aboutsummaryrefslogtreecommitdiff
path: root/server/store/migrations/sqlite3
diff options
context:
space:
mode:
authorNiall Sheridan <nsheridan@gmail.com>2018-08-07 16:15:16 +0100
committerNiall Sheridan <nsheridan@gmail.com>2018-08-07 23:55:40 +0100
commit30c64cb3292f55231bc20c365c2fe5d06d6d2369 (patch)
tree708d09ff81366b290c2ecefc41883f97c20653f0 /server/store/migrations/sqlite3
parentf089aaf1b66309756d3ee0e44cab30e17139b71a (diff)
Drop unneeded index idx_revoked_expires_at
Diffstat (limited to 'server/store/migrations/sqlite3')
-rw-r--r--server/store/migrations/sqlite3/20180807223808_idx_revoked_expires_at.sql5
1 files changed, 5 insertions, 0 deletions
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`);