/*
  Navicat MySQL Data Transfer
  Source Server: localhost_psy_3306
  Source Server Version:50711
  Source Host: localhost:3306
  Source Database: psyblog

  Target Server Type: MYSQL
  Target Server Version:50711
  File Encoding:utf-8

  Date: 
*/

SET FOREIGN_KEY_CHECKS=0;
-- --------------------------------
-- Table structure for psy_article
-- --------------------------------
DROP TABLE IF EXISTS `psy_article`;
CREATE TABLE `psy_article` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `abstract` text,
  `content` text NOT NULL,
  `picurl` varchar(255) DEFAULT NULL,
  `author` varchar(255) DEFAULT NULL,
  `createtime` datetime DEFAULT NULL,
  `view` bigint(20) DEFAULT '1',
  `totop` smallint(6) DEFAULT '0',
  `torecom` smallint(6) DEFAULT '0',
  `topicrecom` smallint(6) DEFAULT '0',
  `tag` int(11) DEFAULT NULL,
  `keywords` varchar(255) DEFAULT NULL,
  `allowcomment` int(11) DEFAULT '1',
  `ispublished` int(11) DEFAULT '0',
  `from` varchar(255) DEFAULT NULL,
  `item` int(11) DEFAULT NULL,
  `like` int(11) DEFAULT '0' COMMENT '喜欢',
  `flag_a` smallint(255) DEFAULT '0',
  `flag_b` smallint(255) DEFAULT '0',
  `flag_c` smallint(255) DEFAULT '0',
  `flag_d` smallint(255) DEFAULT '0',
  PRIMARY KEY(`id`)
) ENGINE=MyISAM AUTO_INCREMENT=420 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of psy_article
-- ----------------------------
INSERT INTO `psy_article` VALUES ('111', '社会心理学','ss','aaaaa','static/upload/pics/8/6/2016sS0SWY9BOhOiFqyMDzDpTmLP.png','Baude','2018-06-13 12:00:00','111','0','0','0','14','1','1','1','','6','0',null,null,null,null);

-- -------------------------------
-- Table structure for psy_comment
-- -------------------------------
DROP TABLE IF EXISTS `psy_comment`;
CREATE TABLE `psy_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `aid` int(11) DEFAULT NULL COMMENT 'article id',
  `author` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `email` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `qq` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `comment` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `belongid` int(11) DEFAULT '0' COMMENT '回复的评论id',
  `dig` int(11) DEFAULT '0',
  `tipoff` int(11) DEFAULT '0' COMMENT '举报',
  `createtime` datetime DEFAULT NULL,
  `pic` varchar(255) COLLATE utf8_bin DEFAULT '' COMMENT '头像',
  PRIMARY KEY(`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- -------------------------
-- Records of psy_comment
-- -------------------------

-- -----------------------------
-- Table structure for psy_guest
-- -----------------------------
DROP TABLE IF EXISTS `psy_guest`;
CREATE TABLE `psy_guest` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nickname` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `contact` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `guest` varchar(255) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------
-- Records of psy_guest
-- --------------------
INSERT INTO `psy_guest` VALUES ('33','s','是','搜索');
INSERT INTO `psy_guest` VALUES ('34','范德萨发史蒂夫','的说法是否','你好');
INSERT INTO `psy_guest` VALUES ('35','南瓜法师','806323472@qq.com','我申请了交换友情链接');

-- ----------------------------
-- Table structure for psy_item
-- ----------------------------
DROP TABLE IF EXISTS `psy_item`;
CREATE TABLE `psy_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `itemname` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

-- -------------------
-- Records of psy_item
-- -------------------
INSERT INTO `psy_item` VALUES ('1','Article');
INSERT INTO `psy_item` VALUES ('2','心理分类');
INSERT INTO `psy_item` VALUES ('3','心理常识');
INSERT INTO `psy_item` VALUES ('4','心理现象');
INSERT INTO `psy_item` VALUES ('5','心理简讯');
INSERT INTO `psy_item` VALUES ('6','心理名人录');
INSERT INTO `psy_item` VALUES ('7','最新心理研究');

-- -----------------------------
-- Table structure for psy_links
-- -----------------------------
DROP TABLE IF EXISTS `psy_links`;
CREATE TABLE `psy_links` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `domain` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `link` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `qq` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `notice` varchar(255) COLLATE utf8_bin DEFAULT NULL,
  `flag` varchar(255) COLLATE utf8_bin DEFAULT '0' COMMENT '是否通过',
  `orders` int(255) DEFAULT '0' COMMENT '顺序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- --------------------
