phpBB

Development Wiki

Difference between revisions of "Table.phpbb posts"

From phpBB Development Wiki

m (algetli)
m (Reverted edits by NoricLicli (Talk); changed back to last version by Pyramide)
Line 1: Line 1:
oucoelli
 
 
description goes here
 
description goes here
  

Revision as of 20:02, 28 February 2008

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

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