/*
 Navicat Premium Data Transfer

 Source Server         : 腾讯基础版
 Source Server Type    : MySQL
 Source Server Version : 50718
 Source Host           : mysql-1.ennn.cn:10130
 Source Schema         : admin_ennn_cn

 Target Server Type    : MySQL
 Target Server Version : 50718
 File Encoding         : 65001

 Date: 25/09/2020 23:00:50
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for hq_ad
-- ----------------------------
DROP TABLE IF EXISTS `hq_ad`;
CREATE TABLE `hq_ad`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `userid` smallint(8) NULL DEFAULT NULL COMMENT '用户ID',
  `category` smallint(5) NOT NULL DEFAULT 0 COMMENT '分类',
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '分类名称',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '描述',
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '链接',
  `target` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '' COMMENT '打开方式',
  `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片',
  `sort_order` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '排序',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '状态',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
  `update_time` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `delete_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '广告' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of hq_ad
-- ----------------------------
INSERT INTO `hq_ad` VALUES (5, NULL, 33, '发是打发阿什顿发', '', '', '_self', 'https://mdf.muxue.com.cn/uploads/20200814/6b57516592b5933b36dd3b601fd95540.png', 0, 1, 1591088366, 1597378767, 0);
INSERT INTO `hq_ad` VALUES (6, NULL, 33, '发是打发阿什顿发', '', '', '', 'https://mdf.muxue.com.cn/uploads/20200813/139d5259dded219bb0752c15b20f942f.jpg', 0, 1, 1597322681, 1601042552, 0);
INSERT INTO `hq_ad` VALUES (7, NULL, 33, '', '', '', '', 'https://mdf.muxue.com.cn/uploads/20200814/43a294e305267d10e3757aa51a042a12.png', 0, 1, 1597322693, 1597378717, 0);

-- ----------------------------
-- Table structure for hq_admin
-- ----------------------------
DROP TABLE IF EXISTS `hq_admin`;
CREATE TABLE `hq_admin`  (
  `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `username` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '管理员用户名',
  `avatar` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
  `password` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '管理员密码',
  `status` tinyint(1) NOT NULL DEFAULT 1 COMMENT '0禁用/1启动',
  `last_login_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '上次登录时间',
  `last_login_ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '上次登录IP',
  `login_count` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '登录次数',
  `content` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,
  `auth` tinyint(5) NULL DEFAULT 1 COMMENT '访问权限  1全部访问 0部分访问',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
  `update_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '更新时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '管理员' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of hq_admin
-- ----------------------------
INSERT INTO `hq_admin` VALUES (1, 'admin', NULL, '黄青', 'e10adc3949ba59abbe56e057f20f883e', 1, 1601041470, '220.200.0.110', 1159, 'd', 1, 1555249039, 1601041470);

-- ----------------------------
-- Table structure for hq_admin_log
-- ----------------------------
DROP TABLE IF EXISTS `hq_admin_log`;
CREATE TABLE `hq_admin_log`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `admin_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0 COMMENT '管理员id',
  `username` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '管理员用户名',
  `useragent` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'User-Agent',
  `ip` varchar(16) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'ip地址',
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '请求链接',
  `method` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '请求类型',
  `type` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '资源类型',
  `param` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '请求参数',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT '日志备注',
  `create_time` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1241 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '管理员日志' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of hq_admin_log
-- ----------------------------

-- ----------------------------
-- Table structure for hq_article
-- ----------------------------
DROP TABLE IF EXISTS `hq_article`;
CREATE TABLE `hq_article`  (
  `id` int(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` int(5) NOT NULL DEFAULT 0 COMMENT 'ID',
  `cid` int(5) NOT NULL COMMENT '分类ID',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
  `tags` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标签',
  `keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关键字',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `author` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '作者',
  `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '封面',
  `source` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '来源',
  `view` int(10) NOT NULL DEFAULT 0 COMMENT '阅读量',
  `comment` int(10) NOT NULL DEFAULT 0 COMMENT '评论数',
  `like` int(10) NOT NULL DEFAULT 0 COMMENT '点赞数',
  `favor` int(10) NOT NULL DEFAULT 0 COMMENT '收藏数',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '详细内容',
  `video` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '视频地址',
  `sort_order` tinyint(5) NOT NULL DEFAULT 100 COMMENT '排序',
  `status` tinyint(5) NOT NULL DEFAULT 0 COMMENT '状态 0待审核 1审核通过 2审核拒绝',
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'URL',
  `wxapp_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小程序链接',
  `is_hot` tinyint(3) NOT NULL DEFAULT 0 COMMENT '是否热门 0不热门 1热门',
  `is_tuijian` tinyint(3) NOT NULL DEFAULT 0 COMMENT '是否推荐 0不推荐 1推荐',
  `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `delete_time` int(11) NOT NULL DEFAULT 0 COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 133 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '文章表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of hq_article
-- ----------------------------
INSERT INTO `hq_article` VALUES (128, 0, 55, '定时宝 定时提醒助手', '是的啊,是打发萨顶顶,是发送', '是打发', '定时提醒助手', '', 'https://mdf.muxue.com.cn/uploads/20200812/c11f84f725bee7e1cc53e14a693c0b56.jpg', '', 53, 0, 0, 0, '<p>定时宝</p>\r\n<p>定时提醒小程序</p>\r\n<p>主要为商家提供定时提醒服务,客户管理服务等</p>', NULL, 100, 1, '/show/128.html', '/pages/list/article?id=128', 0, 0, 1597126342, 1597230393, 0);
INSERT INTO `hq_article` VALUES (129, 0, 55, '出纳宝 小微企业记账软件', '', '啥是打发啥都,地方,啊', '小微企业记账软件', '', 'https://mdf.muxue.com.cn/uploads/20200812/db9d2eaae7994e9a85cf69aa72488347.jpg', '', 111, 0, 0, 0, '<p>出纳宝</p>\r\n<p>针对老板，无需任何会计知识，轻松管账，管钱，管库存，从此告别糊涂账。针对财务人员，凭证，报表自动生成，简单省事。</p>\r\n<div class=\"section-heading\">\r\n<h2 class=\"title\">无需任何会计知识,轻松记账</h2>\r\n<p class=\"text\">一键添加收入支出，智能管理应收应付，轻松解决复杂的往来账务。</p>\r\n</div>\r\n<ul class=\"feature-list\">\r\n<li>\r\n<p>多端同步记账，多人同步协作。</p>\r\n</li>\r\n<li>\r\n<p>一键记录收入支出，统计往来账目</p>\r\n</li>\r\n<li>\r\n<p>待收待付，定时提醒，杜绝坏账。</p>\r\n</li>\r\n<li>\r\n<p>一键导入，实时导出，数据安全有保</p>\r\n</li>\r\n</ul>', NULL, 100, 1, '/show/129.html', '/pages/list/article?id=129', 0, 0, 1597126376, 1597230250, 0);
INSERT INTO `hq_article` VALUES (130, 0, 55, '课时邦 小培训机构销课系统', '是的啊,是打发萨顶顶,是发送', '是打发', '小培训机构销课系统', '', 'https://mdf.muxue.com.cn/uploads/20200814/c6a4a19fafbe3c22351af7e4432c3c5e.png', '', 80, 0, 0, 0, '<p>定时宝</p>\r\n<p>定时提醒小程序</p>\r\n<p>主要为商家提供定时提醒服务,客户管理服务等</p>', NULL, 100, 1, '/show/130.html', '/pages/list/article?id=130', 0, 0, 1597126342, 1600609259, 0);
INSERT INTO `hq_article` VALUES (131, 0, 55, '云代理商 小程序分销系统', '', '啥是打发啥都,地方,啊', '小程序分销系统', '', 'https://mdf.muxue.com.cn/uploads/20200814/fb6e491120001bbb7d6611be3046a75d.png', '', 174, 0, 0, 0, '<p>出纳宝</p>\r\n<p>针对老板，无需任何会计知识，轻松管账，管钱，管库存，从此告别糊涂账。针对财务人员，凭证，报表自动生成，简单省事。</p>\r\n<div class=\"section-heading\">\r\n<h2 class=\"title\">无需任何会计知识,轻松记账</h2>\r\n<p class=\"text\">一键添加收入支出，智能管理应收应付，轻松解决复杂的往来账务。</p>\r\n</div>\r\n<ul class=\"feature-list\">\r\n<li>\r\n<p>多端同步记账，多人同步协作。</p>\r\n</li>\r\n<li>\r\n<p>一键记录收入支出，统计往来账目</p>\r\n</li>\r\n<li>\r\n<p>待收待付，定时提醒，杜绝坏账。</p>\r\n</li>\r\n<li>\r\n<p>一键导入，实时导出，数据安全有保</p>\r\n</li>\r\n</ul>', NULL, 100, 1, '/show/131.html', '/pages/list/article?id=131', 0, 0, 1597126376, 1597396757, 0);
INSERT INTO `hq_article` VALUES (132, 0, 55, 'test', NULL, '', '', '', '', '', 0, 0, 0, 0, '<p><img src=\"http://www.quwenqushi.com/uploadfile/2020/0922/20200922083115263.jpg\" /></p>', NULL, 100, 1, '/show/132.html', '/pages/list/article?id=132', 0, 0, 1600828172, 1600828353, 1600828353);

-- ----------------------------
-- Table structure for hq_auth_group
-- ----------------------------
DROP TABLE IF EXISTS `hq_auth_group`;
CREATE TABLE `hq_auth_group`  (
  `id` smallint(5) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `status` tinyint(1) NOT NULL DEFAULT 1,
  `rules` text CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限组' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of hq_auth_group
-- ----------------------------
INSERT INTO `hq_auth_group` VALUES (1, '超级管理员', '', 1, '6,43,44,168,178,179,199,200,201,202,203,204,205,206,207,219,180,142,143,145,146,147,186,188,182,183,184,185,155,156,158,159,160,157,161,162,163,174,175,176,177,195,196,197,198,164,165,166,167,169,181,194,172,170,171,173,187,189,191,192,193,190,4,123,125,126,127,128,92,45,68,69,70,103,5,16,37,38,39,18,53,17,40,41,42,15,22,23,24');
INSERT INTO `hq_auth_group` VALUES (3, '后台管理', '', 1, '168,178,179,180');

-- ----------------------------
-- Table structure for hq_auth_group_access
-- ----------------------------
DROP TABLE IF EXISTS `hq_auth_group_access`;
CREATE TABLE `hq_auth_group_access`  (
  `uid` smallint(5) UNSIGNED NOT NULL DEFAULT 0,
  `group_id` smallint(5) UNSIGNED NOT NULL DEFAULT 0
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限授权' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of hq_auth_group_access
-- ----------------------------
INSERT INTO `hq_auth_group_access` VALUES (1, 1);
INSERT INTO `hq_auth_group_access` VALUES (2, 1);

-- ----------------------------
-- Table structure for hq_auth_rule
-- ----------------------------
DROP TABLE IF EXISTS `hq_auth_rule`;
CREATE TABLE `hq_auth_rule`  (
  `id` int(11) UNSIGNED NOT NULL AUTO_INCREMENT,
  `pid` int(11) UNSIGNED NOT NULL DEFAULT 0,
  `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `icon` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '',
  `sort_order` int(11) NOT NULL DEFAULT 0 COMMENT '排序',
  `type` char(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '' COMMENT 'nav,auth',
  `index` tinyint(1) NOT NULL DEFAULT 0 COMMENT '快捷导航',
  `status` tinyint(1) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 223 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限规则' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of hq_auth_rule
-- ----------------------------
INSERT INTO `hq_auth_rule` VALUES (4, 0, '系统设置', '', 'layui-icon-set', 6, 'nav', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (5, 0, '管理员管理', '', 'layui-icon-auz', 9, 'nav', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (6, 0, '控制台', 'admin/index/home', 'layui-icon-home', 0, 'nav', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (15, 5, '权限规则', 'admin/auth/rule', 'fa fa-th-list', 3, 'nav', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (16, 5, '管理员列表', 'admin/admin/index', 'fa fa-user', 0, 'nav', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (17, 5, '角色管理', 'admin/auth/group', 'fa fa-users', 2, 'nav', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (18, 5, '操作日志', 'admin/admin/log', 'fa fa-clock-o', 1, 'nav', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (22, 15, '添加', 'admin/auth/addRule', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (23, 15, '编辑', 'admin/auth/editRule', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (24, 15, '删除', 'admin/auth/delRule', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (37, 16, '添加', 'admin/admin/add', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (38, 16, '编辑', 'admin/admin/edit', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (39, 16, '删除', 'admin/admin/del', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (40, 17, '添加', 'admin/auth/addGroup', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (41, 17, '编辑', 'admin/auth/editGroup', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (42, 17, '删除', 'admin/auth/delGroup', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (43, 6, '修改密码', 'admin/index/editPassword', '', 2, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (44, 6, '清除缓存', 'admin/index/clear', '', 3, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (45, 4, '上传设置', 'admin/config/upload', 'fa fa-upload', 4, 'nav', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (53, 18, '一键清空', 'admin/admin/truncate', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (68, 45, '上传图片', 'admin/index/uploadimage', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (69, 45, '上传文件', 'admin/index/uploadfile', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (70, 45, '上传视频', 'admin/index/uploadvideo', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (92, 4, '配置信息', 'admin/config/param', '', 2, 'nav', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (103, 4, '上传管理', 'admin/uploads/index', '', 10, 'nav', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (123, 4, '网站配置', 'admin/config/setting', '', 0, 'nav', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (125, 4, '字典管理', 'admin/dict/index', '', 0, 'nav', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (126, 125, '新增', 'admin/dict/add', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (127, 125, '编辑', 'admin/dict/edit', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (128, 125, '删除', 'admin/dict/del', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (142, 0, '会员管理', '', 'layui-icon-user', 3, 'nav', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (143, 142, '会员管理', 'admin/user/index', '', 0, 'nav', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (145, 143, '添加', 'admin/user/add', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (146, 143, '编辑', 'admin/user/edit', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (147, 143, '删除', 'admin/user/del', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (155, 0, '文章管理', '', 'layui-icon-read', 4, 'nav', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (156, 155, '栏目管理', 'admin/category/index', '', 0, 'nav', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (157, 155, '文章管理', 'admin/article/index', '', 0, 'nav', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (158, 156, '添加', 'admin/category/add', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (159, 156, '编辑', 'admin/category/edit', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (160, 156, '删除', 'admin/category/del', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (161, 157, '添加', 'admin/article/add', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (162, 157, '编辑', 'admin/article/edit', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (163, 157, '删除', 'admin/article/del', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (164, 155, '轮播管理', 'admin/ad/index', '', 100, 'nav', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (174, 155, '专题管理', 'admin/zhuanti/index', '', 0, 'nav', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (175, 174, '添加', 'admin/zhuanti/add', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (176, 174, '编辑', 'admin/zhuanti/edit', '', 0, 'auth', 0, 1);
INSERT INTO `hq_auth_rule` VALUES (177, 174, '删除', 'admin/zhuanti/del', '', 0, 'auth', 0, 1);

-- ----------------------------
-- Table structure for hq_category
-- ----------------------------
DROP TABLE IF EXISTS `hq_category`;
CREATE TABLE `hq_category`  (
  `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类名称',
  `pid` int(5) NOT NULL DEFAULT 0 COMMENT '上级栏目',
  `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类图片',
  `sort_order` tinyint(10) NOT NULL DEFAULT 100 COMMENT '排序',
  `status` tinyint(5) NOT NULL DEFAULT 1 COMMENT '状态',
  `keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关键字',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '页面URL',
  `wxapp_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小程序URL',
  `model` tinyint(5) NULL DEFAULT NULL COMMENT '模型类型',
  `template_class` tinyint(5) NOT NULL DEFAULT 1 COMMENT '分类模板ID',
  `is_tuijian` tinyint(3) NOT NULL DEFAULT 0 COMMENT '是否推荐 0不推荐 1推荐',
  `is_login` tinyint(3) NOT NULL DEFAULT 0 COMMENT '是否登陆 0不登录 1登陆',
  `is_service` tinyint(3) NOT NULL DEFAULT 1 COMMENT '显示客服 0不显示 1显示',
  `is_share` tinyint(3) NOT NULL DEFAULT 1 COMMENT '是否分享 0不分享 1分享',
  `create_time` int(10) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `update_time` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `delete_time` int(10) NOT NULL DEFAULT 0 COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 59 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of hq_category
-- ----------------------------
INSERT INTO `hq_category` VALUES (53, '公司介绍', 0, 'https://mdf.muxue.com.cn/uploads/20200814/bed575473ed1f67de641b594d04cc33d.png', 100, 1, '', '', '/lists/53.html', '/pages/list/index?id=53', 1, 3, 0, 1, 1, 1, 1596717154, 1597754763, 0);
INSERT INTO `hq_category` VALUES (54, '解决方案', 0, 'https://mdf.muxue.com.cn/uploads/20200814/dc522ab7d0b9297713b8e4a30911cfa0.png', 5, 1, '', '', '/lists/54.html', '/pages/zhuanti/index?id=54', 2, 6, 0, 1, 1, 1, 1596717181, 1597754983, 0);
INSERT INTO `hq_category` VALUES (55, '公司产品', 0, 'https://mdf.muxue.com.cn/uploads/20200814/83266d48b1287cb4728d253daad79964.png', 10, 1, '', '', '/lists/55.html', '/pages/list/index?id=55', 1, 5, 0, 1, 1, 1, 1596717247, 1597756955, 0);
INSERT INTO `hq_category` VALUES (56, '联系方式', 0, 'https://mdf.muxue.com.cn/uploads/20200814/63b2a680fc29477498573b44b5773645.png', 1, 1, '', '', '/lists/56.html', '/pages/list/index?id=56', 1, 4, 0, 1, 1, 1, 1597378323, 1597378585, 0);
INSERT INTO `hq_category` VALUES (57, '产品', 0, 'https://mdf.muxue.com.cn/uploads/20200826/6dc7f56297906a86445d6d7e219ef60b.jpeg', 100, 1, NULL, NULL, '/lists/57.html', '/pages/goods/index?id=57', 7, 8, 0, 0, 1, 1, 1598347740, 1598868647, 0);
INSERT INTO `hq_category` VALUES (58, '好棒', 0, 'https://mdf.muxue.com.cn/uploads/20200911/65ba613583211e1fcc3fd030b18402dd.png', 100, 1, NULL, NULL, '/lists/58.html', '/pages/list/index?id=58', 9, 0, 0, 0, 1, 1, 1599791184, 1599791184, 0);

-- ----------------------------
-- Table structure for hq_category_model
-- ----------------------------
DROP TABLE IF EXISTS `hq_category_model`;
CREATE TABLE `hq_category_model`  (
  `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `pid` tinyint(6) NOT NULL DEFAULT 0 COMMENT '上级ID',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '模型名称',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '模型表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of hq_category_model
-- ----------------------------
INSERT INTO `hq_category_model` VALUES (1, 0, '文章模型');
INSERT INTO `hq_category_model` VALUES (2, 0, '专题模型');
INSERT INTO `hq_category_model` VALUES (3, 1, '新闻样式');
INSERT INTO `hq_category_model` VALUES (4, 1, '大图样式');
INSERT INTO `hq_category_model` VALUES (5, 1, '小图样式');
INSERT INTO `hq_category_model` VALUES (6, 2, '专题样式');
INSERT INTO `hq_category_model` VALUES (7, 0, '产品模型');
INSERT INTO `hq_category_model` VALUES (8, 7, '产品样式');
INSERT INTO `hq_category_model` VALUES (9, 0, '跳转链接');

-- ----------------------------
-- Table structure for hq_dict
-- ----------------------------
DROP TABLE IF EXISTS `hq_dict`;
CREATE TABLE `hq_dict`  (
  `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `auth_id` int(3) NOT NULL DEFAULT 0 COMMENT '所属权限',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '字典类目名称',
  `sort_order` tinyint(5) NULL DEFAULT 10 COMMENT '排序',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of hq_dict
-- ----------------------------
INSERT INTO `hq_dict` VALUES (5, 0, '轮播分类', 10);
INSERT INTO `hq_dict` VALUES (9, 0, '客户标签', 10);

-- ----------------------------
-- Table structure for hq_dict_data
-- ----------------------------
DROP TABLE IF EXISTS `hq_dict_data`;
CREATE TABLE `hq_dict_data`  (
  `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `dict_id` int(3) NOT NULL DEFAULT 0 COMMENT '字典ID',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '字典名称',
  `sort_order` tinyint(10) NOT NULL DEFAULT 0 COMMENT '排序',
  `status` tinyint(10) NOT NULL DEFAULT 1 COMMENT '状态 0禁用 1启用',
  `create_time` int(10) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `update_time` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `delete_time` int(10) NOT NULL DEFAULT 0 COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '字典数据' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of hq_dict_data
-- ----------------------------
INSERT INTO `hq_dict_data` VALUES (33, 5, '小程序首页轮播', 0, 1, 1591758692, 1591758692, 0);
INSERT INTO `hq_dict_data` VALUES (34, 5, '1112', 0, 1, 1597372531, 1601043616, 1601043616);
INSERT INTO `hq_dict_data` VALUES (35, 9, '靠谱客户', 0, 1, 1599631927, 1599631927, 0);
INSERT INTO `hq_dict_data` VALUES (36, 9, '牛逼客户', 0, 1, 1599631932, 1599631932, 0);
INSERT INTO `hq_dict_data` VALUES (37, 10, '植发', 0, 1, 1599631939, 1601043547, 1601043547);
INSERT INTO `hq_dict_data` VALUES (38, 10, '植眉', 0, 1, 1599631947, 1601043549, 1601043549);
INSERT INTO `hq_dict_data` VALUES (39, 11, '美容院', 0, 1, 1600825053, 1601043556, 1601043556);
INSERT INTO `hq_dict_data` VALUES (40, 11, '美发店', 0, 1, 1600825062, 1601043559, 1601043559);
INSERT INTO `hq_dict_data` VALUES (41, 11, '个人代理', 0, 1, 1600825068, 1601043562, 1601043562);

-- ----------------------------
-- Table structure for hq_system
-- ----------------------------
DROP TABLE IF EXISTS `hq_system`;
CREATE TABLE `hq_system`  (
  `id` int(3) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `key` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置字段',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '配置名称',
  `jdata` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '配置参数',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '系统配置表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of hq_system
-- ----------------------------
INSERT INTO `hq_system` VALUES (1, 'website', '网站配置', '{\"logo\":\"http:\\/\\/admin.ennn.cn\\/uploads\\/20200925\\/7b18b226c7fb6cd029bc6b5caeeb038d.png\",\"sitename\":\"1\",\"title\":\"323\",\"keywords\":\"13\",\"description\":\"42\",\"copyright\":\"5sddfas\",\"beian\":\"6sad\"}');
INSERT INTO `hq_system` VALUES (2, 'qiniu', '七牛配置', '{\"model\":\"qiniu\",\"ak\":\"1\",\"sk\":\"2\",\"bucket\":\"3\",\"domain\":\"4\",\"type\":\"0\"}');
INSERT INTO `hq_system` VALUES (3, 'weixin', '公众号配置', '{\"model\":\"weixin\",\"appid\":\"11\",\"appsecret\":\"22\",\"token\":\"liunuoyun33\",\"aes_key\":\"44\",\"type\":\"0\"}');
INSERT INTO `hq_system` VALUES (4, 'wxapp', '小程序配置', '{\"model\":\"wxapp\",\"appid\":\"44\",\"appsecret\":\"55\",\"type\":\"0\"}');
INSERT INTO `hq_system` VALUES (5, 'wxpay', '微信支付配置', '{\"model\":\"wxpay\",\"appid\":\"66\",\"mch_id\":\"77\",\"key\":\"88\",\"notify_url\":\"4\",\"certpem\":\"111\",\"keypem\":\"333\",\"type\":\"0\"}');
INSERT INTO `hq_system` VALUES (6, 'qcloudsms', '腾讯云短信', NULL);
INSERT INTO `hq_system` VALUES (7, 'haibao', '海报配置', '{\"bgimg\":\"https://mdf.muxue.com.cn/uploads/20200811/1f58f92c34dd962e82606fd576604ec2.jpg\",\"qrname\":\"\\u516d\\u8bfa\\u79d1\\u6280 \\u957f\\u6309\\u4fdd\\u5b58\"}');
INSERT INTO `hq_system` VALUES (8, 'login', '小程序登陆配置', '{\"login_bg\":\"https:\\/\\/mdf.muxue.com.cn\\/uploads\\/20200811\\/f3b3ca0fecc31e65819cdba144dcedf2.jpg\",\"login_range\":\"150\",\"login_title\":\"\\u8d26\\u53f7\\u767b\\u9646\",\"login_is_kong\":\"on\",\"coupon_image\":\"https:\\/\\/mdf.muxue.com.cn\\/uploads\\/20200910\\/c13b9938bc1ded62bb63a066d8b31ffa.png\",\"coupon_bg\":\"https:\\/\\/mdf.muxue.com.cn\\/uploads\\/20200829\\/5cf40f9f3c3c345fababa69eeb9885cb.png\",\"share_img\":\"https:\\/\\/mdf.muxue.com.cn\\/uploads\\/20200906\\/7d4c9189df5add423265d589365d4a8a.jpg\",\"share_title\":\"\\u8fd9\\u662f\\u5206\\u4eab\\u670b\\u53cb\\u5708\\u7684\",\"agent_name1\":\"\\u6211\\u7684\\u5e97\\u5bb6\",\"agent_name2\":\"\\u4e8c\\u7ea7\\u5ba2\\u6237\",\"agent_name3\":\"\\u6211\\u7684\\u5ba2\\u6237\"}');
INSERT INTO `hq_system` VALUES (9, 'customer', '客户配置', '{\"exp_day\":\"90\",\"level\":\"2\",\"relation_name_1\":\"\\u5e97\\u5bb6\",\"relation_price_a1\":\"30\",\"relation_price_a2\":\"3.5\",\"relation_name_2\":\"\\u5408\\u4f19\\u4eba\",\"relation_price_b1\":\"40\",\"relation_price_b2\":\"10\",\"is_tixian\":\"1\"}');
INSERT INTO `hq_system` VALUES (10, 'upload_setting', '上传选项', NULL);
INSERT INTO `hq_system` VALUES (11, 'system', '系统配置', '{\"title\":\"\\u4e91\\u4ee3\\u7406\\u5546\\u7cfb\\u7edf\",\"custom_image\":\"https:\\/\\/mdf.muxue.com.cn\\/uploads\\/20200913\\/e4e3a9cae949578bd9a09303b9efa843.png\",\"custom_color\":\"#8dc63f\",\"custom_textcolor\":\"#333333\",\"color\":\"#f37b1d\",\"is_back\":\"on\"}');

-- ----------------------------
-- Table structure for hq_uploads
-- ----------------------------
DROP TABLE IF EXISTS `hq_uploads`;
CREATE TABLE `hq_uploads`  (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `shop_id` int(5) NULL DEFAULT 0 COMMENT '商户ID',
  `user_id` int(5) UNSIGNED NULL DEFAULT 0 COMMENT '用户ID',
  `storage` char(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '存储位置',
  `file_url` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '存储域名',
  `file_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件名',
  `file_size` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件大小',
  `mine` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `status` int(3) NULL DEFAULT 1 COMMENT '状态',
  `create_time` int(10) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `update_time` int(10) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `delete_time` int(10) NOT NULL DEFAULT 0 COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 226 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '上传数据表' ROW_FORMAT = DYNAMIC;

-- ----------------------------
-- Records of hq_uploads
-- ----------------------------
INSERT INTO `hq_uploads` VALUES (225, 0, 1, 'local', '', 'uploads/20200925/7b18b226c7fb6cd029bc6b5caeeb038d.png', '68182', 'image/png', 1, 1601042114, 1601042114, 0);

-- ----------------------------
-- Table structure for hq_user
-- ----------------------------
DROP TABLE IF EXISTS `hq_user`;
CREATE TABLE `hq_user`  (
  `id` int(5) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `name` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名 ',
  `mobile` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '手机号码',
  `nickname` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '昵称',
  `avatarurl` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',
  `gender` tinyint(3) NULL DEFAULT NULL COMMENT '性别',
  `province` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '省',
  `city` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '市',
  `region` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '区县',
  `openid` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'OPENID',
  `is_customer` tinyint(2) NOT NULL DEFAULT 1 COMMENT '是否客户 0无效用户 1普通用户 2客户',
  `is_agent` tinyint(2) NOT NULL DEFAULT 0 COMMENT '是否代理商 0否 1普通代理商  2商家代理商',
  `agent_type` smallint(5) NOT NULL DEFAULT 0 COMMENT '代理商标签',
  `is_deal` tinyint(2) NOT NULL DEFAULT 0 COMMENT '是否成交 0否 1是',
  `status` tinyint(5) NULL DEFAULT 1 COMMENT '状态 0禁用 1启用',
  `balance` decimal(10, 2) NULL DEFAULT 0.00 COMMENT '账户余额',
  `sort_order` int(5) NOT NULL DEFAULT 100 COMMENT '排序',
  `tags` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户标签',
  `remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户备注',
  `show_coupon_time` int(11) NOT NULL DEFAULT 0 COMMENT '优惠券弹窗时间',
  `service_id` int(5) NOT NULL DEFAULT 0 COMMENT '客服ID',
  `unread_service` mediumint(10) NOT NULL DEFAULT 0 COMMENT '客服未读',
  `unread_relation` mediumint(10) NOT NULL DEFAULT 0 COMMENT '代理商未读',
  `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `delete_time` int(11) NOT NULL DEFAULT 0 COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of hq_user
-- ----------------------------

-- ----------------------------
-- Table structure for hq_zhuanti
-- ----------------------------
DROP TABLE IF EXISTS `hq_zhuanti`;
CREATE TABLE `hq_zhuanti`  (
  `id` int(8) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'ID',
  `user_id` int(5) NOT NULL DEFAULT 0 COMMENT 'ID',
  `cid` int(5) NOT NULL COMMENT '分类ID',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标题',
  `tags` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '标签',
  `keywords` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '关键字',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '封面',
  `view` int(10) NOT NULL DEFAULT 0 COMMENT '阅读量',
  `comment` int(10) NOT NULL DEFAULT 0 COMMENT '评论数',
  `like` int(10) NOT NULL DEFAULT 0 COMMENT '点赞数',
  `favor` int(10) NOT NULL DEFAULT 0 COMMENT '收藏数',
  `content` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '详细内容',
  `sort_order` tinyint(5) NOT NULL DEFAULT 100 COMMENT '排序',
  `status` tinyint(5) NOT NULL DEFAULT 0 COMMENT '状态 0待审核 1审核通过 2审核拒绝',
  `url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'URL',
  `wxapp_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '小程序链接',
  `is_hot` tinyint(3) NOT NULL DEFAULT 0 COMMENT '是否热门 0不热门 1热门',
  `is_tuijian` tinyint(3) NOT NULL DEFAULT 0 COMMENT '是否推荐 0不推荐 1推荐',
  `create_time` int(11) NOT NULL DEFAULT 0 COMMENT '创建时间',
  `update_time` int(11) NOT NULL DEFAULT 0 COMMENT '更新时间',
  `delete_time` int(11) NOT NULL DEFAULT 0 COMMENT '删除时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 130 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '专题表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of hq_zhuanti
-- ----------------------------
INSERT INTO `hq_zhuanti` VALUES (128, 0, 54, '这是一篇文章', '是的啊,是打发萨顶顶,是发送', '是打发', '沙发是打发是打发啊是打发阿什顿发阿什顿发是打发啥都发是打发啥都发', 'https://mdf.muxue.com.cn/uploads/20200811/19019ae3e698cb4dd052ea0fe7d3ea78.png', 6, 0, 0, 0, '<p><img src=\"https://mdf.muxue.com.cn/uploads/20200811/b3e76c813ac225e526de74f891265f04.png\" /></p>\r\n<p>啊是打发爱上大是打发啊少的地方了王嘉尔;发市场艾维尔</p>\r\n<p>发阿什顿啊市场问查完人才市场微创</p>', 100, 1, '/show/128.html', '/pages/list/article?id=128', 0, 0, 1597126342, 1597209144, 1597209144);
INSERT INTO `hq_zhuanti` VALUES (129, 0, 54, '普通的专题', '', '啥是打发啥都,地方,啊', '是的发烧地方阿什顿发是打发', 'https://mdf.muxue.com.cn/uploads/20200812/381c1e3f0f8750de0094d67edb2e61ae.jpg', 67, 0, 0, 0, '<p><img src=\"https://mdf.muxue.com.cn/uploads/20200812/09ad64a48ae491366337fa493f42612f.jpg\" alt=\"\" width=\"600\" height=\"4735\" /></p>', 100, 1, '/show/129.html', '/pages/zhuanti/article?id=129', 0, 0, 1597126376, 1597221223, 0);

SET FOREIGN_KEY_CHECKS = 1;