-- Records of psy_links
-- --------------------
INSERT INTO `psy_links` VALUES ('4','小站','www.imenger.cn','http://www.imenger.cn','1193288577','','0','0');
INSERT INTO `psy_links` VALUES ('5','Magento','www.maijindou.com','','',null,'1','0');
INSERT INTO `psy_links` VALUES ('13','Yii中文网','www.yii-china.com','','',null,'1','1');

-- -----------------------------------------
-- Table structure for psy_manage_permission
-- -----------------------------------------
DROP TABLE IF EXISTS `psy_manage_permission`;
CREATE TABLE `psy_manage_permission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `pername` varchar(255) DEFAULT NULL,
  `permission` text,
  `tag` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=70 DEFAULT CHARSET=utf8;

-- --------------------------------
-- Records of psy_manage_permission
-- --------------------------------
INSERT INTO `psy_manage_permission` VALUES ('1', '新建/编辑文章', 'admin/content/article', '1');
INSERT INTO `psy_manage_permission` VALUES ('2', '添加markdown', 'admin/content/addmarkdown', '1');
INSERT INTO `psy_manage_permission` VALUES ('3', '文章列表', 'admin/content/index', '1');
INSERT INTO `psy_manage_permission` VALUES ('7', '后台首页', 'admin/index/index', '4');
INSERT INTO `psy_manage_permission` VALUES ('8', '后台欢迎页', 'admin/index/welcome', '4');
INSERT INTO `psy_manage_permission` VALUES ('9', '草稿箱文章列表', 'admin/content/draftlist', '1');
INSERT INTO `psy_manage_permission` VALUES ('10', '新增/编辑文章提交接口', 'admin/content/doadd', '1');
INSERT INTO `psy_manage_permission` VALUES ('11', '草稿箱发布接口', 'admin/content/updatestatus', '1');
INSERT INTO `psy_manage_permission` VALUES ('12', '删除/批量删除文章接口', 'admin/content/delsome', '1');
INSERT INTO `psy_manage_permission` VALUES ('13', '上传文章缩略图接口', 'admin/content/upload', '1');
INSERT INTO `psy_manage_permission` VALUES ('14', '上传编辑器图片接口', 'admin/content/uploadeditor', '1');
INSERT INTO `psy_manage_permission` VALUES ('15', '上传markdown文件及解析接口/内容分页', 'admin/content/uploadfile', '1');
INSERT INTO `psy_manage_permission` VALUES ('16', '留言列表', 'admin/guest/index', '5');
INSERT INTO `psy_manage_permission` VALUES ('17', '删除/批量留言接口', 'admin/guest/delsome', '5');
INSERT INTO `psy_manage_permission` VALUES ('18', '退出后台接口', 'admin/index/logout', '4');
INSERT INTO `psy_manage_permission` VALUES ('19', '栏目列表', 'admin/item/index', '6');
INSERT INTO `psy_manage_permission` VALUES ('20', '新增/编辑栏目', 'admin/item/item', '6');
INSERT INTO `psy_manage_permission` VALUES ('21', '新增/编辑栏目接口', 'admin/item/save', '6');
INSERT INTO `psy_manage_permission` VALUES ('22', '删除/批量删除栏目接口', 'admin/item/delsome', '6');
INSERT INTO `psy_manage_permission` VALUES ('23', '申请列表', 'admin/links/index', '14');
INSERT INTO `psy_manage_permission` VALUES ('24', '删除/批量删除友情链接接口', 'admin/links/delsome', '14');
INSERT INTO `psy_manage_permission` VALUES ('25', '导航列表', 'admin/menu/index', '2');
INSERT INTO `psy_manage_permission` VALUES ('26', '新增/编辑导航', 'admin/menu/item', '2');
INSERT INTO `psy_manage_permission` VALUES ('27', '编辑/新增导航接口', 'admin/menu/save', '2');
INSERT INTO `psy_manage_permission` VALUES ('28', '删除/批量删除导航接口', 'admin/menu/delsome', '2');
INSERT INTO `psy_manage_permission` VALUES ('29', '权限列表', 'admin/permission/index', '10');
INSERT INTO `psy_manage_permission` VALUES ('30', '新增/编辑权限', 'admin/permission/item', '10');
INSERT INTO `psy_manage_permission` VALUES ('31', '编辑/新增权限接口', 'admin/permission/save', '10');
INSERT INTO `psy_manage_permission` VALUES ('32', '删除/批量删除权限接口', 'admin/permission/delsome', '10');
INSERT INTO `psy_manage_permission` VALUES ('33', '权限分类列表', 'admin/pertag/index', '10');
INSERT INTO `psy_manage_permission` VALUES ('34', '新增/编辑权限分类', 'admin/pertag/item', '10');
INSERT INTO `psy_manage_permission` VALUES ('35', '编辑/新增权限分类接口', 'admin/pertag/save', '10');
INSERT INTO `psy_manage_permission` VALUES ('36', '删除/批量删除权限分类接口', 'admin/pertag/delsome', '10');
INSERT INTO `psy_manage_permission` VALUES ('37', '角色列表', 'admin/role/index', '10');
INSERT INTO `psy_manage_permission` VALUES ('38', '新增/编辑角色', 'admin/role/item', '10');
INSERT INTO `psy_manage_permission` VALUES ('40', '删除/批量删除角色接口', 'admin/role/delsome', '10');
INSERT INTO `psy_manage_permission` VALUES ('41', '角色分配权限页', 'admin/role/perlist', '10');
INSERT INTO `psy_manage_permission` VALUES ('42', '角色分配权限保存接口', 'admin/role/rolesave', '10');
INSERT INTO `psy_manage_permission` VALUES ('43', '标签列表', 'admin/tag/index', '9');
INSERT INTO `psy_manage_permission` VALUES ('44', '新增/编辑标签', 'admin/tag/item', '9');
INSERT INTO `psy_manage_permission` VALUES ('45', '新增/编辑标签接口', 'admin/tag/save', '9');
INSERT INTO `psy_manage_permission` VALUES ('46', '删除/批量删除标签接口', 'admin/tag/delsome', '9');
INSERT INTO `psy_manage_permission` VALUES ('47', '用户列表', 'admin/user/index', '8');
INSERT INTO `psy_manage_permission` VALUES ('48', '新增/编辑用户', 'admin/user/item', '8');
INSERT INTO `psy_manage_permission` VALUES ('49', '新增/编辑用户接口', 'admin/user/save', '8');
INSERT INTO `psy_manage_permission` VALUES ('50', '删除/批量删除用户接口', 'admin/user/delsome', '8');
INSERT INTO `psy_manage_permission` VALUES ('51', '常规设置', 'admin/system/index', '11');
INSERT INTO `psy_manage_permission` VALUES ('52', '常规设置保存接口', 'admin/system/edit', '11');
INSERT INTO `psy_manage_permission` VALUES ('53', '评论设置', 'admin/system/setcomment', '11');
INSERT INTO `psy_manage_permission` VALUES ('54', '评论设置保存接口', 'admin/system/commentedit', '11');
INSERT INTO `psy_manage_permission` VALUES ('55', '管理员列表', 'admin/user/adminlist', '8');
INSERT INTO `psy_manage_permission` VALUES ('56', '评论列表', 'admin/comment/index', '12');
INSERT INTO `psy_manage_permission` VALUES ('57', '举报列表', 'admin/comment/tiplist', '12');
INSERT INTO `psy_manage_permission` VALUES ('58', '主题列表', 'admin/topic/index', '13');
INSERT INTO `psy_manage_permission` VALUES ('59', '显示/隐藏主题', 'admin/topic/update', '13');
INSERT INTO `psy_manage_permission` VALUES ('60', '主题标签管理', 'admin/topictag/index', '13');
INSERT INTO `psy_manage_permission` VALUES ('61', '新增/编辑主题分类', 'admin/topictag/item', '13');
INSERT INTO `psy_manage_permission` VALUES ('62', '新增/编辑主题分类接口', 'admin/topictag/save', '13');
INSERT INTO `psy_manage_permission` VALUES ('63', '删除/批量删除主题标签接口', 'admin/topictag/delsome', '13');
INSERT INTO `psy_manage_permission` VALUES ('64', '链接管理', 'admin/links/list', '14');
INSERT INTO `psy_manage_permission` VALUES ('65', '新增/编辑友情链接	', 'admin/links/item', '14');
INSERT INTO `psy_manage_permission` VALUES ('66', '新增/编辑友情链接接口', 'admin/links/save', '14');
INSERT INTO `psy_manage_permission` VALUES ('67', '显示/隐藏友情链接接口', 'admin/links/upstatus', '14');
INSERT INTO `psy_manage_permission` VALUES ('68', '设置logo', 'admin/system/setlogo', '11');
INSERT INTO `psy_manage_permission` VALUES ('69', '上传logo接口', 'admin/system/upload', '11');

-- -----------------------------------
-- Table structure for psy_manage_role
-- -----------------------------------
DROP TABLE IF EXISTS `psy_manage_role`;
CREATE TABLE `psy_manage_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role` varchar(255) DEFAULT NULL,
  `rolename` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `pid` text,
  `permission` longtext CHARACTER SET utf8 COLLATE utf8_bin,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- --------------------------
-- Records of psy_manage_role
-- --------------------------
INSERT INTO `psy_manage_role` VALUES ('4', 'visitor', '访客', '3,9,25,7,8,18,16,19,23,47,43', 0x61646D696E2F636F6E74656E742F696E6465782C61646D696E2F636F6E74656E742F64726166746C6973742C61646D696E2F6D656E752F696E6465782C61646D696E2F696E6465782F696E6465782C61646D696E2F696E6465782F77656C636F6D652C61646D696E2F696E6465782F6C6F676F75742C61646D696E2F67756573742F696E6465782C61646D696E2F6974656D2F696E6465782C61646D696E2F6C696E6B732F696E6465782C61646D696E2F757365722F696E6465782C61646D696E2F7461672F696E646578);

-- ----------------------------------
-- Table structure for psy_manage_tag
-- ----------------------------------
DROP TABLE IF EXISTS `psy_manage_tag`;
CREATE TABLE `psy_manage_tag` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8;

-- -------------------------
-- Records of psy_manage_tag
-- -------------------------
INSERT INTO `psy_manage_tag` VALUES ('1','文章管理');
INSERT INTO `psy_manage_tag` VALUES ('2','导航管理');
INSERT INTO `psy_manage_tag` VALUES ('4','基础页面');
INSERT INTO `psy_manage_tag` VALUES ('5','留言管理');
INSERT INTO `psy_manage_tag` VALUES ('6','栏目管理');
INSERT INTO `psy_manage_tag` VALUES ('8','用户管理');
INSERT INTO `psy_manage_tag` VALUES ('9','标签管理');
INSERT INTO `psy_manage_tag` VALUES ('10','权限管理');
INSERT INTO `psy_manage_tag` VALUES ('11','系统设置');
INSERT INTO `psy_manage_tag` VALUES ('12','评论管理');
INSERT INTO `psy_manage_tag` VALUES ('13','社区管理');
INSERT INTO `psy_manage_tag` VALUES ('14','友情链接');

-- ----------------------------
-- Table structure for psy_menu
-- ----------------------------
DROP TABLE IF EXISTS `psy_menu`;
CREATE TABLE `psy_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `menuname` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '菜单名',
  `url` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '导航链接',
  `info` varchar(255) CHARACTER SET utf8 DEFAULT NULL COMMENT '备注',
  `appear` int(11) DEFAULT '1',
  `orders` int(255) DEFAULT '0' COMMENT '排序',
  `target` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=latin1;

