]> git.evergreen-ils.org Git - working/Evergreen.git/blob - Open-ILS/src/sql/Pg/upgrade/0735.data.search_filter_group_perms.sql
LP#1758426: Disable triggers before recalculating bib visibility in 1085
[working/Evergreen.git] / Open-ILS / src / sql / Pg / upgrade / 0735.data.search_filter_group_perms.sql
1 -- Evergreen DB patch 0735.data.search_filter_group_perms.sql
2 --
3 BEGIN;
4
5 -- check whether patch can be applied
6 SELECT evergreen.upgrade_deps_block_check('0735', :eg_version);
7
8 INSERT INTO permission.perm_list ( id, code, description ) 
9     VALUES ( 
10         537, 
11         'ADMIN_SEARCH_FILTER_GROUP',
12         oils_i18n_gettext( 
13             537,
14             'Allows staff to manage search filter groups and entries',
15             'ppl', 
16             'description' 
17         )
18     ),
19     (
20         538, 
21         'VIEW_SEARCH_FILTER_GROUP',
22         oils_i18n_gettext( 
23             538,
24             'Allows staff to view search filter groups and entries',
25             'ppl', 
26             'description' 
27         )
28
29     );
30
31 COMMIT;