free/libre analytics platform
Your Piwik database is out-of-date, and must be upgraded before you can continue.
Piwik database will be upgraded from version 1.7.1 to the new version 2.14.3.
The following dimensions will be updated: log_visit.location_latitude, log_visit.location_city, log_visit.visit_total_searches, log_visit.location_longitude, log_visit.location_region, log_visit.user_id.
If you have a large Piwik database, updates might take too long to run in the browser. In this situation, you can execute the updates from your command line:
php /storage/content/64/130264/stats.borasboras.se/public_html/console core:update
If you manage a high traffic Piwik server, we recommend to momentarily disable visitor Tracking and put the Piwik User Interface in maintenance mode.
If you are not able to use the command line updater and if Piwik fails to upgrade (due to a timeout of the database, a browser timeout, or any other issue), you could manually execute the SQL queries to update Piwik.
› Click here to view and copy the list of SQL queries that will get executed
# Note: if you manually execute these queries, it is expected that some of them fail. In this case, simply ignore the errors, and run the next ones in the list.
ALTER TABLE `piwik_pdf` CHANGE `aggregate_reports_format` `display_format` TINYINT(1) NOT NULL;
ALTER TABLE `piwik_user_dashboard` ADD `name` VARCHAR( 100 ) NULL DEFAULT NULL AFTER `iddashboard`;
ALTER TABLE `piwik_site` CHANGE `excluded_parameters` `excluded_parameters` TEXT NOT NULL;
CREATE TABLE `piwik_report` ( `idreport` INT(11) NOT NULL AUTO_INCREMENT, `idsite` INTEGER(11) NOT NULL, `login` VARCHAR(100) NOT NULL, `description` VARCHAR(255) NOT NULL, `period` VARCHAR(10) NOT NULL, `type` VARCHAR(10) NOT NULL, `format` VARCHAR(10) NOT NULL, `reports` TEXT NOT NULL, `parameters` TEXT NULL, `ts_created` TIMESTAMP NULL, `ts_last_sent` TIMESTAMP NULL, `deleted` tinyint(4) NOT NULL default 0, PRIMARY KEY (`idreport`) ) DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_log_action` ADD `url_prefix` TINYINT(2) NULL AFTER `type`; ;
UPDATE `piwik_log_action` SET url_prefix = IF ( LEFT(name, 11) = 'http://www.', 1, IF ( LEFT(name, 7) = 'http://', 0, IF ( LEFT(name, 12) = 'https://www.', 3, IF ( LEFT(name, 8) = 'https://', 2, NULL ) ) ) ), name = IF ( url_prefix = 0, SUBSTRING(name, 8), IF ( url_prefix = 1, SUBSTRING(name, 12), IF ( url_prefix = 2, SUBSTRING(name, 9), IF ( url_prefix = 3, SUBSTRING(name, 13), name ) ) ) ), hash = CRC32(name) WHERE type = 1 AND url_prefix IS NULL; ;
DROP TABLE IF EXISTS `piwik_log_action_duplicates`; ;
CREATE TABLE `piwik_log_action_duplicates` ( `before` int(10) unsigned NOT NULL, `after` int(10) unsigned NOT NULL, KEY `mainkey` (`before`) ) ENGINE=InnoDB; ;
INSERT INTO `piwik_log_action_duplicates` ( SELECT action.idaction AS `before`, canonical.idaction AS `after` FROM ( SELECT name, hash, MIN(idaction) AS idaction FROM `piwik_log_action` AS action_canonical_base WHERE type = 1 AND url_prefix IS NOT NULL GROUP BY name, hash HAVING COUNT(idaction) > 1 ) AS canonical LEFT JOIN `piwik_log_action` AS action ON (action.type = 1 AND canonical.hash = action.hash) AND canonical.name = action.name AND canonical.idaction != action.idaction ); ;
UPDATE `piwik_log_link_visit_action` AS link LEFT JOIN `piwik_log_action_duplicates` AS duplicates_idaction_url ON link.idaction_url = duplicates_idaction_url.before SET link.idaction_url = duplicates_idaction_url.after WHERE duplicates_idaction_url.after IS NOT NULL; ;
UPDATE `piwik_log_link_visit_action` AS link LEFT JOIN `piwik_log_action_duplicates` AS duplicates_idaction_url_ref ON link.idaction_url_ref = duplicates_idaction_url_ref.before SET link.idaction_url_ref = duplicates_idaction_url_ref.after WHERE duplicates_idaction_url_ref.after IS NOT NULL; ;
UPDATE `piwik_log_conversion` AS conversion LEFT JOIN `piwik_log_action_duplicates` AS duplicates ON conversion.idaction_url = duplicates.before SET conversion.idaction_url = duplicates.after WHERE duplicates.after IS NOT NULL; ;
UPDATE `piwik_log_visit` AS visit LEFT JOIN `piwik_log_action_duplicates` AS duplicates_entry ON visit.visit_entry_idaction_url = duplicates_entry.before SET visit.visit_entry_idaction_url = duplicates_entry.after WHERE duplicates_entry.after IS NOT NULL; ;
UPDATE `piwik_log_visit` AS visit LEFT JOIN `piwik_log_action_duplicates` AS duplicates_exit ON visit.visit_exit_idaction_url = duplicates_exit.before SET visit.visit_exit_idaction_url = duplicates_exit.after WHERE duplicates_exit.after IS NOT NULL; ;
DELETE action FROM `piwik_log_action` AS action LEFT JOIN `piwik_log_action_duplicates` AS duplicates ON action.idaction = duplicates.before WHERE duplicates.after IS NOT NULL; ;
DROP TABLE `piwik_log_action_duplicates`; ;
ALTER TABLE `piwik_log_visit` DROP `location_continent`;
ALTER TABLE `piwik_log_conversion` DROP `location_continent`;
ALTER TABLE `piwik_log_visit` ADD `location_region` CHAR(2) NULL AFTER `location_country`, ADD `location_city` VARCHAR(255) NULL AFTER `location_region`, ADD `location_latitude` FLOAT(10, 6) NULL AFTER `location_city`, ADD `location_longitude` FLOAT(10, 6) NULL AFTER `location_latitude`;
ALTER TABLE `piwik_log_conversion` ADD `location_region` CHAR(2) NULL AFTER `location_country`, ADD `location_city` VARCHAR(255) NULL AFTER `location_region`, ADD `location_latitude` FLOAT(10, 6) NULL AFTER `location_city`, ADD `location_longitude` FLOAT(10, 6) NULL AFTER `location_latitude`;
ALTER TABLE `piwik_log_link_visit_action` CHANGE `idaction_url` `idaction_url` INT( 10 ) UNSIGNED NULL DEFAULT NULL;
ALTER TABLE `piwik_log_visit` ADD visit_total_searches SMALLINT(5) UNSIGNED NOT NULL AFTER `visit_total_actions`;
ALTER TABLE `piwik_site` ADD sitesearch TINYINT DEFAULT 1 AFTER `excluded_parameters`, ADD sitesearch_keyword_parameters TEXT NOT NULL AFTER `sitesearch`, ADD sitesearch_category_parameters TEXT NOT NULL AFTER `sitesearch_keyword_parameters`;
UPDATE `piwik_site` SET `sitesearch` = 1;
ALTER TABLE `piwik_log_link_visit_action` CHANGE `idaction_url_ref` `idaction_url_ref` INT( 10 ) UNSIGNED NULL DEFAULT 0;
ALTER TABLE `piwik_log_visit` CHANGE `visit_exit_idaction_url` `visit_exit_idaction_url` INT( 10 ) UNSIGNED NULL DEFAULT 0;
ALTER TABLE piwik_site DROP `feedburnerName`;
ALTER TABLE piwik_site ADD COLUMN excluded_user_agents TEXT NOT NULL AFTER excluded_parameters;
ALTER TABLE piwik_report ADD COLUMN hour tinyint NOT NULL default 0 AFTER period;
ALTER TABLE piwik_site ADD COLUMN `keep_url_fragment` TINYINT NOT NULL DEFAULT 0 AFTER `group`;
ALTER TABLE `piwik_log_link_visit_action` ADD `custom_float` FLOAT NULL DEFAULT NULL;
ALTER TABLE piwik_report ADD COLUMN idsegment INT(11) AFTER description;
ALTER TABLE piwik_logger_message ADD COLUMN tag VARCHAR(50) NULL AFTER idlogger_message;
ALTER TABLE piwik_logger_message ADD COLUMN level TINYINT AFTER timestamp;
ALTER TABLE piwik_logger_message MODIFY level VARCHAR(16) NULL;
DROP TABLE piwik_logger_exception;
DROP TABLE piwik_logger_error;
DROP TABLE piwik_logger_api_call;
UPDATE `piwik_archive_numeric_2011_01` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2011_09` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2011_10` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2011_11` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2011_12` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2012_01` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2012_02` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2012_03` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2012_04` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2012_05` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2012_06` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2012_07` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2012_08` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2012_09` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2012_10` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2012_11` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2012_12` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2013_01` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2013_02` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2013_03` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2013_04` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2013_05` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2013_06` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2013_07` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2013_08` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2013_09` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2013_10` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2013_11` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2013_12` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2014_01` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2014_02` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2014_03` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2014_04` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2014_05` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2014_06` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2014_07` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2014_08` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2014_09` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2014_10` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2014_11` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2014_12` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2015_01` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2015_02` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2015_03` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2015_04` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2015_05` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2015_06` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2015_07` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2015_08` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_numeric_2015_09` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2011_01` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2011_09` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2011_10` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2011_11` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2011_12` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2012_01` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2012_02` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2012_03` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2012_04` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2012_05` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2012_06` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2012_07` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2012_08` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2012_09` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2012_10` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2012_11` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2012_12` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2013_01` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2013_02` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2013_03` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2013_04` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2013_05` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2013_06` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2013_07` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2013_08` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2013_09` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2013_10` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2013_11` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2013_12` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2014_01` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2014_02` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2014_03` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2014_04` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2014_05` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2014_06` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2014_07` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2014_08` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2014_09` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2014_10` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2014_11` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2014_12` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2015_01` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2015_02` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2015_03` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2015_04` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2015_05` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2015_06` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2015_07` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2015_08` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_archive_blob_2015_09` SET `name`=REPLACE(`name`, 'Referers_', 'Referrers_') WHERE `name` LIKE 'Referers_%';
UPDATE `piwik_segment` SET `definition`=REPLACE(`definition`, 'referer', 'referrer') WHERE `definition` LIKE '%referer%';
UPDATE `piwik_report` SET `reports`=REPLACE(`reports`, 'Referer', 'Referrer') WHERE `reports` LIKE '%Referer%';
UPDATE `piwik_user_dashboard` SET `layout`=REPLACE(`layout`, 'Referer', 'Referrer') WHERE `layout` LIKE '%Referer%';
UPDATE `piwik_option` SET `option_name` = 'version_ScheduledReports' WHERE `option_name` = 'version_PDFReports' ;
ALTER TABLE piwik_log_visit ADD COLUMN visit_total_events SMALLINT(5) UNSIGNED NOT NULL AFTER visit_total_searches;
ALTER TABLE piwik_log_link_visit_action ADD COLUMN idaction_event_category INTEGER(10) UNSIGNED AFTER idaction_name_ref, ADD COLUMN idaction_event_action INTEGER(10) UNSIGNED AFTER idaction_event_category;
ALTER TABLE `piwik_site` ADD `type` VARCHAR(255) NOT NULL DEFAULT 'website' AFTER `group` ;
ALTER TABLE piwik_user ADD COLUMN `superuser_access` tinyint(2) unsigned NOT NULL DEFAULT '0' AFTER token_auth;
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_2011_01 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';
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_2011_01', 501);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2011_09', 501);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2011_10', 1040);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2011_11', 1012);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2011_12', 961);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_01', 953);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_02', 907);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_03', 599);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_04', 660);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_05', 640);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_06', 593);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_07', 592);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_08', 575);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_09', 767);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_10', 537);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_11', 535);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2012_12', 537);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_01', 561);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_02', 533);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_03', 536);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_04', 568);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_05', 568);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_06', 566);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_07', 569);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_08', 568);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_09', 567);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_10', 568);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_11', 566);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2013_12', 569);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_01', 569);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_02', 600);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_03', 569);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_04', 566);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_05', 568);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_06', 567);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_07', 568);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_08', 568);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_09', 567);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_10', 568);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_11', 566);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2014_12', 569);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_01', 571);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_02', 562);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_03', 569);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_04', 566);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_05', 568);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_06', 567);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_07', 568);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_08', 569);
INSERT INTO piwik_sequence (name, value) VALUES ('piwik_archive_numeric_2015_09', 578);
# 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_user_dashboard SET layout = 'null' WHERE iddashboard = 1;
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_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_2011_01 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_user_dashboard SET layout = 'null' WHERE iddashboard = 1;
UPDATE piwik_archive_blob_2011_01 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';
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_log_visit` ADD COLUMN `location_latitude` float(10, 6) DEFAULT NULL, ADD COLUMN `location_city` varchar(255) DEFAULT NULL, ADD COLUMN `visit_total_searches` SMALLINT(5) UNSIGNED NOT NULL, ADD COLUMN `location_longitude` float(10, 6) DEFAULT NULL, ADD COLUMN `location_region` char(2) DEFAULT NULL, ADD COLUMN `user_id` VARCHAR(200) NULL;
ALTER TABLE `piwik_log_conversion` ADD COLUMN `location_latitude` float(10, 6) DEFAULT NULL, ADD COLUMN `location_city` varchar(255) DEFAULT NULL, ADD COLUMN `location_longitude` float(10, 6) DEFAULT NULL, ADD COLUMN `location_region` char(2) DEFAULT NULL;
The database upgrade process may take a while, so please be patient.