From 1a2139cb44a691cdfb50969612ae6110ab39cd0a Mon Sep 17 00:00:00 2001 From: Kyle Huckins Date: Fri, 18 Oct 2019 18:05:57 +0000 Subject: [PATCH] Course Reserves Permission - Create MANAGE_RESERVES permission. Signed-off-by: Kyle Huckins Changes to be committed: modified: Open-ILS/src/sql/Pg/950.data.seed-values.sql new file: Open-ILS/src/sql/Pg/upgrade/XXXX.data.manage-reserves-permission.sql --- Open-ILS/src/sql/Pg/950.data.seed-values.sql | 3 +++ .../upgrade/XXXX.data.manage-reserves-permission.sql | 19 +++++++++++++++++++ 2 files changed, 22 insertions(+) create mode 100644 Open-ILS/src/sql/Pg/upgrade/XXXX.data.manage-reserves-permission.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 04ca260c36..6776e2fa02 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -1934,6 +1934,8 @@ INSERT INTO permission.perm_list ( id, code, description ) VALUES 'Allows a user to create a pre-catalogued copy', 'ppl', 'description')), ( 619, 'EDIT_SELF_IN_CLIENT', oils_i18n_gettext(619, 'Allow a user to edit their own account in the staff client', 'ppl', 'description')) + ( 620, 'MANAGE_RESERVES', oils_i18n_gettext(620, + 'Allows user to manage Courses, Course Materials, and associate Users with Courses.', 'ppl', 'description')) ; @@ -2445,6 +2447,7 @@ INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable) 'CREATE_CIRC_DURATION', 'CREATE_PRECAT', 'DELETE_CIRC_DURATION', + 'MANAGE_RESERVES', 'MARK_ITEM_MISSING_PIECES', 'UPDATE_CIRC_DURATION', 'UPDATE_HOLD_REQUEST_TIME', diff --git a/Open-ILS/src/sql/Pg/upgrade/XXXX.data.manage-reserves-permission.sql b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.manage-reserves-permission.sql new file mode 100644 index 0000000000..d7699af9be --- /dev/null +++ b/Open-ILS/src/sql/Pg/upgrade/XXXX.data.manage-reserves-permission.sql @@ -0,0 +1,19 @@ +BEGIN; + +SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version); + +INSERT INTO permission.perm_list(id, code, description) + VALUES ( + 620, + 'MANAGE_RESERVES', + oils_i18n_gettext( + 620, + 'Allows user to manage Courses, Course Materials, and associate Users with Courses.', + 'ppl', + 'description' + ) + ); + +INSERT INTO permission.grp_perm_map(perm, grp, depth) VALUES (620, 9, 0), (620, 11, 0), (20, 12, 0), (620, 13, 0); + +COMMIT; \ No newline at end of file -- 2.11.0