--
-- Host: localhost    Database: topappkw_fr
-- ------------------------------------------------------


--
-- Current Database: `topappkw_fr`
--


--
-- Table structure for table `brand_translations`
--

CREATE TABLE `brand_translations` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `brand_id` int unsigned NOT NULL,
  `name` 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 `brand_translations_brand_id_locale_unique` (`brand_id`,`locale`),
  KEY `brand_translations_locale_index` (`locale`),
  CONSTRAINT `brand_translations_brand_id_foreign` FOREIGN KEY (`brand_id`) REFERENCES `brands` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `brand_translations`
--

INSERT INTO `brand_translations` (`id`, `brand_id`, `name`, `locale`, `created_at`, `updated_at`) VALUES (11,7,'عكس السير','ar',NULL,NULL),(12,7,'aks alsair','en',NULL,NULL),(13,8,'فريش المنعش','ar',NULL,NULL),(14,8,'freesh almonesh','en',NULL,NULL),(17,10,'tet','ar',NULL,NULL),(18,10,'tets','en',NULL,NULL),(19,11,'test','ar',NULL,NULL),(20,11,'test','en',NULL,NULL),(21,12,'dqwde','ar',NULL,NULL),(22,12,'wefwef','en',NULL,NULL),(23,13,'test','ar',NULL,NULL),(24,13,'teat','en',NULL,NULL);

--
-- Table structure for table `brands`
--

CREATE TABLE `brands` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `image` 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=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `brands`
--

INSERT INTO `brands` (`id`, `image`, `created_at`, `updated_at`) VALUES (7,'EQdv0Qbkv2hFHtwO7Xkx4C1BE4PIjNQhVSPOgg52.jpg','2021-05-29 15:28:47','2022-03-30 17:59:30'),(8,'UaD317QacyHpFEQbcyRQNHWIYCVjRALpPUHavIIb.png','2021-05-29 17:41:25','2022-03-30 18:00:16'),(10,'kKQRF9WPtFUFgI0DV958vwJV2V9Kfv48XjwNTtTv.png','2021-05-29 17:44:17','2022-03-30 18:00:50'),(11,'BXLE5ms7j4aDK2i4K4nl5M79qjU6xHYRqr2VRPvb.png','2022-03-30 18:01:45','2022-03-30 18:01:45'),(12,'SMtpcq3fBmSlBUd4dNxp3BdmE7URBv6xJIuiYJrS.png','2022-03-30 18:02:08','2022-03-30 18:02:08'),(13,'p3ziCTZ4nlh5pAIPiz22YleNmNJBpNKC2xgInObT.png','2022-03-30 18:02:28','2022-03-30 18:02:28');

