Index: branches/5.0.x/core/install/install_schema.sql =================================================================== diff -u -r12264 -r12399 --- branches/5.0.x/core/install/install_schema.sql (.../install_schema.sql) (revision 12264) +++ branches/5.0.x/core/install/install_schema.sql (.../install_schema.sql) (revision 12399) @@ -320,21 +320,21 @@ ); CREATE TABLE UserSession ( - SessionKey int(10) unsigned NOT NULL default '0', - CurrentTempKey int(10) unsigned default NULL, - PrevTempKey int(10) unsigned default NULL, - LastAccessed int(10) unsigned NOT NULL default '0', - PortalUserId int(11) NOT NULL default '-2', - `Language` int(11) NOT NULL default '1', - Theme int(11) NOT NULL default '1', - GroupId int(11) NOT NULL default '0', - IpAddress varchar(20) NOT NULL default '0.0.0.0', - `Status` int(11) NOT NULL default '1', - GroupList varchar(255) default NULL, - tz int(11) default NULL, - PRIMARY KEY (SessionKey), + SessionKey int(10) unsigned NOT NULL DEFAULT '0', + LastAccessed int(10) unsigned NOT NULL DEFAULT '0', + PortalUserId int(11) NOT NULL DEFAULT '-2', + `Language` int(11) NOT NULL DEFAULT '1', + Theme int(11) NOT NULL DEFAULT '1', + GroupId int(11) NOT NULL DEFAULT '0', + IpAddress varchar(20) NOT NULL DEFAULT '0.0.0.0', + `Status` int(11) NOT NULL DEFAULT '1', + GroupList varchar(255) DEFAULT NULL, + tz int(11) DEFAULT NULL, + BrowserSignature varchar(32) NOT NULL, + PRIMARY KEY (SessionKey), KEY UserId (PortalUserId), - KEY LastAccessed (LastAccessed) + KEY LastAccessed (LastAccessed), + KEY BrowserSignature (BrowserSignature) ); CREATE TABLE EmailLog (