create table speciesPatterns (
    speciesPatternID int not null primary key auto_increment,
    speciesID varchar(32) not null,
    pattern varchar(20) not null,
    patternName varchar(32) not null
);
