Attachment 27099 Details for Bug 11811 – script to change collation of Koha's tables to utf8_unicode_ci

script to change collation of Koha's tables to utf8_unicode_ci

change-collation.sql (text/plain), 13.35 KB, created by Galen Charlton on 2014-04-14 16:22:33 UTC

(hide)

Description:

Filename:

MIME Type:

Creator: Galen Charlton

Created: 2014-04-14 16:22:33 UTC

Size: 13.35 KB

patch

obsolete

>set foreign_key_checks = 0;
>alter table accountlines convert to character set utf8 collate utf8_unicode_ci;
>alter table accountoffsets convert to character set utf8 collate utf8_unicode_ci;
>alter table action_logs convert to character set utf8 collate utf8_unicode_ci;
>alter table alert convert to character set utf8 collate utf8_unicode_ci;
>alter table aqbasket convert to character set utf8 collate utf8_unicode_ci;
>alter table aqbasketgroups convert to character set utf8 collate utf8_unicode_ci;
>alter table aqbasketusers convert to character set utf8 collate utf8_unicode_ci;
>alter table aqbooksellers convert to character set utf8 collate utf8_unicode_ci;
>alter table aqbudgetborrowers convert to character set utf8 collate utf8_unicode_ci;
>alter table aqbudgetperiods convert to character set utf8 collate utf8_unicode_ci;
>alter table aqbudgets convert to character set utf8 collate utf8_unicode_ci;
>alter table aqbudgets_planning convert to character set utf8 collate utf8_unicode_ci;
>alter table aqcontract convert to character set utf8 collate utf8_unicode_ci;
>alter table aqinvoices convert to character set utf8 collate utf8_unicode_ci;
>alter table aqorders convert to character set utf8 collate utf8_unicode_ci;
>alter table aqorders_items convert to character set utf8 collate utf8_unicode_ci;
>alter table aqorders_transfers convert to character set utf8 collate utf8_unicode_ci;
>alter table auth_header convert to character set utf8 collate utf8_unicode_ci;
>alter table auth_subfield_structure convert to character set utf8 collate utf8_unicode_ci;
>alter table auth_tag_structure convert to character set utf8 collate utf8_unicode_ci;
>alter table auth_types convert to character set utf8 collate utf8_unicode_ci;
>alter table authorised_values convert to character set utf8 collate utf8_unicode_ci;
>alter table authorised_values_branches convert to character set utf8 collate utf8_unicode_ci;
>alter table biblio convert to character set utf8 collate utf8_unicode_ci;
>alter table biblio_framework convert to character set utf8 collate utf8_unicode_ci;
>alter table biblioimages convert to character set utf8 collate utf8_unicode_ci;
>alter table biblioitems convert to character set utf8 collate utf8_unicode_ci;
>alter table borrower_attribute_types convert to character set utf8 collate utf8_unicode_ci;
>alter table borrower_attribute_types_branches convert to character set utf8 collate utf8_unicode_ci;
>alter table borrower_attributes convert to character set utf8 collate utf8_unicode_ci;
>alter table borrower_debarments convert to character set utf8 collate utf8_unicode_ci;
>alter table borrower_files convert to character set utf8 collate utf8_unicode_ci;
>alter table borrower_message_preferences convert to character set utf8 collate utf8_unicode_ci;
>alter table borrower_message_transport_preferences convert to character set utf8 collate utf8_unicode_ci;
>alter table borrower_modifications convert to character set utf8 collate utf8_unicode_ci;
>alter table borrowers convert to character set utf8 collate utf8_unicode_ci;
>alter table branch_borrower_circ_rules convert to character set utf8 collate utf8_unicode_ci;
>alter table branch_item_rules convert to character set utf8 collate utf8_unicode_ci;
>alter table branch_transfer_limits convert to character set utf8 collate utf8_unicode_ci;
>alter table branchcategories convert to character set utf8 collate utf8_unicode_ci;
>alter table branches convert to character set utf8 collate utf8_unicode_ci;
>alter table branchrelations convert to character set utf8 collate utf8_unicode_ci;
>alter table branchtransfers convert to character set utf8 collate utf8_unicode_ci;
>alter table browser convert to character set utf8 collate utf8_unicode_ci;
>alter table categories convert to character set utf8 collate utf8_unicode_ci;
>alter table categories_branches convert to character set utf8 collate utf8_unicode_ci;
>alter table cities convert to character set utf8 collate utf8_unicode_ci;
>alter table class_sort_rules convert to character set utf8 collate utf8_unicode_ci;
>alter table class_sources convert to character set utf8 collate utf8_unicode_ci;
>alter table collections convert to character set utf8 collate utf8_unicode_ci;
>alter table collections_tracking convert to character set utf8 collate utf8_unicode_ci;
>alter table course_instructors convert to character set utf8 collate utf8_unicode_ci;
>alter table course_items convert to character set utf8 collate utf8_unicode_ci;
>alter table course_reserves convert to character set utf8 collate utf8_unicode_ci;
>alter table courses convert to character set utf8 collate utf8_unicode_ci;
>alter table creator_batches convert to character set utf8 collate utf8_unicode_ci;
>alter table creator_images convert to character set utf8 collate utf8_unicode_ci;
>alter table creator_layouts convert to character set utf8 collate utf8_unicode_ci;
>alter table creator_templates convert to character set utf8 collate utf8_unicode_ci;
>alter table currency convert to character set utf8 collate utf8_unicode_ci;
>alter table default_borrower_circ_rules convert to character set utf8 collate utf8_unicode_ci;
>alter table default_branch_circ_rules convert to character set utf8 collate utf8_unicode_ci;
>alter table default_branch_item_rules convert to character set utf8 collate utf8_unicode_ci;
>alter table default_circ_rules convert to character set utf8 collate utf8_unicode_ci;
>alter table deletedbiblio convert to character set utf8 collate utf8_unicode_ci;
>alter table deletedbiblioitems convert to character set utf8 collate utf8_unicode_ci;
>alter table deletedborrowers convert to character set utf8 collate utf8_unicode_ci;
>alter table deleteditems convert to character set utf8 collate utf8_unicode_ci;
>alter table ethnicity convert to character set utf8 collate utf8_unicode_ci;
>alter table export_format convert to character set utf8 collate utf8_unicode_ci;
>alter table fieldmapping convert to character set utf8 collate utf8_unicode_ci;
>alter table foo convert to character set utf8 collate utf8_unicode_ci;
>alter table hold_fill_targets convert to character set utf8 collate utf8_unicode_ci;
>alter table import_auths convert to character set utf8 collate utf8_unicode_ci;
>alter table import_batches convert to character set utf8 collate utf8_unicode_ci;
>alter table import_biblios convert to character set utf8 collate utf8_unicode_ci;
>alter table import_items convert to character set utf8 collate utf8_unicode_ci;
>alter table import_record_matches convert to character set utf8 collate utf8_unicode_ci;
>alter table import_records convert to character set utf8 collate utf8_unicode_ci;
>alter table issues convert to character set utf8 collate utf8_unicode_ci;
>alter table issuingrules convert to character set utf8 collate utf8_unicode_ci;
>alter table item_circulation_alert_preferences convert to character set utf8 collate utf8_unicode_ci;
>alter table items convert to character set utf8 collate utf8_unicode_ci;
>alter table itemtypes convert to character set utf8 collate utf8_unicode_ci;
>alter table language_descriptions convert to character set utf8 collate utf8_unicode_ci;
>alter table language_rfc4646_to_iso639 convert to character set utf8 collate utf8_unicode_ci;
>alter table language_script_bidi convert to character set utf8 collate utf8_unicode_ci;
>alter table language_script_mapping convert to character set utf8 collate utf8_unicode_ci;
>alter table language_subtag_registry convert to character set utf8 collate utf8_unicode_ci;
>alter table letter convert to character set utf8 collate utf8_unicode_ci;
>alter table linktracker convert to character set utf8 collate utf8_unicode_ci;
>alter table marc_matchers convert to character set utf8 collate utf8_unicode_ci;
>alter table marc_modification_template_actions convert to character set utf8 collate utf8_unicode_ci;
>alter table marc_modification_templates convert to character set utf8 collate utf8_unicode_ci;
>alter table marc_subfield_structure convert to character set utf8 collate utf8_unicode_ci;
>alter table marc_tag_structure convert to character set utf8 collate utf8_unicode_ci;
>alter table matchchecks convert to character set utf8 collate utf8_unicode_ci;
>alter table matcher_matchpoints convert to character set utf8 collate utf8_unicode_ci;
>alter table matchpoint_component_norms convert to character set utf8 collate utf8_unicode_ci;
>alter table matchpoint_components convert to character set utf8 collate utf8_unicode_ci;
>alter table matchpoints convert to character set utf8 collate utf8_unicode_ci;
>alter table message_attributes convert to character set utf8 collate utf8_unicode_ci;
>alter table message_queue convert to character set utf8 collate utf8_unicode_ci;
>alter table message_transport_types convert to character set utf8 collate utf8_unicode_ci;
>alter table message_transports convert to character set utf8 collate utf8_unicode_ci;
>alter table messages convert to character set utf8 collate utf8_unicode_ci;
>alter table need_merge_authorities convert to character set utf8 collate utf8_unicode_ci;
>alter table notifys convert to character set utf8 collate utf8_unicode_ci;
>alter table oai_sets convert to character set utf8 collate utf8_unicode_ci;
>alter table oai_sets_biblios convert to character set utf8 collate utf8_unicode_ci;
>alter table oai_sets_descriptions convert to character set utf8 collate utf8_unicode_ci;
>alter table oai_sets_mappings convert to character set utf8 collate utf8_unicode_ci;
>alter table old_issues convert to character set utf8 collate utf8_unicode_ci;
>alter table old_reserves convert to character set utf8 collate utf8_unicode_ci;
>alter table opac_news convert to character set utf8 collate utf8_unicode_ci;
>alter table overduerules convert to character set utf8 collate utf8_unicode_ci;
>alter table patron_list_patrons convert to character set utf8 collate utf8_unicode_ci;
>alter table patron_lists convert to character set utf8 collate utf8_unicode_ci;
>alter table patroncards convert to character set utf8 collate utf8_unicode_ci;
>alter table patronimage convert to character set utf8 collate utf8_unicode_ci;
>alter table pending_offline_operations convert to character set utf8 collate utf8_unicode_ci;
>alter table permissions convert to character set utf8 collate utf8_unicode_ci;
>alter table plugin_data convert to character set utf8 collate utf8_unicode_ci;
>alter table printers convert to character set utf8 collate utf8_unicode_ci;
>alter table printers_profile convert to character set utf8 collate utf8_unicode_ci;
>alter table quotes convert to character set utf8 collate utf8_unicode_ci;
>alter table ratings convert to character set utf8 collate utf8_unicode_ci;
>alter table repeatable_holidays convert to character set utf8 collate utf8_unicode_ci;
>alter table reports_dictionary convert to character set utf8 collate utf8_unicode_ci;
>alter table reserveconstraints convert to character set utf8 collate utf8_unicode_ci;
>alter table reserves convert to character set utf8 collate utf8_unicode_ci;
>alter table reviews convert to character set utf8 collate utf8_unicode_ci;
>alter table saved_reports convert to character set utf8 collate utf8_unicode_ci;
>alter table saved_sql convert to character set utf8 collate utf8_unicode_ci;
>alter table search_history convert to character set utf8 collate utf8_unicode_ci;
>alter table serial convert to character set utf8 collate utf8_unicode_ci;
>alter table serialitems convert to character set utf8 collate utf8_unicode_ci;
>alter table services_throttle convert to character set utf8 collate utf8_unicode_ci;
>alter table sessions convert to character set utf8 collate utf8_unicode_ci;
>alter table social_data convert to character set utf8 collate utf8_unicode_ci;
>alter table special_holidays convert to character set utf8 collate utf8_unicode_ci;
>alter table statistics convert to character set utf8 collate utf8_unicode_ci;
>alter table stopwords convert to character set utf8 collate utf8_unicode_ci;
>alter table subscription convert to character set utf8 collate utf8_unicode_ci;
>alter table subscription_frequencies convert to character set utf8 collate utf8_unicode_ci;
>alter table subscription_numberpatterns convert to character set utf8 collate utf8_unicode_ci;
>alter table subscriptionhistory convert to character set utf8 collate utf8_unicode_ci;
>alter table subscriptionroutinglist convert to character set utf8 collate utf8_unicode_ci;
>alter table suggestions convert to character set utf8 collate utf8_unicode_ci;
>alter table systempreferences convert to character set utf8 collate utf8_unicode_ci;
>alter table tags convert to character set utf8 collate utf8_unicode_ci;
>alter table tags_all convert to character set utf8 collate utf8_unicode_ci;
>alter table tags_approval convert to character set utf8 collate utf8_unicode_ci;
>alter table tags_index convert to character set utf8 collate utf8_unicode_ci;
>alter table tmp_accountlines convert to character set utf8 collate utf8_unicode_ci;
>alter table tmp_holdsqueue convert to character set utf8 collate utf8_unicode_ci;
>alter table transport_cost convert to character set utf8 collate utf8_unicode_ci;
>alter table user_permissions convert to character set utf8 collate utf8_unicode_ci;
>alter table userflags convert to character set utf8 collate utf8_unicode_ci;
>alter table virtualshelfcontents convert to character set utf8 collate utf8_unicode_ci;
>alter table virtualshelfshares convert to character set utf8 collate utf8_unicode_ci;
>alter table virtualshelves convert to character set utf8 collate utf8_unicode_ci;
>alter table z3950servers convert to character set utf8 collate utf8_unicode_ci;
>alter table zebraqueue convert to character set utf8 collate utf8_unicode_ci;
>set foreign_key_checks = 1;

Actions: View

Attachments on bug 11811: 25616 | 25628 | 25629 | 26059 | 26060 | 26102 | 26375 | 27099