-- MariaDB dump 10.19  Distrib 10.4.32-MariaDB, for Win64 (AMD64)
--
-- Host: localhost    Database: ecomm_wps_db
-- ------------------------------------------------------
-- Server version	10.4.32-MariaDB

/*!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 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `ad_campaigns`
--

DROP TABLE IF EXISTS `ad_campaigns`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ad_campaigns` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `platform` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'active',
  `budget` decimal(12,2) NOT NULL DEFAULT 0.00,
  `spend` decimal(12,2) NOT NULL DEFAULT 0.00,
  `impressions` int(10) unsigned NOT NULL DEFAULT 0,
  `clicks` int(10) unsigned NOT NULL DEFAULT 0,
  `conversions` int(10) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ad_campaigns`
--

LOCK TABLES `ad_campaigns` WRITE;
/*!40000 ALTER TABLE `ad_campaigns` DISABLE KEYS */;
/*!40000 ALTER TABLE `ad_campaigns` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ad_profiles`
--

DROP TABLE IF EXISTS `ad_profiles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ad_profiles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `platform` varchar(255) NOT NULL,
  `pixel_id` varchar(255) NOT NULL,
  `currency` varchar(255) NOT NULL DEFAULT 'MAD',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ad_profiles`
--

LOCK TABLES `ad_profiles` WRITE;
/*!40000 ALTER TABLE `ad_profiles` DISABLE KEYS */;
/*!40000 ALTER TABLE `ad_profiles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ad_spend_records`
--

DROP TABLE IF EXISTS `ad_spend_records`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ad_spend_records` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `date` varchar(255) NOT NULL,
  `platform` varchar(255) NOT NULL,
  `campaign_name` varchar(255) NOT NULL,
  `spend_amount` decimal(12,2) NOT NULL DEFAULT 0.00,
  `revenue` decimal(12,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ad_spend_records`
--

LOCK TABLES `ad_spend_records` WRITE;
/*!40000 ALTER TABLE `ad_spend_records` DISABLE KEYS */;
/*!40000 ALTER TABLE `ad_spend_records` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cache`
--

DROP TABLE IF EXISTS `cache`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache`
--

LOCK TABLES `cache` WRITE;
/*!40000 ALTER TABLE `cache` DISABLE KEYS */;
INSERT INTO `cache` VALUES ('laravel_cache_5c785c036466adea360111aa28563bfd556b5fba','i:2;',1790719668),('laravel_cache_5c785c036466adea360111aa28563bfd556b5fba:timer','i:1790719668;',1790719668),('laravel_cache_admin@gmail.com|127.0.0.1','i:1;',1790705685),('laravel_cache_admin@gmail.com|127.0.0.1:timer','i:1790705685;',1790705685),('laravel_cache_spatie.permission.cache','a:3:{s:5:\"alias\";a:4:{s:1:\"a\";s:2:\"id\";s:1:\"b\";s:4:\"name\";s:1:\"c\";s:10:\"guard_name\";s:1:\"r\";s:5:\"roles\";}s:11:\"permissions\";a:43:{i:0;a:4:{s:1:\"a\";i:1;s:1:\"b\";s:14:\"dashboard.view\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:3:{i:0;i:1;i:1;i:2;i:2;i:3;}}i:1;a:4:{s:1:\"a\";i:2;s:1:\"b\";s:14:\"analytics.view\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:2;a:4:{s:1:\"a\";i:3;s:1:\"b\";s:13:\"products.view\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:3;a:4:{s:1:\"a\";i:4;s:1:\"b\";s:15:\"products.create\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:4;a:4:{s:1:\"a\";i:5;s:1:\"b\";s:15:\"products.update\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:5;a:4:{s:1:\"a\";i:6;s:1:\"b\";s:15:\"products.delete\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:6;a:4:{s:1:\"a\";i:7;s:1:\"b\";s:11:\"orders.view\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:3:{i:0;i:1;i:1;i:2;i:2;i:3;}}i:7;a:4:{s:1:\"a\";i:8;s:1:\"b\";s:13:\"orders.create\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:8;a:4:{s:1:\"a\";i:9;s:1:\"b\";s:13:\"orders.update\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:3:{i:0;i:1;i:1;i:2;i:2;i:3;}}i:9;a:4:{s:1:\"a\";i:10;s:1:\"b\";s:13:\"orders.delete\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:10;a:4:{s:1:\"a\";i:11;s:1:\"b\";s:16:\"orders.dearchive\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:1:{i:0;i:1;}}i:11;a:4:{s:1:\"a\";i:12;s:1:\"b\";s:14:\"customers.view\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:12;a:4:{s:1:\"a\";i:13;s:1:\"b\";s:16:\"customers.create\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:13;a:4:{s:1:\"a\";i:14;s:1:\"b\";s:16:\"customers.update\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:14;a:4:{s:1:\"a\";i:15;s:1:\"b\";s:16:\"customers.delete\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:15;a:4:{s:1:\"a\";i:16;s:1:\"b\";s:13:\"cities.create\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:16;a:4:{s:1:\"a\";i:17;s:1:\"b\";s:13:\"cities.update\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:17;a:4:{s:1:\"a\";i:18;s:1:\"b\";s:13:\"cities.delete\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:18;a:4:{s:1:\"a\";i:19;s:1:\"b\";s:14:\"reviews.update\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:19;a:4:{s:1:\"a\";i:20;s:1:\"b\";s:14:\"reviews.delete\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:20;a:4:{s:1:\"a\";i:21;s:1:\"b\";s:10:\"users.view\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:1:{i:0;i:1;}}i:21;a:4:{s:1:\"a\";i:22;s:1:\"b\";s:12:\"users.create\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:1:{i:0;i:1;}}i:22;a:4:{s:1:\"a\";i:23;s:1:\"b\";s:12:\"users.update\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:1:{i:0;i:1;}}i:23;a:4:{s:1:\"a\";i:24;s:1:\"b\";s:12:\"users.delete\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:1:{i:0;i:1;}}i:24;a:4:{s:1:\"a\";i:25;s:1:\"b\";s:10:\"roles.view\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:1:{i:0;i:1;}}i:25;a:4:{s:1:\"a\";i:26;s:1:\"b\";s:12:\"roles.update\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:1:{i:0;i:1;}}i:26;a:4:{s:1:\"a\";i:27;s:1:\"b\";s:13:\"settings.view\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:27;a:4:{s:1:\"a\";i:28;s:1:\"b\";s:15:\"settings.update\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:28;a:4:{s:1:\"a\";i:29;s:1:\"b\";s:12:\"contact.view\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:29;a:4:{s:1:\"a\";i:30;s:1:\"b\";s:14:\"contact.delete\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:30;a:4:{s:1:\"a\";i:31;s:1:\"b\";s:8:\"ads.view\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:31;a:4:{s:1:\"a\";i:32;s:1:\"b\";s:10:\"ads.create\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:32;a:4:{s:1:\"a\";i:33;s:1:\"b\";s:10:\"ads.delete\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:33;a:4:{s:1:\"a\";i:34;s:1:\"b\";s:13:\"shipping.view\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:3:{i:0;i:1;i:1;i:2;i:2;i:3;}}i:34;a:4:{s:1:\"a\";i:35;s:1:\"b\";s:15:\"shipping.create\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:35;a:4:{s:1:\"a\";i:36;s:1:\"b\";s:15:\"shipping.delete\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:36;a:4:{s:1:\"a\";i:37;s:1:\"b\";s:18:\"google-sheets.view\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:37;a:4:{s:1:\"a\";i:38;s:1:\"b\";s:20:\"google-sheets.create\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:38;a:4:{s:1:\"a\";i:39;s:1:\"b\";s:20:\"google-sheets.delete\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:39;a:4:{s:1:\"a\";i:40;s:1:\"b\";s:9:\"blog.view\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:40;a:4:{s:1:\"a\";i:41;s:1:\"b\";s:11:\"blog.create\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:41;a:4:{s:1:\"a\";i:42;s:1:\"b\";s:11:\"blog.update\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}i:42;a:4:{s:1:\"a\";i:43;s:1:\"b\";s:11:\"blog.delete\";s:1:\"c\";s:7:\"sanctum\";s:1:\"r\";a:2:{i:0;i:1;i:1;i:2;}}}s:5:\"roles\";a:3:{i:0;a:3:{s:1:\"a\";i:1;s:1:\"b\";s:5:\"admin\";s:1:\"c\";s:7:\"sanctum\";}i:1;a:3:{s:1:\"a\";i:2;s:1:\"b\";s:7:\"manager\";s:1:\"c\";s:7:\"sanctum\";}i:2;a:3:{s:1:\"a\";i:3;s:1:\"b\";s:7:\"courier\";s:1:\"c\";s:7:\"sanctum\";}}}',1790792047);
/*!40000 ALTER TABLE `cache` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cache_locks`
--

DROP TABLE IF EXISTS `cache_locks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL,
  PRIMARY KEY (`key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cache_locks`
--

LOCK TABLES `cache_locks` WRITE;
/*!40000 ALTER TABLE `cache_locks` DISABLE KEYS */;
/*!40000 ALTER TABLE `cache_locks` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `categories` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `categories_slug_unique` (`slug`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` VALUES (1,'Contes','contes','2026-09-29 17:00:10','2026-09-29 17:00:10'),(2,'Chants','chants','2026-09-29 17:00:10','2026-09-29 17:00:10'),(3,'Jeux','jeux','2026-09-29 17:00:10','2026-09-29 17:00:10'),(4,'Accessoires','accessoires','2026-09-29 17:00:10','2026-09-29 17:00:10'),(5,'Coffrets','coffrets','2026-09-29 17:00:10','2026-09-29 17:00:10');
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `cities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cities` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `shipping_zone_id` bigint(20) unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `cities_name_unique` (`name`),
  KEY `cities_shipping_zone_id_foreign` (`shipping_zone_id`),
  CONSTRAINT `cities_shipping_zone_id_foreign` FOREIGN KEY (`shipping_zone_id`) REFERENCES `shipping_zones` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=377 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `cities` WRITE;
/*!40000 ALTER TABLE `cities` DISABLE KEYS */;
INSERT INTO `cities` VALUES (1,'Casablanca',1,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(2,'Sidi rehal',2,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(3,'Ain harrouda',3,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(4,'Deroua',3,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(5,'Nouaceur',3,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(6,'Mediouna',3,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(7,'Tit melil',3,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(8,'Tit mellil',3,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(9,'Mohammedia',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(10,'Bouskoura',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(11,'Dar bouaza',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(12,'Al rahma',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(13,'Tamaris',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(14,'Marrakech',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(15,'Meknes',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(16,'Tetouan',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(17,'Kenitra',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(18,'Rabat',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(19,'Sale',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(20,'Sale el jadida',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(21,'Temara',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(22,'Agadir',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(23,'Fes',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(24,'Berrchid',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(25,'Had soualem',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(26,'Tanger',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(27,'Safi',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(28,'El jadida',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(29,'Bouznika',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(30,'Ait addou',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(31,'Agdez',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(32,'Settat',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(33,'Beni mellal',4,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(34,'Bouderbala',5,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(35,'Chefchaouen',5,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(36,'Sidi bouzid',5,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(37,'Zoumi',8,'2026-09-29 17:00:08','2026-09-29 17:00:09'),(38,'Oulad berhili',8,'2026-09-29 17:00:08','2026-09-29 17:00:09'),(39,'Ait balouna',6,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(40,'Toumliwana',6,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(41,'Igoudmanet',6,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(42,'Mrimina',6,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(43,'Battou',6,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(44,'Guelta zemmur',6,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(45,'Rehamna',7,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(46,'Tnine mhaya',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(47,'Ain taoujdate',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(48,'Sabaa aiyoun',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(49,'Boufakrane',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(50,'El hajeb',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(51,'Agourai',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(52,'Boujdour',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(53,'Martil',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(54,'M diq',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(55,'Fnideq',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(56,'Errachidia',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(57,'Oujda',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(58,'Nador',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(59,'Selouane',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(60,'Al aaroui',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(61,'Zaio',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(62,'Driouch',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(63,'Khouribga',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(64,'Oued zem',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(65,'Boulanouar',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(66,'Boujniba',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(67,'Bir mezoui',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(68,'Khemisset',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(69,'Tiflet',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(70,'Dakhla',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(71,'Sidi taibi',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(72,'Sidi yahya el gharb',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(73,'Allal tazi',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(74,'Mechra bel ksiri',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(75,'Sidi sliman',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(76,'Sidi kacem',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(77,'Mehdya',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(78,'Tan tan',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(79,'Guelmim',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(80,'Bouizakarne',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(81,'Tleta el akhsass',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(82,'Tarhjijt',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(83,'Ifrane atlas saghir',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(84,'Timoulay',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(85,'Sidi ifni',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(86,'Tamesna',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(87,'Skhirat',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(88,'Ouarzazat',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(89,'Ait zineb',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(90,'Tabounte',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(91,'Tajda',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(92,'Timdline',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(93,'Tifoultoute',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(94,'Ifran',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(95,'Azrou',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(96,'Inzegane',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(97,'Dcheira',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(98,'Ait meloul',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(99,'Sidi bibi',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(100,'Taghazoute',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(101,'Ain bida',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(102,'Oulad ettayeb',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(103,'Ain allah',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(104,'Sidi harazem',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(105,'Essmara',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(106,'Al hoceima',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(107,'Ajdir',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(108,'Boukidaren',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(109,'Ait kamra',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(110,'Imzouren',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(111,'Youssoufia',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(112,'Essaouira',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(113,'Ounagha',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(114,'Taftecht',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(115,'Mejji',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(116,'Talmest',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(117,'Akermoud',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(118,'Zaouiet bouzarktoune',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(119,'Smimou',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(120,'Tamanar',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(121,'Sidi kaouki',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(122,'Mrirt',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(123,'Khenifra',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(124,'Ben guerir',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(125,'Taroudannt',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(126,'Oulad teima',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(127,'Ait laaza',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(128,'Aoulouz',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(129,'Irherm',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(130,'Taliouine',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(131,'Sebt el guerdane',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(132,'Berkane',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(133,'Saidia',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(134,'Ras el ma',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(135,'Bni drar',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(136,'Ahfir',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(137,'Aklim',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(138,'Zeghanghane',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(139,'Farkhana',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(140,'Taza',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(141,'Guercif',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(142,'Tiznit',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(143,'Had hrara',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(144,'Sebt gzoula',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(145,'Tleta sidi bouguedra',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(146,'Larache',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(147,'Ksar el kebir',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(148,'Sidi messaoud',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(149,'El kelaa des sraghna',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(150,'Azemmour',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(151,'Moulay abdellah',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(152,'Oualidia',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(153,'Sidi bennour',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(154,'Beni ansar',8,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(155,'Izemmouren',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(156,'Laayoune',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(157,'El marsa',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(158,'Fquih ben salah',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(159,'Sebt oulad nemma',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(160,'Afourer',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(161,'Ouled yaiche',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(162,'El ksiba',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(163,'Ain aouda',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(164,'Tamansourt',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(165,'Benslimane',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(166,'Kasbah tadla',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(167,'Chemaia',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(168,'Ourika',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(169,'Tahannaout',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(170,'Ait ourir',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(171,'Touama',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(172,'Oudaya',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(173,'Chichaoua',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(174,'Assilah',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(175,'Sefrou',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(176,'Taourirt',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(177,'Chouiter',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(178,'Sidi allal el bahraoui',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(179,'Romani',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(180,'Oualmas',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(181,'Ouazzane',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(182,'Ain dorij',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(183,'Masmouda',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(184,'Sidi redouane',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(185,'Asjen',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(186,'Moqrisset',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(187,'Harhoura',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(188,'Laattaouia',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(189,'Rissani',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(190,'Arfoud',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(191,'Merzouga',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(192,'Taddart',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(193,'Bni bouayach',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(194,'Azilal',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(195,'Ouaouizeght',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(196,'Bejaad',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(197,'Tinghir',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(198,'Boumalne dades',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(199,'Kalaat mgouna',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(200,'Alnif',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(201,'Bou adel',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(202,'Khlalfa',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(203,'Ain mediouna',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(204,'Ain aicha',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(205,'Taounate',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(206,'Awrir',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(207,'Ait amira',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(208,'Belfaa',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(209,'Anza',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(210,'Derdara',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(211,'Bab taza',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(212,'Akchour',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(213,'Bab berred',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(214,'El jebeha',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(215,'Midelt',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(216,'Jerada',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(217,'Bouarfa',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(218,'Laayoun cherqia',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(219,'Zagora',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(220,'Tamegroute',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(221,'Tagomite',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(222,'Mhamid lghezlane',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(223,'Agdz',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(224,'Nkob',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(225,'Tazzarine',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(226,'Taghbalte',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(227,'Errich',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(228,'Missour',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(229,'Boumia',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(230,'Tinjdad',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(231,'Gulmima',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(232,'Sidi bouknadel',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(233,'Imintanoute',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(234,'Demnate',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(235,'Ouad laou',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(236,'Cabo negro',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(237,'Khmiss zemamera',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(238,'Sidi smail',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(239,'Oulad fraj',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(240,'Mellalyã¨ne',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(241,'Assa',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(242,'Lakhssas',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(243,'Aoufous',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(244,'Boudnib',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(245,'Ben ahmed',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(246,'Sidi bou othmane',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(247,'Asni',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(248,'Souk elarbaa du gharb',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(249,'Ajdir (rã©gion taza)',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(250,'Azla',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(251,'Marina',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(252,'Ain atig',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(253,'Mers lkhir',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(254,'Sidi yahya zair',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(255,'Ain chgeg',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(256,'Jorf sfer',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(257,'Bir jdid',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(258,'Midar',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(259,'Tamsaman',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(260,'Tafarist',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(261,'Bentayab',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(262,'Sidi ismail',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(263,'El gara',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(264,'Bni oukil',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(265,'Jemaat shaim',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(266,'Beni kla',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(267,'Jorf el melha',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(268,'Tikiwine',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(269,'Arzou-agadir',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(270,'El outia',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(271,'Tizi ousli',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(272,'Merzoqa',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(273,'Tahla',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(274,'Mrija',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(275,'Hed wlad zbayr',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(276,'El cap',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(277,'Azghar',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(278,'Ait hicham',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(279,'Talla',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(280,'Boukidan',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(281,'Swani',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(282,'Skhour rhamna',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(283,'Imouzar kandar',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(284,'Oued amlil',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(285,'Biougra',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(286,'Mensouria',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(287,'Tighsalin',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(288,'Laayoune-oujda',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(289,'Kkerrouchen',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(290,'Ghafsai',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(291,'Tata',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(292,'Moulay yacoub',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(293,'Ait ishak',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(294,'Ighrem laalam',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(295,'Sidi jaber',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(296,'Figuig',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(297,'Ksar sghir',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(298,'Oulad ayad',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(299,'Dar oulad zidoune',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(300,'Zaouiat cheikh',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(301,'Moulay bouaza',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(302,'Laouamra',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(303,'Aglmous',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(304,'Houara',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(305,'Mireleft',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(306,'Tilmia',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(307,'Bouljami',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(308,'Ait marghade',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(309,'Msemriro',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(310,'Taadadati',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(311,'Ait karmas',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(312,'Bab attoutchy',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(313,'Tiidrinas',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(314,'Ait hanik',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(315,'Tamtetouchte',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(316,'Timkitek',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(317,'Akouras',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(318,'Ait oulghouma',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(319,'Illigha',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(320,'Foum zguid',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(321,'El merja',8,'2026-09-29 17:00:09','2026-09-29 17:00:09'),(322,'Hassilabied',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(323,'Ait chaib rass',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(324,'Tadaout',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(325,'Alnifa',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(326,'Tanout',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(327,'Ait kherdi',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(328,'Tifirit',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(329,'Oumjrane',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(330,'Takchawa',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(331,'Tarnawa',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(332,'Aghallal',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(333,'Al mahbes',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(334,'Al farssia',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(335,'Tifariti',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(336,'Bir lehlou',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(337,'Oum dreyga',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(338,'Lqliaa',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(339,'Madagh',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(340,'Regada',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(341,'Jaadar',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(342,'Bouarg',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(343,'Arkman',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(344,'Teztoutin',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(345,'Dar el kebdani',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(346,'Taouima',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(347,'Ihdaden',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(348,'Kassita',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(349,'Crona',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(350,'Ouled settout',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(351,'Boudinar',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(352,'Anwal',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(353,'Amzarou',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(354,'Mariouari',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(355,'Bouhlou',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(356,'Aknoul',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(357,'Bourd',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(358,'Sidi ali bourakba',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(359,'Ain hamra',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(360,'Hed ouled zbir',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(361,'Kaldman',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(362,'Issagen',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(363,'Targist',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(364,'Tala',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(365,'Souani',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(366,'Debdou',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(367,'Tendrara',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(368,'Ain-beni-mathar',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(369,'Bergem',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(370,'Cafe maure',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(371,'Lamris',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(372,'Naima Région',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(373,'Moulay bousselham',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(374,'Khenichet',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(375,'Lalla mimouna',8,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(376,'Ain beni mathar',8,'2026-09-29 17:00:10','2026-09-29 17:00:10');
/*!40000 ALTER TABLE `cities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `contact_messages`
--

DROP TABLE IF EXISTS `contact_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `contact_messages` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `read_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contact_messages`
--

LOCK TABLES `contact_messages` WRITE;
/*!40000 ALTER TABLE `contact_messages` DISABLE KEYS */;
/*!40000 ALTER TABLE `contact_messages` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `customers`
--

DROP TABLE IF EXISTS `customers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `customers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `customers_email_unique` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customers`
--

LOCK TABLES `customers` WRITE;
/*!40000 ALTER TABLE `customers` DISABLE KEYS */;
/*!40000 ALTER TABLE `customers` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `failed_jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `failed_jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext 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;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `failed_jobs` WRITE;
/*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `job_batches`
--

DROP TABLE IF EXISTS `job_batches`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `job_batches`
--

LOCK TABLES `job_batches` WRITE;
/*!40000 ALTER TABLE `job_batches` DISABLE KEYS */;
/*!40000 ALTER TABLE `job_batches` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `jobs`
--

DROP TABLE IF EXISTS `jobs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `jobs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) unsigned NOT NULL,
  `reserved_at` int(10) unsigned DEFAULT NULL,
  `available_at` int(10) unsigned NOT NULL,
  `created_at` int(10) unsigned NOT NULL,
  PRIMARY KEY (`id`),
  KEY `jobs_queue_index` (`queue`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `jobs`
--

LOCK TABLES `jobs` WRITE;
/*!40000 ALTER TABLE `jobs` DISABLE KEYS */;
/*!40000 ALTER TABLE `jobs` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `migrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `migrations` WRITE;
/*!40000 ALTER TABLE `migrations` DISABLE KEYS */;
INSERT INTO `migrations` VALUES (1,'0001_01_01_000000_create_users_table',1),(2,'0001_01_01_000001_create_cache_table',1),(3,'0001_01_01_000002_create_jobs_table',1),(4,'2025_01_01_000002_create_categories_table',1),(5,'2025_01_01_000003_create_products_table',1),(6,'2025_01_01_000003_create_shipping_zones_table',1),(7,'2025_01_01_000004_create_cities_table',1),(8,'2025_01_01_000004_create_customers_table',1),(9,'2025_01_01_000004_create_product_offers_table',1),(10,'2025_01_01_000004_create_shipping_services_table',1),(11,'2025_01_01_000005_create_orders_table',1),(12,'2025_01_01_000006_create_order_items_table',1),(13,'2025_01_01_000007_create_reviews_table',1),(14,'2025_01_01_000008_create_platform_settings_table',1),(15,'2026_07_22_144151_create_permission_tables',1),(16,'2026_07_22_144152_create_personal_access_tokens_table',1),(17,'2026_07_23_000001_create_contact_messages_table',1),(18,'2026_07_23_000002_create_ad_campaigns_table',1),(19,'2026_07_23_000003_create_ad_spend_records_table',1),(20,'2026_07_23_000004_create_ad_profiles_table',1),(21,'2026_07_23_000006_create_shipping_dispatch_logs_table',1),(22,'2026_07_23_000007_create_sheet_integrations_table',1),(23,'2026_07_23_000008_create_sheet_sync_logs_table',1),(24,'2026_08_08_134627_create_product_images_table',1),(25,'2026_08_08_135625_create_product_testimonials_table',1),(26,'2026_08_08_141837_create_posts_table',1),(27,'2026_08_08_145851_remap_shipped_delivered_order_statuses_to_confirmed',1),(28,'2026_09_24_000001_create_product_offer_product_table',1),(29,'2026_09_25_182610_add_deleted_at_to_orders_table',1),(30,'2026_09_25_191953_add_status_forcelog_to_orders_table',1),(31,'2026_09_29_000001_add_card_payment_enabled_to_platform_settings_table',1);
/*!40000 ALTER TABLE `migrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `model_has_permissions`
--

DROP TABLE IF EXISTS `model_has_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `model_has_permissions`
--

LOCK TABLES `model_has_permissions` WRITE;
/*!40000 ALTER TABLE `model_has_permissions` DISABLE KEYS */;
/*!40000 ALTER TABLE `model_has_permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `model_has_roles`
--

DROP TABLE IF EXISTS `model_has_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) unsigned NOT NULL,
  `model_type` varchar(255) NOT NULL,
  `model_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`),
  CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `model_has_roles`
--

LOCK TABLES `model_has_roles` WRITE;
/*!40000 ALTER TABLE `model_has_roles` DISABLE KEYS */;
INSERT INTO `model_has_roles` VALUES (1,'App\\Models\\User',1),(2,'App\\Models\\User',2),(3,'App\\Models\\User',3);
/*!40000 ALTER TABLE `model_has_roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `order_items`
--

DROP TABLE IF EXISTS `order_items`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `order_items` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned DEFAULT NULL,
  `product_offer_id` bigint(20) unsigned DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `quantity` int(10) unsigned NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_items_order_id_foreign` (`order_id`),
  KEY `order_items_product_id_foreign` (`product_id`),
  KEY `order_items_product_offer_id_foreign` (`product_offer_id`),
  CONSTRAINT `order_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE SET NULL,
  CONSTRAINT `order_items_product_offer_id_foreign` FOREIGN KEY (`product_offer_id`) REFERENCES `product_offers` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_items`
--

LOCK TABLES `order_items` WRITE;
/*!40000 ALTER TABLE `order_items` DISABLE KEYS */;
/*!40000 ALTER TABLE `order_items` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `orders`
--

DROP TABLE IF EXISTS `orders`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `orders` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `order_number` varchar(255) NOT NULL,
  `customer_name` varchar(255) DEFAULT NULL,
  `customer_phone` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `city_id` bigint(20) unsigned DEFAULT NULL,
  `customer_id` bigint(20) unsigned DEFAULT NULL,
  `total` decimal(10,2) NOT NULL DEFAULT 0.00,
  `shipping_fee` decimal(8,2) NOT NULL DEFAULT 0.00,
  `free_shipping_offer_applied` tinyint(1) NOT NULL DEFAULT 0,
  `payment_status` varchar(255) NOT NULL DEFAULT 'pending',
  `payment_method` varchar(255) NOT NULL DEFAULT 'cod',
  `naps_transaction_id` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'pending',
  `status_forcelog` varchar(255) DEFAULT NULL,
  `is_send` tinyint(1) NOT NULL DEFAULT 0,
  `shipping_service_id` bigint(20) unsigned DEFAULT NULL,
  `tracking_reference` varchar(255) DEFAULT NULL,
  `note` text DEFAULT NULL,
  `source` varchar(255) DEFAULT 'direct',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `orders_order_number_unique` (`order_number`),
  KEY `orders_city_id_foreign` (`city_id`),
  KEY `orders_customer_id_foreign` (`customer_id`),
  KEY `orders_shipping_service_id_foreign` (`shipping_service_id`),
  CONSTRAINT `orders_city_id_foreign` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE SET NULL,
  CONSTRAINT `orders_customer_id_foreign` FOREIGN KEY (`customer_id`) REFERENCES `customers` (`id`) ON DELETE SET NULL,
  CONSTRAINT `orders_shipping_service_id_foreign` FOREIGN KEY (`shipping_service_id`) REFERENCES `shipping_services` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `orders`
--

LOCK TABLES `orders` WRITE;
/*!40000 ALTER TABLE `orders` DISABLE KEYS */;
/*!40000 ALTER TABLE `orders` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `password_reset_tokens`
--

DROP TABLE IF EXISTS `password_reset_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `password_reset_tokens`
--

LOCK TABLES `password_reset_tokens` WRITE;
/*!40000 ALTER TABLE `password_reset_tokens` DISABLE KEYS */;
/*!40000 ALTER TABLE `password_reset_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `permissions`
--

DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `permissions` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `permissions`
--

LOCK TABLES `permissions` WRITE;
/*!40000 ALTER TABLE `permissions` DISABLE KEYS */;
INSERT INTO `permissions` VALUES (1,'dashboard.view','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(2,'analytics.view','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(3,'products.view','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(4,'products.create','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(5,'products.update','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(6,'products.delete','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(7,'orders.view','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(8,'orders.create','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(9,'orders.update','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(10,'orders.delete','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(11,'orders.dearchive','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(12,'customers.view','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(13,'customers.create','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(14,'customers.update','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(15,'customers.delete','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(16,'cities.create','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(17,'cities.update','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(18,'cities.delete','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(19,'reviews.update','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(20,'reviews.delete','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(21,'users.view','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(22,'users.create','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(23,'users.update','sanctum','2026-09-29 17:00:05','2026-09-29 17:00:05'),(24,'users.delete','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(25,'roles.view','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(26,'roles.update','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(27,'settings.view','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(28,'settings.update','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(29,'contact.view','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(30,'contact.delete','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(31,'ads.view','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(32,'ads.create','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(33,'ads.delete','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(34,'shipping.view','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(35,'shipping.create','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(36,'shipping.delete','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(37,'google-sheets.view','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(38,'google-sheets.create','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(39,'google-sheets.delete','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(40,'blog.view','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(41,'blog.create','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(42,'blog.update','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(43,'blog.delete','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06');
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `personal_access_tokens`
--

DROP TABLE IF EXISTS `personal_access_tokens`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` text NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`),
  KEY `personal_access_tokens_expires_at_index` (`expires_at`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `personal_access_tokens`
--

LOCK TABLES `personal_access_tokens` WRITE;
/*!40000 ALTER TABLE `personal_access_tokens` DISABLE KEYS */;
INSERT INTO `personal_access_tokens` VALUES (4,'App\\Models\\User',1,'back-office','c708aff1b55e3b992c6abd425c8ea3de909f0d088eaf9e0dcd2d92c79ee447d5','[\"*\"]','2026-09-29 21:09:28',NULL,'2026-09-29 21:07:44','2026-09-29 21:09:28');
/*!40000 ALTER TABLE `personal_access_tokens` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `platform_settings`
--

DROP TABLE IF EXISTS `platform_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `platform_settings` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `site_title` varchar(255) NOT NULL DEFAULT 'Bassidi & Nana',
  `meta_description` text DEFAULT NULL,
  `meta_keywords` varchar(255) DEFAULT NULL,
  `logo_option` varchar(255) NOT NULL DEFAULT 'text',
  `logo_text` varchar(255) DEFAULT NULL,
  `logo_url` varchar(255) DEFAULT NULL,
  `navbar_color` varchar(255) DEFAULT NULL,
  `sidebar_color` varchar(255) DEFAULT NULL,
  `primary_color` varchar(255) DEFAULT NULL,
  `site_zoom` smallint(5) unsigned NOT NULL DEFAULT 100,
  `meta_pixel_id` varchar(255) DEFAULT NULL,
  `google_client_id` text DEFAULT NULL,
  `google_client_secret` text DEFAULT NULL,
  `google_service_account_json` text DEFAULT NULL,
  `default_shipping_price` decimal(8,2) DEFAULT NULL,
  `card_payment_enabled` tinyint(1) NOT NULL DEFAULT 0,
  `contact_email` varchar(255) DEFAULT NULL,
  `contact_phone` varchar(255) DEFAULT NULL,
  `contact_whatsapp` varchar(255) DEFAULT NULL,
  `contact_address` varchar(255) DEFAULT NULL,
  `contact_b2b_phone` varchar(255) DEFAULT NULL,
  `song_preview_seconds` int(10) unsigned NOT NULL DEFAULT 30,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `platform_settings`
--

LOCK TABLES `platform_settings` WRITE;
/*!40000 ALTER TABLE `platform_settings` DISABLE KEYS */;
INSERT INTO `platform_settings` VALUES (1,'Bassidi & Nana','Livres sonores et accessoires pour enfants inspirés du patrimoine marocain.','livres sonores, contes, patrimoine marocain, enfants','text','Bassidi & Nana',NULL,'#ffffff','#1f2937','#009689',100,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL,NULL,NULL,30,'2026-09-29 17:00:10','2026-09-29 17:00:10');
/*!40000 ALTER TABLE `platform_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `posts`
--

DROP TABLE IF EXISTS `posts`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `posts` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `excerpt` text DEFAULT NULL,
  `content` longtext NOT NULL,
  `cover_image` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'draft',
  `published_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `posts_slug_unique` (`slug`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `posts`
--

LOCK TABLES `posts` WRITE;
/*!40000 ALTER TABLE `posts` DISABLE KEYS */;
/*!40000 ALTER TABLE `posts` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product_images`
--

DROP TABLE IF EXISTS `product_images`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product_images` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned NOT NULL,
  `url` varchar(255) NOT NULL,
  `position` int(10) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_images_product_id_foreign` (`product_id`),
  CONSTRAINT `product_images_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_images`
--

LOCK TABLES `product_images` WRITE;
/*!40000 ALTER TABLE `product_images` DISABLE KEYS */;
/*!40000 ALTER TABLE `product_images` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product_offer_product`
--

DROP TABLE IF EXISTS `product_offer_product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product_offer_product` (
  `product_offer_id` bigint(20) unsigned NOT NULL,
  `product_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`product_offer_id`,`product_id`),
  KEY `product_offer_product_product_id_foreign` (`product_id`),
  CONSTRAINT `product_offer_product_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_offer_product_product_offer_id_foreign` FOREIGN KEY (`product_offer_id`) REFERENCES `product_offers` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_offer_product`
--

LOCK TABLES `product_offer_product` WRITE;
/*!40000 ALTER TABLE `product_offer_product` DISABLE KEYS */;
/*!40000 ALTER TABLE `product_offer_product` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product_offers`
--

DROP TABLE IF EXISTS `product_offers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product_offers` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned NOT NULL,
  `min_quantity` int(10) unsigned NOT NULL,
  `price` decimal(10,2) NOT NULL,
  `price_type` enum('total','per_unit') NOT NULL DEFAULT 'total',
  `free_shipping` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_offers_product_id_foreign` (`product_id`),
  CONSTRAINT `product_offers_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_offers`
--

LOCK TABLES `product_offers` WRITE;
/*!40000 ALTER TABLE `product_offers` DISABLE KEYS */;
/*!40000 ALTER TABLE `product_offers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product_testimonials`
--

DROP TABLE IF EXISTS `product_testimonials`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `product_testimonials` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned NOT NULL,
  `screenshot_url` varchar(255) NOT NULL,
  `position` int(10) unsigned NOT NULL DEFAULT 0,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_testimonials_product_id_foreign` (`product_id`),
  CONSTRAINT `product_testimonials_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_testimonials`
--

LOCK TABLES `product_testimonials` WRITE;
/*!40000 ALTER TABLE `product_testimonials` DISABLE KEYS */;
/*!40000 ALTER TABLE `product_testimonials` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `products`
--

DROP TABLE IF EXISTS `products`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `products` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `category_id` bigint(20) unsigned DEFAULT NULL,
  `title` varchar(255) NOT NULL,
  `slug` varchar(255) NOT NULL,
  `sku` varchar(255) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `dimensions` varchar(255) DEFAULT NULL,
  `age_recommendation` varchar(255) DEFAULT NULL,
  `features` text DEFAULT NULL,
  `chansons` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL CHECK (json_valid(`chansons`)),
  `price` decimal(10,2) NOT NULL,
  `stock` int(10) unsigned NOT NULL DEFAULT 0,
  `sales` int(10) unsigned NOT NULL DEFAULT 0,
  `threshold` int(10) unsigned NOT NULL DEFAULT 5,
  `tag` varchar(255) DEFAULT NULL,
  `image` varchar(255) DEFAULT NULL,
  `testimonial_audio_url` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `products_slug_unique` (`slug`),
  UNIQUE KEY `products_sku_unique` (`sku`),
  KEY `products_category_id_foreign` (`category_id`),
  CONSTRAINT `products_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `products`
--

LOCK TABLES `products` WRITE;
/*!40000 ALTER TABLE `products` DISABLE KEYS */;
INSERT INTO `products` VALUES (1,1,'Air d\'Enfance - Tome 1','tome-1',NULL,'Le volume iconique qui a réveillé les souvenirs de milliers de familles marocaines : 6 comptines traditionnelles à écouter, chanter et transmettre grâce à des boutons sonores tactiles.',NULL,NULL,NULL,NULL,250.00,50,0,5,'Best Seller',NULL,NULL,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(2,1,'Air d\'Enfance - Tome 2','tome-2',NULL,'20 nouvelles chansons du patrimoine marocain pour prolonger l\'expérience Air d\'Enfance, avec des illustrations faites main inspirées de l\'artisanat de Fès.',NULL,NULL,NULL,NULL,250.00,40,0,5,'Nouveau',NULL,NULL,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(3,4,'Totebag - Vibes Zwinin Only','totebag-zwinin',NULL,'Sac en coton biologique épais, imprimé à Casablanca avec des encres à l\'eau écologiques. Design exclusif Vibes Zwinin Only.',NULL,NULL,NULL,NULL,80.00,60,0,5,'Cadeau',NULL,NULL,'2026-09-29 17:00:10','2026-09-29 17:00:10'),(4,4,'Totebag - Niya is Cool','totebag-niya',NULL,'Sac en coton premium résistant, motif Niya is Cool sérigraphié en édition limitée. Idéal pour transporter vos livres sonores partout.',NULL,NULL,NULL,NULL,80.00,45,0,5,NULL,NULL,NULL,'2026-09-29 17:00:10','2026-09-29 17:00:10');
/*!40000 ALTER TABLE `products` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `reviews`
--

DROP TABLE IF EXISTS `reviews`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `reviews` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `product_id` bigint(20) unsigned DEFAULT NULL,
  `author` varchar(255) NOT NULL,
  `comment` text NOT NULL,
  `rating` tinyint(3) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `reviews_product_id_foreign` (`product_id`),
  CONSTRAINT `reviews_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reviews`
--

LOCK TABLES `reviews` WRITE;
/*!40000 ALTER TABLE `reviews` DISABLE KEYS */;
/*!40000 ALTER TABLE `reviews` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `role_has_permissions`
--

DROP TABLE IF EXISTS `role_has_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) unsigned NOT NULL,
  `role_id` bigint(20) unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `role_has_permissions_role_id_foreign` (`role_id`),
  CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `role_has_permissions`
--

LOCK TABLES `role_has_permissions` WRITE;
/*!40000 ALTER TABLE `role_has_permissions` DISABLE KEYS */;
INSERT INTO `role_has_permissions` VALUES (1,1),(1,2),(1,3),(2,1),(2,2),(3,1),(3,2),(4,1),(4,2),(5,1),(5,2),(6,1),(6,2),(7,1),(7,2),(7,3),(8,1),(8,2),(9,1),(9,2),(9,3),(10,1),(10,2),(11,1),(12,1),(12,2),(13,1),(13,2),(14,1),(14,2),(15,1),(15,2),(16,1),(16,2),(17,1),(17,2),(18,1),(18,2),(19,1),(19,2),(20,1),(20,2),(21,1),(22,1),(23,1),(24,1),(25,1),(26,1),(27,1),(27,2),(28,1),(28,2),(29,1),(29,2),(30,1),(30,2),(31,1),(31,2),(32,1),(32,2),(33,1),(33,2),(34,1),(34,2),(34,3),(35,1),(35,2),(36,1),(36,2),(37,1),(37,2),(38,1),(38,2),(39,1),(39,2),(40,1),(40,2),(41,1),(41,2),(42,1),(42,2),(43,1),(43,2);
/*!40000 ALTER TABLE `role_has_permissions` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `roles` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `guard_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `roles` WRITE;
/*!40000 ALTER TABLE `roles` DISABLE KEYS */;
INSERT INTO `roles` VALUES (1,'admin','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(2,'manager','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06'),(3,'courier','sanctum','2026-09-29 17:00:06','2026-09-29 17:00:06');
/*!40000 ALTER TABLE `roles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sessions`
--

DROP TABLE IF EXISTS `sessions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) unsigned DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `sessions_user_id_index` (`user_id`),
  KEY `sessions_last_activity_index` (`last_activity`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sessions`
--

LOCK TABLES `sessions` WRITE;
/*!40000 ALTER TABLE `sessions` DISABLE KEYS */;
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sheet_integrations`
--

DROP TABLE IF EXISTS `sheet_integrations`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sheet_integrations` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `spreadsheet_id` varchar(255) NOT NULL,
  `range_name` varchar(255) NOT NULL DEFAULT 'Feuille1',
  `trigger_event` varchar(255) NOT NULL DEFAULT 'on_new_order',
  `status` varchar(255) NOT NULL DEFAULT 'active',
  `field_mapping` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL CHECK (json_valid(`field_mapping`)),
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sheet_integrations`
--

LOCK TABLES `sheet_integrations` WRITE;
/*!40000 ALTER TABLE `sheet_integrations` DISABLE KEYS */;
/*!40000 ALTER TABLE `sheet_integrations` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sheet_sync_logs`
--

DROP TABLE IF EXISTS `sheet_sync_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sheet_sync_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `sheet_integration_id` bigint(20) unsigned DEFAULT NULL,
  `integration_name_snapshot` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `sheet_sync_logs_sheet_integration_id_foreign` (`sheet_integration_id`),
  CONSTRAINT `sheet_sync_logs_sheet_integration_id_foreign` FOREIGN KEY (`sheet_integration_id`) REFERENCES `sheet_integrations` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sheet_sync_logs`
--

LOCK TABLES `sheet_sync_logs` WRITE;
/*!40000 ALTER TABLE `sheet_sync_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `sheet_sync_logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `shipping_dispatch_logs`
--

DROP TABLE IF EXISTS `shipping_dispatch_logs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shipping_dispatch_logs` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `shipping_service_id` bigint(20) unsigned DEFAULT NULL,
  `order_id` bigint(20) unsigned DEFAULT NULL,
  `request_payload` text DEFAULT NULL,
  `response_status` int(10) unsigned DEFAULT NULL,
  `response_body` text DEFAULT NULL,
  `success` tinyint(1) NOT NULL DEFAULT 0,
  `error_message` text DEFAULT NULL,
  `external_reference` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `shipping_dispatch_logs_shipping_service_id_foreign` (`shipping_service_id`),
  KEY `shipping_dispatch_logs_order_id_foreign` (`order_id`),
  CONSTRAINT `shipping_dispatch_logs_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE SET NULL,
  CONSTRAINT `shipping_dispatch_logs_shipping_service_id_foreign` FOREIGN KEY (`shipping_service_id`) REFERENCES `shipping_services` (`id`) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `shipping_dispatch_logs`
--

LOCK TABLES `shipping_dispatch_logs` WRITE;
/*!40000 ALTER TABLE `shipping_dispatch_logs` DISABLE KEYS */;
/*!40000 ALTER TABLE `shipping_dispatch_logs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `shipping_services`
--

DROP TABLE IF EXISTS `shipping_services`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shipping_services` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'active',
  `endpoint` varchar(255) NOT NULL,
  `method` varchar(255) NOT NULL DEFAULT 'POST',
  `headers` text DEFAULT NULL,
  `body_template` text DEFAULT NULL,
  `response_id_path` varchar(255) DEFAULT NULL,
  `items_template` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `shipping_services`
--

LOCK TABLES `shipping_services` WRITE;
/*!40000 ALTER TABLE `shipping_services` DISABLE KEYS */;
/*!40000 ALTER TABLE `shipping_services` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `shipping_zones`
--

DROP TABLE IF EXISTS `shipping_zones`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `shipping_zones` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `price` decimal(8,2) NOT NULL DEFAULT 0.00,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `shipping_zones`
--

LOCK TABLES `shipping_zones` WRITE;
/*!40000 ALTER TABLE `shipping_zones` DISABLE KEYS */;
INSERT INTO `shipping_zones` VALUES (1,'Zone 18 DH',18.00,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(2,'Zone 29 DH',29.00,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(3,'Zone 33 DH',33.00,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(4,'Zone 35 DH',35.00,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(5,'Zone 37 DH',37.00,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(6,'Zone 39 DH',39.00,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(7,'Zone 40 DH',40.00,'2026-09-29 17:00:08','2026-09-29 17:00:08'),(8,'Zone 45 DH',45.00,'2026-09-29 17:00:08','2026-09-29 17:00:08');
/*!40000 ALTER TABLE `shipping_zones` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `users`
--

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `users` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL DEFAULT 'active',
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `users`
--

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,'Admin Bassidi & Nana','admin@bassidinana.ma','2026-09-29 17:00:07','$2y$12$TqBTDwq9eEetHlQIAuKNSOhE8hIAAmO2btFDBgwraU2lz9qCa9pG2','active',NULL,'2026-09-29 17:00:07','2026-09-29 17:00:07'),(2,'Manager Bassidi & Nana','manager@bassidinana.ma','2026-09-29 17:00:07','$2y$12$LjCjUow9iF206EygjZkmyuVYejWshp3ct15jBcYOJZ3Kt635jkJ/6','active',NULL,'2026-09-29 17:00:07','2026-09-29 17:00:07'),(3,'Courier Bassidi & Nana','courier@bassidinana.ma','2026-09-29 17:00:08','$2y$12$cPEAljpAQfdaR5OoUmsKQuc08oreY.k/a6.iOwdB82PDu1PHrHYMi','active',NULL,'2026-09-29 17:00:08','2026-09-29 17:00:08');
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2026-09-29 23:37:28