Eric Lippmann 755b2108a8 Schema: Increase length of username columns
In order to support usernames with domains, the length of the username columns is now 254 which also supports email addresses as usernames.

refs #2153
2017-06-12 13:31:07 +02:00

6 lines
382 B
SQL

# Icinga Web 2 | (c) 2017 Icinga Development Team | GPLv2+
ALTER TABLE `icingaweb_group_membership` MODIFY COLUMN `username` varchar(254) COLLATE utf8_unicode_ci NOT NULL;
ALTER TABLE `icingaweb_user` MODIFY COLUMN `name` varchar(254) COLLATE utf8_unicode_ci NOT NULL;
ALTER TABLE `icingaweb_user_preference` MODIFY COLUMN `username` varchar(254) COLLATE utf8_unicode_ci NOT NULL;