From 24bf58fa0d8d5871f9985449f00cedea0a3b28a5 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 25 May 2012 14:54:23 -0400 Subject: [PATCH] Stamping upgrade for ACQ org setting group Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ....add_acq_config_group.sql => 0715.data.add_acq_config_group.sql} | 6 ++++++ 2 files changed, 7 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.data.add_acq_config_group.sql => 0715.data.add_acq_config_group.sql} (74%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 9ccef4edd7..fe2a1dab5a 100644 --- a/Open-ILS/src/sql/Pg/002.schema.config.sql +++ b/Open-ILS/src/sql/Pg/002.schema.config.sql @@ -87,7 +87,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 ('0714', :eg_version); -- berick/miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0715', :eg_version); -- dbs/berick CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.add_acq_config_group.sql b/Open-ILS/src/sql/Pg/upgrade/0715.data.add_acq_config_group.sql similarity index 74% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.data.add_acq_config_group.sql rename to Open-ILS/src/sql/Pg/upgrade/0715.data.add_acq_config_group.sql index a094b8af83..00269a26a1 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.add_acq_config_group.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0715.data.add_acq_config_group.sql @@ -1,6 +1,12 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('0715', :eg_version); + INSERT INTO config.settings_group (name, label) VALUES ('acq', oils_i18n_gettext('config.settings_group.system', 'Acquisitions', 'coust', 'label')); UPDATE config.org_unit_setting_type SET grp = 'acq' WHERE name LIKE 'acq%'; + +COMMIT; -- 2.11.0