Database model
oauth_access_tokens
access_token: varchar(80)
client_id: varchar(80) NULL
user_id: varchar(80) NULL
expires: datetime NULL
scope: varchar(4000) NULL
oauth_authorization_codes
authorization_code: varchar(40) PRIMARY KEY NOT NULL
client_id: varchar(80) NOT NULL
user_id: varchar(80)
redirect_uri: varchar(2000)
expires: datetime NOT NULL
scope: varchar(4000)
id_token: varchar(1000)
oauth_clients
client_id: varchar(80)
client_secret: varchar(80) NULL
redirect_uri: varchar(2000) NULL
grant_types: varchar(80) NULL
scope: varchar(4000) NULL
user_id: varchar(80) NULL
oauth_ip_logins
ip_login_id: int NOT NULL PRIMARY KEY auto_increment
ip: varchar(128)
user_agent: varchar(512)
login_time: datetime
user_id: varchar(4000)
access_token: varchar(4000)
location: varchar(4000)
success: tinyint NULL
oauth_jwt
client_id: varchar(80)
subject: varchar(80) NULL
public_key: varchar(2000)
oauth_public_keys
client_id: varchar(80)
private_key: varchar(8000)
public_key: varchar(8000)
encryption_algorithm: varchar(80) DEFAULT 'RS256'
oauth_refresh_tokens
refresh_token: varchar(40) PRIMARY KEY NOT NULL
client_id: varchar(80) NOT NULL
user_id: varchar(80)
expires: datetime NOT NULL
scope: varchar(4000) NULL
oauth_scopes
is_default: tinyint NULL
scope: varchar(80)
oauth_users
user_id: int NOT NULL PRIMARY KEY auto_increment
username: varchar(40)
password: varchar(80)
email: varchar(4000) NULL
email_verified: tinyint NULL
scope: varchar(80) NULL
activate_token: varchar(200) NULL
reset_token: varchar(200) NULL
last_login: datetime NULL
last_password_set: datetime NULL
first_name: varchar(512) NULL
last_name: varchar(512) NULL
external_id: int NULL
metadata: varchar(4000) NULL