-- ABS-47292/ ABS-114625

DROP INDEX XIF1CUSTOMERCONTAINERRENTPRICE;

ALTER TABLE CUSTOMERCONTAINERRENTPRICE
  DROP CONSTRAINT FK_CUSTOMERCONTRENTPRICE_CBC;

ALTER TABLE CUSTOMERCONTAINERRENTPRICE RENAME COLUMN CUSTOMERBILLPERCONTAINER_ID TO CONTAINERBILLPERCUSTOMER_ID;

CREATE INDEX XIF1CUSTOMERCONTAINERRENTPRICE ON CUSTOMERCONTAINERRENTPRICE (CONTAINERBILLPERCUSTOMER_ID ASC);

ALTER TABLE CUSTOMERCONTAINERRENTPRICE
  ADD CONSTRAINT FK_CUSTOMERCONTRENTPRICE_CBC FOREIGN KEY (CONTAINERBILLPERCUSTOMER_ID)
  REFERENCES CONTAINERBILLPERCUSTOMER (CONTAINERBILLPERCUSTOMER_ID) ON DELETE CASCADE;