Database Upgrade Required

# These SQL queries will be executed: 
ALTER TABLE `piwik_site_setting` CHANGE `idsite` `idsite` INTEGER(10) UNSIGNED NOT NULL;
ALTER TABLE `piwik_plugin_setting` ADD COLUMN `idplugin_setting` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `piwik_site_setting` ADD COLUMN `idsite_setting` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `piwik_log_profiling` ADD COLUMN `idprofiling` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `piwik_access` CHANGE `access` `access` VARCHAR(50) NULL;
ALTER TABLE `piwik_access` DROP PRIMARY KEY;
ALTER TABLE `piwik_access` ADD COLUMN `idaccess` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `piwik_access` ADD INDEX index_loginidsite (`login`, `idsite`);
ALTER TABLE `piwik_user` ADD COLUMN `ts_password_modified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;
CREATE TABLE `piwik_report_subscriptions` (`idreport` INT(11) NOT NULL, `token`  VARCHAR(100) NULL, `email` VARCHAR(100) NOT NULL, `ts_subscribed` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `ts_unsubscribed` TIMESTAMP NULL, PRIMARY KEY ( `idreport`, `email` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_report_subscriptions` ADD UNIQUE KEY unique_token (`token`);
ALTER TABLE `piwik_user` CHANGE `ts_password_modified` `ts_password_modified` TIMESTAMP NULL;
UPDATE `piwik_user` SET ts_password_modified = NULL;
ALTER TABLE `piwik_site` ADD COLUMN `creator_login`  VARCHAR(100) NULL;

# These console commands will be run: 
./console plugin:activate "IntranetMeasurable"

# These SQL queries will be executed: 
ALTER TABLE `piwik_goal` ADD COLUMN `event_value_as_revenue` tinyint(4) NOT NULL default '0';
ALTER TABLE `piwik_report` ADD COLUMN `evolution_graph_within_period` TINYINT(4) NOT NULL DEFAULT 0;
ALTER TABLE `piwik_report` ADD COLUMN `evolution_graph_period_n` INT(11) NULL;
ALTER TABLE `piwik_user` ADD COLUMN `twofactor_secret` VARCHAR(40) NOT NULL DEFAULT '';
CREATE TABLE `piwik_twofactor_recovery_code` (`idrecoverycode` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `login` VARCHAR(100) NOT NULL, `recovery_code` VARCHAR(40) NOT NULL, PRIMARY KEY ( `idrecoverycode` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;

# These console commands will be run: 
./console plugin:activate "TwoFactorAuth"
./console plugin:deactivate "GoogleAuthenticator"

# These SQL queries will be executed: 
CREATE TABLE `piwik_tracking_failure` (`idsite` BIGINT(20) UNSIGNED NOT NULL, `idfailure` SMALLINT UNSIGNED NOT NULL, `date_first_occurred` DATETIME NOT NULL, `request_url` MEDIUMTEXT NOT NULL, PRIMARY KEY ( `idsite`, `idfailure` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `piwik_brute_force_log` (`id_brute_force_log` bigint(11) NOT NULL AUTO_INCREMENT, `ip_address` VARCHAR(60) DEFAULT NULL, `attempted_at` datetime NOT NULL, PRIMARY KEY ( `id_brute_force_log` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_brute_force_log` ADD INDEX index_ip_address (`ip_address`);
ALTER TABLE `piwik_report` ADD COLUMN `period_param` VARCHAR(10) NULL;

# These console commands will be run: 
./console plugin:activate "Tour"