Skip to main content

max / goingson

320 B · 7 lines History Blame Raw
1 -- Subtask task links: Allow subtasks to link to other tasks
2 -- This enables multi-phase features where Phase 2 is a full task linked as a subtask of Phase 1
3
4 ALTER TABLE subtasks ADD COLUMN linked_task_id TEXT REFERENCES tasks(id) ON DELETE SET NULL;
5
6 CREATE INDEX idx_subtasks_linked_task ON subtasks(linked_task_id);
7