REPLACE INTO /*TABLE_PREFIX*/t_country (pk_c_code, s_name, s_name_native, s_slug, s_phone_code, s_currency) VALUES 
('CK', 'Cook Islands', 'Cook Islands', 'cook-islands', '682', 'NZD');

REPLACE INTO /*TABLE_PREFIX*/t_region (pk_i_id, fk_c_country_code, s_name, b_active, s_slug) VALUES 
(14695124, 'CK', 'Aitutaki', 1, 'aitutaki'),
(14695126, 'CK', 'Atiu', 1, 'atiu'),
(14695127, 'CK', 'Mangaia', 1, 'mangaia'),
(14695384, 'CK', 'Manihiki', 1, 'manihiki'),
(14695385, 'CK', 'Ma\'uke', 1, 'ma-uke'),
(14695386, 'CK', 'Mitiaro', 1, 'mitiaro'),
(14695387, 'CK', 'Palmerston', 1, 'palmerston'),
(14695388, 'CK', 'Penrhyn', 1, 'penrhyn'),
(14695389, 'CK', 'Pukapuka', 1, 'pukapuka'),
(14695390, 'CK', 'Rakahanga', 1, 'rakahanga'),
(14695425, 'CK', 'Rarotonga', 1, 'rarotonga');

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 
(7031126, 14695388, 'CK', 'Te Tautua', 1, 'te-tautua', -8.95873, -157.92621),
(7031141, 14695388, 'CK', 'Omoka', 1, 'omoka', -8.97982, -158.05307),
(7035447, 14695124, 'CK', 'Vaipae', 1, 'vaipae', -18.87102, -159.77818),
(7035463, 14695384, 'CK', 'Tukao', 1, 'tukao', -10.37518, -161.01018),
(7035494, 14695126, 'CK', 'Tengatangi Village', 1, 'tengatangi-village', -19.99347, -158.1147),
(7035509, 14695126, 'CK', 'Teenui Village', 1, 'teenui-village', -19.99273, -158.12265),
(7035523, 14695384, 'CK', 'Tauhunu', 1, 'tauhunu', -10.42361, -161.03398),
(7035530, 14695127, 'CK', 'Tamarua Village', 1, 'tamarua-village', -21.95045, -157.90799),
(7035549, 14695389, 'CK', 'Roto', 1, 'roto', -10.88333, -165.83333),
(7035622, 14695126, 'CK', 'Ngatiarua Village', 1, 'ngatiarua-village', -19.99813, -158.12058),
(7035623, 14695385, 'CK', 'Ngatiarua', 1, 'ngatiarua', -20.15278, -157.34333),
(7035637, 14695425, 'CK', 'Muri', 1, 'muri', -21.2565, -159.73205),
(7035655, 14695126, 'CK', 'Mapumai Village', 1, 'mapumai-village', -19.98909, -158.11942),
(7035694, 14695127, 'CK', 'Ivirua Village', 1, 'ivirua-village', -21.9177, -157.89527),
(7035715, 14695425, 'CK', 'Avarua', 1, 'avarua', -21.2075, -159.77545),
(7035725, 14695124, 'CK', 'Arutanga', 1, 'arutanga', -18.86509, -159.79808),
(7035729, 14695126, 'CK', 'Areora', 1, 'areora', -19.99926, -158.11609),
(7035730, 14695385, 'CK', 'Areora', 1, 'areora', -20.16333, -157.34444),
(7035755, 14695124, 'CK', 'Amuri', 1, 'amuri', -18.85195, -159.79293),
(7036432, 14695387, 'CK', 'Palmerston', 1, 'palmerston', -18.05525, -163.20884),
(7036467, 14695385, 'CK', 'Kimiangatau Village', 1, 'kimiangatau-village', -20.14367, -157.35648),
(7036480, 14695127, 'CK', 'Karanga Village', 1, 'karanga-village', -21.90784, -157.90212),
(7036498, 14695425, 'CK', 'Matavera', 1, 'matavera', -21.22444, -159.73333),
(7036511, 14695124, 'CK', 'Tautu', 1, 'tautu', -18.87437, -159.78537),
(7036522, 14695124, 'CK', 'Nikaupara', 1, 'nikaupara', -18.87116, -159.8007),
(11556382, 14695425, 'CK', 'Vaimaanga Tapere', 1, 'vaimaanga-tapere', -21.2571, -159.79168),
(14748274, 14695386, 'CK', 'Mangarei', 1, 'mangarei', -19.85961, -157.71801),
(14748275, 14695389, 'CK', 'Motu Koe', 1, 'motu-koe', -10.91229, -165.83682),
(14748276, 14695389, 'CK', 'Moto Kavata', 1, 'moto-kavata', -10.89261, -165.86772),
(14748278, 14695390, 'CK', 'Nivano', 1, 'nivano', -10.03174, -161.10176);