--
-- 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 '1',
  `options` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_id` int DEFAULT '0',
  `orderBy` int DEFAULT NULL,
  `image_show` 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`)
) 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,
  `content` 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 `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 `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint unsigned NOT NULL AUTO_INCREMENT,
  `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`)
) 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) NOT NULL,
  `count` int NOT NULL,
  `feature_id` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL 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 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_translations_feature_id_locale_unique` (`feature_id`,`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,
  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=157 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 (3,'/uploads/product/1/16219399013917bddb-df4a-4e1c-9459-bddeb8720db4.jpg',0,'16219399013917bddb-df4a-4e1c-9459-bddeb8720db4.jpg',1,'App\\Models\\Product','2021-05-25 08:51:41','2021-05-25 08:51:41'),(4,'/uploads/product/1/162193990264214267-6352-4118-86f3-ea1ff396b790.jpg',0,'162193990264214267-6352-4118-86f3-ea1ff396b790.jpg',1,'App\\Models\\Product','2021-05-25 08:51:42','2021-05-25 08:51:42'),(6,'/uploads/product/1/1621939905WhatsApp Image 2021-05-24 at 9.34.51 AM.jpeg',0,'1621939905WhatsApp Image 2021-05-24 at 9.34.51 AM.jpeg',1,'App\\Models\\Product','2021-05-25 08:51:45','2021-05-25 08:51:45'),(8,'/uploads/product/13/1622480035pro(76).jpg',0,'1622480035pro(76).jpg',13,'App\\Models\\Product','2021-05-31 14:53:55','2021-05-31 14:53:55'),(9,'/uploads/product/13/1622480036pro(82).jpg',0,'1622480036pro(82).jpg',13,'App\\Models\\Product','2021-05-31 14:53:56','2021-05-31 14:53:56'),(10,'/uploads/product/13/1622480036pro(83).jpg',0,'1622480036pro(83).jpg',13,'App\\Models\\Product','2021-05-31 14:53:56','2021-05-31 14:53:56'),(11,'/uploads/product/13/1622480037pro(87).jpg',0,'1622480037pro(87).jpg',13,'App\\Models\\Product','2021-05-31 14:53:57','2021-05-31 14:53:57'),(12,'/uploads/product/13/1622480038pro(88).jpg',0,'1622480038pro(88).jpg',13,'App\\Models\\Product','2021-05-31 14:53:58','2021-05-31 14:53:58'),(13,'/uploads/product/13/1622480075pro (13).jpg',0,'1622480075pro (13).jpg',13,'App\\Models\\Product','2021-05-31 14:54:35','2021-05-31 14:54:35'),(14,'/uploads/product/13/1622480076pro (14).jpg',0,'1622480076pro (14).jpg',13,'App\\Models\\Product','2021-05-31 14:54:36','2021-05-31 14:54:36'),(15,'/uploads/product/13/1622480076pro (16).jpg',0,'1622480076pro (16).jpg',13,'App\\Models\\Product','2021-05-31 14:54:36','2021-05-31 14:54:36'),(16,'/uploads/product/13/1622480077pro (18).jpg',0,'1622480077pro (18).jpg',13,'App\\Models\\Product','2021-05-31 14:54:37','2021-05-31 14:54:37'),(17,'/uploads/product/13/1622480078pro (19).jpg',0,'1622480078pro (19).jpg',13,'App\\Models\\Product','2021-05-31 14:54:38','2021-05-31 14:54:38'),(23,'/uploads/product/15/1622480617pro(70).jpg',0,'1622480617pro(70).jpg',15,'App\\Models\\Product','2021-05-31 15:03:37','2021-05-31 15:03:37'),(24,'/uploads/product/15/1622480618pro(72).jpg',0,'1622480618pro(72).jpg',15,'App\\Models\\Product','2021-05-31 15:03:38','2021-05-31 15:03:38'),(25,'/uploads/product/15/1622480619pro(73).jpg',0,'1622480619pro(73).jpg',15,'App\\Models\\Product','2021-05-31 15:03:39','2021-05-31 15:03:39'),(26,'/uploads/product/15/1622480619pro(74).jpg',0,'1622480619pro(74).jpg',15,'App\\Models\\Product','2021-05-31 15:03:39','2021-05-31 15:03:39'),(27,'/uploads/product/15/1622480620pro(75).jpg',0,'1622480620pro(75).jpg',15,'App\\Models\\Product','2021-05-31 15:03:40','2021-05-31 15:03:40'),(28,'/uploads/product/15/1622480620pro(84).jpg',0,'1622480620pro(84).jpg',15,'App\\Models\\Product','2021-05-31 15:03:40','2021-05-31 15:03:40'),(29,'/uploads/product/15/1622480621pro(85).jpg',0,'1622480621pro(85).jpg',15,'App\\Models\\Product','2021-05-31 15:03:41','2021-05-31 15:03:41'),(30,'/uploads/product/15/1622480648pro (34).jpg',0,'1622480648pro (34).jpg',15,'App\\Models\\Product','2021-05-31 15:04:08','2021-05-31 15:04:08'),(31,'/uploads/product/15/1622480671pro (32).jpg',0,'1622480671pro (32).jpg',15,'App\\Models\\Product','2021-05-31 15:04:31','2021-05-31 15:04:31'),(32,'/uploads/product/15/1622480671pro (33).jpg',0,'1622480671pro (33).jpg',15,'App\\Models\\Product','2021-05-31 15:04:31','2021-05-31 15:04:31'),(38,'/uploads/product/25/1622537736562A1315.jpg',0,'1622537736562A1315.jpg',25,'App\\Models\\Product','2021-06-01 06:55:36','2021-06-01 06:55:36'),(39,'/uploads/product/25/1622537736562A1319.jpg',0,'1622537736562A1319.jpg',25,'App\\Models\\Product','2021-06-01 06:55:36','2021-06-01 06:55:36'),(40,'/uploads/product/25/1622537737562A1450.jpg',0,'1622537737562A1450.jpg',25,'App\\Models\\Product','2021-06-01 06:55:37','2021-06-01 06:55:37'),(41,'/uploads/product/25/1622537737562A1458.jpg',0,'1622537737562A1458.jpg',25,'App\\Models\\Product','2021-06-01 06:55:37','2021-06-01 06:55:37'),(42,'/uploads/product/25/1622537738562A1462.jpg',0,'1622537738562A1462.jpg',25,'App\\Models\\Product','2021-06-01 06:55:38','2021-06-01 06:55:38'),(43,'/uploads/product/26/1622537931562A1350.jpg',0,'1622537931562A1350.jpg',26,'App\\Models\\Product','2021-06-01 06:58:51','2021-06-01 06:58:51'),(44,'/uploads/product/26/1622537931562A1365.jpg',0,'1622537931562A1365.jpg',26,'App\\Models\\Product','2021-06-01 06:58:51','2021-06-01 06:58:51'),(45,'/uploads/product/26/1622537932562A1385.jpg',0,'1622537932562A1385.jpg',26,'App\\Models\\Product','2021-06-01 06:58:52','2021-06-01 06:58:52'),(46,'/uploads/product/26/1622537932562A1392.jpg',0,'1622537932562A1392.jpg',26,'App\\Models\\Product','2021-06-01 06:58:52','2021-06-01 06:58:52'),(47,'/uploads/product/26/1622537932562A1409.jpg',0,'1622537932562A1409.jpg',26,'App\\Models\\Product','2021-06-01 06:58:52','2021-06-01 06:58:52'),(48,'/uploads/product/27/1622538072562A4688.jpg',0,'1622538072562A4688.jpg',27,'App\\Models\\Product','2021-06-01 07:01:12','2021-06-01 07:01:12'),(49,'/uploads/product/27/1622538072562A4689.jpg',0,'1622538072562A4689.jpg',27,'App\\Models\\Product','2021-06-01 07:01:12','2021-06-01 07:01:12'),(50,'/uploads/product/27/1622538072562A4694.jpg',0,'1622538072562A4694.jpg',27,'App\\Models\\Product','2021-06-01 07:01:12','2021-06-01 07:01:12'),(51,'/uploads/product/29/1623153590حلويات (7).jpg',0,'1623153590حلويات (7).jpg',29,'App\\Models\\Product','2021-06-08 09:59:50','2021-06-08 09:59:50'),(52,'/uploads/product/29/1623153591حلويات (10).jpg',0,'1623153591حلويات (10).jpg',29,'App\\Models\\Product','2021-06-08 09:59:51','2021-06-08 09:59:51'),(53,'/uploads/product/29/1623153592حلويات (11).jpg',0,'1623153592حلويات (11).jpg',29,'App\\Models\\Product','2021-06-08 09:59:52','2021-06-08 09:59:52'),(54,'/uploads/product/29/1623153592حلويات (13).jpg',0,'1623153592حلويات (13).jpg',29,'App\\Models\\Product','2021-06-08 09:59:52','2021-06-08 09:59:52'),(55,'/uploads/product/30/1623153722حلويات (1).jpg',0,'1623153722حلويات (1).jpg',30,'App\\Models\\Product','2021-06-08 10:02:02','2021-06-08 10:02:02'),(56,'/uploads/product/30/1623153723حلويات (8).jpg',0,'1623153723حلويات (8).jpg',30,'App\\Models\\Product','2021-06-08 10:02:03','2021-06-08 10:02:03'),(57,'/uploads/product/30/1623153724حلويات (9).jpg',0,'1623153724حلويات (9).jpg',30,'App\\Models\\Product','2021-06-08 10:02:04','2021-06-08 10:02:04'),(58,'/uploads/product/30/1623153724حلويات (12).jpg',0,'1623153724حلويات (12).jpg',30,'App\\Models\\Product','2021-06-08 10:02:04','2021-06-08 10:02:04'),(59,'/uploads/product/30/1623153725حلويات (15).jpg',0,'1623153725حلويات (15).jpg',30,'App\\Models\\Product','2021-06-08 10:02:05','2021-06-08 10:02:05'),(60,'/uploads/product/30/1623153726حلويات (16).jpg',0,'1623153726حلويات (16).jpg',30,'App\\Models\\Product','2021-06-08 10:02:06','2021-06-08 10:02:06'),(61,'/uploads/product/30/1623153727حلويات (17).jpg',0,'1623153727حلويات (17).jpg',30,'App\\Models\\Product','2021-06-08 10:02:07','2021-06-08 10:02:07'),(62,'/uploads/product/30/1623153727حلويات (18).jpg',0,'1623153727حلويات (18).jpg',30,'App\\Models\\Product','2021-06-08 10:02:07','2021-06-08 10:02:07'),(63,'/uploads/product/30/1623153729حلويات (19).jpg',0,'1623153729حلويات (19).jpg',30,'App\\Models\\Product','2021-06-08 10:02:09','2021-06-08 10:02:09'),(64,'/uploads/product/36/1623159502pro(102).jpg',0,'1623159502pro(102).jpg',36,'App\\Models\\Product','2021-06-08 11:38:22','2021-06-08 11:38:22'),(65,'/uploads/product/36/1623159524pro(104).jpg',0,'1623159524pro(104).jpg',36,'App\\Models\\Product','2021-06-08 11:38:44','2021-06-08 11:38:44'),(66,'/uploads/product/36/1623159524pro(105).jpg',0,'1623159524pro(105).jpg',36,'App\\Models\\Product','2021-06-08 11:38:44','2021-06-08 11:38:44'),(67,'/uploads/product/36/1623159524pro(106).jpg',0,'1623159524pro(106).jpg',36,'App\\Models\\Product','2021-06-08 11:38:45','2021-06-08 11:38:45'),(68,'/uploads/product/5/1623160271pro(102).jpg',0,'1623160271pro(102).jpg',5,'App\\Models\\Product','2021-06-08 11:51:11','2021-06-08 11:51:11'),(69,'/uploads/product/5/1623160272pro(103).jpg',0,'1623160272pro(103).jpg',5,'App\\Models\\Product','2021-06-08 11:51:12','2021-06-08 11:51:12'),(70,'/uploads/product/5/1623160272pro(104).jpg',0,'1623160272pro(104).jpg',5,'App\\Models\\Product','2021-06-08 11:51:12','2021-06-08 11:51:12'),(71,'/uploads/product/5/1623160273pro(105).jpg',0,'1623160273pro(105).jpg',5,'App\\Models\\Product','2021-06-08 11:51:13','2021-06-08 11:51:13'),(72,'/uploads/product/5/1623160273pro(106).jpg',0,'1623160273pro(106).jpg',5,'App\\Models\\Product','2021-06-08 11:51:13','2021-06-08 11:51:13'),(73,'/uploads/product/37/1623161353562A1290 (1).jpg',0,'1623161353562A1290 (1).jpg',37,'App\\Models\\Product','2021-06-08 12:09:13','2021-06-08 12:09:13'),(97,'/uploads/product/16/1624089086حلويات (19).jpg',0,'1624089086حلويات (19).jpg',16,'App\\Models\\Product','2021-06-19 05:51:26','2021-06-19 05:51:26'),(98,'/uploads/product/16/1624089087حلويات (10).jpg',0,'1624089087حلويات (10).jpg',16,'App\\Models\\Product','2021-06-19 05:51:27','2021-06-19 05:51:27'),(99,'/uploads/product/16/1624089088حلويات (11).jpg',0,'1624089088حلويات (11).jpg',16,'App\\Models\\Product','2021-06-19 05:51:28','2021-06-19 05:51:28'),(100,'/uploads/product/45/1624089266pro(67).jpg',0,'1624089266pro(67).jpg',45,'App\\Models\\Product','2021-06-19 05:54:26','2021-06-19 05:54:26'),(101,'/uploads/product/45/1624089297pro (9).jpg',0,'1624089297pro (9).jpg',45,'App\\Models\\Product','2021-06-19 05:54:57','2021-06-19 05:54:57'),(102,'/uploads/product/45/1624089298pro (10).jpg',0,'1624089298pro (10).jpg',45,'App\\Models\\Product','2021-06-19 05:54:58','2021-06-19 05:54:58'),(103,'/uploads/product/45/1624089298pro (11).jpg',0,'1624089298pro (11).jpg',45,'App\\Models\\Product','2021-06-19 05:54:58','2021-06-19 05:54:58'),(104,'/uploads/product/45/1624089299pro (12).jpg',0,'1624089299pro (12).jpg',45,'App\\Models\\Product','2021-06-19 05:54:59','2021-06-19 05:54:59'),(110,'/uploads/product/47/1624089958WhatsApp Image 2021-06-08 at 7.49.13 AM (2).jpeg',0,'1624089958WhatsApp Image 2021-06-08 at 7.49.13 AM (2).jpeg',47,'App\\Models\\Product','2021-06-19 06:05:58','2021-06-19 06:05:58'),(111,'/uploads/product/47/1624089958WhatsApp Image 2021-06-08 at 7.49.16 AM.jpeg',0,'1624089958WhatsApp Image 2021-06-08 at 7.49.16 AM.jpeg',47,'App\\Models\\Product','2021-06-19 06:05:58','2021-06-19 06:05:58'),(112,'/uploads/product/47/1624089959WhatsApp Image 2021-06-08 at 7.49.18 AM.jpeg',0,'1624089959WhatsApp Image 2021-06-08 at 7.49.18 AM.jpeg',47,'App\\Models\\Product','2021-06-19 06:05:59','2021-06-19 06:05:59'),(113,'/uploads/product/47/1624089960WhatsApp Image 2021-06-08 at 7.49.19 AM.jpeg',0,'1624089960WhatsApp Image 2021-06-08 at 7.49.19 AM.jpeg',47,'App\\Models\\Product','2021-06-19 06:06:00','2021-06-19 06:06:00'),(114,'/uploads/product/49/1624090204pro(70).jpg',0,'1624090204pro(70).jpg',49,'App\\Models\\Product','2021-06-19 06:10:04','2021-06-19 06:10:04'),(115,'/uploads/product/49/1624090205pro(72).jpg',0,'1624090205pro(72).jpg',49,'App\\Models\\Product','2021-06-19 06:10:05','2021-06-19 06:10:05'),(116,'/uploads/product/49/1624090205pro(73).jpg',0,'1624090205pro(73).jpg',49,'App\\Models\\Product','2021-06-19 06:10:06','2021-06-19 06:10:06'),(117,'/uploads/product/49/1624090206pro(74).jpg',0,'1624090206pro(74).jpg',49,'App\\Models\\Product','2021-06-19 06:10:06','2021-06-19 06:10:06'),(118,'/uploads/product/49/1624090207pro(75).jpg',0,'1624090207pro(75).jpg',49,'App\\Models\\Product','2021-06-19 06:10:07','2021-06-19 06:10:07'),(119,'/uploads/product/49/1624090207pro(82).jpg',0,'1624090207pro(82).jpg',49,'App\\Models\\Product','2021-06-19 06:10:07','2021-06-19 06:10:07'),(120,'/uploads/product/49/1624090208pro(83).jpg',0,'1624090208pro(83).jpg',49,'App\\Models\\Product','2021-06-19 06:10:08','2021-06-19 06:10:08'),(121,'/uploads/product/49/1624090208pro(84).jpg',0,'1624090208pro(84).jpg',49,'App\\Models\\Product','2021-06-19 06:10:08','2021-06-19 06:10:08'),(122,'/uploads/product/49/1624090209pro(85).jpg',0,'1624090209pro(85).jpg',49,'App\\Models\\Product','2021-06-19 06:10:09','2021-06-19 06:10:09'),(123,'/uploads/product/50/1624090401حلويات (3).jpg',0,'1624090401حلويات (3).jpg',50,'App\\Models\\Product','2021-06-19 06:13:21','2021-06-19 06:13:21'),(124,'/uploads/product/50/1624090401حلويات (4).jpg',0,'1624090401حلويات (4).jpg',50,'App\\Models\\Product','2021-06-19 06:13:21','2021-06-19 06:13:21'),(125,'/uploads/product/51/1624090597pro(90).jpg',0,'1624090597pro(90).jpg',51,'App\\Models\\Product','2021-06-19 06:16:37','2021-06-19 06:16:37'),(126,'/uploads/product/51/1624090598pro(93).jpg',0,'1624090598pro(93).jpg',51,'App\\Models\\Product','2021-06-19 06:16:38','2021-06-19 06:16:38'),(127,'/uploads/product/51/1624090598pro(94).jpg',0,'1624090598pro(94).jpg',51,'App\\Models\\Product','2021-06-19 06:16:38','2021-06-19 06:16:38'),(128,'/uploads/product/51/1624090599pro(96).jpg',0,'1624090599pro(96).jpg',51,'App\\Models\\Product','2021-06-19 06:16:39','2021-06-19 06:16:39'),(129,'/uploads/product/51/1624090600pro(98).jpg',0,'1624090600pro(98).jpg',51,'App\\Models\\Product','2021-06-19 06:16:40','2021-06-19 06:16:40'),(130,'/uploads/product/51/1624090600pro(108).jpg',0,'1624090600pro(108).jpg',51,'App\\Models\\Product','2021-06-19 06:16:40','2021-06-19 06:16:40'),(131,'/uploads/product/53/1624091206pro(71).jpg',0,'1624091206pro(71).jpg',53,'App\\Models\\Product','2021-06-19 06:26:46','2021-06-19 06:26:46'),(132,'/uploads/product/53/1624091503pro (2).jpg',0,'1624091503pro (2).jpg',53,'App\\Models\\Product','2021-06-19 06:31:43','2021-06-19 06:31:43'),(133,'/uploads/product/53/1624091506pro (4).jpg',0,'1624091506pro (4).jpg',53,'App\\Models\\Product','2021-06-19 06:31:46','2021-06-19 06:31:46'),(134,'/uploads/product/53/1624091509pro (5).jpg',0,'1624091509pro (5).jpg',53,'App\\Models\\Product','2021-06-19 06:31:49','2021-06-19 06:31:49'),(135,'/uploads/product/53/1624091511pro (6).jpg',0,'1624091511pro (6).jpg',53,'App\\Models\\Product','2021-06-19 06:31:51','2021-06-19 06:31:51'),(136,'/uploads/product/53/1624091514pro (7).jpg',0,'1624091514pro (7).jpg',53,'App\\Models\\Product','2021-06-19 06:31:54','2021-06-19 06:31:54'),(137,'/uploads/product/53/1624091518pro (8).jpg',0,'1624091518pro (8).jpg',53,'App\\Models\\Product','2021-06-19 06:31:58','2021-06-19 06:31:58'),(138,'/uploads/product/54/1648536196iStock-1135801697.jpg',0,'1648536196iStock-1135801697.jpg',54,'App\\Models\\Product','2022-03-29 03:43:16','2022-03-29 03:43:16'),(139,'/uploads/product/54/1648536196people-taking-care-farm_23-2149232307.png',0,'1648536196people-taking-care-farm_23-2149232307.png',54,'App\\Models\\Product','2022-03-29 03:43:16','2022-03-29 03:43:16'),(140,'/uploads/product/54/1648536196Place Your Image Here.png',0,'1648536196Place Your Image Here.png',54,'App\\Models\\Product','2022-03-29 03:43:16','2022-03-29 03:43:16'),(141,'/uploads/product/57/1648669220Tea-pickers-in-Kenyas-Mount-Kenya-region-_Photo-credits_-Pic-by-Neil-Palmer-CIAT.jpg.webp',0,'1648669220Tea-pickers-in-Kenyas-Mount-Kenya-region-_Photo-credits_-Pic-by-Neil-Palmer-CIAT.jpg.webp',57,'App\\Models\\Product','2022-03-30 17:40:20','2022-03-30 17:40:20'),(142,'/uploads/product/58/1648669377file-20210629-28-rtys0b.jpeg.webp',0,'1648669377file-20210629-28-rtys0b.jpeg.webp',58,'App\\Models\\Product','2022-03-30 17:42:57','2022-03-30 17:42:57'),(143,'/uploads/product/59/16486694933567600916561.jpg',0,'16486694933567600916561.jpg',59,'App\\Models\\Product','2022-03-30 17:44:53','2022-03-30 17:44:53'),(144,'/uploads/product/60/1648669776empowering_small_farmers.jpg',0,'1648669776empowering_small_farmers.jpg',60,'App\\Models\\Product','2022-03-30 17:49:36','2022-03-30 17:49:36'),(145,'/uploads/product/61/1648669875de75c90a97.jpg',0,'1648669875de75c90a97.jpg',61,'App\\Models\\Product','2022-03-30 17:51:15','2022-03-30 17:51:15'),(146,'/uploads/product/62/164866988712.jpeg',0,'164866988712.jpeg',62,'App\\Models\\Product','2022-03-30 17:51:27','2022-03-30 17:51:27'),(147,'/uploads/product/62/164866989012.jpeg',0,'164866989012.jpeg',62,'App\\Models\\Product','2022-03-30 17:51:30','2022-03-30 17:51:30'),(148,'/uploads/product/63/16486699371.jpeg',0,'16486699371.jpeg',63,'App\\Models\\Product','2022-03-30 17:52:17','2022-03-30 17:52:17'),(149,'/uploads/product/64/164866997212.jpeg',0,'164866997212.jpeg',64,'App\\Models\\Product','2022-03-30 17:52:52','2022-03-30 17:52:52'),(150,'/uploads/product/64/164866997512.jpeg',0,'164866997512.jpeg',64,'App\\Models\\Product','2022-03-30 17:52:55','2022-03-30 17:52:55'),(151,'/uploads/product/65/16486700061.jpeg',0,'16486700061.jpeg',65,'App\\Models\\Product','2022-03-30 17:53:26','2022-03-30 17:53:26'),(152,'/uploads/product/66/164867009412.jpeg',0,'164867009412.jpeg',66,'App\\Models\\Product','2022-03-30 17:54:54','2022-03-30 17:54:54'),(153,'/uploads/product/67/16486702201.jpeg',0,'16486702201.jpeg',67,'App\\Models\\Product','2022-03-30 17:57:00','2022-03-30 17:57:00'),(154,'/uploads/product/68/164867024012.jpeg',0,'164867024012.jpeg',68,'App\\Models\\Product','2022-03-30 17:57:20','2022-03-30 17:57:20'),(155,'/uploads/product/71/1649954526fruit-og-d176ef00.jpeg',0,'1649954526fruit-og-d176ef00.jpeg',71,'App\\Models\\Product','2022-04-14 14:42:06','2022-04-14 14:42:06'),(156,'/uploads/product/58/1649954559fruit-og-d176ef00.jpeg',0,'1649954559fruit-og-d176ef00.jpeg',58,'App\\Models\\Product','2022-04-14 14:42:39','2022-04-14 14:42:39');

