From d0eede6c1adb5657deb9b3f99cfed07feb0bb80b Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 31 Aug 2016 10:31:09 -0400 Subject: [PATCH] JBAS-1419 CO history usr index (LP#1615736) Signed-off-by: Bill Erickson --- KCLS/sql/schema/deploy/patron-co-history-table.sql | 2 ++ 1 file changed, 2 insertions(+) diff --git a/KCLS/sql/schema/deploy/patron-co-history-table.sql b/KCLS/sql/schema/deploy/patron-co-history-table.sql index 46ef1e35b0..89a1fa8331 100644 --- a/KCLS/sql/schema/deploy/patron-co-history-table.sql +++ b/KCLS/sql/schema/deploy/patron-co-history-table.sql @@ -24,6 +24,8 @@ CREATE TRIGGER action_usr_circ_history_target_copy_trig AFTER INSERT OR UPDATE ON action.usr_circ_history FOR EACH ROW EXECUTE PROCEDURE evergreen.fake_fkey_tgr('target_copy'); +CREATE INDEX action_usr_circ_history_usr_idx ON action.usr_circ_history (usr); + CREATE OR REPLACE FUNCTION action.maintain_usr_circ_history() RETURNS TRIGGER AS $FUNK$ DECLARE -- 2.11.0