--order 502559      
      /*
      CHANGE REPORT for Table ABSLOGPROCESSJOB
          - Adding column MOBILEDEVICE_ID
          - Adding column definition to MOBILEDEVICE_ID
          - Adding index XIF5ABSLOGPROCESSJOB
          - Adding a new relationship ABSLOGPROCESSJOB_MOBILEDEVICE_
          WARNING : Create FK statement may fail (existing data may violate the new FK rules: adding a new FK ABSLOGPROCESSJOB_MOBILEDEVICE_ of table ABSLOGPROCESSJOB, which references table MOBILEDEVICE).
      ACTION is ALTER or modify Table ABSLOGPROCESSJOB
      */

ALTER TABLE ABSLOGPROCESSJOB ADD (MOBILEDEVICE_ID      NUMBER NULL);


COMMENT ON COLUMN ABSLOGPROCESSJOB.MOBILEDEVICE_ID IS 'Filled only in case of PDA import';

CREATE INDEX XIF5ABSLOGPROCESSJOB ON ABSLOGPROCESSJOB
(
       MOBILEDEVICE_ID                ASC
);


ALTER TABLE ABSLOGPROCESSJOB
       ADD (CONSTRAINT ABSLOGPROCESSJOB_MOBILEDEVICE_
              FOREIGN KEY (MOBILEDEVICE_ID)
                             REFERENCES MOBILEDEVICE  (MOBILEDEVICE_ID));

