-- Update for null values
UPDATE item_permission_ref SET project_id = '-1' WHERE project_id IS NULL;
UPDATE label SET hidden = '0' WHERE hidden IS NULL;
UPDATE object SET deleted = '0' WHERE deleted IS NULL;
UPDATE object SET revision = '1' WHERE revision IS NULL;
UPDATE object_access_permission SET access_perms = '0' WHERE access_perms IS NULL;
UPDATE object_additional_info SET content_frozen = '0' WHERE content_frozen IS NULL;
UPDATE object_notification SET deleted = '0' WHERE deleted IS NULL;
UPDATE object_notification SET only_members = '0' WHERE only_members IS NULL;
UPDATE object_reference SET deleted = '0' WHERE deleted IS NULL;
UPDATE object_reference SET status_id = '0' WHERE status_id IS NULL;
UPDATE object_reference_filter SET flags = '0' WHERE flags IS NULL;
UPDATE object_revision SET deleted = '0' WHERE deleted IS NULL;
UPDATE perm_object_user_mapping SET project_id = '-1' WHERE project_id IS NULL;
UPDATE release_team_stats SET creation_type = 'AUTOMATIC' WHERE creation_type IS NULL;
UPDATE task SET flags = '0' WHERE flags IS NULL;
UPDATE task SET revision = '1' WHERE revision IS NULL;
UPDATE task_escalation_schedule SET fired = '0' WHERE fired IS NULL;
UPDATE task_revision SET flags = '0' WHERE flags IS NULL;
UPDATE task_search_history SET flags = '0' WHERE flags IS NULL;
UPDATE task_search_history SET revision = '1' WHERE revision IS NULL;
UPDATE task_type SET desc_id = '1' WHERE desc_id IS NULL;
UPDATE task_type SET service_desk = '0' WHERE service_desk IS NULL;
UPDATE task_type SET template = '0' WHERE template IS NULL;
UPDATE users SET downloadlimit = '-1' WHERE downloadlimit IS NULL;


-- Change the collection of the database
ALTER DATABASE <TABLE_SCHEMA> CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci;
ALTER SCHEMA <TABLE_SCHEMA> DEFAULT COLLATE utf8mb4_general_ci;

