/*
 Navicat Premium Data Transfer

 Source Server         : 5.7
 Source Server Type    : MySQL
 Source Server Version : 50719
 Source Host           : localhost:3306
 Source Schema         : easyweb-jwt

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

 Date: 07/04/2019 16:27:26
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for oauth_token
-- ----------------------------
DROP TABLE IF EXISTS `oauth_token`;
CREATE TABLE `oauth_token`  (
  `token_id` int(11) NOT NULL AUTO_INCREMENT,
  `access_token` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `user_id` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `permissions` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `roles` varchar(512) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `refresh_token` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `expire_time` datetime(0) NULL DEFAULT NULL,
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0),
  PRIMARY KEY (`token_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 58 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of oauth_token
-- ----------------------------
INSERT INTO `oauth_token` VALUES (4, 'eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiIzIiwiZXhwIjoxNTU0NDMwNTUwfQ.WEw2WprFZtbv9Tz37FwmkiAQRIX0f_N1_kANPUkI3vE', '3', '[\"get:/v1/user/info\",\"get:/v1/user\",\"get:/v1/role\",\"get:/v1/user/menu\"]', '[\"2\"]', NULL, '2019-04-05 10:15:51', '2019-04-04 10:15:50', '2019-04-04 10:15:50');
INSERT INTO `oauth_token` VALUES (55, 'eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiIxIiwiZXhwIjoxNTU0NzA4Mzg5fQ.xaEmkgjNiCW7mAditCOvs8W__7Q1G09gzjBMVqzwh9M', '1', '[\"delete:/v1/role/{id}\",\"get:/v1/menu\",\"post:/v1/menu\",\"put:/v1/menu\",\"delete:/v1/user/{id}\",\"delete:/v1/menu/{id}\",\"get:/v1/user\",\"get:/v1/user/info\",\"post:/v1/user/login\",\"get:/v1/user/menu\",\"delete:/v1/authorities/role\",\"put:/v1/user/state\",\"post:/v1/authorities/sync\",\"get:/v1/role\",\"get:/v1/authorities\",\"post:/v1/role\",\"post:/v1/user\",\"put:/v1/role\",\"put:/v1/user\",\"put:/v1/user/psw\",\"put:/v1/user/psw/{id}\",\"post:/v1/authorities/role\"]', '[\"1\"]', NULL, '2019-04-08 15:26:30', '2019-04-07 15:26:29', '2019-04-07 15:26:29');
INSERT INTO `oauth_token` VALUES (56, 'eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiIxIiwiZXhwIjoxNTU0NzA4NDgwfQ.U1Al-uEiQ_jcPo58n2TyfGrikAuk8uCpyocRiTGRtvw', '1', '[\"delete:/v1/role/{id}\",\"get:/v1/menu\",\"post:/v1/menu\",\"put:/v1/menu\",\"delete:/v1/user/{id}\",\"delete:/v1/menu/{id}\",\"get:/v1/user\",\"get:/v1/user/info\",\"post:/v1/user/login\",\"get:/v1/user/menu\",\"delete:/v1/authorities/role\",\"put:/v1/user/state\",\"post:/v1/authorities/sync\",\"get:/v1/role\",\"get:/v1/authorities\",\"post:/v1/role\",\"post:/v1/user\",\"put:/v1/role\",\"put:/v1/user\",\"put:/v1/user/psw\",\"put:/v1/user/psw/{id}\",\"post:/v1/authorities/role\"]', '[\"1\"]', NULL, '2019-04-08 15:28:00', '2019-04-07 15:28:00', '2019-04-07 15:28:00');
INSERT INTO `oauth_token` VALUES (57, 'eyJhbGciOiJIUzI1NiJ9.eyJzdWIiOiIxIiwiZXhwIjoxNTU0NzA4NTU0fQ._HQyYUnwXg_OkKQdDy-undUEZcVQfYz_A3zwknLH2oU', '1', '[\"delete:/v1/role/{id}\",\"get:/v1/menu\",\"post:/v1/menu\",\"put:/v1/menu\",\"delete:/v1/user/{id}\",\"delete:/v1/menu/{id}\",\"get:/v1/user\",\"get:/v1/user/info\",\"post:/v1/user/login\",\"get:/v1/user/menu\",\"delete:/v1/authorities/role\",\"put:/v1/user/state\",\"post:/v1/authorities/sync\",\"get:/v1/role\",\"get:/v1/authorities\",\"post:/v1/role\",\"post:/v1/user\",\"put:/v1/role\",\"put:/v1/user\",\"put:/v1/user/psw\",\"put:/v1/user/psw/{id}\",\"post:/v1/authorities/role\",\"get:/store/app\",\"post:/store/user/login\"]', '[\"1\"]', NULL, '2019-04-08 15:29:15', '2019-04-07 15:29:14', '2019-04-07 15:29:14');

-- ----------------------------
-- Table structure for oauth_token_key
-- ----------------------------
DROP TABLE IF EXISTS `oauth_token_key`;
CREATE TABLE `oauth_token_key`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `token_key` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '生成token时的key',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of oauth_token_key
-- ----------------------------
INSERT INTO `oauth_token_key` VALUES (1, '590203e1b9a025b750d68984e5e4fa9d2ca13e282cc450d4575f0cef418d3c40', '2019-04-03 14:51:59');

-- ----------------------------
-- Table structure for store_app
-- ----------------------------
DROP TABLE IF EXISTS `store_app`;
CREATE TABLE `store_app`  (
  `store_app_id` int(11) NOT NULL AUTO_INCREMENT,
  `icon` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '图标',
  `title` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '标题',
  `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '描述',
  `size` double NULL DEFAULT NULL COMMENT '大小',
  `count` int(11) NULL DEFAULT NULL COMMENT '下载量',
  `download_url` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '下载url',
  `time` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '时间',
  PRIMARY KEY (`store_app_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_bin ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of store_app
-- ----------------------------
INSERT INTO `store_app` VALUES (1, 'http://aliyunzixunbucket.oss-cn-beijing.aliyuncs.com/jpg/6c38c557e18834a5074f3ea11b245a20.jpg?x-oss-process=image/resize,p_100/auto-orient,1/quality,q_90/format,jpg/watermark,image_eXVuY2VzaGk=,t_100', '雷电模拟器', '超好用的App，可以模拟器很多东西超好用的App，可以模拟器很多东西超好用的App，可以模拟器很多东西', 32, 255, 'http://aliyunzixunbucket.oss-cn-beijing.aliyuncs.com/jpg/6c38c557e18834a5074f3ea11b245a20.jpg?x-oss-process=image/resize,p_100/auto-orient,1/quality,q_90/format,jpg/watermark,image_eXVuY2VzaGk=,t_100', '2019-4-7');
INSERT INTO `store_app` VALUES (2, 'http://aliyunzixunbucket.oss-cn-beijing.aliyuncs.com/jpg/6c38c557e18834a5074f3ea11b245a20.jpg?x-oss-process=image/resize,p_100/auto-orient,1/quality,q_90/format,jpg/watermark,image_eXVuY2VzaGk=,t_100', '雷电模拟器', '超好用的App，可以模拟器很多东西超好用的App，可以模拟器很多东西超好用的App，可以模拟器很多东西', 32, 255, 'http://aliyunzixunbucket.oss-cn-beijing.aliyuncs.com/jpg/6c38c557e18834a5074f3ea11b245a20.jpg?x-oss-process=image/resize,p_100/auto-orient,1/quality,q_90/format,jpg/watermark,image_eXVuY2VzaGk=,t_100', '2019-4-7');
INSERT INTO `store_app` VALUES (3, 'http://aliyunzixunbucket.oss-cn-beijing.aliyuncs.com/jpg/6c38c557e18834a5074f3ea11b245a20.jpg?x-oss-process=image/resize,p_100/auto-orient,1/quality,q_90/format,jpg/watermark,image_eXVuY2VzaGk=,t_100', '雷电模拟器', '超好用的App，可以模拟器很多东西超好用的App，可以模拟器很多东西超好用的App，可以模拟器很多东西', 32, 255, 'http://aliyunzixunbucket.oss-cn-beijing.aliyuncs.com/jpg/6c38c557e18834a5074f3ea11b245a20.jpg?x-oss-process=image/resize,p_100/auto-orient,1/quality,q_90/format,jpg/watermark,image_eXVuY2VzaGk=,t_100', '2019-4-7');
INSERT INTO `store_app` VALUES (4, 'http://aliyunzixunbucket.oss-cn-beijing.aliyuncs.com/jpg/6c38c557e18834a5074f3ea11b245a20.jpg?x-oss-process=image/resize,p_100/auto-orient,1/quality,q_90/format,jpg/watermark,image_eXVuY2VzaGk=,t_100', '雷电模拟器', '超好用的App，可以模拟器很多东西超好用的App，可以模拟器很多东西超好用的App，可以模拟器很多东西', 32, 255, 'http://aliyunzixunbucket.oss-cn-beijing.aliyuncs.com/jpg/6c38c557e18834a5074f3ea11b245a20.jpg?x-oss-process=image/resize,p_100/auto-orient,1/quality,q_90/format,jpg/watermark,image_eXVuY2VzaGk=,t_100', '2019-4-7');
INSERT INTO `store_app` VALUES (5, 'http://aliyunzixunbucket.oss-cn-beijing.aliyuncs.com/jpg/6c38c557e18834a5074f3ea11b245a20.jpg?x-oss-process=image/resize,p_100/auto-orient,1/quality,q_90/format,jpg/watermark,image_eXVuY2VzaGk=,t_100', '雷电模拟器', '超好用的App，可以模拟器很多东西超好用的App，可以模拟器很多东西超好用的App，可以模拟器很多东西', 32, 255, 'http://aliyunzixunbucket.oss-cn-beijing.aliyuncs.com/jpg/6c38c557e18834a5074f3ea11b245a20.jpg?x-oss-process=image/resize,p_100/auto-orient,1/quality,q_90/format,jpg/watermark,image_eXVuY2VzaGk=,t_100', '2019-4-7');

-- ----------------------------
-- Table structure for sys_authorities
-- ----------------------------
DROP TABLE IF EXISTS `sys_authorities`;
CREATE TABLE `sys_authorities`  (
  `authority` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '授权标识',
  `authority_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '名称',
  `parent_name` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '模块',
  `sort` int(11) NOT NULL DEFAULT 0 COMMENT '排序号',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`authority`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '权限' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_authorities
-- ----------------------------
INSERT INTO `sys_authorities` VALUES ('delete:/v1/authorities/role', '移除角色权限', '权限管理', 5, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('delete:/v1/menu/{id}', '删除菜单', '菜单管理', 10, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('delete:/v1/role/{id}', '删除角色', '角色管理', 14, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('delete:/v1/user/{id}', '删除用户', '用户管理', 24, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('get:/store/app', '查询所有用户', '商店app控制器', 1, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('get:/v1/authorities', '查询所有权限', '权限管理', 3, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('get:/v1/menu', '查询所有菜单', '菜单管理', 7, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('get:/v1/role', '查询所有角色', '角色管理', 11, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('get:/v1/user', '查询所有用户', '用户管理', 15, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('get:/v1/user/info', '获取个人信息', '个人信息', 18, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('get:/v1/user/menu', '获取所有菜单', '个人信息', 20, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('post:/store/user/login', '用户登录', '商店用户登录', 2, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('post:/v1/authorities/role', '给角色添加权限', '权限管理', 4, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('post:/v1/authorities/sync', '同步权限', '权限管理', 6, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('post:/v1/menu', '添加菜单', '菜单管理', 8, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('post:/v1/role', '添加角色', '角色管理', 12, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('post:/v1/user', '添加用户', '用户管理', 16, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('post:/v1/user/login', '用户登录', '个人信息', 19, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('put:/v1/menu', '修改菜单', '菜单管理', 9, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('put:/v1/role', '修改角色', '角色管理', 13, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('put:/v1/user', '修改用户', '用户管理', 17, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('put:/v1/user/psw', '修改自己密码', '用户管理', 21, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('put:/v1/user/psw/{id}', '重置密码', '用户管理', 22, '2019-04-07 15:31:11');
INSERT INTO `sys_authorities` VALUES ('put:/v1/user/state', '修改用户状态', '用户管理', 23, '2019-04-07 15:31:11');

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu`  (
  `menu_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '菜单id',
  `parent_id` int(11) NOT NULL DEFAULT -1 COMMENT '父级id',
  `menu_name` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '菜单名称',
  `menu_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单url',
  `menu_icon` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
  `sort_number` int(11) NOT NULL DEFAULT 0 COMMENT '排序号',
  `authority` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '对应权限',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
  PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '菜单表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
INSERT INTO `sys_menu` VALUES (1, -1, '系统管理', '', 'layui-icon layui-icon-set', 1, '', '2019-03-26 13:19:08', '2019-03-26 16:18:08');
INSERT INTO `sys_menu` VALUES (2, 1, '用户管理', '#/system/user', '', 3, 'get:/v1/user', '2019-03-26 16:21:17', '2019-04-04 10:11:03');
INSERT INTO `sys_menu` VALUES (3, 1, '角色管理', '#/system/role', '', 4, 'get:/v1/role', '2019-03-26 16:22:03', '2019-04-04 10:12:46');
INSERT INTO `sys_menu` VALUES (4, 1, '权限管理', '#/system/authorities', '', 5, 'get:/v1/authorities', '2019-03-26 16:22:28', '2019-03-29 13:59:14');
INSERT INTO `sys_menu` VALUES (5, 1, '菜单管理', '#/system/menu', '', 6, 'get:/v1/menu', '2019-03-26 16:28:14', '2019-03-29 13:59:14');
INSERT INTO `sys_menu` VALUES (6, -1, '系统功能', '', 'layui-icon layui-icon-engine', 7, '', '2019-03-28 16:44:19', '2019-03-29 13:59:15');
INSERT INTO `sys_menu` VALUES (7, 6, 'Druid监控', '#/tpl/iframe/id=druid', '', 8, '', '2019-03-28 16:45:34', '2019-03-29 13:59:19');
INSERT INTO `sys_menu` VALUES (8, 6, '接口文档', '#/tpl/iframe/id=swagger', '', 9, '', '2019-03-28 16:47:56', '2019-03-29 13:59:20');
INSERT INTO `sys_menu` VALUES (10, -1, '商店APP', '', 'layui-icon layui-icon-set', 3, '', '2019-04-07 15:30:40', '2019-04-07 15:32:21');
INSERT INTO `sys_menu` VALUES (11, 10, 'APP管理', '#/store/app', '', 1, 'get:/store/app', '2019-04-07 15:32:49', '2019-04-07 15:33:24');

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`  (
  `role_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色id',
  `role_name` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '角色名称',
  `comments` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
  PRIMARY KEY (`role_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role
-- ----------------------------
INSERT INTO `sys_role` VALUES (1, '管理员', '管理员', '2018-12-19 23:11:29', '2018-12-19 23:11:29');
INSERT INTO `sys_role` VALUES (2, '普通用户', '普通用户', '2018-12-19 23:12:09', '2018-12-19 23:12:09');

-- ----------------------------
-- Table structure for sys_role_authorities
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_authorities`;
CREATE TABLE `sys_role_authorities`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `role_id` int(11) NOT NULL COMMENT '角色id',
  `authority` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '权限id',
  `create_time` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FK_sys_role_permission_pm`(`authority`) USING BTREE,
  INDEX `FK_sys_role_permission_role`(`role_id`) USING BTREE,
  CONSTRAINT `sys_role_authorities_ibfk_1` FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`role_id`) ON DELETE CASCADE ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 36 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '角色权限' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_role_authorities
-- ----------------------------
INSERT INTO `sys_role_authorities` VALUES (1, 1, 'delete:/v1/role/{id}', '2018-12-19 23:11:36');
INSERT INTO `sys_role_authorities` VALUES (2, 1, 'get:/v1/menu', '2019-03-29 12:49:52');
INSERT INTO `sys_role_authorities` VALUES (3, 1, 'post:/v1/menu', '2019-03-29 12:49:53');
INSERT INTO `sys_role_authorities` VALUES (4, 1, 'put:/v1/menu', '2019-03-29 12:49:53');
INSERT INTO `sys_role_authorities` VALUES (5, 1, 'delete:/v1/user/{id}', '2019-03-29 12:50:04');
INSERT INTO `sys_role_authorities` VALUES (6, 1, 'delete:/v1/menu/{id}', '2019-03-29 12:50:44');
INSERT INTO `sys_role_authorities` VALUES (7, 1, 'get:/v1/user', '2019-03-29 12:50:45');
INSERT INTO `sys_role_authorities` VALUES (8, 1, 'get:/v1/user/info', '2019-03-29 13:47:08');
INSERT INTO `sys_role_authorities` VALUES (9, 1, 'post:/v1/user/login', '2019-03-29 13:47:08');
INSERT INTO `sys_role_authorities` VALUES (10, 1, 'get:/v1/user/menu', '2019-03-29 13:47:08');
INSERT INTO `sys_role_authorities` VALUES (11, 1, 'delete:/v1/authorities/role', '2018-12-26 10:32:09');
INSERT INTO `sys_role_authorities` VALUES (12, 1, 'put:/v1/user/state', '2018-12-19 23:11:50');
INSERT INTO `sys_role_authorities` VALUES (13, 1, 'post:/v1/authorities/sync', '2018-12-19 23:11:42');
INSERT INTO `sys_role_authorities` VALUES (14, 1, 'get:/v1/role', '2018-12-19 23:11:40');
INSERT INTO `sys_role_authorities` VALUES (15, 1, 'get:/v1/authorities', '2018-12-19 23:11:37');
INSERT INTO `sys_role_authorities` VALUES (16, 1, 'post:/v1/role', '2018-12-19 23:11:43');
INSERT INTO `sys_role_authorities` VALUES (17, 1, 'post:/v1/user', '2018-12-19 23:11:44');
INSERT INTO `sys_role_authorities` VALUES (18, 1, 'put:/v1/role', '2018-12-19 23:11:46');
INSERT INTO `sys_role_authorities` VALUES (19, 1, 'put:/v1/user', '2018-12-19 23:11:46');
INSERT INTO `sys_role_authorities` VALUES (20, 1, 'put:/v1/user/psw', '2018-12-19 23:11:47');
INSERT INTO `sys_role_authorities` VALUES (21, 1, 'put:/v1/user/psw/{id}', '2018-12-19 23:11:47');
INSERT INTO `sys_role_authorities` VALUES (23, 2, 'get:/v1/user/info', '2019-03-29 13:47:39');
INSERT INTO `sys_role_authorities` VALUES (25, 2, 'get:/v1/user', '2019-03-29 12:50:56');
INSERT INTO `sys_role_authorities` VALUES (27, 2, 'get:/v1/role', '2018-12-19 23:13:06');
INSERT INTO `sys_role_authorities` VALUES (28, 2, 'get:/v1/user/menu', '2019-03-29 13:47:40');
INSERT INTO `sys_role_authorities` VALUES (29, 1, 'post:/v1/authorities/role', '2019-04-03 14:55:53');
INSERT INTO `sys_role_authorities` VALUES (32, 1, 'get:/store/app', '2019-04-07 15:31:20');
INSERT INTO `sys_role_authorities` VALUES (33, 1, 'post:/store/user/login', '2019-04-07 15:31:21');
INSERT INTO `sys_role_authorities` VALUES (34, 2, 'get:/store/app', '2019-04-07 15:31:25');
INSERT INTO `sys_role_authorities` VALUES (35, 2, 'post:/store/user/login', '2019-04-07 15:31:26');

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`  (
  `user_id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户id',
  `username` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '账号',
  `password` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '密码',
  `nick_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '昵称',
  `avatar` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '头像',
  `sex` varchar(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '男' COMMENT '性别',
  `phone` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '手机号',
  `email` varchar(256) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '邮箱',
  `email_verified` int(1) NULL DEFAULT 0 COMMENT '邮箱是否验证，0未验证，1已验证',
  `true_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '真实姓名',
  `id_card` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '身份证号',
  `birthday` date NULL DEFAULT NULL COMMENT '出生日期',
  `department_id` int(11) NULL DEFAULT NULL COMMENT '部门id',
  `state` int(1) NOT NULL DEFAULT 0 COMMENT '状态，0正常，1冻结',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间',
  `update_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '修改时间',
  PRIMARY KEY (`user_id`) USING BTREE,
  UNIQUE INDEX `user_account`(`username`) USING BTREE,
  INDEX `FK_sys_user`(`true_name`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_user
-- ----------------------------
INSERT INTO `sys_user` VALUES (1, 'admin', '21232f297a57a5a743894a0e4a801fc3', '管理员', NULL, '男', '15228311770', NULL, 0, NULL, NULL, NULL, NULL, 0, '2018-12-19 23:30:05', '2019-04-07 14:14:03');
INSERT INTO `sys_user` VALUES (2, 'user01', 'e10adc3949ba59abbe56e057f20f883e', '用户01', NULL, '男', '12345678901', NULL, 0, NULL, NULL, NULL, NULL, 0, '2018-12-19 23:31:25', '2019-04-03 14:52:10');
INSERT INTO `sys_user` VALUES (3, 'aaaa', 'e10adc3949ba59abbe56e057f20f883e', 'aaaa', NULL, '男', '15228311771', NULL, 0, NULL, NULL, NULL, NULL, 0, '2019-04-04 10:13:56', '2019-04-07 14:13:54');

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role`  (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL COMMENT '用户id',
  `role_id` int(11) NOT NULL COMMENT '角色id',
  `create_time` timestamp(0) NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FK_sys_user_role`(`user_id`) USING BTREE,
  INDEX `FK_sys_user_role_role`(`role_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户角色' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
INSERT INTO `sys_user_role` VALUES (2, 2, 2, '2019-03-29 13:13:35');
INSERT INTO `sys_user_role` VALUES (4, 3, 2, '2019-04-07 14:13:54');
INSERT INTO `sys_user_role` VALUES (5, 1, 1, '2019-04-07 14:14:03');

SET FOREIGN_KEY_CHECKS = 1;