Convert SEEK mySQL database to UTF-8 (as of schema version 20140625135500)

utf8_conversion.sql

ALTER DATABASE seek_production CHARACTER SET utf8 COLLATE utf8_unicode_ci;

connect seek_production;

ALTER TABLE activity_logs CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;
ALTER TABLE admin_defined_role_projects CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE annotation_attributes CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE annotation_value_seeds CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE annotation_versions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE annotations CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE assay_assets CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE assay_auth_lookup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE assay_classes CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE assay_organisms CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE assay_types CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE assay_types_edges CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE assays CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE assays_samples CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE assets CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE assets_creators CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE attachments CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE auth_lookup_update_queues CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE avatars CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE bioportal_concepts CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE cell_ranges CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE compounds CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE content_blobs CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE culture_growth_types CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE cultures CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE data_file_auth_lookup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE data_file_versions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE data_file_versions_projects CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE data_files CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE data_files_events CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE data_files_projects CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE db_files CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE delayed_jobs CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE disciplines CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE disciplines_people CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE event_auth_lookup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE events CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE events_presentations CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE events_projects CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE events_publications CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE experimental_condition_links CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE experimental_conditions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE favourite_group_memberships CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE favourite_groups CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE favourites CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE forum_attachments CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE forums CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE genes CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE genotypes CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE group_memberships CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE group_memberships_project_roles CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE help_attachments CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE help_documents CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE help_images CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE institutions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE investigation_auth_lookup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE investigations CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE investigations_projects CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE mapping_links CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE mappings CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE measured_items CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE model_auth_lookup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE model_formats CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE model_images CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE model_types CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE model_versions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE model_versions_projects CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE models CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE models_projects CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE moderatorships CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE modifications CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE monitorships CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE notifiee_infos CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE number_value_versions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE number_values CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE organisms CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE organisms_projects CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE people CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE permissions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE phenotypes CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE policies CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE posts CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE presentation_auth_lookup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE presentation_versions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE presentation_versions_projects CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE presentations CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE presentations_projects CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE programmes CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE project_folder_assets CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE project_folders CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE project_roles CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE project_subscriptions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE projects CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE projects_publications CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE projects_samples CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE projects_sop_versions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE projects_sops CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE projects_specimens CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE projects_strains CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE projects_sweeps CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE projects_taverna_player_runs CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE projects_workflow_versions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE projects_workflows CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE publication_auth_lookup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE publication_author_orders CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE publication_authors CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE publications CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE recommended_model_environments CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE reindexing_queues CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE relationship_types CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE relationships CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE resource_publish_logs CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE sample_assets CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE sample_auth_lookup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE samples CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE samples_tissue_and_cell_types CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE saved_searches CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE scales CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE schema_migrations CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE sessions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE settings CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE site_announcement_categories CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE site_announcements CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE sop_auth_lookup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE sop_specimens CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE sop_versions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE sops CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE special_auth_codes CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE specimen_auth_lookup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE specimens CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE strain_auth_lookup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE strain_descendants CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE strains CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE studied_factor_links CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE studied_factors CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE studies CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE study_auth_lookup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE subscriptions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE sweep_auth_lookup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE sweeps CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE synonyms CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE taggings CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE tags CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE taverna_player_interactions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE taverna_player_run_auth_lookup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE taverna_player_run_ports CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE taverna_player_runs CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE taverna_player_service_credentials CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE technology_types CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE technology_types_edges CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE text_value_versions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE text_values CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE tissue_and_cell_types CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE topics CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE trash_records CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE treatments CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE units CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE users CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE work_groups CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE workflow_auth_lookup CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE workflow_categories CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE workflow_input_port_types CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE workflow_input_ports CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE workflow_output_port_types CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE workflow_output_ports CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE workflow_versions CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE workflows CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; 
ALTER TABLE worksheets CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci;