max / goingson

404 B · 12 lines History Blame Raw

1	-- Subtasks for tasks (simple checkbox items) - SQLite
2	CREATE TABLE subtasks (
3	id TEXT PRIMARY KEY NOT NULL,
4	task_id TEXT NOT NULL REFERENCES tasks(id) ON DELETE CASCADE,
5	text TEXT NOT NULL,
6	is_completed INTEGER NOT NULL DEFAULT 0,
7	position INTEGER NOT NULL DEFAULT 0,
8	created_at TEXT NOT NULL DEFAULT (datetime('now'))
9	);
10
11	CREATE INDEX idx_subtasks_task_id ON subtasks(task_id);
12