-- Alter table
USE <TABLE_SCHEMA>;
ALTER TABLE version COLLATE = utf8mb4_general_ci;
ALTER TABLE acl_role COLLATE = utf8mb4_general_ci;
ALTER TABLE role_mapping COLLATE = utf8mb4_general_ci;
ALTER TABLE user_key COLLATE = utf8mb4_general_ci;
ALTER TABLE user_pref COLLATE = utf8mb4_general_ci;
ALTER TABLE session_history COLLATE = utf8mb4_general_ci;
ALTER TABLE object_approval_workflow COLLATE = utf8mb4_general_ci;
ALTER TABLE object_approval_step COLLATE = utf8mb4_general_ci;
ALTER TABLE object_approver COLLATE = utf8mb4_general_ci;
ALTER TABLE object COLLATE = utf8mb4_general_ci;
ALTER TABLE object_additional_info COLLATE = utf8mb4_general_ci;
ALTER TABLE object_revision COLLATE = utf8mb4_general_ci;
ALTER TABLE object_tag COLLATE = utf8mb4_general_ci;
ALTER TABLE object_access_log COLLATE = utf8mb4_general_ci;
ALTER TABLE object_approval_history COLLATE = utf8mb4_general_ci;
ALTER TABLE object_reference_filter COLLATE = utf8mb4_general_ci;
ALTER TABLE object_job_schedule COLLATE = utf8mb4_general_ci;
ALTER TABLE task_type COLLATE = utf8mb4_general_ci;
ALTER TABLE task_field_status_specific COLLATE = utf8mb4_general_ci;
ALTER TABLE task_field_value_tuple COLLATE = utf8mb4_general_ci;
ALTER TABLE task_search_history COLLATE = utf8mb4_general_ci;
ALTER TABLE task_revision COLLATE = utf8mb4_general_ci;
ALTER TABLE task_tag COLLATE = utf8mb4_general_ci;
ALTER TABLE task_reference_tag COLLATE = utf8mb4_general_ci;
ALTER TABLE task_field_value COLLATE = utf8mb4_general_ci;
ALTER TABLE field_value_search_history COLLATE = utf8mb4_general_ci;
ALTER TABLE task_field_history COLLATE = utf8mb4_general_ci;
ALTER TABLE task_escalation_schedule COLLATE = utf8mb4_general_ci;
ALTER TABLE task_review COLLATE = utf8mb4_general_ci;
ALTER TABLE object_access_permission COLLATE = utf8mb4_general_ci;
ALTER TABLE object_notification COLLATE = utf8mb4_general_ci;
ALTER TABLE daily_proj_stat COLLATE = utf8mb4_general_ci;
ALTER TABLE profile_met COLLATE = utf8mb4_general_ci;
ALTER TABLE daily_tracker_stat COLLATE = utf8mb4_general_ci;
ALTER TABLE release_team_stats COLLATE = utf8mb4_general_ci;
ALTER TABLE navigation_history COLLATE = utf8mb4_general_ci;
ALTER TABLE workingset COLLATE = utf8mb4_general_ci;
ALTER TABLE workingset_item COLLATE = utf8mb4_general_ci;
ALTER TABLE server_information COLLATE = utf8mb4_general_ci;
ALTER TABLE application_configuration COLLATE = utf8mb4_general_ci;
ALTER TABLE label COLLATE = utf8mb4_general_ci;
ALTER TABLE object_label COLLATE = utf8mb4_general_ci;
ALTER TABLE computed_update_job COLLATE = utf8mb4_general_ci;
ALTER TABLE computed_update_job_tracker COLLATE = utf8mb4_general_ci;
ALTER TABLE computed_update_job_item COLLATE = utf8mb4_general_ci;
ALTER TABLE scm_submodule COLLATE = utf8mb4_general_ci;
ALTER TABLE object_reference COLLATE = utf8mb4_general_ci;
ALTER TABLE reference_search_history COLLATE = utf8mb4_general_ci;
ALTER TABLE object_association_type COLLATE = utf8mb4_general_ci;
ALTER TABLE object_rating COLLATE = utf8mb4_general_ci;
ALTER TABLE project_activity_log COLLATE = utf8mb4_general_ci;
ALTER TABLE upgrade_statements COLLATE = utf8mb4_general_ci;
ALTER TABLE object_quartz_schedule COLLATE = utf8mb4_general_ci;
ALTER TABLE chat_ops_mapping COLLATE = utf8mb4_general_ci;
ALTER TABLE chat_ops_thread COLLATE = utf8mb4_general_ci;
ALTER TABLE audit_trail_logs COLLATE = utf8mb4_general_ci;
ALTER TABLE audit_trail_logs_metadata COLLATE = utf8mb4_general_ci;
ALTER TABLE monitoring_log COLLATE = utf8mb4_general_ci;
ALTER TABLE slow_request_meta_data COLLATE = utf8mb4_general_ci;
ALTER TABLE propagate_up_mapping COLLATE = utf8mb4_general_ci;
ALTER TABLE propagate_down_mapping COLLATE = utf8mb4_general_ci;
ALTER TABLE computed_field_lookup COLLATE = utf8mb4_general_ci;
ALTER TABLE field_recent_value COLLATE = utf8mb4_general_ci;
ALTER TABLE tracker_outline COLLATE = utf8mb4_general_ci;
ALTER TABLE id_filter_temp_table COLLATE = utf8mb4_general_ci;
ALTER TABLE revision_filter_temp_table COLLATE = utf8mb4_general_ci;
ALTER TABLE comp_field_ref_temp_table COLLATE = utf8mb4_general_ci;
ALTER TABLE order_id_idx_temp_table COLLATE = utf8mb4_general_ci;
ALTER TABLE color_field_temp_table COLLATE = utf8mb4_general_ci;
ALTER TABLE document_cache COLLATE = utf8mb4_general_ci;
ALTER TABLE document_cache_data COLLATE = utf8mb4_general_ci;
ALTER TABLE artifact_uuid_registry COLLATE = utf8mb4_general_ci;
ALTER TABLE task_uuid_registry COLLATE = utf8mb4_general_ci;
ALTER TABLE permanent_link COLLATE = utf8mb4_general_ci;
ALTER TABLE history_search_update COLLATE = utf8mb4_general_ci;
ALTER TABLE task_lock COLLATE = utf8mb4_general_ci;
ALTER TABLE task_ordinal_history COLLATE = utf8mb4_general_ci;
ALTER TABLE page_view COLLATE = utf8mb4_general_ci;
ALTER TABLE perftest COLLATE = utf8mb4_general_ci;
ALTER TABLE perftest_clob COLLATE = utf8mb4_general_ci;
ALTER TABLE perftest_blob COLLATE = utf8mb4_general_ci;
ALTER TABLE perftest_step COLLATE = utf8mb4_general_ci;
ALTER TABLE perftest_latency COLLATE = utf8mb4_general_ci;
ALTER TABLE perftest_varchar255 COLLATE = utf8mb4_general_ci;
ALTER TABLE perftest_integer COLLATE = utf8mb4_general_ci;
ALTER TABLE perftest_integer_idx COLLATE = utf8mb4_general_ci;
ALTER TABLE perftest_datetime COLLATE = utf8mb4_general_ci;
ALTER TABLE QRTZ_SIMPLE_TRIGGERS COLLATE = utf8mb4_general_ci;
ALTER TABLE QRTZ_CRON_TRIGGERS COLLATE = utf8mb4_general_ci;
ALTER TABLE QRTZ_SIMPROP_TRIGGERS COLLATE = utf8mb4_general_ci;
ALTER TABLE QRTZ_BLOB_TRIGGERS COLLATE = utf8mb4_general_ci;
ALTER TABLE QRTZ_CALENDARS COLLATE = utf8mb4_general_ci;
ALTER TABLE QRTZ_PAUSED_TRIGGER_GRPS COLLATE = utf8mb4_general_ci;
ALTER TABLE QRTZ_SCHEDULER_STATE COLLATE = utf8mb4_general_ci;
ALTER TABLE QRTZ_LOCKS COLLATE = utf8mb4_general_ci;
ALTER TABLE QRTZ_JOB_DETAILS COLLATE = utf8mb4_general_ci;
ALTER TABLE QRTZ_TRIGGERS COLLATE = utf8mb4_general_ci;
ALTER TABLE QRTZ_FIRED_TRIGGERS COLLATE = utf8mb4_general_ci;
ALTER TABLE tomcat_session COLLATE = utf8mb4_general_ci;
ALTER TABLE session_user_licenses COLLATE = utf8mb4_general_ci;
ALTER TABLE locks COLLATE = utf8mb4_general_ci;
ALTER TABLE export_job_report COLLATE = utf8mb4_general_ci;
ALTER TABLE tomcat_session_blobs COLLATE = utf8mb4_general_ci;
ALTER TABLE users_small_photo_blobs COLLATE = utf8mb4_general_ci;
ALTER TABLE users_large_photo_blobs COLLATE = utf8mb4_general_ci;
ALTER TABLE object_revision_blobs COLLATE = utf8mb4_general_ci;
ALTER TABLE document_cache_data_blobs COLLATE = utf8mb4_general_ci;
ALTER TABLE export_content_blobs COLLATE = utf8mb4_general_ci;
ALTER TABLE export_template_blobs COLLATE = utf8mb4_general_ci;
ALTER TABLE existing_object_map COLLATE = utf8mb4_general_ci;
ALTER TABLE excel_import_settings COLLATE = utf8mb4_general_ci;
ALTER TABLE background_job COLLATE = utf8mb4_general_ci;
ALTER TABLE background_step_context COLLATE = utf8mb4_general_ci;
ALTER TABLE background_step_result COLLATE = utf8mb4_general_ci;
ALTER TABLE background_step COLLATE = utf8mb4_general_ci;
ALTER TABLE background_job_meta COLLATE = utf8mb4_general_ci;
ALTER TABLE users COLLATE = utf8mb4_general_ci;
ALTER TABLE existing COLLATE = utf8mb4_general_ci;
ALTER TABLE task COLLATE = utf8mb4_general_ci;
ALTER TABLE item_permission_ref COLLATE = utf8mb4_general_ci;
ALTER TABLE perm_object_user_mapping COLLATE = utf8mb4_general_ci;

