SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";



CREATE TABLE `cities` (
  `id` bigint(20) NOT NULL,
  `name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;


INSERT INTO `cities` (`id`, `name`) VALUES
(672, 'ADANA'),
(673, 'ADIYAMAN'),
(674, 'AFYONKARAHİSAR'),
(675, 'AĞRI'),
(676, 'AKSARAY'),
(677, 'AMASYA'),
(678, 'ANKARA'),
(679, 'ANTALYA'),
(680, 'ARDAHAN'),
(681, 'ARTVİN'),
(682, 'AYDIN'),
(683, 'BALIKESİR'),
(684, 'BARTIN'),
(685, 'BATMAN'),
(686, 'BAYBURT'),
(687, 'BİLECİK'),
(688, 'BİNGÖL'),
(689, 'BİTLİS'),
(690, 'BOLU'),
(691, 'BURDUR'),
(692, 'BURSA'),
(693, 'ÇANAKKALE'),
(694, 'ÇANKIRI'),
(695, 'ÇORUM'),
(696, 'DENİZLİ'),
(697, 'DİYARBAKIR'),
(698, 'DÜZCE'),
(699, 'EDİRNE'),
(700, 'ELAZIĞ'),
(701, 'ERZİNCAN'),
(702, 'ERZURUM'),
(703, 'ESKİŞEHİR'),
(704, 'GAZİANTEP'),
(705, 'GİRESUN'),
(706, 'GÜMÜŞHANE'),
(707, 'HAKKARİ'),
(708, 'HATAY'),
(709, 'IĞDIR'),
(710, 'ISPARTA'),
(711, 'İSTANBUL'),
(712, 'İZMİR'),
(713, 'KAHRAMANMARAŞ'),
(714, 'KARABÜK'),
(715, 'KARAMAN'),
(716, 'KARS'),
(717, 'KASTAMONU'),
(718, 'KAYSERİ'),
(719, 'KIRIKKALE'),
(720, 'KIRKLARELİ'),
(721, 'KIRŞEHİR'),
(722, 'KİLİS'),
(723, 'KOCAELİ'),
(724, 'KONYA'),
(725, 'KÜTAHYA'),
(726, 'MALATYA'),
(727, 'MANİSA'),
(728, 'MARDİN'),
(729, 'MERSİN'),
(730, 'MUĞLA'),
(731, 'MUŞ'),
(732, 'NEVŞEHİR'),
(733, 'NİĞDE'),
(734, 'ORDU'),
(735, 'OSMANİYE'),
(736, 'RİZE'),
(737, 'SAKARYA'),
(738, 'SAMSUN'),
(739, 'SİİRT'),
(740, 'SİNOP'),
(741, 'SİVAS'),
(742, 'ŞANLIURFA'),
(743, 'ŞIRNAK'),
(744, 'TEKİRDAĞ'),
(745, 'TOKAT'),
(746, 'TRABZON'),
(747, 'TUNCELİ'),
(748, 'UŞAK'),
(749, 'VAN'),
(750, 'YALOVA'),
(751, 'YOZGAT'),
(752, 'ZONGULDAK');

ALTER TABLE `cities`
  ADD PRIMARY KEY (`id`);

ALTER TABLE `cities`
  MODIFY `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=753;
COMMIT;


