-- MySQL dump 10.14  Distrib 5.5.43-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: demo2
-- ------------------------------------------------------
-- Server version	5.5.43-MariaDB

--
-- Table structure for table 'addrbook'
--
DROP TABLE IF EXISTS 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
) DEFAULT CHARSET=latin1;
--
-- Load data for table 'addrbook'
--
LOCK TABLES addrbook WRITE;
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');
UNLOCK TABLES;

--
-- Table structure for table 'analytics'
--
DROP TABLE IF EXISTS analytics;
CREATE TABLE analytics (
  col1  float DEFAULT NULL,
  col2  float DEFAULT NULL,
  col3  float DEFAULT NULL,
  col4  float DEFAULT NULL,
  col5  float DEFAULT NULL,
  col6  float DEFAULT NULL,
  col7  float DEFAULT NULL,
  col8  float DEFAULT NULL,
  col9  float DEFAULT NULL,
  col10 float DEFAULT NULL,
  col11 float DEFAULT NULL,
  col12 float DEFAULT NULL,
  col13 float DEFAULT NULL,
  col14 float DEFAULT NULL,
  col15 float DEFAULT NULL,
  col16 float DEFAULT NULL,
  col17 float DEFAULT NULL,
  col18 float DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Load data for table 'analytics'
--
LOCK TABLES analytics WRITE;
INSERT INTO analytics VALUES 
(1,6.5,-44,0,88,102,216,131,-55,67,0.6,0,13,99,150,67,0,32.3),
(2,7.5,-45,0,89,103,217,132,-56,68,0.7,0,14,98,151,68,0,32.4),
(3,8.5,-46,0,90,104,218,133,-57,69,0.8,0,15,99,152,66,0,32.5),
(4,9.5,-47,0,91,105,219,134,-58,70,0.9,0,16,99,153,70,0,32.6),
(5,4.5,-48,0,92,106,220,135,-59,71,0.4,0,17,99,154,71,0,32.7),
(6,3.5,-49,0,93,107,221,136,-60,72,0.3,0,18,99,155,72,0,32.8);
UNLOCK TABLES;

--
-- Table structure for table 'country'
--
DROP TABLE IF EXISTS 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;
--
-- Load data for table 'country'
--
LOCK TABLES country WRITE;
INSERT INTO country VALUES 
('1','country','Afghanistan','1'),
('2','country','Albania','2'),
('3','country','Algeria','3'),
('4','country','Andorra','4'),
('5','country','Angola','5'),
('6','country','Antigua and Deps','6'),
('7','country','Argentina','7'),
('8','country','Armenia','8'),
('9','country','Australia','9'),
('10','country','Austria','10'),
('11','country','Azerbaijan','11'),
('12','country','Bahamas','12'),
('13','country','Bahrain','13'),
('14','country','Bangladesh','14'),
('15','country','Barbados','15'),
('16','country','Belarus','16'),
('17','country','Belgium','17'),
('18','country','Belize','18'),
('19','country','Benin','19'),
('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'),
('30','country','Cameroon','30'),
('31','country','Canada','31'),
('31.1','state','Alterta','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'),
('31.10','state','Saskatchewan','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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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.2','state','Baja California Norte','114'),
('114.3','state','Baja California Sur','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'),
('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.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.30','state','Veracruz','114'),
('114.31','state','Yacatan','114'),
('114.32','state','Zacatecas','114'),
('115','country','Micronesia','115'),
('116','country','Moldova','116'),
('117','country','Monaco','117'),
('118','country','Mongolia','118'),
('119','country','Montenegro','119'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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'),
('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.2','state','Alaska','186'),
('186.3','state','Arizona','186'),
('186.4','state','Arkansas','186'),
('186.5','state','California','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'),
('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.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.30','state','New Hampshire','186'),
('186.31','state','New Jersey','186'),
('186.31.1','county','Atlantic','186.31'),
('186.31.2','county','Bergen','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.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.20','county','Union','186.31'),
('186.31.21','county','Warren','186.31'),
('186.32','state','New Mexico','186'),
('186.33','state','New York','186'),
('186.33.1','county','Albany ','186.33'),
('186.33.2','county','Allegany ','186.33'),
('186.33.3','county','Bronx ','186.33'),
('186.33.3.1','town','Baychester','186.33.3'),
('186.33.3.2','town','Bedford Park','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.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.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.4','county','Broome ','186.33'),
('186.33.5','county','Cattaraugus ','186.33'),
('186.33.6','county','Cayuga ','186.33'),
('186.33.7','county','Chautauqua ','186.33'),
('186.33.8','county','Chemung ','186.33'),
('186.33.9','county','Chenango ','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.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.2','town','Bay Ridge','186.33.24'),
('186.33.24.3','town','Bedford-Stuyvesant','186.33.24'),
('186.33.24.4','town','Bensonhurst','186.33.24'),
('186.33.24.5','town','Boerum Hill','186.33.24'),
('186.33.24.6','town','Borough Park','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.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.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.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.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.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.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.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.30','county','Nassau ','186.33'),
('186.33.30.1','town','Glen Head','186.33.30'),
('186.33.30.2','town','Albertson','186.33.30'),
('186.33.30.3','town','Alden Manor','186.33.30'),
('186.33.30.4','town','Atlantic Beach ','186.33.30'),
('186.33.30.5','town','Baldwin','186.33.30'),
('186.33.30.6','town','Baldwin Harbor','186.33.30'),
('186.33.30.7','town','Barnum Island','186.33.30'),
('186.33.30.8','town','Baxter Estates ','186.33.30'),
('186.33.30.9','town','Bay Colony','186.33.30'),
('186.33.30.10','town','Bay Park','186.33.30'),
('186.33.30.11','town','Bayville ','186.33.30'),
('186.33.30.12','town','Bellerose ','186.33.30'),
('186.33.30.13','town','Bellerose Terrace','186.33.30'),
('186.33.30.14','town','Bellmore','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.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.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.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.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.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.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.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.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.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.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.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.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.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.31','county','New York ','186.33'),
('186.33.31.1','town','Harbor View Terrace','186.33.31'),
('186.33.31.2','town','Penn Station South','186.33.31'),
('186.33.31.3','town','Amalgamated Dwellings','186.33.31'),
('186.33.31.4','town','Amsterdam Houses','186.33.31'),
('186.33.31.5','town','Battery Park City','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.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.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.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.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.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.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.40','county','Putnam ','186.33'),
('186.33.41','county','Queens ','186.33'),
('186.33.41.1','town','Arverne','186.33.41'),
('186.33.41.2','town','Astoria','186.33.41'),
('186.33.41.3','town','Auburndale','186.33.41'),
('186.33.41.4','town','Bay Terrace ','186.33.41'),
('186.33.41.5','town','Bayside','186.33.41'),
('186.33.41.6','town','Bayswater','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.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.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.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.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.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.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.42','county','Rensselaer ','186.33'),
('186.33.43','county','Richmond ','186.33'),
('186.33.43.1','town','Arrochar','186.33.43'),
('186.33.43.2','town','Annadale','186.33.43'),
('186.33.43.3','town','Arden Heights','186.33.43'),
('186.33.43.4','town','Bay Terrace','186.33.43'),
('186.33.43.5','town','Bloomfield','186.33.43'),
('186.33.43.6','town','Bulls Head','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.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.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.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.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.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.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.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.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.2','town','Sagaponack ','186.33.52'),
('186.33.52.3','town','Amagansett','186.33.52'),
('186.33.52.4','town','Amity Harbor','186.33.52'),
('186.33.52.5','town','Amityville ','186.33.52'),
('186.33.52.6','town','Apaquogue','186.33.52'),
('186.33.52.7','town','Aquebogue','186.33.52'),
('186.33.52.8','town','Art Village','186.33.52'),
('186.33.52.9','town','Asharoken ','186.33.52'),
('186.33.52.10','town','Atlantique','186.33.52'),
('186.33.52.11','town','Babylon ','186.33.52'),
('186.33.52.12','town','Baiting Hollow','186.33.52'),
('186.33.52.13','town','Barnes Hole','186.33.52'),
('186.33.52.14','town','Bay Point','186.33.52'),
('186.33.52.15','town','Bay Shore','186.33.52'),
('186.33.52.16','town','Bay Wood','186.33.52'),
('186.33.52.17','town','Bayberry Dunes','186.33.52'),
('186.33.52.18','town','Bayport','186.33.52'),
('186.33.52.19','town','Beach Hampton','186.33.52'),
('186.33.52.20','town','Beixedon Estates','186.33.52'),
('186.33.52.21','town','Belle Terre ','186.33.52'),
('186.33.52.22','town','Bellport ','186.33.52'),
('186.33.52.23','town','Bellview Beach','186.33.52'),
('186.33.52.24','town','Blue Point','186.33.52'),
('186.33.52.25','town','Bohemia','186.33.52'),
('186.33.52.26','town','Brentwood','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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.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.60','county','Westchester ','186.33'),
('186.33.61','county','Wyoming ','186.33'),
('186.33.62','county','Yates','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.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.50','state','Wisconsin','186'),
('186.51','state','Wyoming','186'),
('187','country','Uruguay','187'),
('188','country','Uzbekistan','188'),
('189','country','Vanuatu','189'),
('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');
UNLOCK TABLES;

--
-- Table structure for table 'covid'
--
DROP TABLE IF EXISTS covid;
CREATE TABLE covid (
  id int(11) NOT NULL,
  country           varchar(99) NOT NULL,
  region            varchar(99) NOT NULL,
  population        int(11)     NOT NULL,
  cases             int(11)     NOT NULL,
  cases_last7days   int(11)     NOT NULL,
  cases_last24hrs   int(11)     NOT NULL,
  death             int(11)     NOT NULL,
  death_last7days   int(11)     NOT NULL,
  death_last24hrs   int(11)     NOT NULL,
  xmit_class        varchar(9)  DEFAULT NULL,
  PRIMARY KEY (id)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Load data for table 'covid'
--
LOCK TABLES covid WRITE;
INSERT INTO covid VALUES 
(1,'China','Asia',1471597122,102276,240,73,4849,3,0,'CC'),
(2,'India','Asia',1380007793,11333728,141640,24882,158446,790,140,'CC'),
(3,'United States','North America',331002599,29000561,531825,60312,527068,12055,1570,'CT'),
(4,'Indonesia','South-East Asia',273525624,1410134,42065,6412,38229,1203,180,'CT'),
(5,'Pakistan','Asia',220888415,600198,13184,2701,13430,302,53,'CT'),
(6,'Brazil','South America',212559314,11277717,483985,75412,272889,11919,2233,'CT'),
(7,'Nigeria','Africa',206135253,160332,2290,399,2009,55,8,'CT'),
(8,'Bangladesh','South-East Asia',164690772,555222,6038,1066,8515,74,13,'CT'),
(9,'Russia','Europe',145934317,4380525,68344,9908,91695,2969,475,'CC'),
(10,'Mexico','Central America',128933005,2151028,38520,6470,193142,4276,654,'CT'),
(11,'Japan','Western Pacific',126475263,445585,7693,1296,8509,331,58,'CC'),
(12,'Ethiopia','Africa',114963027,172571,8499,1361,2510,106,27,'CT'),
(13,'Philippines','Western Pacific',109581467,611618,23914,4570,12694,271,86,'CT'),
(14,'Egypt','Africa',102336086,189639,4305,639,11214,298,45,'CC'),
(15,'Viet Nam','South-East Asia',97328244,2550,49,15,35,0,0,'CC'),
(16,'Congo','Africa',89572906,26845,506,108,712,1,0,'CT'),
(17,'Turkey','Middle East',84339057,2850930,93470,14941,29356,455,66,'CT'),
(18,'Iran','Middle East',83993015,1731558,58088,8088,61069,557,53,'CT'),
(19,'Germany','Europe',83784054,2558455,66376,12674,73301,1497,239,'CT'),
(20,'Thailand','South-East Asia',69806940,26757,452,78,86,1,1,'CC'),
(21,'United Kingdom','Europe',67885963,4248290,40982,6609,125343,1082,175,'CT'),
(22,'France','Europe',65273557,3946733,155150,25120,89632,1856,290,'CT'),
(23,'Italy','Europe',60461849,3175807,152678,26790,101564,2293,380,'CC'),
(24,'Tanzania','Africa',59882353,509,0,0,21,0,0,'P'),
(25,'South Africa','Africa',59308707,1526873,7894,1225,51179,613,69,'CT'),
(26,'Myanmar','South-East Asia',54409096,142122,122,8,3201,1,0,'CC'),
(27,'Kenya','Africa',53770956,111935,4606,750,1901,31,2,'CT'),
(28,'North Korea','South-East Asia',51710000,0,0,0,0,0,0,'NC'),
(29,'South Korea','South-East Asia',51269123,95176,3121,490,1667,35,5,'CC'),
(30,'Colombia','South America',50882888,2290539,24328,4579,60858,669,85,'CT'),
(31,'Spain','Europe',46754751,3183704,24381,0,72258,401,0,'CT'),
(32,'Uganda','Africa',45740072,40544,118,9,334,0,0,'CT'),
(33,'Argentina','South America',45195733,2185747,43893,7849,53578,794,85,'CT'),
(34,'Algeria','Africa',43850993,115008,1060,157,3031,24,3,'CT'),
(35,'Sudan','Africa',43847465,30873,297,0,1940,36,0,'CT'),
(36,'Ukraine','Europe',43733815,1451744,57683,13276,28158,1239,243,'CT'),
(37,'Iraq','Middle East',40222594,750264,31143,4622,13696,159,25,'CT'),
(38,'Afghanistan','Asia',38928000,55959,119,0,2454,5,0,'CC'),
(39,'Poland','Europe',37846619,1889360,122870,21063,47068,2156,344,'CT'),
(40,'Canada','North America',37742118,899757,21366,3018,22371,220,36,'CT'),
(41,'Morocco','Africa',36910427,488181,2614,431,8716,43,4,'CC'),
(42,'Saudi Arabia','Middle East',34813714,381708,2616,360,6556,37,5,'SC'),
(43,'Uzbekistan','Asia',33469600,80481,356,89,622,0,0,'CC'),
(44,'Peru','South America',32971855,1394571,44724,7114,48484,1178,161,'CT'),
(45,'Angola','Africa',32867079,21265,239,60,519,8,2,'CT'),
(46,'Malaysia','Western Pacific',32366099,320939,10842,1575,1203,44,3,'CC'),
(47,'Mozambique','Africa',31255005,64004,2475,359,719,39,8,'CT'),
(48,'Ghana','Africa',31072938,86737,1498,0,656,27,0,'CT'),
(49,'Yemen','Middle East',29836245,2733,318,62,680,31,12,'CT'),
(50,'Nepal','Asia',29136757,275118,510,48,3012,2,0,'CC'),
(51,'Venezuela','South America',28435689,144277,3317,481,1415,51,8,'CT'),
(52,'Madagascar','Africa',27689243,20155,324,0,300,3,0,'CT'),
(53,'Cameroon','Africa',26545925,38988,3274,0,588,37,0,'CT'),
(54,'Cote d\'Ivoire','Africa',26378224,36824,3539,313,211,17,2,'CT'),
(55,'Australia','Oceania',25498992,29102,82,12,909,0,0,'CC'),
(56,'Niger','Africa',24204489,4853,113,0,180,8,0,'CT'),
(57,'Sri Lanka','South-East Asia',21413046,87286,2326,297,525,32,5,'CC'),
(58,'Burkina Faso','Africa',20901987,12305,182,30,145,2,2,'CT'),
(59,'Mali','Africa',20250460,8813,304,31,360,2,1,'CT'),
(60,'Romania','Europe',19237697,850362,29431,5010,21360,575,108,'CT'),
(61,'Malawi','Africa',19129571,32746,389,73,1079,21,1,'CT'),
(62,'Chile','South America',19116205,879485,39366,11536,21451,613,245,'CT'),
(63,'Kazakhstan','Asia',18776709,272420,4763,0,3456,67,0,'CC'),
(64,'Zambia','Africa',18383781,84240,2899,327,1149,36,1,'CT'),
(65,'Guatemala','Central America',17915588,181974,5098,1581,6546,111,24,'CT'),
(66,'Ecuador','South America',17643077,299216,8146,1259,16193,196,65,'CT'),
(67,'Syria','Middle East',17500536,16328,458,71,1090,36,5,'CT'),
(68,'Netherlands','Europe',17134873,1144822,34775,6068,16024,264,27,'CT'),
(69,'Senegal','Africa',16744048,36569,1532,198,951,55,10,'CT'),
(70,'Cambodia','South-East Asia',16719577,1264,311,39,1,1,0,'SC'),
(71,'Chad','Africa',16425826,4274,185,28,152,12,1,'CT'),
(72,'Somalia','Africa',15891892,8820,970,0,338,64,0,'CT'),
(73,'Zimbabwe','Africa',14862891,36423,175,46,1496,12,4,'CT'),
(74,'Guinea','Africa',13133259,17592,1172,220,102,9,1,'CT'),
(75,'Rwanda','Africa',12952535,20057,631,112,275,8,2,'CT'),
(76,'Benin','Africa',12124207,6501,430,0,81,6,0,'CT'),
(77,'Burundi','Africa',11889917,2441,142,21,3,0,0,'CT'),
(78,'Tunisia','Africa',11818646,240617,4261,640,8329,199,16,'CT'),
(79,'Bolivia','South America',11673042,257240,4880,778,11903,142,19,'CT'),
(80,'Belgium','Europe',11589629,801723,14369,0,22397,150,0,'CT'),
(81,'Haiti','Caribbean',11402780,12632,96,0,250,-1,-1,'CT'),
(82,'Cuba','Caribbean',11326629,59919,5834,762,365,24,4,'CT'),
(83,'South Sudan','Africa',11193189,9334,907,129,104,4,1,'CT'),
(84,'Dominican Republic','Caribbean',10847892,245452,3365,529,3213,63,9,'CT'),
(85,'Czechia','Europe',10708984,1392108,79944,15110,23083,1525,218,'CT'),
(86,'Greece','Europe',10423034,217018,15341,2357,6986,322,49,'CT'),
(87,'Jordan','Middle East',10203138,464856,46922,22654,5224,362,178,'CT'),
(88,'Portugal','Europe',10196711,813152,4747,577,16650,164,15,'CC'),
(89,'Azerbaijan','Asia',10139172,238959,2947,576,3268,33,6,'CC'),
(90,'Sweden','Europe',10099260,712527,27505,5252,13146,39,3,'CT'),
(91,'Honduras','Central America',9904618,176427,3850,985,4311,80,10,'CT'),
(92,'United Arab Emirates','Middle East',9890402,422246,20041,2250,1378,92,9,'CT'),
(93,'Hungary','Europe',9660345,507627,47811,9444,16790,1025,163,'CT'),
(94,'Tajikistan','Asia',9537520,13714,0,0,91,0,0,'P'),
(95,'Belarus','Europe',9449310,300146,7043,1186,2078,58,8,'CT'),
(96,'Austria','Europe',9006398,484682,17989,3009,8635,122,23,'CT'),
(97,'Papua New Guinea','South-East Asia',8947368,1819,290,0,21,5,0,'CT'),
(98,'Israel','Middle East',8655535,806257,7903,0,5925,62,0,'CT'),
(99,'Switzerland','Europe',8654617,567967,6702,6,9359,43,0,'CT'),
(100,'Togo','Africa',8278339,7953,525,96,93,5,0,'CT'),
(101,'Sierra Leone','Africa',7976480,3934,25,2,79,0,0,'CT'),
(102,'Lao','South-East Asia',7272727,48,1,0,0,0,0,'SC'),
(103,'Paraguay','South America',7132536,175827,11517,1814,3411,155,24,'CT'),
(104,'Serbia','Europe',6963761,507959,29081,4668,4670,145,26,'CT'),
(105,'Bulgaria','Europe',6948449,275859,17474,3159,11196,625,102,'CC'),
(106,'Libya','Africa',6871293,143643,6161,972,2348,112,8,'CT'),
(107,'Lebanon','Middle East',6825442,411839,21786,2930,5278,307,48,'CT'),
(108,'Nicaragua','Central America',6624333,5216,40,0,175,1,0,'CT'),
(109,'Kyrgyzstan','Asia',6524186,86818,312,63,1480,9,0,'CC'),
(110,'El Salvador','Central America',6486189,61947,1147,133,1940,46,5,'CT'),
(111,'Turkmenistan','Asia',5942000,0,0,0,0,0,0,'NC'),
(112,'Singapore','South-East Asia',5850334,60080,73,10,29,0,0,'SC'),
(113,'Denmark','Europe',5792204,219305,5373,645,2387,10,3,'CT'),
(114,'Finland','Europe',5540710,65315,3763,706,786,19,3,'CT'),
(115,'Congo','Africa',5518159,9329,150,0,131,0,0,'CT'),
(116,'Slovakia','Europe',5459646,336235,14131,2363,8440,701,94,'CC'),
(117,'Norway','Europe',5421252,78040,4547,872,639,7,0,'CT'),
(118,'Oman','Middle East',5106628,145257,2361,0,1600,17,0,'CT'),
(119,'Palestine (occupied territory)','Middle East',5101419,232665,14037,2309,2467,134,22,'CT'),
(120,'Costa Rica','Central America',5094113,208717,2424,473,2859,30,7,'CT'),
(121,'Liberia','Africa',5057299,2030,13,4,85,0,0,'CT'),
(122,'Ireland','Europe',4937791,225820,3651,641,4518,113,9,'CT'),
(123,'Central African Republic','Africa',4829742,5021,24,0,63,0,0,'CT'),
(124,'New Zealand','Oceania',4822596,2066,24,5,26,0,0,'CC'),
(125,'Mauritania','Africa',4649610,17410,143,16,442,0,0,'CT'),
(126,'Panama','Central America',4314769,346775,3494,474,5972,77,15,'CT'),
(127,'Kuwait','Middle East',4270569,207249,9139,1356,1156,43,8,'CT'),
(128,'Croatia','Europe',4105265,250484,4364,823,5670,85,23,'CT'),
(129,'Moldova','Europe',4033960,201909,8924,1785,4256,185,36,'CT'),
(130,'Georgia','Asia',3989165,274721,2104,344,3643,76,9,'CT'),
(131,'Eritrea','Africa',3546580,3038,116,29,7,0,0,'CT'),
(132,'Uruguay','South America',3473736,67717,6772,1233,683,52,5,'CT'),
(133,'Bosnia and Herzegovina','Europe',3280822,142160,6647,1170,5446,218,36,'CT'),
(134,'Mongolia','Asia',3278161,3664,511,103,4,2,0,'CC'),
(135,'Armenia','Asia',2963241,178799,4542,1695,3253,34,10,'CT'),
(136,'Jamaica','Caribbean',2961175,29387,4611,419,480,37,5,'CT'),
(137,'Qatar','Middle East',2881052,169284,3269,455,265,4,1,'CT'),
(138,'Albania','Europe',2877794,116123,4822,681,2018,121,16,'CC'),
(139,'Puerto Rico','Caribbean',2860850,102407,1341,356,2073,17,2,'CT'),
(140,'Lithuania','Europe',2722288,204954,3155,598,3389,68,16,'CT'),
(141,'Namibia','Africa',2540906,40810,1344,179,456,20,6,'CT'),
(142,'Gambia','Africa',2416695,4939,180,88,153,1,0,'CT'),
(143,'Botswana','Africa',2351635,34098,2440,0,424,65,0,'CT'),
(144,'Gabon','Africa',2225725,16660,1406,347,96,8,3,'CT'),
(145,'Lesotho','Africa',2142232,10528,6,0,309,2,0,'CT'),
(146,'North Macedonia','Europe',2083379,111077,4967,868,3280,104,15,'CT'),
(147,'Slovenia','Europe',2078938,199002,4835,770,4205,17,0,'CC'),
(148,'Guinea-Bissau','Africa',1968030,3398,95,18,52,3,1,'CT'),
(149,'Latvia','Europe',1886198,92906,3492,632,1746,66,9,'CT'),
(150,'Kosovo','Europe',1860381,75927,4036,730,1678,54,6,'CT'),
(151,'Bahrain','Middle East',1701574,129825,4311,744,480,12,2,'CC'),
(152,'Equatorial Guinea','Africa',1402976,6562,352,106,98,5,0,'CT'),
(153,'Trinidad and Tobago','Caribbean',1399484,7753,26,10,140,1,0,'CT'),
(154,'Estonia','Europe',1326534,83872,10188,1586,710,66,15,'CC'),
(155,'Timor-Leste','Western Pacific',1318852,170,51,11,0,0,0,'CC'),
(156,'Mauritius','Africa',1271857,691,71,50,10,0,0,'CC'),
(157,'Cyprus','Europe',1207359,38879,2602,383,238,6,2,'CC'),
(158,'Eswatini','Africa',1160167,17225,70,10,659,5,0,'CT'),
(159,'Djibouti','Africa',988006,6236,106,2,63,0,0,'CT'),
(160,'Fiji','Western Pacific',896739,66,3,0,2,0,0,'SC'),
(161,'Reunion','Africa',895314,13801,676,0,71,12,0,'CT'),
(162,'Comoros','Africa',869597,3615,28,1,146,1,0,'CT'),
(163,'Guyana','South America',786555,8993,294,65,206,7,1,'CC'),
(164,'Bhutan','Asia',771624,868,1,0,1,0,0,'SC'),
(165,'Solomon Islands','Western Pacific',687023,18,0,0,0,0,0,'NC'),
(166,'Montenegro','Europe',628066,82603,2818,0,1113,54,0,'CC'),
(167,'Luxembourg','Europe',625978,57503,1207,182,681,29,6,'CT'),
(168,'Suriname','South America',586632,8997,38,7,176,1,1,'CC'),
(169,'Cabo Verde','Africa',555986,15986,303,54,155,3,0,'CT'),
(170,'Maldives','Asia',540545,21382,817,114,64,0,0,'CC'),
(171,'Malta','Europe',441543,25969,2098,329,346,18,5,'CC'),
(172,'Brunei Darussalam','South-East Asia',437457,192,4,0,3,0,0,'SC'),
(173,'Guadeloupe','Caribbean',400124,10458,0,0,168,0,0,'CT'),
(174,'Belize','Central America',397628,12359,30,4,316,2,0,'CT'),
(175,'Bahamas','Caribbean',393244,8680,71,0,185,4,0,'CC'),
(176,'Martinique','Caribbean',375265,6886,0,0,47,0,0,'CT'),
(177,'Iceland','Europe',341242,6072,13,0,29,0,0,'CT'),
(178,'Vanuatu','Western Pacific',306122,3,2,0,0,0,0,'NC'),
(179,'French Guiana','South America',298682,16764,71,71,87,0,0,'CT'),
(180,'Barbados','Caribbean',287375,3372,186,19,37,0,0,'CT'),
(181,'New Caledonia','Western Pacific',285529,88,30,7,0,0,0,'SC'),
(182,'French Polynesia','South-East Asia',280908,18527,68,10,141,1,0,'SC'),
(183,'Mayotte','Africa',272815,18642,502,38,129,4,0,'CT'),
(184,'Sao Tome and Principe','Africa',219159,2035,112,0,32,1,0,'CT'),
(185,'Samoa','Western Pacific',198020,4,0,0,0,0,0,'NC'),
(186,'Saint Lucia','Caribbean',183627,3966,152,25,47,4,0,'CT'),
(187,'Guam','South-East Asia',168775,7557,18,9,133,0,0,'CC'),
(188,'Curacao','Caribbean',164093,4915,164,53,22,0,0,'CT'),
(189,'Kiribati','Western Pacific',117606,0,0,0,0,0,0,'NC'),
(190,'Micronesia','Western Pacific',113815,0,0,0,0,0,0,'NC'),
(191,'Grenada','Caribbean',112527,151,0,0,1,0,0,'SC'),
(192,'Saint Vincent and Grenadines','Caribbean',110940,1674,16,0,8,0,0,'CT'),
(193,'Jersey','Europe',108800,3222,2,0,69,0,0,'CT'),
(194,'Aruba','Caribbean',106766,8272,263,45,77,2,0,'CT'),
(195,'Tonga','Western Pacific',104494,0,0,0,0,0,0,'NC'),
(196,'United States Virgin Islands','Caribbean',104425,2761,47,0,25,0,0,'CT'),
(197,'Seychelles','Africa',98347,3132,242,45,15,2,0,'CT'),
(198,'Antigua and Barbuda','Caribbean',97929,945,176,83,25,6,3,'CC'),
(199,'Isle of Man','Europe',85032,1028,482,76,25,0,0,'NC'),
(200,'Andorra','Europe',77265,11199,201,0,112,0,0,'CT'),
(201,'Dominica','Caribbean',71992,156,12,5,0,0,0,'CC'),
(202,'Cayman Islands','Caribbean',65720,463,15,3,2,0,0,'SC'),
(203,'Guernsey','Europe',63196,821,0,0,14,0,0,'CT'),
(204,'Bermuda','Caribbean',62273,732,11,1,12,0,0,'SC'),
(205,'Marshall Islands','Western Pacific',59172,4,0,0,0,0,0,'NC'),
(206,'Northern Mariana Islands','South-East Asia',57557,147,3,1,2,0,0,'P'),
(207,'Greenland','Europe',56777,31,0,0,0,0,0,'NC'),
(208,'American Samoa','Western Pacific',55312,0,0,0,0,0,0,'NC'),
(209,'Saint Kitts and Nevis','Caribbean',53191,43,2,1,0,0,0,'SC'),
(210,'Faroe Islands','Europe',48865,660,2,0,1,0,0,'SC'),
(211,'Sint Maarten','Caribbean',42882,2078,12,1,27,0,0,'CT'),
(212,'Monaco','Europe',39244,2097,89,22,27,1,1,'SC'),
(213,'Turks and Caicos Islands','Caribbean',38718,2200,58,10,15,1,0,'CC'),
(214,'Saint Martin','Caribbean',38659,1581,0,0,12,0,0,'CT'),
(215,'Liechtenstein','Europe',38137,2678,12,0,54,0,0,'SC'),
(216,'San Marino','Europe',33938,4126,230,30,77,1,0,'CT'),
(217,'Gibraltar','Europe',33691,4259,16,3,93,0,0,'CC'),
(218,'British Virgin Islands','Caribbean',30237,154,0,0,1,0,0,'CC'),
(219,'Bonaire','Caribbean',20915,633,178,37,6,1,0,'CT'),
(220,'Palau','Western Pacific',18008,0,0,0,0,0,0,'NC'),
(221,'Cook Islands','Western Pacific',17459,0,0,0,0,0,0,'NC'),
(222,'Anguilla','Caribbean',15002,19,1,-2,0,0,0,'SC'),
(223,'Nauru','Western Pacific',12581,0,0,0,0,0,0,'NC'),
(224,'Tuvalu','Western Pacific',11646,0,0,0,0,0,0,'NC'),
(225,'Wallis and Futuna','Western Pacific',11246,155,146,1,0,0,0,'SC'),
(226,'Saint Barthelemy','Caribbean',9885,671,59,0,0,0,0,'CC'),
(227,'Saint Helena','Africa',6600,0,0,0,0,0,0,'NC'),
(228,'Saint Pierre and Miquelon','Caribbean',5795,24,0,0,0,0,0,'NC'),
(229,'Montserrat','Caribbean',4999,20,0,0,1,0,0,'SC'),
(230,'Falkland Islands','South America',3483,51,0,0,0,0,0,'NC'),
(231,'Sint Eustatius','Caribbean',3139,20,0,0,0,0,0,'NC'),
(232,'Saba','Caribbean',1933,6,0,0,0,0,0,'NC'),
(233,'Niue','Western Pacific',1624,0,0,0,0,0,0,'NC'),
(234,'Tokelau','Western Pacific',1411,0,0,0,0,0,0,'NC'),
(235,'Holy See','Europe',809,26,0,0,0,0,0,'SC'),
(236,'Pitcairn Islands','Western Pacific',67,0,0,0,0,0,0,'NC'),
(237,'Other','Other',0,745,0,0,13,0,0,'NA');
UNLOCK TABLES;

--
-- Table structure for table 'covid_class'
--
DROP TABLE IF EXISTS covid_class;
CREATE TABLE covid_class (
  xmit_class     varchar(9)  NOT NULL,
  Classification varchar(99) NOT NULL,
  PRIMARY KEY (xmit_class)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Load data for table 'covid_class'
--
LOCK TABLES covid_class WRITE;
INSERT INTO covid_class VALUES 
('CC','Cluster Cases'),
('CT','Community Transmission'),
('NA','Not Applicable'),
('NC','No Cases'),
('P','Pending'),
('SC','Sporadic Cases');
UNLOCK TABLES;

--
-- Table structure for table 'cust_cart'
--
DROP TABLE IF EXISTS cust_cart;
CREATE TABLE cust_cart (
  cart_id   int(11)     NOT NULL AUTO_INCREMENT,
  flavor    varchar(250),
  topping   varchar(250),
  cust_id   int(11)     NOT NULL,
  PRIMARY KEY (cart_id)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
--
-- Load data for table 'cust_cart'
--
LOCK TABLES cust_cart WRITE;
INSERT INTO cust_cart VALUES 
(2,'vanilla,chocolate','hotFudge,sprinkles',1);
UNLOCK TABLES;

--
-- Table structure for table 'cust_order'
--
DROP TABLE IF EXISTS cust_order;
CREATE TABLE cust_order (
  order_id   int(11)      NOT NULL AUTO_INCREMENT,
  firstname  varchar(30)  NOT NULL,
  lastname   varchar(30)  NOT NULL,
  address    varchar(100) NOT NULL,
  flavor     varchar(60)  NOT NULL,
  topping    varchar(60)  NOT NULL,
  creditCard varchar(15)  NOT NULL,
  cust_id    int(11)      NOT NULL,
  PRIMARY KEY (order_id)
) AUTO_INCREMENT=2591 DEFAULT CHARSET=latin1;
--
-- Load data for table 'cust_order'
--
LOCK TABLES cust_order WRITE;
INSERT INTO cust_order VALUES 
(533,'sam','sultan','216 COLD SPRING RD\r\nSeptember 24 @ 8:31pm','vanilla,chocolate,strawberry','hotFudge,sprinkles','MC',1),
(294,'Sam','Sultan','124 Main Street\r\nNew York','vanilla,chocolate,butter-pecan,rocky-road,pistachio','sprinkles,nuts','visa',1),
(6,'Sam','Samuels','Way out there','vanilla,chocolate,strawberry','hotFudge,sprinkles,nuts','visa',1),
(7,'Fred','Fredricks','Top of the Hill','chocolate','hotFudge,nuts','master-card',1),
(8,'Donald','Duck','1 Magic Place\r\nOrlando, FL\r\nUSA','rocky-road,french-vanilla,pistachio','sprinkles,nuts','master-card',1),
(9,'Sam','Sultan','123 Main Street','butter-pecan,pistachio','hotFudge,nuts','visa',1),
(10,'Herman','Munsters','1313 Mocking Bird Lane','chocolate','hotFudge,nuts','visa',1),
(11,'Sam','Sultan','1234 Main Street','chocolate,strawberry','hotFudge,nuts','amex',1),
(118,'George','Bush','out of the whitehouse\r\nWashington DC','strawberry,butter-pecan','nuts','amex',1),
(13,'sam','sultan','123 main street','vanilla,chocolate','hotFudge','visa',1),
(15,'Fred','Flintstone','1 Bedrock Avenue \r\nBedrock','strawberry,butter-pecan','hotFudge,sprinkles','visa',1),
(175,'john','doe','main street','vanilla,strawberry,rocky-road','sprinkles,whippedCream','master-card',1),
(164,'Sam','Sultan','123 Main street\r\nNew York, NY 12345','vanilla,chocolate,butter-pecan,pistachio','sprinkles,nuts','visa',1),
(115,'Sam ','Sultan','123 main street 6/20','vanilla,chocolate,strawberry','hotFudge','visa',1),
(152,'hello ','kitty','123 kitty land','chocolate','hotFudge','visa',1),
(165,'Sam','Sultan','123 Main street\r\nNew York, NY 12345','vanilla,butter-pecan','hotFudge','master-card',1),
(40,'Mickey','Mouse','1 Magic Kingdom\r\nOrlando Fl','vanilla,chocolate,strawberry','hotFudge,nuts','visa',1),
(121,'Dave','Davidson','123 Main Street\r\nNew York\r\nNY','vanilla,chocolate,strawberry','hotFudge','visa',1),
(137,'Vasant ','Mangal','45 120W','vanilla,chocolate','sprinkles','amex',1),
(47,'Bob','Smith','Land of Nowhere','vanilla,chocolate','sprinkles,nuts','visa',1),
(586,'David','Johnson','7 E 12th st','chocolate','nuts','visa',1),
(54,'Bill','Gates','$100 Billion Road\r\nWealthville, CA 12345','vanilla','nuts','amex',1),
(107,'Martha','Sanchez','123 Main Street','vanilla,chocolate,strawberry,butter-pecan','hotFudge,nuts','visa',1),
(59,'Zcar','Peter','czar palace\r\nSt. Petersburg\r\n','vanilla,chocolate,strawberry','hotFudge,sprinkles','master-card',1),
(61,'Hillary','Clinton','White House 2008','butter-pecan','hotFudge,whippedCream','master-card',1),
(2551,'sherry','chao','123 main st','vanilla,chocolate','hotFudge,nuts,','visa',1),
(234,'Harry','Lastname','523 Harriet Street','vanilla,chocolate,pistachio','sprinkles,nuts','visa',1),
(101,'Sam ','Sultan','123 main street (6/12)','vanilla,chocolate,strawberry','hotFudge,sprinkles','visa',1),
(157,'sam','sultan','48 cooper','vanilla','hotFudge','visa',1),
(99,'John','Martinez','56 Holly dr.','chocolate','hotFudge','master-card',1),
(170,'John','Johnson','124 Main Street','vanilla,chocolate,butter-pecan,french-vanilla','sprinkles,nuts','visa',2),
(93,'Martina','Fugo','45 something st','chocolate','hotFudge,sprinkles,whippedCream','amex',1),
(178,'sam','sultan','12345 unknown road','vanilla,chocolate,strawberry','hotFudge,nuts','visa',1),
(169,'Sam Jr.','Sultan','123 Main street\r\nNew York, NY 12345','chocolate,rocky-road,pistachio','hotFudge','master-card',1),
(2540,'Samuel','Sultan','1234 Main Street','vanilla','hotFudge','visa',1),
(163,'John','John','124 Main Street','chocolate,strawberry','hotFudge,nuts','master-card',2),
(162,'John','Johnson','124 Main Street','vanilla','hotFudge','visa',2),
(181,'laura','g','a better address \r\nwould be nice','butter-pecan','nuts,whippedCream','amex',1),
(184,'maria','quizon','jersey','chocolate','hotFudge,sprinkles,nuts','amex',1),
(185,'Sam Sr.','Sultan','trying the new DB','vanilla,chocolate,strawberry','hotFudge','visa',1),
(436,'JIHAE','CHUNG','NEW YORK','chocolate,rocky-road','whippedCream','master-card',57),
(571,'Xi','jin','540 main street, Roosevelt isl','vanilla','hotFudge,','visa',1),
(242,'Richard','Schulman','5 Tudor City Place','vanilla,chocolate,strawberry,butter-pecan,rocky-road,french-','sprinkles,whippedCream','master-card',1),
(588,'Omar','Sharif','12 park','vanilla','sprinkles','visa',1),
(563,'Yvette','Hu','123 main street','chocolate','sprinkles,nuts,','master-card',1),
(200,'sam','sultan','123 main street','vanilla,chocolate,strawberry','hotFudge,sprinkles','visa',1),
(241,'Richard','Schulman','5 Tudor City Place','vanilla,chocolate,strawberry,butter-pecan,rocky-road,french-','sprinkles,whippedCream','master-card',1),
(202,'sam','sultan','123 main st','strawberry,butter-pecan','hotFudge,sprinkles','visa',1),
(203,'sam','sultan','123 main st','strawberry,butter-pecan','hotFudge,sprinkles','visa',1),
(204,'John','Doe','Generic Address\r\nNy, NY','vanilla,strawberry','hotFudge,nuts','visa',1),
(205,'mike','jones','2828 NY','strawberry','hotFudge','visa',1),
(231,'sam','sultan','here at the Woolworth Bldg','butter-pecan,rocky-road','hotFudge,sprinkles','visa',1),
(230,'steve','pezz','45 new york city','vanilla','sprinkles','master-card',1),
(2530,'Sam','Sultan','123 Main Street','vanilla','hotFudge','visa',1),
(2531,'Sam','Sultan','123 Main Street','vanilla,chocolate,strawberry','hotFudge,sprinkles','visa',1),
(213,'Benand','Jerry','Waffle Cone Ave','vanilla,chocolate,strawberry,butter-pecan,rocky-road','hotFudge,sprinkles','visa',1),
(214,'Tom','Jerry','Kitchen ','strawberry','whippedCream','amex',1),
(560,'Sam','Sultan','123 main street\r\nNew York 12/1/2016','vanilla,chocolate,strawberry','hotFudge,whippedCream','visa',1),
(527,'Chris','Sanchez','123 main street','vanilla,butter-pecan','hotFudge,whippedCream','visa',1),
(585,'Austin','Browning','665 Broadway','strawberry,pistachio','sprinkles,whippedCream','master-card',1),
(286,'sam','sultan','2nd time around','vanilla','hotFudge','visa',1),
(221,'Jane','Jones','456 Happy Place','vanilla','sprinkles,whippedCream','amex',1),
(222,'joe','bloggs','123 abc rd.','vanilla,chocolate','hotFudge,sprinkles,nuts','master-card',1),
(223,'sam','sultan','woolworth bldg','vanilla,chocolate,strawberry','hotFudge','visa',1),
(561,'Michael','Sun','605 ','strawberry','hotFudge,nuts,','visa',1),
(226,'sam','sultan','123 main street 6/24/2011','vanilla','hotFudge','visa',1),
(523,'yao','huang','1234 j st','strawberry','sprinkles','visa',80),
(244,'Melissa','Young','123 address street','vanilla','hotFudge','visa',1),
(245,'Christopher','HB','something10','strawberry','hotFudge','visa',1),
(285,'sam','sultan','one more time','vanilla,chocolate,strawberry','hotFudge,nuts,whippedCream','master-card',1),
(247,'John','Smith','test address','vanilla','whippedCream','amex',1),
(248,'David','Tawil','123 Fake Street','chocolate','hotFudge,sprinkles,nuts,whippedCream','visa',1),
(249,'Raybblin','Vargas','600 West 161st. Street \r\nApt. 5A\r\nNew York, New York 10032','vanilla','nuts,whippedCream','visa',1),
(499,'ericka','luba','new york, ny','strawberry','sprinkles,whippedCream','master-card',1),
(304,'chas','hill','3521','butter-pecan','hotFudge','visa',40),
(290,'sam','sultan','testing the entire application','vanilla','hotFudge','visa',1),
(289,'sam','sultan','123 xyz street','vanilla','hotFudge','visa',1),
(454,'ji','choi','123 charles st','chocolate','hotFudge','master-card',1),
(307,'Dan','M','none of your business','strawberry','hotFudge','master-card',1),
(260,'yoyo','Ma','master street','vanilla,strawberry','hotFudge,whippedCream','master-card',1),
(261,'jiyeon','lee','3110 th','vanilla,chocolate','hotFudge,sprinkles','master-card',1),
(262,'John','Doe','123 Main Street','vanilla,chocolate','hotFudge,sprinkles,nuts','master-card',1),
(263,'Jiyeon','Lee','Station Square','vanilla,strawberry','hotFudge','master-card',1),
(265,'sam','sultan','12 E 12 ','vanilla,chocolate,strawberry','hotFudge','master-card',1),
(266,'sam','sultan','123 main street','vanilla,butter-pecan','hotFudge','visa',1),
(267,'kelly','kim','123 church street\r\nny, ny 10010','chocolate,butter-pecan','sprinkles','amex',1),
(268,'J','Lee','Station SQ. -- 505','strawberry,butter-pecan','hotFudge,whippedCream','visa',1),
(301,'Dan','Danielson','123 45th Street\r\nNew York, NY 10021','vanilla,strawberry,pistachio','hotFudge,nuts','master-card',1),
(300,'Bob','Toney','122 pacific st','vanilla','hotFudge','visa',1),
(313,'Outcalt','Leela','397 Park Pl','vanilla','hotFudge','visa',1),
(276,'sita','mosodeen','133-42 114th str','vanilla','hotFudge','visa',1),
(279,'sam','sultan','123 main street\r\n4/21/2012','chocolate,strawberry,butter-pecan','hotFudge,nuts','amex',1),
(315,'leela','outcalt','MY adress','strawberry','hotFudge','visa',1),
(316,'Elizabeth','Timmins','123 Spring Street','chocolate','hotFudge,sprinkles','master-card',1),
(437,'SAM','SULTAN','123 MAIN STREET\r\n12/5/2013','vanilla,chocolate,strawberry','hotFudge,sprinkles','visa',1),
(318,'Sam','Sultan','123 main street','strawberry','hotFudge','master-card',1),
(444,'huge','beard','123 fake st','strawberry','hotFudge','visa',1),
(558,'Sam','Sultan','123 main street\r\nNew York 12/1/2016','vanilla,chocolate,strawberry','hotFudge,whippedCream','visa',1),
(589,'Donald','Trump','Trump Plaza\r\n5th Ave\r\nNew York, NY ','vanilla,chocolate,strawberry','hotFudge,sprinkles,','master-card',1),
(524,'sam','sultan','123 main street','chocolate,rocky-road','sprinkles','visa',79),
(456,'Saamahn','Mahjouri','853 7th Avenue','vanilla','hotFudge,whippedCream','visa',1),
(508,'YANG','CHEN','40 Newport Parkway apt 2506','vanilla','sprinkles','visa',74),
(403,'Marvin','Tumasar','10419 105th Street','chocolate','hotFudge','visa',1),
(583,'Sam','Sultan','7 east 12 street','vanilla,chocolate','hotFudge,nuts','visa',1),
(584,'Sam','Sultan','7 East 12th Street','vanilla,chocolate','hotFudge,nuts','visa',1),
(442,'sam','sultan','123 main street \r\n12/7/2013','chocolate,strawberry,butter-pecan','sprinkles,nuts','master-card',1),
(412,'Danny','Walls','1 Park Avenue','strawberry','hotFudge','visa',45),
(413,'Marvin','Tee','233 Broadway','vanilla,butter-pecan,pistachio','hotFudge','visa',46),
(496,'Yuta','Okazaki','Midtown','vanilla','hotFudge','visa',1),
(441,'Andrew','Mac','45e Main St  12/7/2013\r\nApt 601\r\nNew York','butter-pecan','hotFudge,sprinkles','visa',1),
(416,'prat','tee','10120301','strawberry','hotFudge,sprinkles','visa',1),
(503,'sylvia','fu','here midtown','strawberry,french-vanilla','sprinkles,nuts','visa',1),
(431,'mike','bucket','5799 westwood street\r\nnew york, ny\r\n11011','vanilla','hotFudge,sprinkles,nuts','visa',1),
(449,'Joe','Smoe','56 White Street\r\nNew York, NY\r\n11022','strawberry','hotFudge','visa',1),
(417,'Adam','Saxe','801 Amsterdm','chocolate','hotFudge,whippedCream','amex',1),
(425,'sal','gueli','2311','vanilla','hotFudge','visa',1),
(426,'Sam','Sultan','123 main street \r\n7/7/2013','vanilla,chocolate,strawberry','hotFudge,nuts','visa',1),
(427,'sam','sultan','123 main street \r\n08/10/2013','vanilla,chocolate','hotFudge,sprinkles','visa',1),
(506,'YANG','CHEN','123 st, 10010','strawberry','hotFudge','amex',74),
(396,'Rudolph','Reindeer','North Pole','butter-pecan','nuts','amex',1),
(397,'michelle','obama','1600 Pennsylvania Ave','strawberry','sprinkles','master-card',1),
(559,'Bhavana','Singh','9876\r\n12/1/2016','vanilla,chocolate,strawberry','hotFudge,whippedCream','visa',1),
(435,'Sam','Sultan','123 Main Street\r\nNew York','vanilla,rocky-road,french-vanilla,pistachio','hotFudge,sprinkles','visa',1),
(401,'s ','parsons','100 whatever','chocolate','hotFudge','visa',1),
(419,'Debra','holmes','111 St','strawberry','sprinkles','master-card',1),
(394,'a','chan','970 kensington rd\r\nmt prospect il 60056','strawberry','hotFudge','visa',1),
(395,'Santa','Claus','North Pole','chocolate','hotFudge','visa',1),
(387,'John','Demler','1234 Hammermill Ln.\r\nGary, Indiana\r\n12341','chocolate','sprinkles','amex',1),
(698,'Sam','Sultan','123 Main Street','chocolate','hotFudge','visa',1);
UNLOCK TABLES;

--
-- Table structure for table 'cust_order2'
--
DROP TABLE IF EXISTS cust_order2;
CREATE TABLE cust_order2 (
  order_id      int(11)     NOT NULL AUTO_INCREMENT,
  firstname     varchar(30) NOT NULL,
  lastname      varchar(30) NOT NULL,
  address       varchar(100) NOT NULL,
  creditCard    varchar(15) NOT NULL,
  cust_id       int(11)     NOT NULL,
  PRIMARY KEY (order_id)
) ENGINE=InnoDB AUTO_INCREMENT=2577 DEFAULT CHARSET=latin1;
--
-- Load data for table 'cust_order2'
--
LOCK TABLES cust_order2 WRITE;
INSERT INTO cust_order2 VALUES 
(1,'sam','sultan','123 main street','visa',1),
(2,'Sam ','Sultan','123 main blvd\r\nnew york, new york','amex',1),
(3,'Sam','Sultan','54321 some street\r\nSome Town, NY 12345','visa',1),
(5,'Sam ','Sultan','123 main street\r\n12/10/12','visa',1),
(12,'Saamahn','Mahjouri','16392 Ringer Road','master-card',1),
(13,'hugh','beard','testing 123','visa',1),
(18,'sam','sultan','123 main street\r\n2014-07-19','amex',1),
(21,'YANG','CHEN','A good address','visa',1),
(22,'Yifei','Han','145','master-card',1),
(23,'ying','lian','888','visa',1),
(2524,'Sam','Sultan','123 Main Street','visa',1),
(2525,'Sam','Sultan','123 Main Street','master-card',1),
(2526,'Sam','Sultan','AAA street \r\nNew York','visa',1),
(2527,'Sam','Sultan','111 main street','visa',1),
(2528,'Sam','Sultan','123 Main Street','amex',1),
(2529,'Sam','Sultan','123 Main Street','visa',1),
(2530,'Sam','Sultan','123 Main Street','visa',1),
(2531,'Sam','Sultan','123 Main Street','visa',1),
(2532,'Sam','Sultan','123 Main Street','visa',1),
(2533,'Sam','Sultan','123 Main Street','visa',1),
(2534,'Sam','Sultan','123 Main Street','visa',1),
(2535,'Sam','Sultan','1234 Main Street','visa',1),
(2536,'Sam','Sultan','1234 Main Street','visa',1),
(2537,'Sam','Sultan','1234 Main Street','amex',1),
(2538,'Samuel','Sultan','123-456 Main Street','visa',1),
(2548,'Samuel','Sultan','1234 Main Street','visa',1),
(2560,'Samuel','Sultan','1234 Main Street','visa',1),
(2566,'Sam','Sultan','1234 Main Street','visa',1),
(2567,'Sam','Sultan','1234 Main Street','visa',1),
(2568,'Sam','Sultan','1234 Main Street','master-card',1),
(2571,'di','gou','123mainst','visa',118),
(2573,'frank','zhang','2222','visa',119),
(2574,'Sam','Sultan','1234 Main Street','visa',1);
UNLOCK TABLES;

--
-- Table structure for table 'cust_order2_flavor'
--
DROP TABLE IF EXISTS 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=95 DEFAULT CHARSET=latin1;
--
-- Load data for table 'cust_order2_flavor'
--
LOCK TABLES cust_order2_flavor WRITE;
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),
(35,'chocolate',21),
(36,'vanilla',22),
(37,'strawberry',22),
(38,'strawberry',23),
(39,'butter-pecan',23),
(40,'vanilla',2524),
(41,'chocolate',2524),
(42,'strawberry',2524),
(43,'vanilla',2525),
(44,'butter-pecan',2525),
(45,'vanilla',2526),
(46,'chocolate',2526),
(47,'strawberry',2526),
(48,'vanilla',2527),
(49,'chocolate',2527),
(50,'strawberry',2527),
(51,'rocky-road',2528),
(52,'french-vanilla',2528),
(53,'pistachio',2528),
(54,'vanilla',2529),
(55,'vanilla',2530),
(56,'vanilla',2531),
(57,'chocolate',2531),
(58,'strawberry',2531),
(59,'chocolate',2532),
(60,'vanilla',2533),
(61,'chocolate',2533),
(62,'vanilla',2534),
(63,'chocolate',2534),
(64,'vanilla',2535),
(65,'chocolate',2535),
(66,'vanilla',2536),
(67,'butter-pecan',2536),
(68,'rocky-road',2536),
(69,'vanilla',2537),
(70,'vanilla',2538),
(71,'chocolate',2538),
(72,'strawberry',2538),
(73,'vanilla',2548),
(74,'chocolate',2548),
(75,'strawberry',2548),
(76,'vanilla',2560),
(77,'chocolate',2560),
(78,'strawberry',2560),
(79,'Vanilla',2566),
(80,'Chocolate',2566),
(81,'Strawberry',2566),
(82,'Rocky Road',2566),
(83,'French Vanilla',2566),
(84,'Butter Pecan',2567),
(85,'Rocky Road',2567),
(86,'French vanilla',2567),
(87,'Chocolate',2568),
(88,'Chocolate Chip',2568),
(89,'Vanilla',2571),
(90,'Butter Pecan',2571),
(91,'Pistachio',2571),
(92,'Vanilla',2573),
(93,'Vanilla',2574);
UNLOCK TABLES;

--
-- Table structure for table 'cust_order2_topping'
--
DROP TABLE IF EXISTS 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=78 DEFAULT CHARSET=latin1;
--
-- Load data for table 'cust_order2_topping'
--
LOCK TABLES cust_order2_topping WRITE;
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),
(40,'hotFudge',21),
(41,'hotFudge',22),
(42,'hotFudge',23),
(43,'hotFudge',2524),
(44,'sprinkles',2524),
(45,'nuts',2525),
(46,'whippedCream',2525),
(47,'hotFudge',2526),
(48,'sprinkles',2526),
(49,'hotFudge',2527),
(50,'sprinkles',2527),
(51,'hotFudge',2528),
(52,'nuts',2528),
(53,'hotFudge',2529),
(54,'hotFudge',2530),
(55,'hotFudge',2531),
(56,'sprinkles',2531),
(57,'hotFudge',2532),
(58,'hotFudge',2533),
(59,'hotFudge',2534),
(60,'hotFudge',2535),
(61,'hotFudge',2536),
(62,'hotFudge',2537),
(63,'hotFudge',2538),
(64,'hotFudge',2548),
(65,'sprinkles',2548),
(66,'hotFudge',2560),
(67,'sprinkles',2560),
(68,'Hot Fudge',2566),
(69,'Sprinkles',2566),
(70,'Hot Fudge',2567),
(71,'Hot Fudge',2568),
(72,'Hot Fudge',2571),
(73,'Whipped Cream',2571),
(74,'Hot Fudge',2573),
(75,'Sprinkles',2574);
UNLOCK TABLES;

--
-- Table structure for table 'customer'
--
DROP TABLE IF EXISTS customer;
CREATE TABLE customer (
  cust_id   int(11)     NOT NULL AUTO_INCREMENT,
  user      varchar(20) NOT NULL,
  pswd      varchar(20) NOT NULL,
  fname     varchar(30) NOT NULL,
  lname     varchar(30) NOT NULL,
  address   varchar(99) NOT NULL,
  email     varchar(99) NOT NULL,
  phone     varchar(20) DEFAULT NULL,
  PRIMARY KEY (cust_id)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
--
-- Load data for table 'customer'
--
LOCK TABLES customer WRITE;
INSERT INTO customer VALUES 
(1,'sam','sam','Sam','Sultan','123 main Street\r\nNew York, NY 12345','sam.sultan@nyu.edu','(212) 123-1234'),
(2,'sam2','sam2','Samuel','Sultan','123 main street','x@x.com','123-123-1234');
UNLOCK TABLES;

--
-- Table structure for table 'customer2'
--
DROP TABLE IF EXISTS customer2;
CREATE TABLE customer2 (
  cust_id   int(11)     NOT NULL AUTO_INCREMENT,
  user      varchar(20) NOT NULL,
  pswd      varchar(20) NOT NULL,
  fname     varchar(20) NOT NULL,
  lname     varchar(20) NOT NULL,
  address   varchar(99) NOT NULL,
  phone     varchar(20) DEFAULT NULL,
  PRIMARY KEY (cust_id)
) AUTO_INCREMENT=125 DEFAULT CHARSET=latin1;
--
-- Load data for table 'customer2'
--
LOCK TABLES customer2 WRITE;
INSERT INTO customer2 VALUES 
(1,'sam','sam','Sam','Sultan','1234 Main Street','123-123-1234'),
(2,'Sexy','123456','Sexy','Chunky','Sexy Chunky Road\r\nSouth Beach, Florida 696969','123-453-8768'),
(6,'cc117','hihi','Cary','Chan','726 Broadway, Suite 352\r\nNew York, NY 10003','212-443-1047'),
(9,'sam2','sam2','Sam','Sultan','1234','123'),
(110,'ds','123','D','S','123','123'),
(19,'haider','haider','Hey','Me','12672st ','12435'),
(26,'wb2bwu','123','Jose','Berrios','wb2bwu@gmail.com','718-263-1455'),
(27,'yulke','yulke','Brian','Yulke','123 Road St\r\nTown, ST 01234','555-1212'),
(28,'dhill','sigma86','David','Hill','30 Amsterdam Ave\r\nNew York, NY 10040','917-529-2509'),
(103,'heyyo','heyyo','hey','yo','yoyoyo','heyheyhey'),
(32,'vishal','rewah','vishal','rewah','133-42 114th street ','347-255-3388'),
(33,'sita','princess','sita','mosodeen','10 astor','347-255-3446'),
(102,'psycynthia1996','1311PENG!sa','Penny','Peng','444 Washington Blvd., NJ','7323723455'),
(101,'han','han','han','han','han','999'),(40,'hill','hill','chas','hill','3521','646'),
(100,'sam9','sam9','Sam2','Sultan','1 Woolworth Building','123456789'),
(43,'john','john','John','Dunbar','1234 South Whatever\r\nRivington, Alaska','5555555555'),
(45,'789','marvin','Danny','Walls','1 Park Avenue','212-234-2123'),
(46,'00000','test','Marvin','Tee','233 Broadway','212-1231-12312'),
(99,'demodw','demodw','hjlkj','jh','hjl','hjh'),
(48,'12356','password1','s','par','123 Henry','203-000-0000'),
(98,'011','123','zhi','cong','d','5175180293'),
(97,'bc2771','shop','baihong','chen','25 river drive south','+1 6462045760'),
(96,'sam6','sam6','Sam','Sultan','123 Main Street\r\nNew York','123456789'),
(55,'Rocio','me','Same','Same','Address','111-111-1111'),
(56,'Id200','id200','Eric','Ericlname','Adresss','222-222-3333'),
(57,'JIHAE','123','JIHAE','CHUNG','NEW YORK','123456123'),
(58,'mahjouri','ssm55391','Saamahn','Mahjouri','853 7th Avenue','(612)581-8333'),
(95,'sam5','sam5','sam5','sultan','123 main street','1234'),
(94,'group3','puorg3','vicky','li','djakljle','7889732894'),
(93,'sam3','sam3','sam3','sultan','123','123-123-1234'),
(92,'ml6919','ml6919','Mian','Li','555 10th Ave','9293175065'),
(91,'zw2014','zw2014','zimo','wangliang','ooooooo','1111111'),
(73,'moi','ert','me','hu','330 E. 33rd street','2126893874'),
(76,'chen','chen','yang','chen','sdf','ds'),
(75,'yang','yang','yang','chen','123st','1232343456'),
(90,'group7','group7','group','7','group7','1234567890'),
(79,'samsam','samsam','sam','sultan','123 main street','123'),
(80,'yao','yao','yao','huang','1234 j st','123'),
(89,'yizhen','123456','yizhen','ning','888','6177847175'),
(82,'1111','123','Chuck','David','123 River Rd','999'),
(84,'song','song','123','123','123','123'),
(85,'yo526@nyu.edu','kindness','Yuta','Okazaki','11 42nd Street','9179410535'),
(86,'carol','carol','carol','cammero','abc','123'),
(88,'sam4','sam4','sam4','sultan','123 main street\r\nNew York','12345'),
(109,'11122','111','111','111','test_street','1111111111'),(108,'z','sam','x','q','q','q'),
(111,'nihao','nihao','nihao','nihao','df','12345'),
(112,'demo','1','sdf','sdf','sdfsdfsdfsdf','sdf'),
(113,'evelyn','e','evelyn','evelyn','e','evelyn'),
(114,'a','a','a','a','a','a'),
(115,'123','123','test','Li','6230 Acropolis Dr SE','5175180293'),
(116,'sam7','sam7','sam','sam','123 main street','1231231234'),
(117,'lala','lala','lala','la','la','la'),
(118,'goudi','123456','di','gou','123mainst','6462877336'),
(119,'1','frank','frank','zhang','2222','1111'),
(120,'dg3210','dg3210','di','gou','123','123456'),
(121,'1235','123','123','123','123','123'),
(122,'Zhehua','Zhehua','Zhehua','Zhehua','235 Grand Street\r\nAPT3006','6314287502'),
(123,'student','123','11','11','11','11'),(124,'fff','fff','fff','fff','235 grand','123444444');
UNLOCK TABLES;

--
-- Table structure for table 'generic_tbl'
--
DROP TABLE IF EXISTS generic_tbl;
CREATE TABLE generic_tbl (
  pk         int(11)      NOT NULL AUTO_INCREMENT,
  fname      varchar(20)  DEFAULT NULL,
  lname      varchar(20)  DEFAULT NULL,
  address    varchar(100) DEFAULT NULL,
  brand      varchar(50)  DEFAULT NULL,
  flavor     varchar(100) DEFAULT NULL,
  topping    varchar(100) DEFAULT NULL,
  creditcard varchar(50)  DEFAULT NULL,
  PRIMARY KEY (pk)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
--
-- Load data for table 'generic_tbl'
--
LOCK TABLES generic_tbl WRITE;
INSERT INTO generic_tbl VALUES 
(1,'sam','sultan','123 main street\r\nnew york','Ben & Jerry\"s','Chocolate,Strawberry,Butter Pecan','hotFudge,nuts','VISA'),
(2,'a','a','a','Basking-Robbins','Butter Pecan','hotFudge','MC'),
(3,'a','a','a','Basking-Robbins','Strawberry','hotFudge','MC'),
(4,'Sam','Sultan','123 main street\r\nnew york','Basking-Robbins','Butter Pecan,Rocky Road,French Vanilla','hotFudge,sprinkles','MC'),
(5,'Sam','Sultan','123 main street\r\nnew york','Basking-Robbins','Butter Pecan,Rocky Road,French Vanilla','hotFudge,sprinkles','MC'),
(6,'Sam ','Sultan','123 main street\r\nnew york','Ben & Jerry\"s','Strawberry,Butter Pecan','hotFudge,sprinkles','MC'),
(7,'Sam ','Sultan','123 main street\r\nnew york','Ben & Jerry\"s','Strawberry,Butter Pecan','hotFudge,sprinkles','MC'),
(8,'a','b','c','Basking-Robbins','Chocolate','hotFudge','MC'),
(9,'a','b','','Basking-Robbins','Chocolate','hotFudge','MC'),
(11,'xxx','yyy','zzz','Cold Stone','Chocolate,Strawberry,Butter Pecan','hotFudge,whippedCream','AMEX'),
(12,'1','1','1','Basking-Robbins','Strawberry','hotFudge','MC');
UNLOCK TABLES;

--
-- Table structure for table 'image'
--
DROP TABLE IF EXISTS 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)
) AUTO_INCREMENT=21 DEFAULT CHARSET=latin1;
--
-- Load data for table 'image'
--
LOCK TABLES image WRITE;
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');
UNLOCK TABLES;

--
-- Table structure for table 'java'
--
DROP TABLE IF EXISTS 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)
) AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;

--
-- Load data for table 'java'
--
LOCK TABLES java WRITE;
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'),
(6,'Brown','Jim','2011-07-26 16:23:39'),
(7,'Jones','Bill','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,'Lee','Bruce','2012-06-26 20:00:59'),
(22,'Jones','Tom','2015-07-24 23:04:36'),
(13,'Steel','Man','2013-06-09 23:33:04'),
(21,'Obama','Barak','2015-02-02 19:45:29'),
(15,'Lewis','Ray','2013-07-19 22:25:04'),
(16,'Etienne','Joseph','2014-06-24 18:06:25'),
(18,'sultan','sam','2015-02-02 17:50:00'),
(19,'last','first','2015-02-02 19:19:48'),
(31,'Smith','John','2020-11-19 02:34:41'),
(26,'swain','asa','2015-11-07 00:01:36'),
(27,'wade','linc','2015-11-07 00:17:14'),
(30,'Sultan','Sam','2020-11-18 22:28:45');
UNLOCK TABLES;

--
-- Table structure for table 'shop_cart'
--
DROP TABLE IF EXISTS shop_cart;
CREATE TABLE shop_cart (
  item_id   int(11)     NOT NULL AUTO_INCREMENT,
  cust_id   int(11)     NOT NULL,
  prod_id   int(11)     NOT NULL,
  prod_desc varchar(99) NOT NULL,
  type      varchar(25) NOT NULL,
  price     decimal(6,2) NOT NULL,
  qty       int(11)     NOT NULL,
  PRIMARY KEY (item_id)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=latin1;
--
-- Load data for table 'shop_cart'
--
LOCK TABLES shop_cart WRITE;
INSERT INTO shop_cart VALUES 
(37,1,1,'Vanilla','ice cream',2.50,1),
(38,0,1,'Vanilla','ice cream',2.50,1);
UNLOCK TABLES;

--
-- Table structure for table 'shop_customer'
--
DROP TABLE IF EXISTS shop_customer;
CREATE TABLE shop_customer (
  cust_id   int(11)     NOT NULL PRIMARY KEY,
  user      varchar(20) NOT NULL,
  pswd      varchar(20) NOT NULL,
  fname     varchar(30) NOT NULL,
  lname     varchar(30) NOT NULL,
  address   varchar(99) NOT NULL,
  email     varchar(99) NOT NULL,
  phone     varchar(20) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
--
-- Load data for table 'shop_customer'
--
LOCK TABLES shop_customer WRITE;
INSERT INTO shop_customer VALUES 
(1,'sam','sam','Sam','Sultan','123 main Street\r\nNew York, NY 12345','sam.sultan@nyu.edu','(212) 123-1234'),
(2,'sam2','sam2','Samuel','Sultan','123 main street','x@x.com','123-123-1234'),
(0,'test','123123','test','test','1234','test@gmail.com','123456');
UNLOCK TABLES;

--
-- Table structure for table 'shop_order'
--
DROP TABLE IF EXISTS shop_order;
CREATE TABLE shop_order (
  order_id      int(11)     NOT NULL AUTO_INCREMENT,
  cust_id       int(11)     NOT NULL,
  ship_fname    varchar(30) NOT NULL,
  ship_lname    varchar(30) NOT NULL,
  ship_addr     varchar(99) NOT NULL,
  ship_email    varchar(99) NOT NULL,
  credit_card   varchar(50) NOT NULL,
  order_date    timestamp   NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (order_id)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=latin1;
--
-- Load data for table 'shop_order'
--
LOCK TABLES shop_order WRITE;
INSERT INTO shop_order VALUES 
(1,1,'Sam','Sultan','123 main Street\r\nNew York, NY 12345','sam.sultan@nyu.edu','1234-1234-1234-1234','2021-01-03 23:04:14'),
(2,1,'Sam','Sultan','123 main Street\r\nNew York, NY 12345','sam.sultan@nyu.edu','1234-1234-1234-1234','2021-01-03 23:10:19'),
(3,2,'Samuel','Sultan','123 main street','x@x.com','4321-4321-4321-4321','2021-01-03 23:13:42'),
(4,1,'Sam','Sultan','123 main Street\r\nNew York, NY 12345','sam.sultan@nyu.edu','1234-1234-1234-1234','2021-01-03 23:15:40'),
(5,1,'Sam','Sultan','123 main Street\r\nNew York, NY 12345','sam.sultan@nyu.edu','1234-1234-1234-1234','2021-01-03 23:19:40'),
(6,1,'Sam','Sultan','123 main Street\r\nNew York, NY 12345','sam.sultan@nyu.edu','1234-1234-1234-1234','2021-01-03 23:20:50'),
(7,1,'Sam','Sultan','123 main Street\r\nNew York, NY 12345','sam.sultan@nyu.edu','1234-1234-1234-1234','2021-01-04 21:31:22'),
(8,1,'Sam','Sultan','123 main Street\r\nNew York, NY 12345','sam.sultan@nyu.edu','1111-2222-3333-1234','2021-01-08 19:37:36'),
(9,1,'Sam','Sultan','123 main Street\r\nNew York, NY 12345','sam.sultan@nyu.edu','4321-4321-4321-4321','2021-01-09 21:41:59'),
(10,1,'Sam','Sultan','123 main Street\r\nJersey City, NJ 12345','sam.sultan@nyu.edu','1111-2222-3333-4444','2021-01-10 02:23:03'),
(11,1,'Sam','Sultan','123 main Street\r\nJersey City, NJ 12345','sam.sultan@nyu.edu','1234-1234-1234-1234','2021-01-10 02:24:30'),
(12,1,'Sam','Sultan','123 main Street\r\nHoboken, NJ 12345','sam.sultan@nyu.edu','1234-1234-1234-1234','2021-01-10 02:39:53');
UNLOCK TABLES;

--
-- Table structure for table 'shop_order_detail'
--
DROP TABLE IF EXISTS shop_order_detail;
CREATE TABLE shop_order_detail (
  order_dtl_id  int(11)     NOT NULL AUTO_INCREMENT,
  order_id      int(11)     NOT NULL,
  prod_id       int(11)     NOT NULL,
  prod_desc     varchar(99) NOT NULL,
  type          varchar(25) NOT NULL,
  price         decimal(6,2) NOT NULL,
  qty           int(11)     NOT NULL,
  tax           decimal(6,3) NOT NULL,
  PRIMARY KEY (order_dtl_id)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
--
-- Load data for table 'shop_order_detail'
--
LOCK TABLES shop_order_detail WRITE;
INSERT INTO shop_order_detail VALUES 
(1,3,3,'Strawberry','ice cream',2.50,2,6.500),
(2,3,1,'Vanilla','ice cream',2.50,2,6.500),
(3,3,2,'Chocolate','ice cream',2.50,2,6.500),
(4,6,1,'Vanilla','ice cream',2.50,2,8.875),
(5,6,2,'Chocolate','ice cream',2.50,3,8.875),
(6,7,3,'Strawberry','ice cream',2.50,3,8.875),
(7,7,2,'Chocolate','ice cream',2.50,4,8.875),
(8,8,1,'Vanilla','ice cream',2.50,1,8.875),
(9,8,2,'Chocolate','ice cream',2.50,2,8.875),
(10,8,5,'Praline','ice cream',3.00,5,8.875),
(11,8,21,'Hot Fudge','topping',0.25,21,8.875),
(12,8,26,'Cherries','topping',0.25,26,8.875),
(13,8,27,'Hot Fudge Sunday','specialty',5.50,27,8.875),
(14,8,8,'Rocky Road','ice cream',3.00,8,8.875),
(15,9,21,'Hot Fudge','topping',0.25,1,8.875),
(16,9,23,'Sprinkles','topping',0.25,2,8.875),
(17,9,28,'Banana Split','specialty',6.25,2,8.875),
(18,9,1,'Vanilla','ice cream',2.50,3,8.875),
(19,10,1,'Vanilla','ice cream',2.50,1,6.625),
(20,10,2,'Chocolate','ice cream',2.50,2,6.625),
(21,10,25,'Whipped Cream','topping',0.25,1,6.625),
(22,10,7,'Coffee','ice cream',3.00,1,6.625),
(23,11,1,'Vanilla','ice cream',2.50,1,6.625),
(24,12,1,'Vanilla','ice cream',2.50,1,6.625);
UNLOCK TABLES;

--
-- Table structure for table 'shop_product'
--
DROP TABLE IF EXISTS shop_product;
CREATE TABLE shop_product (
  prod_id       int(11)     NOT NULL AUTO_INCREMENT,
  prod_desc     varchar(99) NOT NULL,
  prod_type     varchar(25) NOT NULL,
  prod_avail    char(1) NOT NULL,
  prod_price    decimal(6,2) NOT NULL,
  PRIMARY KEY (prod_id)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=latin1;
--
-- Load data for table 'shop_product'
--
LOCK TABLES shop_product WRITE;
INSERT INTO shop_product VALUES 
(1,'Vanilla','ice cream','Y',2.50),
(2,'Chocolate','ice cream','Y',2.50),
(3,'Strawberry','ice cream','Y',2.50),
(4,'Butter Pecan','ice cream','Y',3.00),
(5,'Praline','ice cream','Y',3.00),
(6,'Pistachio','ice cream','Y',3.00),
(7,'Coffee','ice cream','Y',3.00),
(8,'Rocky Road','ice cream','Y',3.00),
(9,'Cherry Jubilee','ice cream','Y',3.00),
(10,'French Vanilla','ice cream','N',3.00),
(11,'Chocolate Chip','ice cream','N',3.00),
(12,'Cookies & Cream','ice cream','N',3.00),
(13,'Double Chocolate','ice cream','N',3.50),
(14,'Chocolate Fudge','ice cream','N',3.50),
(15,'Almond Fudge','ice cream','N',3.00),
(16,'Peanut Butter','ice cream','N',3.00),
(17,'Nutty Coconut','ice cream','N',3.00),
(18,'Rainbow Sherbet','ice cream','Y',2.75),
(19,'Orange Sherbet','ice cream','N',2.75),
(20,'Lemon Sherbet','ice cream','N',2.75),
(21,'Hot Fudge','topping','Y',0.25),
(22,'Caramel','topping','Y',0.25),
(23,'Sprinkles','topping','Y',0.25),
(24,'Nuts','topping','Y',0.25),
(25,'Whipped Cream','topping','Y',0.25),
(26,'Cherries','topping','Y',0.25),
(27,'Hot Fudge Sunday','specialty','Y',5.50),
(28,'Banana Split','specialty','Y',6.25),
(29,'Waffle Cone','specialty','Y',0.75),
(30,'Ice Cream Cake','specialty','N',21.50);
UNLOCK TABLES;

--
-- Table structure for table 'shopcart'
--
DROP TABLE IF EXISTS shopcart;
CREATE TABLE shopcart (
  owner     varchar(20)  NOT NULL,
  content   varchar(250) DEFAULT NULL,
  PRIMARY KEY (owner)
) DEFAULT CHARSET=latin1;
--
-- Load data for table 'shopcart'
--
LOCK TABLES shopcart WRITE;
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|'),
('85','Shirt:x_small,white,1,34.99|');
UNLOCK TABLES;

--
-- Table structure for table 'page_tracker'
--
DROP TABLE IF EXISTS page_tracker;
CREATE TABLE page_tracker (
  prim_key          int(11) NOT NULL AUTO_INCREMENT,
  site_id           varchar(10)         DEFAULT NULL,
  date_time         timestamp NOT NULL  DEFAULT CURRENT_TIMESTAMP,
  requesting_page   varchar(250)        DEFAULT NULL,
  request_method    varchar(10)         DEFAULT NULL,
  requested_url     varchar(250)        DEFAULT NULL,
  action            varchar(10)         DEFAULT NULL,
  ad_name           varchar(250)        DEFAULT NULL,
  query_string      varchar(1000)       DEFAULT NULL,
  client_host       varchar(250)        DEFAULT NULL,
  client_ip         varchar(30)         DEFAULT NULL,
  client_port       varchar(5)          DEFAULT NULL,
  client_user       varchar(250)        DEFAULT NULL,
  server_host       varchar(250)        DEFAULT NULL,
  server_ip         varchar(30)         DEFAULT NULL,
  server_port       varchar(5)          DEFAULT NULL,
  server_protocol   varchar(250)        DEFAULT NULL,
  server_software   varchar(250)        DEFAULT NULL,
  document_root     varchar(250)        DEFAULT NULL,
  http_referer      varchar(1000)       DEFAULT NULL,
  http_user_agent   varchar(1000)       DEFAULT NULL,
  http_host         varchar(250)        DEFAULT NULL,
  http_connection   varchar(250)        DEFAULT NULL,
  https             varchar(250)        DEFAULT NULL,
  auth_type         varchar(250)        DEFAULT NULL,
  auth_user         varchar(250)        DEFAULT NULL,
  auth_pswd         varchar(250)        DEFAULT NULL,
  script_filename   varchar(250)        DEFAULT NULL,
  path_translated   varchar(250)        DEFAULT NULL,
  path_info         varchar(250)        DEFAULT NULL,
  request_time      varchar(250)        DEFAULT NULL,
  get_array         varchar(5000)       DEFAULT NULL,
  post_array        varchar(5000)       DEFAULT NULL,
  cookies           varchar(5000)       DEFAULT NULL,
  PRIMARY KEY (prim_key)
) ENGINE=InnoDB AUTO_INCREMENT=2932 DEFAULT CHARSET=latin1;
--
-- Load data for table 'page_tracker'
--
LOCK TABLES page_tracker WRITE;
-- INSERT INTO page_tracker VALUES (...) 
UNLOCK TABLES;

--
-- Table structure for table 'web_date'
--
DROP TABLE IF EXISTS web_date;
CREATE TABLE web_date (
  date_id   int(11)     NOT NULL AUTO_INCREMENT,
  date      datetime    DEFAULT NULL,
  date_mth  varchar(15) DEFAULT NULL,
  date_day  varchar(15) DEFAULT NULL,
  date_yyyy char(4)     DEFAULT NULL,
  date_mm   char(2)     DEFAULT NULL,
  date_dd   char(2)     DEFAULT NULL,
  PRIMARY KEY (date_id)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
--
-- Load data for table 'web_date'
--
LOCK TABLES web_date WRITE;
INSERT INTO web_date VALUES (1,'2021-03-15 00:00:00','March','Monday','2021','03','15'),(2,'2021-03-16 00:00:00','March','Tuesday','2021','03','16'),(3,'2021-03-17 00:00:00','March','Wednesday','2021','03','17'),(4,'2021-03-18 00:00:00','March','Thursday','2021','03','18'),(5,'2021-03-19 00:00:00','March','Friday','2021','03','19'),(6,'2021-03-20 00:00:00','March','Saturday','2021','03','20'),(7,'2021-03-21 00:00:00','March','Sunday','2021','03','21'),(8,'2021-03-22 00:00:00','March','Monday','2021','03','22'),(9,'2021-03-23 00:00:00','March','Tuesday','2021','03','23'),(10,'2021-03-24 00:00:00','March','Wednesday','2021','03','24'),(11,'2021-03-25 00:00:00','March','Thursday','2021','03','25'),(12,'2021-03-26 00:00:00','March','Friday','2021','03','26'),(13,'2021-03-27 00:00:00','March','Saturday','2021','03','27'),(14,'2021-03-28 00:00:00','March','Sunday','2021','03','28'),(15,'2021-03-29 00:00:00','March','Monday','2021','03','29'),(16,'2021-03-30 00:00:00','March','Tuesday','2021','03','30'),(17,'2021-03-31 00:00:00','March','Wednesday','2021','03','31');
UNLOCK TABLES;

--
-- Table structure for table 'web_user'
--
DROP TABLE IF EXISTS web_user;
CREATE TABLE web_user (
  user_id   int(11)     NOT NULL AUTO_INCREMENT,
  client_ip varchar(15) DEFAULT NULL,
  PRIMARY KEY (user_id)
) ENGINE=InnoDB AUTO_INCREMENT=2192 DEFAULT CHARSET=latin1;
--
-- Load data for table 'web_user'
--
LOCK TABLES web_user WRITE;
INSERT INTO web_user VALUES (1,'66.249.66.218'),(2,'34.77.162.29'),(3,'102.184.143.226'),(4,'40.77.167.60'),(5,'157.55.39.50'),(6,'17.58.101.190'),(7,'17.58.99.163'),(8,'157.55.39.46'),(9,'34.77.162.10'),(10,'66.249.66.220'),(11,'106.75.181.78'),(12,'185.191.171.5'),(13,'157.55.39.28'),(14,'192.241.228.139'),(15,'185.191.171.8'),(16,'40.77.167.59'),(17,'66.249.66.216'),(18,'13.66.139.2'),(19,'66.249.66.76'),(20,'157.55.39.75'),(21,'40.77.167.93'),(22,'14.180.216.56'),(23,'157.55.39.130'),(24,'185.191.171.3'),(25,'185.191.171.40'),(26,'185.191.171.42'),(27,'77.88.5.228'),(28,'191.102.188.155'),(29,'196.240.249.233'),(30,'185.191.171.20'),(31,'185.191.171.45'),(32,'220.181.108.161'),(33,'100.8.74.177'),(34,'13.66.139.38'),(35,'54.36.148.128'),(36,'40.77.167.27'),(37,'193.118.53.210'),(38,'193.138.218.224'),(39,'34.227.66.254'),(40,'24.205.144.249'),(41,'185.191.171.44'),(42,'185.191.171.26'),(43,'66.249.66.78'),(44,'66.249.66.77'),(45,'51.89.207.171'),(46,'40.77.167.35'),(47,'23.129.64.227'),(48,'185.191.171.37'),(49,'185.191.171.15'),(50,'37.200.77.252'),(51,'40.77.189.123'),(52,'40.77.188.114'),(53,'40.77.188.229'),(54,'40.77.188.142'),(55,'157.55.39.7'),(56,'185.191.171.24'),(57,'42.6.110.217'),(58,'185.191.171.18'),(59,'107.158.32.39'),(60,'185.191.171.11'),(61,'185.191.171.34'),(62,'185.191.171.43'),(63,'185.191.171.39'),(64,'66.249.93.43'),(65,'36.37.124.100'),(66,'104.223.33.22'),(67,'77.88.5.26'),(68,'185.191.171.14'),(69,'5.253.19.12'),(70,'201.157.202.222'),(71,'176.120.201.17'),(72,'116.139.203.247'),(73,'185.191.171.38'),(74,'157.55.39.106'),(75,'185.191.171.12'),(76,'185.191.171.9'),(77,'185.191.171.23'),(78,'116.179.32.159'),(79,'51.15.27.133'),(80,'13.66.139.117'),(81,'104.248.129.254'),(82,'85.208.98.24'),(83,'185.191.171.41'),(84,'85.208.98.23'),(85,'85.208.98.22'),(86,'178.150.47.62'),(87,'193.142.146.202'),(88,'88.198.36.62'),(89,'144.76.102.243'),(90,'185.191.171.6'),(91,'192.95.42.42'),(92,'128.141.191.50'),(93,'3.235.226.0'),(94,'216.244.66.238'),(95,'13.66.139.115'),(96,'182.119.224.147'),(97,'93.158.161.11'),(98,'192.210.194.146'),(99,'35.222.2.248'),(100,'223.185.136.72'),(101,'185.191.171.1'),(102,'52.87.186.233'),(103,'185.191.171.13'),(104,'54.202.46.219'),(105,'24.45.40.56'),(106,'62.171.188.63'),(107,'185.191.171.22'),(108,'103.206.31.2'),(109,'66.102.8.128'),(110,'185.191.171.35'),(111,'100.38.3.246'),(112,'212.8.246.122'),(113,'185.191.171.17'),(114,'185.191.171.16'),(115,'148.75.230.236'),(116,'103.131.71.61'),(117,'167.71.68.203'),(118,'193.112.94.225'),(119,'54.36.148.217'),(120,'35.197.17.152'),(121,'185.191.171.4'),(122,'193.46.254.25'),(123,'197.46.230.181'),(124,'185.191.171.2'),(125,'194.87.54.32'),(126,'71.190.62.253'),(127,'40.77.167.16'),(128,'185.191.171.10'),(129,'192.241.226.135'),(130,'107.158.85.138'),(131,'100.1.17.212'),(132,'69.171.251.8'),(133,'185.191.171.33'),(134,'39.103.181.213'),(135,'116.179.32.31'),(136,'103.131.71.19'),(137,'103.131.71.34'),(138,'192.241.224.252'),(139,'185.191.171.36'),(140,'49.212.157.242'),(141,'51.11.229.77'),(142,'149.3.170.66'),(143,'65.78.9.252'),(144,'40.88.21.235'),(145,'116.179.32.211'),(146,'205.185.122.102'),(147,'123.189.91.193'),(148,'54.71.68.123'),(149,'125.135.64.13'),(150,'69.113.184.33'),(151,'162.93.65.8'),(152,'216.218.206.68'),(153,'136.56.73.211'),(154,'181.215.28.131'),(155,'3.227.243.187'),(156,'185.191.171.19'),(157,'45.146.165.157'),(158,'157.55.39.203'),(159,'73.53.4.78'),(160,'74.125.212.252'),(161,'74.125.212.224'),(162,'66.114.16.96'),(163,'213.238.182.236'),(164,'66.249.64.154'),(165,'168.232.14.90'),(166,'66.249.64.152'),(167,'66.249.64.156'),(168,'150.108.240.143'),(169,'185.191.171.7'),(170,'109.94.119.6'),(171,'40.77.188.63'),(172,'66.249.64.16'),(173,'23.94.229.248'),(174,'66.249.64.17'),(175,'64.233.173.93'),(176,'64.233.173.64'),(177,'34.207.235.152'),(178,'185.191.171.21'),(179,'60.8.151.237'),(180,'60.8.151.241'),(181,'185.191.171.25'),(182,'62.210.119.157'),(183,'66.249.64.18'),(184,'46.105.85.31'),(185,'69.248.163.93'),(186,'67.245.31.115'),(187,'148.252.128.207'),(188,'93.158.161.36'),(189,'185.59.246.14'),(190,'35.165.39.38'),(191,'45.72.61.213'),(192,'77.88.5.142'),(193,'85.208.98.18'),(194,'85.208.98.19'),(195,'85.208.98.16'),(196,'85.208.98.20'),(197,'66.249.80.155'),(198,'96.238.35.61'),(199,'46.101.40.17'),(200,'67.83.17.141'),(201,'191.215.183.162'),(202,'74.101.201.111'),(203,'45.15.143.141'),(204,'204.14.37.34'),(205,'128.14.141.75'),(206,'180.163.220.3'),(207,'180.163.220.68'),(208,'180.163.220.5'),(209,'180.163.220.67'),(210,'27.115.124.70'),(211,'27.115.124.38'),(212,'73.160.82.78'),(213,'66.249.88.189'),(214,'66.249.88.191'),(215,'220.181.108.91'),(216,'103.131.71.67'),(217,'103.131.71.62'),(218,'13.66.139.90'),(219,'173.68.207.243'),(220,'116.179.32.78'),(221,'35.163.216.132'),(222,'94.155.33.26'),(223,'151.237.186.10'),(224,'27.0.28.133'),(225,'192.0.102.24'),(226,'180.163.220.95'),(227,'180.163.220.42'),(228,'42.236.10.88'),(229,'118.33.239.181'),(230,'37.49.225.131'),(231,'66.249.80.159'),(232,'172.104.193.53'),(233,'185.63.190.228'),(234,'62.4.29.77'),(235,'103.220.207.242'),(236,'193.110.202.150'),(237,'154.160.22.36'),(238,'118.121.119.134'),(239,'66.102.8.159'),(240,'40.77.188.198'),(241,'36.110.199.47'),(242,'193.118.53.194'),(243,'116.179.32.225'),(244,'66.249.88.140'),(245,'54.213.36.204'),(246,'34.77.162.8'),(247,'91.39.56.185'),(248,'92.118.161.49'),(249,'75.80.108.160'),(250,'116.179.32.89'),(251,'111.125.82.204'),(252,'5.188.48.34'),(253,'64.251.14.67'),(254,'178.73.215.171'),(255,'144.172.68.48'),(256,'35.233.212.203'),(257,'45.144.225.78'),(258,'64.233.173.95'),(259,'24.97.110.218'),(260,'178.63.51.106'),(261,'109.87.44.14'),(262,'37.204.254.39'),(263,'151.245.85.103'),(264,'185.142.236.43'),(265,'34.78.227.165'),(266,'44.227.133.159'),(267,'95.82.135.105'),(268,'23.92.125.84'),(269,'188.187.84.147'),(270,'66.249.64.130'),(271,'178.159.37.104'),(272,'123.126.68.113'),(273,'172.105.89.161'),(274,'192.35.168.144'),(275,'27.128.230.74'),(276,'5.62.61.9'),(277,'34.123.189.138'),(278,'184.72.168.41'),(279,'116.179.32.91'),(280,'116.179.32.216'),(281,'45.125.245.133'),(282,'45.88.3.90'),(283,'85.208.98.17'),(284,'220.181.108.187'),(285,'116.179.32.142'),(286,'18.231.94.162'),(287,'101.228.83.189'),(288,'172.245.60.137'),(289,'200.53.20.115'),(290,'52.255.159.55'),(291,'113.87.182.40'),(292,'103.131.71.23'),(293,'103.131.71.22'),(294,'118.174.232.60'),(295,'192.241.220.208'),(296,'5.34.180.192'),(297,'105.184.95.33'),(298,'38.94.109.221'),(299,'81.28.193.236'),(300,'23.231.37.49'),(301,'150.108.240.159'),(302,'60.8.123.97'),(303,'38.94.109.195'),(304,'162.83.179.154'),(305,'68.56.64.71'),(306,'66.249.64.158'),(307,'79.3.96.106'),(308,'45.56.154.210'),(309,'5.235.226.55'),(310,'96.246.190.172'),(311,'54.36.148.227'),(312,'67.86.140.206'),(313,'157.55.39.33'),(314,'44.192.42.100'),(315,'2.57.122.97'),(316,'119.52.94.176'),(317,'139.214.90.98'),(318,'139.211.101.5'),(319,'96.239.24.9'),(320,'139.162.106.181'),(321,'60.8.151.71'),(322,'65.49.20.69'),(323,'157.55.39.160'),(324,'13.82.231.120'),(325,'185.200.212.101'),(326,'115.150.22.29'),(327,'103.131.71.60'),(328,'103.131.71.70'),(329,'34.82.7.32'),(330,'144.76.68.124'),(331,'104.236.212.203'),(332,'66.102.8.157'),(333,'23.111.151.138'),(334,'86.198.138.107'),(335,'185.189.182.234'),(336,'107.13.65.100'),(337,'193.70.33.60'),(338,'157.55.39.68'),(339,'178.69.26.164'),(340,'80.234.34.116'),(341,'54.36.148.66'),(342,'66.249.83.1'),(343,'96.242.171.107'),(344,'141.126.229.39'),(345,'175.147.50.241'),(346,'67.250.29.144'),(347,'103.131.71.64'),(348,'72.227.158.183'),(349,'180.252.61.205'),(350,'128.14.209.242'),(351,'66.249.73.165'),(352,'66.108.42.109'),(353,'66.249.73.162'),(354,'157.90.160.102'),(355,'66.249.73.166'),(356,'81.107.152.153'),(357,'98.234.247.227'),(358,'47.92.54.162'),(359,'196.242.178.43'),(360,'40.77.188.86'),(361,'40.77.188.133'),(362,'40.77.188.224'),(363,'66.249.93.47'),(364,'179.61.184.222'),(365,'72.89.254.246'),(366,'66.249.93.45'),(367,'192.241.227.144'),(368,'81.162.123.233'),(369,'183.216.214.168'),(370,'183.217.232.73'),(371,'94.73.22.236'),(372,'74.64.166.221'),(373,'113.96.232.118'),(374,'46.29.254.222'),(375,'135.0.176.119'),(376,'66.249.73.184'),(377,'100.35.67.229'),(378,'112.156.52.239'),(379,'66.249.65.222'),(380,'66.249.65.221'),(381,'134.209.70.240'),(382,'168.63.232.177'),(383,'174.52.243.13'),(384,'54.176.188.51'),(385,'178.79.190.195'),(386,'27.147.143.186'),(387,'222.186.136.150'),(388,'69.206.243.140'),(389,'66.249.65.223'),(390,'74.120.14.55'),(391,'167.248.133.56'),(392,'128.14.134.134'),(393,'66.65.155.252'),(394,'40.77.190.80'),(395,'212.33.244.98'),(396,'121.4.254.238'),(397,'123.189.89.111'),(398,'202.83.161.130'),(399,'190.94.138.49'),(400,'71.230.208.149'),(401,'13.66.139.1'),(402,'13.66.139.0'),(403,'3.93.12.52'),(404,'116.179.32.95'),(405,'95.165.168.53'),(406,'84.20.68.206'),(407,'103.101.68.14'),(408,'202.14.4.188'),(409,'88.198.90.9'),(410,'76.116.152.177'),(411,'45.5.66.117'),(412,'34.221.233.109'),(413,'96.126.103.73'),(414,'23.90.31.70'),(415,'220.135.22.1'),(416,'37.229.255.32'),(417,'35.230.56.66'),(418,'222.188.156.184'),(419,'185.173.35.5'),(420,'188.208.211.36'),(421,'186.33.125.245'),(422,'181.10.230.100'),(423,'66.249.73.190'),(424,'95.154.221.72'),(425,'123.58.117.233'),(426,'72.179.171.226'),(427,'51.254.59.113'),(428,'71.6.232.4'),(429,'173.56.38.162'),(430,'174.215.145.160'),(431,'114.244.12.78'),(432,'13.66.139.98'),(433,'17.58.98.91'),(434,'17.58.99.173'),(435,'17.58.99.174'),(436,'17.58.99.180'),(437,'17.58.99.187'),(438,'221.133.9.1'),(439,'37.232.133.3'),(440,'116.179.32.148'),(441,'103.131.71.20'),(442,'40.77.190.64'),(443,'40.77.188.171'),(444,'40.77.189.51'),(445,'40.77.190.222'),(446,'40.77.188.182'),(447,'105.235.128.241'),(448,'101.32.126.96'),(449,'212.252.83.80'),(450,'103.131.71.56'),(451,'107.172.229.57'),(452,'101.32.114.41'),(453,'220.181.108.139'),(454,'66.249.82.75'),(455,'78.188.24.146'),(456,'108.165.192.217'),(457,'13.66.139.22'),(458,'149.129.50.37'),(459,'41.191.101.8'),(460,'74.125.209.1'),(461,'74.125.209.29'),(462,'104.129.15.150'),(463,'180.163.220.126'),(464,'163.53.204.182'),(465,'157.230.182.62'),(466,'13.66.139.50'),(467,'180.163.220.4'),(468,'180.163.220.66'),(469,'54.36.148.133'),(470,'207.172.168.240'),(471,'103.131.71.66'),(472,'49.36.160.104'),(473,'221.202.168.254'),(474,'68.187.64.2'),(475,'173.252.95.119'),(476,'135.125.112.125'),(477,'100.8.92.39'),(478,'103.159.45.89'),(479,'95.163.255.219'),(480,'95.163.255.212'),(481,'192.154.116.202'),(482,'23.129.64.204'),(483,'175.147.109.108'),(484,'74.207.244.243'),(485,'101.91.60.109'),(486,'220.181.108.175'),(487,'189.107.203.124'),(488,'95.163.255.122'),(489,'95.163.255.225'),(490,'66.249.81.95'),(491,'66.249.64.64'),(492,'66.249.64.94'),(493,'66.249.64.235'),(494,'82.147.220.206'),(495,'66.249.64.237'),(496,'24.218.71.8'),(497,'34.83.174.140'),(498,'121.4.250.220'),(499,'66.249.64.233'),(500,'71.105.206.100'),(501,'66.249.64.95'),(502,'192.99.15.222'),(503,'175.147.111.122'),(504,'94.10.166.199'),(505,'194.124.159.182'),(506,'116.179.32.93'),(507,'54.36.149.44'),(508,'192.241.226.227'),(509,'39.82.249.169'),(510,'20.191.45.212'),(511,'27.5.43.77'),(512,'222.188.156.220'),(513,'222.66.96.130'),(514,'162.142.125.56'),(515,'183.36.112.205'),(516,'171.111.86.126'),(517,'107.15.156.118'),(518,'58.34.34.251'),(519,'220.181.108.171'),(520,'116.179.32.138'),(521,'111.206.198.72'),(522,'111.206.221.50'),(523,'111.206.221.38'),(524,'111.206.198.91'),(525,'111.206.198.90'),(526,'111.206.198.16'),(527,'111.206.198.37'),(528,'111.206.198.120'),(529,'111.206.198.11'),(530,'111.206.221.110'),(531,'111.206.221.5'),(532,'111.206.221.31'),(533,'111.206.198.87'),(534,'111.206.198.94'),(535,'111.206.198.35'),(536,'111.206.198.116'),(537,'119.39.46.111'),(538,'111.206.221.33'),(539,'111.206.221.2'),(540,'111.206.221.47'),(541,'111.206.221.104'),(542,'111.206.198.50'),(543,'111.206.221.76'),(544,'111.206.198.109'),(545,'111.206.221.96'),(546,'111.206.198.117'),(547,'111.206.198.40'),(548,'111.206.198.107'),(549,'111.206.221.10'),(550,'111.206.198.108'),(551,'36.5.71.97'),(552,'110.177.178.41'),(553,'60.25.68.126'),(554,'1.202.112.123'),(555,'223.166.74.9'),(556,'120.85.111.87'),(557,'221.13.12.177'),(558,'36.106.167.15'),(559,'110.177.183.182'),(560,'124.227.31.100'),(561,'100.38.27.70'),(562,'103.73.35.90'),(563,'192.241.229.45'),(564,'74.108.36.30'),(565,'23.231.37.23'),(566,'220.181.108.107'),(567,'123.125.67.162'),(568,'66.249.82.191'),(569,'93.158.161.37'),(570,'77.88.5.120'),(571,'81.5.201.197'),(572,'220.181.108.156'),(573,'218.148.52.90'),(574,'157.55.39.224'),(575,'175.210.219.174'),(576,'95.163.255.235'),(577,'95.163.255.215'),(578,'78.46.161.81'),(579,'159.65.2.132'),(580,'92.245.175.39'),(581,'103.131.71.24'),(582,'40.77.167.76'),(583,'220.181.108.122'),(584,'119.15.83.197'),(585,'66.249.64.91'),(586,'103.145.13.24'),(587,'51.77.94.191'),(588,'103.131.71.54'),(589,'178.159.37.58'),(590,'95.163.255.236'),(591,'95.163.255.123'),(592,'175.140.211.238'),(593,'62.149.141.117'),(594,'223.247.154.173'),(595,'85.208.98.21'),(596,'128.199.155.13'),(597,'24.184.98.139'),(598,'160.39.18.37'),(599,'67.87.241.106'),(600,'139.162.1.149'),(601,'192.241.224.12'),(602,'71.183.216.142'),(603,'3.0.78.231'),(604,'69.122.37.105'),(605,'163.53.150.146'),(606,'192.241.226.178'),(607,'45.56.110.79'),(608,'193.142.146.42'),(609,'143.110.253.172'),(610,'74.82.47.2'),(611,'185.102.217.160'),(612,'95.163.255.223'),(613,'95.163.255.203'),(614,'61.129.6.251'),(615,'61.129.6.225'),(616,'61.129.6.145'),(617,'101.89.239.120'),(618,'101.89.239.216'),(619,'184.153.116.16'),(620,'15.161.120.69'),(621,'170.238.149.163'),(622,'76.22.23.26'),(623,'168.232.13.147'),(624,'150.108.240.99'),(625,'116.179.32.86'),(626,'72.88.137.43'),(627,'168.235.197.215'),(628,'61.129.6.203'),(629,'152.57.235.108'),(630,'157.55.39.200'),(631,'134.122.64.83'),(632,'170.254.73.134'),(633,'91.92.24.61'),(634,'45.125.245.238'),(635,'205.185.223.3'),(636,'76.102.109.69'),(637,'42.3.27.203'),(638,'61.151.178.197'),(639,'45.118.134.134'),(640,'69.112.166.86'),(641,'164.68.143.135'),(642,'74.125.212.254'),(643,'14.102.188.249'),(644,'101.89.239.230'),(645,'190.238.123.244'),(646,'88.5.237.10'),(647,'167.99.151.56'),(648,'116.179.32.81'),(649,'54.36.149.105'),(650,'34.77.162.6'),(651,'120.52.152.3'),(652,'40.77.188.29'),(653,'40.77.189.41'),(654,'40.77.188.194'),(655,'40.77.188.216'),(656,'40.77.191.4'),(657,'40.77.188.112'),(658,'40.77.188.233'),(659,'40.77.188.168'),(660,'68.129.237.176'),(661,'139.162.15.163'),(662,'212.111.40.161'),(663,'34.201.27.150'),(664,'66.249.82.160'),(665,'66.249.82.77'),(666,'72.89.176.60'),(667,'103.18.109.162'),(668,'46.163.144.139'),(669,'132.181.70.182'),(670,'187.190.215.35'),(671,'67.254.248.215'),(672,'116.213.43.238'),(673,'45.134.225.209'),(674,'66.249.72.88'),(675,'66.249.72.247'),(676,'47.22.181.187'),(677,'35.187.168.72'),(678,'66.249.72.251'),(679,'66.249.69.206'),(680,'66.249.69.202'),(681,'119.29.54.149'),(682,'110.177.179.33'),(683,'221.13.12.220'),(684,'220.200.167.148'),(685,'1.202.114.214'),(686,'221.213.75.154'),(687,'221.11.20.174'),(688,'36.106.166.112'),(689,'60.13.136.62'),(690,'61.52.81.47'),(691,'120.85.111.100'),(692,'113.128.105.128'),(693,'103.151.124.154'),(694,'66.249.69.204'),(695,'101.89.29.92'),(696,'95.163.255.204'),(697,'95.163.255.17'),(698,'27.69.7.150'),(699,'23.106.196.7'),(700,'100.33.123.86'),(701,'66.249.72.249'),(702,'220.181.108.108'),(703,'47.254.179.226'),(704,'196.2.9.9'),(705,'45.144.225.87'),(706,'54.36.148.92'),(707,'40.114.38.21'),(708,'65.141.6.170'),(709,'123.126.68.128'),(710,'116.179.32.42'),(711,'18.215.63.162'),(712,'123.189.94.238'),(713,'5.62.34.47'),(714,'95.163.255.238'),(715,'95.163.255.224'),(716,'95.163.255.220'),(717,'213.55.95.170'),(718,'196.240.237.149'),(719,'54.146.72.253'),(720,'95.163.255.1'),(721,'103.88.46.33'),(722,'143.110.213.101'),(723,'103.131.71.35'),(724,'103.131.71.30'),(725,'103.131.71.25'),(726,'95.163.255.214'),(727,'95.163.255.209'),(728,'80.249.150.185'),(729,'67.195.161.238'),(730,'103.131.71.65'),(731,'74.82.47.3'),(732,'121.4.254.41'),(733,'66.102.9.93'),(734,'5.173.137.160'),(735,'220.181.108.184'),(736,'73.73.47.60'),(737,'189.157.198.246'),(738,'220.181.108.173'),(739,'220.181.108.160'),(740,'182.69.144.84'),(741,'66.102.9.64'),(742,'35.194.87.72'),(743,'111.37.19.238'),(744,'44.227.103.78'),(745,'154.47.130.166'),(746,'192.241.221.108'),(747,'195.123.209.118'),(748,'34.107.39.157'),(749,'98.14.82.13'),(750,'113.118.187.246'),(751,'18.221.126.147'),(752,'193.118.53.202'),(753,'68.195.54.133'),(754,'66.249.82.111'),(755,'15.165.208.47'),(756,'157.55.39.253'),(757,'69.115.229.226'),(758,'74.125.209.31'),(759,'192.241.226.62'),(760,'66.102.8.221'),(761,'216.255.127.211'),(762,'170.24.144.102'),(763,'35.197.38.164'),(764,'89.46.105.195'),(765,'84.81.60.120'),(766,'188.163.35.42'),(767,'165.22.72.71'),(768,'198.199.88.9'),(769,'173.2.28.25'),(770,'54.36.148.48'),(771,'5.188.210.18'),(772,'162.142.125.39'),(773,'34.83.84.109'),(774,'3.129.64.83'),(775,'195.58.227.74'),(776,'186.211.9.137'),(777,'68.190.108.152'),(778,'194.147.140.4'),(779,'73.160.192.245'),(780,'47.57.182.186'),(781,'173.71.211.201'),(782,'81.158.34.157'),(783,'47.57.182.146'),(784,'120.79.13.158'),(785,'14.104.204.119'),(786,'34.77.162.11'),(787,'94.181.74.39'),(788,'101.89.29.78'),(789,'66.249.83.29'),(790,'66.225.101.6'),(791,'160.202.38.222'),(792,'103.41.25.126'),(793,'172.117.191.126'),(794,'69.203.149.115'),(795,'49.7.21.129'),(796,'182.245.71.238'),(797,'124.156.64.88'),(798,'176.9.47.122'),(799,'42.6.204.96'),(800,'103.131.71.69'),(801,'193.22.84.86'),(802,'116.179.32.168'),(803,'220.181.108.163'),(804,'116.179.32.227'),(805,'220.181.108.172'),(806,'8.47.64.2'),(807,'150.158.170.238'),(808,'139.224.197.133'),(809,'54.36.148.172'),(810,'180.164.186.221'),(811,'113.89.239.237'),(812,'94.181.72.130'),(813,'45.186.248.132'),(814,'95.163.255.202'),(815,'95.163.255.237'),(816,'164.52.24.163'),(817,'129.213.44.208'),(818,'217.182.253.190'),(819,'18.217.69.99'),(820,'95.163.255.0'),(821,'36.90.42.210'),(822,'217.160.60.212'),(823,'81.28.193.245'),(824,'136.55.160.70'),(825,'103.131.71.59'),(826,'78.46.94.83'),(827,'148.251.50.77'),(828,'95.163.255.213'),(829,'37.37.129.126'),(830,'104.244.72.115'),(831,'191.102.182.177'),(832,'1.192.192.6'),(833,'35.233.187.182'),(834,'65.49.20.68'),(835,'203.203.49.216'),(836,'42.236.10.81'),(837,'42.236.10.91'),(838,'181.215.157.152'),(839,'124.239.150.107'),(840,'43.230.196.54'),(841,'74.88.206.193'),(842,'95.163.255.231'),(843,'95.163.255.234'),(844,'38.94.109.39'),(845,'101.88.156.209'),(846,'107.158.32.82'),(847,'17.58.99.188'),(848,'17.58.99.18'),(849,'116.179.32.136'),(850,'173.252.111.12'),(851,'173.252.111.120'),(852,'31.167.109.189'),(853,'34.203.210.177'),(854,'66.249.64.92'),(855,'168.119.11.187'),(856,'94.159.52.190'),(857,'98.113.217.236'),(858,'47.18.199.117'),(859,'116.179.32.207'),(860,'95.163.255.227'),(861,'95.163.255.200'),(862,'62.234.6.68'),(863,'95.163.255.229'),(864,'95.163.255.217'),(865,'112.198.166.124'),(866,'66.102.8.219'),(867,'194.187.171.105'),(868,'194.187.171.156'),(869,'114.244.4.118'),(870,'123.183.224.119'),(871,'42.6.110.226'),(872,'192.241.228.65'),(873,'61.129.6.227'),(874,'102.23.146.165'),(875,'104.206.128.58'),(876,'23.83.87.189'),(877,'54.36.149.57'),(878,'189.252.216.28'),(879,'103.131.71.71'),(880,'192.241.228.232'),(881,'23.83.87.97'),(882,'51.39.11.159'),(883,'220.181.108.82'),(884,'76.69.154.133'),(885,'123.189.91.160'),(886,'74.120.14.53'),(887,'98.223.25.238'),(888,'173.234.25.210'),(889,'220.181.108.147'),(890,'95.163.255.232'),(891,'92.253.217.56'),(892,'116.179.32.46'),(893,'192.241.227.66'),(894,'24.241.82.106'),(895,'54.36.148.162'),(896,'116.179.32.200'),(897,'116.206.195.150'),(898,'103.131.71.68'),(899,'115.48.162.24'),(900,'42.236.10.70'),(901,'220.181.108.75'),(902,'170.83.176.219'),(903,'103.68.250.52'),(904,'220.181.108.149'),(905,'167.248.133.54'),(906,'116.179.32.28'),(907,'220.181.108.152'),(908,'18.237.5.42'),(909,'45.156.31.239'),(910,'46.252.34.28'),(911,'178.63.74.219'),(912,'182.48.105.210'),(913,'103.131.71.21'),(914,'103.131.71.18'),(915,'103.131.71.31'),(916,'103.131.71.29'),(917,'13.66.139.97'),(918,'220.181.108.177'),(919,'10.208.49.77'),(920,'185.175.137.119'),(921,'106.11.156.54'),(922,'106.11.158.48'),(923,'42.156.137.7'),(924,'107.174.148.85'),(925,'13.66.139.85'),(926,'23.83.87.219'),(927,'190.26.12.58'),(928,'85.249.198.165'),(929,'13.66.139.55'),(930,'107.77.76.50'),(931,'74.71.89.58'),(932,'95.163.255.201'),(933,'47.56.176.45'),(934,'193.169.203.157'),(935,'45.155.126.222'),(936,'74.82.47.4'),(937,'143.198.77.12'),(938,'192.241.226.91'),(939,'92.63.196.29'),(940,'178.128.155.29'),(941,'66.102.8.220'),(942,'181.215.88.153'),(943,'176.179.156.82'),(944,'107.174.149.61'),(945,'66.249.68.28'),(946,'66.249.68.24'),(947,'45.14.224.130'),(948,'157.90.117.121'),(949,'66.249.68.26'),(950,'66.249.68.76'),(951,'170.83.177.38'),(952,'106.11.158.107'),(953,'36.67.199.121'),(954,'66.249.68.78'),(955,'193.56.29.26'),(956,'217.160.250.196'),(957,'191.101.92.204'),(958,'193.178.169.2'),(959,'78.46.90.120'),(960,'205.185.127.244'),(961,'159.203.18.128'),(962,'35.187.190.226'),(963,'72.182.41.88'),(964,'116.179.32.154'),(965,'66.249.68.74'),(966,'35.156.27.135'),(967,'167.248.133.53'),(968,'192.73.251.201'),(969,'80.82.70.118'),(970,'5.8.10.202'),(971,'61.189.20.24'),(972,'24.218.7.0'),(973,'199.47.189.198'),(974,'24.149.5.196'),(975,'173.252.107.14'),(976,'69.171.251.16'),(977,'69.171.251.6'),(978,'210.193.27.2'),(979,'143.244.51.84'),(980,'139.162.145.250'),(981,'52.168.51.139'),(982,'104.218.60.115'),(983,'134.122.64.84'),(984,'103.131.71.63'),(985,'220.181.108.116'),(986,'220.181.108.141'),(987,'139.99.9.22'),(988,'34.222.173.173'),(989,'69.125.176.70'),(990,'92.75.161.135'),(991,'203.159.80.143'),(992,'116.213.43.220'),(993,'185.220.103.9'),(994,'46.105.32.156'),(995,'203.119.253.56'),(996,'66.249.82.107'),(997,'66.249.82.223'),(998,'3.208.92.73'),(999,'146.6.15.11'),(1000,'114.32.20.141'),(1001,'62.210.168.194'),(1002,'171.7.16.121'),(1003,'31.217.213.151'),(1004,'186.33.76.222'),(1005,'139.59.69.194'),(1006,'125.34.210.204'),(1007,'115.207.255.203'),(1008,'61.129.6.151'),(1009,'101.89.239.245'),(1010,'61.151.178.177'),(1011,'103.133.243.12'),(1012,'111.206.36.32'),(1013,'194.127.179.139'),(1014,'36.110.199.31'),(1015,'36.110.199.162'),(1016,'91.207.184.213'),(1017,'103.252.170.229'),(1018,'80.97.226.102'),(1019,'42.236.10.121'),(1020,'92.255.198.132'),(1021,'103.6.198.94'),(1022,'186.179.36.248'),(1023,'191.102.182.207'),(1024,'5.34.219.121'),(1025,'54.36.149.93'),(1026,'184.105.139.70'),(1027,'84.17.46.229'),(1028,'220.181.108.110'),(1029,'162.241.219.197'),(1030,'45.33.102.90'),(1031,'73.10.9.196'),(1032,'49.7.21.75'),(1033,'181.215.157.188'),(1034,'103.143.77.64'),(1035,'217.115.34.254'),(1036,'85.237.234.206'),(1037,'209.141.33.74'),(1038,'66.249.83.31'),(1039,'212.102.63.156'),(1040,'111.253.20.229'),(1041,'125.230.87.91'),(1042,'199.180.112.136'),(1043,'116.179.32.12'),(1044,'54.91.119.72'),(1045,'66.249.93.212'),(1046,'66.249.93.211'),(1047,'77.35.63.44'),(1048,'95.105.125.112'),(1049,'192.161.177.3'),(1050,'192.150.10.207'),(1051,'123.126.68.131'),(1052,'84.135.25.40'),(1053,'123.183.224.107'),(1054,'123.165.51.192'),(1055,'181.115.204.74'),(1056,'173.230.65.71'),(1057,'192.241.227.165'),(1058,'45.144.225.171'),(1059,'107.174.151.130'),(1060,'10.208.55.98'),(1061,'86.62.119.82'),(1062,'205.169.39.117'),(1063,'139.211.231.74'),(1064,'139.211.231.204'),(1065,'122.138.104.141'),(1066,'194.48.199.121'),(1067,'205.169.39.184'),(1068,'218.73.117.56'),(1069,'111.93.30.66'),(1070,'104.223.31.95'),(1071,'103.255.6.79'),(1072,'172.255.81.150'),(1073,'10.22.14.207'),(1074,'54.180.78.136'),(1075,'66.249.79.24'),(1076,'66.249.79.28'),(1077,'54.36.148.25'),(1078,'66.249.79.26'),(1079,'66.249.79.14'),(1080,'66.249.79.10'),(1081,'66.249.79.12'),(1082,'70.175.223.76'),(1083,'100.38.83.118'),(1084,'162.142.125.121'),(1085,'35.226.29.9'),(1086,'40.77.188.38'),(1087,'40.77.190.119'),(1088,'40.77.188.44'),(1089,'40.77.189.91'),(1090,'40.77.189.227'),(1091,'40.77.190.225'),(1092,'40.77.188.21'),(1093,'66.214.174.182'),(1094,'91.239.130.30'),(1095,'5.188.210.227'),(1096,'107.77.104.49'),(1097,'96.239.17.145'),(1098,'62.210.91.20'),(1099,'176.110.134.2'),(1100,'108.30.58.124'),(1101,'45.35.33.246'),(1102,'95.163.255.230'),(1103,'38.69.48.187'),(1104,'165.16.37.130'),(1105,'98.218.106.151'),(1106,'52.8.22.94'),(1107,'221.13.7.50'),(1108,'66.249.84.32'),(1109,'66.249.84.61'),(1110,'66.249.83.88'),(1111,'36.69.71.110'),(1112,'163.172.51.75'),(1113,'46.101.142.222'),(1114,'103.22.182.153'),(1115,'103.131.71.58'),(1116,'101.230.64.18'),(1117,'187.133.94.193'),(1118,'190.61.46.174'),(1119,'83.24.247.102'),(1120,'43.226.148.198'),(1121,'221.204.146.52'),(1122,'204.44.96.130'),(1123,'185.222.138.163'),(1124,'13.66.139.79'),(1125,'66.249.72.253'),(1126,'42.236.10.90'),(1127,'61.219.56.19'),(1128,'61.219.56.7'),(1129,'61.219.56.17'),(1130,'61.219.56.10'),(1131,'74.72.216.62'),(1132,'212.129.152.41'),(1133,'185.153.196.198'),(1134,'220.181.108.120'),(1135,'116.179.32.77'),(1136,'220.181.108.157'),(1137,'220.79.131.182'),(1138,'54.218.76.234'),(1139,'106.52.111.175'),(1140,'104.223.33.15'),(1141,'77.88.5.246'),(1142,'192.35.168.32'),(1143,'157.55.39.61'),(1144,'157.55.39.174'),(1145,'157.55.39.252'),(1146,'40.77.167.18'),(1147,'186.33.96.63'),(1148,'121.4.163.148'),(1149,'212.233.126.114'),(1150,'13.66.139.51'),(1151,'116.226.169.122'),(1152,'66.96.228.212'),(1153,'139.28.37.245'),(1154,'27.34.104.245'),(1155,'46.161.15.88'),(1156,'81.242.188.42'),(1157,'121.5.78.93'),(1158,'121.5.219.20'),(1159,'46.147.100.80'),(1160,'121.5.112.244'),(1161,'213.180.203.249'),(1162,'213.180.203.253'),(1163,'124.13.110.14'),(1164,'121.4.181.178'),(1165,'54.36.148.6'),(1166,'157.97.20.127'),(1167,'5.107.32.138'),(1168,'121.5.113.11'),(1169,'41.57.111.241'),(1170,'184.105.139.68'),(1171,'157.55.39.30'),(1172,'40.80.88.134'),(1173,'116.179.32.198'),(1174,'116.179.32.51'),(1175,'178.134.155.82'),(1176,'192.241.218.140'),(1177,'64.64.247.4'),(1178,'66.249.80.157'),(1179,'40.77.167.91'),(1180,'88.245.199.54'),(1181,'66.249.81.64'),(1182,'45.131.195.182'),(1183,'108.35.111.230'),(1184,'70.112.121.134'),(1185,'116.179.32.18'),(1186,'45.132.227.50'),(1187,'40.94.37.73'),(1188,'111.206.198.125'),(1189,'111.206.198.122'),(1190,'111.206.221.41'),(1191,'111.206.198.44'),(1192,'111.206.221.44'),(1193,'111.206.198.70'),(1194,'106.45.11.118'),(1195,'111.206.221.22'),(1196,'49.113.96.59'),(1197,'1.85.217.214'),(1198,'111.206.221.35'),(1199,'111.206.198.33'),(1200,'111.206.198.75'),(1201,'111.206.221.7'),(1202,'111.206.221.87'),(1203,'111.206.221.113'),(1204,'111.206.221.101'),(1205,'111.206.221.73'),(1206,'27.224.137.16'),(1207,'111.206.198.93'),(1208,'113.58.247.43'),(1209,'111.206.221.21'),(1210,'111.206.221.16'),(1211,'60.13.136.20'),(1212,'60.13.7.92'),(1213,'125.72.95.220'),(1214,'116.52.118.62'),(1215,'36.5.71.241'),(1216,'175.184.165.82'),(1217,'150.108.240.83'),(1218,'80.84.57.6'),(1219,'198.98.59.61'),(1220,'115.148.153.163'),(1221,'59.55.155.45'),(1222,'115.148.152.249'),(1223,'223.166.74.123'),(1224,'115.148.154.137'),(1225,'175.152.110.58'),(1226,'98.113.66.235'),(1227,'46.101.151.39'),(1228,'58.245.27.199'),(1229,'124.235.138.81'),(1230,'171.117.205.76'),(1231,'104.47.61.254'),(1232,'184.144.110.40'),(1233,'40.94.37.63'),(1234,'185.184.157.95'),(1235,'35.239.58.193'),(1236,'181.114.150.100'),(1237,'42.236.10.78'),(1238,'42.236.10.84'),(1239,'42.236.10.125'),(1240,'42.236.10.106'),(1241,'109.233.196.232'),(1242,'105.184.80.46'),(1243,'109.13.11.91'),(1244,'198.98.110.138'),(1245,'192.164.241.95'),(1246,'171.221.24.42'),(1247,'77.148.95.95'),(1248,'54.36.148.84'),(1249,'138.201.194.13'),(1250,'3.90.153.146'),(1251,'101.89.239.232'),(1252,'142.202.189.71'),(1253,'80.251.223.18'),(1254,'68.194.132.130'),(1255,'74.101.172.238'),(1256,'67.87.73.34'),(1257,'13.66.139.113'),(1258,'68.42.229.156'),(1259,'18.237.199.126'),(1260,'94.244.134.107'),(1261,'97.100.18.16'),(1262,'74.102.224.121'),(1263,'121.4.131.160'),(1264,'60.13.6.243'),(1265,'219.143.174.64'),(1266,'106.45.10.170'),(1267,'171.36.135.172'),(1268,'60.13.138.7'),(1269,'120.85.111.57'),(1270,'124.227.31.252'),(1271,'36.32.3.195'),(1272,'110.167.215.251'),(1273,'124.227.31.41'),(1274,'112.66.103.105'),(1275,'205.169.39.211'),(1276,'205.169.39.216'),(1277,'157.55.39.31'),(1278,'128.14.133.58'),(1279,'35.153.134.146'),(1280,'123.189.88.192'),(1281,'68.234.44.93'),(1282,'66.154.104.2'),(1283,'82.115.215.127'),(1284,'220.249.46.82'),(1285,'13.66.139.103'),(1286,'91.220.235.51'),(1287,'74.72.124.195'),(1288,'192.241.222.55'),(1289,'42.192.184.76'),(1290,'170.130.187.26'),(1291,'23.90.28.168'),(1292,'116.246.6.128'),(1293,'66.249.82.192'),(1294,'66.249.82.189'),(1295,'100.37.203.216'),(1296,'37.187.73.52'),(1297,'106.242.14.91'),(1298,'192.241.225.183'),(1299,'196.242.10.225'),(1300,'4.28.87.68'),(1301,'65.154.226.165'),(1302,'157.55.39.117'),(1303,'42.192.17.155'),(1304,'13.66.139.147'),(1305,'123.126.68.117'),(1306,'73.246.211.23'),(1307,'49.36.45.189'),(1308,'119.54.175.225'),(1309,'23.100.232.233'),(1310,'220.181.108.78'),(1311,'121.5.226.36'),(1312,'193.169.255.246'),(1313,'220.181.108.186'),(1314,'35.224.211.46'),(1315,'98.149.56.21'),(1316,'104.206.128.62'),(1317,'103.221.235.208'),(1318,'206.189.200.107'),(1319,'216.218.206.69'),(1320,'66.249.81.93'),(1321,'66.249.72.226'),(1322,'35.240.117.172'),(1323,'13.66.139.29'),(1324,'46.135.6.145'),(1325,'204.16.247.162'),(1326,'5.157.61.143'),(1327,'17.58.98.96'),(1328,'174.204.137.77'),(1329,'205.169.39.243'),(1330,'106.11.159.68'),(1331,'106.11.154.130'),(1332,'77.222.114.92'),(1333,'98.7.210.3'),(1334,'192.0.101.15'),(1335,'196.242.178.5'),(1336,'74.71.167.76'),(1337,'54.36.148.21'),(1338,'192.241.227.203'),(1339,'181.174.107.197'),(1340,'184.153.121.89'),(1341,'192.241.219.133'),(1342,'119.116.7.209'),(1343,'119.29.111.220'),(1344,'106.11.152.21'),(1345,'35.189.57.191'),(1346,'205.169.39.130'),(1347,'207.180.225.224'),(1348,'103.131.71.27'),(1349,'103.131.71.28'),(1350,'220.181.108.154'),(1351,'40.77.167.87'),(1352,'69.171.251.3'),(1353,'77.49.71.245'),(1354,'106.11.159.121'),(1355,'88.231.247.233'),(1356,'68.195.19.56'),(1357,'73.89.152.25'),(1358,'172.56.22.94'),(1359,'216.197.138.153'),(1360,'67.245.227.168'),(1361,'64.227.122.210'),(1362,'71.105.90.86'),(1363,'46.148.46.138'),(1364,'112.218.231.43'),(1365,'93.183.251.251'),(1366,'203.138.99.49'),(1367,'128.59.228.34'),(1368,'5.9.70.113'),(1369,'83.136.216.51'),(1370,'13.66.242.240'),(1371,'20.190.38.165'),(1372,'207.237.8.108'),(1373,'5.188.48.197'),(1374,'129.236.130.141'),(1375,'217.76.38.53'),(1376,'160.39.143.149'),(1377,'67.86.141.209'),(1378,'216.165.73.13'),(1379,'168.181.121.30'),(1380,'202.43.232.29'),(1381,'49.7.21.67'),(1382,'180.163.220.43'),(1383,'82.145.220.187'),(1384,'172.105.161.142'),(1385,'144.76.120.197'),(1386,'52.141.215.127'),(1387,'67.177.180.82'),(1388,'174.127.242.156'),(1389,'54.36.148.82'),(1390,'190.94.140.127'),(1391,'180.103.219.68'),(1392,'72.193.7.75'),(1393,'192.241.227.47'),(1394,'194.67.104.15'),(1395,'34.77.162.13'),(1396,'119.116.2.145'),(1397,'88.198.43.207'),(1398,'107.148.247.96'),(1399,'13.66.139.8'),(1400,'116.246.15.242'),(1401,'69.116.114.127'),(1402,'47.21.25.54'),(1403,'13.66.139.33'),(1404,'34.77.162.20'),(1405,'111.7.96.149'),(1406,'23.81.232.238'),(1407,'116.179.32.174'),(1408,'174.218.133.228'),(1409,'23.95.239.67'),(1410,'20.55.217.97'),(1411,'207.46.13.35'),(1412,'40.77.167.43'),(1413,'119.116.0.9'),(1414,'23.83.90.189'),(1415,'220.181.108.113'),(1416,'209.127.43.14'),(1417,'67.205.144.202'),(1418,'192.126.243.49'),(1419,'123.126.68.111'),(1420,'103.221.235.183'),(1421,'116.179.32.150'),(1422,'123.125.67.164'),(1423,'60.8.123.7'),(1424,'120.232.150.100'),(1425,'65.49.20.66'),(1426,'23.83.87.227'),(1427,'81.69.191.124'),(1428,'116.179.32.167'),(1429,'116.179.32.220'),(1430,'86.142.80.200'),(1431,'113.59.213.175'),(1432,'139.215.226.85'),(1433,'201.140.178.25'),(1434,'167.248.133.55'),(1435,'139.162.119.197'),(1436,'20.57.24.7'),(1437,'151.202.49.154'),(1438,'5.188.84.250'),(1439,'13.66.139.30'),(1440,'13.66.139.41'),(1441,'106.11.153.12'),(1442,'101.84.156.24'),(1443,'170.244.188.44'),(1444,'66.108.45.38'),(1445,'13.76.191.209'),(1446,'54.169.219.212'),(1447,'104.215.156.1'),(1448,'13.229.67.193'),(1449,'34.72.224.111'),(1450,'23.81.232.105'),(1451,'45.195.146.140'),(1452,'222.188.159.158'),(1453,'199.249.230.69'),(1454,'113.102.108.131'),(1455,'54.36.149.95'),(1456,'34.201.4.208'),(1457,'213.108.0.35'),(1458,'61.147.15.67'),(1459,'188.165.113.29'),(1460,'91.98.172.228'),(1461,'106.54.78.68'),(1462,'125.72.95.243'),(1463,'27.224.136.154'),(1464,'221.213.75.105'),(1465,'124.89.90.61'),(1466,'27.224.137.210'),(1467,'123.14.253.119'),(1468,'124.227.31.153'),(1469,'1.202.113.72'),(1470,'36.5.150.102'),(1471,'123.189.88.12'),(1472,'47.89.192.12'),(1473,'173.68.95.137'),(1474,'54.69.168.72'),(1475,'91.216.254.2'),(1476,'40.77.190.84'),(1477,'40.77.188.102'),(1478,'23.81.232.93'),(1479,'15.236.210.209'),(1480,'192.3.27.173'),(1481,'138.68.69.164'),(1482,'104.140.188.6'),(1483,'150.108.238.161'),(1484,'162.142.125.55'),(1485,'46.114.143.210'),(1486,'183.216.214.44'),(1487,'61.7.141.126'),(1488,'157.230.224.111'),(1489,'93.100.128.35'),(1490,'50.112.30.237'),(1491,'91.197.47.79'),(1492,'170.233.47.15'),(1493,'60.8.123.89'),(1494,'139.211.229.198'),(1495,'122.138.99.5'),(1496,'45.12.213.141'),(1497,'40.77.167.90'),(1498,'220.181.108.169'),(1499,'42.236.10.110'),(1500,'72.79.51.77'),(1501,'222.246.38.204'),(1502,'107.174.218.202'),(1503,'144.76.118.82'),(1504,'168.195.209.21'),(1505,'108.169.200.134'),(1506,'103.69.217.171'),(1507,'54.81.216.211'),(1508,'40.77.189.195'),(1509,'40.77.190.13'),(1510,'40.77.190.36'),(1511,'54.36.148.74'),(1512,'116.179.32.37'),(1513,'185.191.124.152'),(1514,'45.83.66.24'),(1515,'47.52.33.40'),(1516,'116.179.32.210'),(1517,'111.206.198.103'),(1518,'111.206.198.45'),(1519,'111.206.198.34'),(1520,'210.99.31.252'),(1521,'34.77.162.30'),(1522,'196.242.10.116'),(1523,'54.196.158.233'),(1524,'74.72.158.95'),(1525,'52.4.104.152'),(1526,'165.73.99.241'),(1527,'45.143.99.69'),(1528,'107.6.232.100'),(1529,'112.86.135.124'),(1530,'27.115.124.101'),(1531,'196.189.240.51'),(1532,'60.8.151.163'),(1533,'13.66.139.42'),(1534,'157.230.95.84'),(1535,'178.153.213.29'),(1536,'2.95.196.197'),(1537,'167.114.181.145'),(1538,'87.244.208.142'),(1539,'49.7.20.124'),(1540,'41.190.22.154'),(1541,'113.156.65.68'),(1542,'138.255.12.75'),(1543,'13.66.139.7'),(1544,'159.203.41.236'),(1545,'220.181.108.99'),(1546,'23.95.239.115'),(1547,'49.7.20.98'),(1548,'181.215.88.147'),(1549,'112.6.9.8'),(1550,'111.206.221.95'),(1551,'111.206.221.48'),(1552,'123.245.24.51'),(1553,'123.163.114.139'),(1554,'60.13.138.42'),(1555,'123.163.114.104'),(1556,'175.184.164.138'),(1557,'120.85.110.218'),(1558,'150.255.81.110'),(1559,'223.166.75.111'),(1560,'49.113.99.76'),(1561,'49.113.103.119'),(1562,'119.39.47.129'),(1563,'104.238.47.23'),(1564,'121.5.109.55'),(1565,'197.210.227.128'),(1566,'95.217.229.88'),(1567,'78.196.124.149'),(1568,'64.62.197.212'),(1569,'186.33.126.76'),(1570,'112.198.69.225'),(1571,'181.215.204.131'),(1572,'45.33.90.54'),(1573,'192.241.226.206'),(1574,'145.40.80.163'),(1575,'109.200.253.2'),(1576,'40.77.189.101'),(1577,'82.221.105.7'),(1578,'34.76.224.145'),(1579,'54.154.198.175'),(1580,'41.75.120.181'),(1581,'134.209.24.81'),(1582,'154.124.97.221'),(1583,'45.131.195.142'),(1584,'54.36.149.8'),(1585,'76.205.180.236'),(1586,'192.241.218.5'),(1587,'36.37.149.240'),(1588,'74.64.211.166'),(1589,'77.77.131.178'),(1590,'34.74.78.69'),(1591,'50.102.208.196'),(1592,'77.88.5.211'),(1593,'103.99.196.26'),(1594,'200.53.21.88'),(1595,'212.227.216.16'),(1596,'13.66.139.16'),(1597,'144.76.162.206'),(1598,'104.37.172.157'),(1599,'178.238.8.33'),(1600,'112.103.195.130'),(1601,'124.228.67.187'),(1602,'67.82.242.1'),(1603,'39.103.170.104'),(1604,'84.201.164.206'),(1605,'116.179.32.83'),(1606,'199.47.87.140'),(1607,'98.11.238.25'),(1608,'13.66.139.12'),(1609,'193.142.146.84'),(1610,'103.131.71.33'),(1611,'69.127.109.24'),(1612,'181.215.204.153'),(1613,'116.179.32.197'),(1614,'74.120.14.56'),(1615,'167.250.140.141'),(1616,'217.209.126.75'),(1617,'50.87.144.90'),(1618,'185.119.187.26'),(1619,'115.96.144.25'),(1620,'157.32.95.109'),(1621,'54.36.148.165'),(1622,'46.33.33.102'),(1623,'40.77.191.54'),(1624,'192.241.220.200'),(1625,'220.181.108.146'),(1626,'203.119.173.114'),(1627,'203.88.145.161'),(1628,'192.241.217.16'),(1629,'180.149.125.166'),(1630,'66.249.82.109'),(1631,'211.214.107.108'),(1632,'161.185.161.27'),(1633,'47.25.200.107'),(1634,'31.42.176.13'),(1635,'36.77.94.220'),(1636,'212.69.18.121'),(1637,'66.249.66.68'),(1638,'66.249.66.158'),(1639,'66.249.66.70'),(1640,'66.249.66.34'),(1641,'66.249.66.72'),(1642,'66.249.66.44'),(1643,'104.168.28.169'),(1644,'66.249.66.136'),(1645,'40.77.189.242'),(1646,'40.77.188.243'),(1647,'40.77.189.74'),(1648,'40.77.188.109'),(1649,'40.77.190.52'),(1650,'40.77.190.106'),(1651,'66.249.66.157'),(1652,'125.161.130.186'),(1653,'66.249.66.37'),(1654,'66.249.66.204'),(1655,'185.173.35.1'),(1656,'65.49.20.67'),(1657,'192.241.228.101'),(1658,'45.148.10.45'),(1659,'66.249.66.40'),(1660,'217.219.28.146'),(1661,'73.229.174.44'),(1662,'72.68.103.114'),(1663,'92.101.95.157'),(1664,'66.249.66.194'),(1665,'116.15.26.231'),(1666,'207.46.13.7'),(1667,'36.110.147.95'),(1668,'91.204.154.197'),(1669,'178.214.253.155'),(1670,'23.229.57.248'),(1671,'43.239.160.242'),(1672,'191.254.150.41'),(1673,'123.183.224.6'),(1674,'161.97.154.167'),(1675,'119.52.109.223'),(1676,'119.52.196.81'),(1677,'119.52.109.60'),(1678,'92.118.77.10'),(1679,'82.165.224.137'),(1680,'66.24.249.170'),(1681,'3.231.168.59'),(1682,'54.36.148.202'),(1683,'138.201.117.67'),(1684,'95.139.114.91'),(1685,'13.66.246.180'),(1686,'47.20.29.83'),(1687,'200.218.242.213'),(1688,'188.232.143.93'),(1689,'37.49.229.154'),(1690,'194.147.142.120'),(1691,'220.249.46.105'),(1692,'208.196.3.110'),(1693,'40.77.188.160'),(1694,'40.77.189.104'),(1695,'124.70.33.191'),(1696,'18.167.173.213'),(1697,'42.236.10.123'),(1698,'91.243.46.122'),(1699,'113.72.121.162'),(1700,'66.102.8.223'),(1701,'66.102.8.222'),(1702,'74.125.210.10'),(1703,'74.125.210.14'),(1704,'74.125.210.12'),(1705,'74.125.214.27'),(1706,'74.125.214.29'),(1707,'74.125.214.25'),(1708,'66.102.7.28'),(1709,'66.102.7.27'),(1710,'66.102.7.26'),(1711,'106.52.27.165'),(1712,'106.45.11.16'),(1713,'150.255.33.219'),(1714,'123.160.175.248'),(1715,'49.113.101.94'),(1716,'124.89.119.4'),(1717,'27.224.137.144'),(1718,'112.112.83.137'),(1719,'124.227.31.190'),(1720,'119.39.47.140'),(1721,'124.227.31.74'),(1722,'112.232.238.75'),(1723,'27.34.12.253'),(1724,'188.21.233.122'),(1725,'66.102.9.95'),(1726,'176.59.108.183'),(1727,'103.75.167.6'),(1728,'60.184.54.194'),(1729,'34.123.83.210'),(1730,'40.77.167.19'),(1731,'40.77.167.17'),(1732,'105.235.128.59'),(1733,'46.4.83.150'),(1734,'220.181.108.174'),(1735,'216.218.206.66'),(1736,'206.189.135.161'),(1737,'144.217.67.229'),(1738,'63.142.250.231'),(1739,'54.36.149.47'),(1740,'40.77.167.13'),(1741,'143.110.176.129'),(1742,'207.46.13.40'),(1743,'103.138.4.209'),(1744,'185.69.153.208'),(1745,'193.200.50.189'),(1746,'173.252.87.6'),(1747,'173.252.87.4'),(1748,'173.252.87.10'),(1749,'80.89.238.219'),(1750,'128.14.134.170'),(1751,'34.72.86.44'),(1752,'110.44.121.23'),(1753,'205.169.39.170'),(1754,'34.218.245.18'),(1755,'173.252.107.19'),(1756,'173.252.111.7'),(1757,'193.46.254.171'),(1758,'89.28.86.236'),(1759,'220.181.108.88'),(1760,'202.164.139.148'),(1761,'37.210.156.5'),(1762,'196.121.23.67'),(1763,'98.203.62.117'),(1764,'161.97.183.146'),(1765,'103.17.202.138'),(1766,'93.124.33.164'),(1767,'220.181.108.81'),(1768,'193.124.181.253'),(1769,'60.8.123.73'),(1770,'104.248.175.154'),(1771,'82.223.9.130'),(1772,'148.75.118.96'),(1773,'117.141.74.48'),(1774,'27.115.124.10'),(1775,'27.115.124.36'),(1776,'27.115.124.37'),(1777,'27.115.124.99'),(1778,'170.254.226.191'),(1779,'68.174.212.240'),(1780,'134.35.33.192'),(1781,'61.244.94.11'),(1782,'154.231.123.161'),(1783,'185.242.10.208'),(1784,'171.98.16.160'),(1785,'167.248.133.39'),(1786,'218.95.176.205'),(1787,'116.1.220.3'),(1788,'171.116.80.239'),(1789,'221.0.16.134'),(1790,'1.202.114.223'),(1791,'116.249.23.247'),(1792,'118.81.225.139'),(1793,'123.245.25.8'),(1794,'61.52.82.161'),(1795,'60.13.7.187'),(1796,'27.211.176.126'),(1797,'36.32.3.155'),(1798,'107.150.80.95'),(1799,'73.178.73.92'),(1800,'54.242.245.59'),(1801,'201.20.79.18'),(1802,'162.83.167.205'),(1803,'144.168.157.153'),(1804,'40.77.188.95'),(1805,'40.77.189.9'),(1806,'40.77.188.56'),(1807,'40.77.190.99'),(1808,'109.81.214.225'),(1809,'34.245.95.163'),(1810,'40.77.167.95'),(1811,'117.196.230.215'),(1812,'108.54.48.15'),(1813,'167.88.12.72'),(1814,'45.127.247.34'),(1815,'116.179.32.209'),(1816,'8.242.205.74'),(1817,'54.36.148.129'),(1818,'23.129.64.205'),(1819,'134.209.173.43'),(1820,'134.209.163.249'),(1821,'101.88.157.56'),(1822,'47.244.103.226'),(1823,'47.93.22.124'),(1824,'36.26.71.182'),(1825,'47.57.4.86'),(1826,'47.242.249.91'),(1827,'40.77.202.107'),(1828,'40.77.189.13'),(1829,'39.109.68.129'),(1830,'93.124.96.243'),(1831,'193.106.29.210'),(1832,'202.43.232.20'),(1833,'42.192.11.192'),(1834,'211.249.218.7'),(1835,'66.220.149.30'),(1836,'128.199.98.99'),(1837,'110.232.87.13'),(1838,'151.245.123.163'),(1839,'42.236.10.109'),(1840,'42.236.10.104'),(1841,'107.206.251.69'),(1842,'192.241.226.44'),(1843,'114.251.211.16'),(1844,'112.117.113.91'),(1845,'60.13.7.21'),(1846,'112.232.238.211'),(1847,'1.85.219.183'),(1848,'112.117.113.19'),(1849,'36.32.3.236'),(1850,'49.113.99.248'),(1851,'112.230.42.64'),(1852,'223.166.74.48'),(1853,'221.11.4.150'),(1854,'223.166.74.64'),(1855,'80.99.186.26'),(1856,'195.158.1.133'),(1857,'87.13.5.152'),(1858,'54.36.149.22'),(1859,'220.181.108.121'),(1860,'34.219.72.1'),(1861,'222.139.91.51'),(1862,'116.179.32.76'),(1863,'64.62.197.122'),(1864,'3.228.19.183'),(1865,'77.51.175.242'),(1866,'91.224.92.170'),(1867,'178.216.215.14'),(1868,'143.198.79.221'),(1869,'34.205.90.108'),(1870,'72.89.243.83'),(1871,'100.37.176.159'),(1872,'118.137.154.251'),(1873,'192.168.5.91'),(1874,'197.136.174.162'),(1875,'60.8.151.214'),(1876,'98.116.224.166'),(1877,'180.163.220.61'),(1878,'46.12.14.158'),(1879,'205.169.39.248'),(1880,'144.76.186.38'),(1881,'34.237.140.218'),(1882,'139.214.85.231'),(1883,'139.214.84.45'),(1884,'139.214.88.200'),(1885,'172.58.235.55'),(1886,'24.185.234.180'),(1887,'95.163.255.83'),(1888,'95.163.255.88'),(1889,'129.123.209.46'),(1890,'40.77.188.195'),(1891,'40.77.188.163'),(1892,'40.77.189.215'),(1893,'66.249.69.180'),(1894,'162.142.125.38'),(1895,'95.163.255.89'),(1896,'66.249.72.90'),(1897,'168.63.74.168'),(1898,'24.166.221.141'),(1899,'189.1.168.147'),(1900,'220.181.108.96'),(1901,'40.77.202.126'),(1902,'190.13.242.175'),(1903,'66.249.72.92'),(1904,'66.249.69.182'),(1905,'66.249.69.184'),(1906,'167.71.113.117'),(1907,'72.227.147.238'),(1908,'74.125.212.93'),(1909,'125.230.76.149'),(1910,'47.95.212.162'),(1911,'36.5.218.70'),(1912,'49.113.102.109'),(1913,'120.85.111.47'),(1914,'223.166.75.172'),(1915,'110.177.181.214'),(1916,'123.245.25.233'),(1917,'124.227.31.135'),(1918,'110.177.182.80'),(1919,'49.113.97.217'),(1920,'61.52.82.60'),(1921,'112.117.201.198'),(1922,'89.25.44.102'),(1923,'117.28.134.201'),(1924,'36.75.243.51'),(1925,'34.77.162.2'),(1926,'68.129.209.165'),(1927,'72.68.29.208'),(1928,'49.7.20.141'),(1929,'34.205.50.100'),(1930,'27.189.28.164'),(1931,'39.98.125.196'),(1932,'161.117.239.46'),(1933,'174.107.98.167'),(1934,'138.99.216.174'),(1935,'54.36.149.48'),(1936,'45.146.165.165'),(1937,'116.179.32.141'),(1938,'218.56.244.21'),(1939,'165.225.210.168'),(1940,'159.69.187.108'),(1941,'192.35.168.160'),(1942,'35.223.196.118'),(1943,'220.181.108.86'),(1944,'220.181.108.179'),(1945,'194.165.16.83'),(1946,'24.6.216.255'),(1947,'49.165.20.101'),(1948,'67.81.156.253'),(1949,'174.136.38.30'),(1950,'220.181.108.168'),(1951,'104.236.55.244'),(1952,'184.105.247.195'),(1953,'36.71.141.165'),(1954,'121.53.83.7'),(1955,'18.138.170.112'),(1956,'192.241.226.104'),(1957,'114.119.146.18'),(1958,'128.14.211.194'),(1959,'93.38.218.171'),(1960,'220.181.108.83'),(1961,'111.206.198.28'),(1962,'111.206.198.51'),(1963,'111.206.221.83'),(1964,'111.206.221.112'),(1965,'111.206.198.84'),(1966,'111.206.221.49'),(1967,'111.206.198.22'),(1968,'111.206.198.123'),(1969,'111.206.221.6'),(1970,'111.206.198.7'),(1971,'111.206.198.77'),(1972,'111.206.221.8'),(1973,'111.206.198.54'),(1974,'120.85.111.190'),(1975,'36.32.3.166'),(1976,'36.106.166.73'),(1977,'123.163.114.225'),(1978,'221.205.139.202'),(1979,'221.13.12.127'),(1980,'27.224.136.226'),(1981,'123.245.25.205'),(1982,'61.52.86.162'),(1983,'120.85.110.145'),(1984,'220.200.161.6'),(1985,'116.179.32.202'),(1986,'36.110.147.96'),(1987,'40.77.202.157'),(1988,'66.249.72.66'),(1989,'115.148.154.22'),(1990,'212.70.113.81'),(1991,'95.152.62.44'),(1992,'92.118.208.241'),(1993,'132.145.127.1'),(1994,'177.131.117.183'),(1995,'54.36.149.4'),(1996,'66.249.72.94'),(1997,'64.62.184.13'),(1998,'64.62.184.12'),(1999,'202.14.6.186'),(2000,'10.27.10.139'),(2001,'103.16.69.153'),(2002,'192.241.220.212'),(2003,'147.139.174.237'),(2004,'192.241.227.38'),(2005,'69.206.162.53'),(2006,'122.239.24.155'),(2007,'24.126.32.163'),(2008,'154.21.114.195'),(2009,'10.208.58.42'),(2010,'167.249.102.186'),(2011,'45.146.55.220'),(2012,'74.71.22.34'),(2013,'100.2.162.73'),(2014,'47.56.154.54'),(2015,'34.86.35.21'),(2016,'3.87.101.55'),(2017,'108.6.210.237'),(2018,'54.169.66.162'),(2019,'186.33.77.213'),(2020,'180.194.132.46'),(2021,'176.105.33.47'),(2022,'130.61.113.63'),(2023,'31.205.114.80'),(2024,'138.118.100.57'),(2025,'73.4.164.213'),(2026,'34.240.100.197'),(2027,'170.83.179.84'),(2028,'3.87.17.4'),(2029,'139.214.89.1'),(2030,'139.214.89.132'),(2031,'139.214.89.57'),(2032,'104.236.49.151'),(2033,'73.109.58.166'),(2034,'100.37.185.194'),(2035,'167.249.102.91'),(2036,'135.181.82.212'),(2037,'185.144.245.92'),(2038,'174.225.12.91'),(2039,'186.33.77.80'),(2040,'107.151.182.58'),(2041,'134.209.115.71'),(2042,'24.149.5.197'),(2043,'66.249.88.219'),(2044,'161.35.78.11'),(2045,'184.153.102.226'),(2046,'135.181.85.48'),(2047,'47.242.210.199'),(2048,'116.179.32.195'),(2049,'5.157.17.17'),(2050,'34.86.35.13'),(2051,'34.86.35.22'),(2052,'40.77.167.94'),(2053,'97.75.181.68'),(2054,'72.226.13.75'),(2055,'104.236.12.63'),(2056,'116.179.32.98'),(2057,'108.41.98.5'),(2058,'92.118.161.17'),(2059,'68.230.71.76'),(2060,'23.229.86.44'),(2061,'23.236.234.172'),(2062,'70.73.129.213'),(2063,'24.55.167.119'),(2064,'24.205.125.95'),(2065,'116.179.32.35'),(2066,'123.125.67.220'),(2067,'193.42.110.99'),(2068,'40.77.202.41'),(2069,'82.165.48.181'),(2070,'60.8.151.5'),(2071,'186.179.18.143'),(2072,'14.160.24.90'),(2073,'74.116.59.8'),(2074,'180.163.220.99'),(2075,'186.179.37.61'),(2076,'95.163.255.82'),(2077,'114.119.156.38'),(2078,'45.170.220.65'),(2079,'23.105.143.173'),(2080,'54.36.148.15'),(2081,'91.220.151.9'),(2082,'176.15.142.199'),(2083,'192.241.227.85'),(2084,'183.228.124.35'),(2085,'34.77.162.33'),(2086,'82.146.56.139'),(2087,'109.71.35.4'),(2088,'220.181.108.115'),(2089,'117.15.213.129'),(2090,'183.87.240.249'),(2091,'186.179.37.26'),(2092,'86.137.100.75'),(2093,'34.82.206.113'),(2094,'42.228.38.235'),(2095,'95.163.255.85'),(2096,'203.158.50.66'),(2097,'74.120.14.39'),(2098,'18.139.160.217'),(2099,'156.96.151.240'),(2100,'111.206.221.79'),(2101,'171.37.38.173'),(2102,'111.206.198.76'),(2103,'111.206.221.14'),(2104,'111.206.198.68'),(2105,'119.39.47.69'),(2106,'113.200.71.99'),(2107,'111.206.221.88'),(2108,'120.85.111.58'),(2109,'110.167.215.179'),(2110,'111.206.221.103'),(2111,'117.14.115.208'),(2112,'150.255.32.50'),(2113,'110.177.177.98'),(2114,'221.13.12.133'),(2115,'111.206.198.97'),(2116,'193.207.203.103'),(2117,'40.77.188.178'),(2118,'13.66.139.161'),(2119,'13.66.139.108'),(2120,'51.15.240.72'),(2121,'58.236.111.59'),(2122,'104.248.226.52'),(2123,'139.59.27.16'),(2124,'191.102.165.145'),(2125,'129.205.96.150'),(2126,'107.175.90.27'),(2127,'45.120.50.15'),(2128,'40.77.189.47'),(2129,'78.38.13.79'),(2130,'182.160.98.250'),(2131,'54.36.148.144'),(2132,'158.222.237.144'),(2133,'223.186.96.172'),(2134,'161.35.142.10'),(2135,'162.210.196.129'),(2136,'54.78.212.94'),(2137,'80.82.77.192'),(2138,'173.252.111.19'),(2139,'173.252.111.2'),(2140,'114.95.35.216'),(2141,'31.13.127.14'),(2142,'69.171.251.116'),(2143,'31.13.127.12'),(2144,'31.13.127.15'),(2145,'110.177.181.181'),(2146,'223.166.75.130'),(2147,'221.213.75.46'),(2148,'220.200.167.232'),(2149,'180.95.231.204'),(2150,'110.177.182.15'),(2151,'183.185.21.71'),(2152,'123.191.133.14'),(2153,'175.184.167.247'),(2154,'123.163.114.135'),(2155,'60.216.139.169'),(2156,'13.66.139.110'),(2157,'45.32.100.213'),(2158,'188.32.144.20'),(2159,'123.200.10.98'),(2160,'157.90.7.182'),(2161,'212.227.216.132'),(2162,'47.232.136.20'),(2163,'188.19.254.191'),(2164,'54.204.158.119'),(2165,'93.174.95.106'),(2166,'3.92.240.157'),(2167,'92.118.161.57'),(2168,'71.251.24.121'),(2169,'47.57.142.177'),(2170,'8.210.159.213'),(2171,'104.183.240.225'),(2172,'45.134.225.193'),(2173,'45.144.225.96'),(2174,'168.80.176.71'),(2175,'168.80.99.251'),(2176,'168.80.177.20'),(2177,'168.80.176.176'),(2178,'114.119.139.247'),(2179,'142.79.213.55'),(2180,'104.140.83.113'),(2181,'108.253.179.40'),(2182,'95.163.255.87'),(2183,'38.94.109.41'),(2184,'42.236.10.117'),(2185,'42.236.10.75'),(2186,'42.236.10.93'),(2187,'216.24.181.228'),(2188,'78.56.105.17'),(2189,'103.131.71.32'),(2190,'35.243.240.156'),(2191,'3.92.126.191');
UNLOCK TABLES;

--
-- Table structure for table 'web_page'
--
DROP TABLE IF EXISTS web_page;
CREATE TABLE web_page (
  page_id   int(11)      NOT NULL AUTO_INCREMENT,
  page_url  varchar(999) DEFAULT NULL,
  page_type varchar(99)  DEFAULT NULL,
  page_size int(11)      DEFAULT NULL,
  PRIMARY KEY (page_id)
) ENGINE=InnoDB AUTO_INCREMENT=10365 DEFAULT CHARSET=latin1;
--
-- Load data for table 'web_page'
--
LOCK TABLES web_page WRITE;
-- INSERT INTO web_page VALUES (...)
UNLOCK TABLES;

--
-- Table structure for table 'web_product'
--
DROP TABLE IF EXISTS web_product;
CREATE TABLE web_product (
  prod_id int(11)       NOT NULL AUTO_INCREMENT,
  product varchar(999)  DEFAULT NULL,
  PRIMARY KEY (prod_id)
) ENGINE=InnoDB AUTO_INCREMENT=4787 DEFAULT CHARSET=latin1;
--
-- Load data for table 'web_product'
--
LOCK TABLES web_product WRITE;
-- INSERT INTO web_product VALUES (...) 
UNLOCK TABLES;

--
-- Table structure for table 'web_log'
--
DROP TABLE IF EXISTS web_log;
CREATE TABLE web_log (
  pk             int(11)     NOT NULL AUTO_INCREMENT,
  user_id        int(11)     DEFAULT NULL,
  page_id        int(11)     DEFAULT NULL,
  prod_id        int(11)     DEFAULT NULL,
  date_id        int(11)     DEFAULT NULL,
  user_signon    varchar(99) DEFAULT NULL,
  request_date   datetime    DEFAULT NULL,
  request_method varchar(10) DEFAULT NULL,
  protocol       varchar(15) DEFAULT NULL,
  request_status int(11)     DEFAULT NULL,
  referrer       varchar(999) DEFAULT NULL,
  browser_agent  varchar(999) DEFAULT NULL,
  PRIMARY KEY (pk)
) ENGINE=InnoDB AUTO_INCREMENT=52249 DEFAULT CHARSET=latin1;
--
-- Load data for table 'web_log'
--
LOCK TABLES web_log WRITE;
-- INSERT INTO web_log VALUES (...) 
UNLOCK TABLES;