/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50726
 Source Host           : 127.0.0.1:3306
 Source Schema         : hyperf_cms

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

 Date: 25/08/2021 23:33:04
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for advice
-- ----------------------------
DROP TABLE IF EXISTS `advice`;
CREATE TABLE `advice`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '标题',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '内容',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态（0：待解决，1：已解决，2：关闭）',
  `reply` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '回复内容',
  `type` tinyint(4) NOT NULL DEFAULT 0 COMMENT '类型（0：bug，1：优化，2：混合',
  `created_at` timestamp(0) DEFAULT NULL,
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '字典数据表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for chat_friend
-- ----------------------------
DROP TABLE IF EXISTS `chat_friend`;
CREATE TABLE `chat_friend`  (
  `user_id` int(10) UNSIGNED NOT NULL,
  `friend_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `create_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for chat_group
-- ----------------------------
DROP TABLE IF EXISTS `chat_group`;
CREATE TABLE `chat_group`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
  `chat_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '会话id',
  `admin_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '群主id',
  `show_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '群名称',
  `user_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '群员id列表',
  `is_forbit` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '是否禁言',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for chat_group_history
-- ----------------------------
DROP TABLE IF EXISTS `chat_group_history`;
CREATE TABLE `chat_group_history`  (
  `list_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `type` int(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '消息类型',
  `msg_type` int(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '0用户消息1系统消息',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `create_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0)
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for chat_history
-- ----------------------------
DROP TABLE IF EXISTS `chat_history`;
CREATE TABLE `chat_history`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'id',
  `chat_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '会话id',
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '用户id',
  `type` int(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '消息类型',
  `msg_type` int(2) UNSIGNED NOT NULL DEFAULT 0 COMMENT '0用户消息1系统消息',
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '内容',
  `create_at` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for chat_list
-- ----------------------------
DROP TABLE IF EXISTS `chat_list`;
CREATE TABLE `chat_list`  (
  `chat_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'uid',
  `friend_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '朋友id',
  `type` tinyint(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '0个人，1群聊',
  `status` tinyint(1) UNSIGNED NOT NULL DEFAULT 1 COMMENT '1显示，0不显示',
  `user_ids` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '群成员id',
  `not_read_num` int(11) UNSIGNED NOT NULL DEFAULT 0 COMMENT '未读数量',
  PRIMARY KEY (`chat_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for chat_member
-- ----------------------------
DROP TABLE IF EXISTS `chat_member`;
CREATE TABLE `chat_member`  (
  `chat_id` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '会话id',
  `user_id` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT 'uid',
  `not_read_num` int(10) UNSIGNED NOT NULL DEFAULT 0 COMMENT '未读消息数量',
  `status` int(1) UNSIGNED NOT NULL DEFAULT 0 COMMENT '1显示0不显示',
  PRIMARY KEY (`chat_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for dict_data
-- ----------------------------
DROP TABLE IF EXISTS `dict_data`;
CREATE TABLE `dict_data`  (
  `dict_code` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '字典编码',
  `dict_sort` int(11) NOT NULL DEFAULT 0 COMMENT '字典排序',
  `dict_label` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '字典标签',
  `dict_value` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '字典键值',
  `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '字典类型',
  `css_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '样式属性（其他样式扩展）',
  `list_class` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '表格回显样式',
  `is_default` tinyint(4) NOT NULL DEFAULT 1 COMMENT '是否默认（Y是 N否）',
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '状态（0正常 1停用）',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '备注',
  `created_at` timestamp(0) DEFAULT NULL,
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`dict_code`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 33 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of dict_data
-- ----------------------------
INSERT INTO `dict_data` VALUES (1, 1, '男', '0', 'sys_user_sex', '', '', 1, 1, '性别男', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (2, 1, '女', '1', 'sys_user_sex', '', '', 1, 1, '性别女', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (3, 1, '未知', '2', 'sys_user_sex', '', '', 1, 1, '性别未知', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (4, 1, '启动', '1', 'sys_user_status', '', '', 1, 1, '用户启动状态', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (5, 1, '禁用', '0', 'sys_user_status', '', '', 1, 1, '用户禁用状态', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (6, 1, '启用', '1', 'sys_permission_status', '', '', 1, 1, '权限启用状态', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (7, 1, '禁用', '0', 'sys_permission_status', '', '', 1, 1, '权限禁用状态', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (8, 1, '是', '1', 'sys_permission_hidden', '', '', 1, 1, '隐藏权限', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (9, 1, '否', '0', 'sys_permission_hidden', '', '', 1, 1, '不隐藏权限', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (10, 1, '菜单', '1', 'sys_permission_type', '', '', 1, 1, '菜单权限类型', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (11, 1, '按钮', '2', 'sys_permission_type', '', '', 1, 1, '按钮权限类型', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (12, 1, '接口', '3', 'sys_permission_type', '', '', 1, 1, '接口权限类型', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (13, 1, 'bug', '0', 'sys_advice_type', '', '', 1, 1, 'bug类型', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (14, 1, '优化', '1', 'sys_advice_type', '', '', 1, 1, '优化类型', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (15, 1, '混合', '2', 'sys_advice_type', '', '', 1, 1, '混合类型', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (16, 1, '待解决', '0', 'sys_advice_status', '', '', 1, 1, '待解决状态', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (17, 1, '已解决', '1', 'sys_advice_status', '', '', 1, 1, '已解决状态', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (18, 1, '关闭', '2', 'sys_advice_status', '', '', 1, 1, '关闭状态', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (19, 1, '未发布', '0', 'sys_notice_status', '', '', 1, 1, '未发布状态', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (20, 1, '已发布', '1', 'sys_notice_status', '', '', 1, 1, '已发布状态', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (21, 1, '启动', '1', 'blog_album_status', '', '', 1, 1, '相册启动状态', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (22, 2, '禁用', '0', 'blog_album_status', '', '', 1, 1, '相册禁用状态', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (23, 1, '普通相册', '1', 'blog_album_type', '', '', 1, 1, '普通相册', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (24, 2, '密码相册', '2', 'blog_album_type', '', '', 1, 1, '密码相册', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (25, 1, '启用', '1', 'sys_timed_task_status', '', '', 1, 1, '启用状态', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (26, 1, '禁用', '0', 'sys_timed_task_status', '', '', 1, 1, '禁用状态', '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_data` VALUES (27, 1, '是', '1', 'sys_permission_is_link', '', '', 1, 1, '是外链', '2021-06-15 11:47:19', '2021-06-15 11:47:19');
INSERT INTO `dict_data` VALUES (28, 1, '否', '0', 'sys_permission_is_link', '', '', 1, 1, '不是外链', '2021-06-15 11:47:31', '2021-06-15 11:47:31');
INSERT INTO `dict_data` VALUES (29, 1, '文本', 'text', 'sys_global_config_type', '', '', 1, 1, '文本类型(string, int)', '2021-06-17 10:30:03', '2021-06-17 10:30:03');
INSERT INTO `dict_data` VALUES (30, 1, '布尔值', 'boolean', 'sys_global_config_type', '', '', 1, 1, '布尔值类型', '2021-06-17 10:30:29', '2021-06-17 10:30:29');
INSERT INTO `dict_data` VALUES (31, 1, 'HTML', 'html', 'sys_global_config_type', '', '', 1, 1, 'HTML格式', '2021-06-17 10:30:45', '2021-06-17 10:30:45');
INSERT INTO `dict_data` VALUES (32, 1, 'JSON', 'json', 'sys_global_config_type', '', '', 1, 1, 'json格式', '2021-06-17 10:31:02', '2021-06-17 10:31:02');

-- ----------------------------
-- Table structure for dict_type
-- ----------------------------
DROP TABLE IF EXISTS `dict_type`;
CREATE TABLE `dict_type`  (
  `dict_id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '字典主键',
  `dict_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '字典名称',
  `dict_type` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '字典类型',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '状态（0正常 1停用）',
  `created_at` timestamp(0) DEFAULT NULL,
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`dict_id`) USING BTREE,
  UNIQUE INDEX `dict_type`(`dict_type`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '字典类型表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of dict_type
-- ----------------------------
INSERT INTO `dict_type` VALUES (1, '用户性别', 'sys_user_sex', '用户性别列表', 1, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_type` VALUES (2, '用户状态', 'sys_user_status', '用户状态列表', 1, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_type` VALUES (3, '权限状态', 'sys_permission_status', '权限状态列表', 1, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_type` VALUES (4, '权限隐藏是否', 'sys_permission_hidden', '权限是否隐藏', 1, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_type` VALUES (5, '权限类型', 'sys_permission_type', '权限类型列表', 1, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_type` VALUES (6, '系统建议类型', 'sys_advice_type', '系统建议类型', 1, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_type` VALUES (7, '系统建议状态', 'sys_advice_status', '系统建议状态', 1, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_type` VALUES (8, '通知管理状态', 'sys_notice_status', '通知管理的状态枚举', 1, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_type` VALUES (9, '相册状态', 'blog_album_status', '相册的启动状态', 1, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_type` VALUES (10, '相册类型', 'blog_album_type', '相册类型枚举', 1, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_type` VALUES (12, '定时任务状态', 'sys_timed_task_status', '定时任务的状态枚举', 1, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `dict_type` VALUES (13, '权限是否外链', 'sys_permission_is_link', '菜单是否外链', 1, '2021-06-15 11:47:07', '2021-06-15 11:47:07');
INSERT INTO `dict_type` VALUES (14, '参数设置类型枚举', 'sys_global_config_type', '参数设置模块的类型相关枚举', 1, '2021-06-17 10:29:41', '2021-06-17 10:29:41');

-- ----------------------------
-- Table structure for global_config
-- ----------------------------
DROP TABLE IF EXISTS `global_config`;
CREATE TABLE `global_config`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `key_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'keyName',
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
  `type` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'text' COMMENT '类型 text html json boolean',
  `remark` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注',
  `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '数据',
  `created_at` timestamp(0) DEFAULT NULL,
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  UNIQUE INDEX `key_name_unique`(`key_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '参数配置表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of global_config
-- ----------------------------
INSERT INTO `global_config` VALUES (1, 'maintain_switch', '维护模式开关', 'boolean', '用来控制系统维护模式是否开启开关 默认为关', '0', '2021-06-17 11:01:19', '2021-06-18 10:28:33');
INSERT INTO `global_config` VALUES (2, 'simple_maintain_switch', '简易维护模式', 'boolean', '用来维护系统的简易维护模式开关', '0', '2021-06-17 11:17:34', '2021-06-18 10:28:35');
INSERT INTO `global_config` VALUES (3, 'register_switch', '后台注册入口开关', 'boolean', '后台注册入口开关', '1', '2021-06-17 11:18:18', '2021-06-17 20:06:43');

-- ----------------------------
-- Table structure for login_log
-- ----------------------------
DROP TABLE IF EXISTS `login_log`;
CREATE TABLE `login_log`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户名称',
  `login_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '登陆IP地址',
  `login_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '登陆地址',
  `login_browser` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '登陆浏览器',
  `os` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '操作系统',
  `response_result` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '返回结果',
  `response_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '返回状态码',
  `login_date` datetime(0) NOT NULL COMMENT '登陆时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 82 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '登陆日志' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of login_log
-- ----------------------------
INSERT INTO `login_log` VALUES (1, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误', '1005', '2021-07-05 00:08:37');
INSERT INTO `login_log` VALUES (2, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误', '1005', '2021-07-05 00:10:19');
INSERT INTO `login_log` VALUES (3, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误', '1005', '2021-07-05 00:13:29');
INSERT INTO `login_log` VALUES (4, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误', '1005', '2021-07-05 00:35:59');
INSERT INTO `login_log` VALUES (5, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误GXsx', '1005', '2021-07-05 00:36:08');
INSERT INTO `login_log` VALUES (6, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误8OYI', '1005', '2021-07-05 00:36:12');
INSERT INTO `login_log` VALUES (7, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误XWSN', '1005', '2021-07-05 00:36:15');
INSERT INTO `login_log` VALUES (8, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误olDE', '1005', '2021-07-05 00:36:19');
INSERT INTO `login_log` VALUES (9, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误iXPw', '1005', '2021-07-05 00:36:22');
INSERT INTO `login_log` VALUES (10, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误g8AF', '1005', '2021-07-05 00:36:27');
INSERT INTO `login_log` VALUES (11, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误0uEV', '1005', '2021-07-05 00:36:29');
INSERT INTO `login_log` VALUES (12, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误KkAj', '1005', '2021-07-05 00:36:33');
INSERT INTO `login_log` VALUES (13, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误jwfO', '1005', '2021-07-05 00:36:36');
INSERT INTO `login_log` VALUES (14, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误sR4y', '1005', '2021-07-05 00:36:38');
INSERT INTO `login_log` VALUES (15, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误TbQG', '1005', '2021-07-05 00:36:40');
INSERT INTO `login_log` VALUES (16, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误38xo', '1005', '2021-07-05 00:36:42');
INSERT INTO `login_log` VALUES (17, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误1AoU', '1005', '2021-07-05 00:36:43');
INSERT INTO `login_log` VALUES (18, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误a6KI', '1005', '2021-07-05 00:36:48');
INSERT INTO `login_log` VALUES (19, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误jO6Q', '1005', '2021-07-05 00:36:51');
INSERT INTO `login_log` VALUES (20, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误jaSP', '1005', '2021-07-05 00:36:52');
INSERT INTO `login_log` VALUES (21, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误p3ND', '1005', '2021-07-05 00:37:01');
INSERT INTO `login_log` VALUES (22, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误Iqn3', '1005', '2021-07-05 00:37:03');
INSERT INTO `login_log` VALUES (23, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误gIdc', '1005', '2021-07-05 00:37:05');
INSERT INTO `login_log` VALUES (24, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误NaYp', '1005', '2021-07-05 00:37:08');
INSERT INTO `login_log` VALUES (25, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误yK5N', '1005', '2021-07-05 00:37:11');
INSERT INTO `login_log` VALUES (26, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '验证失败，验证码错误6oH9', '1005', '2021-07-05 00:37:13');
INSERT INTO `login_log` VALUES (27, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '登陆成功', '200', '2021-07-05 00:37:22');
INSERT INTO `login_log` VALUES (28, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '登陆成功', '200', '2021-07-05 19:55:16');
INSERT INTO `login_log` VALUES (29, 'admin@admin.com', '172.17.0.1', '', 'Chrome', 'Windows', '登陆成功', '200', '2021-07-07 01:50:37');
INSERT INTO `login_log` VALUES (30, 'admin@admin.com', '192.168.137.1', '', 'Chrome', 'Windows', '验证失败，验证码错误', '1005', '2021-08-15 03:24:08');
INSERT INTO `login_log` VALUES (31, 'admin@admin.com', '192.168.137.1', '', 'Chrome', 'Windows', '登陆成功', '200', '2021-08-15 03:24:16');
INSERT INTO `login_log` VALUES (32, 'wodsad', '192.168.137.1', '', 'Safari', 'MAC', '登录失败，用户不存在', '2003', '2021-08-15 17:02:09');
INSERT INTO `login_log` VALUES (33, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '验证失败，验证码错误', '1005', '2021-08-15 17:03:22');
INSERT INTO `login_log` VALUES (34, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-15 17:03:56');
INSERT INTO `login_log` VALUES (35, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-15 17:10:50');
INSERT INTO `login_log` VALUES (36, 'admin@admin.com', '192.168.137.1', '', 'Chrome', 'Windows', '验证失败，验证码错误', '1005', '2021-08-15 18:37:58');
INSERT INTO `login_log` VALUES (37, 'admin@admin.com', '192.168.137.1', '', 'Chrome', 'Windows', '登陆成功', '200', '2021-08-15 18:38:10');
INSERT INTO `login_log` VALUES (38, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-15 23:40:15');
INSERT INTO `login_log` VALUES (39, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-15 23:46:55');
INSERT INTO `login_log` VALUES (40, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '验证失败，验证码错误', '1005', '2021-08-15 23:53:01');
INSERT INTO `login_log` VALUES (41, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-15 23:53:10');
INSERT INTO `login_log` VALUES (42, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-15 23:55:41');
INSERT INTO `login_log` VALUES (43, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-15 23:58:19');
INSERT INTO `login_log` VALUES (44, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-15 23:59:40');
INSERT INTO `login_log` VALUES (45, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-16 00:03:44');
INSERT INTO `login_log` VALUES (46, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '验证失败，验证码错误', '1005', '2021-08-16 00:04:42');
INSERT INTO `login_log` VALUES (47, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-16 00:04:53');
INSERT INTO `login_log` VALUES (48, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-16 00:06:12');
INSERT INTO `login_log` VALUES (49, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-16 00:10:00');
INSERT INTO `login_log` VALUES (50, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-16 00:11:04');
INSERT INTO `login_log` VALUES (51, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-16 00:17:09');
INSERT INTO `login_log` VALUES (52, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-16 02:39:35');
INSERT INTO `login_log` VALUES (53, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-24 22:59:15');
INSERT INTO `login_log` VALUES (54, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '验证失败，验证码错误', '1005', '2021-08-24 23:00:36');
INSERT INTO `login_log` VALUES (55, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '验证失败，验证码错误', '1005', '2021-08-24 23:00:48');
INSERT INTO `login_log` VALUES (56, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-24 23:01:03');
INSERT INTO `login_log` VALUES (57, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-24 23:02:38');
INSERT INTO `login_log` VALUES (58, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-24 23:03:03');
INSERT INTO `login_log` VALUES (59, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '验证失败，验证码错误', '1005', '2021-08-24 23:03:45');
INSERT INTO `login_log` VALUES (60, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-24 23:04:00');
INSERT INTO `login_log` VALUES (61, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-24 23:04:57');
INSERT INTO `login_log` VALUES (62, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-24 23:07:17');
INSERT INTO `login_log` VALUES (63, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '验证失败，验证码错误', '1005', '2021-08-24 23:09:13');
INSERT INTO `login_log` VALUES (64, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-24 23:09:25');
INSERT INTO `login_log` VALUES (65, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-24 23:10:46');
INSERT INTO `login_log` VALUES (66, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '验证失败，验证码错误', '1005', '2021-08-24 23:13:45');
INSERT INTO `login_log` VALUES (67, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '验证失败，验证码错误', '1005', '2021-08-24 23:13:55');
INSERT INTO `login_log` VALUES (68, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-24 23:14:06');
INSERT INTO `login_log` VALUES (69, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-25 00:29:58');
INSERT INTO `login_log` VALUES (70, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-25 00:30:43');
INSERT INTO `login_log` VALUES (71, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-25 20:18:28');
INSERT INTO `login_log` VALUES (72, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '验证失败，验证码错误', '1005', '2021-08-25 20:36:28');
INSERT INTO `login_log` VALUES (73, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-25 20:36:38');
INSERT INTO `login_log` VALUES (74, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '验证失败，验证码错误', '1005', '2021-08-25 20:39:08');
INSERT INTO `login_log` VALUES (75, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-25 20:39:28');
INSERT INTO `login_log` VALUES (76, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '验证失败，验证码错误', '1005', '2021-08-25 22:49:47');
INSERT INTO `login_log` VALUES (77, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '验证失败，验证码错误', '1005', '2021-08-25 22:49:56');
INSERT INTO `login_log` VALUES (78, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '验证失败，验证码错误', '1005', '2021-08-25 22:53:21');
INSERT INTO `login_log` VALUES (79, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '验证失败，验证码错误', '1005', '2021-08-25 22:59:51');
INSERT INTO `login_log` VALUES (80, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '服务器错误 A non well formed numeric value encountered:: FILE:/mnt/www/hyperf-im/app/Foundation/Utils/JWT.php:: LINE: 38#0 /mnt/www/hyperf-im/app/Foundation/Utils/JWT.php(38): Hyperf\\ExceptionHandler\\Listener\\ErrorExceptionHandler::Hyperf\\ExceptionHa', '500', '2021-08-25 23:00:09');
INSERT INTO `login_log` VALUES (81, 'admin@admin.com', '192.168.137.1', '', 'Safari', 'MAC', '登陆成功', '200', '2021-08-25 23:06:34');

-- ----------------------------
-- Table structure for migrations
-- ----------------------------
DROP TABLE IF EXISTS `migrations`;
CREATE TABLE `migrations`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of migrations
-- ----------------------------
INSERT INTO `migrations` VALUES (1, '2020_09_21_072036_create_permission_tables', 1);
INSERT INTO `migrations` VALUES (2, '2020_09_21_072831_create_user_table', 1);
INSERT INTO `migrations` VALUES (3, '2020_11_06_072831_create_operate_log_table', 1);
INSERT INTO `migrations` VALUES (4, '2021_06_02_192155_create_advice_table', 1);
INSERT INTO `migrations` VALUES (5, '2021_06_02_192209_create_dict_type_table', 1);
INSERT INTO `migrations` VALUES (6, '2021_06_02_192215_create_dict_data_table', 1);
INSERT INTO `migrations` VALUES (7, '2021_06_02_192223_create_login_log_table', 1);
INSERT INTO `migrations` VALUES (8, '2021_06_02_192231_create_notice_table', 1);
INSERT INTO `migrations` VALUES (9, '2021_06_02_192244_create_timed_task_table', 1);
INSERT INTO `migrations` VALUES (10, '2021_06_02_192249_create_timed_task_log_table', 1);
INSERT INTO `migrations` VALUES (11, '2021_06_02_192258_create_photo_table', 1);
INSERT INTO `migrations` VALUES (12, '2021_06_02_192304_create_photo_album_table', 1);
INSERT INTO `migrations` VALUES (13, '2021_06_02_194802_create_ct_friend_chat_history_table', 1);
INSERT INTO `migrations` VALUES (14, '2021_06_02_194812_create_ct_friend_group_table', 1);
INSERT INTO `migrations` VALUES (15, '2021_06_02_194824_create_ct_friend_relation_table', 1);
INSERT INTO `migrations` VALUES (16, '2021_06_02_194832_create_ct_group_table', 1);
INSERT INTO `migrations` VALUES (17, '2021_06_02_194839_create_ct_group_chat_history_table', 1);
INSERT INTO `migrations` VALUES (18, '2021_06_02_194848_create_ct_group_relation_table', 1);
INSERT INTO `migrations` VALUES (19, '2021_06_02_194903_create_ct_user_application_table', 1);
INSERT INTO `migrations` VALUES (20, '2021_06_10_174700_create_global_config_table', 1);

-- ----------------------------
-- Table structure for model_has_permissions
-- ----------------------------
DROP TABLE IF EXISTS `model_has_permissions`;
CREATE TABLE `model_has_permissions`  (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`, `model_id`, `model_type`) USING BTREE,
  INDEX `model_has_permissions_model_id_model_type_index`(`model_id`, `model_type`) USING BTREE,
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for model_has_roles
-- ----------------------------
DROP TABLE IF EXISTS `model_has_roles`;
CREATE TABLE `model_has_roles`  (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(190) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL,
  PRIMARY KEY (`role_id`, `model_id`, `model_type`) USING BTREE,
  INDEX `model_has_roles_model_id_model_type_index`(`model_id`, `model_type`) USING BTREE,
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of model_has_roles
-- ----------------------------
INSERT INTO `model_has_roles` VALUES (1, 'App\\Model\\Auth\\User', 1);

-- ----------------------------
-- Table structure for notice
-- ----------------------------
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户名称',
  `user_id` int(11) NOT NULL DEFAULT 0 COMMENT '用户ID',
  `title` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '标题',
  `content` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '内容',
  `public_time` int(11) NOT NULL DEFAULT 0 COMMENT '发布时间',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '操作系统',
  `created_at` timestamp(0) DEFAULT NULL,
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `notice_public_time_index`(`public_time`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '系统通知表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of notice
-- ----------------------------
INSERT INTO `notice` VALUES (1, '超级用户', 1, '添加通知', '<p>添加通知添加通知添加通知</p>', 1625500800, 1, '2021-07-05 00:50:18', '2021-07-05 00:50:18');

-- ----------------------------
-- Table structure for operate_log
-- ----------------------------
DROP TABLE IF EXISTS `operate_log`;
CREATE TABLE `operate_log`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `action` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '操作',
  `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '请求参数',
  `username` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '操作人账号',
  `operator` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '操作人描述',
  `response_result` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '响应结果',
  `response_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '响应状态码',
  `target_class` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '目标类',
  `target_method` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '目标方法',
  `request_ip` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '请求IP',
  `request_method` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '请求方法',
  `target_url` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '目标路由',
  `uid` int(11) NOT NULL DEFAULT 0 COMMENT '操作人ID',
  `created_at` timestamp(0) DEFAULT NULL,
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of operate_log
-- ----------------------------
INSERT INTO `operate_log` VALUES (1, '添加系统通知', '{\"title\":\"\\u6dfb\\u52a0\\u901a\\u77e5\",\"status\":1,\"content\":\"<p>\\u6dfb\\u52a0\\u901a\\u77e5\\u6dfb\\u52a0\\u901a\\u77e5\\u6dfb\\u52a0\\u901a\\u77e5<\\/p>\",\"public_time\":\"2021-07-05T16:00:00.000Z\"}', 'admin@admin.com', '超级用户', '添加系统通知成功', '200', 'App\\Controller\\System\\NoticeController', 'store', '172.17.0.1', 'POST', '/setting/system_module/notice/store', 1, '2021-07-05 00:50:18', '2021-07-05 00:50:18');

-- ----------------------------
-- Table structure for permissions
-- ----------------------------
DROP TABLE IF EXISTS `permissions`;
CREATE TABLE `permissions`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '名称',
  `display_desc` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '描述',
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '路由地址',
  `component` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '组件地址',
  `guard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'web',
  `icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '图标',
  `type` tinyint(4) NOT NULL DEFAULT 1 COMMENT '类型：1: 目录 2：菜单 3：接口/按钮',
  `hidden` tinyint(4) NOT NULL DEFAULT 1 COMMENT '是否隐藏菜单 1:true 0 false',
  `is_link` tinyint(4) NOT NULL DEFAULT 0 COMMENT '是否外链',
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '启动状态1：启动 0：禁用',
  `sort` smallint(6) NOT NULL DEFAULT 99 COMMENT '排序，数字越大越在前面',
  `created_at` timestamp(0) DEFAULT NULL,
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 79 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of permissions
-- ----------------------------
INSERT INTO `permissions` VALUES (1, 0, 'Api:setting', '设置', '', '/setting', 'Layout', 'web', 'group_setting', 1, 0, 0, 1, 1, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (2, 1, 'Api:setting/user_module', '用户模块', '', '/setting/user_module', 'Layout', 'web', 'user', 1, 0, 0, 1, 1, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (3, 2, 'Api:setting/user_module/user', '用户管理', '对后台用户进行管理', '/setting/user_module/user/list', 'setting/user_module/user/index', 'web', 'product-list', 2, 0, 0, 1, 1, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (4, 3, 'Api:setting/user_module/user/list-index', '用户查询', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (5, 3, 'Api:setting/user_module/user/store-store', '用户添加', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (6, 3, 'Api:setting/user_module/user/update-update', '用户修改', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (7, 3, 'Api:setting/user_module/user/destroy-destroy', '用户删除', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (8, 3, 'Api:setting/user_module/user/change_status-changeStatus', '修改用户状态', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (9, 3, 'Api:setting/user_module/permission/accord_user_permission-accordUserPermission', '分配用户功能权限', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (10, 3, 'Api:setting/user_module/user/reset_password-resetPassword', '重置用户密码', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (11, 2, 'Api:setting/user_module/role', '角色管理', '对后台角色进行管理', '/setting/user_module/role/list', 'setting/user_module/role/index', 'web', 'role', 2, 0, 0, 1, 2, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (12, 11, 'Api:setting/user_module/role/list-index', '角色查询', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (13, 11, 'Api:setting/user_module/role/store-store', '角色添加', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (14, 11, 'Api:setting/user_module/role/update-update', '角色修改', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (15, 11, 'Api:setting/user_module/role/destroy-destroy', '角色删除', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (16, 11, 'Api:setting/user_module/permission/accord_role_permission-accordRolePermission', '分配角色权限', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (17, 2, 'Api:setting/user_module/permission', '权限管理', '对后台权限/菜单进行管理', '/setting/user_module/permission/list', 'setting/user_module/permission/index', 'web', 'permission', 2, 0, 0, 1, 3, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (18, 17, 'Api:setting/user_module/permission/list-index', '权限查询', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (19, 17, 'Api:setting/user_module/permission/store-store', '权限添加', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (20, 17, 'Api:setting/user_module/permission/update-update', '权限修改', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (21, 17, 'Api:setting/user_module/permission/destroy-destroy', '权限删除', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (22, 1, 'Api:setting/monitoring_module', '系统监控', '', '/setting/monitoring_module', 'Layout', 'web', 'monitoring_module', 1, 0, 0, 1, 2, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (23, 22, 'Api:setting/monitoring_module/serve-serve', '服务监控', '记录系统配置信息等', '/setting/monitoring_module/serve', 'setting/monitoring_module/serve/index', 'web', 'serve', 2, 0, 0, 1, 1, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (24, 22, 'Api:setting/monitoring_module/timed_task', '定时任务', '配置系统的定时任务', '/setting/monitoring_module/crontab', 'setting/monitoring_module/crontab/index', 'web', 'crontab', 2, 0, 0, 1, 2, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (25, 24, 'Api:setting/monitoring_module/timed_task/list-index', '查询定时任务', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (26, 24, 'Api:setting/monitoring_module/timed_task/store-store', '添加定时任务', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (27, 24, 'Api:setting/monitoring_module/timed_task/update-update', '修改定时任务', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (28, 24, 'Api:setting/monitoring_module/timed_task/destroy-destroy', '删除定时任务', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (29, 24, 'Api:setting/monitoring_module/timed_task/change_status-changeStatus', '修改定时任务状态', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (30, 1, 'Api:setting/system_module', '系统管理', '', '/setting/system_module', 'Layout', 'web', 'system_module', 1, 0, 0, 1, 3, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (31, 30, 'Api:setting/system_module/dict_type', '字典管理', '配置系统的枚举项', '/setting/system_module/dict/list', 'setting/system_module/dict/index', 'web', 'dict', 2, 0, 0, 1, 1, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (32, 31, 'Api:setting/system_module/dict_type/list-index', '字典查询', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (33, 31, 'Api:setting/system_module/dict_type/store-store', '字典添加', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (34, 31, 'Api:setting/system_module/dict_type/update-update', '字典修改', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (35, 31, 'Api:setting/system_module/dict_type/destroy-destroy', '字典删除', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (36, 30, 'Api:setting/system_module/dict_data', '字典数据', '字典数据列表', '/setting/system_module/dict_data/list/:dict_id', 'setting/system_module/dict/data', 'web', 'dict', 2, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (37, 36, 'Api:setting/system_module/dict_data/list-index', '查询字典数据', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (38, 36, 'Api:setting/system_module/dict_data/store-store', '添加字典数据', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (39, 36, 'Api:setting/system_module/dict_data/update-update', '修改字典数据', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (40, 36, 'Api:setting/system_module/dict_data/destory-destroy', '删除字典数据', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (41, 30, 'Api:setting/system_module/global_config', '参数设置', '配置项目中一些常用的参数', '/setting/system_module/global_config/config/list', 'setting/system_module/globalConfig/index', 'web', 'config', 2, 0, 0, 1, 2, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (42, 41, 'Api:setting/system_module/global_config/list-index', '参数查询', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (43, 41, 'Api:setting/system_module/global_config/store-store', '添加参数', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (44, 41, 'Api:setting/system_module/global_config/update-update', '修改参数', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (45, 41, 'Api:setting/system_module/global_config/destroy-destroy', '删除参数', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (46, 30, 'Api:setting/system_module/notice', '通知管理', '系统的一些广播通知', '/setting/system_module/notice', 'setting/system_module/notice', 'web', 'notice', 2, 0, 0, 1, 3, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (47, 46, 'Api:setting/system_module/notice/list-index', '通知查询', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (48, 46, 'Api:setting/system_module/notice/store-store', '添加通知', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (49, 46, 'Api:setting/system_module/notice/update-update', '修改通知', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (50, 46, 'Api:setting/system_module/notice/destroy-destroy', '删除通知', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (51, 30, 'Api:setting/system_module/advice', '系统建议', '提供给用户反馈bug以及优化需求', '/setting/system_module/advice', 'setting/system_module/advice', 'web', 'form', 2, 0, 0, 1, 4, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (52, 51, 'Api:setting/system_module/advice/list-index', '系统建议查询', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (53, 51, 'Api:setting/system_module/advice/store-store', '添加系统建议', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (54, 51, 'Api:setting/system_module/advice/update-update', '修改系统建议', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (55, 51, 'Api:setting/system_module/advice/destroy-destroy', '删除系统建议', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (56, 51, 'Api:setting/system_module/advice/reply-reply', '回复系统建议', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (57, 1, 'Api:setting/log_module', '日志管理', '', '/setting/log_module', 'Layout', 'web', 'log', 1, 0, 0, 1, 4, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (58, 57, 'Api:setting/log_module/operate_log/list-index', '操作日志', '记录用户的一些行为日志', '/setting/log_module/operate_log/list', 'setting/log_module/operateLog', 'web', 'operateLog', 2, 0, 0, 1, 1, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (59, 57, 'Api:setting/log_module/login_log/list-index', '登陆日志', '记录用户登陆信息', '/setting/log_module/login_log/list', 'setting/log_module/loginLog', 'web', 'loginLog', 2, 0, 0, 1, 2, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (60, 57, 'Api:setting/log_module/system_log', '系统日志', '系统的框架日志以及错误日志', '/setting/log_module/system_log/list', 'setting/log+module/systemLog', 'web', 'logs', 2, 0, 0, 1, 3, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (61, 60, 'Api:setting/log_module/system_log/log_path-getLogPath', '查询系统日志', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (62, 60, 'Api:setting/log_module/system_log/destroy_log-deleteLog', '删除系统日志', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (63, 1, 'Api:setting/technique_module', '技术支持', '', '/setting/technique_module', 'Layout', 'web', 'technique', 1, 0, 0, 1, 5, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (64, 63, 'Api:setting/technique_module/form_build-formBuild', '表单构建', '快速生成表单', '/setting/technique_module/form_build', 'setting/technique_module/formBuild', 'web', 'form', 2, 0, 0, 1, 1, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (65, 63, 'Api:setting/technique_module/json_decode-jsonDecode', 'Json解析', '用来解析json表达式', '/setting/technique_module/json_decode', 'setting/technique_module/jsonDecode', 'web', 'jsonDecode', 2, 0, 0, 1, 2, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (66, 0, 'Api:blog', '博客', '', '/blog', 'Layout', 'web', 'blog', 1, 0, 0, 1, 2, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (67, 66, 'Api:blog/picture_module', '图床模块', '相册网站的图片资源', '/blog/picture_module', 'Layout', 'web', 'pictureBed', 1, 0, 0, 1, 1, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (68, 67, 'Api:blog/picture_module/album', '相册管理', '相册模块管理', '/blog/picture_module/album', 'blog/picture_module/album', 'web', 'album', 2, 0, 0, 1, 1, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (69, 68, 'Api:blog/picture_module/album/list-index', '查询相册', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (70, 68, 'Api:blog/picture_module/album/store-store', '添加相册', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (71, 68, 'Api:blog/picture_module/album/update-update', '修改相册', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (72, 68, 'Api:blog/picture_module/album/destroy-destroy', '删除相册', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (73, 67, 'Api:blog/picture_module/photo', '图片模块', '图片管理模块', '/blog/picture_module/photo', 'blog/picture_module/photo', 'web', 'image', 2, 0, 0, 1, 2, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (74, 73, 'Api:blog/picture_module/photo/list-index', '查询图片', '', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (75, 73, 'Api:blog/picture_module/photo/destroy-destroy', '删除图片', '删除图片模块', '', '', 'web', '', 3, 1, 0, 1, 99, '2020-06-10 00:00:00', '2020-06-10 00:00:00');
INSERT INTO `permissions` VALUES (76, 63, 'Api:setting/technique_module/control', '后台控制', '用来控制项目后台的一些开光以及一些配置选项', '/setting/technique_module/control', 'setting/technique_module/control/', 'web', 'swagger', 2, 0, 0, 1, 3, '2021-06-17 09:48:18', '2021-06-17 16:39:24');
INSERT INTO `permissions` VALUES (77, 76, 'Api:setting/technique_module/control/list-getConfigList', '按钮查询', '获取按钮列表', '', '', 'web', '', 3, 0, 0, 1, 99, '2021-06-17 16:38:33', '2021-06-17 16:38:33');
INSERT INTO `permissions` VALUES (78, 76, 'Api:setting/technique_module/control/change_control-changeControl', '按钮控制', '修改按钮开关', '', '', 'web', '', 3, 0, 0, 1, 99, '2021-06-17 16:39:18', '2021-06-17 16:39:18');

-- ----------------------------
-- Table structure for photo
-- ----------------------------
DROP TABLE IF EXISTS `photo`;
CREATE TABLE `photo`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `photo_album` tinyint(4) NOT NULL COMMENT '所属相册',
  `photo_url` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '图片路径',
  `created_at` timestamp(0) DEFAULT NULL,
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '照片' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for photo_album
-- ----------------------------
DROP TABLE IF EXISTS `photo_album`;
CREATE TABLE `photo_album`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `album_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '相册名',
  `album_desc` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '相册描述',
  `album_cover` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '相册封面图',
  `album_type` int(11) NOT NULL DEFAULT 0 COMMENT '相册分类',
  `album_author` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0' COMMENT '相册作者',
  `album_click_num` int(11) NOT NULL DEFAULT 0 COMMENT '相册浏览数',
  `album_status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '相册状态 1：启用 0：禁用',
  `album_question` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' COMMENT '访问相册的问题',
  `album_answer` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1' COMMENT '访问相册的密码',
  `album_sort` int(11) NOT NULL DEFAULT 99 COMMENT '相册排序 数字越小越靠前',
  `created_at` timestamp(0) DEFAULT NULL,
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '相册' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for role_has_permissions
-- ----------------------------
DROP TABLE IF EXISTS `role_has_permissions`;
CREATE TABLE `role_has_permissions`  (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL,
  PRIMARY KEY (`permission_id`, `role_id`) USING BTREE,
  INDEX `role_has_permissions_role_id_foreign`(`role_id`) USING BTREE,
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for roles
-- ----------------------------
DROP TABLE IF EXISTS `roles`;
CREATE TABLE `roles`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp(0) DEFAULT NULL,
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of roles
-- ----------------------------
INSERT INTO `roles` VALUES (1, 'super_admin', '超级管理员', 'web', '2021-07-05 00:00:49', '2021-07-05 00:00:49');
INSERT INTO `roles` VALUES (2, 'default_admin', '普通管理员', 'web', '2021-07-05 00:00:49', '2021-07-05 00:00:49');
INSERT INTO `roles` VALUES (3, 'tourist_admin', '游客', 'web', '2021-07-05 00:00:49', '2021-07-05 00:00:49');

-- ----------------------------
-- Table structure for timed_task
-- ----------------------------
DROP TABLE IF EXISTS `timed_task`;
CREATE TABLE `timed_task`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '定时任务名',
  `params` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '作为参数',
  `task` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT 'task任务名',
  `execute_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '执行时间',
  `next_execute_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '下次执行时间',
  `desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注信息',
  `times` int(11) NOT NULL DEFAULT 0 COMMENT '执行次数',
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '1:启用 0：禁用',
  `created_at` timestamp(0) DEFAULT NULL,
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '定时任务表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for timed_task_log
-- ----------------------------
DROP TABLE IF EXISTS `timed_task_log`;
CREATE TABLE `timed_task_log`  (
  `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT,
  `task_id` int(11) NOT NULL COMMENT '任务ID',
  `task_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '任务名',
  `task` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '任务',
  `execute_time` int(11) NOT NULL COMMENT '执行时间',
  `error_log` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '错误信息',
  `result` tinyint(4) NOT NULL DEFAULT 0 COMMENT '执行结果 1：成功 0：失败',
  `created_at` timestamp(0) DEFAULT NULL,
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `task_id_index`(`task_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci COMMENT = '任务日志表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users`  (
  `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT,
  `username` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名',
  `password` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '账号密码',
  `nickname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `desc` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '描述，备注',
  `status` tinyint(4) NOT NULL DEFAULT 1 COMMENT '账号状态 0-停用，1-启用',
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '用户头像',
  `mobile` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '手机号码',
  `last_ip` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '上次登录IP',
  `sex` tinyint(4) NOT NULL DEFAULT 0 COMMENT '用户性别',
  `creater` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '创建者',
  `email` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '邮箱地址',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '收货地址',
  `last_login` int(11) NOT NULL DEFAULT 0 COMMENT '上次登录时间',
  `created_at` timestamp(0) DEFAULT NULL,
  `updated_at` timestamp(0) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO `users` VALUES (1, 'admin@admin.com', '64e1b8d34f425d19e1ee2ea7236d3028', NULL, '超级用户', 1, 'http://landlord-res.oss-cn-shenzhen.aliyuncs.com/admin_face/face3.png', '1800000000', '192.168.137.1', 1, '', 'admin@admin.com', '', 1629903994, '2021-07-05 00:00:49', '2021-08-25 23:06:34');
INSERT INTO `users` VALUES (2, 'admin@admin.com', '64e1b8d34f425d19e1ee2ea7236d3028', NULL, '超级用户', 1, 'http://landlord-res.oss-cn-shenzhen.aliyuncs.com/admin_face/face7.png', '1800000000', '', 1, '', 'admin@admin.com', '', 1625414542, '2021-07-05 00:02:22', '2021-07-05 00:02:22');

SET FOREIGN_KEY_CHECKS = 1;