phpBB

Development Wiki

Difference between revisions of "Tables"

From phpBB Development Wiki

m (ropasc4)
m (Info)
 
(14 intermediate revisions by 7 users not shown)
Line 1: Line 1:
racerchia
+
Tables –– List of Database Tables used within phpBB3
List of all tables in olympus (as of B4).
+
 
+
Get the script used to create these pages: [[User:Pyramide/DB2wiki]].
+
  
 +
==Tables 3.2/3.3==
 
{|border="1" cellspacing="0" cellpadding="3"
 
{|border="1" cellspacing="0" cellpadding="3"
 
! name
 
! name
 
! content
 
! content
 
|-
 
|-
| [[/phpbb_acl_groups|phpbb_acl_groups]]
+
| [[Table.phpbb_acl_groups|phpbb_acl_groups]]
 
| Permission roles and/or individual permissions assigned to groups
 
| Permission roles and/or individual permissions assigned to groups
 
|-
 
|-
| [[/phpbb_acl_options|phpbb_acl_options]]
+
| [[Table.phpbb_acl_options|phpbb_acl_options]]
 
| List of possible permissions
 
| List of possible permissions
 
|-
 
|-
| [[/phpbb_acl_roles|phpbb_acl_roles]]
+
| [[Table.phpbb_acl_roles|phpbb_acl_roles]]
 
| Permission roles (Standard Moderator, Simple Moderator etc.)
 
| Permission roles (Standard Moderator, Simple Moderator etc.)
 
|-
 
|-
| [[/phpbb_acl_roles_data|phpbb_acl_roles_data]]
+
| [[Table.phpbb_acl_roles_data|phpbb_acl_roles_data]]
| This table stores which permissions each role contains
+
| Permissions each role contains
 
|-
 
|-
| [[/phpbb_acl_users|phpbb_acl_users]]
+
| [[Table.phpbb_acl_users|phpbb_acl_users]]
 
| Permission roles and/or individual permissions assigned to users
 
| Permission roles and/or individual permissions assigned to users
 
|-
 
|-
| [[/phpbb_attachments|phpbb_attachments]]
+
| [[Table.phpbb_attachments|phpbb_attachments]]
| Informations on attachments (Post, physical filename, original filename, MIME type...)
+
| Information on attachments (Post, physical filename, original filename, MIME type...)
 
|-
 
|-
| [[/phpbb_banlist|phpbb_banlist]]
+
| [[Table.phpbb_banlist|phpbb_banlist]]
 
| Banned users/IPs/emails...
 
| Banned users/IPs/emails...
 
|-
 
|-
| [[/phpbb_bbcodes|phpbb_bbcodes]]
+
| [[Table.phpbb_bbcodes|phpbb_bbcodes]]
 
| Custom BBCodes
 
| Custom BBCodes
 
|-
 
|-
| [[/phpbb_bookmarks|phpbb_bookmarks]]
+
| [[Table.phpbb_bookmarks|phpbb_bookmarks]]
 
| Bookmarked topics
 
| Bookmarked topics
 
|-
 
|-
| [[/phpbb_bots|phpbb_bots]]
+
| [[Table.phpbb_bots|phpbb_bots]]
 
| Spiders/Robots
 
| Spiders/Robots
 
|-
 
|-
| [[/phpbb_config|phpbb_config]]
+
| [[Table.phpbb_config|phpbb_config]]
| Configuration informations ($config table)
+
| Configuration information ($config table)
 
|-
 
|-
| [[/phpbb_confirm|phpbb_confirm]]
+
| [[Table.phpbb_config_text|phpbb_config_text]]
 +
| tbd
 +
|-
 +
| [[Table.phpbb_confirm|phpbb_confirm]]
 
| Contains session information for confirm pages ("are you sure you want to delete foo")
 
| Contains session information for confirm pages ("are you sure you want to delete foo")
 
|-
 
|-
| [[/phpbb_disallow|phpbb_disallow]]
+
| [[Table.phpbb_disallow|phpbb_disallow]]
 
| Disallowed usernames
 
| Disallowed usernames
 
|-
 
|-
| [[/phpbb_drafts|phpbb_drafts]]
+
| [[Table.phpbb_drafts|phpbb_drafts]]
 
| Drafts of future posts/private messages
 
| Drafts of future posts/private messages
 
|-
 
|-
| [[/phpbb_extension_groups|phpbb_extension_groups]]
+
| [[Table.phpbb_ext|phpbb_ext]]
 +
| tbd
 +
|-
 +
| [[Table.phpbb_extension_groups|phpbb_extension_groups]]
 
| Extensions Groups (associate extensions with a file type - Images, text...)
 
| Extensions Groups (associate extensions with a file type - Images, text...)
 
|-
 
|-
| [[/phpbb_extensions|phpbb_extensions]]
+
| [[Table.phpbb_extensions|phpbb_extensions]]
 
| Extensions (.xxx) allowed for attachments
 
| Extensions (.xxx) allowed for attachments
 
|-
 
|-
| [[/phpbb_forums|phpbb_forums]]
+
| [[Table.phpbb_forums|phpbb_forums]]
 
| Forums (Name, description, rules...)
 
| Forums (Name, description, rules...)
 
|-
 
|-
| [[/phpbb_forums_access|phpbb_forums_access]]
+
| [[Table.phpbb_forums_access|phpbb_forums_access]]
| tbd
+
| Stores who is logged in to password protected forums
 
|-
 
|-
| [[/phpbb_forums_track|phpbb_forums_track]]
+
| [[Table.phpbb_forums_track|phpbb_forums_track]]
| unread post information is stored here
+
| Unread post information is stored here
 
|-
 
|-
| [[/phpbb_forums_watch|phpbb_forums_watch]]
+
| [[Table.phpbb_forums_watch|phpbb_forums_watch]]
| subscribed forums
+
| Subscribed forums
 
|-
 
|-
| [[/phpbb_groups|phpbb_groups]]
+
| [[Table.phpbb_groups|phpbb_groups]]
 
| Usergroups
 
| Usergroups
 
|-
 
|-
| [[/phpbb_icons|phpbb_icons]]
+
| [[Table.phpbb_icons|phpbb_icons]]
 
| Post icons
 
| Post icons
 
|-
 
|-
| [[/phpbb_lang|phpbb_lang]]
+
| [[Table.phpbb_lang|phpbb_lang]]
| installed languages
+
| Installed languages
 
|-
 
|-
| [[/phpbb_log|phpbb_log]]
+
| [[Table.phpbb_log|phpbb_log]]
 
| Administration/Moderation/Error logs
 
| Administration/Moderation/Error logs
 
|-
 
|-
| [[/phpbb_moderator_cache|phpbb_moderator_cache]]
+
| [[Table.phpbb_login_attempts|phpbb_login_attempts]]
| who is moderator in which forum (for display on forum index)
+
| tbd
 
|-
 
|-
| [[/phpbb_modules|phpbb_modules]]
+
| [[Table.phpbb_migrations|phpbb_migrations]]
| configuration of acp, mcp and ucp modules
+
| tbd
 +
|-
 +
| [[Table.phpbb_moderator_cache|phpbb_moderator_cache]]
 +
| Who is a moderator in which forum (for display on forum index)
 +
|-
 +
| [[Table.phpbb_modules|phpbb_modules]]
 +
| Configuration of acp, mcp and ucp modules
 +
|-
 +
| [[Table.phpbb_notification_types|phpbb_notification_types]]
 +
| tbd
 +
|-
 +
| [[Table.phpbb_notifications|phpbb_notifications]]
 +
| tbd
 +
|-
 +
| [[Table.phpbb_oauth_accounts|phpbb_oauth_accounts]]
 +
| tbd
 +
|-
 +
| [[Table.phpbb_oauth_states|phpbb_oauth_states]]
 +
| tbd
 +
|-
 +
| [[Table.phpbb_oauth_tokens|phpbb_oauth_tokens]]
 +
| tbd
 
|-
 
|-
| [[/phpbb_poll_options|phpbb_poll_options]]
+
| [[Table.phpbb_poll_options|phpbb_poll_options]]
 
| Options text of all votes ("Yes", "No", "Maybe"...)
 
| Options text of all votes ("Yes", "No", "Maybe"...)
 
|-
 
|-
| [[/phpbb_poll_votes|phpbb_poll_votes]]
+
| [[Table.phpbb_poll_votes|phpbb_poll_votes]]
| Users which have voted to a poll
+
| Users which have voted on a poll
 
|-
 
|-
| [[/phpbb_posts|phpbb_posts]]
+
| [[Table.phpbb_posts|phpbb_posts]]
| All topics posts
+
| Topics posts
 
|-
 
|-
| [[/phpbb_privmsgs|phpbb_privmsgs]]
+
| [[Table.phpbb_privmsgs|phpbb_privmsgs]]
| All private messages text
+
| Private messages text
 
|-
 
|-
| [[/phpbb_privmsgs_folder|phpbb_privmsgs_folder]]
+
| [[Table.phpbb_privmsgs_folder|phpbb_privmsgs_folder]]
 
| Custom privates messages folders (for each user)
 
| Custom privates messages folders (for each user)
 
|-
 
|-
| [[/phpbb_privmsgs_rules|phpbb_privmsgs_rules]]
+
| [[Table.phpbb_privmsgs_rules|phpbb_privmsgs_rules]]
 
| Messages rules, e.g. "if the username of the sender is ..., move the message to this folder".
 
| Messages rules, e.g. "if the username of the sender is ..., move the message to this folder".
 
|-
 
|-
| [[/phpbb_privmsgs_to|phpbb_privmsgs_to]]
+
| [[Table.phpbb_privmsgs_to|phpbb_privmsgs_to]]
| Some informations (sender, new, replied...) on private messages.
+
| Information (sender, new, replied...) on private messages.
 
|-
 
|-
| [[/phpbb_profile_fields|phpbb_profile_fields]]
+
| [[Table.phpbb_profile_fields|phpbb_profile_fields]]
| Custom rofile fields (name, min/max number of characters, allowed characters...)
+
| Custom profile fields (name, min/max number of characters, allowed characters...)
 
|-
 
|-
| [[/phpbb_profile_fields_data|phpbb_profile_fields_data]]
+
| [[Table.phpbb_profile_fields_data|phpbb_profile_fields_data]]
| Data that users enter in custom profile fields)
+
| Data that users enter in custom profile fields
 
|-
 
|-
| [[/phpbb_profile_fields_lang|phpbb_profile_fields_lang]]
+
| [[Table.phpbb_profile_fields_lang|phpbb_profile_fields_lang]]
 
| tbd (empty on my forum with some custom profile fields)
 
| tbd (empty on my forum with some custom profile fields)
 
|-
 
|-
| [[/phpbb_profile_lang|phpbb_profile_lang]]
+
| [[Table.phpbb_profile_lang|phpbb_profile_lang]]
 
| Localized name and description of custom profile fields (presented to users)
 
| Localized name and description of custom profile fields (presented to users)
 
|-
 
|-
| [[/phpbb_ranks|phpbb_ranks]]
+
| [[Table.phpbb_ranks|phpbb_ranks]]
 
| Ranks (Name, image, minimal # of posts)
 
| Ranks (Name, image, minimal # of posts)
 
|-
 
|-
| [[/phpbb_reports|phpbb_reports]]
+
| [[Table.phpbb_reports|phpbb_reports]]
 
| Reported posts
 
| Reported posts
 
|-
 
|-
| [[/phpbb_reports_reasons|phpbb_reports_reasons]]
+
| [[Table.phpbb_reports_reasons|phpbb_reports_reasons]]
| reasons for post reports and disapprovals
+
| Reasons for reported posts and disapprovals
 
|-
 
|-
| [[/phpbb_search_results|phpbb_search_results]]
+
| [[Table.phpbb_search_results|phpbb_search_results]]
 
| Last searches
 
| Last searches
 
|-
 
|-
| [[/phpbb_search_wordlist|phpbb_search_wordlist]]
+
| [[Table.phpbb_search_wordlist|phpbb_search_wordlist]]
 
| Indexed words (for search)
 
| Indexed words (for search)
 
|-
 
|-
| [[/phpbb_search_wordmatch|phpbb_search_wordmatch]]
+
| [[Table.phpbb_search_wordmatch|phpbb_search_wordmatch]]
 
| Associate a post with indexed words
 
| Associate a post with indexed words
 
|-
 
|-
| [[/phpbb_sessions|phpbb_sessions]]
+
| [[Table.phpbb_sessions|phpbb_sessions]]
 
| Sessions (to identify users browsing the forum)
 
| Sessions (to identify users browsing the forum)
 
|-
 
|-
| [[/phpbb_sessions_keys|phpbb_sessions_keys]]
+
| [[Table.phpbb_sessions_keys|phpbb_sessions_keys]]
 
| Autologin feature
 
| Autologin feature
 
|-
 
|-
| [[/phpbb_sitelist|phpbb_sitelist]]
+
| [[Table.phpbb_sitelist|phpbb_sitelist]]
 
| Secure Downloads of attachments - list of IPs and hostnames
 
| Secure Downloads of attachments - list of IPs and hostnames
 
|-
 
|-
| [[/phpbb_smilies|phpbb_smilies]]
+
| [[Table.phpbb_smilies|phpbb_smilies]]
 
| Smilies (text => image)
 
| Smilies (text => image)
 
|-
 
|-
| [[/phpbb_styles|phpbb_styles]]
+
| [[Table.phpbb_styles|phpbb_styles]]
| Style = template + theme + imageset
+
| Style = template + theme
 
|-
 
|-
| [[/phpbb_styles_imageset|phpbb_styles_imageset]]
+
| [[Table.phpbb_teampage|phpbb_teampage]]
| [[Templating_Tutorial#Customizing_the_Imageset|Imagesets]]
+
|-
+
| [[/phpbb_styles_template|phpbb_styles_template]]
+
 
| tbd
 
| tbd
 
|-
 
|-
| [[/phpbb_styles_template_data|phpbb_styles_template_data]]
+
| [[Table.phpbb_topics|phpbb_topics]]
| tbd
+
|-
+
| [[/phpbb_styles_theme|phpbb_styles_theme]]
+
| theme = css file
+
|-
+
| [[/phpbb_topics|phpbb_topics]]
+
 
| Topics in forums
 
| Topics in forums
 
|-
 
|-
| [[/phpbb_topics_posted|phpbb_topics_posted]]
+
| [[Table.phpbb_topics_posted|phpbb_topics_posted]]
| who posted to which topic (used for the small dots in viewforum)
+
| Who posted to which topic (used for the small dots in viewforum)
 
|-
 
|-
| [[/phpbb_topics_track|phpbb_topics_track]]
+
| [[Table.phpbb_topics_track|phpbb_topics_track]]
| unread post information is stored here
+
| Unread post information is stored here
 
|-
 
|-
| [[/phpbb_topics_watch|phpbb_topics_watch]]
+
| [[Table.phpbb_topics_watch|phpbb_topics_watch]]
 
| "notify me upon replies"
 
| "notify me upon replies"
 
|-
 
|-
| [[/phpbb_user_group|phpbb_user_group]]
+
| [[Table.phpbb_user_group|phpbb_user_group]]
 
| Users groups
 
| Users groups
 
|-
 
|-
| [[/phpbb_users|phpbb_users]]
+
| [[Table.phpbb_user_notifications|phpbb_user_notifications]]
 +
| tbd
 +
|-
 +
| [[Table.phpbb_users|phpbb_users]]
 
| Registered users
 
| Registered users
 
|-
 
|-
| [[/phpbb_warnings|phpbb_warnings]]
+
| [[Table.phpbb_warnings|phpbb_warnings]]
 
| Warnings given to users
 
| Warnings given to users
 
|-
 
|-
| [[/phpbb_words|phpbb_words]]
+
| [[Table.phpbb_words|phpbb_words]]
 
| censored words
 
| censored words
 
|-
 
|-
| [[/phpbb_zebra|phpbb_zebra]]
+
| [[Table.phpbb_zebra|phpbb_zebra]]
| friends and foes
+
| 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.
 +
 +
==Info==
 +
* Script used to create this list: [[User:Pyramide/DB2wiki]].
 +
* Updated to reflect the wiki guidelines (battye, January 2009)<br><br>
 +
* Updated to reflect the phpBB 3.1.x Tables too --[[User:3di|3Di]] ([[User talk:3di|talk]]) 11:57, 19 September 2015 (UTC)
 +
* Updated to reflect the phpBB 3.2 and 3.3 Tables --[[User:3di|3Di]] ([[User talk:3di|talk]]) 13 Feb 2020 (UTC)
 
[[Category:Database]]
 
[[Category:Database]]
 +
[[Category:Database Tables]]
 +
 +
[[ja:Tables]]

Latest revision as of 06:52, 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.

Info

  • 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)
  • Updated to reflect the phpBB 3.2 and 3.3 Tables --3Di (talk) 13 Feb 2020 (UTC)