ALTER TABLE FCT_MODELOCONTRATO ADD IDQUANTINTEGRAHCM VARCHAR2(3)
/
                   
ALTER TABLE FCT_MODELOCONTRATO ADD CONSTRAINT CKC_IDQUANTINTEGRAHCM_MODCONT CHECK (IDQUANTINTEGRAHCM IN ('QTD', 'QMD'))
/

UPDATE FCT_MODELOCONTRATO
  SET IDQUANTINTEGRAHCM = 'QTD'
WHERE IDQUANTINTEGRAHCM IS NULL
/
COMMIT
/
ALTER TABLE FCT_CONTRATO ADD IDQUANTINTEGRAHCM VARCHAR2(3)
/

ALTER TABLE FCT_CONTRATO ADD CONSTRAINT CKC_IDQUANTINTEGRAHCM_CONT CHECK (IDQUANTINTEGRAHCM IN ('QTD', 'QMD'))
/

UPDATE FCT_CONTRATO
  SET IDQUANTINTEGRAHCM = 'QTD'
WHERE IDQUANTINTEGRAHCM IS NULL
/
COMMIT
/