INSERT INTO `cities` (`id`, `name`, `state_id`) VALUES
(45784, 'Toledo', 3959),
(45785, 'Trotwood', 3959),
(45786, 'Troy', 3959),
(45787, 'Twinsburg', 3959),
(45788, 'University Heights', 3959),
(45789, 'Upper Arlington', 3959),
(45790, 'Urbana', 3959),
(45791, 'Valley Glen', 3959),
(45792, 'Van Wert', 3959),
(45793, 'Vandalia', 3959),
(45794, 'Vermilion', 3959),
(45795, 'Wadsworth', 3959),
(45796, 'Warren', 3959),
(45797, 'Warrensville Heights', 3959),
(45798, 'Washington', 3959),
(45799, 'Waverly', 3959),
(45800, 'West Carrollton City', 3959),
(45801, 'West Chester', 3959),
(45802, 'Westerville', 3959),
(45803, 'Westlake', 3959),
(45804, 'White Oak', 3959),
(45805, 'Whitehall', 3959),
(45806, 'Wickliffe', 3959),
(45807, 'Willoughby', 3959),
(45808, 'Willowick', 3959),
(45809, 'Wilmington', 3959),
(45810, 'Winesburg', 3959),
(45811, 'Wooster', 3959),
(45812, 'Worthington', 3959),
(45813, 'Xenia', 3959),
(45814, 'Yellow Springs', 3959),
(45815, 'Youngstown', 3959),
(45816, 'Zanesville', 3959),
(45817, 'Ada', 3960),
(45818, 'Altus', 3960),
(45819, 'Ardmore', 3960),
(45820, 'Bartlesville', 3960),
(45821, 'Bethany', 3960),
(45822, 'Bixby', 3960),
(45823, 'Broken Arrow', 3960),
(45824, 'Catoosa', 3960),
(45825, 'Chickasha', 3960),
(45826, 'Choctaw', 3960),
(45827, 'Claremore', 3960),
(45828, 'Del City', 3960),
(45829, 'Duncan', 3960),
(45830, 'Durant', 3960),
(45831, 'Edmond', 3960),
(45832, 'El Reno', 3960),
(45833, 'Elk City', 3960),
(45834, 'Enid', 3960),
(45835, 'Fort Sill', 3960),
(45836, 'Grove', 3960),
(45837, 'Guthrie', 3960),
(45838, 'Heavener', 3960),
(45839, 'Hugo', 3960),
(45840, 'Lawton', 3960),
(45841, 'Lindsay', 3960),
(45842, 'MacAlester', 3960),
(45843, 'Miami', 3960),
(45844, 'Midwest City', 3960),
(45845, 'Moore', 3960),
(45846, 'Morrison', 3960),
(45847, 'Muskogee', 3960),
(45848, 'Mustang', 3960),
(45849, 'Norman', 3960),
(45850, 'Oklahoma City', 3960),
(45851, 'Okmulgee', 3960),
(45852, 'Owasso', 3960),
(45853, 'Pawnee', 3960),
(45854, 'Ponca City', 3960),
(45855, 'Rattan', 3960),
(45856, 'Sand Springs', 3960),
(45857, 'Sapulpa', 3960),
(45858, 'Shawnee', 3960),
(45859, 'Stillwater', 3960),
(45860, 'Sulphur', 3960),
(45861, 'Tahlequah', 3960),
(45862, 'The Village', 3960),
(45863, 'Tulsa', 3960),
(45864, 'Weatherford', 3960),
(45865, 'Welch', 3960),
(45866, 'Woodward', 3960),
(45867, 'Yukon', 3960),
(45868, 'Point Edward', 3961),
(45869, 'Woodbridge', 3961),
(45870, 'Albany', 3962),
(45871, 'Aloha', 3962),
(45872, 'Altamont', 3962),
(45873, 'Arleta', 3962),
(45874, 'Ashland', 3962),
(45875, 'Astoria', 3962),
(45876, 'Baker City', 3962),
(45877, 'Beaverton', 3962),
(45878, 'Bend', 3962),
(45879, 'Canby', 3962),
(45880, 'Cave Junction', 3962),
(45881, 'Cedar Hills', 3962),
(45882, 'Cedar Mill', 3962),
(45883, 'Central Point', 3962),
(45884, 'City of The Dalles', 3962),
(45885, 'Coos Bay', 3962),
(45886, 'Corvallis', 3962),
(45887, 'Creswell', 3962),
(45888, 'Dallas', 3962),
(45889, 'Donald', 3962),
(45890, 'Eugene', 3962),
(45891, 'Forest Grove', 3962),
(45892, 'Four Corners', 3962),
(45893, 'Gladstone', 3962),
(45894, 'Glide', 3962),
(45895, 'Grants Pass', 3962),
(45896, 'Gresham', 3962),
(45897, 'Hayesville', 3962),
(45898, 'Hazelwood', 3962),
(45899, 'Hermiston', 3962),
(45900, 'Hillsboro', 3962),
(45901, 'Hood River', 3962),
(45902, 'Hubbard', 3962),
(45903, 'John Day', 3962),
(45904, 'Jordan Valley', 3962),
(45905, 'Keizer', 3962),
(45906, 'Klamath Falls', 3962),
(45907, 'La Grande', 3962),
(45908, 'Lake Oswego', 3962),
(45909, 'Lebanon', 3962),
(45910, 'Lincoln', 3962),
(45911, 'MacMinnville', 3962),
(45912, 'Medford', 3962),
(45913, 'Milwaukie', 3962),
(45914, 'Newberg', 3962),
(45915, 'Newport', 3962),
(45916, 'North Bend', 3962),
(45917, 'OBrien', 3962),
(45918, 'Oak Grove', 3962),
(45919, 'Oatfield', 3962),
(45920, 'Ontario', 3962),
(45921, 'Oregon City', 3962),
(45922, 'Pendleton', 3962),
(45923, 'Portland', 3962),
(45924, 'Redmond', 3962),
(45925, 'Riddle', 3962),
(45926, 'River Road', 3962),
(45927, 'Roseburg', 3962),
(45928, 'Salem', 3962),
(45929, 'Sherwood', 3962),
(45930, 'Springfield', 3962),
(45931, 'Sublimity', 3962),
(45932, 'Sutherlin', 3962),
(45933, 'Talent', 3962),
(45934, 'Tigard', 3962),
(45935, 'Troutdale', 3962),
(45936, 'Tualatin', 3962),
(45937, 'Turner', 3962),
(45938, 'Vaughn', 3962),
(45939, 'West Linn', 3962),
(45940, 'Wilsonville', 3962),
(45941, 'Woodburn', 3962),
(45942, 'Akron', 3963),
(45943, 'Aliquippa', 3963),
(45944, 'Allentown', 3963),
(45945, 'Altoona', 3963),
(45946, 'Ambler', 3963),
(45947, 'Amityville', 3963),
(45948, 'Ardmore', 3963),
(45949, 'Audubon', 3963),
(45950, 'Back Mountain', 3963),
(45951, 'Baldwin', 3963),
(45952, 'Bangor', 3963),
(45953, 'Beaver Falls', 3963),
(45954, 'Belle Vernon', 3963),
(45955, 'Bensalem', 3963),
(45956, 'Berwick', 3963),
(45957, 'Berwyn', 3963),
(45958, 'Bethel Park', 3963),
(45959, 'Bethlehem', 3963),
(45960, 'Bloomsburg', 3963),
(45961, 'Boyertown', 3963),
(45962, 'Bradford', 3963),
(45963, 'Brentwood', 3963),
(45964, 'Bridgeport', 3963),
(45965, 'Bristol', 3963),
(45966, 'Brockway', 3963),
(45967, 'Broomall', 3963),
(45968, 'Bushkill', 3963),
(45969, 'Butler', 3963),
(45970, 'Camp Hill', 3963),
(45971, 'Canonsburg', 3963),
(45972, 'Carbondale', 3963),
(45973, 'Carlisle', 3963),
(45974, 'Carnegie', 3963),
(45975, 'Carnot Moon', 3963),
(45976, 'Chambersburg', 3963),
(45977, 'Chester', 3963),
(45978, 'Chester Springs', 3963),
(45979, 'Clarks Summit', 3963),
(45980, 'Coatesville', 3963),
(45981, 'Colonial Park', 3963),
(45982, 'Columbia', 3963),
(45983, 'Conshohocken', 3963),
(45984, 'Coraopolis', 3963),
(45985, 'Corry', 3963),
(45986, 'Cranberry Township', 3963),
(45987, 'Cresco', 3963),
(45988, 'Croydon', 3963),
(45989, 'Dallas', 3963),
(45990, 'Dallastown', 3963),
(45991, 'Darby', 3963),
(45992, 'Darby Township', 3963),
(45993, 'Downingtown', 3963),
(45994, 'Drexel Hill', 3963),
(45995, 'Duncansville', 3963),
(45996, 'Dunmore', 3963),
(45997, 'East Norriton', 3963),
(45998, 'East Stroudsburg', 3963),
(45999, 'Easton', 3963),
(46000, 'Economy', 3963),
(46001, 'Edinboro', 3963),
(46002, 'Elizabethtown', 3963),
(46003, 'Elkins Park', 3963),
(46004, 'Emmaus', 3963),
(46005, 'Ephrata', 3963),
(46006, 'Erdenheim', 3963),
(46007, 'Erie', 3963),
(46008, 'Erwinna', 3963),
(46009, 'Exton', 3963),
(46010, 'Feasterville', 3963),
(46011, 'Folcroft', 3963),
(46012, 'Franklin', 3963),
(46013, 'Franklin Park', 3963),
(46014, 'Frederick', 3963),
(46015, 'Fullerton', 3963),
(46016, 'Furlong', 3963),
(46017, 'Gettysburg', 3963),
(46018, 'Gibsonia', 3963),
(46019, 'Glenside', 3963),
(46020, 'Gordonville', 3963),
(46021, 'Greensburg', 3963),
(46022, 'Gwynedd', 3963),
(46023, 'Hampden Township', 3963),
(46024, 'Hanover', 3963),
(46025, 'Harleysville', 3963),
(46026, 'Harrisburg', 3963),
(46027, 'Harrison Township', 3963),
(46028, 'Hatboro', 3963),
(46029, 'Haverford', 3963),
(46030, 'Havertown', 3963),
(46031, 'Hazleton', 3963),
(46032, 'Hermitage', 3963),
(46033, 'Hershey', 3963),
(46034, 'Hollidaysburg', 3963),
(46035, 'Horsham', 3963),
(46036, 'Huntingdon Valley', 3963),
(46037, 'Indiana', 3963),
(46038, 'Irvine', 3963),
(46039, 'Ivyland', 3963),
(46040, 'Jeannette', 3963),
(46041, 'Jefferson', 3963),
(46042, 'Jenkintown', 3963),
(46043, 'Johnstown', 3963),
(46044, 'Kempton', 3963),
(46045, 'Kennett Square', 3963),
(46046, 'King of Prussia', 3963),
(46047, 'Kingston', 3963),
(46048, 'Kutztown', 3963),
(46049, 'Lafayette Hill', 3963),
(46050, 'Lancaster', 3963),
(46051, 'Landenberg', 3963),
(46052, 'Langhorne', 3963),
(46053, 'Lansdale', 3963),
(46054, 'Lansdowne', 3963),
(46055, 'Lansford', 3963),
(46056, 'Laurys Station', 3963),
(46057, 'Lebanon', 3963),
(46058, 'Lehighton', 3963),
(46059, 'Levittown', 3963),
(46060, 'Lincoln University', 3963),
(46061, 'Linesville', 3963),
(46062, 'Linwood', 3963),
(46063, 'Lower Burrell', 3963),
(46064, 'Lower Merion', 3963),
(46065, 'MacCandless Township', 3963),
(46066, 'MacKeesport', 3963),
(46067, 'Malvern', 3963),
(46068, 'Meadville', 3963),
(46069, 'Mechanicsburg', 3963),
(46070, 'Media', 3963),
(46071, 'Merion Station', 3963),
(46072, 'Middleburg', 3963),
(46073, 'Mifflinville', 3963),
(46074, 'Milanville', 3963),
(46075, 'Milford', 3963),
(46076, 'Millersburg', 3963),
(46077, 'Monessen', 3963),
(46078, 'Moscow', 3963),
(46079, 'Mount Carmel', 3963),
(46080, 'Mount Lebanon', 3963),
(46081, 'Mountville', 3963),
(46082, 'Munhall', 3963),
(46083, 'Municipality of Monroeville', 3963),
(46084, 'Municipality of Murrysville', 3963),
(46085, 'N. Charleroi', 3963),
(46086, 'Nanticoke', 3963),
(46087, 'Narberth', 3963),
(46088, 'Natrona Heights', 3963),
(46089, 'Nazareth', 3963),
(46090, 'Nether Providence Township', 3963),
(46091, 'New Buffalo', 3963),
(46092, 'New Carlisle', 3963),
(46093, 'New Castle', 3963),
(46094, 'New Cumberland', 3963),
(46095, 'New Hope', 3963),
(46096, 'New Kensington', 3963),
(46097, 'Newton', 3963),
(46098, 'Newtown', 3963),
(46099, 'Newville', 3963),
(46100, 'Norristown', 3963),
(46101, 'North East', 3963),
(46102, 'North Versailles', 3963),
(46103, 'North Wales', 3963),
(46104, 'Oaks', 3963),
(46105, 'Oil City', 3963),
(46106, 'Olyphant', 3963),
(46107, 'Orrtanna', 3963),
(46108, 'Orwigsburg', 3963),
(46109, 'Oxford', 3963),
(46110, 'Paoli', 3963),
(46111, 'Parksburg', 3963),
(46112, 'Penn Hills', 3963),
(46113, 'Philadelphia', 3963),
(46114, 'Phildelphia', 3963),
(46115, 'Phoenixville', 3963),
(46116, 'Pipersville', 3963),
(46117, 'Pittsburgh', 3963),
(46118, 'Pleasantville', 3963),
(46119, 'Plum', 3963),
(46120, 'Pocono Summit', 3963),
(46121, 'Pottstown', 3963),
(46122, 'Pottsville', 3963),
(46123, 'Primos', 3963),
(46124, 'Progress', 3963),
(46125, 'Prospect', 3963),
(46126, 'Quakertown', 3963),
(46127, 'Radnor Township', 3963),
(46128, 'Reading', 3963),
(46129, 'Robinson Township', 3963),
(46130, 'Roseto', 3963),
(46131, 'Ross Township', 3963),
(46132, 'Royersford', 3963),
(46133, 'Saint Marys', 3963),
(46134, 'Sarver', 3963),
(46135, 'Saxonburg', 3963),
(46136, 'Scott Township', 3963),
(46137, 'Scranton', 3963),
(46138, 'Seward', 3963),
(46139, 'Sewickley', 3963),
(46140, 'Shaler Township', 3963),
(46141, 'Sharon', 3963),
(46142, 'Shermans Dale', 3963),
(46143, 'Somerset', 3963),
(46144, 'Souderton', 3963),
(46145, 'South Park Township', 3963),
(46146, 'Southampton', 3963),
(46147, 'Springfield', 3963),
(46148, 'State College', 3963),
(46149, 'Strasburg', 3963),
(46150, 'Sunbury', 3963),
(46151, 'Susquehanna', 3963),
(46152, 'Swissvale', 3963),
(46153, 'Tamaqua', 3963),
(46154, 'Taylor', 3963),
(46155, 'Telford', 3963),
(46156, 'Trevose', 3963),
(46157, 'Turtle Creek', 3963),
(46158, 'Tyrone', 3963),
(46159, 'Uniontown', 3963),
(46160, 'Upper Darby', 3963),
(46161, 'Upper Providence Township', 3963),
(46162, 'Upper Saint Clair', 3963),
(46163, 'Vanderbilt', 3963),
(46164, 'Warminster', 3963),
(46165, 'Warren', 3963),
(46166, 'Warrendale', 3963),
(46167, 'Washington', 3963),
(46168, 'Waterford', 3963),
(46169, 'Waverly', 3963),
(46170, 'Wayne', 3963),
(46171, 'Waynesboro', 3963),
(46172, 'West Chester', 3963),
(46173, 'West Mifflin', 3963),
(46174, 'West Norriton', 3963),
(46175, 'West Point', 3963),
(46176, 'Wexford', 3963),
(46177, 'Whitehall', 3963),
(46178, 'Wilcox', 3963),
(46179, 'Wilkes-Barre', 3963),
(46180, 'Wilkinsburg', 3963),
(46181, 'Williamsport', 3963),
(46182, 'Willow Grove', 3963),
(46183, 'Womelsdorf', 3963),
(46184, 'Woodlyn', 3963),
(46185, 'Woolrich', 3963),
(46186, 'Wyncote', 3963),
(46187, 'Wyndmoor', 3963),
(46188, 'Wynnewood', 3963),
(46189, 'Yardley', 3963),
(46190, 'Yeadon', 3963),
(46191, 'York', 3963),
(46192, 'Ramey', 3964),
(46193, 'Adamsville', 3969),
(46194, 'Alcoa', 3969),
(46195, 'Antioch', 3969),
(46196, 'Arlington', 3969),
(46197, 'Athens', 3969),
(46198, 'Bartlett', 3969),
(46199, 'Bell Buckle', 3969),
(46200, 'Bloomingdale', 3969),
(46201, 'Blountville', 3969),
(46202, 'Brentwood', 3969),
(46203, 'Bristol', 3969),
(46204, 'Brownsville', 3969),
(46205, 'Burns', 3969),
(46206, 'Chattanooga', 3969),
(46207, 'Clarksville', 3969),
(46208, 'Cleveland', 3969),
(46209, 'Collierville', 3969),
(46210, 'Columbia', 3969),
(46211, 'Cookeville', 3969),
(46212, 'Cornersville', 3969),
(46213, 'Crossville', 3969),
(46214, 'Dayton', 3969),
(46215, 'Dickson', 3969),
(46216, 'Dyersburg', 3969),
(46217, 'East Brainerd', 3969),
(46218, 'East Ridge', 3969),
(46219, 'Elizabethton', 3969),
(46220, 'Farragut', 3969),
(46221, 'Franklin', 3969),
(46222, 'Gainesboro', 3969),
(46223, 'Gallatin', 3969),
(46224, 'Gatlinburg', 3969),
(46225, 'Germantown', 3969),
(46226, 'Goodlettsville', 3969),
(46227, 'Greeneville', 3969),
(46228, 'Hendersonville', 3969),
(46229, 'Hixson', 3969),
(46230, 'Jackson', 3969),
(46231, 'Johnson City', 3969),
(46232, 'Kingsport', 3969),
(46233, 'Knoxville', 3969),
(46234, 'Kodak', 3969),
(46235, 'La Vergne', 3969),
(46236, 'Lawrenceburg', 3969),
(46237, 'Lebanon', 3969),
(46238, 'Lenoir City', 3969),
(46239, 'Lewisburg', 3969),
(46240, 'MacMinnville', 3969),
(46241, 'Maryville', 3969),
(46242, 'Memphis', 3969),
(46243, 'Middle Valley', 3969),
(46244, 'Millington', 3969),
(46245, 'Morristown', 3969),
(46246, 'Mulberry', 3969),
(46247, 'Murfreesboro', 3969),
(46248, 'Nashville', 3969),
(46249, 'Oak Ridge', 3969),
(46250, 'Ooltewah', 3969),
(46251, 'Pinson', 3969),
(46252, 'Red Bank', 3969),
(46253, 'Selmer', 3969),
(46254, 'Sevierville', 3969),
(46255, 'Shelbyville', 3969),
(46256, 'Smithville', 3969),
(46257, 'Smyrna', 3969),
(46258, 'Spring City', 3969),
(46259, 'Springfield', 3969),
(46260, 'Tazewell', 3969),
(46261, 'Trenton', 3969),
(46262, 'Tullahoma', 3969),
(46263, 'Union City', 3969),
(46264, 'Abilene', 3970),
(46265, 'Addison', 3970),
(46266, 'Alamo', 3970),
(46267, 'Aldine', 3970),
(46268, 'Alice', 3970),
(46269, 'Allen', 3970),
(46270, 'Alvin', 3970),
(46271, 'Amarillo', 3970),
(46272, 'Anderson Mill', 3970),
(46273, 'Andrews', 3970),
(46274, 'Angleton', 3970),
(46275, 'Argyle', 3970),
(46276, 'Arlington', 3970),
(46277, 'Aspermont', 3970),
(46278, 'Atascocita', 3970),
(46279, 'Athens', 3970),
(46280, 'Austin', 3970),
(46281, 'Austinn', 3970),
(46282, 'Azle', 3970),
(46283, 'Balch Springs', 3970),
(46284, 'Barry', 3970),
(46285, 'Bay City', 3970),
(46286, 'Baytown', 3970),
(46287, 'Beaumont', 3970),
(46288, 'Bedford', 3970),
(46289, 'Beeville', 3970),
(46290, 'Bellaire', 3970),
(46291, 'Belton', 3970),
(46292, 'Benbrook', 3970),
(46293, 'Big Spring', 3970),
(46294, 'Bluff Dale', 3970),
(46295, 'Boerne', 3970),
(46296, 'Borger', 3970),
(46297, 'Breckenridge', 3970),
(46298, 'Brenham', 3970),
(46299, 'Brownfield', 3970),
(46300, 'Brownsville', 3970),
(46301, 'Brownwood', 3970),
(46302, 'Bryan', 3970),
(46303, 'Buda', 3970),
(46304, 'Burkburnett', 3970),
(46305, 'Burleson', 3970),
(46306, 'Campbell', 3970),
(46307, 'Canyon', 3970),
(46308, 'Canyon Lake', 3970),
(46309, 'Carrollton', 3970),
(46310, 'Cat Spring', 3970),
(46311, 'Cedar Hill', 3970),
(46312, 'Cedar Park', 3970),
(46313, 'Celina', 3970),
(46314, 'Center', 3970),
(46315, 'Channelview', 3970),
(46316, 'City of Dallas', 3970),
(46317, 'Cleburne', 3970),
(46318, 'Cloverleaf', 3970),
(46319, 'Clute', 3970),
(46320, 'College Station', 3970),
(46321, 'Colleyville', 3970),
(46322, 'Columbus', 3970),
(46323, 'Comanche', 3970),
(46324, 'Conroe', 3970),
(46325, 'Converse', 3970),
(46326, 'Coppell', 3970),
(46327, 'Copperas Cove', 3970),
(46328, 'Corinth', 3970),
(46329, 'Corpus Christi', 3970),
(46330, 'Corsicana', 3970),
(46331, 'Cotulla', 3970),
(46332, 'Crandall', 3970),
(46333, 'Cypress', 3970),
(46334, 'Dallas', 3970),
(46335, 'Dayton', 3970),
(46336, 'DeSoto', 3970),
(46337, 'Deer Park', 3970),
(46338, 'Del Rio', 3970),
(46339, 'Denison', 3970),
(46340, 'Denton', 3970),
(46341, 'Dickinson', 3970),
(46342, 'Donna', 3970),
(46343, 'Dumas', 3970),
(46344, 'Duncanville', 3970),
(46345, 'Eagle Pass', 3970),
(46346, 'Edinburg', 3970),
(46347, 'El Campo', 3970),
(46348, 'El Paso', 3970),
(46349, 'Elmendorf', 3970),
(46350, 'Ennis', 3970),
(46351, 'Euless', 3970),
(46352, 'Fairfield', 3970),
(46353, 'Farmers Branch', 3970),
(46354, 'Flower Mound', 3970),
(46355, 'Forest Hill', 3970),
(46356, 'Forney', 3970),
(46357, 'Fort Bliss', 3970),
(46358, 'Fort Hood', 3970),
(46359, 'Fort Worth', 3970),
(46360, 'Freeport', 3970),
(46361, 'Friendswood', 3970),
(46362, 'Frisco', 3970),
(46363, 'Gainesville', 3970),
(46364, 'Galena Park', 3970),
(46365, 'Galveston', 3970),
(46366, 'Garland', 3970),
(46367, 'Gatesville', 3970),
(46368, 'Georgetown', 3970),
(46369, 'Grand Prairie', 3970),
(46370, 'Grandview', 3970),
(46371, 'Grapeland', 3970),
(46372, 'Grapevine', 3970),
(46373, 'Greenville', 3970),
(46374, 'Gregory', 3970),
(46375, 'Groves', 3970),
(46376, 'Haltom City', 3970),
(46377, 'Harker Heights', 3970),
(46378, 'Harlingen', 3970),
(46379, 'Henderson', 3970),
(46380, 'Hereford', 3970),
(46381, 'Hewitt', 3970),
(46382, 'Highland Village', 3970),
(46383, 'Hillsboro', 3970),
(46384, 'Houston', 3970),
(46385, 'Humble', 3970),
(46386, 'Huntsville', 3970),
(46387, 'Hurst', 3970),
(46388, 'Ingleside', 3970),
(46389, 'Irving', 3970),
(46390, 'Jacksonville', 3970),
(46391, 'Jefferson', 3970),
(46392, 'Jollyville', 3970),
(46393, 'Justin', 3970),
(46394, 'Katy', 3970),
(46395, 'Kaufman', 3970),
(46396, 'Keller', 3970),
(46397, 'Kemah', 3970),
(46398, 'Kemp', 3970),
(46399, 'Kerrville', 3970),
(46400, 'Kilgore', 3970),
(46401, 'Killeen', 3970),
(46402, 'Kingsville', 3970),
(46403, 'Kingwood', 3970),
(46404, 'La Marque', 3970),
(46405, 'La Porte', 3970),
(46406, 'Lackland Air Force Base', 3970),
(46407, 'Lago Vista', 3970),
(46408, 'Lake Jackson', 3970),
(46409, 'Lamesa', 3970),
(46410, 'Lampasas', 3970),
(46411, 'Lancaster', 3970),
(46412, 'Laredo', 3970),
(46413, 'League City', 3970),
(46414, 'Leon Valley', 3970),
(46415, 'Levelland', 3970),
(46416, 'Lewisville', 3970),
(46417, 'Liberty Hill', 3970),
(46418, 'Lindsay', 3970),
(46419, 'Little Elm', 3970),
(46420, 'Live Oak', 3970),
(46421, 'Llano', 3970),
(46422, 'Lockhart', 3970),
(46423, 'Longview', 3970),
(46424, 'Lubbock', 3970),
(46425, 'Lufkin', 3970),
(46426, 'Lumberton', 3970),
(46427, 'MacAllen', 3970),
(46428, 'MacKinney', 3970),
(46429, 'Magnolia', 3970),
(46430, 'Malakoff', 3970),
(46431, 'Mansfield', 3970),
(46432, 'Marshall', 3970),
(46433, 'McAllen', 3970),
(46434, 'McKinney', 3970),
(46435, 'Medina', 3970),
(46436, 'Mercedes', 3970),
(46437, 'Mesquite', 3970),
(46438, 'Midland', 3970),
(46439, 'Mineral Wells', 3970),
(46440, 'Mission', 3970),
(46441, 'Mission Bend', 3970),
(46442, 'Missouri City', 3970),
(46443, 'Montgomery', 3970),
(46444, 'Mount Pleasant', 3970),
(46445, 'Murphy', 3970),
(46446, 'Nacogdoches', 3970),
(46447, 'Nederland', 3970),
(46448, 'New Braunfels', 3970),
(46449, 'New Caney', 3970),
(46450, 'North Richland Hills', 3970),
(46451, 'North Zulch', 3970),
(46452, 'Odessa', 3970),
(46453, 'Orange', 3970),
(46454, 'Ovalo', 3970),
(46455, 'Palestine', 3970),
(46456, 'Pampa', 3970),
(46457, 'Paris', 3970),
(46458, 'Pasadena', 3970),
(46459, 'Pearland', 3970),
(46460, 'Pecan Grove', 3970),
(46461, 'Pecos', 3970),
(46462, 'Pflugerville', 3970),
(46463, 'Pharr', 3970),
(46464, 'Pinehurst', 3970),
(46465, 'Plainview', 3970),
(46466, 'Plano', 3970),
(46467, 'Pontotoc', 3970),
(46468, 'Port Arthur', 3970),
(46469, 'Port Lavaca', 3970),
(46470, 'Port Neches', 3970),
(46471, 'Portland', 3970),
(46472, 'Pottsboro', 3970),
(46473, 'Princeton', 3970),
(46474, 'Richardson', 3970),
(46475, 'Richmond', 3970),
(46476, 'Rio Grande City', 3970),
(46477, 'Robstown', 3970),
(46478, 'Rockport', 3970),
(46479, 'Rockwall', 3970),
(46480, 'Roma', 3970),
(46481, 'Rosenberg', 3970),
(46482, 'Round Rock', 3970),
(46483, 'Rowlett', 3970),
(46484, 'Royse City', 3970),
(46485, 'Sachse', 3970),
(46486, 'Saginaw', 3970),
(46487, 'San Angelo', 3970),
(46488, 'San Antonio', 3970),
(46489, 'San Benito', 3970),
(46490, 'San Juan', 3970),
(46491, 'San Marcos', 3970),
(46492, 'Santa Fe', 3970),
(46493, 'Schertz', 3970),
(46494, 'Seabrook', 3970),
(46495, 'Seagoville', 3970),
(46496, 'Seguin', 3970),
(46497, 'Sherman', 3970),
(46498, 'Slaton', 3970),
(46499, 'Smithville', 3970),
(46500, 'Snyder', 3970),
(46501, 'Socorro', 3970),
(46502, 'South Houston', 3970),
(46503, 'South Padre Island', 3970),
(46504, 'Southlake', 3970),
(46505, 'Spring', 3970),
(46506, 'Stafford', 3970),
(46507, 'Stephenville', 3970),
(46508, 'Strawn', 3970),
(46509, 'Sugar Land', 3970),
(46510, 'Sulphur Springs', 3970),
(46511, 'Sweetwater', 3970),
(46512, 'Taylor', 3970),
(46513, 'Temple', 3970),
(46514, 'Terrell', 3970),
(46515, 'Texarkana', 3970),
(46516, 'Texas City', 3970),
(46517, 'The Colony', 3970),
(46518, 'The Woodlands', 3970),
(46519, 'Tomball', 3970),
(46520, 'Tyler', 3970),
(46521, 'Universal City', 3970),
(46522, 'University Park', 3970),
(46523, 'Uvalde', 3970),
(46524, 'Vernon', 3970),
(46525, 'Victoria', 3970),
(46526, 'Vidor', 3970),
(46527, 'Waco', 3970),
(46528, 'Watauga', 3970),
(46529, 'Waxahachie', 3970),
(46530, 'Weatherford', 3970),
(46531, 'Weslaco', 3970),
(46532, 'West Odessa', 3970),
(46533, 'West University Place', 3970),
(46534, 'White Settlement', 3970),
(46535, 'Wichita Falls', 3970),
(46536, 'Winnsboro', 3970),
(46537, 'Woodway', 3970),
(46538, 'Wylie', 3970),
(46539, 'Yoakum', 3970),
(46540, 'austinn', 3970),
(46541, 'Bedford Kentucky', 3971),
(46542, 'Alpine', 3972),
(46543, 'American Fork', 3972),
(46544, 'Bluffdale', 3972),
(46545, 'Bountiful', 3972),
(46546, 'Brigham City', 3972),
(46547, 'Canyon Rim', 3972),
(46548, 'Castle Dale', 3972),
(46549, 'Cedar City', 3972),
(46550, 'Centerville', 3972),
(46551, 'Clearfield', 3972),
(46552, 'Clinton', 3972),
(46553, 'Cottonwood Heights', 3972),
(46554, 'Cottonwood West', 3972),
(46555, 'Draper', 3972),
(46556, 'East Millcreek', 3972),
(46557, 'Farmington', 3972),
(46558, 'Holladay-Cottonwood', 3972),
(46559, 'Ivins', 3972),
(46560, 'Kaysville', 3972),
(46561, 'Kearns', 3972),
(46562, 'Layton', 3972),
(46563, 'Lehi', 3972),
(46564, 'Logan', 3972),
(46565, 'Magna', 3972),
(46566, 'Mapleton', 3972),
(46567, 'Midvale', 3972),
(46568, 'Millcreek', 3972),
(46569, 'Moab', 3972),
(46570, 'Monticello', 3972),
(46571, 'Murray', 3972),
(46572, 'North Logan', 3972),
(46573, 'North Ogden', 3972),
(46574, 'Ogden', 3972),
(46575, 'Orem', 3972),
(46576, 'Panguitch', 3972),
(46577, 'Park City', 3972),
(46578, 'Payson', 3972),
(46579, 'Pleasant Grove', 3972),
(46580, 'Provo', 3972),
(46581, 'Riverton', 3972),
(46582, 'Roy', 3972),
(46583, 'Saint George', 3972),
(46584, 'Salt Lake City', 3972),
(46585, 'Sandy', 3972),
(46586, 'Santaquin', 3972),
(46587, 'South Jordan', 3972),
(46588, 'South Ogden', 3972),
(46589, 'South Salt Lake', 3972),
(46590, 'Spanish Fork', 3972),
(46591, 'Springville', 3972),
(46592, 'Taylorsville', 3972),
(46593, 'Tooele', 3972),
(46594, 'Tremonton', 3972),
(46595, 'Union', 3972),
(46596, 'Washington', 3972),
(46597, 'West Jordan', 3972),
(46598, 'West Valley City', 3972),
(46599, 'Woods Cross', 3972),
(46600, 'Barre', 3973),
(46601, 'Bennington', 3973),
(46602, 'Brattleboro', 3973),
(46603, 'Bristol', 3973),
(46604, 'Burlington', 3973),
(46605, 'Cabot', 3973),
(46606, 'Colchester', 3973),
(46607, 'Danville', 3973),
(46608, 'Dorset', 3973),
(46609, 'Dummerston', 3973),
(46610, 'East Corinth', 3973),
(46611, 'East Fairfield', 3973),
(46612, 'East Randolph', 3973),
(46613, 'Essex', 3973),
(46614, 'Essex Junction', 3973),
(46615, 'Grand Isle', 3973),
(46616, 'Hartford', 3973),
(46617, 'Jericho', 3973),
(46618, 'Manchester', 3973),
(46619, 'Manchester Center', 3973),
(46620, 'Middlebury', 3973),
(46621, 'Milton', 3973),
(46622, 'Montpelier', 3973),
(46623, 'Putney', 3973),
(46624, 'Randolph', 3973),
(46625, 'Rochester', 3973),
(46626, 'Rutland', 3973),
(46627, 'Saint Albans', 3973),
(46628, 'Saint Johnsbury', 3973),
(46629, 'Saxtons River', 3973),
(46630, 'South Burlington', 3973),
(46631, 'South Strafford', 3973),
(46632, 'Springfield', 3973),
(46633, 'Townshend', 3973),
(46634, 'Tunbridge', 3973),
(46635, 'Van', 3973),
(46636, 'Vernon', 3973),
(46637, 'Wallingford', 3973),
(46638, 'Watisfield', 3973),
(46639, 'West Brookfield', 3973),
(46640, 'West Charleston', 3973),
(46641, 'West Newbury', 3973),
(46642, 'Williston', 3973),
(46643, 'Winooski', 3973),
(46644, 'Abingdon', 3974),
(46645, 'Alexandria', 3974),
(46646, 'Annandale', 3974),
(46647, 'Arlington', 3974),
(46648, 'Ashburn', 3974),
(46649, 'Ashland', 3974),
(46650, 'Aylett', 3974),
(46651, 'Bailey\'s Crossroads', 3974),
(46652, 'Blacksburg', 3974),
(46653, 'Bland', 3974),
(46654, 'Bluefield', 3974),
(46655, 'Bon Air', 3974),
(46656, 'Bristol', 3974),
(46657, 'Burke', 3974),
(46658, 'Cave Spring', 3974),
(46659, 'Centreville', 3974),
(46660, 'Chantilly', 3974),
(46661, 'Charlottesville', 3974),
(46662, 'Chesapeake', 3974),
(46663, 'Chester', 3974),
(46664, 'Christiansburg', 3974),
(46665, 'Churchville', 3974),
(46666, 'Clifton', 3974),
(46667, 'Colonial Heights', 3974),
(46668, 'Culloden', 3974),
(46669, 'Dale City', 3974),
(46670, 'Danville', 3974),
(46671, 'Dublin', 3974),
(46672, 'Eagle Rock', 3974),
(46673, 'East Highland Park', 3974),
(46674, 'Faber', 3974),
(46675, 'Fairfax', 3974),
(46676, 'Falls Church', 3974),
(46677, 'Fishersville', 3974),
(46678, 'Fort Hunt', 3974),
(46679, 'Fort Valley', 3974),
(46680, 'Franconia', 3974),
(46681, 'Franklin', 3974),
(46682, 'Fredericksburg', 3974),
(46683, 'Front Royal', 3974),
(46684, 'Gainesville', 3974),
(46685, 'Glen Allen', 3974),
(46686, 'Gloucester', 3974),
(46687, 'Goochland', 3974),
(46688, 'Great Falls', 3974),
(46689, 'Groveton', 3974),
(46690, 'Hampton', 3974),
(46691, 'Harrisonburg', 3974),
(46692, 'Henrico', 3974),
(46693, 'Herndon', 3974),
(46694, 'Highland Springs', 3974),
(46695, 'Hollins', 3974),
(46696, 'Hopewell', 3974),
(46697, 'Hybla Valley', 3974),
(46698, 'Idylwood', 3974),
(46699, 'Irvington', 3974),
(46700, 'Jamesville', 3974),
(46701, 'Jefferson', 3974),
(46702, 'Keen Mountain', 3974),
(46703, 'Keswick', 3974),
(46704, 'Lake Ridge', 3974),
(46705, 'Lakeside', 3974),
(46706, 'Laurel', 3974),
(46707, 'Leesburg', 3974),
(46708, 'Lincolnia', 3974),
(46709, 'Lorton', 3974),
(46710, 'Lynchburg', 3974),
(46711, 'MacLean', 3974),
(46712, 'Madison', 3974),
(46713, 'Madison Heights', 3974),
(46714, 'Manassas', 3974),
(46715, 'Marion', 3974),
(46716, 'Martinsville', 3974),
(46717, 'Mclean', 3974),
(46718, 'Mechanicsville', 3974),
(46719, 'Melfa', 3974),
(46720, 'Midlothian', 3974),
(46721, 'Montclair', 3974),
(46722, 'Montross', 3974),
(46723, 'Mount Vernon', 3974),
(46724, 'Newington', 3974),
(46725, 'Newport News', 3974),
(46726, 'Norfolk', 3974),
(46727, 'North Springfield', 3974),
(46728, 'Oakton', 3974),
(46729, 'Orange', 3974),
(46730, 'Petersburg', 3974),
(46731, 'Poquoson', 3974),
(46732, 'Portsmouth', 3974),
(46733, 'Radford', 3974),
(46734, 'Reston', 3974),
(46735, 'Richmond', 3974),
(46736, 'Roanoke', 3974),
(46737, 'Rose Hill', 3974),
(46738, 'Salem', 3974),
(46739, 'Seaford', 3974),
(46740, 'South Boston', 3974),
(46741, 'Springfield', 3974),
(46742, 'Stafford', 3974),
(46743, 'Staffordshire', 3974),
(46744, 'Staunton', 3974),
(46745, 'Sterling', 3974),
(46746, 'Suffolk', 3974),
(46747, 'Sugarland Run', 3974),
(46748, 'Tappahannock', 3974),
(46749, 'Timberlake', 3974),
(46750, 'Triangle', 3974),
(46751, 'Tuckahoe', 3974),
(46752, 'Tysons Corner', 3974),
(46753, 'Vienna', 3974),
(46754, 'Virginia Beach', 3974),
(46755, 'Warrenton', 3974),
(46756, 'Washington', 3974),
(46757, 'Waterford', 3974),
(46758, 'Waynesboro', 3974),
(46759, 'West Springfield', 3974),
(46760, 'Williamsburg', 3974),
(46761, 'Winchester', 3974),
(46762, 'Wolf Trap', 3974),
(46763, 'Woodbridge', 3974),
(46764, 'Wytheville', 3974),
(46765, 'Yorktown', 3974),
(46766, 'Aberdeen', 3975),
(46767, 'Airway Heights', 3975),
(46768, 'Alderwood Manor', 3975),
(46769, 'Anacortes', 3975),
(46770, 'Arlington', 3975),
(46771, 'Auburn', 3975),
(46772, 'Bainbridge Island', 3975),
(46773, 'Battle Ground', 3975),
(46774, 'Bellevue', 3975),
(46775, 'Bellingham', 3975),
(46776, 'Bingen', 3975),
(46777, 'Blaine', 3975),
(46778, 'Bothell', 3975),
(46779, 'Bremerton', 3975),
(46780, 'Bryn Mawr-Skyway', 3975),
(46781, 'Buckley', 3975),
(46782, 'Burien', 3975),
(46783, 'Burlington', 3975),
(46784, 'Camano Island', 3975),
(46785, 'Camas', 3975),
(46786, 'Cascade-Fairwood', 3975),
(46787, 'Centralia', 3975),
(46788, 'Chehalis', 3975),
(46789, 'Cheney', 3975),
(46790, 'Clear Lake', 3975),
(46791, 'Colbert', 3975),
(46792, 'Cottage Lake', 3975),
(46793, 'Covington-Sawyer-Wilderness', 3975),
(46794, 'Des Moines', 3975),
(46795, 'Duvall', 3975),
(46796, 'East Hill-Meridian', 3975),
(46797, 'East Renton Highlands', 3975),
(46798, 'East Wenatchee Bench', 3975),
(46799, 'Eastsound', 3975),
(46800, 'Eatonville', 3975),
(46801, 'Edgewood-North Hill', 3975),
(46802, 'Edmonds', 3975),
(46803, 'Elk Plain', 3975),
(46804, 'Ellensburg', 3975),
(46805, 'Enumclaw', 3975),
(46806, 'Esperance', 3975),
(46807, 'Everett', 3975),
(46808, 'Evergreen', 3975),
(46809, 'Fairchild', 3975),
(46810, 'Federal Way', 3975),
(46811, 'Ferndale', 3975),
(46812, 'Fircrest', 3975),
(46813, 'Ford', 3975),
(46814, 'Fort Lewis', 3975),
(46815, 'Friday Harbor', 3975),
(46816, 'Gig Harbor', 3975),
(46817, 'Graham', 3975),
(46818, 'Harbour Pointe', 3975),
(46819, 'Inglewood-Finn Hill', 3975),
(46820, 'Issaquah', 3975),
(46821, 'Kelso', 3975),
(46822, 'Kenmore', 3975),
(46823, 'Kennewick', 3975),
(46824, 'Kent', 3975),
(46825, 'Kingsgate', 3975),
(46826, 'Kirkland', 3975),
(46827, 'Lacey', 3975),
(46828, 'Lake Serene-North Lynnwood', 3975),
(46829, 'Lakeland North', 3975),
(46830, 'Lakeland South', 3975),
(46831, 'Lakewood', 3975),
(46832, 'Longview', 3975),
(46833, 'Lynnwood', 3975),
(46834, 'Martha Lake', 3975),
(46835, 'Marysville', 3975),
(46836, 'Mercer Island', 3975),
(46837, 'Minnehaha', 3975),
(46838, 'Monroe', 3975),
(46839, 'Moses Lake', 3975),
(46840, 'Mossyrock', 3975),
(46841, 'Mount Vernon', 3975),
(46842, 'Mountlake Terrace', 3975),
(46843, 'Mukilteo', 3975),
(46844, 'Newport Hills', 3975),
(46845, 'North City-Ridgecrest', 3975),
(46846, 'North Creek', 3975),
(46847, 'North Marysville', 3975),
(46848, 'Oak Harbor', 3975),
(46849, 'Ocean Shores', 3975),
(46850, 'Olympia', 3975),
(46851, 'Opportunity', 3975),
(46852, 'Orchards South', 3975),
(46853, 'Orting', 3975),
(46854, 'Paine Field-Lake Stickney', 3975),
(46855, 'Parkland', 3975),
(46856, 'Pasco', 3975),
(46857, 'Picnic Point-North Lynnwood', 3975),
(46858, 'Pine Lake', 3975),
(46859, 'Port Angeles', 3975),
(46860, 'Port Hadlock', 3975),
(46861, 'Port Ludlow', 3975),
(46862, 'Port Orchard', 3975),
(46863, 'Poulsbo', 3975),
(46864, 'Pullman', 3975),
(46865, 'Puyallup', 3975),
(46866, 'Redmond', 3975),
(46867, 'Renton', 3975),
(46868, 'Republic', 3975),
(46869, 'Richland', 3975),
(46870, 'Riverton-Boulevard Park', 3975),
(46871, 'Sahalee', 3975),
(46872, 'Salmon Creek', 3975),
(46873, 'Sammamish', 3975),
(46874, 'SeaTac', 3975),
(46875, 'Seattle', 3975),
(46876, 'Seattle Hill-Silver Firs', 3975),
(46877, 'Sedro Woolley', 3975),
(46878, 'Shelton', 3975),
(46879, 'Shoreline', 3975),
(46880, 'Silverdale', 3975),
(46881, 'Snohomish', 3975),
(46882, 'South Hill', 3975),
(46883, 'South Prairie', 3975),
(46884, 'South Seattle', 3975),
(46885, 'Spanaway', 3975),
(46886, 'Spokane', 3975),
(46887, 'Sumas', 3975),
(46888, 'Sumner', 3975),
(46889, 'Sunnyside', 3975),
(46890, 'Tacoma', 3975),
(46891, 'Tukwila', 3975),
(46892, 'Tumwater', 3975),
(46893, 'University Place', 3975),
(46894, 'Vancouver', 3975),
(46895, 'Vashon', 3975),
(46896, 'Walla Walla', 3975),
(46897, 'Washougal', 3975),
(46898, 'Wenatchee', 3975),
(46899, 'West Lake Stevens', 3975),
(46900, 'White Center', 3975),
(46901, 'White Salmon', 3975),
(46902, 'White Swan', 3975),
(46903, 'Woodinville', 3975),
(46904, 'Yakima', 3975),
(46905, 'Yelm', 3975),
(46906, 'Adams', 3977),
(46907, 'Allouez', 3977),
(46908, 'Appleton', 3977),
(46909, 'Ashland', 3977),
(46910, 'Ashwaubenon', 3977),
(46911, 'Baraboo', 3977),
(46912, 'Beaver Dam', 3977),
(46913, 'Beloit', 3977),
(46914, 'Brookfield', 3977),
(46915, 'Brown Deer', 3977),
(46916, 'Burlington', 3977),
(46917, 'Caledonia', 3977),
(46918, 'Carter', 3977),
(46919, 'Cedarburg', 3977),
(46920, 'Chippewa Falls', 3977),
(46921, 'Cudahy', 3977),
(46922, 'De Pere', 3977),
(46923, 'Deer Park', 3977),
(46924, 'Delafield', 3977),
(46925, 'Eau Claire', 3977),
(46926, 'Elkhorn', 3977),
(46927, 'Elroy', 3977),
(46928, 'Fitchburg', 3977),
(46929, 'Fond du Lac', 3977),
(46930, 'Fort Atkinson', 3977),
(46931, 'Franklin', 3977),
(46932, 'Galesville', 3977),
(46933, 'Germantown', 3977),
(46934, 'Glen Flora', 3977),
(46935, 'Glendale', 3977),
(46936, 'Goodman', 3977),
(46937, 'Grafton', 3977),
(46938, 'Green Bay', 3977),
(46939, 'Greendale', 3977),
(46940, 'Greenfield', 3977),
(46941, 'Hartford', 3977),
(46942, 'Hartland', 3977),
(46943, 'Howard', 3977),
(46944, 'Hudson', 3977),
(46945, 'Janesville', 3977),
(46946, 'Jefferson', 3977),
(46947, 'Junction City', 3977),
(46948, 'Kaukauna', 3977),
(46949, 'Kenosha', 3977),
(46950, 'Kiel', 3977),
(46951, 'Kohler', 3977),
(46952, 'La Crosse', 3977),
(46953, 'Little Chute', 3977),
(46954, 'Madison', 3977),
(46955, 'Manitowoc', 3977),
(46956, 'Marinette', 3977),
(46957, 'Marshfield', 3977),
(46958, 'Medford', 3977),
(46959, 'Menasha', 3977),
(46960, 'Menomonee Falls', 3977),
(46961, 'Menomonie', 3977),
(46962, 'Mequon', 3977),
(46963, 'Merrill', 3977),
(46964, 'Middleton', 3977),
(46965, 'Milwaukee', 3977),
(46966, 'Mineral Point', 3977),
(46967, 'Monroe', 3977),
(46968, 'Mount Pleasant', 3977),
(46969, 'Mukwonago', 3977),
(46970, 'Muskego', 3977),
(46971, 'Neenah', 3977),
(46972, 'New Berlin', 3977),
(46973, 'New Richmond', 3977),
(46974, 'Oak Creek', 3977),
(46975, 'Oconomowoc', 3977),
(46976, 'Onalaska', 3977),
(46977, 'Orfordville', 3977),
(46978, 'Oshkosh', 3977),
(46979, 'Pigeon Falls', 3977),
(46980, 'Platteville', 3977),
(46981, 'Pleasant Prairie', 3977),
(46982, 'Plover', 3977),
(46983, 'Port Washington', 3977),
(46984, 'Portage', 3977),
(46985, 'Pound', 3977),
(46986, 'Racine', 3977),
(46987, 'Reedsburg', 3977),
(46988, 'Rhinelander', 3977),
(46989, 'River Falls', 3977),
(46990, 'Saint Francis', 3977),
(46991, 'Sheboygan', 3977),
(46992, 'Shorewood', 3977),
(46993, 'South Milwaukee', 3977),
(46994, 'Spring Valley', 3977),
(46995, 'Stevens Point', 3977),
(46996, 'Stoughton', 3977),
(46997, 'Strum', 3977),
(46998, 'Sturtevant', 3977),
(46999, 'Sun Prairie', 3977),
(47000, 'Superior', 3977),
(47001, 'Three Lakes', 3977),
(47002, 'Tomah', 3977),
(47003, 'Two Rivers', 3977),
(47004, 'Washington Island', 3977),
(47005, 'Waterford', 3977),
(47006, 'Watertown', 3977),
(47007, 'Waukesha', 3977),
(47008, 'Waupun', 3977),
(47009, 'Wausau', 3977),
(47010, 'Wautoma', 3977),
(47011, 'Wauwatosa', 3977),
(47012, 'West Allis', 3977),
(47013, 'West Bend', 3977),
(47014, 'Weston', 3977),
(47015, 'Whitefish Bay', 3977),
(47016, 'Whitewater', 3977),
(47017, 'Wisconsin Rapids', 3977),
(47018, 'Buffalo', 3978),
(47019, 'Casper', 3978),
(47020, 'Cheyenne', 3978),
(47021, 'Cody', 3978),
(47022, 'Douglas', 3978),
(47023, 'Evanston', 3978),
(47024, 'Gillette', 3978),
(47025, 'Green River', 3978),
(47026, 'Jackson', 3978),
(47027, 'Lander', 3978),
(47028, 'Laramie', 3978),
(47029, 'Powell', 3978),
(47030, 'Rawlins', 3978),
(47031, 'Riverton', 3978),
(47032, 'Rock Springs', 3978),
(47033, 'Sheridan', 3978),
(47034, 'Torrington', 3978),
(47035, 'Worland', 3978),
(47036, 'Artigas', 3980),
(47037, 'Bella Union', 3980),
(47038, 'Camino Maldonado', 3981),
(47039, 'Canelones', 3981),
(47040, 'Ciudad de la Costa', 3981),
(47041, 'Juan Antonio Artigas', 3981),
(47042, 'Las Piedras', 3981),
(47043, 'Pando', 3981),
(47044, 'Paso de Carrasco', 3981),
(47045, 'Progreso', 3981),
(47046, 'Santa Lucia', 3981),
(47047, 'Carmelo', 3983),
(47048, 'Colonia', 3983),
(47049, 'Juan Lacaze', 3983),
(47050, 'Nueva Helvecia', 3983),
(47051, 'Durazno', 3984),
(47052, 'Florida', 3985),
(47053, 'Trinidad', 3986),
(47054, 'Minas', 3987),
(47055, 'Maldonado', 3988),
(47056, 'San Carlos', 3988),
(47057, 'La Paz', 3989),
(47058, 'Montevideo', 3989),
(47059, 'Paysandu', 3990),
(47060, 'Rivera', 3992),
(47061, 'Chuy', 3993),
(47062, 'Rocha', 3993),
(47063, 'Salto', 3994),
(47064, 'Dolores', 3996),
(47065, 'Mercedes', 3996),
(47066, 'Paso de los Toros', 3997),
(47067, 'Tacuarembo', 3997),
(47068, 'Ahunabayev', 3999),
(47069, 'Andijon', 3999),
(47070, 'Asaka', 3999),
(47071, 'Boz', 3999),
(47072, 'Hakkulobod', 3999),
(47073, 'Hocaobod', 3999),
(47074, 'Honobod', 3999),
(47075, 'Ilyichevsk', 3999),
(47076, 'Karabagis', 3999),
(47077, 'Kurgontepa', 3999),
(47078, 'Marhomat', 3999),
(47079, 'Pahtaobod', 3999),
(47080, 'Paytug', 3999),
(47081, 'Sahrihan', 3999),
(47082, 'Buhoro', 4000),
(47083, 'Cangeldi', 4000),
(47084, 'Galaosiye', 4000),
(47085, 'Gazli', 4000),
(47086, 'Gijduvon', 4000),
(47087, 'Kizilravbe', 4000),
(47088, 'Kogon', 4000),
(47089, 'Korakul', 4000),
(47090, 'Korovulbazar', 4000),
(47091, 'Kukca', 4000),
(47092, 'Olot', 4000),
(47093, 'Oyokkuduk', 4000),
(47094, 'Romitan', 4000),
(47095, 'Safirkon', 4000),
(47096, 'Vobkent', 4000),
(47097, 'Cizah', 4002),
(47098, 'Dustlik', 4002),
(47099, 'Gagarin', 4002),
(47100, 'Gallaorol', 4002),
(47101, 'Marcanbulok', 4002),
(47102, 'Pahtakor', 4002),
(47103, 'Ulyanovo', 4002),
(47104, 'Zomin', 4002),
(47105, 'Altyarik', 4003),
(47106, 'Avval', 4003),
(47107, 'Besarik', 4003),
(47108, 'Fargona', 4003),
(47109, 'Hamza', 4003),
(47110, 'Kirgili', 4003),
(47111, 'Kukon', 4003),
(47112, 'Kuva', 4003),
(47113, 'Kuvasoy', 4003),
(47114, 'Margilon', 4003),
(47115, 'Rapkan', 4003),
(47116, 'Riston', 4003),
(47117, 'Toslok', 4003),
(47118, 'Yaypan', 4003),
(47119, 'Drujba', 4004),
(47120, 'Gurlan', 4004),
(47121, 'Hazorasp', 4004),
(47122, 'Heva', 4004),
(47123, 'Honko', 4004),
(47124, 'Kuskupir', 4004),
(47125, 'Mesekli', 4004),
(47126, 'Sovot', 4004),
(47127, 'Turpokkala', 4004),
(47128, 'Urgenc', 4004),
(47129, 'Beskent', 4005),
(47130, 'Ceynau', 4005),
(47131, 'Cirakci', 4005),
(47132, 'Dehkanobod', 4005),
(47133, 'Dinau', 4005),
(47134, 'Guzor', 4005),
(47135, 'Kallig', 4005),
(47136, 'Kamasi', 4005),
(47137, 'Karabag', 4005),
(47138, 'Karsi', 4005),
(47139, 'Kasbi', 4005),
(47140, 'Kitob', 4005),
(47141, 'Koson', 4005),
(47142, 'Madaniyat', 4005),
(47143, 'Maydayap', 4005),
(47144, 'Maymanak', 4005),
(47145, 'Muborak', 4005),
(47146, 'Oktyabrskiy', 4005),
(47147, 'Sahrisabz', 4005),
(47148, 'Talimarcon', 4005),
(47149, 'Urtacim', 4005),
(47150, 'Yakkabog', 4005),
(47151, 'Yaninison', 4005),
(47152, 'Beruni', 4006),
(47153, 'Buston', 4006),
(47154, 'Cimboy', 4006),
(47155, 'Halkobod', 4006),
(47156, 'Hucayli', 4006),
(47157, 'Karauzyak', 4006),
(47158, 'Kegayli', 4006),
(47159, 'Kizketken', 4006),
(47160, 'Kozokdaryo', 4006),
(47161, 'Kungirot', 4006),
(47162, 'Mangit', 4006),
(47163, 'Muynok', 4006),
(47164, 'Nukus', 4006),
(47165, 'Tahiatos', 4006),
(47166, 'Tahtakupir', 4006),
(47167, 'Turtkul', 4006),
(47168, 'Aytim', 4007),
(47169, 'Besbulok', 4007),
(47170, 'Cartak', 4007),
(47171, 'Cingeldi', 4007),
(47172, 'Cust', 4007),
(47173, 'Gozgon', 4007),
(47174, 'Iskavat', 4007),
(47175, 'Kalkuduk', 4007),
(47176, 'Konimeh', 4007),
(47177, 'Kosonsoy', 4007),
(47178, 'Minbulok', 4007),
(47179, 'Namangan', 4007),
(47180, 'Nurota', 4007),
(47181, 'Pop', 4007),
(47182, 'Tomdibulok', 4007),
(47183, 'Tosbulok', 4007),
(47184, 'Turakurgon', 4007),
(47185, 'Uckurgon', 4007),
(47186, 'Unhoyat', 4007),
(47187, 'Uyci', 4007),
(47188, 'Uzunkuduk', 4007),
(47189, 'Yanikurgon', 4007),
(47190, 'Karmana', 4008),
(47191, 'Kiziltepa', 4008),
(47192, 'Navoi', 4008),
(47193, 'Uckuduk', 4008),
(47194, 'Zarafson', 4008),
(47195, 'Bulungur', 4009),
(47196, 'Camboy', 4009),
(47197, 'Carhin', 4009),
(47198, 'Celak', 4009),
(47199, 'Cuma', 4009),
(47200, 'Dahbed', 4009),
(47201, 'Istihon', 4009),
(47202, 'Kattakurgon', 4009),
(47203, 'Kusrobod', 4009),
(47204, 'Nurobod', 4009),
(47205, 'Oktos', 4009),
(47206, 'Paysanba', 4009),
(47207, 'Samarkand', 4009),
(47208, 'Superfosfatniy', 4009),
(47209, 'Urgut', 4009),
(47210, 'Yanirobod', 4009),
(47211, 'Ziadin', 4009),
(47212, 'Baht', 4010),
(47213, 'Guliston', 4010),
(47214, 'Hovos', 4010),
(47215, 'Sirdare', 4010),
(47216, 'Sirin', 4010),
(47217, 'Yaniyer', 4010),
(47218, 'Akkurgon', 4011),
(47219, 'Boysun', 4011),
(47220, 'Carkurgon', 4011),
(47221, 'Denau', 4011),
(47222, 'Kumkurgon', 4011),
(47223, 'Paskurd', 4011),
(47224, 'Sargun', 4011),
(47225, 'Sariasiya', 4011),
(47226, 'Serobod', 4011),
(47227, 'Surci', 4011),
(47228, 'Termiz', 4011),
(47229, 'Zan', 4011),
(47230, 'Almazar', 4012),
(47231, 'Angren', 4012),
(47232, 'Bekobod', 4012),
(47233, 'Bektemir', 4012),
(47234, 'Buka', 4012),
(47235, 'Cinoz', 4012),
(47236, 'Circik', 4012),
(47237, 'Gazalkent', 4012),
(47238, 'Iskandar', 4012),
(47239, 'Keles', 4012),
(47240, 'Kibray', 4012),
(47241, 'Krasnogorskiy', 4012),
(47242, 'Kuyluk', 4012),
(47243, 'Ohangaron', 4012),
(47244, 'Olmalik', 4012),
(47245, 'Parkent', 4012),
(47246, 'Pskent', 4012),
(47247, 'Salar', 4012),
(47248, 'Soldatski', 4012),
(47249, 'Tashkent', 4012),
(47250, 'Toskent', 4012),
(47251, 'Tuytepa', 4012),
(47252, 'Urtaaul', 4012),
(47253, 'Yaniobod', 4012),
(47254, 'Yaniyul', 4012),
(47255, 'Lakatoro', 4013),
(47256, 'Norsup', 4013),
(47257, 'Longana', 4014),
(47258, 'Luganville', 4015),
(47259, 'Port Olry', 4015),
(47260, 'Vila', 4016),
(47261, 'Isangel', 4017),
(47262, 'Sola', 4018),
(47263, 'Puerto Ayacucho', 4020),
(47264, 'Anaco', 4021),
(47265, 'Barcelona', 4021),
(47266, 'Cantaura', 4021),
(47267, 'El Tigre', 4021),
(47268, 'Puerto la Cruz', 4021),
(47269, 'San Jose de Guanipa', 4021),
(47270, 'Guasdualito', 4022),
(47271, 'San Fernando', 4022),
(47272, 'Cagua', 4023),
(47273, 'El Limon', 4023),
(47274, 'La Victoria', 4023),
(47275, 'Las Teyerias', 4023),
(47276, 'Maracay', 4023),
(47277, 'Palo Negro', 4023),
(47278, 'San Mateo', 4023),
(47279, 'Turmero', 4023),
(47280, 'Villa de Cura', 4023),
(47281, 'Barinas', 4024),
(47282, 'Barinitas', 4024),
(47283, 'Ciudad Bolivar', 4025),
(47284, 'Ciudad Guayana', 4025),
(47285, 'Upata', 4025),
(47286, 'Goaigoaza', 4026),
(47287, 'Guacara', 4026),
(47288, 'Guigue', 4026),
(47289, 'Mariara', 4026),
(47290, 'Moron', 4026),
(47291, 'Puerto Cabello', 4026),
(47292, 'San Joaquin', 4026),
(47293, 'Tacarigua', 4026),
(47294, 'Valencia', 4026),
(47295, 'San Carlos', 4027),
(47296, 'Tinaquillo', 4027),
(47297, 'Coro', 4030),
(47298, 'Punta Cardon', 4030),
(47299, 'Punto Fijo', 4030),
(47300, 'Altagracia de Orituco', 4031),
(47301, 'Calabozo', 4031),
(47302, 'San Juan de los Morros', 4031),
(47303, 'Valle de la Pascua', 4031),
(47304, 'Zaraza', 4031),
(47305, 'Barquisimeto', 4032),
(47306, 'Cabudare', 4032),
(47307, 'Carora', 4032),
(47308, 'El Tocuyo', 4032),
(47309, 'Los Rastrojos', 4032),
(47310, 'Quibor', 4032),
(47311, 'Ejido', 4033),
(47312, 'El Vigia', 4033),
(47313, 'Merida', 4033),
(47314, 'Baruta', 4034),
(47315, 'Carrizal', 4034),
(47316, 'Catia La Mar', 4034),
(47317, 'Caucaguita', 4034),
(47318, 'Chacao', 4034),
(47319, 'Charallave', 4034),
(47320, 'Cua', 4034),
(47321, 'El Cafetal', 4034),
(47322, 'El Hatillo', 4034),
(47323, 'Filas de Mariche', 4034),
(47324, 'Guarenas', 4034),
(47325, 'Guatire', 4034),
(47326, 'La Dolorita', 4034),
(47327, 'Los Dos Caminos', 4034),
(47328, 'Los Teques', 4034),
(47329, 'Ocumare del Tuy', 4034),
(47330, 'Petare', 4034),
(47331, 'San Antonio de los Altos', 4034),
(47332, 'Santa Teresa', 4034),
(47333, 'Maturin', 4035),
(47334, 'Acarigua', 4037),
(47335, 'Araure', 4037),
(47336, 'Guanare', 4037),
(47337, 'Villa Bruzual', 4037),
(47338, 'Carupano', 4038),
(47339, 'Cumana', 4038),
(47340, 'La Fria', 4039),
(47341, 'Rubio', 4039),
(47342, 'San Antonio del Tachira', 4039),
(47343, 'San Cristobal', 4039),
(47344, 'San Juan de Colon', 4039),
(47345, 'Tariba', 4039),
(47346, 'Trujillo', 4040),
(47347, 'Valera', 4040),
(47348, 'Caraballeda', 4041),
(47349, 'La Guaira', 4041),
(47350, 'Maiquetia', 4041),
(47351, 'Chivacoa', 4042),
(47352, 'Nirgua', 4042),
(47353, 'San Felipe', 4042),
(47354, 'Yaritagua', 4042),
(47355, 'Bachaquero', 4043),
(47356, 'Cabimas', 4043),
(47357, 'Ciudad Ojeda', 4043),
(47358, 'Lagunillas', 4043),
(47359, 'Machiques', 4043),
(47360, 'Maracaibo', 4043),
(47361, 'San Carlos del Zulia', 4043),
(47362, 'Santa Rita', 4043),
(47363, 'Villa del Rosario', 4043),
(47364, 'Ha noi', 4053),
(47365, 'Hoang Mai', 4053),
(47366, 'Lang Ha', 4053),
(47367, 'Settlement', 4064),
(47368, 'East End-Long Look', 4066),
(47369, 'Road Town', 4066),
(47370, 'West End', 4066),
(47371, 'Kolia', 4070),
(47372, 'Mala\'e', 4070),
(47373, 'Ono', 4070),
(47374, 'Poi', 4070),
(47375, 'Tamana', 4070),
(47376, 'Taoa', 4070),
(47377, 'Tuatafa', 4070),
(47378, 'Vele', 4070),
(47379, 'Fiua', 4071),
(47380, 'Leava', 4071),
(47381, 'Nuku', 4071),
(47382, 'Tavai', 4071),
(47383, 'Toloke', 4071),
(47384, 'Vaisei', 4071),
(47385, 'Ahoa', 4072),
(47386, 'Aka Aka', 4072),
(47387, 'Alele', 4072),
(47388, 'Falaleu', 4072),
(47389, 'Gahi', 4072),
(47390, 'Haafuasia', 4072),
(47391, 'Haatofo', 4072),
(47392, 'Halalo', 4072),
(47393, 'Kolopopo', 4072),
(47394, 'Lavegahau', 4072),
(47395, 'Liku', 4072),
(47396, 'Mala\'e', 4072),
(47397, 'Malaefoou', 4072),
(47398, 'Mata\'Utu', 4072),
(47399, 'Teesi', 4072),
(47400, 'Tepa', 4072),
(47401, 'Utuofa', 4072),
(47402, 'Vailala', 4072),
(47403, 'Vaimalau', 4072),
(47404, 'Vaitupu', 4072),
(47405, 'ad-Dakhlah', 4074),
(47406, 'al-\'Ayun', 4075),
(47407, 'as-Samarah', 4076),
(47408, '\'Adan', 4077),
(47409, 'Aden', 4077),
(47410, 'Ahwar', 4078),
(47411, 'Ja\'ar', 4078),
(47412, 'Zinjibar', 4078),
(47413, 'Dhamar', 4079),
(47414, 'Shaqra\'', 4080),
(47415, 'al-Mukalla', 4080),
(47416, 'ash-Shahir', 4080),
(47417, 'Hajjah', 4081),
(47418, 'Hodaidah', 4082),
(47419, 'Dhi Sufal', 4083),
(47420, 'Ibb', 4083),
(47421, 'Jiblah', 4083),
(47422, 'Qa\'tabah', 4083),
(47423, 'Yarim', 4083),
(47424, 'Tuban', 4084),
(47425, 'Ma\'rib', 4085),
(47426, 'Sa\'dah', 4087),
(47427, '\'Amran', 4088),
(47428, 'Sahar', 4088),
(47429, 'Sanaa', 4088),
(47430, 'Sayyan', 4088),
(47431, '\'Ataq', 4089),
(47432, 'Habban', 4089),
(47433, 'Taiz', 4089),
(47434, 'Ta\'izz', 4090),
(47435, 'al-Mukha', 4090),
(47436, 'Raydah', 4091),
(47437, 'al-Bayda', 4091),
(47438, 'Bajil', 4092),
(47439, 'Bayt-al-Faqih', 4092),
(47440, 'Zabid', 4092),
(47441, 'al-Hudaydah', 4092),
(47442, 'al-Marawi\'ah', 4092),
(47443, 'az-Zaydiyah', 4092),
(47444, 'al-Hazm', 4093),
(47445, 'al-Ghaydah', 4094),
(47446, 'Mahwit', 4095),
(47447, 'Nikshic', 4098),
(47448, 'Pljevlja', 4098),
(47449, 'Podgorica', 4098),
(47450, 'Ulcinj', 4098),
(47451, 'Gjakove', 4100),
(47452, 'Novi Banovci', 4100),
(47453, 'Senta', 4100),
(47454, 'Serbia', 4100),
(47455, 'Uzice', 4100),
(47456, 'Ada', 4101),
(47457, 'Alibunar', 4101),
(47458, 'Apatin', 4101),
(47459, 'Bach', 4101),
(47460, 'Bachka Palanka', 4101),
(47461, 'Bachka Petrovac', 4101),
(47462, 'Bachka Topola', 4101),
(47463, 'Bachki Jarak', 4101),
(47464, 'Banacki Karlovac', 4101),
(47465, 'Bechej', 4101),
(47466, 'Bela Crkva', 4101),
(47467, 'Beochin', 4101),
(47468, 'Choka', 4101),
(47469, 'Churug', 4101),
(47470, 'Crvenka', 4101),
(47471, 'Futog', 4101),
(47472, 'Indhija', 4101),
(47473, 'Irig', 4101),
(47474, 'Kac', 4101),
(47475, 'Kanjizha', 4101),
(47476, 'Kikinda', 4101),
(47477, 'Kovachica', 4101),
(47478, 'Kovin', 4101),
(47479, 'Kula', 4101),
(47480, 'Mol', 4101),
(47481, 'Nova Pazova', 4101),
(47482, 'Novi Bechej', 4101),
(47483, 'Novi Knezhevac', 4101),
(47484, 'Novi Sad', 4101),
(47485, 'Odzhaci', 4101),
(47486, 'Pacarak', 4101),
(47487, 'Palic', 4101),
(47488, 'Panchevo', 4101),
(47489, 'Petrovaradin', 4101),
(47490, 'Ruma', 4101),
(47491, 'Senta', 4101),
(47492, 'Shid', 4101),
(47493, 'Sivac', 4101),
(47494, 'Sombor', 4101),
(47495, 'Srbobran', 4101),
(47496, 'Sremska Kamenica', 4101),
(47497, 'Sremska Mitrovica', 4101),
(47498, 'Sremski Karlovci', 4101),
(47499, 'Stara Pazova', 4101),
(47500, 'Subotica', 4101),
(47501, 'Temerin', 4101),
(47502, 'Veternik', 4101),
(47503, 'Vrbas', 4101),
(47504, 'Vrshac', 4101),
(47505, 'Zhabalj', 4101),
(47506, 'Zhitishte', 4101),
(47507, 'Zrenjanin', 4101),
(47508, 'Kabwe', 4102),
(47509, 'Kapiri Mposhi', 4102),
(47510, 'Mkushi', 4102),
(47511, 'Mumbwa', 4102),
(47512, 'Serenje', 4102),
(47513, 'Chambishi', 4103),
(47514, 'Chililabombwe', 4103),
(47515, 'Chingola', 4103),
(47516, 'Kalulushi', 4103),
(47517, 'Kitwe', 4103),
(47518, 'Luanshya', 4103),
(47519, 'Mpongwe', 4103),
(47520, 'Mufulira', 4103),
(47521, 'Ndola', 4103),
(47522, 'Chipata', 4104),
(47523, 'Katete', 4104),
(47524, 'Lundazi', 4104),
(47525, 'Petauke', 4104),
(47526, 'Mansa', 4105),
(47527, 'Mwansabombwe', 4105),
(47528, 'Nchelenge', 4105),
(47529, 'Samfya', 4105),
(47530, 'Chilanga', 4106),
(47531, 'Kafue', 4106),
(47532, 'Lusaka', 4106),
(47533, 'Kalengwa', 4107),
(47534, 'Kansanshi', 4107),
(47535, 'Mwinilunga', 4107),
(47536, 'Solwezi', 4107),
(47537, 'Zambezi', 4107),
(47538, 'Chinsali', 4108),
(47539, 'Isoka', 4108),
(47540, 'Kasama', 4108),
(47541, 'Mbala', 4108),
(47542, 'Mpika', 4108),
(47543, 'Choma', 4109),
(47544, 'Itezhi-Tezhi', 4109),
(47545, 'Kalomo', 4109),
(47546, 'Livingstone', 4109),
(47547, 'Maamba', 4109),
(47548, 'Mazabuka', 4109),
(47549, 'Monze', 4109),
(47550, 'Nakambala', 4109),
(47551, 'Siavonga', 4109),
(47552, 'Kalabo', 4110),
(47553, 'Kaoma', 4110),
(47554, 'Limulunga', 4110),
(47555, 'Mongu', 4110),
(47556, 'Senanga', 4110),
(47557, 'Sesheke', 4110),
(47558, 'Bulawayo', 4111),
(47559, 'Chitungwiza', 4112),
(47560, 'Harare', 4112),
(47561, 'Chimanimani', 4113),
(47562, 'Chipinge', 4113),
(47563, 'Mutare', 4113),
(47564, 'Nyanga', 4113),
(47565, 'Rusape', 4113),
(47566, 'Sakubva', 4113),
(47567, 'Chiredzi', 4117),
(47568, 'Gaths', 4117),
(47569, 'Masvingo', 4117),
(47570, 'Chivhu', 4120),
(47571, 'Gweru', 4120),
(47572, 'Kwekwe', 4120),
(47573, 'Mvuma', 4120),
(47574, 'Redcliffe', 4120),
(47575, 'Shurugwi', 4120),
(47576, 'Zvishavane', 4120),
(47577, 'Manchester', 3952),
(47578, 'Nashua', 3952),
(47579, 'Concord', 3952),
(47580, 'Derry', 3952),
(47581, 'Dover', 3952),
(47582, 'Rochester', 3952),
(47583, 'Salem', 3952),
(47584, 'Merrimack', 3952),
(47585, 'Hudson', 3952),
(47586, 'Londonderry', 3952),
(47587, 'Keene', 3952),
(47588, 'Bedford', 3952),
(47589, 'Portsmouth', 3952),
(47590, 'Goffstown', 3952),
(47591, 'Laconia', 3952),
(47592, 'Hampton', 3952),
(47593, 'Milford', 3952),
(47594, 'Durham', 3952),
(47595, 'Exeter', 3952),
(47596, 'Windham', 3952),
(47597, 'Hooksett', 3952),
(47598, 'Claremont', 3952),
(47599, 'Lebanon', 3952),
(47600, 'Pelham', 3952),
(47601, 'Somersworth', 3952),
(47602, 'Hanover', 3952),
(47603, 'Amherst', 3952),
(47604, 'Raymond', 3952),
(47605, 'Conway', 3952),
(47606, 'Berlin', 3952),
(47607, 'Newmarket', 3952),
(47608, 'Weare', 3952),
(47609, 'Seabrook', 3952),
(47610, 'Barrington', 3952),
(47611, 'Hampstead', 3952),
(47612, 'Franklin', 3952),
(47613, 'Litchfield', 3952),
(47614, 'Hollis', 3952),
(47615, 'Plaistow', 3952),
(47616, 'Bow', 3952),
(47617, 'Belmont', 3952),
(47618, 'Stratham', 3952),
(47619, 'Swanzey', 3952),
(47620, 'Gilford', 3952),
(47621, 'Pembroke', 3952),
(47622, 'Plymouth', 3952),
(47623, 'Farmington', 3952),
(47624, 'Atkinson', 3952),
(47625, 'Newport', 3952),
(47626, 'Epping', 3952),
(47627, 'Peterborough', 3952),
(47628, 'Wolfeboro', 3952),
(47629, 'Meredith', 3952),
(47630, 'Kingston', 3952),
(47631, 'Rindge', 3952),
(47632, 'Hillsborough', 3952),
(47633, 'Newark', 3953),
(47634, 'Jersey City', 3953),
(47635, 'Paterson', 3953),
(47636, 'Elizabeth', 3953),
(47637, 'Edison', 3953),
(47638, 'Woodbridge', 3953),
(47639, 'Lakewood', 3953),
(47640, 'Toms River', 3953),
(47641, 'Hamilton', 3953),
(47642, 'Trenton', 3953),
(47643, 'Clifton', 3953),
(47644, 'Camden', 3953),
(47645, 'Brick', 3953),
(47646, 'Cherry Hill', 3953),
(47647, 'Passaic', 3953),
(47648, 'Middletown', 3953),
(47649, 'Union City', 3953),
(47650, 'Old Bridge', 3953),
(47651, 'Gloucester Township', 3953),
(47652, 'East Orange', 3953),
(47653, 'Bayonne', 3953),
(47654, 'Franklin', 3953),
(47655, 'North Bergen', 3953),
(47656, 'Vineland', 3953),
(47657, 'Union', 3953),
(47658, 'Piscataway', 3953),
(47659, 'New Brunswick', 3953),
(47660, 'Jackson', 3953),
(47661, 'Wayne', 3953),
(47662, 'Irvington', 3953),
(47663, 'Parsippany-Troy Hills', 3953),
(47664, 'Howell', 3953),
(47665, 'Perth Amboy', 3953),
(47666, 'Hoboken', 3953),
(47667, 'Plainfield', 3953),
(47668, 'West New York', 3953),
(47669, 'Washington Township', 3953),
(47670, 'East Brunswick', 3953),
(47671, 'Bloomfield', 3953),
(47672, 'West Orange', 3953),
(47673, 'Evesham', 3953),
(47674, 'Bridgewater', 3953),
(47675, 'South Brunswick', 3953),
(47676, 'Egg Harbor', 3953),
(47677, 'Manchester', 3953),
(47678, 'Hackensack', 3953),
(47679, 'Sayreville', 3953),
(47680, 'Mount Laurel', 3953),
(47681, 'Berkeley', 3953),
(47682, 'North Brunswick', 3953),
(47683, 'Kearny', 3953),
(47684, 'Linden', 3953),
(47685, 'Marlboro', 3953),
(47686, 'Teaneck', 3953),
(47687, 'Atlantic City', 3953),
(47688, 'Winslow', 3953),
(47689, 'Monroe', 3953),
(47690, 'Manalapan', 3953),
(47691, 'Hillsborough', 3953),
(47692, 'Montclair', 3953),
(47693, 'Galloway', 3953),
(47694, 'Freehold Township', 3953),
(47695, 'Monroe Township', 3953),
(47696, 'Belleville', 3953),
(47697, 'Pennsauken', 3953),
(47698, 'Ewing', 3953),
(47699, 'Fort Lee', 3953),
(47700, 'Lawrence', 3953),
(47701, 'Fair Lawn', 3953),
(47702, 'Willingboro', 3953),
(47703, 'Long Branch', 3953),
(47704, 'Deptford', 3953),
(47705, 'Garfield', 3953),
(47706, 'Westfield', 3953),
(47707, 'City of Orange', 3953),
(47708, 'Livingston', 3953),
(47709, 'Voorhees', 3953),
(47710, 'Princeton', 3953),
(47711, 'Millville', 3953),
(47712, 'Nutley', 3953),
(47713, 'Mount Olive', 3953),
(47714, 'Neptune', 3953);
INSERT INTO `cities` (`id`, `name`, `state_id`) VALUES
(47715, 'Pemberton Township', 3953),
(47716, 'Lacey', 3953),
(47717, 'Rahway', 3953),
(47718, 'Ocean Township', 3953),
(47719, 'East Windsor', 3953),
(47720, 'West Windsor', 3953),
(47721, 'Englewood', 3953),
(47722, 'Bergenfield', 3953),
(47723, 'Bernards Township', 3953),
(47724, 'Stafford Township', 3953),
(47725, 'Hamilton Township', 3953),
(47726, 'Paramus', 3953),
(47727, 'Wall', 3953),
(47728, 'Mahwah', 3953),
(47729, 'West Milford', 3953),
(47730, 'Randolph', 3953),
(47731, 'Bridgeton', 3953),
(47732, 'Ridgewood', 3953),
(47733, 'Rockaway Township', 3953),
(47734, 'Lodi', 3953),
(47735, 'Vernon', 3953),
(47736, 'Maplewood', 3953),
(47737, 'Cliffside Park', 3953),
(47738, 'Scotch Plains', 3953),
(47739, 'South Plainfield', 3953),
(47740, 'Roxbury', 3953),
(47741, 'Medford', 3953),
(47742, 'Plainsboro', 3953),
(47743, 'Lower Township', 3953),
(47744, 'Carteret', 3953),
(47745, 'Cranford', 3953),
(47746, 'Burlington Township', 3953),
(47747, 'Morris Township', 3953),
(47748, 'Montgomery', 3953),
(47749, 'Raritan Township', 3953),
(47750, 'North Plainfield', 3953),
(47751, 'West Deptford', 3953),
(47752, 'Montville', 3953),
(47753, 'Summit', 3953),
(47754, 'Hillside', 3953),
(47755, 'Jefferson', 3953),
(47756, 'Roselle', 3953),
(47757, 'Barnegat', 3953),
(47758, 'Moorestown', 3953),
(47759, 'Lyndhurst', 3953),
(47760, 'Hazlet', 3953),
(47761, 'Pleasantville', 3953),
(47762, 'Millburn', 3953),
(47763, 'Little Egg Harbor', 3953),
(47764, 'Sparta', 3953),
(47765, 'Palisades Park', 3953),
(47766, 'Elmwood Park', 3953),
(47767, 'Maple Shade', 3953),
(47768, 'Middle Township', 3953),
(47769, 'Hawthorne', 3953),
(47770, 'Glassboro', 3953),
(47771, 'Washington Township', 3953),
(47772, 'Morristown', 3953),
(47773, 'Point Pleasant', 3953),
(47774, 'Aberdeen', 3953),
(47775, 'Dover', 3953),
(47776, 'Rutherford', 3953),
(47777, 'Tinton Falls', 3953),
(47778, 'Lindenwold', 3953),
(47779, 'Dumont', 3953),
(47780, 'Hopewell Township', 3953),
(47781, 'Delran', 3953),
(47782, 'Franklin Township', 3953),
(47783, 'Holmdel', 3953),
(47784, 'Wyckoff', 3953),
(47785, 'Denville', 3953),
(47786, 'New Milford', 3953),
(47787, 'Secaucus', 3953),
(47788, 'South Orange Village', 3953),
(47789, 'Readington', 3953),
(47790, 'Asbury Park', 3953),
(47791, 'South River', 3953),
(47792, 'Madison', 3953),
(47793, 'Springfield', 3953),
(47794, 'Cinnaminson', 3953),
(47795, 'Pequannock', 3953),
(47796, 'North Arlington', 3953),
(47797, 'Warren', 3953),
(47798, 'Mantua', 3953),
(47799, 'Hopatcong', 3953),
(47800, 'Phillipsburg', 3953),
(47801, 'Hammonton', 3953),
(47802, 'Clark', 3953),
(47803, 'Haddon Township', 3953),
(47804, 'Tenafly', 3953),
(47805, 'Ramsey', 3953),
(47806, 'Branchburg', 3953),
(47807, 'Little Falls', 3953),
(47808, 'Highland Park', 3953),
(47809, 'Collingswood', 3953),
(47810, 'Fairview', 3953),
(47811, 'Hanover', 3953),
(47812, 'Saddle Brook', 3953),
(47813, 'Robbinsville', 3953),
(47814, 'Middlesex', 3953),
(47815, 'Harrison', 3953),
(47816, 'Metuchen', 3953),
(47817, 'Clinton Township', 3953),
(47818, 'Pennsville', 3953),
(47819, 'Verona', 3953),
(47820, 'Albuquerque', 3955),
(47821, 'Las Cruces', 3955),
(47822, 'Rio Rancho', 3955),
(47823, 'Santa Fe', 3955),
(47824, 'Roswell', 3955),
(47825, 'Farmington', 3955),
(47826, 'South Valley', 3955),
(47827, 'Clovis', 3955),
(47828, 'Hobbs', 3955),
(47829, 'Alamogordo', 3955),
(47830, 'Carlsbad', 3955),
(47831, 'Gallup', 3955),
(47832, 'Deming', 3955),
(47833, 'Los Lunas', 3955),
(47834, 'Chaparral', 3955),
(47835, 'Sunland Park', 3955),
(47836, 'Las Vegas', 3955),
(47837, 'Portales', 3955),
(47838, 'Los Alamos', 3955),
(47839, 'North Valley', 3955),
(47840, 'Artesia', 3955),
(47841, 'Lovington', 3955),
(47842, 'Silver City', 3955),
(47843, 'Espanola', 3955),
(47844, 'Anthony', 3955),
(47845, 'Grants', 3955),
(47846, 'Socorro', 3955),
(47847, 'Corrales', 3955),
(47848, 'Bernalillo', 3955),
(47849, 'Shiprock', 3955),
(47850, 'Bloomfield', 3955),
(47851, 'Ruidoso', 3955),
(47852, 'Kirtland', 3955),
(47853, 'Belen', 3955),
(47854, 'Airmont', 3956),
(47855, 'Albany', 3956),
(47856, 'Alden', 3956),
(47857, 'Amherst', 3956),
(47858, 'Amityville', 3956),
(47859, 'Amsterdam', 3956),
(47860, 'Arcadia', 3956),
(47861, 'Auburn', 3956),
(47862, 'Aurora', 3956),
(47863, 'Babylon', 3956),
(47864, 'Baldwinsville', 3956),
(47865, 'Ballston', 3956),
(47866, 'Batavia', 3956),
(47867, 'Bath', 3956),
(47868, 'Beacon', 3956),
(47869, 'Bedford', 3956),
(47870, 'Beekman', 3956),
(47871, 'Bethlehem', 3956),
(47872, 'Binghamton', 3956),
(47873, 'Blooming Grove', 3956),
(47874, 'Briarcliff Manor', 3956),
(47875, 'Brighton', 3956),
(47876, 'Brockport', 3956),
(47877, 'Brookhaven', 3956),
(47878, 'Brunswick', 3956),
(47879, 'Buffalo', 3956),
(47880, 'Camillus', 3956),
(47881, 'Canandaigua', 3956),
(47882, 'Canton', 3956),
(47883, 'Carmel', 3956),
(47884, 'Catskill', 3956),
(47885, 'Cheektowaga', 3956),
(47886, 'Chenango', 3956),
(47887, 'Chester', 3956),
(47888, 'Chestnut Ridge', 3956),
(47889, 'Chili', 3956),
(47890, 'Cicero', 3956),
(47891, 'Clarence', 3956),
(47892, 'Clarkstown', 3956),
(47893, 'Clay', 3956),
(47894, 'Clifton Park', 3956),
(47895, 'Cohoes', 3956),
(47896, 'Colonie', 3956),
(47897, 'Corning', 3956),
(47898, 'Cornwall', 3956),
(47899, 'Cortland', 3956),
(47900, 'Cortlandt', 3956),
(47901, 'Crawford', 3956),
(47902, 'Croton-on-Hudson', 3956),
(47903, 'Depew', 3956),
(47904, 'DeWitt (De Witt)', 3956),
(47905, 'Dobbs Ferry', 3956),
(47906, 'Dryden', 3956),
(47907, 'Dunkirk', 3956),
(47908, 'East Fishkill', 3956),
(47909, 'East Greenbush', 3956),
(47910, 'East Hampton', 3956),
(47911, 'East Hills', 3956),
(47912, 'East Rockaway', 3956),
(47913, 'Eastchester', 3956),
(47914, 'Elma', 3956),
(47915, 'Elmira', 3956),
(47916, 'Endicott', 3956),
(47917, 'Esopus', 3956),
(47918, 'Evans', 3956),
(47919, 'Fallsburg', 3956),
(47920, 'Farmingdale', 3956),
(47921, 'Farmington', 3956),
(47922, 'Fishkill', 3956),
(47923, 'Floral Park', 3956),
(47924, 'Fredonia', 3956),
(47925, 'Freeport', 3956),
(47926, 'Fulton', 3956),
(47927, 'Garden City', 3956),
(47928, 'Gates', 3956),
(47929, 'Geddes', 3956),
(47930, 'Geneseo', 3956),
(47931, 'Geneva', 3956),
(47932, 'German Flatts', 3956),
(47933, 'Glen Cove', 3956),
(47934, 'Glens Falls', 3956),
(47935, 'Glenville', 3956),
(47936, 'Gloversville', 3956),
(47937, 'Goshen', 3956),
(47938, 'Grand Island', 3956),
(47939, 'Great Neck', 3956),
(47940, 'Greece', 3956),
(47941, 'Greenburgh', 3956),
(47942, 'Guilderland', 3956),
(47943, 'Halfmoon', 3956),
(47944, 'Hamburg', 3956),
(47945, 'Hamlin', 3956),
(47946, 'Harrison', 3956),
(47947, 'Hastings', 3956),
(47948, 'Hastings-on-Hudson', 3956),
(47949, 'Haverstraw', 3956),
(47950, 'Hempstead', 3956),
(47951, 'Henrietta', 3956),
(47952, 'Herkimer', 3956),
(47953, 'Highlands', 3956),
(47954, 'Hornell', 3956),
(47955, 'Horseheads', 3956),
(47956, 'Hudson', 3956),
(47957, 'Hudson Falls', 3956),
(47958, 'Huntington', 3956),
(47959, 'Hyde Park', 3956),
(47960, 'Ilion', 3956),
(47961, 'Irondequoit', 3956),
(47962, 'Islip', 3956),
(47963, 'Ithaca', 3956),
(47964, 'Jamestown', 3956),
(47965, 'Johnson City', 3956),
(47966, 'Johnstown', 3956),
(47967, 'Kenmore', 3956),
(47968, 'Kent', 3956),
(47969, 'Kingsbury', 3956),
(47970, 'Kingston', 3956),
(47971, 'Kirkland', 3956),
(47972, 'Kiryas Joel', 3956),
(47973, 'Lackawanna', 3956),
(47974, 'LaGrange (La Grange)', 3956),
(47975, 'Lake Grove', 3956),
(47976, 'Lancaster', 3956),
(47977, 'Lansing', 3956),
(47978, 'Le Ray', 3956),
(47979, 'Lenox', 3956),
(47980, 'Lewisboro', 3956),
(47981, 'Lewiston', 3956),
(47982, 'Liberty', 3956),
(47983, 'Lindenhurst', 3956),
(47984, 'Little Falls', 3956),
(47985, 'Lloyd', 3956),
(47986, 'Lockport', 3956),
(47987, 'Long Beach', 3956),
(47988, 'Lynbrook', 3956),
(47989, 'Lysander', 3956),
(47990, 'Macedon', 3956),
(47991, 'Malone', 3956),
(47992, 'Malta', 3956),
(47993, 'Malverne', 3956),
(47994, 'Mamakating', 3956),
(47995, 'Mamaroneck', 3956),
(47996, 'Manchester', 3956),
(47997, 'Manlius', 3956),
(47998, 'Massapequa Park', 3956),
(47999, 'Massena', 3956),
(48000, 'Mastic Beach', 3956),
(48001, 'Mechanicville', 3956),
(48002, 'Mendon', 3956),
(48003, 'Middletown', 3956),
(48004, 'Milton', 3956),
(48005, 'Mineola', 3956),
(48006, 'Monroe', 3956),
(48007, 'Montgomery', 3956),
(48008, 'Moreau', 3956),
(48009, 'Mount Kisco', 3956),
(48010, 'Mount Pleasant', 3956),
(48011, 'Mount Vernon', 3956),
(48012, 'New Castle', 3956),
(48013, 'New Hartford', 3956),
(48014, 'New Hyde Park', 3956),
(48015, 'New Paltz', 3956),
(48016, 'New Rochelle', 3956),
(48017, 'New Square', 3956),
(48018, 'New Windsor', 3956),
(48019, 'New York', 3956),
(48020, 'Newark', 3956),
(48021, 'Newburgh', 3956),
(48022, 'Newfane', 3956),
(48023, 'Niagara Falls', 3956),
(48024, 'Niskayuna', 3956),
(48025, 'North Castle', 3956),
(48026, 'North Greenbush', 3956),
(48027, 'North Hempstead', 3956),
(48028, 'North Syracuse', 3956),
(48029, 'North Tonawanda', 3956),
(48030, 'Northport', 3956),
(48031, 'Norwich', 3956),
(48032, 'Nyack', 3956),
(48033, 'Ogden', 3956),
(48034, 'Ogdensburg', 3956),
(48035, 'Olean', 3956),
(48036, 'Oneida', 3956),
(48037, 'Oneonta', 3956),
(48038, 'Onondaga', 3956),
(48039, 'Ontario', 3956),
(48040, 'Orangetown', 3956),
(48041, 'Orchard Park', 3956),
(48042, 'Ossining', 3956),
(48043, 'Oswego', 3956),
(48044, 'Owego', 3956),
(48045, 'Oyster Bay', 3956),
(48046, 'Parma', 3956),
(48047, 'Patchogue', 3956),
(48048, 'Patterson', 3956),
(48049, 'Peekskill', 3956),
(48050, 'Pelham', 3956),
(48051, 'Penfield', 3956),
(48052, 'Perinton', 3956),
(48053, 'Philipstown', 3956),
(48054, 'Pittsford', 3956),
(48055, 'Plattekill', 3956),
(48056, 'Plattsburgh', 3956),
(48057, 'Pleasant Valley', 3956),
(48058, 'Pleasantville', 3956),
(48059, 'Pomfret', 3956),
(48060, 'Port Chester', 3956),
(48061, 'Port Jefferson', 3956),
(48062, 'Port Jervis', 3956),
(48063, 'Potsdam', 3956),
(48064, 'Poughkeepsie', 3956),
(48065, 'Putnam Valley', 3956),
(48066, 'Queensbury', 3956),
(48067, 'Ramapo', 3956),
(48068, 'Red Hook', 3956),
(48069, 'Rensselaer', 3956),
(48070, 'Riverhead', 3956),
(48071, 'Rochester', 3956),
(48072, 'Rockville Centre', 3956),
(48073, 'Rome', 3956),
(48074, 'Rotterdam', 3956),
(48075, 'Rye', 3956),
(48076, 'Rye Brook', 3956),
(48077, 'Salamanca', 3956),
(48078, 'Salina', 3956),
(48079, 'Saratoga Springs', 3956),
(48080, 'Saugerties', 3956),
(48081, 'Scarsdale', 3956),
(48082, 'Schenectady', 3956),
(48083, 'Schodack', 3956),
(48084, 'Scotia', 3956),
(48085, 'Seneca Falls', 3956),
(48086, 'Shawangunk', 3956),
(48087, 'Sherrill', 3956),
(48088, 'Sleepy Hollow', 3956),
(48089, 'Smithtown', 3956),
(48090, 'Somers', 3956),
(48091, 'Southampton', 3956),
(48092, 'Southeast', 3956),
(48093, 'Southold', 3956),
(48094, 'Southport', 3956),
(48095, 'Spring Valley', 3956),
(48096, 'Stony Point', 3956),
(48097, 'Suffern', 3956),
(48098, 'Sullivan', 3956),
(48099, 'Sweden', 3956),
(48100, 'Syracuse', 3956),
(48101, 'Tarrytown', 3956),
(48102, 'Thompson', 3956),
(48103, 'Tonawanda', 3956),
(48104, 'Troy', 3956),
(48105, 'Ulster', 3956),
(48106, 'Union', 3956),
(48107, 'Utica', 3956),
(48108, 'Valley Stream', 3956),
(48109, 'Van Buren', 3956),
(48110, 'Vestal', 3956),
(48111, 'Victor', 3956),
(48112, 'Walden', 3956),
(48113, 'Wallkill', 3956),
(48114, 'Walworth', 3956),
(48115, 'Wappinger', 3956),
(48116, 'Warwick', 3956),
(48117, 'Watertown', 3956),
(48118, 'Watervliet', 3956),
(48119, 'Wawarsing', 3956),
(48120, 'Webster', 3956),
(48121, 'West Haverstraw', 3956),
(48122, 'West Seneca', 3956),
(48123, 'Westbury', 3956),
(48124, 'Wheatfield', 3956),
(48125, 'White Plains', 3956),
(48126, 'Whitestown', 3956),
(48127, 'Williston Park', 3956),
(48128, 'Wilton', 3956),
(48129, 'Woodbury', 3956),
(48130, 'Yonkers', 3956),
(48131, 'Yorktown', 3956),
(48132, 'Charlotte', 3957),
(48133, 'Raleigh', 3957),
(48134, 'Greensboro', 3957),
(48135, 'Durham', 3957),
(48136, 'Winston-Salem', 3957),
(48137, 'Fayetteville', 3957),
(48138, 'Cary', 3957),
(48139, 'Wilmington', 3957),
(48140, 'High Point', 3957),
(48141, 'Greenville', 3957),
(48142, 'Asheville', 3957),
(48143, 'Concord', 3957),
(48144, 'Gastonia', 3957),
(48145, 'Jacksonville', 3957),
(48146, 'Chapel Hill', 3957),
(48147, 'Rocky Mount', 3957),
(48148, 'Burlington', 3957),
(48149, 'Huntersville', 3957),
(48150, 'Wilson', 3957),
(48151, 'Kannapolis', 3957),
(48152, 'Apex', 3957),
(48153, 'Hickory', 3957),
(48154, 'Wake Forest', 3957),
(48155, 'Indian Trail', 3957),
(48156, 'Goldsboro', 3957),
(48157, 'Mooresville', 3957),
(48158, 'Monroe', 3957),
(48159, 'Salisbury', 3957),
(48160, 'New Bern', 3957),
(48161, 'Holly Springs', 3957),
(48162, 'Matthews', 3957),
(48163, 'Sanford', 3957),
(48164, 'Garner', 3957),
(48165, 'Cornelius', 3957),
(48166, 'Thomasville', 3957),
(48167, 'Asheboro', 3957),
(48168, 'Statesville', 3957),
(48169, 'Mint Hill', 3957),
(48170, 'Kernersville', 3957),
(48171, 'Morrisville', 3957),
(48172, 'Fuquay-Varina', 3957),
(48173, 'Lumberton', 3957),
(48174, 'Kinston', 3957),
(48175, 'Carrboro', 3957),
(48176, 'Havelock', 3957),
(48177, 'Shelby', 3957),
(48178, 'Clemmons', 3957),
(48179, 'Lexington', 3957),
(48180, 'Clayton', 3957),
(48181, 'Boone', 3957),
(48182, 'Fargo', 3958),
(48183, 'Bismarck', 3958),
(48184, 'Grand Forks', 3958),
(48185, 'Minot', 3958),
(48186, 'West Fargo', 3958),
(48187, 'Williston', 3958),
(48188, 'Dickinson', 3958),
(48189, 'Mandan', 3958),
(48190, 'Jamestown', 3958),
(48191, 'Wahpeton', 3958),
(48192, 'Devils Lake', 3958),
(48193, 'Valley City', 3958),
(48194, 'Providence', 3965),
(48195, 'Warwick', 3965),
(48196, 'Cranston', 3965),
(48197, 'Pawtucket', 3965),
(48198, 'East Providence', 3965),
(48199, 'Woonsocket', 3965),
(48200, 'Coventry', 3965),
(48201, 'Cumberland', 3965),
(48202, 'North Providence', 3965),
(48203, 'South Kingstown', 3965),
(48204, 'West Warwick', 3965),
(48205, 'Johnston', 3965),
(48206, 'North Kingstown', 3965),
(48207, 'Newport', 3965),
(48208, 'Bristol', 3965),
(48209, 'Westerly', 3965),
(48210, 'Smithfield', 3965),
(48211, 'Lincoln', 3965),
(48212, 'Central Falls', 3965),
(48213, 'Portsmouth', 3965),
(48214, 'Barrington', 3965),
(48215, 'Middletown', 3965),
(48216, 'Burrillville', 3965),
(48217, 'Narragansett', 3965),
(48218, 'Tiverton', 3965),
(48219, 'East Greenwich', 3965),
(48220, 'North Smithfield', 3965),
(48221, 'Warren', 3965),
(48222, 'Scituate', 3965),
(48223, 'Glocester', 3965),
(48224, 'Hopkinton', 3965),
(48225, 'Charlestown', 3965),
(48226, 'Richmond', 3965),
(48227, 'Columbia', 3966),
(48228, 'Charleston', 3966),
(48229, 'North Charleston', 3966),
(48230, 'Mount Pleasant', 3966),
(48231, 'Rock Hill', 3966),
(48232, 'Greenville', 3966),
(48233, 'Summerville', 3966),
(48234, 'Sumter', 3966),
(48235, 'Hilton Head Island', 3966),
(48236, 'Spartanburg', 3966),
(48237, 'Florence', 3966),
(48238, 'Goose Creek', 3966),
(48239, 'Aiken', 3966),
(48240, 'Myrtle Beach', 3966),
(48241, 'Anderson', 3966),
(48242, 'Greer', 3966),
(48243, 'Mauldin', 3966),
(48244, 'Greenwood', 3966),
(48245, 'North Augusta', 3966),
(48246, 'Easley', 3966),
(48247, 'Simpsonville', 3966),
(48248, 'Hanahan', 3966),
(48249, 'Lexington', 3966),
(48250, 'Conway', 3966),
(48251, 'West Columbia', 3966),
(48252, 'North Myrtle Beach', 3966),
(48253, 'Clemson', 3966),
(48254, 'Orangeburg', 3966),
(48255, 'Cayce', 3966),
(48256, 'Bluffton', 3966),
(48257, 'Beaufort', 3966),
(48258, 'Gaffney', 3966),
(48259, 'Irmo', 3966),
(48260, 'Fort Mill', 3966),
(48261, 'Port Royal', 3966),
(48262, 'Forest Acres', 3966),
(48263, 'Newberry', 3966),
(48264, 'Sioux Falls', 3967),
(48265, 'Rapid City', 3967),
(48266, 'Aberdeen', 3967),
(48267, 'Brookings', 3967),
(48268, 'Watertown', 3967),
(48269, 'Mitchell', 3967),
(48270, 'Yankton', 3967),
(48271, 'Pierre', 3967),
(48272, 'Huron', 3967),
(48273, 'Spearfish', 3967),
(48274, 'Vermillion', 3967),
(48275, 'Brandon', 3967),
(48276, 'Box Elder', 3967),
(48277, 'Madison', 3967),
(48278, 'Sturgis', 3967),
(48279, 'Belle Fourche', 3967),
(48280, 'Harrisburg', 3967),
(48281, 'Charleston', 3976),
(48282, 'Huntington', 3976),
(48283, 'Morgantown', 3976),
(48284, 'Parkersburg', 3976),
(48285, 'Wheeling', 3976),
(48286, 'Weirton', 3976),
(48287, 'Fairmont', 3976),
(48288, 'Martinsburg', 3976),
(48289, 'Beckley', 3976),
(48290, 'Clarksburg', 3976),
(48291, 'South Charleston', 3976),
(48292, 'St. Albans', 3976),
(48293, 'Vienna', 3976),
(48294, 'Bluefield', 3976),
(48295, 'Moundsville', 3976),
(48296, 'Bridgeport', 3976),
(48297, 'Oak Hill', 3976),
(48298, 'Dunbar', 3976),
(48299, 'Elkins', 3976),
(48300, 'Nitro', 3976),
(48301, 'Hurricane', 3976),
(48302, 'Princeton', 3976),
(48303, 'Charles Town', 3976),
(48304, 'Buckhannon', 3976),
(48305, 'Keyser', 3976),
(48306, 'New Martinsville', 3976),
(48307, 'Grafton', 3976),
(48308, 'Ranson', 3976),
(48309, 'Point Pleasant', 3976),
(48310, 'Westover', 3976),
(48311, 'Weston', 3976),
(48312, 'Lewisburg', 3976),
(48313, 'Ravenswood', 3976),
(48314, 'Summersville', 3976);

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

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int(11) NOT NULL,
  `sortname` varchar(3) NOT NULL,
  `name` varchar(150) NOT NULL,
  `phonecode` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `sortname`, `name`, `phonecode`) VALUES
