1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
|
CREATE TABLE `bb1_sessions` (
`sessionhash` varchar(32) NOT NULL default '',
`userid` int(11) unsigned default '0',
`ipaddress` varchar(16) default NULL,
`useragent` varchar(100) default NULL,
`lastactivity` int(11) unsigned default '0',
`request_uri` varchar(250) default NULL,
`styleid` int(11) unsigned default '0',
`langid` int(11) default '0',
`boardid` int(11) unsigned default '0',
`threadid` int(11) unsigned default '0',
`authentificationcode` varchar(32) default NULL,
PRIMARY KEY (`sessionhash`),
KEY `userid` (`userid`),
KEY `boardid` (`boardid`)
) |