-- Add red team configuration to contracts
ALTER TABLE contracts
ADD COLUMN red_team_enabled BOOLEAN NOT NULL DEFAULT FALSE,
ADD COLUMN red_team_prompt TEXT;

COMMENT ON COLUMN contracts.red_team_enabled IS 'Whether to spawn a red team task to monitor work tasks';
COMMENT ON COLUMN contracts.red_team_prompt IS 'Custom criteria for the red team to evaluate';