/*ORDER 502299*/      
      /*
      CHANGE REPORT for Table CUSTOMERRENTPRICE
          - Changing definition of index XAK1CUSTOMERRENTPRICE
      ACTION is ALTER or modify Table CUSTOMERRENTPRICE
      */

DROP INDEX XAK1CUSTOMERRENTPRICE;

      
      /*
      CHANGE REPORT for Table GENERALRENTPRICE
          - Changing definition of index XAK1GENERALRENTPRICE
      ACTION is ALTER or modify Table GENERALRENTPRICE
      */

DROP INDEX XAK1GENERALRENTPRICE;

CREATE UNIQUE INDEX XAK1CUSTOMERRENTPRICE ON CUSTOMERRENTPRICE
(
       PRODUCTLISTPERCUSTOMER_ID      ASC,
       STARTDATE                      ASC,
       CHANGESPERWEEK                 ASC,
       TYPEOFRENT                    ASC ,
       INVOICEFREQUENCYNUMBER         
);

CREATE UNIQUE INDEX XAK1GENERALRENTPRICE ON GENERALRENTPRICE
(
       GENERALPRICELIST_ID            ASC,
       PRODUCT_ID                     ASC,
       SIZEDEFINITION_ID              ASC,
       FINISHINGMETHOD_ID             ASC,
       TYPEOFRENT                     ASC,
       STARTDATE                      ASC,
       CHANGESPERWEEK                 ASC,
       INVOICEFREQUENCYNUMBER         
);

