Matomo › Update

Matomo database will be upgraded from version 2.1.0 to the new version 3.14.1.

The following plugins will be updated: LanguagesManager, Goals, Provider.

The following dimensions will be updated: log_link_visit_action.idpageview, log_link_visit_action.interaction_position, log_link_visit_action.time_spent_ref_action, log_visit.location_country, log_visit.location_latitude, log_visit.location_longitude, log_visit.referer_url, log_visit.user_id, 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_days_since_first, log_visit.visitor_days_since_last, log_visit.visitor_days_since_order, log_visit.visitor_localtime, log_visit.visitor_returning.

Important notes for large Matomo installations

This is a major update! It will take longer than usual. The following advice is especially important for large 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 /www/htdocs/w00acce1/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 3.14.1

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

# These SQL queries will be executed: 
ALTER TABLE `piwik_session` CHANGE `id` `id` VARCHAR( 255 ) NOT NULL;
ALTER TABLE `piwik_log_visit` ADD COLUMN `config_browser_engine` VARCHAR(10) NOT NULL;
UPDATE piwik_log_visit SET `config_browser_engine` = IF (`config_browser_name` IN ('OP'), 'Presto', IF (`config_browser_name` IN ('SF','CH','OW','AR','EP','FL','WO','AB','IR','CS','FD','HA','MI','GE','DF','BB','BP','TI','CF','RK','B2','NF'), 'WebKit', IF (`config_browser_name` IN ('KO'), 'KHTML', IF (`config_browser_name` IN ('NS','PX','FF','FB','CA','GA','KM','MO','SM','CO','FE','KP','KZ','TB'), 'Gecko', IF (`config_browser_name` IN ('IE'), 'Trident', '')))));
UPDATE IGNORE piwik_archive_blob_2009_01 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2009_02 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2009_03 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2009_04 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2009_05 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2009_06 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2009_07 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2009_08 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2009_11 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2009_12 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2010_01 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2010_02 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2010_03 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2010_04 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2010_05 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2010_06 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2010_07 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2010_08 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2010_09 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2010_10 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2010_11 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2010_12 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2011_01 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2011_02 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2011_03 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2011_04 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2011_05 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2011_06 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2011_07 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2011_08 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2011_09 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2011_10 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2011_11 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2011_12 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_01 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_02 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_03 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_04 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_05 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_06 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_07 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_08 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_09 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_10 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_11 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2012_12 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_01 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_02 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_03 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_04 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_05 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_06 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_07 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_08 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_09 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_10 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_11 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2013_12 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_01 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_02 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_03 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_04 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_05 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_06 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_07 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_08 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_09 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_10 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_11 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2014_12 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_01 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_02 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_03 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_04 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_05 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_06 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_07 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_08 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_09 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_10 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_11 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2015_12 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2016_01 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2016_02 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2016_03 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2016_04 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2016_05 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2016_06 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2016_07 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2016_08 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2016_09 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2016_10 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2016_11 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2016_12 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2017_01 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2017_02 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2017_03 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2017_04 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2017_05 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2017_06 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2017_07 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2017_08 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2017_09 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2017_10 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2017_11 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2017_12 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2018_01 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2018_02 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2018_03 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2018_04 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2018_05 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2018_06 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2018_07 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2018_08 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2018_09 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2018_10 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2018_11 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2018_12 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2019_01 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2019_02 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2019_03 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2019_04 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2019_05 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2019_06 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2019_07 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2019_08 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2019_09 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2019_10 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2019_11 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2019_12 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2020_01 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2020_02 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2020_03 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2020_04 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2020_05 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2020_06 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2020_07 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2020_08 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';
UPDATE IGNORE piwik_archive_blob_2020_09 SET name='DevicesDetection_browserEngines' WHERE name = 'UserSettings_browserType';

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

