-- ============================================================
--  Rollback de 2026-10-14_01_paquetes_servicios.sql
--  Se pierden los paquetes y su lista de precios.
-- ============================================================
USE tinsa_db;

DELETE pr FROM permisos_roles pr JOIN pestanas p ON p.id = pr.id_pestana WHERE p.ruta = '/ventas/paquetes';
DELETE pe FROM permisos pe JOIN pestanas p ON p.id = pe.id_pestana WHERE p.ruta = '/ventas/paquetes';
DELETE FROM pestanas WHERE ruta = '/ventas/paquetes';

DROP TABLE IF EXISTS `paquete_material`;
DROP TABLE IF EXISTS `paquete_formula`;
DROP TABLE IF EXISTS `paquete_variable`;
DROP TABLE IF EXISTS `paquete`;
DROP TABLE IF EXISTS `paquete_producto`;