1
2
3
4
5
6
7
8
9
10
11
12
13
|
-- Source configuration for selecting which items to fetch
CREATE TABLE IF NOT EXISTS source_config (
id INTEGER PRIMARY KEY AUTOINCREMENT,
source TEXT NOT NULL, -- 'trello', 'todoist', 'gcal', 'gtasks'
item_type TEXT NOT NULL, -- 'board', 'project', 'calendar', 'tasklist'
item_id TEXT NOT NULL, -- ID from the source
item_name TEXT NOT NULL, -- Display name
enabled INTEGER NOT NULL DEFAULT 1,
updated_at TEXT NOT NULL DEFAULT (datetime('now', 'localtime')),
UNIQUE(source, item_type, item_id)
);
CREATE INDEX IF NOT EXISTS idx_source_config_source ON source_config(source, enabled);
|
