--
-- Host: localhost    Database: server18servermd_chambre-espagnole-db
-- ------------------------------------------------------


--
-- Table structure for table `attachments`
--

CREATE TABLE `attachments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `path` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `size` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `attachmentable_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `attachmentable_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `attachments_uid_unique` (`uid`),
  KEY `attachments_attachmentable_type_attachmentable_id_index` (`attachmentable_type`,`attachmentable_id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attachments`
--

INSERT INTO `attachments` VALUES (1,'CM8-LWA-yIb-mlI','categories/machines.png',NULL,'image/png',NULL,'App\\Models\\Category',3,'2023-08-05 10:59:47','2023-08-05 10:59:47',NULL),(2,'OUw-PQ2-Anx-lFb','categories/agroalimentaire.png',NULL,'image/png',NULL,'App\\Models\\Category',4,'2023-08-05 10:59:47','2023-08-05 10:59:47',NULL),(3,'Jgc-LPJ-2Sj-tML','categories/construction.png',NULL,'image/png',NULL,'App\\Models\\Category',5,'2023-08-05 10:59:47','2023-08-05 10:59:47',NULL),(4,'Tvw-cji-9D2-Gvs','categories/bois.png',NULL,'image/png',NULL,'App\\Models\\Category',6,'2023-08-05 10:59:48','2023-08-05 10:59:48',NULL),(5,'R4w-IZa-Zt3-q8l','categories/electricity.png',NULL,'image/png',NULL,'App\\Models\\Category',7,'2023-08-05 10:59:48','2023-08-05 10:59:48',NULL),(6,'7Rv-y4b-Q8x-Z7R','categories/metallurgy.png',NULL,'image/png',NULL,'App\\Models\\Category',8,'2023-08-05 10:59:48','2023-08-05 10:59:48',NULL),(7,'UYD-kVd-HN0-uHu','categories/paper.png',NULL,'image/png',NULL,'App\\Models\\Category',9,'2023-08-05 10:59:48','2023-08-05 10:59:48',NULL),(8,'Cjf-DAy-2Nz-5lv','categories/chemistry.png',NULL,'image/png',NULL,'App\\Models\\Category',10,'2023-08-05 10:59:48','2023-08-05 10:59:48',NULL),(9,'3yF-qLq-r8b-wof','categories/pharmaceutical.png',NULL,'image/png',NULL,'App\\Models\\Category',11,'2023-08-05 10:59:48','2023-08-05 10:59:48',NULL),(10,'8Yz-tvB-gVA-BAW','categories/transport.png',NULL,'image/png',NULL,'App\\Models\\Category',12,'2023-08-05 10:59:48','2023-08-05 10:59:48',NULL),(11,'JBv-3J0-W7S-R9s','categories/automobile.png',NULL,'image/png',NULL,'App\\Models\\Category',13,'2023-08-05 10:59:48','2023-08-05 10:59:48',NULL),(12,'LoK-0jr-1Bb-Zv2','categories/plastic.png',NULL,'image/png',NULL,'App\\Models\\Category',14,'2023-08-05 10:59:48','2023-08-05 10:59:48',NULL),(13,'wgc-WAM-vMh-BHo','categories/multimedia.png',NULL,'image/png',NULL,'App\\Models\\Category',15,'2023-08-05 10:59:48','2023-08-05 10:59:48',NULL),(14,'rvJ-NoH-Zxe-ydI','categories/consulting.png',NULL,'image/png',NULL,'App\\Models\\Category',16,'2023-08-05 10:59:48','2023-08-05 10:59:48',NULL),(15,'Ms5-XLf-TMj-JE7','categories/bank.png',NULL,'image/png',NULL,'App\\Models\\Category',17,'2023-08-05 10:59:48','2023-08-05 10:59:48',NULL),(16,'zr7-JaK-lH6-BfA','categories/commerce.png',NULL,'image/png',NULL,'App\\Models\\Category',18,'2023-08-05 10:59:48','2023-08-05 10:59:48',NULL),(17,'zPB-lWC-FoZ-AcT','categories/informatique.png',NULL,'image/png',NULL,'App\\Models\\Category',19,'2023-08-05 10:59:48','2023-08-05 10:59:48',NULL),(18,'pKg-Cpa-hLu-wtT','categories/services.png',NULL,'image/png',NULL,'App\\Models\\Category',20,'2023-08-05 10:59:48','2023-08-05 10:59:48',NULL),(19,'2Fo-OBW-011-xGt','categories/juridique.png',NULL,'image/png',NULL,'App\\Models\\Category',21,'2023-08-05 10:59:48','2023-08-05 10:59:48',NULL),(20,'0KF-l4x-862-64w','categories/textile.png',NULL,'image/png',NULL,'App\\Models\\Category',22,'2023-08-05 10:59:48','2023-08-05 10:59:48',NULL),(21,'kMs-yA0-xyA-i3y','categories/restauration.png',NULL,'image/png',NULL,'App\\Models\\Category',23,'2023-08-05 10:59:48','2023-08-05 10:59:48',NULL),(22,'eVG-1AW-QIT-0KU','categories/entertainment.png',NULL,'image/png',NULL,'App\\Models\\Category',24,'2023-08-05 10:59:48','2023-08-05 10:59:48',NULL),(23,'BrF-jSd-XDb-UjE','offers/ZlbCWX9Yd2chmTsfYBoEEtv7NyvyyR56a8ZLNwPN.jpg',NULL,'image/jpeg','145059','App\\Models\\Offer',1,'2023-08-05 11:03:07','2023-08-05 11:03:07',NULL),(24,'zqC-Eeh-rNP-E67','offers/U3TJ5Tt5xHanqZMhUWYOFZzv7hBkeNpEOFVdrYZQ.jpg',NULL,'image/jpeg','181254','App\\Models\\Offer',2,'2023-08-05 11:03:35','2023-08-05 11:03:35',NULL),(25,'SnD-6Wi-1QN-cRz','offers/Qutq0OzN6IwPyiPyn1GjAvcsmWLN2HPFGRoN6Akt.jpg',NULL,'image/jpeg','124999','App\\Models\\Offer',3,'2023-08-05 11:04:00','2023-08-05 11:04:00',NULL),(26,'Amp-LVr-ezP-EJu','users/grlGzPUk3W8WI5VIGDeIbAXDhO3K7zango2tviYp.png',NULL,'image/png',NULL,'App\\Models\\User',2,'2023-08-29 12:49:49','2023-08-29 12:49:49',NULL),(27,'yyb-Ksl-H11-Nhn','offers/EME8sPLP9SjILKuxDslaLnpbq5DYQKGH4jL9z6xE.jpg',NULL,'image/jpeg','201632','App\\Models\\Offer',4,'2023-09-08 13:08:20','2023-09-08 13:08:20',NULL),(28,'Uuw-kbs-YAg-mTd','offers/Q5grWWcqvC0DI5g1tYa14Oy175yCDsfcDVFHOcVp.pdf',NULL,'application/pdf','84327','App\\Models\\Offer',4,'2023-09-08 13:08:20','2023-09-08 13:08:20',NULL),(29,'EGG-tDd-byn-7ax','offers/THELXabcAKNl7EWdVIk9fpaNEdmEAT8VjBEBgoZN.jpg',NULL,'image/jpeg','201632','App\\Models\\Offer',5,'2023-09-08 13:08:22','2023-09-08 13:08:22',NULL),(30,'m2e-cdn-diB-oeb','offers/2uC0r6MUmYdbtIPnFJXvwY70bXcPAD3F4fw2oRuE.pdf',NULL,'application/pdf','84327','App\\Models\\Offer',5,'2023-09-08 13:08:22','2023-09-08 13:08:22',NULL);

--
-- Table structure for table `categories`
--

CREATE TABLE `categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `categories_uid_unique` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `categories`
--

INSERT INTO `categories` VALUES (1,'RtV-wDp-AsN-0B2','Produit','2023-08-05 10:52:31','2023-08-05 10:52:31'),(2,'LgR-mQB-KnF-hTe','Service','2023-08-05 10:52:31','2023-08-05 10:52:31'),(3,'LoV-eEI-8Gn-AOe','Machines et équipements','2023-08-05 10:52:31','2023-08-05 10:52:31'),(4,'gpY-dGF-HJ8-8Zv','Agroalimentaire / Agro-industrie','2023-08-05 10:52:31','2023-08-05 10:52:31'),(5,'a6s-5UH-tNd-SLY','BTP/ Construction','2023-08-05 10:52:31','2023-08-05 10:52:31'),(6,'nqj-bxM-Bng-St2','Bois','2023-08-05 10:52:31','2023-08-05 10:52:31'),(7,'VnZ-66O-cLu-ixP','Electronique / Electricité','2023-08-05 10:52:31','2023-08-05 10:52:31'),(8,'mEd-erp-cMy-3na','Métallurgie','2023-08-05 10:52:31','2023-08-05 10:52:31'),(9,'OnV-KbS-4b7-wMM','Papier / Carton','2023-08-05 10:52:31','2023-08-05 10:52:31'),(10,'vQJ-XqC-PkW-5Bl','Chimie/ Parachimie','2023-08-05 10:52:32','2023-08-05 10:52:32'),(11,'v7h-v9X-3iG-DhD','Industrie pharmaceutique','2023-08-05 10:52:32','2023-08-05 10:52:32'),(12,'QNv-kdc-tHN-ZNJ','Transports / Logistique','2023-08-05 10:52:32','2023-08-05 10:52:32'),(13,'qcO-4Kv-wQq-LFP','Automobile','2023-08-05 10:52:32','2023-08-05 10:52:32'),(14,'z9o-1K4-3Lr-vzm','Plastique / Caoutchouc','2023-08-05 10:52:32','2023-08-05 10:52:32'),(15,'TCs-ew3-ia5-SMV','Edition / Imprimerie / Communication / Multimédia','2023-08-05 10:52:32','2023-08-05 10:52:32'),(16,'SZS-00D-yzC-kW4','Etudes et conseils','2023-08-05 10:52:32','2023-08-05 10:52:32'),(17,'G0n-jSR-Gm1-oDJ','Banque / Assurance','2023-08-05 10:52:32','2023-08-05 10:52:32'),(18,'jEE-FMv-sZa-6Uf','Commerce / Négoce / Distribution','2023-08-05 10:52:32','2023-08-05 10:52:32'),(19,'upP-9jP-JmB-J4M','Informatique / télécoms','2023-08-05 10:52:32','2023-08-05 10:52:32'),(20,'ffJ-qXu-FYL-j1V','Services aux entreprises','2023-08-05 10:52:32','2023-08-05 10:52:32'),(21,'kQm-NXZ-KhZ-Dlx','Juridique et Fiscale','2023-08-05 10:52:32','2023-08-05 10:52:32'),(22,'zpf-5my-Dpa-7eE','Textile','2023-08-05 10:52:32','2023-08-05 10:52:32'),(23,'pDc-0In-G7C-eY6','Hôtellerie / Restauration','2023-08-05 10:52:32','2023-08-05 10:52:32'),(24,'1nd-QbU-cPZ-2Rc','Loisirs','2023-08-05 10:52:32','2023-08-05 10:52:32');

--
-- Table structure for table `category_user`
--

