/** Source Server Version: 8.0.31 Source Database: daogucms Date: 2025/07/12 09:59:22 */ DROP TABLE IF EXISTS `sys_ems`; CREATE TABLE `sys_ems` ( PRIMARY KEY (`id`), `id` BIGINT AUTO_INCREMENT COMMENT 'ID', `origin` VARCHAR(20) COMMENT '来源', `email` VARCHAR(50) NOT NULL COMMENT '邮箱地址', `ems_code` VARCHAR(6) COMMENT '验证码', `ip` VARCHAR(255) COMMENT 'IP', `ua` VARCHAR(255) COMMENT 'User Agent', `create_time` DATETIME DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间' ) ENGINE = INNODB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8mb4 COMMENT = '系统邮件记录表';