From 469809183d232761b8984848c133f9f11f5e7cea Mon Sep 17 00:00:00 2001
From: Mario <mario@mariovavti.com>
Date: Sun, 20 May 2018 22:42:47 +0200
Subject: 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

---
 install/schema_postgres.sql | 8 ++++----
 1 file changed, 4 insertions(+), 4 deletions(-)

(limited to 'install/schema_postgres.sql')

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)
-- 
cgit v1.2.3

