From e1853b2c4fa9c7c56e22b2bb06cb427dde9cc351 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Wed, 15 Jun 2016 15:08:53 -0400 Subject: [PATCH] Forward port 2.9.5 to 2.9.6 upgrade script. Signed-off-by: Jason Stephenson --- .../sql/Pg/version-upgrade/2.9.5-2.9.6-upgrade-db.sql | 11 +++++++++++ 1 file changed, 11 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/version-upgrade/2.9.5-2.9.6-upgrade-db.sql diff --git a/Open-ILS/src/sql/Pg/version-upgrade/2.9.5-2.9.6-upgrade-db.sql b/Open-ILS/src/sql/Pg/version-upgrade/2.9.5-2.9.6-upgrade-db.sql new file mode 100644 index 0000000000..a3190ff1f0 --- /dev/null +++ b/Open-ILS/src/sql/Pg/version-upgrade/2.9.5-2.9.6-upgrade-db.sql @@ -0,0 +1,11 @@ +--Upgrade Script for 2.9.5 to 2.9.6 +\set eg_version '''2.9.6''' +BEGIN; +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('2.9.6', :eg_version); + +SELECT evergreen.upgrade_deps_block_check('0981', :eg_version); + +CREATE INDEX hold_request_copy_capture_time_idx ON action.hold_request (current_copy,capture_time); +CREATE INDEX hold_request_open_captured_shelf_lib_idx ON action.hold_request (current_shelf_lib) WHERE capture_time IS NOT NULL AND fulfillment_time IS NULL AND (pickup_lib <> current_shelf_lib); + +COMMIT; -- 2.43.2