1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
|
<?php
/**
* Piwik - Open source web analytics
*
* @link http://piwik.org
* @license http://www.gnu.org/licenses/gpl-3.0.html Gpl v3 or later
* @version $Id$
*
* @category Piwik
* @package Updates
*/
/**
* @package Updates
*/
class Piwik_Updates_0_4_3 implements Piwik_iUpdate
{
static function update()
{
Piwik_Updater::updateDatabase(__FILE__, array(
// 0.1.7 [463]
'ALTER IGNORE TABLE `'. Piwik::prefixTable('log_visit') .'`
CHANGE `location_provider` `location_provider` VARCHAR( 100 ) DEFAULT NULL' => '1054',
// 0.1.7 [470]
'ALTER TABLE `'. Piwik::prefixTable('logger_api_call') .'`
CHANGE `parameter_names_default_values` `parameter_names_default_values` TEXT,
CHANGE `parameter_values` `parameter_values` TEXT,
CHANGE `returned_value` `returned_value` TEXT' => false,
'ALTER TABLE `'. Piwik::prefixTable('logger_error') .'`
CHANGE `message` `message` TEXT' => false,
'ALTER TABLE `'. Piwik::prefixTable('logger_exception') .'`
CHANGE `message` `message` TEXT' => false,
'ALTER TABLE `'. Piwik::prefixTable('logger_message') .'`
CHANGE `message` `message` TEXT' => false,
// 0.2.2 [489]
'ALTER IGNORE TABLE `'. Piwik::prefixTable('site') .'`
CHANGE `feedburnerName` `feedburnerName` VARCHAR( 100 ) DEFAULT NULL' => '1054',
// 0.2.12 [673]
// Note: requires INDEX privilege
'DROP INDEX index_idaction ON `'. Piwik::prefixTable('log_action') .'`' => '1091',
// 0.2.27 [826]
'ALTER IGNORE TABLE `'. Piwik::prefixTable('log_visit') .'`
CHANGE `visit_goal_converted` `visit_goal_converted` TINYINT(1) NOT NULL' => false,
// 0.2.32 [941]
'ALTER TABLE `'. Piwik::prefixTable('access') .'`
CHANGE `login` `login` VARCHAR( 100 ) NOT NULL' => false,
'ALTER TABLE `'. Piwik::prefixTable('user') .'`
CHANGE `login` `login` VARCHAR( 100 ) NOT NULL' => false,
'ALTER TABLE `'. Piwik::prefixTable('user_dashboard') .'`
CHANGE `login` `login` VARCHAR( 100 ) NOT NULL' => '1146',
'ALTER TABLE `'. Piwik::prefixTable('user_language') .'`
CHANGE `login` `login` VARCHAR( 100 ) NOT NULL' => '1146',
// 0.2.33 [1020]
'ALTER TABLE `'. Piwik::prefixTable('user_dashboard') .'`
CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ' => '1146',
'ALTER TABLE `'. Piwik::prefixTable('user_language') .'`
CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci ' => '1146',
// 0.4 [1140]
'ALTER TABLE `'. Piwik::prefixTable('log_visit') .'`
CHANGE `location_ip` `location_ip` BIGINT UNSIGNED NOT NULL' => false,
'ALTER TABLE `'. Piwik::prefixTable('logger_api_call') .'`
CHANGE `caller_ip` `caller_ip` BIGINT UNSIGNED' => false,
));
}
}
|