Database Upgrade Required

# These SQL queries will be executed: 
CREATE TABLE `piwiksuz_privacy_logdata_anonymizations` (`idlogdata_anonymization` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `idsites` TEXT NULL DEFAULT NULL, `date_start` DATETIME NOT NULL, `date_end` DATETIME NOT NULL, `anonymize_ip` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `anonymize_location` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `anonymize_userid` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `unset_visit_columns` TEXT NOT NULL DEFAULT '', `unset_link_visit_action_columns` TEXT NOT NULL DEFAULT '', `output` MEDIUMTEXT NULL DEFAULT NULL, `scheduled_date` DATETIME NULL, `job_start_date` DATETIME NULL, `job_finish_date` DATETIME NULL, `requester` VARCHAR(100) NOT NULL DEFAULT '', PRIMARY KEY ( `idlogdata_anonymization` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwiksuz_privacy_logdata_anonymizations` ADD INDEX index_job_start_date (`job_start_date`);
ALTER TABLE `piwiksuz_plugin_setting` ADD COLUMN `json_encoded` TINYINT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `piwiksuz_site_setting` ADD COLUMN `json_encoded` TINYINT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `piwiksuz_site_setting` CHANGE `idsite` `idsite` INTEGER(10) UNSIGNED NOT NULL;
ALTER TABLE `piwiksuz_plugin_setting` ADD COLUMN `idplugin_setting` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `piwiksuz_site_setting` ADD COLUMN `idsite_setting` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `piwiksuz_log_profiling` ADD COLUMN `idprofiling` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `piwiksuz_access` CHANGE `access` `access` VARCHAR(50) NULL;
ALTER TABLE `piwiksuz_access` DROP PRIMARY KEY;
ALTER TABLE `piwiksuz_access` ADD COLUMN `idaccess` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `piwiksuz_access` ADD INDEX index_loginidsite (`login`, `idsite`);
ALTER TABLE `piwiksuz_user` ADD COLUMN `ts_password_modified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;
CREATE TABLE `piwiksuz_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 `piwiksuz_report_subscriptions` ADD UNIQUE KEY unique_token (`token`);
ALTER TABLE `piwiksuz_user` CHANGE `ts_password_modified` `ts_password_modified` TIMESTAMP NULL;
UPDATE `piwiksuz_user` SET ts_password_modified = NULL;
ALTER TABLE `piwiksuz_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 `piwiksuz_goal` ADD COLUMN `event_value_as_revenue` tinyint(4) NOT NULL default '0';
ALTER TABLE `piwiksuz_report` ADD COLUMN `evolution_graph_within_period` TINYINT(4) NOT NULL DEFAULT 0;
ALTER TABLE `piwiksuz_report` ADD COLUMN `evolution_graph_period_n` INT(11) NULL;
ALTER TABLE `piwiksuz_user` ADD COLUMN `twofactor_secret` VARCHAR(40) NOT NULL DEFAULT '';
CREATE TABLE `piwiksuz_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 `piwiksuz_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 `piwiksuz_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 `piwiksuz_brute_force_log` ADD INDEX index_ip_address (`ip_address`);
ALTER TABLE `piwiksuz_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 `piwiksuz_goal` CHANGE `pattern_type` `pattern_type` varchar(25) NOT NULL;
CREATE TABLE `piwiksuz_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 `piwiksuz_option` SET option_value = 'https://download.db-ip.com/free/dbip-city-lite-2024-11.mmdb.gz' WHERE option_name = 'geoip2.loc_db_url' AND option_value = 'https://geolite.maxmind.com/download/geoip/database/GeoLite2-City.tar.gz';
UPDATE `piwiksuz_option` SET option_value = 'https://download.db-ip.com/free/dbip-country-lite-2024-11.mmdb.gz' WHERE option_name = 'geoip2.loc_db_url' AND option_value = 'https://geolite.maxmind.com/download/geoip/database/GeoLite2-Country.tar.gz';
ALTER TABLE `piwiksuz_log_visit` MODIFY COLUMN `location_region` char(3) DEFAULT NULL;
ALTER TABLE `piwiksuz_log_conversion` MODIFY COLUMN `location_region` char(3) DEFAULT NULL;