-- -------------------
-- Records of psy_menu
-- -------------------
INSERT INTO `psy_menu` VALUES ('1','首页','/','','1','1','1');
INSERT INTO `psy_menu` VALUES ('2','文档','/doc.html',null,'0','2','0');
INSERT INTO `psy_menu` VALUES ('3','资源下载','/download.html',null,'1','3','0');
INSERT INTO `psy_menu` VALUES ('4','活动','/activity.html',null,'1','4','0');
INSERT INTO `psy_menu` VALUES ('5','社区','/topic.html',null,'1','5','0');
INSERT INTO `psy_menu` VALUES ('6','招聘','/topic/job.html',null,'1','6','0');
INSERT INTO `psy_menu` VALUES ('7','捐赠','/donate.html',null,'1','7','0');

-- ------------------------------
-- Table structure for psy_system
-- ------------------------------
DROP TABLE IF EXISTS `psy_system`;
CREATE TABLE `psy_system` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `sitename` varchar(255) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `keywords` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `author` char(50) DEFAULT NULL,
  `copyright` varchar(255) DEFAULT NULL,
  `links` text,
  `allowcomment` int(11) DEFAULT '1',
  `tongji` text,
  `theme` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT 'default',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ---------------------
-- Records of psy_system
-- ---------------------
INSERT INTO `psy_system` VALUES ('1','psychology station','/','psychology thinkjs','base on thinkjs for psychology','psychology','@2018 copyright','XXXXXXXX','0','XXXXXXX','psychology blog');

