persistence/sql/migrations/20201110104000000000_drop_uq_oauth2.postgres.up.sql from ory-am/hydra

persistence/sql/migrations/20201110104000000000_drop_uq_oauth2.postgres.up.sql

Summary

Maintainability

Test Coverage

Issues
Source
Stats

Issues

DROP INDEX hydra_oauth2_access_request_id_idx;
DROP INDEX hydra_oauth2_refresh_request_id_idx;

CREATE INDEX hydra_oauth2_access_request_id_idx ON hydra_oauth2_access (request_id);
CREATE INDEX hydra_oauth2_refresh_request_id_idx ON hydra_oauth2_refresh (request_id);

CREATE INDEX hydra_oauth2_code_request_id_idx ON hydra_oauth2_code (request_id);
CREATE INDEX hydra_oauth2_oidc_request_id_idx ON hydra_oauth2_oidc (request_id);
CREATE INDEX hydra_oauth2_pkce_request_id_idx ON hydra_oauth2_pkce (request_id);