use www;


truncate table can_guide;
truncate table destination;
truncate table employee;
truncate table experience;
truncate table gathering_point;
truncate table guest;
truncate table plays_role;
truncate table reservation;
truncate table role;
truncate table trip;
truncate table trip_type;




--
-- Host: localhost    Database: www
-- ------------------------------------------------------


--
-- Dumping data for table `can_guide`
--

INSERT INTO `can_guide` VALUES (1,1),(1,2),(2,1),(2,2),(3,1),(4,2),(7,2);

--
-- Dumping data for table `destination`
--

INSERT INTO `destination` VALUES (1,'Lower Wisconsin River'),(2,'Upper Wisconsin River'),(3,'Wolf River');

--
-- Dumping data for table `employee`
--

INSERT INTO `employee` VALUES (1,'Wilma C.','Carson','Wilma','414-555-1234','414-555-9876','Year round, full-time'),(2,'Walter C.','Carson','Bud','414-555-1235','414-555-9876','Year round, full-time, except for deer hunting season'),(3,'Anne B.','Schultz','Annie','414-555-1266','414-555-2121','Year round, full-time, except for August vacation'),(4,'Joshua','Green','Josh','414-555-1268',NULL,'Summers, full-time'),(5,'William R.','Wagner  III','Billy','414-555-1271','414-555-3259','Summers, full-time, returns to school on August 19th'),(6,'Constance','Simms','Summer','414-555-1288',NULL,'Year round, part-time, as needed'),(7,'Blair Q.','McArthur','Blinky','414-555-1289','414-555-2121','Year round, full-time, except for May vacation');

--
-- Dumping data for table `experience`
--

INSERT INTO `experience` VALUES (3,'Expert'),(4,'Intermediate'),(1,'None'),(2,'Novice');

--
-- Dumping data for table `gathering_point`
--

INSERT INTO `gathering_point` VALUES (2,'Omar\'s Live Bait and Bridal Salon; 3421 Highway KZ; Casino Springs; WI 54776'),(1,'River Valley High School (Parking Lot); 660 Varsity Blvd; Spring Green; WI 53588'),(3,'VFW #95001; 200 W. Main Street; Littleton; WI 55884');

--
-- Dumping data for table `guest`
--

INSERT INTO `guest` VALUES (1,'Margie','Samuels',31,130,1,'847-555-5201',2),(2,'Bart','Samuels',44,195,1,NULL,2),(3,'Lilly','Samuels',18,101,1,NULL,2),(4,'Bart Jr.','Samuels',6,60,0,NULL,1),(5,'George','Fogerty',28,160,1,'414-555-7654',3),(6,'Bruce','Simmons',5,150,1,NULL,3),(9,'Marion','Glaston',61,135,1,'815-555-4453',2),(10,'Marie','Glaston',61,135,1,NULL,2),(11,'Lamar','Lincoln',25,175,0,'414-555-9988',1),(12,'Fizza','Smith',25,115,1,'414-555-9876',3),(13,'Kara','Dilworth',23,110,0,'312-555-9876',2),(14,'Tyler','Worth',24,145,1,'217-555-6776',4),(15,'Timmy','Zodah',30,150,1,NULL,1),(16,'Marie','Mickelson',22,100,0,'217-555-1500',2),(17,'David','Sills',61,180,1,'414-555-0002',4),(18,'Daniel','Divine',21,150,1,'414-555-3223',1),(19,'Madison','Ahern',31,120,0,NULL,1),(20,'Lacey','Sills',35,125,1,NULL,2);

--
-- Dumping data for table `plays_role`
--

INSERT INTO `plays_role` VALUES (1,1),(1,2),(1,3),(2,2),(2,3),(3,1),(3,2),(3,3),(4,2),(4,3),(5,3),(6,1),(6,3),(7,2),(7,3);

--
-- Dumping data for table `reservation`
--

