yvjia/db/sys_ems.sql

/**
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 = '系统邮件记录表';