yvjia/db/sys_sms_history.sql

# /**
# Source Server Version: 8.0.31
# Source Database: backendsys
# Date: 2023/05/23 17:09:22
# */
#
# /* 即将弃用 */
#
# DROP TABLE IF EXISTS `sys_mobile_sms_history`;
# CREATE TABLE `sys_mobile_sms_history` (
#     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='系统短信记录表';