ALTER TABLE FCM_TAREFARECORRENTE ADD IDSITUACAO CHAR(1) DEFAULT '1' NOT NULL
/

ALTER TABLE FCM_TAREFARECORRENTE ADD CONSTRAINT CHK_IDSITUACAO CHECK (IDSITUACAO IN ('1','2','3','4'))
/

ALTER TABLE FCM_TAREFARECORRENTE ADD DSLOGGERACAO VARCHAR2(4000)
/

ALTER TABLE FCM_TAREFAAGEND ADD NRTAREFARECORRENTE NUMBER NULL
/

CREATE INDEX FCM00135_FK ON FCM_TAREFAAGEND (NRTAREFARECORRENTE ASC)
/

ALTER TABLE FCM_TAREFAAGEND 
    ADD CONSTRAINT FKFCM00135TARAGEND_TARRECORR FOREIGN KEY (NRTAREFARECORRENTE)
        REFERENCES FCM_TAREFARECORRENTE (NRTAREFARECORRENTE)
/