aboutsummaryrefslogtreecommitdiff
path: root/src
diff options
context:
space:
mode:
Diffstat (limited to 'src')
-rw-r--r--src/odbc/mssql.sql2
-rw-r--r--src/odbc/mysql.sql2
-rw-r--r--src/odbc/pg.sql2
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
);