(1, 'AF', 'Afghanistan', 93),
(2, 'AL', 'Albania', 355),
(3, 'DZ', 'Algeria', 213),
(4, 'AS', 'American Samoa', 1684),
(5, 'AD', 'Andorra', 376),
(6, 'AO', 'Angola', 244),
(7, 'AI', 'Anguilla', 1264),
(8, 'AQ', 'Antarctica', 0),
(9, 'AG', 'Antigua And Barbuda', 1268),
(10, 'AR', 'Argentina', 54),
(11, 'AM', 'Armenia', 374),
(12, 'AW', 'Aruba', 297),
(13, 'AU', 'Australia', 61),
(14, 'AT', 'Austria', 43),
(15, 'AZ', 'Azerbaijan', 994),
(16, 'BS', 'Bahamas The', 1242),
(17, 'BH', 'Bahrain', 973),
(18, 'BD', 'Bangladesh', 880),
(19, 'BB', 'Barbados', 1246),
(20, 'BY', 'Belarus', 375),
(21, 'BE', 'Belgium', 32),
(22, 'BZ', 'Belize', 501),
(23, 'BJ', 'Benin', 229),
(24, 'BM', 'Bermuda', 1441),
(25, 'BT', 'Bhutan', 975),
(26, 'BO', 'Bolivia', 591),
(27, 'BA', 'Bosnia and Herzegovina', 387),
(28, 'BW', 'Botswana', 267),
(29, 'BV', 'Bouvet Island', 0),
(30, 'BR', 'Brazil', 55),
(31, 'IO', 'British Indian Ocean Territory', 246),
(32, 'BN', 'Brunei', 673),
(33, 'BG', 'Bulgaria', 359),
(34, 'BF', 'Burkina Faso', 226),
(35, 'BI', 'Burundi', 257),
(36, 'KH', 'Cambodia', 855),
(37, 'CM', 'Cameroon', 237),
(38, 'CA', 'Canada', 1),
(39, 'CV', 'Cape Verde', 238),
(40, 'KY', 'Cayman Islands', 1345),
(41, 'CF', 'Central African Republic', 236),
(42, 'TD', 'Chad', 235),
(43, 'CL', 'Chile', 56),
(44, 'CN', 'China', 86),
(45, 'CX', 'Christmas Island', 61),
(46, 'CC', 'Cocos (Keeling) Islands', 672),
(47, 'CO', 'Colombia', 57),
(48, 'KM', 'Comoros', 269),
(49, 'CG', 'Republic Of The Congo', 242),
(50, 'CD', 'Democratic Republic Of The Congo', 242),
(51, 'CK', 'Cook Islands', 682),
(52, 'CR', 'Costa Rica', 506),
(53, 'CI', 'Cote D\'Ivoire (Ivory Coast)', 225),
(54, 'HR', 'Croatia (Hrvatska)', 385),
(55, 'CU', 'Cuba', 53),
(56, 'CY', 'Cyprus', 357),
(57, 'CZ', 'Czech Republic', 420),
(58, 'DK', 'Denmark', 45),
(59, 'DJ', 'Djibouti', 253),
(60, 'DM', 'Dominica', 1767),
(61, 'DO', 'Dominican Republic', 1809),
(62, 'TP', 'East Timor', 670),
(63, 'EC', 'Ecuador', 593),
(64, 'EG', 'Egypt', 20),
(65, 'SV', 'El Salvador', 503),
(66, 'GQ', 'Equatorial Guinea', 240),
(67, 'ER', 'Eritrea', 291),
(68, 'EE', 'Estonia', 372),
(69, 'ET', 'Ethiopia', 251),
(70, 'XA', 'External Territories of Australia', 61),
(71, 'FK', 'Falkland Islands', 500),
(72, 'FO', 'Faroe Islands', 298),
(73, 'FJ', 'Fiji Islands', 679),
(74, 'FI', 'Finland', 358),
(75, 'FR', 'France', 33),
(76, 'GF', 'French Guiana', 594),
(77, 'PF', 'French Polynesia', 689),
(78, 'TF', 'French Southern Territories', 0),
(79, 'GA', 'Gabon', 241),
(80, 'GM', 'Gambia The', 220),
(81, 'GE', 'Georgia', 995),
(82, 'DE', 'Germany', 49),
(83, 'GH', 'Ghana', 233),
(84, 'GI', 'Gibraltar', 350),
(85, 'GR', 'Greece', 30),
(86, 'GL', 'Greenland', 299),
(87, 'GD', 'Grenada', 1473),
(88, 'GP', 'Guadeloupe', 590),
(89, 'GU', 'Guam', 1671),
(90, 'GT', 'Guatemala', 502),
(91, 'XU', 'Guernsey and Alderney', 44),
(92, 'GN', 'Guinea', 224),
(93, 'GW', 'Guinea-Bissau', 245),
(94, 'GY', 'Guyana', 592),
(95, 'HT', 'Haiti', 509),
(96, 'HM', 'Heard and McDonald Islands', 0),
(97, 'HN', 'Honduras', 504),
(98, 'HK', 'Hong Kong S.A.R.', 852),
(99, 'HU', 'Hungary', 36),
(100, 'IS', 'Iceland', 354),
(101, 'IN', 'India', 91),
(102, 'ID', 'Indonesia', 62),
(103, 'IR', 'Iran', 98),
(104, 'IQ', 'Iraq', 964),
(105, 'IE', 'Ireland', 353),
(106, 'IL', 'Israel', 972),
(107, 'IT', 'Italy', 39),
(108, 'JM', 'Jamaica', 1876),
(109, 'JP', 'Japan', 81),
(110, 'XJ', 'Jersey', 44),
(111, 'JO', 'Jordan', 962),
(112, 'KZ', 'Kazakhstan', 7),
(113, 'KE', 'Kenya', 254),
(114, 'KI', 'Kiribati', 686),
(115, 'KP', 'Korea North', 850),
(116, 'KR', 'Korea South', 82),
(117, 'KW', 'Kuwait', 965),
(118, 'KG', 'Kyrgyzstan', 996),
(119, 'LA', 'Laos', 856),
(120, 'LV', 'Latvia', 371),
(121, 'LB', 'Lebanon', 961),
(122, 'LS', 'Lesotho', 266),
(123, 'LR', 'Liberia', 231),
(124, 'LY', 'Libya', 218),
(125, 'LI', 'Liechtenstein', 423),
(126, 'LT', 'Lithuania', 370),
(127, 'LU', 'Luxembourg', 352),
(128, 'MO', 'Macau S.A.R.', 853),
(129, 'MK', 'Macedonia', 389),
(130, 'MG', 'Madagascar', 261),
(131, 'MW', 'Malawi', 265),
(132, 'MY', 'Malaysia', 60),
(133, 'MV', 'Maldives', 960),
(134, 'ML', 'Mali', 223),
(135, 'MT', 'Malta', 356),
(136, 'XM', 'Man (Isle of)', 44),
(137, 'MH', 'Marshall Islands', 692),
(138, 'MQ', 'Martinique', 596),
(139, 'MR', 'Mauritania', 222),
(140, 'MU', 'Mauritius', 230),
(141, 'YT', 'Mayotte', 269),
(142, 'MX', 'Mexico', 52),
(143, 'FM', 'Micronesia', 691),
(144, 'MD', 'Moldova', 373),
(145, 'MC', 'Monaco', 377),
(146, 'MN', 'Mongolia', 976),
(147, 'MS', 'Montserrat', 1664),
(148, 'MA', 'Morocco', 212),
(149, 'MZ', 'Mozambique', 258),
(150, 'MM', 'Myanmar', 95),
(151, 'NA', 'Namibia', 264),
(152, 'NR', 'Nauru', 674),
(153, 'NP', 'Nepal', 977),
(154, 'AN', 'Netherlands Antilles', 599),
(155, 'NL', 'Netherlands The', 31),
(156, 'NC', 'New Caledonia', 687),
(157, 'NZ', 'New Zealand', 64),
(158, 'NI', 'Nicaragua', 505),
(159, 'NE', 'Niger', 227),
(160, 'NG', 'Nigeria', 234),
(161, 'NU', 'Niue', 683),
(162, 'NF', 'Norfolk Island', 672),
(163, 'MP', 'Northern Mariana Islands', 1670),
(164, 'NO', 'Norway', 47),
(165, 'OM', 'Oman', 968),
(166, 'PK', 'Pakistan', 92),
(167, 'PW', 'Palau', 680),
(168, 'PS', 'Palestinian Territory Occupied', 970),
(169, 'PA', 'Panama', 507),
(170, 'PG', 'Papua new Guinea', 675),
(171, 'PY', 'Paraguay', 595),
(172, 'PE', 'Peru', 51),
(173, 'PH', 'Philippines', 63),
(174, 'PN', 'Pitcairn Island', 0),
(175, 'PL', 'Poland', 48),
(176, 'PT', 'Portugal', 351),
(177, 'PR', 'Puerto Rico', 1787),
(178, 'QA', 'Qatar', 974),
(179, 'RE', 'Reunion', 262),
(180, 'RO', 'Romania', 40),
(181, 'RU', 'Russia', 70),
(182, 'RW', 'Rwanda', 250),
(183, 'SH', 'Saint Helena', 290),
(184, 'KN', 'Saint Kitts And Nevis', 1869),
(185, 'LC', 'Saint Lucia', 1758),
(186, 'PM', 'Saint Pierre and Miquelon', 508),
(187, 'VC', 'Saint Vincent And The Grenadines', 1784),
(188, 'WS', 'Samoa', 684),
(189, 'SM', 'San Marino', 378),
(190, 'ST', 'Sao Tome and Principe', 239),
(191, 'SA', 'Saudi Arabia', 966),
(192, 'SN', 'Senegal', 221),
(193, 'RS', 'Serbia', 381),
(194, 'SC', 'Seychelles', 248),
(195, 'SL', 'Sierra Leone', 232),
(196, 'SG', 'Singapore', 65),
(197, 'SK', 'Slovakia', 421),
(198, 'SI', 'Slovenia', 386),
(199, 'XG', 'Smaller Territories of the UK', 44),
(200, 'SB', 'Solomon Islands', 677),
(201, 'SO', 'Somalia', 252),
(202, 'ZA', 'South Africa', 27),
(203, 'GS', 'South Georgia', 0),
(204, 'SS', 'South Sudan', 211),
(205, 'ES', 'Spain', 34),
(206, 'LK', 'Sri Lanka', 94),
(207, 'SD', 'Sudan', 249),
(208, 'SR', 'Suriname', 597),
(209, 'SJ', 'Svalbard And Jan Mayen Islands', 47),
(210, 'SZ', 'Swaziland', 268),
(211, 'SE', 'Sweden', 46),
(212, 'CH', 'Switzerland', 41),
(213, 'SY', 'Syria', 963),
(214, 'TW', 'Taiwan', 886),
(215, 'TJ', 'Tajikistan', 992),
(216, 'TZ', 'Tanzania', 255),
(217, 'TH', 'Thailand', 66),
(218, 'TG', 'Togo', 228),
(219, 'TK', 'Tokelau', 690),
(220, 'TO', 'Tonga', 676),
(221, 'TT', 'Trinidad And Tobago', 1868),
(222, 'TN', 'Tunisia', 216),
(223, 'TR', 'Turkey', 90),
(224, 'TM', 'Turkmenistan', 7370),
(225, 'TC', 'Turks And Caicos Islands', 1649),
(226, 'TV', 'Tuvalu', 688),
(227, 'UG', 'Uganda', 256),
(228, 'UA', 'Ukraine', 380),
(229, 'AE', 'United Arab Emirates', 971),
(230, 'GB', 'United Kingdom', 44),
(231, 'US', 'United States', 1),
(232, 'UM', 'United States Minor Outlying Islands', 1),
(233, 'UY', 'Uruguay', 598),
(234, 'UZ', 'Uzbekistan', 998),
(235, 'VU', 'Vanuatu', 678),
(236, 'VA', 'Vatican City State (Holy See)', 39),
(237, 'VE', 'Venezuela', 58),
(238, 'VN', 'Vietnam', 84),
(239, 'VG', 'Virgin Islands (British)', 1284),
(240, 'VI', 'Virgin Islands (US)', 1340),
(241, 'WF', 'Wallis And Futuna Islands', 681),
(242, 'EH', 'Western Sahara', 212),
(243, 'YE', 'Yemen', 967),
(244, 'YU', 'Yugoslavia', 38),
(245, 'ZM', 'Zambia', 260),
(246, 'ZW', 'Zimbabwe', 263);

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

