forked from thousmile/spring-admin-vue
-
Notifications
You must be signed in to change notification settings - Fork 0
/
Copy pathsnbad.sql
213 lines (197 loc) · 13.9 KB
/
snbad.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
/*
Navicat MySQL Data Transfer
Source Server : 刘俊mysql
Source Server Version : 50718
Source Host : rm-wz9t8kxl4zxxm6n1l7o.mysql.rds.aliyuncs.com:3306
Source Database : snbad
Target Server Type : MYSQL
Target Server Version : 50718
File Encoding : 65001
Date: 2018-10-29 23:15:29
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for t_sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_dept`;
CREATE TABLE `t_sys_dept` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '部门id',
`name` varchar(255) NOT NULL COMMENT '部门名称',
`parent_id` int(11) NOT NULL COMMENT '上级部门',
`level` int(4) NOT NULL COMMENT '部门排序',
`describe` varchar(255) DEFAULT NULL COMMENT '部门描述',
`up_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
`add_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='[权限管理] 部门表';
-- ----------------------------
-- Records of t_sys_dept
-- ----------------------------
INSERT INTO `t_sys_dept` VALUES ('1', '阿里巴巴集团', '0', '1', '阿里巴巴集团', '2018-10-23 12:47:09', '2018-10-23 12:47:11');
INSERT INTO `t_sys_dept` VALUES ('2', '阿里云', '1', '0', '阿里云科技', '2018-10-23 04:51:46', '2018-10-23 04:51:46');
INSERT INTO `t_sys_dept` VALUES ('3', '事业部门', '2', '1', '阿里云事业部', '2018-10-23 04:50:33', '2018-10-23 04:50:33');
INSERT INTO `t_sys_dept` VALUES ('4', '开发部门', '2', '2', '阿里云开发部门', '2018-10-23 04:50:11', '2018-10-23 04:50:11');
INSERT INTO `t_sys_dept` VALUES ('5', '安全部门', '2', '3', '阿里云安全部门', '2018-10-23 04:50:13', '2018-10-23 04:50:13');
INSERT INTO `t_sys_dept` VALUES ('6', '淘宝网', '1', '0', '淘宝网络科技', '2018-10-23 12:51:39', '2018-10-23 12:51:41');
INSERT INTO `t_sys_dept` VALUES ('7', '快递部门', '6', '1', '淘宝网快递部门', '2018-10-23 12:52:28', '2018-10-23 12:52:30');
INSERT INTO `t_sys_dept` VALUES ('8', '客服部门', '6', '2', '淘宝网客服部门', '2018-10-23 12:52:59', '2018-10-23 12:53:01');
-- ----------------------------
-- Table structure for t_sys_permission
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_permission`;
CREATE TABLE `t_sys_permission` (
`pid` int(11) NOT NULL AUTO_INCREMENT COMMENT '权限唯一ID',
`father` int(11) NOT NULL COMMENT '上级ID',
`resources` varchar(255) NOT NULL COMMENT '权限资源 ',
`title` varchar(100) NOT NULL COMMENT '资源名称',
`icon` varchar(255) DEFAULT NULL COMMENT '资源图标',
`type` varchar(10) NOT NULL DEFAULT '' COMMENT '类型，menu或者button',
`add_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '创建时间',
`up_time` datetime NOT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
`describe` varchar(255) DEFAULT NULL COMMENT '权限描述',
PRIMARY KEY (`pid`)
) ENGINE=InnoDB AUTO_INCREMENT=53 DEFAULT CHARSET=utf8 COMMENT='[权限管理] 权限表';
-- ----------------------------
-- Records of t_sys_permission
-- ----------------------------
INSERT INTO `t_sys_permission` VALUES ('1', '0', 'pre', '权限设置', 'pre_admin', 'menu', '2018-10-28 21:58:53', '2018-10-28 21:58:53', '权限管理，如,用户权限的增删改查');
INSERT INTO `t_sys_permission` VALUES ('2', '0', 'sys', '系统设置', 'sys_set', 'menu', '2018-10-28 21:52:24', '2018-10-28 21:52:24', '系统的详细设置, 如微信公众号 openId');
INSERT INTO `t_sys_permission` VALUES ('3', '0', 'control', '系统监控', 'sys_control', 'menu', '2018-10-28 21:52:25', '2018-10-28 21:52:25', '系统运行时的监控');
INSERT INTO `t_sys_permission` VALUES ('4', '0', 'task', '定时任务', 'time_task', 'menu', '2018-10-28 21:52:27', '2018-10-28 21:52:27', '定时发送文章的任务');
INSERT INTO `t_sys_permission` VALUES ('29', '1', 'perm', '权限管理', 'prem_admin', 'menu', '2018-10-28 21:59:07', '2018-10-28 21:59:07', '');
INSERT INTO `t_sys_permission` VALUES ('30', '1', 'user', '用户管理', 'user__admin', 'menu', '2018-10-28 21:59:11', '2018-10-28 21:59:11', '');
INSERT INTO `t_sys_permission` VALUES ('31', '1', 'role', '角色管理', 'role__admin', 'menu', '2018-10-28 21:59:15', '2018-10-28 21:59:15', '');
INSERT INTO `t_sys_permission` VALUES ('32', '1', 'dept', '部门管理', 'dept__admin', 'menu', '2018-10-28 21:59:19', '2018-10-28 21:59:19', '');
INSERT INTO `t_sys_permission` VALUES ('33', '29', 'perm:new', '新增权限', '', 'button', '2018-10-15 11:35:57', '2018-10-15 11:35:57', '');
INSERT INTO `t_sys_permission` VALUES ('34', '29', 'perm:delete', '删除权限', '', 'button', '2018-10-15 11:35:57', '2018-10-15 11:35:57', '');
INSERT INTO `t_sys_permission` VALUES ('35', '29', 'perm:update', '修改权限', '', 'button', '2018-10-15 11:35:57', '2018-10-15 11:35:57', '');
INSERT INTO `t_sys_permission` VALUES ('36', '29', 'perm:view', '查看权限', '', 'button', '2018-10-15 11:35:57', '2018-10-15 11:35:57', '');
INSERT INTO `t_sys_permission` VALUES ('37', '30', 'user:new', '新增用户', '', 'button', '2018-10-15 11:35:57', '2018-10-15 11:35:57', '');
INSERT INTO `t_sys_permission` VALUES ('38', '30', 'user:delete', '删除用户', '', 'button', '2018-10-15 11:35:57', '2018-10-15 11:35:57', '');
INSERT INTO `t_sys_permission` VALUES ('39', '30', 'user:update', '修改用户', '', 'button', '2018-10-15 11:35:57', '2018-10-15 11:35:57', '');
INSERT INTO `t_sys_permission` VALUES ('40', '30', 'user:view', '查看用户', '', 'button', '2018-10-15 11:35:57', '2018-10-15 11:35:57', '');
INSERT INTO `t_sys_permission` VALUES ('41', '31', 'role:new', '新增角色', '', 'button', '2018-10-15 11:35:57', '2018-10-15 11:35:57', '');
INSERT INTO `t_sys_permission` VALUES ('42', '31', 'role:delete', '删除角色', '', 'button', '2018-10-15 11:35:57', '2018-10-15 11:35:57', '');
INSERT INTO `t_sys_permission` VALUES ('43', '31', 'role:update', '修改角色', '', 'button', '2018-10-15 11:35:57', '2018-10-15 11:35:57', '');
INSERT INTO `t_sys_permission` VALUES ('44', '31', 'role:view', '查看角色', '', 'button', '2018-10-15 11:35:57', '2018-10-15 11:35:57', '');
INSERT INTO `t_sys_permission` VALUES ('45', '32', 'dept:new', '新增部门', '', 'button', '2018-10-15 11:35:57', '2018-10-15 11:35:57', '');
INSERT INTO `t_sys_permission` VALUES ('46', '32', 'dept:delete', '删除部门', '', 'button', '2018-10-15 11:35:57', '2018-10-15 11:35:57', '');
INSERT INTO `t_sys_permission` VALUES ('47', '32', 'dept:update', '修改部门', '', 'button', '2018-10-15 11:35:57', '2018-10-15 11:35:57', '');
INSERT INTO `t_sys_permission` VALUES ('48', '32', 'dept:view', '查看部门', '', 'button', '2018-10-15 11:35:57', '2018-10-15 11:35:57', '');
INSERT INTO `t_sys_permission` VALUES ('49', '3', 'database', '数据库监控', 'control_database', 'menu', '2018-10-28 22:11:11', '2018-10-28 22:11:11', '数据库监控');
INSERT INTO `t_sys_permission` VALUES ('50', '3', 'logs', '系统日志', 'control_logs', 'menu', '2018-10-28 22:11:18', '2018-10-28 22:11:18', '系统日志监控');
INSERT INTO `t_sys_permission` VALUES ('51', '2', 'wechat', '微信设置', 'sys_wechat', 'menu', '2018-10-29 22:26:54', '2018-10-29 22:26:56', '微信相关设置');
INSERT INTO `t_sys_permission` VALUES ('52', '2', 'backstage', '后台设置', 'sys_backstage', 'menu', '2018-10-29 22:29:45', '2018-10-29 22:29:47', '后台设置');
-- ----------------------------
-- Table structure for t_sys_role
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_role`;
CREATE TABLE `t_sys_role` (
`rid` int(11) NOT NULL AUTO_INCREMENT COMMENT '系统角色ID',
`describe` varchar(255) DEFAULT NULL COMMENT '系统角色描述',
`name` varchar(255) DEFAULT NULL COMMENT '系统角色名称',
`state` int(11) DEFAULT NULL COMMENT '系统角色状态[0.删除，1.正常]',
`up_time` datetime DEFAULT NULL COMMENT '修改时间',
`add_time` datetime DEFAULT NULL COMMENT '添加时间',
PRIMARY KEY (`rid`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='[权限管理] 角色表';
-- ----------------------------
-- Records of t_sys_role
-- ----------------------------
INSERT INTO `t_sys_role` VALUES ('3', '超级管理员', 'ROLE_ROOT', '1', '2018-10-23 12:32:10', '2018-10-23 12:32:13');
INSERT INTO `t_sys_role` VALUES ('4', '管理员', 'ROLE_ADMIN', '1', '2018-10-23 12:32:29', '2018-10-23 12:32:31');
INSERT INTO `t_sys_role` VALUES ('5', '编辑', 'ROLE_EDIT', '1', '2018-10-23 12:32:50', '2018-10-23 12:32:52');
INSERT INTO `t_sys_role` VALUES ('6', '测试用户', 'ROLE_USER', '1', '2018-10-23 12:33:11', '2018-10-23 12:33:13');
-- ----------------------------
-- Table structure for t_sys_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_role_permission`;
CREATE TABLE `t_sys_role_permission` (
`permission_id` int(20) NOT NULL COMMENT '权限ID',
`role_id` int(11) NOT NULL COMMENT '角色ID',
KEY `role_id` (`role_id`),
KEY `permission_id` (`permission_id`),
CONSTRAINT `t_sys_role_permission_ibfk_2` FOREIGN KEY (`role_id`) REFERENCES `t_sys_role` (`rid`),
CONSTRAINT `t_sys_role_permission_ibfk_3` FOREIGN KEY (`permission_id`) REFERENCES `t_sys_permission` (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='[权限管理] 角色和权限表';
-- ----------------------------
-- Records of t_sys_role_permission
-- ----------------------------
INSERT INTO `t_sys_role_permission` VALUES ('1', '3');
INSERT INTO `t_sys_role_permission` VALUES ('2', '3');
INSERT INTO `t_sys_role_permission` VALUES ('3', '3');
INSERT INTO `t_sys_role_permission` VALUES ('4', '3');
INSERT INTO `t_sys_role_permission` VALUES ('29', '3');
INSERT INTO `t_sys_role_permission` VALUES ('30', '3');
INSERT INTO `t_sys_role_permission` VALUES ('31', '3');
INSERT INTO `t_sys_role_permission` VALUES ('32', '3');
INSERT INTO `t_sys_role_permission` VALUES ('33', '3');
INSERT INTO `t_sys_role_permission` VALUES ('34', '3');
INSERT INTO `t_sys_role_permission` VALUES ('35', '3');
INSERT INTO `t_sys_role_permission` VALUES ('36', '3');
INSERT INTO `t_sys_role_permission` VALUES ('37', '3');
INSERT INTO `t_sys_role_permission` VALUES ('38', '3');
INSERT INTO `t_sys_role_permission` VALUES ('39', '3');
INSERT INTO `t_sys_role_permission` VALUES ('40', '3');
INSERT INTO `t_sys_role_permission` VALUES ('41', '3');
INSERT INTO `t_sys_role_permission` VALUES ('42', '3');
INSERT INTO `t_sys_role_permission` VALUES ('43', '3');
INSERT INTO `t_sys_role_permission` VALUES ('44', '3');
INSERT INTO `t_sys_role_permission` VALUES ('45', '3');
INSERT INTO `t_sys_role_permission` VALUES ('46', '3');
INSERT INTO `t_sys_role_permission` VALUES ('47', '3');
INSERT INTO `t_sys_role_permission` VALUES ('48', '3');
INSERT INTO `t_sys_role_permission` VALUES ('49', '3');
INSERT INTO `t_sys_role_permission` VALUES ('50', '3');
INSERT INTO `t_sys_role_permission` VALUES ('1', '4');
INSERT INTO `t_sys_role_permission` VALUES ('29', '4');
INSERT INTO `t_sys_role_permission` VALUES ('33', '4');
INSERT INTO `t_sys_role_permission` VALUES ('34', '4');
INSERT INTO `t_sys_role_permission` VALUES ('35', '4');
INSERT INTO `t_sys_role_permission` VALUES ('36', '4');
INSERT INTO `t_sys_role_permission` VALUES ('51', '3');
INSERT INTO `t_sys_role_permission` VALUES ('52', '3');
-- ----------------------------
-- Table structure for t_sys_user
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user`;
CREATE TABLE `t_sys_user` (
`uid` varchar(250) NOT NULL COMMENT '系统用户ID',
`avatar` varchar(255) NOT NULL COMMENT '头像',
`username` varchar(100) NOT NULL COMMENT '账号',
`nickname` varchar(100) NOT NULL COMMENT '用户名称',
`password` varchar(255) NOT NULL COMMENT '密码',
`phone` varchar(20) DEFAULT NULL COMMENT '手机号码',
`mail` varchar(50) NOT NULL COMMENT '邮箱',
`state` int(4) NOT NULL COMMENT '状态',
`add_time` datetime DEFAULT NULL COMMENT '添加时间',
`up_time` datetime DEFAULT NULL COMMENT '修改时间',
`dept` int(11) DEFAULT NULL COMMENT '部门id',
PRIMARY KEY (`uid`),
UNIQUE KEY `UK_6i5ixxulo5s2i7qoksp54tgwl` (`username`),
KEY `t_dept` (`dept`),
CONSTRAINT `t_sys_user_ibfk_1` FOREIGN KEY (`dept`) REFERENCES `t_sys_dept` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='[权限管理] 用户表';
-- ----------------------------
-- Records of t_sys_user
-- ----------------------------
INSERT INTO `t_sys_user` VALUES ('3BDDD3B7B3AF4BA2A8FA0EFEB585597B', 'https://ifsaid-blog.oss-cn-shenzhen.aliyuncs.com/images/2018/9/28/3BDDD3B7B3AF4BA2A8FA0EFEB585597B.jpg', 'admin', '系统管理员', '$2a$10$XTF2XRl2GR9ARlR/C55bjOYnpfTZeSmDyqJwKQMTm16BXau.BsCC.', null, '[email protected]', '1', '2018-10-23 12:09:02', '2018-10-23 12:09:05', '4');
INSERT INTO `t_sys_user` VALUES ('3BDwqwqeqwc5448wqevcrA0EFEB585597B', 'https://ifsaid-blog.oss-cn-shenzhen.aliyuncs.com/images/2018/9/28/3BDDD3B7B3AF4BA2A8FA0EFEB585597B.jpg', 'test', '测试用户', '$2a$10$HL7Di2TKZKwJenz/c06W4eEwNvSppfI6mj34JkwVAaJ9eb.8wRPlK', null, '[email protected]', '1', '2018-10-23 12:09:02', '2018-10-23 12:09:05', '5');
-- ----------------------------
-- Table structure for t_sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `t_sys_user_role`;
CREATE TABLE `t_sys_user_role` (
`user_uid` varchar(250) NOT NULL COMMENT '用户id',
`role_rid` int(11) NOT NULL COMMENT '角色id',
KEY `user_uid` (`user_uid`),
KEY `role_rid` (`role_rid`),
CONSTRAINT `t_sys_user_role_ibfk_2` FOREIGN KEY (`role_rid`) REFERENCES `t_sys_role` (`rid`),
CONSTRAINT `t_sys_user_role_ibfk_3` FOREIGN KEY (`user_uid`) REFERENCES `t_sys_user` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='[权限管理] 角色和权限表';
-- ----------------------------
-- Records of t_sys_user_role
-- ----------------------------
INSERT INTO `t_sys_user_role` VALUES ('3BDDD3B7B3AF4BA2A8FA0EFEB585597B', '3');
INSERT INTO `t_sys_user_role` VALUES ('3BDDD3B7B3AF4BA2A8FA0EFEB585597B', '6');
INSERT INTO `t_sys_user_role` VALUES ('3BDwqwqeqwc5448wqevcrA0EFEB585597B', '4');