Development Wiki

Difference between revisions of "Tables"

From phpBB Development Wiki

Line 192: Line 192:
* Script used to create this list: [[User:Pyramide/DB2wiki]].<br><br>
* Script used to create this list: [[User:Pyramide/DB2wiki]].
* Updated to reflect the wiki guidelines (battye, January 2009)<br><br>

Revision as of 11:30, 2 January 2010

Tables –– List of Database Tables used within phpBB3


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


  • Script used to create this list: User:Pyramide/DB2wiki.
  • Updated to reflect the wiki guidelines (battye, January 2009)