-- Add contract_id to directive_steps for contract-backed execution ALTER TABLE directive_steps ADD COLUMN contract_id UUID REFERENCES contracts(id); -- Add contract_type to specify what kind of contract to create ALTER TABLE directive_steps ADD COLUMN contract_type VARCHAR(32);