Dromara Orion Visor

Appearance

v2.4.0 ​

sql 脚本 - DDL ​

sql
-- 调整字段位置
ALTER TABLE `upload_task_file` 
MODIFY COLUMN `create_time` datetime(0) NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' AFTER `error_message`;

sql 脚本 - DML1 ​

sql
-- 修改终端偏好
UPDATE preference SET item = 'sshDisplaySetting' WHERE type = 'TERMINAL' AND item = 'displaySetting';
UPDATE preference SET item = 'sshActionBarSetting' WHERE type = 'TERMINAL' AND item = 'actionBarSetting';
-- 插入默认终端偏好 重新
INSERT INTO preference (user_id, type, item, VALUE, create_time, update_time, creator, updater, deleted) SELECT u.id, 'TERMINAL', 'rdpGraphSetting', '{"displayHeight":0,"enableTheming":true,"disableBitmapCaching":false,"enableDesktopComposition":true,"disableOffscreenCaching":false,"enableFullWindowDrag":true,"displaySize":"fit","forceLossless":true,"enableWallpaper":true,"enableAudioOutput":true,"enableMenuAnimations":false,"displayWidth":0,"enableFontSmoothing":true,"colorDepth":24,"disableGlyphCaching":false}', NOW(), NOW(), u.username, u.username, 0 FROM system_user u WHERE deleted = 0;
INSERT INTO preference (user_id, type, item, VALUE, create_time, update_time, creator, updater, deleted) SELECT u.id, 'TERMINAL', 'rdpActionBarSetting', '{"saveRdp":true,"disconnect":true,"upload":true,"display":true,"position":"top","combinationKey":true,"close":true,"clipboard":true}', NOW(), NOW(), u.username, u.username, 0 FROM system_user u WHERE deleted = 0;
-- 修改连接日志状态
UPDATE terminal_connect_log l SET status = 'COMPLETE', end_time = l.start_time WHERE status = 'CONNECTING';
-- 修改执行日志状态
UPDATE exec_log l SET status = 'COMPLETE', finish_time = l.start_time WHERE status IN ('WAITING', 'RUNNING');

sql 脚本 - DML2 - 修改权限标识符 ​

sql
-- exec 模块操作日志
UPDATE operator_log SET module = 'exec:upload-task' WHERE module = 'asset:upload-task';
UPDATE operator_log SET module = 'exec:exec-template' WHERE module = 'asset:exec-template';
UPDATE operator_log SET module = 'exec:exec-job' WHERE module = 'asset:exec-job';
UPDATE operator_log SET module = 'exec:exec-job-log' WHERE module = 'asset:exec-job-log';
UPDATE operator_log SET module = 'exec:exec-command' WHERE module = 'asset:exec-command';
UPDATE operator_log SET module = 'exec:exec-command-log' WHERE module = 'asset:exec-command-log';
-- terminal 模块操作日志
UPDATE operator_log SET module ='terminal:terminal' WHERE module = 'asset:terminal';
UPDATE operator_log SET module ='terminal:terminal-connect-log' WHERE module = 'asset:terminal-connect-log';

sql 脚本 - DML3 - 重新导入菜单/字典 ​

