diff options
| author | Dries Buytaert <dries@buytaert.net> | 2004-04-24 07:50:39 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2004-04-24 07:50:39 +0000 |
| commit | df974508342cba397abf9c134b3eedaba5678b5a (patch) | |
| tree | 190e2ef9de378c07c603b40be7cd2a25a134c136 | |
| parent | 33eb82e16f97e0a97f4a4400b9ee671c4f35d639 (diff) | |
| download | brdo-df974508342cba397abf9c134b3eedaba5678b5a.tar.gz brdo-df974508342cba397abf9c134b3eedaba5678b5a.tar.bz2 | |
- Patch #7286 by LiDave: improved filter table indices. I updated database/updates.inc as well.
| -rw-r--r-- | database/database.mysql | 2 | ||||
| -rw-r--r-- | database/database.pgsql | 2 | ||||
| -rw-r--r-- | database/updates.inc | 2 |
3 files changed, 3 insertions, 3 deletions
diff --git a/database/database.mysql b/database/database.mysql index 698d81d2d..dfe3f7a74 100644 --- a/database/database.mysql +++ b/database/database.mysql @@ -174,7 +174,7 @@ CREATE TABLE feed ( CREATE TABLE filters ( module varchar(64) NOT NULL default '', weight tinyint(2) DEFAULT '0' NOT NULL, - KEY weight (weight) + KEY module (module) ) TYPE=MyISAM; -- diff --git a/database/database.pgsql b/database/database.pgsql index 6d3da335c..187ee0a76 100644 --- a/database/database.pgsql +++ b/database/database.pgsql @@ -173,7 +173,7 @@ CREATE TABLE feed ( CREATE TABLE filters ( module varchar(64) NOT NULL default '', weight smallint DEFAULT '0' NOT NULL, - PRIMARY KEY (weight) + PRIMARY KEY (module) ); -- diff --git a/database/updates.inc b/database/updates.inc index 54ca79eb1..fffa8e130 100644 --- a/database/updates.inc +++ b/database/updates.inc @@ -747,7 +747,7 @@ function update_78() { $ret[] = update_sql("CREATE TABLE {filters} ( module varchar(64) NOT NULL default '', weight tinyint(2) DEFAULT '0' NOT NULL, - KEY weight (weight) + KEY module (module) )"); } else { |