1 files changed, 6 insertions, 6 deletions
diff --git a/database/database.mysql b/database/database.mysql
index e4c82f772..147ccfbb0 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -360,12 +360,12 @@ CREATE TABLE role (
 #
 
 CREATE TABLE search_index (
-  word varchar(50) default NULL,
-  lno int(10) unsigned default NULL,
-  type varchar(16) default NULL,
-  count int(10) unsigned default NULL,
-  KEY lno (lno),
-  KEY word (word)
+ word varchar(50) NOT NULL,
+ lno int(10) unsigned NOT NULL,
+ type varchar(16) default NULL,
+ count int(10) unsigned default NULL,
+ KEY lno (lno),
+ KEY word (word)
 ) TYPE=MyISAM;
 
 #