-- phpMyAdmin SQL Dump
-- version 5.2.2
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 17, 2025 at 08:42 AM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

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


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `ecom_store`
--

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

--
-- Table structure for table `about_us`
--

CREATE TABLE `about_us` (
  `about_id` int(10) NOT NULL,
  `about_heading` text NOT NULL,
  `about_short_desc` text NOT NULL,
  `about_desc` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `about_us`
--

INSERT INTO `about_us` (`about_id`, `about_heading`, `about_short_desc`, `about_desc`) VALUES
(1, 'About Us - Our Story', '\r\nIt is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters,\r\n', 'Rhone was the collective vision of a small group of weekday warriors. For years, we were frustrated by the lack of activewear designed for men and wanted something better. With that in mind, we set out to design premium apparel that is made for motion and engineered to endure.\r\n\r\nAdvanced materials and state of the art technology are combined with heritage craftsmanship to create a new standard in activewear. Every product tells a story of premium performance, reminding its wearer to push themselves physically without having to sacrifice comfort and style.\r\n\r\nBeyond our product offering, Rhone is founded on principles of progress and integrity. Just as we aim to become better as a company, we invite men everywhere to raise the bar and join us as we move Forever Forward.');

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

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

CREATE TABLE `admins` (
  `admin_id` int(10) NOT NULL,
  `admin_name` varchar(255) NOT NULL,
  `admin_email` varchar(255) NOT NULL,
  `admin_pass` varchar(255) NOT NULL,
  `admin_image` text NOT NULL,
  `admin_contact` varchar(255) NOT NULL,
  `admin_country` text NOT NULL,
  `admin_job` varchar(255) NOT NULL,
  `admin_about` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `admins`
--

INSERT INTO `admins` (`admin_id`, `admin_name`, `admin_email`, `admin_pass`, `admin_image`, `admin_contact`, `admin_country`, `admin_job`, `admin_about`) VALUES
(2, 'Administrator', 'admin@mail.com', 'Password@123', 'user-profile-min.png', '7777775500', 'Morocco', 'Front-End Developer', ' Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical ');

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

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

CREATE TABLE `banners` (
  `id` int(11) NOT NULL,
  `title` varchar(255) NOT NULL,
  `image` varchar(255) NOT NULL,
  `link` varchar(255) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `bundle_product_relation`
--

CREATE TABLE `bundle_product_relation` (
  `rel_id` int(10) NOT NULL,
  `rel_title` varchar(255) NOT NULL,
  `product_id` int(10) NOT NULL,
  `bundle_id` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

--
-- Table structure for table `cart`
--

CREATE TABLE `cart` (
  `p_id` int(10) NOT NULL,
  `ip_add` varchar(255) NOT NULL,
  `qty` int(10) NOT NULL,
  `p_price` varchar(255) NOT NULL,
  `size` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `cart`
--

INSERT INTO `cart` (`p_id`, `ip_add`, `qty`, `p_price`, `size`) VALUES
(5, '20.171.207.133', 1, '800', 'Default'),
(8, '171.78.139.54', 1, '245', 'Default'),
(9, '20.171.207.80', 1, '50', 'Default'),
(12, '20.171.207.80', 1, '150', 'Default'),
(13, '49.37.9.51', 1, '90', 'Default'),
(14, '20.171.207.80', 1, '120', 'Default'),
(15, '20.171.207.80', 1, '88', 'Default'),
(16, '20.171.207.80', 1, '1299', 'Default'),
(17, '::1', 1, '899', 'Default'),
(18, '20.171.207.80', 1, '49', 'Default'),
(22, '152.58.163.255', 1, '10', 'Default'),
(25, '157.34.202.180', 1, '12', 'Default');

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

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

CREATE TABLE `categories` (
  `cat_id` int(10) NOT NULL,
  `cat_type` enum('Hardware','Software') NOT NULL,
  `cat_name` varchar(100) NOT NULL,
  `parent_cat_id` int(15) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `categories` (`cat_id`, `cat_type`, `cat_name`, `parent_cat_id`) VALUES
(1, 'Hardware', 'Hardware', 0),
(2, 'Software', 'Software', 0),
(23, 'Hardware', 'Processor\r\n', 1),
(24, 'Hardware', 'Motherboard\r\n', 1);

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

--
-- Table structure for table `contact_us`
--

CREATE TABLE `contact_us` (
  `contact_id` int(10) NOT NULL,
  `contact_email` text NOT NULL,
  `contact_heading` text NOT NULL,
  `contact_desc` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `contact_us`
--

INSERT INTO `contact_us` (`contact_id`, `contact_email`, `contact_heading`, `contact_desc`) VALUES
(1, 'ecomstore@mail.com', 'Contact  To Us', 'If you have any questions, please feel free to contact us, our customer service center is working for you 24/7.');

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

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

CREATE TABLE `coupons` (
  `coupon_id` int(10) NOT NULL,
  `product_id` int(10) NOT NULL,
  `coupon_title` varchar(255) NOT NULL,
  `coupon_price` varchar(255) NOT NULL,
  `coupon_code` varchar(255) NOT NULL,
  `coupon_limit` int(100) NOT NULL,
  `coupon_used` int(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `coupons`
--

INSERT INTO `coupons` (`coupon_id`, `product_id`, `coupon_title`, `coupon_price`, `coupon_code`, `coupon_limit`, `coupon_used`) VALUES
(5, 8, 'Sale', '10', 'CASTRO', 2, 1),
(6, 14, 'Sale', '65', 'CODEASTRO', 3, 1);

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

--
-- Table structure for table `customers`
--

CREATE TABLE `customers` (
  `customer_id` int(10) NOT NULL,
  `customer_name` varchar(255) NOT NULL,
  `customer_email` varchar(255) NOT NULL,
  `customer_pass` varchar(255) NOT NULL,
  `customer_country` text NOT NULL,
  `customer_city` text NOT NULL,
  `customer_contact` varchar(255) NOT NULL,
  `customer_address` text NOT NULL,
  `customer_image` text NOT NULL,
  `customer_ip` varchar(255) NOT NULL,
  `customer_confirm_code` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` (`customer_id`, `customer_name`, `customer_email`, `customer_pass`, `customer_country`, `customer_city`, `customer_contact`, `customer_address`, `customer_image`, `customer_ip`, `customer_confirm_code`) VALUES
(2, 'user', 'user@ave.com', '123', 'United State', 'New York', '0092334566931', 'new york', 'user.jpg', '::1', ''),
(3, 'Demo Customer', 'demo@customer.com', 'Password123', 'DemoCountry', 'DemoCity', '700000000', 'DemoAddress', 'sample_image.jpg', '::1', ''),
(4, 'Thomas', 'thomas@demo.com', 'Password123', 'One Country', 'One City', '777777777', '111 Address', 'sample_img360.png', '::1', '1427053935'),
(5, 'Fracis', 'test@customer.com', 'Password123', 'US', 'Demo City', '780000000', '112 Bleck Street', 'userav-min.png', '::1', '1634138674'),
(6, 'Sample Customer', 'customer@mail.com', 'Password123', 'Sample Country', 'Sample City', '7800000000', 'Sample Address', 'user-icn-min.png', '::1', '174829126'),
(7, 'Shivam Das', 'shivamdas123pl@gmail.com', 'shivam2006', 'India', 'Durgapur', '08348872742', 'Sepco', 'load.gif', '::1', '1911673528');

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

--
-- Table structure for table `customer_orders`
--

CREATE TABLE `customer_orders` (
  `order_id` int(10) NOT NULL,
  `customer_id` int(10) NOT NULL,
  `due_amount` int(100) NOT NULL,
  `invoice_no` int(100) NOT NULL,
  `qty` int(10) NOT NULL,
  `size` text NOT NULL,
  `order_date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `order_status` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `customer_orders`
--

INSERT INTO `customer_orders` (`order_id`, `customer_id`, `due_amount`, `invoice_no`, `qty`, `size`, `order_date`, `order_status`) VALUES
(17, 2, 100, 1715523401, 2, 'Large', '2017-02-20 08:21:42', 'pending'),
(23, 3, 20, 1762810884, 1, 'Medium', '2021-09-14 08:35:57', 'Complete'),
(24, 4, 100, 1972602052, 1, 'Large', '2021-09-14 16:37:52', 'Complete'),
(25, 4, 90, 2008540778, 1, 'Medium', '2021-09-14 16:43:15', 'pending'),
(27, 5, 120, 2138906686, 1, 'Small', '2021-09-15 03:18:41', 'Complete'),
(28, 5, 180, 361540113, 2, 'Medium', '2021-09-15 03:25:42', 'Complete'),
(29, 3, 100, 858195683, 1, 'Large', '2021-09-15 03:14:01', 'Complete'),
(31, 6, 245, 901707655, 1, 'Medium', '2021-09-15 03:52:18', 'Complete'),
(32, 6, 75, 2125554712, 1, 'Large', '2021-09-15 03:52:58', 'pending');

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

--
-- Table structure for table `enquiry_types`
--

CREATE TABLE `enquiry_types` (
  `enquiry_id` int(10) NOT NULL,
  `enquiry_title` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `enquiry_types`
--

INSERT INTO `enquiry_types` (`enquiry_id`, `enquiry_title`) VALUES
(1, 'Order and Delivery Support'),
(2, 'Technical Support'),
(3, 'Price Concern');

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

--
-- Table structure for table `manufacturers`
--

CREATE TABLE `manufacturers` (
  `manufacturer_id` int(10) NOT NULL,
  `manufacturer_title` text NOT NULL,
  `manufacturer_top` text NOT NULL,
  `manufacturer_image` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `manufacturers`
--

INSERT INTO `manufacturers` (`manufacturer_id`, `manufacturer_title`, `manufacturer_top`, `manufacturer_image`) VALUES
(2, 'HP', 'no', 'hp-5.svg'),
(4, 'MSI', 'no', 'micro-star-international-logo.svg'),
(5, 'ASUS', 'no', 'asus-4.svg'),
(7, 'DELL', 'no', 'dell-2.svg'),
(8, 'INTEL', 'no', 'intel-6.svg'),
(9, 'GIGABYTE ', 'no', 'gigabyte.svg'),
(10, 'AMD', 'no', 'amd-logo-1.svg'),
(11, 'LENOVO ', 'no', 'lenovo-2.svg'),
(12, 'SAMSUNG ', 'no', 'samsung-8.svg'),
(13, 'ACER', 'no', 'acer-2.svg'),
(16, 'COOLER MASTER ', 'no', 'cooler-master-black-logo.svg'),
(18, 'NZXT', 'no', 'nzxt-1.svg'),
(19, 'NVIDIA ', 'yes', 'nvidia.svg'),
(20, 'ZOTAC', 'no', ''),
(21, 'INNO3D', 'no', ''),
(22, 'ANT ESPORTS', 'no', ''),
(23, 'CORSAIR', 'no', 'corsair-2.svg'),
(24, 'LIAN LI', 'no', ''),
(25, 'APPLE ', 'no', 'apple-13.svg'),
(26, 'MICROSOFT', 'no', 'microsoft-6.svg');

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

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

CREATE TABLE `payments` (
  `payment_id` int(10) NOT NULL,
  `invoice_no` int(10) NOT NULL,
  `amount` int(10) NOT NULL,
  `payment_mode` text NOT NULL,
  `ref_no` int(10) NOT NULL,
  `code` int(10) NOT NULL,
  `payment_date` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `payments`
--

INSERT INTO `payments` (`payment_id`, `invoice_no`, `amount`, `payment_mode`, `ref_no`, `code`, `payment_date`) VALUES
(2, 1607603019, 447, 'UBL/Omni', 5678, 33, '11/1/2016'),
(3, 314788500, 345, 'UBL/Omni', 443, 865, '11/1/2016'),
(4, 6906, 400, 'Western Union', 101025780, 696950, 'January 1'),
(5, 10023, 20, 'Bank Code', 1000010101, 6969, '09/14/2021'),
(6, 69088, 100, 'Bank Code', 1010101022, 88669, '09/14/2021'),
(7, 1835758347, 480, 'Western Union', 1785002101, 66990, '09-04-2021'),
(8, 1835758347, 480, 'Bank Code', 1012125550, 66500, '09-14-2021'),
(9, 1144520, 480, 'Bank Code', 1025000020, 66990, '09-14-2021'),
(10, 2145000000, 480, 'Bank Code', 2147483647, 66580, '09-14-2021'),
(20, 858195683, 100, 'Bank Code', 1400256000, 47850, '09-13-2021'),
(21, 2138906686, 120, 'Bank Code', 1455000020, 202020, '09-13-2021'),
(22, 2138906686, 120, 'Bank Code', 1450000020, 202020, '09-15-2021'),
(23, 361540113, 180, 'Western Union', 1470000020, 12001, '09-15-2021'),
(24, 361540113, 180, 'UBL/Omni', 1258886650, 200, '09-15-2021'),
(25, 901707655, 245, 'Western Union', 1200002588, 88850, '09-15-2021');

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

--
-- Table structure for table `pending_orders`
--

CREATE TABLE `pending_orders` (
  `order_id` int(10) NOT NULL,
  `customer_id` int(10) NOT NULL,
  `invoice_no` int(10) NOT NULL,
  `product_id` text NOT NULL,
  `qty` int(10) NOT NULL,
  `size` text NOT NULL,
  `order_status` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `pending_orders`
--

INSERT INTO `pending_orders` (`order_id`, `customer_id`, `invoice_no`, `product_id`, `qty`, `size`, `order_status`) VALUES
(17, 2, 1715523401, '9', 2, 'Large', 'pending'),
(23, 3, 1762810884, '12', 1, 'Medium', 'Complete'),
(24, 4, 1972602052, '5', 1, 'Large', 'Complete'),
(25, 4, 2008540778, '13', 1, 'Medium', 'pending'),
(27, 5, 2138906686, '14', 1, 'Small', 'Complete'),
(28, 5, 361540113, '13', 2, 'Medium', 'Complete'),
(29, 3, 858195683, '5', 1, 'Large', 'Complete'),
(31, 6, 901707655, '8', 1, 'Medium', 'Complete'),
(32, 6, 2125554712, '15', 1, 'Large', 'pending');

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

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

CREATE TABLE `products` (
  `product_id` int(10) NOT NULL,
  `p_cat_id` int(10) NOT NULL,
  `cat_id` int(10) NOT NULL,
  `manufacturer_id` int(10) NOT NULL,
  `date` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `product_title` text NOT NULL,
  `product_url` text NOT NULL,
  `product_img1` text NOT NULL,
  `product_img2` text NOT NULL,
  `product_img3` text NOT NULL,
  `product_price` int(10) NOT NULL,
  `product_psp_price` int(100) NOT NULL,
  `product_desc` text NOT NULL,
  `product_features` text NOT NULL,
  `product_video` text NOT NULL,
  `product_keywords` text NOT NULL,
  `product_label` text NOT NULL,
  `status` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

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

INSERT INTO `products` (`product_id`, `p_cat_id`, `cat_id`, `manufacturer_id`, `date`, `product_title`, `product_url`, `product_img1`, `product_img2`, `product_img3`, `product_price`, `product_psp_price`, `product_desc`, `product_features`, `product_video`, `product_keywords`, `product_label`, `status`) VALUES
(5, 13, 19, 4, '2025-09-24 03:32:32', 'MSI Katana A15 AI B8VE-481IN Gaming Laptop (Ryzen 7 8845HS/RTX 4050 6GB GDDR6)', 'MSI-Katana -A15-AI-B8VE-481IN', '9s7-158n31-481-image.jpeg', '9s7-158n31-481-image-2.jpeg', '9s7-158n31-481-image-1.jpeg', 800, 500, 'Katana A15 AI B8VE-481IN\r\n\r\n Up to AMD Ryzen 7 8845HS Processor\r\nWindows 11 Home \r\nUp to latest GeForce RTX 4050 Laptop GPU 6GB GDDR6\r\nPowered by NVIDIA DLSS 3, ultra-efficient Ada Lovelace arch, and Max-Q Technologies.\r\n15.6\" Full HD (1920x1080), 144 Hz Refresh Rate, IPS-Level panel\r\nDiscrete Graphics mode(MUX design) squeezes the performance to the extreme level.\r\nExclusive Cooler Boost 5 Technology\r\nMSI AI Engine for AI-Powered computing experience\r\nMSI App Player for seamless gaming experience between mobile and PC\r\nHigh-Resolution Audio ready\r\nWi-Fi 6E for enhanced streaming experience\r\n\r\n\r\n\r\n\r\n', '\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nIt is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters,\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n', '\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<iframe width=\"854\" height=\"480\" src=\"https://www.youtube.com/embed/qRswlmADRa8\" frameborder=\"0\" allowfullscreen></iframe>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n', 'MSI LAPTOP, AMD PROCESSOR, RTX 4050, 6GB GPU, AI POWERED LAPTOP', 'Featured', 'product'),
(8, 13, 19, 11, '2025-09-24 03:22:32', 'Lenovo LOQ 83GS0097IN Gaming laptop (i5-12th Gen-12450HX/RTX 2050 4GB GDDR6)', 'Lenovo-LOQ-LOQ 83GS0097IN', '83gs0097in-image-01.jpg', '83gs0097in-image-main.jpg', '83gs0097in-image-04.jpg', 750, 400, '\r\n\r\n\r\nProcessor\r\n12th Generation IntelÂ® Coreâ„¢ i5-12450HX Processor (E-cores up to 3.10 GHz P-cores up to 4.40 GHz)\r\nOperating System\r\nWindows 11 Home Single Language 64\r\nGraphics Card\r\nNVIDIAÂ® GeForce RTXâ„¢ 2050 Laptop GPU 4GB GDDR6\r\nMemory\r\n12 GB DDR5-4800MHz (SODIMM)\r\nStorage\r\n512 GB SSD M.2 2242 PCIe Gen4 QLC\r\nDisplay\r\n39.62cms (15.6) FHD (1920 x 1080), IPS, Anti-Glare, Non-Touch, 100%sRGB, 300 nits, 144Hz\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n', '\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n', '\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n<iframe width=\"854\" height=\"480\" src=\"https://www.youtube.com/embed/qRswlmADRa8\" frameborder=\"0\" allowfullscreen></iframe>\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n', 'LENOVO LAPTOP,RTX 2050, INTEL PROCESSOR, WINDOWS 11', 'Best price', 'product'),
(9, 13, 19, 9, '2025-09-24 03:57:01', 'Gigabyte AORUS 16X 9KG-43INC54SH Gaming Laptop (i7-13650HX/RTX 4060)', 'Gigabyte-AORUS-16X -9KG-43INC54SH ', 'aorus-16x-9kg-43inc54sh-image.jpeg', 'aorus-16x-9kg-43inc54sh-image-1.jpeg', 'aorus-16x-9kg-43inc54sh-image-3.jpeg', 990, 480, '\r\nCPU: Intel Core i7-13650HX Processor\r\nGraphics: NVIDIA GeForce RTX 4060 Laptop GPU 8GB GDDR\r\nMemory: DDR5 4800 8GB*2\r\nStorage: Gen4 1TB\r\nNVIDIA Advanced Optimus: Dynamic Display Switch Technology\r\n\r\nThe new Dynamic Display Switch (DDS) technology allows the laptop to intelligently switch between graphics card output modes depending on the usage scenario, rapidly achieving additional performance without additional settings. Advanced Optimus delivers long battery life plus the tear free gameplay of G-SYNC.\r\n\r\nThe AORUS 16X is powered by the most advanced silicon in computing and graphics. Not only is it born to elevate your gaming and creating experience, but also ready to carry out your AI tasks.\r\n\r\n\r\n\r\n', '\r\n\r\n\r\n\r\n\r\n\r\n', '\r\n\r\n\r\n\r\n\r\n\r\n\r\n<iframe width=\"854\" height=\"480\" src=\"https://www.youtube.com/embed/qRswlmADRa8\" frameborder=\"0\" allowfullscreen></iframe>\r\n\r\n\r\n\r\n\r\n\r\n\r\n', 'I7 PROCESSOR, RTX 4060, 1TB GEN-4 M.2, DDR 5 RAM, NVIDIA GRAPHICS CARD', 'Sale', 'product'),
(13, 13, 19, 2, '2025-09-24 07:39:52', 'HP 15-FC0155AU Laptop (AMD Ryzen 5-7520U/AMD Radeon Graphics)', 'HP-15-FC0155AU-Laptop', '9d3m9pa-image.jpeg', '9d3m9pa-image-1.jpeg', '9d3m9pa-image-2.jpeg', 480, 350, '\r\n\r\n\r\n\r\nAMD Ryzen 5 Processor\r\n\r\nTap into truly impressive notebook performance. A revolutionary new architecture with amazing battery life that delivers exceptional multi-threaded processing and Vega graphics for intensive multimedia tasks.\r\n\r\nAMD Radeon graphics\r\n\r\nWhether itâ€™s games or movies, experience high performance for all your entertainment.\r\n\r\nFull HD display\r\n\r\nSit back and enjoy crystal-clear visuals and images with the vibrant quality of 2 million pixels. The 1920 x 1080 resolution gives all your digital content a new dimension.\r\n\r\nUSB Type-C 5Gbps signaling data rate\r\n\r\nPlug in your external storage with this USB Type-CÂ® port, featuring 5Gbps signaling data rate. And itâ€™s reversible, so you never have to worry about plugging in upside down.\r\n\r\nDual front-facing speakers\r\n\r\nPump up the volume to your favorite music, movie or game. When your audio is directed towards you, nothing comes between you and your entertainment.\r\n\r\nGet a fresh perspective\r\n\r\nFrom a rejuvenated Start menu, to new ways to connect to your favorite people, news, games, and contentâ€”Windows 11 is the place to think, express, and create in a natural way.\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n', '\r\n\r\n\r\n\r\nHP Laptop 39.6 cm (15.6) 15-fc0155AU, Silver\r\n\r\nAMD Ryzen 5-7520U processor\r\nWindows 11 Home\r\n39.6 cm (15.6) diagonal, FHD display with AMD Radeon Graphics\r\n8 GB LPDDR5-5500 RAM\r\n512 GB SSD Hard Drive\r\nBacklit keyboard with numeric keypad, True Vision 1080p FHD camera\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n', '\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\nThis is a sample text. This is a sample text. This is a sample text.\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n', 'HP,AMD, WINDOWS 11, DDR5 RAM, 512 GB SSD', 'New', 'product'),
(14, 13, 19, 5, '2025-09-24 03:33:33', 'ASUS TUF Gaming A15 FA506NFR-HN045W Laptop (Ryzen 7 7435HS/RTX 2050 4GB GDDR6)', 'ASUS-TUF-Gaming-A15 ', 'fa506nfr-hn045w-image.jpeg', 'fa506nfr-hn045w-image-1.jpeg', 'fa506nfr-hn045w-image-2.jpeg', 750, 520, '\r\n\r\n\r\n\r\n\r\nASUS TUF Gaming A15, Gaming Laptop, AMD Ryzen 7 7435HS, RTX 2050 GPU (16GB/512GB/39.62 cms (15.6) FHD/Windows 11 Home) FA506NFR-HN045W\r\n\r\nExplore the ASUS TUF Gaming A15 laptops. Experience their robust performance, durable construction, and excellent gaming features. Ideal for gamers and professionals looking for reliable, high-quality, and economical devices. Discover the ASUS TUF Gaming A15 and benefit from top-tier features at an attractive price.\r\n\r\n\r\n\r\n\r\n\r\n\r\n', '\r\n\r\n\r\n\r\n\r\nProcessorï¼š AMD Ryzenâ„¢ 7 7435HS Mobile Processor 3.1GHz (20MB Cache, up to 4.5 GHz, 8 cores, 16 Threads)\r\nGraphicsï¼š 4GB GDDR6 NVIDIAÂ® GeForce RTXâ„¢ 2050 Laptop GPU || Up to 1670MHz at 60W (70W with Dynamic Boost)\r\nDisplayï¼š 39.62 cms (15.6) FHD (1920 x 1080) Anti-glare display having 16:09 Aspect Ratio || 144Hz Refresh Rate || 250nits Brightness\r\nMemoryï¼š 16GB DDR5 RAM (8GB DDR5-5600 SO-DIMM *2) expandable upto 32GB using 2x SO-DIMM slots\r\nStorageï¼š 512GB PCIeÂ® 4.0 NVMeâ„¢ M.2 SSD\r\nMS Officeï¼š 1-month trial for new Microsoft 365 customers. Credit card required.\r\nColorï¼š Graphite Black\r\nOperating Systemï¼šWindows 11 Home\r\n\r\n\r\n\r\n\r\n', '\r\n\r\n\r\n\r\n\r\n\r\n\r\nThis is a demo.\r\n\r\n\r\n\r\n\r\n', 'ASUS, AMD RYZEN, NVIDIA GPU, RTX 2050, 512 GB M. 2', 'New', 'product'),
(15, 5, 5, 8, '2025-09-21 05:32:51', 'Asus Rog', 'cotton-polo-shirt', 'ultra-laptop.jpg', 'g18bulk2.jpg', 'g18bulk3.jpg', 88, 75, '\r\nTHIS IS A DEMO DESCRIPTION\r\n', '\r\n\r\nDEMO FEATURES\r\n\r\n', '\r\n\r\n\r\n\r\n', 'polo shirt', 'Sale', 'bundle'),
(19, 13, 19, 12, '2025-09-24 07:30:29', 'Samsung Galaxy Book4 NP750XGK-LG8IN Laptop (Intel Core 7-150U/Gray)', 'Samsung-Galaxy -Book4-NP750XGK', 'np750xgk-lg8in-image.jpeg', 'np750xgk-lg8in-image-1.jpeg', 'np750xgk-lg8in-image-2.jpeg', 600, 520, '\r\n\r\n\r\n\r\n\r\n\r\n', '\r\n\r\n\r\n\r\n\r\n\r\n', '\r\n\r\n\r\n\r\n\r\n\r\n', 'Sumsung ,I7100U', 'New', 'product'),
(20, 13, 19, 13, '2025-09-24 07:30:00', 'Acer Nitro V ANV15-41 Laptop (AMD Ryzen 5-6600H/RTX 3050)', 'Acer-Nitro-V -ANV15-41-Laptop', 'nh-qpfsi-006-image.jpeg', 'nh-qpfsi-006-image-2.jpeg', 'nh-qpfsi-006-image-3.jpeg', 550, 380, '\r\nAcer Nitro V Gaming Laptop AMD Ryzen 5-6600H Processor (Windows 11 Home/ 16 GB/ 512 GB SSD/ NVIDIA GeForce RTX 3050/ 165Hz) ANV15-41 with FHD 39.62 cm (15.6\") IPS Display, Obsidian Black, 2.1 KG\r\n\r\nOperating System: Windows 11 Home\r\nProcessor: AMD Ryzen 5-6600H Processor\r\nDisplay: 39.6 cm (15.6\") display with IPS (In-Plane Switching) technology, Full HD 1920 x 1080, Acer ComfyView LED-backlit TFT LCD, supporting 165 Hz\r\nGraphics: NVIDIA GeForce RTX 3050 with 6 GB of dedicated GDDR6 VRAM\r\nMemory: Dual-channel DDR5 SDRAM support: 16 (1*16) GB of DDR5 system memory Upgradable up to 32GB of DDR5 system memory (Memory Frequency: up to 4800 MT/s)\r\nStorage: 512 GB, PCIe Gen4, 16 Gb/s, NVMe\r\nBattery Information:Number of Cells-4,Battery Chemistry-Lithium Ion (Li-Ion) ,Battery Capacity-57 Wh\r\n\r\n\r\n', '\r\n\r\n\r\n\r\n', '\r\n\r\n\r\n\r\n', 'ACER,AMD 56600H,RTX3050, WINDOWS 11 ', 'Sale', 'product'),
(21, 13, 19, 7, '2025-09-24 07:37:13', 'Dell Inspiron 3530 Laptop (i3-1305U/Intel UHD Graphics)', 'Dell-Inspiron-3530-Laptop', 'oin353010051rinb1mo-image.jpeg', 'oin353010051rinb1mo-image-1.jpeg', 'oin353010051rinb1mo-image-2.jpeg', 420, 300, '\r\nInspiron 3530 Laptop\r\n\r\nProcessor: 13th Generation IntelÂ® Core i3-1305U (10 MB cache, 5 cores, 6 threads, up to 4.50 GHz)\r\nOperating System: Windows 11 Home, Single Language English\r\nVideo Card: IntelÂ® UHD Graphics\r\nMemory:8GB, 8Gx1, DDR4, 2666MHz\r\nStorage:512GB M.2 PCIe NVMe Solid State Drive\r\nDisplay :15.6\", FHD 1920x1080\r\nColor : Black\r\nKeyboard : English International Non-Backlit Keyboard\r\n\r\n\r\n', '\r\n\r\n\r\n\r\n', '\r\n\r\n\r\n\r\n', 'DELL,i3-1305U, WINDOWS 11,DDR 4 RAM,512 GB M.2', 'New', 'product'),
(22, 26, 2, 26, '2025-09-26 09:22:50', 'Windows 10 Pro(32bit/64bit) Lifetime Validity AUTOMATIC KEY.', 'Windows-10-Pro-(32bit/64bit)', '1653646217.WhatsApp Image 2022-05-27 at 3.35.18 PM.jpeg', '1653646217.WhatsApp Image 2022-05-27 at 3.35.18 PM.jpeg', '1653646217.WhatsApp Image 2022-05-27 at 3.35.18 PM.jpeg', 10, 5, '\r\n\r\n\r\n\r\n', '\r\n\r\n\r\n\r\n', '\r\n\r\n\r\n\r\n', 'WINDOWS10, LIFETIME ACTIVATION KI,', 'Sale', 'product'),
(23, 26, 2, 26, '2025-09-26 09:22:50', 'Windows 11 Pro Lifetime Validity key', 'Windows-11-Pro', '1635678435.win11pro.jpg', '1635678435.win11pro.jpg', '1635678435.win11pro.jpg', 12, 6, 'You can also activate windows 10 with this key and then upgrade to windows 11\r\nLifetime validity of this key provided Motherboard remains the same.\r\n\r\n', '\r\n\r\n', '\r\n\r\n', 'WINDOWS 11, LIFETIME ACTIVATION KEY', 'Sale', 'product'),
(24, 26, 2, 26, '2025-09-26 09:25:03', 'Windows 10 Home 32/64 Bit Lifetime Key', 'Windows-10-Home', '1639134580.windows10 home.png', '1639134580.windows10 home.png', '1639134580.windows10 home.png', 10, 5, '1. Lifetime validity of this key provided Motherboard remains the same.\r\n2. Free upgrade to Windows 11\r\n3. Only Retail licence. \r\n4. Click here to Download\r\n\r\n', '\r\n', '\r\n', 'WINDOWS 10 HOME', 'Sale', 'product'),
(25, 26, 2, 26, '2025-09-26 09:24:52', 'Windows 11 Home 32/64 Bit Lifetime Key', 'Windows-11-Home', '1676694712.win11.jpg', '1676694712.win11.jpg', '1676694712.win11.jpg', 12, 5, '\r\n', '\r\n', '\r\n', 'WINDOWS 11 HOME', 'Featured', 'product'),
(26, 26, 2, 26, '2025-09-26 10:01:10', 'Windows 10 Enterprise Lifetime validity key', 'Windows-10-Enterprise', '1639133946.windows10 enterprise.png', '1639133946.windows10 enterprise.png', '1639133946.windows10 enterprise.png', 15, 8, '\r\n', '\r\n', '\r\n', 'Windows-10-Enterprise', 'bestsellers', 'product'),
(27, 26, 2, 26, '2025-09-26 11:33:15', 'Office Professional Plus 2021 Online Activation ( Lifetime)', 'Office-Professional-Plus-2021', '1635675987.Office-2021-Professional-Plus-5.jpg', '1635675987.Office-2021-Professional-Plus-5.jpg', '1635675987.Office-2021-Professional-Plus-5.jpg', 20, 10, '', '', '', 'MICROSOFT OFFICE', 'Sale', 'product'),
(28, 27, 2, 26, '2025-09-26 11:53:00', 'Office Professional Plus 2019 Online Activation (Lifetime)', 'Office-Professional-Plus-2019', '1710732781.office 2019.jpeg', '1710732781.office 2019.jpeg', '', 15, 10, '1) Uninstall any existing ms office package and then restart your system.\r\n2) Then copy/paste following link in browser to  download the setup file \r\nhttps://officecdn.microsoft.com/db/492350F6-3A01-4F97-B9C0-C7C6DDF67D60/media/en-US/ProPlus2019Retail.img\r\n3) Install downloaded office software.\r\n4) Open any app like Word or Excel.\r\n5) Enter the product key and activate.\r\n\r\nIt is done', '', '', 'Microsoft office 2019', 'Sale', 'product'),
(29, 28, 2, 26, '2025-09-27 10:25:45', 'Windows Server 2025 Standard Lifetime Key', 'Windows-Server-2025-Standard', '1733294090.Windows Server 2025.jpeg', '1733294090.Windows Server 2025.jpeg', '', 30, 25, '', '', '', 'WINDOWS SERVER', 'New', 'product'),
(30, 28, 2, 26, '2025-09-27 10:25:55', 'Windows Server 2025 Data Center Lifetime', 'Windows-Server-2025-Data-Center', '1758173545.WhatsApp Image 2025-09-18 at 11.01.36 AM.jpeg', '', '', 40, 35, '', '', '', 'SERVER ', 'New', 'product');

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

--
-- Table structure for table `product_categories`
--

CREATE TABLE `product_categories` (
  `p_cat_id` int(10) NOT NULL,
  `cat_id` int(11) DEFAULT NULL,
  `p_cat_title` text NOT NULL,
  `p_cat_top` text NOT NULL,
  `p_cat_image` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `product_categories`
--

INSERT INTO `product_categories` (`p_cat_id`, `cat_id`, `p_cat_title`, `p_cat_top`, `p_cat_image`) VALUES
(13, 1, 'LAPTOP ', 'yes', 'images.jpeg'),
(14, 1, 'PROCESSOR', 'no', 'icons8-processor-50.png'),
(15, 1, 'MOTHERBOARD', 'no', 'icons8-motherboard-96.png'),
(16, 1, 'RAM', 'no', 'icons8-ram-96.png'),
(17, 1, 'STORAGE', 'no', 'icons8-hdd-64.png'),
(18, 1, 'GRAPHICS CARD', 'no', 'icons8-graphic-card-66.png'),
(19, 1, 'CPU COOLER', 'no', 'icons8-cooling-64.png'),
(20, 1, 'POWER SUPPLY', 'no', 'icons8-power-supply-66.png'),
(21, 1, 'CABINET', 'no', 'icons8-computer-case-64.png'),
(22, 1, 'KEYBOARD', 'no', ''),
(23, 1, 'MOUSE', '', ''),
(24, 1, 'HEADSET', '', ''),
(25, 1, 'MONITOR', '', ''),
(26, 2, 'WINDOWS', 'no', ''),
(27, 2, 'MICROSOFT OFFICE', 'no', ''),
(28, 2, 'WINDOWS SERVER', 'no', '');

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

--
-- Table structure for table `store`
--

CREATE TABLE `store` (
  `store_id` int(10) NOT NULL,
  `store_title` varchar(255) NOT NULL,
  `store_image` varchar(255) NOT NULL,
  `store_desc` text NOT NULL,
  `store_button` varchar(255) NOT NULL,
  `store_url` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `store`
--

INSERT INTO `store` (`store_id`, `store_title`, `store_image`, `store_desc`, `store_button`, `store_url`) VALUES
(4, 'London Store', 'store (3).jpg', '<p style=\"text-align: center;\"><strong>180-182 RECENTS STREET, LONDON, W1B 5BT</strong></p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut libero erat, aliquet eget mauris ut, dictum sagittis libero. Nam at dui dapibus, semper dolor ac, malesuada mi. Duis quis lobortis arcu. Vivamus sed sodales orci, non varius dolor.</p>', 'View Map', 'http://www.thedailylux.com/ecommerce'),
(5, 'New York Store', 'store (1).png', '<p style=\"text-align: center;\"><strong>109 COLUMBUS CIRCLE, NEW YORK, NY10023</strong></p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut libero erat, aliquet eget mauris ut, dictum sagittis libero. Nam at dui dapibus, semper dolor ac, malesuada mi. Duis quis lobortis arcu. Vivamus sed sodales orci, non varius dolor.</p>', 'View Map', 'http://www.thedailylux.com/ecommerce'),
(6, 'Paris Store', 'store (2).jpg', '<p style=\"text-align: center;\"><strong>2133 RUE SAINT-HONORE, 75001 PARIS&nbsp;</strong></p>\r\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Ut libero erat, aliquet eget mauris ut, dictum sagittis libero. Nam at dui dapibus, semper dolor ac, malesuada mi. Duis quis lobortis arcu. Vivamus sed sodales orci, non varius dolor.</p>', 'View Map', 'http://www.thedailylux.com/ecommerce');

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

--
-- Table structure for table `terms`
--

CREATE TABLE `terms` (
  `term_id` int(10) NOT NULL,
  `term_title` varchar(100) NOT NULL,
  `term_link` varchar(100) NOT NULL,
  `term_desc` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `terms`
--

INSERT INTO `terms` (`term_id`, `term_title`, `term_link`, `term_desc`) VALUES
(1, 'Rules And Regulations', 'rules', '<p>Contrary to popular belief, Lorem Ipsum is not simply random text. It has roots in a piece of classical Latin literature from 45 BC, making it over 2000 years old. Richard McClintock, a Latin professor at Hampden-Sydney College in Virginia, looked up one of the more obscure Latin words, consectetur, from a Lorem Ipsum passage, and going through the cites of the word in classical literature, discovered the undoubtable source. Lorem Ipsum comes from sections 1.10.32 and 1.10.33 of \"de Finibus Bonorum et Malorum\" (The Extremes of Good and Evil) by Cicero, written in 45 BC. This book is a treatise on the theory of ethics, very popular during the Renaissance.&nbsp;</p>'),
(2, 'Refund Policy', 'link2', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).Why do we use it?It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on'),
(3, 'Pricing and Promotions Policy', 'link3', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).Why do we use it?It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on');

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

--
-- Table structure for table `wishlist`
--

CREATE TABLE `wishlist` (
  `wishlist_id` int(10) NOT NULL,
  `customer_id` int(10) NOT NULL,
  `product_id` int(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

--
-- Dumping data for table `wishlist`
--

INSERT INTO `wishlist` (`wishlist_id`, `customer_id`, `product_id`) VALUES
(2, 2, 8),
(3, 5, 13),
(4, 3, 13),
(5, 6, 15);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `about_us`
--
ALTER TABLE `about_us`
  ADD PRIMARY KEY (`about_id`);

--
-- Indexes for table `admins`
--
ALTER TABLE `admins`
  ADD PRIMARY KEY (`admin_id`);

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

--
-- Indexes for table `bundle_product_relation`
--
ALTER TABLE `bundle_product_relation`
  ADD PRIMARY KEY (`rel_id`);

--
-- Indexes for table `cart`
--
ALTER TABLE `cart`
  ADD PRIMARY KEY (`p_id`);

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

--
-- Indexes for table `contact_us`
--
ALTER TABLE `contact_us`
  ADD PRIMARY KEY (`contact_id`);

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

--
-- Indexes for table `customers`
--
ALTER TABLE `customers`
  ADD PRIMARY KEY (`customer_id`);

--
-- Indexes for table `customer_orders`
--
ALTER TABLE `customer_orders`
  ADD PRIMARY KEY (`order_id`);

--
-- Indexes for table `enquiry_types`
--
ALTER TABLE `enquiry_types`
  ADD PRIMARY KEY (`enquiry_id`);

--
-- Indexes for table `manufacturers`
--
ALTER TABLE `manufacturers`
  ADD PRIMARY KEY (`manufacturer_id`);

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

--
-- Indexes for table `pending_orders`
--
ALTER TABLE `pending_orders`
  ADD PRIMARY KEY (`order_id`);

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

--
-- Indexes for table `product_categories`
--
ALTER TABLE `product_categories`
  ADD PRIMARY KEY (`p_cat_id`);

--
-- Indexes for table `store`
--
ALTER TABLE `store`
  ADD PRIMARY KEY (`store_id`);

--
-- Indexes for table `terms`
--
ALTER TABLE `terms`
  ADD PRIMARY KEY (`term_id`);

--
-- Indexes for table `wishlist`
--
ALTER TABLE `wishlist`
  ADD PRIMARY KEY (`wishlist_id`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `about_us`
--
ALTER TABLE `about_us`
  MODIFY `about_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `admins`
--
ALTER TABLE `admins`
  MODIFY `admin_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

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

--
-- AUTO_INCREMENT for table `bundle_product_relation`
--
ALTER TABLE `bundle_product_relation`
  MODIFY `rel_id` int(10) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `cat_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=25;

--
-- AUTO_INCREMENT for table `contact_us`
--
ALTER TABLE `contact_us`
  MODIFY `contact_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT for table `coupons`
--
ALTER TABLE `coupons`
  MODIFY `coupon_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `customers`
--
ALTER TABLE `customers`
  MODIFY `customer_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `customer_orders`
--
ALTER TABLE `customer_orders`
  MODIFY `order_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `enquiry_types`
--
ALTER TABLE `enquiry_types`
  MODIFY `enquiry_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `manufacturers`
--
ALTER TABLE `manufacturers`
  MODIFY `manufacturer_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
  MODIFY `payment_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;

--
-- AUTO_INCREMENT for table `pending_orders`
--
ALTER TABLE `pending_orders`
  MODIFY `order_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=33;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `product_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;

--
-- AUTO_INCREMENT for table `product_categories`
--
ALTER TABLE `product_categories`
  MODIFY `p_cat_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT for table `store`
--
ALTER TABLE `store`
  MODIFY `store_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `terms`
--
ALTER TABLE `terms`
  MODIFY `term_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

--
-- AUTO_INCREMENT for table `wishlist`
--
ALTER TABLE `wishlist`
  MODIFY `wishlist_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;
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 */;
