Index: branches/5.2.x/core/install/upgrades.sql =================================================================== diff -u -N -r14437 -r14447 --- branches/5.2.x/core/install/upgrades.sql (.../upgrades.sql) (revision 14437) +++ branches/5.2.x/core/install/upgrades.sql (.../upgrades.sql) (revision 14447) @@ -2012,4 +2012,15 @@ SET DisplayOrder = DisplayOrder + 0.01 WHERE `ModuleOwner` = 'In-Portal:Users' AND `Section` = 'in-portal:configure_users' AND DisplayOrder BETWEEN 10.12 AND 20.00; -INSERT INTO ConfigurationValues VALUES(DEFAULT, 'User_AdminGroup', '11', 'In-Portal:Users', 'in-portal:configure_users', 'la_title_General', 'la_users_admin_group', 'select', NULL, '0=lu_none||SELECT GroupId as OptionValue, Name as OptionName FROM PortalGroup WHERE Enabled=1 AND Personal=0', 10.12, 0, 1, NULL); \ No newline at end of file +INSERT INTO ConfigurationValues VALUES(DEFAULT, 'User_AdminGroup', '11', 'In-Portal:Users', 'in-portal:configure_users', 'la_title_General', 'la_users_admin_group', 'select', NULL, '0=lu_none||SELECT GroupId as OptionValue, Name as OptionName FROM PortalGroup WHERE Enabled=1 AND Personal=0', 10.12, 0, 1, NULL); + +ALTER TABLE PortalUser + DROP INDEX Login, + ADD INDEX Login (Login); + +ALTER TABLE PortalUser CHANGE Login Login VARCHAR(255) NOT NULL; +ALTER TABLE PortalUser ADD OldStyleLogin TINYINT NOT NULL; + +UPDATE PortalUser +SET OldStyleLogin = 1 +WHERE (Login <> '') AND (Login NOT REGEXP '^[A-Z0-9_\\-\\.]+$'); \ No newline at end of file