From 30c64cb3292f55231bc20c365c2fe5d06d6d2369 Mon Sep 17 00:00:00 2001
From: Niall Sheridan <nsheridan@gmail.com>
Date: Tue, 7 Aug 2018 16:15:16 +0100
Subject: Drop unneeded index idx_revoked_expires_at

---
 .../store/migrations/mysql/20180807223808_idx_revoked_expires_at.sql | 5 +++++
 1 file changed, 5 insertions(+)
 create mode 100644 server/store/migrations/mysql/20180807223808_idx_revoked_expires_at.sql

(limited to 'server/store/migrations/mysql/20180807223808_idx_revoked_expires_at.sql')

diff --git a/server/store/migrations/mysql/20180807223808_idx_revoked_expires_at.sql b/server/store/migrations/mysql/20180807223808_idx_revoked_expires_at.sql
new file mode 100644
index 0000000..fe82dd5
--- /dev/null
+++ b/server/store/migrations/mysql/20180807223808_idx_revoked_expires_at.sql
@@ -0,0 +1,5 @@
+-- +migrate Up
+ALTER TABLE `issued_certs` DROP INDEX `idx_revoked_expires_at`;
+
+-- +migrate Down
+ALTER TABLE `issued_certs` ADD INDEX `idx_revoked_expires_at` (`revoked`,`expires_at`);
-- 
cgit v1.2.3

