-- phpMyAdmin SQL Dump
-- version 4.9.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Nov 24, 2019 at 01:53 PM
-- Server version: 10.4.8-MariaDB
-- PHP Version: 7.3.10

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


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `tayar`
--

-- --------------------------------------------------------

--
-- Table structure for table `cities`
--

CREATE TABLE `cities` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `gov_id` bigint(20) UNSIGNED NOT NULL,
  `city_name_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cities`
--

INSERT INTO `cities` (`id`, `gov_id`, `city_name_en`, `city_name`, `created_at`, `updated_at`) VALUES
(1, 1, 'Cairo', 'القاهره', NULL, NULL),
(2, 2, 'Giza', 'الجيزة', NULL, NULL),
(3, 2, 'Sixth of October', 'السادس من أكتوبر', NULL, NULL),
(4, 2, 'Cheikh Zayed', 'الشيخ زايد\n', NULL, NULL),
(5, 2, 'Hawamdiyah', 'الحوامدية', NULL, NULL),
(6, 2, 'Al Badrasheen', 'البدرشين', NULL, NULL),
(7, 2, 'Saf', 'الصف', NULL, NULL),
(8, 2, 'Atfih', 'أطفيح', NULL, NULL),
(9, 2, 'Al Ayat', 'العياط', NULL, NULL),
(10, 2, 'Al-Bawaiti', 'الباويطي', NULL, NULL),
(11, 2, 'ManshiyetAl Qanater', 'منشأة القناطر', NULL, NULL),
(12, 2, 'Oaseem', 'أوسيم', NULL, NULL),
(13, 2, 'Kerdasa', 'كرداسة', NULL, NULL),
(14, 2, 'Abu Nomros', 'أبو النمرس', NULL, NULL),
(15, 2, 'Kafr Ghati', 'كفر غطاطي', NULL, NULL),
(16, 2, 'Manshiyet Al Bakari', 'منشأة البكاري', NULL, NULL),
(17, 3, 'Alexandria', 'الأسكندرية', NULL, NULL),
(18, 3, 'Burj Al Arab', 'برج العرب', NULL, NULL),
(19, 3, 'New Burj Al Arab', 'برج العرب الجديدة', NULL, NULL),
(20, 12, 'Banha', 'بنها', NULL, NULL),
(21, 12, 'Qalyub', 'قليوب', NULL, NULL),
(22, 12, 'Shubra Al Khaimah', 'شبرا الخيمة', NULL, NULL),
(23, 12, 'Al Qanater Charity', 'القناطر الخيرية', NULL, NULL),
(24, 12, 'Khanka', 'الخانكة', NULL, NULL),
(25, 12, 'Kafr Shukr', 'كفر شكر', NULL, NULL),
(26, 12, 'Tukh', 'طوخ', NULL, NULL),
(27, 12, 'Qaha', 'قها', NULL, NULL),
(28, 12, 'Obour', 'العبور', NULL, NULL),
(29, 12, 'Khosous', 'الخصوص', NULL, NULL),
(30, 12, 'Shibin Al Qanater', 'شبين القناطر', NULL, NULL),
(31, 6, 'Damanhour', 'دمنهور', NULL, NULL),
(32, 6, 'Kafr El Dawar', 'كفر الدوار', NULL, NULL),
(33, 6, 'Rashid', 'رشيد', NULL, NULL),
(34, 6, 'Edco', 'إدكو', NULL, NULL),
(35, 6, 'Abu al-Matamir', 'أبو المطامير', NULL, NULL),
(36, 6, 'Abu Homs', 'أبو حمص', NULL, NULL),
(37, 6, 'Delengat', 'الدلنجات', NULL, NULL),
(38, 6, 'Mahmoudiyah', 'المحمودية', NULL, NULL),
(39, 6, 'Rahmaniyah', 'الرحمانية', NULL, NULL),
(40, 6, 'Itai Baroud', 'إيتاي البارود', NULL, NULL),
(41, 6, 'Housh Eissa', 'حوش عيسى', NULL, NULL),
(42, 6, 'Shubrakhit', 'شبراخيت', NULL, NULL),
(43, 6, 'Kom Hamada', 'كوم حمادة', NULL, NULL),
(44, 6, 'Badr', 'بدر', NULL, NULL),
(45, 6, 'Wadi Natrun', 'وادي النطرون', NULL, NULL),
(46, 6, 'New Nubaria', 'النوبارية الجديدة', NULL, NULL),
(47, 23, 'Marsa Matrouh', 'مرسى مطروح', NULL, NULL),
(48, 23, 'El Hamam', 'الحمام', NULL, NULL),
(49, 23, 'Alamein', 'العلمين', NULL, NULL),
(50, 23, 'Dabaa', 'الضبعة', NULL, NULL),
(51, 23, 'Al-Nagila', 'النجيلة', NULL, NULL),
(52, 23, 'Sidi Brani', 'سيدي براني', NULL, NULL),
(53, 23, 'Salloum', 'السلوم', NULL, NULL),
(54, 23, 'Siwa', 'سيوة', NULL, NULL),
(55, 19, 'Damietta', 'دمياط', NULL, NULL),
(56, 19, 'New Damietta', 'دمياط الجديدة', NULL, NULL),
(57, 19, 'Ras El Bar', 'رأس البر', NULL, NULL),
(58, 19, 'Faraskour', 'فارسكور', NULL, NULL),
(59, 19, 'Zarqa', 'الزرقا', NULL, NULL),
(60, 19, 'alsaru', 'السرو', NULL, NULL),
(61, 19, 'alruwda', 'الروضة', NULL, NULL),
(62, 19, 'Kafr El-Batikh', 'كفر البطيخ', NULL, NULL),
(63, 19, 'Azbet Al Burg', 'عزبة البرج', NULL, NULL),
(64, 19, 'Meet Abou Ghalib', 'ميت أبو غالب', NULL, NULL),
(65, 19, 'Kafr Saad', 'كفر سعد', NULL, NULL),
(66, 4, 'Mansoura', 'المنصورة', NULL, NULL),
(67, 4, 'Talkha', 'طلخا', NULL, NULL),
(68, 4, 'Mitt Ghamr', 'ميت غمر', NULL, NULL),
(69, 4, 'Dekernes', 'دكرنس', NULL, NULL),
(70, 4, 'Aga', 'أجا', NULL, NULL),
(71, 4, 'Menia El Nasr', 'منية النصر', NULL, NULL),
(72, 4, 'Sinbillawin', 'السنبلاوين', NULL, NULL),
(73, 4, 'El Kurdi', 'الكردي', NULL, NULL),
(74, 4, 'Bani Ubaid', 'بني عبيد', NULL, NULL),
(75, 4, 'Al Manzala', 'المنزلة', NULL, NULL),
(76, 4, 'tami al\'amdid', 'تمي الأمديد', NULL, NULL),
(77, 4, 'aljamalia', 'الجمالية', NULL, NULL),
(78, 4, 'Sherbin', 'شربين', NULL, NULL),
(79, 4, 'Mataria', 'المطرية', NULL, NULL),
(80, 4, 'Belqas', 'بلقاس', NULL, NULL),
(81, 4, 'Meet Salsil', 'ميت سلسيل', NULL, NULL),
(82, 4, 'Gamasa', 'جمصة', NULL, NULL),
(83, 4, 'Mahalat Damana', 'محلة دمنة', NULL, NULL),
(84, 4, 'Nabroh', 'نبروه', NULL, NULL),
(85, 22, 'Kafr El Sheikh', 'كفر الشيخ', NULL, NULL),
(86, 22, 'Desouq', 'دسوق', NULL, NULL),
(87, 22, 'Fooh', 'فوه', NULL, NULL),
(88, 22, 'Metobas', 'مطوبس', NULL, NULL),
(89, 22, 'Burg Al Burullus', 'برج البرلس', NULL, NULL),
(90, 22, 'Baltim', 'بلطيم', NULL, NULL),
(91, 22, 'Masief Baltim', 'مصيف بلطيم', NULL, NULL),
(92, 22, 'Hamol', 'الحامول', NULL, NULL),
(93, 22, 'Bella', 'بيلا', NULL, NULL),
(94, 22, 'Riyadh', 'الرياض', NULL, NULL),
(95, 22, 'Sidi Salm', 'سيدي سالم', NULL, NULL),
(96, 22, 'Qellen', 'قلين', NULL, NULL),
(97, 22, 'Sidi Ghazi', 'سيدي غازي', NULL, NULL),
(98, 8, 'Tanta', 'طنطا', NULL, NULL),
(99, 8, 'Al Mahalla Al Kobra', 'المحلة الكبرى', NULL, NULL),
(100, 8, 'Kafr El Zayat', 'كفر الزيات', NULL, NULL),
(101, 8, 'Zefta', 'زفتى', NULL, NULL),
(102, 8, 'El Santa', 'السنطة', NULL, NULL),
(103, 8, 'Qutour', 'قطور', NULL, NULL),
(104, 8, 'Basion', 'بسيون', NULL, NULL),
(105, 8, 'Samannoud', 'سمنود', NULL, NULL),
(106, 10, 'Shbeen El Koom', 'شبين الكوم', NULL, NULL),
(107, 10, 'Sadat City', 'مدينة السادات', NULL, NULL),
(108, 10, 'Menouf', 'منوف', NULL, NULL),
(109, 10, 'Sars El-Layan', 'سرس الليان', NULL, NULL),
(110, 10, 'Ashmon', 'أشمون', NULL, NULL),
(111, 10, 'Al Bagor', 'الباجور', NULL, NULL),
(112, 10, 'Quesna', 'قويسنا', NULL, NULL),
(113, 10, 'Berkat El Saba', 'بركة السبع', NULL, NULL),
(114, 10, 'Tala', 'تلا', NULL, NULL),
(115, 10, 'Al Shohada', 'الشهداء', NULL, NULL),
(116, 20, 'Zagazig', 'الزقازيق', NULL, NULL),
(117, 20, 'Al Ashr Men Ramadan', 'العاشر من رمضان', NULL, NULL),
(118, 20, 'Minya Al Qamh', 'منيا القمح', NULL, NULL),
(119, 20, 'Belbeis', 'بلبيس', NULL, NULL),
(120, 20, 'Mashtoul El Souq', 'مشتول السوق', NULL, NULL),
(121, 20, 'Qenaiat', 'القنايات', NULL, NULL),
(122, 20, 'Abu Hammad', 'أبو حماد', NULL, NULL),
(123, 20, 'El Qurain', 'القرين', NULL, NULL),
(124, 20, 'Hehia', 'ههيا', NULL, NULL),
(125, 20, 'Abu Kabir', 'أبو كبير', NULL, NULL),
(126, 20, 'Faccus', 'فاقوس', NULL, NULL),
(127, 20, 'El Salihia El Gedida', 'الصالحية الجديدة', NULL, NULL),
(128, 20, 'Al Ibrahimiyah', 'الإبراهيمية', NULL, NULL),
(129, 20, 'Deirb Negm', 'ديرب نجم', NULL, NULL),
(130, 20, 'Kafr Saqr', 'كفر صقر', NULL, NULL),
(131, 20, 'Awlad Saqr', 'أولاد صقر', NULL, NULL),
(132, 20, 'Husseiniya', 'الحسينية', NULL, NULL),
(133, 20, 'san alhajar alqablia', 'صان الحجر القبلية', NULL, NULL),
(134, 20, 'Manshayat Abu Omar', 'منشأة أبو عمر', NULL, NULL),
(135, 18, 'PorSaid', 'بورسعيد', NULL, NULL),
(136, 18, 'PorFouad', 'بورفؤاد', NULL, NULL),
(137, 9, 'Ismailia', 'الإسماعيلية', NULL, NULL),
(138, 9, 'Fayed', 'فايد', NULL, NULL),
(139, 9, 'Qantara Sharq', 'القنطرة شرق', NULL, NULL),
(140, 9, 'Qantara Gharb', 'القنطرة غرب', NULL, NULL),
(141, 9, 'El Tal El Kabier', 'التل الكبير', NULL, NULL),
(142, 9, 'Abu Sawir', 'أبو صوير', NULL, NULL),
(143, 9, 'Kasasien El Gedida', 'القصاصين الجديدة', NULL, NULL),
(144, 14, 'Suez', 'السويس', NULL, NULL),
(145, 26, 'Arish', 'العريش', NULL, NULL),
(146, 26, 'Sheikh Zowaid', 'الشيخ زويد', NULL, NULL),
(147, 26, 'Nakhl', 'نخل', NULL, NULL),
(148, 26, 'Rafah', 'رفح', NULL, NULL),
(149, 26, 'Bir al-Abed', 'بئر العبد', NULL, NULL),
(150, 26, 'Al Hasana', 'الحسنة', NULL, NULL),
(151, 21, 'Al Toor', 'الطور', NULL, NULL),
(152, 21, 'Sharm El-Shaikh', 'شرم الشيخ', NULL, NULL),
(153, 21, 'Dahab', 'دهب', NULL, NULL),
(154, 21, 'Nuweiba', 'نويبع', NULL, NULL),
(155, 21, 'Taba', 'طابا', NULL, NULL),
(156, 21, 'Saint Catherine', 'سانت كاترين', NULL, NULL),
(157, 21, 'Abu Redis', 'أبو رديس', NULL, NULL),
(158, 21, 'Abu Zenaima', 'أبو زنيمة', NULL, NULL),
(159, 21, 'Ras Sidr', 'رأس سدر', NULL, NULL),
(160, 17, 'Bani Sweif', 'بني سويف', NULL, NULL),
(161, 17, 'Beni Suef El Gedida', 'بني سويف الجديدة', NULL, NULL),
(162, 17, 'Al Wasta', 'الواسطى', NULL, NULL),
(163, 17, 'Naser', 'ناصر', NULL, NULL),
(164, 17, 'Ehnasia', 'إهناسيا', NULL, NULL),
(165, 17, 'beba', 'ببا', NULL, NULL),
(166, 17, 'Fashn', 'الفشن', NULL, NULL),
(167, 17, 'Somasta', 'سمسطا', NULL, NULL),
(168, 7, 'Fayoum', 'الفيوم', NULL, NULL),
(169, 7, 'Fayoum El Gedida', 'الفيوم الجديدة', NULL, NULL),
(170, 7, 'Tamiya', 'طامية', NULL, NULL),
(171, 7, 'Snores', 'سنورس', NULL, NULL),
(172, 7, 'Etsa', 'إطسا', NULL, NULL),
(173, 7, 'Epschway', 'إبشواي', NULL, NULL),
(174, 7, 'Yusuf El Sediaq', 'يوسف الصديق', NULL, NULL),
(175, 11, 'Minya', 'المنيا', NULL, NULL),
(176, 11, 'Minya El Gedida', 'المنيا الجديدة', NULL, NULL),
(177, 11, 'El Adwa', 'العدوة', NULL, NULL),
(178, 11, 'Magagha', 'مغاغة', NULL, NULL),
(179, 11, 'Bani Mazar', 'بني مزار', NULL, NULL),
(180, 11, 'Mattay', 'مطاي', NULL, NULL),
(181, 11, 'Samalut', 'سمالوط', NULL, NULL),
(182, 11, 'Madinat El Fekria', 'المدينة الفكرية', NULL, NULL),
(183, 11, 'Meloy', 'ملوي', NULL, NULL),
(184, 11, 'Deir Mawas', 'دير مواس', NULL, NULL),
(185, 16, 'Assiut', 'أسيوط', NULL, NULL),
(186, 16, 'Assiut El Gedida', 'أسيوط الجديدة', NULL, NULL),
(187, 16, 'Dayrout', 'ديروط', NULL, NULL),
(188, 16, 'Manfalut', 'منفلوط', NULL, NULL),
(189, 16, 'Qusiya', 'القوصية', NULL, NULL),
(190, 16, 'Abnoub', 'أبنوب', NULL, NULL),
(191, 16, 'Abu Tig', 'أبو تيج', NULL, NULL),
(192, 16, 'El Ghanaim', 'الغنايم', NULL, NULL),
(193, 16, 'Sahel Selim', 'ساحل سليم', NULL, NULL),
(194, 16, 'El Badari', 'البداري', NULL, NULL),
(195, 16, 'Sidfa', 'صدفا', NULL, NULL),
(196, 13, 'El Kharga', 'الخارجة', NULL, NULL),
(197, 13, 'Paris', 'باريس', NULL, NULL),
(198, 13, 'Mout', 'موط', NULL, NULL),
(199, 13, 'Farafra', 'الفرافرة', NULL, NULL),
(200, 13, 'Balat', 'بلاط', NULL, NULL),
(201, 5, 'Hurghada', 'الغردقة', NULL, NULL),
(202, 5, 'Ras Ghareb', 'رأس غارب', NULL, NULL),
(203, 5, 'Safaga', 'سفاجا', NULL, NULL),
(204, 5, 'El Qusiar', 'القصير', NULL, NULL),
(205, 5, 'Marsa Alam', 'مرسى علم', NULL, NULL),
(206, 5, 'Shalatin', 'الشلاتين', NULL, NULL),
(207, 5, 'Halaib', 'حلايب', NULL, NULL),
(208, 27, 'Sohag', 'سوهاج', NULL, NULL),
(209, 27, 'Sohag El Gedida', 'سوهاج الجديدة', NULL, NULL),
(210, 27, 'Akhmeem', 'أخميم', NULL, NULL),
(211, 27, 'Akhmim El Gedida', 'أخميم الجديدة', NULL, NULL),
(212, 27, 'Albalina', 'البلينا', NULL, NULL),
(213, 27, 'El Maragha', 'المراغة', NULL, NULL),
(214, 27, 'almunsha\'a', 'المنشأة', NULL, NULL),
(215, 27, 'Dar AISalaam', 'دار السلام', NULL, NULL),
(216, 27, 'Gerga', 'جرجا', NULL, NULL),
(217, 27, 'Jahina Al Gharbia', 'جهينة الغربية', NULL, NULL),
(218, 27, 'Saqilatuh', 'ساقلته', NULL, NULL),
(219, 27, 'Tama', 'طما', NULL, NULL),
(220, 27, 'Tahta', 'طهطا', NULL, NULL),
(221, 25, 'Qena', 'قنا', NULL, NULL),
(222, 25, 'New Qena', 'قنا الجديدة', NULL, NULL),
(223, 25, 'Abu Tesht', 'أبو تشت', NULL, NULL),
(224, 25, 'Nag Hammadi', 'نجع حمادي', NULL, NULL),
(225, 25, 'Deshna', 'دشنا', NULL, NULL),
(226, 25, 'Alwaqf', 'الوقف', NULL, NULL),
(227, 25, 'Qaft', 'قفط', NULL, NULL),
(228, 25, 'Naqada', 'نقادة', NULL, NULL),
(229, 25, 'Farshout', 'فرشوط', NULL, NULL),
(230, 25, 'Quos', 'قوص', NULL, NULL),
(231, 24, 'Luxor', 'الأقصر', NULL, NULL),
(232, 24, 'New Luxor', 'الأقصر الجديدة', NULL, NULL),
(233, 24, 'Esna', 'إسنا', NULL, NULL),
(234, 24, 'New Tiba', 'طيبة الجديدة', NULL, NULL),
(235, 24, 'Al ziynia', 'الزينية', NULL, NULL),
(236, 24, 'Al Bayadieh', 'البياضية', NULL, NULL),
(237, 24, 'Al Qarna', 'القرنة', NULL, NULL),
(238, 24, 'Armant', 'أرمنت', NULL, NULL),
(239, 24, 'Al Tud', 'الطود', NULL, NULL),
(240, 15, 'Aswan', 'أسوان', NULL, NULL),
(241, 15, 'Aswan El Gedida', 'أسوان الجديدة', NULL, NULL),
(242, 15, 'Drau', 'دراو', NULL, NULL),
(243, 15, 'Kom Ombo', 'كوم أمبو', NULL, NULL),
(244, 15, 'Nasr Al Nuba', 'نصر النوبة', NULL, NULL),
(245, 15, 'Kalabsha', 'كلابشة', NULL, NULL),
(246, 15, 'Edfu', 'إدفو', NULL, NULL),
(247, 15, 'Al-Radisiyah', 'الرديسية', NULL, NULL),
(248, 15, 'Al Basilia', 'البصيلية', NULL, NULL),
(249, 15, 'Al Sibaeia', 'السباعية', NULL, NULL),
(250, 15, 'Abo Simbl Al Siyahia', 'ابوسمبل السياحية', NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `cities`
--
ALTER TABLE `cities`
  ADD PRIMARY KEY (`id`),
  ADD KEY `cities_gov_id_foreign` (`gov_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `cities`
--
ALTER TABLE `cities`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=251;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `cities`
--
ALTER TABLE `cities`
  ADD CONSTRAINT `cities_gov_id_foreign` FOREIGN KEY (`gov_id`) REFERENCES `governorates` (`id`) ON DELETE CASCADE;
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
