v2.4.2
sql 脚本 - DML
sql
-- 添加 vnc 偏好设置
INSERT INTO preference (user_id, type, item, VALUE, create_time, update_time, creator, updater, deleted) SELECT u.id, 'TERMINAL', 'vncGraphSetting', '{"cursor":"local","displayHeight":0,"displayWidth":0,"colorDepth":24,"qualityLevel":5,"forceLossless":true,"displaySize":"fit","compressLevel":5}', 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', 'vncActionBarSetting', '{"disconnect":true,"display":true,"position":"right","combinationKey":true,"close":true,"clipboard":true,"reconnect":false,"triggerKey":false,"info":true,"sftpUpload":true,"openSftp":true}', NOW(), NOW(), u.username, u.username, 0 FROM system_user u WHERE deleted = 0;
-- 修改 ssh 偏好设置
UPDATE `preference` SET `value` = JSON_SET(`value`, '$.replaceBackspace', false) WHERE `item` = 'sshInteractSetting';
-- 修改 rdp 偏好设置
UPDATE preference SET value = '{"saveRdp":false,"disconnect":true,"upload":true,"display":true,"position":"right","combinationKey":true,"close":true,"clipboard":true,"triggerKey":false,"sftpUpload":false,"reconnect":false,"openSftp":false,"rdpUpload":true,"info":true}' WHERE item = 'rdpActionBarSetting';
-- 字典值
DELETE FROM `dict_value` WHERE id IN (463, 464, 465, 466, 467, 468, 520, 521);
INSERT INTO `dict_value` VALUES (463, 69, 'screenResolution', '1920x1080', '1920x1080', '{\"width\": 1920, \"height\": 1080}', 10, '2025-06-19 00:57:51', '2025-07-03 02:36:09', '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-07-03 02:36:05', '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-07-03 02:36:01', '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-07-03 02:35:58', '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-07-03 02:35:54', '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-07-03 02:35:50', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (520, 58, 'hostType', 'VNC', 'VNC', '{\"color\": \"pinkpurple\"}', 30, '2025-07-01 16:02:01', '2025-07-03 00:56:56', 'admin', 'admin', 0);
INSERT INTO `dict_value` VALUES (521, 27, 'terminalConnectType', 'VNC', 'VNC', '{\"color\": \"pinkpurple\"}', 40, '2025-07-01 16:02:21', '2025-07-03 00:56:54', 'admin', 'admin', 0);