+--
+-- TABLE 2fa_recovery_codes
+--
+CREATE TABLE IF NOT EXISTS `2fa_recovery_codes` (
+ `uid` mediumint unsigned NOT NULL COMMENT 'User ID',
+ `code` varchar(50) NOT NULL COMMENT 'Recovery code string',
+ `generated` datetime NOT NULL COMMENT 'Datetime the code was generated',
+ `used` datetime COMMENT 'Datetime the code was used',
+ PRIMARY KEY(`uid`,`code`)
+) DEFAULT COLLATE utf8mb4_general_ci COMMENT='Two-factor authentication recovery codes';
+