Lines Matching full:not
2 id INTEGER NOT NULL PRIMARY KEY,
4 original_poster TEXT NOT NULL,
9 private BOOLEAN NOT NULL DEFAULT 0, -- 0 - public, 1 - private
10 lock BOOLEAN NOT NULL DEFAULT 0, -- 0 - unlocked, 1 - locked
12 type TEXT NOT NULL DEFAULT 'issue', -- issue, project
13 …state TEXT NOT NULL DEFAULT 'proposal', -- proposal,opened,done,closed,reject…
15 create_date TEXT NOT NULL, -- ISO8601
16 last_activity_date TEXT NOT NULL, -- ISO8601
17 last_modification_date TEXT NOT NULL, -- ISO8601
20 title TEXT NOT NULL,
21 content TEXT NOT NULL,
22 content_html TEXT NOT NULL,
24 task_count INTEGER NOT NULL DEFAULT 0,
25 task_count_closed INTEGER NOT NULL DEFAULT 0,
33 thread_id INTEGER NOT NULL REFERENCES thread (id),
34 user_id TEXT NOT NULL,
36 original_poster BOOLEAN NOT NULL DEFAULT 0,
37 coordinator BOOLEAN NOT NULL DEFAULT 0,
39 commentator BOOLEAN NOT NULL DEFAULT 0,
40 task_assignee BOOLEAN NOT NULL DEFAULT 0,
41 subscribent BOOLEAN NOT NULL DEFAULT 0,
43 …added_by TEXT NOT NULL, -- user who added the participant. Equals user_id when user subs…
44 added_date TEXT NOT NULL, -- ISO8601
50 id INTEGER NOT NULL PRIMARY KEY,
52 thread_id INTEGER NOT NULL REFERENCES thread (id),
54 …type TEXT NOT NULL DEFAULT 'comment', -- comment, cause_real, cause_potential --…
56 author TEXT NOT NULL,
57 create_date TEXT NOT NULL, -- ISO8601
58 last_modification_date TEXT NOT NULL, -- ISO8601
60 content TEXT NOT NULL,
61 content_html TEXT NOT NULL,
63 task_count INTEGER NOT NULL DEFAULT 0
77 id INTEGER NOT NULL PRIMARY KEY,
78 name TEXT UNIQUE NOT NULL,
80 count INTEGER NOT NULL DEFAULT 0,
82 added_by TEXT NOT NULL, -- user who added the label
83 added_date TEXT NOT NULL -- ISO8601
90 thread_id INTEGER NOT NULL,
91 label_id INTEGER NOT NULL,
127 id INTEGER NOT NULL PRIMARY KEY,
128 name TEXT UNIQUE NOT NULL,
129 count INTEGER NOT NULL DEFAULT 0,
131 added_by TEXT NOT NULL, -- user who added the label
132 added_date TEXT NOT NULL -- ISO8601
135 -- we cannot delete tasks (so not triggers provided)
137 id INTEGER NOT NULL PRIMARY KEY,
139 original_poster TEXT NOT NULL,
140 assignee TEXT NOT NULL,
143 private BOOLEAN NOT NULL DEFAULT 0, -- 0 - public, 1 - private
144 lock BOOLEAN NOT NULL DEFAULT 0, -- 0 - unlocked, 1 - locked
146 state TEXT NOT NULL DEFAULT 'opened', -- opened, done
147 …type TEXT NOT NULL DEFAULT 'correction', -- correction, corrective, preventiv…
149 create_date TEXT NOT NULL, -- ISO8601
150 last_activity_date TEXT NOT NULL, -- -- ISO8601
151 last_modification_date TEXT NOT NULL, -- ISO8601
155 plan_date TEXT NOT NULL, -- -- ISO8601
156 all_day_event INTEGER NOT NULL DEFAULT 0, -- 0 - false, 1 - true
160 content TEXT NOT NULL,
161 content_html TEXT NOT NULL,
177 WHEN new.thread_id IS NOT NULL
187 WHEN new.thread_id IS NOT NULL AND new.cost IS NOT NULL
209 WHEN old.cost IS NOT NULL
219 WHEN new.cost IS NOT NULL
319 task_id INTEGER NOT NULL REFERENCES thread (id),
320 user_id TEXT NOT NULL,
322 original_poster BOOLEAN NOT NULL DEFAULT 0,
323 assignee BOOLEAN NOT NULL DEFAULT 0,
325 commentator BOOLEAN NOT NULL DEFAULT 0,
326 subscribent BOOLEAN NOT NULL DEFAULT 0,
328 …added_by TEXT NOT NULL, -- user who added the participant. Equals user_id when user subs…
329 added_date TEXT NOT NULL, -- ISO8601
335 id INTEGER NOT NULL PRIMARY KEY,
337 task_id INTEGER NOT NULL REFERENCES task (id),
339 author TEXT NOT NULL,
340 create_date TEXT NOT NULL, -- ISO8601
341 last_modification_date TEXT NOT NULL, -- ISO8601
343 content TEXT NOT NULL,
344 content_html TEXT NOT NULL
348 page_id TEXT NOT NULL,
349 token TEXT NOT NULL,
351 generated_by TEXT NOT NULL,
352 generation_date TEXT NOT NULL,