diff options
| author | Jan-Hendrik Willms <tleilax+studip@gmail.com> | 2025-06-26 18:09:50 +0200 |
|---|---|---|
| committer | David Siegfried <david.siegfried@uni-vechta.de> | 2025-06-26 16:09:50 +0000 |
| commit | 21042329e368b0185210be98c7605b50972045f6 (patch) | |
| tree | b4fd4a9f246d1157e370fe601f66fbe7ba463ea9 | |
| parent | dbee0b041a49a9d5e242c12f2b2011517f2a92d8 (diff) | |
update column matriculation_number before adding index, re #4577
Merge request studip/studip!4292
| -rw-r--r-- | db/migrations/5.5.32_index_and_correct_type_for_matriculation_number.php | 5 |
1 files changed, 5 insertions, 0 deletions
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`)"; |