Authorization Server Storage Database Schema

When the Authorization Server storage is set to Database, users are required to create two new tables manually in the Database where the Authorization Server will store the scope and details of the client registration.

Users can refer to the following example of a table schema to generate the tables for Authorization Server.

Example - Table Schema

CREATE TABLE oauth_scope (
scope       VARCHAR(64) NOT NULL PRIMARY KEY, 
description VARCHAR(128)
);

CREATE TABLE oauth_client ( 
client_name   VARCHAR(128)    NOT NULL PRIMARY KEY, 
client_id     VARCHAR(64)     NOT NULL, 
client_secret VARCHAR(64)     NOT NULL, 
client_scope  VARCHAR(2048)   NOT NULL 
);