From d0604dbdddfe41faa8444aac66900edf34f4af32 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Mon, 22 Jul 2013 10:55:14 -0400 Subject: [PATCH] Wrap upgrade script for TPAC library name links Signed-off-by: Dan Scott --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ...fo_url_OUS.sql => 0812.data.add_library_info_url_OUS.sql} | 12 ++++++++++++ 2 files changed, 13 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.add_library_info_url_OUS.sql => 0812.data.add_library_info_url_OUS.sql} (65%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index 68648b1e6e..5d938ab57e 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 ('0811', :eg_version); -- fparks/miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0812', :eg_version); -- dbs/kmlussier CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.add_library_info_url_OUS.sql b/Open-ILS/src/sql/Pg/upgrade/0812.data.add_library_info_url_OUS.sql similarity index 65% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.add_library_info_url_OUS.sql rename to Open-ILS/src/sql/Pg/upgrade/0812.data.add_library_info_url_OUS.sql index 623539bf38..e33f38fb07 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.add_library_info_url_OUS.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0812.data.add_library_info_url_OUS.sql @@ -1,3 +1,13 @@ +-- Evergreen DB patch 0812.data.add_library_info_url_OUS.sql +-- +-- Adds YAOUS for enabling information links from the TPAC to a library URL +-- +BEGIN; + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0812', :eg_version); + +-- FIXME: add/check SQL statements to perform the upgrade INSERT into config.org_unit_setting_type ( name, grp, label, description, datatype, fm_class ) VALUES ( 'lib.info_url', 'lib', @@ -9,3 +19,5 @@ INSERT into config.org_unit_setting_type 'coust', 'description'), 'string', null) ; + +COMMIT; -- 2.11.0