INSERT INTO `reservation` VALUES (562,1),(563,1),(577,1),(583,1),(562,2),(567,2),(577,2),(581,2),(582,2),(583,2),(562,3),(563,3),(577,3),(581,3),(582,3),(583,3),(562,4),(575,4),(577,4),(582,4),(583,4),(562,5),(563,5),(577,5),(580,5),(582,5),(583,5),(562,6),(566,6),(570,6),(575,6),(583,6),(562,9),(563,9),(573,9),(562,10),(563,10),(564,10),(573,10),(574,10),(579,10),(561,11),(562,11),(563,11),(566,11),(569,11),(571,11),(573,11),(576,11),(577,11),(579,11),(561,12),(564,12),(566,12),(567,12),(569,12),(571,12),(576,12),(577,12),(579,12),(582,12),(561,13),(563,13),(569,13),(571,13),(576,13),(577,13),(578,13),(579,13),(561,14),(564,14),(565,14),(569,14),(571,14),(572,14),(576,14),(577,14),(578,14),(579,14),(561,15),(563,15),(565,15),(571,15),(572,15),(576,15),(577,15),(578,15),(579,15),(580,15),(561,16),(564,16),(565,16),(571,16),(572,16),(576,16),(578,16),(579,16),(581,16),(561,17),(565,17),(571,17),(572,17),(574,17),(576,17),(578,17),(581,17),(583,17),(561,18),(564,18),(565,18),(572,18),(576,18),(578,18),(581,18),(584,18),(561,19),(565,19),(566,19),(572,19),(579,19),(561,20),(564,20),(572,20),(579,20),(582,20);

--
-- Dumping data for table `role`
--

INSERT INTO `role` VALUES (3,'Gear'),(2,'Guide'),(1,'Reservations');

--
-- Dumping data for table `trip`
--

INSERT INTO `trip` VALUES (561,'2014-08-02',10,'07:30:00','08:15:00','16:00:00',1,2,4,NULL,1),(562,'2014-08-02',10,'07:30:00','08:15:00','16:00:00',1,1,3,NULL,1),(563,'2014-08-09',10,'07:30:00','08:15:00','16:00:00',1,2,4,NULL,1),(564,'2014-08-09',10,'07:30:00','08:15:00','16:00:00',1,1,3,NULL,1),(565,'2014-08-16',10,'07:30:00','08:15:00','16:00:00',1,2,4,NULL,1),(566,'2014-08-16',10,'07:30:00','08:15:00','16:00:00',1,1,3,NULL,1),(567,'2014-08-23',10,'07:30:00','08:15:00','16:00:00',1,2,4,NULL,1),(568,'2014-08-23',10,'07:30:00','08:15:00','16:00:00',1,1,3,NULL,1),(569,'2014-08-30',10,'07:30:00','08:15:00','16:00:00',1,2,4,NULL,1),(570,'2014-08-30',10,'07:30:00','08:15:00','16:00:00',1,1,3,NULL,1),(571,'2014-08-02',7,'07:30:00','08:15:00','16:00:00',2,1,2,NULL,2),(572,'2014-08-09',7,'07:30:00','08:15:00','16:00:00',2,1,2,NULL,2),(573,'2014-08-16',7,'07:30:00','08:15:00','16:00:00',2,1,2,NULL,2),(574,'2014-08-23',7,'07:30:00','08:15:00','16:00:00',2,1,2,NULL,2),(575,'2014-08-30',7,'07:30:00','08:15:00','16:00:00',2,1,2,NULL,2),(576,'2014-08-02',10,'07:30:00','08:15:00','16:00:00',3,1,1,NULL,3),(577,'2014-08-02',10,'07:30:00','08:15:00','16:00:00',3,2,7,NULL,3),(578,'2014-08-09',10,'07:30:00','08:15:00','16:00:00',3,1,1,NULL,3),(579,'2014-08-09',10,'07:30:00','08:15:00','16:00:00',3,2,7,NULL,3),(580,'2014-08-16',10,'07:30:00','08:15:00','16:00:00',3,1,1,NULL,3),(581,'2014-08-16',10,'07:30:00','08:15:00','16:00:00',3,2,7,NULL,3),(582,'2014-08-23',10,'07:30:00','08:15:00','16:00:00',3,1,1,NULL,3),(583,'2014-08-23',10,'07:30:00','08:15:00','16:00:00',3,2,7,NULL,3),(584,'2014-08-30',10,'07:30:00','08:15:00','16:00:00',3,1,1,NULL,3),(585,'2014-08-30',10,'07:30:00','08:15:00','16:00:00',3,2,7,NULL,3);

--
-- Dumping data for table `trip_type`
--

INSERT INTO `trip_type` VALUES (2,'Canoe'),(1,'Kayak'),(3,'Raft');


