--ABS-94756/ABS-105084
----------------PACKINGNOTELINESPECIAL
CREATE TABLE PACKINGNOTELINESPECIAL
(
  PACKINGNOTELINE_ID NUMBER NOT NULL,
  QTYREWASH NUMBER DEFAULT 0 NOT NULL,
  SYSTEMUSER_ID  NUMBER NOT NULL,
  TIMESTAMP      DATE NOT NULL
);

COMMENT ON COLUMN PACKINGNOTELINESPECIAL.QTYREWASH 
  IS 'Number of items scanned in Rewash (via MultireadRewashScan)';

ALTER TABLE PACKINGNOTELINESPECIAL
  ADD CONSTRAINT XPKPACKINGNOTELINESPECIAL PRIMARY KEY (PACKINGNOTELINE_ID);

ALTER TABLE PACKINGNOTELINESPECIAL
  ADD CONSTRAINT FK_PNLSPECIAL_PNL FOREIGN KEY (PACKINGNOTELINE_ID)
  REFERENCES PACKINGNOTELINE(PACKINGNOTELINE_ID) ON DELETE CASCADE;
