From bb9225c7164cd485068eeca0a96b913dbcc4856f Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 17 May 2017 13:14:17 -0400 Subject: [PATCH] LP#1673799 Stamping EDI query SQL update Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...ge_remote_file.sql => 1040.schema.index_edi_message_remote_file.sql} | 2 +- 2 files changed, 2 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.index_edi_message_remote_file.sql => 1040.schema.index_edi_message_remote_file.sql} (62%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index febaca136e..c8f34197ac 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 ('1039', :eg_version); -- jeffdavis/gmcharlt +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1040', :eg_version); --gmcharlt/berick CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.index_edi_message_remote_file.sql b/Open-ILS/src/sql/Pg/upgrade/1040.schema.index_edi_message_remote_file.sql similarity index 62% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.index_edi_message_remote_file.sql rename to Open-ILS/src/sql/Pg/upgrade/1040.schema.index_edi_message_remote_file.sql index 41691618ba..1395573a2b 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.index_edi_message_remote_file.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1040.schema.index_edi_message_remote_file.sql @@ -1,6 +1,6 @@ BEGIN; --- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1040', :eg_version); CREATE INDEX edi_message_remote_file_idx ON acq.edi_message (evergreen.lowercase(remote_file)); -- 2.11.0