--order 502641      
      /*
      CHANGE REPORT for Table UNIQUEITEM
          - Changing column definition of POOLITEM
      ACTION is ALTER or modify Table UNIQUEITEM
      */

COMMENT ON COLUMN UNIQUEITEM.POOLITEM IS '0 = Stock
1 = Pool
2 = Non Pool
3 = OR Pack';

      
      /*
      CHANGE REPORT for Table UNIQUEITEMFIXEDINFO
          - Adding a new relationship UNIQUEITEMFIXEDINFO_REWASHEMPL
          WARNING : Create FK statement may fail (existing data may violate the new FK rules: adding a new FK UNIQUEITEMFIXEDINFO_REWASHEMPL of table UNIQUEITEMFIXEDINFO, which references table EMPLOYEE).
          - Adding column REWASHEMPLOYEE_ID
          - Adding index XIF8UNIQUEITEMFIXEDINFO
      ACTION is ALTER or modify Table UNIQUEITEMFIXEDINFO
      */

ALTER TABLE UNIQUEITEMFIXEDINFO ADD (REWASHEMPLOYEE_ID    NUMBER NULL);

CREATE INDEX XIF8UNIQUEITEMFIXEDINFO ON UNIQUEITEMFIXEDINFO
(
       REWASHEMPLOYEE_ID              ASC
);

      
      /*
      CHANGE REPORT for Table UNIQUEITEMFLAG
          - Adding a new relationship UNIQUEITEMFLAG_TREATMENTTYPE_I
          WARNING : Create FK statement may fail (existing data may violate the new FK rules: adding a new FK UNIQUEITEMFLAG_TREATMENTTYPE_I of table UNIQUEITEMFLAG, which references table E/318).
          - Adding column TREATMENTTYPE_ID
          - Adding index XIF3UNIQUEITEMFLAG
      ACTION is ALTER or modify Table UNIQUEITEMFLAG
      */

ALTER TABLE UNIQUEITEMFLAG ADD (TREATMENTTYPE_ID     NUMBER NULL);

CREATE INDEX XIF3UNIQUEITEMFLAG ON UNIQUEITEMFLAG
(
       TREATMENTTYPE_ID               ASC
);


ALTER TABLE UNIQUEITEMFIXEDINFO
       ADD  ( CONSTRAINT UNIQUEITEMFIXEDINFO_REWASHEMPL
              FOREIGN KEY (REWASHEMPLOYEE_ID)
                             REFERENCES EMPLOYEE ) ;


ALTER TABLE UNIQUEITEMFLAG
       ADD  ( CONSTRAINT UNIQUEITEMFLAG_TREATMENTTYPE_I
              FOREIGN KEY (TREATMENTTYPE_ID)
                             REFERENCES TREATMENTTYPE ) ;

