diff options
| author | Mickaël Rémond <mickael.remond@process-one.net> | 2007-07-09 17:22:09 +0000 |
|---|---|---|
| committer | Mickaël Rémond <mickael.remond@process-one.net> | 2007-07-09 17:22:09 +0000 |
| commit | 3fe646c3cba731aa7ec6544916bc46fdfd52ea82 (patch) | |
| tree | 771cb4e34107623716a62400b863d31c2dc2093f /src | |
| parent | * Added missing file. (diff) | |
* 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
Diffstat (limited to '')
| -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, |