From 6be131cd20392d961f3bc1520e3b3b865a31b7ee Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Thu, 21 Jan 2016 11:21:32 -0500 Subject: [PATCH] JBAS-1129 Remove KCLS custom language filter SQL No need to track a separate language_filter table, since we have the same data available via coded value maps. Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/2.5-to-2.7-upgrade.sql | 7 +++++++ 1 file changed, 7 insertions(+) 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 007091cc00..7e066d27eb 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 @@ -8934,6 +8934,13 @@ CREATE OR REPLACE VIEW extend_reporter.full_circ_count AS + (SELECT COUNT(*) FROM action.aged_circulation WHERE target_copy = cp.id) AS circ_count FROM asset.copy cp; +-- KCLS: deprecating custom language filter code. +-- This means removing a bunch of deprecated SQL. + +DROP TRIGGER IF EXISTS language_filter_trigger ON biblio.record_entry; +DROP FUNCTION IF EXISTS biblio.update_language_filter(); +DROP TABLE IF EXISTS metabib.language_filter; + COMMIT; -- 2.11.0