-- 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;