Die Matomo-Datenbank wird von Version 2.9.1 auf die neue Version 4.11.0 aktualisiert.
Die folgenden Plugins werden aktualisiert: LanguagesManager, Goals.
Die folgenden Dimensionen werden aktualisiert: log_link_visit_action.idpageview, log_link_visit_action.search_cat, log_link_visit_action.search_count, log_link_visit_action.time_spent_ref_action, log_visit.config_browser_engine, log_visit.config_browser_name, log_visit.config_browser_version, log_visit.config_client_type, log_visit.config_device_brand, log_visit.config_device_model, log_visit.config_device_type, log_visit.config_os, log_visit.location_country, log_visit.location_latitude, log_visit.location_longitude, log_visit.location_region, log_visit.profilable, log_visit.referer_name, log_visit.referer_url, log_visit.visit_entry_idaction_name, log_visit.visit_entry_idaction_url, log_visit.visit_exit_idaction_name, log_visit.visit_exit_idaction_url, log_visit.visit_goal_buyer, log_visit.visit_goal_converted, log_visit.visit_total_actions, log_visit.visit_total_events, log_visit.visit_total_interactions, log_visit.visit_total_searches, log_visit.visit_total_time, log_visit.visitor_count_visits, log_visit.visitor_localtime, log_visit.visitor_returning, log_visit.visitor_seconds_since_first, log_visit.visitor_seconds_since_last, log_visit.visitor_seconds_since_order.
Wichtiger Hinweis für große Matomo-Installationen
Wenn Sie eine große Matomo-Datenbank haben, können Aktualisierungen zu lange dauern, um erfolgreich im Browser durchgeführt zu werden. In diesem Fall können Sie die Aktualisierung auch von der Kommandozeile aus starten:
php /usr/www/users/viuerf/dskpiwik/console core:update
Wenn Sie eine Website mit hohem Verkehrsaufkommen verwalten, empfehlen wir, das Besuchertracking vorübergehend zu deaktivieren und die Benutzeroberfläche in den Wartungsmodus zu versetzen.
Zu Ihrer Information: Dies sind die SQL Abfragen und Konsolenkommandos, welche ausgeführt werden, um die Datenbank für Matomo 4.11.0 zu aktualisieren
# Diese SQL Abfragen werden ausgeführt:
# 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 = '{\"config\":{\"layout\":\"33-33-33\"},\"columns\":[[{\"uniqueId\":\"widgetVisitsSummarygetSparklines\",\"parameters\":{\"module\":\"VisitsSummary\",\"action\":\"getSparklines\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetVisitorInterestgetNumberOfVisitsByDaysSinceLast\",\"parameters\":{\"module\":\"VisitorInterest\",\"action\":\"getNumberOfVisitsByDaysSinceLast\",\"widget\":1},\"isHidden\":true},{\"uniqueId\":\"widgetVisitTimegetVisitInformationPerLocalTime\",\"parameters\":{\"module\":\"VisitTime\",\"action\":\"getVisitInformationPerLocalTime\",\"widget\":1,\"isFooterExpandedInDashboard\":true},\"isHidden\":false},{\"uniqueId\":\"widgetVisitsSummarygetEvolutionGraphcolumnsArray\",\"parameters\":{\"module\":\"VisitsSummary\",\"action\":\"getEvolutionGraph\",\"columns\":[\"nb_visits\"],\"widget\":1,\"columns_to_display\":[\"nb_visits\"],\"rows\":[],\"rows_to_display\":[],\"isFooterExpandedInDashboard\":false},\"isHidden\":false},{\"uniqueId\":\"widgetLivewidget\",\"parameters\":{\"module\":\"Live\",\"action\":\"widget\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetVisitorInterestgetNumberOfVisitsPerVisitDuration\",\"parameters\":{\"module\":\"VisitorInterest\",\"action\":\"getNumberOfVisitsPerVisitDuration\",\"widget\":1},\"isHidden\":false}],[{\"uniqueId\":\"widgetVisitsSummaryindex\",\"parameters\":{\"module\":\"VisitsSummary\",\"action\":\"index\",\"widget\":1,\"isFooterExpandedInDashboard\":true},\"isHidden\":false}],[{\"uniqueId\":\"widgetReferrersgetWebsites\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getWebsites\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetReferrersgetKeywords\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getKeywords\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetDevicesDetectiongetBrowsers\",\"parameters\":{\"module\":\"DevicesDetection\",\"action\":\"getBrowsers\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetReferrersgetSearchEngines\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getSearchEngines\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetVisitTimegetVisitInformationPerServerTime\",\"parameters\":{\"module\":\"VisitTime\",\"action\":\"getVisitInformationPerServerTime\",\"widget\":1,\"isFooterExpandedInDashboard\":true,\"viewDataTable\":\"tableGoals\"},\"isHidden\":false},{\"uniqueId\":\"widgetExampleRssWidgetrssPiwik\",\"parameters\":{\"module\":\"ExampleRssWidget\",\"action\":\"rssPiwik\",\"widget\":1},\"isHidden\":false}]]}' WHERE iddashboard = '1';
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_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2013_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2014_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2014_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2015_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2015_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2016_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2016_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2017_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2017_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2018_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2018_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2019_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2019_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2020_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2020_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2021_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2021_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2021_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2021_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2021_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2021_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2021_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2021_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2021_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2021_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2021_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2021_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2021_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2021_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2021_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2021_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2021_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2021_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2021_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2021_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2021_11 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2021_11 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2021_12 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2021_12 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2022_01 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2022_01 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2022_02 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2022_02 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2022_03 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2022_03 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2022_04 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2022_04 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2022_05 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2022_05 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2022_06 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2022_06 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2022_07 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2022_07 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2022_08 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2022_08 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2022_09 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2022_09 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2022_10 SET name = 'Resolution_resolution' WHERE name = 'UserSettings_resolution';
UPDATE piwik_archive_blob_2022_10 SET name = 'Resolution_configuration' WHERE name = 'UserSettings_configuration';
UPDATE piwik_archive_blob_2013_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2013_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2014_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2015_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2016_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2017_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2018_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2019_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2020_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2021_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2021_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2021_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2021_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2021_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2021_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2021_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2021_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2021_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2021_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2021_11 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2021_12 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2022_01 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2022_02 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2022_03 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2022_04 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2022_05 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2022_06 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2022_07 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2022_08 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2022_09 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
UPDATE piwik_archive_blob_2022_10 SET name = 'DevicePlugins_plugin' WHERE name = 'UserSettings_plugin';
# Diese Konsolenkommandos werden ausgeführt:
./console plugin:activate "Ecommerce"
# Diese SQL Abfragen werden ausgeführt:
UPDATE piwik_archive_blob_2013_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2013_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2014_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2015_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2016_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2017_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2018_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2019_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2020_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2021_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2021_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2021_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2021_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2021_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2021_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2021_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2021_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2021_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2021_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2021_11 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2021_12 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2022_01 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2022_02 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2022_03 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2022_04 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2022_05 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2022_06 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2022_07 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2022_08 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2022_09 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
UPDATE piwik_archive_blob_2022_10 SET name = 'UserLanguage_language' WHERE name = 'UserSettings_language';
# Diese Konsolenkommandos werden ausgeführt:
./console plugin:activate "Monolog"
./console plugin:activate "Diagnostics"
# Diese SQL Abfragen werden ausgeführt:
delete from `piwik_option` where option_name like '%defaultReport%' and option_value='';
DROP TABLE IF EXISTS `piwik_site_setting`;
CREATE TABLE `piwik_site_setting` (`idsite` INTEGER(10) UNSIGNED NOT NULL AUTO_INCREMENT, `setting_name` VARCHAR(255) NOT NULL, `setting_value` LONGTEXT NOT NULL, PRIMARY KEY ( `idsite`, `setting_name` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_site` ADD COLUMN `exclude_unknown_urls` TINYINT(1) DEFAULT 0 AFTER `currency`;
# Diese Konsolenkommandos werden ausgeführt:
./console plugin:activate "Heartbeat"
# Diese SQL Abfragen werden ausgeführt:
UPDATE piwik_user_dashboard SET layout = '{\"config\":{\"layout\":\"33-33-33\"},\"columns\":[[{\"uniqueId\":\"widgetVisitsSummarygetforceView1viewDataTablesparklines\",\"parameters\":{\"module\":\"VisitsSummary\",\"action\":\"get\",\"widget\":1,\"forceView\":\"1\",\"viewDataTable\":\"sparklines\"},\"isHidden\":false},{\"uniqueId\":\"widgetVisitorInterestgetNumberOfVisitsByDaysSinceLast\",\"parameters\":{\"module\":\"VisitorInterest\",\"action\":\"getNumberOfVisitsByDaysSinceLast\",\"widget\":1},\"isHidden\":true},{\"uniqueId\":\"widgetVisitsSummarygetEvolutionGraphforceView1viewDataTablegraphEvolution\",\"parameters\":{\"module\":\"VisitsSummary\",\"action\":\"getEvolutionGraph\",\"columns\":[\"nb_visits\"],\"widget\":1,\"columns_to_display\":[\"nb_visits\"],\"rows\":[],\"rows_to_display\":[],\"isFooterExpandedInDashboard\":false,\"forceView\":\"1\",\"viewDataTable\":\"graphEvolution\"},\"isHidden\":false},{\"uniqueId\":\"widgetLivewidget\",\"parameters\":{\"module\":\"Live\",\"action\":\"widget\",\"widget\":1},\"isHidden\":false}],[{\"uniqueId\":\"widgetVisitOverviewWithGraph\",\"parameters\":{\"module\":\"CoreHome\",\"action\":\"renderWidgetContainer\",\"widget\":1,\"isFooterExpandedInDashboard\":true,\"containerId\":\"VisitOverviewWithGraph\"},\"isHidden\":false}],[{\"uniqueId\":\"widgetReferrersgetWebsites\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getWebsites\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetReferrersgetKeywords\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getKeywords\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetUserSettingsgetBrowser\",\"parameters\":{\"module\":\"UserSettings\",\"action\":\"getBrowser\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetReferrersgetSearchEngines\",\"parameters\":{\"module\":\"Referrers\",\"action\":\"getSearchEngines\",\"widget\":1},\"isHidden\":false},{\"uniqueId\":\"widgetExampleRssWidgetrssPiwik\",\"parameters\":{\"module\":\"ExampleRssWidget\",\"action\":\"rssPiwik\",\"widget\":1},\"isHidden\":false}]]}' WHERE iddashboard = '1';
CREATE TABLE `piwik_plugin_setting` (`plugin_name` VARCHAR(60) NOT NULL, `setting_name` VARCHAR(255) NOT NULL, `setting_value` LONGTEXT NOT NULL, `user_login` VARCHAR(100) NOT NULL DEFAULT '') ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_plugin_setting` ADD INDEX index_plugin_name_user_login (`plugin_name`, `user_login`);
DELETE FROM `piwik_option` WHERE `option_name` like "Plugin_%_Settings";
DROP TABLE IF EXISTS `piwik_site_setting`;
CREATE TABLE `piwik_site_setting` (`idsite` INTEGER(10) UNSIGNED NOT NULL, `plugin_name` VARCHAR(60) NOT NULL, `setting_name` VARCHAR(255) NOT NULL, `setting_value` LONGTEXT NOT NULL) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_site_setting` ADD INDEX(idsite, plugin_name);
ALTER TABLE `piwik_log_visit` CHANGE `idvisit` `idvisit` BIGINT(10) UNSIGNED NOT NULL AUTO_INCREMENT;
ALTER TABLE `piwik_log_conversion_item` CHANGE `idvisit` `idvisit` BIGINT(10) UNSIGNED NOT NULL;
ALTER TABLE `piwik_log_conversion` CHANGE `idvisit` `idvisit` BIGINT(10) UNSIGNED NOT NULL, CHANGE `idlink_va` `idlink_va` BIGINT(10) UNSIGNED default NULL;
ALTER TABLE `piwik_log_link_visit_action` CHANGE `idlink_va` `idlink_va` BIGINT(10) UNSIGNED NOT NULL AUTO_INCREMENT, CHANGE `idvisit` `idvisit` BIGINT(10) UNSIGNED NOT NULL, CHANGE `idaction_name_ref` `idaction_name_ref` INTEGER(10) UNSIGNED NULL;
ALTER TABLE `piwik_user` CHANGE `password` `password` VARCHAR(255) NOT NULL;
CREATE TABLE `piwik_privacy_logdata_anonymizations` (`idlogdata_anonymization` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `idsites` TEXT NULL DEFAULT NULL, `date_start` DATETIME NOT NULL, `date_end` DATETIME NOT NULL, `anonymize_ip` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `anonymize_location` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `anonymize_userid` TINYINT(1) UNSIGNED NOT NULL DEFAULT 0, `unset_visit_columns` TEXT NOT NULL DEFAULT '', `unset_link_visit_action_columns` TEXT NOT NULL DEFAULT '', `output` MEDIUMTEXT NULL DEFAULT NULL, `scheduled_date` DATETIME NULL, `job_start_date` DATETIME NULL, `job_finish_date` DATETIME NULL, `requester` VARCHAR(100) NOT NULL DEFAULT '', PRIMARY KEY ( `idlogdata_anonymization` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_privacy_logdata_anonymizations` ADD INDEX index_job_start_date (`job_start_date`);
ALTER TABLE `piwik_plugin_setting` ADD COLUMN `json_encoded` TINYINT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `piwik_site_setting` ADD COLUMN `json_encoded` TINYINT UNSIGNED NOT NULL DEFAULT 0;
ALTER TABLE `piwik_site_setting` CHANGE `idsite` `idsite` INTEGER(10) UNSIGNED NOT NULL;
ALTER TABLE `piwik_plugin_setting` ADD COLUMN `idplugin_setting` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `piwik_site_setting` ADD COLUMN `idsite_setting` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `piwik_log_profiling` ADD COLUMN `idprofiling` BIGINT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `piwik_access` CHANGE `access` `access` VARCHAR(50) NULL;
ALTER TABLE `piwik_access` DROP PRIMARY KEY;
ALTER TABLE `piwik_access` ADD COLUMN `idaccess` INT UNSIGNED NOT NULL PRIMARY KEY AUTO_INCREMENT;
ALTER TABLE `piwik_access` ADD INDEX index_loginidsite (`login`, `idsite`);
ALTER TABLE `piwik_user` ADD COLUMN `ts_password_modified` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP;
CREATE TABLE `piwik_report_subscriptions` (`idreport` INT(11) NOT NULL, `token` VARCHAR(100) NULL, `email` VARCHAR(100) NOT NULL, `ts_subscribed` TIMESTAMP DEFAULT CURRENT_TIMESTAMP, `ts_unsubscribed` TIMESTAMP NULL, PRIMARY KEY ( `idreport`, `email` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_report_subscriptions` ADD UNIQUE KEY unique_token (`token`);
ALTER TABLE `piwik_user` CHANGE `ts_password_modified` `ts_password_modified` TIMESTAMP NULL;
UPDATE `piwik_user` SET ts_password_modified = NULL;
ALTER TABLE `piwik_site` ADD COLUMN `creator_login` VARCHAR(100) NULL;
# Diese Konsolenkommandos werden ausgeführt:
./console plugin:activate "IntranetMeasurable"
# Diese SQL Abfragen werden ausgeführt:
ALTER TABLE `piwik_goal` ADD COLUMN `event_value_as_revenue` tinyint(4) NOT NULL default '0';
ALTER TABLE `piwik_report` ADD COLUMN `evolution_graph_within_period` TINYINT(4) NOT NULL DEFAULT 0;
ALTER TABLE `piwik_report` ADD COLUMN `evolution_graph_period_n` INT(11) NULL;
ALTER TABLE `piwik_user` ADD COLUMN `twofactor_secret` VARCHAR(40) NOT NULL DEFAULT '';
CREATE TABLE `piwik_twofactor_recovery_code` (`idrecoverycode` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `login` VARCHAR(100) NOT NULL, `recovery_code` VARCHAR(40) NOT NULL, PRIMARY KEY ( `idrecoverycode` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Diese Konsolenkommandos werden ausgeführt:
./console plugin:activate "TwoFactorAuth"
./console plugin:deactivate "GoogleAuthenticator"
# Diese SQL Abfragen werden ausgeführt:
CREATE TABLE `piwik_tracking_failure` (`idsite` BIGINT(20) UNSIGNED NOT NULL, `idfailure` SMALLINT UNSIGNED NOT NULL, `date_first_occurred` DATETIME NOT NULL, `request_url` MEDIUMTEXT NOT NULL, PRIMARY KEY ( `idsite`, `idfailure` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `piwik_brute_force_log` (`id_brute_force_log` bigint(11) NOT NULL AUTO_INCREMENT, `ip_address` VARCHAR(60) DEFAULT NULL, `attempted_at` datetime NOT NULL, PRIMARY KEY ( `id_brute_force_log` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_brute_force_log` ADD INDEX index_ip_address (`ip_address`);
ALTER TABLE `piwik_report` ADD COLUMN `period_param` VARCHAR(10) NULL;
# Diese Konsolenkommandos werden ausgeführt:
./console plugin:activate "Tour"
# Diese SQL Abfragen werden ausgeführt:
ALTER TABLE `piwik_goal` CHANGE `pattern_type` `pattern_type` varchar(25) NOT NULL;
CREATE TABLE `piwik_locks` (`key` VARCHAR(70) NOT NULL, `value` VARCHAR(255) NULL DEFAULT NULL, `expiry_time` BIGINT UNSIGNED DEFAULT 9999999999, PRIMARY KEY ( `key` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
# Diese Konsolenkommandos werden ausgeführt:
./console plugin:deactivate "ExamplePlugin"
./console plugin:deactivate "ExampleAPI"
# Diese SQL Abfragen werden ausgeführt:
UPDATE `piwik_option` SET option_value = 'https://download.db-ip.com/free/dbip-city-lite-2024-11.mmdb.gz' WHERE option_name = 'geoip2.loc_db_url' AND option_value = 'https://geolite.maxmind.com/download/geoip/database/GeoLite2-City.tar.gz';
UPDATE `piwik_option` SET option_value = 'https://download.db-ip.com/free/dbip-country-lite-2024-11.mmdb.gz' WHERE option_name = 'geoip2.loc_db_url' AND option_value = 'https://geolite.maxmind.com/download/geoip/database/GeoLite2-Country.tar.gz';
# Diese Konsolenkommandos werden ausgeführt:
./console core:matomo4-migrate-token-auths
# Diese SQL Abfragen werden ausgeführt:
CREATE TABLE `piwik_archive_invalidations` (`idinvalidation` BIGINT UNSIGNED NOT NULL AUTO_INCREMENT, `idarchive` INTEGER UNSIGNED NULL, `name` VARCHAR(255) NOT NULL, `idsite` INTEGER NOT NULL, `date1` DATE NOT NULL, `date2` DATE NOT NULL, `period` TINYINT UNSIGNED NOT NULL, `ts_invalidated` DATETIME NOT NULL, `status` TINYINT(1) UNSIGNED DEFAULT 0, `report` VARCHAR(255) NULL, PRIMARY KEY ( `idinvalidation` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_archive_invalidations` ADD INDEX index_idsite_dates_period_name (`idsite`, `date1`, `period`);
ALTER TABLE `piwik_user` DROP COLUMN `alias`;
DELETE FROM `piwik_session` WHERE length(id) > 190;
ALTER TABLE `piwik_session` CHANGE `id` `id` VARCHAR(191);
ALTER TABLE `piwik_site_url` CHANGE `url` `url` VARCHAR(190);
ALTER TABLE `piwik_option` CHANGE `option_name` `option_name` VARCHAR(191);
ALTER TABLE `piwik_log_action` CHANGE `name` `name` VARCHAR(4096);
ALTER TABLE `piwik_log_conversion` CHANGE `url` `url` VARCHAR(4096);
ALTER TABLE `piwik_log_link_visit_action` CHANGE `interaction_position` `pageview_position` MEDIUMINT UNSIGNED DEFAULT NULL;
# Diese Konsolenkommandos werden ausgeführt:
./console plugin:activate "BulkTracking"
./console plugin:deactivate "CustomPiwikJs"
./console plugin:uninstall "CustomPiwikJs"
# Diese SQL Abfragen werden ausgeführt:
ALTER TABLE `piwik_archive_numeric_2013_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2013_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2013_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2013_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2013_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2013_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2013_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2013_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2013_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2013_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2014_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2015_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2016_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2017_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2018_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2019_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2020_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2021_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_numeric_2022_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2013_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2013_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2013_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2013_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2013_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2013_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2013_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2013_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2013_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2013_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2014_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2015_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2016_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2017_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2018_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2019_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2020_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_11` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2021_12` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_01` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_02` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_03` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_04` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_05` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_06` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_07` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_08` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_09` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_archive_blob_2022_10` CHANGE `name` `name` VARCHAR(190);
ALTER TABLE `piwik_log_link_visit_action` ADD COLUMN `search_cat` VARCHAR(200) NULL, ADD COLUMN `search_count` INTEGER(10) UNSIGNED NULL, ADD COLUMN `time_dom_completion` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_dom_processing` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_network` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_on_load` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_server` MEDIUMINT(10) UNSIGNED NULL, ADD COLUMN `time_transfer` MEDIUMINT(10) UNSIGNED NULL;
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.search_cat', 'VARCHAR(200) NULL');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.search_count', 'INTEGER(10) UNSIGNED NULL');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_dom_completion', 'MEDIUMINT(10) UNSIGNED NULL');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_dom_processing', 'MEDIUMINT(10) UNSIGNED NULL');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_network', 'MEDIUMINT(10) UNSIGNED NULL');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_on_load', 'MEDIUMINT(10) UNSIGNED NULL');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_server', 'MEDIUMINT(10) UNSIGNED NULL');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_link_visit_action.time_transfer', 'MEDIUMINT(10) UNSIGNED NULL');
ALTER TABLE `piwik_log_visit` ADD COLUMN `visitor_seconds_since_first` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_order` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_last` INT(11) UNSIGNED NULL, ADD COLUMN `profilable` TINYINT(1) NULL;
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_visit.visitor_seconds_since_first', 'INT(11) UNSIGNED NULL1');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_visit.visitor_seconds_since_order', 'INT(11) UNSIGNED NULL1');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_visit.visitor_seconds_since_last', 'INT(11) UNSIGNED NULL');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_visit.profilable', 'TINYINT(1) NULL');
ALTER TABLE `piwik_log_conversion` ADD COLUMN `visitor_seconds_since_first` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_order` INT(11) UNSIGNED NULL;
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_conversion.visitor_seconds_since_first', 'INT(11) UNSIGNED NULL');
INSERT IGNORE INTO `piwik_option` (option_name, option_value) VALUES ('version_log_conversion.visitor_seconds_since_order', 'INT(11) UNSIGNED NULL');
UPDATE piwik_log_link_visit_action SET search_cat = if(custom_var_k4 = '_pk_scat', custom_var_v4, search_cat), search_count = if(custom_var_k5 = '_pk_scount', custom_var_v5, search_count) WHERE custom_var_k4 = '_pk_scat' or custom_var_k5 = '_pk_scount';
DELETE FROM `piwik_option` WHERE option_name IN ("geoip.updater_period", "geoip.loc_db_url", "geoip.isp_db_url", "geoip.org_db_url");
UPDATE piwik_log_visit SET visitor_seconds_since_first = visitor_days_since_first * 86400, visitor_seconds_since_order = visitor_days_since_order * 86400, visitor_seconds_since_last = visitor_days_since_last * 86400;
UPDATE piwik_log_conversion SET visitor_seconds_since_first = visitor_days_since_first * 86400, visitor_seconds_since_order = visitor_days_since_order * 86400;
ALTER TABLE `piwik_log_visit` DROP COLUMN `config_gears`, DROP COLUMN `config_director`, DROP COLUMN `visitor_days_since_first`, DROP COLUMN `visitor_days_since_order`, DROP COLUMN `visitor_days_since_last`;
ALTER TABLE `piwik_log_conversion` DROP COLUMN `visitor_days_since_first`, DROP COLUMN `visitor_days_since_order`;
# Diese Konsolenkommandos werden ausgeführt:
./console config:set --section="Tracker" --key="ignore_visits_cookie_name" --value="piwik_ignore"
./console plugin:activate "PagePerformance"
./console plugin:activate "CustomDimensions"
./console config:set --section="General" --key="login_allowlist_apply_to_reporting_api_requests" --value="0"
# Diese SQL Abfragen werden ausgeführt:
ALTER TABLE `piwik_archive_invalidations` ADD COLUMN `ts_started` DATETIME NULL;
# Diese Konsolenkommandos werden ausgeführt:
./console plugin:deactivate "ExampleTheme"
# Diese SQL Abfragen werden ausgeführt:
UPDATE piwik_user_token_auth SET hash_algo = "sha512" where hash_algo is null or hash_algo = "" ;
# Diese Konsolenkommandos werden ausgeführt:
./console plugin:uninstall "ExampleTheme"
./console plugin:deactivate "ExamplePlugin"
./console plugin:deactivate "ExampleLogTables"
./console plugin:deactivate "ExampleUI"
./console plugin:deactivate "ExampleReport"
./console plugin:deactivate "ExampleAPI"
./console plugin:deactivate "ExampleCommand"
./console plugin:deactivate "ExampleSettingsPlugin"
./console plugin:deactivate "ExampleTracker"
./console plugin:deactivate "ExampleVisualization"
./console plugin:uninstall "ExamplePlugin"
./console plugin:uninstall "ExampleLogTables"
./console plugin:uninstall "ExampleUI"
./console plugin:uninstall "ExampleReport"
./console plugin:uninstall "ExampleAPI"
./console plugin:uninstall "ExampleCommand"
./console plugin:uninstall "ExampleSettingsPlugin"
./console plugin:uninstall "ExampleTracker"
./console plugin:uninstall "ExampleVisualization"
# Diese SQL Abfragen werden ausgeführt:
UPDATE `piwik_archive_numeric_2013_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2014_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2016_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2017_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2018_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2019_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2020_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_11` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2021_12` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_03` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_04` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_05` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_06` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_07` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_08` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_09` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2022_10` SET `name` = 'done' WHERE `name` = 'done.';
ALTER TABLE `piwik_segment` ADD COLUMN `hash` CHAR(32) NULL AFTER `definition`;
UPDATE `piwik_segment` SET `hash` = '2d7334f02cb2dd0e3b650dbd6a0a8dc7' WHERE `idsegment` = '1';
UPDATE `piwik_segment` SET `hash` = 'a5697874d51330ae32364fbf4b5995db' WHERE `idsegment` = '2';
ALTER TABLE `piwik_brute_force_log` ADD COLUMN `login` VARCHAR(100) NULL;
# Diese Konsolenkommandos werden ausgeführt:
./console config:set --section="General" --key="login_allow_logme" --value="1"
# Diese SQL Abfragen werden ausgeführt:
ALTER TABLE `piwik_session` CHANGE `data` `data` MEDIUMTEXT;
# Diese Konsolenkommandos werden ausgeführt:
./console plugin:activate "CoreVue"
# Diese SQL Abfragen werden ausgeführt:
ALTER TABLE `piwik_user` ADD COLUMN `idchange_last_viewed` INTEGER UNSIGNED NULL;
CREATE TABLE `piwik_changes` (`idchange` INT(11) NOT NULL AUTO_INCREMENT, `created_time` DATETIME NOT NULL, `plugin_name` VARCHAR(255) NOT NULL, `version` VARCHAR(20) NOT NULL, `title` VARCHAR(255) NOT NULL, `description` TEXT NOT NULL, `link_name` VARCHAR(255) NULL, `link` VARCHAR(255) NULL, PRIMARY KEY ( `idchange` )) ENGINE=InnoDB DEFAULT CHARSET=utf8;
ALTER TABLE `piwik_changes` CHANGE `plugin_name` `plugin_name` VARCHAR(60) NOT NULL;
ALTER TABLE `piwik_changes` DROP INDEX `unique_plugin_version_title`;
ALTER TABLE `piwik_changes` ADD UNIQUE KEY unique_plugin_version_title (`plugin_name`, `version`, `title` (100));
ALTER TABLE `piwik_user` ADD COLUMN `invite_status` ENUM('accept','pending','decline','expired') DEFAULT 'accept';
ALTER TABLE `piwik_user` DROP COLUMN `invite_status`;
ALTER TABLE `piwik_user` ADD COLUMN `invite_token` VARCHAR(191) DEFAULT null;
ALTER TABLE `piwik_user` ADD COLUMN `invited_by` VARCHAR(100) DEFAULT null;
ALTER TABLE `piwik_user` ADD COLUMN `invite_expired_at` TIMESTAMP null DEFAULT null;
ALTER TABLE `piwik_user` ADD COLUMN `invite_accept_at` TIMESTAMP null DEFAULT null;
ALTER TABLE `piwik_user_language` ADD COLUMN `use_12_hour_clock` TINYINT(1) NOT NULL DEFAULT 0 AFTER `language`;
ALTER TABLE `piwik_goal` ADD COLUMN `description` VARCHAR(255) NOT NULL DEFAULT '' AFTER `name`;
ALTER TABLE `piwik_log_visit` ADD COLUMN `profilable` TINYINT(1) NULL, MODIFY COLUMN `visit_goal_buyer` TINYINT(1) NULL, MODIFY COLUMN `visit_goal_converted` TINYINT(1) NULL, MODIFY COLUMN `visitor_returning` TINYINT(1) NULL, ADD COLUMN `visitor_seconds_since_first` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_order` INT(11) UNSIGNED NULL, MODIFY COLUMN `visitor_count_visits` INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN `visit_entry_idaction_name` INTEGER(10) UNSIGNED NULL, MODIFY COLUMN `visit_entry_idaction_url` INTEGER(11) UNSIGNED NULL DEFAULT NULL, MODIFY COLUMN `visit_exit_idaction_name` INTEGER(10) UNSIGNED NULL, MODIFY COLUMN `visit_exit_idaction_url` INTEGER(10) UNSIGNED NULL DEFAULT 0, MODIFY COLUMN `visit_total_actions` INT(11) UNSIGNED NULL, ADD COLUMN `visit_total_interactions` MEDIUMINT UNSIGNED DEFAULT 0, MODIFY COLUMN `visit_total_searches` SMALLINT(5) UNSIGNED NULL, MODIFY COLUMN `referer_name` VARCHAR(255) NULL, MODIFY COLUMN `referer_url` VARCHAR(1500) NULL, MODIFY COLUMN `config_browser_engine` VARCHAR(10) NULL, MODIFY COLUMN `config_browser_name` VARCHAR(40) NULL, MODIFY COLUMN `config_browser_version` VARCHAR(20) NULL, ADD COLUMN `config_client_type` TINYINT( 1 ) NULL DEFAULT NULL, MODIFY COLUMN `config_device_brand` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, MODIFY COLUMN `config_device_model` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, MODIFY COLUMN `config_device_type` TINYINT( 100 ) NULL DEFAULT NULL, MODIFY COLUMN `config_os` CHAR(3) NULL, MODIFY COLUMN `visit_total_events` INT(11) UNSIGNED NULL, MODIFY COLUMN `visitor_localtime` TIME NULL, ADD COLUMN `visitor_seconds_since_last` INT(11) UNSIGNED NULL, MODIFY COLUMN `visit_total_time` INT(11) UNSIGNED NOT NULL, MODIFY COLUMN `location_country` CHAR(3) NULL, MODIFY COLUMN `location_latitude` decimal(9, 6) DEFAULT NULL, MODIFY COLUMN `location_longitude` decimal(9, 6) DEFAULT NULL, MODIFY COLUMN `location_region` char(3) DEFAULT NULL;
ALTER TABLE `piwik_log_conversion` MODIFY COLUMN `visitor_returning` TINYINT(1) NULL, ADD COLUMN `visitor_seconds_since_first` INT(11) UNSIGNED NULL, ADD COLUMN `visitor_seconds_since_order` INT(11) UNSIGNED NULL, MODIFY COLUMN `visitor_count_visits` INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN `referer_name` VARCHAR(255) NULL, ADD COLUMN `config_browser_name` VARCHAR(40) NULL, ADD COLUMN `config_client_type` TINYINT( 1 ) NULL DEFAULT NULL, ADD COLUMN `config_device_brand` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, ADD COLUMN `config_device_model` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, ADD COLUMN `config_device_type` TINYINT( 100 ) NULL DEFAULT NULL, MODIFY COLUMN `location_country` CHAR(3) NULL, MODIFY COLUMN `location_latitude` decimal(9, 6) DEFAULT NULL, MODIFY COLUMN `location_longitude` decimal(9, 6) DEFAULT NULL, MODIFY COLUMN `location_region` char(3) DEFAULT NULL;
ALTER TABLE `piwik_log_link_visit_action` ADD COLUMN `idpageview` CHAR(6) NULL DEFAULT NULL, ADD COLUMN `search_cat` VARCHAR(200) NULL, ADD COLUMN `search_count` INTEGER(10) UNSIGNED NULL, MODIFY COLUMN `time_spent_ref_action` INTEGER(10) UNSIGNED NULL;
Brauchen Sie Hilfe beim Upgrade von Matomo?
Wenn Sie Hilfe beim Upgrade von Matomo brauchen, sind die Ersteller von Matomo hier, um Ihnen zu einem erfolgreichen Upgrade zu helfen. Für Anleitungen, best practises und weiterführenden Support, kontaktiere die Matomo-Experten um das Upgrade sicher durchzuführen.
Sind Sie bereit?
Die Aktualisierung kann eine Weile dauern. Bitte haben Sie etwas Geduld.
Der Datei-Integritätscheck ist fehlgeschlagen und hat ein paar Fehler gemeldet. Du solltest die Probleme beheben und diese Seite neu laden, bis sie keine Fehler mehr anzeigt. |
Es wurden unerwartete Verzeichnisse in Ihrer Matomo-Installation gefunden. --> Bitte löschen Sie diese Verzeichnisse, um Fehler zu vermeiden. <-- Zu löschendes Verzeichnis: libs/PiwikTracker/java Zu löschendes Verzeichnis: libs/Zend/Auth Zu löschendes Verzeichnis: libs/Zend/Cache Zu löschendes Verzeichnis: libs/Zend/Config Zu löschendes Verzeichnis: libs/Zend/Feed Zu löschendes Verzeichnis: libs/Zend/Http Zu löschendes Verzeichnis: libs/Zend/Log Zu löschendes Verzeichnis: libs/Zend/Mail Zu löschendes Verzeichnis: libs/Zend/OpenId Zu löschendes Verzeichnis: libs/Zend/Validate Zu löschendes Verzeichnis: libs/bower_components Zu löschendes Verzeichnis: libs/jquery Zu löschendes Verzeichnis: libs/pChart2.1.3 Zu löschendes Verzeichnis: libs/sparkline Zu löschendes Verzeichnis: libs/tcpdf Zu löschendes Verzeichnis: themes Zu löschendes Verzeichnis: vendor/container-interop Zu löschendes Verzeichnis: vendor/doctrine Zu löschendes Verzeichnis: vendor/leafo Zu löschendes Verzeichnis: vendor/mnapoli Zu löschendes Verzeichnis: vendor/myclabs Zu löschendes Verzeichnis: vendor/piwik Zu löschendes Verzeichnis: vendor/twig/twig/ext Zu löschendes Verzeichnis: vendor/twig/twig/lib Um alle diese Verzeichnisse auf einmal zu löschen, kannst du folgenden Befehl ausführen: rm -Rf /usr/www/users/viuerf/dskpiwik/libs/PiwikTracker/java /usr/www/users/viuerf/dskpiwik/libs/Zend/Auth /usr/www/users/viuerf/dskpiwik/libs/Zend/Cache /usr/www/users/viuerf/dskpiwik/libs/Zend/Config /usr/www/users/viuerf/dskpiwik/libs/Zend/Feed /usr/www/users/viuerf/dskpiwik/libs/Zend/Http /usr/www/users/viuerf/dskpiwik/libs/Zend/Log /usr/www/users/viuerf/dskpiwik/libs/Zend/Mail /usr/www/users/viuerf/dskpiwik/libs/Zend/OpenId /usr/www/users/viuerf/dskpiwik/libs/Zend/Validate /usr/www/users/viuerf/dskpiwik/libs/bower_components /usr/www/users/viuerf/dskpiwik/libs/jquery /usr/www/users/viuerf/dskpiwik/libs/pChart2.1.3 /usr/www/users/viuerf/dskpiwik/libs/sparkline /usr/www/users/viuerf/dskpiwik/libs/tcpdf /usr/www/users/viuerf/dskpiwik/themes /usr/www/users/viuerf/dskpiwik/vendor/container-interop /usr/www/users/viuerf/dskpiwik/vendor/doctrine /usr/www/users/viuerf/dskpiwik/vendor/leafo /usr/www/users/viuerf/dskpiwik/vendor/mnapoli /usr/www/users/viuerf/dskpiwik/vendor/myclabs /usr/www/users/viuerf/dskpiwik/vendor/piwik /usr/www/users/viuerf/dskpiwik/vendor/twig/twig/ext /usr/www/users/viuerf/dskpiwik/vendor/twig/twig/lib |
Es wurden unerwartete Dateien in Ihrer Matomo-Installation gefunden. --> Bitte löschen Sie diese Dateien, um Fehler zu vermeiden. <-- Zu löschende Datei: README Zu löschende Datei: bower.json Zu löschende Datei: composer.json Zu löschende Datei: composer.lock Zu löschende Datei: config/config.ini.sample.php Zu löschende Datei: config/global.ini.auto-backup-before-update.php Zu löschende Datei: js/README Zu löschende Datei: lang/am.php Zu löschende Datei: lang/ar.php Zu löschende Datei: lang/be.php Zu löschende Datei: lang/bg.php Zu löschende Datei: lang/ca.php Zu löschende Datei: lang/cs.php Zu löschende Datei: lang/cy.php Zu löschende Datei: lang/da.php Zu löschende Datei: lang/de.php Zu löschende Datei: lang/el.php Zu löschende Datei: lang/en.php Zu löschende Datei: lang/es.php Zu löschende Datei: lang/et.php Zu löschende Datei: lang/eu.php Zu löschende Datei: lang/fa.php Zu löschende Datei: lang/fi.php Zu löschende Datei: lang/fr.php Zu löschende Datei: lang/gl.php Zu löschende Datei: lang/he.php Zu löschende Datei: lang/hr.php Zu löschende Datei: lang/hu.php Zu löschende Datei: lang/id.php Zu löschende Datei: lang/is.php Zu löschende Datei: lang/it.php Zu löschende Datei: lang/ja.php Zu löschende Datei: lang/ka.php Zu löschende Datei: lang/ko.php Zu löschende Datei: lang/lt.php Zu löschende Datei: lang/lv.php Zu löschende Datei: lang/nb.php Zu löschende Datei: lang/nl.php Zu löschende Datei: lang/nn.php Zu löschende Datei: lang/pl.php Zu löschende Datei: lang/pt-br.php Zu löschende Datei: lang/pt.php Zu löschende Datei: lang/ro.php Zu löschende Datei: lang/ru.php Zu löschende Datei: lang/sk.php Zu löschende Datei: lang/sl.php Zu löschende Datei: lang/sq.php Zu löschende Datei: lang/sr.php Zu löschende Datei: lang/sv.php Zu löschende Datei: lang/te.php Zu löschende Datei: lang/th.php Zu löschende Datei: lang/tr.php Zu löschende Datei: lang/uk.php Zu löschende Datei: lang/zh-cn.php Zu löschende Datei: lang/zh-tw.php Zu löschende Datei: libs/Archive_Tar/Tar.php Zu löschende Datei: libs/MaxMindGeoIP/geoip.inc Zu löschende Datei: libs/MaxMindGeoIP/geoipcity.inc Zu löschende Datei: libs/PEAR.php Zu löschende Datei: libs/PEAR/Exception.php Zu löschende Datei: libs/PEAR/FixPHP5PEARWarnings.php Zu löschende Datei: libs/PEAR/LICENSE Zu löschende Datei: libs/PEAR5.php Zu löschende Datei: libs/PclZip/lgpl-2.1.txt Zu löschende Datei: libs/PclZip/pclzip.lib.php Zu löschende Datei: libs/PiwikTracker/LICENSE.txt Zu löschende Datei: libs/README_LIBS Zu löschende Datei: libs/UserAgentParser/README Zu löschende Datei: libs/UserAgentParser/README.md Zu löschende Datei: libs/UserAgentParser/UserAgentParser.php Zu löschende Datei: libs/UserAgentParser/UserAgentParser.test.php Zu löschende Datei: libs/Zend/Mime.php Zu löschende Datei: libs/Zend/Mime/Decode.php Zu löschende Datei: libs/Zend/Mime/Exception.php Zu löschende Datei: libs/Zend/Mime/Message.php Zu löschende Datei: libs/Zend/Mime/Part.php Zu löschende Datei: libs/Zend/Uri.php Zu löschende Datei: libs/Zend/Uri/Exception.php Zu löschende Datei: libs/Zend/Uri/Http.php Zu löschende Datei: libs/cssmin/MIT-LICENSE.txt Zu löschende Datei: libs/cssmin/cssmin.php Zu löschende Datei: libs/html5shiv/html5shiv.js Zu löschende Datei: libs/javascript/json2.js Zu löschende Datei: libs/javascript/sprintf.js Zu löschende Datei: libs/jqplot/jqplot.core.js Zu löschende Datei: libs/jqplot/jqplot.lineRenderer.js Zu löschende Datei: libs/jqplot/jqplot.linearAxisRenderer.js Zu löschende Datei: libs/jqplot/jqplot.themeEngine.js Zu löschende Datei: libs/jqplot/plugins/jqplot.barRenderer.js Zu löschende Datei: libs/jqplot/plugins/jqplot.pieRenderer.js Zu löschende Datei: libs/jsmin/jsmin.php Zu löschende Datei: libs/swfobject/MIT-LICENSE.txt Zu löschende Datei: libs/swfobject/expressInstall.swf Zu löschende Datei: libs/swfobject/swfobject.js Zu löschende Datei: misc/How to install Piwik.html Zu löschende Datei: misc/composer/build-xhprof.sh Zu löschende Datei: misc/composer/clean-xhprof.sh Zu löschende Datei: misc/cron/archive.windows.ps1 Zu löschende Datei: misc/gpl-3.0.txt Zu löschende Datei: misc/internal-docs/content-tracking.md Zu löschende Datei: misc/log-analytics/README Zu löschende Datei: misc/others/ExamplePiwikTracker.php Zu löschende Datei: misc/others/api_internal_call.php Zu löschende Datei: misc/others/api_rest_call.php Zu löschende Datei: misc/others/cli-script-bootstrap.php Zu löschende Datei: misc/others/crossdomain.xml Zu löschende Datei: misc/others/db-schema-README Zu löschende Datei: misc/others/db-schema.png Zu löschende Datei: misc/others/db-schema.xml Zu löschende Datei: misc/others/diagram_general_request.jpg Zu löschende Datei: misc/others/diagram_general_request.vsd Zu löschende Datei: misc/others/download-count.txt Zu löschende Datei: misc/others/generateDoc.bat Zu löschende Datei: misc/others/generateDoc.sh Zu löschende Datei: misc/others/iframeWidget.htm Zu löschende Datei: misc/others/iframeWidget_localhost.php Zu löschende Datei: misc/others/phpdoc-config.ini Zu löschende Datei: misc/others/phpstorm-codestyles/Piwik_codestyle.xml Zu löschende Datei: misc/others/phpstorm-codestyles/README.md Zu löschende Datei: misc/others/stress.sh Zu löschende Datei: misc/others/svn-props-to-set-new-files.svnprops Zu löschende Datei: misc/others/uninstall-delete-piwik-directory.php Zu löschende Datei: misc/others/widget_example_lastvisits.html Zu löschende Datei: misc/phpstorm-codestyles/Piwik_codestyle.xml Zu löschende Datei: misc/phpstorm-codestyles/README.md Zu löschende Datei: misc/proxy-hide-piwik-url/piwik.php Zu löschende Datei: tests/README.txt Zu löschende Datei: vendor/composer/installed.json Zu löschende Datei: vendor/mustangostang/spyc/README Zu löschende Datei: vendor/mustangostang/spyc/composer.json Zu löschende Datei: vendor/symfony/console/Symfony/Component/Console/composer.json Zu löschende Datei: vendor/symfony/console/Symfony/Component/Console/phpunit.xml.dist Zu löschende Datei: vendor/tedivm/jshrink/composer.json Zu löschende Datei: vendor/tedivm/jshrink/package.xml Zu löschende Datei: vendor/tedivm/jshrink/phpunit.xml.dist Zu löschende Datei: vendor/twig/twig/composer.json Zu löschende Datei: vendor/twig/twig/phpunit.xml.dist Zu löschende Datei: vendor/twig/twig/.editorconfig Um alle diese Dateien auf einmal zu löschen, kannst du folgenden Befehl ausführen: rm "/usr/www/users/viuerf/dskpiwik/README" "/usr/www/users/viuerf/dskpiwik/bower.json" "/usr/www/users/viuerf/dskpiwik/composer.json" "/usr/www/users/viuerf/dskpiwik/composer.lock" "/usr/www/users/viuerf/dskpiwik/config/config.ini.sample.php" "/usr/www/users/viuerf/dskpiwik/config/global.ini.auto-backup-before-update.php" "/usr/www/users/viuerf/dskpiwik/js/README" "/usr/www/users/viuerf/dskpiwik/lang/am.php" "/usr/www/users/viuerf/dskpiwik/lang/ar.php" "/usr/www/users/viuerf/dskpiwik/lang/be.php" "/usr/www/users/viuerf/dskpiwik/lang/bg.php" "/usr/www/users/viuerf/dskpiwik/lang/ca.php" "/usr/www/users/viuerf/dskpiwik/lang/cs.php" "/usr/www/users/viuerf/dskpiwik/lang/cy.php" "/usr/www/users/viuerf/dskpiwik/lang/da.php" "/usr/www/users/viuerf/dskpiwik/lang/de.php" "/usr/www/users/viuerf/dskpiwik/lang/el.php" "/usr/www/users/viuerf/dskpiwik/lang/en.php" "/usr/www/users/viuerf/dskpiwik/lang/es.php" "/usr/www/users/viuerf/dskpiwik/lang/et.php" "/usr/www/users/viuerf/dskpiwik/lang/eu.php" "/usr/www/users/viuerf/dskpiwik/lang/fa.php" "/usr/www/users/viuerf/dskpiwik/lang/fi.php" "/usr/www/users/viuerf/dskpiwik/lang/fr.php" "/usr/www/users/viuerf/dskpiwik/lang/gl.php" "/usr/www/users/viuerf/dskpiwik/lang/he.php" "/usr/www/users/viuerf/dskpiwik/lang/hr.php" "/usr/www/users/viuerf/dskpiwik/lang/hu.php" "/usr/www/users/viuerf/dskpiwik/lang/id.php" "/usr/www/users/viuerf/dskpiwik/lang/is.php" "/usr/www/users/viuerf/dskpiwik/lang/it.php" "/usr/www/users/viuerf/dskpiwik/lang/ja.php" "/usr/www/users/viuerf/dskpiwik/lang/ka.php" "/usr/www/users/viuerf/dskpiwik/lang/ko.php" "/usr/www/users/viuerf/dskpiwik/lang/lt.php" "/usr/www/users/viuerf/dskpiwik/lang/lv.php" "/usr/www/users/viuerf/dskpiwik/lang/nb.php" "/usr/www/users/viuerf/dskpiwik/lang/nl.php" "/usr/www/users/viuerf/dskpiwik/lang/nn.php" "/usr/www/users/viuerf/dskpiwik/lang/pl.php" "/usr/www/users/viuerf/dskpiwik/lang/pt-br.php" "/usr/www/users/viuerf/dskpiwik/lang/pt.php" "/usr/www/users/viuerf/dskpiwik/lang/ro.php" "/usr/www/users/viuerf/dskpiwik/lang/ru.php" "/usr/www/users/viuerf/dskpiwik/lang/sk.php" "/usr/www/users/viuerf/dskpiwik/lang/sl.php" "/usr/www/users/viuerf/dskpiwik/lang/sq.php" "/usr/www/users/viuerf/dskpiwik/lang/sr.php" "/usr/www/users/viuerf/dskpiwik/lang/sv.php" "/usr/www/users/viuerf/dskpiwik/lang/te.php" rm "/usr/www/users/viuerf/dskpiwik/lang/th.php" "/usr/www/users/viuerf/dskpiwik/lang/tr.php" "/usr/www/users/viuerf/dskpiwik/lang/uk.php" "/usr/www/users/viuerf/dskpiwik/lang/zh-cn.php" "/usr/www/users/viuerf/dskpiwik/lang/zh-tw.php" "/usr/www/users/viuerf/dskpiwik/libs/Archive_Tar/Tar.php" "/usr/www/users/viuerf/dskpiwik/libs/MaxMindGeoIP/geoip.inc" "/usr/www/users/viuerf/dskpiwik/libs/MaxMindGeoIP/geoipcity.inc" "/usr/www/users/viuerf/dskpiwik/libs/PEAR.php" "/usr/www/users/viuerf/dskpiwik/libs/PEAR/Exception.php" "/usr/www/users/viuerf/dskpiwik/libs/PEAR/FixPHP5PEARWarnings.php" "/usr/www/users/viuerf/dskpiwik/libs/PEAR/LICENSE" "/usr/www/users/viuerf/dskpiwik/libs/PEAR5.php" "/usr/www/users/viuerf/dskpiwik/libs/PclZip/lgpl-2.1.txt" "/usr/www/users/viuerf/dskpiwik/libs/PclZip/pclzip.lib.php" "/usr/www/users/viuerf/dskpiwik/libs/PiwikTracker/LICENSE.txt" "/usr/www/users/viuerf/dskpiwik/libs/README_LIBS" "/usr/www/users/viuerf/dskpiwik/libs/UserAgentParser/README" "/usr/www/users/viuerf/dskpiwik/libs/UserAgentParser/README.md" "/usr/www/users/viuerf/dskpiwik/libs/UserAgentParser/UserAgentParser.php" "/usr/www/users/viuerf/dskpiwik/libs/UserAgentParser/UserAgentParser.test.php" "/usr/www/users/viuerf/dskpiwik/libs/Zend/Mime.php" "/usr/www/users/viuerf/dskpiwik/libs/Zend/Mime/Decode.php" "/usr/www/users/viuerf/dskpiwik/libs/Zend/Mime/Exception.php" "/usr/www/users/viuerf/dskpiwik/libs/Zend/Mime/Message.php" "/usr/www/users/viuerf/dskpiwik/libs/Zend/Mime/Part.php" "/usr/www/users/viuerf/dskpiwik/libs/Zend/Uri.php" "/usr/www/users/viuerf/dskpiwik/libs/Zend/Uri/Exception.php" "/usr/www/users/viuerf/dskpiwik/libs/Zend/Uri/Http.php" "/usr/www/users/viuerf/dskpiwik/libs/cssmin/MIT-LICENSE.txt" "/usr/www/users/viuerf/dskpiwik/libs/cssmin/cssmin.php" "/usr/www/users/viuerf/dskpiwik/libs/html5shiv/html5shiv.js" "/usr/www/users/viuerf/dskpiwik/libs/javascript/json2.js" "/usr/www/users/viuerf/dskpiwik/libs/javascript/sprintf.js" "/usr/www/users/viuerf/dskpiwik/libs/jqplot/jqplot.core.js" "/usr/www/users/viuerf/dskpiwik/libs/jqplot/jqplot.lineRenderer.js" "/usr/www/users/viuerf/dskpiwik/libs/jqplot/jqplot.linearAxisRenderer.js" "/usr/www/users/viuerf/dskpiwik/libs/jqplot/jqplot.themeEngine.js" "/usr/www/users/viuerf/dskpiwik/libs/jqplot/plugins/jqplot.barRenderer.js" "/usr/www/users/viuerf/dskpiwik/libs/jqplot/plugins/jqplot.pieRenderer.js" "/usr/www/users/viuerf/dskpiwik/libs/jsmin/jsmin.php" "/usr/www/users/viuerf/dskpiwik/libs/swfobject/MIT-LICENSE.txt" "/usr/www/users/viuerf/dskpiwik/libs/swfobject/expressInstall.swf" "/usr/www/users/viuerf/dskpiwik/libs/swfobject/swfobject.js" "/usr/www/users/viuerf/dskpiwik/misc/How to install Piwik.html" "/usr/www/users/viuerf/dskpiwik/misc/composer/build-xhprof.sh" "/usr/www/users/viuerf/dskpiwik/misc/composer/clean-xhprof.sh" "/usr/www/users/viuerf/dskpiwik/misc/cron/archive.windows.ps1" "/usr/www/users/viuerf/dskpiwik/misc/gpl-3.0.txt" "/usr/www/users/viuerf/dskpiwik/misc/internal-docs/content-tracking.md" rm "/usr/www/users/viuerf/dskpiwik/misc/log-analytics/README" "/usr/www/users/viuerf/dskpiwik/misc/others/ExamplePiwikTracker.php" "/usr/www/users/viuerf/dskpiwik/misc/others/api_internal_call.php" "/usr/www/users/viuerf/dskpiwik/misc/others/api_rest_call.php" "/usr/www/users/viuerf/dskpiwik/misc/others/cli-script-bootstrap.php" "/usr/www/users/viuerf/dskpiwik/misc/others/crossdomain.xml" "/usr/www/users/viuerf/dskpiwik/misc/others/db-schema-README" "/usr/www/users/viuerf/dskpiwik/misc/others/db-schema.png" "/usr/www/users/viuerf/dskpiwik/misc/others/db-schema.xml" "/usr/www/users/viuerf/dskpiwik/misc/others/diagram_general_request.jpg" "/usr/www/users/viuerf/dskpiwik/misc/others/diagram_general_request.vsd" "/usr/www/users/viuerf/dskpiwik/misc/others/download-count.txt" "/usr/www/users/viuerf/dskpiwik/misc/others/generateDoc.bat" "/usr/www/users/viuerf/dskpiwik/misc/others/generateDoc.sh" "/usr/www/users/viuerf/dskpiwik/misc/others/iframeWidget.htm" "/usr/www/users/viuerf/dskpiwik/misc/others/iframeWidget_localhost.php" "/usr/www/users/viuerf/dskpiwik/misc/others/phpdoc-config.ini" "/usr/www/users/viuerf/dskpiwik/misc/others/phpstorm-codestyles/Piwik_codestyle.xml" "/usr/www/users/viuerf/dskpiwik/misc/others/phpstorm-codestyles/README.md" "/usr/www/users/viuerf/dskpiwik/misc/others/stress.sh" "/usr/www/users/viuerf/dskpiwik/misc/others/svn-props-to-set-new-files.svnprops" "/usr/www/users/viuerf/dskpiwik/misc/others/uninstall-delete-piwik-directory.php" "/usr/www/users/viuerf/dskpiwik/misc/others/widget_example_lastvisits.html" "/usr/www/users/viuerf/dskpiwik/misc/phpstorm-codestyles/Piwik_codestyle.xml" "/usr/www/users/viuerf/dskpiwik/misc/phpstorm-codestyles/README.md" "/usr/www/users/viuerf/dskpiwik/misc/proxy-hide-piwik-url/piwik.php" "/usr/www/users/viuerf/dskpiwik/tests/README.txt" "/usr/www/users/viuerf/dskpiwik/vendor/composer/installed.json" "/usr/www/users/viuerf/dskpiwik/vendor/mustangostang/spyc/README" "/usr/www/users/viuerf/dskpiwik/vendor/mustangostang/spyc/composer.json" "/usr/www/users/viuerf/dskpiwik/vendor/symfony/console/Symfony/Component/Console/composer.json" "/usr/www/users/viuerf/dskpiwik/vendor/symfony/console/Symfony/Component/Console/phpunit.xml.dist" "/usr/www/users/viuerf/dskpiwik/vendor/tedivm/jshrink/composer.json" "/usr/www/users/viuerf/dskpiwik/vendor/tedivm/jshrink/package.xml" "/usr/www/users/viuerf/dskpiwik/vendor/tedivm/jshrink/phpunit.xml.dist" "/usr/www/users/viuerf/dskpiwik/vendor/twig/twig/composer.json" "/usr/www/users/viuerf/dskpiwik/vendor/twig/twig/phpunit.xml.dist" "/usr/www/users/viuerf/dskpiwik/vendor/twig/twig/.editorconfig" |