升级这段数据。
- DROP TABLE IF EXISTS cdb_sessions;
- CREATE TABLE cdb_sessions (
- sid char(6) binary 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',
- styleid 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',
- pageviews smallint(6) unsigned NOT NULL default '0',
- seccode smallint(6) unsigned NOT NULL default '0',
- fid smallint(6) unsigned NOT NULL default '0',
- tid mediumint(8) unsigned NOT NULL default '0',
- bloguid mediumint(8) unsigned NOT NULL default '0',
- UNIQUE KEY sid (sid),
- KEY uid (uid),
- KEY bloguid (bloguid)
- ) TYPE=Heap;
复制代码 |