sql
-- 导入字典项
DELETE FROM `dict_key` WHERE id >= 66;
INSERT INTO `dict_key` VALUES (66, 'hostPasswordAuthType', 'STRING', '[]', '主机密码身份认证方式', '2025-03-31 20:04:01', '2025-03-31 20:05:05', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (67, 'hostExtraPasswordAuthType', 'STRING', '[]', '主机密码额外认证方式', '2025-03-31 20:05:30', '2025-03-31 20:05:30', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (68, 'graphColorDepth', 'INTEGER', '[]', '图形化色彩深度', '2025-06-19 00:49:57', '2025-06-19 00:49:57', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (69, 'screenResolution', 'STRING', '[{\"name\": \"width\", \"type\": \"INTEGER\"}, {\"name\": \"height\", \"type\": \"INTEGER\"}]', '屏幕分辨率', '2025-06-19 00:50:52', '2025-06-19 00:50:52', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (70, 'timezone', 'STRING', '[]', '时区', '2025-06-19 00:51:20', '2025-06-19 00:51:20', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (71, 'graphActionBarPosition', 'INTEGER', '[]', '图形操作栏位置', '2025-06-19 00:51:30', '2025-06-19 00:51:30', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (72, 'keyboardLayout', 'STRING', '[]', '键盘布局', '2025-06-19 01:03:17', '2025-06-19 01:03:17', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (73, 'clipboardNormalize', 'STRING', '[]', '剪切板标准', '2025-06-19 01:22:36', '2025-06-19 01:22:36', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (74, 'clipboardEncoding', 'STRING', '[]', '剪切板编码', '2025-06-19 01:22:44', '2025-06-19 01:22:44', 'admin', 'admin', 0);
INSERT INTO `dict_key` VALUES (75, 'vcnCursor', 'STRING', '[]', 'vnc光标', '2025-06-19 01:22:54', '2025-06-19 01:22:54', 'admin', 'admin', 0);

-- 导入字典值
DELETE FROM `dict_value` WHERE id IN (180, 215, 232, 236, 254, 262, 263, 289, 431);
DELETE FROM `dict_value` WHERE id >= 453;
INSERT INTO `dict_value` VALUES (180, 1, 'operatorLogModule', 'terminal:terminal', '主机终端', '{}', 2050, '2023-12-27 18:42:39', '2024-10-16 11:09:09', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (215, 1, 'operatorLogModule', 'terminal:terminal-connect-log', '终端连接日志', '{}', 2060, '2024-03-04 13:43:33', '2024-10-16 10:40:49', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (232, 1, 'operatorLogModule', 'exec:exec-template', '执行模板', '{}', 2070, '2024-03-07 18:32:41', '2024-10-14 10:46:50', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (236, 1, 'operatorLogModule', 'exec:exec-command', '批量执行', '{}', 2080, '2024-03-13 15:08:43', '2024-10-14 10:46:50', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (254, 1, 'operatorLogModule', 'exec:exec-job', '计划任务', '{}', 2090, '2024-04-10 16:18:07', '2024-10-14 10:46:50', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (262, 1, 'operatorLogModule', 'exec:exec-command-log', '批量执行日志', '{}', 2090, '2024-03-13 15:08:43', '2024-10-14 10:46:50', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (263, 1, 'operatorLogModule', 'exec:exec-job-log', '计划任务日志', '{}', 2100, '2024-04-10 16:18:07', '2024-10-14 10:46:50', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (289, 1, 'operatorLogModule', 'exec:upload-task', '批量上传', '{}', 2110, '2024-05-08 22:23:01', '2024-10-14 10:46:50', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (431, 61, 'updatePasswordReason', 'NEW', '为了保障账户安全，请立即修改初始密码。', '{}', 10, '2024-12-11 17:24:19', '2024-12-20 11:22:35', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (453, 58, 'hostType', 'RDP', 'RDP', '{\"color\": \"purple\"}', 20, '2025-03-31 20:02:57', '2025-03-31 20:02:57', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (454, 66, 'hostPasswordAuthType', 'PASSWORD', '密码认证', '{}', 10, '2025-03-31 20:08:09', '2025-03-31 20:08:09', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (455, 66, 'hostPasswordAuthType', 'IDENTITY', '身份认证', '{}', 20, '2025-03-31 20:08:22', '2025-03-31 20:40:54', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (456, 67, 'hostExtraPasswordAuthType', 'DEFAULT', '主机默认配置', '{}', 10, '2025-03-31 20:08:41', '2025-03-31 20:09:31', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (457, 67, 'hostExtraPasswordAuthType', 'CUSTOM_IDENTITY', '自定义身份', '{}', 20, '2025-03-31 20:10:39', '2025-03-31 20:11:13', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (458, 2, 'operatorLogType', 'host:update-spec', '修改主机规格', '{}', 60, '2025-04-06 12:02:13', '2025-04-06 12:02:13', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (459, 27, 'terminalConnectType', 'RDP', 'RDP', '{\"color\": \"purple\"}', 30, '2025-06-06 15:23:25', '2025-06-06 15:23:25', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (460, 68, 'graphColorDepth', '8', '低质量 (8bit)', '{}', 10, '2025-06-19 00:56:41', '2025-06-19 00:56:41', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (461, 68, 'graphColorDepth', '16', '中质量 (16bit)', '{}', 20, '2025-06-19 00:56:53', '2025-06-19 00:56:53', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (462, 68, 'graphColorDepth', '24', '高质量 (24bit)', '{}', 30, '2025-06-19 00:57:21', '2025-06-19 00:57:21', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (463, 69, 'screenResolution', '1920x1080', '1920x1080 (最佳平衡)', '{\"width\": 1920, \"height\": 1080}', 10, '2025-06-19 00:57:51', '2025-06-19 00:58:04', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (464, 69, 'screenResolution', '1600x900', '1600x900 (良好)', '{\"width\": 1600, \"height\": 900}', 20, '2025-06-19 00:58:25', '2025-06-19 00:59:24', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (465, 69, 'screenResolution', '1440x900', '1440x900 (良好)', '{\"width\": 1440, \"height\": 900}', 30, '2025-06-19 00:58:52', '2025-06-19 00:59:30', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (466, 69, 'screenResolution', '1366x768', '1366x768 (低带宽)', '{\"width\": 1366, \"height\": 768}', 40, '2025-06-19 00:59:48', '2025-06-22 00:48:45', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (467, 69, 'screenResolution', '1280x720', '1280x720 (低带宽)', '{\"width\": 1280, \"height\": 720}', 50, '2025-06-19 00:59:59', '2025-06-19 00:59:59', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (468, 69, 'screenResolution', '1024x768', '1024x768 (兼容性)', '{\"width\": 1024, \"height\": 768}', 60, '2025-06-19 01:00:10', '2025-06-19 01:00:10', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (469, 70, 'timezone', 'Asia/Shanghai', '中国上海', '{}', 10, '2025-06-19 01:00:27', '2025-06-19 01:00:27', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (470, 70, 'timezone', 'America/New_York', '美国东部', '{}', 20, '2025-06-19 01:00:40', '2025-06-19 01:00:40', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (471, 70, 'timezone', 'Europe/London', '英国伦敦', '{}', 30, '2025-06-19 01:00:52', '2025-06-19 01:00:52', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (472, 70, 'timezone', 'Europe/Berlin', '德国柏林', '{}', 40, '2025-06-19 01:01:00', '2025-06-19 01:01:00', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (473, 70, 'timezone', 'Australia/Sydney', '澳大利亚悉尼', '{}', 50, '2025-06-19 01:01:10', '2025-06-19 01:01:10', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (474, 70, 'timezone', 'Asia/Tokyo', '日本东京', '{}', 60, '2025-06-19 01:01:22', '2025-06-19 01:01:22', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (475, 70, 'timezone', 'Africa/Cairo', '埃及开罗', '{}', 70, '2025-06-19 01:01:32', '2025-06-19 01:01:32', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (476, 70, 'timezone', 'Pacific/Auckland', '新西兰奥克兰', '{}', 80, '2025-06-19 01:01:42', '2025-06-19 01:01:48', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (477, 70, 'timezone', 'America/Los_Angeles', '美国太平洋', '{}', 90, '2025-06-19 01:02:07', '2025-06-19 01:02:07', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (478, 70, 'timezone', 'Asia/Kolkata', '印度标准', '{}', 100, '2025-06-19 01:02:19', '2025-06-19 01:02:19', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (479, 68, 'graphColorDepth', '32', '超高质量 (32bit)', '{}', 40, '2025-06-19 01:11:00', '2025-06-19 01:11:00', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (480, 72, 'keyboardLayout', 'en-us-qwerty', 'English US (Qwerty)', '{}', 10, '2025-06-19 01:11:30', '2025-06-19 01:11:30', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (481, 72, 'keyboardLayout', 'en-gb-qwerty', 'English UK (Qwerty)', '{}', 20, '2025-06-19 01:11:42', '2025-06-19 01:11:42', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (482, 72, 'keyboardLayout', 'pt-br-qwerty', 'Brazilian Portuguese (Qwerty)', '{}', 30, '2025-06-19 01:11:53', '2025-06-19 01:11:53', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (483, 72, 'keyboardLayout', 'fr-fr-azerty', 'French (Azerty)', '{}', 40, '2025-06-19 01:12:09', '2025-06-19 01:12:09', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (484, 72, 'keyboardLayout', 'fr-be-azerty', 'French Belgian (Azerty)', '{}', 50, '2025-06-19 01:12:19', '2025-06-19 01:12:19', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (485, 72, 'keyboardLayout', 'fr-ch-qwertz', 'French Swiss (Qwertz)', '{}', 60, '2025-06-19 01:12:38', '2025-06-19 01:12:38', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (486, 72, 'keyboardLayout', 'de-de-qwertz', 'German (Qwertz)', '{}', 70, '2025-06-19 01:12:50', '2025-06-19 01:12:50', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (487, 72, 'keyboardLayout', 'de-ch-qwertz', 'German Swiss (Qwertz)', '{}', 80, '2025-06-19 01:13:00', '2025-06-19 01:13:00', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (488, 72, 'keyboardLayout', 'hu-hu-qwertz', 'Hungarian (Qwertz)', '{}', 90, '2025-06-19 01:13:11', '2025-06-19 01:13:11', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (489, 72, 'keyboardLayout', 'it-it-qwerty', 'Italian (Qwerty)', '{}', 100, '2025-06-19 01:13:21', '2025-06-19 01:13:21', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (490, 72, 'keyboardLayout', 'ja-jp-qwerty', 'Japanese (Qwerty)', '{}', 110, '2025-06-19 01:13:34', '2025-06-19 01:13:34', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (491, 72, 'keyboardLayout', 'no-no-qwerty', 'Norwegian (Qwerty)', '{}', 120, '2025-06-19 01:13:45', '2025-06-19 01:13:45', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (492, 72, 'keyboardLayout', 'es-es-qwerty', 'Spanish (Qwerty)', '{}', 130, '2025-06-19 01:13:54', '2025-06-19 01:13:54', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (493, 72, 'keyboardLayout', 'es-latam-qwerty', 'Spanish Latin American (Qwerty)', '{}', 140, '2025-06-19 01:14:08', '2025-06-19 01:14:08', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (494, 72, 'keyboardLayout', 'sv-se-qwerty', 'Swedish (Qwerty)', '{}', 150, '2025-06-19 01:14:19', '2025-06-19 01:14:19', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (495, 72, 'keyboardLayout', 'tr-tr-qwerty', 'Turkish Q (Qwerty)', '{}', 160, '2025-06-19 01:14:32', '2025-06-19 01:14:32', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (496, 73, 'clipboardNormalize', 'preserve', '保持原状', '{}', 10, '2025-06-19 01:23:21', '2025-06-19 01:23:21', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (497, 73, 'clipboardNormalize', 'unix', 'unix (LF)', '{}', 20, '2025-06-19 01:23:34', '2025-06-19 01:23:34', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (498, 73, 'clipboardNormalize', 'windows', 'windows (CRLF)', '{}', 30, '2025-06-19 01:23:43', '2025-06-19 01:23:43', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (499, 74, 'clipboardEncoding', 'UTF-8', 'UTF-8', '{}', 10, '2025-06-19 01:24:01', '2025-06-19 01:24:01', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (500, 74, 'clipboardEncoding', 'UTF-16', 'UTF-16', '{}', 20, '2025-06-19 01:24:05', '2025-06-19 01:24:05', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (501, 74, 'clipboardEncoding', 'ISO8859-1', 'ISO8859-1', '{}', 30, '2025-06-19 01:24:10', '2025-06-19 01:24:10', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (502, 74, 'clipboardEncoding', 'CP1252', 'CP1252', '{}', 40, '2025-06-19 01:24:14', '2025-06-19 01:24:14', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (503, 75, 'vcnCursor', 'local', '本地', '{}', 10, '2025-06-19 01:24:42', '2025-06-19 01:24:42', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (504, 75, 'vcnCursor', 'remote', '远程', '{}', 20, '2025-06-19 01:24:48', '2025-06-19 01:24:48', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (505, 69, 'screenResolution', 'fit', '自适应', '{\"width\": 0, \"height\": 0}', 5, '2025-06-21 22:51:30', '2025-06-21 22:51:30', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (506, 71, 'graphActionBarPosition', 'top', '顶端(推荐)', '{}', 10, '2025-06-22 20:38:01', '2025-06-22 20:38:01', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (507, 71, 'graphActionBarPosition', 'right', '右侧', '{}', 20, '2025-06-22 20:38:10', '2025-06-22 20:38:10', 'admin', 'admin', 0);

-- 导入菜单
DELETE FROM `system_menu` WHERE id >= 144;
INSERT INTO `system_menu` VALUES (144, 63, '资产授权', NULL, 2, 60, 1, 1, 1, 0, 'icon-safe', NULL, 'assetGrant', '2023-11-30 22:38:57', '2024-07-03 18:52:18', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (145, 0, '主机运维', NULL, 1, 400, 1, 1, 1, 1, 'IconDesktop', NULL, 'terminalModule', '2023-12-04 23:33:25', '2024-10-21 14:49:52', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (146, 145, '主机终端', NULL, 2, 10, 1, 1, 1, 1, 'icon-code-square', NULL, 'terminal', '2023-12-04 23:38:01', '2024-10-21 14:54:11', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (148, 152, '连接日志', NULL, 2, 10, 1, 1, 1, 0, 'IconLink', NULL, 'connectLog', '2023-12-26 22:53:07', '2024-03-07 19:09:59', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (149, 148, '查询连接日志', 'terminal:terminal-connect-log:management:query', 3, 10, 1, 1, 1, 0, NULL, NULL, NULL, '2023-12-26 22:53:08', '2024-10-16 10:41:08', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (151, 146, '连接终端', 'terminal:terminal:access', 3, 10, 1, 1, 1, 0, NULL, NULL, NULL, '2023-12-27 18:56:33', '2024-10-16 10:41:08', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (152, 0, '运维审计', NULL, 1, 410, 1, 1, 1, 0, 'IconSafe', NULL, 'assetAuditModule', '2024-01-04 17:54:56', '2024-04-28 15:30:04', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (153, 148, '删除连接日志', 'terminal:terminal-connect-log:management:delete', 3, 20, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-04 13:39:46', '2024-10-16 10:41:08', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (154, 148, '清空连接日志', 'terminal:terminal-connect-log:management:clear', 3, 30, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-04 13:40:05', '2024-10-16 10:41:08', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (155, 148, '强制断开连接', 'terminal:terminal-connect-log:management:force-offline', 3, 40, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-04 13:41:02', '2024-10-16 10:41:08', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (156, 122, '删除操作日志', 'infra:operator-log:delete', 3, 20, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-04 17:06:55', '2024-03-04 17:08:22', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (157, 122, '清空操作日志', 'infra:operator-log:management:clear', 3, 30, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-04 17:07:25', '2024-04-11 11:16:17', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (158, 152, '文件操作日志', NULL, 2, 40, 1, 1, 1, 0, 'IconFile', NULL, 'sftpLog', '2024-03-05 15:30:13', '2024-08-04 20:23:19', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (159, 158, '查询文件操作日志', 'terminal:terminal-sftp-log:management:query', 3, 10, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-05 15:31:02', '2024-10-16 16:23:52', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (160, 158, '删除文件操作日志', 'terminal:terminal-sftp-log:management:delete', 3, 20, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-05 15:31:17', '2024-10-16 16:23:52', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (161, 176, '执行模板', NULL, 2, 80, 1, 1, 1, 0, 'IconBookmark', NULL, 'execTemplate', '2024-03-07 18:32:41', '2024-12-12 23:31:06', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (162, 161, '查询执行模板', 'exec:exec-template:query', 3, 10, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-07 18:32:41', '2024-10-14 10:36:36', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (163, 161, '创建执行模板', 'exec:exec-template:create', 3, 20, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-07 18:32:41', '2024-10-14 10:36:36', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (164, 161, '修改执行模板', 'exec:exec-template:update', 3, 30, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-07 18:32:41', '2024-10-14 10:36:36', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (165, 161, '删除执行模板', 'exec:exec-template:delete', 3, 40, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-07 18:32:41', '2024-10-14 10:36:36', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (167, 176, '执行日志', NULL, 2, 20, 1, 1, 1, 0, 'IconFindReplace', NULL, 'execCommandLog', '2024-03-13 15:08:23', '2024-12-12 23:35:30', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (168, 167, '查询执行日志', 'exec:exec-command-log:query', 3, 10, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-13 15:08:23', '2024-10-14 10:33:02', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (169, 167, '删除执行日志', 'exec:exec-command-log:delete', 3, 20, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-13 15:08:23', '2024-10-14 10:33:02', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (171, 167, '清理执行日志', 'exec:exec-command-log:management:clear', 3, 30, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-13 15:08:23', '2024-10-14 10:33:02', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (172, 176, '命令执行', NULL, 2, 10, 1, 1, 1, 0, 'icon-thunderbolt', NULL, 'execCommand', '2024-03-13 15:08:23', '2024-05-08 21:58:24', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (173, 172, '执行命令', 'exec:exec-command:exec', 3, 10, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-13 15:08:23', '2024-10-14 10:36:36', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (174, 167, '中断批量执行', 'exec:exec-command-log:interrupt', 3, 40, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-13 15:25:36', '2024-10-14 10:33:02', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (176, 0, '批量执行', NULL, 1, 420, 1, 1, 1, 0, 'icon-relation', NULL, 'execModule', '2024-04-10 16:13:27', '2024-04-28 15:30:31', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (177, 176, '任务列表', NULL, 2, 30, 1, 1, 1, 0, 'IconUnorderedList', NULL, 'execJob', '2024-04-10 16:13:27', '2024-12-12 23:34:35', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (178, 177, '查询计划任务', 'exec:exec-job:query', 3, 10, 1, 1, 1, 0, NULL, NULL, NULL, '2024-04-10 16:13:27', '2024-10-14 10:36:36', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (179, 177, '创建计划任务', 'exec:exec-job:create', 3, 20, 1, 1, 1, 0, NULL, NULL, NULL, '2024-04-10 16:13:27', '2024-10-14 10:36:36', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (180, 177, '修改计划任务', 'exec:exec-job:update', 3, 30, 1, 1, 1, 0, NULL, NULL, NULL, '2024-04-10 16:13:27', '2024-10-14 10:36:36', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (181, 177, '修改任务状态', 'exec:exec-job:update-status', 3, 40, 1, 1, 1, 0, NULL, NULL, NULL, '2024-04-10 16:13:27', '2024-10-14 10:36:36', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (182, 177, '删除计划任务', 'exec:exec-job:delete', 3, 50, 1, 1, 1, 0, NULL, NULL, NULL, '2024-04-10 16:13:27', '2024-10-14 10:36:36', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (183, 177, '手动执行任务', 'exec:exec-job:trigger', 3, 60, 1, 1, 1, 0, NULL, NULL, NULL, '2024-04-10 16:13:27', '2024-10-14 10:36:36', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (184, 176, '任务日志', NULL, 2, 40, 1, 1, 1, 0, 'icon-history', '', 'execJobLog', '2024-04-11 13:40:47', '2024-12-12 23:34:45', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (185, 176, '计划任务日志', NULL, 2, 50, 0, 1, 0, 1, NULL, NULL, 'execJobLogView', '2024-04-11 13:41:47', '2024-12-12 23:34:55', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (186, 184, '查询任务日志', 'exec:exec-job-log:query', 3, 10, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-13 15:08:23', '2024-10-14 10:36:36', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (187, 184, '删除任务日志', 'exec:exec-job-log:delete', 3, 20, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-13 15:08:23', '2024-10-14 10:36:36', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (189, 184, '清理任务日志', 'exec:exec-job-log:management:clear', 3, 30, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-13 15:08:23', '2024-10-14 10:36:36', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (190, 184, '中断计划任务', 'exec:exec-job-log:interrupt', 3, 40, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-13 15:08:23', '2024-10-14 10:36:36', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (194, 152, '在线会话', NULL, 2, 20, 1, 1, 1, 0, 'IconUserGroup', NULL, 'connectSession', '2024-05-07 11:12:17', '2024-05-07 11:12:35', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (195, 194, '查询在线会话', 'terminal:terminal-connect-session:management:query', 3, 10, 1, 1, 1, 0, NULL, NULL, NULL, '2024-05-07 11:13:16', '2024-10-16 10:41:08', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (196, 194, '强制断开连接', 'terminal:terminal-connect-session:management:force-offline', 3, 20, 1, 1, 1, 0, NULL, NULL, NULL, '2024-05-07 11:13:37', '2024-10-16 10:41:08', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (197, 176, '批量上传', NULL, 2, 60, 1, 1, 1, 0, 'IconUpload', NULL, 'batchUpload', '2024-05-08 22:12:23', '2024-12-12 23:34:11', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (198, 176, '上传任务', NULL, 2, 70, 1, 1, 1, 0, 'IconCloud', NULL, 'uploadTask', '2024-05-08 22:16:05', '2024-12-12 23:34:19', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (199, 197, '上传文件', 'exec:upload-task:upload', 3, 10, 1, 1, 1, 0, NULL, NULL, NULL, '2024-05-08 22:19:35', '2024-10-14 10:36:36', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (200, 198, '查询上传日志', 'exec:upload-task:query', 3, 10, 1, 1, 1, 0, NULL, NULL, NULL, '2024-05-08 22:20:01', '2024-10-14 10:36:36', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (201, 198, '删除上传日志', 'exec:upload-task:delete', 3, 20, 1, 1, 1, 0, NULL, NULL, NULL, '2024-05-08 22:20:26', '2024-10-14 10:36:36', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (202, 198, '清理上传日志', 'exec:upload-task:management:clear', 3, 30, 1, 1, 1, 0, NULL, NULL, NULL, '2024-05-08 22:20:37', '2024-10-14 10:36:36', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (203, 12, '系统设置', NULL, 2, 40, 1, 1, 1, 0, 'IconSettings', NULL, 'systemSetting', '2024-06-17 20:46:15', '2024-06-17 20:46:15', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (265, 203, '更新系统设置', 'infra:system-setting:update', 3, 20, 1, 1, 1, 0, NULL, NULL, NULL, '2024-10-09 19:25:28', '2025-01-02 22:14:45', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (271, 177, '修改任务执行用户', 'exec:exec-job:update-exec-user', 3, 45, 1, 1, 1, 0, NULL, NULL, NULL, '2024-12-13 00:18:13', '2024-12-13 00:18:13', 'admin', 'admin', 0);

最后更新: