phpBB

Development Wiki

Table.phpbb posts

From phpBB Development Wiki

description goes here

Fields

column type (MySQL) content default
post_id mediumint(8) unsigned primary key auto_increment
topic_id mediumint(8) unsigned tbd 0
forum_id mediumint(8) unsigned tbd 0
poster_id mediumint(8) unsigned tbd 0
icon_id mediumint(8) unsigned tbd 0
poster_ip varchar(40) tbd  
post_time int(11) unsigned tbd 0
post_approved tinyint(1) unsigned tbd 1
post_reported tinyint(1) unsigned tbd 0
enable_bbcode tinyint(1) unsigned tbd 1
enable_smilies tinyint(1) unsigned tbd 1
enable_magic_url tinyint(1) unsigned tbd 1
enable_sig tinyint(1) unsigned tbd 1
post_username varchar(255) tbd  
post_subject varchar(100) tbd  
post_text mediumtext tbd  
post_checksum varchar(32) tbd  
post_attachment tinyint(1) unsigned 1=This post has at least one attachment
0=no attachments in this post
0
bbcode_bitfield varchar(255) see Parsing text  
bbcode_uid varchar(5) see Parsing text  
post_postcount tinyint(1) unsigned tbd 1
post_edit_time int(11) unsigned tbd 0
post_edit_reason varchar(255) tbd  
post_edit_user mediumint(8) unsigned tbd 0
post_edit_count smallint(4) unsigned tbd 0
post_edit_locked tinyint(1) unsigned tbd 0

Keys

name fields
PRIMARY post_id
forum_id forum_id
topic_id topic_id
poster_ip poster_ip
poster_id poster_id
post_approved post_approved
tid_post_time topic_id
post_time