ALTER TABLE FCT_PARAMETROGERAL ADD DSEMAILALERTRENOVCONT VARCHAR(400)
/  

ALTER TABLE FCT_PARAMETROGERAL ADD IDPERIODALERTRENOVCONT VARCHAR(1) DEFAULT 'N'
/ 

ALTER TABLE FCT_PARAMETROGERAL ADD CONSTRAINT CKC_IDPERIODALERTRENV_FCTPARAM CHECK(IDPERIODALERTRENOVCONT IN('N', 'D', 'S', 'M'))
/
ALTER TABLE FCT_MODELOCONTRATO ADD IDRENOVACAOAUTOMATICA VARCHAR(1)
/

ALTER TABLE FCT_MODELOCONTRATO ADD CONSTRAINT CKC_RENOVAUTOMATICA_MODCT CHECK(IDRENOVACAOAUTOMATICA IN ('S', 'N'))
/

ALTER TABLE FCT_MODELOCONTRATO ADD IDREAJUSTEAUTOMATICO VARCHAR(1)
/

ALTER TABLE FCT_MODELOCONTRATO ADD CONSTRAINT CKC_REAJUSTEAUTOMATICO_MODCT CHECK(IDREAJUSTEAUTOMATICO IN ('S', 'N'))
/
ALTER TABLE FCT_CONTRATO ADD IDRENOVACAOAUTOMATICA VARCHAR(1)
/

ALTER TABLE FCT_CONTRATO ADD CONSTRAINT CKC_RENOVAUTOMATICA_CONTRATO CHECK(IDRENOVACAOAUTOMATICA IN ('S', 'N'))
/

ALTER TABLE FCT_CONTRATO ADD IDREAJUSTEAUTOMATICO VARCHAR(1)
/

ALTER TABLE FCT_CONTRATO ADD CONSTRAINT CKC_REAJAUTOMATICO_CONTRATO CHECK(IDREAJUSTEAUTOMATICO IN ('S', 'N'))
/

ALTER TABLE FCT_CONTRATO ADD DTRENOVACAO DATE
/

ALTER TABLE FCT_CONTRATO ADD NRDIASPRORGCONTRENOV NUMBER
/
CREATE TABLE FCT_LOGRENOVACAOCONT (
	NRSEQCONTRATO         NUMBER,
	MSGERROR              VARCHAR(2000),
	DTRENOVACAO           DATE,
	DTFINVIGENCONT        DATE,
	DTINIVIGENCONT        DATE,
	VRCONTRATO			  FLOAT(126),
	NRORG             NUMBER 	     DEFAULT      SYS_CONTEXT('nrorg_ctx','nrorg') NOT NULL,
    IDATIVO           VARCHAR2(1)     DEFAULT 'S' NOT NULL
      CONSTRAINT CKC_IDATIVO_FCT_LOGRENOVCONT CHECK (IDATIVO IN ('S','N')),
    DTINCLUSAO        DATE                  			NULL,
    DTULTATU          DATE                  			NULL,
    NRORGINCLUSAO     NUMBER          DEFAULT 		SYS_CONTEXT('nrorg_ctx','nrorg')		NULL,
    CDOPERINCLUSAO    VARCHAR2(12)    DEFAULT '1' 		NULL,
    NRORGULTATU       NUMBER          DEFAULT 		SYS_CONTEXT('nrorg_ctx','nrorg')		NULL,
    CDOPERULTATU      VARCHAR2(12)    DEFAULT '1'
)