diff options
author | mrjive <mrjive@mrjive.it> | 2018-04-05 10:52:39 +0200 |
---|---|---|
committer | GitHub <noreply@github.com> | 2018-04-05 10:52:39 +0200 |
commit | a7ff2cc5ea11afd7b832bef24866abfb0220d022 (patch) | |
tree | e7dcd63bbfdaa6ae564c60d59ef60edf0e6ba7a7 /install/schema_postgres.sql | |
parent | 20ac91703d54679d2e5080ba2d4985e93986a515 (diff) | |
parent | dcacdd23c87061dc15bd12ed2e959bcbe020c5df (diff) | |
download | volse-hubzilla-a7ff2cc5ea11afd7b832bef24866abfb0220d022.tar.gz volse-hubzilla-a7ff2cc5ea11afd7b832bef24866abfb0220d022.tar.bz2 volse-hubzilla-a7ff2cc5ea11afd7b832bef24866abfb0220d022.zip |
Merge pull request #3 from redmatrix/dev
Dev
Diffstat (limited to 'install/schema_postgres.sql')
-rw-r--r-- | install/schema_postgres.sql | 54 |
1 files changed, 54 insertions, 0 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index a4f6e9253..df94712fe 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -1610,3 +1610,57 @@ ALTER TABLE ONLY users CREATE UNIQUE INDEX users_ukey ON users USING btree (username); + + +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(255), + 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(255), + 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(255), + expires TIMESTAMP NOT NULL, + scope VARCHAR(4000), + PRIMARY KEY (refresh_token) +); + +CREATE TABLE oauth_scopes ( + scope VARCHAR(191) NOT NULL, + is_default SMALLINT, + PRIMARY KEY (scope) +); + +CREATE TABLE oauth_jwt ( + client_id VARCHAR(80) NOT NULL, + subject VARCHAR(80), + public_key VARCHAR(2000) NOT NULL +); + + |