We are using Cookies! For more information visit this page Cookie policy
.', 1, 2, 'AIzaSyBtQRC4TwHj8MrqQSosp_bOm5aHfSNknBk', 'ramaagrotech-65695.firebaseapp.com', 'ramaagrotech-65695', 'ramaagrotech-65695.appspot.com', '93134539784', '1:931345397847:web:244711a0edfcb950384b12', 'G-RNSPWDX5FP', 1, 1, 1, 1, '[\"1\",\"2\",\"20\"]', '[\"2\",\"3\",\"35\"]', '[\"5\",\"10\",\"50\"]', '[\"10\",\"20\",\"100\"]', 1, 1, 1, 0, 0, 'Welcome to Sakshi Hair & Beauty Salon, your ultimate destination for exceptional beauty care and rejuvenation. At Sakshi Salon, we understand that beauty is more than just skin deep—it’s a reflection of how you feel inside. Our mission is to help you feel confident, refreshed, and beautiful every day.', 'rzp_test_HTD2QHstWRUnXj', 'Gcssf0cBaHIIPBZ2TzCWLt53', '#', '#', '#', '#', 'https://maps.app.goo.gl/YHCE9fzv22FmmtEx6', 'mail', 'mail.ramaagrotech.in', 'no-reply@ramaagrotech.in', '?U+V-nAeDsy5', '465', 'ssl', 'santuxsangit2004@gmail.com', 'Saikat9153@@', '413102', '
1)
2)
3)
', 2, 1, '', '#', '#', '#', 0, 1, '', '', '7865939447');
-- --------------------------------------------------------
--
-- 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', '
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.
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
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.
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.
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
Facial Scrub is Natural Care
Duis quis odio quis dui sagittis laoreet.
Suspendisse tempus felis a libero mollis ultrices.
Lorem ipsum dolor sit amet, consectetur adipiscing elit.
Suspendisse tempus felis a libero mollis ultrices.
Proin sit amet diam et elit dictum sodales.
', '/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', '
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.
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
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.
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.
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
Facial Scrub is Natural Care
Duis quis odio quis dui sagittis laoreet.
Suspendisse tempus felis a libero mollis ultrices.
Lorem ipsum dolor sit amet, consectetur adipiscing elit.
Suspendisse tempus felis a libero mollis ultrices.
Proin sit amet diam et elit dictum sodales.
', '/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', '
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.
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
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.
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.
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
Facial Scrub is Natural Care
Duis quis odio quis dui sagittis laoreet.
Suspendisse tempus felis a libero mollis ultrices.
Lorem ipsum dolor sit amet, consectetur adipiscing elit.
Suspendisse tempus felis a libero mollis ultrices.
Proin sit amet diam et elit dictum sodales.
', '/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', '
Where to find demo content for your WordPress website
Image Source: kpgolfpro – Pixabay.com / License: CC0 Public Domain
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.
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 real content.
Publishing Posts, Pages, Categories…
Creating sample posts (Sample Post 1, 2, 3…), sample categories (Category A, B, C…) and sample pages (Home, Archive, Contact…) 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 Lorem Ipsum text into your articles.
Uploading featured images
When it comes to images, most WordPress themes nowadays make use of featured images. 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.
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: 10 Image Sources For Your WordPress Website Or Blog.
Image Source: Unsplash – Pixabay.com / License: CC0 Public Domain
2 – Import demo content with XML files
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 Tools => Import and then select WordPress to install the WordPress Importer plugin.
In case you don\'t have a demo content XML file, you could for example use the WordPress.org theme unit test data which is often also being used by WordPress developers to test the output of their WordPress themes.
Important: 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.
If you\'re using WordPress themes by MH Themes, 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 theme documentation of your particular WordPress theme.
3 – WordPress plugins for sample content
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. FakerPress or WP Example Content. 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.
Conclusion: Choosing the best approach for demo content
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.
Image Source: annca – Pixabay.com / License: CC0 Public Domain
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.
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 magazine website 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.
An \"About Us\" Page is where you reveal your brand story, business values, mission, and experiences.
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.
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?
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!
Why does your website need an About Us page?
Well, benefits of about us page are many. 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.
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.
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.
Your About Us page ideas 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.
Some Incredible About Us Page Examples
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.
So how can you design a compelling \"About Us\" page by following the About Us page best practices 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.
So, have a look at these About Us page examples of organizations who got it right.
', '', '', '', 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, '
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
Cares for dry, frizzy & 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
Olive oil, known to be rich in Vitamin E and antioxidants, moisturises hair, and prevents scalp irritation, giving strong and nourished hair
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
Green tea, rich in anti-fungal and anti-inflammatory properties, improves hair health and adds shine to damaged, dyed and chemically treated hair
Straight, curly, thin, thick, fine, textured hair - this light & non-sticky hair oil is suitable for all hair types. Can also be used for after hair wash styling
', 'Pcs', '', '', '
Is Discontinued By Manufacturer : No
Package Dimensions : 21.9 x 8.4 x 5.6 cm; 285.76 Grams
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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.
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!
Be it cool or warm, get consistent results every time on any hair type!
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!
Be it cool or warm, get consistent results every time on any hair type!
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! Be it cool or warm, get consistent results every time on any hair type!
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
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.
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.
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.
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.
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.
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.
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
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.
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.
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.
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.
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.
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.
Color-treated hair can fade and lose its luster over time. Inspired by nature\'s fade-defying orchid, The Matrix Biol age 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*.
Color-treated hair can fade and lose its luster over time. Inspired by nature\'s fade-defying orchid, The Matrix Biol age 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*.
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.
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 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.
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.
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.
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.
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
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.
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.
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 worse. Prolong hair lifespan and treat hair loss right at the root with the Matrix Biol-age Scalp-sync Aminexil. Trusted by professionals, Scalp-sync Aminexil is a hair fall treatment has anti-hair loss efficacy, proven under dermatological control.
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.
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.
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.
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.
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.
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.
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.
VLCC Gold Facial Kit nourishes & 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.
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.
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.
', '', '', '', 'core-facial'),
(33, 0, 'The AGE smart Facial', '/uploads/1662027108_c5bc50703a1e8e754bba.jpeg', '
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.
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.
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.
', '', '', '', 'shiner-bleach'),
(36, 0, ' Full Body Bleach ', '/uploads/1662028287_7bb0d0be71c419395bf9.jpeg', '
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.
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.
', '', '', '', 'hair-thermal-treatment'),
(38, 0, 'Neck and Shoulder + Head Massage', '/uploads/1663576597_85964c7879a6a80e8d51.jpg', '
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.
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!
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.
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.
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.
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.
', '', '', '', 'heena-hair-colour-application'),
(44, 0, 'Nude make up ', '/uploads/1663576869_e26d0dd5e21957bde372.jpg', '
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.
', '', '', '', 'nude-make-up'),
(45, 0, 'Day Party Make Up', '/uploads/1663576905_9ff5bf2b3e056dd6eb7b.jpg', '
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 .
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 .
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.
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.
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.
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.
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
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.
', '', '', '', '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, '
About us
Welcome!
Sakshi salon & Academy was founded in the year 2019 by Sakshi kharat.
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.
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.
Our Bridal Studio & Makeup Academy headed by Mrs. Sakshi Kharat, who is the first generation in taking Sakshi ahead caters to Brides & Students from all over India.
');
-- --------------------------------------------------------
--
-- 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 `users`
--
CREATE TABLE `users` (
`user_id` int(11) NOT NULL,
`user_name` varchar(500) NOT NULL,
`user_slug` varchar(500) NOT NULL,
`user_password` varchar(500) NOT NULL,
`user_mobile` varchar(50) NOT NULL,
`user_email` varchar(255) NOT NULL,
`user_role` varchar(500) NOT NULL,
`user_session_id` varchar(500) NOT NULL,
`user_token` varchar(500) NOT NULL,
`user_login_type` varchar(500) NOT NULL,
`user_status` varchar(8) NOT NULL,
`user_image` varchar(500) DEFAULT NULL,
`user_stock_point_name` varchar(500) NOT NULL,
`user_address` text NOT NULL,
`user_stock_point_code` varchar(500) NOT NULL,
`user_pin_code` text NOT NULL,
`user_gst` int(1) DEFAULT 1,
`created_at` date DEFAULT NULL,
`is_employee` int(1) NOT NULL DEFAULT 0,
`user_added_by` int(11) NOT NULL,
`emp_commission` int(1) NOT NULL DEFAULT 0
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci;
--
-- Dumping data for table `users`
--
INSERT INTO `users` (`user_id`, `user_name`, `user_slug`, `user_password`, `user_mobile`, `user_email`, `user_role`, `user_session_id`, `user_token`, `user_login_type`, `user_status`, `user_image`, `user_stock_point_name`, `user_address`, `user_stock_point_code`, `user_pin_code`, `user_gst`, `created_at`, `is_employee`, `user_added_by`, `emp_commission`) VALUES
(1, 'Santosh', '', 'D74FF0EE8DA3B9806B18C877DBF29BBDE50B5BD8E4DAD7A3A725000FEB82E8F1', '9933003479', 'super_admin@gmail.com', 'Super Admin', '178601273', '!g{@$@pm#*jD5*ZbvjtB/pfKWNc5s4;RwxdGN3eWNLBnOD+@b*OP(2|dy&w^XXj]JV(NwO44btUM(HE2;', '', 'Active', NULL, '', '', '', '0', 1, NULL, 0, 0, 0),
(2, 'Naon', '', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', '7507253338', 'dalanmaharashtrache@gmail.com', 'Admin', '814886350', '7[5L]?yA))gVq|hhbWjXsE&a^bvJ&FM9FZGUWQtV#4P^PGG68Cu|3go7TJD$2dHDM3%kfzv#bNoh{#YOh', '', 'Active', '/uploads/1661246068_a56e7cfba9a50eb455fd.png', '', '', '', '0', 1, NULL, 0, 0, 0),
(39, 'Nitin Dnyandev Bhujbal', 'nitin-dnyandev-bhujbal', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', '9960836343', 'bhujbalnd@gmail.com', 'User', '', 'T6yvAT^AA)*4*w$s&OIAbO2ZD/WR2%{=7x/3j28xFm#VGugqn*=;KHK&[6s{Wz24CZByH|QUu/?=j7Wqd', '', 'Active', NULL, 'Nitin Dnyandev Bhujbal', 'A/p-Varkute-BK,Loni Devkar,Tal-Indapur,Dist-Pune', 'RADH101', '0', 1, '2022-02-01', 0, 0, 0),
(529, 'Saikat Majumder', '', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', '7898745896', 'saikat@gmail.com', 'User', '', 'QSwrbSk)EPI&ShCxV[Q%MIR@UWGsyM6&o?[jH1WpOIca]G9TT&(T1*40Un*Z;TQF]5wArf$h#BnYfdUTe', '', 'Active', '/uploads/1652169518_b6b74d5db852d3c58516.png', '', 'Duan, , Antala, West Midnapore, West Bengal', '', '721124', 1, '2022-04-29', 0, 0, 0),
(530, 'Radha Store', 'The-Cake-Corner', '453bbe005ba7ecc3370f7d9a4628afe88fd4c745d48eb093ea410710a02137e6', '8999044480', 'training.santosh@gmail.com', 'Stock Point', '', 'yBxCrliG|&WGY48pqC)?Tw@Kj/(iclPGb![!k(u%Qz6EiCAAJV[Ydsd8?zFOY0SF&(C(XvscEBGCrfvh4', '', 'Active', NULL, 'The Cake Corner', 'City IN Chowk MIDC', '', '[\"413102\",\"413133\"]', 1, '2022-05-02', 0, 0, 0),
(532, 'Rajib Das', '', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', '7456987458', 'rajib@gmail.com', 'User', '', '*wNw{2CoC5[OkFN3a3VXJyBh;xa=JTG[LFy64@]iWJR6NOQ1|H!@uCr9BA!OyNCjEdLuLtV%tPZ^A;%Ky', '', 'Active', NULL, '', '', '', '', 1, '2022-05-04', 0, 0, 0),
(534, 'Sambhu das', 'Sambhu-das', 'b225e6da24f7fd9239d6a0ecc3448025c700baf09abedbca49dc4bfcc4891ba9', '7845698748', 'sambhu@gmail.com', 'Sale Executive', '', '!GbMTdX/UWb*M1W)UI%T81s2MetDG7Juj7LIsBV?N|Awu5laJyP#g^qr(URroOK|Bf1s/e6moyJ00KnAl', '', 'Active', NULL, '', 'Duan', '', '', 1, '2022-05-12', 1, 2, 0),
(535, 'Test', '', '03803dc74d4aa2c0b31b807310babb0d579e559252f81f5b28dfbadbab97ad6c', '7865987458', '', 'User', '', '', '', 'Active', NULL, '', '', '', '', 1, NULL, 0, 0, 0),
(536, 'Sabuj Das', 'Sabuj-Das', 'c7dd834701bd523160608832f465efefe1fe209732d6eece4149e25a878606bd', '7869870025', 'sabuj@gmail.com', 'Sale Executive', '', '4EiNOwY=@qHz8T&xWuP?P$M+eL[@i[u9gC(l+?;o#5yd=#XhRSfn]$r7V1b{u]ukMr+FvAOVT}R^lmCk;', '', 'Active', NULL, '', '', '', '', 1, '2022-05-12', 1, 496, 0),
(537, 'Ranjan Das', 'Ranjan-Das', 'd6431e810273a0fef240ed02298888c0ba14c9a47d2eab2cbcd3503ae9e536b0', '8945698745', 'ranjan@gmail.com', 'Delivery Boy', '', 'I88cw&AAXH))qju3pK)G)Pj((A+as(h6(HSI;i4h|+P=+7)fezxe@CR=WKp0gnWqaEGrvTt%Avk]7uu0q', '', 'Active', NULL, '', 'Duan', '', '', 1, '2022-05-12', 1, 2, 1),
(538, 'Sagar Das', 'Sagar-Das', '444a4e1984c329c59a017d1d8951eb7b5c4b36a960cd6549af0508a9880137e4', '8945698520', 'sagar@gmail.com', 'Delivery Boy', '', '', '', 'Active', NULL, '', '', '', '', 1, '2022-05-12', 1, 496, 1),
(539, 'Sagar Mandal', '', '3099b2ab187463ba9fd4e3bf7472a4a4e054be8b063972d9640bdeba9e184b3f', '8945874580', '', 'User', '', '', '', 'Active', NULL, '', '', '', '', 1, NULL, 0, 0, 0),
(540, 'Raghab Das', '', 'c1fa798dfeffd4a36520123a6e4ca49c08077edb446e813cf6027a95d60b1d6e', '8948569870', '', 'User', '', '', '', 'Active', NULL, '', '', '', '', 1, NULL, 0, 0, 0),
(541, 'Ranjit', 'ranjit', '3bbca0a070de227e23a441a67cca507dd09a7fe9e73af3e142014aa6398a1405', '7865002584', 'ranjit@gmail.com', 'User', '', 'lD6MA*Y@(=I2]CXwf)=}4##}rYt4xLFR}#xh6S9Y8$*4jOun)B1C|d&s2|#dHY2@^&?qCV1u2K(XSqYJI', '', 'Active', NULL, '', 'Duan, , Antala, West Midnapore, West Bengal', '', '721124', 1, '2022-05-12', 0, 0, 0),
(542, 'Sangit Majumder', '', '1f03bb83deab709ed7f6e96a29fd5c7add80f9262b3aafc55e81643d7223dc5c', '8945256587', 'sangit@gmail.com', 'User', '', '', '', 'Active', NULL, '', 'Duan, , Antala, West Midnapore, West Bengal', '', '721124', 1, '2022-06-03', 0, 0, 0),
(543, 'Raju Samanta', 'raju-samanta', 'edbcebbdaabb427175bf18e02da6e2207db14b1ac1914c2eefcdd4c4d5b6b91b', '8974563258', 'raju.samanta@gmail.com', 'Delivery Boy', '', 'H+DT^!2Z/i*(uCAq=Yiw?lXu/d*X^]@7XHX(&h9$Yg@34/jf{l?mKQvI|#1^)jja8HAbZW[eL@fu9Fbjq', '', 'Active', '/uploads/1654254755_f8f74a90641a4e2ce034.png', '', '', '', '', 1, '2022-06-03', 1, 530, 1),
(544, 'Swapan Majumder', '', 'd74ff0ee8da3b9806b18c877dbf29bbde50b5bd8e4dad7a3a725000feb82e8f1', '8974545896', 'swapan@gmail.com', 'User', '', 'xUK/M|e{z1ixctzTX3]Vnnw*pIx@TzaqDSeS}cKU=^he]+$wNUcyxRg@4&p9&UnL%jF;{SR&[I1[M^umm', '', 'Active', NULL, '', 'Duan, , Darra, West Midnapore, West Bengal', '', '721124', 1, '2022-06-04', 0, 0, 0),
(545, 'Naon', '', 'cc522f1e8ce2951649c53cbe43d925a78cf11493f22067dfb79ba481aeed026d', '09321688687', 'dalanmaharashtrache@gmail.com', 'User', '', '', '', 'Active', NULL, '', 'Bbb, , Dahisar, Thane, Maharashtra', '', '400612', 1, '2024-07-04', 0, 0, 0),
(546, 'Saikat Majumder', '', '5b93db32f46677f9cbd1e6559e910442571fbe2c7a239f8c6af0f069a7bbd3fe', '7865939449', 'santosh@gmail.com', 'Student', '', '', '', 'Active', NULL, '', 'Duan', '', '', 1, '2024-08-31', 0, 0, 0),
(547, 'Saikat Majumde', '', '', '7865939449', '', '', '', '', '', '', NULL, '', '', '', '', 1, NULL, 0, 0, 0),
(548, 'Saikat Majumder', '', '', '7865939448', '', '', '', '', '', '', NULL, '', '', '', '', 1, NULL, 0, 0, 0);
-- --------------------------------------------------------
--
-- Table structure for table `user_order_address`
--
CREATE TABLE `user_order_address` (
`user_order_address_id` int(11) NOT NULL,
`user_order_address_user_id` int(11) NOT NULL,
`user_order_address_address` varchar(500) NOT NULL,
`user_order_address_address_2` varchar(500) NOT NULL,
`user_order_address_area` varchar(500) NOT NULL,
`user_order_address_dist` varchar(500) NOT NULL,
`user_order_address_state` varchar(500) NOT NULL,
`user_order_address_pin` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
--
-- Dumping data for table `user_order_address`
--
INSERT INTO `user_order_address` (`user_order_address_id`, `user_order_address_user_id`, `user_order_address_address`, `user_order_address_address_2`, `user_order_address_area`, `user_order_address_dist`, `user_order_address_state`, `user_order_address_pin`) VALUES
(10, 544, 'Duan', '', 'Antala', 'West Midnapore', 'West Bengal', '721124'),
(11, 530, 'Jalochi', 'Jalochi', 'Baramati', 'Pune', 'Maharashtra', '413102'),
(12, 545, 'Bbb', '', 'Dahisar', 'Thane', 'Maharashtra', '400612');
-- --------------------------------------------------------
--
-- 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 dumped tables
--
--
-- Indexes for table `application_setting`
--
ALTER TABLE `application_setting`
ADD PRIMARY KEY (`id`);
--
-- 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 `users`
--
ALTER TABLE `users`
ADD PRIMARY KEY (`user_id`);
--
-- Indexes for table `user_order_address`
--
ALTER TABLE `user_order_address`
ADD PRIMARY KEY (`user_order_address_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 dumped tables
--
--
-- AUTO_INCREMENT for table `application_setting`
--
ALTER TABLE `application_setting`
MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- 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 `users`
--
ALTER TABLE `users`
MODIFY `user_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=549;
--
-- AUTO_INCREMENT for table `user_order_address`
--
ALTER TABLE `user_order_address`
MODIFY `user_order_address_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- 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;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
![\"WordPress](\"https://mhthemes.com/wp-content/uploads/2016/06/WordPress_Demo_Content.jpg\")
![\"Creating](\"https://mhthemes.com/wp-content/uploads/2016/06/Creating_Sample_Content.jpg\")
![\"Workspace](\"https://mhthemes.com/wp-content/uploads/2016/06/Workspace_Laptop.jpg\")
![\"Tips](\"https://www.webdew.com/hubfs/Web-images/tips-to-create-about-us-pages.webp\")
![\"6](\"https://www.webdew.com/hubfs/6-tricks-to-create-professional-website-1.svg\")