Development Wiki

Difference between revisions of "Table.phpbb posts"

From phpBB Development Wiki

Line 168: Line 168:
[[Category:Database Tables]]

Revision as of 08:06, 13 January 2010

description goes here


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 tbd 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


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