From 21042329e368b0185210be98c7605b50972045f6 Mon Sep 17 00:00:00 2001 From: Jan-Hendrik Willms Date: Thu, 26 Jun 2025 18:09:50 +0200 Subject: update column matriculation_number before adding index, re #4577 Merge request studip/studip!4292 --- .../5.5.32_index_and_correct_type_for_matriculation_number.php | 5 +++++ 1 file changed, 5 insertions(+) diff --git a/db/migrations/5.5.32_index_and_correct_type_for_matriculation_number.php b/db/migrations/5.5.32_index_and_correct_type_for_matriculation_number.php index e74ff6d..38475e1 100644 --- a/db/migrations/5.5.32_index_and_correct_type_for_matriculation_number.php +++ b/db/migrations/5.5.32_index_and_correct_type_for_matriculation_number.php @@ -11,6 +11,11 @@ final class IndexAndCorrectTypeForMatriculationNumber extends Migration public function up() { + $query = "UPDATE `auth_user_md5` + SET `matriculation_number` = NULL + WHERE `matriculation_number` = ''"; + DBManager::get()->exec($query); + $query = "ALTER TABLE `auth_user_md5` MODIFY COLUMN `matriculation_number` VARCHAR(255) COLLATE latin1_bin NULL DEFAULT NULL, ADD UNIQUE INDEX `matriculation_number` (`matriculation_number`)"; -- cgit v1.0