From b11da34c3d94b25f2a3c5877849e9484d48c6a84 Mon Sep 17 00:00:00 2001 From: Lebbeous Fogle-Weekley Date: Wed, 13 Mar 2013 15:09:31 -0400 Subject: [PATCH] Upgrade script numbering for acq order indentifier selector Signed-off-by: Lebbeous Fogle-Weekley --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...ema.acq-order-ident.sql => 0776.schema.acq-order-ident.sql} | 3 ++- ....data.acq-order-ident.sql => 0777.data.acq-order-ident.sql} | 3 ++- ...ema.acq-multi-attrs.sql => 0778.schema.acq-multi-attrs.sql} | 3 ++- 4 files changed, 7 insertions(+), 4 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.acq-order-ident.sql => 0776.schema.acq-order-ident.sql} (91%) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.acq-order-ident.sql => 0777.data.acq-order-ident.sql} (99%) rename Open-ILS/src/sql/Pg/upgrade/{YYYY.schema.acq-multi-attrs.sql => 0778.schema.acq-multi-attrs.sql} (98%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index a11edd5250..649d665bab 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 ('0775', :eg_version); -- berick/miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0778', :eg_version); -- berick/senator CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-order-ident.sql b/Open-ILS/src/sql/Pg/upgrade/0776.schema.acq-order-ident.sql similarity index 91% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-order-ident.sql rename to Open-ILS/src/sql/Pg/upgrade/0776.schema.acq-order-ident.sql index a0b09ee80d..2185e5535e 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.acq-order-ident.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0776.schema.acq-order-ident.sql @@ -1,6 +1,7 @@ - BEGIN; +SELECT evergreen.upgrade_deps_block_check('0776', :eg_version); + ALTER TABLE acq.lineitem_attr ADD COLUMN order_ident BOOLEAN NOT NULL DEFAULT FALSE; diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.acq-order-ident.sql b/Open-ILS/src/sql/Pg/upgrade/0777.data.acq-order-ident.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.acq-order-ident.sql rename to Open-ILS/src/sql/Pg/upgrade/0777.data.acq-order-ident.sql index c5d467b72c..4146b16baf 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.acq-order-ident.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0777.data.acq-order-ident.sql @@ -1,6 +1,7 @@ - BEGIN; +SELECT evergreen.upgrade_deps_block_check('0777', :eg_version); + -- Listed here for reference / ease of access. The update -- is not applied here (see the WHERE clause). UPDATE action_trigger.event_definition SET template = diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.acq-multi-attrs.sql b/Open-ILS/src/sql/Pg/upgrade/0778.schema.acq-multi-attrs.sql similarity index 98% rename from Open-ILS/src/sql/Pg/upgrade/YYYY.schema.acq-multi-attrs.sql rename to Open-ILS/src/sql/Pg/upgrade/0778.schema.acq-multi-attrs.sql index cbe837ffbd..1cd2880609 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.acq-multi-attrs.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0778.schema.acq-multi-attrs.sql @@ -1,6 +1,7 @@ - BEGIN; +SELECT evergreen.upgrade_deps_block_check('0778', :eg_version); + CREATE OR REPLACE FUNCTION extract_marc_field_set (TEXT, BIGINT, TEXT, TEXT) RETURNS SETOF TEXT AS $$ DECLARE -- 2.43.2