MySQL Create Table SQL
Table Structure: okayapi_login：/tablelist/okayapi_login.html
-- MySQL Table okayapi_login
-- From: OkayAPI.com
CREATE TABLE `okayapi_login` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`userId` bigint(15) NOT NULL COMMENT '用户id',
`type` tinyint(2) NOT NULL COMMENT '类型
0-密码登录
1-验证码登录',
`date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建日期',
KEY `userId` (`userId`),
KEY `type` (`type`),
KEY `date` (`date`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'web开发-登录信息存session';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-3 of 3 results.
| Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
|---|---|---|---|---|---|---|
| userId | bigint(15) | 否 | 用户id | |||
| type | tinyint(2) | 否 | 类型 0-密码登录 1-验证码登录 | |||
| date | timestamp | CURRENT_TIMESTAMP | 否 | 创建日期 | CURRENT_TIMESTAMP |
