Dromara Orion Visor

Appearance

v2.3.1 ​

sql 脚本 - DDL ​

sql
-- 修改系统设置表结构
ALTER TABLE `system_setting` 
DROP COLUMN `item`,
MODIFY COLUMN `config_key` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '配置key' AFTER `type`,
DROP INDEX `type_item_idx`,
RENAME INDEX `key_idx` TO `idx_key`;
-- 修改用户表
ALTER TABLE `system_user` 
ADD COLUMN `update_password_time` datetime(0) NULL COMMENT '修改密码时间' AFTER `update_password_reason`;
-- 修改主机连接记录的 sessionId
ALTER TABLE `terminal_connect_log`
CHANGE COLUMN `token` `session_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT 'sessionId' AFTER `status`,
RENAME INDEX `idx_token` TO `idx_session_id`;

sql 脚本 - DML ​

sql
-- 重新导入系统设置
DELETE FROM system_setting;
INSERT INTO `system_setting` VALUES (6, 'sftp', 'sftp_previewSize', '2', '2025-02-10 22:19:46', '2025-02-10 22:19:46', '1', '1', 0);
INSERT INTO `system_setting` VALUES (7, 'sftp', 'sftp_uploadPresentBackup', 'true', '2025-02-10 22:19:46', '2025-02-10 22:19:46', '1', '1', 0);
INSERT INTO `system_setting` VALUES (8, 'sftp', 'sftp_uploadBackupFileName', 'bk_${fileName}_${timestamp}', '2025-02-10 22:19:46', '2025-02-10 22:19:46', '1', '1', 0);
INSERT INTO `system_setting` VALUES (9, 'login', 'login_loginSessionTime', '1440', '2025-02-10 22:20:59', '2025-02-10 22:20:59', '1', '1', 0);
INSERT INTO `system_setting` VALUES (10, 'login', 'login_maxRefreshCount', '3', '2025-02-10 22:20:59', '2025-02-10 22:20:59', '1', '1', 0);
INSERT INTO `system_setting` VALUES (11, 'login', 'login_refreshInterval', '480', '2025-02-10 22:20:59', '2025-02-10 22:20:59', '1', '1', 0);
INSERT INTO `system_setting` VALUES (12, 'login', 'login_loginFailedLockThreshold', '5', '2025-02-10 22:20:59', '2025-02-10 22:20:59', '1', '1', 0);
INSERT INTO `system_setting` VALUES (13, 'login', 'login_loginFailedLockTime', '30', '2025-02-10 22:20:59', '2025-02-10 22:20:59', '1', '1', 0);
INSERT INTO `system_setting` VALUES (14, 'login', 'login_loginFailedSendThreshold', '5', '2025-02-10 22:20:59', '2025-02-10 22:20:59', '1', '1', 0);
INSERT INTO `system_setting` VALUES (15, 'login', 'login_allowMultiDevice', 'true', '2025-02-10 22:20:59', '2025-02-10 22:20:59', '1', '1', 0);
INSERT INTO `system_setting` VALUES (16, 'login', 'login_allowRefresh', 'true', '2025-02-10 22:20:59', '2025-02-10 22:20:59', '1', '1', 0);
INSERT INTO `system_setting` VALUES (17, 'login', 'login_loginFailedLock', 'true', '2025-02-10 22:20:59', '2025-02-10 22:20:59', '1', '1', 0);
INSERT INTO `system_setting` VALUES (18, 'login', 'login_loginFailedSend', 'true', '2025-02-10 22:20:59', '2025-02-10 22:20:59', '1', '1', 0);
INSERT INTO `system_setting` VALUES (21, 'encrypt', 'encrypt_publicKey', 'MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQC6++dxyeNdij6ZfM2I9ojLQ1tzmqyuL3rkectm9uXJsXOFiN0aFi4glsoGVZO5hMH5/pppdSQnYz3rSV9b0qjFTRMv5u1BHHzuzoOkI43WqXCX96f8diHIZsEu9fZ+AkxVck/kDPfmR2dVjwo8ZBuJ7drsP8fDbs8N3vtEwPSotwIDAQAB', '2025-02-10 22:21:11', '2025-02-10 22:21:11', '1', '1', 0);
INSERT INTO `system_setting` VALUES (22, 'encrypt', 'encrypt_privateKey', 'MIICdwIBADANBgkqhkiG9w0BAQEFAASCAmEwggJdAgEAAoGBALr753HJ412KPpl8zYj2iMtDW3OarK4veuR5y2b25cmxc4WI3RoWLiCWygZVk7mEwfn+mml1JCdjPetJX1vSqMVNEy/m7UEcfO7Og6QjjdapcJf3p/x2IchmwS719n4CTFVyT+QM9+ZHZ1WPCjxkG4nt2uw/x8Nuzw3e+0TA9Ki3AgMBAAECgYA+sD3ENH952ONr6h+uj5kFLKv4ch76twhomTzMZHJd0JR+bIhUOqN0YZmRzhcc15mBCw8R1Cgu3GLiA1NpIZNbH6ujsGzwOGn9E+1TIgRAfgOV1JmMIJ4sVa2zb5+seZ4TkU2MfpKjToa/cX1kovoiNR8gPV+HCE8HUBXgOziF4QJBAOf2LGTjjKSag8WBQjgy2OCi6l0260jGSCGBJYCG884feeH/msTbTdvo44iYyd3P9txxBmmnpdJLvPgJWCu01q0CQQDOXH8yPkSCBL+ZvFizBHayhoO0FN/YFyrYf1wewt43mCDHbx4fzwXtc2CLrSt+nqgwTA4M73Sf2DAOW9pk9T1zAkBIT1d7g+v+DCTz1t2bw04UiPTiZhJmt1kZCLd2H5u1L97A8vt+Tpcw7KKxnF+hhAkCo0FKgnaQ3gdkkxUnWtJpAkEAoA4v/bk8C5hBP61NIrRQmBEq767NG16Etdy6h4VfM8GDkwvFUqiQkWZOuKc8t/24t5UVxMSpMR1N0KU/k9R+rwJBALjw7SzSeqWV2VLUZVqtWPu9nZvX79SWZWMp0gtmYYgzKa1dttzdJsXY5i/cfKH6RO2hwicO1rVBpiZ5zMggljo=', '2025-02-10 22:21:11', '2025-02-10 22:21:11', '1', '1', 0);
INSERT INTO `system_setting` VALUES (23, 'log', 'log_webScrollLines', '1500', '2025-02-10 22:21:54', '2025-02-10 22:21:54', '1', '1', 0);
INSERT INTO `system_setting` VALUES (24, 'log', 'log_trackerLoadInterval', '100', '2025-02-10 22:21:54', '2025-02-10 22:21:54', '1', '1', 0);
INSERT INTO `system_setting` VALUES (25, 'log', 'log_trackerLoadLines', '300', '2025-02-10 22:21:54', '2025-02-10 22:21:54', '1', '1', 0);
INSERT INTO `system_setting` VALUES (26, 'log', 'log_execDetailLog', 'true', '2025-02-10 22:21:54', '2025-02-10 22:21:54', '1', '1', 0);
INSERT INTO `system_setting` VALUES (27, 'autoClear', 'autoClear_execLogKeepDays', '30', '2025-02-10 22:22:00', '2025-02-10 22:22:00', '1', '1', 0);
INSERT INTO `system_setting` VALUES (28, 'autoClear', 'autoClear_terminalLogKeepDays', '30', '2025-02-10 22:22:00', '2025-02-10 22:22:00', '1', '1', 0);
INSERT INTO `system_setting` VALUES (29, 'autoClear', 'autoClear_execLogEnabled', 'true', '2025-02-10 22:22:00', '2025-02-10 22:22:00', '1', '1', 0);
INSERT INTO `system_setting` VALUES (30, 'autoClear', 'autoClear_terminalLogEnabled', 'true', '2025-02-10 22:22:00', '2025-02-10 22:22:00', '1', '1', 0);

最后更新: