id int(11) not_null auto_increment comment(Primary key - unique identifier for each failed attempt record)
identifier varchar(255) not_null comment(Identifier being tracked - typically MCP key, username, or IP address)
attempts int(11) default null comment(Number of consecutive failed authentication attempts)
last_attempt int(11) not_null comment(Unix timestamp of the most recent failed attempt)
--
primary id
idx_identifier identifier
##
engine innodb
character_set utf8mb4
collate utf8mb4_unicode_ci