From 85047e978b5783e9172a0a40e62542337d702720 Mon Sep 17 00:00:00 2001
From: Niall Sheridan <nsheridan@gmail.com>
Date: Thu, 6 Apr 2017 19:03:31 +0100
Subject: Add indexes

---
 db/seed.sql | 2 ++
 1 file changed, 2 insertions(+)

(limited to 'db/seed.sql')

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

