ALTER TABLE RFPFORNECEDOR DROP CONSTRAINT FKSUP00670RFPFORNECDR_NRFPMAIN
/

ALTER TABLE RFPFORNECEDOR ADD CONSTRAINT FKSUP00670RFPFORNECDR_NRFPMAIN FOREIGN KEY (NRRFPMAIN) REFERENCES RFPMAIN (NRRFPMAIN) ON DELETE CASCADE
/

ALTER TABLE RFPREGIAO DROP CONSTRAINT FKSUP00672RFPREGIAO_NRRFPMAIN
/

ALTER TABLE RFPREGIAO ADD CONSTRAINT FKSUP00672RFPREGIAO_NRRFPMAIN FOREIGN KEY (NRRFPMAIN) REFERENCES RFPMAIN (NRRFPMAIN) ON DELETE CASCADE
/

ALTER TABLE RFPPRODMARCA DROP CONSTRAINT FKSUP00674RFPRODMARCA_NRFPMAIN
/

ALTER TABLE RFPPRODMARCA ADD CONSTRAINT FKSUP00674RFPRODMARCA_NRFPMAIN FOREIGN KEY (NRRFPMAIN) REFERENCES RFPMAIN (NRRFPMAIN) ON DELETE CASCADE
/

ALTER TABLE RFPITEMCOTA DROP CONSTRAINT FKSUP00680RFPITEMCOTA_NRFPMAIN
/

ALTER TABLE RFPITEMCOTA ADD CONSTRAINT FKSUP00680RFPITEMCOTA_NRFPMAIN FOREIGN KEY (NRRFPMAIN) REFERENCES RFPMAIN (NRRFPMAIN) ON DELETE CASCADE
/

ALTER TABLE RFPREGIAO ADD CDFORNECED VARCHAR2(21)
/

ALTER TABLE RFPREGIAO ADD CONSTRAINT FKSUP00687RFPREGIAO_CDFORNECED FOREIGN KEY (CDFORNECED) REFERENCES FORNECEDOR (CDFORNECED)
/

CREATE INDEX SUP00687_FK ON RFPREGIAO(CDFORNECED)
/