ALTER TABLE FCT_AGRUPAMENTOTIPOORCA DROP CONSTRAINT CHK_IDTPFATURA_FCT_AGRUPTIPOORCA
/

ALTER TABLE FCT_AGRUPAMENTOTIPOORCA ADD CONSTRAINT CKC_IDTPFATURA_FCT_AGRUPTPORC CHECK (IDTPFATURA IN ('A', 'X', 'P'))
/

DROP INDEX FCM00195_FK
/

ALTER TABLE FCM_FOTORESULTAUDIT DROP CONSTRAINT FKFCM00195CATEGORIAAUDIT_FTRESULAUT
/

ALTER TABLE FCM_FOTORESULTAUDIT ADD CONSTRAINT FKFCM00195CATAUDIT_FTRESULAUT FOREIGN KEY (NRCATEGORIAAUDIT)
    REFERENCES FCM_CATEGORIAAUDIT (NRCATEGORIAAUDIT)
/ 

CREATE INDEX FCM00195_FK ON FCM_FOTORESULTAUDIT (NRCATEGORIAAUDIT)
/

DROP INDEX SM00412_FK
/

ALTER TABLE FCT_PARCELASAPURNEGCONTRATO DROP CONSTRAINT FKSM00412PARCAPURNEGCON_NEGCONT
/

ALTER TABLE FCT_PARCELASAPURNEGCONTRATO ADD CONSTRAINT FKSM00412PARCAPRNEGCON_NEGCON FOREIGN KEY (NRNEGCONTRATO)
      REFERENCES FCT_NEGCONTRATO (NRNEGCONTRATO)
/

CREATE INDEX SM00412_FK ON FCT_PARCELASAPURNEGCONTRATO (NRNEGCONTRATO ASC)
/