-- Agregar campo invoice_printed a la tabla orders
ALTER TABLE orders 
ADD COLUMN invoice_printed BOOLEAN DEFAULT FALSE AFTER archived;

-- Crear índice para mejorar rendimiento de consultas
CREATE INDEX idx_invoice_printed ON orders(invoice_printed);