-- MySQL dump 10.13 Distrib 8.0.37, for Linux (x86_64) -- -- Host: localhost Database: topappkw_fr -- ------------------------------------------------------ -- Server version 8.0.37 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!50503 SET NAMES utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Current Database: `topappkw_fr` -- -- -- Table structure for table `brand_translations` -- DROP TABLE IF EXISTS `brand_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `brand_translations` -- LOCK TABLES `brand_translations` WRITE; /*!40000 ALTER TABLE `brand_translations` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `brand_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `brands` -- DROP TABLE IF EXISTS `brands`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `brands` -- LOCK TABLES `brands` WRITE; /*!40000 ALTER TABLE `brands` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `brands` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `categories` -- DROP TABLE IF EXISTS `categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `categories` -- LOCK TABLES `categories` WRITE; /*!40000 ALTER TABLE `categories` DISABLE KEYS */; /*!40000 ALTER TABLE `categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `category_translations` -- DROP TABLE IF EXISTS `category_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `category_translations` -- LOCK TABLES `category_translations` WRITE; /*!40000 ALTER TABLE `category_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `category_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `failed_jobs` -- DROP TABLE IF EXISTS `failed_jobs`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `failed_jobs` -- LOCK TABLES `failed_jobs` WRITE; /*!40000 ALTER TABLE `failed_jobs` DISABLE KEYS */; /*!40000 ALTER TABLE `failed_jobs` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `feature_option_translations` -- DROP TABLE IF EXISTS `feature_option_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `feature_option_translations` -- LOCK TABLES `feature_option_translations` WRITE; /*!40000 ALTER TABLE `feature_option_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `feature_option_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `feature_options` -- DROP TABLE IF EXISTS `feature_options`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `feature_options` -- LOCK TABLES `feature_options` WRITE; /*!40000 ALTER TABLE `feature_options` DISABLE KEYS */; /*!40000 ALTER TABLE `feature_options` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `feature_translations` -- DROP TABLE IF EXISTS `feature_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `feature_translations` -- LOCK TABLES `feature_translations` WRITE; /*!40000 ALTER TABLE `feature_translations` DISABLE KEYS */; /*!40000 ALTER TABLE `feature_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `features` -- DROP TABLE IF EXISTS `features`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `features` -- LOCK TABLES `features` WRITE; /*!40000 ALTER TABLE `features` DISABLE KEYS */; /*!40000 ALTER TABLE `features` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `files` -- DROP TABLE IF EXISTS `files`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `files` -- LOCK TABLES `files` WRITE; /*!40000 ALTER TABLE `files` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `files` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `migrations` -- DROP TABLE IF EXISTS `migrations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `migrations` -- LOCK TABLES `migrations` WRITE; /*!40000 ALTER TABLE `migrations` DISABLE KEYS */; INSERT INTO `migrations` (`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); /*!40000 ALTER TABLE `migrations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `orders` -- DROP TABLE IF EXISTS `orders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `orders` -- LOCK TABLES `orders` WRITE; /*!40000 ALTER TABLE `orders` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `orders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `password_resets` -- DROP TABLE IF EXISTS `password_resets`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `password_resets` -- LOCK TABLES `password_resets` WRITE; /*!40000 ALTER TABLE `password_resets` DISABLE KEYS */; /*!40000 ALTER TABLE `password_resets` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `permission_role` -- DROP TABLE IF EXISTS `permission_role`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `permission_role` -- LOCK TABLES `permission_role` WRITE; /*!40000 ALTER TABLE `permission_role` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `permission_role` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `permission_user` -- DROP TABLE IF EXISTS `permission_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `permission_user` -- LOCK TABLES `permission_user` WRITE; /*!40000 ALTER TABLE `permission_user` DISABLE KEYS */; /*!40000 ALTER TABLE `permission_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `permissions` -- DROP TABLE IF EXISTS `permissions`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `permissions` ( `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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `permissions` -- LOCK TABLES `permissions` WRITE; /*!40000 ALTER TABLE `permissions` DISABLE KEYS */; INSERT INTO `permissions` (`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'); /*!40000 ALTER TABLE `permissions` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_categories` -- DROP TABLE IF EXISTS `product_categories`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `product_categories` -- LOCK TABLES `product_categories` WRITE; /*!40000 ALTER TABLE `product_categories` DISABLE KEYS */; /*!40000 ALTER TABLE `product_categories` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_gifts` -- DROP TABLE IF EXISTS `product_gifts`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `product_gifts` -- LOCK TABLES `product_gifts` WRITE; /*!40000 ALTER TABLE `product_gifts` DISABLE KEYS */; /*!40000 ALTER TABLE `product_gifts` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_related` -- DROP TABLE IF EXISTS `product_related`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `product_related` -- LOCK TABLES `product_related` WRITE; /*!40000 ALTER TABLE `product_related` DISABLE KEYS */; /*!40000 ALTER TABLE `product_related` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `product_translations` -- DROP TABLE IF EXISTS `product_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `product_translations` -- LOCK TABLES `product_translations` WRITE; /*!40000 ALTER TABLE `product_translations` DISABLE KEYS */; INSERT INTO `product_translations` (`id`, `product_id`, `name`, `content`, `locale`, `created_at`, `updated_at`) VALUES (83,54,'new','إذا كنت تحتاج إلى عدد أكبر من الفقرات يتيح لك مولد النص العربى زيادة عدد الفقرات كما تريد، النص لن يبدو مقسما ولا يحوي أخطاء لغوية، مولد النص العربى مفيد لمصممي المواقع على وجه الخصوص، حيث يحتاج العميل فى كثير من الأحيان أن يطلع على صورة حقيقية لتصميم الموقع.
\r\nومن هنا وجب على المصمم أن يضع نصوصا مؤقتة على التصميم ليظهر للعميل الشكل كاملاً،دور مولد النص العربى أن يوفر على المصمم عناء البحث عن نص بديل لا علاقة له بالموضوع الذى يتحدث عنه ڤ','ar',NULL,NULL),(84,54,'asd','

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry'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.

','en',NULL,NULL),(85,57,'sfsdfdsfs','إذا كنت تحتاج إلى عدد أكبر من الفقرات يتيح لك مولد النص العربى زيادة عدد الفقرات كما تريد، النص لن يبدو مقسما ولا يحوي أخطاء لغوية، مولد النص العربى مفيد لمصممي المواقع على وجه الخصوص، حيث يحتاج العميل فى كثير من الأحيان أن يطلع على صورة حقيقية لتصميم الموقع.
\r\nومن هنا وجب على المصمم أن يضع نصوصا مؤقتة على التصميم ليظهر للعميل الشكل كاملاً،دور مولد النص العربى أن يوفر على المصمم عناء البحث عن نص بديل لا علاقة له بالموضوع الذى يتحدث عنه ','ar',NULL,NULL),(86,57,'sfsdfs','

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry'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.

','en',NULL,NULL),(87,58,'خبر تجريبي','إذا كنت تحتاج إلى عدد أكبر من الفقرات يتيح لك مولد النص العربى زيادة عدد الفقرات كما تريد، النص لن يبدو مقسما ولا يحوي أخطاء لغوية، مولد النص العربى مفيد لمصممي المواقع على وجه الخصوص، حيث يحتاج العميل فى كثير من الأحيان أن يطلع على صورة حقيقية لتصميم الموقع.
\r\nومن هنا وجب على المصمم أن يضع نصوصا مؤقتة على التصميم ليظهر للعميل الشكل كاملاً،دور مولد النص العربى أن يوفر على المصمم عناء البحث عن نص بديل لا علاقة له بالموضوع الذى يتحدث عنه ','ar',NULL,NULL),(88,58,'خبر تجريبي','

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry'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.

','en',NULL,NULL),(89,59,'خبر تجريبي 2','إذا كنت تحتاج إلى عدد أكبر من الفقرات يتيح لك مولد النص العربى زيادة عدد الفقرات كما تريد، النص لن يبدو مقسما ولا يحوي أخطاء لغوية، مولد النص العربى مفيد لمصممي المواقع على وجه الخصوص، حيث يحتاج العميل فى كثير من الأحيان أن يطلع على صورة حقيقية لتصميم الموقع.
\r\nومن هنا وجب على المصمم أن يضع نصوصا مؤقتة على التصميم ليظهر للعميل الشكل كاملاً،دور مولد النص العربى أن يوفر على المصمم عناء البحث عن نص بديل لا علاقة له بالموضوع الذى يتحدث عنه ','ar',NULL,NULL),(90,59,'خبر تجريبي 2','

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry'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.

','en',NULL,NULL),(91,60,'خبر تجريبي3','إذا كنت تحتاج إلى عدد أكبر من الفقرات يتيح لك مولد النص العربى زيادة عدد الفقرات كما تريد، النص لن يبدو مقسما ولا يحوي أخطاء لغوية، مولد النص العربى مفيد لمصممي المواقع على وجه الخصوص، حيث يحتاج العميل فى كثير من الأحيان أن يطلع على صورة حقيقية لتصميم الموقع.
\r\nومن هنا وجب على المصمم أن يضع نصوصا مؤقتة على التصميم ليظهر للعميل الشكل كاملاً،دور مولد النص العربى أن يوفر على المصمم عناء البحث عن نص بديل لا علاقة له بالموضوع الذى يتحدث عنه ','ar',NULL,NULL),(92,60,'خبر تجريبي3','

Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry'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.

','en',NULL,NULL),(93,61,'خبر تجريبي 4','إذا كنت تحتاج إلى عدد أكبر من الفقرات يتيح لك مولد النص العربى زيادة عدد الفقرات كما تريد، النص لن يبدو مقسما ولا يحوي أخطاء لغوية، مولد النص العربى مفيد لمصممي المواقع على وجه الخصوص، حيث يحتاج العميل فى كثير من الأحيان أن يطلع على صورة حقيقية لتصميم الموقع.
\r\nومن هنا وجب على المصمم أن يضع نصوصا مؤقتة على التصميم ليظهر للعميل الشكل كاملاً،دور مولد النص العربى أن يوفر على المصمم عناء البحث عن نص بديل لا علاقة له بالموضوع الذى يتحدث عنه ','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); /*!40000 ALTER TABLE `product_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `products` -- DROP TABLE IF EXISTS `products`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `products` -- LOCK TABLES `products` WRITE; /*!40000 ALTER TABLE `products` DISABLE KEYS */; INSERT INTO `products` (`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'); /*!40000 ALTER TABLE `products` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `role_user` -- DROP TABLE IF EXISTS `role_user`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `role_user` -- LOCK TABLES `role_user` WRITE; /*!40000 ALTER TABLE `role_user` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `role_user` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `roles` -- DROP TABLE IF EXISTS `roles`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; CREATE TABLE `roles` ( `id` 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `roles` -- LOCK TABLES `roles` WRITE; /*!40000 ALTER TABLE `roles` DISABLE KEYS */; INSERT INTO `roles` (`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'); /*!40000 ALTER TABLE `roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `slider_translations` -- DROP TABLE IF EXISTS `slider_translations`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `slider_translations` -- LOCK TABLES `slider_translations` WRITE; /*!40000 ALTER TABLE `slider_translations` DISABLE KEYS */; 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); /*!40000 ALTER TABLE `slider_translations` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `sliders` -- DROP TABLE IF EXISTS `sliders`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `sliders` -- LOCK TABLES `sliders` WRITE; /*!40000 ALTER TABLE `sliders` DISABLE KEYS */; 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'); /*!40000 ALTER TABLE `sliders` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `users` -- DROP TABLE IF EXISTS `users`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!50503 SET character_set_client = utf8mb4 */; 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; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `users` -- LOCK TABLES `users` WRITE; /*!40000 ALTER TABLE `users` DISABLE KEYS */; INSERT INTO `users` (`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'); /*!40000 ALTER TABLE `users` ENABLE KEYS */; UNLOCK TABLES; -- -- Dumping events for database 'topappkw_fr' -- -- -- Dumping routines for database 'topappkw_fr' -- /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; -- Dump completed on 2025-10-28 2:19:40