/* 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) VALUES ('medium', 'tan', 1); /* a medium sized black dog */ INSERT INTO dog (size, colour, dogID) VALUES ('medium', 'black', 2); /* a smaller white and tan dog */ /* note weak colour representation */ INSERT INTO dog (size, colour, dogID) VALUES ('medium', 'white', 3); /* a larger tan dog */ INSERT INTO dog (size, colour, dogID) VALUES ('larger', 'tan', 4); /* a larger black dog */ INSERT INTO dog (size, colour, dogID) VALUES ('larger', 'black', 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) VALUES ('medium', 'black', 6); INSERT INTO onLead (dog, person) VALUES (1,1); INSERT INTO onLead (dog, person) VALUES (2,2); INSERT INTO onLead (dog, person) VALUES (3,3); INSERT INTO onLead (dog, person) VALUES (4,4); INSERT INTO onLead (dog, person) VALUES (5,5); INSERT INTO onLead (dog, person) VALUES (6,6);