diff options
Diffstat (limited to 'server/store/migrations/mysql/20180807223808_idx_revoked_expires_at.sql')
| -rw-r--r-- | server/store/migrations/mysql/20180807223808_idx_revoked_expires_at.sql | 5 |
1 files changed, 5 insertions, 0 deletions
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`); |