ALTER TABLE `convert_app_sessions` CHANGE COLUMN `session_app_data` `session_app_data` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT 'Session Data containing rows converted, completed steps, etc.';
ALTER TABLE `cjmenu_groups` CHANGE COLUMN `group_extra` `group_extra` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '';
ALTER TABLE `sdmyplaces_categories` CHANGE COLUMN `category_custom_fields` `category_custom_fields` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '', CHANGE COLUMN `category_tags_predefined` `category_tags_predefined` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '';
ALTER TABLE `sdmyplaces_custom_fields` CHANGE COLUMN `cf_content` `cf_content` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '', CHANGE COLUMN `cf_input_format` `cf_input_format` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '', CHANGE COLUMN `cf_format` `cf_format` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '';
UPDATE `sdmyplaces_places` SET `place_start_lat`=0 WHERE `place_start_lat` IS NULL;
UPDATE `sdmyplaces_places` SET `place_start_lon`=0 WHERE `place_start_lon` IS NULL;
UPDATE `sdmyplaces_places` SET `place_end_lat`=0 WHERE `place_end_lat` IS NULL;
UPDATE `sdmyplaces_places` SET `place_end_lon`=0 WHERE `place_end_lon` IS NULL;
ALTER TABLE `sdmyplaces_places` CHANGE COLUMN `place_votes` `place_votes` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '', CHANGE COLUMN `place_description` `place_description` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '', CHANGE COLUMN `place_data` `place_data` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '', CHANGE COLUMN `place_start_lat` `place_start_lat` DECIMAL (20,14) NOT NULL DEFAULT 0 COMMENT '', CHANGE COLUMN `place_start_lon` `place_start_lon` DECIMAL (20,14) NOT NULL DEFAULT 0 COMMENT '', CHANGE COLUMN `place_end_lat` `place_end_lat` DECIMAL (20,14) NOT NULL DEFAULT 0 COMMENT '', CHANGE COLUMN `place_end_lon` `place_end_lon` DECIMAL (20,14) NOT NULL DEFAULT 0 COMMENT '';
ALTER TABLE `sdmyplaces_comments` CHANGE COLUMN `comment_text` `comment_text` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '';
ALTER TABLE `sdmyplaces_reviews` CHANGE COLUMN `review_text` `review_text` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '', CHANGE COLUMN `review_votes_data` `review_votes_data` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '';
ALTER TABLE `sdmyplaces_places_images` CHANGE COLUMN `image_no_watermark` `image_no_watermark` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '', CHANGE COLUMN `image_thumb` `image_thumb` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '';
ALTER TABLE `sdmyplaces_imports` CHANGE COLUMN `import_error_message` `import_error_message` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '';
ALTER TABLE `sdmyplaces_import_files` CHANGE COLUMN `file_location` `file_location` TEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '', CHANGE COLUMN `file_data` `file_data` MEDIUMTEXT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL COMMENT '';