-- Manager becomes Advisor. Driver picks up and delivers the car.

INSERT INTO roles (name, slug, level, description)
SELECT 'Advisor', 'advisor', 3, 'Service advisor. Accepts bookings, inspects cars, and assigns drivers and staff.'
FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM roles WHERE slug = 'advisor');

UPDATE users u
INNER JOIN roles old_role ON old_role.id = u.role_id AND old_role.slug = 'manager'
INNER JOIN roles new_role ON new_role.slug = 'advisor'
SET u.role_id = new_role.id;

DELETE FROM roles WHERE slug = 'manager';

INSERT INTO roles (name, slug, level, description)
SELECT 'Driver', 'driver', 4, 'Picks up the car from the customer and delivers it back.'
FROM DUAL
WHERE NOT EXISTS (SELECT 1 FROM roles WHERE slug = 'driver');