Last active
August 25, 2020 02:29
-
-
Save leolin310148/3b2cb7d83ba0ec9e1d58 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
hello, where is oath2 sql schema ? I can't find in org/springframework/security/oauth/boot/spring-security-oauth2-autoconfigure/2.0.0.RELEASE/spring-security-oauth2-autoconfigure-2.0.0.RELEASE.jar. which jar can i find it?