-- order 502698 (analysis changed)

DROP INDEX XIF7REPAIRHISTORY;

      
      /*
      CHANGE REPORT for Table REPAIRHISTORY
      ACTION is ALTER or modify Table REPAIRHISTORY
      IMPACT ANALYSIS REPORT for ALTER or modify Table REPAIRHISTORY
          - index XIF7REPAIRHISTORY needs to be removed in order to proceed. 
      */

ALTER TABLE REPAIRHISTORY MODIFY (PRODUCT_LINK_ID NULL);

CREATE INDEX XIF7REPAIRHISTORY ON REPAIRHISTORY
(
       PRODUCT_LINK_ID                ASC
);

