create table manufacturers (
    manufacturerID varchar(32) primary key,
    manufacturer varchar(32) not null
);