--
-- Table structure for table `imagetable`
--

CREATE TABLE `imagetable` (
  `id` int(11) NOT NULL,
  `table_name` varchar(50) DEFAULT NULL,
  `img_path` text DEFAULT NULL,
  `img_href` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ref_id` int(11) DEFAULT NULL,
  `type` int(11) DEFAULT 1,
  `is_active_img` varchar(1) DEFAULT '1',
  `additional_attributes` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `imagetable`
--

INSERT INTO `imagetable` (`id`, `table_name`, `img_path`, `img_href`, `created_at`, `updated_at`, `ref_id`, `type`, `is_active_img`, `additional_attributes`) VALUES
(2, 'logo', 'uploads/imagetable/logo_1596647798.jpg', NULL, '2020-08-05 17:16:38', '2020-08-05 12:16:38', NULL, 1, '1', NULL),
(3, 'favicon', 'uploads/imagetable/img37_1591969852.png', NULL, '2020-06-12 13:50:52', '2020-06-12 08:50:52', NULL, 1, '1', NULL);

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

--
-- Table structure for table `inquiry`
--

CREATE TABLE `inquiry` (
  `id` int(11) NOT NULL,
  `inquiries_fname` varchar(255) NOT NULL,
  `inquiries_email` text NOT NULL,
  `inquiries_phone` varchar(255) DEFAULT NULL,
  `extra_content` text DEFAULT NULL,
  `date` date DEFAULT NULL,
  `is_read` char(1) NOT NULL DEFAULT '0',
  `type` int(11) NOT NULL DEFAULT 1,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `is_active` int(11) NOT NULL DEFAULT 1,
  `is_deleted` int(11) DEFAULT 0,
  `user_id` int(11) DEFAULT 0,
  `inquiries_lname` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `migrations`
--

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

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(32, '2020_02_06_212634_create_coupons_table', 1),
(33, '2020_02_17_141858_create_leads_table', 2),
(34, '2020_03_03_103119_create_services_table', 3),
(35, '2020_03_03_131702_create_blogs_table', 4),
(36, '2020_03_04_100337_create_videos_table', 5),
(37, '2020_03_04_115141_create_galleries_table', 6),
(38, '2020_03_05_074441_create_testimonials_table', 7),
(39, '2020_03_05_082154_create_partners_table', 8),
(40, '2020_03_05_082315_create_agents_table', 9),
(41, '2020_03_05_082618_create_immigrations_table', 10),
(42, '2020_03_06_112628_create_programs_table', 11),
(43, '2020_03_14_122529_create_phrases_table', 12),
(45, '2020_03_18_090959_create_posts_table', 13),
(46, '2020_03_19_103559_create_blogs_table', 14),
(47, '2020_03_19_114604_create_faqs_table', 15),
(48, '2020_03_20_132636_create_discoveries_table', 16),
(49, '2020_03_23_093654_create_sizes_table', 17),
(50, '2020_03_23_094659_create_colors_table', 18),
(51, '2020_03_23_182646_product_images', 19),
(52, '2020_04_03_135842_create_reviews_table', 20),
(53, '2020_04_03_143348_create_teams_table', 21),
(54, '2020_04_07_091305_create_yachts_table', 22),
(55, '2020_04_07_092411_create_types_table', 23),
(56, '2020_04_07_100421_create_locations_table', 24),
(57, '2020_04_07_100456_create_builders_table', 25),
(58, '2020_04_07_100703_create_lenghts_table', 26),
(59, '2020_04_13_134432_create_testimonials_table', 27),
(60, '2020_04_13_134557_create_pages_table', 28),
(61, '2020_04_13_153243_create_languages_table', 29),
(62, '2020_04_17_092905_create_contents_table', 30),
(63, '2020_05_01_134228_create_protections_table', 31),
(64, '2020_05_01_134426_create_insurances_table', 32),
(65, '2020_05_20_185831_create_members_table', 33),
(66, '2020_06_02_122548_create_whats_table', 34),
(67, '2020_06_17_113911_create_resumes_table', 35),
(68, '2020_06_24_085039_create_videos_table', 36),
(69, '2020_07_21_144243_create_consults_table', 37);

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

--
-- Table structure for table `m_flag`
--

CREATE TABLE `m_flag` (
  `id` int(11) NOT NULL,
  `flag_type` varchar(100) NOT NULL,
  `flag_value` varchar(250) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `flag_additionalText` text DEFAULT NULL,
  `has_image` varchar(1) DEFAULT '0',
  `is_active` varchar(1) DEFAULT '1',
  `is_config` varchar(1) DEFAULT '0',
  `flag_show_text` text DEFAULT NULL,
  `is_featured` int(11) DEFAULT 0,
  `is_deleted` int(11) DEFAULT 0,
  `user_id` int(11) DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `m_flag`
--

INSERT INTO `m_flag` (`id`, `flag_type`, `flag_value`, `created_at`, `updated_at`, `flag_additionalText`, `has_image`, `is_active`, `is_config`, `flag_show_text`, `is_featured`, `is_deleted`, `user_id`) VALUES
(59, 'COMPANYPHONE', '800 681 4926', '2020-08-05 19:15:04', '0000-00-00 00:00:00', '800 681 4926', '0', '1', '1', 'Company Phone', 0, 0, 0),
(123, 'COMPANYURL', 'Free Shipping', '2020-03-02 11:44:17', '0000-00-00 00:00:00', 'Free Shipping', '0', '1', '0', 'Shipping', 0, 0, 0),
(218, 'COMPANYEMAIL', '8murraym@mpmassociates.com', '2020-08-05 19:16:13', '0000-00-00 00:00:00', '8murraym@mpmassociates.com', '0', '1', '1', 'Company Email', 0, 0, 0),
(499, 'copyright', 'Copyrights © 2020 Demolinks .All Rights Reserved', '2020-08-05 20:49:37', '0000-00-00 00:00:00', 'Copyrights © 2020 Demolinks .All Rights Reserved', '0', '1', '1', 'Copyright', 0, 0, 0),
(519, 'ADDRESS', 'Brickel Avenue Miami Florida 33024', '2020-08-05 19:14:05', '0000-00-00 00:00:00', 'Brickel Avenue Miami Florida 33024', '0', '1', '1', 'Address', 0, 0, 0),
(682, 'FACEBOOK', 'https://www.facebook.com', '2020-08-08 09:09:08', '0000-00-00 00:00:00', 'https://www.facebook.com', '0', '1', '1', 'Facebook', 0, 0, 0),
(1960, 'TWITTER', 'https://twitter.com/', '2020-05-04 15:59:42', '0000-00-00 00:00:00', 'https://twitter.com/', '0', '1', '1', 'Twitter', 0, 0, 0),
(1961, 'PINTEREST', 'https://www.pinterest.com/', '2020-05-01 15:17:01', '0000-00-00 00:00:00', 'https://www.pinterest.com/', '0', '1', '0', 'Pinterest', 0, 0, 0),
(1962, 'INSTAGRAM', 'https://www.instagram.com', '2020-05-01 15:17:05', '0000-00-00 00:00:00', 'https://www.instagram.com', '0', '1', '0', 'Instagram', 0, 0, 0),
(1963, 'LinkedIn', 'https://www.linkedin.com/', '2020-06-12 12:41:12', '0000-00-00 00:00:00', 'https://www.linkedin.com/', '0', '1', '1', 'Linkedin', 0, 0, 0),
(1964, 'Youtube', 'https://www.youtube.com', '2020-05-01 15:17:22', '0000-00-00 00:00:00', 'https://www.youtube.com', '0', '1', '0', 'Youtube', 0, 0, 0),
(1965, 'Whatsapp', '+123 - 456789', '2020-05-01 15:17:37', '0000-00-00 00:00:00', '+123 - 456789', '0', '1', '0', 'Whatsapp Number', 0, 0, 0),
(1966, 'GOOGLE MAP', 'https://www.google.com/maps/embed?pb=!1m17!1m8!1m3!1d1432.6587814383113!2d-70.217972!3d44.097439!3m2!1i1024!2i768!4f13.1!4m6!3e6!4m0!4m3!3m2!1d44.097439!2d-70.217972!5e0!3m2!1sen!2s!4v1576763046314!5m2!1sen!2s', '2020-03-02 11:56:05', '0000-00-00 00:00:00', 'GOOGLE MAP', '0', '1', '0', 'GOOGLE MAP', 0, 0, 0);

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

--
-- Table structure for table `newsletter`
--

CREATE TABLE `newsletter` (
  `id` int(11) NOT NULL,
  `newsletter_name` varchar(255) DEFAULT NULL,
  `newsletter_email` varchar(500) NOT NULL,
  `newsletter_message` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `is_active` int(11) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `orders_products`
--

CREATE TABLE `orders_products` (
  `order_products_id` int(11) NOT NULL,
  `orders_id` int(11) DEFAULT NULL,
  `order_products_product_id` int(11) DEFAULT NULL,
  `order_products_name` varchar(255) DEFAULT NULL,
  `order_products_price` float DEFAULT NULL,
  `order_products_qty` int(11) DEFAULT NULL,
  `mat_language` varchar(250) DEFAULT NULL,
  `shipping` varchar(250) DEFAULT NULL,
  `order_products_subtotal` float DEFAULT NULL,
  `is_deleted` int(11) DEFAULT 0,
  `user_id` int(11) DEFAULT 0,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `ref_id` varchar(250) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `page_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `created_at`, `updated_at`, `page_name`, `name`, `content`, `image`) VALUES
