diff options
| author | Dries Buytaert <dries@buytaert.net> | 2002-06-06 18:29:40 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2002-06-06 18:29:40 +0000 |
| commit | 68129fd539c48e600a1402e05c7b3a2eff2c2d89 (patch) | |
| tree | b4c07b99804006da8d1e5cb0a2a97488b41cae17 | |
| parent | 3eb607b8eea4b6f5acfa80bd184fedf558c988af (diff) | |
| download | brdo-68129fd539c48e600a1402e05c7b3a2eff2c2d89.tar.gz brdo-68129fd539c48e600a1402e05c7b3a2eff2c2d89.tar.bz2 | |
- 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,
| -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() { |