|
||||
字段名 | 说明描述 | 具体参数 | ||
username | 用户名称 | char(20) NOT NULL default '' , | ||
typeid | 栏目ID | smallint(5) unsigned NOT NULL default '0' , | ||
good | 顶 | mediumint(8) unsigned NOT NULL default '0' , | ||
ip | 评论IP | char(15) NOT NULL default '' , | ||
dtime | 评论时间 | int(10) unsigned NOT NULL default '0' , | ||
mid | 会员ID | mediumint(8) unsigned NOT NULL default '0' , | ||
face | 会员表情 | smallint(5) unsigned NOT NULL default '0' , | ||
bad | 踩 | mediumint(8) unsigned NOT NULL default '0' , | ||
ftype | 论评类型 | set('feedback','good','bad') NOT NULL default 'feedback' , | ||
ischeck | 是否审核 | smallint(6) NOT NULL default '0' , | ||
msg | 信息内容 | text , | ||
aid | 文档ID | mediumint(8) unsigned NOT NULL default '0' , | ||
arctitle | 文档标题 | varchar(60) NOT NULL default '' , | ||
id | ID | int(10) unsigned NOT NULL auto_increment , | ||
索引: PRIMARY KEY (`id`), KEY `aid` (`aid`,`ischeck`,`mid`) |
1
Comments