From eee584eaee6595cf82275bdb734b7d17c9820eef Mon Sep 17 00:00:00 2001 From: Kathy Lussier Date: Fri, 17 Feb 2017 01:12:08 -0500 Subject: [PATCH] LP#1596595: Stamping upgrade scripts for hold targeter refactoring Signed-off-by: Kathy Lussier --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...X.schema.hold_targeter.sql => 1019.schema.hold_targeter.sql} | 2 ++ ...ettings_by_org.sql => 1020.schema.batch_settings_by_org.sql} | 2 ++ 3 files changed, 5 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.hold_targeter.sql => 1019.schema.hold_targeter.sql} (89%) rename Open-ILS/src/sql/Pg/upgrade/{YYYY.schema.batch_settings_by_org.sql => 1020.schema.batch_settings_by_org.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 e7323d586c..954324b9f5 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 ('1018', :eg_version); -- csharp/Dyrcona/gmcharlt +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1020', :eg_version); -- berick/csharp/kmlussier CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.hold_targeter.sql b/Open-ILS/src/sql/Pg/upgrade/1019.schema.hold_targeter.sql similarity index 89% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.hold_targeter.sql rename to Open-ILS/src/sql/Pg/upgrade/1019.schema.hold_targeter.sql index ba584f0f57..61f3462ffe 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.hold_targeter.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1019.schema.hold_targeter.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('1019', :eg_version); + CREATE OR REPLACE FUNCTION action.hold_request_regen_copy_maps( hold_id INTEGER, copy_ids INTEGER[]) RETURNS VOID AS $$ diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.batch_settings_by_org.sql b/Open-ILS/src/sql/Pg/upgrade/1020.schema.batch_settings_by_org.sql similarity index 91% rename from Open-ILS/src/sql/Pg/upgrade/YYYY.schema.batch_settings_by_org.sql rename to Open-ILS/src/sql/Pg/upgrade/1020.schema.batch_settings_by_org.sql index 567183f307..cc566aedd1 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.schema.batch_settings_by_org.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1020.schema.batch_settings_by_org.sql @@ -1,5 +1,7 @@ BEGIN; +SELECT evergreen.upgrade_deps_block_check('1020', :eg_version); + CREATE OR REPLACE FUNCTION actor.org_unit_ancestor_setting_batch_by_org( setting_name TEXT, org_ids INTEGER[]) RETURNS SETOF actor.org_unit_setting AS -- 2.43.2