/*order 502459*/

ALTER TABLE ISSUEHISTORY
     ADD (WORKORDER_ID NUMBER NULL);

CREATE INDEX XIF17ISSUEHISTORY ON ISSUEHISTORY
(
       WORKORDER_ID                 ASC
);

ALTER TABLE ISSUEHISTORY
       ADD  ( CONSTRAINT ISSUEHISTORY_WORKORDER_ID
              FOREIGN KEY (WORKORDER_ID)
                             REFERENCES WORKORDER
                             ON DELETE SET NULL) ;