Skip to content

Commit 3daa826

Browse files
elunezelunez
committed
更新sql文件
1 parent 60ebdb1 commit 3daa826

1 file changed

Lines changed: 51 additions & 45 deletions

File tree

‎sql/eladmin.sql‎

Lines changed: 51 additions & 45 deletions
Original file line numberDiff line numberDiff line change
@@ -11,7 +11,7 @@
1111
Target Server Version : 50562
1212
File Encoding : 65001
1313
14-
Date: 31/10/2019 12:24:38
14+
Date: 08/11/2019 21:19:49
1515
*/
1616

1717
SET NAMES utf8mb4;
@@ -52,7 +52,7 @@ CREATE TABLE `dept` (
5252
`enabled` bit(1) NOT NULL,
5353
`create_time` datetime NULL DEFAULT NULL,
5454
PRIMARY KEY (`id`) USING BTREE
55-
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
55+
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
5656

5757
-- ----------------------------
5858
-- Records of dept
@@ -75,7 +75,7 @@ CREATE TABLE `dict` (
7575
`remark` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
7676
`create_time` datetime NULL DEFAULT NULL,
7777
PRIMARY KEY (`id`) USING BTREE
78-
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
78+
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
7979

8080
-- ----------------------------
8181
-- Records of dict
@@ -98,7 +98,7 @@ CREATE TABLE `dict_detail` (
9898
PRIMARY KEY (`id`) USING BTREE,
9999
INDEX `FK5tpkputc6d9nboxojdbgnpmyb`(`dict_id`) USING BTREE,
100100
CONSTRAINT `FK5tpkputc6d9nboxojdbgnpmyb` FOREIGN KEY (`dict_id`) REFERENCES `dict` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
101-
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
101+
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
102102

103103
-- ----------------------------
104104
-- Records of dict_detail
@@ -124,6 +124,11 @@ CREATE TABLE `email_config` (
124124
PRIMARY KEY (`id`) USING BTREE
125125
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
126126

127+
-- ----------------------------
128+
-- Records of email_config
129+
-- ----------------------------
130+
INSERT INTO `email_config` VALUES (1, '**', '**', '**', '465', 'eladmin');
131+
127132
-- ----------------------------
128133
-- Table structure for gen_config
129134
-- ----------------------------
@@ -143,7 +148,7 @@ CREATE TABLE `gen_config` (
143148
-- ----------------------------
144149
-- Records of gen_config
145150
-- ----------------------------
146-
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);
151+
INSERT INTO `gen_config` VALUES (1, 'Zheng Jie', b'0', 'eladmin-system', 'me.zhengjie.test', 'E:\\workspace\\me\\front\\eladmin-web\\src\\views\\test', 'E:\\workspace\\me\\front\\eladmin-web\\src\\api', NULL);
147152

148153
-- ----------------------------
149154
-- Table structure for job
@@ -159,7 +164,7 @@ CREATE TABLE `job` (
159164
PRIMARY KEY (`id`) USING BTREE,
160165
INDEX `FKmvhj0rogastlctflsxf1d6k3i`(`dept_id`) USING BTREE,
161166
CONSTRAINT `FKmvhj0rogastlctflsxf1d6k3i` FOREIGN KEY (`dept_id`) REFERENCES `dept` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
162-
) ENGINE = InnoDB AUTO_INCREMENT = 14 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
167+
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
163168

164169
-- ----------------------------
165170
-- Records of job
@@ -185,7 +190,7 @@ CREATE TABLE `local_storage` (
185190
`operate` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作人',
186191
`create_time` datetime NULL DEFAULT NULL COMMENT '创建日期',
187192
PRIMARY KEY (`id`) USING BTREE
188-
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
193+
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
189194

190195
-- ----------------------------
191196
-- Table structure for log
@@ -205,7 +210,7 @@ CREATE TABLE `log` (
205210
`address` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
206211
`browser` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
207212
PRIMARY KEY (`id`) USING BTREE
208-
) ENGINE = InnoDB AUTO_INCREMENT = 17040 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
213+
) ENGINE = InnoDB AUTO_INCREMENT = 17373 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
209214

210215
-- ----------------------------
211216
-- Table structure for menu
@@ -239,8 +244,8 @@ INSERT INTO `menu` VALUES (3, b'0', '角色管理', 'system/role/index', 1, 3, '
239244
INSERT INTO `menu` VALUES (5, b'0', '菜单管理', 'system/menu/index', 1, 5, 'menu', 'menu', b'0', b'0', 'Menu', '2018-12-18 15:17:28', 'menu:list', 1);
240245
INSERT INTO `menu` VALUES (6, b'0', '系统监控', NULL, 0, 10, 'monitor', 'monitor', b'0', b'0', NULL, '2018-12-18 15:17:48', NULL, 0);
241246
INSERT INTO `menu` VALUES (7, b'0', '操作日志', 'monitor/log/index', 6, 11, 'log', 'logs', b'0', b'0', 'Log', '2018-12-18 15:18:26', NULL, 1);
242-
INSERT INTO `menu` VALUES (8, b'0', '系统缓存', 'monitor/redis/index', 6, 13, 'redis', 'redis', b'0', b'0', 'Redis', '2018-12-18 15:19:01', 'redis:list', 1);
243-
INSERT INTO `menu` VALUES (9, b'0', 'SQL监控', 'monitor/sql/index', 6, 14, 'sqlMonitor', 'druid', b'0', b'0', 'Sql', '2018-12-18 15:19:34', NULL, 1);
247+
INSERT INTO `menu` VALUES (8, b'0', '系统缓存', 'monitor/redis/index', 6, 15, 'redis', 'redis', b'0', b'0', 'Redis', '2018-12-18 15:19:01', 'redis:list', 1);
248+
INSERT INTO `menu` VALUES (9, b'0', 'SQL监控', 'monitor/sql/index', 6, 18, 'sqlMonitor', 'druid', b'0', b'0', 'Sql', '2018-12-18 15:19:34', NULL, 1);
244249
INSERT INTO `menu` VALUES (10, b'0', '组件管理', NULL, 0, 50, 'zujian', 'components', b'0', b'0', NULL, '2018-12-19 13:38:16', NULL, 0);
245250
INSERT INTO `menu` VALUES (11, b'0', '图标库', 'components/IconSelect', 10, 51, 'icon', 'icon', b'0', b'0', 'Icons', '2018-12-19 13:38:49', NULL, 1);
246251
INSERT INTO `menu` VALUES (14, b'0', '邮件工具', 'tools/email/index', 36, 24, 'email', 'email', b'0', b'0', 'Email', '2018-12-27 10:13:09', NULL, 1);
@@ -291,7 +296,35 @@ INSERT INTO `menu` VALUES (75, b'0', '任务删除', '', 28, 4, '', '', b'0', b'
291296
INSERT INTO `menu` VALUES (77, b'0', '上传文件', '', 18, 2, '', '', b'0', b'0', '', '2019-10-29 13:09:09', 'storage:add', 2);
292297
INSERT INTO `menu` VALUES (78, b'0', '文件编辑', '', 18, 3, '', '', b'0', b'0', '', '2019-10-29 13:09:22', 'storage:edit', 2);
293298
INSERT INTO `menu` VALUES (79, b'0', '文件删除', '', 18, 4, '', '', b'0', b'0', '', '2019-10-29 13:09:34', 'storage:del', 2);
294-
INSERT INTO `menu` VALUES (81, b'0', '服务器监控', 'monitor/server/index', 6, 15, 'system', 'server', b'0', b'0', 'Server', '2019-11-01 16:37:41', 'server:list', 1);
299+
INSERT INTO `menu` VALUES (80, b'0', '服务监控', 'monitor/server/index', 6, 14, 'codeConsole', 'server', b'0', b'0', 'ServerMonitor', '2019-11-07 13:06:39', 'server:list', 1);
300+
301+
-- ----------------------------
302+
-- Table structure for monitor_server
303+
-- ----------------------------
304+
DROP TABLE IF EXISTS `monitor_server`;
305+
CREATE TABLE `monitor_server` (
306+
`id` int(11) NOT NULL AUTO_INCREMENT,
307+
`cpu_core` int(11) NULL DEFAULT NULL,
308+
`cpu_rate` double NULL DEFAULT NULL,
309+
`disk_total` double NULL DEFAULT NULL,
310+
`disk_used` double NULL DEFAULT NULL,
311+
`ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
312+
`mem_total` double NULL DEFAULT NULL,
313+
`mem_used` double NULL DEFAULT NULL,
314+
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
315+
`port` int(11) NULL DEFAULT NULL,
316+
`sort` int(11) NULL DEFAULT NULL,
317+
`state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
318+
`swap_total` double NULL DEFAULT NULL,
319+
`swap_used` double NULL DEFAULT NULL,
320+
PRIMARY KEY (`id`) USING BTREE
321+
) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
322+
323+
-- ----------------------------
324+
-- Records of monitor_server
325+
-- ----------------------------
326+
INSERT INTO `monitor_server` VALUES (1, NULL, NULL, NULL, NULL, 'localhost', NULL, NULL, '本地', 8777, 1, '0', NULL, NULL);
327+
295328
-- ----------------------------
296329
-- Table structure for picture
297330
-- ----------------------------
@@ -308,7 +341,7 @@ CREATE TABLE `picture` (
308341
`width` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '图片宽度',
309342
`md5code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
310343
PRIMARY KEY (`id`) USING BTREE
311-
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
344+
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
312345

313346
-- ----------------------------
314347
-- Table structure for qiniu_config
@@ -339,7 +372,7 @@ CREATE TABLE `qiniu_content` (
339372
`url` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '文件url',
340373
`suffix` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
341374
PRIMARY KEY (`id`) USING BTREE
342-
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
375+
) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
343376

344377
-- ----------------------------
345378
-- Table structure for quartz_job
@@ -381,7 +414,7 @@ CREATE TABLE `quartz_log` (
381414
`params` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
382415
`time` bigint(20) NULL DEFAULT NULL,
383416
PRIMARY KEY (`id`) USING BTREE
384-
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
417+
) ENGINE = InnoDB AUTO_INCREMENT = 269 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
385418

386419
-- ----------------------------
387420
-- Table structure for role
@@ -396,7 +429,7 @@ CREATE TABLE `role` (
396429
`create_time` datetime NULL DEFAULT NULL COMMENT '创建日期',
397430
`permission` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
398431
PRIMARY KEY (`id`) USING BTREE
399-
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
432+
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
400433

401434
-- ----------------------------
402435
-- Records of role
@@ -497,7 +530,7 @@ INSERT INTO `roles_menus` VALUES (75, 1);
497530
INSERT INTO `roles_menus` VALUES (77, 1);
498531
INSERT INTO `roles_menus` VALUES (78, 1);
499532
INSERT INTO `roles_menus` VALUES (79, 1);
500-
INSERT INTO `roles_menus` VALUES (81, 1);
533+
INSERT INTO `roles_menus` VALUES (80, 1);
501534
INSERT INTO `roles_menus` VALUES (1, 2);
502535
INSERT INTO `roles_menus` VALUES (2, 2);
503536
INSERT INTO `roles_menus` VALUES (3, 2);
@@ -556,7 +589,7 @@ CREATE TABLE `user` (
556589
CONSTRAINT `FK5rwmryny6jthaaxkogownknqp` FOREIGN KEY (`dept_id`) REFERENCES `dept` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
557590
CONSTRAINT `FKfftoc2abhot8f2wu6cl9a5iky` FOREIGN KEY (`job_id`) REFERENCES `job` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
558591
CONSTRAINT `FKpq2dhypk2qgt68nauh2by22jb` FOREIGN KEY (`avatar_id`) REFERENCES `user_avatar` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
559-
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
592+
) ENGINE = InnoDB AUTO_INCREMENT = 4 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
560593

561594
-- ----------------------------
562595
-- Records of user
@@ -624,33 +657,6 @@ CREATE TABLE `visits` (
624657
`week_day` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
625658
PRIMARY KEY (`id`) USING BTREE,
626659
UNIQUE INDEX `UK_11aksgq87euk9bcyeesfs4vtp`(`date`) USING BTREE
627-
) ENGINE = InnoDB AUTO_INCREMENT = 111 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
628-
629-
-- ----------------------------
630-
-- Records of visits
631-
-- ----------------------------
632-
INSERT INTO `visits` VALUES (108, '2019-10-29 21:45:49', '2019-10-29', 1, 1, 'Tue');
633-
INSERT INTO `visits` VALUES (109, '2019-10-30 08:58:54', '2019-10-30', 2, 11, 'Wed');
634-
INSERT INTO `visits` VALUES (110, '2019-10-31 09:04:18', '2019-10-31', 2, 8, 'Thu');
635-
636-
637-
DROP TABLE IF EXISTS `monitor_server`;
638-
CREATE TABLE `monitor_server` (
639-
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '编号',
640-
`name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
641-
`ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'IP地址',
642-
`port` int(11) NULL DEFAULT NULL COMMENT '访问端口',
643-
`state` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '状态',
644-
`cpu_rate` float NULL DEFAULT NULL COMMENT 'CPU使用率',
645-
`cpu_core` int(11) NULL DEFAULT NULL COMMENT 'CPU内核数',
646-
`mem_total` float NULL DEFAULT NULL COMMENT '内存总数',
647-
`mem_used` float NULL DEFAULT NULL COMMENT '内存使用量',
648-
`disk_total` float NULL DEFAULT NULL COMMENT '磁盘总量',
649-
`disk_used` float NULL DEFAULT NULL COMMENT '磁盘使用量',
650-
`swap_total` float NULL DEFAULT NULL COMMENT '交换区总量',
651-
`swap_used` float NULL DEFAULT NULL COMMENT '交换区使用量',
652-
`sort` int(11) NULL DEFAULT NULL COMMENT '排序',
653-
PRIMARY KEY (`id`) USING BTREE
654-
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '服务器监控' ROW_FORMAT = Dynamic;
660+
) ENGINE = InnoDB AUTO_INCREMENT = 118 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
655661

656662
SET FOREIGN_KEY_CHECKS = 1;

0 commit comments

Comments
 (0)