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
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
|
<?php
/**
* Matomo - free/libre analytics platform
*
* @link https://matomo.org
* @license http://www.gnu.org/licenses/gpl-3.0.html GPL v3 or later
*
*/
namespace Piwik\Updates;
use Piwik\Updater;
use Piwik\Updates as PiwikUpdates;
use Piwik\Updater\Migration;
use Piwik\Updater\Migration\Factory as MigrationFactory;
use Piwik\Common;
use Piwik\DbHelper;
/**
* Update for version 3.6.0-b2
*/
class Updates_3_6_0_b2 extends PiwikUpdates
{
/**
* @var MigrationFactory
*/
private $migration;
private $pluginSettingsTable = 'plugin_setting';
private $siteSettingsTable = 'site_setting';
private $logProfilingTable = 'log_profiling';
public function __construct(MigrationFactory $factory)
{
$this->migration = $factory;
}
/**
* Here you can define one or multiple SQL statements that should be executed during the update.
* @param Updater $updater
* @return Migration[]
*/
public function getMigrations(Updater $updater)
{
$migrations = [];
// in the previous 2.14.0-b2 idsite was added w/ AUTO_INCREMENT, but it should not have been. (note: this
// should have been undone in the 3.0.0-b1 update, but at least one instance out there still has the
// AUTO_INCREMENT modifier).
$migrations[] = $this->migration->db->changeColumn($this->siteSettingsTable, 'idsite', 'idsite', 'INTEGER(10) UNSIGNED NOT NULL');
$migrations = $this->getPluginSettingsMigrations($migrations);
$migrations = $this->getSiteSettingsMigrations($migrations);
$migrations = $this->getLogProfilingMigrations($migrations);
$accessColumns = DbHelper::getTableColumns(Common::prefixTable('access'));
// changes for ACL
$migrations[] = $this->migration->db->changeColumnType('access', 'access', 'VARCHAR(50) NULL');
if (!isset($accessColumns['idaccess'])) {
// the test UpdaterTest::testUpdateWorksAfterPiwikIsAlreadyUpToDate() runs this update on the new DB schema which
// already includes the idaccess column including auto_increment statement. It then fails cause it cannot drop
// the primary key from idaccess as it also has an auto_increment. But in normal case when not executed in that test
// it would remove the primary key (login,idsite). So we ensure to execute this only if the idaccess column not already
// exists
$migrations[] = $this->migration->db->dropPrimaryKey('access');
$migrations[] = $this->migration->db->addColumn('access', 'idaccess', 'INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT');
$migrations[] = $this->migration->db->addIndex('access', array('login', 'idsite'), 'index_loginidsite');
}
// changes for session auth
$migrations[] = $this->migration->db->addColumn('user', 'ts_password_modified',
'TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP');
return $migrations;
}
public function doUpdate(Updater $updater)
{
$updater->executeMigrations(__FILE__, $this->getMigrations($updater));
}
/**
* @param Migration[] $queries
* @return Migration[]
*/
private function getPluginSettingsMigrations($queries)
{
$queries[] = $this->migration->db->addColumn($this->pluginSettingsTable, 'idplugin_setting', 'BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT');
return $queries;
}
/**
* @param Migration[] $queries
* @return Migration[]
*/
private function getSiteSettingsMigrations($queries)
{
$queries[] = $this->migration->db->addColumn($this->siteSettingsTable, 'idsite_setting', 'BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT');
return $queries;
}
/**
* @param Migration[] $queries
* @return Migration[]
*/
private function getLogProfilingMigrations($queries)
{
$queries[] = $this->migration->db->addColumn($this->logProfilingTable, 'idprofiling', 'BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT');
return $queries;
}
}
|
