11
11
Target Server Version : 50562
12
12
File Encoding : 65001
13
13
14
- Date: 07 /09/2019 21:59:47
14
+ Date: 26 /09/2019 17:41:39
15
15
*/
16
16
17
17
SET NAMES utf8mb4;
@@ -85,7 +85,6 @@ CREATE TABLE `dict` (
85
85
INSERT INTO ` dict` VALUES (1 , ' user_status' , ' 用户状态' );
86
86
INSERT INTO ` dict` VALUES (4 , ' dept_status' , ' 部门状态' );
87
87
INSERT INTO ` dict` VALUES (5 , ' job_status' , ' 岗位状态' );
88
- INSERT INTO ` dict` VALUES (6 , ' tt' , ' tt' );
89
88
90
89
-- ----------------------------
91
90
-- Table structure for dict_detail
@@ -111,7 +110,6 @@ INSERT INTO `dict_detail` VALUES (11, '正常', 'true', '1', 4);
111
110
INSERT INTO ` dict_detail` VALUES (12 , ' 停用' , ' false' , ' 2' , 4 );
112
111
INSERT INTO ` dict_detail` VALUES (13 , ' 正常' , ' true' , ' 1' , 5 );
113
112
INSERT INTO ` dict_detail` VALUES (14 , ' 停用' , ' false' , ' 2' , 5 );
114
- INSERT INTO ` dict_detail` VALUES (15 , ' f' , ' fdaf' , ' 1' , 6 );
115
113
116
114
-- ----------------------------
117
115
-- Table structure for email_config
@@ -146,7 +144,7 @@ CREATE TABLE `gen_config` (
146
144
-- ----------------------------
147
145
-- Records of gen_config
148
146
-- ----------------------------
149
- INSERT INTO ` gen_config` VALUES (1 , ' Zheng Jie' , b' 0' , ' eladmin-tools ' , ' me.zhengjie' , ' E:\\ workspace\\ me\\ front\\ eladmin-qt\\ src\\ views\\ tools \\ storage \\ local ' , ' E:\\ workspace\\ me\\ front\\ eladmin-qt\\ src\\ api' , NULL );
147
+ INSERT INTO ` gen_config` VALUES (1 , ' Zheng Jie' , b' 0' , ' eladmin-system ' , ' me.zhengjie.test ' , ' E:\\ workspace\\ me\\ front\\ eladmin-qt\\ src\\ views\\ test1111 ' , ' E:\\ workspace\\ me\\ front\\ eladmin-qt\\ src\\ api' , NULL );
150
148
151
149
-- ----------------------------
152
150
-- Table structure for job
@@ -209,7 +207,7 @@ CREATE TABLE `log` (
209
207
` username` varchar (255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
210
208
` address` varchar (255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
211
209
PRIMARY KEY (` id` ) USING BTREE
212
- ) ENGINE = InnoDB AUTO_INCREMENT = 13914 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
210
+ ) ENGINE = InnoDB AUTO_INCREMENT = 14269 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
213
211
214
212
-- ----------------------------
215
213
-- Table structure for menu
@@ -279,7 +277,7 @@ CREATE TABLE `permission` (
279
277
` name` varchar (255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' 名称' ,
280
278
` pid` int (11 ) NOT NULL COMMENT ' 上级权限' ,
281
279
PRIMARY KEY (` id` ) USING BTREE
282
- ) ENGINE = InnoDB AUTO_INCREMENT = 55 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
280
+ ) ENGINE = InnoDB AUTO_INCREMENT = 60 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
283
281
284
282
-- ----------------------------
285
283
-- Records of permission
@@ -332,6 +330,11 @@ INSERT INTO `permission` VALUES (51, '字典查询', '2019-04-10 16:25:16', 'DIC
332
330
INSERT INTO ` permission` VALUES (52 , ' 字典创建' , ' 2019-04-10 16:25:29' , ' DICT_CREATE' , 50 );
333
331
INSERT INTO ` permission` VALUES (53 , ' 字典编辑' , ' 2019-04-10 16:27:19' , ' DICT_EDIT' , 50 );
334
332
INSERT INTO ` permission` VALUES (54 , ' 字典删除' , ' 2019-04-10 16:27:30' , ' DICT_DELETE' , 50 );
333
+ INSERT INTO ` permission` VALUES (55 , ' 文件管理' , ' 2019-09-08 12:31:54' , ' LOCALSTORAGE_ALL' , 0 );
334
+ INSERT INTO ` permission` VALUES (56 , ' 文件搜索' , ' 2019-09-08 12:40:53' , ' LOCALSTORAGE_SELECT' , 55 );
335
+ INSERT INTO ` permission` VALUES (57 , ' 文件上传' , ' 2019-09-08 12:41:05' , ' LOCALSTORAGE_CREATE' , 55 );
336
+ INSERT INTO ` permission` VALUES (58 , ' 文件编辑' , ' 2019-09-08 12:41:19' , ' LOCALSTORAGE_EDIT' , 55 );
337
+ INSERT INTO ` permission` VALUES (59 , ' 文件删除' , ' 2019-09-08 12:41:29' , ' LOCALSTORAGE_DELETE' , 55 );
335
338
336
339
-- ----------------------------
337
340
-- Table structure for picture
@@ -348,7 +351,7 @@ CREATE TABLE `picture` (
348
351
` username` varchar (255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' 用户名称' ,
349
352
` width` varchar (255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' 图片宽度' ,
350
353
PRIMARY KEY (` id` ) USING BTREE
351
- ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
354
+ ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
352
355
353
356
-- ----------------------------
354
357
-- Table structure for qiniu_config
@@ -373,13 +376,13 @@ CREATE TABLE `qiniu_content` (
373
376
` id` bigint (20 ) NOT NULL AUTO_INCREMENT COMMENT ' ID' ,
374
377
` bucket` varchar (255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' Bucket 识别符' ,
375
378
` name` varchar (255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' 文件名称' ,
376
- ` suffix` varchar (255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' 文件后缀' ,
377
379
` size` varchar (255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' 文件大小' ,
378
380
` type` varchar (255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' 文件类型:私有或公开' ,
379
381
` update_time` datetime NULL DEFAULT NULL COMMENT ' 上传或同步的时间' ,
380
382
` url` varchar (255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT ' 文件url' ,
383
+ ` suffix` varchar (255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
381
384
PRIMARY KEY (` id` ) USING BTREE
382
- ) ENGINE = InnoDB AUTO_INCREMENT = 20 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
385
+ ) ENGINE = InnoDB AUTO_INCREMENT = 24 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
383
386
384
387
-- ----------------------------
385
388
-- Table structure for quartz_job
@@ -403,7 +406,7 @@ CREATE TABLE `quartz_job` (
403
406
-- ----------------------------
404
407
INSERT INTO ` quartz_job` VALUES (1 , ' visitsTask' , ' 0 0 0 * * ?' , b' 0' , ' 更新访客记录' , ' run' , NULL , ' 每日0点创建新的访客记录' , ' 2019-01-08 14:53:31' );
405
408
INSERT INTO ` quartz_job` VALUES (2 , ' testTask' , ' 0/5 * * * * ?' , b' 1' , ' 测试1' , ' run1' , ' test' , ' 带参测试,多参使用json' , ' 2019-08-22 14:08:29' );
406
- INSERT INTO ` quartz_job` VALUES (3 , ' testTask' , ' 0/5 * * * * ?' , b' 1' , ' 测试' , ' run' , ' ' , ' 不带参测试' , ' 2019-08-22 14:08:28 ' );
409
+ INSERT INTO ` quartz_job` VALUES (3 , ' testTask' , ' 0/5 * * * * ?' , b' 1' , ' 测试' , ' run' , ' ' , ' 不带参测试' , ' 2019-09-26 16:44:39 ' );
407
410
408
411
-- ----------------------------
409
412
-- Table structure for quartz_log
@@ -421,7 +424,7 @@ CREATE TABLE `quartz_log` (
421
424
` params` varchar (255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
422
425
` time` bigint (20 ) NULL DEFAULT NULL ,
423
426
PRIMARY KEY (` id` ) USING BTREE
424
- ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
427
+ ) ENGINE = InnoDB AUTO_INCREMENT = 51 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
425
428
426
429
-- ----------------------------
427
430
-- Table structure for role
@@ -675,6 +678,6 @@ CREATE TABLE `visits` (
675
678
` week_day` varchar (255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL ,
676
679
PRIMARY KEY (` id` ) USING BTREE,
677
680
UNIQUE INDEX ` UK_11aksgq87euk9bcyeesfs4vtp` (` date` ) USING BTREE
678
- ) ENGINE = InnoDB AUTO_INCREMENT = 89 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
681
+ ) ENGINE = InnoDB AUTO_INCREMENT = 96 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
679
682
680
683
SET FOREIGN_KEY_CHECKS = 1 ;
0 commit comments