Mine

CREATE TABLE `affsite_posts` (
  `pid` int(10) unsigned NOT NULL auto_increment,
  `tid` int(10) unsigned NOT NULL default '0',
  `replyto` int(10) unsigned NOT NULL default '0',
  `fid` smallint(5) unsigned NOT NULL default '0',
  `subject` varchar(120) collate latin1_german2_ci NOT NULL default '',
  `icon` smallint(5) unsigned NOT NULL default '0',
  `uid` int(10) unsigned NOT NULL default '0',
  `username` varchar(80) collate latin1_german2_ci NOT NULL default '',
  `dateline` bigint(30) NOT NULL default '0',
  `message` text collate latin1_german2_ci NOT NULL,
  `ipaddress` varchar(30) collate latin1_german2_ci NOT NULL default '',
  `includesig` char(3) collate latin1_german2_ci NOT NULL default '',
  `smilieoff` char(3) collate latin1_german2_ci NOT NULL default '',
  `edituid` int(10) unsigned NOT NULL default '0',
  `edittime` int(10) NOT NULL default '0',
  `visible` int(1) NOT NULL default '0',
  `posthash` varchar(32) collate latin1_german2_ci NOT NULL default '',
  PRIMARY KEY  (`pid`),
  KEY `tid` (`tid`,`uid`),
  KEY `uid` (`uid`),
  KEY `dateline` (`dateline`),
  KEY `pid` (`pid`),
  FULLTEXT KEY `message` (`message`)
) ENGINE=MyISAM AUTO_INCREMENT=70978 DEFAULT CHARSET=latin1 COLLATE=latin1_german2_ci AUTO_INCREMENT=70978 ;