--
-- Host: localhost    Database: topappkw_book
-- ------------------------------------------------------


--
-- Current Database: `topappkw_book`
--


--
-- Table structure for table `arrival_prices`
--

CREATE TABLE `arrival_prices` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `region_id` int DEFAULT NULL,
  `price` double DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=134 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `arrival_prices`
--

INSERT INTO `arrival_prices` (`id`, `region_id`, `price`, `created_at`, `updated_at`) VALUES (1,1,0,'2022-12-06 13:53:46','2022-12-06 13:59:21'),(2,19,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(3,20,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(4,21,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(5,22,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(6,23,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(7,24,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(8,25,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(9,26,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(10,27,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(11,28,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(12,29,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(13,30,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(14,31,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(15,32,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(16,33,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(17,34,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(18,35,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(19,36,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(20,37,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(21,38,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(22,39,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(23,40,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(24,41,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(25,42,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(26,43,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(27,44,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(28,45,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(29,46,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(30,47,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(31,48,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(32,49,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(33,50,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(34,51,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(35,52,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(36,53,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(37,54,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(38,55,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(39,56,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(40,57,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(41,58,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(42,59,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(43,60,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(44,61,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(45,62,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(46,63,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(47,64,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(48,65,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(49,66,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(50,67,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(51,68,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(52,69,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(53,70,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(54,71,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(55,72,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(56,73,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(57,74,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(58,75,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(59,76,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(60,77,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(61,78,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(62,79,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(63,80,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(64,81,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(65,82,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(66,83,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(67,84,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(68,85,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(69,86,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(70,87,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(71,88,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(72,89,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(73,90,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(74,91,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(75,92,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(76,93,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(77,94,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(78,95,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(79,96,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(80,97,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(81,98,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(82,99,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(83,100,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(84,101,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(85,102,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(86,103,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(87,104,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(88,105,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(89,106,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(90,107,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(91,108,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(92,109,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(93,110,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(94,111,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(95,112,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(96,113,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(97,114,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(98,115,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(99,116,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(100,117,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(101,118,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(102,119,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(103,120,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(104,121,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(105,122,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(106,123,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(107,124,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(108,125,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(109,126,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(110,127,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(111,128,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(112,129,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(113,130,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(114,131,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(115,132,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(116,133,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(117,134,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(118,135,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(119,136,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(120,137,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(121,138,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(122,139,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(123,140,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(124,141,1,'2022-12-10 06:34:34','2022-12-10 06:34:34'),(125,142,1,'2022-12-10 06:34:35','2022-12-10 06:34:35'),(126,143,1,'2022-12-10 06:34:35','2022-12-10 06:34:35'),(127,144,1,'2022-12-10 06:34:35','2022-12-10 06:34:35'),(128,145,1,'2022-12-10 06:34:35','2022-12-10 06:34:35'),(129,146,1,'2022-12-10 06:34:35','2022-12-10 06:34:35'),(130,147,1,'2022-12-10 06:34:35','2022-12-10 06:34:35'),(131,148,1,'2022-12-10 06:34:35','2022-12-10 06:34:35'),(132,149,1,'2022-12-10 06:34:35','2022-12-10 06:34:35'),(133,151,1,'2022-12-10 06:34:35','2022-12-10 06:34:35');

--
-- Table structure for table `arrival_times`
--

CREATE TABLE `arrival_times` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `arrival_id` int unsigned NOT NULL,
  `from` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `to` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `arrival_times_arrival_id_foreign` (`arrival_id`),
  CONSTRAINT `arrival_times_arrival_id_foreign` FOREIGN KEY (`arrival_id`) REFERENCES `arrivals` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `arrival_times`
--

INSERT INTO `arrival_times` (`id`, `arrival_id`, `from`, `to`, `created_at`, `updated_at`) VALUES (11,2,'15:00','19:00','2022-12-20 21:36:18','2022-12-20 21:36:18'),(12,3,'15:00','19:00','2022-12-20 21:36:42','2022-12-20 21:36:42'),(13,4,'15:00','19:00','2022-12-20 21:37:05','2022-12-20 21:37:05'),(14,5,'15:00','19:00','2022-12-20 21:37:27','2022-12-20 21:37:27'),(15,6,'15:00','19:00','2022-12-20 21:37:47','2022-12-20 21:37:47'),(20,1,'15:00','19:00','2023-03-06 14:03:34','2023-03-06 14:03:34'),(21,1,'19:00','21:00','2023-03-06 14:03:34','2023-03-06 14:03:34');

--
-- Table structure for table `arrivals`
--

CREATE TABLE `arrivals` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `day` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `avalibale` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `arrivals`
--

INSERT INTO `arrivals` (`id`, `day`, `avalibale`, `created_at`, `updated_at`) VALUES (1,'Saturday',1,'2022-06-23 07:18:36','2022-12-20 21:35:56'),(2,'Sunday',1,'2022-12-20 21:36:18','2022-12-20 21:36:18'),(3,'Monday',1,'2022-12-20 21:36:42','2022-12-20 21:36:42'),(4,'Tuesday',1,'2022-12-20 21:37:05','2022-12-20 21:37:05'),(5,'Wednesday',1,'2022-12-20 21:37:27','2022-12-20 21:37:27'),(6,'Thursday',1,'2022-12-20 21:37:47','2022-12-20 21:37:47');

--
-- Table structure for table `branche_translations`
--

CREATE TABLE `branche_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `branche_id` int unsigned NOT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `branche_translations_branche_id_locale_unique` (`branche_id`,`locale`),
  KEY `branche_translations_locale_index` (`locale`),
  CONSTRAINT `branche_translations_branche_id_foreign` FOREIGN KEY (`branche_id`) REFERENCES `branches` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `branche_translations`
--

INSERT INTO `branche_translations` (`id`, `branche_id`, `address`, `locale`, `created_at`, `updated_at`) VALUES (3,2,'مؤسسة الالتزام للمقاولات العامة للمباني','ar',NULL,NULL),(4,2,'مؤسسة الالتزام للمقاولات العامة للمباني','en',NULL,NULL),(5,3,'شركة باند للتصميم','ar',NULL,NULL),(6,3,'شركة باند للتصميم','en',NULL,NULL),(7,4,'شركة ميتال لأعمال الالمنيوم','ar',NULL,NULL),(8,4,'شركة ميتال لأعمال الالمنيوم','en',NULL,NULL),(9,5,'تونتي ناين لأعمال النجارة والديكور','ar',NULL,NULL),(10,5,'تونتي ناين لأعمال النجارة والديكور','en',NULL,NULL),(11,6,'مخزن السيراميك','ar',NULL,NULL),(12,6,'مخزن السيراميك','en',NULL,NULL),(13,7,'كود للتكييف والتهويه المركزية','ar',NULL,NULL),(14,7,'كود للتكييف والتهويه المركزية','en',NULL,NULL),(15,8,'اربيسك للمسابح وتنسيق الحدائق','ar',NULL,NULL),(16,8,'اربيسك للمسابح وتنسيق الحدائق','en',NULL,NULL),(17,9,'باند فت اوت للتصميم الصناعي','ar',NULL,NULL),(18,9,'باند فت اوت للتصميم الصناعي','en',NULL,NULL),(19,10,'اوشيو للمواد الصحية','ar',NULL,NULL),(20,10,'اوشيو للمواد الصحية','en',NULL,NULL),(21,11,'ان دور للابواب والشبابيك','ar',NULL,NULL),(22,11,'ان دور للابواب والشبابيك','en',NULL,NULL),(23,12,'سيرامكس للسيراميك والبورسلان','ar',NULL,NULL),(24,12,'سيرامكس للسيراميك والبورسلان','en',NULL,NULL);

--
-- Table structure for table `branches`
--

CREATE TABLE `branches` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `status` int NOT NULL DEFAULT '1',
  `address_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_latitude` double NOT NULL,
  `address_longitude` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone2` varchar(111) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `branches`
--

INSERT INTO `branches` (`id`, `status`, `address_address`, `address_latitude`, `address_longitude`, `created_at`, `updated_at`, `phone`, `phone2`) VALUES (2,1,NULL,0,0,'2024-02-19 18:41:57','2024-02-19 18:41:57','https://www.instagram.com/al.eltzam/?hl=ar',NULL),(3,1,NULL,0,0,'2024-02-19 18:52:16','2024-02-21 16:24:24','https://www.instagram.com/band.des/',NULL),(4,1,NULL,0,0,'2024-02-19 18:52:44','2024-02-21 16:25:08','https://www.instagram.com/metal.kitchens.kw/',NULL),(5,1,NULL,0,0,'2024-02-19 18:52:52','2024-02-21 16:25:24','https://www.instagram.com/twentyninekw/',NULL),(6,1,NULL,0,0,'2024-02-19 18:52:57','2024-02-21 16:25:47','https://www.instagram.com/ceramicstor/',NULL),(7,1,NULL,0,0,'2024-02-19 18:53:03','2024-02-21 16:27:07','https://www.instagram.com/kw.cod/',NULL),(8,1,NULL,0,0,'2024-02-19 18:53:08','2024-02-21 16:27:33','https://www.instagram.com/arabiskkw/',NULL),(9,1,NULL,0,0,'2024-02-19 18:53:14','2024-02-21 16:27:47','https://www.instagram.com/bandfitout/',NULL),(10,1,NULL,0,0,'2024-02-19 18:53:19','2024-02-21 16:28:29','https://www.instagram.com/occhio.kw/',NULL),(11,1,NULL,0,0,'2024-02-19 18:53:27','2024-02-21 16:28:41','https://www.instagram.com/indooor.kw/',NULL),(12,1,NULL,0,0,'2024-02-19 18:53:33','2024-02-19 18:53:33',NULL,NULL);

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

CREATE TABLE `categories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint(1) NOT NULL DEFAULT '0',
  `parent_id` int NOT NULL,
  `color_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `main` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `category_translations`
--

CREATE TABLE `category_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `category_id` int unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `category_translations_category_id_locale_unique` (`category_id`,`locale`),
  KEY `category_translations_locale_index` (`locale`),
  CONSTRAINT `category_translations_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category_translations`
--


--
-- Table structure for table `contacts`
--

CREATE TABLE `contacts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `status` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `contacts`
--

INSERT INTO `contacts` (`id`, `name`, `email`, `comment`, `phone`, `created_at`, `updated_at`, `status`) VALUES (1,'samer','samer@gmail.com','asdasdasd','4365345','2022-06-26 11:13:47','2022-06-26 11:39:22',1),(2,'cvbb','ffhjvh@ghh.com','shigella','vvv','2022-06-28 08:15:57','2022-06-28 08:15:57',0),(3,'adada','asdsd@gmail.com','sdfsdf','234234','2022-11-03 23:02:52','2022-11-03 23:02:52',0),(4,'dsfsf','sdfds@gmail.com','dsfsdfsdf','3242342','2022-11-03 23:04:04','2022-11-03 23:04:04',0),(5,'asdasd','asdasd@gmail.com','asdfasd','3234','2022-11-03 23:04:32','2022-11-03 23:04:32',0);

--
-- Table structure for table `countries`
--

CREATE TABLE `countries` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address_latitude` double NOT NULL,
  `address_longitude` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `prices` float NOT NULL,
  `key` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipper` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `countries`
--

INSERT INTO `countries` (`id`, `status`, `image`, `code`, `currency`, `address_address`, `address_latitude`, `address_longitude`, `created_at`, `updated_at`, `prices`, `key`, `shipper`) VALUES (1,1,'vvBbzHHZDdEbPGgHbbrF3nYfARVqffCyLAOF5oKv.png','KWD','KWD','مدينة الكويت، Kuwait',29.375859,47.9774052,'2020-07-29 23:06:29','2023-03-13 12:30:03',1,'+965',NULL),(2,1,'Jf0lu2CuQ7q5H1rfTHMQ6aKaUW80u1WcrgRJTwgx.png','SAR','SAR','Saudi Arabia',23.885942,45.079162,'2022-04-25 17:22:01','2023-09-27 17:05:03',12.0769,'+966','10'),(3,1,'oDrty4kRyxsgSxmLAe7zXbHKWs84OEjVPX1ZQkMQ.jpg','QAR','ريال قطري','Tehran Province, Tehran, خیابان وزرا، Iran',35.7373583,51.4125621,'2022-11-20 13:41:51','2023-09-27 17:05:04',11.7233,NULL,'12'),(4,1,'fOxYPIAf1yBMBi4JDmn8x6AQJNq0jh8gGpDxObZ6.png','AED','AED','الإمارات العربية المتحدة',23.424076,53.847818,'2022-12-05 08:55:34','2023-09-27 05:20:03',11.827,NULL,NULL),(6,1,'uW8rovTlH1s97FAjL1GKzCkS1oQt7nsF7UOXwTDq.png','BHD','BHD','البحرين',26.0667,50.5577,'2022-12-06 13:39:21','2023-09-27 17:05:05',1.21421,NULL,NULL),(7,1,'RHYIml9mZoz7pAUJuuqxUUDaIku2cQXfoPZCitbm.png','OMR','OMR','Oman',21.4735329,55.975413,'2022-12-20 21:28:24','2023-09-27 17:05:05',1.23833,NULL,NULL);

--
-- Table structure for table `country_translations`
--

CREATE TABLE `country_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `country_id` int unsigned NOT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `locale` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `country_translations_country_id_locale_unique` (`country_id`,`locale`),
  KEY `country_translations_locale_index` (`locale`),
  CONSTRAINT `country_translations_country_id_foreign` FOREIGN KEY (`country_id`) REFERENCES `countries` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `country_translations`
--

INSERT INTO `country_translations` (`id`, `country_id`, `name`, `locale`, `created_at`, `updated_at`) VALUES (1,1,'الكويت','ar',NULL,NULL),(2,1,'kuwait','en',NULL,NULL),(3,2,'السعودية','ar',NULL,NULL),(4,2,'Saudi Arabia','en',NULL,NULL),(5,3,'قطر','ar',NULL,NULL),(6,3,'Qater','en',NULL,NULL),(7,4,'الإمارات','ar',NULL,NULL),(8,4,'United Arab Emirates','en',NULL,NULL),(11,6,'البحرين','ar',NULL,NULL),(12,6,'Bahrain','en',NULL,NULL),(13,7,'عُمان','ar',NULL,NULL),(14,7,'Oman','en',NULL,NULL);

--
-- Table structure for table `coupone_relateds`
--

CREATE TABLE `coupone_relateds` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `coupons_id` int unsigned NOT NULL,
  `related_id` int NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `coupone_relateds_coupons_id_foreign` (`coupons_id`),
  CONSTRAINT `coupone_relateds_coupons_id_foreign` FOREIGN KEY (`coupons_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `coupone_relateds`
--

INSERT INTO `coupone_relateds` (`id`, `coupons_id`, `related_id`, `created_at`, `updated_at`) VALUES (3,1,2,NULL,NULL),(4,1,4,NULL,NULL),(5,1,5,NULL,NULL),(6,1,6,NULL,NULL),(7,2,2,NULL,NULL),(8,2,4,NULL,NULL),(9,2,5,NULL,NULL),(10,2,6,NULL,NULL),(11,3,6,NULL,NULL);

--
-- Table structure for table `coupons`
--

CREATE TABLE `coupons` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `count` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `coupons_user_id_foreign` (`user_id`),
  CONSTRAINT `coupons_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `coupons`
--

INSERT INTO `coupons` (`id`, `user_id`, `name`, `code`, `type`, `value`, `count`, `status`, `created_at`, `updated_at`) VALUES (1,1,'asds','sa','category','10',1,0,'2022-09-24 17:17:33','2023-03-07 07:15:59'),(2,1,'جمعية','9821','category','10',7,0,'2022-10-02 09:01:16','2023-03-07 07:16:05'),(3,1,'لفاا','mm','product','10',10,0,'2022-11-20 14:06:28','2023-03-07 07:16:02'),(4,1,'كود خصم كلي','sasa','total','12',10,0,'2022-12-14 07:01:33','2023-03-07 07:16:03');

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

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

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


--
-- Table structure for table `feature_option_translations`
--

CREATE TABLE `feature_option_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `feature_option_id` int unsigned NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `feature_option_translations_feature_option_id_locale_unique` (`feature_option_id`,`locale`),
  CONSTRAINT `feature_option_translations_feature_option_id_foreign` FOREIGN KEY (`feature_option_id`) REFERENCES `feature_options` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `feature_option_translations`
--


--
-- Table structure for table `feature_options`
--

CREATE TABLE `feature_options` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `price` decimal(8,2) DEFAULT '0.00',
  `count` int DEFAULT '0',
  `feature_id` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `color` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `feature_options_feature_id_foreign` (`feature_id`),
  CONSTRAINT `feature_options_feature_id_foreign` FOREIGN KEY (`feature_id`) REFERENCES `features` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `feature_options`
--


--
-- Table structure for table `feature_translations`
--

CREATE TABLE `feature_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `feature_id` int unsigned NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `feature_translations_feature_id_locale_unique` (`feature_id`,`locale`),
  KEY `feature_translations_locale_index` (`locale`),
  CONSTRAINT `feature_translations_feature_id_foreign` FOREIGN KEY (`feature_id`) REFERENCES `features` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `feature_translations`
--


--
-- Table structure for table `features`
--

CREATE TABLE `features` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `type` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `features_product_id_foreign` (`product_id`),
  CONSTRAINT `features_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `features`
--


--
-- Table structure for table `files`
--

CREATE TABLE `files` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `main` tinyint NOT NULL DEFAULT '0',
  `tag` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fileable_id` bigint unsigned DEFAULT NULL,
  `fileable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `files`
--

INSERT INTO `files` (`id`, `image`, `main`, `tag`, `fileable_id`, `fileable_type`, `created_at`, `updated_at`) VALUES (1,'/uploads/product/1/17083689832.png',0,'17083689832.png',1,'App\\Models\\Product','2024-02-19 18:56:23','2024-02-19 18:56:23'),(2,'/uploads/product/1/17083689863.png',0,'17083689863.png',1,'App\\Models\\Product','2024-02-19 18:56:26','2024-02-19 18:56:26');

--
-- Table structure for table `government_translations`
--

CREATE TABLE `government_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `government_id` int unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `government_translations_government_id_locale_unique` (`government_id`,`locale`),
  KEY `government_translations_locale_index` (`locale`),
  CONSTRAINT `government_translations_government_id_foreign` FOREIGN KEY (`government_id`) REFERENCES `governments` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=133 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `government_translations`
--

INSERT INTO `government_translations` (`id`, `government_id`, `name`, `locale`, `created_at`, `updated_at`) VALUES (15,8,'العاصمة','ar',NULL,NULL),(16,8,'Capital Governorate','en',NULL,NULL),(17,9,'الأحمدي','ar',NULL,NULL),(18,9,'Ahmadi Governorate','en',NULL,NULL),(19,10,'الفروانية','ar',NULL,NULL),(20,10,'Farwaniya Governorate','en',NULL,NULL),(21,11,'الجهراء','ar',NULL,NULL),(22,11,'Jahra Governorate','en',NULL,NULL),(23,12,'حولي','ar',NULL,NULL),(24,12,'Hawalli Governorate','en',NULL,NULL),(25,13,'مبارك الكبير','ar',NULL,NULL),(26,13,'Mubarak Al-Kabeer Governorate','en',NULL,NULL),(27,14,'الرياض','ar',NULL,NULL),(28,14,'RIYAD','en',NULL,NULL),(29,15,'مكة المكرمة','ar',NULL,NULL),(30,15,'MAKKAH AL MUKARRAMAH','en',NULL,NULL),(31,16,'المدينة المنورة','ar',NULL,NULL),(32,16,'MADINA EL MONAWARA','en',NULL,NULL),(33,17,'القصيم','ar',NULL,NULL),(34,17,'QASSIM','en',NULL,NULL),(35,18,'المنطقة الشرقية','ar',NULL,NULL),(36,18,'Eastern Province','en',NULL,NULL),(37,19,'عسير','ar',NULL,NULL),(38,19,'Asir','en',NULL,NULL),(39,20,'تبوك','ar',NULL,NULL),(40,20,'TABOUK','en',NULL,NULL),(41,21,'حائل','ar',NULL,NULL),(42,21,'Hail','en',NULL,NULL),(43,22,'عرعر','ar',NULL,NULL),(44,22,'Arar','en',NULL,NULL),(45,23,'رفحاء','ar',NULL,NULL),(46,23,'Rafha','en',NULL,NULL),(47,24,'العويقيلة','ar',NULL,NULL),(48,24,'Al Aqilah','en',NULL,NULL),(49,25,'طريف','ar',NULL,NULL),(50,25,'TURAIF','en',NULL,NULL),(51,26,'جازان','ar',NULL,NULL),(52,26,'GIZAN','en',NULL,NULL),(53,27,'نجران','ar',NULL,NULL),(54,27,'NAJRAN','en',NULL,NULL),(55,28,'الباحة','ar',NULL,NULL),(56,28,'AL BAHA','en',NULL,NULL),(57,29,'الجوف','ar',NULL,NULL),(58,29,'JOUF','en',NULL,NULL),(59,30,'الريان','ar',NULL,NULL),(60,30,'RAYYAN','en',NULL,NULL),(61,31,'الدوحة','ar',NULL,NULL),(62,31,'DOHA','en',NULL,NULL),(63,32,'الخور','ar',NULL,NULL),(64,32,'AL KHOR','en',NULL,NULL),(65,33,'الوكرة','ar',NULL,NULL),(66,33,'WAKRAH','en',NULL,NULL),(67,34,'الشمال','ar',NULL,NULL),(68,34,'AL SHAMAL','en',NULL,NULL),(69,35,'ام صلال علي','ar',NULL,NULL),(70,35,'UM SALAL ALI','en',NULL,NULL),(71,36,'ام صلال محمد','ar',NULL,NULL),(72,36,'UM SALAL MOHAMMED','en',NULL,NULL),(73,37,'الضعاين','ar',NULL,NULL),(74,37,'AL DAAYAEN','en',NULL,NULL),(75,38,'دبي','ar',NULL,NULL),(76,38,'DUBAI','en',NULL,NULL),(77,39,'أبوظبي','ar',NULL,NULL),(78,39,'ABU DHABI','en',NULL,NULL),(79,40,'الشارقة','ar',NULL,NULL),(80,40,'Sharjah','en',NULL,NULL),(81,41,'العين','ar',NULL,NULL),(82,41,'AL AIN','en',NULL,NULL),(83,42,'عجمان','ar',NULL,NULL),(84,42,'Ajman','en',NULL,NULL),(85,43,'رأس الخيمة','ar',NULL,NULL),(86,43,'Ras al Khaimah','en',NULL,NULL),(87,44,'الفجيرة','ar',NULL,NULL),(88,44,'Fujairah','en',NULL,NULL),(89,45,'ام القيوين','ar',NULL,NULL),(90,45,'Umm Al Quawain','en',NULL,NULL),(91,46,'دبا الفجيرة','ar',NULL,NULL),(92,46,'Dibba Al Fujairah','en',NULL,NULL),(93,47,'خورفكان','ar',NULL,NULL),(94,47,'KHORFAKAN','en',NULL,NULL),(95,48,'كلباء','ar',NULL,NULL),(96,48,'KALBA','en',NULL,NULL),(97,49,'مدينة زايد','ar',NULL,NULL),(98,49,'Zayed City','en',NULL,NULL),(99,50,'الرويس','ar',NULL,NULL),(100,50,'Ruwais','en',NULL,NULL),(101,51,'دبا الحصن','ar',NULL,NULL),(102,51,'Dibba Al Hisn','en',NULL,NULL),(103,52,'الرمس','ar',NULL,NULL),(104,52,'Rams','en',NULL,NULL),(105,53,'الداخلية','ar',NULL,NULL),(106,53,'Al Dakhiliyah','en',NULL,NULL),(107,54,'الظاهرة','ar',NULL,NULL),(108,54,'Al Dhahirah','en',NULL,NULL),(109,55,'شمال الباطنة','ar',NULL,NULL),(110,55,'Al Batinah North','en',NULL,NULL),(111,56,'جنوب الباطنة','ar',NULL,NULL),(112,56,'Al Batinah South','en',NULL,NULL),(113,57,'البريمي','ar',NULL,NULL),(114,57,'Buraimi','en',NULL,NULL),(115,58,'الوسطى','ar',NULL,NULL),(116,58,'Al Wusta','en',NULL,NULL),(117,59,'شمال الشرقية','ar',NULL,NULL),(118,59,'North Sharqiyah','en',NULL,NULL),(119,60,'جنوب الشرقية','ar',NULL,NULL),(120,60,'South-Eastern','en',NULL,NULL),(121,61,'ظفار','ar',NULL,NULL),(122,61,'Dhofar','en',NULL,NULL),(123,62,'مسقط','ar',NULL,NULL),(124,62,'Muscat','en',NULL,NULL),(125,63,'مسندم','ar',NULL,NULL),(126,63,'Musandam','en',NULL,NULL),(127,64,'محافظة العاصمة','ar',NULL,NULL),(128,64,'Capital Governorate','en',NULL,NULL),(129,65,'المحرق','ar',NULL,NULL),(130,65,'Muharraq','en',NULL,NULL),(131,66,'المحافظة الشمالية','ar',NULL,NULL),(132,66,'Northern Governorate','en',NULL,NULL);

--
-- Table structure for table `governments`
--

CREATE TABLE `governments` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `status` int NOT NULL DEFAULT '1',
  `address_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address_latitude` double NOT NULL,
  `address_longitude` double NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `country_id` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=67 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `governments`
--

INSERT INTO `governments` (`id`, `status`, `address_address`, `address_latitude`, `address_longitude`, `created_at`, `updated_at`, `country_id`) VALUES (8,1,'العاصمة، Kuwait',29.3342457,47.9812152,'2022-08-24 14:00:00','2022-12-10 06:48:49',1),(9,1,'الأحمدي',0,0,'2022-08-24 14:01:23','2022-08-24 14:01:23',1),(10,1,'الفروانية',0,0,'2022-08-24 14:01:45','2022-08-24 14:01:45',1),(11,1,'الجهراء',0,0,'2022-08-24 14:02:14','2022-08-24 14:02:14',1),(12,1,'حولي',0,0,'2022-08-24 14:02:34','2022-08-24 14:02:34',1),(13,1,'مبارك الكبير',0,0,'2022-08-24 14:02:50','2022-08-24 14:02:50',1),(14,1,'الرياض Saudi Arabia',24.7135517,46.6752957,'2023-05-04 09:24:23','2023-05-04 09:24:23',2),(15,1,'Makkah al-Mukarramah Saudi Arabia',21.3890824,39.8579118,'2023-05-04 09:28:57','2023-05-04 09:30:09',2),(16,1,'Madina El Monawara, Diriyah Saudi Arabia',24.7621277,46.5759892,'2023-05-04 09:30:51','2023-05-04 09:30:51',2),(17,1,'Qassim Saudi Arabia',26.207826,43.483738,'2023-05-04 09:31:27','2023-05-04 09:31:27',2),(18,1,'المنطقة الشرقية Saudi Arabia',23.5681347,50.6793759,'2023-05-04 09:33:26','2023-05-04 09:33:26',2),(19,1,'Asir Saudi Arabia',19.0969062,42.8637875,'2023-05-04 09:36:03','2023-05-04 09:36:26',2),(20,1,'Tabuk Saudi Arabia',28.3835079,36.5661908,'2023-05-04 09:39:59','2023-05-04 09:39:59',2),(21,1,'Hail Saudi Arabia',27.5114102,41.7208243,'2023-05-04 09:41:31','2023-05-04 09:41:31',2),(22,1,'Araraquara, State of São Paulo, Brazil',-21.7790843,-48.1792643,'2023-05-04 09:42:06','2023-05-04 09:42:06',2),(23,1,'Rafha Saudi Arabia',29.62728449999999,43.5192704,'2023-05-04 09:44:41','2023-05-04 09:44:41',NULL),(24,1,'Al Aqilah, Riyadh Saudi Arabia',24.7392522,46.6668795,'2023-05-04 09:46:45','2023-05-04 09:46:45',2),(25,1,'طريف‎ Saudi Arabia',31.6660775,38.6634693,'2023-05-04 09:47:36','2023-05-04 09:47:59',2),(26,1,'Gizan Saudi Arabia',16.8893586,42.57056740000001,'2023-05-04 09:49:12','2023-05-04 09:49:12',2),(27,1,'Najran Saudi Arabia',17.5656036,44.2289441,'2023-05-04 09:53:02','2023-05-04 09:53:02',2),(28,1,'الباحة Saudi Arabia',20.0217407,41.4712733,'2023-05-04 09:54:50','2023-05-04 09:54:50',2),(29,1,'الجوف Saudi Arabia',29.887356,39.3206241,'2023-05-04 09:56:31','2023-05-04 09:56:31',2),(30,1,'Qatar Foundation, Ar-Rayyan, Qatar',25.3193477,51.43620809999999,'2023-05-04 10:01:19','2023-05-04 10:01:19',3),(31,1,'Doha, Qatar',25.2854473,51.53103979999999,'2023-05-04 10:02:26','2023-05-04 10:02:26',3),(32,1,'الخور، Qatar',25.6804078,51.4968502,'2023-05-04 10:03:05','2023-05-04 10:03:05',3),(33,1,'Wakrah, Qatar',24.7815867,51.2631813,'2023-05-04 10:04:17','2023-05-04 10:04:17',3),(34,1,'Al Shamal, Qatar',26.0056463,51.2213044,'2023-05-04 10:05:03','2023-05-04 10:05:03',3),(35,1,'أم صلال عل، Qatar',25.4695749,51.3968437,'2023-05-04 10:05:29','2023-05-04 10:05:29',NULL),(36,1,'أم صلال محمد، Qatar',25.3983615,51.4247485,'2023-05-04 10:05:55','2023-05-04 10:05:55',NULL),(37,1,'مركز الظعاين الصحي، Qatar',25.5634402,51.4538182,'2023-05-04 10:07:13','2023-05-04 10:07:13',NULL),(38,1,'Dubai - United Arab Emirates',25.2048493,55.2707828,'2023-05-04 10:08:18','2023-05-04 10:08:18',4),(39,1,'Abu Dhabi - United Arab Emirates',24.453884,54.3773438,'2023-05-04 10:12:02','2023-05-04 10:59:57',4),(40,1,'الشارقة - Sharjah - United Arab Emirates',25.3461555,55.42109319999999,'2023-05-04 10:12:22','2023-05-04 10:59:31',4),(41,1,'4 طريق العين - Abu Dhabi - United Arab Emirates',24.285115,54.6410752,'2023-05-04 10:12:48','2023-05-04 10:59:15',4),(42,1,'عجمان - Ajman - United Arab Emirates',25.4052165,55.5136433,'2023-05-04 10:13:13','2023-05-04 10:58:59',4),(43,1,'رأس الخيمة - Ras al Khaimah - United Arab Emirates',25.8006926,55.9761994,'2023-05-04 10:13:26','2023-05-04 10:58:43',4),(44,1,'الفجيرة - Fujairah - United Arab Emirates',25.1288099,56.3264849,'2023-05-04 10:13:40','2023-05-04 10:58:22',4),(45,1,'أم القيوين - Umm Al Quawain - United Arab Emirates',25.5507975,55.5524476,'2023-05-04 10:13:55','2023-05-04 10:58:11',4),(46,1,'Dibba Al-Fujairah - Fujairah - United Arab Emirates',25.594046,56.2625744,'2023-05-04 10:15:52','2023-05-04 10:57:58',4),(47,1,'Khorfakkan Waterfalls - Sharjah - United Arab Emirates',25.3669781,56.3481254,'2023-05-04 10:17:19','2023-05-04 10:57:48',4),(48,1,'Kalba - Sharjah - United Arab Emirates',25.057898,56.3546378,'2023-05-04 10:18:19','2023-05-04 10:57:34',4),(49,1,'مدينة زايد - Abu Dhabi - United Arab Emirates',23.6568306,53.7033803,'2023-05-04 10:28:23','2023-05-04 10:57:24',4),(50,1,'Ruwais - Abu Dhabi - United Arab Emirates',24.0974844,52.7347149,'2023-05-04 10:29:00','2023-05-04 10:29:00',NULL),(51,1,'Dibba Al-Hisn - Sharjah - United Arab Emirates',25.615171,56.2673582,'2023-05-04 10:29:40','2023-05-04 10:29:40',NULL),(52,1,'Rams - Ras al Khaimah - United Arab Emirates',25.8782807,56.0250625,'2023-05-04 10:31:32','2023-05-04 10:57:10',4),(53,1,'محافظة الداخلية، Oman',22.8588758,57.5394356,'2023-05-04 10:37:26','2023-05-04 10:37:26',7),(54,1,'الظاهرة للعقارات ومقاولات البناء، Al Buraimi, عمان',24.2496788,55.7852067,'2023-05-04 10:38:15','2023-05-04 10:38:34',7),(55,1,'شمال الباطنه، Oman',21.4735329,55.975413,'2023-05-04 10:39:19','2023-05-04 10:39:19',7),(56,1,'Al Batinah South Governorate, Oman',23.4314903,57.4239796,'2023-05-04 10:39:37','2023-05-04 10:55:04',7),(57,1,'البريمي، Oman',24.2815207,55.8245558,'2023-05-04 10:40:08','2023-05-04 10:53:50',7),(58,1,'محافظة الوسطى، Oman',19.9571078,56.2756846,'2023-05-04 10:41:15','2023-05-04 10:53:10',7),(59,1,'شمال الشرقيه إبراء، الفليج،، Oman',23.2227578,58.79818210000001,'2023-05-04 10:41:43','2023-05-04 10:52:57',7),(60,1,'جنوب الشرقية، 35, Al Kamil Wal Wafi, Oman',22.2231668,59.20378599999999,'2023-05-04 10:42:07','2023-05-04 10:52:29',7),(61,1,'ظفار، Oman',17.0322121,54.1425214,'2023-05-04 10:42:27','2023-05-04 10:52:13',7),(62,1,'مسقط، Oman',23.5880307,58.3828717,'2023-05-04 10:42:48','2023-05-04 10:51:52',7),(63,1,'مسندم، Oman',26.1986144,56.2460949,'2023-05-04 10:43:20','2023-05-04 10:43:20',NULL),(64,1,'Capital Governorate, Bahrain',26.2217634,50.5653294,'2023-05-04 10:46:05','2023-05-04 10:46:05',6),(65,1,'Muharraq, Bahrain',26.2534919,50.60825579999999,'2023-05-04 10:46:36','2023-05-04 10:49:38',6),(66,1,'المحافظة الشمالية، Bahrain',26.1882301,50.4928628,'2023-05-04 10:47:35','2023-05-04 10:49:02',6);

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

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

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

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES (1,'2014_10_12_000000_create_users_table',1),(2,'2014_10_12_100000_create_password_resets_table',1),(3,'2016_06_01_000001_create_oauth_auth_codes_table',1),(4,'2016_06_01_000002_create_oauth_access_tokens_table',1),(5,'2016_06_01_000003_create_oauth_refresh_tokens_table',1),(6,'2016_06_01_000004_create_oauth_clients_table',1),(7,'2016_06_01_000005_create_oauth_personal_access_clients_table',1),(8,'2019_08_19_000000_create_failed_jobs_table',1),(9,'2019_12_14_000001_create_personal_access_tokens_table',1),(10,'2022_02_06_071010_laratrust_setup_tables',1),(11,'2022_02_07_073030_create_public_notifcations_table',1),(12,'2022_02_07_131228_create_topics_table',1),(13,'2022_02_07_131335_create_topic_subscripts_table',1),(14,'2022_02_10_131840_create_short_terms_table',1),(15,'2022_03_24_101035_create_sliders_table',1),(16,'2022_03_24_114417_create_slider_translations_table',1),(17,'2022_05_29_115314_create_categories_table',1),(18,'2022_05_29_115351_create_category_translations_table',1),(19,'2022_05_31_082944_create_products_tables',1),(20,'2022_05_31_083136_create_product_translations_table',1),(21,'2022_05_31_084033_create_features_table',1),(22,'2022_05_31_084050_create_feature_translations_table',1),(23,'2022_05_31_084308_create_feature_options_table',1),(24,'2022_05_31_084333_create_feature_option_translations_table',1),(25,'2022_05_31_085551_create_files_table',1),(26,'2022_05_31_112821_create_product_categories_table',1),(27,'2022_06_02_080435_create_payment_methods_table',1),(28,'2022_06_02_080436_create_shipping_types_table',1),(29,'2022_06_02_080440_create_orders_table',1),(30,'2022_06_02_081214_create_product_orders_table',1),(31,'2022_06_02_081356_create_order_product_features_table',1),(32,'2022_06_02_082600_create_payment_method_translations_table',1),(33,'2022_06_02_082610_create_shipping_type_translations_table',1),(34,'2022_06_02_122112_create_governments_table',1),(35,'2022_06_02_122142_create_government_translations_table',1),(36,'2022_06_02_122214_create_regions_table',1),(37,'2022_06_02_122222_create_region_translations_table',1),(38,'2022_06_02_133202_create_arrival_prices_table',1),(39,'2022_06_04_091835_added_checked_to_products_table',1),(40,'2022_06_05_073619_create_coupons_table',1),(41,'2022_06_05_074500_create_coupone_relateds_table',1),(42,'2022_06_05_081404_create_user_products_table',1),(43,'2022_06_05_113923_create_user_addresses_table',1),(44,'2022_06_08_101900_create_arrivals_table',1),(45,'2022_06_08_102003_create_arrival_times_table',1),(46,'2022_06_09_132916_create_order_coupons_table',1),(47,'2022_06_09_134805_add_category_id_to_product_orders_table',1),(48,'2022_06_11_093816_added_checked_to_user_addresses_table',1),(49,'2022_06_11_102956_added_delivery_date_time_to_orders_table',1),(50,'2022_06_11_103215_create_order_shippings_table',1),(51,'2022_06_18_093322_create_order_comments_table',1),(52,'2022_06_19_082401_create_tagers_table',1),(53,'2022_06_20_102847_added_latـlang_table',1),(54,'2022_06_20_135514_create_user_categories_table',1),(55,'2022_06_21_073606_added_image_to_user_table',1),(56,'2022_06_25_095040_create_refund_products_table',2),(57,'2022_06_26_105000_create_user_orders_table',3),(58,'2022_06_26_125130_create_contacts_table',4),(59,'2022_06_28_111636_create_pages_table',5),(60,'2022_06_28_111731_create_page_translations_table',5),(61,'2022_07_17_122026_create_order_options_table',6),(62,'2023_03_21_070405_create_branches_table',7),(63,'2023_03_21_072239_create_branche_translations_table',7);

--
-- Table structure for table `oauth_access_tokens`
--

CREATE TABLE `oauth_access_tokens` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned DEFAULT NULL,
  `client_id` bigint unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_access_tokens_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_access_tokens`
--

INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES ('04c5783973d49237e263303d40d3d2e9f17a41ddfb98b934cdf0e859072814b1e3398baf45293433',73,1,'mazraa','[]',0,'2022-09-28 09:10:32','2022-09-28 09:10:32','2023-09-28 11:10:32'),('06d6a47b866c6ecc39e78b9b665b031f3b2642520c31cc8e4b04ee85a59877e4e68b08aa1c10411e',71,1,'mazraa','[]',0,'2022-07-06 11:16:28','2022-07-06 11:16:28','2023-07-06 13:16:28'),('06da447d74de85c8b73410de9d75a0ec9a6125cfed910acb0b79e0c7a11b361e95a4d02bd65ee305',1,1,'gold','[]',0,'2022-12-10 08:23:25','2022-12-10 08:23:25','2023-12-10 10:23:25'),('0770119bbc9a6dc7d9fb4fa5026d9fe581552532d6b788f330c193433dd20801c00285fa8e5e2a6f',62,1,'mazraa','[]',0,'2022-07-01 12:26:25','2022-07-01 12:26:25','2023-07-01 14:26:25'),('094f5f3fd50f7cca02992d3e1f98ec6e5937431dadd8e32ee65817bc5099dc7aa16b445c0f1a0939',78,1,'gold','[]',0,'2022-10-29 06:57:43','2022-10-29 06:57:43','2023-10-29 08:57:43'),('097819e9b7d5769f0f9b075da44afb0d8b483a69f01ccbd2a452b6a46741e3ea89448565290bf209',1,1,'gold','[]',0,'2022-11-15 09:34:30','2022-11-15 09:34:30','2023-11-15 11:34:30'),('0bf126d7633fae011ddb030611a11fc43214551e9d32fdd8fb9deabed29f9c2812bb3c53f2e101e8',1,1,'gold','[]',0,'2022-12-06 05:38:39','2022-12-06 05:38:39','2023-12-06 07:38:39'),('0c4be3baec2bb77d7b065d4f8f1eb9de25fd92cf587f7aa2cdf5a01f0491687928cd8685bc51fbcb',77,1,'mazraa','[]',0,'2022-09-29 06:35:57','2022-09-29 06:35:57','2023-09-29 08:35:57'),('0f2756793a7aee37a3325c852792d60aa946387f14b0e3bd524933cfe50a4a0b2f0575b275883645',9,1,'mazraa','[]',0,'2022-09-28 08:49:49','2022-09-28 08:49:49','2023-09-28 10:49:49'),('0f4ba37f9ca35241ebb31c9657e066acb01c71225244a9d201c893a4088078a6126a4f29fa274350',77,1,'mazraa','[]',0,'2022-09-29 06:34:50','2022-09-29 06:34:50','2023-09-29 08:34:50'),('0fe2ce712b05c6d4840bc53b66a7f3590efc04cf8d90a6212712e6e560e531e72b6ac3726f41ff13',73,1,'mazraa','[]',0,'2022-10-01 16:16:08','2022-10-01 16:16:08','2023-10-01 18:16:08'),('11e4e3c3d5546eeb00367f099262c4fe488a1aba1a644938f6a8c5ba2785dd52081789fd6ff91aa0',11,1,'mazraa','[]',0,'2022-06-23 08:02:47','2022-06-23 08:02:47','2023-06-23 10:02:47'),('121f3960f28da2ab5e18e54051c96cb5ef994cddacbb6aaa6855f38daa042bfbe689ee2d441b4ba5',73,1,'mazraa','[]',0,'2022-10-02 05:21:48','2022-10-02 05:21:48','2023-10-02 07:21:48'),('12ebd141d29b06674b7af8f36abdaf26934dbf828e7f134c3d3ed5e34a946913be025e3dd7c4ef90',73,1,'mazraa','[]',0,'2022-11-17 08:05:03','2022-11-17 08:05:03','2023-11-17 10:05:03'),('135d1c9e6ab9ac3e682562f753f7f6e521f6ecfac88a951d3f4ec43f680bd2584e4aa9344c938806',82,1,'gold','[]',0,'2022-11-28 10:50:29','2022-11-28 10:50:29','2023-11-28 12:50:29'),('1455211b53b1e4e6becd2dde88ed8ff502edb18f37883d4d6f0e5c2823972863426a489987ab6ce9',76,1,'mazraa','[]',0,'2022-09-29 06:18:30','2022-09-29 06:18:30','2023-09-29 08:18:30'),('15a65942ead48cf920c419b317f5bda965ddd12f529d50880c2da3bd6304c40922cd13bc4297f187',43,1,'mazraa','[]',0,'2022-06-23 09:31:29','2022-06-23 09:31:29','2023-06-23 11:31:29'),('169128135ffbf069c55f8e7fff450f6c589eac7905efdffce3e1ac61b449b9a537c8c57a2e0beedc',76,1,'mazraa','[]',0,'2022-09-29 06:30:03','2022-09-29 06:30:03','2023-09-29 08:30:03'),('16ab442674f11633f651293b08aedb67d098e64a17d6a5c922cfb7418d9ef8f4c74ea519bc9ce7d3',57,1,'mazraa','[]',0,'2022-06-26 05:30:30','2022-06-26 05:30:30','2023-06-26 07:30:30'),('16c58257a012cdca0682407d0fd215d0d26df646762f7fcd77b9574a5f16b61ecbb5d157654720ce',45,1,'mazraa','[]',0,'2022-06-23 09:54:18','2022-06-23 09:54:18','2023-06-23 11:54:18'),('194f8bce0f06c6a6d73ea4d076c4637e478a260a85e6763d67ec58291a391ca659e4e7588b7195bf',11,1,'mazraa','[]',0,'2022-06-23 08:03:59','2022-06-23 08:03:59','2023-06-23 10:03:59'),('1a9c43a3593cca2448c9921cc354f90ff8404ad2e17bbd199b499b7f35f9ba09aa690adca78edb0b',71,1,'mazraa','[]',0,'2022-07-06 11:19:42','2022-07-06 11:19:42','2023-07-06 13:19:42'),('1b1596fa0d5cebf24c26586a036030962be8592dc31a4b33b2dff14f9c6f135439520d78f2142a7b',65,1,'mazraa','[]',0,'2022-07-03 04:39:55','2022-07-03 04:39:55','2023-07-03 06:39:55'),('1b5c2f353de7aafecacfd98b40312b5b28660d6b15089560b6595e4dfaa67b4f524c4b6495ac4ace',18,1,'mazraa','[]',0,'2022-06-23 08:25:17','2022-06-23 08:25:17','2023-06-23 10:25:17'),('1ba2360b77d3e29b2fccf95cd62fdaeb39a757cc1e0309fc0971a530219557ba273ad556af3f5b0f',43,1,'mazraa','[]',0,'2022-06-23 09:31:14','2022-06-23 09:31:14','2023-06-23 11:31:14'),('1e49c47a0b5f7ce9e8bd8f4b358a7c5d90bfebf707649ad8c721e7a9633f2c02602ae4f1a992151c',11,1,'mazraa','[]',0,'2022-06-23 08:06:13','2022-06-23 08:06:13','2023-06-23 10:06:13'),('1ec0fabcee6ba1485def34b013fd3d5878355b4f1ea6315f1f4479f80240925bbfd81c238ed5ce74',73,1,'mazraa','[]',0,'2022-10-01 08:44:15','2022-10-01 08:44:15','2023-10-01 10:44:15'),('20b3dda2783262ae7e7a56b101a30b58bf89c209bff9ec18a715c68818ad529a72144dfa32f733c0',11,1,'mazraa','[]',0,'2022-06-23 08:06:26','2022-06-23 08:06:26','2023-06-23 10:06:26'),('21609e89ea57c036fbe46d6088a92d9b4aaec6070dd29f84db9e2a91fdbed5c66e043dc8d8855e1c',81,1,'mazraa','[]',0,'2022-10-30 08:06:35','2022-10-30 08:06:35','2023-10-30 10:06:35'),('216b7f4038ff4ff0a73506c21d31f9d6d2df68283bfe87ad2db7d2a5e3f3d690a7d418730ed4e1b6',73,1,'mazraa','[]',0,'2022-10-01 15:57:35','2022-10-01 15:57:35','2023-10-01 17:57:35'),('26a279b19322161216c323a9a0798133bda672c398957a84735776b8912759d3718d3ba653cd3436',72,1,'mazraa','[]',0,'2022-09-24 08:52:42','2022-09-24 08:52:42','2023-09-24 10:52:42'),('27cfbb2f9f8975b4495ed6d99f3893851febcbc7a035384f8dafd0d2791a087c699b2e7c5ba0b150',73,1,'mazraa','[]',0,'2022-10-01 06:05:19','2022-10-01 06:05:19','2023-10-01 08:05:19'),('299c66937fcb2e125ed6cf126710b1162511d0e81e28d23c85e0f1c683bf2a9331f36dff581bf503',73,1,'mazraa','[]',0,'2022-11-17 06:26:32','2022-11-17 06:26:32','2023-11-17 08:26:32'),('2da5e289aa4d330fa441a4ab0321fbda54cc43a81f500ff2513bfcf9c51b23f9fb02493eaa5d8ed1',9,1,'mazraa','[]',0,'2022-07-04 07:33:06','2022-07-04 07:33:06','2023-07-04 09:33:06'),('2e3481d95f5a5ccabab1bbd9a6e73e3e35c46c0b18cc617ea70a625abb0bb2656a557e3586219034',71,1,'mazraa','[]',0,'2022-07-06 09:07:56','2022-07-06 09:07:56','2023-07-06 11:07:56'),('2ed9dcda1272bd3693b3cb32140efeeaf1266b2e1c21b8538ebac5d8a94f74f22ec81808deb757b3',80,1,'gold','[]',0,'2022-10-29 08:20:31','2022-10-29 08:20:31','2023-10-29 10:20:31'),('3105a118c0b05b5725d5fc2fb61e18422fe87a320912a97409121e4500e32758088b0ce908c22552',77,1,'mazraa','[]',0,'2022-09-29 06:34:17','2022-09-29 06:34:17','2023-09-29 08:34:17'),('311cb5a95f49884aa2011509065857cf18a1485b4f0f675eca7e2a9103fba32b8c2b5c6f1a58fe9f',73,1,'mazraa','[]',0,'2022-09-28 09:01:11','2022-09-28 09:01:11','2023-09-28 11:01:11'),('3133cfe757d1dcc560d46d6f3a2c522ddc73e719635b512407e768829de9da9380a2da1948fadb98',9,1,'mazraa','[]',0,'2022-10-01 15:52:34','2022-10-01 15:52:34','2023-10-01 17:52:34'),('3313c36c4f41dacb2d103a6dac5715acd4e8cc745adfc32fbfc2a8969ff582a5a7062db2e54e34ea',9,1,'mazraa','[]',0,'2022-07-04 06:30:41','2022-07-04 06:30:41','2023-07-04 08:30:41'),('344ece9f8612b98e8e18fe42db5d182bfe35a98ed15edef75683de40468fb8cb388820d5796f83d8',73,1,'mazraa','[]',0,'2022-09-29 08:38:35','2022-09-29 08:38:35','2023-09-29 10:38:35'),('34f12873c26e726b6c5af96f45423473a7d6ce7465e25d18de8f677045502a6a086bb121c234f6bf',71,1,'mazraa','[]',0,'2022-07-06 09:09:14','2022-07-06 09:09:14','2023-07-06 11:09:14'),('37e6c6bf69fe823824aef2fc417562ab89bfb031a31695be83557cf7a5398aef7dc1ddf35362146c',73,1,'mazraa','[]',0,'2022-10-02 07:43:26','2022-10-02 07:43:26','2023-10-02 09:43:26'),('39366a083a68e5527b7083e7705060a66be525f339a2a083e171bc7728e8b438fd7c709c6342d73f',72,1,'mazraa','[]',0,'2022-09-25 09:21:35','2022-09-25 09:21:35','2023-09-25 11:21:35'),('3a88e0dcb94998f37fd0390fc6fbed3b98615b0ccad38b7f0802b564d22d9ae9c6c7720957187072',40,1,'mazraa','[]',0,'2022-06-23 09:30:17','2022-06-23 09:30:17','2023-06-23 11:30:17'),('3d2e702406f90e315f72162f2de7e36dd15ae6ba8d8336e5649f714c484c01942a9847a8db8a78b0',73,1,'mazraa','[]',0,'2022-11-08 07:34:06','2022-11-08 07:34:06','2023-11-08 09:34:06'),('3d68b896e27a05e84eb90f263c5a2f6c8f450219dee3704771f7888d9f062e80b14cb3cd9a586530',11,1,'mazraa','[]',0,'2022-06-23 08:05:33','2022-06-23 08:05:33','2023-06-23 10:05:33'),('3efddcbb13096ca0735241d6073805a2a660f944b35b8fa9180f5dca610478be160abdf22883f9a5',9,1,'mazraa','[]',0,'2022-06-27 11:49:22','2022-06-27 11:49:22','2023-06-27 13:49:22'),('40e46dadd5b2c57a962f59d8827e002855e8bc9e00fefe80fdcba761c98c7bee0817a17a94b313c7',73,1,'mazraa','[]',0,'2022-10-02 07:46:40','2022-10-02 07:46:40','2023-10-02 09:46:40'),('419806b888bafe7d2d14864f1949f5d3c8f6954d60bdb9bf79b41aa7c0ff530ecfcac897dc6039ea',81,1,'gold','[]',0,'2022-11-02 18:50:02','2022-11-02 18:50:02','2023-11-02 20:50:02'),('41ce822c1b015230b3bfa8284cde36a9fdb1d7713d261e253ac3f41b8e0d575311003f2c6295b028',64,1,'mazraa','[]',0,'2022-07-02 09:28:58','2022-07-02 09:28:58','2023-07-02 11:28:58'),('44b65737ba67b5a729e7b73227df23d9bfff18b1b5601e74b8cbafed9f09eb13bc377527ca747e2f',81,1,'gold','[]',0,'2022-10-31 06:11:27','2022-10-31 06:11:27','2023-10-31 08:11:27'),('450cd12a2b5009e701d341f30dced2472b09de67111a1c02d7c2d45895eeaa5c70314a14fa15e957',73,1,'mazraa','[]',0,'2022-10-01 17:32:28','2022-10-01 17:32:28','2023-10-01 19:32:28'),('45dfc301338c97ea78924e1808759a8f9224cd5cbda16327e50c9b8a9a8bd2a741510e00d8b34215',11,1,'mazraa','[]',0,'2022-06-23 08:04:21','2022-06-23 08:04:21','2023-06-23 10:04:21'),('468369144d0951d5ca808c2a2242a4ac2b1d58baf0ad6d33f721939e89f64317b01adfd7238af2bc',76,1,'mazraa','[]',0,'2022-09-29 06:22:50','2022-09-29 06:22:50','2023-09-29 08:22:50'),('4799365296a88fa738bfebe64b96f79b7815326d4efa5158aa9a2fb53d6d99ff2a490f97d83d2d3b',11,1,'mazraa','[]',0,'2022-06-23 08:04:29','2022-06-23 08:04:29','2023-06-23 10:04:29'),('4958584584d281882b2b63a14f73af39d421857dc7d9fadc6d4b221d4da93e884b6419d7d5b53546',24,1,'mazraa','[]',0,'2022-06-23 08:27:07','2022-06-23 08:27:07','2023-06-23 10:27:07'),('49938f76b16d984df7d5b06ac3b8a0bbd4ce6b3d2d099a46d71cf0c79fc619436ab34cb5398625e4',3,1,'mazraa','[]',0,'2022-06-23 06:47:52','2022-06-23 06:47:52','2023-06-23 08:47:52'),('4a845c855325b6254a26832ab1d0c7fb221c1c0d036a4ae30bd908aee71b5c915599ee5259652d83',74,1,'mazraa','[]',0,'2022-09-29 05:46:05','2022-09-29 05:46:05','2023-09-29 07:46:05'),('4aa4ed91475f5bff6dd22f3684f8cb765fe8873dc873820b8cddb69c74c95d38fbbb49ad950476ce',81,1,'gold','[]',0,'2022-10-30 08:06:52','2022-10-30 08:06:52','2023-10-30 10:06:52'),('5021dd07a66901f01322f3ef96cc8fd9b1efb2552366f1950458ad062c0ca16b46035d4d668e65f3',76,1,'mazraa','[]',0,'2022-09-29 06:18:17','2022-09-29 06:18:17','2023-09-29 08:18:17'),('50dc643c15526b613a72c9a5386b4888f413e9be1f78a06a8a7add390c0d0b4f4f0f7a8dd2733063',43,1,'mazraa','[]',0,'2022-06-23 09:30:46','2022-06-23 09:30:46','2023-06-23 11:30:46'),('513b12c075439fdf6be0f39215cf7323d2a5c4dbf8911da9478517660f0d24b78c7982d8e0345e23',3,1,'mazraa','[]',0,'2022-06-23 08:34:33','2022-06-23 08:34:33','2023-06-23 10:34:33'),('54adc381ffe5013dbeffb0c309c875f34abf032475e1e12c1dce69b62dd0a1951d0125bcdf36ecf0',12,1,'mazraa','[]',0,'2022-06-23 08:11:05','2022-06-23 08:11:05','2023-06-23 10:11:05'),('569892d3ea07736d9126f5a6fca47078f669564f55925263636df9383d5103eec456d0c089de46f8',73,1,'mazraa','[]',0,'2022-11-03 05:59:46','2022-11-03 05:59:46','2023-11-03 07:59:46'),('588ae856b104f19a5ae100a76a9b735f63dfb19166816056e0f67fffb764c44ed9a0440809ca9cb9',73,1,'mazraa','[]',0,'2022-11-01 07:44:29','2022-11-01 07:44:29','2023-11-01 09:44:29'),('59e74542ae7077bf773502ca80789dcf6c0a0d6c9a412e32fd47d849c0af9b9d3cc408a07d86f009',73,1,'mazraa','[]',0,'2022-11-18 08:10:49','2022-11-18 08:10:49','2023-11-18 10:10:49'),('5a754051f1e92c1910aae79f9434da882be73b642c49eee9d2219878c39bcc4f157d3dbb8d30d5d5',43,1,'mazraa','[]',0,'2022-06-23 09:31:26','2022-06-23 09:31:26','2023-06-23 11:31:26'),('5ac68e3ac3e2fb9cf366f441ca48886b2c1cc1ea481308d4c12752487006c573a68c287f75560134',61,1,'mazraa','[]',0,'2022-06-28 09:59:48','2022-06-28 09:59:48','2023-06-28 11:59:48'),('5c7355dd11c8aac12cd180feba02529208d40cba953fe033d669e0d85aef409458d3d066afaeffd0',60,1,'mazraa','[]',0,'2022-06-27 08:37:33','2022-06-27 08:37:33','2023-06-27 10:37:33'),('5e9902ae23bc32cc64f3a75998a627beb83e2ddbe8e290bba5c5b433dc61e42105254502e963da3e',73,1,'mazraa','[]',0,'2022-10-01 18:58:05','2022-10-01 18:58:05','2023-10-01 20:58:05'),('61730597520a7c8cbf62faa4953c5fd72a5a3d938824083d75549c9dfe4f7d3fbd31d24717c39489',3,1,'mazraa','[]',0,'2022-06-23 07:39:54','2022-06-23 07:39:54','2023-06-23 09:39:54'),('620b1882e187621ce2aa80e128b49daa36de7e97b98c0f6eab0524fd13bf2d3734ce0698e2b5a7be',46,1,'mazraa','[]',0,'2022-06-23 09:57:14','2022-06-23 09:57:14','2023-06-23 11:57:14'),('6229c3bc858c941ff6040291190168e12717681ea599c1537da70e20e7733fa8688cbf7b2f67023a',6,1,'mazraa','[]',0,'2022-06-22 10:14:57','2022-06-22 10:14:57','2023-06-22 12:14:57'),('62fad415f9d41597e55b751522a83e2ee8271d41f31b98b52d4d3e40d3f4449ea56dfd9208111ec4',11,1,'mazraa','[]',0,'2022-06-23 07:59:13','2022-06-23 07:59:13','2023-06-23 09:59:13'),('634257169214a9ee3e618c7108217cd5f1b3227fcc4b04e6e7ba9ab8c6b080c2ddcc570b2dcc432c',11,1,'mazraa','[]',0,'2022-06-23 08:03:43','2022-06-23 08:03:43','2023-06-23 10:03:43'),('6430bd1bce32be86a87cb055a21b5a32dfe46f2bdac0b336d6a6cf919310f34b4c40b460fb2c6fa1',41,1,'mazraa','[]',0,'2022-06-23 09:17:00','2022-06-23 09:17:00','2023-06-23 11:17:00'),('65e36ca8fbd4e4a41b6699f5c3d16992ea9ad36d98a1868ee0d59263590be6e4eda270c82df018b3',8,1,'mazraa','[]',0,'2022-06-22 10:16:50','2022-06-22 10:16:50','2023-06-22 12:16:50'),('663dc5c36f941846187d41e295ef8c17aec60fd8acf948712a086684cb5baea1ad74b5aac49504d9',77,1,'mazraa','[]',0,'2022-09-29 06:34:43','2022-09-29 06:34:43','2023-09-29 08:34:43'),('67c134fe3eb21966061598e02a8ed18c592e99bf82dd52a375f2c417ba8882ddb2cd79d270a75491',73,1,'mazraa','[]',0,'2022-11-08 06:55:19','2022-11-08 06:55:19','2023-11-08 08:55:19'),('6981b883e2c80c53faf22351907cb9635577dba3a8910595df6dc72fae5b5550ca49594210eb2134',81,1,'gold','[]',0,'2022-10-29 08:32:25','2022-10-29 08:32:25','2023-10-29 10:32:25'),('69ade6e956e13ebfd45f381b0c2277cac080981ec58c5bb0b00548819c51c7da219bf98d7f445990',73,1,'mazraa','[]',0,'2022-09-29 06:22:05','2022-09-29 06:22:05','2023-09-29 08:22:05'),('6c1fd3a4e8e7d0f1101e9a75069612b8c53ec80480cf157a3a8a2f810f9308e84ebf0d429c72923d',73,1,'mazraa','[]',0,'2022-11-03 05:56:29','2022-11-03 05:56:29','2023-11-03 07:56:29'),('6e5efeb1122e035d0d82129c31d65a7c601f921b193a39f9eecd7fbdac1337cf5c14c5d566c97864',45,1,'mazraa','[]',0,'2022-06-23 09:55:42','2022-06-23 09:55:42','2023-06-23 11:55:42'),('71f0e0a1ce44a15f213716f13278835690ce7c05f6f2fec373681222aa45350fe6fecc8b13984023',69,1,'mazraa','[]',0,'2022-07-05 12:13:21','2022-07-05 12:13:21','2023-07-05 14:13:21'),('72dc474c964ebd6a8b8a8b56fcfb8b0c886fab4b8c1e5054ef29a07d97cfab661bf62f7ddd01bdd7',40,1,'mazraa','[]',0,'2022-06-23 09:14:24','2022-06-23 09:14:24','2023-06-23 11:14:24'),('74a8a1af5cf00c216d57c479080f33abd84292f6ae493c205cc045939993c114370435bf84406775',11,1,'mazraa','[]',0,'2022-06-23 08:03:06','2022-06-23 08:03:06','2023-06-23 10:03:06'),('74f87b871fd11555c0792e02740cffb22523813a11a23e317a5266005a4e2a7fbac8c87147d5c751',81,1,'gold','[]',0,'2022-10-31 10:05:12','2022-10-31 10:05:12','2023-10-31 12:05:12'),('75f393de7da16003334b8e2b3c6ea74a9afc45b2c089df47046fc062330b03deadfbad66dc349025',63,1,'mazraa','[]',0,'2022-07-02 09:09:22','2022-07-02 09:09:22','2023-07-02 11:09:22'),('766696083d78f5e47f7b44a5f287bc8f26d01d22690cbbd1f084e4f731c443002e666cd3b4c19c26',73,1,'mazraa','[]',0,'2022-11-19 14:05:21','2022-11-19 14:05:21','2023-11-19 16:05:21'),('7959cb7fda61e86c6dba7085b6162803f7bd58aae9009eb059a2c5d3085701349d16e02734e5b5eb',73,1,'mazraa','[]',0,'2022-11-03 04:45:35','2022-11-03 04:45:35','2023-11-03 06:45:35'),('7a0ea66d1d3b55397daa622012089abdf1d12fa1ed2852bd69c2317d8dc00cef79d808e767773e94',73,1,'mazraa','[]',0,'2022-11-09 08:57:22','2022-11-09 08:57:22','2023-11-09 10:57:22'),('7a4c5040c7f32efe4fe3d4ef4f8f58bebc9e68f6f383a5646c519bda6d4af3e73891298737d1e652',11,1,'mazraa','[]',0,'2022-06-23 08:04:16','2022-06-23 08:04:16','2023-06-23 10:04:16'),('7a55c9849dfc03134ab40c41632370ca02df563630adc4e95d31477ea6d23627a7edb8a8d4047eb7',73,1,'mazraa','[]',0,'2022-11-17 07:00:45','2022-11-17 07:00:45','2023-11-17 09:00:45'),('7c6fc498767643804a4bb9b1e23594739709d6f043466145a284a0531655a4ad11bc058bd8474f2b',73,1,'mazraa','[]',0,'2022-11-19 15:45:09','2022-11-19 15:45:09','2023-11-19 17:45:09'),('7ce0030a88a9cc88e4be9908a8da82b12e0427467f7172c186215e2e8786e5a8518df4a630bdd6bd',45,1,'mazraa','[]',0,'2022-06-23 10:21:08','2022-06-23 10:21:08','2023-06-23 12:21:08'),('7d0be8f80ad9af1d23c2bd19c5f50b790bb48e5070943a6483e42e5bfb4c745ac501a35abce379d5',9,1,'mazraa','[]',0,'2022-06-27 10:01:18','2022-06-27 10:01:18','2023-06-27 12:01:18'),('7de4b75062e3e35047704eaea4a39e72a05d5124274f97bbf98f15c9018da83e93ce7689a890f34e',71,1,'mazraa','[]',0,'2022-07-06 11:21:10','2022-07-06 11:21:10','2023-07-06 13:21:10'),('7ee5e381d31a22198d431c15eaeef6ac5d761a20a315551f0745d623d8637f0f965bd6e27f1444bb',11,1,'mazraa','[]',0,'2022-06-23 08:04:39','2022-06-23 08:04:39','2023-06-23 10:04:39'),('7f4d3c67e6b52da4fbec6d751425df20e48a154c10d21007cb3ea468425b865f22f894ff87ec90b3',10,1,'mazraa','[]',0,'2022-06-23 06:50:53','2022-06-23 06:50:53','2023-06-23 08:50:53'),('7f8e3bf68719eeab9798c2590f3578693da7b21d13aa36c98b4206def67dfa1d178a6de14f77ece7',39,1,'mazraa','[]',0,'2022-06-23 09:03:16','2022-06-23 09:03:16','2023-06-23 11:03:16'),('7fdaa14102b9477d207c86839aef7c1a00ce3f38ac93a278aa6ed3afc135eefb3bee41bef000a6bd',71,1,'mazraa','[]',0,'2022-07-06 11:18:34','2022-07-06 11:18:34','2023-07-06 13:18:34'),('804420db0a5ee3bee90a35234cc270e5d05c8c9b4da93a4ebe8d858e598f962a3f9084e7ea843859',73,1,'mazraa','[]',0,'2022-11-02 18:18:35','2022-11-02 18:18:35','2023-11-02 20:18:35'),('814f0ed92b557a09b4e03aaa08ead996231cea1f9956d0df15d06ac1c6f04d7ca26f577ee07912ba',71,1,'mazraa','[]',0,'2022-07-06 09:08:58','2022-07-06 09:08:58','2023-07-06 11:08:58'),('816f4cd12a0c9da8df231ad94df9aff35eb005d523ea58c692ec88f9f3e7781e13578c907dcf79fb',73,1,'mazraa','[]',0,'2022-09-28 08:51:27','2022-09-28 08:51:27','2023-09-28 10:51:27'),('8383f4061423bfd6bf0c3eafc396c2a4299a451a5c9d42e86c6522d969033574d3d86ee78b7d1de3',71,1,'mazraa','[]',0,'2022-07-06 11:08:23','2022-07-06 11:08:23','2023-07-06 13:08:23'),('83c043c8392ec90feac3d3e4a91e519f72e53c5fc78b873fe60864333865a972251dfe1ce9257fd0',11,1,'mazraa','[]',0,'2022-06-23 08:09:29','2022-06-23 08:09:29','2023-06-23 10:09:29'),('84e465e23d565fbd3d9debfad177074f780c15bb7d0b5997b77f3efd9cd02095b86b116f9b201c7d',86,1,'gold','[]',0,'2025-10-08 06:25:20','2025-10-08 06:25:20','2026-10-08 06:25:20'),('8644c101435cabf45b8b3de46a12cefcc3e7a14ec85910c11714a6c5ed39aef9fba3b3fc9235dc57',11,1,'mazraa','[]',0,'2022-06-23 08:04:54','2022-06-23 08:04:54','2023-06-23 10:04:54'),('89ffcf36e0e1079d951f1c30db012aba029f561946c18a1608c71489cf35cbb395db4068f99dbf4f',42,1,'mazraa','[]',0,'2022-06-23 09:19:09','2022-06-23 09:19:09','2023-06-23 11:19:09'),('8a9e27fc783f7c1dda05ecafa8a7f4a82d2a67487d3c347d372cfc6aa9354b921fc499da853e3af3',43,1,'mazraa','[]',0,'2022-06-23 09:45:38','2022-06-23 09:45:38','2023-06-23 11:45:38'),('8ac2fe5c85ade22161db3eb07cb0e4cc682a1c5a812f46bd02e2b80ea364d957247e7fbbc08f9c79',71,1,'mazraa','[]',0,'2022-07-06 11:17:07','2022-07-06 11:17:07','2023-07-06 13:17:07'),('8c8720cf9900d1574020453d82936c6ba2ed9cda9f87b1c7c039b0c4ab4ef831adf91a6ac90c9b7a',73,1,'mazraa','[]',0,'2022-10-01 16:54:17','2022-10-01 16:54:17','2023-10-01 18:54:17'),('8e6c192472cd12eedc2731493f1bd0741579827e5787a5049845b5b2073ae966ccde845f880e3434',81,1,'gold','[]',0,'2022-11-01 20:28:29','2022-11-01 20:28:29','2023-11-01 22:28:29'),('8e78551e73f865ea1c271c76071807ff13c3b6d7ff57db4e697b87ce774f2601deb97baf77d6ee1f',9,1,'mazraa','[]',0,'2022-10-01 08:05:53','2022-10-01 08:05:53','2023-10-01 10:05:53'),('9055f6b0889575b337050cf6225c9962b58103e49e3fa8318dd21ecc035096e349635f3244530936',11,1,'mazraa','[]',0,'2022-06-23 08:02:30','2022-06-23 08:02:30','2023-06-23 10:02:30'),('925e38b9d03cfe5972a7b3a561ad2efb8f4bbc06b45bbaa9edc463b15d3a346595ed5dc78a7a72c2',11,1,'mazraa','[]',0,'2022-06-23 08:08:51','2022-06-23 08:08:51','2023-06-23 10:08:51'),('93b8472b0caee54e59f8d598cfe14eec41ee9638660743a04d5a346254a8c2a0b20b21a7114632ad',73,1,'mazraa','[]',0,'2022-09-28 08:51:05','2022-09-28 08:51:05','2023-09-28 10:51:05'),('93e567dd0a05e4cc2beeb23ae850484417870bb3bc63e7a57fc1a4dd7d5d125efef4bf1d708139d3',73,1,'mazraa','[]',0,'2022-11-17 08:06:18','2022-11-17 08:06:18','2023-11-17 10:06:18'),('94c7e6c34dbdc3cdbde7b925a2aa316f62036669e502c7291e2f006c4901b9ba57f307769dab3d7f',73,1,'mazraa','[]',0,'2022-11-02 18:31:27','2022-11-02 18:31:27','2023-11-02 20:31:27'),('998e75263735514f4059610e920e70cde29ecb7d6a2582abded01e73effbd69edc594bbbe28e9b20',11,1,'mazraa','[]',0,'2022-06-23 08:07:08','2022-06-23 08:07:08','2023-06-23 10:07:08'),('9ad209624a2cb471234b0850be0b9c2623f89c179b30388242edb9de2881d610cf1062bef2c33723',84,1,'mazraa','[]',0,'2022-11-20 15:10:45','2022-11-20 15:10:45','2023-11-20 17:10:45'),('a0d0cf3535a263ddab982cb9118f80f3a837d282aa4f4939ba2f3261695594a990037d683172111d',70,1,'mazraa','[]',0,'2022-07-06 06:25:06','2022-07-06 06:25:06','2023-07-06 08:25:06'),('a1e503e99f87232da95fbbcd5e29239ccbf7bdecdb03959c653b8fb7e9a5daee5251e0b4fc3a09fe',73,1,'mazraa','[]',0,'2022-11-17 06:03:30','2022-11-17 06:03:30','2023-11-17 08:03:30'),('a1eaeb7c2959c5045cfddb94dd7278f9252f44970d33611605fb0fd15811c2f910a539791762d50a',75,1,'mazraa','[]',0,'2022-09-29 06:09:54','2022-09-29 06:09:54','2023-09-29 08:09:54'),('a4cb306ad634b75250675fd285a0245668d0890c9a2794a88aa2e874677a1cfb01526a5a481dcc58',3,1,'mazraa','[]',0,'2022-06-23 07:55:37','2022-06-23 07:55:37','2023-06-23 09:55:37'),('a4edbd59fab369be0cb4a5d68f9185e8ffe12497e2d12c165df82d3c60981959602e2c0369e196ac',73,1,'mazraa','[]',0,'2022-09-28 08:50:48','2022-09-28 08:50:48','2023-09-28 10:50:48'),('a650a032af8729b9c5ee17577673d42666b50d917b97b3ac1de31b9b05ed788bf69891c861ac3d79',11,1,'mazraa','[]',0,'2022-06-23 07:56:19','2022-06-23 07:56:19','2023-06-23 09:56:19'),('a70ca0b1d3f5de3fe7cd5914b080f51b6cf634832e7cbc065fd677a99bd15460fa44e734fe53c258',73,1,'mazraa','[]',0,'2022-09-28 09:00:24','2022-09-28 09:00:24','2023-09-28 11:00:24'),('a8643d88c8107bc2d157babdbcfa80d405f5d3a489c44a7a7d2dcf4286e618ce1db38e4fe3989aca',7,1,'mazraa','[]',0,'2022-06-22 10:16:25','2022-06-22 10:16:25','2023-06-22 12:16:25'),('aa3813e78585961696de9a0026ac29fae342197e0fbf6759d62b7a558e60e9d288d28c4d0c872db8',11,1,'mazraa','[]',0,'2022-06-23 08:06:35','2022-06-23 08:06:35','2023-06-23 10:06:35'),('ab94419973969f3e986c784ff61a6ae13d912c03ffae54200c181479959171440c65506fb92b7a6d',73,1,'mazraa','[]',0,'2022-11-01 09:26:37','2022-11-01 09:26:37','2023-11-01 11:26:37'),('ac63b8e84ef3f091f4f8f4fa197469b7a9f3abd8a1b089d12b2c0b09adcba7a80065f36b087d809b',11,1,'mazraa','[]',0,'2022-06-23 08:01:42','2022-06-23 08:01:42','2023-06-23 10:01:42'),('ae2ba51e641e817c6cdee5c9e487500e18fabbbd900c2729af7683c09a23e609f7564179aa7ddbdf',71,1,'mazraa','[]',0,'2022-07-06 11:18:27','2022-07-06 11:18:27','2023-07-06 13:18:27'),('af4062d25f56d77176fe742e1db752be427bc43c5c74e39e4b3b9444b665a32fe143c2a469b5508b',9,1,'mazraa','[]',0,'2022-07-06 08:51:33','2022-07-06 08:51:33','2023-07-06 10:51:33'),('b066eaadde1521d31cc682c79e408f104187cefd123fc5e2b17a602692ab1230018d54393b62258e',73,1,'mazraa','[]',0,'2022-11-02 09:51:21','2022-11-02 09:51:21','2023-11-02 11:51:21'),('b14ad02331fdedcee3282c92d6f8487096272774042c0979a90d3c03116b3efd1c40c870cbd01c45',73,1,'mazraa','[]',0,'2022-09-28 08:58:45','2022-09-28 08:58:45','2023-09-28 10:58:45'),('b1e9f3eba1662b40f712bd7c3d10fea9d22b2237680408281562c1eb44cd8d69df28720febffbef9',73,1,'mazraa','[]',0,'2022-11-17 08:26:16','2022-11-17 08:26:16','2023-11-17 10:26:16'),('b248b659639e91061bfa335192ebe479da9d57b34e61daa6f17dae20d89ed02d9728d81ea0b45003',81,1,'gold','[]',0,'2022-10-29 08:32:41','2022-10-29 08:32:41','2023-10-29 10:32:41'),('b573d65f6c4d83563b87a176f5bb74d3743b27b6f14bce449b53012a802dd950325d06ce4e245910',79,1,'gold','[]',0,'2022-10-29 07:27:11','2022-10-29 07:27:11','2023-10-29 09:27:11'),('b65012ab78117f099861c87999ead30118c00ea781182ed629c2ee232799b6fff7c31dcfae9b83e7',71,1,'mazraa','[]',0,'2022-07-06 11:21:12','2022-07-06 11:21:12','2023-07-06 13:21:12'),('b90aa5f9976175cf954f33471bd2d6574e386fe96ab762b3758365e1deeb742ab66ff3b5448af5b5',83,1,'mazraa','[]',0,'2022-11-20 14:23:47','2022-11-20 14:23:47','2023-11-20 16:23:47'),('bac476380657dbb46523454aa70b573ee350b02951e5161ce6a57775056f115f29ced520c7579235',11,1,'mazraa','[]',0,'2022-06-23 08:07:23','2022-06-23 08:07:23','2023-06-23 10:07:23'),('bb99ba908dd2ef3682e9de5d0ea0c8b9a5a8c03bb45cea645862d284bfbbfee1469d3cf423788ae4',67,1,'mazraa','[]',0,'2022-07-04 17:23:29','2022-07-04 17:23:29','2023-07-04 19:23:29'),('c1af6ffc9cf5899344ffede1da64d2a02bc8634c4662e821b69bb8dab4d65e5217dd7a16579ebfe4',45,1,'mazraa','[]',0,'2022-06-23 09:54:03','2022-06-23 09:54:03','2023-06-23 11:54:03'),('c1d0fc8b4dae690d5d41591b9e0f160b4ed2019decaa13a2ab5f2d9dda0a9c8604720806a316e829',82,1,'gold','[]',0,'2022-12-03 07:38:27','2022-12-03 07:38:27','2023-12-03 09:38:27'),('c29a2fdf3669b565d06ee21c98fc33dbfb928ff2707d86ab7b3eea7763503636319bf1c4f745fd85',73,1,'mazraa','[]',0,'2022-09-28 09:16:33','2022-09-28 09:16:33','2023-09-28 11:16:33'),('c306b3ab9820786f4a45d721b60c793e1761decc466968e29163fd51fd9c33e7d5d5c06e0cb845fc',11,1,'mazraa','[]',0,'2022-06-23 08:08:28','2022-06-23 08:08:28','2023-06-23 10:08:28'),('c39dcd129536be45cf366e4462b403a8b9ce32976c1c2826c3c2f09971e18583c2db0799c853bc64',73,1,'mazraa','[]',0,'2022-09-28 09:11:06','2022-09-28 09:11:06','2023-09-28 11:11:06'),('c45345434033191329580dfbfecf1e536b5d9fbe7d6d6a7c581f2ac19ddd906d452ba8c504a43bb8',81,1,'gold','[]',0,'2022-10-29 08:32:12','2022-10-29 08:32:12','2023-10-29 10:32:12'),('c6203778f676e7fe8f869b36e44abc7742b8a4c902174318f91d8229b1444b21a64f5c294b8ede45',43,1,'mazraa','[]',0,'2022-06-23 09:32:02','2022-06-23 09:32:02','2023-06-23 11:32:02'),('c745ea2b478a8e6e1a3f4f98704588e62fc2c474bd85b657bf0fd0d0396a339c6bdd302fb43d9ffe',45,1,'mazraa','[]',0,'2022-06-23 09:53:38','2022-06-23 09:53:38','2023-06-23 11:53:38'),('c75d29ed3b0eba10a06d78863649ee94f563f6a0bf2f88c234e31de66aa2f6df149b66091348e035',80,1,'gold','[]',0,'2022-10-29 08:21:10','2022-10-29 08:21:10','2023-10-29 10:21:10'),('c864b06debe184181dca878781117bb627824bc4aa4f665ba881c39d4e2c7a04f1eb7eab6e9a89c2',82,1,'gold','[]',0,'2022-11-20 04:42:41','2022-11-20 04:42:41','2023-11-20 06:42:41'),('c94e0cda760f56009d930a67a211c2e6c541309bcac17c669cd9962df57b5935dc96679ceaab49a1',45,1,'mazraa','[]',0,'2022-06-23 10:19:13','2022-06-23 10:19:13','2023-06-23 12:19:13'),('c9b84b73b57c06e3ddde37884294919d5198bc889a5d479af297185d027151e2b3055433737705e0',85,1,'mazraa','[]',0,'2022-12-14 11:56:53','2022-12-14 11:56:53','2023-12-14 13:56:53'),('c9b8739b8b5f3c69cc8fa9e95a94d585cbb349d22ffb7335711424bbe9156266c9010ebf84c50820',68,1,'mazraa','[]',0,'2022-07-05 10:29:38','2022-07-05 10:29:38','2023-07-05 12:29:38'),('cd64e651c08ff0c5a95506fd60375e345b0701d528b62d7a27154ffbbd6590481eb86933853f249b',45,1,'mazraa','[]',0,'2022-06-23 09:53:57','2022-06-23 09:53:57','2023-06-23 11:53:57'),('d396a7b8a3c43fee303f2b74dabbc735a606bfd4af45dbae24bed92e679249b441b285566acac7b8',69,1,'mazraa','[]',0,'2022-07-05 12:54:28','2022-07-05 12:54:28','2023-07-05 14:54:28'),('d4d76218b21ce411430759fb34ce4da25ff71f307fafc1ec4bdee918f6ca28d4b8d5919e0d15ca15',72,1,'mazraa','[]',0,'2022-09-24 08:51:59','2022-09-24 08:51:59','2023-09-24 10:51:59'),('d5dd49ae370106426c6e51aede4cdaaa376c442ddba0b4e6211a809d9ef08ff8805660af17452fff',73,1,'mazraa','[]',0,'2022-11-18 09:21:40','2022-11-18 09:21:40','2023-11-18 11:21:40'),('d812332341ad6dc81303fead0a64f08310e604afceca6ac57773a1c2035015b18eaf1b96ebf81848',71,1,'mazraa','[]',0,'2022-07-06 11:15:59','2022-07-06 11:15:59','2023-07-06 13:15:59'),('d9ce270f5bf143663d61a6518cd9539046c26f6620a3aa4668129a023cdc4583cdcea94f582c8405',11,1,'mazraa','[]',0,'2022-06-23 08:09:16','2022-06-23 08:09:16','2023-06-23 10:09:16'),('d9daeefdd92b0a61d8f63f487cde78df3ac66b4616cb6a3cd32d1af03c214115724274f877a98362',73,1,'mazraa','[]',0,'2022-09-28 09:24:56','2022-09-28 09:24:56','2023-09-28 11:24:56'),('dc34256fe5a0a439db8d728d9c57d48f114509ac982141fdaa4567083cb56d3fc860ca6d599f09c5',73,1,'mazraa','[]',0,'2022-09-29 11:04:36','2022-09-29 11:04:36','2023-09-29 13:04:36'),('dc8768117c5ab1447884bf8ce98e01ea0813573fb55e76dae05eaff9d25f10caefb02bd6da3879cd',73,1,'mazraa','[]',0,'2022-10-01 07:41:20','2022-10-01 07:41:20','2023-10-01 09:41:20'),('dcc26ef7b6dd08734a2e1eb58b3f96241d0a5915e65d532efdf31df8668d3ad830c21f8f8e65ef57',79,1,'gold','[]',0,'2022-10-29 07:50:49','2022-10-29 07:50:49','2023-10-29 09:50:49'),('df5d5df84d6dd8eb9762b76ba3045c571a7cadc4d047f5757c06207705151f4e4271780952e8cd6f',82,1,'gold','[]',0,'2022-11-20 04:43:30','2022-11-20 04:43:30','2023-11-20 06:43:30'),('dfb242d38fd3831116c7a8d0a55294d564f3ada060b08a89fc0a1d563abfc93f004497a41eb87bc7',73,1,'mazraa','[]',0,'2022-11-17 08:37:30','2022-11-17 08:37:30','2023-11-17 10:37:30'),('e1c69633ccc5b393d34bf613be8b82bafd923f98864f350ecca69d9ce9f3f5ca4369f68b5298932e',11,1,'mazraa','[]',0,'2022-06-23 08:03:49','2022-06-23 08:03:49','2023-06-23 10:03:49'),('e296aa8088924eed2fd7199d0f9ef336322b542a594c940811692e1db655fd48fc0e53b7dacf2d3b',73,1,'mazraa','[]',0,'2022-11-01 07:24:23','2022-11-01 07:24:23','2023-11-01 09:24:23'),('e323ea6ce0c789996e91d0b39f61a3591f8040fd9510768e68a83e86040984348442a42df047c3e9',11,1,'mazraa','[]',0,'2022-06-23 08:06:59','2022-06-23 08:06:59','2023-06-23 10:06:59'),('e46d7989bccd9f96ab410f92536d38738f995688e274ade2cff5193a0da265212771c443886d7eda',81,1,'gold','[]',0,'2022-10-29 08:50:07','2022-10-29 08:50:07','2023-10-29 10:50:07'),('e4b6820dadd332def4afb6dab79dfe284adfb47f6e1843090e696a52a28ac33588d3e133782bc780',73,1,'mazraa','[]',0,'2022-11-01 18:45:22','2022-11-01 18:45:22','2023-11-01 20:45:22'),('e529d6207dc548be2d9826efc94c8fef42fc6d93b1d5479543d0f54a04ac5cb7baa3ef58974d7fc2',43,1,'mazraa','[]',0,'2022-06-23 09:31:32','2022-06-23 09:31:32','2023-06-23 11:31:32'),('e54ddfff1688ce8bce303c9b75b9527e800e798f1b28a442bf74bd1f2faf32dca8775db6e7bc8c26',11,1,'mazraa','[]',0,'2022-06-23 08:02:49','2022-06-23 08:02:49','2023-06-23 10:02:49'),('e681093ff41aba08c04c36994f73e4381c074da2440cfdddcae28bd13a5cc805a018408d087c10af',9,1,'mazraa','[]',0,'2022-06-22 10:17:54','2022-06-22 10:17:54','2023-06-22 12:17:54'),('e6be750fa3896fdbb264773e389ed60eb8af1b5d31683d4d7ea18f93f20ceb55ff1ed4c089ec9b55',43,1,'mazraa','[]',0,'2022-06-23 09:50:56','2022-06-23 09:50:56','2023-06-23 11:50:56'),('e886fc503c555caa58d35bfe0f5927092f82104a7ffd9da9c8bb366402bcb056847f826ea8017a0a',44,1,'mazraa','[]',0,'2022-06-23 09:39:52','2022-06-23 09:39:52','2023-06-23 11:39:52'),('e9a0ad4ff61e8ef2e69d324865724ea8273f6a1416091d8ab4229422dd2aacb70cfee7962dc75e03',15,1,'mazraa','[]',0,'2022-06-23 08:14:41','2022-06-23 08:14:41','2023-06-23 10:14:41'),('eb9b51402c35738b51892d30a6d8f3b086553bc26f3023fe1d452ae8882985c1d33c267a4d2b30c0',59,1,'mazraa','[]',0,'2022-06-27 07:58:28','2022-06-27 07:58:28','2023-06-27 09:58:28'),('eba79678bf6013d904fc46cc18c50522d553733079abf52711ffb716fee7b463e8e1b99f3cdd237a',11,1,'mazraa','[]',0,'2022-06-23 08:07:45','2022-06-23 08:07:45','2023-06-23 10:07:45'),('ec7b2d8e3fc7cea65ed5c403d89e11fe1e9778866a10237625f7478eb1a713354fbb75528c941e14',73,1,'mazraa','[]',0,'2022-10-01 15:53:14','2022-10-01 15:53:14','2023-10-01 17:53:14'),('f0f33ed03ac8b99e195c5dc8b014af222e6b03ea81dda424872808374c13fd139f87af3642877d10',9,1,'mazraa','[]',0,'2022-06-22 10:17:35','2022-06-22 10:17:35','2023-06-22 12:17:35'),('f13159781d519375c450b6ceb8f5d897bf3e904611fe6898618efa91863695737ebd51f83e4290bd',73,1,'mazraa','[]',0,'2022-09-29 05:44:59','2022-09-29 05:44:59','2023-09-29 07:44:59'),('f1609eaa7aa93a02fc58d503a391f09ecbd2a2f8af64997fbb9e1aeb9b8cbe27a9fbda38e00bcb8d',73,1,'mazraa','[]',0,'2022-11-17 08:05:07','2022-11-17 08:05:07','2023-11-17 10:05:07'),('f23884be8aa22475ade170b6f827ce05b645e91ff01ae5816ec59e42ad6f84cae172dcccd2df3658',73,1,'mazraa','[]',0,'2022-11-17 08:10:29','2022-11-17 08:10:29','2023-11-17 10:10:29'),('f61c3f4b2425707e03e623992647b69a8dbc2a1aa23c29e15f7c2eb72c50592979f558a8c5ef6933',81,1,'gold','[]',0,'2022-10-30 08:04:54','2022-10-30 08:04:54','2023-10-30 10:04:54'),('f6428351e9b7ecfb7653245e36f3205631a64d2b8a59768865c2d885cfe427e447d91a809a7e2a53',71,1,'mazraa','[]',0,'2022-07-06 11:15:24','2022-07-06 11:15:24','2023-07-06 13:15:24'),('f6836a6ba1026909923019dd6cf36e2c214f0e61a19f0644d6023d3dc6b585d4193b157ee4f7cfcd',9,1,'mazraa','[]',0,'2022-10-01 08:15:48','2022-10-01 08:15:48','2023-10-01 10:15:48'),('f78a37d8dbe9d97b86926d468a4e6c9a41a163b8f78406372e6445092a7c589fce30981086712728',66,1,'mazraa','[]',0,'2022-07-03 10:43:49','2022-07-03 10:43:49','2023-07-03 12:43:49'),('f8ec4c9b8bbfd78ede685e057605340d9153970263d7b7f00c9ee5144e787c4acf8a007e94be9fa1',19,1,'mazraa','[]',0,'2022-06-23 08:25:52','2022-06-23 08:25:52','2023-06-23 10:25:52'),('f99ca1c83a6d8c0600e49a8d93f6b2b86ce5ce4743e1c4a4725678d86309bb455045de563c232212',73,1,'mazraa','[]',0,'2022-09-28 11:38:53','2022-09-28 11:38:53','2023-09-28 13:38:53'),('fbfb3b219cb472a775c711b0a845809c84c118fe7896db058c34582fda377441a4b15a9b90fec674',73,1,'mazraa','[]',0,'2022-10-25 19:02:54','2022-10-25 19:02:54','2023-10-25 21:02:54'),('fcb2a51eeb54991cd82e76b57dd200b1ee37ec5c22d9c883da8137df34a51a01544b3b7bd08c7d36',27,1,'mazraa','[]',0,'2022-06-23 08:41:40','2022-06-23 08:41:40','2023-06-23 10:41:40'),('ff3a2dac6d7d57efc124c4300bfbb0abcb93a429e822535531b0aef4e3ea4cab0d9941f220db4b60',71,1,'mazraa','[]',0,'2022-07-06 11:18:53','2022-07-06 11:18:53','2023-07-06 13:18:53'),('fff47bc64a4c08865be4963f84bb7c6d4e835056f7b98e5d6673fb511f4b2526e0822a26723c5edc',73,1,'mazraa','[]',0,'2022-10-01 17:10:06','2022-10-01 17:10:06','2023-10-01 19:10:06');

--
-- Table structure for table `oauth_auth_codes`
--

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `client_id` bigint unsigned NOT NULL,
  `scopes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_auth_codes_user_id_index` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_auth_codes`
--


--
-- Table structure for table `oauth_clients`
--

CREATE TABLE `oauth_clients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `user_id` bigint unsigned DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `secret` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `provider` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `redirect` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `personal_access_client` tinyint(1) NOT NULL,
  `password_client` tinyint(1) NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_clients_user_id_index` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_clients`
--

INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `provider`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES (1,NULL,'Laravel Personal Access Client','M5hKJeOymQ5ybOqGLb1ZHeZwAvggkkcZi4jSuwrX',NULL,'http://localhost',1,0,0,'2022-06-22 10:12:48','2022-06-22 10:12:48'),(2,NULL,'Laravel Password Grant Client','oiElx9TLRlbGMJYB07DzGeD7GcN1SQMxbg24HbDa','users','http://localhost',0,1,0,'2022-06-22 10:12:48','2022-06-22 10:12:48');

--
-- Table structure for table `oauth_personal_access_clients`
--

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `client_id` bigint unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_personal_access_clients`
--

INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES (1,1,'2022-06-22 10:12:48','2022-06-22 10:12:48');

--
-- Table structure for table `oauth_refresh_tokens`
--

CREATE TABLE `oauth_refresh_tokens` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `access_token_id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `oauth_refresh_tokens`
--


--
-- Table structure for table `order_comments`
--

CREATE TABLE `order_comments` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int unsigned NOT NULL,
  `rate` int NOT NULL DEFAULT '1',
  `comment` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_comments_order_id_foreign` (`order_id`),
  CONSTRAINT `order_comments_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_comments`
--


--
-- Table structure for table `order_coupons`
--

CREATE TABLE `order_coupons` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int unsigned NOT NULL,
  `price` double NOT NULL,
  `discountprice` double NOT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `coupons_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_coupons_order_id_foreign` (`order_id`),
  KEY `order_coupons_coupons_id_foreign` (`coupons_id`),
  CONSTRAINT `order_coupons_coupons_id_foreign` FOREIGN KEY (`coupons_id`) REFERENCES `coupons` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_coupons_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_coupons`
--


--
-- Table structure for table `order_options`
--

CREATE TABLE `order_options` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int unsigned DEFAULT NULL,
  `product_order_id` int unsigned DEFAULT NULL,
  `Logo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Logo_frontName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Logo_backName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `font_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `font_image_frontName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `font_image_backName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `Logo_second` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Logo_frontName_second` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Logo_backName_second` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `font_image_second` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `font_image_frontName_second` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `font_image_backName_second` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_options_order_id_foreign` (`order_id`),
  KEY `order_options_product_order_id_foreign` (`product_order_id`),
  CONSTRAINT `order_options_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_options_product_order_id_foreign` FOREIGN KEY (`product_order_id`) REFERENCES `product_orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_options`
--

INSERT INTO `order_options` (`id`, `order_id`, `product_order_id`, `Logo`, `Logo_frontName`, `Logo_backName`, `font_image`, `font_image_frontName`, `font_image_backName`, `created_at`, `updated_at`, `Logo_second`, `Logo_frontName_second`, `Logo_backName_second`, `font_image_second`, `font_image_frontName_second`, `font_image_backName_second`) VALUES (1,3,3,NULL,NULL,NULL,NULL,NULL,NULL,'2022-12-12 21:23:56','2022-12-12 21:23:56',NULL,NULL,NULL,NULL,NULL,NULL),(3,6,7,'260','null','null',NULL,'null','null','2022-12-13 20:48:48','2022-12-13 20:48:48',NULL,NULL,NULL,NULL,NULL,NULL),(12,11,21,'null','انور','شحاتة',NULL,'null','null','2022-12-14 12:14:34','2022-12-14 12:14:34',NULL,NULL,NULL,NULL,NULL,NULL),(13,12,23,'null','انس','انور',NULL,'null','null','2022-12-14 12:27:21','2022-12-14 12:27:21',NULL,NULL,NULL,NULL,NULL,NULL),(14,13,25,'null','null','null','181','الله','اكبر','2022-12-14 12:30:15','2022-12-14 12:30:15',NULL,NULL,NULL,NULL,NULL,NULL),(15,14,27,'null','trwy','rty',NULL,'null','null','2022-12-14 13:03:37','2022-12-14 13:03:37',NULL,NULL,NULL,NULL,NULL,NULL),(16,17,31,'null','hbbbv','hhvv',NULL,'null','null','2022-12-15 05:32:39','2022-12-15 05:32:39',NULL,NULL,NULL,NULL,NULL,NULL),(17,18,33,'191',NULL,NULL,NULL,NULL,NULL,'2022-12-15 07:08:24','2022-12-15 07:08:24','210',NULL,NULL,NULL,NULL,NULL),(18,18,34,'193',NULL,NULL,NULL,NULL,NULL,'2022-12-15 07:09:02','2022-12-15 07:09:02','212',NULL,NULL,NULL,NULL,NULL),(21,20,37,'null',NULL,NULL,NULL,NULL,NULL,'2022-12-15 08:44:18','2022-12-15 08:44:18',NULL,NULL,NULL,NULL,NULL,NULL),(22,21,38,'null',NULL,NULL,'369','احمد','علي','2022-12-15 08:46:42','2022-12-15 08:46:42',NULL,NULL,NULL,NULL,NULL,NULL),(30,24,49,'null','xfgch','fghf',NULL,NULL,NULL,'2022-12-16 09:45:04','2022-12-16 09:45:04',NULL,NULL,NULL,NULL,NULL,NULL),(31,25,51,'319',NULL,NULL,NULL,NULL,NULL,'2022-12-16 21:07:18','2022-12-16 21:07:18',NULL,NULL,NULL,NULL,NULL,NULL),(32,26,53,'374',NULL,NULL,NULL,NULL,NULL,'2022-12-17 05:42:14','2022-12-17 05:42:14',NULL,NULL,NULL,NULL,NULL,NULL),(35,22,56,'348',NULL,NULL,NULL,NULL,NULL,'2022-12-17 06:30:27','2022-12-17 06:30:27',NULL,NULL,NULL,NULL,NULL,NULL),(36,27,57,'347',NULL,NULL,NULL,NULL,NULL,'2022-12-17 06:34:16','2022-12-17 06:34:16',NULL,NULL,NULL,NULL,NULL,NULL),(37,27,58,'null','محمد','هادي',NULL,NULL,NULL,'2022-12-17 06:34:35','2022-12-17 06:34:35',NULL,NULL,NULL,NULL,NULL,NULL),(38,28,59,'null','حامد','حامد',NULL,NULL,NULL,'2022-12-17 06:36:53','2022-12-17 06:36:53',NULL,NULL,NULL,NULL,NULL,NULL),(39,28,60,'null','منصور','منصور',NULL,NULL,NULL,'2022-12-17 06:43:17','2022-12-17 06:43:17',NULL,NULL,NULL,NULL,NULL,NULL),(40,28,61,'347',NULL,NULL,NULL,NULL,NULL,'2022-12-17 06:44:21','2022-12-17 06:44:21',NULL,NULL,NULL,NULL,NULL,NULL),(41,29,62,'null',NULL,NULL,'524','احمد','احمد','2022-12-18 07:23:57','2022-12-18 07:23:57',NULL,NULL,NULL,NULL,NULL,NULL),(42,30,64,'590',NULL,NULL,NULL,NULL,NULL,'2022-12-21 07:16:20','2022-12-21 07:16:20',NULL,NULL,NULL,NULL,NULL,NULL),(43,31,66,NULL,NULL,NULL,NULL,NULL,NULL,'2022-12-21 07:30:30','2022-12-21 07:30:30',NULL,NULL,NULL,NULL,NULL,NULL),(44,29,68,'512',NULL,NULL,NULL,NULL,NULL,'2022-12-21 08:34:09','2022-12-21 08:34:09',NULL,NULL,NULL,NULL,NULL,NULL),(46,34,73,'543',NULL,NULL,NULL,NULL,NULL,'2022-12-22 07:55:02','2022-12-22 07:55:02',NULL,NULL,NULL,NULL,NULL,NULL),(47,34,74,'542',NULL,NULL,NULL,NULL,NULL,'2022-12-22 07:55:14','2022-12-22 07:55:14',NULL,NULL,NULL,NULL,NULL,NULL),(49,35,76,'null','null','null','491','نمر','محمد','2022-12-28 12:50:24','2022-12-28 12:50:24',NULL,NULL,NULL,NULL,NULL,NULL),(50,37,78,'477',NULL,NULL,NULL,NULL,NULL,'2023-01-02 19:30:11','2023-01-02 19:30:11',NULL,NULL,NULL,NULL,NULL,NULL),(52,39,81,'null',NULL,NULL,'604','علي','ناصر','2023-01-03 05:44:41','2023-01-03 05:44:41',NULL,NULL,NULL,NULL,NULL,NULL),(53,40,82,NULL,NULL,NULL,'569','محمد','ناصلر','2023-01-03 06:22:04','2023-01-03 06:22:04',NULL,NULL,NULL,NULL,NULL,NULL),(54,44,86,'1','asd','sadasd','asd','asdasd','asdasd','2023-01-08 11:39:33','2023-01-08 11:39:33',NULL,NULL,NULL,NULL,NULL,NULL),(55,45,87,'477',NULL,NULL,NULL,NULL,NULL,'2023-01-11 10:22:48','2023-01-11 10:22:48',NULL,NULL,NULL,NULL,NULL,NULL),(56,47,90,'477',NULL,NULL,NULL,NULL,NULL,'2023-01-11 18:46:26','2023-01-11 18:46:26',NULL,NULL,NULL,NULL,NULL,NULL),(57,49,92,NULL,NULL,NULL,NULL,NULL,NULL,'2023-01-12 06:10:06','2023-01-12 06:10:06',NULL,NULL,NULL,NULL,NULL,NULL),(58,52,95,'477',NULL,NULL,NULL,NULL,NULL,'2023-01-14 08:36:05','2023-01-14 08:36:05',NULL,NULL,NULL,NULL,NULL,NULL),(59,54,98,'964',NULL,NULL,NULL,NULL,NULL,'2023-01-15 12:40:02','2023-01-15 12:40:02',NULL,NULL,NULL,NULL,NULL,NULL),(60,57,102,'542',NULL,NULL,NULL,NULL,NULL,'2023-01-16 06:01:57','2023-01-16 06:01:57',NULL,NULL,NULL,NULL,NULL,NULL),(61,57,104,'1015',NULL,NULL,NULL,NULL,NULL,'2023-01-16 06:27:01','2023-01-16 06:27:01',NULL,NULL,NULL,NULL,NULL,NULL),(62,59,105,'981',NULL,NULL,NULL,NULL,NULL,'2023-01-16 10:39:44','2023-01-16 10:39:44',NULL,NULL,NULL,NULL,NULL,NULL),(63,61,107,'1085',NULL,NULL,NULL,NULL,NULL,'2023-01-17 07:01:32','2023-01-17 07:01:32',NULL,NULL,NULL,NULL,NULL,NULL),(64,65,111,'613',NULL,NULL,NULL,NULL,NULL,'2023-01-17 12:01:35','2023-01-17 12:01:35',NULL,NULL,NULL,NULL,NULL,NULL),(65,66,114,NULL,NULL,NULL,NULL,NULL,NULL,'2023-01-19 05:59:40','2023-01-19 05:59:40',NULL,NULL,NULL,NULL,NULL,NULL),(66,71,122,NULL,NULL,NULL,NULL,NULL,NULL,'2023-01-21 05:54:53','2023-01-21 05:54:53',NULL,NULL,NULL,NULL,NULL,NULL),(67,73,125,NULL,NULL,NULL,NULL,NULL,NULL,'2023-01-21 06:22:47','2023-01-21 06:22:47',NULL,NULL,NULL,NULL,NULL,NULL),(68,78,134,'1015',NULL,NULL,NULL,NULL,NULL,'2023-01-24 05:02:44','2023-01-24 05:02:44',NULL,NULL,NULL,NULL,NULL,NULL),(70,80,137,'null',NULL,NULL,'1083','محمد','محمد','2023-01-29 21:44:20','2023-01-29 21:44:20',NULL,NULL,NULL,NULL,NULL,NULL),(71,81,138,NULL,NULL,NULL,NULL,NULL,NULL,'2023-01-30 11:29:39','2023-01-30 11:29:39',NULL,NULL,NULL,NULL,NULL,NULL),(72,82,139,NULL,NULL,NULL,NULL,NULL,NULL,'2023-02-02 22:21:42','2023-02-02 22:21:42',NULL,NULL,NULL,NULL,NULL,NULL),(73,83,140,'1073',NULL,NULL,NULL,NULL,NULL,'2023-02-05 11:52:03','2023-02-05 11:52:03',NULL,NULL,NULL,NULL,NULL,NULL),(74,84,141,'null',NULL,NULL,'1133','مم','راشد','2023-02-05 18:14:01','2023-02-05 18:14:01',NULL,NULL,NULL,NULL,NULL,NULL),(75,85,142,'null',NULL,NULL,'596','تساساتيتست','نبنبنب','2023-02-06 05:56:42','2023-02-06 05:56:42',NULL,NULL,NULL,NULL,NULL,NULL),(76,88,146,NULL,NULL,NULL,NULL,NULL,NULL,'2023-02-10 16:06:04','2023-02-10 16:06:04',NULL,NULL,NULL,NULL,NULL,NULL),(77,90,148,'477',NULL,NULL,NULL,NULL,NULL,'2023-02-11 10:51:51','2023-02-11 10:51:51',NULL,NULL,NULL,NULL,NULL,NULL),(79,94,152,NULL,NULL,NULL,NULL,NULL,NULL,'2023-02-15 10:08:16','2023-02-15 10:08:16',NULL,NULL,NULL,NULL,NULL,NULL),(80,95,153,NULL,NULL,NULL,NULL,NULL,NULL,'2023-02-15 10:28:55','2023-02-15 10:28:55',NULL,NULL,NULL,NULL,NULL,NULL),(81,55,156,'479',NULL,NULL,NULL,NULL,NULL,'2023-03-04 09:53:27','2023-03-04 09:53:27',NULL,NULL,NULL,NULL,NULL,NULL),(84,99,159,NULL,NULL,NULL,NULL,NULL,NULL,'2023-03-05 08:29:38','2023-03-05 08:29:38',NULL,NULL,NULL,NULL,NULL,NULL),(85,101,161,NULL,NULL,NULL,NULL,NULL,NULL,'2023-03-05 08:33:36','2023-03-05 08:33:36',NULL,NULL,NULL,NULL,NULL,NULL),(87,103,163,'528',NULL,NULL,NULL,NULL,NULL,'2023-03-06 13:55:14','2023-03-06 13:55:14',NULL,NULL,NULL,NULL,NULL,NULL),(89,105,165,NULL,NULL,NULL,NULL,'ali','li','2023-03-06 14:26:35','2023-03-06 14:26:35',NULL,NULL,NULL,NULL,NULL,NULL),(90,106,167,NULL,NULL,NULL,'548','asd',NULL,'2023-03-07 07:16:30','2023-03-07 07:16:30',NULL,NULL,NULL,NULL,NULL,NULL),(91,110,172,'1076',NULL,NULL,NULL,NULL,NULL,'2023-04-01 20:02:48','2023-04-01 20:02:48',NULL,NULL,NULL,NULL,NULL,NULL),(92,110,173,'1095',NULL,NULL,NULL,NULL,NULL,'2023-04-01 20:03:33','2023-04-01 20:03:33',NULL,NULL,NULL,NULL,NULL,NULL),(93,113,176,NULL,NULL,NULL,NULL,NULL,NULL,'2023-04-07 16:44:07','2023-04-07 16:44:07',NULL,NULL,NULL,NULL,NULL,NULL),(94,113,177,NULL,NULL,NULL,NULL,NULL,NULL,'2023-04-07 16:54:10','2023-04-07 16:54:10',NULL,NULL,NULL,NULL,NULL,NULL),(95,114,178,'504',NULL,NULL,'510','asd','asd','2023-04-11 14:03:57','2023-04-11 14:03:57',NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `order_product_features`
--

CREATE TABLE `order_product_features` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `order_product_id` int unsigned NOT NULL,
  `feature_id` int unsigned NOT NULL,
  `option_id` int unsigned NOT NULL,
  `product_id` int unsigned DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` double(8,2) DEFAULT NULL,
  `count` int DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_product_features_order_product_id_foreign` (`order_product_id`),
  KEY `order_product_features_feature_id_foreign` (`feature_id`),
  KEY `order_product_features_option_id_foreign` (`option_id`),
  KEY `order_product_features_product_id_foreign` (`product_id`),
  CONSTRAINT `order_product_features_feature_id_foreign` FOREIGN KEY (`feature_id`) REFERENCES `features` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_product_features_option_id_foreign` FOREIGN KEY (`option_id`) REFERENCES `feature_options` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_product_features_order_product_id_foreign` FOREIGN KEY (`order_product_id`) REFERENCES `product_orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `order_product_features_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_product_features`
--


--
-- Table structure for table `order_shippings`
--

CREATE TABLE `order_shippings` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int unsigned NOT NULL,
  `country_id` int DEFAULT NULL,
  `government_id` int unsigned DEFAULT NULL,
  `region_id` int unsigned DEFAULT NULL,
  `block` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gada` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `jada` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `building` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `floor` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `room_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `lat` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `long` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `secondphone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `civil_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(111) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `order_shippings_order_id_foreign` (`order_id`),
  KEY `order_shippings_government_id_foreign` (`government_id`),
  KEY `order_shippings_region_id_foreign` (`region_id`),
  CONSTRAINT `order_shippings_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `order_shippings`
--

INSERT INTO `order_shippings` (`id`, `order_id`, `country_id`, `government_id`, `region_id`, `block`, `gada`, `jada`, `building`, `floor`, `room_number`, `created_at`, `updated_at`, `lat`, `long`, `phone`, `secondphone`, `civil_id`, `email`, `name`, `address`) VALUES (1,1,1,8,20,'1221','123','123123',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'510007138','123123',NULL,'sadasdas@gmail.com','samer',NULL),(2,1,NULL,9,52,'21','12','12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'51007138',NULL,NULL,'asdasd@gmail.com','asdasd',NULL),(3,2,NULL,9,52,'sdad','asdsad','asdasd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'51007138',NULL,NULL,'asdasds@mail.com','sadadas',NULL),(4,3,NULL,9,52,'sdad','asdsad','asdasd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'51007138',NULL,NULL,'asdasds@mail.com','sadadas',NULL),(5,4,NULL,9,52,'sdad','asdsad','asdasd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'51007138',NULL,NULL,'asdasds@mail.com','sadadas',NULL),(6,8,NULL,10,84,'fgfgfg','المنصورة','fgggggggggdf','dfffffffffq','dfffffffff',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'admin@admin.com','amir_nageh',NULL),(7,9,NULL,10,84,'fgfgfg','المنصورة','fgggggggggdf','dfffffffffq','dfffffffff',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'admin@admin.com','amir_nageh',NULL),(8,9,NULL,10,84,'fgfgfg','المنصورة','fgggggggggdf','dfffffffffq','dfffffffff',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'admin@admin.com','amir_nageh',NULL),(9,6,NULL,9,52,'sdad','asdsad','asdasd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'51007138',NULL,NULL,'asdasds@mail.com','sadadas',NULL),(10,13,2,14,52,'sdad','asdsad','asdasd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'51007138',NULL,NULL,'asdasds@mail.com','sadadas',NULL),(11,13,2,14,52,'sdad','asdsad','asdasd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'51007138',NULL,NULL,'asdasds@mail.com','sadadas',NULL),(12,13,2,14,52,'sdad','asdsad','asdasd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'51007138',NULL,NULL,'asdasds@mail.com','sadadas',NULL),(13,13,2,14,52,'sdad','asdsad','asdasd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'51007138',NULL,NULL,'asdasds@mail.com','sadadas',NULL),(14,13,2,14,52,'sdad','asdsad','asdasd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'51007138',NULL,NULL,'asdasds@mail.com','sadadas',NULL),(15,13,2,14,52,'sdad','asdsad','asdasd',NULL,NULL,NULL,NULL,NULL,NULL,NULL,'51007138',NULL,NULL,'asdasds@mail.com','sadadas',NULL);

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

CREATE TABLE `orders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `order_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `total_price` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int unsigned DEFAULT NULL,
  `incart` tinyint(1) NOT NULL DEFAULT '1',
  `mac_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price_ship` double(8,2) DEFAULT NULL,
  `shipping_Type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `delivery_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order_done_date` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('wait','refused','accepted','shipped','complete') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_method` int unsigned DEFAULT NULL,
  `payment_status` enum('paid','unPaid') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `delivery_date_time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `payment_id` int DEFAULT NULL,
  `nameOfCart` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_code` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `orders_user_id_foreign` (`user_id`),
  KEY `orders_payment_method_foreign` (`payment_method`),
  CONSTRAINT `orders_payment_method_foreign` FOREIGN KEY (`payment_method`) REFERENCES `payment_methods` (`id`) ON DELETE CASCADE,
  CONSTRAINT `orders_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `orders` (`id`, `order_number`, `total_price`, `user_id`, `incart`, `mac_address`, `price_ship`, `shipping_Type`, `delivery_time`, `order_done_date`, `status`, `payment_method`, `payment_status`, `deleted_at`, `created_at`, `updated_at`, `delivery_date_time`, `payment_id`, `nameOfCart`, `country_code`, `country_id`) VALUES (1,'6522','44.000',1,0,'FGIVY63LF73yDGB0LRkzs8Nc88f9xzFKZvxVYdr1',1.00,NULL,NULL,'2024-02-19 19:24:31','complete',1,'',NULL,'2024-02-19 18:59:10','2024-02-21 18:30:09',NULL,NULL,NULL,'KWD',NULL),(2,'92088','44.000',1,0,'hvUffXqe5i5rb6P001VrnUxJkZankUrPc0wBYvG2',1.00,NULL,'2024-02-28','2024-02-21 18:50:58','wait',1,'',NULL,'2024-02-21 16:09:20','2024-02-21 18:50:58','07:00 PM-03:00 PM',NULL,NULL,'KWD',NULL),(3,'66697','22.000',1,0,'hvUffXqe5i5rb6P001VrnUxJkZankUrPc0wBYvG2',1.00,NULL,NULL,'2024-02-21 19:18:23','wait',1,'',NULL,'2024-02-21 19:18:11','2024-02-21 19:18:23',NULL,NULL,NULL,'KWD',NULL),(4,'96107','22.000',1,0,'hvUffXqe5i5rb6P001VrnUxJkZankUrPc0wBYvG2',1.00,NULL,NULL,'2024-02-21 19:25:19','wait',1,'',NULL,'2024-02-21 19:22:44','2024-02-21 19:25:19',NULL,NULL,NULL,'KWD',NULL),(5,'21277',NULL,NULL,1,'h3Dp7ym7aC8TtVYBL2ucg1di0GDntHhe53PkE05Q',NULL,'',NULL,NULL,'wait',NULL,'paid',NULL,'2024-02-21 19:28:13','2024-02-21 19:28:20',NULL,NULL,NULL,'KWD',NULL),(6,'6755','91.000',1,0,'hvUffXqe5i5rb6P001VrnUxJkZankUrPc0wBYvG2',1.00,NULL,NULL,'2024-02-24 10:06:56','wait',1,'',NULL,'2024-02-22 21:15:00','2024-02-24 10:06:56',NULL,NULL,NULL,'KWD',NULL),(7,'85757',NULL,NULL,1,'P5pVTk9p5u7wmXlfzxtfbGC4soH9T2LtQk03t9pb',NULL,'',NULL,NULL,'wait',NULL,'paid',NULL,'2024-02-22 21:15:09','2024-02-22 21:15:13',NULL,NULL,NULL,'KWD',NULL),(8,'60712','66',NULL,0,'MiQ5eF6mE1dfnpgwq7JG4nud9dStgNGKYw9pi03x',1.00,NULL,'2024-02-27','2024-02-22 22:55:58','wait',1,'',NULL,'2024-02-22 22:16:18','2024-02-22 22:55:58','07:00 PM-03:00 PM',NULL,NULL,'KWD',NULL),(9,'98008','110',NULL,0,'MiQ5eF6mE1dfnpgwq7JG4nud9dStgNGKYw9pi03x',1.00,NULL,'2024-02-25','2024-02-22 23:09:22','wait',1,'',NULL,'2024-02-22 23:06:25','2024-02-22 23:09:22','07:00 PM-03:00 PM',NULL,NULL,'KWD',NULL),(10,'81745',NULL,NULL,1,'9LGK2Qk2udgRp1LrbkvTTwPoQM71ocjhBYEzVpqx',NULL,'',NULL,NULL,'wait',NULL,'paid',NULL,'2024-02-23 07:02:07','2024-02-23 07:02:07',NULL,NULL,NULL,'KWD',NULL),(11,'90024',NULL,NULL,1,'xL0DwOjPmnGhTKCUSs6ShhblCTtRbUIEJoIIbIVh',NULL,'',NULL,NULL,'wait',NULL,'paid',NULL,'2024-02-24 10:12:33','2024-02-24 10:12:39',NULL,NULL,NULL,'KWD',NULL),(12,'249',NULL,NULL,1,'6LoQFBhrxKr58oQQeuOZkEzhP3l8byrSfERUQtfc',NULL,'',NULL,NULL,'wait',NULL,'paid',NULL,'2024-02-24 14:38:51','2024-02-24 14:55:54',NULL,NULL,NULL,'AED',NULL),(13,'1062','26.000',1,1,'hvUffXqe5i5rb6P001VrnUxJkZankUrPc0wBYvG2',1.00,NULL,NULL,'2024-03-09 20:58:05','wait',10,'unPaid',NULL,'2024-02-24 15:37:11','2024-03-09 20:58:05',NULL,NULL,NULL,'KWD',NULL),(14,'4088',NULL,NULL,1,'ZmAZG2nqWSxI7yktnG5hcyppHeyWd89f96wbP5E4',NULL,'',NULL,NULL,'wait',NULL,'paid',NULL,'2024-04-24 01:54:20','2024-04-24 01:54:24',NULL,NULL,NULL,'KWD',NULL);

--
-- Table structure for table `page_translations`
--

CREATE TABLE `page_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `page_id` int unsigned NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `page_translations_page_id_locale_unique` (`page_id`,`locale`),
  KEY `page_translations_locale_index` (`locale`),
  CONSTRAINT `page_translations_page_id_foreign` FOREIGN KEY (`page_id`) REFERENCES `pages` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `page_translations`
--

INSERT INTO `page_translations` (`id`, `page_id`, `title`, `locale`, `content`, `created_at`, `updated_at`) VALUES (1,1,'من نحن','ar','<p dir=\"rtl\">أجمل المسابيح في تطبيق واحد، هواة الخليج علامة تجارية مسجلة، ب خبرة واسعة في صناعة المشغولات اليدوية الحصرية بأفخم تشكيلات المسابيح الطبيعية و الصناعية و أحدثها بمختلف التصاميم العصرية و الكلاسيكية ؛ نقدمها لكم كتحف فنية ساحرة مع باقة من الخدمات المتكاملة تبدأ من سهولة التصفح و اختيار مسباحك المفضل و من ثم تعزيزه كهدية مثالية بأعلى المعايير في التعبئة و التغليف بأناقة متناهية مع خدمة متابعة الطلب و ما بعد البيع و ضمان الجودة ل نمنح تجربة للعملاء لا مثيل لها و أن نكون معكم عبر التطبيق الأمثل للهدايا و التذكارات التي تحتفي بكافة المناسبات.<br />\r\n&nbsp;<br />\r\nفمنكم نستلهم أفكارنا و إليكم نقدم أجمل منتجاتنا</p>',NULL,NULL),(2,1,'who are we','en','<p dir=\"rtl\">أجمل المسابيح في تطبيق واحد، هواة الخليج علامة تجارية مسجلة، ب خبرة واسعة في صناعة المشغولات اليدوية الحصرية بأفخم تشكيلات المسابيح الطبيعية و الصناعية و أحدثها بمختلف التصاميم العصرية و الكلاسيكية ؛ نقدمها لكم كتحف فنية ساحرة مع باقة من الخدمات المتكاملة تبدأ من سهولة التصفح و اختيار مسباحك المفضل و من ثم تعزيزه كهدية مثالية بأعلى المعايير في التعبئة و التغليف بأناقة متناهية مع خدمة متابعة الطلب و ما بعد البيع و ضمان الجودة ل نمنح تجربة للعملاء لا مثيل لها و أن نكون معكم عبر التطبيق الأمثل للهدايا و التذكارات التي تحتفي بكافة المناسبات.<br />\r\n&nbsp;<br />\r\nفمنكم نستلهم أفكارنا و إليكم نقدم أجمل منتجاتنا</p>',NULL,NULL),(3,2,'سياسة الاستبدال والاسترجاع','ar','<p dir=\"rtl\"><strong>سياسة الاستبدال والاسترجاع</strong> ( لعمليات الشراء اونلاين - من داخل الكويت )</p>\r\n\r\n<ul dir=\"rtl\">\r\n	<li><strong>مسابيح الكهرمان , المسابيح و الأحجار الطبيعية</strong><br />\r\n	مدة الاستبدال أو الاسترجاع المسموحة خلال 24 ساعة .</li>\r\n	<li><strong>المسابيح والخامات المُصنّعة</strong><br />\r\n	مدة الاستبدال أو الاسترجاع المسموحة خلال 3 أيام .</li>\r\n	<li><strong>رسوم التوصيل , عُمولة الدفع اونلاين</strong><br />\r\n	نتحمّل نحن رسوم التوصيل من وإلى العميل وعمولة الدفع اونلاين في حالة كان<br />\r\n	هناك أي اختلاف أو خــــطأ وارد في الطلب من قبلنا أمـــا غـــير ذلك فيتحمـــل<br />\r\n	العــــميل جميع رسوم التوصيل والدفع الالكتروني المُضافة .<br />\r\n	&nbsp;</li>\r\n	<li><strong>ملاحظات هامة</strong><br />\r\n	يُشترط عدم استخدام المنتج واعادته بتغليفه وحالته الأصلية .<br />\r\n	يُشترط ارفاق فاتورة الدفع و الشراء مع المنتج .<br />\r\n	المنتجات التي يتم التعديل عليها وتفصيلها حسب طلب العميل لا تسترد ولا تستبدل .<br />\r\n	تستغرق عملية اعادة الأموال أونلاين من 3 الى 7 أيام عمل<br />\r\n	&nbsp;</li>\r\n</ul>\r\n\r\n<hr />\r\n<p dir=\"rtl\"><br />\r\n<strong>سياسة الاستبدال والاسترجاع</strong> ( لعمليات الشراء اونلاين - من خارج الكويت )</p>\r\n\r\n<ul dir=\"rtl\">\r\n	<li><strong>مسابيح الكهرمان , المسابيح و الأحجار الطبيعية</strong><br />\r\n	مدة الاستبدال أو الاسترجاع المسموحة خلال 24 ساعة من تاريخ استلام الشحنة .</li>\r\n	<li><strong>المسابيح والخامات المُصنّعة</strong><br />\r\n	مدة الاستبدال أو الاسترجاع المسموحة خلال 3 أيام من تاريخ استلام الشحنة ..</li>\r\n	<li><strong>رسوم الشحن , الجمارك , عُمولة الدفع اونلاين</strong><br />\r\n	نتحمّل نحن رسوم الشحن من وإلى العميل وعمولةالدفع اونلاين في حالة كان<br />\r\n	هناك أي اختلاف أو خطأ وارد في الطلب من قبلنا, أمـا غير ذلك فيتحمل العـــــميل<br />\r\n	جميع رسوم الشحن والجمارك&nbsp; والدفع الالكتروني المُضافة .<br />\r\n	&nbsp;</li>\r\n	<li><strong>ملاحظات هامة</strong><br />\r\n	يُشترط عدم استخدام المنتج واعادته بتغليفه وحالته الأصلية .<br />\r\n	يُشترط ارفاق فاتورة الدفع و الشراء مع المنتج .<br />\r\n	المنتجات التي يتم التعديل عليها وتفصيلها حسب طلب العميل لا تسترد ولا تستبدل .<br />\r\n	تستغرق عملية اعادة الأموال أونلاين من 3 الى 7 أيام عمل</li>\r\n</ul>',NULL,NULL),(4,2,'sale policy','en','<p>sale policy</p>',NULL,NULL),(5,3,'الشروط والاحكام','ar','<p>جميع مواقعنا مبنية على قواعد بيانات مهنية للأرشفة من محركات البحث، حيث تكون مبنية وفق تسلل منطقي منظم، تجعل وصول المعلومات وطريقة عرضها أمر سهل وبسيط، كما تسهل عملية الأرشفة من محركات البحث مثل جوجل مما يجعل موقعك يظهر بشكل أفضل على محرك البحث جوجل</p>\r\n\r\n<p>جميع مواقعنا مبنية على قواعد بيانات مهنية للأرشفة من محركات البحث، حيث تكون مبنية وفق تسلل منطقي منظم، تجعل وصول المعلومات وطريقة عرضها أمر سهل وبسيط، كما تسهل عملية الأرشفة من محركات البحث مثل جوجل مما يجعل موقعك يظهر بشكل أفضل على محرك البحث جوجل</p>\r\n\r\n<p>جميع مواقعنا مبنية على قواعد بيانات مهنية للأرشفة من محركات البحث، حيث تكون مبنية وفق تسلل منطقي منظم، تجعل وصول المعلومات وطريقة عرضها أمر سهل وبسيط، كما تسهل عملية الأرشفة من محركات البحث مثل جوجل مما يجعل موقعك يظهر بشكل أفضل على محرك البحث جوجل</p>\r\n\r\n<p>جميع مواقعنا مبنية على قواعد بيانات مهنية للأرشفة من محركات البحث، حيث تكون مبنية وفق تسلل منطقي منظم، تجعل وصول المعلومات وطريقة عرضها أمر سهل وبسيط، كما تسهل عملية الأرشفة من محركات البحث مثل جوجل مما يجعل موقعك يظهر بشكل أفضل على محرك البحث جوجل</p>',NULL,NULL),(6,3,'Terms and Conditions','en','<p>جميع مواقعنا مبنية على قواعد بيانات مهنية للأرشفة من محركات البحث، حيث تكون مبنية وفق تسلل منطقي منظم، تجعل وصول المعلومات وطريقة عرضها أمر سهل وبسيط، كما تسهل عملية الأرشفة من محركات البحث مثل جوجل مما يجعل موقعك يظهر بشكل أفضل على محرك البحث جوجل</p>\r\n\r\n<p>جميع مواقعنا مبنية على قواعد بيانات مهنية للأرشفة من محركات البحث، حيث تكون مبنية وفق تسلل منطقي منظم، تجعل وصول المعلومات وطريقة عرضها أمر سهل وبسيط، كما تسهل عملية الأرشفة من محركات البحث مثل جوجل مما يجعل موقعك يظهر بشكل أفضل على محرك البحث جوجل</p>\r\n\r\n<p>جميع مواقعنا مبنية على قواعد بيانات مهنية للأرشفة من محركات البحث، حيث تكون مبنية وفق تسلل منطقي منظم، تجعل وصول المعلومات وطريقة عرضها أمر سهل وبسيط، كما تسهل عملية الأرشفة من محركات البحث مثل جوجل مما يجعل موقعك يظهر بشكل أفضل على محرك البحث جوجل</p>\r\n\r\n<p>جميع مواقعنا مبنية على قواعد بيانات مهنية للأرشفة من محركات البحث، حيث تكون مبنية وفق تسلل منطقي منظم، تجعل وصول المعلومات وطريقة عرضها أمر سهل وبسيط، كما تسهل عملية الأرشفة من محركات البحث مثل جوجل مما يجعل موقعك يظهر بشكل أفضل على محرك البحث جوجل</p>',NULL,NULL),(7,4,'عبد الله','ar','<p style=\"text-align:center\">شغل رائع وتعامل أروع منتجات مميزة<br />\r\nوجودة عالية صراحة مشكوورين</p>',NULL,NULL),(8,4,'عبد الله','en','<p style=\"text-align:center\">شغل رائع وتعامل أروع منتجات مميزة<br />\r\nوجودة عالية صراحة مشكوورين</p>',NULL,NULL),(9,5,'Bo Hmood','ar','<p style=\"text-align:center\">جربت الطلب من عندكم<br />\r\nأنصح بهذا الموقع خدمة ممتازة</p>',NULL,NULL),(10,5,'Bo Hmood','en','<p style=\"text-align:center\">جربت الطلب من عندكم<br />\r\nأنصح بهذا الموقع خدمة ممتازة</p>',NULL,NULL),(11,6,'نواف الظفيري','ar','<p style=\"text-align:center\">خووش موقع وفقم الله ورزقكم<br />\r\nومو آخر مرة ان شاء الله اطلب منكم</p>',NULL,NULL),(12,6,'نواف الظفيري','en','<p style=\"text-align:center\">خووش موقع وفقم الله ورزقكم<br />\r\nومو آخر مرة ان شاء الله اطلب منكم</p>',NULL,NULL);

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `image` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` (`id`, `created_at`, `updated_at`, `image`, `type`) VALUES (1,'2022-06-28 09:49:28','2022-06-29 05:53:36','2022-06-29-farm.docx',0),(2,'2022-11-03 11:42:33','2022-11-03 11:42:33',NULL,0),(3,'2022-11-03 11:43:26','2022-11-03 11:43:26',NULL,0),(4,'2022-12-13 07:05:37','2022-12-13 07:05:37',NULL,1),(5,'2022-12-13 08:38:46','2022-12-13 08:38:46','2022-12-13-RYHL1-1.jpg',1),(6,'2022-12-13 09:19:54','2022-12-13 09:19:54',NULL,1);

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--


--
-- Table structure for table `payment_method_translations`
--

CREATE TABLE `payment_method_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `payment_method_id` int unsigned NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `payment_method_translations_payment_method_id_locale_unique` (`payment_method_id`,`locale`),
  CONSTRAINT `payment_method_translations_payment_method_id_foreign` FOREIGN KEY (`payment_method_id`) REFERENCES `payment_methods` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_method_translations`
--

INSERT INTO `payment_method_translations` (`id`, `payment_method_id`, `title`, `locale`, `created_at`, `updated_at`) VALUES (1,1,'الدفع عند الاستلام','ar',NULL,NULL),(2,1,'الدفع عند الاستلام','en',NULL,NULL),(3,2,'كي نت','ar',NULL,NULL),(4,2,'كي نت','en',NULL,NULL),(19,10,'فيزا/Visa','ar',NULL,NULL),(20,10,'Visa','en',NULL,NULL);

--
-- Table structure for table `payment_methods`
--

CREATE TABLE `payment_methods` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `payment_methods`
--

INSERT INTO `payment_methods` (`id`, `image`, `type`, `status`, `created_at`, `updated_at`) VALUES (1,'2022-07-02-payment.png',0,1,'2022-06-22 10:19:52','2022-12-06 13:23:32'),(2,'2022-07-02-drd_QbKb_400x400.jpg',1,1,'2022-06-22 10:20:09','2022-12-06 13:24:52'),(10,'2024-03-09-images (1).jpeg',2,1,'2024-03-09 20:57:38','2024-03-09 20:57:38');

--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `permission_id` bigint unsigned NOT NULL,
  `role_id` bigint unsigned NOT NULL,
  PRIMARY KEY (`permission_id`,`role_id`),
  KEY `permission_role_role_id_foreign` (`role_id`),
  CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_role`
--

INSERT INTO `permission_role` (`permission_id`, `role_id`) VALUES (1,1),(2,1),(3,1),(4,1),(5,1),(6,1),(7,1),(8,1),(9,1),(10,1),(11,1),(12,1),(13,1),(14,1),(15,1),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,1),(24,1),(25,1),(26,1),(27,1),(28,1),(29,1),(30,1),(31,1),(32,1),(33,1),(34,1),(35,1),(36,1),(37,1),(38,1),(39,1),(40,1),(41,1),(42,1),(43,1),(44,1),(45,1),(46,1),(47,1),(48,1),(49,1),(50,1),(51,1),(52,1),(53,1),(54,1),(55,1),(56,1),(57,1),(58,1),(59,1),(60,1),(61,1),(62,1),(63,1),(64,1),(21,6),(22,6);

--
-- Table structure for table `permission_user`
--

CREATE TABLE `permission_user` (
  `permission_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `user_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`user_id`,`permission_id`,`user_type`),
  KEY `permission_user_permission_id_foreign` (`permission_id`),
  CONSTRAINT `permission_user_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_user`
--


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

CREATE TABLE `permissions` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `permissions_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=65 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `permissions` (`id`, `name`, `display_name`, `description`, `created_at`, `updated_at`) VALUES (1,'create_users','Create Users','Create Users','2022-06-21 09:32:18','2022-06-21 09:32:18'),(2,'read_users','Read Users','Read Users','2022-06-21 09:32:18','2022-06-21 09:32:18'),(3,'update_users','Update Users','Update Users','2022-06-21 09:32:18','2022-06-21 09:32:18'),(4,'delete_users','Delete Users','Delete Users','2022-06-21 09:32:18','2022-06-21 09:32:18'),(5,'create_roles','Create Roles','Create Roles','2022-06-21 09:32:18','2022-06-21 09:32:18'),(6,'read_roles','Read Roles','Read Roles','2022-06-21 09:32:18','2022-06-21 09:32:18'),(7,'update_roles','Update Roles','Update Roles','2022-06-21 09:32:18','2022-06-21 09:32:18'),(8,'delete_roles','Delete Roles','Delete Roles','2022-06-21 09:32:18','2022-06-21 09:32:18'),(9,'create_notifications','Create Notifications','Create Notifications','2022-06-21 09:32:18','2022-06-21 09:32:18'),(10,'read_notifications','Read Notifications','Read Notifications','2022-06-21 09:32:18','2022-06-21 09:32:18'),(11,'update_notifications','Update Notifications','Update Notifications','2022-06-21 09:32:18','2022-06-21 09:32:18'),(12,'delete_notifications','Delete Notifications','Delete Notifications','2022-06-21 09:32:18','2022-06-21 09:32:18'),(13,'create_sliders','Create Sliders','Create Sliders','2022-06-21 09:32:18','2022-06-21 09:32:18'),(14,'read_sliders','Read Sliders','Read Sliders','2022-06-21 09:32:18','2022-06-21 09:32:18'),(15,'update_sliders','Update Sliders','Update Sliders','2022-06-21 09:32:18','2022-06-21 09:32:18'),(16,'delete_sliders','Delete Sliders','Delete Sliders','2022-06-21 09:32:18','2022-06-21 09:32:18'),(17,'create_settings','Create Settings','Create Settings','2022-06-21 09:32:18','2022-06-21 09:32:18'),(18,'read_settings','Read Settings','Read Settings','2022-06-21 09:32:18','2022-06-21 09:32:18'),(19,'update_settings','Update Settings','Update Settings','2022-06-21 09:32:18','2022-06-21 09:32:18'),(20,'delete_settings','Delete Settings','Delete Settings','2022-06-21 09:32:18','2022-06-21 09:32:18'),(21,'create_categories','Create Categories','Create Categories','2022-06-21 09:32:18','2022-06-21 09:32:18'),(22,'read_categories','Read Categories','Read Categories','2022-06-21 09:32:18','2022-06-21 09:32:18'),(23,'update_categories','Update Categories','Update Categories','2022-06-21 09:32:18','2022-06-21 09:32:18'),(24,'delete_categories','Delete Categories','Delete Categories','2022-06-21 09:32:18','2022-06-21 09:32:18'),(25,'create_products','Create Products','Create Products','2022-06-21 09:32:18','2022-06-21 09:32:18'),(26,'read_products','Read Products','Read Products','2022-06-21 09:32:18','2022-06-21 09:32:18'),(27,'update_products','Update Products','Update Products','2022-06-21 09:32:18','2022-06-21 09:32:18'),(28,'delete_products','Delete Products','Delete Products','2022-06-21 09:32:18','2022-06-21 09:32:18'),(29,'create_paymentMethods','Create PaymentMethods','Create PaymentMethods','2022-06-21 09:32:18','2022-06-21 09:32:18'),(30,'read_paymentMethods','Read PaymentMethods','Read PaymentMethods','2022-06-21 09:32:18','2022-06-21 09:32:18'),(31,'update_paymentMethods','Update PaymentMethods','Update PaymentMethods','2022-06-21 09:32:18','2022-06-21 09:32:18'),(32,'delete_paymentMethods','Delete PaymentMethods','Delete PaymentMethods','2022-06-21 09:32:18','2022-06-21 09:32:18'),(33,'create_shippingType','Create ShippingType','Create ShippingType','2022-06-21 09:32:18','2022-06-21 09:32:18'),(34,'read_shippingType','Read ShippingType','Read ShippingType','2022-06-21 09:32:18','2022-06-21 09:32:18'),(35,'update_shippingType','Update ShippingType','Update ShippingType','2022-06-21 09:32:18','2022-06-21 09:32:18'),(36,'delete_shippingType','Delete ShippingType','Delete ShippingType','2022-06-21 09:32:18','2022-06-21 09:32:18'),(37,'create_orders','Create Orders','Create Orders','2022-06-21 09:32:18','2022-06-21 09:32:18'),(38,'read_orders','Read Orders','Read Orders','2022-06-21 09:32:18','2022-06-21 09:32:18'),(39,'update_orders','Update Orders','Update Orders','2022-06-21 09:32:18','2022-06-21 09:32:18'),(40,'delete_orders','Delete Orders','Delete Orders','2022-06-21 09:32:18','2022-06-21 09:32:18'),(41,'create_reports','Create Reports','Create Reports','2022-06-21 09:32:18','2022-06-21 09:32:18'),(42,'read_reports','Read Reports','Read Reports','2022-06-21 09:32:18','2022-06-21 09:32:18'),(43,'update_reports','Update Reports','Update Reports','2022-06-21 09:32:18','2022-06-21 09:32:18'),(44,'delete_reports','Delete Reports','Delete Reports','2022-06-21 09:32:18','2022-06-21 09:32:18'),(45,'create_governments','Create Governments','Create Governments','2022-06-21 09:32:18','2022-06-21 09:32:18'),(46,'read_governments','Read Governments','Read Governments','2022-06-21 09:32:18','2022-06-21 09:32:18'),(47,'update_governments','Update Governments','Update Governments','2022-06-21 09:32:18','2022-06-21 09:32:18'),(48,'delete_governments','Delete Governments','Delete Governments','2022-06-21 09:32:18','2022-06-21 09:32:18'),(49,'create_regions','Create Regions','Create Regions','2022-06-21 09:32:18','2022-06-21 09:32:18'),(50,'read_regions','Read Regions','Read Regions','2022-06-21 09:32:18','2022-06-21 09:32:18'),(51,'update_regions','Update Regions','Update Regions','2022-06-21 09:32:18','2022-06-21 09:32:18'),(52,'delete_regions','Delete Regions','Delete Regions','2022-06-21 09:32:18','2022-06-21 09:32:18'),(53,'create_discount','Create Discount','Create Discount','2022-06-21 09:32:18','2022-06-21 09:32:18'),(54,'read_discount','Read Discount','Read Discount','2022-06-21 09:32:18','2022-06-21 09:32:18'),(55,'update_discount','Update Discount','Update Discount','2022-06-21 09:32:18','2022-06-21 09:32:18'),(56,'delete_discount','Delete Discount','Delete Discount','2022-06-21 09:32:18','2022-06-21 09:32:18'),(57,'create_times','Create Times','Create Times','2022-06-21 09:32:18','2022-06-21 09:32:18'),(58,'read_times','Read Times','Read Times','2022-06-21 09:32:18','2022-06-21 09:32:18'),(59,'update_times','Update Times','Update Times','2022-06-21 09:32:18','2022-06-21 09:32:18'),(60,'delete_times','Delete Times','Delete Times','2022-06-21 09:32:18','2022-06-21 09:32:18'),(61,'create_tagers','Create Tagers','Create Tagers','2022-06-21 09:32:18','2022-06-21 09:32:18'),(62,'read_tagers','Read Tagers','Read Tagers','2022-06-21 09:32:18','2022-06-21 09:32:18'),(63,'update_tagers','Update Tagers','Update Tagers','2022-06-21 09:32:18','2022-06-21 09:32:18'),(64,'delete_tagers','Delete Tagers','Delete Tagers','2022-06-21 09:32:18','2022-06-21 09:32:18');

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

CREATE TABLE `personal_access_tokens` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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


--
-- Table structure for table `product_categories`
--

CREATE TABLE `product_categories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int unsigned DEFAULT NULL,
  `category_id` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_categories_product_id_foreign` (`product_id`),
  KEY `product_categories_category_id_foreign` (`category_id`),
  CONSTRAINT `product_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_categories_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_categories`
--


--
-- Table structure for table `product_orders`
--

CREATE TABLE `product_orders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `order_id` int unsigned NOT NULL,
  `product_id` int unsigned NOT NULL,
  `user_id` int DEFAULT NULL,
  `quantity` int NOT NULL DEFAULT '1',
  `option` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` decimal(8,2) NOT NULL,
  `shipping_cost` decimal(8,2) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `category_id` int NOT NULL,
  `nameOfCart` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `real_price` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_orders_order_id_foreign` (`order_id`),
  KEY `product_orders_product_id_foreign` (`product_id`),
  CONSTRAINT `product_orders_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_orders_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_orders`
--

INSERT INTO `product_orders` (`id`, `order_id`, `product_id`, `user_id`, `quantity`, `option`, `price`, `shipping_cost`, `created_at`, `updated_at`, `category_id`, `nameOfCart`, `real_price`) VALUES (1,1,1,NULL,2,' ',22.00,NULL,'2024-02-19 19:04:40','2024-02-19 19:24:31',0,NULL,'22.00'),(2,2,1,NULL,2,' ',22.00,NULL,'2024-02-21 16:09:20','2024-02-21 18:50:58',0,NULL,'22.00'),(3,3,1,NULL,1,' ',22.00,NULL,'2024-02-21 19:18:11','2024-02-21 19:18:23',0,NULL,'22.00'),(4,4,1,NULL,1,' ',22.00,NULL,'2024-02-21 19:22:44','2024-02-21 19:25:19',0,NULL,'22.00'),(5,5,1,NULL,1,' ',22.00,NULL,'2024-02-21 19:28:13','2024-02-22 00:41:51',0,NULL,'22.00'),(6,6,1,NULL,7,' ',13.00,NULL,'2024-02-22 21:15:00','2024-02-24 10:06:56',0,NULL,'13.00'),(7,7,1,NULL,2,' ',22.00,NULL,'2024-02-22 21:15:09','2024-02-22 22:05:34',0,NULL,'22.00'),(8,8,1,NULL,3,' ',22.00,NULL,'2024-02-22 22:16:18','2024-02-22 22:55:58',0,NULL,'22.00'),(9,9,1,NULL,5,' ',22.00,NULL,'2024-02-22 23:06:25','2024-02-22 23:09:22',0,NULL,'22.00'),(10,10,1,NULL,2,' ',22.00,NULL,'2024-02-23 07:02:07','2024-02-23 07:02:35',0,NULL,'22.00'),(11,11,1,NULL,3,' ',13.00,NULL,'2024-02-24 10:12:33','2024-02-24 10:18:58',0,NULL,'13.00'),(12,12,1,NULL,2,' ',153.75,NULL,'2024-02-24 14:38:51','2024-02-24 15:52:56',0,NULL,'13.00'),(13,13,1,NULL,2,' ',13.00,NULL,'2024-02-24 15:37:11','2024-03-16 20:34:20',0,NULL,'13.00'),(14,14,1,NULL,1,' ',13.00,NULL,'2024-04-24 01:54:20','2024-04-24 01:54:46',0,NULL,'13.00');

--
-- Table structure for table `product_otherdatas`
--

CREATE TABLE `product_otherdatas` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int unsigned DEFAULT NULL,
  `input_key_ar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `input_value_ar` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `input_key_en` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `input_value_en` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_otherdatas_product_id_foreign` (`product_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_otherdatas`
--


--
-- Table structure for table `product_translations`
--

CREATE TABLE `product_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `content` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_keywords` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `product_translations_product_id_locale_unique` (`product_id`,`locale`),
  KEY `product_translations_locale_index` (`locale`),
  CONSTRAINT `product_translations_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_translations`
--

INSERT INTO `product_translations` (`id`, `product_id`, `name`, `content`, `meta_keywords`, `locale`, `created_at`, `updated_at`) VALUES (1,1,'الدليل الشامل لجمال منزلك','<p>الدليل الشامل لجمال منزلك</p>',NULL,'ar',NULL,NULL),(2,1,'الدليل الشامل لجمال منزلك','<p>الدليل الشامل لجمال منزلك</p>',NULL,'en',NULL,NULL);

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

CREATE TABLE `products` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_id` int unsigned DEFAULT NULL,
  `mainprice` decimal(8,2) NOT NULL DEFAULT '0.00',
  `discount` decimal(8,2) NOT NULL DEFAULT '0.00',
  `stoke` int NOT NULL DEFAULT '0',
  `option` enum('true','false') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('pending','reject','active') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'pending',
  `reason` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `checked` int NOT NULL DEFAULT '1',
  `knetPay` int NOT NULL DEFAULT '0',
  `arrivalTime` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Thread_options` int DEFAULT '0',
  `defualt_Thread_count` int DEFAULT '33',
  `news` int DEFAULT NULL,
  `checkWhatsapp` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `nameOfCart` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `defualt_Thread_count_showed` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `const` int NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `products_user_id_foreign` (`user_id`),
  CONSTRAINT `products_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `products` (`id`, `image`, `user_id`, `mainprice`, `discount`, `stoke`, `option`, `code`, `status`, `reason`, `deleted_at`, `created_at`, `updated_at`, `checked`, `knetPay`, `arrivalTime`, `Thread_options`, `defualt_Thread_count`, `news`, `checkWhatsapp`, `nameOfCart`, `defualt_Thread_count_showed`, `const`) VALUES (1,'2024-02-19-1.png',1,13.00,13.00,22,NULL,'-','active',NULL,NULL,'2024-02-19 18:54:06','2024-02-24 10:06:02',1,0,NULL,0,33,NULL,NULL,NULL,NULL,0);

--
-- Table structure for table `public_notifcations`
--

CREATE TABLE `public_notifcations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `data` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `public_notifcations_user_id_foreign` (`user_id`),
  CONSTRAINT `public_notifcations_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=52 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `public_notifcations`
--

INSERT INTO `public_notifcations` (`id`, `user_id`, `title`, `message`, `data`, `created_at`, `updated_at`) VALUES (26,1,'sfsdfsdf','dsfsf','{\"image\":\"https:\\/\\/mazraeati.com\\/storage\\/images\\/notifications\\/bBn2q7IF0vxSAzG6XtwhI9H5EZw1S4ZLxgSxBTLK.png\"}','2022-07-02 08:34:48','2022-07-02 08:34:48'),(27,1,'asdasd','asd','{\"image\":\"https:\\/\\/mazraeati.com\\/storage\\/images\\/notifications\\/uj3bvx488aDZkqu54WJil7vMLsNZLNFspPaR9zCM.png\"}','2022-07-13 09:10:39','2022-07-13 09:10:39'),(28,1,'asd','asd','{\"image\":null}','2022-12-06 10:29:46','2022-12-06 10:29:46'),(29,1,'asd','asd','{\"image\":null}','2022-12-06 10:30:03','2022-12-06 10:30:03'),(30,1,'asd','asd','{\"image\":null}','2022-12-06 10:30:13','2022-12-06 10:30:13'),(31,1,'hkljlkj','iojlkj','{\"image\":null}','2022-12-14 07:39:28','2022-12-14 07:39:28'),(32,1,'erwtrewtew','trwetrewt','{\"image\":null}','2022-12-14 07:41:33','2022-12-14 07:41:33'),(33,1,'asd','asdasda','{\"image\":null}','2022-12-14 07:42:18','2022-12-14 07:42:18'),(34,1,'rtey','retyte','{\"image\":null}','2022-12-14 12:19:00','2022-12-14 12:19:00'),(35,1,'ertrew','rweqrqw','{\"image\":null}','2022-12-14 12:19:30','2022-12-14 12:19:30'),(36,1,'ert','ewrterwt','{\"image\":null}','2022-12-14 12:19:43','2022-12-14 12:19:43'),(37,1,'yrtwyt','yertyer','{\"image\":null}','2022-12-15 05:31:13','2022-12-15 05:31:13'),(38,1,'yrtwyt','yertyer','{\"image\":null}','2022-12-15 05:31:14','2022-12-15 05:31:14'),(39,1,'ertrewt','rewtewtew','{\"image\":null}','2022-12-15 05:31:21','2022-12-15 05:31:21'),(40,1,'wertewr','werterwterwt','{\"image\":null}','2022-12-15 05:31:27','2022-12-15 05:31:27'),(41,1,'qerwterq','trewtqet','{\"image\":null}','2022-12-15 05:31:36','2022-12-15 05:31:36'),(42,1,'rtrewt','ewrterw','{\"image\":null}','2022-12-15 05:31:41','2022-12-15 05:31:41'),(43,1,'ewrt','erwterw','{\"image\":null}','2022-12-15 06:55:15','2022-12-15 06:55:15'),(44,1,'hgffjhgjh','ukyg','{\"image\":null}','2022-12-15 06:55:57','2022-12-15 06:55:57'),(45,1,'jklhlhj','kjg','{\"image\":null}','2022-12-15 06:59:34','2022-12-15 06:59:34'),(46,1,'wretr','trwetew','{\"image\":null}','2022-12-15 07:01:01','2022-12-15 07:01:01'),(47,1,'reter','erwtrewt','{\"image\":null}','2022-12-15 07:02:15','2022-12-15 07:02:15'),(48,1,'werterwt','ewrterw','{\"image\":null}','2022-12-15 07:02:25','2022-12-15 07:02:25'),(49,1,'ewqrtewqr','wqerewqrwq','{\"image\":null}','2022-12-15 07:06:00','2022-12-15 07:06:00'),(50,1,'qwerwq','q43rwe','{\"image\":null}','2022-12-15 07:06:09','2022-12-15 07:06:09'),(51,1,'weqrwq','weqr','{\"image\":null}','2022-12-15 07:37:57','2022-12-15 07:37:57');

--
-- Table structure for table `refund_products`
--

CREATE TABLE `refund_products` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `product_order_id` int unsigned DEFAULT NULL,
  `product_id` int unsigned DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `restore` int DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `refund_products_user_id_foreign` (`user_id`),
  KEY `refund_products_product_id_foreign` (`product_id`),
  KEY `refund_products_product_order_id_foreign` (`product_order_id`),
  CONSTRAINT `refund_products_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `refund_products_product_order_id_foreign` FOREIGN KEY (`product_order_id`) REFERENCES `product_orders` (`id`) ON DELETE CASCADE,
  CONSTRAINT `refund_products_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `refund_products`
--


--
-- Table structure for table `region_translations`
--

CREATE TABLE `region_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `region_id` int unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `arrival` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `region_translations_region_id_locale_unique` (`region_id`,`locale`),
  KEY `region_translations_locale_index` (`locale`)
) ENGINE=InnoDB AUTO_INCREMENT=303 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `region_translations`
--

INSERT INTO `region_translations` (`id`, `region_id`, `name`, `locale`, `created_at`, `updated_at`, `arrival`) VALUES (37,19,'مدينة الكويت','ar',NULL,NULL,'بعد ٢٤ ساعة'),(38,19,'kuwait City','en',NULL,NULL,'After 24 Hours'),(39,20,'دسمان','ar',NULL,NULL,'بعد ٢٤ ساعة'),(40,20,'Dasman','en',NULL,NULL,'After 24 Hours'),(41,21,'شرق','ar',NULL,NULL,'بعد ٢٤ ساعة'),(42,21,'Sharq','en',NULL,NULL,'After 24 Hours'),(43,22,'الصوابر','ar',NULL,NULL,'بعد ٢٤ ساعة'),(44,22,'Sawber','en',NULL,NULL,'After 24 Hours'),(45,23,'المرقاب','ar',NULL,NULL,'بعد ٢٤ ساعة'),(46,23,'Mirqab','en',NULL,NULL,'After 24 Hours'),(47,24,'القبلة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(48,24,'Qibla','en',NULL,NULL,'After 24 Hours'),(49,25,'الصالحية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(50,25,'Salhiya','en',NULL,NULL,'After 24 Hours'),(51,26,'الوطية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(52,26,'Watiya','en',NULL,NULL,'After 24 Hours'),(53,27,'بنيد القار','ar',NULL,NULL,'بعد ٢٤ ساعة'),(54,27,'Binid elgar','en',NULL,NULL,'After 24 Hours'),(55,28,'كيفان','ar',NULL,NULL,'بعد ٢٤ ساعة'),(56,28,'Kefan','en',NULL,NULL,'After 24 Hours'),(57,29,'الدوحة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(58,29,'Douha','en',NULL,NULL,'After 24 Hours'),(59,30,'الدسمة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(60,30,'Dasma','en',NULL,NULL,'After 24 Hours'),(61,31,'الدعية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(62,31,'Daiya','en',NULL,NULL,'After 24 Hours'),(63,32,'المنصورية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(64,32,'Mansoriya','en',NULL,NULL,'After 24 Hours'),(65,33,'ضاحية عبد الله السالم','ar',NULL,NULL,'بعد ٢٤ ساعة'),(66,33,'Abdulallah al-salem','en',NULL,NULL,'After 24 Hours'),(67,34,'النزهة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(68,34,'Nuzha','en',NULL,NULL,'After 24 Hours'),(69,35,'الفيحاء','ar',NULL,NULL,'بعد ٢٤ ساعة'),(70,35,'Fayha','en',NULL,NULL,'After 24 Hours'),(71,36,'الشامية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(72,36,'Shamiya','en',NULL,NULL,'After 24 Hours'),(73,37,'الروضة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(74,37,'Rowda','en',NULL,NULL,'After 24 Hours'),(75,38,'العديلية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(76,38,'Adileya','en',NULL,NULL,'After 24 Hours'),(77,39,'الخالدية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(78,39,'khaldiya','en',NULL,NULL,'After 24 Hours'),(79,40,'القادسية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(80,40,'Qadisya','en',NULL,NULL,'After 24 Hours'),(81,41,'قرطبة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(82,41,'Qurtoba','en',NULL,NULL,'After 24 Hours'),(83,42,'السرة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(84,42,'Sorra','en',NULL,NULL,'After 24 Hours'),(85,43,'اليرموك','ar',NULL,NULL,'بعد ٢٤ ساعة'),(86,43,'Yarmouk','en',NULL,NULL,'After 24 Hours'),(87,44,'الشويخ','ar',NULL,NULL,'بعد ٢٤ ساعة'),(88,44,'Shiwayakh','en',NULL,NULL,'After 24 Hours'),(89,45,'الري','ar',NULL,NULL,'بعد ٢٤ ساعة'),(90,45,'Alrai','en',NULL,NULL,'After 24 Hours'),(91,46,'غرناطة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(92,46,'Granada','en',NULL,NULL,'After 24 Hours'),(93,47,'الصليبيخات','ar',NULL,NULL,'بعد ٢٤ ساعة'),(94,47,'Sulibkhat','en',NULL,NULL,'After 24 Hours'),(95,48,'النهضة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(96,48,'Nahda','en',NULL,NULL,'After 24 Hours'),(97,49,'مدينة جابر الأحمد','ar',NULL,NULL,'بعد ٢٤ ساعة'),(98,49,'Jaber Al-ahmed city','en',NULL,NULL,'After 24 Hours'),(99,50,'القيروان','ar',NULL,NULL,'بعد ٢٤ ساعة'),(100,50,'Qairawan','en',NULL,NULL,'After 24 Hours'),(101,51,'شمال غرب الصليبيخات','ar',NULL,NULL,'بعد ٢٤ ساعة'),(102,51,'East Sulibkhat','en',NULL,NULL,'After 24 Hours'),(103,52,'الفنطاس','ar',NULL,NULL,'بعد ٢٤ ساعة'),(104,52,'Fintas','en',NULL,NULL,'After 24 Hours'),(105,53,'العقيلة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(106,53,'Eqaila','en',NULL,NULL,'After 24 Hours'),(107,54,'الظهر','ar',NULL,NULL,'بعد ٢٤ ساعة'),(108,54,'Zuhor','en',NULL,NULL,'After 24 Hours'),(109,55,'المقوع','ar',NULL,NULL,'بعد ٢٤ ساعة'),(110,55,'Moqwa','en',NULL,NULL,'After 24 Hours'),(111,56,'المهبولة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(112,56,'Mahbola','en',NULL,NULL,'After 24 Hours'),(113,57,'الرقة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(114,57,'Riqa','en',NULL,NULL,'After 24 Hours'),(115,58,'هدية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(116,58,'Hadiya','en',NULL,NULL,'After 24 Hours'),(117,59,'أبو حليفة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(118,59,'Abu helifa','en',NULL,NULL,'After 24 Hours'),(119,60,'الصباحية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(120,60,'Sabhiya','en',NULL,NULL,'After 24 Hours'),(121,61,'المنقف','ar',NULL,NULL,'بعد ٢٤ ساعة'),(122,61,'Manqaf','en',NULL,NULL,'After 24 Hours'),(123,62,'الفحيحيل','ar',NULL,NULL,'بعد ٢٤ ساعة'),(124,62,'Fahahel','en',NULL,NULL,'After 24 Hours'),(125,63,'الأحمدي','ar',NULL,NULL,'بعد ٢٤ ساعة'),(126,63,'Ahmadi','en',NULL,NULL,'After 24 Hours'),(127,64,'الوفرة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(128,64,'Wafra','en',NULL,NULL,'After 24 Hours'),(129,65,'الزور','ar',NULL,NULL,'بعد ٢٤ ساعة'),(130,65,'Zoor','en',NULL,NULL,'After 24 Hours'),(131,66,'الخيران','ar',NULL,NULL,'بعد ٢٤ ساعة'),(132,66,'Khiyran','en',NULL,NULL,'After 24 Hours'),(133,67,'ميناء عبد الله','ar',NULL,NULL,'بعد ٢٤ ساعة'),(134,67,'Menaa Abdulallah','en',NULL,NULL,'After 24 Hours'),(135,68,'الوفرة الزراعية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(136,68,'Wafra ziraeya','en',NULL,NULL,'After 24 Hours'),(137,69,'بنيدر','ar',NULL,NULL,'بعد ٢٤ ساعة'),(138,69,'Binder','en',NULL,NULL,'After 24 Hours'),(139,70,'الجليعة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(140,70,'Gelaya','en',NULL,NULL,'After 24 Hours'),(141,71,'الضباعية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(142,71,'Dabiya','en',NULL,NULL,'After 24 Hours'),(143,72,'ضاحية جابر العلي','ar',NULL,NULL,'بعد ٢٤ ساعة'),(144,72,'Jaber Al-ali','en',NULL,NULL,'بعد ٢٤ ساعة'),(145,73,'ضاحية فهد الأحمد','ar',NULL,NULL,'بعد ٢٤ ساعة'),(146,73,'Fahd Al-ahmed','en',NULL,NULL,'After 24 Hours'),(147,74,'الشعيبة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(148,74,'Sheeyba','en',NULL,NULL,'After 24 Hours'),(149,75,'واره','ar',NULL,NULL,'بعد ٢٤ ساعة'),(150,75,'Waaraa','en',NULL,NULL,'After 24 Hours'),(151,76,'مدينة صباح الأحمد','ar',NULL,NULL,'بعد ٢٤ ساعة'),(152,76,'Sobah Al-ahmed','en',NULL,NULL,'After 24 Hours'),(153,77,'النويصيب','ar',NULL,NULL,'بعد ٢٤ ساعة'),(154,77,'Nouyseb','en',NULL,NULL,'After 24 Hours'),(155,78,'مدينة الخيران','ar',NULL,NULL,'بعد ٢٤ ساعة'),(156,78,'Khiran City','en',NULL,NULL,'After 24 Hours'),(157,79,'ضاحية علي صباح السالم أم الهيمان سابقاً','ar',NULL,NULL,'بعد ٢٤ ساعة'),(158,79,'Ali Subah Al-salem','en',NULL,NULL,'After 24 Hours'),(159,80,'مدينة صباح الأحمد البحرية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(160,80,'Subah Al-ahmed bahrya','en',NULL,NULL,'After 24 Hours'),(161,81,'أبرق خيطان','ar',NULL,NULL,'بعد ٢٤ ساعة'),(162,81,'Abrq Khitan','en',NULL,NULL,'After 24 Hours'),(163,82,'الأندلس','ar',NULL,NULL,'بعد ٢٤ ساعة'),(164,82,'Andalus','en',NULL,NULL,'After 24 Hours'),(165,83,'اشبيلية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(166,83,'Ashbilya','en',NULL,NULL,'After 24 Hours'),(167,84,'جليب الشيوخ','ar',NULL,NULL,'بعد ٢٤ ساعة'),(168,84,'Jeleeb Al-shwikh','en',NULL,NULL,'After 24 Hours'),(169,85,'خيطان','ar',NULL,NULL,'بعد ٢٤ ساعة'),(170,85,'Khitan','en',NULL,NULL,'After 24 Hours'),(171,86,'خيطان الجديدة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(172,86,'New Khitan','en',NULL,NULL,'After 24 Hours'),(173,87,'العمرية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(174,87,'Omarya','en',NULL,NULL,'After 24 Hours'),(175,88,'العارضية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(176,88,'Ardiya','en',NULL,NULL,'After 24 Hours'),(177,89,'العارضية الصناعية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(178,89,'Ardiya Senaya','en',NULL,NULL,'After 24 Hours'),(179,90,'العباسية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(180,90,'Abasiya','en',NULL,NULL,'After 24 Hours'),(181,91,'الفردوس','ar',NULL,NULL,'بعد ٢٤ ساعة'),(182,91,'Fardaus','en',NULL,NULL,'After 24 Hours'),(183,92,'الفروانية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(184,92,'Farwaniya','en',NULL,NULL,'After 24 Hours'),(185,93,'الحساوي','ar',NULL,NULL,'بعد ٢٤ ساعة'),(186,93,'Hasawi','en',NULL,NULL,'After 24 Hours'),(187,94,'الشدادية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(188,94,'Shadadya','en',NULL,NULL,'After 24 Hours'),(189,95,'الرابية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(190,95,'Rabya','en',NULL,NULL,'After 24 Hours'),(191,96,'الرحاب','ar',NULL,NULL,'بعد ٢٤ ساعة'),(192,96,'Rehab','en',NULL,NULL,'After 24 Hours'),(193,97,'الرقعي','ar',NULL,NULL,'بعد ٢٤ ساعة'),(194,97,'Reqai','en',NULL,NULL,'After 24 Hours'),(195,98,'الري الصناعية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(196,98,'Al-rai senya','en',NULL,NULL,'After 24 Hours'),(197,99,'ضاحية صباح الناصر','ar',NULL,NULL,'بعد ٢٤ ساعة'),(198,99,'Sobah - Al-nasser','en',NULL,NULL,'After 24 Hours'),(199,100,'ضاحية عبد الله المبارك','ar',NULL,NULL,'بعد ٢٤ ساعة'),(200,100,'Abdulallh Mubarak','en',NULL,NULL,'After 24 Hours'),(201,101,'الضجيج','ar',NULL,NULL,'بعد ٢٤ ساعة'),(202,101,'Dagej','en',NULL,NULL,'After 24 Hours'),(203,102,'الصليبية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(204,102,'Salibiya','en',NULL,NULL,'After 24 Hours'),(205,103,'أمغرة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(206,103,'Amgra','en',NULL,NULL,'After 24 Hours'),(207,104,'النعيم','ar',NULL,NULL,'بعد ٢٤ ساعة'),(208,104,'Naeem','en',NULL,NULL,'After 24 Hours'),(209,105,'القصر','ar',NULL,NULL,'بعد ٢٤ ساعة'),(210,105,'Qasr','en',NULL,NULL,'After 24 Hours'),(211,106,'الواحة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(212,106,'Waha','en',NULL,NULL,'After 24 Hours'),(213,107,'تيماء','ar',NULL,NULL,'بعد ٢٤ ساعة'),(214,107,'Tayma','en',NULL,NULL,'After 24 Hours'),(215,108,'النسيم','ar',NULL,NULL,'بعد ٢٤ ساعة'),(216,108,'Nassem','en',NULL,NULL,'After 24 Hours'),(217,109,'العيون','ar',NULL,NULL,'بعد ٢٤ ساعة'),(218,109,'Eyoun','en',NULL,NULL,'After 24 Hours'),(219,110,'القيصرية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(220,110,'Qaysarya','en',NULL,NULL,'After 24 Hours'),(221,111,'العبدلي','ar',NULL,NULL,'بعد ٢٤ ساعة'),(222,111,'Abali','en',NULL,NULL,'After 24 Hours'),(223,112,'الجهراء القديمة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(224,112,'Old Jahra','en',NULL,NULL,'After 24 Hours'),(225,113,'الجهراء الجديدة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(226,113,'New jahra','en',NULL,NULL,'After 24 Hours'),(227,114,'كاظمة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(228,114,'Kazma','en',NULL,NULL,'After 24 Hours'),(229,115,'مدينة سعد العبد الله','ar',NULL,NULL,'بعد ٢٤ ساعة'),(230,115,'Saad - Al-abdullah','en',NULL,NULL,'After 24 Hours'),(231,116,'السالمي','ar',NULL,NULL,'بعد ٢٤ ساعة'),(232,116,'Alsalmi','en',NULL,NULL,'After 24 Hours'),(233,117,'المطلاع','ar',NULL,NULL,'بعد ٢٤ ساعة'),(234,117,'Metlah','en',NULL,NULL,'After 24 Hours'),(235,118,'مدينة الحرير','ar',NULL,NULL,'بعد ٢٤ ساعة'),(236,118,'Harir city','en',NULL,NULL,'After 24 Hours'),(237,119,'كبد','ar',NULL,NULL,'بعد ٢٤ ساعة'),(238,119,'Kabad','en',NULL,NULL,'After 24 Hours'),(239,120,'الروضتين','ar',NULL,NULL,'بعد ٢٤ ساعة'),(240,120,'Rawdaten','en',NULL,NULL,'After 24 Hours'),(241,121,'الصبية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(242,121,'Subya','en',NULL,NULL,'After 24 Hours'),(243,122,'حولي','ar',NULL,NULL,'بعد ٢٤ ساعة'),(244,122,'Hawalli','en',NULL,NULL,'After 24 Hours'),(245,123,'الشعب','ar',NULL,NULL,'بعد ٢٤ ساعة'),(246,123,'Shaab','en',NULL,NULL,'After 24 Hours'),(247,124,'السالمية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(248,124,'Salmya','en',NULL,NULL,'After 24 Hours'),(249,125,'الرميثية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(250,125,'Romythiya','en',NULL,NULL,'After 24 Hours'),(251,126,'الجابرية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(252,126,'Jabrya','en',NULL,NULL,'After 24 Hours'),(253,127,'مشرف','ar',NULL,NULL,'بعد ٢٤ ساعة'),(254,127,'Meshrif','en',NULL,NULL,'After 24 Hours'),(255,128,'بيان','ar',NULL,NULL,'بعد ٢٤ ساعة'),(256,128,'Bayan','en',NULL,NULL,'After 24 Hours'),(257,129,'آلبدع','ar',NULL,NULL,'بعد ٢٤ ساعة'),(258,129,'Albedaa','en',NULL,NULL,'After 24 Hours'),(259,130,'النقرة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(260,130,'Noqra','en',NULL,NULL,'After 24 Hours'),(261,131,'ميدان حولي','ar',NULL,NULL,'بعد ٢٤ ساعة'),(262,131,'Medaan Hawalli','en',NULL,NULL,'After 24 Hours'),(263,132,'ضاحية مبارك العبد الله الجابر','ar',NULL,NULL,'بعد ٢٤ ساعة'),(264,132,'Mubarak Al-adbullah Algaber','en',NULL,NULL,'After 24 Hours'),(265,133,'سلوى','ar',NULL,NULL,'بعد ٢٤ ساعة'),(266,133,'Salwa','en',NULL,NULL,'After 24 Hours'),(267,134,'جنوب السرة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(268,134,'Ganub Al-Surra','en',NULL,NULL,'After 24 Hours'),(269,135,'الزهراء','ar',NULL,NULL,'بعد ٢٤ ساعة'),(270,135,'Al-zahra','en',NULL,NULL,'After 24 Hours'),(271,136,'الصديق','ar',NULL,NULL,'بعد ٢٤ ساعة'),(272,136,'Sedeq','en',NULL,NULL,'After 24 Hours'),(273,137,'حطين','ar',NULL,NULL,'بعد ٢٤ ساعة'),(274,137,'Hiten','en',NULL,NULL,'After 24 Hours'),(275,138,'السلام','ar',NULL,NULL,'بعد ٢٤ ساعة'),(276,138,'Alsalam','en',NULL,NULL,'After 24 Hours'),(277,139,'الشهداء','ar',NULL,NULL,'بعد ٢٤ ساعة'),(278,139,'Showhada','en',NULL,NULL,'After 24 Hours'),(279,140,'العدان','ar',NULL,NULL,'بعد ٢٤ ساعة'),(280,140,'Adan','en',NULL,NULL,'After 24 Hours'),(281,141,'القصور','ar',NULL,NULL,'بعد ٢٤ ساعة'),(282,141,'Qusor','en',NULL,NULL,'After 24 Hours'),(283,142,'القرين','ar',NULL,NULL,'بعد ٢٤ ساعة'),(284,142,'Quren','en',NULL,NULL,'After 24 Hours'),(285,143,'ضاحية صباح السالم','ar',NULL,NULL,'بعد ٢٤ ساعة'),(286,143,'Subah Al-salem','en',NULL,NULL,'After 24 Hours'),(287,144,'المسيلة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(288,144,'Mesilya','en',NULL,NULL,'After 24 Hours'),(289,145,'المسايل','ar',NULL,NULL,'بعد ٢٤ ساعة'),(290,145,'Masayel','en',NULL,NULL,'After 24 Hours'),(291,146,'أبو فطيرة','ar',NULL,NULL,'بعد ٢٤ ساعة'),(292,146,'Abu fetra','en',NULL,NULL,'After 24 Hours'),(293,147,'أبو الحصانية','ar',NULL,NULL,'بعد ٢٤ ساعة'),(294,147,'Abu Alhusanya','en',NULL,NULL,'After 24 Hours'),(295,148,'صبحان','ar',NULL,NULL,'بعد ٢٤ ساعة'),(296,148,'Sabhan','en',NULL,NULL,'After 24 Hours'),(297,149,'الفنيطيس','ar',NULL,NULL,'بعد ٢٤ ساعة'),(298,149,'Fintes','en',NULL,NULL,'After 24 Hours'),(301,151,'ضاحيه مبارك الكبير','ar',NULL,NULL,'ضاحيه مبارك الكبير'),(302,151,'ضاحيه مبارك الكبير','en',NULL,NULL,'ضاحيه مبارك الكبير');

--
-- Table structure for table `regions`
--

CREATE TABLE `regions` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `status` tinyint(1) NOT NULL DEFAULT '1',
  `address_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address_latitude` double NOT NULL,
  `address_longitude` double NOT NULL,
  `governments_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `regions_governments_id_foreign` (`governments_id`)
) ENGINE=InnoDB AUTO_INCREMENT=152 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `regions`
--

INSERT INTO `regions` (`id`, `status`, `address_address`, `address_latitude`, `address_longitude`, `governments_id`, `created_at`, `updated_at`) VALUES (19,1,'مدينة الكويت',0,0,8,'2022-08-25 10:34:31','2022-08-25 10:34:31'),(20,1,'دسمان',0,0,8,'2022-08-25 10:36:00','2022-08-25 10:36:00'),(21,1,'شرق',0,0,8,'2022-08-25 10:36:31','2022-08-25 10:36:31'),(22,1,'الصوابر',0,0,8,'2022-08-25 10:41:53','2022-08-25 10:41:53'),(23,1,'المرقاب',0,0,8,'2022-08-25 10:42:29','2022-08-25 10:42:29'),(24,1,'القبلة',0,0,8,'2022-08-25 10:42:56','2022-08-25 10:42:56'),(25,1,'الصالحية',0,0,8,'2022-08-25 10:43:27','2022-08-25 10:43:27'),(26,1,'الوطية',0,0,8,'2022-08-25 10:43:58','2022-08-25 10:43:58'),(27,1,'بنيد القار',0,0,8,'2022-08-25 10:44:54','2022-08-25 10:44:54'),(28,1,'كيفان',0,0,8,'2022-08-25 10:45:21','2022-08-25 10:45:21'),(29,1,'الدوحة',0,0,8,'2022-08-25 10:46:27','2022-08-25 10:46:27'),(30,1,'الدسمة',0,0,8,'2022-08-25 10:46:52','2022-08-25 10:46:52'),(31,1,'الدعية',0,0,8,'2022-08-25 10:48:10','2022-08-25 10:48:10'),(32,1,'المنصورية',0,0,8,'2022-08-25 10:48:40','2022-08-25 10:48:40'),(33,1,'ضاحية عبد الله السالم',0,0,8,'2022-08-25 10:49:23','2022-08-25 10:49:23'),(34,1,'النزهة',0,0,8,'2022-08-25 10:49:56','2022-08-25 10:49:56'),(35,1,'الفيحاء',0,0,8,'2022-08-25 10:50:29','2022-08-25 10:50:29'),(36,1,'الشامية',0,0,8,'2022-08-25 10:51:07','2022-08-25 10:51:07'),(37,1,'الروضة',0,0,8,'2022-08-25 10:51:48','2022-08-25 10:51:48'),(38,1,'العديلية',0,0,8,'2022-08-25 10:52:21','2022-08-25 10:52:21'),(39,1,'الخالدية',0,0,8,'2022-08-25 10:53:18','2022-08-25 10:53:18'),(40,1,'القادسية',0,0,8,'2022-08-25 10:53:43','2022-08-25 10:53:43'),(41,1,'قرطبة',0,0,8,'2022-08-25 10:54:11','2022-08-25 10:54:11'),(42,1,'السرة',0,0,8,'2022-08-25 10:54:40','2022-08-25 10:54:40'),(43,1,'اليرموك',0,0,8,'2022-08-25 10:55:09','2022-08-25 10:55:09'),(44,1,'الشويخ',0,0,8,'2022-08-25 10:55:54','2022-08-25 10:55:54'),(45,1,'الري',0,0,8,'2022-08-25 10:56:14','2022-08-25 10:56:14'),(46,1,'غرناطة، Kuwait',29.312521,47.8785532,8,'2022-08-25 10:57:53','2022-08-25 10:57:53'),(47,1,'الصليبيخات',29.312521,47.8785532,8,'2022-08-25 10:59:18','2022-08-25 10:59:18'),(48,1,'النهضة',29.312521,47.8785532,8,'2022-08-25 10:59:50','2022-08-25 10:59:50'),(49,1,'مدينة جابر الأحمد',29.312521,47.8785532,8,'2022-08-25 11:00:29','2022-08-25 11:00:29'),(50,1,'القيروان',29.312521,47.8785532,8,'2022-08-25 11:01:01','2022-08-25 11:01:01'),(51,1,'شمال غرب الصليبيخات',29.312521,47.8785532,8,'2022-08-25 11:02:03','2022-08-25 11:02:03'),(52,1,'الفنطاس',29.312521,47.8785532,9,'2022-08-25 11:02:23','2022-08-25 11:02:23'),(53,1,'العقيلة',29.312521,47.8785532,9,'2022-08-25 11:02:49','2022-08-25 11:02:49'),(54,1,'الظهر',29.312521,47.8785532,9,'2022-08-25 11:03:15','2022-08-25 11:03:15'),(55,1,'المقوع',29.312521,47.8785532,9,'2022-08-25 11:03:52','2022-08-25 11:03:52'),(56,1,'المهبولة',29.312521,47.8785532,9,'2022-08-25 11:08:24','2022-08-25 11:08:24'),(57,1,'الرقة',29.312521,47.8785532,9,'2022-08-25 11:08:46','2022-08-25 11:08:46'),(58,1,'هدية',29.312521,47.8785532,9,'2022-08-25 11:09:06','2022-08-25 11:09:06'),(59,1,'أبو حليفة',29.312521,47.8785532,9,'2022-08-25 11:09:46','2022-08-25 11:09:46'),(60,1,'الصباحية',29.312521,47.8785532,9,'2022-08-25 11:10:14','2022-08-25 11:10:14'),(61,1,'المنقف',29.312521,47.8785532,9,'2022-08-25 11:10:44','2022-08-25 11:10:44'),(62,1,'الفحيحيل',29.312521,47.8785532,9,'2022-08-25 11:11:17','2022-08-25 11:11:17'),(63,1,'الأحمدي',29.312521,47.8785532,9,'2022-08-25 11:11:52','2022-08-25 11:11:52'),(64,1,'الوفرة',29.312521,47.8785532,9,'2022-08-25 11:12:12','2022-08-25 11:12:12'),(65,1,'الزور',29.312521,47.8785532,9,'2022-08-25 11:12:36','2022-08-25 11:12:36'),(66,1,'الخيران',29.312521,47.8785532,9,'2022-08-25 11:13:08','2022-08-25 11:13:08'),(67,1,'ميناء عبد الله',29.312521,47.8785532,9,'2022-08-25 11:13:55','2022-08-25 11:13:55'),(68,1,'الوفرة الزراعية',29.312521,47.8785532,9,'2022-08-25 11:14:28','2022-08-25 11:14:28'),(69,1,'بنيدر',29.312521,47.8785532,9,'2022-08-25 11:14:58','2022-08-25 11:14:58'),(70,1,'الجليعة',29.312521,47.8785532,9,'2022-08-25 11:15:37','2022-08-25 11:15:37'),(71,1,'الضباعية',29.312521,47.8785532,9,'2022-08-25 11:16:05','2022-08-25 11:16:05'),(72,1,'ضاحية جابر العلي',29.312521,47.8785532,9,'2022-08-25 11:16:38','2022-08-25 11:16:38'),(73,1,'ضاحية فهد الأحمد',29.312521,47.8785532,9,'2022-08-25 11:17:13','2022-08-25 11:17:13'),(74,1,'الشعيبة',29.312521,47.8785532,9,'2022-08-25 11:17:41','2022-08-25 11:17:41'),(75,1,'واره',29.312521,47.8785532,9,'2022-08-25 11:18:02','2022-08-25 11:18:02'),(76,1,'مدينة صباح الأحمد',29.312521,47.8785532,9,'2022-08-25 11:18:43','2022-08-25 11:18:43'),(77,1,'النويصيب',29.312521,47.8785532,9,'2022-08-25 11:19:20','2022-08-25 11:19:20'),(78,1,'مدينة الخيران',29.312521,47.8785532,9,'2022-08-25 11:19:53','2022-08-25 11:19:53'),(79,1,'ضاحية علي صباح السالم أم الهيمان سابقاً',29.312521,47.8785532,9,'2022-08-25 11:20:38','2022-08-25 11:20:38'),(80,1,'مدينة صباح الأحمد البحرية',29.312521,47.8785532,9,'2022-08-25 11:21:22','2022-08-25 11:21:22'),(81,1,'Abrq Khitan',29.312521,47.8785532,10,'2022-08-25 11:22:08','2022-08-25 11:22:08'),(82,1,'الأندلس',29.312521,47.8785532,10,'2022-08-25 11:22:29','2022-08-25 11:22:29'),(83,1,'اشبيلية',29.312521,47.8785532,10,'2022-08-25 11:23:08','2022-08-25 11:23:08'),(84,1,'جليب الشيوخ',29.312521,47.8785532,10,'2022-08-25 11:23:43','2022-08-25 11:23:43'),(85,1,'خيطان',29.312521,47.8785532,10,'2022-08-25 11:24:06','2022-08-25 11:24:06'),(86,1,'خيطان الجديدة',29.312521,47.8785532,10,'2022-08-25 11:24:30','2022-08-25 11:24:30'),(87,1,'العمرية',29.312521,47.8785532,10,'2022-08-25 11:24:58','2022-08-25 11:24:58'),(88,1,'العارضية',29.312521,47.8785532,10,'2022-08-25 11:25:22','2022-08-25 11:25:22'),(89,1,'العارضية الصناعية',29.312521,47.8785532,10,'2022-08-25 11:26:01','2022-08-25 11:26:01'),(90,1,'العباسية',29.312521,47.8785532,10,'2022-08-25 11:26:30','2022-08-25 11:26:30'),(91,1,'الفردوس',29.312521,47.8785532,10,'2022-08-25 11:27:01','2022-08-25 11:27:01'),(92,1,'الفروانية',29.312521,47.8785532,10,'2022-08-25 11:27:27','2022-08-25 11:27:27'),(93,1,'الحساوي',29.312521,47.8785532,10,'2022-08-25 11:27:52','2022-08-25 11:27:52'),(94,1,'الشدادية',0,0,10,'2022-08-25 11:31:28','2022-08-25 11:31:28'),(95,1,'الرابية',0,0,10,'2022-08-25 11:31:56','2022-08-25 11:31:56'),(96,1,'الرحاب',0,0,10,'2022-08-25 11:32:37','2022-08-25 11:32:37'),(97,1,'الرقعي',0,0,10,'2022-08-25 11:34:15','2022-08-25 11:34:15'),(98,1,'الري الصناعية',0,0,10,'2022-08-25 11:34:49','2022-08-25 11:34:49'),(99,1,'ضاحية صباح الناصر',0,0,10,'2022-08-25 11:35:48','2022-08-25 11:35:48'),(100,1,'ضاحية عبد الله المبارك',0,0,10,'2022-08-25 11:36:25','2022-08-25 11:36:25'),(101,1,'Dagej',0,0,10,'2022-08-25 11:37:32','2022-08-25 11:37:32'),(102,1,'الصليبية',0,0,11,'2022-08-25 11:38:04','2022-08-25 11:38:04'),(103,1,'أمغرة',0,0,11,'2022-08-25 11:38:29','2022-08-25 11:38:29'),(104,1,'Naeem',0,0,11,'2022-08-25 11:39:03','2022-08-25 11:39:03'),(105,1,'القصر',0,0,11,'2022-08-25 11:42:07','2022-08-25 11:42:07'),(106,1,'الواحة',0,0,11,'2022-08-25 11:42:30','2022-08-25 11:42:30'),(107,1,'تيماء',0,0,11,'2022-08-25 11:42:50','2022-08-25 11:42:50'),(108,1,'النسيم',0,0,11,'2022-08-25 11:43:13','2022-08-25 11:43:13'),(109,1,'العيون',0,0,11,'2022-08-25 11:43:44','2022-08-25 11:43:44'),(110,1,'القيصرية',0,0,11,'2022-08-25 11:44:37','2022-08-25 11:44:37'),(111,1,'العبدلي',0,0,11,'2022-08-25 11:45:06','2022-08-25 11:45:06'),(112,1,'الجهراء القديمة',0,0,11,'2022-08-25 11:46:42','2022-08-25 11:46:42'),(113,1,'New jahra',0,0,11,'2022-08-25 11:47:31','2022-08-25 11:47:31'),(114,1,'كاظمة',0,0,11,'2022-08-25 11:47:48','2022-08-25 11:47:48'),(115,1,'مدينة سعد العبد الله',0,0,11,'2022-08-25 11:48:22','2022-08-25 11:48:22'),(116,1,'السالمي',0,0,11,'2022-08-25 11:48:52','2022-08-25 11:48:52'),(117,1,'المطلاع',0,0,11,'2022-08-25 11:49:24','2022-08-25 11:49:24'),(118,1,'مدينة الحرير',0,0,11,'2022-08-25 11:50:13','2022-08-25 11:50:13'),(119,1,'كبد',0,0,11,'2022-08-25 11:50:44','2022-08-25 11:50:44'),(120,1,'الروضتين',0,0,11,'2022-08-25 11:51:21','2022-08-25 11:51:21'),(121,1,'الصبية',0,0,11,'2022-08-25 11:51:47','2022-08-25 11:51:47'),(122,1,'حولي',0,0,12,'2022-08-25 11:52:26','2022-08-25 11:52:26'),(123,1,'الشعب',0,0,12,'2022-08-25 11:52:47','2022-08-25 11:52:47'),(124,1,'السالمية',0,0,12,'2022-08-25 11:53:07','2022-08-25 11:53:07'),(125,1,'الرميثية',0,0,12,'2022-08-25 11:53:52','2022-08-25 11:53:52'),(126,1,'الجابرية',0,0,12,'2022-08-25 11:54:15','2022-08-25 11:54:15'),(127,1,'مشرف',0,0,12,'2022-08-25 11:54:39','2022-08-25 11:54:39'),(128,1,'بيان',0,0,12,'2022-08-25 11:54:57','2022-08-25 11:54:57'),(129,1,'آلبدع',0,0,12,'2022-08-25 11:55:23','2022-08-25 11:55:23'),(130,1,'النقرة',0,0,12,'2022-08-25 11:55:53','2022-08-25 11:55:53'),(131,1,'ميدان حولي',0,0,12,'2022-08-25 11:56:15','2022-08-25 11:56:15'),(132,1,'ضاحية مبارك العبد الله الجابر',0,0,12,'2022-08-25 11:57:05','2022-08-25 11:57:05'),(133,1,'سلوى',0,0,12,'2022-08-25 11:57:23','2022-08-25 11:57:23'),(134,1,'جنوب السرة',0,0,12,'2022-08-25 11:57:54','2022-08-25 11:57:54'),(135,1,'الزهراء',0,0,12,'2022-08-25 11:58:27','2022-08-25 11:58:27'),(136,1,'الصديق',0,0,12,'2022-08-25 11:59:17','2022-08-25 11:59:17'),(137,1,'حطين',0,0,12,'2022-08-25 11:59:57','2022-08-25 11:59:57'),(138,1,'السلام',0,0,12,'2022-08-25 12:01:35','2022-08-25 12:01:35'),(139,1,'الشهداء',0,0,12,'2022-08-25 12:02:07','2022-08-25 12:02:07'),(140,1,'العدان',0,0,13,'2022-08-25 12:02:29','2022-08-25 12:02:29'),(141,1,'القصور',0,0,13,'2022-08-25 12:02:59','2022-08-25 12:02:59'),(142,1,'القرين',0,0,13,'2022-08-25 12:03:31','2022-08-25 12:03:31'),(143,1,'ضاحية صباح السالم',0,0,13,'2022-08-25 12:04:02','2022-08-25 12:04:02'),(144,1,'المسيلة',0,0,13,'2022-08-25 12:04:27','2022-08-25 12:04:27'),(145,1,'المسايل',0,0,13,'2022-08-25 12:04:54','2022-08-25 12:04:54'),(146,1,'أبو فطيرة',0,0,13,'2022-08-25 12:05:20','2022-08-25 12:05:20'),(147,1,'أبو الحصانية',0,0,13,'2022-08-25 12:05:57','2022-08-25 12:05:57'),(148,1,'صبحان',0,0,13,'2022-08-25 12:06:25','2022-08-25 12:06:25'),(149,1,'الفنيطيس',0,0,13,'2022-08-25 12:06:55','2022-08-25 12:06:55'),(151,1,'مبارك الكبير، الكويت‎',29.1886698,48.0806909,13,'2022-08-28 01:58:47','2022-08-28 01:58:47');

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

CREATE TABLE `role_user` (
  `role_id` bigint unsigned NOT NULL,
  `user_id` bigint unsigned NOT NULL,
  `user_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`user_id`,`role_id`,`user_type`),
  KEY `role_user_role_id_foreign` (`role_id`),
  CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `role_user` (`role_id`, `user_id`, `user_type`) VALUES (1,1,'App\\Models\\User'),(2,3,'App\\Models\\User'),(2,6,'App\\Models\\User'),(2,7,'App\\Models\\User'),(2,8,'App\\Models\\User'),(2,9,'App\\Models\\User'),(2,10,'App\\Models\\User'),(2,11,'App\\Models\\User'),(2,12,'App\\Models\\User'),(2,15,'App\\Models\\User'),(2,18,'App\\Models\\User'),(2,19,'App\\Models\\User'),(2,24,'App\\Models\\User'),(2,27,'App\\Models\\User'),(2,39,'App\\Models\\User'),(2,40,'App\\Models\\User'),(2,41,'App\\Models\\User'),(2,42,'App\\Models\\User'),(2,43,'App\\Models\\User'),(2,44,'App\\Models\\User'),(2,45,'App\\Models\\User'),(2,46,'App\\Models\\User'),(2,57,'App\\Models\\User'),(2,59,'App\\Models\\User'),(2,60,'App\\Models\\User'),(2,61,'App\\Models\\User'),(2,62,'App\\Models\\User'),(2,63,'App\\Models\\User'),(2,64,'App\\Models\\User'),(2,65,'App\\Models\\User'),(2,66,'App\\Models\\User'),(2,67,'App\\Models\\User'),(2,68,'App\\Models\\User'),(2,69,'App\\Models\\User'),(2,70,'App\\Models\\User'),(2,71,'App\\Models\\User'),(2,72,'App\\Models\\User'),(2,73,'App\\Models\\User'),(2,74,'App\\Models\\User'),(2,75,'App\\Models\\User'),(2,76,'App\\Models\\User'),(2,77,'App\\Models\\User'),(2,78,'App\\Models\\User'),(2,79,'App\\Models\\User'),(2,80,'App\\Models\\User'),(2,81,'App\\Models\\User'),(2,82,'App\\Models\\User'),(2,83,'App\\Models\\User'),(2,84,'App\\Models\\User'),(2,85,'App\\Models\\User'),(2,86,'App\\Models\\User'),(3,55,'App\\Models\\User'),(3,58,'App\\Models\\User');

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

CREATE TABLE `roles` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `display_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `roles_name_unique` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` (`id`, `name`, `display_name`, `description`, `created_at`, `updated_at`) VALUES (1,'super_admin','Super Admin','Super Admin','2022-06-21 09:32:18','2022-06-21 09:32:18'),(2,'clients','Clients','Clients','2022-06-21 09:32:18','2022-06-21 09:32:18'),(3,'admin','Admin','Admin','2022-06-21 09:32:18','2022-06-21 09:32:18'),(6,'متم',NULL,NULL,'2022-11-20 13:44:46','2022-11-20 13:44:46');

--
-- Table structure for table `shipping_type_translations`
--

CREATE TABLE `shipping_type_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `shipping_type_id` int unsigned NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `shipping_type_translations_shipping_type_id_locale_unique` (`shipping_type_id`,`locale`),
  CONSTRAINT `shipping_type_translations_shipping_type_id_foreign` FOREIGN KEY (`shipping_type_id`) REFERENCES `shipping_types` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shipping_type_translations`
--


--
-- Table structure for table `shipping_types`
--

CREATE TABLE `shipping_types` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` int NOT NULL DEFAULT '0',
  `status` int NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `shipping_types`
--


--
-- Table structure for table `short_terms`
--

CREATE TABLE `short_terms` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `Ticket` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `AccountNo` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `Action` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `FirstSymbol` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `PriceCurrent` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `PriceOpen` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `PriceSL` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `PriceTP` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `Profit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `SecondSymbol` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `Symbol` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Time` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `Volume` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `short_terms`
--


--
-- Table structure for table `slider_translations`
--

CREATE TABLE `slider_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `slider_id` int unsigned NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `locale` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `slider_translations_slider_id_locale_unique` (`slider_id`,`locale`),
  KEY `slider_translations_locale_index` (`locale`),
  CONSTRAINT `slider_translations_slider_id_foreign` FOREIGN KEY (`slider_id`) REFERENCES `sliders` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `slider_translations`
--

INSERT INTO `slider_translations` (`id`, `slider_id`, `name`, `content`, `locale`, `created_at`, `updated_at`) VALUES (1,3,'الدليل الشامل لجمال منزلك','<pre>\r\nيستعرض هذا الكتاب التفاصيل الهامة لنجاح\r\nمشــــــــــــــروع بناء بيت العمـــر من التصميم\r\nالــــــــــــــى التسليــــــــــــــم\r\n</pre>','ar',NULL,NULL),(2,3,'الدليل الشامل لجمال منزلك','<pre>\r\nيستعرض هذا الكتاب التفاصيل الهامة لنجاح\r\nمشــــــــــــــروع بناء بيت العمـــر من التصميم\r\nالــــــــــــــى التسليــــــــــــــم\r\n</pre>','en',NULL,NULL),(3,8,'هل ترغب في تحسين جمال منزلك','<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; هل ترغب في تحسين جمال منزلك</p>','ar',NULL,NULL),(4,8,'هل ترغب في تحسين جمال منزلك','<p>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; هل ترغب في تحسين جمال منزلك</p>','en',NULL,NULL),(5,9,'هل ترغب في تحسين جمال منزلك','<p>هل ترغب في تحسين جمال منزلك</p>','ar',NULL,NULL),(6,9,'هل ترغب في تحسين جمال منزلك','<p>هل ترغب في تحسين جمال منزلك</p>','en',NULL,NULL);

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` enum('none','category','product') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'none',
  `id_number` int DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '1',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `banner` int DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `image`, `type`, `id_number`, `status`, `created_at`, `updated_at`, `banner`) VALUES (3,'774315-1.png','none',2,'1','2022-11-08 08:59:16','2024-02-19 18:30:56',0),(8,'821494-2.png','none',NULL,'1','2024-02-19 18:33:58','2024-02-19 18:33:58',0),(9,'350922-3.png','none',NULL,'1','2024-02-19 18:34:34','2024-02-19 18:34:34',0);

--
-- Table structure for table `tagers`
--

CREATE TABLE `tagers` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `instagram_link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `banners` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tagers_user_id_foreign` (`user_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tagers`
--

INSERT INTO `tagers` (`id`, `user_id`, `instagram_link`, `banners`, `created_at`, `updated_at`) VALUES (2,47,'https://forsa.topapp-kw.com/ar/admin/panel/tagers/create','[\"2022-06-26-e5e46aed80d0ea36e1ce0e66694b02f81648659101471.png\"]','2022-06-25 08:39:01','2022-06-26 08:48:14'),(3,51,'https://forsa.topapp-kw.com/ar/admin/panel/tagers/create','[\"2022-06-26-unnamed.png\"]','2022-06-25 08:43:38','2022-06-26 08:52:05'),(4,52,'https://forsa.topapp-kw.com/ar/admin/panel/tagers/create','[\"2022-06-25-unnamed-1.png\"]','2022-06-25 08:49:26','2022-06-25 08:49:26'),(5,53,'https://forsa.topapp-kw.com/ar/admin/panel/tagers/create','[\"2022-06-25-b350d943a372f3f36a876b10b3f40038_icon.png\"]','2022-06-25 08:53:19','2022-06-25 08:53:19');

--
-- Table structure for table `topic_subscripts`
--

CREATE TABLE `topic_subscripts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `topics_id` int unsigned DEFAULT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `symobleName` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `topic_subscripts_topics_id_foreign` (`topics_id`),
  CONSTRAINT `topic_subscripts_topics_id_foreign` FOREIGN KEY (`topics_id`) REFERENCES `topics` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `topic_subscripts`
--


--
-- Table structure for table `topics`
--

CREATE TABLE `topics` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `topics`
--


--
-- Table structure for table `user_addresses`
--

CREATE TABLE `user_addresses` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `governments_id` int unsigned DEFAULT NULL,
  `region_id` int unsigned DEFAULT NULL,
  `block` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `Street_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `gada` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `Apartment_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `floor_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `user_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `checked` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lat` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `long` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country_id` int DEFAULT NULL,
  `secondphone` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `governments` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `regions` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `note` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `civil_id` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mac_address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_addresses_user_id_foreign` (`user_id`),
  KEY `user_addresses_governments_id_foreign` (`governments_id`),
  KEY `user_addresses_region_id_foreign` (`region_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_addresses`
--

INSERT INTO `user_addresses` (`id`, `user_id`, `governments_id`, `region_id`, `block`, `Street_number`, `gada`, `Apartment_number`, `floor_number`, `house_number`, `type`, `user_name`, `phone`, `email`, `created_at`, `updated_at`, `checked`, `lat`, `long`, `country_id`, `secondphone`, `governments`, `regions`, `note`, `civil_id`, `mac_address`, `address`) VALUES (1,1,9,52,'21','12','12',NULL,NULL,NULL,NULL,'asdasd','51007138','asdasd@gmail.com','2024-02-19 19:24:19','2024-02-19 19:24:19','true',NULL,NULL,NULL,NULL,NULL,NULL,'asd',NULL,'FGIVY63LF73yDGB0LRkzs8Nc88f9xzFKZvxVYdr1',NULL),(2,1,14,52,'sdad','asdsad','asdasd',NULL,NULL,NULL,NULL,'sadadas','51007138','asdasds@mail.com','2024-02-21 18:50:31','2024-02-24 15:38:08','true',NULL,NULL,2,NULL,NULL,NULL,'asdasd',NULL,'hvUffXqe5i5rb6P001VrnUxJkZankUrPc0wBYvG2',NULL),(3,NULL,10,84,'fgfgfg','المنصورة','fgggggggggdf',NULL,'dfffffffff','dfffffffffq',NULL,'amir_nageh',NULL,'admin@admin.com','2024-02-22 22:41:32','2024-02-22 22:41:32','true',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'MiQ5eF6mE1dfnpgwq7JG4nud9dStgNGKYw9pi03x',NULL);

--
-- Table structure for table `user_categories`
--

CREATE TABLE `user_categories` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `category_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_categories_user_id_foreign` (`user_id`),
  KEY `user_categories_category_id_foreign` (`category_id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_categories`
--

INSERT INTO `user_categories` (`id`, `user_id`, `category_id`, `created_at`, `updated_at`) VALUES (2,47,3,NULL,NULL),(3,51,4,NULL,NULL),(4,52,3,NULL,NULL),(5,53,3,NULL,NULL),(9,47,10,NULL,NULL);

--
-- Table structure for table `user_orders`
--

CREATE TABLE `user_orders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned DEFAULT NULL,
  `order_id` int unsigned DEFAULT NULL,
  `status` enum('wait','refused','accepted','shipped','complete') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_orders_user_id_foreign` (`user_id`),
  KEY `user_orders_order_id_foreign` (`order_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_orders`
--


--
-- Table structure for table `user_products`
--

CREATE TABLE `user_products` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int unsigned NOT NULL,
  `product_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `user_products_user_id_foreign` (`user_id`),
  KEY `user_products_product_id_foreign` (`product_id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_products`
--

INSERT INTO `user_products` (`id`, `user_id`, `product_id`, `created_at`, `updated_at`) VALUES (16,1,3,NULL,NULL);

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

CREATE TABLE `users` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '1',
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `unique_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `civil_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `activation_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lat` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `long` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `device_token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`),
  UNIQUE KEY `users_phone_unique` (`phone`)
) ENGINE=InnoDB AUTO_INCREMENT=87 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `status`, `phone`, `unique_id`, `civil_id`, `activation_code`, `remember_token`, `created_at`, `updated_at`, `address`, `lat`, `long`, `image`, `device_token`) VALUES (1,'admin','admin@admin.com',NULL,'$2y$10$g9ceBZqU5q04D9oL5lUXOuF7Nxvnnf6WQF4E6nouYEL4rGuQS6MOy',1,NULL,NULL,NULL,NULL,NULL,'2022-06-21 09:32:18','2024-02-19 19:05:37',NULL,NULL,NULL,NULL,NULL),(82,'samer','samerabdelmonem96@gmail.com',NULL,'$2y$10$4tgjS7MW713OtLqHvi0qBORFK6iTxYPdEQdJw5BeQfCXeXC3gwuWi',1,'+96555022830',NULL,'212311','73244',NULL,'2022-11-20 04:42:41','2022-11-20 04:44:05',NULL,NULL,NULL,NULL,NULL),(83,'ggggggg','gggg@ggg.com',NULL,'$2y$10$6wO4BWNwtCU1.mTm41aBzujUidjyGH8gxHbnXjCvLTp9anhMJpL2i',1,'+965+96522222222',NULL,NULL,'10132',NULL,'2022-11-20 14:23:47','2022-11-20 14:23:47',NULL,NULL,NULL,NULL,'null'),(84,'ggggg','dddddddd@cc.com',NULL,'$2y$10$96paNluZWZOPAs4sV8TyL.8b/Xyh4Jsyo7/u6rdw95ctXVdsTCtgq',1,'+965+96588888888',NULL,NULL,'41585',NULL,'2022-11-20 15:10:45','2022-11-20 15:10:45',NULL,NULL,NULL,NULL,'null'),(85,'hossamaoun','hossamaoun91@gmail.com',NULL,'$2y$10$gs6rG6gUtxBZ3SP8lYAuFewxRksJq2hsQr45yqZm5lpqZFHMJCzua',1,'+965+96565757668',NULL,NULL,'82599',NULL,'2022-12-14 11:56:53','2022-12-14 11:56:53',NULL,NULL,NULL,NULL,'null'),(86,'adminxx','adminxx@gmail.com',NULL,'$2y$10$DGAMLDuZqzG9Jwp8DYFm0usWbmkSMX6tTyTG798NmT0CFog8s7kSW',1,'+965',NULL,NULL,'96214',NULL,'2025-10-08 06:25:20','2025-10-08 06:25:20',NULL,NULL,NULL,NULL,NULL);

--
-- Dumping events for database 'topappkw_book'
--

--
-- Dumping routines for database 'topappkw_book'
--


