ALTER TABLE FCT_CONTRATODOC DROP CONSTRAINT CK_IDSITUACAOCONTRATO_CON
/
  
ALTER TABLE FCT_CONTRATODOC ADD CONSTRAINT CK_IDSITUACAOCONTRATO_CON CHECK (IDSITUACAOCONTRATO  IN ('P','A','R','C', 'E','D', 'S'))
/

ALTER TABLE FCT_CONTRATO DROP CONSTRAINT CKC_IDSITCONTRATO_FCTCONTR
/
  
ALTER TABLE FCT_CONTRATO ADD CONSTRAINT CKC_IDSITCONTRATO_FCTCONTR CHECK (IDSITUACAOCONTRATO  IN ('P','A','R','C', 'E','D', 'S'))
/

ALTER TABLE FCT_CONTRATO ADD DTSUSPENSAO DATE
/

ALTER TABLE FCT_MODELODOCCONTR DROP CONSTRAINT CK_IDSITUACAOCONTRATO_DOC
/

ALTER TABLE FCT_MODELODOCCONTR ADD CONSTRAINT CK_IDSITUACAOCONTRATO_DOC CHECK (IDSITUACAOCONTRATO  IN ('P','A','R','C', 'E','D', 'S'))
/

ALTER TABLE FCT_ORCAMENTO ADD ISSUEID NUMBER
/