From 6a1aa49194919a29ea77f09a2387aadd7d7790ff Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Fri, 26 Aug 2011 16:02:05 -0400 Subject: [PATCH] pin upgrade version number for magic macros Signed-off-by: Jason Etheridge --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../upgrade/{XXXX.magic_macros.sql => 0611.data.magic_macros.sql} | 8 ++++++++ 2 files changed, 9 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.magic_macros.sql => 0611.data.magic_macros.sql} (93%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 941ea933c3..9a80f6f075 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -86,7 +86,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 ('0610', :eg_version); -- miker/berick +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0611', :eg_version); -- miker/berick CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.magic_macros.sql b/Open-ILS/src/sql/Pg/upgrade/0611.data.magic_macros.sql similarity index 93% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.magic_macros.sql rename to Open-ILS/src/sql/Pg/upgrade/0611.data.magic_macros.sql index 6bfce60fa3..402ee108fd 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.magic_macros.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0611.data.magic_macros.sql @@ -1,3 +1,9 @@ +-- Evergreen DB patch 0611.data.magic_macros.sql +BEGIN; + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0611', :eg_version); + INSERT into config.org_unit_setting_type ( name, label, description, datatype ) VALUES ( @@ -80,3 +86,5 @@ INSERT into config.org_unit_setting_type ), 'string' ); + +COMMIT; -- 2.11.0