From eca2ef927d263a4d9379fa331174c018fd170d3f Mon Sep 17 00:00:00 2001 From: Galen Charlton Date: Thu, 28 Apr 2016 11:31:20 -0400 Subject: [PATCH] LP#1569884: stamp schema update Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../upgrade/0977.schema.allow_parts_to_be_recreated.sql} | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/{XXXX.schema.allow_parts_to_be_recreated.sql => Pg/upgrade/0977.schema.allow_parts_to_be_recreated.sql} (67%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 2a92f1c726..95766bf371 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 ('0976', :eg_version); -- berick/kmlussier +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0977', :eg_version); -- Callender/Dyrcona/gmcharlt CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/XXXX.schema.allow_parts_to_be_recreated.sql b/Open-ILS/src/sql/Pg/upgrade/0977.schema.allow_parts_to_be_recreated.sql similarity index 67% rename from Open-ILS/src/sql/XXXX.schema.allow_parts_to_be_recreated.sql rename to Open-ILS/src/sql/Pg/upgrade/0977.schema.allow_parts_to_be_recreated.sql index c403a5d27d..1c220b70ff 100644 --- a/Open-ILS/src/sql/XXXX.schema.allow_parts_to_be_recreated.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0977.schema.allow_parts_to_be_recreated.sql @@ -1,6 +1,6 @@ BEGIN; -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0977', :eg_version); -- Callender/Dyrcona/gmcharlt ALTER TABLE biblio.monograph_part DROP CONSTRAINT "record_label_unique"; CREATE UNIQUE INDEX record_label_unique_idx ON biblio.monograph_part (record, label) WHERE deleted = FALSE; -- 2.43.2