--Order 20010883

ALTER TABLE WORKORDER
	ADD (MOVEDWEAREREMPLOYMENTLINK_ID NUMBER NULL);



ALTER TABLE WORKORDERSPLIT
	ADD (MOVEDWEAREREMPLOYMENTLINK_ID NUMBER NULL);


CREATE INDEX XIF22WORKORDER on WORKORDER (MOVEDWEAREREMPLOYMENTLINK_ID)
  TABLESPACE INDX;


CREATE INDEX XIF4WORKORDERSPLIT on WORKORDERSPLIT (MOVEDWEAREREMPLOYMENTLINK_ID)
  TABLESPACE INDX;


ALTER TABLE WORKORDER
ADD CONSTRAINT WORKORDER_WEAREREMPLOYMENTLINK FOREIGN KEY (MOVEDWEAREREMPLOYMENTLINK_ID) REFERENCES WEAREREMPLOYMENT_LINK (WEAREREMPLOYMENT_LINK_ID);



ALTER TABLE WORKORDERSPLIT
ADD CONSTRAINT WORKORDERSPLIT_WEAREREMPLOYMEN FOREIGN KEY (MOVEDWEAREREMPLOYMENTLINK_ID) REFERENCES WEAREREMPLOYMENT_LINK (WEAREREMPLOYMENT_LINK_ID);


