From 2135221774fc98edb2378bc929c763236bf1939c Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 20 Feb 2015 16:55:40 -0500 Subject: [PATCH] LP#1410369 stamping TPAC message center DB upgrade Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...schema.message-center.sql => 0910.schema.message-center.sql} | 2 +- ...YYY.data.message-center.sql => 0911.data.message-center.sql} | 2 ++ 3 files changed, 4 insertions(+), 2 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.message-center.sql => 0910.schema.message-center.sql} (97%) rename Open-ILS/src/sql/Pg/upgrade/{YYYY.data.message-center.sql => 0911.data.message-center.sql} (98%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index bc665c1428..39f93ce4ae 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 ('0909', :eg_version); -- berick/miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0911', :eg_version); -- miker/gmcharlt/berick CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.message-center.sql b/Open-ILS/src/sql/Pg/upgrade/0910.schema.message-center.sql similarity index 97% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.message-center.sql rename to Open-ILS/src/sql/Pg/upgrade/0910.schema.message-center.sql index 7e47618a09..181eeb2082 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.message-center.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0910.schema.message-center.sql @@ -1,6 +1,6 @@ BEGIN; -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('0910', :eg_version); CREATE TABLE actor.usr_message ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.message-center.sql b/Open-ILS/src/sql/Pg/upgrade/0911.data.message-center.sql similarity index 98% rename from Open-ILS/src/sql/Pg/upgrade/YYYY.data.message-center.sql rename to Open-ILS/src/sql/Pg/upgrade/0911.data.message-center.sql index e6ddf4cb87..96f04ab5ba 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.message-center.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0911.data.message-center.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0911', :eg_version); + -- Auto-cancelled, no target INSERT INTO action_trigger.event_definition ( id, active, owner, name, hook, -- 2.43.2