--ABS-164946

--DELIVERYSCAN TABLE
ALTER TABLE DELIVERYSCAN
DROP CONSTRAINT DELIVERYSCAN_PACKINGNOTE_ID;

ALTER TABLE DELIVERYSCAN
ADD CONSTRAINT DELIVERYSCAN_PACKINGNOTE_ID FOREIGN KEY (PACKINGNOTE_ID)
REFERENCES PACKINGNOTE (PACKINGNOTE_ID) ON DELETE CASCADE;

--STRAIGHTEVENRETURN TABLE
ALTER TABLE STRAIGHTEVENRETURN
DROP CONSTRAINT STRAIGHTEVENRETURN_STOP_ID;

ALTER TABLE STRAIGHTEVENRETURN
ADD CONSTRAINT STRAIGHTEVENRETURN_STOP_ID FOREIGN KEY (STOP_ID)
REFERENCES STOP (STOP_ID) ON DELETE CASCADE;
