diff options
Diffstat (limited to 'src')
| -rw-r--r-- | src/odbc/mssql.sql | 2 | ||||
| -rw-r--r-- | src/odbc/mysql.sql | 2 | ||||
| -rw-r--r-- | src/odbc/pg.sql | 2 |
3 files changed, 3 insertions, 3 deletions
diff --git a/src/odbc/mssql.sql b/src/odbc/mssql.sql index 13e9f4aa7..4bed2ed32 100644 --- a/src/odbc/mssql.sql +++ b/src/odbc/mssql.sql @@ -105,7 +105,7 @@ GO CREATE TABLE [dbo].[rosterusers] (
[username] [varchar] (250) NOT NULL ,
[jid] [varchar] (250) NOT NULL ,
- [nick] [varchar] (50) NULL ,
+ [nick] [varchar] (50) NOT NULL ,
[subscription] [char] (1) NOT NULL ,
[ask] [char] (1) NOT NULL ,
[askmessage] [varchar] (250) NOT NULL ,
diff --git a/src/odbc/mysql.sql b/src/odbc/mysql.sql index ca1db6571..5ba85a723 100644 --- a/src/odbc/mysql.sql +++ b/src/odbc/mysql.sql @@ -17,7 +17,7 @@ CREATE TABLE last ( CREATE TABLE rosterusers ( username varchar(250) NOT NULL, jid varchar(250) NOT NULL, - nick text, + nick text NOT NULL, subscription character(1) NOT NULL, ask character(1) NOT NULL, askmessage text, diff --git a/src/odbc/pg.sql b/src/odbc/pg.sql index b8efb0187..46411818a 100644 --- a/src/odbc/pg.sql +++ b/src/odbc/pg.sql @@ -15,7 +15,7 @@ CREATE TABLE last ( CREATE TABLE rosterusers ( username text NOT NULL, jid text NOT NULL, - nick text, + nick text NOT NULL, subscription character(1) NOT NULL, ask character(1) NOT NULL, askmessage text NOT NULL, |