     
      /*
      CHANGE REPORT for Table PRODUCT
          - Adding column WASHCOGTURNOVERGROUP_ID
          - Adding index XIF23PRODUCT
      ACTION is ALTER or modify Table PRODUCT
      */

ALTER TABLE PRODUCT ADD (WASHCOGTURNOVERGROUP_ID NUMBER NULL);

CREATE INDEX XIF23PRODUCT ON PRODUCT
(
       WASHCOGTURNOVERGROUP_ID        ASC
);

      
      /*
      CHANGE REPORT for Table PRODUCTGROUP
          - Adding column WASHCOGTURNOVERGROUP_ID
          - Adding index XIF9PRODUCTGROUP
      ACTION is ALTER or modify Table PRODUCTGROUP
      */

ALTER TABLE PRODUCTGROUP ADD (WASHCOGTURNOVERGROUP_ID NUMBER NULL);

CREATE INDEX XIF9PRODUCTGROUP ON PRODUCTGROUP
(
       WASHCOGTURNOVERGROUP_ID        ASC
);


ALTER TABLE PRODUCT
       ADD  ( CONSTRAINT PROD_WASHCOGTURNOVERGROUP_ID
              FOREIGN KEY (WASHCOGTURNOVERGROUP_ID)
                             REFERENCES TURNOVERGROUP ) ;


ALTER TABLE PRODUCTGROUP
       ADD  ( CONSTRAINT PRODGR_WASHCOGTURNOVERGROUP_ID
              FOREIGN KEY (WASHCOGTURNOVERGROUP_ID)
                             REFERENCES TURNOVERGROUP ) ;

