From 3fe646c3cba731aa7ec6544916bc46fdfd52ea82 Mon Sep 17 00:00:00 2001 From: =?UTF-8?q?Micka=C3=ABl=20R=C3=A9mond?= Date: Mon, 9 Jul 2007 17:22:09 +0000 Subject: * src/odbc/mssql.sql: Nickname cannot be null in rosterusers table (MSSQL) * src/odbc/mysql.sql: Likewise * src/odbc/pg.sql: Likewise SVN Revision: 809 --- src/odbc/mssql.sql | 2 +- src/odbc/mysql.sql | 2 +- src/odbc/pg.sql | 2 +- 3 files changed, 3 insertions(+), 3 deletions(-) (limited to 'src') 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, -- cgit v1.2.3