summaryrefslogtreecommitdiff
path: root/database
diff options
context:
space:
mode:
Diffstat (limited to 'database')
-rw-r--r--database/database.mysql1
-rw-r--r--database/updates.inc1
2 files changed, 2 insertions, 0 deletions
diff --git a/database/database.mysql b/database/database.mysql
index 026a20292..f8be88bbc 100644
--- a/database/database.mysql
+++ b/database/database.mysql
@@ -541,6 +541,7 @@ CREATE TABLE search_index (
fromtype varchar(16) default NULL,
score int(10) unsigned default NULL,
KEY sid (sid),
+ KEY fromsid (fromsid),
KEY word (word)
) TYPE=MyISAM;
diff --git a/database/updates.inc b/database/updates.inc
index ac7ad621d..e135ae431 100644
--- a/database/updates.inc
+++ b/database/updates.inc
@@ -1940,6 +1940,7 @@ function update_110() {
fromtype varchar(16) default NULL,
score int(10) unsigned default NULL,
KEY sid (sid),
+ KEY fromsid (fromsid),
KEY word (word)
) TYPE=MyISAM");