-- ABS-63422/ ABS-64034

--- EMBLEMHISTORY table ---
ALTER TABLE EMBLEMHISTORY
  DROP CONSTRAINT EMBLEMHISTORY_ISSUEHISTORY_ID;
  
ALTER TABLE EMBLEMHISTORY
  ADD CONSTRAINT EMBLEMHISTORY_ISSUEHISTORY_ID FOREIGN KEY (ISSUEHISTORY_ID)
  REFERENCES ISSUEHISTORY (ISSUEHISTORY_ID) ON DELETE SET NULL;

--- CONTACT table ---
ALTER TABLE CONTACT
  DROP CONSTRAINT CONTACT_STOP_ID;
  
ALTER TABLE CONTACT
  ADD CONSTRAINT CONTACT_STOP_ID FOREIGN KEY (STOP_ID)
  REFERENCES STOP (STOP_ID) ON DELETE SET NULL;
