56,675
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE forums (
fid smallint(6) unsigned NOT NULL AUTO_INCREMENT,
fup smallint(6) unsigned NOT NULL DEFAULT '0',
`type` enum('group','forum','sub') NOT NULL DEFAULT 'forum',
`name` char(50) NOT NULL DEFAULT '',
`status` tinyint(1) NOT NULL DEFAULT '0',
displayorder tinyint(3) NOT NULL DEFAULT '0',
threads mediumint(8) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (fid),
KEY forum (`status`,`type`,displayorder),
KEY fup (fup)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;
CREATE TABLE threads (
tid mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
fid smallint(6) unsigned NOT NULL DEFAULT '0',
typeid smallint(6) unsigned NOT NULL DEFAULT '0',
author char(15) NOT NULL DEFAULT '',
authorid mediumint(8) unsigned NOT NULL DEFAULT '0',
`subject` char(80) NOT NULL DEFAULT '',
views int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (tid),
KEY typeid (fid,typeid)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;