From cc0ef7448c8a92f1715dd1726aead4409a8b0e08 Mon Sep 17 00:00:00 2001 From: Dan Wells Date: Fri, 7 Jun 2013 15:31:37 -0400 Subject: [PATCH] Stamping upgrade script for purge holds functionality Signed-off-by: Dan Wells --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...ion.purge_holds.sql => 0797.schema.action.purge_holds.sql} | 4 ++++ 2 files changed, 5 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.action.purge_holds.sql => 0797.schema.action.purge_holds.sql} (99%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 769ad25601..e7f467f6a5 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -91,7 +91,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 ('0796', :eg_version); -- berick/dbwells +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0797', :eg_version); -- tsbere/Dyrcona/dbwells CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.action.purge_holds.sql b/Open-ILS/src/sql/Pg/upgrade/0797.schema.action.purge_holds.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.action.purge_holds.sql rename to Open-ILS/src/sql/Pg/upgrade/0797.schema.action.purge_holds.sql index 538985615c..dc50c9272f 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.action.purge_holds.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0797.schema.action.purge_holds.sql @@ -1,3 +1,6 @@ +BEGIN; + +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0797', :eg_version); -- tsbere/Dyrcona/dbwells -- New global flags for the purge function INSERT INTO config.global_flag (name, label, enabled) @@ -366,3 +369,4 @@ CREATE TRIGGER action_hold_request_aging_tgr FOR EACH ROW EXECUTE PROCEDURE action.age_hold_on_delete (); +COMMIT; -- 2.43.2