summaryrefslogtreecommitdiff
path: root/database/database.mysql
diff options
context:
space:
mode:
authorDries Buytaert <dries@buytaert.net>2004-11-04 06:47:03 +0000
committerDries Buytaert <dries@buytaert.net>2004-11-04 06:47:03 +0000
commitb6eee48c887e66b195a2b88fe905872af83bbade (patch)
tree7f3f4f6b67637670eb654578b66bed204e9c4dab /database/database.mysql
parentd13943e245403e046168c921a57c13f08bfc6ca9 (diff)
downloadbrdo-b6eee48c887e66b195a2b88fe905872af83bbade.tar.gz
brdo-b6eee48c887e66b195a2b88fe905872af83bbade.tar.bz2
- Patch #12232 by Steven: more search improvements:
+ When a comment is posted, a node needs to be re-indexed. Luckily, we can use node_comment_statistics for this easily. + When a node is deleted, it should be deleted from the search index as well. + The search wipe didn't properly remove links to nodes from the index. + Section url was faulty in _help. + Minor code rearrangement.
Diffstat (limited to 'database/database.mysql')
-rw-r--r--database/database.mysql1
1 files changed, 1 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;