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`;
