-- ABS-11734
------------   EXCHANGECARTSCHEDULE   -------------
CREATE SEQUENCE SEQ_EXCHANGECARTSCHEDULE
START WITH 1
INCREMENT BY 1;

ALTER TABLE EXCHANGECARTSCHEDULE DROP CONSTRAINT XPKEXCHANGECARTSCHEDULE;

ALTER TABLE EXCHANGECARTSCHEDULE ADD (EXCHANGECARTSCHEDULE_ID NUMBER NOT NULL);

ALTER TABLE EXCHANGECARTSCHEDULE ADD CONSTRAINT XPKEXCHANGECARTSCHEDULE PRIMARY KEY (EXCHANGECARTSCHEDULE_ID);

CREATE UNIQUE INDEX XAK1EXCHANGECARTSCHEDULE ON EXCHANGECARTSCHEDULE (EXCHANGECART_ID ASC, ACTION ASC, DAY_ID ASC);