-- ABS-150530 Create new field and database structure for Workstation

ALTER TABLE WORKSTATIONEXTRAINFO 
ADD (PLANTDEPARTMENTMACHINE_ID NUMBER NULL);

CREATE INDEX XIF1WORKSTATIONEXTRAINFO ON WORKSTATIONEXTRAINFO (PLANTDEPARTMENTMACHINE_ID);

ALTER TABLE WORKSTATIONEXTRAINFO
ADD CONSTRAINT FK_WORKSTATIONEXTRAINFO_PLANTDPTMACHINEID FOREIGN KEY (PLANTDEPARTMENTMACHINE_ID) REFERENCES PLANTDEPARTMENTMACHINE (PLANTDEPARTMENTMACHINE_ID) ON DELETE SET NULL;