3 UPDATE permission.perm_list SET id = id + 1000 WHERE code NOT IN (
12 'REQUEST_HOLDS_OVERRIDE',
17 'VIEW_USER_FINES_SUMMARY',
18 'VIEW_USER_TRANSACTIONS',
27 'RENEW_HOLD_OVERRIDE',
35 'CHECKIN_BYPASS_HOLD_FULFILL',
39 'SET_CIRC_CLAIMS_RETURNED',
49 'CREATE_CONTAINER_ITEM',
50 'CREATE_USER_GROUP_LINK',
51 'REMOVE_USER_GROUP_LINK',
53 'VIEW_PERMIT_CHECKOUT',
55 'CREATE_PATRON_STAT_CAT',
56 'CREATE_COPY_STAT_CAT',
57 'CREATE_PATRON_STAT_CAT_ENTRY',
58 'CREATE_COPY_STAT_CAT_ENTRY',
59 'UPDATE_PATRON_STAT_CAT',
60 'UPDATE_COPY_STAT_CAT',
61 'UPDATE_PATRON_STAT_CAT_ENTRY',
62 'UPDATE_COPY_STAT_CAT_ENTRY',
63 'CREATE_COPY_STAT_CAT_ENTRY_MAP',
64 'CREATE_PATRON_STAT_CAT_ENTRY_MAP',
65 'DELETE_PATRON_STAT_CAT',
66 'DELETE_COPY_STAT_CAT',
67 'DELETE_PATRON_STAT_CAT_ENTRY',
68 'DELETE_COPY_STAT_CAT_ENTRY',
69 'DELETE_PATRON_STAT_CAT_ENTRY_MAP',
70 'DELETE_COPY_STAT_CAT_ENTRY_MAP',
71 'CREATE_NON_CAT_TYPE',
72 'UPDATE_NON_CAT_TYPE',
73 'CREATE_IN_HOUSE_USE',
75 'CREATE_COPY_LOCATION',
76 'UPDATE_COPY_LOCATION',
77 'DELETE_COPY_LOCATION',
78 'CREATE_COPY_TRANSIT',
79 'COPY_TRANSIT_RECEIVE',
81 'VIEW_COPY_CHECKOUT_HISTORY',
83 'REGISTER_WORKSTATION',
94 'CREATE_MY_CONTAINER',
95 'VIEW_HOLD_NOTIFICATION',
96 'CREATE_HOLD_NOTIFICATION',
101 'CIRC_OVERRIDE_DUE_DATE',
102 'CIRC_PERMIT_OVERRIDE',
103 'COPY_IS_REFERENCE.override',
105 'CIRC_CLAIMS_RETURNED.override',
106 'COPY_BAD_STATUS.override',
107 'COPY_ALERT_MESSAGE.override',
108 'COPY_STATUS_LOST.override',
109 'COPY_STATUS_MISSING.override',
111 'ABORT_REMOTE_TRANSIT',
114 'CREATE_DUPLICATE_HOLDS',
115 'actor.org_unit.closed_date.update',
116 'actor.org_unit.closed_date.delete',
117 'actor.org_unit.closed_date.create',
118 'DELETE_NON_CAT_TYPE',
119 'money.collections_tracker.create',
120 'money.collections_tracker.delete',
123 'DELETE_WORKSTATION',
124 'group_application.user',
125 'group_application.user.patron',
126 'group_application.user.staff',
127 'group_application.user.staff.circ',
128 'group_application.user.staff.cat',
129 'group_application.user.staff.admin.global_admin',
130 'group_application.user.staff.admin.local_admin',
131 'group_application.user.staff.admin.lib_manager',
132 'group_application.user.staff.cat.cat1',
133 'group_application.user.staff.supercat',
134 'group_application.user.sip_client',
135 'group_application.user.vendor',
136 'ITEM_AGE_PROTECTED.override',
137 'MAX_RENEWALS_REACHED.override',
138 'PATRON_EXCEEDS_CHECKOUT_COUNT.override',
139 'PATRON_EXCEEDS_OVERDUE_COUNT.override',
140 'PATRON_EXCEEDS_FINES.override',
141 'CIRC_EXCEEDS_COPY_RANGE.override',
142 'ITEM_ON_HOLDS_SHELF.override',
143 'COPY_NOT_AVAILABLE.override',
144 'HOLD_EXISTS.override',
146 'SHARE_REPORT_FOLDER',
147 'VIEW_REPORT_OUTPUT',
148 'COPY_CIRC_NOT_ALLOWED.override',
149 'DELETE_CONTAINER_ITEM',
150 'ASSIGN_WORK_ORG_UNIT',
151 'CREATE_FUNDING_SOURCE',
152 'DELETE_FUNDING_SOURCE',
153 'VIEW_FUNDING_SOURCE',
154 'UPDATE_FUNDING_SOURCE',
159 'CREATE_FUND_ALLOCATION',
160 'DELETE_FUND_ALLOCATION',
161 'VIEW_FUND_ALLOCATION',
162 'UPDATE_FUND_ALLOCATION',
168 'ADMIN_FUNDING_SOURCE',
170 'MANAGE_FUNDING_SOURCE',
177 'ADMIN_CURRENCY_TYPE',
180 'MARK_ITEM_AVAILABLE',
181 'MARK_ITEM_CHECKED_OUT',
185 'MARK_ITEM_IN_PROCESS',
186 'MARK_ITEM_IN_TRANSIT',
187 'MARK_ITEM_RESHELVING',
188 'MARK_ITEM_ON_HOLDS_SHELF',
189 'MARK_ITEM_ON_ORDER',
191 'group_application.user.staff.acq',
192 'CREATE_PURCHASE_ORDER',
193 'VIEW_PURCHASE_ORDER',
194 'IMPORT_ACQ_LINEITEM_BIB_RECORD',
195 'RECEIVE_PURCHASE_ORDER',
197 'CREATE_MFHD_RECORD',
198 'UPDATE_MFHD_RECORD',
199 'DELETE_MFHD_RECORD',
201 'group_application.user.staff.acq_admin',
205 'CREATE_CIRC_DURATION',
207 'CREATE_COPY_STATUS',
208 'CREATE_HOURS_OF_OPERATION',
215 'CREATE_METABIB_FIELD',
216 'CREATE_NET_ACCESS_LEVEL',
217 'CREATE_ORG_ADDRESS',
220 'CREATE_ORG_UNIT_CLOSING',
222 'CREATE_RELEVANCE_ADJUSTMENT',
225 'CREATE_XML_TRANSFORM',
228 'DELETE_CIRC_DURATION',
230 'DELETE_COPY_STATUS',
231 'DELETE_HOURS_OF_OPERATION',
238 'DELETE_METABIB_FIELD',
239 'DELETE_NET_ACCESS_LEVEL',
240 'DELETE_ORG_ADDRESS',
243 'DELETE_ORG_UNIT_CLOSING',
245 'DELETE_RELEVANCE_ADJUSTMENT',
249 'DELETE_XML_TRANSFORM',
254 'UPDATE_CIRC_DURATION',
257 'UPDATE_COPY_STATUS',
259 'UPDATE_HOURS_OF_OPERATION',
266 'UPDATE_METABIB_FIELD',
267 'UPDATE_NET_ACCESS_LEVEL',
268 'UPDATE_ORG_ADDRESS',
270 'UPDATE_ORG_UNIT_CLOSING',
272 'UPDATE_RELEVANCE_ADJUSTMENT',
275 'UPDATE_VOLUME_NOTE',
277 'UPDATE_XML_TRANSFORM',
279 'UPDATE_PICKUP_LIB_FROM_HOLDS_SHELF',
280 'CREATE_ACQ_FUNDING_SOURCE',
281 'CREATE_AUTHORITY_IMPORT_IMPORT_FIELD_DEF',
282 'CREATE_AUTHORITY_IMPORT_QUEUE',
283 'CREATE_AUTHORITY_RECORD_NOTE',
284 'CREATE_BIB_IMPORT_FIELD_DEF',
285 'CREATE_BIB_IMPORT_QUEUE',
288 'CREATE_TRANSLATION',
289 'DELETE_ACQ_FUNDING_SOURCE',
290 'DELETE_AUTHORITY_IMPORT_IMPORT_FIELD_DEF',
291 'DELETE_AUTHORITY_IMPORT_QUEUE',
292 'DELETE_AUTHORITY_RECORD_NOTE',
293 'DELETE_BIB_IMPORT_IMPORT_FIELD_DEF',
294 'DELETE_BIB_IMPORT_QUEUE',
297 'DELETE_TRANSLATION',
298 'UPDATE_ACQ_FUNDING_SOURCE',
299 'UPDATE_AUTHORITY_IMPORT_IMPORT_FIELD_DEF',
300 'UPDATE_AUTHORITY_IMPORT_QUEUE',
301 'UPDATE_AUTHORITY_RECORD_NOTE',
302 'UPDATE_BIB_IMPORT_IMPORT_FIELD_DEF',
303 'UPDATE_BIB_IMPORT_QUEUE',
306 'UPDATE_TRANSLATION',
307 'VIEW_ACQ_FUNDING_SOURCE',
308 'VIEW_AUTHORITY_RECORD_NOTES',
309 'CREATE_IMPORT_ITEM',
310 'CREATE_IMPORT_ITEM_ATTR_DEF',
311 'CREATE_IMPORT_TRASH_FIELD',
312 'DELETE_IMPORT_ITEM',
313 'DELETE_IMPORT_ITEM_ATTR_DEF',
314 'DELETE_IMPORT_TRASH_FIELD',
315 'UPDATE_IMPORT_ITEM',
316 'UPDATE_IMPORT_ITEM_ATTR_DEF',
317 'UPDATE_IMPORT_TRASH_FIELD',
318 'UPDATE_ORG_UNIT_SETTING_ALL',
319 'UPDATE_ORG_UNIT_SETTING.circ.lost_materials_processing_fee',
320 'UPDATE_ORG_UNIT_SETTING.cat.default_item_price',
321 'UPDATE_ORG_UNIT_SETTING.auth.opac_timeout',
322 'UPDATE_ORG_UNIT_SETTING.auth.staff_timeout',
323 'UPDATE_ORG_UNIT_SETTING.org.bounced_emails',
324 'UPDATE_ORG_UNIT_SETTING.circ.hold_expire_alert_interval',
325 'UPDATE_ORG_UNIT_SETTING.circ.hold_expire_interval',
326 'UPDATE_ORG_UNIT_SETTING.global.credit.allow',
327 'UPDATE_ORG_UNIT_SETTING.circ.void_overdue_on_lost',
328 'UPDATE_ORG_UNIT_SETTING.circ.hold_stalling.soft',
329 'UPDATE_ORG_UNIT_SETTING.circ.hold_boundary.hard',
330 'UPDATE_ORG_UNIT_SETTING.circ.hold_boundary.soft',
331 'UPDATE_ORG_UNIT_SETTING.opac.barcode_regex',
332 'UPDATE_ORG_UNIT_SETTING.global.password_regex',
333 'UPDATE_ORG_UNIT_SETTING.circ.item_checkout_history.max',
334 'UPDATE_ORG_UNIT_SETTING.circ.reshelving_complete.interval',
335 'UPDATE_ORG_UNIT_SETTING.circ.selfcheck.patron_login_timeout',
336 'UPDATE_ORG_UNIT_SETTING.circ.selfcheck.alert_on_checkout_event',
337 'UPDATE_ORG_UNIT_SETTING.circ.selfcheck.require_patron_password',
338 'UPDATE_ORG_UNIT_SETTING.global.juvenile_age_threshold',
339 'UPDATE_ORG_UNIT_SETTING.cat.bib.keep_on_empty',
340 'UPDATE_ORG_UNIT_SETTING.cat.bib.alert_on_empty',
341 'UPDATE_ORG_UNIT_SETTING.patron.password.use_phone',
342 'SET_CIRC_CLAIMS_RETURNED.override',
343 'UPDATE_PATRON_CLAIM_RETURN_COUNT'
346 SELECT SETVAL('permission.perm_list_id_seq'::TEXT, GREATEST( (SELECT MAX(id) FROM permission.perm_list), 1000 ));
348 UPDATE permission.grp_perm_map SET perm = perm + 1000 WHERE perm NOT IN ( SELECT id FROM permission.perm_list );
349 UPDATE permission.usr_perm_map SET perm = perm + 1000 WHERE perm NOT IN ( SELECT id FROM permission.perm_list );