From 12159383d46bf76db3e710a689ad8b5140436007 Mon Sep 17 00:00:00 2001 From: Mike Rylander Date: Wed, 24 Aug 2016 12:56:28 -0400 Subject: [PATCH] Stamping upgrade script for authority edit changes and propagation improvement Signed-off-by: Mike Rylander --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...ropage-edit-date.sql => 0994.schema.authority-propage-edit-date.sql} | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.authority-propage-edit-date.sql => 0994.schema.authority-propage-edit-date.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 d7438fb656..1e1dac8165 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 ('0993', :eg_version); -- berick/miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0994', :eg_version); -- berick/miker CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.authority-propage-edit-date.sql b/Open-ILS/src/sql/Pg/upgrade/0994.schema.authority-propage-edit-date.sql similarity index 98% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.authority-propage-edit-date.sql rename to Open-ILS/src/sql/Pg/upgrade/0994.schema.authority-propage-edit-date.sql index 3d53c033b9..5d003429c3 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.authority-propage-edit-date.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0994.schema.authority-propage-edit-date.sql @@ -1,6 +1,8 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0994', :eg_version); + CREATE OR REPLACE FUNCTION authority.propagate_changes (aid BIGINT, bid BIGINT) RETURNS BIGINT AS $func$ DECLARE -- 2.11.0