diff options
Diffstat (limited to 'migrations')
| -rw-r--r-- | migrations/025_task_budgets_and_availability.sql | 14 |
1 files changed, 14 insertions, 0 deletions
diff --git a/migrations/025_task_budgets_and_availability.sql b/migrations/025_task_budgets_and_availability.sql new file mode 100644 index 0000000..3fd945d --- /dev/null +++ b/migrations/025_task_budgets_and_availability.sql @@ -0,0 +1,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; |