persistence/sql/migrations/20240612222110000001_add_oauth2_expires_at_indices.down.sql from ory-am/hydra

persistence/sql/migrations/20240612222110000001_add_oauth2_expires_at_indices.down.sql

Summary

Maintainability

Test Coverage

Issues
Source
Stats

Issues

CREATE INDEX IF NOT EXISTS hydra_oauth2_access_expires_at_idx ON hydra_oauth2_oidc (expires_at);
CREATE INDEX IF NOT EXISTS hydra_oauth2_refresh_expires_at_idx ON hydra_oauth2_oidc (expires_at);
CREATE INDEX IF NOT EXISTS hydra_oauth2_code_expires_at_idx ON hydra_oauth2_oidc (expires_at);
CREATE INDEX IF NOT EXISTS hydra_oauth2_pkce_expires_at_idx ON hydra_oauth2_oidc (expires_at);

DROP INDEX hydra_oauth2_access_expires_at_v2_idx;
DROP INDEX hydra_oauth2_refresh_expires_at_v2_idx;
DROP INDEX hydra_oauth2_code_expires_at_v2_idx;
DROP INDEX hydra_oauth2_pkce_expires_at_v2_idx;