-- Admin model overrides table.
--
-- Operators mark specific (model_id, provider) rows as deprecated or stale
-- when catalog data is unreliable or when a model fails production verification.
-- The router reads these rows and excludes deprecated models from candidate
-- selection, so an override takes effect on live /route requests without a
-- code change or restart.
--
-- Run with: sqlite3 router.db < admin_schema.sql

PRAGMA foreign_keys = ON;

CREATE TABLE IF NOT EXISTS admin_model_overrides (
    model_id         TEXT NOT NULL,
    provider         TEXT NOT NULL,
    availability     TEXT NOT NULL,          -- 'active' | 'deprecated' | 'stale'
    reason           TEXT,
    updated_at       TEXT NOT NULL,
    PRIMARY KEY (model_id, provider)
);

CREATE INDEX IF NOT EXISTS idx_admin_model_overrides_availability
    ON admin_model_overrides (availability);