Update All system_mtimes In All ArchivesSpace Tables

gistfile1.txt

Don't Actually Run All The Commands At Once!!!

update  accession                          set system_mtime = NOW();
update  active_edit                        set system_mtime = NOW();
update  agent_contact                      set system_mtime = NOW();
update  agent_corporate_entity             set system_mtime = NOW();
update  agent_family                       set system_mtime = NOW();
update  agent_person                       set system_mtime = NOW();
update  agent_software                     set system_mtime = NOW();
update  archival_object                    set system_mtime = NOW();
update  aspace-dts_schema_info             set system_mtime = NOW();
update  assessment                         set system_mtime = NOW();
update  assessment_attribute               set system_mtime = NOW();
update  assessment_attribute_definition    set system_mtime = NOW();
update  assessment_attribute_note          set system_mtime = NOW();
update  assessment_reviewer_rlshp          set system_mtime = NOW();
update  assessment_rlshp                   set system_mtime = NOW();
update  auth_db                            set system_mtime = NOW();
update  classification                     set system_mtime = NOW();
update  classification_creator_rlshp       set system_mtime = NOW();
update  classification_rlshp               set system_mtime = NOW();
update  classification_term                set system_mtime = NOW();
update  classification_term_creator_rlshp  set system_mtime = NOW();
update  collection_management              set system_mtime = NOW();
update  container_profile                  set system_mtime = NOW();
update  custom_report_template             set system_mtime = NOW();
update  date                               set system_mtime = NOW();
update  deaccession                        set system_mtime = NOW();
update  default_values                     set system_mtime = NOW();
update  deleted_records                    set system_mtime = NOW();
update  digital_object                     set system_mtime = NOW();
update  digital_object_component           set system_mtime = NOW();
update  enumeration                        set system_mtime = NOW();
update  enumeration_value                  set system_mtime = NOW();
update  event                              set system_mtime = NOW();
update  event_link_rlshp                   set system_mtime = NOW();
update  extent                             set system_mtime = NOW();
update  external_document                  set system_mtime = NOW();
update  external_id                        set system_mtime = NOW();
update  file_version                       set system_mtime = NOW();
update  group                              set system_mtime = NOW();
update  group_permission                   set system_mtime = NOW();
update  group_user                         set system_mtime = NOW();
update  instance                           set system_mtime = NOW();
update  instance_do_link_rlshp             set system_mtime = NOW();
update  job                                set system_mtime = NOW();
update  job_created_record                 set system_mtime = NOW();
update  job_input_file                     set system_mtime = NOW();
update  job_modified_record                set system_mtime = NOW();
update  linked_agent_term                  set system_mtime = NOW();
update  linked_agents_rlshp                set system_mtime = NOW();
update  location                           set system_mtime = NOW();
update  location_function                  set system_mtime = NOW();
update  location_profile                   set system_mtime = NOW();
update  location_profile_rlshp             set system_mtime = NOW();
update  name_authority_id                  set system_mtime = NOW();
update  name_corporate_entity              set system_mtime = NOW();
update  name_family                        set system_mtime = NOW();
update  name_person                        set system_mtime = NOW();
update  name_software                      set system_mtime = NOW();
update  note                               set system_mtime = NOW();
update  note_persistent_id                 set system_mtime = NOW();
update  notification                       set system_mtime = NOW();
update  oai_config                         set system_mtime = NOW();
update  owner_repo_rlshp                   set system_mtime = NOW();
update  permission                         set system_mtime = NOW();
update  preference                         set system_mtime = NOW();
update  rde_template                       set system_mtime = NOW();
update  related_accession_rlshp            set system_mtime = NOW();
update  related_agents_rlshp               set system_mtime = NOW();
update  repository                         set system_mtime = NOW();
update  required_fields                    set system_mtime = NOW();
update  resource                           set system_mtime = NOW();
update  resource_delete                    set system_mtime = NOW();
update  resource_update                    set system_mtime = NOW();
update  resource_update_via_ao             set system_mtime = NOW();
update  resource_update_via_do             set system_mtime = NOW();
update  resource_update_via_do_ao          set system_mtime = NOW();
update  resource_update_via_doc            set system_mtime = NOW();
update  resource_update_via_doc_do_ao      set system_mtime = NOW();
update  resource_update_via_r              set system_mtime = NOW();
update  resource_updates_schema_info       set system_mtime = NOW();
update  revision_statement                 set system_mtime = NOW();
update  rights_restriction                 set system_mtime = NOW();
update  rights_restriction_type            set system_mtime = NOW();
update  rights_statement                   set system_mtime = NOW();
update  rights_statement_act               set system_mtime = NOW();
update  rights_statement_pre_088           set system_mtime = NOW();
update  schema_info                        set system_mtime = NOW();
update  sequence                           set system_mtime = NOW();
update  session                            set system_mtime = NOW();
update  spawned_rlshp                      set system_mtime = NOW();
update  sub_container                      set system_mtime = NOW();
update  subject                            set system_mtime = NOW();
update  subject_rlshp                      set system_mtime = NOW();
update  subject_term                       set system_mtime = NOW();
update  subnote_metadata                   set system_mtime = NOW();
update  surveyed_by_rlshp                  set system_mtime = NOW();
update  system_event                       set system_mtime = NOW();
update  telephone                          set system_mtime = NOW();
update  term                               set system_mtime = NOW();
update  top_container                      set system_mtime = NOW();
update  top_container_housed_at_rlshp      set system_mtime = NOW();
update  top_container_link_rlshp           set system_mtime = NOW();
update  top_container_profile_rlshp        set system_mtime = NOW();
update  user                               set system_mtime = NOW();
update  user_defined                       set system_mtime = NOW();
update  vocabulary                         set system_mtime = NOW();