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

ALTER TABLE RENTALQTYADJUSTMENT ADD (SALESEMPLOYEE_ID     NUMBER NULL);

CREATE INDEX XIF5RENTALQTYADJUSTMENT ON RENTALQTYADJUSTMENT
(
       SALESEMPLOYEE_ID               ASC
);


ALTER TABLE RENTALQTYADJUSTMENT
       ADD  ( CONSTRAINT RENTQTYADJ_SALESEMPLOYEE_ID
              FOREIGN KEY (SALESEMPLOYEE_ID)
                             REFERENCES EMPLOYEE ) ;