--
-- 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=22 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,'2019_08_19_000000_create_failed_jobs_table',1),(4,'2020_09_30_112906_create_brands_table',1),(5,'2020_10_18_113719_create_products_table',1),(6,'2020_10_18_113758_create_product_translations_table',1),(7,'2020_10_18_114316_create_files_table',1),(8,'2020_10_18_115158_create_features_table',1),(9,'2020_10_18_115225_create_feature_translations_table',1),(10,'2020_10_18_115300_create_feature_options_table',1),(11,'2020_10_18_115340_create_feature_option_translations_table',1),(12,'2021_01_12_171432_create_product_related_table',1),(13,'2021_01_13_135350_create_brand_translations_table',1),(14,'2021_04_30_110824_laratrust_setup_tables',1),(15,'2021_05_13_224637_product_gifts',1),(16,'2021_05_22_114120_create_sliders_table',1),(17,'2021_05_22_114941_create_slider_translations_table',1),(18,'2021_05_22_132200_create_categories_table',1),(19,'2021_05_22_132354_create_category_translations_table',1),(20,'2021_05_23_231446_create_product_categories_table',1),(21,'2021_05_24_213952_create_orders_table',2);

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

CREATE TABLE `orders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `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,
  `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `quantity` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int NOT NULL DEFAULT '0',
  `Notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `product_id` int unsigned DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `orders_product_id_foreign` (`product_id`),
  CONSTRAINT `orders_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 `orders`
--

INSERT INTO `orders` (`id`, `name`, `phone`, `email`, `product_name`, `quantity`, `status`, `Notes`, `product_id`, `created_at`, `updated_at`) VALUES (1,'sasd','3432','sasa@ins.co','ssa','21',0,'23',NULL,'2021-05-24 23:11:56','2021-05-24 23:11:56'),(2,'yousaef','55665287','yousef@yousef.com','كرتون للحلويات بغطاء شفاف','4000',1,'Test',NULL,'2021-05-25 12:01:26','2021-05-25 12:02:46');

--
-- 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 `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),(9,4),(10,4),(11,4),(12,4),(13,4),(14,4),(15,4),(16,4),(17,4),(18,4),(19,4),(20,4),(21,4),(22,4),(23,4),(24,4),(25,4),(26,4),(5,5);

