From 510d4febcbb666a6ca944470969e94e800f9de00 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 26 May 2017 12:09:49 -0400 Subject: [PATCH] LP#1672775 Stamping A/T purge SQL upgrade Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...e-events.sql => 1043.schema.action-trigger-purge-events.sql} | 2 +- ...rge-events.sql => 1044.data.action-trigger-purge-events.sql} | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.action-trigger-purge-events.sql => 1043.schema.action-trigger-purge-events.sql} (98%) rename Open-ILS/src/sql/Pg/upgrade/{YYYY.data.action-trigger-purge-events.sql => 1044.data.action-trigger-purge-events.sql} (86%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index da3a39d442..b19894ace3 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 ('1042', :eg_version); -- mmorgan/gmcharlt +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1044', :eg_version); -- berick/gmcharlt CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.action-trigger-purge-events.sql b/Open-ILS/src/sql/Pg/upgrade/1043.schema.action-trigger-purge-events.sql similarity index 98% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.action-trigger-purge-events.sql rename to Open-ILS/src/sql/Pg/upgrade/1043.schema.action-trigger-purge-events.sql index 30f4dd6cac..6f0939bde4 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.action-trigger-purge-events.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1043.schema.action-trigger-purge-events.sql @@ -1,6 +1,6 @@ BEGIN; --- SELECT evergreen.upgrade_deps_block_check('1XXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1043', :eg_version); ALTER TABLE action_trigger.event_definition ADD COLUMN retention_interval INTERVAL; diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.action-trigger-purge-events.sql b/Open-ILS/src/sql/Pg/upgrade/1044.data.action-trigger-purge-events.sql similarity index 86% rename from Open-ILS/src/sql/Pg/upgrade/YYYY.data.action-trigger-purge-events.sql rename to Open-ILS/src/sql/Pg/upgrade/1044.data.action-trigger-purge-events.sql index 1c790529cc..4dd3473f25 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.action-trigger-purge-events.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1044.data.action-trigger-purge-events.sql @@ -1,6 +1,6 @@ BEGIN; --- SELECT evergreen.upgrade_deps_block_check('1XXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1044', :eg_version); UPDATE action_trigger.hook SET passive = FALSE WHERE key IN ( 'format.po.html', -- 2.43.2