  --i-test 1 for order 502422    
      /*
      CHANGE REPORT for Table ORLABELSPERWORKSTATION
          - Adding a new relationship ORLABELSPERWORKSTATION_FINISHI
          WARNING : Create FK statement may fail (existing data may violate the new FK rules: adding a new FK ORLABELSPERWORKSTATION_FINISHI of table ORLABELSPERWORKSTATION, which references table FINISHINGMETHOD).
          - Adding column FINISHINGMETHOD_ID
          - Adding index XIF4ORLABELSPERWORKSTATION
      ACTION is ALTER or modify Table ORLABELSPERWORKSTATION
      */

ALTER TABLE ORLABELSPERWORKSTATION ADD (FINISHINGMETHOD_ID   NUMBER NOT NULL);

CREATE INDEX XIF4ORLABELSPERWORKSTATION ON ORLABELSPERWORKSTATION
(
       FINISHINGMETHOD_ID             ASC
);

ALTER TABLE ORLABELSPERWORKSTATION DROP CONSTRAINT XPKORLABELSPERWORKSTATION;

ALTER TABLE ORLABELSPERWORKSTATION ADD ( CONSTRAINT XPKORLABELSPERWORKSTATION
					 PRIMARY KEY (WORKSTATION_ID, PRODUCT_ID, SIZEDEFINITION_ID, FINISHINGMETHOD_ID)
					);

ALTER TABLE ORLABELSPERWORKSTATION
       ADD  ( CONSTRAINT ORLABELSPERWORKSTATION_FINISHI
              FOREIGN KEY (FINISHINGMETHOD_ID)
                             REFERENCES FINISHINGMETHOD
                             ON DELETE CASCADE ) ;

