From 67f5d8882455a7e4d7dde545dfa4ad1b5a27a150 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 Conflicts: Open-ILS/src/sql/Pg/002.schema.config.sql Conflicts: Open-ILS/src/sql/Pg/002.schema.config.sql --- Open-ILS/src/sql/Pg/002.schema.config.sql | 3 +-- .../upgrade/0977.schema.allow_parts_to_be_recreated.sql} | 2 +- 2 files changed, 2 insertions(+), 3 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 62ac75a62e..e1e4a2cb17 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -91,8 +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 ('0949', :eg_version); -- csharp/kmlussier/dyrcona -INSERT INTO config.upgrade_log (version, applied_to) VALUES ('2.9.1', :eg_version); +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.11.0