/* a guy in blue jeans and a grey top which says "Minnesota" */ INSERT INTO person (gender, lowerCColour, lowerClothing, upperCColour, upperCText, personID) VALUES ('m', 'blue', 'jeans', 'grey', 'Minnesota', 1); /* a big guy in light blue track-suit pants and a yellow tee-shirt */ INSERT INTO person (size, gender, lowerCColour, lowerClothing, upperCColour, upperClothing, personID) VALUES ('big', 'm', 'lightBlue', 'trackPants', 'yellow', 'teeShirt', 2); /* a guy in a white top */ INSERT INTO person (gender, upperCColour, personID) VALUES ('m', 'white', 3); /* a girl in a white top and blue jeans */ INSERT INTO person (gender, upperCColour, lowerCColour, lowerClothing, personID) VALUES ('f', 'white', 'blue', 'jeans', 4); /* the person we can't see */ INSERT INTO person (personID) VALUES (5); /* guy in blue jeans, dark blue top that says "ASF", and a red cap */ INSERT INTO person (gender, lowerCColour, lowerClothing, upperCColour, upperCText, hatColour, hat, personID) VALUES ('m', 'blue', 'jeans', 'darkBlue', 'ASF', 'red', 'cap', 6); /* a medium sized tan dog */ INSERT INTO dog (size, colour, dogID, onLead) VALUES ('medium', 'tan', 1, 1); /* a medium sized black dog */ INSERT INTO dog (size, colour, dogID, onLead) VALUES ('medium', 'black', 2, 2); /* a smaller white and tan dog */ /* note weak colour representation */ INSERT INTO dog (size, colour, dogID, onLead) VALUES ('medium', 'white', 3, 3); /* a larger tan dog */ INSERT INTO dog (size, colour, dogID, onLead) VALUES ('larger', 'tan', 4, 4); /* a larger black dog */ INSERT INTO dog (size, colour, dogID, onLead) VALUES ('larger', 'black', 5, 5); /* a medium sized brindled back and tan dog with a white patch on his neck and chest */ /* note tragic deficiency of colour representation */ INSERT INTO dog (size, colour, dogID, onLead) VALUES ('medium', 'black', 6, 6);