create table zones
(
    id         int auto_increment
        primary key,
    country_id int                  not null,
    name       varchar(128)         not null,
    code       varchar(32)          not null,
    status     tinyint(1) default 1 not null
)
    charset = utf8;

INSERT INTO zones (id, country_id, name, code, status) VALUES (1, 215, 'ADANA', '01', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (2, 215, 'ADIYAMAN', '02', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (3, 215, 'AFYONKARAHİSAR', '03', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (4, 215, 'AĞRI', '04', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (5, 215, 'AMASYA', '05', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (6, 215, 'ANKARA', '06', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (7, 215, 'ANTALYA', '07', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (8, 215, 'ARTVİN', '08', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (9, 215, 'AYDIN', '09', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (10, 215, 'BALIKESİR', '10', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (11, 215, 'BİLECİK', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (12, 215, 'BİNGÖL', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (13, 215, 'BİTLİS', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (14, 215, 'BOLU', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (16, 215, 'BURSA', '16', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (17, 215, 'ÇANAKKALE', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (18, 215, 'ÇANKIRI', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (19, 215, 'ÇORUM', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (21, 215, 'DİYARBAKIR', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (22, 215, 'EDİRNE', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (23, 215, 'ELAZIĞ', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (24, 215, 'ERZİNCAN', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (25, 215, 'ERZURUM', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (26, 215, 'ESKİŞEHİR', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (27, 215, 'GAZİANTEP', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (28, 215, 'GİRESUN', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (29, 215, 'GÜMÜŞHANE', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (30, 215, 'HAKKARİ', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (31, 215, 'HATAY', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (32, 215, 'ISPARTA', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (33, 215, 'MERSİN', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (34, 215, 'İSTANBUL', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (35, 215, 'İZMİR', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (36, 215, 'KARS', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (37, 215, 'KASTAMONU', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (38, 215, 'KAYSERİ', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (39, 215, 'KIRKLARELİ', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (40, 215, 'KIRŞEHİR', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (41, 215, 'KOCAELİ', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (42, 215, 'KONYA', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (43, 215, 'KÜTAHYA', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (44, 215, 'MALATYA', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (45, 215, 'MANİSA', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (46, 215, 'KAHRAMANMARAŞ', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (47, 215, 'MARDİN', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (48, 215, 'MUĞLA', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (49, 215, 'MUŞ', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (50, 215, 'NEVŞEHİR', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (51, 215, 'NİĞDE', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (52, 215, 'ORDU', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (53, 215, 'RİZE', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (54, 215, 'SAKARYA', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (55, 215, 'SAMSUN', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (56, 215, 'SİİRT', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (57, 215, 'SİNOP', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (58, 215, 'SİVAS', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (59, 215, 'TEKİRDAĞ', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (60, 215, 'TOKAT', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (61, 215, 'TRABZON', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (62, 215, 'TUNCELİ', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (63, 215, 'ŞANLIURFA', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (64, 215, 'UŞAK', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (65, 215, 'VAN', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (66, 215, 'YOZGAT', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (67, 215, 'ZONGULDAK', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (68, 215, 'AKSARAY', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (69, 215, 'BAYBURT', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (70, 215, 'KARAMAN', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (71, 215, 'KIRIKKALE', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (72, 215, 'BATMAN', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (73, 215, 'ŞIRNAK', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (74, 215, 'BARTIN', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (75, 215, 'ARDAHAN', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (76, 215, 'IĞDIR', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (77, 215, 'YALOVA', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (78, 215, 'KARABÜK', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (79, 215, 'KİLİS', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (80, 215, 'OSMANİYE', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (81, 215, 'DÜZCE', '', 1);
INSERT INTO zones (id, country_id, name, code, status) VALUES (85, 215, 'DENİZLİ', '20', 1);
