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, --- update.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'update.php') diff --git a/update.php b/update.php index 134c6e641..2e5592453 100644 --- a/update.php +++ b/update.php @@ -326,7 +326,7 @@ function update_22() { } function update_23() { - update_sql("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));"); + update_sql("CREATE TABLE search_index (word varchar(50) default NOT NULL, lno int(10) unsigned default NOT NULL, type varchar(16) default NOT NULL, count int(10) unsigned default NOT NULL, KEY lno (lno), KEY word (word));"); } function update_24() { -- cgit v1.2.3