From 63cdb5ec73cb4d7c31852f5c3665ac6d17b6a711 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Mon, 25 Jul 2011 17:24:13 -0400 Subject: [PATCH] Stamped upgrade script for checkout_fills_related_hold_exact_match Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/002.schema.config.sql | 2 +- ..._match.sql => 0585.checkout_fills_related_hold_exact_match.sql} | 7 +++++++ 2 files changed, 8 insertions(+), 1 deletion(-) rename Open-ILS/src/sql/Pg/upgrade/{XXXX.checkout_fills_related_hold_exact_match.sql => 0585.checkout_fills_related_hold_exact_match.sql} (79%) diff --git a/Open-ILS/src/sql/Pg/002.schema.config.sql b/Open-ILS/src/sql/Pg/002.schema.config.sql index cb783e2134..7984118747 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 ('0584', :eg_version); -- phasefx/berick +INSERT INTO config.upgrade_log (version, applied_to) VALUES ('0585', :eg_version); -- tsbere/berick CREATE TABLE config.bib_source ( id SERIAL PRIMARY KEY, diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.checkout_fills_related_hold_exact_match.sql b/Open-ILS/src/sql/Pg/upgrade/0585.checkout_fills_related_hold_exact_match.sql similarity index 79% rename from Open-ILS/src/sql/Pg/upgrade/XXXX.checkout_fills_related_hold_exact_match.sql rename to Open-ILS/src/sql/Pg/upgrade/0585.checkout_fills_related_hold_exact_match.sql index c720e36486..611a2b058d 100644 --- a/Open-ILS/src/sql/Pg/upgrade/XXXX.checkout_fills_related_hold_exact_match.sql +++ b/Open-ILS/src/sql/Pg/upgrade/0585.checkout_fills_related_hold_exact_match.sql @@ -1,6 +1,13 @@ +BEGIN; + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('0585', :eg_version); + INSERT into config.org_unit_setting_type ( name, label, description, datatype ) VALUES ( 'circ.checkout_fills_related_hold_exact_match_only', 'Checkout Fills Related Hold On Valid Copy Only', 'When filling related holds on checkout only match on items that are valid for opportunistic capture for the hold. Without this set a Title or Volume hold could match when the item is not holdable. With this set only holdable items will match.', 'bool'); + +COMMIT; -- 2.11.0