1 files changed, 15 insertions, 0 deletions
diff --git a/migrations/019_add_google_tasks.sql b/migrations/019_add_google_tasks.sql
new file mode 100644
index 0000000..70f5980
--- /dev/null
+++ b/migrations/019_add_google_tasks.sql
@@ -0,0 +1,15 @@
+-- Google Tasks cache table
+CREATE TABLE IF NOT EXISTS google_tasks (
+    id TEXT PRIMARY KEY,
+    title TEXT NOT NULL,
+    notes TEXT,
+    status TEXT NOT NULL,
+    completed BOOLEAN NOT NULL DEFAULT 0,
+    due_date TEXT,
+    updated_at TEXT,
+    list_id TEXT NOT NULL,
+    url TEXT
+);
+
+CREATE INDEX IF NOT EXISTS idx_google_tasks_due_date ON google_tasks(due_date);
+CREATE INDEX IF NOT EXISTS idx_google_tasks_list_id ON google_tasks(list_id);