/*
Navicat MySQL Data Transfer

Source Server         : lee
Source Server Version : 50709
Source Host           : localhost:3306
Source Database       : zhihu

Target Server Type    : MYSQL
Target Server Version : 50709
File Encoding         : 65001

Date: 2016-08-08 17:10:30
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for zhihu_admin
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_admin`;
CREATE TABLE `zhihu_admin` (
  `id` int(5) unsigned NOT NULL AUTO_INCREMENT,
  `username` varchar(64) NOT NULL,
  `name` varchar(50) NOT NULL,
  `pass` char(32) NOT NULL,
  `image` varchar(255) NOT NULL DEFAULT 'default_80.jpg' COMMENT '头像图片名',
  `denied` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_admin
-- ----------------------------
INSERT INTO `zhihu_admin` VALUES ('1', 'admin', '管理员', 'e10adc3949ba59abbe56e057f20f883e', 'default_80.jpg', '1');
INSERT INTO `zhihu_admin` VALUES ('2', 'yangyun', '杨云', 'e10adc3949ba59abbe56e057f20f883e', 'default_82.jpg', '1');
INSERT INTO `zhihu_admin` VALUES ('3', 'zhangsan', '张三', 'e10adc3949ba59abbe56e057f20f883e', 'default_80.jpg', '1');
INSERT INTO `zhihu_admin` VALUES ('5', 'test2', '世纪东方', 'e10adc3949ba59abbe56e057f20f883e', 'default_80.jpg', '1');

-- ----------------------------
-- Table structure for zhihu_answer
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_answer`;
CREATE TABLE `zhihu_answer` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `filename` varchar(255) DEFAULT NULL,
  `part` varchar(255) NOT NULL,
  `question_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `zan` int(10) unsigned NOT NULL DEFAULT '0',
  `discuss_number` int(10) unsigned NOT NULL DEFAULT '0',
  `thanks` int(10) unsigned NOT NULL DEFAULT '0',
  `helpless` int(10) unsigned NOT NULL DEFAULT '0',
  `display` tinyint(4) NOT NULL DEFAULT '1',
  `report` tinyint(4) NOT NULL DEFAULT '0',
  `datetime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `filename` (`filename`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_answer
-- ----------------------------
INSERT INTO `zhihu_answer` VALUES ('1', '2016080757a6ea08ea755.txt', '作者：知乎小管家\r\n链接：https://www.zhihu.com/question/19550225/answer/95067981\r\n来源：知乎\r\n著作权归作者所有，转载请联系作者获得授权。\r\n\r\n	本问题隶属于「知乎官方', '1', '3', null, '1', '1', '0', '0', '1', '0', '2016-08-07 15:58:00');
INSERT INTO `zhihu_answer` VALUES ('2', '2016080757a6f74f5040d.txt', '增加一个回答', '1', '3', null, '1', '1', '0', '0', '1', '1', '2016-08-07 16:54:39');
INSERT INTO `zhihu_answer` VALUES ('3', '2016080757a6faa72a665.txt', '\r\n	\r\n	\r\n		如果让我顺着题主的思路，在一定要玩游戏，不考虑去学习的情况，我会这么答:\r\n仅从目前我常玩的游戏炉石传说来说:\r\n培养快速计算能力（带上时间', '2', '6', null, '0', '0', '0', '0', '1', '0', '2016-08-07 17:08:55');
INSERT INTO `zhihu_answer` VALUES ('4', '2016080757a6fbce1a412.txt', '\r\n	\r\n		论背景完整和地位，第一肯定是魔戒。魔戒可不仅仅是三部曲+一部霍比特人那么简单，托尔金在设计魔戒世界的时候，充分体现了英国人的严谨。很多魔', '3', '3', null, '1', '1', '0', '0', '1', '0', '2016-08-07 17:13:50');
INSERT INTO `zhihu_answer` VALUES ('5', '2016080757a6fd6d423b4.txt', '\r\n	\r\n		这头龙已经很老很老了。\r\n有多老呢？它的牙齿已经布满裂痕，那是长年累月跟刀剑和魔法作战的痕迹；它的眼球浑浊，翅膀上的鳞片已经斑驳；它挥动的', '4', '6', null, '1', '1', '0', '0', '1', '0', '2016-08-07 17:20:45');
INSERT INTO `zhihu_answer` VALUES ('6', '2016080757a716f3dcf53.txt', '\r\n	\r\n		没想到更让人不解的是你乎居然还有人为了Mack Horton发声：“我顿是干净的啊你大白杨嗑过药啊所以他可以理直气壮鄙视孙杨啊”“运动员之间的', '5', '7', null, '1', '0', '0', '0', '1', '0', '2016-08-07 19:09:39');
INSERT INTO `zhihu_answer` VALUES ('7', '2016080757a7171f77c28.txt', '霍顿真是个空口验尿的举世奇才。', '5', '7', null, '2', '1', '0', '0', '1', '0', '2016-08-07 19:10:23');
INSERT INTO `zhihu_answer` VALUES ('8', '2016080757a728be4b924.txt', '作为一个鬼吹灯和盗笔都看了不知道多少遍的人，作为一个曾经的盗笔迷，现在的我只想说别', '6', '3', null, '1', '0', '0', '0', '1', '0', '2016-08-07 20:25:34');
INSERT INTO `zhihu_answer` VALUES ('9', '2016080757a72982bedd2.txt', '\r\n	\r\n差在剧本、剧情、台词、演员、摄影、化妆，等，几乎涵盖一切电影所以成为电影的基本要素', '6', '7', null, '0', '0', '0', '0', '1', '0', '2016-08-07 20:28:50');
INSERT INTO `zhihu_answer` VALUES ('10', '2016080857a7e7c2eccae.txt', '相当不错', '6', '8', null, '0', '0', '0', '0', '1', '0', '2016-08-08 10:00:34');
INSERT INTO `zhihu_answer` VALUES ('11', '2016080857a7e8d4276f8.txt', '\r\n	著作权归作者所有，转载请联系作者获得授权。\r\n	\r\n		\r\n			开源软件、开源社区的发展大大减少了程序员的重复劳动。10年前，开源仍然是比较小众的（还记得', '8', '3', null, '2', '0', '0', '0', '1', '0', '2016-08-08 10:05:08');
INSERT INTO `zhihu_answer` VALUES ('12', '2016080857a7e90d2879c.txt', '\r\n	\r\n		编程语言层出不穷，然而内核是万变不离其宗。我个人看法觉得是以下几个方面的变化比较明显\r\n语言本身：\r\n1. 工业标准\r\n网页标准有w3c控制，尤其是浏', '8', '3', null, '0', '1', '0', '0', '1', '0', '2016-08-08 10:06:05');
INSERT INTO `zhihu_answer` VALUES ('13', '2016080857a800d6bca23.txt', '不如意事常八九，能与人言无二三。', '9', '6', null, '0', '0', '0', '0', '1', '0', '2016-08-08 11:47:34');
INSERT INTO `zhihu_answer` VALUES ('14', '2016080857a81eb82eea5.txt', '我觉得题主多虑了。\r\n\r\n\r\n据我所知西山居美术中心在自研IP上砸了不少钱，这种投入是短期之内难以获得回报的，但这是符合国内游戏行业下一阶段产业升级长', '11', '5', null, '1', '0', '1', '1', '1', '0', '2016-08-08 13:55:04');
INSERT INTO `zhihu_answer` VALUES ('15', '2016080857a82a4df0ac6.txt', '\r\n	\r\n		我在现场观赛，主席台正对着的座位，算是全场最好的座位之一了，定价4600雷亚尔，折合人民币一万元，讲讲现场的一些有意思的事情吧：\r\n收到欢呼最', '13', '5', null, '1', '0', '0', '0', '1', '0', '2016-08-08 14:44:29');
INSERT INTO `zhihu_answer` VALUES ('16', '2016080857a82a94ad0eb.txt', '\r\n\r\n	\r\n		再一次印证了白岩松的牛X\r\n全长近4个小时（不算后边的讲话3个多小时），一个人介绍这么多国家，准备资料还不忘加上段子。\r\n肯定有团队帮他准备资', '13', '6', null, '0', '0', '0', '0', '1', '0', '2016-08-08 14:45:40');
INSERT INTO `zhihu_answer` VALUES ('17', '2016080857a836e3b9af0.txt', '\r\n	rtyuiortyu\r\n\r\n\r\n	\r\n', '14', '3', null, '0', '0', '0', '0', '1', '0', '2016-08-08 15:38:11');

-- ----------------------------
-- Table structure for zhihu_article
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_article`;
CREATE TABLE `zhihu_article` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `filename` varchar(255) DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `zan` int(10) unsigned NOT NULL,
  `discuss_number` int(10) unsigned NOT NULL,
  `thanks` int(10) unsigned NOT NULL,
  `helpless` int(10) unsigned NOT NULL,
  `display` tinyint(4) NOT NULL DEFAULT '1',
  `report` tinyint(4) NOT NULL DEFAULT '0',
  `datetime` datetime DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `filename` (`filename`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_article
-- ----------------------------
INSERT INTO `zhihu_article` VALUES ('1', '2016080757a6ebbf57040.txt', '桃花源记', '3', '0', '5', '0', '0', '1', '0', '2016-08-07 16:05:19', '2016/08/07/2016080757a6ebbebb597.jpg');
INSERT INTO `zhihu_article` VALUES ('2', '2016080757a717ee9a640.txt', '奥运会开始了；里约准备好了，我也准备好了。', '7', '0', '0', '0', '0', '1', '0', '2016-08-07 19:13:50', null);
INSERT INTO `zhihu_article` VALUES ('5', '2016080857a7eeec415f1.txt', '搭建汉字王国：有意义学习', '3', '0', '0', '0', '0', '1', '0', '2016-08-08 10:31:08', null);
INSERT INTO `zhihu_article` VALUES ('6', '2016080857a7ef495fb97.txt', '孩子做事全凭好玩，有趣，否则就提不起劲做，怎么办？', '3', '0', '0', '0', '0', '1', '0', '2016-08-08 10:32:41', null);
INSERT INTO `zhihu_article` VALUES ('7', '2016080857a7ef98b1e31.txt', '对孩子不吼不叫的非暴力沟通，你能做到', '3', '0', '0', '0', '0', '1', '0', '2016-08-08 10:34:00', null);
INSERT INTO `zhihu_article` VALUES ('8', '2016080857a7f0108db80.txt', '游戏机到底应该是什么样？', '3', '0', '0', '0', '0', '1', '0', '2016-08-08 10:36:00', null);
INSERT INTO `zhihu_article` VALUES ('10', '2016080857a816c24adac.txt', '我看诛仙...', '6', '0', '0', '0', '0', '1', '0', '2016-08-08 13:21:06', '2016/08/08/2016080857a816c224473.jpg');
INSERT INTO `zhihu_article` VALUES ('11', '2016080857a837282dc52.txt', '标题', '3', '0', '1', '0', '0', '1', '0', '2016-08-08 15:39:20', '2016/08/08/2016080857a83727eea36.jpg');

-- ----------------------------
-- Table structure for zhihu_article_discuss
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_article_discuss`;
CREATE TABLE `zhihu_article_discuss` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `content` varchar(255) DEFAULT NULL,
  `article_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `to_user_id` int(10) unsigned NOT NULL,
  `zan` int(10) unsigned DEFAULT '0',
  `display` tinyint(4) NOT NULL DEFAULT '1',
  `report` tinyint(4) NOT NULL DEFAULT '0',
  `datetime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_article_discuss
-- ----------------------------
INSERT INTO `zhihu_article_discuss` VALUES ('1', '虽然你是抄写经典,但我还是给个赞...就冲你拍的照片...', '1', '4', '0', '0', '1', '0', '2016-08-07 16:15:22');
INSERT INTO `zhihu_article_discuss` VALUES ('2', '虽然你是抄写经典,但我还是给个赞...就冲你拍的照片...', '1', '4', '0', '0', '1', '0', '2016-08-07 16:15:24');
INSERT INTO `zhihu_article_discuss` VALUES ('3', 'O(∩_∩)O~呵呵', '1', '3', '4', '0', '1', '0', '2016-08-07 16:15:54');
INSERT INTO `zhihu_article_discuss` VALUES ('4', '好的', '1', '6', '0', '0', '1', '0', '2016-08-08 13:49:59');
INSERT INTO `zhihu_article_discuss` VALUES ('5', '严肃点, 别卖萌...', '1', '6', '3', '0', '1', '0', '2016-08-08 13:50:34');
INSERT INTO `zhihu_article_discuss` VALUES ('6', 'ajx', '11', '3', '0', '0', '1', '0', '2016-08-08 15:39:35');

-- ----------------------------
-- Table structure for zhihu_collect
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_collect`;
CREATE TABLE `zhihu_collect` (
  `user_id` int(10) unsigned NOT NULL,
  `answer_id` int(10) unsigned NOT NULL,
  `article_id` int(10) unsigned NOT NULL,
  `store_id` int(10) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_collect
-- ----------------------------
INSERT INTO `zhihu_collect` VALUES ('3', '3', '0', '2');
INSERT INTO `zhihu_collect` VALUES ('6', '10', '0', '9');
INSERT INTO `zhihu_collect` VALUES ('6', '3', '0', '9');
INSERT INTO `zhihu_collect` VALUES ('3', '2', '0', '2');
INSERT INTO `zhihu_collect` VALUES ('3', '2', '0', '10');
INSERT INTO `zhihu_collect` VALUES ('3', '5', '0', '12');

-- ----------------------------
-- Table structure for zhihu_discuss
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_discuss`;
CREATE TABLE `zhihu_discuss` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `content` varchar(255) DEFAULT NULL,
  `answer_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `to_user_id` int(10) unsigned NOT NULL,
  `zan` int(10) unsigned NOT NULL DEFAULT '0',
  `display` tinyint(4) NOT NULL DEFAULT '1',
  `report` tinyint(4) NOT NULL DEFAULT '0',
  `datetime` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_discuss
-- ----------------------------
INSERT INTO `zhihu_discuss` VALUES ('1', '这个真是提升用户体验...', '1', '4', '0', '0', '0', '0', '2016-08-07 16:12:56');
INSERT INTO `zhihu_discuss` VALUES ('2', '滴学生卡,老司机发车啊.', '2', '3', '0', '0', '0', '1', '2016-08-07 16:58:35');
INSERT INTO `zhihu_discuss` VALUES ('3', '小哥写的不错啊,继续哟...', '5', '3', '0', '0', '1', '0', '2016-08-07 17:41:01');
INSERT INTO `zhihu_discuss` VALUES ('4', '一个人只写一个世界...想必是精致的', '4', '6', '0', '0', '1', '0', '2016-08-07 18:40:58');
INSERT INTO `zhihu_discuss` VALUES ('5', '看到这一句, 我就知道还是有明白人的...', '7', '6', '0', '0', '1', '0', '2016-08-07 19:53:05');
INSERT INTO `zhihu_discuss` VALUES ('6', '好', '12', '3', '0', '0', '1', '0', '2016-08-08 15:40:20');

-- ----------------------------
-- Table structure for zhihu_hot
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_hot`;
CREATE TABLE `zhihu_hot` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `topic_id` int(10) unsigned NOT NULL,
  `topic_name` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `answer_num` int(10) unsigned NOT NULL,
  `attend_num` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `display` tinyint(4) NOT NULL DEFAULT '1',
  `report` tinyint(4) NOT NULL DEFAULT '0',
  `datetime` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_hot
-- ----------------------------

-- ----------------------------
-- Table structure for zhihu_image
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_image`;
CREATE TABLE `zhihu_image` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `iname` varchar(255) DEFAULT NULL,
  `type` tinyint(3) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `iname` (`iname`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_image
-- ----------------------------

-- ----------------------------
-- Table structure for zhihu_invite
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_invite`;
CREATE TABLE `zhihu_invite` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `question_id` int(10) unsigned NOT NULL,
  `invited_user_id` tinyint(4) NOT NULL DEFAULT '0',
  `datetime` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_invite
-- ----------------------------

-- ----------------------------
-- Table structure for zhihu_letter
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_letter`;
CREATE TABLE `zhihu_letter` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `to_user_id` int(10) unsigned NOT NULL,
  `content` varchar(255) NOT NULL,
  `is_stranger` tinyint(4) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `datetime` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_letter
-- ----------------------------
INSERT INTO `zhihu_letter` VALUES ('9', '3', '5', '11', '0', '0', '2016-08-08 15:35:04');
INSERT INTO `zhihu_letter` VALUES ('10', '5', '3', '77', '0', '0', '2016-08-08 15:35:15');

-- ----------------------------
-- Table structure for zhihu_news
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_news`;
CREATE TABLE `zhihu_news` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `to_user_id` int(10) unsigned NOT NULL,
  `type` tinyint(4) NOT NULL DEFAULT '0',
  `status` tinyint(4) NOT NULL DEFAULT '0',
  `datetime` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_news
-- ----------------------------

-- ----------------------------
-- Table structure for zhihu_node
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_node`;
CREATE TABLE `zhihu_node` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `mname` varchar(50) NOT NULL,
  `aname` varchar(50) NOT NULL,
  `status` tinyint(1) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_node
-- ----------------------------
INSERT INTO `zhihu_node` VALUES ('1', '浏览用户', 'user', 'index', '1');
INSERT INTO `zhihu_node` VALUES ('2', '添加用户', 'user', 'add', '1');
INSERT INTO `zhihu_node` VALUES ('3', '删除用户', 'user', 'del', '1');
INSERT INTO `zhihu_node` VALUES ('4', '修改用户', 'user', 'edit', '1');
INSERT INTO `zhihu_node` VALUES ('5', '浏览角色', 'role', 'index', '1');
INSERT INTO `zhihu_node` VALUES ('6', '添加角色', 'role', 'add', '1');
INSERT INTO `zhihu_node` VALUES ('7', '删除角色', 'role', 'del', '1');
INSERT INTO `zhihu_node` VALUES ('8', '编辑角色', 'role', 'edit', '1');
INSERT INTO `zhihu_node` VALUES ('9', '浏览节点', 'node', 'index', '1');
INSERT INTO `zhihu_node` VALUES ('10', '添加节点', 'node', 'add', '1');
INSERT INTO `zhihu_node` VALUES ('11', '删除节点', 'node', 'del', '1');
INSERT INTO `zhihu_node` VALUES ('12', '修改节点', 'node', 'edit', '1');
INSERT INTO `zhihu_node` VALUES ('13', '浏览用户分配角色', 'ad', 'rolelist', '1');
INSERT INTO `zhihu_node` VALUES ('14', '更改用户分配角色', 'ad', 'role_save', '1');
INSERT INTO `zhihu_node` VALUES ('15', '浏览角色的操作权限', 'role', 'nodelist', '1');
INSERT INTO `zhihu_node` VALUES ('16', '修改角色中操作权限', 'role', 'savenode', '1');
INSERT INTO `zhihu_node` VALUES ('17', '角色状态', 'role', 'role_status', '1');
INSERT INTO `zhihu_node` VALUES ('18', '节点状态', 'node', 'node_status', '1');
INSERT INTO `zhihu_node` VALUES ('19', '浏览用户', 'ad', 'index', '1');
INSERT INTO `zhihu_node` VALUES ('20', '添加用户', 'ad', 'add', '1');
INSERT INTO `zhihu_node` VALUES ('21', '删除用户', 'ad', 'del', '1');
INSERT INTO `zhihu_node` VALUES ('22', '修改用户', 'ad', 'edit', '1');
INSERT INTO `zhihu_node` VALUES ('23', '后台用户切换状态', 'ad', 'ad_denied', '1');
INSERT INTO `zhihu_node` VALUES ('24', '后台主页', 'index', 'index', '1');
INSERT INTO `zhihu_node` VALUES ('25', '浏览问题', 'question', 'index', '1');
INSERT INTO `zhihu_node` VALUES ('26', '切换问题状态', 'question', 'qs_display', '1');
INSERT INTO `zhihu_node` VALUES ('27', '切换问题举报', 'question', 'report', '1');
INSERT INTO `zhihu_node` VALUES ('28', '问题列表', 'question', 'edit', '1');

-- ----------------------------
-- Table structure for zhihu_ptopic
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_ptopic`;
CREATE TABLE `zhihu_ptopic` (
  `topic_id` int(10) unsigned NOT NULL,
  `other_pid` int(10) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_ptopic
-- ----------------------------

-- ----------------------------
-- Table structure for zhihu_question
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_question`;
CREATE TABLE `zhihu_question` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `content` varchar(255) DEFAULT NULL,
  `topic_id` int(10) unsigned NOT NULL,
  `topic_name` varchar(255) DEFAULT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `user_name` varchar(255) DEFAULT NULL,
  `answer_num` int(10) unsigned NOT NULL DEFAULT '0',
  `attend_num` int(10) unsigned NOT NULL DEFAULT '0',
  `hot` tinyint(4) DEFAULT '0',
  `display` tinyint(4) NOT NULL DEFAULT '1',
  `report` tinyint(4) NOT NULL DEFAULT '0',
  `datetime` datetime NOT NULL,
  `visitors` int(255) NOT NULL DEFAULT '0',
  `is_delete` tinyint(4) DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_question
-- ----------------------------
INSERT INTO `zhihu_question` VALUES ('1', '如何使用知乎?', '...', '3', '互联网', '3', 'test1', '2', '1', '0', '0', '1', '2016-08-07 15:49:09', '0', '1');
INSERT INTO `zhihu_question` VALUES ('2', '有哪些游戏能够增长语文，数学或英语知识？', '...', '1', '游戏', '3', 'test1', '1', '0', '0', '0', '0', '2016-08-07 17:03:52', '0', '1');
INSERT INTO `zhihu_question` VALUES ('3', '魔戒，魔兽世界，冰与火，星球大战，漫威这五个系列哪个背景更完整？', '这五个系列，哪一个背景更完整体系更宏大，人物更丰富，地位更高，粉丝更多？', '1', '游戏', '3', 'test1', '1', '1', '0', '0', '1', '2016-08-07 17:11:30', '0', '1');
INSERT INTO `zhihu_question` VALUES ('4', '游戏里的 BOSS 每天都在干嘛？不寂寞吗？', '...', '1', '游戏', '3', 'test1', '1', '1', '0', '1', '0', '2016-08-07 17:16:08', '0', '1');
INSERT INTO `zhihu_question` VALUES ('5', '如何看待澳洲游泳运动员霍顿称孙杨为磕药骗子一事？', '孙杨遗憾摘银，澳洲霍顿摘金，赛后霍顿评价孙杨为“磕药骗子”，怎样看待这一事件，中国是否与俄罗斯一样也存在兴奋剂的问题。', '2', '运动', '3', 'test1', '2', '1', '0', '1', '0', '2016-08-07 19:05:12', '0', '0');
INSERT INTO `zhihu_question` VALUES ('6', '《盗墓笔记》电影版和《寻龙诀》相比差在哪里？', '我看过盗笔的原著，但是没看过鬼吹灯。觉得寻龙诀各方面都达到了比较高的水平，但是盗笔电影版其实人物演的还行。。但整个剧情简直不能忍。想问问大家怎么评价这两部电影。\r\n\r\n再加一个问题：《盗墓笔记》《九层妖塔》《寻龙诀》之间的差距有多大？', '21', '电影', '7', 'test3', '3', '2', '0', '1', '0', '2016-08-07 20:23:16', '0', '0');
INSERT INTO `zhihu_question` VALUES ('7', 'PHP', 'PHP语言', '3', '互联网', '8', '闫世亮', '0', '1', '0', '1', '0', '2016-08-08 09:59:39', '0', '0');
INSERT INTO `zhihu_question` VALUES ('8', '十年来，编程领域有什么重要进展？', '1', '3', '互联网', '3', 'test1', '2', '1', '0', '1', '0', '2016-08-08 10:04:19', '0', '0');
INSERT INTO `zhihu_question` VALUES ('9', '你听过最能引起共鸣的话是什么？', '如题', '37', '文学', '6', 'lixiaoge', '1', '1', '0', '1', '0', '2016-08-08 11:47:08', '0', '0');
INSERT INTO `zhihu_question` VALUES ('10', '为什么很多人更愿意去咖啡馆看书、写作、工作', '很多人把原因归结为安静，但大多数人家里比咖啡馆更安静呀', '9', '生活方式', '6', 'lixiaoge', '0', '1', '0', '1', '0', '2016-08-08 11:49:13', '0', '0');
INSERT INTO `zhihu_question` VALUES ('11', '你见过的国内最奇葩的游戏公司是哪个？', '我先来：广州西山居。\r\n\r\n理由：大规模裁撤之后，目前剩下两个工作室（第三个工作室即将裁撤）和一个美术中心。两个工作室加起来六七十人（本身有美术，工作时常需要外包，因为美术中心说自己很忙，没空），一个美术中心有一百多个美术（从不接外活，那么问题来了，美术中心的人在干嘛？）。\r\n意思是：美术占了公司三分之二的人数。\r\n\r\n一个从来不做事的美术中心总是声称自己很忙，在公司别的同事没有年终奖的情况下拿了六个月工资作为年终奖。你有什么感想？', '1', '游戏', '6', 'lixiaoge', '1', '1', '0', '1', '0', '2016-08-08 13:52:43', '0', '0');
INSERT INTO `zhihu_question` VALUES ('12', '减肥期间有哪些低脂又好吃方便的东西？', '可以代替早餐，又或者下午饿了零食什么的？', '2', '运动', '10', 'test5', '0', '1', '0', '1', '0', '2016-08-08 14:42:10', '0', '0');
INSERT INTO `zhihu_question` VALUES ('13', '如何评价 2016 年里约热内卢奥运会开幕式及点火仪式？', '奥运', '2', '运动', '10', 'test5', '2', '1', '0', '1', '0', '2016-08-08 14:43:42', '0', '0');
INSERT INTO `zhihu_question` VALUES ('14', '十年', '123', '1', '游戏', '3', 'test1', '1', '1', '0', '1', '0', '2016-08-08 15:37:55', '0', '0');

-- ----------------------------
-- Table structure for zhihu_question_topic
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_question_topic`;
CREATE TABLE `zhihu_question_topic` (
  `question_id` int(10) unsigned NOT NULL,
  `topic_id` int(10) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_question_topic
-- ----------------------------

-- ----------------------------
-- Table structure for zhihu_role
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_role`;
CREATE TABLE `zhihu_role` (
  `id` smallint(6) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(20) NOT NULL,
  `status` tinyint(1) unsigned DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_role
-- ----------------------------
INSERT INTO `zhihu_role` VALUES ('1', '神', '1', '最高权限');
INSERT INTO `zhihu_role` VALUES ('2', '项目经理', '1', '负责所有项目');
INSERT INTO `zhihu_role` VALUES ('3', '部门主任', '1', '负责当期部门管理');
INSERT INTO `zhihu_role` VALUES ('4', '普通员工', '1', '日常管理');
INSERT INTO `zhihu_role` VALUES ('5', '临时工', '1', '背锅');
INSERT INTO `zhihu_role` VALUES ('7', '维修工', '1', '没什么权限');
INSERT INTO `zhihu_role` VALUES ('8', '扫地大妈', '1', '也没权限');

-- ----------------------------
-- Table structure for zhihu_role_node
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_role_node`;
CREATE TABLE `zhihu_role_node` (
  `rid` smallint(6) unsigned NOT NULL,
  `nid` smallint(6) unsigned NOT NULL,
  KEY `groupId` (`rid`),
  KEY `nodeId` (`nid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_role_node
-- ----------------------------
INSERT INTO `zhihu_role_node` VALUES ('8', '1');
INSERT INTO `zhihu_role_node` VALUES ('8', '5');
INSERT INTO `zhihu_role_node` VALUES ('8', '9');
INSERT INTO `zhihu_role_node` VALUES ('8', '13');
INSERT INTO `zhihu_role_node` VALUES ('8', '24');

-- ----------------------------
-- Table structure for zhihu_special
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_special`;
CREATE TABLE `zhihu_special` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `datetime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_special
-- ----------------------------

-- ----------------------------
-- Table structure for zhihu_store
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_store`;
CREATE TABLE `zhihu_store` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sname` varchar(255) DEFAULT NULL,
  `fondcontent` varchar(255) DEFAULT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `is_private` tinyint(4) DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`sname`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_store
-- ----------------------------
INSERT INTO `zhihu_store` VALUES ('2', '小采集', 'heheh', '3', '1');
INSERT INTO `zhihu_store` VALUES ('4', 'hi', null, '5', '1');
INSERT INTO `zhihu_store` VALUES ('5', 'mnmnm', '121212', '5', '1');
INSERT INTO `zhihu_store` VALUES ('6', 'ww', null, '5', '0');
INSERT INTO `zhihu_store` VALUES ('9', '111', '1111', '6', '1');
INSERT INTO `zhihu_store` VALUES ('11', 'i miss', 'hhh', '3', '0');
INSERT INTO `zhihu_store` VALUES ('12', '游戏', 'hihi', '3', '1');

-- ----------------------------
-- Table structure for zhihu_topics
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_topics`;
CREATE TABLE `zhihu_topics` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `image` varchar(255) NOT NULL DEFAULT 'default_80.jpg',
  `detail` varchar(255) DEFAULT NULL,
  `attend_num` int(11) NOT NULL,
  `level` tinyint(3) unsigned NOT NULL,
  `pid` int(10) unsigned NOT NULL,
  `path` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_topics
-- ----------------------------
INSERT INTO `zhihu_topics` VALUES ('1', '游戏', '2016/08/07/45_2016080757a6eb09a3560.jpg', '游戏是一种基于物质满足之上的，在一种特定时间、空间范围内遵循某…', '6', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('2', '运动', '2016/08/07/45_2016080757a7157d6a1c1.jpg', '指身体的活动，一般以健身和娱乐为目的。', '2', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('3', '互联网', '2016/08/08/45_2016080857a817e3557b9.jpg', '互联网（英语：internet），是网络 与网络之间所串连成的庞大网络，这些网络以一组标准的网络TCP/IP协议族 相连，链接全世界几十亿个设备，形成逻辑上的单一巨大国际网络。这是一个网络的网络，它是由从地方到全球范围内几百万个私人的，学术界的，企业的和政府的网络所构成，通过电子，无线和光纤网络技术等等一系列广泛的技术联系在一起。这种将计算机网络互相联接在一起的方法可称作“网络互联”，在这基础上发展出覆盖全世界的全球性互联网络称互联网，即是互相连接一起的网络。', '5', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('4', '艺术', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('5', '阅读', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('6', '美食', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('7', '动漫', 'default_80.jpg', '动漫是动画和漫画的合称与缩写。随着现代传媒技术的发展，动画（animation / anime）和漫画（comics / manga，特别是故事性漫画）之间联系日趋紧密，两者常被合而为「动漫」。', '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('8', '汽车', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('9', '生活方式', 'default_80.jpg', '生活方式不是「生活」。', '1', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('10', '教育', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('11', '摄影', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('12', '历史', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('13', '文化', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('14', '旅行', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('15', '职业发展', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('16', '经济学', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('17', '足球', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('18', '篮球', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('19', '投资', 'default_80.jpg', '', '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('20', '音乐', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('21', '电影', 'default_80.jpg', null, '3', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('22', '法律', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('23', '自然科学', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('24', '设计', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('25', '创业', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('26', '健康', 'default_80.jpg', '健康是指一个人在身体、精神和社会等方面都处于良好的状态。', '1', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('27', '商业', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('28', '体育', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('29', '科技', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('30', '化学', 'default_80.jpg', null, '1', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('31', '物理学', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('32', '生物学', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('33', '金融', 'default_80.jpg', null, '0', '0', '0', '0,');
INSERT INTO `zhihu_topics` VALUES ('34', '知乎提问', 'default_80.jpg', null, '4', '1', '3', '0,3,');
INSERT INTO `zhihu_topics` VALUES ('37', '文学', '2016/08/08/45_2016080857a800ac96340.jpg', '文学...', '0', '0', '13', '0,13,');
INSERT INTO `zhihu_topics` VALUES ('38', '单机游戏', '2016/08/08/45_2016080857a8105de9e3a.jpg', '单机游戏（Single-Player Game），相对于联网游戏而言的单人游戏', '0', '0', '1', '0,1,');
INSERT INTO `zhihu_topics` VALUES ('39', '网络游戏', '2016/08/08/45_2016080857a8110d9bc6b.jpg', '网络游戏，也称在线游戏（Online Game），一般指多名玩家通过计算机网络互动娱乐的视频游戏。有战略游戏、动作游戏、体育游戏、格斗游戏、音乐游戏、竞速游戏、网页游戏和角色扮演游戏等多种类型，不过也有少数在线单人游戏。', '0', '0', '1', '0,1,');
INSERT INTO `zhihu_topics` VALUES ('40', '电子竞技', '2016/08/08/45_2016080857a811795968c.jpg', '电子竞技是指使用电脑游戏来比赛的体育项目。随着游戏对经济、社会不断加强的影响，电子竞技正式成为体育竞技的一种。', '0', '0', '1', '0,1,');
INSERT INTO `zhihu_topics` VALUES ('41', '手机游戏', '2016/08/08/45_2016080857a811ecbe246.jpg', '手机游戏是指运行在手机等移动设备上的游戏软件。', '0', '0', '1', '0,1,');
INSERT INTO `zhihu_topics` VALUES ('42', '游戏设计', '2016/08/08/45_2016080857a8122ed603a.jpg', '游戏设计', '0', '0', '1', '0,1,');
INSERT INTO `zhihu_topics` VALUES ('43', '英雄联盟 ', '2016/08/08/45_2016080857a812a86729a.jpg', 'lol', '0', '0', '1', '0,1,');
INSERT INTO `zhihu_topics` VALUES ('44', '魔兽世界', '2016/08/08/45_2016080857a812fad85ff.jpg', '《魔兽世界》（World of Warcraft、简称 WoW 或魔兽）是著名的游戏公司暴雪娱乐（Blizzard Entertainment）所制作的一款大型多人在线角色扮演游戏（MMORPG），于 2004 年年中在北美公开测试。', '0', '0', '1', '0,1,');

-- ----------------------------
-- Table structure for zhihu_user
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_user`;
CREATE TABLE `zhihu_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `pass` char(32) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `tel` char(11) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `private` tinyint(4) DEFAULT '1',
  `denied` tinyint(4) DEFAULT '1',
  `regtime` datetime DEFAULT NULL,
  `letter_a` tinyint(4) NOT NULL DEFAULT '2',
  `stranger` tinyint(4) NOT NULL DEFAULT '0',
  `invite_a` tinyint(4) NOT NULL DEFAULT '1',
  `question_a` tinyint(4) NOT NULL DEFAULT '2',
  `discuss_a` tinyint(4) NOT NULL DEFAULT '0',
  `thanks_a` tinyint(4) NOT NULL DEFAULT '0',
  `zan_discuss` tinyint(4) NOT NULL DEFAULT '0',
  `zan_article` tinyint(4) NOT NULL DEFAULT '0',
  `attend_a` tinyint(4) NOT NULL DEFAULT '0',
  `attend_special` tinyint(4) NOT NULL DEFAULT '0',
  `receive_email` tinyint(4) NOT NULL DEFAULT '0',
  `choose` tinyint(4) NOT NULL DEFAULT '0',
  `notice` tinyint(4) NOT NULL DEFAULT '0',
  `image` varchar(255) NOT NULL DEFAULT 'default_80.jpg' COMMENT '头像图片名',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_user
-- ----------------------------
INSERT INTO `zhihu_user` VALUES ('1', '匿名用户', 'e10adc3949ba59abbe56e057f20f883e', 'jyqpj@163.com', '18345678901', 'jyqpj', '1', '0', '2016-07-21 16:15:00', '2', '0', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'default_80.jpg');
INSERT INTO `zhihu_user` VALUES ('2', '知乎管理', 'e10adc3949ba59abbe56e057f20f883e', null, '13621900861', null, '1', '1', '2016-08-04 16:04:06', '2', '0', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'default_80.jpg');
INSERT INTO `zhihu_user` VALUES ('3', 'test1', 'e10adc3949ba59abbe56e057f20f883e', null, '18012345678', null, '1', '1', '2016-08-08 11:22:05', '2', '0', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2016/08/08/2016080857a7ee6f99798.png');
INSERT INTO `zhihu_user` VALUES ('4', 'test2', 'e10adc3949ba59abbe56e057f20f883e', null, '18011112222', null, '1', '1', '2016-08-07 16:11:46', '2', '0', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2016/08/08/2016080857a7f9cf34c65.jpg');
INSERT INTO `zhihu_user` VALUES ('5', 'zxy', 'e10adc3949ba59abbe56e057f20f883e', null, '15923332222', null, '1', '1', '2016-08-07 16:44:13', '2', '0', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2016/08/08/2016080857a81407aeb7f.jpg');
INSERT INTO `zhihu_user` VALUES ('6', 'lixiaoge', 'e10adc3949ba59abbe56e057f20f883e', null, '18011112222', null, '1', '1', '2016-08-08 12:12:34', '2', '0', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2016/08/08/2016080857a806bf80757.jpg');
INSERT INTO `zhihu_user` VALUES ('7', 'test3', 'e10adc3949ba59abbe56e057f20f883e', null, '18012345678', null, '1', '1', '2016-08-07 19:05:45', '2', '0', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'default_80.jpg');
INSERT INTO `zhihu_user` VALUES ('8', '闫世亮', 'e10adc3949ba59abbe56e057f20f883e', null, '13621900861', null, '1', '1', '2016-08-08 09:56:00', '2', '0', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'default_80.jpg');
INSERT INTO `zhihu_user` VALUES ('9', '老司机', '14e1b600b1fd579f47433b88e8d85291', '522690693@qq.com', '15923332222', null, '1', '0', '2016-08-08 11:03:24', '2', '0', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'default_80.jpg');
INSERT INTO `zhihu_user` VALUES ('10', 'test5', 'e10adc3949ba59abbe56e057f20f883e', null, '18012345678', null, '1', '1', '2016-08-08 14:32:13', '2', '0', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'default_80.jpg');
INSERT INTO `zhihu_user` VALUES ('11', 'admin', '7fef6171469e80d32c0559f88b377245', null, '18012345678', null, '1', '1', '2016-08-08 15:59:22', '2', '0', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'default_80.jpg');

-- ----------------------------
-- Table structure for zhihu_userinfo
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_userinfo`;
CREATE TABLE `zhihu_userinfo` (
  `id` int(10) unsigned NOT NULL,
  `sex` tinyint(4) DEFAULT '0',
  `mbshow` tinyint(4) DEFAULT '0',
  `say` varchar(255) DEFAULT NULL,
  `introduction` varchar(255) DEFAULT NULL,
  `vocation` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `company` varchar(255) DEFAULT NULL,
  `position` varchar(255) DEFAULT NULL,
  `school` varchar(255) DEFAULT NULL,
  `major` varchar(255) DEFAULT NULL,
  `goodat` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_userinfo
-- ----------------------------
INSERT INTO `zhihu_userinfo` VALUES ('3', '1', '0', '', '一个人疯疯癫癫跌跌撞撞的一路走来', '', '', '上海贝兹文化传媒公司', '模型师', '山东广播电视学院', '动漫设计', 'computer');
INSERT INTO `zhihu_userinfo` VALUES ('4', '0', '0', null, null, null, null, null, null, null, null, null);
INSERT INTO `zhihu_userinfo` VALUES ('5', '0', '0', null, null, null, null, null, null, null, null, null);
INSERT INTO `zhihu_userinfo` VALUES ('6', '1', '0', '男', '123123', '123', '坦克', '', '', '', '', '');
INSERT INTO `zhihu_userinfo` VALUES ('7', '0', '0', null, null, null, null, null, null, null, null, null);
INSERT INTO `zhihu_userinfo` VALUES ('8', '1', '0', '缘似浪', '', 'php', '上海', '', '', '', '', '');
INSERT INTO `zhihu_userinfo` VALUES ('10', '0', '0', null, null, null, null, null, null, null, null, null);
INSERT INTO `zhihu_userinfo` VALUES ('11', '0', '0', null, null, null, null, null, null, null, null, null);

-- ----------------------------
-- Table structure for zhihu_user_question
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_user_question`;
CREATE TABLE `zhihu_user_question` (
  `user_id` int(10) unsigned NOT NULL,
  `question_id` int(10) unsigned NOT NULL,
  `datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_user_question
-- ----------------------------
INSERT INTO `zhihu_user_question` VALUES ('4', '1', '2016-08-07 16:13:15');
INSERT INTO `zhihu_user_question` VALUES ('3', '5', '2016-08-07 19:05:12');
INSERT INTO `zhihu_user_question` VALUES ('7', '6', '2016-08-07 20:23:16');
INSERT INTO `zhihu_user_question` VALUES ('8', '6', '2016-08-08 09:58:54');
INSERT INTO `zhihu_user_question` VALUES ('8', '4', '2016-08-08 09:58:57');
INSERT INTO `zhihu_user_question` VALUES ('8', '3', '2016-08-08 09:58:59');
INSERT INTO `zhihu_user_question` VALUES ('8', '7', '2016-08-08 09:59:39');
INSERT INTO `zhihu_user_question` VALUES ('6', '9', '2016-08-08 11:47:08');
INSERT INTO `zhihu_user_question` VALUES ('6', '10', '2016-08-08 11:49:13');
INSERT INTO `zhihu_user_question` VALUES ('6', '11', '2016-08-08 13:52:43');
INSERT INTO `zhihu_user_question` VALUES ('10', '12', '2016-08-08 14:42:10');
INSERT INTO `zhihu_user_question` VALUES ('10', '13', '2016-08-08 14:43:42');
INSERT INTO `zhihu_user_question` VALUES ('3', '14', '2016-08-08 15:37:55');

-- ----------------------------
-- Table structure for zhihu_user_role
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_user_role`;
CREATE TABLE `zhihu_user_role` (
  `rid` mediumint(9) unsigned DEFAULT NULL,
  `uid` int(6) unsigned NOT NULL,
  KEY `group_id` (`rid`),
  KEY `user_id` (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_user_role
-- ----------------------------
INSERT INTO `zhihu_user_role` VALUES ('8', '2');

-- ----------------------------
-- Table structure for zhihu_user_topic
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_user_topic`;
CREATE TABLE `zhihu_user_topic` (
  `user_id` int(10) unsigned NOT NULL,
  `topic_id` int(10) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_user_topic
-- ----------------------------
INSERT INTO `zhihu_user_topic` VALUES ('4', '3');
INSERT INTO `zhihu_user_topic` VALUES ('4', '34');
INSERT INTO `zhihu_user_topic` VALUES ('6', '2');
INSERT INTO `zhihu_user_topic` VALUES ('6', '3');
INSERT INTO `zhihu_user_topic` VALUES ('6', '34');
INSERT INTO `zhihu_user_topic` VALUES ('6', '1');
INSERT INTO `zhihu_user_topic` VALUES ('7', '1');
INSERT INTO `zhihu_user_topic` VALUES ('7', '21');
INSERT INTO `zhihu_user_topic` VALUES ('8', '1');
INSERT INTO `zhihu_user_topic` VALUES ('8', '34');
INSERT INTO `zhihu_user_topic` VALUES ('8', '3');
INSERT INTO `zhihu_user_topic` VALUES ('8', '9');
INSERT INTO `zhihu_user_topic` VALUES ('8', '21');
INSERT INTO `zhihu_user_topic` VALUES ('3', '3');
INSERT INTO `zhihu_user_topic` VALUES ('6', '21');
INSERT INTO `zhihu_user_topic` VALUES ('3', '1');
INSERT INTO `zhihu_user_topic` VALUES ('4', '1');

-- ----------------------------
-- Table structure for zhihu_user_user
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_user_user`;
CREATE TABLE `zhihu_user_user` (
  `user_id` int(10) unsigned NOT NULL,
  `attended_id` int(10) unsigned NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_user_user
-- ----------------------------
INSERT INTO `zhihu_user_user` VALUES ('4', '3');
INSERT INTO `zhihu_user_user` VALUES ('8', '3');
INSERT INTO `zhihu_user_user` VALUES ('8', '4');
INSERT INTO `zhihu_user_user` VALUES ('8', '8');
INSERT INTO `zhihu_user_user` VALUES ('3', '8');
INSERT INTO `zhihu_user_user` VALUES ('3', '4');
INSERT INTO `zhihu_user_user` VALUES ('3', '6');

-- ----------------------------
-- Table structure for zhihu_vocation
-- ----------------------------
DROP TABLE IF EXISTS `zhihu_vocation`;
CREATE TABLE `zhihu_vocation` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `pid` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=112 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhihu_vocation
-- ----------------------------
INSERT INTO `zhihu_vocation` VALUES ('1', '高新科技', '0,');
INSERT INTO `zhihu_vocation` VALUES ('2', '信息传媒', '0,');
INSERT INTO `zhihu_vocation` VALUES ('3', '金融', '0,');
INSERT INTO `zhihu_vocation` VALUES ('4', '服务业', '0,');
INSERT INTO `zhihu_vocation` VALUES ('5', '教育', '0,');
INSERT INTO `zhihu_vocation` VALUES ('6', '医疗服务', '0,');
INSERT INTO `zhihu_vocation` VALUES ('7', '艺术娱乐', '0,');
INSERT INTO `zhihu_vocation` VALUES ('8', '制造加工', '0,');
INSERT INTO `zhihu_vocation` VALUES ('9', '地产建筑', '0,');
INSERT INTO `zhihu_vocation` VALUES ('10', '贸易零售', '0,');
INSERT INTO `zhihu_vocation` VALUES ('11', '公共服务', '0,');
INSERT INTO `zhihu_vocation` VALUES ('12', '开采冶金', '0,');
INSERT INTO `zhihu_vocation` VALUES ('13', '交通仓储', '0,');
INSERT INTO `zhihu_vocation` VALUES ('14', '农林牧渔', '0,');
INSERT INTO `zhihu_vocation` VALUES ('15', '互联网', '0,1,');
INSERT INTO `zhihu_vocation` VALUES ('16', '电子商务', '0,1,');
INSERT INTO `zhihu_vocation` VALUES ('17', '电子游戏', '0,1,');
INSERT INTO `zhihu_vocation` VALUES ('18', '计算机软件', '0,1,');
INSERT INTO `zhihu_vocation` VALUES ('19', '计算机硬件', '0,1,');
INSERT INTO `zhihu_vocation` VALUES ('20', '出版业', '0,2,');
INSERT INTO `zhihu_vocation` VALUES ('21', '电影录音', '0,2,');
INSERT INTO `zhihu_vocation` VALUES ('22', '广播电视', '0,2,');
INSERT INTO `zhihu_vocation` VALUES ('23', '通信', '0,2,');
INSERT INTO `zhihu_vocation` VALUES ('24', '银行', '0,3,');
INSERT INTO `zhihu_vocation` VALUES ('25', '资本投资', '0,3,');
INSERT INTO `zhihu_vocation` VALUES ('26', '证券投资', '0,3,');
INSERT INTO `zhihu_vocation` VALUES ('27', '保险', '0,3,');
INSERT INTO `zhihu_vocation` VALUES ('28', '信贷', '0,3,');
INSERT INTO `zhihu_vocation` VALUES ('29', '财务', '0,3,');
INSERT INTO `zhihu_vocation` VALUES ('30', '审计', '0,3,');
INSERT INTO `zhihu_vocation` VALUES ('31', '法律', '0,4,');
INSERT INTO `zhihu_vocation` VALUES ('32', '餐饮', '0,4,');
INSERT INTO `zhihu_vocation` VALUES ('33', '酒店', '0,4,');
INSERT INTO `zhihu_vocation` VALUES ('34', '旅游', '0,4,');
INSERT INTO `zhihu_vocation` VALUES ('35', '广告', '0,4,');
INSERT INTO `zhihu_vocation` VALUES ('36', '公关', '0,4,');
INSERT INTO `zhihu_vocation` VALUES ('37', '景观', '0,4,');
INSERT INTO `zhihu_vocation` VALUES ('38', '咨询分析', '0,4,');
INSERT INTO `zhihu_vocation` VALUES ('39', '市场推广', '0,4,');
INSERT INTO `zhihu_vocation` VALUES ('40', '人力资源', '0,4,');
INSERT INTO `zhihu_vocation` VALUES ('41', '社工服务', '0,4,');
INSERT INTO `zhihu_vocation` VALUES ('42', '养老服务', '0,4,');
INSERT INTO `zhihu_vocation` VALUES ('43', '高等教育', '0,5,');
INSERT INTO `zhihu_vocation` VALUES ('44', '基础教育', '0,5,');
INSERT INTO `zhihu_vocation` VALUES ('45', '职业教育', '0,5,');
INSERT INTO `zhihu_vocation` VALUES ('46', '幼儿教育', '0,5,');
INSERT INTO `zhihu_vocation` VALUES ('47', '特殊教育', '0,5,');
INSERT INTO `zhihu_vocation` VALUES ('48', '培训', '0,5,');
INSERT INTO `zhihu_vocation` VALUES ('49', '临床医疗', '0,6,');
INSERT INTO `zhihu_vocation` VALUES ('50', '制药', '0,6,');
INSERT INTO `zhihu_vocation` VALUES ('51', '保健', '0,6,');
INSERT INTO `zhihu_vocation` VALUES ('52', '美容', '0,6,');
INSERT INTO `zhihu_vocation` VALUES ('53', '医疗器材', '0,6,');
INSERT INTO `zhihu_vocation` VALUES ('54', '生物工程', '0,6,');
INSERT INTO `zhihu_vocation` VALUES ('55', '疗养服务', '0,6,');
INSERT INTO `zhihu_vocation` VALUES ('56', '护理服务', '0,6,');
INSERT INTO `zhihu_vocation` VALUES ('57', '创意艺术', '0,7,');
INSERT INTO `zhihu_vocation` VALUES ('58', '体育健身', '0,7,');
INSERT INTO `zhihu_vocation` VALUES ('59', '娱乐休闲', '0,7,');
INSERT INTO `zhihu_vocation` VALUES ('60', '图书馆', '0,7,');
INSERT INTO `zhihu_vocation` VALUES ('61', '博物', '0,7,');
INSERT INTO `zhihu_vocation` VALUES ('62', '博彩', '0,7,');
INSERT INTO `zhihu_vocation` VALUES ('63', '食品饮料业', '0,8,');
INSERT INTO `zhihu_vocation` VALUES ('64', '纺织皮革业', '0,8,');
INSERT INTO `zhihu_vocation` VALUES ('65', '服装业', '0,8,');
INSERT INTO `zhihu_vocation` VALUES ('66', '烟草业', '0,8,');
INSERT INTO `zhihu_vocation` VALUES ('67', '造纸业', '0,8,');
INSERT INTO `zhihu_vocation` VALUES ('68', '印刷业', '0,8,');
INSERT INTO `zhihu_vocation` VALUES ('69', '化工业', '0,8,');
INSERT INTO `zhihu_vocation` VALUES ('70', '汽车', '0,8,');
INSERT INTO `zhihu_vocation` VALUES ('71', '家具', '0,8,');
INSERT INTO `zhihu_vocation` VALUES ('72', '电子电器', '0,8,');
INSERT INTO `zhihu_vocation` VALUES ('73', '机械设备', '0,8,');
INSERT INTO `zhihu_vocation` VALUES ('74', '塑料工业', '0,8,');
INSERT INTO `zhihu_vocation` VALUES ('75', '金属加工', '0,8,');
INSERT INTO `zhihu_vocation` VALUES ('76', '军火', '0,8,');
INSERT INTO `zhihu_vocation` VALUES ('77', '房地产', '0,9,');
INSERT INTO `zhihu_vocation` VALUES ('78', '装饰装潢', '0,9,');
INSERT INTO `zhihu_vocation` VALUES ('79', '物业服务', '0,9,');
INSERT INTO `zhihu_vocation` VALUES ('80', '特殊建造', '0,9,');
INSERT INTO `zhihu_vocation` VALUES ('81', '建筑设备', '0,9,');
INSERT INTO `zhihu_vocation` VALUES ('82', '零售', '0,10,');
INSERT INTO `zhihu_vocation` VALUES ('83', '大宗交易', '0,10,');
INSERT INTO `zhihu_vocation` VALUES ('84', '进出口贸易', '0,10,');
INSERT INTO `zhihu_vocation` VALUES ('85', '政府', '0,11,');
INSERT INTO `zhihu_vocation` VALUES ('86', '国防军事', '0,11,');
INSERT INTO `zhihu_vocation` VALUES ('87', '航天', '0,11,');
INSERT INTO `zhihu_vocation` VALUES ('88', '科研', '0,11,');
INSERT INTO `zhihu_vocation` VALUES ('89', '给排水', '0,11,');
INSERT INTO `zhihu_vocation` VALUES ('90', '水利能源', '0,11,');
INSERT INTO `zhihu_vocation` VALUES ('91', '电力电网', '0,11,');
INSERT INTO `zhihu_vocation` VALUES ('92', '公共管理', '0,11,');
INSERT INTO `zhihu_vocation` VALUES ('93', '环境保护', '0,11,');
INSERT INTO `zhihu_vocation` VALUES ('94', '非营利组织', '0,11,');
INSERT INTO `zhihu_vocation` VALUES ('95', '煤炭工业', '0,12,');
INSERT INTO `zhihu_vocation` VALUES ('96', '石油工业', '0,12,');
INSERT INTO `zhihu_vocation` VALUES ('97', '黑色金属', '0,12,');
INSERT INTO `zhihu_vocation` VALUES ('98', '有色金属', '0,12,');
INSERT INTO `zhihu_vocation` VALUES ('99', '土砂石开采', '0,12,');
INSERT INTO `zhihu_vocation` VALUES ('100', '地热开采', '0,12,');
INSERT INTO `zhihu_vocation` VALUES ('101', '邮政', '0,13,');
INSERT INTO `zhihu_vocation` VALUES ('102', '物流递送', '0,13,');
INSERT INTO `zhihu_vocation` VALUES ('103', '地面运输', '0,13,');
INSERT INTO `zhihu_vocation` VALUES ('104', '铁路运输', '0,13,');
INSERT INTO `zhihu_vocation` VALUES ('105', '管线运输', '0,13,');
INSERT INTO `zhihu_vocation` VALUES ('106', '航运业', '0,13,');
INSERT INTO `zhihu_vocation` VALUES ('107', '民用航空业', '0,13,');
INSERT INTO `zhihu_vocation` VALUES ('108', '种植业', '0,14,');
INSERT INTO `zhihu_vocation` VALUES ('109', '畜牧养殖业', '0,14,');
INSERT INTO `zhihu_vocation` VALUES ('110', '林业', '0,14,');
INSERT INTO `zhihu_vocation` VALUES ('111', '渔业', '0,14,');