ory-am/hydra

persistence/sql/migrations/20190400000011000000_oauth2.up.sql

Summary

Maintainability

Test Coverage

Issues

CREATE TABLE IF NOT EXISTS hydra_oauth2_jti_blacklist (
    signature       varchar(64) NOT NULL PRIMARY KEY,
    expires_at      timestamp NOT NULL DEFAULT now()
);

-- mysql requires the index to be named
CREATE INDEX hydra_oauth2_jti_blacklist_expiry ON hydra_oauth2_jti_blacklist ( expires_at );