Skip to main content

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