USE `garage_management`;

INSERT INTO `permissions` (`module`, `slug`, `name`) VALUES
  ('reports', 'reports.view', 'View Reports'),
  ('audit', 'audit.view', 'View Audit Logs')
ON DUPLICATE KEY UPDATE `name` = VALUES(`name`);

INSERT INTO `role_permissions` (`role_id`, `permission_id`)
SELECT (SELECT id FROM roles WHERE name = 'Admin'), p.id FROM permissions p
WHERE p.slug IN ('reports.view','audit.view')
ON DUPLICATE KEY UPDATE `role_id` = `role_id`;

INSERT INTO `role_permissions` (`role_id`, `permission_id`)
SELECT (SELECT id FROM roles WHERE name = 'Manager'), p.id FROM permissions p
WHERE p.slug IN ('reports.view','audit.view')
ON DUPLICATE KEY UPDATE `role_id` = `role_id`;

INSERT INTO `role_permissions` (`role_id`, `permission_id`)
SELECT (SELECT id FROM roles WHERE name = 'Accountant'), p.id FROM permissions p
WHERE p.slug IN ('reports.view')
ON DUPLICATE KEY UPDATE `role_id` = `role_id`;