From 5c678c44da735e74288cb2c2f2c251e3b10cf772 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Mon, 17 Jun 2019 15:50:06 -0400 Subject: [PATCH] JBAS-1832 Authority reingest addl sql logging Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/3.2-additions.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/KCLS/sql/schema/deploy/3.2-additions.sql b/KCLS/sql/schema/deploy/3.2-additions.sql index 5664e333e6..f4a8cb61a6 100644 --- a/KCLS/sql/schema/deploy/3.2-additions.sql +++ b/KCLS/sql/schema/deploy/3.2-additions.sql @@ -302,6 +302,8 @@ ALTER TABLE authority.record_entry DISABLE TRIGGER b_maintain_901; ALTER TABLE authority.record_entry DISABLE TRIGGER c_maintain_control_numbers; ALTER TABLE authority.record_entry DISABLE TRIGGER map_thesaurus_to_control_set; +SELECT CLOCK_TIMESTAMP(), 'Authority re-ingest started...'; + UPDATE authority.record_entry SET id = id WHERE NOT DELETED; ALTER TABLE authority.record_entry ENABLE TRIGGER a_marcxml_is_well_formed; -- 2.11.0