From 949660309b5e2496a126ab8464df30656ebb7dfe Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Thu, 7 Aug 2014 17:10:39 -0400 Subject: [PATCH] LP#1270289 - stamping upgrade scripts for acq cancel display Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...-cancel-display.sql => 0888.schema.acq-cancel-display.sql} | 4 +++- ...cq-cancel-display.sql => 0889.data.acq-cancel-display.sql} | 4 +++- 3 files changed, 7 insertions(+), 3 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.acq-cancel-display.sql => 0888.schema.acq-cancel-display.sql} (95%) rename Open-ILS/src/sql/Pg/upgrade/{XXXY.data.acq-cancel-display.sql => 0889.data.acq-cancel-display.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 f447d2f4b6..2278f15403 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 ('0887', :eg_version); -- miker/dyrcona +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0889', :eg_version); -- berick/kmlussier/bshum CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-cancel-display.sql b/Open-ILS/src/sql/Pg/upgrade/0888.schema.acq-cancel-display.sql similarity index 95% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-cancel-display.sql rename to Open-ILS/src/sql/Pg/upgrade/0888.schema.acq-cancel-display.sql index 7509e1f0d8..ad3c0dec42 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-cancel-display.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0888.schema.acq-cancel-display.sql @@ -1,6 +1,8 @@ - BEGIN; +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0888', :eg_version); + DROP VIEW acq.lineitem_summary; CREATE VIEW acq.lineitem_summary AS diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXY.data.acq-cancel-display.sql b/Open-ILS/src/sql/Pg/upgrade/0889.data.acq-cancel-display.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/XXXY.data.acq-cancel-display.sql rename to Open-ILS/src/sql/Pg/upgrade/0889.data.acq-cancel-display.sql index c32cb844b6..f454efc96f 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXY.data.acq-cancel-display.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0889.data.acq-cancel-display.sql @@ -1,6 +1,8 @@ - BEGIN; +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0889', :eg_version); + -- Update ACQ cancel reason names, but only those that -- have not already been locally modified from stock values. -- 2.43.2