ory-am/hydra

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

Summary

Maintainability

Test Coverage

Issues

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

CREATE INDEX ON hydra_oauth2_jti_blacklist ( expires_at );