-- Add Mechanics and Fleet Managers groups and grant Vehicle Reports card access
INSERT INTO groups (name, description)
VALUES
  ('Mechanics', 'Vehicle maintenance team'),
  ('Fleet Managers', 'Fleet management supervisors');

INSERT INTO dashboard_card_permissions (card_slug, group_id)
VALUES
  ('Vehicle_Reports', (SELECT id FROM groups WHERE name='Mechanics' LIMIT 1)),
  ('Vehicle_Reports', (SELECT id FROM groups WHERE name='Fleet Managers' LIMIT 1));