-- --------------------------------------
-- Table structure for psy_system_comment
-- --------------------------------------
DROP TABLE IF EXISTS `psy_system_comment`;
CREATE TABLE `psy_system_comment` (
  `clientid` varchar(2555) CHARACTER SET utf8 DEFAULT NULL,
  `appcode` text CHARACTER SET utf8,
  `appkey` varchar(255) CHARACTER SET utf8 DEFAULT NULL,
  `appid` varchar(255) CHARACTER SET utf8 NOT NULL DEFAULT '',
	`id` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`,`appid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
-- -----------------------------
-- Records of psy_system_comment
-- -----------------------------
INSERT INTO `psy_system_comment` VALUES ('clientId','XXXXXX','ce4694888','cysoRJNx0','1');

-- ----------------------------
-- Table structure for psy_tags
-- ----------------------------
DROP TABLE IF EXISTS `psy_tags`;
CREATE TABLE `psy_tags` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `tagname` varchar(255) DEFAULT NULL,
  `appear` int(11) DEFAULT '1', 
  `orders` int(255) DEFAULT '0' COMMENT '显示顺序',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8;
-- -------------------
-- Records of psy_tags
-- -------------------
INSERT INTO `psy_tags` VALUES ('1','普通心理学','0','0');
INSERT INTO `psy_tags` VALUES ('2','社会心理学','1','1');
INSERT INTO `psy_tags` VALUES ('3','发展心理学','1','2');
INSERT INTO `psy_tags` VALUES ('4','犯罪心理学','0','3');
INSERT INTO `psy_tags` VALUES ('5','管理心理学','1','4');
INSERT INTO `psy_tags` VALUES ('6','认知心理学','1','5');

-- -----------------------------
-- Table structure for psy_topic
-- -----------------------------
DROP TABLE IF EXISTS `psy_topic`;
CREATE TABLE `psy_topic` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `item` varchar(255) DEFAULT NULL,
  `content` longtext CHARACTER SET utf8 COLLATE utf8_bin COMMENT '内容',
  `author` varchar(255) DEFAULT NULL,
  `createtime` datetime DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '标题',
  `view` bigint(20) DEFAULT '1' COMMENT '点击数',
  `updatetime` datetime DEFAULT NULL,
  `updateauthor` varchar(255) DEFAULT NULL,
  `updatepic` varchar(255) DEFAULT NULL,
  `replycount` int(11) DEFAULT '0' COMMENT '回复数',
  `show` smallint(255) DEFAULT '1' COMMENT '是否显示',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records of psy_topic
-- ----------------------------
INSERT INTO `psy_topic` VALUES ('31', 'ask', 0x3C703EE59CA8E5819AE799BBE99986E9A1B5E79A84E9AA8CE8AF81E7A081E58A9FE883BDEFBC8CE4B98BE5898DE6B2A1E69C89E794A86E6F6465E5819AE8BF87EFBC8CE69C89E4BB80E4B988E58A9EE6B395E4B988EFBC9F3C2F703E, 'livi', '2016-09-02 15:52:44', '新手求解', '193', '2016-09-02 16:30:43', 'baude', 'common/images/pic/avatar_7.jpg', '4', '0');

-- ----------------------------
-- Table structure for psy_topic_comment
-- ----------------------------
DROP TABLE IF EXISTS `psy_topic_comment`;
CREATE TABLE `psy_topic_comment` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `author` varchar(255) NOT NULL,
  `tid` bigint(20) DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL COMMENT '主题标题',
  `createtime` datetime DEFAULT NULL,
  `pic` varchar(255) DEFAULT '' COMMENT '回复者头像',
  `like` bigint(20) DEFAULT '0',
  `comment` longtext CHARACTER SET utf8 COLLATE utf8_bin,
  `likers` text,
  `oldcomment` longtext CHARACTER SET utf8 COLLATE utf8_bin,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=46 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of psy_topic_comment
-- ----------------------------
INSERT INTO `psy_topic_comment` VALUES ('20', 'baude', '26', '杭州微易信息科技－互联网金融的新兴力量（15k-25k）', '2016-08-22 22:26:25', '', '0', 0xE9A1B6E8B5B7EFBC81, null, 0x3C703EE9A1B6E8B5B7EFBC813C2F703E);

-- ----------------------------
-- Table structure for psy_topic_item
-- ----------------------------
DROP TABLE IF EXISTS `psy_topic_item`;
CREATE TABLE `psy_topic_item` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `comment` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of psy_topic_item
-- ----------------------------
INSERT INTO `psy_topic_item` VALUES ('1', 'share', '分享');
INSERT INTO `psy_topic_item` VALUES ('2', 'ask', '问答');
INSERT INTO `psy_topic_item` VALUES ('3', 'job', '招聘');
INSERT INTO `psy_topic_item` VALUES ('4', 'psyblog', 'psyblog');
INSERT INTO `psy_topic_item` VALUES ('5', 'wangeditor', 'wangeditor');
INSERT INTO `psy_topic_item` VALUES ('6', 'thinkjs', 'thinkjs');

-- ----------------------------
-- Table structure for psy_user
-- ----------------------------
DROP TABLE IF EXISTS `psy_user`;
CREATE TABLE `psy_user` (
  `id` int(100) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `nickname` varchar(255) DEFAULT NULL,
  `password` varchar(100) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `role` int(255) DEFAULT '4',
  `openid` varchar(255) DEFAULT NULL COMMENT '第三方登录标识',
  `pic` varchar(255) DEFAULT '' COMMENT '头像',
  `way` varchar(255) DEFAULT 'site' COMMENT '登录方式',
  `point` varchar(255) DEFAULT '10' COMMENT '积分',
  `sign` text COMMENT '个性签名',
  `createtime` datetime DEFAULT NULL,
  `level` int(11) DEFAULT '1' COMMENT '等级',
  `vip` int(11) DEFAULT '0' COMMENT 'vip',
  `isverify` int(11) DEFAULT '0' COMMENT '是否已验证邮箱',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=86 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of psy_user
-- ----------------------------
INSERT INTO `psy_user` VALUES ('56', 'admin', 'admin', 'e10adc3949ba59abbe56e057f20f883e', 'admin@jsout.com', '1', null, 'common/images/pic/avatar_7.jpg', 'site', '15', null, '2016-08-22 14:44:32', '1', '0', '0');
INSERT INTO `psy_user` VALUES ('85', 'baudel', 'baudel', null, 'baudelee@gmail.com', '4', null, '', 'site', '10', null, null, '1', '0', '0');

-- ----------------------------
-- Table structure for psy_user_collect
-- ----------------------------
DROP TABLE IF EXISTS `psy_user_collect`;
CREATE TABLE `psy_user_collect` (
  `id` bigint(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(255) DEFAULT NULL COMMENT '类型',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin DEFAULT NULL,
  `author` varchar(255) DEFAULT NULL,
  `createtime` datetime DEFAULT NULL,
  `type` varchar(255) DEFAULT NULL,
  `aid` int(11) DEFAULT NULL COMMENT '文章id',
  `iscollect` int(11) DEFAULT '1' COMMENT '是否收藏',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of psy_user_collect
-- ----------------------------
INSERT INTO `psy_user_collect` VALUES ('26', '/topic/item/23', ' E井在线商城招聘前端开发工程师(15-30k) ', 'livichen', '2016-08-23 19:00:48', 'topic', '23', '1');
INSERT INTO `psy_user_collect` VALUES ('27', '/topic/item/27', ' css3中display:box 和display:flex区别 ', 'asf1988', '2016-08-29 19:31:08', 'topic', '27', '1');
INSERT INTO `psy_user_collect` VALUES ('28', '/topic/item/27', ' css3中display:box 和display:flex有区别？ ', 'bbq2013', '2016-08-29 19:41:25', 'topic', '27', '1');
INSERT INTO `psy_user_collect` VALUES ('29', '/topic/item/28', ' div垂直水平居中的几种方法 ', 'bbt1991', '2016-09-02 10:14:56', 'topic', '28', '1');
INSERT INTO `psy_user_collect` VALUES ('30', '/topic/item/31.html', ' 新手求解，thinkjs如何生成随机验证码，并返回至前台？ ', 'livisky', '2016-09-02 16:32:09', 'topic', '31', '1');
INSERT INTO `psy_user_collect` VALUES ('31', '/topic/item/34.html', ' liblog v2.0功能更新(2016/9/18) ', 'livisky', '2016-09-18 19:14:01', 'topic', '34', '1');