diff options
| author | robocoder <anthon.pang@gmail.com> | 2011-03-31 16:24:39 +0400 |
|---|---|---|
| committer | robocoder <anthon.pang@gmail.com> | 2011-03-31 16:24:39 +0400 |
| commit | 385683d8c20f360dd86a3a6c95a15db3e0ca9b26 (patch) | |
| tree | 0b5649702fe3ba75bd0f1d31ba43eaa40f066911 /core/Updates/1.2.3.php | |
| parent | 679a2d841c153e657d86275382afc01dbbe95e7b (diff) | |
refs #2243 - set database's default charset explicitly
git-svn-id: http://dev.piwik.org/svn/trunk@4263 59fd770c-687e-43c8-a1e3-f5a4ff64c105
Diffstat (limited to 'core/Updates/1.2.3.php')
| -rw-r--r-- | core/Updates/1.2.3.php | 5 |
1 files changed, 4 insertions, 1 deletions
diff --git a/core/Updates/1.2.3.php b/core/Updates/1.2.3.php index c41434de4b..d58754ebfb 100644 --- a/core/Updates/1.2.3.php +++ b/core/Updates/1.2.3.php @@ -18,8 +18,11 @@ class Piwik_Updates_1_2_3 extends Piwik_Updates static function getSql($schema = 'Myisam') { return array( + // LOAD DATA INFILE uses the database's charset + 'ALTER DATABASE '. Zend_Registry::get('config')->database->dbname .' DEFAULT CHARACTER SET utf8' => false, + // Various performance improvements schema updates - 'ALTER TABLE `'. Piwik_Common::prefixTable('log_visit') .'` + 'ALTER TABLE `'. Piwik_Common::prefixTable('log_visit') .'` DROP INDEX index_idsite_datetime_config, DROP INDEX index_idsite_idvisit, ADD INDEX index_idsite_config_datetime (idsite, config_id, visit_last_action_time), |