-- ABS-56106 / ABS-65187
--- PRICEUPDATEHISTORY ---
ALTER TABLE PRICEUPDATEHISTORY DROP CONSTRAINT PRICEUPDATEHISTORY_ABSLOGPROC;

ALTER TABLE PRICEUPDATEHISTORY DROP COLUMN ABSLOGPROCESSJOBLINE_ID;

ALTER TABLE PRICEUPDATEHISTORY ADD (ABSLOGPROCESSJOBPART_ID NUMBER NOT NULL);

CREATE UNIQUE INDEX XAK1PRICEUPDATEHISTORY ON PRICEUPDATEHISTORY (ABSLOGPROCESSJOBPART_ID ASC);

ALTER TABLE PRICEUPDATEHISTORY ADD CONSTRAINT PRICEUPDATEHISTORY_ABSLOGPROC FOREIGN KEY (ABSLOGPROCESSJOBPART_ID)
REFERENCES ABSLOGPROCESSJOBPART (ABSLOGPROCESSJOBPART_ID) ON DELETE CASCADE;