登录 注册
开源 企业版 高校版 私有云 Gitee AI NEW
扫描微信二维码支付
取消
支付完成
Watch
不关注 关注所有动态 仅关注版本发行动态 关注但不提醒动态
1 Star 0 Fork 1.3K

yandeqing / bootshiro

forked from tomsun28 / bootshiro 
代码 Issues 0 Pull Requests 0 Wiki 统计 流水线
服务
加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目，私有仓库也完全免费 ：）
免费加入
克隆/下载
usthe.sql 22.29 KB
一键复制 编辑 原始数据 按行查看 历史
tomsun28 提交于 2018-05-14 18:45 . update sql
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282
/*

 Navicat Premium Data Transfer



 Source Server         : 本地mysql

 Source Server Type    : MySQL

 Source Server Version : 100211

 Source Host           : localhost:3306

 Source Schema         : usthe



 Target Server Type    : MySQL

 Target Server Version : 100211

 File Encoding         : 65001



 Date: 14/05/2018 17:20:42

*/



DROP DATABASE IF EXISTS usthe;

CREATE DATABASE usthe DEFAULT CHARACTER SET utf8;

USE usthe;



SET NAMES utf8mb4;

SET FOREIGN_KEY_CHECKS = 0;



-- ----------------------------

-- Table structure for auth_account_log

-- ----------------------------

DROP TABLE IF EXISTS `auth_account_log`;

