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 + database/updates.inc | 1 + 2 files changed, 2 insertions(+) (limited to 'database') 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"); -- cgit v1.2.3