29 lines
2.1 KiB
Plaintext
29 lines
2.1 KiB
Plaintext
|
#Client configuration
|
||
|
|
client_id="<%= @client_id %>"
|
||
|
|
client_secret="<%= @client_secret %>"
|
||
|
|
redirect_uri="<%= @redirect_uri %>"
|
||
|
|
grant_types="<%= @grant_types %>"
|
||
|
|
scope="<%= @scope %>"
|
||
|
|
user_id="<%= @user_id %>"
|
||
|
|
|
||
|
|
#Database configuration
|
||
|
|
oauth_user="<%= @db_user %>"
|
||
|
|
oauth_db_name="<%= @db_name %>"
|
||
|
|
oauth_pass="<%= @db_pass %>"
|
||
|
|
ip="<%= @db_host %>"
|
||
|
|
port=<%= @db_port %>
|
||
|
|
|
||
|
|
#######################################--SQL STATEMENT--###########################################
|
||
|
|
|
||
|
|
#Tables creation
|
||
|
|
create_table_oauth_client="CREATE TABLE oauth_clients (client_id VARCHAR(80) NOT NULL, client_secret VARCHAR(80), redirect_uri VARCHAR(2000) NOT NULL, grant_types VARCHAR(80), scope VARCHAR(100), user_id VARCHAR(80), CONSTRAINT clients_client_id_pk PRIMARY KEY (client_id));"
|
||
|
|
create_table_oauth_access_tokens="CREATE TABLE oauth_access_tokens (access_token VARCHAR(40) NOT NULL, client_id VARCHAR(80) NOT NULL, user_id VARCHAR(255), expires TIMESTAMP NOT NULL, scope VARCHAR(2000), CONSTRAINT access_token_pk PRIMARY KEY (access_token));"
|
||
|
|
create_table_oauth_authorization_codes="CREATE TABLE oauth_authorization_codes (authorization_code VARCHAR(40) NOT NULL, client_id VARCHAR(80) NOT NULL, user_id VARCHAR(255), redirect_uri VARCHAR(2000), expires TIMESTAMP NOT NULL, scope VARCHAR(2000), CONSTRAINT auth_code_pk PRIMARY KEY (authorization_code));"
|
||
|
|
create_table_oauth_refresh_tokens="CREATE TABLE oauth_refresh_tokens (refresh_token VARCHAR(40) NOT NULL, client_id VARCHAR(80) NOT NULL, user_id VARCHAR(255), expires TIMESTAMP NOT NULL, scope VARCHAR(2000), CONSTRAINT refresh_token_pk PRIMARY KEY (refresh_token));"
|
||
|
|
create_table_users="CREATE TABLE users (id SERIAL NOT NULL, username VARCHAR(255) NOT NULL, CONSTRAINT id_pk PRIMARY KEY (id));"
|
||
|
|
create_table_oauth_scopes="CREATE TABLE oauth_scopes (scope TEXT, is_default BOOLEAN);"
|
||
|
|
|
||
|
|
#Client creation
|
||
|
|
create_client="INSERT INTO oauth_clients (client_id,client_secret,redirect_uri,grant_types,scope,user_id) VALUES ('$client_id','$client_secret','$redirect_uri','$grant_types','$scope','$user_id');"
|
||
|
|
|
||
|
|
###################################################################################################
|