Schema for PostgreSQL to use with JdbcTokenStore (Spring Security OAuth2)

schema.sql

create table oauth_client_details (
  client_id VARCHAR(256) PRIMARY KEY,
  resource_ids VARCHAR(256),
  client_secret VARCHAR(256),
  scope VARCHAR(256),
  authorized_grant_types VARCHAR(256),
  web_server_redirect_uri VARCHAR(256),
  authorities VARCHAR(256),
  access_token_validity INTEGER,
  refresh_token_validity INTEGER,
  additional_information VARCHAR(4096),
  autoapprove VARCHAR(256)
);

create table oauth_client_token (
  token_id VARCHAR(256),
  token bytea,
  authentication_id VARCHAR(256),
  user_name VARCHAR(256),
  client_id VARCHAR(256)
);

create table oauth_access_token (
  token_id VARCHAR(256),
  token bytea,
  authentication_id VARCHAR(256),
  user_name VARCHAR(256),
  client_id VARCHAR(256),
  authentication bytea,
  refresh_token VARCHAR(256)
);

create table oauth_refresh_token (
  token_id VARCHAR(256),
  token bytea,
  authentication bytea
);

create table oauth_code (
  code VARCHAR(256), authentication bytea
);

create table oauth_approvals (
  userId VARCHAR(256),
  clientId VARCHAR(256),
  scope VARCHAR(256),
  status VARCHAR(10),
  expiresAt TIMESTAMP,
  lastModifiedAt TIMESTAMP
);

Thanks for this, really helped me out!

should I use pk's and indexes?

Awesome! Thanks!

Thanks!

Definitely could use constraints, both PKs and a FK from oauth_access_token.refresh_token to oauth_refresh_token.token_id.

Thank you! It helped me!

hi can I pass this user token to postgres so that it can it can fill data like
created by,lastmodifiedby

Save my day. <3

Hi Fernando, I has some issue, can you support me.
My project only using Grant Type <client_credentials>. So I think I can not using some tables.
So what would I keep from the ones above?
Thanks you.

thank you. this help me alot

nice

\o_ Very nice

thank you man