ALTER TABLE QRTZ_BLOB_TRIGGERS CHANGE SCHED_NAME SCHED_NAME varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_BLOB_TRIGGERS CHANGE TRIGGER_GROUP TRIGGER_GROUP varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_BLOB_TRIGGERS CHANGE TRIGGER_NAME TRIGGER_NAME varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_CALENDARS CHANGE CALENDAR_NAME CALENDAR_NAME varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_CALENDARS CHANGE SCHED_NAME SCHED_NAME varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_CRON_TRIGGERS CHANGE CRON_EXPRESSION CRON_EXPRESSION varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_CRON_TRIGGERS CHANGE SCHED_NAME SCHED_NAME varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_CRON_TRIGGERS CHANGE TIME_ZONE_ID TIME_ZONE_ID varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE QRTZ_CRON_TRIGGERS CHANGE TRIGGER_GROUP TRIGGER_GROUP varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_CRON_TRIGGERS CHANGE TRIGGER_NAME TRIGGER_NAME varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_FIRED_TRIGGERS CHANGE ENTRY_ID ENTRY_ID varchar(140) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_FIRED_TRIGGERS CHANGE INSTANCE_NAME INSTANCE_NAME varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_FIRED_TRIGGERS CHANGE JOB_GROUP JOB_GROUP varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE QRTZ_FIRED_TRIGGERS CHANGE JOB_NAME JOB_NAME varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE QRTZ_FIRED_TRIGGERS CHANGE SCHED_NAME SCHED_NAME varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_FIRED_TRIGGERS CHANGE STATE STATE varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_FIRED_TRIGGERS CHANGE TRIGGER_GROUP TRIGGER_GROUP varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_FIRED_TRIGGERS CHANGE TRIGGER_NAME TRIGGER_NAME varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_JOB_DETAILS CHANGE DESCRIPTION DESCRIPTION varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE QRTZ_JOB_DETAILS CHANGE JOB_CLASS_NAME JOB_CLASS_NAME varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_JOB_DETAILS CHANGE JOB_GROUP JOB_GROUP varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_JOB_DETAILS CHANGE JOB_NAME JOB_NAME varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_JOB_DETAILS CHANGE SCHED_NAME SCHED_NAME varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_LOCKS CHANGE LOCK_NAME LOCK_NAME varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_LOCKS CHANGE SCHED_NAME SCHED_NAME varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_PAUSED_TRIGGER_GRPS CHANGE SCHED_NAME SCHED_NAME varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_PAUSED_TRIGGER_GRPS CHANGE TRIGGER_GROUP TRIGGER_GROUP varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_SCHEDULER_STATE CHANGE INSTANCE_NAME INSTANCE_NAME varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_SCHEDULER_STATE CHANGE SCHED_NAME SCHED_NAME varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_SIMPLE_TRIGGERS CHANGE SCHED_NAME SCHED_NAME varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_SIMPLE_TRIGGERS CHANGE TRIGGER_GROUP TRIGGER_GROUP varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_SIMPLE_TRIGGERS CHANGE TRIGGER_NAME TRIGGER_NAME varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_SIMPROP_TRIGGERS CHANGE SCHED_NAME SCHED_NAME varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_SIMPROP_TRIGGERS CHANGE STR_PROP_1 STR_PROP_1 varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE QRTZ_SIMPROP_TRIGGERS CHANGE STR_PROP_2 STR_PROP_2 varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE QRTZ_SIMPROP_TRIGGERS CHANGE STR_PROP_3 STR_PROP_3 varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE QRTZ_SIMPROP_TRIGGERS CHANGE TIME_ZONE_ID TIME_ZONE_ID varchar(80) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE QRTZ_SIMPROP_TRIGGERS CHANGE TRIGGER_GROUP TRIGGER_GROUP varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_SIMPROP_TRIGGERS CHANGE TRIGGER_NAME TRIGGER_NAME varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_TRIGGERS CHANGE CALENDAR_NAME CALENDAR_NAME varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE QRTZ_TRIGGERS CHANGE DESCRIPTION DESCRIPTION varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE QRTZ_TRIGGERS CHANGE JOB_GROUP JOB_GROUP varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_TRIGGERS CHANGE JOB_NAME JOB_NAME varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_TRIGGERS CHANGE SCHED_NAME SCHED_NAME varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_TRIGGERS CHANGE TRIGGER_GROUP TRIGGER_GROUP varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_TRIGGERS CHANGE TRIGGER_NAME TRIGGER_NAME varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_TRIGGERS CHANGE TRIGGER_STATE TRIGGER_STATE varchar(16) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE QRTZ_TRIGGERS CHANGE TRIGGER_TYPE TRIGGER_TYPE varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE acl_role CHANGE description description varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE acl_role CHANGE name name varchar(99) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE application_configuration CHANGE configuration configuration mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE artifact_uuid_registry CHANGE original_uuid original_uuid varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE artifact_uuid_registry CHANGE uuid uuid varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE audit_trail_logs CHANGE details details mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE audit_trail_logs CHANGE event_type event_type varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE audit_trail_logs_metadata CHANGE key_name key_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE audit_trail_logs_metadata CHANGE key_value key_value varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE background_job CHANGE description description varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE background_job CHANGE job_status job_status varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE background_job CHANGE job_type job_type varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE background_job_meta CHANGE meta_key meta_key varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE background_job_meta CHANGE meta_value meta_value varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE background_step CHANGE step_data step_data mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE background_step CHANGE step_name step_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE background_step CHANGE step_processor_id step_processor_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE background_step CHANGE step_status step_status varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE background_step_context CHANGE context_data context_data mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE background_step_result CHANGE step_result step_result varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE background_step_result CHANGE step_result_message step_result_message mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE chat_ops_mapping CHANGE external_id external_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE chat_ops_thread CHANGE thread_id thread_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE color_field_temp_table CHANGE data_key data_key varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE comp_field_ref_temp_table CHANGE data_key data_key varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE computed_update_job CHANGE job_key job_key varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE computed_update_job CHANGE status status varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE computed_update_job_item CHANGE error_message error_message mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE computed_update_job_item CHANGE status status varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE document_cache_data CHANGE boost boost varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE document_cache_data CHANGE field_name field_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE excel_import_settings CHANGE json json mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE existing CHANGE key_name key_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE existing CHANGE mount_point mount_point varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE existing CHANGE name name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE existing CHANGE propagation propagation varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE export_content_blobs CHANGE id id varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE export_job_report CHANGE export_id export_id varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE export_job_report CHANGE file_name file_name varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE export_job_report CHANGE is_convert_pdf is_convert_pdf char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE export_job_report CHANGE is_zip is_zip char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE export_job_report CHANGE request_json request_json mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE export_job_report CHANGE state state varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE export_job_report CHANGE temp_file_name temp_file_name varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE export_template_blobs CHANGE id id varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE field_recent_value CHANGE recent_values recent_values varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE id_filter_temp_table CHANGE data_key data_key varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE label CHANGE hidden hidden char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '0';
ALTER TABLE label CHANGE name name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE locks CHANGE lock_key lock_key varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE locks CHANGE node_id node_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE monitoring_log CHANGE details details mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE monitoring_log CHANGE log_type log_type varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE monitoring_log CHANGE node_id node_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE object_additional_info CHANGE content_frozen content_frozen char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '0';
ALTER TABLE object_approval_history CHANGE approval_comment approval_comment text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE object_approval_history CHANGE approval_step_name approval_step_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE object_approval_history CHANGE approved approved char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE object_approval_step CHANGE name name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE object_approval_workflow CHANGE name name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE object_association_type CHANGE name name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE object_job_schedule CHANGE job_name job_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE object_notification CHANGE deleted deleted char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '0';
ALTER TABLE object_notification CHANGE only_members only_members char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '0';
ALTER TABLE object_quartz_schedule CHANGE cron cron varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE object_quartz_schedule CHANGE job_data job_data mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE object_quartz_schedule CHANGE name name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE object_quartz_schedule CHANGE status status varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE object_reference CHANGE url url text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE object_reference_filter CHANGE qualifier qualifier text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE object_revision CHANGE desc_format desc_format char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE object_revision CHANGE description description mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE object_revision CHANGE name name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE object_revision CHANGE rev_comment rev_comment text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE order_id_idx_temp_table CHANGE data_key data_key varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE page_view CHANGE link_metadata link_metadata mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE page_view CHANGE view_key view_key varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE perftest_clob CHANGE value value mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE perftest_latency CHANGE test_data test_data varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE perftest_step CHANGE description description varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE perftest_step CHANGE explain_plan explain_plan mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE perftest_step CHANGE query query varchar(4000) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE perftest_step CHANGE query_hash query_hash varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE perftest_step CHANGE result result varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE perftest_varchar255 CHANGE value value varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE permanent_link CHANGE link_metadata link_metadata mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE permanent_link CHANGE unique_hash unique_hash varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE profile_met CHANGE host_id host_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE project_activity_log CHANGE event_comment event_comment varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE reference_search_history CHANGE url url text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE release_team_stats CHANGE creation_type creation_type varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'AUTOMATIC';
ALTER TABLE revision_filter_temp_table CHANGE data_key data_key varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE scm_submodule CHANGE module_name module_name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE scm_submodule CHANGE module_path module_path varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE scm_submodule CHANGE module_revision module_revision varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE scm_submodule CHANGE module_url module_url varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE scm_submodule CHANGE super_repo_branch super_repo_branch varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE scm_submodule CHANGE super_repo_tag super_repo_tag char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE server_information CHANGE server_id server_id varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE server_information CHANGE server_mode server_mode varchar(6) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE session_history CHANGE remote_host remote_host varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE session_history CHANGE session_id session_id varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE session_user_licenses CHANGE ip_hash ip_hash varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE session_user_licenses CHANGE product_type product_type varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE session_user_licenses CHANGE session_id session_id varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE session_user_licenses CHANGE user_license_type user_license_type varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE task CHANGE details details mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE task CHANGE ishtml ishtml char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE task CHANGE summary summary varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE task_escalation_schedule CHANGE fired fired char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '0';
ALTER TABLE task_field_history CHANGE new_value new_value mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE task_field_history CHANGE old_value old_value mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE task_field_status_specific CHANGE required required char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE task_field_status_specific CHANGE settings settings mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE task_field_value CHANGE field_value field_value mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE task_field_value_tuple CHANGE tuple_val tuple_val mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE task_lock CHANGE is_expire_with_session is_expire_with_session char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE task_search_history CHANGE summary summary varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE task_type CHANGE prefix prefix varchar(22) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE task_type CHANGE service_desk service_desk char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '0';
ALTER TABLE task_type CHANGE template template char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '0';
ALTER TABLE task_type CHANGE visible visible char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE task_uuid_registry CHANGE original_uuid original_uuid varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE task_uuid_registry CHANGE uuid uuid varchar(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE tomcat_session CHANGE ip_hash ip_hash varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE tomcat_session CHANGE session_hash session_hash varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE tomcat_session CHANGE session_id session_id varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE tomcat_session CHANGE version version varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE tomcat_session_blobs CHANGE id id varchar(40) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE tracker_outline CHANGE outline outline longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE upgrade_statements CHANGE statement_id statement_id varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL;
ALTER TABLE upgrade_statements CHANGE status status varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci;
ALTER TABLE user_key CHANGE algorithm algorithm varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE user_key CHANGE format format varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE user_key CHANGE name name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE user_pref CHANGE pref_value pref_value mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE address address varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE browser browser varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE city city varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE company company varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE country country varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE date_format date_format varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE datetime_format datetime_format varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE division_size division_size varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE email email varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE email_client email_client varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE firstname firstname varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE geo_city geo_city varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE geo_country geo_country varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE geo_latitude geo_latitude varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE geo_longitude geo_longitude varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE geo_region geo_region varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE hostname hostname varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE language language varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE lastname lastname varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE mobil mobil varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE name name varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE users CHANGE passwd passwd char(254) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE phone phone varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE referrer_url referrer_url varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE scc scc varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE skills skills text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE source_of_interest source_of_interest varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE state state varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE status status varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE team_size team_size varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE timezone timezone varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE title title varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE unused0 unused0 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE unused1 unused1 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE unused2 unused2 varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE users CHANGE zip zip varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE version CHANGE major major varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE version CHANGE minor minor varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE workingset CHANGE description description text CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE workingset CHANGE description_format description_format char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin;
ALTER TABLE workingset CHANGE name name varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;
ALTER TABLE workingset CHANGE selected selected char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL;

-- Analyze result
ANALYZE TABLE QRTZ_BLOB_TRIGGERS;
ANALYZE TABLE QRTZ_CALENDARS;
ANALYZE TABLE QRTZ_CRON_TRIGGERS;
ANALYZE TABLE QRTZ_FIRED_TRIGGERS;
ANALYZE TABLE QRTZ_JOB_DETAILS;
ANALYZE TABLE QRTZ_LOCKS;
ANALYZE TABLE QRTZ_PAUSED_TRIGGER_GRPS;
ANALYZE TABLE QRTZ_SCHEDULER_STATE;
ANALYZE TABLE QRTZ_SIMPLE_TRIGGERS;
ANALYZE TABLE QRTZ_SIMPROP_TRIGGERS;
ANALYZE TABLE QRTZ_TRIGGERS;
ANALYZE TABLE acl_role;
ANALYZE TABLE artifact_uuid_registry;
ANALYZE TABLE audit_trail_logs;
ANALYZE TABLE audit_trail_logs_metadata;
ANALYZE TABLE background_job;
ANALYZE TABLE background_job_meta;
ANALYZE TABLE background_step;
ANALYZE TABLE background_step_result;
ANALYZE TABLE chat_ops_mapping;
ANALYZE TABLE chat_ops_thread;
ANALYZE TABLE color_field_temp_table;
ANALYZE TABLE comp_field_ref_temp_table;
ANALYZE TABLE computed_update_job;
ANALYZE TABLE computed_update_job_item;
ANALYZE TABLE document_cache_data;
ANALYZE TABLE existing;
ANALYZE TABLE export_content_blobs;
ANALYZE TABLE export_job_report;
ANALYZE TABLE export_template_blobs;
ANALYZE TABLE field_recent_value;
ANALYZE TABLE id_filter_temp_table;
ANALYZE TABLE label;
ANALYZE TABLE locks;
ANALYZE TABLE monitoring_log;
ANALYZE TABLE object_approval_history;
ANALYZE TABLE object_approval_step;
ANALYZE TABLE object_approval_workflow;
ANALYZE TABLE object_association_type;
ANALYZE TABLE object_job_schedule;
ANALYZE TABLE object_quartz_schedule;
ANALYZE TABLE object_revision;
ANALYZE TABLE order_id_idx_temp_table;
ANALYZE TABLE page_view;
ANALYZE TABLE perftest_latency;
ANALYZE TABLE perftest_step;
ANALYZE TABLE perftest_varchar255;
ANALYZE TABLE permanent_link;
ANALYZE TABLE profile_met;
ANALYZE TABLE project_activity_log;
ANALYZE TABLE release_team_stats;
ANALYZE TABLE revision_filter_temp_table;
ANALYZE TABLE scm_submodule;
ANALYZE TABLE server_information;
ANALYZE TABLE session_history;
ANALYZE TABLE session_user_licenses;
ANALYZE TABLE task;
ANALYZE TABLE task_search_history;
ANALYZE TABLE task_type;
ANALYZE TABLE task_uuid_registry;
ANALYZE TABLE tomcat_session;
ANALYZE TABLE tomcat_session_blobs;
ANALYZE TABLE upgrade_statements;
ANALYZE TABLE user_key;
ANALYZE TABLE users;
ANALYZE TABLE version;
ANALYZE TABLE workingset;

