-- ============================================================
--  Rollback de 2026-09-25_04_traslados_bodega.sql
-- ============================================================
USE tinsa_db;

DELETE FROM permisos_roles WHERE id_pestana IN (
  SELECT id FROM (SELECT id FROM pestanas WHERE ruta IN ('/inventario/traslados', '/inventario/aprobacion-traslados')) t
);
DELETE FROM permisos WHERE id_pestana IN (
  SELECT id FROM (SELECT id FROM pestanas WHERE ruta IN ('/inventario/traslados', '/inventario/aprobacion-traslados')) t
);
DELETE FROM pestanas WHERE ruta IN ('/inventario/traslados', '/inventario/aprobacion-traslados');

DROP TABLE IF EXISTS traslado_bodega_historial;
DROP TABLE IF EXISTS traslado_bodega_item;
DROP TABLE IF EXISTS traslado_bodega;