Database Upgrade Required

# These console commands will be run: 
./console plugin:deactivate "ExamplePlugin"
./console plugin:deactivate "ExampleLogTables"
./console plugin:deactivate "ExampleUI"
./console plugin:deactivate "ExampleReport"
./console plugin:deactivate "ExampleAPI"
./console plugin:deactivate "ExampleCommand"
./console plugin:deactivate "ExampleSettingsPlugin"
./console plugin:deactivate "ExampleTracker"
./console plugin:deactivate "ExampleVisualization"
./console plugin:uninstall "ExamplePlugin"
./console plugin:uninstall "ExampleLogTables"
./console plugin:uninstall "ExampleUI"
./console plugin:uninstall "ExampleReport"
./console plugin:uninstall "ExampleAPI"
./console plugin:uninstall "ExampleCommand"
./console plugin:uninstall "ExampleSettingsPlugin"
./console plugin:uninstall "ExampleTracker"
./console plugin:uninstall "ExampleVisualization"

# These SQL queries will be executed: 
UPDATE `piwik_archive_numeric_2013_01` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_02` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2013_03` 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_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_10` SET `name` = 'done' WHERE `name` = 'done.';
UPDATE `piwik_archive_numeric_2015_11` 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.';
ALTER TABLE `piwik_segment` ADD COLUMN `hash` CHAR(32) NULL AFTER `definition`;
ALTER TABLE `piwik_brute_force_log` ADD COLUMN `login` VARCHAR(100) NULL;

# These console commands will be run: 
./console config:set --section="General" --key="login_allow_logme" --value="1"

# These SQL queries will be executed: 
ALTER TABLE `piwik_session` CHANGE `data` `data` MEDIUMTEXT;

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

# These SQL queries will be executed: 
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_goal` ADD COLUMN `description` VARCHAR(255) NOT NULL DEFAULT '' AFTER `name`;
ALTER TABLE `piwik_log_visit` CHANGE `location_provider` `location_provider` VARCHAR(200) NULL;
ALTER TABLE `piwik_log_visit` MODIFY COLUMN `visit_goal_buyer` TINYINT(1) NULL, MODIFY COLUMN `visit_goal_converted` TINYINT(1) NULL, MODIFY COLUMN `visitor_returning` TINYINT(1) NULL, MODIFY COLUMN `visitor_count_visits` INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN `visit_entry_idaction_name` INTEGER(10) UNSIGNED NULL, MODIFY COLUMN `visit_entry_idaction_url` INTEGER(11) UNSIGNED NULL  DEFAULT NULL, MODIFY COLUMN `visit_exit_idaction_name` INTEGER(10) UNSIGNED NULL, MODIFY COLUMN `visit_exit_idaction_url` INTEGER(10) UNSIGNED NULL DEFAULT 0, MODIFY COLUMN `visit_total_actions` INT(11) UNSIGNED NULL, ADD COLUMN `visit_total_interactions` MEDIUMINT UNSIGNED DEFAULT 0, MODIFY COLUMN `visit_total_searches` SMALLINT(5) UNSIGNED NULL, MODIFY COLUMN `referer_name` VARCHAR(255) NULL, MODIFY COLUMN `referer_url` VARCHAR(1500) NULL, MODIFY COLUMN `location_browser_lang` VARCHAR(20) NULL, MODIFY COLUMN `config_browser_engine` VARCHAR(10) NULL, MODIFY COLUMN `config_browser_name` VARCHAR(40) NULL, MODIFY COLUMN `config_browser_version` VARCHAR(20) NULL, ADD COLUMN `config_client_type` TINYINT( 1 ) NULL DEFAULT NULL, MODIFY COLUMN `config_device_brand` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, MODIFY COLUMN `config_device_model` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, MODIFY COLUMN `config_device_type` TINYINT( 100 ) NULL DEFAULT NULL, MODIFY COLUMN `config_os` CHAR(3) NULL, MODIFY COLUMN `visit_total_events` INT(11) UNSIGNED NULL, MODIFY COLUMN `visitor_localtime` TIME NULL, ADD COLUMN `visitor_days_since_last` SMALLINT(5) UNSIGNED NULL, MODIFY COLUMN `config_resolution` VARCHAR(18) NULL, MODIFY COLUMN `config_cookie` TINYINT(1) NULL, ADD COLUMN `config_director` TINYINT(1) NULL, MODIFY COLUMN `config_flash` TINYINT(1) NULL, ADD COLUMN `config_gears` TINYINT(1) NULL, MODIFY COLUMN `config_java` TINYINT(1) NULL, MODIFY COLUMN `config_pdf` TINYINT(1) NULL, MODIFY COLUMN `config_quicktime` TINYINT(1) NULL, MODIFY COLUMN `config_realplayer` TINYINT(1) NULL, MODIFY COLUMN `config_silverlight` TINYINT(1) NULL, MODIFY COLUMN `config_windowsmedia` TINYINT(1) NULL, MODIFY COLUMN `visit_total_time` INT(11) UNSIGNED NOT NULL, MODIFY COLUMN `location_country` CHAR(3) NULL, MODIFY COLUMN `location_latitude` decimal(9, 6) DEFAULT NULL, MODIFY COLUMN `location_longitude` decimal(9, 6) DEFAULT NULL, MODIFY COLUMN `location_region` char(3) DEFAULT NULL;
ALTER TABLE `piwik_log_conversion` MODIFY COLUMN `visitor_returning` TINYINT(1) NULL, MODIFY COLUMN `visitor_count_visits` INT(11) UNSIGNED NOT NULL DEFAULT 0, MODIFY COLUMN `referer_name` VARCHAR(255) NULL, ADD COLUMN `config_browser_name` VARCHAR(40) NULL, ADD COLUMN `config_client_type` TINYINT( 1 ) NULL DEFAULT NULL, ADD COLUMN `config_device_brand` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, ADD COLUMN `config_device_model` VARCHAR( 100 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, ADD COLUMN `config_device_type` TINYINT( 100 ) NULL DEFAULT NULL, MODIFY COLUMN `location_country` CHAR(3) NULL, MODIFY COLUMN `location_latitude` decimal(9, 6) DEFAULT NULL, MODIFY COLUMN `location_longitude` decimal(9, 6) DEFAULT NULL, MODIFY COLUMN `location_region` char(3) DEFAULT NULL;
ALTER TABLE `piwik_log_link_visit_action` ADD COLUMN `idpageview` CHAR(6) NULL DEFAULT NULL, ADD COLUMN `interaction_position` SMALLINT UNSIGNED DEFAULT NULL, MODIFY COLUMN `time_spent_ref_action` INTEGER(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat2` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat3` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat4` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_cat5` INT(10) UNSIGNED NULL, ADD COLUMN `idaction_product_name` INT(10) UNSIGNED NULL, ADD COLUMN `product_price` DOUBLE NULL, ADD COLUMN `idaction_product_sku` INT(10) UNSIGNED NULL;