-- https://www.phpmyadmin.net/
--

START TRANSACTION;



-- --------------------------------------------------------

--
-- Table structure for table `areas`
--

CREATE TABLE `areas` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `governorate_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shipping_cost` double(10,2) NOT NULL,
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `attributes`
--

CREATE TABLE `attributes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attributes`
--

INSERT INTO `attributes` (`id`, `title`, `arabic_title`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(2, 'attriute value2', 'title2', '1', NULL, '2023-03-21 23:13:49', '2023-03-21 23:13:49'),
(3, 'Color', 'Color', '1', NULL, '2023-05-09 07:05:52', '2023-05-09 07:05:52');

-- --------------------------------------------------------

--
-- Table structure for table `attribute_values`
--

CREATE TABLE `attribute_values` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `attribute_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `color_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `attribute_values`
--

INSERT INTO `attribute_values` (`id`, `attribute_id`, `title`, `arabic_title`, `color_code`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(3, 3, 'green', 'green ar', '#0bcf07', '1', NULL, '2023-03-22 04:46:37', '2023-05-23 06:33:57'),
(4, 3, 'red', 'red ar', '#df2020', '1', NULL, '2023-03-22 04:46:45', '2023-05-23 06:33:24');

-- --------------------------------------------------------

--
-- Table structure for table `banners`
--

CREATE TABLE `banners` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `banner_url` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `banners`
--

INSERT INTO `banners` (`id`, `title`, `arabic_title`, `description`, `arabic_description`, `banner_url`, `image`, `status`, `created_at`, `updated_at`) VALUES
(1, 'banner', 'banner', 'banner', 'banner', NULL, '1684221286_slide1.png', '1', '2023-05-16 01:15:11', '2023-05-16 01:44:46'),
(2, '2nd slide', '2nd slide ar', '2nd  dec', '2nd slide desc  ar', NULL, '1684221326_slide4.png', '1', '2023-05-16 01:45:26', '2023-05-16 01:45:26'),
(3, 'signup', 's', 's', 's', NULL, '1684299708_footer-bg.png', '1', '2023-05-16 23:31:48', '2023-05-16 23:31:48');

-- --------------------------------------------------------

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

CREATE TABLE `brands` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `brands` (`id`, `title`, `arabic_title`, `slug`, `logo`, `image`, `status`, `created_at`, `updated_at`) VALUES
(1, 'nike', 'nike', 'nike', '1684818888_01.webp', '1684818888_02.webp', '1', '2023-05-22 23:44:48', '2023-05-22 23:44:48'),
(2, 'Puma', 'Puma ar', 'puma', '1684838581_05.webp', '1684838581_05.webp', '1', '2023-05-23 05:13:01', '2023-05-23 05:13:01'),
(3, 'Addibas', 'Addibas ar', 'addibas', '1684838605_07.webp', '1684838605_08.webp', '1', '2023-05-23 05:13:25', '2023-05-23 05:13:25');

-- --------------------------------------------------------

--
-- Table structure for table `careers`
--

CREATE TABLE `careers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `job_id` int(11) DEFAULT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `dob` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `additional_info` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `file` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `carts`
--

CREATE TABLE `carts` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `user_ip` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `variant_id` int(11) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `coupon_id` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `cart_products`
--

CREATE TABLE `cart_products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `cart_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `variant_id` int(11) DEFAULT NULL,
  `quantity` int(11) DEFAULT NULL,
  `price` double(10,3) NOT NULL DEFAULT 0.000,
  `discount` double(10,3) NOT NULL DEFAULT 0.000,
  `tax` double(10,3) NOT NULL DEFAULT 0.000,
  `shipping_cost` double(10,3) NOT NULL DEFAULT 0.000,
  `shipping_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `arabic_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `parent_category_id` int(11) NOT NULL DEFAULT 0,
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` (`id`, `title`, `slug`, `arabic_title`, `description`, `arabic_description`, `image`, `parent_category_id`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'Men', 'men', 'Men ar', 'Men desc', 'Men desc ar', '1684839054_02.png', 0, '1', NULL, '2023-03-17 04:20:47', '2023-05-23 05:28:14'),
(2, 'Women', 'women', 'Women ar', 'Women desc', 'Women desc ar', '1684838822_imagesTest.jpg', 0, '1', NULL, '2023-03-17 04:25:00', '2023-05-23 05:28:02'),
(3, 'Kids', 'kids', 'Kids ar', 'kids desc', 'kids desc ar', '1684840488_02.png', 0, '1', NULL, '2023-05-23 05:44:48', '2023-05-23 05:44:48');

-- --------------------------------------------------------

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

CREATE TABLE `coupons` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_code` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` enum('percentage','flat') COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `usage_limit` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) 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()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `governorates`
--

CREATE TABLE `governorates` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `home_contents`
--

CREATE TABLE `home_contents` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slider_banner_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slider_banner_id2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `banner_type` int(11) NOT NULL DEFAULT 0,
  `product1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product3` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `must_have_product_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mid_slider` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sales_banner1` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sales_banner2` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sales_banner3` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `signup` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB 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, '2019_12_14_000001_create_personal_access_tokens_table', 1),
(5, '2016_06_01_000001_create_oauth_auth_codes_table', 2),
(6, '2016_06_01_000002_create_oauth_access_tokens_table', 2),
(7, '2016_06_01_000003_create_oauth_refresh_tokens_table', 2),
(8, '2016_06_01_000004_create_oauth_clients_table', 2),
(9, '2016_06_01_000005_create_oauth_personal_access_clients_table', 2),
(11, '2023_03_14_125213_create_admins_tables', 3),
(12, '2023_03_16_065623_create_categories_table', 4),
(13, '2023_03_17_072927_create_products_table', 5),
(14, '2023_03_20_050607_add_status_in_users_table', 6),
(15, '2023_03_20_073300_create_sub_categories_table', 6),
(16, '2023_03_20_095136_create_attributes_table', 6),
(17, '2023_03_20_102748_create_attribute_values_table', 6),
(18, '2023_03_21_073927_create_product_gallery', 7),
(19, '2023_03_22_044104_create_product_variants', 8),
(20, '2023_03_22_050519_create_variant_attributes', 8),
(21, '2023_03_24_100434_create_coupons_table', 9),
(22, '2023_03_27_055318_add_column_subcategory_id', 9),
(23, '2023_03_27_092336_create_governorates_table', 10),
(24, '2023_03_27_114609_create_areas_table', 10),
(25, '2023_03_28_052642_create_user_addresses', 11),
(26, '2023_03_28_054927_create_orders', 11),
(27, '2023_03_28_062759_create_order_items', 11),
(28, '2023_03_29_053738_create_pages_table', 12),
(29, '2023_03_31_065547_add_transaction_status_in_orders_table', 12),
(30, '2023_04_04_094233_create_home_contents_table', 12),
(31, '2023_04_04_124546_create_banners_table', 12),
(32, '2023_04_07_112159_add_slug_in_products_table', 12),
(33, '2023_04_10_124345_create_permission_tables', 12),
(34, '2023_04_11_095707_change_role_in_users_table', 13),
(35, '2023_04_14_055945_create_brands_table', 14),
(36, '2023_04_14_100853_add_brand_id_in_products_table', 14),
(37, '2023_05_09_073348_add_color_code_in_attribute_values_table', 14),
(38, '2023_05_10_093426_create_settings_table', 15),
(39, '2023_05_10_095258_create_reviews_table', 15),
(40, '2023_05_10_101503_create_newsletter_subscribers_table', 15),
(41, '2023_05_12_115005_create_wishlists_table', 16),
(42, '2023_05_24_064225_create_home_contents_tbl', 17),
(43, '2023_05_25_090426_create_cart_products_table', 17),
(44, '2023_05_25_112515_create_cart_table', 17),
(45, '2023_03_28_054929_create_orders', 18),
(46, '2023_06_09_065818_create_table_careers', 18),
(47, '2023_06_09_0715277_create_jobs_table', 18);

-- --------------------------------------------------------

--
-- Table structure for table `model_has_permissions`
--

CREATE TABLE `model_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `model_has_roles`
--

CREATE TABLE `model_has_roles` (
  `role_id` bigint(20) UNSIGNED NOT NULL,
  `model_type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `model_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_has_roles`
--

INSERT INTO `model_has_roles` (`role_id`, `model_type`, `model_id`) VALUES
(21, 'App\\Models\\User', 51),
(22, 'App\\Models\\User', 52);

-- --------------------------------------------------------

--
-- Table structure for table `newsletter_subscribers`
--

CREATE TABLE `newsletter_subscribers` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `ip_address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `newsletter_subscribers`
--

INSERT INTO `newsletter_subscribers` (`id`, `user_id`, `email`, `ip_address`, `created_at`, `updated_at`) VALUES
(1, NULL, 'test@gmail.com', NULL, '2023-05-10 07:22:48', '2023-05-10 07:22:48'),
(2, NULL, 'admin@admin.com', NULL, '2023-05-10 07:23:18', '2023-05-10 07:23:18'),
(3, NULL, 'anuj.thakur@hashstudioz.com', NULL, '2023-05-10 07:30:00', '2023-05-10 07:30:00'),
(4, NULL, 'thaku@b', '::1', '2023-05-11 04:27:36', '2023-05-11 04:27:36'),
(5, NULL, 'thakuf@db', '::1', '2023-05-11 04:36:08', '2023-05-11 04:36:08'),
(6, NULL, 'test123ac@gmail.com', '::1', '2023-05-16 06:16:01', '2023-05-16 06:16:01'),
(7, NULL, 'testBr@gmail.com', '::1', '2023-05-16 06:16:54', '2023-05-16 06:16:54');

-- --------------------------------------------------------

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

CREATE TABLE `oauth_auth_codes` (
  `id` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `scopes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `revoked` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `client_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `oauth_personal_access_clients` (`id`, `client_id`, `created_at`, `updated_at`) VALUES
(1, 1, '2023-03-14 00:53:11', '2023-03-14 00:53:11');

-- --------------------------------------------------------

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

CREATE TABLE `orders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` bigint(20) DEFAULT NULL,
  `address_id` bigint(20) DEFAULT NULL,
  `coupon_id` int(11) DEFAULT NULL,
  `coupon_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `coupon_type` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `coupon_amount` int(11) DEFAULT NULL,
  `coupon_discount` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `grand_total` int(11) DEFAULT NULL,
  `checkout_total` int(11) DEFAULT NULL,
  `payment_type` enum('online','cod') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'online',
  `transaction_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `transaction_status` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lng` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `full_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `governorate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `area` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `building_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `appartment_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `near_location` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL,
  `order_status` enum('New','Order Process','Order Shipped','Out For Delivery','Delivered','Cancelled') COLLATE utf8mb4_unicode_ci NOT NULL,
  `notes` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

--
-- Table structure for table `order_items`
--

CREATE TABLE `order_items` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `order_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `quantity` int(11) DEFAULT NULL,
  `item_price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `pages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `pages` (`id`, `slug`, `title`, `arabic_title`, `description`, `arabic_description`, `image`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 'delivery-information', 'Delivery Information', 'معلومات التوصيل', NULL, NULL, NULL, '1', NULL, '2023-05-09 06:54:27', '2023-05-09 06:54:27'),
(2, 'terms-and-condition-of-sale', 'Terms And Conditions of Sale', 'شروط وأحكام البيع', NULL, NULL, NULL, '1', NULL, '2023-05-09 06:54:27', '2023-05-09 06:54:27'),
(3, 'terms-and-condition', 'Website Terms And Conditions', 'شروط وأحكام موقع الويب', NULL, NULL, NULL, '1', NULL, '2023-05-09 06:54:27', '2023-05-09 06:54:27'),
(4, 'privacy-policy', 'Privacy Policy', 'سياسة الخصوصية', '<h2 style=\"font-family: var(--poppins); color: rgb(67, 67, 67);\">Nemo enim ipsam voluptatem quias</h2><p style=\"font-size: 16.2px; font-family: Yantramanav, sans-serif; color: rgb(67, 67, 67);\">Aperiam totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur? Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse quam nihil molestiae consequatur, vel illum qui dolorem eum fugiat quo voluptas nulla pariatur</p><h2 style=\"font-family: var(--poppins); color: rgb(67, 67, 67);\">Reprehenderit aute irure dolor in reprehenderit</h2><p style=\"font-size: 16.2px; font-family: Yantramanav, sans-serif; color: rgb(67, 67, 67);\">Consectetur adipiscing elit, Lorem ipsum dolor sit amet, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit anim id est laborum.</p><p style=\"font-size: 16.2px; font-family: Yantramanav, sans-serif; color: rgb(67, 67, 67);\">Laudantium sed ut perspiciatis unde omnis iste natus error sit voluptatem accusantium doloremque laudantium, totam rem aperiam, eaque ipsa quae ab illo inventore veritatis et quasi architecto beatae vitae dicta sunt explicabo. Nemo enim ipsam voluptatem quia voluptas sit aspernatur aut odit aut fugit, sed quia consequuntur magni dolores eos qui ratione voluptatem sequi nesciunt. Neque porro quisquam est, qui dolorem ipsum quia dolor sit amet, consectetur, adipisci velit, sed quia non numquam eius modi tempora incidunt ut labore et dolore magnam aliquam quaerat voluptatem. Ut enim ad minima veniam, quis nostrum exercitationem ullam corporis suscipit laboriosam, nisi ut aliquid ex ea commodi consequatur? Quis autem vel eum iure reprehenderit qui in ea voluptate velit esse quam nihil molestiae consequatur, vel illum qui dolorem eum fugiat quo voluptas nulla pariatur</p><h3 style=\"font-family: var(--poppins); color: rgb(67, 67, 67);\">Excepteur sint occaecat cupidatat</h3><p style=\"font-size: 16.2px; font-family: Yantramanav, sans-serif; color: rgb(67, 67, 67);\">Voluptate Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur. Excepteur sint occaecat cupidatat non proident, sunt in culpa qui officia deserunt mollit</p>', NULL, NULL, '1', NULL, '2023-05-09 06:54:27', '2023-05-16 00:18:42'),
(5, 'returns-refunds', 'Returns And Refunds', 'الأستبدال والترجيع', NULL, NULL, NULL, '1', NULL, '2023-05-09 06:54:27', '2023-05-09 06:54:27');

-- --------------------------------------------------------

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

CREATE TABLE `permissions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `permissions` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(247, 'dashboard', 'web', '2023-05-09 23:50:49', '2023-05-09 23:50:49'),
(248, 'order_view', 'web', '2023-05-09 23:50:49', '2023-05-09 23:50:49'),
(249, 'order_edit', 'web', '2023-05-09 23:50:49', '2023-05-09 23:50:49'),
(250, 'category_create', 'web', '2023-05-09 23:50:49', '2023-05-09 23:50:49'),
(251, 'category_view', 'web', '2023-05-09 23:50:49', '2023-05-09 23:50:49'),
(252, 'category_edit', 'web', '2023-05-09 23:50:49', '2023-05-09 23:50:49'),
(253, 'category_delete', 'web', '2023-05-09 23:50:49', '2023-05-09 23:50:49'),
(254, 'sub_category_create', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(255, 'sub_category_view', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(256, 'sub_category_edit', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(257, 'sub_category_delete', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(258, 'banner_create', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(259, 'banner_view', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(260, 'banner_edit', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(261, 'banner_delete', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(262, 'home_content_create', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(263, 'home_content_view', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(264, 'home_content_edit', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(265, 'attribute_create', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(266, 'attribute_view', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(267, 'attribute_edit', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(268, 'attribute_delete', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(269, 'attribute_value_create', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(270, 'attribute_value_view', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(271, 'attribute_value_edit', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(272, 'attribute_value_delete', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(273, 'product_create', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(274, 'product_view', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(275, 'product_edit', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(276, 'product_delete', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(277, 'users_create', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(278, 'users_view', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(279, 'users_edit', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(280, 'users_delete', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(281, 'coupon_create', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(282, 'coupon_view', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(283, 'coupon_edit', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(284, 'coupon_delete', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(285, 'governorate_create', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(286, 'governorate_view', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(287, 'governorate_edit', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(288, 'governorate_delete', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(289, 'area_create', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(290, 'area_view', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(291, 'area_edit', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(292, 'area_delete', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(293, 'page_create', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(294, 'page_view', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(295, 'page_edit', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(296, 'page_delete', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(297, 'report_view', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(298, 'role_create', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(299, 'role_view', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(300, 'role_edit', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(301, 'role_delete', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(302, 'permission_create', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(303, 'permission_view', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(304, 'permission_edit', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(305, 'permission_delete', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(306, 'brand_create', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(307, 'brand_view', 'web', '2023-05-09 23:50:50', '2023-05-09 23:50:50'),
(308, 'brand_edit', 'web', '2023-05-09 23:50:51', '2023-05-09 23:50:51'),
(309, 'brand_delete', 'web', '2023-05-09 23:50:51', '2023-05-09 23:50:51');

-- --------------------------------------------------------

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

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `priority` int(11) NOT NULL DEFAULT 0,
  `description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_description` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `brand_id` bigint(20) DEFAULT NULL,
  `category_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sub_category_id` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `products` (`id`, `title`, `arabic_title`, `slug`, `priority`, `description`, `arabic_description`, `brand_id`, `category_id`, `sub_category_id`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(45, 'testws', 'ddd', NULL, 1, 'ddsdd', 'd', NULL, '[\"2\"]', NULL, '1', NULL, '2023-03-21 06:51:59', '2023-03-21 07:07:37'),
(46, 'dd', 'fs', NULL, 1, 'ds', 'sf', NULL, '[\"1\"]', NULL, '1', '2023-03-22 04:27:53', '2023-03-21 07:26:46', '2023-03-22 04:27:53'),
(47, 'ddd', 'dd', NULL, 1, 'dd', 'd', NULL, '[\"2\"]', NULL, '1', '2023-03-22 04:27:48', '2023-03-22 02:09:57', '2023-03-22 04:27:48'),
(49, 'testVaiant1', 'testVaiant1', NULL, 1, 'testVaiant1', 'testVaiant1', NULL, '[\"1\"]', NULL, '1', '2023-03-22 04:27:43', '2023-03-22 04:13:25', '2023-03-22 04:27:43'),
(50, 'qedf', 'fa', NULL, 2, 'af', 'af', NULL, '[\"2\"]', NULL, '1', '2023-03-22 04:27:39', '2023-03-22 04:15:09', '2023-03-22 04:27:39'),
(51, 'ef', 'dsf', NULL, 1, 'fe', 'FE', NULL, '[\"1\"]', NULL, '1', '2023-03-22 04:27:34', '2023-03-22 04:25:19', '2023-03-22 04:27:34'),
(52, 'EF', 'f', NULL, 2, 'f', 'F', NULL, '[\"1\"]', NULL, '1', '2023-03-22 04:27:29', '2023-03-22 04:26:30', '2023-03-22 04:27:29'),
(53, 'sad', 'asd', NULL, 2, 'as', 'das', NULL, '[\"2\"]', NULL, '1', NULL, '2023-03-22 04:45:01', '2023-03-22 04:45:01'),
(54, 'af', 'af', NULL, 2, 'af', 'af', NULL, '[\"1\"]', NULL, '1', NULL, '2023-03-22 04:48:31', '2023-03-22 04:48:31'),
(55, 'asc', 'sv', NULL, 2, 'sv', 'sv', NULL, '[\"2\"]', NULL, '1', NULL, '2023-03-22 05:23:22', '2023-03-22 05:23:22'),
(56, 'ad', 'ad', NULL, 2, 'ad', 'ad', NULL, '[\"2\"]', NULL, '1', NULL, '2023-03-22 05:31:50', '2023-03-22 05:31:50'),
(57, 'daf', 'wf', NULL, 2, 'sf', 'fw', NULL, '[\"1\"]', NULL, '1', NULL, '2023-03-22 06:04:00', '2023-03-22 06:04:00'),
(58, 'wqf', 'sg', NULL, 2, 'sf', 'sg', NULL, '[\"2\"]', NULL, '1', NULL, '2023-03-22 06:12:07', '2023-03-22 06:12:07'),
(59, 'plain shirt', 'plain shirt AR', 'plain-shirt', 1, 'plain shirt DESC', 'plain shirt DESC AR', 1, '[\"1\",\"2\"]', '[\"1\"]', '1', NULL, '2023-03-22 22:53:00', '2023-05-23 06:35:18'),
(60, 'jordan', 'jordan', 'jordan', 2, 'nike1prod', 'nike1prod', 1, '[\"2\"]', '[\"2\"]', '1', NULL, '2023-05-22 23:45:18', '2023-05-23 06:36:38'),
(61, 'black jeans', 'black jeans ar', 'black-jeans', 3, 'black jeans desc', 'black jeans desc  ar', 1, '[\"1\"]', '[\"3\"]', '1', NULL, '2023-05-23 06:32:02', '2023-05-23 06:32:02'),
(62, 'fit jeans', 'fit jeans ar', 'fit-jeans', 3, 'fit jeans desc', 'fit jeans desc ar', 2, '[\"1\"]', '[\"3\"]', '1', NULL, '2023-05-23 06:38:31', '2023-05-23 06:38:31'),
(63, 'school bag', 'school bag ar', 'school-bag', 12, 'school bag desc', 'school bag  desc ar', 3, '[\"3\"]', '[\"4\"]', '1', NULL, '2023-05-23 06:43:44', '2023-05-23 06:43:44');

-- --------------------------------------------------------

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

CREATE TABLE `product_gallery` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `product_gallery` (`id`, `product_id`, `image`, `created_at`, `updated_at`) VALUES
(5, 45, '1679401359_Screenshot (1).png', '2023-03-21 06:52:39', '2023-03-21 06:52:39'),
(6, 45, '1679401359_Screenshot (2).png', '2023-03-21 06:52:39', '2023-03-21 06:52:39'),
(7, 47, '1679470802_Screenshot (1).png', '2023-03-22 02:10:02', '2023-03-22 02:10:02'),
(8, 47, '1679477006_Screenshot (3).png', '2023-03-22 03:53:26', '2023-03-22 03:53:26'),
(10, 49, '1679478210_Screenshot (1).png', '2023-03-22 04:13:30', '2023-03-22 04:13:30'),
(11, 50, '1679478314_Screenshot (1).png', '2023-03-22 04:15:14', '2023-03-22 04:15:14'),
(12, 51, '1679478930_Screenshot (3).png', '2023-03-22 04:25:30', '2023-03-22 04:25:30'),
(13, 52, '1679478994_Screenshot (2).png', '2023-03-22 04:26:34', '2023-03-22 04:26:34'),
(14, 53, '1679480112_Screenshot (7).png', '2023-03-22 04:45:12', '2023-03-22 04:45:12'),
(15, 54, '1679480315_Screenshot (3).png', '2023-03-22 04:48:35', '2023-03-22 04:48:35'),
(16, 55, '1679482406_Screenshot (2).png', '2023-03-22 05:23:26', '2023-03-22 05:23:26'),
(17, 56, '1679482915_Screenshot (1).png', '2023-03-22 05:31:55', '2023-03-22 05:31:55'),
(18, 57, '1679484844_Screenshot (2).png', '2023-03-22 06:04:04', '2023-03-22 06:04:04'),
(19, 58, '1679485332_Screenshot (2).png', '2023-03-22 06:12:12', '2023-03-22 06:12:12'),
(21, 59, '1684310062_01.webp', '2023-05-17 02:24:22', '2023-05-17 02:24:22'),
(22, 60, '1684818924_04.webp', '2023-05-22 23:45:24', '2023-05-22 23:45:24'),
(23, 61, '1684843329_02.png', '2023-05-23 06:32:09', '2023-05-23 06:32:09'),
(24, 62, '1684843721_02.png', '2023-05-23 06:38:41', '2023-05-23 06:38:41'),
(25, 63, '1684844030_07.png', '2023-05-23 06:43:50', '2023-05-23 06:43:50');

-- --------------------------------------------------------

--
-- Table structure for table `product_variants`
--

CREATE TABLE `product_variants` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `stock` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `barcode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sku` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `currency` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `special_price` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `product_variants`
--

INSERT INTO `product_variants` (`id`, `product_id`, `stock`, `barcode`, `sku`, `currency`, `price`, `special_price`, `created_at`, `updated_at`) VALUES
(24, 59, 'stcko1', 'stcko1', 'stcko1', 'KWD', '120', '60', '2023-03-23 01:42:50', '2023-03-23 01:42:50'),
(25, 59, 'stcko2', 'stcko2', 'stcko2', '2', '2', '2', '2023-03-23 01:42:50', '2023-03-23 01:42:50'),
(26, 59, 'd', 'dd', 'sku', 'KWD', '120', '60', '2023-05-17 01:01:55', '2023-05-17 01:01:55'),
(27, 60, '1', '11', '1', 'KWD', '120', '111', '2023-05-22 23:45:47', '2023-05-22 23:45:47'),
(28, 61, 'stock', 'code', 'skuSs', 'KWD', '120', '100', '2023-05-23 06:34:07', '2023-05-23 06:34:07'),
(29, 62, '2', 'code', 'sku', 'KWD', '11000', '9000', '2023-05-23 06:39:12', '2023-05-23 06:39:12'),
(30, 63, 'd', 'ww', 'sku', 'KWD', '1200', '1000', '2023-05-23 06:44:11', '2023-05-23 06:44:11');

-- --------------------------------------------------------

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rating` int(11) NOT NULL,
  `helpful` int(11) NOT NULL DEFAULT 0,
  `unhelpful` int(11) NOT NULL DEFAULT 0,
  `comment` text COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

-- --------------------------------------------------------

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

CREATE TABLE `roles` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `guard_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `roles` (`id`, `name`, `guard_name`, `created_at`, `updated_at`) VALUES
(21, 'superadmin', 'web', '2023-05-09 23:50:51', '2023-05-09 23:50:51'),
(22, 'admin', 'web', '2023-05-09 23:50:51', '2023-05-09 23:50:51'),
(23, 'user', 'web', '2023-05-09 23:50:51', '2023-05-09 23:50:51');

-- --------------------------------------------------------

--
-- Table structure for table `role_has_permissions`
--

CREATE TABLE `role_has_permissions` (
  `permission_id` bigint(20) UNSIGNED NOT NULL,
  `role_id` bigint(20) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_has_permissions`
--

INSERT INTO `role_has_permissions` (`permission_id`, `role_id`) VALUES
(247, 21),
(248, 21),
(249, 21),
(250, 21),
(251, 21),
(252, 21),
(253, 21),
(254, 21),
(255, 21),
(256, 21),
(257, 21),
(258, 21),
(259, 21),
(260, 21),
(261, 21),
(262, 21),
(263, 21),
(264, 21),
(265, 21),
(266, 21),
(267, 21),
(268, 21),
(269, 21),
(270, 21),
(271, 21),
(272, 21),
(273, 21),
(274, 21),
(275, 21),
(276, 21),
(277, 21),
(278, 21),
(279, 21),
(280, 21),
(281, 21),
(282, 21),
(283, 21),
(284, 21),
(285, 21),
(286, 21),
(287, 21),
(288, 21),
(289, 21),
(290, 21),
(291, 21),
(292, 21),
(293, 21),
(294, 21),
(295, 21),
(296, 21),
(297, 21),
(298, 21),
(299, 21),
(300, 21),
(301, 21),
(302, 21),
(303, 21),
(304, 21),
(305, 21),
(306, 21),
(307, 21),
(308, 21),
(309, 21);

-- --------------------------------------------------------

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

CREATE TABLE `settings` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `logo` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `admin_email` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `facebook_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `insta_link` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `twitter_link` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `linkedin_link` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pinterest_link` varchar(32) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `low_inventory_alert_value` int(11) NOT NULL DEFAULT 0,
  `default_shipping_cost` double(10,2) NOT NULL DEFAULT 0.00,
  `tax_prcnt` int(11) NOT NULL DEFAULT 0,
  `contact_us_email` varchar(62) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_us_phone` varchar(62) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_us_address` varchar(62) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `settings` (`id`, `logo`, `admin_email`, `facebook_link`, `insta_link`, `twitter_link`, `linkedin_link`, `pinterest_link`, `low_inventory_alert_value`, `default_shipping_cost`, `tax_prcnt`, `contact_us_email`, `contact_us_phone`, `contact_us_address`, `created_at`, `updated_at`) VALUES
(2, NULL, 'anuj.thakur@hashstudioz.com', 'x', 's', 'Twitter', 'Linkedin', 'Pinterest', 2, 1.00, 1, 'info@gmail.com', '+965 45645640', '785 15h Street, Office 478 Berlin M', '2023-05-11 00:04:04', '2023-05-23 00:36:15');

-- --------------------------------------------------------

--
-- Table structure for table `sub_categories`
--

CREATE TABLE `sub_categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `slug` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_title` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `arabic_description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `image` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '0',
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sub_categories`
--

INSERT INTO `sub_categories` (`id`, `category_id`, `title`, `slug`, `arabic_title`, `description`, `arabic_description`, `image`, `status`, `deleted_at`, `created_at`, `updated_at`) VALUES
(1, 1, 'cotton shirt', 'cotton-shirt', 'cotton shirt ar', 'cotton shirt desc', 'cotton shirt ar desc', '1684840954_02 (1).png', '1', NULL, '2023-03-26 23:06:09', '2023-05-23 05:52:34'),
(2, 2, 'Shoes', 'shoes', 'Shoes ar', 'Shoes desc', 'Shoes desc ar', '1684841953_02.png', '1', NULL, '2023-05-23 06:09:13', '2023-05-23 06:09:13'),
(3, 1, 'Long jeans', 'long-jeans', 'Long jeans ar', 'Long jeans desc', 'Long jeans desc ar', '1684843241_02.png', '1', NULL, '2023-05-23 06:30:41', '2023-05-23 06:30:41'),
(4, 3, 'bags', 'bags', 'bags ar', 'bags desc', 'bags desc ar', '1684843963_07.png', '1', NULL, '2023-05-23 06:42:43', '2023-05-23 06:42:43');

-- --------------------------------------------------------

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

CREATE TABLE `user_addresses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `first_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_name` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `house_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `contact_no` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `appartment` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `landmark` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pincode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_type` enum('home','office','other') COLLATE utf8mb4_unicode_ci NOT NULL,
  `governorate` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `area` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lat` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lng` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` enum('1','0') COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `user_addresses` (`id`, `user_id`, `first_name`, `last_name`, `house_no`, `contact_no`, `appartment`, `landmark`, `pincode`, `address_type`, `governorate`, `area`, `address`, `lat`, `lng`, `status`, `created_at`, `updated_at`) VALUES
(1, 52, 'anuj12', 'lakur2', '11112', '9876543212', 'appartment 2', 'khmb2', '178872', 'office', '2', 'area1', 'address2', NULL, NULL, '1', NULL, '2023-05-19 05:13:27'),
(2, 52, 'anuj', 'lakur', '1111', '9876543211', 'appartment 1', 'khmba', '178876', 'other', 'w', 'area1', 'address1', NULL, NULL, '1', NULL, NULL);

-- --------------------------------------------------------

--
-- Table structure for table `variant_attributes`
--

CREATE TABLE `variant_attributes` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `variant_id` bigint(20) UNSIGNED NOT NULL,
  `attribute_id` bigint(20) UNSIGNED NOT NULL,
  `attribute_val_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `variant_attributes`
--

INSERT INTO `variant_attributes` (`id`, `product_id`, `variant_id`, `attribute_id`, `attribute_val_id`, `created_at`, `updated_at`) VALUES
(45, 59, 25, 2, 3, '2023-03-23 01:42:50', '2023-03-23 01:42:50'),
(46, 59, 25, 2, 4, '2023-03-23 01:42:50', '2023-03-23 01:42:50'),
(47, 59, 26, 2, 3, '2023-05-17 01:01:55', '2023-05-17 01:01:55'),
(48, 59, 24, 2, 4, '2023-05-17 02:24:28', '2023-05-17 02:24:28'),
(49, 59, 24, 2, 3, '2023-05-17 02:24:28', '2023-05-17 02:24:28'),
(50, 60, 27, 2, 3, '2023-05-22 23:45:47', '2023-05-22 23:45:47'),
(51, 61, 28, 3, 3, '2023-05-23 06:34:07', '2023-05-23 06:34:07'),
(52, 62, 29, 3, 4, '2023-05-23 06:39:12', '2023-05-23 06:39:12'),
(53, 63, 30, 3, 3, '2023-05-23 06:44:11', '2023-05-23 06:44:11');

-- --------------------------------------------------------

--
-- Table structure for table `wishlists`
--

CREATE TABLE `wishlists` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` int(11) DEFAULT NULL,
  `product_id` int(11) DEFAULT NULL,
  `variant_id` int(32) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `wishlists`
--

INSERT INTO `wishlists` (`id`, `user_id`, `product_id`, `variant_id`, `created_at`, `updated_at`) VALUES
(4, 52, 59, 24, '2023-05-22 03:40:11', '2023-05-22 03:40:11'),
(69, 51, 60, 27, '2023-05-23 06:48:08', '2023-05-23 06:48:08');

--
-- Indexes for table `areas`
--
ALTER TABLE `areas`
  ADD PRIMARY KEY (`id`),
  ADD KEY `areas_governorate_id_index` (`governorate_id`);

--
-- Indexes for table `attributes`
--
ALTER TABLE `attributes`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `attribute_values`
--
ALTER TABLE `attribute_values`
  ADD PRIMARY KEY (`id`),
  ADD KEY `attribute_values_attribute_id_index` (`attribute_id`);

--
-- Indexes for table `banners`
--
ALTER TABLE `banners`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `brands`
--
ALTER TABLE `brands`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `careers`
--
ALTER TABLE `careers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `carts`
--
ALTER TABLE `carts`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `cart_products`
--
ALTER TABLE `cart_products`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `categories`
--
ALTER TABLE `categories`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `categories_slug_unique` (`slug`);

--
-- Indexes for table `coupons`
--
ALTER TABLE `coupons`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `governorates`
--
ALTER TABLE `governorates`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `home_contents`
--
ALTER TABLE `home_contents`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`model_id`,`model_type`),
  ADD KEY `model_has_permissions_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD PRIMARY KEY (`role_id`,`model_id`,`model_type`),
  ADD KEY `model_has_roles_model_id_model_type_index` (`model_id`,`model_type`);

--
-- Indexes for table `newsletter_subscribers`
--
ALTER TABLE `newsletter_subscribers`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `oauth_auth_codes`
--
ALTER TABLE `oauth_auth_codes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_auth_codes_user_id_index` (`user_id`);

--
-- Indexes for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `orders`
--
ALTER TABLE `orders`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `order_items`
--
ALTER TABLE `order_items`
  ADD PRIMARY KEY (`id`),
  ADD KEY `order_items_order_id_index` (`order_id`),
  ADD KEY `order_items_product_id_index` (`product_id`);

--
-- Indexes for table `pages`
--
ALTER TABLE `pages`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `permissions`
--
ALTER TABLE `permissions`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `permissions_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `product_gallery`
--
ALTER TABLE `product_gallery`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_gallery_product_id_index` (`product_id`);

--
-- Indexes for table `product_variants`
--
ALTER TABLE `product_variants`
  ADD PRIMARY KEY (`id`),
  ADD KEY `product_variants_product_id_index` (`product_id`);

--
-- Indexes for table `reviews`
--
ALTER TABLE `reviews`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `roles_name_guard_name_unique` (`name`,`guard_name`);

--
-- Indexes for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD PRIMARY KEY (`permission_id`,`role_id`),
  ADD KEY `role_has_permissions_role_id_foreign` (`role_id`);

--
-- Indexes for table `settings`
--
ALTER TABLE `settings`
  ADD PRIMARY KEY (`id`);

--
-- Indexes for table `sub_categories`
--
ALTER TABLE `sub_categories`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sub_categories_category_id_index` (`category_id`);

--
-- Indexes for table `user_addresses`
--
ALTER TABLE `user_addresses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `user_addresses_user_id_index` (`user_id`);

--
-- Indexes for table `variant_attributes`
--
ALTER TABLE `variant_attributes`
  ADD PRIMARY KEY (`id`),
  ADD KEY `variant_attributes_product_id_index` (`product_id`),
  ADD KEY `variant_attributes_variant_id_index` (`variant_id`),
  ADD KEY `variant_attributes_attribute_id_index` (`attribute_id`),
  ADD KEY `variant_attributes_attribute_val_id_index` (`attribute_val_id`);

--
-- Indexes for table `wishlists`
--
ALTER TABLE `wishlists`
  ADD PRIMARY KEY (`id`);

--
-- AUTO_INCREMENT for table `areas`
--
ALTER TABLE `areas`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `attributes`
--
ALTER TABLE `attributes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `attribute_values`
--
ALTER TABLE `attribute_values`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `banners`
--
ALTER TABLE `banners`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `brands`
--
ALTER TABLE `brands`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `careers`
--
ALTER TABLE `careers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `carts`
--
ALTER TABLE `carts`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `cart_products`
--
ALTER TABLE `cart_products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `governorates`
--
ALTER TABLE `governorates`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `home_contents`
--
ALTER TABLE `home_contents`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `newsletter_subscribers`
--
ALTER TABLE `newsletter_subscribers`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `oauth_personal_access_clients`
--
ALTER TABLE `oauth_personal_access_clients`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `orders`
--
ALTER TABLE `orders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `order_items`
--
ALTER TABLE `order_items`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `pages`
--
ALTER TABLE `pages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `permissions`
--
ALTER TABLE `permissions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=310;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=64;

--
-- AUTO_INCREMENT for table `product_gallery`
--
ALTER TABLE `product_gallery`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `product_variants`
--
ALTER TABLE `product_variants`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `reviews`
--
ALTER TABLE `reviews`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `settings`
--
ALTER TABLE `settings`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `sub_categories`
--
ALTER TABLE `sub_categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `user_addresses`
--
ALTER TABLE `user_addresses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `variant_attributes`
--
ALTER TABLE `variant_attributes`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=54;

--
-- AUTO_INCREMENT for table `wishlists`
--
ALTER TABLE `wishlists`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=70;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `areas`
--
ALTER TABLE `areas`
  ADD CONSTRAINT `areas_governorate_id_foreign` FOREIGN KEY (`governorate_id`) REFERENCES `governorates` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `attribute_values`
--
ALTER TABLE `attribute_values`
  ADD CONSTRAINT `attribute_values_attribute_id_foreign` FOREIGN KEY (`attribute_id`) REFERENCES `attributes` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_permissions`
--
ALTER TABLE `model_has_permissions`
  ADD CONSTRAINT `model_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `model_has_roles`
--
ALTER TABLE `model_has_roles`
  ADD CONSTRAINT `model_has_roles_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `order_items`
--
ALTER TABLE `order_items`
  ADD CONSTRAINT `order_items_order_id_foreign` FOREIGN KEY (`order_id`) REFERENCES `orders` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `order_items_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `product_gallery`
--
ALTER TABLE `product_gallery`
  ADD CONSTRAINT `product_gallery_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `product_variants`
--
ALTER TABLE `product_variants`
  ADD CONSTRAINT `product_variants_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `role_has_permissions`
--
ALTER TABLE `role_has_permissions`
  ADD CONSTRAINT `role_has_permissions_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `role_has_permissions_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `sub_categories`
--
ALTER TABLE `sub_categories`
  ADD CONSTRAINT `sub_categories_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `user_addresses`
--
ALTER TABLE `user_addresses`
  ADD CONSTRAINT `user_addresses_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `variant_attributes`
--
ALTER TABLE `variant_attributes`
  ADD CONSTRAINT `variant_attributes_attribute_id_foreign` FOREIGN KEY (`attribute_id`) REFERENCES `attributes` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `variant_attributes_attribute_val_id_foreign` FOREIGN KEY (`attribute_val_id`) REFERENCES `attribute_values` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `variant_attributes_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `variant_attributes_variant_id_foreign` FOREIGN KEY (`variant_id`) REFERENCES `product_variants` (`id`) ON DELETE CASCADE;
COMMIT;