# These SQL queries will be executed: 
CREATE TABLE `piwik_sequence` (`name` VARCHAR(120) NOT NULL, `value` BIGINT(20) UNSIGNED NOT NULL, PRIMARY KEY ( `name` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2009_01',711);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2009_02',663);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2009_03',680);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2009_04',670);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2009_05',675);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2009_06',675);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2009_07',675);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2009_08',540);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2009_11',502);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2009_12',535);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2010_01',535);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2010_02',532);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2010_03',536);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2010_04',565);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2010_05',600);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2010_06',683);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2010_07',633);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2010_08',597);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2010_09',592);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2010_10',576);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2010_11',562);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2010_12',566);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2011_01',564);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2011_02',558);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2011_03',564);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2011_04',593);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2011_05',596);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2011_06',595);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2011_07',596);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2011_08',604);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2011_09',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2011_10',574);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2011_11',571);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2011_12',572);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_01',607);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_02',615);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_03',636);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_04',602);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_05',603);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_06',599);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_07',604);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_08',602);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_09',696);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_10',674);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_11',596);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2012_12',572);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_01',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_02',564);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_03',547);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_04',535);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_05',550);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_06',609);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_07',536);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_08',535);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_09',561);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_10',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_11',568);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2013_12',572);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_01',603);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_02',593);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_03',604);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_04',590);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_05',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_06',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_07',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_08',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_09',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_10',582);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_11',572);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2014_12',572);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_01',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_02',564);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_03',572);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_04',568);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_05',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_06',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_07',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_08',572);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_09',568);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_10',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_11',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2015_12',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2016_01',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2016_02',568);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2016_03',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2016_04',568);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2016_05',572);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2016_06',568);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2016_07',582);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2016_08',572);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2016_09',568);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2016_10',572);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2016_11',568);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2016_12',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2017_01',572);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2017_02',564);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2017_03',570);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2017_04',568);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2017_05',572);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2017_06',568);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2017_07',520);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2017_08',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2017_09',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2017_10',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2017_11',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2017_12',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2018_01',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2018_02',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2018_03',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2018_04',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2018_05',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2018_06',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2018_07',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2018_08',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2018_09',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2018_10',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2018_11',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2018_12',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2019_01',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2019_02',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2019_03',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2019_04',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2019_05',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2019_06',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2019_07',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2019_08',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2019_09',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2019_10',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2019_11',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2019_12',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2020_01',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2020_02',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2020_03',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2020_04',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2020_05',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2020_06',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2020_07',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2020_08',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2020_09',1);
INSERT INTO `piwik_sequence` (`name`, `value`) VALUES ('piwik_archive_numeric_2020_10',1);
# ATTENTION: This update script will execute some more SQL queries than that below as it is necessary to rebuilt some archives #;
UPDATE piwik_report SET reports = REPLACE(reports, 'UserSettings_getBrowserVersion', 'DevicesDetection_getBrowserVersions');
UPDATE piwik_report SET reports = REPLACE(reports, 'UserSettings_getBrowser', 'DevicesDetection_getBrowsers');
UPDATE piwik_report SET reports = REPLACE(reports, 'UserSettings_getOSFamily', 'DevicesDetection_getOsFamilies');
UPDATE piwik_report SET reports = REPLACE(reports, 'UserSettings_getOS', 'DevicesDetection_getOsVersions');
UPDATE piwik_report SET reports = REPLACE(reports, 'UserSettings_getMobileVsDesktop', 'DevicesDetection_getType');
UPDATE piwik_report SET reports = REPLACE(reports, 'UserSettings_getBrowserType', 'DevicesDetection_getBrowserEngines');
UPDATE piwik_report SET reports = REPLACE(reports, 'UserSettings_getWideScreen', 'UserSettings_getScreenType');
UPDATE piwik_archive_blob_2009_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2009_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2009_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2009_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2009_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2009_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2009_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2009_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2009_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2009_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2009_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2009_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2009_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2009_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2009_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2009_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2009_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2009_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2009_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2009_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2010_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2010_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2010_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2010_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2010_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2010_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2010_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2010_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2010_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2010_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2010_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2010_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2010_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2010_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2010_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2010_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2010_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2010_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2010_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2010_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2010_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2010_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2010_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2010_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2011_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2011_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2011_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2011_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2011_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2011_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2011_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2011_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2011_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2011_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2011_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2011_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2011_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2011_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2011_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2011_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2011_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2011_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2011_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2011_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2011_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2011_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2011_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2011_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2012_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2012_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2009_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2009_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2009_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2009_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2009_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2009_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2009_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2009_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2009_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2009_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2010_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2010_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2010_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2010_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2010_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2010_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2010_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2010_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2010_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2010_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2010_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2010_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2011_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2011_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2011_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2011_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2011_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2011_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2011_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2011_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2011_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2011_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2011_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2011_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2012_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';

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