CREATE TABLE `category_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `category_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `category_user_user_id_category_id_unique` (`user_id`,`category_id`),
  KEY `category_user_category_id_foreign` (`category_id`),
  CONSTRAINT `category_user_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `category_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category_user`
--

INSERT INTO `category_user` VALUES (2,3,3,'2023-09-08 13:07:13','2023-09-08 13:07:13');

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

CREATE TABLE `cities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_famous` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cities_uid_unique` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=619 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `cities` VALUES (1,'f1h-ZCY-3O3-f43','Aarab Sebbah Gheris',0,'2023-08-05 10:51:54','2023-08-05 10:51:54'),(2,'Y8X-Krd-Bkm-rBn','Aarab Sebbah Ziz',0,'2023-08-05 10:51:54','2023-08-05 10:51:54'),(3,'H12-318-Vqj-Xvf','Abadou',0,'2023-08-05 10:51:54','2023-08-05 10:51:54'),(4,'8R2-hax-pUP-AbU','Abaynou',0,'2023-08-05 10:51:54','2023-08-05 10:51:54'),(5,'tWE-lEP-bNH-2TS','Abbou Lakhal',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(6,'ExE-4Jc-yMg-AAr','Abdelghaya Souahel',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(7,'m6R-e8k-HUp-mH7','Abteh',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(8,'UNX-5Pv-vRf-w2W','Adaghas',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(9,'lKA-uqY-IfO-6CA','Adar',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(10,'VVM-NvZ-8Eh-JX8','Adrej',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(11,'Nmu-3hW-C2M-b4q','Aferkat',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(12,'jJo-lVF-790-fRl','Afourar',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(13,'teA-4tM-V48-zcV','Agadir',1,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(14,'C75-5fY-7Oh-TPd','Agadir Melloul',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(15,'ZjN-THL-R3D-eOf','Agafay',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(16,'Ful-xIT-pQ6-k57','Agdz',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(17,'xAA-29U-GLo-Usz','Aghbal',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(18,'KO5-Q1Z-qnj-VBO','Aghbala',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(19,'XdR-GAk-EWn-fvo','Aghbalou',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(20,'KUB-L1Y-bZa-lB3','Aghbalou N\'kerdous',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(21,'XOr-bx1-lzb-3de','Aghouinite',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(22,'svF-pJr-HfE-TcX','Agourai',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(23,'JQl-Vaw-CCP-vQp','Aguelmous',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(24,'t6x-cLR-sZ0-iAU','Ahfir',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(25,'4sm-dJG-Eqj-0yc','Ahl Sidi Lahcen',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(26,'C8N-pKj-r9Y-tlN','Ahlaf',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(27,'Xap-n1B-ToY-A6h','Ahmar Laglalcha',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(28,'SBA-CuG-rID-qP4','Ain Aouda',0,'2023-08-05 10:51:55','2023-08-05 10:51:55'),(29,'Gz8-x2X-vGo-GfW','Ain Attig',0,'2023-08-05 10:51:56','2023-08-05 10:51:56'),(30,'6nC-pVc-ggR-ArU','Ain Bida',0,'2023-08-05 10:51:56','2023-08-05 10:51:56'),(31,'ivE-8FG-yxE-dTf','Ain Bni Mathar',0,'2023-08-05 10:51:56','2023-08-05 10:51:56'),(32,'qXi-dOh-E3H-IZ3','Ain Cheggag',0,'2023-08-05 10:51:56','2023-08-05 10:51:56'),(33,'aG6-QBW-R39-96I','Ain Erreggada',0,'2023-08-05 10:51:56','2023-08-05 10:51:56'),(34,'txo-6aa-3vy-gwD','Ain Harrouda',0,'2023-08-05 10:51:56','2023-08-05 10:51:56'),(35,'m14-jbx-BEn-qko','Ain Johra',0,'2023-08-05 10:51:56','2023-08-05 10:51:56'),(36,'7ey-43l-J2u-FuZ','Ain Karma',0,'2023-08-05 10:51:56','2023-08-05 10:51:56'),(37,'FWV-rd2-K1y-ILw','Ain Legdah',0,'2023-08-05 10:51:56','2023-08-05 10:51:56'),(38,'9Ff-bxc-94R-aFa','Ain Leuh',0,'2023-08-05 10:51:56','2023-08-05 10:51:56'),(39,'tfQ-JLQ-1Mz-zpO','Ain Orma',0,'2023-08-05 10:51:56','2023-08-05 10:51:56'),(40,'BK4-ZNJ-2rm-138','Ain Sbit',0,'2023-08-05 10:51:56','2023-08-05 10:51:56'),(41,'S8g-bUE-iIM-rBC','Ain Sfa',0,'2023-08-05 10:51:56','2023-08-05 10:51:56'),(42,'ykX-rBd-Cae-Wlw','Ain Taoujdate',0,'2023-08-05 10:51:56','2023-08-05 10:51:56'),(43,'KQB-8VL-a6V-XKt','Ain Tizgha',0,'2023-08-05 10:51:56','2023-08-05 10:51:56'),(44,'ZT3-qpa-AB2-mEp','Ait Amira',0,'2023-08-05 10:51:56','2023-08-05 10:51:56'),(45,'jWT-drQ-GKp-GP1','Ait Baha',0,'2023-08-05 10:51:57','2023-08-05 10:51:57'),(46,'gz9-i37-dWu-2GF','Ait Belkacem',0,'2023-08-05 10:51:57','2023-08-05 10:51:57'),(47,'y8p-LnW-YWN-Kdu','Ait Ben Yacoub',0,'2023-08-05 10:51:57','2023-08-05 10:51:57'),(48,'Y0N-N2H-qLq-VNa','Ait Boubidmane',0,'2023-08-05 10:51:57','2023-08-05 10:51:57'),(49,'GQ9-P9c-G3i-4tV','Ait Bouyahya El Hajjama',0,'2023-08-05 10:51:57','2023-08-05 10:51:57'),(50,'wmB-OjV-Qdn-AgP','Aït Iaaza',0,'2023-08-05 10:51:57','2023-08-05 10:51:57'),(51,'VyS-wWB-RRN-4s7','Ait Ichou',0,'2023-08-05 10:51:57','2023-08-05 10:51:57'),(52,'8it-dFC-rcY-6NJ','Ait Imour',0,'2023-08-05 10:51:57','2023-08-05 10:51:57'),(53,'U5L-VPn-a6W-OAM','Ait Ishaq',0,'2023-08-05 10:51:57','2023-08-05 10:51:57'),(54,'qck-o54-07z-k1d','Ait Malek',0,'2023-08-05 10:51:57','2023-08-05 10:51:57'),(55,'TPp-PwM-pXD-unP','Ait Melloul',0,'2023-08-05 10:51:57','2023-08-05 10:51:57'),(56,'Qzn-EXX-iRq-M8U','Ait Milk',0,'2023-08-05 10:51:57','2023-08-05 10:51:57'),(57,'wdt-XGg-XBQ-Tpy','Ait Mimoun',0,'2023-08-05 10:51:57','2023-08-05 10:51:57'),(58,'Odz-8Or-7Up-7d8','Ait Ouallal',0,'2023-08-05 10:51:58','2023-08-05 10:51:58'),(59,'m8l-WuF-AfI-N5B','Ait Ouribel',0,'2023-08-05 10:51:58','2023-08-05 10:51:58'),(60,'qjr-gwD-UST-wSx','Ait Ourir',0,'2023-08-05 10:51:58','2023-08-05 10:51:58'),(61,'b2b-JlS-sY5-P4a','Ait Sidi Daoud',0,'2023-08-05 10:51:58','2023-08-05 10:51:58'),(62,'yKS-ehC-Bkk-Pmc','Ait Yaazem',0,'2023-08-05 10:51:58','2023-08-05 10:51:58'),(63,'5KV-PDz-tif-U0q','Ait Yadine',0,'2023-08-05 10:51:58','2023-08-05 10:51:58'),(64,'heY-RuL-d3Q-4EL','Ait Youl',0,'2023-08-05 10:51:58','2023-08-05 10:51:58'),(65,'og0-nKP-okh-2iX','Ajdir',0,'2023-08-05 10:51:58','2023-08-05 10:51:58'),(66,'nvt-NMA-chH-ud9','Akarma',0,'2023-08-05 10:51:58','2023-08-05 10:51:58'),(67,'vAL-dnx-uwS-zAz','Akhfennir',0,'2023-08-05 10:51:58','2023-08-05 10:51:58'),(68,'VWr-iWR-RoX-YVu','Akka',0,'2023-08-05 10:51:58','2023-08-05 10:51:58'),(69,'Bi1-FcU-OOk-vbo','Aklim',0,'2023-08-05 10:51:58','2023-08-05 10:51:58'),(70,'xOB-sfW-OwT-Vcr','Aknoul',0,'2023-08-05 10:51:58','2023-08-05 10:51:58'),(71,'V43-DCp-WTD-51p','Al Aaroui',0,'2023-08-05 10:51:58','2023-08-05 10:51:58'),(72,'yPe-VZR-G0g-k0a','Al Firdaous',0,'2023-08-05 10:51:58','2023-08-05 10:51:58'),(73,'QhY-T7Y-m6V-8Uv','Al Haouz',0,'2023-08-05 10:51:58','2023-08-05 10:51:58'),(74,'E6y-JKP-ceD-fAw','Al Hoceima',0,'2023-08-05 10:51:58','2023-08-05 10:51:58'),(75,'daz-4AN-qH2-cRL','Al Oioun Sidi Mellouk',0,'2023-08-05 10:51:58','2023-08-05 10:51:58'),(76,'pb1-pYT-w7X-jZq','Allyene',0,'2023-08-05 10:51:58','2023-08-05 10:51:58'),(77,'I0d-n30-zxT-jtF','Alnif',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(78,'aXe-hvl-dSi-ZuV','Amalou',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(79,'25x-j2P-GA5-oT3','Amerzgane',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(80,'beH-ymF-3WE-Jbo','Ameur Seflia',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(81,'ELT-cru-JcX-NHu','Amghras',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(82,'O5G-6Yb-4wE-x8J','Amizmiz',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(83,'NO8-mtH-hxl-qqE','Amskroud',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(84,'6QF-ARO-E4L-4BQ','Amtar',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(85,'2hV-gGW-UkF-GEk','Anfeg',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(86,'7Rx-s12-NOc-hCa','Anjra',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(87,'GWX-YEs-HAs-a76','Aoulouz',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(88,'TVi-veC-41R-RuM','Aourir',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(89,'fjO-zD2-SJE-EzY','Aousserd',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(90,'c5C-qlL-mJq-6nw','Aqesri',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(91,'FtL-ixS-94h-QrA','Aquouass Briech',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(92,'gxj-Hjc-yFg-Pm7','Arbaa Sahel',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(93,'HxC-YnU-lob-ITW','Arbaoua',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(94,'I4D-gVy-hVo-5zH','Arekmane',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(95,'k0z-Cu9-6BY-kUs','Arfoud',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(96,'mtd-Z3S-2gi-ila','Asilah',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(97,'rOH-oX7-na6-6VV','Asni',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(98,'1H3-jHw-4bs-oZO','Assa',0,'2023-08-05 10:51:59','2023-08-05 10:51:59'),(99,'VxP-Xot-jvw-nK1','Assa zag',0,'2023-08-05 10:52:00','2023-08-05 10:52:00'),(100,'ea5-MjS-NYB-SQF','Assahrij',0,'2023-08-05 10:52:00','2023-08-05 10:52:00'),(101,'fLx-2qh-1zw-MDj','Ayir',0,'2023-08-05 10:52:00','2023-08-05 10:52:00'),(102,'w0z-DEx-Ix3-zMD','Azemmour',0,'2023-08-05 10:52:00','2023-08-05 10:52:00'),(103,'z0H-gEA-XVD-Ltw','Azilal',0,'2023-08-05 10:52:00','2023-08-05 10:52:00'),(104,'IAN-PsF-tET-eLD','Azla',0,'2023-08-05 10:52:00','2023-08-05 10:52:00'),(105,'UyT-nVh-9iH-xtM','Azlaf',0,'2023-08-05 10:52:00','2023-08-05 10:52:00'),(106,'UYd-c4B-I01-mDj','Azrou',0,'2023-08-05 10:52:00','2023-08-05 10:52:00'),(107,'WLv-Qxs-pAw-Bwg','Bab Berred',0,'2023-08-05 10:52:00','2023-08-05 10:52:00'),(108,'H4G-9mm-qFr-kHG','Bab Taza',0,'2023-08-05 10:52:00','2023-08-05 10:52:00'),(109,'b2U-gRn-R7g-etv','Barkine',0,'2023-08-05 10:52:00','2023-08-05 10:52:00'),(110,'BRQ-KSx-Ol6-33y','Bejaad',0,'2023-08-05 10:52:00','2023-08-05 10:52:00'),(111,'Kgv-Fcw-TCc-o2O','Belfaa',0,'2023-08-05 10:52:00','2023-08-05 10:52:00'),(112,'fhx-efw-tqn-XOD','Ben Ahmed',0,'2023-08-05 10:52:00','2023-08-05 10:52:00'),(113,'kZE-JXK-xTs-cD4','Ben Guerir',0,'2023-08-05 10:52:00','2023-08-05 10:52:00'),(114,'Pqu-ukk-5JL-FsU','Ben Maachou',0,'2023-08-05 10:52:00','2023-08-05 10:52:00'),(115,'uTW-3S5-NzR-Rek','Ben Smim',0,'2023-08-05 10:52:00','2023-08-05 10:52:00'),(116,'J0O-Jpp-tnN-px7','Ben Taieb',0,'2023-08-05 10:52:00','2023-08-05 10:52:00'),(117,'yLD-MO7-kJp-9UM','Beni Malek',0,'2023-08-05 10:52:00','2023-08-05 10:52:00'),(118,'ZD5-zzG-xod-iIG','Béni Mellal',1,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(119,'KX8-fuQ-SDO-O4U','Béni Yakhlef',0,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(120,'6QT-6KE-GTc-ay5','Benslimane',0,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(121,'nM5-iHx-21v-PNB','Berkane',0,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(122,'C2p-hDD-kjV-iQg','Berrechid',0,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(123,'jcU-RET-yYr-lHG','Bhalil',0,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(124,'usg-JkH-RRU-mq7','Bin El Ouidane',0,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(125,'v56-joR-ht1-FYI','Biougra',0,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(126,'k98-nnD-GyC-iUe','Bir Ennasr',0,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(127,'lBU-aiD-UgG-qmz','Bir Jdid',0,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(128,'Wzb-GPr-bjw-Aj1','Bir Tam Tam',0,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(129,'wGR-6MT-dky-fdi','Bitit',0,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(130,'Ni9-bo0-cTF-JQz','Bizdad',0,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(131,'bP7-nkX-rUb-89f','Bni Ansar',0,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(132,'C7C-FNL-FHq-Lpl','Bni Ayat',0,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(133,'YfQ-Qrr-YmH-aFJ','Bni Bouzra',0,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(134,'GwY-et1-2pM-dqU','Bni Chiker',0,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(135,'odI-5qt-6xv-Rfo','Bni Drar',0,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(136,'vDh-9Ih-mhN-xYF','Bni Ftah',0,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(137,'8uk-Exs-3th-sTO','Bni Harchen',0,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(138,'icE-BFO-EvS-M3H','Bni Hassane',0,'2023-08-05 10:52:01','2023-08-05 10:52:01'),(139,'TuM-YPT-MPp-VLv','Bni Khloug',0,'2023-08-05 10:52:02','2023-08-05 10:52:02'),(140,'W54-i8W-q3T-ONL','Bni Marghnine',0,'2023-08-05 10:52:02','2023-08-05 10:52:02'),(141,'Wp9-Oco-bsi-xyI','Bni Mathar',0,'2023-08-05 10:52:02','2023-08-05 10:52:02'),(142,'10l-8TV-gU1-NGO','Bni Salah',0,'2023-08-05 10:52:02','2023-08-05 10:52:02'),(143,'cJJ-zMc-qAN-FFE','Bni Tadjite',0,'2023-08-05 10:52:02','2023-08-05 10:52:02'),(144,'WB1-2gI-g9Q-CzF','Bouadel',0,'2023-08-05 10:52:02','2023-08-05 10:52:02'),(145,'iqQ-lBh-hmK-qCn','Bouanane',0,'2023-08-05 10:52:02','2023-08-05 10:52:02'),(146,'o2z-9e0-nhu-8lI','Bouarfa',0,'2023-08-05 10:52:02','2023-08-05 10:52:02'),(147,'ovK-8ul-K35-5yR','Boudinar',0,'2023-08-05 10:52:02','2023-08-05 10:52:02'),(148,'AnX-Y3i-TSg-MMv','Boudnib',0,'2023-08-05 10:52:02','2023-08-05 10:52:02'),(149,'GUZ-h9B-jeG-DSk','Boufkrane',0,'2023-08-05 10:52:02','2023-08-05 10:52:02'),(150,'Yu6-Lzx-voS-fnf','Boughriba',0,'2023-08-05 10:52:02','2023-08-05 10:52:02'),(151,'EIV-GeV-IRc-Utf','Bouguedra',0,'2023-08-05 10:52:02','2023-08-05 10:52:02'),(152,'xLw-oTq-mEU-79v','Bouizakarne',0,'2023-08-05 10:52:02','2023-08-05 10:52:02'),(153,'gbx-icN-9sC-30M','Boujdour',0,'2023-08-05 10:52:02','2023-08-05 10:52:02'),(154,'pvp-2oP-1OP-DXk','Boujniba',0,'2023-08-05 10:52:02','2023-08-05 10:52:02'),(155,'bB4-UtW-ADh-Pdl','Boukhalef',0,'2023-08-05 10:52:02','2023-08-05 10:52:02'),(156,'P8b-PeO-pjP-FAv','Boulanouar',0,'2023-08-05 10:52:03','2023-08-05 10:52:03'),(157,'AEb-Ej4-KU7-soB','Boulaouane',0,'2023-08-05 10:52:03','2023-08-05 10:52:03'),(158,'Qn2-IR6-Z9k-b9Q','Boulemane',0,'2023-08-05 10:52:03','2023-08-05 10:52:03'),(159,'FB4-BxI-w1k-kzt','Boulmane',0,'2023-08-05 10:52:03','2023-08-05 10:52:03'),(160,'wB9-y1t-G2L-Tq3','Boumalne-Dadès',0,'2023-08-05 10:52:03','2023-08-05 10:52:03'),(161,'hDj-hbK-0jd-I38','Boumia',0,'2023-08-05 10:52:03','2023-08-05 10:52:03'),(162,'wy6-ulZ-Egd-2Ub','Bounaamane',0,'2023-08-05 10:52:03','2023-08-05 10:52:03'),(163,'Hwp-h9L-5jw-Cs7','Bouskoura',0,'2023-08-05 10:52:03','2023-08-05 10:52:03'),(164,'msO-zCj-ImR-NNY','Bousselham',0,'2023-08-05 10:52:03','2023-08-05 10:52:03'),(165,'lTQ-som-YAq-Hsb','Bouzemmour',0,'2023-08-05 10:52:03','2023-08-05 10:52:03'),(166,'84L-hW6-wzn-qt9','Bouznika',1,'2023-08-05 10:52:03','2023-08-05 10:52:03'),(167,'3ku-IFO-meH-ijB','Brachoua',0,'2023-08-05 10:52:03','2023-08-05 10:52:03'),(168,'cMJ-6n4-OOZ-FT9','Bradia',0,'2023-08-05 10:52:03','2023-08-05 10:52:03'),(169,'uR6-bQm-Osl-1Z3','Bsara',0,'2023-08-05 10:52:03','2023-08-05 10:52:03'),(170,'dVk-5NI-5P6-v8N','Cabo Negro',0,'2023-08-05 10:52:03','2023-08-05 10:52:03'),(171,'uB8-Bjc-HSE-lxv','Cap de l\'eau',0,'2023-08-05 10:52:03','2023-08-05 10:52:03'),(172,'n50-ujB-a6M-PmZ','Casablanca',1,'2023-08-05 10:52:03','2023-08-05 10:52:03'),(173,'v8x-Pnb-76X-62z','Chaibate',0,'2023-08-05 10:52:03','2023-08-05 10:52:03'),(174,'nMM-edP-pKJ-G0H','Chakrane',0,'2023-08-05 10:52:04','2023-08-05 10:52:04'),(175,'h8y-u8Z-9Qn-oOU','Chefchaouen',0,'2023-08-05 10:52:04','2023-08-05 10:52:04'),(176,'7Yh-Llc-UhY-Aza','Chellalate',0,'2023-08-05 10:52:04','2023-08-05 10:52:04'),(177,'lnY-Kwx-nRZ-RtC','Cherrat',0,'2023-08-05 10:52:04','2023-08-05 10:52:04'),(178,'QMw-0r7-rml-75V','Chichaoua',0,'2023-08-05 10:52:04','2023-08-05 10:52:04'),(179,'L3S-vBL-Y7B-PM1','Chouihia',0,'2023-08-05 10:52:04','2023-08-05 10:52:04'),(180,'3Wm-xdR-lcO-uE3','Chtouka',0,'2023-08-05 10:52:04','2023-08-05 10:52:04'),(181,'cVa-IET-myX-99F','Dakhla',0,'2023-08-05 10:52:04','2023-08-05 10:52:04'),(182,'I6m-0s6-ghL-A5h','Daoura',0,'2023-08-05 10:52:04','2023-08-05 10:52:04'),(183,'8MD-gCl-Vew-dk2','Dar Bel Amri',0,'2023-08-05 10:52:04','2023-08-05 10:52:04'),(184,'10h-dKH-x3r-MCX','Dar Bni Karrich',0,'2023-08-05 10:52:04','2023-08-05 10:52:04'),(185,'dxD-6wZ-LjY-Rxf','Dar Bouazza',0,'2023-08-05 10:52:04','2023-08-05 10:52:04'),(186,'xKo-bKh-Z7a-PGG','Dar Chaffai',0,'2023-08-05 10:52:04','2023-08-05 10:52:04'),(187,'Tdi-G2D-KKW-QE6','Dar El Kebdani',0,'2023-08-05 10:52:04','2023-08-05 10:52:04'),(188,'9nW-CmF-6Z8-5fk','Dar Gueddari',0,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(189,'k8E-aOv-cli-ZBh','Dar Jamaa',0,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(190,'if9-Nyf-OD6-tQG','Dar Ould Zidouh',0,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(191,'wU1-riO-Rjm-LLO','Dcheira',0,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(192,'91r-C6S-lMI-tiy','Dcheïra El Jihadia',0,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(193,'4a8-n8B-bnQ-22I','Debdou',0,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(194,'k2k-0Kd-BtZ-aZT','Demnate',0,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(195,'ptC-nkY-Prh-YJC','Deroua',0,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(196,'w9o-79W-u8y-00w','Dir El Ksiba',0,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(197,'jMV-ayk-A1k-SSu','Drargua',0,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(198,'62n-KqS-7Ge-EkT','Driouch',0,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(199,'LzW-cwc-azG-otg','Dzouz',0,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(200,'DLG-U2g-3sY-EAq','Echemmaia',0,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(201,'46e-qqZ-tSt-T4d','El Beddouza',0,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(202,'Qay-4Fv-Yai-Po4','El Borouj',0,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(203,'OS1-qna-mNc-rns','El Foqra',0,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(204,'tOL-ROx-eNt-sWE','El Gara',0,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(205,'uQ3-ZLz-Xs4-FRV','El Guerdane',0,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(206,'LJ0-UBT-bR4-EsD','El Hajeb',0,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(207,'Pxc-aDL-reu-Szk','El Hanchane',0,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(208,'z9a-O6o-3eo-Q70','El Jadida',1,'2023-08-05 10:52:05','2023-08-05 10:52:05'),(209,'RTY-EGg-t9C-Y3M','El Jebha',0,'2023-08-05 10:52:06','2023-08-05 10:52:06'),(210,'5iX-Xc3-xcF-ggD','El Kelâa des Sraghna',0,'2023-08-05 10:52:06','2023-08-05 10:52:06'),(211,'kPz-jvQ-cxG-VxK','El Ksiba',0,'2023-08-05 10:52:06','2023-08-05 10:52:06'),(212,'4jB-jcq-w4a-n7z','El Maader El Kabir',0,'2023-08-05 10:52:06','2023-08-05 10:52:06'),(213,'lDc-7Hd-NlH-NX9','El Majjatia Ouled Taleb',0,'2023-08-05 10:52:06','2023-08-05 10:52:06'),(214,'QM8-GAj-rv6-loO','El Mansouria',0,'2023-08-05 10:52:06','2023-08-05 10:52:06'),(215,'RXS-UFq-ozy-oB0','El Marsa',0,'2023-08-05 10:52:06','2023-08-05 10:52:06'),(216,'6eF-Tti-NOc-FJv','El Menzeh',0,'2023-08-05 10:52:06','2023-08-05 10:52:06'),(217,'wO6-cbV-oqt-of1','El Menzel',0,'2023-08-05 10:52:06','2023-08-05 10:52:06'),(218,'bd7-Wir-2eF-SGV','El Outia',0,'2023-08-05 10:52:06','2023-08-05 10:52:06'),(219,'HTO-DH1-VA3-oks','Er-Rich',0,'2023-08-05 10:52:06','2023-08-05 10:52:06'),(220,'Sv1-L0W-fFo-uV5','Er-Rissani',0,'2023-08-05 10:52:06','2023-08-05 10:52:06'),(221,'uNt-oMe-bgu-vW8','Errachidia',0,'2023-08-05 10:52:06','2023-08-05 10:52:06'),(222,'9Zx-9Qc-YkY-a4b','Errahma',0,'2023-08-05 10:52:06','2023-08-05 10:52:06'),(223,'ZSh-YTT-JdM-FAn','Es-Semara',0,'2023-08-05 10:52:06','2023-08-05 10:52:06'),(224,'AGV-b2M-0zx-ygx','Essaouira',0,'2023-08-05 10:52:06','2023-08-05 10:52:06'),(225,'MXA-GIn-t6P-0ZD','Ezzhiliga',0,'2023-08-05 10:52:06','2023-08-05 10:52:06'),(226,'aly-40q-fwU-YZa','Farkhana',0,'2023-08-05 10:52:07','2023-08-05 10:52:07'),(227,'vec-ofZ-wiw-Sd3','Fask',0,'2023-08-05 10:52:07','2023-08-05 10:52:07'),(228,'8qj-PSe-r5x-pka','Fdalate',0,'2023-08-05 10:52:07','2023-08-05 10:52:07'),(229,'vLr-5k9-Om4-Gs8','Fès',1,'2023-08-05 10:52:07','2023-08-05 10:52:07'),(230,'Fuk-nuV-VQr-N9l','Fezna',0,'2023-08-05 10:52:07','2023-08-05 10:52:07'),(231,'Wen-7bH-Sx6-8Mh','Fezouane',0,'2023-08-05 10:52:07','2023-08-05 10:52:07'),(232,'asS-FRH-Wuv-JFL','Fezouata',0,'2023-08-05 10:52:07','2023-08-05 10:52:07'),(233,'BnJ-YbK-uPi-dVu','Figuig',0,'2023-08-05 10:52:07','2023-08-05 10:52:07'),(234,'fCo-Eri-KYT-lmH','Fnideq',0,'2023-08-05 10:52:07','2023-08-05 10:52:07'),(235,'f5v-fiS-o9r-D37','Foum El Oued',0,'2023-08-05 10:52:07','2023-08-05 10:52:07'),(236,'eWi-rVX-VoX-vy4','Foum Jemaa',0,'2023-08-05 10:52:07','2023-08-05 10:52:07'),(237,'ZlH-88l-QLo-StU','Foum Oudi',0,'2023-08-05 10:52:08','2023-08-05 10:52:08'),(238,'eFw-T3I-GIg-qFh','Foum zguid',0,'2023-08-05 10:52:08','2023-08-05 10:52:08'),(239,'9aR-Ij8-fsv-EG5','Fquih Ben Saleh',0,'2023-08-05 10:52:08','2023-08-05 10:52:08'),(240,'cXt-0Zw-4lS-fqC','Freija',0,'2023-08-05 10:52:08','2023-08-05 10:52:08'),(241,'y4J-EKM-pib-4ha','Galaz',0,'2023-08-05 10:52:08','2023-08-05 10:52:08'),(242,'O1e-5UK-kpD-mIx','Ghafsai',0,'2023-08-05 10:52:08','2023-08-05 10:52:08'),(243,'qCc-DBE-TIo-m66','Ghiata Al Gharbia',0,'2023-08-05 10:52:08','2023-08-05 10:52:08'),(244,'x34-xu4-4gF-Fx2','Ghmate',0,'2023-08-05 10:52:08','2023-08-05 10:52:08'),(245,'vkI-HVR-dmm-YtQ','Goulmima',0,'2023-08-05 10:52:08','2023-08-05 10:52:08'),(246,'Db8-uHt-QVh-ilz','Guelmim',0,'2023-08-05 10:52:09','2023-08-05 10:52:09'),(247,'0h0-nUu-6JT-aDf','Guenfouda',0,'2023-08-05 10:52:09','2023-08-05 10:52:09'),(248,'glc-i3F-cqh-qvV','Guercif',0,'2023-08-05 10:52:09','2023-08-05 10:52:09'),(249,'LFX-tJg-M1Z-obC','Gueznaia',0,'2023-08-05 10:52:09','2023-08-05 10:52:09'),(250,'I2R-FhD-DLl-FDW','Guigou',0,'2023-08-05 10:52:09','2023-08-05 10:52:09'),(251,'N8I-fkD-6YE-N14','Guisser',0,'2023-08-05 10:52:09','2023-08-05 10:52:09'),(252,'leT-wSa-qGm-XUv','Gzenaya Al Janoubia',0,'2023-08-05 10:52:09','2023-08-05 10:52:09'),(253,'u2B-NAk-QpF-x0k','Had Bouhssoussen',0,'2023-08-05 10:52:09','2023-08-05 10:52:09'),(254,'bCU-iU0-Q2l-bqb','Had Boumoussa',0,'2023-08-05 10:52:09','2023-08-05 10:52:09'),(255,'TBX-uPf-BsT-hE9','Had Dra',0,'2023-08-05 10:52:10','2023-08-05 10:52:10'),(256,'2yO-Owk-pDy-voQ','Had Kourt',0,'2023-08-05 10:52:10','2023-08-05 10:52:10'),(257,'XzW-3Yv-SX0-3cu','Had Soualem',0,'2023-08-05 10:52:10','2023-08-05 10:52:10'),(258,'AFi-cwl-y3O-TZd','Haouzia',0,'2023-08-05 10:52:10','2023-08-05 10:52:10'),(259,'uCL-cCa-Llt-8EP','Hassi Berkane',0,'2023-08-05 10:52:10','2023-08-05 10:52:10'),(260,'4Hi-3A0-XJy-tPe','Hattane',0,'2023-08-05 10:52:10','2023-08-05 10:52:10'),(261,'QcQ-pFh-yOP-QnZ','Houara Oulad Raho',0,'2023-08-05 10:52:10','2023-08-05 10:52:10'),(262,'1k7-Ktr-Kv0-EsQ','Houderrane',0,'2023-08-05 10:52:10','2023-08-05 10:52:10'),(263,'GTT-Z38-Oz7-zgc','Hrara',0,'2023-08-05 10:52:10','2023-08-05 10:52:10'),(264,'X6j-idT-xu3-OIE','Iferni',0,'2023-08-05 10:52:10','2023-08-05 10:52:10'),(265,'qnm-hZu-8UR-1bi','Ifrane',0,'2023-08-05 10:52:10','2023-08-05 10:52:10'),(266,'QB9-9IM-a0j-S2T','Ifrane Atlas Saghir',0,'2023-08-05 10:52:10','2023-08-05 10:52:10'),(267,'RV9-X6T-QXS-KSC','Ighrem N\'ougdal',0,'2023-08-05 10:52:10','2023-08-05 10:52:10'),(268,'de4-rgZ-g68-pws','Ijoukak',0,'2023-08-05 10:52:10','2023-08-05 10:52:10'),(269,'Zy7-Bwr-a9I-qy6','Imider',0,'2023-08-05 10:52:10','2023-08-05 10:52:10'),(270,'V5E-7AD-OCj-NcJ','Imindounit',0,'2023-08-05 10:52:10','2023-08-05 10:52:10'),(271,'MiK-Lhb-qnZ-WuL','Imintanoute',0,'2023-08-05 10:52:10','2023-08-05 10:52:10'),(272,'SvS-gwP-Lx9-tTd','Imlil',0,'2023-08-05 10:52:10','2023-08-05 10:52:10'),(273,'ZNU-ltD-Dvs-VR5','Imoulass',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(274,'AjC-oCe-ShQ-nzb','Imouzzer',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(275,'Atq-Jk0-yg4-LIF','Imouzzer Marmoucha',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(276,'u3Q-bXO-eEW-0eh','Imouzzer-Kendar',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(277,'qji-sNF-2Fu-CGQ','Imrabten',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(278,'Nbz-Idh-J2u-nwv','Imsouane',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(279,'DEM-1Jx-Pvs-9vk','Imzouren',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(280,'j5G-VrS-Smo-Mif','Inchaden',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(281,'fhR-cKl-waO-inh','Inzegan',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(282,'azc-Vdt-Xu0-DnP','Iqaddar',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(283,'QN3-RlA-tIu-cuu','Irohalen',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(284,'q4o-VDj-MFZ-vLE','Issafen',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(285,'NMi-N2U-64J-8YP','Issaguen',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(286,'imf-cCl-DuF-lJJ','Issen',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(287,'q5p-N6v-ZPN-EWt','Itzer',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(288,'nyg-MP5-Fbo-BN0','Izemmouren',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(289,'HLx-I0H-EMi-uGM','Jaadar',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(290,'dkO-wQY-Skt-x35','Jaidate',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(291,'MGc-9X1-ROn-ZDE','Jamaat Shaim',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(292,'yIV-Ap6-8Ns-DJr','Jbel Lahbib',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(293,'djg-VMu-n3b-Vyu','Jemaa Shaim',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(294,'LHf-vQr-gf6-5by','Jorf',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(295,'ssE-33l-nzK-Xm5','Jorf El Melha',0,'2023-08-05 10:52:11','2023-08-05 10:52:11'),(296,'Khj-hEt-nfg-Vyc','Jrada',0,'2023-08-05 10:52:12','2023-08-05 10:52:12'),(297,'0DJ-7uZ-bOR-XCL','Kalaat M\'gouna',0,'2023-08-05 10:52:12','2023-08-05 10:52:12'),(298,'Q8v-EtF-HUR-yO6','Kandar Sidi Khiar',0,'2023-08-05 10:52:12','2023-08-05 10:52:12'),(299,'9V1-iFL-erD-CzQ','Karia Ba Mohamed',0,'2023-08-05 10:52:12','2023-08-05 10:52:12'),(300,'Tk8-Y6o-6Xu-AtM','Kasba Tadla',0,'2023-08-05 10:52:12','2023-08-05 10:52:12'),(301,'K0J-M3V-jmU-lCD','Kattara',0,'2023-08-05 10:52:12','2023-08-05 10:52:12'),(302,'bwa-d5u-lPj-95w','Kechoula',0,'2023-08-05 10:52:12','2023-08-05 10:52:12'),(303,'YzC-4aK-IjB-dUK','Kénitra',1,'2023-08-05 10:52:12','2023-08-05 10:52:12'),(304,'Xbq-0t5-N0f-FT6','Ketama',0,'2023-08-05 10:52:12','2023-08-05 10:52:12'),(305,'PW2-56T-hUx-HmP','Khemis Sidi Yahya',0,'2023-08-05 10:52:12','2023-08-05 10:52:12'),(306,'LXl-qGX-LGM-Ojz','Khemisset',0,'2023-08-05 10:52:12','2023-08-05 10:52:12'),(307,'N2T-z5f-U6q-nyV','Khemisset Chaouia',0,'2023-08-05 10:52:12','2023-08-05 10:52:12'),(308,'sGB-CWx-pqg-7mW','Khénifra',0,'2023-08-05 10:52:12','2023-08-05 10:52:12'),(309,'acP-idv-yxJ-dpt','Khmis Ksiba',0,'2023-08-05 10:52:12','2023-08-05 10:52:12'),(310,'ceg-ulZ-2Wj-gYd','Khouribga',1,'2023-08-05 10:52:12','2023-08-05 10:52:12'),(311,'5mE-fAP-20s-qcc','Korimate',0,'2023-08-05 10:52:12','2023-08-05 10:52:12'),(312,'lCj-gii-7Aa-dI9','Kridid',0,'2023-08-05 10:52:12','2023-08-05 10:52:12'),(313,'guD-jUe-RzK-Ne9','Ksabi Moulouya',0,'2023-08-05 10:52:12','2023-08-05 10:52:12'),(314,'rcD-3sh-RuZ-ynG','Ksar el-Kebir',0,'2023-08-05 10:52:12','2023-08-05 10:52:12'),(315,'ohP-4ke-zn1-W5s','Ksar es-Seghir',0,'2023-08-05 10:52:12','2023-08-05 10:52:12'),(316,'D6d-Jpl-LG4-RMK','Laaouama',0,'2023-08-05 10:52:13','2023-08-05 10:52:13'),(317,'Ie3-pe8-taP-mLb','Laaounate',0,'2023-08-05 10:52:13','2023-08-05 10:52:13'),(318,'nhC-Xjx-moo-7JM','Laatamna',0,'2023-08-05 10:52:13','2023-08-05 10:52:13'),(319,'l1s-9hM-QWg-dPC','Laattaouia',0,'2023-08-05 10:52:13','2023-08-05 10:52:13'),(320,'Ca1-478-zPM-59X','Laattaouia Ech-Chaybia',0,'2023-08-05 10:52:13','2023-08-05 10:52:13'),(321,'7w4-uCI-Awa-kre','Laâyoune',0,'2023-08-05 10:52:13','2023-08-05 10:52:13'),(322,'3Oj-zY5-FX7-ok6','Laäyoune Ain Tizgha',0,'2023-08-05 10:52:13','2023-08-05 10:52:13'),(323,'wfe-ofC-V99-S0w','Lagfifat',0,'2023-08-05 10:52:13','2023-08-05 10:52:13'),(324,'ZuZ-tpE-9rU-boc','Laghnimyine',0,'2023-08-05 10:52:13','2023-08-05 10:52:13'),(325,'VEj-EOj-aPh-AoH','Laghoualem',0,'2023-08-05 10:52:13','2023-08-05 10:52:13'),(326,'lY9-I8K-gDf-i7J','Lagouira',0,'2023-08-05 10:52:14','2023-08-05 10:52:14'),(327,'8pt-nsr-QhG-Iwh','Lahraouyine',0,'2023-08-05 10:52:14','2023-08-05 10:52:14'),(328,'xgK-VKt-ZqS-DvX','Lakhiaita',0,'2023-08-05 10:52:14','2023-08-05 10:52:14'),(329,'X0H-qEq-0yA-dSf','Lakhnafif',0,'2023-08-05 10:52:14','2023-08-05 10:52:14'),(330,'95p-Iqk-kh2-kPX','Lakhoualqa',0,'2023-08-05 10:52:14','2023-08-05 10:52:14'),(331,'V0U-OFJ-4x1-P0h','Lakhssas',0,'2023-08-05 10:52:14','2023-08-05 10:52:14'),(332,'Dai-F80-0jh-DLZ','Lamaachate',0,'2023-08-05 10:52:14','2023-08-05 10:52:14'),(333,'Hrt-4Vp-nXB-nQj','Lamhadi',0,'2023-08-05 10:52:14','2023-08-05 10:52:14'),(334,'qrt-gNV-lLQ-rd5','Lamharza Essahel',0,'2023-08-05 10:52:14','2023-08-05 10:52:14'),(335,'rgx-mfM-tv7-RgZ','Lamkansa',0,'2023-08-05 10:52:14','2023-08-05 10:52:14'),(336,'0Mh-5XC-oS5-BOn','Laouamra',0,'2023-08-05 10:52:14','2023-08-05 10:52:14'),(337,'UzE-QKD-fj4-Ge3','Larache',0,'2023-08-05 10:52:14','2023-08-05 10:52:14'),(338,'swJ-bHd-KLO-Bas','Lkhaloua',0,'2023-08-05 10:52:14','2023-08-05 10:52:14'),(339,'Ynr-soq-Aly-gqM','Lkheng',0,'2023-08-05 10:52:14','2023-08-05 10:52:14'),(340,'l4g-UpE-Jnt-Xsk','Loudaya',0,'2023-08-05 10:52:15','2023-08-05 10:52:15'),(341,'Rc3-o6x-DRz-4VB','Loulad',0,'2023-08-05 10:52:15','2023-08-05 10:52:15'),(342,'GlH-xgB-Byh-gfL','Louta',0,'2023-08-05 10:52:15','2023-08-05 10:52:15'),(343,'gb2-QdU-nOd-cQV','Lqliaa',0,'2023-08-05 10:52:15','2023-08-05 10:52:15'),(344,'j7Z-Khu-dNC-ZoO','M\'hamid El Ghizlane',0,'2023-08-05 10:52:15','2023-08-05 10:52:15'),(345,'AVB-N5u-Lsh-uj2','M\'haya',0,'2023-08-05 10:52:15','2023-08-05 10:52:15'),(346,'1sR-wVz-ku4-ndP','M\'qam Tobla',0,'2023-08-05 10:52:15','2023-08-05 10:52:15'),(347,'XE1-V2B-NUq-FkQ','M\'sick',0,'2023-08-05 10:52:15','2023-08-05 10:52:15'),(348,'tNK-Wup-RGa-Hzv','Maaziz',0,'2023-08-05 10:52:15','2023-08-05 10:52:15'),(349,'qPg-pV1-Zq9-L9i','Machraa El Ain',0,'2023-08-05 10:52:15','2023-08-05 10:52:15'),(350,'xaJ-loK-Zkp-lXy','Madagh',0,'2023-08-05 10:52:15','2023-08-05 10:52:15'),(351,'xlq-AHx-pwO-Dc1','Majjat',0,'2023-08-05 10:52:15','2023-08-05 10:52:15'),(352,'Pqz-FY4-DmS-Rc2','Mallalienne',0,'2023-08-05 10:52:15','2023-08-05 10:52:15'),(353,'VFA-eiB-eTF-3yF','Mansoura',0,'2023-08-05 10:52:15','2023-08-05 10:52:15'),(354,'Lu8-6c5-kpF-zig','Marchouch',0,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(355,'bnn-tqz-1wO-zlV','Marrakech',1,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(356,'lTP-csZ-0QF-dwS','Martil',0,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(357,'SEc-cBs-Saa-IZU','Massa',0,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(358,'ZIQ-wZY-dMl-N0k','Mdiq',0,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(359,'St6-LdV-SFa-N3l','Méchouar Fès Jdid',0,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(360,'bIn-oyt-iIH-nUI','Méchouar Kasba',0,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(361,'9HG-7UZ-5Ev-Ry3','Mechra Bel Ksiri',0,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(362,'VvN-UiH-GKx-o2i','Mediouna',0,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(363,'5uW-hIF-B5V-GQx','Mehdia',0,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(364,'k28-5eB-dXt-HjB','Meknassa Acharqia',0,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(365,'fwK-XKa-aWh-D9J','Meknassa Al Gharbia',0,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(366,'ewn-Ytd-bGe-WGN','Meknès',1,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(367,'DtA-DVP-KFl-pX3','Mellila',0,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(368,'OW0-bMT-SGS-d4u','Mers El Kheir',0,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(369,'jb8-nmy-WnD-K6o','Merzouga',0,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(370,'1o7-2iB-eOb-F89','Messassa',0,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(371,'xke-v9z-FqR-z4z','Mestegmer',0,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(372,'58R-7fR-bvV-fkD','Mestferki',0,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(373,'Bzv-qVC-WZ2-H93','Midar',0,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(374,'6lW-zBJ-dxt-DKZ','Midelt',0,'2023-08-05 10:52:16','2023-08-05 10:52:16'),(375,'hvM-lK8-3Ea-2Pi','Mirleft',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(376,'Usv-JuY-27J-2Mg','Missour',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(377,'dI7-6OJ-sFA-aud','Mkansa',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(378,'GRD-h79-pZX-LXm','Mograne',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(379,'qFQ-BpZ-c5g-i0x','Mohammedia',1,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(380,'EXM-alZ-wgX-hWC','Moualine El Oued',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(381,'NHq-r9N-Wg2-V4J','Moulay Abdallah',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(382,'hlt-lJ6-wW0-4vP','Moulay Bouazza',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(383,'YIk-yri-tD6-98e','Moulay Bousselham',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(384,'se1-NzU-FGM-MaK','Moulay Bouzarqtoune',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(385,'OEI-1Bb-Twj-ywJ','Moulay Driss Aghbal',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(386,'z5Y-Eon-FB3-ktg','Moulay Driss Zerhoun',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(387,'B7f-IDw-W5C-FXH','Moulay Yaâcoub',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(388,'RG8-5GS-J5j-22n','Moulay Yaccoub',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(389,'fjb-8bz-b91-oi8','Mrir\'t',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(390,'x3i-TKS-ruR-Bci','N\'khila',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(391,'ICp-kEE-aDP-iXz','Nador',1,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(392,'Zv6-czp-4ir-jNw','Naima',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(393,'gxg-yz4-1BB-H1e','Naour',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(394,'1Zi-4o2-PRh-7LB','Nouaceur',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(395,'KWL-2cZ-NFE-fek','Ouad Eddahab',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(396,'kbA-QjB-NJI-obK','Ouahat Sidi Brahim',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(397,'cR3-IYl-tFA-Fcg','Ouaklim',0,'2023-08-05 10:52:17','2023-08-05 10:52:17'),(398,'9jI-22G-FoX-OSA','Oualidia',0,'2023-08-05 10:52:18','2023-08-05 10:52:18'),(399,'Lw9-FmS-59c-yWQ','Oualili',0,'2023-08-05 10:52:18','2023-08-05 10:52:18'),(400,'jc5-lUa-WYW-971','Ouaouizeght',0,'2023-08-05 10:52:18','2023-08-05 10:52:18'),(401,'dYP-2GH-Ulf-z6W','Ouaoumana',0,'2023-08-05 10:52:18','2023-08-05 10:52:18'),(402,'WaT-qkR-hDc-8BW','Ouaouzgane',0,'2023-08-05 10:52:18','2023-08-05 10:52:18'),(403,'mTJ-TaA-2ZD-B9L','Ouarzazate',0,'2023-08-05 10:52:18','2023-08-05 10:52:18'),(404,'4eC-L79-G64-TKU','Ouazzane',0,'2023-08-05 10:52:18','2023-08-05 10:52:18'),(405,'LS3-YzU-Wsl-u4r','Oued Amlil',0,'2023-08-05 10:52:18','2023-08-05 10:52:18'),(406,'8PC-BXS-r9E-OXV','Oued Ifrane',0,'2023-08-05 10:52:18','2023-08-05 10:52:18'),(407,'7aS-8uq-1jc-uyL','Oued Jdida',0,'2023-08-05 10:52:18','2023-08-05 10:52:18'),(408,'zTF-k7r-3rP-DaJ','Oued Laou',0,'2023-08-05 10:52:18','2023-08-05 10:52:18'),(409,'BN6-n4n-Pfp-Ye0','Oued Malha',0,'2023-08-05 10:52:18','2023-08-05 10:52:18'),(410,'Bzz-668-i71-iNN','Oued Zem',0,'2023-08-05 10:52:18','2023-08-05 10:52:18'),(411,'IiQ-y6F-NRo-4yW','Ouirgane',0,'2023-08-05 10:52:19','2023-08-05 10:52:19'),(412,'22M-Ik5-m2h-fiu','Ouislane',0,'2023-08-05 10:52:19','2023-08-05 10:52:19'),(413,'hhd-48I-a6x-n1l','Oujda',1,'2023-08-05 10:52:19','2023-08-05 10:52:19'),(414,'kMv-E3U-Sg6-wYH','Oukaimden',0,'2023-08-05 10:52:19','2023-08-05 10:52:19'),(415,'fS6-jIg-EuJ-suC','Oulad Abbou',0,'2023-08-05 10:52:19','2023-08-05 10:52:19'),(416,'rFW-6Hz-iA1-PQ5','Oulad Aissa',0,'2023-08-05 10:52:19','2023-08-05 10:52:19'),(417,'bsd-TEA-FSB-3Px','Oulad Al Toualaa',0,'2023-08-05 10:52:19','2023-08-05 10:52:19'),(418,'Ss2-H5e-HkY-5pB','Oulad Dahou',0,'2023-08-05 10:52:19','2023-08-05 10:52:19'),(419,'khN-HUs-nfv-cY1','Oulad Fares',0,'2023-08-05 10:52:19','2023-08-05 10:52:19'),(420,'sle-BGv-uOA-pl3','Oulad Frej',0,'2023-08-05 10:52:19','2023-08-05 10:52:19'),(421,'ESz-P2h-97D-SKu','Oulad Ftata',0,'2023-08-05 10:52:19','2023-08-05 10:52:19'),(422,'uny-mEC-A2f-qXm','Oulad Ghanem',0,'2023-08-05 10:52:19','2023-08-05 10:52:19'),(423,'6qU-1e6-YkO-iM2','Oulad Hamdane',0,'2023-08-05 10:52:19','2023-08-05 10:52:19'),(424,'zNI-FcY-8cR-Im6','Oulad Hcine',0,'2023-08-05 10:52:19','2023-08-05 10:52:19'),(425,'0so-AhS-LhR-HZv','Oulad M\'barek',0,'2023-08-05 10:52:20','2023-08-05 10:52:20'),(426,'7ye-8s3-39l-DEw','Oulad M\'rah',0,'2023-08-05 10:52:20','2023-08-05 10:52:20'),(427,'HfH-dDi-Ahb-rXG','Oulad Mtaa',0,'2023-08-05 10:52:20','2023-08-05 10:52:20'),(428,'z5U-rt4-KZ5-51F','Oulad Said',0,'2023-08-05 10:52:20','2023-08-05 10:52:20'),(429,'Pkf-NbY-q8r-KOf','Oulad Said L\'oued',0,'2023-08-05 10:52:20','2023-08-05 10:52:20'),(430,'l0T-JRF-8zf-gaH','Oulad Salah',0,'2023-08-05 10:52:20','2023-08-05 10:52:20'),(431,'DIs-sy7-VkD-rCO','Oulad Yahya Louta',0,'2023-08-05 10:52:20','2023-08-05 10:52:20'),(432,'Z5N-pbf-a2l-lDk','Oulad Yaich',0,'2023-08-05 10:52:20','2023-08-05 10:52:20'),(433,'AD1-AzW-z00-CrR','Oulad Youssef',0,'2023-08-05 10:52:20','2023-08-05 10:52:20'),(434,'nXA-RNz-CEp-Wvv','Oulad Zidane',0,'2023-08-05 10:52:20','2023-08-05 10:52:20'),(435,'XkV-bv8-9Xl-kz6','Ouled Ayad',0,'2023-08-05 10:52:20','2023-08-05 10:52:20'),(436,'lkj-zrq-Fyb-UJ0','Ouled Berhil',0,'2023-08-05 10:52:20','2023-08-05 10:52:20'),(437,'VDm-7Zo-jvv-XVg','Ouled Dlim',0,'2023-08-05 10:52:20','2023-08-05 10:52:20'),(438,'QR2-C23-Exe-Qjq','Ouled Frej',0,'2023-08-05 10:52:20','2023-08-05 10:52:20'),(439,'kn9-1Xc-wfG-1LZ','Ouled Teïma',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(440,'7KS-gG9-eJD-Vuo','Oulmes',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(441,'CQr-Vha-GEJ-1T9','Ounagha',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(442,'pNv-75x-2fI-pS0','Ourika',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(443,'j8a-JJw-9gZ-Ov9','Outat El Haj',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(444,'gM0-QMr-gf8-jst','Rabat',1,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(445,'it7-52o-C2e-WT8','Ras Ain Rhamna',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(446,'99I-zar-sJs-dEa','Ras El Ain',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(447,'Ke4-14o-oS7-ln7','Ras Ijerri',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(448,'0D2-koQ-wiR-Evc','Ratba',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(449,'iGC-9no-BJr-37u','Rfala',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(450,'Wlz-O7h-nSe-JVQ','Ribat el Kheir',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(451,'5rT-x78-8xs-pp4','Rima',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(452,'Lie-OMJ-INC-FDP','Rissana Janoubia',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(453,'PBh-LaY-Ogc-Xhb','Rissani',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(454,'Qez-Rft-yCL-elS','Rommani',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(455,'9EP-QJE-0lT-tMD','Saada',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(456,'tb7-zZ5-2zD-zuE','Saadla',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(457,'X4F-o4v-YNv-Waq','Sabaa Aiyoun',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(458,'ZXa-JxF-bnx-1ey','Sabbah',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(459,'NjZ-2cZ-izI-sOm','Safi',1,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(460,'0Te-LuA-09F-Qk5','Sahel Chamali',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(461,'1si-UVF-JbY-QFo','Sahel Oulad H\'riz',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(462,'sGG-QL5-QYl-lp5','Saidia',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(463,'Y2x-Rr4-RMa-RHE','Saka',0,'2023-08-05 10:52:21','2023-08-05 10:52:21'),(464,'mbb-muw-zAA-nHi','Salé',1,'2023-08-05 10:52:22','2023-08-05 10:52:22'),(465,'XSv-Xk8-KsD-sGA','Sbouya',0,'2023-08-05 10:52:22','2023-08-05 10:52:22'),(466,'jED-9uE-hn3-vN0','Sebt Ennabour',0,'2023-08-05 10:52:22','2023-08-05 10:52:22'),(467,'9Ge-upJ-0nZ-5UP','Sebt Gzoula',0,'2023-08-05 10:52:22','2023-08-05 10:52:22'),(468,'5jE-Rvx-RM6-Fm9','Sefrou',0,'2023-08-05 10:52:22','2023-08-05 10:52:22'),(469,'unK-pVC-Hlf-Qs6','Selouane',0,'2023-08-05 10:52:22','2023-08-05 10:52:22'),(470,'YBb-NIB-R0C-tDw','Settat',1,'2023-08-05 10:52:22','2023-08-05 10:52:22'),(471,'ZMj-xlT-dbH-IOv','Sfassif',0,'2023-08-05 10:52:22','2023-08-05 10:52:22'),(472,'I5m-YDq-TZu-9f8','Sid L\'mokhtar',0,'2023-08-05 10:52:22','2023-08-05 10:52:22'),(473,'dwO-vzz-ppZ-9Wc','Sid Zouine',0,'2023-08-05 10:52:22','2023-08-05 10:52:22'),(474,'p3O-VKI-LfT-9Rt','Sidi Abdallah El Bouchouari',0,'2023-08-05 10:52:22','2023-08-05 10:52:22'),(475,'ZL6-yBJ-qhJ-Nb0','Sidi Abdallah Ghiat',0,'2023-08-05 10:52:22','2023-08-05 10:52:22'),(476,'2k5-PJo-pHP-IUK','Sidi Abderrazak',0,'2023-08-05 10:52:22','2023-08-05 10:52:22'),(477,'7GX-yep-G7E-wDz','Sidi Abed',0,'2023-08-05 10:52:22','2023-08-05 10:52:22'),(478,'HuI-mNf-WIn-ZS7','Sidi Ahmed Ou Amar',0,'2023-08-05 10:52:22','2023-08-05 10:52:22'),(479,'wBt-N35-Tlc-n4w','Sidi Aissa Ben Ali',0,'2023-08-05 10:52:22','2023-08-05 10:52:22'),(480,'lx8-OaE-xlx-XbD','Sidi Aissa Ben Slimane',0,'2023-08-05 10:52:22','2023-08-05 10:52:22'),(481,'fvv-CGB-3DE-8ZH','Sidi Ali',0,'2023-08-05 10:52:22','2023-08-05 10:52:22'),(482,'cXf-4F6-N4r-gqQ','Sidi Ali Ben Hamdouche',0,'2023-08-05 10:52:22','2023-08-05 10:52:22'),(483,'a9q-3i8-Q7q-Dt2','Sidi Allal El Bahraoui',0,'2023-08-05 10:52:22','2023-08-05 10:52:22'),(484,'wWI-qWj-lPQ-Tl3','Sidi Allal Tazi',0,'2023-08-05 10:52:23','2023-08-05 10:52:23'),(485,'LrU-pcD-6EQ-EUr','Sidi Bennour',0,'2023-08-05 10:52:23','2023-08-05 10:52:23'),(486,'mZJ-5bk-n8s-8Uw','Sidi Bettache',0,'2023-08-05 10:52:23','2023-08-05 10:52:23'),(487,'uvG-LNo-SLc-cUK','Sidi Bibi',0,'2023-08-05 10:52:23','2023-08-05 10:52:23'),(488,'iis-puf-q8x-wrH','Sidi Boaal',0,'2023-08-05 10:52:23','2023-08-05 10:52:23'),(489,'4eN-D9E-ItH-XGp','Sidi Bou Othmane',0,'2023-08-05 10:52:23','2023-08-05 10:52:23'),(490,'Igs-DPU-MsP-xZK','Sidi Boubker',0,'2023-08-05 10:52:23','2023-08-05 10:52:23'),(491,'l7u-fQU-6Px-LMm','Sidi Boukhalkhal',0,'2023-08-05 10:52:23','2023-08-05 10:52:23'),(492,'EFy-Xt3-iAE-9Ht','Sidi Bouknadel',0,'2023-08-05 10:52:23','2023-08-05 10:52:23'),(493,'Q7J-yyH-qav-dK5','Sidi Boulenouar',0,'2023-08-05 10:52:23','2023-08-05 10:52:23'),(494,'Gd8-hzI-VxN-WfE','Sidi Boumehdi',0,'2023-08-05 10:52:23','2023-08-05 10:52:23'),(495,'nnk-8zG-4Xv-ksE','Sidi Bouzid',0,'2023-08-05 10:52:23','2023-08-05 10:52:23'),(496,'NMW-lnZ-86P-0bl','Sidi Chiker',0,'2023-08-05 10:52:23','2023-08-05 10:52:23'),(497,'Uxb-x8S-0wz-zlU','Sidi Dahbi',0,'2023-08-05 10:52:24','2023-08-05 10:52:24'),(498,'IRl-Fpg-Tv3-YZz','Sidi El Abed',0,'2023-08-05 10:52:24','2023-08-05 10:52:24'),(499,'y49-aki-fmQ-QRi','Sidi el Aîdi',0,'2023-08-05 10:52:24','2023-08-05 10:52:24'),(500,'MwS-lKI-W83-rkO','Sidi El Makhfi',0,'2023-08-05 10:52:24','2023-08-05 10:52:24'),(501,'Lnb-CMx-Ndv-rF2','Sidi El Mekki',0,'2023-08-05 10:52:24','2023-08-05 10:52:24'),(502,'2wa-Xbg-w5K-Xil','Sidi Hajjaj',0,'2023-08-05 10:52:24','2023-08-05 10:52:24'),(503,'5Wh-srz-nD5-uU8','Sidi Hajjaj Oued Hassar',0,'2023-08-05 10:52:24','2023-08-05 10:52:24'),(504,'G26-5ac-mpR-a8h','Sidi Ifni',0,'2023-08-05 10:52:24','2023-08-05 10:52:24'),(505,'OJ5-Emf-Lq9-yO5','Sidi Jaber',0,'2023-08-05 10:52:24','2023-08-05 10:52:24'),(506,'MTB-3RL-XQR-9GL','Sidi Kacem',0,'2023-08-05 10:52:25','2023-08-05 10:52:25'),(507,'Uxm-xFO-fGC-a78','Sidi Lyamani',0,'2023-08-05 10:52:25','2023-08-05 10:52:25'),(508,'Tbx-OCH-xi5-wSc','Sidi Moussa Ben Ali',0,'2023-08-05 10:52:25','2023-08-05 10:52:25'),(509,'fg4-OvG-D0v-aYZ','Sidi Moussa El Majdoub',0,'2023-08-05 10:52:25','2023-08-05 10:52:25'),(510,'uw2-hv4-LGV-D36','Sidi Ouassay',0,'2023-08-05 10:52:25','2023-08-05 10:52:25'),(511,'mpT-6pF-RAE-r5W','Sidi Rahal',0,'2023-08-05 10:52:25','2023-08-05 10:52:25'),(512,'gNj-jjf-OWi-BlG','Sidi Slimane',0,'2023-08-05 10:52:25','2023-08-05 10:52:25'),(513,'4ww-GEE-Tny-A4g','Sidi Slimane Echcharraa',0,'2023-08-05 10:52:25','2023-08-05 10:52:25'),(514,'WMr-cGx-rA0-xOt','Sidi Smail',0,'2023-08-05 10:52:25','2023-08-05 10:52:25'),(515,'SLH-dTV-9Zt-tpv','Sidi Taibi',0,'2023-08-05 10:52:25','2023-08-05 10:52:25'),(516,'A2g-VTf-giF-a2c','Sidi Yahya',0,'2023-08-05 10:52:26','2023-08-05 10:52:26'),(517,'R6n-hcI-PIy-wPZ','Sidi Yahya El Gharb',0,'2023-08-05 10:52:26','2023-08-05 10:52:26'),(518,'On6-1vE-p3C-l9R','Sidi Yahya Zaer',0,'2023-08-05 10:52:26','2023-08-05 10:52:26'),(519,'vfE-vyH-jDM-h5z','Skhinate',0,'2023-08-05 10:52:26','2023-08-05 10:52:26'),(520,'k4s-u0d-R90-gyl','Skhirat',0,'2023-08-05 10:52:26','2023-08-05 10:52:26'),(521,'h9m-nbD-kND-rZt','Skhour Rhamna',0,'2023-08-05 10:52:26','2023-08-05 10:52:26'),(522,'9S1-2Ak-xPJ-XIV','Skoura Ahl El Oust',0,'2023-08-05 10:52:26','2023-08-05 10:52:26'),(523,'rQI-pbp-Xfa-681','Skoura M\'daz',0,'2023-08-05 10:52:26','2023-08-05 10:52:26'),(524,'lJS-qlK-m2D-qqY','Smia',0,'2023-08-05 10:52:26','2023-08-05 10:52:26'),(525,'tOm-k0q-Pvh-aT8','Souaken',0,'2023-08-05 10:52:26','2023-08-05 10:52:26'),(526,'bcr-E08-RoB-Te0','Souihla',0,'2023-08-05 10:52:26','2023-08-05 10:52:26'),(527,'n9B-Hhm-i37-2yc','Souk El Arbaa',0,'2023-08-05 10:52:26','2023-08-05 10:52:26'),(528,'dtT-NPu-TtC-FMI','Souk Sebt Ouled Nemma',0,'2023-08-05 10:52:26','2023-08-05 10:52:26'),(529,'E64-0Pa-JgO-9Hx','Souk Tlet El Gharb',0,'2023-08-05 10:52:26','2023-08-05 10:52:26'),(530,'MnV-WwR-TBG-qK8','Steha',0,'2023-08-05 10:52:26','2023-08-05 10:52:26'),(531,'WpA-1Dw-j2x-MrN','Tabant',0,'2023-08-05 10:52:26','2023-08-05 10:52:26'),(532,'iD5-rRB-qvW-obB','Tabouda',0,'2023-08-05 10:52:26','2023-08-05 10:52:26'),(533,'RmK-taE-WCI-8xI','Tachraft',0,'2023-08-05 10:52:26','2023-08-05 10:52:26'),(534,'ThS-5LH-ELu-tXl','Tadighoust',0,'2023-08-05 10:52:27','2023-08-05 10:52:27'),(535,'upF-56i-Xxw-3Nv','Tafersit',0,'2023-08-05 10:52:27','2023-08-05 10:52:27'),(536,'Wl2-2gq-gBi-ypT','Tafoughalt',0,'2023-08-05 10:52:27','2023-08-05 10:52:27'),(537,'E6s-5yn-I0K-pIe','Tafraout',0,'2023-08-05 10:52:27','2023-08-05 10:52:27'),(538,'N0J-5JB-vpl-o7L','Tagante',0,'2023-08-05 10:52:27','2023-08-05 10:52:27'),(539,'xT5-Ptq-MRi-2lb','Taghazout',0,'2023-08-05 10:52:27','2023-08-05 10:52:27'),(540,'Hod-UkD-ChT-nzO','Taghzout',0,'2023-08-05 10:52:27','2023-08-05 10:52:27'),(541,'Ivy-ty1-gSM-ZhY','Taghzoute N\'ait Atta',0,'2023-08-05 10:52:27','2023-08-05 10:52:27'),(542,'zgZ-TRU-Qai-8dy','Tahannaout',0,'2023-08-05 10:52:27','2023-08-05 10:52:27'),(543,'pwI-z8z-iaD-O7s','Tahla',0,'2023-08-05 10:52:27','2023-08-05 10:52:27'),(544,'erE-1Oi-ojB-3kX','Takate',0,'2023-08-05 10:52:27','2023-08-05 10:52:27'),(545,'gxG-yWS-gd9-QdV','Talat N\'yaaqoub',0,'2023-08-05 10:52:27','2023-08-05 10:52:27'),(546,'7n6-Rr9-JBe-B7S','Taliouine',0,'2023-08-05 10:52:27','2023-08-05 10:52:27'),(547,'I6U-3yC-FMa-0kZ','Talmakante',0,'2023-08-05 10:52:27','2023-08-05 10:52:27'),(548,'f1j-RYm-3sa-LUb','Talmest',0,'2023-08-05 10:52:27','2023-08-05 10:52:27'),(549,'5U5-0oy-TrF-aT0','Talsint',0,'2023-08-05 10:52:27','2023-08-05 10:52:27'),(550,'pkv-Beg-txH-OOb','Tamallalt',0,'2023-08-05 10:52:27','2023-08-05 10:52:27'),(551,'cTd-ma0-Gpu-sUZ','Tamaris',0,'2023-08-05 10:52:27','2023-08-05 10:52:27'),(552,'QHm-LmH-KLv-1XW','Tamazouzte',0,'2023-08-05 10:52:28','2023-08-05 10:52:28'),(553,'ZDV-kAF-Xt3-FxF','Tamedit',0,'2023-08-05 10:52:28','2023-08-05 10:52:28'),(554,'NKs-pkO-Y0B-u0G','Tamensourt',0,'2023-08-05 10:52:28','2023-08-05 10:52:28'),(555,'7zk-2Bh-p4d-7LQ','Tameslohte',0,'2023-08-05 10:52:28','2023-08-05 10:52:28'),(556,'cOK-SPI-Jcf-s4s','Tamesna',0,'2023-08-05 10:52:28','2023-08-05 10:52:28'),(557,'Fig-G80-qVY-tH1','Tamezmoute',0,'2023-08-05 10:52:28','2023-08-05 10:52:28'),(558,'X2n-j4q-UVQ-qzT','Tamorot',0,'2023-08-05 10:52:28','2023-08-05 10:52:28'),(559,'wqk-Xge-82d-evI','Tamouda Bay',0,'2023-08-05 10:52:28','2023-08-05 10:52:28'),(560,'UGM-Euj-0NV-E8N','Tamri',0,'2023-08-05 10:52:28','2023-08-05 10:52:28'),(561,'2PX-ADm-RGx-FQF','Tamsaout',0,'2023-08-05 10:52:28','2023-08-05 10:52:28'),(562,'J6S-vuX-0YW-HNq','Tan-Tan',0,'2023-08-05 10:52:28','2023-08-05 10:52:28'),(563,'f4k-K90-PGf-MeU','Tanant',0,'2023-08-05 10:52:28','2023-08-05 10:52:28'),(564,'0wY-apN-mko-fCC','Tangarfa',0,'2023-08-05 10:52:28','2023-08-05 10:52:28'),(565,'PuE-vc6-SYS-Ucq','Tanger',1,'2023-08-05 10:52:28','2023-08-05 10:52:28'),(566,'yOw-mDg-l1Q-X9g','Taounate',0,'2023-08-05 10:52:28','2023-08-05 10:52:28'),(567,'yt7-quk-Ecf-AA0','Taourirt',0,'2023-08-05 10:52:28','2023-08-05 10:52:28'),(568,'Mry-UJX-nEj-QXK','Tarfaya',0,'2023-08-05 10:52:28','2023-08-05 10:52:28'),(569,'mpz-z09-CrJ-CCi','Targuist',0,'2023-08-05 10:52:28','2023-08-05 10:52:28'),(570,'zWC-8BF-rmk-IBQ','Taroudant',0,'2023-08-05 10:52:28','2023-08-05 10:52:28'),(571,'wvN-rsU-xvR-0y2','Tassoultante',0,'2023-08-05 10:52:28','2023-08-05 10:52:28'),(572,'HYJ-IHx-5ef-Dar','Tata',0,'2023-08-05 10:52:29','2023-08-05 10:52:29'),(573,'1Cg-n3s-ntg-JET','Tataoute',0,'2023-08-05 10:52:29','2023-08-05 10:52:29'),(574,'5Zo-mxK-tO6-qTZ','Tatoft',0,'2023-08-05 10:52:29','2023-08-05 10:52:29'),(575,'8a1-Pmy-PHQ-v5x','Taza',0,'2023-08-05 10:52:29','2023-08-05 10:52:29'),(576,'htA-06r-RMO-8tu','Tazart',0,'2023-08-05 10:52:29','2023-08-05 10:52:29'),(577,'BMK-53D-5Ac-nZe','Tazemmourt',0,'2023-08-05 10:52:29','2023-08-05 10:52:29'),(578,'Wqi-iun-RVG-f8x','Taznakht',0,'2023-08-05 10:52:29','2023-08-05 10:52:29'),(579,'jog-M6r-oeA-Fpf','Temara',1,'2023-08-05 10:52:29','2023-08-05 10:52:29'),(580,'G0k-WS5-McD-QAV','Temsamane',0,'2023-08-05 10:52:29','2023-08-05 10:52:29'),(581,'Vr7-9k5-IVC-DBY','Temsia',0,'2023-08-05 10:52:29','2023-08-05 10:52:29'),(582,'8BB-PzF-GuJ-VEW','Tendrara',0,'2023-08-05 10:52:29','2023-08-05 10:52:29'),(583,'pJm-8Wi-Mbq-2VF','Tétouan',1,'2023-08-05 10:52:29','2023-08-05 10:52:29'),(584,'bBE-Enf-slz-yRf','Thar Es-Souk',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(585,'QOJ-5BA-hQw-wxe','Tichla',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(586,'Ber-0l6-83Y-0vt','Tiddas',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(587,'oKL-v8P-Jso-OXA','Tifarouine',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(588,'W37-2hD-645-fdp','Tifelt',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(589,'N6V-TEn-UE5-coa','Tighirt',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(590,'UN6-B4H-jba-Zwq','Tikiouine',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(591,'nTv-ikn-vPe-4lF','Timahdite',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(592,'07H-LPP-drd-Xwz','Timoulay',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(593,'kGA-SiL-75h-pRN','Timoulilt',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(594,'3Sv-fDV-qge-Xge','Tinejdad',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(595,'Oa0-L05-zyq-Drs','Tinghir',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(596,'0kJ-O3g-zbp-eCS','Tissa',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(597,'B6i-pMa-WTQ-g1d','Tit Mellil',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(598,'8Ly-5Ep-ed9-RO2','Tizgane',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(599,'CsC-8oS-g6F-nNt','Tiznit',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(600,'Vjc-KYa-HS0-qXh','Tlite',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(601,'sfW-DUa-dR5-gzU','Tnine Aglou',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(602,'MTg-58T-Z50-KAY','Touama',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(603,'LKH-Ggo-i6g-5Sa','Touissit',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(604,'tpR-Fj4-7A3-q91','Tsaft',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(605,'CqF-UJ4-92n-V8N','Youssoufia',0,'2023-08-05 10:52:30','2023-08-05 10:52:30'),(606,'SwY-KZN-5qu-fZd','Zag',0,'2023-08-05 10:52:31','2023-08-05 10:52:31'),(607,'Lwq-eju-Otl-BjS','Zagora',0,'2023-08-05 10:52:31','2023-08-05 10:52:31'),(608,'kv3-KVo-Eg6-mjH','Zaida',0,'2023-08-05 10:52:31','2023-08-05 10:52:31'),(609,'JsC-9Tb-Rni-V4j','Zaïo',0,'2023-08-05 10:52:31','2023-08-05 10:52:31'),(610,'x13-qbE-7Sc-3oZ','Zaouia Sidi Tahar',0,'2023-08-05 10:52:31','2023-08-05 10:52:31'),(611,'408-aaX-Qcw-enc','Zaouïat Cheikh',0,'2023-08-05 10:52:31','2023-08-05 10:52:31'),(612,'XbJ-viM-CNO-uIM','Zaouiat Sidi Kacem',0,'2023-08-05 10:52:31','2023-08-05 10:52:31'),(613,'MFG-pR5-5Jb-Nsr','Zeghanghane',0,'2023-08-05 10:52:31','2023-08-05 10:52:31'),(614,'vkV-61J-DvG-LWH','Zemamra',0,'2023-08-05 10:52:31','2023-08-05 10:52:31'),(615,'rs0-bhT-5ez-Xbw','Zemrane',0,'2023-08-05 10:52:31','2023-08-05 10:52:31'),(616,'Dic-RTq-vh4-4Gy','Ziaida',0,'2023-08-05 10:52:31','2023-08-05 10:52:31'),(617,'hNg-C4o-1NH-7bf','Zoug',0,'2023-08-05 10:52:31','2023-08-05 10:52:31'),(618,'S0A-LYe-9c8-7qM','Zoumi',0,'2023-08-05 10:52:31','2023-08-05 10:52:31');

--
-- Table structure for table `comments`
--

CREATE TABLE `comments` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `offer_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `text` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `stars` tinyint(4) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `comments_uid_unique` (`uid`),
  KEY `comments_offer_id_foreign` (`offer_id`),
  KEY `comments_user_id_foreign` (`user_id`),
  CONSTRAINT `comments_offer_id_foreign` FOREIGN KEY (`offer_id`) REFERENCES `offers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `comments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `comments`
--


--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `failed_jobs`
--


--
-- Table structure for table `favorites`
--

CREATE TABLE `favorites` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `offer_id` bigint(20) unsigned NOT NULL,
  `user_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `favorites_uid_unique` (`uid`),
  KEY `favorites_offer_id_foreign` (`offer_id`),
  KEY `favorites_user_id_foreign` (`user_id`),
  CONSTRAINT `favorites_offer_id_foreign` FOREIGN KEY (`offer_id`) REFERENCES `offers` (`id`) ON DELETE CASCADE,
  CONSTRAINT `favorites_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `favorites`
--


--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (60,'2014_09_17_123011_create_cities_table',1),(61,'2014_09_17_123047_create_categories_table',1),(62,'2014_10_12_000000_create_users_table',1),(63,'2014_10_12_100000_create_password_resets_table',1),(64,'2019_08_19_000000_create_failed_jobs_table',1),(65,'2023_03_27_103441_create_roles_table',1),(66,'2023_03_27_103452_create_attachments_table',1),(67,'2023_03_27_103629_create_role_user_table',1),(68,'2023_04_03_121859_create_offers_table',1),(69,'2023_06_13_155652_create_quotations_table',1),(70,'2023_07_21_154316_create_comments_table',1),(71,'2023_07_24_133008_create_favorites_table',1),(72,'2023_07_28_141618_create_category_user_table',1),(73,'2019_12_14_000001_create_personal_access_tokens_table',2);

--
-- Table structure for table `offers`
--

CREATE TABLE `offers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `titre` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci,
  `video` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `user_id` bigint(20) unsigned NOT NULL,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `offers_uid_unique` (`uid`),
  KEY `offers_user_id_foreign` (`user_id`),
  KEY `offers_category_id_foreign` (`category_id`),
  CONSTRAINT `offers_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL,
  CONSTRAINT `offers_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `offers`
--

INSERT INTO `offers` VALUES (4,'kWU-tvh-dCP-PAw','Test','Des','https://www.youtube.com/watch?v=qQ0iatmHWFM',1,3,2,'2023-09-08 13:08:19','2023-09-08 13:08:19',NULL),(5,'uwt-kn9-ASU-miw','Test','Des','https://www.youtube.com/watch?v=qQ0iatmHWFM',1,3,2,'2023-09-08 13:08:22','2023-09-08 13:08:22',NULL);

--
-- Table structure for table `quotations`
--

CREATE TABLE `quotations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `telephone` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `message` text COLLATE utf8mb4_unicode_ci,
  `offer_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `quotations_offer_id_foreign` (`offer_id`),
  CONSTRAINT `quotations_offer_id_foreign` FOREIGN KEY (`offer_id`) REFERENCES `offers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `quotations`
--


--
-- Table structure for table `role_user`
--

CREATE TABLE `role_user` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `role_user_user_id_role_id_unique` (`user_id`,`role_id`),
  KEY `role_user_role_id_foreign` (`role_id`),
  CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=125 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_user`
--

INSERT INTO `role_user` VALUES (1,1,1,'2023-08-05 10:52:33','2023-08-05 10:52:33'),(3,3,2,'2023-09-08 13:04:07','2023-09-08 13:04:07');

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uid` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_uid_unique` (`uid`),
  UNIQUE KEY `roles_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'39X-53H-BFf-QWJ','admin','2023-08-05 10:52:32','2023-08-05 10:52:32'),(2,'Uup-poD-xY8-s5j','member','2023-08-05 10:52:32','2023-08-05 10:52:32');


