CREATE TABLE animals ( id mediumint not null auto_increment,
name char(30) not null,
primary key (id));