From ebbdca4cde8eb4480266562a675545570d137ea4 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Mon, 27 Jul 2020 10:16:37 -0400 Subject: [PATCH] LP#1248734: (follow-up) add new indexes to schema update script Signed-off-by: Galen Charlton --- .../src/sql/Pg/upgrade/XXXX.schema.lp1248734_add_ws_to_ihu.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1248734_add_ws_to_ihu.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1248734_add_ws_to_ihu.sql index 5cb74bfb2d..a96e148faa 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1248734_add_ws_to_ihu.sql +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1248734_add_ws_to_ihu.sql @@ -5,4 +5,7 @@ BEGIN; ALTER TABLE action.in_house_use ADD COLUMN workstation INT REFERENCES actor.workstation (id) DEFERRABLE INITIALLY DEFERRED; ALTER TABLE action.non_cat_in_house_use ADD COLUMN workstation INT REFERENCES actor.workstation (id) DEFERRABLE INITIALLY DEFERRED; +CREATE INDEX action_in_house_use_ws_idx ON action.in_house_use ( workstation ); +CREATE INDEX non_cat_in_house_use_ws_idx ON action.non_cat_in_house_use ( workstation ); + COMMIT; -- 2.43.2