Skip to main content

max / goingson

361 B · 8 lines History Blame Raw
1 -- Add recurrence tracking columns to tasks table (SQLite)
2 -- recurrence_parent_id: Links to the original recurring task (for history)
3
4 ALTER TABLE tasks ADD COLUMN recurrence_parent_id TEXT REFERENCES tasks(id) ON DELETE SET NULL;
5
6 -- Index for finding child tasks of a recurring parent
7 CREATE INDEX idx_tasks_recurrence_parent ON tasks(recurrence_parent_id);
8