From b2d8fc460be3105ac383098e7cdc92171e5026ec Mon Sep 17 00:00:00 2001
From: Peter Stone <thepeterstone@gmail.com>
Date: Mon, 23 Mar 2026 08:13:02 +0000
Subject: feat: unify Google Tasks with main system via caching and integrated
 UI

- Implement SQLite caching layer for Google Tasks
- Integrate Google Tasks into unified Atoms loop (showing in Tasks tab)
- Update Planning tab to include cached Google Tasks
- Enhance Quick Add form with Todoist project selector
- Remove orphaned HandleTasksTab/HandleRefreshTab methods
- Update tests to reflect new BuildTimeline signature and data structures
---
 migrations/019_add_google_tasks.sql | 15 +++++++++++++++
 1 file changed, 15 insertions(+)
 create mode 100644 migrations/019_add_google_tasks.sql

(limited to 'migrations/019_add_google_tasks.sql')

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);
-- 
cgit v1.2.3

