- CREATE TABLE pre_common_session (
- sid char(6) NOT NULL DEFAULT '',
- ip1 tinyint(3) unsigned NOT NULL DEFAULT '0',
- ip2 tinyint(3) unsigned NOT NULL DEFAULT '0',
- ip3 tinyint(3) unsigned NOT NULL DEFAULT '0',
- ip4 tinyint(3) unsigned NOT NULL DEFAULT '0',
- uid mediumint(8) unsigned NOT NULL DEFAULT '0',
- username char(15) NOT NULL DEFAULT '',
- groupid smallint(6) unsigned NOT NULL DEFAULT '0',
- invisible tinyint(1) NOT NULL DEFAULT '0',
- `action` tinyint(1) unsigned NOT NULL DEFAULT '0',
- lastactivity int(10) unsigned NOT NULL DEFAULT '0',
- lastolupdate int(10) unsigned NOT NULL DEFAULT '0',
- fid mediumint(8) unsigned NOT NULL DEFAULT '0',
- tid mediumint(8) unsigned NOT NULL DEFAULT '0',
- UNIQUE KEY sid (sid),
- KEY uid (uid)
- ) TYPE=HEAP;
复制代码 |