türkiye şehirleri

INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '01', 'Adana'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Adana');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '02', 'Adıyaman'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Adıyaman');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '03', 'Afyon'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Afyon');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '04', 'Ağrı'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Ağrı');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '05', 'Amasya'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Amasya');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '06', 'Ankara'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Ankara');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '07', 'Antalya'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Antalya');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '08', 'Artvin'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Artvin');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '09', 'Aydın'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Aydın');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '10', 'Balikesir'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Balikesir');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '11', 'Bilecik'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Bilecik');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '12', 'Bingöl'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Bingöl');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '13', 'Bitlis'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Bitlis');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '14', 'Bolu'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Bolu');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '15', 'Burdur'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Burdur');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '16', 'Bursa'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Bursa');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '17', 'Çanakkale'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Çanakkale');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '18', 'Çankırı'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Çankırı');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '19', 'Çorum'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Çorum');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '20', 'Denizli'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Denizli');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '21', 'Diyarbakir'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Diyarbakir');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '22', 'Edirne'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Edirne');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '23', 'Elazığ'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Elazığ');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '24', 'Erzincan'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Erzincan');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '25', 'Erzurum'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Erzurum');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '26', 'Eskişehir'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Eskişehir');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '27', 'Gaziantep'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Gaziantep');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '28', 'Giresun'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Giresun');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '29', 'Gümüşhane'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Gümüşhane');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '30', 'Hakkari'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Hakkari');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '31', 'Hatay'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Hatay');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '32', 'Isparta');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Isparta');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '33', 'İçel');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'İçel');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '34', 'İstanbul');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'İstanbul');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '35', 'İzmir');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'İzmir');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '36', 'Kars');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Kars');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '37', 'Kastamonu');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Kastamonu');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '38', 'Kayseri');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Kayseri');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '39', 'Kırklareli');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Kırklareli');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '40', 'Kırşehir');
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Kırşehir');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '41', 'Kocaeli'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Kocaeli');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '42', 'Konya'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Konya');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '43', 'Kütahya'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Kütahya');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '44', 'Malatya'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Malatya');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '45', 'Manisa'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Manisa');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '46', 'Kahramanmaraş'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Kahramanmaraş');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '47', 'Mardin'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Mardin');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '48', 'Muğla'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Muğla');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '49', 'Muş'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Muş');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '50', 'Nevşehir'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Nevşehir');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '51', 'Niğde'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Niğde');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '52', 'Ordu'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Ordu');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '53', 'Rize'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Rize');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '54', 'Sakarya'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Sakarya');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '55', 'Samsun'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Samsun');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '56', 'Siirt'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Siirt');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '57', 'Sinop'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Sinop');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '58', 'Sivas'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Sivas');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '59', 'Tekirdağ'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Tekirdağ');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '60', 'Tokat'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Tokat');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '61', 'Trabzon'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Trabzon');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '62', 'Tunceli'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Tunceli');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '63', 'Şanlıurfa'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Şanlıurfa');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '64', 'Uşak'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Uşak');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '65', 'Van'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Van');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '66', 'Yozgat'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Yozgat');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '67', 'Zonguldak'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Zonguldak');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '68', 'Aksaray'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Aksaray');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '69', 'Bayburt'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Bayburt');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '70', 'Karaman'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Karaman');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '71', 'Kırıkkale'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Kırıkkale');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '72', 'Batman'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Batman');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '73', 'Şırnak'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Şırnak');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '74', 'Bartın'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Bartın');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '75', 'Ardahan'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Ardahan');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '76', 'Iğdır'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Iğdır');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '77', 'Yalova'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Yalova');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '78', 'Karabük'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Karabük');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '79', 'Kilis'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Kilis');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '80', 'Osmaniye'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Osmaniye');
INSERT INTO `directory_country_region` (`country_id`, `code`, `default_name`) VALUES ('TR', '81', 'Düzce'); 
INSERT INTO `directory_country_region_name` (`locale`, `region_id`, `name`) VALUES ('tr_TR', LAST_INSERT_ID(), 'Düzce');