diff options
Diffstat (limited to 'server/store/migrations/sqlite3/20180807223808_idx_revoked_expires_at.sql')
| -rw-r--r-- | server/store/migrations/sqlite3/20180807223808_idx_revoked_expires_at.sql | 5 |
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`); |