diff options
Diffstat (limited to 'makima/migrations/20250121000000_add_branched_from.sql')
| -rw-r--r-- | makima/migrations/20250121000000_add_branched_from.sql | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/makima/migrations/20250121000000_add_branched_from.sql b/makima/migrations/20250121000000_add_branched_from.sql new file mode 100644 index 0000000..bbb395b --- /dev/null +++ b/makima/migrations/20250121000000_add_branched_from.sql @@ -0,0 +1,10 @@ +-- Add branched_from_task_id column to tasks table for task branching support. +-- This allows creating new tasks that branch from an existing task's conversation, +-- enabling "what if" exploration of different approaches from the same starting point. + +ALTER TABLE tasks +ADD COLUMN IF NOT EXISTS branched_from_task_id UUID REFERENCES tasks(id) ON DELETE SET NULL; + +CREATE INDEX IF NOT EXISTS idx_tasks_branched_from ON tasks(branched_from_task_id); + +COMMENT ON COLUMN tasks.branched_from_task_id IS 'Source task ID when this task was branched from another task conversation'; |