From adda813e888222a4f4ec5575901594970df5f6c7 Mon Sep 17 00:00:00 2001 From: Josh Stompro Date: Thu, 12 Nov 2015 21:53:36 -0600 Subject: [PATCH] LP1498155 - Remove SET_CIRC_MISSING permission. SET_CIRC_MISSING isn't used anywhere, remove it to avoid confusing it with MARK_ITEM_MISSING permission. Signed-off-by: Josh Stompro Signed-off-by: Chris Sharp Signed-off-by: Galen Charlton --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 4 ---- Open-ILS/src/sql/Pg/upgrade/XXXX.remove_SET_CIRC_MISSING.sql | 10 ++++++++++ 2 files changed, 10 insertions(+), 4 deletions(-) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.remove_SET_CIRC_MISSING.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 a6570399d2..e3c34b4415 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -573,8 +573,6 @@ INSERT INTO permission.perm_list ( id, code, description ) VALUES 'Allow a user to record payments in the Billing Interface', 'ppl', 'description' )), ( 34, 'SET_CIRC_LOST', oils_i18n_gettext( 34, 'Allow a user to mark an item as ''lost''', 'ppl', 'description' )), - ( 35, 'SET_CIRC_MISSING', oils_i18n_gettext( 35, - 'Allow a user to mark an item as ''missing''', 'ppl', 'description' )), ( 36, 'SET_CIRC_CLAIMS_RETURNED', oils_i18n_gettext( 36, 'Allow a user to mark an item as ''claims returned''', 'ppl', 'description' )), ( 37, 'CREATE_TRANSACTION', oils_i18n_gettext( 37, @@ -2096,7 +2094,6 @@ INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) 'SET_CIRC_CLAIMS_RETURNED', 'SET_CIRC_CLAIMS_RETURNED.override', 'SET_CIRC_LOST', - 'SET_CIRC_MISSING', 'UPDATE_BILL_NOTE', 'UPDATE_PATRON_CLAIM_NEVER_CHECKED_OUT_COUNT', 'UPDATE_PATRON_CLAIM_RETURN_COUNT', @@ -2254,7 +2251,6 @@ INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) 'SET_CIRC_CLAIMS_RETURNED', 'SET_CIRC_CLAIMS_RETURNED.override', 'SET_CIRC_LOST', - 'SET_CIRC_MISSING', 'UNBAR_PATRON', 'UPDATE_BILL_NOTE', 'UPDATE_NON_CAT_TYPE', diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.remove_SET_CIRC_MISSING.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.remove_SET_CIRC_MISSING.sql new file mode 100644 index 0000000000..a7f2911f12 --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.remove_SET_CIRC_MISSING.sql @@ -0,0 +1,10 @@ +BEGIN; + +--delete all instances from permission.grp_perm_map first +DELETE FROM permission.grp_perm_map where perm in +(select id from permission.perm_list where code='SET_CIRC_MISSING'); + +--delete from permission.perm_list +DELETE FROM permission.perm_list where code='SET_CIRC_MISSING'; + +COMMIT; -- 2.11.0