-- ABS-39817/ 46061

COMMENT ON COLUMN CUSTOMERRENTDISCOUNT.TYPEOFRENT
  IS '1=Piece price
2=Changes per week
3 = Overuse price
4 = Per Frequency
5 = Underuse Price
6 = Lease
7 = Split price
8 = Per Invoice Frequency
9 = Residential rent (not used)
10 = Loan';

DROP INDEX XAK1CUSTOMERRENTDISCOUNT;
CREATE UNIQUE INDEX XAK1CUSTOMERRENTDISCOUNT ON CUSTOMERRENTDISCOUNT (PRODUCTLISTPERCUSTOMER_ID ASC, STARTDATE ASC, TYPEOFRENT ASC);