1 -- Evergreen DB patch XXXX.data.transit-checkin-interval.sql
3 -- New org unit setting "circ.transit.min_checkin_interval"
4 -- New TRANSIT_CHECKIN_INTERVAL_BLOCK.override permission
9 -- check whether patch can be applied
10 SELECT evergreen.upgrade_deps_block_check('0549', :eg_version);
12 INSERT INTO config.org_unit_setting_type ( name, label, description, datatype ) VALUES (
13 'circ.transit.min_checkin_interval',
15 'circ.transit.min_checkin_interval',
16 'Circ: Minimum Transit Checkin Interval',
21 'circ.transit.min_checkin_interval',
22 'In-Transit items checked in this close to the transit start time will be prevented from checking in',
29 INSERT INTO permission.perm_list ( id, code, description ) VALUES (
31 'TRANSIT_CHECKIN_INTERVAL_BLOCK.override',
34 'Allows a user to override the TRANSIT_CHECKIN_INTERVAL_BLOCK event',
40 -- add the perm to the default circ admin group
41 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable)
43 pgt.id, perm.id, aout.depth, TRUE
45 permission.grp_tree pgt,
46 permission.perm_list perm,
47 actor.org_unit_type aout
49 pgt.name = 'Circulation Administrator' AND
50 aout.name = 'System' AND
51 perm.code IN ( 'TRANSIT_CHECKIN_INTERVAL_BLOCK.override' );