ALTER TABLE FCT_CAPAPARAMFATESC ADD QTPARCELASPARAUTO NUMBER
/

ALTER TABLE FCT_CAPAPARAMFATESC ADD QTDIASINTERVALOPARAUTO NUMBER
/

ALTER TABLE FCT_CAPAPARAMFATESC ADD NRDIAVENCIMENTOPARAUTO NUMBER
/

ALTER TABLE FCT_CAPAPARAMFATESC ADD QTCARENCIADIASPARAUTO NUMBER
/

ALTER TABLE FCT_PARAMFATITESC ADD QTPARCELASPARAUTO NUMBER
/

ALTER TABLE FCT_PARAMFATITESC ADD QTDIASINTERVALOPARAUTO NUMBER
/

ALTER TABLE FCT_PARAMFATITESC ADD NRDIAVENCIMENTOPARAUTO NUMBER
/

ALTER TABLE FCT_PARAMFATITESC ADD QTCARENCIADIASPARAUTO NUMBER
/

ALTER TABLE FCT_RELACESCOPOMODCONT ADD IDGERAPARCAUTO CHAR(1)
/

ALTER TABLE FCT_RELACESCOPOMODCONT ADD CONSTRAINT CKC_IDGERAPARCAUTO_CONT CHECK (IDGERAPARCAUTO IN ('S', 'N'))
/

UPDATE FCT_RELACESCOPOMODCONT
   SET IDGERAPARCAUTO = 'N'
 WHERE IDGERAPARCAUTO IS NULL
/

COMMIT
/