From b6eee48c887e66b195a2b88fe905872af83bbade Mon Sep 17 00:00:00 2001 From: Dries Buytaert Date: Thu, 4 Nov 2004 06:47:03 +0000 Subject: - 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. --- database/database.mysql | 1 + 1 file changed, 1 insertion(+) (limited to 'database/database.mysql') 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; -- cgit v1.2.3