INSERT IGNORE INTO permission_modules (module_key, label, module_group, sort_order) VALUES
  ('sale_pipelines', 'Sale Pipelines', 'Core', 57);

INSERT IGNORE INTO role_permissions (role_id, module_key, action_key, allowed)
SELECT wr.id, 'sale_pipelines', 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, 'sale_pipelines', 'read', 1
FROM role_permissions rp
WHERE rp.module_key = 'web_settings' AND rp.action_key = 'read' AND rp.allowed = 1;

INSERT IGNORE INTO role_permissions (role_id, module_key, action_key, allowed)
SELECT wr.id, 'sale_pipelines', 'read', 1
FROM workspace_roles wr
WHERE wr.slug = 'email-operator' AND wr.deleted_at IS NULL;