-- phpMyAdmin SQL Dump
-- version 4.9.4
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Generation Time: Dec 21, 2020 at 06:55 AM
-- Server version: 5.6.49-cll-lve
-- PHP Version: 7.3.6

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
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: `AliXpress`
--

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

--
-- Table structure for table `AboutUs`
--

CREATE TABLE `AboutUs` (
  `id` int(11) NOT NULL,
  `subject` text,
  `detail` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `AboutUs`
--

INSERT INTO `AboutUs` (`id`, `subject`, `detail`) VALUES
(1, 'About Us', '<p id=\"docs-internal-guid-5a035dfd-7fff-eb5a-2d36-cf177b7467cc\" dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We are committed to protecting your privacy</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><em><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We collect the minimum amount of information about you that is commensurate with providing you with a satisfactory service. This policy indicates the type of processes that may result in data being collected about you. Your use of this website gives us the right to collect that information. </span></em></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Information Collected</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We may collect any or all of the information that you give us depending on the type of transaction you enter into, including your name, address, telephone number, and email address, together with data about your use of the website. Other information that may be needed from time to time to process a request may also be collected as indicated on the website.&rsquo;</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We use </span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Location Permissions</span></p>\r\n<ul style=\"margin-top: 0pt; margin-bottom: 0pt;\">\r\n<li dir=\"ltr\" style=\"list-style-type: disc; font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\">\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Location Access (For accessing Weather forecasting of specific location)</span></p>\r\n</li>\r\n</ul>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Information Use</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We use the information collected primarily to process the task for which you visited the website. Data collected in the UK is held in accordance with the Data Protection Act. All reasonable precautions are taken to prevent unauthorised access to this information. This safeguard may require you to provide additional forms of identity should you wish to obtain information about your account details.</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Cookies</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Your Internet browser has the in-built facility for storing small files - \"cookies\" - that hold information which allows a website to recognise your account. Our website takes advantage of this facility to enhance your experience. You have the ability to prevent your computer from accepting cookies but, if you do, certain functionality on the website may be impaired.</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Disclosing Information</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We do not disclose any personal information obtained about you from this website to third parties unless you permit us to do so by ticking the relevant boxes in registration or competition forms. We may also use the information to keep in contact with you and inform you of developments associated with us. You will be given the opportunity to remove yourself from any mailing list or similar device. If at any time in the future we should wish to disclose information collected on this website to any third party, it would only be with your knowledge and consent. </span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We may from time to time provide information of a general nature to third parties - for example, the number of individuals visiting our website or completing a registration form, but we will not use any information that could identify those individuals. </span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">In addition Dummy may work with third parties for the purpose of delivering targeted behavioural advertising to the Dummy website. Through the use of cookies, anonymous information about your use of our websites and other websites will be used to provide more relevant adverts about goods and services of interest to you. For more information on online behavioural advertising and about how to turn this feature off, please visit youronlinechoices.com/opt-out.</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Changes to this Policy</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Any changes to our Privacy Policy will be placed here and will supersede this version of our policy. We will take reasonable steps to draw your attention to any changes in our policy. However, to be on the safe side, we suggest that you read this document each time you use the website to ensure that it still meets with your approval.</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Contacting Us</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">If you have any questions about our Privacy Policy, or if you want to know what information we have collected about you, please email us at yourEmail@gmail.com. You can also correct any factual errors in that information or require us to remove your details form any list under our control.</span></p>\r\n<p><br /><br /><br /><br /><br /></p>');

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

--
-- Table structure for table `Admin`
--

CREATE TABLE `Admin` (
  `id` int(11) NOT NULL,
  `email` text,
  `password` text,
  `type` varchar(150) NOT NULL DEFAULT 'admin',
  `encryption_key` text,
  `encryption_text` text,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Admin`
--

INSERT INTO `Admin` (`id`, `email`, `password`, `type`, `encryption_key`, `encryption_text`, `enable`) VALUES
(1, 'admin@gmail.com', 'SRUFoxgU', 'admin', 'Admin', '1234567891011121', 0);

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

--
-- Table structure for table `AttributeItem`
--

CREATE TABLE `AttributeItem` (
  `id` int(11) NOT NULL,
  `attribute_id` text,
  `image` text,
  `name` text,
  `price` text,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `AttributeItem`
--

INSERT INTO `AttributeItem` (`id`, `attribute_id`, `image`, `name`, `price`, `enable`) VALUES
(1, '1', '18.webp', 'Black Case + Black', '16.74', 0),
(2, '1', NULL, 'Silver Case + Black', '18', 0),
(3, '1', NULL, 'Yellow Case + Black', '16.74', 0),
(4, '1', NULL, 'Blue Case + Black', '18', 0);

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

--
-- Table structure for table `BankingDetail`
--

CREATE TABLE `BankingDetail` (
  `id` int(11) NOT NULL,
  `term_id` text,
  `meta_key` text,
  `bank_name` text,
  `branch_code` text,
  `account_holder_name` text,
  `account_no` text,
  `iban_no` text,
  `cheque_picture` text,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `BankingDetail`
--

INSERT INTO `BankingDetail` (`id`, `term_id`, `meta_key`, `bank_name`, `branch_code`, `account_holder_name`, `account_no`, `iban_no`, `cheque_picture`, `enable`) VALUES
(1, '1', 'brand detail', NULL, NULL, NULL, NULL, NULL, NULL, 0);

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

--
-- Table structure for table `Brand`
--

CREATE TABLE `Brand` (
  `id` int(11) NOT NULL,
  `category_id` text,
  `sub_category_id` text,
  `name` text,
  `cover_photo` text,
  `image` text,
  `address` text,
  `featured` int(11) NOT NULL DEFAULT '0',
  `enable` int(11) DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Brand`
--

INSERT INTO `Brand` (`id`, `category_id`, `sub_category_id`, `name`, `cover_photo`, `image`, `address`, `featured`, `enable`, `date_created`) VALUES
(1, '7', '13,14', 'Lenovo', '20200316232405_684.jpg.webp', '20190823030952_423.png.webp', NULL, 1, 0, '2020-07-27 00:10:26'),
(2, '7', '14', 'Xiomi', '20200316232405_684.jpg.webp', '20190915221646_482.jpg.webp', NULL, 1, 0, '2020-07-27 00:10:26'),
(3, '7', '15', 'Samsung', '20200316232405_684.jpg.webp', '20191010042100_586.jpg.webp', NULL, 0, 0, '2020-07-27 00:10:26'),
(4, '7', '15', 'Current', '20200316232405_684.jpg.webp', '20190819224301_565.jpg.webp', NULL, 0, 0, '2020-07-27 00:10:26');

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

--
-- Table structure for table `BrandCredentials`
--

CREATE TABLE `BrandCredentials` (
  `id` int(11) NOT NULL,
  `term_id` text,
  `meta_key` text,
  `email` text,
  `password` text,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `BrandMonthlyEarning`
--

CREATE TABLE `BrandMonthlyEarning` (
  `id` int(11) NOT NULL,
  `brand_id` text,
  `total_sales` text,
  `total_earning` text,
  `status` int(150) NOT NULL DEFAULT '0' COMMENT '0 = pending , 1 = sent',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `Cart`
--

CREATE TABLE `Cart` (
  `id` int(11) NOT NULL,
  `user_id` text,
  `brand_id` text,
  `product_id` text,
  `quantity` text,
  `price` text,
  `courier_id` int(11) DEFAULT '0',
  `selector` int(11) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '0',
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Cart`
--

INSERT INTO `Cart` (`id`, `user_id`, `brand_id`, `product_id`, `quantity`, `price`, `courier_id`, `selector`, `status`, `enable`) VALUES
(31, '1', '1', '1', '4', '100', 1, 0, 0, 0),
(32, '1', '1', '1', '2', '100', 1, 0, 0, 1),
(33, '1', '1', '2', '2', '100', 1, 0, 0, 0),
(34, '1', '1', '1', '2', '100', 1, 0, 0, 0),
(35, '1', '1', '1', '2', '100', 1, 0, 0, 0),
(36, '1', '1', '1', '2', '100', 1, 0, 0, 0),
(42, '6', '1', '1', '4', '14.23', 1, 0, 1, 0),
(43, '8', '1', '1', '3', '14.23', 3, 0, 1, 0),
(44, '8', '1', '1', '2', '14.23', 1, 0, 1, 0),
(49, '10', '1', '1', '1', '14.23', 1, 0, 0, 0),
(50, '10', '1', '1', '1', '14.23', 1, 0, 0, 0),
(48, '10', '1', '1', '1', '14.23', 1, 0, 0, 0),
(52, '7', '1', '1', '1', '14.23', 1, 0, 0, 0),
(53, '10', '1', '1', '1', '14.23', 3, 0, 0, 0),
(54, '10', '1', '1', '1', '14.23', 3, 0, 0, 0),
(55, '10', '1', '1', '1', '14.23', 3, 0, 0, 0),
(56, '10', '1', '1', '1', '14.23', 3, 0, 0, 0),
(57, '8', '1', '1', '2', '14.23', 1, 0, 0, 0);

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

--
-- Table structure for table `CartMeta`
--

CREATE TABLE `CartMeta` (
  `id` int(11) NOT NULL,
  `cart_id` text,
  `attribute_id` text NOT NULL,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CartMeta`
--

INSERT INTO `CartMeta` (`id`, `cart_id`, `attribute_id`, `enable`) VALUES
(47, '37', '1', 0),
(46, '36', '1', 0),
(45, '35', '1', 0),
(44, '34', '1', 0),
(43, '33', '', 0),
(42, '32', '', 0),
(41, '31', '1', 0),
(40, '30', '1', 0),
(39, '29', '1', 0),
(38, '28', '1', 0),
(37, '27', '1', 0),
(36, '26', '1', 0),
(35, '25', '1', 0),
(34, '24', '1', 0),
(48, '38', '1', 0),
(49, '39', '1', 0),
(50, '40', '1', 0),
(51, '41', '1', 0),
(52, '42', '1', 0),
(53, '43', '1', 0),
(54, '44', '3', 0),
(55, '45', '1', 0),
(56, '46', '1', 0),
(57, '47', '1', 0),
(58, '48', '2', 0),
(59, '49', '2', 0),
(60, '49', '2', 0),
(61, '50', '2', 0),
(62, '50', '2', 0),
(63, '50', '2', 0),
(64, '51', '', 0),
(65, '52', '1', 0),
(66, '53', '', 0),
(67, '54', '', 0),
(68, '55', '', 0),
(69, '56', '', 0),
(70, '57', '1', 0);

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

--
-- Table structure for table `Categories`
--

CREATE TABLE `Categories` (
  `id` int(11) NOT NULL,
  `name` text,
  `image` text,
  `position` text,
  `home_item` int(11) DEFAULT '0',
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Categories`
--

INSERT INTO `Categories` (`id`, `name`, `image`, `position`, `home_item`, `enable`) VALUES
(1, 'Men\'s Clothing', 'ic_men_clothing.webp', '5', NULL, 0),
(2, 'Women\'s Clothing', 'ic_women_clothing.png', '3', NULL, 0),
(3, 'Automobiles & Motorcycles', 'ic_automobile.webp', '8', NULL, 0),
(4, 'Health & Beauty', 'ic_health_beauty.webp', '5', NULL, 0),
(5, 'Electronics', 'ic_electronics.webp', '6', NULL, 0),
(6, 'Computer & Networking', 'ic_computer_networking.webp', '9', NULL, 0),
(7, 'Jewelry & Watch', 'ic_jewelry_watches.webp', '1', NULL, 0),
(8, 'Phones & Telecom', 'ic_phone_telecom.webp', '8', NULL, 0),
(9, 'Home & Garden', 'ic_home.webp', '8', NULL, 0),
(10, 'Toys Hobbies & Robot', NULL, '9', NULL, 1);

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

--
-- Table structure for table `ChildSubCategories`
--

CREATE TABLE `ChildSubCategories` (
  `id` int(11) NOT NULL,
  `sub_category_id` text,
  `name` text,
  `image` text,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ChildSubCategories`
--

INSERT INTO `ChildSubCategories` (`id`, `sub_category_id`, `name`, `image`, `enable`) VALUES
(1, '1', 'Hats & Caps', '1234', 0),
(2, '1', 'Belts', '1234', 0),
(3, '1', 'Eyeglasses', '1234', 0),
(4, '1', 'Socks', '1234', 0),
(5, '2', 'TShirts', '1234', 0),
(6, '2', 'Shirts', '1234', 0),
(7, '2', 'Sweaters', '1234', 0),
(8, '2', 'Hoodies & SweatShirts', '1234', 0),
(9, '5', 'Hats & Caps', '1234', 0),
(10, '5', 'Belts', '1234', 0),
(11, '5', 'Headwear', '1234', 0),
(12, '5', 'Socks', '1234', 0),
(13, '5', 'Sunglasses & Eyeglasses', '1234', 0),
(14, '6', 'Midi Dresses', '1234', 0),
(15, '6', 'Maxi Dresses', '1234', 0),
(16, '6', 'Mini Dresses', '1234', 0),
(17, '6', 'Long Sleeves Dresses', '1234', 0),
(18, '6', 'Shirt', '1234', 0),
(19, '13', 'Quartz Watches', 'quartz.webp', 0),
(20, '13', 'Creative Watches', 'creative_watches.webp', 0),
(21, '13', 'Mechanical Watches', 'mechanical_watches.webp', 0),
(22, '13', 'Duel Display', 'sport_watches.webp', 0),
(23, '13', 'Pocket Watches', 'pocket_watches.webp', 0),
(24, '14', 'Fashion Style', 'fashion_watches.webp', 0),
(25, '14', 'Retro Watches', 'retro_style.webp', 0),
(26, '14', 'Casual Watches', 'casual_watches.webp', 0),
(27, '14', 'Couple Watches', 'couple_watches.webp', 0),
(28, '11', 'USB', '1234', 0),
(29, '11', 'HDD SSD Drive Holder', '1234', 0),
(30, '13', 'Digital Watches', 'digital_Watches.webp', 0);

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

--
-- Table structure for table `Configuration`
--

CREATE TABLE `Configuration` (
  `id` int(11) NOT NULL,
  `meta_key` text,
  `meta_value` text,
  `meta_value_02` text,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Configuration`
--

INSERT INTO `Configuration` (`id`, `meta_key`, `meta_value`, `meta_value_02`, `enable`) VALUES
(1, 'currency_data', 'USD', '$', 0);

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

--
-- Table structure for table `ContactUs`
--

CREATE TABLE `ContactUs` (
  `id` int(11) NOT NULL,
  `user_id` text,
  `subject` text,
  `detail` text,
  `enable` int(11) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ContactUs`
--

INSERT INTO `ContactUs` (`id`, `user_id`, `subject`, `detail`, `enable`, `date_created`) VALUES
(1, '1', 'testing subject', '2846465424', 0, '2020-10-08 00:41:37'),
(2, '8', 'hvv', 'bffthn', 0, '2020-11-03 03:51:31');

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

--
-- Table structure for table `Coupon`
--

CREATE TABLE `Coupon` (
  `id` int(11) NOT NULL,
  `brand_id` text,
  `child_sub_category_id` text,
  `name` text,
  `tagline` text,
  `code` text,
  `type` text COMMENT 'CouponMeta',
  `offer` text,
  `nature` text COMMENT 'CouponCategory',
  `usage_count` int(11) DEFAULT '0' COMMENT 'No of user use this coupon',
  `price_discount_value` varchar(100) DEFAULT '0' COMMENT 'Price condition for price discount',
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime(6) DEFAULT NULL,
  `user_count` text COMMENT 'how many user can use this coupon',
  `duration_limit` int(11) NOT NULL DEFAULT '0' COMMENT 'Condition for start and end time (0 = ok , 1 = not ok )',
  `user_limit` int(11) NOT NULL DEFAULT '0' COMMENT 'Condition for user usage limit (0 = ok , 1 = not ok )',
  `enable` int(11) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Coupon`
--

INSERT INTO `Coupon` (`id`, `brand_id`, `child_sub_category_id`, `name`, `tagline`, `code`, `type`, `offer`, `nature`, `usage_count`, `price_discount_value`, `start_date`, `end_date`, `user_count`, `duration_limit`, `user_limit`, `enable`, `date_created`) VALUES
(1, '1', '1', '12% Off', '12% off for Men Watches', 'ABCFGH', '4', '12', '4', 0, '60', '2020-08-11 23:34:17', '2020-11-30 23:34:17.000000', '40', 1, 0, 0, '2020-08-11 23:10:42'),
(2, '2', '20', '22% Off', '22% off for Men Watches', 'ABCF', '1', '12', '2', 0, '0', '2020-08-11 23:34:17', '2020-08-11 23:34:17.000000', '30', 0, 0, 0, '2020-08-11 23:10:42'),
(3, '3', '22', '42% Off', '12% off for Men Watches', 'ABC', '1', '12', '2', 0, '0', '2020-08-11 23:34:17', '2020-08-11 23:34:17.000000', '50', 0, 0, 0, '2020-08-11 23:10:42'),
(4, '3', '3', '42% Off', '12% off for Men Watches', 'AB', '1', '12', '1', 0, '0', '2020-08-11 23:34:17', '2020-08-11 23:34:17.000000', '20', 0, 0, 0, '2020-08-11 23:10:42'),
(5, '1', '36', 'coupon name', NULL, 'coupon code', '2', '2', '1', 0, '500', '2020-02-12 15:22:00', '0000-00-00 00:00:00.000000', '40', 0, 0, 0, '2020-12-03 04:36:58'),
(6, '1', '36', 'coupon name', NULL, 'coupon code', '2', '2', '1', 0, '500', '2020-02-12 15:22:00', '0000-00-00 00:00:00.000000', '40', 0, 0, 0, '2020-12-03 04:39:00');

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

--
-- Table structure for table `CouponCategory`
--

CREATE TABLE `CouponCategory` (
  `id` int(11) NOT NULL,
  `name` text,
  `enable` int(11) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CouponCategory`
--

INSERT INTO `CouponCategory` (`id`, `name`, `enable`, `date_created`) VALUES
(1, 'Store', 0, '2020-08-21 04:42:56'),
(2, 'Category', 0, '2020-08-21 04:42:56'),
(3, 'Product', 0, '2020-08-21 04:42:56'),
(4, 'All', 0, '2020-08-21 04:42:56');

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

--
-- Table structure for table `CouponMeta`
--

CREATE TABLE `CouponMeta` (
  `id` int(11) NOT NULL,
  `name` text,
  `enable` int(11) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CouponMeta`
--

INSERT INTO `CouponMeta` (`id`, `name`, `enable`, `date_created`) VALUES
(1, 'Percentage', 0, '2020-08-11 23:10:32'),
(2, 'Price', 0, '2020-08-11 23:10:32'),
(3, 'Shipping', 0, '2020-08-11 23:10:32'),
(4, 'Fixed', 0, '2020-08-11 23:10:32');

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

--
-- Table structure for table `CustomizedShipping`
--

CREATE TABLE `CustomizedShipping` (
  `id` int(11) NOT NULL,
  `logo` text,
  `name` text,
  `type` text,
  `estimated_delivery_days` text,
  `currency_symbol` text,
  `currency_code` text,
  `weight_condition` int(11) DEFAULT '0',
  `enable` int(11) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `CustomizedShipping`
--

INSERT INTO `CustomizedShipping` (`id`, `logo`, `name`, `type`, `estimated_delivery_days`, `currency_symbol`, `currency_code`, `weight_condition`, `enable`, `date_created`) VALUES
(1, 'ic_leopard.webp', 'Leopard', 'customized', '2-3 days', '$', 'USD', 0, 0, '2020-08-31 23:35:48'),
(2, 'ic_usps.webp', 'USPS Courier', 'international', '2-9 days', '$', 'USD', 0, 0, '2020-08-31 23:35:48'),
(3, 'ic_tcs_courier.webp', 'TCS', 'customized', '1-6 days', '$', 'USD', 0, 0, '2020-08-31 23:35:48');

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

--
-- Table structure for table `Dispute`
--

CREATE TABLE `Dispute` (
  `id` int(11) NOT NULL,
  `term_id` text,
  `user_id` text,
  `status` varchar(150) NOT NULL DEFAULT '0' COMMENT '0 = unresolved , 1 = resolved ',
  `enable` int(11) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Dispute`
--

INSERT INTO `Dispute` (`id`, `term_id`, `user_id`, `status`, `enable`, `date_created`) VALUES
(1, '1', '1', '0', 0, '2020-10-06 03:59:38'),
(2, '1', '1', '0', 0, '2020-10-06 04:23:14'),
(3, '3', '8', '0', 0, '2020-11-03 03:35:45');

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

--
-- Table structure for table `Favourite`
--

CREATE TABLE `Favourite` (
  `id` int(11) NOT NULL,
  `user_id` text,
  `meta_key` text,
  `meta_value` text,
  `enable` int(11) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Favourite`
--

INSERT INTO `Favourite` (`id`, `user_id`, `meta_key`, `meta_value`, `enable`, `date_created`) VALUES
(6, '1', 'favourite_product', '1', 0, '2020-09-11 00:37:57'),
(5, '1', 'favourite_store', '1', 1, '2020-08-22 04:59:03'),
(7, '1', 'favourite_store', '1', 0, '2020-10-09 05:17:57'),
(8, '1', 'favourite_product', '1', 0, '2020-10-16 04:01:49'),
(15, '8', 'favourite_store', '1', 0, '2020-11-03 04:50:37');

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

--
-- Table structure for table `FeaturedBanner`
--

CREATE TABLE `FeaturedBanner` (
  `id` int(11) NOT NULL,
  `name` text,
  `image` text,
  `type` text,
  `sale_type` text,
  `sale_price` text,
  `enable` int(11) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `FeaturedBanner`
--

INSERT INTO `FeaturedBanner` (`id`, `name`, `image`, `type`, `sale_type`, `sale_price`, `enable`, `date_created`) VALUES
(1, 'Health Care & Fitness Sale', '20200711033430_458.jpg.webp', 'list', '1', '5', 0, '2020-08-08 02:59:07'),
(2, 'RC Toys & Robots', '20200711031137_140.jpg.webp', 'product', '2', '20', 0, '2020-08-08 03:03:48');

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

--
-- Table structure for table `FeaturedBannerMeta`
--

CREATE TABLE `FeaturedBannerMeta` (
  `id` int(11) NOT NULL,
  `featured_id` text,
  `store_id` text,
  `product_id` text,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `FeaturedBannerMeta`
--

INSERT INTO `FeaturedBannerMeta` (`id`, `featured_id`, `store_id`, `product_id`, `enable`) VALUES
(1, '1', '1', '1', 0),
(2, '2', '1', '1', 0),
(3, '1', '1', '2', 0);

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

--
-- Table structure for table `Following`
--

CREATE TABLE `Following` (
  `id` int(11) NOT NULL,
  `user_id` text,
  `meta_key` text,
  `meta_value` text,
  `enable` int(11) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Following`
--

INSERT INTO `Following` (`id`, `user_id`, `meta_key`, `meta_value`, `enable`, `date_created`) VALUES
(9, '8', 'favourite_store', '1', 0, '2020-11-03 04:44:09'),
(6, '1', 'favourite_product', '1', 0, '2020-10-09 23:30:06'),
(10, '10', 'favourite_store', '2', 0, '2020-11-05 18:37:10');

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

--
-- Table structure for table `HomeFeaturedCategories`
--

CREATE TABLE `HomeFeaturedCategories` (
  `id` int(11) NOT NULL,
  `child_sub_categories` text,
  `name` text,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `HomeFeaturedCategories`
--

INSERT INTO `HomeFeaturedCategories` (`id`, `child_sub_categories`, `name`, `enable`) VALUES
(1, '19,6,2', 'Men', 0),
(2, '24', 'Women', 0);

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

--
-- Table structure for table `ListOfOrders`
--

CREATE TABLE `ListOfOrders` (
  `id` int(11) NOT NULL,
  `order_no` text,
  `user_id` text,
  `address_id` text,
  `coupon_id` varchar(50) NOT NULL DEFAULT '0',
  `total_amount` text NOT NULL,
  `shipping_fee` text NOT NULL,
  `currency_code` text NOT NULL,
  `currency_symbol` text NOT NULL,
  `discounted_amount` text,
  `transaction_token` text,
  `status` int(11) NOT NULL DEFAULT '0' COMMENT '0 = pending , 1 = processed , 2 completed',
  `enable` int(11) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ListOfOrders`
--

INSERT INTO `ListOfOrders` (`id`, `order_no`, `user_id`, `address_id`, `coupon_id`, `total_amount`, `shipping_fee`, `currency_code`, `currency_symbol`, `discounted_amount`, `transaction_token`, `status`, `enable`, `date_created`) VALUES
(1, '4277', '7', '1', '0', '85.26', '200.0', 'USD', '$', '0', NULL, 0, 0, '2020-12-07 13:28:09'),
(2, '4278', '1', '1', '0', '85.26', '200.0', 'USD', '$', '0', NULL, 0, 0, '2020-12-16 00:11:44'),
(3, '4279', '1', '1', '0', '85.26', '200.0', 'USD', '$', '0', NULL, 0, 0, '2020-12-16 00:11:44'),
(4, '4280', '1', '1', '0', '85.26', '200.0', 'USD', '$', '0', NULL, 0, 0, '2020-12-16 00:11:44'),
(5, '4281', '1', '1', '0', '85.26', '200.0', 'USD', '$', '0', NULL, 0, 0, '2020-12-16 00:11:44'),
(6, '4282', '1', '1', '0', '85.26', '200.0', 'USD', '$', '0', NULL, 0, 0, '2020-12-16 00:11:44'),
(7, '4283', '1', '1', '0', '85.26', '200.0', 'USD', '$', '0', NULL, 0, 0, '2020-12-16 00:11:44'),
(8, '4284', '1', '1', '0', '85.26', '200.0', 'USD', '$', '0', NULL, 0, 0, '2020-12-16 00:11:44'),
(9, '4285', '1', '1', '0', '85.26', '201.97', 'USD', '$', '0', NULL, 0, 1, '2020-12-16 00:11:44'),
(10, '5084', '1', '1', '0', '85.26', '201.97', 'USD', '$', '0', 'ch_1HZCy4HjWgc1Hu3ruPs0Hw4y', 0, 0, '2020-12-16 00:11:44'),
(11, '9877', '1', '1', '0', '85.26', '201.97', 'USD', '$', '0', 'ch_1HZD1kHjWgc1Hu3rcxdHlfDR', 0, 0, '2020-12-16 00:11:44'),
(12, '3836', '6', '3', '0', '56.92', '201.23', 'USD', '$', '0', 'ch_1HhZqaHjWgc1Hu3r4RodW6UO', 0, 0, '2020-12-16 00:11:44'),
(13, '1977', '6', '3', '0', '56.92', '201.23', 'USD', '$', '0', 'ch_1HhZsDHjWgc1Hu3rIVueSA74', 0, 0, '2020-12-16 00:11:44'),
(14, '8545', '6', '3', '0', '56.92', '201.23', 'USD', '$', '0', 'ch_1HhZtqHjWgc1Hu3rXeaxAmEk', 0, 0, '2020-12-16 00:11:44'),
(15, '0185', '8', '8', '0', '71.15', '501.95', 'USD', '$', '0', 'ch_1HiwyAHjWgc1Hu3rViyhp7Td', 0, 0, '2020-12-16 00:11:44'),
(16, '0374', '8', '8', '0', '71.15', '501.95', 'USD', '$', '561.1', 'ch_1HixLgHjWgc1Hu3r00qAUFRd', 0, 0, '2020-12-16 00:11:44');

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

--
-- Table structure for table `OrderMeta`
--

CREATE TABLE `OrderMeta` (
  `id` int(11) NOT NULL,
  `term_id` text,
  `brand_id` text,
  `product_id` text,
  `attribute_id` text,
  `quantity` text,
  `price` text,
  `coupon_id` text,
  `discounted_amount` text,
  `shipping_id` text,
  `package_id` text,
  `courier_rate` text,
  `weight` text,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `OrderMeta`
--

INSERT INTO `OrderMeta` (`id`, `term_id`, `brand_id`, `product_id`, `attribute_id`, `quantity`, `price`, `coupon_id`, `discounted_amount`, `shipping_id`, `package_id`, `courier_rate`, `weight`, `enable`) VALUES
(1, '1', '1', '2', '', '2', '9.15', '', '', '1', '1', '100', NULL, 0),
(2, '1', '2', '1', '1', '4', '16.74', '', '', '1', '1', '100', NULL, 0),
(3, '2', '1', '2', '', '2', '9.15', '', '', '1', '1', '100', NULL, 0),
(4, '2', '2', '1', '1', '4', '16.74', '', '', '1', '1', '100', NULL, 0),
(5, '3', '1', '2', '', '2', '9.15', '', '', '1', '1', '100', NULL, 0),
(6, '3', '2', '1', '1', '4', '16.74', '', '', '1', '1', '100', NULL, 0),
(7, '4', '1', '2', '', '2', '9.15', '', '', '1', '1', '100', NULL, 0),
(8, '4', '2', '1', '1', '4', '16.74', '', '', '1', '1', '100', NULL, 0),
(9, '5', '1', '2', '', '2', '9.15', '', '', '1', '1', '100', NULL, 0),
(10, '5', '2', '1', '1', '4', '16.74', '', '', '1', '1', '100', NULL, 0),
(11, '6', '1', '2', '', '2', '9.15', '', '', '1', '1', '100', NULL, 0),
(12, '6', '2', '1', '1', '4', '16.74', '', '', '1', '1', '100', NULL, 0),
(13, '7', '1', '2', '', '2', '9.15', '', '', '1', '1', '100', NULL, 0),
(14, '7', '2', '1', '1', '4', '16.74', '', '', '1', '1', '100', NULL, 0),
(15, '8', '1', '2', '', '2', '9.15', '', '', '1', '1', '100', NULL, 0),
(16, '8', '2', '1', '1', '4', '16.74', '', '', '1', '1', '100', NULL, 0),
(17, '9', '1', '2', '', '2', '9.15', '', '', '1', '1', '100', NULL, 0),
(18, '9', '2', '1', '1', '4', '16.74', '', '', '1', '1', '100', NULL, 0),
(19, '10', '1', '2', '', '2', '9.15', '', '', '1', '1', '100', NULL, 0),
(20, '10', '2', '1', '1', '4', '16.74', '', '', '1', '1', '100', NULL, 0),
(21, '11', '1', '2', '', '2', '9.15', '', '', '1', '1', '100', NULL, 0),
(22, '11', '2', '1', '1', '4', '16.74', '', '', '1', '1', '100', NULL, 0),
(23, '12', '1', '1', '1', '4', '14.23', '', '', '1', '1', '200', NULL, 0),
(24, '13', '1', '1', '1', '4', '14.23', '', '', '1', '1', '200', NULL, 0),
(25, '14', '2', '1', '1', '4', '14.23', '', '', '1', '1', '200', NULL, 0),
(26, '15', '1', '1', '1', '2', '14.23', '', '', '1', '1', '200', NULL, 0),
(27, '15', '2', '1', '1', '3', '14.23', '', '', '3', '2', '300', NULL, 0),
(28, '16', '1', '1', '1', '2', '14.23', '1', '16.46', '1', '1', '200', NULL, 0),
(29, '16', '1', '1', '1', '3', '14.23', '1', '30.689999999999998', '3', '2', '300', NULL, 0);

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

--
-- Table structure for table `PaymentMethod`
--

CREATE TABLE `PaymentMethod` (
  `id` int(11) NOT NULL,
  `name` text,
  `image` text,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PaymentMethod`
--

INSERT INTO `PaymentMethod` (`id`, `name`, `image`, `enable`) VALUES
(1, 'Visa Card', 'ic_visa.webp', 0),
(2, 'Mastercard', 'ic_mastercard.webp', 0),
(3, 'Discover', 'ic_discover.webp', 0),
(4, 'American Express', 'ic_american_express.webp', 0),
(5, 'JCB', 'ic_jcb.webp', 0),
(6, 'Dinners Club', 'ic_dinners_club.webp', 0);

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

--
-- Table structure for table `PersonalDetail`
--

CREATE TABLE `PersonalDetail` (
  `id` int(11) NOT NULL,
  `term_id` text,
  `first_name` text,
  `last_name` text,
  `cnic` text,
  `phone_no` text,
  `address` text,
  `city` text,
  `postal_code` text,
  `country` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PersonalDetail`
--

INSERT INTO `PersonalDetail` (`id`, `term_id`, `first_name`, `last_name`, `cnic`, `phone_no`, `address`, `city`, `postal_code`, `country`) VALUES
(1, '1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);

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

--
-- Table structure for table `PrivacyPolicy`
--

CREATE TABLE `PrivacyPolicy` (
  `id` int(11) NOT NULL,
  `subject` text,
  `detail` text NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `PrivacyPolicy`
--

INSERT INTO `PrivacyPolicy` (`id`, `subject`, `detail`) VALUES
(1, 'Privacy Policy', '<p id=\"docs-internal-guid-5a035dfd-7fff-eb5a-2d36-cf177b7467cc\" dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We are committed to protecting your privacy</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><em><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We collect the minimum amount of information about you that is commensurate with providing you with a satisfactory service. This policy indicates the type of processes that may result in data being collected about you. Your use of this website gives us the right to collect that information. </span></em></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Information Collected</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We may collect any or all of the information that you give us depending on the type of transaction you enter into, including your name, address, telephone number, and email address, together with data about your use of the website. Other information that may be needed from time to time to process a request may also be collected as indicated on the website.&rsquo;</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We use </span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Location Permissions</span></p>\r\n<ul style=\"margin-top: 0pt; margin-bottom: 0pt;\">\r\n<li dir=\"ltr\" style=\"list-style-type: disc; font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\">\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Location Access (For accessing Weather forecasting of specific location)</span></p>\r\n</li>\r\n</ul>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Information Use</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We use the information collected primarily to process the task for which you visited the website. Data collected in the UK is held in accordance with the Data Protection Act. All reasonable precautions are taken to prevent unauthorised access to this information. This safeguard may require you to provide additional forms of identity should you wish to obtain information about your account details.</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Cookies</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Your Internet browser has the in-built facility for storing small files - \"cookies\" - that hold information which allows a website to recognise your account. Our website takes advantage of this facility to enhance your experience. You have the ability to prevent your computer from accepting cookies but, if you do, certain functionality on the website may be impaired.</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Disclosing Information</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We do not disclose any personal information obtained about you from this website to third parties unless you permit us to do so by ticking the relevant boxes in registration or competition forms. We may also use the information to keep in contact with you and inform you of developments associated with us. You will be given the opportunity to remove yourself from any mailing list or similar device. If at any time in the future we should wish to disclose information collected on this website to any third party, it would only be with your knowledge and consent. </span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We may from time to time provide information of a general nature to third parties - for example, the number of individuals visiting our website or completing a registration form, but we will not use any information that could identify those individuals. </span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">In addition Dummy may work with third parties for the purpose of delivering targeted behavioural advertising to the Dummy website. Through the use of cookies, anonymous information about your use of our websites and other websites will be used to provide more relevant adverts about goods and services of interest to you. For more information on online behavioural advertising and about how to turn this feature off, please visit youronlinechoices.com/opt-out.</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Changes to this Policy</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Any changes to our Privacy Policy will be placed here and will supersede this version of our policy. We will take reasonable steps to draw your attention to any changes in our policy. However, to be on the safe side, we suggest that you read this document each time you use the website to ensure that it still meets with your approval.</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Contacting Us</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">If you have any questions about our Privacy Policy, or if you want to know what information we have collected about you, please email us at yourEmail@gmail.com. You can also correct any factual errors in that information or require us to remove your details form any list under our control.</span></p>\r\n<p><br /><br /><br /><br /><br /></p>');

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

--
-- Table structure for table `Product`
--

CREATE TABLE `Product` (
  `id` int(11) NOT NULL,
  `category_id` text,
  `sub_category_id` text,
  `child_category_id` text,
  `brand_id` text,
  `image` text,
  `name` text,
  `description` text,
  `tags` text,
  `processing_time` text,
  `price` text,
  `weight` text,
  `enable` int(11) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Product`
--

INSERT INTO `Product` (`id`, `category_id`, `sub_category_id`, `child_category_id`, `brand_id`, `image`, `name`, `description`, `tags`, `processing_time`, `price`, `weight`, `enable`, `date_created`) VALUES
(1, '7', '13', '19', '1', 'f0b31042-4f67-4e81-8230-877eca143385_125.jpg.webp', 'DOM M-1288 Waterproof Creative Fashion Men Quartz Watch', '<p id=\"docs-internal-guid-5a035dfd-7fff-eb5a-2d36-cf177b7467cc\" dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We are committed to protecting your privacy</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><em><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We collect the minimum amount of information about you that is commensurate with providing you with a satisfactory service. This policy indicates the type of processes that may result in data being collected about you. Your use of this website gives us the right to collect that information. </span></em></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Information Collected</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We may collect any or all of the information that you give us depending on the type of transaction you enter into, including your name, address, telephone number, and email address, together with data about your use of the website. Other information that may be needed from time to time to process a request may also be collected as indicated on the website.&rsquo;</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We use </span><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Location Permissions</span></p>\r\n<ul style=\"margin-top: 0pt; margin-bottom: 0pt;\">\r\n<li dir=\"ltr\" style=\"list-style-type: disc; font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre;\">\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Location Access (For accessing Weather forecasting of specific location)</span></p>\r\n</li>\r\n</ul>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Information Use</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We use the information collected primarily to process the task for which you visited the website. Data collected in the UK is held in accordance with the Data Protection Act. All reasonable precautions are taken to prevent unauthorised access to this information. This safeguard may require you to provide additional forms of identity should you wish to obtain information about your account details.</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Cookies</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Your Internet browser has the in-built facility for storing small files - \"cookies\" - that hold information which allows a website to recognise your account. Our website takes advantage of this facility to enhance your experience. You have the ability to prevent your computer from accepting cookies but, if you do, certain functionality on the website may be impaired.</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Disclosing Information</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We do not disclose any personal information obtained about you from this website to third parties unless you permit us to do so by ticking the relevant boxes in registration or competition forms. We may also use the information to keep in contact with you and inform you of developments associated with us. You will be given the opportunity to remove yourself from any mailing list or similar device. If at any time in the future we should wish to disclose information collected on this website to any third party, it would only be with your knowledge and consent. </span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">We may from time to time provide information of a general nature to third parties - for example, the number of individuals visiting our website or completing a registration form, but we will not use any information that could identify those individuals. </span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">In addition Dummy may work with third parties for the purpose of delivering targeted behavioural advertising to the Dummy website. Through the use of cookies, anonymous information about your use of our websites and other websites will be used to provide more relevant adverts about goods and services of interest to you. For more information on online behavioural advertising and about how to turn this feature off, please visit youronlinechoices.com/opt-out.</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Changes to this Policy</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Any changes to our Privacy Policy will be placed here and will supersede this version of our policy. We will take reasonable steps to draw your attention to any changes in our policy. However, to be on the safe side, we suggest that you read this document each time you use the website to ensure that it still meets with your approval.</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: bold; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">Contacting Us</span></p>\r\n<p dir=\"ltr\" style=\"line-height: 1.38; margin-top: 0pt; margin-bottom: 0pt;\"><span style=\"font-size: 11pt; font-family: Arial; color: #000000; background-color: transparent; font-weight: 400; font-style: normal; font-variant: normal; text-decoration: none; vertical-align: baseline; white-space: pre-wrap;\">If you have any questions about our Privacy Policy, or if you want to know what information we have collected about you, please email us at yourEmail@gmail.com. You can also correct any factual errors in that information or require us to remove your details form any list under our control.</span></p>\r\n<p><br /><br /><br /><br /><br /></p>', NULL, '1-4 business days', '16.74', '15', 0, '2020-10-01 02:30:11'),
(2, '7', '14', '26', '1', '02.webp', 'Biden 0124 Ultra Thin Casual Style Mesh Steel Men Watch', NULL, NULL, '1-3 business days', '9.15', '15', 0, '2020-11-01 02:30:11'),
(3, '7', '14', '26', '1', '03.webp', 'GADYSON A9105 Calendar Casual Style Men Wristwatch', NULL, NULL, '1-3 business days', '50', '15', 0, '2020-07-26 02:30:11'),
(4, '7', '14', '26', '1', '04.webp', 'YAZOLE 318 Luminous Display Casual Style Clock Men Watch', NULL, NULL, '1-3 business days', '35', '15', 0, '2020-07-26 02:30:11'),
(5, '7', '13', '19', '1', '05.webp', 'CRRJU 2150 Simple Dial Bright Needle Quartz Watch', NULL, NULL, '1-3 business days', '13.78', '15', 0, '2020-10-31 02:30:11'),
(6, '7', '13', '19', '1', '06.webp', 'SKMEI 9128 Chronograph Sport Sillicone Strap Men Watch', NULL, NULL, '1-3 business days', '22.58', '15', 0, '2020-07-26 02:30:11'),
(7, '7', '13', '22', '1', '07.webp', 'CURRENT 8023 Waterproof Fake Three Dials Analog Quartz Watch', NULL, NULL, '1-3 business days', '14.74', '15', 0, '2020-07-26 02:30:11'),
(8, '7', '13', '19', '1', '08.webp', 'Reward RD82004M Fashion Waterproof Men Quartz Watch', NULL, NULL, '1-3 business days', '24.53', '15', 0, '2020-07-26 02:30:11'),
(9, '7', '13', '19', '1', '09.webp', 'CRRJU 2271 Men Atmospheric Dial Quartz Watch', NULL, NULL, '1-3 business days', '24.24', '15', 0, '2020-07-26 02:30:11'),
(10, '7', '13', '21', '1', '10.webp', 'WWOOR 8831 Square Dial Luminous Display Men Wristwatch', NULL, NULL, '1-3 business days', '19.56', '15', 0, '2020-07-26 02:30:11'),
(11, '7', '13', '30', '1', '11.webp', 'NAVIFORCE 9153 Business Style LED Dual Digital Watch', NULL, NULL, '1-3 business days', '25.61', '15', 0, '2020-07-26 02:30:11'),
(12, '7', '13', '19', '1', '12.webp', 'YAZOLE 271 Men Watch', NULL, NULL, '1-3 business days', '7.34', '15', 0, '2020-07-26 02:30:11'),
(13, '7', '14', '25', '1', '13.webp', 'NAVIFORCE 3003 Working Little Dial Waterproof Quartz Watch', NULL, NULL, '1-3 business days', '24.24', '15', 0, '2020-07-26 02:30:11'),
(14, '7', '14', '26', '1', '14.webp', 'YAZOLE YD368 Sun and Moon 24 Hours Pointer\r\nCreative Watch', NULL, NULL, '1-3 business days', '25', '15', 0, '2020-07-26 02:30:11'),
(15, '7', '13', '22', '1', '15.webp', 'NAVIFORCE 9171 Full Steel Dual Display Watch', NULL, NULL, '1-3 business days', '25.36', '15', 0, '2020-07-26 02:30:11'),
(16, '7', '13', '20', '1', '16.webp', 'CURRENT 8250 Luxury Leather Watch Band Casual Men Watch', NULL, NULL, '1-3 business days', '25.36', '15', 0, '2020-07-26 02:30:11'),
(17, '7', '14', '26', '1', '17.webp', 'CURRENT 8259 Casual Watches Rubber Band Quartz Watch', NULL, NULL, '1-3 business days', '56', '15', 0, '2020-10-29 02:30:11');

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

--
-- Table structure for table `ProductAttribute`
--

CREATE TABLE `ProductAttribute` (
  `id` int(11) NOT NULL,
  `product_id` text,
  `name` text,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ProductAttribute`
--

INSERT INTO `ProductAttribute` (`id`, `product_id`, `name`, `enable`) VALUES
(1, '1', 'Colours', 0),
(2, '1', 'Sizes', 0);

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

--
-- Table structure for table `ProductPicture`
--

CREATE TABLE `ProductPicture` (
  `id` int(11) NOT NULL,
  `product_id` text,
  `image` text,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ProductPicture`
--

INSERT INTO `ProductPicture` (`id`, `product_id`, `image`, `enable`) VALUES
(1, '1', 'f0b31042-4f67-4e81-8230-877eca143385.jpg.webp', 0),
(2, '2', '02.webp', 0),
(3, '3', '03.webp', 0),
(4, '4', '04.webp', 0),
(5, '5', '05.webp', 0),
(6, '6', '06.webp', 0),
(7, '7', '07.webp', 0),
(8, '8', '08.webp', 0),
(9, '9', '09.webp', 0),
(10, '10', '10.webp', 0),
(11, '11', '11.webp', 0),
(12, '12', '12.webp', 0),
(13, '13', '13.webp', 0),
(14, '14', '14.webp', 0),
(15, '15', '15.webp', 0),
(16, '16', '16.webp', 0),
(17, '17', '17.webp', 0),
(18, '1', '3c7398db-3731-4c62-8f5d-eaeccafabee6.jpg.webp', 0),
(19, '1', 'f0b31042-4f67-4e81-8230-877eca143385.jpg.webp', 1),
(20, '1', '3b6459fa-dcff-48e1-b5d9-09e53e1e80ca.jpg.webp', 0),
(21, '1', '349fd133-d199-4921-841b-5fb44ac78a22.jpg.webp', 0);

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

--
-- Table structure for table `ProductQuestion`
--

CREATE TABLE `ProductQuestion` (
  `id` int(11) NOT NULL,
  `user_id` text,
  `product_id` text,
  `name` text,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ProductQuestion`
--

INSERT INTO `ProductQuestion` (`id`, `user_id`, `product_id`, `name`, `enable`) VALUES
(1, '1', '1', 'How much Battery last longer?', 0),
(2, '1', '1', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500s', 0),
(3, '1', '1', 'I want to ask some questions regarding product either it\'s gold plated and what\'s about it\'s quality', 0),
(4, '8', '1', 'How are you', 0),
(5, '8', '1', 'hi', 0);

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

--
-- Table structure for table `ProductShipping`
--

CREATE TABLE `ProductShipping` (
  `id` int(11) NOT NULL,
  `product_id` text,
  `shipping_id` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ProductShipping`
--

INSERT INTO `ProductShipping` (`id`, `product_id`, `shipping_id`) VALUES
(1, '1', '1'),
(2, '1', '3'),
(3, '2', '1'),
(4, '2', '3');

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

--
-- Table structure for table `QuestionAnswer`
--

CREATE TABLE `QuestionAnswer` (
  `id` int(11) NOT NULL,
  `question_id` text,
  `user_id` text,
  `answer` text,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `QuestionAnswer`
--

INSERT INTO `QuestionAnswer` (`id`, `question_id`, `user_id`, `answer`, `enable`) VALUES
(1, '1', '1', 'It would last about 10 hours', 0),
(2, '1', '1', 'It would last about 2-3 hrs', 0),
(4, '3', '1', 'Yup , it\'s of gold plated and high quality product', 0),
(5, '3', '1', 'it\'s of good quality', 0),
(6, '3', '1', 'good', 0),
(7, '5', '8', 'ok', 0),
(8, '4', '8', 'gfvb', 0);

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

--
-- Table structure for table `Rating`
--

CREATE TABLE `Rating` (
  `id` int(11) NOT NULL,
  `user_id` text,
  `order_id` text,
  `brand_id` text,
  `product_id` text,
  `rating` text,
  `review` text,
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Rating`
--

INSERT INTO `Rating` (`id`, `user_id`, `order_id`, `brand_id`, `product_id`, `rating`, `review`, `date_created`, `enable`) VALUES
(1, '1', NULL, NULL, '1', '4.5', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry. Lorem Ipsum has been the industry\'s standard dummy text ever since the 1500', '2020-07-14 00:01:40', 0),
(2, '1', '1', '1', '1', '3.6', 'There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form, by injected humour, or randomised words which don\'t look even slightly believable', '2020-07-14 00:01:40', 0);

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

--
-- Table structure for table `Refund`
--

CREATE TABLE `Refund` (
  `id` int(11) NOT NULL,
  `user_id` text,
  `brand_id` text,
  `term_id` text,
  `reason` text,
  `response` text,
  `status` varchar(150) NOT NULL DEFAULT '0' COMMENT '0 = neutral , 1 = accepted , 2 = declined',
  `enable` int(11) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Refund`
--

INSERT INTO `Refund` (`id`, `user_id`, `brand_id`, `term_id`, `reason`, `response`, `status`, `enable`, `date_created`) VALUES
(1, '1', '1', '2', 'Test 03', NULL, '0', 0, '2020-10-05 05:43:54'),
(2, '1', '1', '2', 'There is a problem in product , it didn\'t work perfectly', NULL, '0', 0, '2020-10-06 04:44:53'),
(3, '8', '1', '26', 'testing refund request', NULL, '0', 0, '2020-11-03 03:33:19');

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

--
-- Table structure for table `RefundMeta`
--

CREATE TABLE `RefundMeta` (
  `id` int(11) NOT NULL,
  `term_id` text,
  `image` text,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `RefundMeta`
--

INSERT INTO `RefundMeta` (`id`, `term_id`, `image`, `enable`) VALUES
(1, '1', '2_0_refund_5231543.webp', 0),
(2, '1', '2_1_refund_943357606.webp', 0),
(3, '2', '2_0_refund_598491666.webp', 0),
(4, '2', '2_1_refund_463235269.webp', 0),
(5, '2', '2_2_refund_1796979805.webp', 0),
(6, '3', '26_0_refund_1767724638.webp', 0);

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

--
-- Table structure for table `ReviewPicture`
--

CREATE TABLE `ReviewPicture` (
  `id` int(11) NOT NULL,
  `review_id` text,
  `image` text,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ReviewPicture`
--

INSERT INTO `ReviewPicture` (`id`, `review_id`, `image`, `enable`) VALUES
(1, '1', '04.webp', 0),
(2, '3', '2_0_rating_1874146070.webp', 0),
(3, '3', '2_1_rating_1336400629.webp', 0),
(4, '3', '2_2_rating_2046771923.webp', 0),
(5, '4', '26_0_rating_760594991.webp', 0);

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

--
-- Table structure for table `Sale`
--

CREATE TABLE `Sale` (
  `id` int(11) NOT NULL,
  `brand_id` text,
  `product_id` text,
  `sale_type` text,
  `discount` text,
  `start_date` datetime DEFAULT CURRENT_TIMESTAMP,
  `end_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `enable` int(11) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Sale`
--

INSERT INTO `Sale` (`id`, `brand_id`, `product_id`, `sale_type`, `discount`, `start_date`, `end_date`, `enable`, `date_created`) VALUES
(1, '1', '1', '1', '15', '2020-07-20 00:00:00', '2020-11-30 16:15:07', 0, '2020-07-27 00:35:56'),
(2, '1', '2', '1', '20', '2020-07-26 00:00:00', '2020-11-30 00:00:00', 0, '2020-07-27 01:00:27');

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

--
-- Table structure for table `SaleMeta`
--

CREATE TABLE `SaleMeta` (
  `id` int(11) NOT NULL,
  `name` text NOT NULL,
  `type` text NOT NULL,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `SaleMeta`
--

INSERT INTO `SaleMeta` (`id`, `name`, `type`, `enable`) VALUES
(1, '% Discount', 'per_discount', 0),
(2, 'Price Discount', 'price_discount', 0);

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

--
-- Table structure for table `Search`
--

CREATE TABLE `Search` (
  `id` int(11) NOT NULL,
  `name` text,
  `enable` int(11) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Search`
--

INSERT INTO `Search` (`id`, `name`, `enable`, `date_created`) VALUES
(1, 'latest watches', 0, '2020-08-14 05:00:17'),
(2, 'cheap Shoes', 0, '2020-08-14 05:00:17'),
(3, 'Trending Fragrances', 0, '2020-08-14 05:01:35'),
(4, 'Ardinuo ', 0, '2020-08-14 05:01:35');

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

--
-- Table structure for table `Shipping`
--

CREATE TABLE `Shipping` (
  `id` int(11) NOT NULL,
  `cart_id` text,
  `rate_id` text,
  `shipment_id` text,
  `carrier` text,
  `service` text,
  `rate` text,
  `delivery_days` text,
  `currency` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Shipping`
--

INSERT INTO `Shipping` (`id`, `cart_id`, `rate_id`, `shipment_id`, `carrier`, `service`, `rate`, `delivery_days`, `currency`) VALUES
(1, '31', 'rate_040ec32507f5473ebbe48b0cd047a2a2', 'shp_c887d6aa3e8f42d093afbcc2d4c7c3ed', 'USPS', 'PriorityMailInternational', '58.81', '', 'USD'),
(2, '31', 'rate_ce3317fa6c9e4d3288c150a9d67579ab', 'shp_c887d6aa3e8f42d093afbcc2d4c7c3ed', 'USPS', 'ExpressMailInternational', '74.44', '', 'USD'),
(3, '31', 'rate_8855bfdd19d44683ad3191ecdad83e3f', 'shp_c887d6aa3e8f42d093afbcc2d4c7c3ed', 'USPS', 'FirstClassPackageInternationalService', '38.48', '', 'USD');

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

--
-- Table structure for table `ShippingAddress`
--

CREATE TABLE `ShippingAddress` (
  `id` int(11) NOT NULL,
  `user_id` text,
  `address` text,
  `appartment` text,
  `city` text,
  `country_id` text,
  `postal_code` text,
  `phone` text,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `ShippingPackages`
--

CREATE TABLE `ShippingPackages` (
  `id` int(11) NOT NULL,
  `customized_shipping_id` text,
  `name` text,
  `delivery_days` text,
  `additional_price_per_kg` text,
  `enable` int(11) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ShippingPackages`
--

INSERT INTO `ShippingPackages` (`id`, `customized_shipping_id`, `name`, `delivery_days`, `additional_price_per_kg`, `enable`, `date_created`) VALUES
(1, '1', 'Overnight ', '1', NULL, 0, '2020-09-02 00:19:53'),
(2, '3', 'Economy', '2', NULL, 0, '2020-09-02 00:19:53');

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

--
-- Table structure for table `ShippingPackagesMeta`
--

CREATE TABLE `ShippingPackagesMeta` (
  `id` int(11) NOT NULL,
  `term_id` text,
  `from_weight` text,
  `to_weight` text,
  `rate` text,
  `date_created` datetime DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `ShippingPackagesMeta`
--

INSERT INTO `ShippingPackagesMeta` (`id`, `term_id`, `from_weight`, `to_weight`, `rate`, `date_created`) VALUES
(1, '1', '1', '500', '200', '2020-09-02 00:23:52'),
(2, '1', '501', '1024', '245', '2020-09-02 00:23:52'),
(3, '1', '1025', '-1', '200', '2020-09-02 00:42:23'),
(4, '2', '1', '500', '300', '2020-09-02 00:23:52'),
(5, '2', '501', '1024', '345', '2020-09-02 00:23:52'),
(6, '2', '1025', '-1', '500', '2020-09-02 00:42:23');

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

--
-- Table structure for table `SubCategories`
--

CREATE TABLE `SubCategories` (
  `id` int(11) NOT NULL,
  `category_id` text,
  `name` text,
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `SubCategories`
--

INSERT INTO `SubCategories` (`id`, `category_id`, `name`, `enable`) VALUES
(1, '1', 'Accessories', 0),
(2, '1', 'Tops', 0),
(3, '1', 'Bottoms', 0),
(4, '1', 'Outwear', 0),
(5, '2', 'Accessories', 0),
(6, '2', 'Dresses', 0),
(7, '3', 'Car Electronics', 0),
(8, '3', 'Car Audio & Monitors', 0),
(9, '5', 'Photography & Camera Accessories', 0),
(10, '5', 'Video Games Accesssories', 0),
(11, '6', 'Drives & Storage', 0),
(12, '6', 'Laptop & Accessories', 0),
(13, '7', 'Men Watches', 0),
(14, '7', 'Women Watches', 0),
(15, '7', 'Magnet & Healing Jewelry', 0),
(16, '7', 'Keychain & Ornament', 0),
(17, '7', 'Jewelry Supplies', 0),
(18, '8', 'Telephone', 0),
(19, '8', 'Mobile Phones', 0),
(20, '8', 'Phone Accessories', 0),
(21, '8', 'Mobile Phone PArts', 0),
(29, '7', 'Gym & Hiking Watch', 0),
(23, '9', 'Housekeeping', 0),
(24, '9', 'Gardening', 0),
(25, '9', 'Kitchen , Dining & Bar', 0),
(26, '9', 'Bathroom', 0),
(27, '10', 'Learning & Educator', 0),
(28, '10', 'Musical Instruments', 0);

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

--
-- Table structure for table `Tags`
--

CREATE TABLE `Tags` (
  `id` int(11) NOT NULL,
  `product_id` text,
  `name` text,
  `enable` int(11) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `Tags`
--

INSERT INTO `Tags` (`id`, `product_id`, `name`, `enable`, `date_created`) VALUES
(1, '1', 'latest watches', 0, '2020-08-15 06:33:50'),
(2, '1', 'modern watch', 0, '2020-08-15 06:33:50'),
(3, '1', 'golden watch', 0, '2020-08-15 06:33:50'),
(4, '1', 'steal like watch', 0, '2020-08-15 06:33:50');

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

--
-- Table structure for table `User`
--

CREATE TABLE `User` (
  `id` int(11) NOT NULL,
  `picture` varchar(1500) DEFAULT 'app_icon.webp',
  `first_name` text,
  `last_name` text,
  `email_address` text,
  `phone_number` text,
  `password` text,
  `note` text NOT NULL,
  `status` int(11) DEFAULT '0',
  `enable` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `User`
--

INSERT INTO `User` (`id`, `picture`, `first_name`, `last_name`, `email_address`, `phone_number`, `password`, `note`, `status`, `enable`) VALUES
(1, '1__profile_400600232.webp', 'Alexs', 'Smith', 'alex.smith@gmail.com', '+92 321 55566699', 'e6e537d46540581aafa8d505896dee78', 'There are many variations of passages of Lorem Ipsum available, but the majority have suffered alteration in some form', 0, 0),
(5, 'app_icon.webp', 'User', '02', 'testing123@gmail.com', '+92322 23569874', '25f9e794323b453885f5181f1b624d0b', '', 0, 0),
(6, 'app_icon.webp', 'Asif', 'khan', 'test01@gmail.com', '+923221233456789', '25f9e794323b453885f5181f1b624d0b', '', 0, 0),
(7, 'app_icon.webp', 'Khan', '02', 'test02@gmail.com', '+16505551234', '25f9e794323b453885f5181f1b624d0b', '', 0, 0),
(8, '8__profile_1810373898.webp', 'Haris', 'Farooq', 'test03@gmail.com', '+16505551235', '25f9e794323b453885f5181f1b624d0b', '', 0, 0),
(10, 'app_icon.webp', 'Abdullah', 'Jutt', 'Fouji.offical1@gmail.com', '+923226149355', 'ae2b1fca515949e5d54fb22b8ed95575', '', 0, 0);

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

--
-- Table structure for table `UserMeta`
--

CREATE TABLE `UserMeta` (
  `id` int(11) NOT NULL,
  `user_id` text,
  `address` text,
  `apartment` text,
  `city` text NOT NULL,
  `postal_code` text NOT NULL,
  `country` text NOT NULL,
  `phone` text NOT NULL,
  `note` text
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `UserMeta`
--

INSERT INTO `UserMeta` (`id`, `user_id`, `address`, `apartment`, `city`, `postal_code`, `country`, `phone`, `note`) VALUES
(1, '1', 'House no. 12345 o/p nothing but you can reach it', 'AWS no 1234', 'Faisalabad', '38600', 'Pakistan', '+92 360 1563789', NULL),
(10, '7', 'hshhs', 'ebheeh', 'jsueye', 'nhshs', 'Country', 'ndhsus', 'bshsys'),
(3, '6', 'Opposite xyz store near petrol pump XYN post office ABC road', 'House no. 1897', 'Faisalabad', '38600', 'Pk', '+92 360 1563789', NULL),
(8, '8', 'A -1020 o/p abc post office ', 'apartments 02', 'Lahore', '36000', 'Country', '+16505551235', 'Abc gate at the abc side of road after passing stairs'),
(11, '7', 'nshhs', 'nshshhs', 'hshhs', 'jdjj', 'Country', 'jjddj', 'ndushe'),
(12, '7', 'test address ', 'test aprt', 'Fsd', 'test postal', 'Country', '1234568890', 'jhshdhs'),
(13, '8', 'vgfdf', 'cvgff', 'vffdr', 'gddf', 'Country', 'ffjgf', 'vddtt');

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

--
-- Table structure for table `UserPaymentMethod`
--

CREATE TABLE `UserPaymentMethod` (
  `id` int(11) NOT NULL,
  `term_id` varchar(100) DEFAULT '0',
  `card_no` text,
  `card_company_name` text,
  `card_token` text,
  `enable` int(11) NOT NULL DEFAULT '0',
  `date_created` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `UserPaymentMethod`
--

INSERT INTO `UserPaymentMethod` (`id`, `term_id`, `card_no`, `card_company_name`, `card_token`, `enable`, `date_created`) VALUES
(1, '', '4242424242424242', NULL, 'tok_1HX3i5HjWgc1Hu3rhgmG6KQL', 0, '2020-09-30 04:43:29'),
(2, '', '4242424242424242', NULL, 'cus_I7IRO3oJOSFJ8J', 0, '2020-09-30 04:51:31'),
(3, '', '4242424242424242', NULL, 'cus_I7J2YaTJg1Rqyk', 0, '2020-09-30 05:28:25'),
(4, '', '4242424242424242', NULL, 'cus_I7fVg0eylPsK8s', 0, '2020-10-01 04:41:43'),
(5, '1', '4242424242424242', 'Visa Card', 'cus_I7hlAb9XE0yQuz', 0, '2020-10-01 07:01:26'),
(6, '1', '4242424242424242', 'Visa Card', 'cus_I7hs8nr0Q8P2ab', 0, '2020-10-01 07:08:59'),
(7, '1', '4242424242424242', 'Visa Card', 'cus_I7i4pJCpzGcyQN', 0, '2020-10-01 07:20:47'),
(8, '6', '4242424242424242', 'Visa Card', 'cus_IIAAasTQs7LlM8', 0, '2020-10-29 05:03:07'),
(9, '8', '4242424242424242', 'Visa Card', 'cus_IJZZeqKMck39Nr', 0, '2020-11-01 23:22:05'),
(10, '8', '4242424242424242', 'Visa Card', 'cus_IJZZPD871p8pRN', 0, '2020-11-01 23:22:06'),
(11, '10', '4242424242424242', 'Mastercard', 'cus_IOv8FKBbFMG0gD', 0, '2020-11-16 05:58:41'),
(12, '10', '4242424242424242', 'Mastercard', 'cus_IOv8FXwSeXR6fb', 0, '2020-11-16 05:58:42'),
(13, '10', '4242424242424242', 'Mastercard', 'cus_IOv8LQLU7wSQNu', 0, '2020-11-16 05:58:43'),
(14, '10', '4242424242424242', 'Mastercard', 'cus_IOv8bWZnh4jm8f', 0, '2020-11-16 05:58:44'),
(15, '10', '4242424242424242', 'Mastercard', 'cus_IOv8fcxyX1xLu8', 0, '2020-11-16 05:58:46'),
(16, '10', '4242424242424242', 'Mastercard', 'cus_IOv8RjK2QCLO0B', 0, '2020-11-16 05:58:47'),
(17, '10', '4242424242424242', 'Mastercard', 'cus_IOv8Ec4vAgzEg5', 0, '2020-11-16 05:58:49'),
(18, '10', '4242424242424242', 'Mastercard', 'cus_IOv8xJeEhGQ1Mi', 0, '2020-11-16 05:58:50'),
(19, '10', '4242424242424242', 'Mastercard', 'cus_IOv8wks7oW68Bw', 0, '2020-11-16 05:58:52'),
(20, '10', '4242424242424242', 'Mastercard', 'cus_IOv8nPhdwtl8j6', 0, '2020-11-16 05:58:53'),
(21, '10', '4242424242424242', 'Mastercard', 'cus_IOv8OIKy2RutEq', 0, '2020-11-16 05:58:55'),
(22, '10', '4242424242424242', 'Mastercard', 'cus_IOv8QrN4JlIgfJ', 0, '2020-11-16 05:58:56'),
(23, '10', '4242424242424242', 'Mastercard', 'cus_IOv8SEVIscOkFE', 0, '2020-11-16 05:58:58'),
(24, '10', '4242424242424242', 'Mastercard', 'cus_IOv85PdsMWOUu2', 0, '2020-11-16 05:59:00');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `AboutUs`
--
ALTER TABLE `AboutUs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `Admin`
--
ALTER TABLE `Admin`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `AttributeItem`
--
ALTER TABLE `AttributeItem`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `BankingDetail`
--
ALTER TABLE `BankingDetail`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `Brand`
--
ALTER TABLE `Brand`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `BrandCredentials`
--
ALTER TABLE `BrandCredentials`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `BrandMonthlyEarning`
--
ALTER TABLE `BrandMonthlyEarning`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `Cart`
--
ALTER TABLE `Cart`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=58;

--
-- AUTO_INCREMENT for table `CartMeta`
--
ALTER TABLE `CartMeta`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=71;

--
-- AUTO_INCREMENT for table `Categories`
--
ALTER TABLE `Categories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT for table `ChildSubCategories`
--
ALTER TABLE `ChildSubCategories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `Configuration`
--
ALTER TABLE `Configuration`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `ContactUs`
--
ALTER TABLE `ContactUs`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `Coupon`
--
ALTER TABLE `Coupon`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `CouponCategory`
--
ALTER TABLE `CouponCategory`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `CouponMeta`
--
ALTER TABLE `CouponMeta`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `CustomizedShipping`
--
ALTER TABLE `CustomizedShipping`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `Dispute`
--
ALTER TABLE `Dispute`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `Favourite`
--
ALTER TABLE `Favourite`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=20;

--
-- AUTO_INCREMENT for table `FeaturedBanner`
--
ALTER TABLE `FeaturedBanner`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `FeaturedBannerMeta`
--
ALTER TABLE `FeaturedBannerMeta`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `Following`
--
ALTER TABLE `Following`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;

--
-- AUTO_INCREMENT for table `HomeFeaturedCategories`
--
ALTER TABLE `HomeFeaturedCategories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `ListOfOrders`
--
ALTER TABLE `ListOfOrders`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;

--
-- AUTO_INCREMENT for table `OrderMeta`
--
ALTER TABLE `OrderMeta`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `PaymentMethod`
--
ALTER TABLE `PaymentMethod`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `PersonalDetail`
--
ALTER TABLE `PersonalDetail`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `PrivacyPolicy`
--
ALTER TABLE `PrivacyPolicy`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `Product`
--
ALTER TABLE `Product`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `ProductAttribute`
--
ALTER TABLE `ProductAttribute`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `ProductPicture`
--
ALTER TABLE `ProductPicture`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT for table `ProductQuestion`
--
ALTER TABLE `ProductQuestion`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `ProductShipping`
--
ALTER TABLE `ProductShipping`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `QuestionAnswer`
--
ALTER TABLE `QuestionAnswer`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT for table `Rating`
--
ALTER TABLE `Rating`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `Refund`
--
ALTER TABLE `Refund`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `RefundMeta`
--
ALTER TABLE `RefundMeta`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `ReviewPicture`
--
ALTER TABLE `ReviewPicture`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `Sale`
--
ALTER TABLE `Sale`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `SaleMeta`
--
ALTER TABLE `SaleMeta`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `Search`
--
ALTER TABLE `Search`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `Shipping`
--
ALTER TABLE `Shipping`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `ShippingPackages`
--
ALTER TABLE `ShippingPackages`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

--
-- AUTO_INCREMENT for table `ShippingPackagesMeta`
--
ALTER TABLE `ShippingPackagesMeta`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `SubCategories`
--
ALTER TABLE `SubCategories`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT for table `Tags`
--
ALTER TABLE `Tags`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `User`
--
ALTER TABLE `User`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `UserMeta`
--
ALTER TABLE `UserMeta`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `UserPaymentMethod`
--
ALTER TABLE `UserPaymentMethod`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;
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 */;
