9 lines
471 B
MySQL
9 lines
471 B
MySQL
|
-- Additive permission only. Rollback: hide the report UI; retain permissions/data.
|
||
|
|
INSERT INTO permissions(code,description,category) VALUES
|
||
|
|
('planner.absence_report','Se og eksportere fraværsrapporter for tilladte medarbejdere','planner')
|
||
|
|
ON CONFLICT DO NOTHING;
|
||
|
|
INSERT INTO group_permissions(group_id,permission_id)
|
||
|
|
SELECT g.id,p.id FROM groups g CROSS JOIN permissions p
|
||
|
|
WHERE g.name='Administrators' AND p.code='planner.absence_report'
|
||
|
|
ON CONFLICT DO NOTHING;
|