create or replace table transactions ( id int auto_increment primary key, name varchar(60) not null ) charset=latin1;