sub2api/backend/migrations/070_add_usage_log_service_tier.sql

ALTER TABLE usage_logs
    ADD COLUMN IF NOT EXISTS service_tier VARCHAR(16);

CREATE INDEX IF NOT EXISTS idx_usage_logs_service_tier_created_at
    ON usage_logs (service_tier, created_at);