phpBB

Development Wiki

Difference between revisions of "Tables"

From phpBB Development Wiki

m (Tables)
m (Info)
 
(5 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
Tables –– List of Database Tables used within phpBB3
 
Tables –– List of Database Tables used within phpBB3
  
==Tables==
+
==Tables 3.2/3.3==
 
{|border="1" cellspacing="0" cellpadding="3"
 
{|border="1" cellspacing="0" cellpadding="3"
 
! name
 
! name
Line 38: Line 38:
 
| [[Table.phpbb_config|phpbb_config]]
 
| [[Table.phpbb_config|phpbb_config]]
 
| Configuration information ($config table)
 
| Configuration information ($config table)
 +
|-
 +
| [[Table.phpbb_config_text|phpbb_config_text]]
 +
| tbd
 
|-
 
|-
 
| [[Table.phpbb_confirm|phpbb_confirm]]
 
| [[Table.phpbb_confirm|phpbb_confirm]]
Line 47: Line 50:
 
| [[Table.phpbb_drafts|phpbb_drafts]]
 
| [[Table.phpbb_drafts|phpbb_drafts]]
 
| Drafts of future posts/private messages
 
| Drafts of future posts/private messages
 +
|-
 +
| [[Table.phpbb_ext|phpbb_ext]]
 +
| tbd
 
|-
 
|-
 
| [[Table.phpbb_extension_groups|phpbb_extension_groups]]
 
| [[Table.phpbb_extension_groups|phpbb_extension_groups]]
Line 79: Line 85:
 
|-
 
|-
 
| [[Table.phpbb_login_attempts|phpbb_login_attempts]]
 
| [[Table.phpbb_login_attempts|phpbb_login_attempts]]
 +
| tbd
 +
|-
 +
| [[Table.phpbb_migrations|phpbb_migrations]]
 
| tbd
 
| tbd
 
|-
 
|-
Line 86: Line 95:
 
| [[Table.phpbb_modules|phpbb_modules]]
 
| [[Table.phpbb_modules|phpbb_modules]]
 
| Configuration of acp, mcp and ucp 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
 
|-
 
|-
 
| [[Table.phpbb_poll_options|phpbb_poll_options]]
 
| [[Table.phpbb_poll_options|phpbb_poll_options]]
Line 151: Line 175:
 
|-
 
|-
 
| [[Table.phpbb_styles|phpbb_styles]]
 
| [[Table.phpbb_styles|phpbb_styles]]
| Style = template + theme + imageset
+
| Style = template + theme
 
|-
 
|-
| [[Table.phpbb_styles_imageset|phpbb_styles_imageset]]
+
| [[Table.phpbb_teampage|phpbb_teampage]]
| [[Templating_Tutorial#Customizing_the_Imageset|Imagesets]]
+
|-
+
| [[Table.phpbb_styles_imageset_data|phpbb_styles_imageset_data]]
+
| tbd
+
|-
+
| [[Table.phpbb_styles_template|phpbb_styles_template]]
+
| tbd
+
|-
+
| [[Table.phpbb_styles_template_data|phpbb_styles_template_data]]
+
 
| tbd
 
| tbd
|-
 
| [[Table.phpbb_styles_theme|phpbb_styles_theme]]
 
| theme = css file
 
 
|-
 
|-
 
| [[Table.phpbb_topics|phpbb_topics]]
 
| [[Table.phpbb_topics|phpbb_topics]]
Line 182: Line 194:
 
| [[Table.phpbb_user_group|phpbb_user_group]]
 
| [[Table.phpbb_user_group|phpbb_user_group]]
 
| Users groups
 
| Users groups
 +
|-
 +
| [[Table.phpbb_user_notifications|phpbb_user_notifications]]
 +
| tbd
 
|-
 
|-
 
| [[Table.phpbb_users|phpbb_users]]
 
| [[Table.phpbb_users|phpbb_users]]
Line 195: Line 210:
 
| Friends and foes
 
| Friends and foes
 
|}
 
|}
== Added in phpBB 3.1.x ==
+
 
{|border="1" cellspacing="0" cellpadding="3"
+
== Reflects tables for 3.2 and 3.3 ==
! name
+
 
! content
+
This change affects only the tables list at the present time, more to come.
|-
+
| [[Table.phpbb_user_notifications|phpbb_user_notifications]]
+
| User Notifications
+
|}
+
<br>
+
  
 
==Info==
 
==Info==
 
* Script used to create this list: [[User:Pyramide/DB2wiki]].
 
* Script used to create this list: [[User:Pyramide/DB2wiki]].
 
* Updated to reflect the wiki guidelines (battye, January 2009)<br><br>
 
* 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]]
 
[[Category:Database Tables]]
  
 
[[ja: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)