-- Add plugin field to translation_jobs for separating jobs by source plugin
ALTER TABLE "translation_jobs" ADD COLUMN "plugin" VARCHAR(30) NOT NULL DEFAULT 'translate';

-- Update model default from stale value
ALTER TABLE "translation_jobs" ALTER COLUMN "model" SET DEFAULT 'gemini-3.1-flash-lite';

-- Index for filtering jobs by plugin
CREATE INDEX "translation_jobs_plugin_idx" ON "translation_jobs"("plugin");
