From 7a0ecf9ae87077e0f4dd0719e0a751428707101a Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Tue, 18 Aug 2015 22:30:13 -0400 Subject: [PATCH] LP#1204671: Stamping upgrade script for fund tag propagation Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../{XXXX.fund_tags_persist.sql => 0926.fund_tags_persist.sql} | 2 ++ 2 files changed, 3 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.fund_tags_persist.sql => 0926.fund_tags_persist.sql} (99%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 93f283f98c..6110f7d482 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 ('0925', :eg_version); -- dyrcona/bshum +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0926', :eg_version); -- dpearl/kmlussier/bshum CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.fund_tags_persist.sql b/Open-ILS/src/sql/Pg/upgrade/0926.fund_tags_persist.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.fund_tags_persist.sql rename to Open-ILS/src/sql/Pg/upgrade/0926.fund_tags_persist.sql index 68e141ad45..cb11e9b5ad 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.fund_tags_persist.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0926.fund_tags_persist.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('0926', :eg_version); + CREATE OR REPLACE FUNCTION acq.copy_fund_tags( old_fund_id INTEGER, new_fund_id INTEGER -- 2.43.2