-- Atualizando contratos para v3: Tipo, Observações e Novos Status
-- Status: draft, active, completed, canceled, renewing

ALTER TABLE contracts MODIFY COLUMN status ENUM('draft', 'active', 'completed', 'canceled', 'renewing') DEFAULT 'draft';
ALTER TABLE contracts ADD COLUMN contract_type VARCHAR(100) AFTER unit_id;
ALTER TABLE contracts ADD COLUMN observations TEXT AFTER description;
