You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
Malio/sql/sms_verify.sql

14 lines
437 B
MySQL

6 years ago
/* 给 user 表增加 phone 字段 */
ALTER TABLE `user` ADD `phone` bigint(20) AFTER `email`;
/* 增加 短信验证码 表 */
CREATE TABLE IF NOT EXISTS `sms_verify` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`phone` bigint(20) NOT NULL,
`code` text NOT NULL,
`ip` text NOT NULL,
`expire_in` bigint(20) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;