max / goingson

758 B · 19 lines History Blame Raw

1	-- Weekly review completion tracking
2	CREATE TABLE IF NOT EXISTS weekly_reviews (
3	id TEXT PRIMARY KEY NOT NULL,
4	user_id TEXT NOT NULL,
5	week_start_date TEXT NOT NULL, -- ISO week Monday (YYYY-MM-DD)
6	completed_at TEXT NOT NULL DEFAULT (datetime('now')),
7	notes TEXT NOT NULL DEFAULT '',
8	UNIQUE(user_id, week_start_date),
9	FOREIGN KEY (user_id) REFERENCES users(id)
10	);
11
12	CREATE INDEX IF NOT EXISTS idx_weekly_reviews_user_week ON weekly_reviews(user_id, week_start_date);
13
14	-- Add focus field to tasks (projects derived from focused tasks)
15	ALTER TABLE tasks ADD COLUMN is_focus INTEGER NOT NULL DEFAULT 0;
16	ALTER TABLE tasks ADD COLUMN focus_set_at TEXT;
17
18	CREATE INDEX IF NOT EXISTS idx_tasks_focus ON tasks(is_focus) WHERE is_focus = 1;
19