create or replace table itemcategories ( id int auto_increment primary key, name varchar(100) null, constraint nameIndex unique (name) ) charset=latin1;