From 3c1b6d0a129a45e6073e78cdeaaf2c59515b83cd Mon Sep 17 00:00:00 2001 From: Dan Wells Date: Tue, 27 Feb 2018 16:08:46 -0500 Subject: [PATCH] LP#1737016 Stamping upgrade script for easing constraints on afs.code Signed-off-by: Dan Wells --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...schema.lp1737016_afs_code.sql => 1091.schema.lp1737016_afs_code.sql} | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.lp1737016_afs_code.sql => 1091.schema.lp1737016_afs_code.sql} (79%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index e8fa263da7..b230584993 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 ('1090', :eg_version); -- berick/dbwells +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1091', :eg_version); -- jboyer/dbwells CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1737016_afs_code.sql b/Open-ILS/src/sql/Pg/upgrade/1091.schema.lp1737016_afs_code.sql similarity index 79% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1737016_afs_code.sql rename to Open-ILS/src/sql/Pg/upgrade/1091.schema.lp1737016_afs_code.sql index bea3fb53a4..9d0e69f4d9 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1737016_afs_code.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1091.schema.lp1737016_afs_code.sql @@ -1,6 +1,6 @@ BEGIN; -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1091', :eg_version); ALTER TABLE acq.funding_source DROP CONSTRAINT funding_source_code_key; ALTER TABLE acq.funding_source ALTER COLUMN code SET NOT NULL; -- 2.11.0