-- OpenRouter model allowlist seed
--
-- USAGE: sqlite3 router.db < config/allowlist-openrouter.sql
--
-- Idempotent: INSERT OR IGNORE against primary key (provider, model_id).
-- Re-running is safe — existing rows are left untouched.
--
-- Curated from the live OpenRouter catalog (web-researched Sept 2026),
-- verifying each model exists and is routable. No x-ai / openai / anthropic
-- vendor paths included.

INSERT OR IGNORE INTO provider_model_allowlist (provider, model_id, added_at, note) VALUES
    ('openrouter', 'mistralai/codestral-2508',   datetime('now'), 'Dedicated coding model'),
    ('openrouter', 'mistralai/devstral-2512',    datetime('now'), 'Dedicated coding model'),
    ('openrouter', 'qwen/qwen3-coder',           datetime('now'), 'Coding / general'),
    ('openrouter', 'qwen/qwen3-coder-plus',      datetime('now'), 'Coding / general'),
    ('openrouter', 'qwen/qwen3-coder-flash',     datetime('now'), 'Coding / general'),
    ('openrouter', 'qwen/qwen3-coder-next',      datetime('now'), 'Coding / general'),
    ('openrouter', 'moonshotai/kimi-k2.7-code',  datetime('now'), 'Frontier coding'),
    ('openrouter', 'z-ai/glm-5.3',               datetime('now'), 'Cost workhorse, NeuralWatt compare'),
    ('openrouter', 'moonshotai/kimi-k3',         datetime('now'), 'Frontier coding'),
    ('openrouter', 'qwen/qwen3-max-thinking',    datetime('now'), 'Reasoning / general'),
    ('openrouter', 'google/gemini-3.1-pro-preview', datetime('now'), 'Google general/vision'),
    ('openrouter', 'deepseek/deepseek-v4-flash', datetime('now'), 'Reasoning / cheap frontier'),
    ('openrouter', 'deepseek/deepseek-v4-pro',   datetime('now'), 'Reasoning / cheap frontier'),
    ('openrouter', 'z-ai/glm-5.3-flash',         datetime('now'), 'Fast workhorse, NeuralWatt compare'),
    ('openrouter', 'z-ai/glm-5.2',               datetime('now'), 'Cheapest workhorse, NeuralWatt compare'),
    ('openrouter', 'qwen/qwen3-vl-235b-a22b-instruct', datetime('now'), 'Vision'),
    ('openrouter', 'qwen/qwen3-vl-30b-a3b-instruct',   datetime('now'), 'Vision'),
    ('openrouter', 'google/gemini-3.5-flash',    datetime('now'), 'Google general/vision'),
    ('openrouter', 'google/gemini-3.1-flash-lite', datetime('now'), 'Google general/vision'),
    ('openrouter', 'qwen/qwen3.6-35b-a3b',       datetime('now'), 'General/reasoning'),
    ('openrouter', 'qwen/qwen3-max',             datetime('now'), 'General/reasoning'),
    ('openrouter', 'mistralai/mistral-medium-3.1', datetime('now'), 'General chat'),
    ('openrouter', 'mistralai/mistral-small-3.2-24b-instruct', datetime('now'), 'General chat'),
    ('openrouter', 'mistralai/mistral-large-2512',   datetime('now'), 'General chat'),
    ('openrouter', 'z-ai/glm-5.2:free',          datetime('now'), 'Free tier plumbing test'),
    ('openrouter', 'nvidia/nemotron-3-super-120b-a12b:free', datetime('now'), 'Free tier plumbing test'),
    ('openrouter', 'nvidia/nemotron-3-nano-omni-30b-a3b-reasoning:free', datetime('now'), 'Free tier plumbing test'),
    ('openrouter', 'meta-llama/llama-4-maverick', datetime('now'), 'General open weights'),
    ('openrouter', 'meta-llama/llama-4-scout',   datetime('now'), 'General open weights'),
    ('openrouter', 'deepseek/deepseek-v3.2',     datetime('now'), 'Legacy / general');