在dz后台,执行下面的两个建表语句:- 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;
复制代码 |