ALTER TABLE FCT_SIGNATPADRMODORCA DROP CONSTRAINT FK_FCT_MODORCA_SIGNATPADMDORCA
/

ALTER TABLE FCT_SIGNATPADRMODORCA
    ADD CONSTRAINT FK_FCT_MODORCA_SIGNATPADMDORCA FOREIGN KEY (NRORCAMENTOMODELO)
      REFERENCES FCT_ORCAMENTOMODELO (NRORCAMENTOMODELO) ON DELETE CASCADE
/

ALTER TABLE FCT_SIGNATPADRMODCONT DROP CONSTRAINT FK_FCT_MODCONT_SIGNATPADMDCONT
/

ALTER TABLE FCT_SIGNATPADRMODCONT
    ADD CONSTRAINT FK_FCT_MODCONT_SIGNATPADMDCONT FOREIGN KEY (NRSEQMODCONTRA)
      REFERENCES FCT_MODELOCONTRATO (NRSEQMODCONTRA) ON DELETE CASCADE
/

ALTER TABLE FCT_CONTRATO DROP CONSTRAINT CK_IDSITUACAOCONTRATO_CONTR
/

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'))
/

ALTER TABLE FCT_PARAMETROGERAL ADD NMSENDERCERTSIGN VARCHAR2(100)
/

ALTER TABLE FCT_PARAMETROGERAL ADD DSEMAILSENDERCERTSIGN VARCHAR2(100)
/

ALTER TABLE FCT_PARAMETROGERAL ADD NRCPFSENDERCERTSIGN VARCHAR2(11)
/