From 69cb26efbb373c3efb01814d3e850914b3e00669 Mon Sep 17 00:00:00 2001 From: Jason Boyer Date: Thu, 3 Sep 2020 18:33:40 -0400 Subject: [PATCH] LP#1841974: Stamp Upgrade Scripts Signed-off-by: Jason Boyer --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...rotect-YAOUS.sql => 1220.data.calc-prox-for-age_protect-YAOUS.sql} | 2 +- ...nd-hold-permit.sql => 1221.function.calc-prox-and-hold-permit.sql} | 4 ++-- 3 files changed, 4 insertions(+), 4 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.calc-prox-for-age_protect-YAOUS.sql => 1220.data.calc-prox-for-age_protect-YAOUS.sql} (90%) rename Open-ILS/src/sql/Pg/upgrade/{YYYY.function.calc-prox-and-hold-permit.sql => 1221.function.calc-prox-and-hold-permit.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 82227504dd..7dd7921936 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -92,7 +92,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 ('1219', :eg_version); -- gmcharlt/berick +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1221', :eg_version); -- miker/JBoyer CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.calc-prox-for-age_protect-YAOUS.sql b/Open-ILS/src/sql/Pg/upgrade/1220.data.calc-prox-for-age_protect-YAOUS.sql similarity index 90% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.calc-prox-for-age_protect-YAOUS.sql rename to Open-ILS/src/sql/Pg/upgrade/1220.data.calc-prox-for-age_protect-YAOUS.sql index 84fb089d60..f3e0aa8c18 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.calc-prox-for-age_protect-YAOUS.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1220.data.calc-prox-for-age_protect-YAOUS.sql @@ -1,6 +1,6 @@ BEGIN; -SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1220', :eg_version); INSERT into config.org_unit_setting_type ( name, grp, label, description, datatype, fm_class ) VALUES diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.function.calc-prox-and-hold-permit.sql b/Open-ILS/src/sql/Pg/upgrade/1221.function.calc-prox-and-hold-permit.sql similarity index 99% rename from Open-ILS/src/sql/Pg/upgrade/YYYY.function.calc-prox-and-hold-permit.sql rename to Open-ILS/src/sql/Pg/upgrade/1221.function.calc-prox-and-hold-permit.sql index bfbbacc388..31f7d8e098 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.function.calc-prox-and-hold-permit.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1221.function.calc-prox-and-hold-permit.sql @@ -1,6 +1,6 @@ BEGIN; -SELECT evergreen.upgrade_deps_block_check('YYYY', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1221', :eg_version); CREATE OR REPLACE FUNCTION action.copy_calculated_proximity( pickup INT, @@ -70,7 +70,7 @@ BEGIN RETURN baseline_prox; END; -$F$ LANGUAGE PLPGSQL; +$f$ LANGUAGE PLPGSQL; CREATE OR REPLACE FUNCTION action.hold_copy_calculated_proximity( ahr_id INT, -- 2.11.0