From 6b92127c9001a8d30ee15a651ea76ea280214f92 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Wed, 22 Aug 2012 11:48:52 -0400 Subject: [PATCH] Clear-shelf includes pickup-lib changes : sql Signed-off-by: Bill Erickson --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 20 +++++++++++++++++ .../upgrade/XXXX.data.clear_shelf_pl_changed.sql | 25 ++++++++++++++++++++++ 2 files changed, 45 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.clear_shelf_pl_changed.sql diff --git a/Open-ILS/src/sql/Pg/950.data.seed-values.sql b/Open-ILS/src/sql/Pg/950.data.seed-values.sql index 41eb5fecce..4d2bf3929f 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -11836,3 +11836,23 @@ INSERT into config.org_unit_setting_type 'bool' ); +INSERT into config.org_unit_setting_type + (name, grp, label, description, datatype) + VALUES ( + 'circ.holds.clear_shelf.include_pl_changed', + 'holds', + oils_i18n_gettext( + 'circ.holds.clear_shelf.include_pl_changed', + 'Clear shelf process includes Wrong-Shelf holds', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'circ.holds.clear_shelf.include_pl_changed', + 'If enabled, we include Wrong-Shelf holds in the results list of the holds clear shelf process. Wrong-Shelf holds are those whose pickup lib was changed while the hold was on the holds shelf', + 'coust', + 'description' + ), + 'bool' + ); + diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.clear_shelf_pl_changed.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.clear_shelf_pl_changed.sql new file mode 100644 index 0000000000..19216c8e67 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.clear_shelf_pl_changed.sql @@ -0,0 +1,25 @@ +BEGIN; + +-- SELECT evergreen.upgrade_deps_block_check('0730', :eg_version); + +INSERT into config.org_unit_setting_type + (name, grp, label, description, datatype) + VALUES ( + 'circ.holds.clear_shelf.include_pl_changed', + 'holds', + oils_i18n_gettext( + 'circ.holds.clear_shelf.include_pl_changed', + 'Clear shelf process includes Wrong-Shelf holds', + 'coust', + 'label' + ), + oils_i18n_gettext( + 'circ.holds.clear_shelf.include_pl_changed', + 'If enabled, we include Wrong-Shelf holds in the results list of the holds clear shelf process. Wrong-Shelf holds are those whose pickup lib was changed while the hold was on the holds shelf', + 'coust', + 'description' + ), + 'bool' + ); + +COMMIT; -- 2.11.0