-- ABS-109578/ ABS-111107
ALTER TABLE MATCARRYUNITCONTENTS ADD (ROUTECONTROLBULKPACKSTOP_ID NUMBER NULL);
 
CREATE INDEX XIF4MATCARRYUNITCONTENTS ON MATCARRYUNITCONTENTS (ROUTECONTROLBULKPACKSTOP_ID ASC);

ALTER TABLE MATCARRYUNITCONTENTS
  ADD CONSTRAINT FK_MATCARRYUNITCONT_RCBULKPSTOP FOREIGN KEY (ROUTECONTROLBULKPACKSTOP_ID)
  REFERENCES ROUTECONTROLBULKPACKSTOP (ROUTECONTROLBULKPACKSTOP_ID) ON DELETE SET NULL;
