Lines Matching refs:state
13 state TEXT NOT NULL DEFAULT 'proposal', -- proposal,opened,done,closed,rejected
146 state TEXT NOT NULL DEFAULT 'opened', -- opened, done
227 UPDATE OF thread_id, state
229 WHEN old.state = 'opened' AND new.state = 'done'
237 UPDATE OF thread_id, state
239 WHEN old.state = 'done' AND new.state = 'opened'
247 UPDATE OF thread_id, state
249 WHEN old.state = 'done' AND new.state = 'done'
364 CASE WHEN task.state = 'done' THEN NULL
382 CASE WHEN thread.state = 'opened' AND thread.task_count > 0 AND thread.task_count = thread.task_count_closed THEN 'done'
383 ELSE thread.state END AS state