REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('GU', 'Guam', 'Guam', 'guam', '+1-671', 'USD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(7038478, 'GU', 'Piti', 1, 'piti'),
(7038555, 'GU', 'Santa Rita', 1, 'santa-rita'),
(7038590, 'GU', 'Sinajana', 1, 'sinajana'),
(7038652, 'GU', 'Talofofo', 1, 'talofofo'),
(7038661, 'GU', 'Tamuning', 1, 'tamuning'),
(7038739, 'GU', 'Umatac', 1, 'umatac'),
(7038796, 'GU', 'Yigo', 1, 'yigo'),
(7038811, 'GU', 'Yona', 1, 'yona'),
(7043396, 'GU', 'Merizo', 1, 'merizo'),
(7043416, 'GU', 'Mangilao', 1, 'mangilao'),
(7043524, 'GU', 'Agana Heights', 1, 'agana-heights'),
(7043614, 'GU', 'Chalan Pago-Ordot', 1, 'chalan-pago-ordot'),
(7043691, 'GU', 'Asan', 1, 'asan'),
(7043725, 'GU', 'Agat', 1, 'agat'),
(7043877, 'GU', 'Dededo', 1, 'dededo'),
(7043885, 'GU', 'Barrigada', 1, 'barrigada'),
(7044019, 'GU', 'Hagatna', 1, 'hagatna'),
(7044041, 'GU', 'Inarajan', 1, 'inarajan'),
(7044148, 'GU', 'Mongmong-Toto-Maite', 1, 'mongmong-toto-maite');

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 
(7038473, 7038478, 'GU', 'Piti Village', 1, 'piti-village', 13.46256, 144.69331),
(7038554, 7038555, 'GU', 'Santa Rita Village', 1, 'santa-rita-village', 13.38608, 144.67226),
(7038588, 7038590, 'GU', 'Sinajana Village', 1, 'sinajana-village', 13.46334, 144.75406),
(7038647, 7038652, 'GU', 'Talofofo Village', 1, 'talofofo-village', 13.35513, 144.75835),
(7038659, 7038661, 'GU', 'Tamuning-Tumon-Harmon Village', 1, 'tamuning-tumon-harmon-village', 13.48773, 144.78138),
(7038733, 7038739, 'GU', 'Umatac Village', 1, 'umatac-village', 13.29843, 144.66314),
(7038794, 7038796, 'GU', 'Yigo Village', 1, 'yigo-village', 13.53605, 144.88855),
(7038809, 7038811, 'GU', 'Yona Village', 1, 'yona-village', 13.40974, 144.77697),
(7043399, 7043396, 'GU', 'Merizo Village', 1, 'merizo-village', 13.26584, 144.66908),
(7043499, 7044041, 'GU', 'Inarajan Village', 1, 'inarajan-village', 13.27363, 144.74845),
(7043525, 7043524, 'GU', 'Agana Heights Village', 1, 'agana-heights-village', 13.46559, 144.74795),
(7043615, 7043614, 'GU', 'Chalan Pago-Ordot Village', 1, 'chalan-pago-ordot-village', 13.44741, 144.75902),
(7043656, 7043885, 'GU', 'Barrigada Village', 1, 'barrigada-village', 13.46913, 144.79901),
(7043804, 7043725, 'GU', 'Agat Village', 1, 'agat-village', 13.38855, 144.65852),
(7043812, 7043691, 'GU', 'Asan-Maina Village', 1, 'asan-maina-village', 13.47215, 144.71654),
(7043909, 7043877, 'GU', 'Dededo Village', 1, 'dededo-village', 13.51777, 144.8391),
(7044012, 7044019, 'GU', 'Hagåtña', 1, 'hagatna', 13.47567, 144.74886),
(10268049, 7043416, 'GU', 'Mangilao Village', 1, 'mangilao-village', 13.44761, 144.80109),
(10873866, 7044148, 'GU', 'Mongmong-Toto-Maite Village', 1, 'mongmong-toto-maite-village', 13.46857, 144.78214),
(10874008, 7044019, 'GU', 'Hagåtña Village', 1, 'hagatna-village', 13.47279, 144.75802),
(10874631, 7038661, 'GU', 'Tamuning', 1, 'tamuning', 13.48754, 144.78143);