From ab37833ff9df7fa13e86e41fb160232bdee51793 Mon Sep 17 00:00:00 2001 From: Ben Shum Date: Mon, 8 Jul 2013 10:33:12 -0400 Subject: [PATCH] Stamping upgrade script for user barcode regex setting Signed-off-by: Ben Shum --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...check_barcode_regex.sql => 0801.check_barcode_regex.sql} | 6 ++++++ 2 files changed, 7 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.check_barcode_regex.sql => 0801.check_barcode_regex.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 00daaee279..adf0b231a5 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 ('0800', :eg_version); -- miker/dbs +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0801', :eg_version); -- tsbere/paxed/bshum CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.check_barcode_regex.sql b/Open-ILS/src/sql/Pg/upgrade/0801.check_barcode_regex.sql similarity index 85% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.check_barcode_regex.sql rename to Open-ILS/src/sql/Pg/upgrade/0801.check_barcode_regex.sql index 0d2bcef43c..b6b9dd7922 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.check_barcode_regex.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0801.check_barcode_regex.sql @@ -1,3 +1,7 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('0801', :eg_version); + INSERT into config.org_unit_setting_type ( name, grp, label, description, datatype, fm_class ) VALUES ( 'ui.patron.edit.ac.barcode.regex', 'gui', @@ -8,3 +12,5 @@ INSERT into config.org_unit_setting_type 'The Regular Expression for validation on barcodes in patron registration.', 'coust', 'description'), 'string', null); + +COMMIT; -- 2.43.2