From 68129fd539c48e600a1402e05c7b3a2eff2c2d89 Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Thu, 6 Jun 2002 18:29:40 +0000 Subject: - Changed some "default NULL"s to "default NOT NULL"s as this only works on recent MySQL versions. I included the diffs for review. update.php: - update_sql("CREATE TABLE search_index (word varchar(50) default NULL, lno in + update_sql("CREATE TABLE search_index (word varchar(50) default NOT NULL, ln database.mysql: - word varchar(50) default NULL, - lno int(10) unsigned default NULL, - type varchar(16) default NULL, - count int(10) unsigned default NULL, + word varchar(50) NOT NULL, + lno int(10) unsigned NOT NULL, + type varchar(16) default NULL, + count int(10) unsigned default NULL, --- database/database.mysql | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) (limited to 'database') 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; # -- cgit v1.2.3