Skip to content

Instantly share code, notes, and snippets.

@kehh
Last active December 15, 2015 09:59
Show Gist options
  • Save kehh/5242861 to your computer and use it in GitHub Desktop.
Save kehh/5242861 to your computer and use it in GitHub Desktop.
BEGIN;
update `accession` set source_culture = 'en_AU' where source_culture = 'en';
update `acl_group` set source_culture = 'en_AU' where source_culture = 'en';
update `actor` set source_culture = 'en_AU' where source_culture = 'en';
update `contact_information` set source_culture = 'en_AU' where source_culture = 'en';
update `deaccession` set source_culture = 'en_AU' where source_culture = 'en';
update `event` set source_culture = 'en_AU' where source_culture = 'en';
update `function` set source_culture = 'en_AU' where source_culture = 'en';
update `information_object` set source_culture = 'en_AU' where source_culture = 'en';
update `menu` set source_culture = 'en_AU' where source_culture = 'en';
update `note` set source_culture = 'en_AU' where source_culture = 'en';
update `other_name` set source_culture = 'en_AU' where source_culture = 'en';
update `physical_object` set source_culture = 'en_AU' where source_culture = 'en';
update `property` set source_culture = 'en_AU' where source_culture = 'en';
update `relation` set source_culture = 'en_AU' where source_culture = 'en';
update `repository` set source_culture = 'en_AU' where source_culture = 'en';
update `rights` set source_culture = 'en_AU' where source_culture = 'en';
update `static_page` set source_culture = 'en_AU' where source_culture = 'en';
SHOW WARNINGS;
begin;
delete from `accession_i18n` where culture = 'en_AU'; replace into `accession_i18n` (appraisal,id,title,source_of_acquisition,scope_and_content,received_extent_units,processing_notes,physical_characteristics,location_information,archival_history, culture) select appraisal,id,title,source_of_acquisition,scope_and_content,received_extent_units,processing_notes,physical_characteristics,location_information,archival_history, 'en_AU' as culture from `accession_i18n` where culture = 'en';
delete from `acl_group_i18n` where culture = 'en_AU'; replace into `acl_group_i18n` (id,description,name, culture) select id,description,name, 'en_AU' as culture from `acl_group_i18n` where culture = 'en';
delete from `actor_i18n` where culture = 'en_AU'; replace into `actor_i18n` (id,revision_history,sources,rules,institution_responsible_identifier,general_context,internal_structures,mandates,functions,legal_status,places,history,dates_of_existence,authorized_form_of_name, culture) select id,revision_history,sources,rules,institution_responsible_identifier,general_context,internal_structures,mandates,functions,legal_status,places,history,dates_of_existence,authorized_form_of_name, 'en_AU' as culture from `actor_i18n` where culture = 'en';
delete from `contact_information_i18n` where culture = 'en_AU'; replace into `contact_information_i18n` (id,note,region,city,contact_type, culture) select id,note,region,city,contact_type, 'en_AU' as culture from `contact_information_i18n` where culture = 'en';
delete from `deaccession_i18n` where culture = 'en_AU'; replace into `deaccession_i18n` (description,extent,reason,id, culture) select description,extent,reason,id, 'en_AU' as culture from `deaccession_i18n` where culture = 'en';
delete from `event_i18n` where culture = 'en_AU'; replace into `event_i18n` (id,date,description,name, culture) select id,date,description,name, 'en_AU' as culture from `event_i18n` where culture = 'en';
delete from `function_i18n` where culture = 'en_AU'; replace into `function_i18n` (id,sources,rules,revision_history,institution_identifier,legislation,history,description,dates,classification,authorized_form_of_name, culture) select id,sources,rules,revision_history,institution_identifier,legislation,history,description,dates,classification,authorized_form_of_name, 'en_AU' as culture from `function_i18n` where culture = 'en';
delete from `information_object_i18n` where culture = 'en_AU'; replace into `information_object_i18n` (location_of_copies,location_of_originals,finding_aids,physical_characteristics,related_units_of_description,institution_responsible_identifier,rules,sources,revision_history,id,reproduction_conditions,access_conditions,title,alternate_title,edition,extent_and_medium,archival_history,acquisition,scope_and_content,appraisal,accruals,arrangement, culture) select location_of_copies,location_of_originals,finding_aids,physical_characteristics,related_units_of_description,institution_responsible_identifier,rules,sources,revision_history,id,reproduction_conditions,access_conditions,title,alternate_title,edition,extent_and_medium,archival_history,acquisition,scope_and_content,appraisal,accruals,arrangement, 'en_AU' as culture from `information_object_i18n` where culture = 'en';
delete from `loan_i18n` where culture = 'en_AU'; replace into `loan_i18n` (id,title,considerations,description, culture) select id,title,considerations,description, 'en_AU' as culture from `loan_i18n` where culture = 'en';
delete from `menu_i18n` where culture = 'en_AU'; replace into `menu_i18n` (label,description,id, culture) select label,description,id, 'en_AU' as culture from `menu_i18n` where culture = 'en';
delete from `note_i18n` where culture = 'en_AU'; replace into `note_i18n` (content,id, culture) select content,id, 'en_AU' as culture from `note_i18n` where culture = 'en';
delete from `other_name_i18n` where culture = 'en_AU'; replace into `other_name_i18n` (id,dates,note,name, culture) select id,dates,note,name, 'en_AU' as culture from `other_name_i18n` where culture = 'en';
delete from `physical_object_i18n` where culture = 'en_AU'; replace into `physical_object_i18n` (name,description,location,id, culture) select name,description,location,id, 'en_AU' as culture from `physical_object_i18n` where culture = 'en';
delete from `property_i18n` where culture = 'en_AU'; replace into `property_i18n` (value,id, culture) select value,id, 'en_AU' as culture from `property_i18n` where culture = 'en';
delete from `relation_i18n` where culture = 'en_AU'; replace into `relation_i18n` (id,date,description, culture) select id,date,description, 'en_AU' as culture from `relation_i18n` where culture = 'en';
delete from `repository_i18n` where culture = 'en_AU'; replace into `repository_i18n` (id,desc_revision_history,desc_sources,desc_rules,desc_institution_identifier,public_facilities,reproduction_services,research_services,disabled_access,geocultural_context,collecting_policies,buildings,holdings,finding_aids,opening_times,access_conditions, culture) select id,desc_revision_history,desc_sources,desc_rules,desc_institution_identifier,public_facilities,reproduction_services,research_services,disabled_access,geocultural_context,collecting_policies,buildings,holdings,finding_aids,opening_times,access_conditions, 'en_AU' as culture from `repository_i18n` where culture = 'en';
delete from `rights_i18n` where culture = 'en_AU'; replace into `rights_i18n` (id,statute_note,statute_citation,statute_jurisdiction,license_note,license_terms,license_identifier,copyright_note,rights_note, culture) select id,statute_note,statute_citation,statute_jurisdiction,license_note,license_terms,license_identifier,copyright_note,rights_note, 'en_AU' as culture from `rights_i18n` where culture = 'en';
delete from `setting_i18n` where culture = 'en_AU'; replace into `setting_i18n` (value,id, culture) select value,id, 'en_AU' as culture from `setting_i18n` where culture = 'en';
delete from `static_page_i18n` where culture = 'en_AU'; replace into `static_page_i18n` (id,content,title, culture) select id,content,title, 'en_AU' as culture from `static_page_i18n` where culture = 'en';
delete from `taxonomy_i18n` where culture = 'en_AU'; replace into `taxonomy_i18n` (name,note,id, culture) select name,note,id, 'en_AU' as culture from `taxonomy_i18n` where culture = 'en';
delete from `term_i18n` where culture = 'en_AU'; replace into `term_i18n` (name,id, culture) select name,id, 'en_AU' as culture from `term_i18n` where culture = 'en';
SHOW WARNINGS;
COMMIT;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment