-- clears all of the data before inserting
DELETE FROM Pet;
DELETE FROM PetType;
DELETE FROM Owner;

-- this loads the PetTypes:

INSERT INTO PetType (PetType_Id, Description) VALUES (1, 'Dog');

INSERT INTO PetType (PetType_Id, Description) VALUES (2, 'Cat');

INSERT INTO PetType (PetType_Id, Description) VALUES ( 3, 'Mouse');

INSERT INTO PetType (PetType_Id, Description) VALUES ( 4, 'Monkey');

INSERT INTO PetType (PetType_Id, Description) VALUES ( 5, 'Bird');

INSERT INTO PetType (PetType_Id, Description) VALUES ( 6, 'Fish');

COMMIT;

-- This loads Owners:
INSERT INTO Owner (Owner_Id, Name, StreetAddress, City, StateCode, Phone)
VALUES ( 1, 'Bob Barker', '1234 Main Street', 'San Mateo', 'CA','415 555 3424');

INSERT INTO owner (Owner_Id, Name, StreetAddress, City, StateCode, Phone)
VALUES ( 2, 'Fred Kuba', '542 3rd St.', 'San Rafael', 'CA', '425 555 0822');

COMMIT;


-- This loads Pets:
INSERT INTO Pet (Pet_Id, Name, Birthdate, PetType_Id )
VALUES (1, 'Gizmo', '03-Apr-98', 1);

INSERT INTO Pet (Pet_Id, Name, Birthdate, PetType_Id, Owner_Id) 
VALUES (2, 'Scrappy', '03-Apr-93', 1, 1);

INSERT INTO Pet (Pet_Id, Name, Birthdate, PetType_Id, Owner_Id) 
VALUES (3, 'Rufus', '28-May-90', 1, 1);

INSERT INTO Pet (Pet_id, Name, Birthdate, PetType_Id, Owner_Id) 
VALUES (4, 'Spot', '01-dec-95', 1, 2 );

INSERT INTO Pet (Pet_Id, Name, Birthdate, PetType_Id, Owner_Id) 
VALUES (5, 'Spot', '05-Oct-92', 1, 1 );

INSERT INTO Pet (Pet_Id, Name, Birthdate, PetType_Id, Owner_Id)
VALUES (6, 'Candy', '05-Oct-88', 2, 1 );

COMMIT;