Development Wiki

Difference between revisions of "Tables"

From phpBB Development Wiki

m (Changed on 13-02-2020)
m (Reflects tables for 3.2 and 3.3)
Line 213: Line 213:
== Reflects tables for 3.2 and 3.3 ==
== Reflects tables for 3.2 and 3.3 ==
This chnage affects only the tables list at the present time, more to come.
This change affects only the tables list at the present time, more to come.

Revision as of 06:51, 13 February 2020

Tables –– List of Database Tables used within phpBB3

Tables 3.2/3.3

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_config_text tbd
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_ext tbd
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 Stores who is logged in to password protected forums
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_login_attempts tbd
phpbb_migrations tbd
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_notification_types tbd
phpbb_notifications tbd
phpbb_oauth_accounts tbd
phpbb_oauth_states tbd
phpbb_oauth_tokens tbd
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
phpbb_teampage tbd
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_user_notifications tbd
phpbb_users Registered users
phpbb_warnings Warnings given to users
phpbb_words censored words
phpbb_zebra Friends and foes

Reflects tables for 3.2 and 3.3

This change affects only the tables list at the present time, more to come.


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

  • Updated to reflect the phpBb 3.1.x Tables too --3Di (talk) 11:57, 19 September 2015 (UTC)