主題表

CREATE TABLE pre_forum_thread ( tid mediumint(8) unsigned NOT NULL auto_increment COMMENT '主題id', fid mediumint(8) unsigned NOT NULL default '0' COMMENT '上級論壇', posttableid smallint(6) unsigned NOT NULL default '0' COMMENT '帖子表ID', typeid smallint(6) unsigned NOT NULL default '0' COMMENT '主題分類id', sortid smallint(6) unsigned NOT NULL default '0' COMMENT '分類信息id', readperm tinyint(3) unsigned NOT NULL default '0' COMMENT '閱讀權(quán)限', price smallint(6) NOT NULL default '0' COMMENT '價格', author char(15) NOT NULL default '' COMMENT '會員名', authorid mediumint(8) unsigned NOT NULL default '0' COMMENT '會員id', `subject` char(80) NOT NULL default '' COMMENT '標(biāo)題', dateline int(10) unsigned NOT NULL default '0' COMMENT '發(fā)表時間', lastpost int(10) unsigned NOT NULL default '0' COMMENT '最后發(fā)表', lastposter char(15) NOT NULL default '' COMMENT '最后發(fā)表人id', views int(10) unsigned NOT NULL default '0' COMMENT '瀏覽次數(shù)', replies mediumint(8) unsigned NOT NULL default '0' COMMENT '回復(fù)次數(shù)', displayorder tinyint(1) NOT NULL default '0' COMMENT '顯示順序', highlight tinyint(1) NOT NULL default '0' COMMENT '是否高亮', digest tinyint(1) NOT NULL default '0' COMMENT '是否精華', rate tinyint(1) NOT NULL default '0' COMMENT '是否評分', special tinyint(1) NOT NULL default '0' COMMENT '特殊主題', attachment tinyint(1) NOT NULL default '0' COMMENT '附件,0無附件 1普通附件 2有圖片附件', moderated tinyint(1) NOT NULL default '0' COMMENT '是否被管理員改動', closed mediumint(8) unsigned NOT NULL default '0' COMMENT '是否關(guān)閉', stickreply tinyint(1) unsigned NOT NULL default '0' COMMENT '是否有回帖置頂', recommends smallint(6) NOT NULL default '0' COMMENT '推薦指數(shù)', recommend_add smallint(6) NOT NULL default '0' COMMENT '支持人數(shù)', recommend_sub smallint(6) NOT NULL default '0' COMMENT '反對人數(shù)', heats int(10) unsigned NOT NULL default '0' COMMENT '主題熱度值', status smallint (6) unsigned NOT NULL default '0' , isgroup tinyint(1) NOT NULL default '0' COMMENT '是否為群組帖子', favtimes mediumint(8) NOT NULL default '0' COMMENT '主題收藏次數(shù)', sharetimes mediumint(8) NOT NULL default '0' COMMENT '主題分享次數(shù)', `stamp` tinyint(3) NOT NULL default '-1' COMMENT '主題圖章', `icon` tinyint(3) NOT NULL default '-1' COMMENT '主題圖標(biāo)', pushedaid mediumint(8) NOT NULL default '0' COMMENT '被推送到的文章aid', cover smallint(6) NOT NULL default '0' COMMENT '主題封面 負(fù)數(shù):遠(yuǎn)程　正數(shù):本地 0:無封面', replycredit smallint(6) NOT NULL default '0' COMMENT '回帖獎勵積分主題記錄積分值', PRIMARY KEY (tid), KEY digest (digest), KEY sortid (sortid), KEY displayorder (fid,displayorder,lastpost), KEY typeid (fid,typeid,displayorder,lastpost), KEY recommends (recommends), KEY heats (heats), KEY authorid (authorid), KEY isgroup (isgroup, lastpost), KEY special (special) ) ENGINE=MyISAM COMMENT='主題表' ;

內(nèi)容表

CREATE TABLE pre_forum_post ( pid int(10) unsigned NOT NULL auto_increment COMMENT '帖子id', fid mediumint(8) unsigned NOT NULL default '0' COMMENT '論壇id', tid mediumint(8) unsigned NOT NULL default '0' COMMENT '主題id', `first` tinyint(1) NOT NULL default '0' COMMENT '是否是首貼', author varchar(15) NOT NULL default '' COMMENT '作者姓名', authorid mediumint(8) unsigned NOT NULL default '0' COMMENT '作者id', `subject` varchar(80) NOT NULL default '' COMMENT '標(biāo)題', dateline int(10) unsigned NOT NULL default '0' COMMENT '發(fā)表時間', message mediumtext NOT NULL COMMENT '消息', useip varchar(15) NOT NULL default '' COMMENT '發(fā)帖者IP', invisible tinyint(1) NOT NULL default '0' COMMENT '是否通過審核', anonymous tinyint(1) NOT NULL default '0' COMMENT '是否匿名', usesig tinyint(1) NOT NULL default '0' COMMENT '是否啟用簽名', htmlon tinyint(1) NOT NULL default '0' COMMENT '是否允許HTML', bbcodeoff tinyint(1) NOT NULL default '0' COMMENT '是否關(guān)閉BBCODE', smileyoff tinyint(1) NOT NULL default '0' COMMENT '是否關(guān)閉表情', parseurloff tinyint(1) NOT NULL default '0' COMMENT '是否允許粘貼URL', attachment tinyint(1) NOT NULL default '0' COMMENT '附件', rate smallint(6) NOT NULL default '0' COMMENT '評分分?jǐn)?shù)', ratetimes tinyint(3) unsigned NOT NULL default '0' COMMENT '評分次數(shù)', `status` tinyint(1) NOT NULL default '0' COMMENT '帖子狀態(tài)', tags varchar(255) NOT NULL default '0' COMMENT '新增字段，用于存放tag', `comment` tinyint(1) NOT NULL default '0' COMMENT '是否存在點評', replycredit smallint(6) NOT NULL default '0' COMMENT '回帖獲得積分記錄', PRIMARY KEY (pid), KEY fid (fid), KEY authorid (authorid), KEY dateline (dateline), KEY invisible (invisible), KEY displayorder (tid,invisible,dateline), KEY `first` (tid,`first`) ) ENGINE=MyISAM COMMENT='帖子表' ;

　　

轉(zhuǎn)載于:https://www.cnblogs.com/leavesldy/archive/2013/05/10/3070863.html

總結(jié)

以上是生活随笔為你收集整理的pre_forum_thread 主题表跟pre_forum_thread内容表是用哪个字段对应起来的？的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。