REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('VC', 'Saint Vincent and the Grenadines', 'Saint Vincent and the Grenadines', 'saint-vincent-and-the-grenadines', '+1-784', 'XCD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(6577818, 'VC', 'Saint Patrick', 1, 'saint-patrick'),
(6577819, 'VC', 'Saint George', 1, 'saint-george'),
(6577821, 'VC', 'Saint David', 1, 'saint-david'),
(6577822, 'VC', 'Saint Andrew', 1, 'saint-andrew'),
(6577892, 'VC', 'Grenadines', 1, 'grenadines'),
(6577934, 'VC', 'Charlotte', 1, 'charlotte');

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 
(6577788, 6577934, 'VC', 'Waterloo', 1, 'waterloo', 13.30901, -61.12362),
(6577791, 6577821, 'VC', 'Wallibou', 1, 'wallibou', 13.31151, -61.23221),
(6577792, 6577822, 'VC', 'Vermont', 1, 'vermont', 13.20423, -61.22466),
(6577795, 6577892, 'VC', 'Union', 1, 'union', 13.01422, -61.23211),
(6577796, 6577934, 'VC', 'Turema', 1, 'turema', 13.32114, -61.14441),
(6577798, 6577821, 'VC', 'Troumaka', 1, 'troumaka', 13.28011, -61.25762),
(6577802, 6577819, 'VC', 'Stubbs', 1, 'stubbs', 13.14802, -61.15891),
(6577803, 6577818, 'VC', 'Spring Village', 1, 'spring-village', 13.26212, -61.25068),
(6577805, 6577934, 'VC', 'South Rivers', 1, 'south-rivers', 13.24642, -61.14162),
(6577810, 6577934, 'VC', 'Sans Souci', 1, 'sans-souci', 13.22378, -61.13136),
(6577825, 6577818, 'VC', 'Rutland Vale', 1, 'rutland-vale', 13.20993, -61.26283),
(6577826, 6577821, 'VC', 'Rosehall', 1, 'rosehall', 13.27255, -61.24228),
(6577827, 6577821, 'VC', 'Richmond Vale', 1, 'richmond-vale', 13.28364, -61.23788),
(6577831, 6577821, 'VC', 'Richmond', 1, 'richmond', 13.30313, -61.22776),
(6577832, 6577934, 'VC', 'Richland Park', 1, 'richland-park', 13.2, -61.16667),
(6577833, 6577819, 'VC', 'Ribishi', 1, 'ribishi', 13.13333, -61.18333),
(6577837, 6577934, 'VC', 'Rabaka', 1, 'rabaka', 13.3, -61.15),
(6577839, 6577822, 'VC', 'Questelles', 1, 'questelles', 13.17619, -61.24893),
(6577844, 6577892, 'VC', 'Port Elizabeth', 1, 'port-elizabeth', 13.01102, -61.23548),
(6577855, 6577934, 'VC', 'Peruvian Vale', 1, 'peruvian-vale', 13.17711, -61.14356),
(6577856, 6577822, 'VC', 'Pembroke', 1, 'pembroke', 13.18242, -61.25131),
(6577857, 6577892, 'VC', 'Paget Farm', 1, 'paget-farm', 12.98777, -61.25371),
(6577859, 6577934, 'VC', 'Orange Hill', 1, 'orange-hill', 13.3136, -61.11999),
(6577861, 6577892, 'VC', 'Old Wall', 1, 'old-wall', 12.63854, -61.39431),
(6577862, 6577934, 'VC', 'O’Briens', 1, 'o-briens', 13.28472, -61.14879),
(6577864, 6577934, 'VC', 'North Union', 1, 'north-union', 13.21667, -61.13333),
(6577866, 6577934, 'VC', 'New Sandy Bay Village', 1, 'new-sandy-bay-village', 13.35113, -61.13072),
(6577869, 6577822, 'VC', 'Montrose', 1, 'montrose', 13.16667, -61.23333),
(6577873, 6577934, 'VC', 'Mesopotamia', 1, 'mesopotamia', 13.16667, -61.16667),
(6577877, 6577892, 'VC', 'Lovell Village', 1, 'lovell-village', 12.88352, -61.18786),
(6577879, 6577822, 'VC', 'Layou', 1, 'layou', 13.20175, -61.27014),
(6577887, 6577819, 'VC', 'Kingstown', 1, 'kingstown', 13.15527, -61.22742),
(6577890, 6577818, 'VC', 'Hermitage', 1, 'hermitage', 13.24955, -61.21685),
(6577893, 6577934, 'VC', 'Greiggs', 1, 'greiggs', 13.2, -61.15),
(6577900, 6577934, 'VC', 'Georgetown', 1, 'georgetown', 13.28054, -61.1185),
(6577903, 6577892, 'VC', 'Friendship', 1, 'friendship', 12.9923, -61.23934),
(6577904, 6577934, 'VC', 'Friendly', 1, 'friendly', 13.23811, -61.11717),
(6577905, 6577822, 'VC', 'Francois', 1, 'francois', 13.20586, -61.22024),
(6577906, 6577934, 'VC', 'Fancy', 1, 'fancy', 13.38132, -61.16854),
(6577910, 6577822, 'VC', 'Dubois', 1, 'dubois', 13.18333, -61.23333),
(6577911, 6577892, 'VC', 'Dovers', 1, 'dovers', 12.89186, -61.18521),
(6577915, 6577892, 'VC', 'Derrick', 1, 'derrick', 12.99245, -61.26204),
(6577923, 6577934, 'VC', 'Colonarie', 1, 'colonarie', 13.24041, -61.11641),
(6577925, 6577892, 'VC', 'Clifton', 1, 'clifton', 12.59706, -61.41739),
(6577926, 6577822, 'VC', 'Clare Valley', 1, 'clare-valley', 13.17959, -61.25657),
(6577928, 6577892, 'VC', 'Cheltenham', 1, 'cheltenham', 12.89253, -61.18404),
(6577929, 6577822, 'VC', 'Chauncey', 1, 'chauncey', 13.16667, -61.23333),
(6577933, 6577821, 'VC', 'Chateaubelair', 1, 'chateaubelair', 13.29069, -61.24043),
(6577937, 6577892, 'VC', 'Charlestown', 1, 'charlestown', 12.70042, -61.33062),
(6577938, 6577934, 'VC', 'Chapmans', 1, 'chapmans', 13.2862, -61.1188),
(6577942, 6577822, 'VC', 'Campden Park', 1, 'campden-park', 13.17455, -61.24447),
(6577944, 6577934, 'VC', 'Byera Village', 1, 'byera-village', 13.25636, -61.11954),
(6577952, 6577819, 'VC', 'Brighton Village', 1, 'brighton-village', 13.13572, -61.17477),
(6577955, 6577934, 'VC', 'Biabou', 1, 'biabou', 13.1943, -61.13904),
(6577959, 6577819, 'VC', 'Belmont', 1, 'belmont', 13.15, -61.18333),
(6577962, 6577818, 'VC', 'Barrouallie', 1, 'barrouallie', 13.23676, -61.27275),
(6577966, 6577892, 'VC', 'Ashton', 1, 'ashton', 12.59496, -61.43533),
(6577969, 6577819, 'VC', 'Arnos Vale', 1, 'arnos-vale', 13.14186, -61.20764),
(6577972, 6577934, 'VC', 'Adelphi', 1, 'adelphi', 13.18993, -61.13922),
(6748719, 6577822, 'VC', 'Edinboro', 1, 'edinboro', 13.15981, -61.23644),
(6748723, 6577822, 'VC', 'Liberty Lodge', 1, 'liberty-lodge', 13.16583, -61.23167),
(6748724, 6577822, 'VC', 'Redemption', 1, 'redemption', 13.16444, -61.22944),
(6748726, 6577819, 'VC', 'Kingstown Park', 1, 'kingstown-park', 13.15924, -61.23161),
(6748736, 6577819, 'VC', 'Greathead', 1, 'greathead', 13.14157, -61.22421),
(6748746, 6577819, 'VC', 'Calliaqua', 1, 'calliaqua', 13.12867, -61.19178),
(12072630, 6577822, 'VC', 'Buccament', 1, 'buccament', 13.19328, -61.26681),
(14281477, 6577892, 'VC', 'Belmont', 1, 'belmont', 13.00548, -61.23687);