-- ABS-32100
ALTER TABLE PLPCFIXEDWEARERS ADD (STARTDATE DATE DEFAULT SYSDATE NOT NULL,
                                 ENDDATE DATE DEFAULT TO_DATE('31-12-2099','DD-MM-YYYY') NOT NULL);

DROP INDEX XAK1PLPCFIXEDWEARERS;
CREATE UNIQUE INDEX XAK1PLPCFIXEDWEARERS ON PLPCFIXEDWEARERS (PRODUCTLISTPERCUSTOMER_ID, COSTCENTER_ID, NROFWEARERS, NROFCHANGES, STARTDATE);