--
-- 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=27 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_roles','Create Roles','Create Roles','2021-05-23 11:42:49','2021-05-23 11:42:49'),(2,'read_roles','Read Roles','Read Roles','2021-05-23 11:42:49','2021-05-23 11:42:49'),(3,'update_roles','Update Roles','Update Roles','2021-05-23 11:42:49','2021-05-23 11:42:49'),(4,'delete_roles','Delete Roles','Delete Roles','2021-05-23 11:42:49','2021-05-23 11:42:49'),(5,'create_users','Create Users','Create Users','2021-05-23 11:42:49','2021-05-23 11:42:49'),(6,'read_users','Read Users','Read Users','2021-05-23 11:42:49','2021-05-23 11:42:49'),(7,'update_users','Update Users','Update Users','2021-05-23 11:42:49','2021-05-23 11:42:49'),(8,'delete_users','Delete Users','Delete Users','2021-05-23 11:42:49','2021-05-23 11:42:49'),(9,'create_sliders','Create Sliders','Create Sliders','2021-05-23 11:42:49','2021-05-23 11:42:49'),(10,'read_sliders','Read Sliders','Read Sliders','2021-05-23 11:42:49','2021-05-23 11:42:49'),(11,'update_sliders','Update Sliders','Update Sliders','2021-05-23 11:42:49','2021-05-23 11:42:49'),(12,'delete_sliders','Delete Sliders','Delete Sliders','2021-05-23 11:42:49','2021-05-23 11:42:49'),(13,'create_categories','Create Categories','Create Categories','2021-05-23 11:42:49','2021-05-23 11:42:49'),(14,'read_categories','Read Categories','Read Categories','2021-05-23 11:42:49','2021-05-23 11:42:49'),(15,'update_categories','Update Categories','Update Categories','2021-05-23 11:42:49','2021-05-23 11:42:49'),(16,'delete_categories','Delete Categories','Delete Categories','2021-05-23 11:42:49','2021-05-23 11:42:49'),(17,'create_products','Create Products','Create Products','2021-05-23 11:42:49','2021-05-23 11:42:49'),(18,'read_products','Read Products','Read Products','2021-05-23 11:42:49','2021-05-23 11:42:49'),(19,'update_products','Update Products','Update Products','2021-05-23 11:42:49','2021-05-23 11:42:49'),(20,'delete_products','Delete Products','Delete Products','2021-05-23 11:42:49','2021-05-23 11:42:49'),(21,'create_brands','Create Brands','Create Brands','2021-05-23 11:42:49','2021-05-23 11:42:49'),(22,'read_brands','Read Brands','Read Brands','2021-05-23 11:42:49','2021-05-23 11:42:49'),(23,'update_brands','Update Brands','Update Brands','2021-05-23 11:42:49','2021-05-23 11:42:49'),(24,'delete_brands','Delete Brands','Delete Brands','2021-05-23 11:42:49','2021-05-23 11:42:49'),(25,'create_settings','Create Settings','Create Settings','2021-05-23 11:42:49','2021-05-23 11:42:49'),(26,'read_settings','Read Settings','Read Settings','2021-05-23 11:42:49','2021-05-23 11:42:49');

