CREATE OR ALTER trigger orders_pay_ord_aiud0 for orders_pay_ord
active after insert or update or delete position 0
AS
begin
  /* Trigger text */
  if (inserting) then
   begin
     update orders
     set order_prepay = order_prepay + new.orders_pay_sum
     where id=new.orders_id;
   end
  if (updating) then
   begin
     update orders
     set order_prepay = order_prepay + new.orders_pay_sum
     where id=new.orders_id;

     update orders
     set order_prepay = order_prepay - old.orders_pay_sum
     where id=old.orders_id;
   end
  if (deleting) then
   begin
     update orders
     set order_prepay = order_prepay - old.orders_pay_sum
     where id=old.orders_id;
   end
end

CREATE OR ALTER trigger client_pay_sum_aiud1 for client_pay_sum
active after insert or update or delete position 2
AS
 declare variable o_id bigint;
begin
  /* Trigger text */
  if ((inserting)) then
   begin
     select o.id from owners o,mdoc m
     where m.owner_id=o.id and
     m.id = new.doc_id
       into :o_id;
     update owners
     set cash_sum=iif(cash_sum is null, 0, cash_sum)+ new.doc_sum
     where id=:o_id;
   end 
  if ((updating)) then
   begin
     select o.id from owners o,mdoc m
     where m.owner_id=o.id and
     m.id = new.doc_id
       into :o_id;
     update owners
     set cash_sum=iif(cash_sum is null, 0, cash_sum)+ new.doc_sum
     where id=:o_id;

     select o.id from owners o,mdoc m
     where m.owner_id=o.id and
     m.id= old.doc_id
       into :o_id;
     update owners
     set cash_sum=iif(cash_sum is null, 0, cash_sum) - old.doc_sum
     where id=:o_id;

   end
  if ((deleting)) then
   begin
     select o.id from owners o,mdoc m
     where m.owner_id=o.id and
     m.id= old.doc_id
       into :o_id;
     update owners
     set cash_sum=iif(cash_sum is null, 0, cash_sum) - old.doc_sum
     where id=:o_id;
   end
end