Make makima more opinionated and structured

1 files changed, 13 insertions, 0 deletions

diff --git a/makima/migrations/20260202100000_add_contract_worktree.sql b/makima/migrations/20260202100000_add_contract_worktree.sql
new file mode 100644
index 0000000..26c54ba
--- /dev/null
+++ b/makima/migrations/20260202100000_add_contract_worktree.sql
@@ -0,0 +1,13 @@
+-- Add worktree tracking to contracts
+-- Each contract now has a single worktree managed by a specific daemon
+
+ALTER TABLE contracts
+    ADD COLUMN worktree_path VARCHAR(512),
+    ADD COLUMN worktree_daemon_id UUID REFERENCES daemons(id),
+    ADD COLUMN worktree_base_branch VARCHAR(255),
+    ADD COLUMN worktree_branch VARCHAR(255);
+
+COMMENT ON COLUMN contracts.worktree_path IS 'Path to the worktree directory on the assigned daemon';
+COMMENT ON COLUMN contracts.worktree_daemon_id IS 'The daemon that owns/manages this contract worktree';
+COMMENT ON COLUMN contracts.worktree_base_branch IS 'The base branch the worktree was created from';
+COMMENT ON COLUMN contracts.worktree_branch IS 'The working branch in the worktree';