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;