-- Add phase_guard column to contracts table
-- When enabled, the supervisor will wait for user confirmation before progressing to the next phase.
-- This allows users to review and potentially amend phase outputs (plans, requirements, etc.)
-- before the contract continues to the next phase.

ALTER TABLE contracts
ADD COLUMN IF NOT EXISTS phase_guard BOOLEAN NOT NULL DEFAULT FALSE;

COMMENT ON COLUMN contracts.phase_guard IS 'Whether to wait for user confirmation before progressing to the next phase';