CREATE TABLE IF NOT EXISTS `mybb_sessions` (
`sid` varchar(32) NOT NULL default '',
`uid` int(10) unsigned NOT NULL default '0',
`ip` varchar(40) NOT NULL default '',
`time` bigint(30) NOT NULL default '0',
`location` varchar(150) NOT NULL default '',
`useragent` varchar(100) NOT NULL default '',
`anonymous` int(1) NOT NULL default '0',
`nopermission` int(1) NOT NULL default '0',
`location1` int(10) NOT NULL default '0',
`location2` int(10) NOT NULL default '0',
`loginattempts` tinyint(2) NOT NULL default '1',
`failedlogin` bigint(30) NOT NULL default '0',
PRIMARY KEY (`sid`),
KEY `location1` (`location1`),
KEY `location2` (`location2`),
KEY `time` (`time`),
KEY `uid` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;