-- One-off fix: the 7 rows inserted by add_status_change_reasons.sql got
-- double-encoded (mojibake) because the mysql CLI session that ran the
-- insert wasn't forced to utf8mb4. This overwrites them with correct
-- text, by id, so it doesn't disturb anything already referencing them.
--
-- IMPORTANT: run this with --default-character-set=utf8mb4, otherwise
-- it will corrupt the data the same way again:
--
--   docker compose exec -T db mysql --default-character-set=utf8mb4 \
--       -u axioma -p"$(grep '^DB_PASS=' .env | cut -d '=' -f2-)" axioma \
--       < scripts/fix_status_reasons_encoding.sql

UPDATE student_status_reasons SET name = 'Нет результата'       WHERE id = 1;
UPDATE student_status_reasons SET name = 'Конфликт'             WHERE id = 2;
UPDATE student_status_reasons SET name = 'Не устроили условия'  WHERE id = 3;
UPDATE student_status_reasons SET name = 'Переезд'              WHERE id = 4;
UPDATE student_status_reasons SET name = 'Перестали отвечать'   WHERE id = 5;
UPDATE student_status_reasons SET name = 'Каникулы'             WHERE id = 6;
UPDATE student_status_reasons SET name = 'Выполнили цель'       WHERE id = 7;
