Fix worktree cleanup to not run for shared worktrees

1 files changed, 7 insertions, 0 deletions

diff --git a/makima/migrations/20260129000000_add_supervisor_worktree_task_id.sql b/makima/migrations/20260129000000_add_supervisor_worktree_task_id.sql
new file mode 100644
index 0000000..974644c
--- /dev/null
+++ b/makima/migrations/20260129000000_add_supervisor_worktree_task_id.sql
@@ -0,0 +1,7 @@
+-- Add supervisor_worktree_task_id column to tasks table.
+-- When set, indicates this task shares the worktree of the specified supervisor task
+-- and should NOT have its worktree deleted during cleanup (the supervisor owns the worktree).
+ALTER TABLE tasks ADD COLUMN supervisor_worktree_task_id UUID REFERENCES tasks(id) ON DELETE SET NULL;
+
+-- Create index for efficient lookups
+CREATE INDEX idx_tasks_supervisor_worktree_task_id ON tasks(supervisor_worktree_task_id) WHERE supervisor_worktree_task_id IS NOT NULL;