diff options
| author | Mickaël Rémond <mickael.remond@process-one.net> | 2007-02-19 14:19:27 +0000 |
|---|---|---|
| committer | Mickaël Rémond <mickael.remond@process-one.net> | 2007-02-19 14:19:27 +0000 |
| commit | 090ba85424f06219b7714f8ffc1ba9dcc106af93 (patch) | |
| tree | 08bf4fa2160ca79682755f947f14dd7001f7c809 /src | |
| parent | * src/ejabberd_auth_ldap.erl: prevent anonymous bind on LDAP servers (diff) | |
* src/odbc/pg.sql: last table, state column cannot be NULL (EJAB-191).
* src/odbc/mysql.sql: likewise.
* src/odbc/mssql.sql. likewise.
SVN Revision: 732
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 581a21182..13e9f4aa7 100644 --- a/src/odbc/mssql.sql +++ b/src/odbc/mssql.sql @@ -91,7 +91,7 @@ GO CREATE TABLE [dbo].[last] (
[username] [varchar] (250) NOT NULL ,
[seconds] [varchar] (50) NOT NULL ,
- [state] [varchar] (100) NULL ,
+ [state] [varchar] (100) NOT NULL ,
) ON [PRIMARY]
GO
diff --git a/src/odbc/mysql.sql b/src/odbc/mysql.sql index 3af2f65fd..ca1db6571 100644 --- a/src/odbc/mysql.sql +++ b/src/odbc/mysql.sql @@ -10,7 +10,7 @@ CREATE TABLE users ( CREATE TABLE last ( username varchar(250) PRIMARY KEY, seconds text NOT NULL, - state text + state text NOT NULl ) CHARACTER SET utf8; diff --git a/src/odbc/pg.sql b/src/odbc/pg.sql index 9f632d215..b8efb0187 100644 --- a/src/odbc/pg.sql +++ b/src/odbc/pg.sql @@ -8,7 +8,7 @@ CREATE TABLE users ( CREATE TABLE last ( username text PRIMARY KEY, seconds text NOT NULL, - state text + state text NOT NULL ); |