Dromara Orion Visor

Appearance

v2.4.1 ​

sql 脚本 - DML ​

sql
-- 合并 SSH 交互设置
UPDATE preference p1
JOIN (
    SELECT 
        t1.user_id,
        t1.type,
        JSON_MERGE_PATCH(
            COALESCE(t2.value, '{}'), 
            COALESCE(t1.value, '{}')
        ) AS merged_value
    FROM preference t1
    LEFT JOIN preference t2 
        ON t1.user_id = t2.user_id 
        AND t2.item = 'interactSetting'
    WHERE t1.item = 'sessionSetting'
) AS tmp 
ON p1.user_id = tmp.user_id AND p1.item = 'interactSetting'
SET p1.value = tmp.merged_value;
-- 删除 SSH 会话设置
DELETE FROM preference WHERE item = 'sessionSetting';
-- 更新 RDP 图形化设置
UPDATE preference SET value = JSON_SET(COALESCE(value, '{}'),'$.disableGfx', FALSE) WHERE item = 'rdpGraphSetting';
-- 添加 RDP 会话设置
INSERT INTO preference (user_id, type, item, VALUE, create_time, update_time, creator, updater, deleted) SELECT u.id, 'TERMINAL', 'rdpSessionSetting', '{"enableAudioInput":false,"enableAudioOutput":true,"driveMountMode":"ASSET"}', NOW(), NOW(), u.username, u.username, 0 FROM system_user u WHERE deleted = 0;
-- 更新 item
UPDATE preference SET item = 'sshInteractSetting' WHERE item = 'interactSetting';
UPDATE preference SET item = 'sshRightMenuSetting' WHERE item = 'rightMenuSetting';
UPDATE preference SET item = 'sshPluginsSetting' WHERE item = 'pluginsSetting';
UPDATE preference SET item = 'sshRightMenuSetting' WHERE item = 'rightMenuSetting';
UPDATE preference SET item = 'sshActionBarSetting' WHERE item = 'actionBarSetting';
UPDATE preference SET item = 'sshTheme' WHERE item = 'theme';
-- 修改操作日志
UPDATE operator_log SET module = 'terminal:terminal-file-log', type = 'terminal-file-log:delete' WHERE type = 'terminal:delete-sftp-log';	
-- 菜单
DELETE FROM `system_menu` WHERE id IN (148, 158, 159, 160, 194, 281);
INSERT INTO `system_menu` VALUES (148, 152, '连接日志', NULL, 2, 10, 1, 1, 1, 0, 'IconLink', NULL, 'terminalConnectLog', '2023-12-26 22:53:07', '2025-06-29 19:01:30', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (158, 152, '文件日志', NULL, 2, 40, 1, 1, 1, 0, 'IconFile', NULL, 'terminalFileLog', '2024-03-05 15:30:13', '2025-06-29 19:01:37', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (159, 158, '查询文件操作日志', 'terminal:terminal-file-log:management:query', 3, 10, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-05 15:31:02', '2025-06-29 12:19:25', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (160, 158, '删除文件操作日志', 'terminal:terminal-file-log:management:delete', 3, 20, 1, 1, 1, 0, NULL, NULL, NULL, '2024-03-05 15:31:17', '2025-06-29 12:19:30', 'admin', 'admin', 0);
INSERT INTO `system_menu` VALUES (194, 152, '在线会话', NULL, 2, 20, 1, 1, 1, 0, 'IconUserGroup', NULL, 'terminalConnectSession', '2024-05-07 11:12:17', '2025-06-29 19:01:34', 'admin', 'admin', 0);
-- 字典
DELETE FROM `dict_key` WHERE id = 76;
INSERT INTO `dict_key` VALUES (76, 'driveMountMode', 'STRING', '[{\"name\": \"help\", \"type\": \"STRING\"}]', '驱动挂载模式', '2025-06-28 22:53:20', '2025-06-28 22:53:20', 'admin', 'admin', 0);
DELETE FROM `dict_value` WHERE id IN (222, 223, 224, 225, 226, 227, 228, 229, 230, 231, 201, 202, 508, 509, 510, 511, 512, 513, 514, 515, 516, 517, 518, 519);
INSERT INTO `dict_value` VALUES (222, 2, 'operatorLogType', 'terminal-file-log:delete', '删除文件操作日志', '{}', 15, '2024-03-05 15:28:00', '2025-06-29 17:48:55', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (223, 33, 'terminalFileOperatorType', 'terminal:sftp-mkdir', '创建文件夹', '{}', 10, '2024-03-05 16:50:17', '2025-06-29 12:30:22', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (224, 33, 'terminalFileOperatorType', 'terminal:sftp-touch', '创建文件', '{}', 20, '2024-03-05 16:50:27', '2025-06-29 12:30:22', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (225, 33, 'terminalFileOperatorType', 'terminal:sftp-move', '移动文件', '{}', 30, '2024-03-05 16:50:41', '2025-06-29 12:30:22', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (226, 33, 'terminalFileOperatorType', 'terminal:sftp-remove', '删除文件', '{}', 40, '2024-03-05 16:50:53', '2025-06-29 12:30:22', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (227, 33, 'terminalFileOperatorType', 'terminal:sftp-truncate', '截断文件', '{}', 50, '2024-03-05 16:51:04', '2025-06-29 12:30:22', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (228, 33, 'terminalFileOperatorType', 'terminal:sftp-chmod', '文件提权', '{}', 60, '2024-03-05 16:51:15', '2025-06-29 12:30:22', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (229, 33, 'terminalFileOperatorType', 'terminal:sftp-set-content', '修改文件内容', '{}', 70, '2024-03-05 16:51:30', '2025-06-29 12:30:22', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (230, 33, 'terminalFileOperatorType', 'terminal:sftp-upload', '上传文件(SFTP)', '{}', 80, '2024-03-05 16:52:06', '2025-06-29 12:30:22', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (231, 33, 'terminalFileOperatorType', 'terminal:sftp-download', '下载文件(SFTP)', '{}', 90, '2024-03-05 16:52:18', '2025-06-29 12:30:22', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (201, 2, 'operatorLogType', 'terminal:sftp-upload', '上传文件(SFTP)', '{}', 90, '2024-02-23 17:54:52', '2025-06-29 12:29:51', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (202, 2, 'operatorLogType', 'terminal:sftp-download', '下载文件(SFTP)', '{}', 100, '2024-02-23 17:55:03', '2025-06-29 12:29:50', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (508, 76, 'driveMountMode', 'SHARED', '完全共享', '{\"help\": \"所有资产使用同一个挂载路径\"}', 10, '2025-06-28 22:54:32', '2025-06-28 23:08:19', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (509, 76, 'driveMountMode', 'SESSION', '会话维度', '{\"help\": \"每个会话使用独立的挂载路径\"}', 20, '2025-06-28 22:54:08', '2025-06-28 23:08:18', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (510, 76, 'driveMountMode', 'ASSET', '资产维度', '{\"help\": \"同一资产使用同一个挂载路径\"}', 30, '2025-06-28 22:55:12', '2025-06-28 22:55:12', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (511, 76, 'driveMountMode', 'DAY', '天维度', '{\"help\": \"同一天内使用同一个挂载路径\"}', 40, '2025-06-28 22:55:57', '2025-06-28 22:56:03', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (512, 76, 'driveMountMode', 'DAY_ASSET', '天+资产', '{\"help\": \"同一天内同一个资产使用同一个挂载路径\"}', 50, '2025-06-28 22:56:31', '2025-06-28 22:56:31', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (513, 76, 'driveMountMode', 'MONTH', '月维度', '{\"help\": \"同一月内使用同一个挂载路径\"}', 60, '2025-06-28 22:57:03', '2025-06-28 22:57:03', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (514, 76, 'driveMountMode', 'MONTH_ASSET', '月+资产', '{\"help\": \"同一月内同一个资产使用同一个挂载路径\"}', 70, '2025-06-28 22:57:29', '2025-06-28 22:57:29', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (515, 1, 'operatorLogModule', 'terminal:terminal-file-log', '文件操作日志', '{}', 2080, '2025-06-28 22:57:29', '2025-06-29 18:56:05', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (516, 2, 'operatorLogType', 'terminal:rdp-upload', '上传文件(RDP)', '{}', 110, '2024-02-23 17:54:52', '2024-10-15 15:54:47', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (517, 2, 'operatorLogType', 'terminal:rdp-download', '下载文件(RDP)', '{}', 120, '2024-02-23 17:55:03', '2024-10-15 15:54:47', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (518, 33, 'terminalFileOperatorType', 'terminal:rdp-upload', '上传文件(RDP)', '{}', 100, '2024-03-05 16:52:06', '2025-06-29 12:27:24', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (519, 33, 'terminalFileOperatorType', 'terminal:rdp-download', '下载文件(RDP)', '{}', 110, '2024-03-05 16:52:18', '2025-06-29 12:28:52', 'admin', 'admin', 0);

最后更新: