Hi I plan to create a tale to store the race result like this,

Place    RaceNumber       Gender      Name              Result    
12       0112              Male     Mike Lee            1:32:40 
16       0117              Female   Rose Marry           2:20:40 

I confused at the items type definiation.

Q1.I am not sure the result can be set to varchar(32) or other type?

Q2. and for racenumber, between int(11) and varchar(11), which one is better?

Q3. Can I use `UNIQUE KEY` like my way?

Q4. Do I need split name to firstName and lastName in my DB table?

DROP TABLE IF EXISTS `race_result`;
CREATE TABLE IF NOT EXISTS `race_result` (
  `id` int(11) NOT NULL auto_increment,
  `racenumber` int(11) NOT NULL,
  `gender` enum('male','female') NOT NULL,
  `name` varchar(16) NOT NULL,
  `result` varchar(32) NOT NULL,
  PRIMARY KEY  (`id`),
  UNIQUE KEY `racenumber` (`racenumber`,`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 AUTO_INCREMENT=3;