CREATE TABLE foo(
  id int(10) unsigned NOT NULL AUTO_INCREMENT,
  letter char(1) NOT NULL,
  name text NOT NULL,
  num float NULL,
  PRIMARY KEY (id)
);