From 665abff5880b74b1ef66cb26a4ebf6a02f901a62 Mon Sep 17 00:00:00 2001
From: Christophe Romain <christophe.romain@process-one.net>
Date: Fri, 28 Sep 2007 13:33:27 +0000
Subject: Added some missing NOT NULL restrictions

SVN Revision: 952
---
 src/odbc/mysql.sql | 6 +++---
 1 file changed, 3 insertions(+), 3 deletions(-)

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

diff --git a/src/odbc/mysql.sql b/src/odbc/mysql.sql
index 5ba85a723..20c53b577 100644
--- a/src/odbc/mysql.sql
+++ b/src/odbc/mysql.sql
@@ -20,9 +20,9 @@ CREATE TABLE rosterusers (
     nick text NOT NULL,
     subscription character(1) NOT NULL,
     ask character(1) NOT NULL,
-    askmessage text,
+    askmessage text NOT NULL,
     server character(1) NOT NULL,
-    subscribe text,
+    subscribe text NOT NULL,
     type text
 ) CHARACTER SET utf8;
 
@@ -41,7 +41,7 @@ CREATE INDEX pk_rosterg_user_jid ON rostergroups(username(75), jid(75));
 
 CREATE TABLE spool (
     username varchar(250) NOT NULL,
-    xml text,
+    xml text NOT NULL,
     seq BIGINT UNSIGNED NOT NULL AUTO_INCREMENT UNIQUE
 ) CHARACTER SET utf8;
 
-- 
cgit v1.2.3

