Forked from leolin310148/spring_security_oauth2_mysql.schema
Created
May 1, 2019 08:08
-
-
Save syakuis/86f74628466a94cbcc0c2255e947e73d to your computer and use it in GitHub Desktop.
Spring Security OAuth2 MySQL Schema
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
create table oauth_client_details ( | |
client_id VARCHAR(255) PRIMARY KEY, | |
resource_ids VARCHAR(255), | |
client_secret VARCHAR(255), | |
scope VARCHAR(255), | |
authorized_grant_types VARCHAR(255), | |
web_server_redirect_uri VARCHAR(255), | |
authorities VARCHAR(255), | |
access_token_validity INTEGER, | |
refresh_token_validity INTEGER, | |
additional_information VARCHAR(4096), | |
autoapprove tinyint | |
); | |
create table oauth_client_token ( | |
token_id VARCHAR(255), | |
token BLOB, | |
authentication_id VARCHAR(255), | |
user_name VARCHAR(255), | |
client_id VARCHAR(255) | |
); | |
create table oauth_access_token ( | |
token_id VARCHAR(255), | |
token BLOB, | |
authentication_id VARCHAR(255), | |
user_name VARCHAR(255), | |
client_id VARCHAR(255), | |
authentication BLOB, | |
refresh_token VARCHAR(255) | |
); | |
create table oauth_refresh_token ( | |
token_id VARCHAR(255), | |
token BLOB, | |
authentication BLOB | |
); | |
create table oauth_code ( | |
code VARCHAR(255), authentication BLOB | |
); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment