-
Notifications
You must be signed in to change notification settings - Fork 4
/
Copy pathuser.sql
427 lines (409 loc) · 31.7 KB
/
user.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
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
/*
Navicat MySQL Data Transfer
Source Server : localhost
Source Server Version : 50516
Source Host : localhost:3306
Source Database : user
Target Server Type : MYSQL
Target Server Version : 50516
File Encoding : 65001
Date: 2018-12-31 16:47:00
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for tb_company
-- ----------------------------
DROP TABLE IF EXISTS `tb_company`;
CREATE TABLE `tb_company` (
`id` int(255) NOT NULL AUTO_INCREMENT COMMENT '公司id',
`name` varchar(255) NOT NULL COMMENT '公司名字',
`description` varchar(255) NOT NULL COMMENT '公司描述',
`address` varchar(255) NOT NULL COMMENT '公司地址',
`phone` varchar(255) NOT NULL COMMENT '公司电话',
`createDate` varchar(255) NOT NULL COMMENT '创建时间',
`modifyDate` varchar(255) NOT NULL COMMENT '修改日期',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of tb_company
-- ----------------------------
INSERT INTO `tb_company` VALUES ('1', '百度自动驾驶广州黄埔分公司', '百度自动驾驶广州黄埔分公司', '广东广州', '020088888888', '2018-12-12 16:17:48', '2018-12-21 15:53:53');
INSERT INTO `tb_company` VALUES ('2', '广东滴滴公司', '广东滴滴公司', '魔都上海', '01066666667', '2018-12-12 16:17:48', '2018-12-25 08:42:40');
-- ----------------------------
-- Table structure for tb_dept
-- ----------------------------
DROP TABLE IF EXISTS `tb_dept`;
CREATE TABLE `tb_dept` (
`id` int(255) NOT NULL AUTO_INCREMENT COMMENT '部门id',
`name` varchar(255) NOT NULL COMMENT '部门名称',
`createDate` varchar(255) NOT NULL COMMENT '创建时间',
`description` varchar(255) NOT NULL COMMENT '部门描述',
`modifyDate` varchar(255) NOT NULL COMMENT '修改日期',
`comId` int(11) DEFAULT NULL COMMENT '公司id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of tb_dept
-- ----------------------------
INSERT INTO `tb_dept` VALUES ('1', '研发部门', '2018-12-12 14:41:35', '开发软件、硬件。', '2018-12-21 15:51:09', '1');
INSERT INTO `tb_dept` VALUES ('2', '后勤部门', '2018-12-12 14:41:35', '后勤部门', '2018-12-21 15:53:24', '1');
INSERT INTO `tb_dept` VALUES ('3', '人事部门', '2018-12-12 14:41:35', '人事部门', '2018-12-21 15:54:18', '2');
INSERT INTO `tb_dept` VALUES ('4', '技术支持部门', '2018-12-12 14:41:35', '技术支持部门', '2018-12-21 15:54:50', '2');
-- ----------------------------
-- Table structure for tb_role
-- ----------------------------
DROP TABLE IF EXISTS `tb_role`;
CREATE TABLE `tb_role` (
`id` int(255) NOT NULL AUTO_INCREMENT COMMENT '角色id',
`roleName` varchar(255) NOT NULL COMMENT '角色名',
`description` varchar(255) NOT NULL COMMENT '角色描述',
`createDate` varchar(255) NOT NULL COMMENT '创建时间',
`modifyDate` varchar(255) NOT NULL COMMENT '修改时间',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of tb_role
-- ----------------------------
INSERT INTO `tb_role` VALUES ('1', '超级管理员', '超级管理员', '2018-12-12 16:00:10', '2018-12-21 15:55:03');
INSERT INTO `tb_role` VALUES ('2', '管理员', '管理员', '2018-12-12 16:00:13', '2018-12-21 15:55:08');
INSERT INTO `tb_role` VALUES ('3', '普通用户', '普通用户', '2018-12-12 16:00:15', '2018-12-21 15:55:13');
INSERT INTO `tb_role` VALUES ('4', 'demo', 'demo', '2018-12-24 10:39:41', '2018-12-24 10:39:41');
-- ----------------------------
-- Table structure for tb_role_rule
-- ----------------------------
DROP TABLE IF EXISTS `tb_role_rule`;
CREATE TABLE `tb_role_rule` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '角色_权限id',
`roleId` int(255) NOT NULL COMMENT '角色id',
`ruleId` int(255) NOT NULL COMMENT '权限id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=935 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of tb_role_rule
-- ----------------------------
INSERT INTO `tb_role_rule` VALUES ('565', '3', '1');
INSERT INTO `tb_role_rule` VALUES ('566', '3', '2');
INSERT INTO `tb_role_rule` VALUES ('567', '3', '3');
INSERT INTO `tb_role_rule` VALUES ('568', '3', '4');
INSERT INTO `tb_role_rule` VALUES ('569', '3', '5');
INSERT INTO `tb_role_rule` VALUES ('570', '3', '6');
INSERT INTO `tb_role_rule` VALUES ('571', '3', '7');
INSERT INTO `tb_role_rule` VALUES ('572', '3', '8');
INSERT INTO `tb_role_rule` VALUES ('573', '3', '9');
INSERT INTO `tb_role_rule` VALUES ('574', '3', '10');
INSERT INTO `tb_role_rule` VALUES ('575', '3', '11');
INSERT INTO `tb_role_rule` VALUES ('576', '3', '12');
INSERT INTO `tb_role_rule` VALUES ('577', '3', '13');
INSERT INTO `tb_role_rule` VALUES ('578', '3', '14');
INSERT INTO `tb_role_rule` VALUES ('579', '3', '15');
INSERT INTO `tb_role_rule` VALUES ('580', '3', '16');
INSERT INTO `tb_role_rule` VALUES ('581', '3', '17');
INSERT INTO `tb_role_rule` VALUES ('582', '3', '18');
INSERT INTO `tb_role_rule` VALUES ('583', '3', '19');
INSERT INTO `tb_role_rule` VALUES ('584', '3', '20');
INSERT INTO `tb_role_rule` VALUES ('585', '3', '21');
INSERT INTO `tb_role_rule` VALUES ('586', '3', '22');
INSERT INTO `tb_role_rule` VALUES ('587', '3', '23');
INSERT INTO `tb_role_rule` VALUES ('588', '3', '24');
INSERT INTO `tb_role_rule` VALUES ('589', '3', '25');
INSERT INTO `tb_role_rule` VALUES ('590', '3', '26');
INSERT INTO `tb_role_rule` VALUES ('591', '3', '27');
INSERT INTO `tb_role_rule` VALUES ('592', '3', '28');
INSERT INTO `tb_role_rule` VALUES ('593', '3', '29');
INSERT INTO `tb_role_rule` VALUES ('594', '3', '30');
INSERT INTO `tb_role_rule` VALUES ('595', '3', '31');
INSERT INTO `tb_role_rule` VALUES ('596', '3', '58');
INSERT INTO `tb_role_rule` VALUES ('597', '3', '59');
INSERT INTO `tb_role_rule` VALUES ('598', '3', '60');
INSERT INTO `tb_role_rule` VALUES ('599', '3', '61');
INSERT INTO `tb_role_rule` VALUES ('740', '4', '61');
INSERT INTO `tb_role_rule` VALUES ('803', '1', '1');
INSERT INTO `tb_role_rule` VALUES ('804', '1', '2');
INSERT INTO `tb_role_rule` VALUES ('805', '1', '3');
INSERT INTO `tb_role_rule` VALUES ('806', '1', '4');
INSERT INTO `tb_role_rule` VALUES ('807', '1', '5');
INSERT INTO `tb_role_rule` VALUES ('808', '1', '6');
INSERT INTO `tb_role_rule` VALUES ('809', '1', '7');
INSERT INTO `tb_role_rule` VALUES ('810', '1', '8');
INSERT INTO `tb_role_rule` VALUES ('811', '1', '9');
INSERT INTO `tb_role_rule` VALUES ('812', '1', '10');
INSERT INTO `tb_role_rule` VALUES ('813', '1', '11');
INSERT INTO `tb_role_rule` VALUES ('814', '1', '12');
INSERT INTO `tb_role_rule` VALUES ('815', '1', '13');
INSERT INTO `tb_role_rule` VALUES ('816', '1', '14');
INSERT INTO `tb_role_rule` VALUES ('817', '1', '15');
INSERT INTO `tb_role_rule` VALUES ('818', '1', '16');
INSERT INTO `tb_role_rule` VALUES ('819', '1', '17');
INSERT INTO `tb_role_rule` VALUES ('820', '1', '18');
INSERT INTO `tb_role_rule` VALUES ('821', '1', '19');
INSERT INTO `tb_role_rule` VALUES ('822', '1', '20');
INSERT INTO `tb_role_rule` VALUES ('823', '1', '21');
INSERT INTO `tb_role_rule` VALUES ('824', '1', '22');
INSERT INTO `tb_role_rule` VALUES ('825', '1', '23');
INSERT INTO `tb_role_rule` VALUES ('826', '1', '24');
INSERT INTO `tb_role_rule` VALUES ('827', '1', '25');
INSERT INTO `tb_role_rule` VALUES ('828', '1', '26');
INSERT INTO `tb_role_rule` VALUES ('829', '1', '27');
INSERT INTO `tb_role_rule` VALUES ('830', '1', '28');
INSERT INTO `tb_role_rule` VALUES ('831', '1', '29');
INSERT INTO `tb_role_rule` VALUES ('832', '1', '30');
INSERT INTO `tb_role_rule` VALUES ('833', '1', '31');
INSERT INTO `tb_role_rule` VALUES ('834', '1', '32');
INSERT INTO `tb_role_rule` VALUES ('835', '1', '33');
INSERT INTO `tb_role_rule` VALUES ('836', '1', '34');
INSERT INTO `tb_role_rule` VALUES ('837', '1', '35');
INSERT INTO `tb_role_rule` VALUES ('838', '1', '36');
INSERT INTO `tb_role_rule` VALUES ('839', '1', '37');
INSERT INTO `tb_role_rule` VALUES ('840', '1', '38');
INSERT INTO `tb_role_rule` VALUES ('841', '1', '39');
INSERT INTO `tb_role_rule` VALUES ('842', '1', '40');
INSERT INTO `tb_role_rule` VALUES ('843', '1', '41');
INSERT INTO `tb_role_rule` VALUES ('844', '1', '42');
INSERT INTO `tb_role_rule` VALUES ('845', '1', '43');
INSERT INTO `tb_role_rule` VALUES ('846', '1', '44');
INSERT INTO `tb_role_rule` VALUES ('847', '1', '45');
INSERT INTO `tb_role_rule` VALUES ('848', '1', '46');
INSERT INTO `tb_role_rule` VALUES ('849', '1', '47');
INSERT INTO `tb_role_rule` VALUES ('850', '1', '48');
INSERT INTO `tb_role_rule` VALUES ('851', '1', '49');
INSERT INTO `tb_role_rule` VALUES ('852', '1', '50');
INSERT INTO `tb_role_rule` VALUES ('853', '1', '51');
INSERT INTO `tb_role_rule` VALUES ('854', '1', '52');
INSERT INTO `tb_role_rule` VALUES ('855', '1', '53');
INSERT INTO `tb_role_rule` VALUES ('856', '1', '54');
INSERT INTO `tb_role_rule` VALUES ('857', '1', '55');
INSERT INTO `tb_role_rule` VALUES ('858', '1', '56');
INSERT INTO `tb_role_rule` VALUES ('859', '1', '57');
INSERT INTO `tb_role_rule` VALUES ('860', '1', '58');
INSERT INTO `tb_role_rule` VALUES ('861', '1', '59');
INSERT INTO `tb_role_rule` VALUES ('862', '1', '60');
INSERT INTO `tb_role_rule` VALUES ('863', '1', '61');
INSERT INTO `tb_role_rule` VALUES ('864', '1', '62');
INSERT INTO `tb_role_rule` VALUES ('865', '1', '63');
INSERT INTO `tb_role_rule` VALUES ('866', '1', '64');
INSERT INTO `tb_role_rule` VALUES ('867', '1', '65');
INSERT INTO `tb_role_rule` VALUES ('868', '1', '66');
INSERT INTO `tb_role_rule` VALUES ('869', '2', '1');
INSERT INTO `tb_role_rule` VALUES ('870', '2', '2');
INSERT INTO `tb_role_rule` VALUES ('871', '2', '3');
INSERT INTO `tb_role_rule` VALUES ('872', '2', '4');
INSERT INTO `tb_role_rule` VALUES ('873', '2', '5');
INSERT INTO `tb_role_rule` VALUES ('874', '2', '6');
INSERT INTO `tb_role_rule` VALUES ('875', '2', '7');
INSERT INTO `tb_role_rule` VALUES ('876', '2', '8');
INSERT INTO `tb_role_rule` VALUES ('877', '2', '9');
INSERT INTO `tb_role_rule` VALUES ('878', '2', '10');
INSERT INTO `tb_role_rule` VALUES ('879', '2', '11');
INSERT INTO `tb_role_rule` VALUES ('880', '2', '12');
INSERT INTO `tb_role_rule` VALUES ('881', '2', '13');
INSERT INTO `tb_role_rule` VALUES ('882', '2', '14');
INSERT INTO `tb_role_rule` VALUES ('883', '2', '15');
INSERT INTO `tb_role_rule` VALUES ('884', '2', '16');
INSERT INTO `tb_role_rule` VALUES ('885', '2', '17');
INSERT INTO `tb_role_rule` VALUES ('886', '2', '18');
INSERT INTO `tb_role_rule` VALUES ('887', '2', '19');
INSERT INTO `tb_role_rule` VALUES ('888', '2', '20');
INSERT INTO `tb_role_rule` VALUES ('889', '2', '21');
INSERT INTO `tb_role_rule` VALUES ('890', '2', '22');
INSERT INTO `tb_role_rule` VALUES ('891', '2', '23');
INSERT INTO `tb_role_rule` VALUES ('892', '2', '24');
INSERT INTO `tb_role_rule` VALUES ('893', '2', '25');
INSERT INTO `tb_role_rule` VALUES ('894', '2', '26');
INSERT INTO `tb_role_rule` VALUES ('895', '2', '27');
INSERT INTO `tb_role_rule` VALUES ('896', '2', '28');
INSERT INTO `tb_role_rule` VALUES ('897', '2', '29');
INSERT INTO `tb_role_rule` VALUES ('898', '2', '30');
INSERT INTO `tb_role_rule` VALUES ('899', '2', '31');
INSERT INTO `tb_role_rule` VALUES ('900', '2', '32');
INSERT INTO `tb_role_rule` VALUES ('901', '2', '33');
INSERT INTO `tb_role_rule` VALUES ('902', '2', '34');
INSERT INTO `tb_role_rule` VALUES ('903', '2', '35');
INSERT INTO `tb_role_rule` VALUES ('904', '2', '36');
INSERT INTO `tb_role_rule` VALUES ('905', '2', '37');
INSERT INTO `tb_role_rule` VALUES ('906', '2', '38');
INSERT INTO `tb_role_rule` VALUES ('907', '2', '39');
INSERT INTO `tb_role_rule` VALUES ('908', '2', '40');
INSERT INTO `tb_role_rule` VALUES ('909', '2', '41');
INSERT INTO `tb_role_rule` VALUES ('910', '2', '42');
INSERT INTO `tb_role_rule` VALUES ('911', '2', '43');
INSERT INTO `tb_role_rule` VALUES ('912', '2', '44');
INSERT INTO `tb_role_rule` VALUES ('913', '2', '45');
INSERT INTO `tb_role_rule` VALUES ('914', '2', '46');
INSERT INTO `tb_role_rule` VALUES ('915', '2', '47');
INSERT INTO `tb_role_rule` VALUES ('916', '2', '48');
INSERT INTO `tb_role_rule` VALUES ('917', '2', '49');
INSERT INTO `tb_role_rule` VALUES ('918', '2', '50');
INSERT INTO `tb_role_rule` VALUES ('919', '2', '51');
INSERT INTO `tb_role_rule` VALUES ('920', '2', '52');
INSERT INTO `tb_role_rule` VALUES ('921', '2', '53');
INSERT INTO `tb_role_rule` VALUES ('922', '2', '54');
INSERT INTO `tb_role_rule` VALUES ('923', '2', '55');
INSERT INTO `tb_role_rule` VALUES ('924', '2', '56');
INSERT INTO `tb_role_rule` VALUES ('925', '2', '57');
INSERT INTO `tb_role_rule` VALUES ('926', '2', '58');
INSERT INTO `tb_role_rule` VALUES ('927', '2', '59');
INSERT INTO `tb_role_rule` VALUES ('928', '2', '60');
INSERT INTO `tb_role_rule` VALUES ('929', '2', '61');
INSERT INTO `tb_role_rule` VALUES ('930', '2', '62');
INSERT INTO `tb_role_rule` VALUES ('931', '2', '63');
INSERT INTO `tb_role_rule` VALUES ('932', '2', '64');
INSERT INTO `tb_role_rule` VALUES ('933', '2', '65');
INSERT INTO `tb_role_rule` VALUES ('934', '2', '66');
-- ----------------------------
-- Table structure for tb_rule
-- ----------------------------
DROP TABLE IF EXISTS `tb_rule`;
CREATE TABLE `tb_rule` (
`id` int(255) NOT NULL AUTO_INCREMENT COMMENT '权限id',
`ruleName` varchar(255) NOT NULL COMMENT '权限名称',
`description` varchar(255) NOT NULL COMMENT '权限描述',
`type` varchar(255) DEFAULT NULL COMMENT '类型 0菜单 1按钮',
`permissions` varchar(255) DEFAULT NULL COMMENT '权限',
`url` varchar(255) NOT NULL COMMENT '对应url',
`orderNum` int(11) DEFAULT NULL COMMENT '排序',
`pid` int(11) NOT NULL COMMENT '上级菜单id',
`createDate` varchar(255) NOT NULL COMMENT '创建时间',
`modifyDate` varchar(255) NOT NULL COMMENT '修改日期',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of tb_rule
-- ----------------------------
INSERT INTO `tb_rule` VALUES ('1', '系统管理', '系统管理', 'menu', 'system:setting', 'javascript:;', '0', '0', '2018-12-12 13:39:45', '2018-12-22 15:38:23');
INSERT INTO `tb_rule` VALUES ('2', '报表导出', '报表导出', 'menu', 'excelExports', 'excelExports.html', '0', '0', '2018-12-12 13:39:45', '2018-12-21 10:55:33');
INSERT INTO `tb_rule` VALUES ('3', '用户管理接口文档', '用户管理接口文档', 'menu', 'user:swagger', 'swagger-ui.html', '0', '1', '2018-12-12 13:39:45', '2018-12-12 13:39:45');
INSERT INTO `tb_rule` VALUES ('4', '数据库监控', '数据库监控', 'menu', 'user:druid', 'druid', '0', '1', '2018-12-12 13:39:45', '2018-12-12 13:39:45');
INSERT INTO `tb_rule` VALUES ('5', '用户设置', '用户设置', 'menu', 'user:manage', 'javascript:;', '0', '0', '2018-12-12 13:39:45', '2018-12-12 13:39:45');
INSERT INTO `tb_rule` VALUES ('6', '用户管理', '用户管理', 'menu', 'user:manage', 'user/userSetting.html', '0', '5', '2018：12：15', '2018：12：15');
INSERT INTO `tb_rule` VALUES ('7', '角色管理', '角色管理', 'menu', 'role:manage', 'user/characterSetting.html', '0', '5', '2018：12：15', '2018：12：15');
INSERT INTO `tb_rule` VALUES ('8', '权限管理', '权限管理', 'menu', 'rule:manage', 'user/rightSetting.html', '0', '5', '2018：12：15', '2018：12：15');
INSERT INTO `tb_rule` VALUES ('9', '公司管理', '公司管理', 'menu', 'company:manage', 'user/companySetting.html', '0', '5', '2018：12：15', '2018：12：15');
INSERT INTO `tb_rule` VALUES ('10', '部门管理', '部门管理', 'menu', 'dept:manage', 'user/departmentSetting.html', '0', '5', '2018：12：15', '2018：12：15');
INSERT INTO `tb_rule` VALUES ('11', '用户添加', '用户添加', 'button', 'user:create', 'api/v1/user/user', '0', '6', '2018-12-12 13:39:24', '2018-12-12 13:39:24');
INSERT INTO `tb_rule` VALUES ('12', '获取id对应的用户信息', '获取id对应的用户信息', 'button', 'user:read', 'api/v1/user/user', '0', '6', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('13', '更新用户信息', '更新用户信息', 'button', 'user:update', 'api/v1/user/user', '0', '6', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('14', '删除用户', '删除用户信息', 'button', 'user:delete ', 'api/v1/user/user', '0', '6', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('15', '获取用户列表', '获取用户列表', 'button', 'users:read', 'api/v1/user/users', '0', '6', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('16', '获取用户信息列表(对应公司)', '获取用户信息列表(对应公司)', 'button', 'userCom:read', 'api/v1/user/userCom', '0', '6', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('17', '查找用户', '查找用户', 'button', 'user:searchUser', 'api/v1/user/user/searchByUsername', '0', '6', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('18', '查找公司用户', '查找公司用户', 'button', 'user:searchComUser', 'api/v1/user/user/searchByUserNameAndComId', '0', '6', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('19', '判断用户名重复', '判断用户名重复', 'button', 'user:judgeUsername', 'api/v1/user/user/judgeUsername', '0', '6', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('20', '修改密码', '修改密码', 'button', 'user:modifyPwd', 'api/v1/user/user/modifyPwd', '0', '6', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('21', '角色添加', '角色添加', 'button', 'role:create', 'api/v1/user/role', '0', '7', '2018-12-12 13:39:24', '2018-12-12 13:39:24');
INSERT INTO `tb_rule` VALUES ('22', '获取id对应的角色信息', '获取id对应的角色信息', 'button', 'role:read', 'api/v1/user/role', '0', '7', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('23', '更新角色信息', '更新角色信息', 'button', 'role:update', 'api/v1/user/role', '0', '7', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('24', '删除角色', '删除角色信息', 'button', 'role:delete ', 'api/v1/user/role', '0', '7', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('25', '获取角色列表', '获取角色列表', 'button', 'roles:read', 'api/v1/user/roles', '0', '7', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('26', '查找角色', '查找角色', 'button', 'role:searchByName', 'api/v1/user/user/searchByName', '0', '7', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('27', '获取用户对应角色', '获取用户对应角色', 'button', 'role:userRole', 'api/v1/user/userRole', '0', '6', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('28', '权限添加', '权限添加', 'button', 'rule:create', 'api/v1/user/rule', '0', '8', '2018-12-12 13:39:24', '2018-12-12 13:39:24');
INSERT INTO `tb_rule` VALUES ('29', '获取id对应的权限信息', '获取id对应的权限信息', 'button', 'rule:read', 'api/v1/user/rule', '0', '8', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('30', '更新权限信息', '更新权限信息', 'button', 'rule:update', 'api/v1/user/rule', '0', '8', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('31', '删除权限', '删除权限信息', 'button', 'rule:delete ', 'api/v1/user/rule', '0', '8', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('32', '获取权限列表', '获取权限列表', 'button', 'rules:read', 'api/v1/user/rules', '0', '8', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('33', '查找权限', '查找权限', 'button', 'rule:searchByName', 'api/v1/user/role/searchByName', '0', '8', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('34', '获取角色对应权限', '获取角色对应权限', 'button', 'roleRule:read', 'api/v1/user/roleRule', '0', '8', '2018-12-12 13:39:24', '2018-12-12 13:39:24');
INSERT INTO `tb_rule` VALUES ('35', '公司添加', '公司添加', 'button', 'company:create', 'api/v1/user/company', '0', '9', '2018-12-12 13:39:24', '2018-12-12 13:39:24');
INSERT INTO `tb_rule` VALUES ('36', '获取id对应的公司信息', '获取id对应的公司信息', 'button', 'company:read', 'api/v1/user/rule', '0', '9', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('37', '更新公司信息', '更新公司信息', 'button', 'company:update', 'api/v1/user/company', '0', '9', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('38', '删除公司', '删除公司信息', 'button', 'company:delete ', 'api/v1/user/company', '0', '9', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('39', '获取权限列表', '获取公司列表', 'button', 'companys:read', 'api/v1/user/companys', '0', '9', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('40', '查找公司', '查找公司', 'button', 'company:searchByName', 'api/v1/user/company/searchByName', '0', '9', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('41', '获取公司信息', '获取公司信息', 'button', 'company:readAll', 'api/v1/user/company', '0', '9', '2018-12-12 13:39:24', '2018-12-12 13:39:24');
INSERT INTO `tb_rule` VALUES ('42', '部门添加', '部门添加', 'button', 'dept:create', 'api/v1/user/dept', '0', '10', '2018-12-12 13:39:24', '2018-12-12 13:39:24');
INSERT INTO `tb_rule` VALUES ('43', '获取id对应的部门信息', '获取id对应的部门信息', 'button', 'dept:read', 'api/v1/user/dept', '0', '10', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('44', '更新部门信息', '更新部门信息', 'button', 'dept:update', 'api/v1/user/dept', '0', '10', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('45', '删除部门', '删除部门信息', 'button', 'dept:delete ', 'api/v1/user/dept', '0', '10', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('46', '获取公司部门', '获取公司部门', 'button', 'comDept:read', 'api/v1/user/comDept', '0', '10', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('47', '获取部门信息', '获取部门信息', 'button', 'dept:readAll', 'api/v1/user/dept', '0', '10', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('48', '获取部门信息列表', '获取部门信息列表', 'button', 'depts:read', 'api/v1/user/depts', '0', '10', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('49', '获取部门列表（对应公司）', '获取部门列表（对应公司）', 'button', 'comDepts:read', 'api/v1/user/comDepts', '0', '10', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('50', '查找部门', '查找部门', 'button', 'dept:searchByName', 'api/v1/user/dept/searchByName', '0', '10', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('51', '查找公司部门', '查找公司部门', 'button', 'dept:searchByNameAndComId', 'api/v1/user/dept/searchByNameAndComId', '0', '10', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('52', '添加用户-角色管理信息', '添加用户-角色管理信息', 'button', 'userRole:create', 'api/v1/user/userRole', '0', '10', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('53', '更新id对应的用户-角色管理信息', '更新id对应的用户-角色管理信息', 'button', 'userRole:update', 'api/v1/user/userRole', '0', '10', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('54', '添加角色-权限管理信息', '添加角色-权限管理信息', 'button', 'roleRule:create', 'api/v1/user/roleRule', '0', '10', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('55', '更新id对应的角色-权限管理信息', '更新id对应的角色-权限管理信息', 'button', 'roleRule:update', 'api/v1/user/roleRule', '0', '10', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('56', '获取全部角色', '获取全部角色', 'button', 'role:getAll', 'api/v1/user/role/getAll', '0', '7', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('57', '获取全部权限', '获取全部权限', 'button', 'rule:getAll', 'api/v1/user/rule/getAll', '0', '8', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('58', '车辆监控', '车辆监控', 'menu', 'car:monitor', 'javascript:;', '0', '0', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('59', '实时定位', '实时定位', 'menu', 'realTime:position', 'map/bds.html', '0', '58', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('60', '历史轨迹', '历史轨迹', 'menu', 'car:trackBack', 'map/trackback.html', '0', '58', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('61', '应用监控', '应用监控', 'menu', 'app:monitor', 'http://120.79.100.1:7000/api/v1/monitor/login', '0', '1', '2018-12-12 16:17:48', '2018-12-12 16:17:48');
INSERT INTO `tb_rule` VALUES ('62', '操作日志管理', '操作日志', 'menu', 'syslog:manage', 'logger.html', '0', '1', '2018-12-30 10:37:00', '2018-12-30 10:37:00');
INSERT INTO `tb_rule` VALUES ('63', '读取对应日志', '读取对应日志', 'button', 'syslog:read', '/api/v2/logger/syslog', '0', '62', '2018-12-30 10:37:00', '2018-12-30 10:37:00');
INSERT INTO `tb_rule` VALUES ('64', '获取所有操作日志', '获取所有操作日志', 'button', 'syslogs:read', '/api/v2/logger/syslogs', '0', '62', '2018-12-30 10:37:00', '2018-12-30 10:37:00');
INSERT INTO `tb_rule` VALUES ('65', '获取本人操作日志', '获取本人操作日志', 'button', 'userSysLogs:read', '/api/v2/logger/userSysLogs', '0', '62', '2018-12-30 10:37:00', '2018-12-30 10:37:00');
INSERT INTO `tb_rule` VALUES ('66', '查找用户操作日志', '查找用户操作日志', 'button', 'syslog:searchByUsername:read', '/api/v2/logger/syslog/searchByUsernam', '0', '62', '2018-12-30 10:37:00', '2018-12-30 10:37:00');
-- ----------------------------
-- Table structure for tb_user
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
`id` int(255) NOT NULL AUTO_INCREMENT COMMENT '用户id',
`username` varchar(255) NOT NULL COMMENT '用户名',
`salt` varchar(255) DEFAULT NULL COMMENT '盐值（加密密码用）',
`pwd` varchar(255) NOT NULL,
`createDate` varchar(255) NOT NULL COMMENT '创建时间',
`modifyDate` varchar(255) DEFAULT NULL COMMENT '修改时间',
`avatarUrl` varchar(255) DEFAULT NULL COMMENT '头像',
`status` int(255) DEFAULT NULL COMMENT '状态 0 不可用 1 可用',
`name` varchar(255) DEFAULT NULL COMMENT '真实姓名',
`phone` varchar(255) DEFAULT NULL COMMENT '手机',
`age` int(11) DEFAULT NULL COMMENT '年龄',
`sex` int(255) DEFAULT NULL COMMENT '性别 0男 1女',
`address` varchar(255) DEFAULT NULL COMMENT '家庭住址',
`email` varchar(255) DEFAULT NULL COMMENT '邮箱',
`job` varchar(255) DEFAULT NULL COMMENT '职位',
`deptId` int(11) DEFAULT NULL COMMENT '部门id',
`comId` int(11) DEFAULT NULL COMMENT '公司id',
`remark` varchar(255) DEFAULT NULL COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of tb_user
-- ----------------------------
INSERT INTO `tb_user` VALUES ('1', 'root', '63856b59dd154d64a2ebba7601c4c87b', '38BFDE3B8BA4F59C7CBA5DDFEDFB916B', '2018-12-12 13:32:05', '2018-12-22 09:26:12', '1', '1', '超级管理员', '14657861455', '27', '0', '广东广州', '211423432@qq.com', '董事长', '1', '1', '');
INSERT INTO `tb_user` VALUES ('2', 'admin', '63856b59dd154d64a2ebba7601c4c87b', '38BFDE3B8BA4F59C7CBA5DDFEDFB916B', '2018-12-12 13:32:05', '2018-12-24 20:57:01', '1', '1', '管理员', '13634478678', '22', '1', '魔都上海', '83684633@163.com', '部门经理', '3', '2', '');
INSERT INTO `tb_user` VALUES ('3', 'root1', '63856b59dd154d64a2ebba7601c4c87b', '38BFDE3B8BA4F59C7CBA5DDFEDFB916B', '2018-12-12 13:32:05', '2018-12-12 13:39:24', '无头像', '0', 'root', '13634676678', '21', '0', '广东广州', '21423432@qq.com', '总经理', '1', '1', '');
INSERT INTO `tb_user` VALUES ('4', 'admin1', '63856b59dd154d64a2ebba7601c4c87b', '38BFDE3B8BA4F59C7CBA5DDFEDFB916B', '2018-12-12 13:32:05', '2018-12-12 13:32:05', '无头像', '1', 'admin', '13634478678', '22', '1', '魔都上海', '83684633@163.com', '董事长', '4', '2', '');
INSERT INTO `tb_user` VALUES ('5', 'root2', '63856b59dd154d64a2ebba7601c4c87b', '38BFDE3B8BA4F59C7CBA5DDFEDFB916B', '2018-12-12 13:32:05', '2018-12-12 13:39:24', '无头像', '1', 'root', '13634676678', '21', '0', '广东广州', '21423432@qq.com', '总经理', '2', '1', '');
INSERT INTO `tb_user` VALUES ('6', 'admin2', '63856b59dd154d64a2ebba7601c4c87b', '38BFDE3B8BA4F59C7CBA5DDFEDFB916B', '2018-12-12 13:32:05', '2018-12-12 13:32:05', '无头像', '1', 'admin', '13634478678', '22', '1', '魔都上海', '83684633@163.com', '董事长', '4', '2', '');
INSERT INTO `tb_user` VALUES ('7', 'root3', '63856b59dd154d64a2ebba7601c4c87b', '38BFDE3B8BA4F59C7CBA5DDFEDFB916B', '2018-12-12 13:32:05', '2018-12-12 13:39:24', '无头像', '1', 'root', '13634676678', '21', '0', '广东广州', '21423432@qq.com', '总经理', '2', '1', '');
INSERT INTO `tb_user` VALUES ('8', 'user', '63856b59dd154d64a2ebba7601c4c87b', '38BFDE3B8BA4F59C7CBA5DDFEDFB916B', '2018-12-12 13:32:05', '2018-12-22 09:25:06', '1', '0', '张三', '13634478678', '22', '1', '魔都上海', '83684633@163.com', '董事长', '3', '2', '');
INSERT INTO `tb_user` VALUES ('9', 'demo1', 'a2ed5ff657424ca0afecca7513bc0394', '2CDA7AEF75BE823D4DCBFA1592F2F063', '2018-12-24 11:19:16', '2018-12-24 20:21:34', '1', '1', 'demo1', '11111111111', '23', '0', '1', '11111', '1', null, '1', null);
INSERT INTO `tb_user` VALUES ('10', 'test', '76d4c7d991ba428c8b740c37e87df0db', '46EF5EDDB1D7ACA1A62B9321CD94DD39', '2018-12-24 16:51:11', '2018-12-24 16:51:11', '1', '1', '12', '12345678900', '34', '0', '44', '55', '66', null, '1', null);
-- ----------------------------
-- Table structure for tb_user_role
-- ----------------------------
DROP TABLE IF EXISTS `tb_user_role`;
CREATE TABLE `tb_user_role` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '用户_角色id',
`userId` int(255) NOT NULL COMMENT '用户id',
`roleId` int(255) NOT NULL COMMENT '角色id',
PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
-- ----------------------------
-- Records of tb_user_role
-- ----------------------------
INSERT INTO `tb_user_role` VALUES ('1', '1', '1');
INSERT INTO `tb_user_role` VALUES ('2', '1', '2');
INSERT INTO `tb_user_role` VALUES ('3', '1', '3');
INSERT INTO `tb_user_role` VALUES ('4', '2', '2');
INSERT INTO `tb_user_role` VALUES ('5', '2', '3');
INSERT INTO `tb_user_role` VALUES ('6', '3', '2');
INSERT INTO `tb_user_role` VALUES ('9', '5', '1');
INSERT INTO `tb_user_role` VALUES ('10', '6', '2');
INSERT INTO `tb_user_role` VALUES ('12', '8', '2');
INSERT INTO `tb_user_role` VALUES ('13', '8', '3');
INSERT INTO `tb_user_role` VALUES ('14', '5', '2');
INSERT INTO `tb_user_role` VALUES ('15', '5', '3');
INSERT INTO `tb_user_role` VALUES ('16', '8', '3');
INSERT INTO `tb_user_role` VALUES ('17', '1', '2');
INSERT INTO `tb_user_role` VALUES ('18', '2', '3');
INSERT INTO `tb_user_role` VALUES ('22', '7', '3');
INSERT INTO `tb_user_role` VALUES ('23', '4', '2');
INSERT INTO `tb_user_role` VALUES ('24', '4', '3');
INSERT INTO `tb_user_role` VALUES ('34', '10', '1');
INSERT INTO `tb_user_role` VALUES ('35', '10', '2');
INSERT INTO `tb_user_role` VALUES ('38', '9', '4');