text: -- --------------------------------------------------------
  -- Host:                         127.0.0.1
  -- Server version:               5.7.31 - MySQL Community Server (GPL)
  -- Server OS:                    Win64
  -- HeidiSQL Version:             11.2.0.6213
  -- --------------------------------------------------------
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET NAMES utf8 */;
  /*!50503 SET NAMES utf8mb4 */;
  /*!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 */;
  
  -- Dumping structure for table sensorbaba_db.attributegroup_category
  CREATE TABLE IF NOT EXISTS `attributegroup_category` (
    `category_id` int(10) unsigned NOT NULL,
    `attributeGroup_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    KEY `attributegroup_category_category_id_foreign` (`category_id`),
    KEY `attributegroup_category_attributegroup_id_foreign` (`attributeGroup_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.attributevalue_product
  CREATE TABLE IF NOT EXISTS `attributevalue_product` (
    `attributeValue_id` int(11) DEFAULT NULL,
    `product_id` int(11) DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    KEY `attributevalue_product_product_id_foreign` (`product_id`) USING BTREE,
    KEY `attributevalue_product_attributeValue_id_id_foreign` (`attributeValue_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.attributevalue_variety
  CREATE TABLE IF NOT EXISTS `attributevalue_variety` (
    `attributeValue_id` int(11) DEFAULT NULL,
    `variety_id` int(11) DEFAULT NULL,
    KEY `attributeValue_variety_attributeValue_id_foriegn` (`attributeValue_id`) USING BTREE,
    KEY `attributevalue_variety_variety_id_foriegn` (`variety_id`) USING BTREE
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.attribute_groups
  CREATE TABLE IF NOT EXISTS `attribute_groups` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `type` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.attribute_values
  CREATE TABLE IF NOT EXISTS `attribute_values` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `attributeGroup_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `attribute_values_attributegroup_id_foreign` (`attributeGroup_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.baners
  CREATE TABLE IF NOT EXISTS `baners` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `product_id` int(10) unsigned NOT NULL,
    `description` text COLLATE utf8mb4_persian_ci NOT NULL,
    `photo_id` int(11) NOT NULL,
    `title` varchar(50) COLLATE utf8mb4_persian_ci DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `baners_product_id_foriegn` (`product_id`) USING BTREE,
    KEY `baners_photo_id_foriegn` (`photo_id`) USING BTREE
  ) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.brands
  CREATE TABLE IF NOT EXISTS `brands` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `description` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `photo_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `brands_photo_id_foreign` (`photo_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.brand_category
  CREATE TABLE IF NOT EXISTS `brand_category` (
    `category_id` int(10) unsigned NOT NULL,
    `brand_id` int(10) unsigned NOT NULL,
    KEY `brand_category_brand_id_foreign` (`brand_id`),
    KEY `brand_category_category_id_foreign` (`category_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.categories
  CREATE TABLE IF NOT EXISTS `categories` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `meta_desc` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `meta_title` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `meta_keywords` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `parent_id` int(10) unsigned DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.category_product
  CREATE TABLE IF NOT EXISTS `category_product` (
    `category_id` int(10) unsigned NOT NULL,
    `product_id` int(10) unsigned NOT NULL,
    KEY `category_product_category_id_foreign` (`category_id`),
    KEY `category_product_product_id_foreign` (`product_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.failed_jobs
  CREATE TABLE IF NOT EXISTS `failed_jobs` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `uuid` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `connection` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `queue` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `payload` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `exception` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
    `failed_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (`id`),
    UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.features
  CREATE TABLE IF NOT EXISTS `features` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `product_id` int(10) unsigned NOT NULL,
    `description` text COLLATE utf8mb4_persian_ci NOT NULL,
    `title` varchar(50) COLLATE utf8mb4_persian_ci NOT NULL,
    `photo_id` varchar(50) COLLATE utf8mb4_persian_ci NOT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `features_product_id_foriegn` (`product_id`),
    KEY `features_photo_id_foriegn` (`photo_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.feature_product
  CREATE TABLE IF NOT EXISTS `feature_product` (
    `feature_id` int(10) unsigned NOT NULL,
    `product_id` int(10) unsigned NOT NULL,
    KEY `feature_product_feature_id_foreign` (`feature_id`),
    KEY `feature_product_product_id_foreign` (`product_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.migrations
  CREATE TABLE IF NOT EXISTS `migrations` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `migration` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `batch` int(11) NOT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.news
  CREATE TABLE IF NOT EXISTS `news` (
    `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
    `description` text COLLATE utf8mb4_persian_ci NOT NULL,
    `title` varchar(50) COLLATE utf8mb4_persian_ci NOT NULL,
    `photo_id` varchar(50) COLLATE utf8mb4_persian_ci NOT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `news_photo_id_foriegn` (`photo_id`) USING BTREE
  ) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.password_resets
  CREATE TABLE IF NOT EXISTS `password_resets` (
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `token` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    KEY `password_resets_email_index` (`email`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.photos
  CREATE TABLE IF NOT EXISTS `photos` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `path` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `original_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `photos_user_id_foreign` (`user_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=70 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.photo_product
  CREATE TABLE IF NOT EXISTS `photo_product` (
    `photo_id` int(10) unsigned NOT NULL,
    `product_id` int(10) unsigned NOT NULL,
    KEY `photo_product_photo_id_foreign` (`photo_id`),
    KEY `photo_product_product_id_foreign` (`product_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.photo_slide
  CREATE TABLE IF NOT EXISTS `photo_slide` (
    `photo_id` int(10) unsigned NOT NULL,
    `slide_id` int(10) unsigned NOT NULL,
    KEY `photo_slide_photo_id_foreign` (`photo_id`),
    KEY `photo_slide_slide_id_foreign` (`slide_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.photo_variety
  CREATE TABLE IF NOT EXISTS `photo_variety` (
    `photo_id` int(11) DEFAULT NULL,
    `variety_id` int(11) DEFAULT NULL,
    KEY `photo_variety_photo_id_foriegn` (`photo_id`),
    KEY `photo_variety_variety_id_foriegn` (`variety_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.products
  CREATE TABLE IF NOT EXISTS `products` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `sku` varchar(191) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
    `slug` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `status` tinyint(4) NOT NULL,
    `price` double(8,2) NOT NULL,
    `discount_price` double(8,2) DEFAULT NULL,
    `short_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `long_description` text COLLATE utf8mb4_unicode_ci NOT NULL,
    `video_id` int(10) unsigned DEFAULT NULL,
    `brand_id` int(10) unsigned NOT NULL,
    `user_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `products_slug_unique` (`slug`),
    UNIQUE KEY `products_sku_unique` (`sku`),
    KEY `products_video_id_foreign` (`video_id`),
    KEY `products_brand_id_foreign` (`brand_id`),
    KEY `products_user_id_foreign` (`user_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.slides
  CREATE TABLE IF NOT EXISTS `slides` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `title` varchar(50) COLLATE utf8mb4_persian_ci DEFAULT NULL,
    `status` varchar(50) COLLATE utf8mb4_persian_ci DEFAULT 'deactive',
    `description` text COLLATE utf8mb4_persian_ci,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.users
  CREATE TABLE IF NOT EXISTS `users` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `email_verified_at` timestamp NULL DEFAULT NULL,
    `password` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `remember_token` varchar(100) 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=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.varieties
  CREATE TABLE IF NOT EXISTS `varieties` (
    `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
    `product_id` int(11) unsigned NOT NULL,
    `color` varchar(50) COLLATE utf8mb4_persian_ci DEFAULT NULL,
    `price` float DEFAULT NULL,
    `discount_price` float DEFAULT NULL,
    `sku` int(11) unsigned NOT NULL,
    `title` varchar(255) COLLATE utf8mb4_persian_ci NOT NULL,
    `slug` varchar(255) COLLATE utf8mb4_persian_ci NOT NULL,
    `status` int(10) unsigned NOT NULL,
    `user_id` int(11) NOT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `product_id` (`product_id`),
    KEY `varieties_user_id` (`user_id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_persian_ci;
  
  -- Data exporting was unselected.
  
  -- Dumping structure for table sensorbaba_db.videos
  CREATE TABLE IF NOT EXISTS `videos` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `path` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `original_name` varchar(191) COLLATE utf8mb4_unicode_ci NOT NULL,
    `user_id` int(10) unsigned NOT NULL,
    `product_id` int(10) unsigned NOT NULL,
    `created_at` timestamp NULL DEFAULT NULL,
    `updated_at` timestamp NULL DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `videos_user_id_foreign` (`user_id`),
    KEY `videos_product_id_foreign` (`product_id`)
  ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
  
  -- Data exporting was unselected.
  
  /*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
  /*!40014 SET FOREIGN_KEY_CHECKS=IFNULL(@OLD_FOREIGN_KEY_CHECKS, 1) */;
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40111 SET SQL_NOTES=IFNULL(@OLD_SQL_NOTES, 1) */;
  