create or replace table clanserver ( id int auto_increment, serverName varchar(100) not null, primary key (id, serverName) ) charset=latin1;