diff options
| -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 { |