LP#1850547: (follow-up) add a bit of spacing between two buttons
[Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / YYYY.data.acq_permissions.sql
1 BEGIN;
2
3 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable)
4         SELECT
5                 pgt.id, perm.id, aout.depth, TRUE
6         FROM
7                 permission.grp_tree pgt,
8                 permission.perm_list perm,
9                 actor.org_unit_type aout
10         WHERE
11                 pgt.name = 'Acquisitions Administrator' AND
12                 aout.name = 'Consortium' AND
13                 perm.code IN (
14                     'VIEW_FUND',
15                     'VIEW_FUNDING_SOURCE',
16                     'VIEW_FUND_ALLOCATION',
17                     'VIEW_PICKLIST',
18                     'VIEW_PROVIDER',
19                     'VIEW_PURCHASE_ORDER',
20                     'VIEW_INVOICE',
21                     'CREATE_PICKLIST',
22                     'ACQ_ADD_LINEITEM_IDENTIFIER',
23                     'ACQ_SET_LINEITEM_IDENTIFIER',
24                     'MANAGE_FUND',
25                     'CREATE_INVOICE',
26                     'CREATE_PURCHASE_ORDER',
27                     'IMPORT_ACQ_LINEITEM_BIB_RECORD',
28                     'IMPORT_ACQ_LINEITEM_BIB_RECORD_UPLOAD',
29                     'MANAGE_CLAIM',
30                     'MANAGE_PROVIDER',
31                     'MANAGE_FUNDING_SOURCE',
32                     'RECEIVE_PURCHASE_ORDER',
33                     'ADMIN_ACQ_LINEITEM_ALERT_TEXT',
34                     'UPDATE_FUNDING_SOURCE',
35                     'UPDATE_PROVIDER',
36                     'VIEW_IMPORT_MATCH_SET',
37                     'VIEW_MERGE_PROFILE',
38                     'IMPORT_MARC'
39                 );
40
41
42 INSERT INTO permission.grp_perm_map (grp, perm, depth, grantable)
43         SELECT
44                 pgt.id, perm.id, aout.depth, FALSE
45         FROM
46                 permission.grp_tree pgt,
47                 permission.perm_list perm,
48                 actor.org_unit_type aout
49         WHERE
50                 pgt.name = 'Acquisitions' AND
51                 aout.name = 'Consortium' AND
52                 perm.code IN (
53                     'ACQ_ADD_LINEITEM_IDENTIFIER',
54                     'ACQ_SET_LINEITEM_IDENTIFIER',
55                     'ADMIN_ACQ_FUND',
56                     'ADMIN_FUND',
57                     'ACQ_INVOICE-REOPEN',
58                     'ADMIN_ACQ_DISTRIB_FORMULA',
59                     'ADMIN_INVOICE',
60                     'IMPORT_ACQ_LINEITEM_BIB_RECORD_UPLOAD',
61                     'VIEW_IMPORT_MATCH_SET',
62                     'VIEW_MERGE_PROFILE'
63                 );
64
65 COMMIT;