-- ABS-56229
------- GARMENTBATCHSCAN ---------
ALTER TABLE GARMENTBATCHSCAN ADD (ROUTECONTROL_ID NUMBER NULL);

CREATE INDEX XIF4GARMENTBATCHSCAN on GARMENTBATCHSCAN (ROUTECONTROL_ID ASC);

ALTER TABLE GARMENTBATCHSCAN ADD CONSTRAINT GARMENTBATCHSCAN_RC FOREIGN KEY (ROUTECONTROL_ID)
REFERENCES ROUTECONTROL (ROUTECONTROL_ID) ON DELETE SET NULL;

------- DELIVERYSCAN ---------
ALTER TABLE DELIVERYSCAN ADD (GARMENTBATCH_ID NUMBER NULL);

CREATE INDEX XIF12DELIVERYSCAN ON DELIVERYSCAN (GARMENTBATCH_ID ASC);

ALTER TABLE DELIVERYSCAN ADD CONSTRAINT DELIVERYSCAN_GARMBATCH FOREIGN KEY (GARMENTBATCH_ID)
REFERENCES GARMENTBATCH (GARMENTBATCH_ID) ON DELETE SET NULL;

