diff options
Diffstat (limited to 'makima/migrations')
| -rw-r--r-- | makima/migrations/20250125000000_add_completed_deliverables.sql | 8 |
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); |