CREATE TABLE `signup_sessions` (`id` blob,`email_index` blob NOT NULL,`token_hash` blob NOT NULL,`verified` numeric NOT NULL,`expires_at` datetime NOT NULL,`created_at` datetime,PRIMARY KEY (`id`));
2
3
CREATE INDEX `idx_signup_sessions_expires_at` ON `signup_sessions`(`expires_at`);
4
5
CREATE INDEX `idx_signup_sessions_token_hash` ON `signup_sessions`(`token_hash`);
6
7
CREATE INDEX `idx_signup_sessions_email_index` ON `signup_sessions`(`email_index`);
amadan