我知道了,是表的关系。
CREATE TABLE IF NOT EXISTS `cdb_myposts` (
`uid` mediumint(8) unsigned NOT NULL default '0',
`tid` mediumint(8) unsigned NOT NULL default '0',
`pid` int(10) unsigned NOT NULL default '0',
`position` smallint(6) unsigned NOT NULL default '0',
`dateline` int(10) unsigned NOT NULL default '0',
`special` tinyint(1) unsigned NOT NULL default '0',
PRIMARY KEY (`uid`,`tid`),
KEY `tid` (`tid`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
CREATE TABLE IF NOT EXISTS `cdb_mythreads` (
`uid` mediumint(8) unsigned NOT NULL default '0',
`tid` mediumint(8) unsigned NOT NULL default '0',
`special` tinyint(1) unsigned NOT NULL default '0',
`dateline` int(10) NOT NULL default '0',
PRIMARY KEY (`uid`,`tid`),
KEY `tid` (`tid`,`dateline`)
) ENGINE=MyISAM DEFAULT CHARSET=gbk;
新建表就行 |