1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
|
-- Cache metadata table for tracking API fetch times and TTL
CREATE TABLE IF NOT EXISTS cache_metadata (
key TEXT PRIMARY KEY,
last_fetch DATETIME NOT NULL,
ttl_minutes INTEGER NOT NULL DEFAULT 5,
updated_at DATETIME DEFAULT CURRENT_TIMESTAMP
);
-- Pre-populate with cache keys
INSERT OR IGNORE INTO cache_metadata (key, last_fetch, ttl_minutes) VALUES
('todoist_tasks', '2000-01-01 00:00:00', 5),
('todoist_projects', '2000-01-01 00:00:00', 5),
('obsidian_notes', '2000-01-01 00:00:00', 5),
('plantoeat_meals', '2000-01-01 00:00:00', 5),
('trello_boards', '2000-01-01 00:00:00', 5),
('trello_cards', '2000-01-01 00:00:00', 5);
|
