Matomo database will be upgraded from version 4.15.1 to the new version 5.1.0.
The following plugins will be updated: TagManager, BotTracker.
The following dimensions will be updated: log_conversion.pageviews_before.
Important notes for large Matomo installations
If you have a large Matomo database, updates might take too long to run in the browser. In this situation, you can execute the updates from your command line:
php /home/digitalanalytics/public_html/console core:update
If you manage a high traffic Matomo server, we recommend to momentarily disable visitor Tracking and put the Matomo User Interface in maintenance mode.
FYI: these are the SQL queries and console commands that will be executed to upgrade your database to Matomo 5.1.0
› Click here to view and copy the list of SQL queries and console commands that will get executed
# These SQL queries will be executed:
DELETE FROM `archive_numeric_2008_12` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2008_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2008_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2009_01` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2009_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2009_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2009_02` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2009_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2009_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2009_03` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2009_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2009_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2009_04` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2009_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2009_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2009_05` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2009_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2009_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2009_06` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2009_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2009_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2009_07` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2009_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2009_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2009_08` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2009_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2009_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2009_09` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2009_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2009_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2009_10` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2009_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2009_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2009_11` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2009_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2009_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2009_12` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2009_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2009_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2010_01` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2010_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2010_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2010_02` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2010_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2010_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2010_03` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2010_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2010_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2010_04` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2010_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2010_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2010_05` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2010_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2010_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2010_06` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2010_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2010_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2010_07` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2010_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2010_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2010_08` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2010_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2010_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2010_09` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2010_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2010_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2010_10` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2010_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2010_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2010_11` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2010_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2010_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2010_12` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2010_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2010_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2011_01` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2011_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2011_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2011_02` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2011_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2011_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2011_03` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2011_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2011_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2011_04` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2011_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2011_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2011_05` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2011_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2011_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2011_06` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2011_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2011_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2011_07` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2011_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2011_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2011_08` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2011_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2011_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2011_09` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2011_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2011_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2011_10` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2011_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2011_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2011_11` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2011_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2011_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2011_12` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2011_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2011_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2012_01` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2012_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2012_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2012_02` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2012_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2012_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2012_03` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2012_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2012_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2012_04` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2012_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2012_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2012_05` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2012_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2012_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2012_06` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2012_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2012_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2012_07` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2012_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2012_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2012_08` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2012_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2012_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2012_09` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2012_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2012_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2012_10` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2012_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2012_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2012_11` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2012_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2012_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2012_12` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2012_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2012_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2013_01` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2013_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2013_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2013_02` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2013_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2013_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2013_03` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2013_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2013_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2013_04` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2013_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2013_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2013_05` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2013_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2013_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2013_06` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2013_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2013_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2013_07` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2013_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2013_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2013_08` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2013_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2013_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2013_09` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2013_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2013_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2013_10` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2013_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2013_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2013_11` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2013_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2013_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2013_12` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2013_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2013_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2014_01` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2014_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2014_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2014_02` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2014_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2014_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2014_03` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2014_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2014_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2014_04` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2014_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2014_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2014_05` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2014_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2014_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2014_06` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2014_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2014_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2014_07` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2014_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2014_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2014_08` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2014_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2014_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2014_09` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2014_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2014_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2014_10` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2014_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2014_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2014_11` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2014_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2014_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2014_12` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2014_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2014_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2015_01` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2015_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2015_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2015_02` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2015_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2015_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2015_03` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2015_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2015_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2015_04` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2015_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2015_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2015_05` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2015_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2015_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2015_06` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2015_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2015_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2015_07` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2015_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2015_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2015_08` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2015_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2015_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2015_09` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2015_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2015_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2015_10` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2015_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2015_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2015_11` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2015_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2015_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2015_12` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2015_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2015_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2016_01` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2016_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2016_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2016_02` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2016_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2016_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2016_03` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2016_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2016_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2016_04` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2016_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2016_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2016_05` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2016_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2016_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2016_06` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2016_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2016_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2016_07` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2016_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2016_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2016_08` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2016_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2016_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2016_09` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2016_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2016_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2016_10` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2016_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2016_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2016_11` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2016_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2016_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2016_12` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2016_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2016_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2017_01` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2017_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2017_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2017_02` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2017_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2017_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2017_03` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2017_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2017_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2017_04` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2017_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2017_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2017_05` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2017_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2017_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2017_06` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2017_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2017_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2017_07` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2017_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2017_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2017_08` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2017_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2017_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2017_09` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2017_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2017_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2017_10` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2017_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2017_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2017_11` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2017_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2017_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2017_12` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2017_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2017_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2018_01` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2018_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2018_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2018_02` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2018_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2018_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2018_03` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2018_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2018_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2018_04` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2018_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2018_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2018_05` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2018_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2018_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2018_06` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2018_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2018_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2018_07` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2018_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2018_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2018_08` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2018_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2018_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2018_09` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2018_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2018_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2018_10` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2018_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2018_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2018_11` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2018_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2018_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2018_12` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2018_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2018_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2019_01` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2019_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2019_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2019_02` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2019_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2019_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2019_03` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2019_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2019_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2019_04` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2019_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2019_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2019_05` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2019_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2019_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2019_06` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2019_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2019_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2019_07` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2019_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2019_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2019_08` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2019_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2019_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2019_09` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2019_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2019_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2019_10` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2019_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2019_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2019_11` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2019_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2019_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2019_12` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2019_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2019_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2020_01` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2020_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2020_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2020_02` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2020_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2020_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2020_03` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2020_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2020_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2020_04` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2020_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2020_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2020_05` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2020_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2020_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2020_06` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2020_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2020_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2020_07` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2020_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2020_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2020_08` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2020_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2020_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2020_09` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2020_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2020_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2020_10` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2020_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2020_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2020_11` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2020_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2020_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2020_12` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2020_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2020_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2021_01` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2021_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2021_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2021_02` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2021_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2021_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2021_03` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2021_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2021_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2021_04` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2021_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2021_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2021_05` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2021_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2021_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2021_06` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2021_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2021_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2021_07` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2021_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2021_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2021_08` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2021_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2021_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2021_09` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2021_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2021_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2021_10` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2021_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2021_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2021_11` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2021_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2021_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2021_12` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2021_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2021_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2022_01` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2022_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2022_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2022_02` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2022_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2022_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2022_03` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2022_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2022_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2022_04` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2022_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2022_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2022_05` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2022_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2022_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2022_06` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2022_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2022_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2022_07` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2022_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2022_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2022_08` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2022_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2022_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2022_09` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2022_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2022_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2022_10` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2022_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2022_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2022_11` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2022_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2022_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2022_12` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2022_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2022_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2023_01` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2023_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2023_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2023_02` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2023_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2023_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2023_03` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2023_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2023_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2023_04` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2023_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2023_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2023_05` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2023_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2023_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2023_06` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2023_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2023_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2023_07` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2023_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2023_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2023_08` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2023_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2023_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2023_09` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2023_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2023_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2023_10` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2023_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2023_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2023_11` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2023_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2023_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2023_12` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2023_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2023_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2024_01` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2024_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2024_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2024_02` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2024_02` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2024_02` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2024_03` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2024_03` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2024_03` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2024_04` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2024_04` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2024_04` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2024_05` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2024_05` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2024_05` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2024_06` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2024_06` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2024_06` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2024_07` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2024_07` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2024_07` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2024_08` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2024_08` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2024_08` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2024_09` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2024_09` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2024_09` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2024_10` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2024_10` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2024_10` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2024_11` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2024_11` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2024_11` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2024_12` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2024_12` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2024_12` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
DELETE FROM `archive_numeric_2025_01` WHERE ts_archived is null;
ALTER TABLE `archive_numeric_2025_01` DROP INDEX `index_idsite_dates_period`;
ALTER TABLE `archive_numeric_2025_01` ADD INDEX index_idsite_dates_period (`idsite`, `date1`, `date2`, `period`, `name` (6));
ALTER TABLE `user_token_auth` ADD COLUMN `post_only` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `log_conversion` ADD COLUMN `pageviews_before` SMALLINT UNSIGNED DEFAULT NULL;
# These console commands will be run:
./console core:calculate-conversion-pages --dates=yesterday,today
# These SQL queries will be executed:
ALTER TABLE `log_visit` ADD INDEX `index_idsite_idvisitor_time` (`idsite`, `idvisitor`, `visit_last_action_time` DESC);
ALTER TABLE `log_visit` DROP INDEX `index_idsite_idvisitor`;
# These console commands will be run:
./console plugin:activate "JsTrackerInstallCheck"
# These SQL queries will be executed:
ALTER TABLE `user_token_auth` CHANGE `post_only` `secure_only` TINYINT(2) UNSIGNED NOT NULL DEFAULT '0';
ALTER TABLE `user` ADD COLUMN `ts_changes_shown` TIMESTAMP NULL;
ALTER TABLE `tagmanager_container` ADD COLUMN `ignoreGtmDataLayer` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0 AFTER `description`;
ALTER TABLE `bot_db` ADD COLUMN `botType` TINYINT(0) UNSIGNED NULL DEFAULT 0;
ALTER TABLE `bot_db` CHANGE `botName` `botName` VARCHAR(256);
ALTER TABLE `bot_db` CHANGE `botKeyword` `botKeyword` VARCHAR(256);
ALTER TABLE `bot_db_stat` CHANGE `page` `page` VARCHAR(256);
ALTER TABLE `bot_db_stat` CHANGE `useragent` `useragent` VARCHAR(256);
CREATE TABLE `bot_visits` (`id` bigint unsigned NOT NULL AUTO_INCREMENT, `botId` INT UNSIGNED, `idsite` INT UNSIGNED, `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY ( `id` )) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
CREATE TABLE `bot_type` (`id` INT(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(256) NOT NULL, `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY ( `id` )) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
INSERT INTO `bot_type` (`name`) VALUES ('Monitoring & Analytics');
INSERT INTO `bot_type` (`name`) VALUES ('Search Engine Optimization');
INSERT INTO `bot_type` (`name`) VALUES ('Advertising & Marketing');
INSERT INTO `bot_type` (`name`) VALUES ('Page Preview');
INSERT INTO `bot_type` (`name`) VALUES ('Webhook');
INSERT INTO `bot_type` (`name`) VALUES ('Social network');
INSERT INTO `bot_type` (`name`) VALUES ('Scraper');
INSERT INTO `bot_type` (`name`) VALUES ('Copyright');
INSERT INTO `bot_type` (`name`) VALUES ('Search Engine Crawler');
INSERT INTO `bot_type` (`name`) VALUES ('AI Search Crawler');
INSERT INTO `bot_type` (`name`) VALUES ('AI Data Scraper');
INSERT INTO `bot_type` (`name`) VALUES ('AI Assistant');
INSERT INTO `bot_type` (`name`) VALUES ('Other');
CREATE TABLE `bot_device_detector_bots` (`id` INT(11) NOT NULL AUTO_INCREMENT, `idsite` INT UNSIGNED, `useragent` VARCHAR(256) NOT NULL, `date` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY ( `id` )) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;
ALTER TABLE `bot_type` CHANGE `name` `name` VARCHAR(256);
ALTER TABLE `log_conversion` ADD COLUMN `pageviews_before` SMALLINT UNSIGNED DEFAULT 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. |
Files were found in your Matomo, but we didn't expect them. --> Please delete these files to prevent errors. <-- File to delete: How to install Matomo.html File to delete: config/environment/test.php File to delete: config/environment/ui-test.php File to delete: matomo-4.5.0.zip File to delete: misc/DBIP-City.mmdb.1651511854.old File to delete: piwik.min.js To delete all these files at once, you can run this command: rm "/home/digitalanalytics/public_html/How to install Matomo.html" "/home/digitalanalytics/public_html/config/environment/test.php" "/home/digitalanalytics/public_html/config/environment/ui-test.php" "/home/digitalanalytics/public_html/matomo-4.5.0.zip" "/home/digitalanalytics/public_html/misc/DBIP-City.mmdb.1651511854.old" "/home/digitalanalytics/public_html/piwik.min.js" |