-- ABS-56106 / ABS-65187
--- PRICEUPDATEHISTORY ---
ALTER TABLE PRICEUPDATEHISTORY ADD (FINISHINGMETHOD_ID NUMBER NULL);

CREATE INDEX XIF8PRICEUPDATEHISTORY ON PRICEUPDATEHISTORY (FINISHINGMETHOD_ID ASC);

ALTER TABLE PRICEUPDATEHISTORY ADD CONSTRAINT PRICEUPDATEHISTORY_FMID FOREIGN KEY (FINISHINGMETHOD_ID)
REFERENCES FINISHINGMETHOD (FINISHINGMETHOD_ID) ON DELETE SET NULL;