Matomo › Update

Matomo database will be upgraded from version 4.0.1-b1 to the new version 5.0.1.

The following plugins will be updated: Goals.

The following dimensions will be updated: log_conversion.pageviews_before, log_link_visit_action.idaction_product_cat, log_link_visit_action.idaction_product_cat2, log_link_visit_action.idaction_product_cat3, log_link_visit_action.idaction_product_cat4, log_link_visit_action.idaction_product_cat5, log_link_visit_action.idaction_product_name, log_link_visit_action.idaction_product_sku, log_link_visit_action.idpageview, log_link_visit_action.product_price, log_link_visit_action.time_spent_ref_action, log_visit.config_browser_engine, log_visit.config_browser_name, log_visit.config_browser_version, log_visit.config_client_type, log_visit.config_cookie, log_visit.config_device_brand, log_visit.config_device_model, log_visit.config_device_type, log_visit.config_flash, log_visit.config_java, log_visit.config_os, log_visit.config_pdf, log_visit.config_quicktime, log_visit.config_realplayer, log_visit.config_resolution, log_visit.config_silverlight, log_visit.config_windowsmedia, log_visit.location_browser_lang, log_visit.location_country, log_visit.location_latitude, log_visit.location_longitude, log_visit.location_region, log_visit.referer_name, log_visit.referer_url, log_visit.visit_entry_idaction_name, log_visit.visit_entry_idaction_url, log_visit.visit_exit_idaction_name, log_visit.visit_exit_idaction_url, log_visit.visit_goal_buyer, log_visit.visit_goal_converted, log_visit.visit_total_actions, log_visit.visit_total_events, log_visit.visit_total_interactions, log_visit.visit_total_searches, log_visit.visit_total_time, log_visit.visitor_count_visits, log_visit.visitor_localtime, log_visit.visitor_returning.

Important notes for large Matomo installations

If you have a large Matomo database, updates might take too long to run in the browser. In this situation, you can execute the updates from your command line:

php /home/bradzio/domains/bhp-nos.pl/public_html/piwik/console core:update

If you manage a high traffic Matomo server, we recommend to momentarily disable visitor Tracking and put the Matomo User Interface in maintenance mode.

FYI: these are the SQL queries and console commands that will be executed to upgrade your database to Matomo 5.0.1

› Click here to view and copy the list of SQL queries and console commands that will get executed

