From 30c64cb3292f55231bc20c365c2fe5d06d6d2369 Mon Sep 17 00:00:00 2001 From: Niall Sheridan 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