Files

10 lines
666 B
SQL

-- 增量执行,不修改已有用户及 Google OAuth 绑定。
CREATE TABLE IF NOT EXISTS sys_user_totp (
user_id BIGINT NOT NULL COMMENT '本地用户 ID,一人一个 Authenticator',
secret_cipher VARCHAR(255) CHARACTER SET ascii COLLATE ascii_bin NOT NULL COMMENT 'AES-256-GCM 密文',
last_used_step BIGINT NOT NULL DEFAULT -1 COMMENT '防重放:最近消费的 30 秒时间步',
created_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
updated_at TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (user_id)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户 Authenticator 动态码凭据';