Skip to content

Instantly share code, notes, and snippets.

@kehh

kehh/fix_ca_locales_en_AU.sql

Created January 20, 2017 06:26
Show Gist options
  • Save kehh/069dd8a18cb638212e43c204c3b393e5 to your computer and use it in GitHub Desktop.
Save kehh/069dd8a18cb638212e43c204c3b393e5 to your computer and use it in GitHub Desktop.
Download ZIP
Fix CollectiveAccess locales. Replaces all en_US locales with en_AU. Removes all other locale values.
Raw
fix_ca_locales_en_AU.sql
UPDATE ca_attributes SET locale_id = 1 WHERE locale_id <> 1;
UPDATE ca_data_importer_labels SET locale_id = 1 WHERE locale_id <> 1;
DELETE FROM ca_editor_ui_labels WHERE locale_id <> 1;
DELETE from ca_editor_ui_screen_labels WHERE locale_id <> 1;
UPDATE ca_entities SET locale_id = 1 WHERE locale_id <> 1;
UPDATE ca_entity_labels SET locale_id = 1 WHERE locale_id <> 1;
UPDATE ca_list_item_labels SET locale_id = 1 WHERE locale_id = 13;
DELETE FROM ca_list_item_labels WHERE locale_id <> 1;
DELETE FROM ca_list_labels WHERE locale_id <> 1;
UPDATE ca_loan_labels SET locale_id = 1 WHERE locale_id <> 1;
DELETE FROM ca_metadata_element_labels WHERE locale_id <> 1;
UPDATE ca_object_labels SET locale_id = 1 WHERE locale_id <> 1;
UPDATE ca_objects SET locale_id = 1 WHERE locale_id <> 1;
UPDATE ca_occurrence_labels SET locale_id = 1 WHERE locale_id <> 1;
UPDATE ca_occurrences SET locale_id = 1 WHERE locale_id <> 1;
UPDATE ca_place_labels SET locale_id = 1 WHERE locale_id <> 1;
UPDATE ca_places SET locale_id = 1 WHERE locale_id <> 1;
DELETE FROM ca_relationship_type_labels WHERE locale_id <> 1;
DELETE FROM ca_search_form_labels WHERE locale_id <> 1;
DELETE from ca_locales WHERE locale_id <> 1;
UPDATE ca_locales SET name = 'English (Australia)', country = 'AU' WHERE locale_id = 1;
UPDATE ca_users SET vars = TO_BASE64(REPLACE(FROM_BASE64(vars),'en_US', 'en_AU')) WHERE FROM_BASE64(vars) LIKE '%en_US%';
UPDATE ca_application_vars SET vars = TO_BASE64(REPLACE(FROM_BASE64(vars),'en_US', 'en_AU')) WHERE FROM_BASE64(vars) LIKE '%en_US%';
UPDATE ca_set_items SET vars = TO_BASE64(REPLACE(FROM_BASE64(vars),'en_US', 'en_AU')) WHERE FROM_BASE64(vars) LIKE '%en_US%';
UPDATE ca_user_groups SET vars = TO_BASE64(REPLACE(FROM_BASE64(vars),'en_US', 'en_AU')) WHERE FROM_BASE64(vars) LIKE '%en_US%';
UPDATE ca_user_roles SET vars = TO_BASE64(REPLACE(FROM_BASE64(vars),'en_US', 'en_AU')) WHERE FROM_BASE64(vars) LIKE '%en_US%';
UPDATE ca_bundle_display_placements SET settings = TO_BASE64(REPLACE(FROM_BASE64(settings),'en_US', 'en_AU')) WHERE FROM_BASE64(settings) LIKE '%en_US%';
UPDATE ca_bundle_display_type_restrictions SET settings = TO_BASE64(REPLACE(FROM_BASE64(settings),'en_US', 'en_AU')) WHERE FROM_BASE64(settings) LIKE '%en_US%';
UPDATE ca_bundle_displays SET settings = TO_BASE64(REPLACE(FROM_BASE64(settings),'en_US', 'en_AU')) WHERE FROM_BASE64(settings) LIKE '%en_US%';
UPDATE ca_data_exporter_items SET settings = TO_BASE64(REPLACE(FROM_BASE64(settings),'en_US', 'en_AU')) WHERE FROM_BASE64(settings) LIKE '%en_US%';
UPDATE ca_data_exporters SET settings = TO_BASE64(REPLACE(FROM_BASE64(settings),'en_US', 'en_AU')) WHERE FROM_BASE64(settings) LIKE '%en_US%';
UPDATE ca_data_importer_groups SET settings = TO_BASE64(REPLACE(FROM_BASE64(settings),'en_US', 'en_AU')) WHERE FROM_BASE64(settings) LIKE '%en_US%';
UPDATE ca_data_importer_items SET settings = TO_BASE64(REPLACE(FROM_BASE64(settings),'en_US', 'en_AU')) WHERE FROM_BASE64(settings) LIKE '%en_US%';
UPDATE ca_data_importers SET settings = TO_BASE64(REPLACE(FROM_BASE64(settings),'en_US', 'en_AU')) WHERE FROM_BASE64(settings) LIKE '%en_US%';
UPDATE ca_editor_ui_bundle_placement_type_restrictions SET settings = TO_BASE64(REPLACE(FROM_BASE64(settings),'en_US', 'en_AU')) WHERE FROM_BASE64(settings) LIKE '%en_US%';
UPDATE ca_editor_ui_bundle_placements SET settings = TO_BASE64(REPLACE(FROM_BASE64(settings),'en_US', 'en_AU')) WHERE FROM_BASE64(settings) LIKE '%en_US%';
UPDATE ca_editor_ui_screen_type_restrictions SET settings = TO_BASE64(REPLACE(FROM_BASE64(settings),'en_US', 'en_AU')) WHERE FROM_BASE64(settings) LIKE '%en_US%';
UPDATE ca_editor_ui_type_restrictions SET settings = TO_BASE64(REPLACE(FROM_BASE64(settings),'en_US', 'en_AU')) WHERE FROM_BASE64(settings) LIKE '%en_US%';
UPDATE ca_list_items SET settings = TO_BASE64(REPLACE(FROM_BASE64(settings),'en_US', 'en_AU')) WHERE FROM_BASE64(settings) LIKE '%en_US%';
UPDATE ca_metadata_dictionary_entries SET settings = TO_BASE64(REPLACE(FROM_BASE64(settings),'en_US', 'en_AU')) WHERE FROM_BASE64(settings) LIKE '%en_US%';
UPDATE ca_metadata_dictionary_rules SET settings = TO_BASE64(REPLACE(FROM_BASE64(settings),'en_US', 'en_AU')) WHERE FROM_BASE64(settings) LIKE '%en_US%';
UPDATE ca_metadata_elements SET settings = TO_BASE64(REPLACE(FROM_BASE64(settings),'en_US', 'en_AU')) WHERE FROM_BASE64(settings) LIKE '%en_US%';
UPDATE ca_metadata_type_restrictions SET settings = TO_BASE64(REPLACE(FROM_BASE64(settings),'en_US', 'en_AU')) WHERE FROM_BASE64(settings) LIKE '%en_US%';
UPDATE ca_search_form_placements SET settings = TO_BASE64(REPLACE(FROM_BASE64(settings),'en_US', 'en_AU')) WHERE FROM_BASE64(settings) LIKE '%en_US%';
UPDATE ca_search_forms SET settings = TO_BASE64(REPLACE(FROM_BASE64(settings),'en_US', 'en_AU')) WHERE FROM_BASE64(settings) LIKE '%en_US%';
UPDATE ca_attribute_value_multifiles SET media_metadata = TO_BASE64(REPLACE(FROM_BASE64(media_metadata),'en_US', 'en_AU')) WHERE FROM_BASE64(media_metadata) LIKE '%en_US%';
UPDATE ca_attribute_values SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_bundle_display_labels SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_collection_labels SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_collections SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_collections_x_collections SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_collections_x_storage_locations SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_collections_x_vocabulary_terms SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_data_exporter_labels SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_data_importer_labels SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_data_importers SET rules = TO_BASE64(REPLACE(FROM_BASE64(rules),'en_US', 'en_AU')) WHERE FROM_BASE64(rules) LIKE '%en_US%';
UPDATE ca_entities SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_entities_x_collections SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_entities_x_entities SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_entities_x_occurrences SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_entities_x_places SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_entities_x_storage_locations SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_entities_x_vocabulary_terms SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_entity_labels SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_list_item_labels SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_list_items SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_list_items_x_list_items SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_loan_labels SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_loans SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_loans_x_collections SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_loans_x_entities SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_loans_x_loans SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_loans_x_movements SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_loans_x_object_lots SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_loans_x_object_representations SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_loans_x_objects SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_loans_x_occurrences SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_loans_x_places SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_loans_x_storage_locations SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_loans_x_vocabulary_terms SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_movement_labels SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_movements SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_movements_x_collections SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_movements_x_entities SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_movements_x_movements SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_movements_x_object_lots SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_movements_x_object_representations SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_movements_x_objects SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_movements_x_occurrences SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_movements_x_places SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_movements_x_storage_locations SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_movements_x_vocabulary_terms SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_object_labels SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_object_lot_labels SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_object_lots SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_object_lots_x_collections SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_object_lots_x_entities SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_object_lots_x_object_lots SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_object_lots_x_object_representations SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_object_lots_x_occurrences SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_object_lots_x_places SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_object_lots_x_storage_locations SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_object_lots_x_vocabulary_terms SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_object_representation_labels SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_object_representation_multifiles SET media_metadata = TO_BASE64(REPLACE(FROM_BASE64(media_metadata),'en_US', 'en_AU')) WHERE FROM_BASE64(media_metadata) LIKE '%en_US%';
UPDATE ca_object_representations SET media_metadata = TO_BASE64(REPLACE(FROM_BASE64(media_metadata),'en_US', 'en_AU')) WHERE FROM_BASE64(media_metadata) LIKE '%en_US%';
UPDATE ca_object_representations SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_object_representations_x_collections SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_object_representations_x_entities SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_object_representations_x_object_representations SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_object_representations_x_occurrences SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_object_representations_x_places SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_object_representations_x_storage_locations SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_object_representations_x_vocabulary_terms SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_objects SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_objects_x_collections SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_objects_x_entities SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_objects_x_objects SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_objects_x_occurrences SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_objects_x_places SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_objects_x_storage_locations SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_objects_x_vocabulary_terms SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_occurrence_labels SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_occurrences SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_occurrences_x_collections SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_occurrences_x_occurrences SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_occurrences_x_storage_locations SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_occurrences_x_vocabulary_terms SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_place_labels SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_places SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_places_x_collections SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_places_x_occurrences SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_places_x_places SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_places_x_storage_locations SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_places_x_vocabulary_terms SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_relationship_relationships SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_representation_annotation_labels SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_representation_annotations SET props = TO_BASE64(REPLACE(FROM_BASE64(props),'en_US', 'en_AU')) WHERE FROM_BASE64(props) LIKE '%en_US%';
UPDATE ca_representation_annotations SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_representation_annotations_x_entities SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_representation_annotations_x_objects SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_representation_annotations_x_occurrences SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_representation_annotations_x_places SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_representation_annotations_x_vocabulary_terms SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_search_form_labels SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_search_indexing_queue SET field_data = TO_BASE64(REPLACE(FROM_BASE64(field_data),'en_US', 'en_AU')) WHERE FROM_BASE64(field_data) LIKE '%en_US%';
UPDATE ca_search_indexing_queue SET changed_fields = TO_BASE64(REPLACE(FROM_BASE64(changed_fields),'en_US', 'en_AU')) WHERE FROM_BASE64(changed_fields) LIKE '%en_US%';
UPDATE ca_search_indexing_queue SET options = TO_BASE64(REPLACE(FROM_BASE64(options),'en_US', 'en_AU')) WHERE FROM_BASE64(options) LIKE '%en_US%';
UPDATE ca_search_indexing_queue SET dependencies = TO_BASE64(REPLACE(FROM_BASE64(dependencies),'en_US', 'en_AU')) WHERE FROM_BASE64(dependencies) LIKE '%en_US%';
UPDATE ca_storage_location_labels SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_storage_locations SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_storage_locations_x_storage_locations SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_storage_locations_x_vocabulary_terms SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_tour_stops_x_collections SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_tour_stops_x_entities SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_tour_stops_x_objects SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_tour_stops_x_occurrences SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_tour_stops_x_places SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_tour_stops_x_tour_stops SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_tour_stops_x_vocabulary_terms SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_tours SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_user_representation_annotation_labels SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_user_representation_annotations SET props = TO_BASE64(REPLACE(FROM_BASE64(props),'en_US', 'en_AU')) WHERE FROM_BASE64(props) LIKE '%en_US%';
UPDATE ca_user_representation_annotations SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_user_representation_annotations_x_entities SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_user_representation_annotations_x_objects SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_user_representation_annotations_x_occurrences SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_user_representation_annotations_x_places SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_user_representation_annotations_x_vocabulary_terms SET source_info = TO_BASE64(REPLACE(FROM_BASE64(source_info),'en_US', 'en_AU')) WHERE FROM_BASE64(source_info) LIKE '%en_US%';
UPDATE ca_user_roles SET field_access = TO_BASE64(REPLACE(FROM_BASE64(field_access),'en_US', 'en_AU')) WHERE FROM_BASE64(field_access) LIKE '%en_US%';
UPDATE ca_users SET volatile_vars = TO_BASE64(REPLACE(FROM_BASE64(volatile_vars),'en_US', 'en_AU')) WHERE FROM_BASE64(volatile_vars) LIKE '%en_US%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment