-- ABS-83278 / ABS-89103

-- The content of this script has been commented because the Java part of this order was not committed in 9.03.04.

/*-------------CLEANCOUNTDELIVERY----------------------

ALTER TABLE CLEANCOUNTDELIVERY ADD (STERILIZATIONRUN_ID NUMBER NULL);

CREATE INDEX XIF8CLEANCOUNTDELIVERY ON CLEANCOUNTDELIVERY (STERILIZATIONRUN_ID ASC);

DROP INDEX XAK1CLEANCOUNTDELIVERY;

CREATE UNIQUE INDEX XAK1CLEANCOUNTDELIVERY ON CLEANCOUNTDELIVERY (DISTRIBUTIONPOINT_ID ASC, PRODUCT_ID ASC, SIZEDEFINITION_ID ASC, FINISHINGMETHOD_ID ASC, PACKINGNOTE_ID ASC, DELIVERYDATE ASC, WORKSTATION_ID ASC, CLEANROOMBATCH_ID ASC, NVL(STERILIZATIONRUN_ID,0) ASC );

ALTER TABLE CLEANCOUNTDELIVERY
  ADD CONSTRAINT CLEANCOUNTDELIVERY_STRRUN FOREIGN KEY (STERILIZATIONRUN_ID)
  REFERENCES STERILIZATIONRUN (STERILIZATIONRUN_ID);
  
------CLEANROOMBATCHCOUNTCONTENT-----------

DROP INDEX XAK1CLEANROOMBATCHCOUNTCONTENT;

CREATE UNIQUE INDEX XAK1CLEANROOMBATCHCOUNTCONTENT ON CLEANROOMBATCHCOUNTCONTENT (PRODUCT_LINK_ID  ASC, FINISHINGMETHOD_ID ASC, SIZEDEFINITION_LINK_ID ASC, CLEANROOMBATCHCUSTOMER_ID ASC, CUSTOMERCONTAINER ASC, NVL(STERILIZATIONRUN_ID,0) ASC);*/