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 /update.php | |
| 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,
Diffstat (limited to 'update.php')
| -rw-r--r-- | update.php | 2 |
1 files changed, 1 insertions, 1 deletions
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() { |