Index: branches/5.2.x/core/install/install_schema.sql =================================================================== diff -u -N -r14437 -r14447 --- branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 14437) +++ branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 14447) @@ -237,7 +237,7 @@ CREATE TABLE PortalUser ( PortalUserId int(11) NOT NULL AUTO_INCREMENT, - Login varchar(255) DEFAULT NULL, + Login varchar(255) NOT NULL, `Password` varchar(255) DEFAULT 'd41d8cd98f00b204e9800998ecf8427e', FirstName varchar(255) NOT NULL DEFAULT '', LastName varchar(255) NOT NULL DEFAULT '', @@ -267,16 +267,17 @@ DisplayToPublic text, UserType tinyint(4) NOT NULL, PrimaryGroupId int(11) DEFAULT NULL, + OldStyleLogin tinyint(4) NOT NULL, PRIMARY KEY (PortalUserId), UNIQUE KEY ResourceId (ResourceId), - UNIQUE KEY Login (Login), KEY CreatedOn (CreatedOn), KEY `Status` (`Status`), KEY Modified (Modified), KEY dob (dob), KEY IsBanned (IsBanned), KEY AdminLanguage (AdminLanguage), - KEY UserType (UserType) + KEY UserType (UserType), + KEY Login (Login) ); CREATE TABLE PortalUserCustomData (