aboutsummaryrefslogtreecommitdiff
path: root/db
diff options
context:
space:
mode:
Diffstat (limited to 'db')
-rw-r--r--db/seed.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/db/seed.sql b/db/seed.sql
index 7c438fd..03f7b1e 100644
--- a/db/seed.sql
+++ b/db/seed.sql
@@ -11,3 +11,5 @@ CREATE TABLE `issued_certs` (
`raw_key` text,
PRIMARY KEY (`key_id`)
);
+CREATE INDEX `idx_expires_at` ON `issued_certs` (`expires_at`);
+CREATE INDEX `idx_revoked_expires_at` ON `issued_certs` (`revoked`, `expires_at`);