multivendor_ecommerce database - SQL Dump File - phpMyAdmin Export.sql

-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Generation Time: Aug 13, 2023 at 11:59 PM
-- Server version: 8.0.28
-- PHP Version: 8.1.4

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
SET time_zone = "+00:00";


/*!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 */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `multivendor_ecommerce`
--

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

--
-- Table structure for table `admins`
--

CREATE TABLE `admins` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `vendor_id` int NOT NULL,
  `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `confirm` enum('No','Yes') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'No',
  `status` tinyint 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 `admins`
--

INSERT INTO `admins` (`id`, `name`, `type`, `vendor_id`, `mobile`, `email`, `password`, `image`, `confirm`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Ahmed Yahya', 'superadmin', 0, '01255686414', 'admin@admin.com', '$2a$12$xvkjSScUPRexfcJTAy9ATutIeGUuRgJrjDIdL/.xlrddEvRZINpeC', 'ahmed.jpg', 'No', 1, NULL, '2022-08-17 18:06:05'),
(2, 'Yasser Fouaad - Vendor', 'vendor', 1, '01259598421', 'yasser@admin.com', '$2a$12$xvkjSScUPRexfcJTAy9ATutIeGUuRgJrjDIdL/.xlrddEvRZINpeC', '83157.jpg', 'Yes', 1, NULL, '2023-01-02 10:10:56'),
(3, 'Samir Morsy', 'vendor', 5, '01154572136', 'samir@yahoo.com', '$2a$12$xvkjSScUPRexfcJTAy9ATutIeGUuRgJrjDIdL/.xlrddEvRZINpeC', NULL, 'No', 1, '2022-10-13 22:55:41', '2022-10-15 21:55:37'),
(4, 'Ramy Saeed', 'vendor', 6, '01098571935', 'ramy@admin.com', '$2a$12$xvkjSScUPRexfcJTAy9ATutIeGUuRgJrjDIdL/.xlrddEvRZINpeC', '', 'Yes', 0, '2022-10-14 01:20:03', '2022-10-15 21:56:18'),
(6, 'Safaa Masoud', 'vendor', 8, '01255374956', 'safaa@vendor.com', '$2a$12$xvkjSScUPRexfcJTAy9ATutIeGUuRgJrjDIdL/.xlrddEvRZINpeC', NULL, 'Yes', 0, '2022-10-14 18:46:53', '2022-10-15 17:10:11'),
(7, 'Ghali Shennway', 'vendor', 9, '01154557789', 'ghali@yahoo.com', '$2a$12$xvkjSScUPRexfcJTAy9ATutIeGUuRgJrjDIdL/.xlrddEvRZINpeC', NULL, 'Yes', 1, '2022-10-14 18:48:28', '2022-10-15 17:10:10');

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

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

CREATE TABLE `banners` (
  `id` bigint UNSIGNED NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `link` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `alt` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint 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 `banners`
--

INSERT INTO `banners` (`id`, `image`, `type`, `link`, `title`, `alt`, `status`, `created_at`, `updated_at`) VALUES
(1, 'banner-1.jpg', 'Slider', 'spring-collection', 'Spring Collection', 'Spring Collection', 1, NULL, '2022-09-26 16:48:57'),
(2, 'banner-2.jpg', 'Slider', 'tops', 'Tops', 'Tops', 1, NULL, '2022-09-26 16:57:36'),
(5, '22225.png', '', 'men', 'men', 'men', 0, '2022-09-25 20:17:36', '2022-09-25 20:57:19'),
(6, '50216.jpg', 'Fix', 'men', 'men', 'men', 1, '2022-09-26 16:55:43', '2022-09-26 16:55:43'),
(7, '6455.jpg', 'Fix', 'test', 'test', 'test', 1, '2022-09-26 16:58:08', '2022-09-26 16:58:08');

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

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

CREATE TABLE `brands` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint 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 `brands`
--

INSERT INTO `brands` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Arrow', 1, NULL, '2022-08-26 23:17:18'),
(2, 'Gap', 1, NULL, '2022-08-26 23:17:18'),
(3, 'Lee', 1, NULL, '2022-08-26 23:17:19'),
(4, 'Samsung', 1, NULL, NULL),
(5, 'LG', 1, NULL, NULL),
(6, 'Lenovo', 1, NULL, NULL),
(7, 'MI', 1, NULL, '2022-08-26 23:17:17'),
(9, 'Others', 1, '2022-08-27 21:39:09', '2022-08-27 21:39:09');

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

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

CREATE TABLE `carts` (
  `id` bigint UNSIGNED NOT NULL,
  `session_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `user_id` int DEFAULT NULL,
  `product_id` int NOT NULL,
  `size` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `quantity` int 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 `carts`
--

INSERT INTO `carts` (`id`, `session_id`, `user_id`, `product_id`, `size`, `quantity`, `created_at`, `updated_at`) VALUES
(2, '7ad795dc60d80e18d539758068e3c4e2', 0, 5, 'Medium', 1, '2022-11-08 17:42:14', '2022-11-08 17:46:52'),
(4, '22ff3817f14d878331bf007d2dcea6f5', 0, 5, 'Small', 8, '2022-11-08 22:09:58', '2022-11-09 00:09:17'),
(9, '6d717cff9f01d04ff7ef2debec9edf31', 0, 5, 'Small', 1, '2022-11-09 10:14:25', '2022-11-09 10:14:25'),
(11, '56254dd8ea2bfb0bf12532b7d3da1a81', 0, 5, 'Medium', 6, '2022-11-13 23:51:35', '2022-11-13 23:58:16'),
(12, '56254dd8ea2bfb0bf12532b7d3da1a81', 0, 5, 'Small', 1, '2022-11-13 23:56:37', '2022-11-13 23:56:37'),
(17, '5088d2b9d971513dc3fbf2b98f3dfb97', 0, 4, 'Small', 3, '2022-12-06 20:59:02', '2022-12-06 23:05:50'),
(42, '5617d343aa7e9b62d5475c899ca3dae3', 1, 5, 'Medium', 1, '2023-03-22 22:24:40', '2023-03-22 23:53:31'),
(67, 'f945daeb6a96dd25613f5da29ec2b2f1', 0, 2, 'Medium', 1, '2023-04-08 13:29:51', '2023-04-08 13:29:51'),
(82, 'af690783e2408f23b745c76873d045b3', 2, 1, '128GB-4GB', 1, '2023-08-07 16:33:02', '2023-08-07 16:33:02');

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

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

