From a0b5e1315d8d5133be555c822ce4bbc02d93cd8b Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Mon, 26 Oct 2015 14:48:47 -0400 Subject: [PATCH] JBAS-944 biblio.indexing_ingest_or_delete updates Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql | 9 ++++++++- 1 file changed, 8 insertions(+), 1 deletion(-) diff --git a/KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql b/KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql index ffa2c78f12..d3f20ac909 100644 --- a/KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql +++ b/KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql @@ -4247,7 +4247,14 @@ BEGIN DELETE FROM authority.bib_linking WHERE bib = NEW.id; -- Avoid updating fields in bibs that are no longer visible DELETE FROM biblio.peer_bib_copy_map WHERE peer_record = NEW.id; -- Separate any multi-homed items - DELETE FROM metabib.browse_entry_def_map WHERE source = NEW.id; -- Don't auto-suggest deleted bibs + -- KCLS + -- DELETE FROM metabib.browse_entry_def_map WHERE source = NEW.id; -- Don't auto-suggest deleted bibs + DELETE FROM metabib.browse_author_entry_def_map WHERE source = NEW.id; + DELETE FROM metabib.browse_series_entry_def_map WHERE source = NEW.id; + DELETE FROM metabib.browse_subject_entry_def_map WHERE source = NEW.id; + DELETE FROM metabib.browse_title_entry_def_map WHERE source = NEW.id; + DELETE FROM metabib.browse_call_number_entry_def_map WHERE source = NEW.id; + -- /KCLS RETURN NEW; -- and we're done END IF; -- 2.11.0