1 files changed, 17 insertions, 0 deletions
diff --git a/migrations/020_native_tasks.sql b/migrations/020_native_tasks.sql
new file mode 100644
index 0000000..9abf3ad
--- /dev/null
+++ b/migrations/020_native_tasks.sql
@@ -0,0 +1,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);