From 5503e0ff2838bb9d392b95bd1f9341127e20e960 Mon Sep 17 00:00:00 2001 From: Bill Erickson Date: Fri, 3 Jun 2011 13:24:16 -0400 Subject: [PATCH] unwrapped upgrade script for cat.volume.delete_on_empty Signed-off-by: Bill Erickson Signed-off-by: Jason Etheridge --- .../sql/Pg/upgrade/XXXX.data.delete_empty_volume.sql | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.delete_empty_volume.sql diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.delete_empty_volume.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.delete_empty_volume.sql new file mode 100644 index 0000000000..d4a529fd00 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.delete_empty_volume.sql @@ -0,0 +1,18 @@ +-- Evergreen DB patch XXXX.data.delete_empty_volume.sql +-- +-- New org setting cat.volume.delete_on_empty +-- +BEGIN; + +-- check whether patch can be applied +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +INSERT INTO config.org_unit_setting_type ( name, label, description, datatype ) + VALUES ( + 'cat.volume.delete_on_empty', + oils_i18n_gettext('cat.volume.delete_on_empty', 'Cat: Delete volume with last copy', 'coust', 'label'), + oils_i18n_gettext('cat.volume.delete_on_empty', 'Automatically delete a volume when the last linked copy is deleted', 'coust', 'description'), + 'bool' + ); + +COMMIT; -- 2.11.0