(1, '2020-08-08 02:50:58', '2020-08-08 02:52:09', 'Home', 'About Us', '<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.<br />\r\n<br />\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat.<br />\r\n<br />\r\nLorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua.</p>', 'uploads/pages/20200805.jpg');

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

--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(191) 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;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` (`id`, `name`, `label`, `created_at`, `updated_at`) VALUES
(1, 'All Permission', NULL, '2019-11-07 12:57:52', '2019-11-07 12:57:52'),
(2, 'add-blog', NULL, '2019-11-07 12:57:52', '2019-11-07 12:57:52'),
(3, 'view-blog', NULL, '2019-11-07 12:57:52', '2019-11-07 12:57:52'),
(4, 'edit-blog', NULL, '2019-11-07 12:57:52', '2019-11-07 12:57:52'),
(5, 'delete-blog', NULL, '2019-11-07 12:57:52', '2019-11-07 12:57:52'),
(6, 'add-blog-category', NULL, '2019-11-07 12:57:53', '2019-11-07 12:57:53'),
(7, 'view-blog-category', NULL, '2019-11-07 12:57:53', '2019-11-07 12:57:53'),
(8, 'edit-blog-category', NULL, '2019-11-07 12:57:53', '2019-11-07 12:57:53'),
(9, 'delete-blog-category', NULL, '2019-11-07 12:57:53', '2019-11-07 12:57:53'),
(10, 'add-testmonials', NULL, '2019-11-07 13:15:38', '2019-11-07 13:15:38'),
(11, 'edit-testmonials', NULL, '2019-11-07 13:15:38', '2019-11-07 13:15:38'),
(12, 'view-testmonials', NULL, '2019-11-07 13:15:38', '2019-11-07 13:15:38'),
(13, 'delete-testmonials', NULL, '2019-11-07 13:15:38', '2019-11-07 13:15:38'),
(14, 'add-staff', NULL, '2019-11-26 18:24:31', '2019-11-26 18:24:31'),
(15, 'edit-staff', NULL, '2019-11-26 18:24:31', '2019-11-26 18:24:31'),
(16, 'view-staff', NULL, '2019-11-26 18:24:31', '2019-11-26 18:24:31'),
(17, 'delete-staff', NULL, '2019-11-26 18:24:31', '2019-11-26 18:24:31'),
(18, 'add-teachers', NULL, '2019-11-26 19:39:43', '2019-11-26 19:39:43'),
(19, 'edit-teachers', NULL, '2019-11-26 19:39:43', '2019-11-26 19:39:43'),
(20, 'view-teachers', NULL, '2019-11-26 19:39:43', '2019-11-26 19:39:43'),
(21, 'delete-teachers', NULL, '2019-11-26 19:39:43', '2019-11-26 19:39:43'),
(22, 'add-teams', NULL, '2019-11-26 19:41:36', '2019-11-26 19:41:36'),
(23, 'edit-teams', NULL, '2019-11-26 19:41:36', '2019-11-26 19:41:36'),
(24, 'view-teams', NULL, '2019-11-26 19:41:36', '2019-11-26 19:41:36'),
(25, 'delete-teams', NULL, '2019-11-26 19:41:36', '2019-11-26 19:41:36'),
(26, 'add-students', NULL, '2019-11-26 19:42:58', '2019-11-26 19:42:58'),
(27, 'edit-students', NULL, '2019-11-26 19:42:58', '2019-11-26 19:42:58'),
(28, 'view-students', NULL, '2019-11-26 19:42:58', '2019-11-26 19:42:58'),
(29, 'delete-students', NULL, '2019-11-26 19:42:58', '2019-11-26 19:42:58'),
(30, 'add-cources', NULL, '2019-11-26 19:44:17', '2019-11-26 19:44:17'),
(31, 'edit-cources', NULL, '2019-11-26 19:44:17', '2019-11-26 19:44:17'),
(32, 'view-cources', NULL, '2019-11-26 19:44:17', '2019-11-26 19:44:17'),
(33, 'delete-cources', NULL, '2019-11-26 19:44:17', '2019-11-26 19:44:17'),
(34, 'add-class', NULL, '2019-11-26 19:46:27', '2019-11-26 19:46:27'),
(35, 'edit-class', NULL, '2019-11-26 19:46:27', '2019-11-26 19:46:27'),
(36, 'view-class', NULL, '2019-11-26 19:46:27', '2019-11-26 19:46:27'),
(37, 'delete-class', NULL, '2019-11-26 19:46:27', '2019-11-26 19:46:27'),
(38, 'add-test', NULL, '2019-11-26 19:48:16', '2019-11-26 19:48:16'),
(39, 'edit-test', NULL, '2019-11-26 19:48:16', '2019-11-26 19:48:16'),
(40, 'view-test', NULL, '2019-11-26 19:48:16', '2019-11-26 19:48:16'),
(41, 'delete-test', NULL, '2019-11-26 19:48:16', '2019-11-26 19:48:16'),
(42, 'add-fuck', NULL, '2019-11-26 19:50:31', '2019-11-26 19:50:31'),
(43, 'edit-fuck', NULL, '2019-11-26 19:50:31', '2019-11-26 19:50:31'),
(44, 'view-fuck', NULL, '2019-11-26 19:50:31', '2019-11-26 19:50:31'),
(45, 'delete-fuck', NULL, '2019-11-26 19:50:31', '2019-11-26 19:50:31'),
(46, 'add-basit', NULL, '2019-11-26 19:53:19', '2019-11-26 19:53:19'),
(47, 'edit-basit', NULL, '2019-11-26 19:53:19', '2019-11-26 19:53:19'),
(48, 'view-basit', NULL, '2019-11-26 19:53:19', '2019-11-26 19:53:19'),
(49, 'delete-basit', NULL, '2019-11-26 19:53:19', '2019-11-26 19:53:19'),
(50, 'add-teacher', NULL, '2019-11-28 20:59:45', '2019-11-28 20:59:45'),
(51, 'edit-teacher', NULL, '2019-11-28 20:59:45', '2019-11-28 20:59:45'),
(52, 'view-teacher', NULL, '2019-11-28 20:59:45', '2019-11-28 20:59:45'),
(53, 'delete-teacher', NULL, '2019-11-28 20:59:45', '2019-11-28 20:59:45'),
(54, 'add-course', NULL, '2019-12-02 10:36:36', '2019-12-02 10:36:36'),
(55, 'edit-course', NULL, '2019-12-02 10:36:36', '2019-12-02 10:36:36'),
(56, 'view-course', NULL, '2019-12-02 10:36:36', '2019-12-02 10:36:36'),
(57, 'delete-course', NULL, '2019-12-02 10:36:36', '2019-12-02 10:36:36'),
(58, 'add-banner', NULL, '2019-12-05 17:37:28', '2019-12-05 17:37:28'),
(59, 'edit-banner', NULL, '2019-12-05 17:37:28', '2019-12-05 17:37:28'),
(60, 'view-banner', NULL, '2019-12-05 17:37:28', '2019-12-05 17:37:28'),
(61, 'delete-banner', NULL, '2019-12-05 17:37:28', '2019-12-05 17:37:28'),
(62, 'add-accommodation', NULL, '2019-12-05 22:13:23', '2019-12-05 22:13:23'),
(63, 'edit-accommodation', NULL, '2019-12-05 22:13:23', '2019-12-05 22:13:23'),
(64, 'view-accommodation', NULL, '2019-12-05 22:13:23', '2019-12-05 22:13:23'),
(65, 'delete-accommodation', NULL, '2019-12-05 22:13:23', '2019-12-05 22:13:23'),
(66, 'add-student', NULL, '2019-12-05 22:20:19', '2019-12-05 22:20:19'),
(67, 'edit-student', NULL, '2019-12-05 22:20:19', '2019-12-05 22:20:19'),
(68, 'view-student', NULL, '2019-12-05 22:20:19', '2019-12-05 22:20:19'),
(69, 'delete-student', NULL, '2019-12-05 22:20:19', '2019-12-05 22:20:19'),
(70, 'add-discovery', NULL, '2019-12-05 22:31:54', '2019-12-05 22:31:54'),
(71, 'edit-discovery', NULL, '2019-12-05 22:31:54', '2019-12-05 22:31:54'),
(72, 'view-discovery', NULL, '2019-12-05 22:31:54', '2019-12-05 22:31:54'),
(73, 'delete-discovery', NULL, '2019-12-05 22:31:54', '2019-12-05 22:31:54'),
(74, 'add-journey', NULL, '2019-12-05 22:39:38', '2019-12-05 22:39:38'),
(75, 'edit-journey', NULL, '2019-12-05 22:39:38', '2019-12-05 22:39:38'),
(76, 'view-journey', NULL, '2019-12-05 22:39:38', '2019-12-05 22:39:38'),
(77, 'delete-journey', NULL, '2019-12-05 22:39:38', '2019-12-05 22:39:38'),
(78, 'add-fee', NULL, '2019-12-05 22:49:07', '2019-12-05 22:49:07'),
(79, 'edit-fee', NULL, '2019-12-05 22:49:08', '2019-12-05 22:49:08'),
(80, 'view-fee', NULL, '2019-12-05 22:49:08', '2019-12-05 22:49:08'),
(81, 'delete-fee', NULL, '2019-12-05 22:49:08', '2019-12-05 22:49:08'),
(82, 'add-gallery', NULL, '2019-12-05 22:50:45', '2019-12-05 22:50:45'),
(83, 'edit-gallery', NULL, '2019-12-05 22:50:45', '2019-12-05 22:50:45'),
(84, 'view-gallery', NULL, '2019-12-05 22:50:45', '2019-12-05 22:50:45'),
(85, 'delete-gallery', NULL, '2019-12-05 22:50:45', '2019-12-05 22:50:45'),
(86, 'add-event', NULL, '2019-12-11 16:39:58', '2019-12-11 16:39:58'),
(87, 'edit-event', NULL, '2019-12-11 16:39:58', '2019-12-11 16:39:58'),
(88, 'view-event', NULL, '2019-12-11 16:39:58', '2019-12-11 16:39:58'),
(89, 'delete-event', NULL, '2019-12-11 16:39:58', '2019-12-11 16:39:58'),
(90, 'add-programs', NULL, '2019-12-12 23:06:34', '2019-12-12 23:06:34'),
(91, 'edit-programs', NULL, '2019-12-12 23:06:34', '2019-12-12 23:06:34'),
(92, 'view-programs', NULL, '2019-12-12 23:06:34', '2019-12-12 23:06:34'),
(93, 'delete-programs', NULL, '2019-12-12 23:06:34', '2019-12-12 23:06:34'),
(94, 'add-program', NULL, '2019-12-12 23:15:51', '2019-12-12 23:15:51'),
(95, 'edit-program', NULL, '2019-12-12 23:15:51', '2019-12-12 23:15:51'),
(96, 'view-program', NULL, '2019-12-12 23:15:51', '2019-12-12 23:15:51'),
(97, 'delete-program', NULL, '2019-12-12 23:15:51', '2019-12-12 23:15:51'),
(98, 'add-about', NULL, '2019-12-13 00:32:57', '2019-12-13 00:32:57'),
(99, 'edit-about', NULL, '2019-12-13 00:32:57', '2019-12-13 00:32:57'),
(100, 'view-about', NULL, '2019-12-13 00:32:57', '2019-12-13 00:32:57'),
(101, 'delete-about', NULL, '2019-12-13 00:32:57', '2019-12-13 00:32:57'),
(102, 'add-product', NULL, '2019-12-27 00:08:42', '2019-12-27 00:08:42'),
(103, 'edit-product', NULL, '2019-12-27 00:08:42', '2019-12-27 00:08:42'),
(104, 'view-product', NULL, '2019-12-27 00:08:42', '2019-12-27 00:08:42'),
(105, 'delete-product', NULL, '2019-12-27 00:08:42', '2019-12-27 00:08:42'),
(106, 'add-package', NULL, '2020-01-17 05:30:22', '2020-01-17 05:34:41'),
(107, 'edit-package', NULL, '2020-01-17 05:30:25', '2020-01-17 05:34:46'),
(108, 'view-package', NULL, '2020-01-17 05:30:27', '2020-01-17 05:34:48'),
(109, 'delete-package', NULL, '2020-01-17 05:30:29', '2020-01-17 05:34:53'),
(118, 'add-group', NULL, '2020-01-17 06:28:39', '2020-01-17 06:28:39'),
(119, 'edit-group', NULL, '2020-01-17 06:28:39', '2020-01-17 06:28:39'),
(120, 'view-group', NULL, '2020-01-17 06:28:39', '2020-01-17 06:28:39'),
(121, 'delete-group', NULL, '2020-01-17 06:28:39', '2020-01-17 06:28:39'),
(122, 'add-team', NULL, '2020-01-22 07:17:15', '2020-01-22 07:17:15'),
(123, 'edit-team', NULL, '2020-01-22 07:17:15', '2020-01-22 07:17:15'),
(124, 'view-team', NULL, '2020-01-22 07:17:15', '2020-01-22 07:17:15'),
(125, 'delete-team', NULL, '2020-01-22 07:17:15', '2020-01-22 07:17:15'),
(126, 'add-category', NULL, '2020-01-22 07:21:34', '2020-01-22 07:21:34'),
(127, 'edit-category', NULL, '2020-01-22 07:21:34', '2020-01-22 07:21:34'),
(128, 'view-category', NULL, '2020-01-22 07:21:34', '2020-01-22 07:21:34'),
(129, 'delete-category', NULL, '2020-01-22 07:21:34', '2020-01-22 07:21:34'),
(130, 'add-coupon', NULL, '2020-02-07 02:26:34', '2020-02-07 02:26:34'),
(131, 'edit-coupon', NULL, '2020-02-07 02:26:34', '2020-02-07 02:26:34'),
(132, 'view-coupon', NULL, '2020-02-07 02:26:34', '2020-02-07 02:26:34'),
(133, 'delete-coupon', NULL, '2020-02-07 02:26:34', '2020-02-07 02:26:34'),
(134, 'add-lead', NULL, '2020-02-17 19:18:58', '2020-02-17 19:18:58'),
(135, 'edit-lead', NULL, '2020-02-17 19:18:58', '2020-02-17 19:18:58'),
(136, 'view-lead', NULL, '2020-02-17 19:18:58', '2020-02-17 19:18:58'),
(137, 'delete-lead', NULL, '2020-02-17 19:18:58', '2020-02-17 19:18:58'),
(138, 'add-service', NULL, '2020-03-03 05:31:20', '2020-03-03 05:31:20'),
(139, 'edit-service', NULL, '2020-03-03 05:31:20', '2020-03-03 05:31:20'),
(140, 'view-service', NULL, '2020-03-03 05:31:21', '2020-03-03 05:31:21'),
(141, 'delete-service', NULL, '2020-03-03 05:31:21', '2020-03-03 05:31:21'),
(142, 'add-video', NULL, '2020-03-04 05:03:38', '2020-03-04 05:03:38'),
(143, 'edit-video', NULL, '2020-03-04 05:03:38', '2020-03-04 05:03:38'),
(144, 'view-video', NULL, '2020-03-04 05:03:38', '2020-03-04 05:03:38'),
(145, 'delete-video', NULL, '2020-03-04 05:03:38', '2020-03-04 05:03:38'),
(146, 'add-partner', NULL, '2020-03-05 03:21:55', '2020-03-05 03:21:55'),
(147, 'edit-partner', NULL, '2020-03-05 03:21:55', '2020-03-05 03:21:55'),
(148, 'view-partner', NULL, '2020-03-05 03:21:55', '2020-03-05 03:21:55'),
(149, 'delete-partner', NULL, '2020-03-05 03:21:55', '2020-03-05 03:21:55'),
(150, 'add-agent', NULL, '2020-03-05 03:23:16', '2020-03-05 03:23:16'),
(151, 'edit-agent', NULL, '2020-03-05 03:23:16', '2020-03-05 03:23:16'),
(152, 'view-agent', NULL, '2020-03-05 03:23:16', '2020-03-05 03:23:16'),
(153, 'delete-agent', NULL, '2020-03-05 03:23:16', '2020-03-05 03:23:16'),
(154, 'add-immigration', NULL, '2020-03-05 03:26:19', '2020-03-05 03:26:19'),
(155, 'edit-immigration', NULL, '2020-03-05 03:26:19', '2020-03-05 03:26:19'),
(156, 'view-immigration', NULL, '2020-03-05 03:26:19', '2020-03-05 03:26:19'),
(157, 'delete-immigration', NULL, '2020-03-05 03:26:19', '2020-03-05 03:26:19'),
(158, 'add-phrase', NULL, '2020-03-14 07:25:30', '2020-03-14 07:25:30'),
(159, 'edit-phrase', NULL, '2020-03-14 07:25:30', '2020-03-14 07:25:30'),
(160, 'view-phrase', NULL, '2020-03-14 07:25:30', '2020-03-14 07:25:30'),
(161, 'delete-phrase', NULL, '2020-03-14 07:25:30', '2020-03-14 07:25:30'),
(162, 'add-post', NULL, '2020-03-18 04:10:00', '2020-03-18 04:10:00'),
(163, 'edit-post', NULL, '2020-03-18 04:10:01', '2020-03-18 04:10:01'),
(164, 'view-post', NULL, '2020-03-18 04:10:01', '2020-03-18 04:10:01'),
(165, 'delete-post', NULL, '2020-03-18 04:10:01', '2020-03-18 04:10:01'),
(166, 'add-faq', NULL, '2020-03-19 06:46:05', '2020-03-19 06:46:05'),
(167, 'edit-faq', NULL, '2020-03-19 06:46:05', '2020-03-19 06:46:05'),
(168, 'view-faq', NULL, '2020-03-19 06:46:05', '2020-03-19 06:46:05'),
(169, 'delete-faq', NULL, '2020-03-19 06:46:05', '2020-03-19 06:46:05'),
(170, 'add-size', NULL, '2020-03-23 04:36:56', '2020-03-23 04:36:56'),
(171, 'edit-size', NULL, '2020-03-23 04:36:56', '2020-03-23 04:36:56'),
(172, 'view-size', NULL, '2020-03-23 04:36:56', '2020-03-23 04:36:56'),
(173, 'delete-size', NULL, '2020-03-23 04:36:56', '2020-03-23 04:36:56'),
(174, 'add-color', NULL, '2020-03-23 04:46:59', '2020-03-23 04:46:59'),
(175, 'edit-color', NULL, '2020-03-23 04:46:59', '2020-03-23 04:46:59'),
(176, 'view-color', NULL, '2020-03-23 04:46:59', '2020-03-23 04:46:59'),
(177, 'delete-color', NULL, '2020-03-23 04:46:59', '2020-03-23 04:46:59'),
(178, 'add-review', NULL, '2020-04-03 17:58:42', '2020-04-03 17:58:42'),
(179, 'edit-review', NULL, '2020-04-03 17:58:42', '2020-04-03 17:58:42'),
(180, 'view-review', NULL, '2020-04-03 17:58:42', '2020-04-03 17:58:42'),
(181, 'delete-review', NULL, '2020-04-03 17:58:42', '2020-04-03 17:58:42'),
(182, 'add-yacht', NULL, '2020-04-07 04:13:05', '2020-04-07 04:13:05'),
(183, 'edit-yacht', NULL, '2020-04-07 04:13:05', '2020-04-07 04:13:05'),
(184, 'view-yacht', NULL, '2020-04-07 04:13:05', '2020-04-07 04:13:05'),
(185, 'delete-yacht', NULL, '2020-04-07 04:13:05', '2020-04-07 04:13:05'),
(186, 'add-type', NULL, '2020-04-07 04:24:12', '2020-04-07 04:24:12'),
(187, 'edit-type', NULL, '2020-04-07 04:24:12', '2020-04-07 04:24:12'),
(188, 'view-type', NULL, '2020-04-07 04:24:12', '2020-04-07 04:24:12'),
(189, 'delete-type', NULL, '2020-04-07 04:24:12', '2020-04-07 04:24:12'),
(190, 'add-location', NULL, '2020-04-07 05:04:21', '2020-04-07 05:04:21'),
(191, 'edit-location', NULL, '2020-04-07 05:04:21', '2020-04-07 05:04:21'),
(192, 'view-location', NULL, '2020-04-07 05:04:21', '2020-04-07 05:04:21'),
(193, 'delete-location', NULL, '2020-04-07 05:04:21', '2020-04-07 05:04:21'),
(194, 'add-builder', NULL, '2020-04-07 05:04:56', '2020-04-07 05:04:56'),
(195, 'edit-builder', NULL, '2020-04-07 05:04:56', '2020-04-07 05:04:56'),
(196, 'view-builder', NULL, '2020-04-07 05:04:56', '2020-04-07 05:04:56'),
(197, 'delete-builder', NULL, '2020-04-07 05:04:56', '2020-04-07 05:04:56'),
(198, 'add-lenght', NULL, '2020-04-07 05:07:04', '2020-04-07 05:07:04'),
(199, 'edit-lenght', NULL, '2020-04-07 05:07:04', '2020-04-07 05:07:04'),
(200, 'view-lenght', NULL, '2020-04-07 05:07:04', '2020-04-07 05:07:04'),
(201, 'delete-lenght', NULL, '2020-04-07 05:07:04', '2020-04-07 05:07:04'),
(202, 'add-testimonial', NULL, '2020-04-13 08:44:32', '2020-04-13 08:44:32'),
(203, 'edit-testimonial', NULL, '2020-04-13 08:44:32', '2020-04-13 08:44:32'),
(204, 'view-testimonial', NULL, '2020-04-13 08:44:32', '2020-04-13 08:44:32'),
(205, 'delete-testimonial', NULL, '2020-04-13 08:44:32', '2020-04-13 08:44:32'),
(206, 'add-page', NULL, '2020-04-13 08:45:57', '2020-04-13 08:45:57'),
(207, 'edit-page', NULL, '2020-04-13 08:45:57', '2020-04-13 08:45:57'),
(208, 'view-page', NULL, '2020-04-13 08:45:57', '2020-04-13 08:45:57'),
(209, 'delete-page', NULL, '2020-04-13 08:45:57', '2020-04-13 08:45:57'),
(210, 'add-language', NULL, '2020-04-13 10:32:43', '2020-04-13 10:32:43'),
(211, 'edit-language', NULL, '2020-04-13 10:32:43', '2020-04-13 10:32:43'),
(212, 'view-language', NULL, '2020-04-13 10:32:43', '2020-04-13 10:32:43'),
(213, 'delete-language', NULL, '2020-04-13 10:32:43', '2020-04-13 10:32:43'),
(214, 'add-content', NULL, '2020-04-17 13:29:05', '2020-04-17 13:29:05'),
(215, 'edit-content', NULL, '2020-04-17 13:29:05', '2020-04-17 13:29:05'),
(216, 'view-content', NULL, '2020-04-17 13:29:05', '2020-04-17 13:29:05'),
(217, 'delete-content', NULL, '2020-04-17 13:29:05', '2020-04-17 13:29:05'),
(218, 'add-protection', NULL, '2020-05-01 08:42:29', '2020-05-01 08:42:29'),
(219, 'edit-protection', NULL, '2020-05-01 08:42:29', '2020-05-01 08:42:29'),
(220, 'view-protection', NULL, '2020-05-01 08:42:29', '2020-05-01 08:42:29'),
(221, 'delete-protection', NULL, '2020-05-01 08:42:29', '2020-05-01 08:42:29'),
(222, 'add-insurance', NULL, '2020-05-01 08:44:26', '2020-05-01 08:44:26'),
(223, 'edit-insurance', NULL, '2020-05-01 08:44:26', '2020-05-01 08:44:26'),
(224, 'view-insurance', NULL, '2020-05-01 08:44:26', '2020-05-01 08:44:26'),
(225, 'delete-insurance', NULL, '2020-05-01 08:44:26', '2020-05-01 08:44:26'),
(226, 'add-member', NULL, '2020-05-20 22:58:31', '2020-05-20 22:58:31'),
(227, 'edit-member', NULL, '2020-05-20 22:58:31', '2020-05-20 22:58:31'),
(228, 'view-member', NULL, '2020-05-20 22:58:31', '2020-05-20 22:58:31'),
(229, 'delete-member', NULL, '2020-05-20 22:58:31', '2020-05-20 22:58:31'),
(230, 'add-what', NULL, '2020-06-02 07:25:49', '2020-06-02 07:25:49'),
(231, 'edit-what', NULL, '2020-06-02 07:25:49', '2020-06-02 07:25:49'),
(232, 'view-what', NULL, '2020-06-02 07:25:49', '2020-06-02 07:25:49'),
(233, 'delete-what', NULL, '2020-06-02 07:25:50', '2020-06-02 07:25:50'),
(234, 'add-resume', NULL, '2020-06-17 15:39:11', '2020-06-17 15:39:11'),
(235, 'edit-resume', NULL, '2020-06-17 15:39:11', '2020-06-17 15:39:11'),
(236, 'view-resume', NULL, '2020-06-17 15:39:11', '2020-06-17 15:39:11'),
(237, 'delete-resume', NULL, '2020-06-17 15:39:11', '2020-06-17 15:39:11'),
(238, 'add-consult', NULL, '2020-07-21 09:42:44', '2020-07-21 09:42:44'),
(239, 'edit-consult', NULL, '2020-07-21 09:42:44', '2020-07-21 09:42:44'),
(240, 'view-consult', NULL, '2020-07-21 09:42:44', '2020-07-21 09:42:44'),
(241, 'delete-consult', NULL, '2020-07-21 09:42:44', '2020-07-21 09:42:44');

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

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `permission_id` int(10) UNSIGNED NOT NULL,
  `role_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` (`permission_id`, `role_id`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 1),
(7, 1),
(8, 1),
(9, 1),
(10, 1),
(11, 1),
(12, 1),
(13, 1),
(14, 1),
(15, 1),
(16, 1),
(17, 1),
(18, 1),
(19, 1),
(20, 1),
(21, 1),
(22, 1),
(23, 1),
(24, 1),
(25, 1),
(26, 1),
(27, 1),
(28, 1),
(29, 1),
(30, 1),
(31, 1),
(32, 1),
(33, 1),
(34, 1),
(35, 1),
(36, 1),
(37, 1),
(38, 1),
(39, 1),
(40, 1),
(41, 1),
(42, 1),
(43, 1),
(44, 1),
(45, 1),
(46, 1),
(47, 1),
(48, 1),
(49, 1),
(50, 1),
(51, 1),
(52, 1),
(53, 1),
(54, 1),
(55, 1),
(56, 1),
(57, 1),
(58, 1),
(59, 1),
(60, 1),
(61, 1),
(62, 1),
(63, 1),
(64, 1),
(65, 1),
(66, 1),
(67, 1),
(68, 1),
(69, 1),
(70, 1),
(71, 1),
(72, 1),
(73, 1),
(74, 1),
(75, 1),
(76, 1),
(77, 1),
(78, 1),
(79, 1),
(80, 1),
(81, 1),
(82, 1),
(83, 1),
(84, 1),
(85, 1),
(86, 1),
(87, 1),
(88, 1),
(89, 1),
(90, 1),
(91, 1),
(92, 1),
(93, 1),
(94, 1),
(95, 1),
(96, 1),
(97, 1),
(98, 1),
(99, 1),
(100, 1),
(101, 1),
(102, 1),
(103, 1),
(104, 1),
(105, 1),
(106, 1),
(107, 1),
(108, 1),
(109, 1),
(118, 1),
(119, 1),
(120, 1),
(121, 1),
(122, 1),
(123, 1),
(124, 1),
(125, 1),
(126, 1),
(127, 1),
(128, 1),
(129, 1),
(130, 1),
(131, 1),
(132, 1),
(133, 1),
(134, 1),
(135, 1),
(136, 1),
(137, 1),
(138, 1),
(139, 1),
(140, 1),
(141, 1),
(142, 1),
(143, 1),
(144, 1),
(145, 1),
(146, 1),
(147, 1),
(148, 1),
(149, 1),
(150, 1),
(151, 1),
(152, 1),
(153, 1),
(154, 1),
(155, 1),
(156, 1),
(157, 1),
(158, 1),
(159, 1),
(160, 1),
(161, 1),
(162, 1),
(163, 1),
(164, 1),
(165, 1),
(166, 1),
(167, 1),
(168, 1),
(169, 1),
(170, 1),
(171, 1),
(172, 1),
(173, 1),
(174, 1),
(175, 1),
(176, 1),
(177, 1),
(178, 1),
(179, 1),
(180, 1),
(181, 1),
(182, 1),
(183, 1),
(184, 1),
(185, 1),
(186, 1),
(187, 1),
(188, 1),
(189, 1),
(190, 1),
(191, 1),
(192, 1),
(193, 1),
(194, 1),
(195, 1),
(196, 1),
(197, 1),
(198, 1),
(199, 1),
(200, 1),
(201, 1),
(202, 1),
(203, 1),
(204, 1),
(205, 1),
(206, 1),
(207, 1),
(208, 1),
(209, 1),
(210, 1),
(211, 1),
(212, 1),
(213, 1),
(214, 1),
(215, 1),
(216, 1),
(217, 1),
(218, 1),
(219, 1),
(220, 1),
(221, 1),
(222, 1),
(223, 1),
(224, 1),
(225, 1),
(226, 1),
(227, 1),
(228, 1),
(229, 1),
(230, 1),
(231, 1),
(232, 1),
(233, 1),
(234, 1),
(235, 1),
(236, 1),
(237, 1),
(238, 1),
(239, 1),
(240, 1),
(241, 1);

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

--
-- Table structure for table `products`
--

CREATE TABLE `products` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `product_title` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_title` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `category` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `language` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` decimal(10,2) DEFAULT NULL,
  `sar_price` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `qar_price` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `bhr_price` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `omr_price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `us_price` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `kwd_price` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `egp_price` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jod_price` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `images` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sku` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `product_imagess`
