1#@!#!123s

��JFIF�� 1#@!#!123s
: / home / earnlouq / qarkt.com / database /
Filename : igboanugo.sql
back
-- phpMyAdmin SQL Dump
-- version 5.1.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Feb 25, 2023 at 09:08 AM
-- Server version: 10.4.22-MariaDB
-- PHP Version: 8.1.1

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


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

--
-- Database: `igboanugo`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE `admin` (
  `id` int(11) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `updationDate` varchar(255) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`id`, `username`, `password`, `updationDate`) VALUES
(1, 'admin', '631c1de754e98780d71d60027d9ed27b', '20-08-2020 05:07:27 AM'),
(2, 'admin', '21832155F46FBD31598C4BCD8782670C', ''),
(3, 'credenceadmin', '45BB529F8316193D0595F13992408D64', '');

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

--
-- Table structure for table `adminlog`
--

CREATE TABLE `adminlog` (
  `id` int(11) NOT NULL,
  `uid` int(11) DEFAULT NULL,
  `username` varchar(255) DEFAULT NULL,
  `userip` binary(16) DEFAULT NULL,
  `loginTime` timestamp NULL DEFAULT current_timestamp(),
  `logout` varchar(255) DEFAULT NULL,
  `status` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `adminlog`
--

INSERT INTO `adminlog` (`id`, `uid`, `username`, `userip`, `loginTime`, `logout`, `status`) VALUES
(13, 0, 'admin', 0x3a3a3100000000000000000000000000, '2022-10-27 09:05:08', NULL, 0),
(14, 1, 'admin', 0x3a3a3100000000000000000000000000, '2022-10-27 09:05:20', '27-10-2022 02:39:25 PM', 1),
(15, 1, 'admin', 0x3a3a3100000000000000000000000000, '2022-10-27 09:17:16', NULL, 1),
(16, 1, 'admin', 0x3132372e302e302e3100000000000000, '2022-10-27 09:49:30', '27-10-2022 08:33:25 PM', 1),
(17, 1, 'admin', 0x3a3a3100000000000000000000000000, '2022-10-27 15:56:56', NULL, 1),
(18, 1, 'admin', 0x3132372e302e302e3100000000000000, '2023-02-25 08:05:58', NULL, 1);

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

--
-- Table structure for table `brands`
--

CREATE TABLE `brands` (
  `brand_id` int(100) NOT NULL,
  `brand_title` text NOT NULL,
  `brand_image` varchar(225) DEFAULT NULL,
  `creationDate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updationDate` varchar(225) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `brands`
--

INSERT INTO `brands` (`brand_id`, `brand_title`, `brand_image`, `creationDate`, `updationDate`) VALUES
(5, 'Hennessy', '', '2021-09-23 12:17:42', ''),
(6, 'Martell', '', '2021-09-23 12:35:38', ''),
(7, 'Remy Martin', '', '2021-09-24 10:49:58', ''),
(8, 'Whisky', '', '2021-09-24 11:07:34', ''),
(9, 'Vodca', '', '2021-09-24 11:24:05', '');

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

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

CREATE TABLE `cart` (
  `id` int(10) NOT NULL,
  `p_id` int(10) NOT NULL,
  `ip_add` varchar(250) NOT NULL,
  `user_id` int(10) NOT NULL,
  `product_title` varchar(300) NOT NULL,
  `product_image` text NOT NULL,
  `qty` int(100) NOT NULL,
  `price` int(100) NOT NULL,
  `total_amount` int(100) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `cart` (`id`, `p_id`, `ip_add`, `user_id`, `product_title`, `product_image`, `qty`, `price`, `total_amount`) VALUES
(38, 40, '197.210.78.210', -1, 'Fierce Euphoria Erotism Suction Lipstick', 'products-3.png', 2, 31000, 62000),
(70, 40, '::1', 5, 'Eva Wine', 'product-4.jpg', 1, 31000, 31000),
(71, 39, '::1', 5, 'Martell Cognac', 'product-3.jpeg', 1, 27000, 27000),
(72, 37, '::1', 5, 'Eliot', 'product-2.jpeg', 1, 11500, 11500),
(73, 36, '::1', 5, 'Baron Romero', 'product-1.jpg', 1, 10000, 10000),
(74, 64, '::1', 5, 'Baron Romero', 'product-1.jpg', 1, 470000, 470000),
(75, 43, '::1', 5, 'Jameson', 'product-5.png', 1, 46000, 46000),
(76, 39, '::1', -1, 'Martell Cognac', 'product-3.jpeg', 1, 27000, 27000),
(77, 41, '127.0.0.1', 5, 'Remy Martin Vsop', 'product-5.webp', 1, 36000, 36000);

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

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

CREATE TABLE `categories` (
  `cat_id` int(100) NOT NULL,
  `cat_title` text NOT NULL,
  `creationDate` datetime NOT NULL DEFAULT current_timestamp(),
  `updationDate` varchar(226) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `categories` (`cat_id`, `cat_title`, `creationDate`, `updationDate`) VALUES
(7, 'Drinks and Wines', '2021-11-02 20:12:20', NULL),
(8, 'Toiletries', '2021-11-02 20:12:20', NULL),
(9, 'Groceries and Soft Drinks', '2021-11-02 20:12:20', NULL),
(12, 'Soft and Energy Drinks', '2021-12-07 19:08:30', NULL);

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

--
-- Table structure for table `customer_order`
--

CREATE TABLE `customer_order` (
  `id` int(100) NOT NULL,
  `pid` int(100) NOT NULL,
  `uid` int(11) DEFAULT NULL,
  `p_name` varchar(255) NOT NULL,
  `p_price` int(100) NOT NULL,
  `p_qty` int(100) NOT NULL,
  `p_status` varchar(100) NOT NULL,
  `trx_id` varchar(300) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

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

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

CREATE TABLE `products` (
  `product_id` int(100) NOT NULL,
  `product_title` varchar(300) NOT NULL,
  `product_cat_id` int(11) NOT NULL,
  `product_price` double NOT NULL,
  `product_desc` longtext DEFAULT NULL,
  `product_image` text NOT NULL,
  `product_tag` varchar(225) DEFAULT NULL,
  `product_brand_id` int(100) NOT NULL,
  `stock` int(100) NOT NULL,
  `status` int(11) DEFAULT 1,
  `availability` varchar(225) NOT NULL DEFAULT 'In Stock',
  `product_keywords` text NOT NULL,
  `counter` int(11) NOT NULL,
  `date_view` date NOT NULL,
  `creationDate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updationDate` varchar(225) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `products` (`product_id`, `product_title`, `product_cat_id`, `product_price`, `product_desc`, `product_image`, `product_tag`, `product_brand_id`, `stock`, `status`, `availability`, `product_keywords`, `counter`, `date_view`, `creationDate`, `updationDate`) VALUES
(36, 'Baron Romero', 7, 10000, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur ornare, mi in ornare elementum, libero nibh lacinia urna, quis convallis lorem erat at purus. Maecenas eu varius nisi.', 'product-1.jpg', 'HOT', 5, 10, 1, 'Out of Stock', 'tshirt', 5, '2022-10-26', '2021-11-02 17:46:43', NULL),
(37, 'Eliot', 7, 11500, NULL, 'product-2.jpeg', 'LATEST', 6, 0, 1, 'In Stock', 'shirt', 1, '2022-10-23', '2021-11-02 17:46:43', NULL),
(39, 'Martell Cognac', 7, 27000, NULL, 'product-3.jpeg', NULL, 0, 0, 1, 'In Stock', 'sneaker', 2, '2022-10-21', '2021-11-02 17:46:43', NULL),
(40, 'Eva Wine', 7, 31000, 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur ornare, mi in ornare elementum, libero nibh lacinia urna, quis convallis lorem erat at purus. Maecenas eu varius nisi.', 'product-4.jpg', NULL, 0, 5, 1, 'In Stock', '', 3, '2022-10-21', '2021-11-02 17:46:43', NULL),
(41, 'Remy Martin Vsop', 7, 36000, NULL, 'product-5.webp', NULL, 0, 0, 1, 'In Stock', 'sneaker, shoe', 1, '2022-11-04', '2021-11-02 17:46:43', NULL),
(42, 'Martell Cognac', 7, 36000, NULL, 'product-3.jpeg', NULL, 0, 0, 1, 'In Stock', 'sneaker,shoe', 1, '2022-10-21', '2021-11-02 17:46:43', NULL),
(43, 'Jameson', 7, 46000, NULL, 'product-5.png', NULL, 0, 0, 1, 'In Stock', '', 11, '2022-10-21', '2021-11-02 17:46:43', NULL),
(64, 'Baron Romero', 7, 470000, NULL, 'product-1.jpg', NULL, 0, 0, 1, 'In Stock', '', 2, '2022-05-04', '2021-11-02 17:46:43', NULL),
(65, 'Nivea Perfect & Radiant Even Tone 3 in 1 Cleanser 150 ml', 8, 3500, 'Buy Nivea Perfect & Radiant Even Tone 3 in 1 Cleanser 150 ml on Supermart.ng. This facial cleanser is great for removing makeup, excess oil, dirt, dead skin cells and other impurities that can damage your face. They also help to unclog skin pores and prevent skin conditions like acne. When next you get home from a day at the office or a night on the town, this facial cleaners will help you remove all the makeup and get your face feeling fresh again. This product will leave your face feeling fresh, soft and brand new. Your facial care regime will be incomplete without this. If you want to find the best price of facial cleanser in Nigeria, then this is the right place. At Supermart.ng, you can order online and get same-day delivery in Lagos. For those who don\'t know where to buy facial cleanser in Nigeria, you may check supermarkets near me and local shops in your neighbourhood but for convenience and peace of mind, it\'s better to shop online. It may be worthwhile also doing a search for grocery delivery near me to find it at a cheap rate. Friends may ask where can I get it or how much is it and once you\'ve tried the service, you\'ll be able to answer all their questions and refer them to the number 1 online supermarket. Supermart.ng is the perfect site to do your grocery shopping - low prices and huge discounts always. Most products come with directions for how to use them but if the product is not branded or doesn\'t have any label or packaging, you can check online or ask friends for directions for use. Consumer goods products made by manufacturers will typically come with instructions for use; if you don\'t find this enclosed, exercise caution before using or consuming any product you\'re unfamiliar with. It is made by one of the most popular manufacturers for this product category and there are hundreds of distributors that supply it across supermarkets and markets in Lagos, Nigeria. If you want to know where to purchase it, the best place to check is an online retailer that you can order online from and have delivered to you at home. This is one of the top selling products in Nigeria and also one of the most famous brands.', 'product-6.jpg', NULL, 2, 0, 0, 'In Stock', '', 0, '0000-00-00', '2022-10-20 19:13:50', NULL),
(66, 'Colgate Toothpaste Optic White 75 ml', 8, 1400, 'Buy Colgate Toothpaste Optic White 75 ml on Supermart.ng. Good dental and oral care is essential. If you want healthy teeth and gums, you should brush your teeth twice a day with a good toothbrush and toothpaste. You can also rinse afterwards with a mouthwash of your choice. Oral hygiene, if practiced properly, will protect your mouth, tongue, teeth and gums from diseases and infections. You can also avoid bad breath, tooth decay and other oral hygiene problems by cleaning your teeth regularly. It is also advisable to change your toothbrush regularly especially after an illness. When selecting toothpaste, go for one that contain fluoride which helps fight caivities. Rather than poke your teeth and gums with foreign objects, use a good floss to clean inbetween your teeth. A good tongue cleaner and interdental brush will come in handy for your oral care. If you want to find the best price of toothpaste in Nigeria, then this is the right place. At Supermart.ng, you can order online and get same-day delivery in Lagos. For those who don\'t know where to buy toothpaste in Nigeria, you may check supermarkets near me and local shops in your neighbourhood but for convenience and peace of mind, it\'s better to shop online. It may be worthwhile also doing a search for grocery delivery near me to find it at a cheap rate. Friends may ask where can I get it or how much is it and once you\'ve tried the service, you\'ll be able to answer all their questions and refer them to the number 1 online supermarket. Supermart.ng is the perfect site to do your grocery shopping - low prices and huge discounts always. Most products come with directions for how to use them but if the product is not branded or doesn\'t have any label or packaging, you can check online or ask friends for directions for use. Consumer goods products made by manufacturers will typically come with instructions for use; if you don\'t find this enclosed, exercise caution before using or consuming any product you\'re unfamiliar with. It is made by one of the most popular manufacturers for this product category and there are hundreds of distributors that supply it across supermarkets and markets in Lagos, Nigeria. If you want to know where to purchase it, the best place to check is an online retailer that you can order online from and have delivered to you at home. This is one of the top selling products in Nigeria and also one of the most famous brands. One of the first questions customers ask about a product is - how much does it cost? And the answer is - not a lot if you\'re buying online from Supermart.ng. The undisputed online retailer to get low prices and huge discounts always.', 'product-7.png', NULL, 2, 10, 0, 'In Stock', '', 15, '2022-10-21', '2022-10-20 19:13:50', NULL),
(67, 'Hollandia Yoghurt Drink Strawberry 100 cl', 9, 905, 'Buy Hollandia Yoghurt Drink Strawberry 100 cl on Supermart.ng. This yoghurt drink is a tasty beverage for both kids and adults. It\'s rich in flavour and can be drank at any time of the day. When you\'re thirsty and want something creamy and refreshing, this yoghurt drink is a good choice. It\'s best drank cold. Yoghurt comes in two forms - the solid, creamy version or the liquid version which can be drank from a glass or bottle. Yoghurt and yoghurt drinks are very refreshing and can be eaten or drank on its own or combined with various meals. No need to stress yourself making yoghurt at home when you can buy a great tasting one like this. Hollandia Yoghurt Strawberry has a sleek, creamy and luxurious texture. Its flavour is delicious and will leave your taste buds with an unerasable memory. Let it wet your tongue, massage your throat and nourish your body. Aside from its smooth, pure and delicious taste, it is also high in protein, calcium, vitamins, and live culture, or probiotics, which can enhance the gut microbiota. These can offer protection for bones and teeth and help prevent digestive problems. Low-fat yogurt can be a useful source of protein on a weight-loss diet.So on a hot and sunny day, when drops of sweat travel across your brow and your saliva becomes sticky. When your clothes stick to your body and your throat feels dry and flaky. You can always revitalize your body with the refreshing goodness of Hollandia. HOLLANDIA is a superb product of CHI Limited, the undisputed Market Leader in Fruit Juices, Dairy-based beverages & Snacks in Nigeria. Strawberry flavoured yoghurt drinks are very popular with children and adults and because they come in compact sizes, they can be drank on-the-go. Drinkable yogurt flavoured with strawberry has a rich, creamy annd fruity taste that provides nourishment at all times of day. Drinking yogurt conntains calcium, protein and other nnutrients that offer health benefits and the strawberry flavour just adds an extra dimension to the taste. The combination of yogurt and fruit in a drinkable format has been gaining traction for many years in Nigeria with people now conisdering it a decent option to be consumed as a healthy snack or as part of a main meal. If you want to find the best price of yoghurt drink in Nigeria, then this is the right place. At Supermart.ng, you can order online and get same-day delivery in Lagos. For those who don\'t know where to buy yoghurt drink in Nigeria, you may check supermarkets near me and local shops in your neighbourhood but for convenience and peace of mind, it\'s better to shop online. It may be worthwhile also doing a search for grocery delivery near me to find it at a cheap rate. Friends may ask where can I get it or how much is it and once you\'ve tried the service, you\'ll be able to answer all their questions and refer them to the number 1 online supermarket. Supermart.ng is the perfect site to do your grocery shopping - low prices and huge discounts always. Most products come with directions for how to use them but if the product is not branded or doesn\'t have any label or packaging, you can check online or ask friends for directions for use. Consumer goods products made by manufacturers will typically come with instructions for use; if you don\'t find this enclosed, exercise caution before using or consuming any product you\'re unfamiliar with. It is made by one of the most popular manufacturers for this product category and there are hundreds of distributors that supply it across supermarkets and markets in Lagos, Nigeria. If you want to know where to purchase it, the best place to check is an online retailer that you can order online from and have delivered to you at home. This is one of the top selling products in Nigeria and also one of the most famous brands. One of the first questions customers ask about a product is - how much does it cost? And the answer is - not a lot if you\'re buying online from Supermart.ng. If you want to know the health benefits, check the ingredients and contents which will be stated on the packaging if available. Otherwise, you can do an online search to know more about it.', 'product-8.png', NULL, 3, 8, 0, 'In Stock', '', 0, '0000-00-00', '2022-10-20 19:20:35', NULL),
(68, 'Milo Energy Food Drink 18 cl x12', 9, 1560, 'Buy Milo Energy Food Drink 18 cl x12 on Supermart.ng. Milo is a rich and powdered formulation of chocolate extracts, malted barley, solid milk, sugar, vegetable oil aggregates (palm oil, palm olein, coconut oil, palm kernel oil, whey, corn oil, soya oil) and ACTIGENEThe price is affordable relative to the mix of ingredients. Tasty and trusted, Milo brand is the world?s leading chocolate malt beverage that can be prepared with hot or cold milk or water. It offers essential vitamins and minerals to meet the nutrition and energy demands of young bodies and mindsThis helps you concentrate better and longer in the class, and keeps you feeling energetic even after school. MILO aids in the release of energy from food with a combination of B vitamins and Magnesium. Other nutritional benefits of Milo drink include;Vitamin C to keep gums and skin in good shapeIron to aid the transport of oxygen to body cellsCalcium for strong teeth and bonesVitamin A for eyesight. Buy Milo Energy Food Drink 18 cl on Supermart.ng. This milk drink is a tasty beverage for both kids and adults. It\'s rich in flavour and can be drank at any time of the day. When you\'re thirsty and want something creamy and refreshing, this milk drink is a good choice. It\'s best drank cold. Chocolate fruit flavoured milk drinks are a tasty beverage primarily targetted at kids but also loved by adults of all ages. Chocolate milk juice drinks are rich in flavour and can be drank at any time of the day. Though a milk and juice blend may seem unusual, they are a great way to get kids who wouldn\'t usually drink plain milk to get the nutrients packed in dairy milk. When you\'re thirsty and want something creamy and refreshing, this chocolate flavoured milk drink is a good choice. Whatever your preferred brand of chocolate fruit-flavoured milk, it\'s best drank cold. Because many of them come in small handy packs (either plastic bottles or tetra pak), they\'re a popular choice for parents to give to kids for their school lunnch. Before you buy, check the ingredients to be certain that it contains enough nutrients, minerals and vitamins to provide nnutritional value to you and your kids diet. If you want to find the best price of milk drink in Nigeria, then this is the right place. At Supermart.ng. , you can order online and get same-day delivery in Lagos. For those who don\'t know where to buy milk drink in Nigeria, you may check supermarkets near me and local shops in your neighbourhood but for convenience and peace of mind, it\'s better to shop online. It may be worthwhile also doing a search for grocery delivery near me to find it at a cheap rate. Friends may ask where can I get it or how much is it and once you\'ve tried the service, you\'ll be able to answer all their questions and refer them to the number 1 online supermarket. Supermart.ng. is the perfect site to do your grocery shopping - low prices and huge discounts always. Most products come with directions for how to use them but if the product is not branded or doesn\'t have any label or packaging, you can check online or ask friends for directions for use.', 'product-9.jpg', NULL, 5, 0, 0, 'In Stock', '', 0, '0000-00-00', '2022-10-20 19:20:35', NULL),
(69, 'Sensodyne Daily Care 75 ml', 8, 895, 'Buy Sensodyne Daily Care 75 ml on Supermart.ng. Good dental and oral care is essential. If you want healthy teeth and gums, you should brush your teeth twice a day with a good toothbrush and toothpaste. You can also rinse afterwards with a mouthwash of your choice. Oral hygiene, if practiced properly, will protect your mouth, tongue, teeth and gums from diseases and infections. You can also avoid bad breath, tooth decay and other oral hygiene problems by cleaning your teeth regularly. It is also advisable to change your toothbrush regularly especially after an illness. When selecting toothpaste, go for one that contain fluoride which helps fight caivities. Rather than poke your teeth and gums with foreign objects, use a good floss to clean inbetween your teeth. A good tongue cleaner and interdental brush will come in handy for your oral care. If you want to find the best price of toothpaste in Nigeria, then this is the right place. At Supermart.ng, you can order online and get same-day delivery in Lagos. For those who don\'t know where to buy toothpaste in Nigeria, you may check supermarkets near me and local shops in your neighbourhood but for convenience and peace of mind, it\'s better to shop online. It may be worthwhile also doing a search for grocery delivery near me to find it at a cheap rate. Friends may ask where can I get it or how much is it and once you\'ve tried the service, you\'ll be able to answer all their questions and refer them to the number 1 online supermarket. Supermart.ng is the perfect site to do your grocery shopping - low prices and huge discounts always. Most products come with directions for how to use them but if the product is not branded or doesn\'t have any label or packaging, you can check online or ask friends for directions for use. Consumer goods products made by manufacturers will typically come with instructions for use; if you don\'t find this enclosed, exercise caution before using or consuming any product you\'re unfamiliar with. It is made by one of the most popular manufacturers for this product category and there are hundreds of distributors that supply it across supermarkets and markets in Lagos, Nigeria. If you want to know where to purchase it, the best place to check is an online retailer that you can order online from and have delivered to you at home. This is one of the top selling products in Nigeria and also one of the most famous brands. One of the first questions customers ask about a product is - how much does it cost? And the answer is - not a lot if you\'re buying online from Supermart.ng. The undisputed online retailer to get low prices and huge discounts always.', 'product-10.jpg', NULL, 5, 5, 0, 'In Stock', '', 0, '0000-00-00', '2022-10-20 19:35:17', NULL),
(70, 'Irish Spring Body Wash Active Refresh 532 ml', 8, 3250, 'Buy Irish Spring Body Wash Active Refresh 532 ml on Supermart.ng. A good body wash will not just get you clean, it will also leaving you feeling fresh and smelling good. Some people prefer a liquid shower gel to bar soaps and this is because they often come in a range of enticing fragrances. Shower gels typically come in bright colours and have a fruity or sporty fragrance while shower creams or moisturising body wash are thicker and creamier. This type of body wash will contain moisturisers so that your skin is soft and moisturised after bathing; these are good for people with dry skin. When it\'s time for a bath or shower, you should use the very best products to get clean, protect your skin and to make you feel good. Supermart.ng is the leading online supermarket and grocery delivery service in Nigeria. Order online from over 10,000 groceries and receive same-day delivery. Get the best prices and discounts on groceries in Nigeria here. Why go to the supermarket when Supermart can come to you? Buy your groceries online on Supermart.ng today. If you want to find the best price of body wash in Nigeria, then this is the right place. At Supermart.ng, you can order online and get same-day delivery in Lagos. For those who don\'t know where to buy shower gel in Nigeria, you may check supermarkets near me and local shops in your neighbourhood but for convenience and peace of mind, it\'s better to shop online. It may be worthwhile also doing a search for grocery delivery near me to find it at a cheap rate. Friends may ask where can I get it or how much is it and once you\'ve tried the service, you\'ll be able to answer all their questions and refer them to the number 1 online supermarket. Supermart.ng is the perfect site to do your grocery shopping - low prices and huge discounts always. Most products come with directions for how to use them but if the product is not branded or doesn\'t have any label or packaging, you can check online or ask friends for directions for use. Consumer goods products made by manufacturers will typically come with instructions for use; if you don\'t find this enclosed, exercise caution before using or consuming any product you\'re unfamiliar with. It is made by one of the most popular manufacturers for this product category and there are hundreds of distributors that supply it across supermarkets and markets in Lagos, Nigeria. If you want to know where to purchase it, the best place to check is an online retailer that you can order online from and have delivered to you at home. This is one of the top selling products in Nigeria and also one of the most famous brands. ', 'product-11.jfif', NULL, 3, 0, 0, 'In Stock', '', 0, '0000-00-00', '2022-10-20 19:35:17', NULL),
(71, 'Idole Papaya Whitening Facial Soap 200 g x3', 8, 1780, 'Buy Idole Papaya Whitening Facial Soap 200 g x3 on Supermart.ng. Soap bars often get a bad name for being a dull and boring way to clean the body. But many are convinced that bar soaps are more effective than liquid body wash. Some argue that bar soaps last longer and include fewer preservatives than other liquid equivalents. When it\'s time for a bath or shower, you should use the very best products to get clean, protect your skin and to make you feel good. The ingredients in each brand of bar soap differ greatly but they all aim to get us clean and make us feel refreshed. Soap bars should be stored in an open and properly ventilated area. To avoid any infections, it is advisable to rinse your bar soap before you using it. For those looking to get an even skin tone, this product will work wonders. It can help even out dark marks and scars. Skin whitening and skin lightening should always be done with original products to ensure you get the best results without any negative impact on your skin. Supermart.ng is the leading online supermarket and grocery delivery service in Nigeria. Order online from over 10,000 groceries and receive same-day delivery. Get the best prices and discounts on groceries in Nigeria here. Why go to the supermarket when Supermart can come to you? Buy your groceries online on Supermart.ng today. If you want to find the best price of soap bars in Nigeria, then this is the right place. At Supermart.ng, you can order online and get same-day delivery in Lagos. For those who don\'t know where to buy soap bars in Nigeria, you may check supermarkets near me and local shops in your neighbourhood but for convenience and peace of mind, it\'s better to shop online. It may be worthwhile also doing a search for grocery delivery near me to find it at a cheap rate. Friends may ask where can I get it or how much is it and once you\'ve tried the service, you\'ll be able to answer all their questions and refer them to the number 1 online supermarket. Supermart.ng is the perfect site to do your grocery shopping - low prices and huge discounts always. Most products come with directions for how to use them but if the product is not branded or doesn\'t have any label or packaging, you can check online or ask friends for directions for use. Consumer goods products made by manufacturers will typically come with instructions for use; if you don\'t find this enclosed, exercise caution before using or consuming any product you\'re unfamiliar with. It is made by one of the most popular manufacturers for this product category and there are hundreds of distributors that supply it across supermarkets and markets in Lagos, Nigeria. If you want to know where to purchase it, the best place to check is an online retailer that you can order online from and have delivered to you at home. This is one of the top selling products in Nigeria and also one of the most famous brands. One of the first questions customers ask about a product is - how much does it cost? And the answer is - not a lot if you\'re buying online from Supermart.ng. The undisputed online retailer to get low prices and huge discounts always.', 'product-12.jpg', NULL, 4, 6, 0, 'In Stock', '', 0, '0000-00-00', '2022-10-20 19:40:39', NULL),
(72, 'Zinnia Papaya Double Whitening Shower Cream 1.2 L', 8, 3000, 'Buy Zinnia Papaya Double Whitening Shower Cream 1.2 L on Supermart.ng. A good body wash will not just get you clean, it will also leaving you feeling fresh and smelling good. Some people prefer a liquid shower gel to bar soaps and this is because they often come in a range of enticing fragrances. Shower gels typically come in bright colours and have a fruity or sporty fragrance while shower creams or moisturising body wash are thicker and creamier. This type of body wash will contain moisturisers so that your skin is soft and moisturised after bathing; these are good for people with dry skin. When it\'s time for a bath or shower, you should use the very best products to get clean, protect your skin and to make you feel good. For those looking to get an even skin tone, this product will work wonders. It can help even out dark marks and scars. Skin whitening and skin lightening should always be done with original products to ensure you get the best results without any negative impact on your skin. Supermart.ng is the leading online supermarket and grocery delivery service in Nigeria. Order online from over 10,000 groceries and receive same-day delivery. Get the best prices and discounts on groceries in Nigeria here. Why go to the supermarket when Supermart can come to you? Buy your groceries online on Supermart.ng today. If you want to find the best price of body wash in Nigeria, then this is the right place. At Supermart.ng, you can order online and get same-day delivery in Lagos. For those who don\'t know where to buy shower gel in Nigeria, you may check supermarkets near me and local shops in your neighbourhood but for convenience and peace of mind, it\'s better to shop online. It may be worthwhile also doing a search for grocery delivery near me to find it at a cheap rate. Friends may ask where can I get it or how much is it and once you\'ve tried the service, you\'ll be able to answer all their questions and refer them to the number 1 online supermarket. Supermart.ng is the perfect site to do your grocery shopping - low prices and huge discounts always. Most products come with directions for how to use them but if the product is not branded or doesn\'t have any label or packaging, you can check online or ask friends for directions for use. Consumer goods products made by manufacturers will typically come with instructions for use; if you don\'t find this enclosed, exercise caution before using or consuming any product you\'re unfamiliar with. It is made by one of the most popular manufacturers for this product category and there are hundreds of distributors that supply it across supermarkets and markets in Lagos, Nigeria. If you want to know where to purchase it, the best place to check is an online retailer that you can order online from and have delivered to you at home. This is one of the top selling products in Nigeria and also one of the most famous brands. One of the first questions customers ask about a product is - how much does it cost? And the answer is - not a lot if you\'re buying online from Supermart.ng. The undisputed online retailer to get low prices and huge discounts always.', 'product-13.jpg', NULL, 5, 0, 0, 'In Stock', '', 1, '2022-10-26', '2022-10-20 19:40:39', NULL),
(73, 'Knorr Chicken Cubes 8 g x50', 9, 995, 'Buy Knorr Chicken Cubes 8 g x50 on Supermart.ng. Knorr Chicken Cubes 8 g x50 is one spice/seasoning that is an everyday and popular staple in most Nigerian homes. It is useful to both amateur and professional chefs for their culinary practices. They are convenient, easy to use, quick to dissolve and add rich deep and unique flavours to your soups, stews, sauces vegetables, potatoes and gravies. It is chicken flavoured, free from artificial colours and preservatives and gluten free. It is made with a carefully selected blend of herbs, seasonings and chicken juices that delicately enhance the natural flavours of your dish. You will love it if you value good, nutritious, tasty, flavourful and authentic home cooking that will stand out and have that succulent beef flavour. Try seasoning today with Knorr Chicken Cube for a richer, deeper, fuller flavour. It is safely and hygienically packaged. Knorr Chicken Cubes is available and can be bought online in Nigeria at supermart.ng. Buy Knorr Chicken Cubes 8 g x50 on Supermart.ng. Bring your food to life with the very best spice and seasoning. Whether you\'re a masterchef or an amateur cook, your meals shouldn\'t taste bland. With the right combination of spices and seasoning, you can truly cook great tasting dishes. Very often, the difference between a good and bad dish is the quality and quantity of seasoning cubes used. A good seasoning cube will add great taste to a meal without it tasting too salty or over spiced. If you want to find the best price of seasoning cubes in Nigeria, then this is the right place. At Supermart.ng, you can order online and get same-day delivery in Lagos. For those who don\'t know where to buy seasoning cubes in Nigeria, you may check supermarkets near me and local shops in your neighbourhood but for convenience and peace of mind, it\'s better to shop online. It may be worthwhile also doing a search for grocery delivery near me to find it at a cheap rate. Friends may ask where can I get it or how much is it and once you\'ve tried the service, you\'ll be able to answer all their questions and refer them to the number 1 online supermarket. Supermart.ng is the perfect site to do your grocery shopping - low prices and huge discounts always. Most products come with directions for how to use them but if the product is not branded or doesn\'t have any label or packaging, you can check online or ask friends for directions for use. Consumer goods products made by manufacturers will typically come with instructions for use;', 'product-14.jpeg', NULL, 3, 0, 0, 'In Stock', '', 2, '2022-10-26', '2022-10-20 19:52:41', NULL),
(74, 'Tiger Nutmeg Powder 100 g', 9, 1250, 'Buy Tiger Nutmeg Powder 100 g on Supermart.ng. Tiger Nutmeg Powder 100 g is a spice made from the seed of the nutmeg tree, a native Indonesian evergreen tree that is the source of two popular spices: nutmeg and mace. Nutmeg is the inner seed, while mace is the red, lace-like substance that covers the seed. Tiger Nutmeg Powder is a quintessential autumn spice, frequently found in fall desserts and beverages. It can also be used in savory dishes, such as butternut squash soup, and pairs well with cream- or cheese-based recipes like a vegetable gratin or alfredo sauce. Nutmeg has a milder taste compared to mace and is sweeter and more delicate. Nutmeg is also an ingredient in different spice blends, such as pumpkin pie spice. It is also sprinkled over a variety of hot beverages like cappuccino and eggnog for added flavor and garnish. It is hygienically packaged and packed in an airtight container to enable it last longer. Tiger Nutmeg Powder is available and can be bought online in Nigeria at supermart.ng. Buy this on Supermart.ng. Bring your food to life with the very best spice and seasoning. Whether you\'re a masterchef or an amateur cook, your meals shouldn\'t taste bland. With the right combination of spices and seasoning, you can truly cook great tasting dishes. Knowing what spice to add can dramatically transform your meals and make people ask for more. If you want to find the best price of nutmeg spice in Nigeria, then this is the right place. At Supermart.ng, you can order online and get same-day delivery in Lagos. For those who don\'t know where to buy nutmeg spice in Nigeria, you may check supermarkets near me and local shops in your neighbourhood but for convenience and peace of mind, it\'s better to shop online. It may be worthwhile also doing a search for grocery delivery near me to find it at a cheap rate.', 'product-15.jpg', NULL, 6, 0, 0, 'In Stock', '', 5, '2022-10-21', '2022-10-20 19:52:41', NULL),
(75, 'Moringa Leaves 25 g', 9, 1985, 'Buy Moringa Leaves 25 g on Supermart.ng. Bring your food to life with the very best spice and seasoning. Whether you\'re a masterchef or an amateur cook, your meals shouldn\'t taste bland. With the right combination of spices and seasoning, you can truly cook great tasting dishes. Knowing what spice to add can dramatically transform your meals and make people ask for more. Most products come with directions for how to use them but if the product is not branded or doesn\'t have any label or packaging, you can check online or ask friends for directions for use. Consumer goods products made by manufacturers will typically come with instructions for use; if you don\'t find this enclosed, exercise caution before using or consuming any product you\'re unfamiliar with. It is made by one of the most popular manufacturers for this product category and there are hundreds of distributors that supply it across supermarkets and markets in Lagos, Nigeria. If you want to know where to purchase it, the best place to check is an online retailer that you can order online from and have delivered to you at home.', 'product-16.jpg', NULL, 5, 0, 0, 'In Stock', '', 14, '2022-10-21', '2022-10-20 19:57:21', NULL),
(76, 'Maggi Chicken Flavour Powder 450 g', 9, 900, 'Buy Maggi Chicken Flavour Powder 450 g on Supermart.ng. Bring your food to life with the very best spice and seasoning. Whether you\'re a masterchef or an amateur cook, your meals shouldn\'t taste bland. With the right combination of spices and seasoning, you can truly cook great tasting dishes. Knowing what spice to add can dramatically transform your meals and make people ask for more. If you want to find the best price of chicken seasoning in Nigeria, then this is the right place. At Supermart.ng, you can order online and get same-day delivery in Lagos. For those who don\'t know where to buy chicken seasoning in Nigeria, you may check supermarkets near me and local shops in your neighbourhood but for convenience and peace of mind, it\'s better to shop online. It may be worthwhile also doing a search for grocery delivery near me to find it at a cheap rate. Friends may ask where can I get it or how much is it and once you\'ve tried the service, you\'ll be able to answer all their questions and refer them to the number 1 online supermarket. Supermart.ng is the perfect site to do your grocery shopping - low prices and huge discounts always. Most products come with directions for how to use them but if the product is not branded or doesn\'t have any label or packaging, you can check online or ask friends for directions for use. Consumer goods products made by manufacturers will typically come with instructions for use; if you don\'t find this enclosed, exercise caution before using or consuming any product you\'re unfamiliar with. It is made by one of the most popular manufacturers for this product category and there are hundreds of distributors that supply it across supermarkets and markets in Lagos, Nigeria. If you want to know where to purchase it, the best place to check is an online retailer that you can order online from and have delivered to you at home. This is one of the top selling products in Nigeria and also one of the most famous brands. One of the first questions customers ask about a product is - how much does it cost? And the answer is - not a lot if you\'re buying online from Supermart.ng. ', 'product-17.jpg', NULL, 7, 0, 0, 'In Stock', '', 0, '0000-00-00', '2022-10-20 19:57:21', NULL);

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

--
-- Table structure for table `received_payment`
--

CREATE TABLE `received_payment` (
  `id` int(100) NOT NULL,
  `amount` int(100) NOT NULL,
  `trx_id` varchar(100) NOT NULL,
  `ref` varchar(250) DEFAULT NULL,
  `status` varchar(225) NOT NULL,
  `date` date NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `received_payment`
--

INSERT INTO `received_payment` (`id`, `amount`, `trx_id`, `ref`, `status`, `date`) VALUES
(1, 45000, '112345', 'aa345', 'Dispatched', '2021-11-07'),
(2, 47500, 'C3C8A6B', NULL, 'Confirmed', '2021-12-02');

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

--
-- Table structure for table `user_info`
--

CREATE TABLE `user_info` (
  `user_id` int(10) NOT NULL,
  `first_name` varchar(300) NOT NULL,
  `last_name` varchar(100) NOT NULL,
  `email` varchar(300) NOT NULL,
  `password` varchar(100) NOT NULL,
  `mobile` varchar(12) NOT NULL,
  `address` varchar(200) DEFAULT NULL,
  `creationDate` timestamp NOT NULL DEFAULT current_timestamp(),
  `updationDate` varchar(225) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

--
-- Dumping data for table `user_info`
--

INSERT INTO `user_info` (`user_id`, `first_name`, `last_name`, `email`, `password`, `mobile`, `address`, `creationDate`, `updationDate`) VALUES
(3, 'Precious', 'Omagbemi', 'precious@gmail.com', 'cd6855fc6139f6686ecd45badec90f8b', '09033944592', 'Gana, Sapele', '2022-05-18 22:31:27', NULL),
(5, 'Omagbemi', 'Precious', 'bignamepreciousonstage@gmail.com', 'b51f838479c10d04898e8e96c20eccc8', '09033944592', '45, Ogorode Lane', '2022-05-18 22:31:27', NULL),
(8, 'Omagbemi', 'John', 'bignamepreciousonstaddsdge@gmail.com', 'b51f838479c10d04898e8e96c20eccc8', '09033944592', '0 Tutu Way', '2022-05-18 22:31:27', NULL),
(9, 'Omagbemi', 'John', 'bignamepreciousodsfsdftaddsdge@gmail.com', 'b51f838479c10d04898e8e96c20eccc8', '09033944592', '0 Tutu Way', '2022-05-18 22:31:27', NULL),
(10, 'Omagbei', 'John', 'john@gmail.com', 'b51f838479c10d04898e8e96c20eccc8', '09033944592', 'kijpojpof', '2022-05-18 22:31:27', NULL),
(11, 'Yoyo', 'Billions', 'bignamepreciousonstaasage@gmail.com', 'c9ffc3e3ca543481b8065d011bf6ae71', '09033944592', '0 Tutu Way,Sapele', '2022-10-23 11:40:33', NULL);

--
-- Indexes for dumped tables
--

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

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

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

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

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

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

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

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

--
-- Indexes for table `user_info`
--
ALTER TABLE `user_info`
  ADD PRIMARY KEY (`user_id`);

--
-- AUTO_INCREMENT for dumped tables
--

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

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

--
-- AUTO_INCREMENT for table `brands`
--
ALTER TABLE `brands`
  MODIFY `brand_id` int(100) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT for table `cart`
--
ALTER TABLE `cart`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;

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

--
-- AUTO_INCREMENT for table `customer_order`
--
ALTER TABLE `customer_order`
  MODIFY `id` int(100) NOT NULL AUTO_INCREMENT;

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

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

--
-- AUTO_INCREMENT for table `user_info`
--
ALTER TABLE `user_info`
  MODIFY `user_id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
COMMIT;

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