--SO 20012870.50 - Soil Count Entry per Consumption Point

ALTER TABLE DELIVERYVARIATIONS
	ADD (OLDPLANTDEPARTMENT_ID NUMBER NULL);

CREATE  INDEX XIF11DELIVERYVARIATIONS ON DELIVERYVARIATIONS
(OLDPLANTDEPARTMENT_ID   ASC);

ALTER TABLE DELIVERYVARIATIONS
ADD CONSTRAINT DELIVERYVAR_OLDPLANTDEP_ID FOREIGN KEY (OLDPLANTDEPARTMENT_ID) REFERENCES PLANTDEPARTMENT (PLANTDEPARTMENT_ID) ON DELETE SET NULL;


