ALTER TABLE NOTIFICSUPPLY ADD NRAUTOFORN VARCHAR2(10)
/

ALTER TABLE NOTIFICSUPPLY DROP COLUMN IDNOTIFICFAV
/
CREATE INDEX FKSUP00332CONFREC ON AUTOFORNE (CDFILDEST, IDCONFRECEBIMENTO)
/

ALTER TABLE AUTOFORNE ADD DTAPROVALCADA DATE
/
ALTER TABLE CONFIGALCADA DROP CONSTRAINT CKC_IDTPALCADA
/

ALTER TABLE CONFIGALCADA ADD CONSTRAINT CKC_IDTPALCADA CHECK (IDTPALCADA IN ('ORCAMENTO', 'FINANCEIRO', 'COMPRAS', 'CATALOGO'))
/