migrations/025_task_budgets_and_availability.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14

-- Opt-in time-budget visibility: a manual weekly availability template,
-- per-task time estimates, and a budget-tracked flag on projects/labels so
-- only tasks the user has opted in count against any budget calculation.
CREATE TABLE availability_blocks (
    id TEXT PRIMARY KEY,
    weekday INTEGER NOT NULL,      -- 0-6, Sun-Sat
    start_time TEXT NOT NULL,      -- "18:00"
    end_time TEXT NOT NULL,        -- "20:00"
    label TEXT DEFAULT ''
);

ALTER TABLE native_tasks ADD COLUMN estimated_minutes INTEGER DEFAULT 0;
ALTER TABLE projects ADD COLUMN budget_tracked BOOLEAN DEFAULT 0;
ALTER TABLE labels ADD COLUMN budget_tracked BOOLEAN DEFAULT 0;