--order 502788
      
      /*
      CHANGE REPORT for Table ARTRANSACTION
          - Adding relation ARTRANSACTION_ARTRANSACTION_ID
          - Adding column ORIGINALTRANSACTION_ID
          - Adding index XIF20ARTRANSACTION
      ACTION is ALTER or modify Table ARTRANSACTION
      */

ALTER TABLE ARTRANSACTION ADD (ORIGINALTRANSACTION_ID NUMBER NULL);

CREATE INDEX XIF20ARTRANSACTION ON ARTRANSACTION
(
       ORIGINALTRANSACTION_ID    ASC
);


ALTER TABLE ARTRANSACTION
       ADD  ( CONSTRAINT ARTRANSACTION_ARTRANSACTION_ID
              FOREIGN KEY (ORIGINALTRANSACTION_ID)
                             REFERENCES ARTRANSACTION
                             ON DELETE CASCADE ) ;

