· 8 years ago · Aug 05, 2018, 03:42 AM
1CREATE TABLE IF NOT EXISTS `XXXXXX_session` (
2 `session_id` varchar(200) NOT NULL default '',
3 `client_id` tinyint(3) unsigned NOT NULL default '0',
4 `guest` tinyint(4) unsigned default '1',
5 `time` varchar(14) default '',
6 `data` mediumtext,
7 `userid` int(11) default '0',
8 `username` varchar(150) default '',
9 `usertype` varchar(50) default '',
10 PRIMARY KEY (`session_id`),
11 KEY `whosonline` (`guest`,`usertype`),
12 KEY `userid` (`userid`),
13 KEY `time` (`time`)
14) ENGINE=InnoDB DEFAULT CHARSET=utf8;