diff options
| author | Dries Buytaert <dries@buytaert.net> | 2004-11-04 06:47:03 +0000 |
|---|---|---|
| committer | Dries Buytaert <dries@buytaert.net> | 2004-11-04 06:47:03 +0000 |
| commit | b6eee48c887e66b195a2b88fe905872af83bbade (patch) | |
| tree | 7f3f4f6b67637670eb654578b66bed204e9c4dab /database | |
| parent | d13943e245403e046168c921a57c13f08bfc6ca9 (diff) | |
| download | brdo-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')
| -rw-r--r-- | database/database.mysql | 1 | ||||
| -rw-r--r-- | database/updates.inc | 1 |
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"); |