Download this file
| 1 | -- Generated by rastrillo migration generate; DO NOT EDIT. |
| 2 | -- The schema every migration in this directory adds up to. |
| 3 | |
| 4 | CREATE TABLE `mail_counters` (`hour_bucket` text,`count` integer,PRIMARY KEY (`hour_bucket`)); |
| 5 | |
| 6 | 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, `name` text); |
| 7 | |
| 8 | CREATE TABLE `spent_nonces` (`nonce` text,`expires_at` datetime,PRIMARY KEY (`nonce`)); |
| 9 | |
| 10 | CREATE UNIQUE INDEX `idx_signups_email` ON `signups`(`email`); |
| 11 | |
| 12 | CREATE INDEX `idx_spent_nonces_expires_at` ON `spent_nonces`(`expires_at`); |
| 13 | |
| 14 | |
amadan