Add completion phases

1 files changed, 8 insertions, 0 deletions

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);