--ABS-56351
------ CUSTOMER ---------
COMMENT ON COLUMN CUSTOMER.LOSSCHARGETRIGGER IS '0=Loss Triggered by Outscan Date 1=Loss Triggered by Last Scan Date
2=Loss Triggered by Delivery Date';

ALTER TABLE CUSTOMER ADD CONSTRAINT LOSSCHARGETRIGGER_VALID1_1 CHECK (LOSSCHARGETRIGGER IN (0,1,2));

------- UNIQUEITEM --------
ALTER TABLE UNIQUEITEM ADD (LASTDELIVERYDATE DATE NULL);

----- UNIQUEITEMLOSS ------
ALTER TABLE UNIQUEITEMLOSS ADD (LASTDELIVERYDATE DATE NULL);

CREATE INDEX XIE6UNIQUEITEMLOSS ON UNIQUEITEMLOSS (UNIQUEITEM_LINK_ID ASC, LASTDELIVERYDATE ASC);
