CREATE TABLE `dede_apizl_comment` (
`id` int (11) NOT NULL AUTO_INCREMENT,
`uid` int (11) DEFAULT '-1' COMMENT '-1=不存在登录' ,
`ip` varchar (255) DEFAULT NULL ,
`useragent` varchar (255) DEFAULT NULL ,
`to_id` int (11) DEFAULT '0' COMMENT '给某人回复' ,
`hash` varchar (255) CHARACTER SET gbk DEFAULT NULL ,
`view_id` int (11) DEFAULT NULL ,
`url` varchar (255) CHARACTER SET gbk DEFAULT NULL ,
`type` enum( 'URL' , '文章' ) CHARACTER SET gbk DEFAULT '文章' ,
`username` varchar (255) CHARACTER SET gbk DEFAULT NULL ,
`user_url` varchar (255) CHARACTER SET gbk DEFAULT NULL ,
`user_email` varchar (255) CHARACTER SET gbk DEFAULT NULL ,
`user_images` varchar (255) CHARACTER SET gbk DEFAULT NULL ,
`content` varchar (255) CHARACTER SET gbk DEFAULT NULL ,
`add_time` int (11) DEFAULT NULL ,
`edit_time` int (11) DEFAULT NULL ,
`up_click` int (11) DEFAULT '0' ,
`down_click` int (11) DEFAULT '0' ,
`state` enum( '删除' , '正常' , '待审核' ) CHARACTER SET gbk DEFAULT '待审核' ,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`),
KEY `type` (`type`),
KEY `state` (`state`),
KEY `uid` (`uid`),
KEY `to_id` (`to_id`),
KEY `hash_2` (`hash`),
KEY `view_id` (`view_id`),
KEY `url` (`url`),
KEY `ip` (`ip`)
) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COMMENT= '评论表' ;
CREATE TABLE `dede_apizl_comment_setting` (
` key ` varchar (255) CHARACTER SET gbk DEFAULT NULL ,
`value` varchar (255) CHARACTER SET gbk DEFAULT NULL ,
UNIQUE KEY ` key ` (` key `)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT= '评论配置插件' ;
INSERT INTO `dede_plus` (`plusname`, `menustring`, `mainurl`, `writer`, `isshow`, `filelist`) VALUES ( '爱资料评论插件' , '<m:item name="爱资料评论插件" link="comment_manage.php" rank="爱资料评论插件" target="main" />' , '' , '爱资料' , 1, NULL );
|