From 0842413f0ed21ec741a0f16b5cbb27f2018357fc Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Thu, 9 Apr 2015 21:58:07 -0400 Subject: [PATCH] LP#1442254: Stamping upgrade script for use-ws-lib-for-messages Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...for-messages.sql => 0916.schema.use-ws-lib-for-messages.sql} | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{ZZZZ.schema.use-ws-lib-for-messages.sql => 0916.schema.use-ws-lib-for-messages.sql} (91%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 2d5f0f5fe1..751ad1699d 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 ('0915', :eg_version); -- berick +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0916', :eg_version); -- gmcharlt/kmlussier/bshum CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.use-ws-lib-for-messages.sql b/Open-ILS/src/sql/Pg/upgrade/0916.schema.use-ws-lib-for-messages.sql similarity index 91% rename from Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.use-ws-lib-for-messages.sql rename to Open-ILS/src/sql/Pg/upgrade/0916.schema.use-ws-lib-for-messages.sql index 0163d0b09f..3cccc346e0 100644 --- a/Open-ILS/src/sql/Pg/upgrade/ZZZZ.schema.use-ws-lib-for-messages.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0916.schema.use-ws-lib-for-messages.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0916', :eg_version); + CREATE OR REPLACE FUNCTION actor.convert_usr_note_to_message () RETURNS TRIGGER AS $$ DECLARE sending_ou INTEGER; -- 2.43.2