-- ABS-32100

--------- PLPCFIXEDWEARERS ---------

CREATE SEQUENCE SEQ_PLPCFIXEDWEARERS
START WITH 1
INCREMENT BY 1;

ALTER TABLE PLPCFIXEDWEARERS ADD PLPCFIXEDWEARERS_ID NUMBER NOT NULL;

ALTER TABLE PLPCFIXEDWEARERS
  DROP CONSTRAINT XPKPLPCFIXEDWEARERS CASCADE;

ALTER TABLE PLPCFIXEDWEARERS
  ADD CONSTRAINT XPKPLPCFIXEDWEARERS PRIMARY KEY (PLPCFIXEDWEARERS_ID);
    
CREATE UNIQUE INDEX XAK1PLPCFIXEDWEARERS ON PLPCFIXEDWEARERS (COSTCENTER_ID, NROFWEARERS, NROFCHANGES);


