From bd6b518aae61608ddc2d82b43ccc283dc95b9c54 Mon Sep 17 00:00:00 2001 From: Junjie <fallin.jie@qq.com> Date: 星期三, 11 三月 2026 13:59:33 +0800 Subject: [PATCH] # --- src/main/resources/sql/20260311_add_passkey_columns_to_sys_user.sql | 26 ++++++++++++++++++++++++++ 1 files changed, 26 insertions(+), 0 deletions(-) diff --git a/src/main/resources/sql/20260311_add_passkey_columns_to_sys_user.sql b/src/main/resources/sql/20260311_add_passkey_columns_to_sys_user.sql new file mode 100644 index 0000000..a666be3 --- /dev/null +++ b/src/main/resources/sql/20260311_add_passkey_columns_to_sys_user.sql @@ -0,0 +1,26 @@ +-- 鐢ㄩ�旓細鏀寔璐﹀彿缁戝畾鍗曚釜閫氳瀵嗛挜骞堕�氳繃閫氳瀵嗛挜鐧诲綍 +-- 閫傜敤琛細sys_user + +SET @table_exists := ( + SELECT COUNT(*) + FROM information_schema.tables + WHERE table_schema = DATABASE() + AND table_name = 'sys_user' +); + +SET @sql := IF(@table_exists = 0, + 'SELECT ''sys_user not found''', + 'ALTER TABLE sys_user + ADD COLUMN passkey_name VARCHAR(100) NULL COMMENT ''閫氳瀵嗛挜鍚嶇О'' AFTER mfa_bound_time, + ADD COLUMN passkey_credential_id VARCHAR(255) NULL COMMENT ''閫氳瀵嗛挜鍑瘉ID'' AFTER passkey_name, + ADD COLUMN passkey_public_key TEXT NULL COMMENT ''閫氳瀵嗛挜鍏挜SPKI'' AFTER passkey_credential_id, + ADD COLUMN passkey_algorithm INT NULL COMMENT ''閫氳瀵嗛挜绠楁硶'' AFTER passkey_public_key, + ADD COLUMN passkey_sign_count BIGINT NOT NULL DEFAULT 0 COMMENT ''閫氳瀵嗛挜绛惧悕璁℃暟鍣�'' AFTER passkey_algorithm, + ADD COLUMN passkey_transports VARCHAR(255) NULL COMMENT ''閫氳瀵嗛挜浼犺緭鏂瑰紡'' AFTER passkey_sign_count, + ADD COLUMN passkey_bound_time DATETIME NULL COMMENT ''閫氳瀵嗛挜缁戝畾鏃堕棿'' AFTER passkey_transports, + ADD COLUMN passkey_last_used_time DATETIME NULL COMMENT ''閫氳瀵嗛挜鏈�杩戜娇鐢ㄦ椂闂�'' AFTER passkey_bound_time' +); + +PREPARE stmt FROM @sql; +EXECUTE stmt; +DEALLOCATE PREPARE stmt; -- Gitblit v1.9.1