Database Upgrade Required

# These SQL queries will be executed: 
ALTER TABLE `drvogler_consult_piwik_site_setting` CHANGE `idsite` `idsite` INTEGER(10) UNSIGNED NOT NULL;
ALTER TABLE `drvogler_consult_piwik_plugin_setting` ADD COLUMN `idplugin_setting` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `drvogler_consult_piwik_site_setting` ADD COLUMN `idsite_setting` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `drvogler_consult_piwik_log_profiling` ADD COLUMN `idprofiling` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `drvogler_consult_piwik_access` CHANGE `access` `access` VARCHAR(50) NULL;
ALTER TABLE `drvogler_consult_piwik_access` DROP PRIMARY KEY;
ALTER TABLE `drvogler_consult_piwik_access` ADD COLUMN `idaccess` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `drvogler_consult_piwik_access` ADD INDEX index_loginidsite (`login`, `idsite`);
ALTER TABLE `drvogler_consult_piwik_user` ADD COLUMN `ts_password_modified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;
CREATE TABLE `drvogler_consult_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 `drvogler_consult_piwik_report_subscriptions` ADD UNIQUE KEY unique_token (`token`);
ALTER TABLE `drvogler_consult_piwik_user` CHANGE `ts_password_modified` `ts_password_modified` TIMESTAMP NULL;
UPDATE `drvogler_consult_piwik_user` SET ts_password_modified = NULL;
ALTER TABLE `drvogler_consult_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 `drvogler_consult_piwik_goal` ADD COLUMN `event_value_as_revenue` tinyint(4) NOT NULL default '0';
ALTER TABLE `drvogler_consult_piwik_report` ADD COLUMN `evolution_graph_within_period` TINYINT(4) NOT NULL DEFAULT 0;
ALTER TABLE `drvogler_consult_piwik_report` ADD COLUMN `evolution_graph_period_n` INT(11) NULL;
ALTER TABLE `drvogler_consult_piwik_user` ADD COLUMN `twofactor_secret` VARCHAR(40) NOT NULL DEFAULT '';
CREATE TABLE `drvogler_consult_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 `drvogler_consult_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 `drvogler_consult_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 `drvogler_consult_piwik_brute_force_log` ADD INDEX index_ip_address (`ip_address`);
ALTER TABLE `drvogler_consult_piwik_report` ADD COLUMN `period_param` VARCHAR(10) NULL;

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

# These SQL queries will be executed: 
ALTER TABLE `drvogler_consult_piwik_goal` CHANGE `pattern_type` `pattern_type` varchar(25) NOT NULL;
CREATE TABLE `drvogler_consult_piwik_locks` (`key` VARCHAR(70) NOT NULL, `value` VARCHAR(255) NULL DEFAULT NULL, `expiry_time` BIGINT UNSIGNED DEFAULT 9999999999, PRIMARY KEY ( `key` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;

# These console commands will be run: 
./console plugin:deactivate "ExamplePlugin"
./console plugin:deactivate "ExampleAPI"

# These SQL queries will be executed: 
UPDATE `drvogler_consult_piwik_option` SET option_value = 'https://download.db-ip.com/free/dbip-city-lite-2020-09.mmdb.gz' WHERE option_name = 'geoip2.loc_db_url' AND option_value = 'https://geolite.maxmind.com/download/geoip/database/GeoLite2-City.tar.gz';
UPDATE `drvogler_consult_piwik_option` SET option_value = 'https://download.db-ip.com/free/dbip-country-lite-2020-09.mmdb.gz' WHERE option_name = 'geoip2.loc_db_url' AND option_value = 'https://geolite.maxmind.com/download/geoip/database/GeoLite2-Country.tar.gz';