DELIMITER |
CREATE TRIGGER vloz AFTER INSERT ON historie FOR EACH ROW BEGIN
  INSERT INTO penezenka (ID_transakce,castka,ID_uzivatele) VALUES 
	 (NEW.ID_transakce, NEW.cena*(-1), NEW.ID_kupce);
INSERT INTO penezenka (ID_transakce,castka,ID_uzivatele) VALUES
	 (NEW.ID_transakce, NEW.cena, NEW.ID_prodejce);
END;
|
DELIMITER ;

