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 --- .../migrations/sqlite3/20180807223808_idx_revoked_expires_at.sql | 5 +++++ 1 file changed, 5 insertions(+) create mode 100644 server/store/migrations/sqlite3/20180807223808_idx_revoked_expires_at.sql (limited to 'server/store/migrations/sqlite3/20180807223808_idx_revoked_expires_at.sql') diff --git a/server/store/migrations/sqlite3/20180807223808_idx_revoked_expires_at.sql b/server/store/migrations/sqlite3/20180807223808_idx_revoked_expires_at.sql new file mode 100644 index 0000000..ae9ca3d --- /dev/null +++ b/server/store/migrations/sqlite3/20180807223808_idx_revoked_expires_at.sql @@ -0,0 +1,5 @@ +-- +migrate Up +DROP INDEX `idx_revoked_expires_at`; + +-- +migrate Down +CREATE INDEX `idx_revoked_expires_at` ON `issued_certs` (`revoked`, `expires_at`); -- cgit v1.2.3