Home

Your premium source for custom modification services for phpBB

   logo

HomeForumsBlogMOD ManagerFAQSearch Log in

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
phpbb_search_wordmatch
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.
Column Name Datatype Default Column Description
post_id mediumint(8) unsigned
 0 Foreign key to the phpbb_posts table. This value shows the post that the selected word appears in.
word_id mediumint(8) unsigned
 0 Foreign key to the phpbb_search_wordlist table. This value shows the word contained in the selected post.
title_match tinyint(1)
 0 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.

Table relationships
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
Legend Notes: [Primary Key] [Foreign Key or other Indexed Field(s)] [Glossary Entry]

Glossary | Graphical Database Diagram (Future Feature)


HomeForumsMOD ManagerFAQSearch Register Log in
Not endorsed by or affiliated with the phpBB Group
Powered by phpBB © phpBB Group 		Terms of Service
Web design by MomentsOfLight.com logo