--SO 20015919

--------------------------------------------------------STERILIZATIONRUN --------------------------------------------------
ALTER TABLE STERILIZATIONRUN ADD (CONFIRMATIONEMPLOYEE_ID NUMBER NULL,
				        APPROVALEMPLOYEE_ID NUMBER NULL);

CREATE INDEX XIF09STERILIZATIONRUN ON STERILIZATIONRUN (CONFIRMATIONEMPLOYEE_ID);

ALTER TABLE STERILIZATIONRUN
  ADD CONSTRAINT STERILIZATIONRUN_EMPLOYEE FOREIGN KEY (CONFIRMATIONEMPLOYEE_ID)
  REFERENCES EMPLOYEE (EMPLOYEE_ID);

CREATE INDEX XIF10STERILIZATIONRUN ON STERILIZATIONRUN (APPROVALEMPLOYEE_ID);

ALTER TABLE STERILIZATIONRUN
  ADD CONSTRAINT STERILIZATIONRUN_EMPLOYEE1 FOREIGN KEY (APPROVALEMPLOYEE_ID)
  REFERENCES EMPLOYEE (EMPLOYEE_ID);


------------------------------------------------------------WORKSTATION---------------------------------------------------

ALTER TABLE WORKSTATION
  DROP CONSTRAINT SOCKETPROTOCOL_VALID1_1;
ALTER TABLE WORKSTATION
  ADD CONSTRAINT SOCKETPROTOCOL_VALID1_1
  CHECK (SOCKETPROTOCOL IN (0, 1, 2, 3, 4, 5, 6));

COMMENT ON COLUMN WORKSTATION.SOCKETPROTOCOL
  IS '0 = Not applicable 1 = Standard EPC + CR/LF 2 = Datamars 3 = TagSys-L400 EPC + CR/LF 4 = TagSys u-Door 5 = TAGSYSSTXNG 6 = TCP Sick';


