From 5ea850143880cccf233c5a55d6bfdb67acfe32e0 Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Mon, 14 Mar 2016 14:46:19 -0400 Subject: [PATCH] LP#1550495: stamp DB update Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ....cancel_reason-add-85.sql => 0972.data.acq-cancel_reason-add-85.sql} | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{xxxx.acq.cancel_reason-add-85.sql => 0972.data.acq-cancel_reason-add-85.sql} (85%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 8d6b9cdfaf..36cdbc8bea 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 ('0971', :eg_version); -- csharp/Dyrcona +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0972', :eg_version); -- jstompro/gmcharlt CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/xxxx.acq.cancel_reason-add-85.sql b/Open-ILS/src/sql/Pg/upgrade/0972.data.acq-cancel_reason-add-85.sql similarity index 85% rename from Open-ILS/src/sql/Pg/upgrade/xxxx.acq.cancel_reason-add-85.sql rename to Open-ILS/src/sql/Pg/upgrade/0972.data.acq-cancel_reason-add-85.sql index d2e2273bb9..ac27300125 100644 --- a/Open-ILS/src/sql/Pg/upgrade/xxxx.acq.cancel_reason-add-85.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0972.data.acq-cancel_reason-add-85.sql @@ -1,6 +1,6 @@ BEGIN; --- INSERT INTO config.upgrade_log (version) VALUES ('xxxx'); +SELECT evergreen.upgrade_deps_block_check('0972', :eg_version); -- jstompro/gmcharlt -- LP#1550495 - Add Baker&Taylor EDI Quantity Cancel Code -- Insert EDI Cancel Reason 85 (1200 + 85 = 1285) if it doesn't already exist -- 2.11.0