# These console commands will be run: 
./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 `piwi_archive_numeric_2013_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2013_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2013_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2013_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2013_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2013_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2013_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2013_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2013_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2013_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2013_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2014_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2014_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2014_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2014_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2014_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2014_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2014_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2014_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2014_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2014_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2014_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2014_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2015_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2015_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2015_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2015_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2015_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2015_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2015_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2015_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2015_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2015_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2015_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2015_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2016_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2016_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2016_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2016_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2016_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2016_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2016_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2016_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2016_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2016_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2017_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2017_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2017_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2017_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2017_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2017_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2017_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2017_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2017_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2017_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2018_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2018_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2018_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2018_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2018_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2018_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2018_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2018_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2018_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2018_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2018_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2018_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2019_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2019_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2019_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2019_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2019_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2019_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2019_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2019_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2019_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2019_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2019_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2019_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2021_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2021_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2023_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwi_archive_numeric_2024_01` SET `name` = 'done' WHERE `name` = 'done.';
ALTER TABLE `piwi_segment` ADD COLUMN `hash` CHAR(32) NULL AFTER `definition`;
UPDATE `piwi_segment` SET `hash` = '4578744398d6a1ac38bb7532c75cc989' WHERE `idsegment` = '1';
UPDATE `piwi_segment` SET `hash` = '4578744398d6a1ac38bb7532c75cc989' WHERE `idsegment` = '2';
UPDATE `piwi_segment` SET `hash` = 'c0138155e56c77838af19d30e510c63c' WHERE `idsegment` = '3';
ALTER TABLE `piwi_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 `piwi_session` CHANGE `data` `data` MEDIUMTEXT;

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

# These SQL queries will be executed: 
ALTER TABLE `piwi_user` ADD COLUMN `idchange_last_viewed` INTEGER UNSIGNED NULL;
CREATE TABLE `piwi_changes` (`idchange` INT(11) NOT NULL AUTO_INCREMENT, `created_time` DATETIME NOT NULL, `plugin_name` VARCHAR(255) NOT NULL, `version` VARCHAR(20) NOT NULL, `title` VARCHAR(255) NOT NULL, `description` TEXT NOT NULL, `link_name` VARCHAR(255) NULL, `link` VARCHAR(255) NULL, PRIMARY KEY ( `idchange` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwi_changes` CHANGE `plugin_name` `plugin_name` VARCHAR(60) NOT NULL;
ALTER TABLE `piwi_changes` DROP INDEX `unique_plugin_version_title`;
ALTER TABLE `piwi_changes` ADD UNIQUE KEY unique_plugin_version_title (`plugin_name`, `version`, `title` (100));
ALTER TABLE `piwi_user` ADD COLUMN `invite_status` ENUM('accept','pending','decline','expired') DEFAULT 'accept';
ALTER TABLE `piwi_user` DROP COLUMN `invite_status`;
ALTER TABLE `piwi_user` ADD COLUMN `invite_token` VARCHAR(191) DEFAULT null;
ALTER TABLE `piwi_user` ADD COLUMN `invited_by` VARCHAR(100) DEFAULT null;
ALTER TABLE `piwi_user` ADD COLUMN `invite_expired_at` TIMESTAMP null DEFAULT null;
ALTER TABLE `piwi_user` ADD COLUMN `invite_accept_at` TIMESTAMP null DEFAULT null;
ALTER TABLE `piwi_site` ADD COLUMN `excluded_referrers` TEXT NOT NULL AFTER `excluded_user_agents`;
ALTER TABLE `piwi_user` ADD UNIQUE KEY uniq_email (`email`);
ALTER TABLE `piwi_user` ADD COLUMN `invite_link_token` VARCHAR(191) DEFAULT null;
DELETE FROM `piwi_archive_numeric_2013_01` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2013_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2013_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2013_03` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2013_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2013_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2013_04` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2013_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2013_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2013_05` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2013_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2013_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2013_06` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2013_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2013_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2013_07` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2013_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2013_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2013_08` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2013_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2013_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2013_09` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2013_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2013_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2013_10` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2013_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2013_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2013_11` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2013_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2013_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2013_12` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2013_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2013_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2014_01` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2014_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2014_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2014_02` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2014_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2014_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2014_03` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2014_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2014_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2014_04` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2014_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2014_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2014_05` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2014_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2014_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2014_06` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2014_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2014_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2014_07` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2014_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2014_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2014_08` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2014_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2014_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2014_09` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2014_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2014_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2014_10` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2014_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2014_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2014_11` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2014_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2014_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2014_12` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2014_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2014_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2015_01` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2015_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2015_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2015_02` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2015_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2015_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2015_03` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2015_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2015_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2015_04` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2015_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2015_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2015_05` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2015_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2015_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2015_06` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2015_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2015_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2015_07` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2015_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2015_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2015_08` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2015_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2015_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2015_09` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2015_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2015_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2015_10` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2015_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2015_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2015_11` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2015_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2015_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2015_12` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2015_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2015_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2016_01` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2016_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2016_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2016_02` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2016_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2016_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2016_03` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2016_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2016_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2016_04` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2016_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2016_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2016_07` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2016_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2016_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2016_08` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2016_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2016_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2016_09` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2016_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2016_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2016_10` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2016_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2016_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2016_11` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2016_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2016_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2016_12` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2016_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2016_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2017_01` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2017_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2017_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2017_04` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2017_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2017_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2017_05` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2017_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2017_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2017_06` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2017_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2017_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2017_07` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2017_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2017_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2017_08` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2017_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2017_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2017_09` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2017_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2017_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2017_10` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2017_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2017_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2017_11` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2017_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2017_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2017_12` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2017_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2017_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2018_01` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2018_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2018_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2018_02` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2018_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2018_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2018_03` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2018_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2018_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2018_04` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2018_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2018_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2018_05` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2018_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2018_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2018_06` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2018_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2018_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2018_07` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2018_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2018_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2018_08` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2018_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2018_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2018_09` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2018_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2018_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2018_10` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2018_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2018_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2018_11` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2018_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2018_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2018_12` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2018_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2018_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2019_01` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2019_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2019_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2019_02` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2019_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2019_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2019_03` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2019_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2019_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2019_04` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2019_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2019_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2019_05` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2019_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2019_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2019_06` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2019_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2019_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2019_07` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2019_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2019_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2019_08` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2019_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2019_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2019_09` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2019_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2019_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2019_10` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2019_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2019_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2019_11` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2019_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2019_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2019_12` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2019_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2019_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2021_09` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2021_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2021_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2021_10` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2021_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2021_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2023_12` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2023_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2023_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `piwi_archive_numeric_2024_01` WHERE ts_archived is null;
ALTER TABLE `piwi_archive_numeric_2024_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `piwi_archive_numeric_2024_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
ALTER TABLE `piwi_user_token_auth` ADD COLUMN `post_only` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `piwi_log_conversion` ADD COLUMN `pageviews_before` SMALLINT UNSIGNED DEFAULT NULL;

# These console commands will be run: 
./console core:calculate-conversion-pages --dates=yesterday,today

# These SQL queries will be executed: 
ALTER TABLE `piwi_log_visit` ADD INDEX `index_idsite_idvisitor_time` (`idsite`, `idvisitor`, `visit_last_action_time`);
ALTER TABLE `piwi_log_visit` DROP INDEX `index_idsite_idvisitor`;

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

# These SQL queries will be executed: 
ALTER TABLE `piwi_user_token_auth` CHANGE `post_only` `secure_only` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `piwi_user` ADD COLUMN `ts_changes_shown` TIMESTAMP NULL;
ALTER TABLE `piwi_goal` ADD COLUMN `description` VARCHAR(255) NOT NULL DEFAULT '' AFTER `name`;
ALTER TABLE `piwi_log_visit` MODIFY COLUMN `visit_goal_buyer` TINYINT(1) NULL, MODIFY COLUMN `visit_goal_converted` TINYINT(1) NULL, MODIFY COLUMN `visitor_returning` TINYINT(1) NULL, MODIFY COLUMN `visitor_count_visits` INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN `visit_entry_idaction_name` INTEGER(10) UNSIGNED NULL, MODIFY COLUMN `visit_entry_idaction_url` INTEGER(11) UNSIGNED NULL  DEFAULT NULL, MODIFY COLUMN `visit_exit_idaction_name` INTEGER(10) UNSIGNED NULL, MODIFY COLUMN `visit_exit_idaction_url` INTEGER(10) UNSIGNED NULL DEFAULT 0, MODIFY COLUMN `visit_total_actions` INT(11) UNSIGNED NULL, ADD COLUMN `visit_total_interactions` MEDIUMINT UNSIGNED DEFAULT 0, MODIFY COLUMN `visit_total_searches` SMALLINT(5) UNSIGNED NULL, MODIFY COLUMN `referer_name` VARCHAR(255) NULL, MODIFY COLUMN `referer_url` VARCHAR(1500) NULL, MODIFY COLUMN `location_browser_lang` VARCHAR(20) NULL, MODIFY COLUMN `config_browser_engine` VARCHAR(10) NULL, MODIFY COLUMN `config_browser_name` VARCHAR(40) NULL, MODIFY COLUMN `config_browser_version` VARCHAR(20) NULL, ADD COLUMN `config_client_type` TINYINT( 1 ) NULL DEFAULT NULL, MODIFY COLUMN `config_device_brand` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, MODIFY COLUMN `config_device_model` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, MODIFY COLUMN `config_device_type` TINYINT( 100 ) NULL DEFAULT NULL, MODIFY COLUMN `config_os` CHAR(3) NULL, MODIFY COLUMN `visit_total_events` INT(11) UNSIGNED NULL, MODIFY COLUMN `visitor_localtime` TIME NULL, MODIFY COLUMN `config_resolution` VARCHAR(18) NULL, MODIFY COLUMN `config_cookie` TINYINT(1) NULL, MODIFY COLUMN `config_flash` TINYINT(1) NULL, MODIFY COLUMN `config_java` TINYINT(1) NULL, MODIFY COLUMN `config_pdf` TINYINT(1) NULL, MODIFY COLUMN `config_quicktime` TINYINT(1) NULL, MODIFY COLUMN `config_realplayer` TINYINT(1) NULL, MODIFY COLUMN `config_silverlight` TINYINT(1) NULL, MODIFY COLUMN `config_windowsmedia` TINYINT(1) NULL, MODIFY COLUMN `visit_total_time` INT(11) UNSIGNED NOT NULL, MODIFY COLUMN `location_country` CHAR(3) NULL, MODIFY COLUMN `location_latitude` decimal(9, 6) DEFAULT NULL, MODIFY COLUMN `location_longitude` decimal(9, 6) DEFAULT NULL, MODIFY COLUMN `location_region` char(3) DEFAULT NULL;
ALTER TABLE `piwi_log_conversion` MODIFY COLUMN `visitor_returning` TINYINT(1) NULL, 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, ADD COLUMN `config_device_brand` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, ADD COLUMN `config_device_model` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, ADD COLUMN `config_device_type` TINYINT( 100 ) NULL DEFAULT NULL, MODIFY COLUMN `location_country` CHAR(3) NULL, MODIFY COLUMN `location_latitude` decimal(9, 6) DEFAULT NULL, MODIFY COLUMN `location_longitude` decimal(9, 6) DEFAULT NULL, MODIFY COLUMN `location_region` char(3) DEFAULT NULL, ADD COLUMN `pageviews_before` SMALLINT UNSIGNED DEFAULT NULL;
ALTER TABLE `piwi_log_link_visit_action` ADD COLUMN `idpageview` CHAR(6) NULL DEFAULT NULL, MODIFY COLUMN `time_spent_ref_action` INTEGER(10) UNSIGNED NULL, 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;

Need help upgrading Matomo?

If you need support to upgrade your Matomo, the creators of Matomo are here to help you make the Matomo upgrade a success and provide all instructions, best practises and ongoing support. Contact the Matomo experts to get started upgrading your Matomo safely.

Ready to go?

The database upgrade process may take a while, so please be patient.

Database Upgrade Required

Important notes for large Matomo installations

Need help upgrading Matomo?

Ready to go?