Lines Matching refs:thread

1 CREATE TABLE thread (
6   closed_by              TEXT    NULL, -- who closed or rejected the thread
30   ON thread (last_activity_date); -- to speedup order by
33   thread_id       INTEGER NOT NULL REFERENCES thread (id),
52   thread_id              INTEGER NOT NULL REFERENCES thread (id),
69       thread.coordinator AS coordinator
71       JOIN thread ON thread_comment.thread_id = thread.id;
163   thread_id              INTEGER REFERENCES thread (id), --may be null
179   UPDATE thread
189   UPDATE thread
198   UPDATE thread
201   UPDATE thread
211   UPDATE thread
221   UPDATE thread
231   UPDATE thread
241   UPDATE thread
251   UPDATE thread
254   UPDATE thread
319   task_id       INTEGER NOT NULL REFERENCES thread (id),
363       thread.coordinator AS coordinator,
370       LEFT JOIN thread ON task.thread_id = thread.id;
374     SELECT thread.id, thread.original_poster, thread.coordinator, thread.closed_by,
375       thread.private, thread.lock, thread.type,
376       thread.create_date, thread.last_activity_date, thread.last_modification_date, thread.close_date,
377       thread.title, thread.content, thread.content_html,
378       thread.task_count, thread.task_count_closed, thread.task_sum_cost,
381       (SELECT MIN(priority) FROM task_view WHERE task_view.thread_id = thread.id) AS priority,
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
384     FROM thread
385       LEFT JOIN thread_label ON thread.id = thread_label.thread_id