diff options
| -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`)"; |