REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('AG', 'Antigua and Barbuda', 'Antigua and Barbuda', 'antigua-and-barbuda', '+1-268', 'XCD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(6576015, 'AG', 'Saint Philip', 1, 'saint-philip'),
(6576016, 'AG', 'Saint Peter', 1, 'saint-peter'),
(6576017, 'AG', 'Saint Paul', 1, 'saint-paul'),
(6576018, 'AG', 'Saint Mary', 1, 'saint-mary'),
(6576023, 'AG', 'Saint John', 1, 'saint-john'),
(6576024, 'AG', 'Saint George', 1, 'saint-george'),
(6576037, 'AG', 'Redonda', 1, 'redonda'),
(6576390, 'AG', 'Barbuda', 1, 'barbuda');

REPLACE INTO /*TABLE_PREFIX*/t_city (pk_i_id, fk_i_region_id, fk_c_country_code, s_name, b_active, s_slug, d_coord_lat, d_coord_long) VALUES 
(6575930, 6576018, 'AG', 'Yorks', 1, 'yorks', 17.07897, -61.87497),
(6575933, 6576023, 'AG', 'Woods', 1, 'woods', 17.13526, -61.82585),
(6575938, 6576015, 'AG', 'Willoughby', 1, 'willoughby', 17.04051, -61.71994),
(6575940, 6576015, 'AG', 'Willikies', 1, 'willikies', 17.08684, -61.7093),
(6575950, 6576023, 'AG', 'Weatherills', 1, 'weatherills', 17.16514, -61.83534),
(6575951, 6576015, 'AG', 'Watsons', 1, 'watsons', 17.05451, -61.67789),
(6575952, 6576016, 'AG', 'Vernons', 1, 'vernons', 17.09192, -61.77132),
(6575956, 6576018, 'AG', 'Urlings', 1, 'urlings', 17.02687, -61.87618),
(6575957, 6576017, 'AG', 'Tyrells', 1, 'tyrells', 17.04828, -61.79516),
(6575965, 6576024, 'AG', 'The Grove', 1, 'the-grove', 17.1, -61.8),
(6575968, 6576016, 'AG', 'The Diamond', 1, 'the-diamond', 17.07759, -61.76047),
(6575971, 6576015, 'AG', 'The Brook', 1, 'the-brook', 17.05972, -61.68061),
(6575973, 6576017, 'AG', 'Table Hill Gordon', 1, 'table-hill-gordon', 17.04332, -61.77991),
(6575975, 6576017, 'AG', 'Swetes', 1, 'swetes', 17.05037, -61.80091),
(6575976, 6576023, 'AG', 'Sutherlands Development', 1, 'sutherlands-development', 17.12268, -61.8295),
(6575977, 6576023, 'AG', 'Sutherland', 1, 'sutherland', 17.11241, -61.88007),
(6576004, 6576024, 'AG', 'Sea View Farm', 1, 'sea-view-farm', 17.08809, -61.80281),
(6576005, 6576015, 'AG', 'Seatons', 1, 'seatons', 17.09435, -61.72552),
(6576006, 6576018, 'AG', 'Seaforths', 1, 'seaforths', 17.09376, -61.8643),
(6576008, 6576018, 'AG', 'Sawcolts', 1, 'sawcolts', 17.05038, -61.82014),
(6576009, 6576017, 'AG', 'Savannah', 1, 'savannah', 17.02083, -61.73871),
(6576014, 6576015, 'AG', 'Saint Philips', 1, 'saint-philips', 17.04628, -61.72373),
(6576019, 6576023, 'AG', 'Saint Lukes', 1, 'saint-lukes', 17.07877, -61.83437),
(6576020, 6576023, 'AG', 'Saint Johnston Village', 1, 'saint-johnston-village', 17.11861, -61.827),
(6576022, 6576023, 'AG', 'Saint John’s', 1, 'saint-john-s', 17.12096, -61.84329),
(6576034, 6576023, 'AG', 'Renfrew', 1, 'renfrew', 17.09023, -61.81071),
(6576039, 6576017, 'AG', 'Red Hill', 1, 'red-hill', 17.03111, -61.7416),
(6576050, 6576023, 'AG', 'Potters Village', 1, 'potters-village', 17.11337, -61.81962),
(6576057, 6576024, 'AG', 'Piggotts', 1, 'piggotts', 17.11667, -61.8),
(6576059, 6576017, 'AG', 'Piccadilly', 1, 'piccadilly', 17.03147, -61.75312),
(6576069, 6576024, 'AG', 'Paynters', 1, 'paynters', 17.11789, -61.80678),
(6576070, 6576017, 'AG', 'Pattersons Dwelling House', 1, 'pattersons-dwelling-house', 17.03333, -61.78333),
(6576071, 6576017, 'AG', 'Pattersons', 1, 'pattersons', 17.02415, -61.78848),
(6576072, 6576016, 'AG', 'Parrys', 1, 'parrys', 17.07388, -61.76477),
(6576074, 6576016, 'AG', 'Parham', 1, 'parham', 17.09682, -61.77046),
(6576075, 6576016, 'AG', 'Pares', 1, 'pares', 17.08493, -61.75445),
(6576076, 6576023, 'AG', 'Paradise View', 1, 'paradise-view', 17.14953, -61.84161),
(6576080, 6576024, 'AG', 'Osbourn', 1, 'osbourn', 17.12591, -61.8044),
(6576085, 6576018, 'AG', 'Old Road', 1, 'old-road', 17.01682, -61.83579),
(6576094, 6576024, 'AG', 'New Winthorpes', 1, 'new-winthorpes', 17.14575, -61.81344),
(6576095, 6576015, 'AG', 'Newfield', 1, 'newfield', 17.05687, -61.7254),
(6576102, 6576017, 'AG', 'Mount William', 1, 'mount-william', 17.03892, -61.79057),
(6576104, 6576017, 'AG', 'Morris Loobys', 1, 'morris-loobys', 17.04961, -61.75892),
(6576108, 6576015, 'AG', 'Montpelier', 1, 'montpelier', 17.05087, -61.71912),
(6576112, 6576015, 'AG', 'Mill Reef Club', 1, 'mill-reef-club', 17.03333, -61.68333),
(6576120, 6576017, 'AG', 'Matthews', 1, 'matthews', 17.05816, -61.79493),
(6576125, 6576015, 'AG', 'Mannings', 1, 'mannings', 17.03779, -61.6938),
(6576130, 6576015, 'AG', 'Lyons', 1, 'lyons', 17.05754, -61.73002),
(6576134, 6576015, 'AG', 'Long Lane', 1, 'long-lane', 17.06734, -61.742),
(6576139, 6576016, 'AG', 'Little Duers', 1, 'little-duers', 17.06927, -61.74761),
(6576144, 6576017, 'AG', 'Liberta', 1, 'liberta', 17.04141, -61.79052),
(6576158, 6576018, 'AG', 'Johnsons Point', 1, 'johnsons-point', 17.02985, -61.88885),
(6576159, 6576018, 'AG', 'John Hughes', 1, 'john-hughes', 17.04328, -61.8222),
(6576160, 6576015, 'AG', 'Jennings', 1, 'jennings', 17.07779, -61.86582),
(6576184, 6576023, 'AG', 'Herberts', 1, 'herberts', 17.094, -61.81403),
(6576190, 6576018, 'AG', 'Harveys', 1, 'harveys', 17.03333, -61.86667),
(6576194, 6576023, 'AG', 'Hamiltons', 1, 'hamiltons', 17.05, -61.83333),
(6576197, 6576024, 'AG', 'Gunthorpes', 1, 'gunthorpes', 17.10975, -61.79989),
(6576214, 6576023, 'AG', 'Grays Hill', 1, 'grays-hill', 17.10579, -61.84737),
(6576215, 6576015, 'AG', 'Grays', 1, 'grays', 17.07853, -61.70721),
(6576218, 6576015, 'AG', 'Grants', 1, 'grants', 17.08333, -61.71667),
(6576219, 6576023, 'AG', 'Golden Grove', 1, 'golden-grove', 17.08903, -61.84685),
(6576225, 6576015, 'AG', 'Glanvilles', 1, 'glanvilles', 17.0858, -61.7252),
(6576226, 6576016, 'AG', 'Gilberts', 1, 'gilberts', 17.08905, -61.73903),
(6576236, 6576015, 'AG', 'Freetown', 1, 'freetown', 17.04791, -61.70332),
(6576238, 6576016, 'AG', 'Freemans', 1, 'freemans', 17.07917, -61.7857),
(6576245, 6576023, 'AG', 'Five Islands Village', 1, 'five-islands-village', 17.11944, -61.88388),
(6576249, 6576024, 'AG', 'Fitches Creek', 1, 'fitches-creek', 17.12419, -61.7949),
(6576256, 6576015, 'AG', 'Ffryes', 1, 'ffryes', 17.05509, -61.73143),
(6576260, 6576017, 'AG', 'Falmouth', 1, 'falmouth', 17.02741, -61.78136),
(6576264, 6576017, 'AG', 'English Harbour Town', 1, 'english-harbour-town', 17.01637, -61.7674),
(6576266, 6576023, 'AG', 'Emanuel', 1, 'emanuel', 17.07217, -61.83731),
(6576267, 6576018, 'AG', 'Ebenezer', 1, 'ebenezer', 17.08285, -61.85895),
(6576272, 6576390, 'AG', 'Dulcina', 1, 'dulcina', 17.59367, -61.82697),
(6576281, 6576017, 'AG', 'Delaps', 1, 'delaps', 17.06046, -61.75179),
(6576290, 6576023, 'AG', 'Crosbies', 1, 'crosbies', 17.16569, -61.82367),
(6576291, 6576023, 'AG', 'Creekside', 1, 'creekside', 17.07902, -61.85646),
(6576299, 6576018, 'AG', 'Crab Hill', 1, 'crab-hill', 17.03437, -61.89114),
(6576305, 6576015, 'AG', 'Comfort Hall', 1, 'comfort-hall', 17.08133, -61.71415),
(6576307, 6576015, 'AG', 'Collins', 1, 'collins', 17.07615, -61.73322),
(6576311, 6576390, 'AG', 'Codrington', 1, 'codrington', 17.63333, -61.83333),
(6576318, 6576016, 'AG', 'Cochranes', 1, 'cochranes', 17.08334, -61.76691),
(6576319, 6576017, 'AG', 'Cobbs Cross', 1, 'cobbs-cross', 17.02402, -61.76599),
(6576324, 6576023, 'AG', 'Clare Hall', 1, 'clare-hall', 17.11667, -61.81667),
(6576328, 6576017, 'AG', 'Christian Hill', 1, 'christian-hill', 17.03532, -61.75136),
(6576337, 6576018, 'AG', 'Cedar Hall', 1, 'cedar-hall', 17.0773, -61.85763),
(6576338, 6576023, 'AG', 'Cedar Grove', 1, 'cedar-grove', 17.16225, -61.8178),
(6576341, 6576023, 'AG', 'Cassada Gardens', 1, 'cassada-gardens', 17.12824, -61.81148),
(6576344, 6576024, 'AG', 'Carlisle', 1, 'carlisle', 17.13226, -61.80356),
(6576353, 6576023, 'AG', 'Buckleys', 1, 'buckleys', 17.07221, -61.81337),
(6576355, 6576023, 'AG', 'Branns Hamlet', 1, 'branns-hamlet', 17.10366, -61.83612),
(6576358, 6576023, 'AG', 'Boon House', 1, 'boon-house', 17.16667, -61.83333),
(6576361, 6576018, 'AG', 'Bolands', 1, 'bolands', 17.06565, -61.87466),
(6576364, 6576018, 'AG', 'Blubber Valley', 1, 'blubber-valley', 17.06651, -61.86419),
(6576369, 6576018, 'AG', 'Bishops', 1, 'bishops', 17.04523, -61.81557),
(6576376, 6576016, 'AG', 'Betty’s Hope', 1, 'betty-s-hope', 17.08119, -61.74479),
(6576377, 6576017, 'AG', 'Bethesda', 1, 'bethesda', 17.04331, -61.75083),
(6576378, 6576023, 'AG', 'Bendals', 1, 'bendals', 17.06807, -61.83604),
(6576379, 6576023, 'AG', 'Belmont', 1, 'belmont', 17.09964, -61.82612),
(6576380, 6576023, 'AG', 'Bellevue Heights', 1, 'bellevue-heights', 17.0922, -61.82302),
(6576382, 6576017, 'AG', 'Bats Cave', 1, 'bats-cave', 17.01667, -61.75),
(6576386, 6576024, 'AG', 'Barnes Hill', 1, 'barnes-hill', 17.14227, -61.80788),
(6576397, 6576016, 'AG', 'All Saints', 1, 'all-saints', 17.06671, -61.79303),
(6576398, 6576023, 'AG', 'Aberdeen', 1, 'aberdeen', 17.06994, -61.80977),
(9544535, 6576018, 'AG', 'Guadeloupe', 1, 'guadeloupe', 16.99597, -62.06764),
(9695166, 6576018, 'AG', 'Jolly Harbour', 1, 'jolly-harbour', 17.06622, -61.88646),
(10290268, 6576016, 'AG', 'Freemans Village', 1, 'freemans-village', 17.08021, -61.79273),
(14881331, 6576023, 'AG', 'Soldier', 1, 'soldier', 17.16859, -61.83619),
(14881343, 6576023, 'AG', 'Side Hill', 1, 'side-hill', 17.11817, -61.86245),
(14881352, 6576018, 'AG', 'Roses', 1, 'roses', 17.05735, -61.87432),
(14881353, 6576018, 'AG', 'Tottenham Park', 1, 'tottenham-park', 17.06155, -61.87267),
(14881355, 6576018, 'AG', 'Willocks', 1, 'willocks', 17.04884, -61.87584),
(14881392, 6576023, 'AG', 'Friars Hill', 1, 'friars-hill', 17.14634, -61.83406),
(14881393, 6576023, 'AG', 'Black Rock', 1, 'black-rock', 17.16912, -61.82741),
(14881395, 6576023, 'AG', 'Royals', 1, 'royals', 17.16329, -61.81057),
(14881399, 6576024, 'AG', 'Weirs', 1, 'weirs', 17.11643, -61.7909),
(14881402, 6576016, 'AG', 'Twenty Hill', 1, 'twenty-hill', 17.10236, -61.76978),
(14881416, 6576016, 'AG', 'Mount Joy', 1, 'mount-joy', 17.0874, -61.77274),
(14881417, 6576015, 'AG', 'Elliots', 1, 'elliots', 17.08088, -61.7375),
(14881421, 6576017, 'AG', 'Bodkins', 1, 'bodkins', 17.04947, -61.76567),
(14881424, 6576017, 'AG', 'Richmond', 1, 'richmond', 17.03937, -61.80155),
(14881425, 6576017, 'AG', 'Green Hill', 1, 'green-hill', 17.03821, -61.78555),
(14881436, 6576017, 'AG', 'Guinea Bush', 1, 'guinea-bush', 17.03123, -61.77185),
(14881741, 6576015, 'AG', 'Browns', 1, 'browns', 17.06781, -61.69812),
(14881744, 6576017, 'AG', 'Follys', 1, 'follys', 17.05105, -61.80882),
(14881747, 6576023, 'AG', 'Martin Hill', 1, 'martin-hill', 17.07291, -61.81704),
(14882961, 6576023, 'AG', 'Yepton', 1, 'yepton', 17.12493, -61.87235),
(14882969, 6576016, 'AG', 'Jonas', 1, 'jonas', 17.07413, -61.79086),
(14882970, 6576024, 'AG', 'Bellevue', 1, 'bellevue', 17.08004, -61.79373),
(14882972, 6576016, 'AG', 'Cedar Hill', 1, 'cedar-hill', 17.10506, -61.78067),
(14883142, 6576023, 'AG', 'Hattons', 1, 'hattons', 17.11654, -61.85302),
(14883146, 6576018, 'AG', 'Picarts', 1, 'picarts', 17.04214, -61.88753);