diff options
Diffstat (limited to 'core/Updates/1.6-b1.php')
-rw-r--r-- | core/Updates/1.6-b1.php | 32 |
1 files changed, 16 insertions, 16 deletions
diff --git a/core/Updates/1.6-b1.php b/core/Updates/1.6-b1.php index edaadabfa3..57e1deb889 100644 --- a/core/Updates/1.6-b1.php +++ b/core/Updates/1.6-b1.php @@ -14,15 +14,15 @@ */ class Piwik_Updates_1_6_b1 extends Piwik_Updates { - static function getSql($schema = 'Myisam') - { - return array( - 'ALTER TABLE `'. Piwik_Common::prefixTable('log_conversion_item') .'` + static function getSql($schema = 'Myisam') + { + return array( + 'ALTER TABLE `' . Piwik_Common::prefixTable('log_conversion_item') . '` ADD idaction_category2 INTEGER(10) UNSIGNED NOT NULL AFTER idaction_category, ADD idaction_category3 INTEGER(10) UNSIGNED NOT NULL, ADD idaction_category4 INTEGER(10) UNSIGNED NOT NULL, - ADD idaction_category5 INTEGER(10) UNSIGNED NOT NULL' => false, - 'ALTER TABLE `'. Piwik_Common::prefixTable('log_visit') .'` + ADD idaction_category5 INTEGER(10) UNSIGNED NOT NULL' => false, + 'ALTER TABLE `' . Piwik_Common::prefixTable('log_visit') . '` CHANGE custom_var_k1 custom_var_k1 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v1 custom_var_v1 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_k2 custom_var_k2 VARCHAR(200) DEFAULT NULL, @@ -32,8 +32,8 @@ class Piwik_Updates_1_6_b1 extends Piwik_Updates CHANGE custom_var_k4 custom_var_k4 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v4 custom_var_v4 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_k5 custom_var_k5 VARCHAR(200) DEFAULT NULL, - CHANGE custom_var_v5 custom_var_v5 VARCHAR(200) DEFAULT NULL' => false, - 'ALTER TABLE `'. Piwik_Common::prefixTable('log_conversion') .'` + CHANGE custom_var_v5 custom_var_v5 VARCHAR(200) DEFAULT NULL' => false, + 'ALTER TABLE `' . Piwik_Common::prefixTable('log_conversion') . '` CHANGE custom_var_k1 custom_var_k1 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v1 custom_var_v1 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_k2 custom_var_k2 VARCHAR(200) DEFAULT NULL, @@ -43,8 +43,8 @@ class Piwik_Updates_1_6_b1 extends Piwik_Updates CHANGE custom_var_k4 custom_var_k4 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v4 custom_var_v4 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_k5 custom_var_k5 VARCHAR(200) DEFAULT NULL, - CHANGE custom_var_v5 custom_var_v5 VARCHAR(200) DEFAULT NULL' => false, - 'ALTER TABLE `'. Piwik_Common::prefixTable('log_link_visit_action') .'` + CHANGE custom_var_v5 custom_var_v5 VARCHAR(200) DEFAULT NULL' => false, + 'ALTER TABLE `' . Piwik_Common::prefixTable('log_link_visit_action') . '` CHANGE custom_var_k1 custom_var_k1 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v1 custom_var_v1 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_k2 custom_var_k2 VARCHAR(200) DEFAULT NULL, @@ -55,11 +55,11 @@ class Piwik_Updates_1_6_b1 extends Piwik_Updates CHANGE custom_var_v4 custom_var_v4 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_k5 custom_var_k5 VARCHAR(200) DEFAULT NULL, CHANGE custom_var_v5 custom_var_v5 VARCHAR(200) DEFAULT NULL' => false, - ); - } + ); + } - static function update() - { - Piwik_Updater::updateDatabase(__FILE__, self::getSql()); - } + static function update() + { + Piwik_Updater::updateDatabase(__FILE__, self::getSql()); + } } |