CREATE TABLE `categories` (
  `id` bigint UNSIGNED NOT NULL,
  `parent_id` int NOT NULL,
  `section_id` int NOT NULL,
  `category_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `category_discount` double(8,2) NOT NULL DEFAULT '0.00',
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `meta_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `status` tinyint 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 `categories`
--

INSERT INTO `categories` (`id`, `parent_id`, `section_id`, `category_name`, `category_image`, `category_discount`, `description`, `url`, `meta_title`, `meta_description`, `meta_keywords`, `status`, `created_at`, `updated_at`) VALUES
(1, 0, 1, 'Men', '', 0.00, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, 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.', 'men', NULL, NULL, NULL, 1, NULL, '2022-09-29 14:47:51'),
(2, 0, 1, 'Women', '', 0.00, '', 'women', '', '', '', 1, NULL, '2022-08-20 22:38:56'),
(3, 0, 1, 'Kids', '', 0.00, '', 'kids', '', '', '', 1, NULL, '2022-09-22 19:33:59'),
(4, 0, 2, 'Mobiles', '', 10.00, 'test', 'mobiles', 'mobiles', 'mobiles', 'mobiles', 1, '2022-08-21 19:11:28', '2022-08-26 18:27:54'),
(5, 4, 2, 'Smartphones', '', 10.00, 'j', 'smartphones', 'smartphones', 'smartphones', 'smartphones', 1, '2022-08-22 23:30:07', '2022-10-31 21:02:48'),
(6, 1, 1, 'T-Shirts', '', 0.00, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, 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.', 'tshirts', 'Men T-shirts', 'Huge variety of men t-shirts', 'men t-shirts, cotton t-shirts', 1, '2022-08-24 17:58:46', '2023-05-05 18:32:28'),
(7, 1, 1, 'Shirts', '', 0.00, NULL, 'shirts', NULL, NULL, NULL, 1, '2022-08-25 00:09:23', '2022-08-25 00:09:51'),
(8, 2, 1, 'Tops', '', 0.00, NULL, 'tops', NULL, NULL, NULL, 1, '2022-08-25 00:17:42', '2022-08-25 00:17:42'),
(9, 0, 4, 'Refrigerators', '', 0.00, NULL, 'refrigerators', 'Refrigerators', NULL, NULL, 1, '2022-09-22 21:55:53', '2022-09-22 21:55:53');

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

--
-- Table structure for table `cod_pincodes`
--

CREATE TABLE `cod_pincodes` (
  `id` bigint UNSIGNED NOT NULL,
  `pincode` varchar(10) CHARACTER SET utf8mb4 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 `cod_pincodes`
--

INSERT INTO `cod_pincodes` (`id`, `pincode`, `created_at`, `updated_at`) VALUES
(1, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(2, '504293', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(3, '504307', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(4, '504001', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(5, '504001', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(6, '504251', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(7, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(8, '504251', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(9, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(10, '504201', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(11, '504110', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(12, '504202', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(13, '504296', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(14, '504231', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(15, '504109', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(16, '504201', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(17, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(18, '504002', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(19, '504201', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(20, '504204', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(21, '504312', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(22, '504313', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(23, '504101', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(24, '504293', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(25, '504201', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(26, '504204', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(27, '504293', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(28, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(29, '504205', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(30, '504203', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(31, '504295', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(32, '504106', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(33, '504306', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(34, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(35, '504296', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(36, '504101', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(37, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(38, '504203', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(39, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(40, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(41, '504202', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(42, '504251', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(43, '504251', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(44, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(45, '504001', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(46, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(47, '504308', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(48, '504204', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(49, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(50, '504002', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(51, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(52, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(53, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(54, '504001', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(55, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(56, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(57, '504101', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(58, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(59, '504306', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(60, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(61, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(62, '504101', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(63, '504307', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(64, '504110', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(65, '504272', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(66, '504101', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(67, '504251', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(68, '504251', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(69, '504323', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(70, '504293', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(71, '504272', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(72, '504002', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(73, '504215', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(74, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(75, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(76, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(77, '504296', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(78, '504346', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(79, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(80, '504110', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(81, '504002', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(82, '504201', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(83, '504296', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(84, '504205', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(85, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(86, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(87, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(88, '504310', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(89, '504294', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(90, '504306', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(91, '504202', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(92, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(93, '504313', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(94, '504302', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(95, '504002', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(96, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(97, '504206', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(98, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(99, '504346', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(100, '504002', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(101, '504001', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(102, '504202', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(103, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(104, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(105, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(106, '504102', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(107, '504294', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(108, '504293', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(109, '504308', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(110, '504218', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(111, '504201', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(112, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(113, '504313', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(114, '504110', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(115, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(116, '504346', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(117, '504205', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(118, '504231', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(119, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(120, '504203', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(121, '504306', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(122, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(123, '504310', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(124, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(125, '504207', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(126, '504215', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(127, '504201', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(128, '504206', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(129, '504272', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(130, '504296', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(131, '504296', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(132, '504307', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(133, '504102', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(134, '504102', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(135, '504209', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(136, '504104', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(137, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(138, '504001', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(139, '504292', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(140, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(141, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(142, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(143, '504297', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(144, '504346', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(145, '504307', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(146, '504307', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(147, '504219', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(148, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(149, '504207', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(150, '504292', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(151, '504312', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(152, '504110', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(153, '504346', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(154, '504323', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(155, '504293', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(156, '504208', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(157, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(158, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(159, '504215', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(160, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(161, '504308', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(162, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(163, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(164, '504109', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(165, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(166, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(167, '504306', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(168, '504293', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(169, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(170, '504251', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(171, '504308', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(172, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(173, '504346', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(174, '504296', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(175, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(176, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(177, '504207', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(178, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(179, '504205', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(180, '504216', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(181, '504346', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(182, '504295', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(183, '504106', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(184, '504296', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(185, '504215', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(186, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(187, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(188, '504313', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(189, '504216', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(190, '504251', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(191, '504110', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(192, '504313', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(193, '504251', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(194, '504207', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(195, '504214', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(196, '504205', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(197, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(198, '504102', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(199, '504312', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(200, '504219', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(201, '504105', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(202, '504205', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(203, '504109', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(204, '504306', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(205, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(206, '504231', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(207, '504310', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(208, '504102', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(209, '504002', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(210, '504313', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(211, '504219', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(212, '504101', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(213, '504297', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(214, '504219', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(215, '504293', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(216, '504312', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(217, '504312', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(218, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(219, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(220, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(221, '504207', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(222, '504106', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(223, '504231', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(224, '504293', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(225, '504346', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(226, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(227, '504292', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(228, '504295', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(229, '504203', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(230, '504295', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(231, '504002', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(232, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(233, '504101', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(234, '504204', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(235, '504216', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(236, '504205', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(237, '504307', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(238, '504308', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(239, '504201', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(240, '504102', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(241, '504201', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(242, '504292', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(243, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(244, '504323', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(245, '504310', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(246, '504215', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(247, '504312', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(248, '504214', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(249, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(250, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(251, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(252, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(253, '504106', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(254, '504110', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(255, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(256, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(257, '504105', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(258, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(259, '504312', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(260, '504323', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(261, '504216', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(262, '504109', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(263, '504219', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(264, '504301', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(265, '504214', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(266, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(267, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(268, '504106', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(269, '504207', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(270, '504109', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(271, '504202', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(272, '504206', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(273, '504313', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(274, '504312', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(275, '504104', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(276, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(277, '504215', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(278, '504296', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(279, '504105', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(280, '504220', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(281, '504206', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(282, '504204', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(283, '504202', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(284, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(285, '504313', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(286, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(287, '504110', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(288, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(289, '504214', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(290, '504106', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(291, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(292, '504307', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(293, '504310', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(294, '504204', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(295, '504206', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(296, '504313', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(297, '504208', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(298, '504209', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(299, '504208', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(300, '504231', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(301, '141001', NULL, NULL);

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

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

CREATE TABLE `countries` (
  `id` int NOT NULL,
  `country_code` varchar(2) NOT NULL DEFAULT '',
  `country_name` varchar(100) NOT NULL DEFAULT '',
  `status` tinyint NOT NULL DEFAULT '1',
  `created_at` datetime NOT NULL,
  `updated_at` timestamp NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

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

INSERT INTO `countries` (`id`, `country_code`, `country_name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'AF', 'Afghanistan', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(2, 'AL', 'Albania', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(3, 'DZ', 'Algeria', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(4, 'DS', 'American Samoa', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(5, 'AD', 'Andorra', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(6, 'AO', 'Angola', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(7, 'AI', 'Anguilla', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(8, 'AQ', 'Antarctica', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(9, 'AG', 'Antigua and Barbuda', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(10, 'AR', 'Argentina', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(11, 'AM', 'Armenia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(12, 'AW', 'Aruba', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(13, 'AU', 'Australia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(14, 'AT', 'Austria', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(15, 'AZ', 'Azerbaijan', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(16, 'BS', 'Bahamas', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(17, 'BH', 'Bahrain', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(18, 'BD', 'Bangladesh', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(19, 'BB', 'Barbados', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(20, 'BY', 'Belarus', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(21, 'BE', 'Belgium', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(22, 'BZ', 'Belize', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(23, 'BJ', 'Benin', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(24, 'BM', 'Bermuda', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(25, 'BT', 'Bhutan', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(26, 'BO', 'Bolivia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(27, 'BA', 'Bosnia and Herzegovina', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(28, 'BW', 'Botswana', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(29, 'BV', 'Bouvet Island', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(30, 'BR', 'Brazil', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(31, 'IO', 'British Indian Ocean Territory', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(32, 'BN', 'Brunei Darussalam', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(33, 'BG', 'Bulgaria', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(34, 'BF', 'Burkina Faso', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(35, 'BI', 'Burundi', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(36, 'KH', 'Cambodia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(37, 'CM', 'Cameroon', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(38, 'CA', 'Canada', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(39, 'CV', 'Cape Verde', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(40, 'KY', 'Cayman Islands', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(41, 'CF', 'Central African Republic', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(42, 'TD', 'Chad', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(43, 'CL', 'Chile', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(44, 'CN', 'China', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(45, 'CX', 'Christmas Island', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(46, 'CC', 'Cocos (Keeling) Islands', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(47, 'CO', 'Colombia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(48, 'KM', 'Comoros', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(49, 'CD', 'Democratic Republic of the Congo', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(50, 'CG', 'Republic of Congo', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(51, 'CK', 'Cook Islands', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(52, 'CR', 'Costa Rica', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(53, 'HR', 'Croatia (Hrvatska)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(54, 'CU', 'Cuba', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(55, 'CY', 'Cyprus', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(56, 'CZ', 'Czech Republic', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(57, 'DK', 'Denmark', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(58, 'DJ', 'Djibouti', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(59, 'DM', 'Dominica', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(60, 'DO', 'Dominican Republic', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(61, 'TP', 'East Timor', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(62, 'EC', 'Ecuador', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(63, 'EG', 'Egypt', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(64, 'SV', 'El Salvador', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(65, 'GQ', 'Equatorial Guinea', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(66, 'ER', 'Eritrea', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(67, 'EE', 'Estonia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(68, 'ET', 'Ethiopia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(69, 'FK', 'Falkland Islands (Malvinas)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(70, 'FO', 'Faroe Islands', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(71, 'FJ', 'Fiji', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(72, 'FI', 'Finland', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(73, 'FR', 'France', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(74, 'FX', 'France, Metropolitan', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(75, 'GF', 'French Guiana', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(76, 'PF', 'French Polynesia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(77, 'TF', 'French Southern Territories', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(78, 'GA', 'Gabon', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(79, 'GM', 'Gambia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(80, 'GE', 'Georgia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(81, 'DE', 'Germany', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(82, 'GH', 'Ghana', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(83, 'GI', 'Gibraltar', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(84, 'GK', 'Guernsey', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(85, 'GR', 'Greece', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(86, 'GL', 'Greenland', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(87, 'GD', 'Grenada', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(88, 'GP', 'Guadeloupe', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(89, 'GU', 'Guam', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(90, 'GT', 'Guatemala', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(91, 'GN', 'Guinea', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(92, 'GW', 'Guinea-Bissau', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(93, 'GY', 'Guyana', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(94, 'HT', 'Haiti', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(95, 'HM', 'Heard and Mc Donald Islands', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(96, 'HN', 'Honduras', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(97, 'HK', 'Hong Kong', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(98, 'HU', 'Hungary', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(99, 'IS', 'Iceland', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(100, 'IN', 'India', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(101, 'IM', 'Isle of Man', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(102, 'ID', 'Indonesia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(103, 'IR', 'Iran (Islamic Republic of)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(104, 'IQ', 'Iraq', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(105, 'IE', 'Ireland', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(106, 'IL', 'Israel', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(107, 'IT', 'Italy', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(108, 'CI', 'Ivory Coast', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(109, 'JE', 'Jersey', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(110, 'JM', 'Jamaica', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(111, 'JP', 'Japan', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(112, 'JO', 'Jordan', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(113, 'KZ', 'Kazakhstan', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(114, 'KE', 'Kenya', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(115, 'KI', 'Kiribati', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(116, 'KP', 'Korea, Democratic People\'s Republic of', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(117, 'KR', 'Korea, Republic of', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(118, 'XK', 'Kosovo', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(119, 'KW', 'Kuwait', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(120, 'KG', 'Kyrgyzstan', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(121, 'LA', 'Lao People\'s Democratic Republic', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(122, 'LV', 'Latvia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(123, 'LB', 'Lebanon', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(124, 'LS', 'Lesotho', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(125, 'LR', 'Liberia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(126, 'LY', 'Libyan Arab Jamahiriya', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(127, 'LI', 'Liechtenstein', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(128, 'LT', 'Lithuania', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(129, 'LU', 'Luxembourg', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(130, 'MO', 'Macau', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(131, 'MK', 'North Macedonia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(132, 'MG', 'Madagascar', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(133, 'MW', 'Malawi', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(134, 'MY', 'Malaysia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(135, 'MV', 'Maldives', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(136, 'ML', 'Mali', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(137, 'MT', 'Malta', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(138, 'MH', 'Marshall Islands', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(139, 'MQ', 'Martinique', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(140, 'MR', 'Mauritania', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(141, 'MU', 'Mauritius', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(142, 'TY', 'Mayotte', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(143, 'MX', 'Mexico', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(144, 'FM', 'Micronesia, Federated States of', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(145, 'MD', 'Moldova, Republic of', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(146, 'MC', 'Monaco', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(147, 'MN', 'Mongolia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(148, 'ME', 'Montenegro', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(149, 'MS', 'Montserrat', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(150, 'MA', 'Morocco', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(151, 'MZ', 'Mozambique', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(152, 'MM', 'Myanmar', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(153, 'NA', 'Namibia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(154, 'NR', 'Nauru', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(155, 'NP', 'Nepal', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(156, 'NL', 'Netherlands', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(157, 'AN', 'Netherlands Antilles', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(158, 'NC', 'New Caledonia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(159, 'NZ', 'New Zealand', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(160, 'NI', 'Nicaragua', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(161, 'NE', 'Niger', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(162, 'NG', 'Nigeria', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(163, 'NU', 'Niue', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(164, 'NF', 'Norfolk Island', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(165, 'MP', 'Northern Mariana Islands', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(166, 'NO', 'Norway', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(167, 'OM', 'Oman', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(168, 'PK', 'Pakistan', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(169, 'PW', 'Palau', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(170, 'PS', 'Palestine', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(171, 'PA', 'Panama', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(172, 'PG', 'Papua New Guinea', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(173, 'PY', 'Paraguay', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(174, 'PE', 'Peru', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(175, 'PH', 'Philippines', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(176, 'PN', 'Pitcairn', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(177, 'PL', 'Poland', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(178, 'PT', 'Portugal', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(179, 'PR', 'Puerto Rico', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(180, 'QA', 'Qatar', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(181, 'RE', 'Reunion', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(182, 'RO', 'Romania', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(183, 'RU', 'Russian Federation', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(184, 'RW', 'Rwanda', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(185, 'KN', 'Saint Kitts and Nevis', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(186, 'LC', 'Saint Lucia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(187, 'VC', 'Saint Vincent and the Grenadines', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(188, 'WS', 'Samoa', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(189, 'SM', 'San Marino', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(190, 'ST', 'Sao Tome and Principe', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(191, 'SA', 'Saudi Arabia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(192, 'SN', 'Senegal', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(193, 'RS', 'Serbia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(194, 'SC', 'Seychelles', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(195, 'SL', 'Sierra Leone', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(196, 'SG', 'Singapore', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(197, 'SK', 'Slovakia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(198, 'SI', 'Slovenia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(199, 'SB', 'Solomon Islands', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(200, 'SO', 'Somalia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(201, 'ZA', 'South Africa', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(202, 'GS', 'South Georgia South Sandwich Islands', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(203, 'SS', 'South Sudan', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(204, 'ES', 'Spain', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(205, 'LK', 'Sri Lanka', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(206, 'SH', 'St. Helena', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(207, 'PM', 'St. Pierre and Miquelon', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(208, 'SD', 'Sudan', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(209, 'SR', 'Suriname', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(210, 'SJ', 'Svalbard and Jan Mayen Islands', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(211, 'SZ', 'Eswatini', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(212, 'SE', 'Sweden', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(213, 'CH', 'Switzerland', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(214, 'SY', 'Syrian Arab Republic', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(215, 'TW', 'Taiwan', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(216, 'TJ', 'Tajikistan', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(217, 'TZ', 'Tanzania, United Republic of', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(218, 'TH', 'Thailand', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(219, 'TG', 'Togo', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(220, 'TK', 'Tokelau', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(221, 'TO', 'Tonga', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(222, 'TT', 'Trinidad and Tobago', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(223, 'TN', 'Tunisia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(224, 'TR', 'Turkey', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(225, 'TM', 'Turkmenistan', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(226, 'TC', 'Turks and Caicos Islands', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(227, 'TV', 'Tuvalu', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(228, 'UG', 'Uganda', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(229, 'UA', 'Ukraine', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(230, 'AE', 'United Arab Emirates', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(231, 'GB', 'United Kingdom', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(232, 'US', 'United States', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(233, 'UM', 'United States minor outlying islands', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(234, 'UY', 'Uruguay', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(235, 'UZ', 'Uzbekistan', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(236, 'VU', 'Vanuatu', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(237, 'VA', 'Vatican City State', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(238, 'VE', 'Venezuela', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(239, 'VN', 'Vietnam', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(240, 'VG', 'Virgin Islands (British)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(241, 'VI', 'Virgin Islands (U.S.)', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(242, 'WF', 'Wallis and Futuna Islands', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(243, 'EH', 'Western Sahara', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(244, 'YE', 'Yemen', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(245, 'ZM', 'Zambia', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00'),
(246, 'ZW', 'Zimbabwe', 1, '0000-00-00 00:00:00', '0000-00-00 00:00:00');

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

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

CREATE TABLE `coupons` (
  `id` bigint UNSIGNED NOT NULL,
  `vendor_id` int NOT NULL,
  `coupon_option` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `coupon_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `categories` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `brands` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `users` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `coupon_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double(8,2) NOT NULL,
  `expiry_date` date NOT NULL,
  `status` tinyint 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 `coupons`
--

INSERT INTO `coupons` (`id`, `vendor_id`, `coupon_option`, `coupon_code`, `categories`, `brands`, `users`, `coupon_type`, `amount_type`, `amount`, `expiry_date`, `status`, `created_at`, `updated_at`) VALUES
(1, 0, 'Manual', 'test10', '1,6,7,2,8,3', '2,3', '', 'Single Time', 'Percentage', 10.00, '2023-12-01', 1, NULL, '2023-01-05 18:08:22'),
(3, 0, 'Automatic', '3dTtKNg7', '1,6,7', '1,2', 'ramy@yopmail.com,ibrahim@gmail.com', 'Multiple Times', 'Percentage', 10.00, '2023-12-31', 1, '2022-12-15 14:56:01', '2023-01-05 17:37:12'),
(4, 0, 'Manual', 'test200', '1,6,7', '1,2,4', 'ramy@yopmail.com,ibrahim@gmail.com,fouad@gmail.com,mahmoud@yahoo.com', 'Single Time', 'Fixed', 200.00, '2022-12-31', 1, '2022-12-15 14:59:24', '2022-12-18 12:49:19'),
(5, 1, 'Automatic', 'PHmKm7WL', '1,6,7,2,8,3', '1,2,3,4,5,6,7', '', 'Multiple Times', 'Percentage', 10.00, '2023-08-13', 1, '2023-01-02 23:27:03', '2023-01-02 23:27:03'),
(6, 0, 'Automatic', 'ekVpnDJL', '1,6,7', '1,2,3,9', '', 'Single Time', 'Percentage', 10.00, '2023-07-11', 1, '2023-03-24 01:03:42', '2023-03-24 01:03:42'),
(7, 0, 'Automatic', 'Y3gsKF5G', '1,6,7,2,8,3,4,5,9', '1,2,3,4,5,6,7,9', '', 'Multiple Times', 'Percentage', 10.00, '2023-12-31', 1, '2023-04-25 12:49:06', '2023-04-25 12:49:06');

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

--
-- Table structure for table `delivery_addresses`
--

CREATE TABLE `delivery_addresses` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pincode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `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 `delivery_addresses`
--

INSERT INTO `delivery_addresses` (`id`, `user_id`, `name`, `address`, `city`, `state`, `country`, `pincode`, `mobile`, `status`, `created_at`, `updated_at`) VALUES
(3, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '141001', '0119578625', 1, NULL, '2023-04-12 19:24:50'),
(5, 2, 'Ibrahim Mohamed', '20 El Nasr St., El Mansheya', 'Alexandria', 'Alexandria', 'Egypt', '141001', '0100995033', 1, '2023-02-25 23:02:09', '2023-04-12 19:25:30'),
(7, 2, 'Ibrahim', '28 Fouad St.', 'Alexandria', 'Alexandria', 'Egypt', '55663', '01205857145', 1, '2023-02-25 23:11:25', '2023-02-25 23:11:25'),
(9, 2, 'sgzdgfSZG', 'sgsfg', 'sgsg', 'SGszg', 'Egypt', 'gsrgzsfg', 'zsgzsg', 1, '2023-02-26 21:32:20', '2023-02-26 21:32:20'),
(10, 1, 'Ramy Yasser', '25 Abbas El-Akkad St.', 'Cairo', 'Cairo', 'Egypt', '542174', '0129568322', 1, '2023-03-22 23:55:04', '2023-03-22 23:55:04');

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

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

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

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

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

CREATE TABLE `migrations` (
  `id` int UNSIGNED NOT NULL,
  `migration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int 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, '2022_08_09_172927_create_vendors_table', 1),
(6, '2022_08_09_175014_create_admins_table', 1),
(8, '2022_08_14_013126_create_vendors_business_details_table', 2),
(9, '2022_08_14_125705_create_vendors_bank_details', 3),
(10, '2022_08_14_125705_create_vendors_bank_details_table', 4),
(11, '2022_08_18_133204_create_sections_table', 4),
(12, '2022_08_20_154959_create_categories_table', 5),
(13, '2022_08_26_235606_create_brands_table', 6),
(14, '2022_08_28_003445_create_products_table', 7),
(15, '2022_09_06_163819_create_products_attributes_table', 8),
(16, '2022_09_17_195644_create_products_images_table', 9),
(17, '2022_09_24_150406_create_banners_table', 10),
(18, '2022_09_26_142845_update_banners_table', 11),
(19, '2022_09_27_134607_update_products_table', 12),
(20, '2022_10_02_142913_create_products_filters_table', 13),
(21, '2022_10_02_143716_create_products_filters_values_table', 14),
(22, '2022_11_02_215937_create_recently_viewed_products_table', 15),
(23, '2022_11_03_143550_create_carts_table', 16),
(24, '2022_11_09_144019_add_columns_to_users', 17),
(25, '2022_12_14_025719_create_coupons_table', 18),
(26, '2023_01_14_012938_create_delivery_addresses_table', 19),
(27, '2023_02_27_200827_create_orders_table', 20),
(28, '2023_02_27_201841_create_orders_products_table', 21),
(29, '2023_03_04_161126_create_order_statuses_table', 22),
(30, '2023_03_05_000428_create_order_item_statuses_table', 23),
(31, '2023_03_08_003018_create_orders_logs_table', 24),
(32, '2023_03_09_144122_update_orders_table', 25),
(33, '2023_03_09_235853_update_orders_products_table', 26),
(34, '2023_03_10_001719_update_orders_logs_table', 27),
(35, '2023_03_29_151313_create_payments_table', 28),
(36, '2023_04_01_140344_create_shipping_charges_table', 29),
(37, '2023_04_04_234905_drop_column_from_shipping_charges_table', 30),
(38, '2023_04_04_235424_add_columns_to_shipping_charges_table', 31),
(39, '2023_04_12_002719_create_cod_pincodes_table', 32),
(40, '2023_04_12_194813_create_prepaid_pincodes_table', 33),
(41, '2023_04_14_154108_add_commission_column_to_vendors_table', 34),
(42, '2023_04_16_211726_add_is_pushed_column_to_orders_table', 35),
(43, '2023_04_23_225334_add_api_token_column_to_users_table', 36),
(44, '2016_06_01_000001_create_oauth_auth_codes_table', 37),
(45, '2016_06_01_000002_create_oauth_access_tokens_table', 37),
(46, '2016_06_01_000003_create_oauth_refresh_tokens_table', 37),
(47, '2016_06_01_000004_create_oauth_clients_table', 37),
(48, '2016_06_01_000005_create_oauth_personal_access_clients_table', 37),
(49, '2023_04_23_225334_add_access_token_column_to_users_table', 38),
(50, '2023_05_26_233039_create_newsletter_subscribers_table', 38),
(51, '2023_07_05_112943_create_ratings_table', 39);

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

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

CREATE TABLE `newsletter_subscribers` (
  `id` bigint UNSIGNED NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint 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 `newsletter_subscribers`
--

INSERT INTO `newsletter_subscribers` (`id`, `email`, `status`, `created_at`, `updated_at`) VALUES
(1, 'yasser100@yopmail.com', 1, '2023-05-31 18:40:41', '2023-05-31 21:29:24'),
(3, 'test@test.com', 1, '2023-06-02 15:38:17', '2023-06-02 15:38:17'),
(4, 'check@check.com', 1, '2023-06-02 15:41:41', '2023-06-06 17:39:13');

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

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

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

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

INSERT INTO `oauth_access_tokens` (`id`, `user_id`, `client_id`, `name`, `scopes`, `revoked`, `created_at`, `updated_at`, `expires_at`) VALUES
('1150c7668968f342e17ada0ac697c900e85530e662db649f8bdac082e317b50fdbf0cf14b93c9412', 33, 1, 'farag@hotmail.com', '[]', 0, '2023-04-30 22:27:32', '2023-04-30 22:27:32', '2024-05-01 01:27:32'),
('6d0ce755c80ad38622cae938ab9b21e42b57790c0581e22d6b860fafbf5ca2cdcb1c2ffbeddd2e3b', 7, 1, 'nermin@hotmail.com', '[]', 0, '2023-04-30 23:33:42', '2023-04-30 23:33:42', '2024-05-01 02:33:42'),
('fd8b5eea9088f152e0745bba62fc165d7b53139b37e00d40b12354429562fcc21eefd29dbde81c43', 34, 1, 'farag@hotmail.com', '[]', 0, '2023-04-30 22:48:10', '2023-04-30 22:48:11', '2024-05-01 01:48:10');

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

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

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

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

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

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

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

INSERT INTO `oauth_clients` (`id`, `user_id`, `name`, `secret`, `provider`, `redirect`, `personal_access_client`, `password_client`, `revoked`, `created_at`, `updated_at`) VALUES
(1, NULL, 'StackDevelopers Personal Access Client', 'kId7oUF3BLJkScW8b0M9aU0vCKquH67EbOBeJzEr', NULL, 'http://localhost', 1, 0, 0, '2023-04-29 21:21:51', '2023-04-29 21:21:51'),
(2, NULL, 'StackDevelopers Password Grant Client', 'x7QUOhmzDimA8zZBoh7OG2lWocs9QuaCcsQfZMFB', 'users', 'http://localhost', 0, 1, 0, '2023-04-29 21:21:51', '2023-04-29 21:21:51');

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

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

CREATE TABLE `oauth_personal_access_clients` (
  `id` bigint UNSIGNED NOT NULL,
  `client_id` bigint 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-04-29 21:21:51', '2023-04-29 21:21:51');

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

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

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

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

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

CREATE TABLE `orders` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pincode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `shipping_charges` double(8,2) NOT NULL,
  `coupon_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `coupon_amount` double(8,2) DEFAULT NULL,
  `order_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_gateway` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `grand_total` double(8,2) NOT NULL,
  `courier_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tracking_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_pushed` tinyint NOT NULL DEFAULT '0' COMMENT 'Order pushed to Shiprocket or NOT',
  `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 `orders`
--

INSERT INTO `orders` (`id`, `user_id`, `name`, `address`, `city`, `state`, `country`, `pincode`, `mobile`, `email`, `shipping_charges`, `coupon_code`, `coupon_amount`, `order_status`, `payment_method`, `payment_gateway`, `grand_total`, `courier_name`, `tracking_number`, `is_pushed`, `created_at`, `updated_at`) VALUES
(1, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '12154', '01195786255', 'ibrahim@gmail.com', 0.00, '3dTtKNg7', 220.00, 'Shipped', 'COD', 'COD', 1980.00, '', '', 0, '2023-03-01 20:27:38', '2023-04-16 20:49:33'),
(2, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '12154', '01195786255', 'ibrahim@gmail.com', 0.00, '3dTtKNg7', 220.00, 'New', 'COD', 'COD', 1980.00, '', '', 0, '2023-03-01 21:20:52', '2023-03-04 21:46:33'),
(3, 2, 'sgzdgfSZG', 'sgsfg', 'sgsg', 'SGszg', 'Egypt', 'gsrgzsfg', 'zsgzsg', 'ibrahim@gmail.com', 0.00, '3dTtKNg7', 220.00, 'New', 'COD', 'COD', 880.00, '', '', 0, '2023-03-01 21:37:23', '2023-03-01 21:37:23'),
(4, 2, 'Ibrahim Mohamed', '20 El Nasr St., El Mansheya', 'Alexandria', 'Alexandria', 'Egypt', '57843', '01009950333', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'Shipped', 'Prepaid', 'Paypal', 1080.00, '', '', 1, '2023-03-03 21:34:13', '2023-04-17 22:57:51'),
(6, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '12154', '01195786255', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'New', 'COD', 'COD', 807.50, '', '', 0, '2023-03-05 20:59:36', '2023-03-05 20:59:36'),
(7, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '12154', '01195786255', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'New', 'COD', 'COD', 1887.50, '', '', 0, '2023-03-05 21:04:45', '2023-03-05 21:04:45'),
(9, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '12154', '01195786255', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'New', 'COD', 'COD', 1200.00, '', '', 0, '2023-03-07 18:48:59', '2023-03-07 18:48:59'),
(10, 2, 'Ibrahim Mohamed', '20 El Nasr St., El Mansheya', 'Alexandria', 'Alexandria', 'Egypt', '57843', '01009950333', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'New', 'COD', 'COD', 13200.00, '', '', 0, '2023-03-07 19:43:24', '2023-03-07 19:43:24'),
(11, 2, 'Ibrahim Mohamed', '20 El Nasr St., El Mansheya', 'Alexandria', 'Alexandria', 'Egypt', '57843', '01009950333', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'Shipped', 'COD', 'COD', 13200.00, 'FedEx', '39539936', 0, '2023-03-07 19:46:03', '2023-03-16 01:55:33'),
(14, 2, 'Ibrahim', '28 Fouad St.', 'Alexandria', 'Alexandria', 'Egypt', '55663', '01205857145', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'New', 'COD', 'COD', 1807.50, NULL, NULL, 0, '2023-03-17 16:49:44', '2023-03-17 16:49:44'),
(15, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '12154', '01195786255', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'New', 'COD', 'COD', 13080.00, NULL, NULL, 0, '2023-03-17 17:31:40', '2023-03-17 17:31:40'),
(16, 2, 'sgzdgfSZG', 'sgsfg', 'sgsg', 'SGszg', 'Egypt', 'gsrgzsfg', 'zsgzsg', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'New', 'COD', 'COD', 720.00, NULL, NULL, 0, '2023-03-18 14:00:49', '2023-03-18 14:00:49'),
(17, 2, 'Ibrahim Mohamed', '20 El Nasr St., El Mansheya', 'Alexandria', 'Alexandria', 'Egypt', '57843', '01009950333', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'New', 'COD', 'COD', 1000.00, NULL, NULL, 0, '2023-03-21 21:51:03', '2023-03-21 21:51:03'),
(18, 2, 'Ibrahim Mohamed', '20 El Nasr St., El Mansheya', 'Alexandria', 'Alexandria', 'Egypt', '57843', '01009950333', 'ibrahim@gmail.com', 0.00, 'test10', 120.00, 'New', 'COD', 'COD', 1080.00, NULL, NULL, 0, '2023-03-24 01:00:07', '2023-03-24 01:00:07'),
(19, 2, 'sgzdgfSZG', 'sgsfg', 'sgsg', 'SGszg', 'Egypt', 'gsrgzsfg', 'zsgzsg', 'ibrahim@gmail.com', 0.00, 'ekVpnDJL', 72.00, 'New', 'COD', 'COD', 648.00, NULL, NULL, 0, '2023-03-24 01:18:08', '2023-03-24 01:18:08'),
(20, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '12154', '01195786255', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'Pending', 'Prepaid', 'PayPal', 1200.00, NULL, NULL, 0, '2023-03-25 01:58:45', '2023-03-25 01:58:45'),
(21, 2, 'Ibrahim Mohamed', '20 El Nasr St., El Mansheya', 'Alexandria', 'Alexandria', 'Egypt', '57843', '01009950333', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'Pending', 'Prepaid', 'PayPal', 1080.00, NULL, NULL, 0, '2023-03-26 02:27:48', '2023-03-26 02:27:48'),
(22, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '12154', '01195786255', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'Pending', 'Prepaid', 'PayPal', 14400.00, NULL, NULL, 0, '2023-03-26 02:28:31', '2023-03-26 02:28:31'),
(23, 2, 'Ibrahim', '28 Fouad St.', 'Alexandria', 'Alexandria', 'Egypt', '55663', '01205857145', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'Pending', 'Prepaid', 'PayPal', 12000.00, NULL, NULL, 0, '2023-03-26 02:31:11', '2023-03-26 02:31:11'),
(24, 2, 'Ibrahim', '28 Fouad St.', 'Alexandria', 'Alexandria', 'Egypt', '55663', '01205857145', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'Pending', 'Prepaid', 'PayPal', 12000.00, NULL, NULL, 0, '2023-03-26 02:31:48', '2023-03-26 02:31:48'),
(25, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '12154', '01195786255', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'Pending', 'Prepaid', 'Paypal', 14400.00, NULL, NULL, 0, '2023-03-26 02:34:22', '2023-03-26 02:34:22'),
(26, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '12154', '01195786255', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'Pending', 'Prepaid', 'Paypal', 14400.00, NULL, NULL, 0, '2023-03-29 02:52:23', '2023-03-29 02:52:23'),
(27, 2, 'Ibrahim Mohamed', '20 El Nasr St., El Mansheya', 'Alexandria', 'Alexandria', 'Egypt', '57843', '01009950333', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'Pending', 'Prepaid', 'Paypal', 14400.00, NULL, NULL, 0, '2023-03-30 02:00:43', '2023-03-30 02:00:43'),
(28, 2, 'Ibrahim Mohamed', '20 El Nasr St., El Mansheya', 'Alexandria', 'Alexandria', 'Egypt', '57843', '01009950333', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'Pending', 'Prepaid', 'Paypal', 14400.00, NULL, NULL, 0, '2023-03-30 11:56:37', '2023-03-30 11:56:37'),
(29, 2, 'Ibrahim Mohamed', '20 El Nasr St., El Mansheya', 'Alexandria', 'Alexandria', 'Egypt', '57843', '01009950333', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'Pending', 'Prepaid', 'Paypal', 14400.00, NULL, NULL, 0, '2023-03-30 13:12:25', '2023-03-30 13:12:25'),
(30, 2, 'sgzdgfSZG', 'sgsfg', 'sgsg', 'SGszg', 'Egypt', 'gsrgzsfg', 'zsgzsg', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'Pending', 'Prepaid', 'Paypal', 14400.00, NULL, NULL, 0, '2023-03-30 13:24:17', '2023-03-30 13:24:17'),
(31, 2, 'Ibrahim Mohamed', '20 El Nasr St., El Mansheya', 'Alexandria', 'Alexandria', 'Egypt', '57843', '01009950333', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'Pending', 'Prepaid', 'Paypal', 14400.00, NULL, NULL, 0, '2023-03-30 13:43:28', '2023-03-30 13:43:28'),
(32, 2, 'Ibrahim', '28 Fouad St.', 'Alexandria', 'Alexandria', 'Egypt', '55663', '01205857145', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'Pending', 'Prepaid', 'Paypal', 14400.00, NULL, NULL, 0, '2023-03-31 02:22:44', '2023-03-31 02:22:44'),
(33, 2, 'Ibrahim Mohamed', '20 El Nasr St., El Mansheya', 'Alexandria', 'Alexandria', 'Egypt', '57843', '01009950333', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'Paid', 'Prepaid', 'Paypal', 14400.00, NULL, NULL, 0, '2023-03-31 23:23:39', '2023-03-31 23:29:20'),
(34, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '12154', '01195786255', 'ibrahim@gmail.com', 200.00, NULL, NULL, 'New', 'COD', 'COD', 1400.00, NULL, NULL, 0, '2023-04-04 20:45:06', '2023-04-04 20:45:06'),
(35, 2, 'Ibrahim Mohamed', '20 El Nasr St., El Mansheya', 'Alexandria', 'Alexandria', 'Egypt', '57843', '01009950333', 'ibrahim@gmail.com', 200.00, NULL, NULL, 'New', 'COD', 'COD', 2500.00, NULL, NULL, 0, '2023-04-05 14:44:38', '2023-04-05 14:44:38'),
(36, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '12154', '01195786255', 'ibrahim@gmail.com', 100.00, NULL, NULL, 'New', 'COD', 'COD', 2300.00, NULL, NULL, 0, '2023-04-05 23:57:36', '2023-04-05 23:57:36'),
(37, 2, 'Ibrahim', '28 Fouad St.', 'Alexandria', 'Alexandria', 'Egypt', '55663', '01205857145', 'ibrahim@gmail.com', 100.00, NULL, NULL, 'New', 'COD', 'COD', 4300.00, NULL, NULL, 0, '2023-04-06 00:00:42', '2023-04-06 00:00:42'),
(38, 2, 'Ibrahim', '28 Fouad St.', 'Alexandria', 'Alexandria', 'Egypt', '55663', '01205857145', 'ibrahim@gmail.com', 100.00, NULL, NULL, 'New', 'COD', 'COD', 12100.00, NULL, NULL, 0, '2023-04-08 02:40:23', '2023-04-08 02:40:23'),
(39, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '141001', '0119578625', 'ibrahim@gmail.com', 0.00, 'PHmKm7WL', 100.00, 'New', 'COD', 'COD', 900.00, NULL, NULL, 0, '2023-04-21 23:08:52', '2023-04-21 23:08:52'),
(40, 2, 'Ibrahim Mohamed', '20 El Nasr St., El Mansheya', 'Alexandria', 'Alexandria', 'Egypt', '141001', '0100995033', 'ibrahim@gmail.com', 0.00, '3dTtKNg7', 220.00, 'New', 'COD', 'COD', 1980.00, NULL, NULL, 0, '2023-04-22 22:05:22', '2023-04-22 22:05:22'),
(41, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '141001', '0119578625', 'ibrahim@gmail.com', 100.00, 'Y3gsKF5G', 230.00, 'New', 'COD', 'COD', 2170.00, NULL, NULL, 0, '2023-04-25 13:24:20', '2023-04-25 13:24:20'),
(42, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '141001', '0119578625', 'ibrahim@gmail.com', 100.00, NULL, NULL, 'Pending', 'Prepaid', 'iyzipay', 4010.00, NULL, NULL, 0, '2023-05-14 19:05:46', '2023-05-14 19:05:46'),
(43, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '141001', '0119578625', 'ibrahim@gmail.com', 100.00, NULL, NULL, 'Pending', 'Prepaid', 'iyzipay', 4010.00, NULL, NULL, 0, '2023-05-15 20:05:23', '2023-05-15 20:05:23'),
(44, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '141001', '0119578625', 'ibrahim@gmail.com', 100.00, NULL, NULL, 'Pending', 'Prepaid', 'iyzipay', 4010.00, NULL, NULL, 0, '2023-05-18 17:47:45', '2023-05-18 17:47:45'),
(45, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '141001', '0119578625', 'ibrahim@gmail.com', 100.00, NULL, NULL, 'Pending', 'Prepaid', 'iyzipay', 4010.00, NULL, NULL, 0, '2023-05-21 13:11:16', '2023-05-21 13:11:16'),
(50, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '141001', '0119578625', 'ibrahim@gmail.com', 100.00, NULL, NULL, 'New', 'COD', 'COD', 4820.00, NULL, NULL, 0, '2023-06-09 13:19:38', '2023-06-09 13:19:38'),
(53, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '141001', '0119578625', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'New', 'COD', 'COD', 1000.00, NULL, NULL, 0, '2023-07-26 17:47:50', '2023-07-26 17:47:50'),
(55, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '141001', '0119578625', 'ibrahim@gmail.com', 0.00, NULL, NULL, 'New', 'COD', 'COD', 1000.00, NULL, NULL, 0, '2023-07-26 20:15:04', '2023-07-26 20:15:04'),
(56, 2, 'Ibrahim', '16 El Fath St.', 'Cairo', 'Cairo', 'Egypt', '141001', '0119578625', 'ibrahim@gmail.com', 100.00, NULL, NULL, 'Pending', 'Prepaid', 'Paypal', 14500.00, NULL, NULL, 0, '2023-08-07 16:33:30', '2023-08-07 16:33:30');

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

--
-- Table structure for table `orders_logs`
--

CREATE TABLE `orders_logs` (
  `id` bigint UNSIGNED NOT NULL,
  `order_id` int NOT NULL,
  `order_item_id` int DEFAULT NULL,
  `order_status` varchar(255) CHARACTER SET utf8mb4 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 `orders_logs`
--

INSERT INTO `orders_logs` (`id`, `order_id`, `order_item_id`, `order_status`, `created_at`, `updated_at`) VALUES
(1, 11, 13, 'Shipped', '2023-03-09 22:54:15', '2023-03-09 22:54:15'),
(2, 11, NULL, 'Shipped', '2023-03-16 00:49:03', '2023-03-16 00:49:03'),
(3, 11, NULL, 'Shipped', '2023-03-16 01:55:33', '2023-03-16 01:55:33'),
(4, 11, 14, 'Shipped', '2023-03-16 02:07:26', '2023-03-16 02:07:26'),
(5, 11, 14, 'Shipped', '2023-03-16 02:11:32', '2023-03-16 02:11:32'),
(6, 11, 14, 'Shipped', '2023-03-16 02:16:50', '2023-03-16 02:16:50'),
(7, 15, 18, 'Shipped', '2023-03-17 21:34:41', '2023-03-17 21:34:41'),
(8, 7, 8, 'Shipped', '2023-03-17 21:37:38', '2023-03-17 21:37:38'),
(9, 11, 13, 'Shipped', '2023-03-17 22:39:12', '2023-03-17 22:39:12'),
(10, 11, 13, 'Shipped', '2023-03-17 22:46:22', '2023-03-17 22:46:22'),
(11, 1, NULL, 'Shipped', '2023-04-16 20:49:33', '2023-04-16 20:49:33'),
(12, 4, NULL, 'Shipped', '2023-04-16 21:18:51', '2023-04-16 21:18:51');

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

--
-- Table structure for table `orders_products`
--

CREATE TABLE `orders_products` (
  `id` bigint UNSIGNED NOT NULL,
  `order_id` int NOT NULL,
  `user_id` int NOT NULL,
  `vendor_id` int NOT NULL,
  `admin_id` int NOT NULL,
  `product_id` int NOT NULL,
  `product_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_size` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_price` double(8,2) NOT NULL,
  `product_qty` int NOT NULL,
  `item_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `courier_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `tracking_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `commission` float 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 `orders_products`
--

INSERT INTO `orders_products` (`id`, `order_id`, `user_id`, `vendor_id`, `admin_id`, `product_id`, `product_code`, `product_name`, `product_color`, `product_size`, `product_price`, `product_qty`, `item_status`, `courier_name`, `tracking_number`, `commission`, `created_at`, `updated_at`) VALUES
(1, 1, 2, 1, 2, 8, 'BT501', 'Blue T-Shirt', 'Blue', 'Small', 1000.00, 1, '', '', '', 0, '2023-03-01 20:27:38', '2023-03-05 14:22:04'),
(2, 1, 2, 0, 1, 2, 'RC001', 'Red Casual T-Shirt', 'Red', 'Medium', 1200.00, 1, '', '', '', 0, '2023-03-01 20:27:38', '2023-03-05 14:22:09'),
(3, 2, 2, 1, 2, 8, 'BT501', 'Blue T-Shirt', 'Blue', 'Small', 1000.00, 1, '', '', '', 0, '2023-03-01 21:20:52', '2023-03-01 21:20:52'),
(4, 2, 2, 0, 1, 2, 'RC001', 'Red Casual T-Shirt', 'Red', 'Medium', 1200.00, 1, '', '', '', 0, '2023-03-01 21:20:52', '2023-03-01 21:20:52'),
(5, 3, 2, 0, 1, 2, 'RC001', 'Red Casual T-Shirt', 'Red', 'Small', 1100.00, 1, '', '', '', 0, '2023-03-01 21:37:23', '2023-03-01 21:37:23'),
(6, 4, 2, 9, 7, 9, 'BT01', 'Black T-shirt', 'black', 'Small', 1080.00, 1, '', '', '', 0, '2023-03-03 21:34:13', '2023-03-05 20:53:43'),
(7, 6, 2, 9, 7, 10, 'PT01', '100', 'Pink', 'Small', 807.50, 1, '', '', '', 0, '2023-03-05 20:59:36', '2023-03-05 20:59:36'),
(8, 7, 2, 9, 7, 9, 'BT01', 'Black T-shirt', 'black', 'Small', 1080.00, 1, 'Shipped', 'FedEx', '39539936', 0, '2023-03-05 21:04:45', '2023-03-17 21:37:38'),
(9, 7, 2, 9, 7, 10, 'PT01', '100', 'Pink', 'Small', 807.50, 1, '', '', '', 0, '2023-03-05 21:04:45', '2023-03-05 21:50:39'),
(10, 9, 2, 0, 1, 2, 'RC001', 'Red Casual T-Shirt', 'Red', 'Medium', 1200.00, 1, NULL, '', '', 0, '2023-03-07 18:48:59', '2023-03-07 18:48:59'),
(11, 10, 2, 0, 1, 1, 'RN11', 'Redmi Note 11', 'Blue', '64GB-4GB', 12000.00, 1, NULL, '', '', 0, '2023-03-07 19:43:24', '2023-03-07 19:43:24'),
(12, 10, 2, 0, 1, 2, 'RC001', 'Red Casual T-Shirt', 'Red', 'Medium', 1200.00, 1, NULL, '', '', 0, '2023-03-07 19:43:24', '2023-03-07 19:43:24'),
(13, 11, 2, 0, 1, 1, 'RN11', 'Redmi Note 11', 'Blue', '64GB-4GB', 12000.00, 1, 'Shipped', 'FedEx', '39539936', 0, '2023-03-07 19:46:03', '2023-03-17 22:46:22'),
(14, 11, 2, 0, 1, 2, 'RC001', 'Red Casual T-Shirt', 'Red', 'Medium', 1200.00, 1, 'Shipped', 'Blue Dart', '345411515', 0, '2023-03-07 19:46:03', '2023-03-16 02:16:50'),
(15, 14, 2, 0, 1, 4, 'BT01', 'Blue T-Shirt', 'Blue', 'Small', 1000.00, 1, NULL, NULL, NULL, 0, '2023-03-17 16:49:44', '2023-03-17 16:49:44'),
(16, 14, 2, 9, 7, 10, 'PT01', '100', 'Pink', 'Small', 807.50, 1, NULL, NULL, NULL, 0, '2023-03-17 16:49:44', '2023-03-17 16:49:44'),
(17, 15, 2, 0, 1, 1, 'RN11', 'Redmi Note 11', 'Blue', '64GB-4GB', 12000.00, 1, NULL, NULL, NULL, 0, '2023-03-17 17:31:40', '2023-03-17 17:31:40'),
(18, 15, 2, 9, 7, 9, 'BT01', 'Black T-shirt', 'black', 'Small', 1080.00, 1, 'Shipped', 'FedEx', '546664564646', 0, '2023-03-17 17:31:40', '2023-03-17 21:34:40'),
(19, 16, 2, 0, 1, 5, 'GT01', 'Green T-Shirt', 'Green', 'Small', 720.00, 1, NULL, NULL, NULL, 0, '2023-03-18 14:00:49', '2023-03-18 14:00:49'),
(20, 17, 2, 0, 1, 4, 'BT01', 'Blue T-Shirt', 'Blue', 'Small', 1000.00, 1, NULL, NULL, NULL, 0, '2023-03-21 21:51:03', '2023-03-21 21:51:03'),
(21, 18, 2, 0, 1, 2, 'RC001', 'Red Casual T-Shirt', 'Red', 'Medium', 1200.00, 1, NULL, NULL, NULL, 0, '2023-03-24 01:00:07', '2023-03-24 01:00:07'),
(22, 19, 2, 0, 1, 5, 'GT01', 'Green T-Shirt', 'Green', 'Small', 720.00, 1, NULL, NULL, NULL, 0, '2023-03-24 01:18:08', '2023-03-24 01:18:08'),
(23, 20, 2, 0, 1, 2, 'RC001', 'Red Casual T-Shirt', 'Red', 'Medium', 1200.00, 1, NULL, NULL, NULL, 0, '2023-03-25 01:58:45', '2023-03-25 01:58:45'),
(24, 21, 2, 9, 7, 9, 'BT01', 'Black T-shirt', 'black', 'Small', 1080.00, 1, NULL, NULL, NULL, 0, '2023-03-26 02:27:48', '2023-03-26 02:27:48'),
(25, 22, 2, 0, 1, 1, 'RN11', 'Redmi Note 11', 'Blue', '128GB-4GB', 14400.00, 1, NULL, NULL, NULL, 0, '2023-03-26 02:28:31', '2023-03-26 02:28:31'),
(26, 23, 2, 0, 1, 1, 'RN11', 'Redmi Note 11', 'Blue', '64GB-4GB', 12000.00, 1, NULL, NULL, NULL, 0, '2023-03-26 02:31:11', '2023-03-26 02:31:11'),
(27, 24, 2, 0, 1, 1, 'RN11', 'Redmi Note 11', 'Blue', '64GB-4GB', 12000.00, 1, NULL, NULL, NULL, 0, '2023-03-26 02:31:48', '2023-03-26 02:31:48'),
(28, 25, 2, 0, 1, 1, 'RN11', 'Redmi Note 11', 'Blue', '128GB-4GB', 14400.00, 1, NULL, NULL, NULL, 0, '2023-03-26 02:34:22', '2023-03-26 02:34:22'),
(29, 26, 2, 0, 1, 1, 'RN11', 'Redmi Note 11', 'Blue', '128GB-4GB', 14400.00, 1, NULL, NULL, NULL, 0, '2023-03-29 02:52:23', '2023-03-29 02:52:23'),
(30, 27, 2, 0, 1, 1, 'RN11', 'Redmi Note 11', 'Blue', '128GB-4GB', 14400.00, 1, NULL, NULL, NULL, 0, '2023-03-30 02:00:43', '2023-03-30 02:00:43'),
(31, 28, 2, 0, 1, 1, 'RN11', 'Redmi Note 11', 'Blue', '128GB-4GB', 14400.00, 1, NULL, NULL, NULL, 0, '2023-03-30 11:56:37', '2023-03-30 11:56:37'),
(32, 29, 2, 0, 1, 1, 'RN11', 'Redmi Note 11', 'Blue', '128GB-4GB', 14400.00, 1, NULL, NULL, NULL, 0, '2023-03-30 13:12:25', '2023-03-30 13:12:25'),
(33, 30, 2, 0, 1, 1, 'RN11', 'Redmi Note 11', 'Blue', '128GB-4GB', 14400.00, 1, NULL, NULL, NULL, 0, '2023-03-30 13:24:17', '2023-03-30 13:24:17'),
(34, 31, 2, 0, 1, 1, 'RN11', 'Redmi Note 11', 'Blue', '128GB-4GB', 14400.00, 1, NULL, NULL, NULL, 0, '2023-03-30 13:43:28', '2023-03-30 13:43:28'),
(35, 32, 2, 0, 1, 1, 'RN11', 'Redmi Note 11', 'Blue', '128GB-4GB', 14400.00, 1, NULL, NULL, NULL, 0, '2023-03-31 02:22:44', '2023-03-31 02:22:44'),
(36, 33, 2, 0, 1, 1, 'RN11', 'Redmi Note 11', 'Blue', '128GB-4GB', 14400.00, 1, NULL, NULL, NULL, 0, '2023-03-31 23:23:39', '2023-03-31 23:23:39'),
(37, 34, 2, 0, 1, 2, 'RC001', 'Red Casual T-Shirt', 'Red', 'Medium', 1200.00, 1, NULL, NULL, NULL, 0, '2023-04-04 20:45:06', '2023-04-04 20:45:06'),
(38, 35, 2, 0, 1, 3, 'AT01', 'Arrow T-Shirt', 'Red', 'Small', 1100.00, 1, NULL, NULL, NULL, 0, '2023-04-05 14:44:38', '2023-04-05 14:44:38'),
(39, 35, 2, 0, 1, 2, 'RC001', 'Red Casual T-Shirt', 'Red', 'Medium', 1200.00, 1, NULL, NULL, NULL, 0, '2023-04-05 14:44:38', '2023-04-05 14:44:38'),
(40, 36, 2, 0, 1, 2, 'RC001', 'Red Casual T-Shirt', 'Red', 'Small', 1100.00, 2, NULL, NULL, NULL, 0, '2023-04-05 23:57:36', '2023-04-05 23:57:36'),
(41, 37, 2, 0, 1, 2, 'RC001', 'Red Casual T-Shirt', 'Red', 'Medium', 1200.00, 1, NULL, NULL, NULL, 0, '2023-04-06 00:00:42', '2023-04-06 00:00:42'),
(42, 37, 2, 0, 1, 4, 'BT01', 'Blue T-Shirt', 'Blue', 'Small', 1000.00, 3, NULL, NULL, NULL, 0, '2023-04-06 00:00:42', '2023-04-06 00:00:42'),
(43, 38, 2, 0, 1, 1, 'RN11', 'Redmi Note 11', 'Blue', '64GB-4GB', 12000.00, 1, NULL, NULL, NULL, 0, '2023-04-08 02:40:23', '2023-04-08 02:40:23'),
(44, 39, 2, 1, 2, 8, 'BT501', 'Blue T-Shirt', 'Blue', 'Small', 1000.00, 1, NULL, NULL, NULL, 0, '2023-04-21 23:08:52', '2023-04-21 23:08:52'),
(45, 40, 2, 1, 2, 8, 'BT501', 'Blue T-Shirt', 'Blue', 'Medium', 1200.00, 1, NULL, NULL, NULL, 0, '2023-04-22 22:05:22', '2023-04-22 22:05:22'),
(46, 40, 2, 1, 2, 8, 'BT501', 'Blue T-Shirt', 'Blue', 'Small', 1000.00, 1, NULL, NULL, NULL, 0, '2023-04-22 22:05:22', '2023-04-22 22:05:22'),
(47, 41, 2, 1, 2, 8, 'BT501', 'Blue T-Shirt', 'Blue', 'Small', 1000.00, 1, NULL, NULL, NULL, 0, '2023-04-25 13:24:20', '2023-04-25 13:24:20'),
(48, 41, 2, 0, 1, 2, 'RC001', 'Red Casual T-Shirt', 'Red', 'Large', 1300.00, 1, NULL, NULL, NULL, 0, '2023-04-25 13:24:20', '2023-04-25 13:24:20'),
(49, 42, 2, 0, 1, 5, 'GT01', 'Green T-Shirt', 'Green', 'Medium', 810.00, 1, NULL, NULL, NULL, 0, '2023-05-14 19:05:46', '2023-05-14 19:05:46'),
(50, 42, 2, 0, 1, 4, 'BT01', 'Blue T-Shirt', 'Blue', 'Small', 1000.00, 2, NULL, NULL, NULL, 0, '2023-05-14 19:05:46', '2023-05-14 19:05:46'),
(51, 42, 2, 0, 1, 2, 'RC001', 'Red Casual T-Shirt', 'Red', 'Small', 1100.00, 1, NULL, NULL, NULL, 0, '2023-05-14 19:05:46', '2023-05-14 19:05:46'),
(52, 43, 2, 0, 1, 5, 'GT01', 'Green T-Shirt', 'Green', 'Medium', 810.00, 1, NULL, NULL, NULL, 0, '2023-05-15 20:05:24', '2023-05-15 20:05:24'),
(53, 43, 2, 0, 1, 4, 'BT01', 'Blue T-Shirt', 'Blue', 'Small', 1000.00, 2, NULL, NULL, NULL, 0, '2023-05-15 20:05:24', '2023-05-15 20:05:24'),
(54, 43, 2, 0, 1, 2, 'RC001', 'Red Casual T-Shirt', 'Red', 'Small', 1100.00, 1, NULL, NULL, NULL, 0, '2023-05-15 20:05:24', '2023-05-15 20:05:24'),
(55, 44, 2, 0, 1, 5, 'GT01', 'Green T-Shirt', 'Green', 'Medium', 810.00, 1, NULL, NULL, NULL, 0, '2023-05-18 17:47:45', '2023-05-18 17:47:45'),
(56, 44, 2, 0, 1, 4, 'BT01', 'Blue T-Shirt', 'Blue', 'Small', 1000.00, 2, NULL, NULL, NULL, 0, '2023-05-18 17:47:45', '2023-05-18 17:47:45'),
(57, 44, 2, 0, 1, 2, 'RC001', 'Red Casual T-Shirt', 'Red', 'Small', 1100.00, 1, NULL, NULL, NULL, 0, '2023-05-18 17:47:45', '2023-05-18 17:47:45'),
(58, 45, 2, 0, 1, 5, 'GT01', 'Green T-Shirt', 'Green', 'Medium', 810.00, 1, NULL, NULL, NULL, 0, '2023-05-21 13:11:16', '2023-05-21 13:11:16'),
(59, 45, 2, 0, 1, 4, 'BT01', 'Blue T-Shirt', 'Blue', 'Small', 1000.00, 2, NULL, NULL, NULL, 0, '2023-05-21 13:11:17', '2023-05-21 13:11:17'),
(60, 45, 2, 0, 1, 2, 'RC001', 'Red Casual T-Shirt', 'Red', 'Small', 1100.00, 1, NULL, NULL, NULL, 0, '2023-05-21 13:11:17', '2023-05-21 13:11:17'),
(61, 50, 2, 0, 1, 5, 'GT01', 'Green T-Shirt', 'Green', 'Medium', 810.00, 2, NULL, NULL, NULL, 0, '2023-06-09 13:19:38', '2023-06-09 13:19:38'),
(62, 50, 2, 0, 1, 4, 'BT01', 'Blue T-Shirt', 'Blue', 'Small', 1000.00, 2, NULL, NULL, NULL, 0, '2023-06-09 13:19:38', '2023-06-09 13:19:38'),
(63, 50, 2, 0, 1, 2, 'RC001', 'Red Casual T-Shirt', 'Red', 'Small', 1100.00, 1, NULL, NULL, NULL, 0, '2023-06-09 13:19:38', '2023-06-09 13:19:38'),
(64, 53, 2, 0, 1, 4, 'BT01', 'Blue T-Shirt', 'Blue', 'Small', 1000.00, 1, NULL, NULL, NULL, NULL, '2023-07-26 17:47:50', '2023-07-26 17:47:50'),
(65, 55, 2, 1, 2, 8, 'BT501', 'Blue T-Shirt', 'Blue', 'Small', 1000.00, 1, NULL, NULL, NULL, 2, '2023-07-26 20:15:04', '2023-07-26 20:15:04'),
(66, 56, 2, 0, 1, 1, 'RN11', 'Redmi Note 11', 'Blue', '128GB-4GB', 14400.00, 1, NULL, NULL, NULL, NULL, '2023-08-07 16:33:30', '2023-08-07 16:33:30');

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

--
-- Table structure for table `order_item_statuses`
--

CREATE TABLE `order_item_statuses` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint 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 `order_item_statuses`
--

INSERT INTO `order_item_statuses` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Pending', 1, NULL, NULL),
(2, 'In Progress', 1, NULL, NULL),
(3, 'Shipped', 1, NULL, NULL),
(4, 'Delivered', 1, NULL, NULL);

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

--
-- Table structure for table `order_statuses`
--

CREATE TABLE `order_statuses` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint 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 `order_statuses`
--

INSERT INTO `order_statuses` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'New', 1, NULL, NULL),
(2, 'Pending', 1, NULL, NULL),
(3, 'Canceled', 1, NULL, NULL),
(4, 'In Progress', 1, NULL, NULL),
(5, 'Shipped', 1, NULL, NULL),
(6, 'Partially Shipped', 1, NULL, NULL),
(7, 'Delivered', 1, NULL, NULL),
(8, 'Partially Delivered', 1, NULL, NULL),
(9, 'Paid', 1, NULL, NULL);

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

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

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

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

--
-- Table structure for table `payments`
--

CREATE TABLE `payments` (
  `id` bigint UNSIGNED NOT NULL,
  `order_id` int NOT NULL,
  `user_id` int NOT NULL,
  `payment_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payer_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payer_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `amount` double(10,2) NOT NULL,
  `currency` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `payment_status` varchar(255) CHARACTER SET utf8mb4 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 `payments`
--

INSERT INTO `payments` (`id`, `order_id`, `user_id`, `payment_id`, `payer_id`, `payer_email`, `amount`, `currency`, `payment_status`, `created_at`, `updated_at`) VALUES
(1, 31, 2, 'PAYID-MQS4RTI4C4881603G035944H', 'VWDQ9XDE56LRJ', 'sb-z6uip25383523@personal.example.com', 180.00, 'USD', 'approved', '2023-03-30 15:48:20', '2023-03-30 15:48:20'),
(2, 32, 2, 'PAYID-MQTGAHQ95G50050T1402342Y', 'VWDQ9XDE56LRJ', 'sb-z6uip25383523@personal.example.com', 180.00, 'USD', 'approved', '2023-03-31 02:23:38', '2023-03-31 02:23:38'),
(3, 33, 2, 'PAYID-MQTYRBY7S9607652J403324M', 'VWDQ9XDE56LRJ', 'sb-z6uip25383523@personal.example.com', 180.00, 'USD', 'approved', '2023-03-31 23:29:20', '2023-03-31 23:29:20');

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

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

CREATE TABLE `personal_access_tokens` (
  `id` bigint UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `tokenable_id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `token` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `abilities` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_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 `prepaid_pincodes`
--

CREATE TABLE `prepaid_pincodes` (
  `id` bigint UNSIGNED NOT NULL,
  `pincode` varchar(10) CHARACTER SET utf8mb4 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 `prepaid_pincodes`
--

INSERT INTO `prepaid_pincodes` (`id`, `pincode`, `created_at`, `updated_at`) VALUES
(1, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(2, '504293', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(3, '504307', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(4, '504001', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(5, '504001', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(6, '504251', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(7, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(8, '504251', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(9, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(10, '504201', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(11, '504110', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(12, '504202', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(13, '504296', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(14, '504231', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(15, '504109', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(16, '504201', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(17, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(18, '504002', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(19, '504201', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(20, '504204', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(21, '504312', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(22, '504313', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(23, '504101', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(24, '504293', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(25, '504201', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(26, '504204', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(27, '504293', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(28, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(29, '504205', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(30, '504203', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(31, '504295', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(32, '504106', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(33, '504306', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(34, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(35, '504296', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(36, '504101', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(37, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(38, '504203', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(39, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(40, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(41, '504202', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(42, '504251', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(43, '504251', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(44, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(45, '504001', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(46, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(47, '504308', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(48, '504204', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(49, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(50, '504002', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(51, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(52, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(53, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(54, '504001', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(55, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(56, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(57, '504101', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(58, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(59, '504306', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(60, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(61, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(62, '504101', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(63, '504307', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(64, '504110', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(65, '504272', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(66, '504101', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(67, '504251', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(68, '504251', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(69, '504323', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(70, '504293', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(71, '504272', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(72, '504002', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(73, '504215', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(74, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(75, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(76, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(77, '504296', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(78, '504346', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(79, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(80, '504110', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(81, '504002', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(82, '504201', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(83, '504296', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(84, '504205', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(85, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(86, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(87, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(88, '504310', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(89, '504294', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(90, '504306', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(91, '504202', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(92, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(93, '504313', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(94, '504302', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(95, '504002', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(96, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(97, '504206', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(98, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(99, '504346', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(100, '504002', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(101, '504001', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(102, '504202', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(103, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(104, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(105, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(106, '504102', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(107, '504294', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(108, '504293', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(109, '504308', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(110, '504218', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(111, '504201', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(112, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(113, '504313', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(114, '504110', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(115, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(116, '504346', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(117, '504205', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(118, '504231', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(119, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(120, '504203', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(121, '504306', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(122, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(123, '504310', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(124, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(125, '504207', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(126, '504215', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(127, '504201', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(128, '504206', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(129, '504272', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(130, '504296', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(131, '504296', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(132, '504307', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(133, '504102', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(134, '504102', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(135, '504209', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(136, '504104', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(137, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(138, '504001', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(139, '504292', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(140, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(141, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(142, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(143, '504297', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(144, '504346', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(145, '504307', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(146, '504307', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(147, '504219', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(148, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(149, '504207', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(150, '504292', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(151, '504312', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(152, '504110', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(153, '504346', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(154, '504323', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(155, '504293', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(156, '504208', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(157, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(158, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(159, '504215', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(160, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(161, '504308', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(162, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(163, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(164, '504109', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(165, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(166, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(167, '504306', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(168, '504293', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(169, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(170, '504251', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(171, '504308', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(172, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(173, '504346', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(174, '504296', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(175, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(176, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(177, '504207', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(178, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(179, '504205', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(180, '504216', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(181, '504346', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(182, '504295', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(183, '504106', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(184, '504296', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(185, '504215', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(186, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(187, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(188, '504313', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(189, '504216', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(190, '504251', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(191, '504110', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(192, '504313', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(193, '504251', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(194, '504207', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(195, '504214', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(196, '504205', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(197, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(198, '504102', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(199, '504312', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(200, '504219', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(201, '504105', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(202, '504205', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(203, '504109', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(204, '504306', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(205, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(206, '504231', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(207, '504310', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(208, '504102', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(209, '504002', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(210, '504313', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(211, '504219', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(212, '504101', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(213, '504297', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(214, '504219', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(215, '504293', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(216, '504312', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(217, '504312', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(218, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(219, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(220, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(221, '504207', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(222, '504106', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(223, '504231', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(224, '504293', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(225, '504346', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(226, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(227, '504292', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(228, '504295', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(229, '504203', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(230, '504295', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(231, '504002', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(232, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(233, '504101', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(234, '504204', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(235, '504216', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(236, '504205', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(237, '504307', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(238, '504308', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(239, '504201', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(240, '504102', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(241, '504201', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(242, '504292', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(243, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(244, '504323', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(245, '504310', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(246, '504215', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(247, '504312', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(248, '504214', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(249, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(250, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(251, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(252, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(253, '504106', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(254, '504110', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(255, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(256, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(257, '504105', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(258, '504304', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(259, '504312', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(260, '504323', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(261, '504216', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(262, '504109', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(263, '504219', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(264, '504301', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(265, '504214', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(266, '504309', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(267, '504311', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(268, '504106', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(269, '504207', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(270, '504109', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(271, '504202', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(272, '504206', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(273, '504313', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(274, '504312', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(275, '504104', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(276, '504299', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(277, '504215', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(278, '504296', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(279, '504105', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(280, '504220', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(281, '504206', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(282, '504204', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(283, '504202', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(284, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(285, '504313', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(286, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(287, '504110', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(288, '504103', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(289, '504214', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(290, '504106', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(291, '504273', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(292, '504307', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(293, '504310', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(294, '504204', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(295, '504206', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(296, '504313', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(297, '504208', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(298, '504209', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(299, '504208', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(300, '504231', '2023-03-23 22:00:00', '2023-03-23 22:00:00'),
(301, '141001', NULL, NULL);

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

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

CREATE TABLE `products` (
  `id` bigint UNSIGNED NOT NULL,
  `section_id` int NOT NULL,
  `category_id` int NOT NULL,
  `brand_id` int NOT NULL,
  `vendor_id` int NOT NULL,
  `admin_id` int NOT NULL,
  `admin_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `product_price` float NOT NULL,
  `product_discount` float NOT NULL,
  `product_weight` int NOT NULL,
  `product_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `product_video` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `group_code` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `operating_system` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `screen_size` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `occasion` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pattern` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `sleeve` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ram` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `fabric` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_keywords` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `meta_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_featured` enum('No','Yes') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_bestseller` enum('No','Yes') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint 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 `products`
--

INSERT INTO `products` (`id`, `section_id`, `category_id`, `brand_id`, `vendor_id`, `admin_id`, `admin_type`, `product_name`, `product_code`, `product_color`, `product_price`, `product_discount`, `product_weight`, `product_image`, `product_video`, `group_code`, `description`, `operating_system`, `screen_size`, `occasion`, `fit`, `pattern`, `sleeve`, `ram`, `fabric`, `meta_title`, `meta_keywords`, `meta_description`, `is_featured`, `is_bestseller`, `status`, `created_at`, `updated_at`) VALUES
(1, 2, 5, 7, 0, 1, 'superadmin', 'Redmi Note 11', 'RN11', 'Blue', 15000, 20, 500, '91540.jpg', '', NULL, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, 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.', 'Android', 'Up to 3.9 in', NULL, NULL, NULL, NULL, '4 GB', NULL, 'Redmi Note 11', 'redmi note 11', 'Best price for Redmi Note 11', 'Yes', 'Yes', 1, NULL, '2023-08-13 20:44:59'),
(2, 1, 6, 2, 0, 1, 'superadmin', 'Red Casual T-Shirt', 'RC001', 'Red', 1100, 0, 200, '95575.jpg', '', '100', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, 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.', NULL, NULL, NULL, NULL, NULL, 'half sleeve', NULL, 'cotton', NULL, NULL, NULL, 'Yes', 'Yes', 1, NULL, '2023-08-13 20:44:39'),
(3, 1, 6, 1, 0, 1, 'superadmin', 'Arrow T-Shirt', 'AT01', 'Red', 1500, 0, 400, '27416.jpg', '880084420.mp4', NULL, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, 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.', NULL, NULL, NULL, NULL, NULL, 'half sleeve', NULL, 'cotton', 'Pure Cotton T-shirt', 'cotton T-shirt, red T-shirt', 'This is a high quality cotton T-shirt', 'No', 'Yes', 1, '2022-09-02 22:50:41', '2023-05-12 10:25:32'),
(4, 1, 6, 3, 0, 1, 'superadmin', 'Blue T-Shirt', 'BT01', 'Blue', 2500, 0, 0, '58892.png', NULL, '100', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, 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.', NULL, NULL, NULL, NULL, NULL, 'half sleeve', NULL, 'polyester', NULL, NULL, NULL, 'No', 'Yes', 1, '2022-09-26 18:44:39', '2023-05-12 10:21:52'),
(5, 1, 6, 2, 0, 1, 'superadmin', 'Green T-Shirt', 'GT01', 'Green', 900, 10, 100, '79204.png', NULL, '100', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, 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.', NULL, NULL, NULL, NULL, NULL, 'half sleeve', NULL, 'polyester', NULL, NULL, NULL, 'Yes', 'No', 1, '2022-09-26 18:46:39', '2023-05-12 10:22:05'),
(6, 1, 7, 1, 0, 1, 'superadmin', 'Black Shirt', 'BS01', 'Blue', 2000, 10, 100, '20083.jpg', NULL, '', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit, 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.', NULL, NULL, NULL, NULL, NULL, 'full sleeve', NULL, 'polyester', NULL, NULL, NULL, 'Yes', 'Yes', 1, '2022-09-28 12:16:45', '2022-10-31 21:56:02'),
(7, 2, 4, 7, 0, 1, 'superadmin', 'Redmi Phone', 'RT001', 'Red', 12000, 0, 0, NULL, NULL, '', NULL, 'Android', '5 to 5.4 in', NULL, NULL, NULL, NULL, '4 GB', NULL, NULL, NULL, NULL, 'No', 'No', 1, '2022-10-06 14:37:36', '2022-10-06 14:37:36'),
(8, 1, 6, 2, 1, 2, 'vendor', 'Blue T-Shirt', 'BT501', 'Blue', 1600, 0, 0, '64835.jpg', NULL, '', NULL, NULL, NULL, NULL, NULL, NULL, 'full sleeve', NULL, 'cotton', NULL, NULL, NULL, 'No', 'No', 1, '2022-10-15 13:10:41', '2022-10-15 13:10:41'),
(9, 1, 6, 3, 9, 7, 'vendor', 'Black T-shirt', 'BT01', 'black', 1200, 10, 200, '95056.jpg', NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, 'half sleeve', NULL, 'cotton', NULL, NULL, NULL, 'No', 'No', 1, '2023-03-03 21:12:45', '2023-06-09 12:41:41'),
(10, 1, 6, 1, 9, 7, 'vendor', 'Pink T-Shirt', 'PT01', 'Pink', 950, 15, 220, '20148.jpg', NULL, '100', NULL, NULL, NULL, NULL, NULL, NULL, 'half sleeve', NULL, 'cotton', NULL, NULL, NULL, 'No', 'No', 1, '2023-03-05 20:56:07', '2023-03-19 01:24:00');

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

--
-- Table structure for table `products_attributes`
--

CREATE TABLE `products_attributes` (
  `id` bigint UNSIGNED NOT NULL,
  `product_id` int NOT NULL,
  `size` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `price` double(8,2) NOT NULL,
  `stock` int NOT NULL,
  `sku` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint 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 `products_attributes`
--

INSERT INTO `products_attributes` (`id`, `product_id`, `size`, `price`, `stock`, `sku`, `status`, `created_at`, `updated_at`) VALUES
(1, 3, 'Small', 1100.00, 1, 'RC001-S', 1, '2022-09-11 20:11:15', '2022-10-29 19:54:29'),
(2, 3, 'Medium', 1200.00, 0, 'RC001-M', 1, '2022-09-11 20:11:16', '2022-10-29 19:54:29'),
(3, 3, 'Large', 1300.00, 0, 'RC001-L', 1, '2022-09-11 20:11:16', '2022-10-29 19:54:30'),
(4, 2, 'Small', 1100.00, 4, 'BT001-S', 1, '2022-10-10 13:42:25', '2023-06-09 13:19:38'),
(5, 2, 'Medium', 1200.00, 11, 'BT001-M', 1, '2022-10-10 13:43:40', '2023-04-07 19:49:51'),
(6, 2, 'Large', 1300.00, 12, 'BT001-L', 1, '2022-10-10 13:43:40', '2023-04-25 13:24:20'),
(7, 1, '64GB-4GB', 15000.00, 99, 'RN11644', 1, '2022-10-10 14:00:11', '2023-04-08 02:40:23'),
(8, 1, '128GB-4GB', 18000.00, 149, 'RN111284', 1, '2022-10-10 15:27:56', '2023-08-07 16:33:30'),
(9, 7, '64GB-4GB', 12000.00, 100, 'RT001644', 1, '2022-10-10 17:21:27', '2022-10-10 17:21:27'),
(10, 4, 'Small', 1000.00, 86, 'BT01-S', 1, '2022-10-10 21:36:38', '2023-07-26 17:47:50'),
(11, 5, 'Small', 800.00, 2, 'GT01-S', 1, '2022-10-10 21:38:12', '2023-06-09 13:19:18'),
(12, 5, 'Medium', 900.00, 4, 'GT01-M', 1, '2022-10-10 21:39:45', '2023-06-09 13:19:38'),
(13, 6, 'Small', 2000.00, 2, 'BS01-S', 1, '2022-10-10 21:40:42', '2023-06-09 13:08:27'),
(14, 6, 'Medium', 3000.00, 10, 'BS01-M', 1, '2022-10-31 21:59:57', '2023-06-09 13:08:27'),
(15, 8, 'Small', 1000.00, 6, 'BT501-S', 1, '2023-03-01 12:36:27', '2023-07-26 20:15:04'),
(16, 8, 'Medium', 1200.00, 9, 'BT501-M', 1, '2023-03-01 12:36:27', '2023-04-22 22:05:22'),
(17, 9, 'Small', 1200.00, 3, 'BS001-S', 1, '2023-03-03 21:16:33', '2023-03-03 21:16:33'),
(18, 10, 'Small', 950.00, 4, 'PT01', 1, '2023-03-05 20:56:31', '2023-03-05 20:56:31');

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

--
-- Table structure for table `products_filters`
--

CREATE TABLE `products_filters` (
  `id` bigint UNSIGNED NOT NULL,
  `cat_ids` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `filter_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `filter_column` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint 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 `products_filters`
--

INSERT INTO `products_filters` (`id`, `cat_ids`, `filter_name`, `filter_column`, `status`, `created_at`, `updated_at`) VALUES
(1, '1,6,7,2,8,3', 'Fabric', 'fabric', 1, '2022-10-03 09:05:25', '2022-10-03 09:05:25'),
(2, '4,5', 'RAM', 'ram', 1, '2022-10-03 09:43:23', '2022-10-03 09:43:23'),
(3, '1,6,7,2,8,3', 'Sleeve', 'sleeve', 1, '2022-10-03 09:59:32', '2022-10-03 09:59:32'),
(4, '1,6,7,2,8,3', 'Pattern', 'pattern', 1, '2022-10-03 10:14:02', '2022-10-03 10:14:02'),
(5, '1,6,7,2,8,3', 'Fit', 'fit', 1, '2022-10-03 10:14:35', '2022-10-03 10:14:35'),
(6, '1,6,7,2,8,3', 'Occasion', 'occasion', 1, '2022-10-03 10:31:13', '2022-10-03 10:31:13'),
(7, '4,5', 'Screen Size', 'screen_size', 1, '2022-10-03 12:11:45', '2022-10-03 12:11:45'),
(8, '4,5', 'Operating System', 'operating_system', 1, '2022-10-03 12:18:21', '2022-10-03 12:18:21');

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

--
-- Table structure for table `products_filters_values`
--

CREATE TABLE `products_filters_values` (
  `id` bigint UNSIGNED NOT NULL,
  `filter_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `filter_value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint 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 `products_filters_values`
--

INSERT INTO `products_filters_values` (`id`, `filter_id`, `filter_value`, `status`, `created_at`, `updated_at`) VALUES
(1, '1', 'cotton', 1, '2022-10-03 11:52:27', '2022-10-03 11:52:36'),
(2, '1', 'polyester', 1, '2022-10-03 11:53:40', '2022-10-03 11:53:40'),
(3, '1', 'wool', 1, '2022-10-03 11:54:27', '2022-10-03 11:54:27'),
(4, '3', 'full sleeve', 1, '2022-10-03 11:59:03', '2022-10-03 11:59:03'),
(5, '3', 'half sleeve', 1, '2022-10-03 12:02:08', '2022-10-03 12:02:08'),
(6, '3', 'short sleeve', 1, '2022-10-03 12:01:14', '2022-10-03 12:01:14'),
(7, '2', '4 GB', 1, '2022-10-03 12:04:14', '2022-10-03 12:04:14'),
(8, '2', '8 GB', 1, '2022-10-03 12:08:25', '2022-10-03 12:08:25'),
(9, '7', 'Up to 3.9 in', 1, '2022-10-03 12:16:34', '2022-10-03 12:16:34'),
(10, '7', '4 to 4.4 in', 1, '2022-10-03 12:17:19', '2022-10-03 12:17:19'),
(11, '8', 'Android', 1, '2022-10-03 12:19:07', '2022-10-03 12:19:07'),
(12, '8', 'iOS', 1, '2022-10-03 12:20:19', '2022-10-03 12:20:19'),
(13, '8', 'Windows', 1, '2022-10-03 12:21:02', '2022-10-03 12:21:02'),
(14, '7', '4.5 to 4.9 in', 1, '2022-10-06 12:39:50', '2022-10-06 12:39:50'),
(15, '7', '5 to 5.4 in', 1, '2022-10-06 13:10:22', '2022-10-06 13:10:22'),
(16, '7', '5.5 in & above', 1, '2022-10-06 13:11:25', '2022-10-06 13:11:25');

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

--
-- Table structure for table `products_images`
--

CREATE TABLE `products_images` (
  `id` bigint UNSIGNED NOT NULL,
  `product_id` int NOT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint 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 `products_images`
--

INSERT INTO `products_images` (`id`, `product_id`, `image`, `status`, `created_at`, `updated_at`) VALUES
(1, 2, '27416.jpg8713.jpg', 1, '2022-09-19 22:14:34', '2022-09-19 22:30:29'),
(2, 2, 'dfd.jpg4510.jpg', 1, '2022-09-19 22:14:34', '2022-09-19 22:30:30'),
(4, 2, 't-shirt-red-man-1710578.jpg97967.jpg', 1, '2022-11-01 02:07:37', '2022-11-01 02:07:37');

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

--
-- Table structure for table `ratings`
--

CREATE TABLE `ratings` (
  `id` bigint UNSIGNED NOT NULL,
  `user_id` int NOT NULL,
  `product_id` int NOT NULL,
  `review` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rating` int NOT NULL,
  `status` tinyint 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 `ratings`
--

INSERT INTO `ratings` (`id`, `user_id`, `product_id`, `review`, `rating`, `status`, `created_at`, `updated_at`) VALUES
(1, 2, 1, 'It\'s a great mobile phone!', 4, 1, NULL, '2023-07-05 18:30:11'),
(3, 2, 2, 'Nice red t-shirt!', 4, 1, '2023-07-08 19:14:14', '2023-07-11 16:31:24'),
(4, 2, 4, 'Very nice blue t-shirt!', 5, 1, '2023-07-11 16:33:11', '2023-07-11 16:33:34'),
(5, 34, 4, 'Not bad blue t-shirt!', 2, 1, '2023-07-11 19:37:22', '2023-07-11 19:38:02');

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

--
-- Table structure for table `recently_viewed_products`
--

CREATE TABLE `recently_viewed_products` (
  `id` bigint UNSIGNED NOT NULL,
  `product_id` int NOT NULL,
  `session_id` varchar(255) CHARACTER SET utf8mb4 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 `recently_viewed_products`
--

INSERT INTO `recently_viewed_products` (`id`, `product_id`, `session_id`, `created_at`, `updated_at`) VALUES
(1, 5, 'cf8e7ee925e90bcfee46bca79a53efac', NULL, NULL),
(2, 3, 'cf8e7ee925e90bcfee46bca79a53efac', NULL, NULL),
(3, 2, 'cf8e7ee925e90bcfee46bca79a53efac', NULL, NULL),
(4, 4, 'cf8e7ee925e90bcfee46bca79a53efac', NULL, NULL),
(5, 8, 'cf8e7ee925e90bcfee46bca79a53efac', NULL, NULL),
(6, 5, '0f5507dad3983e0c3e8dee119cd91f14', NULL, NULL),
(7, 2, '0f5507dad3983e0c3e8dee119cd91f14', NULL, NULL),
(8, 2, '74d6d8c4e102f9babb7cc63550c2d140', NULL, NULL),
(9, 2, '862087ef43881067f5b21deaf2c13943', NULL, NULL),
(10, 2, 'd272a6fbe4d3485c0377f806a095f66e', NULL, NULL),
(11, 4, 'd272a6fbe4d3485c0377f806a095f66e', NULL, NULL),
(12, 4, 'dc8e443ce1dc5935d6a08ae99c291b37', NULL, NULL),
(13, 2, '645bf3787e6f60d17f7423ab9c3808db', NULL, NULL),
(14, 2, 'baca53fe770323a06f0c2b5af654fa93', NULL, NULL),
(15, 2, 'c60344ee948d7ba6d68da1dd76e15b76', NULL, NULL),
(16, 5, 'c60344ee948d7ba6d68da1dd76e15b76', NULL, NULL),
(17, 5, '5c8539bf414d7eeae54f8abab9c0ee38', NULL, NULL),
(18, 2, '5c8539bf414d7eeae54f8abab9c0ee38', NULL, NULL),
(19, 2, '7ad795dc60d80e18d539758068e3c4e2', NULL, NULL),
(20, 5, '7ad795dc60d80e18d539758068e3c4e2', NULL, NULL),
(21, 2, '22ff3817f14d878331bf007d2dcea6f5', NULL, NULL),
(22, 5, '22ff3817f14d878331bf007d2dcea6f5', NULL, NULL),
(23, 2, '6d717cff9f01d04ff7ef2debec9edf31', NULL, NULL),
(24, 5, '6d717cff9f01d04ff7ef2debec9edf31', NULL, NULL),
(25, 4, '6d717cff9f01d04ff7ef2debec9edf31', NULL, NULL),
(26, 2, '19649472505c75da7317a362a8651522', NULL, NULL),
(27, 2, '56254dd8ea2bfb0bf12532b7d3da1a81', NULL, NULL),
(28, 5, '56254dd8ea2bfb0bf12532b7d3da1a81', NULL, NULL),
(29, 5, '1ec97b7ec8728ce15160c0c5baf20ecf', NULL, NULL),
(30, 4, '5b205a6a581f067960cbd653b90c1ee0', NULL, NULL),
(31, 5, '5b205a6a581f067960cbd653b90c1ee0', NULL, NULL),
(32, 8, '5b205a6a581f067960cbd653b90c1ee0', NULL, NULL),
(33, 3, '5b205a6a581f067960cbd653b90c1ee0', NULL, NULL),
(34, 4, '5088d2b9d971513dc3fbf2b98f3dfb97', NULL, NULL),
(35, 3, '5088d2b9d971513dc3fbf2b98f3dfb97', NULL, NULL),
(36, 2, '5088d2b9d971513dc3fbf2b98f3dfb97', NULL, NULL),
(37, 2, '6e07c9e036d4a0e2c905bfdb51917eed', NULL, NULL),
(38, 5, 'af69e6aa11ee42a18a553c1d997f68f6', NULL, NULL),
(39, 2, 'af69e6aa11ee42a18a553c1d997f68f6', NULL, NULL),
(40, 4, '1eb829d83f40a8e7a6ac067b3a1d4da8', NULL, NULL),
(41, 5, '1eb829d83f40a8e7a6ac067b3a1d4da8', NULL, NULL),
(42, 6, '1eb829d83f40a8e7a6ac067b3a1d4da8', NULL, NULL),
(43, 5, 'cc0fc76add9971b8c35776e4e97c472d', NULL, NULL),
(44, 2, 'd3360c6e24caf83671ad64038e980bbe', NULL, NULL),
(45, 4, 'd3360c6e24caf83671ad64038e980bbe', NULL, NULL),
(46, 8, 'd3360c6e24caf83671ad64038e980bbe', NULL, NULL),
(47, 2, 'cbff8122dd2e30e147c578df1f85712b', NULL, NULL),
(48, 8, '7bd0eb514d3599057de35a1353956a5e', NULL, NULL),
(49, 2, '7bd0eb514d3599057de35a1353956a5e', NULL, NULL),
(50, 9, '55fd5a3fee59fc277b66b44ede0e7c29', NULL, NULL),
(51, 10, '09d1678b912d6b669c440a103c07d406', NULL, NULL),
(52, 9, '09d1678b912d6b669c440a103c07d406', NULL, NULL),
(53, 2, 'f1ffef91d5d97de89d81f9a682d5567c', NULL, NULL),
(54, 1, 'f1ffef91d5d97de89d81f9a682d5567c', NULL, NULL),
(55, 2, '17f2908bda8d432f469ea27dc4578cc1', NULL, NULL),
(56, 10, '6a9b0aa64d0537a64e369a61abc94929', NULL, NULL),
(57, 2, '6a9b0aa64d0537a64e369a61abc94929', NULL, NULL),
(58, 4, '6a9b0aa64d0537a64e369a61abc94929', NULL, NULL),
(59, 9, '6a9b0aa64d0537a64e369a61abc94929', NULL, NULL),
(60, 1, '6a9b0aa64d0537a64e369a61abc94929', NULL, NULL),
(61, 4, '20fd3904b5673b235314b95e4fd841d2', NULL, NULL),
(62, 5, '20fd3904b5673b235314b95e4fd841d2', NULL, NULL),
(63, 10, '20fd3904b5673b235314b95e4fd841d2', NULL, NULL),
(64, 2, '20fd3904b5673b235314b95e4fd841d2', NULL, NULL),
(65, 2, '3d869470fba4782c683752d89757853d', NULL, NULL),
(66, 10, 'a1684f50ef7d61b6fe4ad0845dee6f71', NULL, NULL),
(67, 9, '26741bc7c08a2ee6941592756a4be4e1', NULL, NULL),
(68, 9, 'fc6047d5509dbd7a74078c81d3d9c044', NULL, NULL),
(69, 10, 'fc6047d5509dbd7a74078c81d3d9c044', NULL, NULL),
(70, 4, 'f3ce7a6d51c0d21855e59643b42bbb4e', NULL, NULL),
(71, 5, '5617d343aa7e9b62d5475c899ca3dae3', NULL, NULL),
(72, 2, 'bbc136a855f14954aad52f55bf5db70d', NULL, NULL),
(73, 1, 'bbc136a855f14954aad52f55bf5db70d', NULL, NULL),
(74, 5, 'bbc136a855f14954aad52f55bf5db70d', NULL, NULL),
(75, 2, '915e9c2e16355f46e0e77f0ff3b08d9f', NULL, NULL),
(76, 2, '3c81dd15139ad88810c6ed5924571283', NULL, NULL),
(77, 9, '3c81dd15139ad88810c6ed5924571283', NULL, NULL),
(78, 1, '3c81dd15139ad88810c6ed5924571283', NULL, NULL),
(79, 1, 'acb87c9a08ca78f0ede30e19e0870c0d', NULL, NULL),
(80, 2, 'e9f1297c64e70451e3eac4c89c6a1f16', NULL, NULL),
(81, 2, '07f369959838bc3cb7af64baf8c7e7c3', NULL, NULL),
(82, 3, '07f369959838bc3cb7af64baf8c7e7c3', NULL, NULL),
(83, 2, '946c2d8ed159e2935ff1fa159d24dbc7', NULL, NULL),
(84, 4, '946c2d8ed159e2935ff1fa159d24dbc7', NULL, NULL),
(85, 3, '907fe403cd200a61e98769dfc3398710', NULL, NULL),
(86, 2, '907fe403cd200a61e98769dfc3398710', NULL, NULL),
(87, 1, '907fe403cd200a61e98769dfc3398710', NULL, NULL),
(88, 2, 'f945daeb6a96dd25613f5da29ec2b2f1', NULL, NULL),
(89, 5, '7861a0d776e4e9120f833ba960b59c77', NULL, NULL),
(90, 5, '336adca83822340b6a26dcf407e20a81', NULL, NULL),
(91, 1, '336adca83822340b6a26dcf407e20a81', NULL, NULL),
(92, 2, '84a19f3c5ba04028ec98c7d49db68bef', NULL, NULL),
(93, 2, '7a0fbef755942a32b823a8a36e980b16', NULL, NULL),
(94, 2, 'bd3c741cce9136862a289664e7d2e8d6', NULL, NULL),
(95, 2, '0f0d8d1cdd8e82e062b26745b114fa47', NULL, NULL),
(96, 2, 'fa145b842656b9a076820f07b743e75d', NULL, NULL),
(97, 2, '202d4d64a35a7b847887f6236b64bb47', NULL, NULL),
(98, 8, 'fc7672f0b8d32c5b22ede33c2195ffb9', NULL, NULL),
(99, 5, 'fc7672f0b8d32c5b22ede33c2195ffb9', NULL, NULL),
(100, 8, '38d7160f4cbb2bce323f796e8f1d77d2', NULL, NULL),
(101, 2, '41b0929f60f7509876d2c82b80e25e91', NULL, NULL),
(102, 8, '41b0929f60f7509876d2c82b80e25e91', NULL, NULL),
(103, 5, '41b0929f60f7509876d2c82b80e25e91', NULL, NULL),
(104, 2, '3e0281eeca9f78a51a3ec257aa6b34d9', NULL, NULL),
(105, 1, '3e0281eeca9f78a51a3ec257aa6b34d9', NULL, NULL),
(106, 2, '1114c0313ca78b4638e0a67bb6e61d83', NULL, NULL),
(107, 4, '1114c0313ca78b4638e0a67bb6e61d83', NULL, NULL),
(108, 5, '1114c0313ca78b4638e0a67bb6e61d83', NULL, NULL),
(109, 1, '0d59f4133dcd87a0882cbaa3e51b5196', NULL, NULL),
(110, 2, '0d59f4133dcd87a0882cbaa3e51b5196', NULL, NULL),
(111, 2, '4e0405fa3832b4bba9244287d1565df7', NULL, NULL),
(112, 2, '592fc02443a4db5c9a625ee7d58e72c5', NULL, NULL),
(113, 2, '11d127c06062691e7814e4d0fd872983', NULL, NULL),
(114, 1, '11d127c06062691e7814e4d0fd872983', NULL, NULL),
(115, 3, '11d127c06062691e7814e4d0fd872983', NULL, NULL),
(116, 3, 'fae8818e4ffcc7493c361b289e8b2d5b', NULL, NULL),
(117, 4, 'fae8818e4ffcc7493c361b289e8b2d5b', NULL, NULL),
(118, 2, '4c43ac9e27935e9fe6f466b6a62d18b4', NULL, NULL),
(119, 3, '4c43ac9e27935e9fe6f466b6a62d18b4', NULL, NULL),
(120, 4, '4c43ac9e27935e9fe6f466b6a62d18b4', NULL, NULL),
(121, 4, 'ae6b24dcb852f000eddde5da1d4d4fd7', NULL, NULL),
(122, 4, '5b7a3e97ac8b6b67e643be22facddb60', NULL, NULL),
(123, 4, '85cfe14fc1a847c1cf17479176346161', NULL, NULL),
(124, 4, '5d679934c77c2f9998fe6e8836a5490e', NULL, NULL),
(125, 4, '3f1225d199328a690f0ae000830e0730', NULL, NULL),
(126, 8, '3f1225d199328a690f0ae000830e0730', NULL, NULL),
(127, 10, '444c3b573bbe18ac70d59261875ac169', NULL, NULL),
(128, 9, '444c3b573bbe18ac70d59261875ac169', NULL, NULL),
(129, 2, '444c3b573bbe18ac70d59261875ac169', NULL, NULL),
(130, 2, 'af690783e2408f23b745c76873d045b3', NULL, NULL),
(131, 2, '9f9d27c3ba0428ef9b3223778a7355ca', NULL, NULL),
(132, 2, '2716a1c72c48670213369960cbbabdd5', NULL, NULL),
(133, 1, 'af690783e2408f23b745c76873d045b3', NULL, NULL),
(134, 9, 'af690783e2408f23b745c76873d045b3', NULL, NULL),
(135, 10, 'af690783e2408f23b745c76873d045b3', NULL, NULL),
(136, 4, 'ba8e260521c9e9e773e2080e131c7ea0', NULL, NULL),
(137, 3, 'ba8e260521c9e9e773e2080e131c7ea0', NULL, NULL),
(138, 2, 'ba8e260521c9e9e773e2080e131c7ea0', NULL, NULL),
(139, 1, 'ba8e260521c9e9e773e2080e131c7ea0', NULL, NULL),
(140, 8, 'ba8e260521c9e9e773e2080e131c7ea0', NULL, NULL);

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

--
-- Table structure for table `sections`
--

CREATE TABLE `sections` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `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 `sections`
--

INSERT INTO `sections` (`id`, `name`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Clothing', 1, NULL, '2022-09-22 19:28:50'),
(2, 'Electronics', 1, NULL, '2022-09-22 18:38:47'),
(4, 'Appliances', 1, NULL, NULL),
(6, 'Computers', 1, '2022-08-19 22:27:04', '2022-09-22 18:51:54');

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

--
-- Table structure for table `shipping_charges`
--

CREATE TABLE `shipping_charges` (
  `id` bigint UNSIGNED NOT NULL,
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `0_500g` double(8,2) NOT NULL,
  `501g_1000g` double(8,2) NOT NULL,
  `1001_2000g` double(8,2) NOT NULL,
  `2001g_5000g` double(8,2) NOT NULL,
  `above_5000g` double(8,2) NOT NULL,
  `status` tinyint 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 `shipping_charges`
--

INSERT INTO `shipping_charges` (`id`, `country`, `0_500g`, `501g_1000g`, `1001_2000g`, `2001g_5000g`, `above_5000g`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Afghanistan', 100.00, 200.00, 300.00, 400.00, 500.00, 1, '2023-03-31 22:00:00', '2023-04-04 23:36:54'),
(2, 'Albania', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-04-01 14:24:48'),
(3, 'Algeria', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-04-01 14:24:49'),
(4, 'American Samoa', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(5, 'Andorra', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(6, 'Angola', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(7, 'Anguilla', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(8, 'Antarctica', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(9, 'Antigua and Barbuda', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(10, 'Argentina', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(11, 'Armenia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(12, 'Aruba', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(13, 'Australia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(14, 'Austria', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(15, 'Azerbaijan', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(16, 'Bahamas', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(17, 'Bahrain', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(18, 'Bangladesh', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(19, 'Barbados', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(20, 'Belarus', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(21, 'Belgium', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(22, 'Belize', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(23, 'Benin', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(24, 'Bermuda', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(25, 'Bhutan', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(26, 'Bolivia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(27, 'Bosnia and Herzegovina', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(28, 'Botswana', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(29, 'Bouvet Island', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(30, 'Brazil', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(31, 'British Indian Ocean Territory', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(32, 'Brunei Darussalam', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(33, 'Bulgaria', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(34, 'Burkina Faso', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(35, 'Burundi', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(36, 'Cambodia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(37, 'Cameroon', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(38, 'Canada', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(39, 'Cape Verde', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(40, 'Cayman Islands', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(41, 'Central African Republic', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(42, 'Chad', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(43, 'Chile', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(44, 'China', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(45, 'Christmas Island', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(46, 'Cocos (Keeling) Islands', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(47, 'Colombia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(48, 'Comoros', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(49, 'Democratic Republic of the Congo', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(50, 'Republic of Congo', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(51, 'Cook Islands', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(52, 'Costa Rica', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(53, 'Croatia (Hrvatska)', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(54, 'Cuba', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(55, 'Cyprus', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(56, 'Czech Republic', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(57, 'Denmark', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(58, 'Djibouti', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(59, 'Dominica', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(60, 'Dominican Republic', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(61, 'East Timor', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(62, 'Ecuador', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(63, 'Egypt', 100.00, 200.00, 300.00, 400.00, 500.00, 1, '2023-03-31 22:00:00', '2023-04-05 14:39:13'),
(64, 'El Salvador', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(65, 'Equatorial Guinea', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(66, 'Eritrea', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(67, 'Estonia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(68, 'Ethiopia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(69, 'Falkland Islands (Malvinas)', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(70, 'Faroe Islands', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(71, 'Fiji', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(72, 'Finland', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(73, 'France', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(74, 'France, Metropolitan', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(75, 'French Guiana', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(76, 'French Polynesia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(77, 'French Southern Territories', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(78, 'Gabon', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(79, 'Gambia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(80, 'Georgia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(81, 'Germany', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(82, 'Ghana', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(83, 'Gibraltar', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(84, 'Guernsey', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(85, 'Greece', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(86, 'Greenland', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(87, 'Grenada', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(88, 'Guadeloupe', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(89, 'Guam', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(90, 'Guatemala', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(91, 'Guinea', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(92, 'Guinea-Bissau', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(93, 'Guyana', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(94, 'Haiti', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(95, 'Heard and Mc Donald Islands', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(96, 'Honduras', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(97, 'Hong Kong', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(98, 'Hungary', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(99, 'Iceland', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(100, 'India', 100.00, 200.00, 300.00, 400.00, 500.00, 1, '2023-03-31 22:00:00', '2023-04-04 23:37:56'),
(101, 'Isle of Man', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(102, 'Indonesia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(103, 'Iran (Islamic Republic of)', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(104, 'Iraq', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(105, 'Ireland', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(106, 'Israel', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(107, 'Italy', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(108, 'Ivory Coast', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(109, 'Jersey', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(110, 'Jamaica', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(111, 'Japan', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(112, 'Jordan', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(113, 'Kazakhstan', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(114, 'Kenya', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(115, 'Kiribati', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(116, 'Korea, Democratic People\'s Republic of', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(117, 'Korea, Republic of', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(118, 'Kosovo', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(119, 'Kuwait', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(120, 'Kyrgyzstan', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(121, 'Lao People\'s Democratic Republic', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(122, 'Latvia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(123, 'Lebanon', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(124, 'Lesotho', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(125, 'Liberia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(126, 'Libyan Arab Jamahiriya', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(127, 'Liechtenstein', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(128, 'Lithuania', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(129, 'Luxembourg', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(130, 'Macau', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(131, 'North Macedonia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(132, 'Madagascar', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(133, 'Malawi', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(134, 'Malaysia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(135, 'Maldives', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(136, 'Mali', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(137, 'Malta', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(138, 'Marshall Islands', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(139, 'Martinique', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(140, 'Mauritania', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(141, 'Mauritius', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(142, 'Mayotte', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(143, 'Mexico', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(144, 'Micronesia, Federated States of', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(145, 'Moldova, Republic of', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(146, 'Monaco', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(147, 'Mongolia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(148, 'Montenegro', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(149, 'Montserrat', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(150, 'Morocco', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(151, 'Mozambique', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(152, 'Myanmar', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(153, 'Namibia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(154, 'Nauru', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(155, 'Nepal', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(156, 'Netherlands', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(157, 'Netherlands Antilles', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(158, 'New Caledonia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(159, 'New Zealand', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(160, 'Nicaragua', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(161, 'Niger', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(162, 'Nigeria', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(163, 'Niue', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(164, 'Norfolk Island', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(165, 'Northern Mariana Islands', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(166, 'Norway', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(167, 'Oman', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(168, 'Pakistan', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(169, 'Palau', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(170, 'Palestine', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(171, 'Panama', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(172, 'Papua New Guinea', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(173, 'Paraguay', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(174, 'Peru', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(175, 'Philippines', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(176, 'Pitcairn', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(177, 'Poland', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(178, 'Portugal', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(179, 'Puerto Rico', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(180, 'Qatar', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(181, 'Reunion', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(182, 'Romania', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(183, 'Russian Federation', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(184, 'Rwanda', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(185, 'Saint Kitts and Nevis', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(186, 'Saint Lucia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(187, 'Saint Vincent and the Grenadines', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(188, 'Samoa', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(189, 'San Marino', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(190, 'Sao Tome and Principe', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(191, 'Saudi Arabia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(192, 'Senegal', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(193, 'Serbia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(194, 'Seychelles', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(195, 'Sierra Leone', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(196, 'Singapore', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(197, 'Slovakia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(198, 'Slovenia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(199, 'Solomon Islands', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(200, 'Somalia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(201, 'South Africa', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(202, 'South Georgia South Sandwich Islands', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(203, 'South Sudan', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(204, 'Spain', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(205, 'Sri Lanka', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(206, 'St. Helena', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(207, 'St. Pierre and Miquelon', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(208, 'Sudan', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(209, 'Suriname', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(210, 'Svalbard and Jan Mayen Islands', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(211, 'Eswatini', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(212, 'Sweden', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(213, 'Switzerland', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(214, 'Syrian Arab Republic', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(215, 'Taiwan', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(216, 'Tajikistan', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(217, 'Tanzania, United Republic of', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(218, 'Thailand', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(219, 'Togo', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(220, 'Tokelau', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(221, 'Tonga', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(222, 'Trinidad and Tobago', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(223, 'Tunisia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(224, 'Turkey', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(225, 'Turkmenistan', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(226, 'Turks and Caicos Islands', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(227, 'Tuvalu', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(228, 'Uganda', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(229, 'Ukraine', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(230, 'United Arab Emirates', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(231, 'United Kingdom', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(232, 'United States', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(233, 'United States minor outlying islands', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(234, 'Uruguay', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(235, 'Uzbekistan', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(236, 'Vanuatu', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(237, 'Vatican City State', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(238, 'Venezuela', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(239, 'Vietnam', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(240, 'Virgin Islands (British)', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(241, 'Virgin Islands (U.S.)', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(242, 'Wallis and Futuna Islands', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(243, 'Western Sahara', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(244, 'Yemen', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(245, 'Zambia', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00'),
(246, 'Zimbabwe', 0.00, 0.00, 0.00, 0.00, 0.00, 1, '2023-03-31 22:00:00', '2023-03-31 22:00:00');

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

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

CREATE TABLE `users` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pincode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `status` tinyint NOT NULL DEFAULT '1',
  `remember_token` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `access_token` text CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `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 `users`
--

INSERT INTO `users` (`id`, `name`, `address`, `city`, `state`, `country`, `pincode`, `mobile`, `email`, `email_verified_at`, `password`, `status`, `remember_token`, `access_token`, `created_at`, `updated_at`) VALUES
(1, 'Ramy Morsy', NULL, NULL, NULL, NULL, NULL, '9650000000', 'ramy@yopmail.com', NULL, '$2a$12$xvkjSScUPRexfcJTAy9ATutIeGUuRgJrjDIdL/.xlrddEvRZINpeC', 1, NULL, NULL, '2022-11-09 21:24:54', '2022-11-09 21:24:54'),
(2, 'Ibrahim Mohamed', '16 El Fath St.', 'Cairo', 'Great Cairo', 'Egypt', '141001', '01195786255', 'ibrahim@gmail.com', NULL, '$2a$12$xvkjSScUPRexfcJTAy9ATutIeGUuRgJrjDIdL/.xlrddEvRZINpeC', 1, NULL, NULL, '2022-11-10 21:52:20', '2022-11-28 13:57:55'),
(3, 'Fouad Yasser', NULL, NULL, NULL, NULL, NULL, '01254873526', 'fouad@gmail.com', NULL, '$2a$12$xvkjSScUPRexfcJTAy9ATutIeGUuRgJrjDIdL/.xlrddEvRZINpeC', 1, NULL, NULL, '2022-11-10 23:28:20', '2022-11-10 23:28:20'),
(4, 'Adel Ramez', NULL, NULL, NULL, NULL, NULL, '01052347854', 'adel@gmail.com', NULL, '$2a$12$xvkjSScUPRexfcJTAy9ATutIeGUuRgJrjDIdL/.xlrddEvRZINpeC', 0, NULL, NULL, '2022-11-14 18:10:24', '2023-01-06 21:52:09'),
(5, 'Fayez Fathy', NULL, NULL, NULL, NULL, NULL, '01152006900', 'fayez@yahoo.com', NULL, '$2a$12$xvkjSScUPRexfcJTAy9ATutIeGUuRgJrjDIdL/.xlrddEvRZINpeC', 0, NULL, NULL, '2022-11-14 18:11:46', '2022-11-14 18:11:46'),
(6, 'Mahmoud Samy', NULL, NULL, NULL, NULL, NULL, '01151548874', 'mahmoud@yahoo.com', NULL, '$2y$10$1JBFeFHmv9aIuKbnDUEoGOc/59wlvX/wJ3hbo1nrhcRgs/12HVXjS', 1, NULL, NULL, '2022-11-15 21:05:45', '2023-08-07 17:45:48'),
(7, 'Nermin Yasser', NULL, NULL, NULL, NULL, NULL, '01050049566', 'nermin@hotmail.com', NULL, '$2a$12$xvkjSScUPRexfcJTAy9ATutIeGUuRgJrjDIdL/.xlrddEvRZINpeC', 0, NULL, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJhdWQiOiIxIiwianRpIjoiNmQwY2U3NTVjODBhZDM4NjIyY2FlOTM4YWI5YjIxZTQyYjU3NzkwYzA1ODFlMjJkNmI4NjBmYWZiZjVjYTJjZGNiMWMyZmZiZWRkZDJlM2IiLCJpYXQiOjE2ODI5MDg0MjIuNDA4MTExLCJuYmYiOjE2ODI5MDg0MjIuNDA4MTE1LCJleHAiOjE3MTQ1MzA4MjIuMTYxMTExLCJzdWIiOiI3Iiwic2NvcGVzIjpbXX0.JZSCQ0RtYOiQgutK4fD_oKKl6E6yyxQRioCRKxpOIwdN6byh0aos0MaYYQJ5uYHanon_NycnHxFobCRNbUuuoWsilmLwWYq3d0O-JLHamueZDBQdMWSe7-2pouHGKZ4Eg0tu669ASEJf-FVcIGVeWLDoyzIMJAgQARoV1rHtf_XHSBQjWiDZWP1aRTUoMizGdYNOldLYYNBVzCLkF_9-ZYUtMuZsYScncbW8MSuBGi_w4mMV9A_c6AYWw_KFMEsl55cD1SM8jupE05RDBeaUuVFIvJiz0XL1psQlVmoyv_LQj0FXM77y-Ot2QNpXsSQh_kztFDb5t-ttDaY7yXOCN2OSql_hAX_yomxbFzRVGm8Qs6l-vNVK4qT2bFK4lc5G2v8rWGM7A1JSqFAeByRe9dWF6Q-MBwz2JY-0OXNenmQ3SrLp59fc9DSKppSh6oSNzVHQx9uD0Fum5g9YFllpCRuGxd_c9AXoPHz6x9_EKIjLhtsywvEfVBhMu4hE9m4BWMtF9LqJzU-ogpme9rLouvqHzZTEjAtbPjbCLPZ8-BI7cNPy-Bozprl4mnzLCaSoE4Lb9Yvid3zzxBniNswchypqBBGIALlR84IHmRg_QCc7TYDlXLGzV63KCP29XOQZK29vHP7XalLRpnrVkYmVHhZip7QsexkcOKgkvJchN8k', '2022-11-17 22:55:47', '2023-04-30 23:33:42'),
(30, 'Raouf', NULL, NULL, NULL, NULL, NULL, NULL, 'raouf@hotmail.com', NULL, '$2a$12$xvkjSScUPRexfcJTAy9ATutIeGUuRgJrjDIdL/.xlrddEvRZINpeC', 1, NULL, 'DUCpVtiKrL2j2Mr9FPfWdXwY9N74CRjUgBRTRIX1rEqnCMUVZQygaHyRLOoz', '2023-04-23 22:16:37', '2023-04-23 22:16:37'),
(34, 'Farag', NULL, NULL, NULL, NULL, NULL, NULL, 'farag@hotmail.com', NULL, '$2a$12$xvkjSScUPRexfcJTAy9ATutIeGUuRgJrjDIdL/.xlrddEvRZINpeC', 1, NULL, 'eyJ0eXAiOiJKV1QiLCJhbGciOiJSUzI1NiJ9.eyJhdWQiOiIxIiwianRpIjoiZmQ4YjVlZWE5MDg4ZjE1MmUwNzQ1YmJhNjJmYzE2NWQ3YjUzMTM5YjM3ZTAwZDQwYjEyMzU0NDI5NTYyZmNjMjFlZWZkMjlkYmRlODFjNDMiLCJpYXQiOjE2ODI5MDU2OTEuMDEyMjI2LCJuYmYiOjE2ODI5MDU2OTEuMDEyMjI5LCJleHAiOjE3MTQ1MjgwOTAuNzU3ODAyLCJzdWIiOiIzNCIsInNjb3BlcyI6W119.HWzoeLfegHgLJE_bxRgsQfvT-V-2SZNR-k5_Z9NV1cIEFPxcSziCYUlHFGh38JjDWGKQy2cQEVym4jtBNJo_OFj31OVBNmZfj6P7odQve-R-NRiDxBBoX43RNlh5bAVkw2UPMZZ9B8wLcsFjxBxfJMg5M1zU1X05OuQnp4x9tgQJJzlCV9l1XIRmthhmT7_mKeirOVW_j9cCeQY9HZyiZbzU_1hWltourDqVmWiQhAkdA4Im7JF4pD98jgfu_vBntdr-7KZZhkXDgF1YqelTpuzCP8bqPyqMry6GLLZYMAtrmo_iiN3I50GVE_MKw9mEy26o5y4dkLdkNHbHy5JFdxS2iVyc3MDj2LyxCUciyqheEDaavTPq48toBBexg2kv9EFvtnvzC9b68InwN1mM0U9xbPCne4-6gZb5WLKnu1ybj2ljNuW0StEWZqqWgohaOsKYb0-6u5l7-sJKH-EMsZhtnwml5sxlsfs5ZSpVpGqgJFN3NHow2IZ5sNn44Ig_2wALVaBHxeHKzSnK7jhFuWc-Ew_26gpQdbyqhHGNq5Rq_UOngqEPwdH0KgP4triZxsnehhMwJZrTMEefeBOfdc-x207iIQ_wN6cnsi5dG_FRu6Om9BCjjoohKkxbUhIOARBWHSZGCb3QHvB1sOCAlhxxAXwYBDLhyVMU438amQQ', '2023-04-30 22:48:10', '2023-04-30 22:48:11');

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

--
-- Table structure for table `vendors`
--

CREATE TABLE `vendors` (
  `id` bigint UNSIGNED NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pincode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `confirm` enum('No','Yes') CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'No',
  `commission` double(8,2) NOT NULL,
  `status` tinyint 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 `vendors`
--

INSERT INTO `vendors` (`id`, `name`, `address`, `city`, `state`, `country`, `pincode`, `mobile`, `email`, `confirm`, `commission`, `status`, `created_at`, `updated_at`) VALUES
(1, 'Yasser Fouaad - Vendor', '17 El-Salam St.', 'Maadi', 'Cairo', 'Egypt', '33315', '01259598421', 'yasser@admin.com', 'No', 5.00, 1, NULL, '2023-04-21 23:21:23'),
(5, 'Samir Morsy', '9 Fouaad St.', 'Bab Shark', 'Alexandria', 'Egypt', NULL, '01154572136', 'samir@yahoo.com', 'No', 5.00, 1, '2022-10-13 22:55:41', '2023-04-18 14:07:27'),
(6, 'Ramy Saeed', '25 El-Amana St.', 'Zagazig', 'Sharkia', 'Egypt', '54151', '01098571935', 'ramy@admin.com', 'Yes', 3.00, 0, '2022-10-14 01:20:03', '2023-04-18 14:08:12'),
(8, 'Safaa Masoud', '14 Talaat Harb St.', 'Abo Tesht', 'Qena', 'Egypt', NULL, '01255374956', 'safaa@vendor.com', 'Yes', 0.00, 0, '2022-10-14 18:46:53', '2022-10-14 23:23:51'),
(9, 'Ghali Shennway', '8 Fady Safwat St.', 'El Ganayen', 'Suez', 'Egypt', NULL, '01154557789', 'ghali@yahoo.com', 'Yes', 0.00, 1, '2022-10-14 18:48:28', '2022-10-14 18:48:28');

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

--
-- Table structure for table `vendors_bank_details`
--

CREATE TABLE `vendors_bank_details` (
  `id` bigint UNSIGNED NOT NULL,
  `vendor_id` int NOT NULL,
  `account_holder_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bank_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `account_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `bank_ifsc_code` varchar(255) CHARACTER SET utf8mb4 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 `vendors_bank_details`
--

INSERT INTO `vendors_bank_details` (`id`, `vendor_id`, `account_holder_name`, `bank_name`, `account_number`, `bank_ifsc_code`, `created_at`, `updated_at`) VALUES
(1, 1, 'Yasser Fouaad', 'CIB', '777777', '55555', NULL, NULL),
(2, 6, 'Ramy Saeed', 'HSBC', '5124152415', '5458745', NULL, '2022-10-15 21:28:44');

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

--
-- Table structure for table `vendors_business_details`
--

CREATE TABLE `vendors_business_details` (
  `id` bigint UNSIGNED NOT NULL,
  `vendor_id` int NOT NULL,
  `shop_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shop_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shop_city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shop_state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shop_country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shop_pincode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shop_mobile` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shop_website` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `shop_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_proof` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `address_proof_image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `business_license_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `gst_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `pan_number` varchar(255) CHARACTER SET utf8mb4 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 `vendors_business_details`
--

INSERT INTO `vendors_business_details` (`id`, `vendor_id`, `shop_name`, `shop_address`, `shop_city`, `shop_state`, `shop_country`, `shop_pincode`, `shop_mobile`, `shop_website`, `shop_email`, `address_proof`, `address_proof_image`, `business_license_number`, `gst_number`, `pan_number`, `created_at`, `updated_at`) VALUES
(1, 1, 'Electronics World', '1234-Mall Road', 'New Cairo', 'Cairo', 'Egypt', '00000000000', '1111111111', 'amazon.com.eg', 'yasser@admin.com', 'Aadhar card', '52583.png', '2222222', '3333333337', '444444444', NULL, '2022-10-15 20:11:35'),
(2, 6, 'B Tech', 'test', 'sgs', 'sgsag', 'Bahrain', '454545', '1111111111', 'sagasga', NULL, 'PAN', '', '3333', '333333333', '11111', NULL, '2022-10-15 21:19:44'),
(3, 9, 'Ghali Vendor', NULL, 'Cairo', NULL, NULL, NULL, '0113335845', NULL, NULL, 'Passport', '', NULL, NULL, NULL, NULL, NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `admins_email_unique` (`email`);

--
-- 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 `carts`
--
ALTER TABLE `carts`
  ADD PRIMARY KEY (`id`);

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

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

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

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

--
-- Indexes for table `delivery_addresses`
--
ALTER TABLE `delivery_addresses`
  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 `migrations`
--
ALTER TABLE `migrations`
  ADD PRIMARY KEY (`id`);

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

--
-- Indexes for table `oauth_access_tokens`
--
ALTER TABLE `oauth_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_access_tokens_user_id_index` (`user_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_clients`
--
ALTER TABLE `oauth_clients`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_clients_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 `oauth_refresh_tokens`
--
ALTER TABLE `oauth_refresh_tokens`
  ADD PRIMARY KEY (`id`),
  ADD KEY `oauth_refresh_tokens_access_token_id_index` (`access_token_id`);

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

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

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

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

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

--
-- Indexes for table `password_resets`
--
ALTER TABLE `password_resets`
  ADD KEY `password_resets_email_index` (`email`);

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

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- Indexes for table `vendors`
--
ALTER TABLE `vendors`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `vendors_email_unique` (`email`);

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `banners`
--
ALTER TABLE `banners`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `brands`
--
ALTER TABLE `brands`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `carts`
--
ALTER TABLE `carts`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `cod_pincodes`
--
ALTER TABLE `cod_pincodes`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=302;

--
-- AUTO_INCREMENT for table `countries`
--
ALTER TABLE `countries`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=247;

--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `delivery_addresses`
--
ALTER TABLE `delivery_addresses`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

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

--
-- AUTO_INCREMENT for table `migrations`
--
ALTER TABLE `migrations`
  MODIFY `id` int UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=52;

--
-- AUTO_INCREMENT for table `newsletter_subscribers`
--
ALTER TABLE `newsletter_subscribers`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

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

--
-- AUTO_INCREMENT for table `orders_products`
--
ALTER TABLE `orders_products`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `recently_viewed_products`
--
ALTER TABLE `recently_viewed_products`
  MODIFY `id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=141;
COMMIT;

/*!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 */;