Mine

mysql> show create table ttbl_sbf_participant_info;
+---------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| Table                     | Create Table                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   |
+---------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
| ttbl_sbf_participant_info | CREATE TABLE `ttbl_sbf_participant_info` (
  `ParticipantID` int(10) unsigned NOT NULL default '0',
  `EventYear` int(10) unsigned NOT NULL default '0',
  `ParticipantYears` int(10) unsigned default NULL,
  `ParticipantTypeID` int(10) unsigned default NULL,
  `IsWebsiteAllowed` int(10) unsigned default NULL,
  `ShirtSizeID` int(10) unsigned default NULL,
  `GenderID` int(10) unsigned default NULL,
  KEY `sbfparticipantinfo_ParticipantID` (`ParticipantID`),
  KEY `sbfparticipantinfo_EventYear` (`EventYear`),
  KEY `sbfparticipantinfo_ParticipantTypeID` (`ParticipantTypeID`),
  KEY `sbfparticipantinfo_IsWebsiteAllowed` (`IsWebsiteAllowed`),
  KEY `sbfparticipantinfo_GenderID` (`GenderID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 |
+---------------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

mysql>