/*order 502368*/      

      /*
      CHANGE REPORT for Table WEBSERVICETRANSACTION
          - Adding a new relationship WEBSERVICETRANSACTION_SCAN_ID
          WARNING : Create FK statement may fail (existing data may violate the new FK rules: adding a new FK WEBSERVICETRANSACTION_SCAN_ID of table WEBSERVICETRANSACTION, which references table SCAN).
          - Adding column SCAN_ID
      ACTION is ALTER or modify Table WEBSERVICETRANSACTION
      */

ALTER TABLE WEBSERVICETRANSACTION ADD (SCAN_ID              NUMBER NULL);

CREATE INDEX XIF1WEBSERVICETRANSA ON WEBSERVICETRANSACTION
(
       SCAN_ID  ASC
);

ALTER TABLE WEBSERVICETRANSACTION
       ADD  ( CONSTRAINT WEBSERVICETRANSACTION_SCAN_ID
              FOREIGN KEY (SCAN_ID)
                             REFERENCES SCAN ON DELETE SET NULL) ;

