LP#1841974: Stamp Upgrade Scripts

Signed-off-by: Jason Boyer <JBoyer@equinoxinitiative.org>

diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql
index 8222750..7dd7921 100644 (file)
--- 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 84fb089..f3e0aa8 100644 (file)
--- 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 bfbbacc..31f7d8e 100644 (file)
--- 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,