From ebecc44027af204c8f5ec8ca790a4753dbcf2fc3 Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Tue, 18 Dec 2012 01:00:07 -0500 Subject: [PATCH] Stamping upgrade script for frozen holds clear expire time Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...re_time.sql => 0747.data.frozen_holds_clear_expire_time.sql} | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.frozen_holds_clear_expire_time.sql => 0747.data.frozen_holds_clear_expire_time.sql} (77%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index d069cc0ae2..5fd64c17ce 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -87,7 +87,7 @@ CREATE TRIGGER no_overlapping_deps BEFORE INSERT OR UPDATE ON config.db_patch_dependencies FOR EACH ROW EXECUTE PROCEDURE evergreen.array_overlap_check ('deprecates'); -INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0746', :eg_version); -- mrpeters-isl/bshum +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0747', :eg_version); -- dyrcona/bshum CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.frozen_holds_clear_expire_time.sql b/Open-ILS/src/sql/Pg/upgrade/0747.data.frozen_holds_clear_expire_time.sql similarity index 77% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.frozen_holds_clear_expire_time.sql rename to Open-ILS/src/sql/Pg/upgrade/0747.data.frozen_holds_clear_expire_time.sql index 2bd15b8fc2..3dea928fa1 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.frozen_holds_clear_expire_time.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0747.data.frozen_holds_clear_expire_time.sql @@ -2,7 +2,7 @@ -- Set the expire_time to NULL on all frozen/suspended holds. BEGIN; -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0747', :eg_version); UPDATE action.hold_request SET expire_time = NULL -- 2.43.2