/[drupal]/contributions/modules/db_maintenance/db_maintenance.module
ViewVC logotype

Diff of /contributions/modules/db_maintenance/db_maintenance.module

Parent Directory Parent Directory | Revision Log Revision Log | View Revision Graph Revision Graph | View Patch Patch

revision 1.14, Sat Aug 22 04:52:39 2009 UTC revision 1.15, Sun Aug 23 01:17:32 2009 UTC
# Line 1  Line 1 
1  <?php  <?php
2  // $Id: db_maintenance.module,v 1.11.2.2 2008/05/28 18:57:38 deekayen Exp $  // $Id: db_maintenance.module,v 1.14 2009/08/22 04:52:39 deekayen Exp $
3    
4  /**  /**
5   * @file   * @file
# Line 130  function db_maintenance_optimize_tables( Line 130  function db_maintenance_optimize_tables(
130          $previous = db_set_active($db);          $previous = db_set_active($db);
131          if (db_table_exists($table_name)) {          if (db_table_exists($table_name)) {
132            // PDO doesn't replace table names with ? or :            // PDO doesn't replace table names with ? or :
133              // db_table_exists and db_escape_table is redundant, but just doing both
134            if ($databases['default']['default']['driver'] == 'mysql') {            if ($databases['default']['default']['driver'] == 'mysql') {
135              db_query(sprintf("OPTIMIZE TABLE %s", $table_name));              db_query(sprintf("OPTIMIZE TABLE %s", db_escape_table($table_name)));
136            }            }
137            elseif ($databases['default']['default']['driver'] == 'pgsql') {            elseif ($databases['default']['default']['driver'] == 'pgsql') {
138              db_query(sprintf("VACUUM ANALYZE %s", $table_name));              db_query(sprintf("VACUUM ANALYZE %s", db_escape_table($table_name)));
139            }            }
140          }          }
141          else {          else {
Legend:
Removed from v.1.14  
changed lines
  Added in v.1.15
  ViewVC Help
Powered by ViewVC 1.1.2