Denis Surkov Posted February 10 Posted February 10 (edited) Recently I can't upgrade my forum to new version. When I start upgrade, I get an error "There are some problems with your database which need to be fixed before you can start the upgrade". And it's not a small fix, whole code down below. If I press "Fix Automatically", after 2 minutes of waiting, I get this error The problems with your database could not be fixed automatically. CREATE TABLE `core_search_index_new` LIKE `core_search_index`; Table 'core_search_index_new' already exists So I ran every single query manually from MyAdmin. They all returned successful. After all this work, I went with the upgrade option again, and, received the very same error with the exact same "fixes" I need to do to my database, listed below. I press "Check Again", but it's not believing I did all this work and ask for a "fix". This is my second attempt to fix it. Before that, I uploading a fresh set of files from client area, then ran the upgrader from /admin/upgrade. The upgrade went okay, I hoped it will fix everything, but the next upgrade came and I get the same errors. Does that mean I'm stuck with manual upgrade only? My host's PHP is 8.3. I have a small community, with less than a 100 000 posts total. Do not use plugins. Â UPDATE `core_modules` SET `sys_module_title`='' WHERE `sys_module_title` IS NULL; UPDATE `core_modules` SET `sys_module_application`='' WHERE `sys_module_application` IS NULL; UPDATE `core_modules` SET `sys_module_key`='' WHERE `sys_module_key` IS NULL; CREATE TABLE `core_modules_new` LIKE `core_modules`; ALTER TABLE `core_modules_new` CHANGE COLUMN `sys_module_title` `sys_module_title` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , DROP INDEX `identifier`, DROP INDEX `sys_module_application`, CHANGE COLUMN `sys_module_application` `sys_module_application` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD UNIQUE KEY `identifier` (`sys_module_application`,`sys_module_key`,`sys_module_area`), ADD KEY `sys_module_application` (`sys_module_application`), DROP INDEX `sys_module_key`, CHANGE COLUMN `sys_module_key` `sys_module_key` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `sys_module_key` (`sys_module_key`), CHANGE COLUMN `sys_module_area` `sys_module_area` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT 'front' , CHANGE COLUMN `sys_module_default_controller` `sys_module_default_controller` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; INSERT IGNORE INTO `core_modules_new` SELECT * FROM `core_modules`; DROP TABLE `core_modules`; RENAME TABLE `core_modules_new` TO `core_modules`; UPDATE `core_applications` SET `app_author`='' WHERE `app_author` IS NULL; UPDATE `core_applications` SET `app_version`='' WHERE `app_version` IS NULL; UPDATE `core_applications` SET `app_directory`='' WHERE `app_directory` IS NULL; ALTER TABLE `core_applications` CHANGE COLUMN `app_author` `app_author` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `app_version` `app_version` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , DROP INDEX `app_directory`, CHANGE COLUMN `app_directory` `app_directory` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `app_directory` (`app_directory`(191)), CHANGE COLUMN `app_website` `app_website` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `app_update_check` `app_update_check` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `app_update_version` `app_update_version` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Json array of the latest version info returned by the update check URL', CHANGE COLUMN `app_disabled_groups` `app_disabled_groups` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `app_disabled_message` `app_disabled_message` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `app_diagnostic_url` `app_diagnostic_url` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The URL to send diagnostic reports to'; UPDATE `core_dev` SET `app_key`='' WHERE `app_key` IS NULL; UPDATE `core_dev` SET `working_version`='10000' WHERE `working_version` IS NULL; CREATE TABLE `core_dev_new` LIKE `core_dev`; ALTER TABLE `core_dev_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `app_key` `app_key` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Application key', ADD PRIMARY KEY (`app_key`(191)), CHANGE COLUMN `working_version` `working_version` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '10000' COMMENT 'The version ID being worked on, which can be the string \'working\'', CHANGE COLUMN `ran` `ran` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON array of queries ran'; INSERT IGNORE INTO `core_dev_new` SELECT * FROM `core_dev`; DROP TABLE `core_dev`; RENAME TABLE `core_dev_new` TO `core_dev`; UPDATE `core_members` SET `name`='' WHERE `name` IS NULL; UPDATE `core_members` SET `email`='' WHERE `email` IS NULL; UPDATE `core_members` SET `ip_address`='' WHERE `ip_address` IS NULL; UPDATE `core_members` SET `mgroup_others`='' WHERE `mgroup_others` IS NULL; UPDATE `core_members` SET `members_seo_name`='' WHERE `members_seo_name` IS NULL; UPDATE `core_members` SET `members_day_posts`='0,0' WHERE `members_day_posts` IS NULL; UPDATE `core_members` SET `pp_cover_photo`='' WHERE `pp_cover_photo` IS NULL; ALTER TABLE `core_members` DROP INDEX `name_index`, CHANGE COLUMN `name` `name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `name_index` (`name`(191)), DROP INDEX `email`, CHANGE COLUMN `email` `email` VARCHAR (150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `email` (`email`), DROP INDEX `ip_address`, CHANGE COLUMN `ip_address` `ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `ip_address` (`ip_address`), CHANGE COLUMN `auto_track` `auto_track` VARCHAR (256) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '0' , DROP INDEX `member_groups`, CHANGE COLUMN `mgroup_others` `mgroup_others` VARCHAR (245) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `member_groups` (`member_group_id`,`mgroup_others`(188)), CHANGE COLUMN `members_seo_name` `members_seo_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `members_cache` `members_cache` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `failed_logins` `failed_logins` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `members_pass_hash` `members_pass_hash` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `members_pass_salt` `members_pass_salt` VARCHAR (22) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `members_day_posts` `members_day_posts` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0,0' , CHANGE COLUMN `pp_last_visitors` `pp_last_visitors` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `pp_main_photo` `pp_main_photo` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `pp_thumb_photo` `pp_thumb_photo` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `pp_photo_type` `pp_photo_type` VARCHAR (20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `signature` `signature` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `pconversation_filters` `pconversation_filters` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `pp_customization` `pp_customization` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `timezone` `timezone` VARCHAR (64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `pp_cover_photo` `pp_cover_photo` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , DROP INDEX `profilesync`, CHANGE COLUMN `profilesync` `profilesync` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `profilesync` (`profilesync_lastsync`,`profilesync`(181)), CHANGE COLUMN `create_menu` `create_menu` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Cached contents of the \"Create\" drop down menu.', CHANGE COLUMN `member_title` `member_title` VARCHAR (64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `member_streams` `member_streams` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `mfa_details` `mfa_details` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `permission_array` `permission_array` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'A cache of the clubs and social groups that the member is in', CHANGE COLUMN `unique_hash` `unique_hash` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_sys_cp_sessions` SET `session_id`='' WHERE `session_id` IS NULL; UPDATE `core_sys_cp_sessions` SET `session_ip_address`='' WHERE `session_ip_address` IS NULL; UPDATE `core_sys_cp_sessions` SET `session_member_name`='' WHERE `session_member_name` IS NULL; UPDATE `core_sys_cp_sessions` SET `session_location`='' WHERE `session_location` IS NULL; CREATE TABLE `core_sys_cp_sessions_new` LIKE `core_sys_cp_sessions`; ALTER TABLE `core_sys_cp_sessions_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `session_id` `session_id` VARCHAR (128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD PRIMARY KEY (`session_id`), CHANGE COLUMN `session_ip_address` `session_ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `session_member_name` `session_member_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `session_location` `session_location` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `session_url` `session_url` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; INSERT IGNORE INTO `core_sys_cp_sessions_new` SELECT * FROM `core_sys_cp_sessions`; DROP TABLE `core_sys_cp_sessions`; RENAME TABLE `core_sys_cp_sessions_new` TO `core_sys_cp_sessions`; UPDATE `core_groups` SET `g_create_clubs`='public,open,closed,private' WHERE `g_create_clubs` IS NULL; UPDATE `core_groups` SET `g_club_allowed_nodes`='' WHERE `g_club_allowed_nodes` IS NULL; ALTER TABLE `core_groups` CHANGE COLUMN `g_edit_posts` `g_edit_posts` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `g_delete_own_posts` `g_delete_own_posts` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `g_icon` `g_icon` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `prefix` `prefix` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `suffix` `suffix` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `g_photo_max_vars` `g_photo_max_vars` VARCHAR (200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '100:200:200' , CHANGE COLUMN `g_signature_limits` `g_signature_limits` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `g_hide_own_posts` `g_hide_own_posts` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `g_lock_unlock_own` `g_lock_unlock_own` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `g_can_report` `g_can_report` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `g_create_clubs` `g_create_clubs` SET ('public','open','closed','private','readonly') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'public,open,closed,private' COMMENT 'The types of club this group can create', CHANGE COLUMN `g_club_allowed_nodes` `g_club_allowed_nodes` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'Node types that can be created in clubs, or * for all'; UPDATE `core_validating` SET `vid`='' WHERE `vid` IS NULL; UPDATE `core_validating` SET `ip_address`='0' WHERE `ip_address` IS NULL; UPDATE `core_validating` SET `prev_email`='0' WHERE `prev_email` IS NULL; CREATE TABLE `core_validating_new` LIKE `core_validating`; ALTER TABLE `core_validating_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `vid` `vid` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD PRIMARY KEY (`vid`), DROP INDEX `ip_address`, CHANGE COLUMN `ip_address` `ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0' , ADD KEY `ip_address` (`ip_address`), CHANGE COLUMN `prev_email` `prev_email` VARCHAR (150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0' , CHANGE COLUMN `ref` `ref` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'URL to redirect the user to after validation is complete'; INSERT IGNORE INTO `core_validating_new` SELECT * FROM `core_validating`; DROP TABLE `core_validating`; RENAME TABLE `core_validating_new` TO `core_validating`; UPDATE `core_sys_lang` SET `lang_short`='' WHERE `lang_short` IS NULL; UPDATE `core_sys_lang` SET `lang_title`='' WHERE `lang_title` IS NULL; ALTER TABLE `core_sys_lang` DROP INDEX `lang_short`, CHANGE COLUMN `lang_short` `lang_short` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `lang_short` (`lang_short`), CHANGE COLUMN `lang_title` `lang_title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `lang_update_url` `lang_update_url` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `lang_version` `lang_version` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `lang_update_data` `lang_update_data` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `lang_author_name` `lang_author_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `lang_author_url` `lang_author_url` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_sys_lang_words` SET `word_key`='' WHERE `word_key` IS NULL; CREATE TABLE `core_sys_lang_words_new` LIKE `core_sys_lang_words`; ALTER TABLE `core_sys_lang_words_new` DROP INDEX `word_key`, DROP INDEX `word_find`, CHANGE COLUMN `word_app` `word_app` VARCHAR (80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT 'The application key, if word belongs to an application', ADD UNIQUE KEY `word_key` (`word_key`,`word_app`,`lang_id`,`word_js`), ADD KEY `word_find` (`lang_id`,`word_app`), CHANGE COLUMN `word_key` `word_key` VARCHAR (64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The key', CHANGE COLUMN `word_default` `word_default` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The default value', CHANGE COLUMN `word_custom` `word_custom` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The current value', CHANGE COLUMN `word_default_version` `word_default_version` VARCHAR (10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The application/plugin version the word was last changed in', CHANGE COLUMN `word_custom_version` `word_custom_version` VARCHAR (10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The application/plugin version installed when this word was customised'; INSERT IGNORE INTO `core_sys_lang_words_new` SELECT * FROM `core_sys_lang_words`; DROP TABLE `core_sys_lang_words`; RENAME TABLE `core_sys_lang_words_new` TO `core_sys_lang_words`; ALTER TABLE `core_reputation_levels` CHANGE COLUMN `level_image` `level_image` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_sys_conf_settings` SET `conf_key`='' WHERE `conf_key` IS NULL; CREATE TABLE `core_sys_conf_settings_new` LIKE `core_sys_conf_settings`; ALTER TABLE `core_sys_conf_settings_new` DROP INDEX `conf_key`, CHANGE COLUMN `conf_key` `conf_key` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD UNIQUE KEY `conf_key` (`conf_key`), CHANGE COLUMN `conf_value` `conf_value` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `conf_default` `conf_default` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `conf_keywords` `conf_keywords` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `conf_app` `conf_app` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `conf_report` `conf_report` ENUM ('full','bool') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; INSERT IGNORE INTO `core_sys_conf_settings_new` SELECT * FROM `core_sys_conf_settings`; DROP TABLE `core_sys_conf_settings`; RENAME TABLE `core_sys_conf_settings_new` TO `core_sys_conf_settings`; UPDATE `core_admin_permission_rows` SET `row_id_type`='member' WHERE `row_id_type` IS NULL; CREATE TABLE `core_admin_permission_rows_new` LIKE `core_admin_permission_rows`; ALTER TABLE `core_admin_permission_rows_new` DROP INDEX `PRIMARY`, DROP INDEX `row_id_type`, CHANGE COLUMN `row_id_type` `row_id_type` VARCHAR (13) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'member' , ADD PRIMARY KEY (`row_id`,`row_id_type`), ADD KEY `row_id_type` (`row_id_type`), CHANGE COLUMN `row_perm_cache` `row_perm_cache` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; INSERT IGNORE INTO `core_admin_permission_rows_new` SELECT * FROM `core_admin_permission_rows`; DROP TABLE `core_admin_permission_rows`; RENAME TABLE `core_admin_permission_rows_new` TO `core_admin_permission_rows`; ALTER TABLE `core_member_ranks` CHANGE COLUMN `title` `title` VARCHAR (128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `icon` `icon` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_banfilters` SET `ban_type`='ip' WHERE `ban_type` IS NULL; ALTER TABLE `core_banfilters` DROP INDEX `ban_type`, CHANGE COLUMN `ban_type` `ban_type` VARCHAR (10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ip' , ADD KEY `ban_type` (`ban_type`), DROP INDEX `ban_content`, CHANGE COLUMN `ban_content` `ban_content` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `ban_content` (`ban_content`(191)), CHANGE COLUMN `ban_reason` `ban_reason` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; ALTER TABLE `core_pfields_content` CHANGE COLUMN `field_1` `field_1` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_pfields_data` SET `pf_type`='' WHERE `pf_type` IS NULL; UPDATE `core_pfields_data` SET `pf_member_hide`='all' WHERE `pf_member_hide` IS NULL; UPDATE `core_pfields_data` SET `pf_search_type`='' WHERE `pf_search_type` IS NULL; UPDATE `core_pfields_data` SET `pf_topic_hide`='hide' WHERE `pf_topic_hide` IS NULL; ALTER TABLE `core_pfields_data` CHANGE COLUMN `pf_content` `pf_content` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `pf_type` `pf_type` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `pf_member_hide` `pf_member_hide` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'all' , CHANGE COLUMN `pf_input_format` `pf_input_format` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `pf_format` `pf_format` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Custom formatting for topic view', CHANGE COLUMN `pf_search_type` `pf_search_type` VARCHAR (5) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `pf_profile_format` `pf_profile_format` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Custom formatting for profiles', CHANGE COLUMN `pf_topic_hide` `pf_topic_hide` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'hide' ; UPDATE `core_admin_logs` SET `appcomponent`='' WHERE `appcomponent` IS NULL; UPDATE `core_admin_logs` SET `module`='' WHERE `module` IS NULL; UPDATE `core_admin_logs` SET `controller`='' WHERE `controller` IS NULL; ALTER TABLE `core_admin_logs` CHANGE COLUMN `note` `note` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , DROP INDEX `ip_address`, CHANGE COLUMN `ip_address` `ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `ip_address` (`ip_address`), CHANGE COLUMN `appcomponent` `appcomponent` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `module` `module` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `controller` `controller` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `do` `do` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' , CHANGE COLUMN `lang_key` `lang_key` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `member_name` `member_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_permission_index` SET `app`='' WHERE `app` IS NULL; UPDATE `core_permission_index` SET `perm_type`='' WHERE `perm_type` IS NULL; UPDATE `core_permission_index` SET `perm_view`='' WHERE `perm_view` IS NULL; CREATE TABLE `core_permission_index_new` LIKE `core_permission_index`; ALTER TABLE `core_permission_index_new` DROP INDEX `perm_type`, CHANGE COLUMN `app` `app` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD UNIQUE KEY `perm_type` (`app`,`perm_type`,`perm_type_id`), DROP INDEX `perm_index`, CHANGE COLUMN `perm_type` `perm_type` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `perm_index` (`perm_type`,`perm_type_id`), CHANGE COLUMN `perm_view` `perm_view` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , CHANGE COLUMN `perm_2` `perm_2` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `perm_3` `perm_3` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `perm_4` `perm_4` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `perm_5` `perm_5` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `perm_6` `perm_6` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `perm_7` `perm_7` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `authorized_users` `authorized_users` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; INSERT IGNORE INTO `core_permission_index_new` SELECT * FROM `core_permission_index`; DROP TABLE `core_permission_index`; RENAME TABLE `core_permission_index_new` TO `core_permission_index`; UPDATE `core_notification_defaults` SET `notification_key`='' WHERE `notification_key` IS NULL; UPDATE `core_notification_defaults` SET `default`='' WHERE `default` IS NULL; UPDATE `core_notification_defaults` SET `disabled`='' WHERE `disabled` IS NULL; CREATE TABLE `core_notification_defaults_new` LIKE `core_notification_defaults`; ALTER TABLE `core_notification_defaults_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `notification_key` `notification_key` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Key', ADD PRIMARY KEY (`notification_key`), CHANGE COLUMN `default` `default` SET ('email','inline','push') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Default options', CHANGE COLUMN `disabled` `disabled` SET ('email','inline','push') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Disabled options'; INSERT IGNORE INTO `core_notification_defaults_new` SELECT * FROM `core_notification_defaults`; DROP TABLE `core_notification_defaults`; RENAME TABLE `core_notification_defaults_new` TO `core_notification_defaults`; ALTER TABLE `core_members_warn_actions` CHANGE COLUMN `wa_mq_unit` `wa_mq_unit` CHAR (1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `wa_rpa_unit` `wa_rpa_unit` CHAR (1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `wa_suspend_unit` `wa_suspend_unit` CHAR (1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; ALTER TABLE `core_members_warn_reasons` CHANGE COLUMN `wr_name` `wr_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `wr_remove_unit` `wr_remove_unit` CHAR (1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `wr_notes` `wr_notes` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_moderators` SET `type`='m' WHERE `type` IS NULL; CREATE TABLE `core_moderators_new` LIKE `core_moderators`; ALTER TABLE `core_moderators_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `type` `type` ENUM ('m','g') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'm' COMMENT 'Member or group', ADD PRIMARY KEY (`type`,`id`), CHANGE COLUMN `perms` `perms` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Permissions'; INSERT IGNORE INTO `core_moderators_new` SELECT * FROM `core_moderators`; DROP TABLE `core_moderators`; RENAME TABLE `core_moderators_new` TO `core_moderators`; UPDATE `core_attachments` SET `attach_ext`='' WHERE `attach_ext` IS NULL; UPDATE `core_attachments` SET `attach_file`='' WHERE `attach_file` IS NULL; UPDATE `core_attachments` SET `attach_location`='' WHERE `attach_location` IS NULL; UPDATE `core_attachments` SET `attach_thumb_location`='' WHERE `attach_thumb_location` IS NULL; UPDATE `core_attachments` SET `attach_post_key`='0' WHERE `attach_post_key` IS NULL; UPDATE `core_attachments` SET `attach_moderation_status`='skipped' WHERE `attach_moderation_status` IS NULL; ALTER TABLE `core_attachments` CHANGE COLUMN `attach_ext` `attach_ext` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `attach_file` `attach_file` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , DROP INDEX `attach_location`, CHANGE COLUMN `attach_location` `attach_location` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `attach_location` (`attach_location`(191)), DROP INDEX `attach_thumb_location`, CHANGE COLUMN `attach_thumb_location` `attach_thumb_location` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `attach_thumb_location` (`attach_thumb_location`(191)), DROP INDEX `attach_post_key`, CHANGE COLUMN `attach_post_key` `attach_post_key` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0' , ADD KEY `attach_post_key` (`attach_post_key`), CHANGE COLUMN `attach_moderation_status` `attach_moderation_status` ENUM ('skipped','approved','pending') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'skipped' COMMENT 'If this attachment has been flagged for moderation by the image scanner, the status of that', CHANGE COLUMN `attach_security_key` `attach_security_key` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Security key for this attachment that will be checked when viewing.', CHANGE COLUMN `attach_labels` `attach_labels` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Labels from image scanner'; UPDATE `core_sessions` SET `id`='0' WHERE `id` IS NULL; UPDATE `core_sessions` SET `seo_name`='' WHERE `seo_name` IS NULL; UPDATE `core_sessions` SET `browser`='' WHERE `browser` IS NULL; UPDATE `core_sessions` SET `current_appcomponent`='' WHERE `current_appcomponent` IS NULL; UPDATE `core_sessions` SET `current_module`='' WHERE `current_module` IS NULL; UPDATE `core_sessions` SET `uagent_key`='' WHERE `uagent_key` IS NULL; UPDATE `core_sessions` SET `uagent_version`='' WHERE `uagent_version` IS NULL; UPDATE `core_sessions` SET `uagent_type`='' WHERE `uagent_type` IS NULL; CREATE TABLE `core_sessions_new` LIKE `core_sessions`; ALTER TABLE `core_sessions_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `id` `id` VARCHAR (128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0' , ADD PRIMARY KEY (`id`), CHANGE COLUMN `member_name` `member_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `seo_name` `seo_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , DROP INDEX `member_id`, DROP INDEX `ip_address`, CHANGE COLUMN `ip_address` `ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `member_id` (`member_id`,`ip_address`), ADD KEY `ip_address` (`ip_address`,`member_id`), CHANGE COLUMN `browser` `browser` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , CHANGE COLUMN `current_appcomponent` `current_appcomponent` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `current_module` `current_module` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `current_controller` `current_controller` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' , CHANGE COLUMN `uagent_key` `uagent_key` VARCHAR (200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `uagent_version` `uagent_version` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `uagent_type` `uagent_type` VARCHAR (200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `location_url` `location_url` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `location_lang` `location_lang` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `location_data` `location_data` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `location_permissions` `location_permissions` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; INSERT IGNORE INTO `core_sessions_new` SELECT * FROM `core_sessions`; DROP TABLE `core_sessions`; RENAME TABLE `core_sessions_new` TO `core_sessions`; UPDATE `core_emoticons` SET `typed`='' WHERE `typed` IS NULL; UPDATE `core_emoticons` SET `image`='' WHERE `image` IS NULL; UPDATE `core_emoticons` SET `emo_set`='default' WHERE `emo_set` IS NULL; ALTER TABLE `core_emoticons` CHANGE COLUMN `typed` `typed` VARCHAR (128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `image` `image` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , DROP INDEX `emo_set`, CHANGE COLUMN `emo_set` `emo_set` VARCHAR (64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default' , ADD KEY `emo_set` (`emo_set`), CHANGE COLUMN `image_2x` `image_2x` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; ALTER TABLE `core_files` DROP INDEX `file`, CHANGE COLUMN `filename` `filename` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT 'Filename', ADD KEY `file` (`container`(95),`filename`(95)), CHANGE COLUMN `salt` `salt` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `container` `container` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; ALTER TABLE `core_files_temp` DROP INDEX `upload_key`, CHANGE COLUMN `upload_key` `upload_key` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Key for upload process', ADD KEY `upload_key` (`upload_key`), CHANGE COLUMN `filename` `filename` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT 'Filename', CHANGE COLUMN `mime` `mime` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `contents` `contents` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Path to file on disk', CHANGE COLUMN `storage_extension` `storage_extension` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `exif` `exif` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `labels` `labels` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_store` SET `store_key`='' WHERE `store_key` IS NULL; CREATE TABLE `core_store_new` LIKE `core_store`; ALTER TABLE `core_store_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `store_key` `store_key` VARCHAR (150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Key', ADD PRIMARY KEY (`store_key`); INSERT IGNORE INTO `core_store_new` SELECT * FROM `core_store`; DROP TABLE `core_store`; RENAME TABLE `core_store_new` TO `core_store`; ALTER TABLE `core_question_and_answer` CHANGE COLUMN `qa_answers` `qa_answers` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_share_links` SET `share_title`='' WHERE `share_title` IS NULL; UPDATE `core_share_links` SET `share_key`='' WHERE `share_key` IS NULL; ALTER TABLE `core_share_links` CHANGE COLUMN `share_title` `share_title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `share_key` `share_key` VARCHAR (50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `share_groups` `share_groups` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_incoming_emails` SET `rule_criteria_field`='' WHERE `rule_criteria_field` IS NULL; UPDATE `core_incoming_emails` SET `rule_criteria_type`='' WHERE `rule_criteria_type` IS NULL; UPDATE `core_incoming_emails` SET `rule_criteria_value`='' WHERE `rule_criteria_value` IS NULL; UPDATE `core_incoming_emails` SET `rule_app`='' WHERE `rule_app` IS NULL; ALTER TABLE `core_incoming_emails` CHANGE COLUMN `rule_criteria_field` `rule_criteria_field` VARCHAR (4) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `rule_criteria_type` `rule_criteria_type` VARCHAR (4) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `rule_criteria_value` `rule_criteria_value` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , CHANGE COLUMN `rule_app` `rule_app` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' ; UPDATE `core_spam_service_log` SET `log_msg`='' WHERE `log_msg` IS NULL; UPDATE `core_spam_service_log` SET `email_address`='' WHERE `email_address` IS NULL; UPDATE `core_spam_service_log` SET `ip_address`='' WHERE `ip_address` IS NULL; ALTER TABLE `core_spam_service_log` CHANGE COLUMN `log_msg` `log_msg` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `email_address` `email_address` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `ip_address` `ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' ; UPDATE `core_profanity_filters` SET `type`='' WHERE `type` IS NULL; UPDATE `core_profanity_filters` SET `action`='swap' WHERE `action` IS NULL; ALTER TABLE `core_profanity_filters` CHANGE COLUMN `type` `type` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `swop` `swop` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `action` `action` SET ('swap','moderate','block') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'swap' ; UPDATE `core_bulk_mail` SET `mail_subject`='' WHERE `mail_subject` IS NULL; UPDATE `core_bulk_mail` SET `mail_content`='' WHERE `mail_content` IS NULL; ALTER TABLE `core_bulk_mail` CHANGE COLUMN `mail_subject` `mail_subject` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `mail_content` `mail_content` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , CHANGE COLUMN `mail_opts` `mail_opts` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_tasks` SET `key`='' WHERE `key` IS NULL; UPDATE `core_tasks` SET `frequency`='' WHERE `frequency` IS NULL; CREATE TABLE `core_tasks_new` LIKE `core_tasks`; ALTER TABLE `core_tasks_new` DROP INDEX `app`, CHANGE COLUMN `app` `app` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The application key which owns the task.', ADD KEY `app` (`app`(191)), DROP INDEX `key`, CHANGE COLUMN `key` `key` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The task key.', ADD UNIQUE KEY `key` (`key`), CHANGE COLUMN `frequency` `frequency` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'DateInterval specification for the frequency the task runs.'; INSERT IGNORE INTO `core_tasks_new` SELECT * FROM `core_tasks`; DROP TABLE `core_tasks`; RENAME TABLE `core_tasks_new` TO `core_tasks`; ALTER TABLE `core_tasks_log` CHANGE COLUMN `log` `log` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_acronyms` SET `a_type`='acronym' WHERE `a_type` IS NULL; ALTER TABLE `core_acronyms` DROP INDEX `a_short`, CHANGE COLUMN `a_short` `a_short` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `a_short` (`a_short`(191)), CHANGE COLUMN `a_long` `a_long` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `a_type` `a_type` ENUM ('acronym','link') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'acronym' ; UPDATE `core_email_templates` SET `template_app`='' WHERE `template_app` IS NULL; UPDATE `core_email_templates` SET `template_name`='' WHERE `template_name` IS NULL; UPDATE `core_email_templates` SET `template_key`='' WHERE `template_key` IS NULL; CREATE TABLE `core_email_templates_new` LIKE `core_email_templates`; ALTER TABLE `core_email_templates_new` DROP INDEX `template_app`, CHANGE COLUMN `template_app` `template_app` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `template_app` (`template_app`(250)), CHANGE COLUMN `template_name` `template_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `template_content_html` `template_content_html` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `template_data` `template_data` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , DROP INDEX `template_key`, CHANGE COLUMN `template_key` `template_key` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD UNIQUE KEY `template_key` (`template_key`,`template_parent`), CHANGE COLUMN `template_content_plaintext` `template_content_plaintext` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; INSERT IGNORE INTO `core_email_templates_new` SELECT * FROM `core_email_templates`; DROP TABLE `core_email_templates`; RENAME TABLE `core_email_templates_new` TO `core_email_templates`; UPDATE `core_message_topics` SET `mt_title`='' WHERE `mt_title` IS NULL; ALTER TABLE `core_message_topics` DROP INDEX `mt_title`, CHANGE COLUMN `mt_title` `mt_title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD FULLTEXT KEY `mt_title` (`mt_title`(250)); UPDATE `core_message_posts` SET `msg_post_key`='0' WHERE `msg_post_key` IS NULL; UPDATE `core_message_posts` SET `msg_ip_address`='0' WHERE `msg_ip_address` IS NULL; ALTER TABLE `core_message_posts` DROP INDEX `msg_post`, CHANGE COLUMN `msg_post` `msg_post` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD FULLTEXT KEY `msg_post` (`msg_post`), CHANGE COLUMN `msg_post_key` `msg_post_key` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0' , DROP INDEX `msg_ip_address`, CHANGE COLUMN `msg_ip_address` `msg_ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0' , ADD KEY `msg_ip_address` (`msg_ip_address`); UPDATE `core_message_topic_user_map` SET `map_folder_id`='' WHERE `map_folder_id` IS NULL; ALTER TABLE `core_message_topic_user_map` CHANGE COLUMN `map_folder_id` `map_folder_id` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' ; UPDATE `core_mail_error_logs` SET `mlog_to`='' WHERE `mlog_to` IS NULL; UPDATE `core_mail_error_logs` SET `mlog_from`='' WHERE `mlog_from` IS NULL; ALTER TABLE `core_mail_error_logs` CHANGE COLUMN `mlog_to` `mlog_to` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , CHANGE COLUMN `mlog_from` `mlog_from` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `mlog_subject` `mlog_subject` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `mlog_content` `mlog_content` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `mlog_msg` `mlog_msg` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `mlog_smtp_log` `mlog_smtp_log` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `mlog_resend_data` `mlog_resend_data` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_rc_comments` SET `comment`='' WHERE `comment` IS NULL; ALTER TABLE `core_rc_comments` CHANGE COLUMN `comment` `comment` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , CHANGE COLUMN `author_name` `author_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , DROP INDEX `ip_address`, CHANGE COLUMN `ip_address` `ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `ip_address` (`ip_address`); UPDATE `core_rc_reports` SET `report`='' WHERE `report` IS NULL; ALTER TABLE `core_rc_reports` CHANGE COLUMN `report` `report` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , DROP INDEX `ip_address`, CHANGE COLUMN `ip_address` `ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The IP address of the user reporting the content', ADD KEY `ip_address` (`ip_address`); UPDATE `core_rc_index` SET `class`='' WHERE `class` IS NULL; UPDATE `core_rc_index` SET `status`='1' WHERE `status` IS NULL; ALTER TABLE `core_rc_index` DROP INDEX `content_lookup`, DROP INDEX `class_node`, CHANGE COLUMN `class` `class` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Indicates the type of content that was reported', ADD KEY `content_lookup` (`class`(171),`content_id`), ADD KEY `class_node` (`class`(191),`node_id`), DROP INDEX `report_count`, CHANGE COLUMN `status` `status` ENUM ('1','2','3') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '1' COMMENT '1 = New report. 2 = Under Review. 3 = Complete.', ADD KEY `report_count` (`perm_id`,`status`); UPDATE `core_item_markers` SET `item_key`='' WHERE `item_key` IS NULL; UPDATE `core_item_markers` SET `item_app`='core' WHERE `item_app` IS NULL; CREATE TABLE `core_item_markers_new` LIKE `core_item_markers`; ALTER TABLE `core_item_markers_new` DROP INDEX `combo_key`, CHANGE COLUMN `item_key` `item_key` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD UNIQUE KEY `combo_key` (`item_key`,`item_member_id`,`item_app`), DROP INDEX `marker_index`, CHANGE COLUMN `item_app` `item_app` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'core' , ADD KEY `marker_index` (`item_member_id`,`item_app`,`item_app_key_1`), CHANGE COLUMN `item_read_array` `item_read_array` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; INSERT IGNORE INTO `core_item_markers_new` SELECT * FROM `core_item_markers`; DROP TABLE `core_item_markers`; RENAME TABLE `core_item_markers_new` TO `core_item_markers`; UPDATE `core_upgrade_history` SET `upgrade_version_human`='' WHERE `upgrade_version_human` IS NULL; UPDATE `core_upgrade_history` SET `upgrade_app`='core' WHERE `upgrade_app` IS NULL; ALTER TABLE `core_upgrade_history` CHANGE COLUMN `upgrade_version_human` `upgrade_version_human` VARCHAR (200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , DROP INDEX `upgrades`, CHANGE COLUMN `upgrade_app` `upgrade_app` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'core' , ADD KEY `upgrades` (`upgrade_app`,`upgrade_version_id`); ALTER TABLE `core_members_warn_logs` CHANGE COLUMN `wl_note_member` `wl_note_member` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `wl_note_mods` `wl_note_mods` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `wl_mq` `wl_mq` VARCHAR (128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `wl_rpa` `wl_rpa` VARCHAR (128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `wl_suspend` `wl_suspend` VARCHAR (128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , DROP INDEX `content`, CHANGE COLUMN `wl_content_app` `wl_content_app` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `content` (`wl_content_app`,`wl_content_module`,`wl_content_id1`,`wl_content_id2`), CHANGE COLUMN `wl_content_id1` `wl_content_id1` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `wl_content_id2` `wl_content_id2` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `wl_content_module` `wl_content_module` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_plugins` SET `plugin_name`='' WHERE `plugin_name` IS NULL; UPDATE `core_plugins` SET `plugin_version_human`='1.0.0' WHERE `plugin_version_human` IS NULL; ALTER TABLE `core_plugins` CHANGE COLUMN `plugin_name` `plugin_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Name', CHANGE COLUMN `plugin_update_check` `plugin_update_check` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'URL to check for updates', CHANGE COLUMN `plugin_author` `plugin_author` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Author name', CHANGE COLUMN `plugin_website` `plugin_website` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Author website URL', CHANGE COLUMN `plugin_location` `plugin_location` VARCHAR (80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' COMMENT 'Folder name for IN_DEV mode', CHANGE COLUMN `plugin_version_human` `plugin_version_human` VARCHAR (14) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '1.0.0' COMMENT 'Currently installed version (human-readable)', CHANGE COLUMN `plugin_update_check_data` `plugin_update_check_data` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON data returned in last update check', CHANGE COLUMN `plugin_diagnostic_url` `plugin_diagnostic_url` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The URL to send diagnostic reports to.'; UPDATE `core_themes` SET `set_name`='' WHERE `set_name` IS NULL; UPDATE `core_themes` SET `set_key`='' WHERE `set_key` IS NULL; UPDATE `core_themes` SET `set_author_name`='' WHERE `set_author_name` IS NULL; UPDATE `core_themes` SET `set_author_url`='' WHERE `set_author_url` IS NULL; UPDATE `core_themes` SET `set_emo_dir`='default' WHERE `set_emo_dir` IS NULL; ALTER TABLE `core_themes` CHANGE COLUMN `set_name` `set_name` VARCHAR (200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `set_key` `set_key` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `set_parent_array` `set_parent_array` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `set_child_array` `set_child_array` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `set_permissions` `set_permissions` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `set_author_name` `set_author_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `set_author_url` `set_author_url` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `set_emo_dir` `set_emo_dir` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'default' , CHANGE COLUMN `set_skin_gen_data` `set_skin_gen_data` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `set_template_settings` `set_template_settings` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `set_editor_skin` `set_editor_skin` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `set_logo_data` `set_logo_data` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON data of logo url, width, height', CHANGE COLUMN `set_version` `set_version` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Human skin set version', CHANGE COLUMN `set_update_check` `set_update_check` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Remote URL to retrieve update data', CHANGE COLUMN `set_update_data` `set_update_data` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON update data retrieved from remote URL.', CHANGE COLUMN `set_css_map` `set_css_map` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `set_resource_map` `set_resource_map` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `set_cache_key` `set_cache_key` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The current cache key, updated when any template is changed to force disk caches to rebuild', CHANGE COLUMN `set_custom_header` `set_custom_header` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `set_custom_footer` `set_custom_footer` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_theme_templates` SET `template_group`='' WHERE `template_group` IS NULL; UPDATE `core_theme_templates` SET `template_master_key`='' WHERE `template_master_key` IS NULL; UPDATE `core_theme_templates` SET `template_app`='core' WHERE `template_app` IS NULL; CREATE TABLE `core_theme_templates_new` LIKE `core_theme_templates`; ALTER TABLE `core_theme_templates_new` DROP INDEX `unique_key`, DROP INDEX `template_name`, CHANGE COLUMN `template_group` `template_group` VARCHAR (80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD UNIQUE KEY `unique_key` (`template_set_id`,`template_location`(50),`template_app`(31),`template_group`(50),`template_name`(50)), ADD KEY `template_name` (`template_name`,`template_group`), CHANGE COLUMN `template_content` `template_content` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `template_name` `template_name` VARCHAR (80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `template_data` `template_data` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , DROP INDEX `template_master_key`, CHANGE COLUMN `template_master_key` `template_master_key` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `template_master_key` (`template_master_key`), CHANGE COLUMN `template_location` `template_location` VARCHAR (80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' , DROP INDEX `template_app`, CHANGE COLUMN `template_app` `template_app` VARCHAR (50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'core' , ADD KEY `template_app` (`template_app`), CHANGE COLUMN `template_version` `template_version` VARCHAR (10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; INSERT IGNORE INTO `core_theme_templates_new` SELECT * FROM `core_theme_templates`; DROP TABLE `core_theme_templates`; RENAME TABLE `core_theme_templates_new` TO `core_theme_templates`; UPDATE `core_theme_css` SET `css_location`='' WHERE `css_location` IS NULL; UPDATE `core_theme_css` SET `css_app`='0' WHERE `css_app` IS NULL; UPDATE `core_theme_css` SET `css_modules`='' WHERE `css_modules` IS NULL; UPDATE `core_theme_css` SET `css_master_key`='' WHERE `css_master_key` IS NULL; UPDATE `core_theme_css` SET `css_path`='' WHERE `css_path` IS NULL; UPDATE `core_theme_css` SET `css_name`='' WHERE `css_name` IS NULL; CREATE TABLE `core_theme_css_new` LIKE `core_theme_css`; ALTER TABLE `core_theme_css_new` DROP INDEX `unique_key`, CHANGE COLUMN `css_location` `css_location` VARCHAR (80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD UNIQUE KEY `unique_key` (`css_set_id`,`css_app`(27),`css_location`(44),`css_path`(66),`css_name`(44)), CHANGE COLUMN `css_content` `css_content` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , DROP INDEX `css_app`, CHANGE COLUMN `css_app` `css_app` VARCHAR (50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0' , ADD KEY `css_app` (`css_app`), CHANGE COLUMN `css_attributes` `css_attributes` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `css_modules` `css_modules` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `css_master_key` `css_master_key` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `css_path` `css_path` VARCHAR (120) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `css_name` `css_name` VARCHAR (80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `css_version` `css_version` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; INSERT IGNORE INTO `core_theme_css_new` SELECT * FROM `core_theme_css`; DROP TABLE `core_theme_css`; RENAME TABLE `core_theme_css_new` TO `core_theme_css`; UPDATE `core_theme_conflict` SET `conflict_type`='html' WHERE `conflict_type` IS NULL; UPDATE `core_theme_conflict` SET `conflict_app`='' WHERE `conflict_app` IS NULL; UPDATE `core_theme_conflict` SET `conflict_location`='' WHERE `conflict_location` IS NULL; UPDATE `core_theme_conflict` SET `conflict_path`='' WHERE `conflict_path` IS NULL; UPDATE `core_theme_conflict` SET `conflict_name`='' WHERE `conflict_name` IS NULL; ALTER TABLE `core_theme_conflict` DROP INDEX `conflict_set_id`, CHANGE COLUMN `conflict_type` `conflict_type` VARCHAR (10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'html' , ADD KEY `conflict_set_id` (`conflict_set_id`,`conflict_type`), CHANGE COLUMN `conflict_app` `conflict_app` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `conflict_location` `conflict_location` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `conflict_path` `conflict_path` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `conflict_name` `conflict_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `conflict_data` `conflict_data` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `conflict_content` `conflict_content` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_theme_content_history` SET `content_type`='html' WHERE `content_type` IS NULL; UPDATE `core_theme_content_history` SET `content_app`='' WHERE `content_app` IS NULL; UPDATE `core_theme_content_history` SET `content_location`='' WHERE `content_location` IS NULL; UPDATE `core_theme_content_history` SET `content_path`='' WHERE `content_path` IS NULL; UPDATE `core_theme_content_history` SET `content_name`='' WHERE `content_name` IS NULL; ALTER TABLE `core_theme_content_history` DROP INDEX `content_set_id`, CHANGE COLUMN `content_type` `content_type` VARCHAR (10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'html' , ADD KEY `content_set_id` (`content_set_id`,`content_type`), CHANGE COLUMN `content_app` `content_app` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `content_location` `content_location` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `content_path` `content_path` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `content_name` `content_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `content_data` `content_data` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `content_content` `content_content` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_theme_resources` SET `resource_app`='' WHERE `resource_app` IS NULL; UPDATE `core_theme_resources` SET `resource_location`='' WHERE `resource_location` IS NULL; UPDATE `core_theme_resources` SET `resource_path`='' WHERE `resource_path` IS NULL; UPDATE `core_theme_resources` SET `resource_name`='' WHERE `resource_name` IS NULL; ALTER TABLE `core_theme_resources` DROP INDEX `resource_app`, CHANGE COLUMN `resource_app` `resource_app` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `resource_app` (`resource_app`), CHANGE COLUMN `resource_location` `resource_location` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `resource_path` `resource_path` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `resource_name` `resource_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `resource_filename` `resource_filename` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'File object URI'; UPDATE `core_theme_settings_fields` SET `sc_key`='' WHERE `sc_key` IS NULL; UPDATE `core_theme_settings_fields` SET `sc_type`='' WHERE `sc_type` IS NULL; CREATE TABLE `core_theme_settings_fields_new` LIKE `core_theme_settings_fields`; ALTER TABLE `core_theme_settings_fields_new` DROP INDEX `replace_key`, CHANGE COLUMN `sc_key` `sc_key` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD UNIQUE KEY `replace_key` (`sc_set_id`,`sc_key`(90),`sc_app`(90)), CHANGE COLUMN `sc_type` `sc_type` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `sc_content` `sc_content` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , DROP INDEX `sc_lookup`, CHANGE COLUMN `sc_app` `sc_app` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT 'core' , ADD KEY `sc_lookup` (`sc_set_id`,`sc_app`), CHANGE COLUMN `sc_default` `sc_default` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `sc_tab_key` `sc_tab_key` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT 'custom' , CHANGE COLUMN `sc_title` `sc_title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `sc_condition` `sc_condition` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; INSERT IGNORE INTO `core_theme_settings_fields_new` SELECT * FROM `core_theme_settings_fields`; DROP TABLE `core_theme_settings_fields`; RENAME TABLE `core_theme_settings_fields_new` TO `core_theme_settings_fields`; ALTER TABLE `core_theme_settings_values` CHANGE COLUMN `sv_value` `sv_value` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_error_logs` SET `log_error_code`='0' WHERE `log_error_code` IS NULL; ALTER TABLE `core_error_logs` CHANGE COLUMN `log_error` `log_error` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `log_error_code` `log_error_code` VARCHAR (24) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0' , DROP INDEX `log_ip_address`, CHANGE COLUMN `log_ip_address` `log_ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `log_ip_address` (`log_ip_address`), CHANGE COLUMN `log_request_uri` `log_request_uri` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_admin_login_logs` SET `admin_ip_address`='0.0.0.0' WHERE `admin_ip_address` IS NULL; UPDATE `core_admin_login_logs` SET `admin_username`='' WHERE `admin_username` IS NULL; ALTER TABLE `core_admin_login_logs` DROP INDEX `admin_ip_address`, CHANGE COLUMN `admin_ip_address` `admin_ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0.0.0.0' , ADD KEY `admin_ip_address` (`admin_ip_address`), CHANGE COLUMN `admin_username` `admin_username` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `admin_request` `admin_request` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_hooks` SET `type`='' WHERE `type` IS NULL; UPDATE `core_hooks` SET `class`='' WHERE `class` IS NULL; UPDATE `core_hooks` SET `filename`='' WHERE `filename` IS NULL; ALTER TABLE `core_hooks` DROP INDEX `app`, CHANGE COLUMN `app` `app` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Application key, if belongs to app', ADD KEY `app` (`app`(191)), CHANGE COLUMN `type` `type` CHAR (1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'C for code, S for skin', CHANGE COLUMN `class` `class` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The class the hook overrides', CHANGE COLUMN `filename` `filename` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The filename on disk'; UPDATE `core_javascript` SET `javascript_app`='' WHERE `javascript_app` IS NULL; UPDATE `core_javascript` SET `javascript_location`='' WHERE `javascript_location` IS NULL; UPDATE `core_javascript` SET `javascript_path`='' WHERE `javascript_path` IS NULL; UPDATE `core_javascript` SET `javascript_name`='' WHERE `javascript_name` IS NULL; UPDATE `core_javascript` SET `javascript_type`='' WHERE `javascript_type` IS NULL; UPDATE `core_javascript` SET `javascript_version`='0' WHERE `javascript_version` IS NULL; UPDATE `core_javascript` SET `javascript_key`='' WHERE `javascript_key` IS NULL; CREATE TABLE `core_javascript_new` LIKE `core_javascript`; ALTER TABLE `core_javascript_new` DROP INDEX `javascript_lookup`, CHANGE COLUMN `javascript_app` `javascript_app` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD UNIQUE KEY `javascript_lookup` (`javascript_app`(25),`javascript_location`(25),`javascript_path`(79),`javascript_name`(119)), CHANGE COLUMN `javascript_location` `javascript_location` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `javascript_plugin` `javascript_plugin` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' , CHANGE COLUMN `javascript_path` `javascript_path` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `javascript_name` `javascript_name` VARCHAR (150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `javascript_type` `javascript_type` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `javascript_content` `javascript_content` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `javascript_version` `javascript_version` VARCHAR (10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0' , DROP INDEX `look_up_key`, CHANGE COLUMN `javascript_key` `javascript_key` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Look up key ', ADD KEY `look_up_key` (`javascript_key`); INSERT IGNORE INTO `core_javascript_new` SELECT * FROM `core_javascript`; DROP TABLE `core_javascript`; RENAME TABLE `core_javascript_new` TO `core_javascript`; UPDATE `core_announcements` SET `announce_title`='' WHERE `announce_title` IS NULL; UPDATE `core_announcements` SET `announce_seo_title`='' WHERE `announce_seo_title` IS NULL; UPDATE `core_announcements` SET `announce_app`='*' WHERE `announce_app` IS NULL; UPDATE `core_announcements` SET `announce_location`='*' WHERE `announce_location` IS NULL; UPDATE `core_announcements` SET `announce_page_location`='' WHERE `announce_page_location` IS NULL; ALTER TABLE `core_announcements` CHANGE COLUMN `announce_title` `announce_title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `announce_content` `announce_content` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `announce_seo_title` `announce_seo_title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `announce_ids` `announce_ids` VARCHAR (245) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `announce_app` `announce_app` VARCHAR (45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '*' , CHANGE COLUMN `announce_location` `announce_location` VARCHAR (45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '*' , CHANGE COLUMN `announce_permissions` `announce_permissions` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Comma-delimited list of Group IDs, or * for all', CHANGE COLUMN `announce_page_location` `announce_page_location` VARCHAR (45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Page location to show announcement', CHANGE COLUMN `announce_color` `announce_color` VARCHAR (45) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Page top announcement color', CHANGE COLUMN `announce_url` `announce_url` VARCHAR (2048) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Announcement URL'; UPDATE `core_seo_meta` SET `meta_url`='' WHERE `meta_url` IS NULL; ALTER TABLE `core_seo_meta` DROP INDEX `url`, CHANGE COLUMN `meta_url` `meta_url` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , ADD KEY `url` (`meta_url`(191)), CHANGE COLUMN `meta_tags` `meta_tags` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `meta_title` `meta_title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_notification_preferences` SET `notification_key`='' WHERE `notification_key` IS NULL; CREATE TABLE `core_notification_preferences_new` LIKE `core_notification_preferences`; ALTER TABLE `core_notification_preferences_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `notification_key` `notification_key` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Key', ADD PRIMARY KEY (`member_id`,`notification_key`), CHANGE COLUMN `preference` `preference` SET ('email','inline','push') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The chosen notification method(s)'; INSERT IGNORE INTO `core_notification_preferences_new` SELECT * FROM `core_notification_preferences`; DROP TABLE `core_notification_preferences`; RENAME TABLE `core_notification_preferences_new` TO `core_notification_preferences`; UPDATE `core_notifications` SET `notification_app`='' WHERE `notification_app` IS NULL; UPDATE `core_notifications` SET `notification_key`='' WHERE `notification_key` IS NULL; ALTER TABLE `core_notifications` CHANGE COLUMN `notification_app` `notification_app` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The application that owns this type of notification', CHANGE COLUMN `notification_key` `notification_key` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The notification key', DROP INDEX `item_lookup`, CHANGE COLUMN `item_class` `item_class` VARCHAR (128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The class for the item the notification is about', ADD KEY `item_lookup` (`item_class`,`item_id`), CHANGE COLUMN `member_data` `member_data` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON-encoded merge data', DROP INDEX `subitem_lookup`, CHANGE COLUMN `item_sub_class` `item_sub_class` VARCHAR (128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Item Sub Class for Comments and Reviews', ADD KEY `subitem_lookup` (`item_sub_class`,`item_sub_id`), CHANGE COLUMN `extra` `extra` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON-encoded additional data'; UPDATE `core_attachments_map` SET `location_key`='' WHERE `location_key` IS NULL; ALTER TABLE `core_attachments_map` DROP INDEX `map_lookup`, CHANGE COLUMN `location_key` `location_key` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The editor location the content claiming this attachment has come from', ADD KEY `map_lookup` (`location_key`(210),`id1`,`id2`), DROP INDEX `temp_key`, CHANGE COLUMN `temp` `temp` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Temporary key for content claiming attachment', ADD KEY `temp_key` (`temp`), CHANGE COLUMN `id3` `id3` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Arbitrary data for content claiming attachment'; UPDATE `core_leaders_groups` SET `group_name`='' WHERE `group_name` IS NULL; UPDATE `core_leaders_groups` SET `group_template`='' WHERE `group_template` IS NULL; ALTER TABLE `core_leaders_groups` CHANGE COLUMN `group_name` `group_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `group_template` `group_template` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' ; UPDATE `core_leaders` SET `leader_type`='m' WHERE `leader_type` IS NULL; CREATE TABLE `core_leaders_new` LIKE `core_leaders`; ALTER TABLE `core_leaders_new` DROP INDEX `leader_type`, CHANGE COLUMN `leader_type` `leader_type` ENUM ('m','g') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'm' COMMENT 'Record is for member (m) or group (g)', ADD UNIQUE KEY `leader_type` (`leader_type`,`leader_type_id`); INSERT IGNORE INTO `core_leaders_new` SELECT * FROM `core_leaders`; DROP TABLE `core_leaders`; RENAME TABLE `core_leaders_new` TO `core_leaders`; ALTER TABLE `core_file_storage` CHANGE COLUMN `method` `method` VARCHAR (128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The storage method', CHANGE COLUMN `configuration` `configuration` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON object of configuration options'; UPDATE `core_advertisements` SET `ad_location`='' WHERE `ad_location` IS NULL; ALTER TABLE `core_advertisements` CHANGE COLUMN `ad_location` `ad_location` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'Stores the location for the advertisement to display', CHANGE COLUMN `ad_html` `ad_html` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `ad_images` `ad_images` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Stores a JSON array of images to use for this ad (small, medium and large)', CHANGE COLUMN `ad_link` `ad_link` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Link used by image advertisements', CHANGE COLUMN `ad_exempt` `ad_exempt` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON array of group IDs exempt from this ad', CHANGE COLUMN `ad_html_https` `ad_html_https` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Optional HTTPS version of ad', CHANGE COLUMN `ad_maximum_unit` `ad_maximum_unit` VARCHAR (1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Type of maximum value (for image ads only)', CHANGE COLUMN `ad_additional_settings` `ad_additional_settings` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON array of additional settings', CHANGE COLUMN `ad_image_alt` `ad_image_alt` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Alt text for web-based image ads, or for plaintext emails'; UPDATE `core_edit_history` SET `class`='' WHERE `class` IS NULL; UPDATE `core_edit_history` SET `old`='' WHERE `old` IS NULL; UPDATE `core_edit_history` SET `new`='' WHERE `new` IS NULL; ALTER TABLE `core_edit_history` DROP INDEX `edit_log`, CHANGE COLUMN `class` `class` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The comment class', ADD KEY `edit_log` (`class`(220),`comment_id`,`time`), CHANGE COLUMN `old` `old` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The previous comment text', CHANGE COLUMN `new` `new` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The new comment text', CHANGE COLUMN `reason` `reason` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'User-provided reason for editing'; UPDATE `core_acp_search_index` SET `url`='' WHERE `url` IS NULL; UPDATE `core_acp_search_index` SET `keyword`='' WHERE `keyword` IS NULL; UPDATE `core_acp_search_index` SET `app`='' WHERE `app` IS NULL; UPDATE `core_acp_search_index` SET `lang_key`='' WHERE `lang_key` IS NULL; ALTER TABLE `core_acp_search_index` CHANGE COLUMN `url` `url` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The query string', DROP INDEX `keyword`, CHANGE COLUMN `keyword` `keyword` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The keyword', ADD KEY `keyword` (`keyword`(191)), DROP INDEX `app`, CHANGE COLUMN `app` `app` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The application key', ADD KEY `app` (`app`(191)), CHANGE COLUMN `lang_key` `lang_key` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The language key to use for the result link', CHANGE COLUMN `restriction` `restriction` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'If applicable, the ACP restriction key that should be checked for this result'; UPDATE `core_moderator_logs` SET `appcomponent`='' WHERE `appcomponent` IS NULL; UPDATE `core_moderator_logs` SET `module`='' WHERE `module` IS NULL; UPDATE `core_moderator_logs` SET `controller`='' WHERE `controller` IS NULL; UPDATE `core_moderator_logs` SET `lang_key`='' WHERE `lang_key` IS NULL; ALTER TABLE `core_moderator_logs` CHANGE COLUMN `note` `note` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , DROP INDEX `ip_address`, CHANGE COLUMN `ip_address` `ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `ip_address` (`ip_address`), CHANGE COLUMN `appcomponent` `appcomponent` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `module` `module` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `controller` `controller` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `do` `do` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' , CHANGE COLUMN `lang_key` `lang_key` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , DROP INDEX `class`, CHANGE COLUMN `class` `class` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `class` (`class`(191)), CHANGE COLUMN `member_name` `member_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' ; UPDATE `core_widgets` SET `key`='' WHERE `key` IS NULL; UPDATE `core_widgets` SET `class`='' WHERE `class` IS NULL; UPDATE `core_widgets` SET `default_area`='sidebar' WHERE `default_area` IS NULL; UPDATE `core_widgets` SET `menu_style`='menu' WHERE `menu_style` IS NULL; CREATE TABLE `core_widgets_new` LIKE `core_widgets`; ALTER TABLE `core_widgets_new` DROP INDEX `widget_key`, CHANGE COLUMN `key` `key` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The widget key', ADD UNIQUE KEY `widget_key` (`key`(191)), DROP INDEX `widget_app`, CHANGE COLUMN `app` `app` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The application which owns the widget (if applicable)', ADD KEY `widget_app` (`app`(191)), DROP INDEX `widget_plugin`, CHANGE COLUMN `plugin` `plugin` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The plugin which owns the widget (if applicable)', ADD KEY `widget_plugin` (`plugin`(191)), CHANGE COLUMN `class` `class` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'What type of widget is this? e.g. \\IPS\\Widget\\StaticCache', CHANGE COLUMN `caches` `caches` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON encoded array of cache keys to be referenced when deleting caches', CHANGE COLUMN `restrict` `restrict` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON array of owner app restrictions (e.g. core restricts to sidebar only, content restricts to IP.Content only)', CHANGE COLUMN `default_area` `default_area` VARCHAR (80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'sidebar' COMMENT 'If no sidebar configuration is available for a page, all of the widgets for that app are loaded. This field determines which area on the page the default will show.', CHANGE COLUMN `menu_style` `menu_style` SET ('menu','modal') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'menu' ; INSERT IGNORE INTO `core_widgets_new` SELECT * FROM `core_widgets`; DROP TABLE `core_widgets`; RENAME TABLE `core_widgets_new` TO `core_widgets`; UPDATE `core_tags` SET `tag_aai_lookup`='' WHERE `tag_aai_lookup` IS NULL; UPDATE `core_tags` SET `tag_aap_lookup`='' WHERE `tag_aap_lookup` IS NULL; UPDATE `core_tags` SET `tag_meta_app`='' WHERE `tag_meta_app` IS NULL; UPDATE `core_tags` SET `tag_meta_area`='' WHERE `tag_meta_area` IS NULL; ALTER TABLE `core_tags` DROP INDEX `tag_aai_lookup`, CHANGE COLUMN `tag_aai_lookup` `tag_aai_lookup` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `tag_aai_lookup` (`tag_aai_lookup`), DROP INDEX `tag_aap_lookup`, CHANGE COLUMN `tag_aap_lookup` `tag_aap_lookup` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `tag_aap_lookup` (`tag_aap_lookup`(27),`tag_text`(164)), DROP INDEX `tag_app`, CHANGE COLUMN `tag_meta_app` `tag_meta_app` VARCHAR (200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `tag_app` (`tag_meta_app`(90),`tag_meta_area`(90),`tag_meta_id`), CHANGE COLUMN `tag_meta_area` `tag_meta_area` VARCHAR (200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , DROP INDEX `tag_text`, CHANGE COLUMN `tag_text` `tag_text` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `tag_text` (`tag_text`(191)); UPDATE `core_tags_cache` SET `tag_cache_key`='' WHERE `tag_cache_key` IS NULL; CREATE TABLE `core_tags_cache_new` LIKE `core_tags_cache`; ALTER TABLE `core_tags_cache_new` DROP INDEX `tag_cache_key`, CHANGE COLUMN `tag_cache_key` `tag_cache_key` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD UNIQUE KEY `tag_cache_key` (`tag_cache_key`), CHANGE COLUMN `tag_cache_text` `tag_cache_text` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; INSERT IGNORE INTO `core_tags_cache_new` SELECT * FROM `core_tags_cache`; DROP TABLE `core_tags_cache`; RENAME TABLE `core_tags_cache_new` TO `core_tags_cache`; UPDATE `core_tags_perms` SET `tag_perm_aai_lookup`='' WHERE `tag_perm_aai_lookup` IS NULL; UPDATE `core_tags_perms` SET `tag_perm_aap_lookup`='' WHERE `tag_perm_aap_lookup` IS NULL; UPDATE `core_tags_perms` SET `tag_perm_text`='' WHERE `tag_perm_text` IS NULL; CREATE TABLE `core_tags_perms_new` LIKE `core_tags_perms`; ALTER TABLE `core_tags_perms_new` DROP INDEX `tag_perm_aai_lookup`, CHANGE COLUMN `tag_perm_aai_lookup` `tag_perm_aai_lookup` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD UNIQUE KEY `tag_perm_aai_lookup` (`tag_perm_aai_lookup`), DROP INDEX `tag_perm_aap_lookup`, CHANGE COLUMN `tag_perm_aap_lookup` `tag_perm_aap_lookup` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `tag_perm_aap_lookup` (`tag_perm_aap_lookup`), DROP INDEX `tag_lookup`, CHANGE COLUMN `tag_perm_text` `tag_perm_text` VARCHAR (2000) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `tag_lookup` (`tag_perm_text`(249),`tag_perm_visible`); INSERT IGNORE INTO `core_tags_perms_new` SELECT * FROM `core_tags_perms`; DROP TABLE `core_tags_perms`; RENAME TABLE `core_tags_perms_new` TO `core_tags_perms`; UPDATE `core_reputation_index` SET `app`='' WHERE `app` IS NULL; UPDATE `core_reputation_index` SET `type`='' WHERE `type` IS NULL; UPDATE `core_reputation_index` SET `class_type_id_hash`='' WHERE `class_type_id_hash` IS NULL; ALTER TABLE `core_reputation_index` DROP INDEX `app`, DROP INDEX `sidebar_lookup`, CHANGE COLUMN `app` `app` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `app` (`app`,`type`,`type_id`,`member_id`,`member_received`), ADD KEY `sidebar_lookup` (`app`,`type`,`item_id`,`type_id`), CHANGE COLUMN `type` `type` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , DROP INDEX `rep_class`, DROP INDEX `member_received`, DROP INDEX `leaderboard`, DROP INDEX `item_lookup`, CHANGE COLUMN `rep_class` `rep_class` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `rep_class` (`rep_class`,`type_id`), ADD KEY `member_received` (`member_received`,`rep_date`,`rep_class`,`rep_rating`), ADD KEY `leaderboard` (`rep_class`,`rep_date`,`member_received`,`rep_rating`), ADD KEY `item_lookup` (`rep_class`,`item_id`), DROP INDEX `class_type_id_hash`, CHANGE COLUMN `class_type_id_hash` `class_type_id_hash` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'MD5 of rep_class:type_id', ADD KEY `class_type_id_hash` (`class_type_id_hash`,`rep_date`,`rep_rating`); UPDATE `core_follow` SET `follow_id`='' WHERE `follow_id` IS NULL; UPDATE `core_follow` SET `follow_app`='' WHERE `follow_app` IS NULL; UPDATE `core_follow` SET `follow_area`='' WHERE `follow_area` IS NULL; UPDATE `core_follow` SET `follow_notify_freq`='' WHERE `follow_notify_freq` IS NULL; CREATE TABLE `core_follow_new` LIKE `core_follow`; ALTER TABLE `core_follow_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `follow_id` `follow_id` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD PRIMARY KEY (`follow_id`), DROP INDEX `followers`, DROP INDEX `follow_stream`, CHANGE COLUMN `follow_app` `follow_app` VARCHAR (150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `followers` (`follow_app`(70),`follow_area`(93),`follow_rel_id`,`follow_notify_freq`(8)), ADD KEY `follow_stream` (`follow_app`(73),`follow_area`(98),`follow_member_id`), CHANGE COLUMN `follow_area` `follow_area` VARCHAR (200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `follow_notify_meta` `follow_notify_meta` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , DROP INDEX `digest_task`, CHANGE COLUMN `follow_notify_freq` `follow_notify_freq` VARCHAR (20) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `digest_task` (`follow_notify_do`,`follow_notify_freq`,`follow_notify_sent`,`follow_member_id`); INSERT IGNORE INTO `core_follow_new` SELECT * FROM `core_follow`; DROP TABLE `core_follow`; RENAME TABLE `core_follow_new` TO `core_follow`; ALTER TABLE `core_polls` CHANGE COLUMN `choices` `choices` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `poll_question` `poll_question` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `poll_item_class` `poll_item_class` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_voters` SET `ip_address`='' WHERE `ip_address` IS NULL; ALTER TABLE `core_voters` CHANGE COLUMN `member_choices` `member_choices` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , DROP INDEX `ip_address`, CHANGE COLUMN `ip_address` `ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `ip_address` (`ip_address`); UPDATE `core_ratings` SET `class`='' WHERE `class` IS NULL; UPDATE `core_ratings` SET `ip`='' WHERE `ip` IS NULL; CREATE TABLE `core_ratings_new` LIKE `core_ratings`; ALTER TABLE `core_ratings_new` DROP INDEX `member_lookup`, DROP INDEX `lookup`, CHANGE COLUMN `class` `class` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The content item classname', ADD UNIQUE KEY `member_lookup` (`member`,`class`,`item_id`), ADD KEY `lookup` (`class`,`item_id`), DROP INDEX `ip`, CHANGE COLUMN `ip` `ip` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'IP address', ADD KEY `ip` (`ip`); INSERT IGNORE INTO `core_ratings_new` SELECT * FROM `core_ratings`; DROP TABLE `core_ratings`; RENAME TABLE `core_ratings_new` TO `core_ratings`; UPDATE `core_member_status_updates` SET `status_hash`='' WHERE `status_hash` IS NULL; UPDATE `core_member_status_updates` SET `status_author_ip`='' WHERE `status_author_ip` IS NULL; ALTER TABLE `core_member_status_updates` CHANGE COLUMN `status_content` `status_content` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `status_last_ids` `status_last_ids` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , DROP INDEX `s_hash`, CHANGE COLUMN `status_hash` `status_hash` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `s_hash` (`status_member_id`,`status_hash`,`status_date`), DROP INDEX `ip_lookup`, CHANGE COLUMN `status_author_ip` `status_author_ip` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `ip_lookup` (`status_author_ip`); ALTER TABLE `core_member_status_replies` CHANGE COLUMN `reply_content` `reply_content` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , DROP INDEX `ip_lookup`, CHANGE COLUMN `reply_ip_address` `reply_ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `ip_lookup` (`reply_ip_address`); UPDATE `core_queue` SET `data`='' WHERE `data` IS NULL; UPDATE `core_queue` SET `key`='' WHERE `key` IS NULL; ALTER TABLE `core_queue` CHANGE COLUMN `data` `data` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , DROP INDEX `task_lookup`, CHANGE COLUMN `app` `app` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `task_lookup` (`app`,`key`), DROP INDEX `queue_key`, CHANGE COLUMN `key` `key` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `queue_key` (`key`); UPDATE `core_soft_delete_log` SET `sdl_obj_key`='' WHERE `sdl_obj_key` IS NULL; ALTER TABLE `core_soft_delete_log` DROP INDEX `look_up`, CHANGE COLUMN `sdl_obj_key` `sdl_obj_key` VARCHAR (128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `look_up` (`sdl_obj_id`,`sdl_obj_key`), CHANGE COLUMN `sdl_obj_reason` `sdl_obj_reason` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_widget_areas` SET `app`='' WHERE `app` IS NULL; UPDATE `core_widget_areas` SET `module`='' WHERE `module` IS NULL; UPDATE `core_widget_areas` SET `controller`='' WHERE `controller` IS NULL; UPDATE `core_widget_areas` SET `widgets`='' WHERE `widgets` IS NULL; UPDATE `core_widget_areas` SET `area`='sidebar' WHERE `area` IS NULL; CREATE TABLE `core_widget_areas_new` LIKE `core_widget_areas`; ALTER TABLE `core_widget_areas_new` DROP INDEX `controller`, CHANGE COLUMN `app` `app` VARCHAR (80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD UNIQUE KEY `controller` (`app`(47),`module`(47),`controller`(47),`area`(47)), CHANGE COLUMN `module` `module` VARCHAR (80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `controller` `controller` VARCHAR (80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `widgets` `widgets` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , CHANGE COLUMN `area` `area` VARCHAR (80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'sidebar' ; INSERT IGNORE INTO `core_widget_areas_new` SELECT * FROM `core_widget_areas`; DROP TABLE `core_widget_areas`; RENAME TABLE `core_widget_areas_new` TO `core_widget_areas`; UPDATE `core_search_index` SET `index_content`='' WHERE `index_content` IS NULL; UPDATE `core_search_index` SET `index_permissions`='' WHERE `index_permissions` IS NULL; UPDATE `core_search_index` SET `index_class_type_id_hash`='' WHERE `index_class_type_id_hash` IS NULL; CREATE TABLE `core_search_index_new` LIKE `core_search_index`; ALTER TABLE `core_search_index_new` DROP INDEX `object`, DROP INDEX `index_class_and_object_id`, DROP INDEX `container`, DROP INDEX `author_lookup`, DROP INDEX `index_stream`, DROP INDEX `followed_content`, DROP INDEX `item`, CHANGE COLUMN `index_class` `index_class` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Content type class e.g. \\IPS\\forums\\Topic', ADD UNIQUE KEY `object` (`index_class`(181),`index_object_id`), ADD KEY `index_class_and_object_id` (`index_class`(181),`index_object_id`), ADD KEY `container` (`index_class`(171),`index_container_id`,`index_date_commented`), ADD KEY `author_lookup` (`index_author`,`index_class`(160),`index_hidden`,`index_date_updated`,`index_date_commented`), ADD KEY `index_stream` (`index_class`(219),`index_item_id`,`index_date_commented`,`index_date_updated`), ADD KEY `followed_content` (`index_class`(227),`index_is_last_comment`,`index_hidden`,`index_date_commented`,`index_date_updated`), ADD KEY `item` (`index_class`(239),`index_item_id`,`index_is_last_comment`), DROP INDEX `index_content`, CHANGE COLUMN `index_content` `index_content` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The plain-text content to search', ADD FULLTEXT KEY `index_content` (`index_content`(123),`index_title`(126)), CHANGE COLUMN `index_permissions` `index_permissions` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'A comma-delimited list of groups which have permission to view', DROP INDEX `index_title`, CHANGE COLUMN `index_title` `index_title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Content title', ADD FULLTEXT KEY `index_title` (`index_title`(250)), DROP INDEX `index_class_type_id_hash`, CHANGE COLUMN `index_class_type_id_hash` `index_class_type_id_hash` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'MD5 of (index_class:index_object_id)', ADD KEY `index_class_type_id_hash` (`index_class_type_id_hash`), CHANGE COLUMN `index_container_class` `index_container_class` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The class of the container that relates to index_container_id'; INSERT IGNORE INTO `core_search_index_new` SELECT * FROM `core_search_index`; DROP TABLE `core_search_index`; RENAME TABLE `core_search_index_new` TO `core_search_index`; UPDATE `core_widget_trash` SET `id`='' WHERE `id` IS NULL; CREATE TABLE `core_widget_trash_new` LIKE `core_widget_trash`; ALTER TABLE `core_widget_trash_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `id` `id` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Widgets unique ID', ADD PRIMARY KEY (`id`), CHANGE COLUMN `data` `data` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; INSERT IGNORE INTO `core_widget_trash_new` SELECT * FROM `core_widget_trash`; DROP TABLE `core_widget_trash`; RENAME TABLE `core_widget_trash_new` TO `core_widget_trash`; UPDATE `core_file_logs` SET `log_method`='' WHERE `log_method` IS NULL; ALTER TABLE `core_file_logs` DROP INDEX `log_type`, CHANGE COLUMN `log_type` `log_type` ENUM ('log','copy','error','move','orphaned') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `log_type` (`log_type`), DROP INDEX `log_action`, CHANGE COLUMN `log_action` `log_action` ENUM ('move','copy','delete','save','orphaned') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `log_action` (`log_action`), DROP INDEX `log_method`, CHANGE COLUMN `log_method` `log_method` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `log_method` (`log_method`(191)), CHANGE COLUMN `log_filename` `log_filename` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `log_msg` `log_msg` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `log_data` `log_data` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `log_container` `log_container` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `log_url` `log_url` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_sitemap` SET `sitemap`='' WHERE `sitemap` IS NULL; CREATE TABLE `core_sitemap_new` LIKE `core_sitemap`; ALTER TABLE `core_sitemap_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `sitemap` `sitemap` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The sitemap key', ADD PRIMARY KEY (`sitemap`(191)), CHANGE COLUMN `data` `data` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The sitemap XML'; INSERT IGNORE INTO `core_sitemap_new` SELECT * FROM `core_sitemap`; DROP TABLE `core_sitemap`; RENAME TABLE `core_sitemap_new` TO `core_sitemap`; ALTER TABLE `core_acp_tab_order` CHANGE COLUMN `data` `data` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_cache` SET `cache_key`='' WHERE `cache_key` IS NULL; UPDATE `core_cache` SET `cache_value`='' WHERE `cache_value` IS NULL; CREATE TABLE `core_cache_new` LIKE `core_cache`; ALTER TABLE `core_cache_new` DROP INDEX `cache_key`, DROP INDEX `keyexpire`, CHANGE COLUMN `cache_key` `cache_key` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The key', ADD UNIQUE KEY `cache_key` (`cache_key`), ADD KEY `keyexpire` (`cache_key`,`cache_expire`), CHANGE COLUMN `cache_value` `cache_value` LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The value'; INSERT IGNORE INTO `core_cache_new` SELECT * FROM `core_cache`; DROP TABLE `core_cache`; RENAME TABLE `core_cache_new` TO `core_cache`; UPDATE `core_menu` SET `app`='' WHERE `app` IS NULL; ALTER TABLE `core_menu` CHANGE COLUMN `app` `app` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The application key for the item', CHANGE COLUMN `extension` `extension` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The FrontNavigation extension key', CHANGE COLUMN `config` `config` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Any additional configuration', CHANGE COLUMN `permissions` `permissions` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Comma-delimited list of group IDs, or * for all, NULL to inherit'; UPDATE `core_streams` SET `ownership`='all' WHERE `ownership` IS NULL; UPDATE `core_streams` SET `read`='all' WHERE `read` IS NULL; UPDATE `core_streams` SET `follow`='all' WHERE `follow` IS NULL; UPDATE `core_streams` SET `date_type`='all' WHERE `date_type` IS NULL; UPDATE `core_streams` SET `sort`='newest' WHERE `sort` IS NULL; UPDATE `core_streams` SET `default_view`='expanded' WHERE `default_view` IS NULL; UPDATE `core_streams` SET `solved`='all' WHERE `solved` IS NULL; ALTER TABLE `core_streams` CHANGE COLUMN `classes` `classes` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The classes this stream will pull from or null for all', CHANGE COLUMN `containers` `containers` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'A JSON-encoded array of classes to allowed containers or NULL for all', CHANGE COLUMN `ownership` `ownership` ENUM ('all','started','postedin','custom') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'all' COMMENT 'Stream pulls all content or only content the viewer has started or posted in', CHANGE COLUMN `read` `read` ENUM ('all','unread') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'all' COMMENT 'If the stream only includes unread items', CHANGE COLUMN `follow` `follow` ENUM ('all','followed') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'all' COMMENT 'If the stream only shows followed content', CHANGE COLUMN `date_type` `date_type` ENUM ('all','last_visit','custom','relative') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'all' COMMENT 'The date range for the stream', CHANGE COLUMN `sort` `sort` ENUM ('newest','oldest') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'newest' COMMENT 'Whether the stream sorts newest first or oldest first by default', CHANGE COLUMN `custom_members` `custom_members` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'If using custom ownership, the member IDs', CHANGE COLUMN `tags` `tags` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Tags to match', CHANGE COLUMN `followed_types` `followed_types` SET ('containers','items','members') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'If filtering by followed content, what kind of follows to include', CHANGE COLUMN `title` `title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'If this is a member-created stream, the title (admin created streams use language strings)', CHANGE COLUMN `default_view` `default_view` ENUM ('expanded','condensed') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'expanded' COMMENT 'Should a stream show in a condensed or expanded layout by default', CHANGE COLUMN `clubs` `clubs` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Comma-delimited list of club IDs or 0 to exclude clubs, or NULL to not filter by clubs', CHANGE COLUMN `solved` `solved` ENUM ('all','solved','unsolved') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'all' COMMENT 'The solved status of the item'; UPDATE `core_view_updates` SET `classname`='' WHERE `classname` IS NULL; ALTER TABLE `core_view_updates` DROP INDEX `classname_and_id`, CHANGE COLUMN `classname` `classname` VARCHAR (150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Name of the class the view is for', ADD KEY `classname_and_id` (`classname`,`id`); UPDATE `core_geoip_cache` SET `ip_address`='' WHERE `ip_address` IS NULL; CREATE TABLE `core_geoip_cache_new` LIKE `core_geoip_cache`; ALTER TABLE `core_geoip_cache_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `ip_address` `ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The IP address', ADD PRIMARY KEY (`ip_address`), CHANGE COLUMN `data` `data` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The JSON-encoded data returned by the service'; INSERT IGNORE INTO `core_geoip_cache_new` SELECT * FROM `core_geoip_cache`; DROP TABLE `core_geoip_cache`; RENAME TABLE `core_geoip_cache_new` TO `core_geoip_cache`; UPDATE `core_api_keys` SET `api_id`='' WHERE `api_id` IS NULL; CREATE TABLE `core_api_keys_new` LIKE `core_api_keys`; ALTER TABLE `core_api_keys_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `api_id` `api_id` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'API Key', ADD PRIMARY KEY (`api_id`), CHANGE COLUMN `api_permissions` `api_permissions` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON encoded details of which endpoints the key can access', CHANGE COLUMN `api_allowed_ips` `api_allowed_ips` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Comma-delimited allowed IPs'; INSERT IGNORE INTO `core_api_keys_new` SELECT * FROM `core_api_keys`; DROP TABLE `core_api_keys`; RENAME TABLE `core_api_keys_new` TO `core_api_keys`; UPDATE `core_api_logs` SET `endpoint`='' WHERE `endpoint` IS NULL; ALTER TABLE `core_api_logs` CHANGE COLUMN `endpoint` `endpoint` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The endpoint that was requested', CHANGE COLUMN `method` `method` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The HTTP request method which was used', CHANGE COLUMN `api_key` `api_key` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The API key that was used', DROP INDEX `bruteforce`, CHANGE COLUMN `ip_address` `ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The IP address that the request came from', ADD KEY `bruteforce` (`ip_address`,`is_bad_key`), CHANGE COLUMN `request_data` `request_data` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The request body', CHANGE COLUMN `response_code` `response_code` CHAR (3) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The HTTP response code', CHANGE COLUMN `response_output` `response_output` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The response output', CHANGE COLUMN `client_id` `client_id` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The OAuth client ID, if applicable', CHANGE COLUMN `access_token` `access_token` CHAR (97) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The raw access token that was used'; ALTER TABLE `core_search_index_tags` DROP INDEX `index_tag`, CHANGE COLUMN `index_tag` `index_tag` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `index_tag` (`index_tag`(191)); UPDATE `core_log` SET `message`='' WHERE `message` IS NULL; ALTER TABLE `core_log` CHANGE COLUMN `exception_class` `exception_class` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'If the log was an exception, the class name', CHANGE COLUMN `message` `message` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The log message', CHANGE COLUMN `backtrace` `backtrace` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The backtrace', DROP INDEX `category`, CHANGE COLUMN `category` `category` VARCHAR (128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Optional string identifying the type of log', ADD KEY `category` (`category`), CHANGE COLUMN `url` `url` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'URL the error occurred on, if any', CHANGE COLUMN `loaded_hooks` `loaded_hooks` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Any third party hooks loaded'; UPDATE `core_search_index_item_map` SET `index_class`='' WHERE `index_class` IS NULL; CREATE TABLE `core_search_index_item_map_new` LIKE `core_search_index_item_map`; ALTER TABLE `core_search_index_item_map_new` DROP INDEX `search_map`, CHANGE COLUMN `index_class` `index_class` VARCHAR (80) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD UNIQUE KEY `search_map` (`index_item_id`,`index_class`,`index_author_id`); INSERT IGNORE INTO `core_search_index_item_map_new` SELECT * FROM `core_search_index_item_map`; DROP TABLE `core_search_index_item_map`; RENAME TABLE `core_search_index_item_map_new` TO `core_search_index_item_map`; ALTER TABLE `core_security_answers` CHANGE COLUMN `answer_answer` `answer_answer` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The answer, stored as an \\IPS\\Text\\Encrypt tag'; UPDATE `core_rss_export` SET `rss_seo_title`='' WHERE `rss_seo_title` IS NULL; UPDATE `core_rss_export` SET `rss_configuration`='' WHERE `rss_configuration` IS NULL; ALTER TABLE `core_rss_export` CHANGE COLUMN `rss_seo_title` `rss_seo_title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `rss_configuration` `rss_configuration` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , CHANGE COLUMN `rss_groups` `rss_groups` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_clubs` SET `name`='' WHERE `name` IS NULL; UPDATE `core_clubs` SET `type`='open' WHERE `type` IS NULL; ALTER TABLE `core_clubs` CHANGE COLUMN `name` `name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'Name of the club', CHANGE COLUMN `type` `type` ENUM ('public','open','closed','private','readonly') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'open' COMMENT 'Type of club', CHANGE COLUMN `profile_photo` `profile_photo` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The club profile photo', CHANGE COLUMN `cover_photo` `cover_photo` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The club cover photo', CHANGE COLUMN `location_json` `location_json` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Full \\IPS\\Geolocation JSON value of club location', CHANGE COLUMN `about` `about` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Blurb about this club', CHANGE COLUMN `profile_photo_uncropped` `profile_photo_uncropped` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The uncropped club photo', CHANGE COLUMN `fee` `fee` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON object with costs if this is a paid club', CHANGE COLUMN `renewal_units` `renewal_units` CHAR (1) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The renewal units - \"d\" for days, etc.', CHANGE COLUMN `renewal_price` `renewal_price` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON object with renewal costs if this is a paid club', CHANGE COLUMN `menu_tabs` `menu_tabs` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Club Menu sortorder', CHANGE COLUMN `show_membertab` `show_membertab` SET ('member','moderator','nonmember') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `rules` `rules` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; ALTER TABLE `core_clubs_memberships` DROP INDEX `member_id`, CHANGE COLUMN `status` `status` ENUM ('member','requested','invited','leader','declined','banned','moderator','invited_bypassing_payment','payment_pending','expired_moderator','expired') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT 'member' COMMENT 'The status of the membership. member is normal member, requested/invited are in the process of joining, leader is leader, declined means their request to join was declined, banned is banned by a leader', ADD KEY `member_id` (`member_id`,`status`); UPDATE `core_clubs_node_map` SET `node_class`='' WHERE `node_class` IS NULL; UPDATE `core_clubs_node_map` SET `name`='' WHERE `name` IS NULL; ALTER TABLE `core_clubs_node_map` DROP INDEX `node`, CHANGE COLUMN `node_class` `node_class` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The class for the type of node', ADD KEY `node` (`node_class`(171),`node_id`), CHANGE COLUMN `name` `name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The name'; ALTER TABLE `core_clubs_fields` CHANGE COLUMN `f_type` `f_type` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The field type', CHANGE COLUMN `f_extra` `f_extra` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Extra details such as options'; UPDATE `core_deletion_log` SET `dellog_content_class`='' WHERE `dellog_content_class` IS NULL; UPDATE `core_deletion_log` SET `dellog_content_title`='' WHERE `dellog_content_title` IS NULL; UPDATE `core_deletion_log` SET `dellog_content_seo_title`='' WHERE `dellog_content_seo_title` IS NULL; UPDATE `core_deletion_log` SET `dellog_content_permissions`='' WHERE `dellog_content_permissions` IS NULL; ALTER TABLE `core_deletion_log` DROP INDEX `dellog_content`, CHANGE COLUMN `dellog_content_class` `dellog_content_class` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `dellog_content` (`dellog_content_class`(171),`dellog_content_id`), CHANGE COLUMN `dellog_content_title` `dellog_content_title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `dellog_content_seo_title` `dellog_content_seo_title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `dellog_deleted_by_name` `dellog_deleted_by_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `dellog_deleted_by_seo_name` `dellog_deleted_by_seo_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `dellog_content_permissions` `dellog_content_permissions` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , CHANGE COLUMN `dellog_content_container_class` `dellog_content_container_class` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; ALTER TABLE `core_content_meta` DROP INDEX `meta_content`, CHANGE COLUMN `meta_class` `meta_class` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The Item Content Class', ADD KEY `meta_content` (`meta_class`(171),`meta_item_id`,`meta_item_author`), CHANGE COLUMN `meta_type` `meta_type` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The Type of Meta Data'; UPDATE `core_member_history` SET `log_app`='' WHERE `log_app` IS NULL; ALTER TABLE `core_member_history` DROP INDEX `application`, CHANGE COLUMN `log_app` `log_app` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Application', ADD KEY `application` (`log_app`(191)), CHANGE COLUMN `log_type` `log_type` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Log Type', DROP INDEX `log_data`, CHANGE COLUMN `log_data` `log_data` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `log_data` (`log_data`(191)), DROP INDEX `log_ip_address`, DROP INDEX `log_by`, CHANGE COLUMN `log_ip_address` `log_ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `log_ip_address` (`log_ip_address`), ADD KEY `log_by` (`log_by`,`log_ip_address`,`log_date`); UPDATE `core_members_known_devices` SET `device_key`='' WHERE `device_key` IS NULL; CREATE TABLE `core_members_known_devices_new` LIKE `core_members_known_devices`; ALTER TABLE `core_members_known_devices_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `device_key` `device_key` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'A random string whose value will be set as a permanent cookie to identify a device', ADD PRIMARY KEY (`device_key`,`member_id`), CHANGE COLUMN `user_agent` `user_agent` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The user agent string. Note this is not for identification but just for reference, and will be updated when the user upgrades their browser version', CHANGE COLUMN `login_key` `login_key` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'If the user has chosen \"remember me\", a random string whose value is set as a cookie to facilitate automatic login. NULL if they did not choose \"remember me\".', CHANGE COLUMN `login_handler` `login_handler` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The login handler which processed the most recent login (not updated on automatic log ins).'; INSERT IGNORE INTO `core_members_known_devices_new` SELECT * FROM `core_members_known_devices`; DROP TABLE `core_members_known_devices`; RENAME TABLE `core_members_known_devices_new` TO `core_members_known_devices`; UPDATE `core_members_known_ip_addresses` SET `device_key`='' WHERE `device_key` IS NULL; UPDATE `core_members_known_ip_addresses` SET `ip_address`='' WHERE `ip_address` IS NULL; CREATE TABLE `core_members_known_ip_addresses_new` LIKE `core_members_known_ip_addresses`; ALTER TABLE `core_members_known_ip_addresses_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `device_key` `device_key` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The device key as stored in core_members_known_devices.device_key', ADD PRIMARY KEY (`device_key`,`member_id`,`ip_address`), DROP INDEX `ip_address`, CHANGE COLUMN `ip_address` `ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The IP address', ADD KEY `ip_address` (`ip_address`); INSERT IGNORE INTO `core_members_known_ip_addresses_new` SELECT * FROM `core_members_known_ip_addresses`; DROP TABLE `core_members_known_ip_addresses`; RENAME TABLE `core_members_known_ip_addresses_new` TO `core_members_known_ip_addresses`; UPDATE `core_statistics` SET `type`='' WHERE `type` IS NULL; ALTER TABLE `core_statistics` DROP INDEX `type_int_value`, DROP INDEX `type_text_value`, CHANGE COLUMN `type` `type` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Type of statistic', ADD KEY `type_int_value` (`type`(161),`time`,`value_1`), ADD KEY `type_text_value` (`type`(90),`time`,`value_4`(90)), CHANGE COLUMN `value_4` `value_4` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `extra_data` `extra_data` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; ALTER TABLE `core_reactions` CHANGE COLUMN `reaction_icon` `reaction_icon` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_social_promote` SET `promote_class`='' WHERE `promote_class` IS NULL; UPDATE `core_social_promote` SET `promote_text`='' WHERE `promote_text` IS NULL; UPDATE `core_social_promote` SET `promote_short_link`='' WHERE `promote_short_link` IS NULL; UPDATE `core_social_promote` SET `promote_media`='' WHERE `promote_media` IS NULL; UPDATE `core_social_promote` SET `promote_images`='' WHERE `promote_images` IS NULL; ALTER TABLE `core_social_promote` DROP INDEX `promote_lookup`, DROP INDEX `promote_achievements`, CHANGE COLUMN `promote_class` `promote_class` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The content class', ADD KEY `promote_lookup` (`promote_class`(180),`promote_class_id`,`promote_internal`), ADD KEY `promote_achievements` (`promote_class`(181),`promote_class_id`,`promote_author_id`), CHANGE COLUMN `promote_text` `promote_text` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'JSON array of text for all services', CHANGE COLUMN `promote_short_link` `promote_short_link` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , CHANGE COLUMN `promote_media` `promote_media` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'JSON array of custom uploads', CHANGE COLUMN `promote_share_to` `promote_share_to` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON array of share service names (facebook, twitter)', CHANGE COLUMN `promote_images` `promote_images` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'JSON array of file locations (container/file.jpg)', CHANGE COLUMN `promote_returned` `promote_returned` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON array of data returned from the post', CHANGE COLUMN `promote_form_data` `promote_form_data` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_social_promote_sharers` SET `sharer_key`='' WHERE `sharer_key` IS NULL; UPDATE `core_social_promote_sharers` SET `sharer_settings`='' WHERE `sharer_settings` IS NULL; ALTER TABLE `core_social_promote_sharers` CHANGE COLUMN `sharer_key` `sharer_key` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `sharer_settings` `sharer_settings` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'JSON array of promotion settings'; UPDATE `core_social_promote_content` SET `response_promote_key`='' WHERE `response_promote_key` IS NULL; UPDATE `core_social_promote_content` SET `response_json`='' WHERE `response_json` IS NULL; ALTER TABLE `core_social_promote_content` DROP INDEX `response_promote_id`, CHANGE COLUMN `response_promote_key` `response_promote_key` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `response_promote_id` (`response_promote_id`,`response_promote_key`), CHANGE COLUMN `response_json` `response_json` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'JSON array showing the response', CHANGE COLUMN `response_service_id` `response_service_id` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Specific page/group ID for this service if applicable'; ALTER TABLE `core_group_promotions` CHANGE COLUMN `promote_filters` `promote_filters` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Json-encoded array of filters that a member must meet in order for this rule to apply', CHANGE COLUMN `promote_actions` `promote_actions` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Json-encoded array of actions taken when this rule applies'; ALTER TABLE `core_profile_steps` CHANGE COLUMN `step_completion_act` `step_completion_act` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `step_extension` `step_extension` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `step_subcompletion_act` `step_subcompletion_act` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_oauth_clients` SET `oauth_client_id`='' WHERE `oauth_client_id` IS NULL; UPDATE `core_oauth_clients` SET `oauth_grant_types`='' WHERE `oauth_grant_types` IS NULL; UPDATE `core_oauth_clients` SET `oauth_pkce`='none' WHERE `oauth_pkce` IS NULL; UPDATE `core_oauth_clients` SET `core_oauth_clients`='rest' WHERE `core_oauth_clients` IS NULL; CREATE TABLE `core_oauth_clients_new` LIKE `core_oauth_clients`; ALTER TABLE `core_oauth_clients_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `oauth_client_id` `oauth_client_id` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The client ID', ADD PRIMARY KEY (`oauth_client_id`), CHANGE COLUMN `oauth_client_secret` `oauth_client_secret` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The hashed client secret or NULL for public clients', CHANGE COLUMN `oauth_grant_types` `oauth_grant_types` SET ('authorization_code','implicit','client_credentials','password') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'Available grant types', CHANGE COLUMN `oauth_redirect_uris` `oauth_redirect_uris` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON-encoded array of Redirect URIs', CHANGE COLUMN `oauth_scopes` `oauth_scopes` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON-encoded array of scope data', CHANGE COLUMN `oauth_prompt` `oauth_prompt` ENUM ('login','reauthorize','automatic','none') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT 'reauthorize' COMMENT 'How to prompt users. login = Users must always login. reauthorize = Users are shown authorize screen. automatic = Users with an existing access token skip authorise screen. none = Never show screen', CHANGE COLUMN `oauth_brute_force` `oauth_brute_force` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON-encoded array of IP addresses and failed authentication, for brute-force prevention', CHANGE COLUMN `oauth_type` `oauth_type` ENUM ('invision','wordpress','mobile') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'A hint for how to display the form (NULL is generic custom)', CHANGE COLUMN `oauth_pkce` `oauth_pkce` ENUM ('S256','plain','none') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'none' COMMENT 'Required PKCE method.', CHANGE COLUMN `core_oauth_clients` `core_oauth_clients` ENUM ('rest','graphql','both') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'rest' , CHANGE COLUMN `oauth_api_access` `oauth_api_access` ENUM ('rest','graphql','both') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT 'rest' ; INSERT IGNORE INTO `core_oauth_clients_new` SELECT * FROM `core_oauth_clients`; DROP TABLE `core_oauth_clients`; RENAME TABLE `core_oauth_clients_new` TO `core_oauth_clients`; UPDATE `core_oauth_server_access_tokens` SET `client_id`='' WHERE `client_id` IS NULL; UPDATE `core_oauth_server_access_tokens` SET `access_token`='' WHERE `access_token` IS NULL; UPDATE `core_oauth_server_access_tokens` SET `status`='active' WHERE `status` IS NULL; CREATE TABLE `core_oauth_server_access_tokens_new` LIKE `core_oauth_server_access_tokens`; ALTER TABLE `core_oauth_server_access_tokens_new` DROP INDEX `access_lookup`, DROP INDEX `refresh_lookup`, DROP INDEX `authorization_code_lookup`, DROP INDEX `member_lookup`, CHANGE COLUMN `client_id` `client_id` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The client ID', ADD UNIQUE KEY `access_lookup` (`client_id`,`access_token`), ADD UNIQUE KEY `refresh_lookup` (`client_id`,`refresh_token`), ADD KEY `authorization_code_lookup` (`client_id`,`authorization_code`), ADD KEY `member_lookup` (`client_id`,`member_id`), CHANGE COLUMN `access_token` `access_token` CHAR (64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The access token', CHANGE COLUMN `refresh_token` `refresh_token` CHAR (64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Refresh token or NULL if not applicable', CHANGE COLUMN `scope` `scope` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON-encoded array of scopes or NULL if no scope was requested', CHANGE COLUMN `authorization_code` `authorization_code` CHAR (64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The authorization code that generated the access token, if applicable', CHANGE COLUMN `auth_user_agent` `auth_user_agent` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The user agent that the user performed authentication on, if known', CHANGE COLUMN `issue_user_agent` `issue_user_agent` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The user agent that the access token was issued to, if known', DROP INDEX `device_lookup`, CHANGE COLUMN `device_key` `device_key` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The device key of the device used to obtain this access token, if known', ADD KEY `device_lookup` (`member_id`,`device_key`), CHANGE COLUMN `status` `status` ENUM ('active','revoked') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'active' COMMENT 'The status. \"active\" means \"active if within expiry date\".'; INSERT IGNORE INTO `core_oauth_server_access_tokens_new` SELECT * FROM `core_oauth_server_access_tokens`; DROP TABLE `core_oauth_server_access_tokens`; RENAME TABLE `core_oauth_server_access_tokens_new` TO `core_oauth_server_access_tokens`; UPDATE `core_oauth_server_authorization_codes` SET `client_id`='' WHERE `client_id` IS NULL; UPDATE `core_oauth_server_authorization_codes` SET `code`='' WHERE `code` IS NULL; CREATE TABLE `core_oauth_server_authorization_codes_new` LIKE `core_oauth_server_authorization_codes`; ALTER TABLE `core_oauth_server_authorization_codes_new` DROP INDEX `authorization_code`, CHANGE COLUMN `client_id` `client_id` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The client ID', ADD UNIQUE KEY `authorization_code` (`client_id`,`code`), CHANGE COLUMN `redirect_uri` `redirect_uri` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The redirect_uri provided in the request', CHANGE COLUMN `code` `code` CHAR (64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The authorization code', CHANGE COLUMN `scope` `scope` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON-encoded array of scopes or NULL if no scope was requested', CHANGE COLUMN `code_challenge` `code_challenge` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The PKCE code challenge, if one was provided by the client', CHANGE COLUMN `code_challenge_method` `code_challenge_method` SET ('plain','S256') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT 'plain' COMMENT 'The PKCE code challenge method, if applicable', CHANGE COLUMN `user_agent` `user_agent` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The user agent that the user performed authentication on, if known', CHANGE COLUMN `device_key` `device_key` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The device key of the device used to obtain this authorization code, if known'; INSERT IGNORE INTO `core_oauth_server_authorization_codes_new` SELECT * FROM `core_oauth_server_authorization_codes`; DROP TABLE `core_oauth_server_authorization_codes`; RENAME TABLE `core_oauth_server_authorization_codes_new` TO `core_oauth_server_authorization_codes`; UPDATE `core_login_methods` SET `login_classname`='' WHERE `login_classname` IS NULL; UPDATE `core_login_methods` SET `login_settings`='' WHERE `login_settings` IS NULL; ALTER TABLE `core_login_methods` CHANGE COLUMN `login_classname` `login_classname` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'Handler\'s class name', CHANGE COLUMN `login_settings` `login_settings` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'JSON-encoded handler-specific setting values'; UPDATE `core_login_links` SET `token_identifier`='' WHERE `token_identifier` IS NULL; CREATE TABLE `core_login_links_new` LIKE `core_login_links`; ALTER TABLE `core_login_links_new` DROP INDEX `token_identifier`, CHANGE COLUMN `token_identifier` `token_identifier` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The server\'s identifier for the user', ADD UNIQUE KEY `token_identifier` (`token_login_method`,`token_identifier`(181)), CHANGE COLUMN `token_access_token` `token_access_token` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Access token', CHANGE COLUMN `token_refresh_token` `token_refresh_token` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Refresh token, if provided', CHANGE COLUMN `token_secret` `token_secret` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Token secret for OAuth 1.0 implementations', CHANGE COLUMN `token_scope` `token_scope` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON-encoded array of scopes issued', CHANGE COLUMN `token_id_token` `token_id_token` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'ID token for Open ID Connect implementations'; INSERT IGNORE INTO `core_login_links_new` SELECT * FROM `core_login_links`; DROP TABLE `core_login_links`; RENAME TABLE `core_login_links_new` TO `core_login_links`; UPDATE `core_spam_whitelist` SET `whitelist_type`='ip' WHERE `whitelist_type` IS NULL; ALTER TABLE `core_spam_whitelist` DROP INDEX `whitelist`, CHANGE COLUMN `whitelist_type` `whitelist_type` VARCHAR (10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'ip' , ADD KEY `whitelist` (`whitelist_content`(240),`whitelist_type`(9)), CHANGE COLUMN `whitelist_content` `whitelist_content` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `whitelist_reason` `whitelist_reason` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; ALTER TABLE `core_automatic_moderation_rules` CHANGE COLUMN `rule_types` `rule_types` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `rule_filters` `rule_filters` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_automatic_moderation_pending` SET `pending_object_class`='' WHERE `pending_object_class` IS NULL; CREATE TABLE `core_automatic_moderation_pending_new` LIKE `core_automatic_moderation_pending`; ALTER TABLE `core_automatic_moderation_pending_new` DROP INDEX `pending_unique`, CHANGE COLUMN `pending_object_class` `pending_object_class` VARCHAR (150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD UNIQUE KEY `pending_unique` (`pending_object_class`,`pending_object_id`); INSERT IGNORE INTO `core_automatic_moderation_pending_new` SELECT * FROM `core_automatic_moderation_pending`; DROP TABLE `core_automatic_moderation_pending`; RENAME TABLE `core_automatic_moderation_pending_new` TO `core_automatic_moderation_pending`; UPDATE `core_saved_charts` SET `chart_controller`='' WHERE `chart_controller` IS NULL; UPDATE `core_saved_charts` SET `chart_title`='' WHERE `chart_title` IS NULL; ALTER TABLE `core_saved_charts` CHANGE COLUMN `chart_controller` `chart_controller` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , CHANGE COLUMN `chart_configuration` `chart_configuration` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `chart_title` `chart_title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `chart_timescale` `chart_timescale` ENUM ('hourly','daily','weekly','monthly','none') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_oauth_authorize_prompts` SET `session_id`='' WHERE `session_id` IS NULL; UPDATE `core_oauth_authorize_prompts` SET `client_id`='' WHERE `client_id` IS NULL; UPDATE `core_oauth_authorize_prompts` SET `response_type`='code' WHERE `response_type` IS NULL; CREATE TABLE `core_oauth_authorize_prompts_new` LIKE `core_oauth_authorize_prompts`; ALTER TABLE `core_oauth_authorize_prompts_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `session_id` `session_id` VARCHAR (128) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The session ID', ADD PRIMARY KEY (`session_id`), CHANGE COLUMN `client_id` `client_id` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The client ID', CHANGE COLUMN `response_type` `response_type` ENUM ('code','token') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'code' COMMENT 'The response type', CHANGE COLUMN `redirect_uri` `redirect_uri` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The provided redirect URI', CHANGE COLUMN `scope` `scope` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'space-delimited scope', CHANGE COLUMN `state` `state` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `prompt` `prompt` ENUM ('login','reauthorize') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The requested prompt type', CHANGE COLUMN `code_challenge` `code_challenge` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The PKCE code challenge, if one was provided by the client', CHANGE COLUMN `code_challenge_method` `code_challenge_method` SET ('plain','S256') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT 'plain' COMMENT 'The PKCE code challenge method, if applicable'; INSERT IGNORE INTO `core_oauth_authorize_prompts_new` SELECT * FROM `core_oauth_authorize_prompts`; DROP TABLE `core_oauth_authorize_prompts`; RENAME TABLE `core_oauth_authorize_prompts_new` TO `core_oauth_authorize_prompts`; UPDATE `core_acp_notifications` SET `app`='' WHERE `app` IS NULL; UPDATE `core_acp_notifications` SET `ext`='' WHERE `ext` IS NULL; ALTER TABLE `core_acp_notifications` CHANGE COLUMN `app` `app` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The key of the application this notification belongs to', CHANGE COLUMN `ext` `ext` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The extension this notification belongs to within the application', CHANGE COLUMN `extra` `extra` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Any additional data about the notification'; UPDATE `core_acp_notifications_preferences` SET `type`='' WHERE `type` IS NULL; UPDATE `core_acp_notifications_preferences` SET `email`='never' WHERE `email` IS NULL; CREATE TABLE `core_acp_notifications_preferences_new` LIKE `core_acp_notifications_preferences`; ALTER TABLE `core_acp_notifications_preferences_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `type` `type` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'Key representing the notification type', ADD PRIMARY KEY (`member`,`type`), CHANGE COLUMN `email` `email` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'never' COMMENT 'How frequently to email the admin about this notification'; INSERT IGNORE INTO `core_acp_notifications_preferences_new` SELECT * FROM `core_acp_notifications_preferences`; DROP TABLE `core_acp_notifications_preferences`; RENAME TABLE `core_acp_notifications_preferences_new` TO `core_acp_notifications_preferences`; UPDATE `core_ips_bulletins` SET `title`='' WHERE `title` IS NULL; UPDATE `core_ips_bulletins` SET `body`='' WHERE `body` IS NULL; UPDATE `core_ips_bulletins` SET `severity`='' WHERE `severity` IS NULL; UPDATE `core_ips_bulletins` SET `style`='' WHERE `style` IS NULL; UPDATE `core_ips_bulletins` SET `dismissible`='' WHERE `dismissible` IS NULL; UPDATE `core_ips_bulletins` SET `conditions`='' WHERE `conditions` IS NULL; ALTER TABLE `core_ips_bulletins` CHANGE COLUMN `title` `title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The bulletin title', CHANGE COLUMN `body` `body` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The bulletin body', CHANGE COLUMN `severity` `severity` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The bulletin severity', CHANGE COLUMN `style` `style` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The bulletin style', CHANGE COLUMN `dismissible` `dismissible` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'If the bulletin can be dismissed', CHANGE COLUMN `link` `link` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Where the notification should link to', CHANGE COLUMN `conditions` `conditions` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'PHP code to check if notification should show'; UPDATE `core_post_before_registering` SET `email`='' WHERE `email` IS NULL; UPDATE `core_post_before_registering` SET `class`='' WHERE `class` IS NULL; UPDATE `core_post_before_registering` SET `secret`='' WHERE `secret` IS NULL; CREATE TABLE `core_post_before_registering_new` LIKE `core_post_before_registering`; ALTER TABLE `core_post_before_registering_new` CHANGE COLUMN `email` `email` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The guest\'s email address', DROP INDEX `content_lookup`, CHANGE COLUMN `class` `class` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The class of the content that was posted', ADD UNIQUE KEY `content_lookup` (`class`(171),`id`), DROP INDEX `secret`, CHANGE COLUMN `secret` `secret` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'A secret key which is used to link the user to this content', ADD KEY `secret` (`secret`); INSERT IGNORE INTO `core_post_before_registering_new` SELECT * FROM `core_post_before_registering`; DROP TABLE `core_post_before_registering`; RENAME TABLE `core_post_before_registering_new` TO `core_post_before_registering`; UPDATE `core_output_cache` SET `cache_key`='' WHERE `cache_key` IS NULL; UPDATE `core_output_cache` SET `cache_value`='' WHERE `cache_value` IS NULL; UPDATE `core_output_cache` SET `cache_meta`='' WHERE `cache_meta` IS NULL; CREATE TABLE `core_output_cache_new` LIKE `core_output_cache`; ALTER TABLE `core_output_cache_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `cache_key` `cache_key` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The key', ADD PRIMARY KEY (`cache_key`), CHANGE COLUMN `cache_value` `cache_value` LONGTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The output HTML', CHANGE COLUMN `cache_meta` `cache_meta` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'JSON headers and meta data'; INSERT IGNORE INTO `core_output_cache_new` SELECT * FROM `core_output_cache`; DROP TABLE `core_output_cache`; RENAME TABLE `core_output_cache_new` TO `core_output_cache`; ALTER TABLE `core_referral_banners` CHANGE COLUMN `rb_url` `rb_url` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; ALTER TABLE `core_referrals` CHANGE COLUMN `amount` `amount` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_club_pages` SET `page_title`='' WHERE `page_title` IS NULL; UPDATE `core_club_pages` SET `page_seo_title`='' WHERE `page_seo_title` IS NULL; UPDATE `core_club_pages` SET `page_content`='' WHERE `page_content` IS NULL; ALTER TABLE `core_club_pages` CHANGE COLUMN `page_title` `page_title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `page_seo_title` `page_seo_title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `page_content` `page_content` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , CHANGE COLUMN `page_can_view` `page_can_view` SET ('member','moderator','nonmember') CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_rss_import` SET `rss_import_title`='' WHERE `rss_import_title` IS NULL; UPDATE `core_rss_import` SET `rss_import_class`='' WHERE `rss_import_class` IS NULL; UPDATE `core_rss_import` SET `rss_import_showlink`='' WHERE `rss_import_showlink` IS NULL; UPDATE `core_rss_import` SET `rss_import_topic_pre`='' WHERE `rss_import_topic_pre` IS NULL; UPDATE `core_rss_import` SET `rss_import_enclosures`='import' WHERE `rss_import_enclosures` IS NULL; ALTER TABLE `core_rss_import` CHANGE COLUMN `rss_import_title` `rss_import_title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `rss_import_url` `rss_import_url` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `rss_import_auth_user` `rss_import_auth_user` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' , CHANGE COLUMN `rss_import_auth_pass` `rss_import_auth_pass` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' , CHANGE COLUMN `rss_import_class` `rss_import_class` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `rss_import_showlink` `rss_import_showlink` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `rss_import_topic_pre` `rss_import_topic_pre` VARCHAR (50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `rss_import_settings` `rss_import_settings` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Json array of the extensions settings', CHANGE COLUMN `rss_import_enclosures` `rss_import_enclosures` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'import' COMMENT 'Enclosure handling: import, ignore or hotlink'; UPDATE `core_rss_imported` SET `rss_imported_guid`='0' WHERE `rss_imported_guid` IS NULL; CREATE TABLE `core_rss_imported_new` LIKE `core_rss_imported`; ALTER TABLE `core_rss_imported_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `rss_imported_guid` `rss_imported_guid` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0' , ADD PRIMARY KEY (`rss_imported_guid`); INSERT IGNORE INTO `core_rss_imported_new` SELECT * FROM `core_rss_imported`; DROP TABLE `core_rss_imported`; RENAME TABLE `core_rss_imported_new` TO `core_rss_imported`; UPDATE `core_follow_count_cache` SET `class`='' WHERE `class` IS NULL; CREATE TABLE `core_follow_count_cache_new` LIKE `core_follow_count_cache`; ALTER TABLE `core_follow_count_cache_new` DROP INDEX `id_class`, CHANGE COLUMN `class` `class` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD UNIQUE KEY `id_class` (`id`,`class`(171)); INSERT IGNORE INTO `core_follow_count_cache_new` SELECT * FROM `core_follow_count_cache`; DROP TABLE `core_follow_count_cache`; RENAME TABLE `core_follow_count_cache_new` TO `core_follow_count_cache`; UPDATE `core_solved_index` SET `app`='' WHERE `app` IS NULL; ALTER TABLE `core_solved_index` DROP INDEX `app`, CHANGE COLUMN `app` `app` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `app` (`app`,`comment_class`), DROP INDEX `solved_class`, CHANGE COLUMN `comment_class` `comment_class` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `solved_class` (`comment_class`,`comment_id`); UPDATE `core_api_webhooks` SET `api_key`='' WHERE `api_key` IS NULL; UPDATE `core_api_webhooks` SET `events`='' WHERE `events` IS NULL; UPDATE `core_api_webhooks` SET `url`='' WHERE `url` IS NULL; UPDATE `core_api_webhooks` SET `filters`='' WHERE `filters` IS NULL; ALTER TABLE `core_api_webhooks` DROP INDEX `api_key`, CHANGE COLUMN `api_key` `api_key` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' COMMENT 'The API key which owns this webhook', ADD KEY `api_key` (`api_key`), CHANGE COLUMN `events` `events` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'Comma-delimited list of events to fire for', CHANGE COLUMN `url` `url` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The URL to send webhook to', CHANGE COLUMN `filters` `filters` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'JSON-encoded array of filters for each event', CHANGE COLUMN `content_type` `content_type` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT 'application/x-www-form-urlencoded' ; UPDATE `core_api_webhook_fires` SET `event`='' WHERE `event` IS NULL; UPDATE `core_api_webhook_fires` SET `status`='pending' WHERE `status` IS NULL; ALTER TABLE `core_api_webhook_fires` CHANGE COLUMN `event` `event` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The event being fired', CHANGE COLUMN `data` `data` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The data to send', DROP INDEX `queue`, CHANGE COLUMN `status` `status` ENUM ('pending','successful','failed') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'pending' COMMENT 'The status', ADD KEY `queue` (`status`,`time`), CHANGE COLUMN `response_code` `response_code` CHAR (3) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The HTTP response code', CHANGE COLUMN `response_body` `response_body` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'The response body'; UPDATE `core_marketplace_tokens` SET `token`='' WHERE `token` IS NULL; ALTER TABLE `core_marketplace_tokens` CHANGE COLUMN `token` `token` CHAR (97) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ; UPDATE `core_anonymous_posts` SET `anonymous_object_class`='' WHERE `anonymous_object_class` IS NULL; CREATE TABLE `core_anonymous_posts_new` LIKE `core_anonymous_posts`; ALTER TABLE `core_anonymous_posts_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `anonymous_object_class` `anonymous_object_class` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , ADD PRIMARY KEY (`anonymous_member_id`,`anonymous_object_class`,`anonymous_object_id`); INSERT IGNORE INTO `core_anonymous_posts_new` SELECT * FROM `core_anonymous_posts`; DROP TABLE `core_anonymous_posts`; RENAME TABLE `core_anonymous_posts_new` TO `core_anonymous_posts`; UPDATE `core_s3_deletions` SET `s3_container`='' WHERE `s3_container` IS NULL; CREATE TABLE `core_s3_deletions_new` LIKE `core_s3_deletions`; ALTER TABLE `core_s3_deletions_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `s3_container` `s3_container` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD PRIMARY KEY (`s3_container`(191)), CHANGE COLUMN `s3_marker` `s3_marker` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Last key seen, so it can be used to get the next result set from AWS'; INSERT IGNORE INTO `core_s3_deletions_new` SELECT * FROM `core_s3_deletions`; DROP TABLE `core_s3_deletions`; RENAME TABLE `core_s3_deletions_new` TO `core_s3_deletions`; UPDATE `core_item_redirect` SET `redirect_class`='' WHERE `redirect_class` IS NULL; ALTER TABLE `core_item_redirect` DROP INDEX `redirect_lookup`, DROP INDEX `redirect_delete`, CHANGE COLUMN `redirect_class` `redirect_class` VARCHAR (200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , ADD KEY `redirect_lookup` (`redirect_class`(181),`redirect_item_id`), ADD KEY `redirect_delete` (`redirect_class`(181),`redirect_new_item_id`); UPDATE `core_item_statistics_cache` SET `cache_class`='' WHERE `cache_class` IS NULL; UPDATE `core_item_statistics_cache` SET `cache_contents`='' WHERE `cache_contents` IS NULL; CREATE TABLE `core_item_statistics_cache_new` LIKE `core_item_statistics_cache`; ALTER TABLE `core_item_statistics_cache_new` DROP INDEX `cache_lookup`, CHANGE COLUMN `cache_class` `cache_class` VARCHAR (150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD UNIQUE KEY `cache_lookup` (`cache_class`,`cache_item_id`), CHANGE COLUMN `cache_contents` `cache_contents` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ; INSERT IGNORE INTO `core_item_statistics_cache_new` SELECT * FROM `core_item_statistics_cache`; DROP TABLE `core_item_statistics_cache`; RENAME TABLE `core_item_statistics_cache_new` TO `core_item_statistics_cache`; UPDATE `core_item_member_map` SET `map_class`='' WHERE `map_class` IS NULL; CREATE TABLE `core_item_member_map_new` LIKE `core_item_member_map`; ALTER TABLE `core_item_member_map_new` DROP INDEX `map_unique`, CHANGE COLUMN `map_class` `map_class` VARCHAR (200) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , ADD UNIQUE KEY `map_unique` (`map_class`(171),`map_item_id`,`map_member_id`); INSERT IGNORE INTO `core_item_member_map_new` SELECT * FROM `core_item_member_map`; DROP TABLE `core_item_member_map`; RENAME TABLE `core_item_member_map_new` TO `core_item_member_map`; UPDATE `core_notifications_pwa_keys` SET `endpoint`='' WHERE `endpoint` IS NULL; UPDATE `core_notifications_pwa_keys` SET `p256dh`='' WHERE `p256dh` IS NULL; UPDATE `core_notifications_pwa_keys` SET `auth`='' WHERE `auth` IS NULL; UPDATE `core_notifications_pwa_keys` SET `encoding`='aesgcm' WHERE `encoding` IS NULL; UPDATE `core_notifications_pwa_keys` SET `device`='' WHERE `device` IS NULL; ALTER TABLE `core_notifications_pwa_keys` CHANGE COLUMN `endpoint` `endpoint` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'Endpoint URL. Use TEXT as endpoints may exceed the limits of VARCHAR.', CHANGE COLUMN `p256dh` `p256dh` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `auth` `auth` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `encoding` `encoding` VARCHAR (50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'aesgcm' COMMENT 'The content encoding preferred by this browser', CHANGE COLUMN `device` `device` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' ; ALTER TABLE `core_notifications_pwa_queue` CHANGE COLUMN `notification_data` `notification_data` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_points_log` SET `rules`='' WHERE `rules` IS NULL; UPDATE `core_points_log` SET `actor`='' WHERE `actor` IS NULL; ALTER TABLE `core_points_log` CHANGE COLUMN `rules` `rules` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'A comma-delimited list of rules which were applied', CHANGE COLUMN `actor` `actor` SET ('subject','other') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'If the member receiving the points was the subject or other in the action'; UPDATE `core_member_badges` SET `actor`='' WHERE `actor` IS NULL; ALTER TABLE `core_member_badges` CHANGE COLUMN `actor` `actor` SET ('subject','other') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'If the member receiving the badge was the subject or other in the action'; ALTER TABLE `core_badges` CHANGE COLUMN `image` `image` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_achievements_rules` SET `action`='' WHERE `action` IS NULL; ALTER TABLE `core_achievements_rules` CHANGE COLUMN `action` `action` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The action that this rule applies to', CHANGE COLUMN `filters` `filters` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'JSON object of filters'; UPDATE `core_achievements_log` SET `action`='' WHERE `action` IS NULL; UPDATE `core_achievements_log` SET `identifier`='' WHERE `identifier` IS NULL; CREATE TABLE `core_achievements_log_new` LIKE `core_achievements_log`; ALTER TABLE `core_achievements_log_new` DROP INDEX `lookup`, CHANGE COLUMN `action` `action` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'The action that was performed', ADD UNIQUE KEY `lookup` (`identifier`,`action`), CHANGE COLUMN `identifier` `identifier` VARCHAR (50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL COMMENT 'An identifier for the thing the action is being performed on (e.g. if this is for making a post, the post ID)'; INSERT IGNORE INTO `core_achievements_log_new` SELECT * FROM `core_achievements_log`; DROP TABLE `core_achievements_log`; RENAME TABLE `core_achievements_log_new` TO `core_achievements_log`; UPDATE `core_content_featured` SET `feature_content_class`='' WHERE `feature_content_class` IS NULL; ALTER TABLE `core_content_featured` DROP INDEX `feature_lookup`, CHANGE COLUMN `feature_content_class` `feature_content_class` VARCHAR (50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `feature_lookup` (`feature_content_id`,`feature_content_class`,`feature_content_author`); UPDATE `core_member_recognize` SET `r_content_class`='' WHERE `r_content_class` IS NULL; ALTER TABLE `core_member_recognize` DROP INDEX `r_content`, CHANGE COLUMN `r_content_class` `r_content_class` VARCHAR (150) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , ADD KEY `r_content` (`r_content_class`,`r_content_id`), CHANGE COLUMN `r_message` `r_message` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; CREATE TABLE `core_members_logins_new` LIKE `core_members_logins`; ALTER TABLE `core_members_logins_new` DROP INDEX `lookup`, CHANGE COLUMN `member_date` `member_date` VARCHAR (10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD UNIQUE KEY `lookup` (`member_id`,`member_date`); INSERT IGNORE INTO `core_members_logins_new` SELECT * FROM `core_members_logins`; DROP TABLE `core_members_logins`; RENAME TABLE `core_members_logins_new` TO `core_members_logins`; CREATE TABLE `core_achievements_log_milestones_new` LIKE `core_achievements_log_milestones`; ALTER TABLE `core_achievements_log_milestones_new` DROP INDEX `lookup`, CHANGE COLUMN `milestone_type` `milestone_type` VARCHAR (100) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT 'subject' , ADD UNIQUE KEY `lookup` (`milestone_member_id`,`milestone_rule`,`milestone_type`); INSERT IGNORE INTO `core_achievements_log_milestones_new` SELECT * FROM `core_achievements_log_milestones`; DROP TABLE `core_achievements_log_milestones`; RENAME TABLE `core_achievements_log_milestones_new` TO `core_achievements_log_milestones`; UPDATE `core_editor_stored_replies` SET `reply_title`='' WHERE `reply_title` IS NULL; UPDATE `core_editor_stored_replies` SET `reply_text`='' WHERE `reply_text` IS NULL; ALTER TABLE `core_editor_stored_replies` CHANGE COLUMN `reply_title` `reply_title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , CHANGE COLUMN `reply_text` `reply_text` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ; UPDATE `core_stream_subscriptions` SET `frequency`='weekly' WHERE `frequency` IS NULL; ALTER TABLE `core_stream_subscriptions` CHANGE COLUMN `frequency` `frequency` ENUM ('daily','weekly') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'weekly' ; UPDATE `core_alerts` SET `alert_title`='' WHERE `alert_title` IS NULL; UPDATE `core_alerts` SET `alert_content`='' WHERE `alert_content` IS NULL; UPDATE `core_alerts` SET `alert_seo_title`='' WHERE `alert_seo_title` IS NULL; UPDATE `core_alerts` SET `alert_recipient_type`='user' WHERE `alert_recipient_type` IS NULL; UPDATE `core_alerts` SET `alert_show_to`='all' WHERE `alert_show_to` IS NULL; ALTER TABLE `core_alerts` CHANGE COLUMN `alert_title` `alert_title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , CHANGE COLUMN `alert_content` `alert_content` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , CHANGE COLUMN `alert_seo_title` `alert_seo_title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , DROP INDEX `look_up`, CHANGE COLUMN `alert_recipient_type` `alert_recipient_type` ENUM ('user','group') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'user' , ADD KEY `look_up` (`alert_start`,`alert_end`,`alert_recipient_type`,`alert_recipient_user`), CHANGE COLUMN `alert_recipient_group` `alert_recipient_group` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `alert_show_to` `alert_show_to` VARCHAR (50) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'all' ; UPDATE `core_approval_queue` SET `approval_content_class`='' WHERE `approval_content_class` IS NULL; ALTER TABLE `core_approval_queue` CHANGE COLUMN `approval_held_reason` `approval_held_reason` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , DROP INDEX `approval_content`, CHANGE COLUMN `approval_content_class` `approval_content_class` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `approval_content` (`approval_content_class`(191),`approval_content_id`); UPDATE `core_member_privacy_actions` SET `action`='' WHERE `action` IS NULL; ALTER TABLE `core_member_privacy_actions` CHANGE COLUMN `action` `action` ENUM ('pii_download','delete_account','delete_account_validation') CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , CHANGE COLUMN `vkey` `vkey` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `core_contact_verify` SET `email_address`='' WHERE `email_address` IS NULL; UPDATE `core_contact_verify` SET `verify_key`='' WHERE `verify_key` IS NULL; UPDATE `core_contact_verify` SET `contact_data`='' WHERE `contact_data` IS NULL; CREATE TABLE `core_contact_verify_new` LIKE `core_contact_verify`; ALTER TABLE `core_contact_verify_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `email_address` `email_address` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD PRIMARY KEY (`email_address`(191)), CHANGE COLUMN `verify_key` `verify_key` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `contact_data` `contact_data` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL ; INSERT IGNORE INTO `core_contact_verify_new` SELECT * FROM `core_contact_verify`; DROP TABLE `core_contact_verify`; RENAME TABLE `core_contact_verify_new` TO `core_contact_verify`; UPDATE `forums_forums` SET `last_poster_name`='' WHERE `last_poster_name` IS NULL; UPDATE `forums_forums` SET `seo_last_title`='' WHERE `seo_last_title` IS NULL; UPDATE `forums_forums` SET `seo_last_name`='' WHERE `seo_last_name` IS NULL; ALTER TABLE `forums_forums` CHANGE COLUMN `last_poster_name` `last_poster_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , DROP INDEX `forum_password`, DROP INDEX `widget_performance`, CHANGE COLUMN `password` `password` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `forum_password` (`password`), ADD KEY `widget_performance` (`min_posts_view`,`password`(20),`password_override`(160),`can_view_others`), CHANGE COLUMN `password_override` `password_override` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `last_title` `last_title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `sort_key` `sort_key` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `redirect_url` `redirect_url` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' , CHANGE COLUMN `name_seo` `name_seo` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `seo_last_title` `seo_last_title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `seo_last_name` `seo_last_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `last_x_topic_ids` `last_x_topic_ids` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `tag_predefined` `tag_predefined` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `ipseo_priority` `ipseo_priority` VARCHAR (3) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT '' , CHANGE COLUMN `qa_rate_questions` `qa_rate_questions` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `qa_rate_answers` `qa_rate_answers` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `icon` `icon` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `feature_color` `feature_color` VARCHAR (15) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Feature color', CHANGE COLUMN `card_image` `card_image` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL COMMENT 'Card image file name'; UPDATE `forums_topics` SET `title`='' WHERE `title` IS NULL; UPDATE `forums_topics` SET `title_seo`='' WHERE `title_seo` IS NULL; ALTER TABLE `forums_topics` CHANGE COLUMN `title` `title` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , DROP INDEX `last_post`, CHANGE COLUMN `state` `state` VARCHAR (8) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `last_post` (`forum_id`,`pinned`,`last_real_post`,`state`), CHANGE COLUMN `starter_name` `starter_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `last_poster_name` `last_poster_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `poll_state` `poll_state` VARCHAR (8) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , DROP INDEX `moved_redirects`, CHANGE COLUMN `moved_to` `moved_to` VARCHAR (64) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , ADD KEY `moved_redirects` (`moved_on`,`moved_to`,`pinned`), CHANGE COLUMN `title_seo` `title_seo` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' ; UPDATE `forums_posts` SET `ip_address`='' WHERE `ip_address` IS NULL; UPDATE `forums_posts` SET `post_key`='0' WHERE `post_key` IS NULL; UPDATE `forums_posts` SET `post_edit_reason`='' WHERE `post_edit_reason` IS NULL; ALTER TABLE `forums_posts` CHANGE COLUMN `author_name` `author_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , DROP INDEX `ip_address`, CHANGE COLUMN `ip_address` `ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `ip_address` (`ip_address`), CHANGE COLUMN `post` `post` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `edit_name` `edit_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , DROP INDEX `post_key`, CHANGE COLUMN `post_key` `post_key` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '0' , ADD KEY `post_key` (`post_key`), CHANGE COLUMN `post_edit_reason` `post_edit_reason` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `post_field_t1` `post_field_t1` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `post_field_t2` `post_field_t2` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `forums_archive_rules` SET `archive_key`='' WHERE `archive_key` IS NULL; UPDATE `forums_archive_rules` SET `archive_app`='core' WHERE `archive_app` IS NULL; UPDATE `forums_archive_rules` SET `archive_field`='' WHERE `archive_field` IS NULL; UPDATE `forums_archive_rules` SET `archive_value`='' WHERE `archive_value` IS NULL; UPDATE `forums_archive_rules` SET `archive_text`='' WHERE `archive_text` IS NULL; UPDATE `forums_archive_rules` SET `archive_unit`='' WHERE `archive_unit` IS NULL; CREATE TABLE `forums_archive_rules_new` LIKE `forums_archive_rules`; ALTER TABLE `forums_archive_rules_new` DROP INDEX `PRIMARY`, CHANGE COLUMN `archive_key` `archive_key` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD PRIMARY KEY (`archive_key`), CHANGE COLUMN `archive_app` `archive_app` VARCHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'core' , CHANGE COLUMN `archive_field` `archive_field` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `archive_value` `archive_value` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `archive_text` `archive_text` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL , CHANGE COLUMN `archive_unit` `archive_unit` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' ; INSERT IGNORE INTO `forums_archive_rules_new` SELECT * FROM `forums_archive_rules`; DROP TABLE `forums_archive_rules`; RENAME TABLE `forums_archive_rules_new` TO `forums_archive_rules`; UPDATE `forums_archive_posts` SET `archive_ip_address`='' WHERE `archive_ip_address` IS NULL; UPDATE `forums_archive_posts` SET `archive_attach_key`='' WHERE `archive_attach_key` IS NULL; UPDATE `forums_archive_posts` SET `archive_edit_name`='' WHERE `archive_edit_name` IS NULL; UPDATE `forums_archive_posts` SET `archive_edit_reason`='' WHERE `archive_edit_reason` IS NULL; ALTER TABLE `forums_archive_posts` CHANGE COLUMN `archive_author_name` `archive_author_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , DROP INDEX `archive_ip_address`, CHANGE COLUMN `archive_ip_address` `archive_ip_address` VARCHAR (46) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , ADD KEY `archive_ip_address` (`archive_ip_address`), CHANGE COLUMN `archive_content` `archive_content` MEDIUMTEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `archive_attach_key` `archive_attach_key` CHAR (32) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `archive_edit_name` `archive_edit_name` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `archive_edit_reason` `archive_edit_reason` VARCHAR (255) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' ; UPDATE `forums_topic_mmod` SET `topic_state`='leave' WHERE `topic_state` IS NULL; UPDATE `forums_topic_mmod` SET `topic_pin`='leave' WHERE `topic_pin` IS NULL; UPDATE `forums_topic_mmod` SET `topic_title_st`='' WHERE `topic_title_st` IS NULL; UPDATE `forums_topic_mmod` SET `topic_title_end`='' WHERE `topic_title_end` IS NULL; ALTER TABLE `forums_topic_mmod` CHANGE COLUMN `topic_state` `topic_state` VARCHAR (10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'leave' , CHANGE COLUMN `topic_pin` `topic_pin` VARCHAR (10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'leave' , CHANGE COLUMN `topic_title_st` `topic_title_st` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `topic_title_end` `topic_title_end` VARCHAR (250) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT '' , CHANGE COLUMN `topic_reply_content` `topic_reply_content` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL , CHANGE COLUMN `mm_forums` `mm_forums` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL ; UPDATE `forums_view_method` SET `method`='table' WHERE `method` IS NULL; UPDATE `forums_view_method` SET `type`='index' WHERE `type` IS NULL; CREATE TABLE `forums_view_method_new` LIKE `forums_view_method`; ALTER TABLE `forums_view_method_new` CHANGE COLUMN `method` `method` VARCHAR (10) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'table' , DROP INDEX `member_id`, CHANGE COLUMN `type` `type` VARCHAR (16) CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL DEFAULT 'index' , ADD UNIQUE KEY `member_id` (`member_id`,`type`); INSERT IGNORE INTO `forums_view_method_new` SELECT * FROM `forums_view_method`; DROP TABLE `forums_view_method`; RENAME TABLE `forums_view_method_new` TO `forums_view_method`; Â Edited February 10 by Denis Surkov
Adlago Posted February 10 Posted February 10 Revert your PHP to 8.2, although PHP 8.2 is still not supported by IPS, at least for me PHP 8.2 works correctly. PHP 8.3. probably causing all the issues in your installation.
Denis Surkov Posted February 10 Author Posted February 10 9 minutes ago, Adlago said: Revert your PHP to 8.2, although PHP 8.2 is still not supported by IPS, at least for me PHP 8.2 works correctly. PHP 8.3. probably causing all the issues in your installation. Thanks, but no help. I tried 8.0, 8.1, 8.2 and 8.3. Same result.
Adlago Posted February 10 Posted February 10 5 minutes ago, Denis Surkov said: Thanks, but no help. I tried 8.0, 8.1, 8.2 and 8.3. Same result. After going back to 8.1 for example, open your database with phpmyadmin, select all tables bottom, and in the drop down menu select repair tables. After this action, try to update.
Denis Surkov Posted February 10 Author Posted February 10 43 minutes ago, Adlago said: After going back to 8.1 for example, open your database with phpmyadmin, select all tables bottom, and in the drop down menu select repair tables. After this action, try to update. Just did. While I got "Your SQL query has been executed successfully", few of the tables got a "The storage engine for the table doesn't support repair" message. Tried the upgrade, so far everything is the same.
Denis Surkov Posted February 10 Author Posted February 10 4 minutes ago, Adlago said: Which version of IPS are you using now? 4.7.14 trying to upgrade to 4.7.15
Adlago Posted February 10 Posted February 10 6 minutes ago, Denis Surkov said: 4.7.14 trying to upgrade to 4.7.15 In this case, in my opinion, it is better to try with backup files and database to restore normal operation of your site (if of course your host creates a backup) - When you restore your site, leave only PHP 8.1 active Then try an update.
Jim M Posted February 11 Posted February 11 18 hours ago, Denis Surkov said: Thanks, but no help. I tried 8.0, 8.1, 8.2 and 8.3. Same result. Would clear any OPCache, etc... If everything has been ran successfully via your MySQL server. You can certainly try a manual upgrade. Of course, be sure to take necessary backups.
Solution Stuart Silvester Posted February 12 Solution Posted February 12 You'll need to convert your database to utf8mb4, in MySQL `utf8` no longer exists and is an alias for `ut8mb3` so when you're running these queries to fix the collation, MySQL is changing it to utf8mb3 instead and thus you have this loop. In the AdminCP, go to the Support page and you should see an option for converting to UTF8MB4. Marc, Denis Surkov and adc_bjorn 3
Denis Surkov Posted February 12 Author Posted February 12 5 hours ago, Stuart Silvester said: You'll need to convert your database to utf8mb4, in MySQL `utf8` no longer exists and is an alias for `ut8mb3` so when you're running these queries to fix the collation, MySQL is changing it to utf8mb3 instead and thus you have this loop. In the AdminCP, go to the Support page and you should see an option for converting to UTF8MB4. Thank you!
Recommended Posts