diff options
Diffstat (limited to 'core/Updates/0.5.5.php')
-rw-r--r-- | core/Updates/0.5.5.php | 47 |
1 files changed, 22 insertions, 25 deletions
diff --git a/core/Updates/0.5.5.php b/core/Updates/0.5.5.php index d0d4225ae5..a2db73c613 100644 --- a/core/Updates/0.5.5.php +++ b/core/Updates/0.5.5.php @@ -14,32 +14,29 @@ */ class Piwik_Updates_0_5_5 extends Piwik_Updates { - static function getSql($schema = 'Myisam') - { - $sqlarray = array( - 'DROP INDEX index_idsite_date ON ' . Piwik_Common::prefixTable('log_visit') => '1091', - 'CREATE INDEX index_idsite_date_config ON ' . Piwik_Common::prefixTable('log_visit') . ' (idsite, visit_server_date, config_md5config(8))' => '1061', - ); + static function getSql($schema = 'Myisam') + { + $sqlarray = array( + 'DROP INDEX index_idsite_date ON ' . Piwik_Common::prefixTable('log_visit') => '1091', + 'CREATE INDEX index_idsite_date_config ON ' . Piwik_Common::prefixTable('log_visit') . ' (idsite, visit_server_date, config_md5config(8))' => '1061', + ); - $tables = Piwik::getTablesInstalled(); - foreach($tables as $tableName) - { - if(preg_match('/archive_/', $tableName) == 1) - { - $sqlarray[ 'DROP INDEX index_all ON '. $tableName ] = '1091'; - } - if(preg_match('/archive_numeric_/', $tableName) == 1) - { - $sqlarray[ 'CREATE INDEX index_idsite_dates_period ON '. $tableName .' (idsite, date1, date2, period)' ] = '1061'; - } - } + $tables = Piwik::getTablesInstalled(); + foreach ($tables as $tableName) { + if (preg_match('/archive_/', $tableName) == 1) { + $sqlarray['DROP INDEX index_all ON ' . $tableName] = '1091'; + } + if (preg_match('/archive_numeric_/', $tableName) == 1) { + $sqlarray['CREATE INDEX index_idsite_dates_period ON ' . $tableName . ' (idsite, date1, date2, period)'] = '1061'; + } + } - return $sqlarray; - } + return $sqlarray; + } - static function update() - { - Piwik_Updater::updateDatabase(__FILE__, self::getSql()); - - } + static function update() + { + Piwik_Updater::updateDatabase(__FILE__, self::getSql()); + + } } |