-- MySQL Administrator dump 1.4 -- -- ------------------------------------------------------ -- Server version 5.0.27-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; -- -- Create schema eaglebre_watsonhome -- CREATE DATABASE IF NOT EXISTS eaglebre_watsonhome; USE eaglebre_watsonhome; -- -- Definition of table `eaglebre_watsonhome`.`Borrowers` -- DROP TABLE IF EXISTS `eaglebre_watsonhome`.`Borrowers`; CREATE TABLE `eaglebre_watsonhome`.`Borrowers` ( `index` tinyint(4) NOT NULL auto_increment, `Borrower` varchar(255) default NULL, PRIMARY KEY (`index`), KEY `Borrower` (`Borrower`) ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1; -- -- Dumping data for table `eaglebre_watsonhome`.`Borrowers` -- /*!40000 ALTER TABLE `Borrowers` DISABLE KEYS */; LOCK TABLES `Borrowers` WRITE; INSERT INTO `eaglebre_watsonhome`.`Borrowers` VALUES (1,'Dave Fellows'), (2,'Shauna Charles'), (3,'Jeff Galloway'), (4,'Kim Watson'), (5,'Steph Toyn'), (6,'Cunningtons'), (7,'Greg Galloway'); UNLOCK TABLES; /*!40000 ALTER TABLE `Borrowers` ENABLE KEYS */; -- -- Definition of table `eaglebre_watsonhome`.`Checkout_Log` -- DROP TABLE IF EXISTS `eaglebre_watsonhome`.`Checkout_Log`; CREATE TABLE `eaglebre_watsonhome`.`Checkout_Log` ( `DVD_ID` int(4) NOT NULL default '1', `index_event` smallint(6) NOT NULL auto_increment, `Borrower_ID` tinyint(4) NOT NULL default '0', `Date_Taken` date default NULL, `Date_Returned` date default NULL, PRIMARY KEY (`index_event`), KEY `Borrower_ID` (`Borrower_ID`) ) ENGINE=MyISAM AUTO_INCREMENT=139 DEFAULT CHARSET=latin1; -- -- Dumping data for table `eaglebre_watsonhome`.`Checkout_Log` -- /*!40000 ALTER TABLE `Checkout_Log` DISABLE KEYS */; LOCK TABLES `Checkout_Log` WRITE; INSERT INTO `eaglebre_watsonhome`.`Checkout_Log` VALUES (165,7,1,'2004-11-26','2004-11-30'), (68,2,1,'2004-11-22','2004-11-26'), (101,3,1,'2004-11-22','2004-11-26'), (112,4,1,'2004-11-22','2004-11-26'), (10,5,1,'2004-11-22','2004-11-26'), (48,8,1,'2004-11-26','2004-11-30'), (147,9,1,'2004-11-26','2004-11-30'), (17,10,1,'2004-11-26','2004-11-30'), (58,11,1,'2004-11-30','2004-12-07'), (198,12,1,'2004-11-30','2004-12-07'), (202,13,1,'2004-11-30','2004-12-07'), (88,14,1,'2004-11-30','2004-12-07'), (13,15,1,'2004-12-07','2004-12-16'), (97,16,1,'2004-12-07','2004-12-16'), (155,17,1,'2004-12-07','2004-12-16'), (158,18,1,'2004-12-07','2004-12-16'), (114,19,1,'2004-12-07','2004-12-16'), (242,20,1,'2004-12-16','2004-12-23'), (109,21,1,'2004-12-16','2004-12-23'), (121,22,1,'2004-12-16','2004-12-23'), (20,23,1,'2004-12-16','2004-12-23'), (220,24,1,'2004-12-16','2004-12-23'), (72,25,6,'2005-01-29','2005-02-13'), (211,40,1,'2005-02-17','2005-02-24'), (62,28,4,'2005-02-02','2005-02-12'), (117,29,4,'2005-02-02','2005-02-12'); INSERT INTO `eaglebre_watsonhome`.`Checkout_Log` VALUES (138,30,4,'2005-02-02','2005-02-12'), (3,31,4,'2005-02-02','2005-02-12'), (156,32,4,'2005-02-02','2005-02-12'), (258,33,4,'2005-02-02','2005-02-12'), (262,34,1,'2005-02-10','2005-02-17'), (176,35,1,'2005-02-10','2005-02-17'), (249,36,1,'2005-02-10','2005-02-17'), (210,37,1,'2005-02-10','2005-02-17'), (125,38,1,'2005-02-10','2005-02-17'), (244,39,1,'2005-02-10','2005-02-17'), (188,41,1,'2005-02-17','2005-02-24'), (177,42,1,'2005-02-17','2005-02-24'), (66,43,1,'2005-02-17','2005-02-24'), (27,44,1,'2005-02-17','2005-02-24'), (14,45,1,'2005-02-17','2005-02-24'), (4,46,6,'2005-02-19','2005-02-25'), (100,47,6,'2005-02-19','2005-02-25'), (259,49,1,'2005-02-24','2005-03-05'), (221,50,1,'2005-02-24','2005-03-05'), (168,51,1,'2005-02-24','2005-03-05'), (75,52,1,'2005-02-24','2005-03-05'), (99,53,1,'2005-02-24','2005-03-05'), (84,54,1,'2005-02-24','2005-03-05'), (219,55,1,'2005-03-03','2005-03-10'), (260,56,1,'2005-03-03','2005-03-10'), (136,57,1,'2005-03-03','2005-03-10'); INSERT INTO `eaglebre_watsonhome`.`Checkout_Log` VALUES (234,58,1,'2005-03-03','2005-03-10'), (258,59,1,'2005-03-03','2005-03-10'), (178,60,1,'2005-03-10','2005-03-17'), (253,61,1,'2005-03-10','2005-03-17'), (47,62,1,'2005-03-10','2005-03-17'), (164,63,1,'2005-03-10','2005-03-17'), (254,64,1,'2005-03-10','2005-03-17'), (33,65,1,'2005-03-10','2005-03-17'), (208,66,1,'2005-03-10','2005-03-17'), (208,67,1,'2005-03-10','2005-03-17'), (35,68,1,'2005-03-17','2005-03-24'), (32,69,1,'2005-03-17','2005-03-24'), (229,70,1,'2005-03-17','2005-03-24'), (143,71,1,'2005-03-17','2005-03-24'), (271,72,1,'2005-03-17','2005-03-24'), (270,73,1,'2005-03-17','2005-03-24'), (153,74,1,'2005-03-24','2005-03-31'), (261,75,1,'2005-03-24','2005-03-31'), (232,76,1,'2005-03-24','2005-03-31'), (241,77,1,'2005-03-24','2005-03-31'), (200,78,1,'2005-03-24','2005-03-31'), (81,79,1,'2005-03-24','2005-03-31'), (269,80,1,'2005-03-31','2005-04-06'), (238,81,1,'2005-03-31','2005-04-06'), (120,82,1,'2005-03-31','2005-04-06'), (278,83,1,'2005-03-31','2005-04-06'); INSERT INTO `eaglebre_watsonhome`.`Checkout_Log` VALUES (190,84,1,'2005-03-31','2005-04-06'), (173,85,1,'2005-03-31','2005-04-06'), (37,86,1,'2005-03-31','2005-04-06'), (53,87,6,'2005-03-31','2005-04-06'), (279,88,6,'2005-03-31','2005-04-06'), (33,89,6,'2005-03-31','2005-04-06'), (139,90,6,'2005-03-31','2005-04-06'), (170,91,6,'2005-03-31','2005-04-06'), (254,92,6,'2005-03-31','2005-04-06'), (4,93,6,'2005-03-31','2005-04-06'), (279,94,1,'2005-04-06','2005-05-03'), (280,95,1,'2005-04-06','2005-05-03'), (187,96,1,'2005-04-06','2005-05-03'), (222,97,1,'2005-04-06','2005-05-03'), (292,98,4,'2005-05-23','2005-06-01'), (305,99,7,'2005-06-24','2005-06-27'), (3,100,4,'2005-07-13','2005-07-14'), (60,101,4,'2005-07-13','2005-07-14'), (239,102,2,'2005-08-02','2005-08-04'), (230,103,2,'2005-08-02','2005-08-04'), (43,104,2,'2005-08-02','2005-08-04'), (181,105,2,'2005-09-10','2005-10-26'), (182,106,2,'2005-09-10','2005-10-26'), (183,107,2,'2005-09-10','2005-10-26'), (318,108,6,'2005-11-25','2005-12-19'), (312,109,6,'2005-11-25','2005-12-19'); INSERT INTO `eaglebre_watsonhome`.`Checkout_Log` VALUES (264,110,6,'2005-11-25','2005-12-19'), (325,111,2,'2005-12-22','2006-01-02'), (362,112,2,'2006-08-13','2006-10-02'), (372,113,2,'2006-08-13','2006-10-02'), (372,114,2,'2006-09-22','2006-10-03'), (368,115,2,'2006-09-22','2006-10-03'), (186,116,4,'2006-09-24','2006-11-28'), (242,117,4,'2006-09-24','2006-11-28'), (391,118,2,'2006-10-03','2006-10-17'), (361,119,2,'2006-10-03','2006-10-17'), (367,120,2,'2006-10-03','2006-10-24'), (358,121,2,'2006-10-03','2006-12-27'), (390,122,2,'2006-10-24','2006-11-10'), (392,123,2,'2006-10-24','2006-10-26'), (376,124,2,'2006-10-24','2006-11-10'), (397,125,2,'2006-10-24','2006-10-29'), (378,126,2,'2006-11-08','2006-11-23'), (238,127,2,'2006-11-08','2006-11-23'), (345,128,6,'2006-11-18','2004-12-31'), (345,129,6,'2006-11-18','2004-12-31'), (408,130,2,'2006-11-23','2004-12-31'), (24,131,3,'2006-12-04','2004-12-31'), (406,132,3,'2006-12-04','2004-12-31'), (398,133,3,'2006-12-04','2004-12-31'), (1,134,4,'2006-12-04','2006-12-04'); INSERT INTO `eaglebre_watsonhome`.`Checkout_Log` VALUES (23,135,3,'2006-12-04','2006-12-04'), (429,136,2,'2007-03-20','2004-12-31'), (425,137,2,'2007-03-20','2004-12-31'), (428,138,2,'2007-03-20','2007-07-02'); UNLOCK TABLES; /*!40000 ALTER TABLE `Checkout_Log` ENABLE KEYS */; -- -- Definition of table `eaglebre_watsonhome`.`DiningOut` -- DROP TABLE IF EXISTS `eaglebre_watsonhome`.`DiningOut`; CREATE TABLE `eaglebre_watsonhome`.`DiningOut` ( `ID` int(10) unsigned NOT NULL auto_increment, `Place` tinyint(3) unsigned NOT NULL COMMENT 'Lookup from the Restaurant DB', `Date` datetime NOT NULL, `Meal` enum('Breakfast','Lunch','Dinner','Brunch','Other') NOT NULL, `Comments` varchar(255) default NULL, `Participants` varchar(255) default 'Lynn & Sandy', `Ranking` enum('1','2','3','4','5') NOT NULL COMMENT 'Scale of 1:5', PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1 COMMENT='Here''s a list of when we ate out'; -- -- Dumping data for table `eaglebre_watsonhome`.`DiningOut` -- /*!40000 ALTER TABLE `DiningOut` DISABLE KEYS */; LOCK TABLES `DiningOut` WRITE; INSERT INTO `eaglebre_watsonhome`.`DiningOut` VALUES (1,1,'2006-12-02 00:00:00','Brunch','Marionberry scones for Sandy, medium hot choc. next time','Lynn & Sandy','3'), (2,3,'2006-12-02 00:00:00','Dinner','Sandy:Mu-Shu Chicken ; Lynn:Triple over Noodles','Lynn & Sandy','3'), (3,4,'2006-12-04 00:00:00','Lunch','Philly Cheesesteak--Not great','Lynn & Sandy','2'), (4,5,'2006-12-05 00:00:00','Lunch','Lynn-Mushroom Burger;Sandy-Chicken Wrap and Gingersnap shake--YUM!','Lynn & Sandy','4'), (5,6,'2006-12-07 00:00:00','Lunch','Lunch with Terry to discuss his dental appliance ideas. \"Sticky Salad\" good, but spicy','Lynn & Terry Tingey','3'), (6,7,'2006-12-07 00:00:00','Dinner','Lynn: Chipolte spanish chicken Sandy: grilled pork sandwich','Lynn & Sandy','3'), (7,8,'2006-12-07 00:00:00','Dinner','Filet Medallions, Roasted Chicken','Lynn & Sandy, Steph & Nick','3'), (8,9,'2006-12-07 00:00:00','Lunch','The Ciabatta Steak Sandwich was horrible. Jumbo taco (Sandy) was nasty','Lynn & Sandy','1'), (9,10,'2006-12-08 00:00:00','Dinner','Before the BYU Christmas Concert','Lynn & Sandy, Steve & Karen, Adam & Nadine','3'); INSERT INTO `eaglebre_watsonhome`.`DiningOut` VALUES (10,11,'2006-12-09 00:00:00','Lunch',NULL,'Lynn & Sandy, Steve & Karen, Adam/Nade, Greg','3'), (11,2,'2006-12-13 00:00:00','Lunch',' I think you get more in the salad than the burrito','Lynn & Sandy','4'), (12,4,'2007-01-01 00:00:00','Lunch','Nick, Steph, Sandy, Lynn','Lynn & Sandy','2'), (13,13,'2006-12-30 00:00:00','Dinner','Nick, Steph, Sandy, Lynn, Doug','Lynn & Sandy','3'), (14,15,'2006-12-27 00:00:00','Lunch','Sandy, Lynn, Doug, Greg, Brittney','Lynn & Sandy','3'), (15,16,'2007-01-04 00:00:00','Dinner','Nick, Steph, Sandy, Lynn','Lynn & Sandy','3'), (16,12,'2007-01-05 00:00:00','Lunch','I liked the house noodles this time.','Lynn & Sandy','3'), (17,17,'2007-01-13 00:00:00','Dinner','Love the halibut tacos','Lynn & Sandy & Brian','3'), (18,18,'2007-01-15 00:00:00','Lunch','Rueben & Chicken Wrap','Lynn & Sandy','3'), (19,2,'2007-01-12 00:00:00','Lunch','The Salad is good.','Lynn & Sandy','3'); UNLOCK TABLES; /*!40000 ALTER TABLE `DiningOut` ENABLE KEYS */; -- -- Definition of table `eaglebre_watsonhome`.`FoodTypes` -- DROP TABLE IF EXISTS `eaglebre_watsonhome`.`FoodTypes`; CREATE TABLE `eaglebre_watsonhome`.`FoodTypes` ( `ID` tinyint(3) unsigned NOT NULL auto_increment, `Type` varchar(45) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=latin1; -- -- Dumping data for table `eaglebre_watsonhome`.`FoodTypes` -- /*!40000 ALTER TABLE `FoodTypes` DISABLE KEYS */; LOCK TABLES `FoodTypes` WRITE; INSERT INTO `eaglebre_watsonhome`.`FoodTypes` VALUES (1,'Breakfast'), (2,'Bakery'), (3,'Mexican'), (4,'Thai'), (5,'Italian'), (6,'BBQ'), (7,'Fresh-Mex'), (8,'SouthWestern'), (9,'American Diner'), (10,'Vietnamese'), (11,'FastFood'), (12,'Bar & Grill'), (13,'Seafood'); UNLOCK TABLES; /*!40000 ALTER TABLE `FoodTypes` ENABLE KEYS */; -- -- Definition of table `eaglebre_watsonhome`.`Restaurants` -- DROP TABLE IF EXISTS `eaglebre_watsonhome`.`Restaurants`; CREATE TABLE `eaglebre_watsonhome`.`Restaurants` ( `ID` int(11) NOT NULL auto_increment, `Name` varchar(45) NOT NULL, `City` varchar(45) NOT NULL, `State` int(10) unsigned NOT NULL default '75', `FoodType` tinyint(4) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=latin1 COMMENT='Keep a Record of the places we eat'; -- -- Dumping data for table `eaglebre_watsonhome`.`Restaurants` -- /*!40000 ALTER TABLE `Restaurants` DISABLE KEYS */; LOCK TABLES `Restaurants` WRITE; INSERT INTO `eaglebre_watsonhome`.`Restaurants` VALUES (1,'Wild West Bakery','Eagle',75,2), (2,'Costa Vida','Meridan',75,7), (3,'Fusion Grill','Meridan',75,10), (4,'Carl\'s Jr.','Boise',75,11), (5,'Red Robin','Boise',75,9), (6,'Wingers','Meridian',75,9), (7,'Bardenay','Eagle',75,12), (8,'Texas Roadhouse BBQ','Ammon',75,6), (9,'Jack in the Box','Burley',75,11), (10,'TGI Fridays','Provo',111,9), (11,'Olive Garden','Logan',111,5), (12,'Ginger Thai','Eagle',75,4), (13,'Red Robin','Eagle',75,9), (14,'Carls Jr.','Meridian',75,11), (15,'Grandma\'s Diner','Cascade',75,9), (16,'Smokey Mtn. Pizza','Eagle',75,12), (17,'Off The Hook','Boise',75,13), (18,'Arbys','Eagle',75,11); UNLOCK TABLES; /*!40000 ALTER TABLE `Restaurants` ENABLE KEYS */; -- -- Definition of table `eaglebre_watsonhome`.`States` -- DROP TABLE IF EXISTS `eaglebre_watsonhome`.`States`; CREATE TABLE `eaglebre_watsonhome`.`States` ( `ID` int(10) unsigned NOT NULL auto_increment, `TwoChar` varchar(2) NOT NULL, `Full` varchar(45) NOT NULL, PRIMARY KEY (`ID`) ) ENGINE=MyISAM AUTO_INCREMENT=119 DEFAULT CHARSET=latin1; -- -- Dumping data for table `eaglebre_watsonhome`.`States` -- /*!40000 ALTER TABLE `States` DISABLE KEYS */; LOCK TABLES `States` WRITE; INSERT INTO `eaglebre_watsonhome`.`States` VALUES (60,'AL','ALABAMA'), (61,'AK','ALASKA'), (62,'AS','AMERICAN SAMOA'), (63,'AZ','ARIZONA'), (64,'AR','ARKANSAS'), (65,'CA','CALIFORNIA'), (66,'CO','COLORADO'), (67,'CT','CONNECTICUT'), (68,'DE','DELAWARE'), (69,'DC','DISTRICT OF COLUMBIA'), (70,'FM','FEDERATED STATES OF MICRONESIA'), (71,'FL','FLORIDA'), (72,'GA','GEORGIA'), (73,'GU','GUAM'), (74,'HI','HAWAII'), (75,'ID','IDAHO'), (76,'IL','ILLINOIS'), (77,'IN','INDIANA'), (78,'IA','IOWA'), (79,'KS','KANSAS'), (80,'KY','KENTUCKY'), (81,'LA','LOUISIANA'), (82,'ME','MAINE'), (83,'MH','MARSHALL ISLANDS'), (84,'MD','MARYLAND'), (85,'MA','MASSACHUSETTS'), (86,'MI','MICHIGAN'), (87,'MN','MINNESOTA'), (88,'MS','MISSISSIPPI'), (89,'MO','MISSOURI'), (90,'MT','MONTANA'), (91,'NE','NEBRASKA'), (92,'NV','NEVADA'), (93,'NH','NEW HAMPSHIRE'), (94,'NJ','NEW JERSEY'), (95,'NM','NEW MEXICO'), (96,'NY','NEW YORK'), (97,'NC','NORTH CAROLINA'), (98,'ND','NORTH DAKOTA'), (99,'MP','NORTHERN MARIANA ISLANDS'), (100,'OH','OHIO'); INSERT INTO `eaglebre_watsonhome`.`States` VALUES (101,'OK','OKLAHOMA'), (102,'OR','OREGON'), (103,'PW','PALAU'), (104,'PA','PENNSYLVANIA'), (105,'PR','PUERTO RICO'), (106,'RI','RHODE ISLAND'), (107,'SC','SOUTH CAROLINA'), (108,'SD','SOUTH DAKOTA'), (109,'TN','TENNESSEE'), (110,'TX','TEXAS'), (111,'UT','UTAH'), (112,'VT','VERMONT'), (113,'VI','VIRGIN ISLANDS'), (114,'VA','VIRGINIA'), (115,'WA','WASHINGTON'), (116,'WV','WEST VIRGINIA'), (117,'WI','WISCONSIN'), (118,'WY','WYOMING'); UNLOCK TABLES; /*!40000 ALTER TABLE `States` ENABLE KEYS */; -- -- Definition of table `eaglebre_watsonhome`.`Watson_DVD_Library` -- DROP TABLE IF EXISTS `eaglebre_watsonhome`.`Watson_DVD_Library`; CREATE TABLE `eaglebre_watsonhome`.`Watson_DVD_Library` ( `NAME` varchar(255) default NULL, `YEAR MADE` int(11) default NULL, `RATING` enum('NOT RATED','PG-13','PG','G') default NULL, `CATEGORY` enum('Musical','Music','Family','Church','Christmas','Chick-Flick','Drama','Comedy','TV Series','Action') default NULL COMMENT '', `RUNTIME` varchar(255) default NULL, `INDEX` int(11) NOT NULL auto_increment, PRIMARY KEY (`INDEX`) ) ENGINE=MyISAM AUTO_INCREMENT=501 DEFAULT CHARSET=latin1; -- -- Dumping data for table `eaglebre_watsonhome`.`Watson_DVD_Library` -- /*!40000 ALTER TABLE `Watson_DVD_Library` DISABLE KEYS */; LOCK TABLES `Watson_DVD_Library` WRITE; INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('A Bug\'s Life',1997,'G','Family','95min.',1), ('A Shot in the Dark',1964,'PG','Comedy','102min.',2), ('About A Boy',2002,'PG-13','Chick-Flick','100 Minutes',3), ('American Outlaws',2001,'PG-13','Action','95min.',4), ('Anger Management',2003,'PG-13','Comedy','106min.',5), ('Anna and the King',1999,'PG-13','Chick-Flick','147min.',6), ('Anne of Green Gables',1995,'G','Family','195min.',7), ('Anne of Green Gables--The Continuing Story',2001,'G','Family','185 Minutes',8), ('Anne of Green Gables--The sequel',1996,'G','Family','232min.',9), ('Annie',1981,'PG','Musical','127min.',10), ('Antwone Fisher',2002,'PG-13','Drama','120min.',11), ('Antz',2002,'PG','Comedy','83min.',12), ('Armageddon',1997,'PG-13','Drama','151min.',13), ('Behind Enemy Lines',2001,'PG-13','Action','105min.',14), ('Big',1988,'PG','Drama','104min.',15), ('Bringing Down the House',2003,'PG-13','Comedy','105min.',16), ('Bruce Almighty',2003,'PG-13','Comedy','102min.',17), ('Casablanca',1943,'PG','Chick-Flick','103min.',18); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('Catch me if you can',2002,'PG-13','Drama','141min.',19), ('Cheaper by the Dozen',2003,'PG','Family','120 Minutes',20), ('Chicken Run',2000,'G','Family','84min.',21), ('Christmas Carol',1984,'PG','Christmas','100min.',22), ('A Christmas Story',1983,'PG','Christmas','98min.',23), ('Christmas Vacation',1989,'PG-13','Christmas','97min.',24), ('Cipher in the Snow',2003,'NOT RATED','Church','125min.',25), ('City Slickers',1991,'PG-13','Comedy','106 min.',26), ('Clear and Present Danger',1994,'PG-13','Action','141min.',27), ('Cool Runnings',1993,'PG','Drama','98min.',28), ('Crouching Tiger Hidden Dragon',2000,'PG-13','Action','120 Minutes',29), ('Daddy Day Care',2003,'PG','Comedy','92min.',30), ('Dave',1993,'PG-13','Drama','110min.',31), ('Dave Koz---The Dance',1999,'NOT RATED','Music',NULL,32), ('Deep Impact',1998,'PG-13','Drama','121min.',33), ('Die Another Day',2002,'PG-13','Action','132min.',34), ('Don Henley Live: Inside Job',2000,'NOT RATED','Music','105min.',35), ('Dr. NO',1962,'PG','Action','110min.',36); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('Dr. Doolittle 2',2001,'PG','Comedy','87min.',37), ('Eagles:Hell Freezes Over',1994,'NOT RATED','Music','99min.',38), ('Elton John: One Night Only- Greatest Hits',2000,'NOT RATED','Music',NULL,39), ('Emma',1996,'PG','Chick-Flick','121min.',40), ('Fiddler on the Roof',1971,'G','Musical','179min.',41), ('Finding Forrestor',2001,'PG-13','Drama','136min.',42), ('Finding Nemo',2003,'G','Comedy','100min.',43), ('First Knight',1997,'PG-13','Chick-Flick','133min.',44), ('Fleetwood Mac: The Dance',1997,'NOT RATED','Music','106min.',45), ('Footloose',1984,'PG','Musical','107min.',46), ('Forever Young',1992,'PG','Drama','102min.',47), ('Freaky Friday',2003,'PG','Comedy','97min.',48), ('Frequency',2000,'PG-13','Drama','119min.',49), ('Funny farm',1988,'PG','Comedy','101min.',50), ('Ghostbusters',1984,'PG','Family','107min.',51), ('Ghostbusters 2',1989,'PG','Family','108min.',52), ('Gods and Generals',2003,'PG-13','Action','219min.',53), ('Goldeneye',1995,'PG','Action','130min.',54); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('Goldfinger',1964,'PG','Action','110min.',55), ('Good Boy!',2003,'PG','Family','88min.',56), ('Grease',1978,'PG','Musical','110min.',57), ('Green Acres--First Season',1966,'NOT RATED','TV Series',NULL,58), ('Groundhog Day',1993,'PG-13','Comedy','101min.',59), ('Harry Potter 1',2002,'PG','Action','152min.',60), ('Harry Potter 2',2003,'PG','Action','161min.',61), ('Hildago',2004,'PG-13','Action','136 min.',62), ('Holes',2003,'PG','Family','117min.',63), ('Home Alone',1990,'PG','Comedy','103min.',64), ('Home Alone 2',1992,'PG','Comedy','105min.',65), ('Hook',1991,'PG','Action','142min.',66), ('Hoosiers',1986,'PG','Family','115min.',67), ('How the Grinch Stole Christmas',1970,'NOT RATED','Christmas','60min.',68), ('Ice Age',2002,'PG','Comedy','81min.',69), ('I\'ll be Home for Christmas',1998,'PG','Christmas','86min.',70), ('Independence Day',1996,'PG-13','Action','153min.',71), ('Indiana Jones and the Last Crusade',1989,'PG-13','Action','126 Minutes',72), ('Intolerable Cruelty',2003,'PG-13','Comedy','100min.',73); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('I-SPY',2003,'PG-13','Action','97min.',74), ('It Runs in the Family',2003,'PG-13','Comedy','109min.',75), ('Italian Job',2003,'PG-13','Action','110min.',76), ('Its a wonderful Life',NULL,'NOT RATED','Christmas','132min.',77), ('James Taylor Live',1998,'NOT RATED','Music','109min.',78), ('James Taylor Live at the BeaconTht.',1998,'NOT RATED','Music','109min.',79), ('Jethro Tull',2002,'NOT RATED','Music',NULL,80), ('John Q.',2002,'PG-13','Drama','112min.',81), ('Johnny English',2003,'PG','Comedy','88min.',82), ('Johnny Lingo',NULL,'NOT RATED','Church','103min.',83), ('Joshua',2002,'G','Drama','90min.',84), ('Jurassic Park',1996,'PG-13','Action','127min.',85), ('Jurassic Park 2: the Lost World',2000,'PG-13','Action','129min.',86), ('Jurassic Park 3',2001,'PG-13','Action','93min.',87), ('K-19 Widowmaker',2002,'PG-13','Action','137min.',88), ('Legally Blonde',2001,'PG-13','Comedy','96min.',89), ('Lemmings',2003,'NOT RATED','Church',NULL,90), ('License to Kill',1989,'PG-13','Action','133min.',91); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('Life is Beautiful',1998,'PG-13','Drama','116min.',92), ('Lost in Space',1998,'PG-13','Action','130min.',93), ('LOTR: The Fellowship of the Ring',2001,'PG-13','Action','178min.',94), ('LOTR: The Return of the King',2003,'PG-13','Action','200min.',95), ('LOTR: The Two Towers',2002,'PG-13','Action','179min.',96), ('Maid in Manhattan',2003,'PG-13','Chick-Flick','105min.',97), ('Master and Commander',2003,'PG-13','Action','138min.',98), ('Master of Disguise',2002,'PG','Family','114 min.',99), ('Matchstick Men',2003,'PG-13','Drama','116 min.',100), ('Men in Black',1997,'PG-13','Comedy','98min.',101), ('Men in Black 2',2002,'PG-13','Comedy','88min.',102), ('Miracle',2004,'PG','Family','136min.',103), ('Miracle on 34th Street',1994,'PG','Christmas','113min.',104), ('Monsters Inc.',2001,'G','Family','93min.',105), ('Mr. Deeds',2002,'PG-13','Comedy','97min.',106), ('Mr.Holland\'s Opus',1995,'PG','Family','143min.',107), ('My Big Fat Greek Wedding',2002,'PG','Comedy','95min.',108); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('Newsies',1983,'PG','Musical','121min.',109), ('Nine Months',1995,'PG-13','Comedy','106min.',110), ('Nottinghill',1999,'PG-13','Chick-Flick','124 min.',111), ('O Brother Where Art Thou?',2000,'PG-13','Comedy','103min.',112), ('Oceans Eleven',2001,'PG-13','Action','117min.',113), ('Oklahoma!',1955,'G','Musical','145min.',114), ('Out of Time',2003,'PG-13','Action','105min.',115), ('Overboard',1987,'PG','Comedy','112min.',116), ('Pearl Harbor',2001,'PG-13','Drama','183min.',117), ('Pirates of the Carribean',2003,'PG-13','Action','143min.',118), ('Pride and Prejudice',2003,'PG','Church','104 min.',119), ('Princess Diaries',2001,'G','Family','115min.',120), ('Queen: We will Rock You',2001,'NOT RATED','Music','90min.',121), ('Radio',2004,'PG','Family','109min.',122), ('The Day After Tomorrow',2004,'PG-13','Action','123 Minutes',268), ('Rear Window',1954,'PG','Drama','115min.',124), ('Remember the Titans',2001,'PG','Family','114min.',125), ('Revenge of the Pink Panther',1978,'PG','Comedy','103min.',126); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('Rigoletto',2002,'NOT RATED','Family','98min.',127), ('Romancing the Stone',1984,'PG','Action','106min.',128), ('Runaway Bride',1999,'PG','Chick-Flick','116 min.',129), ('Runaway Jury',2003,'PG-13','Drama','127min.',130), ('Rush Hour',2001,'PG-13','Comedy','97min.',131), ('Rush Hour 2',2001,'PG-13','Comedy','91min.',132), ('Sabrina',1995,'PG','Chick-Flick','127min.',133), ('Sade Lovers Live',2002,'NOT RATED','Music','116min.',134), ('The Santa Clause 2',2002,'G','Christmas','104min.',135), ('Santana Live: Supernatural',2000,'NOT RATED','Music',NULL,136), ('Seabiscuit',2003,'PG-13','Drama','141min.',137), ('Seconhand Lions',2003,'PG','Drama','110 Minutes',138), ('Seems Like Old Times',1980,'PG','Comedy','102min.',139), ('Seven Brides for Seven Brothers',1954,'G','Musical','102min.',140), ('Shanghai Knights',2003,'PG-13','Comedy','114min.',141), ('Shanghai Noon',2000,'PG-13','Comedy','110min.',142), ('Shelter: Moonshine Experiment #3',NULL,'NOT RATED','Music',NULL,143), ('Shrek',2001,'PG','Family','93min.',144); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('Sleepless in Seattle',1999,'PG','Chick-Flick','105min.',145), ('Spiderman',2002,'PG-13','Action','121min.',146), ('Spies Like Us',1985,'PG','Comedy','102min.',147), ('Starwars 1: The Phantom Menace',2001,'PG','Action','133 Minutes',148), ('Starwars 2: Attack of the Clones',1977,'PG','Action','143 Minutes',149), ('Starwars 4: A New Hope',1980,'PG','Action','121 Minutes',150), ('Starwars 5: The Empire Strikes Back',1983,'PG','Action','124 Minutes',151), ('Starwars 6: Return of the Jedi',2002,'PG','Action','142min.',152), ('Steely Dan\'s: 2 Against Nature',2000,'NOT RATED','Music','102min.',153), ('Stepmom',1999,'PG-13','Drama','125 min.',154), ('Sting: The Brand New Day Tour',2000,'NOT RATED','Music',NULL,155), ('Sweet Home Alabama',2003,'PG-13','Chick-Flick','109min.',156), ('That Thing you do!',1996,'PG','Musical','105min.',157), ('The American President',1995,'PG-13','Chick-Flick','115min.',158), ('The Apple Dumpling Gang',1975,'G','Family','100min.',159), ('The Beatles: A Hard Day\'s Night',NULL,'G','Music','92min.',160); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('The Bishop\'s Wife',1947,'NOT RATED','Christmas','109min.',161), ('The Bourne Identity',2002,'PG-13','Action','119min.',162), ('The Count of Monte Christo',2002,'PG-13','Drama','131min.',163), ('The Doors Collection',1985,'NOT RATED','Music','172min.',164), ('The Emperors New Groove',2000,'G','Family','77min.',165), ('The Family Man',2001,'PG-13','Drama','126min.',166), ('The Fugitive',2001,'PG-13','Action','130min.',167), ('The Ghost and Mr. Chicken',1966,'NOT RATED','Family','90min.',168), ('The Grinch',2001,'PG','Christmas','105min.',169), ('The Incredible Mr.Limpet',1964,'G','Family','99min.',170), ('The In-Laws',2003,'PG-13','Comedy','98min.',171), ('The Jungle Book',1994,'PG','Family','111min.',172), ('The Kid',1998,'PG','Family','104min.',173), ('The Lion King',1994,'G','Family','90min.',175), ('The Man from Snowy River',1982,'PG','Family','104min.',176), ('The Man in the Iron Mask',1998,'PG-13','Action','132min.',177), ('The Man Who Knew Too Little',1997,'PG','Comedy','94min.',178); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('The Man with the Golden Gun',1974,'PG','Action','125min.',179), ('The Mask of Zorro',2000,'PG-13','Action','137min.',180), ('The Mighty Ducks',1992,'PG','Family','104min.',181), ('The Mighty Ducks 2',1994,'PG','Family','107min.',182), ('The Mighty Ducks 3',1996,'PG','Family','104min.',183), ('The Mummy',2000,'PG-13','Action','125min.',184), ('The Mummy Returns',2001,'PG-13','Action','140min.',185), ('The Music Man',1989,'G','Musical','151min.',186), ('The Musketeer',2001,'PG-13','Action','105min.',187), ('The Net',1997,'PG-13','Drama','114min.',188), ('The Other Side of Heaven',2003,'PG','Church','113min.',189), ('The Parent Trap',1998,'PG','Family','128min.',190), ('The Pink Panther',1964,'NOT RATED','Comedy','115min.',191), ('The Pink Panther Strikes Again',1976,'PG','Comedy','103min.',192), ('The Preacher\'s Wife',1996,'PG','Christmas','124min.',193), ('The R.M.',2003,'PG','Church','101min.',194), ('The Rookie',2002,'G','Family','127min.',195), ('The Sandlot',1993,'PG','Family','101min.',196); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('The Santa Clause',1994,'PG','Christmas','97min.',197), ('The Scorpion King',2002,'PG-13','Action','92min.',198), ('The Spy who loved me',1977,'PG','Action','125min.',199), ('The Sum of All Fears',2002,'PG-13','Action','123min.',200), ('The World is Not Enough',1999,'PG-13','Action','128min.',202), ('Tomorrow Never Dies',1997,'PG-13','Action','117 Minutes',203), ('Toy Story',1995,'G','Family','81 Minutes',204), ('Toy Story 2',1999,'G','Family','92 Minutes',205), ('Trail of the Pink Panther',1982,'PG','Comedy','97 Minutes',206), ('Truth and Conviction',2002,'NOT RATED','Drama','60 Minutes',207), ('U-571',2000,'PG-13','Action','117 Minutes',208), ('What About Bob?',1999,'PG','Comedy','99 Minutes',209), ('What Dreams May Come',1998,'PG-13','Drama','114 Minutes',210), ('While You were Sleeping',NULL,'PG','Chick-Flick','103 Minutes',211), ('White Christmas',1954,'NOT RATED','Christmas','120 Minutes',212), ('X2',2003,'PG-13','Action','134 Minutes',213), ('X-MEN',2000,'PG-13','Action','104 Minutes',214); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('Young Frankenstein',1974,'PG','Comedy','106 Minutes',215), ('Youve Got Mail',1999,'PG','Chick-Flick','120 Minutes',216), ('Rustlers Rhapsody',1985,'PG','Comedy','88 Minutes',0), ('MASH',1972,'NOT RATED','Drama','612 Minutes',218), ('Laverne and Shirley',1976,'NOT RATED','TV Series','373 Minutes',219), ('The Beverly Hillbillies',NULL,'NOT RATED','Comedy','200 Minutes',220), ('Petticoat Junction',1963,'NOT RATED','TV Series','182 Minutes',221), ('Andy Griffith',NULL,'NOT RATED','TV Series','102 Minutes',222), ('Follow Me Boys',1966,'G','Family','133 Minutes',223), ('The Prince and Me',2004,'PG','Chick-Flick','110 Minutes',224), ('Mona Lisa Smile',2004,'PG-13','Chick-Flick','120 Minutes',225), ('The Legend of Johnny Lingo',2003,'PG','Family','91 Minutes',226), ('Welcome to Mooseport',2003,'PG-13','Comedy','115 Minutes',227), ('Aladdin',1992,'G','Family','90 Minutes',228), ('Yours, Mine and Ours',1968,'NOT RATED','Family','111 Minutes',229), ('Shrek 2',2003,'PG','Family','92 Minutes',230); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('Miracle on 34th Street',1947,'NOT RATED','Christmas','97 Minutes',231), ('Mr. Mom',1983,'PG','Comedy','91 Minutes',232), ('A Walk to Remember',2002,'PG','Chick-Flick','102 Minutes',275), ('Mulan',2004,'G','Family','88 Minutes',234), ('Elf',2003,'PG','Christmas','95 Minutes',235), ('The Cutting Edge',1992,'PG','Chick-Flick','102 Minutes',236), ('Harry Potter and the Prisoner of Azkaban',2004,'PG','Action','142 Minutes',237), ('The Terminal',2004,'PG-13','Drama','129 Minutes',238), ('Spiderman 2',2004,'PG-13','Action','128 Minutes',239), ('The Best Two Years',2004,'PG','Church','109 Minutes',240), ('The Bourne Supremacy',2004,'PG-13','Action','109 Minutes',241), ('Mary Poppins',1964,'G','Musical','139 Minutes',242), ('Top Gun',1986,'PG','Action','109 Minutes',243), ('Robin Hood--Prince of Thieves',1991,'PG-13','Action','155 Minutes',244), ('George of the Jungle',1997,'PG','Family','92 Minutes',245), ('Snowball Express',1972,'G','Family','93 Minutes',246), ('Apple Dumpling Gang Rides Again',1979,'G','Family','89 Minutes',247); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('Rescuers Down Under',1990,'G','Family','77 Minutes',248), ('Return to Snowy River',1988,'PG','Drama','99 Minutes',249), ('The Cheap Detective',1978,'PG','Comedy','92 Minutes',250), ('Doc Hollywood',1991,'PG-13','Comedy','104 Minutes',251), ('Napoleon Dynamite',2004,'PG','Comedy','95 Minutes',252), ('Where the Red Fern Grows',1974,'NOT RATED','Family','98 Minutes',253), ('Swiss Family Robinson',1960,'G','Family','126 Minutes',254), ('Back to the Future',1985,'PG','Action','116 Minutes',255), ('Back to the Future II',1989,'PG','Action','108 Minutes',256), ('Back to the Future III',1990,'PG','Action','118 Minutes',257), ('Mulan II',2005,'G','Family','79 Minutes',258), ('Rod Stewart--It Had To Be You',2003,'NOT RATED','Music',NULL,259), ('Monk--Season One',2002,'NOT RATED','TV Series',NULL,260), ('Monk--Season Two',2005,'NOT RATED','TV Series',NULL,261), ('Five People you Meet in Heaven',2004,'NOT RATED','Drama','133 Minutes',262), ('Seinfeld--Seasons 1, 2 &3',2004,'NOT RATED','TV Series',NULL,263); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('Foul Play',1978,'PG','Comedy','116 Minutes',264), ('Shark Tale',2004,'PG','Family','90 Minutes',265), ('Indiana Jones and the Raiders of the Lost Ark',1981,'PG','Action','115 Minutes',266), ('Indian Jones and the Temple of Doom',1984,'PG','Action','118 Minutes',267), ('Green Acres--Second Season',1966,'NOT RATED','TV Series',NULL,269), ('The Jungle Book',1994,'PG','Family','111 Minutes',270), ('The In-Laws',2003,'PG-13','Comedy','98 Minutes',271), ('Finding Neverland',2004,'PG','Drama','101 Minutes',272), ('Ladder 49',2004,'PG-13','Drama','105 Minutes',273), ('With Honors',1994,'PG-13','Drama','101 Minutes',274), ('Spellbound',2002,'G',NULL,'127 minutes',276), ('Super Size Me',2004,'PG-13',NULL,'100 Minutes',277), ('Miracle of the White Stallions',1963,'G','Family','92 Minutes',278), ('The Client',1994,'PG-13','Action','121 Minutes',279), ('The Pelican Brief',1993,'PG-13','Drama','141 Minutes',280), ('Apollo 13',1995,'PG','Drama','140 Minutes',281), ('The Love Bug',1969,'G','Family','108 Minutes',282); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('Herbie Rides Again',1974,'G','Family','88 Minutes',283), ('Herbie Goes to Monte Carlo',1977,'G','Family','105 Minutes',284), ('Herbie Goes Bananas',1980,'G','Family','102 Minutes',285), ('The Call of Story',NULL,'NOT RATED',NULL,'57 Minutes',286), ('Top 10 Most Thrilling Moments in BYU Sports',NULL,'NOT RATED',NULL,NULL,287), ('Classic BYU Devotionals',2004,'NOT RATED','Church',NULL,288), ('To This End Was I Born',2004,'NOT RATED','Church','27 Minutes',289), ('Stories of Christmas',2004,'NOT RATED','Christmas','102 Minutes',290), ('BYU vs. Michigan--Football',1984,'NOT RATED',NULL,'170 Minutes',291), ('Ocean\'s Twelve',2004,'PG-13','Drama','125 Minutes',292), ('Waking Ned Devine',1998,'PG','Comedy','95 Minutes',293), ('Superman the Movie',1978,'PG','Action','154 Minutes',294), ('Superman II',1980,'PG','Action','127 Minutes',295), ('Superman III',1983,'PG','Action','125 Minutes',296), ('Superman IV',1987,'PG','Action','90 Minutes',297), ('The Work and the Glory',2005,'PG','Church','110 Minutes',298); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('The Phantom of the Opera',2004,'PG-13','Musical','141 Minutes',299), ('National Treasure',2005,'PG','Action','131 Minutes',300), ('Racing Stripes',2005,'PG','Comedy','102 Minutes',301), ('A Series of Unfortunate Events',2004,'PG','Family','107 Minutes',302), ('Saints and Soldiers',2005,'PG-13','Church','90 Minutes',303), ('Father of the Bride',1990,'PG','Comedy','105 Minutes',304), ('Hitch',2005,'PG-13','Comedy','118 Minutes',305), ('Miss Congeniality 2',2005,'PG-13','Comedy','115 Minutes',306), ('Monk---Season Three',2005,'NOT RATED','TV Series','11 hours 45 minutes',307), ('Million Dollar Baby',2004,'PG-13','Drama','132 Minutes',308), ('The Cosby Show--Season 1',1984,'NOT RATED','TV Series',NULL,309), ('Sahara',2005,'PG-13','Action','123 Minutes',310), ('Private Eyes',1981,'PG','Comedy','91 Minutes',311), ('American Mormon',2005,'NOT RATED','Church','35 Minutes',312), ('Hotel Rwanda',2004,'PG-13','Drama','122 Minutes',313), ('Heros',2005,'NOT RATED','Church','99 minutes',314); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('So I Married An Axe Murderer',1999,'PG-13','Comedy','93 Minutes',315), ('Tootsie',1982,'PG','Comedy','116 Minutes',316), ('Cinderella',1950,'G','Family','76 Minutes',317), ('Baptists at our Barbecue',2004,'PG','Church','93 Minutes',318), ('Legacy',2004,'NOT RATED','Church','52 Minutes',319), ('Batman Begins',2005,'PG-13','Action','140 Minutes',320), ('Herbie Fully Loaded',2005,'G','Family','102 Minutes',321), ('Bewitched',1964,'NOT RATED','TV Series','76 Minutes',322), ('Bewitched (The Movie)',2005,'PG-13','Comedy','102 Minutes',323), ('Starwars 3: Revenge of the Sith',2005,'PG-13','Action','140 Minutes',324), ('Christmas with the Kranks',2004,'PG','Christmas','99 minutes',325), ('Hogan\'s Heroes',1965,'NOT RATED','TV Series','13 Hours 42 Minutes',326), ('Madagascar',2005,'PG','Family','86 Minutes',327), ('Chigago/Earth Wind & Fire',2004,'NOT RATED','Music','172 Minutes',328), ('Simon & Garfunkel--Old Friends Live on Stage',2004,'NOT RATED','Music','140 Minutes',329), ('Cellular',2004,'PG-13','Action','95 Minutes',330); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('The Eagles Farewell 1 Tour---Live From Melbourne',2005,'NOT RATED','Music','175 Minutes',331), ('Billy Joel--The Essential Video Collection',2001,'NOT RATED','Music','105 Minutes',332), ('Ever After',1998,'PG-13','Chick-Flick','121 Minutes',333), ('Maverick',1994,'PG','Comedy','127 Minutes',334), ('Jingle All The Way',1996,'PG','Christmas','88 Minutes',335), ('Uncle Buck',1989,'PG','Comedy','100 Minutes',336), ('Malcolm in the Middle--1st Season',2000,'NOT RATED','TV Series','300 Minutes',337), ('The Polar Express',2004,'G','Christmas','100 Minutes',338), ('War of the Worlds',2005,'PG-13','Action','117 Minutes',339), ('Mr. & Mrs. Smith',2005,'PG-13','Action','120 Minutes',340), ('Fantastic 4',2005,'PG-13','Action','106 Minutes',341), ('Cinderella Man',2005,'PG-13','Drama','144 Minutes',342), ('Three Dog NIght',2002,'NOT RATED','Music','85 Minutes',343), ('Silver Streak',1976,'PG','Comedy','113 Minutes',344), ('Mobsters and Mormons',2005,'PG','Church','93 Minutes',345), ('Jane Manning James',2005,'NOT RATED','Church','17 Minutes',346); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('Flight Plan',2005,'PG-13','Action','98 MInutes',347), ('Oliver Twist',2005,'PG-13','Drama','130 Minutes',348), ('The Legend of Zorro',2005,'PG-13','Action','130 Minutes',349), ('Harry Potter and the Goblet of Fire',2005,'PG-13','Action','157 Minutes',350), ('The Mountain of the Lord',NULL,'NOT RATED','Church','73 Minutes',351), ('Pride and Predjudice',2005,'PG','Chick-Flick','129 Minutes',352), ('Yours, Mine and Ours',2005,'PG','Comedy','87 MInutes',353), ('Lady and the Tramp',1955,'G','Family','76 Minutes',354), ('Rulon\'s Game',2004,'NOT RATED','Church','15 Minutes',355), ('Red Eye',2005,'PG-13','Action','85 Minutes',356), ('Wild Hearts Can\'t Be Broken',1991,'G','Family','89 MInutes',357), ('House--Season One',2004,'NOT RATED','TV Series','16 Hours 12 Minutes',358), ('The Gods Must Be Crazy',1980,'PG','Comedy','109 Minutes',359), ('Dreamer',2005,'PG','Family','106 Minutes',360), ('Chicken Little',2005,'G','Family','81 Minutes',361), ('The Shaggy Dog',1959,'G','Family','92 Minutes',362); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('The Shaggy D.A.',1976,'G','Family','91 Minutes',363), ('The Chronicles of Narnia',2005,'PG','Action','135 Minutes',364), ('The Greatest Game Ever Played',2005,'PG','Family','121 Minutes',365), ('The Ten Commandments',1956,'G','Church','136 Minutes',366), ('Something the Lord Made',2004,'NOT RATED','Drama','110 Minutes',367), ('Two Brothers',2005,'PG','Family','115 Minutes',368), ('Nanny McPhee',2005,'PG','Family','99 minutes',369), ('Boston Legal---Season One',2006,'NOT RATED','TV Series',NULL,370), ('The Pink Panther',2006,'PG','Comedy','93 Minutes',371), ('Eight Below',2006,'PG','Family','120 Minutes',372), ('Cheaper By The Dozen 2',2005,'PG','Comedy','94 Minutes',373), ('Glory Road',2006,'PG','Drama','106 Minutes',374), ('Firewall',2006,'PG','Action','105 Minutes',375), ('An Unfinished Life',2005,'PG-13','Drama','107 Minutes',376), ('Annapolis',2006,'PG-13','Drama','103 Minutes',377), ('Failure to Launch',2006,'PG-13','Chick-Flick','96 Minutes',378), ('Monk---Season Four',2005,'NOT RATED','TV Series','11 hours 33 minutes',379); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('High Crimes',2002,'PG-13','Action','115 Minutes',380), ('Nine to Five',1980,'PG','Comedy','110 Minutes',381), ('The Work and the Glory--American Zion',2005,'PG-13','Church','99 Minutes',382), ('New York Doll',2005,'PG-13','Church','78 Minutes',383), ('Isn\'t Being Good Good Enough?',2006,'NOT RATED','Church','74 Minutes',384), ('The Best 3 Hours of the Week',2006,'NOT RATED','Church','73 Minutes',385), ('Oliver Twist',1968,'G','Musical','153 Minutes',386), ('The Benchwarmers',2006,'PG-13','Comedy','85 Minutes',387), ('The Shaggy Dog',2006,'PG','Family','99 Minutes',388), ('House--Season Two',2006,'NOT RATED','TV Series','17 Hours 24 Minutes',389), ('The Lake House',2006,'PG','Chick-Flick','105 Minutes',390), ('Message In A Bottle',1999,'PG-13','Chick-Flick','126 Minutes',391), ('March of the Penguins',2005,'G',NULL,'80 Minutes',392), ('The Wild',2006,'G','Family','94 Minutes',393), ('The Sentinel',2006,'PG-13','Action','108 Minutes',394), ('Liar Liar',1997,'PG-13','Comedy','86 Minutes',395); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('The Little Mermaid',1989,'G','Family','83 Minutes',396), ('Over the Hedge',2006,'PG','Family','83 Minutes',397), ('Nacho Libre',2006,'PG','Comedy','92 Minutes',398), ('Air Force One (Edited)',1997,'NOT RATED','Action','124 Minutes',399), ('I spy (Edited)',2002,'NOT RATED','Comedy','97 Minutes',400), ('Patriot Games (Edited)',1992,'NOT RATED','Action','117 Minutes',401), ('Kiss the Girls (Edited)',1997,'NOT RATED','Action','111 Minutes',402), ('The Firm (Edited)',1993,'NOT RATED','Action','154 Minutes',403), ('Cars',2006,'G','Family','124 Minutes',404), ('DaVinci Code',2006,'PG-13','Action','149 Minutes',407), ('Mission Impossible III',2006,'PG-13','Action','126 Minutes',406), ('Ice Age--The Meltdown',2006,'PG','Family','91 Minutes',408), ('A Little Princess',1995,'G','Family','97 Minutes',409), ('The Secret Garden',1993,'G','Family','102 Minutes',410), ('Robin Hood (Disney)',1973,'G','Family','83 Minutes',411), ('Superman Returns',2006,'PG-13','Drama','154 Minutes',412); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('The Princess Bride',1987,'PG','Comedy','98 Minutes',413), ('Brian\'s Song',1971,'G','Drama','73 Minutes',414), ('Pirates of the Caribbean--Dead Man\'s Chest',2006,'PG-13','Drama','150 Minutes',415), ('The Willie and Martin Handcart Story',2006,'NOT RATED','Church','60 Minutes',416), ('Suits on the Loose',2006,'PG','Church','93 Minutes',417), ('The World\'s Fastest Indian',2005,'PG-13','Drama','127 Minutes',418), ('Blackbeard\'s Ghost',1968,'G','Family','107 Minutes',419), ('Church Ball',2006,'PG','Church','91 Minutes',420), ('October Sky',1999,'PG','Drama','108 Minutes',421), ('Witness (Edited)',1985,'NOT RATED','Drama','112 Minutes',422), ('Double Jeopardy (Edited)',1999,'NOT RATED','Drama','105 Minutes',423), ('The Guardian',2006,'PG-13','Drama','139 Minutes',424), ('The Illusionist',2006,'PG-13','Drama','109 Minutes',425), ('Open Season',2006,'PG','Family','86 Minutes',426), ('Facing the Giants',2006,'PG','Drama','111 Minutes',427), ('Flyboys',2006,'PG-13','Action','139 Minutes',428); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('Fllicka',2006,'PG','Family','95 Minutes',429), ('Casino Royale',2006,'PG-13','Action','144 Minutes',430), ('Peter Pan',1953,'G','Family','77 Minutes',431), ('The Prestige',2006,'PG-13','Drama','130 Mintes',432), ('The Pursuit of HappyNess',2006,'PG-13','Drama','117 Minutes',433), ('Charlotte\'s Web',2006,'G','Family','96 Minutes',434), ('Pete\'s Dragon',1977,'G','Family','129 Minutes',435), ('Night at the Museum',2006,'PG','Comedy','108 Minutes',436), ('The Work and the Glory III',2007,'PG','Church','93 Minutes',437), ('Dejavu',2006,'PG-13','Action','128 MInutes',438), ('Planet Earth',2006,'PG','TV Series','660 Minutes',439), ('Breach',2007,'PG-13','Action','111 Minutes',440), ('Music and Lyrics',2007,'PG-13','Drama','105 Minutes',441), ('Bridge to Tarabithia',NULL,'PG','Family','96 Minutes',442), ('Monk--Season Five',2007,'NOT RATED','TV Series',NULL,443), ('Psych--Season One',2007,'NOT RATED','TV Series',NULL,444), ('Premonition',2007,'PG-13','Drama','110 Minutes',445); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('Wild Hogs',2007,'PG-13','Comedy','100 Minutes',446), ('The Ultimante Gift',2006,'PG','Drama','117 Minutes',447), ('Blades of Glory',2007,'PG-13','Comedy','93 Minutes',448), ('The Astromaut Farmer',2007,'PG','Family','104 Minutes',449), ('We Are Marshall',2006,'PG','Drama','131 Minutes',450), ('Love\'s Abiding Joy',2006,'PG','Family','87 Minutes',451), ('Love Comes Softly',2002,'NOT RATED','Family','88 Minutes',452), ('Love\'s Enduring Promise',2007,'NOT RATED','Family','87 Minutes',453), ('Love\'s Long Journey',2005,'NOT RATED','Family','85 Minutes',454), ('Rocky Balboa',2007,'PG','Drama','102 Minutes',455), ('The Jungle Book',1967,'G','Family','78 Minutes',456), ('Meet the Robinsons',2007,'G','Family','95 Minutes',457), ('The Christmas Classics',NULL,'G','Christmas',NULL,458), ('Surf\'s Up',2007,'PG','Family','85 Minutes',459), ('Ratatouille',2007,'G','Family','111 Minutes',460), ('Evan Almighty',2007,'PG','Family','96 Minutes',461), ('Ocean\'s Thirteen',2007,'PG-13','Drama','122 Minutes',462); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('It\'s A Wonderful LIfe--Color',1946,'NOT RATED','Christmas','130 Minutes',463), ('The Times and Teachings of Jospeph Smith',2007,'NOT RATED','Church','70 MInutes',464), ('Shrek the Third',2007,'PG','Family','92 Minutes',465), ('Live Free or Die Hard',2007,'PG-13','Action','129 Minutes',466), ('Mr. Bean\'s Holiday',2007,'G','Comedy','90 Minutes',467), ('Santa Clause 3--The Escape Clause',2006,'G','Christmas','92 Minutes',468), ('Hairspray',2007,'PG','Musical','117 Minutes',469), ('The Bourne Ultimatum',2007,'PG-13','Action','116 Minutes',470), ('Harry Potter and the Order of the Phoenix',2007,'PG-13','Action','139 Minutes',471), ('The Singles 2nd Ward',2007,'NOT RATED','Church','86 Minutes',472), ('Return with Honor',2007,'NOT RATED','Church','105 Minutes',473), ('Support Your Local Sheriff',1968,'G','Comedy','93 Minutes',474), ('Support Your Local Gunfighter',1971,'G','Comedy','93 Minutes',475), ('Mary Poppins',1964,'G','Musical','139 Minutes',476), ('Dr. Dolittle',1998,'PG-13','Comedy','85 Minutes',477); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('The Wizard of Oz',1939,'G','Musical','103 Minutes',478), ('Mr. Magorium\'s Wonder Emporium',2007,'G','Christmas','94 Minutes',479), ('101 Dalmations',1961,'G','Family','79 Minutes',480), ('Tin Man',2007,'NOT RATED','TV Series',NULL,481), ('Hunt for Red October',1990,'PG','Action','135 Minutes',482), ('Throw Momma from the Train',1987,'PG-13','Comedy','88 Minutes',483), ('XXX',2002,'PG-13','Action','124 Minutes',484), ('Airplane',1980,'PG','Comedy','87 Minutes',485), ('Mission Impossible 2',2000,'PG-13','Action','123 Minutes',486), ('Pay it Forward',2000,'PG','Drama','123 Minutes',487), ('A River Runs Through It',1992,'PG','Drama','124 Minutes',488), ('The Wicker Man',2006,'PG-13','Drama','102 Minutes',489), ('Bee Movie',2007,'PG','Family','90 Minutes',490), ('August Rush',2007,'PG','Drama','113 Minutes',491), ('Dan In Real Life',2007,'PG-13','Comedy','90 Minutes',492), ('The Kite Runner2007',2007,'PG-13','Drama','127 Minutes',493), ('National Treasure 2',2008,'PG','Drama','125 Minutes',494); INSERT INTO `eaglebre_watsonhome`.`Watson_DVD_Library` VALUES ('P.S. I Love You',2008,'PG-13','Chick-Flick','127 Minutes',495), ('Fool\'s Gold',2008,'PG-13','Drama','112 Minutes',496), ('Gordon B. Hinckley',2008,'NOT RATED','Church','59 Minutes',497), ('The Bucket List',2008,'PG-13','Comedy','97 Minutes',498), ('Passage to Zarahelmla',2008,'PG-13','Church','107 Minutes',499), ('Vantage Point',2008,'PG-13','Action','90 Minutes',500); UNLOCK TABLES; /*!40000 ALTER TABLE `Watson_DVD_Library` ENABLE KEYS */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;