1 -- Evergreen DB patch XXXX.data.collections_exempt_perm.sql
3 -- Adds a new UPDATE_PATRON_COLLECTIONS_EXEMPT permission
8 -- check whether patch can be applied
9 SELECT evergreen.upgrade_deps_block_check('XXXX', :eg_version);
11 INSERT INTO permission.perm_list ( id, code, description )
12 VALUES ( 510, 'UPDATE_PATRON_COLLECTIONS_EXEMPT', oils_i18n_gettext(510,
13 'Allows a user to indicate that a patron is exempt from collections processing', 'ppl', 'description'));
15 --- stock Circulation Administrator group
17 INSERT INTO permission.grp_perm_map ( grp, perm, depth, grantable )
23 FROM permission.perm_list
24 WHERE code in ('UPDATE_PATRON_COLLECTIONS_EXEMPT');