1CREATE TRIGGER task_tr_delete
2  DELETE ON task
3BEGIN
4  UPDATE thread
5  SET task_count = task_count - 1
6  WHERE id = old.thread_id;
7
8  UPDATE thread
9  SET task_sum_cost = task_sum_cost - coalesce(old.cost, 0)
10  WHERE id = old.thread_id;
11
12  DELETE FROM task_comment WHERE task_id=old.id;
13END;
14
15CREATE TRIGGER task_tr_delete_state_done
16  DELETE ON task
17  WHEN old.state = 'done'
18BEGIN
19  UPDATE thread
20  SET task_count_closed = task_count_closed - 1
21  WHERE id = old.thread_id;
22END;