Created
April 1, 2021 18:30
-
-
Save zprobst/d1360f166a60ac14e8417a46e782cd5a to your computer and use it in GitHub Desktop.
commands.sql
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
USE ouath; | |
CREATE TABLE oauth_clients ( | |
client_id VARCHAR(80) NOT NULL, | |
client_secret VARCHAR(80), | |
redirect_uri VARCHAR(2000), | |
grant_types VARCHAR(80), | |
scope VARCHAR(4000), | |
user_id VARCHAR(80), | |
PRIMARY KEY (client_id) | |
); | |
CREATE TABLE oauth_access_tokens ( | |
access_token VARCHAR(40) NOT NULL, | |
client_id VARCHAR(80) NOT NULL, | |
user_id VARCHAR(80), | |
expires TIMESTAMP NOT NULL, | |
scope VARCHAR(4000), | |
PRIMARY KEY (access_token) | |
); | |
CREATE TABLE oauth_authorization_codes ( | |
authorization_code VARCHAR(40) NOT NULL, | |
client_id VARCHAR(80) NOT NULL, | |
user_id VARCHAR(80), | |
redirect_uri VARCHAR(2000), | |
expires TIMESTAMP NOT NULL, | |
scope VARCHAR(4000), | |
id_token VARCHAR(1000), | |
PRIMARY KEY (authorization_code) | |
); | |
CREATE TABLE oauth_refresh_tokens ( | |
refresh_token VARCHAR(40) NOT NULL, | |
client_id VARCHAR(80) NOT NULL, | |
user_id VARCHAR(80), | |
expires TIMESTAMP NOT NULL, | |
scope VARCHAR(4000), | |
PRIMARY KEY (refresh_token) | |
); | |
CREATE TABLE oauth_users ( | |
username VARCHAR(80), | |
password VARCHAR(80), | |
first_name VARCHAR(80), | |
last_name VARCHAR(80), | |
email VARCHAR(80), | |
email_verified BOOLEAN, | |
scope VARCHAR(4000), | |
PRIMARY KEY (username) | |
); | |
CREATE TABLE oauth_scopes ( | |
scope VARCHAR(80) NOT NULL, | |
is_default BOOLEAN, | |
PRIMARY KEY (scope) | |
); | |
CREATE TABLE oauth_jwt ( | |
client_id VARCHAR(80) NOT NULL, | |
subject VARCHAR(80), | |
public_key VARCHAR(2000) NOT NULL | |
); |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment