create or replace table stattypes ( id tinyint(11) auto_increment, name varchar(100) not null, primary key (id, name) ) charset=latin1;