3 INSERT INTO config.upgrade_log (version) VALUES ('0026');
5 UPDATE permission.perm_list SET id = id + 1000 WHERE code NOT IN (
14 'REQUEST_HOLDS_OVERRIDE',
19 'VIEW_USER_FINES_SUMMARY',
20 'VIEW_USER_TRANSACTIONS',
29 'RENEW_HOLD_OVERRIDE',
37 'CHECKIN_BYPASS_HOLD_FULFILL',
41 'SET_CIRC_CLAIMS_RETURNED',
51 'CREATE_CONTAINER_ITEM',
52 'CREATE_USER_GROUP_LINK',
53 'REMOVE_USER_GROUP_LINK',
55 'VIEW_PERMIT_CHECKOUT',
57 'CREATE_PATRON_STAT_CAT',
58 'CREATE_COPY_STAT_CAT',
59 'CREATE_PATRON_STAT_CAT_ENTRY',
60 'CREATE_COPY_STAT_CAT_ENTRY',
61 'UPDATE_PATRON_STAT_CAT',
62 'UPDATE_COPY_STAT_CAT',
63 'UPDATE_PATRON_STAT_CAT_ENTRY',
64 'UPDATE_COPY_STAT_CAT_ENTRY',
65 'CREATE_COPY_STAT_CAT_ENTRY_MAP',
66 'CREATE_PATRON_STAT_CAT_ENTRY_MAP',
67 'DELETE_PATRON_STAT_CAT',
68 'DELETE_COPY_STAT_CAT',
69 'DELETE_PATRON_STAT_CAT_ENTRY',
70 'DELETE_COPY_STAT_CAT_ENTRY',
71 'DELETE_PATRON_STAT_CAT_ENTRY_MAP',
72 'DELETE_COPY_STAT_CAT_ENTRY_MAP',
73 'CREATE_NON_CAT_TYPE',
74 'UPDATE_NON_CAT_TYPE',
75 'CREATE_IN_HOUSE_USE',
77 'CREATE_COPY_LOCATION',
78 'UPDATE_COPY_LOCATION',
79 'DELETE_COPY_LOCATION',
80 'CREATE_COPY_TRANSIT',
81 'COPY_TRANSIT_RECEIVE',
83 'VIEW_COPY_CHECKOUT_HISTORY',
85 'REGISTER_WORKSTATION',
96 'CREATE_MY_CONTAINER',
97 'VIEW_HOLD_NOTIFICATION',
98 'CREATE_HOLD_NOTIFICATION',
103 'CIRC_OVERRIDE_DUE_DATE',
104 'CIRC_PERMIT_OVERRIDE',
105 'COPY_IS_REFERENCE.override',
107 'CIRC_CLAIMS_RETURNED.override',
108 'COPY_BAD_STATUS.override',
109 'COPY_ALERT_MESSAGE.override',
110 'COPY_STATUS_LOST.override',
111 'COPY_STATUS_MISSING.override',
113 'ABORT_REMOTE_TRANSIT',
116 'CREATE_DUPLICATE_HOLDS',
117 'actor.org_unit.closed_date.update',
118 'actor.org_unit.closed_date.delete',
119 'actor.org_unit.closed_date.create',
120 'DELETE_NON_CAT_TYPE',
121 'money.collections_tracker.create',
122 'money.collections_tracker.delete',
125 'DELETE_WORKSTATION',
126 'group_application.user',
127 'group_application.user.patron',
128 'group_application.user.staff',
129 'group_application.user.staff.circ',
130 'group_application.user.staff.cat',
131 'group_application.user.staff.admin.global_admin',
132 'group_application.user.staff.admin.local_admin',
133 'group_application.user.staff.admin.lib_manager',
134 'group_application.user.staff.cat.cat1',
135 'group_application.user.staff.supercat',
136 'group_application.user.sip_client',
137 'group_application.user.vendor',
138 'ITEM_AGE_PROTECTED.override',
139 'MAX_RENEWALS_REACHED.override',
140 'PATRON_EXCEEDS_CHECKOUT_COUNT.override',
141 'PATRON_EXCEEDS_OVERDUE_COUNT.override',
142 'PATRON_EXCEEDS_FINES.override',
143 'CIRC_EXCEEDS_COPY_RANGE.override',
144 'ITEM_ON_HOLDS_SHELF.override',
145 'COPY_NOT_AVAILABLE.override',
146 'HOLD_EXISTS.override',
148 'SHARE_REPORT_FOLDER',
149 'VIEW_REPORT_OUTPUT',
150 'COPY_CIRC_NOT_ALLOWED.override',
151 'DELETE_CONTAINER_ITEM',
152 'ASSIGN_WORK_ORG_UNIT',
153 'CREATE_FUNDING_SOURCE',
154 'DELETE_FUNDING_SOURCE',
155 'VIEW_FUNDING_SOURCE',
156 'UPDATE_FUNDING_SOURCE',
161 'CREATE_FUND_ALLOCATION',
162 'DELETE_FUND_ALLOCATION',
163 'VIEW_FUND_ALLOCATION',
164 'UPDATE_FUND_ALLOCATION',
170 'ADMIN_FUNDING_SOURCE',
172 'MANAGE_FUNDING_SOURCE',
179 'ADMIN_CURRENCY_TYPE',
182 'MARK_ITEM_AVAILABLE',
183 'MARK_ITEM_CHECKED_OUT',
187 'MARK_ITEM_IN_PROCESS',
188 'MARK_ITEM_IN_TRANSIT',
189 'MARK_ITEM_RESHELVING',
190 'MARK_ITEM_ON_HOLDS_SHELF',
191 'MARK_ITEM_ON_ORDER',
193 'group_application.user.staff.acq',
194 'CREATE_PURCHASE_ORDER',
195 'VIEW_PURCHASE_ORDER',
196 'IMPORT_ACQ_LINEITEM_BIB_RECORD',
197 'RECEIVE_PURCHASE_ORDER',
199 'CREATE_MFHD_RECORD',
200 'UPDATE_MFHD_RECORD',
201 'DELETE_MFHD_RECORD',
203 'group_application.user.staff.acq_admin',
207 'CREATE_CIRC_DURATION',
209 'CREATE_COPY_STATUS',
210 'CREATE_HOURS_OF_OPERATION',
217 'CREATE_METABIB_FIELD',
218 'CREATE_NET_ACCESS_LEVEL',
219 'CREATE_ORG_ADDRESS',
222 'CREATE_ORG_UNIT_CLOSING',
224 'CREATE_RELEVANCE_ADJUSTMENT',
227 'CREATE_XML_TRANSFORM',
230 'DELETE_CIRC_DURATION',
232 'DELETE_COPY_STATUS',
233 'DELETE_HOURS_OF_OPERATION',
240 'DELETE_METABIB_FIELD',
241 'DELETE_NET_ACCESS_LEVEL',
242 'DELETE_ORG_ADDRESS',
245 'DELETE_ORG_UNIT_CLOSING',
247 'DELETE_RELEVANCE_ADJUSTMENT',
251 'DELETE_XML_TRANSFORM',
256 'UPDATE_CIRC_DURATION',
259 'UPDATE_COPY_STATUS',
261 'UPDATE_HOURS_OF_OPERATION',
268 'UPDATE_METABIB_FIELD',
269 'UPDATE_NET_ACCESS_LEVEL',
270 'UPDATE_ORG_ADDRESS',
272 'UPDATE_ORG_UNIT_CLOSING',
274 'UPDATE_RELEVANCE_ADJUSTMENT',
277 'UPDATE_VOLUME_NOTE',
279 'UPDATE_XML_TRANSFORM',
281 'UPDATE_PICKUP_LIB_FROM_HOLDS_SHELF',
282 'CREATE_ACQ_FUNDING_SOURCE',
283 'CREATE_AUTHORITY_IMPORT_IMPORT_FIELD_DEF',
284 'CREATE_AUTHORITY_IMPORT_QUEUE',
285 'CREATE_AUTHORITY_RECORD_NOTE',
286 'CREATE_BIB_IMPORT_FIELD_DEF',
287 'CREATE_BIB_IMPORT_QUEUE',
290 'CREATE_TRANSLATION',
291 'DELETE_ACQ_FUNDING_SOURCE',
292 'DELETE_AUTHORITY_IMPORT_IMPORT_FIELD_DEF',
293 'DELETE_AUTHORITY_IMPORT_QUEUE',
294 'DELETE_AUTHORITY_RECORD_NOTE',
295 'DELETE_BIB_IMPORT_IMPORT_FIELD_DEF',
296 'DELETE_BIB_IMPORT_QUEUE',
299 'DELETE_TRANSLATION',
300 'UPDATE_ACQ_FUNDING_SOURCE',
301 'UPDATE_AUTHORITY_IMPORT_IMPORT_FIELD_DEF',
302 'UPDATE_AUTHORITY_IMPORT_QUEUE',
303 'UPDATE_AUTHORITY_RECORD_NOTE',
304 'UPDATE_BIB_IMPORT_IMPORT_FIELD_DEF',
305 'UPDATE_BIB_IMPORT_QUEUE',
308 'UPDATE_TRANSLATION',
309 'VIEW_ACQ_FUNDING_SOURCE',
310 'VIEW_AUTHORITY_RECORD_NOTES',
311 'CREATE_IMPORT_ITEM',
312 'CREATE_IMPORT_ITEM_ATTR_DEF',
313 'CREATE_IMPORT_TRASH_FIELD',
314 'DELETE_IMPORT_ITEM',
315 'DELETE_IMPORT_ITEM_ATTR_DEF',
316 'DELETE_IMPORT_TRASH_FIELD',
317 'UPDATE_IMPORT_ITEM',
318 'UPDATE_IMPORT_ITEM_ATTR_DEF',
319 'UPDATE_IMPORT_TRASH_FIELD',
320 'UPDATE_ORG_UNIT_SETTING_ALL',
321 'UPDATE_ORG_UNIT_SETTING.circ.lost_materials_processing_fee',
322 'UPDATE_ORG_UNIT_SETTING.cat.default_item_price',
323 'UPDATE_ORG_UNIT_SETTING.auth.opac_timeout',
324 'UPDATE_ORG_UNIT_SETTING.auth.staff_timeout',
325 'UPDATE_ORG_UNIT_SETTING.org.bounced_emails',
326 'UPDATE_ORG_UNIT_SETTING.circ.hold_expire_alert_interval',
327 'UPDATE_ORG_UNIT_SETTING.circ.hold_expire_interval',
328 'UPDATE_ORG_UNIT_SETTING.global.credit.allow',
329 'UPDATE_ORG_UNIT_SETTING.circ.void_overdue_on_lost',
330 'UPDATE_ORG_UNIT_SETTING.circ.hold_stalling.soft',
331 'UPDATE_ORG_UNIT_SETTING.circ.hold_boundary.hard',
332 'UPDATE_ORG_UNIT_SETTING.circ.hold_boundary.soft',
333 'UPDATE_ORG_UNIT_SETTING.opac.barcode_regex',
334 'UPDATE_ORG_UNIT_SETTING.global.password_regex',
335 'UPDATE_ORG_UNIT_SETTING.circ.item_checkout_history.max',
336 'UPDATE_ORG_UNIT_SETTING.circ.reshelving_complete.interval',
337 'UPDATE_ORG_UNIT_SETTING.circ.selfcheck.patron_login_timeout',
338 'UPDATE_ORG_UNIT_SETTING.circ.selfcheck.alert_on_checkout_event',
339 'UPDATE_ORG_UNIT_SETTING.circ.selfcheck.require_patron_password',
340 'UPDATE_ORG_UNIT_SETTING.global.juvenile_age_threshold',
341 'UPDATE_ORG_UNIT_SETTING.cat.bib.keep_on_empty',
342 'UPDATE_ORG_UNIT_SETTING.cat.bib.alert_on_empty',
343 'UPDATE_ORG_UNIT_SETTING.patron.password.use_phone',
344 'SET_CIRC_CLAIMS_RETURNED.override',
345 'UPDATE_PATRON_CLAIM_RETURN_COUNT'
348 SELECT SETVAL('permission.perm_list_id_seq'::TEXT, GREATEST( (SELECT MAX(id) FROM permission.perm_list), 1000 ));
350 UPDATE permission.grp_perm_map SET perm = perm + 1000 WHERE perm NOT IN ( SELECT id FROM permission.perm_list );
351 UPDATE permission.usr_perm_map SET perm = perm + 1000 WHERE perm NOT IN ( SELECT id FROM permission.perm_list );