-- Migration: 0006_add_transcription_tier
-- Media analysis phase (PDF/OCR/image/voice). Adds a 4th model tier
-- dedicated to speech-to-text (Avalai's Whisper endpoint uses a
-- separate /audio/transcriptions API, not /chat/completions, but the
-- model name it needs still comes from this same DB-driven catalog
-- — never hardcoded — for consistency with every other model choice).

ALTER TABLE ai_models
    MODIFY COLUMN tier ENUM('cheap', 'medium', 'powerful', 'transcription') NOT NULL;

INSERT INTO ai_models (provider, model_name, tier, credit_multiplier, is_active) VALUES
    ('avalai', 'whisper-1', 'transcription', 1.000, 1);