24 lines
874 B
SQL
24 lines
874 B
SQL
-- 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);
|