-- 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;