master

分支 (1)

管理

管理

master

zhlblog
/
antionzhou.sql

/*
Navicat MySQL Data Transfer

Source Server         : 本机
Source Server Version : 50553
Source Host           : localhost:3306
Source Database       : antionzhou

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

Date: 2018-01-07 14:21:50
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for zhl_admin_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `zhl_admin_auth_group`;
CREATE TABLE `zhl_admin_auth_group` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `title` char(100) NOT NULL DEFAULT '' COMMENT '组别名称',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `is_manage` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1需要验证权限 2 不需要验证权限',
  `rules` text NOT NULL COMMENT '用户组拥有的规则id， 多个规则',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of zhl_admin_auth_group
-- ----------------------------
INSERT INTO `zhl_admin_auth_group` VALUES ('27', '超级管理员', '1', '1', '2,57,60,61,58,59,73,74,14,21,24,25,26,27,22,28,29,30,31,23,32,33,34,35,39,75,78,79,80,40,41,42,43,44,45,46,47,48,50,51,49,52,53,54,55,56,62,63,64,65,67,68,69,70,71,72');
INSERT INTO `zhl_admin_auth_group` VALUES ('31', '88', '2', '1', '');
INSERT INTO `zhl_admin_auth_group` VALUES ('32', '8888', '1', '1', '2,14,21,24,25,26,27,22,28,29,30,31,23,32,33,34,35');
INSERT INTO `zhl_admin_auth_group` VALUES ('33', '1', '2', '1', '');

-- ----------------------------
-- Table structure for zhl_admin_auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `zhl_admin_auth_group_access`;
CREATE TABLE `zhl_admin_auth_group_access` (
  `uid` mediumint(8) unsigned NOT NULL,
  `group_id` mediumint(8) unsigned NOT NULL,
  UNIQUE KEY `uid_group_id` (`uid`,`group_id`),
  KEY `uid` (`uid`),
  KEY `group_id` (`group_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of zhl_admin_auth_group_access
-- ----------------------------
INSERT INTO `zhl_admin_auth_group_access` VALUES ('1', '27');
INSERT INTO `zhl_admin_auth_group_access` VALUES ('2', '32');
INSERT INTO `zhl_admin_auth_group_access` VALUES ('18', '32');

-- ----------------------------
-- Table structure for zhl_admin_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `zhl_admin_auth_rule`;
CREATE TABLE `zhl_admin_auth_rule` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `icon` varchar(100) DEFAULT '' COMMENT '图标',
  `menu_name` varchar(100) NOT NULL DEFAULT '' COMMENT '规则唯一标识Controller/action',
  `title` varchar(100) NOT NULL DEFAULT '' COMMENT '菜单名称',
  `pid` tinyint(5) NOT NULL DEFAULT '0' COMMENT '菜单ID ',
  `is_menu` tinyint(1) DEFAULT '1' COMMENT '1:是主菜单 2 否',
  `is_race_menu` tinyint(1) NOT NULL DEFAULT '1' COMMENT '1:是 2:不是',
  `type` tinyint(1) NOT NULL DEFAULT '1',
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `condition` char(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=81 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Records of zhl_admin_auth_rule
-- ----------------------------
INSERT INTO `zhl_admin_auth_rule` VALUES ('2', '', '', '基本管理', '0', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('4', '&amp;#xe613;', 'User/index', '用户管理', '2', '1', '1', '1', '2', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('7', 'asdasd', 'asd/asdasd', '三级菜单', '4', '2', '1', '1', '2', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('14', '', '', '权限管理', '0', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('20', 'asd', 'User/addUser', '添加用户', '4', '2', '1', '1', '2', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('21', '&amp;#xe624;', 'Menu/index', '菜单管理', '14', '1', '2', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('22', '&amp;#xe612;', 'AuthGroup/authGroupList', '角色管理', '14', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('23', '&amp;#xe613;', 'User/index', '用户管理', '14', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('24', '13', 'Menu/addMenu', '添加菜单', '21', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('25', '213', 'Menu/editMenu', '编辑菜单', '21', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('26', '435', 'Menu/deleteMenu', '删除菜单', '21', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('27', '13', 'Menu/viewOpt', '查看三级菜单', '21', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('28', '123', 'AuthGroup/addGroup', '添加角色', '22', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('29', '35', 'AuthGroup/editGroup', '编辑角色', '22', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('30', '345', 'AuthGroup/deleteGroup', '删除角色', '22', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('31', 'asd', 'AuthGroup/ruleGroup', '分配权限', '22', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('32', '13', 'User/addUser', '添加用户', '23', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('33', '324', 'User/editUser', '编辑用户', '23', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('34', '435', 'User/deleterUser', '删除用户', '23', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('35', '234', 'AuthGroup/giveRole', '分配角色', '23', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('37', 'icon', 'goods/gooslist', '商品管理', '2', '1', '1', '1', '2', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('38', 'ss', 'goods/goodslist', '商品管理', '14', '1', '1', '1', '2', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('39', '', 'Customer/', '访客管理', '0', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('40', '', 'Category/index', '分类管理', '0', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('41', '&amp;#xe60c;', 'Category/category_list', '分类列表', '40', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('42', '13', 'Category/sort', '排序', '41', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('43', 'add', 'Category/add', '添加子分类', '41', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('44', 'edit', 'Category/edit', '修改', '41', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('45', 'delete', 'Category/delete', '删除', '41', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('46', '&amp;#xe60c;', 'Category/post', '添加分类', '40', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('47', 'Tag', 'Tag/', '标签管理', '0', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('48', '&amp;#xe63c;', 'Tag/index', '标签列表', '47', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('49', '&amp;#xe61f;', 'Tag/add', '添加标签', '47', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('50', 'edit', 'Tag/edit', '修改', '48', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('51', 'delete', 'Tag/delete', '删除标签', '48', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('52', 'Article', 'Article/', '文章管理', '0', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('53', '&amp;#xe62a;', 'Article/index', '文章列表', '52', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('54', '&amp;#xe642;', 'Article/edit', '修改文章', '53', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('55', 'Recycle', 'Recycle/recycle', '删除到回收站', '53', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('56', '&amp;#xe61f;', 'Article/add', '发布文章', '52', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('57', '&amp;#xe640;', 'Recycle/article', '已删文章', '2', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('58', '&amp;#xe640;', 'Recycle/comment', '已删评论', '2', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('59', '&amp;#xe640;', 'Recycle/link', '已删友情链接', '2', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('60', 'recover', 'Recycle/recover', '恢复文章', '57', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('61', 'delete', 'Article/delete', '彻底删除', '57', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('62', '', 'Config/', '网站管理', '0', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('63', '&amp;#xe614;', 'Config/index', '配置管理', '62', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('64', 'link', 'Link/', '友情链接', '0', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('65', '&amp;#xe650;', 'Link/index', '友链列表', '64', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('66', 'add', 'Link/add', '添加友链', '65', '2', '1', '1', '2', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('67', 'edit', 'Link/edit', '修改友链', '65', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('68', '&amp;#xe61f;', 'Link/add', '添加友链', '64', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('69', 'Statement', 'Statements/s', '语句管理', '0', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('70', '&amp;#xe62d;', 'Statements/index', '语句列表', '69', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('71', '&amp;#xe62d;', 'Statements/edit', '修改语句', '70', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('72', '&amp;#xe61f;', 'Statements/add', '添加语句', '69', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('73', '&amp;#xe640;', 'Recycle/Statement', '已删语句', '2', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('74', 'delete', 'Recycle/delete', '彻底删除', '73', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('75', '&amp;#xe612;', 'Customer/index', '访客列表', '39', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('76', '12', '12/12', '12', '39', '1', '1', '1', '2', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('77', '&amp;#xe612;', 'comment/index', '评论列表', '0', '1', '1', '1', '2', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('78', '&amp;#xe61f;', 'comment/index', '评论列表', '39', '1', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('79', 'change_status', 'Comment/change_status', '审核', '78', '2', '1', '1', '1', '');
INSERT INTO `zhl_admin_auth_rule` VALUES ('80', 'Reply', 'comment/Reply', '回复', '78', '2', '1', '1', '1', '');

-- ----------------------------
-- Table structure for zhl_article
-- ----------------------------
DROP TABLE IF EXISTS `zhl_article`;
CREATE TABLE `zhl_article` (
  `aid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '文章表主键',
  `title` char(100) NOT NULL DEFAULT '' COMMENT '标题',
  `author` varchar(15) NOT NULL DEFAULT '' COMMENT '作者',
  `content` mediumtext NOT NULL COMMENT '文章内容',
  `keywords` varchar(255) NOT NULL DEFAULT '' COMMENT '关键字',
  `description` char(255) NOT NULL DEFAULT '' COMMENT '描述',
  `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '文章是否显示 1是 0否',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除 1是 0否',
  `is_top` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否置顶 1是 0否',
  `is_original` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否原创',
  `click` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '点击数',
  `addtime` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '添加时间',
  `cid` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '分类id',
  `edit_time` int(11) DEFAULT NULL,
  PRIMARY KEY (`aid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhl_article
-- ----------------------------
INSERT INTO `zhl_article` VALUES ('1', '测试', '周宏亮', '&lt;p&gt;测试&lt;/p&gt;', '测试', '测试', '1', '0', '0', '1', '1', '1515303125', '1', '1515303125');

-- ----------------------------
-- Table structure for zhl_article_pic
-- ----------------------------
DROP TABLE IF EXISTS `zhl_article_pic`;
CREATE TABLE `zhl_article_pic` (
  `ap_id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `path` varchar(100) NOT NULL DEFAULT '' COMMENT '图片路径',
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '所属文章id',
  PRIMARY KEY (`ap_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhl_article_pic
-- ----------------------------

-- ----------------------------
-- Table structure for zhl_article_tag
-- ----------------------------
DROP TABLE IF EXISTS `zhl_article_tag`;
CREATE TABLE `zhl_article_tag` (
  `aid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '文章id',
  `tid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '标签id'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhl_article_tag
-- ----------------------------

-- ----------------------------
-- Table structure for zhl_category
-- ----------------------------
DROP TABLE IF EXISTS `zhl_category`;
CREATE TABLE `zhl_category` (
  `cid` tinyint(2) unsigned NOT NULL AUTO_INCREMENT COMMENT '分类主键id',
  `cname` varchar(15) NOT NULL DEFAULT '' COMMENT '分类名称',
  `keywords` varchar(255) DEFAULT '' COMMENT '关键词',
  `description` varchar(255) DEFAULT '' COMMENT '描述',
  `sort` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '排序',
  `pid` tinyint(2) unsigned NOT NULL DEFAULT '0' COMMENT '父级栏目id',
  PRIMARY KEY (`cid`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhl_category
-- ----------------------------
INSERT INTO `zhl_category` VALUES ('1', '测试', '', '', '1', '0');

-- ----------------------------
-- Table structure for zhl_comment
-- ----------------------------
DROP TABLE IF EXISTS `zhl_comment`;
CREATE TABLE `zhl_comment` (
  `cmtid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `ouid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论用户id 关联oauth_user表的id',
  `type` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '1：文章评论',
  `pid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父级id',
  `aid` int(10) unsigned NOT NULL COMMENT '文章id',
  `content` text NOT NULL COMMENT '内容',
  `date` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '评论日期',
  `status` tinyint(1) unsigned NOT NULL COMMENT '1:已审核 0：未审核',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`cmtid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhl_comment
-- ----------------------------
INSERT INTO `zhl_comment` VALUES ('1', '1', '1', '0', '1', '22', '1515303163', '1', '0');
INSERT INTO `zhl_comment` VALUES ('2', '1', '1', '1', '1', '&lt;p&gt;33&lt;/p&gt;', '1515305737', '1', '0');

-- ----------------------------
-- Table structure for zhl_config
-- ----------------------------
DROP TABLE IF EXISTS `zhl_config`;
CREATE TABLE `zhl_config` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(100) NOT NULL DEFAULT '' COMMENT '配置项键名',
  `value` text COMMENT '配置项键值 1表示开启 0 关闭',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhl_config
-- ----------------------------
INSERT INTO `zhl_config` VALUES ('1', 'WEB_NAME', '周宏亮博客');
INSERT INTO `zhl_config` VALUES ('2', 'WEB_KEYWORDS', '周宏亮,周宏亮,周宏亮博客,技术流博客,zhouhongliang,zhouhongliang博客,php个人博客,thinkphp博客系统,个人博客模板');
INSERT INTO `zhl_config` VALUES ('3', 'WEB_DESCRIPTION', '周宏亮的php博客,个人技术博客,zhouhongliang,zhouhongliang官方网站');
INSERT INTO `zhl_config` VALUES ('4', 'WEB_STATUS', '1');
INSERT INTO `zhl_config` VALUES ('5', 'ADMIN_PASSWORD', '21232f297a57a5a743894a0e4a801fc3');
INSERT INTO `zhl_config` VALUES ('6', 'WATER_TYPE', '1');
INSERT INTO `zhl_config` VALUES ('7', 'TEXT_WATER_WORD', 'baijunyao.com');
INSERT INTO `zhl_config` VALUES ('8', 'TEXT_WATER_TTF_PTH', './Public/static/font/ariali.ttf');
INSERT INTO `zhl_config` VALUES ('9', 'TEXT_WATER_FONT_SIZE', '15');
INSERT INTO `zhl_config` VALUES ('10', 'TEXT_WATER_COLOR', '#008CBA');
INSERT INTO `zhl_config` VALUES ('11', 'TEXT_WATER_ANGLE', '0');
INSERT INTO `zhl_config` VALUES ('12', 'TEXT_WATER_LOCATE', '9');
INSERT INTO `zhl_config` VALUES ('13', 'IMAGE_WATER_PIC_PTAH', './Upload/image/logo/logo.png');
INSERT INTO `zhl_config` VALUES ('14', 'IMAGE_WATER_LOCATE', '9');
INSERT INTO `zhl_config` VALUES ('15', 'IMAGE_WATER_ALPHA', '80');
INSERT INTO `zhl_config` VALUES ('16', 'WEB_CLOSE_WORD', '网站升级中，请稍后访问。');
INSERT INTO `zhl_config` VALUES ('17', 'WEB_ICP_NUMBER', '京ICP备17010926号');
INSERT INTO `zhl_config` VALUES ('18', 'ADMIN_EMAIL', '[email protected]');
INSERT INTO `zhl_config` VALUES ('19', 'COPYRIGHT_WORD', '本文为周宏亮原创文章,转载无需和我联系,但请注明来自周宏亮博客zhouhongliang.cn');
INSERT INTO `zhl_config` VALUES ('20', 'QQ_APP_ID', '');
INSERT INTO `zhl_config` VALUES ('21', 'CHANGYAN_APP_ID', 'cyrKRbJ5N');
INSERT INTO `zhl_config` VALUES ('22', 'CHANGYAN_CONF', 'prod_c654661caf5ab6da98742d040413815b');
INSERT INTO `zhl_config` VALUES ('23', 'WEB_STATISTICS', '');
INSERT INTO `zhl_config` VALUES ('24', 'CHANGEYAN_RETURN_COMMENT', '');
INSERT INTO `zhl_config` VALUES ('25', 'AUTHOR', '周宏亮');
INSERT INTO `zhl_config` VALUES ('26', 'QQ_APP_KEY', '');
INSERT INTO `zhl_config` VALUES ('27', 'CHANGYAN_COMMENT', '');
INSERT INTO `zhl_config` VALUES ('28', 'BAIDU_SITE_URL', '');
INSERT INTO `zhl_config` VALUES ('29', 'DOUBAN_API_KEY', '');
INSERT INTO `zhl_config` VALUES ('30', 'DOUBAN_SECRET', '');
INSERT INTO `zhl_config` VALUES ('31', 'RENREN_API_KEY', '');
INSERT INTO `zhl_config` VALUES ('32', 'RENREN_SECRET', '');
INSERT INTO `zhl_config` VALUES ('33', 'SINA_API_KEY', '');
INSERT INTO `zhl_config` VALUES ('34', 'SINA_SECRET', '');
INSERT INTO `zhl_config` VALUES ('35', 'KAIXIN_API_KEY', '');
INSERT INTO `zhl_config` VALUES ('36', 'KAIXIN_SECRET', '');
INSERT INTO `zhl_config` VALUES ('37', 'SOHU_API_KEY', '');
INSERT INTO `zhl_config` VALUES ('38', 'SOHU_SECRET', '');
INSERT INTO `zhl_config` VALUES ('39', 'GITHUB_CLIENT_ID', '');
INSERT INTO `zhl_config` VALUES ('40', 'GITHUB_CLIENT_SECRET', '');
INSERT INTO `zhl_config` VALUES ('41', 'IMAGE_TITLE_ALT_WORD', '周宏亮个人技术博客');
INSERT INTO `zhl_config` VALUES ('42', 'EMAIL_SMTP', '');
INSERT INTO `zhl_config` VALUES ('43', 'EMAIL_USERNAME', '');
INSERT INTO `zhl_config` VALUES ('44', 'EMAIL_PASSWORD', '');
INSERT INTO `zhl_config` VALUES ('45', 'EMAIL_FROM_NAME', '');
INSERT INTO `zhl_config` VALUES ('46', 'COMMENT_REVIEW', '1');
INSERT INTO `zhl_config` VALUES ('47', 'COMMENT_SEND_EMAIL', '1');
INSERT INTO `zhl_config` VALUES ('48', 'EMAIL_RECEIVE', '[email protected]');

-- ----------------------------
-- Table structure for zhl_customer
-- ----------------------------
DROP TABLE IF EXISTS `zhl_customer`;
CREATE TABLE `zhl_customer` (
  `uid` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(30) NOT NULL DEFAULT '',
  `pwd` varchar(35) NOT NULL DEFAULT '',
  `nickname` varchar(50) DEFAULT NULL COMMENT '昵称',
  `email` varchar(50) DEFAULT NULL COMMENT '邮件',
  `sex` int(11) NOT NULL DEFAULT '0',
  `phone` varchar(50) DEFAULT NULL,
  `address` varchar(100) DEFAULT NULL COMMENT '联系地址',
  `actualName` varchar(30) DEFAULT NULL COMMENT '真实姓名',
  `header_img` varchar(255) DEFAULT NULL COMMENT '头像',
  `birthday` varchar(50) DEFAULT NULL,
  `status` tinyint(4) DEFAULT '2' COMMENT '是否允许用户登录后台(1是  2否)',
  `lastlogin_time` int(11) DEFAULT NULL,
  `create_time` date NOT NULL,
  PRIMARY KEY (`uid`),
  UNIQUE KEY `uphone` (`name`),
  UNIQUE KEY `uid` (`uid`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhl_customer
-- ----------------------------
INSERT INTO `zhl_customer` VALUES ('1', 'root', '123456', '', '[email protected]', '0', '18243514784', '', null, null, null, '1', '1515303082', '0000-00-00');
INSERT INTO `zhl_customer` VALUES ('18', '6666', '6666', null, null, '0', null, null, null, null, null, '1', '1515055298', '0000-00-00');

-- ----------------------------
-- Table structure for zhl_link
-- ----------------------------
DROP TABLE IF EXISTS `zhl_link`;
CREATE TABLE `zhl_link` (
  `lid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `lname` varchar(50) NOT NULL DEFAULT '' COMMENT '链接名',
  `url` varchar(255) NOT NULL DEFAULT '' COMMENT '链接地址',
  `sort` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '排序',
  `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '文章是否显示 1是 0否',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除 1是 0否',
  PRIMARY KEY (`lid`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhl_link
-- ----------------------------
INSERT INTO `zhl_link` VALUES ('2', '周洪亮博客', 'http://zhouhongliang.cn', '1', '1', '0');

-- ----------------------------
-- Table structure for zhl_oauth_user
-- ----------------------------
DROP TABLE IF EXISTS `zhl_oauth_user`;
CREATE TABLE `zhl_oauth_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `uid` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '关联的本站用户id',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '类型 1：QQ  2：新浪微博 3：豆瓣 4：人人 5：开心网',
  `nickname` varchar(30) NOT NULL DEFAULT '' COMMENT '第三方昵称',
  `head_img` varchar(255) NOT NULL DEFAULT '' COMMENT '头像',
  `openid` varchar(40) NOT NULL DEFAULT '' COMMENT '第三方用户id',
  `access_token` varchar(255) NOT NULL DEFAULT '' COMMENT 'access_token token',
  `create_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '绑定时间',
  `last_login_time` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '最后登录时间',
  `last_login_ip` varchar(16) NOT NULL DEFAULT '' COMMENT '最后登录ip',
  `login_times` int(6) unsigned NOT NULL DEFAULT '0' COMMENT '登录次数',
  `status` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '状态',
  `email` varchar(255) NOT NULL DEFAULT '' COMMENT '邮箱',
  `is_admin` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否是admin',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhl_oauth_user
-- ----------------------------

-- ----------------------------
-- Table structure for zhl_statement
-- ----------------------------
DROP TABLE IF EXISTS `zhl_statement`;
CREATE TABLE `zhl_statement` (
  `chid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '碎言id',
  `date` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '发表时间',
  `content` text NOT NULL COMMENT '内容',
  `is_show` tinyint(1) unsigned NOT NULL DEFAULT '1' COMMENT '是否显示',
  `is_delete` tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`chid`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhl_statement
-- ----------------------------
INSERT INTO `zhl_statement` VALUES ('5', '1499397976', '<p>得过且过，苍天能放过谁？</p>', '1', '0');
INSERT INTO `zhl_statement` VALUES ('6', '1500532572', '<p><span style=\"color: rgb(51, 51, 51); font-size: 14px;\">喝醉，从来就不是酒精的罪过，而是感情的度数太高 。——亲爱的不二 </span><br></p>', '1', '0');
INSERT INTO `zhl_statement` VALUES ('7', '1510287623', '<p>1654</p>', '1', '1');
INSERT INTO `zhl_statement` VALUES ('8', '1510289303', '<p><span style=\"color: rgb(38, 38, 38); font-size: 15px;\">何须论得丧，才子词人，自是白衣卿相</span><br></p>', '1', '0');
INSERT INTO `zhl_statement` VALUES ('9', '1510289309', '<p><span style=\"color: rgb(38, 38, 38); font-size: 15px;\">诗万首，酒万觞，几曾着眼看侯王</span><br></p>', '1', '0');
INSERT INTO `zhl_statement` VALUES ('10', '1510289316', '<p><span style=\"color: rgb(38, 38, 38); font-size: 15px;\">但愿老死花酒间，不愿鞠躬车马前。</span><br></p>', '1', '0');
INSERT INTO `zhl_statement` VALUES ('11', '1510289402', '<p><span style=\"color: rgb(107, 122, 140); font-size: 15px;\">忍把浮名，换了浅斟低唱！</span><br></p>', '1', '0');

-- ----------------------------
-- Table structure for zhl_tag
-- ----------------------------
DROP TABLE IF EXISTS `zhl_tag`;
CREATE TABLE `zhl_tag` (
  `tid` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT '标签主键',
  `tname` varchar(10) NOT NULL DEFAULT '' COMMENT '标签名',
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of zhl_tag
-- ----------------------------