Home

Your premium source for custom modification services for phpBB

   logo

HomeForumsBlogMOD ManagerFAQSearch Log in

The phpBB Doctor is currently available for private clients only. At this time we are not accepting any new work until we can clear out our current backlog. Thank you for your patience.

Tables — Table Structure
phpbb_posts
Posts for your board. Each post is part of a Topic.
Column Name Datatype Default Column Description
post_id mediumint(8) unsigned
auto_increment		 System assigned primary key, no user interaction required.
topic_id mediumint(8) unsigned
 0 Foreign key to phpbb_topics table, showing which topic this post belongs to. Required. Populated by system.
forum_id smallint(5) unsigned
 0 Foreign key to show which forum this post belongs to. Note that the topic also belongs to a forum, this is used to quickly count the number of posts per forum. Updated if a topic (or post) is moved (or split) by a moderator.
poster_id mediumint(8)
 0 Foreign key to the phpbb_users table, showing which user made this post.
post_time int(11)
 0 Unix timestamp for date/time this post was entered. Note that posts are sorted by post_id and not by this time.
poster_ip varchar(8)
 Hex-encoded IP address; IP address converted (255 becomes ff) and dots removed. The result is stored on the post.
127.0.0.1 (localhost) becomes 7f000001
SELECT inet_ntoa(conv(poster_ip, 16, 10)) FROM phpbb_posts to convert back with MySQL
post_username varchar(25)
 Normally null this field is used to record the post user name if / when a user is deleted.
enable_bbcode tinyint(1)
 1 Bit flag used by the user to specify whether BBCode is enabled for this post. Set on posting.php by user's default, then possibly changed at post time. Values are 1 = On (Default), 0 = Off.
enable_html tinyint(1)
 0 Bit flag used by the user to specify whether HTML is enabled for this post. Set on posting.php by user's default, then possibly changed at post time. Values are 1 = On, 0 = Off (Default).
enable_smilies tinyint(1)
 1 Bit flag used by the user to specify whether Smilies are enabled for this post. Set on posting.php by user's default, then possibly changed at post time. Values are 1 = On (Default), 0 = Off.
enable_sig tinyint(1)
 1 A user signature is not stored on a post, it is stored as part of the phpbb_users row. This bit flag (1 = On and 0 = Off) tells whether the sig should be displayed with this post or not.
post_edit_time int(11)
 As with other time values, this is stored as a unix_timestamp value. Normally null, if a user edits a post withing certain conditions, the last edit time will be stored. Multiple edits are allowed, only the last is stored
post_edit_count smallint(5) unsigned
 0 Since only the last edit time is stored, this field is used to increment the number of edits.

Table relationships
Forum containing the Post phpbb_forums.forum_id = phpbb_posts.forum_id
Last Post for Forum phpbb_forums.forum_last_post_id = phpbb_posts.post_id
Post Search Word cross reference phpbb_posts.post_id = phpbb_search_wordmatch.post_id
Post containing Post Text phpbb_posts.post_id = phpbb_posts_text.post_id
Topic containing the Post phpbb_topics.topic_id = phpbb_posts.topic_id
First Post for Topic phpbb_topics.topic_first_post_id = phpbb_posts.post_id
Last Post for Topic phpbb_topics.topic_last_post_id = phpbb_posts.post_id
User making the Post phpbb_users.user_id = phpbb_posts.poster_id
Legend Notes: [Primary Key] [Foreign Key or other Indexed Field(s)] [Glossary Entry]

Glossary | Graphical Database Diagram (Future Feature)


HomeForumsMOD ManagerFAQSearch Register Log in
Not endorsed by or affiliated with the phpBB Group
Powered by phpBB © phpBB Group 		Terms of Service
Web design by MomentsOfLight.com logo