-- Only needed if 2026_11_17_000001 was already run with the old codes.
-- Renames Serbian 'rs' -> 'sr' and Swedish 'sw' -> 'sv' without losing anyone's preference.
-- Safe to run more than once.
ALTER TABLE users MODIFY preferred_language ENUM('mk','en','sr','sv','rs','sw') NOT NULL DEFAULT 'en';
UPDATE users SET preferred_language = 'sr' WHERE preferred_language = 'rs';
UPDATE users SET preferred_language = 'sv' WHERE preferred_language = 'sw';
ALTER TABLE users MODIFY preferred_language ENUM('mk','en','sr','sv') NOT NULL DEFAULT 'en';

UPDATE settings SET value = 'sr' WHERE name = 'default_language' AND value = 'rs';
UPDATE settings SET value = 'sv' WHERE name = 'default_language' AND value = 'sw';
