From 85047e978b5783e9172a0a40e62542337d702720 Mon Sep 17 00:00:00 2001 From: Niall Sheridan Date: Thu, 6 Apr 2017 19:03:31 +0100 Subject: Add indexes --- db/seed.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'db') 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`); -- cgit v1.2.3