diff options
| author | Niall Sheridan <nsheridan@gmail.com> | 2018-08-07 16:15:16 +0100 |
|---|---|---|
| committer | Niall Sheridan <nsheridan@gmail.com> | 2018-08-07 23:55:40 +0100 |
| commit | 30c64cb3292f55231bc20c365c2fe5d06d6d2369 (patch) | |
| tree | 708d09ff81366b290c2ecefc41883f97c20653f0 /server/store/migrations | |
| parent | f089aaf1b66309756d3ee0e44cab30e17139b71a (diff) | |
Drop unneeded index idx_revoked_expires_at
Diffstat (limited to 'server/store/migrations')
| -rw-r--r-- | server/store/migrations/mysql/20180807223808_idx_revoked_expires_at.sql | 5 | ||||
| -rw-r--r-- | server/store/migrations/sqlite3/20180807223808_idx_revoked_expires_at.sql | 5 |
2 files changed, 10 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`); 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`); |