INSERT IGNORE INTO permission_modules (module_key, label, module_group, sort_order) VALUES
  ('employee_performance', 'Employee Performance', 'Core', 58);

INSERT IGNORE INTO role_permissions (role_id, module_key, action_key, allowed)
SELECT wr.id, 'employee_performance', pa.action_key, 1
FROM workspace_roles wr
CROSS JOIN permission_actions pa
WHERE wr.slug = 'super-admin';

INSERT IGNORE INTO role_permissions (role_id, module_key, action_key, allowed)
SELECT DISTINCT rp.role_id, 'employee_performance', 'read', 1
FROM role_permissions rp
WHERE rp.module_key = 'dashboard' AND rp.action_key = 'read' AND rp.allowed = 1;

INSERT IGNORE INTO role_permissions (role_id, module_key, action_key, allowed)
SELECT DISTINCT rp.role_id, 'employee_performance', 'view', 1
FROM role_permissions rp
WHERE rp.module_key = 'employees' AND rp.action_key = 'read' AND rp.allowed = 1;

INSERT IGNORE INTO role_permissions (role_id, module_key, action_key, allowed)
SELECT DISTINCT rp.role_id, 'employee_performance', 'export', 1
FROM role_permissions rp
WHERE rp.module_key = 'employees' AND rp.action_key = 'export' AND rp.allowed = 1;