/*!40101 SET @OLD_CHARACTER_SET_CLIENT = @@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS = @@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION = @@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE = @@TIME_ZONE */;
/*!40103 SET TIME_ZONE = '+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS = @@UNIQUE_CHECKS, UNIQUE_CHECKS = 0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS = @@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS = 0 */;
/*!40101 SET @OLD_SQL_MODE = @@SQL_MODE, SQL_MODE = 'NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES = @@SQL_NOTES, SQL_NOTES = 0 */;
ALTER TABLE `address_hierarchy_address_to_entry_map` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `address_hierarchy_entry` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `address_hierarchy_level` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `allergy` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `allergy_reaction` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `appframework_component_state` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `appframework_user_app` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `appointmentscheduling_appointment` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `appointmentscheduling_appointment_block` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `appointmentscheduling_appointment_request` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `appointmentscheduling_appointment_status_history` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `appointmentscheduling_appointment_type` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `appointmentscheduling_block_type_map` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `appointmentscheduling_time_slot` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `calculation_registration` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `care_setting` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `chartsearch_bookmark` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `chartsearch_categories` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `chartsearch_category_displayname` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `chartsearch_history` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `chartsearch_note` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `chartsearch_preference` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `chartsearch_synonym_groups` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `chartsearch_synonyms` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `clob_datatype_storage` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `cohort` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `cohort_member` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_answer` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_attribute` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_attribute_type` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_class` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_complex` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_datatype` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_description` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_map_type` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_name` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_name_tag` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_name_tag_map` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_numeric` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_proposal` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_proposal_tag_map` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_reference_map` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_reference_source` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_reference_term` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_reference_term_map` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_set` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_state_conversion` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `concept_stop_word` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `conditions` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `dataintegrity_result` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `dataintegrity_rule` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `drug` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `drug_ingredient` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `drug_order` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `drug_reference_map` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `encounter` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `encounter_provider` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `encounter_role` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `encounter_type` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `field` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `field_answer` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `field_type` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `fingerprint` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `form` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `form_field` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `form_resource` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `formfilter_filter_property` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `formfilter_form_filter` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `global_property` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `hl7_in_archive` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `hl7_in_error` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `hl7_in_queue` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `hl7_source` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `htmlformentry_html_form` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `idgen_auto_generation_option` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `idgen_id_pool` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `idgen_identifier_source` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `idgen_log_entry` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `idgen_pooled_identifier` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `idgen_remote_source` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `idgen_reserved_identifier` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `idgen_seq_id_gen` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `liquibasechangelog` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `liquibasechangeloglock` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `location` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `location_attribute` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `location_attribute_type` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `location_tag` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `location_tag_map` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `metadatamapping_metadata_set` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `metadatamapping_metadata_set_member` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `metadatamapping_metadata_source` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `metadatamapping_metadata_term_mapping` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `metadatasharing_exported_package` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `metadatasharing_imported_item` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `metadatasharing_imported_package` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `note` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `notification_alert` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `notification_alert_recipient` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `notification_template` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `obs` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `openconceptlab_item` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `openconceptlab_update` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `order_frequency` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `order_group` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `order_set` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `order_set_member` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `order_type` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `order_type_class_map` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `orders` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `patient` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `patient_identifier` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `patient_identifier_type` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `patient_program` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `patient_state` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `patientflags_displaypoint` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `patientflags_flag` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `patientflags_flag_tag` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `patientflags_priority` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `patientflags_tag` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `patientflags_tag_displayPoint` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `person` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `person_address` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `person_attribute` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `person_attribute_type` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `person_merge_log` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `person_name` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `privilege` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `program` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `program_workflow` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `program_workflow_state` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `provider` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `provider_attribute` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `provider_attribute_type` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `providermanagement_provider_role` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `providermanagement_provider_role_provider_attribute_type` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `providermanagement_provider_role_relationship_type` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `providermanagement_provider_role_supervisee_provider_role` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `providermanagement_provider_suggestion` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `providermanagement_supervision_suggestion` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `relationship` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `relationship_type` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `report_object` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `report_schema_xml` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `reporting_report_design` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `reporting_report_design_resource` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `reporting_report_processor` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `reporting_report_request` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `role` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `role_privilege` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `role_role` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `scheduler_task_config` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `scheduler_task_config_property` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `serialized_object` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `test_order` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `uiframework_user_defined_page_view` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `user_property` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `user_role` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `users` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `visit` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `visit_attribute` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `visit_attribute_type` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `visit_type` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `xforms_medical_history_field` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `xforms_person_repeat_attribute` CONVERT TO CHARACTER SET UTF8;
ALTER TABLE `xforms_xform` CONVERT TO CHARACTER SET UTF8;