Database Upgrade Required

# These SQL queries will be executed: 
UPDATE piwikvrmd_user_token_auth SET hash_algo = "sha512" where hash_algo is null or hash_algo = "" ;

# These console commands will be run: 
./console plugin:uninstall "ExampleTheme"
./console plugin:deactivate "ExamplePlugin"
./console plugin:deactivate "ExampleLogTables"
./console plugin:deactivate "ExampleUI"
./console plugin:deactivate "ExampleReport"
./console plugin:deactivate "ExampleAPI"
./console plugin:deactivate "ExampleCommand"
./console plugin:deactivate "ExampleSettingsPlugin"
./console plugin:deactivate "ExampleTracker"
./console plugin:deactivate "ExampleVisualization"
./console plugin:uninstall "ExamplePlugin"
./console plugin:uninstall "ExampleLogTables"
./console plugin:uninstall "ExampleUI"
./console plugin:uninstall "ExampleReport"
./console plugin:uninstall "ExampleAPI"
./console plugin:uninstall "ExampleCommand"
./console plugin:uninstall "ExampleSettingsPlugin"
./console plugin:uninstall "ExampleTracker"
./console plugin:uninstall "ExampleVisualization"

# These SQL queries will be executed: 
UPDATE `piwikvrmd_archive_numeric_2008_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2015_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2015_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2015_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2015_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2015_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2015_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2015_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2015_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2015_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2016_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2016_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2016_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2016_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2016_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2016_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2016_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2016_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2016_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2016_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2016_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2016_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2017_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2017_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2017_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2017_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2017_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2017_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2017_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2017_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2017_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2017_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2017_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2017_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2018_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2018_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2018_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2018_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2018_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2018_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2021_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwikvrmd_archive_numeric_2021_12` SET `name` = 'done' WHERE `name` = 'done.';
ALTER TABLE `piwikvrmd_segment` ADD COLUMN `hash` CHAR(32) NULL AFTER `definition`;
ALTER TABLE `piwikvrmd_brute_force_log` ADD COLUMN `login` VARCHAR(100) NULL;

# These console commands will be run: 
./console config:set --section="General" --key="login_allow_logme" --value="1"

# These SQL queries will be executed: 
ALTER TABLE `piwikvrmd_session` CHANGE `data` `data` MEDIUMTEXT;

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

# These SQL queries will be executed: 
ALTER TABLE `piwikvrmd_log_visit` MODIFY COLUMN `visitor_count_visits` INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN `visit_total_interactions` MEDIUMINT UNSIGNED DEFAULT 0, MODIFY COLUMN `referer_name` VARCHAR(255) NULL, MODIFY COLUMN `referer_url` VARCHAR(1500) NULL, MODIFY COLUMN `config_browser_name` VARCHAR(40) NULL, ADD COLUMN `config_client_type` TINYINT( 1 ) NULL DEFAULT NULL, MODIFY COLUMN `location_region` char(3) DEFAULT NULL;
ALTER TABLE `piwikvrmd_log_conversion` MODIFY COLUMN `visitor_count_visits` INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN `referer_name` VARCHAR(255) NULL, ADD COLUMN `config_browser_name` VARCHAR(40) NULL, ADD COLUMN `config_client_type` TINYINT( 1 ) NULL DEFAULT NULL, MODIFY COLUMN `location_region` char(3) DEFAULT NULL;
ALTER TABLE `piwikvrmd_log_link_visit_action` ADD COLUMN `idaction_product_cat` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat2` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat3` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat4` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat5` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_name` INT(10) UNSIGNED NULL, ADD COLUMN `product_price` DOUBLE NULL, ADD COLUMN `idaction_product_sku` INT(10) UNSIGNED NULL;