connect test;

drop trigger delhasmedrecs;
drop trigger delmedrecs;

delimiter $$

create trigger delhasmedrecs before delete on has_medical_records
FOR EACH ROW BEGIN
 insert into del_has_medical_records set pacctid = OLD.pacctid, rid = OLD.rid;
END$$

delimiter @@

create trigger delmedrecs before delete on medical_records
FOR EACH ROW BEGIN
 insert into del_medical_records set rid = OLD.rid, rdatetime = OLD.rdatetime, entrytype = OLD.entrytype, entrydesc = OLD.entrydesc, entrysourceid = OLD.entrysourceid;
END@@