create table `test`.`user`( `ID` int not null auto_increment, `FIRSTNAME` varchar(255), `LASTNAME` varchar(255), `COUNTRYCODE` varchar(2), `EMAILADDRESS` varchar(255), primary key (`ID`) ); create unique index `PRIMARY` on `test`.`user`(`ID`);