CREATE TABLE `{prefix}secure_tfa_logs` (
    `id` BIGINT(20) unsigned NOT NULL AUTO_INCREMENT,
    `user_id` INT(11) NOT NULL,
    `admin_id` INT(11) DEFAULT NULL,
    `log_type` varchar(255) NOT NULL,
    `identifier` varchar(255) DEFAULT NULL,
    `method` VARCHAR(255) DEFAULT NULL,
    `using_backup_code` TINYINT(1) DEFAULT NULL,
    `ip_address` VARCHAR(45) NOT NULL,
    `created_at` TIMESTAMP NULL DEFAULT NULL,
    `updated_at` TIMESTAMP NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    KEY `{prefix}secure_tfa_logs_user_id_index` (`user_id`),
    KEY `{prefix}secure_tfa_logs_method_index` (`method`)
) {collate};