diff options
| -rw-r--r-- | database/database.mysql | 12 | ||||
| -rw-r--r-- | update.php | 2 |
2 files changed, 7 insertions, 7 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; # 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() { |