drop table if exists pet;
create table pet (
    pid int auto_increment,
    name varchar(30),
    dob date,
    weight float,
    sex enum('male','female'),
    neutered enum('yes','no'),
    species enum('dog','cat','rabbit'),
    litters tinyint,
    behaviors set('bites','hisses','scratches'),
    primary key (pid)
    );