diff options
| -rw-r--r-- | ChangeLog | 7 | ||||
| -rw-r--r-- | src/odbc/mssql.sql | 2 | ||||
| -rw-r--r-- | src/odbc/mysql.sql | 2 | ||||
| -rw-r--r-- | src/odbc/pg.sql | 2 |
4 files changed, 10 insertions, 3 deletions
@@ -1,3 +1,10 @@ +2007-07-09 Mickael Remond <mickael.remond@process-one.net> + + * src/odbc/mssql.sql: Nickname cannot be null in rosterusers table + (MSSQL) + * src/odbc/mysql.sql: Likewise + * src/odbc/pg.sql: Likewise + 2007-06-29 Mickael Remond <mickael.remond@process-one.net> * src/ejabberd_config.erl: Normalize hostnames in config file. If mixed 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, |