|The phpBB Doctor is currently available for private clients only. At this time we are not accepting any new work until we can clear out our current backlog. Thank you for your patience.|
|Tables Table Structure||
Cross-reference list of posts to words, used by the search algorithm. Essentially this is a listing of which words in the word list appear in which posts. It is used to provide a very effective way to search a large amount of text very efficiently.
||Foreign key to the phpbb_posts table. This value shows the post that the selected word appears in.
||Foreign key to the phpbb_search_wordlist table. This value shows the word contained in the selected post.
||A bit flag (0 or 1) that shows whether the word was included in the post subject or not. Values are No = 0 (Default) and Yes = 1. Used by the search screen, as the user can select title + body or body only.
Legend Notes: [Primary Key] [Foreign Key or other Indexed Field(s)] [Glossary Entry]
Graphical Database Diagram (Future Feature)
|Post Search Word cross reference
||phpbb_posts.post_id = phpbb_search_wordmatch.post_id
|Search Word Post cross reference
||phpbb_search_wordlist.word_id = phpbb_search_wordmatch.word_id