CREATE TABLE `{LOGINPROTECTION_LOGS}` (
	`log_id` INT NOT NULL AUTO_INCREMENT,
	`event_type` VARCHAR(30) NOT NULL,
	`account` VARCHAR(191) NULL,
	`ip_address` VARCHAR(45) NULL,
	`identity_type` VARCHAR(16) NULL,
	`identity_value` VARCHAR(191) NULL,
	`message` VARCHAR(500) NULL,
	`context_json` TEXT NULL,
	`created_at` INT NOT NULL DEFAULT 0,
	PRIMARY KEY (`log_id`),
	KEY `ix_loginprotection_logs_created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4
