-- ============================================================
--  Rollback de 2026-09-03_01_ordenes_compra.sql
-- ============================================================
USE tinsa_db;

DELETE FROM permisos_roles
WHERE id_pestana IN (SELECT id FROM (
  SELECT id FROM pestanas WHERE ruta IN
    ('/compras/ordenes', '/compras/aprobacion-ordenes', '/compras/pagos')
) t);

DELETE FROM pestanas
WHERE ruta IN ('/compras/ordenes', '/compras/aprobacion-ordenes', '/compras/pagos');

DROP TABLE IF EXISTS orden_compra_recepcion_item;
DROP TABLE IF EXISTS orden_compra_recepcion;
DROP TABLE IF EXISTS orden_compra_historial;
DROP TABLE IF EXISTS orden_compra_item;
DROP TABLE IF EXISTS orden_compra;

ALTER TABLE proveedor DROP COLUMN nit;