--

CREATE TABLE `product_imagess` (
  `id` int(11) NOT NULL,
  `image` varchar(100) NOT NULL,
  `product_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `profiles`
--

CREATE TABLE `profiles` (
  `id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED DEFAULT NULL,
  `bio` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `localisation` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` date DEFAULT NULL,
  `gender` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pic` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `postal` varchar(191) 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;

--
-- Dumping data for table `profiles`
--

INSERT INTO `profiles` (`id`, `user_id`, `bio`, `localisation`, `dob`, `gender`, `pic`, `country`, `state`, `city`, `address`, `postal`, `created_at`, `updated_at`) VALUES
(3, 1, 'Math Guru', 'male', '2017-09-13', NULL, 'yb6F7XO9HY.jpeg', 'United States', 'Alabama', 'Sipsey', '3083  Marcus Street, 3083  Marcus Street', '35768', '2019-12-10 19:00:46', '2020-08-06 09:06:56'),
(4, 2, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-05-30 16:59:58', '2020-05-30 16:59:58'),
(5, 3, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-05-30 19:05:58', '2020-05-30 19:05:58'),
(6, 4, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-01 14:58:08', '2020-06-01 14:58:08'),
(7, 5, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-06-24 03:39:20', '2020-06-24 03:39:20'),
(8, 6, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2020-07-03 08:22:52', '2020-07-03 08:22:52');

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

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(10) UNSIGNED NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `label` varchar(191) 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;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` (`id`, `name`, `label`, `created_at`, `updated_at`) VALUES
(1, 'admin', NULL, '2019-11-07 12:57:52', '2019-11-07 12:57:52'),
(2, 'user', NULL, '2019-11-07 12:57:52', '2019-11-07 12:57:52');

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

--
-- Table structure for table `role_user`
--

CREATE TABLE `role_user` (
  `role_id` int(10) UNSIGNED NOT NULL,
  `user_id` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_user`
--

INSERT INTO `role_user` (`role_id`, `user_id`) VALUES
(1, 1),
(2, 2),
(2, 3),
(2, 4),
(2, 5),
(2, 6);

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

--
-- Table structure for table `social_accounts`
--

CREATE TABLE `social_accounts` (
  `user_id` int(11) NOT NULL,
  `provider_user_id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `provider` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `id` int(10) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_name` varchar(250) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `verified` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `comments` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_comments` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`id`, `created_at`, `updated_at`, `name`, `arabic_name`, `verified`, `comments`, `arabic_comments`, `image`) VALUES
(1, '2020-05-01 09:29:53', '2020-08-08 03:54:04', 'Michael White', NULL, 'Redfox CEO', '<p>Lorem ipsum dolor sit amet, sit aperiam reprimique ad, sit illum laboramus appellantur in, ne everti percipit antiopam qui. Vim id lorem urbanitas, ea mei error noluisse. Vix habeo vituperata.</p>', NULL, 'uploads/testimonials/415db764fe0b9b6964bcda020d2bc27f_1596876844.jpg'),
(2, '2020-05-01 09:29:59', '2020-05-01 09:29:59', 'Michael White', NULL, 'Redfox CEO', '<p>Lorem ipsum dolor sit amet, sit aperiam reprimique ad, sit illum laboramus appellantur in, ne everti percipit antiopam qui. Vim id lorem urbanitas, ea mei error noluisse. Vix habeo vituperata.</p>', NULL, 'uploads/testimonials/tmls-icon2_1588343399.png'),
(3, '2020-05-01 09:30:04', '2020-05-01 09:30:04', 'Michael White', NULL, 'Redfox CEO', '<p>Lorem ipsum dolor sit amet, sit aperiam reprimique ad, sit illum laboramus appellantur in, ne everti percipit antiopam qui. Vim id lorem urbanitas, ea mei error noluisse. Vix habeo vituperata.</p>', NULL, 'uploads/testimonials/tmls-icon3_1588343404.png');

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

--
-- Table structure for table `wishlists`
--

CREATE TABLE `wishlists` (
  `id` int(11) NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT 0,
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Indexes for dumped tables
--

--
-- Indexes for table `activity_log`
--
ALTER TABLE `activity_log`
  ADD PRIMARY KEY (`id`),
  ADD KEY `activity_log_log_name_index` (`log_name`);

--
-- Indexes for table `banners`
--
ALTER TABLE `banners`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `blogs`
--
ALTER TABLE `blogs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cities`
--
ALTER TABLE `cities`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `countries`
--
ALTER TABLE `countries`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `imagetable`
--
ALTER TABLE `imagetable`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `inquiry`
--
ALTER TABLE `inquiry`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `m_flag`
--
ALTER TABLE `m_flag`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `newsletter`
--
ALTER TABLE `newsletter`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `orders_products`
--
ALTER TABLE `orders_products`
  ADD PRIMARY KEY (`order_products_id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permission_role`
--
ALTER TABLE `permission_role`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `permission_role_role_id_foreign` (`role_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_imagess`
--
ALTER TABLE `product_imagess`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `profiles`
--
ALTER TABLE `profiles`
  ADD PRIMARY KEY (`id`),
  ADD KEY `profiles_user_id_foreign` (`user_id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `role_user`
--
ALTER TABLE `role_user`
  ADD PRIMARY KEY (`role_id`,`user_id`),
  ADD KEY `role_user_user_id_foreign` (`user_id`);

--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `wishlists`
--
ALTER TABLE `wishlists`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `activity_log`
--
ALTER TABLE `activity_log`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=542;

--
-- AUTO_INCREMENT for table `banners`
--
ALTER TABLE `banners`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cities`
--
ALTER TABLE `cities`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48315;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=247;

--
-- AUTO_INCREMENT for table `imagetable`
--
ALTER TABLE `imagetable`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `inquiry`
--
ALTER TABLE `inquiry`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70;

--
-- AUTO_INCREMENT for table `m_flag`
--
ALTER TABLE `m_flag`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1967;

--
-- AUTO_INCREMENT for table `newsletter`
--
ALTER TABLE `newsletter`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `orders_products`
--
ALTER TABLE `orders_products`
  MODIFY `order_products_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=242;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_imagess`
--
ALTER TABLE `product_imagess`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `profiles`
--
ALTER TABLE `profiles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `wishlists`
--
ALTER TABLE `wishlists`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `profiles`
--
ALTER TABLE `profiles`
  ADD CONSTRAINT `profiles_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_user`
--
ALTER TABLE `role_user`
  ADD CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;
COMMIT;

