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