登陆注册与忘记密码前后端与jwt配置
Change-Id: Ide4ca3ea34609fdb33ea027e28169852fa41784a
diff --git a/all_tables.sql b/all_tables.sql
index 0510e25..b796224 100644
--- a/all_tables.sql
+++ b/all_tables.sql
@@ -47,6 +47,23 @@
updated_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间'
) ENGINE=InnoDB COMMENT='用户表';
+-- 邮箱验证表
+CREATE TABLE email_verifications (
+ id INT AUTO_INCREMENT PRIMARY KEY COMMENT '验证ID',
+ email VARCHAR(100) NOT NULL COMMENT '邮箱地址',
+ code VARCHAR(255) NOT NULL COMMENT '验证码',
+ type ENUM('register', 'reset_password', 'email_change') NOT NULL COMMENT '验证类型',
+ user_id INT DEFAULT NULL COMMENT '用户ID（找回密码时使用）',
+ is_verified BOOLEAN DEFAULT FALSE COMMENT '是否已验证',
+ expires_at TIMESTAMP NOT NULL COMMENT '过期时间',
+ created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
+ verified_at TIMESTAMP NULL DEFAULT NULL COMMENT '验证时间',
+ INDEX idx_email_code (email, code),
+ INDEX idx_email_type (email, type),
+ INDEX idx_expires_at (expires_at),
+ FOREIGN KEY (user_id) REFERENCES users(id) ON DELETE CASCADE
+) ENGINE=InnoDB COMMENT='邮箱验证表';
+
-- 标签表
CREATE TABLE tags (
id INT AUTO_INCREMENT PRIMARY KEY COMMENT '标签ID',