-- Switch billing from tokens to characters
-- tokens_used kept for internal Gemini API cost tracking

-- Add characters_used column to translation_jobs
ALTER TABLE "translation_jobs" ADD COLUMN "characters_used" INTEGER NOT NULL DEFAULT 0;

-- Rename customer_cost_per_token to customer_cost_per_char on subscriptions
ALTER TABLE "subscriptions" RENAME COLUMN "customer_cost_per_token" TO "customer_cost_per_char";
