Tables
From phpBB Development Wiki
Tables –– List of Database Tables used within phpBB3
Tables
| name | content |
|---|---|
| phpbb_acl_groups | Permission roles and/or individual permissions assigned to groups |
| phpbb_acl_options | List of possible permissions |
| phpbb_acl_roles | Permission roles (Standard Moderator, Simple Moderator etc.) |
| phpbb_acl_roles_data | Permissions each role contains |
| phpbb_acl_users | Permission roles and/or individual permissions assigned to users |
| phpbb_attachments | Information on attachments (Post, physical filename, original filename, MIME type...) |
| phpbb_banlist | Banned users/IPs/emails... |
| phpbb_bbcodes | Custom BBCodes |
| phpbb_bookmarks | Bookmarked topics |
| phpbb_bots | Spiders/Robots |
| phpbb_config | Configuration information ($config table) |
| phpbb_confirm | Contains session information for confirm pages ("are you sure you want to delete foo") |
| phpbb_disallow | Disallowed usernames |
| phpbb_drafts | Drafts of future posts/private messages |
| phpbb_extension_groups | Extensions Groups (associate extensions with a file type - Images, text...) |
| phpbb_extensions | Extensions (.xxx) allowed for attachments |
| phpbb_forums | Forums (Name, description, rules...) |
| phpbb_forums_access | tbd |
| phpbb_forums_track | Unread post information is stored here |
| phpbb_forums_watch | Subscribed forums |
| phpbb_groups | Usergroups |
| phpbb_icons | Post icons |
| phpbb_lang | Installed languages |
| phpbb_log | Administration/Moderation/Error logs |
| phpbb_moderator_cache | Who is a moderator in which forum (for display on forum index) |
| phpbb_modules | Configuration of acp, mcp and ucp modules |
| phpbb_poll_options | Options text of all votes ("Yes", "No", "Maybe"...) |
| phpbb_poll_votes | Users which have voted on a poll |
| phpbb_posts | Topics posts |
| phpbb_privmsgs | Private messages text |
| phpbb_privmsgs_folder | Custom privates messages folders (for each user) |
| phpbb_privmsgs_rules | Messages rules, e.g. "if the username of the sender is ..., move the message to this folder". |
| phpbb_privmsgs_to | Information (sender, new, replied...) on private messages. |
| phpbb_profile_fields | Custom profile fields (name, min/max number of characters, allowed characters...) |
| phpbb_profile_fields_data | Data that users enter in custom profile fields |
| phpbb_profile_fields_lang | tbd (empty on my forum with some custom profile fields) |
| phpbb_profile_lang | Localized name and description of custom profile fields (presented to users) |
| phpbb_ranks | Ranks (Name, image, minimal # of posts) |
| phpbb_reports | Reported posts |
| phpbb_reports_reasons | Reasons for reported posts and disapprovals |
| phpbb_search_results | Last searches |
| phpbb_search_wordlist | Indexed words (for search) |
| phpbb_search_wordmatch | Associate a post with indexed words |
| phpbb_sessions | Sessions (to identify users browsing the forum) |
| phpbb_sessions_keys | Autologin feature |
| phpbb_sitelist | Secure Downloads of attachments - list of IPs and hostnames |
| phpbb_smilies | Smilies (text => image) |
| phpbb_styles | Style = template + theme + imageset |
| phpbb_styles_imageset | Imagesets |
| phpbb_styles_template | tbd |
| phpbb_styles_template_data | tbd |
| phpbb_styles_theme | theme = css file |
| phpbb_topics | Topics in forums |
| phpbb_topics_posted | Who posted to which topic (used for the small dots in viewforum) |
| phpbb_topics_track | Unread post information is stored here |
| phpbb_topics_watch | "notify me upon replies" |
| phpbb_user_group | Users groups |
| phpbb_users | Registered users |
| phpbb_warnings | Warnings given to users |
| phpbb_words | censored words |
| phpbb_zebra | Friends and foes |
Info
- Script used to create this list: User:Pyramide/DB2wiki.
