CREATE TRIGGER "order_history" after update order  1  on DBA.orders
referencing old as old_name new as new_name
for each row 
begin
  if(new_name.car_send_id <> old_name.car_send_id) then
  begin
    select cities_list.id,cities_list.city_name as city 
     from orders 
     key join cars 
     join cities_list on cities_list.id = cars.city_id
     where orders.id = new_name.id  

       if new_name.city_id = cities_list.id then
        insert into "history" (ord_id, "action") values (new_name.id, 'Приехали');
      else 
        insert into "history" (ord_id, "action") values (new_name.id, city);	
     end if
  end  if
end

if new_name.city_id = cities_list.id then
         insert into "history" (ord_id, "action") values (new_name.id, 
'Приехали');
       else
         insert into "history" (ord_id, "action") values (new_name.id, 
city);	
      end if