diff options
Diffstat (limited to 'sql')
| -rw-r--r-- | sql/lite.new.sql | 9 | ||||
| -rw-r--r-- | sql/lite.sql | 2 | ||||
| -rw-r--r-- | sql/mssql.sql | 6 | ||||
| -rw-r--r-- | sql/mysql.new.sql | 2 | ||||
| -rw-r--r-- | sql/mysql.sql | 2 | ||||
| -rw-r--r-- | sql/pg.new.sql | 2 | ||||
| -rw-r--r-- | sql/pg.sql | 2 |
7 files changed, 16 insertions, 9 deletions
diff --git a/sql/lite.new.sql b/sql/lite.new.sql index 7264e58c..816b7eba 100644 --- a/sql/lite.new.sql +++ b/sql/lite.new.sql @@ -1,5 +1,5 @@ -- --- ejabberd, Copyright (C) 2002-2019 ProcessOne +-- ejabberd, Copyright (C) 2002-2020 ProcessOne -- -- This program is free software; you can redistribute it and/or -- modify it under the terms of the GNU General Public License as @@ -368,6 +368,13 @@ CREATE TABLE oauth_token ( expire bigint NOT NULL ); +CREATE TABLE oauth_client ( + client_id text PRIMARY KEY, + client_name text NOT NULL, + grant_type text NOT NULL, + options text NOT NULL +); + CREATE TABLE route ( domain text NOT NULL, server_host text NOT NULL, diff --git a/sql/lite.sql b/sql/lite.sql index 0b6bb12c..dfd47199 100644 --- a/sql/lite.sql +++ b/sql/lite.sql @@ -1,5 +1,5 @@ -- --- ejabberd, Copyright (C) 2002-2019 ProcessOne +-- ejabberd, Copyright (C) 2002-2020 ProcessOne -- -- This program is free software; you can redistribute it and/or -- modify it under the terms of the GNU General Public License as diff --git a/sql/mssql.sql b/sql/mssql.sql index 0b884430..1a0587d9 100644 --- a/sql/mssql.sql +++ b/sql/mssql.sql @@ -1,5 +1,5 @@ --
--- ejabberd, Copyright (C) 2002-2019 ProcessOne
+-- ejabberd, Copyright (C) 2002-2020 ProcessOne
--
-- This program is free software; you can redistribute it and/or
-- modify it under the terms of the GNU General Public License as
@@ -26,8 +26,8 @@ CREATE TABLE [dbo].[archive] ( [timestamp] [bigint] NOT NULL,
[peer] [varchar] (250) NOT NULL,
[bare_peer] [varchar] (250) NOT NULL,
- [xml] [text] NOT NULL,
- [txt] [text] NULL,
+ [xml] [ntext] NOT NULL,
+ [txt] [ntext] NULL,
[id] [bigint] IDENTITY(1,1) NOT NULL,
[kind] [varchar] (10) NULL,
[nick] [varchar] (250) NULL,
diff --git a/sql/mysql.new.sql b/sql/mysql.new.sql index 15843fc7..0ee296fb 100644 --- a/sql/mysql.new.sql +++ b/sql/mysql.new.sql @@ -1,5 +1,5 @@ -- --- ejabberd, Copyright (C) 2002-2019 ProcessOne +-- ejabberd, Copyright (C) 2002-2020 ProcessOne -- -- This program is free software; you can redistribute it and/or -- modify it under the terms of the GNU General Public License as diff --git a/sql/mysql.sql b/sql/mysql.sql index 7afc2cf1..80e75eda 100644 --- a/sql/mysql.sql +++ b/sql/mysql.sql @@ -1,5 +1,5 @@ -- --- ejabberd, Copyright (C) 2002-2019 ProcessOne +-- ejabberd, Copyright (C) 2002-2020 ProcessOne -- -- This program is free software; you can redistribute it and/or -- modify it under the terms of the GNU General Public License as diff --git a/sql/pg.new.sql b/sql/pg.new.sql index 59fdfc75..e005cccb 100644 --- a/sql/pg.new.sql +++ b/sql/pg.new.sql @@ -1,5 +1,5 @@ -- --- ejabberd, Copyright (C) 2002-2019 ProcessOne +-- ejabberd, Copyright (C) 2002-2020 ProcessOne -- -- This program is free software; you can redistribute it and/or -- modify it under the terms of the GNU General Public License as @@ -1,5 +1,5 @@ -- --- ejabberd, Copyright (C) 2002-2019 ProcessOne +-- ejabberd, Copyright (C) 2002-2020 ProcessOne -- -- This program is free software; you can redistribute it and/or -- modify it under the terms of the GNU General Public License as |