diff options
Diffstat (limited to 'core/Updates/0.2.27.php')
-rw-r--r-- | core/Updates/0.2.27.php | 20 |
1 files changed, 15 insertions, 5 deletions
diff --git a/core/Updates/0.2.27.php b/core/Updates/0.2.27.php index 3424216245..57cf3465d6 100644 --- a/core/Updates/0.2.27.php +++ b/core/Updates/0.2.27.php @@ -13,12 +13,17 @@ /** * @package Updates */ -class Piwik_Updates_0_2_27 implements Piwik_iUpdate +class Piwik_Updates_0_2_27 extends Piwik_Updates { - static function update() + static function getSql($adapter = 'PDO_MYSQL') { - $sqlarray[ 'ALTER TABLE `'. Piwik::prefixTable('log_visit') .'` - ADD `visit_goal_converted` VARCHAR( 1 ) NOT NULL AFTER `visit_total_time`' ] = false; + $sqlarray = array( + 'ALTER TABLE `'. Piwik_Common::prefixTable('log_visit') .'` + ADD `visit_goal_converted` VARCHAR( 1 ) NOT NULL AFTER `visit_total_time`' => false, + // 0.2.27 [826] + 'ALTER IGNORE TABLE `'. Piwik_Common::prefixTable('log_visit') .'` + CHANGE `visit_goal_converted` `visit_goal_converted` TINYINT(1) NOT NULL' => false, + ); $tables = Piwik::getTablesCreateSql(); $sqlarray[ $tables['log_conversion'] ] = false; @@ -33,6 +38,11 @@ class Piwik_Updates_0_2_27 implements Piwik_iUpdate } } - Piwik_Updater::updateDatabase(__FILE__, $sqlarray); + return $sqlarray; + } + + static function update() + { + Piwik_Updater::updateDatabase(__FILE__, self::getSql()); } } |