CREATE TABLE `login_challenges` (`id` blob,`account_id` blob NOT NULL,`branch` text NOT NULL,`challenge` blob NOT NULL,`expires_at` datetime NOT NULL,`created_at` datetime,PRIMARY KEY (`id`));
2
3
CREATE INDEX `idx_login_challenges_expires_at` ON `login_challenges`(`expires_at`);
4
5
CREATE INDEX `idx_login_challenges_challenge` ON `login_challenges`(`challenge`);
6
7
CREATE INDEX `idx_login_challenges_account_id` ON `login_challenges`(`account_id`);
amadan