root
11 lines
422 B
SQL
11 lines
422 B
SQL
CREATE TABLE IF NOT EXISTS `ip_attempts` (
|
|
`id` INT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
|
|
`ip_address` VARCHAR(45) NOT NULL,
|
|
`attempts` INT DEFAULT 0 NOT NULL,
|
|
`last_attempt_at` DATETIME NOT NULL,
|
|
`blocked_until` DATETIME DEFAULT NULL,
|
|
`created_at` DATETIME DEFAULT CURRENT_TIMESTAMP,
|
|
`updated_at` DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
|
|
UNIQUE KEY (`ip_address`)
|
|
);
|