--
-- 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_gifts`
--

CREATE TABLE `product_gifts` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int unsigned NOT NULL,
  `gift_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_gifts_product_id_foreign` (`product_id`),
  KEY `product_gifts_gift_id_foreign` (`gift_id`),
  CONSTRAINT `product_gifts_gift_id_foreign` FOREIGN KEY (`gift_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_gifts_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_gifts`
--


--
-- Table structure for table `product_related`
--

CREATE TABLE `product_related` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `product_id` int unsigned NOT NULL,
  `related_id` int unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `product_related_product_id_foreign` (`product_id`),
  KEY `product_related_related_id_foreign` (`related_id`),
  CONSTRAINT `product_related_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  CONSTRAINT `product_related_related_id_foreign` FOREIGN KEY (`related_id`) REFERENCES `products` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_related`
--


--
-- 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 DEFAULT NULL,
  `content` 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=109 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `product_translations` (`id`, `product_id`, `name`, `content`, `locale`, `created_at`, `updated_at`) VALUES (83,54,'new','إذا كنت تحتاج إلى عدد أكبر من الفقرات يتيح لك مولد النص العربى زيادة عدد الفقرات كما تريد، النص لن يبدو مقسما ولا يحوي أخطاء لغوية، مولد النص العربى مفيد لمصممي المواقع على وجه الخصوص، حيث يحتاج العميل فى كثير من الأحيان أن يطلع على صورة حقيقية لتصميم الموقع.<br />\r\nومن هنا وجب على المصمم أن يضع نصوصا مؤقتة على التصميم ليظهر للعميل الشكل كاملاً،دور مولد النص العربى أن يوفر على المصمم عناء البحث عن نص بديل لا علاقة له بالموضوع الذى يتحدث عنه ڤ','ar',NULL,NULL),(84,54,'asd','<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>','en',NULL,NULL),(85,57,'sfsdfdsfs','إذا كنت تحتاج إلى عدد أكبر من الفقرات يتيح لك مولد النص العربى زيادة عدد الفقرات كما تريد، النص لن يبدو مقسما ولا يحوي أخطاء لغوية، مولد النص العربى مفيد لمصممي المواقع على وجه الخصوص، حيث يحتاج العميل فى كثير من الأحيان أن يطلع على صورة حقيقية لتصميم الموقع.<br />\r\nومن هنا وجب على المصمم أن يضع نصوصا مؤقتة على التصميم ليظهر للعميل الشكل كاملاً،دور مولد النص العربى أن يوفر على المصمم عناء البحث عن نص بديل لا علاقة له بالموضوع الذى يتحدث عنه&nbsp;','ar',NULL,NULL),(86,57,'sfsdfs','<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>','en',NULL,NULL),(87,58,'خبر تجريبي','إذا كنت تحتاج إلى عدد أكبر من الفقرات يتيح لك مولد النص العربى زيادة عدد الفقرات كما تريد، النص لن يبدو مقسما ولا يحوي أخطاء لغوية، مولد النص العربى مفيد لمصممي المواقع على وجه الخصوص، حيث يحتاج العميل فى كثير من الأحيان أن يطلع على صورة حقيقية لتصميم الموقع.<br />\r\nومن هنا وجب على المصمم أن يضع نصوصا مؤقتة على التصميم ليظهر للعميل الشكل كاملاً،دور مولد النص العربى أن يوفر على المصمم عناء البحث عن نص بديل لا علاقة له بالموضوع الذى يتحدث عنه&nbsp;','ar',NULL,NULL),(88,58,'خبر تجريبي','<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>','en',NULL,NULL),(89,59,'خبر تجريبي 2','إذا كنت تحتاج إلى عدد أكبر من الفقرات يتيح لك مولد النص العربى زيادة عدد الفقرات كما تريد، النص لن يبدو مقسما ولا يحوي أخطاء لغوية، مولد النص العربى مفيد لمصممي المواقع على وجه الخصوص، حيث يحتاج العميل فى كثير من الأحيان أن يطلع على صورة حقيقية لتصميم الموقع.<br />\r\nومن هنا وجب على المصمم أن يضع نصوصا مؤقتة على التصميم ليظهر للعميل الشكل كاملاً،دور مولد النص العربى أن يوفر على المصمم عناء البحث عن نص بديل لا علاقة له بالموضوع الذى يتحدث عنه&nbsp;','ar',NULL,NULL),(90,59,'خبر تجريبي 2','<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>','en',NULL,NULL),(91,60,'خبر تجريبي3','إذا كنت تحتاج إلى عدد أكبر من الفقرات يتيح لك مولد النص العربى زيادة عدد الفقرات كما تريد، النص لن يبدو مقسما ولا يحوي أخطاء لغوية، مولد النص العربى مفيد لمصممي المواقع على وجه الخصوص، حيث يحتاج العميل فى كثير من الأحيان أن يطلع على صورة حقيقية لتصميم الموقع.<br />\r\nومن هنا وجب على المصمم أن يضع نصوصا مؤقتة على التصميم ليظهر للعميل الشكل كاملاً،دور مولد النص العربى أن يوفر على المصمم عناء البحث عن نص بديل لا علاقة له بالموضوع الذى يتحدث عنه&nbsp;','ar',NULL,NULL),(92,60,'خبر تجريبي3','<p><strong>Lorem Ipsum</strong>&nbsp;is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry&#39;s standard dummy text ever since the 1500s, when an unknown printer took a galley of type and scrambled it to make a type specimen book. It has survived not only five centuries, but also the leap into electronic typesetting, remaining essentially unchanged. It was popularised in the 1960s with the release of Letraset sheets containing Lorem Ipsum passages, and more recently with desktop publishing software like Aldus PageMaker including versions of Lorem Ipsum.</p>','en',NULL,NULL),(93,61,'خبر تجريبي 4','إذا كنت تحتاج إلى عدد أكبر من الفقرات يتيح لك مولد النص العربى زيادة عدد الفقرات كما تريد، النص لن يبدو مقسما ولا يحوي أخطاء لغوية، مولد النص العربى مفيد لمصممي المواقع على وجه الخصوص، حيث يحتاج العميل فى كثير من الأحيان أن يطلع على صورة حقيقية لتصميم الموقع.<br />\r\nومن هنا وجب على المصمم أن يضع نصوصا مؤقتة على التصميم ليظهر للعميل الشكل كاملاً،دور مولد النص العربى أن يوفر على المصمم عناء البحث عن نص بديل لا علاقة له بالموضوع الذى يتحدث عنه&nbsp;','ar',NULL,NULL),(94,61,'خبر تجريبي 4','خبر تجريبي 4','en',NULL,NULL),(95,62,'مشروع تجريبي','مشروع تجريبي','ar',NULL,NULL),(96,62,'مشروع تجريبيمشروع تجريبي','مشروع تجريبي','en',NULL,NULL),(97,63,'مشروع تجريبي','مشروع تجريبي','ar',NULL,NULL),(98,63,'مشروع تجريبي','مشروع تجريبي','en',NULL,NULL),(99,64,'مشروع تجريبي','مشروع تجريبي','ar',NULL,NULL),(100,64,'مشروع تجريبي','مشروع تجريبي','en',NULL,NULL),(101,65,'مشروع تجريبي','مشروع تجريبي','ar',NULL,NULL),(102,65,'مشروع تجريبي','مشروع تجريبي','en',NULL,NULL),(103,66,'مشروع تجريبي','مشروع تجريبي','ar',NULL,NULL),(104,66,'مشروع تجريبي','مشروع تجريبي','en',NULL,NULL),(105,67,'مشروع تجريبي','مشروع تجريبي','ar',NULL,NULL),(106,67,'مشروع تجريبي','مشروع تجريبي','en',NULL,NULL),(107,68,'مشروع تجريبي','مشروع تجريبي','ar',NULL,NULL),(108,68,'مشروع تجريبي','مشروع تجريبي','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',
  `startoffer` datetime DEFAULT NULL,
  `endoffer` datetime DEFAULT NULL,
  `price_offer` decimal(8,2) DEFAULT NULL,
  `view` int NOT NULL DEFAULT '0',
  `code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` enum('0','1','2') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('pending','active') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'active',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  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=74 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `products` (`id`, `image`, `user_id`, `mainprice`, `discount`, `stoke`, `startoffer`, `endoffer`, `price_offer`, `view`, `code`, `type`, `status`, `created_at`, `updated_at`) VALUES (54,'ggxD9VFi7pjRoMqzQx9gyQOeowH4MVFKdcsN5vJN.png',1,0.00,0.00,0,NULL,NULL,NULL,0,NULL,'0','active','2022-03-29 03:27:16','2022-03-30 03:37:17'),(56,NULL,NULL,0.00,0.00,0,NULL,NULL,NULL,0,NULL,NULL,'active','2022-03-30 17:38:54','2022-03-30 17:38:54'),(57,'T2nUVTKrlMOvvZ3jxBw2utVdXc6hoUBIzyio9i70.webp',1,0.00,0.00,0,NULL,NULL,NULL,0,NULL,'0','active','2022-03-30 17:39:46','2022-03-30 17:40:47'),(58,'Ai6E8X6W0JqHiOEbe7DiwSC58Gg3pK1N9aDxSgdA.webp',1,0.00,0.00,0,NULL,NULL,NULL,0,NULL,'0','active','2022-03-30 17:42:41','2022-03-30 17:43:10'),(59,'5WGjK6ggGK70dAxY7uBoKz1aZRZRpqHXeagkt4cP.jpg',1,0.00,0.00,0,NULL,NULL,NULL,0,NULL,'0','active','2022-03-30 17:44:13','2022-03-30 17:44:58'),(60,'a2kUgIwc54Td1ephMw0koEumynZRKqNkTchwY9lg.jpg',1,0.00,0.00,0,NULL,NULL,NULL,0,NULL,'0','active','2022-03-30 17:45:44','2022-03-30 17:49:49'),(61,'anpi9WUvGsvo1ZCdYz6h4cnNjZ0wEzISzVMdnVCV.jpg',1,0.00,0.00,0,NULL,NULL,NULL,0,NULL,'0','active','2022-03-30 17:50:48','2022-03-30 17:51:24'),(62,'3sxCYH1QIjeVgpDxZehW9j6VCZhl11NeiswyfAZM.jpg',1,0.00,0.00,0,NULL,NULL,NULL,0,NULL,'1','active','2022-03-30 17:50:59','2022-03-30 17:51:32'),(63,'DVIfpJq6Fyc98lWw1zHmLvKSb4BZcWG2tHBmx5Ad.jpg',1,0.00,0.00,0,NULL,NULL,NULL,0,NULL,'1','active','2022-03-30 17:52:02','2022-03-30 17:52:24'),(64,'bLY2fln7eSlNPlg3vMdDtVg7jDkekxdvdlBur9aG.jpg',1,0.00,0.00,0,NULL,NULL,NULL,0,NULL,'1','active','2022-03-30 17:52:40','2022-03-30 17:53:00'),(65,'S69qHAwoP0pYTGfym0RzJAeOycti1dPvYtdxKouO.jpg',1,0.00,0.00,0,NULL,NULL,NULL,0,NULL,'1','active','2022-03-30 17:53:14','2022-03-30 17:53:29'),(66,'f90QBmih3ixK6vonojboMH81uEHyzglJPfEmbwSO.jpg',1,0.00,0.00,0,NULL,NULL,NULL,0,NULL,'2','active','2022-03-30 17:54:39','2022-03-30 17:54:56'),(67,'sgsJhwWIDjL4FeUzrzwtqNLOm8XeeLcInG0bfQOH.jpg',1,0.00,0.00,0,NULL,NULL,NULL,0,NULL,'2','active','2022-03-30 17:56:48','2022-03-30 17:57:02'),(68,'W5wckcKYdKH5ohLRKaIdQFp6mjL5CT9a5Gp9oXDy.jpg',1,0.00,0.00,0,NULL,NULL,NULL,0,NULL,'2','active','2022-03-30 17:57:07','2022-03-30 17:57:23'),(69,NULL,NULL,0.00,0.00,0,NULL,NULL,NULL,0,NULL,NULL,'active','2022-04-02 17:27:17','2022-04-02 17:27:17'),(70,NULL,NULL,0.00,0.00,0,NULL,NULL,NULL,0,NULL,NULL,'active','2022-04-14 14:35:42','2022-04-14 14:35:42'),(71,NULL,NULL,0.00,0.00,0,NULL,NULL,NULL,0,NULL,NULL,'active','2022-04-14 14:41:42','2022-04-14 14:41:42'),(72,NULL,NULL,0.00,0.00,0,NULL,NULL,NULL,0,NULL,NULL,'active','2022-04-14 14:44:26','2022-04-14 14:44:26'),(73,NULL,NULL,0.00,0.00,0,NULL,NULL,NULL,0,NULL,NULL,'active','2022-04-14 14:44:50','2022-04-14 14:44:50');

--
-- 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,4,'App\\Models\\User'),(2,5,'App\\Models\\User'),(2,6,'App\\Models\\User'),(4,4,'App\\Models\\User'),(4,5,'App\\Models\\User'),(5,6,'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=11 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','2021-05-23 11:42:49','2021-05-23 11:42:49'),(2,'admin','Admin','Admin','2021-05-23 11:42:49','2021-05-23 11:42:49'),(4,'Executive Director','Accountant','Accountant','2021-05-23 11:42:49','2022-03-30 05:48:15'),(5,'مبيعات',NULL,NULL,'2021-05-25 08:23:56','2021-05-25 08:23:56'),(6,'sadasd',NULL,NULL,'2022-03-30 05:47:20','2022-03-30 05:47:20'),(7,'asdasdsad',NULL,NULL,'2022-03-30 05:47:34','2022-03-30 05:47:34'),(8,'asdasdsadasda',NULL,NULL,'2022-03-30 05:47:43','2022-03-30 05:47:43'),(9,'Founder and President of the Africa Food Basket Fund Consortium',NULL,NULL,'2022-03-30 05:53:43','2022-03-30 05:53:55'),(10,'مديدر',NULL,NULL,'2022-04-14 14:44:00','2022-04-14 14:44:00');

--
-- 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,
  `content2` 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=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `slider_translations` (`id`, `slider_id`, `name`, `content`, `content2`, `locale`, `created_at`, `updated_at`) VALUES (21,10,'فثسف','شسي',NULL,'ar',NULL,NULL),(22,10,'شسي','شسيشسي',NULL,'en',NULL,NULL),(23,10,'سشيشسي','شسيشسي',NULL,'ru',NULL,NULL),(24,10,'شسي','سشي',NULL,'fr',NULL,NULL);

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

CREATE TABLE `sliders` (
  `id` int unsigned NOT NULL AUTO_INCREMENT,
  `show` enum('banner','slider') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `order` int DEFAULT NULL,
  `categoryShow` int DEFAULT NULL,
  `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 `sliders`
