-- ABS-36845 / ABS-64626
ALTER TABLE PACKINGNOTE ADD (PARKEDBYEMPLOYEE_ID NUMBER NULL);

COMMENT ON COLUMN PACKINGNOTE.PARKEDBYEMPLOYEE_ID
  IS 'Used by packing assistant to log who parked the packing.  Also used as a flag to indicate that it has been parked.';

CREATE INDEX XIF20PACKINGNOTE ON PACKINGNOTE (PARKEDBYEMPLOYEE_ID ASC);

ALTER TABLE PACKINGNOTE
  ADD CONSTRAINT PACKINGNOTE_PARKEDBYEMPLOYEE FOREIGN KEY (PARKEDBYEMPLOYEE_ID)
  REFERENCES EMPLOYEE (EMPLOYEE_ID) ON DELETE SET NULL;
