# /** # 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(10) NOT NULL 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='系统短信记录表';