diff options
| author | Niall Sheridan <nsheridan@gmail.com> | 2017-04-06 19:03:31 +0100 |
|---|---|---|
| committer | Niall Sheridan <nsheridan@gmail.com> | 2017-04-10 11:13:24 +0100 |
| commit | 85047e978b5783e9172a0a40e62542337d702720 (patch) | |
| tree | 8ec568d683a249f717b9c3a478579b34d979ce0c | |
| parent | 4e29aef6993d07ea9938af7152a28413c57334f1 (diff) | |
Add indexes
| -rw-r--r-- | db/seed.sql | 2 |
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`); |