-- ABS-85758/ ABS-87977

--------------CSVEXPORT table--------------------
ALTER TABLE CSVEXPORT ADD (DELIVERYDATE DATE NULL);

COMMENT ON COLUMN CSVEXPORT.CSVEXPORTTYPE
  IS '0 = CSV Export Invoice
1 = Client.CSV
2 = Costs per wearer
3 = Wash costs per client';

ALTER TABLE CSVEXPORT
  DROP CONSTRAINT CSVEXPORT_VALID1_1;
ALTER TABLE CSVEXPORT
  ADD CONSTRAINT CHK_CSVEXPORT_CSVEXPORTTYPE
  CHECK (CSVEXPORTTYPE IN (0, 1, 2, 3));