From 6c537fc3a063cbb2d1c13907b3d94b6fcde09e73 Mon Sep 17 00:00:00 2001 From: Kathy Lussier Date: Fri, 17 Feb 2017 10:29:33 -0500 Subject: [PATCH 1/1] LP#1117808: Stamping upgrade scripts for extend use of merge profiles Signed-off-by: Kathy Lussier --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...ore_overlay_funcs.sql => 1022.schema.more_overlay_funcs.sql} | 2 +- ...vmp_ou_setting.sql => 1023.data.default_vmp_ou_settings.sql} | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.schema.more_overlay_funcs.sql => 1022.schema.more_overlay_funcs.sql} (97%) rename Open-ILS/src/sql/Pg/upgrade/{YYYY.data.default_vmp_ou_setting.sql => 1023.data.default_vmp_ou_settings.sql} (88%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 78bc5b915b..f9c5ccc06a 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 ('1021', :eg_version); -- Jboyer/kmlussier +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('1023', :eg_version); -- gmcharlt/kmlussier CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.more_overlay_funcs.sql b/Open-ILS/src/sql/Pg/upgrade/1022.schema.more_overlay_funcs.sql similarity index 97% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.schema.more_overlay_funcs.sql rename to Open-ILS/src/sql/Pg/upgrade/1022.schema.more_overlay_funcs.sql index e3bfa2e04a..848e8a088e 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.schema.more_overlay_funcs.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1022.schema.more_overlay_funcs.sql @@ -1,6 +1,6 @@ BEGIN; --- SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1022', :eg_version); CREATE OR REPLACE FUNCTION vandelay.merge_record_xml_using_profile ( incoming_marc TEXT, existing_marc TEXT, merge_profile_id BIGINT ) RETURNS TEXT AS $$ DECLARE diff --git a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.default_vmp_ou_setting.sql b/Open-ILS/src/sql/Pg/upgrade/1023.data.default_vmp_ou_settings.sql similarity index 88% rename from Open-ILS/src/sql/Pg/upgrade/YYYY.data.default_vmp_ou_setting.sql rename to Open-ILS/src/sql/Pg/upgrade/1023.data.default_vmp_ou_settings.sql index ebc8b16881..4ea169e213 100644 --- a/Open-ILS/src/sql/Pg/upgrade/YYYY.data.default_vmp_ou_setting.sql +++ b/Open-ILS/src/sql/Pg/upgrade/1023.data.default_vmp_ou_settings.sql @@ -1,6 +1,6 @@ BEGIN; --- SELECT evergreen.upgrade_deps_block_check('YYYY', :eg_version); +SELECT evergreen.upgrade_deps_block_check('1023', :eg_version); INSERT into config.org_unit_setting_type ( name, grp, label, description, datatype, fm_class ) VALUES -- 2.43.2