664
edits
(Created page with '{{DRAFT}} This document refers to the search rewrite of Q4 2009. == Goals == * Improve index time (should be able to index at least once/hour). ** Move from Sphinx 0.9.8 to 0.…') |
(added indices) |
||
| Line 28: | Line 28: | ||
http://sumo-forumux.stage.mozilla.com/ | http://sumo-forumux.stage.mozilla.com/ | ||
The username/password is "support"/"stage". | The username/password is "support"/"stage". | ||
== Indices == | |||
The current sphinx.conf provides the indices, with the indicate attributes: | |||
=== forum_threads === | |||
Returns a '''threadId''' (for a thread) | |||
{| | |||
!attr name!!type!!description | |||
|- | |||
|forumid||int|| | |||
|- | |||
|author_ord||int||crc32(userName) | |||
|- | |||
|status||int||crc32(status) | |||
|- | |||
|created||timestamp|| | |||
|- | |||
|last_updated||timestamp|| | |||
|- | |||
|replies||int||number of replies | |||
|- | |||
|authors||multi int||crc32(userName) for all posters in the thread | |||
|} | |||
=== forum_posts === | |||
Returns a '''threadId''' (for a specific post) | |||
{| | |||
!attr name!!type!!description | |||
|- | |||
|threadid||int||threadId of the actual thread (not the post) | |||
|- | |||
|author_ord||int||crc32(userName) | |||
|- | |||
|status ||int||crc32(status) | |||
|- | |||
|forumid||int||forum id for the thread | |||
|- | |||
|created||timestamp|| | |||
|} | |||
=== wiki_pages === | |||
Returns a '''page_id''' | |||
{| | |||
!attr name!!type!!description | |||
|- | |||
|lastmodif||timestamp|| | |||
|- | |||
|locale||int||crc32(lang) | |||
|- | |||
|tag||int multi||crc32(tag) | |||
|- | |||
|category||int multi||categId | |||
|} | |||
edits