   /*I-TEST 9 for order 502258*/   
      /*
      CHANGE REPORT for Table RENTALQTYADJUSTMENT
          - Adding column CANCELLATIONTIMESTAMP
          - Changing definition of index XAK1RENTALQTYADJUSTMENT
      ACTION is ALTER or modify Table RENTALQTYADJUSTMENT
      */

DROP INDEX XAK1RENTALQTYADJUSTMENT;


ALTER TABLE RENTALQTYADJUSTMENT ADD (CANCELLATIONTIMESTAMP DATE NULL);

CREATE UNIQUE INDEX XAK1RENTALQTYADJUSTMENT ON RENTALQTYADJUSTMENT
(
       PRODUCTLISTPERDISTRIBPOINT_ID  ASC,
       ADJUSTMENTDATE                 ASC,
       REASONCODE_ID                  ASC,
       CANCELLATIONTIMESTAMP          
);

