INSERT INTO `cities` (`id`, `name`, `country_id`, `active`, `lat`, `lng`) VALUES
(6836, 'Denali Park', 217, '0', '63.73309816', '-148.9140994'),
(6837, 'Yakutat', 217, '0', '59.54730715', '-139.7272183'),
(6838, 'Homer', 217, '0', '59.64293439', '-151.5482797'),
(6839, 'Tanacross', 217, '0', '63.38570335', '-143.346403'),
(6840, 'Wiseman', 217, '0', '67.4104706', '-150.1074891'),
(6841, 'Kailua-Kona', 217, '0', '19.6405556', '-155.9955556'),
(6842, 'Butte', 217, '0', '46.0038961', '-112.5338394'),
(6843, 'Grand Forks', 217, '0', '47.92527753', '-97.0324858'),
(6844, 'Pocatello', 217, '0', '42.87134829', '-112.4447234'),
(6845, 'Tacoma', 217, '0', '47.21131594', '-122.5150131'),
(6846, 'Yuma', 217, '0', '32.68527753', '-114.6236084'),
(6847, 'Prescott', 217, '0', '34.59001914', '-112.4477723'),
(6848, 'Long Beach', 217, '0', '33.78696739', '-118.1580439'),
(6849, 'Grand Junction', 217, '0', '39.09385276', '-108.5499998'),
(6850, 'Ely', 217, '0', '39.24702171', '-114.887675'),
(6851, 'Carson City', 217, '0', '39.16384849', '-119.7663953'),
(6852, 'Carlsbad', 217, '0', '32.420565', '-104.2282998'),
(6853, 'Alamogordo', 217, '0', '32.89947634', '-105.9597187'),
(6854, 'Medford', 217, '0', '42.32662701', '-122.8744227'),
(6855, 'Klamath Falls', 217, '0', '42.22500531', '-121.7805359'),
(6856, 'St. George', 217, '0', '37.10415509', '-113.583336'),
(6857, 'Provo', 217, '0', '40.24889854', '-111.63777'),
(6858, 'Laramie', 217, '0', '41.31136599', '-105.5905681'),
(6859, 'Little Rock', 217, '0', '34.73608258', '-92.33109318'),
(6860, 'Wichita', 217, '0', '37.71998313', '-97.32998702'),
(6861, 'Jefferson City', 217, '0', '38.57662335', '-92.17332503'),
(6862, 'Rapid City', 217, '0', '44.08055096', '-103.2305571'),
(6863, 'Lafayette', 217, '0', '30.19997703', '-92.01994938'),
(6864, 'Galveston', 217, '0', '29.301143', '-94.7974801'),
(6865, 'Freeport', 217, '0', '28.95948427', '-95.35687747999999'),
(6866, 'Victoria', 217, '0', '28.80499758', '-97.00334029'),
(6867, 'Odessa', 217, '0', '31.84556134', '-102.3672248'),
(6868, 'Wichita Falls', 217, '0', '33.91362632', '-98.49306848000001'),
(6869, 'Waco', 217, '0', '31.54917116', '-97.14638066000001'),
(6870, 'Lubbock', 217, '0', '33.58000327', '-101.8799677'),
(6871, 'Hartford', 217, '0', '41.77002016', '-72.67996708'),
(6872, 'Providence', 217, '0', '41.82110231', '-71.4149797'),
(6873, 'Birmingham', 217, '0', '33.53000633', '-86.82499516'),
(6874, 'Mobile', 217, '0', '30.68002525', '-88.04998499'),
(6875, 'Pensacola', 217, '0', '30.42112632', '-87.21693506'),
(6876, 'St. Petersburg', 217, '0', '27.77053876', '-82.67938257'),
(6877, 'Biloxi', 217, '0', '30.39580487', '-88.88530867999999'),
(6878, 'Springfield', 217, '0', '39.82000999', '-89.65001651999999'),
(6879, 'Frankfort', 217, '0', '38.2008065', '-84.87335718'),
(6880, 'Greensboro', 217, '0', '36.07000633', '-79.80002344'),
(6881, 'Dayton', 217, '0', '39.750376', '-84.19998742999999'),
(6882, 'Virginia Beach', 217, '0', '36.85321433', '-75.97831873'),
(6883, 'Madison', 217, '0', '43.07301556', '-89.40111699000001'),
(6884, 'Green Bay', 217, '0', '44.5299809', '-88.00001388'),
(6885, 'Trenton', 217, '0', '40.2169625', '-74.74335535'),
(6886, 'Lansing', 217, '0', '42.73352724', '-84.54673629'),
(6887, 'Gambell', 217, '0', '63.77971031', '-171.7310787'),
(6888, 'Palmer', 217, '0', '61.59971417', '-149.1126919'),
(6889, 'Seward', 217, '0', '60.1261607', '-149.4699827'),
(6890, 'Duluth', 217, '0', '46.78333173', '-92.10637822'),
(6891, 'Bemidji', 217, '0', '47.47357383', '-94.88018823'),
(6892, 'Havre', 217, '0', '48.54523968', '-109.6776829'),
(6893, 'Kalispell', 217, '0', '48.19776735', '-114.3159786'),
(6894, 'Idaho Falls', 217, '0', '43.46668662', '-112.0333014'),
(6895, 'Lewiston', 217, '0', '46.41660992', '-117.016589'),
(6896, 'Yakima', 217, '0', '46.60223167', '-120.5046965'),
(6897, 'Wenatchee', 217, '0', '47.42362856', '-120.3090237'),
(6898, 'Douglas', 217, '0', '31.35864016', '-109.5483627'),
(6899, 'Bakersfield', 217, '0', '35.36997154', '-119.0199809'),
(6900, 'Oakland', 217, '0', '37.76892071', '-122.2211034'),
(6901, 'Lancaster', 217, '0', '34.69804873', '-118.135823'),
(6902, 'Chico', 217, '0', '39.72862022', '-121.8363982'),
(6903, 'Monterey', 217, '0', '36.6002582', '-121.8935781'),
(6904, 'Salinas', 217, '0', '36.68221702', '-121.6416555'),
(6905, 'Los Alamos', 217, '0', '35.89110252', '-106.2977084'),
(6906, 'Eugene', 217, '0', '44.05001019', '-123.1000161'),
(6907, 'Coos Bay', 217, '0', '43.36661521', '-124.2165888'),
(6908, 'Bend', 217, '0', '44.071921', '-121.3099962'),
(6909, 'Cody', 217, '0', '44.52321128', '-109.0571007'),
(6910, 'Cedar Rapids', 217, '0', '41.96998212', '-91.66002303'),
(6911, 'Springfield', 217, '0', '37.18001609', '-93.31999922999999'),
(6912, 'Lincoln', 217, '0', '40.81997479', '-96.68000086000001'),
(6913, 'Alexandria', 217, '0', '31.31109784', '-92.44501388'),
(6914, 'Abilene', 217, '0', '32.4486253', '-99.73278609'),
(6915, 'Brownsville', 217, '0', '25.91997988', '-97.50000248000001'),
(6916, 'Tyler', 217, '0', '32.35108604', '-95.30078272'),
(6917, 'Concord', 217, '0', '43.20807192', '-71.53804712'),
(6918, 'Huntsville', 217, '0', '34.71995953', '-86.60999536'),
(6919, 'Key West', 217, '0', '24.55523114', '-81.78274479'),
(6920, 'West Palm Beach', 217, '0', '26.74501996', '-80.12362125999999'),
(6921, 'Sarasota', 217, '0', '27.33612083', '-82.53078699'),
(6922, 'Daytona Beach', 217, '0', '29.21055422', '-81.0230754'),
(6923, 'Gainesville', 217, '0', '29.65138002', '-82.32503727'),
(6924, 'Ft. Myers', 217, '0', '26.64029767', '-81.86049199'),
(6925, 'Brunswick', 217, '0', '31.1496865', '-81.49165145000001'),
(6926, 'Augusta', 217, '0', '33.46081158', '-81.98498051'),
(6927, 'Vicksburg', 217, '0', '32.3524813', '-90.87774520000001'),
(6928, 'Myrtle Beach', 217, '0', '33.68891136', '-78.8869784'),
(6929, 'Charleston', 217, '0', '32.79237693', '-79.99210474'),
(6930, 'Peoria', 217, '0', '40.69998212', '-89.67004114'),
(6931, 'Evansville', 217, '0', '37.97469627', '-87.5558291'),
(6932, 'Louisville', 217, '0', '38.22501691', '-85.74870427'),
(6933, 'Lexington', 217, '0', '38.05001467', '-84.50002078999999'),
(6934, 'Charlotte', 217, '0', '35.20499453', '-80.83003809'),
(6935, 'Youngstown', 217, '0', '41.09969932', '-80.64973902'),
(6936, 'Canton', 217, '0', '40.79886497', '-81.37863509'),
(6937, 'Toledo', 217, '0', '41.67002626', '-83.57997358999999'),
(6938, 'Columbus', 217, '0', '39.97997438', '-82.99000959999999'),
(6939, 'Chattanooga', 217, '0', '35.06998985', '-85.25000086'),
(6940, 'Charlottesville', 217, '0', '38.02918907', '-78.47692591000001'),
(6941, 'Lynchburg', 217, '0', '37.4136194', '-79.14246668'),
(6942, 'Wausau', 217, '0', '44.95915367', '-89.62999189999999'),
(6943, 'Albany', 217, '0', '42.67001691', '-73.81994917999999'),
(6944, 'Ithaca', 217, '0', '42.44057355', '-76.49694340000001'),
(6945, 'Harrisburg', 217, '0', '40.27359987', '-76.88474918999999'),
(6946, 'Bangor', 217, '0', '44.80115297', '-68.77834477'),
(6947, 'Portland', 217, '0', '43.67216158', '-70.2455274'),
(6948, 'Saginaw', 217, '0', '43.4194802', '-83.95082951000001'),
(6949, 'Ketchikan', 217, '0', '55.3562193', '-131.6639895'),
(6950, 'Unalaska', 217, '0', '53.868584', '-166.5316028'),
(6951, 'Togiak', 217, '0', '59.07036101', '-160.3783234'),
(6952, 'Red Devil', 217, '0', '61.76099632', '-157.3125273'),
(6953, 'Hooper Bay', 217, '0', '61.53108787', '-166.0965648'),
(6954, 'Wainwright', 217, '0', '70.63688865', '-160.0383041'),
(6955, 'Galena', 217, '0', '64.73329551', '-156.9269953'),
(6956, 'Kaktovik', 217, '0', '70.08785552000001', '-143.6029132'),
(6957, 'Skagway', 217, '0', '59.45832033', '-135.3138959'),
(6958, 'Cordova', 217, '0', '60.5427761', '-145.7574962'),
(6959, 'Kenai', 217, '0', '60.55435162', '-151.2580131'),
(6960, 'Fort Yukon', 217, '0', '66.56468243', '-145.2737789'),
(6961, 'Santa Cruz', 217, '0', '36.97194629', '-122.0263904'),
(6962, 'San Bernardino', 217, '0', '34.12038373', '-117.3000342'),
(6963, 'Bridgeport', 217, '0', '41.17997866', '-73.19996118'),
(6964, 'Rochester', 217, '0', '43.17042564', '-77.61994979000001'),
(6965, 'International Falls', 217, '0', '48.60112775', '-93.4108464'),
(6966, 'St. Paul', 217, '0', '44.94398663', '-93.08497481000001'),
(6967, 'Billings', 217, '0', '45.78830202', '-108.5400004'),
(6968, 'Great Falls', 217, '0', '47.50029055', '-111.299987'),
(6969, 'Missoula', 217, '0', '46.87224103', '-113.9930526'),
(6970, 'Minot', 217, '0', '48.23249392', '-101.2958173'),
(6971, 'Fargo', 217, '0', '46.8772278', '-96.7894257'),
(6972, 'Hilo', 217, '0', '19.69999778', '-155.0900273'),
(6973, 'Olympia', 217, '0', '47.03804486', '-122.899434'),
(6974, 'Spokane', 217, '0', '47.66999595', '-117.4199494'),
(6975, 'Vancouver', 217, '0', '45.63030133', '-122.6399925'),
(6976, 'Flagstaff', 217, '0', '35.19809572', '-111.6505083'),
(6977, 'Tucson', 217, '0', '32.20499676', '-110.8899862'),
(6978, 'Santa Barbara', 217, '0', '34.43498985', '-119.7199899'),
(6979, 'Fresno', 217, '0', '36.7477169', '-119.7729841'),
(6980, 'Eureka', 217, '0', '40.80222394', '-124.1474974'),
(6981, 'Colorado Springs', 217, '0', '38.86296246', '-104.7919863'),
(6982, 'Reno', 217, '0', '39.52997601', '-119.8200096'),
(6983, 'Elko', 217, '0', '40.83250633', '-115.7619886'),
(6984, 'Albuquerque', 217, '0', '35.10497479', '-106.6413308'),
(6985, 'Salem', 217, '0', '44.92807029', '-123.0238967'),
(6986, 'Casper', 217, '0', '42.86661989', '-106.3124878'),
(6987, 'Topeka', 217, '0', '39.05000531', '-95.66998499'),
(6988, 'Kansas City', 217, '0', '39.10708851', '-94.60409421999999'),
(6989, 'Tulsa', 217, '0', '36.12000327', '-95.93002079'),
(6990, 'Sioux Falls', 217, '0', '43.54998903', '-96.72999780000001'),
(6991, 'Shreveport', 217, '0', '32.50001752', '-93.77002344'),
(6992, 'Baton Rouge', 217, '0', '30.45794578', '-91.14015812'),
(6993, 'Ft. Worth', 217, '0', '32.73997703', '-97.34003808999999'),
(6994, 'Corpus Christi', 217, '0', '27.74281435', '-97.40189478000001'),
(6995, 'Austin', 217, '0', '30.26694969', '-97.74277836'),
(6996, 'Amarillo', 217, '0', '35.22998008', '-101.8299966'),
(6997, 'El Paso', 217, '0', '31.77998395', '-106.5099952'),
(6998, 'Laredo', 217, '0', '27.50613629', '-99.50721847'),
(6999, 'Burlington', 217, '0', '44.47579816', '-73.21246687999999'),
(7000, 'Montgomery', 217, '0', '32.36160219', '-86.27918868'),
(7001, 'Tallahassee', 217, '0', '30.44998761', '-84.28003422'),
(7002, 'Orlando', 217, '0', '28.50997683', '-81.38003036000001'),
(7003, 'Jacksonville', 217, '0', '30.33002077', '-81.66998682000001'),
(7004, 'Savannah', 217, '0', '32.02110618', '-81.10999516'),
(7005, 'Columbia', 217, '0', '34.0399752', '-80.89998214000001'),
(7006, 'Indianapolis', 217, '0', '39.74998842', '-86.17004806'),
(7007, 'Wilmington', 217, '0', '34.22551943', '-77.94502039'),
(7008, 'Knoxville', 217, '0', '35.97001243', '-83.92003036'),
(7009, 'Richmond', 217, '0', '37.55001935', '-77.449986'),
(7010, 'Charleston', 217, '0', '38.34973798', '-81.63272811'),
(7011, 'Baltimore', 217, '0', '39.29999005', '-76.61998499000001'),
(7012, 'Syracuse', 217, '0', '43.04999371', '-76.15001367000001'),
(7013, 'Augusta', 217, '0', '44.31056276', '-69.77998906000001'),
(7014, 'Sault Ste. Marie', 217, '0', '46.49526145', '-84.34527572'),
(7015, 'Sitka', 217, '0', '57.06039769', '-135.3275494'),
(7016, 'Helena', 217, '0', '46.59274904', '-112.035291'),
(7017, 'Bismarck', 217, '0', '46.80831728', '-100.7833163'),
(7018, 'Boise', 217, '0', '43.60859011', '-116.2274899'),
(7019, 'San Jose', 217, '0', '37.29998293', '-121.8499891'),
(7020, 'Sacramento', 217, '0', '38.57502138', '-121.4700381'),
(7021, 'Las Vegas', 217, '0', '36.20999778', '-115.2200061'),
(7022, 'Santa Fe', 217, '0', '35.68692893', '-105.9372394'),
(7023, 'Portland', 217, '0', '45.52002382', '-122.6799901'),
(7024, 'Salt Lake City', 217, '0', '40.7750163', '-111.9300519'),
(7025, 'Cheyenne', 217, '0', '41.14000694', '-104.8197107'),
(7026, 'Des Moines', 217, '0', '41.57998008', '-93.61998092'),
(7027, 'Omaha', 217, '0', '41.24000083', '-96.00999007'),
(7028, 'Oklahoma City', 217, '0', '35.47004295', '-97.51868351'),
(7029, 'Pierre', 217, '0', '44.36833701', '-100.350552'),
(7030, 'San Antonio', 217, '0', '29.48733319', '-98.50730534'),
(7031, 'Jackson', 217, '0', '32.29881533', '-90.18499679'),
(7032, 'Raleigh', 217, '0', '35.81878135', '-78.64469344'),
(7033, 'Cleveland', 217, '0', '41.4699868', '-81.69499820999999'),
(7034, 'Cincinnati', 217, '0', '39.16188479', '-84.45692265'),
(7035, 'Nashville', 217, '0', '36.16997438', '-86.77998499'),
(7036, 'Memphis', 217, '0', '35.1199868', '-89.99999516'),
(7037, 'Norfolk', 217, '0', '36.84995872', '-76.28000573999999'),
(7038, 'Milwaukee', 217, '0', '43.05265505', '-87.91996708000001'),
(7039, 'Buffalo', 217, '0', '42.87997825', '-78.88000208'),
(7040, 'Pittsburgh', 217, '0', '40.4299986', '-79.99998539000001'),
(7041, 'Kodiak', 217, '0', '57.78999839', '-152.4069869'),
(7042, 'Cold Bay', 217, '0', '55.20000144', '-162.7150916'),
(7043, 'Bethel', 217, '0', '60.79330345', '-161.7557961'),
(7044, 'Point Hope', 217, '0', '68.34772605000001', '-166.8080201'),
(7045, 'Barrow', 217, '0', '71.29056968', '-156.78858'),
(7046, 'Nome', 217, '0', '64.50610008', '-165.4063744'),
(7047, 'Valdez', 217, '0', '61.13599571', '-146.348287'),
(7048, 'Juneau', 217, '0', '58.31412661', '-134.419997'),
(7049, 'Fairbanks', 217, '0', '64.83698427', '-147.7106586'),
(7050, 'Prudhoe Bay', 217, '0', '70.29218100999999', '-148.6693598'),
(7051, 'Minneapolis', 217, '0', '44.97997927', '-93.25178634'),
(7052, 'Honolulu', 217, '0', '21.30687644', '-157.8579979'),
(7053, 'Seattle', 217, '0', '47.57000205', '-122.339985'),
(7054, 'Phoenix', 217, '0', '33.53997988', '-112.0699917'),
(7055, 'San Diego', 217, '0', '32.82002382', '-117.1799899'),
(7056, 'St. Louis', 217, '0', '38.63501772', '-90.23998051'),
(7057, 'New Orleans', 217, '0', '29.99500246', '-90.03996687999999'),
(7058, 'Dallas', 217, '0', '32.82002382', '-96.84001693'),
(7059, 'Boston', 217, '0', '42.32996014', '-71.07001366999999'),
(7060, 'Tampa', 217, '0', '27.94698793', '-82.45862085'),
(7061, 'Philadelphia', 217, '0', '39.99997316', '-75.16999597'),
(7062, 'Detroit', 217, '0', '42.32996014', '-83.08005579'),
(7063, 'Anchorage', 217, '0', '61.21996991', '-149.9002149'),
(7064, 'San Francisco', 217, '0', '37.74000775', '-122.4599777'),
(7065, 'Denver', 217, '0', '39.73918805', '-104.984016'),
(7066, 'Houston', 217, '0', '29.81997438', '-95.33997929'),
(7067, 'Miami', 217, '0', '25.7876107', '-80.22410608'),
(7068, 'Atlanta', 217, '0', '33.83001385', '-84.39994938'),
(7069, 'Chicago', 217, '0', '41.82999066', '-87.75005496999999'),
(7070, 'Los Angeles', 217, '0', '33.98997825', '-118.1799805'),
(7071, 'Washington, D.C.', 217, '0', '38.89954938', '-77.00941858'),
(7072, 'New York', 217, '0', '40.74997906', '-73.98001693000001'),
(7073, 'Christiansted', 224, '0', '17.75037518', '-64.74998600000001'),
(7074, 'Colonia del Sacramento', 218, '0', '-34.47999901', '-57.84000247'),
(7075, 'Trinidad', 218, '0', '-33.54399894', '-56.90099656'),
(7076, 'Fray Bentos', 218, '0', '-33.13899903', '-58.30399747'),
(7077, 'Canelones', 218, '0', '-34.53800401', '-56.28400149'),
(7078, 'Florida', 218, '0', '-34.09900201', '-56.21499845'),
(7079, 'Artigas', 218, '0', '-30.41598712', '-56.48602014'),
(7080, 'Baltasar Brum', 218, '0', '-30.7300248', '-57.31997441'),
(7081, 'Tranqueras', 218, '0', '-31.20002195', '-55.74996688'),
(7082, 'Tacuarembo', 218, '0', '-31.70996499', '-55.98000452'),
(7083, 'Paso de los Toros', 218, '0', '-32.8100012', '-56.51004968'),
(7084, 'Vergara', 218, '0', '-32.92999388', '-53.94999923'),
(7085, 'Treinta y Tres', 218, '0', '-33.23002724', '-54.38002466'),
(7086, 'Santa Lucia', 218, '0', '-34.47000324', '-56.39997888'),
(7087, 'Jose Batlle y Ordonez', 218, '0', '-33.47001259', '-55.12000533'),
(7088, 'Minas', 218, '0', '-34.37000934', '-55.23002446'),
(7089, 'Maldonado', 218, '0', '-34.91002806', '-54.95998926'),
(7090, 'Punta del Este', 218, '0', '-34.96997272', '-54.94998987'),
(7091, 'Aigua', 218, '0', '-34.19999388', '-54.75000208'),
(7092, 'La Paloma', 218, '0', '-34.66999103', '-54.1699858'),
(7093, 'Carmelo', 218, '0', '-33.98961912', '-58.29999211'),
(7094, 'Bella Union', 218, '0', '-30.25961424', '-57.59995732'),
(7095, 'Mercedes', 218, '0', '-33.25953449', '-58.02998275'),
(7096, 'Melo', 218, '0', '-32.35948606', '-54.17998519'),
(7097, 'Rivera', 218, '0', '-30.89957518', '-55.56000431'),
(7098, 'Lascano', 218, '0', '-33.66958698', '-54.20000981'),
(7099, 'Castillos', 218, '0', '-34.16960814', '-53.82998071'),
(7100, 'San Jose de Mayo', 218, '0', '-34.34995888', '-56.7099858'),
(7101, 'Rocha', 218, '0', '-34.48297402', '-54.33302494'),
(7102, 'Paysandu', 218, '0', '-32.32997882', '-58.0799797'),
(7103, 'Salto', 218, '0', '-31.39034625', '-57.9686945'),
(7104, 'Durazno', 218, '0', '-33.41001626', '-56.51004968'),
(7105, 'Montevideo', 218, '0', '-34.85804157', '-56.17105229'),
(7106, 'Khujayli', 219, '0', '42.4047101', '59.45165767'),
(7107, 'Urgut', 219, '0', '39.40070742', '67.26069006'),
(7108, 'Kattaqorgon', 219, '0', '39.90070274', '66.26075109999999'),
(7109, 'Denow', 219, '0', '38.27715843', '67.88716345'),
(7110, 'Guliston', 219, '0', '40.49573102', '68.79072587'),
(7111, 'Iskandar', 219, '0', '41.55073122', '69.68074906'),
(7112, 'Chirchiq', 219, '0', '41.45497479', '69.55998124'),
(7113, 'Kogon', 219, '0', '39.72107546', '64.54576534'),
(7114, 'Khiwa', 219, '0', '41.39112856', '60.35573686'),
(7115, 'Chimboy', 219, '0', '42.93113792', '59.77075964'),
(7116, 'Qunghirot', 219, '0', '43.0704059', '58.90001176'),
(7117, 'Zarafshon', 219, '0', '41.58222801', '64.20180701'),
(7118, 'Navoi', 219, '0', '40.1104057', '65.35496659'),
(7119, 'Shahrisabz', 219, '0', '39.06178754', '66.83146562'),
(7120, 'Qarshi', 219, '0', '38.87042971', '65.80000403'),
(7121, 'Qoqon', 219, '0', '40.54040529', '70.94000037000001'),
(7122, 'Jizzax', 219, '0', '40.10038047', '67.83000932'),
(7123, 'Angren', 219, '0', '41.03037539', '70.15493201'),
(7124, 'Olmaliq', 219, '0', '40.85043805', '69.59501786'),
(7125, 'Muynoq', 219, '0', '43.76832196', '59.0213997'),
(7126, 'Termiz', 219, '0', '37.23293276', '67.27293738'),
(7127, 'Fargona', 219, '0', '40.3899752', '71.78000077'),
(7128, 'Namangan', 219, '0', '41.00001548', '71.66998165'),
(7129, 'Urgentch', 219, '0', '41.5599813', '60.64000891'),
(7130, 'Bukhara', 219, '0', '39.78001243', '64.43001013'),
(7131, 'Nukus', 219, '0', '42.47000327', '59.61500688'),
(7132, 'Andijon', 219, '0', '40.79000246', '72.33996659'),
(7133, 'Samarqand', 219, '0', '39.67001914', '66.94499874'),
(7134, 'Tashkent', 219, '0', '41.31170188', '69.29493282'),
(7135, 'Luganville', 220, '0', '-15.51255573', '167.1766068'),
(7136, 'Port Vila', 220, '0', '-17.7333504', '168.3166406'),
(7137, 'Vatican City', 0, '0', '41.90001223', '12.44780839'),
(7138, 'San Carlos', 221, '0', '9.657999007000001', '-68.58999854'),
(7139, 'San Felipe', 221, '0', '10.33599598', '-68.74599551999999'),
(7140, 'San Juan De Los Morros', 221, '0', '9.900999019', '-67.35400159'),
(7141, 'La Asuncion', 221, '0', '11.03333403', '-63.8833315'),
(7142, 'Guasdualito', 221, '0', '7.239983133', '-70.73998214'),
(7143, 'Barinas', 221, '0', '8.599977640000001', '-70.25001205'),
(7144, 'Valera', 221, '0', '9.319959533', '-70.62001530000001'),
(7145, 'Cabimas', 221, '0', '10.42999514', '-71.44999048'),
(7146, 'Carora', 221, '0', '10.18998395', '-70.07999658'),
(7147, 'Guanare', 221, '0', '9.049976012', '-69.75001673'),
(7148, 'Puerto la Cruz', 221, '0', '10.16995933', '-64.68001612'),
(7149, 'Anaco', 221, '0', '9.440003884999999', '-64.4600037'),
(7150, 'Los Teques', 221, '0', '10.41996991', '-67.02002831999999'),
(7151, 'Valle de la Pascua', 221, '0', '9.209992085', '-66.019986'),
(7152, 'Ocumare del Tuy', 221, '0', '10.11998822', '-66.77999129'),
(7153, 'Carupano', 221, '0', '10.67000633', '-63.23000126'),
(7154, 'Trujillo', 221, '0', '9.380395119999999', '-70.44000045'),
(7155, 'Santa Rita', 221, '0', '10.53182698', '-71.50394901999999'),
(7156, 'Machiques', 221, '0', '10.07043052', '-72.54994918'),
(7157, 'San Carlos del Zulia', 221, '0', '9.010391865000001', '-71.91998762999999'),
(7158, 'Puerto Cabello', 221, '0', '10.47043194', '-68.17000981'),
(7159, 'Acarigua', 221, '0', '9.580382912999999', '-69.20002445999999'),
(7160, 'Upata', 221, '0', '8.020426452000001', '-62.40999964'),
(7161, 'El Manteco', 221, '0', '7.35038983', '-62.53332544'),
(7162, 'Chaguaramas', 221, '0', '9.215934874', '-63.75226913'),
(7163, 'Barcelona', 221, '0', '10.13037518', '-64.72001367'),
(7164, 'El Tigre', 221, '0', '8.890347513', '-64.26001591000001'),
(7165, 'Maiquetia', 221, '0', '10.60039817', '-66.9699797'),
(7166, 'Calabozo', 221, '0', '8.930396748', '-67.43997684999999'),
(7167, 'Zaraza', 221, '0', '9.340397562', '-65.32000289'),
(7168, 'Altagracia de Orituco', 221, '0', '9.85041811', '-66.37998987'),
(7169, 'Tucupita', 221, '0', '9.060492166', '-62.05999516'),
(7170, 'Porlamar', 221, '0', '10.9603762', '-63.84998926'),
(7171, 'San Fernando de Apure', 221, '0', '7.899994526', '-67.46994918'),
(7172, 'Barquisimeto', 221, '0', '10.04999249', '-69.29996668'),
(7173, 'Maturin', 221, '0', '9.749959126', '-63.17003076'),
(7174, 'Cumana', 221, '0', '10.44999392', '-64.18002079'),
(7175, 'Coro', 221, '0', '11.42001223', '-69.67999516'),
(7176, 'Punto Fijo', 221, '0', '11.71999392', '-70.21001449000001'),
(7177, 'La Esmeralda', 221, '0', '3.173823058', '-65.54660405'),
(7178, 'Ciudad Bolivar', 221, '0', '8.099982319', '-63.60000452'),
(7179, 'El Dorado', 221, '0', '6.733295714', '-61.6333287'),
(7180, 'Maracay', 221, '0', '10.2468797', '-67.59580713'),
(7181, 'Merida', 221, '0', '8.399989847000001', '-71.13001001000001'),
(7182, 'Puerto Ayacucho', 221, '0', '5.663903624', '-67.62360905'),
(7183, 'San Cristobal', 221, '0', '7.770002461', '-72.24996749'),
(7184, 'Valencia', 221, '0', '10.22998151', '-67.9800214'),
(7185, 'Ciudad Guayana', 221, '0', '8.370017516000001', '-62.61998682'),
(7186, 'Maracaibo', 221, '0', '10.72997683', '-71.65997766'),
(7187, 'Caracas', 221, '0', '10.50099855', '-66.91703719'),
(7188, 'Tay Ninh', 222, '0', '11.32299911', '106.1469997'),
(7189, 'Luan Chau', 222, '0', '21.74000399', '103.3430047'),
(7190, 'Bac Kan', 222, '0', '22.1333333', '105.8333333'),
(7191, 'Lang Son', 222, '0', '21.8459971', '106.7570016'),
(7192, 'Son La', 222, '0', '21.32800214', '103.9100047'),
(7193, 'Tuyen Quang', 222, '0', '21.8179981', '105.2109996'),
(7194, 'Yen Bai', 222, '0', '21.70500304', '104.8750026'),
(7195, 'Hai Duong', 222, '0', '20.94200108', '106.3310046'),
(7196, 'Thai Binh', 222, '0', '20.45030412', '106.3330296'),
(7197, 'Tuy Hoa', 222, '0', '13.08200402', '109.3159987'),
(7198, 'Thu Dau Mot', 222, '0', '10.96907408', '106.6527455'),
(7199, 'Dong Ha', 222, '0', '16.8499981', '107.1333007'),
(7200, 'Cao Lanh', 222, '0', '10.46700013', '105.6359976'),
(7201, 'Truc Giang', 222, '0', '10.234998', '106.3749966'),
(7202, 'Tra Vinh', 222, '0', '9.934002087', '106.3340017'),
(7203, 'Vinh Long', 222, '0', '10.256004', '105.9640026'),
(7204, 'Cao Bang', 222, '0', '22.66399806', '106.2680046'),
(7205, 'Hong Gai', 222, '0', '20.9604118', '107.1000154'),
(7206, 'Cam Pha', 222, '0', '21.04043276', '107.320002'),
(7207, 'Lao Chi', 222, '0', '22.50135134', '103.9659948'),
(7208, 'Hoa Binh', 222, '0', '20.81370241', '105.3383142'),
(7209, 'Son Tay', 222, '0', '21.13817873', '105.5050223'),
(7210, 'Ninh Binh', 222, '0', '20.25430503', '105.9750195'),
(7211, 'Viet Tri', 222, '0', '21.33041506', '105.4299882'),
(7212, 'Bac Giang', 222, '0', '21.26700808', '106.2000187'),
(7213, 'Ha Tinh', 222, '0', '18.33377626', '105.900037'),
(7214, 'Buon Me Thuot', 222, '0', '12.66704205', '108.0499833'),
(7215, 'Da Lat', 222, '0', '11.93042035', '108.4199865'),
(7216, 'Phan Rang', 222, '0', '11.56703168', '108.9833113'),
(7217, 'Hon Quan', 222, '0', '11.65038576', '106.6000459'),
(7218, 'Kon Tum', 222, '0', '14.38375897', '107.9833207'),
(7219, 'Quang Ngai', 222, '0', '15.15043052', '108.8299873'),
(7220, 'Quang Tri', 222, '0', '16.7503587', '107.2000093'),
(7221, 'Vung Tau', 222, '0', '10.35537437', '107.0849776'),
(7222, 'Phan Thiet', 222, '0', '10.933737', '108.1000577'),
(7223, 'Long Xuyen', 222, '0', '10.38038576', '105.4200146'),
(7224, 'Chau Doc', 222, '0', '10.70039207', '105.1166739'),
(7225, 'Rach Gia', 222, '0', '10.01539512', '105.0913525'),
(7226, 'Tan An', 222, '0', '10.53373557', '106.416698'),
(7227, 'My Tho', 222, '0', '10.35041343', '106.3500354'),
(7228, 'Bac Lieu', 222, '0', '9.280375384999999', '105.7199963'),
(7229, 'Ca Mau', 222, '0', '9.177358418000001', '105.1500052'),
(7230, 'Soc Trang', 222, '0', '9.603740661', '105.9800321'),
(7231, 'Ha Giang', 222, '0', '22.83365664', '104.9833488'),
(7232, 'Thai Nguyen', 222, '0', '21.59995933', '105.8300154'),
(7233, 'Thanh Hoa', 222, '0', '19.8200163', '105.7999914'),
(7234, 'Nam Dinh', 222, '0', '20.42003135', '106.2000187'),
(7235, 'Vinh', 222, '0', '18.6999813', '105.6799987'),
(7236, 'Dong Hoi', 222, '0', '17.48333722', '106.6000459'),
(7237, 'Play Ku', 222, '0', '13.98329246', '108.0000122'),
(7238, 'Nha Trang', 222, '0', '12.25003908', '109.1700183'),
(7239, 'Cam Ranh', 222, '0', '11.90202415', '109.2206612'),
(7240, 'Qui Nhon', 222, '0', '13.77997154', '109.1800435'),
(7241, 'Hue', 222, '0', '16.46998822', '107.5800378'),
(7242, 'Bien Hoa', 222, '0', '10.97001385', '106.8300577'),
(7243, 'Can Tho', 222, '0', '10.04999249', '105.7700191'),
(7244, 'Haiphong', 222, '0', '20.83000633', '106.6800927'),
(7245, 'Da Nang', 222, '0', '16.06003908', '108.2499711'),
(7246, 'Hanoi', 222, '0', '21.03332725', '105.8500142'),
(7247, 'Ho Chi Minh City', 222, '0', '10.78002545', '106.6950272'),
(7248, 'Bir Lehlou', 226, '0', '26.11916669', '-9.652522218'),
(7249, 'Al Bayda', 227, '0', '13.9789981', '45.57400265'),
(7250, '\'Ataq', 227, '0', '14.55000311', '46.80000058'),
(7251, 'Marib', 227, '0', '15.42099607', '45.33399954'),
(7252, 'Dhamar', 227, '0', '14.5574693', '44.3874609'),
(7253, 'Ibb', 227, '0', '13.97585105', '44.17088497'),
(7254, 'Ash Shihr', 227, '0', '14.75931744', '49.60915767'),
(7255, 'Zabid', 227, '0', '14.19508832', '43.31553666'),
(7256, 'Hajjah', 227, '0', '15.69174115', '43.60213415'),
(7257, 'Lahij', 227, '0', '13.05818097', '44.88376135'),
(7258, 'Al Ghaydah', 227, '0', '16.23940798', '52.1637821'),
(7259, 'Rida', 227, '0', '14.42949261', '44.8341003'),
(7260, 'Hadiboh', 227, '0', '12.65187502', '54.02392696'),
(7261, 'Saywun', 227, '0', '15.94299196', '48.78734737'),
(7262, 'Sadah', 227, '0', '16.93977867', '43.84976762'),
(7263, 'Al Hudaydah', 227, '0', '14.79794558', '42.95297481'),
(7264, 'Sayhut', 227, '0', '15.21050437', '51.24544023'),
(7265, 'Al Mukalla', 227, '0', '14.54116538', '49.12593135'),
(7266, 'Taizz', 227, '0', '13.60445253', '44.03942012'),
(7267, 'Aden', 227, '0', '12.77972251', '45.00949011'),
(7268, 'Sanaa', 227, '0', '15.3547333', '44.20659338'),
(7269, 'Kawambwa', 229, '0', '-9.779520651', '29.08002315'),
(7270, 'Nchelenge', 229, '0', '-9.349572735000001', '28.73001868'),
(7271, 'Chinsali', 229, '0', '-10.54960285', '32.0599963'),
(7272, 'Kasama', 229, '0', '-10.19959837', '31.17994665'),
(7273, 'Kapiri Mposhi', 229, '0', '-13.96960081', '28.65999711'),
(7274, 'Mumbwa', 229, '0', '-14.97961668', '27.07001664'),
(7275, 'Chingola', 229, '0', '-12.53961058', '27.85002071'),
(7276, 'Chililabombwe', 229, '0', '-12.36959511', '27.8199967'),
(7277, 'Nyimba', 229, '0', '-14.54951373', '30.80999508'),
(7278, 'Lundazi', 229, '0', '-12.28954832', '33.17000606'),
(7279, 'Chipata', 229, '0', '-13.62956989', '32.64001257'),
(7280, 'Mwinilunga', 229, '0', '-11.73955605', '24.4399963'),
(7281, 'Kasempa', 229, '0', '-13.4596061', '25.82001542'),
(7282, 'Solwezi', 229, '0', '-12.17958087', '26.39998002'),
(7283, 'Choma', 229, '0', '-16.80947915', '26.97002274'),
(7284, 'Mongu', 229, '0', '-15.27959837', '23.12002519'),
(7285, 'Kaoma', 229, '0', '-14.77962889', '24.79997432'),
(7286, 'Sesheke', 229, '0', '-17.46954222', '24.30000484'),
(7287, 'Lukulu', 229, '0', '-14.38957518', '23.24001786'),
(7288, 'Kalabo', 229, '0', '-14.98959023', '22.68000036'),
(7289, 'Senanga', 229, '0', '-16.11959878', '23.27004187'),
(7290, 'Mansa', 229, '0', '-11.20000242', '28.89000891'),
(7291, 'Mpika', 229, '0', '-11.83004148', '31.45998124'),
(7292, 'Mbala', 229, '0', '-8.840043112', '31.37001257'),
(7293, 'Luanshya', 229, '0', '-13.13332111', '28.40001298'),
(7294, 'Ndola', 229, '0', '-12.99994424', '28.65002356'),
(7295, 'Zambezi', 229, '0', '-13.54001463', '23.10994828'),
(7296, 'Kafue', 229, '0', '-15.78003294', '28.18002641'),
(7297, 'Mazabuka', 229, '0', '-15.86002806', '27.76000036'),
(7298, 'Kabwe', 229, '0', '-14.44001137', '28.44998409'),
(7299, 'Mufulira', 229, '0', '-12.54999754', '28.25996985'),
(7300, 'Kitwe', 229, '0', '-12.81003335', '28.22002397'),
(7301, 'Livingstone', 229, '0', '-17.86000934', '25.86001298'),
(7302, 'Lusaka', 229, '0', '-15.41664427', '28.28332759'),
(7303, 'Mazowe', 230, '0', '-17.51961668', '30.97003699'),
(7304, 'Shamva', 230, '0', '-17.31962889', '31.57000036'),
(7305, 'Victoria Falls', 230, '0', '-17.92961749', '25.8400142'),
(7306, 'Zvishavane', 230, '0', '-20.32957436', '30.04998979'),
(7307, 'Kwekwe', 230, '0', '-18.92960814', '29.79997921'),
(7308, 'Plumtree', 230, '0', '-20.47953937', '27.8199967'),
(7309, 'Beitbridge', 230, '0', '-22.20961465', '29.98999345'),
(7310, 'Gwanda', 230, '0', '-20.93961465', '29.01000159'),
(7311, 'Chiredzi', 230, '0', '-21.04958209', '31.66002071'),
(7312, 'Masvingo', 230, '0', '-20.05961668', '30.8200203'),
(7313, 'Karoi', 230, '0', '-16.81955605', '29.67998653'),
(7314, 'Chinhoyi', 230, '0', '-17.35962645', '30.18000769'),
(7315, 'Kariba', 230, '0', '-16.52959959', '28.80004024'),
(7316, 'Hwange', 230, '0', '-18.37000405', '26.50002559'),
(7317, 'Gweru', 230, '0', '-19.45004148', '29.82002966'),
(7318, 'Mutare', 230, '0', '-18.97001911', '32.6500378'),
(7319, 'Kadoma', 230, '0', '-18.33000649', '29.90994665'),
(7320, 'Chitungwiza', 230, '0', '-18.00000079', '31.10000321'),
(7321, 'Harare', 230, '0', '-17.81778969', '31.04470943'),
(7322, 'Bulawayo', 230, '0', '-20.16999754', '28.58000199');

