Trigger

CREATE OR REPLACE TRIGGER trest_min AFTER INSERT OR UPDATE ON TypUdalosti
    FOR EACH ROW BEGIN
        UPDATE Hrac SET TrestneMinuty = TrestneMinuty + NEW.trest
            WHERE Jmeno = NEW.H_jmeno AND Prijmeni = NEW.H_prijmeni AND cislo = NEW.H_cislo;
    END;