From 3fe646c3cba731aa7ec6544916bc46fdfd52ea82 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Micka=C3=ABl=20R=C3=A9mond?=
 <mickael.remond@process-one.net>
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 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'src/odbc/mssql.sql')

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

