CREATE TABLE `{prefix}secure_tfa_otp_verifications` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(11) DEFAULT NULL,
  `method` varchar(255) NOT NULL,
  `identifier` varchar(255) NOT NULL,
  `code` varchar(255) DEFAULT NULL,
  `action` varchar(255) NOT NULL DEFAULT 'login',
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `ip_address` varchar(45) DEFAULT NULL,
  `expired_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `{prefix}secure_tfa_otp_verifications_user_id_index` (`user_id`),
  KEY `{prefix}secure_tfa_otp_verifications_identifier_index` (`identifier`),
  KEY `{prefix}secure_tfa_otp_verifications_method_index` (`method`)
) {collate};