--

INSERT INTO `sliders` (`id`, `show`, `image`, `link`, `order`, `categoryShow`, `created_at`, `updated_at`) VALUES (10,NULL,'2022-04-14-fruit-og-d176ef00.jpeg',NULL,NULL,NULL,'2022-04-14 14:41:19','2022-04-14 14:41:19');

--
-- 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 DEFAULT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `civil_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int 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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `users_email_unique` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `users` (`id`, `name`, `email`, `email_verified_at`, `password`, `civil_id`, `image`, `status`, `remember_token`, `created_at`, `updated_at`) VALUES (1,'admin','super_admin@admin.com',NULL,'$2y$10$Z5sfFPbSuAqB3b4Xhrb7yeJArmSptgmhd/4/4npa1TstVLu9mRR.i','159159',NULL,1,NULL,'2021-05-23 11:42:49','2021-05-23 11:42:49'),(4,'samer',NULL,NULL,NULL,NULL,'2022-03-30-image2.jpg',1,NULL,'2022-03-30 04:47:37','2022-03-30 04:47:37'),(5,'asdsadasdas',NULL,NULL,NULL,NULL,'2022-03-30-image2.jpg',1,NULL,'2022-03-30 05:35:34','2022-03-30 05:35:34'),(6,'ahmed',NULL,NULL,NULL,NULL,'2022-04-14-fruit-og-d176ef00.jpeg',1,NULL,'2022-04-14 14:43:34','2022-04-14 14:43:34');

--
-- Dumping events for database 'topappkw_fr'
--

--
-- Dumping routines for database 'topappkw_fr'
--


