multica/server/migrations/242_runtime_profile_add_qoderclicn.down.sql

-- Restore the pre-242 whitelist (with Qwen Code, without Qoder CN CLI).
-- NOT VALID keeps rollback compatible with historical rows the prior
-- migrations allowed.
ALTER TABLE runtime_profile DROP CONSTRAINT IF EXISTS runtime_profile_protocol_family_check;

ALTER TABLE runtime_profile ADD CONSTRAINT runtime_profile_protocol_family_check
    CHECK (protocol_family IN (
        'claude',
        'codebuddy',
        'codex',
        'copilot',
        'opencode',
        'openclaw',
        'hermes',
        'pi',
        'cursor',
        'kimi',
        'kiro',
        'antigravity',
        'qoder',
        'traecli',
        'deveco',
        'grok',
        'qwen'
    )) NOT VALID;