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>