From 04e1e8f0dd85d19917ac5ba0b73cba65ebac8976 Mon Sep 17 00:00:00 2001
From: soryu <soryu@soryu.co>
Date: Mon, 26 Jan 2026 20:19:30 +0000
Subject: Add completion phases

---
 makima/migrations/20250125000000_add_completed_deliverables.sql | 8 ++++++++
 1 file changed, 8 insertions(+)
 create mode 100644 makima/migrations/20250125000000_add_completed_deliverables.sql

(limited to 'makima/migrations/20250125000000_add_completed_deliverables.sql')

diff --git a/makima/migrations/20250125000000_add_completed_deliverables.sql b/makima/migrations/20250125000000_add_completed_deliverables.sql
new file mode 100644
index 0000000..662a2bd
--- /dev/null
+++ b/makima/migrations/20250125000000_add_completed_deliverables.sql
@@ -0,0 +1,8 @@
+-- Add completed_deliverables column to track which phase deliverables have been marked complete
+-- Structure: { "plan": ["plan-document"], "execute": ["pull-request"] }
+
+ALTER TABLE contracts
+ADD COLUMN completed_deliverables JSONB NOT NULL DEFAULT '{}';
+
+-- Add index for efficient querying
+CREATE INDEX idx_contracts_completed_deliverables ON contracts USING gin (completed_deliverables);
-- 
cgit v1.2.3

