Skip to content

Instantly share code, notes, and snippets.

@jamesnguyen101
Forked from fernandomantoan/schema.sql
Created December 21, 2018 03:22
Show Gist options
  • Save jamesnguyen101/78b11d916df62970affafa436b62c187 to your computer and use it in GitHub Desktop.
Save jamesnguyen101/78b11d916df62970affafa436b62c187 to your computer and use it in GitHub Desktop.
Schema for PostgreSQL to use with JdbcTokenStore (Spring Security OAuth2)
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
);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment