create database if not exists wx_miniApp default charset utf8mb4; use wx_miniApp; CREATE TABLE IF NOT EXISTS `wx_user` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `openid` varchar(100) NOT NULL COMMENT '微信openid', `nickname` varchar(50) DEFAULT NULL COMMENT '昵称', `avatar_url` varchar(500) DEFAULT NULL COMMENT '头像URL', `gender` tinyint(4) DEFAULT NULL COMMENT '性别 0-未知 1-男 2-女', `country` varchar(50) DEFAULT NULL COMMENT '国家', `province` varchar(50) DEFAULT NULL COMMENT '省份', `city` varchar(50) DEFAULT NULL COMMENT '城市', `language` varchar(50) DEFAULT NULL COMMENT '语言', `create_time` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间', `update_time` datetime DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间', PRIMARY KEY (`id`), UNIQUE KEY `uk_openid` (`openid`) COMMENT 'openid唯一索引' ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='微信用户表'; CREATE TABLE IF NOT EXISTS `debate_history` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) NOT NULL COMMENT '关联用户ID', `topic` varchar(255) NOT NULL COMMENT '辩题', `stance` enum('正方','反方') NOT NULL COMMENT '持方', `content` text COMMENT '辩论内容JSON', `review` text COMMENT 'AI复盘内容', `rounds` smallint(6) DEFAULT 0 COMMENT '辩论轮数', PRIMARY KEY (`id`), KEY `idx_user_time` (`user_id`, `create_time`), CONSTRAINT `fk_user_history` FOREIGN KEY (`user_id`) REFERENCES `wx_user` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='辩论历史记录表';