4 lines
220 B
SQL
4 lines
220 B
SQL
ALTER TABLE tasks ADD COLUMN parent_task_id TEXT NOT NULL DEFAULT '';
|
|
ALTER TABLE tasks ADD COLUMN parent_merge_by TEXT NOT NULL DEFAULT '';
|
|
CREATE INDEX tasks_parent ON tasks(parent_task_id) WHERE parent_task_id != '';
|