CREATE TABLE `auth_account_log`  (

  `ID` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户账户操作日志主键',

  `LOG_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志名称(login,register,logout)',

  `USER_ID` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户id',

  `CREATE_TIME` datetime(0) NULL DEFAULT current_timestamp() COMMENT '创建时间',

  `SUCCEED` tinyint(4) NULL DEFAULT NULL COMMENT '是否执行成功(0失败1成功)',

  `MESSAGE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '具体消息',

  `IP` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录ip',

  PRIMARY KEY (`ID`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 92 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '登录注册登出记录' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of auth_account_log

-- ----------------------------

INSERT INTO `auth_account_log` VALUES (17, '用户登录日志', 'tom', '2018-04-22 13:22:39', 1, NULL, '10.0.75.2');



-- ----------------------------

-- Table structure for auth_operation_log

-- ----------------------------

DROP TABLE IF EXISTS `auth_operation_log`;

CREATE TABLE `auth_operation_log`  (

  `ID` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户操作日志主键',

  `LOG_NAME` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '日志名称',

  `USER_ID` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户id',

  `API` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT 'api名称',

  `METHOD` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '方法名称',

  `CREATE_TIME` datetime(0) NULL DEFAULT current_timestamp() COMMENT '创建时间',

  `SUCCEED` tinyint(4) NULL DEFAULT NULL COMMENT '是否执行成功(0失败1成功)',

  `MESSAGE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '具体消息备注',

  PRIMARY KEY (`ID`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 610 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '操作日志' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of auth_operation_log

-- ----------------------------

INSERT INTO `auth_operation_log` VALUES (17, '业务操作日志', 'tom', '/resource/menus', 'GET', '2018-04-22 16:05:05', 1, NULL);

INSERT INTO `auth_operation_log` VALUES (18, '业务操作日志', 'tom', '/resource/menus', 'GET', '2018-04-22 16:05:09', 1, NULL);

INSERT INTO `auth_operation_log` VALUES (19, '业务操作日志', 'tom', '/resource/api/-1/1/10', 'GET', '2018-04-22 16:08:15', 1, NULL);



-- ----------------------------

-- Table structure for auth_resource

-- ----------------------------

DROP TABLE IF EXISTS `auth_resource`;

CREATE TABLE `auth_resource`  (

  `ID` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '资源ID',

  `CODE` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源名称',

  `NAME` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '资源描述',

  `PARENT_ID` int(11) NULL DEFAULT NULL COMMENT '父资源编码->菜单',

  `URI` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '访问地址URL',

  `TYPE` smallint(4) NULL DEFAULT NULL COMMENT '类型 1:菜单menu 2:资源element(rest-api) 3:资源分类',

  `METHOD` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '访问方式 GET POST PUT DELETE PATCH',

  `ICON` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图标',

  `STATUS` smallint(4) NULL DEFAULT 1 COMMENT '状态   1:正常、9：禁用',

  `CREATE_TIME` datetime(0) NULL DEFAULT current_timestamp() COMMENT '创建时间',

  `UPDATE_TIME` datetime(0) NULL DEFAULT current_timestamp() COMMENT '更新时间',

  PRIMARY KEY (`ID`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 146 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '资源信息表(菜单,资源)' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of auth_resource

-- ----------------------------

INSERT INTO `auth_resource` VALUES (101, 'ACCOUNT_LOGIN', '用户登录', 103, '/account/login', 2, 'POST', NULL, 1, NULL, NULL);

INSERT INTO `auth_resource` VALUES (103, 'GROUP_ACCOUNT', '账户系列', 110, '', 3, 'POST', NULL, 1, NULL, NULL);

INSERT INTO `auth_resource` VALUES (104, 'USER_MAGE', '用户管理', -1, '', 1, 'POST', 'fa fa-user', 1, NULL, NULL);

INSERT INTO `auth_resource` VALUES (106, 'RESOURCE_MAGE', '资源配置', -1, '', 1, 'POST', 'fa fa-pie-chart', 1, NULL, NULL);

INSERT INTO `auth_resource` VALUES (107, 'MENU_MANAGE', '菜单管理', 106, '/index/menu', 1, 'POST', 'fa fa-th', 1, NULL, NULL);

INSERT INTO `auth_resource` VALUES (109, 'API_MANAGE', 'API管理', 106, '/index/api', 1, NULL, 'fa fa-share', 1, '2018-04-07 09:40:24', '2018-04-07 09:40:24');

INSERT INTO `auth_resource` VALUES (110, 'CATEGORY_GROUP', '分类集合(API类别请放入此集合)', -1, NULL, 3, NULL, NULL, 1, '2018-04-07 14:27:58', '2018-04-07 14:27:58');

INSERT INTO `auth_resource` VALUES (112, 'ACCOUNT_REGISTER', '用户注册', 103, '/account/register', 2, 'POST', NULL, 1, '2018-04-07 16:21:45', '2018-04-07 16:21:45');

INSERT INTO `auth_resource` VALUES (115, 'GROUP_USER', '用户系列', 110, '', 3, 'GET', NULL, 1, '2018-04-07 16:31:01', '2018-04-07 16:31:01');

INSERT INTO `auth_resource` VALUES (117, 'ROLE_MANAGE', '角色管理', 106, '/index/role', 1, NULL, 'fa fa-adjust', 1, '2018-04-08 05:36:31', '2018-04-08 05:36:31');

INSERT INTO `auth_resource` VALUES (118, 'GROUP_RESOURCE', '资源系列', 110, NULL, 3, NULL, NULL, 1, '2018-04-09 02:29:14', '2018-04-09 02:29:14');

INSERT INTO `auth_resource` VALUES (119, 'USER_ROLE_APPID', '获取对应用户角色', 115, '/user/role/*/*/*', 2, 'GET', NULL, 1, '2018-04-12 03:07:22', '2018-04-12 03:07:22');

INSERT INTO `auth_resource` VALUES (120, 'USER_LIST', '获取用户列表', 115, '/user/list', 2, 'GET', NULL, 1, '2018-04-12 03:08:30', '2018-04-12 03:08:30');

INSERT INTO `auth_resource` VALUES (121, 'USER_AUTHORITY_ROLE', '给用户授权添加角色', 115, '/user/authority/role', 2, 'POST', NULL, 1, '2018-04-12 03:15:56', '2018-04-12 03:15:56');

INSERT INTO `auth_resource` VALUES (122, 'USER_AUTHORITY_ROLE', '删除已经授权的用户角色', 115, '/user/authority/role', 2, 'DELETE', NULL, 1, '2018-04-12 03:29:03', '2018-04-12 03:29:03');

INSERT INTO `auth_resource` VALUES (123, 'RESOURCE_AUTORITYMENU', '获取用户被授权菜单', 118, '/resource/authorityMenu', 2, 'GET', NULL, 1, '2018-04-12 05:30:03', '2018-04-12 05:30:03');

INSERT INTO `auth_resource` VALUES (124, 'RESOURCE_MENUS', '获取全部菜单列', 118, '/resource/menus', 2, 'GET', NULL, 1, '2018-04-12 05:42:46', '2018-04-12 05:42:46');

INSERT INTO `auth_resource` VALUES (125, 'RESOURCE_MENU', '增加菜单', 118, '/resource/menu', 2, 'POST', NULL, 1, '2018-04-12 06:15:39', '2018-04-12 06:15:39');

INSERT INTO `auth_resource` VALUES (126, 'RESOURCE_MENU', '修改菜单', 118, '/resource/menu', 2, 'PUT', NULL, 1, '2018-04-12 06:16:35', '2018-04-12 06:16:35');

INSERT INTO `auth_resource` VALUES (127, 'RESOURCE_MENU', '删除菜单', 118, '/resource/menu', 2, 'DELETE', NULL, 1, '2018-04-12 06:17:18', '2018-04-12 06:17:18');

INSERT INTO `auth_resource` VALUES (128, 'RESOURCE_API', '获取API list', 118, '/resource/api/*/*/*', 2, 'GET', NULL, 1, '2018-04-12 06:18:02', '2018-04-12 06:18:02');

INSERT INTO `auth_resource` VALUES (129, 'RESOURCE_API', '增加API', 118, '/resource/api', 2, 'POST', NULL, 1, '2018-04-12 06:18:42', '2018-04-12 06:18:42');

INSERT INTO `auth_resource` VALUES (130, 'RESOURCE_API', '修改API', 118, '/resource/api', 2, 'PUT', NULL, 1, '2018-04-12 06:19:32', '2018-04-12 06:19:32');

INSERT INTO `auth_resource` VALUES (131, 'RESOURCE_API', '删除API', 118, '/resource/api', 2, 'DELETE', NULL, 1, '2018-04-12 06:20:03', '2018-04-12 06:20:03');

INSERT INTO `auth_resource` VALUES (132, 'GROUP_ROLE', '角色系列', 110, NULL, 3, NULL, NULL, 1, '2018-04-12 06:22:02', '2018-04-12 06:22:02');

INSERT INTO `auth_resource` VALUES (133, 'ROLE_USER', '获取角色关联用户列表', 132, '/role/user/*/*/*', 2, 'GET', NULL, 1, '2018-04-12 06:22:59', '2018-04-12 06:22:59');

INSERT INTO `auth_resource` VALUES (134, 'ROLE_USER', '获取角色未关联用户列表', 132, '/role/user/-/*/*/*', 2, 'GET', NULL, 1, '2018-04-12 06:24:09', '2018-04-12 06:24:09');

INSERT INTO `auth_resource` VALUES (135, 'ROLE_API', '获取角色关联API资源', 132, '/role/api/*/*/*', 2, 'GET', NULL, 1, '2018-04-12 06:25:32', '2018-04-12 06:25:32');

INSERT INTO `auth_resource` VALUES (136, 'ROLE_API', '获取角色未关联API资源', 132, '/role/api/-/*/*/*', 2, 'GET', NULL, 1, '2018-04-12 06:26:12', '2018-04-12 06:26:12');

INSERT INTO `auth_resource` VALUES (137, 'ROLE_MENU', '获取角色关联菜单资源', 132, 'role/menu/*/*/*', 2, 'GET', NULL, 1, '2018-04-12 06:27:20', '2018-04-12 06:27:20');

INSERT INTO `auth_resource` VALUES (138, 'ROLE_MENU', '获取角色未关联菜单资源', 132, '/role/menu/-/*/*/*', 2, 'GET', NULL, 1, '2018-04-12 06:27:56', '2018-04-12 06:27:56');

INSERT INTO `auth_resource` VALUES (139, 'ROLE_AUTHORITY_RESOURCE', '授权资源给角色', 132, '/role/authority/resource', 2, 'POST', NULL, 1, '2018-04-12 06:29:45', '2018-04-12 06:29:45');

INSERT INTO `auth_resource` VALUES (140, 'ROLE_AUTHORITY_RESOURCE', '删除角色的授权资源', 132, '/role/authority/resource', 2, 'DELETE', NULL, 1, '2018-04-12 06:31:12', '2018-04-12 06:31:12');

INSERT INTO `auth_resource` VALUES (141, 'ROLE', '获取角色LIST', 132, 'role/*/*', 2, 'GET', NULL, 1, '2018-04-12 06:32:34', '2018-04-12 06:32:34');

INSERT INTO `auth_resource` VALUES (142, 'ROLE', '添加角色', 132, 'role', 2, 'POST', NULL, 1, '2018-04-12 06:33:25', '2018-04-12 06:33:25');

INSERT INTO `auth_resource` VALUES (143, 'USER', '更新角色', 132, 'role', 2, 'PUT', NULL, 1, '2018-04-12 06:34:27', '2018-04-12 06:34:27');

INSERT INTO `auth_resource` VALUES (144, 'ROLE', '删除角色', 132, 'role', 2, 'DELETE', NULL, 1, '2018-04-12 06:35:15', '2018-04-12 06:35:15');

INSERT INTO `auth_resource` VALUES (145, 'LOG_WATCH', '日志记录', 104, '/index/log', 1, NULL, 'fa fa-rss-square', 1, '2018-04-22 08:12:24', '2018-04-22 08:12:24');



-- ----------------------------

-- Table structure for auth_role

-- ----------------------------

DROP TABLE IF EXISTS `auth_role`;

CREATE TABLE `auth_role`  (

  `ID` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '角色ID',

  `CODE` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色编码',

  `NAME` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名称',

  `STATUS` smallint(4) NULL DEFAULT 1 COMMENT '状态   1:正常、9：禁用',

  `CREATE_TIME` datetime(0) NULL DEFAULT current_timestamp() COMMENT '创建时间',

  `UPDATE_TIME` datetime(0) NULL DEFAULT current_timestamp() COMMENT '更新时间',

  PRIMARY KEY (`ID`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 105 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色信息表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of auth_role

-- ----------------------------

INSERT INTO `auth_role` VALUES (100, 'role_admin', '管理员角色', 1, NULL, NULL);

INSERT INTO `auth_role` VALUES (102, 'role_user', '用户角色', 1, NULL, NULL);

INSERT INTO `auth_role` VALUES (103, 'role_guest', '访客角色', 1, NULL, NULL);

INSERT INTO `auth_role` VALUES (104, 'role_anon', '非角色', 1, NULL, NULL);



-- ----------------------------

-- Table structure for auth_role_resource

-- ----------------------------

DROP TABLE IF EXISTS `auth_role_resource`;

CREATE TABLE `auth_role_resource`  (

  `ID` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '主键ID',

  `ROLE_ID` int(11) NOT NULL COMMENT '角色ID',

  `RESOURCE_ID` int(11) NOT NULL COMMENT '资源ID',

  `CREATE_TIME` datetime(0) NULL DEFAULT current_timestamp() COMMENT '创建时间',

  `UPDATE_TIME` datetime(0) NULL DEFAULT current_timestamp() COMMENT '更新时间',

  PRIMARY KEY (`ID`) USING BTREE,

  UNIQUE INDEX `ROLE_ID`(`ROLE_ID`, `RESOURCE_ID`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 110 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '资源角色关联表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of auth_role_resource

-- ----------------------------



INSERT INTO `auth_role_resource` VALUES (10, 103, 105, '2018-04-01 12:50:19', '2018-04-01 12:50:19');

INSERT INTO `auth_role_resource` VALUES (21, 102, 102, '2018-04-09 21:09:09', '2018-04-09 21:09:09');

INSERT INTO `auth_role_resource` VALUES (23, 103, 101, '2018-04-09 21:51:39', '2018-04-09 21:51:39');

INSERT INTO `auth_role_resource` VALUES (24, 103, 102, '2018-04-09 21:51:43', '2018-04-09 21:51:43');

INSERT INTO `auth_role_resource` VALUES (25, 103, 103, '2018-04-09 21:51:46', '2018-04-09 21:51:46');

INSERT INTO `auth_role_resource` VALUES (26, 103, 112, '2018-04-09 21:51:49', '2018-04-09 21:51:49');

INSERT INTO `auth_role_resource` VALUES (27, 101, 112, '2018-04-09 22:21:02', '2018-04-09 22:21:02');

INSERT INTO `auth_role_resource` VALUES (28, 101, 103, '2018-04-09 22:21:06', '2018-04-09 22:21:06');

INSERT INTO `auth_role_resource` VALUES (29, 100, 102, '2018-04-09 22:25:09', '2018-04-09 22:25:09');

INSERT INTO `auth_role_resource` VALUES (30, 101, 101, '2018-04-09 22:39:28', '2018-04-09 22:39:28');

INSERT INTO `auth_role_resource` VALUES (31, 103, 100, '2018-04-09 22:45:00', '2018-04-09 22:45:00');

INSERT INTO `auth_role_resource` VALUES (32, 103, 104, '2018-04-09 22:46:26', '2018-04-09 22:46:26');

INSERT INTO `auth_role_resource` VALUES (33, 103, 106, '2018-04-09 22:46:28', '2018-04-09 22:46:28');

INSERT INTO `auth_role_resource` VALUES (34, 103, 107, '2018-04-09 22:46:31', '2018-04-09 22:46:31');

INSERT INTO `auth_role_resource` VALUES (35, 103, 109, '2018-04-09 22:46:34', '2018-04-09 22:46:34');

INSERT INTO `auth_role_resource` VALUES (36, 103, 116, '2018-04-09 22:46:37', '2018-04-09 22:46:37');

INSERT INTO `auth_role_resource` VALUES (37, 103, 117, '2018-04-09 22:46:43', '2018-04-09 22:46:43');

INSERT INTO `auth_role_resource` VALUES (38, 104, 101, '2018-04-09 22:49:46', '2018-04-09 22:49:46');

INSERT INTO `auth_role_resource` VALUES (39, 104, 102, '2018-04-09 22:49:52', '2018-04-09 22:49:52');

INSERT INTO `auth_role_resource` VALUES (40, 104, 103, '2018-04-09 22:49:55', '2018-04-09 22:49:55');

INSERT INTO `auth_role_resource` VALUES (41, 100, 103, '2018-04-09 22:51:56', '2018-04-09 22:51:56');

INSERT INTO `auth_role_resource` VALUES (42, 102, 101, '2018-04-11 09:35:37', '2018-04-11 09:35:37');

INSERT INTO `auth_role_resource` VALUES (43, 103, 123, '2018-04-20 09:08:52', '2018-04-20 09:08:52');

INSERT INTO `auth_role_resource` VALUES (44, 103, 119, '2018-04-20 09:23:51', '2018-04-20 09:23:51');

INSERT INTO `auth_role_resource` VALUES (45, 103, 129, '2018-04-20 09:24:21', '2018-04-20 09:24:21');

INSERT INTO `auth_role_resource` VALUES (46, 103, 128, '2018-04-20 09:25:58', '2018-04-20 09:25:58');

INSERT INTO `auth_role_resource` VALUES (47, 102, 104, '2018-04-20 23:26:00', '2018-04-20 23:26:00');

INSERT INTO `auth_role_resource` VALUES (48, 102, 107, '2018-04-20 23:26:04', '2018-04-20 23:26:04');

INSERT INTO `auth_role_resource` VALUES (49, 102, 117, '2018-04-20 23:26:07', '2018-04-20 23:26:07');

INSERT INTO `auth_role_resource` VALUES (50, 102, 109, '2018-04-20 23:26:10', '2018-04-20 23:26:10');

INSERT INTO `auth_role_resource` VALUES (51, 102, 106, '2018-04-20 23:26:13', '2018-04-20 23:26:13');

INSERT INTO `auth_role_resource` VALUES (52, 102, 123, '2018-04-21 00:24:38', '2018-04-21 00:24:38');

INSERT INTO `auth_role_resource` VALUES (53, 104, 112, '2018-04-21 09:03:24', '2018-04-21 09:03:24');

INSERT INTO `auth_role_resource` VALUES (54, 102, 128, '2018-04-21 09:27:08', '2018-04-21 09:27:08');

INSERT INTO `auth_role_resource` VALUES (58, 102, 134, '2018-04-22 13:24:55', '2018-04-22 13:24:55');

INSERT INTO `auth_role_resource` VALUES (59, 102, 135, '2018-04-22 13:25:00', '2018-04-22 13:25:00');

INSERT INTO `auth_role_resource` VALUES (60, 102, 145, '2018-04-22 17:23:30', '2018-04-22 17:23:30');

INSERT INTO `auth_role_resource` VALUES (83, 100, 124, '2018-04-25 16:05:11', '2018-04-25 16:05:11');

INSERT INTO `auth_role_resource` VALUES (84, 103, 122, '2018-05-03 23:00:19', '2018-05-03 23:00:19');

INSERT INTO `auth_role_resource` VALUES (85, 100, 120, '2018-05-03 23:02:14', '2018-05-03 23:02:14');

INSERT INTO `auth_role_resource` VALUES (86, 100, 104, '2018-05-09 10:10:06', '2018-05-09 10:10:06');

INSERT INTO `auth_role_resource` VALUES (87, 100, 107, '2018-05-09 10:10:13', '2018-05-09 10:10:13');

INSERT INTO `auth_role_resource` VALUES (88, 102, 112, '2018-05-09 10:10:40', '2018-05-09 10:10:40');

INSERT INTO `auth_role_resource` VALUES (89, 102, 119, '2018-05-09 10:10:45', '2018-05-09 10:10:45');

INSERT INTO `auth_role_resource` VALUES (90, 102, 120, '2018-05-09 10:10:50', '2018-05-09 10:10:50');

INSERT INTO `auth_role_resource` VALUES (91, 102, 121, '2018-05-09 10:10:55', '2018-05-09 10:10:55');

INSERT INTO `auth_role_resource` VALUES (92, 102, 122, '2018-05-09 10:11:00', '2018-05-09 10:11:00');

INSERT INTO `auth_role_resource` VALUES (93, 102, 124, '2018-05-09 10:11:05', '2018-05-09 10:11:05');

INSERT INTO `auth_role_resource` VALUES (94, 102, 125, '2018-05-09 10:11:10', '2018-05-09 10:11:10');

INSERT INTO `auth_role_resource` VALUES (95, 102, 126, '2018-05-09 10:11:15', '2018-05-09 10:11:15');

INSERT INTO `auth_role_resource` VALUES (96, 102, 127, '2018-05-09 10:11:19', '2018-05-09 10:11:19');

INSERT INTO `auth_role_resource` VALUES (97, 102, 129, '2018-05-09 10:11:24', '2018-05-09 10:11:24');

INSERT INTO `auth_role_resource` VALUES (98, 102, 130, '2018-05-09 10:11:29', '2018-05-09 10:11:29');

INSERT INTO `auth_role_resource` VALUES (99, 102, 131, '2018-05-09 10:11:34', '2018-05-09 10:11:34');

INSERT INTO `auth_role_resource` VALUES (100, 102, 133, '2018-05-09 10:11:39', '2018-05-09 10:11:39');

INSERT INTO `auth_role_resource` VALUES (101, 102, 136, '2018-05-09 10:11:44', '2018-05-09 10:11:44');

INSERT INTO `auth_role_resource` VALUES (102, 102, 137, '2018-05-09 10:11:49', '2018-05-09 10:11:49');

INSERT INTO `auth_role_resource` VALUES (103, 102, 138, '2018-05-09 10:11:54', '2018-05-09 10:11:54');

INSERT INTO `auth_role_resource` VALUES (104, 102, 139, '2018-05-09 10:11:59', '2018-05-09 10:11:59');

INSERT INTO `auth_role_resource` VALUES (105, 102, 140, '2018-05-09 10:12:04', '2018-05-09 10:12:04');

INSERT INTO `auth_role_resource` VALUES (106, 102, 141, '2018-05-09 10:12:08', '2018-05-09 10:12:08');

INSERT INTO `auth_role_resource` VALUES (107, 102, 142, '2018-05-09 10:12:13', '2018-05-09 10:12:13');

INSERT INTO `auth_role_resource` VALUES (108, 102, 143, '2018-05-09 10:12:17', '2018-05-09 10:12:17');

INSERT INTO `auth_role_resource` VALUES (109, 102, 144, '2018-05-09 10:12:21', '2018-05-09 10:12:21');



-- ----------------------------

-- Table structure for auth_user

-- ----------------------------

DROP TABLE IF EXISTS `auth_user`;

CREATE TABLE `auth_user`  (

  `uid` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'uid,用户账号,主键',

  `username` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户名(nick_name)',

  `password` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '密码(MD5(密码+盐))',

  `salt` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '盐',

  `real_name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户真名',

  `avatar` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '头像',

  `phone` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '电话号码(唯一)',

  `email` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '邮件地址(唯一)',

  `sex` tinyint(4) NULL DEFAULT NULL COMMENT '性别(1.男 2.女)',

  `status` tinyint(4) NULL DEFAULT NULL COMMENT '账户状态(1.正常 2.锁定 3.删除 4.非法)',

  `CREATE_TIME` datetime(0) NULL DEFAULT current_timestamp() COMMENT '创建时间',

  `UPDATE_TIME` datetime(0) NULL DEFAULT current_timestamp() COMMENT '更新时间',

  `CREATE_WHERE` tinyint(4) NULL DEFAULT NULL COMMENT '创建来源(1.web 2.android 3.ios 4.win 5.macos 6.ubuntu)',

  PRIMARY KEY (`uid`) USING BTREE,

  UNIQUE INDEX `phone`(`phone`) USING BTREE,

  UNIQUE INDEX `email`(`email`) USING BTREE

) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户信息表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of auth_user

-- ----------------------------

INSERT INTO `auth_user` VALUES ('1', '1', '55EC49B5AEF567AFDDC25D322E9FD644', '79sz6j', NULL, NULL, NULL, NULL, NULL, 1, '2018-04-26 19:21:04', '2018-04-26 11:21:04', NULL);



-- ----------------------------

-- Table structure for auth_user_role

-- ----------------------------

DROP TABLE IF EXISTS `auth_user_role`;

CREATE TABLE `auth_user_role`  (

  `ID` int(11) UNSIGNED NOT NULL AUTO_INCREMENT COMMENT '用户角色关联表主键',

  `USER_ID` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户UID',

  `ROLE_ID` int(11) NOT NULL COMMENT '角色ID',

  `CREATE_TIME` datetime(0) NULL DEFAULT current_timestamp() COMMENT '创建时间',

  `UPDATE_TIME` datetime(0) NULL DEFAULT current_timestamp() COMMENT '更新时间',

  PRIMARY KEY (`ID`) USING BTREE,

  UNIQUE INDEX `USER_ID`(`USER_ID`, `ROLE_ID`) USING BTREE

) ENGINE = InnoDB AUTO_INCREMENT = 39 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户角色关联表' ROW_FORMAT = Dynamic;



-- ----------------------------

-- Records of auth_user_role

-- ----------------------------



INSERT INTO `auth_user_role` VALUES (15, '282870345', 103, '2018-04-09 22:44:47', '2018-04-09 22:44:47');





SET FOREIGN_KEY_CHECKS = 1;
Java
1
https://gitee.com/yandeqing/bootshiro.git
git@gitee.com:yandeqing/bootshiro.git
yandeqing
bootshiro
bootshiro
master
点此查找更多帮助

搜索帮助

Git 命令在线学习 如何在 Gitee 导入 GitHub 仓库
Git 仓库基础操作
企业版和社区版功能对比
SSH 公钥设置
如何处理代码冲突
仓库体积过大，如何减小？
如何找回被删除的仓库数据
Gitee 产品配额说明
GitHub仓库快速导入Gitee及同步更新
什么是 Release（发行版）
将 PHP 项目自动发布到 packagist.org
评论
仓库举报
回到顶部