migrations/019_add_google_tasks.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
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);