DELETE FROM Civilization_CityNames WHERE CivilizationType = 'CIVILIZATION_ARABIA';
INSERT INTO Civilization_CityNames (CivilizationType, CityName)
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_BAGHDAD' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_MECCA' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_MEDINA' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_DAMASCUS' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_NAJRAN' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_KUFAH' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_BASRA' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_KHURASAN' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_ANJAR' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_FUSTAT' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_ADEN' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_YAMAMA' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_MUSCAT' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_MANSURA' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_BUKHARA' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_SHIRAZ' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_MERW' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_BALKH' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_MOSUL' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_AYDAB' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_BAYT_RAS' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_SUHAR' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_TAIF' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_HAMA' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_TABUK' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_SANAA' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_SHIHR' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_TRIPOLI' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_TUNIS' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_KAIROUAN' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_ALGIERS' UNION ALL
SELECT 'CIVILIZATION_ARABIA', 'TXT_KEY_CITY_NAME_ORAN';