重建一下doing 表- CREATE TABLE uchome_doing (
- doid mediumint(8) unsigned NOT NULL auto_increment,
- uid mediumint(8) unsigned NOT NULL default '0',
- username varchar(15) NOT NULL default '',
- `from` varchar(20) NOT NULL default '',
- dateline int(10) unsigned NOT NULL default '0',
- message text NOT NULL,
- ip varchar(20) NOT NULL default '',
- replynum int(10) unsigned NOT NULL default '0',
- mood smallint(6) NOT NULL default '0',
- PRIMARY KEY (doid),
- KEY uid (uid,dateline),
- KEY dateline (dateline)
- ) ENGINE=MyISAM;
复制代码 |