From 4acbcfc9e799eeb6a342a26cb6eac8932b57bf75 Mon Sep 17 00:00:00 2001 From: Dan Scott Date: Mon, 30 Jul 2012 16:24:45 -0400 Subject: [PATCH] Wrap upgrade script for TPAC advanced search VR formats Signed-off-by: Dan Scott --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ....vr_format_value_maps.sql => 0729.vr_format_value_maps.sql} | 10 ++++++++++ 2 files changed, 11 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.vr_format_value_maps.sql => 0729.vr_format_value_maps.sql} (95%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index ec191cbcbf..420b9150c6 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 ('0728', :eg_version); -- berick/miker +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0729', :eg_version); -- tsbere/denials CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.vr_format_value_maps.sql b/Open-ILS/src/sql/Pg/upgrade/0729.vr_format_value_maps.sql similarity index 95% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.vr_format_value_maps.sql rename to Open-ILS/src/sql/Pg/upgrade/0729.vr_format_value_maps.sql index 21d9d245bf..7d5ceb4726 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.vr_format_value_maps.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0729.vr_format_value_maps.sql @@ -1,3 +1,10 @@ +-- Evergreen DB patch 0729.vr_format_value_maps.sql +-- +BEGIN; + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0729', :eg_version); + CREATE OR REPLACE FUNCTION config.update_coded_value_map(in_ctype TEXT, in_code TEXT, in_value TEXT, in_description TEXT DEFAULT NULL, in_opac_visible BOOL DEFAULT NULL, in_search_label TEXT DEFAULT NULL, in_is_simple BOOL DEFAULT NULL, add_only BOOL DEFAULT FALSE) RETURNS VOID AS $f$ DECLARE current_row config.coded_value_map%ROWTYPE; @@ -47,3 +54,6 @@ SELECT config.update_coded_value_map('vr_format', 'u', 'Unknown', add_only := TR SELECT config.update_coded_value_map('vr_format', 'v', 'DVD', add_only := TRUE); SELECT config.update_coded_value_map('vr_format', 'z', 'Other', add_only := TRUE); SELECT config.update_coded_value_map('vr_format', ' ', 'Unspecified', add_only := TRUE); + + +COMMIT; -- 2.11.0