# These SQL queries will be executed: 
UPDATE piwik_archive_blob_2009_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2009_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2009_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2009_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2009_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2009_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2009_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2009_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2009_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2009_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2010_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2010_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2010_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2010_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2010_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2010_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2010_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2010_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2010_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2010_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2010_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2010_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2011_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2011_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2011_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2011_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2011_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2011_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2011_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2011_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2011_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2011_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2011_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2011_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2012_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';

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

# These SQL queries will be executed: 
delete from `piwik_option` where option_name like '%defaultReport%' and option_value='';
DROP TABLE IF EXISTS `piwik_site_setting`;
CREATE TABLE `piwik_site_setting` (`idsite` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, `setting_name` VARCHAR(255) NOT NULL, `setting_value` LONGTEXT NOT NULL, PRIMARY KEY ( `idsite`, `setting_name` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_site` ADD COLUMN `exclude_unknown_urls` TINYINT(1) DEFAULT 0 AFTER `currency`;

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

# These SQL queries will be executed: 
UPDATE piwik_user_dashboard SET layout = '{\"config\":{\"layout\":\"33-33-33\"},\"columns\":[[{\"uniqueId\":\"widgetVisitsSummarygetEvolutionGraphforceView1viewDataTablegraphEvolution\",\"parameters\":{\"module\":\"VisitsSummary\",\"action\":\"getEvolutionGraph\",\"columns\":[\"nb_visits\"],\"viewDataTable\":\"graphEvolution\",\"filter_limit\":10,\"forceView\":\"1\"},\"isHidden\":0},{\"uniqueId\":\"widgetReferrersgetWebsites\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getWebsites\",\"viewDataTable\":{\"module\":\"Referrers\",\"action\":\"getWebsites\"},\"filter_limit\":10},\"isHidden\":0}],[{\"uniqueId\":\"widgetReferrersgetKeywords\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getKeywords\",\"viewDataTable\":{\"module\":\"Referrers\",\"action\":\"getKeywords\"},\"filter_limit\":10},\"isHidden\":0},{\"uniqueId\":\"widgetUserCountrygetCountry\",\"parameters\":{\"module\":\"UserCountry\",\"action\":\"getCountry\",\"viewDataTable\":{\"module\":\"UserCountry\",\"action\":\"getCountry\"},\"filter_limit\":10},\"isHidden\":0}],[{\"uniqueId\":\"widgetReferrersgetSearchEngines\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getSearchEngines\",\"viewDataTable\":{\"module\":\"Referrers\",\"action\":\"getSearchEngines\"},\"filter_limit\":10},\"isHidden\":0}]]}' WHERE iddashboard = '1';
CREATE TABLE `piwik_plugin_setting` (`plugin_name` VARCHAR(60) NOT NULL, `setting_name` VARCHAR(255) NOT NULL, `setting_value` LONGTEXT NOT NULL, `user_login` VARCHAR(100) NOT NULL DEFAULT '') ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_plugin_setting` ADD INDEX index_plugin_name_user_login (`plugin_name`, `user_login`);
DELETE FROM `piwik_option` WHERE `option_name` like "Plugin_%_Settings";
DROP TABLE IF EXISTS `piwik_site_setting`;
CREATE TABLE `piwik_site_setting` (`idsite` INTEGER(10) UNSIGNED NOT NULL, `plugin_name` VARCHAR(60) NOT NULL, `setting_name` VARCHAR(255) NOT NULL, `setting_value` LONGTEXT NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_site_setting` ADD INDEX(idsite, plugin_name);
ALTER TABLE `piwik_log_visit` CHANGE `idvisit` `idvisit` BIGINT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `piwik_log_conversion_item` CHANGE `idvisit` `idvisit` BIGINT(10) UNSIGNED NOT NULL;
ALTER TABLE `piwik_log_conversion` CHANGE `idvisit` `idvisit` BIGINT(10) UNSIGNED NOT NULL, CHANGE `idlink_va` `idlink_va` BIGINT(10) UNSIGNED default NULL;
ALTER TABLE `piwik_log_link_visit_action` CHANGE `idlink_va` `idlink_va` BIGINT(10) UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `idvisit` `idvisit` BIGINT(10) UNSIGNED NOT NULL, CHANGE `idaction_name_ref` `idaction_name_ref` INTEGER(10) UNSIGNED NULL;
ALTER TABLE `piwik_user` CHANGE `password` `password` VARCHAR(255) NOT NULL;
CREATE TABLE `piwik_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 `piwik_privacy_logdata_anonymizations` ADD INDEX index_job_start_date (`job_start_date`);
ALTER TABLE `piwik_plugin_setting` ADD COLUMN `json_encoded` TINYINT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `piwik_site_setting` ADD COLUMN `json_encoded` TINYINT UNSIGNED NOT NULL DEFAULT 0;
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"

# These SQL queries will be executed: 
ALTER TABLE `piwik_goal` CHANGE `pattern_type` `pattern_type` varchar(25) NOT NULL;
CREATE TABLE `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 `piwik_option` SET option_value = 'https://download.db-ip.com/free/dbip-city-lite-2023-10.mmdb.gz' WHERE option_name = 'geoip2.loc_db_url' AND option_value = 'https://geolite.maxmind.com/download/geoip/database/GeoLite2-City.tar.gz';
UPDATE `piwik_option` SET option_value = 'https://download.db-ip.com/free/dbip-country-lite-2023-10.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 `piwik_user_language` ADD COLUMN `use_12_hour_clock` TINYINT(1) NOT NULL DEFAULT 0 AFTER `language`;
ALTER TABLE `piwik_goal` ADD COLUMN `description` VARCHAR(255) NOT NULL DEFAULT '' AFTER `name`;
ALTER TABLE `piwik_log_visit` CHANGE `location_provider` `location_provider` VARCHAR(200) NULL;
ALTER TABLE `piwik_log_visit` ADD COLUMN `user_id` VARCHAR(200) NULL, MODIFY COLUMN `visit_goal_buyer` TINYINT(1) NULL, MODIFY COLUMN `visit_goal_converted` TINYINT(1) NULL, MODIFY COLUMN `visitor_days_since_first` SMALLINT(5) UNSIGNED NULL, MODIFY COLUMN `visitor_days_since_order` SMALLINT(5) UNSIGNED NULL, MODIFY COLUMN `visitor_returning` TINYINT(1) NULL, MODIFY COLUMN `visitor_count_visits` INT(11) UNSIGNED NOT NULL, 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` SMALLINT UNSIGNED DEFAULT 0, MODIFY COLUMN `visit_total_searches` SMALLINT(5) UNSIGNED NULL, MODIFY COLUMN `referer_url` TEXT NULL, MODIFY COLUMN `visit_total_events` INT(11) UNSIGNED NULL, MODIFY COLUMN `visitor_localtime` TIME NULL, MODIFY COLUMN `visitor_days_since_last` SMALLINT(5) UNSIGNED 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;
ALTER TABLE `piwik_log_conversion` MODIFY COLUMN `visitor_days_since_first` SMALLINT(5) UNSIGNED NULL, MODIFY COLUMN `visitor_days_since_order` SMALLINT(5) UNSIGNED NULL, MODIFY COLUMN `visitor_returning` TINYINT(1) NULL, MODIFY COLUMN `visitor_count_visits` 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;
ALTER TABLE `piwik_log_link_visit_action` ADD COLUMN `idpageview` CHAR(6) NULL DEFAULT NULL, ADD COLUMN `interaction_position` SMALLINT UNSIGNED DEFAULT NULL, MODIFY COLUMN `time_spent_ref_action` INTEGER(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.

File integrity check failed and reported some errors. You should fix this issue and then refresh this page until it shows no error.

Database Upgrade Required

Important notes for large Matomo installations

Need help upgrading Matomo?

Ready to go?