# phpMyAdmin MySQL-Dump # http://phpwizard.net/phpMyAdmin/ # # Host: mysql.serve.com Database : mcudlproto # -------------------------------------------------------- # # Table structure for table 'games' # CREATE TABLE games ( id tinyint(4) DEFAULT '0' NOT NULL, field tinyint(4) DEFAULT '0' NOT NULL, home_team_id tinyint(4) DEFAULT '0' NOT NULL, away_team_id tinyint(4) DEFAULT '0' NOT NULL, game_day varchar(10) DEFAULT 'TBD' NOT NULL, home_score tinyint(4) DEFAULT '0' NOT NULL, away_score tinyint(4) DEFAULT '0' NOT NULL ); # # Dumping data for table 'games' # INSERT INTO games VALUES ( '1', '5', '1', '5', '05/01/2002', '0', '0'); INSERT INTO games VALUES ( '2', '2', '1', '5', '05/02/2002', '17', '6'); INSERT INTO games VALUES ( '3', '1', '5', '1', '06/01/2002', '3', '15'); INSERT INTO games VALUES ( '4', '1', '5', '1', '06/03/2002', '4', '15'); INSERT INTO games VALUES ( '5', '3', '5', '1', '06/05/2002', '4', '15'); INSERT INTO games VALUES ( '6', '4', '1', '5', '06/06/2002', '0', '0'); INSERT INTO games VALUES ( '7', '1', '1', '5', '06/07/2002', '0', '0'); INSERT INTO games VALUES ( '8', '1', '5', '6', '06/07/2002', '0', '0'); INSERT INTO games VALUES ( '9', '1', '4', '3', '06/01/2002', '3', '15'); INSERT INTO games VALUES ( '10', '1', '4', '3', '06/04/2002', '15', '4'); INSERT INTO games VALUES ( '11', '5', '4', '3', '05/01/2002', '0', '0'); INSERT INTO games VALUES ( '12', '5', '3', '7', '05/20/2002', '0', '15'); # -------------------------------------------------------- # # Table structure for table 'player' # CREATE TABLE player ( id varchar(40) DEFAULT '0' NOT NULL, LastName varchar(60) NOT NULL, FirstName varchar(60), NickName varchar(60), Street varchar(128), City varchar(60), State char(2), ZipCode varchar(10), EmailAddress varchar(128), HomePhone varchar(12), WorkPhone varchar(12), CurrentUPAMember char(1), SkillLevel char(2), FitnessLevel char(2), YearsClub char(2), YearsRecreation char(2), Baggage1 varchar(128), Baggage2 varchar(128) NOT NULL, Baggage3 varchar(128) NOT NULL, WillCaptain char(1), Sex char(1), Birthdate varchar(11), password varchar(128) NOT NULL, isAdmin char(1) DEFAULT 'N' NOT NULL, playingA char(1) NOT NULL, playingDraft char(1) NOT NULL ); # # Dumping data for table 'player' # INSERT INTO player VALUES ( 'Kieffer', 'Kieffer', 'Darwin Billy', NULL, '2 Belfast Ct.', 'Hamilton', 'NJ', '08610', 'DWK13@aol.com', '6095810076', '', 'Y', '2', '2', '0', '3', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Foundos', 'Foundos', 'Ed', NULL, '1643-B Bluebird Dr.', 'Yardley', 'PA', '19067', 'edward.foundos@csfb.com', '2153693230', '6092430733', 'Y', '2', '3', '0', '4', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Gyori', 'Gyori', 'Peter (Crash)', NULL, '815 Bradley Ct.', 'Mt. Laurel', 'NJ', '08054', 'pgyori@hotmail.com', '8566421653', '8566086461', 'N', '3', '3', '10', '10', '', '', '', 'Y', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Bencivengo', 'Bencivengo', 'Craig Milo', NULL, '11-20 Pheasant Hollow Dr.', 'Plainsboro', 'NJ', '08536', 'cbenci@home.com', '6097507368', '9082365816', 'Y', '3', '2', '7', '7', '', '', '', 'Y', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Eisner', 'Eisner', 'Ari', NULL, '2131 Brunswick Ave.', 'Lawrenceville', 'NJ', '08648', 'arisafari@spa.net', '6093942252', '', 'N', '2', '3', '7', '5', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Dunn', 'Dunn', 'Jason', NULL, '1405 Pennington Rd.', 'Ewing', 'NJ', '08618', 'jdbogota@hotmail.com', '6094067993', '2155044444', 'N', '0', '2', '0', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Ferrer', 'Ferrer', 'Jessica', NULL, '21 Nathaniel Green Rd.', 'Titusville', 'NJ', '08560', 'jest2001@aol.com', '6097372452', '', 'N', '0', '2', '0', '0', 'Ben Ferrer', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Ferrer', 'Ferrer', 'Ben', NULL, '19 W. Delaware Ave. Apt. A', 'Pennington', 'NJ', '08534', 'benferrer@yahoo.com', '6098189178', '6094521212', 'N', '2', '2', '2', '0', 'Jesse Ferrer', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Perrott', 'Perrott', 'Simon', NULL, '20113 Heather Dr.', 'Princeton Jct.', 'NJ', '08550', 'simon.perrott@factiva.com', '6092750447', '', 'N', '2', '3', '0', '0', 'Larry Monagle', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Monagle', 'Monagle', 'Larry', NULL, '22122 Heather Dr.', 'Princeton Jct.', 'NJ', '08550', 'lawrence.monagle@dowjones.com', '6099360281', '6095204410', 'N', '0', '1', '0', '0', 'Simon Perrott', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Hoel', 'Hoel', 'Kevin', NULL, '544 S. Clinton Ave.', 'Trenton', 'NJ', '08611', '', '6096568810', '', 'N', '1', '2', '3', '4', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Jun', 'Jun', 'Andrew', NULL, '121 Alberts Way', 'Langhorne', 'PA', '19047', 'aj302@columbia.edu', '2155791212', '6466238486', 'N', '1', '2', '0', '3', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Rodriguez', 'Rodriguez', 'Bob', NULL, 'P.O. Box 1042', 'New Providence', 'NJ', '07974', 'rdrodrigue@hotmail.com', '9087041331', '9082560941', 'Y', '2', '3', '0', '3', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Martus', 'Martus', 'Sheila', NULL, '151 Orchard St. Apt. 2', 'Bloomfield', 'NJ', '07003', '', '9734299619', '2122649200', 'Y', '2', '2', '3', '7', '', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Buriani', 'Buriani', 'Michael', '', '175 Briner Lane', 'Hamilton Sq.', 'NJ', '', 'mburiani@aol.com', '', '', 'Y', '3', '3', '15', '18', '', '', '', 'Y', 'M', '01/01/1900', 'no3ntry!', 'Y', 'Y', 'Y'); INSERT INTO player VALUES ( 'Kemp', 'Kemp', 'Jackie', NULL, '4 Spokane Lane', 'Branchburg', 'NJ', '08876', 'jskemp1@earthlink.net', '9085411166', '9084296110', 'N', '1', '2', '0', '3', '', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Quallick', 'Quallick', 'Jeff', NULL, '1581 Clark Dr.', 'Yardley', 'PA', '19067', 'lizardQ13@aol.com', '2154939817', '2159435555', 'N', '1', '1', '0', '2', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Maimone', 'Maimone', 'Frank', NULL, '1 Tracy Dr.', 'E. Brunswick', 'NJ', '08816', 'famai@aol.com', '7326131050', '7326900583', 'N', '1', '2', '0', '4', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Pascale', 'Pascale', 'Andrew', NULL, '101 Dewey St.', 'Toms River', 'NJ', '08753', 'patch@alumni.nd.edu', '7323415853', '6099129400', 'Y', '2', '2', '4', '3', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Kolomeyer', 'Kolomeyer', 'Anton', NULL, '119 N. 10th Ave.', 'Highland Park', 'NJ', '08904', 'adog173075@aol.com', '7328198738', '', 'N', '2', '2', '2', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Chen', 'Chen', 'Dan', NULL, '148 Ethel Road', 'Edison', 'NJ', '08817', '', '7322488308', '', 'N', '2', '2', '2', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Scheraga', 'Scheraga', 'Nancy', NULL, '3114 Quail Ridge Dr.', 'Plainsboro', 'NJ', '08536', '', '6097509397', '6094435100', 'Y', '2', '2', '6', '3', '', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Sigal', 'Sigal', 'Dan', NULL, '1487 Woodview Rd.', 'Yardley', 'PA', '19067', 'superelf16@aol.com', '2154931153', '', 'Y', '1', '1', '', '1', 'Chris Low', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Funches', 'Funches', 'Risharde', NULL, '1352 Brentwood Rd.', 'Yardley', 'PA', '19067', 'risharde@earthlink.net', '2155790167', '2158607033', 'N', '2', '2', '4', '3', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Bonn', 'Bonn', 'R. Timothy', NULL, '17-J Lincoln Place', 'North Brunswick', 'NJ', '08902', 'tbonn@princeton.com', '7324222230', '6099878787', 'N', '3', '1', '4', '6', '', '', '', 'Y', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Draine', 'Draine', 'David', NULL, '229 Shadybrook Lane', 'Princeton', 'NJ', '08540', 'ddraine@princeton.edu', '6099868997', '', 'Y', '2', '3', '1', '2', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Low', 'Low', 'Chris', NULL, '1321 Lexington Dr.', 'Yardley', 'PA', '19067', 'clow82@aol.com', '2154934750', '', 'N', '0', '1', '0', '0', 'Dan Sigal', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Anouna', 'Anouna', 'Larry', NULL, '55 Garrison', 'Willingboro', 'NJ', '08046', 'anouna@sprintmail.com', '6098772862', '2159236600', 'Y', '3', '2', '14', '19', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Marino', 'Marino', 'John', NULL, 'B4 East Garden Way', 'Dayton', 'NJ', '08810', 'jmarino@evanseast.com', '7323550446', '6093714800', 'N', '2', '2', '6', '10', 'Roni Todd', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Todd', 'Todd', 'Roni', NULL, 'B4 East Garden Way', 'Dayton', 'NJ', '08810', 'ronitodd@hotmail.com', '7323550446', '', 'N', '1', '1', '0', '3', 'John Marino', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Kolaski', 'Kolaski', 'Burt', NULL, '13 Juniper Ct.', 'Lawrenceville', 'NJ', '', 'agata@rcn.com', '6092191174', '', 'N', '3', '3', '10', '10', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Boikess', 'Boikess', 'Steve', NULL, '1 Wakefield Lane', 'Piscataway', 'NJ', '08854', 'boikess@war.wyeth.com', '7328782005', '7322744728', 'N', '2', '2', '4', '8', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Fell', 'Fell', 'Jeff', NULL, '', '', '', '', '', '', '', 'N', '3', '2', '', '10', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Kroschwitz', 'Kroschwitz', 'John', NULL, '14 Mae Dr.', 'Hamilton', 'NJ', '08620', 'jjpkros@smtp.lps.state.nj.us', '6095854436', '6096314733', 'N', '3', '2', '0', '15', '', '', '', 'Y', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Porrazza', 'Porrazza', 'John', NULL, '2090 Dawn Lane', 'Newtown', 'PA', '18940', 'razza28@aol.com', '2155794643', '', 'N', '1', '2', '0', '2', 'Eric Han', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Stein', 'Stein', 'Alan', NULL, '42 Van Wyck Dr.', 'Princeton Jct.', 'NJ', '08550', 'ajs@ajsoft.com', '6097161929', '7329499088', 'N', '2', '2', '0', '8', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Shah', 'Shah', 'Sachin', NULL, '7 Louis Ct.', 'Edison', 'NJ', '08820', 'sach214@aol.com', '9087560131', '', 'N', '1', '2', '5', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Su', 'Su', 'Devlin', NULL, '22 Hilltown Ct.', 'Plainsboro', 'NJ', '08536', 'fishygoat@home.com', '6097501218', '', 'Y', '1', '2', '2', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Zou', 'Zou', 'Lily', NULL, '5 Osprey Lane', 'Cranbury', 'NJ', '08512', 'o101o101o@aol.com', '6092758316', '', 'Y', '1', '2', '2', '0', '', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Muentener', 'Muentener', 'Kristen', NULL, '14 E. Prospect St.', 'Hopewell', 'NJ', '08525', 'lefty834@yahoo.com', '6094661421', '', 'N', '0', '1', '0', '0', 'Alexis Johnson', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Johnson', 'Johnson', 'Alexis', NULL, '22 Morningside Dr.', 'Pennington', 'NJ', '08534', 'clio268@aol.com', '6097378104', '', 'N', '1', '2', '0', '1', 'Kristen Muentener', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Chen', 'Chen', 'Ken', NULL, '31 Sandalwood Dr.', 'Edison', 'NJ', '08820', 'k_chenneth@yahoo.com', '7328272827', '', 'N', '1', '2', '4', '1', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Lahet', 'Lahet', 'Steve', NULL, '105 Kingsberry Dr.', 'Somerset', 'NJ', '08873', 'mcudl@morningglory.com', '7327291970', '7327291970', 'N', '3', '1', '10', '15', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Hsieh', 'Hsieh', 'Jonathan', NULL, '6 Wilson Way South', 'W. Windsor', 'NJ', '08550', 'krippa@aol.com', '6099361457', '6099361457', 'N', '1', '2', '1', '1', 'Catherine Cheung', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Bishop', 'Bishop', 'Brian', NULL, '25 Bank St. Apt. 2', 'Princeton', 'NJ', '08540', 'brian@mochasteak.com', '6096830302', '6098657454', 'N', '2', '2', '5', '3', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Cheung', 'Cheung', 'Catherine', NULL, '3 Penrose Lane', 'W. Windsor', 'NJ', '08550', 'squirrelgirlnuts@bigfoot.com', '6092750974', '', 'N', '0', '1', '0', '0', 'Jonathon Hsieh', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Lallier', 'Lallier', 'Ed', NULL, '39-04 Ravens Crest Dr.', 'Plainsboro', 'NJ', '08536', 'tlallier@bloomberg.net', '6097161896', '6098061226', 'N', '3', '2', '4', '2', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Han', 'Han', 'Eric', NULL, '2062 E. Wellington Rd.', 'Newtown', 'NJ', '18940', 'eric_han@hotmail.com', '2159681746', '', 'N', '0', '2', '0', '0', 'John Porrazza', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Lynch', 'Lynch', 'Hugh', NULL, '2 Lemore Circle', 'Rocky Hill', 'NJ', '08553', 'hugh.lynch@rssgroup.com', '6096880903', '6094307400', 'N', '3', '2', '4', '3', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Nadbau', 'Nadbau', 'Ted', NULL, '16 Park Pl.', 'Princeton', 'NJ', '08540', 'dotline@dotline.com', '6094970536', '6094307400', 'N', '0', '1', '0', '0', 'Greg Besner', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Besner', 'Besner', 'Greg', NULL, '1 Ivy Terrace', 'Millburn', 'NJ', '07041', 'breg.besner@rssgroup.com', '9739211297', '6094307400', 'N', '0', '2', '0', '0', 'Ted Nadbau', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Studholme', 'Studholme', 'Joe', NULL, '28 Markham Rd.', 'Princeton', 'NJ', '08540', 'Joes@alumni.princeton.edu', '6099218566', '6094307400', 'Y', '3', '3', '20', '20', '', '', '', 'Y', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Simon', 'Simon', 'Rachelle', NULL, '150 Patton Ave.', 'Princeton', 'NJ', '08540', 'wingreen@research.nj.nec.com', '6092520051', '6099512654', 'N', '1', '2', '3', '10', 'Ned Wingreen', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Wingreen', 'Wingreen', 'Ned', NULL, '150 Patton Ave.', 'Princeton', 'NJ', '08540', 'wingreen@research.nj.nec.com', '6092520051', '6099512654', 'N', '2', '2', '1', '10', 'Rachelle Simon', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Sun', 'Sun', 'Nancy', NULL, '17 Huntington Dr.', 'Princeton Jct.', 'NJ', '08550', 'nancy@mit.edu', '6092751748', '', 'Y', '2', '2', '1', '1', 'Matt Anderegg/Isaac Cohen', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Vallone', 'Vallone', 'Lee', NULL, '28 Red Coach Ln.', 'Locust', 'NJ', '07760', 'lvallone@lucent.com', '7322915425', '7329494651', 'N', '2', '1', '15', '10', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Marano', 'Marano', 'Michael', NULL, '30 Dancer Dr.', 'Trenton', 'NJ', '08610', 'mudshark11@aol.com', '6095817704', '6097347016', 'N', '2', '2', '0', '12', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'O\'Donnell', 'O\'Donnell', 'Paul (Odie)', NULL, '172 Carson St.', 'Somerset', 'NJ', '08873', 'odonnell53@hotmail.com', '7325371250', '', 'N', '3', '3', '8', '7', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Kerr', 'Kerr', 'Christopher', NULL, '38 Elm St.', 'Hopewell', 'NJ', '08525', 'ck@gfdl.noaa.gov', '6094661571', '6094526573', 'N', '1', '1', '1', '1', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Anderegg', 'Anderegg', 'Matthew', NULL, '5 Gulick Ln.', 'Plainsboro', 'NJ', '08536', 'mja105@columbia.edu', '6097999278', '', 'N', '1', '2', '0', '3', 'Nancy Sun/Isaac Cohen', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Meierlang', 'Meierlang', 'Todd', NULL, '5611 Town Court South', 'Lawrenceville', 'NJ', '08648', 'toddmeierlang@hotmail.com', '6097161239', '6094307400', 'N', '0', '1', '0', '0', 'Dave Genetti', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Genetti', 'Genetti', 'Dave', NULL, '19 Tree Farm Road', 'Monmouth Jct.', 'NJ', '08852', 'dgenetti@rssgroup.com', '7323550571', '6094307400', 'N', '0', '2', '0', '0', 'Todd Meierlang', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Howse', 'Howse', 'Andrew', NULL, '19 Tree Farm Road', 'Monmouth Jct.', 'NJ', '08852', 'andrew_howse@hotmail.com', '7323550571', '6094307400', 'N', '0', '2', '0', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Cohen', 'Cohen', 'Isaac', NULL, '184 Washington Rd.', 'Princeton', 'NJ', '08540', 'iscohen@vassar.com', '6094528221', '6094528221', 'Y', '2', '2', '2', '0', 'Matt Anderegg/Nancy Sun', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Springer', 'Springer', 'Nick', NULL, '363 Prince St.', 'Bordentown', 'NJ', '08505', 'nspringer@home.com', '6093241635', '2159223800', 'N', '2', '2', '13', '13', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Ruth', 'Ruth', 'Terry', NULL, '208 Chilton Way', 'Fairless Hills', 'PA', '19030', 'phishnut@hotmail.com', '2155476562', '2678797596', 'N', '0', '1', '0', '1', '', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'LeMay', 'LeMay', 'Debbie', NULL, '41 Oriole Dr.', 'W. Trenton', 'NJ', '08628', 'xenadsl@home.com', '6095380084', '', 'Y', '3', '2', '11', '13', '', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Conover', 'Conover', 'Kevin', NULL, '63 Joni Ave.', 'Hamilton Sq.', 'NJ', '08690', 'kevin.conover@dot.state.nj.us', '6095852488', '6095303482', 'N', '3', '2', '10', '14', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Fort', 'Fort', 'Scott', NULL, '316 S. Main St.', 'Pennington', 'NJ', '08534', 'imscooter1@home.com', '6097370752', '6097301010', 'N', '2', '3', '0', '5', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Knigge', 'Knigge', 'Chris', NULL, '147 Birch Ave.', 'Princeton', 'NJ', '08542', '', '6094972343', '6094977636', 'N', '3', '2', '0', '15', '', '', '', 'Y', 'N', '01/01/1900', 'no3ntry!', 'Y', 'Y', 'Y'); INSERT INTO player VALUES ( 'Burns', 'Burns', 'Sean', NULL, '248 Mapleton Rd.', 'Princeton', 'NJ', '08540', 'sburns@princetonboro.org', '6094521399', '6094977630', 'N', '2', '2', '0', '6', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Harpel', 'Harpel', 'Mario', NULL, '4 Fieldstone Rd.', 'Princeton', 'NJ', '08540', 'mario.harpel@globalriskconsultants.com', '6099191247', '7326354429', 'N', '1', '2', '0', '1', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Bauser', 'Bauser', 'Adam', NULL, '6 Brookline Ct.', 'Princeton', 'NJ', '08540', 'bauser@rcn.com', '6096830920', '6098968613', 'Y', '1', '2', '0', '1', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Warren', 'Warren', 'Ryan', NULL, '78 Coryell St.', 'Lambertville', 'NJ', '08530', 'ryan.warren@factiva.com', '6097730558', '6096272808', 'N', '2', '2', '0', '3', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Strang', 'Strang', 'Alan', NULL, '177 Regina Ave.', 'Mercerville', 'NJ', '08619', 'allan.strang@vw.com', '6095874276', '6098608808', 'N', '2', '3', '0', '12', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Coker', 'Coker', 'Richard', NULL, '643 Bayberry Lane', 'Yardley', 'PA', '19067', 'facelessnumber@email.com', '2153690465', '2156014860', 'Y', '1', '1', '0', '2', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Filler', 'Filler', 'Forrest', NULL, '25 Scott Lane', 'Princeton', 'NJ', '08540', 'edmundboy@aol.com', '6096834828', '6096838284', 'N', '2', '3', '5', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Sage', 'Sage', 'Dan', NULL, '', '', '', '', '', '', '', 'N', '1', '', '', '', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Wammer', 'Wammer', 'Gregory', NULL, '49 Smithfield Ave.', 'Lawrenceville', 'NJ', '08648', 'wsammergman@hotmail.com', '6096710395', '6099892765', 'N', '2', '2', '0', '1', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Barr', 'Barr', 'Jennifer', NULL, '4 Reigate Way', 'Titusville', 'NJ', '08560', 'frankieb53@mindspring.com', '6097371689', '', 'N', '1', '3', '0', '1', '', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Bresnen', 'Bresnen', 'Anthony', NULL, '49 Hemlock Ct.', 'Hamilton', 'NJ', '08619', 'jester7xx@aol.com', '6095847448', '6095204451', 'N', '1', '2', '0', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Bernstein', 'Bernstein', 'Richard', NULL, '2 O\'Neill Ct.', 'Lawrenceville', 'NJ', '08648', 'jedirab@aol.com', '6096899441', '6098061293', 'N', '2', '2', '3', '3', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Ryan', 'Ryan', 'Rick', NULL, '603 Ravens Crest Dr.', 'Plainsboro', 'NJ', '08536', 'rryan11@yahoo.com', '6097161326', '7323023893', 'N', '2', '3', '0', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Berger', 'Berger', 'Elliot', NULL, '63 Winchip Road', 'Summit', 'NJ', '', 'elliot_berger@ml.com', '9089632255', '6096274060', 'N', '2', '1', '6', '2', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Lee', 'Lee', 'Brian', NULL, '5 Norman Ct.', 'E. Brunswick', 'NJ', '08816', 'bribri@engine.umich.edu', '7323902854', '', 'Y', '2', '2', '1', '3', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Zupko', 'Zupko', 'Bill', NULL, '41 Oriole Dr.', 'W. Trenton', 'NJ', '08628', 'williamZ1@home.com', '6095380084', '', 'N', '3', '3', '10', '20', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Bane', 'Bane', 'Noah', NULL, '509 Brookbend Ct.', 'Yardley', 'PA', '19067', 'fenixtx1fan@aol.com', '2153211306', '', 'N', '0', '2', '0', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Rowley', 'Rowley', 'Michael', NULL, '2131 Brunswick Ave.', 'Lawrenceville', 'NJ', '08648', '', '6093942252', '', 'N', '1', '1', '0', '3', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Varhley', 'Varhley', 'Andrew', NULL, '17 Benjamin Trail', 'Pennington', 'NJ', '08534', 'phlyphisherman@aol.com', '6097372577', '', 'N', '0', '3', '0', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Hokenson', 'Hokenson', 'Greg', NULL, '264 Jacobs Creek Rd.', 'Titusville', 'NJ', '08560', 'broham777@aol.com', '6097371249', '', 'N', '0', '3', '0', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Pall', 'Pall', 'Jason', NULL, '1 Linden Ln.', 'Pennington', 'NJ', '08534', 'broham333@aol.com', '6097301790', '', 'N', '0', '3', '0', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Finn', 'Finn', 'Edward', NULL, '0611 First Center', 'Princeton', 'NJ', '08544', 'edfinn@princeton.edu', '', '', 'Y', '2', '3', '3', '1', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Hamm', 'Hamm', 'Michael', NULL, '135 N. 7th Ave.', 'Highland Park', 'NJ', '08904', 'michael.hamm@oberlin.edu', '7328190871', '', 'N', '2', '3', '2', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Donnelly', 'Donnelly', 'Kevin', NULL, '5031 Rebecca Fell Dr.', 'Doylestown', 'PA', '18901', '', '2154899289', '2159684713', 'N', '1', '1', '0', '1', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Balog', 'Balog', 'Lauren', NULL, '1 Noel Lane', 'E. Brunswick', 'NJ', '08816', '1balog@gwu.edu', '7322386564', '', 'Y', '1', '2', '1', '0', '', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'LaFarge', 'LaFarge', 'Erin', NULL, '17 Devon Rd.', 'Newtown', 'PA', '18940', 'elafarge@brynmawr.edu', '2158605083', '6097308698', 'N', '0', '2', '0', '0', '', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Brown', 'Brown', 'Claire', NULL, '150 Cox Ave.', 'Morrisville', 'PA', '19067', 'cbrown@bates.edu', '2157369338', '', 'Y', '2', '2', '3', '0', '', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Mershon', 'Mershon', 'Jeff', NULL, '506 Brunswick Pike', 'Lambertville', 'NJ', '08530', '', '6093979188', '6097730892', 'N', '2', '1', '0', '12', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Taga', 'Taga', 'Ken', NULL, '', '', '', '', 'kenny_taga@hotmail.com', '2157528645', '', 'N', '1', '', '', '', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Kieffer1', 'Kieffer', 'Dave', NULL, '', '', 'NJ', '', '', '', '', 'N', '1', '2', '', '', '', '', '', 'N', 'M', '01/01/1900', '', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'DeBoer', 'DeBoer', 'Jeff', NULL, '', '', '', '', '', '', '', 'N', '1', '', '', '', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Hillman', 'Hillman', 'Bruce', NULL, '21 Edgemont Rd.', 'Trenton', 'NJ', '08620', 'sharkbait4you@aol.com', '6095814705', '', 'N', '2', '2', '0', '8', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Gupta', 'Gupta', 'Samir', NULL, '', '', '', '', '', '', '', 'N', '1', '', '', '', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Rosen', 'Rosen', 'Michael', NULL, '165 Wilshire Dr.', 'Belle Mead', 'NJ', '08502', 'michael_rosen@pds.k12.nj.us', '9082819868', '', 'N', '1', '2', '0', '3', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Kassler-Taub', 'Kassler-Taub', 'Mike', NULL, '177 Killdee Rd.', 'Belle Mead', 'NJ', '08502', 'mkt@pds.org', '9088744277', '', 'N', '1', '2', '0', '2', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Cooper', 'Cooper', 'Steve', NULL, '246 Hampshire Dr.', 'Plainsboro', 'NJ', '08536', 'loserdrums@yahoo.com', '6092757470', '', 'N', '1', '', '', '', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'DiMarco', 'DiMarco', 'Carmen', NULL, '6 Randi Way', 'Titusville', 'NJ', '08560', '', '', '', 'Y', '2', '1', '10', '20', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Kieffer2', 'Kieffer', 'Drew', NULL, '25 Arlington', 'Yardville', 'NJ', '08620', 'drew_kieffer@ap.org', '6098606961', '6095811943', 'N', '2', '1', '0', '12', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Snover', 'Snover', 'Jeffrey', NULL, '588 B South Dove Rd.', 'Yardley', 'PA', '19067', 'jeff.snover@dowjones.com', '2153215777', '6095204216', 'N', '1', '2', '2', '1', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Su', 'Su', 'Dustin', NULL, '175 Mundy Ave.', 'Edison', 'NJ', '08820', 'sud@umich.edu', '7325160619', '', 'N', '2', '2', '2', '2', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Becker', 'Becker', 'Christopher', NULL, '4455 Province Line Rd.', 'Princeton', 'NJ', '08540', 'chrisbecker@earthlink.net', '6099241402', '6099241358', 'N', '1', '2', '1', '2', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Weissman', 'Weissman', 'Ariel', NULL, '8 Amanda Ct.', 'E. Brunswick', 'NJ', '08816', 'aweiss01@emeraldtufts.edu', '7323907480', '', 'Y', '3', '3', '4', '1', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'MacDougal', 'MacDougal', 'Michael', NULL, '29 Baldwin St.', 'Pennington', 'NJ', '08534', 'mmacdougal@mesapathdsl.net', '6094979468', '6088189145', 'N', '1', '2', '1', '1', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Biarnes', 'Biarnes', 'Marta', NULL, '21 Spring Oak Dr.', 'Newtown', 'PA', '18940', 'mbiarnes@andrew.cmu.edu', '2158600226', '', 'N', '0', '2', '1', '0', '', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Klein', 'Klein', 'Grady', NULL, '', '', '', '', '', '', '', 'N', '1', '', '', '', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Hwang', 'Hwang', 'Eileen', NULL, '9 Villa Dr.', 'W. Windsor', 'NJ', '08550', 'ehwang@princeton.edu', '6092755972', '9085008257', 'Y', '1', '2', '1', '0', '', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Allen', 'Allen', 'Doug', NULL, '2122 N. Crescent Blvd', 'Yardley', 'PA', '19067', 'dougyfresh@aol.com', '2154935932', '', 'N', '0', '3', '0', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Wilkins', 'Wilkins', 'Mark', NULL, '', 'Lawrenceville', 'NJ', '08648', 'mwilkins@lawrenceville.org', '6096388634', '', 'N', '1', '', '', '', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Granger', 'Granger', 'Julie', NULL, '', '', '', '', '', '', '', 'N', '1', '', '', '', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Casill', 'Casill', 'Linda', NULL, '628 River Rd.', 'Belle Mead', 'NJ', '08502', 'linda.casill@zsassociates.com', '9082815501', '6094194515', 'N', '2', '2', '2', '2', '', '', '', 'Y', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Kalicki', 'Kalicki', 'Walt', NULL, '965B Bergen Ave.', 'No. Brunswick', 'NJ', '08902', 'waltkal@yahoo.com', '7328169530', '', 'Y', '3', '2', '3', '8', '', '', '', 'Y', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Jacobson', 'Jacobson', 'Howie', NULL, '141 Palmer Lane', 'Ewing', 'NJ', '08618', 'howiemia@yahoo.com', '6098831807', '', 'N', '2', '1', '0', '10', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Drobits', 'Drobits', 'Jeff', NULL, '35 Lowry Ct', 'Skillman', 'NJ', '08558', 'jdrobits@pvimage.com', '6094664788', '6099129400', 'Y', '1', '3', '', '12', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Keeton', 'Keeton', 'Brad', NULL, '11 Jed Ct.', 'Hamilton', 'NJ', '08609', 'bradkeet@hotmail.com', '6099372435', '', 'N', '3', '2', '1', '5', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Jaeger', 'Jaeger', 'Michael', NULL, '965B Bergen Ave.', 'No. Brunswick', 'NJ', '08902', 'mjjaeger@hotmail.com', '6099150515', '9083064692', 'N', '3', '2', '4', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Fring', 'Fring', 'Kyle', NULL, '402 Federal Lane', 'Morrisville', 'PA', '19067', 'okie@aol.com', '2159624870', '2159624870', 'N', '1', '2', '0', '1', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Lafferty', 'Lafferty', 'Joe', NULL, '366 Holly Dr.', 'Marlton', 'NJ', '08053', 'ledhead32@aol.com', '8568091363', '', 'N', '1', '2', '0', '', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Ho', 'Ho', 'Jeffrey', NULL, '32 Hodge Rd.', 'Princeton', 'NJ', '08540', 'jhalan@usa.net', '6099219530', '6099219530', 'Y', '2', '2', '2', '2', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Rogers', 'Rogers', 'Mike', NULL, '482 Keating Dr.', 'Morrisville', 'PA', '19067', 'theheresiarch@hotmail.com', '2157369263', '2152951525', 'N', '0', '1', '0', '1', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Nolan', 'Nolan', 'Mike', NULL, '2325 Lakeview Dr.', 'Yardley', 'PA', '19067', 'crustpeace@hotmail.com', '2154633692', '', 'N', '2', '2', '0', '2', 'Mike Rogers', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Miller', 'Miller', 'Robert', NULL, '43 Eleventh Ave.', 'Haddon Hts.', 'NJ', '08035', 'robanne@rcn.com', '6096729077', '6093925553', 'N', '1', '2', '0', '5', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Browar', 'Browar', 'Teddy', NULL, '48 Linden Lane', 'Princeton', 'NJ', '08540', 'mazrym64@hotmail.com', '6096880652', '', 'N', '2', '3', '3', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Shelley', 'Shelley', 'Katie', NULL, '49 Hilltop Rd.', 'Ewing', 'NJ', '08638', 'ktshelley@yahoo.com', '6096719020', '6099211800', 'N', '1', '1', '1', '0', '', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Tritton', 'Tritton', 'Matt', NULL, '527 Liberty Dr.', 'Yardley', 'PA', '19067', 'tritt15@aol.com', '2154931348', '', 'N', '0', '1', '0', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Haag', 'Haag', 'Kenneth', NULL, '61 Briarwood Ct.', 'Princeton', 'NJ', '08540', 'tiokenito@hotmail.com', '7324389663', '7324380420', 'N', '3', '2', '4', '12', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Carr', 'Carr', 'Ryan', NULL, '243 Mercer Rd.', 'Princeton', 'NJ', '08540', 'rcarr@haverford.edu', '6092520215', '', 'N', '2', '3', '0', '4', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Kalmus', 'Kalmus', 'Brian', NULL, '24 Chelmsford Dr.', 'Ewing', 'NJ', '08618', 'bkslippy@cs.com', '6098837068', '', 'Y', '3', '2', '4', '4', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Lin', 'Lin', 'Brian', NULL, '29 Schubert Ave.', 'Edison', 'NJ', '08820', 'saint2097@yahoo.com', '7323881323', '', 'N', '1', '3', '1', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Carlisle', 'Carlisle', 'Jennifer', NULL, '10 Edwards Dr.', 'E. Windsor', 'NJ', '08520', 'jen_carlisle@hotmail.com', '6099189579', '7326508200', 'N', '0', '3', '0', '0', 'Kristin Kelley', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Kelley', 'Kelley', 'Kristin', NULL, '10 Edwards Dr.', 'E. Windsor', 'NJ', '08520', 'kkelley150@aol.com', '6099189586', '2019338800', 'N', '1', '3', '0', '1', 'Jen Carlisle', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Atallah', 'Atallah', 'Bassam', NULL, '27 W. Broad St.', 'Hopewell', 'NJ', '08525', 'parity-violation@hotmail.com', '6093330834', '6092756500', 'N', '2', '1', '2', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Saul', 'Saul', 'Bailey', NULL, '', 'Yardley', 'NJ', '', '', '', '', 'N', '', '', '', '', '', '', '', 'Y', '', '', 'no3ntry!', 'Y', 'Y', 'Y'); INSERT INTO player VALUES ( 'Saul2', 'Saul', 'Rueben', NULL, '', 'yardley', 'PA', '', '', '', '', 'N', '', '', '', '', '', '', '', 'N', '', '', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Jackson', 'Jackson', 'Michael', NULL, '965B Bergen Ave.', 'No. Brunswick', 'NJ', '08902', 'mjackson@cms.westwindsor.k12.nj.us', '7323063577', '6097165300', 'N', '3', '3', '4', '6', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Tunney', 'Tunney', 'Pat', NULL, '1442 Heather Circle', 'Yardley', 'PA', '19067', 'ptun12@aol.com', '2154934828', '6097710555', 'N', '2', '3', '3', '15', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Worth', 'Worth', 'Patrick', NULL, '199 Ivanhoe Dr.', 'Robbinsville', 'NJ', '', 'worthp@worthconsulting.com', 'home', 'work', 'Y', '2', '3', '1', '8', 'a,b', 'c,d', 'e,f', 'Y', 'M', '05/30/1963', 'Tgi3f.', 'Y', 'Y', 'Y'); INSERT INTO player VALUES ( 'Pattik', 'Pattik', 'Edward', NULL, '142 Springdale Ave.', 'yardville', 'NJ', '08620', 'epattik@juno.com', '6095819303', '6099849301', 'Y', '2', '2', '4', '5', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'George', 'George', 'Laurie', NULL, '2429 Brown St. Apt. 123', 'Philadelphia', 'PA', '19130', 'laurgeorge@yahoo.com', '2157653295', '6099872500', 'N', '2', '2', '0', '7', '', '', '', 'Y', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Grillo', 'Grillo', 'Roger', NULL, '153 Darwin Ave.', 'N. Brunswick', 'NJ', '08902', 'grillo@aesop.rutgers.edu', '7322971045', '7329328165', 'Y', '3', '2', '25', '21', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Bedy', 'Bedy', 'Aaron', NULL, 'P.O. Box 616', 'Kingston', 'NJ', '08528', 'aaronbedy7676@hotmail.com', '6096889919', '6096272307', 'N', '1', '3', '0', '1', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Bills', 'Bills', 'Matthew', NULL, '11 Webster Ct.', 'Plainsboro', 'NJ', '08536', 'bills@stolaf.edu', '6092758557', '', 'Y', '2', '2', '1', '3', 'Shirley Wu&Mi-Sung Kim', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Shiue', 'Shiue', 'Albert', NULL, '3 Almond Ct.', 'W. Windsor', 'NJ', '08550', 'ashiue@middlebury.edu', '6097998623', '', 'Y', '2', '2', '1', '3', 'Jennifer Lee', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Kinczel', 'Kinczel', 'George', NULL, '24 Cannon Dr.', 'Hamilton Sq.', 'NJ', '08690', '', '6096891175', '6099848419', 'N', '2', '2', '0', '12', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Wu', 'Wu', 'Shirley', NULL, '6 Dey Farm Drive', 'Princeton Jct.', 'NJ', '08550', 'shirley-wu@brown.edu', '6097998701', '', 'Y', '2', '2', '1', '4', 'Matt Bills&Mi-Sung Kim', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Eastty', 'Eastty', 'Bob', NULL, '38 Pinedale Ct.', 'Hamilton Sq.', 'NJ', '08690', 'wor35@aol.com', '6095880528', '6098181203', 'N', '0', '2', '0', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Ahamd', 'Ahamd', 'Rizwan', NULL, '8 Butter Rd.', 'Edison', 'NJ', '08820', 'frizbee621@worldnet.att.net', '9085618918', '', 'N', '2', '3', '4', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Patel', 'Patel', 'Jay', NULL, '61 Pheasant Run', 'Edison', 'NJ', '08820', 'smellyfob@yahoo.com', '7329061309', '', 'N', '2', '2', '4', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Lee', 'Lee', 'Jennifer', NULL, '7 Ellsworth Dr.', 'W. Windsor', 'NJ', '08550', 'jennylee781@hotmail.com', '6092754375', '', 'Y', '1', '2', '1', '2', 'Albert Shiue', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Kim', 'Kim', 'Mi-Sung', NULL, '43 Windsor Dr.', 'Princeton Jct.', 'NJ', '08550', 'msk379@aol.com', '6097996537', '', 'N', '1', '2', '0', '1', 'Matt Bills&Shirley Wu', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Schmidt', 'Schmidt', 'George', NULL, '123 Ivy Dr. 7', 'Charlottesville', 'VA', '22903', 'gls3@prodigy.net', '5618267833', '', 'N', '0', '3', '0', '0', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Junkins', 'Junkins', 'Brian', NULL, '144 Ivy Dr. 11', 'Charlottesville', 'VA', '22903', 'brian_junkins@zsassociates.com', '8048252708', '6094194564', 'N', '1', '2', '', '', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Tou', 'Tou', 'Shepherd', NULL, '328 McKinley Ave.', 'Edison', 'NJ', '08820', 'sheptou@eden.rutgers.edu', '9087574099', '', 'Y', '2', '3', '1', '2', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Sayers', 'Sayers', 'Scott', NULL, '825 Farmingdale Rd.', 'Jackson', 'NJ', '08527', 'ssayers@att.com', '7323709642', '7324204592', 'Y', '3', '2', '16', '16', '', '', '', 'Y', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Bajo', 'Bajo', 'David', NULL, '108 Leigh Ave.', 'Princeton', 'NJ', '08542', 'bajo@eclipse.net', '6092791788', '', 'N', '0', '2', '0', '0', 'Jim Levine', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Levine', 'Levine', 'James', NULL, '34 Linden Ln.', 'Princeton', 'NJ', '08540', 'levine52@aol.com', '6099245799', '6096837044', 'N', '3', '1', '12', '5', 'David Bajo', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Wilson', 'Wilson', 'Kit', NULL, '18 Mark Twain Dr.', 'Hamilton Sq.', 'NJ', '08690', 'fvwilson@netscape.net', '6095864711', '6096332148', 'N', '3', '2', '0', '20', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Heaton', 'Heaton', 'Heather', NULL, '205 Salem Ct. 12', 'Princeton', 'NJ', '08540', 'heather.heaton@zsassociates.com', '6097201743', '6094193822', 'N', '0', '2', '0', '0', '', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Curry', 'Curry', 'Eva', NULL, '19 S. First St. Apt. 2', 'Highland Park', 'NJ', '', 'ecurry@math.rutgers.edu', '7328782250', '', 'N', '0', '3', '0', '0', 'Amelia Taylor', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Majsztrik', 'Majsztrik', 'John', NULL, '20 Appleby Lane', 'E. Brunswick', 'NJ', '08816', 'vballrush@yahoo.com', '7322382826', '7325865514', 'N', '2', '3', '0', '4', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Taylor', 'Taylor', 'Amelia', NULL, '131 Greenwood Ave. A', 'Edison', 'NJ', '08817', 'ataylor@math.rutgers.edu', '7329851391', '7324453488', 'N', '3', '3', '6', '2', 'Eva Curry', '', '', 'N', 'Y', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'True', 'True', 'Bruce', NULL, '9071 Mill Creek Rd. 2312', 'Levittown', 'PA', '19054', 'btrue@martnet.com', '2675800540', '6095879797', 'N', '1', '2', '0', '1', '', '', '', 'N', 'N', '01/01/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'blow', 'blow', 'joe', NULL, '', 'anywhere', 'NJ', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'blow2', 'blow2', 'j', NULL, '10 main st', 'anywhere', 'NJ', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, NULL, 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'stardust', 'stardust', 'ziggy', NULL, '10 main st', 'here', 'NJ', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, '05/30/1963', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'Knigge', 'Knigge', 'Chris', NULL, '147 Birch Ave', 'Princeton', 'NJ', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, '10/23/1958', 'no3ntry!', 'Y', 'Y', 'Y'); INSERT INTO player VALUES ( 'joMama', 'joMama', 'statyou', NULL, '10 main street', 'anywhere', 'NJ', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, '06/06/1942', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'sample', 'sample', 'ann', NULL, '10 main st', 'anywhere', 'NJ', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, '12/12/1900', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'whacky', 'whacky', 'jacky', NULL, '10 mains treet', 'here', 'NJ', '', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', '', NULL, NULL, '12/12/1988', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'last', 'last', 'first', NULL, 'street', 'town', 'NJ', '', 'you@arehere.com', 'homephone', 'workphone', 'Y', '1', '1', '2', '1', 'smith,joe', '', '', 'Y', 'M', '12/12/2001', 'no3ntry!', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'testlast', 'testlast', 'testfirst', NULL, '10 main street', '', 'NJ', '', '', '', '', 'Y', '1', '1', '1', '1', '', '', '', 'N', 'M', '', '', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'testlast2', 'testlast', 'testfirst', NULL, '', '', 'NJ', '', '', '', '', 'N', '', '', '', '', '', '', '', 'N', '', '', '', 'N', 'Y', 'Y'); INSERT INTO player VALUES ( 'testlast3', 'testlast', 'testfirst', NULL, 'last known address', '', 'NJ', '', '', '', '', 'N', '', '', '', '', '', '', '', 'N', '', '', '', 'N', 'Y', 'Y'); # -------------------------------------------------------- # # Table structure for table 'player_stats' # CREATE TABLE player_stats ( id tinyint(4) DEFAULT '0' NOT NULL, game_id tinyint(4) DEFAULT '0' NOT NULL, player_id varchar(40) DEFAULT '0' NOT NULL, team_id tinyint(4) DEFAULT '0' NOT NULL, goals tinyint(4) DEFAULT '0' NOT NULL, assists tinyint(4) DEFAULT '0' NOT NULL, blocks tinyint(4) DEFAULT '0' NOT NULL ); # # Dumping data for table 'player_stats' # INSERT INTO player_stats VALUES ( '4', '3', 'George', '1', '6', '0', '0'); INSERT INTO player_stats VALUES ( '5', '3', 'Saul', '1', '0', '7', '0'); INSERT INTO player_stats VALUES ( '6', '3', 'Worth', '1', '0', '0', '8'); INSERT INTO player_stats VALUES ( '7', '12', 'Worth', '7', '15', '15', '0'); # -------------------------------------------------------- # # Table structure for table 'roster' # CREATE TABLE roster ( team_id tinyint(4) DEFAULT '0' NOT NULL, player_id varchar(40) DEFAULT '0' NOT NULL, isCaptain char(1) DEFAULT 'N' NOT NULL, id tinyint(4) DEFAULT '0' NOT NULL, player_list_pos tinyint(4) DEFAULT '0' NOT NULL ); # # Dumping data for table 'roster' # INSERT INTO roster VALUES ( '1', 'Worth', 'Y', '1', '0'); INSERT INTO roster VALUES ( '2', 'Buriani', 'Y', '2', '0'); INSERT INTO roster VALUES ( '4', 'Grillo', 'Y', '8', '0'); INSERT INTO roster VALUES ( '3', 'Saul', 'Y', '4', '0'); INSERT INTO roster VALUES ( '2', 'Ahamd', 'N', '5', '0'); INSERT INTO roster VALUES ( '3', 'Allen', 'N', '6', '0'); INSERT INTO roster VALUES ( '1', 'George', 'Y', '7', '0'); INSERT INTO roster VALUES ( '4', 'Besner', 'N', '9', '0'); INSERT INTO roster VALUES ( '5', 'Kalicki', 'Y', '10', '0'); INSERT INTO roster VALUES ( '6', 'Bonn', 'Y', '11', '0'); INSERT INTO roster VALUES ( '1', 'Saul', 'Y', '12', '0'); INSERT INTO roster VALUES ( '3', 'Bills', 'N', '13', '0'); INSERT INTO roster VALUES ( '7', 'Worth', 'Y', '14', '0'); # -------------------------------------------------------- # # Table structure for table 'team' # CREATE TABLE team ( id tinyint(4) DEFAULT '0' NOT NULL, name varchar(40) NOT NULL, wins tinyint(4) DEFAULT '0' NOT NULL, division varchar(5) DEFAULT 'Draft' NOT NULL, losses tinyint(4) DEFAULT '0' NOT NULL, draws tinyint(4) DEFAULT '0' NOT NULL ); # # Dumping data for table 'team' # INSERT INTO team VALUES ( '1', 'Scar Tissue', '2', 'Draft', '0', '0'); INSERT INTO team VALUES ( '2', 'HUK', '0', 'A', '0', '0'); INSERT INTO team VALUES ( '3', 'BailsTeam', '1', 'A', '2', '0'); INSERT INTO team VALUES ( '4', 'BYD', '1', 'A', '1', '0'); INSERT INTO team VALUES ( '5', 'Loose Booty', '0', 'Draft', '1', '0'); INSERT INTO team VALUES ( '6', 'LastPlace', '0', 'Draft', '0', '0'); INSERT INTO team VALUES ( '7', 'Pats Team', '1', 'A', '0', '0');