ory-am/hydra

View on GitHub
persistence/sql/migrations/20240612222110000001_add_oauth2_expires_at_indices.mysql.up.sql

Summary

Maintainability
Test Coverage
CREATE INDEX hydra_oauth2_access_expires_at_v2_idx ON hydra_oauth2_access (expires_at);
CREATE INDEX hydra_oauth2_refresh_expires_at_v2_idx ON hydra_oauth2_refresh (expires_at);
CREATE INDEX hydra_oauth2_code_expires_at_v2_idx ON hydra_oauth2_code (expires_at);
CREATE INDEX hydra_oauth2_pkce_expires_at_v2_idx ON hydra_oauth2_pkce (expires_at);

DROP INDEX hydra_oauth2_access_expires_at_idx ON hydra_oauth2_oidc;
DROP INDEX hydra_oauth2_refresh_expires_at_idx ON hydra_oauth2_oidc;
DROP INDEX hydra_oauth2_code_expires_at_idx ON hydra_oauth2_oidc;
DROP INDEX hydra_oauth2_pkce_expires_at_idx ON hydra_oauth2_oidc;