-- order 502815

      /*
      CHANGE REPORT for Table WEIGHINGCATEGORY
          - Adding a new relationship WGHCAT_MISPRODUCT_ID
          - Adding column MISPRODUCT_ID
          - Adding index XIF3WEIGHINGCATEGORY
      ACTION is ALTER or modify Table WEIGHINGCATEGORY
      */

ALTER TABLE WEIGHINGCATEGORY ADD (MISPRODUCT_ID        NUMBER NULL);

CREATE INDEX XIF3WEIGHINGCATEGORY ON WEIGHINGCATEGORY
(
       MISPRODUCT_ID                  ASC
);


ALTER TABLE WEIGHINGCATEGORY
       ADD  ( CONSTRAINT WGHCAT_MISPRODUCT_ID
              FOREIGN KEY (MISPRODUCT_ID)
                             REFERENCES PRODUCT ) ;

