From ce7ab122f04920f19ec6c043e8d1aea15b303342 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 | 5 ++++- .../upgrade/XXXX.data.manage-reserves-permission.sql | 19 +++++++++++++++++++ 2 files changed, 23 insertions(+), 1 deletion(-) 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 5856dabfe0..406debdfd5 100644 --- a/Open-ILS/src/sql/Pg/950.data.seed-values.sql +++ b/Open-ILS/src/sql/Pg/950.data.seed-values.sql @@ -1939,7 +1939,9 @@ INSERT INTO permission.perm_list ( id, code, description ) VALUES ( 621, 'VIEW_BOOKING_RESOURCE_TYPE', oils_i18n_gettext(621, 'View booking resource types', 'ppl', 'description')), ( 622, 'VIEW_BOOKING_RESOURCE', oils_i18n_gettext(622, - 'View booking resources', 'ppl', 'description')) + 'View booking resources', 'ppl', 'description')), + ( 623, 'MANAGE_RESERVES', oils_i18n_gettext(623, + 'Allows user to manage Courses, Course Materials, and associate Users with Courses.', 'ppl', 'description')) ; @@ -2453,6 +2455,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