-- TripTale v1.31: additional user interface languages
-- preferred_language is already VARCHAR(2); no column change is necessary.
-- This migration deliberately normalizes only invalid or empty old values.
UPDATE travel_1_users
SET preferred_language = 'de'
WHERE preferred_language IS NULL
   OR preferred_language NOT IN ('de', 'en', 'fr', 'it', 'es');
