summaryrefslogtreecommitdiff
path: root/migrations/019_add_google_tasks.sql
diff options
context:
space:
mode:
authorPeter Stone <thepeterstone@gmail.com>2026-03-23 08:13:02 +0000
committerPeter Stone <thepeterstone@gmail.com>2026-03-23 08:13:02 +0000
commitb2d8fc460be3105ac383098e7cdc92171e5026ec (patch)
treecd5ba3f3008e6b3310680d785880f1f32ed090c5 /migrations/019_add_google_tasks.sql
parentb0688c8819da1b7fcb4a97b6ec1fa58050e4841e (diff)
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
Diffstat (limited to 'migrations/019_add_google_tasks.sql')
-rw-r--r--migrations/019_add_google_tasks.sql15
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);