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 ); |