From 2d5002c76cf31369d3c3745019ca5904831a07f7 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Fri, 1 Sep 2017 13:26:05 -0400 Subject: [PATCH] Stamp upgrade scripts for native EDI support Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../{XXXX.schema.edi_attr_set.sql => 1062.schema.edi_attr_set.sql} | 2 +- ...raint-trigger.sql => 1063.schema.inheritance-constraint-trigger.sql} | 2 ++ ...schema.issuance_scap_fkey.sql => 1064.schema.issuance_scap_fkey.sql} | 2 ++ ...l_pattern_templates.sql => 1065.schema.serial_pattern_templates.sql} | 2 +- .../sql/Pg/upgrade/{YYYY.data.spt_perms.sql => 1066.data.spt_perms.sql} | 2 +- .../upgrade/{YYYY.data.edi_attr_set.sql => 1067.data.edi_attr_set.sql} | 2 +- 7 files changed, 9 insertions(+), 5 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.edi_attr_set.sql => 1062.schema.edi_attr_set.sql} (92%) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.inheritance-constraint-trigger.sql => 1063.schema.inheritance-constraint-trigger.sql} (95%) rename Open-ILS/src/sql/Pg/upgrade/{ZZZZ.schema.issuance_scap_fkey.sql => 1064.schema.issuance_scap_fkey.sql} (90%) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.serial_pattern_templates.sql => 1065.schema.serial_pattern_templates.sql} (92%) rename Open-ILS/src/sql/Pg/upgrade/{YYYY.data.spt_perms.sql => 1066.data.spt_perms.sql} (90%) rename Open-ILS/src/sql/Pg/upgrade/{YYYY.data.edi_attr_set.sql => 1067.data.edi_attr_set.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 5962835ffd..ad1dd7c65e 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -90,7 +90,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 ('1061', :eg_version); -- berick/kmlussier/cesardv/phasefx +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1067', :eg_version); -- berick/gmcharlt/miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.edi_attr_set.sql b/Open-ILS/src/sql/Pg/upgrade/1062.schema.edi_attr_set.sql similarity index 92% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.edi_attr_set.sql rename to Open-ILS/src/sql/Pg/upgrade/1062.schema.edi_attr_set.sql index 970f54284a..bbf7e7a61a 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.edi_attr_set.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1062.schema.edi_attr_set.sql @@ -1,6 +1,6 @@ BEGIN; --- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1062', :eg_version); CREATE TABLE acq.edi_attr ( key TEXT PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.inheritance-constraint-trigger.sql b/Open-ILS/src/sql/Pg/upgrade/1063.schema.inheritance-constraint-trigger.sql similarity index 95% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.inheritance-constraint-trigger.sql rename to Open-ILS/src/sql/Pg/upgrade/1063.schema.inheritance-constraint-trigger.sql index 94f40007f0..06a8e8051f 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.inheritance-constraint-trigger.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1063.schema.inheritance-constraint-trigger.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('1063', :eg_version); + DO $temp$ DECLARE r RECORD; diff --git a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.issuance_scap_fkey.sql b/Open-ILS/src/sql/Pg/upgrade/1064.schema.issuance_scap_fkey.sql similarity index 90% rename from Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.issuance_scap_fkey.sql rename to Open-ILS/src/sql/Pg/upgrade/1064.schema.issuance_scap_fkey.sql index d27f8bc974..f30f3b504c 100644 --- a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.issuance_scap_fkey.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1064.schema.issuance_scap_fkey.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('1064', :eg_version); + ALTER TABLE serial.issuance DROP CONSTRAINT IF EXISTS issuance_caption_and_pattern_fkey; -- Using NOT VALID and VALIDATE CONSTRAINT limits the impact to concurrent work. diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.serial_pattern_templates.sql b/Open-ILS/src/sql/Pg/upgrade/1065.schema.serial_pattern_templates.sql similarity index 92% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.serial_pattern_templates.sql rename to Open-ILS/src/sql/Pg/upgrade/1065.schema.serial_pattern_templates.sql index d396682841..c9795e807f 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.serial_pattern_templates.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1065.schema.serial_pattern_templates.sql @@ -1,6 +1,6 @@ BEGIN; --- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1065', :eg_version); CREATE TABLE serial.pattern_template ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.spt_perms.sql b/Open-ILS/src/sql/Pg/upgrade/1066.data.spt_perms.sql similarity index 90% rename from Open-ILS/src/sql/Pg/upgrade/YYYY.data.spt_perms.sql rename to Open-ILS/src/sql/Pg/upgrade/1066.data.spt_perms.sql index 2ceef9134f..6c076de99f 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.spt_perms.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1066.data.spt_perms.sql @@ -1,6 +1,6 @@ BEGIN; --- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1066', :eg_version); INSERT INTO permission.perm_list ( id, code, description ) VALUES ( 593, 'ADMIN_SERIAL_PATTERN_TEMPLATE', oils_i18n_gettext( 593, diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.edi_attr_set.sql b/Open-ILS/src/sql/Pg/upgrade/1067.data.edi_attr_set.sql similarity index 98% rename from Open-ILS/src/sql/Pg/upgrade/YYYY.data.edi_attr_set.sql rename to Open-ILS/src/sql/Pg/upgrade/1067.data.edi_attr_set.sql index 8ca76431bd..aaaa6b3885 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.edi_attr_set.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1067.data.edi_attr_set.sql @@ -1,6 +1,6 @@ BEGIN; --- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1067', :eg_version); INSERT INTO acq.edi_attr (key, label) VALUES ('INCLUDE_PO_NAME', -- 2.11.0