Russian Qt Forum

create trigger insertIntoZayavky after insert on zayavky_zamovnykiv for each row 
begin
insert into zayavky set zayavky.Zajavka_num_zamovnyk = new.id,zayavky.Zamovnyky_id = new.Zamovnyky_id, zayavky.Countrys_id = 1;
insert into zayavky set zayavky.Zajavka_num_zamovnyk = new.id,zayavky.Zamovnyky_id = new.Zamovnyky_id, zayavky.Countrys_id = 2;
end;

create trigger deleteFromZayavky after delete on zayavky_zamovnykiv for each row 
begin
delete from zayavky where zayavky.Zajavka_num_zamovnyk = old.id;
end;

create trigger updateInZayavky after update on zayavky_zamovnykiv for each row
begin
update zayavky set zayavky.Zajavka_num_zamovnyk = new.id,zayavky.Zamovnyky_id = new.Zamovnyky_id,zayavky.valuta_id = new.valuta_id where zayavky.Zajavka_num_zamovnyk = old.id;
end;