diff options
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`); |