-- ============================================================
--  Rollback de 2026-10-06_02_roles_ventas.sql
--  (usuario_roles y permisos_roles caen por FK; si no tuvieran
--   CASCADE, se borran explícitamente antes)
-- ============================================================
USE tinsa_db;

DELETE ur FROM usuario_roles ur JOIN roles r ON r.id = ur.id_rol WHERE r.nombre IN ('Gerente de ventas', 'Vendedor');
DELETE pr FROM permisos_roles pr JOIN roles r ON r.id = pr.id_rol WHERE r.nombre IN ('Gerente de ventas', 'Vendedor');
DELETE FROM roles WHERE nombre IN ('Gerente de ventas', 'Vendedor');