Skip to content

Instantly share code, notes, and snippets.

@Blake-
Last active June 1, 2023 14:52
Show Gist options
  • Star 2 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save Blake-/538c8d7cc7ade39efc372a3e3e190873 to your computer and use it in GitHub Desktop.
Save Blake-/538c8d7cc7ade39efc372a3e3e190873 to your computer and use it in GitHub Desktop.
Update all tables in ArchivesSpace to force a reindex
This will force a solr reindex w/o needing to clear out the /data/ directory
UPDATE accession 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 assessment set system_mtime = NOW();
update classification set system_mtime = NOW();
update classification_term set system_mtime = NOW();
update collection_management set system_mtime = NOW();
update container_profile set system_mtime = NOW();
update date set system_mtime = NOW();
update deaccession 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 event set system_mtime = NOW();
update extent set system_mtime = NOW();
update instance 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 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 repository set system_mtime = NOW();
update resource set system_mtime = NOW();
update rights_statement set system_mtime = NOW();
update subject set system_mtime = NOW();
update term set system_mtime = NOW();
update top_container set system_mtime = NOW();
update vocabulary set system_mtime = NOW();
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment