-- Dumping structure for table supmti_db_preinscription.ville
DROP TABLE IF EXISTS `ville`;
CREATE TABLE IF NOT EXISTS `ville` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `nom_fr` varchar(50) NOT NULL,
  `nom_ar` varchar(50) DEFAULT NULL,
  `pays_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=405 DEFAULT CHARSET=utf8mb4;

-- Dumping data for table supmti_db_preinscription.ville: ~394 rows (approximately)
INSERT INTO `ville` (`id`, `nom_fr`, `nom_ar`, `pays_id`) VALUES
	(1, 'Aïn Harrouda', NULL, 144),
	(2, 'Ben Yakhlef', NULL, 144),
	(3, 'Bouskoura', NULL, 144),
	(4, 'Casablanca', NULL, 144),
	(5, 'Médiouna', NULL, 144),
	(6, 'Mohammadia', NULL, 144),
	(7, 'Tit Mellil', NULL, 144),
	(8, 'Ben Yakhlef', NULL, 144),
	(9, 'Bejaâd', NULL, 144),
	(10, 'Ben Ahmed', NULL, 144),
	(11, 'Benslimane', NULL, 144),
	(12, 'Berrechid', NULL, 144),
	(13, 'Boujniba', NULL, 144),
	(14, 'Boulanouare', NULL, 144),
	(15, 'Bouznika', NULL, 144),
	(16, 'Deroua', NULL, 144),
	(17, 'El Borouj', NULL, 144),
	(18, 'El Gara', NULL, 144),
	(19, 'Guisser', NULL, 144),
	(20, 'Hattane', NULL, 144),
	(21, 'Khouribga', NULL, 144),
	(22, 'Loulad', NULL, 144),
	(23, 'Oued Zem', NULL, 144),
	(24, 'Oulad Abbou', NULL, 144),
	(25, 'Oulad H\'Riz Sahel', NULL, 144),
	(26, 'Oulad M\'rah', NULL, 144),
	(27, 'Oulad Saïd', NULL, 144),
	(28, 'Oulad Sidi Ben Daoud', NULL, 144),
	(29, 'Ras El Aïn', NULL, 144),
	(30, 'Settat', NULL, 144),
	(31, 'Sidi Rahhal Chataï', NULL, 144),
	(32, 'Soualem', NULL, 144),
	(33, 'Azemmour', NULL, 144),
	(34, 'Bir Jdid', NULL, 144),
	(35, 'Bouguedra', NULL, 144),
	(36, 'Echemmaia', NULL, 144),
	(37, 'El Jadida', NULL, 144),
	(38, 'Hrara', NULL, 144),
	(39, 'Ighoud', NULL, 144),
	(40, 'Jamâat Shaim', NULL, 144),
	(41, 'Jorf Lasfar', NULL, 144),
	(42, 'Khemis Zemamra', NULL, 144),
	(43, 'Laaounate', NULL, 144),
	(44, 'Moulay Abdallah', NULL, 144),
	(45, 'Oualidia', NULL, 144),
	(46, 'Oulad Amrane', NULL, 144),
	(47, 'Oulad Frej', NULL, 144),
	(48, 'Oulad Ghadbane', NULL, 144),
	(49, 'Safi', NULL, 144),
	(50, 'Sebt El Maârif', NULL, 144),
	(51, 'Sebt Gzoula', NULL, 144),
	(52, 'Sidi Ahmed', NULL, 144),
	(53, 'Sidi Ali Ban Hamdouche', NULL, 144),
	(54, 'Sidi Bennour', NULL, 144),
	(55, 'Sidi Bouzid', NULL, 144),
	(56, 'Sidi Smaïl', NULL, 144),
	(57, 'Youssoufia', NULL, 144),
	(58, 'Fès', NULL, 144),
	(59, 'Aïn Cheggag', NULL, 144),
	(60, 'Bhalil', NULL, 144),
	(61, 'Boulemane', NULL, 144),
	(62, 'El Menzel', NULL, 144),
	(63, 'Guigou', NULL, 144),
	(64, 'Imouzzer Kandar', NULL, 144),
	(65, 'Imouzzer Marmoucha', NULL, 144),
	(66, 'Missour', NULL, 144),
	(67, 'Moulay Yaâcoub', NULL, 144),
	(68, 'Ouled Tayeb', NULL, 144),
	(69, 'Outat El Haj', NULL, 144),
	(70, 'Ribate El Kheir', NULL, 144),
	(71, 'Séfrou', NULL, 144),
	(72, 'Skhinate', NULL, 144),
	(73, 'Tafajight', NULL, 144),
	(74, 'Arbaoua', NULL, 144),
	(75, 'Aïn Dorij', NULL, 144),
	(76, 'Dar Gueddari', NULL, 144),
	(77, 'Had Kourt', NULL, 144),
	(78, 'Jorf El Melha', NULL, 144),
	(79, 'Kénitra', NULL, 144),
	(80, 'Khenichet', NULL, 144),
	(81, 'Lalla Mimouna', NULL, 144),
	(82, 'Mechra Bel Ksiri', NULL, 144),
	(83, 'Mehdia', NULL, 144),
	(84, 'Moulay Bousselham', NULL, 144),
	(85, 'Sidi Allal Tazi', NULL, 144),
	(86, 'Sidi Kacem', NULL, 144),
	(87, 'Sidi Slimane', NULL, 144),
	(88, 'Sidi Taibi', NULL, 144),
	(89, 'Sidi Yahya El Gharb', NULL, 144),
	(90, 'Souk El Arbaa', NULL, 144),
	(91, 'Akka', NULL, 144),
	(92, 'Assa', NULL, 144),
	(93, 'Bouizakarne', NULL, 144),
	(94, 'El Ouatia', NULL, 144),
	(95, 'Es-Semara', NULL, 144),
	(96, 'Fam El Hisn', NULL, 144),
	(97, 'Foum Zguid', NULL, 144),
	(98, 'Guelmim', NULL, 144),
	(99, 'Taghjijt', NULL, 144),
	(100, 'Tan-Tan', NULL, 144),
	(101, 'Tata', NULL, 144),
	(102, 'Zag', NULL, 144),
	(103, 'Marrakech', NULL, 144),
	(104, 'Ait Daoud', NULL, 144),
	(115, 'Amizmiz', NULL, 144),
	(116, 'Assahrij', NULL, 144),
	(117, 'Aït Ourir', NULL, 144),
	(118, 'Ben Guerir', NULL, 144),
	(119, 'Chichaoua', NULL, 144),
	(120, 'El Hanchane', NULL, 144),
	(121, 'El Kelaâ des Sraghna', NULL, 144),
	(122, 'Essaouira', NULL, 144),
	(123, 'Fraïta', NULL, 144),
	(124, 'Ghmate', NULL, 144),
	(125, 'Ighounane', NULL, 144),
	(126, 'Imintanoute', NULL, 144),
	(127, 'Kattara', NULL, 144),
	(128, 'Lalla Takerkoust', NULL, 144),
	(129, 'Loudaya', NULL, 144),
	(130, 'Lâattaouia', NULL, 144),
	(131, 'Moulay Brahim', NULL, 144),
	(132, 'Mzouda', NULL, 144),
	(133, 'Ounagha', NULL, 144),
	(134, 'Sid L\'Mokhtar', NULL, 144),
	(135, 'Sid Zouin', NULL, 144),
	(136, 'Sidi Abdallah Ghiat', NULL, 144),
	(137, 'Sidi Bou Othmane', NULL, 144),
	(138, 'Sidi Rahhal', NULL, 144),
	(139, 'Skhour Rehamna', NULL, 144),
	(140, 'Smimou', NULL, 144),
	(141, 'Tafetachte', NULL, 144),
	(142, 'Tahannaout', NULL, 144),
	(143, 'Talmest', NULL, 144),
	(144, 'Tamallalt', NULL, 144),
	(145, 'Tamanar', NULL, 144),
	(146, 'Tamansourt', NULL, 144),
	(147, 'Tameslouht', NULL, 144),
	(148, 'Tanalt', NULL, 144),
	(149, 'Zeubelemok', NULL, 144),
	(150, 'Meknès‎', NULL, 144),
	(151, 'Khénifra', NULL, 144),
	(152, 'Agourai', NULL, 144),
	(153, 'Ain Taoujdate', NULL, 144),
	(154, 'MyAliCherif', NULL, 144),
	(155, 'Rissani', NULL, 144),
	(156, 'Amalou Ighriben', NULL, 144),
	(157, 'Aoufous', NULL, 144),
	(158, 'Arfoud', NULL, 144),
	(159, 'Azrou', NULL, 144),
	(160, 'Aïn Jemaa', NULL, 144),
	(161, 'Aïn Karma', NULL, 144),
	(162, 'Aïn Leuh', NULL, 144),
	(163, 'Aït Boubidmane', NULL, 144),
	(164, 'Aït Ishaq', NULL, 144),
	(165, 'Boudnib', NULL, 144),
	(166, 'Boufakrane', NULL, 144),
	(167, 'Boumia', NULL, 144),
	(168, 'El Hajeb', NULL, 144),
	(169, 'Elkbab', NULL, 144),
	(170, 'Er-Rich', NULL, 144),
	(171, 'Errachidia', NULL, 144),
	(172, 'Gardmit', NULL, 144),
	(173, 'Goulmima', NULL, 144),
	(174, 'Gourrama', NULL, 144),
	(175, 'Had Bouhssoussen', NULL, 144),
	(176, 'Haj Kaddour', NULL, 144),
	(177, 'Ifrane', NULL, 144),
	(178, 'Itzer', NULL, 144),
	(179, 'Jorf', NULL, 144),
	(180, 'Kehf Nsour', NULL, 144),
	(181, 'Kerrouchen', NULL, 144),
	(182, 'M\'haya', NULL, 144),
	(183, 'M\'rirt', NULL, 144),
	(184, 'Midelt', NULL, 144),
	(185, 'Moulay Ali Cherif', NULL, 144),
	(186, 'Moulay Bouazza', NULL, 144),
	(187, 'Moulay Idriss Zerhoun', NULL, 144),
	(188, 'Moussaoua', NULL, 144),
	(189, 'N\'Zalat Bni Amar', NULL, 144),
	(190, 'Ouaoumana', NULL, 144),
	(191, 'Oued Ifrane', NULL, 144),
	(192, 'Sabaa Aiyoun', NULL, 144),
	(193, 'Sebt Jahjouh', NULL, 144),
	(194, 'Sidi Addi', NULL, 144),
	(195, 'Tichoute', NULL, 144),
	(196, 'Tighassaline', NULL, 144),
	(197, 'Tighza', NULL, 144),
	(198, 'Timahdite', NULL, 144),
	(199, 'Tinejdad', NULL, 144),
	(200, 'Tizguite', NULL, 144),
	(201, 'Toulal', NULL, 144),
	(202, 'Tounfite', NULL, 144),
	(203, 'Zaouia d\'Ifrane', NULL, 144),
	(204, 'Zaïda', NULL, 144),
	(205, 'Ahfir', NULL, 144),
	(206, 'Aklim', NULL, 144),
	(207, 'Al Aroui', NULL, 144),
	(208, 'Aïn Bni Mathar', NULL, 144),
	(209, 'Aïn Erreggada', NULL, 144),
	(210, 'Ben Taïeb', NULL, 144),
	(211, 'Berkane', NULL, 144),
	(212, 'Bni Ansar', NULL, 144),
	(213, 'Bni Chiker', NULL, 144),
	(214, 'Bni Drar', NULL, 144),
	(215, 'Bni Tadjite', NULL, 144),
	(216, 'Bouanane', NULL, 144),
	(217, 'Bouarfa', NULL, 144),
	(218, 'Bouhdila', NULL, 144),
	(219, 'Dar El Kebdani', NULL, 144),
	(220, 'Debdou', NULL, 144),
	(221, 'Douar Kannine', NULL, 144),
	(222, 'Driouch', NULL, 144),
	(223, 'El Aïoun Sidi Mellouk', NULL, 144),
	(224, 'Farkhana', NULL, 144),
	(225, 'Figuig', NULL, 144),
	(226, 'Ihddaden', NULL, 144),
	(227, 'Jaâdar', NULL, 144),
	(228, 'Jerada', NULL, 144),
	(229, 'Kariat Arekmane', NULL, 144),
	(230, 'Kassita', NULL, 144),
	(231, 'Kerouna', NULL, 144),
	(232, 'Laâtamna', NULL, 144),
	(233, 'Madagh', NULL, 144),
	(234, 'Midar', NULL, 144),
	(235, 'Nador', NULL, 144),
	(236, 'Naima', NULL, 144),
	(237, 'Oued Heimer', NULL, 144),
	(238, 'Oujda', NULL, 144),
	(239, 'Ras El Ma', NULL, 144),
	(240, 'Saïdia', NULL, 144),
	(241, 'Selouane', NULL, 144),
	(242, 'Sidi Boubker', NULL, 144),
	(243, 'Sidi Slimane Echcharaa', NULL, 144),
	(244, 'Talsint', NULL, 144),
	(245, 'Taourirt', NULL, 144),
	(246, 'Tendrara', NULL, 144),
	(247, 'Tiztoutine', NULL, 144),
	(248, 'Touima', NULL, 144),
	(249, 'Touissit', NULL, 144),
	(250, 'Zaïo', NULL, 144),
	(251, 'Zeghanghane', NULL, 144),
	(252, 'Rabat', NULL, 144),
	(253, 'Salé', NULL, 144),
	(254, 'Ain El Aouda', NULL, 144),
	(255, 'Harhoura', NULL, 144),
	(256, 'Khémisset', NULL, 144),
	(257, 'Oulmès', NULL, 144),
	(258, 'Rommani', NULL, 144),
	(259, 'Sidi Allal El Bahraoui', NULL, 144),
	(260, 'Sidi Bouknadel', NULL, 144),
	(261, 'Skhirate', NULL, 144),
	(262, 'Tamesna', NULL, 144),
	(263, 'Témara', NULL, 144),
	(264, 'Tiddas', NULL, 144),
	(265, 'Tiflet', NULL, 144),
	(266, 'Touarga', NULL, 144),
	(267, 'Agadir', NULL, 144),
	(268, 'Agdz', NULL, 144),
	(269, 'Agni Izimmer', NULL, 144),
	(270, 'Aït Melloul', NULL, 144),
	(271, 'Alnif', NULL, 144),
	(272, 'Anzi', NULL, 144),
	(273, 'Aoulouz', NULL, 144),
	(274, 'Aourir', NULL, 144),
	(275, 'Arazane', NULL, 144),
	(276, 'Aït Baha', NULL, 144),
	(277, 'Aït Iaâza', NULL, 144),
	(278, 'Aït Yalla', NULL, 144),
	(279, 'Ben Sergao', NULL, 144),
	(280, 'Biougra', NULL, 144),
	(281, 'Boumalne-Dadès', NULL, 144),
	(282, 'Dcheira El Jihadia', NULL, 144),
	(283, 'Drargua', NULL, 144),
	(284, 'El Guerdane', NULL, 144),
	(285, 'Harte Lyamine', NULL, 144),
	(286, 'Ida Ougnidif', NULL, 144),
	(287, 'Ifri', NULL, 144),
	(288, 'Igdamen', NULL, 144),
	(289, 'Ighil n\'Oumgoun', NULL, 144),
	(290, 'Imassine', NULL, 144),
	(291, 'Inezgane', NULL, 144),
	(292, 'Irherm', NULL, 144),
	(293, 'Kelaat-M\'Gouna', NULL, 144),
	(294, 'Lakhsas', NULL, 144),
	(295, 'Lakhsass', NULL, 144),
	(296, 'Lqliâa', NULL, 144),
	(297, 'M\'semrir', NULL, 144),
	(298, 'Massa (Maroc)', NULL, 144),
	(299, 'Megousse', NULL, 144),
	(300, 'Ouarzazate', NULL, 144),
	(301, 'Oulad Berhil', NULL, 144),
	(302, 'Oulad Teïma', NULL, 144),
	(303, 'Sarghine', NULL, 144),
	(304, 'Sidi Ifni', NULL, 144),
	(305, 'Skoura', NULL, 144),
	(306, 'Tabounte', NULL, 144),
	(307, 'Tafraout', NULL, 144),
	(308, 'Taghzout', NULL, 144),
	(309, 'Tagzen', NULL, 144),
	(310, 'Taliouine', NULL, 144),
	(311, 'Tamegroute', NULL, 144),
	(312, 'Tamraght', NULL, 144),
	(313, 'Tanoumrite Nkob Zagora', NULL, 144),
	(314, 'Taourirt ait zaghar', NULL, 144),
	(315, 'Taroudannt', NULL, 144),
	(316, 'Temsia', NULL, 144),
	(317, 'Tifnit', NULL, 144),
	(318, 'Tisgdal', NULL, 144),
	(319, 'Tiznit', NULL, 144),
	(320, 'Toundoute', NULL, 144),
	(321, 'Zagora', NULL, 144),
	(322, 'Afourar', NULL, 144),
	(323, 'Aghbala', NULL, 144),
	(324, 'Azilal', NULL, 144),
	(325, 'Aït Majden', NULL, 144),
	(326, 'Beni Ayat', NULL, 144),
	(327, 'Béni Mellal', NULL, 144),
	(328, 'Bin elouidane', NULL, 144),
	(329, 'Bradia', NULL, 144),
	(330, 'Bzou', NULL, 144),
	(331, 'Dar Oulad Zidouh', NULL, 144),
	(332, 'Demnate', NULL, 144),
	(333, 'Dra\'a', NULL, 144),
	(334, 'El Ksiba', NULL, 144),
	(335, 'Foum Jamaa', NULL, 144),
	(336, 'Fquih Ben Salah', NULL, 144),
	(337, 'Kasba Tadla', NULL, 144),
	(338, 'Ouaouizeght', NULL, 144),
	(339, 'Oulad Ayad', NULL, 144),
	(340, 'Oulad M\'Barek', NULL, 144),
	(341, 'Oulad Yaich', NULL, 144),
	(342, 'Sidi Jaber', NULL, 144),
	(343, 'Souk Sebt Oulad Nemma', NULL, 144),
	(344, 'Zaouïat Cheikh', NULL, 144),
	(345, 'Tanger‎', NULL, 144),
	(346, 'Tétouan‎', NULL, 144),
	(347, 'Akchour', NULL, 144),
	(348, 'Assilah', NULL, 144),
	(349, 'Bab Berred', NULL, 144),
	(350, 'Bab Taza', NULL, 144),
	(351, 'Brikcha', NULL, 144),
	(352, 'Chefchaouen', NULL, 144),
	(353, 'Dar Bni Karrich', NULL, 144),
	(354, 'Dar Chaoui', NULL, 144),
	(355, 'Fnideq', NULL, 144),
	(356, 'Gueznaia', NULL, 144),
	(357, 'Jebha', NULL, 144),
	(358, 'Karia', NULL, 144),
	(359, 'Khémis Sahel', NULL, 144),
	(360, 'Ksar El Kébir', NULL, 144),
	(361, 'Larache', NULL, 144),
	(362, 'M\'diq', NULL, 144),
	(363, 'Martil', NULL, 144),
	(364, 'Moqrisset', NULL, 144),
	(365, 'Oued Laou', NULL, 144),
	(366, 'Oued Rmel', NULL, 144),
	(367, 'Ouazzane', NULL, 144),
	(368, 'Point Cires', NULL, 144),
	(369, 'Sidi Lyamani', NULL, 144),
	(370, 'Sidi Mohamed ben Abdallah el-Raisuni', NULL, 144),
	(371, 'Zinat', NULL, 144),
	(372, 'Ajdir‎', NULL, 144),
	(373, 'Aknoul‎', NULL, 144),
	(374, 'Al Hoceïma‎', NULL, 144),
	(375, 'Aït Hichem‎', NULL, 144),
	(376, 'Bni Bouayach‎', NULL, 144),
	(377, 'Bni Hadifa‎', NULL, 144),
	(378, 'Ghafsai‎', NULL, 144),
	(379, 'Guercif‎', NULL, 144),
	(380, 'Imzouren‎', NULL, 144),
	(381, 'Inahnahen‎', NULL, 144),
	(382, 'Issaguen (Ketama)‎', NULL, 144),
	(383, 'Karia (El Jadida)‎', NULL, 144),
	(384, 'Karia Ba Mohamed‎', NULL, 144),
	(385, 'Oued Amlil‎', NULL, 144),
	(386, 'Oulad Zbair‎', NULL, 144),
	(387, 'Tahla‎', NULL, 144),
	(388, 'Tala Tazegwaght‎', NULL, 144),
	(389, 'Tamassint‎', NULL, 144),
	(390, 'Taounate‎', NULL, 144),
	(391, 'Targuist‎', NULL, 144),
	(392, 'Taza‎', NULL, 144),
	(393, 'Taïnaste‎', NULL, 144),
	(394, 'Thar Es-Souk‎', NULL, 144),
	(395, 'Tissa‎', NULL, 144),
	(396, 'Tizi Ouasli‎', NULL, 144),
	(397, 'Laayoune‎', NULL, 144),
	(398, 'El Marsa‎', NULL, 144),
	(399, 'Tarfaya‎', NULL, 144),
	(400, 'Boujdour‎', NULL, 144),
	(401, 'Awsard', NULL, 144),
	(402, 'Oued-Eddahab', NULL, 144),
	(403, 'Stehat', NULL, 144),
	(404, 'Aït Attab', NULL, 144);

/*!40103 SET TIME_ZONE=IFNULL(@OLD_TIME_ZONE, 'system') */;
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
