yvjia/db/sys_sms.sql

/**
Source Server Version: 8.0.31
Source Database: backendsys
Date: 2023/05/23 17:09:22
*/

DROP TABLE IF EXISTS `sys_sms`;
CREATE TABLE `sys_sms` (
    PRIMARY KEY (`id`),
    `id` BIGINT AUTO_INCREMENT COMMENT 'ID',
    `origin` VARCHAR(20) COMMENT '来源',
    `phone_area_code` VARCHAR(20) COMMENT '区号/国家码',
    `phone` VARCHAR(20) NOT NULL COMMENT '手机号码',
    `sms_code` VARCHAR(255) 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='系统短信记录表';