From 2d28a7aa88394c8167e30e683f7e3b01b7a5c939 Mon Sep 17 00:00:00 2001 From: Jason Etheridge Date: Tue, 4 Oct 2011 13:20:41 -0400 Subject: [PATCH] pin version for upgrade script Signed-off-by: Jason Etheridge --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- .../{XXXX.new_print_method.sql => 0633.new_print_method.sql} | 7 +++++++ 2 files changed, 8 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.new_print_method.sql => 0633.new_print_method.sql} (85%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 9004611935..368668a956 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 ('0632', :eg_version); -- tsbere/berick +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0633', :eg_version); -- tsbere/phasefx CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.new_print_method.sql b/Open-ILS/src/sql/Pg/upgrade/0633.new_print_method.sql similarity index 85% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.new_print_method.sql rename to Open-ILS/src/sql/Pg/upgrade/0633.new_print_method.sql index bb7d8daf57..9298aaf120 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.new_print_method.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0633.new_print_method.sql @@ -1,3 +1,8 @@ +BEGIN; + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0633', :eg_version); + INSERT into config.org_unit_setting_type ( name, grp, label, description, datatype ) VALUES ( @@ -18,3 +23,5 @@ INSERT into config.org_unit_setting_type ), 'string' ); + +COMMIT; -- 2.11.0