diff options
| author | zotlabs <mike@macgirvin.com> | 2018-05-20 20:19:11 -0700 |
|---|---|---|
| committer | zotlabs <mike@macgirvin.com> | 2018-05-20 20:19:11 -0700 |
| commit | 0044906fabbfeb837326982bbc8d3fcc64b47fa8 (patch) | |
| tree | aa855fe68a468626b15f9b954c000680bb405b0b /install/schema_postgres.sql | |
| parent | ac8706e919d62a3a487fe3776e03160454ca8992 (diff) | |
| parent | 469809183d232761b8984848c133f9f11f5e7cea (diff) | |
| download | volse-hubzilla-0044906fabbfeb837326982bbc8d3fcc64b47fa8.tar.gz volse-hubzilla-0044906fabbfeb837326982bbc8d3fcc64b47fa8.tar.bz2 volse-hubzilla-0044906fabbfeb837326982bbc8d3fcc64b47fa8.zip | |
Merge branch 'dev' of https://github.com/redmatrix/hubzilla into xdev_merge
Diffstat (limited to 'install/schema_postgres.sql')
| -rw-r--r-- | install/schema_postgres.sql | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index fb845ce9d..d4ffed130 100644 --- a/install/schema_postgres.sql +++ b/install/schema_postgres.sql @@ -1620,14 +1620,14 @@ CREATE TABLE oauth_clients ( redirect_uri VARCHAR(2000), grant_types VARCHAR(80), scope VARCHAR(4000), - user_id VARCHAR(80), + user_id bigint NOT NULL DEFAULT '0', 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), + user_id bigint NOT NULL DEFAULT '0', expires TIMESTAMP NOT NULL, scope VARCHAR(4000), PRIMARY KEY (access_token) @@ -1636,7 +1636,7 @@ CREATE TABLE oauth_access_tokens ( CREATE TABLE oauth_authorization_codes ( authorization_code VARCHAR(40) NOT NULL, client_id VARCHAR(80) NOT NULL, - user_id VARCHAR(255), + user_id bigint NOT NULL DEFAULT '0', redirect_uri VARCHAR(2000), expires TIMESTAMP NOT NULL, scope VARCHAR(4000), @@ -1647,7 +1647,7 @@ CREATE TABLE oauth_authorization_codes ( CREATE TABLE oauth_refresh_tokens ( refresh_token VARCHAR(40) NOT NULL, client_id VARCHAR(80) NOT NULL, - user_id VARCHAR(255), + user_id bigint NOT NULL DEFAULT '0', expires TIMESTAMP NOT NULL, scope VARCHAR(4000), PRIMARY KEY (refresh_token) |