Download this file
| 1 | CREATE TABLE `signups` (`id` integer PRIMARY KEY AUTOINCREMENT,`email` text,`stance` text,`background` text,`confirmed` numeric,`confirmed_at` datetime,`token_hash` blob,`token_expiry` datetime,`last_mailed_at` datetime,`mail_count` integer,`created_at` datetime,`updated_at` datetime); |
| 2 | |
| 3 | CREATE UNIQUE INDEX `idx_signups_email` ON `signups`(`email`); |
| 4 | |
| 5 | CREATE TABLE `mail_counters` (`hour_bucket` text,`count` integer,PRIMARY KEY (`hour_bucket`)); |
| 6 | |
| 7 | |
amadan