-- UI locale preference (nl | en) ALTER TABLE user_ui_preferences ADD COLUMN IF NOT EXISTS locale VARCHAR(8) DEFAULT 'nl'; UPDATE user_ui_preferences SET locale = 'nl' WHERE locale IS NULL;