-- DeliverUs DB backup for phpMyAdmin
-- Generated: 2026-09-24 15:45:01
-- Import: create/select database 'deliverus' then Import this file (format SQL).
-- MySQL dump 10.13  Distrib 8.4.11, for Linux (x86_64)
--
-- Host: localhost    Database: deliverus
-- ------------------------------------------------------
-- Server version	8.4.11

/*!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 */;
/*!50503 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 `Withdraw`
--

DROP TABLE IF EXISTS `Withdraw`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `Withdraw` (
  `id` int NOT NULL AUTO_INCREMENT,
  `amount` double NOT NULL,
  `store_id` int DEFAULT NULL,
  `delivery_man_id` int DEFAULT NULL,
  `store_account_id` int DEFAULT NULL,
  `delivery_account_id` int DEFAULT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `status` enum('APPROVED','DENIED','PENDING') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING',
  PRIMARY KEY (`id`),
  KEY `Withdraw_store_id_fkey` (`store_id`),
  KEY `Withdraw_delivery_man_id_fkey` (`delivery_man_id`),
  KEY `Withdraw_delivery_account_id_fkey` (`delivery_account_id`),
  KEY `Withdraw_store_account_id_fkey` (`store_account_id`),
  CONSTRAINT `Withdraw_delivery_account_id_fkey` FOREIGN KEY (`delivery_account_id`) REFERENCES `delivery_banks` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `Withdraw_delivery_man_id_fkey` FOREIGN KEY (`delivery_man_id`) REFERENCES `delivery` (`id`),
  CONSTRAINT `Withdraw_store_account_id_fkey` FOREIGN KEY (`store_account_id`) REFERENCES `store_banks` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `Withdraw_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `Withdraw`
--

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

--
-- Table structure for table `addon`
--

DROP TABLE IF EXISTS `addon`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `addon` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nameAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nameEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` int NOT NULL,
  `store_id` int NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` datetime(3) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  KEY `addon_store_id_fkey` (`store_id`),
  CONSTRAINT `addon_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `addon`
--

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

--
-- Table structure for table `address`
--

DROP TABLE IF EXISTS `address`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `address` (
  `id` int NOT NULL AUTO_INCREMENT,
  `userId` int NOT NULL,
  `default` tinyint(1) NOT NULL DEFAULT '0',
  `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `lat` decimal(65,30) NOT NULL,
  `lng` decimal(65,30) NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  KEY `address_userId_fkey` (`userId`),
  CONSTRAINT `address_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `address`
--

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

--
-- Table structure for table `admin`
--

DROP TABLE IF EXISTS `admin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `admin` (
  `id` int NOT NULL,
  `role` int DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  KEY `admin_role_idx` (`role`),
  CONSTRAINT `admin_id_fkey` FOREIGN KEY (`id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `admin_role_fkey` FOREIGN KEY (`role`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `admin`
--

LOCK TABLES `admin` WRITE;
/*!40000 ALTER TABLE `admin` DISABLE KEYS */;
INSERT INTO `admin` VALUES (1,1,'$2b$13$OoBNKBLBM2fb65C5ussgmO1ZWNEaiDpSputKKsnO9gk7Bg/5fSXyW',NULL,'2025-03-18 07:24:18.077');
/*!40000 ALTER TABLE `admin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `admin_wallet`
--

DROP TABLE IF EXISTS `admin_wallet`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `admin_wallet` (
  `id` int NOT NULL AUTO_INCREMENT,
  `total_earning` decimal(24,2) NOT NULL DEFAULT '0.00',
  `total_withdrawn` decimal(24,2) NOT NULL DEFAULT '0.00',
  `pending_withdraw` decimal(24,2) NOT NULL DEFAULT '0.00',
  `current_balance` decimal(24,2) NOT NULL DEFAULT '0.00',
  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 `admin_wallet`
--

LOCK TABLES `admin_wallet` WRITE;
/*!40000 ALTER TABLE `admin_wallet` DISABLE KEYS */;
INSERT INTO `admin_wallet` VALUES (1,0.50,0.00,0.00,0.50);
/*!40000 ALTER TABLE `admin_wallet` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `advertisement`
--

DROP TABLE IF EXISTS `advertisement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `advertisement` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nameAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nameEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descriptionAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descriptionEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `store_id` int NOT NULL,
  `module_id` int NOT NULL,
  `startDate` datetime(3) NOT NULL,
  `endDate` datetime(3) NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cover` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `video` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `review` tinyint(1) NOT NULL DEFAULT '0',
  `rating` tinyint(1) NOT NULL DEFAULT '0',
  `deleted_at` datetime(3) DEFAULT NULL,
  `status` enum('RUNNING','PAUSED','APPROVED','EXPIRED','PENDING','DENIED','UPDATED') COLLATE utf8mb4_unicode_ci NOT NULL,
  `priority` enum('HIGH','LOW') COLLATE utf8mb4_unicode_ci NOT NULL,
  `promotion` enum('STORE','VIDEO') COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `advertisement_store_id_fkey` (`store_id`),
  KEY `advertisement_module_id_fkey` (`module_id`),
  CONSTRAINT `advertisement_module_id_fkey` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `advertisement_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `advertisement`
--

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

--
-- Table structure for table `attribute`
--

DROP TABLE IF EXISTS `attribute`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `attribute` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `module_id` int NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `attribute_name_ar_key` (`name_ar`),
  UNIQUE KEY `attribute_name_en_key` (`name_en`),
  KEY `attribute_module_id_fkey` (`module_id`),
  CONSTRAINT `attribute_module_id_fkey` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `attribute`
--

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

--
-- Table structure for table `automated_message`
--

DROP TABLE IF EXISTS `automated_message`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `automated_message` (
  `id` int NOT NULL AUTO_INCREMENT,
  `message_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `isActive` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `automated_message`
--

LOCK TABLES `automated_message` WRITE;
/*!40000 ALTER TABLE `automated_message` DISABLE KEYS */;
INSERT INTO `automated_message` VALUES (1,'مرحباً بك في DeliverUs! كيف يمكننا مساعدتك؟','Welcome to DeliverUs! How can we help you?',1,NULL),(2,'طلبك قيد التحضير، شكراً لصبرك.','Your order is being prepared. Thank you for your patience.',1,NULL),(3,'المندوب في الطريق إليك الآن.','The delivery agent is on the way to you.',1,NULL),(4,'تم تسليم طلبك بنجاح. نتمنى أن تستمتع!','Your order was delivered successfully. Enjoy!',1,NULL);
/*!40000 ALTER TABLE `automated_message` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `banks`
--

DROP TABLE IF EXISTS `banks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `banks` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `banks`
--

LOCK TABLES `banks` WRITE;
/*!40000 ALTER TABLE `banks` DISABLE KEYS */;
INSERT INTO `banks` VALUES (1,'Saudi National Bank','البنك الأهلي السعودي',NULL),(2,'Al Rajhi Bank','مصرف الراجحي',NULL),(3,'Riyad Bank','بنك الرياض',NULL),(4,'SABB','بنك ساب',NULL),(5,'Banque Saudi Fransi','البنك السعودي الفرنسي',NULL),(6,'Alinma Bank','بنك الإنماء',NULL),(7,'Bank AlJazira','بنك الجزيرة',NULL),(8,'Bank Albilad','بنك البلاد',NULL),(9,'PKO Bank Polski','PKO Bank Polski',NULL),(10,'mBank','mBank',NULL);
/*!40000 ALTER TABLE `banks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `banner`
--

DROP TABLE IF EXISTS `banner`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `banner` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nameAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nameEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `module_id` int NOT NULL,
  `store_id` int DEFAULT NULL,
  `product_id` int DEFAULT NULL,
  `image` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_featured` tinyint(1) NOT NULL DEFAULT '0',
  `redirect_url` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `type` enum('STORE','ITEM','DEFAULT') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `createdBy` enum('CUSTOMER','ADMIN','VENDOR','DELIVERY','MANAGER','DRIVER_COMPANY') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ADMIN',
  PRIMARY KEY (`id`),
  KEY `banner_store_id_fkey` (`store_id`),
  KEY `banner_product_id_fkey` (`product_id`),
  KEY `banner_module_id_fkey` (`module_id`),
  CONSTRAINT `banner_module_id_fkey` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `banner_product_id_fkey` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `banner_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `banner`
--

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

--
-- Table structure for table `brand`
--

DROP TABLE IF EXISTS `brand`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `brand` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `module_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `brand_module_id_fkey` (`module_id`),
  CONSTRAINT `brand_module_id_fkey` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `brand`
--

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

--
-- Table structure for table `campaign`
--

DROP TABLE IF EXISTS `campaign`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `campaign` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nameAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nameEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descriptionAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descriptionEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `module_id` int NOT NULL,
  `start_date` datetime(3) NOT NULL,
  `end_date` datetime(3) NOT NULL,
  `opening_time` time NOT NULL,
  `closing_time` time NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `campaign_module_id_fkey` (`module_id`),
  CONSTRAINT `campaign_module_id_fkey` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `campaign`
--

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

--
-- Table structure for table `cars`
--

DROP TABLE IF EXISTS `cars`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cars` (
  `id` int NOT NULL AUTO_INCREMENT,
  `car` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `color` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `plate` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `license` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_id` int NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  KEY `cars_customer_id_fkey` (`customer_id`),
  CONSTRAINT `cars_customer_id_fkey` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cars`
--

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

--
-- Table structure for table `cart`
--

DROP TABLE IF EXISTS `cart`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cart` (
  `id` int NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  CONSTRAINT `cart_id_fkey` FOREIGN KEY (`id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cart`
--

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

--
-- Table structure for table `cart_details`
--

DROP TABLE IF EXISTS `cart_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cart_details` (
  `cart_item_id` int NOT NULL,
  `variation_option_id` int NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`cart_item_id`,`variation_option_id`),
  KEY `cart_details_variation_option_id_fkey` (`variation_option_id`),
  CONSTRAINT `cart_details_cart_item_id_fkey` FOREIGN KEY (`cart_item_id`) REFERENCES `cart_item` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `cart_details_variation_option_id_fkey` FOREIGN KEY (`variation_option_id`) REFERENCES `variation_option` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cart_details`
--

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

--
-- Table structure for table `cart_item`
--

DROP TABLE IF EXISTS `cart_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cart_item` (
  `id` int NOT NULL AUTO_INCREMENT,
  `quantity` int NOT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `price` int NOT NULL,
  `product_id` int NOT NULL,
  `cart_id` int NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `cart_item_product_id_fkey` (`product_id`),
  KEY `cart_item_cart_id_fkey` (`cart_id`),
  CONSTRAINT `cart_item_cart_id_fkey` FOREIGN KEY (`cart_id`) REFERENCES `cart` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `cart_item_product_id_fkey` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cart_item`
--

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

--
-- Table structure for table `cashback`
--

DROP TABLE IF EXISTS `cashback`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cashback` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nameAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nameEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `maxDiscount` int NOT NULL DEFAULT '0',
  `purchase` int NOT NULL DEFAULT '0',
  `amount` int NOT NULL DEFAULT '0',
  `startDate` datetime(3) NOT NULL,
  `expireDate` datetime(3) NOT NULL,
  `limit` int NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `total_uses` int NOT NULL DEFAULT '0',
  `customer_id` int NOT NULL,
  `module_id` int NOT NULL,
  `user_id` int DEFAULT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `type` enum('PERCENTAGE','AMOUNT','NONE') COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cashback_customer_id_fkey` (`customer_id`),
  KEY `cashback_module_id_fkey` (`module_id`),
  KEY `cashback_user_id_fkey` (`user_id`),
  CONSTRAINT `cashback_customer_id_fkey` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `cashback_module_id_fkey` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `cashback_user_id_fkey` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cashback`
--

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

--
-- Table structure for table `cashback_history`
--

DROP TABLE IF EXISTS `cashback_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cashback_history` (
  `id` int NOT NULL AUTO_INCREMENT,
  `cashback_id` int NOT NULL,
  `user_id` int NOT NULL,
  `order_id` int NOT NULL,
  `amount` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `cashback_history_cashback_id_fkey` (`cashback_id`),
  KEY `cashback_history_user_id_fkey` (`user_id`),
  KEY `cashback_history_order_id_fkey` (`order_id`),
  CONSTRAINT `cashback_history_cashback_id_fkey` FOREIGN KEY (`cashback_id`) REFERENCES `cashback` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `cashback_history_order_id_fkey` FOREIGN KEY (`order_id`) REFERENCES `order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `cashback_history_user_id_fkey` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cashback_history`
--

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

--
-- Table structure for table `category`
--

DROP TABLE IF EXISTS `category`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `category` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `is_featured` tinyint(1) NOT NULL DEFAULT '0',
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `module_id` int NOT NULL,
  `parent_id` int DEFAULT NULL,
  `store_id` int DEFAULT NULL,
  `priority` int NOT NULL DEFAULT '3',
  `deleted_at` datetime(3) DEFAULT NULL,
  `created_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `category_module_id_fkey` (`module_id`),
  KEY `category_store_id_fkey` (`store_id`),
  KEY `category_parent_id_fkey` (`parent_id`),
  CONSTRAINT `category_module_id_fkey` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  CONSTRAINT `category_parent_id_fkey` FOREIGN KEY (`parent_id`) REFERENCES `category` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `category_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `category`
--

LOCK TABLES `category` WRITE;
/*!40000 ALTER TABLE `category` DISABLE KEYS */;
INSERT INTO `category` VALUES (1,'?????','QA Category',1,0,NULL,1,NULL,NULL,1,NULL,'2026-09-24 11:41:19.000');
/*!40000 ALTER TABLE `category` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `cities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `cities` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_ar` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('ACTIVE','INACTIVE') COLLATE utf8mb4_unicode_ci DEFAULT 'ACTIVE',
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `deleted_at` datetime(3) DEFAULT NULL,
  `countryId` int DEFAULT NULL,
  `updated_at` datetime(3) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `cities_countryId_fkey` (`countryId`),
  CONSTRAINT `cities_countryId_fkey` FOREIGN KEY (`countryId`) REFERENCES `country` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=23 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,'الرياض','Riyadh','ACTIVE','2026-09-24 10:24:48.334',NULL,1,'2026-09-24 10:48:19.254'),(2,'مكة المكرمة','Makkah','ACTIVE','2026-09-24 10:24:48.420',NULL,1,'2026-09-24 10:48:19.270'),(3,'المدينة المنورة','Madinah','ACTIVE','2026-09-24 10:24:48.432',NULL,1,'2026-09-24 10:48:19.281'),(4,'القصيم','Qassim','ACTIVE','2026-09-24 10:24:48.447',NULL,1,'2026-09-24 10:48:19.292'),(5,'الشرقية','Eastern Province','ACTIVE','2026-09-24 10:24:48.461',NULL,1,'2026-09-24 10:48:19.303'),(6,'عسير','Asir','ACTIVE','2026-09-24 10:24:48.486',NULL,1,'2026-09-24 10:48:19.312'),(7,'تبوك','Tabuk','ACTIVE','2026-09-24 10:24:48.506',NULL,1,'2026-09-24 10:48:19.324'),(8,'حائل','Hail','ACTIVE','2026-09-24 10:24:48.525',NULL,1,'2026-09-24 10:48:19.331'),(9,'الحدود الشمالية','Northern Borders','ACTIVE','2026-09-24 10:24:48.542',NULL,1,'2026-09-24 10:48:19.344'),(10,'جازان','Jazan','ACTIVE','2026-09-24 10:24:48.555',NULL,1,'2026-09-24 10:48:19.351'),(11,'نجران','Najran','ACTIVE','2026-09-24 10:24:48.573',NULL,1,'2026-09-24 10:48:19.361'),(12,'الباحة','Al Bahah','ACTIVE','2026-09-24 10:24:48.589',NULL,1,'2026-09-24 10:48:19.369'),(13,'الجوف','Al Jawf','ACTIVE','2026-09-24 10:24:48.658',NULL,1,'2026-09-24 10:48:19.380'),(14,'جدة','Jeddah','ACTIVE','2026-09-24 10:24:48.669',NULL,1,'2026-09-24 10:48:19.387'),(15,'الدمام','Dammam','ACTIVE','2026-09-24 10:24:48.765',NULL,1,'2026-09-24 10:48:19.401'),(16,'وارسو','Warsaw','ACTIVE','2026-09-24 10:24:48.802',NULL,2,'2026-09-24 10:48:19.410'),(17,'كراكوف','Krakow','ACTIVE','2026-09-24 10:24:48.828',NULL,2,'2026-09-24 10:48:19.418'),(18,'غدانسك','Gdansk','ACTIVE','2026-09-24 10:24:49.176',NULL,2,'2026-09-24 10:48:19.427'),(19,'القاهرة','Cairo','ACTIVE','2026-09-24 10:24:49.723',NULL,3,'2026-09-24 10:48:19.436'),(20,'الإسكندرية','Alexandria','ACTIVE','2026-09-24 10:24:50.055',NULL,3,'2026-09-24 10:48:19.449'),(21,'دبي','Dubai','ACTIVE','2026-09-24 10:24:50.538',NULL,4,'2026-09-24 10:48:19.463'),(22,'أبو ظبي','Abu Dhabi','ACTIVE','2026-09-24 10:24:50.878',NULL,4,'2026-09-24 10:48:19.473');
/*!40000 ALTER TABLE `cities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `company_vehicles`
--

DROP TABLE IF EXISTS `company_vehicles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `company_vehicles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `company_id` int NOT NULL,
  `photo` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `brand` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `year` int DEFAULT NULL,
  `color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plate` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `seats` int DEFAULT NULL,
  `status` enum('ACTIVE','SUSPENDED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVE',
  `assigned_delivery_id` int DEFAULT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `company_vehicles_company_id_plate_key` (`company_id`,`plate`),
  UNIQUE KEY `company_vehicles_assigned_delivery_id_key` (`assigned_delivery_id`),
  KEY `company_vehicles_company_id_idx` (`company_id`),
  CONSTRAINT `company_vehicles_assigned_delivery_id_fkey` FOREIGN KEY (`assigned_delivery_id`) REFERENCES `delivery` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `company_vehicles_company_id_fkey` FOREIGN KEY (`company_id`) REFERENCES `driver_companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `company_vehicles`
--

LOCK TABLES `company_vehicles` WRITE;
/*!40000 ALTER TABLE `company_vehicles` DISABLE KEYS */;
INSERT INTO `company_vehicles` VALUES (1,7,NULL,'Toyota','Camry',2024,'White','PLT9099930',4,'ACTIVE',NULL,NULL,'2026-09-24 11:25:25.709'),(2,8,NULL,'Toyota','Camry',2024,'White','PLT9379250',4,'ACTIVE',NULL,NULL,'2026-09-24 11:30:18.037'),(3,9,NULL,'Toyota','Corolla',2023,'Black','QA150487',4,'ACTIVE',NULL,NULL,'2026-09-24 11:42:56.277'),(4,11,NULL,'Toyota','Corolla',2023,'Black','QA934176',4,'ACTIVE',NULL,NULL,'2026-09-24 11:55:58.957'),(5,13,NULL,'Toyota','Corolla',2023,'Black','QA773429',4,'ACTIVE',NULL,NULL,'2026-09-24 12:09:59.031');
/*!40000 ALTER TABLE `company_vehicles` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `condition`
--

DROP TABLE IF EXISTS `condition`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `condition` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `module_id` int NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `condition_module_id_fkey` (`module_id`),
  CONSTRAINT `condition_module_id_fkey` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `condition`
--

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

--
-- Table structure for table `contract_document`
--

DROP TABLE IF EXISTS `contract_document`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `contract_document` (
  `id` int NOT NULL AUTO_INCREMENT,
  `store_id` int NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('DRAFT','UPLOADED','ADMIN_SIGNED','PROVIDER_PENDING','SIGNED','SYNCED','FAILED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'DRAFT',
  `source_file_path` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signed_file_path` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `autenti_document_id` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `autenti_process_id` varchar(120) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `admin_sign_url` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider_sign_url` varchar(1000) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_error` text COLLATE utf8mb4_unicode_ci,
  `admin_signed_at` datetime(3) DEFAULT NULL,
  `provider_signed_at` datetime(3) DEFAULT NULL,
  `synced_at` datetime(3) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` datetime(3) NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `contract_document_store_id_status_idx` (`store_id`,`status`),
  KEY `contract_document_autenti_document_id_idx` (`autenti_document_id`),
  CONSTRAINT `contract_document_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `contract_document`
--

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

--
-- Table structure for table `conversation`
--

DROP TABLE IF EXISTS `conversation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `conversation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `deleted_at` datetime(3) 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 `conversation`
--

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

--
-- Table structure for table `country`
--

DROP TABLE IF EXISTS `country`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `country` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_ar` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `country`
--

LOCK TABLES `country` WRITE;
/*!40000 ALTER TABLE `country` DISABLE KEYS */;
INSERT INTO `country` VALUES (1,'المملكة العربية السعودية','Saudi Arabia',NULL),(2,'بولندا','Poland',NULL),(3,'مصر','Egypt',NULL),(4,'الإمارات العربية المتحدة','United Arab Emirates',NULL);
/*!40000 ALTER TABLE `country` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `coupon`
--

DROP TABLE IF EXISTS `coupon`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `coupon` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nameAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nameEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `discount` int NOT NULL DEFAULT '0',
  `maxDiscount` int NOT NULL DEFAULT '0',
  `minPurchase` int NOT NULL DEFAULT '0',
  `startDate` datetime(3) NOT NULL,
  `expireDate` datetime(3) NOT NULL,
  `start_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `end_time` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `userId` int DEFAULT NULL,
  `total_uses` int NOT NULL DEFAULT '0',
  `limit` int NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `store_id` int DEFAULT NULL,
  `zone_id` int DEFAULT NULL,
  `module_id` int NOT NULL,
  `discount_type` enum('PERCENTAGE','AMOUNT','NONE') COLLATE utf8mb4_unicode_ci NOT NULL,
  `createdBy` enum('ADMIN','VENDOR') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ADMIN',
  `deleted_at` datetime(3) DEFAULT NULL,
  `type` enum('STORE_WISE','ZONE_WISE','FIRST_ORDER','FREE_DELIVERY','DEFAULT') COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `coupon_store_id_fkey` (`store_id`),
  KEY `coupon_zone_id_fkey` (`zone_id`),
  KEY `coupon_module_id_fkey` (`module_id`),
  KEY `coupon_userId_fkey` (`userId`),
  CONSTRAINT `coupon_module_id_fkey` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `coupon_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `coupon_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `coupon_zone_id_fkey` FOREIGN KEY (`zone_id`) REFERENCES `zone` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `coupon`
--

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

--
-- Table structure for table `customer`
--

DROP TABLE IF EXISTS `customer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `customer` (
  `id` int NOT NULL,
  `role` int DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('ACTIVE','DENIED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVE',
  `fcm_token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `earningPoints` int NOT NULL DEFAULT '0',
  `wallet` int NOT NULL DEFAULT '0',
  `rewards` int NOT NULL DEFAULT '0',
  `deviceId` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `deleted_at` datetime(3) DEFAULT NULL,
  `home_delivery_order` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `customer_deviceId_key` (`deviceId`),
  KEY `customer_role_idx` (`role`),
  CONSTRAINT `customer_id_fkey` FOREIGN KEY (`id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `customer_role_fkey` FOREIGN KEY (`role`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `customer`
--

LOCK TABLES `customer` WRITE;
/*!40000 ALTER TABLE `customer` DISABLE KEYS */;
INSERT INTO `customer` VALUES (16,2,NULL,'ACTIVE',NULL,0,0,0,NULL,'2026-09-24 11:43:47.786',NULL,0),(17,2,NULL,'ACTIVE',NULL,2134,0,0,NULL,'2026-09-24 11:45:47.139',NULL,0),(18,2,NULL,'ACTIVE',NULL,2134,0,0,NULL,'2026-09-24 11:48:36.904',NULL,0),(19,2,NULL,'ACTIVE',NULL,4268,0,0,NULL,'2026-09-24 11:50:54.965',NULL,1),(20,2,NULL,'ACTIVE',NULL,2134,0,0,NULL,'2026-09-24 11:54:19.440',NULL,0),(24,2,NULL,'ACTIVE',NULL,2134,0,0,NULL,'2026-09-24 11:56:43.372',NULL,0),(25,2,NULL,'ACTIVE',NULL,2134,0,0,NULL,'2026-09-24 12:09:10.184',NULL,0),(29,2,NULL,'ACTIVE',NULL,2134,0,0,NULL,'2026-09-24 12:10:51.134',NULL,0);
/*!40000 ALTER TABLE `customer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `delivery`
--

DROP TABLE IF EXISTS `delivery`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `delivery` (
  `id` int NOT NULL,
  `role` int DEFAULT NULL,
  `rating` int NOT NULL DEFAULT '0',
  `identify_image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `identify_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deviceId` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city_id` int NOT NULL,
  `nationality_id` int DEFAULT NULL,
  `status` enum('ACTIVE','DENIED','PENDING') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING',
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `verified` tinyint(1) NOT NULL DEFAULT '0',
  `ready_to_receive_orders` tinyint(1) NOT NULL DEFAULT '1',
  `lat` int NOT NULL DEFAULT '0',
  `lng` int NOT NULL DEFAULT '0',
  `vehicle` enum('CAR','BICYCLE') COLLATE utf8mb4_unicode_ci NOT NULL,
  `DrivingLicense` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `VehicleLicense` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `company_id` int DEFAULT NULL,
  `tier_id` int DEFAULT NULL,
  `gender` enum('MALE','FEMALE') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_expiry` datetime(3) DEFAULT NULL,
  `id_expiry` datetime(3) DEFAULT NULL,
  `id_front_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `id_back_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_front_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `license_back_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transport_card_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `passport_image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `commission_type` enum('PERCENTAGE','FIXED') COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `commission_value` double DEFAULT NULL,
  `rating_quality` double DEFAULT NULL,
  `rating_commitment` double DEFAULT NULL,
  `rating_communication` double DEFAULT NULL,
  `rating_avg` double DEFAULT NULL,
  `online` tinyint(1) NOT NULL DEFAULT '0',
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `delivery_deviceId_key` (`deviceId`),
  KEY `delivery_role_idx` (`role`),
  KEY `delivery_company_id_idx` (`company_id`),
  KEY `delivery_tier_id_idx` (`tier_id`),
  KEY `delivery_city_id_fkey` (`city_id`),
  KEY `delivery_nationality_id_fkey` (`nationality_id`),
  CONSTRAINT `delivery_city_id_fkey` FOREIGN KEY (`city_id`) REFERENCES `cities` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  CONSTRAINT `delivery_company_id_fkey` FOREIGN KEY (`company_id`) REFERENCES `driver_companies` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `delivery_id_fkey` FOREIGN KEY (`id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `delivery_nationality_id_fkey` FOREIGN KEY (`nationality_id`) REFERENCES `nationalities` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `delivery_role_fkey` FOREIGN KEY (`role`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `delivery_tier_id_fkey` FOREIGN KEY (`tier_id`) REFERENCES `driver_tiers` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `delivery`
--

LOCK TABLES `delivery` WRITE;
/*!40000 ALTER TABLE `delivery` DISABLE KEYS */;
INSERT INTO `delivery` VALUES (10,4,0,'uploads/default.png','ID9099930','$2b$13$cxEnIDvvZv9TuxZGGRDp6.C4F10Dj0RWUh5rZ0Tkqjl.sBQJuTujS',NULL,22,NULL,'ACTIVE','2026-09-24 11:25:34.645',1,1,0,0,'CAR',NULL,NULL,7,3,'MALE','LIC9099930',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PERCENTAGE',10,NULL,NULL,NULL,NULL,0,NULL),(12,4,0,'uploads/default.png','ID9379250','$2b$13$ktSQVCr4ueItmLYKC59/8.DJIYW7hJUwk.q9wY00feLbJrI1NMofe',NULL,22,NULL,'ACTIVE','2026-09-24 11:30:30.298',1,1,0,0,'CAR',NULL,NULL,8,3,'MALE','LIC9379250',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PERCENTAGE',10,NULL,NULL,NULL,NULL,0,NULL),(14,4,0,'uploads/default.png','ID150487','$2b$13$gv7IpDPfsecp.hR/78fY9ePZNSHsXUWhD1D/nPjxaI/sOOR2B8/Di',NULL,22,NULL,'ACTIVE','2026-09-24 11:43:05.375',1,1,0,0,'CAR',NULL,NULL,9,3,'MALE','LIC150487',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PERCENTAGE',10,NULL,NULL,NULL,NULL,0,NULL),(22,4,0,'uploads/default.png','ID934176','$2b$13$CbHt1Ms5HXgHx.68PdE5uO7zOct61chOt9Ojnh.vGYdjqMUrRq.1W',NULL,22,NULL,'ACTIVE','2026-09-24 11:56:08.163',1,1,0,0,'CAR',NULL,NULL,11,3,'MALE','LIC934176',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PERCENTAGE',10,NULL,NULL,NULL,NULL,0,NULL),(27,4,0,'uploads/default.png','ID773429','$2b$13$xzZkI/5.IeBydsGRE9xdbe1VZV2DEfKXV3Yz4qrHOcasIzXW9c54K',NULL,22,NULL,'ACTIVE','2026-09-24 12:10:08.163',1,1,0,0,'CAR',NULL,NULL,13,3,'MALE','LIC773429',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'PERCENTAGE',10,NULL,NULL,NULL,NULL,0,NULL);
/*!40000 ALTER TABLE `delivery` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `delivery_banks`
--

DROP TABLE IF EXISTS `delivery_banks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `delivery_banks` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `iban` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ownerName` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delivery_id` int NOT NULL,
  `bank_id` int NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `delivery_banks_delivery_id_fkey` (`delivery_id`),
  KEY `delivery_banks_bank_id_fkey` (`bank_id`),
  CONSTRAINT `delivery_banks_bank_id_fkey` FOREIGN KEY (`bank_id`) REFERENCES `banks` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `delivery_banks_delivery_id_fkey` FOREIGN KEY (`delivery_id`) REFERENCES `delivery` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `delivery_banks`
--

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

--
-- Table structure for table `delivery_order_rejected`
--

DROP TABLE IF EXISTS `delivery_order_rejected`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `delivery_order_rejected` (
  `id` int NOT NULL AUTO_INCREMENT,
  `order_id` int NOT NULL,
  `delivery_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `delivery_order_rejected_order_id_fkey` (`order_id`),
  KEY `delivery_order_rejected_delivery_id_fkey` (`delivery_id`),
  CONSTRAINT `delivery_order_rejected_delivery_id_fkey` FOREIGN KEY (`delivery_id`) REFERENCES `delivery` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `delivery_order_rejected_order_id_fkey` FOREIGN KEY (`order_id`) REFERENCES `order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `delivery_order_rejected`
--

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

--
-- Table structure for table `disbursement`
--

DROP TABLE IF EXISTS `disbursement`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `disbursement` (
  `id` int NOT NULL AUTO_INCREMENT,
  `store_id` int NOT NULL,
  `disbursement_account_id` int NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `deleted_at` datetime(3) DEFAULT NULL,
  `updatedAt` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `amount` decimal(65,30) NOT NULL,
  `status` enum('PENDING','ACCEPTED','REJECTED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING',
  PRIMARY KEY (`id`),
  KEY `disbursement_disbursement_account_id_fkey` (`disbursement_account_id`),
  KEY `disbursement_store_id_fkey` (`store_id`),
  CONSTRAINT `disbursement_disbursement_account_id_fkey` FOREIGN KEY (`disbursement_account_id`) REFERENCES `disbursement_account` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `disbursement_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `disbursement`
--

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

--
-- Table structure for table `disbursement_account`
--

DROP TABLE IF EXISTS `disbursement_account`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `disbursement_account` (
  `id` int NOT NULL AUTO_INCREMENT,
  `store_id` int NOT NULL,
  `bankName` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `accountNumber` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `iban` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `swiftCode` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `default` tinyint(1) NOT NULL DEFAULT '0',
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `disbursement_account_store_id_fkey` (`store_id`),
  CONSTRAINT `disbursement_account_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `disbursement_account`
--

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

--
-- Table structure for table `driver_companies`
--

DROP TABLE IF EXISTS `driver_companies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `driver_companies` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `tax_number` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lat` decimal(65,30) DEFAULT NULL,
  `lng` decimal(65,30) DEFAULT NULL,
  `drivers_count_hint` int DEFAULT NULL,
  `vehicles_count_hint` int DEFAULT NULL,
  `status` enum('PENDING','ACTIVE','SUSPENDED','DENIED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING',
  `locale` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pl',
  `notifications_enabled` tinyint(1) NOT NULL DEFAULT '1',
  `phone_verified` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `driver_companies_username_key` (`username`),
  UNIQUE KEY `driver_companies_phone_key` (`phone`),
  UNIQUE KEY `driver_companies_email_key` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `driver_companies`
--

LOCK TABLES `driver_companies` WRITE;
/*!40000 ALTER TABLE `driver_companies` DISABLE KEYS */;
INSERT INTO `driver_companies` VALUES (1,'fleet8286727','Fleet Co 8286727','+48 508286727','fleet8286727@test.com','PL8286727','Warsaw, Poland',NULL,NULL,5,3,'PENDING','pl',1,0,'2026-09-24 11:11:38.333',NULL),(2,'fleetapi1','Fleet API','+48 501112223','fleetapi1@test.com','PL999001','Warsaw',NULL,NULL,NULL,NULL,'PENDING','pl',1,0,'2026-09-24 11:16:20.107',NULL),(3,'fleet8652730','Fleet Co 8652730','+48 501865273','fleet8652730@test.com','PL8652730','Warsaw, Poland',NULL,NULL,5,3,'PENDING','pl',1,0,'2026-09-24 11:17:36.114',NULL),(4,'fleet8786542','Fleet Co 8786542','+48 501878654','fleet8786542@test.com','PL8786542','Warsaw, Poland',NULL,NULL,5,3,'ACTIVE','pl',1,1,'2026-09-24 11:19:50.327',NULL),(5,'fleet8957555','Fleet Co 8957555','+48 501895755','fleet8957555@test.com','PL8957555','Warsaw, Poland',NULL,NULL,5,3,'PENDING','pl',1,0,'2026-09-24 11:22:40.408',NULL),(6,'fleet8981859','Fleet Co 8981859','+48 501898185','fleet8981859@test.com','PL8981859','Warsaw, Poland',NULL,NULL,5,3,'PENDING','pl',1,1,'2026-09-24 11:23:04.894',NULL),(7,'fleet9099930','Fleet Co 9099930','+48 501909993','fleet9099930@test.com','PL9099930','Warsaw, Poland',NULL,NULL,5,3,'ACTIVE','pl',1,1,'2026-09-24 11:25:02.927',NULL),(8,'fleet9379250','Fleet Co 9379250','+48 501937925','fleet9379250@test.com','PL9379250','Warsaw, Poland',NULL,NULL,5,3,'ACTIVE','pl',1,1,'2026-09-24 11:29:49.940',NULL),(9,'qaA150487','QA Accept 150487','+48 511150487','qaA150487@test.com','PLA150487','Warsaw',NULL,NULL,NULL,NULL,'ACTIVE','pl',1,1,'2026-09-24 11:42:38.733',NULL),(10,'qaB150487','QA Deny 150487','+48 512150487','qaB150487@test.com','PLB150487','Warsaw',NULL,NULL,NULL,NULL,'DENIED','pl',1,1,'2026-09-24 11:43:17.244',NULL),(11,'qaA934176','QA Accept 934176','+48 511934176','qaA934176@test.com','PLA934176','Warsaw',NULL,NULL,NULL,NULL,'ACTIVE','pl',1,1,'2026-09-24 11:55:41.414',NULL),(12,'qaB934176','QA Deny 934176','+48 512934176','qaB934176@test.com','PLB934176','Warsaw',NULL,NULL,NULL,NULL,'DENIED','pl',1,1,'2026-09-24 11:56:18.918',NULL),(13,'qaA773429','QA Accept 773429','+48 511773429','qaA773429@test.com','PLA773429','Warsaw',NULL,NULL,NULL,NULL,'ACTIVE','pl',1,1,'2026-09-24 12:09:41.626',NULL),(14,'qaB773429','QA Deny 773429','+48 512773429','qaB773429@test.com','PLB773429','Warsaw',NULL,NULL,NULL,NULL,'DENIED','pl',1,1,'2026-09-24 12:10:20.215',NULL);
/*!40000 ALTER TABLE `driver_companies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `driver_company_support_messages`
--

DROP TABLE IF EXISTS `driver_company_support_messages`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `driver_company_support_messages` (
  `id` int NOT NULL AUTO_INCREMENT,
  `company_id` int NOT NULL,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  KEY `driver_company_support_messages_company_id_idx` (`company_id`),
  CONSTRAINT `driver_company_support_messages_company_id_fkey` FOREIGN KEY (`company_id`) REFERENCES `driver_companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `driver_company_support_messages`
--

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

--
-- Table structure for table `driver_company_users`
--

DROP TABLE IF EXISTS `driver_company_users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `driver_company_users` (
  `id` int NOT NULL,
  `company_id` int NOT NULL,
  `role` int DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` enum('PENDING','ACTIVE','SUSPENDED','DENIED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING',
  `deleted_at` datetime(3) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `driver_company_users_company_id_key` (`company_id`),
  KEY `driver_company_users_role_idx` (`role`),
  CONSTRAINT `driver_company_users_company_id_fkey` FOREIGN KEY (`company_id`) REFERENCES `driver_companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `driver_company_users_id_fkey` FOREIGN KEY (`id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `driver_company_users_role_fkey` FOREIGN KEY (`role`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `driver_company_users`
--

LOCK TABLES `driver_company_users` WRITE;
/*!40000 ALTER TABLE `driver_company_users` DISABLE KEYS */;
INSERT INTO `driver_company_users` VALUES (3,1,6,'$2b$13$blBfpaty8gzKe5r1C2CKAu3YOthu.Ok7SARR9XvBJ69cytiCC.dN2','PENDING',NULL,'2026-09-24 11:11:38.333'),(4,2,6,'$2b$13$H5hN8kcBL92dZOybrGzoy.vxu8K9DZZwLk4W9aOCmQMrsHNc3LfAq','PENDING',NULL,'2026-09-24 11:16:20.107'),(5,3,6,'$2b$13$XxNDH1LW5DVPu334LEy19OzwemlShqNotXMc8WKInxXSLlZ2xKQ52','PENDING',NULL,'2026-09-24 11:17:36.114'),(6,4,6,'$2b$13$o1uUWVeMrbXv0rI4J6CbBeEd/5g8jkT5jMQS09rT4KbgNo4bbR8rC','ACTIVE',NULL,'2026-09-24 11:19:50.327'),(7,5,6,'$2b$13$5QkKbLMX.HJBAvld5jHvNOg2yAIHAbqGU/wVYSj3qAN/85s1Svw2W','PENDING',NULL,'2026-09-24 11:22:40.408'),(8,6,6,'$2b$13$RcAG1rktItpIU3SjB2FehuTWyl/mfCSyM9wdr3TrYHydf2ZB0EkVK','PENDING',NULL,'2026-09-24 11:23:04.894'),(9,7,6,'$2b$13$j2/YGMAZZcAc5BBHLwyV5OCh0wj4tVmepljjjMxVaTGXUth.J9O.q','ACTIVE',NULL,'2026-09-24 11:25:02.927'),(11,8,6,'$2b$13$Y1AIfsHLEFZIXrowShSkYuQ44iLFXjYolanPyjXRPi6TDuMAI5vea','ACTIVE',NULL,'2026-09-24 11:29:49.940'),(13,9,6,'$2b$13$XJ1/DFaOJ.oMN7Q.wIRA5OM9pVqQHjJ4.IxgKb3hJHLVngU4h7RY6','ACTIVE',NULL,'2026-09-24 11:42:38.733'),(15,10,6,'$2b$13$2xBLldBJHQd2FUhbojtD9uxgEAfSVlwXB4P/3.sLgB.DlcUu65l2W','DENIED',NULL,'2026-09-24 11:43:17.244'),(21,11,6,'$2b$13$N37XnPVz2pRI51g4odCr3uPGD0YjCv2E43wuGx1NEomf1yADa..Pe','ACTIVE',NULL,'2026-09-24 11:55:41.414'),(23,12,6,'$2b$13$gKSl1kYsb.yKXyOeUovixOD5.JLUu3U44GoOpNVM8x1XzZkJ8D2iG','DENIED',NULL,'2026-09-24 11:56:18.918'),(26,13,6,'$2b$13$THiS2SyOjq6bELoCsANApeol1fUY19inkrXXkajx/r7ZWbC3npC1u','ACTIVE',NULL,'2026-09-24 12:09:41.626'),(28,14,6,'$2b$13$8aXjxkatotFB3Ggu53t13ujqOW4Ufo7C7VJiq1XJCi59oNzboIfAq','DENIED',NULL,'2026-09-24 12:10:20.215');
/*!40000 ALTER TABLE `driver_company_users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `driver_profile_edit_requests`
--

DROP TABLE IF EXISTS `driver_profile_edit_requests`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `driver_profile_edit_requests` (
  `id` int NOT NULL AUTO_INCREMENT,
  `delivery_id` int NOT NULL,
  `company_id` int NOT NULL,
  `payload` json NOT NULL,
  `status` enum('PENDING_COMPANY','PENDING_ADMIN','APPROVED','REJECTED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING_COMPANY',
  `rejection_reason` text COLLATE utf8mb4_unicode_ci,
  `company_decision_at` datetime(3) DEFAULT NULL,
  `admin_decision_at` datetime(3) DEFAULT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  KEY `driver_profile_edit_requests_company_id_status_idx` (`company_id`,`status`),
  KEY `driver_profile_edit_requests_delivery_id_idx` (`delivery_id`),
  CONSTRAINT `driver_profile_edit_requests_company_id_fkey` FOREIGN KEY (`company_id`) REFERENCES `driver_companies` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `driver_profile_edit_requests_delivery_id_fkey` FOREIGN KEY (`delivery_id`) REFERENCES `delivery` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `driver_profile_edit_requests`
--

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

--
-- Table structure for table `driver_tiers`
--

DROP TABLE IF EXISTS `driver_tiers`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `driver_tiers` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_pl` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_uk` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `priority` int NOT NULL DEFAULT '0',
  `min_rating` double NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` datetime(3) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `driver_tiers_code_key` (`code`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `driver_tiers`
--

LOCK TABLES `driver_tiers` WRITE;
/*!40000 ALTER TABLE `driver_tiers` DISABLE KEYS */;
INSERT INTO `driver_tiers` VALUES (1,'SILVER','فضي','Silver','Srebrny','Срібний',1,0,1,NULL,'2026-09-24 09:56:11.161'),(2,'GOLD','ذهبي','Gold','Złoty','Золотий',2,3.5,1,NULL,'2026-09-24 09:56:11.183'),(3,'DIAMOND','ديموند','Diamond','Diamentowy','Діамантовий',3,4.5,1,NULL,'2026-09-24 09:56:11.194');
/*!40000 ALTER TABLE `driver_tiers` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `emails`
--

DROP TABLE IF EXISTS `emails`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `emails` (
  `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `template_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `template_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `subject_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'subject',
  `subject_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'subject',
  `keys` json NOT NULL,
  `receiver` enum('ADMIN','CUSTOMER','DELIVERYMAN','STORE') COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` datetime(3) DEFAULT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`email`,`receiver`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `emails`
--

LOCK TABLES `emails` WRITE;
/*!40000 ALTER TABLE `emails` DISABLE KEYS */;
INSERT INTO `emails` VALUES ('adminCampaignJoinRequest','<p>{{name}}</p><p>Admin Campaign Join Request</p>','<p>{{name}}</p><p>Admin Campaign Join Request</p>','Admin Campaign Join Request','Admin Campaign Join Request','[\"name\"]','ADMIN',1,'2026-09-24 10:24:53.929','2026-09-24 10:24:53.929',NULL),('adminForgotPassword','<p>{{name}}</p><p>Admin Forgot Password</p>','<p>{{name}}</p><p>Admin Forgot Password</p>','Admin Forgot Password','Admin Forgot Password','[\"name\"]','ADMIN',1,'2026-09-24 10:24:53.729','2026-09-24 10:24:53.729',NULL),('adminNewDeliveryManRegistration','<p>{{name}}</p><p>Admin New Delivery Man Registration</p>','<p>{{name}}</p><p>Admin New Delivery Man Registration</p>','Admin New Delivery Man Registration','Admin New Delivery Man Registration','[\"name\"]','ADMIN',1,'2026-09-24 10:24:53.870','2026-09-24 10:24:53.870',NULL),('adminNewStoreRegistration','<p>{{name}}</p><p>Admin New Store Registration</p>','<p>{{name}}</p><p>Admin New Store Registration</p>','Admin New Store Registration','Admin New Store Registration','[\"name\"]','ADMIN',1,'2026-09-24 10:24:53.765','2026-09-24 10:24:53.765',NULL),('adminRefundRequest','<p>{{name}}</p><p>Admin Refund Request</p>','<p>{{name}}</p><p>Admin Refund Request</p>','Admin Refund Request','Admin Refund Request','[\"name\"]','ADMIN',1,'2026-09-24 10:24:53.984','2026-09-24 10:24:53.984',NULL),('adminWithdrawRequest','<p>{{name}}</p><p>Admin Withdraw Request</p>','<p>{{name}}</p><p>Admin Withdraw Request</p>','Admin Withdraw Request','Admin Withdraw Request','[\"name\"]','ADMIN',1,'2026-09-24 10:24:53.899','2026-09-24 10:24:53.899',NULL),('customerAccountSuspension','<p>{{name}}</p><p>Customer Account Suspension</p>','<p>{{name}}</p><p>Customer Account Suspension</p>','Customer Account Suspension','Customer Account Suspension','[\"name\"]','CUSTOMER',1,'2026-09-24 10:24:55.448','2026-09-24 10:24:55.448',NULL),('customerAccountUnsuspension','<p>{{name}}</p><p>Customer Account Unsuspension</p>','<p>{{name}}</p><p>Customer Account Unsuspension</p>','Customer Account Unsuspension','Customer Account Unsuspension','[\"name\"]','CUSTOMER',1,'2026-09-24 10:24:55.537','2026-09-24 10:24:55.537',NULL),('customerDeliveryVerification','<p>{{name}}</p><p>Customer Delivery Verification</p>','<p>{{name}}</p><p>Customer Delivery Verification</p>','Customer Delivery Verification','Customer Delivery Verification','[\"name\"]','CUSTOMER',1,'2026-09-24 10:24:55.281','2026-09-24 10:24:55.281',NULL),('customerForgotPassword','<p>{{name}}</p><p>Customer Forgot Password</p>','<p>{{name}}</p><p>Customer Forgot Password</p>','Customer Forgot Password','Customer Forgot Password','[\"name\"]','CUSTOMER',1,'2026-09-24 10:24:55.354','2026-09-24 10:24:55.354',NULL),('customerFundAdded','<p>{{name}}</p><p>Customer Fund Added</p>','<p>{{name}}</p><p>Customer Fund Added</p>','Customer Fund Added','Customer Fund Added','[\"name\"]','CUSTOMER',1,'2026-09-24 10:24:55.399','2026-09-24 10:24:55.399',NULL),('customerLoginOTP','<p>{{name}}</p><p>Customer Login O T P</p>','<p>{{name}}</p><p>Customer Login O T P</p>','Customer Login O T P','Customer Login O T P','[\"name\"]','CUSTOMER',1,'2026-09-24 10:24:55.212','2026-09-24 10:24:55.212',NULL),('customerOfflinePaymentApproved','<p>{{name}}</p><p>Customer Offline Payment Approved</p>','<p>{{name}}</p><p>Customer Offline Payment Approved</p>','Customer Offline Payment Approved','Customer Offline Payment Approved','[\"name\"]','CUSTOMER',1,'2026-09-24 10:24:55.407','2026-09-24 10:24:55.407',NULL),('customerOfflinePaymentRejected','<p>{{name}}</p><p>Customer Offline Payment Rejected</p>','<p>{{name}}</p><p>Customer Offline Payment Rejected</p>','Customer Offline Payment Rejected','Customer Offline Payment Rejected','[\"name\"]','CUSTOMER',1,'2026-09-24 10:24:55.423','2026-09-24 10:24:55.423',NULL),('customerOrderPlaced','<p>{{name}}</p><p>Customer Order Placed</p>','<p>{{name}}</p><p>Customer Order Placed</p>','Customer Order Placed','Customer Order Placed','[\"name\"]','CUSTOMER',1,'2026-09-24 10:24:55.303','2026-09-24 10:24:55.303',NULL),('customerOrderRefunded','<p>{{name}}</p><p>Customer Order Refunded</p>','<p>{{name}}</p><p>Customer Order Refunded</p>','Customer Order Refunded','Customer Order Refunded','[\"name\"]','CUSTOMER',1,'2026-09-24 10:24:55.334','2026-09-24 10:24:55.334',NULL),('customerPosRegistration','<p>{{name}}</p><p>Customer Pos Registration</p>','<p>{{name}}</p><p>Customer Pos Registration</p>','Customer Pos Registration','Customer Pos Registration','[\"name\"]','CUSTOMER',1,'2026-09-24 10:24:54.902','2026-09-24 10:24:54.902',NULL),('customerRefundRequestRejected','<p>{{name}}</p><p>Customer Refund Request Rejected</p>','<p>{{name}}</p><p>Customer Refund Request Rejected</p>','Customer Refund Request Rejected','Customer Refund Request Rejected','[\"name\"]','CUSTOMER',1,'2026-09-24 10:24:55.383','2026-09-24 10:24:55.383',NULL),('customerRegistration','<p>{{name}}</p><p>Customer Registration</p>','<p>{{name}}</p><p>Customer Registration</p>','Customer Registration','Customer Registration','[\"name\"]','CUSTOMER',1,'2026-09-24 10:24:54.766','2026-09-24 10:24:54.766',NULL),('customerRegistrationOTP','<p>{{name}}</p><p>Customer Registration O T P</p>','<p>{{name}}</p><p>Customer Registration O T P</p>','Customer Registration O T P','Customer Registration O T P','[\"name\"]','CUSTOMER',1,'2026-09-24 10:24:54.953','2026-09-24 10:24:54.953',NULL),('deliveryManAccountSuspension','<p>{{name}}</p><p>Delivery Man Account Suspension</p>','<p>{{name}}</p><p>Delivery Man Account Suspension</p>','Delivery Man Account Suspension','Delivery Man Account Suspension','[\"name\"]','DELIVERYMAN',1,'2026-09-24 10:24:54.677','2026-09-24 10:24:54.677',NULL),('deliveryManAccountUnsuspension','<p>{{name}}</p><p>Delivery Man Account Unsuspension</p>','<p>{{name}}</p><p>Delivery Man Account Unsuspension</p>','Delivery Man Account Unsuspension','Delivery Man Account Unsuspension','[\"name\"]','DELIVERYMAN',1,'2026-09-24 10:24:54.715','2026-09-24 10:24:54.715',NULL),('deliveryManCashCollection','<p>{{name}}</p><p>Delivery Man Cash Collection</p>','<p>{{name}}</p><p>Delivery Man Cash Collection</p>','Delivery Man Cash Collection','Delivery Man Cash Collection','[\"name\"]','DELIVERYMAN',1,'2026-09-24 10:24:54.732','2026-09-24 10:24:54.732',NULL),('deliveryManForgotPassword','<p>{{name}}</p><p>Delivery Man Forgot Password</p>','<p>{{name}}</p><p>Delivery Man Forgot Password</p>','Delivery Man Forgot Password','Delivery Man Forgot Password','[\"name\"]','DELIVERYMAN',1,'2026-09-24 10:24:54.749','2026-09-24 10:24:54.749',NULL),('deliveryManRegistration','<p>{{name}}</p><p>Delivery Man Registration</p>','<p>{{name}}</p><p>Delivery Man Registration</p>','Delivery Man Registration','Delivery Man Registration','[\"name\"]','DELIVERYMAN',1,'2026-09-24 10:24:54.583','2026-09-24 10:24:54.583',NULL),('deliveryManRegistrationApproved','<p>{{name}}</p><p>Delivery Man Registration Approved</p>','<p>{{name}}</p><p>Delivery Man Registration Approved</p>','Delivery Man Registration Approved','Delivery Man Registration Approved','[\"name\"]','DELIVERYMAN',1,'2026-09-24 10:24:54.630','2026-09-24 10:24:54.630',NULL),('deliveryManRegistrationRejected','<p>{{name}}</p><p>Delivery Man Registration Rejected</p>','<p>{{name}}</p><p>Delivery Man Registration Rejected</p>','Delivery Man Registration Rejected','Delivery Man Registration Rejected','[\"name\"]','DELIVERYMAN',1,'2026-09-24 10:24:54.656','2026-09-24 10:24:54.656',NULL),('storeAccountSuspension','<p>{{name}}</p><p>Store Account Suspension</p>','<p>{{name}}</p><p>Store Account Suspension</p>','Store Account Suspension','Store Account Suspension','[\"name\"]','STORE',1,'2026-09-24 10:24:54.073','2026-09-24 10:24:54.073',NULL),('storeAccountUnsuspension','<p>{{name}}</p><p>Store Account Unsuspension</p>','<p>{{name}}</p><p>Store Account Unsuspension</p>','Store Account Unsuspension','Store Account Unsuspension','[\"name\"]','STORE',1,'2026-09-24 10:24:54.093','2026-09-24 10:24:54.093',NULL),('storeAdvertisementApproved','<p>{{name}}</p><p>Store Advertisement Approved</p>','<p>{{name}}</p><p>Store Advertisement Approved</p>','Store Advertisement Approved','Store Advertisement Approved','[\"name\"]','STORE',1,'2026-09-24 10:24:54.420','2026-09-24 10:24:54.420',NULL),('storeAdvertisementCreatedByAdmin','<p>{{name}}</p><p>Store Advertisement Created By Admin</p>','<p>{{name}}</p><p>Store Advertisement Created By Admin</p>','Store Advertisement Created By Admin','Store Advertisement Created By Admin','[\"name\"]','STORE',1,'2026-09-24 10:24:54.408','2026-09-24 10:24:54.408',NULL),('storeAdvertisementPaused','<p>{{name}}</p><p>Store Advertisement Paused</p>','<p>{{name}}</p><p>Store Advertisement Paused</p>','Store Advertisement Paused','Store Advertisement Paused','[\"name\"]','STORE',1,'2026-09-24 10:24:54.456','2026-09-24 10:24:54.456',NULL),('storeAdvertisementRejected','<p>{{name}}</p><p>Store Advertisement Rejected</p>','<p>{{name}}</p><p>Store Advertisement Rejected</p>','Store Advertisement Rejected','Store Advertisement Rejected','[\"name\"]','STORE',1,'2026-09-24 10:24:54.428','2026-09-24 10:24:54.428',NULL),('storeAdvertisementResumed','<p>{{name}}</p><p>Store Advertisement Resumed</p>','<p>{{name}}</p><p>Store Advertisement Resumed</p>','Store Advertisement Resumed','Store Advertisement Resumed','[\"name\"]','STORE',1,'2026-09-24 10:24:54.442','2026-09-24 10:24:54.442',NULL),('storeCampaignJoinApproved','<p>{{name}}</p><p>Store Campaign Join Approved</p>','<p>{{name}}</p><p>Store Campaign Join Approved</p>','Store Campaign Join Approved','Store Campaign Join Approved','[\"name\"]','STORE',1,'2026-09-24 10:24:54.141','2026-09-24 10:24:54.141',NULL),('storeCampaignJoinRejected','<p>{{name}}</p><p>Store Campaign Join Rejected</p>','<p>{{name}}</p><p>Store Campaign Join Rejected</p>','Store Campaign Join Rejected','Store Campaign Join Rejected','[\"name\"]','STORE',1,'2026-09-24 10:24:54.155','2026-09-24 10:24:54.155',NULL),('storeCampaignJoinRequest','<p>{{name}}</p><p>Store Campaign Join Request</p>','<p>{{name}}</p><p>Store Campaign Join Request</p>','Store Campaign Join Request','Store Campaign Join Request','[\"name\"]','STORE',1,'2026-09-24 10:24:54.134','2026-09-24 10:24:54.134',NULL),('storeProductApproved','<p>{{name}}</p><p>Store Product Approved</p>','<p>{{name}}</p><p>Store Product Approved</p>','Store Product Approved','Store Product Approved','[\"name\"]','STORE',1,'2026-09-24 10:24:54.163','2026-09-24 10:24:54.163',NULL),('storeProductRejected','<p>{{name}}</p><p>Store Product Rejected</p>','<p>{{name}}</p><p>Store Product Rejected</p>','Store Product Rejected','Store Product Rejected','[\"name\"]','STORE',1,'2026-09-24 10:24:54.181','2026-09-24 10:24:54.181',NULL),('storeRegistration','<p>{{name}}</p><p>Store Registration</p>','<p>{{name}}</p><p>Store Registration</p>','Store Registration','Store Registration','[\"name\"]','STORE',1,'2026-09-24 10:24:54.008','2026-09-24 10:24:54.008',NULL),('storeRegistrationApproved','<p>{{name}}</p><p>Store Registration Approved</p>','<p>{{name}}</p><p>Store Registration Approved</p>','Store Registration Approved','Store Registration Approved','[\"name\"]','STORE',1,'2026-09-24 10:24:54.034','2026-09-24 10:24:54.034',NULL),('storeRegistrationRejected','<p>{{name}}</p><p>Store Registration Rejected</p>','<p>{{name}}</p><p>Store Registration Rejected</p>','Store Registration Rejected','Store Registration Rejected','[\"name\"]','STORE',1,'2026-09-24 10:24:54.051','2026-09-24 10:24:54.051',NULL),('storeSubscriptionCancelled','<p>{{name}}</p><p>Store Subscription Cancelled</p>','<p>{{name}}</p><p>Store Subscription Cancelled</p>','Store Subscription Cancelled','Store Subscription Cancelled','[\"name\"]','STORE',1,'2026-09-24 10:24:54.334','2026-09-24 10:24:54.334',NULL),('storeSubscriptionPlanUpdated','<p>{{name}}</p><p>Store Subscription Plan Updated</p>','<p>{{name}}</p><p>Store Subscription Plan Updated</p>','Store Subscription Plan Updated','Store Subscription Plan Updated','[\"name\"]','STORE',1,'2026-09-24 10:24:54.352','2026-09-24 10:24:54.352',NULL),('storeSubscriptionRenewed','<p>{{name}}</p><p>Store Subscription Renewed</p>','<p>{{name}}</p><p>Store Subscription Renewed</p>','Store Subscription Renewed','Store Subscription Renewed','[\"name\"]','STORE',1,'2026-09-24 10:24:54.301','2026-09-24 10:24:54.301',NULL),('storeSubscriptionShifted','<p>{{name}}</p><p>Store Subscription Shifted</p>','<p>{{name}}</p><p>Store Subscription Shifted</p>','Store Subscription Shifted','Store Subscription Shifted','[\"name\"]','STORE',1,'2026-09-24 10:24:54.314','2026-09-24 10:24:54.314',NULL),('storeSubscriptionSuccessful','<p>{{name}}</p><p>Store Subscription Successful</p>','<p>{{name}}</p><p>Store Subscription Successful</p>','Store Subscription Successful','Store Subscription Successful','[\"name\"]','STORE',1,'2026-09-24 10:24:54.209','2026-09-24 10:24:54.209',NULL),('storeWithdrawApproved','<p>{{name}}</p><p>Store Withdraw Approved</p>','<p>{{name}}</p><p>Store Withdraw Approved</p>','Store Withdraw Approved','Store Withdraw Approved','[\"name\"]','STORE',1,'2026-09-24 10:24:54.115','2026-09-24 10:24:54.115',NULL),('storeWithdrawRejected','<p>{{name}}</p><p>Store Withdraw Rejected</p>','<p>{{name}}</p><p>Store Withdraw Rejected</p>','Store Withdraw Rejected','Store Withdraw Rejected','[\"name\"]','STORE',1,'2026-09-24 10:24:54.122','2026-09-24 10:24:54.122',NULL);
/*!40000 ALTER TABLE `emails` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `favorite_store`
--

DROP TABLE IF EXISTS `favorite_store`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `favorite_store` (
  `store_id` int NOT NULL,
  `customer_id` int NOT NULL,
  PRIMARY KEY (`store_id`,`customer_id`),
  KEY `favorite_store_store_id_customer_id_idx` (`store_id`,`customer_id`),
  KEY `favorite_store_customer_id_fkey` (`customer_id`),
  CONSTRAINT `favorite_store_customer_id_fkey` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `favorite_store_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `favorite_store`
--

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

--
-- Table structure for table `fund`
--

DROP TABLE IF EXISTS `fund`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `fund` (
  `id` int NOT NULL AUTO_INCREMENT,
  `customer_id` int NOT NULL,
  `price` int NOT NULL DEFAULT '0',
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fund_customer_id_fkey` (`customer_id`),
  CONSTRAINT `fund_customer_id_fkey` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fund`
--

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

--
-- Table structure for table `ingredients`
--

DROP TABLE IF EXISTS `ingredients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `ingredients` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` datetime(3) 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 `ingredients`
--

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

--
-- Table structure for table `item_campaign`
--

DROP TABLE IF EXISTS `item_campaign`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `item_campaign` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nameAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nameEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descriptionAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descriptionEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_date` datetime(3) NOT NULL,
  `end_date` datetime(3) NOT NULL,
  `opening_time` time NOT NULL,
  `closing_time` time NOT NULL,
  `categoryId` int NOT NULL,
  `storeId` int NOT NULL,
  `subCategoryId` int NOT NULL,
  `moduleId` int NOT NULL,
  `total_stock` int DEFAULT '0',
  `maximum_cart_quantity` int DEFAULT '0',
  `price` decimal(24,2) NOT NULL DEFAULT '0.00',
  `discount` decimal(24,2) DEFAULT '0.00',
  `color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `size` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ingredients` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nutrition` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `discount_type` enum('PERCENTAGE','AMOUNT','NONE') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PERCENTAGE',
  PRIMARY KEY (`id`),
  KEY `item_campaign_moduleId_fkey` (`moduleId`),
  KEY `item_campaign_storeId_fkey` (`storeId`),
  KEY `item_campaign_categoryId_fkey` (`categoryId`),
  KEY `item_campaign_subCategoryId_fkey` (`subCategoryId`),
  CONSTRAINT `item_campaign_categoryId_fkey` FOREIGN KEY (`categoryId`) REFERENCES `category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `item_campaign_moduleId_fkey` FOREIGN KEY (`moduleId`) REFERENCES `module` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `item_campaign_storeId_fkey` FOREIGN KEY (`storeId`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `item_campaign_subCategoryId_fkey` FOREIGN KEY (`subCategoryId`) REFERENCES `category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `item_campaign`
--

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

--
-- Table structure for table `key_value`
--

DROP TABLE IF EXISTS `key_value`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `key_value` (
  `id` int NOT NULL AUTO_INCREMENT,
  `key` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `valueAr` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `valueEn` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updatedAt` datetime(3) NOT NULL,
  `deletedAt` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `key_value`
--

LOCK TABLES `key_value` WRITE;
/*!40000 ALTER TABLE `key_value` DISABLE KEYS */;
INSERT INTO `key_value` VALUES (1,'privacy_policy','سياسة الخصوصية — نص تجريبي. يُرجى تحديثه من لوحة التحكم.','Privacy Policy — placeholder text. Please update from the admin panel.','2026-09-24 10:24:53.595','2026-09-24 10:48:19.572',NULL),(2,'terms_and_conditions','الشروط والأحكام — نص تجريبي. يُرجى تحديثه من لوحة التحكم.','Terms and Conditions — placeholder text. Please update from the admin panel.','2026-09-24 10:24:53.709','2026-09-24 10:48:19.583',NULL),(3,'about_us','من نحن — DeliverUs منصة توصيل متعددة الخدمات.','About Us — DeliverUs is a multi-service delivery platform.','2026-09-24 10:24:53.721','2026-09-24 10:48:19.592',NULL);
/*!40000 ALTER TABLE `key_value` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `loyalty_point`
--

DROP TABLE IF EXISTS `loyalty_point`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `loyalty_point` (
  `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_Id` int NOT NULL,
  `earned` decimal(65,30) NOT NULL DEFAULT '0.000000000000000000000000000000',
  `converted` decimal(65,30) NOT NULL DEFAULT '0.000000000000000000000000000000',
  `current` decimal(65,30) NOT NULL DEFAULT '0.000000000000000000000000000000',
  `createdAt` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `type` enum('OrderPlace','LoyaltyPoint') COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `loyalty_point_customer_Id_fkey` (`customer_Id`),
  CONSTRAINT `loyalty_point_customer_Id_fkey` FOREIGN KEY (`customer_Id`) REFERENCES `customer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `loyalty_point`
--

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

--
-- Table structure for table `message`
--

DROP TABLE IF EXISTS `message`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `message` (
  `id` int NOT NULL AUTO_INCREMENT,
  `conversation_id` int NOT NULL,
  `sender_id` int NOT NULL,
  `receiver_id` int NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `content` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `read` tinyint(1) NOT NULL DEFAULT '1',
  `type` enum('TEXT','IMAGE','VIDEO','FILE') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'TEXT',
  PRIMARY KEY (`id`),
  KEY `message_sender_id_receiver_id_idx` (`sender_id`,`receiver_id`),
  KEY `message_conversation_id_fkey` (`conversation_id`),
  KEY `message_receiver_id_fkey` (`receiver_id`),
  CONSTRAINT `message_conversation_id_fkey` FOREIGN KEY (`conversation_id`) REFERENCES `conversation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `message_receiver_id_fkey` FOREIGN KEY (`receiver_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `message_sender_id_fkey` FOREIGN KEY (`sender_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `message`
--

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

--
-- Table structure for table `module`
--

DROP TABLE IF EXISTS `module`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `module` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_ar` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description_ar` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `description_en` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `replacement_and_retrieval_policy_ar` text COLLATE utf8mb4_unicode_ci,
  `replacement_and_retrieval_policy_en` text COLLATE utf8mb4_unicode_ci,
  `thumbnail` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `isActive` tinyint(1) NOT NULL DEFAULT '1',
  `icon` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('GROCERY','FOOD','PHARMACY','ECOMMERCE','PARCEL') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `module`
--

LOCK TABLES `module` WRITE;
/*!40000 ALTER TABLE `module` DISABLE KEYS */;
INSERT INTO `module` VALUES (1,'بقالة','Grocery','بقالة','Grocery','<p>•	إلغاء الطلب: عادة ما يكون هناك فترة زمنية محددة لإلغاء الطلب بعد تأكيده، مثل 3 دقائق،	•	استرجاع الأموال: في حالة إلغاء الطلب بعد بدء مراحل التوصيل، قد لا يتم استرداد المبلغ بسهولة، وقد يتطلب التواصل مع الدعم الفني للتطبيق.</p><p>	•	جودة الوجبة: إذا وصلت الوجبة وكانت غير مطابقة للمواصفات المطلوبة أو متضررة، يمكن التواصل مع الدعم الفني للتطبيق لطلب استبدال أو استرجاع المبلغ.</p><p><br></p><ul><li>وقت التوصيل: يتم تقدير وقت التوصيل بناءً</li><li>على المسافة بين المطعم والعميل، وقد يكون هناك توصيل سريع في بعض المناطق حيث توجد مطاعم ومناديب كثيرين.</li><li>رسوم التوصيل: تختلف رسوم التوصيل حسب المطعم ومسافة التوصيل. يمكن أن تكون هناك عروض توصيل مجاني للعملاء الجدد أو خلال فترات ترويجية معينة.</li><li>تتبع الطلب: يوفر التطبيق ميزة تتبع الطلب حيث يمكن للعميل معرفة حالة طلبه من خلال عدة مراحل (مثل: تم، ندور لك على كابتن، ترسل للمطعم، الطلب بالمطبخ).</li><li>دفع الفاتورة: يمكن الدفع عند الاستلام أو باستخدام بطاقات الائتمان مباشرة من خلال التطبيق. في حالة الدفع عبر البطاقة، يتم الخصم فوراً عند تأكيد الطلب.</li><li>نقاط الولاء: يوجد برنامج لنقاط الولاء حيث يمكن للعملاء تجميع نقاط لكل ريال ينفقونه، والتي يمكن استردادها للحصول على عروض خاصة أو تخفيضات.</li><li>عروض وتخفيضات: يتم تقديم عروض وتخفيضات من خلال التطبيق بانتظام، بما في ذلك كوبونات الخصم التي يمكن استخدامها لتقليل تكلفة الطلب أو رسوم التوصيل.</li><li>الدعم الفني: يتوفر دعم فني يمكن التواصل معه عبر الهاتف أو رسائل التطبيق لحل أي مشاكل تواجه العملاء.</li><li>التوصيل المجاني: قد يكون هناك توصيل مجاني للعملاء الجدد أو خلال فترات ترويجية خاصة، مثل عروض 100 يوم أو 180 يوم توصيل مجاني</li><li>الاستبدال والاسترجاع: يمكن إرجاع المنتجات أو استبدالها إذا لم يتم استخدامها وكانت في حالتها الأصلية، وذلك خلال فترة زمنية محددة تبلغ عادةً 7 إلى 14 يومًا من تاريخ الاستلام أو الشراء، حسبًا لنوع المنتج.</li><li>شروط الاسترجاع:</li><li class=\"ql-indent-1\">يجب أن تكون البضاعة في حالتها الأصلية، داخل تغليفها الأصلي دون أي أضرار أو استخدام.</li><li class=\"ql-indent-1\">يجب إرفاق فاتورة الشراء الأصلية أو الإلكترونية.</li><li class=\"ql-indent-1\">لا يُسمح باسترجاع أو استبدال المنتجات التي تم شراؤها من خلال عروض خاصة أو باقات معينة، ما لم تكن هناك مشاكل في الصناعة أو التوصيل.</li><li>رسوم الشحن: في حالة استبدال أو استرجاع المنتجات، قد يتم خصم رسوم الشحن من المبلغ المسترجع، وخاصة إذا كان الاسترجاع بسبب تغيير فكر العميل وليس بسبب عيب في المنتج.</li><li>مدة استرجاع الأموال: بعد استلام المنتج المرتجع وفحصه، يتم استرجاع الأموال خلال فترة تتراوح من 7 إلى 14 يومًا عمل، بناءً على طريقة الدفع الأصلية.</li><li>استثناءات: لا يمكن إرجاع أو استبدال بعض المنتجات مثل الملابس الداخلية، المنتجات الشخصية التي تخضع لشروط صحية، أو المنتجات المفتوحة المغلفة.</li><li>خدمة العملاء: يتم التواصل مع خدمة العملاء لطلب تصريح إرجاع المواد قبل إرسال المنتج المراد استرجاعه أو استبداله.</li></ul><p>‎هذه النقاط توضح بشكل عام ما تشمله سياسة الاستبدال والاسترجاع لتطبيق ديلڤر آص ، لكن من الأفضل التحقق من التفاصيل المحدثة من خلال التطبيق نفسه أو من خلال التواصل مع خدمة العملاء للتأكد من أي تعديلات أو إضافات جديدة.</p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p>','<p>•	إلغاء الطلب: عادة ما يكون هناك فترة زمنية محددة لإلغاء الطلب بعد تأكيده، مثل 3 دقائق،	•	استرجاع الأموال: في حالة إلغاء الطلب بعد بدء مراحل التوصيل، قد لا يتم استرداد المبلغ بسهولة، وقد يتطلب التواصل مع الدعم الفني للتطبيق.</p><p>	•	جودة الوجبة: إذا وصلت الوجبة وكانت غير مطابقة للمواصفات المطلوبة أو متضررة، يمكن التواصل مع الدعم الفني للتطبيق لطلب استبدال أو استرجاع المبلغ.</p><p><br></p><ul><li>وقت التوصيل: يتم تقدير وقت التوصيل بناءً</li><li>على المسافة بين المطعم والعميل، وقد يكون هناك توصيل سريع في بعض المناطق حيث توجد مطاعم ومناديب كثيرين.</li><li>رسوم التوصيل: تختلف رسوم التوصيل حسب المطعم ومسافة التوصيل. يمكن أن تكون هناك عروض توصيل مجاني للعملاء الجدد أو خلال فترات ترويجية معينة.</li><li>تتبع الطلب: يوفر التطبيق ميزة تتبع الطلب حيث يمكن للعميل معرفة حالة طلبه من خلال عدة مراحل (مثل: تم، ندور لك على كابتن، ترسل للمطعم، الطلب بالمطبخ).</li><li>دفع الفاتورة: يمكن الدفع عند الاستلام أو باستخدام بطاقات الائتمان مباشرة من خلال التطبيق. في حالة الدفع عبر البطاقة، يتم الخصم فوراً عند تأكيد الطلب.</li><li>نقاط الولاء: يوجد برنامج لنقاط الولاء حيث يمكن للعملاء تجميع نقاط لكل ريال ينفقونه، والتي يمكن استردادها للحصول على عروض خاصة أو تخفيضات.</li><li>عروض وتخفيضات: يتم تقديم عروض وتخفيضات من خلال التطبيق بانتظام، بما في ذلك كوبونات الخصم التي يمكن استخدامها لتقليل تكلفة الطلب أو رسوم التوصيل.</li><li>الدعم الفني: يتوفر دعم فني يمكن التواصل معه عبر الهاتف أو رسائل التطبيق لحل أي مشاكل تواجه العملاء.</li><li>التوصيل المجاني: قد يكون هناك توصيل مجاني للعملاء الجدد أو خلال فترات ترويجية خاصة، مثل عروض 100 يوم أو 180 يوم توصيل مجاني</li></ul><p>‎سياسة الاستبدال والاسترجاع لتطبيق ديلڤر آص تشمل عدة نقاط رئيسية:</p><p>	•	إلغاء الطلب: عادة ما يكون هناك فترة زمنية محددة لإلغاء الطلب بعد تأكيده، مثل 3 دقائق،	•	استرجاع الأموال: في حالة إلغاء الطلب بعد بدء مراحل التوصيل، قد لا يتم استرداد المبلغ بسهولة، وقد يتطلب التواصل مع الدعم الفني للتطبيق.</p><p>	•	جودة الوجبة: إذا وصلت الوجبة وكانت غير مطابقة للمواصفات المطلوبة أو متضررة، يمكن التواصل مع الدعم الفني للتطبيق لطلب استبدال أو استرجاع المبلغ.</p><p><br></p><ul><li>وقت التوصيل: يتم تقدير وقت التوصيل بناءً</li><li>على المسافة بين المطعم والعميل، وقد يكون هناك توصيل سريع في بعض المناطق حيث توجد مطاعم ومناديب كثيرين.</li><li>رسوم التوصيل: تختلف رسوم التوصيل حسب المطعم ومسافة التوصيل. يمكن أن تكون هناك عروض توصيل مجاني للعملاء الجدد أو خلال فترات ترويجية معينة.</li><li>تتبع الطلب: يوفر التطبيق ميزة تتبع الطلب حيث يمكن للعميل معرفة حالة طلبه من خلال عدة مراحل (مثل: تم، ندور لك على كابتن، ترسل للمطعم، الطلب بالمطبخ).</li><li>دفع الفاتورة: يمكن الدفع عند الاستلام أو باستخدام بطاقات الائتمان مباشرة من خلال التطبيق. في حالة الدفع عبر البطاقة، يتم الخصم فوراً عند تأكيد الطلب.</li><li>نقاط الولاء: يوجد برنامج لنقاط الولاء حيث يمكن للعملاء تجميع نقاط لكل ريال ينفقونه، والتي يمكن استردادها للحصول على عروض خاصة أو تخفيضات.</li><li>عروض وتخفيضات: يتم تقديم عروض وتخفيضات من خلال التطبيق بانتظام، بما في ذلك كوبونات الخصم التي يمكن استخدامها لتقليل تكلفة الطلب أو رسوم التوصيل.</li><li>الدعم الفني: يتوفر دعم فني يمكن التواصل معه عبر الهاتف أو رسائل التطبيق لحل أي مشاكل تواجه العملاء.</li><li>التوصيل المجاني: قد يكون هناك توصيل مجاني للعملاء الجدد أو خلال فترات ترويجية خاصة، مثل عروض 100 يوم أو 180 يوم توصيل مجاني</li><li>الاستبدال والاسترجاع: يمكن إرجاع المنتجات أو استبدالها إذا لم يتم استخدامها وكانت في حالتها الأصلية، وذلك خلال فترة زمنية محددة تبلغ عادةً 7 إلى 14 يومًا من تاريخ الاستلام أو الشراء، حسبًا لنوع المنتج.</li><li>شروط الاسترجاع:</li><li class=\"ql-indent-1\">يجب أن تكون البضاعة في حالتها الأصلية، داخل تغليفها الأصلي دون أي أضرار أو استخدام.</li><li class=\"ql-indent-1\">يجب إرفاق فاتورة الشراء الأصلية أو الإلكترونية.</li><li class=\"ql-indent-1\">لا يُسمح باسترجاع أو استبدال المنتجات التي تم شراؤها من خلال عروض خاصة أو باقات معينة، ما لم تكن هناك مشاكل في الصناعة أو التوصيل.</li><li>رسوم الشحن: في حالة استبدال أو استرجاع المنتجات، قد يتم خصم رسوم الشحن من المبلغ المسترجع، وخاصة إذا كان الاسترجاع بسبب تغيير فكر العميل وليس بسبب عيب في المنتج.</li><li>مدة استرجاع الأموال: بعد استلام المنتج المرتجع وفحصه، يتم استرجاع الأموال خلال فترة تتراوح من 7 إلى 14 يومًا عمل، بناءً على طريقة الدفع الأصلية.</li><li>استثناءات: لا يمكن إرجاع أو استبدال بعض المنتجات مثل الملابس الداخلية، المنتجات الشخصية التي تخضع لشروط صحية، أو المنتجات المفتوحة المغلفة.</li><li>خدمة العملاء: يتم التواصل مع خدمة العملاء لطلب تصريح إرجاع المواد قبل إرسال المنتج المراد استرجاعه أو استبداله.</li></ul><p>‎هذه النقاط توضح بشكل عام ما تشمله سياسة الاستبدال والاسترجاع لتطبيق ديلڤر آص ، لكن من الأفضل التحقق من التفاصيل المحدثة من خلال التطبيق نفسه أو من خلال التواصل مع خدمة العملاء للتأكد من أي تعديلات أو إضافات جديدة.</p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p>','uploads/modules/image/Edit/thumbnail-8a8db840-166d-473d-924d-2747446251b3.png',1,'uploads/modules/image/Edit/icon-98d517e7-320f-4555-a329-599db8eca09c.png','GROCERY','2025-01-27 17:20:52.371',NULL),(2,'صيدلية','Pharmacy','صيدلية','Pharmacy',NULL,NULL,'uploads/modules/image/Edit/thumbnail-61fe3ee0-2a2c-4d5b-9e97-ef7dabfabffb.png',1,'uploads/modules/image/Edit/icon-c5e1b806-8e2c-475b-ab51-ccefa5a42d60.png','PHARMACY','2025-01-27 17:20:52.371',NULL),(3,'متجر','Shop','متجر','Shop',NULL,NULL,'uploads/modules/image/Edit/thumbnail-712ac3c7-9884-444e-8cf1-89ba4e728ca8.png',1,'uploads/modules/image/Edit/icon-cb6c63db-3236-4621-a05b-80c74821a75e.png','ECOMMERCE','2025-01-27 17:20:52.371',NULL),(4,'مطاعم','Food','مطاعم','Food',NULL,NULL,'uploads/modules/image/Edit/thumbnail-30efb558-8ca4-4d7a-9cb7-77bb8d0dc7df.png',1,'uploads/modules/image/Edit/icon-c18e8855-bff1-4566-85cd-ede444b5af01.png','FOOD','2025-01-27 17:20:52.371',NULL),(5,'مرسول','Parcel','lvsssssss,g','lvsssssss,g',NULL,NULL,'uploads/modules/image/Edit/thumbnail-cce3db31-4a49-4c55-ac70-f29bb0291cdc.png',1,'uploads/modules/image/Edit/icon-5ed4fba4-fd78-4d86-80c6-5625f735ba4e.png','PARCEL','2025-01-27 17:20:52.371',NULL);
/*!40000 ALTER TABLE `module` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `nationalities`
--

DROP TABLE IF EXISTS `nationalities`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `nationalities` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=148 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `nationalities`
--

LOCK TABLES `nationalities` WRITE;
/*!40000 ALTER TABLE `nationalities` DISABLE KEYS */;
INSERT INTO `nationalities` VALUES (1,'أفغانستاني','Afghan',NULL),(2,'ألباني','Albanian',NULL),(3,'جزائري','Algerian',NULL),(4,'أمريكي','American',NULL),(5,'أندوري','Andorran',NULL),(6,'أنغولي','Angolan',NULL),(7,'أرجنتيني','Argentine',NULL),(8,'أرميني','Armenian',NULL),(9,'أسترالي','Australian',NULL),(10,'نمساوي','Austrian',NULL),(11,'أذربيجاني','Azerbaijani',NULL),(12,'بحريني','Bahraini',NULL),(13,'بنغلاديشي','Bangladeshi',NULL),(14,'باربادوسي','Barbadian',NULL),(15,'بيلاروسي','Belarusian',NULL),(16,'بلجيكي','Belgian',NULL),(17,'بليزي','Belizean',NULL),(18,'بنيني','Beninese',NULL),(19,'بوتاني','Bhutanese',NULL),(20,'بوليفي','Bolivian',NULL),(21,'بوسني','Bosnian',NULL),(22,'برازيلي','Brazilian',NULL),(23,'بريطاني','British',NULL),(24,'بروني','Bruneian',NULL),(25,'بلغاري','Bulgarian',NULL),(26,'بوركيني','Burkinabe',NULL),(27,'بوروندي','Burundian',NULL),(28,'كمبودي','Cambodian',NULL),(29,'كاميروني','Cameroonian',NULL),(30,'كندي','Canadian',NULL),(31,'تشادي','Chadian',NULL),(32,'تشيلي','Chilean',NULL),(33,'صيني','Chinese',NULL),(34,'كولومبي','Colombian',NULL),(35,'كونغولي','Congolese',NULL),(36,'كوستاريكي','Costa Rican',NULL),(37,'كرواتي','Croatian',NULL),(38,'كوبي','Cuban',NULL),(39,'قبرصي','Cypriot',NULL),(40,'تشيكي','Czech',NULL),(41,'دانماركي','Danish',NULL),(42,'دومينيكي','Dominican',NULL),(43,'إكوادوري','Ecuadorian',NULL),(44,'مصري','Egyptian',NULL),(45,'إنجليزي','English',NULL),(46,'إريتري','Eritrean',NULL),(47,'إستوني','Estonian',NULL),(48,'إثيوبي','Ethiopian',NULL),(49,'فلبيني','Filipino',NULL),(50,'فنلندي','Finnish',NULL),(51,'فرنسي','French',NULL),(52,'غابوني','Gabonese',NULL),(53,'غامبي','Gambian',NULL),(54,'جورجي','Georgian',NULL),(55,'ألماني','German',NULL),(56,'غاني','Ghanaian',NULL),(57,'يوناني','Greek',NULL),(58,'غرينادي','Grenadian',NULL),(59,'غواتيمالي','Guatemalan',NULL),(60,'غيني','Guinean',NULL),(61,'غيانا','Guyanese',NULL),(62,'هايتي','Haitian',NULL),(63,'هندوراسي','Honduran',NULL),(64,'هنغاري','Hungarian',NULL),(65,'آيسلندي','Icelandic',NULL),(66,'هندي','Indian',NULL),(67,'إندونيسي','Indonesian',NULL),(68,'إيراني','Iranian',NULL),(69,'عراقي','Iraqi',NULL),(70,'إيرلندي','Irish',NULL),(71,'إيطالي','Italian',NULL),(72,'جامايكي','Jamaican',NULL),(73,'ياباني','Japanese',NULL),(74,'أردني','Jordanian',NULL),(75,'كازاخستاني','Kazakh',NULL),(76,'كيني','Kenyan',NULL),(77,'كوري شمالي','North Korean',NULL),(78,'كوري جنوبي','South Korean',NULL),(79,'كويتي','Kuwaiti',NULL),(80,'لبناني','Lebanese',NULL),(81,'ليبيري','Liberian',NULL),(82,'ليبي','Libyan',NULL),(83,'ليختنشتايني','Liechtensteiner',NULL),(84,'ليتواني','Lithuanian',NULL),(85,'لوكسمبورغي','Luxembourger',NULL),(86,'مقدوني','Macedonian',NULL),(87,'مالاوي','Malawian',NULL),(88,'ماليزي','Malaysian',NULL),(89,'مالديفي','Maldivian',NULL),(90,'مالي','Malian',NULL),(91,'مالطي','Maltese',NULL),(92,'موريتاني','Mauritanian',NULL),(93,'مكسيكي','Mexican',NULL),(94,'مولدوفي','Moldovan',NULL),(95,'موناكو','Monacan',NULL),(96,'منغولي','Mongolian',NULL),(97,'مغربي','Moroccan',NULL),(98,'موزمبيقي','Mozambican',NULL),(99,'ناميبي','Namibian',NULL),(100,'نيبالي','Nepalese',NULL),(101,'هولندي','Dutch',NULL),(102,'نيوزيلندي','New Zealander',NULL),(103,'نيكاراغوي','Nicaraguan',NULL),(104,'نيجيري','Nigerian',NULL),(105,'نرويجي','Norwegian',NULL),(106,'عماني','Omani',NULL),(107,'باكستاني','Pakistani',NULL),(108,'بنمي','Panamanian',NULL),(109,'باراغواي','Paraguayan',NULL),(110,'بيروي','Peruvian',NULL),(111,'بولندي','Polish',NULL),(112,'برتغالي','Portuguese',NULL),(113,'قطري','Qatari',NULL),(114,'روماني','Romanian',NULL),(115,'روسي','Russian',NULL),(116,'رواندي','Rwandan',NULL),(117,'سعودي','Saudi',NULL),(118,'اسكتلندي','Scottish',NULL),(119,'سنغالي','Senegalese',NULL),(120,'صربي','Serbian',NULL),(121,'سنغافوري','Singaporean',NULL),(122,'سلوفاكي','Slovak',NULL),(123,'سلوفيني','Slovenian',NULL),(124,'صومالي','Somali',NULL),(125,'جنوب أفريقي','South African',NULL),(126,'إسباني','Spanish',NULL),(127,'سريلانكي','Sri Lankan',NULL),(128,'سوداني','Sudanese',NULL),(129,'سويدي','Swedish',NULL),(130,'سويسري','Swiss',NULL),(131,'سوري','Syrian',NULL),(132,'تايواني','Taiwanese',NULL),(133,'تنزاني','Tanzanian',NULL),(134,'تايلندي','Thai',NULL),(135,'تونسي','Tunisian',NULL),(136,'تركي','Turkish',NULL),(137,'تركمانستاني','Turkmen',NULL),(138,'أوغندي','Ugandan',NULL),(139,'أوكراني','Ukrainian',NULL),(140,'إماراتي','Emirati',NULL),(141,'أوروغواي','Uruguayan',NULL),(142,'أوزبكي','Uzbek',NULL),(143,'فنزويلي','Venezuelan',NULL),(144,'فيتنامي','Vietnamese',NULL),(145,'يمني','Yemeni',NULL),(146,'زامبي','Zambian',NULL),(147,'زيمبابوي','Zimbabwean',NULL);
/*!40000 ALTER TABLE `nationalities` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `notification`
--

DROP TABLE IF EXISTS `notification`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `notification` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `zone_id` int DEFAULT NULL,
  `module_id` int NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `recipient` enum('CUSTOMER','STORE','DELIVERY_MAN') COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `notification_module_id_fkey` (`module_id`),
  KEY `notification_zone_id_fkey` (`zone_id`),
  CONSTRAINT `notification_module_id_fkey` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `notification_zone_id_fkey` FOREIGN KEY (`zone_id`) REFERENCES `zone` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notification`
--

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

--
-- Table structure for table `notification_settings`
--

DROP TABLE IF EXISTS `notification_settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `notification_settings` (
  `id` int NOT NULL AUTO_INCREMENT,
  `event` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nameAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nameEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descriptionAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descriptionEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `notification` tinyint(1) NOT NULL DEFAULT '0',
  `sms` tinyint(1) NOT NULL DEFAULT '0',
  `mail` tinyint(1) NOT NULL DEFAULT '0',
  `recipient` enum('CUSTOMER','STORE','ADMIN','DELIVERY_MAN') COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `notification_settings_event_key` (`event`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `notification_settings`
--

LOCK TABLES `notification_settings` WRITE;
/*!40000 ALTER TABLE `notification_settings` DISABLE KEYS */;
INSERT INTO `notification_settings` VALUES (21,'WITHDRAW.ADMIN','Withdraw Request','طلب سحب','A new withdrawal request has been submitted, please review it.','لقد تم تقديم طلب سحب جديد، يُرجى مراجعته.',0,0,0,'ADMIN'),(22,'WITHDRAW.DELIVERY.APPROVE','تمت الموافقه علي السحب','Withdraw Approved','تمت الموافقة على طلب السحب الخاص بك، وسيتم تحويل المبلغ قريبًا.','Your withdrawal request has been approved, the amount will be transferred soon.',0,0,0,'DELIVERY_MAN'),(23,'WITHDRAW.DELIVERY.DENY','تم رفض السحب','Withdraw Denied','تم رفض طلب سحب الخاص بك، يُرجى التواصل للحصول على تفاصيل.','Your withdrawal request has been denied, please contact support for details.',0,0,0,'DELIVERY_MAN'),(24,'ORDER.UPDATE','تم تحديث حالة الطلب','Order Status Updated','تم تحديث حالة طلبك، تحقق من التفاصيل الآن.','Your order status has been updated, check the details now.',0,0,0,'CUSTOMER'),(25,'ORDER.DELIVERY.ASSIGN','تم تعيين طلب لك','Order Assigned','تم تعيين طلب لك، تابع تقدم التوصيل.','An order has been assigned to a delivery agent, track the progress.',0,0,0,'DELIVERY_MAN'),(26,'REGISTER.DELIVERY','تسجيل مندوب جديد','New Delivery Registration','تم تسجيل مندوب جديد بنجاح، يُرجى مراجعته.','A new delivery agent has registered, please review the details.',0,0,0,'ADMIN'),(27,'REGISTER.STORE','تسجيل متجر جديد','New Store Registration','تم تسجيل متجر جديد في المنصة، يُرجى مراجعته.','A new store has registered on the platform, please review it.',0,0,0,'ADMIN'),(28,'REGISTER.DELIVERY.APPROVE','تمت الموافقة على المندوب','Delivery Approved','تمت الموافقة على طلب تسجيل المندوب، يمكنه الآن بدء العمل','The delivery agent has been approved and can now start working.',0,0,0,'DELIVERY_MAN'),(29,'REGISTER.DELIVERY.DENY','تم رفض المندوب','Delivery Denied','تم رفض طلب تسجيل المندوب، يُرجى التواصل للحصول على التفاصيل.','The delivery agent registration has been denied, please contact support for details.',0,0,0,'DELIVERY_MAN');
/*!40000 ALTER TABLE `notification_settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `nutrition`
--

DROP TABLE IF EXISTS `nutrition`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `nutrition` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` datetime(3) 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 `nutrition`
--

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

--
-- Table structure for table `order`
--

DROP TABLE IF EXISTS `order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `order` (
  `id` int NOT NULL AUTO_INCREMENT,
  `price` double NOT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `date` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `coupon_id` text COLLATE utf8mb4_unicode_ci,
  `address_id` int DEFAULT NULL,
  `customer_id` int NOT NULL,
  `store_id` int DEFAULT NULL,
  `cancel_reason_id` int DEFAULT NULL,
  `shipping` double NOT NULL DEFAULT '0',
  `tax` double NOT NULL DEFAULT '0',
  `totalPrice` double NOT NULL DEFAULT '0',
  `discountAmount` double NOT NULL DEFAULT '0',
  `deliveryManId` int DEFAULT NULL,
  `carId` int DEFAULT NULL,
  `adminCommission` double NOT NULL DEFAULT '0',
  `deliveryCommission` double NOT NULL DEFAULT '0',
  `customerArrived` tinyint(1) NOT NULL DEFAULT '0',
  `paymentStatus` enum('PAID','UNPAID','FAILED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'UNPAID',
  `paymentMethod` enum('CASH','VISA','WALLET') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'CASH',
  `deliveryStatus` enum('HOME_DELIVERY','TAKE_AWAY','CAR_DELIVERY') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'HOME_DELIVERY',
  `delivery_source` enum('PLATFORM','STORE_FLEET') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PLATFORM',
  `status` enum('PAYMENT_FAILED','PENDING','CANCELLED','ACCEPTED','REJECTED','WAITING_DELIVERY_ACCEPTANCE','WAITING_DELIVERY','HANDED_OVER','ON_THE_WAY','DRIVER_ARRIVED','REFUND','MISSED','DELIVERED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING',
  `paid_with_wallet` int NOT NULL DEFAULT '0',
  `waiting_delivery_acceptance_at` datetime(3) DEFAULT NULL,
  `waiting_delivery_at` datetime(3) DEFAULT NULL,
  `delivered_at` datetime(3) DEFAULT NULL,
  `accepted_at` datetime(3) DEFAULT NULL,
  `canceled_at` datetime(3) DEFAULT NULL,
  `handed_over_at` datetime(3) DEFAULT NULL,
  `missed_at` datetime(3) DEFAULT NULL,
  `rejected_at` datetime(3) DEFAULT NULL,
  `refund_at` datetime(3) DEFAULT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `on_the_way_at` datetime(3) DEFAULT NULL,
  `driver_arrived_at` datetime(3) DEFAULT NULL,
  `finalPrice` double NOT NULL DEFAULT '0',
  `created_at` datetime(3) DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  KEY `order_store_id_fkey` (`store_id`),
  KEY `order_customer_id_fkey` (`customer_id`),
  KEY `order_address_id_fkey` (`address_id`),
  KEY `order_deliveryManId_fkey` (`deliveryManId`),
  KEY `order_carId_fkey` (`carId`),
  CONSTRAINT `order_address_id_fkey` FOREIGN KEY (`address_id`) REFERENCES `address` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `order_carId_fkey` FOREIGN KEY (`carId`) REFERENCES `cars` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `order_customer_id_fkey` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `order_deliveryManId_fkey` FOREIGN KEY (`deliveryManId`) REFERENCES `delivery` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `order_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=1508 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order`
--

LOCK TABLES `order` WRITE;
/*!40000 ALTER TABLE `order` DISABLE KEYS */;
INSERT INTO `order` VALUES (1500,25,NULL,'2026-09-24 11:45:47.601','',NULL,17,1,NULL,0,0,25,0,NULL,NULL,0.25,0,0,'UNPAID','CASH','TAKE_AWAY','PLATFORM','PENDING',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,25,'2026-09-24 11:45:47.601'),(1501,25,NULL,'2026-09-24 11:48:37.610','',NULL,18,1,NULL,0,0,25,0,NULL,NULL,0.25,0,0,'UNPAID','CASH','TAKE_AWAY','PLATFORM','PENDING',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,25,'2026-09-24 11:48:37.610'),(1502,25,NULL,'2026-09-24 11:50:55.648','',NULL,19,1,NULL,0,0,25,0,NULL,NULL,0.25,0,0,'UNPAID','CASH','TAKE_AWAY','PLATFORM','PENDING',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,25,'2026-09-24 11:50:55.648'),(1503,25,NULL,'2026-09-24 11:52:28.000','',NULL,19,1,NULL,0,0,25,0,NULL,NULL,0.25,0,0,'UNPAID','CASH','TAKE_AWAY','PLATFORM','PENDING',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,25,'2026-09-24 11:52:28.000'),(1504,25,NULL,'2026-09-24 11:54:19.691','',NULL,20,1,NULL,0,0,25,0,NULL,NULL,0.25,0,0,'UNPAID','CASH','TAKE_AWAY','PLATFORM','HANDED_OVER',0,NULL,NULL,NULL,NULL,NULL,'2026-09-24 11:54:38.337',NULL,NULL,NULL,NULL,NULL,NULL,25,'2026-09-24 11:54:19.691'),(1505,25,NULL,'2026-09-24 11:56:43.705','',NULL,24,1,NULL,0,0,25,0,NULL,NULL,0.25,0,0,'UNPAID','CASH','TAKE_AWAY','PLATFORM','HANDED_OVER',0,NULL,NULL,NULL,NULL,NULL,'2026-09-24 11:56:44.351',NULL,NULL,NULL,NULL,NULL,NULL,25,'2026-09-24 11:56:43.705'),(1506,25,NULL,'2026-09-24 12:09:10.639','',NULL,25,1,NULL,0,0,25,0,NULL,NULL,0.25,0,0,'PAID','CASH','TAKE_AWAY','PLATFORM','DELIVERED',0,NULL,NULL,'2026-09-24 12:09:11.587',NULL,NULL,'2026-09-24 12:09:11.494',NULL,NULL,NULL,NULL,NULL,NULL,25,'2026-09-24 12:09:10.639'),(1507,25,NULL,'2026-09-24 12:10:51.603','',NULL,29,1,NULL,0,0,25,0,NULL,NULL,0.25,0,0,'PAID','CASH','TAKE_AWAY','PLATFORM','DELIVERED',0,NULL,NULL,'2026-09-24 12:10:53.107',NULL,NULL,'2026-09-24 12:10:53.022',NULL,NULL,NULL,NULL,NULL,NULL,25,'2026-09-24 12:10:51.603');
/*!40000 ALTER TABLE `order` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `order_item`
--

DROP TABLE IF EXISTS `order_item`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `order_item` (
  `id` int NOT NULL AUTO_INCREMENT,
  `orderId` int NOT NULL,
  `productId` int NOT NULL,
  `quantity` int NOT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `price` int NOT NULL,
  `variations_id` text COLLATE utf8mb4_unicode_ci,
  `variations_option_id` text COLLATE utf8mb4_unicode_ci,
  `addons_id` text COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `order_item_orderId_fkey` (`orderId`),
  KEY `order_item_productId_fkey` (`productId`),
  CONSTRAINT `order_item_orderId_fkey` FOREIGN KEY (`orderId`) REFERENCES `order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `order_item_productId_fkey` FOREIGN KEY (`productId`) REFERENCES `product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `order_item`
--

LOCK TABLES `order_item` WRITE;
/*!40000 ALTER TABLE `order_item` DISABLE KEYS */;
INSERT INTO `order_item` VALUES (1,1500,1,1,NULL,25,NULL,NULL,NULL),(2,1501,1,1,NULL,25,NULL,NULL,NULL),(3,1502,1,1,NULL,25,NULL,NULL,NULL),(4,1503,1,1,NULL,25,NULL,NULL,NULL),(5,1504,1,1,NULL,25,NULL,NULL,NULL),(6,1505,1,1,NULL,25,NULL,NULL,NULL),(7,1506,1,1,NULL,25,NULL,NULL,NULL),(8,1507,1,1,NULL,25,NULL,NULL,NULL);
/*!40000 ALTER TABLE `order_item` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `other_banner`
--

DROP TABLE IF EXISTS `other_banner`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `other_banner` (
  `id` int NOT NULL AUTO_INCREMENT,
  `image` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `module_id` int NOT NULL,
  `type` enum('BEST','NEW','BOTTOM','TOP') COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `other_banner_module_id_fkey` (`module_id`),
  CONSTRAINT `other_banner_module_id_fkey` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `other_banner`
--

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

--
-- Table structure for table `otps`
--

DROP TABLE IF EXISTS `otps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `otps` (
  `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `userId` int NOT NULL,
  `otp` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('ACTIVE','DENIED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVE',
  `role` enum('CUSTOMER','ADMIN','VENDOR','DELIVERY','MANAGER','DRIVER_COMPANY') COLLATE utf8mb4_unicode_ci NOT NULL,
  `generatedTimes` int NOT NULL DEFAULT '0',
  `createdAt` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `otps_userId_role_key` (`userId`,`role`),
  CONSTRAINT `otps_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `otps`
--

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

--
-- Table structure for table `parcel_order`
--

DROP TABLE IF EXISTS `parcel_order`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `parcel_order` (
  `id` int NOT NULL AUTO_INCREMENT,
  `senderPoint` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `receiverPoint` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `details` text COLLATE utf8mb4_unicode_ci,
  `place` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` int DEFAULT '0',
  `price` int DEFAULT '0',
  `orderId` int NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `parcel_order_orderId_key` (`orderId`),
  CONSTRAINT `parcel_order_orderId_fkey` FOREIGN KEY (`orderId`) REFERENCES `order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `parcel_order`
--

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

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

DROP TABLE IF EXISTS `permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `permissions` (
  `nameEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nameAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('ADMIN','STORE','GLOBAL','VENDOR') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ADMIN',
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`nameEn`),
  UNIQUE KEY `permissions_nameEn_key` (`nameEn`),
  UNIQUE KEY `permissions_nameAr_key` (`nameAr`),
  KEY `permissions_nameEn_idx` (`nameEn`)
) ENGINE=InnoDB 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 ('Advertisement','الإعلانات','VENDOR',NULL),('Branches','الفروع','VENDOR',NULL),('Business','الأعمال','GLOBAL',NULL),('Customer','العملاء','ADMIN',NULL),('Dashboard','لوحة التحكم','STORE',NULL),('Deliveryman','مندوبي التوصيل','ADMIN',NULL),('Dispatch','الإرسال','ADMIN',NULL),('Employee','الموظفين','GLOBAL',NULL),('Expense Report','التقارير','GLOBAL',NULL),('Marketing','التسويق','VENDOR',NULL),('Modules','الوحدات','ADMIN',NULL),('Order','الطلبات','GLOBAL',NULL),('Plan','الاشتراكات','GLOBAL',NULL),('Product','المنتجات','VENDOR',NULL),('Promotion','العروض','ADMIN',NULL),('Review','التقييمات','ADMIN',NULL),('Schedule','الجدوله','VENDOR',NULL),('Store','المتاجر','VENDOR',NULL),('System','النظام','ADMIN',NULL),('Withdraw','السخب','VENDOR',NULL);
/*!40000 ALTER TABLE `permissions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `plan`
--

DROP TABLE IF EXISTS `plan`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `plan` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `info_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `info_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` int NOT NULL DEFAULT '0',
  `days` int NOT NULL DEFAULT '0',
  `chat` tinyint(1) NOT NULL DEFAULT '0',
  `review` tinyint(1) NOT NULL DEFAULT '0',
  `mobile` tinyint(1) NOT NULL DEFAULT '0',
  `pos` tinyint(1) NOT NULL DEFAULT '0',
  `orders_limited` tinyint(1) NOT NULL DEFAULT '0',
  `items_limited` tinyint(1) NOT NULL DEFAULT '0',
  `is_active` tinyint(1) NOT NULL DEFAULT '0',
  `orders` int NOT NULL DEFAULT '0',
  `items` int NOT NULL DEFAULT '0',
  `default` tinyint(1) NOT NULL DEFAULT '0',
  `deleted_at` datetime(3) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  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 `plan`
--

LOCK TABLES `plan` WRITE;
/*!40000 ALTER TABLE `plan` DISABLE KEYS */;
INSERT INTO `plan` VALUES (1,'تجريبي','Test Plan','خطة تجريبية','Test plan',0,365,0,0,0,0,0,0,1,0,0,1,NULL,'2026-09-24 09:56:14.211');
/*!40000 ALTER TABLE `plan` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product`
--

DROP TABLE IF EXISTS `product`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `product` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `thumbnail` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `store_id` int NOT NULL,
  `category_id` int NOT NULL,
  `sub_category_id` int DEFAULT NULL,
  `unit_id` int DEFAULT NULL,
  `max_purchase` int NOT NULL DEFAULT '0',
  `price` double NOT NULL,
  `totalPrice` double NOT NULL,
  `stock` int DEFAULT NULL,
  `grossSale` int NOT NULL DEFAULT '0',
  `discountGrossSale` int NOT NULL DEFAULT '0',
  `totalOrders` int NOT NULL DEFAULT '0',
  `total_amount_sold` int NOT NULL DEFAULT '0',
  `total_discount_given` int NOT NULL DEFAULT '0',
  `calories` double DEFAULT NULL,
  `allergens` text COLLATE utf8mb4_unicode_ci,
  `discount` decimal(65,30) DEFAULT NULL,
  `color` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `size` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_organic` tinyint(1) DEFAULT '1',
  `is_basic_medicine` tinyint(1) DEFAULT '1',
  `is_prescription` tinyint(1) DEFAULT '1',
  `is_offer` tinyint(1) DEFAULT '0',
  `is_recommended` tinyint(1) DEFAULT '0',
  `module_id` int NOT NULL,
  `condition_id` int DEFAULT NULL,
  `brand_id` int DEFAULT NULL,
  `rating` double NOT NULL DEFAULT '0',
  `review` int NOT NULL DEFAULT '0',
  `addonsId` text COLLATE utf8mb4_unicode_ci,
  `bestRated` tinyint(1) DEFAULT '0',
  `mostSellers` tinyint(1) DEFAULT '0',
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `status` enum('PENDING','ACTIVE','INACTIVE','REJECTED') COLLATE utf8mb4_unicode_ci DEFAULT 'PENDING',
  `discountType` enum('PERCENTAGE','AMOUNT','NONE') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'NONE',
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_condition_id_fkey` (`condition_id`),
  KEY `product_brand_id_fkey` (`brand_id`),
  KEY `product_store_id_fkey` (`store_id`),
  KEY `product_category_id_fkey` (`category_id`),
  KEY `product_sub_category_id_fkey` (`sub_category_id`),
  KEY `product_unit_id_fkey` (`unit_id`),
  KEY `product_module_id_fkey` (`module_id`),
  CONSTRAINT `product_brand_id_fkey` FOREIGN KEY (`brand_id`) REFERENCES `brand` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `product_category_id_fkey` FOREIGN KEY (`category_id`) REFERENCES `category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `product_condition_id_fkey` FOREIGN KEY (`condition_id`) REFERENCES `condition` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `product_module_id_fkey` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `product_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `product_sub_category_id_fkey` FOREIGN KEY (`sub_category_id`) REFERENCES `category` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `product_unit_id_fkey` FOREIGN KEY (`unit_id`) REFERENCES `unit` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product`
--

LOCK TABLES `product` WRITE;
/*!40000 ALTER TABLE `product` DISABLE KEYS */;
INSERT INTO `product` VALUES (1,'???? ??????','QA Product','???','desc','uploads/default.png',1,1,NULL,NULL,10,25,25,92,200,0,8,200,0,NULL,NULL,NULL,NULL,NULL,NULL,1,1,1,0,0,1,NULL,NULL,0,0,NULL,0,1,'2026-09-24 11:41:55.337','ACTIVE','NONE',NULL);
/*!40000 ALTER TABLE `product` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `product_gallery`
--

DROP TABLE IF EXISTS `product_gallery`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_gallery` (
  `product_id` int NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`product_id`,`image`),
  CONSTRAINT `product_gallery_product_id_fkey` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_gallery`
--

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

--
-- Table structure for table `product_ingredients`
--

DROP TABLE IF EXISTS `product_ingredients`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_ingredients` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ingredient_id` int NOT NULL,
  `product_id` int NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_ingredients_ingredient_id_fkey` (`ingredient_id`),
  KEY `product_ingredients_product_id_fkey` (`product_id`),
  CONSTRAINT `product_ingredients_ingredient_id_fkey` FOREIGN KEY (`ingredient_id`) REFERENCES `ingredients` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `product_ingredients_product_id_fkey` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_ingredients`
--

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

--
-- Table structure for table `product_nutrition`
--

DROP TABLE IF EXISTS `product_nutrition`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `product_nutrition` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nutrition_id` int NOT NULL,
  `product_id` int NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_nutrition_nutrition_id_fkey` (`nutrition_id`),
  KEY `product_nutrition_product_id_fkey` (`product_id`),
  CONSTRAINT `product_nutrition_nutrition_id_fkey` FOREIGN KEY (`nutrition_id`) REFERENCES `nutrition` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `product_nutrition_product_id_fkey` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `product_nutrition`
--

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

--
-- Table structure for table `reason`
--

DROP TABLE IF EXISTS `reason`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `reason` (
  `id` int NOT NULL AUTO_INCREMENT,
  `reason_ar` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `reason_en` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `role` enum('CUSTOMER','ADMIN','VENDOR','DELIVERY','MANAGER','DRIVER_COMPANY') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ADMIN',
  `type` enum('REFUND','CANCEL') COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reason`
--

LOCK TABLES `reason` WRITE;
/*!40000 ALTER TABLE `reason` DISABLE KEYS */;
INSERT INTO `reason` VALUES (1,'طلبت بالخطأ','Ordered by mistake',1,'CUSTOMER','CANCEL'),(2,'وقت التوصيل طويل','Delivery time is too long',1,'CUSTOMER','CANCEL'),(3,'غيرت رأيي','Changed my mind',1,'CUSTOMER','CANCEL'),(4,'المنتج غير متوفر','Product out of stock',1,'VENDOR','CANCEL'),(5,'المتجر مغلق','Store is closed',1,'VENDOR','CANCEL'),(6,'عنوان العميل غير واضح','Customer address is unclear',1,'VENDOR','CANCEL'),(7,'تعذر الوصول للعميل','Could not reach the customer',1,'DELIVERY','CANCEL'),(8,'مشكلة في المركبة','Vehicle issue',1,'DELIVERY','CANCEL'),(9,'طلب مشبوه / احتيال','Suspicious / fraudulent order',1,'ADMIN','CANCEL'),(10,'إلغاء إداري','Cancelled by admin',1,'ADMIN','CANCEL'),(11,'المنتج تالف أو ناقص','Damaged or missing item',1,'CUSTOMER','REFUND'),(12,'طلب خاطئ وصلني','Wrong order received',1,'CUSTOMER','REFUND'),(13,'جودة سيئة','Poor quality',1,'CUSTOMER','REFUND'),(14,'استرجاع بعد مراجعة الدعم','Refund after support review',1,'ADMIN','REFUND'),(15,'مشكلة في الدفع','Payment issue',1,'ADMIN','REFUND');
/*!40000 ALTER TABLE `reason` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `reel`
--

DROP TABLE IF EXISTS `reel`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `reel` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nameAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nameEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `module_id` int NOT NULL,
  `store_id` int NOT NULL,
  `video` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_date` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `end_date` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` datetime(3) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  KEY `reel_module_id_fkey` (`module_id`),
  KEY `reel_store_id_fkey` (`store_id`),
  CONSTRAINT `reel_module_id_fkey` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `reel_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reel`
--

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

--
-- Table structure for table `referral`
--

DROP TABLE IF EXISTS `referral`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `referral` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `start_date` datetime(3) NOT NULL,
  `end_date` datetime(3) NOT NULL,
  `nameAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nameEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `referral_code_key` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `referral`
--

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

--
-- Table structure for table `referral_history`
--

DROP TABLE IF EXISTS `referral_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `referral_history` (
  `referral_id` int NOT NULL,
  `store_id` int NOT NULL,
  PRIMARY KEY (`referral_id`,`store_id`),
  UNIQUE KEY `referral_history_referral_id_store_id_key` (`referral_id`,`store_id`),
  KEY `referral_history_referral_id_store_id_idx` (`referral_id`,`store_id`),
  KEY `referral_history_store_id_fkey` (`store_id`),
  CONSTRAINT `referral_history_referral_id_fkey` FOREIGN KEY (`referral_id`) REFERENCES `referral` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  CONSTRAINT `referral_history_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `referral_history`
--

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

--
-- Table structure for table `register_otps`
--

DROP TABLE IF EXISTS `register_otps`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `register_otps` (
  `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `otp` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('ACTIVE','DENIED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVE',
  `role` enum('CUSTOMER','ADMIN','VENDOR','DELIVERY','MANAGER','DRIVER_COMPANY') COLLATE utf8mb4_unicode_ci NOT NULL,
  `generatedTimes` int NOT NULL DEFAULT '0',
  `createdAt` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  PRIMARY KEY (`id`),
  UNIQUE KEY `register_otps_phone_role_key` (`phone`,`role`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `register_otps`
--

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

--
-- Table structure for table `review`
--

DROP TABLE IF EXISTS `review`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `review` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rating` int NOT NULL,
  `rating_quality` int DEFAULT NULL,
  `rating_commitment` int DEFAULT NULL,
  `rating_communication` int DEFAULT NULL,
  `comment` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int NOT NULL,
  `order_id` int DEFAULT NULL,
  `delivery_id` int DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `review_user_id_fkey` (`user_id`),
  KEY `review_delivery_id_fkey` (`delivery_id`),
  KEY `review_order_id_fkey` (`order_id`),
  CONSTRAINT `review_delivery_id_fkey` FOREIGN KEY (`delivery_id`) REFERENCES `delivery` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `review_order_id_fkey` FOREIGN KEY (`order_id`) REFERENCES `order` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `review_user_id_fkey` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `review`
--

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

--
-- Table structure for table `rewards`
--

DROP TABLE IF EXISTS `rewards`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rewards` (
  `id` int NOT NULL AUTO_INCREMENT,
  `code` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `nameAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nameEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_after` double NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `money` double NOT 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 `rewards`
--

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

--
-- Table structure for table `rewards_history`
--

DROP TABLE IF EXISTS `rewards_history`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `rewards_history` (
  `reward_id` int NOT NULL,
  `user_id` int NOT NULL,
  `used` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`reward_id`,`user_id`),
  UNIQUE KEY `rewards_history_reward_id_user_id_key` (`reward_id`,`user_id`),
  KEY `rewards_history_reward_id_user_id_idx` (`reward_id`,`user_id`),
  KEY `rewards_history_user_id_fkey` (`user_id`),
  CONSTRAINT `rewards_history_reward_id_fkey` FOREIGN KEY (`reward_id`) REFERENCES `rewards` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  CONSTRAINT `rewards_history_user_id_fkey` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `rewards_history`
--

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

--
-- Table structure for table `role_permissions`
--

DROP TABLE IF EXISTS `role_permissions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `role_permissions` (
  `role` int NOT NULL,
  `permission` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`role`,`permission`),
  KEY `role_permissions_role_permission_idx` (`role`,`permission`),
  KEY `role_permissions_permission_fkey` (`permission`),
  CONSTRAINT `role_permissions_permission_fkey` FOREIGN KEY (`permission`) REFERENCES `permissions` (`nameEn`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `role_permissions_role_fkey` FOREIGN KEY (`role`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `role_permissions`
--

LOCK TABLES `role_permissions` WRITE;
/*!40000 ALTER TABLE `role_permissions` DISABLE KEYS */;
INSERT INTO `role_permissions` VALUES (1,'Business',NULL),(1,'Customer',NULL),(1,'Deliveryman',NULL),(1,'Dispatch',NULL),(1,'Employee',NULL),(1,'Expense Report',NULL),(1,'Modules',NULL),(1,'Order',NULL),(1,'Product',NULL),(1,'Promotion',NULL),(1,'Review',NULL),(1,'Schedule',NULL),(1,'Store',NULL),(1,'System',NULL),(3,'Advertisement',NULL),(3,'Branches',NULL),(3,'Business',NULL),(3,'Dashboard',NULL),(3,'Employee',NULL),(3,'Expense Report',NULL),(3,'Marketing',NULL),(3,'Order',NULL),(3,'Plan',NULL),(3,'Product',NULL),(3,'Schedule',NULL),(3,'Store',NULL),(3,'Withdraw',NULL),(5,'Business',NULL),(5,'Dashboard',NULL),(5,'Employee',NULL),(5,'Expense Report',NULL),(5,'Order',NULL);
/*!40000 ALTER TABLE `role_permissions` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `roles` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nameEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nameAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `createdAt` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `storeId` int DEFAULT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `type` enum('STORE','SYSTEM','ADMIN') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'SYSTEM',
  PRIMARY KEY (`id`),
  KEY `roles_storeId_fkey` (`storeId`),
  CONSTRAINT `roles_storeId_fkey` FOREIGN KEY (`storeId`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 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','Admin','2025-01-27 17:20:52.295',NULL,NULL,'SYSTEM'),(2,'Customer','Customer','2025-01-27 17:20:52.295',NULL,NULL,'SYSTEM'),(3,'Vendor','Vendor','2025-01-27 17:20:52.295',NULL,NULL,'SYSTEM'),(4,'DELIVERY','Delivery','2025-01-27 17:20:52.295',NULL,NULL,'SYSTEM'),(5,'Manager','Manager','2025-01-27 17:20:52.295',NULL,NULL,'SYSTEM'),(6,'DriverCompany','شركة سائقين','2025-01-27 17:20:52.295',NULL,NULL,'SYSTEM');
/*!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 */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `sessions` (
  `jti` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int NOT NULL,
  `device` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'unknown',
  `valid` tinyint(1) NOT NULL DEFAULT '1',
  `role` int NOT NULL,
  `fcm_token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `socket_id` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `outdated` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `baseRole` enum('CUSTOMER','ADMIN','VENDOR','DELIVERY','MANAGER','DRIVER_COMPANY') COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('ACCESS','FORGET_PASSWORD','VISITOR') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACCESS',
  PRIMARY KEY (`jti`),
  KEY `sessions_user_id_idx` (`user_id`),
  KEY `sessions_role_fkey` (`role`),
  CONSTRAINT `sessions_role_fkey` FOREIGN KEY (`role`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `sessions_user_id_fkey` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) 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 */;
INSERT INTO `sessions` VALUES ('05281958-c6ca-42f1-84e6-84abeef8b9cf',2,'unknown',1,3,NULL,NULL,0,'2026-09-24 12:10:52.945','VENDOR','ACCESS'),('2d61617b-c25d-4a4a-afc4-69ef9726f309',9,'unknown',1,6,NULL,NULL,0,'2026-09-24 11:25:17.819','DRIVER_COMPANY','ACCESS'),('33ada992-51ce-48bb-8843-20e9168e0eb6',16,'unknown',1,2,NULL,NULL,0,'2026-09-24 11:43:48.145','CUSTOMER','ACCESS'),('3763fffb-f711-4fed-a62b-4d5df81fc255',19,'unknown',1,2,NULL,NULL,0,'2026-09-24 11:52:44.205','CUSTOMER','ACCESS'),('4646a143-8d36-4780-b35c-06eeec3af596',25,'unknown',1,2,NULL,NULL,0,'2026-09-24 12:09:10.289','CUSTOMER','ACCESS'),('57e69b92-bd24-465f-aaa8-1f49a04582f0',29,'unknown',1,2,NULL,NULL,0,'2026-09-24 12:10:51.284','CUSTOMER','ACCESS'),('634687b3-db1f-43f0-96fb-4a681b96125a',21,'unknown',1,6,NULL,NULL,0,'2026-09-24 11:55:54.558','DRIVER_COMPANY','ACCESS'),('7b3dbd5d-9370-42b9-a5a2-dda743e88b5b',17,'unknown',1,2,NULL,NULL,0,'2026-09-24 11:45:47.358','CUSTOMER','ACCESS'),('7b7e1143-e342-4192-8343-76bff5565ead',13,'unknown',1,6,NULL,NULL,0,'2026-09-24 11:42:51.556','DRIVER_COMPANY','ACCESS'),('938b956a-6df3-4ab6-8789-14c1a9a56a5e',1,'unknown',1,1,NULL,NULL,0,'2026-09-24 12:16:43.056','ADMIN','ACCESS'),('add296a1-aca8-40b6-a24b-dfc0adb7dd35',26,'unknown',1,6,NULL,NULL,0,'2026-09-24 12:09:54.475','DRIVER_COMPANY','ACCESS'),('b413b42d-47da-4352-83be-09740b609ad9',24,'unknown',1,2,NULL,NULL,0,'2026-09-24 11:56:43.552','CUSTOMER','ACCESS'),('cc6a4fe2-69a1-4b1e-95ea-9b4edb2f2e45',20,'unknown',1,2,NULL,NULL,0,'2026-09-24 11:54:19.499','CUSTOMER','ACCESS'),('da71ed77-083f-4a64-b9b7-cbb7da2bf58f',18,'unknown',1,2,NULL,NULL,0,'2026-09-24 11:48:37.303','CUSTOMER','ACCESS'),('e0c4734f-6e49-4ea8-9ed8-d6fdb73054ba',11,'unknown',1,6,NULL,NULL,0,'2026-09-24 11:30:11.840','DRIVER_COMPANY','ACCESS');
/*!40000 ALTER TABLE `sessions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `settings` (
  `setting` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tooltip_ar` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tooltip_en` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `value` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `domain` enum('BUSINESS','DELIVERY','ORDER','REFUND','STORE','CUSTOMER','PRIORITY','DISBURSEMENT') COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `enum_values` json DEFAULT NULL,
  `data_type` enum('STRING','NUMBER','BOOLEAN','DATE','DATETIME','TIME','LATITUDE','LONGITUDE','JSON','FILE','ENUM') COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`setting`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `settings`
--

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES ('businessDeliveryCommissionRate',NULL,NULL,NULL,NULL,'6','BUSINESS',NULL,'null','NUMBER'),('businessFreeDeliveryOver',NULL,NULL,NULL,NULL,'10','BUSINESS',NULL,'null','NUMBER'),('businessOrderCommissionRate',NULL,NULL,NULL,NULL,'1','BUSINESS',NULL,'null','NUMBER'),('commissionIncluded',NULL,NULL,NULL,NULL,'false','BUSINESS',NULL,'null','BOOLEAN'),('customer1PoundPoints',NULL,NULL,NULL,NULL,'12','CUSTOMER',NULL,'null','NUMBER'),('customerLoyaltyPoints',NULL,NULL,NULL,NULL,'true','CUSTOMER',NULL,'null','BOOLEAN'),('customerMinPointsConvert',NULL,NULL,NULL,NULL,'2','CUSTOMER',NULL,'null','NUMBER'),('customerOrderPoints',NULL,NULL,NULL,NULL,'2134','CUSTOMER',NULL,'null','NUMBER'),('DeliveryMaximumCommission',NULL,NULL,NULL,NULL,'5','BUSINESS',NULL,'null','NUMBER'),('DeliveryMinimumCommission',NULL,NULL,NULL,NULL,'5','BUSINESS',NULL,'null','NUMBER'),('deliverySelfRegister',NULL,NULL,NULL,NULL,'false','DELIVERY',NULL,'null','BOOLEAN'),('generalCopyRightText',NULL,NULL,NULL,NULL,'1يسششيسشيس','BUSINESS',NULL,'null','STRING'),('orderCarDelivery',NULL,NULL,NULL,NULL,'true','ORDER',NULL,'null','BOOLEAN'),('orderHomeDelivery',NULL,NULL,NULL,NULL,'true','ORDER',NULL,'null','BOOLEAN'),('orderTakeaway',NULL,NULL,NULL,NULL,'true','ORDER',NULL,'null','BOOLEAN'),('shippingKMCharge',NULL,NULL,NULL,NULL,'3','BUSINESS',NULL,'null','NUMBER'),('storeCanCancelOrder',NULL,NULL,NULL,NULL,'true','STORE',NULL,'null','BOOLEAN'),('StoreConfirmOrder',NULL,NULL,NULL,NULL,'true','BUSINESS',NULL,'null','BOOLEAN'),('storeNearestByKM',NULL,NULL,NULL,NULL,'5000000000','STORE',NULL,'null','NUMBER'),('storeNeedApprovalForProducts',NULL,NULL,NULL,NULL,'false','STORE',NULL,'null','BOOLEAN'),('verifyHomeDeliveryToCustomer',NULL,NULL,NULL,NULL,'2','CUSTOMER',NULL,'null','NUMBER');
/*!40000 ALTER TABLE `settings` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `social_media`
--

DROP TABLE IF EXISTS `social_media`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `social_media` (
  `platform` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`platform`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `social_media`
--

LOCK TABLES `social_media` WRITE;
/*!40000 ALTER TABLE `social_media` DISABLE KEYS */;
INSERT INTO `social_media` VALUES ('facebook','https://facebook.com/deliverus',NULL,1,NULL),('instagram','https://instagram.com/deliverus',NULL,1,NULL),('linkedin','https://linkedin.com/company/deliverus',NULL,0,NULL),('tiktok','https://tiktok.com/@deliverus',NULL,0,NULL),('twitter','https://x.com/deliverus',NULL,1,NULL),('youtube','https://youtube.com/@deliverus',NULL,0,NULL);
/*!40000 ALTER TABLE `social_media` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `store`
--

DROP TABLE IF EXISTS `store`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `store` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nameAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nameEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cover` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `tax` int NOT NULL DEFAULT '0',
  `module_id` int NOT NULL,
  `prefix_price` double NOT NULL DEFAULT '0',
  `zone_id` int DEFAULT NULL,
  `lat` decimal(65,30) DEFAULT NULL,
  `lng` decimal(65,30) DEFAULT NULL,
  `main_store_id` int DEFAULT NULL,
  `default` tinyint(1) NOT NULL DEFAULT '0',
  `verified` tinyint(1) NOT NULL DEFAULT '0',
  `max_delivery_time` int DEFAULT NULL,
  `min_delivery_time` int DEFAULT NULL,
  `delivery_time` int DEFAULT NULL,
  `is_recommended` tinyint(1) NOT NULL DEFAULT '0',
  `rating` double NOT NULL DEFAULT '0',
  `review` int NOT NULL DEFAULT '0',
  `closed` tinyint(1) NOT NULL DEFAULT '1',
  `type` enum('COMPANY','ORGANIZATION','FREELANCE') COLLATE utf8mb4_unicode_ci NOT NULL,
  `temporarily_closed` tinyint(1) NOT NULL DEFAULT '0',
  `home_delivery` tinyint(1) NOT NULL DEFAULT '1',
  `take_away` tinyint(1) NOT NULL DEFAULT '1',
  `car_delivery` tinyint(1) NOT NULL DEFAULT '1',
  `minimum_order_amount` int NOT NULL DEFAULT '0',
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `branchName` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `frozen` tinyint(1) NOT NULL DEFAULT '0',
  `pos` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('ACTIVE','PENDING','DENIED','EXPIRED') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING',
  `commercialRegistryOrSelfEmploymentDocument` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `commercialRegistryOrSelfEmploymentCertificate` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `website` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `personHandlingTheRegistration` enum('LEGAL_AGENNT','OWNER','ADMIN','EMPLOYEE') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'LEGAL_AGENNT',
  `numberOfMontesSubscribed` int NOT NULL DEFAULT '0',
  `subscriptionExpiredAt` datetime(3) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `deleted_at` datetime(3) DEFAULT NULL,
  `plan_id` int NOT NULL DEFAULT '1',
  `default_delivery_source` enum('PLATFORM','STORE_FLEET') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PLATFORM',
  `fleet_company_id` int DEFAULT NULL,
  `reservations_enabled` tinyint(1) NOT NULL DEFAULT '1',
  `reservation_cancel_hours` int NOT NULL DEFAULT '2',
  PRIMARY KEY (`id`),
  KEY `store_zone_id_idx` (`zone_id`),
  KEY `store_id_idx` (`id`),
  KEY `store_module_id_fkey` (`module_id`),
  KEY `store_plan_id_fkey` (`plan_id`),
  KEY `store_fleet_company_id_fkey` (`fleet_company_id`),
  KEY `store_main_store_id_fkey` (`main_store_id`),
  CONSTRAINT `store_fleet_company_id_fkey` FOREIGN KEY (`fleet_company_id`) REFERENCES `driver_companies` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `store_main_store_id_fkey` FOREIGN KEY (`main_store_id`) REFERENCES `store` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `store_module_id_fkey` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `store_plan_id_fkey` FOREIGN KEY (`plan_id`) REFERENCES `plan` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `store_zone_id_fkey` FOREIGN KEY (`zone_id`) REFERENCES `zone` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `store`
--

LOCK TABLES `store` WRITE;
/*!40000 ALTER TABLE `store` DISABLE KEYS */;
INSERT INTO `store` VALUES (1,'متجر تجريبي','Test Store','uploads/default.png','uploads/default.png','',0,1,0,1,NULL,NULL,NULL,0,1,NULL,NULL,NULL,0,0,0,0,'COMPANY',0,1,1,1,0,'+9660500000001',NULL,0,NULL,'ACTIVE',NULL,NULL,NULL,'LEGAL_AGENNT',0,NULL,'2026-09-24 09:56:14.227',NULL,1,'PLATFORM',NULL,1,2);
/*!40000 ALTER TABLE `store` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `store_banks`
--

DROP TABLE IF EXISTS `store_banks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `store_banks` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `iban` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ownerName` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `store_id` int NOT NULL,
  `bank_id` int NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `store_banks_store_id_fkey` (`store_id`),
  KEY `store_banks_bank_id_fkey` (`bank_id`),
  CONSTRAINT `store_banks_bank_id_fkey` FOREIGN KEY (`bank_id`) REFERENCES `banks` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `store_banks_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `store_banks`
--

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

--
-- Table structure for table `store_campaign`
--

DROP TABLE IF EXISTS `store_campaign`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `store_campaign` (
  `campaign_id` int NOT NULL,
  `store_id` int NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`campaign_id`,`store_id`),
  UNIQUE KEY `store_campaign_campaign_id_store_id_key` (`campaign_id`,`store_id`),
  KEY `store_campaign_store_id_fkey` (`store_id`),
  CONSTRAINT `store_campaign_campaign_id_fkey` FOREIGN KEY (`campaign_id`) REFERENCES `campaign` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `store_campaign_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `store_campaign`
--

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

--
-- Table structure for table `store_notification_setup`
--

DROP TABLE IF EXISTS `store_notification_setup`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `store_notification_setup` (
  `id` int NOT NULL AUTO_INCREMENT,
  `store_id` int NOT NULL,
  `pushEnabled` enum('DISABLED','ACTIVE','INACTIVE') COLLATE utf8mb4_unicode_ci NOT NULL,
  `emailEnabled` enum('DISABLED','ACTIVE','INACTIVE') COLLATE utf8mb4_unicode_ci NOT NULL,
  `smsEnabled` enum('DISABLED','ACTIVE','INACTIVE') COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `event` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `store_notification_setup_store_id_idx` (`store_id`),
  CONSTRAINT `store_notification_setup_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `store_notification_setup`
--

LOCK TABLES `store_notification_setup` WRITE;
/*!40000 ALTER TABLE `store_notification_setup` DISABLE KEYS */;
INSERT INTO `store_notification_setup` VALUES (13,1,'ACTIVE','ACTIVE','DISABLED','تمت الموافقة على السحب','Withdraw Approved','WITHDRAW.STORE.APPROVED','تمت الموافقة على طلب السحب الخاص بك، وسيتم تحويل المبلغ قريبًا.','Your withdrawal request has been approved, the amount will be transferred soon.'),(14,1,'ACTIVE','ACTIVE','DISABLED','تم رفض السحب','Withdraw Rejection','WITHDRAW.STORE.DENY','تم رفض طلب السحب، يُرجى التواصل مع الدعم للحصول على التفاصيل.','Your withdrawal request has been denied, please contact support for details.'),(15,1,'ACTIVE','DISABLED','DISABLED','طلب طلب','Order Request','ORDER.REQUEST','لديك طلب جديد بانتظار المعالجة، تحقق من التفاصيل الآن.','You have a new order request pending, check the details now.'),(16,1,'ACTIVE','DISABLED','DISABLED','تم تحديث حالة الطلب','Order Update','ORDER.UPDATE','تم تحديث حالة طلبك، تحقق من التفاصيل الآن.','Your order status has been updated, check the details now.'),(17,1,'ACTIVE','DISABLED','DISABLED','تم وصول العميل','Customer Arrive','CUSTOMER.ARRIVE','تم وصول العميل لاستلام طلبه الان.','Customer Arrived to recieve his order now.'),(18,1,'ACTIVE','DISABLED','DISABLED','تم الفاء الطلب','Order Canceled successfully','ORDER.CANCEL','تم إلغاء الطلب، يُرجى مراجعة التفاصيل لمعرفة السبب.','The order has been canceled, please review the details.'),(19,1,'ACTIVE','ACTIVE','DISABLED','تمت الموافقة على المنتج','Product Approve','PRODUCT.APPROVE','تمت الموافقة على منتجك، وهو متاح الآن في المتجر.','Your product has been approved and is now available in the store.'),(20,1,'ACTIVE','ACTIVE','DISABLED','تم رفض المنتج','Product Reject','PRODUCT.DENY','تم رفض منتجك، يُرجى مراجعة التفاصيل لمعرفة السبب.','Your product has been rejected, please review the details for clarification.'),(21,1,'ACTIVE','ACTIVE','DISABLED','تم الاشتراك بنجاح','Subscription Success','SUBSCRIPTION.SUCCESS','مبروك تم تفعيل اشتراكك بنجاح.','Congratulations! Your subscription has been activated successfully.'),(22,1,'ACTIVE','ACTIVE','DISABLED','تم تجديد الاشتراك','Subscription Renew','SUBSCRIPTION.RENEW','تم تجديد اشتراكك بنجاح، استمتع بخدماتنا المستمرة.','Your subscription has been renewed successfully, enjoy our services.'),(23,1,'ACTIVE','ACTIVE','DISABLED','تمت الموافقة على المتجر','Store Approved','REGISTER.STORE.APPROVE','تمت الموافقة على المتجر، ويمكنه الآن استقبال الطلبات.','The store has been approved and can now receive orders.'),(24,1,'ACTIVE','ACTIVE','DISABLED','تم رفض المتجر','Store Deny','REGISTER.STORE.DENY','تم رفض طلب تسجيل المتجر، يُرجى التواصل مع الدعم للحصول على التفاصيل.','The registration has been denied, please contact support for details.');
/*!40000 ALTER TABLE `store_notification_setup` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `store_schedule`
--

DROP TABLE IF EXISTS `store_schedule`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `store_schedule` (
  `id` int NOT NULL AUTO_INCREMENT,
  `store_id` int NOT NULL,
  `opening_time` time NOT NULL,
  `closing_time` time NOT NULL,
  `day` enum('SUNDAY','MONDAY','TUESDAY','WEDNESDAY','THURSDAY','FRIDAY','SATURDAY') COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `store_schedule_store_id_idx` (`store_id`),
  CONSTRAINT `store_schedule_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `store_schedule`
--

LOCK TABLES `store_schedule` WRITE;
/*!40000 ALTER TABLE `store_schedule` DISABLE KEYS */;
INSERT INTO `store_schedule` VALUES (1,1,'00:00:00','23:59:59','SUNDAY'),(2,1,'00:00:00','23:59:59','MONDAY'),(3,1,'00:00:00','23:59:59','TUESDAY'),(4,1,'00:00:00','23:59:59','WEDNESDAY'),(5,1,'00:00:00','23:59:59','THURSDAY'),(6,1,'00:00:00','23:59:59','FRIDAY'),(7,1,'00:00:00','23:59:59','SATURDAY');
/*!40000 ALTER TABLE `store_schedule` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subscriptions`
--

DROP TABLE IF EXISTS `subscriptions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `subscriptions` (
  `id` int NOT NULL AUTO_INCREMENT,
  `plan_id` int NOT NULL,
  `store_id` int NOT NULL,
  `renew` int NOT NULL DEFAULT '0',
  `start_date` datetime(3) NOT NULL,
  `expire_date` datetime(3) NOT NULL,
  `status` enum('ACTIVE','INACTIVE','EXPIRED','EXPIRE_SOON') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ACTIVE',
  `is_trial` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `subscriptions_plan_id_fkey` (`plan_id`),
  KEY `subscriptions_store_id_fkey` (`store_id`),
  CONSTRAINT `subscriptions_plan_id_fkey` FOREIGN KEY (`plan_id`) REFERENCES `plan` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  CONSTRAINT `subscriptions_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subscriptions`
--

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

--
-- Table structure for table `system_notification`
--

DROP TABLE IF EXISTS `system_notification`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `system_notification` (
  `id` int NOT NULL AUTO_INCREMENT,
  `role` enum('CUSTOMER','ADMIN','VENDOR','DELIVERY','MANAGER','DRIVER_COMPANY') COLLATE utf8mb4_unicode_ci NOT NULL,
  `read` tinyint(1) NOT NULL DEFAULT '0',
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `nameAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nameEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descriptionAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `descriptionEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int DEFAULT NULL,
  `store_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `system_notification_user_id_fkey` (`user_id`),
  KEY `system_notification_store_id_fkey` (`store_id`),
  CONSTRAINT `system_notification_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `system_notification_user_id_fkey` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `system_notification`
--

LOCK TABLES `system_notification` WRITE;
/*!40000 ALTER TABLE `system_notification` DISABLE KEYS */;
INSERT INTO `system_notification` VALUES (1,'VENDOR',0,'2026-09-24 11:48:37.856','ORDER.REQUEST','ORDER.REQUEST','','',NULL,NULL,1),(2,'VENDOR',0,'2026-09-24 11:50:55.833','ORDER.REQUEST','ORDER.REQUEST','','',NULL,NULL,1),(3,'VENDOR',0,'2026-09-24 11:52:28.159','ORDER.REQUEST','ORDER.REQUEST','','',NULL,NULL,1),(4,'VENDOR',0,'2026-09-24 11:54:19.880','ORDER.REQUEST','ORDER.REQUEST','','',NULL,NULL,1),(5,'VENDOR',0,'2026-09-24 11:54:38.405','ORDER.UPDATE','ORDER.UPDATE','','',NULL,NULL,1),(6,'VENDOR',0,'2026-09-24 11:56:43.753','ORDER.REQUEST','ORDER.REQUEST','','',NULL,NULL,1),(7,'VENDOR',0,'2026-09-24 11:56:44.371','ORDER.UPDATE','ORDER.UPDATE','','',NULL,NULL,1),(8,'VENDOR',0,'2026-09-24 12:09:10.731','ORDER.REQUEST','ORDER.REQUEST','','',NULL,NULL,1),(9,'VENDOR',0,'2026-09-24 12:09:11.517','ORDER.UPDATE','ORDER.UPDATE','','',NULL,NULL,1),(10,'VENDOR',0,'2026-09-24 12:09:11.639','ORDER.UPDATE','ORDER.UPDATE','','',NULL,NULL,1),(11,'VENDOR',0,'2026-09-24 12:10:51.841','ORDER.REQUEST','ORDER.REQUEST','','',NULL,NULL,1),(12,'VENDOR',0,'2026-09-24 12:10:53.051','ORDER.UPDATE','ORDER.UPDATE','','',NULL,NULL,1),(13,'VENDOR',0,'2026-09-24 12:10:53.198','ORDER.UPDATE','ORDER.UPDATE','','',NULL,NULL,1);
/*!40000 ALTER TABLE `system_notification` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `table_reservation`
--

DROP TABLE IF EXISTS `table_reservation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `table_reservation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `store_id` int NOT NULL,
  `customer_id` int DEFAULT NULL,
  `guest_name` varchar(120) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guest_phone` varchar(40) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guest_count` int NOT NULL,
  `reserved_at` datetime(3) NOT NULL,
  `notes` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('PENDING','CONFIRMED','CANCELLED','COMPLETED','NO_SHOW') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'PENDING',
  `fee_amount` double NOT NULL DEFAULT '0',
  `customer_fee_amount` double NOT NULL DEFAULT '0',
  `store_fee_amount` double NOT NULL DEFAULT '0',
  `fee_paid` tinyint(1) NOT NULL DEFAULT '0',
  `cancel_reason` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `cancelled_at` datetime(3) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `updated_at` datetime(3) NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `table_reservation_store_id_reserved_at_idx` (`store_id`,`reserved_at`),
  KEY `table_reservation_customer_id_idx` (`customer_id`),
  KEY `table_reservation_status_idx` (`status`),
  CONSTRAINT `table_reservation_customer_id_fkey` FOREIGN KEY (`customer_id`) REFERENCES `customer` (`id`) ON DELETE SET NULL ON UPDATE CASCADE,
  CONSTRAINT `table_reservation_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `table_reservation`
--

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

--
-- Table structure for table `tags`
--

DROP TABLE IF EXISTS `tags`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `tags` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_id` int NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tags_product_id_fkey` (`product_id`),
  CONSTRAINT `tags_product_id_fkey` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `tags`
--

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

--
-- Table structure for table `transactions`
--

DROP TABLE IF EXISTS `transactions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `transactions` (
  `id` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `customer_Id` int NOT NULL,
  `credit` decimal(65,30) NOT NULL DEFAULT '0.000000000000000000000000000000',
  `debit` decimal(65,30) NOT NULL DEFAULT '0.000000000000000000000000000000',
  `balance` decimal(65,30) NOT NULL DEFAULT '0.000000000000000000000000000000',
  `type` enum('ORDER_REFUND','PAYMENT','FUND','LOYALTY_POINT') COLLATE utf8mb4_unicode_ci NOT NULL,
  `reference` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'N/A',
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `transactions_customer_Id_fkey` (`customer_Id`),
  CONSTRAINT `transactions_customer_Id_fkey` FOREIGN KEY (`customer_Id`) REFERENCES `customer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `transactions`
--

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

--
-- Table structure for table `unit`
--

DROP TABLE IF EXISTS `unit`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `unit` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name_ar` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `name_en` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `module_id` int NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `unit_name_ar_key` (`name_ar`),
  UNIQUE KEY `unit_name_en_key` (`name_en`),
  KEY `unit_module_id_fkey` (`module_id`),
  CONSTRAINT `unit_module_id_fkey` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `unit`
--

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

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `first_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT 'uploads/default.png',
  `isOnline` tinyint(1) NOT NULL DEFAULT '0',
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'Admin','Admin','+9660509272514','admin@admin.com','uploads/default.png',0,NULL),(2,'Store','Owner','+9660500000001','store@store.com','uploads/default.png',0,NULL),(3,'Fleet Co 8286727',NULL,'+48 508286727','fleet8286727@test.com','uploads/default.png',0,NULL),(4,'Fleet API',NULL,'+48 501112223','fleetapi1@test.com','uploads/default.png',0,NULL),(5,'Fleet Co 8652730',NULL,'+48 501865273','fleet8652730@test.com','uploads/default.png',0,NULL),(6,'Fleet Co 8786542',NULL,'+48 501878654','fleet8786542@test.com','uploads/default.png',0,NULL),(7,'Fleet Co 8957555',NULL,'+48 501895755','fleet8957555@test.com','uploads/default.png',0,NULL),(8,'Fleet Co 8981859',NULL,'+48 501898185','fleet8981859@test.com','uploads/default.png',0,NULL),(9,'Fleet Co 9099930',NULL,'+48 501909993','fleet9099930@test.com','uploads/default.png',0,NULL),(10,'Ahmed','Driver','+48 502909993','driver9099930@test.com','uploads/default.png',0,NULL),(11,'Fleet Co 9379250',NULL,'+48 501937925','fleet9379250@test.com','uploads/default.png',0,NULL),(12,'Ahmed','Driver','+48 502937925','driver9379250@test.com','uploads/default.png',0,NULL),(13,'QA Accept 150487',NULL,'+48 511150487','qaA150487@test.com','uploads/default.png',0,NULL),(14,'Khaled','Fleet','+48 513150487','khaled150487@test.com','uploads/default.png',0,NULL),(15,'QA Deny 150487',NULL,'+48 512150487','qaB150487@test.com','uploads/default.png',0,NULL),(16,NULL,NULL,'+48 520150487',NULL,'uploads/default.png',0,NULL),(17,NULL,NULL,'+48 520999001',NULL,'uploads/default.png',0,NULL),(18,NULL,NULL,'+48 520999003',NULL,'uploads/default.png',0,NULL),(19,NULL,NULL,'+48 520999004',NULL,'uploads/default.png',0,NULL),(20,NULL,NULL,'+48 520999005',NULL,'uploads/default.png',0,NULL),(21,'QA Accept 934176',NULL,'+48 511934176','qaA934176@test.com','uploads/default.png',0,NULL),(22,'Khaled','Fleet','+48 513934176','khaled934176@test.com','uploads/default.png',0,NULL),(23,'QA Deny 934176',NULL,'+48 512934176','qaB934176@test.com','uploads/default.png',0,NULL),(24,NULL,NULL,'+48 520934176',NULL,'uploads/default.png',0,NULL),(25,NULL,NULL,'+48 520999006',NULL,'uploads/default.png',0,NULL),(26,'QA Accept 773429',NULL,'+48 511773429','qaA773429@test.com','uploads/default.png',0,NULL),(27,'Khaled','Fleet','+48 513773429','khaled773429@test.com','uploads/default.png',0,NULL),(28,'QA Deny 773429',NULL,'+48 512773429','qaB773429@test.com','uploads/default.png',0,NULL),(29,NULL,NULL,'+48 520773429',NULL,'uploads/default.png',0,NULL);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_conversation`
--

DROP TABLE IF EXISTS `user_conversation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_conversation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `userId` int NOT NULL,
  `conversationId` int NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `role` enum('CUSTOMER','ADMIN','VENDOR','DELIVERY','MANAGER','DRIVER_COMPANY') COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `user_conversation_conversationId_fkey` (`conversationId`),
  KEY `user_conversation_userId_fkey` (`userId`),
  CONSTRAINT `user_conversation_conversationId_fkey` FOREIGN KEY (`conversationId`) REFERENCES `conversation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `user_conversation_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_conversation`
--

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

--
-- Table structure for table `user_coupon`
--

DROP TABLE IF EXISTS `user_coupon`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `user_coupon` (
  `userId` int NOT NULL,
  `orderId` int NOT NULL,
  `couponId` int NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`userId`,`couponId`),
  KEY `user_coupon_userId_couponId_idx` (`userId`,`couponId`),
  KEY `user_coupon_couponId_fkey` (`couponId`),
  KEY `user_coupon_orderId_fkey` (`orderId`),
  CONSTRAINT `user_coupon_couponId_fkey` FOREIGN KEY (`couponId`) REFERENCES `coupon` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  CONSTRAINT `user_coupon_orderId_fkey` FOREIGN KEY (`orderId`) REFERENCES `order` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE,
  CONSTRAINT `user_coupon_userId_fkey` FOREIGN KEY (`userId`) REFERENCES `user` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_coupon`
--

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

--
-- Table structure for table `variation`
--

DROP TABLE IF EXISTS `variation`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `variation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `required` tinyint(1) NOT NULL DEFAULT '0',
  `minQuantity` int DEFAULT NULL,
  `maxQuantity` int DEFAULT NULL,
  `single` tinyint(1) NOT NULL DEFAULT '1',
  `product_id` int NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `variation_product_id_fkey` (`product_id`),
  CONSTRAINT `variation_product_id_fkey` FOREIGN KEY (`product_id`) REFERENCES `product` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `variation`
--

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

--
-- Table structure for table `variation_option`
--

DROP TABLE IF EXISTS `variation_option`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `variation_option` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` int NOT NULL,
  `default` tinyint(1) NOT NULL DEFAULT '0',
  `variation_id` int NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `variation_option_variation_id_fkey` (`variation_id`),
  CONSTRAINT `variation_option_variation_id_fkey` FOREIGN KEY (`variation_id`) REFERENCES `variation` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `variation_option`
--

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

--
-- Table structure for table `vehicle`
--

DROP TABLE IF EXISTS `vehicle`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `vehicle` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nameAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nameEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `extra_charges` int NOT NULL DEFAULT '0',
  `starting_coverage_area` int NOT NULL,
  `maximum_coverage_area` int NOT NULL,
  `is_active` tinyint(1) NOT NULL DEFAULT '1',
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vehicle`
--

LOCK TABLES `vehicle` WRITE;
/*!40000 ALTER TABLE `vehicle` DISABLE KEYS */;
INSERT INTO `vehicle` VALUES (1,'دراجة','Bike',0,0,5,1,NULL),(2,'دراجة نارية','Motorcycle',2,0,15,1,NULL),(3,'سيارة','Car',5,0,40,1,NULL),(4,'شاحنة صغيرة','Van',10,0,80,1,NULL);
/*!40000 ALTER TABLE `vehicle` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `vendor`
--

DROP TABLE IF EXISTS `vendor`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `vendor` (
  `id` int NOT NULL,
  `role` int DEFAULT NULL,
  `storeId` int NOT NULL,
  `deviceId` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `id_number` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fcm_token` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  `created_at` datetime(3) NOT NULL DEFAULT CURRENT_TIMESTAMP(3),
  `default` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  UNIQUE KEY `vendor_deviceId_key` (`deviceId`),
  KEY `vendor_role_idx` (`role`),
  KEY `vendor_storeId_fkey` (`storeId`),
  CONSTRAINT `vendor_id_fkey` FOREIGN KEY (`id`) REFERENCES `user` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `vendor_role_fkey` FOREIGN KEY (`role`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `vendor_storeId_fkey` FOREIGN KEY (`storeId`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `vendor`
--

LOCK TABLES `vendor` WRITE;
/*!40000 ALTER TABLE `vendor` DISABLE KEYS */;
INSERT INTO `vendor` VALUES (2,3,1,NULL,'$2b$13$OoBNKBLBM2fb65C5ussgmO1ZWNEaiDpSputKKsnO9gk7Bg/5fSXyW',NULL,NULL,NULL,'2026-09-24 09:56:14.262',1);
/*!40000 ALTER TABLE `vendor` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wallet`
--

DROP TABLE IF EXISTS `wallet`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `wallet` (
  `id` int NOT NULL AUTO_INCREMENT,
  `store_id` int DEFAULT NULL,
  `delivery_man_id` int DEFAULT NULL,
  `total_earning` decimal(24,2) NOT NULL DEFAULT '0.00',
  `total_withdrawn` decimal(24,2) NOT NULL DEFAULT '0.00',
  `pending_withdraw` decimal(24,2) NOT NULL DEFAULT '0.00',
  `collect_cash` decimal(24,2) NOT NULL DEFAULT '0.00',
  `current_balance` decimal(24,2) NOT NULL DEFAULT '0.00',
  PRIMARY KEY (`id`),
  UNIQUE KEY `wallet_store_id_key` (`store_id`),
  UNIQUE KEY `wallet_delivery_man_id_key` (`delivery_man_id`),
  CONSTRAINT `wallet_delivery_man_id_fkey` FOREIGN KEY (`delivery_man_id`) REFERENCES `delivery` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `wallet_store_id_fkey` FOREIGN KEY (`store_id`) REFERENCES `store` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wallet`
--

LOCK TABLES `wallet` WRITE;
/*!40000 ALTER TABLE `wallet` DISABLE KEYS */;
INSERT INTO `wallet` VALUES (1,1,NULL,49.50,0.00,0.00,50.00,-0.50);
/*!40000 ALTER TABLE `wallet` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zone`
--

DROP TABLE IF EXISTS `zone`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `zone` (
  `id` int NOT NULL AUTO_INCREMENT,
  `nameAr` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `nameEn` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
  `cash` tinyint(1) NOT NULL DEFAULT '1',
  `digital` tinyint(1) NOT NULL DEFAULT '0',
  `offline` tinyint(1) NOT NULL DEFAULT '0',
  `isActive` tinyint(1) NOT NULL DEFAULT '0',
  `createdBy` enum('ADMIN','VENDOR') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'ADMIN',
  `created_at` datetime(3) DEFAULT CURRENT_TIMESTAMP(3),
  `deleted_at` datetime(3) DEFAULT NULL,
  `cityId` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `zone_id_idx` (`id`),
  KEY `zone_cityId_fkey` (`cityId`),
  CONSTRAINT `zone_cityId_fkey` FOREIGN KEY (`cityId`) REFERENCES `cities` (`id`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `zone`
--

LOCK TABLES `zone` WRITE;
/*!40000 ALTER TABLE `zone` DISABLE KEYS */;
INSERT INTO `zone` VALUES (1,'وسط الرياض','Central Riyadh',1,1,0,1,'ADMIN','2026-09-24 10:24:51.156',NULL,1);
/*!40000 ALTER TABLE `zone` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zone_points`
--

DROP TABLE IF EXISTS `zone_points`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `zone_points` (
  `id` int NOT NULL AUTO_INCREMENT,
  `lat` decimal(65,30) NOT NULL,
  `lng` decimal(65,30) NOT NULL,
  `zone_id` int NOT NULL,
  `deleted_at` datetime(3) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `zone_points_zone_id_idx` (`zone_id`),
  CONSTRAINT `zone_points_zone_id_fkey` FOREIGN KEY (`zone_id`) REFERENCES `zone` (`id`) ON DELETE RESTRICT ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `zone_points`
--

LOCK TABLES `zone_points` WRITE;
/*!40000 ALTER TABLE `zone_points` DISABLE KEYS */;
INSERT INTO `zone_points` VALUES (1,24.750000000000000000000000000000,46.600000000000000000000000000000,1,NULL),(2,24.750000000000000000000000000000,46.800000000000000000000000000000,1,NULL),(3,24.650000000000000000000000000000,46.800000000000000000000000000000,1,NULL),(4,24.650000000000000000000000000000,46.600000000000000000000000000000,1,NULL);
/*!40000 ALTER TABLE `zone_points` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Dumping routines for database 'deliverus'
--
/*!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-24 12:45:01
