CREATE TRIGGER view_user_service_hw_insert instead of insert on view_user_service_hw
begin
    -- must be defined user_service_id and group_name
    select RAISE (ABORT,'Услуга не найдена')
      WHERE (select count(id) from user_service where id=NEW.user_service_id and delete_date IS NULL)= 0 ;

    select RAISE (ABORT,'Указанное оборудование уже подключено к услуге')
      WHERE (select count(id) from view_user_service_hw where user_service_id=NEW.user_service_id
 and group_name=cast(NEW.group_name as text) and delete_date IS NULL)> 0 ;

    insert into user_service_hw
      (user_service_id,hw_id)
    select
      NEW.user_service_id, id from hw_telephony_number where group_name=cast(NEW.group_name as text) and
        'telephony_number'=(select hw_name from view_user_service where id=NEW.user_service_id);

    insert into user_service_hw
      (user_service_id,hw_id)
    select
      NEW.user_service_id, id from hw_telephony_port where group_name=cast(NEW.group_name as text) and
        'telephony_port'=(select hw_name from view_user_service where id=NEW.user_service_id);

    ...
end;
CREATE TRIGGER view_user_service_insert instead of insert on view_user_service
begin
  insert into user_service (user_contract_id,service_id,note,is_active,is_main)
    values (NEW.user_contract_id,NEW.service_id,NEW.note,NEW.is_active,NEW.is_main);
end;
CREATE TRIGGER view_user_service_planner_delete instead of delete on view_user_service_planner
begin
  update user_service_planner set delete_date=julianday('now') where id=OLD.id and delete_date is null;
end;
CREATE TRIGGER view_user_service_planner_insert instead of insert on view_user_service_planner
begin
  insert into user_service_planner (user_service_id,action, date)
    values (NEW.user_service_id,NEW.action, NEW.date);
end;
CREATE TRIGGER view_user_service_planner_update instead of update on view_user_service_planner
begin
  update user_service_planner set
    user_service_id=NEW.user_service_id,
    action=NEW.action,
    date=NEW.date
  where id=OLD.id;
end;