diff options
| author | Mario <mario@mariovavti.com> | 2018-05-20 22:42:47 +0200 |
|---|---|---|
| committer | Mario Vavti <mario@mariovavti.com> | 2018-05-20 22:55:13 +0200 |
| commit | 5b48eb3657a7cf6593b4c1f6ee17bf32eaa402af (patch) | |
| tree | 5d8e11cb193526cbc4c165d9b5fce12ab26bc1db /install | |
| parent | 43f04e4bc0b041a4e6450f6aad3e9045fb5eb3cf (diff) | |
| download | volse-hubzilla-5b48eb3657a7cf6593b4c1f6ee17bf32eaa402af.tar.gz volse-hubzilla-5b48eb3657a7cf6593b4c1f6ee17bf32eaa402af.tar.bz2 volse-hubzilla-5b48eb3657a7cf6593b4c1f6ee17bf32eaa402af.zip | |
update oauth related tables to use bigint/int(10) for user_id column. this is to be more consistent with the rest of the tables and fixes issue #1180
Diffstat (limited to 'install')
| -rw-r--r-- | install/schema_mysql.sql | 8 | ||||
| -rw-r--r-- | install/schema_postgres.sql | 8 |
2 files changed, 8 insertions, 8 deletions
diff --git a/install/schema_mysql.sql b/install/schema_mysql.sql index 9bf91fc51..9685a878e 100644 --- a/install/schema_mysql.sql +++ b/install/schema_mysql.sql @@ -1606,14 +1606,14 @@ CREATE TABLE if not exists oauth_clients ( redirect_uri VARCHAR(2000), grant_types VARCHAR(80), scope VARCHAR(4000), - user_id VARCHAR(80), + user_id int(10) unsigned NOT NULL DEFAULT 0, PRIMARY KEY (client_id) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; CREATE TABLE if not exists oauth_access_tokens ( access_token VARCHAR(40) NOT NULL, client_id VARCHAR(80) NOT NULL, - user_id VARCHAR(255), + user_id int(10) unsigned NOT NULL DEFAULT 0, expires TIMESTAMP NOT NULL, scope VARCHAR(4000), PRIMARY KEY (access_token) @@ -1622,7 +1622,7 @@ CREATE TABLE if not exists oauth_access_tokens ( CREATE TABLE if not exists oauth_authorization_codes ( authorization_code VARCHAR(40) NOT NULL, client_id VARCHAR(80) NOT NULL, - user_id VARCHAR(255), + user_id int(10) unsigned NOT NULL DEFAULT 0, redirect_uri VARCHAR(2000), expires TIMESTAMP NOT NULL, scope VARCHAR(4000), @@ -1633,7 +1633,7 @@ CREATE TABLE if not exists oauth_authorization_codes ( CREATE TABLE if not exists oauth_refresh_tokens ( refresh_token VARCHAR(40) NOT NULL, client_id VARCHAR(80) NOT NULL, - user_id VARCHAR(255), + user_id int(10) unsigned NOT NULL DEFAULT 0, expires TIMESTAMP NOT NULL, scope VARCHAR(4000), PRIMARY KEY (refresh_token) diff --git a/install/schema_postgres.sql b/install/schema_postgres.sql index 3fba5b546..4584e4f2e 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) |