--
-- Host: localhost    Database: demo2
-- ------------------------------------------------------


--
-- Table structure for table `addrbook`
--

CREATE TABLE `addrbook` (
  `lastname` varchar(20) DEFAULT NULL,
  `firstname` varchar(20) DEFAULT NULL,
  `street` varchar(50) DEFAULT NULL,
  `city` varchar(20) DEFAULT NULL,
  `state` char(2) DEFAULT NULL,
  `zip` varchar(10) DEFAULT NULL,
  `phone` varchar(20) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `addrbook`
--

INSERT INTO `addrbook` VALUES ('Anile','Joseph','35 Forest Avenue','Glen Cove','NY','12345','(516)937-4021'),('Brown','Robert','96 Landing Road','Brooklyn','NY','12345','(718)921-7505'),('Colin','Albert','64 Lisa Drive','Plainview','NY','12345','(516)671-2895'),('Davies','Todd','129 Georgia Street','Forest Hills','NY','12345','(718)496-3717'),('Eisner','Jack','6 Sunset Drive','East Norwich','CT','12345','(215)759-1976'),('Field','Diane','254 West 79 Street','New York','NY','12345','(212)647-9372'),('Gambi','Teresa','12 Cypress Avenue','Syosset','NY','12345','(516)299-5478'),('Hart','Richard','31 Cherry Lane','Hicksville','NY','12345','(516)679-7920'),('Izzo','Anthony','342 Coleridge Drive','Locus Grove','NY','12345','(516)367-3066'),('Johnson','Carl','8 Bayview Drive','Bayville','NY','12345','(516)299-7643'),('Sullivan','John','22 Oakdale Avenue','Huntington','NY','12345','(516)453-3239'),('Sultan','Sam','123 Main Street','New York','NY','12345','(212)123-1234'),('Sultan','Carol','123 Main Street','New York','NY','12345','(212)123-1234'),('Tillman','Christopher','70 Oyster Bay Road','Oyster Bay','NY','12345','(516)922-4941'),('Urich','Robert','123 Hollywood Lane','Century City','CA','12345','(415)498-5301'),('Valante','Vincent','67 Redbank Road','Holmdel','NJ','12345','(212)123-1234'),('Williams','Leonard','1267 2nd Ave','New York','NY','12345','(212)765-3476'),('Xu','Wei','16 Jericho Turnpike','Jericho','NY','12345','(516)628-8309'),('Yen','Jerry','123 Johnson Circle','Bethpage','NY','12345','(631)327-8567');

--
-- Table structure for table `country`
--

CREATE TABLE `country` (
  `id` varchar(20) NOT NULL,
  `type` varchar(20) NOT NULL,
  `name` varchar(100) NOT NULL,
  `parent_id` varchar(20) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `country`
--

INSERT INTO `country` VALUES ('1','country','Afghanistan','1'),('10','country','Austria','10'),('100','country','Libya','100'),('101','country','Liechtenstein','101'),('102','country','Lithuania','102'),('103','country','Luxembourg','103'),('104','country','Macedonia','104'),('105','country','Madagascar','105'),('106','country','Malawi','106'),('107','country','Malaysia','107'),('108','country','Maldives','108'),('109','country','Mali','109'),('11','country','Azerbaijan','11'),('110','country','Malta','110'),('111','country','Marshall Islands','111'),('112','country','Mauritania','112'),('113','country','Mauritius','113'),('114','country','Mexico','114'),('114.1','state','Aguascalientes','114'),('114.10','state','Durango','114'),('114.11','state','Guanajuato','114'),('114.12','state','Guerrero','114'),('114.13','state','Hidalgo','114'),('114.14','state','Jalisco','114'),('114.15','state','Mexico','114'),('114.16','state','Michoacan','114'),('114.17','state','Morelos','114'),('114.18','state','Nayarit','114'),('114.19','state','Nuevo Leon','114'),('114.2','state','Baja California Norte','114'),('114.20','state','Oaxaca','114'),('114.21','state','Puebla','114'),('114.22','state','Queretaro','114'),('114.23','state','Quintana Roo','114'),('114.24','state','San Luis Potosi','114'),('114.25','state','Sinaloa','114'),('114.26','state','Sonora','114'),('114.27','state','Tabasco','114'),('114.28','state','Tamaulipas','114'),('114.29','state','Tlaxcala','114'),('114.3','state','Baja California Sur','114'),('114.30','state','Veracruz','114'),('114.31','state','Yacatan','114'),('114.32','state','Zacatecas','114'),('114.4','state','Campeche','114'),('114.5','state','Chiapas','114'),('114.6','state','Chihuahua','114'),('114.7','state','Coahuila','114'),('114.8','state','Colima','114'),('114.9','state','Distrito Federal','114'),('115','country','Micronesia','115'),('116','country','Moldova','116'),('117','country','Monaco','117'),('118','country','Mongolia','118'),('119','country','Montenegro','119'),('12','country','Bahamas','12'),('120','country','Morocco','120'),('121','country','Mozambique','121'),('122','country','Myanmar, [Burma]','122'),('123','country','Namibia','123'),('124','country','Nauru','124'),('125','country','Nepal','125'),('126','country','Netherlands','126'),('127','country','New Zealand','127'),('128','country','Nicaragua','128'),('129','country','Niger','129'),('13','country','Bahrain','13'),('130','country','Nigeria','130'),('131','country','Norway','131'),('132','country','Oman','132'),('133','country','Pakistan','133'),('134','country','Palau','134'),('135','country','Panama','135'),('136','country','Papua New Guinea','136'),('137','country','Paraguay','137'),('138','country','Peru','138'),('139','country','Philippines','139'),('14','country','Bangladesh','14'),('140','country','Poland','140'),('141','country','Portugal','141'),('142','country','Qatar','142'),('143','country','Romania','143'),('144','country','Russian Federation','144'),('145','country','Rwanda','145'),('146','country','Saint Vincent and the Grenadines','146'),('147','country','Samoa','147'),('148','country','San Marino','148'),('149','country','Sao Tome and Principe','149'),('15','country','Barbados','15'),('150','country','Saudi Arabia','150'),('151','country','Senegal','151'),('152','country','Serbia','152'),('153','country','Seychelles','153'),('154','country','Sierra Leone','154'),('155','country','Singapore','155'),('156','country','Slovakia','156'),('157','country','Slovenia','157'),('158','country','Solomon Islands','158'),('159','country','Somalia','159'),('16','country','Belarus','16'),('160','country','South Africa','160'),('161','country','Spain','161'),('162','country','Sri Lanka','162'),('163','country','St Kitts and Nevis','163'),('164','country','St Lucia','164'),('165','country','Sudan','165'),('166','country','Suriname','166'),('167','country','Swaziland','167'),('168','country','Sweden','168'),('169','country','Switzerland','169'),('17','country','Belgium','17'),('170','country','Syria','170'),('171','country','Taiwan','171'),('172','country','Tajikistan','172'),('173','country','Tanzania','173'),('174','country','Thailand','174'),('175','country','Togo','175'),('176','country','Tonga','176'),('177','country','Trinidad and Tobago','177'),('178','country','Tunisia','178'),('179','country','Turkey','179'),('18','country','Belize','18'),('180','country','Turkmenistan','180'),('181','country','Tuvalu','181'),('182','country','Uganda','182'),('183','country','Ukraine','183'),('184','country','United Arab Emirates','184'),('185','country','United Kingdom','185'),('186','country','United States','186'),('186.1','state','Alabama','186'),('186.10','state','Florida','186'),('186.11','state','Georgia','186'),('186.12','state','Hawaii','186'),('186.13','state','Idaho','186'),('186.14','state','Illinois','186'),('186.15','state','Indiana','186'),('186.16','state','Iowa','186'),('186.17','state','Kansas','186'),('186.18','state','Kentucky','186'),('186.19','state','Louisiana','186'),('186.2','state','Alaska','186'),('186.20','state','Maine','186'),('186.21','state','Maryland','186'),('186.22','state','Massachusetts','186'),('186.23','state','Michigan','186'),('186.24','state','Minnesota','186'),('186.25','state','Mississippi','186'),('186.26','state','Missouri','186'),('186.27','state','Montana','186'),('186.28','state','Nebraska','186'),('186.29','state','Nevada','186'),('186.3','state','Arizona','186'),('186.30','state','New Hampshire','186'),('186.31','state','New Jersey','186'),('186.31.1','county','Atlantic','186.31'),('186.31.10','county','Hunterdon','186.31'),('186.31.11','county','Mercer','186.31'),('186.31.12','county','Middlesex','186.31'),('186.31.13','county','Monmouth','186.31'),('186.31.14','county','Morris','186.31'),('186.31.15','county','Ocean','186.31'),('186.31.16','county','Passaic','186.31'),('186.31.17','county','Salem','186.31'),('186.31.18','county','Somerset','186.31'),('186.31.19','county','Sussex','186.31'),('186.31.2','county','Bergen','186.31'),('186.31.20','county','Union','186.31'),('186.31.21','county','Warren','186.31'),('186.31.3','county','Burlington','186.31'),('186.31.4','county','Camden','186.31'),('186.31.5','county','Cape May','186.31'),('186.31.6','county','Cumberland','186.31'),('186.31.7','county','Essex','186.31'),('186.31.8','county','Gloucester','186.31'),('186.31.9','county','Hudson','186.31'),('186.32','state','New Mexico','186'),('186.33','state','New York','186'),('186.33.1','county','Albany ','186.33'),('186.33.10','county','Clinton ','186.33'),('186.33.11','county','Columbia ','186.33'),('186.33.12','county','Cortland ','186.33'),('186.33.13','county','Delaware ','186.33'),('186.33.14','county','Dutchess ','186.33'),('186.33.15','county','Erie ','186.33'),('186.33.16','county','Essex ','186.33'),('186.33.17','county','Franklin ','186.33'),('186.33.18','county','Fulton ','186.33'),('186.33.19','county','Genesee ','186.33'),('186.33.2','county','Allegany ','186.33'),('186.33.20','county','Greene ','186.33'),('186.33.21','county','Hamilton ','186.33'),('186.33.22','county','Herkimer ','186.33'),('186.33.23','county','Jefferson ','186.33'),('186.33.24','county','Kings ','186.33'),('186.33.24.1','town','Bath Beach','186.33.24'),('186.33.24.10','town','Brownsville','186.33.24'),('186.33.24.11','town','Bushwick','186.33.24'),('186.33.24.12','town','Carroll Gardens','186.33.24'),('186.33.24.13','town','Clinton Hill','186.33.24'),('186.33.24.14','town','Cobble Hill ','186.33.24'),('186.33.24.15','town','Coney Island ','186.33.24'),('186.33.24.16','town','Crown Heights','186.33.24'),('186.33.24.17','town','Cypress Hills','186.33.24'),('186.33.24.18','town','Ditmas Park','186.33.24'),('186.33.24.19','town','Downtown','186.33.24'),('186.33.24.2','town','Bay Ridge','186.33.24'),('186.33.24.20','town','Dyker Heights','186.33.24'),('186.33.24.21','town','East Flatbush','186.33.24'),('186.33.24.22','town','East New York','186.33.24'),('186.33.24.23','town','East Williamsburg','186.33.24'),('186.33.24.24','town','Farragut','186.33.24'),('186.33.24.25','town','Fiske Terrace','186.33.24'),('186.33.24.26','town','Flatbush','186.33.24'),('186.33.24.27','town','Fort Greene ','186.33.24'),('186.33.24.28','town','Fort Hamilton','186.33.24'),('186.33.24.29','town','Fulton Ferry','186.33.24'),('186.33.24.3','town','Bedford-Stuyvesant','186.33.24'),('186.33.24.30','town','Fultons Landing','186.33.24'),('186.33.24.31','town','Gerritsen Beach','186.33.24'),('186.33.24.32','town','Gowanus','186.33.24'),('186.33.24.33','town','Gravesend','186.33.24'),('186.33.24.34','town','Greenpoint','186.33.24'),('186.33.24.35','town','Highland Park','186.33.24'),('186.33.24.36','town','Homecrest','186.33.24'),('186.33.24.37','town','Kensington','186.33.24'),('186.33.24.38','town','Lefferts Manor','186.33.24'),('186.33.24.39','town','Manhattan Beach','186.33.24'),('186.33.24.4','town','Bensonhurst','186.33.24'),('186.33.24.40','town','Mapleton','186.33.24'),('186.33.24.41','town','Midwood','186.33.24'),('186.33.24.42','town','New Lots','186.33.24'),('186.33.24.43','town','New Utrecht','186.33.24'),('186.33.24.44','town','North Side','186.33.24'),('186.33.24.45','town','Ocean Hill','186.33.24'),('186.33.24.46','town','Ocean Parkway','186.33.24'),('186.33.24.47','town','Park Slope','186.33.24'),('186.33.24.48','town','Parkville','186.33.24'),('186.33.24.49','town','Pigtown','186.33.24'),('186.33.24.5','town','Boerum Hill','186.33.24'),('186.33.24.50','town','Plum Beach','186.33.24'),('186.33.24.51','town','Prospect Heights','186.33.24'),('186.33.24.52','town','Prospect Gardens','186.33.24'),('186.33.24.53','town','Prospect Park','186.33.24'),('186.33.24.54','town','Red Hook','186.33.24'),('186.33.24.55','town','Sea Gate','186.33.24'),('186.33.24.56','town','Spring Creek','186.33.24'),('186.33.24.57','town','Starrett City','186.33.24'),('186.33.24.58','town','Sunset Park','186.33.24'),('186.33.24.59','town','Vinegar Hill','186.33.24'),('186.33.24.6','town','Borough Park','186.33.24'),('186.33.24.60','town','Weeksville','186.33.24'),('186.33.24.61','town','Williamsburg','186.33.24'),('186.33.24.62','town','Windsor Terrace','186.33.24'),('186.33.24.7','town','Brighton Beach','186.33.24'),('186.33.24.8','town','Brooklyn Heights','186.33.24'),('186.33.24.9','town','Brooklyn Navy Yard','186.33.24'),('186.33.25','county','Lewis ','186.33'),('186.33.26','county','Livingston ','186.33'),('186.33.27','county','Madison ','186.33'),('186.33.28','county','Monroe ','186.33'),('186.33.29','county','Montgomery ','186.33'),('186.33.3','county','Bronx ','186.33'),('186.33.3.1','town','Baychester','186.33.3'),('186.33.3.10','town','Marble Hill','186.33.3'),('186.33.3.11','town','Melrose','186.33.3'),('186.33.3.12','town','Morrisania','186.33.3'),('186.33.3.13','town','Morris Park','186.33.3'),('186.33.3.14','town','Mott Haven','186.33.3'),('186.33.3.15','town','Norwood','186.33.3'),('186.33.3.16','town','Parkchester','186.33.3'),('186.33.3.17','town','Pelham Bay','186.33.3'),('186.33.3.18','town','Pelham Parkway','186.33.3'),('186.33.3.19','town','Riverdale','186.33.3'),('186.33.3.2','town','Bedford Park','186.33.3'),('186.33.3.20','town','Soundview','186.33.3'),('186.33.3.21','town','Throgs Neck','186.33.3'),('186.33.3.22','town','Tremont','186.33.3'),('186.33.3.23','town','University Heights','186.33.3'),('186.33.3.24','town','Van Nest','186.33.3'),('186.33.3.25','town','Wakefield','186.33.3'),('186.33.3.26','town','West Farms','186.33.3'),('186.33.3.27','town','Williamsbridge','186.33.3'),('186.33.3.28','town','Woodlawn ','186.33.3'),('186.33.3.3','town','Castle Hill','186.33.3'),('186.33.3.4','town','City Island','186.33.3'),('186.33.3.5','town','Eastchester','186.33.3'),('186.33.3.6','town','Fordham','186.33.3'),('186.33.3.7','town','Highbridge','186.33.3'),('186.33.3.8','town','Hunts Point','186.33.3'),('186.33.3.9','town','KingsBridge','186.33.3'),('186.33.30','county','Nassau ','186.33'),('186.33.30.1','town','Glen Head','186.33.30'),('186.33.30.10','town','Bay Park','186.33.30'),('186.33.30.100','town','North Woodmere','186.33.30'),('186.33.30.101','town','Oceanside','186.33.30'),('186.33.30.102','town','Old Bethpage','186.33.30'),('186.33.30.103','town','Old Brookville ','186.33.30'),('186.33.30.104','town','Old Westbury ','186.33.30'),('186.33.30.105','town','Oyster Bay','186.33.30'),('186.33.30.106','town','Oyster Bay Cove ','186.33.30'),('186.33.30.107','town','Plainedge','186.33.30'),('186.33.30.108','town','Plainview','186.33.30'),('186.33.30.109','town','Plandome ','186.33.30'),('186.33.30.11','town','Bayville ','186.33.30'),('186.33.30.110','town','Plandome Heights ','186.33.30'),('186.33.30.111','town','Plandome Manor ','186.33.30'),('186.33.30.112','town','Point Lookout','186.33.30'),('186.33.30.113','town','Port Washington','186.33.30'),('186.33.30.114','town','Port Washington North ','186.33.30'),('186.33.30.115','town','Rockville Centre ','186.33.30'),('186.33.30.116','town','Roosevelt','186.33.30'),('186.33.30.117','town','Roslyn ','186.33.30'),('186.33.30.118','town','Roslyn Estates ','186.33.30'),('186.33.30.119','town','Roslyn Harbor ','186.33.30'),('186.33.30.12','town','Bellerose ','186.33.30'),('186.33.30.120','town','Roslyn Heights','186.33.30'),('186.33.30.121','town','Russell Gardens ','186.33.30'),('186.33.30.122','town','Saddle Rock ','186.33.30'),('186.33.30.123','town','Saddle Rock Estates','186.33.30'),('186.33.30.124','town','Salisbury','186.33.30'),('186.33.30.125','town','Sands Point ','186.33.30'),('186.33.30.126','town','Sea Cliff ','186.33.30'),('186.33.30.127','town','Seaford','186.33.30'),('186.33.30.128','town','Searingtown','186.33.30'),('186.33.30.129','town','South Farmingdale','186.33.30'),('186.33.30.13','town','Bellerose Terrace','186.33.30'),('186.33.30.130','town','South Floral Park ','186.33.30'),('186.33.30.131','town','South Hempstead','186.33.30'),('186.33.30.132','town','South Valley Stream','186.33.30'),('186.33.30.133','town','Stewart Manor ','186.33.30'),('186.33.30.134','town','Strathmore','186.33.30'),('186.33.30.135','town','Syosset','186.33.30'),('186.33.30.136','town','Thomaston ','186.33.30'),('186.33.30.137','town','Uniondale','186.33.30'),('186.33.30.138','town','University Gardens','186.33.30'),('186.33.30.139','town','Upper Brookville ','186.33.30'),('186.33.30.14','town','Bellmore','186.33.30'),('186.33.30.140','town','Valley Stream ','186.33.30'),('186.33.30.141','town','Wantagh','186.33.30'),('186.33.30.142','town','West Hempstead','186.33.30'),('186.33.30.143','town','Westbury ','186.33.30'),('186.33.30.144','town','Westbury South','186.33.30'),('186.33.30.145','town','Wheatley','186.33.30'),('186.33.30.146','town','Williston Park ','186.33.30'),('186.33.30.147','town','Woodbury','186.33.30'),('186.33.30.148','town','Woodmere','186.33.30'),('186.33.30.149','town','Woodsburgh','186.33.30'),('186.33.30.15','town','Bethpage','186.33.30'),('186.33.30.16','town','Biltmore Shores','186.33.30'),('186.33.30.17','town','Brookville ','186.33.30'),('186.33.30.18','town','Carle Place','186.33.30'),('186.33.30.19','town','Cedarhurst ','186.33.30'),('186.33.30.2','town','Albertson','186.33.30'),('186.33.30.20','town','Centre Island ','186.33.30'),('186.33.30.21','town','Cove Neck ','186.33.30'),('186.33.30.22','town','East Atlantic Beach','186.33.30'),('186.33.30.23','town','East Garden City','186.33.30'),('186.33.30.24','town','East Hills ','186.33.30'),('186.33.30.25','town','East Massapequa','186.33.30'),('186.33.30.26','town','East Meadow','186.33.30'),('186.33.30.27','town','East Norwich','186.33.30'),('186.33.30.28','town','East Rockaway ','186.33.30'),('186.33.30.29','town','East Williston ','186.33.30'),('186.33.30.3','town','Alden Manor','186.33.30'),('186.33.30.30','town','Elmont','186.33.30'),('186.33.30.31','town','Farmingdale ','186.33.30'),('186.33.30.32','town','Floral Park ','186.33.30'),('186.33.30.33','town','Flower Hill ','186.33.30'),('186.33.30.34','town','Franklin Square','186.33.30'),('186.33.30.35','town','Freeport ','186.33.30'),('186.33.30.36','town','Garden City ','186.33.30'),('186.33.30.37','town','Garden City Park','186.33.30'),('186.33.30.38','town','Garden City South','186.33.30'),('186.33.30.39','town','Glen Cove ','186.33.30'),('186.33.30.4','town','Atlantic Beach ','186.33.30'),('186.33.30.40','town','Glenwood Landing','186.33.30'),('186.33.30.41','town','Great Neck ','186.33.30'),('186.33.30.42','town','Great Neck Estates ','186.33.30'),('186.33.30.43','town','Great Neck Gardens','186.33.30'),('186.33.30.44','town','Great Neck Plaza ','186.33.30'),('186.33.30.45','town','Green Acres','186.33.30'),('186.33.30.46','town','Greenvale','186.33.30'),('186.33.30.47','town','Harbor Green','186.33.30'),('186.33.30.48','town','Harbor Hills','186.33.30'),('186.33.30.49','town','Harbor Isle','186.33.30'),('186.33.30.5','town','Baldwin','186.33.30'),('186.33.30.50','town','Hempstead ','186.33.30'),('186.33.30.51','town','Hempstead Gardens','186.33.30'),('186.33.30.52','town','Herricks','186.33.30'),('186.33.30.53','town','Hewlett','186.33.30'),('186.33.30.54','town','Hewlett Bay Park ','186.33.30'),('186.33.30.55','town','Hewlett Harbor ','186.33.30'),('186.33.30.56','town','Hewlett Neck ','186.33.30'),('186.33.30.57','town','Hicksville','186.33.30'),('186.33.30.58','town','Hillside Manor','186.33.30'),('186.33.30.59','town','Inwood','186.33.30'),('186.33.30.6','town','Baldwin Harbor','186.33.30'),('186.33.30.60','town','Island Park ','186.33.30'),('186.33.30.61','town','Jericho','186.33.30'),('186.33.30.62','town','Kensington ','186.33.30'),('186.33.30.63','town','Kings Point ','186.33.30'),('186.33.30.64','town','Lake Success ','186.33.30'),('186.33.30.65','town','Lakeview','186.33.30'),('186.33.30.66','town','Lattingtown ','186.33.30'),('186.33.30.67','town','Laurel Hollow ','186.33.30'),('186.33.30.68','town','Lawrence ','186.33.30'),('186.33.30.69','town','Levittown','186.33.30'),('186.33.30.7','town','Barnum Island','186.33.30'),('186.33.30.70','town','Lido Beach','186.33.30'),('186.33.30.71','town','Locust Grove','186.33.30'),('186.33.30.72','town','Locust Valley','186.33.30'),('186.33.30.73','town','Long Beach ','186.33.30'),('186.33.30.74','town','Lynbrook ','186.33.30'),('186.33.30.75','town','Malverne ','186.33.30'),('186.33.30.76','town','Malverne Park Oaks','186.33.30'),('186.33.30.77','town','Manhasset','186.33.30'),('186.33.30.78','town','Manhasset Hills','186.33.30'),('186.33.30.79','town','Manorhaven ','186.33.30'),('186.33.30.8','town','Baxter Estates ','186.33.30'),('186.33.30.80','town','Massapequa','186.33.30'),('186.33.30.81','town','Massapequa Park ','186.33.30'),('186.33.30.82','town','Matinecock ','186.33.30'),('186.33.30.83','town','Meadowmere Park','186.33.30'),('186.33.30.84','town','Merrick','186.33.30'),('186.33.30.85','town','Mill Neck ','186.33.30'),('186.33.30.86','town','Mineola ','186.33.30'),('186.33.30.87','town','Munsey Park ','186.33.30'),('186.33.30.88','town','Muttontown ','186.33.30'),('186.33.30.89','town','Nassau Shores','186.33.30'),('186.33.30.9','town','Bay Colony','186.33.30'),('186.33.30.90','town','New Cassel','186.33.30'),('186.33.30.91','town','New Hyde Park ','186.33.30'),('186.33.30.92','town','North Bellmore','186.33.30'),('186.33.30.93','town','North Hills ','186.33.30'),('186.33.30.94','town','North Lynbrook','186.33.30'),('186.33.30.95','town','North Massapequa','186.33.30'),('186.33.30.96','town','North Merrick','186.33.30'),('186.33.30.97','town','North New Hyde Park','186.33.30'),('186.33.30.98','town','North Valley Stream','186.33.30'),('186.33.30.99','town','North Wantagh','186.33.30'),('186.33.31','county','New York ','186.33'),('186.33.31.1','town','Harbor View Terrace','186.33.31'),('186.33.31.10','town','Dyckman Houses','186.33.31'),('186.33.31.11','town','East Harlem','186.33.31'),('186.33.31.12','town','East River Houses','186.33.31'),('186.33.31.13','town','East Village','186.33.31'),('186.33.31.14','town','Esplanade Gardens','186.33.31'),('186.33.31.15','town','Franklin Houses','186.33.31'),('186.33.31.16','town','Governor Alfred E Smith Houses','186.33.31'),('186.33.31.17','town','Gracie Square','186.33.31'),('186.33.31.18','town','Grammercy Park','186.33.31'),('186.33.31.19','town','Hamilton Heights','186.33.31'),('186.33.31.2','town','Penn Station South','186.33.31'),('186.33.31.20','town','Hamilton Houses','186.33.31'),('186.33.31.21','town','Harlem River Houses','186.33.31'),('186.33.31.22','town','Hells Kitchen','186.33.31'),('186.33.31.23','town','Henry Street Settlement','186.33.31'),('186.33.31.24','town','Hester - Allen Turnkey Housing','186.33.31'),('186.33.31.25','town','Hillman Housing','186.33.31'),('186.33.31.26','town','Jacob Riis Houses','186.33.31'),('186.33.31.27','town','James Weldon Johnson Houses','186.33.31'),('186.33.31.28','town','Kips Bay','186.33.31'),('186.33.31.29','town','Knickerbocker Village','186.33.31'),('186.33.31.3','town','Amalgamated Dwellings','186.33.31'),('186.33.31.30','town','Lionel Hampton Houses','186.33.31'),('186.33.31.31','town','Little Italy','186.33.31'),('186.33.31.32','town','Loisaida','186.33.31'),('186.33.31.33','town','Lower East Side','186.33.31'),('186.33.31.34','town','Manhattanville','186.33.31'),('186.33.31.35','town','Morningside Heights','186.33.31'),('186.33.31.36','town','Murray Hill','186.33.31'),('186.33.31.37','town','Park West Village','186.33.31'),('186.33.31.38','town','Peter Cooper Village','186.33.31'),('186.33.31.39','town','Phipps Houses','186.33.31'),('186.33.31.4','town','Amsterdam Houses','186.33.31'),('186.33.31.40','town','Polo Grounds Houses','186.33.31'),('186.33.31.41','town','Riverbend Houses','186.33.31'),('186.33.31.42','town','Rose Hill','186.33.31'),('186.33.31.43','town','San Juan Hill','186.33.31'),('186.33.31.44','town','Soho','186.33.31'),('186.33.31.45','town','Stanley Isaacs Houses','186.33.31'),('186.33.31.46','town','Stuyvesant Town','186.33.31'),('186.33.31.47','town','Taino Towers','186.33.31'),('186.33.31.48','town','Tribeca','186.33.31'),('186.33.31.49','town','Tudor City','186.33.31'),('186.33.31.5','town','Battery Park City','186.33.31'),('186.33.31.50','town','University Village','186.33.31'),('186.33.31.51','town','Upper West Side','186.33.31'),('186.33.31.52','town','Washington Square Village','186.33.31'),('186.33.31.53','town','West Village Houses','186.33.31'),('186.33.31.54','town','Yorkville ','186.33.31'),('186.33.31.6','town','Chelsea','186.33.31'),('186.33.31.7','town','Clinton','186.33.31'),('186.33.31.8','town','Colonial Park Houses','186.33.31'),('186.33.31.9','town','Delano Village','186.33.31'),('186.33.32','county','Niagara ','186.33'),('186.33.33','county','Oneida ','186.33'),('186.33.34','county','Onondaga ','186.33'),('186.33.35','county','Ontario ','186.33'),('186.33.36','county','Orange ','186.33'),('186.33.37','county','Orleans ','186.33'),('186.33.38','county','Oswego ','186.33'),('186.33.39','county','Otsego ','186.33'),('186.33.4','county','Broome ','186.33'),('186.33.40','county','Putnam ','186.33'),('186.33.41','county','Queens ','186.33'),('186.33.41.1','town','Arverne','186.33.41'),('186.33.41.10','town','Briarwood','186.33.41'),('186.33.41.11','town','Broad Channel','186.33.41'),('186.33.41.12','town','Cambria Heights','186.33.41'),('186.33.41.13','town','College Point','186.33.41'),('186.33.41.14','town','Corona','186.33.41'),('186.33.41.15','town','Ditmars','186.33.41'),('186.33.41.16','town','Douglas Manor','186.33.41'),('186.33.41.17','town','Douglaston','186.33.41'),('186.33.41.18','town','Douglaston Hill ','186.33.41'),('186.33.41.19','town','East Elmhurst','186.33.41'),('186.33.41.2','town','Astoria','186.33.41'),('186.33.41.20','town','Edgemere','186.33.41'),('186.33.41.21','town','Elmhurst','186.33.41'),('186.33.41.22','town','Far Rockaway','186.33.41'),('186.33.41.23','town','Floral Park ','186.33.41'),('186.33.41.24','town','Flushing','186.33.41'),('186.33.41.25','town','Forest Hills','186.33.41'),('186.33.41.26','town','Fresh Meadows','186.33.41'),('186.33.41.27','town','Glen Oaks','186.33.41'),('186.33.41.28','town','Glendale','186.33.41'),('186.33.41.29','town','Hollis','186.33.41'),('186.33.41.3','town','Auburndale','186.33.41'),('186.33.41.30','town','Hollis Hills','186.33.41'),('186.33.41.31','town','Holliswood','186.33.41'),('186.33.41.32','town','Howard Beach','186.33.41'),('186.33.41.33','town','Hunters Point','186.33.41'),('186.33.41.34','town','Jackson Heights','186.33.41'),('186.33.41.35','town','Jamaica','186.33.41'),('186.33.41.36','town','Jamaica Estates','186.33.41'),('186.33.41.37','town','Jamaica Hills','186.33.41'),('186.33.41.38','town','Kew Gardens ','186.33.41'),('186.33.41.39','town','Kew Gardens Hills','186.33.41'),('186.33.41.4','town','Bay Terrace ','186.33.41'),('186.33.41.40','town','Laurelton','186.33.41'),('186.33.41.41','town','Lefrak City','186.33.41'),('186.33.41.42','town','Little Neck','186.33.41'),('186.33.41.43','town','Long Island City','186.33.41'),('186.33.41.44','town','Malba','186.33.41'),('186.33.41.45','town','Maspeth','186.33.41'),('186.33.41.46','town','Middle Village','186.33.41'),('186.33.41.47','town','Neponsit','186.33.41'),('186.33.41.48','town','Oakland Gardens','186.33.41'),('186.33.41.49','town','Ozone Park','186.33.41'),('186.33.41.5','town','Bayside','186.33.41'),('186.33.41.50','town','Queens Village','186.33.41'),('186.33.41.51','town','Queensbridge','186.33.41'),('186.33.41.52','town','Ravenswood','186.33.41'),('186.33.41.53','town','Rego Park','186.33.41'),('186.33.41.54','town','Richmond Hill','186.33.41'),('186.33.41.55','town','Ridgewood','186.33.41'),('186.33.41.56','town','Rochdale','186.33.41'),('186.33.41.57','town','Rockaway Beach','186.33.41'),('186.33.41.58','town','Rosedale','186.33.41'),('186.33.41.59','town','Saint Albans','186.33.41'),('186.33.41.6','town','Bayswater','186.33.41'),('186.33.41.60','town','South Jamaica','186.33.41'),('186.33.41.61','town','South Ozone Park','186.33.41'),('186.33.41.62','town','Springfield','186.33.41'),('186.33.41.63','town','Steinway','186.33.41'),('186.33.41.64','town','Sunnyside','186.33.41'),('186.33.41.65','town','Westmoreland','186.33.41'),('186.33.41.66','town','Whitestone','186.33.41'),('186.33.41.67','town','Willets Point','186.33.41'),('186.33.41.68','town','Woodhaven','186.33.41'),('186.33.41.69','town','Woodside','186.33.41'),('186.33.41.7','town','Beechhurst','186.33.41'),('186.33.41.8','town','Belle Harbor','186.33.41'),('186.33.41.9','town','Bellerose','186.33.41'),('186.33.42','county','Rensselaer ','186.33'),('186.33.43','county','Richmond ','186.33'),('186.33.43.1','town','Arrochar','186.33.43'),('186.33.43.10','town','Clifton','186.33.43'),('186.33.43.11','town','Concord','186.33.43'),('186.33.43.12','town','Dongan Hills','186.33.43'),('186.33.43.13','town','Egbertville','186.33.43'),('186.33.43.14','town','Elm Park','186.33.43'),('186.33.43.15','town','Eltingville','186.33.43'),('186.33.43.16','town','Emerson Hill','186.33.43'),('186.33.43.17','town','Fort Wadsworth','186.33.43'),('186.33.43.18','town','Graniteville','186.33.43'),('186.33.43.19','town','Grant City','186.33.43'),('186.33.43.2','town','Annadale','186.33.43'),('186.33.43.20','town','Grasmere','186.33.43'),('186.33.43.21','town','Great Kills','186.33.43'),('186.33.43.22','town','Greenridge','186.33.43'),('186.33.43.23','town','Grymes Hill','186.33.43'),('186.33.43.24','town','Heartland Village','186.33.43'),('186.33.43.25','town','Huguenot','186.33.43'),('186.33.43.26','town','Lighthouse Hill','186.33.43'),('186.33.43.27','town','Livingston','186.33.43'),('186.33.43.28','town','Manor Heights','186.33.43'),('186.33.43.29','town','Mariners Harbor','186.33.43'),('186.33.43.3','town','Arden Heights','186.33.43'),('186.33.43.30','town','Meiers Corners','186.33.43'),('186.33.43.31','town','Midland Beach','186.33.43'),('186.33.43.32','town','New Brighton','186.33.43'),('186.33.43.33','town','New Dorp','186.33.43'),('186.33.43.34','town','New Springville','186.33.43'),('186.33.43.35','town','Oakwood','186.33.43'),('186.33.43.36','town','Ocean Breeze','186.33.43'),('186.33.43.37','town','Old Town','186.33.43'),('186.33.43.38','town','Pleasant Plains','186.33.43'),('186.33.43.39','town','Port Richmond','186.33.43'),('186.33.43.4','town','Bay Terrace','186.33.43'),('186.33.43.40','town','Princes Bay','186.33.43'),('186.33.43.41','town','Randall Manor','186.33.43'),('186.33.43.42','town','Richmond Valley','186.33.43'),('186.33.43.43','town','Richmondtown','186.33.43'),('186.33.43.44','town','Rosebank','186.33.43'),('186.33.43.45','town','Rossville','186.33.43'),('186.33.43.46','town','Rudolph Lake','186.33.43'),('186.33.43.47','town','Shore Acres','186.33.43'),('186.33.43.48','town','Silver Lake','186.33.43'),('186.33.43.49','town','South Beach','186.33.43'),('186.33.43.5','town','Bloomfield','186.33.43'),('186.33.43.50','town','St. George','186.33.43'),('186.33.43.51','town','Stapleton','186.33.43'),('186.33.43.52','town','Stapleton Heights','186.33.43'),('186.33.43.53','town','Sunnyside','186.33.43'),('186.33.43.54','town','Todt Hill','186.33.43'),('186.33.43.55','town','Tompkinsville','186.33.43'),('186.33.43.56','town','Tottenville','186.33.43'),('186.33.43.57','town','Tottenville Beach','186.33.43'),('186.33.43.58','town','Travis','186.33.43'),('186.33.43.59','town','Ward Hill','186.33.43'),('186.33.43.6','town','Bulls Head','186.33.43'),('186.33.43.60','town','Westerleigh','186.33.43'),('186.33.43.61','town','West New Brighton','186.33.43'),('186.33.43.62','town','Willowbrook','186.33.43'),('186.33.43.63','town','Woodland Beach','186.33.43'),('186.33.43.64','town','Woodrow','186.33.43'),('186.33.43.7','town','Castleton Corners','186.33.43'),('186.33.43.8','town','Charleston','186.33.43'),('186.33.43.9','town','Chelsea','186.33.43'),('186.33.44','county','Rockland ','186.33'),('186.33.45','county','Saratoga ','186.33'),('186.33.46','county','Schenectady ','186.33'),('186.33.47','county','Schoharie ','186.33'),('186.33.48','county','Schuyler ','186.33'),('186.33.49','county','Seneca ','186.33'),('186.33.5','county','Cattaraugus ','186.33'),('186.33.50','county','St. Lawrence ','186.33'),('186.33.51','county','Steuben ','186.33'),('186.33.52','county','Suffolk ','186.33'),('186.33.52.1','town','Middleville','186.33.52'),('186.33.52.10','town','Atlantique','186.33.52'),('186.33.52.100','town','Holbrook','186.33.52'),('186.33.52.101','town','Holtsville','186.33.52'),('186.33.52.102','town','Huntington','186.33.52'),('186.33.52.103','town','Huntington Bay ','186.33.52'),('186.33.52.104','town','Huntington Beach','186.33.52'),('186.33.52.105','town','Huntington Station','186.33.52'),('186.33.52.106','town','Islandia ','186.33.52'),('186.33.52.107','town','Islip','186.33.52'),('186.33.52.108','town','Islip Terrace','186.33.52'),('186.33.52.109','town','Jamesport','186.33.52'),('186.33.52.11','town','Babylon ','186.33.52'),('186.33.52.110','town','Jericho','186.33.52'),('186.33.52.111','town','Kings Park','186.33.52'),('186.33.52.112','town','Kingstown','186.33.52'),('186.33.52.113','town','Kismet','186.33.52'),('186.33.52.114','town','Lake Grove ','186.33.52'),('186.33.52.115','town','Lake Ronkonkoma','186.33.52'),('186.33.52.116','town','Lakeland','186.33.52'),('186.33.52.117','town','Laughing Waters','186.33.52'),('186.33.52.118','town','Laurel','186.33.52'),('186.33.52.119','town','Lefferts Mill','186.33.52'),('186.33.52.12','town','Baiting Hollow','186.33.52'),('186.33.52.120','town','Lindenhurst ','186.33.52'),('186.33.52.121','town','Little Plains','186.33.52'),('186.33.52.122','town','Lloyd Harbor ','186.33.52'),('186.33.52.123','town','Lonelyville','186.33.52'),('186.33.52.124','town','Lower Melville','186.33.52'),('186.33.52.125','town','Maidstone Park','186.33.52'),('186.33.52.126','town','Manorville','186.33.52'),('186.33.52.127','town','Mastic','186.33.52'),('186.33.52.128','town','Mastic Beach','186.33.52'),('186.33.52.129','town','Mattituck','186.33.52'),('186.33.52.13','town','Barnes Hole','186.33.52'),('186.33.52.130','town','Maywood','186.33.52'),('186.33.52.131','town','Mecox','186.33.52'),('186.33.52.132','town','Medford','186.33.52'),('186.33.52.133','town','Melville','186.33.52'),('186.33.52.134','town','Middle Island','186.33.52'),('186.33.52.135','town','Midhampton','186.33.52'),('186.33.52.136','town','Miller Place','186.33.52'),('186.33.52.137','town','Montauk','186.33.52'),('186.33.52.138','town','Montauk Beach','186.33.52'),('186.33.52.139','town','Montauk Station','186.33.52'),('186.33.52.14','town','Bay Point','186.33.52'),('186.33.52.140','town','Montclair Colony','186.33.52'),('186.33.52.141','town','Moriches','186.33.52'),('186.33.52.142','town','Mount Sinai','186.33.52'),('186.33.52.143','town','Napeague','186.33.52'),('186.33.52.144','town','Nassau Farms','186.33.52'),('186.33.52.145','town','Nesconset','186.33.52'),('186.33.52.146','town','New Suffolk','186.33.52'),('186.33.52.147','town','Newtown','186.33.52'),('186.33.52.148','town','Nissequogue ','186.33.52'),('186.33.52.149','town','North Amityville','186.33.52'),('186.33.52.15','town','Bay Shore','186.33.52'),('186.33.52.150','town','North Babylon','186.33.52'),('186.33.52.151','town','North Bay Shore','186.33.52'),('186.33.52.152','town','North Bellport','186.33.52'),('186.33.52.153','town','North Great River','186.33.52'),('186.33.52.154','town','North Haven ','186.33.52'),('186.33.52.155','town','North Lindenhurst','186.33.52'),('186.33.52.156','town','North Patchogue','186.33.52'),('186.33.52.157','town','North Sea','186.33.52'),('186.33.52.158','town','Northampton','186.33.52'),('186.33.52.159','town','Northport ','186.33.52'),('186.33.52.16','town','Bay Wood','186.33.52'),('186.33.52.160','town','Northville','186.33.52'),('186.33.52.161','town','Northwest Harbor','186.33.52'),('186.33.52.162','town','Noyack','186.33.52'),('186.33.52.163','town','Oak Beach','186.33.52'),('186.33.52.164','town','Oakdale','186.33.52'),('186.33.52.165','town','Oakville','186.33.52'),('186.33.52.166','town','Ocean Bay Park','186.33.52'),('186.33.52.167','town','Ocean Beach ','186.33.52'),('186.33.52.168','town','Old Field ','186.33.52'),('186.33.52.169','town','Old Mastic','186.33.52'),('186.33.52.17','town','Bayberry Dunes','186.33.52'),('186.33.52.170','town','Orient','186.33.52'),('186.33.52.171','town','Orient Point','186.33.52'),('186.33.52.172','town','Pantigo','186.33.52'),('186.33.52.173','town','Patchogue ','186.33.52'),('186.33.52.174','town','Patchogue Highlands','186.33.52'),('186.33.52.175','town','Peconic','186.33.52'),('186.33.52.176','town','Pine Aire','186.33.52'),('186.33.52.177','town','Pine Neck','186.33.52'),('186.33.52.178','town','Pine Valley','186.33.52'),('186.33.52.179','town','Point of Woods','186.33.52'),('186.33.52.18','town','Bayport','186.33.52'),('186.33.52.180','town','Ponquogue','186.33.52'),('186.33.52.181','town','Poquott ','186.33.52'),('186.33.52.182','town','Port Jefferson ','186.33.52'),('186.33.52.183','town','Port Jefferson Station','186.33.52'),('186.33.52.184','town','Quioque','186.33.52'),('186.33.52.185','town','Quogue ','186.33.52'),('186.33.52.186','town','Rampasture','186.33.52'),('186.33.52.187','town','Red Creek','186.33.52'),('186.33.52.188','town','Redwood','186.33.52'),('186.33.52.189','town','Reeves Park','186.33.52'),('186.33.52.19','town','Beach Hampton','186.33.52'),('186.33.52.190','town','Remsenburg','186.33.52'),('186.33.52.191','town','Reydon Shores','186.33.52'),('186.33.52.192','town','Ridge','186.33.52'),('186.33.52.193','town','Riverhead','186.33.52'),('186.33.52.194','town','Riverside','186.33.52'),('186.33.52.195','town','Robbins Rest','186.33.52'),('186.33.52.196','town','Rocky Point','186.33.52'),('186.33.52.197','town','Ronkonkoma','186.33.52'),('186.33.52.198','town','Rose Grove','186.33.52'),('186.33.52.199','town','Sag Harbor ','186.33.52'),('186.33.52.2','town','Sagaponack ','186.33.52'),('186.33.52.20','town','Beixedon Estates','186.33.52'),('186.33.52.200','town','Saint James','186.33.52'),('186.33.52.201','town','Saltaire ','186.33.52'),('186.33.52.202','town','San Remo','186.33.52'),('186.33.52.203','town','Sayville','186.33.52'),('186.33.52.204','town','Scuttlehole','186.33.52'),('186.33.52.205','town','Seaview','186.33.52'),('186.33.52.206','town','Selden','186.33.52'),('186.33.52.207','town','Setauket','186.33.52'),('186.33.52.208','town','Shelter Island','186.33.52'),('186.33.52.209','town','Shelter Island Heights','186.33.52'),('186.33.52.21','town','Belle Terre ','186.33.52'),('186.33.52.210','town','Shinnecock Hills','186.33.52'),('186.33.52.211','town','Shirley','186.33.52'),('186.33.52.212','town','Shore Acres','186.33.52'),('186.33.52.213','town','Shoreham ','186.33.52'),('186.33.52.214','town','Siegfield Park','186.33.52'),('186.33.52.215','town','Silver Beach','186.33.52'),('186.33.52.216','town','Smithtown','186.33.52'),('186.33.52.217','town','Sound Beach','186.33.52'),('186.33.52.218','town','South Haven','186.33.52'),('186.33.52.219','town','South Huntington','186.33.52'),('186.33.52.22','town','Bellport ','186.33.52'),('186.33.52.220','town','South Jamesport','186.33.52'),('186.33.52.221','town','South Manor','186.33.52'),('186.33.52.222','town','South Setauket','186.33.52'),('186.33.52.223','town','Southampton ','186.33.52'),('186.33.52.224','town','Southold','186.33.52'),('186.33.52.225','town','Southport','186.33.52'),('186.33.52.226','town','Speonk','186.33.52'),('186.33.52.227','town','Springs','186.33.52'),('186.33.52.228','town','Springville','186.33.52'),('186.33.52.229','town','Squiretown','186.33.52'),('186.33.52.23','town','Bellview Beach','186.33.52'),('186.33.52.230','town','Stirling','186.33.52'),('186.33.52.231','town','Stony Brook','186.33.52'),('186.33.52.232','town','Sweyze','186.33.52'),('186.33.52.233','town','Terryville','186.33.52'),('186.33.52.234','town','The Creek Beach','186.33.52'),('186.33.52.235','town','The Landing','186.33.52'),('186.33.52.236','town','Tiana','186.33.52'),('186.33.52.237','town','Tuckahoe','186.33.52'),('186.33.52.238','town','Upton','186.33.52'),('186.33.52.239','town','Vernon Valley','186.33.52'),('186.33.52.24','town','Blue Point','186.33.52'),('186.33.52.240','town','Village of the Branch ','186.33.52'),('186.33.52.241','town','Wading River','186.33.52'),('186.33.52.242','town','Wainscott','186.33.52'),('186.33.52.243','town','Water Island','186.33.52'),('186.33.52.244','town','Watermill','186.33.52'),('186.33.52.245','town','Waterville','186.33.52'),('186.33.52.246','town','West Babylon','186.33.52'),('186.33.52.247','town','West Bay Shore','186.33.52'),('186.33.52.248','town','West Gilgo Beach','186.33.52'),('186.33.52.249','town','West Hampton Dunes ','186.33.52'),('186.33.52.25','town','Bohemia','186.33.52'),('186.33.52.250','town','West Hills','186.33.52'),('186.33.52.251','town','West Islip','186.33.52'),('186.33.52.252','town','West Mecox Village','186.33.52'),('186.33.52.253','town','West Sayville','186.33.52'),('186.33.52.254','town','West Tiana','186.33.52'),('186.33.52.255','town','Westhampton','186.33.52'),('186.33.52.256','town','Westhampton Beach ','186.33.52'),('186.33.52.257','town','Westmoreland','186.33.52'),('186.33.52.258','town','Wheatley Heights','186.33.52'),('186.33.52.259','town','Wildwood','186.33.52'),('186.33.52.26','town','Brentwood','186.33.52'),('186.33.52.260','town','Wincoma','186.33.52'),('186.33.52.261','town','Woodcliff Park','186.33.52'),('186.33.52.262','town','Wyandanch','186.33.52'),('186.33.52.263','town','Yaphank ','186.33.52'),('186.33.52.27','town','Bridgehampton','186.33.52'),('186.33.52.28','town','Brightwaters ','186.33.52'),('186.33.52.29','town','Brookhaven','186.33.52'),('186.33.52.3','town','Amagansett','186.33.52'),('186.33.52.30','town','Calverton','186.33.52'),('186.33.52.31','town','Canoe Place','186.33.52'),('186.33.52.32','town','Center Moriches','186.33.52'),('186.33.52.33','town','Centereach','186.33.52'),('186.33.52.34','town','Centerport','186.33.52'),('186.33.52.35','town','Centerville','186.33.52'),('186.33.52.36','town','Central Islip','186.33.52'),('186.33.52.37','town','Cherry Grove','186.33.52'),('186.33.52.38','town','Cobb','186.33.52'),('186.33.52.39','town','Cold Spring Harbor','186.33.52'),('186.33.52.4','town','Amity Harbor','186.33.52'),('186.33.52.40','town','Commack','186.33.52'),('186.33.52.41','town','Copiague','186.33.52'),('186.33.52.42','town','Coram','186.33.52'),('186.33.52.43','town','Crystal Brook','186.33.52'),('186.33.52.44','town','Cutchogue','186.33.52'),('186.33.52.45','town','Cutchogue Station','186.33.52'),('186.33.52.46','town','Davis Park','186.33.52'),('186.33.52.47','town','Deer Park','186.33.52'),('186.33.52.48','town','Deerfield','186.33.52'),('186.33.52.49','town','Dering Harbor ','186.33.52'),('186.33.52.5','town','Amityville ','186.33.52'),('186.33.52.50','town','Devon','186.33.52'),('186.33.52.51','town','Ditch Plains','186.33.52'),('186.33.52.52','town','Divinity Hill','186.33.52'),('186.33.52.53','town','Dix Hills','186.33.52'),('186.33.52.54','town','East Brentwood','186.33.52'),('186.33.52.55','town','East Cutchogue','186.33.52'),('186.33.52.56','town','East Farmingdale','186.33.52'),('186.33.52.57','town','East Hampton ','186.33.52'),('186.33.52.58','town','East Hauppauge','186.33.52'),('186.33.52.59','town','East Islip','186.33.52'),('186.33.52.6','town','Apaquogue','186.33.52'),('186.33.52.60','town','East Marion','186.33.52'),('186.33.52.61','town','East Moriches','186.33.52'),('186.33.52.62','town','East Northport','186.33.52'),('186.33.52.63','town','East Patchogue','186.33.52'),('186.33.52.64','town','East Quogue','186.33.52'),('186.33.52.65','town','East Setauket','186.33.52'),('186.33.52.66','town','East Shoreham','186.33.52'),('186.33.52.67','town','Eastport','186.33.52'),('186.33.52.68','town','Eastside','186.33.52'),('186.33.52.69','town','Eatons Neck','186.33.52'),('186.33.52.7','town','Aquebogue','186.33.52'),('186.33.52.70','town','Elwood','186.33.52'),('186.33.52.71','town','Fair Harbor','186.33.52'),('186.33.52.72','town','Farmingville','186.33.52'),('186.33.52.73','town','Fire Island','186.33.52'),('186.33.52.74','town','Fire Island Pines','186.33.52'),('186.33.52.75','town','Fireplace','186.33.52'),('186.33.52.76','town','Fireplace Lodge Girls Camp','186.33.52'),('186.33.52.77','town','Fishers Island','186.33.52'),('186.33.52.78','town','Flanders','186.33.52'),('186.33.52.79','town','Flying Point','186.33.52'),('186.33.52.8','town','Art Village','186.33.52'),('186.33.52.80','town','Fort Hill','186.33.52'),('186.33.52.81','town','Fort Salonga','186.33.52'),('186.33.52.82','town','Freetown','186.33.52'),('186.33.52.83','town','Georgica','186.33.52'),('186.33.52.84','town','Gerard Park','186.33.52'),('186.33.52.85','town','Gilgo Beach','186.33.52'),('186.33.52.86','town','Gordon Heights','186.33.52'),('186.33.52.87','town','Great River','186.33.52'),('186.33.52.88','town','Greenlawn','186.33.52'),('186.33.52.89','town','Greenport ','186.33.52'),('186.33.52.9','town','Asharoken ','186.33.52'),('186.33.52.90','town','Hagerman','186.33.52'),('186.33.52.91','town','Halesite','186.33.52'),('186.33.52.92','town','Half Hollow','186.33.52'),('186.33.52.93','town','Hampton Bays','186.33.52'),('186.33.52.94','town','Hampton Beach','186.33.52'),('186.33.52.95','town','Hampton Park','186.33.52'),('186.33.52.96','town','Hardscrabble','186.33.52'),('186.33.52.97','town','Hauppauge','186.33.52'),('186.33.52.98','town','Hayground','186.33.52'),('186.33.52.99','town','Head of the Harbor ','186.33.52'),('186.33.53','county','Sullivan ','186.33'),('186.33.54','county','Tioga ','186.33'),('186.33.55','county','Tompkins ','186.33'),('186.33.56','county','Ulster ','186.33'),('186.33.57','county','Warren ','186.33'),('186.33.58','county','Washington ','186.33'),('186.33.59','county','Wayne ','186.33'),('186.33.6','county','Cayuga ','186.33'),('186.33.60','county','Westchester ','186.33'),('186.33.61','county','Wyoming ','186.33'),('186.33.62','county','Yates','186.33'),('186.33.7','county','Chautauqua ','186.33'),('186.33.8','county','Chemung ','186.33'),('186.33.9','county','Chenango ','186.33'),('186.34','state','North Carolina','186'),('186.35','state','North Dakota','186'),('186.36','state','Ohio','186'),('186.37','state','Oklahoma','186'),('186.38','state','Oregon','186'),('186.39','state','Pennsylvania','186'),('186.4','state','Arkansas','186'),('186.40','state','Rhode Island','186'),('186.41','state','South Carolina','186'),('186.42','state','South Dakota','186'),('186.43','state','Tennessee','186'),('186.44','state','Texas','186'),('186.45','state','Utah','186'),('186.46','state','Vermont','186'),('186.47','state','Virginia','186'),('186.48','state','Washington','186'),('186.49','state','West Virginia','186'),('186.5','state','California','186'),('186.50','state','Wisconsin','186'),('186.51','state','Wyoming','186'),('186.6','state','Colorado','186'),('186.7','state','Connecticut','186'),('186.7.1','county','Fairfield ','186.7'),('186.7.2','county','Hartford ','186.7'),('186.7.3','county','Litchfield ','186.7'),('186.7.4','county','Middlesex ','186.7'),('186.7.5','county','New Haven ','186.7'),('186.7.6','county','New London ','186.7'),('186.7.7','county','Tolland ','186.7'),('186.7.8','county','Windham ','186.7'),('186.8','state','Delaware','186'),('186.9','state','District of Columbia','186'),('187','country','Uruguay','187'),('188','country','Uzbekistan','188'),('189','country','Vanuatu','189'),('19','country','Benin','19'),('190','country','Vatican City','190'),('191','country','Venezuela','191'),('192','country','Vietnam','192'),('193','country','Yemen','193'),('194','country','Zambia','194'),('195','country','Zimbabwe','195'),('2','country','Albania','2'),('20','country','Bhutan','20'),('21','country','Bolivia','21'),('22','country','Bosnia Herzegovina','22'),('23','country','Botswana','23'),('24','country','Brazil','24'),('25','country','Brunei','25'),('26','country','Bulgaria','26'),('27','country','Burkina','27'),('28','country','Burundi','28'),('29','country','Cambodia','29'),('3','country','Algeria','3'),('30','country','Cameroon','30'),('31','country','Canada','31'),('31.1','state','Alterta','31'),('31.10','state','Saskatchewan','31'),('31.2','state','British Columbia','31'),('31.3','state','Manitoba','31'),('31.4','state','New Brunswick','31'),('31.5','state','Newfoundland','31'),('31.6','state','Nova Scotia','31'),('31.7','state','Ontario','31'),('31.8','state','Prince Edward Island','31'),('31.9','state','Quebec','31'),('32','country','Cape Verde','32'),('33','country','Central African Rep','33'),('34','country','Chad','34'),('35','country','Chile','35'),('36','country','China','36'),('37','country','Colombia','37'),('38','country','Comoros','38'),('39','country','Congo','39'),('4','country','Andorra','4'),('40','country','Congo [Democratic Rep]','40'),('41','country','Costa Rica','41'),('42','country','Croatia','42'),('43','country','Cuba','43'),('44','country','Cyprus','44'),('45','country','Czech Republic','45'),('46','country','Denmark','46'),('47','country','Djibouti','47'),('48','country','Dominica','48'),('49','country','Dominican Republic','49'),('5','country','Angola','5'),('50','country','East Timor','50'),('51','country','Ecuador','51'),('52','country','Egypt','52'),('53','country','El Salvador','53'),('54','country','Equatorial Guinea','54'),('55','country','Eritrea','55'),('56','country','Estonia','56'),('57','country','Ethiopia','57'),('58','country','Fiji','58'),('59','country','Finland','59'),('6','country','Antigua and Deps','6'),('60','country','France','60'),('61','country','Gabon','61'),('62','country','Gambia','62'),('63','country','Georgia','63'),('64','country','Germany','64'),('65','country','Ghana','65'),('66','country','Greece','66'),('67','country','Grenada','67'),('68','country','Guatemala','68'),('69','country','Guinea','69'),('7','country','Argentina','7'),('70','country','Guinea-Bissau','70'),('71','country','Guyana','71'),('72','country','Haiti','72'),('73','country','Honduras','73'),('74','country','Hungary','74'),('75','country','Iceland','75'),('76','country','India','76'),('77','country','Indonesia','77'),('78','country','Iran','78'),('79','country','Iraq','79'),('8','country','Armenia','8'),('80','country','Ireland [Republic]','80'),('81','country','Israel','81'),('82','country','Italy','82'),('83','country','Ivory Coast','83'),('84','country','Jamaica','84'),('85','country','Japan','85'),('86','country','Jordan','86'),('87','country','Kazakhstan','87'),('88','country','Kenya','88'),('89','country','Kiribati','89'),('9','country','Australia','9'),('90','country','Korea North','90'),('91','country','Korea South','91'),('92','country','Kosovo','92'),('93','country','Kuwait','93'),('94','country','Kyrgyzstan','94'),('95','country','Laos','95'),('96','country','Latvia','96'),('97','country','Lebanon','97'),('98','country','Lesotho','98'),('99','country','Liberia','99');

--
-- Table structure for table `cust_cart`
--

CREATE TABLE `cust_cart` (
  `cart_id` int(11) NOT NULL AUTO_INCREMENT,
  `flavor` varchar(250) DEFAULT NULL,
  `topping` varchar(250) DEFAULT NULL,
  `cust_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`cart_id`),
  KEY `cust_id_fk` (`cust_id`)
) ENGINE=MyISAM AUTO_INCREMENT=42 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cust_cart`
--

INSERT INTO `cust_cart` VALUES (6,'pistachio','hotFudge',1),(8,'pistachio','hotFudge',1),(9,'pistachio','hotFudge',1),(10,'vanilla,butter-pecan,pistachio','hotFudge',1),(11,'vanilla,butter-pecan,pistachio','hotFudge',1),(13,'butter-pecan,rocky-road,pistachio','hotFudge',1),(19,'vanilla,butter-pecan','hotFudge,whippedCream',2),(23,'vanilla,strawberry,french-vanilla','hotFudge,sprinkles,nuts',14),(29,'french-vanilla','hotFudge,nuts,whippedCream',28),(28,'vanilla','whippedCream',19),(30,'chocolate','hotFudge',59),(32,'vanilla,chocolate','nuts',63),(40,'vanilla','sprinkles',72);

--
-- Table structure for table `cust_order2_flavor`
--

CREATE TABLE `cust_order2_flavor` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `flavor` varchar(30) NOT NULL,
  `order_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ord_fk_flv` (`order_id`),
  CONSTRAINT `ord_fk_flv` FOREIGN KEY (`order_id`) REFERENCES `cust_order2` (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cust_order2_flavor`
--

INSERT INTO `cust_order2_flavor` VALUES (1,'vanilla',1),(2,'chocolate',1),(3,'strawberry',1),(4,'strawberry',2),(5,'butter-pecan',2),(6,'vanilla',3),(7,'chocolate',3),(10,'vanilla',5),(11,'chocolate',5),(12,'strawberry',5),(19,'vanilla',12),(20,'vanilla',13),(30,'vanilla',18),(31,'chocolate',18),(32,'strawberry',18),(33,'chocolate',19),(34,'strawberry',20);

--
-- Table structure for table `cust_order2_topping`
--

CREATE TABLE `cust_order2_topping` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `topping` varchar(30) NOT NULL,
  `order_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `ord_fk_top` (`order_id`),
  CONSTRAINT `ord_fk_top` FOREIGN KEY (`order_id`) REFERENCES `cust_order2` (`order_id`)
) ENGINE=InnoDB AUTO_INCREMENT=40 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `cust_order2_topping`
--

INSERT INTO `cust_order2_topping` VALUES (1,'hotFudge',1),(2,'sprinkles',1),(4,'sprinkles',2),(5,'nuts',2),(6,'hotFudge',3),(7,'sprinkles',3),(8,'nuts',3),(12,'hotFudge',5),(13,'sprinkles',5),(26,'hotFudge',12),(27,'hotFudge',13),(36,'hotFudge',18),(37,'nuts',18),(38,'hotFudge',19),(39,'hotFudge',20);

--
-- Table structure for table `image`
--

CREATE TABLE `image` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(20) NOT NULL,
  `name` varchar(50) NOT NULL,
  `owner` varchar(50) NOT NULL,
  `keyword` varchar(100) DEFAULT NULL,
  `filename` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `image`
--

INSERT INTO `image` VALUES (3,'book','unix','Deborah Ray,Eric Ray','unix,Visual QuickStart Guide, easy, teach yourself UNIX','book1.jpg'),(2,'book','html','Elizabeth Castro','HTML for the World Wide Web,Visual QuickStart Guide, easy, teach yourself HTML','book2.jpg'),(4,'book','html','Ed Tittel,Natanya Pitts,Chelsea Valentine','HTML4 for Dummies 3rd edition,top-notch HTML and utilities, XHTML','book3.jpg'),(5,'book','web design','xxx','Web Design in a Nutshell 2nd Edition,Desktop Quick Reference','book4.jpg'),(6,'book','internet','Deitel,Deitel,Nietro','Internet and World Wide Web How to Program, XML, XHTML','book5.jpg'),(16,'software','Dreamweaver','Macromedia','Macromedia Dreamweaver4, Fireworks4 Studio','software1.jpg'),(17,'software','Flash','Macromedia','Macromedia Flash5, High-Impact Web Experiences','software2.jpg'),(18,'software','web','Adobe','Adobe GoLive, Photoshop, Illustrator, LiveMotion, Web Collection','software3.jpg'),(19,'software','fireworks','Macromedia','Macromedia Fireworks4','software4.jpg'),(20,'software','freehand','Macromedia','Macromedia freehand 10','software5.jpg');

--
-- Table structure for table `java`
--

CREATE TABLE `java` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lname` varchar(20) NOT NULL,
  `fname` varchar(20) NOT NULL,
  `upd_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;

--
-- Dumping data for table `java`
--

INSERT INTO `java` VALUES (1,'Sultan','Sam','2009-05-04 00:03:35'),(2,'Johnson','John','2009-05-04 00:10:52'),(3,'Hicks','Bill','2010-07-07 03:16:00'),(4,'amy','tilva','2011-07-26 16:22:34'),(6,'amy','tilva','2011-07-26 16:23:39'),(7,'Bill','Jones','2011-07-26 16:24:23'),(8,'Potter','Harry','2011-07-27 04:53:13'),(9,'Lorenz','Jim','2012-06-26 19:49:35'),(10,'Bruce','Wayne','2012-06-26 20:00:59'),(12,'Last','First','2012-07-04 15:15:01'),(13,'Steel','Man','2013-06-09 23:33:04'),(14,'obama','care','2013-07-19 22:24:44'),(15,'RAY','LEWIS','2013-07-19 22:25:04'),(16,'Etienne','Joseph','2014-06-24 18:06:25');

--
-- Table structure for table `shopcart`
--

CREATE TABLE `shopcart` (
  `owner` varchar(20) NOT NULL,
  `content` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`owner`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `shopcart`
--

INSERT INTO `shopcart` VALUES ('2','Shirt:x_small,blue,1,34.99|'),('9','Hat:small,blue,1,24.99|Shirt:small,white,1,34.99|'),('31','Shirt:medium,white,1,34.99|Pants:medium,white,1,44.99|'),('14','Shirt:small,white,1,34.99|Pants:small,blue,1,44.99|'),('1','Shirt:medium,brown,1,34.99|Shoes:medium,brown,4,75|Pants:small,white,1,44.99|Suit:x_large,black,4,299.99|'),('27','Shirt:medium,blue,1,34.99|Pants:medium,brown,1,44.99|Shoes:medium,brown,1,75|'),('50','Hat:large,grey,100,24.99|'),('68','Pants:small,white,9,44.99|Shirt:small,white,9,34.99|');


