--Order 20010886.430

ALTER TABLE MOBILEDEVICE
	ADD (PACKINGASSISTANT VARCHAR2(1)  DEFAULT 'N' NOT NULL CONSTRAINT YN_ValidationField47 CHECK (PACKINGASSISTANT IN ('Y', 'N')));



ALTER TABLE MOBILEDEVICE
	ADD (PACKINGASSISTANTVERSION VARCHAR2(5));



ALTER TABLE MOBILEDEVICE
	ADD (PACKINGASSISTANTWORKSTATION_ID NUMBER);


CREATE  INDEX XIF2MOBILEDEVICE ON MOBILEDEVICE
(PACKINGASSISTANTWORKSTATION_ID   ASC) TABLESPACE INDX;


ALTER TABLE MOBILEDEVICE
ADD CONSTRAINT MOBILEDEVICE_WORKSTATION FOREIGN KEY (PACKINGASSISTANTWORKSTATION_ID) REFERENCES WORKSTATION (WORKSTATION_ID);


