#
# Table structure for table `forum_posts`
#

CREATE TABLE forum_posts (
  post_id int(255) unsigned NOT NULL auto_increment,
  thread_id int(255) unsigned NOT NULL default '0',
  forum_id int(255) unsigned NOT NULL default '0',
  poster_id int(255) unsigned NOT NULL default '0',
  post_time int(11) NOT NULL default '0',
  poster_ip int(8) NOT NULL default '0',
  post_edit_time int(11) NOT NULL default '0',
  post_edit_count smallint(5) NOT NULL default '0',
  post_username varchar(25) NOT NULL default '',
  PRIMARY KEY  (post_id)
) TYPE=MyISAM;

#
# Dumping data for table `forum_posts`
#

INSERT INTO forum_posts VALUES (2, 0, 1, 1, 0, 0, 0, 0, '');
INSERT INTO forum_posts VALUES (1, 0, 1, 1, 0, 0, 0, 0, '');
INSERT INTO forum_posts VALUES (3, 3, 1, 1, 0, 0, 0, 0, '');
INSERT INTO forum_posts VALUES (4, 3, 1, 1, 0, 0, 0, 0, '');
INSERT INTO forum_posts VALUES (5, 2, 1, 1, 0, 0, 0, 0, '');

 
thread_id     Anzahl Posts
    3                    2
    2                    1
    0                    2