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

START TRANSACTION;



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

--
-- Table structure for table `appointment`
--

CREATE TABLE `appointment` (
  `cus_id` int(11) NOT NULL,
  `cus_name` varchar(500) NOT NULL,
  `cus_email` varchar(500) NOT NULL,
  `cus_phone` varchar(15) NOT NULL,
  `cus_person` int(11) NOT NULL,
  `cus_app_date` date NOT NULL,
  `cus_message` text NOT NULL,
  `date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `appointment`
--

INSERT INTO `appointment` (`cus_id`, `cus_name`, `cus_email`, `cus_phone`, `cus_person`, `cus_app_date`, `cus_message`, `date`) VALUES
(5, 'dsfd', 'asddda@gmail.com', '7865939447', 2, '0000-00-00', '', '0000-00-00'),
(6, 'sdfsdffd', 'dsffd@gmail.com', '7865939447', 2, '2022-08-31', 'dfsdsfdsdfsdf', '2022-08-29');

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

--
-- Table structure for table `blog`
--

CREATE TABLE `blog` (
  `id` int(11) NOT NULL,
  `category` varchar(255) NOT NULL,
  `title` varchar(500) NOT NULL,
  `title_slug` varchar(500) NOT NULL,
  `content` text NOT NULL,
  `image` varchar(500) NOT NULL,
  `tag` text NOT NULL,
  `keywords` text NOT NULL,
  `short_description` varchar(500) NOT NULL,
  `view` int(11) NOT NULL,
  `breaking` int(1) NOT NULL DEFAULT 1,
  `date` datetime NOT NULL,
  `author` varchar(255) NOT NULL,
  `visibility` int(1) NOT NULL DEFAULT 1,
  `like` int(11) NOT NULL,
  `dislike` int(11) NOT NULL,
  `love` int(11) NOT NULL,
  `wow` int(11) NOT NULL,
  `funny` int(11) NOT NULL,
  `angry` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `blog`
--

INSERT INTO `blog` (`id`, `category`, `title`, `title_slug`, `content`, `image`, `tag`, `keywords`, `short_description`, `view`, `breaking`, `date`, `author`, `visibility`, `like`, `dislike`, `love`, `wow`, `funny`, `angry`) VALUES
(10, '4', 'Happy Hands Nail Polish And Exclusive Collection', 'happy-hands-nail-polish-and-exclusive-collection', '<p style=\"margin-bottom: 15px; color: var(--bodyColor); font-family: Rubik, sans-serif;\">Lorem ipsum dolor sit amet consectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in sed quia non numquam eius modi tempora incidunt ut labore et dolore.Sed do eiusmod tempor incididunt ut labore et dolore,magna aliqua. Ut enim ad minim, incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p><p style=\"margin-bottom: 15px; color: var(--bodyColor); font-family: Rubik, sans-serif;\">Lorem ipsum dolor sit amet consectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in sed quia non numquam eius</p><blockquote style=\"margin: 30px 0px; position: relative; z-index: 1; background-color: rgb(245, 245, 245); padding: 30px 60px 35px; font-family: Rubik, sans-serif;\"><p style=\"color: var(--titleColor); font-size: 17px; font-weight: 600; margin-left: 0px; font-family: var(--headerFonts);\">Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Quis ipsum suspendisse ultrices gravida. Risus commodo viverra maecenas accumsan lacus vel facilisis.</p></blockquote><p style=\"margin-bottom: 15px; color: var(--bodyColor); font-family: Rubik, sans-serif;\">Lorem ipsum dolor sit amet consectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in sed quia non numquam eius modi tempora incidunt ut labore et dolore.Sed do eiusmod tempor incididunt ut labore et dolore,magna aliqua. Ut enim ad minim, incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p><p style=\"margin-bottom: 15px; color: var(--bodyColor); font-family: Rubik, sans-serif;\">Lorem ipsum dolor sit amet consectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in sed quia non numquam eius</p><div class=\"blog-article-content\" style=\"margin-bottom: 30px; font-family: Rubik, sans-serif;\"><h3 style=\"margin-bottom: 15px; font-weight: 700; line-height: 1.4; font-size: 26px; font-family: var(--headerFonts);\">Facial Scrub is Natural Care</h3><ul style=\"padding: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; list-style-type: none;\"><li style=\"margin-bottom: 10px; display: block; font-size: var(--fontSize); padding-left: 28px; position: relative; z-index: 1; transition: var(--transition);\"><span class=\"ri-check-line\" style=\"-webkit-font-smoothing: antialiased; position: absolute; top: 5px; left: 0px; color: var(--mainColor); font-size: 20px; line-height: 1; font-family: remixicon !important;\"></span>Duis quis odio quis dui sagittis laoreet.</li><li style=\"margin-bottom: 10px; display: block; font-size: var(--fontSize); padding-left: 28px; position: relative; z-index: 1; transition: var(--transition);\"><span class=\"ri-check-line\" style=\"-webkit-font-smoothing: antialiased; position: absolute; top: 5px; left: 0px; color: var(--mainColor); font-size: 20px; line-height: 1; font-family: remixicon !important;\"></span>Suspendisse tempus felis a libero mollis ultrices.</li><li style=\"margin-bottom: 10px; display: block; font-size: var(--fontSize); padding-left: 28px; position: relative; z-index: 1; transition: var(--transition);\"><span class=\"ri-check-line\" style=\"-webkit-font-smoothing: antialiased; position: absolute; top: 5px; left: 0px; color: var(--mainColor); font-size: 20px; line-height: 1; font-family: remixicon !important;\"></span>Lorem ipsum dolor sit amet, consectetur adipiscing elit.</li><li style=\"margin-bottom: 10px; display: block; font-size: var(--fontSize); padding-left: 28px; position: relative; z-index: 1; transition: var(--transition);\"><span class=\"ri-check-line\" style=\"-webkit-font-smoothing: antialiased; position: absolute; top: 5px; left: 0px; color: var(--mainColor); font-size: 20px; line-height: 1; font-family: remixicon !important;\"></span>Suspendisse tempus felis a libero mollis ultrices.</li><li style=\"margin-bottom: 10px; display: block; font-size: var(--fontSize); padding-left: 28px; position: relative; z-index: 1; transition: var(--transition);\"><span class=\"ri-check-line\" style=\"-webkit-font-smoothing: antialiased; position: absolute; top: 5px; left: 0px; color: var(--mainColor); font-size: 20px; line-height: 1; font-family: remixicon !important;\"></span>Proin sit amet diam et elit dictum sodales.</li></ul></div>', '/uploads/1720696752_6f557ae757630133065b.jpeg', '', '', 'Lorem ipsum dolor sit amet consectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in sed quia non numquam eius modi tempora incidunt ut labore et dolore.Sed do eiusmod tempor incididunt ut labore et dolore,magna aliqua. Ut enim ad minim, incidunt ut labore et dolore magnam aliquam quaerat voluptatem.', 0, 0, '2022-08-28 03:30:49', '', 1, 0, 0, 0, 0, 0, 0),
(11, '5', 'Organize Your Nail Polishes! 5 Creative Ways To Do Polish', 'organize-your-nail-polishes-5-creative-ways-to-do-polish', '<p style=\"margin-bottom: 15px; color: var(--bodyColor); font-family: Rubik, sans-serif;\">Lorem ipsum dolor sit amet consectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in sed quia non numquam eius modi tempora incidunt ut labore et dolore.Sed do eiusmod tempor incididunt ut labore et dolore,magna aliqua. Ut enim ad minim, incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p><p style=\"margin-bottom: 15px; color: var(--bodyColor); font-family: Rubik, sans-serif;\">Lorem ipsum dolor sit amet consectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in sed quia non numquam eius</p><blockquote style=\"margin: 30px 0px; position: relative; z-index: 1; background-color: rgb(245, 245, 245); padding: 30px 60px 35px; font-family: Rubik, sans-serif;\"><p style=\"color: var(--titleColor); font-size: 17px; font-weight: 600; margin-left: 0px; font-family: var(--headerFonts);\">Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Quis ipsum suspendisse ultrices gravida. Risus commodo viverra maecenas accumsan lacus vel facilisis.</p></blockquote><p style=\"margin-bottom: 15px; color: var(--bodyColor); font-family: Rubik, sans-serif;\">Lorem ipsum dolor sit amet consectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in sed quia non numquam eius modi tempora incidunt ut labore et dolore.Sed do eiusmod tempor incididunt ut labore et dolore,magna aliqua. Ut enim ad minim, incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p><p style=\"margin-bottom: 15px; color: var(--bodyColor); font-family: Rubik, sans-serif;\">Lorem ipsum dolor sit amet consectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in sed quia non numquam eius</p><div class=\"blog-article-content\" style=\"margin-bottom: 30px; font-family: Rubik, sans-serif;\"><h3 style=\"margin-bottom: 15px; font-weight: 700; line-height: 1.4; font-size: 26px; font-family: var(--headerFonts);\">Facial Scrub is Natural Care</h3><ul style=\"padding: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; list-style-type: none;\"><li style=\"margin-bottom: 10px; display: block; font-size: var(--fontSize); padding-left: 28px; position: relative; z-index: 1; transition: var(--transition);\"><span class=\"ri-check-line\" style=\"-webkit-font-smoothing: antialiased; position: absolute; top: 5px; left: 0px; color: var(--mainColor); font-size: 20px; line-height: 1; font-family: remixicon !important;\"></span>Duis quis odio quis dui sagittis laoreet.</li><li style=\"margin-bottom: 10px; display: block; font-size: var(--fontSize); padding-left: 28px; position: relative; z-index: 1; transition: var(--transition);\"><span class=\"ri-check-line\" style=\"-webkit-font-smoothing: antialiased; position: absolute; top: 5px; left: 0px; color: var(--mainColor); font-size: 20px; line-height: 1; font-family: remixicon !important;\"></span>Suspendisse tempus felis a libero mollis ultrices.</li><li style=\"margin-bottom: 10px; display: block; font-size: var(--fontSize); padding-left: 28px; position: relative; z-index: 1; transition: var(--transition);\"><span class=\"ri-check-line\" style=\"-webkit-font-smoothing: antialiased; position: absolute; top: 5px; left: 0px; color: var(--mainColor); font-size: 20px; line-height: 1; font-family: remixicon !important;\"></span>Lorem ipsum dolor sit amet, consectetur adipiscing elit.</li><li style=\"margin-bottom: 10px; display: block; font-size: var(--fontSize); padding-left: 28px; position: relative; z-index: 1; transition: var(--transition);\"><span class=\"ri-check-line\" style=\"-webkit-font-smoothing: antialiased; position: absolute; top: 5px; left: 0px; color: var(--mainColor); font-size: 20px; line-height: 1; font-family: remixicon !important;\"></span>Suspendisse tempus felis a libero mollis ultrices.</li><li style=\"margin-bottom: 10px; display: block; font-size: var(--fontSize); padding-left: 28px; position: relative; z-index: 1; transition: var(--transition);\"><span class=\"ri-check-line\" style=\"-webkit-font-smoothing: antialiased; position: absolute; top: 5px; left: 0px; color: var(--mainColor); font-size: 20px; line-height: 1; font-family: remixicon !important;\"></span>Proin sit amet diam et elit dictum sodales.</li></ul></div>', '/uploads/1720696880_eaa86c9973b637b4f036.jpeg', '', '', 'Organize Your Nail Polishes! 5 Creative Ways To Do Polish', 0, 0, '2022-08-28 03:32:34', '', 1, 0, 0, 0, 0, 0, 0),
(12, '6', 'How To Strengthen Brittle Nails Naturally', 'how-to-strengthen-brittle-nails-naturally', '<p style=\"margin-bottom: 15px; color: var(--bodyColor); font-family: Rubik, sans-serif;\">Lorem ipsum dolor sit amet consectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in sed quia non numquam eius modi tempora incidunt ut labore et dolore.Sed do eiusmod tempor incididunt ut labore et dolore,magna aliqua. Ut enim ad minim, incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p><p style=\"margin-bottom: 15px; color: var(--bodyColor); font-family: Rubik, sans-serif;\">Lorem ipsum dolor sit amet consectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in sed quia non numquam eius</p><blockquote style=\"margin: 30px 0px; position: relative; z-index: 1; background-color: rgb(245, 245, 245); padding: 30px 60px 35px; font-family: Rubik, sans-serif;\"><p style=\"color: var(--titleColor); font-size: 17px; font-weight: 600; margin-left: 0px; font-family: var(--headerFonts);\">Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Quis ipsum suspendisse ultrices gravida. Risus commodo viverra maecenas accumsan lacus vel facilisis.</p></blockquote><p style=\"margin-bottom: 15px; color: var(--bodyColor); font-family: Rubik, sans-serif;\">Lorem ipsum dolor sit amet consectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in sed quia non numquam eius modi tempora incidunt ut labore et dolore.Sed do eiusmod tempor incididunt ut labore et dolore,magna aliqua. Ut enim ad minim, incidunt ut labore et dolore magnam aliquam quaerat voluptatem.</p><p style=\"margin-bottom: 15px; color: var(--bodyColor); font-family: Rubik, sans-serif;\">Lorem ipsum dolor sit amet consectetur adipisicing elit sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in sed quia non numquam eius</p><div class=\"blog-article-content\" style=\"margin-bottom: 30px; font-family: Rubik, sans-serif;\"><h3 style=\"margin-bottom: 15px; font-weight: 700; line-height: 1.4; font-size: 26px; font-family: var(--headerFonts);\">Facial Scrub is Natural Care</h3><ul style=\"padding: 0px; margin-right: 0px; margin-bottom: 0px; margin-left: 0px; list-style-type: none;\"><li style=\"margin-bottom: 10px; display: block; font-size: var(--fontSize); padding-left: 28px; position: relative; z-index: 1; transition: var(--transition);\"><span class=\"ri-check-line\" style=\"-webkit-font-smoothing: antialiased; position: absolute; top: 5px; left: 0px; color: var(--mainColor); font-size: 20px; line-height: 1; font-family: remixicon !important;\"></span>Duis quis odio quis dui sagittis laoreet.</li><li style=\"margin-bottom: 10px; display: block; font-size: var(--fontSize); padding-left: 28px; position: relative; z-index: 1; transition: var(--transition);\"><span class=\"ri-check-line\" style=\"-webkit-font-smoothing: antialiased; position: absolute; top: 5px; left: 0px; color: var(--mainColor); font-size: 20px; line-height: 1; font-family: remixicon !important;\"></span>Suspendisse tempus felis a libero mollis ultrices.</li><li style=\"margin-bottom: 10px; display: block; font-size: var(--fontSize); padding-left: 28px; position: relative; z-index: 1; transition: var(--transition);\"><span class=\"ri-check-line\" style=\"-webkit-font-smoothing: antialiased; position: absolute; top: 5px; left: 0px; color: var(--mainColor); font-size: 20px; line-height: 1; font-family: remixicon !important;\"></span>Lorem ipsum dolor sit amet, consectetur adipiscing elit.</li><li style=\"margin-bottom: 10px; display: block; font-size: var(--fontSize); padding-left: 28px; position: relative; z-index: 1; transition: var(--transition);\"><span class=\"ri-check-line\" style=\"-webkit-font-smoothing: antialiased; position: absolute; top: 5px; left: 0px; color: var(--mainColor); font-size: 20px; line-height: 1; font-family: remixicon !important;\"></span>Suspendisse tempus felis a libero mollis ultrices.</li><li style=\"margin-bottom: 10px; display: block; font-size: var(--fontSize); padding-left: 28px; position: relative; z-index: 1; transition: var(--transition);\"><span class=\"ri-check-line\" style=\"-webkit-font-smoothing: antialiased; position: absolute; top: 5px; left: 0px; color: var(--mainColor); font-size: 20px; line-height: 1; font-family: remixicon !important;\"></span>Proin sit amet diam et elit dictum sodales.</li></ul></div>', '/uploads/1720696908_fb6bfc32b0c4dd7551a4.jpeg', '', '', 'How To Strengthen Brittle Nails Naturally', 0, 0, '2022-08-28 03:46:17', '', 1, 0, 0, 0, 0, 0, 0);

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

--
-- Table structure for table `blog_category`
--

CREATE TABLE `blog_category` (
  `category_id` int(11) NOT NULL,
  `category_name` varchar(500) NOT NULL,
  `category_slug` varchar(500) NOT NULL,
  `category_image` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `blog_category`
--

INSERT INTO `blog_category` (`category_id`, `category_name`, `category_slug`, `category_image`) VALUES
(4, ' Massage Therapy ', 'massage-therapy', '/uploads/1661680759_a9ec88bf9219d3ace03e.jpg'),
(5, ' Aroma Therapy ', 'aroma-therapy', '/uploads/1661680773_2cca09d17a13838ff62d.jpg'),
(6, ' Oil Therapy ', 'oil-therapy', '/uploads/1661680786_1493e14f63331277ece0.jpg'),
(7, ' Revive with Rose ', 'revive-with-rose', '/uploads/1661680799_4a807950f10553f4abf9.jpg');

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

--
-- Table structure for table `blog_review`
--

CREATE TABLE `blog_review` (
  `id` int(11) NOT NULL,
  `blog_id` int(11) NOT NULL,
  `name` varchar(500) NOT NULL,
  `mobile` varchar(500) NOT NULL,
  `comment` text NOT NULL,
  `date_time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `blog_review`
--

INSERT INTO `blog_review` (`id`, `blog_id`, `name`, `mobile`, `comment`, `date_time`) VALUES
(2, 3, 'Saikat', '7865939447', 'dshfsdhfjhdfjf', '2021-12-08 11:17:54');

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

--
-- Table structure for table `brand`
--

CREATE TABLE `brand` (
  `brand_id` int(11) NOT NULL,
  `brand_name` varchar(500) NOT NULL,
  `brand_slug` varchar(500) NOT NULL,
  `brand_image` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `brand`
--

INSERT INTO `brand` (`brand_id`, `brand_name`, `brand_slug`, `brand_image`) VALUES
(15, 'Matrix', 'matrix', '/uploads/1663566192_73772e6e6539c7478628.jpeg');

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

--
-- Table structure for table `category`
--

CREATE TABLE `category` (
  `category_id` int(11) NOT NULL,
  `category_code` varchar(255) NOT NULL,
  `category_name` varchar(255) NOT NULL,
  `category_slug` varchar(255) NOT NULL,
  `parent_category` int(11) NOT NULL DEFAULT 0,
  `category_front_show` int(1) NOT NULL DEFAULT 0,
  `category_menu_position` int(11) NOT NULL,
  `category_type` int(11) NOT NULL COMMENT '1=parent,2=sub caregory',
  `category_status` int(1) NOT NULL DEFAULT 1,
  `category_date` datetime NOT NULL,
  `category_varients` text NOT NULL,
  `category_banner` varchar(500) NOT NULL,
  `category_image` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `category`
--

INSERT INTO `category` (`category_id`, `category_code`, `category_name`, `category_slug`, `parent_category`, `category_front_show`, `category_menu_position`, `category_type`, `category_status`, `category_date`, `category_varients`, `category_banner`, `category_image`) VALUES
(298, '1512556163', 'Skin care', 'skin-care', 0, 1, 0, 1, 1, '2022-09-17 05:43:01', '[\"65\"]', '', ''),
(299, '1266822527', 'Hair Care', 'hair-care', 0, 1, 0, 1, 1, '2022-09-17 05:43:33', '[\"65\",\"67\"]', '', ''),
(300, '1174266933', 'Hair Colour', 'hair-colour', 0, 1, 0, 1, 1, '2022-09-17 05:44:06', '[\"65\"]', '', ''),
(301, '2001370406', 'Shampoo', 'shampoo', 299, 1, 0, 2, 1, '2022-09-17 05:44:42', 'null', '', ''),
(302, '1390908904', 'Conditioner', 'conditioner', 299, 1, 0, 2, 1, '2022-09-19 11:14:00', '[\"65\",\"66\"]', '', ''),
(303, '2019407180', 'Leave-In Cream', 'leave-in-cream', 299, 1, 0, 2, 1, '2022-09-19 11:45:10', '[\"65\",\"66\",\"67\"]', '', ''),
(304, '1383371432', 'Matrix LightMaster', 'matrix-lightmaster', 300, 1, 0, 2, 1, '2022-09-19 12:20:59', '[\"65\",\"66\",\"67\"]', '', ''),
(305, '1163032730', 'Matrix Wonder Color', 'matrix-wonder-color', 300, 1, 0, 2, 1, '2022-09-19 12:22:47', '[\"65\",\"66\",\"67\"]', '', ''),
(306, '1044855265', 'Matrix Oxydant', 'matrix-oxydant', 300, 1, 0, 2, 1, '2022-09-19 12:23:26', '[\"65\",\"66\",\"67\"]', '', ''),
(307, '1536725159', 'Matrix SoColor', 'matrix-socolor', 300, 1, 0, 2, 1, '2022-09-19 12:24:15', '[\"65\",\"66\",\"67\"]', '', ''),
(308, '1291399771', 'Hair Masque', 'hair-masque', 299, 1, 0, 2, 1, '2022-11-05 05:08:12', 'null', '', ''),
(309, '216491147', 'Hair Booster', 'hair-booster', 299, 1, 0, 2, 1, '2022-11-05 07:10:56', '[\"65\",\"66\",\"67\"]', '', ''),
(310, '1588804031', 'Hair Serum', 'hair-serum', 299, 1, 0, 2, 1, '2022-11-07 01:47:37', '[\"65\",\"66\"]', '', ''),
(311, '1094498376', 'Hair Treatment Biolage', 'hair-treatment-biolage', 299, 1, 0, 2, 1, '2022-11-07 03:09:27', '[\"65\",\"66\"]', '', ''),
(312, '1266536689', 'Styling', 'styling', 0, 1, 0, 1, 1, '2022-11-07 03:17:28', '[\"65\",\"66\",\"67\"]', '', ''),
(313, '648302635', 'Style Link', 'style-link', 312, 1, 0, 2, 1, '2022-11-07 03:39:02', '[\"65\",\"66\"]', '', '');

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

--
-- Table structure for table `contact_message`
--

CREATE TABLE `contact_message` (
  `id` int(11) NOT NULL,
  `name` varchar(500) NOT NULL,
  `email` varchar(500) NOT NULL,
  `phone` varchar(500) NOT NULL,
  `subject` varchar(500) NOT NULL,
  `message` text NOT NULL,
  `is_reply` int(1) NOT NULL DEFAULT 0,
  `date_time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `coupon_code`
--

CREATE TABLE `coupon_code` (
  `coupon_id` int(11) NOT NULL,
  `coupon_code` varchar(50) NOT NULL,
  `coupon_discount` int(11) NOT NULL,
  `coupon_start_date` datetime NOT NULL,
  `coupon_end_date` datetime NOT NULL,
  `coupon_count` int(11) NOT NULL,
  `coupon_used` int(11) NOT NULL,
  `coupon_status` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

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

--
-- Table structure for table `course`
--

CREATE TABLE `course` (
  `id` int(11) NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `course_slug` varchar(500) NOT NULL,
  `short_description` longtext DEFAULT NULL,
  `description` longtext DEFAULT NULL,
  `outcomes` longtext DEFAULT NULL,
  `language` varchar(255) DEFAULT NULL,
  `category_id` int(11) DEFAULT NULL,
  `sub_category_id` int(11) DEFAULT NULL,
  `section` longtext DEFAULT NULL,
  `requirements` longtext DEFAULT NULL,
  `course_price` double DEFAULT NULL,
  `discounted_price` int(11) DEFAULT NULL,
  `study_meterial_charge` int(11) NOT NULL,
  `level` varchar(50) DEFAULT NULL,
  `user_id` varchar(255) DEFAULT NULL,
  `thumbnail` varchar(255) DEFAULT NULL,
  `video_url` varchar(255) DEFAULT NULL,
  `date_added` date DEFAULT NULL,
  `is_top_course` int(11) DEFAULT 0,
  `is_admin` int(11) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `course_overview_provider` varchar(255) DEFAULT NULL,
  `meta_title` varchar(500) NOT NULL,
  `meta_keywords` longtext DEFAULT NULL,
  `meta_description` longtext DEFAULT NULL,
  `is_free_course` int(11) DEFAULT NULL,
  `multi_instructor` int(11) NOT NULL DEFAULT 0,
  `enable_drip_content` int(11) NOT NULL,
  `creator` int(11) DEFAULT NULL,
  `course_duration_in_month` int(11) NOT NULL,
  `exam_time` int(11) NOT NULL,
  `course_type` varchar(100) NOT NULL DEFAULT 'general',
  `course_selling` int(11) NOT NULL,
  `atp_course_price` int(11) NOT NULL,
  `online_exam_marks` int(11) NOT NULL,
  `practical_exam_marks` int(11) NOT NULL,
  `viva_exam_marks` int(11) NOT NULL,
  `total_questions` int(11) NOT NULL,
  `course_duration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `course`
--

INSERT INTO `course` (`id`, `title`, `course_slug`, `short_description`, `description`, `outcomes`, `language`, `category_id`, `sub_category_id`, `section`, `requirements`, `course_price`, `discounted_price`, `study_meterial_charge`, `level`, `user_id`, `thumbnail`, `video_url`, `date_added`, `is_top_course`, `is_admin`, `status`, `course_overview_provider`, `meta_title`, `meta_keywords`, `meta_description`, `is_free_course`, `multi_instructor`, `enable_drip_content`, `creator`, `course_duration_in_month`, `exam_time`, `course_type`, `course_selling`, `atp_course_price`, `online_exam_marks`, `practical_exam_marks`, `viva_exam_marks`, `total_questions`, `course_duration`) VALUES
(7, 'Professional Makeup & Hairstyling Course', 'professional-makeup-amp-hairstyling-course', 'Basic to Highly Advance Makeup – Including Air-Brush', ' Academy Certificate\r\n', '[]', NULL, NULL, NULL, '[]', '[\"Confidence & Passionate about Makeup\"]', 75000, 55000, 0, 'advanced', NULL, '/uploads/1720695707_037d533669ecc5c09604.jpeg', '', '2023-01-19', 0, NULL, NULL, 'youtube', '', '', '', NULL, 0, 0, NULL, 0, 0, 'general', 0, 0, 0, 0, 0, 0, 6),
(8, 'Professional Master in Beauty', 'professional-master-in-beauty', 'Basic to Highly Advance', 'Professional Makeup Courses in Mumbai\r\nBecome a Master Makeup Artist\r\nBridal, Beauty, Glamour, Fashion, Airbrush & Lot More\r\n', '[]', NULL, NULL, NULL, '[]', '[\"Confidence & Passionate about Makeup\"]', 45000, 25000, 0, 'intermediate', NULL, '/uploads/1720696190_45c2ffe623159c0689e2.jpeg', '', '2023-01-19', 0, NULL, NULL, 'youtube', '', '', '', NULL, 0, 0, NULL, 0, 0, 'general', 0, 0, 0, 0, 0, 0, 0),
(9, 'Professional Hairstyling Course', 'professional-hairstyling-course', 'Best Makeup Academy in Mumbai', 'World-Class Hair Styles\r\nUp do\'s, Down do\'s, Red Carpet, Bridal, Fashion, Latest Hair Styles\r\nMonths\r\n\r\n● Academy Certificate\r\n\r\nDuration 1.5 Months.\r\n\r\n', '[]', NULL, NULL, NULL, '[]', '[\"Confidence & Passionate about Makeup\"]', 55000, 40000, 0, 'advanced', NULL, '/uploads/1720696272_3300c2fcd78f52412cf7.jpeg', '', '2023-01-19', 0, NULL, NULL, 'youtube', '', '', '', NULL, 0, 0, NULL, 0, 0, 'general', 0, 0, 0, 0, 0, 0, 0),
(10, 'Diploma In Beauty', 'diploma-in-beauty', 'Fast Track Course(Duration in 15 Days)', 'Become a Professional Beautician', '[]', NULL, NULL, NULL, '[]', '[\"Beauty, Hair, Skin & Machine Treatment\"]', 25000, 15000, 0, 'beginner', NULL, '/uploads/1720696306_a8a668f5a905dda3e46e.jpeg', '', '2023-01-19', 0, NULL, NULL, 'youtube', '', '', '', NULL, 0, 0, NULL, 0, 0, 'general', 0, 0, 0, 0, 0, 0, 0),
(11, 'Diploma In Beauty', 'diploma-in-beauty', 'Fast Track Course(Duration in 15 Days)', 'Become a Professional Beautician', '[]', NULL, NULL, NULL, '[]', '[\"Beauty, Hair, Skin & Machine Treatment\"]', 25000, 15000, 0, 'beginner', NULL, '/uploads/1720696355_6b73b096a7ad93d5592f.jpeg', '', '2023-01-19', 0, NULL, NULL, 'youtube', '', '', '', NULL, 0, 0, NULL, 0, 0, 'general', 0, 0, 0, 0, 0, 0, 0),
(12, 'Diploma in Hair', 'diploma-in-hair', 'Fast Track Course(Duration 20 Days)', 'A bride’s beauty lies in her freshness. Hence never take chances of letting your hair be as they are.', '[]', NULL, NULL, NULL, '[]', '[\"Frizz-free with our range of Cysteine, Keratin, Smoothening, Rebounding Services\"]', 45, 20000, 0, 'beginner', NULL, '/uploads/1720696387_b1fecf01b85d752577a1.jpeg', '', '2023-01-19', 0, NULL, NULL, 'youtube', '', '', '', NULL, 0, 0, NULL, 0, 0, 'general', 0, 0, 0, 0, 0, 0, 0);

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

--
-- Table structure for table `course_admission`
--

CREATE TABLE `course_admission` (
  `admission_id` int(11) NOT NULL,
  `admission_code` varchar(50) NOT NULL,
  `admission_course` int(11) NOT NULL,
  `admission_student_id` int(11) NOT NULL,
  `admission_duration` int(11) NOT NULL,
  `admission_course_price` int(11) NOT NULL,
  `admission_price` int(11) NOT NULL,
  `admission_date` date NOT NULL,
  `admission_create_date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `course_admission`
--

INSERT INTO `course_admission` (`admission_id`, `admission_code`, `admission_course`, `admission_student_id`, `admission_duration`, `admission_course_price`, `admission_price`, `admission_date`, `admission_create_date`) VALUES
(1, '202408312188', 7, 546, 6, 55000, 50000, '2024-01-16', '2024-08-31'),
(2, '202408315198', 8, 546, 0, 25000, 1000, '2024-02-22', '2024-08-31');

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

--
-- Table structure for table `course_inquery`
--

CREATE TABLE `course_inquery` (
  `inq_id` int(11) NOT NULL,
  `inq_name` varchar(500) NOT NULL,
  `inq_email_id` varchar(500) NOT NULL,
  `inq_mobile` varchar(15) NOT NULL,
  `inq_message` text NOT NULL,
  `inq_course` int(11) NOT NULL,
  `inq_date` date NOT NULL,
  `inq_is_admited` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `course_inquery`
--

INSERT INTO `course_inquery` (`inq_id`, `inq_name`, `inq_email_id`, `inq_mobile`, `inq_message`, `inq_course`, `inq_date`, `inq_is_admited`) VALUES
(4, 'Saikat', 'saikat@gmail.com', '7865939447', 'Duan', 5, '2023-01-14', 0),
(5, 'adnan sayyed', 'adnansayyed@GMAIL.COM', '932128378', 'TESD', 9, '2024-07-04', 0),
(6, 'adnan sayyed', 'adnansayyed@GMAIL.COM', '932128378', 'TESD', 9, '2024-07-04', 0),
(7, 'adnan sayyed', 'adnansayyed@GMAIL.COM', '932128378', 'TESD', 9, '2024-07-04', 0),
(8, 'adnan sayyed', 'adnansayyed@GMAIL.COM', '9876543210', 'tesrt', 7, '2024-07-04', 0),
(9, 'sss', 'ss@gmail.com', '78', '', 7, '2024-08-31', 0),
(10, 'Saikat Majumder', 'saikat.majumder2008@gmail.com', '7865939447', '', 7, '2024-08-31', 0);

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

--
-- Table structure for table `extra_page`
--

CREATE TABLE `extra_page` (
  `id` int(11) NOT NULL,
  `name` varchar(500) NOT NULL,
  `slug` varchar(500) NOT NULL,
  `content` longtext NOT NULL,
  `meta_descrition` text NOT NULL,
  `meta_keyword` text NOT NULL,
  `image` varchar(500) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 1,
  `date` date NOT NULL,
  `important` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `extra_page`
--

INSERT INTO `extra_page` (`id`, `name`, `slug`, `content`, `meta_descrition`, `meta_keyword`, `image`, `status`, `date`, `important`) VALUES
(5, 'Refund and Cancellation', 'Refund-and-Cancellation', '<p>Hi</p>', '', '', '', 1, '2021-09-25', 'Policies'),
(6, 'Terms & Conditions', 'Terms-&-Conditions', '<p><font color=\"#000000\">fsdfsdffdf</font></p>', '', '', '/uploads/1641301112_05b97e08b3d08c8b3f1a.jpg', 1, '2021-09-25', 'Policies'),
(7, 'Course', 'course', '<h1 class=\"hkb-article__title\" style=\"font-size: 2.5em; margin-right: 0px; margin-bottom: 1.5em; margin-left: 0px; font-family: -apple-system, BlinkMacSystemFont, &quot;segoe ui&quot;, &quot;helvetica neue&quot;, Helvetica, Arial, sans-serif; color: rgb(34, 34, 34); font-weight: 700; transition: none 0s ease 0s;\">Where to find demo content for your WordPress website</h1><div class=\"hkb-article__content\" style=\"transition: none 0s ease 0s; margin: 0px 0px 2em; padding: 0px; color: rgb(105, 105, 105); font-family: -apple-system, BlinkMacSystemFont, &quot;segoe ui&quot;, &quot;helvetica neue&quot;, Helvetica, Arial, sans-serif; font-size: 17.6px;\"><figure id=\"attachment_792\" aria-describedby=\"caption-attachment-792\" class=\"wp-caption aligncenter\" style=\"margin-right: auto; margin-bottom: 2rem; margin-left: auto; clear: both; max-width: 100%; transition: none 0s ease 0s; width: 670px;\"><img decoding=\"async\" class=\"size-full wp-image-792 entered lazyloaded\" src=\"https://mhthemes.com/wp-content/uploads/2016/06/WordPress_Demo_Content.jpg\" alt=\"WordPress Demo Content\" width=\"670\" height=\"350\" data-lazy-srcset=\"https://mhthemes.com/wp-content/uploads/2016/06/WordPress_Demo_Content.jpg 670w, https://mhthemes.com/wp-content/uploads/2016/06/WordPress_Demo_Content-300x157.jpg 300w, https://mhthemes.com/wp-content/uploads/2016/06/WordPress_Demo_Content-50x26.jpg 50w, https://mhthemes.com/wp-content/uploads/2016/06/WordPress_Demo_Content-480x252.jpg 480w\" data-lazy-sizes=\"(max-width: 670px) 100vw, 670px\" data-lazy-src=\"https://mhthemes.com/wp-content/uploads/2016/06/WordPress_Demo_Content.jpg\" data-ll-status=\"loaded\" sizes=\"(max-width: 670px) 100vw, 670px\" srcset=\"https://mhthemes.com/wp-content/uploads/2016/06/WordPress_Demo_Content.jpg 670w, https://mhthemes.com/wp-content/uploads/2016/06/WordPress_Demo_Content-300x157.jpg 300w, https://mhthemes.com/wp-content/uploads/2016/06/WordPress_Demo_Content-50x26.jpg 50w, https://mhthemes.com/wp-content/uploads/2016/06/WordPress_Demo_Content-480x252.jpg 480w\" style=\"height: auto; max-width: 100%; border-width: initial; border-color: initial; border-image: initial; transition: none 0s ease 0s;\"><figcaption id=\"caption-attachment-792\" class=\"wp-caption-text\" style=\"font-size: 0.875rem; line-height: 1.62; font-style: italic; transition: none 0s ease 0s;\">Image Source: kpgolfpro – Pixabay.com / License: CC0 Public Domain</figcaption></figure><p style=\"line-height: 1.62; margin-right: 0px; margin-bottom: 1.62rem; margin-left: 0px; transition: none 0s ease 0s;\">If you would like to have some demo content on your WordPress website, there are basically three different ways to do so. First, you could just quickly create some (sample) posts, categories, pages, etc. by yourself. Second, you could import demo content in WordPress through XML files and third, you could install a plugin which provides demo content. Let\'s look at each approach in detail.</p><ul style=\"list-style-type: none; padding: 0px; transition: none 0s ease 0s; margin-right: 0px; margin-bottom: 2em; margin-left: 2em;\"><li style=\"transition: none 0s ease 0s; background: 0px 0px; list-style: disc;\"><a href=\"https://mhthemes.com/support/knb/demo-content-for-wordpress-websites/#1-create-sample-content-by-yourself\" style=\"color: rgb(64, 91, 219); outline: 0px; transition: none 0s ease 0s;\">Create sample content by yourself</a></li><li style=\"transition: none 0s ease 0s; background: 0px 0px; list-style: disc;\"><a href=\"https://mhthemes.com/support/knb/demo-content-for-wordpress-websites/#2-import-demo-content-with-xml-files\" style=\"color: rgb(64, 91, 219); outline: 0px; transition: none 0s ease 0s;\">Import demo content with XML files</a></li><li style=\"transition: none 0s ease 0s; background: 0px 0px; list-style: disc;\"><a href=\"https://mhthemes.com/support/knb/demo-content-for-wordpress-websites/#3-wordpress-plugins-for-sample-content\" style=\"color: rgb(64, 91, 219); outline: 0px; transition: none 0s ease 0s;\">WordPress plugins for sample content</a></li></ul><div class=\"mh-separator content-separator\" style=\"transition: none 0s ease 0s;\"></div><h3 id=\"1-create-sample-content-by-yourself\" style=\"font-family: -apple-system, BlinkMacSystemFont, &quot;segoe ui&quot;, &quot;helvetica neue&quot;, Helvetica, Arial, sans-serif; color: rgb(34, 34, 34); margin: 1em 0px; font-weight: 700; transition: none 0s ease 0s;\">1 – Create sample content by yourself</h3><p style=\"line-height: 1.62; margin-right: 0px; margin-bottom: 1.62rem; margin-left: 0px; transition: none 0s ease 0s;\">In our opinion creating some demo content by yourself is probably the easiest and cleanest solution. Usually you know best how many posts, categories, pages, etc. you will exactly need for your website to make your layout work as expected. After you quickly have created some dummy content, you can selectively delete or replace it later on with your own&nbsp;<em style=\"transition: none 0s ease 0s;\">real</em>&nbsp;content.</p><h4 id=\"publishing-posts-pages-categories\" style=\"font-family: -apple-system, BlinkMacSystemFont, &quot;segoe ui&quot;, &quot;helvetica neue&quot;, Helvetica, Arial, sans-serif; color: rgb(34, 34, 34); margin: 1em 0px; font-weight: 700; transition: none 0s ease 0s;\">Publishing Posts, Pages, Categories…</h4><p style=\"line-height: 1.62; margin-right: 0px; margin-bottom: 1.62rem; margin-left: 0px; transition: none 0s ease 0s;\"><a href=\"https://mhthemes.com/support/create-posts-in-wordpress/\" style=\"color: rgb(64, 91, 219); outline: 0px; transition: none 0s ease 0s;\">Creating sample posts</a>&nbsp;(<em style=\"transition: none 0s ease 0s;\">Sample Post 1</em>,&nbsp;<em style=\"transition: none 0s ease 0s;\">2</em>,&nbsp;<em style=\"transition: none 0s ease 0s;\">3</em>…), sample categories (<em style=\"transition: none 0s ease 0s;\">Category A</em>,&nbsp;<em style=\"transition: none 0s ease 0s;\">B</em>,&nbsp;<em style=\"transition: none 0s ease 0s;\">C</em>…) and sample pages (<em style=\"transition: none 0s ease 0s;\">Home</em>,&nbsp;<em style=\"transition: none 0s ease 0s;\">Archive</em>,&nbsp;<em style=\"transition: none 0s ease 0s;\">Contact</em>…) can be done quickly and only takes a few minutes. If you need dummy text, you could copy and paste a few hundered words of&nbsp;<a href=\"https://www.lipsum.com/\" target=\"_blank\" rel=\"noopener noreferrer\" style=\"color: rgb(64, 91, 219); outline: 0px; transition: none 0s ease 0s;\">Lorem Ipsum</a>&nbsp;text into your articles.</p><h4 id=\"uploading-featured-images\" style=\"font-family: -apple-system, BlinkMacSystemFont, &quot;segoe ui&quot;, &quot;helvetica neue&quot;, Helvetica, Arial, sans-serif; color: rgb(34, 34, 34); margin: 1em 0px; font-weight: 700; transition: none 0s ease 0s;\">Uploading featured images</h4><p style=\"line-height: 1.62; margin-right: 0px; margin-bottom: 1.62rem; margin-left: 0px; transition: none 0s ease 0s;\">When it comes to images, most WordPress themes nowadays&nbsp;<a href=\"https://mhthemes.com/support/how-to-use-featured-images-wordpress/\" style=\"color: rgb(64, 91, 219); outline: 0px; transition: none 0s ease 0s;\">make use of featured images</a>. In case you haven\'t uploaded featured images for your posts yet, many WordPress themes usually display image placeholders instead of images on archives or within custom widgets.</p><p style=\"line-height: 1.62; margin-right: 0px; margin-bottom: 1.62rem; margin-left: 0px; transition: none 0s ease 0s;\">If you would like to replace the image placeholders with some real images and in case you don\'t have suitable images at hand, you could use free images which have been published under a free license for use on your WordPress website:&nbsp;<a href=\"https://mhthemes.com/blog/10-image-sources-for-wordpress-websites/\" style=\"color: rgb(64, 91, 219); outline: 0px; transition: none 0s ease 0s;\">10 Image Sources For Your WordPress Website Or Blog</a>.</p><figure id=\"attachment_793\" aria-describedby=\"caption-attachment-793\" class=\"wp-caption aligncenter\" style=\"margin-right: auto; margin-bottom: 2rem; margin-left: auto; clear: both; max-width: 100%; transition: none 0s ease 0s; width: 670px;\"><img decoding=\"async\" class=\"size-full wp-image-793 entered lazyloaded\" src=\"https://mhthemes.com/wp-content/uploads/2016/06/Creating_Sample_Content.jpg\" alt=\"Creating Sample Content\" width=\"670\" height=\"350\" data-lazy-srcset=\"https://mhthemes.com/wp-content/uploads/2016/06/Creating_Sample_Content.jpg 670w, https://mhthemes.com/wp-content/uploads/2016/06/Creating_Sample_Content-300x157.jpg 300w, https://mhthemes.com/wp-content/uploads/2016/06/Creating_Sample_Content-50x26.jpg 50w, https://mhthemes.com/wp-content/uploads/2016/06/Creating_Sample_Content-480x252.jpg 480w\" data-lazy-sizes=\"(max-width: 670px) 100vw, 670px\" data-lazy-src=\"https://mhthemes.com/wp-content/uploads/2016/06/Creating_Sample_Content.jpg\" data-ll-status=\"loaded\" sizes=\"(max-width: 670px) 100vw, 670px\" srcset=\"https://mhthemes.com/wp-content/uploads/2016/06/Creating_Sample_Content.jpg 670w, https://mhthemes.com/wp-content/uploads/2016/06/Creating_Sample_Content-300x157.jpg 300w, https://mhthemes.com/wp-content/uploads/2016/06/Creating_Sample_Content-50x26.jpg 50w, https://mhthemes.com/wp-content/uploads/2016/06/Creating_Sample_Content-480x252.jpg 480w\" style=\"height: auto; max-width: 100%; border-width: initial; border-color: initial; border-image: initial; transition: none 0s ease 0s;\"><figcaption id=\"caption-attachment-793\" class=\"wp-caption-text\" style=\"font-size: 0.875rem; line-height: 1.62; font-style: italic; transition: none 0s ease 0s;\">Image Source: Unsplash – Pixabay.com / License: CC0 Public Domain</figcaption></figure><div class=\"mh-separator content-separator\" style=\"transition: none 0s ease 0s;\"></div><h3 id=\"2-import-demo-content-with-xml-files\" style=\"font-family: -apple-system, BlinkMacSystemFont, &quot;segoe ui&quot;, &quot;helvetica neue&quot;, Helvetica, Arial, sans-serif; color: rgb(34, 34, 34); margin: 1em 0px; font-weight: 700; transition: none 0s ease 0s;\">2 – Import demo content with XML files</h3><p style=\"line-height: 1.62; margin-right: 0px; margin-bottom: 1.62rem; margin-left: 0px; transition: none 0s ease 0s;\">Another approach to get demo content on your WordPress website is by importing XML files with sample content. You can import XML files in your WordPress dashboard under&nbsp;<span style=\"font-weight: 700; transition: none 0s ease 0s;\">Tools =&gt; Import</span>&nbsp;and then select&nbsp;<em style=\"transition: none 0s ease 0s;\">WordPress</em>&nbsp;to install the&nbsp;<em style=\"transition: none 0s ease 0s;\">WordPress Importer</em>&nbsp;plugin.</p><p style=\"line-height: 1.62; margin-right: 0px; margin-bottom: 1.62rem; margin-left: 0px; transition: none 0s ease 0s;\">In case you don\'t have a demo content XML file, you could for example use the&nbsp;<a href=\"https://codex.wordpress.org/Theme_Unit_Test\" target=\"_blank\" rel=\"noopener noreferrer\" style=\"color: rgb(64, 91, 219); outline: 0px; transition: none 0s ease 0s;\">WordPress.org theme unit test data</a>&nbsp;which is often also being used by WordPress developers to test the output of their WordPress themes.</p><p style=\"line-height: 1.62; margin-right: 0px; margin-bottom: 1.62rem; margin-left: 0px; transition: none 0s ease 0s;\"><span style=\"font-weight: 700; transition: none 0s ease 0s;\">Important:</span>&nbsp;Please keep in mind that uploading XML files to your WordPress website usually just results in some sample content, which is helpful in case your website doesn\'t have content yet. XML files usually won\'t take care of the full website configuration for you.</p><p style=\"line-height: 1.62; margin-right: 0px; margin-bottom: 1.62rem; margin-left: 0px; transition: none 0s ease 0s;\">If you\'re using&nbsp;<a href=\"https://mhthemes.com/themes/\" style=\"color: rgb(64, 91, 219); outline: 0px; transition: none 0s ease 0s;\">WordPress themes by MH Themes</a>, the front page layout of your website usually is based on widgets and these widgets can\'t be placed by uploading a regular XML file. To configure your widgetized front page correctly, you can find all necessary information in the&nbsp;<a href=\"https://mhthemes.com/support/category/theme-documentation/\" style=\"color: rgb(64, 91, 219); outline: 0px; transition: none 0s ease 0s;\">theme documentation</a>&nbsp;of your particular WordPress theme.</p><div class=\"mh-separator content-separator\" style=\"transition: none 0s ease 0s;\"></div><h3 id=\"3-wordpress-plugins-for-sample-content\" style=\"font-family: -apple-system, BlinkMacSystemFont, &quot;segoe ui&quot;, &quot;helvetica neue&quot;, Helvetica, Arial, sans-serif; color: rgb(34, 34, 34); margin: 1em 0px; font-weight: 700; transition: none 0s ease 0s;\">3 – WordPress plugins for sample content</h3><p style=\"line-height: 1.62; margin-right: 0px; margin-bottom: 1.62rem; margin-left: 0px; transition: none 0s ease 0s;\">While doing some research, we have only found very few plugins in the official WordPress plugin directory which provide demo content for your website, e.g.&nbsp;<a href=\"https://wordpress.org/plugins/fakerpress/\" target=\"_blank\" rel=\"noopener noreferrer\" style=\"color: rgb(64, 91, 219); outline: 0px; transition: none 0s ease 0s;\">FakerPress</a>&nbsp;or&nbsp;<a href=\"https://wordpress.org/plugins/wp-example-content/\" target=\"_blank\" rel=\"noopener noreferrer\" style=\"color: rgb(64, 91, 219); outline: 0px; transition: none 0s ease 0s;\">WP Example Content</a>. Before using plugins for demo content, make sure that you know exactly what the particular plugin can and can\'t do. You should also check if the plugin is supported accordingly, compatible with your current WordPress version and well rated – before you install and use it on your website.</p><div class=\"mh-separator content-separator\" style=\"transition: none 0s ease 0s;\"></div><h3 id=\"conclusion-choosing-the-best-approach-for-demo-content\" style=\"font-family: -apple-system, BlinkMacSystemFont, &quot;segoe ui&quot;, &quot;helvetica neue&quot;, Helvetica, Arial, sans-serif; color: rgb(34, 34, 34); margin: 1em 0px; font-weight: 700; transition: none 0s ease 0s;\">Conclusion: Choosing the best approach for demo content</h3><p style=\"line-height: 1.62; margin-right: 0px; margin-bottom: 1.62rem; margin-left: 0px; transition: none 0s ease 0s;\">As you\'ve learned in this article, there basically are 3 ways to add demo content to your WordPress website. Which option you choose is up to you and always depends on your personal requirements and your experience in creating WordPress websites. Creating your own (sample) content can be done easily straight away, but might take a little effort.</p><figure id=\"attachment_796\" aria-describedby=\"caption-attachment-796\" class=\"wp-caption aligncenter\" style=\"margin-right: auto; margin-bottom: 2rem; margin-left: auto; clear: both; max-width: 100%; transition: none 0s ease 0s; width: 670px;\"><img decoding=\"async\" class=\"size-full wp-image-796 entered lazyloaded\" src=\"https://mhthemes.com/wp-content/uploads/2016/06/Workspace_Laptop.jpg\" alt=\"Workspace Laptop\" width=\"670\" height=\"350\" data-lazy-srcset=\"https://mhthemes.com/wp-content/uploads/2016/06/Workspace_Laptop.jpg 670w, https://mhthemes.com/wp-content/uploads/2016/06/Workspace_Laptop-300x157.jpg 300w, https://mhthemes.com/wp-content/uploads/2016/06/Workspace_Laptop-50x26.jpg 50w, https://mhthemes.com/wp-content/uploads/2016/06/Workspace_Laptop-480x252.jpg 480w\" data-lazy-sizes=\"(max-width: 670px) 100vw, 670px\" data-lazy-src=\"https://mhthemes.com/wp-content/uploads/2016/06/Workspace_Laptop.jpg\" data-ll-status=\"loaded\" sizes=\"(max-width: 670px) 100vw, 670px\" srcset=\"https://mhthemes.com/wp-content/uploads/2016/06/Workspace_Laptop.jpg 670w, https://mhthemes.com/wp-content/uploads/2016/06/Workspace_Laptop-300x157.jpg 300w, https://mhthemes.com/wp-content/uploads/2016/06/Workspace_Laptop-50x26.jpg 50w, https://mhthemes.com/wp-content/uploads/2016/06/Workspace_Laptop-480x252.jpg 480w\" style=\"height: auto; max-width: 100%; border-width: initial; border-color: initial; border-image: initial; transition: none 0s ease 0s;\"><figcaption id=\"caption-attachment-796\" class=\"wp-caption-text\" style=\"font-size: 0.875rem; line-height: 1.62; font-style: italic; transition: none 0s ease 0s;\">Image Source: annca – Pixabay.com / License: CC0 Public Domain</figcaption></figure><p style=\"line-height: 1.62; margin-right: 0px; margin-bottom: 1.62rem; margin-left: 0px; transition: none 0s ease 0s;\">Importing demo content through XML files usually is a quicker approach, however you should make sure you know exactly what is being imported to your website to prevent gathering needless content. The third solution would be the plugin approach, but as already mentioned, here you should be cautious and aware of the plugin functionality, otherwise you might experience unexpected issues or even loss of data when you delete content through the particular plugin.</p><p style=\"line-height: 1.62; margin-right: 0px; margin-bottom: 1.62rem; margin-left: 0px; transition: none 0s ease 0s;\">In general the best approach really depends on the nature of the website you\'re running. While importing demo content for a business website with less content makes sense, it usually doesn\'t make much sense to import dozens of demo posts for a&nbsp;<a href=\"https://mhthemes.com/themes/mh-magazine/\" style=\"color: rgb(64, 91, 219); outline: 0px; transition: none 0s ease 0s;\">magazine website</a>&nbsp;because you need to replace or delete all the content afterwards which can be a waste of time. In that case usually it would be better to simply start creating your own content to take your website to the next level.</p></div>', '', '', '', 1, '0000-00-00', 'Top'),
(8, 'About Us', 'about-us', '<p style=\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; font-size: 18px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 1.7; font-family: proxima_nova_rgregular; vertical-align: baseline; color: rgb(51, 71, 91); max-width: 100%; text-align: justify;\">An \"About Us\" Page is where you reveal your brand story, business values, mission, and experiences.&nbsp;</p><p style=\"margin: 30px 0px 0px; padding: 0px; font-size: 18px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 1.7; font-family: proxima_nova_rgregular; vertical-align: baseline; color: rgb(51, 71, 91); max-width: 100%; text-align: justify;\">Now the question is: why would you want to share all this information and make it appealing? The answer is simple: you want to tell your audience who you are, show them what you are good at, and tell them you are worthy of their trust.</p><p style=\"margin: 30px 0px 0px; padding: 0px; font-size: 18px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 1.7; font-family: proxima_nova_rgregular; vertical-align: baseline; color: rgb(51, 71, 91); max-width: 100%; text-align: justify;\">Think for a moment: would you rather purchase from a business you know nothing about, or would you go for somebody with a friendly face shared on their About page and a story that you find exciting? The latter one, right?&nbsp;</p><p style=\"margin: 30px 0px 0px; padding: 0px; font-size: 18px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 1.7; font-family: proxima_nova_rgregular; vertical-align: baseline; color: rgb(51, 71, 91); max-width: 100%; text-align: justify;\">A great About Us page not just portrays your story, qualities and provides an insight on how your business started, but it also helps you sell. When visitors become familiar with your story and connect with it, they\'re probably going to purchase from you. A well-planned About Us page can do this!</p><p style=\"margin: 30px 0px 0px; padding: 0px; font-size: 18px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 1.7; font-family: proxima_nova_rgregular; vertical-align: baseline; color: rgb(51, 71, 91); max-width: 100%; text-align: justify;\"><img loading=\"lazy\" src=\"https://www.webdew.com/hubfs/Web-images/tips-to-create-about-us-pages.webp\" alt=\"Tips to create about us pages\" width=\"1500\" style=\"margin: 15px auto; padding: 0px; font: inherit; word-break: normal; border: 0px; vertical-align: baseline; max-width: 100%; height: auto; width: 1500px; display: block;\"></p><h2 style=\"margin: 45px 0px 25px; padding: 0px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 32px; line-height: normal; font-family: proxima_nova_rgbold; vertical-align: baseline; color: rgb(51, 71, 91);\"><span style=\"margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: 16px; line-height: inherit; font-family: inherit; vertical-align: baseline; color: inherit !important;\">Why does your website need an About Us page?</span></h2><p style=\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; font-size: 18px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 1.7; font-family: proxima_nova_rgregular; vertical-align: baseline; color: rgb(51, 71, 91); max-width: 100%; text-align: justify;\">Well,&nbsp;<span style=\"margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; background-color: transparent; font-size: inherit !important;\">benefits of about us page are many.&nbsp;</span>Various types of visitors check out your \"About Us\" page. They can be first-time visitors, regular visitors, people who wish to work with you, and possible customers. With all kinds of visitors coming to your website, you need to offer sufficient and valuable information to convince them to establish a more substantial connection with you and your business.</p><p style=\"margin: 30px 0px 0px; padding: 0px; font-size: 18px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 1.7; font-family: proxima_nova_rgregular; vertical-align: baseline; color: rgb(51, 71, 91); max-width: 100%; text-align: justify;\"><span class=\"hs-cta-wrapper\" id=\"hs-cta-wrapper-54f20bf5-fd06-4e95-9e06-c8e0b1f90327\" style=\"margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; font-size: inherit !important; color: inherit !important;\"><span class=\"hs-cta-node hs-cta-54f20bf5-fd06-4e95-9e06-c8e0b1f90327\" id=\"hs-cta-54f20bf5-fd06-4e95-9e06-c8e0b1f90327\" data-hs-drop=\"true\" style=\"margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; visibility: visible; font-size: inherit !important; color: inherit !important;\"><a id=\"cta_button_3074142_49c3bec7-801b-4e71-96b1-19df71898b9c\" class=\"cta_button\" href=\"https://www.webdew.com/cs/c/?cta_guid=49c3bec7-801b-4e71-96b1-19df71898b9c&amp;signature=AAH58kEKAZUIQy1ShTnnQPSK-bVzbRqeZw&amp;pageId=43124498451&amp;placement_guid=54f20bf5-fd06-4e95-9e06-c8e0b1f90327&amp;click=e7fbb8ad-3bfd-4a53-913c-43d129e999c5&amp;hsutk=&amp;canon=https%3A%2F%2Fwww.webdew.com%2Fblog%2Fabout-us-page-examples&amp;portal_id=3074142&amp;redirect_url=APefjpF-UvSKFcjwEW_a9zw3H-TE59DWpYkwhJZBcRtOgLvSCPOGaJKE03Yas9hdOwid_tM3MgtpFERNAVfmtDBK7HBLQ2_QhI_8m1DIxF62BFK3c4qrEZxY8TwX_xLtb3gA3AytAsvyWrjmFSplecIgGQgLx3T9FQ\" target=\"_blank\" rel=\"noopener\" cta_dest_link=\"https://www.webdew.com/blog/create-professional-website\" style=\"margin: 0px; padding: 0px; cursor: pointer; border: 0px; font: inherit; vertical-align: middle; color: rgb(0, 127, 255); appearance: none; box-sizing: content-box !important;\"><img id=\"hs-cta-img-54f20bf5-fd06-4e95-9e06-c8e0b1f90327\" class=\"hs-cta-img \" mce_noresize=\"1\" alt=\"6 tricks to create professional website\" height=\"400\" width=\"400\" src=\"https://www.webdew.com/hubfs/6-tricks-to-create-professional-website-1.svg\" loading=\"lazy\" style=\"margin: 15px 0px; padding: 0px; font: inherit; word-break: normal; border: 0px; vertical-align: baseline; max-width: 100%; height: auto; width: auto;\"></a></span></span></p><p style=\"margin: 30px 0px 0px; padding: 0px; font-size: 18px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 1.7; font-family: proxima_nova_rgregular; vertical-align: baseline; color: rgb(51, 71, 91); max-width: 100%; text-align: justify;\">Although not every user who visits your website will end up on your \"About Us\" page, you still need to make sure to attract those who click on the page. You can achieve this by having insightful, exciting content and ultimately makes them believe that they really need what you are offering.</p><p style=\"margin: 30px 0px 0px; padding: 0px; font-size: 18px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 1.7; font-family: proxima_nova_rgregular; vertical-align: baseline; color: rgb(51, 71, 91); max-width: 100%; text-align: justify;\">Your “About Us” page is a wonderful way to show your visitors who you are and provide them the confidence that you and your organization have the skills and expertise they need to solve their issues.&nbsp;</p><p style=\"margin: 30px 0px 0px; padding: 0px; font-size: 18px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 1.7; font-family: proxima_nova_rgregular; vertical-align: baseline; color: rgb(51, 71, 91); max-width: 100%; text-align: justify;\">Your A<span style=\"margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; font-size: inherit !important; color: inherit !important;\">bout Us page ideas</span>&nbsp;is where you create that first intimate bond with your prospective client. It\'s where they ascertain if you would understand them and if you\'re dependable. The more pleasant, personal, and convincing you are, the more likely it is that prospects will feel comfortable buying from you and becoming lifetime customers.</p><h2 style=\"margin: 45px 0px 25px; padding: 0px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 32px; line-height: normal; font-family: proxima_nova_rgbold; vertical-align: baseline; color: rgb(51, 71, 91);\"><span style=\"margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; font-size: 16px; line-height: inherit; font-family: inherit; vertical-align: baseline; color: inherit !important;\">Some Incredible About Us Page Examples</span></h2><p style=\"margin-right: 0px; margin-bottom: 0px; margin-left: 0px; padding: 0px; font-size: 18px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 1.7; font-family: proxima_nova_rgregular; vertical-align: baseline; color: rgb(51, 71, 91); max-width: 100%; text-align: justify;\">Nevertheless, creating an \"About Us\" page that precisely represents your organization can perhaps feel challenging than one might expect. You can consider several things you want your visitors to know, from your history to your achievements to your business values, yet filling all of that information on a single page can be overwhelming for you as well as your visitors.</p><p style=\"margin: 30px 0px 0px; padding: 0px; font-size: 18px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 1.7; font-family: proxima_nova_rgregular; vertical-align: baseline; color: rgb(51, 71, 91); max-width: 100%; text-align: justify;\">So how can you design a compelling \"About Us\" page by following the&nbsp;<span style=\"margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; font-size: inherit !important; color: inherit !important;\">About Us page best practices</span>&nbsp;that will show your visitors who you are and what you do? Indeed, there\'s no one-size-fits-all solution; however, there\'s no harm in looking at what other successful organizations are doing.&nbsp;</p><p><a href=\"https://www.webdew.com/blog/about-us-page-examples#\" id=\"title_1\" style=\"margin: 0px; padding: 0px; cursor: pointer; background-color: rgb(255, 255, 255); border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 18px; line-height: inherit; font-family: proxima_nova_rgregular; vertical-align: baseline; color: rgb(0, 127, 255);\"></a><a href=\"https://www.webdew.com/blog/about-us-page-examples#\" id=\"title_2\" style=\"margin: 0px; padding: 0px; cursor: pointer; background-color: rgb(255, 255, 255); border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; font-size: 18px; line-height: inherit; font-family: proxima_nova_rgregular; vertical-align: baseline; color: rgb(0, 127, 255);\"></a></p><p style=\"margin: 30px 0px 0px; padding: 0px; font-size: 18px; border: 0px; font-variant-numeric: inherit; font-variant-east-asian: inherit; font-stretch: inherit; line-height: 1.7; font-family: proxima_nova_rgregular; vertical-align: baseline; color: rgb(51, 71, 91); max-width: 100%; text-align: justify;\">So, have a look at these A<span style=\"margin: 0px; padding: 0px; border: 0px; font-style: inherit; font-variant: inherit; font-weight: inherit; font-stretch: inherit; line-height: inherit; font-family: inherit; vertical-align: baseline; font-size: inherit !important; color: inherit !important;\">bout Us page examples</span>&nbsp;of organizations who got it right.</p>', '', '', '', 1, '0000-00-00', 'Top');

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

--
-- Table structure for table `features_section`
--

CREATE TABLE `features_section` (
  `section_id` int(11) NOT NULL,
  `section_image` varchar(500) NOT NULL,
  `section_title` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `features_section`
--

INSERT INTO `features_section` (`section_id`, `section_image`, `section_title`) VALUES
(11, '/uploads/1720692391_e67acd4b9b9694e235bc.jpeg', 'Bridal hairstyle'),
(12, '/uploads/1720692479_d581ab04c9abc22dc533.jpeg', 'Bridal Make-up'),
(13, '/uploads/1720692726_c96d2ca9d7ba96f03638.jpeg', 'Horrible make-up');

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

--
-- Table structure for table `gallery`
--

CREATE TABLE `gallery` (
  `gallery_id` int(11) NOT NULL,
  `gallery_name` varchar(500) NOT NULL,
  `gallery_image` varchar(500) NOT NULL,
  `gallery_video` varchar(500) NOT NULL,
  `gallery_mode` int(1) NOT NULL DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `gallery`
--

INSERT INTO `gallery` (`gallery_id`, `gallery_name`, `gallery_image`, `gallery_video`, `gallery_mode`) VALUES
(2, 'hair', '/uploads/1728023553_2b350a66eea6d6c20929.jpeg', '', 1),
(3, 'Skin', '/uploads/1728023566_7771678aa902fa5c5bac.jpeg', '', 1),
(4, 'Video 1', '', 'https://youtu.be/Zd00oIDAt60', 2);

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

--
-- Table structure for table `heading_details`
--

CREATE TABLE `heading_details` (
  `heading_id` int(11) NOT NULL,
  `heading_course` varchar(500) NOT NULL,
  `heading_product` varchar(500) NOT NULL,
  `heading_package` varchar(500) NOT NULL,
  `heading_staff` varchar(500) NOT NULL,
  `heading_testimonial` varchar(500) NOT NULL,
  `heading_booking_form` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `heading_details`
--

INSERT INTO `heading_details` (`heading_id`, `heading_course`, `heading_product`, `heading_package`, `heading_staff`, `heading_testimonial`, `heading_booking_form`) VALUES
(1, 'What We Offer', 'Trending products', 'Our Best Price Packages', 'Our Excellent & Expert Staff', 'What Our Clients Feedback', 'Make An Appointment');

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

--
-- Table structure for table `home_banner`
--

CREATE TABLE `home_banner` (
  `banner_id` int(11) NOT NULL,
  `banner_image` varchar(500) NOT NULL,
  `banner_position` varchar(100) NOT NULL,
  `banner_name` varchar(500) NOT NULL,
  `banner_url` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home_banner`
--

INSERT INTO `home_banner` (`banner_id`, `banner_image`, `banner_position`, `banner_name`, `banner_url`) VALUES
(1, '/uploads/1654168342_171c2e68a0e17b26b7b9.png', 'Slider', 'Image 1', '#'),
(3, '/uploads/1654168755_62c1a7ff9bcd8c91c19d.png', 'Slider', 'Image 2', '#'),
(5, '/uploads/1650537466_aa3ce8e7a0a3328cdb6a.jpg', 'Exclusive Products', 'Image 3', ''),
(6, '/uploads/1650537511_d568f476706909009e53.jpg', 'Trending Products', 'Image 4', ''),
(7, '/uploads/1650537546_754420a50192928db2ff.jpg', 'Below Exclusive Products', 'Image 6', ''),
(8, '/uploads/1650537555_85a50bc3518ba0e695bb.jpg', 'Below Exclusive Products', 'Image 7', ''),
(9, '/uploads/1650537572_bf68e53467e10815cbb5.jpg', 'Below Exclusive Products', 'Image 8', ''),
(10, '/uploads/1650539702_728b6121614f1627a6a9.jpg', 'Below Trending Products', 'Image 8', ''),
(11, '/uploads/1650539902_430e513a14cc5beb61c4.jpg', 'Below Trending Products', 'Image 10', ''),
(12, '/uploads/1650539921_271edb973854b58a95bb.jpg', 'Below Trending Products', 'Image 11', ''),
(14, '/uploads/1653300451_31949ac72327016658c8.png', 'Header Top', 'Igg', '#');

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

--
-- Table structure for table `home_slider`
--

CREATE TABLE `home_slider` (
  `id` int(11) NOT NULL,
  `content_1` varchar(500) NOT NULL,
  `content_2` varchar(500) NOT NULL,
  `description` text NOT NULL,
  `btn_name` varchar(100) NOT NULL,
  `btn_link` varchar(500) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `home_slider`
--

INSERT INTO `home_slider` (`id`, `content_1`, `content_2`, `description`, `btn_name`, `btn_link`, `status`) VALUES
(5, 'Sakshi Hair & Beauty', 'Advanced makeup artistry education.', 'Sakshi Hair & Beauty is committed to providing unparalleled training that unleashes our students’ creative potential and champions artistic freedom and experimentation. A diploma or certificate from Sakshi Hair & Beauty means that you have the knowledge and skills needed to succeed in today’s makeup industry.', 'Learn More', '#', 1),
(6, 'Hair and Beauty Salon', 'Experience In Hair Care', 'Hair care is an overall term for hygiene and cosmetology involving the hair which grows from the human scalp and to a lesser extent facial, pubic, and other body hair. Hair care routines differ according to an individual\'s culture and the physical characteristics of one\'s hair.', '', '', 1);

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

--
-- Table structure for table `order`
--

CREATE TABLE `order` (
  `order_id` int(11) NOT NULL,
  `order_prd_id` int(11) NOT NULL,
  `order_qnty` int(11) NOT NULL,
  `order_varient` varchar(11) NOT NULL,
  `order_price` int(11) NOT NULL,
  `product_rate` int(11) NOT NULL,
  `order_payment_id` varchar(500) NOT NULL,
  `order_date` datetime DEFAULT NULL,
  `order_status` int(11) NOT NULL DEFAULT 0 COMMENT '0 == Pending, 1 == Accepted, 2 == Reject, 3 == Preparing, 4 == Dispatched, 5 == Delivered, 6 == Order Placed',
  `order_tracking_code` varchar(500) NOT NULL,
  `dealer_id` int(11) DEFAULT NULL,
  `dealer_order_id` varchar(500) NOT NULL,
  `paymen_method` int(1) NOT NULL DEFAULT 1 COMMENT '1 == ONLINE && 2 == Cheque && 3 == COD && 4 == Cash && 5 == UPI && 6 == Card',
  `payment_details` text NOT NULL,
  `varient_table` int(11) NOT NULL,
  `user_state` int(11) NOT NULL,
  `user_dist` int(11) NOT NULL,
  `user_taluka` int(11) NOT NULL,
  `user_role` varchar(20) NOT NULL,
  `gst_type` int(1) NOT NULL DEFAULT 1 COMMENT '1 == GST && 0 == Non GST',
  `tax_rate` int(11) NOT NULL,
  `tax_price` int(11) NOT NULL,
  `invoice_id` varchar(50) NOT NULL,
  `discount_amt` float NOT NULL,
  `discount_per` int(11) NOT NULL,
  `stock_point_id` int(11) NOT NULL,
  `shipping_charge` int(11) DEFAULT NULL,
  `order_note` text NOT NULL,
  `is_admin_order` int(1) NOT NULL DEFAULT 1,
  `address_id` int(11) NOT NULL,
  `reject_note` text NOT NULL,
  `due_amount` int(11) NOT NULL,
  `delivery_boy` int(11) NOT NULL,
  `delivery_code` varchar(500) NOT NULL,
  `admin_paid_amount` int(11) NOT NULL,
  `admin_expanse_amount` int(11) NOT NULL,
  `admin_paid_comment` text NOT NULL,
  `admin_paid_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `order`
--

INSERT INTO `order` (`order_id`, `order_prd_id`, `order_qnty`, `order_varient`, `order_price`, `product_rate`, `order_payment_id`, `order_date`, `order_status`, `order_tracking_code`, `dealer_id`, `dealer_order_id`, `paymen_method`, `payment_details`, `varient_table`, `user_state`, `user_dist`, `user_taluka`, `user_role`, `gst_type`, `tax_rate`, `tax_price`, `invoice_id`, `discount_amt`, `discount_per`, `stock_point_id`, `shipping_charge`, `order_note`, `is_admin_order`, `address_id`, `reject_note`, `due_amount`, `delivery_boy`, `delivery_code`, `admin_paid_amount`, `admin_expanse_amount`, `admin_paid_comment`, `admin_paid_date`) VALUES
(511, 47, 1, '64', 150, 0, '', '2022-08-29 04:41:43', 5, 'TC244120220829', 544, '202208291412', 3, '', 82, 0, 0, 0, 'User', 1, 5, 8, '20221001', 0, 0, 0, 0, '', 0, 10, '', 0, 0, '', 0, 0, '', NULL),
(512, 47, 1, '64', 150, 0, '', '2022-09-01 08:52:07', 0, 'TC487120220901', 530, '202209018967', 3, '', 82, 0, 0, 0, 'User', 1, 5, 8, '20221002', 0, 0, 0, 0, '', 0, 11, '', 0, 0, '', 0, 0, '', NULL),
(513, 52, 4, '78, 75', 1200, 0, '', '2024-07-04 03:23:14', 0, 'TC949920240704', 545, '202407041775', 3, '', 87, 0, 0, 0, 'User', 1, 0, 0, '20241003', 0, 0, 0, 0, '', 0, 12, '', 0, 0, '', 0, 0, '', NULL);

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

--
-- Table structure for table `order_status`
--

CREATE TABLE `order_status` (
  `id` int(11) NOT NULL,
  `order_status_user_id` int(11) NOT NULL,
  `order_status_invoice_id` varchar(500) NOT NULL,
  `order_status` varchar(500) NOT NULL,
  `order_status_comment` text NOT NULL,
  `order_status_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `order_status`
--

INSERT INTO `order_status` (`id`, `order_status_user_id`, `order_status_invoice_id`, `order_status`, `order_status_comment`, `order_status_date`) VALUES
(451, 544, '202208291412', '6', '', '2022-08-29 04:41:43'),
(452, 544, '202208291412', '0', '', '2022-08-29 04:41:43'),
(453, 530, '202209018967', '6', '', '2022-09-01 08:52:07'),
(454, 530, '202209018967', '0', '', '2022-09-01 08:52:07'),
(455, 545, '202407041775', '6', '', '2024-07-04 03:23:14'),
(456, 545, '202407041775', '0', '', '2024-07-04 03:23:14'),
(457, 544, '202208291412', '1', '', '2024-08-29 01:38:25'),
(458, 544, '202208291412', '0', '', '2024-08-29 01:38:40'),
(459, 544, '202208291412', '1', '', '2024-08-29 01:38:53'),
(460, 544, '202208291412', '3', '', '2024-08-29 01:38:58'),
(461, 544, '202208291412', '4', '', '2024-08-29 01:43:45'),
(462, 544, '202208291412', '5', '', '2024-08-29 01:43:57');

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

--
-- Table structure for table `our_staff`
--

CREATE TABLE `our_staff` (
  `staff_id` int(11) NOT NULL,
  `staff_name` varchar(500) NOT NULL,
  `staff_position` varchar(500) NOT NULL,
  `staff_image` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `our_staff`
--

INSERT INTO `our_staff` (`staff_id`, `staff_name`, `staff_position`, `staff_image`) VALUES
(1, 'Lorenzo Diego', 'Nail Specialist', '/uploads/1661760492_62801e8d0142844d6bde.jpg'),
(2, ' Gabriele Edoardo', 'Senior Stylist', '/uploads/1661760521_9838fc66f3ba06305ccd.jpg'),
(4, 'Matteo Lorenzo	', 'Pedicure Specialist', '/uploads/1661763870_0a8045c74d81e131e9ee.jpg');

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

--
-- Table structure for table `product`
--

CREATE TABLE `product` (
  `prd_id` int(11) NOT NULL,
  `prd_code` varchar(255) DEFAULT NULL,
  `prd_code_for_n` varchar(500) NOT NULL,
  `prd_hsn` varchar(50) NOT NULL,
  `prd_tax` int(11) NOT NULL,
  `prd_name` varchar(255) DEFAULT NULL,
  `prd_slug` varchar(255) NOT NULL,
  `prd_category` varchar(11) DEFAULT NULL,
  `prd_sub_category` int(11) NOT NULL,
  `prd_child_category` int(11) NOT NULL,
  `prd_brand` int(11) NOT NULL,
  `prd_details` text DEFAULT NULL,
  `prd_unit` varchar(20) DEFAULT NULL,
  `prd_seo_keyword` text NOT NULL,
  `prd_seo_description` text NOT NULL,
  `prd_description` text DEFAULT NULL,
  `prd_specifications` text DEFAULT NULL,
  `prd_today_delas` int(1) NOT NULL DEFAULT 0,
  `prd_today_delas_price` int(11) NOT NULL,
  `prd_today_deal_from` datetime NOT NULL,
  `prd_today_deal_to` datetime NOT NULL,
  `prd_flash_delas` int(1) NOT NULL DEFAULT 0,
  `prd_flash_delas_price` int(11) NOT NULL,
  `prd_flash_deal_from` datetime NOT NULL,
  `prd_flash_deal_to` datetime NOT NULL,
  `prd_onsale` int(11) NOT NULL DEFAULT 0,
  `prd_supplier_name` varchar(255) DEFAULT NULL,
  `prd_comission_category` int(1) NOT NULL DEFAULT 1 COMMENT '1 is percentage & 2 in amount',
  `prd_comission_amount` int(11) DEFAULT NULL,
  `prd_default_image` varchar(500) DEFAULT NULL,
  `prd_status` int(1) DEFAULT 1,
  `prd_date` datetime DEFAULT NULL,
  `prd_total_sales` int(11) NOT NULL,
  `prd_total_visit` int(11) NOT NULL,
  `prd_refund_status` int(1) NOT NULL DEFAULT 0,
  `prd_refund_days` int(11) NOT NULL,
  `prd_return_status` int(1) NOT NULL DEFAULT 0,
  `prd_return_days` int(11) NOT NULL,
  `prd_cod` int(1) NOT NULL DEFAULT 0,
  `prd_length` float NOT NULL,
  `prd_breadth` float NOT NULL,
  `prd_height` float NOT NULL,
  `prd_weight` float NOT NULL,
  `show_feature` int(1) DEFAULT 0,
  `special` int(1) NOT NULL DEFAULT 0,
  `prd_low_stock` int(11) NOT NULL,
  `prd_delivery_commission` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `product`
--

INSERT INTO `product` (`prd_id`, `prd_code`, `prd_code_for_n`, `prd_hsn`, `prd_tax`, `prd_name`, `prd_slug`, `prd_category`, `prd_sub_category`, `prd_child_category`, `prd_brand`, `prd_details`, `prd_unit`, `prd_seo_keyword`, `prd_seo_description`, `prd_description`, `prd_specifications`, `prd_today_delas`, `prd_today_delas_price`, `prd_today_deal_from`, `prd_today_deal_to`, `prd_flash_delas`, `prd_flash_delas_price`, `prd_flash_deal_from`, `prd_flash_deal_to`, `prd_onsale`, `prd_supplier_name`, `prd_comission_category`, `prd_comission_amount`, `prd_default_image`, `prd_status`, `prd_date`, `prd_total_sales`, `prd_total_visit`, `prd_refund_status`, `prd_refund_days`, `prd_return_status`, `prd_return_days`, `prd_cod`, `prd_length`, `prd_breadth`, `prd_height`, `prd_weight`, `show_feature`, `special`, `prd_low_stock`, `prd_delivery_commission`) VALUES
(47, '630c9466e21c2', '6896', '123', 5, 'Hair & Care with Aloe Vera Olive Oil & Green Tea Damage Repair Non-Sticky Hair Oil', 'hair-amp-care-with-aloe-vera-olive-oil-amp-green-tea-damage-repair-non-sticky-hair-oil', '283', 288, 0, 12, '<ul class=\"a-unordered-list a-vertical a-spacing-mini\" style=\"margin-right: 0px; margin-bottom: 0px; margin-left: 18px; color: rgb(15, 17, 17); padding: 0px; font-family: &quot;Amazon Ember&quot;, Arial, sans-serif; font-size: 14px;\"><li style=\"list-style: disc; overflow-wrap: break-word; margin: 0px;\"><span class=\"a-list-item\">Repair upto 100 percent hair damage with New Hair and Care triple blend Damage Repair Oil enriched with Aloe Vera, Olive Oil and Green tea</span></li><li style=\"list-style: disc; overflow-wrap: break-word; margin: 0px;\"><span class=\"a-list-item\">Cares for dry, frizzy &amp; rough hair. Helps repair these signs of damage to give soft, smooth and bouncy hair. Repairs damage caused by styling heat, colouring, chemicals, pollution, sun and hard water</span></li><li style=\"list-style: disc; overflow-wrap: break-word; margin: 0px;\"><span class=\"a-list-item\">Olive oil, known to be rich in Vitamin E and antioxidants, moisturises hair, and prevents scalp irritation, giving strong and nourished hair</span></li><li style=\"list-style: disc; overflow-wrap: break-word; margin: 0px;\"><span class=\"a-list-item\">Aloe Vera soothes itchy scalp, reduces dryness, deep conditions the hair and protects it from sun damage thus leaving your hair soft, smooth and shiny hair</span></li><li style=\"list-style: disc; overflow-wrap: break-word; margin: 0px;\"><span class=\"a-list-item\">Green tea, rich in anti-fungal and anti-inflammatory properties, improves hair health and adds shine to damaged, dyed and chemically treated hair</span></li><li style=\"list-style: disc; overflow-wrap: break-word; margin: 0px;\"><span class=\"a-list-item\">Straight, curly, thin, thick, fine, textured hair - this light &amp; non-sticky hair oil is suitable for all hair types. Can also be used for after hair wash styling</span></li></ul>', 'Pcs', '', '', '<div id=\"detailBullets_feature_div\" style=\"color: rgb(15, 17, 17); font-family: &quot;Amazon Ember&quot;, Arial, sans-serif; font-size: 14px;\"><ul class=\"a-unordered-list a-nostyle a-vertical a-spacing-none detail-bullet-list\" style=\"margin-right: 0px; margin-bottom: 1px; margin-left: 18px; padding: 0px;\"><li style=\"list-style: none; overflow-wrap: break-word; margin: 0px 0px 5.5px;\"><span class=\"a-list-item\"><span class=\"a-text-bold\" style=\"font-weight: 700 !important;\">Is Discontinued By Manufacturer ‏ : ‎&nbsp;</span>No</span></li><li style=\"list-style: none; overflow-wrap: break-word; margin: 0px 0px 5.5px;\"><span class=\"a-list-item\"><span class=\"a-text-bold\" style=\"font-weight: 700 !important;\">Package Dimensions ‏ : ‎&nbsp;</span>21.9 x 8.4 x 5.6 cm; 285.76 Grams</span></li><li style=\"list-style: none; overflow-wrap: break-word; margin: 0px 0px 5.5px;\"><span class=\"a-list-item\"><span class=\"a-text-bold\" style=\"font-weight: 700 !important;\">Date First Available ‏ : ‎&nbsp;</span>12 April 2013</span></li><li style=\"list-style: none; overflow-wrap: break-word; margin: 0px 0px 5.5px;\"><span class=\"a-list-item\"><span class=\"a-text-bold\" style=\"font-weight: 700 !important;\">Manufacturer ‏ : ‎&nbsp;</span>Marico</span></li><li style=\"list-style: none; overflow-wrap: break-word; margin: 0px 0px 5.5px;\"><span class=\"a-list-item\"><span class=\"a-text-bold\" style=\"font-weight: 700 !important;\">ASIN ‏ : ‎&nbsp;</span>B008DY631U</span></li><li style=\"list-style: none; overflow-wrap: break-word; margin: 0px 0px 5.5px;\"><span class=\"a-list-item\"><span class=\"a-text-bold\" style=\"font-weight: 700 !important;\">Item model number ‏ : ‎&nbsp;</span>706563</span></li><li style=\"list-style: none; overflow-wrap: break-word; margin: 0px 0px 5.5px;\"><span class=\"a-list-item\"><span class=\"a-text-bold\" style=\"font-weight: 700 !important;\">Manufacturer ‏ : ‎&nbsp;</span>Marico</span></li><li style=\"list-style: none; overflow-wrap: break-word; margin: 0px 0px 5.5px;\"><span class=\"a-list-item\"><span class=\"a-text-bold\" style=\"font-weight: 700 !important;\">Item Weight ‏ : ‎&nbsp;</span>286 g</span></li><li style=\"list-style: none; overflow-wrap: break-word; margin: 0px 0px 5.5px;\"><span class=\"a-list-item\"><span class=\"a-text-bold\" style=\"font-weight: 700 !important;\">Net Quantity ‏ : ‎&nbsp;</span>300.0 millilitre</span></li></ul></div><ul class=\"a-unordered-list a-nostyle a-vertical a-spacing-none detail-bullet-list\" style=\"margin-right: 0px; margin-bottom: 1px; margin-left: 18px; color: rgb(15, 17, 17); padding: 0px; font-family: &quot;Amazon Ember&quot;, Arial, sans-serif; font-size: 14px;\"><li style=\"list-style: none; overflow-wrap: break-word; margin: 0px 0px 5.5px;\"><span class=\"a-list-item\"><span class=\"a-text-bold\" style=\"font-weight: 700 !important;\">Best Sellers Rank:&nbsp;</span>#1,109 in Beauty (<a href=\"https://www.amazon.in/gp/bestsellers/beauty/ref=pd_zg_ts_beauty\" style=\"color: rgb(0, 113, 133);\">See Top 100 in Beauty</a>)<ul class=\"a-unordered-list a-nostyle a-vertical zg_hrsr\" style=\"margin-right: 0px; margin-left: 14px; padding: 0px;\"><li style=\"list-style: none; overflow-wrap: break-word; margin: 0px 0px 5.5px;\"><span class=\"a-list-item\">#52 in&nbsp;<a href=\"https://www.amazon.in/gp/bestsellers/beauty/3507139031/ref=pd_zg_hrsr_beauty\" style=\"color: rgb(0, 113, 133);\">Hair Oils</a></span></li></ul></span></li></ul>', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1661768806_d8dc245df8e725ed885d.jpg', 1, '2022-08-29 03:56:46', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0),
(48, '6325bd5da3480', '1788', '111', 0, 'Fiber Strong Strengthening Shampoo', 'fiber-strong-strengthening-shampoo', '299', 301, 0, 15, '<p>Fragile hair is easily damaged and prone to breakage and needs a gentle yet effective hair breakage remedy that not only cleanses the hair but also fortifies the hair fibres. The Matrix Biolage Fiberstrong Strengthening Shampoo gently cleanses your scalp and hair and also reinforces strength and elasticity in your hair for healthy, shiny, and resilient hair.<br></p>', '400', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1663417693_07a756cbb2cbf95ac210.jpg', 1, '2022-09-17 05:58:13', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0),
(49, '6327ff824f49c', '1594', '112', 0, 'RepairInside Repairing Shampoo', 'repairinside-repairing-shampoo', '299', 301, 0, 15, '<p>Dry, frizzy, and rough hair often lead to you having a bad hair day, but not anymore. With a shampoo for damaged hair, you can repair the damage. The Matrix Biolage Advanced Repair Inside Shampoo is a protein shampoo that repairs hair damage, brings the gloss, and shines back.<br></p>', '400', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1663565698_553e86d384f318a69ea9.jpg', 1, '2022-09-19 11:04:58', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0),
(50, '6328001d6d09e', '7539', '111', 0, 'Sculpture Dandruff Control Shampoo', 'sculpture-dandruff-control-shampoo', '299', 301, 0, 15, '<p>Shampoos targeting your dandruff often strip your scalp making your hair very dry and frizzy. But with the Matrix Biolage advance sculpture dandruff shampoo, you can have a dandruff-free scalp and nourished hair. The Matrix shampoo is a great dandruff solution that not only deeply cleanses your flaky scalp but also leaves your hair feeling soft and shiny.<br></p>', '400', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1663565853_247ecd7c543f3e646984.jpg', 1, '2022-09-19 11:07:33', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0),
(51, '63280071bd54c', '3729', '111', 0, 'Smoothproof Smoothing Shampoo', 'smoothproof-smoothing-shampoo', '299', 301, 0, 15, '<p>Most shampoos are laden with chemicals that can make your frizzy hair even more dry and unmanageable. The Matrix Biolage Smoothproof Smoothing Shampoo not only cleanses your locks but also intensely smooths and moisturizes your hair to tame frizzy, unruly hair.<br></p>', '400', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1663565937_42ee1b6195a8ba481e4b.jpg', 1, '2022-09-19 11:08:57', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0),
(52, '63280253c6415', '3517', '111', 0, 'Fiberstrong Strengthening Conditioner', 'fiberstrong-strengthening-conditioner', '299', 302, 0, 15, '<p>Fragile hair is hair that is brittle, lacks shine, and is prone to breakage. Prevent hair breakage and moisturize and detangle your hair with the Matrix Biolage Fiberstrong Strengthening Conditioner.<br></p>', '400', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1663566419_da5d41deb79089b7742c.jpg', 1, '2022-09-19 11:16:59', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0),
(53, '632802dc8fb0e', '3317', '111', 0, 'RepairInside Repairing Conditioner', 'repairinside-repairing-conditioner', '299', 302, 0, 15, '<p>Is your hair currently looking dull, dry, and frizzy? These could be signs of severely damaged hair. It’s time to change that and bring the gloss and shine back to your hair with the Matrix Conditioner for severely damaged hair. It is a protein treatment that helps repair the damaged hair protein.<br></p>', '400', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1663566556_ee2ac9552d43c09887b3.jpg', 1, '2022-09-19 11:19:16', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0),
(54, '632803816a3c7', '1745', '111', 0, 'Sculpture Complete Solution Conditioner', 'sculpture-complete-solution-conditioner', '299', 302, 0, 15, '<p>A flaky scalp along with frizzy and dry hair can create mayhem for the health of your hair. It’s time to deal with these hair anomalies and combat frizz, dry hair and an itchy scalp. The Matrix Biolage Sculpture Complete Solution Conditioner is a dandruff solution that is here to your rescue. This Matrix Biolage Conditioner is a multi-correction solution for 72 hours of scalp and hair balance.<br></p>', '400', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1663566721_1abeed9ee159fa61b690.jpg', 1, '2022-09-19 11:22:01', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0),
(55, '632808519c940', '2146', '111', 0, 'Smoothproof Smoothing Conditioner', 'smoothproof-smoothing-conditioner', '299', 302, 0, 15, '<p>Frizzy and unruly hair is not easy to manage, and add to it a humid weather and taming your locks becomes a even more difficult. Detangle, de-frizz, and defend your hair against humidity with the Matrix Biolage Smoothproof Smoothing Conditioner. The Matrix conditioner keeps your hair manageably smooth and deeply conditions your hair to keep it perfectly smooth for up to 72 hours.<br></p>', '400', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1663567953_336a9d0e94cced5e8f6b.jpg', 1, '2022-09-19 11:42:33', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0),
(56, '632809b24c245', '8503', '111', 0, 'Fiberstrong Strengthening Leave-In Cream', 'fiberstrong-strengthening-leave-in-cream', '299', 303, 0, 15, '<p>Fragile hair is dry and rough to the touch, lacks a healthy shine and bounce, and is difficult to manage. The Biolage Fiberstrong Strengthening Leave-In Cream is an advanced formula that is created to target fragile hair to strengthen it and reduce hair fall due to breakage.<br></p>', '400', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1663568306_6d33b75778d20203d525.jpg', 1, '2022-09-19 11:48:26', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0),
(58, '63280c2c89362', '1661', '111', 0, 'RepairInside Repairing Leave-In Cream', 'repairinside-repairing-leave-in-cream', '299', 303, 0, 15, '<p>Along with regular shampoo and conditioning, severely damaged hair requires extra love and care. The Matrix Biolage Repairinside leave in conditioner provides your hair with added nourishment and repairs the damage.<br></p>', '400', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1663568940_0f646131132e58e395db.jpg', 1, '2022-09-19 11:59:00', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0),
(59, '632812b98c6c3', '9063', '111', 0, 'Matrix LightMaster', 'matrix-lightmaster', '300', 304, 0, 15, '<p>The Matrix Light Master is a powerful, high-speed hair lightener that creates a higher lift, even on the scalp, and a maximum lift of up to 8 levels. The Matrix hair lightener is more soluble and so it enables a faster release of oxygen to lighten at a quick, yet controlled pace, while perfectly balanced lightening helps avoid warm yellow under tones.<br></p>', '200', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1663570617_0848e5cebafe222c42fe.jpg', 1, '2022-09-19 12:26:57', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0),
(61, '6328146130a8e', '4694', '111', 0, 'Matrix Wonder Color', 'matrix-wonder-color', '300', 305, 0, 15, '<p>Wonder Color Ammonia Free is a nourishing, long-lasting ammonia free hair color designed to deliver even, true to tone color results<br></p>', '400', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, NULL, 1, '2022-09-19 12:34:01', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0),
(62, '632814af3e06a', '7052', '111', 0, 'Matrix Oxydant', 'matrix-oxydant', '300', 306, 0, 15, '<p>Give your hair the various levels of lift or deposit you require with Matrix Oxydant hair color developers. The Matrix cream oxidant is available in three different strengths for different purposes of lightening and deposition. Matrix developer is a quality peroxide that is optimized to get the best out of Matrix SoColor, Wonder Brown, Wonder Color, Wonder Red, and So Red.<br></p>', '200', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1663571119_3c0159da20677c33062c.jpg', 1, '2022-09-19 12:35:19', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0),
(63, '6328152f7bb01', '7302', '111', 0, 'Matrix SoColor', 'matrix-socolor', '300', 307, 0, 15, '<p>SoColor Pre-Bonded, a permanent hair color that protects the inner hair structure color after color. It enters deepest levels to provide the most true-to-tone fashion results while safeguarding the hair integrity. Choose from a wide palette of 40 shades!</p><p>Be it cool or warm, get consistent results every time on any hair type!</p><p><br></p><p><br></p><p><br></p><p><br></p><p>SoColor Pre-Bonded, a permanent hair color that protects the inner hair structure color after color. It enters deepest levels to provide the most true-to-tone fashion results while safeguarding the hair integrity. Choose from a wide palette of 40 shades!</p><p>Be it cool or warm, get consistent results every time on any hair type!</p><p>SoColor Pre-Bonded is a permanent hair color that protects the inner hair structure color after color. It enters the deepest levels to provide the most true-to-tone fashion results while safeguarding hair integrity. Choose from a wide palette of 40 shades!&nbsp;<span style=\"font-size: 1rem;\">Be it cool or warm, get consistent results every time on any hair type!</span></p><p><br></p><p><br></p><p><br></p><p><br></p><p><br></p>', '200', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1663571247_8d55f67bb28daaac87c4.jpg', 1, '2022-09-19 12:37:27', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 10, 0),
(64, '636648e6e5774', '7337', '111', 0, 'Professional Nourishing Leave-in', 'professional-nourishing-leave-in', '299', 303, 0, 15, '<p>Tangled hair and split ends keeping you away from the hair of your dreams? Discover the professional solution for long and nourished hair, the Matrix Opti Long Nourish Protect Leave-in Cream. The nourishing treatment provides strength and nourishment to the hair fibber\'s and protects your hair from split ends so you can reveal long healthy hair<br></p>', '400', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667647718_2ae6fd3a75e58f9caedd.jpg', 1, '2022-11-05 04:58:38', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(65, '6366545b72767', '6897', '111', 0, 'Fiberstrong Masque', 'fiberstrong-masque', '299', 308, 0, 15, '<p>Damaged and fragile hair needs extra care and nourishment. Treat your locks to a deep condition with the Matrix Biolage Fiberstrong Masque, a hair pack for hair fall that repairs fragile and mechanically damaged hair.<br></p>', '400', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667650651_3d0c459c5da53b040a32.jpg', 1, '2022-11-05 05:47:31', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(66, '6366553270cc9', '7027', '111', 0, 'RepairInside Repairing Masque', 'repairinside-repairing-masque', '299', 308, 0, 15, '<p>If your hair is looking dull, dry, damaged and rough it is time to give it some extra pampering. The Matrix Biolage RepairInside Masque is a hair masque for damaged hair. With this Matrix hair masque, you can deeply nourish your hair and repair your damaged hair.<br></p>', '400', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667650866_a69d9dbc05337105ad82.jpg', 1, '2022-11-05 05:51:06', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(67, '636655a575a1d', '3240', '111', 0, 'Smoothproof Smoothing Biospa Masque', 'smoothproof-smoothing-biospa-masque', '299', 308, 0, 15, '<p>Extremely rough and frizzy hair needs an intense dose of nourishment to replenish the hair fibres and restore the shine, smoothness, and softness. Control rebellious frizz and enjoy smooth and polished hair with long lasting frizz control with the Matrix Biolage Smoothproof Smoothing Biospa Masque.<br></p>', '200', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667650981_29c8b70dde829ccd17ef.jpg', 1, '2022-11-05 05:53:01', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(68, '6366561a845cb', '8863', '111', 0, 'Ultra-Hydrasource-Hydrating-Masque', 'ultra-hydrasource-hydrating-masque', '299', 308, 0, 15, '<p>Dry and damaged hair looks dull, is more prone to breakage, and can become very difficult to manage. Treatments for dry hair restore the moisture and nutrients in lifeless hair and improve the overall look and feel of your locks. Give your dry hair a boost of nourishment with the Matrix Biolage Ultra Hydrasource Masque.</p>', '400', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667651098_e1ee76eda5e427e87292.jpg', 1, '2022-11-05 05:54:58', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(69, '63665695857de', '3845', '111', 0, 'Colorlast Color-Protecting Biospa Masque', 'colorlast-color-protecting-biospa-masque', '299', 308, 0, 15, '<p>Color-treated hair often needs intense moisturization to help maintain its tone and color. Inspired by nature\'s fade-defying orchid, this hair masque by Biolage COLORLAST helps maintain the color depth, tone and shine for vivid color-treated hair.&nbsp;<br></p>', '200', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667651221_cc3f61b1c624be65cd1a.jpg', 1, '2022-11-05 05:57:01', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(70, '636656ee344eb', '7984', '111', 0, 'Professional Ultra Smoothing Masque', 'professional-ultra-smoothing-masque', '299', 308, 0, 15, '<p>Chemically straightened hair needs special care to maintain its smoothness and shine. The Matrix Opti Care Smooth Straight Professional Ultra Smoothing Masque is a masque for chemically treated hair that nourishes and protects your hair to give you silky, shiny, frizz-free and healthy-looking locks.<br></p>', '400', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667651310_eee11bacc428dc8839bd.jpg', 1, '2022-11-05 05:58:30', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(71, '63665775817da', '7294', '111', 0, 'Professional Nourishing Masque', 'professional-nourishing-masque', '299', 308, 0, 15, '<p>Tangled hair and split ends keeping you away from the hair of your dreams? Discover the professional solution for long and nourished hair, the Matrix Opti Long Nourish Professional Nourishing Masque. The deep conditioning treatment acts as a split ends solution and provides strength and nourishment to the hair fibers so you can reveal long healthy hair</p><div><br></div>', '400', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667651445_ba5d256dc78ab58dc24c.jpg', 1, '2022-11-05 06:00:45', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(72, '636668e65a71a', '4803', '111', 0, 'Ultra-Hydrasource-Cera-Vital-Repair', 'ultra-hydrasource-cera-vital-repair', '299', 309, 0, 15, '<p>Damaged hair when left untreated can give rise to a host of other hair problems like hair fall and breakage. Give your hair a professional damaged hair treatment with the Matrix Biolage Hydrasource Cera Vital Repair. The paraben free formula of the concentrated hair repair treatment restores and revives damaged and stressed hair.<br></p>', '400', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667655910_64091b15c1f39e4d8bf6.webp', 1, '2022-11-05 07:15:10', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(73, '63666935b47c4', '7381', '111', 0, 'Professional Intense Smoothing Booster Dose', 'professional-intense-smoothing-booster-dose', '299', 309, 0, 15, '<p>Is your hair feeling rough and dry lately? Give your chemically treated hair an additional booster dose of nourishment with Matrix hair care. The Matrix Professional Opti Care Intense Smoothing Booster Dose is a scalp tonic that gives intense Ceramide treatment to add smoothness and softness to chemically straightened or smoothened hair.<br></p>', '400', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667655989_10baf8b8243af9fce7e3.jpg', 1, '2022-11-05 07:16:29', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(74, '6368bf9314f74', '5154', '111', 0, 'Scalp pure Complete Solution Scalp Serum', 'scalp-pure-complete-solution-scalp-serum', '299', 310, 0, 15, '<p>Is your hair looking frizzy, dull, and dry? Revive your hair with the Matrix hair serum and make your hair soft and manageable. The Matrix Biolage Scalppure Serum is a one-of-a-kind serum that helps you with dandruff control. It also helps you control your flyaway and makes your hair manageable and smooth.<br></p>', '200', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667809171_8b5950f2f719568a2357.jpg', 1, '2022-11-07 01:49:31', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(75, '6368d28bb61e9', '5638', '111', 0, 'Deep Smoothing Serum', 'deep-smoothing-serum', '299', 310, 0, 15, '<p>Frizzy, rough, dull, tangled, and unmanageable hair bringing you down?&nbsp;</p><p>Restore your hair’s shine and smoothness and tame unruly hair and flyaways with the Matrix Biolage Smoothproof Serum.</p><p>The frizz control serum is the perfect quick-fix solution for those who have trouble battling frizzy hair that cannot be tamed</p>', '100', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667814027_a5adb67013c85d60bef0.jpg', 1, '2022-11-07 03:10:27', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(76, '6368d49648189', '9692', '111', 0, ' Professional Split End Serum', 'professional-split-end-serum', '299', 310, 0, 15, '<p>Chemically straightened hair can be a challenge to deal with. Maintain the soft, silky, and shiny hair of your dreams with the Optic-are Professional Split End Serum. The Matrix hair serum repairs frayed tips and split ends in chemically straightened or smoothed hair.<br></p>', '100', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667814550_20d50f4690a0661cd0ef.jpg', 1, '2022-11-07 03:19:10', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(77, '6368d6cab3cc0', '8730', '111', 0, 'Professional Ultra Smoothing Shampoo', 'professional-ultra-smoothing-shampoo', '299', 301, 0, 15, '<p>Chemically straightened hair can be a challenge to deal with. Maintain the soft, silky, and shiny hair of your dreams with the Opti Care Smooth Straight Ultra Smoothing Shampoo. The Matrix shampoo gently cleanses and moisturizes smoothened or straightened hair and improves your hair’s manageability.<br></p>', '100', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667815114_a60c1b4f55a832f844fd.jpg', 1, '2022-11-07 03:28:34', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(78, '6368d834bb579', '8519', '111', 0, 'Ultra-Hydrasource-Hydrating-Shampoo', 'ultra-hydrasource-hydrating-shampoo', '299', 301, 0, 15, '<p>Lack of shine, roughness, frizzy, and brittle – these are some signs of damaged hair. Breathe life into dry and damaged hair with the Matrix Biol-age Hydra-source Ultra Hydrating Shampoo. The Biol age shampoo for dry hair quenches your thirst for beautiful, healthy hair and adds moisture to damaged hair that is dehydrated from sun and heat styling tools.<br></p>', '100', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667815476_711a4ba4dccc2ea282db.jpg', 1, '2022-11-07 03:34:36', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(79, '6368d966d3800', '8432', '111', 0, 'Colorlast Color-Protecting Shampoo', 'colorlast-color-protecting-shampoo', '299', 301, 0, 15, '<p><span style=\"font-size: 1rem;\">Color-treated hair can fade and lose its luster over time. Inspired by nature\'s fade-defying orchid, The Matrix </span>Biol age<span style=\"font-size: 1rem;\">&nbsp;COLOR LAST Shampoo helps maintain the color depth, tone, and shine for vivid color-treated hair. Give your hair salon-vibrant color for up to 9 weeks*.</span><br></p>', '100', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667815782_c4f57c983f1c730b3cf4.jpg', 1, '2022-11-07 03:39:42', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(80, '6368d966e709f', '8432', '111', 0, 'Colorlast Color-Protecting Shampoo', 'colorlast-color-protecting-shampoo', '299', 301, 0, 15, '<p><span style=\"font-size: 1rem;\">Color-treated hair can fade and lose its luster over time. Inspired by nature\'s fade-defying orchid, The Matrix </span>Biol age<span style=\"font-size: 1rem;\">&nbsp;COLOR LAST Shampoo helps maintain the color depth, tone, and shine for vivid color-treated hair. Give your hair salon-vibrant color for up to 9 weeks*.</span><br></p>', '100', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667815782_9d7054ba4d1082ff27e7.jpg', 1, '2022-11-07 03:39:42', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(81, '6368da6cbcb6d', '2678', '111', 0, 'Heat Buffer Thermal Styling Spray', 'heat-buffer-thermal-styling-spray', '312', 313, 0, 15, '<p><span style=\"font-size: 1rem;\">Worried about heat damage every time you style your hair? Well, not anymore. With the Matrix Heat Buffer Thermal Styling spray, it is time to keep heat damage at bay. This light hold, fine mist provides heat protection to your luscious locks. This heat protectant spray shields your hair for up to 450F/232C.</span><br></p>', '200', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667816044_af8c5154493c0ce7af1a.jpg', 1, '2022-11-07 03:44:04', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(82, '6368dafee66db', '7959', '111', 0, 'Professional Nourishing Shampoo', 'professional-nourishing-shampoo', '299', 301, 0, 15, '<p><font color=\"#000000\" face=\"montregular\">Tangled hair and split ends keeping you away from the hair of your dreams? Discover the professional solution for long and nourished hair, the Matrix Optic&nbsp;Long Nourish Protect Shampoo. The nourishing shampoo gently cleanses and removes excessive oil build-up from the scalp and helps long hair with a healthy and moisturized feel.</font><br></p>', '100', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667816190_da3e35ddcd6e10a1a96c.jpg', 1, '2022-11-07 03:46:30', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(83, '6368db77301cb', '5694', '111', 0, 'Volume Builder Mousse', 'volume-builder-mousse', '312', 313, 0, 15, '<p>Does your hair lack the oomph factor and fall flat after styling it? The Matrix StyleLink Volume Builder Mousse helps you add definition and volume to your limp hair. This Matrix mousse is a great styling product for people with wavy and curly hair. This Matrix product has light to medium hold and is a great curl mousse that adds volume and shine to your hair while keeping them natural looking.<br></p>', '200', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667816311_7d321527043c59c7e8bf.jpg', 1, '2022-11-07 03:48:31', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(84, '6368dbd371200', '2049', '111', 0, 'Matte Definer Beach Clay', 'matte-definer-beach-clay', '312', 313, 0, 15, '<p>Beautiful, textured hair looks great and adds a lot of volume to your hair and look. However, it can get a little tricky to achieve perfectly textured hair. Not anymore, with this Matrix product, you can add choppy texture and definition to your luscious locks. The Matrix matter definer beach clay is a medium to strong hold product that helps you texturize your hair.<br></p>', '200', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667816403_03491eef99a446b626b8.jpg', 1, '2022-11-07 03:50:03', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(85, '6368dc2eb4d7c', '2533', '111', 0, 'Super Fixer Strong Hold Gel', 'super-fixer-strong-hold-gel', '312', 313, 0, 15, '<p>After spending hours on perfecting a hairstyle, it can be quite disappointing when it doesn’t stay in place for too long. With the Matrix Super Fixer Strong Hold Gel, you can now set your hairstyle in place without making your hair crunchy. This hair gel provides maximum hold and adds structure and shine to your hair. This hair gel for women is a curly girl approved product, that does wonders while styling curly hair. The strong hold of the gel holds your curls in place without making your hair feel stiff. This strong hold gel is also a great hair gel for men.<br></p>', '200', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667816494_7a7c04834c71cc19c5b6.jpg', 1, '2022-11-07 03:51:34', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(86, '6368dc5a4d4ad', '9861', '111', 0, 'Fiberstrong Intra-Cylane Concentrate', 'fiberstrong-intra-cylane-concentrate', '299', 311, 0, 15, '<p>When dealing with extremely brittle, damaged, and fragile hair, an at-home hair breakage remedy might not give you the results you desire. A professional hair loss treatment delivered by experts will help you strengthen and protect your hair. The Matrix Biolage Fiber-strong Intra-Cylane Concentrate is a salon-exclusive hair breakage treatment that provides the highest concentration of Intra-Cylane for Biolage<br></p>', '200', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667816538_c5ca7485beb64fc723e0.jpg', 1, '2022-11-07 03:52:18', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(87, '6368dc80cb84e', '5106', '111', 0, 'Style Fixer', 'style-fixer', '312', 313, 0, 15, '<p>Locking your hair in place is very important to ensure that your hairstyle doesn’t budge. A hair-setting spray helps you hold your hair in place. With the Matrix Style Fixer, you can add lasting hold and shine to your hair with an ultra-dry finish. The fast-drying film of this setting spray locks in your hairstyle for hours and effectively resists humidity.<br></p>', '200', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667816576_494add30213f1884421a.jpg', 1, '2022-11-07 03:52:56', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(88, '6368ddae6d9e3', '7231', '111', 0, 'Scalppure Clarifying Scalp Scrub', 'scalppure-clarifying-scalp-scrub', '299', 311, 0, 15, '<p><font color=\"#000000\" face=\"montregular\">Is your itchy scalp giving you too much trouble? We are here with a pre-shampoo dandruff solution that will help you with a scalp treatment for dandruff. The Matrix Biol-age Advanced Clarifying Scrub for dandruff control is Matrix’s 1st Ever pre-shampoo clarifying scalp scrub that removes visible flake buildup after every use.</font><br></p>', '200', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667817319_ec9c0990af63ecffd7e7.jpg', 1, '2022-11-07 03:57:58', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0),
(90, '6368e09ad6c51', '8078', '111', 0, 'Scalpsync Aminexil', 'scalpsync-aminexil', '299', 311, 0, 15, '<p><font color=\"#000000\" face=\"montregular\">While some amount of hair fall every day is normal, extreme hair loss can be a cause of worry. And this added stress will only make the hair-fall&nbsp;worse. Prolong hair lifespan and treat hair loss right at the root with the Matrix Biol-age&nbsp;Scalp-sync&nbsp;Aminexil. Trusted by professionals, Scalp-sync&nbsp;Aminexil is a hair fall treatment has anti-hair loss efficacy, proven under dermatological control.</font><br></p>', '200', '', '', '', '', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, 0, '0000-00-00 00:00:00', '0000-00-00 00:00:00', 0, NULL, 1, NULL, '/uploads/1667817626_53134981c4013eea0009.jpg', 1, '2022-11-07 04:10:26', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 100, 0);

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

--
-- Table structure for table `product_image`
--

CREATE TABLE `product_image` (
  `prd_e_id` int(11) NOT NULL,
  `prd_id` int(11) NOT NULL,
  `prd_e_image` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `product_image`
--

INSERT INTO `product_image` (`prd_e_id`, `prd_id`, `prd_e_image`) VALUES
(2, 89, '/uploads/1667816878_ec72c013b1e11ff179f4.jpg');

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

--
-- Table structure for table `product_package`
--

CREATE TABLE `product_package` (
  `package_id` int(11) NOT NULL,
  `package_name` varchar(500) NOT NULL,
  `package_description` text NOT NULL,
  `package_price` int(11) NOT NULL,
  `package_image` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `product_package`
--

INSERT INTO `product_package` (`package_id`, `package_name`, `package_description`, `package_price`, `package_image`) VALUES
(1, 'Professional Masters & Beauty parlour ', 'Professional Master in Hair, Beauty, and Bridal Course and Diploma ', 25000, '/uploads/1667821058_b0198025acd1d01e1ef8.jpeg');

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

--
-- Table structure for table `product_review`
--

CREATE TABLE `product_review` (
  `product_review_id` int(11) NOT NULL,
  `product_id` int(11) DEFAULT NULL,
  `reviewer_id` varchar(255) DEFAULT NULL,
  `comments` text DEFAULT NULL,
  `rate` varchar(100) DEFAULT NULL,
  `date_time` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  `status` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `product_stock`
--

CREATE TABLE `product_stock` (
  `prd_s_id` int(11) NOT NULL,
  `prd_id` int(11) NOT NULL,
  `prd_s_buying_quentiy` int(11) NOT NULL,
  `prd_s_avaliable_quentiy` int(11) NOT NULL,
  `prd_s_date` datetime NOT NULL,
  `prd_s_varient` text NOT NULL,
  `prd_s_sub_varient` text NOT NULL,
  `prd_s_type` int(1) NOT NULL DEFAULT 1 COMMENT '1 == Add && 2 == Buy',
  `prd_s_varient_table_id` int(11) NOT NULL,
  `prd_s_invoice_id` varchar(500) NOT NULL,
  `prd_s_prd_price` int(11) NOT NULL,
  `prd_s_sub_varient_main` int(11) NOT NULL,
  `prd_s_inv_date` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `product_stock`
--

INSERT INTO `product_stock` (`prd_s_id`, `prd_id`, `prd_s_buying_quentiy`, `prd_s_avaliable_quentiy`, `prd_s_date`, `prd_s_varient`, `prd_s_sub_varient`, `prd_s_type`, `prd_s_varient_table_id`, `prd_s_invoice_id`, `prd_s_prd_price`, `prd_s_sub_varient_main`, `prd_s_inv_date`) VALUES
(146, 47, 0, 100, '2022-08-29 03:56:46', '[\"65\",\"66\"]', '[\"\",\"64\"]', 1, 0, '123', 100, 0, '2022-08-23'),
(147, 48, 0, 100, '2022-09-17 05:58:13', '[\"65\",\"67\"]', '[\"78\",\"75\"]', 1, 0, '111', 200, 0, '2022-09-17'),
(148, 49, 0, 10, '2022-09-19 11:04:58', '[\"65\",\"67\"]', '[\"78\",\"75\"]', 1, 0, '111', 200, 0, '2022-09-19'),
(149, 50, 0, 100, '2022-09-19 11:07:33', '[\"65\",\"67\"]', '[\"78\",\"75\"]', 1, 0, '111', 200, 0, '2022-09-19'),
(150, 51, 0, 100, '2022-09-19 11:08:57', '[\"65\",\"67\"]', '[\"78\",\"75\"]', 1, 0, '111', 200, 0, '2022-09-19'),
(151, 52, 0, 100, '2022-09-19 11:16:59', '[\"65\",\"67\"]', '[\"78\",\"75\"]', 1, 0, '111', 200, 0, '2022-09-19'),
(152, 53, 0, 100, '2022-09-19 11:19:16', '[\"65\",\"67\"]', '[\"78\",\"75\"]', 1, 0, '111', 200, 0, '2022-09-19'),
(153, 54, 0, 100, '2022-09-19 11:22:01', '[\"65\",\"67\"]', '[\"78\",\"75\"]', 1, 0, '111', 200, 0, '2022-09-19'),
(154, 55, 0, 100, '2022-09-19 11:42:33', '[\"65\",\"67\"]', '[\"78\",\"75\"]', 1, 0, '111', 200, 0, '2022-09-19'),
(155, 56, 0, 100, '2022-09-19 11:48:26', '[\"65\",\"67\"]', '[\"78\",\"75\"]', 1, 0, '111', 200, 0, '2022-09-19'),
(156, 57, 0, 100, '2022-09-19 11:50:51', '[\"65\",\"67\"]', '[\"78\",\"75\"]', 1, 0, '111', 200, 0, '2022-09-19'),
(157, 58, 0, 100, '2022-09-19 11:59:00', '[\"65\",\"67\"]', '[\"78\",\"75\"]', 1, 0, '111', 200, 0, '2022-09-19'),
(158, 59, 0, 100, '2022-09-19 12:26:57', '[\"65\"]', '[\"63\"]', 1, 0, '111', 200, 0, '2022-09-19'),
(159, 60, 0, 100, '2022-09-19 12:28:47', '[\"65\"]', '[\"63\"]', 1, 0, '111', 200, 0, '2022-09-19'),
(160, 61, 0, 100, '2022-09-19 12:34:01', '[\"65\"]', '[\"78\"]', 1, 0, '111', 200, 0, '2022-09-19'),
(161, 62, 0, 100, '2022-09-19 12:35:19', '[\"65\"]', '[\"78\"]', 1, 0, '111', 200, 0, '2022-09-19'),
(162, 63, 0, 100, '2022-09-19 12:37:27', '[\"65\"]', '[\"67\"]', 1, 0, '111', 200, 0, '2022-09-19'),
(163, 64, 0, 100, '2022-11-05 04:58:39', '[\"65\",\"67\"]', '[\"78\",\"71\"]', 1, 0, '111', 200, 0, '2022-11-05'),
(164, 65, 0, 100, '2022-11-05 05:47:31', '[\"65\",\"67\"]', '[\"78\",\"68\"]', 1, 0, '111', 200, 0, '2022-11-05'),
(165, 66, 0, 100, '2022-11-05 05:51:06', '[\"65\",\"67\"]', '[\"62\",\"69\"]', 1, 0, '111', 200, 0, '2022-11-05'),
(166, 67, 0, 100, '2022-11-05 05:53:03', '[\"65\",\"67\"]', '[\"67\",\"73\"]', 1, 0, '111', 200, 0, '2022-11-05'),
(167, 68, 0, 100, '2022-11-05 05:54:58', '[\"65\",\"67\"]', '[\"63\",\"73\"]', 1, 0, '111', 200, 0, '2022-11-05'),
(168, 69, 0, 100, '2022-11-05 05:57:01', '[\"65\",\"67\"]', '[\"78\",\"75\"]', 1, 0, '111', 200, 0, '2022-11-05'),
(169, 70, 0, 100, '2022-11-05 05:58:30', '[\"65\",\"67\"]', '[\"78\",\"75\"]', 1, 0, '111', 200, 0, '2022-11-05'),
(170, 71, 0, 100, '2022-11-05 06:00:45', '[\"65\",\"67\"]', '[\"78\",\"75\"]', 1, 0, '111', 200, 0, '2022-11-05'),
(171, 72, 0, 100, '2022-11-05 07:15:10', '[\"65\",\"67\"]', '[\"63\",\"74\"]', 1, 0, '111', 200, 0, '2022-11-05'),
(172, 73, 0, 100, '2022-11-05 07:16:29', '[\"65\",\"67\"]', '[\"78\",\"73\"]', 1, 0, '111', 200, 0, '2022-11-05'),
(173, 74, 0, 100, '2022-11-07 01:49:31', '[\"65\",\"67\"]', '[\"63\",\"73\"]', 1, 0, '111', 200, 0, '2022-11-07'),
(174, 75, 0, 100, '2022-11-07 03:10:27', '[\"65\",\"67\"]', '[\"63\",\"77\"]', 1, 0, '111', 200, 0, '2022-11-07'),
(175, 76, 0, 100, '2022-11-07 03:19:10', '[\"65\",\"67\"]', '[\"63\",\"73\"]', 1, 0, '111', 200, 0, '2022-11-07'),
(176, 77, 0, 100, '2022-11-07 03:28:34', '[\"65\",\"67\"]', '[\"63\",\"73\"]', 1, 0, '111', 200, 0, '2022-11-07'),
(177, 78, 0, 100, '2022-11-07 03:34:36', '[\"65\",\"67\"]', '[\"63\",\"77\"]', 1, 0, '111', 200, 0, '2022-11-07'),
(178, 79, 0, 100, '2022-11-07 03:39:42', '[\"65\",\"67\"]', '[\"63\",\"73\"]', 1, 0, '111', 200, 0, '2022-11-07'),
(179, 80, 0, 100, '2022-11-07 03:39:42', '[\"65\",\"67\"]', '[\"63\",\"73\"]', 1, 0, '111', 200, 0, '2022-11-07'),
(180, 81, 0, 100, '2022-11-07 03:44:04', '[\"65\",\"66\",\"67\"]', '[\"63\",\"65\",\"73\"]', 1, 0, '111', 200, 0, '2022-11-07'),
(181, 82, 0, 100, '2022-11-07 03:46:30', '[\"65\",\"67\"]', '[\"63\",\"73\"]', 1, 0, '111', 200, 0, '2022-11-07'),
(182, 83, 0, 100, '2022-11-07 03:48:31', '[\"65\",\"66\",\"67\"]', '[\"63\",\"65\",\"73\"]', 1, 0, '111', 200, 0, '2022-11-07'),
(183, 84, 0, 100, '2022-11-07 03:50:03', '[\"65\",\"66\",\"67\"]', '[\"63\",\"65\",\"73\"]', 1, 0, '111', 200, 0, '2022-11-07'),
(184, 85, 0, 100, '2022-11-07 03:51:34', '[\"65\",\"66\",\"67\"]', '[\"63\",\"65\",\"73\"]', 1, 0, '111', 200, 0, '2022-11-07'),
(185, 86, 0, 100, '2022-11-07 03:52:18', '[\"65\",\"67\"]', '[\"63\",\"73\"]', 1, 0, '111', 200, 0, '2022-11-07'),
(186, 87, 0, 100, '2022-11-07 03:52:56', '[\"65\",\"66\",\"67\"]', '[\"63\",\"65\",\"73\"]', 1, 0, '111', 200, 0, '2022-11-07'),
(187, 88, 0, 200, '2022-11-07 03:57:58', '[\"65\",\"67\"]', '[\"63\",\"73\"]', 1, 0, '111', 200, 0, '2022-07-11'),
(188, 89, 0, 200, '2022-11-07 03:57:58', '[\"65\",\"67\"]', '[\"63\",\"73\"]', 1, 0, '111', 200, 0, '2022-07-11'),
(189, 90, 0, 200, '2022-11-07 04:10:26', '[\"65\",\"67\"]', '[\"63\",\"73\"]', 1, 0, '111', 200, 0, '2022-11-07');

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

--
-- Table structure for table `product_varient`
--

CREATE TABLE `product_varient` (
  `prd_v_id` int(11) NOT NULL,
  `prd_v_buy_price` int(11) DEFAULT NULL,
  `prd_v_sell_price` int(11) NOT NULL,
  `prd_v_offer` int(1) NOT NULL DEFAULT 0,
  `prd_v_offer_price` int(11) NOT NULL,
  `prd_v_product_qnty` int(11) NOT NULL DEFAULT 0,
  `prd_v_default_varient` int(1) NOT NULL DEFAULT 0,
  `prd_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `product_varient`
--

INSERT INTO `product_varient` (`prd_v_id`, `prd_v_buy_price`, `prd_v_sell_price`, `prd_v_offer`, `prd_v_offer_price`, `prd_v_product_qnty`, `prd_v_default_varient`, `prd_id`) VALUES
(82, 100, 200, 1, 150, 98, 1, 47),
(83, 200, 300, 0, 0, 100, 1, 48),
(84, 200, 300, 0, 0, 10, 1, 49),
(85, 200, 300, 0, 0, 100, 1, 50),
(86, 200, 300, 0, 0, 100, 1, 51),
(87, 200, 300, 0, 0, 100, 1, 52),
(88, 200, 300, 0, 0, 100, 1, 53),
(89, 200, 300, 0, 0, 100, 1, 54),
(90, 200, 300, 0, 0, 100, 1, 55),
(91, 200, 300, 0, 0, 100, 1, 56),
(92, 200, 300, 0, 0, 100, 1, 57),
(93, 200, 300, 0, 0, 100, 1, 58),
(94, 200, 300, 0, 0, 100, 1, 59),
(95, 200, 300, 0, 0, 100, 1, 60),
(96, 200, 300, 0, 0, 100, 1, 61),
(97, 200, 300, 0, 0, 100, 1, 62),
(98, 200, 300, 0, 0, 100, 1, 63),
(99, 200, 300, 0, 0, 100, 1, 64),
(100, 200, 300, 0, 0, 100, 1, 65),
(101, 200, 300, 0, 0, 100, 1, 66),
(102, 200, 300, 0, 0, 100, 1, 67),
(103, 200, 300, 0, 0, 100, 1, 68),
(104, 200, 300, 0, 0, 100, 1, 69),
(105, 200, 300, 0, 0, 100, 1, 70),
(106, 200, 300, 0, 0, 100, 1, 71),
(107, 200, 300, 0, 0, 100, 1, 72),
(108, 200, 300, 0, 0, 100, 1, 73),
(109, 200, 3000, 0, 0, 100, 1, 74),
(110, 200, 300, 0, 0, 100, 1, 75),
(111, 200, 300, 0, 0, 100, 1, 76),
(112, 200, 300, 0, 0, 100, 1, 77),
(113, 200, 300, 0, 0, 100, 1, 78),
(114, 200, 300, 0, 0, 100, 1, 79),
(115, 200, 300, 0, 0, 100, 1, 80),
(116, 200, 300, 0, 0, 100, 1, 81),
(117, 200, 300, 0, 0, 100, 1, 82),
(118, 200, 300, 0, 0, 100, 1, 83),
(119, 200, 300, 0, 0, 100, 1, 84),
(120, 200, 300, 0, 0, 100, 1, 85),
(121, 200, 300, 0, 0, 100, 1, 86),
(122, 200, 300, 0, 0, 100, 1, 87),
(123, 200, 300, 0, 0, 200, 1, 88),
(124, 200, 300, 0, 0, 200, 1, 89),
(125, 200, 300, 0, 0, 200, 1, 90);

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

--
-- Table structure for table `product_varient_details`
--

CREATE TABLE `product_varient_details` (
  `prd_vd_id` int(11) NOT NULL,
  `prd_id` int(11) NOT NULL,
  `product_varient_table_id` int(11) NOT NULL,
  `prd_vd_varient` int(11) NOT NULL,
  `prd_vd_sub_varient` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `product_varient_details`
--

INSERT INTO `product_varient_details` (`prd_vd_id`, `prd_id`, `product_varient_table_id`, `prd_vd_varient`, `prd_vd_sub_varient`) VALUES
(206, 47, 82, 65, 0),
(207, 47, 82, 66, 64),
(208, 48, 83, 65, 78),
(209, 48, 83, 67, 75),
(210, 49, 84, 65, 78),
(211, 49, 84, 67, 75),
(212, 50, 85, 65, 78),
(213, 50, 85, 67, 75),
(214, 51, 86, 65, 78),
(215, 51, 86, 67, 75),
(216, 52, 87, 65, 78),
(217, 52, 87, 67, 75),
(218, 53, 88, 65, 78),
(219, 53, 88, 67, 75),
(220, 54, 89, 65, 78),
(221, 54, 89, 67, 75),
(222, 55, 90, 65, 78),
(223, 55, 90, 67, 75),
(224, 56, 91, 65, 78),
(225, 56, 91, 67, 75),
(226, 57, 92, 65, 78),
(227, 57, 92, 67, 75),
(228, 58, 93, 65, 78),
(229, 58, 93, 67, 75),
(230, 59, 94, 65, 63),
(231, 60, 95, 65, 63),
(232, 61, 96, 65, 78),
(233, 62, 97, 65, 78),
(234, 63, 98, 65, 67),
(235, 64, 99, 65, 78),
(236, 64, 99, 67, 71),
(237, 65, 100, 65, 78),
(238, 65, 100, 67, 68),
(239, 66, 101, 65, 62),
(240, 66, 101, 67, 69),
(241, 67, 102, 65, 67),
(242, 67, 102, 67, 73),
(243, 68, 103, 65, 63),
(244, 68, 103, 67, 73),
(245, 69, 104, 65, 78),
(246, 69, 104, 67, 75),
(247, 70, 105, 65, 78),
(248, 70, 105, 67, 75),
(249, 71, 106, 65, 78),
(250, 71, 106, 67, 75),
(251, 72, 107, 65, 63),
(252, 72, 107, 67, 74),
(253, 73, 108, 65, 78),
(254, 73, 108, 67, 73),
(255, 74, 109, 65, 63),
(256, 74, 109, 67, 73),
(257, 75, 110, 65, 63),
(258, 75, 110, 67, 77),
(259, 76, 111, 65, 63),
(260, 76, 111, 67, 73),
(261, 77, 112, 65, 63),
(262, 77, 112, 67, 73),
(263, 78, 113, 65, 63),
(264, 78, 113, 67, 77),
(265, 79, 114, 65, 63),
(266, 80, 115, 65, 63),
(267, 79, 114, 67, 73),
(268, 80, 115, 67, 73),
(269, 81, 116, 65, 63),
(270, 81, 116, 66, 65),
(271, 81, 116, 67, 73),
(272, 82, 117, 65, 63),
(273, 82, 117, 67, 73),
(274, 83, 118, 65, 63),
(275, 83, 118, 66, 65),
(276, 83, 118, 67, 73),
(277, 84, 119, 65, 63),
(278, 84, 119, 66, 65),
(279, 84, 119, 67, 73),
(280, 85, 120, 65, 63),
(281, 85, 120, 66, 65),
(282, 85, 120, 67, 73),
(283, 86, 121, 65, 63),
(284, 86, 121, 67, 73),
(285, 87, 122, 65, 63),
(286, 87, 122, 66, 65),
(287, 87, 122, 67, 73),
(288, 88, 123, 65, 63),
(289, 88, 123, 67, 73),
(290, 89, 124, 65, 63),
(291, 89, 124, 67, 73),
(292, 90, 125, 65, 63),
(293, 90, 125, 67, 73);

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

--
-- Table structure for table `product_video`
--

CREATE TABLE `product_video` (
  `prd_vdo_id` int(11) NOT NULL,
  `prd_id` int(11) NOT NULL,
  `prd_vdo_code` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

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

--
-- Table structure for table `role_permission`
--

CREATE TABLE `role_permission` (
  `id` int(11) NOT NULL,
  `role_name` varchar(255) NOT NULL,
  `stock_point` int(1) NOT NULL DEFAULT 0,
  `blog` int(1) NOT NULL DEFAULT 0,
  `setting` int(1) NOT NULL DEFAULT 0,
  `varient` int(1) NOT NULL DEFAULT 0,
  `category` int(1) NOT NULL DEFAULT 0,
  `product` int(1) NOT NULL DEFAULT 0,
  `home_setting` int(1) NOT NULL DEFAULT 0,
  `order` int(1) NOT NULL DEFAULT 0,
  `pos` int(1) NOT NULL DEFAULT 0,
  `stock_management` int(1) NOT NULL DEFAULT 0,
  `offer_setting` int(1) NOT NULL DEFAULT 0,
  `report` int(1) NOT NULL DEFAULT 0,
  `contact_message` int(1) NOT NULL DEFAULT 0,
  `brand` int(1) NOT NULL DEFAULT 0,
  `role_mgmt` int(1) NOT NULL DEFAULT 0,
  `support_ticket` int(1) NOT NULL DEFAULT 0,
  `customer_mgmt` int(1) NOT NULL DEFAULT 0,
  `emp_mgmt` int(1) NOT NULL DEFAULT 0,
  `is_emp` int(1) NOT NULL DEFAULT 0,
  `service` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `role_permission`
--

INSERT INTO `role_permission` (`id`, `role_name`, `stock_point`, `blog`, `setting`, `varient`, `category`, `product`, `home_setting`, `order`, `pos`, `stock_management`, `offer_setting`, `report`, `contact_message`, `brand`, `role_mgmt`, `support_ticket`, `customer_mgmt`, `emp_mgmt`, `is_emp`, `service`) VALUES
(1, 'Admin', 1, 0, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 0, 1),
(2, 'Stock Point', 0, 0, 0, 0, 0, 0, 0, 1, 1, 1, 0, 1, 0, 0, 0, 0, 0, 1, 0, 0),
(3, 'User', 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0),
(4, 'Delivery Boy', 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0),
(11, 'Sale Executive', 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0),
(12, 'Billing', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0),
(13, 'Sales', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 0, 0, 0, 0);

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

--
-- Table structure for table `services`
--

CREATE TABLE `services` (
  `services_id` int(11) NOT NULL,
  `services_category` int(11) NOT NULL,
  `services_title` varchar(500) NOT NULL,
  `services_image` varchar(500) NOT NULL,
  `services_description` longtext NOT NULL,
  `services_meta_title` varchar(500) NOT NULL,
  `services_meta_description` text NOT NULL,
  `services_meta_keywords` text NOT NULL,
  `services_slug` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `services`
--

INSERT INTO `services` (`services_id`, `services_category`, `services_title`, `services_image`, `services_description`, `services_meta_title`, `services_meta_description`, `services_meta_keywords`, `services_slug`) VALUES
(4, 4, 'Pedicure', '/uploads/1661619735_1da93c258a64a73f1c79.jpg', '<p style=\"margin-bottom: 15px;\"><font face=\"Rubik, sans-serif\">A simple treatment that includes foot soaking, foot scrubbing with a pumice stone or foot file, nail clipping, nail shaping, foot and calf massage, moisturizer and nail polishing.</font><br></p>', '', '', '', 'pedicure'),
(5, 1, 'Eyebrow Threading', '/uploads/1662018597_c9b69bec856c0905c059.jpeg', '<p>The process removes the entire hair, including the root, rather than cutting it.<br></p>', '', '', '', 'eyebrow-threading'),
(6, 1, 'Upper Lips Threading', '/uploads/1662018645_681e18319781b44c10bf.jpeg', '<p>This nonsurgical procedure uses small dissolvable threads to smooth out fine lines around your mouth and boost collagen production. Unlike lip fillers that add volume to your lips, lip threading adds curve and definition, primarily to the cupid\'s bow area of your upper lip.<br></p>', '', '', '', 'upper-lips-threading'),
(7, 1, 'Chin Threading', '/uploads/1662018698_33712adca7510f976018.jpeg', '<p>A type of procedure wherein temporary sutures are used to produce a subtle but visible \"lift\" in the skin.<br></p>', '', '', '', 'chin-threading'),
(8, 4, 'Full Face Threading ', '/uploads/1662018745_265ec8bc1e6ed01eaa91.jpeg', '<p>Full face threading specifically targets hair follicles that grow deep within the skin, as the cotton thread glides along the surface of the skin to remove hair and any dead skin cells.<br></p>', '', '', '', 'full-face-threading'),
(9, 1, 'Neck Threading', '/uploads/1662018791_f8ba43f565924cb5486a.jpeg', '<p>A minimally invasive procedure that uses temporary sutures to tighten and lift sagging skin on the face and neck.<br></p>', '', '', '', 'neck-threading'),
(10, 3, 'Side Face Threading', '/uploads/1662018932_b1d162ef920b0fe33df3.jpeg', '<p>This process uses a thin strand of cotton thread to pull hair and is a great alternative if your face is too sensitive for waxing.<br></p>', '', '', '', 'side-face-threading'),
(11, 3, 'Full arm Wax', '/uploads/1662019820_99f9164b928fe83f8e8b.jpeg', '<p>A full arm and Half arm wax will include everything from your shoulder downwards, including hands and fingers if required.<br></p>', '', '', '', 'full-arm-wax'),
(12, 3, 'Under Arms Wax', '/uploads/1662020015_3635dbfa04616edeffda.jpeg', '<p>Waxing removes dead skin cells along with the hair in your underarms.<br></p>', '', '', '', 'under-arms-wax'),
(13, 4, ' Full legs Wax', '/uploads/1662020106_452db4956455e7f3976a.jpeg', '<p>A full legs and Half legs wax commonly comprises hair removal from the top of the thighs to the base of the ankles (front and back).&nbsp;<br></p>', '', '', '', 'full-legs-wax'),
(14, 4, 'Eyebrow Wax', '/uploads/1662020191_8fe3cdf891f1d2a7128a.jpeg', '<p>Eyebrow waxing works by applying warm (not hot) wax to areas of unwanted hair.<br></p>', '', '', '', 'eyebrow-wax'),
(15, 4, 'Upper Lip Wax', '/uploads/1662020249_3bb86cfc72a196bfd333.jpeg', '<p>Upper lip waxing is a very quick facial hair removal treatment and the result can last for up to a month.&nbsp;<br></p>', '', '', '', 'upper-lip-wax'),
(16, 4, 'Full face Wax', '/uploads/1662020292_dc1d6c2cde5e360b093e.jpeg', '<p>Full-face waxing can include the nostrils, ears, cheeks, and even forehead.<br></p>', '', '', '', 'full-face-wax'),
(17, 4, 'Full Body Wax', '/uploads/1662020355_cb9e784e475a28981cda.jpeg', '<p><span style=\"font-size: 1rem;\">Full body, Full back, Halfback, and Stomach wax is a methods of removing unwanted body hair from the entire body.</span><br></p>', '', '', '', 'full-body-wax'),
(18, 4, 'Temporary Straight Hairdos', '/uploads/1662022602_024e07ba7d794156fcd5.jpeg', '<p>A person can temporarily straighten their hair using: Hair irons, tongs use heat to make the hair straight.<br></p>', '', '', '', 'temporary-straight-hairdos'),
(19, 4, 'Temporary Curls Hairdos', '/uploads/1662022697_393bfc773d1684a4361b.jpeg', '<p>Hairdos For Curly Hair, Curly Hair Styles Easy, Hair Ponytail Styles, Black Girl.</p><div><br></div>', '', '', '', 'temporary-curls-hairdos'),
(20, 3, 'Temporary Hot Rollers Hairdos', '/uploads/1662022913_7be9cfbe6defe2ff6bbe.jpeg', '<p>Hot rollers give you the curls you\'ve always wanted, without having to commit to anything as permanent as a perm.<br></p>', '', '', '', 'temporary-hot-rollers-hairdos'),
(21, 3, 'Temporary Blow Dryer Hairdos', '/uploads/1662023012_d6f69dea424e471686d4.jpeg', '<p>Set on high, aim the blow dryer in the direction - and only the direction - you want your hair to be styled, and use the brush to form that style.<br></p>', '', '', '', 'temporary-blow-dryer-hairdos'),
(22, 3, 'Temporary Bun Hairdos ', '/uploads/1662023094_76eb5349c4c68715b963.jpeg', '<p>A bun is a type of hairstyle in which the hair is pulled back from the face, twisted or plaited, and wrapped in a circular coil around itself, typically on top or back of the head or just above the neck.&nbsp;<br></p>', '', '', '', 'temporary-bun-hairdos'),
(23, 3, ' Straight Hair Cut', '/uploads/1662024303_58ed63fc3128f06a4c48.jpeg', '<p>It\'s exactly what it sounds like: The hair is cut into two layers. The bottom layer has the most length, while the top layer is short.<br></p>', '', '', '', 'straight-hair-cut'),
(24, 3, 'U & V Shape Hair Cut', '/uploads/1662024376_c426620b7ece2270dd4b.jpeg', '<p>The “V” is heavily layered to create a V-shaped point at the ends, while the “U” is largely rounded on the sides to the ends.<br></p>', '', '', '', 'u-amp-v-shape-hair-cut'),
(25, 3, 'Layered Hair Cut', '/uploads/1662024607_065c90c44b632f3de4bf.jpeg', '<p>Layered hair is a hairstyle that gives the illusion of length and volume using long hair for the illusion of length and short hair for volume, as an easy style to manage. Hair is arranged into layers, with the top layers cut shorter than the layers beneath.<br></p>', '', '', '', 'layered-hair-cut'),
(26, 1, 'Kids Hair Cut', '/uploads/1662024718_37a16d6a840a822f7721.jpeg', '<p>Haircuts that every mom can easy to make a style to ... And this has intricate details and design.<br></p>', '', '', '', 'kids-hair-cut'),
(27, 1, 'Clean up Facial', '/uploads/1662026677_173e5248f8eaf9df15c1.jpeg', '<p>A clean-up usually costs less than a facial but does not include massage and other special treatments. Just like clean-up, facial also includes cleansing, scrubbing, steam, removal of blackheads and whiteheads, and applying a face pack.<br></p>', '', '', '', 'clean-up-facial'),
(28, 0, 'Fruit Facial', '/uploads/1662026739_f6bcdfee9a7484b4f511.jpeg', '<p>Fruit facials contain certain fruit acids like glycolic acid, alpha hydroxyl acid, citric acid, phenolic acid, vitamins, and minerals in it. These acids are anti-blemish, and antiwrinkle and help your skin to exfoliate, it highly detoxifies your skin, excrete out all the toxins and it hydrates your face.<br></p>', '', '', '', 'fruit-facial'),
(29, 0, 'VLCC Facial', '/uploads/1662026830_c3ff821dc41ecc81c783.jpeg', '<p>VLCC Gold Facial Kit nourishes &amp; revitalizes for a luminous and radiant complexion. Bleach gives a fairer glow to the skin. The Diamond scrub is enriched with the goodness of Vitamin E, jojoba, and real diamond bhasma which rejuvenates and purifies the skin. It also builds the skin\'s immunity against damage and pollution.<br></p>', '', '', '', 'vlcc-facial'),
(30, 0, 'Skin Tightening', '/uploads/1662026891_08d853e5677da584bdb4.jpeg', '<p>It naturally heals the skin, tightens the pores, and provides a smooth &amp; supple effect to the skin.<br></p>', '', '', '', 'skin-tightening'),
(31, 0, 'Mini Facial', '/uploads/1662026952_c2d7f40e6a78d19b2feb.jpeg', '<p>Mini facial comprises of cleansing, exfoliation, and application of a mask, toner, and moisturizer. All of these steps are safe and risk-free, as long as the approved products are used for every step and are in accordance with your skin type.<br></p>', '', '', '', 'mini-facial'),
(32, 0, 'Core Facial', '/uploads/1662027034_5acf0fdf92dfeef5eb00.jpeg', '<p>This skin treatment is fully inclusive and will deliver your skin\'s best health as it involves a combination of professional double cleansing, exfoliation, high frequency/ultrasound/galvanic modalities, extractions (as needed), masque, toner, and skin protection.<br></p>', '', '', '', 'core-facial'),
(33, 0, 'The AGE smart Facial', '/uploads/1662027108_c5bc50703a1e8e754bba.jpeg', '<p>AGE Smart is the most powerful Dermalogica facial treatment and is an intelligent investment in your future facial skin. A specially created facial for clients concerned with premature aging and the signs of photoaging and sun damage.<br></p>', '', '', '', 'the-age-smart-facial'),
(34, 0, 'Bleach', '/uploads/1662028131_2e97bcaf67b6de0c8002.jpg', '<p>Skin bleaching treatments can reduce dark spots on the skin caused by sun damage, aging, and hormonal changes. It can be beneficial for those who want to minimize skin discoloration, such as liver spots or age spots.<br></p>', '', '', '', 'bleach'),
(35, 0, 'Shiner Bleach', '/uploads/1662028218_f093dd4da97118f8d87a.jpeg', '<p><span style=\"font-size: 1rem;\">Allergic shiners are dark circles under the eyes caused by congestion of the nose and sinuses. They\'re usually described as dark, shadowy pigments that resemble bruises.</span><br></p><div><br></div>', '', '', '', 'shiner-bleach'),
(36, 0, ' Full Body Bleach ', '/uploads/1662028287_7bb0d0be71c419395bf9.jpeg', '<p>Bleach makes skin look fairer and radiant in just about 15 minutes. It bleaches facial hair to match your skin tone. Facial cream conditions skin and protects it against irritation caused by bleaching.<br></p>', '', '', '', 'full-body-bleach'),
(37, 0, 'Hair Thermal Treatment', '/uploads/1663576531_8a7972403863995dfde9.jpg', '<p>A thio-based chemical procedure which uses heat to restructure the hair\'s protein bond, enabling those with frizzy, curly, or wavy hair to experience permanently straight hair while at the same time preserving the health and improving the feel, texture.<br></p>', '', '', '', 'hair-thermal-treatment'),
(38, 0, 'Neck and Shoulder + Head Massage', '/uploads/1663576597_85964c7879a6a80e8d51.jpg', '<p>A revitalizing and aromatic massage encompassing the scalp, neck, and shoulder area to reduce stress-related tension quickly. Cool fingertips run along your neck, gently rubbing the tension away from your spine. They make their way up the back of your head.<br></p>', '', '', '', 'neck-and-shoulder-head-massage'),
(39, 0, 'Hair oil massage', '/uploads/1663576691_a4a9dd1dfcd8bcdd0fbe.jpg', '<p>Massaging the scalp with lukewarm oil facilitates blood circulation and soothes capillaries and nerves. Oil massage relaxes your mind and body, alleviates stress, and boosts mood. Since stress is a contributor to hair loss, regular oil massage can boost hair growth. Research also suggests that it improves eyesight!<br></p>', '', '', '', 'hair-oil-massage'),
(40, 0, 'Protein Treatment', '/uploads/1663576735_7a7be622332c4f521247.jpg', '<p><span style=\"font-size: 1rem;\">Protein treatments are over-the-counter (OTC) or professional products you can apply to your hair to restore strength while providing protection against further damage. You may find keratin and collagen in these types of products. These ingredients help restore hair\'s structure and the oils to help replenish moisture.</span><br></p>', '', '', '', 'protein-treatment'),
(41, 0, 'Hair Spa', '/uploads/1663576761_992afe65a9d5a15c6192.jpg', '<p>A hair spa is an extensive process that involves deep cleansing, massaging, steaming and masking to make hair healthy and shiny. It is a procedure that tackles common hair concerns like dandruff, hair fall, itchiness, damaged hair, etc, while also making it strong and soft.</p><div><br></div>', '', '', '', 'hair-spa'),
(42, 0, 'Body Massage', '/uploads/1663576791_e4a13f54ad10b2076a43.jpg', '<p>A body massage involves working and applying pressure on the muscles of the body, on the skin surface. It may be a manual massage or done with machines. Usually, body massage is a structured and systematic procedure of applying tension, motion or vibration, with or without the application of heat.</p><div><br></div>', '', '', '', 'body-massage'),
(43, 0, 'Heena / hair colour Application', '/uploads/1663576826_c3750be82cd22988c4b1.jpg', '<p>Mix two tablespoons of henna and one tablespoon of Shikakai powder with a sufficient amount of water to make a paste. Let this paste sit overnight and in the morning, add one egg and a tablespoon of curd. Apply this mixture all over the hair and scalp and wash it off with lukewarm water after 40 to 45 minutes.</p><div><br></div>', '', '', '', 'heena-hair-colour-application'),
(44, 0, 'Nude make up ', '/uploads/1663576869_e26d0dd5e21957bde372.jpg', '<p><span style=\"font-size: 1rem;\">Nude makeup looks are characterized by skin-tone-inspired shades, leaning into a more natural makeup look and offering subtle shadow and light instead of overly strobed or contoured faces. But, don\'t confuse a nude makeup look for one that can be slapped together without thought.</span><br></p><div><br></div>', '', '', '', 'nude-make-up'),
(45, 0, 'Day Party Make Up', '/uploads/1663576905_9ff5bf2b3e056dd6eb7b.jpg', '<p><span style=\"font-size: 1rem;\">Light makeup for the party is the concept of this format and uses a very natural and light base for your skin tone. It would appear more like a natural blush on .</span><br></p><div><br></div>', '', '', '', 'day-party-make-up'),
(46, 0, 'Evening makeup', '/uploads/1663576939_3b9128eaa23e54014d9b.jpg', '<p><span style=\"font-size: 1rem;\">Evening makeup usually differs from daytime makeup in depth and color. While too many dark colors can be harsh for the day, these deeper shades work well for .</span><br></p><div><br></div>', '', '', '', 'evening-makeup'),
(47, 0, 'Engagement makeup', '/uploads/1663576986_64c57b1a889a85b3af76.jpg', '<p><span style=\"font-size: 1rem;\">Engagement makeup is the in-between makeup routine. It\'s neither as light as party makeup nor as heavy as bridal makeup. It can either be done by using basic products or even specialized techniques. It all depends on a lot of factors, so here you go, read everything about how to get the right engagement makeup, now.</span><br></p><div><br></div>', '', '', '', 'engagement-makeup'),
(48, 0, 'Bridal Makeup', '/uploads/1663577020_551981865f8604b36db9.jpg', '<p><span style=\"font-size: 1rem;\">A bridal makeup look is one you wear to your wedding. Generally, it is designed to last all day, photograph well, and look beautiful. Just like regular makeup, there are lots of styles you can choose from. These include natural, winter, summer, vintage, smoky, dramatic, red-lipped — the options are almost endless.</span><br></p><div><br></div>', '', '', '', 'bridal-makeup'),
(49, 0, 'Manicure', '/uploads/1663577061_69e14ff4695295b1c1ed.jpg', '<p>A manicure usually consists of filing and shaping the free edge of nails, pushing and clipping (with a cuticle pusher and cuticle nippers) any non living tissue (but limited to the cuticle and hangnails), treatments with various liquids, massage of the hand, and the application of fingernail polish.</p><div><br></div>', '', '', '', 'manicure'),
(50, 0, 'Shellac', '/uploads/1663577104_0b8162336a19ed6c2319.jpg', '<p>Shellac nails are a patented form of polish from Creative Nail Design, with over 100 shades available at CDG-verified salons. Shellac polishes mix two types of nail coating: gel (for durability and nail protection) and traditional nail polish (for color and shine). The finished look errs on the natural side.</p><div><br></div>', '', '', '', 'shellac'),
(51, 0, 'Peel off Sclack', '/uploads/1663577147_e0484c76d3849c6a7181.jpg', '<p><span style=\"font-size: 1rem;\">Peeling nails can result from trauma to the nail. Picking off nail polish and pressing on your nails can cause them to peel. More rarely, they\'re a sign of&nbsp;</span><br></p><div><br></div>', '', '', '', 'peel-off-sclack'),
(52, 0, 'False Nails', '/uploads/1663577182_5155268d9c88750ed55e.jpg', '<p><span style=\"font-size: 1rem;\">Acrylics are a combination of a liquid monomer and a powder polymer that form a paste which is bonded to the natural nail. It\'s then given the desired shape, where it hardens in place to add strength, length, and thickness to the nail.</span><br></p><p><br></p>', '', '', '', 'false-nails');

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

--
-- Table structure for table `service_category`
--

CREATE TABLE `service_category` (
  `sc_id` int(11) NOT NULL,
  `sc_name` varchar(500) NOT NULL,
  `sc_slug` varchar(500) NOT NULL,
  `sc_image` varchar(500) NOT NULL,
  `sc_description` text NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `service_category`
--

INSERT INTO `service_category` (`sc_id`, `sc_name`, `sc_slug`, `sc_image`, `sc_description`) VALUES
(1, 'Hair', 'hair', '/uploads/1724994928_56d2521416217f3167fa.jpeg', '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,'),
(3, 'Skin', 'skin', '/uploads/1724995015_f81230273ec6b8a2900b.jpeg', '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,'),
(4, 'Bridal', 'bridal', '/uploads/1724995046_140098dd91a5235135d1.jpeg', '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,');

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

--
-- Table structure for table `service_package`
--

CREATE TABLE `service_package` (
  `pack_id` int(11) NOT NULL,
  `pack_name` varchar(500) NOT NULL,
  `pack_category` int(11) NOT NULL,
  `pack_content` longtext NOT NULL,
  `pack_main_price` int(11) NOT NULL,
  `pack_discount_price` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `service_package`
--

INSERT INTO `service_package` (`pack_id`, `pack_name`, `pack_category`, `pack_content`, `pack_main_price`, `pack_discount_price`) VALUES
(1, 'Package 1', 1, '[\"Full Hand Wax\",\"Full Leg Wax\",\"Full Leg Wax 2\"]', 1500, 1000),
(3, 'Package 2', 1, '[\"Full Hand Wax\",\"Full Leg Wax\"]', 2000, 0),
(4, 'Package 3', 1, '[\"Full Hand Wax\",\"Full Leg Wax\"]', 3000, 2500);

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

--
-- Table structure for table `service_request`
--

CREATE TABLE `service_request` (
  `request_id` int(11) NOT NULL,
  `request_name` varchar(500) NOT NULL,
  `request_email` varchar(500) NOT NULL,
  `request_phone` varchar(15) NOT NULL,
  `request_msg` text NOT NULL,
  `request_service` int(11) NOT NULL,
  `request_date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `service_request`
--

INSERT INTO `service_request` (`request_id`, `request_name`, `request_email`, `request_phone`, `request_msg`, `request_service`, `request_date`) VALUES
(1, 'Saikat', 'saikat@gmail.com', '644446', 'khgfh', 1, '2022-08-28 01:11:16'),
(2, 'sddd', 'hdg@gmail.com', '57555554', 'duhfuh', 1, '2022-08-28 01:12:26');

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

--
-- Table structure for table `short_about_content`
--

CREATE TABLE `short_about_content` (
  `content_id` int(11) NOT NULL,
  `content_details` longtext NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `short_about_content`
--

INSERT INTO `short_about_content` (`content_id`, `content_details`) VALUES
(1, '<p style=\"line-height: 1;\"><span style=\"font-size: 18px;\"><b><font color=\"#ffffff\">About us</font></b></span></p><p></p><div style=\"font-size: 46px;color=\" #ffffff\"\"=\"\"><font color=\"#ffffff\">Welcome!</font></div><p></p><p><font color=\"#ffffff\">Sakshi salon &amp; Academy was founded in the year 2019 by Sakshi kharat.</font></p><p><font color=\"#ffffff\">Sakshi has forged ahead continuously with a dynamic approach and is today recognized as one of the leading Beauty and Hair Care salons and top-notch Makeup academies.</font></p><p><font color=\"#ffffff\">Treatments and courses are conducted under the personal supervision of Sakshi, who is trained extensively in India, U. in Beauty Skin Care, Make-up, and Hair Colouring coupled with specialization in Aroma Therapy, Reflexology, Stress Management, Non-Surgical Face-Lift, Removal of Scars and Masks and Pigmentation.</font></p><p><font color=\"#ffffff\">Our Bridal Studio &amp; Makeup Academy headed by Mrs. Sakshi Kharat, who is the first generation in taking Sakshi ahead caters to Brides &amp; Students from all over India.</font></p><div><br></div>');

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

--
-- Table structure for table `short_about_image`
--

CREATE TABLE `short_about_image` (
  `image_id` int(11) NOT NULL,
  `image` varchar(500) NOT NULL,
  `image_name` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `short_about_image`
--

INSERT INTO `short_about_image` (`image_id`, `image`, `image_name`) VALUES
(9, '/uploads/1720698637_08310f5bfe1481652266.jpeg', ''),
(10, '/uploads/1720698830_ad3505ab8a648ade29cb.jpeg', ''),
(11, '/uploads/1720698872_38bb3a0df377bbd16c20.jpeg', '');

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

--
-- Table structure for table `slider_extra_image`
--

CREATE TABLE `slider_extra_image` (
  `image_id` int(11) NOT NULL,
  `image_1` varchar(500) NOT NULL,
  `image_2` varchar(500) NOT NULL,
  `image_3` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `slider_extra_image`
--

INSERT INTO `slider_extra_image` (`image_id`, `image_1`, `image_2`, `image_3`) VALUES
(1, '/uploads/1661246689_5cf81f71e2a7888504d5.png', '/uploads/1661246709_79fe741f6a8263ac8d9a.png', '/uploads/1661246927_b5073ce6cef903cf3633.jpg');

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

--
-- Table structure for table `stock_point_stock`
--

CREATE TABLE `stock_point_stock` (
  `stock_id` int(11) NOT NULL,
  `stock_point_id` int(11) NOT NULL,
  `stock_point_stock` int(11) NOT NULL,
  `stock_point_prd_id` int(11) NOT NULL,
  `stock_point_prd_varient` int(11) NOT NULL,
  `stock_point_prd_main_varient` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `stock_point_stock`
--

INSERT INTO `stock_point_stock` (`stock_id`, `stock_point_id`, `stock_point_stock`, `stock_point_prd_id`, `stock_point_prd_varient`, `stock_point_prd_main_varient`) VALUES
(1, 544, 2, 47, 64, 82);

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

--
-- Table structure for table `sub_varient`
--

CREATE TABLE `sub_varient` (
  `sub_varient_id` int(11) NOT NULL,
  `main_varient_id` int(11) NOT NULL,
  `sub_varient_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `sub_varient`
--

INSERT INTO `sub_varient` (`sub_varient_id`, `main_varient_id`, `sub_varient_name`) VALUES
(22, 54, '100ML'),
(23, 54, '250ML'),
(24, 54, '500ML'),
(25, 55, '1Ltr'),
(26, 55, '5Ltr'),
(27, 56, '100Grm'),
(28, 56, '250Grm'),
(29, 54, '1000ML'),
(30, 55, '10Ltr'),
(31, 55, '20Ltr'),
(32, 56, '500Grm'),
(33, 57, 'Red'),
(34, 57, 'Green'),
(35, 57, 'Blue'),
(36, 58, '15'),
(37, 58, '18'),
(38, 58, '20'),
(39, 58, '22'),
(40, 58, '24'),
(41, 59, 'L'),
(42, 59, 'M'),
(43, 59, 'XL'),
(44, 59, 'XXL'),
(45, 60, '1'),
(46, 60, '2'),
(47, 60, '3'),
(48, 61, '2GB'),
(49, 61, '4GB'),
(50, 61, '8GB'),
(51, 61, '16GB'),
(52, 62, '256GB'),
(53, 62, '500GB'),
(54, 62, '1TB'),
(55, 63, '1Meter'),
(56, 63, '2Meter'),
(57, 63, '3Meter'),
(58, 64, '1Kg'),
(59, 64, '2Kg'),
(60, 64, '3Kg'),
(61, 65, '50'),
(62, 65, '100'),
(63, 65, '200'),
(64, 66, '1'),
(65, 66, '2'),
(66, 66, '3'),
(67, 65, '250'),
(68, 67, '10'),
(69, 67, '20'),
(70, 67, '50'),
(71, 67, '100'),
(72, 67, '150'),
(73, 67, '200'),
(74, 67, '250'),
(75, 67, '500'),
(76, 67, '750'),
(77, 67, '1000'),
(78, 65, '500'),
(79, 65, '550'),
(80, 65, '750'),
(81, 65, '800'),
(82, 65, '1000');

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

--
-- Table structure for table `support_ticket`
--

CREATE TABLE `support_ticket` (
  `id` int(11) NOT NULL,
  `rand_id` varchar(500) NOT NULL,
  `user_id` int(11) NOT NULL,
  `ticket_id` varchar(255) NOT NULL,
  `subject` varchar(255) NOT NULL,
  `department` int(11) NOT NULL,
  `description` text NOT NULL,
  `image` varchar(255) NOT NULL,
  `status` int(1) NOT NULL DEFAULT 0,
  `transfer` int(2) NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `support_ticket`
--

INSERT INTO `support_ticket` (`id`, `rand_id`, `user_id`, `ticket_id`, `subject`, `department`, `description`, `image`, `status`, `transfer`, `date`) VALUES
(10, '6724c0c13890474c45e27a8', 529, '#20220604/3656', 'Order Error', 12, 'Order Error', '', 1, 0, '2022-06-04 22:15:07'),
(11, '17115912f6e415b705a8bcc', 2, '#20240704/4455', 'r', 12, 'rerr', '', 0, 0, '2024-07-04 16:44:26');

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

--
-- Table structure for table `support_ticket_comment`
--

CREATE TABLE `support_ticket_comment` (
  `id` int(11) NOT NULL,
  `ticket_id` varchar(500) NOT NULL,
  `who_from` int(1) NOT NULL DEFAULT 1 COMMENT '1 FOR USER & 2 FOR ADMIN',
  `comment` text NOT NULL,
  `image` varchar(500) DEFAULT NULL,
  `user_id` int(11) NOT NULL,
  `datetime` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `support_ticket_comment`
--

INSERT INTO `support_ticket_comment` (`id`, `ticket_id`, `who_from`, `comment`, `image`, `user_id`, `datetime`) VALUES
(11, '6724c0c13890474c45e27a8', 1, 'Order Error', '/uploads/1654361107_028d9769d5ee09c5b14e.jfif', 529, '2022-06-04 22:15:07'),
(12, '17115912f6e415b705a8bcc', 1, 'rerr', '/uploads/1720091666_feb57277d36784386373.png', 2, '2024-07-04 16:44:26');

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

--
-- Table structure for table `testimonials`
--

CREATE TABLE `testimonials` (
  `testimonials_id` int(11) NOT NULL,
  `testimonials_name` varchar(500) NOT NULL,
  `testimonials_description` text NOT NULL,
  `testimonials_rating` int(11) NOT NULL,
  `testimonials_image` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `testimonials`
--

INSERT INTO `testimonials` (`testimonials_id`, `testimonials_name`, `testimonials_description`, `testimonials_rating`, `testimonials_image`) VALUES
(1, 'Swarali G', 'An amazing and professional salon, the salon is so hygienic, relaxing, airy, and has pleasant ', 5, '/uploads/1720694547_40285b2ccf1d24c7e9fe.jpeg'),
(2, 'dhanashree G', 'I ordered a hair care product and also a skin care product that product was the really nice and effective product.', 5, '/uploads/1720694601_d7d1e98850109b3aafc3.jpeg'),
(4, 'Jasmin S', 'the best parlor course in Mumbai, changed my life, I recently open my own spa & beauty salon in Pune. thanks a lot for giving greatly experienced', 4, '/uploads/1720694495_ce10438b697de5733875.jpeg');

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

--
-- Table structure for table `varient`
--

CREATE TABLE `varient` (
  `varient_id` int(11) NOT NULL,
  `varient_name` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Dumping data for table `varient`
--

INSERT INTO `varient` (`varient_id`, `varient_name`) VALUES
(65, 'Grm'),
(66, 'Litter'),
(67, 'ML');

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

--
-- Table structure for table `video_section`
--

CREATE TABLE `video_section` (
  `section_id` int(11) NOT NULL,
  `section_image` varchar(500) NOT NULL,
  `section_video` varchar(500) NOT NULL,
  `section_title` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `video_section`
--

INSERT INTO `video_section` (`section_id`, `section_image`, `section_video`, `section_title`) VALUES
(1, '/uploads/1661695258_8e3d46ae6955ec8a9a62.jpg', 'https://www.youtube.com/watch?v=Zd00oIDAt60', 'We Care About Your Nail And Your well-Being');

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

--
-- Table structure for table `visual_setting`
--

CREATE TABLE `visual_setting` (
  `id` int(11) NOT NULL,
  `color_1` varchar(50) NOT NULL,
  `color_2` varchar(50) NOT NULL,
  `color_3` varchar(500) NOT NULL,
  `color_4` varchar(500) NOT NULL,
  `color_5` varchar(500) NOT NULL,
  `color_6` varchar(200) NOT NULL,
  `color_7` varchar(200) NOT NULL,
  `color_1_rgb` varchar(50) NOT NULL,
  `color_2_rgb` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Dumping data for table `visual_setting`
--

INSERT INTO `visual_setting` (`id`, `color_1`, `color_2`, `color_3`, `color_4`, `color_5`, `color_6`, `color_7`, `color_1_rgb`, `color_2_rgb`) VALUES
(1, '#5D0367', '#D51676', '#5D0367', '#D51676', '#5D0367', '#D51676', '#5D0367', '93,3,103', '213,22,118');

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

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

CREATE TABLE `wishlist` (
  `id` int(11) NOT NULL,
  `wishlist_id` varchar(255) NOT NULL,
  `product_id` varchar(100) NOT NULL,
  `user_id` varchar(100) NOT NULL,
  `status` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;

--
-- Indexes for table `appointment`
--
ALTER TABLE `appointment`
  ADD PRIMARY KEY (`cus_id`);

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

--
-- Indexes for table `blog_category`
--
ALTER TABLE `blog_category`
  ADD PRIMARY KEY (`category_id`);

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

--
-- Indexes for table `brand`
--
ALTER TABLE `brand`
  ADD PRIMARY KEY (`brand_id`);

--
-- Indexes for table `category`
--
ALTER TABLE `category`
  ADD PRIMARY KEY (`category_id`);

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

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

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

--
-- Indexes for table `course_admission`
--
ALTER TABLE `course_admission`
  ADD PRIMARY KEY (`admission_id`);

--
-- Indexes for table `course_inquery`
--
ALTER TABLE `course_inquery`
  ADD PRIMARY KEY (`inq_id`);

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

--
-- Indexes for table `features_section`
--
ALTER TABLE `features_section`
  ADD PRIMARY KEY (`section_id`);

--
-- Indexes for table `gallery`
--
ALTER TABLE `gallery`
  ADD PRIMARY KEY (`gallery_id`);

--
-- Indexes for table `heading_details`
--
ALTER TABLE `heading_details`
  ADD PRIMARY KEY (`heading_id`);

--
-- Indexes for table `home_banner`
--
ALTER TABLE `home_banner`
  ADD PRIMARY KEY (`banner_id`);

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

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

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

--
-- Indexes for table `our_staff`
--
ALTER TABLE `our_staff`
  ADD PRIMARY KEY (`staff_id`);

--
-- Indexes for table `product`
--
ALTER TABLE `product`
  ADD PRIMARY KEY (`prd_id`);

--
-- Indexes for table `product_image`
--
ALTER TABLE `product_image`
  ADD PRIMARY KEY (`prd_e_id`);

--
-- Indexes for table `product_package`
--
ALTER TABLE `product_package`
  ADD PRIMARY KEY (`package_id`);

--
-- Indexes for table `product_review`
--
ALTER TABLE `product_review`
  ADD PRIMARY KEY (`product_review_id`);

--
-- Indexes for table `product_stock`
--
ALTER TABLE `product_stock`
  ADD PRIMARY KEY (`prd_s_id`);

--
-- Indexes for table `product_varient`
--
ALTER TABLE `product_varient`
  ADD PRIMARY KEY (`prd_v_id`);

--
-- Indexes for table `product_varient_details`
--
ALTER TABLE `product_varient_details`
  ADD PRIMARY KEY (`prd_vd_id`) USING BTREE;

--
-- Indexes for table `product_video`
--
ALTER TABLE `product_video`
  ADD PRIMARY KEY (`prd_vdo_id`);

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

--
-- Indexes for table `services`
--
ALTER TABLE `services`
  ADD PRIMARY KEY (`services_id`);

--
-- Indexes for table `service_category`
--
ALTER TABLE `service_category`
  ADD PRIMARY KEY (`sc_id`);

--
-- Indexes for table `service_package`
--
ALTER TABLE `service_package`
  ADD PRIMARY KEY (`pack_id`);

--
-- Indexes for table `service_request`
--
ALTER TABLE `service_request`
  ADD PRIMARY KEY (`request_id`);

--
-- Indexes for table `short_about_content`
--
ALTER TABLE `short_about_content`
  ADD PRIMARY KEY (`content_id`);

--
-- Indexes for table `short_about_image`
--
ALTER TABLE `short_about_image`
  ADD PRIMARY KEY (`image_id`);

--
-- Indexes for table `slider_extra_image`
--
ALTER TABLE `slider_extra_image`
  ADD PRIMARY KEY (`image_id`);

--
-- Indexes for table `stock_point_stock`
--
ALTER TABLE `stock_point_stock`
  ADD PRIMARY KEY (`stock_id`);

--
-- Indexes for table `sub_varient`
--
ALTER TABLE `sub_varient`
  ADD PRIMARY KEY (`sub_varient_id`);

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

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

--
-- Indexes for table `testimonials`
--
ALTER TABLE `testimonials`
  ADD PRIMARY KEY (`testimonials_id`);

--
-- Indexes for table `varient`
--
ALTER TABLE `varient`
  ADD PRIMARY KEY (`varient_id`);

--
-- Indexes for table `video_section`
--
ALTER TABLE `video_section`
  ADD PRIMARY KEY (`section_id`);

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

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

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

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

--
-- AUTO_INCREMENT for table `blog_category`
--
ALTER TABLE `blog_category`
  MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

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

--
-- AUTO_INCREMENT for table `brand`
--
ALTER TABLE `brand`
  MODIFY `brand_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `category`
--
ALTER TABLE `category`
  MODIFY `category_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=314;

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

--
-- AUTO_INCREMENT for table `coupon_code`
--
ALTER TABLE `coupon_code`
  MODIFY `coupon_id` int(11) NOT NULL AUTO_INCREMENT;

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `home_banner`
--
ALTER TABLE `home_banner`
  MODIFY `banner_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

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

--
-- AUTO_INCREMENT for table `order`
--
ALTER TABLE `order`
  MODIFY `order_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=514;

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

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

--
-- AUTO_INCREMENT for table `product`
--
ALTER TABLE `product`
  MODIFY `prd_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=91;

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

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

--
-- AUTO_INCREMENT for table `product_review`
--
ALTER TABLE `product_review`
  MODIFY `product_review_id` int(11) NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `product_stock`
--
ALTER TABLE `product_stock`
  MODIFY `prd_s_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=190;

--
-- AUTO_INCREMENT for table `product_varient`
--
ALTER TABLE `product_varient`
  MODIFY `prd_v_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=126;

--
-- AUTO_INCREMENT for table `product_varient_details`
--
ALTER TABLE `product_varient_details`
  MODIFY `prd_vd_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=294;

--
-- AUTO_INCREMENT for table `product_video`
--
ALTER TABLE `product_video`
  MODIFY `prd_vdo_id` int(11) NOT NULL AUTO_INCREMENT;

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

--
-- AUTO_INCREMENT for table `services`
--
ALTER TABLE `services`
  MODIFY `services_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `sub_varient`
--
ALTER TABLE `sub_varient`
  MODIFY `sub_varient_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=83;

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

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

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

--
-- AUTO_INCREMENT for table `varient`
--
ALTER TABLE `varient`
  MODIFY `varient_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=68;

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

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

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

