From b930174c8c3cf75309993e9f90d9fb8d816e4d23 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Fri, 1 Sep 2017 17:17:16 -0400 Subject: [PATCH] Stamping upgrade scripts for Display Fields and Vandelay regression Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ....metabib-display-field.sql => 1073.schema.metabib-display-field.sql} | 2 ++ ...ta.metabib-display-field.sql => 1074.data.metabib-display-field.sql} | 2 ++ ...X.schema.fix_vii_fake_fkey.sql => 1075.schema.fix_vii_fake_fkey.sql} | 2 ++ 4 files changed, 7 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.metabib-display-field.sql => 1073.schema.metabib-display-field.sql} (99%) rename Open-ILS/src/sql/Pg/upgrade/{YYYY.data.metabib-display-field.sql => 1074.data.metabib-display-field.sql} (94%) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.fix_vii_fake_fkey.sql => 1075.schema.fix_vii_fake_fkey.sql} (89%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index ff27a68126..06c7836c6a 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -92,7 +92,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 ('1072', :eg_version); -- gmcharlt/kmlussier +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1075', :eg_version); -- gmcharlt/miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.metabib-display-field.sql b/Open-ILS/src/sql/Pg/upgrade/1073.schema.metabib-display-field.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.metabib-display-field.sql rename to Open-ILS/src/sql/Pg/upgrade/1073.schema.metabib-display-field.sql index 2e452b97c9..a0c4e6cc3f 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.metabib-display-field.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1073.schema.metabib-display-field.sql @@ -1,6 +1,8 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('1073', :eg_version); + ALTER TABLE config.metabib_field ADD COLUMN display_xpath TEXT, ADD COLUMN display_field BOOL NOT NULL DEFAULT FALSE; diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.metabib-display-field.sql b/Open-ILS/src/sql/Pg/upgrade/1074.data.metabib-display-field.sql similarity index 94% rename from Open-ILS/src/sql/Pg/upgrade/YYYY.data.metabib-display-field.sql rename to Open-ILS/src/sql/Pg/upgrade/1074.data.metabib-display-field.sql index 33fdac4b46..138686c608 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.metabib-display-field.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1074.data.metabib-display-field.sql @@ -1,6 +1,8 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('1074', :eg_version); + INSERT INTO config.internal_flag (name, enabled) VALUES ('ingest.skip_display_indexing', FALSE); diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_vii_fake_fkey.sql b/Open-ILS/src/sql/Pg/upgrade/1075.schema.fix_vii_fake_fkey.sql similarity index 89% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_vii_fake_fkey.sql rename to Open-ILS/src/sql/Pg/upgrade/1075.schema.fix_vii_fake_fkey.sql index 8c2b1e4bb3..346b8bf5ab 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.fix_vii_fake_fkey.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1075.schema.fix_vii_fake_fkey.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('1075', :eg_version); + CREATE OR REPLACE FUNCTION evergreen.vandelay_import_item_imported_as_inh_fkey() RETURNS TRIGGER AS $f$ BEGIN IF NEW.imported_as IS NULL THEN -- 2.11.0