migrations/020_native_tasks.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17

-- Native tasks table: doot-owned task storage, not a sync cache.
-- Populated by importing from Todoist, then managed entirely within doot.
CREATE TABLE IF NOT EXISTS native_tasks (
    id TEXT PRIMARY KEY,
    content TEXT NOT NULL,
    description TEXT DEFAULT '',
    project_name TEXT DEFAULT '',
    due_date DATETIME,
    priority INTEGER DEFAULT 1,
    completed BOOLEAN DEFAULT 0,
    labels TEXT DEFAULT '[]',
    created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
    updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
);

CREATE INDEX IF NOT EXISTS idx_native_tasks_due_date ON native_tasks(due_date);
CREATE INDEX IF NOT EXISTS idx_native_tasks_completed ON native_tasks(completed);