--ABS-53553 / ABS-55366
----------------------CLEANROOMBATCHPKBOXQTY----------------------
ALTER TABLE CLEANROOMBATCHPKBOXQTY ADD (CLEANROOMBATCHCUSTOMER_ID NUMBER NULL);

DROP INDEX XAK1CLEANROOMBATCHPKBOXQTY;
CREATE UNIQUE INDEX XAK1CLEANROOMBATCHPKBOXQTY 
ON CLEANROOMBATCHPKBOXQTY (CLEANROOMBATCHPKBOX_ID ASC, PRODUCT_LINK_ID ASC, FINISHINGMETHOD_ID ASC, NVL(CLEANROOMBATCHCUSTOMER_ID,0) ASC);

CREATE INDEX XIF5CLEANROOMBATCHPKBOXQTY ON CLEANROOMBATCHPKBOXQTY (CLEANROOMBATCHCUSTOMER_ID ASC);

ALTER TABLE CLEANROOMBATCHPKBOXQTY
  ADD CONSTRAINT CRBPKBOXQTY_CUSTOMER FOREIGN KEY (CLEANROOMBATCHCUSTOMER_ID)
  REFERENCES CLEANROOMBATCHCUSTOMER (CLEANROOMBATCHCUSTOMER_ID) ON DELETE CASCADE;
