Phase 1.1: Add local_only flag to contracts

1 files changed, 7 insertions, 0 deletions

diff --git a/makima/migrations/20260126000000_add_local_only_mode.sql b/makima/migrations/20260126000000_add_local_only_mode.sql
new file mode 100644
index 0000000..27af087
--- /dev/null
+++ b/makima/migrations/20260126000000_add_local_only_mode.sql
@@ -0,0 +1,7 @@
+-- Add local_only column to contracts
+ALTER TABLE contracts ADD COLUMN local_only BOOLEAN NOT NULL DEFAULT false;
+
+-- Index for filtering by local_only mode
+CREATE INDEX idx_contracts_local_only ON contracts(local_only) WHERE local_only = true;
+
+COMMENT ON COLUMN contracts.local_only IS 'When true, tasks do not auto-execute completion actions and work stays in worktrees';