From 5b667747affb7c136eb4bb9f84657469c5efc208 Mon Sep 17 00:00:00 2001 From: Jason Stephenson Date: Fri, 31 Mar 2023 09:22:12 -0400 Subject: [PATCH] Back port 1362 DB Upgrade We have the index in the database, so I'm back porting the script to prevent it from being added to future upgrades via my make-db-upgrade script. Signed-off-by: Jason Stephenson --- .../src/sql/Pg/upgrade/1362.schema.add-hopeless-date-index.sql | 9 +++++++++ 1 file changed, 9 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/1362.schema.add-hopeless-date-index.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/1362.schema.add-hopeless-date-index.sql b/Open-ILS/src/sql/Pg/upgrade/1362.schema.add-hopeless-date-index.sql new file mode 100644 index 0000000000..9fd49fd77d --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/1362.schema.add-hopeless-date-index.sql @@ -0,0 +1,9 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('1362', :eg_version); + +CREATE INDEX hold_request_hopeless_date_idx ON action.hold_request (hopeless_date); + +COMMIT; + +ANALYZE action.hold_request; -- 2.11.0