v2.3.0

sql 脚本 - DDL

-- 修改系统设置表结构
ALTER TABLE `system_setting` 
ADD COLUMN `config_key` varchar(64) NULL COMMENT '配置key' AFTER `id`,
MODIFY COLUMN `value` text NULL COMMENT '配置值' AFTER `item`,
ADD INDEX `type_item_idx`(`type`, `item`),
ADD INDEX `key_idx`(`config_key`);
-- 修改偏好表结构
ALTER TABLE `preference` 
MODIFY COLUMN `value` text NULL COMMENT '配置值' AFTER `item`;
-- 添加/修改描述字段
ALTER TABLE `host` 
ADD COLUMN `description` varchar(255) NULL COMMENT '主机描述' AFTER `config`;
ALTER TABLE `host_identity` 
ADD COLUMN `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '描述' AFTER `key_id`;
ALTER TABLE `host_key` 
ADD COLUMN `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '描述' AFTER `password`;
ALTER TABLE `system_user` 
ADD COLUMN `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '用户描述' AFTER `last_login_time`;
ALTER TABLE `system_role` 
ADD COLUMN `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '角色描述' AFTER `status`;
ALTER TABLE `dict_key` 
MODIFY COLUMN `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '配置描述' AFTER `extra_schema`;
ALTER TABLE `exec_log` 
MODIFY COLUMN `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '执行描述' AFTER `exec_mode`;
ALTER TABLE `upload_task` 
MODIFY COLUMN `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NULL DEFAULT NULL COMMENT '描述' AFTER `remote_path`;

sql 脚本 - DML

-- 提取偏好设置 json
UPDATE preference SET value = JSON_UNQUOTE(JSON_EXTRACT(value, '$.value'));
-- 提取系统设置 json
UPDATE system_setting SET config_key = CONCAT(LOWER(type), '.', item), value = JSON_UNQUOTE(JSON_EXTRACT(value, '$.value'));
-- 添加默认密钥对
DELETE FROM `system_setting` WHERE id IN (2, 3); 
INSERT INTO `system_setting` VALUES (2, 'encrypt.publicKey', 'ENCRYPT', 'publicKey', 'MIGfMA0GCSqGSIb3DQEBAQUAA4GNADCBiQKBgQC6++dxyeNdij6ZfM2I9ojLQ1tzmqyuL3rkectm9uXJsXOFiN0aFi4glsoGVZO5hMH5/pppdSQnYz3rSV9b0qjFTRMv5u1BHHzuzoOkI43WqXCX96f8diHIZsEu9fZ+AkxVck/kDPfmR2dVjwo8ZBuJ7drsP8fDbs8N3vtEwPSotwIDAQAB', '2025-01-07 15:40:18', '2025-01-07 15:40:18', '1', '1', 0);
INSERT INTO `system_setting` VALUES (3, 'encrypt.privateKey', '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-01-07 15:40:18', '2025-01-07 15:40:18', '1', '1', 0);