-- --------------------------------------------------------

--
-- Cấu trúc bảng cho bảng `contacts`
--

CREATE TABLE `contacts` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Đang đổ dữ liệu cho bảng `contacts`
--

INSERT INTO `contacts` (`id`, `name`, `email`, `comment`, `created_at`, `updated_at`) VALUES
(25, 'Gordon Wanttie', 'Glw1953@centurylink.net', 'I want to reset the Sunset time from 24 hr to 12 hr  format. Now it shows at 4pm.  1600 hrs. Want 4 pm. How kan that be done. \r\nThx. Gordy', '2018-11-26 06:15:44', '2018-11-26 06:15:44');

-- --------------------------------------------------------

--
-- Cấu trúc bảng cho bảng `countries`
--

CREATE TABLE `countries` (
  `id` int(11) NOT NULL,
  `code` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `name` varchar(150) COLLATE utf8_unicode_ci NOT NULL,
  `lat` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `lng` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `color` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '#ccc',
  `name_file_js` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `active` enum('0','1') COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `param` int(11) NOT NULL DEFAULT '-1'
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Đang đổ dữ liệu cho bảng `countries`
--

INSERT INTO `countries` (`id`, `code`, `name`, `lat`, `lng`, `color`, `name_file_js`, `active`, `param`) VALUES
(1, 'af', 'Afghanistan', '33', '65', '#e8c76a', 'afghanistanHigh', '1', -1),
(2, 'al', 'Albania', '41', '20', '#ccc', 'albaniaHigh', '1', -1),
(3, 'dz', 'Algeria', '28', '3', '#ECC46F', 'algeriaHigh', '1', -1),
(4, 'ad', 'Andorra', '42.5', '1.5', '#ccc', 'worldRussiaSplitWithAntarcticaHigh', '1', -1),
(5, 'ao', 'Angola', '-12.5', '18.5', '#F9C1C0', 'angolaHigh', '1', -1),
(6, 'ai', 'Anguilla', '18.25', '-63.17', '#ccc', 'anguillaHigh', '1', -1),
(7, 'ag', 'Antigua and Barbuda', '17.05', '-61.8', '#ccc', 'antiguaBarbudaHigh', '1', -1),
(8, 'ar', 'Argentina', '-34', '-64', '#E2E783', 'argentinaHigh', '1', -1),
(9, 'am', 'Armenia', '40', '45', '#ccc', 'azerbaijanHigh', '1', -1),
(10, 'aw', 'Aruba', '12.5', '-69.97', '#ccc', 'venezuelaHigh', '1', -1),
(11, 'au', 'Australia', '-27', '133', '#f4c6c6', 'australiaLow', '1', -1),
(12, 'at', 'Austria', '47.33', '13.33', '#ccc', 'austriaHigh', '1', -1),
(13, 'az', 'Azerbaijan', '40.5', '47.5', '#ccc', 'azerbaijanHigh', '1', -1),
(14, 'bs', 'Bahamas', '24.25', '-76', '#ccc', 'bahamasHigh', '1', -1),
(15, 'bh', 'Bahrain', '26', '50.55', '#ccc', 'bahrainHigh', '1', -1),
(16, 'bd', 'Bangladesh', '24', '90', '#D9B5D5', 'bangladeshHigh', '1', -1),
(17, 'bb', 'Barbados', '13.17', '-59.53', '#ccc', 'barbadosHigh', '1', -1),
(18, 'by', 'Belarus', '53', '28', '#c5dd7f', 'belarusHigh', '1', -1),
(19, 'be', 'Belgium', '50.83', '4', '#ccc', 'belgiumHigh', '1', -1),
(20, 'bz', 'Belize', '17.25', '-88.75', '#ccc', 'belizeHigh', '1', -1),
(21, 'bj', 'Benin', '9.5', '2.25', '#ccc', 'beninHigh', '1', -1),
(22, 'bm', 'Bermuda', '32.33', '-64.75', '#ccc', 'bermudaHigh', '1', -1),
(23, 'bt', 'Bhutan', '27.5', '90.5', '#ccc', 'bhutanHigh', '1', -1),
(24, 'bo', 'Bolivia', '-17', '-65', '#B7CC77', 'boliviaHigh', '1', -1),
(25, 'ba', 'Bosnia and Herzegovina', '44', '18', '#ECC46F', 'bosniaHerzegovinaRegionsHigh', '1', -1),
(26, 'bw', 'Botswana', '-22', '24', '#e8c76a', 'botswanaHigh', '1', -1),
(27, 'br', 'Brazil', '-10', '-55', '#efb4b4', 'brazilHigh', '1', -1),
(28, 'bn', 'Brunei Darussalam', '4.5', '114.67', '#ccc', 'malaysiaHigh', '1', -1),
(29, 'bg', 'Bulgaria', '43', '25', '#BCD184', 'bulgariaHigh', '1', -1),
(30, 'bf', 'Burkina Faso', '13', '-2', '#efb4b4', 'burkinaFasoHigh', '1', -1),
(31, 'bi', 'Burundi', '-3.5', '30', '#ccc', 'burundiHigh', '1', -1),
(32, 'kh', 'Cambodia', '13', '105', '#ccc', 'cambodiaHigh', '1', -1),
(33, 'cm', 'Cameroon', '6', '12', '#ccc', 'cameroonHigh', '1', -1),
(34, 'ca', 'Canada', '60', '-95', '#E1A1A1', 'canadaHigh', '1', -1),
(35, 'cv', 'Cape Verde', '16', '-24', '#ccc', 'capeVerdeHigh', '1', -1),
(36, 'ky', 'Cayman Islands', '19.5', '-80.5', '#ccc', 'caymanIslandsHigh', '1', -1),
(37, 'cf', 'Central African Republic', '7', '21', '#ccc', 'centralAfricanRepublicHigh', '1', -1),
(38, 'td', 'Chad', '15', '19', '#F9C1C0', 'chadHigh', '1', -1),
(39, 'cl', 'Chile', '-30', '-71', '#e8c76a', 'chileHigh', '1', -1),
(40, 'cn', 'China', '35', '105', '#F9C1C0', 'chinaHigh', '1', -1),
(41, 'cx', 'Christmas Island', '-10.5', '105.67', '#ccc', 'christmasIslandHigh', '1', -1),
(42, 'cc', 'Cocos (Keeling) Islands', '-12.5', '96.83', '#ccc', 'cocosIslandsHigh', '1', -1),
(43, 'co', 'Colombia', '4', '-72', '#B7CC77', 'colombiaHigh', '1', -1),
(44, 'km', 'Comoros', '-12.17', '44.25', '#ccc', 'comorosHigh', '1', -1),
(45, 'cg', 'Congo', '-1', '15', '#c5dd7f', 'congoHigh', '1', -1),
(46, 'ck', 'Cook Islands', '-21.23', '-159.77', '#ccc', 'cookIslandsHigh', '1', -1),
(47, 'cr', 'Costa Rica', '10', '-84', '#ccc', 'costaRicaHigh', '1', -1),
(48, 'ci', 'Cote D\'Ivoire (Ivory Coast)', '8', '-5', '#c5dd7f', 'ivoryCoastHigh', '1', -1),
(49, 'hr', 'Croatia (Hrvatska)', '45.17', '15.5', '#ccc', 'croatiaHigh', '1', -1),
(50, 'cu', 'Cuba', '21.5', '-80', '#ccc', 'cubaHigh', '1', -1),
(51, 'cy', 'Cyprus', '35', '33', '#ccc', 'cyprusHigh', '1', -1),
(52, 'cz', 'Czech Republic', '49.75', '15.5', '#c5dd7f', 'czechRepublicHigh', '1', -1),
(53, 'cd', 'Democratic Republic of the Congo', '0', '25', '#c5dd7f', 'congoDRHigh', '1', -1),
(54, 'dk', 'Denmark', '56', '10', '#D6AE6B', 'denmarkHigh', '1', -1),
(55, 'dj', 'Djibouti', '11.5', '43', '#ccc', 'djiboutiHigh', '1', -1),
(56, 'dm', 'Dominica', '15.42', '-61.33', '#ccc', 'dominicaHigh', '1', -1),
(57, 'do', 'Dominican Republic', '19', '-70.67', '#ccc', 'dominicanRepublicHigh', '1', -1),
(58, 'ec', 'Ecuador', '-2', '-77.5', '#ccc', 'ecuadorHigh', '1', -1),
(59, 'eg', 'Egypt', '27', '30', '#e3efbd', 'egyptHigh', '1', -1),
(60, 'sv', 'El Salvador', '13.83', '-88.92', '#ccc', 'elSalvadorHigh', '1', -1),
(61, 'gq', 'Equatorial Guinea', '2', '10', '#ccc', 'equatorialGuineaHigh', '1', -1),
(62, 'er', 'Eritrea', '15', '39', '#ccc', 'eritreaHigh', '1', -1),
(63, 'ee', 'Estonia', '59', '26', '#ECC46F', 'estoniaHigh', '1', -1),
(64, 'et', 'Ethiopia', '8', '38', '#E3E76B', 'ethiopiaHigh', '1', -1),
(65, 'fk', 'Falkland Islands (Malvinas)', '-51.75', '-59', '#ccc', 'falklandIslandsHigh', '1', -1),
(66, 'fo', 'Faroe Islands', '62', '-7', '#ccc', 'faroeIslandsHigh', '1', -1),
(67, 'fm', 'Federated States of Micronesia', '6.92', '158.25', '#ccc', 'micronesiaHigh', '1', -1),
(68, 'fj', 'Fiji', '-18', '175', '#ccc', 'fijiWestHigh', '1', -1),
(69, 'fi', 'Finland', '64', '26', '#F0B4B3', 'finlandHigh', '1', -1),
(70, 'fr', 'France', '46', '2', '#E3E76B', 'franceDepartmentsHigh', '1', -1),
(71, 'gf', 'French Guiana', '4', '-53', '#ccc', 'frenchGuianaHigh', '1', -1),
(72, 'pf', 'French Polynesia', '-15', '-140', '#ccc', 'frenchPolynesiaHigh', '1', -1),
(73, 'tf', 'French Southern Territories', '-43', '67', '#ccc', 'frenchGuianaHigh', '1', -1),
(74, 'ga', 'Gabon', '-1', '11.75', '#ccc', 'gabonHigh', '1', -1),
(75, 'gm', 'Gambia', '13.47', '-16.57', '#ccc', 'gambiaHigh', '1', -1),
(76, 'ge', 'Georgia', '42', '43.5', '#ccc', 'georgiaSouthOssetiaHigh', '1', -1),
(77, 'de', 'Germany', '51', '9', '#EDB5AE', 'germanyHigh', '1', -1),
(78, 'gh', 'Ghana', '8', '-2', '#ccc', 'ghanaHigh', '1', -1),
(79, 'gi', 'Gibraltar', '36.18', '-5.37', '#ccc', 'gibraltarHigh', '1', -1),
(80, 'gb', 'Great Britain (UK)', '54', '-2', '#efb4b4', 'unitedKingdomHigh', '1', -1),
(81, 'gr', 'Greece', '39', '22', '#ECC46F', 'greeceHigh', '1', -1),
(82, 'gl', 'Greenland', '72', '-40', '#D6AE6B', 'greenlandHigh', '1', -1),
(83, 'gd', 'Grenada', '12.12', '-61.67', '#ccc', 'grenadaHigh', '1', -1),
(84, 'gp', 'Guadeloupe', '16.25', '-61.58', '#ccc', 'guadeloupeHigh', '1', -1),
(85, 'gt', 'Guatemala', '15.5', '-90.25', '#ccc', 'guatemalaHigh', '1', -1),
(86, 'gn', 'Guinea', '11', '-10', '#ccc', 'guineaHigh', '1', -1),
(87, 'gw', 'Guinea-Bissau', '12', '-15', '#ccc', 'guineaBissauHigh', '1', -1),
(88, 'gy', 'Guyana', '5', '-59', '#ccc', 'guyanaHigh', '1', -1),
(89, 'ht', 'Haiti', '19', '-72.42', '#ccc', 'haitiHigh', '1', -1),
(90, 'hn', 'Honduras', '15', '-86.5', '#ccc', 'hondurasHigh', '1', -1),
(91, 'hk', 'Hong Kong', '22.25', '114.17', '#ccc', 'hongKongHigh', '1', -1),
(92, 'hu', 'Hungary', '47', '20', '#ECC46F', 'hungaryHigh', '1', -1),
(93, 'is', 'Iceland', '65', '-18', '#c5dd7f', 'icelandHigh', '1', -1),
(94, 'in', 'India', '20', '77', '#BED87F', 'indiaHigh', '1', -1),
(95, 'id', 'Indonesia', '-5', '120', '#B7CC77', 'indonesiaHigh', '1', -1),
(96, 'ir', 'Iran', '32', '53', '#F0B4B3', 'iranHigh', '1', -1),
(97, 'iq', 'Iraq', '33', '44', '#ECC46F', 'iraqHigh', '1', -1),
(98, 'ie', 'Ireland', '53', '-8', '#c5dd7f', 'irelandHigh', '1', -1),
(99, 'il', 'Israel', '31.5', '34.75', '#ccc', 'israelHigh', '1', -1),
(100, 'it', 'Italy', '42.83', '12.83', '#cd9eae', 'italyHigh', '1', -1),
(101, 'jm', 'Jamaica', '18.25', '-77.5', '#ccc', 'jamaicaHigh', '1', -1),
(102, 'jp', 'Japan', '36', '138', '#B7CC77', 'japanHigh', '1', -1),
(103, 'jo', 'Jordan', '31', '36', '#ccc', 'jordanHigh', '1', -1),
(104, 'kz', 'Kazakhstan', '48', '68', '#BCD184', 'kazakhstanHigh', '1', -1),
(105, 'ke', 'Kenya', '1', '38', '#c5dd7f', 'kenyaHigh', '1', -1),
(106, 'ki', 'Kiribati', '1.42', '173', '#ccc', 'kiribatiHigh', '1', -1),
(107, 'kp', 'Korea (North)', '40', '127', '#D9B5D5', 'northKoreaHigh', '1', -1),
(108, 'kr', 'Korea (South)', '37', '127.5', '#F0C782', 'southKoreaHigh', '1', -1),
(109, 'kw', 'Kuwait', '29.34', '47.66', '#ccc', 'kuwaitHigh', '1', -1),
(110, 'kg', 'Kyrgyzstan', '41', '75', '#F0C782', 'kyrgyzstanHigh', '1', -1),
(111, 'la', 'Laos', '18', '105', '#e9eb6c', 'laosHigh', '1', -1),
(112, 'lv', 'Latvia', '57', '25', '#ccc', 'latviaHigh', '1', -1),
(113, 'lb', 'Lebanon', '33.83', '35.83', '#ccc', 'lebanonHigh', '1', -1),
(114, 'ls', 'Lesotho', '-29.5', '28.5', '#ccc', 'southAfricaHigh', '1', -1),
(115, 'lr', 'Liberia', '6.5', '-9.5', '#ccc', 'liberiaHigh', '1', -1),
(116, 'ly', 'Libya', '25', '17', '#e9eb6c', 'libyaHigh', '1', -1),
(117, 'li', 'Liechtenstein', '47.17', '9.529999999999999', '#ccc', 'liechtensteinHigh', '1', -1),
(118, 'lt', 'Lithuania', '56', '24', '#ccc', 'lithuaniaHigh', '1', -1),
(119, 'lu', 'Luxembourg', '49.75', '6.17', '#ccc', 'luxembourgHigh', '1', -1),
(120, 'mo', 'Macao', '22.17', '113.55', '#ccc', 'macaoHigh', '1', -1),
(121, 'mk', 'Macedonia', '41.83', '22', '#ccc', 'macedoniaHigh', '1', -1),
(122, 'mg', 'Madagascar', '-20', '47', '#B7CC77', 'madagascarHigh', '1', -1),
(123, 'mw', 'Malawi', '-13.5', '34', '#ccc', 'malawiHigh', '1', -1),
(124, 'my', 'Malaysia', '2.5', '112.5', '#ccc', 'malaysiaHigh', '1', -1),
(125, 'mv', 'Maldives', '3.25', '73', '#ccc', 'maldivesHigh', '1', -1),
(126, 'ml', 'Mali', '17', '-4', '#e3efbd', 'maliHigh', '1', -1),
(127, 'mt', 'Malta', '35.83', '14.58', '#ccc', 'maltaHigh', '1', -1),
(128, 'mh', 'Marshall Islands', '9', '168', '#ccc', 'marshallIslandsHigh', '1', -1),
(129, 'mq', 'Martinique', '14.67', '-61', '#ccc', 'martiniqueHigh', '1', -1),
(130, 'mr', 'Mauritania', '20', '-12', '#B7CC77', 'mauritaniaHigh', '1', -1),
(131, 'mu', 'Mauritius', '-20.28', '57.55', '#ccc', 'mauritiusHigh', '1', -1),
(132, 'yt', 'Mayotte', '-12.83', '45.17', '#ccc', 'mayotteHigh', '1', -1),
(133, 'mx', 'Mexico', '23', '-102', '#F3EC17', 'mexicoHigh', '1', -1),
(134, 'md', 'Moldova', '47', '29', '#ccc', 'moldovaHigh', '1', -1),
(135, 'mc', 'Monaco', '43.73', '7.4', '#ccc', 'monacoHigh', '1', -1),
(136, 'mn', 'Mongolia', '46', '105', '#F0C782', 'mongoliaHigh', '1', -1),
(137, 'ms', 'Montserrat', '16.75', '-62.2', '#ccc', 'montenegroHigh', '1', -1),
(138, 'ma', 'Morocco', '32', '-5', '#cd9eae', 'moroccoHigh', '1', -1),
(139, 'mz', 'Mozambique', '-18.25', '35', '#E2E783', 'mozambiqueHigh', '1', -1),
(140, 'mm', 'Myanmar', '22', '98', '#B7CC77', 'myanmarHigh', '1', -1),
(141, 'na', 'Namibia', '-22', '17', '#e9eb6c', 'namibiaHigh', '1', -1),
(142, 'nr', 'Nauru', '-0.53', '166.92', '#ccc', 'nauruHigh', '1', -1),
(143, 'np', 'Nepal', '28', '84', '#ccc', 'nepalHigh', '1', -1),
(144, 'nl', 'Netherlands', '52.5', '5.75', '#ccc', 'netherlandsHigh', '1', -1),
(145, 'an', 'Netherlands Antilles', '12.25', '-68.75', '#ccc', 'netherlandsHigh', '1', -1),
(146, 'nc', 'New Caledonia', '-21.5', '165.5', '#ccc', 'newCaledoniaHigh', '1', -1),
(147, 'nz', 'New Zealand (Aotearoa)', '-41', '174', '#D9B5D5', 'newZealandHigh', '1', -1),
(148, 'ni', 'Nicaragua', '13', '-85', '#ccc', 'nicaraguaHigh', '1', -1),
(149, 'ne', 'Niger', '16', '8', '#c5dd7f', 'nigerHigh', '1', -1),
(150, 'ng', 'Nigeria', '10', '8', '#e8c76a', 'nigeriaHigh', '1', -1),
(151, 'nu', 'Niue', '-19.03', '-169.87', '#ccc', 'niueHigh', '1', -1),
(152, 'nf', 'Norfolk Island', '-29.03', '167.95', '#ccc', '', '1', -1),
(153, 'mp', 'Northern Mariana Islands', '15.2', '145.75', '#ccc', 'northernMarianaIslandsHigh', '1', -1),
(154, 'no', 'Norway', '62', '10', '#cd9eae', 'norwayHigh', '1', -1),
(155, 'gg', 'NULL', '', '', '#ccc', 'channelIslandsHigh', '1', -1),
(156, 'om', 'Oman', '21', '57', '#B7CC77', 'omanHigh', '1', -1),
(157, 'pk', 'Pakistan', '30', '70', '#e3efbd', 'pakistanHigh', '1', -1),
(158, 'pw', 'Palau', '7.5', '134.5', '#ccc', 'palauHigh', '1', -1),
(159, 'ps', 'Palestinian Territory', '32', '35.25', '#ccc', 'palestineHigh', '1', -1),
(160, 'pa', 'Panama', '9', '-80', '#ccc', 'panamaHigh', '1', -1),
(161, 'pg', 'Papua New Guinea', '-6', '147', '#e9eb6c', 'papuaNewGuineaHigh', '1', -1),
(162, 'py', 'Paraguay', '-23', '-58', '#e8c76a', 'paraguayHigh', '1', -1),
(163, 'pe', 'Peru', '-10', '-76', '#cd9eae', 'peruHigh', '1', -1),
(164, 'ph', 'Philippines', '13', '122', '#efb4b4', 'philippinesHigh', '1', -1),
(165, 'pn', 'Pitcairn', '', '', '#ccc', 'pitcairnIslandsHigh', '1', -1),
(166, 'pl', 'Poland', '52', '20', '#F0C782', 'polandHigh', '1', -1),
(167, 'pt', 'Portugal', '39.5', '-8', '#ccc', 'portugalRegionsHigh', '1', -1),
(168, 'qa', 'Qatar', '25.5', '51.25', '#ccc', 'qatarHigh', '1', -1),
(169, 're', 'Reunion', '-21.1', '55.6', '#ccc', 'reunionHigh', '1', -1),
(170, 'ro', 'Romania', '46', '25', '#E3E76B', 'romaniaHigh', '1', -1),
(171, 'ru', 'Russia', '60', '100', '#DCE97F', 'russiaHigh', '1', -1),
(172, 'rw', 'Rwanda', '-2', '30', '#ccc', 'rwandaHigh', '1', -1),
(173, 'gs', 'S. Georgia and S. Sandwich Islands', '-54.5', '-37', '#ccc', 'georgiaHigh', '1', -1),
(174, 'sh', 'Saint Helena', '-15.93', '-5.7', '#ccc', 'stHelenaHigh', '1', -1),
(175, 'kn', 'Saint Kitts and Nevis', '17.33', '-62.75', '#ccc', 'stKittsNevisHigh', '1', -1),
(176, 'lc', 'Saint Lucia', '13.88', '-61.13', '#ccc', 'stLuciaHigh', '1', -1),
(177, 'pm', 'Saint Pierre and Miquelon', '46.83', '-56.33', '#ccc', 'saintPierreMiquelonHigh', '1', -1),
(178, 'vc', 'Saint Vincent and the Grenadines', '13.25', '-61.2', '#ccc', 'stVincentHigh', '1', -1),
(179, 'ws', 'Samoa', '-13.58', '-172.33', '#ccc', 'samoaHigh', '1', -1),
(180, 'sm', 'San Marino', '43.77', '12.42', '#ccc', 'sanMarinoHigh', '1', -1),
(181, 'st', 'Sao Tome and Principe', '1', '7', '#ccc', 'saoTomePrincipeHigh', '1', -1),
(182, 'sa', 'Saudi Arabia', '25', '45', '#cd9eae', 'saudiArabiaHigh', '1', -1),
(183, 'sn', 'Senegal', '14', '-14', '#efb4b4', 'senegalHigh', '1', -1),
(184, 'sc', 'Seychelles', '-4.58', '55.67', '#ccc', 'seychellesHigh', '1', -1),
(185, 'sl', 'Sierra Leone', '8.5', '-11.5', '#ccc', 'sierraLeoneHigh', '1', -1),
(186, 'sg', 'Singapore', '1.0924073', '103.0456549', '#ccc', 'singaporeHigh', '1', -1),
(187, 'sk', 'Slovakia', '48.67', '19.5', '#ccc', 'slovakiaHigh', '1', -1),
(188, 'si', 'Slovenia', '46', '15', '#ccc', 'sloveniaHigh', '1', -1),
(189, 'sb', 'Solomon Islands', '-8', '159', '#ccc', 'solomonIslandsHigh', '1', -1),
(190, 'so', 'Somalia', '10', '49', '#cd9eae', 'somaliaHigh', '1', -1),
(191, 'za', 'South Africa', '-29', '24', '#B7CC77', 'southAfricaHigh', '1', -1),
(192, 'es', 'Spain', '40', '-4', '#e3efbd', 'spainHigh', '1', -1),
(193, 'lk', 'Sri Lanka', '7', '81', '#E3E76B', 'sriLankaHigh', '1', -1),
(194, 'sd', 'Sudan', '15', '30', '#e8c76a', 'sudanHigh', '1', -1),
(195, 'sr', 'Suriname', '4', '-56', '#ccc', 'surinameHigh', '1', -1),
(196, 'sj', 'Svalbard and Jan Mayen', '78', '20', '#D9B5D5', 'svalbardJanMayenHigh', '1', -1),
(197, 'sz', 'Swaziland', '-26.5', '31.5', '#ccc', 'swazilandHigh', '1', -1),
(198, 'se', 'Sweden', '62', '15', '#B7CC77', 'swedenHigh', '1', -1),
(199, 'ch', 'Switzerland', '47', '8', '#ccc', 'switzerlandHigh', '1', -1),
(200, 'sy', 'Syria', '35', '38', '#ccc', 'syriaHigh', '1', -1),
(201, 'tw', 'Taiwan', '23.5', '121', '#ccc', 'taiwanHigh', '1', -1),
(202, 'tj', 'Tajikistan', '39', '71', '#ccc', 'tajikistanHigh', '1', -1),
(203, 'tz', 'Tanzania', '-6', '35', '#e8c76a', 'tanzaniaHigh', '1', -1),
(204, 'th', 'Thailand', '15', '100', '#ECC46F', 'thailandHigh', '1', -1),
(205, 'tg', 'Togo', '8', '1.17', '#ccc', 'togoHigh', '1', -1),
(206, 'tk', 'Tokelau', '-9', '-172', '#ccc', 'tokelauHigh', '1', -1),
(207, 'to', 'Tonga', '-20', '-175', '#ccc', 'tongaHigh', '1', -1),
(208, 'tt', 'Trinidad and Tobago', '11', '-61', '#ccc', 'trinidadAndTobagoHigh', '1', -1),
(209, 'tn', 'Tunisia', '34', '9', '#efb4b4', 'tunisiaHigh', '1', -1),
(210, 'tr', 'Turkey', '39', '35', '#cd9eae', 'turkeyHigh', '1', -1),
(211, 'tm', 'Turkmenistan', '40', '60', '#e9eb6c', 'turkmenistanHigh', '1', -1),
(212, 'tc', 'Turks and Caicos Islands', '21.75', '-71.58', '#ccc', 'turksCaicosIslandsHigh', '1', -1),
(213, 'tv', 'Tuvalu', '-8', '178', '#ccc', 'tuvaluHigh', '1', -1),
(214, 'ug', 'Uganda', '1', '32', '#cd9eae', 'ugandaHigh', '1', -1),
(215, 'ua', 'Ukraine', '49', '32', '#D9B5D5', 'ukraineHigh', '1', -1),
(216, 'ae', 'United Arab Emirates', '24', '54', '#ccc', 'unitedArabEmiratesHigh', '1', -1),
(217, 'us', 'United States of America', '38', '-97', '#b8d666', 'usa2High', '1', 1),
(218, 'uy', 'Uruguay', '-33', '-56', '#ccc', 'uruguayHigh', '1', -1),
(219, 'uz', 'Uzbekistan', '41', '64', '#EDB5AE', 'uzbekistanHigh', '1', -1),
(220, 'vu', 'Vanuatu', '-16', '167', '#ccc', 'vanuatuHigh', '1', -1),
(221, 've', 'Venezuela', '8', '-66', '#E3E76B', 'venezuelaHigh', '1', -1),
(222, 'vn', 'Viet Nam', '16', '106', '#cd9eae', 'vietnamHigh', '1', 2),
(223, 'vg', 'Virgin Islands (British)', '18.5', '-64.5', '#ccc', 'britishVirginIslandsHigh', '1', -1),
(224, 'vi', 'Virgin Islands (U.S.)', '18.33', '-64.83', '#ccc', 'usVirginIslandsHigh', '1', -1),
(225, 'wf', 'Wallis and Futuna', '-13.3', '-176.2', '#ccc', 'wallisFutunaHigh', '1', -1),
(226, 'eh', 'Western Sahara', '24.5', '-13', '#ccc', 'moroccoHigh', '1', -1),
(227, 'ye', 'Yemen', '15', '48', '#e3efbd', 'yemenHigh', '1', -1),
(228, 'zr', 'Zaire (former)', '', '', '#ccc', '', '1', -1),
(229, 'zm', 'Zambia', '-15', '30', '#cd9eae', 'zambiaHigh', '1', -1),
(230, 'zw', 'Zimbabwe', '-20', '30', '#efb4b4', 'zimbabweHigh', '1', -1),
(231, 'rs', 'Serbia', '44.787197', '20.457273', '#ccc', 'serbiaHigh', '1', -1),
(232, 'xk', 'Kosovo', '42.5571966', '19.7807981', '#ECC46F', 'kosovoHigh', '1', 6),
(233, 'me', 'Montenegro', '42.6887531', '18.2720837', '#c5dd7f', 'montenegroHigh', '1', -1),
(234, 'tl', 'EastTimor', '-8.1268457', '127.3430437', '#D6AE6B', 'eastTimorHigh', '1', 5),
(235, 'ss', 'South Sudan', '7.8495421', '25.1833907', '#D6AE6B', 'southSudanHigh', '1', 5),
(236, 'cg', 'Republic of the Congo', '-1.0765987', '13.8002876', '#D6AE6B', 'congoHigh', '1', 5);

-- --------------------------------------------------------

--
-- Cấu trúc bảng cho bảng `famous_cities`
--

CREATE TABLE `famous_cities` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lat` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lng` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `inhome` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Đang đổ dữ liệu cho bảng `famous_cities`
--

INSERT INTO `famous_cities` (`id`, `name`, `image`, `lat`, `lng`, `inhome`) VALUES
(1, 'Paris, France', 'paris.jpg', '48.8588376', '2.276848', 4),
(2, 'London, England', 'london.jpg', '51.5073299', '-0.3824713', 2),
(3, 'Bangkok, Thailand', 'bangkok.jpg', '13.7244409', '100.352216', 3),
(4, 'Singapore, Singapore', 'singapore.jpg', '1.3437419', '103.6836114', 6),
(5, 'New York, USA', 'new_york.jpg', '42.7286631', '-78.0191629', 1),
(6, 'Kuala Lumpur, Malaysia', 'kuala_lumpur.jpg', '3.1384965', '101.546556', 7),
(7, 'Hong Kong', 'hong_kong.jpg', '22.3524918', '113.8468081', 0),
(8, 'Dubai, UAE', 'dubai.jpg', '25.075084', '54.9468562', 5),
(9, 'Istanbul, Turkey', 'istanbul.jpg', '41.0049806', '28.7312983', 8),
(10, 'Rome', 'rome.jpg', '41.850437', '11.9530653', 0),
(11, 'Shanghai', 'shanghai.jpg', '31.2231276', '120.9148782', 11),
(12, 'Los Angeles', 'los_angeles.jpg', '34.0201597', '-118.6926183', 0),
(13, 'Las Vegas', 'las_vegas.jpg', '36.1246721', '-115.4558844', 0),
(14, 'Miami, FL, USA', 'miami.jpg', '25.7823907', '-80.2996712', 0),
(15, 'Toronto, ON, Canada', 'toronto.jpg', '43.6565336', '-79.6017292', 0),
(16, 'Barcelona, Spain', 'barcelona.jpg', '41.3947047', '2.0083381', 12),
(17, 'Amsterdam, Netherlands', 'amsterdam.jpg', '52.3545649', '4.7581954', 13),
(18, 'Moscow, Russia', 'moscow.jpg', '55.5768866', '36.2617259', 16),
(19, 'Cairo, Egypt', 'cairo.jpg', '30.0594698', '31.1882517', 0),
(20, 'Dublin, Ireland', 'dublin.jpg', '53.3244427', '-6.3861316', 0),
(21, 'Prague, Czechia', 'prague.jpg', '50.0595849', '14.3251958', 18),
(22, 'Vienna, Austria', 'vienna.jpg', '48.2205994', '16.2396315', 17),
(23, 'Madrid, Spain', 'madrid.jpg', '40.4378693', '-3.8199666', 0),
(24, 'San Francisco, CA, USA', 'san_francisco.jpg', '37.7576792', '-122.5078123', 0),
(25, 'Vancouver, BC, Canada', 'vancouver.jpg', '49.2577142', '-123.1941158', 0),
(26, 'Budapest, Hungary', 'budapest.jpg', '47.4808705', '18.8494268', 0),
(27, 'Rio de Janeiro, Brazil', 'rio_de_janeiro.jpg', '-22.0622285', '-44.0473184', 0),
(28, 'Berlin, Germany', 'berlin.jpg', '52.5065116', '13.1438597', 0),
(29, 'Tokyo, Japan', 'tokyo.jpg', '35.6732615', '139.5699573', 9),
(30, 'Mexico City, Mexico', 'mexico_city.jpg', '19.3202819', '-99.4335065', 0),
(31, 'Buenos Aires, Argentina', 'buenos_aires.jpg', '-34.6157433', '-58.5737293', 0),
(32, 'St. Petersburg, FL, USA', 'petersburg.jpg', '27.7786984', '-82.7952523', 0),
(33, 'Seoul, South Korea', 'seoul.jpg', '37.5650168', '126.8491196', 10),
(34, 'Athens, Greece', 'athens.jpg', '37.9908163', '23.668127', 0),
(35, 'Jerusalem, Israel', 'jerusalem.jpg', '31.7962415', '35.0349277', 0),
(36, 'Seattle, WA, USA', 'seattle.jpg', '47.6129428', '-122.4824931', 0),
(37, 'Delhi, India', 'delhi.jpg', '28.692115', '76.8104611', 0),
(38, 'Sydney NSW, Australia', 'sydney.jpg', '-33.8679049', '151.1924394', 0),
(39, 'Mumbai, Maharashtra, India', 'mumbai.jpg', '19.082038', '72.600293', 0),
(40, 'Munich, Germany', 'munich.jpg', '48.1548252', '11.4014072', 15),
(41, 'Venice, Italy', 'venice.jpg', '45.4536548', '11.9702745', 0),
(42, 'Florence, Italy', 'florence.jpg', '43.8443825', '10.670202', 0),
(43, 'Beijing, China', 'beijing.jpg', '39.9385449', '116.116577', 0),
(44, 'Cape Town, South Africa', 'cape_town.jpg', '-33.9142624', '18.0941917', 0),
(45, 'Washington, DC, USA', 'washington.jpg', '38.8935123', '-77.1550062', 0),
(46, 'Montreal, QC, Canada', 'montreal.jpg', '45.5576979', '-74.0111802', 0),
(47, 'Atlanta, GA, USA', 'atlanta.jpg', '33.7676334', '-84.5610349', 0),
(48, 'Boston, GA, USA', 'boston.jpg', '30.7920414', '-83.8074846', 0),
(49, 'Philadelphia, PA, USA', 'philadelphia.jpg', '40.0024133', '-75.2584629', 0),
(50, 'Chicago, IL, USA', 'chicago.jpg', '41.8333908', '-88.0128445', 0),
(51, 'San Diego, CA, USA', 'san_diego.jpg', '32.8242389', '-117.3898649', 0),
(52, 'Stockholm, Sweden', 'stockholm.jpg', '59.3258399', '17.7011865', 0),
(53, 'Cancún, Quintana Roo, Mexico', 'cancun.jpg', '21.1212851', '-86.9896659', 0),
(54, 'Warsaw, Poland', 'warsaw.jpg', '52.2326046', '20.7803218', 0),
(55, 'Sharm el-Sheikh, Egypt', 'sharm_el_sheikh.jpg', '27.856471', '34.2776539', 0),
(56, 'Dallas, TX, USA', 'dallas.jpg', '32.8203509', '-97.0124289', 0),
(57, 'Hồ Chí Minh', 'hochiminh.jpg', '10.7542869', '106.1333174', 0),
(58, 'Milan, Italy', 'milan.jpg', '45.401757', '8.8479664', 14),
(59, 'Oslo, Norway', 'oslo.jpg', '59.8937803', '10.6446905', 0),
(60, 'Lisbon, Portugal', 'lisbon.jpg', '38.7436056', '-9.2304156', 0),
(61, 'Punta Cana', 'punta_cana.jpg', '18.640509', '-68.7522391', 0),
(62, 'Johannesburg, South Africa', 'johannesburg.jpg', '-26.1715045', '27.9698118', 0),
(63, 'Antalya, Turkey', 'antalya.jpg', '36.8978549', '30.5776746', 0),
(64, 'Mecca, Saudi Arabia', 'mecca.jpg', '21.4359569', '39.7061141', 0),
(65, 'Macau, France', 'macau.jpg', '45.0112776', '-0.6433954', 0),
(66, 'Pattaya Beach, Satun, Thailand', 'pattaya.jpg', '6.4854393', '99.2972079', 0),
(67, 'Guangzhou, Guangdong, China', 'guangzhou.jpg', '23.1246026', '112.6659516', 0),
(68, 'Kiev, Ukraine', 'kiev.jpg', '50.4016974', '30.2518167', 0),
(69, 'Shenzhen, Guangdong, China', 'shenzhen.jpg', '22.5549164', '113.772987', 0),
(70, 'Bucharest, Romania', 'bucharest.jpg', '44.4377397', '25.9542083', 0),
(71, 'Taipei City, Taiwan', 'taipei.jpg', '25.08534', '121.4210691', 0),
(72, 'Orlando, FL, USA', 'orlando.jpg', '28.4810968', '-81.5091817', 0),
(73, 'Brussels, Belgium', 'brussels.jpg', '50.854954', '4.3051782', 0),
(74, 'Chennai, Tamil Nadu, India', 'chennai.jpg', '13.047374', '79.9281167', 0),
(75, 'Marrakesh, Morocco', 'marrakesh.jpg', '31.6346022', '-8.0780657', 0),
(76, 'Phuket, Thailand', 'phuket.jpg', '7.8302446', '98.0790327', 0),
(77, 'Edirne, Turkey', 'edirne.jpg', '41.2902575', '25.4012317', 0),
(78, 'Bali, Indonesia', 'bali.jpg', '-8.4550707', '114.5096649', 0),
(79, 'Copenhagen, Denmark', 'copenhagen.jpg', '55.6711872', '12.4533969', 0),
(80, 'São Paulo, Brazil', 'sao_paulo.jpg', '-22.4832955', '-53.1454483', 0),
(81, 'Agra, Uttar Pradesh, India', 'agra.jpg', '27.176157', '77.9098002', 0),
(82, 'Varanasi, Uttar Pradesh, India', 'varanasi.jpg', '25.320746', '82.9208962', 0),
(83, 'Riyadh, Saudi Arabia', 'riyadh.jpg', '24.7241451', '46.2606394', 0),
(84, 'Jakarta, Indonesia', 'jakarta.jpg', '-5.7773015', '106.1160616', 0),
(85, 'Auckland, New Zealand', 'auckland.jpg', '-36.8626926', '174.5845854', 0),
(86, 'Honolulu, HI, USA', 'honolulu.jpg', '21.3279755', '-157.9395055', 0),
(87, 'Edinburgh, UK', 'edinburgh.jpg', '55.9411884', '-3.2755502', 0),
(88, 'Wellington, New Zealand', 'wellington.jpg', '-41.2442847', '174.6214248', 0),
(89, 'New Orleans, LA, USA', 'new_orleans.jpg', '30.0329219', '-90.0229949', 0),
(90, 'Petra, Jordan', 'petra.jpg', '30.3778411', '35.2969587', 0),
(91, 'Melbourne VIC, Australia', 'melbourne.jpg', '-37.8274812', '144.9351606', 0),
(92, 'Luxor, Egypt', 'luxor.jpg', '25.7707742', '32.2052367', 0),
(93, 'Hanoi, Vietnam', 'hanoi.jpg', '21.022736', '105.8018581', 0),
(94, 'Manila, Metro Manila, Philippines', 'manila.jpg', '14.5964957', '120.9444542', 0),
(95, 'Houston, TX, USA', 'houston.jpg', '29.8168809', '-95.6821797', 0),
(96, 'Phnom Penh, Cambodia', 'phnom_penh.jpg', '11.5793304', '104.7497535', 0),
(97, 'Zürich, Switzerland', 'zurich.jpg', '47.3774336', '8.4665031', 0),
(98, 'Lima, Talacker, Zürich, Switzerland', 'lima.jpg', '47.3716477', '8.5335228', 0),
(99, 'Santiago, Chile', 'santiago.jpg', '-33.4533624', '-70.7142991', 0),
(100, 'Bogotá, Bogota, Colombia', 'bogota.jpg', '4.6482836', '-74.2482405', 0);

-- --------------------------------------------------------

--
-- Cấu trúc bảng cho bảng `faqs`
--

CREATE TABLE `faqs` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `detail` longtext COLLATE utf8mb4_unicode_ci,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category_id` int(10) NOT NULL,
  `seo_keywords` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_description` text COLLATE utf8mb4_unicode_ci,
  `seo_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int(11) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Đang đổ dữ liệu cho bảng `faqs`
--

INSERT INTO `faqs` (`id`, `title`, `description`, `detail`, `slug`, `image`, `category_id`, `seo_keywords`, `seo_description`, `seo_title`, `created_by`, `created_at`, `updated_by`, `updated_at`) VALUES
(37, 'What do the timeline colors represent?', 'What do the timeline colors represent?', '<p>What do the timeline colors represent?</p>', 'what-do-the-timeline-colors-represent', NULL, 8, 'What do the timeline colors represent?', 'What do the timeline colors represent?', 'What do the timeline colors represent?', 1, '2018-08-10 10:48:30', 1, '2018-08-10 10:48:30'),
(38, 'What direction are the wind arrows?', 'What direction are the wind arrows?', '<p>What direction are the wind arrows?</p>', 'what-direction-are-the-wind-arrows', NULL, 8, 'wind arrows', 'What direction are the wind arrows?', 'What direction are the wind arrows?', 1, '2018-08-10 10:49:09', 1, '2018-08-10 10:49:09'),
(39, 'What do the percentages mean?', 'What do the percentages mean?', '<p>What do the percentages mean?</p>', 'what-do-the-percentages-mean', NULL, 8, 'percentages', 'What do the percentages mean?', 'What do the percentages mean?', 1, '2018-08-10 10:50:39', 1, '2018-08-10 10:50:39'),
(40, 'Can I embed your map on my website?', 'Can I embed your map on my website?', '<p>Can I embed your map on my website?</p>', 'can-i-embed-your-map-on-my-website', NULL, 9, 'embed', 'Can I embed your map on my website?', 'Can I embed your map on my website?', 1, '2018-08-10 10:51:14', 1, '2018-08-10 10:51:14'),
(41, 'Can I embed your website on my website?', 'Can I embed your website on my website?', '<p>Can I embed your website on my website?</p>', 'can-i-embed-your-website-on-my-website', NULL, 9, 'embed', 'Can I embed your website on my website?', 'Can I embed your website on my website?', 1, '2018-08-10 10:51:39', 1, '2018-08-10 10:51:39'),
(42, 'What do the precipitation percentages and humidity percentages indicate?', 'What do the precipitation percentages and humidity percentages indicate?', '<p>What do the precipitation percentages and humidity percentages indicate?</p>', 'what-do-the-precipitation-percentages-and-humidity-percentages-indicate', NULL, 10, 'humidity percentages, precipitation percentages', 'What do the precipitation percentages and humidity percentages indicate?', 'What do the precipitation percentages and humidity percentages indicate?', 1, '2018-08-10 10:53:28', 1, '2018-08-10 10:53:28'),
(43, 'What do the wind arrows indicate?', 'What do the wind arrows indicate?', '<p>What do the wind arrows indicate?</p>', 'what-do-the-wind-arrows-indicate', NULL, 10, 'wind arrows', 'What do the wind arrows indicate?', 'What do the wind arrows indicate?', 1, '2018-08-10 10:54:02', 1, '2018-08-10 10:54:02'),
(44, 'What do the colors mean on the wind maps?', 'What do the colors mean on the wind maps?', '<p>What do the colors mean on the wind maps?</p>', 'what-do-the-colors-mean-on-the-wind-maps', NULL, 10, 'wind maps', 'What do the colors mean on the wind maps?', 'What do the colors mean on the wind maps?', 1, '2018-08-10 10:54:37', 1, '2018-08-10 10:54:37');

-- --------------------------------------------------------

--
-- Cấu trúc bảng cho bảng `faq_categories`
--

CREATE TABLE `faq_categories` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `keywords` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Đang đổ dữ liệu cho bảng `faq_categories`
--

INSERT INTO `faq_categories` (`id`, `name`, `keywords`, `description`, `slug`, `created_at`, `updated_at`) VALUES
(8, 'WEBSITE', 'WEBSITE', 'WEBSITE', 'WEBSITE', NULL, NULL),
(9, 'EMBEDS', 'EMBEDS', 'EMBEDS', 'EMBEDS', NULL, NULL),
(10, 'MAPS', 'maps', 'maps', 'maps', NULL, NULL);

-- --------------------------------------------------------

--
-- Cấu trúc bảng cho bảng `languages`
--

CREATE TABLE `languages` (
  `id` int(10) UNSIGNED NOT NULL,
  `code` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `active` int(11) NOT NULL DEFAULT '1'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Đang đổ dữ liệu cho bảng `languages`
--

INSERT INTO `languages` (`id`, `code`, `name`, `active`) VALUES
(71, 'af', 'Afrikaans', 1),
(72, 'ar', 'Arabic', 1),
(73, 'az', 'Azeerbaijani', 1),
(74, 'be', 'Belarusian', 1),
(75, 'bg', 'Bulgarian', 1),
(76, 'bn', 'Bengali', 1),
(77, 'ca', 'Catalan', 1),
(78, 'cs', 'Czech', 1),
(79, 'da', 'Danish', 1),
(80, 'de', 'German', 1),
(81, 'el', 'Greek', 1),
(82, 'en', 'English', 1),
(83, 'es', 'Spanish', 1),
(84, 'et', 'Estonian', 1),
(85, 'eu', 'Basque', 1),
(86, 'fa', 'Persian', 1),
(87, 'fi', 'Finnish', 1),
(88, 'fr', 'French', 1),
(89, 'hi', 'Hindi', 1),
(90, 'hr', 'Croatian', 1),
(91, 'hu', 'Hungarian', 1),
(92, 'hy', 'Armenian', 1),
(93, 'id', 'Indonesian', 1),
(94, 'is', 'Icelandic', 1),
(95, 'it', 'Italian', 1),
(96, 'iw', 'Hebrew', 1),
(97, 'ja', 'Japanese', 1),
(98, 'km', 'Khmer', 1),
(99, 'kn', 'Kannada', 1),
(100, 'ko', 'Korean', 1),
(101, 'lo', 'Lao', 1),
(102, 'lt', 'Lithuanian', 1),
(103, 'lv', 'Latvian', 1),
(104, 'mk', 'Macedonian', 1),
(105, 'ml', 'Malayalam', 1),
(106, 'mn', 'Mongolian', 1),
(107, 'mr', 'Marathi', 1),
(108, 'ms', 'Malay', 1),
(109, 'my', 'Myanmar', 1),
(111, 'ne', 'Nepali', 1),
(112, 'nl', 'Dutch', 1),
(113, 'pl', 'Polish', 1),
(114, 'pt', 'Portuguese', 1),
(115, 'ro', 'Romanian', 1),
(116, 'ru', 'Russian', 1),
(117, 'si', 'Sinhala', 1),
(118, 'sk', 'Slovak', 1),
(119, 'sl', 'Slovenian', 1),
(120, 'sr', 'Serbian', 1),
(121, 'sv', 'Swedish', 1),
(122, 'sw', 'Swahili', 1),
(123, 'te', 'Telugu', 0),
(124, 'th', 'Thai', 1),
(125, 'tr', 'Turkish', 1),
(126, 'uk', 'Ukrainian', 1),
(129, 'zu', 'Zulu', 1),
(130, 'vi', 'Vietnamese', 1),
(132, 'zh-CN', 'Chinese (Simplified)', 1),
(133, 'zh-TW', 'Chinese (Traditional)', 1),
(134, 'nb', 'Norwegian', 1);

-- --------------------------------------------------------

--
-- Cấu trúc bảng cho bảng `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Đang đổ dữ liệu cho bảng `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '2014_10_12_000000_create_users_table', 1),
(2, '2014_10_12_100000_create_password_resets_table', 1),
(3, '2018_07_16_071113_create_languages_table', 1),
(4, '2018_07_23_065416_create_cities_table', 2),
(5, '2018_07_24_012545_add_field_to_cities', 2),
(6, '2018_07_24_071303_add_field_user_config', 2),
(7, '2018_07_25_065652_create_table_contact', 3),
(8, '2018_07_25_071930_create_table_contacts', 4);

-- --------------------------------------------------------

--
-- Cấu trúc bảng cho bảng `pages`
--

CREATE TABLE `pages` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_by` int(11) DEFAULT NULL,
  `updated_by` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Đang đổ dữ liệu cho bảng `pages`
--

INSERT INTO `pages` (`id`, `title`, `content`, `slug`, `created_by`, `updated_by`, `created_at`, `updated_at`) VALUES
(15, 'FAQs', '<p>Comming soon...</p>', 'faqs', 1, 1, '2018-07-23 19:00:56', '2018-07-27 02:35:14');

-- --------------------------------------------------------

--
-- Cấu trúc bảng cho bảng `permissions`
--

CREATE TABLE `permissions` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `route` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `group` int(11) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Đang đổ dữ liệu cho bảng `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `route`, `group`, `created_at`, `updated_at`) VALUES
(44, 'Quản lý liên hệ', 'contact.manage', 7, '2018-07-17 10:28:20', '2018-07-17 10:41:19'),
(43, 'Quản lý tài khoản quản trị', 'account.manage', 5, '2018-07-17 10:28:02', '2018-07-17 10:28:02'),
(42, 'Quản lý tin tức', 'news.manage', 4, '2018-07-17 10:27:25', '2018-07-17 10:27:25'),
(41, 'Quản lý đơn hàng', 'product.manage_order', 2, '2018-07-17 10:26:05', '2018-07-17 10:26:05'),
(40, 'Thêm sửa xóa danh mục Thương hiệu', 'product.curd_brand', 2, '2018-07-17 10:10:53', '2018-07-17 10:10:53'),
(39, 'Thêm sửa xóa danh mục Nguồn gốc', 'product.curd_origin', 2, '2018-07-17 10:10:25', '2018-07-17 10:10:25'),
(31, 'Quản lý thông tin liên hệ', 'template.contact', 1, '2018-07-15 10:38:04', '2018-07-15 10:45:07'),
(32, 'Quản lý đối tác', 'template.partner', 1, '2018-07-15 11:05:00', '2018-07-15 11:05:00'),
(33, 'Thêm mới sản phẩm', 'product.add_product', 2, '2018-07-17 10:04:23', '2018-07-17 10:04:23'),
(34, 'Sửa sản phẩm', 'product.edit_product', 2, '2018-07-17 10:04:53', '2018-07-17 10:04:53'),
(35, 'Xóa sản phẩm', 'product.del_product', 2, '2018-07-17 10:05:23', '2018-07-17 10:05:23'),
(46, 'Quản lý khách hàng', 'customer.manage', 3, '2018-07-17 10:30:45', '2018-07-17 10:30:45'),
(45, 'Quản lý Page', 'page.manage', 6, '2018-07-17 10:28:34', '2018-07-17 10:30:02');

-- --------------------------------------------------------

--
-- Cấu trúc bảng cho bảng `posts`
--

CREATE TABLE `posts` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `detail` longtext COLLATE utf8mb4_unicode_ci,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_keywords` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_description` text COLLATE utf8mb4_unicode_ci,
  `seo_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sticky` tinyint(4) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int(11) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Đang đổ dữ liệu cho bảng `posts`
--

INSERT INTO `posts` (`id`, `title`, `description`, `detail`, `slug`, `image`, `seo_keywords`, `seo_description`, `seo_title`, `sticky`, `created_by`, `created_at`, `updated_by`, `updated_at`) VALUES
(39, 'Climate and weather in Chicago, Illinois state, USA', 'Climate in Chicago city, Illinois state, USA has a continental climate, with cold winters and hot summers. Weather Chicago with all four seasons distinctly represented, each season brings Chicago a distinctive color.', '<p>Chicago is the main city of Illinois state, located in the American Midwest, along the banks of Lake Michigan, <strong>the climate is continental</strong>, with freezing winters and hot summers. Although the city is located at a middle latitude, in winter it is cold because the North American land mass cools down a lot, and polar air outbreaks are frequent. Given the distance from the sea and the exposure to different types of air masses, temperature changes are frequent.&nbsp;</p>\n\n<p><strong>Weather Chicago</strong> with all four seasons distinctly represented, each season brings Chicago a distinctive color.</p>\n\n<p><strong>Winter (from late November to early March)</strong></p>\n\n<p>A white color covers the city of Chicago in the winter. By the winter here is very cold, frequent snow, so much so that it snows for several days in a month; sometimes real snow storms can occur.&nbsp;<br />\nPolar cold spells are accompanied by the blizzard, the north wind blowing in gusts and able to heighten the feeling of cold. Particularly cold periods, in which the minimum temperature drops to -20&deg;C (-4&deg;F), occur practically every year, and sometimes it can even drop to around -30&deg;C (-22&deg;F); for example, in January 1982 the temperature dropped to -32.2&deg;C (-26 &deg;F), in January 1985 to -32.8&deg;C (-27 &deg;F), and in January 1994 to -29.5&deg;C (-21&deg;F).&nbsp;</p>\n\n<p style="text-align:center"><img alt="Winter in Chicago" src="/templateEditor/kcfinder/uploads/images/Winter-in-Chicago.jpg" style="height:492px; width:690px" /></p>\n\n<p>Although the temperature remains below freezing (0&deg;C or 32&deg;F) even during the day for weeks, sometimes it can exceed freezing also in winter, resulting in melting snow and possible rainfall. Every so often, also the phenomenon called &quot;ice storm&quot; (or freezing rain) can occur, that is, a rain falling on frozen ground, and freezing everything, roads, trees, light poles, cars etc.&nbsp;</p>\n\n<p><strong>Spring (from mid-March to May)</strong></p>\n\n<p style="text-align:center"><strong><img alt="Spring chicago" src="/templateEditor/kcfinder/uploads/images/Spring-in-Chicago.jpg" style="height:492px; width:690px" /></strong></p>\n\n<p>In Spring, <strong>the weather in Chicago</strong> is wet, cool and an unstable season, characterized by different situations and temperature changes: initially cold in March, with snowfall and still quite frequent frosts, it advances gradually, between the first warm days and the return of cold weather conditions. In early April it can still snow, on the other hand during the month the first warm days can occur, with highs around 30&deg;C (86 &deg;F). In fine weather, a cool (or even cold) breeze in the afternoon blows from the lake, which is felt especially in the eastern districts of the city. In May, it can still be cold at night, especially at the beginning of the month, while on other occasions it can be hot, with highs above 30&deg;C (86&deg;F). In April and May, on fine warm days, also the first thunderstorms in the afternoon or in the evening can occur.&nbsp;</p>\n\n<p><strong>Summer (from June to August)</strong></p>\n\n<p style="text-align:center"><strong><img alt="Summer in Chicago" src="/templateEditor/kcfinder/uploads/images/Summer-in-Chicago.jpg" style="height:492px; width:690px" />&nbsp;</strong></p>\n\n<p>The weather Chicago is hot, humid and sunny, with some afternoon or evening thunderstorms. There may be some pleasant days, with highs around 25/27 &deg;C (77/81 &deg;F) and cool nights, but also real heat waves, with highs around 35 &deg;C (95 &deg;F) and beyond. In the worst moments, the temperature can reach as high as 40 &deg;C (104 &deg;F), as happened in July 2012.&nbsp;</p>\n\n<p><strong>Autumn (from September to November)</strong></p>\n\n<p style="text-align:center"><strong><img alt="Autumn in Chicago" src="/templateEditor/kcfinder/uploads/images/Autumn-in-Chicago.jpg" style="height:492px; width:690px" /></strong></p>\n\n<p>Pleasantly mild autumns, it&#39;s the (relatively) quietest period of year. However, there are still years of cold weather early or a return of warm temperatures, and even waves of bad weather. In early September, the weather is often still characterized by heat and humidity, with sunshine and some afternoon thunderstorms, then it becomes milder. In early October, particularly mild days, even warm, can occur, but in the course of the month there may be slight frosts. Between late October and early November, usually after the first night frosts, a mild period, with highs above 20&deg;C (68&deg;F), can occur: it&#39;s the so-called Indian summer. However, during the month of November it can get cold, with the first snowfalls and intense frosts.&nbsp;</p>\n\n<p><strong>Average rainfall in Chicago of the year</strong></p>\n\n<p>Precipitation amounts to 935 millimetres (37 inches) per year, and is well distributed over the seasons, at least in frequency, while in terms of quantity the winter is the driest season. In winter, and in spring and autumn, weather fronts pass, while in late spring and summer, when they become less frequent, thunderstorms can form in the afternoon or evening: it is no coincidence that August is the rainiest month. In winter, precipitation mainly occurs in the form of snow. An average of 92 centimetres (36 inches) of snow falls per year; every once in a while, a snowfall can be seen already in October, and in spring, sometimes it can snow even in April. The record belongs to the winter of 1978-79, when a total of 228 cm (90 in) of snow fell.<br />\n&nbsp;</p>', 'climate-and-weather-in-chicago-illinois-state-usa', '1539254048.png', 'Climate in Chicago, weather Chicago', NULL, NULL, 0, 1, '2018-12-04 02:35:33', 2, '2018-12-04 10:35:33'),
(38, 'Climate and weather in New York, USA', 'The climate of New York state is generally humid continental, while the extreme southeastern portion of the state (New York City area) lies in the warm humid subtropical climate zone.', '<p><strong>The climate of New York</strong> state is generally humid continental, while the extreme southeastern portion of the state (New York City area) lies in the warm humid subtropical climate zone.</p>\n\n<p>The annual average temperature across the state ranges from around 39&deg;F (4&deg;C) over the Adirondack Mountains to near 53&deg;F (12&deg;C) across Long Island. <strong>Weather in New York </strong>(NYC) is heavily influenced by two air masses: a warm, humid one from the southwest and a cold, dry one from the northwest. A cool, humid northeast airflow from the North Atlantic is much less common, and results in a persistent cloud deck with associated precipitation which linger across the region for prolonged periods of time. Temperature differences between the warmer coast and far northern inland sections can exceed 36 degrees Fahrenheit (20 degrees Celsius), with rain near the coast and frozen precipitation, such as sleet and freezing rain, falling inland. Two-thirds of such events occur between November and April. &nbsp;which moves from northeast to southwest.</p>\n\n<p>Unlike the vast majority of the state, New York City features a humid subtropical climate (Koppen Cfa). New York City is an urban heat island, with temperatures 5&deg;F-7&deg;F (3&deg;C-4&deg;C) warmer overnight than surrounding areas.</p>\n\n<p>New York City lies on the coast, but it&#39;s also on the edge of a continent that cools down in winter and heats up in summer, and where different air masses collide: the cold ones coming from Canada and the warm ones coming from the Gulf of Mexico. The result is an unstable climate, with waves of bad weather alternating with clear and sunny days.&nbsp;</p>\n\n<p><strong>New York weather in seasons of the year:</strong></p>\n\n<p><strong>Winter&nbsp;(from December to February)</strong></p>\n\n<p style="text-align:center"><strong><img alt="Winter in New York" src="/templateEditor/kcfinder/uploads/images/Winter-in-NYC.jpg" style="height:492px; width:690px" /></strong></p>\n\n<p>In New York, the winter is cold: the average temperature is just above freezing (0&deg;C or 32&deg;F), but cold spells, in which the temperature can drop to about -10/-15&deg;C (5/14&deg;F), are not rare. The wind chill can make the air feel colder than it actually is.&nbsp;<br />\nSnowfalls are frequent, and sometimes can be abundant, resulting in real snowstorms. On average, about 60 centimeters (15 inches) of snow fall annually. On other occasions, the wind can blow from the south, bringing some mild days, with highs around 12/15&deg;C (54/59&deg;F). There are also clear and sunny days, with cold nights, and daytime temperatures mild or in any case acceptable.&nbsp;</p>\n\n<p><strong>Spring (from March to May)</strong></p>\n\n<p style="text-align:center"><img alt="Spring in New York" src="/templateEditor/kcfinder/uploads/images/Spring-in-NYC.jpg" style="height:492px; width:690px" /></p>\n\n<p>The weather continues to be unstable: the first warm days alternate with the return of cold weather. In March it can snow, and sometimes this can still happen in early April. But already in April, sometimes the temperature can exceed 25&deg;C (77&deg;F). In May, the average temperature becomes pleasant, although there can still be cool days, or even a little cold and rainy, while the first heat waves can bring the temperature above 30&deg;C (86&deg;F). On sunny days, the first afternoon thunderstorms can erupt.&nbsp;</p>\n\n<p><strong>Summer (from June to August)</strong></p>\n\n<p style="text-align:center"><img alt="Summer in NYC" src="/templateEditor/kcfinder/uploads/images/Summer-in-NYC-1%281%29.jpg" style="height:492px; width:690px" /></p>\n\n<p>In the summer, <strong>the climate in New York</strong> (NYC)&nbsp;is hot, especially in July and August. However, there are different situations also in this season: cool days, maybe rainy as well, with highs around 23/25&deg;C (73/77&deg;F), alternate with hot days, with highs around 28/30&deg;C (82/86&deg;F). Sometimes even heat waves occur, in which the temperature reaches 35/38&deg;C (95/100&deg;F), and remains high during the night, around 23/25&deg;C (73/77&deg;F) or above. The amount of sunshine during the summer is good, even though, in addition to the passage of some weather disturbances, there is a moderate amount of afternoon thunderstorms.&nbsp;</p>\n\n<p><strong>Autumn (from September to November)</strong></p>\n\n<p style="text-align:center"><img alt="Autumn in NYC" src="/templateEditor/kcfinder/uploads/images/Autumn-in-NYC.jpg" style="height:492px; width:690px" /></p>\n\n<p>Autumn is milder and less unstable than the other seasons, at least in the first part. In early September, the weather is often still characterized by heat and humidity, with sunshine and some afternoon thunderstorms, then it quickly becomes mild and relatively quiet until mid-October, while in the second half of October the first cold days may occur. November is by now a cold month, and the first snowfalls may occur. There is a moderate amount of rainfall also in autumn, but it is still the season in which rainy days are a little less frequent.&nbsp;</p>\n\n<p><strong>Precipitation in New York</strong><br />\nAnnual precipitation is fairly even throughout the year across New York state. The Great Lakes region of New York sees the highest annual rain and snow amounts in New York state, and heavy lake-effect snow is common in both western and central New York in winter. In the hotter months, large, long-lived complexes of thunderstorms can invade the state from Canada and the Great Lakes, while tropical cyclones can bring rains and winds from the southwest during the summer and fall. Hurricane impacts on the state occur once every 18-19 years, with major hurricane impacts every 70-74 years. An average of ten tornadoes touch down in New York annually.<br />\n&nbsp;</p>', 'climate-and-weather-in-new-york-usa', '1539169108.png', 'climate in New York, climate NYC, weather in New York', NULL, NULL, 0, 1, '2018-12-04 02:34:44', 2, '2018-12-04 10:34:44'),
(37, 'Climate and weather in London, United Kingdom', 'London lies in the temperate oceanic climate, much like the British Isles, the city rarely witnesses temperatures too high or too low.', '<p>If you come from a country other than the United Kingdom, you would be interested in the climate and <strong>weather in London</strong> when you plan to travel or study abroad or work here. So, in order to be able to adapt quickly to the environment and climate here, you need to pay attention to the following: the difference in temperature between your local area and London; Seasonal climate change and and monitor the weather daily in London to be able to adapt to new environments easily.</p>\n\n<p>London lies in the temperate oceanic climate, much like the British Isles, the city rarely witnesses temperatures too high or too low.&nbsp;</p>\n\n<p><strong>Climate&nbsp;in London by seasons of the year:</strong></p>\n\n<p><strong>Spring (from March to May)</strong><br />\nSpring and autumn are mixed seasons and pleasant. In the spring, the weather in London is cool during the day and cold in the afternoon. The lowest temperature recorded was -21.1&deg;C (-6 &deg; F) in January 1795.&nbsp;</p>\n\n<p style="text-align:center"><img alt="Spring in London" src="/templateEditor/kcfinder/uploads/images/Spring-in-London.jpg" style="height:492px; width:690px" /></p>\n\n<p><strong>Summer (from June to August)</strong><br />\nSummer in London has warm weather with high July temperatures of 22.8&deg;C (73&deg;F) and low of 14&deg;C (57.2&deg;F). Temperatures can exceed 25&deg;C (77&deg;F) for several days, but for most years temperatures are just above 30 &deg; C (86&deg;F) for several days. The highest temperature ever recorded in the city was 38&deg;C (100&deg;F) in 2003.</p>\n\n<p style="text-align:center"><img alt="Summer in London" src="/templateEditor/kcfinder/uploads/images/Summer-in-London.jpg" style="height:492px; width:690px" /></p>\n\n<p><strong>Autumn (from September to November)</strong><br />\nFall weather is often cool and unstable due to the convection between the cool air from the north pole and the current of warm air from the tropics. London is a relatively dry city, despite its reputation as being a rainy city, London receives less &nbsp;precipitation in a year than compared to other cities of Europe.</p>\n\n<p style="text-align:center"><img alt="Autumn in London" src="/templateEditor/kcfinder/uploads/images/Autumn-in-London.jpg" style="height:492px; width:690px" /></p>\n\n<p><strong>Winter (from December to February)</strong><br />\nWinter in London is cold but rarely drops below freezing temperatures of around 5&deg;C (41&deg;F) - 8&deg;C (46&deg;F). London is rarely snow-free, mainly because temperatures in the surrounding areas make London warmer by about 5&deg;C (9&deg;F). However, snowfalls often occur several times a year.&nbsp;</p>\n\n<p style="text-align:center"><img alt="A warm winter day in London" src="/templateEditor/kcfinder/uploads/images/Winter-in-London.jpg" style="height:492px; width:690px" /></p>\n\n<p>The weather in London is quite erratic not to follow a rule. Therefore, visitors and students coming to London, update the London weather daily to be able to adapt to the changing weather conditions here, to enjoy life, study, work and play fully when coming to this beautiful city.</p>\n\n<p>The most beautiful time to visit London is summer, or more generally from mid-May to mid-September, during this time, <strong>the climate in London</strong> is cool, good for outdoor activities, although it&#39;s better to bring an umbrella, and a sweatshirt or sweater for the evening or for cool days. In summer you can hope to find a period of good weather, with warm days, in which the maximum temperature is above 25&deg;C (77&deg;F), or can even approach 30 &deg;C (86 &deg;F), and in which you can remove the outer layers of clothing, stroll in the numerous parks of the city and even sunbathe.</p>', 'climate-and-weather-in-london-united-kingdom', '1539164706.png', 'Climate in London, weather in London', NULL, NULL, 0, 1, '2018-12-04 02:30:24', 2, '2018-12-04 10:30:24'),
(36, 'Climate and weather in Paris, France', 'Paris is known as the city with cool weather, pleasant and peaceful. It has a temperate ocean climate, strongly influenced by the North Atlantic so climate in Paris is very pleasant and moderate', '<p>Paris is known as the city with cool weather, pleasant and peaceful. It has a temperate ocean climate, strongly influenced by the North Atlantic so climate in Paris is very pleasant and moderate. However, sometimes the <strong>weather in Paris</strong> can be very cold in winter and very hot in the summer as it is influenced by the continent.</p>\n\n<p>The climate of Paris in the seasons of the year</p>\n\n<p><strong>1. Summer (from June to August)</strong><br />\nIn Paris, the summer is usually warm and pleasant with average temperatures ranging from 15&deg;C (59&deg;F) to 25&deg;C (77&deg;F), long day and plenty of sunshine. Suitable for outdoor activities, picnics, walking.</p>\n\n<p>However, during the year there are several days of temperatures of up to 32&deg;C (90&deg;F) and record temperatures of up to 40.4&deg;C (104.7&deg;F) (according to statistics from 1980 to 2010 ). The sunny days of record are quite rare in Paris.</p>\n\n<p style="text-align:center"><img alt="Summer in Paris" src="/templateEditor/kcfinder/uploads/images/Summer-in-Paris.jpg" style="height:462px; width:690px" /></p>\n\n<p><strong>2. Autumn (from September to November)</strong><br />\nAutumn in Paris, the weather is dry and cool. Sunshine but not harsh. The average temperature is 12&deg;C (53.6&deg;F) to 21&deg;C (69.8&deg;F).</p>\n\n<p style="text-align:center"><img alt="Autumn in Paris" src="/templateEditor/kcfinder/uploads/images/Autumn-in-Paris%281%29.jpg" style="height:492px; width:690px" /></p>\n\n<p><strong>3. Winter (from December to February)</strong><br />\nWinter in Paris is not too cold, average temperature 3&deg;C (37.4&deg;F) to 7&deg; C(44.6&deg;F). Nighttime fog is quite common, with deep drops occurring only a few days per year down to -5&deg;C (23&deg;F).</p>\n\n<p>Snow falls every year, but rarely freezes on the ground. The coldest Paris weather occurs under the influence of cold air masses from Russia, which can lead to a few snow days, but usually not high, and frost. In Paris temperatures rarely drop to about -10&deg;C (14&deg;F).</p>\n\n<p style="text-align:center"><img alt="Winter in Paris" src="/templateEditor/kcfinder/uploads/images/Winter-in-Paris%281%29.jpg" style="height:492px; width:690px" /></p>\n\n<p><strong>4. Spring (from March to May)</strong><br />\nIn the spring, the climate is cool, pleasant and unstable, characterized by the passage of the Atlantic low pressure and due to temperature changes.</p>\n\n<p style="text-align:center"><img alt="Spring in Paris" src="/templateEditor/kcfinder/uploads/images/Spring-in-Paris%281%29.jpg" style="height:462px; width:690px" /></p>\n\n<p>The average temperature is 7 &deg; C (44.6&deg;F) to 19&deg;C (66&deg;F). The return of cold weather can still occur in the spring and there are short rains in March and sometimes even in April. Sometimes it is still cold in early May, with a high temperature of about 10&deg;C (50&deg;F).</p>\n\n<p><strong>Precipitation in Paris</strong><br />\nThe seasons of the year in Paris have little rainfall and erratic weather. Average rainfall is 650mm (26 inches), well distributed in seasons. The rains a little more often in winter and a little more in summer. Snow in Paris is not much, mainly in the coldest months as January, February, but sometimes in April.</p>\n\n<p>Like all major cities in the world, Paris also suffers from the effects of climate change, the environment due to rapid population growth and economic growth. The capital with the highest population density in Europe, but the proportion of green space in Paris is the lowest, although in recent decades some new parks and gardens were added.</p>', 'climate-and-weather-in-paris-france', '1538966176.png', 'Climate paris, the seasons in Paris', 'Paris is known as the city with cool weather, pleasant and peaceful. It has a temperate ocean climate, strongly influenced by the North Atlantic so climate in Paris is very pleasant and moderate', 'Climate and weather in Paris, France', 1, 1, '2018-12-04 02:35:14', 2, '2018-12-04 10:35:14'),
(40, 'Climate and weather in Toronto, Ontario, Canada', 'Toronto\'s climate is continental climate, moderated by Lake Ontario; its climate is among the mildest in Canada east of the Rocky Mountains, given Toronto\'s southerly latitude within the country.', '<p><strong>Toronto&#39;s climate</strong> is continental climate, moderated by Lake Ontario; its climate is among the mildest in Canada east of the Rocky Mountains, given Toronto&#39;s southerly latitude within the country. Toronto has a semi-continental climate, with a warm, humid summer and a cold winter. However, given the exposure to different types of air masses, jumps in temperature are frequent.&nbsp;</p>\n\n<p>Although Toronto is one of Canada&rsquo;s warmer cities in winter, &nbsp;but the winter is still severe, with snow on the ground most days between mid-December and mid-March. Snow deeper than 1 cm is seen on 65 days a year on average.</p>\n\n<p>All year round, fog is fairly common at night and in the early morning, especially in rural areas around the city.&nbsp;</p>\n\n<p>Weather&nbsp;Toronto&nbsp;in seasons of the year:</p>\n\n<p><strong>Winter (from late November to mid-March)</strong></p>\n\n<p style="text-align:center"><img alt="Winter in Toronto" src="/templateEditor/kcfinder/uploads/images/Winter-in-Toronto.jpg" style="height:492px; width:690px" /></p>\n\n<p>Winter in Toronto is cold, so that the average temperature, about -5.5 &deg;C (22 &deg;F) in January, is similar to that of northern European cities like Oslo. However, at least here the days are not as short as in the Nordic countries.&nbsp;<br />\nCold waves are accompanied by the blizzard, the north wind blowing in gusts.&nbsp;<br />\nGiven the constant instability of the weather, the temperature can exceed freezing (0 &deg;C or 32 &deg;F) also in winter, so that snow can melt and it can rain. On the other hand, waves of bitter cold, with peaks of -20/-25 &deg;C (-4/-13 &deg;F), occur practically every year.&nbsp;<br />\nSnowfalls are frequent, so much so that it snows for several days per month; occasionally, real snow storms may occur. Sometimes the phenomenon called &quot;ice storm&quot; (or glaze ice) may occur, that is, rain falling on frozen ground, freezing everything, roads, trees, light poles, cars etc.&nbsp;</p>\n\n<p><strong>Spring (from mid-March to May)</strong></p>\n\n<p style="text-align:center"><strong><img alt="Spring in Toronto" src="/templateEditor/kcfinder/uploads/images/Spring-in-Toronto-1.jpg" style="height:492px; width:690px" /></strong></p>\n\n<p>Spring in Toronto is an unstable season, characterized by changes in temperature: initially cold in March, with snowfalls and frosts still quite frequent, it advances gradually, with the first warm days but also the return of cold weather, and it is still on average cold in April, when it can still snow in the first half of the month, while it becomes mild in May, when also afternoon thunderstorms start to erupt during sunny days.&nbsp;</p>\n\n<p><strong>Summer (from June to August)</strong></p>\n\n<p><strong>Toronto weather</strong> is usually warm in the spring, with highs usually about 26/27 &deg;C (79/81 &deg;F); on hot days, when the temperature can reach or even exceed 30 &deg;C (86 &deg;F), it can also be muggy, due to contribution of Lake Ontario. However, in summer there are also cool and cloudy days, while in days of fine weather, which are cooled by the breeze from the lake, thunderstorms can erupt in the afternoon. Sometimes even heat waves may occur, with highs around 34/37 &deg;C (93/99 &deg;F), generally of short duration.&nbsp;</p>\n\n<p style="text-align:center"><img alt="Summer in Toronto" src="/templateEditor/kcfinder/uploads/images/Summer-in-Toronto-2.jpg" style="height:492px; width:690px" /></p>\n\n<p>Toronto enjoys a fairly sunny climate &ndash; its summers usually have an abundance of warm or hot sunny days, while its winters are rather less sunny than in the prairie cities of Calgary and Winnipeg. Toronto&rsquo;s smog is very much a summer phenomenon</p>\n\n<p><strong>Autumn (from September to mid-November)</strong><br />\nAutumn is initially pleasant, with many sunny days, in which the temperature exceeds 25 &deg;C (77 &deg;F): these periods, called Indian summer, occur in September, but sometimes also in October. As weeks pass, however, the temperature decreases rapidly, low pressure areas become more frequent and the first cold days occur.&nbsp;</p>\n\n<p style="text-align:center"><img alt="Autumn in Toronto" src="/templateEditor/kcfinder/uploads/images/Autumn-in-Toronto.jpg" style="height:492px; width:690px" /></p>\n\n<p>The amount of sunshine in Toronto is all in all good in late spring and summer; it is not high in the other months, and it&#39;s quite low in winter, when the sun is rarely seen.&nbsp;</p>\n\n<p><strong>Average rainfall in Toronto of the year</strong></p>\n\n<p>Precipitation amounts to about 800 millimetres (31.5 inches) per year, and is well distributed over the seasons: in fact disturbances can pass in all the months, due to the continual clashes between masses of warm and cold air, and in the only season in which they are less frequent, that is summer, afternoon thunderstorms can form: it&#39;s no coincidence that August is the rainiest month, at least as regards the amount. During the long winter months, from mid-November to March, precipitation occurs mainly in the form of snow. In an average year, about one metre and a half (5 feet) of snow fall; sometimes a snowfall can be seen already in October, and in spring, still in early May.&nbsp;</p>\n\n<p>The best time to visit Toronto runs from mid-May to late September. In the height of summer, ie in July and August, there may be hot and muggy days, so this period can be excluded if you cannot stand the heat; in May (and sometimes in early June) it can still be a bit cold. However, you always have to take into account the possibility of rain and changes in temperature.</p>', 'climate-and-weather-in-toronto-ontario-canada', '1539252926.png', 'Toronto\'s climate, the climate of Toronto, weather Toronto', NULL, NULL, 0, 1, '2018-10-11 18:17:30', 1, '2018-10-11 18:17:30'),
(41, 'Climate and weather in Boston, Massachusetts state, USA', 'You can better understand climate and weather in Boston, Massachusetts state, USA. Features of Boston weather in seasons of the year.', '<p>Boston lies in a zone of the northern United States, the capital of the State of Massachusetts, <strong>the climate of Boston</strong> is continental, with very cold and snowy winters, and warm (and sometimes hot) summers, with quite frequent thunderstorms. The city is located on the coast, but in the Atlantic Ocean at this latitude a cold current flows, in addition it&#39;s an area where different air masses collide: those coming down from Canada and those coming from the Gulf of Mexico. The result is an unstable climate, with waves of bad weather alternating with clear and sunny days.&nbsp;<br />\n<strong>Climate and weather in Boston</strong> by seasons of the year:</p>\n\n<p><strong>Winter (from December to mid-March)</strong><br />\nThe winter in Boston is very cold: the average temperature is just below freezing (0 &deg;C or 32 &deg;F), but cold spells, in which the temperature can drop to -15 &deg;C (5 &deg;F) and even below, are not uncommon. The freezing wind, called blizzard, can heighten the feeling of cold.&nbsp;</p>\n\n<p style="text-align:center"><img alt="The winter in Boston" src="/templateEditor/kcfinder/uploads/images/Winter-in-Boston.jpg" style="height:492px; width:690px" /></p>\n\n<p>Snowfalls are frequent, and sometimes can be abundant, resulting in real snowstorms. Example during the storm of the 17/18th of February 2003, 70 centimetres (27 inches) of snow fell, while on the 1st of April 1997, 64.5 cm (25.4 in) fell, and on the 26/27th of January 2015, 62.5 cm (24.6 in). Snow covers the ground for weeks. In a year, an average of 105 cm (41.5 in) of snow falls at the airport, and 115 cm (45 in) in the western districts.&nbsp;<br />\nOn other occasions, the south wind can bring some mild days, during which highs can reach 12/15 &deg;C (54/59 &deg;F), but this occurs less frequently than in New York.&nbsp;</p>\n\n<p><strong>Spring (from mid-March to mid-June)</strong></p>\n\n<p style="text-align:center"><img alt="The spring in Boston" src="/templateEditor/kcfinder/uploads/images/Spring-in-Boston.jpg" style="height:492px; width:690px" /></p>\n\n<p>In spring, <strong>the weather in Boston</strong> continues to be unstable: the first warm days alternate with the return of cold weather. In March, which in fact is often still a winter month, it snows on a frequent basis, and sometimes this can happen even in April, especially at the beginning of the month. But already in April, sometimes the temperature can touch or even exceed 25 &deg;C (77 &deg;F). In May, the average temperature is pleasant, although there are cool days, or even cold and rainy, while the first heat waves can raise the temperature above 30 &deg;C (86 &deg;F). On sunny days, also the first afternoon thunderstorms can erupt. In late spring and early summer, fog may form, maybe on rainy days. When the weather is fine, in the afternoon a cool and moderate breeze rises from the sea.&nbsp;</p>\n\n<p><strong>Summer (from mid-June to August)</strong></p>\n\n<p style="text-align:center"><img alt="The summer in Boston" src="/templateEditor/kcfinder/uploads/images/Summer-in-Boston.jpg" style="height:492px; width:690px" /></p>\n\n<p>The summer in Boston is hot and humid. Different situations can occur in this season as well: there are cool days, maybe with some rain, and with highs around 23/24 &deg;C (73/75 &deg;F), but also hot and quite muggy days, with highs around 28 &deg;C (82 &deg;F), with sunshine and the sea breeze, while sometimes even heat waves can occur, in which the daytime temperature can reach and exceed 35 &deg;C (95 &deg;F), and the minimum temperature remains high as well, around 23/25 &deg;C (73/77 &deg;F). The sunshine amount during the summer is good, however, in addition to the passage of some disturbances, there is a fair amount of afternoon thunderstorms, sometimes intense and accompanied by hail.</p>\n\n<p><strong>Autumn (from September to November)</strong></p>\n\n<p><strong>Boston weather</strong> in autumn is the mildest and less unstable season of the year, at least in the first part. In early September, the weather can still be characterized by heat and humidity, with sunshine and some afternoon thunderstorms, then quickly becomes mild until mid-October, while in the second half of October it can start to be a bit cold. November is already a cold month, and the first snowfalls can occur. Rainfall occurs quite often also in this season.&nbsp;</p>\n\n<p style="text-align:center"><img alt="The autumn in Boston" src="/templateEditor/kcfinder/uploads/images/Autumn-in-Boston.jpg" style="height:492px; width:690px" /></p>\n\n<p>The amount of sunshine in Boston is good in summer, but it is not scarce even in winter, because some sunny days can always occur. On average, there are 9.7 hours of sunshine per day in June and July, and 4.5 in December.&nbsp;</p>\n\n<p><strong>Precipitation in Boston</strong><br />\nRainfall in Boston is quite abundant, since it amounts to 1,100 millimetres (43 inches) per year, and is well distributed over the seasons. In winter it occurs mainly in the form of snow, while in summer, in addition to the passage of some disturbances that can bring some rainy days, thunderstorms in the afternoon or in the evening are quite frequent.&nbsp;</p>', 'climate-and-weather-in-boston-massachusetts-state-usa', '1539600045.png', 'Climate of Boston, weather in Boston, seasons of Boston', NULL, NULL, 0, 1, '2018-10-15 18:41:31', 1, '2018-10-15 18:41:31'),
(42, 'The weather and climate in Houston, Texas, USA', 'Houston is located in the southern part of the United States, so the weather and climate in Houston are warmer than other cities in North America. The climate of Houston city is classified as humid subtropical', '<p>Houston is the most populous city in the U.S. state of Texas and the fourth most populous city in the United States. It&#39;s located in the southern part of the United States, so <strong>the weather and climate in Houston</strong> are warmer than other cities in North America<br />\n<strong>The climate of Houston city</strong> is classified as humid subtropical, although it has a strong influence from the tropics.&nbsp;<br />\nHouston averages only 18 days per year with temperatures of 0&deg;C (32&deg;F) or less and 99 days with high temperatures of 32&deg;C (90&deg;F) or more. Temperatures rarely reach 38&deg;C (100&deg;F).&nbsp;<br />\nAugust normally ranks as the warmest month at 29&deg;C (84&deg;F) and January the coldest month at 12&deg;C (53.1&deg;F).</p>\n\n<p style="text-align:center"><img alt="Climate and weather in Houston, Texas, USA" src="/templateEditor/kcfinder/uploads/images/avata-climate-weather-Houston.jpg" style="height:460px; width:690px" /></p>\n\n<p>The normal annual precipitation measures 49.77 inches (1,264 mm). Occasional severe weather of Houston mostly takes the form of flooding. Supercell thunderstorms sometimes bring tornadoes to the area, most commonly during spring. Houston sometimes experiences tropical cyclones during the Atlantic hurricane season, which can bring heavy rain and significant damage to the city.</p>\n\n<p><strong>Spring (from March to May)</strong><br />\nSpring comes with a gradual warm up from winter. Temperatures are generally not hot yet, averaging from 24&deg;C - 28&deg;C (75&deg;F - 82&deg;F) in the day and 13&deg;C &ndash;18 &deg;C (56&deg;F - 64&deg;F) at night. Spring in Houston is warm climate and often stormy.</p>\n\n<p style="text-align:center"><img alt="Spring in Houston, Texas, USA" src="/templateEditor/kcfinder/uploads/images/Spring-in-Houston.jpg" style="height:460px; width:690px" /></p>\n\n<p><strong>Summer (from June to August)</strong><br />\nIn summer, the weather in Houston is very hot and humid, often with scattered afternoon showers and thunderstorms. The average relative humidity ranges from over 90 percent in the morning to around 60 percent in the afternoon. Summer temperatures in Houston are very similar to average temperatures seen in tropical climates, such as in the Philippines and Central America. The value of relative humidity results in a heat index higher than the actual temperature. The highest temperature ever recorded was 43&deg;C (109&deg;F) on September 4, 2000 and on August 27, 2011.</p>\n\n<p><strong>Autumn (from September to November)</strong></p>\n\n<p style="text-align:center"><img alt="Autumn in Houston, Texas, USA" src="/templateEditor/kcfinder/uploads/images/Autumn-in-Houston.jpg" style="height:460px; width:690px" /></p>\n\n<p>Autumn in Houston is warm, with temperatures averaging in the upper 20&deg;C -28&deg;C (60&deg;F - 80&deg;F) during the day and from 10&deg;C - 17&deg;C (50&deg;F- 60&deg;F) at night. Cool fronts that move through the region during the fall can bring rain. Hurricanes can move into the area from the Gulf of Mexico, bringing heavy rains and high winds.</p>\n\n<p><strong>Winter (from December to March)</strong><br />\nWinters in Houston are relatively mild and temperate compared to most areas of the United States. Houston winters are, on average, colder than South Florida and Southern California but warmer than Dallas, Atlanta, San Antonio, Austin, and other inland southern cities. The average high in January, the coldest month, is 17&deg;C (63&deg;F) and the low 6&deg;C (43&deg;F).</p>\n\n<p style="text-align:center"><img alt="Winter in Houston, Texas, USA" src="/templateEditor/kcfinder/uploads/images/Winter-in-Houston.jpg" style="height:460px; width:690px" /></p>\n\n<p>In December, southward-moving cold fronts can bring cold rain, low wind chills, and, rarely, frozen precipitation. Early January is the coldest time of the year, with temperatures moderating slightly by February.</p>\n\n<p><strong>Precipitation in Houston</strong><br />\nRainfall is the most common form of precipitation in Houston. The wettest month is June, with an average of 5.93 inches (151 mm) of rain. Houston normally receives 49.77 inches (1,264 mm) of precipitation on 104 days annually. &nbsp;Flash flood warnings are common all year, and due to the flat landscape, heavy rains often threaten life and property in the city. Sea breeze showers which are monsoon-like (especially during the summer months, originating from the mesoscale convective cycle, where the polar jet stream usually forms an omega block) are common throughout the Texas Gulf Coast area (from Brownsville to the Florida Peninsula), which has a similar climate to areas like Mumbai and Kolkata &ndash; locals refer to the sea breeze showers as the Gulf Coast Monsoon (also called the Gulf of Mexico or the Texas Monsoon), despite Houston being 50 feet above sea level.</p>', 'the-weather-and-climate-in-houston-texas-usa', '1541064773.png', 'Climate of Houston', NULL, NULL, 0, 1, '2018-11-01 17:41:56', 1, '2018-11-01 17:41:56'),
(43, 'Climate and weather in Washington state, USA', 'Washington\'s climate and weather varies greatly from west to east. The weather is relatively mild in Western and harsh weather in Eastern Washington', '<p>Washington, officially the State of Washington, is a state located in the Pacific Northwest region of the United States. Washington is sometimes referred to as Washington State, to distinguish it from Washington, D.C., the capital of the United States.&nbsp;</p>\n\n<p>Washington is the 18th largest state, with an area of 71,362 square miles (184,827 km2), and the 13th most populous state, with more than 7.4 million people. Approximately 60 percent of Washington&#39;s residents live in the Seattle metropolitan area, the center of transportation, business, and industry along Puget Sound, an inlet of the Pacific Ocean consisting of numerous islands, deep fjords, and bays carved out by glaciers. The remainder of the state consists of: deep temperate rainforests in the west; mountain ranges in the west, central, northeast, and far southeast; and a semi-arid basin region in the east, central, and south, given over to intensive agriculture. Washington is the second most populous state on the West Coast and in the Western United States, after California. It is one of the wealthiest and most liberally progressive states in the country.&nbsp;</p>\n\n<p style="text-align:center"><img alt="Climate and weather in Washington" src="/templateEditor/kcfinder/uploads/images/Avata-Climate-and-weather-in-Washington.jpg" style="height:460px; width:690px" /></p>\n\n<p>The Cascade Mountain Range divides the state Washington into two parts &ndash; Western Washington and Eastern Washington. Therefore, <strong>Washington&#39;s climate and weather</strong> varies greatly from west to east. A Mediterranean Climate predominates in western Washington, and a much drier semi-arid climate prevails east of the Cascade Range. Major factors determining Washington&#39;s climate include the large semi-permanent high pressure and low pressure systems of the north Pacific Ocean, the continental air masses of North America, and the Olympic and Cascade mountains.</p>\n\n<p style="text-align:center"><img alt="Fall in Washington State" src="/templateEditor/kcfinder/uploads/images/Fall-in-Washington.jpg" style="height:460px; width:690px" /></p>\n\n<p>The weather is relatively mild in Western Washington. &nbsp;Summer days, the weather here is usually cool, pleasant, rarely rising above 79 &deg; F (26 &deg; C) and the winter days are usually not too cold, rarely below 45 &deg; F (8 &deg; C) during the day. It is also rarely seen snow in West Washington in winter, although rain is common. Most of Washington&#39;s major cities are located in the west, including Tacoma, Olympia and Seattle. This means you&#39;ll probably have decent weather no matter what time of the year you travel here.</p>\n\n<p style="text-align:center"><img alt="Winter in Washington State" src="/templateEditor/kcfinder/uploads/images/Winter-in-Washington-1.jpg" style="height:460px; width:690px" /></p>\n\n<p><strong>The climate and weather</strong> of the cities of eastern Washington are somewhat harsher than the western cities of the state. Due to the influence of the Cascade Mountains in eastern Washington, snowfall is much more common in certain areas, with up to 200 inches falling on the mountains each year. In the cities in Eastern Washington, the weather can really vary depending on where you visit. For instance, Wenatchee and Chelan enjoy around 300 days of sunshine annually. Summers are also quite hot on this side of the state, with average temperatures reaching the low 90s. But overall, this side of the state makes for a great place to enjoy winter sports like skiing and snowboarding, such as at Mt. Spokane Ski and Snowboard Park.&nbsp;</p>\n\n<p><strong>Weather in Washington State</strong> varies by region. Therefore, you plan to travel or study in Washington, should update the daily weather in Washington, to monitor and adapt quickly to the climate and weather in this state.</p>', 'climate-and-weather-in-washington-state-usa', '1541407463.png', 'Climate of Washington state, Climate and weather in Washington state', NULL, NULL, 0, 1, '2018-11-05 08:52:04', 1, '2018-11-05 16:52:04');

-- --------------------------------------------------------

--
-- Cấu trúc bảng cho bảng `roles`
--

CREATE TABLE `roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `permission` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Đang đổ dữ liệu cho bảng `roles`
--

INSERT INTO `roles` (`id`, `name`, `permission`, `created_at`, `updated_at`) VALUES
(1, 'admin', '31,32,41,40,39,38,33,34,35,46,42,43,45,44,', '2018-07-08 11:15:17', '2018-07-20 02:02:24');

-- --------------------------------------------------------

--
-- Cấu trúc bảng cho bảng `trendding_topic`
--

CREATE TABLE `trendding_topic` (
  `id` int(10) UNSIGNED NOT NULL,
  `title` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `detail` longtext COLLATE utf8mb4_unicode_ci,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_keywords` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `seo_description` text COLLATE utf8mb4_unicode_ci,
  `seo_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sticky` tinyint(4) NOT NULL,
  `created_by` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `updated_by` int(11) NOT NULL,
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Đang đổ dữ liệu cho bảng `trendding_topic`
--

INSERT INTO `trendding_topic` (`id`, `title`, `description`, `detail`, `slug`, `image`, `seo_keywords`, `seo_description`, `seo_title`, `sticky`, `created_by`, `created_at`, `updated_by`, `updated_at`) VALUES
(31, 'Class Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy,At Website.com, we believe everyone deser', 'At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy: our goal is to remove any technical or financial barriers that can prevent business owners from making their own website. At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy . At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy', '<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>', 'at-websitecom-we-believe-everyone-deserves-to-have-a-website-or-online-store-innovation-and-simplicity-makes-us-happyat-websitecom-we-believe-everyone-deser', '1533191741.png', NULL, NULL, NULL, 1, 1, '2018-07-21 20:36:17', 1, '2018-07-31 01:37:14'),
(30, 'Dulicate Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy,At Website.com, we believe everyone deser', 'At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy: our goal is to remove any technical or financial barriers that can prevent business owners from making their own website. At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy . At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy', '<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>', 'at-websitecom-we-believe-everyone-deserves-to-have-a-website-or-online-store-innovation-and-simplicity-makes-us-happyat-websitecom-we-believe-everyone-deser', '1533191741.png', NULL, NULL, NULL, 1, 1, '2018-07-21 20:36:17', 1, '2018-07-31 01:37:14'),
(32, 'Blue  Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy,At Website.com, we believe everyone deser', 'At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy: our goal is to remove any technical or financial barriers that can prevent business owners from making their own website. At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy . At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy', '<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>\r\n\r\n<p>At Website.com, we believe everyone deserves to have a website or online store. Innovation and simplicity makes us happy</p>', 'at-websitecom-we-believe-everyone-deserves-to-have-a-website-or-online-store-innovation-and-simplicity-makes-us-happyat-websitecom-we-believe-everyone-deser', '1533191741.png', NULL, NULL, NULL, 1, 1, '2018-07-21 20:36:17', 1, '2018-07-31 01:37:14'),
(33, 'AAAAAAA', 'AAAAAA', '<p>AAAAAAAA</p>', 'aaaaaaa', '1533191741.png', 'demo,hehe', 'a', 'a', 1, 1, '2018-07-12 00:57:08', 1, '2018-07-12 20:21:54');

--
-- Chỉ mục cho các bảng đã đổ
--

--
-- Chỉ mục cho bảng `cities`
--
ALTER TABLE `cities`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `contacts`
--
ALTER TABLE `contacts`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `famous_cities`
--
ALTER TABLE `famous_cities`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `faqs`
--
ALTER TABLE `faqs`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `faq_categories`
--
ALTER TABLE `faq_categories`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `languages`
--
ALTER TABLE `languages`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `posts`
--
ALTER TABLE `posts`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`);

--
-- Chỉ mục cho bảng `trendding_topic`
--
ALTER TABLE `trendding_topic`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT cho các bảng đã đổ
--

--
-- AUTO_INCREMENT cho bảng `cities`
--
ALTER TABLE `cities`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7323;
--
-- AUTO_INCREMENT cho bảng `contacts`
--
ALTER TABLE `contacts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
--
-- AUTO_INCREMENT cho bảng `countries`
--
ALTER TABLE `countries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=237;
--
-- AUTO_INCREMENT cho bảng `famous_cities`
--
ALTER TABLE `famous_cities`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=101;
--
-- AUTO_INCREMENT cho bảng `faqs`
--
ALTER TABLE `faqs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=45;
--
-- AUTO_INCREMENT cho bảng `faq_categories`
--
ALTER TABLE `faq_categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;
--
-- AUTO_INCREMENT cho bảng `languages`
--
ALTER TABLE `languages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=135;
--
-- AUTO_INCREMENT cho bảng `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT cho bảng `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT cho bảng `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=47;
--
-- AUTO_INCREMENT cho bảng `posts`
--
ALTER TABLE `posts`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=44;
--
-- AUTO_INCREMENT cho bảng `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;
--
-- AUTO_INCREMENT cho bảng `trendding_topic`
--
ALTER TABLE `trendding_topic`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;
