  /*order 502045*/    
      /*
      CHANGE REPORT for Table STATUSQUOHEADER
          - Adding a new relationship STATUSQUOHEADER_ABSLOGPROCESSJ
          WARNING : Create FK statement may fail (existing data may violate the new FK rules: adding a new FK STATUSQUOHEADER_ABSLOGPROCESSJ of table STATUSQUOHEADER, which references table ABSLOGPROCESSJOB).
          - Adding column ABSLOGPROCESSJOB_ID
          - Adding index XIF3STATUSQUOHEADER
      ACTION is ALTER or modify Table STATUSQUOHEADER
      */

DROP INDEX XIF5ABSLOGPROCESSJOB ;

ALTER TABLE ABSLOGPROCESSJOB DROP CONSTRAINT ABSLOGPROCESSJOB_STATUSQUOHEAD ;

ALTER TABLE ABSLOGPROCESSJOB DROP COLUMN STATUSQUOHEADER_ID;

ALTER TABLE STATUSQUOHEADER ADD (ABSLOGPROCESSJOB_ID  NUMBER NULL);

CREATE INDEX XIF3STATUSQUOHEADER ON STATUSQUOHEADER
(
       ABSLOGPROCESSJOB_ID            ASC
);


ALTER TABLE STATUSQUOHEADER
       ADD  ( CONSTRAINT STATUSQUOHEADER_ABSLOGPROCESSJ
              FOREIGN KEY (ABSLOGPROCESSJOB_ID)
                             REFERENCES ABSLOGPROCESSJOB 
                             ON DELETE SET NULL) ;

