-- ABS-63429/ ABS-63430 (IDA-90)

DROP INDEX XAK1WEARERTEMPASSIGNMENT;

CREATE UNIQUE INDEX XAK1WEARERTEMPASSIGNMENT ON WEARERTEMPASSIGNMENT (UNIQUEITEM_LINK_ID ASC, ISSUETOWEARERDATE ASC, RETURNFROMWEARERDATE ASC, WEAREREMPLOYMENT_ID ASC);