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

START TRANSACTION;



--
-- Database: `blackwood`
--

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

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

CREATE TABLE `blog` (
  `id` int(11) NOT NULL,
  `bl_ct_id` int(11) DEFAULT NULL,
  `bl_name` varchar(255) DEFAULT NULL,
  `bl_url` varchar(255) DEFAULT NULL,
  `bl_image` varchar(255) DEFAULT NULL,
  `bl_video` varchar(255) DEFAULT NULL,
  `bl_desc` text DEFAULT NULL,
  `bl_post_date` date DEFAULT NULL,
  `bl_view_counter` int(11) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `blog` (`id`, `bl_ct_id`, `bl_name`, `bl_url`, `bl_image`, `bl_video`, `bl_desc`, `bl_post_date`, `bl_view_counter`, `created_at`, `updated_at`) VALUES
(1, 1, 'Blog - 01', 'blog-01', 'untitled_43920.png', 'https://www.youtube.com/embed/XY-hzt-MSMg', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).', '2020-03-05', 535, '2020-03-06 06:43:45', '2020-03-06 06:43:45'),
(2, 2, 'Blog - 02', 'blog-02', 'blog2.jpg', NULL, 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).', '2020-03-23', 584, '2020-03-06 06:43:45', '2020-03-06 06:43:45'),
(3, 3, 'Blog - 03', 'blog-03', 'blog3.jpg', 'https://www.youtube.com/embed/XY-hzt-MSMg', 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).', '2020-04-09', 536, '2020-03-06 06:43:45', '2020-03-06 06:43:45'),
(4, 3, 'Blog - 04', 'blog-04', 'original-foam-gallery-5_63982.jpg', NULL, 'It is a long established fact that a reader will be distracted by the readable content of a page when looking at its layout. The point of using Lorem Ipsum is that it has a more-or-less normal distribution of letters, as opposed to using \'Content here, content here\', making it look like readable English. Many desktop publishing packages and web page editors now use Lorem Ipsum as their default model text, and a search for \'lorem ipsum\' will uncover many web sites still in their infancy. Various versions have evolved over the years, sometimes by accident, sometimes on purpose (injected humour and the like).', '2020-05-13', 569, '2020-03-17 12:06:05', '2020-03-17 12:06:05');

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

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

CREATE TABLE `blog_category` (
  `id` int(11) NOT NULL,
  `bl_ct_name` varchar(255) DEFAULT NULL,
  `bl_ct_url` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `blog_category` (`id`, `bl_ct_name`, `bl_ct_url`) VALUES
(1, 'Fashion', 'fashion'),
(2, 'Life Style', 'life-style'),
(3, 'Health & Fitness', 'health-fitness'),
(4, 'Care & Beauty', 'care-beauty');

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

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

CREATE TABLE `brand` (
  `id` int(11) NOT NULL,
  `br_name` varchar(200) DEFAULT NULL,
  `br_image` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `brand` (`id`, `br_name`, `br_image`) VALUES
(1, 'Sherrol', '069_31359.jpg');

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

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

CREATE TABLE `category` (
  `id` int(11) NOT NULL,
  `ct_parent_id` int(11) NOT NULL DEFAULT 0,
  `ct_gu_id` int(11) DEFAULT NULL,
  `ct_name` varchar(200) DEFAULT NULL,
  `ct_url` varchar(255) DEFAULT NULL,
  `ct_image` varchar(200) DEFAULT NULL,
  `ct_ban_txt` text DEFAULT NULL,
  `ct_seo_title` varchar(200) DEFAULT NULL,
  `ct_seo_keys` varchar(300) DEFAULT NULL,
  `ct_seo_desc` varchar(500) DEFAULT NULL,
  `ct_status` tinyint(2) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `category` (`id`, `ct_parent_id`, `ct_gu_id`, `ct_name`, `ct_url`, `ct_image`, `ct_ban_txt`, `ct_seo_title`, `ct_seo_keys`, `ct_seo_desc`, `ct_status`) VALUES
(1, 0, 0, 'Women Outfits', 'women-outfits', 'men-collection_11767.jpg', 'New Arrivals', NULL, NULL, NULL, 1),
(2, 0, 0, 'Men\'s Outfits', 'mens-outfits', 'women-collection_15629.jpg', 'Casual wear', NULL, NULL, NULL, 2),
(3, 0, 0, 'Bride & Grooms Match Outfit', 'bride-grooms-match-outfit', 'kid-collection_79737.jpg', 'Plus Size', NULL, NULL, NULL, 1),
(4, 1, NULL, 'Bridal Outfits', 'women-outfits/bridal-outfits', '', NULL, NULL, NULL, NULL, 1),
(5, 1, NULL, 'Women Western Outfits', 'women-outfits/women-western-outfits', '', NULL, NULL, NULL, NULL, 1),
(6, 2, NULL, 'Groom\'s Outfits', 'mens-outfits/grooms-outfits', '', NULL, NULL, NULL, NULL, 2),
(7, 2, NULL, 'Men\'s Indo Western', 'mens-outfits/mens-indo-western', '', NULL, NULL, NULL, NULL, 2),
(8, 2, NULL, 'Men\'s Ethnic', 'mens-outfits/mens-ethnic', '', NULL, NULL, NULL, NULL, 2),
(9, 2, NULL, 'Men\'s Suits', 'mens-outfits/mens-suits', '', NULL, NULL, NULL, NULL, 2),
(10, 0, NULL, 'Jewellary', 'jewellary', '', 'Jeans & Denims', NULL, NULL, NULL, 1),
(12, 3, NULL, 'Lehanga & Sherwani', 'bride-grooms-match-outfit/lehanga-sherwani', '', NULL, NULL, NULL, NULL, 1),
(13, 10, NULL, 'Men\'s Ethnics', 'jewellary/mens-ethnics', '', NULL, NULL, NULL, NULL, 1),
(17, 16, NULL, 'Dress', 'trendy/august/dress', '', NULL, NULL, NULL, NULL, 1),
(18, 16, NULL, 'Trouser', 'trendy/august/trouser', '', NULL, NULL, NULL, NULL, 1),
(19, 3, NULL, 'Suit & Sherwani', 'bride-grooms-match-outfit/suit-sherwani', '', NULL, NULL, NULL, NULL, 1),
(20, 3, NULL, 'Sharara & Sherwani', 'bride-grooms-match-outfit/sharara-sherwani', '', NULL, NULL, NULL, NULL, 1),
(21, 3, NULL, 'Bridal Saree & Sherwani', 'bride-grooms-match-outfit/bridal-saree-sherwani', '', NULL, NULL, NULL, NULL, 1),
(22, 3, NULL, 'Suits & Dresses', 'bride-grooms-match-outfit/suits-dresses', '', NULL, NULL, NULL, NULL, 1),
(23, 0, NULL, 'Pre-Owned Brands', 'pre-owned-brands', '', 'Clothing for sale', NULL, NULL, NULL, 2),
(24, 0, NULL, 'Kid\'s Collection', 'kids-collection', '', 'Shoes', NULL, NULL, NULL, 2),
(25, 0, NULL, 'Rented Clearance Sales', 'rented-clearance-sales', '', 'Hand Bags', NULL, NULL, NULL, 2),
(26, 0, NULL, 'Hand Bags', 'hand-bags', '', 'Hand Bags', NULL, NULL, NULL, 1),
(27, 3, NULL, 'Palazzos  & Pyjama', 'bride-grooms-match-outfit/palazzos-pyjama', '', NULL, NULL, NULL, NULL, 2),
(28, 10, NULL, 'Men\'s Western Wear', 'jewellary/mens-western-wear', '', NULL, NULL, NULL, NULL, 1),
(29, 10, NULL, 'Men\'s Indo Western', 'jewellary/mens-indo-western', '', NULL, NULL, NULL, NULL, 1),
(30, 10, NULL, 'Kurta Set', 'jewellary/kurta-set', '', NULL, NULL, NULL, NULL, 1),
(31, 10, NULL, 'Waist Coat Collection', 'jewellary/waist-coat-collection', '', NULL, NULL, NULL, NULL, 1),
(32, 10, NULL, 'Pathani Set', 'jewellary/pathani-set', '', NULL, NULL, NULL, NULL, 1),
(33, 10, NULL, 'Men\'s Jutti', 'jewellary/mens-jutti', '', NULL, NULL, NULL, NULL, 1),
(34, 2, NULL, 'Kurta Pyjama Set', 'mens-outfits/kurta-pyjama-set', '', NULL, NULL, NULL, NULL, 2),
(35, 2, NULL, 'Men\'s vest', 'mens-outfits/mens-vest', '', NULL, NULL, NULL, NULL, 2),
(36, 0, NULL, 'Jewellery', 'jewellery', '', 'Accessories', NULL, NULL, NULL, 2),
(37, 2, NULL, 'Men\'s Pathani Suits', 'mens-outfits/mens-pathani-suits', '', NULL, NULL, NULL, NULL, 2),
(38, 2, NULL, 'Jumpsuits & Kimonos', 'mens-outfits/jumpsuits-kimonos', '', NULL, NULL, NULL, NULL, 2),
(39, 2, NULL, 'Others', 'mens-outfits/others', '', NULL, NULL, NULL, NULL, 2),
(40, 3, NULL, 'T Shirt & Swear Shirt', 'bride-grooms-match-outfit/t-shirt-swear-shirt', '', NULL, NULL, NULL, NULL, 2),
(41, 3, NULL, 'Active & Workout', 'bride-grooms-match-outfit/active-workout', '', NULL, NULL, NULL, NULL, 2),
(42, 3, NULL, 'Jumpsuits & Kimonos', 'bride-grooms-match-outfit/jumpsuits-kimonos', '', NULL, NULL, NULL, NULL, 2),
(43, 0, NULL, 'Footwear', 'footwear', '', NULL, NULL, NULL, NULL, 1),
(44, 1, NULL, 'Women Sarees', 'women-outfits/women-sarees', '', NULL, NULL, NULL, NULL, 1),
(45, 1, NULL, 'Women Suits', 'women-outfits/women-suits', '', NULL, NULL, NULL, NULL, 1),
(46, 1, NULL, 'Women Sharara', 'women-outfits/women-sharara', '', NULL, NULL, NULL, NULL, 1),
(47, 1, NULL, 'Women Footwear', 'women-outfits/women-footwear', '', NULL, NULL, NULL, NULL, 2),
(48, 1, NULL, 'Women Hand Bags', 'women-outfits/women-hand-bags', '', NULL, NULL, NULL, NULL, 2),
(49, 4, NULL, 'Bridal Lehanga', 'women-outfits/bridal-outfits/bridal-lehanga', '', NULL, NULL, NULL, NULL, 1),
(50, 4, NULL, 'Bridal Suit', 'women-outfits/bridal-outfits/bridal-suit', '', NULL, NULL, NULL, NULL, 1),
(51, 4, NULL, 'Bridal Sharara', 'women-outfits/bridal-outfits/bridal-sharara', '', NULL, NULL, NULL, NULL, 1),
(52, 4, NULL, 'Bridal Saree', 'women-outfits/bridal-outfits/bridal-saree', '', NULL, NULL, NULL, NULL, 1),
(53, 4, NULL, 'Bridal Dress', 'women-outfits/bridal-outfits/bridal-dress', '', NULL, NULL, NULL, NULL, 1),
(54, 23, NULL, 'Women\'s Indian Outfits', 'pre-owned-brands/womens-indian-outfits', '', NULL, NULL, NULL, NULL, 2),
(55, 23, NULL, 'Women\'s Western Outfits', 'pre-owned-brands/womens-western-outfits', '', NULL, NULL, NULL, NULL, 2),
(56, 54, NULL, 'Non Bridal Lehanga', 'pre-owned-brands/womens-indian-outfits/non-bridal-lehanga', '', NULL, NULL, NULL, NULL, 2),
(57, 54, NULL, 'Women\'s Suits', 'pre-owned-brands/womens-indian-outfits/womens-suits', '', NULL, NULL, NULL, NULL, 2),
(58, 55, NULL, 'Gown & Dresses', 'pre-owned-brands/womens-western-outfits/gown-dresses', '', NULL, NULL, NULL, NULL, 2),
(59, 55, NULL, 'Tunics', 'pre-owned-brands/womens-western-outfits/tunics', '', NULL, NULL, NULL, NULL, 2),
(60, 13, NULL, 'Male Western Wear', 'jewellary/mens-ethnics/male-western-wear', '', NULL, NULL, NULL, NULL, 1),
(61, 13, NULL, 'Male Ethnic Wear', 'jewellary/mens-ethnics/male-ethnic-wear', '', NULL, NULL, NULL, NULL, 1),
(62, 28, NULL, 'Women\'s Western Wear', 'jewellary/mens-western-wear/womens-western-wear', '', NULL, NULL, NULL, NULL, 1),
(63, 28, NULL, 'Women\'s Ethnic Wear', 'jewellary/mens-western-wear/womens-ethnic-wear', '', NULL, NULL, NULL, NULL, 1),
(64, 43, NULL, 'Western Footwear', 'footwear/western-footwear', '', NULL, NULL, NULL, NULL, 1),
(65, 43, NULL, 'Ethnic Footwear', 'footwear/ethnic-footwear', '', NULL, NULL, NULL, NULL, 1),
(66, 4, NULL, 'Bridal Jewellery', 'women-outfits/bridal-outfits/bridal-jewellery', '', NULL, NULL, NULL, NULL, 1),
(67, 4, NULL, 'Bridal Clutches & Bags', 'women-outfits/bridal-outfits/bridal-clutches-bags', '', NULL, NULL, NULL, NULL, 1),
(68, 6, NULL, 'Groom\'s  Sherwani', 'mens-outfits/grooms-outfits/grooms-sherwani', '', NULL, NULL, NULL, NULL, 2),
(69, 6, NULL, 'Groom\'s Suit', 'mens-outfits/grooms-outfits/grooms-suit', '', NULL, NULL, NULL, NULL, 2),
(70, 6, NULL, 'Groom\'s Indo Western', 'mens-outfits/grooms-outfits/grooms-indo-western', '', NULL, NULL, NULL, NULL, 2),
(71, 6, NULL, 'Groom\'s Kurta Set', 'mens-outfits/grooms-outfits/grooms-kurta-set', '', NULL, NULL, NULL, NULL, 2),
(72, 6, NULL, 'Groom\'s Bandana', 'mens-outfits/grooms-outfits/grooms-bandana', '', NULL, NULL, NULL, NULL, 2),
(73, 6, NULL, 'Groom\'s Safa Pagri', 'mens-outfits/grooms-outfits/grooms-safa-pagri', '', NULL, NULL, NULL, NULL, 2),
(74, 6, NULL, 'Groom\'s Mala', 'mens-outfits/grooms-outfits/grooms-mala', '', NULL, NULL, NULL, NULL, 2),
(75, 6, NULL, 'Groom\'s Brooch', 'mens-outfits/grooms-outfits/grooms-brooch', '', NULL, NULL, NULL, NULL, 2),
(76, 6, NULL, 'Groom\'s Shawl', 'mens-outfits/grooms-outfits/grooms-shawl', '', NULL, NULL, NULL, NULL, 2),
(77, 6, NULL, 'Groom\'s Jutti', 'mens-outfits/grooms-outfits/grooms-jutti', '', NULL, NULL, NULL, NULL, 2),
(78, 77, NULL, 'Kurta Pyjama', 'mens-outfits/grooms-outfits/grooms-jutti/kurta-pyjama', '', NULL, NULL, NULL, NULL, 2),
(79, 77, NULL, 'Haramm', 'mens-outfits/grooms-outfits/grooms-jutti/haramm', '', NULL, NULL, NULL, NULL, 2),
(80, 77, NULL, 'Pathani Set', 'mens-outfits/grooms-outfits/grooms-jutti/pathani-set', '', NULL, NULL, NULL, NULL, 2),
(81, 77, NULL, 'Anarkalli Set', 'mens-outfits/grooms-outfits/grooms-jutti/anarkalli-set', '', NULL, NULL, NULL, NULL, 2),
(82, 77, NULL, 'Kurta with Baloon Pyjama', 'mens-outfits/grooms-outfits/grooms-jutti/kurta-with-baloon-pyjama', '', NULL, NULL, NULL, NULL, 2),
(83, 77, NULL, 'Kurta Pant Set', 'mens-outfits/grooms-outfits/grooms-jutti/kurta-pant-set', '', NULL, NULL, NULL, NULL, 2),
(84, 24, NULL, 'Kid\'s Sherwani', 'kids-collection/kids-sherwani', '', NULL, NULL, NULL, NULL, 2),
(85, 24, NULL, 'Boy\'s Kurta Pyjama Set', 'kids-collection/boys-kurta-pyjama-set', '', NULL, NULL, NULL, NULL, 2),
(86, 24, NULL, 'Boy\'s Western Suit', 'kids-collection/boys-western-suit', '', NULL, NULL, NULL, NULL, 2),
(87, 24, NULL, 'Girl\'s Lehanga', 'kids-collection/girls-lehanga', '', NULL, NULL, NULL, NULL, 2),
(88, 24, NULL, 'Girl\'s Indian Suit', 'kids-collection/girls-indian-suit', '', NULL, NULL, NULL, NULL, 2),
(89, 24, NULL, 'Girl\'s Western Outfit', 'kids-collection/girls-western-outfit', '', NULL, NULL, NULL, NULL, 2),
(90, 55, NULL, 'Indian Outfits', 'pre-owned-brands/womens-western-outfits/indian-outfits', '', NULL, NULL, NULL, NULL, 2),
(91, 55, NULL, 'Sarees', 'pre-owned-brands/womens-western-outfits/sarees', '', NULL, NULL, NULL, NULL, 2),
(92, 55, NULL, 'Shirt & Trousers', 'pre-owned-brands/womens-western-outfits/shirt-trousers', '', NULL, NULL, NULL, NULL, 2),
(93, 10, NULL, 'Pagri Collection', 'jewellary/pagri-collection', '', NULL, NULL, NULL, NULL, 1),
(94, 54, NULL, 'Saree', 'pre-owned-brands/womens-indian-outfits/saree', '', NULL, NULL, NULL, NULL, 2),
(95, 4, NULL, 'Bridal Footwear', 'women-outfits/bridal-outfits/bridal-footwear', '', NULL, NULL, NULL, NULL, 1),
(96, 5, NULL, 'Women Dresses', 'women-outfits/women-western-outfits/women-dresses', '', NULL, NULL, NULL, NULL, 1),
(97, 5, NULL, 'Women Gowns', 'women-outfits/women-western-outfits/women-gowns', '', NULL, NULL, NULL, NULL, 1),
(98, 0, NULL, 'Renting', 'renting', 'cat-1_29011.jpg', 'Renting Made Easy with Sherrol', 'renting', NULL, NULL, 1);

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

--
-- Table structure for table `colour`
--

CREATE TABLE `colour` (
  `id` int(11) NOT NULL,
  `cl_name` varchar(200) DEFAULT NULL,
  `cl_hex` varchar(50) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `colour`
--

INSERT INTO `colour` (`id`, `cl_name`, `cl_hex`) VALUES
(2, 'Black', '#000000'),
(3, 'White', '#FFFFFF'),
(4, 'Blue', '#0000FF'),
(5, 'Navy Blue', '#000080'),
(6, 'Pink', '#FFC0CB'),
(7, 'Red', '#FF0000'),
(8, 'Green', '#00FF00'),
(9, 'Off White', '#FFFAF5'),
(10, 'Grey', '#C0C0C0'),
(11, 'Yellow', '#FFFF00'),
(12, 'Mustard', '#E1AD01'),
(13, 'Peach', '#FFDAB9'),
(14, 'Maroon', '#800000'),
(15, 'Olive', '#808000'),
(16, 'Beige', '#F5F5DC'),
(17, 'Coral', '#FF7F50'),
(18, 'Orange', '#FF6347'),
(19, 'Grey Melange', '#808080'),
(20, 'Burgundy', '#800020'),
(21, 'Rust', '#B7410E'),
(22, 'Brown', '#D2691E'),
(23, 'Cream', '#FFFDD0'),
(24, 'Charcoal', '#36454F'),
(25, 'Purple', '#9400D3'),
(26, 'Teal', '#008080'),
(27, 'Sea Green', '#2E8B57'),
(28, 'Lavender', '#E6E6FA'),
(29, 'Mauve', '#E0B0FF'),
(30, 'Turquoise Blue', '#40E0D0'),
(31, 'Magenta', '#FF00FF'),
(32, 'Lime Green', '#00FF00'),
(33, 'Taupe', '#483C32'),
(34, 'Gold', '#FFD700'),
(35, 'Silver', '#C0C0C0'),
(36, 'Nude', '#E3BC9A'),
(37, 'Fluorescent Green', '#83F52C'),
(38, 'Khaki', '#F0E68C'),
(39, 'Coffee Brown', '#593C1F'),
(40, 'Rose', '#FF007F'),
(41, 'Tan', '#D2B48C'),
(42, 'Copper', '#B87333'),
(43, 'Metallic', '#AAA9AD'),
(44, 'Bronze', '#CD7F32'),
(45, 'Skin', '#ECBCB4');

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

--
-- Table structure for table `company_info`
--

CREATE TABLE `company_info` (
  `id` int(11) NOT NULL,
  `comp_url` varchar(100) DEFAULT NULL,
  `comp_email1` varchar(100) DEFAULT NULL,
  `comp_email2` varchar(100) DEFAULT NULL,
  `comp_delivery_fee` varchar(255) DEFAULT NULL,
  `comp_contact1` varchar(20) DEFAULT NULL,
  `comp_contact2` varchar(20) DEFAULT NULL,
  `comp_address` varchar(300) DEFAULT NULL,
  `comp_map` text DEFAULT NULL,
  `comp_sm1` varchar(300) DEFAULT NULL,
  `comp_sm2` varchar(300) DEFAULT NULL,
  `comp_sm3` varchar(300) DEFAULT NULL,
  `comp_sm4` varchar(300) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `company_info`
--

INSERT INTO `company_info` (`id`, `comp_url`, `comp_email1`, `comp_email2`, `comp_delivery_fee`, `comp_contact1`, `comp_contact2`, `comp_address`, `comp_map`, `comp_sm1`, `comp_sm2`, `comp_sm3`, `comp_sm4`) VALUES
(1, 'http://sherrol.com/', 'contact@sherrol.com', NULL, NULL, '9311444690', NULL, 'Ritz Fashion Pvt. Ltd., B-76, Sector-80, Noida Phase-II, Uttar Pradesh-201305', '<iframe src=\"https://www.google.com/maps/embed?pb=!1m16!1m12!1m3!1d7009.0900710244105!2d77.40119857273258!3d28.553391803732456!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!2m1!1sB-76%2C%20Sector-80%2C%20Noida%20Phase-II%2C%20Uttar%20Pradesh-201305!5e0!3m2!1sen!2sin!4v1594213392399!5m2!1sen!2sin\" width=\"600\" height=\"465\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>', 'https://www.facebook.com/', 'https://www.instagram.com/', 'https://www.youtube.com/', 'https://twitter.com/');

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

--
-- Table structure for table `contact`
--

CREATE TABLE `contact` (
  `id` int(11) NOT NULL,
  `ct_name` varchar(100) DEFAULT NULL,
  `ct_phone` varchar(20) DEFAULT NULL,
  `ct_email` varchar(100) DEFAULT NULL,
  `ct_msg` varchar(1000) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `contact`
--

INSERT INTO `contact` (`id`, `ct_name`, `ct_phone`, `ct_email`, `ct_msg`, `created_at`) VALUES
(186, 'Raymond', '315-893-1352', 'buddicom.raymond@gmail.com', 'Hey \r\n \r\nMeet your best Buds - True Wireless Earbuds with amazing sound, convenience, portability, & affordability!\r\n\r\nOrder yours now at 50% OFF with FREE Shipping: musicontrol.online\r\n \r\nSincerely, \r\n \r\nRaymond\r\nSHERROL | Contact Us', '2021-07-31 12:30:44'),
(187, 'Ana Hemming', '0369 5605215', 'hemming.ana@gmail.com', 'Good morning \r\nThis is the service your top competitors use:\r\nhttps://your-web-marketing.com/backlinks-generator\r\nWith best regards,\r\nWe offer the very best IT services you can order on our online shop for making big money in a small business, still not thinking about getting new business? Here is an easy, 1-click unsubscribe link: https://your-web-marketing.com/?unsubscribe=sherrol.com', '2021-08-01 13:11:18'),
(188, 'Staci', '561-342-4821', 'mileham.staci74@hotmail.com', 'Good Morning \r\n \r\nCAREDOGBEST™ - Personalized Dog Harness. All sizes from XS to XXL.  Easy ON/OFF in just 2 seconds.  LIFETIME WARRANTY.\r\n\r\nClick here: caredogbest.com\r\n \r\nBest regards, \r\n \r\nStaci\r\nSHERROL | Contact Us', '2021-08-03 06:09:48'),
(189, 'Britt Dumont', '05.43.81.83.77', 'britt@bestlocaldata.com', '6 August 2021.\r\n\r\nThis is the last day BestLocalData.com will be online and operate. We are shutting down and all our data is for sale for $99.\r\n\r\nRegards,\r\nBritt', '2021-08-05 02:05:13'),
(190, 'Alfonso', '078 6313 9923', 'alfonso.corby@gmail.com', 'Hi there \r\n \r\nBody Revolution - Medico Postura™ Body Posture Corrector\r\nImprove Your Posture INSTANTLY!\r\n\r\nGet it while it\'s still 60% OFF!  FREE Worldwide Shipping!\r\n\r\nGet yours here: medicopostura.com\r\n \r\nBest regards, \r\n \r\nAlfonso\r\nSHERROL | Contact Us', '2021-08-07 07:34:04'),
(191, 'Buford Larcombe', 'Cgcmm o An', 'larcombe.buford@gmail.com', 'Quick solution for sherrol.com\r\n\r\nHey there, \r\n\r\nCheck your webpage speed. Faster Website = Better Customer Experience, Rank Higher, Get Traffic, Grow your Company. We\'ll make your website so high-speed that your clients will think ”OMG!”\r\n\r\n\r\nHere is the amazing package it’s vital to get phenomenal customers easily:\r\n\r\n\r\nhttps://best-marketers.com/speedup\r\n\r\n\r\nSincerely,\r\nWe offer the very best marketing services you may purchase on our website for making big money in a small business, still not thinking about getting new customers? Here is a simple, 1-click unsubscribe link: https://best-marketers.com/?unsubscribe=sherrol.com', '2021-08-09 16:51:16'),
(192, 'Nichol', '0352 4590870', 'nichol.leist@hotmail.com', 'Get The Worlds Greatest Magic Sand Free Beach Mat!\r\n\r\nWatch sand, dirt & dust disappear right before your eyes! It\'s perfect for beach, picnic, camping or hiking.\r\n\r\nAct Now And Receive A Special Discount For Our Magic Mat!\r\n\r\nGet Yours Here:  magicmat.shop\r\n\r\nThank You, \r\n \r\nNichol\r\nSHERROL | Contact Us', '2021-08-10 13:20:11'),
(193, 'Eric Jones', '555-555-1212', 'eric.jones.z.mail@gmail.com', 'Hello, my name’s Eric and I just ran across your website at sherrol.com...\r\n\r\nI found it after a quick search, so your SEO’s working out…\r\n\r\nContent looks pretty good…\r\n\r\nOne thing’s missing though…\r\n\r\nA QUICK, EASY way to connect with you NOW.\r\n\r\nBecause studies show that a web lead like me will only hang out a few seconds – 7 out of 10 disappear almost instantly, Surf Surf Surf… then gone forever.\r\n\r\nI have the solution:\r\n\r\nTalk With Web Visitor is a software widget that’s works on your site, ready to capture any visitor’s Name, Email address and Phone Number.  You’ll know immediately they’re interested and you can call them directly to TALK with them - literally while they’re still on the web looking at your site.\r\n\r\nCLICK HERE https://talkwithwebvisitors.com to try out a Live Demo with Talk With Web Visitor now to see exactly how it works and even give it a try… it could be huge for your business.\r\n\r\nPlus, now that you’ve got that phone number, with our new SMS Text With Lead featu', '2021-08-11 05:49:04'),
(194, 'Ryan Robinson', '202-991-6766', 'ryan@unitedbusinessloans.xyz', 'Hello,\r\n\r\nI hope life is treating you kind and business is AWESOME!\r\n\r\nI just have one quick question for you.\r\n\r\nWould you consider a Working Capital Loan for your business if the price and terms were acceptable?\r\n\r\nWe offer loans from 10k to 500k regardless of credit or collateral, and will give you a funding decision in less than 30 seconds \r\nwithout pulling your credit or submitting a single document. \r\n\r\nJust click on the link to INSTANTLY see how much you qualify for www.unitedbusinessloans.xyz\r\n\r\n\r\n\r\nWarm Regards,\r\n\r\nRyan Robinson\r\nUnited Business Loans\r\nwww.unitedbusinessloans.xyz\r\n\r\n\r\n\r\n\r\nThis is an Advertisement.\r\nTo unsubscribe, click here www.unitedbusinessloans.xyz/unsubscribe,\r\n\r\nor write to:\r\n\r\nUnited Business Loans\r\n9169 W State St #3242\r\nGarden City, ID 83714', '2021-08-12 23:42:05'),
(195, 'Lemuel', '01.08.63.84.41', 'lemuel.gosse@googlemail.com', 'Hi\r\n\r\nBuy medical disposable face mask to protect your loved ones from the deadly CoronaVirus.  The price is $0.28 each.  If interested, please check our site: pharmacyoutlets.online\r\n\r\nBest,\r\n\r\nLemuel\r\nSHERROL | Contact Us', '2021-08-14 15:49:42'),
(196, 'Darell Doughty', 'Tqxyhcxah', 'darell@sundatagroup.one', 'New data just for you!\r\n\r\nHi, just letting you know you can now select from hundreds of millions of data records in 200+ countries and in various industries. Benefit from it as soon as possible.\r\n\r\nBrowse our databases or request a custom list that suits your needs.\r\n\r\nThere\'s something for everyone.\r\n\r\nHave a look!\r\nhttps://sundatagroup.one', '2021-08-16 12:05:44'),
(197, 'Jared Whisman', '571-215-9266', 'jared.whisman@hotmail.com', 'Tired of Indian marketing? Try German!\r\n\r\nHey there, \r\n\r\nThe three essential elements of an efficient sherrol.com online marketing promotion are technical SEO, good content, and high-quality backlinks, with can help with all of them.\r\n\r\nTry this big plan you should have to accelerate sherrol.com increase in getting unlimited customers online:\r\n	\r\nhttps://it-technicians.com/backlinks-generator\r\n\r\n\r\nSincerely,\r\nWe offer the very best marketing services you may order on our website for making big money in a small business, still not considering getting new clients? Here is a simple, 1-click unsubscribe link: https://it-technicians.com/?unsubscribe=sherrol.com', '2021-08-18 04:41:42'),
(198, 'Clarice', '09452 98 71 94', 'clarice.florey@googlemail.com', 'New Multifunction Anti-theft Waterproof Sling Bag\r\n\r\nThe best ever SUPER Sling Bag: Drop-proof/Anti-theft/Scratch-resistant/USB Charging\r\n\r\n50% OFF for the next 24 Hours ONLY + FREE Worldwide Shipping for a LIMITED time\r\n\r\nBuy now: fashiondaily.online\r\n\r\nTo your success, \r\n\r\nClarice\r\nSHERROL | Contact Us', '2021-08-18 12:43:07'),
(199, 'Dick', '0699 535 07 03', 'dick.lowerson@gmail.com', 'Hey\r\n\r\nBuy medical disposable face mask to protect your loved ones from the deadly CoronaVirus.  The price is $0.28 each.  If interested, please visit our site: pharmacyoutlets.online\r\n\r\nThanks and Best Regards,\r\n\r\nDick', '2021-08-22 02:33:35'),
(200, 'Zachary Cleary', '089 73 09 42', 'zachary@sundatagroup.one', 'Hello.\r\n\r\nNeed leads for your business? We have a limited offer where we sell almost 400 million executives around the world in 165 countries for $299.\r\n\r\nOr you can buy your country individually for $99.\r\n\r\nwww.SunDataGroup.one', '2021-08-22 16:15:24'),
(201, 'Emory Wicks', '06-92968193', 'wicks.emory@msn.com', 'Tired of Indian marketing? Try German!\r\n\r\nPaying attention to your marketing throughout the web is important to stay visible to any potential new customers.\r\n\r\nTo accelerate your sherrol.com efficiently over the web it’s paramount to have  this impressive package:\r\n	\r\nhttps://first-class-promo.com/backlinks-generator\r\n\r\n\r\nWarm regards,\r\nWe offer the very best marketing services you may find on our website for making big money in a small business, still not considering getting new clients? Here is a simple, 1-click unsubscribe link: https://first-class-promo.com/?unsubscribe=sherrol.com', '2021-08-25 11:45:52'),
(202, 'Eric Jones', '555-555-1212', 'eric.jones.z.mail@gmail.com', 'Hi, Eric here with a quick thought about your website sherrol.com...\r\n\r\nI’m on the internet a lot and I look at a lot of business websites.\r\n\r\nLike yours, many of them have great content. \r\n\r\nBut all too often, they come up short when it comes to engaging and connecting with anyone who visits.\r\n\r\nI get it – it’s hard.  Studies show 7 out of 10 people who land on a site, abandon it in moments without leaving even a trace.  You got the eyeball, but nothing else.\r\n\r\nHere’s a solution for you…\r\n\r\nTalk With Web Visitor is a software widget that’s works on your site, ready to capture any visitor’s Name, Email address and Phone Number.  You’ll know immediately they’re interested and you can call them directly to talk with them literally while they’re still on the web looking at your site.\r\n\r\nCLICK HERE https://talkwithwebvisitors.com to try out a Live Demo with Talk With Web Visitor now to see exactly how it works.\r\n\r\nIt could be huge for your business – and because you’ve got that phone numb', '2021-08-26 06:49:26'),
(203, 'Kurtis Villagomez', '(02) 6781 4696', 'kurtis@sundatagroup.one', 'We have an amazing database of leads for you.\r\n\r\nAll countries are $99 and you can buy the entire world 165 countries for $179.\r\n\r\nThis offer is valid till Friday.\r\n\r\nwww.SunDataGroup.one', '2021-08-26 13:55:32'),
(204, 'Ryan Robinson', '202-991-6766', 'ryan@unitedbusinessloans.xyz', 'Hello,\r\n\r\nI hope life is treating you kind and business is AWESOME!\r\n\r\nI just have one quick question for you.\r\n\r\nWould you consider a Working Capital Loan for your business if the price and terms were acceptable?\r\n\r\nWe offer loans from 10k to 500k regardless of credit or collateral, and will give you a funding decision in less than 30 seconds \r\nwithout pulling your credit or submitting a single document. \r\n\r\nJust click on the link to INSTANTLY see how much you qualify for www.unitedbusinessloans.xyz\r\n\r\n\r\n\r\nWarm Regards,\r\n\r\nRyan Robinson\r\nUnited Business Loans\r\nwww.unitedbusinessloans.xyz\r\n\r\n\r\n\r\n\r\nThis is an Advertisement.\r\nTo unsubscribe, click here www.unitedbusinessloans.xyz/unsubscribe,\r\n\r\nor write to:\r\n\r\nUnited Business Loans\r\n9169 W State St #3242\r\nGarden City, ID 83714', '2021-08-26 22:32:20'),
(205, 'Dennis Perpetua', '833-288-8913', 'dennis@qualitybloggeroutreach.com', 'Hello, \r\n\r\nThis is Dennis Perpetua from QGP.com,\r\n\r\nWe’re interested in advertising on your site. \r\n\r\nIs this something you’d be willing to discuss? \r\n\r\n\r\nDennis Perpetua\r\nOutreach Manager\r\nwww.qgp.com\r\n\r\n\r\n\r\nP.S.: If you don\'t want me to contact you again, just let me know.', '2021-08-29 14:35:31'),
(206, 'Shirley Aplin', '070 8572 4026', 'shirley@order-fulfillment.net', 'Hi from Order-Fulfillment.net\r\n\r\nWho would I speak with at your company about any of your order fulfillment and drop shipping needs?\r\n\r\nMy company Order-Fulfillment.net can warehouse, inventory, and manage your drop shipping / order fulfillment for your customer orders.  \r\n\r\nBased in the USA for almost 2 decades, near major USA air and sea ports.\r\n\r\nHere are some of the items we currently pick, pack and ship for clients:\r\n\r\n-Books, training manuals, guides\r\n-New member welcomes boxes and gifts\r\n-Product samples\r\n-Marketing materials\r\n-Medical program test kits\r\n-Follow up gifts to clients, leads, and prospects\r\n\r\nThank you!\r\n\r\nFulfillment Warehouse\r\nOrder-Fulfillment.net\r\nDrop Shipping and Order Fulfillment Specialists since 2003', '2021-08-31 03:40:08'),
(207, 'Eula Shannon', 'J x xw Q', 'eula@sundatagroup.one', 'Hello.\r\n\r\nIt is with sad regret to inform you we are shutting down.\r\n\r\nWe are selling our entire leads database 366,295,395 Companies / Executives. for $179\r\n\r\nAll countries are $99 and you can buy the entire world 165 countries for $179.\r\n\r\nwww.SunDataGroup.one', '2021-09-01 04:44:20'),
(208, 'Angelita', '209-904-9495', 'angelita.mebane89@msn.com', 'Hi there \r\n\r\n50% OFF!! Hurry to get your Baseball Cap Now!\r\n\r\nThese Caps are SO cool! Perfect for this Summer!\r\n\r\nFree worldwide shipping!\r\n\r\nGET IT HERE: capshop.online\r\n\r\nBest, \r\n \r\nAngelita', '2021-09-03 02:25:29'),
(209, 'Modesta', '0521 94 33 13', 'modesta.gether20@gmail.com', 'Color-changing swimshorts \r\n\r\nDive into the ocean and your swimshorts suddenly change color! These swimshorts ara AMAZING!\r\n\r\nHurry! 50% Off Worldwide For Limited Time Only!\r\n\r\nGet it here: coolshorts.online\r\n\r\nCheers, \r\n\r\nModesta', '2021-09-05 15:15:25'),
(210, 'Faith', '0314 5388772', 'faith.munday@googlemail.com', 'Color-changing swimshorts \r\n\r\nDive into the ocean and your swimshorts suddenly change color! These swimshorts ara AMAZING!\r\n\r\nHurry! 50% Off Worldwide For Limited Time Only!\r\n\r\nGet it here: coolshorts.online\r\n\r\nThe Best, \r\n\r\nFaith', '2021-09-06 10:29:32'),
(211, 'Pedro', '574-279-6091', 'pedro.faulding@gmail.com', 'Hello there\r\n\r\nYou need a pair of Quick Dry Beach Shoes, going out shoes, going OUT OUT shoes, trainers, a spare pair of trainers in case it rains...\r\n\r\nAct Now And Receive A Special Discount For Our Quick Dry Beach Shoes!\r\n\r\nGet Yours Here:  tonature.online\r\n\r\nKind Regards, \r\n \r\nPedro', '2021-09-07 20:28:23'),
(212, 'Chauncey Ontiveros', '0354 1852164', 'ontiveros.chauncey@hotmail.com', 'Details for starting sherrol.com marketing.\r\n\r\nOnline presence can be pivotal to the success of a business because it provides a shortcut into visibility that would otherwise take way too long to achieve or cost substantially more to buy.\r\n\r\nTo effortlessly increase sales on the internet you’ll want this tremendous service:\r\n	\r\nhttps://it-technicians.com/backlinks-generator\r\n\r\n\r\nWith best regards,\r\nWe offer amazing Promotion services you may purchase on our online shop to make big money in a small business, still not thinking about getting new business? Here is an easy, 1-click unsubscribe link: https://it-technicians.com/?unsubscribe=sherrol.com', '2021-09-10 16:01:09'),
(213, 'Ryan Robinson', '202-991-6766', 'ryan@unitedbusinessloans.xyz', 'Hello,\r\n\r\nI hope life is treating you kind and business is AWESOME!\r\n\r\nI just have one quick question for you.\r\n\r\nWould you consider a Working Capital Loan for your business if the price and terms were acceptable?\r\n\r\nWe offer loans from 10k to 500k regardless of credit or collateral, and will give you a funding decision in less than 30 seconds \r\nwithout pulling your credit or submitting a single document. \r\n\r\nJust click on the link to INSTANTLY see how much you qualify for www.unitedbusinessloans.xyz\r\n\r\n\r\n\r\nWarm Regards,\r\n\r\nRyan Robinson\r\nUnited Business Loans\r\nwww.unitedbusinessloans.xyz\r\n\r\n\r\n\r\n\r\nThis is an Advertisement.\r\nTo unsubscribe, click here www.unitedbusinessloans.xyz/unsubscribe,\r\n\r\nor write to:\r\n\r\nUnited Business Loans\r\n9169 W State St #3242\r\nGarden City, ID 83714', '2021-09-10 19:35:12'),
(214, 'Corine Martin', '0366 7117681', 'corine@sundatagroup.com', 'Hello from SunDataGroup.com\r\n\r\nWe are selling leads from around the world. I thought your company could benefit from it.\r\n\r\nYou can visit our website www.SunDataGroup.com to see some of our data.\r\n\r\nWe have a special offer running. All our databases for $99.', '2021-09-11 07:13:52'),
(215, 'Tasha', '(07) 3755 0229', 'tasha.vansickle@gmail.com', 'Good Morning\r\n\r\nBuy medical disposable face mask to protect your loved ones from the deadly CoronaVirus.  The price is $0.28 each.  If interested, please visit our site: pharmacyoutlets.online\r\n\r\nThe Best,\r\n\r\nTasha', '2021-09-11 19:57:27'),
(216, 'Eric Jones', '555-555-1212', 'eric.jones.z.mail@gmail.com', 'My name’s Eric and I just found your site sherrol.com.\r\n\r\nIt’s got a lot going for it, but here’s an idea to make it even MORE effective.\r\n\r\nTalk With Web Visitor – CLICK HERE http://talkwithcustomer.com for a live demo now.\r\n\r\nTalk With Web Visitor is a software widget that’s works on your site, ready to capture any visitor’s Name, Email address and Phone Number.  It signals you the moment they let you know they’re interested – so that you can talk to that lead while they’re literally looking over your site.\r\n\r\nAnd once you’ve captured their phone number, with our new SMS Text With Lead feature, you can automatically start a text (SMS) conversation… and if they don’t take you up on your offer then, you can follow up with text messages for new offers, content links, even just “how you doing?” notes to build a relationship.\r\n\r\nCLICK HERE http://talkwithcustomer.com to discover what Talk With Web Visitor can do for your business.\r\n\r\nThe difference between contacting someone within 5 minu', '2021-09-13 20:10:09'),
(217, 'Sherrie', '812-699-6155', 'ballow.sherrie@gmail.com', 'Morning \r\n \r\nCAREDOGBEST™ - Personalized Dog Harness. All sizes from XS to XXL.  Easy ON/OFF in just 2 seconds.  LIFETIME WARRANTY.\r\n\r\nClick here: caredogbest.com\r\n \r\nAll the best, \r\n \r\nSherrie\r\nSHERROL | Contact Us', '2021-09-14 11:29:41'),
(218, 'Eric Jones', '555-555-1212', 'eric.jones.z.mail@gmail.com', 'Hey there, I just found your site, quick question…\r\n\r\nMy name’s Eric, I found sherrol.com after doing a quick search – you showed up near the top of the rankings, so whatever you’re doing for SEO, looks like it’s working well.\r\n\r\nSo here’s my question – what happens AFTER someone lands on your site?  Anything?\r\n\r\nResearch tells us at least 70% of the people who find your site, after a quick once-over, they disappear… forever.\r\n\r\nThat means that all the work and effort you put into getting them to show up, goes down the tubes.\r\n\r\nWhy would you want all that good work – and the great site you’ve built – go to waste?\r\n\r\nBecause the odds are they’ll just skip over calling or even grabbing their phone, leaving you high and dry.\r\n\r\nBut here’s a thought… what if you could make it super-simple for someone to raise their hand, say, “okay, let’s talk” without requiring them to even pull their cell phone from their pocket?\r\n  \r\nYou can – thanks to revolutionary new software that can literally mak', '2021-09-15 13:38:22'),
(219, 'Eric Jones', '555-555-1212', 'eric.jones.z.mail@gmail.com', 'My name’s Eric and I just found your site sherrol.com.\r\n\r\nIt’s got a lot going for it, but here’s an idea to make it even MORE effective.\r\n\r\nTalk With Web Visitor – CLICK HERE http://talkwithcustomer.com for a live demo now.\r\n\r\nTalk With Web Visitor is a software widget that’s works on your site, ready to capture any visitor’s Name, Email address and Phone Number.  It signals you the moment they let you know they’re interested – so that you can talk to that lead while they’re literally looking over your site.\r\n\r\nAnd once you’ve captured their phone number, with our new SMS Text With Lead feature, you can automatically start a text (SMS) conversation… and if they don’t take you up on your offer then, you can follow up with text messages for new offers, content links, even just “how you doing?” notes to build a relationship.\r\n\r\nCLICK HERE http://talkwithcustomer.com to discover what Talk With Web Visitor can do for your business.\r\n\r\nThe difference between contacting someone within 5 minu', '2021-09-15 19:28:38'),
(220, 'Dell', '06386 96 96 81', 'dell.chappel@outlook.com', 'Hello there\r\n\r\nFull Body Resistance Band Kit - The best and cheapest athletic gear available on the market today. \r\nDo a full body workout from the comfort of your home. You don\'t even need a gym anymore! \r\n\r\nSave 50% OFF + FREE Worldwide Shipping\r\nShop Now: ametathletics.online\r\n\r\nBest Wishes, \r\n \r\nDell', '2021-09-17 14:17:30'),
(221, 'Freda', '0688 923 74 22', 'severance.freda@googlemail.com', 'Hey \r\n \r\nLEARN HOW PawSafer™ CAN SAFELY TRIM YOUR DOG\'S NAILS IN NO TIME FROM HOME.\r\n\r\nGet it while it\'s still 50% OFF + FREE Shipping\r\n\r\nBuy here: pawsafer.shop\r\n \r\nKind Regards, \r\n \r\nFreda', '2021-09-20 06:47:34'),
(222, 'Betsy', '932 67 892', 'betsy.leahy@hotmail.com', 'Hi \r\n\r\nThe New Powerful LED Flashlight is The Perfect Flashlight For Any Situation!\r\n\r\nThe 3,000 Lumens & Adjustable Zoom gives you the wide field of view and brightness other flashlights don’t have.\r\n\r\n50% OFF + Free Shipping!  Get it Now: linterna.shop\r\n\r\nSincerely, \r\n\r\nBetsy', '2021-09-22 19:13:38'),
(223, 'Jillian Wicks', '(02) 6136 3043', 'jillian.wicks@gmail.com', 'SHERROL | Contact Us + My company?\r\n\r\nContinually seek ways to grow your business because once you\'ve reached your top, your competitors will never stop trying to outrank you.\r\n\r\nThe only package you’ll need to attract unlimited clients online:\r\n	\r\nhttps://ultimate-marketers.com/backlinks-generator\r\n\r\n\r\nBest regards,\r\nWe offer superb Digital Marketing services you may find on our website to make big money in a small business, still not interested in getting new clients? Here is a simple, one-click unsubscribe link: https://ultimate-marketers.com/?unsubscribe=sherrol.com', '2021-09-23 22:49:40'),
(224, 'Ryan Robinson', '202-991-6766', 'ryan@unitedbusinessloans.xyz', 'Hello,\r\n\r\nI hope life is treating you kind and business is AWESOME!\r\n\r\nI just have one quick question for you.\r\n\r\nWould you consider a Working Capital Loan for your business if the price and terms were acceptable?\r\n\r\nWe offer loans from 10k to 500k regardless of credit or collateral, and will give you a funding decision in less than 30 seconds \r\nwithout pulling your credit or submitting a single document. \r\n\r\nJust click on the link to INSTANTLY see how much you qualify for www.unitedbusinessloans.xyz\r\n\r\n\r\n\r\nWarm Regards,\r\n\r\nRyan Robinson\r\nUnited Business Loans\r\nwww.unitedbusinessloans.xyz\r\n\r\n\r\n\r\n\r\nThis is an Advertisement.\r\nTo unsubscribe, click here www.unitedbusinessloans.xyz/unsubscribe,\r\n\r\nor write to:\r\n\r\nUnited Business Loans\r\n9169 W State St #3242\r\nGarden City, ID 83714', '2021-09-24 18:59:11'),
(225, 'Nellie', '06743 38 74 40', 'strode.nellie70@gmail.com', 'Hello there \r\n\r\nDefrost frozen foods in minutes safely and naturally with our THAW KING™. \r\n\r\n50% OFF for the next 24 Hours ONLY + FREE Worldwide Shipping for a LIMITED time.\r\n\r\nBuy now: thawking.online\r\n\r\nThank You, \r\n\r\nNellie', '2021-09-25 14:12:14'),
(226, 'Starla Bristol', '026 315 35 83', 'bristol.starla62@gmail.com', 'Hi there\r\n\r\nIf you ever need Negative SEO to de-rank any site, you can hire us here\r\nhttps://www.speed-seo.net/product/negative-seo-service/', '2021-09-28 21:37:10');

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

--
-- Table structure for table `delivery_pincode`
--

CREATE TABLE `delivery_pincode` (
  `id` int(11) NOT NULL,
  `pincode` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `delivery_pincode`
--

INSERT INTO `delivery_pincode` (`id`, `pincode`) VALUES
(1, '110074'),
(2, '110068');

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

--
-- Table structure for table `faq`
--

CREATE TABLE `faq` (
  `id` int(11) NOT NULL,
  `faq_title` varchar(300) DEFAULT NULL,
  `faq_desc` varchar(3000) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `faq`
--

INSERT INTO `faq` (`id`, `faq_title`, `faq_desc`, `created_at`) VALUES
(1, 'WHAT ARE THE PAYMENT OPTIONS AVAILABLE ON SHERROL.COM?', 'sherrol.com offers the following methods of payment: Credit Card / Debit Card, Internet Banking and Cash on delivery for selected pin codes (you can check whether COD payment is applicable in your area at the time of making the purchase)', '2019-11-14 09:17:39'),
(2, 'WHEN WILL MY ORDER BE PROCESSED?', 'If the order is placed using a Credit Card / Debit Card/ Internet Banking, then it will be processed once the payment is approved by the bank. Usually, most orders are dispatched within 5 to 7 working days. The delivery timeline depends on the destination city; however, most orders are delivered within a maximum of 10 working days.', '2019-11-14 09:17:39'),
(3, 'HOW DO I CHECK THE CONFIRMATION OF MY ORDER?', 'You will receive an order confirmation by email usually within 20 minutes of completing your order. You will also receive a confirmation by SMS on your given mobile number.', '2019-12-27 06:20:54'),
(4, 'HOW MUCH IS THE MINIMUM ORDER VALUE?', 'There is no minimum purchase order value.', '2019-12-27 06:22:25'),
(5, 'WHAT ARE THE DELIVERY COSTS?', 'We offer free shipping for all products value more than 2500.00\r\n\r\nFor orders less than 2500 shipping charges @ Rs. 100 will be charged additional.', '2019-12-27 07:16:09'),
(6, 'I AM UNABLE TO COMPLETE THE ORDER USING THE \"CREDIT CARD\" PAYMENT OPTION.', 'Check whether all the required fields have been filled correctly and ensure the secure password is also entered correctly in the payment gateway.', '2020-01-20 05:37:22'),
(7, 'HOW LONG WILL THE DELIVERY TAKE?', 'The orders are normally shipped within 7 working days from the date of placing the order. They are delivered to the customers address within 7 working days (must be serviceable locations) by our official courier. If the service is not available, then the product will be dispatched through other courier agencies / post which would normally take 2-3 working days to deliver.', '2020-01-20 06:23:19'),
(8, 'HOW DO I CHECK THE STATUS OF MY ORDER?', 'Please go to Track my Order option or send message/WhatsApp on support phone number', '2020-02-25 05:23:26'),
(9, 'CAN I SUBSEQUENTLY CHANGE AN ITEM IN MY ORDER?', 'It is not possible to subsequently change sizes or colours of items, or to add or delete items, once you have placed your order. Please enter a new order in the sherrol.com and cancel the order you want to change (Cancellation terms and conditions are applicable).', '2020-05-08 09:54:13'),
(10, 'CAN I CANCEL MY ORDER?', 'As long as the package has not been dispatched from our warehouse, the order could be cancelled. Cancellations can be carried out by contacting our Customer Service. If the package has already been dispatched, we won’t be able to cancel the order. However, you can initiate a return once you have received the order, as long the product is unused and is in compliance with our return terms and conditions.', '2020-06-27 09:08:58'),
(11, 'WHAT HAPPENS IF I AM NOT AT HOME WHEN THE PACKAGE IS DELIVERED?', 'In case you are not available at your shipping address at the time of delivery, our courier partner will get in touch with you on your mobile number and re-attempt the delivery during standard working hours. Repeated fail delivery attempts will result in the order being cancelled.', '2020-06-27 09:09:26'),
(12, 'CAN I EXCHANGE AN ITEM?', 'You can return all items purchased from the Sherrol.com online Store within 10 days of receiving your product. Please note that it is only possible for us to accept items that are returned in their original state. The merchandise should not show signs of usage. Direct exchange of products is not possible, however after cancelling the order; you can place a fresh order on Sherrol.com', '2020-06-27 09:21:27'),
(13, 'WITHIN HOW MANY DAYS CAN I RETURN AN ITEM?', 'You can return any item purchased on Sherrol.com within 3 days of purchasing the product, as long as the product is unused and has its original packaging and tags. - Reimbursement is usually completed in 7 to 15 working days, after receiving and conducting the quality check of your returned package. -The value of the returned product will be credited to your Credit/Debit Card/Net banking account. In case of COD orders, you need to provide us with relevant bank details in order to process the refund.', '2020-06-27 09:21:45'),
(14, 'I WOULD LIKE TO RETURN A DAMAGED, FAULTY OR INCORRECT ITEM, HOW DO I DO THIS?', 'Please send the merchandise back to our address below through a known courier agency: Ritz Fashion Pvt. Ltd, B-76, Sector-80, Noida Phase-II, Uttar Pradesh-201305 India Alternatively, you can check with our customer care, if your pin code is serviceable for a reverse pick up. We will check the issue once we receive the returned merchandise and arrange to send a replacement to your shipping address', '2020-06-27 09:22:06'),
(15, 'CAN YOU SEND ME A CATALOGUE?', 'Sherrol.com products are only available for online viewing. Unfortunately, we will not be able to send you a printed version of the catalogue.', '2020-06-27 09:22:29'),
(16, 'CAN I BOOK AN ORDER FOR DELIVERY TO MORE THAN ONE ADDRESS?', 'Each order is shipped only to a single address. If you wish to ship products to different addresses, you will have to place multiple orders.', '2020-06-27 09:22:45'),
(17, 'ARE THE EXCHANGE AND RETURN POLICIES THE SAME FOR E-COMMERCE AND RETAIL PURCHASES?', 'The Exchange & Return Policies for Sherrol.com e-commerce purchases are different from retail. Check our policies page for Retail purchases policy & E-commerce purchase policy.', '2020-06-27 09:23:04'),
(18, 'CAN I AVAIL ALTERATION SERVICES FOR SHERROL.COM GARMENTS AND ARE THEY CHARGEABLE?', 'Sherrol.com offers its customers a non-chargeable alteration service at all Exclusive Stores. This is a complimentary service that the customers can avail after presenting the invoice. It’s valid for both e-commerce and retail purchases.', '2020-06-27 09:23:21'),
(19, 'SCREEN RESOLUTION', 'On your computer monitor, use a screen resolution of at least 1152 x 768 pixels for optimal presentation of the Sherrol.com Store.', '2020-06-27 09:23:40'),
(20, 'BROWSER SETTINGS', 'To ensure correct display and functioning of the Sherrol.com online Store, please use Internet Explorer Version 11, or Firefox Version 36 or Google Chrome 41. Java and JavaScript capabilities should be activated in the browser. The \"Accept Cookies\" function must be enabled in order to place products into the shopping Bag. Given below are instructions on how to do this for some commonly used web browsers. Additional information can be found in your software manual or on the website of the browser provider. We recommend that you log off completely, when you finish using a computer that is shared and that has a browser set to accept cookies.', '2020-06-27 09:23:56');

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

--
-- Table structure for table `guide`
--

CREATE TABLE `guide` (
  `id` int(11) NOT NULL,
  `gu_name` varchar(255) DEFAULT NULL,
  `gu_image` varchar(255) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `guide`
--

INSERT INTO `guide` (`id`, `gu_name`, `gu_image`) VALUES
(1, 'Coat', 'coat_27611.png'),
(2, 'Kurta', 'kurta_17285.png'),
(3, 'Jacket', 'jacket_69228.png'),
(4, 'Dresses', 'dresses_88132.png'),
(5, 'Kurta Pyjama Adult', 'kurta-pyjama-adult_58177.png'),
(6, 'Kurti', 'kurti_50605.png'),
(7, 'Night Suit', 'night-suit_42508.png'),
(8, 'Shirt', 'shirt_34971.png'),
(9, 'Shorts', 'shorts_99297.png'),
(10, 'Skirt', 'skirt_20586.png'),
(11, 'Sportswear Pant', 'sportswear-pant_90454.png'),
(12, 'Sweat Shirt', 'sweat-shirt_92948.png'),
(13, 'T-Shirt', 't-shirt_68559.png'),
(14, 'Trouser', 'trouser_38396.png'),
(15, 'Women Top Sketch', 'women-top-sketch_87541.png');

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

--
-- Table structure for table `help_query`
--

CREATE TABLE `help_query` (
  `id` int(11) NOT NULL,
  `u_id` int(11) DEFAULT NULL,
  `help_type` varchar(255) DEFAULT NULL,
  `msg` text DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

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

CREATE TABLE `migrations` (
  `id` int(10) UNSIGNED NOT NULL,
  `migration` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `batch` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `newsletter`
--

CREATE TABLE `newsletter` (
  `id` int(11) NOT NULL,
  `news_email` varchar(100) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `newsletter`
--

INSERT INTO `newsletter` (`id`, `news_email`, `created_at`) VALUES
(1, 'val.oakridge@gmail.com', '2021-08-25 21:30:32'),
(2, 'support@ctemplar.com', '2021-09-05 13:59:44'),
(3, 'l.gonzales@yahoo.com', '2021-09-09 20:00:27');

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

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

CREATE TABLE `orders` (
  `id` int(11) NOT NULL,
  `od_uid` int(11) DEFAULT NULL COMMENT 'from table ''user''',
  `od_pd_id` int(11) NOT NULL COMMENT 'from table ''products''',
  `od_pay_id` int(11) NOT NULL COMMENT 'from table ''payment''',
  `od_pd_name` varchar(300) DEFAULT NULL,
  `od_pd_image` varchar(200) DEFAULT NULL,
  `od_pd_mrp` decimal(10,0) NOT NULL DEFAULT 0,
  `od_pd_price` decimal(10,2) NOT NULL DEFAULT 0.00,
  `od_pd_brand` varchar(200) DEFAULT NULL,
  `od_pd_size` varchar(100) DEFAULT NULL,
  `od_pd_color` varchar(100) DEFAULT NULL,
  `od_pd_quantity` decimal(10,0) NOT NULL DEFAULT 0,
  `od_order_status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '1:New Order, 2:Processing, 3:Dispatched, 4:Delivered, 5:Return, 6:Canceled, 7:Canceled by user',
  `od_delivery_status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '1:Delivered, 2:Return',
  `od_return_reason` varchar(100) DEFAULT NULL,
  `od_cancel_reason` varchar(255) DEFAULT NULL,
  `od_comment` text DEFAULT NULL,
  `od_return_status` tinyint(2) DEFAULT NULL COMMENT '0:Pending 1:Accept 2:Reject',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `orders`
--

INSERT INTO `orders` (`id`, `od_uid`, `od_pd_id`, `od_pay_id`, `od_pd_name`, `od_pd_image`, `od_pd_mrp`, `od_pd_price`, `od_pd_brand`, `od_pd_size`, `od_pd_color`, `od_pd_quantity`, `od_order_status`, `od_delivery_status`, `od_return_reason`, `od_cancel_reason`, `od_comment`, `od_return_status`, `created_at`, `updated_at`) VALUES
(1, 2, 8, 1, 'Product Code - 47', 'img-8209_78481.jpg', '0', '2070.00', NULL, 'S', 'Coral', '1', 1, 1, NULL, NULL, NULL, NULL, '2020-09-19 14:12:55', '2020-09-19 14:12:55'),
(2, 3, 3, 2, 'SOL -1015', 'img-7886_71153.jpg', '0', '1760.00', NULL, 'S', 'Coral', '7', 1, 1, NULL, NULL, NULL, NULL, '2020-11-13 06:09:48', '2020-11-13 06:09:48'),
(3, 3, 20, 2, 'SOL-1014', 'annotation-2020-06-14-130104_68851.jpg', '0', '3420.00', 'Sherrol', 'XS', 'Black', '1', 1, 1, NULL, NULL, NULL, NULL, '2020-11-13 06:09:48', '2020-11-13 06:09:48'),
(4, 1, 13, 3, 'SOL-1007', '015_90444.jpg', '0', '4050.00', 'Sherrol', 'XS', 'Red', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-01-30 04:07:28', '2021-01-30 04:07:28'),
(5, 1, 13, 4, 'SOL-1007', '015_90444.jpg', '0', '4050.00', 'Sherrol', 'XS', 'Red', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-01-30 04:07:42', '2021-01-30 04:07:42'),
(6, 5, 19, 5, 'SOL-1013', 'annotation-2020-06-14-132537_56660.jpg', '0', '5500.00', 'Sherrol', 'XS', 'Blue', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-07-01 04:18:47', '2021-07-01 04:18:47'),
(7, 5, 19, 6, 'SOL-1013', 'annotation-2020-06-14-132537_56660.jpg', '0', '5500.00', 'Sherrol', 'XS', 'Blue', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-07-01 04:29:23', '2021-07-01 04:29:23'),
(8, 7, 19, 7, 'SOL-1013', 'annotation-2020-06-14-132537_56660.jpg', '0', '5500.00', 'Sherrol', 'S', 'Blue', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-07-12 09:46:46', '2021-07-12 09:46:46'),
(9, 2, 20, 8, 'BL-001', 'screen-shot-2021-07-24-at-80216-pm_61817.png', '0', '21000.00', 'Sherrol', 'S', 'Black', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-08-01 02:51:29', '2021-08-01 02:51:29'),
(10, 2, 15, 8, 'SOL-1009', 'screen-shot-2021-07-25-at-54530-am_60028.png', '0', '2520.00', 'Sherrol', 'M', 'Black', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-08-01 02:51:29', '2021-08-01 02:51:29'),
(11, 2, 21, 8, 'Combo-001', '', '0', '5500.00', NULL, 'M', 'Burgundy', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-08-01 02:51:29', '2021-08-01 02:51:29'),
(12, 2, 16, 8, 'SOL-1010', '', '0', '3150.00', 'Sherrol', 'S', 'Pink', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-08-01 02:51:29', '2021-08-01 02:51:29'),
(13, 1, 11, 9, 'SOL-1003', 'unnamed_39096.jpg', '0', '3150.00', 'Sherrol', 'XS', 'White', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-09-17 05:12:22', '2021-09-17 05:12:22'),
(14, 1, 11, 10, 'SOL-1003', 'unnamed_39096.jpg', '0', '3150.00', 'Sherrol', 'XS', 'White', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-09-17 05:13:53', '2021-09-17 05:13:53'),
(15, 2, 20, 11, 'BL-001', 'screen-shot-2021-07-24-at-80216-pm_61817.png', '0', '21000.00', 'Sherrol', 'S', 'Black', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-09-28 06:07:08', '2021-09-28 06:07:08'),
(16, 2, 15, 11, 'SOL-1009', 'screen-shot-2021-07-25-at-54530-am_60028.png', '0', '2520.00', 'Sherrol', 'M', 'Black', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-09-28 06:07:08', '2021-09-28 06:07:08'),
(17, 2, 21, 11, 'Combo-001', '', '0', '5500.00', NULL, 'M', 'Burgundy', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-09-28 06:07:08', '2021-09-28 06:07:08'),
(18, 2, 16, 11, 'SOL-1010', '', '0', '3150.00', 'Sherrol', 'S', 'Pink', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-09-28 06:07:08', '2021-09-28 06:07:08'),
(19, 2, 7, 11, 'Product Code - 45', '', '0', '1125.00', NULL, 'S', 'Blue', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-09-28 06:07:08', '2021-09-28 06:07:08'),
(20, 2, 15, 12, 'SOL-1009', 'screen-shot-2021-07-25-at-54530-am_60028.png', '0', '2520.00', 'Sherrol', 'M', 'Black', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-09-28 07:55:48', '2021-09-28 07:55:48'),
(21, 2, 21, 12, 'Combo-001', '', '0', '5500.00', NULL, 'M', 'Burgundy', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-09-28 07:55:48', '2021-09-28 07:55:48'),
(22, 2, 16, 12, 'SOL-1010', '', '0', '3150.00', 'Sherrol', 'S', 'Pink', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-09-28 07:55:48', '2021-09-28 07:55:48'),
(23, 2, 7, 12, 'Product Code - 45', '', '0', '1125.00', NULL, 'S', 'Blue', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-09-28 07:55:48', '2021-09-28 07:55:48'),
(24, 9, 20, 13, 'BL-001', 'screen-shot-2021-07-24-at-80216-pm_61817.png', '0', '21000.00', 'Sherrol', 'XS', 'Black', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-09-28 08:37:53', '2021-09-28 08:37:53'),
(25, 9, 20, 14, 'BL-001', 'screen-shot-2021-07-24-at-80216-pm_61817.png', '0', '21000.00', 'Sherrol', 'XS', 'Black', '1', 1, 1, NULL, NULL, NULL, NULL, '2021-09-28 08:41:57', '2021-09-28 08:41:57');

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

--
-- Table structure for table `others`
--

CREATE TABLE `others` (
  `id` int(11) NOT NULL,
  `oth_name` varchar(200) DEFAULT NULL,
  `oth_image` varchar(255) DEFAULT NULL,
  `oth_url` varchar(200) DEFAULT NULL,
  `oth_page` mediumtext DEFAULT NULL,
  `oth_head_txt` text DEFAULT NULL,
  `oth_tag_line` text DEFAULT NULL,
  `oth_seo_title` varchar(200) DEFAULT NULL,
  `oth_seo_keys` varchar(300) DEFAULT NULL,
  `oth_seo_desc` varchar(500) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `others`
--

INSERT INTO `others` (`id`, `oth_name`, `oth_image`, `oth_url`, `oth_page`, `oth_head_txt`, `oth_tag_line`, `oth_seo_title`, `oth_seo_keys`, `oth_seo_desc`) VALUES
(1, 'About SHERROL', 'video-banner_48479.jpg', 'about-us', '<h3><span style=\"font-family:poppins,sans-serif; font-size:14px\">RITZ FASHION PRIVATE LIMITED</span></h3>', '', '', 'SHERROL | About Us', NULL, NULL),
(2, 'Terms & Conditions', 'terms-of-use_18206.jpg', 'terms-conditions', '<p>Use of this web site is conditioned upon the user&#39;s acceptance of terms and conditions mentioned here.</p>\r\n\r\n<p>All the users of this website hereby understand and agree that their use of this website constitutes acceptance of these terms and conditions set forth here.</p>\r\n\r\n<p>Sherrol.com Online Store, and the RITZ FASHION PRIVATE LIMITED reserve the right to modify the terms and conditions at any time without prior notice.</p>\r\n\r\n<p>If you do not agree to these terms, you may not use this website.</p>', '', NULL, 'SHERROL | Terms & Conditions', NULL, NULL),
(3, 'Exchange & Returns', 'warranty-claim_89034.jpg', 'shipping-returns', '<h3>Exchange&nbsp;Policy</h3>\r\n\r\n<p>Not satisfied with what you bought and want to exchange? Bring it to the Sherrol.com store within 21 days of purchase and exchange it with any other product of your choice. Conditions&nbsp;Product can be exchanged within 7 Days from the date of purchase at any Sherrol.com store in the same state from where it was purchased.</p>\r\n\r\n<p>Product can only be exchanged at any Sherrol.com Store in the same state, from where it was purchased. Inter-state exchange is not applicable.</p>\r\n\r\n<p>If the purchase is done from Large Format Retail stores, Shop-in Shops or MBOs, Exclusive Stores will not be able to accept the request. However, the customer can try at their facility.</p>\r\n\r\n<p>The returned product should be original, unaltered, unmodified and in a saleable condition with its original tag and label attached. If the product is worn/ washed or has the tag/label removed, it will not qualify for exchange.</p>\r\n\r\n<p>The product along with the original invoice has to be presented at the billing counter of the store at the time of exchange.</p>\r\n\r\n<p>The policy only allows for exchange. Refund is not applicable.</p>\r\n\r\n<p>The Policy does not apply to accessories and innerwear.</p>\r\n\r\n<p>Exchange will be done against any product with the same or higher value. In case the customer chooses a higher value product, the difference in value will be paid by the customer at the time of billing of the exchanged product.</p>\r\n\r\n<p>If the customer is unable to find the right size/ colour/ product at the time of exchange, a credit notes basis the returned product&rsquo;s selling price will be issued.</p>\r\n\r\n<p>The credit note will be valid for 90 days from the date of issue, after which it will automatically expire. It is suggested to redeem the amount within the issued span of time.</p>\r\n\r\n<p>The customer can redeem partial amount of the credit note. In this case, the store will issue another credit note with the balance amount. This will be valid for another 90 days from the date of issue.</p>\r\n\r\n<p>The credit note can be used to purchase any item of assigned value from any Exclusive store across India.</p>\r\n\r\n<p>The exchange policy is not applicable on discounted products, purchases done during EOSS and promotions. However, the credit note can be redeemed against purchase of any product in the store, including the promotional/ discounted product.</p>\r\n\r\n<p>&nbsp;</p>\r\n\r\n<h3>Return Policy</h3>\r\n\r\n<pre>\r\nMANUFACTURING DEFECT RETURN</pre>\r\n\r\n<p>In case the product that has been purchased from any Sherrol.com Store is perceived to be defective by the customer, RITZ FASHION PRIVATE LIMITED offers return of the product at its discretion and subject to following policy terms:</p>\r\n\r\n<p>Product should be original.</p>\r\n\r\n<p>Customer to present the defective product at the same Sherrol.com Store where it was purchased from within 6 months from the date of purchase (as part of the GST regulation, unless there is an exception at RITZ FASHION PRIVATE LIMITED&rsquo;s sole discretion).</p>\r\n\r\n<p>In case the original invoice copy is not available, customer must present the product at the store, ensuring the label (Tag/ Taffeta) is present on the product. The store authority will authenticate the purchase date and price paid from the bar code on the label.</p>\r\n\r\n<p>Damage caused by accident, improper wash &amp; care, natural break down of colour &amp; material and regular wear &amp; tear are not covered under this policy. The presented defective product will be accepted at the store only after the Store Manager examines the defect.</p>\r\n\r\n<p>Customer will be provided with an Exchange Form to fill. A copy of the form with reference number will be issued.</p>\r\n\r\n<p>The product is then sent to the company head office for inspection. The process takes up to 10 working days.</p>\r\n\r\n<p>The exchange will be considered on the exact amount paid by the customer for the defective product. In case of EOSS, the discounted MRP will be considered and not the actual MRP of the product.</p>\r\n\r\n<p>The policy allows for exchange, only if approved. Refund is not applicable.</p>\r\n\r\n<p>For product damage caused by the customer, the Exchange Policy does not apply.</p>\r\n\r\n<p>In case of approved defect from Product Assurance Team at RITZ FASHION PRIVATE LIMITED, the Store Manager will call the customer and invite for the exchange. The customer will receive a call to collect the product from the store. The inspection and decision from RITZ FASHION PRIVATE LIMITED will be final and binding.</p>\r\n\r\n<p>When approved, a credit note will be issued to the customer. It will be valid for 90 days from the date of issue, after which it automatically expires.</p>\r\n\r\n<p>The credit note can be redeemed against any merchandise of the similar value at the same Exclusive Store, where it was issued.</p>', '', NULL, 'SHERROL | Exchange & Returns', NULL, NULL),
(4, 'Privacy Policy', 'privacy-policy_65918.jpg', 'privacy-policy', '<p>RITZ FASHION PRIVATE LIMITED does not endorse the contents of any outside links from this website or the contents of any e-mail communication originating or received through this website.</p>\r\n\r\n<p>RITZ FASHION PRIVATE LIMITED is not responsible for any general, special, direct, indirect, incidental or consequential damages that may arise from the use of or the inability to use, this website and / or the materials contained therein, regardless of their source.</p>\r\n\r\n<p>The content of the pages of this website is for your general information and use only. It is subject to change without notice.</p>\r\n\r\n<p>Neither we nor any third parties provide any warranty or guarantee as to the accuracy, timeliness, performance, completeness or suitability of the information and materials found or offered on this website for any particular purpose. You acknowledge that such information and materials may contain inaccuracies or errors and we expressly exclude liability for any such inaccuracies or errors to the fullest extent permitted by law.</p>\r\n\r\n<p>Your use of any information or materials on this website is entirely at your own risk, for which we shall not be liable. It shall be your own responsibility to ensure that any products, services or information available through this website meet your specific requirements.</p>\r\n\r\n<p>This website contains material which is owned by or licensed to us. This material includes, but is not limited to, the design, layout, look, appearance and graphics. Reproduction is prohibited other than in accordance with the copyright notice, which forms part of these terms and conditions.</p>\r\n\r\n<p>Unauthorized use of this website may give rise to a claim for damages and / or will be termed as legal offence. Such act(s) / activities / representation(s) will be processed as per Country / State / Area / Locality / Town legal Jurisdiction.</p>\r\n\r\n<p>From time to time, this website may also include links to other websites. These links are provided for your convenience to provide further information. They do not signify that we endorse the website(s). We have no responsibility for the content of the linked website(s).</p>\r\n\r\n<p>You may not create a link to this website from another website or document without RITZ FASHION PRIVATE LIMITED prior written consent.</p>\r\n\r\n<p>Data uploads on this site is as per decision / discretion of the user himself / herself. The organization will not be responsible for its usage, storage or any other use / purpose in what so ever condition / circumstance it may be.</p>\r\n\r\n<p>The images, styles, garment design(s), cuts, fabric, stitches and / or any other design related content, information and / or view / representation is the sole property / ownership / binding of RITZ FASHION PRIVATE LIMITED only, is not intended for any other purpose / area / reference / representation / usage / reproduction in any circumstance(s) it may be.</p>', '', NULL, 'SHERROL | Privacy Policy', NULL, NULL),
(5, NULL, NULL, NULL, '<p>Not satisfied with what you bought and want to exchange?<br />\r\nProduct can be exchanged within 7 Days from the date of purchase at any sherrol.com store in the same state from where it was purchased.</p>\r\n\r\n<p>Product can only be exchanged at any sherrol.com Store in the same state, from where it was purchased. Inter-state exchange is not applicable.</p>\r\n\r\n<p>In case the product that has been purchased from any sherrol.com Store is perceived to be defective by the customer, SHERROL&nbsp;PRIVATE LIMITED offers return of the product at its discretion and subject to policy term.</p>', '', NULL, 'test4', 'test5', 'test65'),
(6, NULL, NULL, NULL, 'Home Content', '10% extra off in Mid Season Sale for being Sherrol | Use Promo Code Heartbeats21', 'Renting Heartbeats', 'SHERROL | Online Renting Site for Women\'s Fashion', 'Clothing, Shoes, Hand Bags, Accessaries', 'Online Renting Site for Women\'s Fashion'),
(7, NULL, NULL, NULL, 'Contact Content', '', '', 'SHERROL | Contact Us', NULL, NULL);

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

--
-- Table structure for table `payment`
--

CREATE TABLE `payment` (
  `id` int(11) NOT NULL,
  `p_uid` int(11) NOT NULL COMMENT 'from table ''user''',
  `order_id` varchar(200) DEFAULT NULL,
  `order_status` varchar(200) DEFAULT NULL,
  `amount` decimal(10,2) DEFAULT NULL,
  `promo_code` varchar(255) DEFAULT NULL,
  `promo_amount` decimal(10,2) DEFAULT NULL,
  `delivery_charge` decimal(10,2) DEFAULT NULL,
  `final_amount` decimal(10,2) DEFAULT NULL,
  `payment_id` varchar(255) DEFAULT NULL,
  `billing_name` varchar(200) DEFAULT NULL,
  `billing_lname` varchar(255) DEFAULT NULL,
  `billing_address` varchar(200) DEFAULT NULL,
  `billing_city` varchar(200) DEFAULT NULL,
  `billing_state` varchar(200) DEFAULT NULL,
  `billing_zip` varchar(200) DEFAULT NULL,
  `billing_country` varchar(200) DEFAULT NULL,
  `billing_tel` varchar(200) DEFAULT NULL,
  `billing_email` varchar(200) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `payment`
--

INSERT INTO `payment` (`id`, `p_uid`, `order_id`, `order_status`, `amount`, `promo_code`, `promo_amount`, `delivery_charge`, `final_amount`, `payment_id`, `billing_name`, `billing_lname`, `billing_address`, `billing_city`, `billing_state`, `billing_zip`, `billing_country`, `billing_tel`, `billing_email`, `created_at`) VALUES
(1, 2, 'ORD-1000001', NULL, '2070.00', NULL, NULL, '0.00', '2070.00', 'PAYID-L5TBD2Q1JJ679484S123453Y', 'Raman', 'Pranraj', 'B-208, Okhla Phase-I', 'New Delhi', 'New Delhi', '110020', NULL, '9810080949', 'ramanpranraj@gmail.com', '2020-09-19 14:12:55'),
(2, 3, 'ORD-1000002', NULL, '15740.00', NULL, NULL, '0.00', '15740.00', 'PAYID-L6XCGLQ2S1619336K819480V', 'Test', 'test', 'ads', 'ads', 'das', '111111', NULL, '9876543210', 'dorepek683@pidouno.com', '2020-11-13 06:09:48'),
(3, 1, 'ORD-1000003', NULL, '4050.00', NULL, NULL, '0.00', '4050.00', 'PAYID-MAKNXAI6X835175NG9676119', 'pankaj', 'saini', 'hari nagar, ashram', 'Delhi', 'Delhi', '110014', NULL, '6487548758', 'test@gmail.com', '2021-01-30 04:07:28'),
(4, 1, 'ORD-1000004', NULL, '4050.00', NULL, NULL, '0.00', '4050.00', 'PAYID-MAKNXEA39Y18793YJ670145N', 'pankaj', 'saini', 'hari nagar, ashram', 'Delhi', 'Delhi', '110014', NULL, '6487548758', 'test@gmail.com', '2021-01-30 04:07:42'),
(5, 5, 'ORD-1000005', NULL, '5500.00', NULL, NULL, '0.00', '5500.00', 'PAYID-MDOUEKA5B936430GK720453J', 'admin', 'sdf', 'safdf', 'sdfdfs', 'sdfsdf', '114422', NULL, '9638527410', 'admin@gmail.com', '2021-07-01 04:18:47'),
(6, 5, 'ORD-1000006', NULL, '5500.00', NULL, NULL, '0.00', '5500.00', 'PAYID-MDOUJJA9LM67180A2125664L', 'admin', 'sdf', 'safdf', 'sdfdfs', 'sdfsdf', '114422', NULL, '9638527410', 'admin@gmail.com', '2021-07-01 04:29:23'),
(7, 7, 'ORD-1000007', NULL, '5500.00', NULL, NULL, '0.00', '5500.00', 'PAYID-MDWA7BY5VX64792J57802914', 'Test', 'kkh', 'Delhi', 'DElhi', 'Delhi', '110074', NULL, '0123456789', 'test123@gmail.com', '2021-07-12 09:46:46'),
(8, 2, 'ORD-1000008', NULL, '32170.00', NULL, NULL, '0.00', '32170.00', 'PAYID-MEDAYMY8L118561MD5832804', 'Raman', 'Pranraj', 'B-208, Okhla Phase-I', 'New Delhi', 'New Delhi', '110020', NULL, '9810080949', 'ramanpranraj@gmail.com', '2021-08-01 02:51:29'),
(9, 1, 'ORD-1000009', NULL, '3150.00', NULL, NULL, '0.00', '3150.00', NULL, 'pankaj', 'saini', 'hari nagar, ashram', 'Delhi', 'Delhi', '110014', NULL, '6487548758', 'test@gmail.com', '2021-09-17 05:12:22'),
(10, 1, 'ORD-1000010', NULL, '3150.00', NULL, NULL, '0.00', '3150.00', NULL, 'pankaj', 'saini', 'hari nagar, ashram', 'Delhi', 'Delhi', '110014', NULL, '6487548758', 'test@gmail.com', '2021-09-17 05:13:53'),
(11, 2, 'ORD-1000011', NULL, '33295.00', NULL, NULL, '0.00', '33295.00', NULL, 'Raman', 'Pranraj', 'B-208, Okhla Phase-I', 'New Delhi', 'New Delhi', '110020', NULL, '9810080949', 'ramanpranraj@gmail.com', '2021-09-28 06:07:08'),
(12, 2, 'ORD-1000012', NULL, '12295.00', NULL, NULL, '0.00', '12295.00', NULL, 'Raman', 'Pranraj', 'B-208, Okhla Phase-I', 'New Delhi', 'New Delhi', '110020', NULL, '9810080949', 'ramanpranraj@gmail.com', '2021-09-28 07:55:48'),
(13, 9, 'ORD-1000013', NULL, '21000.00', NULL, NULL, '0.00', '21000.00', NULL, 'Tejinder', 'Singh', 'Delhi', 'Delhi', 'Delhi', '201030', NULL, '9650436809', 'tssaini7@gmail.com', '2021-09-28 08:37:53'),
(14, 9, 'ORD-1000014', NULL, '21000.00', NULL, NULL, '0.00', '21000.00', NULL, 'Tejinder', 'Singh', 'Delhi', 'Delhi', 'Delhi', '201030', NULL, '9650436809', 'tssaini7@gmail.com', '2021-09-28 08:41:57');

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

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

CREATE TABLE `products` (
  `id` int(11) NOT NULL,
  `pd_ct_id` int(11) NOT NULL COMMENT 'from table ''category''',
  `pd_ct_links` varchar(100) DEFAULT NULL,
  `pd_vendor` varchar(255) DEFAULT NULL,
  `pd_size` varchar(200) DEFAULT NULL COMMENT 'from table ''size''',
  `pd_colour` varchar(255) DEFAULT NULL,
  `pd_brand` int(11) DEFAULT NULL,
  `pd_name` varchar(200) DEFAULT NULL,
  `pd_url` varchar(200) DEFAULT NULL,
  `pd_sku` varchar(200) DEFAULT NULL,
  `pd_desc` mediumtext DEFAULT NULL,
  `pd_care_desc` text DEFAULT NULL,
  `pd_price` decimal(10,0) DEFAULT 0,
  `pd_discount_price` decimal(10,0) DEFAULT 0,
  `pd_discount_rate` int(5) DEFAULT NULL,
  `pd_status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '1:Show, 2:Not Show',
  `pd_for` tinyint(2) DEFAULT 0,
  `pd_seo_title` varchar(200) DEFAULT NULL,
  `pd_seo_keys` varchar(300) DEFAULT NULL,
  `pd_seo_desc` varchar(500) DEFAULT NULL,
  `created_at` timestamp NOT NULL DEFAULT current_timestamp(),
  `updated_at` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `products` (`id`, `pd_ct_id`, `pd_ct_links`, `pd_vendor`, `pd_size`, `pd_colour`, `pd_brand`, `pd_name`, `pd_url`, `pd_sku`, `pd_desc`, `pd_care_desc`, `pd_price`, `pd_discount_price`, `pd_discount_rate`, `pd_status`, `pd_for`, `pd_seo_title`, `pd_seo_keys`, `pd_seo_desc`, `created_at`, `updated_at`) VALUES
(2, 53, '53,4,1', NULL, '2,3,4,5', '17,8', NULL, 'SOL-1016', 'sol-1016', '1600441433-1415', '<p>No Rent Option</p>', NULL, '2200', '1760', 20, 1, 0, NULL, NULL, NULL, '2020-09-18 22:03:53', '2021-07-25 06:13:46'),
(3, 53, '53,4,1', NULL, '2,3,4,5', '17', NULL, 'SOL -1015', 'sol-1015', '1600441529-8173', '<p>asdfghjkl;poiuytrewqzxcvbnm,.;lokikjuhygtfrdecvbnjuikm,xswedczaqssssgbhbmn n nmmmnmnnmnmmnbnmbnmmnmnmnnnmnn&nbsp; &nbsp; &nbsp; &nbsp;mm,n,m,m,,,,,,,,x,x,xc,kndffsnsnfn,nf,,fafn,fnfjnfjnjfafjfjfnafn,fan,fa,mf,fnf,nf,nfa,f,f,fn,fn,fn,fn,f,f,f,mfsn,sfn,fnf,nfa,nf,nf,nf,fn,fn,fnf,nf,fn,fn,f,f,fn,fn,ff f f&nbsp; &nbsp;f f f m,kaffjfijfoifon,j,cn,vnn,fn,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; kjjalllllllllllldjdjddjdjdjdjdjdjdjdjdjdjdjdjdjdjdjdjdjdjdjdklelelelelelelelellllllllllllllllllekekekekekekdkdididkdkdkdkdkdkdkdkdkdkdkdkdmcmdmdkdkdkdkdkdidieueyeudm,dll;;;;;;;slkkdkfhkllloiuddndmm,,,...;;llkjjdududdudududioollllllmsmsmsmsmsmsmsmsmsmsmsms</p>', NULL, '2200', '1760', 20, 1, 0, NULL, NULL, NULL, '2020-09-18 22:05:29', '2021-07-30 14:35:39'),
(4, 53, '53,4,1', NULL, '2', '17', NULL, 'Product Code - 28', 'product-code-28', '1600441796-1121', NULL, NULL, '1500', '1125', 25, 1, 0, NULL, NULL, NULL, '2020-09-18 22:09:56', '2021-07-30 10:26:51'),
(5, 53, '53,4,1', NULL, '2,3,4,5', '16,2,13,7', NULL, 'Product Code - 42', 'product-code-42', '1600441872-5642', NULL, NULL, '1500', '1125', 25, 1, 0, NULL, NULL, NULL, '2020-09-18 22:11:12', '2021-07-25 06:13:25'),
(6, 49, '49,4,1', NULL, '2,3,4,5', '13', NULL, 'Product Code - 43', 'product-code-43', '1600441981-8553', NULL, NULL, '1500', '1125', 25, 1, 0, NULL, NULL, NULL, '2020-09-18 22:13:01', '2021-07-29 02:14:48'),
(7, 49, '49,4,1', NULL, '2,3,4,5', '4', NULL, 'Product Code - 45', 'product-code-45', '1600442057-8404', NULL, NULL, '1500', '1125', 25, 1, 0, NULL, NULL, NULL, '2020-09-18 22:14:17', '2021-07-29 02:17:01'),
(8, 49, '49,4,1', NULL, '2,3,4,5', '13', NULL, 'Product Code - 47', 'product-code-47', '1600442128-7755', NULL, NULL, '1500', '1125', 25, 1, 0, NULL, NULL, NULL, '2020-09-18 22:15:28', '2021-07-29 02:15:56'),
(9, 49, '49,4,1', NULL, '1,2,3,4,5', '7,3', 1, 'SOL-1001', 'sol-1001', '1601209039-2182', NULL, NULL, '3500', '3150', 10, 1, 0, NULL, NULL, NULL, '2020-09-27 19:17:19', '2021-07-25 06:10:48'),
(10, 12, '12,3', NULL, '1,2,3,4,5', '9', 1, 'SOL-1002', 'sol-1002', '1601209218-5203', NULL, NULL, '3500', '3150', 10, 1, 0, NULL, NULL, NULL, '2020-09-27 19:20:18', '2021-07-25 05:59:09'),
(11, 45, '45,1', NULL, '1,2,3,4,5', '3', 1, 'SOL-1003', 'sol-1003', '1601209380-6795', '<p>100% Viscose Modal Fabric</p>', NULL, '3500', '3150', 10, 1, 0, NULL, NULL, NULL, '2020-09-27 19:23:00', '2021-07-25 00:02:44'),
(12, 12, '12,3', NULL, '1,2,3,4,5', '10,9', 1, 'SOL-1004', 'sol-1004', '1601209920-6428', NULL, NULL, '3500', '3150', 10, 1, 0, NULL, NULL, NULL, '2020-09-27 19:32:00', '2021-07-29 02:10:44'),
(13, 58, '58,55,23', NULL, '2,3,4', '7', 1, 'SOL-1007', 'sol-1007', '1601210756-4065', NULL, NULL, '4500', '900', 80, 2, 0, NULL, NULL, NULL, '2020-09-27 19:45:56', '2021-08-21 02:07:59'),
(14, 12, '12,3', NULL, '1,2,3,4,5', '20,9', 1, 'SOL-1008', 'sol-1008', '1601211445-2969', NULL, NULL, '2800', '2520', 10, 1, 0, NULL, NULL, NULL, '2020-09-27 19:57:25', '2021-07-29 02:10:18'),
(15, 68, '68,6,2', NULL, '1,2,3,4,5', '2', 1, 'SOL-1009', 'sol-1009', '1601211606-4360', NULL, NULL, '2800', '2520', 10, 2, 0, NULL, NULL, NULL, '2020-09-27 20:00:06', '2021-08-21 02:09:40'),
(16, 12, '12,3', NULL, '2', '6', 1, 'SOL-1010', 'sol-1010', '1601211806-3462', NULL, NULL, '3500', '3150', 10, 1, 0, NULL, NULL, NULL, '2020-09-27 20:03:26', '2021-07-30 10:22:35'),
(17, 12, '12,3', NULL, '1,2,3,4,5', '6,3', 1, 'SOL-1011', 'sol-1011', '1601212019-4494', NULL, NULL, '4500', '4050', 10, 1, 0, NULL, NULL, NULL, '2020-09-27 20:06:59', '2021-07-29 02:09:31'),
(18, 63, '63,28,10', NULL, '1,2,3,4,5', '8,11', 1, 'SOL-1012', 'sol-1012', '1601212266-8789', NULL, NULL, '15500', '15500', 0, 1, 0, NULL, NULL, NULL, '2020-09-27 20:11:06', '2021-07-29 02:08:18'),
(19, 58, '58,55,23', NULL, '1,2,3,4,5', '4,11', 1, 'NBL-001', 'nbl-001', '1601212543-3049', NULL, NULL, '15500', '15500', NULL, 2, 0, NULL, NULL, NULL, '2020-09-27 20:15:43', '2021-08-21 02:07:59'),
(20, 49, '49,4,1', NULL, '1,2,3,4', '2', 1, 'BL-001', 'bl-001', '1601212870-9480', NULL, NULL, '21000', '21000', 0, 1, 0, NULL, NULL, NULL, '2020-09-27 20:21:10', '2021-07-29 02:07:39'),
(21, 12, '12,3', NULL, '2,3,4', '20,23', NULL, 'Combo-001', 'combo-001', '1627137599-3844', NULL, NULL, '55000', '5500', 90, 1, 0, NULL, NULL, NULL, '2021-07-24 21:39:59', '2021-07-29 02:07:17');

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

--
-- Table structure for table `products_stock`
--

CREATE TABLE `products_stock` (
  `id` int(11) NOT NULL,
  `ps_pd_id` int(11) DEFAULT NULL COMMENT 'from table ''products''',
  `ps_cl_id` int(11) DEFAULT NULL COMMENT 'from table ''colour'' ',
  `ps_sz_id` int(11) DEFAULT NULL COMMENT 'from table ''size''',
  `ps_in_stock` tinyint(2) DEFAULT 1
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `products_stock`
--

INSERT INTO `products_stock` (`id`, `ps_pd_id`, `ps_cl_id`, `ps_sz_id`, `ps_in_stock`) VALUES
(2, 2, 17, 2, 1),
(3, 2, 17, 3, 1),
(4, 2, 17, 4, 1),
(5, 2, 17, 5, 1),
(6, 2, 8, 2, 1),
(7, 2, 8, 3, 1),
(8, 2, 8, 4, 1),
(9, 2, 8, 5, 1),
(10, 3, 17, 2, 1),
(11, 3, 17, 3, 1),
(12, 3, 17, 4, 1),
(13, 3, 17, 5, 1),
(19, 4, 17, 2, 1),
(26, 5, 16, 2, 1),
(27, 5, 16, 3, 1),
(28, 5, 16, 4, 1),
(29, 5, 16, 5, 1),
(30, 5, 2, 2, 1),
(31, 5, 2, 3, 1),
(32, 5, 2, 4, 1),
(33, 5, 2, 5, 1),
(34, 5, 13, 2, 1),
(35, 5, 13, 3, 1),
(36, 5, 13, 4, 1),
(37, 5, 13, 5, 1),
(38, 5, 7, 2, 1),
(39, 5, 7, 3, 1),
(40, 5, 7, 4, 1),
(41, 5, 7, 5, 1),
(50, 6, 13, 2, 1),
(51, 6, 13, 3, 1),
(52, 6, 13, 4, 1),
(53, 6, 13, 5, 1),
(82, 9, 3, 1, 1),
(83, 9, 3, 2, 1),
(84, 9, 3, 3, 1),
(85, 9, 3, 4, 1),
(86, 9, 3, 5, 1),
(87, 10, 9, 1, 1),
(88, 10, 9, 2, 1),
(89, 10, 9, 3, 1),
(90, 10, 9, 4, 1),
(91, 10, 9, 5, 1),
(92, 11, 3, 1, 1),
(93, 11, 3, 2, 1),
(94, 11, 3, 3, 1),
(95, 11, 3, 4, 1),
(96, 11, 3, 5, 1),
(97, 12, 9, 1, 1),
(98, 12, 9, 2, 1),
(99, 12, 9, 3, 1),
(100, 12, 9, 4, 1),
(101, 12, 9, 5, 1),
(102, 9, 7, 1, 1),
(103, 9, 7, 2, 1),
(104, 9, 7, 3, 1),
(105, 9, 7, 4, 1),
(106, 9, 7, 5, 1),
(113, 13, 7, 2, 1),
(114, 13, 7, 3, 1),
(115, 13, 7, 4, 1),
(117, 14, 9, 1, 1),
(118, 14, 9, 2, 1),
(119, 14, 9, 3, 1),
(120, 14, 9, 4, 1),
(121, 14, 9, 5, 1),
(122, 15, 2, 1, 1),
(123, 15, 2, 2, 1),
(124, 15, 2, 3, 1),
(125, 15, 2, 4, 1),
(126, 15, 2, 5, 1),
(132, 17, 3, 1, 1),
(133, 17, 3, 2, 1),
(134, 17, 3, 3, 1),
(135, 17, 3, 4, 1),
(136, 17, 3, 5, 1),
(137, 18, 8, 1, 1),
(138, 18, 8, 2, 1),
(139, 18, 8, 3, 1),
(140, 18, 8, 4, 1),
(141, 18, 8, 5, 1),
(142, 19, 4, 1, 1),
(143, 19, 4, 2, 1),
(144, 19, 4, 3, 1),
(145, 19, 4, 4, 1),
(146, 19, 4, 5, 1),
(152, 20, 2, 1, 1),
(153, 20, 2, 2, 1),
(154, 20, 2, 3, 1),
(155, 20, 2, 4, 1),
(157, 21, 23, 2, 1),
(158, 21, 23, 3, 1),
(159, 21, 23, 4, 1),
(164, 19, 11, 1, 1),
(165, 19, 11, 2, 1),
(166, 19, 11, 3, 1),
(167, 19, 11, 4, 1),
(168, 19, 11, 5, 1),
(169, 21, 20, 2, 1),
(170, 21, 20, 3, 1),
(171, 21, 20, 4, 1),
(172, 18, 11, 1, 1),
(173, 18, 11, 2, 1),
(174, 18, 11, 3, 1),
(175, 18, 11, 4, 1),
(176, 18, 11, 5, 1),
(177, 17, 6, 1, 1),
(178, 17, 6, 2, 1),
(179, 17, 6, 3, 1),
(180, 17, 6, 4, 1),
(181, 17, 6, 5, 1),
(183, 16, 6, 2, 1),
(187, 14, 20, 1, 1),
(188, 14, 20, 2, 1),
(189, 14, 20, 3, 1),
(190, 14, 20, 4, 1),
(191, 14, 20, 5, 1),
(192, 12, 10, 1, 1),
(193, 12, 10, 2, 1),
(194, 12, 10, 3, 1),
(195, 12, 10, 4, 1),
(196, 12, 10, 5, 1),
(197, 8, 13, 2, 1),
(198, 8, 13, 3, 1),
(199, 8, 13, 4, 1),
(200, 8, 13, 5, 1),
(201, 7, 4, 2, 1),
(202, 7, 4, 3, 1),
(203, 7, 4, 4, 1),
(204, 7, 4, 5, 1);

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

--
-- Table structure for table `product_media`
--

CREATE TABLE `product_media` (
  `id` int(10) UNSIGNED NOT NULL,
  `product_id` int(10) UNSIGNED NOT NULL,
  `color_id` int(11) DEFAULT NULL,
  `media` varchar(255) NOT NULL,
  `media_type` varchar(100) DEFAULT NULL,
  `serial` varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dumping data for table `product_media`
--

INSERT INTO `product_media` (`id`, `product_id`, `color_id`, `media`, `media_type`, `serial`) VALUES
(1, 3, 17, 'j-2_38807.jpeg', 'image', '1'),
(2, 3, 17, 'img-7885_36299.jpg', 'image', '2'),
(3, 3, 17, 'img-7887_43896.jpg', 'image', '3'),
(4, 3, 17, 'img-7888_92120.jpg', 'image', '4'),
(5, 3, 17, 'img-7883_26460.jpg', 'image', '5'),
(6, 3, 17, 'img-7882_18446.jpg', 'image', '6'),
(7, 2, 8, 'j-1_83042.jpeg', 'image', '1'),
(8, 2, 8, 'img-8333_74470.jpg', 'image', '2'),
(9, 2, 8, 'img-8331_23801.jpg', 'image', '3'),
(10, 2, 8, 'img-8334_79279.jpg', 'image', '4'),
(11, 2, 8, 'img-8336_30390.jpg', 'image', '5'),
(12, 2, 8, 'img-8330_32353.jpg', 'image', '6'),
(13, 2, 17, 'img-8326_46796.jpg', 'image', '1'),
(14, 2, 17, 'img-8327_82424.jpg', 'image', '2'),
(15, 2, 17, 'img-8324_70971.jpg', 'image', '3'),
(16, 2, 17, 'img-8328_63452.jpg', 'image', '4'),
(17, 2, 17, 'img-8329_33822.jpg', 'image', '5'),
(18, 2, 17, 'img-8320_27352.jpg', 'image', '6'),
(19, 4, 2, 'j-5_30374.jpeg', 'image', '1'),
(20, 4, 2, 'img-8375_77136.jpg', 'image', '2'),
(21, 4, 2, 'img-8373_43979.jpg', 'image', '3'),
(22, 4, 2, 'img-8376_34936.jpg', 'image', '4'),
(23, 4, 2, 'img-8377_52948.jpg', 'image', '5'),
(24, 4, 2, 'img-8372_41303.jpg', 'image', '6'),
(25, 4, 13, 'img-8241_39060.jpg', 'image', '1'),
(26, 4, 13, 'img-8242_98053.jpg', 'image', '2'),
(27, 4, 13, 'img-8240_22935.jpg', 'image', '3'),
(28, 4, 13, 'img-8243_97824.jpg', 'image', '4'),
(29, 4, 13, 'img-8244_31094.jpg', 'image', '5'),
(30, 4, 13, 'img-8239_42577.jpg', 'image', '6'),
(31, 4, 17, 'img-8307_76318.jpg', 'image', '1'),
(32, 4, 17, 'img-8308_55243.jpg', 'image', '2'),
(33, 4, 17, 'img-8306_80829.jpg', 'image', '3'),
(34, 4, 17, 'img-8309_75768.jpg', 'image', '4'),
(35, 4, 17, 'img-8310_25658.jpg', 'image', '5'),
(36, 4, 17, 'img-8303_47499.jpg', 'image', '6'),
(37, 5, 2, 'j-7_20352.jpeg', 'image', '1'),
(38, 5, 2, 'img-8406_32715.jpg', 'image', '2'),
(39, 5, 2, 'img-8403_13095.jpg', 'image', '3'),
(40, 5, 2, 'img-8407_84275.jpg', 'image', '4'),
(41, 5, 2, 'img-8408_92625.jpg', 'image', '5'),
(42, 5, 2, 'img-8402_50058.jpg', 'image', '6'),
(43, 5, 7, 'img-8299_28595.jpg', 'image', '1'),
(44, 5, 7, 'img-8300_74304.jpg', 'image', '2'),
(45, 5, 7, 'img-8298_29507.jpg', 'image', '3'),
(46, 5, 7, 'img-8301_27381.jpg', 'image', '4'),
(47, 5, 7, 'img-8302_48347.jpg', 'image', '5'),
(48, 5, 7, 'img-8297_65636.jpg', 'image', '6'),
(49, 5, 13, 'img-8279_42371.jpg', 'image', '1'),
(50, 5, 13, 'img-8280_30752.jpg', 'image', '2'),
(51, 5, 13, 'img-8278_43527.jpg', 'image', '3'),
(52, 5, 13, 'img-8281_66405.jpg', 'image', '4'),
(53, 5, 13, 'img-8282_21849.jpg', 'image', '5'),
(54, 5, 13, 'img-8276_12267.jpg', 'image', '6'),
(55, 5, 16, 'img-8272_84340.jpg', 'image', '1'),
(56, 5, 16, 'img-8273_30926.jpg', 'image', '2'),
(57, 5, 16, 'img-8271_58723.jpg', 'image', '3'),
(58, 5, 16, 'img-8274_60669.jpg', 'image', '4'),
(59, 5, 16, 'img-8275_29265.jpg', 'image', '5'),
(60, 5, 16, 'img-8270_65312.jpg', 'image', '6'),
(61, 6, 13, 'bridal-2_58520.jpeg', 'image', '1'),
(62, 6, 13, 'img-8267_47199.jpg', 'image', '2'),
(63, 6, 13, 'img-8265_68898.jpg', 'image', '3'),
(64, 6, 13, 'img-8268_38695.jpg', 'image', '4'),
(65, 6, 13, 'img-8269_28325.jpg', 'image', '5'),
(66, 6, 13, 'img-8264_78176.jpg', 'image', '6'),
(67, 6, 20, 'img-8398_97225.jpg', 'image', '1'),
(68, 6, 20, 'img-8399_31928.jpg', 'image', '2'),
(69, 6, 20, 'img-8395_82549.jpg', 'image', '3'),
(70, 6, 20, 'img-8401_20626.jpg', 'image', '4'),
(71, 6, 20, 'img-8400_86448.jpg', 'image', '5'),
(72, 6, 20, 'img-8394_97116.jpg', 'image', '6'),
(73, 6, 23, 'img-8259_78238.jpg', 'image', '1'),
(74, 6, 23, 'img-8260_73293.jpg', 'image', '2'),
(75, 6, 23, 'img-8258_76245.jpg', 'image', '3'),
(76, 6, 23, 'img-8261_55627.jpg', 'image', '4'),
(77, 6, 23, 'img-8262_39969.jpg', 'image', '5'),
(78, 6, 23, 'img-8257_48146.jpg', 'image', '6'),
(79, 8, 13, 'bridal-3_22367.jpeg', 'image', '1'),
(80, 8, 13, 'img-8286_50215.jpg', 'image', '2'),
(81, 8, 13, 'img-8284_79385.jpg', 'image', '3'),
(82, 8, 13, 'img-8287_87259.jpg', 'image', '4'),
(83, 8, 13, 'img-8288_85497.jpg', 'image', '5'),
(84, 8, 13, 'img-8283_24965.jpg', 'image', '6'),
(85, 8, 17, 'img-8209_78481.jpg', 'image', '1'),
(86, 8, 17, 'img-8210_73940.jpg', 'image', '2'),
(87, 8, 17, 'img-8207_91190.jpg', 'image', '3'),
(88, 8, 17, 'img-8211_68821.jpg', 'image', '4'),
(89, 8, 17, 'img-8212_53593.jpg', 'image', '5'),
(90, 8, 17, 'img-8206_22281.jpg', 'image', '6'),
(91, 8, 20, 'img-8390_57410.jpg', 'image', '1'),
(92, 8, 20, 'img-8391_90853.jpg', 'image', '2'),
(93, 8, 20, 'img-8392_97788.jpg', 'image', '3'),
(94, 8, 20, 'img-8389_89961.jpg', 'image', '4'),
(95, 8, 20, 'img-8393_29102.jpg', 'image', '5'),
(96, 8, 20, 'img-8386_33002.jpg', 'image', '6'),
(97, 7, 2, 'bridal-4_24389.jpeg', 'image', '1'),
(98, 7, 2, '0p5a3795_15280.jpg', 'image', '2'),
(99, 7, 2, '0p5a3793_76635.jpg', 'image', '3'),
(100, 7, 2, '0p5a3796_43382.jpg', 'image', '4'),
(101, 7, 2, '0p5a3798_78278.jpg', 'image', '5'),
(102, 7, 2, '0p5a3792_47419.jpg', 'image', '6'),
(103, 7, 16, 'img-8253_96220.jpg', 'image', '1'),
(104, 7, 16, 'img-8254_85627.jpg', 'image', '2'),
(105, 7, 16, 'img-8252_40307.jpg', 'image', '3'),
(106, 7, 16, 'img-8255_94291.jpg', 'image', '4'),
(107, 7, 16, 'img-8256_33725.jpg', 'image', '5'),
(108, 7, 16, 'img-8251_19903.jpg', 'image', '6'),
(109, 7, 17, 'img-8247_22314.jpg', 'image', '1'),
(110, 7, 17, 'img-8248_23671.jpg', 'image', '2'),
(111, 7, 17, 'img-8246_75292.jpg', 'image', '3'),
(112, 7, 17, 'img-8249_13625.jpg', 'image', '4'),
(113, 7, 17, 'img-8250_62084.jpg', 'image', '5'),
(114, 7, 17, 'img-8245_19496.jpg', 'image', '6'),
(115, 7, 20, 'img-8380_79433.jpg', 'image', '1'),
(116, 7, 20, 'img-8381_20628.jpg', 'image', '2'),
(117, 7, 20, 'img-8379_50648.jpg', 'image', '3'),
(118, 7, 20, 'img-8384_20555.jpg', 'image', '4'),
(119, 7, 20, 'img-8383_93729.jpg', 'image', '5'),
(120, 7, 20, 'img-8378_29032.jpg', 'image', '6'),
(121, 9, 3, 'bridal-5_31254.jpeg', 'image', '1'),
(122, 9, 3, '013b_37916.jpg', 'image', '2'),
(123, 10, 9, 'combo-4_78346.jpg', 'image', '1'),
(124, 10, 9, '024c_49387.jpg', 'image', '2'),
(125, 10, 9, '024b_57416.jpg', 'image', '3'),
(126, 11, 3, 'unnamed_39096.jpg', 'image', '1'),
(127, 11, 3, '025b_38364.jpg', 'image', '2'),
(128, 12, 9, 'combo-2_83339.jpg', 'image', '1'),
(129, 12, 9, '022b_49297.jpg', 'image', '2'),
(130, 13, 4, '015_99364.jpg', 'image', '1'),
(131, 13, 4, '015b_23379.jpg', 'image', '2'),
(132, 13, 7, '015_90444.jpg', 'image', '1'),
(133, 13, 7, '015b_66821.jpg', 'image', '2'),
(134, 14, 9, 'combo-1_41278.jpg', 'image', '1'),
(135, 14, 9, '012c_53329.jpg', 'image', '2'),
(136, 14, 9, '012d_90630.jpg', 'image', '3'),
(137, 14, 9, '012b_94729.jpg', 'image', '4'),
(138, 15, 2, 'screen-shot-2021-07-25-at-54530-am_60028.png', 'image', '1'),
(139, 15, 2, '011_91707.jpg', 'image', '2'),
(140, 15, 2, '010b_61913.jpg', 'image', '3'),
(141, 15, 2, '011b_68504.jpg', 'image', '4'),
(142, 16, 8, 'screen-shot-2021-07-25-at-54030-am_49006.png', 'image', '1'),
(143, 16, 8, 'k016b_89057.jpg', 'image', '2'),
(144, 16, 8, 'k016c_26448.jpg', 'image', '3'),
(145, 17, 3, 'screen-shot-2021-07-25-at-52431-am_53668.png', 'image', '1'),
(146, 17, 3, 'd001b_22106.jpg', 'image', '2'),
(147, 17, 3, 'd001c_95269.jpg', 'image', '3'),
(148, 18, 8, 'screen-shot-2021-07-24-at-80533-pm_16719.png', 'image', '1'),
(149, 19, 4, 'annotation-2020-06-14-132537_56660.jpg', 'image', '1'),
(150, 20, 2, 'screen-shot-2021-07-24-at-80216-pm_61817.png', 'image', '1'),
(151, 21, 23, 'screen-shot-2021-07-24-at-80359-pm_38661.png', 'image', '1');

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

--
-- Table structure for table `promo_code`
--

CREATE TABLE `promo_code` (
  `id` int(11) NOT NULL,
  `pr_name` varchar(100) DEFAULT NULL,
  `pr_value_per` decimal(10,0) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `promo_code`
--

INSERT INTO `promo_code` (`id`, `pr_name`, `pr_value_per`) VALUES
(1, 'MAGIC10', '10');

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

--
-- Table structure for table `return_msg`
--

CREATE TABLE `return_msg` (
  `id` int(11) NOT NULL,
  `rm_name` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `reviews`
--

CREATE TABLE `reviews` (
  `id` int(11) NOT NULL,
  `r_uid` int(11) NOT NULL COMMENT 'from table ''user''',
  `r_pd_id` int(11) NOT NULL COMMENT 'from table ''products''',
  `r_rating` tinyint(2) DEFAULT NULL,
  `r_comment` varchar(300) DEFAULT NULL,
  `r_status` tinyint(2) NOT NULL DEFAULT 1 COMMENT '0:Not Show, 1:Show',
  `created_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `seo`
--

CREATE TABLE `seo` (
  `id` int(11) NOT NULL,
  `seo_title` varchar(300) DEFAULT NULL,
  `seo_keyword` varchar(3000) DEFAULT NULL,
  `seo_desc` varchar(3000) DEFAULT NULL,
  `seo_url` varchar(300) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `seo`
--

INSERT INTO `seo` (`id`, `seo_title`, `seo_keyword`, `seo_desc`, `seo_url`) VALUES
(1, 'Home | Advology Solution', 'seo, smo, ppc', 'Advology Home', 'index.php'),
(2, 'About Us | Advology Solution', 'about us', 'Advology About', 'about-us.php'),
(3, 'Services | Advology Solution', 'services', 'Advology Services', 'services.php'),
(4, 'Contact Us | Advology Solution', 'contact', 'Advology Contact', 'contact-us.php'),
(5, 'Career | Advology Solution', 'career', 'Advology Career', 'careers.php'),
(6, 'FAQ | Advology Solution', 'faq', 'Advology FAQ', 'faq.php'),
(7, 'Site Map | Advology Solution', 'sitemap, direction', 'Advology SiteMap', 'sitemap.php'),
(8, 'Privacy Policy | Advology Solution', 'privacy', 'Advology Privacy Policy', 'privacy-policy.php'),
(9, 'Terms & Conditions | Advology Solution', 'terms, condition', 'Advology Terms & Condition', 'term-condition.php'),
(10, 'Refund Policy | Advology Solution', 'refund', 'Advology Refund Policy', 'refund-policy.php'),
(11, 'Quick Request | Advology Solution', 'request, quick', 'Advology Quick Request', 'quick-request.php#quickrequest'),
(12, 'Blogs | Advology Solution', 'blogs, posts', 'Advology Blogs', 'blog.php'),
(13, 'Portfolio | Advology Solution', 'portfolio, work', 'Advology Portfolio', 'portfolio.php'),
(14, 'Payment | Advology Solution', 'payment', 'Advology Payment', 'payment.php'),
(15, 'SEO | Advology Solution', 'seo', 'Advology SEO', 'seo-services.php'),
(16, 'Mobile App Development | Advology Solution', 'app development', 'Advology Mobile App', 'mobile-app-development.php'),
(17, 'SMO | Advology Solution', 'smo', 'Advology SMO', 'social-media-marketing.php'),
(18, 'Website Designing | Advology Solution', 'website design', 'Advology Web Design', 'website-designing.php'),
(19, 'Web Development | Advology Solution', 'web development', 'Advology Web Development', 'web-development.php'),
(20, 'Content Writing | Advology Solution', 'content writing', 'Advology Content Writing', 'content-writing.php'),
(21, 'PPC | Advology Solution', 'ppc', 'Advology PPC', 'pay-per-click.php'),
(22, 'Web Hosting | Advology Solution', 'hosting', 'Advology Hosting', 'web-hosting.php');

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

--
-- Table structure for table `size`
--

CREATE TABLE `size` (
  `id` int(11) NOT NULL,
  `sz_name` varchar(200) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `size`
--

INSERT INTO `size` (`id`, `sz_name`) VALUES
(1, 'XS'),
(2, 'S'),
(3, 'M'),
(4, 'L'),
(5, 'XL'),
(6, 'XXL');

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

--
-- Table structure for table `size_price`
--

CREATE TABLE `size_price` (
  `id` int(11) NOT NULL,
  `pid` int(11) NOT NULL,
  `size_id` int(11) NOT NULL,
  `price` float(10,2) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

--
-- Table structure for table `slider`
--

CREATE TABLE `slider` (
  `id` int(11) NOT NULL,
  `sl_image` varchar(200) DEFAULT NULL,
  `sl_text1` varchar(200) DEFAULT NULL,
  `sl_text2` varchar(200) DEFAULT NULL,
  `sl_position` varchar(50) DEFAULT NULL,
  `ct_id` tinyint(2) DEFAULT NULL COMMENT 'from ''category'' table'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `slider`
--

INSERT INTO `slider` (`id`, `sl_image`, `sl_text1`, `sl_text2`, `sl_position`, `ct_id`) VALUES
(1, 'lehanga_86237.jpeg', 'Just Launched-Work From Anywhere', 'The Wardrobe Change Is Coming', 'Top', 1),
(2, 'slider3.jpg', 'Plus Size Collection', 'Plus Size  Don\'t Worry / Free Shipping on All Orders', 'Top', 3),
(3, 'slider4.jpg', 'Shop Influencer Look', 'Day To Night Look', 'Top', 2),
(11, NULL, 'Comfy & Casual or Sleek & Polished', 'SHERROL! Before it sells out', 'Mid', 2),
(12, 'slider2_91391.jpg', 'The Collection You Have Been Waiting For', 'Layer Up In New', 'Bottom-Runner', 2),
(13, 'slider2_37335.jpg', 'Wardrobe Staples', 'Before it sells out again...', 'Category-Runner', NULL);

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

--
-- Table structure for table `testimonial`
--

CREATE TABLE `testimonial` (
  `id` int(11) NOT NULL,
  `te_name` varchar(255) DEFAULT NULL,
  `te_image` varchar(255) DEFAULT NULL,
  `te_desc` text DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `testimonial`
--

INSERT INTO `testimonial` (`id`, `te_name`, `te_image`, `te_desc`) VALUES
(1, 'Amit Kumar', 'user_68244.png', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.'),
(2, 'Pankaj Saini', 'user_85714.png', 'Lorem Ipsum is simply dummy text of the printing and typesetting industry.');

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- Indexes for table `product_media`
--
ALTER TABLE `product_media`
  ADD PRIMARY KEY (`id`),
  ADD KEY `idx_products_images_products_id` (`product_id`);

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for dumped tables
--

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

--
-- AUTO_INCREMENT for table `product_media`
--
ALTER TABLE `product_media`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=152;

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

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

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

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

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

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

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

