CREATE OR REPLACE TRIGGER Trigger_RoundBatalla
BEFORE UPDATE
ON ROUND
FOR EACH ROW
BEGIN
IF(:new.ptsvida_heroe<=0) THEN
insert into batalla values(id_batalla,id_heroe,id_villano,nombreballata,id_villano);
END IF;
IF(:new.ptsvida_villano<=0) THEN
insert into batalla values(id_batalla,id_heroe,id_villano,nombreballata,id_heroe);
END IF;
END Trigger_RoundBatalla;