okayapi_verify - MySQ Table Design

MySQL Create Table SQL

Table Structure: okayapi_verify：/tablelist/okayapi_verify.html


-- MySQL Table okayapi_verify
-- From: OkayAPI.com
CREATE TABLE `okayapi_verify` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `type` int(2) NOT NULL DEFAULT '0' COMMENT '类型：
0-登录
1-注册
2-修改登录密码
3-修改支付密码',
    `phone` bigint(11) NOT NULL COMMENT '手机号',
    `verify` int(6) NOT NULL COMMENT '验证码',
    `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    KEY `type` (`type`),
    KEY `phone` (`phone`),
    KEY `verify` (`verify`),
    KEY `date` (`date`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'web开发-手机验证表';

After replication, you can go to the database to create the database table.

MySQL database table structure design

Displaying 1-4 of 4 results.

Field Name	Field Type	Default	IS NULL	Field Comment	Demo Data
type	int(2)	0	否	类型： 0-登录 1-注册 2-修改登录密码 3-修改支付密码	0
phone	bigint(11)		否	手机号
verify	int(6)		否	验证码
date	timestamp	CURRENT_TIMESTAMP	否	创建时间	CURRENT_TIMESTAMP