MySQL Create Table SQL
Table Structure: okayapi_fie_user_login_attempt:/tablelist/okayapi_fie_user_login_attempt.html
-- MySQL Table okayapi_fie_user_login_attempt
-- From: OkayAPI.com
CREATE TABLE `okayapi_fie_user_login_attempt` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`login_attempts` int(10) NOT NULL DEFAULT '0' COMMENT '尝试次数',
`attempt_time` int(10) NOT NULL DEFAULT '0' COMMENT '尝试登录时间',
`locked_time` int(10) NOT NULL DEFAULT '0' COMMENT '锁定时间',
`ip` varchar(15) NOT NULL COMMENT '用户 ip',
`okayapi_fie_user_login_attempt_account` varchar(100) NOT NULL COMMENT '用户账号,手机号,邮箱或用户名',
KEY `login_attempts` (`login_attempts`),
KEY `attempt_time` (`attempt_time`),
KEY `locked_time` (`locked_time`),
KEY `ip` (`ip`),
KEY `okayapi_fie_user_login_attempt_account` (`okayapi_fie_user_login_attempt_account`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'fie内容管理-用户登录尝试表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-5 of 5 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
login_attempts | int(10) | 0 | 否 | 尝试次数 | 0 | |
attempt_time | int(10) | 0 | 否 | 尝试登录时间 | 0 | |
locked_time | int(10) | 0 | 否 | 锁定时间 | 0 | |
ip | varchar(15) | 否 | 用户 ip | |||
okayapi_fie_user_login_attempt_account | varchar(100) | 否 | 用户账号,手机号,邮箱或用户名 |