1 -- @tag: right_productivity_as_category
2 -- @description: Rechte: Produktivität als eigene Kategorie
3 -- @depends: master_rights_positions_fix
4 -- @locales: Productivity (TODO list, Follow-Ups)
6 -- make space before 'configuration'
7 UPDATE auth.master_rights SET position = position+1000
8 WHERE position >= (SELECT position FROM auth.master_rights WHERE name LIKE 'configuration');
10 -- insert category for productivity before 'configuration'
11 INSERT INTO auth.master_rights (position, name, description, category)
12 VALUES ((SELECT position FROM auth.master_rights WHERE name LIKE 'configuration') - 1000,
13 'productivity_category',
17 -- move productivity rights below 'productivity_category'
18 UPDATE auth.master_rights SET position = (SELECT position FROM auth.master_rights WHERE name LIKE 'productivity_category') + 100,
19 description = 'Productivity (TODO list, Follow-Ups)'
20 WHERE name LIKE 'productivity';
22 UPDATE auth.master_rights SET position = (SELECT position FROM auth.master_rights WHERE name LIKE 'productivity_category') + 200
23 WHERE name LIKE 'email_journal';
25 UPDATE auth.master_rights SET position = (SELECT position FROM auth.master_rights WHERE name LIKE 'productivity_category') + 250
26 WHERE name LIKE 'email_employee_readall';