-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: 127.0.0.1
-- Generation Time: Oct 10, 2024 at 10:10 PM
-- Server version: 10.4.32-MariaDB
-- PHP Version: 8.2.12

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


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

--
-- Database: `lwbookselibrary`
--

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

--
-- Table structure for table `authors`
--

CREATE TABLE `authors` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `author_name` varchar(255) NOT NULL,
  `author_image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `authors`
--

INSERT INTO `authors` (`id`, `author_name`, `author_image`, `created_at`, `updated_at`) VALUES
(1, 'Reverend Dr. Chris Oyakhilome Dsc. Dsc. DD', '/storage/upload/author/1809276007592258.png', NULL, '2024-09-04 13:27:40'),
(3, 'Dr John Avanzini', NULL, NULL, NULL);

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

--
-- Table structure for table `blogs`
--

CREATE TABLE `blogs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `blog_name` varchar(255) DEFAULT NULL,
  `blog_slug` varchar(255) DEFAULT NULL,
  `blog_image` varchar(255) DEFAULT NULL,
  `blog_text` text DEFAULT NULL,
  `blog_day` varchar(255) DEFAULT NULL,
  `blog_month` varchar(255) DEFAULT NULL,
  `blog_year` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `blogs`
--

INSERT INTO `blogs` (`id`, `blog_name`, `blog_slug`, `blog_image`, `blog_text`, `blog_day`, `blog_month`, `blog_year`, `created_at`, `updated_at`) VALUES
(5, 'Created for the Good Life: Embrace Your Spiritual Heritage', 'created-for-the-good-life:-embrace-your-spiritual-heritage', '/storage/upload/blog/1812354450172372.jpg', '<p>Have you ever felt like there&rsquo;s more to life than what you&rsquo;re currently experiencing? A deep-seated longing for something greater? Perhaps you&rsquo;ve faced challenges that have left you questioning your faith. The good news is that you&rsquo;re not alone. Even better, the solution is in you.&nbsp;<em>&ldquo;Created for the Good Life: Embrace Your Spiritual Heritage&rdquo;</em></p>\r\n<p>&nbsp;</p>\r\n<p>As believers, we hold an extraordinary inheritance&mdash;spiritual privileges that can transform our very existence. Imagine having access to a bank account overflowing with limitless resources, but never realizing it. In Psalm 82:6-7, the Bible attests to this: &ldquo;<strong><em>I have said, ye are gods, and all of you are children of the Most High. But ye shall die like men, and fall like one of the princes.&rdquo;</em></strong>&nbsp;God has already given you everything you need for life and godliness (2 Peter 1:3). It&rsquo;s up to you to step into this inheritance and exercise your authority in Christ Jesus.</p>\r\n<h4>&nbsp;</h4>\r\n<h4>Walk in the Spirit</h4>\r\n<p>&ldquo;For as many as are led by the Spirit of God, they are the children of God&rdquo; (Romans 8:14). To fully grasp and live out your rights as a child of God, you must be guided by the Holy Spirit. This isn&rsquo;t just about receiving the Holy Spirit; it&rsquo;s about yielding to His guidance every day.</p>\r\n<p>&nbsp;</p>\r\n<p>The Holy Spirit is your constant companion, your Helper, and your Sustainer. He is the one who lifts you up when life knocks you down, who whispers hope into your heart when despair looms, and who leads you into the victory that is your birthright as a child of God.</p>\r\n<p>&nbsp;</p>\r\n<h4>Our Divine Compass: The Word of God</h4>\r\n<p>Your journey doesn&rsquo;t stop with being led by the Spirit; it also requires a deep connection to God&rsquo;s Word.&nbsp;<strong><em>&ldquo;1 Corinthians 2:12 emphasizes this: &ldquo;We have received not the spirit of the world, but the Spirit of God, so that we might know the things that are freely given to us by God.&rdquo;&nbsp;</em></strong></p>\r\n<p>&nbsp;</p>\r\n<p>The Bible isn&rsquo;t just a book; it&rsquo;s a love letter from God, a divine manual crafted for you to live the victorious life He designed for you. Every time you open it, God is speaking to you, revealing your rights and showing you how to overcome every challenge. The Holy Spirit is there to help you understand these truths, bringing them to life in your heart. Consistently immersing yourself in God&rsquo;s Word isn&rsquo;t just a religious duty; it&rsquo;s the key to unlocking the abundant life God has promised you (Joshua 1:8).</p>\r\n<p>&nbsp;</p>\r\n<h4>Prayer: Our Effectual Communication</h4>\r\n<p>Living out your spiritual inheritance also involves actively engaging in prayer. Jesus said,&nbsp;<strong><em>&ldquo;Man shall not live by bread alone, but by every word that proceeds out of the mouth of God&rdquo; (Matthew 4:4).</em></strong>&nbsp;Think about the power of God&rsquo;s Word&mdash;the very words that spoke the universe into existence. Now imagine the transformation that can happen when you start speaking God&rsquo;s Word over your life, over your struggles, and over your dreams.</p>\r\n<p>&nbsp;</p>\r\n<p>Prayer is not just talking to God; it&rsquo;s standing in the authority He has given you, declaring His promises over every situation. James 5:16 tells us, &ldquo;The effectual fervent prayer of a righteous man availeth much.&rdquo; Christ has already done everything needed for your victory. Now, it&rsquo;s your turn to take hold of that victory in prayer, consistently claiming what is rightfully yours through the authority of God&rsquo;s Word.</p>\r\n<p>&nbsp;</p>\r\n<h4>Walking in Freedom</h4>\r\n<p>Jesus brought us out so He could bring us in. We have therefore been called into liberty in Christ. We have been brought out of slavery and brought into freedom. (from the Book; &ldquo;Your Right in Christ&rdquo; by Pastor Chris Oyakhilome).</p>\r\n<p>&nbsp;</p>\r\n<p>This isn&rsquo;t just about breaking free from the chains of sin and fear; it&rsquo;s about stepping into the fullness of life as God&rsquo;s beloved child. It&rsquo;s about embracing your identity in Christ and living out the promises He has spoken over you.</p>\r\n<p>&nbsp;</p>\r\n<p>For deeper insight, you can explore this in&nbsp;<a href=\"https://loveworldbooks.org/product/your-rights-in-christ/\">&ldquo;Your Rights in Christ&rdquo;</a>&nbsp;by Pastor Chris Oyakhilome, available at our bookstore. Always remember&mdash;you were created for the good life. Embrace it. Live it. It&rsquo;s your divine inheritance.</p>', '08', 'October', '2024', '2024-10-08 12:58:13', '2024-10-08 15:15:30'),
(6, 'Build Your Life on the Solid Foundation: Harnessing the Power of God’s Word', 'build-your-life-on-the-solid-foundation:-harnessing-the-power-of-god’s-word', '/storage/upload/blog/1812354747842624.jpg', '<p>Life is full of storms&mdash;unexpected challenges that can shake your very core. You may face financial difficulties, relationship struggles, or emotional battles, and in those moments, everything can feel like it&rsquo;s falling apart. But it doesn&rsquo;t have to be this way. Jesus gave us a clear path to stability when He said,&nbsp;<strong><em>&ldquo;Therefore whosoever heareth these sayings of mine, and doeth them, I will liken him unto a wise man, which built his house upon a rock: and the rain descended, and the floods came and the winds blew, and beat upon that house; and it fell not: for it was founded upon a rock.&rdquo; (Matthew 7:24-24)&nbsp;</em></strong><em>&ldquo;</em><em>Build Your Life on the Solid Foundation: Harnessing the Power of God&rsquo;s Word&rdquo;</em></p>\r\n<p>&nbsp;</p>\r\n<p>Take a moment and think about this: How often do we hear God&rsquo;s Word but fail to live it out? We nod in agreement during sermons, and we read Bible verses that inspire us, but when the storms of life hit, we find ourselves lost, confused, and shaken. Why? Because hearing isn&rsquo;t enough. Real power comes from doing&mdash;applying God&rsquo;s Word in your everyday life.</p>\r\n<p>&nbsp;</p>\r\n<p>You see, life will always throw challenges your way, but if your life is built on the rock of God&rsquo;s Word, you won&rsquo;t be overwhelmed by them. You&rsquo;ll stand firm because you&rsquo;re anchored on something unshakable&mdash;God&rsquo;s promises. And that&rsquo;s the key to victorious living: trusting in God&rsquo;s Word enough to act on it, even when it feels hard or uncertain.</p>\r\n<p>&nbsp;</p>\r\n<p>The truth is, your thoughts are at the heart of this. They shape your mind, influence your decisions, and ultimately, determine how strong your foundation is. If your thoughts are full of doubt, fear, or negativity, your foundation weakens. But when your mind is filled with faith, hope, and the truth of God&rsquo;s Word, you become unmovable, just like that house built on the rock.</p>\r\n<p>&nbsp;</p>\r\n<p>This is why it&rsquo;s so important to understand the power of your mind. Every thought you allow into your heart either strengthens or weakens your spiritual foundation. Have you read the Book&nbsp;<a href=\"https://loveworldbooks.org/product/the-power-of-your-mind/\"><strong><em>&ldquo;The Power of Your Mind&rdquo;?</em></strong></a>&nbsp;You should get it. This book will help you take control of your thoughts and align them with God&rsquo;s truth, so you can experience lasting peace, joy, and stability, no matter what life throws at you.</p>\r\n<p>&nbsp;</p>\r\n<p>You can also get powerful reads that can help build your Faith like the Book;&nbsp;<a href=\"https://loveworldbooks.org/product/how-to-make-your-faith-work/\"><strong><em>&ldquo;How to Make Your Faith Work&rdquo;</em></strong>&nbsp;</a>Both Books Authored by Pastor Oyakhilome, are available here at our Book Store</p>\r\n<p>&nbsp;</p>\r\n<p>Start today. Build your life on the solid foundation of God&rsquo;s Word, you have the power to live unshaken&mdash;Start by Equipping yourself with the right materials to guide you to a Prosperous and Victorious Life.</p>', '08', 'October', '2024', '2024-10-08 13:02:57', '2024-10-08 15:14:21'),
(7, 'Love: The Heartbeat of Soul-Winning', 'love:-the-heartbeat-of-soul-winning', '/storage/upload/blog/1812354864425931.jpg', '<p>There&rsquo;s a deep cry in the world today&mdash;so many hearts yearning for healing, hope, and love. As children of God, we&rsquo;ve been entrusted with the most powerful gift: love, the essence of God&rsquo;s nature. The ultimate act of love was shown when God sent His Son, Jesus, to rescue humanity. It was a sacrifice born from a heart that desired not just to save, but to win back the souls of His beloved creation. (John 3:16).<em>&nbsp;&ldquo;Love: The Heartbeat of Soul-Winning&rdquo;</em></p>\r\n<p>&nbsp;</p>\r\n<p>Soul winning, at its core, isn&rsquo;t about arguments or flashy words, it&rsquo;s about sharing the unconditional love of God to a hurting world and reaching people in the deepest, most vulnerable parts of their being. When you share the love of God, you&rsquo;re reaching into someone&rsquo;s pain, loneliness, or fear, and offering them the comfort that only God gives.</p>\r\n<p>&nbsp;</p>\r\n<p>Being a true child of God means living out His love every day. It&rsquo;s more than just believing; it&rsquo;s acting out his nature in you. It&rsquo;s seeing someone in need and offering them not only help but your heart of love. It&rsquo;s forgiving those who&rsquo;ve hurt you, even when it feels impossible, because that&rsquo;s what God did for us. It&rsquo;s praying for others who have gone astray, knowing that every prayer is a seed planted in someone&rsquo;s soul, watering it, and knowing that God will bring them to His loving arms.</p>\r\n<p>&nbsp;</p>\r\n<p>We&rsquo;re called to be more than just churchgoers&mdash;we&rsquo;re called to be passionate lovers of others. Every time you show love, no matter how small the gesture, you are part of God&rsquo;s great plan to win people&rsquo;s hearts and bring them into the love of God. There is no greater victory than leading someone into the love of God. Let that be our mission. Let love be the fire that drives us to touch lives, heal hearts, and win souls for His kingdom. In love, we reflect the heart of our Father, and in love, we fulfill our true purpose as His children.</p>\r\n<p>&nbsp;</p>\r\n<p>Say this prayer:</p>\r\n<p><em>Dear Father, fill my heart with Your love and compassion for others. Help me to be a beacon of Your light, touching lives through kindness, forgiveness, and prayer. Let Your love flow through me, bringing healing and hope to those in need, so that many may come to know You. In Jesus&rsquo; name, Amen.</em></p>\r\n<p>&nbsp;</p>\r\n<p>Take a step today to partner with God in winning souls, with love as your guide. You can also get the book&nbsp;<a href=\"https://loveworldbooks.org/product/join-this-chariot/\">&ldquo;Join This Chariot&rdquo;</a>&nbsp;by Pastor Chris Oyakhilome, available at our bookstore. It offers profound insight and practical approaches to soul-winning, helping you understand this divine calling in a clearer, more impactful way. Stay Blessed!</p>', '08', 'October', '2024', '2024-10-08 13:04:49', '2024-10-08 15:08:15'),
(8, 'Embrace Challenges, Claim Your Victory', 'embrace-challenges,-claim-your-victory', '/storage/upload/blog/1812354957060460.jpg', '<p>It&rsquo;s easy to trust God when everything seems to be going smoothly. But what about those moments when challenges hit unexpectedly and painfully? It&rsquo;s natural to feel fear, doubt, or worry in times like these. Some people, even some Christians, struggle to remember God&rsquo;s Word in the heat of the moment and start questioning if He is still with them.<em>&nbsp;&ldquo;Embrace Challenges, Claim Your Victory&rdquo;</em></p>\r\n<p>&nbsp;</p>\r\n<p>Beloved, let me remind you: even amid your hardest challenges, God is with you, and His promises still stand. The battle may seem tough, but victory is already yours in Christ. The key is to stay rooted in your identity in Him, no matter what comes your way.</p>\r\n<p>&nbsp;</p>\r\n<p>Here are three powerful ways to respond to challenges as a child of God:</p>\r\n<p>&nbsp;</p>\r\n<p><strong>Be Calm</strong></p>\r\n<p>When challenges come, panic and despair don&rsquo;t have to be our first response. Remember the story of Jesus and His disciples on the stormy sea? The disciples were terrified, but Jesus&mdash;fully aware of His authority&mdash;was peacefully asleep. &ldquo;Then He arose and rebuked the wind, and said to the sea, &lsquo;Peace, be still!&rsquo; And the wind ceased and there was a great calm.&rdquo; (Mark 4:39). Jesus knew who He was and didn&rsquo;t let the storm shake Him. And, my dear, neither should you.<br />You are more than a conqueror through Christ. No challenge defines you&mdash;your faith in Jesus does. Like Him, you have the power to speak peace into your storm. Don&rsquo;t let fear steal your peace. Stand firm, knowing that with Christ&rsquo;s authority, you can command calm in any situation.</p>\r\n<p>&nbsp;</p>\r\n<h4>Pray</h4>\r\n<p>When faced with overwhelming challenges, we must turn to the One who holds the power to all things in prayer. Prayer is our lifeline, our direct connection to God. He is not distant&mdash;He is a loving Father who wants to hear from you, especially when you&rsquo;re hurting. The Bible reminds us, &ldquo;This is the confidence we have in approaching God: that if we ask anything according to His will, He hears us.&rdquo; (1 John 5:14).<br />Your prayers are powerful. They are not ignored. When you call out to God in faith, He hears you, and He moves on your behalf. Speak to Him when experiencing challenges, and trust that He is working for your good, even when you cannot see the manifestation yet.</p>\r\n<p>&nbsp;</p>\r\n<h4>Speak the Word of God</h4>\r\n<p>When you know who you are in Christ, challenges lose their power over you. Jesus said, &ldquo;If anyone says to this mountain, &lsquo;Go, throw yourself into the sea,&rsquo; and does not doubt in their heart but believes that what they say will happen, it will be done.&rdquo; (Mark 11:23). You have the authority to speak to your situation and command it to shift. Don&rsquo;t be silent in the face of adversity, don&rsquo;t murmur or pack up. This is exactly what the devil wants. Disappoint him by standing tall and declare God&rsquo;s Word over that very situation.<br />Every challenge is an opportunity to demonstrate your faith. Don&rsquo;t give in to fear. Speak boldly what you want to see happen, knowing that through Christ, you are more than a conqueror. Victory is yours.</p>\r\n<p><br />For deeper insight, get the book;&nbsp;<a href=\"https://loveworldbooks.org/product/your-rights-in-christ/\">&ldquo;Your Rights in Christ&rdquo;</a>&nbsp;by Pastor Chris Oyakhilome from our bookstore here. This book equips you with the knowledge of your authority in Christ, empowering you to live in constant victory, no matter the challenges you face. Remember, no matter what, you have already won!</p>', '08', 'October', '2024', '2024-10-08 13:06:15', '2024-10-08 15:13:38');

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

--
-- Table structure for table `cache`
--

CREATE TABLE `cache` (
  `key` varchar(255) NOT NULL,
  `value` mediumtext NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `cache`
--

INSERT INTO `cache` (`key`, `value`, `expiration`) VALUES
('0716d9708d321ffb6a00818614779e779925365c', 'i:2;', 1727952213),
('0716d9708d321ffb6a00818614779e779925365c:timer', 'i:1727952213;', 1727952213),
('0ade7c2cf97f75d009975f4d720d1fa6c19f4897', 'i:2;', 1727812015),
('0ade7c2cf97f75d009975f4d720d1fa6c19f4897:timer', 'i:1727812014;', 1727812014),
('1574bddb75c78a6fd2251d61e2993b5146201319', 'i:1;', 1727950366),
('1574bddb75c78a6fd2251d61e2993b5146201319:timer', 'i:1727950366;', 1727950366),
('17ba0791499db908433b80f37c5fbc89b870084b', 'i:2;', 1724774968),
('17ba0791499db908433b80f37c5fbc89b870084b:timer', 'i:1724774968;', 1724774968),
('1b6453892473a467d07372d45eb05abc2031647a', 'i:2;', 1724661202),
('1b6453892473a467d07372d45eb05abc2031647a:timer', 'i:1724661202;', 1724661202),
('356a192b7913b04c54574d18c28d46e6395428ab', 'i:1;', 1724334035),
('356a192b7913b04c54574d18c28d46e6395428ab:timer', 'i:1724334035;', 1724334035),
('77de68daecd823babbb58edb1c8e14d7106e83bb', 'i:2;', 1724261287),
('77de68daecd823babbb58edb1c8e14d7106e83bb:timer', 'i:1724261287;', 1724261287),
('7b52009b64fd0a2a49e6d8a939753077792b0554', 'i:1;', 1727513560),
('7b52009b64fd0a2a49e6d8a939753077792b0554:timer', 'i:1727513560;', 1727513560),
('9e6a55b6b4563e652a23be9d623ca5055c356940', 'i:1;', 1727962690),
('9e6a55b6b4563e652a23be9d623ca5055c356940:timer', 'i:1727962690;', 1727962690),
('admin@gmail.com|127.0.0.1', 'i:1;', 1726230291),
('admin@gmail.com|127.0.0.1:timer', 'i:1726230291;', 1726230291),
('admin1@email.com|127.0.0.1', 'i:1;', 1724661153),
('admin1@email.com|127.0.0.1:timer', 'i:1724661153;', 1724661153),
('b1d5781111d84f7b3fe45a0852e59758cd7a87e5', 'i:1;', 1724317120),
('b1d5781111d84f7b3fe45a0852e59758cd7a87e5:timer', 'i:1724317120;', 1724317120),
('bd307a3ec329e10a2cff8fb87480823da114f8f4', 'i:1;', 1727813350),
('bd307a3ec329e10a2cff8fb87480823da114f8f4:timer', 'i:1727813350;', 1727813350),
('c1dfd96eea8cc2b62785275bca38ac261256e278', 'i:2;', 1727806111),
('c1dfd96eea8cc2b62785275bca38ac261256e278:timer', 'i:1727806111;', 1727806111),
('da4b9237bacccdf19c0760cab7aec4a8359010b0', 'i:2;', 1724325272),
('da4b9237bacccdf19c0760cab7aec4a8359010b0:timer', 'i:1724325270;', 1724325270),
('f1abd670358e036c31296e66b3b66c382ac00812', 'i:1;', 1727888410),
('f1abd670358e036c31296e66b3b66c382ac00812:timer', 'i:1727888410;', 1727888410),
('fa35e192121eabf3dabf9f5ea6abdbcbc107ac3b', 'i:1;', 1727879612),
('fa35e192121eabf3dabf9f5ea6abdbcbc107ac3b:timer', 'i:1727879612;', 1727879612),
('phenomonline@email.com|127.0.0.1', 'i:3;', 1727880331),
('phenomonline@email.com|127.0.0.1:timer', 'i:1727880331;', 1727880331),
('user@gmail.com|127.0.0.1', 'i:1;', 1728123783),
('user@gmail.com|127.0.0.1:timer', 'i:1728123782;', 1728123782);

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

--
-- Table structure for table `cache_locks`
--

CREATE TABLE `cache_locks` (
  `key` varchar(255) NOT NULL,
  `owner` varchar(255) NOT NULL,
  `expiration` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `categories` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_name` varchar(255) NOT NULL,
  `category_slug` varchar(255) NOT NULL,
  `image` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `categories` (`id`, `category_name`, `category_slug`, `image`, `created_at`, `updated_at`) VALUES
(4, 'Prayer and Prophecy', 'prayer-and-prophecy', '/storage/upload/category/1808808715260156.png', NULL, '2024-08-30 10:07:11'),
(5, 'Divine Healing and Health', 'divine-healing-and-health', NULL, NULL, '2024-09-04 12:23:12'),
(6, 'Faith and Prosperity', 'faith-and-prosperity', NULL, NULL, NULL),
(7, 'Salvation and Soulwinning', 'salvation-and-soulwinning', NULL, NULL, NULL),
(8, 'Christian Life And Living', 'christian-life-and-living', NULL, NULL, NULL),
(9, 'Children Books', 'children-books', NULL, NULL, NULL),
(10, 'Teenagers Books', 'teenagers-books', NULL, NULL, '2024-09-10 15:51:49'),
(11, 'Bible And Reference Materials', 'bible-and-reference-materials', NULL, NULL, NULL),
(12, 'Holy Spirit', 'holy-spirit', NULL, NULL, NULL),
(13, 'Featured Categories', 'featured-categories', NULL, NULL, '2024-10-04 14:43:49'),
(15, 'Journals', 'journals', NULL, NULL, NULL);

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

--
-- Table structure for table `category_product`
--

CREATE TABLE `category_product` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `category_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `category_product`
--

INSERT INTO `category_product` (`id`, `category_id`, `product_id`, `created_at`, `updated_at`) VALUES
(2, 6, 2, NULL, NULL),
(3, 8, 2, NULL, NULL),
(4, 4, 3, NULL, NULL),
(6, 4, 4, NULL, NULL),
(7, 4, 5, NULL, NULL),
(8, 12, 5, NULL, NULL),
(9, 5, 6, NULL, NULL),
(10, 5, 7, NULL, NULL),
(11, 5, 8, NULL, NULL),
(12, 6, 9, NULL, NULL),
(13, 7, 9, NULL, NULL),
(14, 8, 9, NULL, NULL),
(15, 7, 10, NULL, NULL),
(16, 7, 5, NULL, NULL),
(18, 6, 12, NULL, NULL),
(19, 8, 12, NULL, NULL),
(20, 8, 13, NULL, NULL),
(21, 8, 14, NULL, NULL),
(22, 8, 15, NULL, NULL),
(23, 8, 16, NULL, NULL),
(24, 8, 17, NULL, NULL),
(25, 11, 18, NULL, NULL),
(26, 11, 19, NULL, NULL),
(27, 9, 20, NULL, NULL),
(28, 11, 20, NULL, NULL),
(29, 10, 21, NULL, NULL),
(30, 11, 21, NULL, NULL),
(31, 12, 22, NULL, NULL),
(32, 12, 23, NULL, NULL),
(33, 12, 24, NULL, NULL),
(34, 13, 25, NULL, NULL),
(35, 13, 26, NULL, NULL),
(36, 9, 27, NULL, NULL),
(37, 9, 28, NULL, NULL),
(38, 9, 29, NULL, NULL),
(39, 4, 30, NULL, NULL),
(40, 7, 31, NULL, NULL),
(41, 12, 31, NULL, NULL),
(45, 8, 34, NULL, NULL),
(47, 7, 36, NULL, NULL);

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

--
-- Table structure for table `failed_jobs`
--

CREATE TABLE `failed_jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `uuid` varchar(255) NOT NULL,
  `connection` text NOT NULL,
  `queue` text NOT NULL,
  `payload` longtext NOT NULL,
  `exception` longtext NOT NULL,
  `failed_at` timestamp NOT NULL DEFAULT current_timestamp()
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `jobs`
--

CREATE TABLE `jobs` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `queue` varchar(255) NOT NULL,
  `payload` longtext NOT NULL,
  `attempts` tinyint(3) UNSIGNED NOT NULL,
  `reserved_at` int(10) UNSIGNED DEFAULT NULL,
  `available_at` int(10) UNSIGNED NOT NULL,
  `created_at` int(10) UNSIGNED NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `job_batches`
--

CREATE TABLE `job_batches` (
  `id` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `total_jobs` int(11) NOT NULL,
  `pending_jobs` int(11) NOT NULL,
  `failed_jobs` int(11) NOT NULL,
  `failed_job_ids` longtext NOT NULL,
  `options` mediumtext DEFAULT NULL,
  `cancelled_at` int(11) DEFAULT NULL,
  `created_at` int(11) NOT NULL,
  `finished_at` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `languages`
--

CREATE TABLE `languages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `language_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `languages`
--

INSERT INTO `languages` (`id`, `language_name`, `created_at`, `updated_at`) VALUES
(1, 'English', NULL, NULL),
(2, 'French', NULL, NULL),
(4, 'Hausa', NULL, NULL),
(6, 'Igbo', NULL, '2024-10-04 14:42:10'),
(7, 'Edo', NULL, NULL);

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

--
-- Table structure for table `levels`
--

CREATE TABLE `levels` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `level_name` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `levels`
--

INSERT INTO `levels` (`id`, `level_name`, `created_at`, `updated_at`) VALUES
(7, 'Free User', NULL, NULL),
(8, 'Silver', NULL, '2024-10-03 16:19:52'),
(9, 'Gold', NULL, NULL),
(10, 'Platinum', NULL, '2024-10-03 16:54:00');

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

--
-- Table structure for table `level_product`
--

CREATE TABLE `level_product` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `level_id` bigint(20) UNSIGNED NOT NULL,
  `product_id` bigint(20) UNSIGNED NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `level_product`
--

INSERT INTO `level_product` (`id`, `level_id`, `product_id`, `created_at`, `updated_at`) VALUES
(3, 9, 2, NULL, NULL),
(8, 8, 3, NULL, NULL),
(9, 9, 3, NULL, NULL),
(10, 10, 3, NULL, NULL),
(11, 8, 4, NULL, NULL),
(12, 9, 4, NULL, NULL),
(13, 10, 4, NULL, NULL),
(14, 8, 5, NULL, NULL),
(15, 9, 5, NULL, NULL),
(16, 10, 5, NULL, NULL),
(17, 8, 6, NULL, NULL),
(18, 9, 6, NULL, NULL),
(19, 10, 6, NULL, NULL),
(20, 8, 7, NULL, NULL),
(21, 9, 7, NULL, NULL),
(22, 10, 7, NULL, NULL),
(23, 8, 8, NULL, NULL),
(24, 9, 8, NULL, NULL),
(25, 10, 8, NULL, NULL),
(28, 10, 9, NULL, NULL),
(29, 8, 10, NULL, NULL),
(30, 9, 10, NULL, NULL),
(31, 10, 10, NULL, NULL),
(35, 8, 12, NULL, NULL),
(36, 9, 12, NULL, NULL),
(37, 10, 12, NULL, NULL),
(38, 8, 13, NULL, NULL),
(39, 9, 13, NULL, NULL),
(40, 10, 13, NULL, NULL),
(41, 8, 14, NULL, NULL),
(42, 9, 14, NULL, NULL),
(43, 10, 14, NULL, NULL),
(44, 8, 15, NULL, NULL),
(45, 9, 15, NULL, NULL),
(46, 10, 15, NULL, NULL),
(47, 8, 16, NULL, NULL),
(48, 9, 16, NULL, NULL),
(49, 10, 16, NULL, NULL),
(50, 8, 17, NULL, NULL),
(51, 9, 17, NULL, NULL),
(52, 10, 17, NULL, NULL),
(53, 8, 18, NULL, NULL),
(54, 9, 18, NULL, NULL),
(55, 10, 18, NULL, NULL),
(56, 8, 19, NULL, NULL),
(57, 9, 19, NULL, NULL),
(58, 10, 19, NULL, NULL),
(59, 8, 20, NULL, NULL),
(60, 9, 20, NULL, NULL),
(61, 10, 20, NULL, NULL),
(62, 8, 21, NULL, NULL),
(63, 9, 21, NULL, NULL),
(64, 10, 21, NULL, NULL),
(65, 8, 22, NULL, NULL),
(66, 9, 22, NULL, NULL),
(67, 10, 22, NULL, NULL),
(68, 8, 23, NULL, NULL),
(69, 9, 23, NULL, NULL),
(70, 10, 23, NULL, NULL),
(71, 8, 24, NULL, NULL),
(72, 9, 24, NULL, NULL),
(73, 10, 24, NULL, NULL),
(74, 8, 25, NULL, NULL),
(75, 9, 25, NULL, NULL),
(76, 10, 25, NULL, NULL),
(77, 8, 26, NULL, NULL),
(78, 9, 26, NULL, NULL),
(79, 10, 26, NULL, NULL),
(80, 8, 27, NULL, NULL),
(81, 9, 27, NULL, NULL),
(82, 10, 27, NULL, NULL),
(83, 8, 28, NULL, NULL),
(84, 9, 28, NULL, NULL),
(85, 10, 28, NULL, NULL),
(86, 8, 29, NULL, NULL),
(87, 9, 29, NULL, NULL),
(88, 10, 29, NULL, NULL),
(89, 8, 30, NULL, NULL),
(90, 9, 30, NULL, NULL),
(91, 10, 30, NULL, NULL),
(92, 8, 31, NULL, NULL),
(93, 9, 31, NULL, NULL),
(94, 10, 31, NULL, NULL),
(101, 8, 34, NULL, NULL),
(102, 9, 34, NULL, NULL),
(103, 10, 34, NULL, NULL),
(108, 8, 2, NULL, NULL),
(109, 10, 2, NULL, NULL),
(110, 8, 9, NULL, NULL),
(111, 9, 9, NULL, NULL),
(112, 7, 36, NULL, NULL),
(113, 8, 36, NULL, NULL),
(114, 9, 36, NULL, NULL),
(115, 10, 36, NULL, NULL);

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

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

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

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` (`id`, `migration`, `batch`) VALUES
(1, '0001_01_01_000000_create_users_table', 1),
(2, '0001_01_01_000001_create_cache_table', 1),
(3, '0001_01_01_000002_create_jobs_table', 1),
(4, '2024_08_21_154530_create_personal_access_tokens_table', 2),
(6, '2024_08_28_180147_create_categories_table', 3),
(7, '2024_09_04_101004_create_authors_table', 4),
(8, '2024_09_04_121501_create_languages_table', 5),
(9, '2024_09_04_133931_create_levels_table', 6),
(20, '2024_09_05_104416_create_products_table', 7),
(21, '2024_09_16_174217_create_category_product_table', 8),
(22, '2024_09_16_174243_create_level_product_table', 8),
(26, '2024_09_24_145232_create_payments_table', 9),
(27, '2024_09_28_141744_create_packages_table', 9),
(29, '2024_09_30_183405_create_subscriptions_table', 10),
(32, '2024_10_07_162128_create_blogs_table', 11),
(33, '2024_10_08_164027_create_testimonials_table', 12),
(34, '2024_10_09_172050_create_sliders_table', 13);

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

--
-- Table structure for table `packages`
--

CREATE TABLE `packages` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `package_name` varchar(255) NOT NULL,
  `package_shortname` varchar(255) NOT NULL,
  `level_id` bigint(20) UNSIGNED NOT NULL,
  `amount_esp` varchar(255) DEFAULT NULL,
  `amount_ngn` varchar(255) NOT NULL,
  `amount_usd` varchar(255) DEFAULT NULL,
  `package_duration` enum('monthly','quarterly','yearly') NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `packages`
--

INSERT INTO `packages` (`id`, `package_name`, `package_shortname`, `level_id`, `amount_esp`, `amount_ngn`, `amount_usd`, `package_duration`, `created_at`, `updated_at`) VALUES
(1, 'Monthly Silver Subscription Plan', 'Silver Subscription', 8, '0.0001', '3500', '2', 'monthly', '2024-09-28 15:25:07', '2024-10-02 10:24:22'),
(2, 'Monthly Gold Subscription Plan', 'Gold  Subscription', 9, '0.0002', '5000', '3.5', 'monthly', '2024-09-28 15:31:16', '2024-10-02 10:24:33'),
(3, 'Monthly Platinum Subscription Plan', 'Platinum Subscription', 10, '0.0003', '7500', '5', 'monthly', '2024-09-28 15:32:51', '2024-10-03 16:53:23'),
(4, 'Quarterly Silver Subscription Plan', 'Silver Subscription', 8, '6', '7500', '6', 'quarterly', '2024-09-28 15:34:36', '2024-10-02 10:25:08'),
(5, 'Quarterly Gold Subscription Plan', 'Gold Subscription', 9, '12', '15000', '12', 'quarterly', '2024-09-28 15:36:17', '2024-10-02 10:25:29'),
(6, 'Quarterly Platinum Subscription Plan', 'Platinum Subscription', 10, '15', '22500', '15', 'quarterly', '2024-09-28 15:37:27', '2024-10-02 10:25:44'),
(7, 'Yearly Silver Subscription Plan', 'Silver Subscription', 8, '24', '30000', '24', 'yearly', '2024-09-28 15:41:48', '2024-10-02 10:26:03'),
(8, 'Yearly Gold Subscription Plan', 'Gold Subscription', 9, '42', '60000', '42', 'yearly', '2024-09-28 15:43:26', '2024-10-02 10:26:22'),
(9, 'Yearly Platinum Subscription Plan', 'Platinum Subscription', 10, '0.01', '90000', '60', 'yearly', '2024-09-28 15:44:30', '2024-10-02 10:26:42');

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

--
-- Table structure for table `password_reset_tokens`
--

CREATE TABLE `password_reset_tokens` (
  `email` varchar(255) NOT NULL,
  `token` varchar(255) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_reset_tokens`
--

INSERT INTO `password_reset_tokens` (`email`, `token`, `created_at`) VALUES
('phenompm@gmail.com', '$2y$12$LOfI15arcWVLlZd1VoPKAuQeMO1eEXQk4Aum8Wsgf5Ds5XQTTosdG', '2024-10-02 15:40:24'),
('user@email.com', '$2y$12$1Ss1KuqD5X16MDBfmp3qguze12oEbIUdMQX6wscldhdSuYQAeBjLa', '2024-10-02 15:42:25'),
('user2@email.com', '$2y$12$vVeynLezOP/vPQD94Gw8ie0Exgq1ipjPMEqMMm9kZYEBC1RISQcGK', '2024-10-02 15:46:26');

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

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

CREATE TABLE `payments` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `phone_number` varchar(255) DEFAULT NULL,
  `payment_gateway` varchar(255) DEFAULT NULL,
  `payment_type` varchar(255) DEFAULT NULL,
  `tx_ref` varchar(255) DEFAULT NULL,
  `payment_ref` varchar(255) DEFAULT NULL,
  `total_amount` varchar(255) DEFAULT NULL,
  `currency` varchar(255) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `narration` varchar(255) DEFAULT NULL,
  `payment_date` varchar(255) DEFAULT NULL,
  `payment_month` varchar(255) DEFAULT NULL,
  `payment_year` varchar(255) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `payments` (`id`, `user_id`, `name`, `email`, `phone_number`, `payment_gateway`, `payment_type`, `tx_ref`, `payment_ref`, `total_amount`, `currency`, `status`, `narration`, `payment_date`, `payment_month`, `payment_year`, `created_at`, `updated_at`) VALUES
(19, 3, 'User Greatness', 'user@email.com', '08076739334', 'Flutterwave', 'card', 'TXN-20241002120055-66fd35f75fc49', 'FLW-MOCK-7cbb062c29fb37c65237c7002cfcb930', '5000', 'NGN', 'successful', 'Elibary - Monthly Gold Subscription Plan', '02 October 2024', 'October', '2024', '2024-10-02 11:05:06', NULL),
(20, 6, 'usertest01', 'user2@email.com', NULL, 'Espees', 'Espees Wallet Payment', 'TXN-20241002132421-66fd4985c6033', '8466805cae7215121a718ca10f98cc63', '0.01', 'ESPEES', 'Successfully Done', 'Elibary - Yearly Platinum Subscription Plan', '02 October 2024', 'October', '2024', '2024-10-02 12:29:24', NULL),
(21, 15, 'Phenom Plus', 'phenomplus1@gmail.com', '08076739334', 'Flutterwave', 'card', 'TXN-20241002170301-66fd7cc5100cf', 'FLW-MOCK-a373cd00709f9677627c32239a373203', '5000', 'NGN', 'successful', 'Elibary - Monthly Gold Subscription Plan', '02 October 2024', 'October', '2024', '2024-10-02 16:04:26', NULL),
(22, 16, 'User4 Person', 'user4@email.com', '07088693671', 'Flutterwave', 'ussd', 'TXN-20241003101927-66fe6faf202ae', 'flwm3s4m0c1727951858461', '5000', 'NGN', 'successful', 'Elibary - Monthly Gold Subscription Plan', '03 October 2024', 'October', '2024', '2024-10-03 09:40:59', NULL),
(23, 18, 'Mayowa Olujobi', 'mayowaolujobi@gmail.com', '08076739334', 'Flutterwave', 'card', 'TXN-20241003180902-66feddbee9f64', 'FLW-MOCK-b4d8a7dc6051d60b3bab41046ef79b72', '5000', 'NGN', 'successful', 'Elibary - Monthly Gold Subscription Plan', '03 October 2024', 'October', '2024', '2024-10-03 17:10:03', NULL);

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

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `expires_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

CREATE TABLE `products` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `author_id` bigint(20) UNSIGNED NOT NULL,
  `vendor_id` bigint(20) UNSIGNED NOT NULL,
  `language_id` bigint(20) UNSIGNED NOT NULL,
  `product_name` varchar(255) NOT NULL,
  `product_subtitle` varchar(255) DEFAULT NULL,
  `product_slug` varchar(255) NOT NULL,
  `product_thumbnail` varchar(255) NOT NULL,
  `product_video_preview` varchar(255) DEFAULT NULL,
  `product_ebook` varchar(255) DEFAULT NULL,
  `cloud_code` varchar(255) DEFAULT NULL,
  `selling_price_esp` varchar(255) NOT NULL,
  `discount_price_esp` varchar(255) DEFAULT NULL,
  `selling_price_ngn` varchar(255) NOT NULL,
  `discount_price_ngn` varchar(255) DEFAULT NULL,
  `selling_price_usd` varchar(255) NOT NULL,
  `discount_price_usd` varchar(255) DEFAULT NULL,
  `product_tags` varchar(255) DEFAULT NULL,
  `short_description` text NOT NULL,
  `long_description` text NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=Inactive, 1=Active',
  `special_offer` int(11) DEFAULT NULL,
  `featured` int(11) DEFAULT NULL,
  `available_in_print` int(11) DEFAULT NULL,
  `available_in_digital` int(11) DEFAULT NULL,
  `new_release` int(11) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `products` (`id`, `author_id`, `vendor_id`, `language_id`, `product_name`, `product_subtitle`, `product_slug`, `product_thumbnail`, `product_video_preview`, `product_ebook`, `cloud_code`, `selling_price_esp`, `discount_price_esp`, `selling_price_ngn`, `discount_price_ngn`, `selling_price_usd`, `discount_price_usd`, `product_tags`, `short_description`, `long_description`, `status`, `special_offer`, `featured`, `available_in_print`, `available_in_digital`, `new_release`, `created_at`, `updated_at`) VALUES
(2, 1, 2, 1, 'How To Make Your Faith Work', NULL, 'how-to-make-your-faith-work', '/storage/upload/products/thumbnail/1728384466.jpg', NULL, NULL, 'd91e6830-dfab-4440-afe7-35e6c4a6d846', '12.9', '11.7', '2750', NULL, '12.9', '11.7', 'faith, Prayer,prosperity,victory', 'That’s the missing ingredient from the message of faith, which is needed now in the body of Christ. This book is an outstanding revelational masterpiece that teaches you not just how to acquire faith, but how to put your faith to work so you can live the life of victory, success, joy, health and prosperity which God has ordained for you.', '<p>That&rsquo;s the missing ingredient from the message of faith, which is needed now in the body of Christ. This book is an outstanding revelational masterpiece that teaches you not just how to acquire faith, but how to put your faith to work so you can live the life of victory, success, joy, health and prosperity which God has ordained for you. You&rsquo;ll learn about: The faith attitude in prayer, The four different levels of the God-kind of faith What to do for your faith to become great The reason and the cure for weak faith How to build prevailing faith. Don&rsquo;t get stuck in the rut! Learn how to make your faith work!</p>', 1, NULL, NULL, 1, 1, NULL, '2024-10-03 15:32:55', '2024-10-08 09:47:46'),
(3, 1, 2, 1, 'How To Pray Effectively – Vol 1', 'Understanding The Rules Of Prayer For Different Situations and How To Apply Them For Your Desired Outcome', 'how-to-pray-effectively-–-vol-1', '/storage/upload/products/thumbnail/1728385258.jpg', NULL, NULL, '57e4013c-e39e-4ca6-8059-c5070749030e', '9.9', '9.0', '3300', NULL, '9.9', '9.0', 'Prayer,Pray Effectively,prayer of faith,intercession,praying in the spirit', 'God’s earnest desire is to have a rich, vibrant, and enduring fellowship with His children; but how can we enjoy such communion with all its blessings and benefits if we don’t know how to pray effectively? With a refreshing blend of sound scriptural exposition and practical anecdotes, best-selling author Chris Oyakhilome, PhD, in this insightful classic shares with you vital principles of effective prayer.', '<p>God&rsquo;s earnest desire is to have a rich, vibrant, and enduring fellowship with His children; but how can we enjoy such communion with all its blessings and benefits if we don&rsquo;t know how to pray effectively? With a refreshing blend of sound scriptural exposition and practical anecdotes, best-selling author Chris Oyakhilome, PhD, in this insightful classic shares with you vital principles of effective prayer. This first volume will establish for you a clear understanding of the rules of different prayers for different situations and how to apply them for your desired outcome.</p>', 1, NULL, NULL, 1, 1, NULL, '2024-10-09 20:19:22', '2024-10-09 20:19:22'),
(4, 1, 2, 1, 'Praying the Right Way', NULL, 'praying-the-right-way', '/storage/upload/products/thumbnail/1728384785.jpg', NULL, NULL, 'ad468339-1256-48cc-909f-be8d8af632b3', '9.2', '8.3', '2200', NULL, '9.2', '8.3', 'Prayer', 'Discover the secrets and principles of effective prayer in this concise, yet comprehensive book, and rid yourself of any wrong mindsets, doctrines, perceptions, practices and prayers that may have clogged the wheels of your prayer life.', '<p>Discover the secrets and principles of effective prayer in this concise, yet comprehensive book, and rid yourself of any wrong mindsets, doctrines, perceptions, practices and prayers that may have clogged the wheels of your prayer life.</p>\r\n<p>Praying The Right Way not only teaches you dynamic principles of effective prayer, but also ignites a passion for prayer within you. The principles are simple, the results guaranteed &ndash; a life full of joy and peace as you receive answers to your prayers &hellip;always.</p>', 1, NULL, NULL, 1, 1, NULL, '2024-10-01 15:09:02', '2024-10-08 09:53:05'),
(5, 1, 2, 1, 'The Power of Tongues', NULL, 'the-power-of-tongues', '/storage/upload/products/thumbnail/1728387046.png', NULL, NULL, 'cfc2bec6-6510-49f2-b5ff-10c4de3a2aaa', '5.2', '4.7', '500', NULL, '5.2', '4.7', 'faith, Prayer, Prophecy', 'This book teaches the “What,” “How” and “Why” of speaking in other tongues, and reveals the immense benefits it holds for the New Testament believer in Jesus Christ.', '<p>This book teaches the &ldquo;What,&rdquo; &ldquo;How&rdquo; and &ldquo;Why&rdquo; of speaking in other tongues, and reveals the immense benefits it holds for the New Testament believer in Jesus Christ. It explains the essence and importance of;</p>\r\n<ul>\r\n<li>Tongues</li>\r\n<li>Interpretation of tongues and Prophecy</li>\r\n<li>The difference between Praying in Your Understanding and Praying in Tongues</li>\r\n<li>How to build up your faith through speaking in tongues</li>\r\n<li>How to enjoy intimate fellowship with the Holy Spirit.</li>\r\n</ul>', 1, NULL, NULL, 1, 1, NULL, '2024-10-01 15:04:23', '2024-10-08 10:30:46'),
(6, 1, 2, 1, 'How To Receive A Miracle And Retain It', NULL, 'how-to-receive-a-miracle-and-retain-it', '/storage/upload/products/thumbnail/1728384648.jpg', NULL, NULL, '858469fc-ad38-4f5a-b1bc-b79a2e111388', '7.2', '6.5', '2200', NULL, '7.2', '6.5', 'miracles', 'This book contains vital information on basic principles that will help you reach out and receive your miracle, and beyond that, teach you how to ward off the counter-attack of the devil, and retain your miracle.', '<p>A miracle is that supernatural intervention of God that transcends all human reasoning. Everyone at one point or the other requires this supernatural intervention. When we are faced with a seemingly hopeless situation; when we require the circumstances of our lives to change; when medical Science offers little or no hope and human reasoning proffers no solution &ndash; it&rsquo;s time for a miracle.</p>\r\n<p>This book contains vital information on basic principles that will help you reach out and receive your miracle, and beyond that, teach you how to ward off the counter-attack of the devil, and retain your miracle.</p>', 1, NULL, NULL, 1, 1, NULL, '2024-10-01 15:11:49', '2024-10-08 09:50:48'),
(7, 1, 2, 1, 'Keeping Your Healing', NULL, 'keeping-your-healing', '/storage/upload/products/thumbnail/1728386773.jpg', NULL, NULL, NULL, '4.2', '3.8', '550', NULL, '4.2', '3.8', 'faith, Prayer, Prophecy', 'Insights on how to keep your healing', '<p>Insights on how to keep your healing</p>', 1, NULL, NULL, 1, 1, NULL, '2024-09-17 20:38:04', '2024-10-08 10:26:13'),
(8, 1, 2, 1, 'None of these Diseases', NULL, 'none-of-these-diseases', '/storage/upload/products/thumbnail/1728385307.jpg', NULL, NULL, '122c2191-6884-40eb-8c59-31f9de94045f', '12.9', '11.7', '2200', NULL, '12.9', '11.7', 'Divine Healing,Divine Health,Miracles,Eternal Life,Blessings', 'God wants His people well. He desires that you prosper spirit, soul and body! No matter the situation you are facing, there is a message in this book for you. If you are sick and bed-ridden, if medical science has given up on you, the divine truths contained in this book will cause faith to be stirred up in your spirit and cause you to rise, take up your bed and walk!', '<p>God wants His people well. He desires that you prosper spirit, soul and body! No matter the situation you are facing, there is a message in this book for you. If you are sick and bed-ridden, if medical science has given up on you, the divine truths contained in this book will cause faith to be stirred up in your spirit and cause you to rise, take up your bed and walk!</p>', 1, NULL, NULL, 1, 1, NULL, '2024-10-01 14:39:11', '2024-10-08 10:01:47'),
(9, 1, 2, 1, 'The Power Of Your Mind', 'Walk in divine excellence and transform your world through the power of a renewed mind', 'the-power-of-your-mind', '/storage/upload/products/thumbnail/1728590190.jpg', NULL, NULL, '0a8c1988-fe98-4dd6-92be-2c1d30f8b4ce', '9.9', '9.0', '3300', NULL, '9.9', '9.0', 'faith, Prayer, Prophecy', 'From the bestselling author of Rhapsody of Realities, the world’s number one daily devotional, comes this new, inspiring, life-transforming classic on the sublime potential of the mind, a book written to help millions around the world function in divine excellence through the power of a renewed mind.', '<p>From the bestselling author of Rhapsody of Realities, the world&rsquo;s number one daily devotional, comes this new, inspiring, life-transforming classic on the sublime potential of the mind, a book written to help millions around the world function in divine excellence through the power of a renewed mind.</p>\r\n<p>&nbsp;</p>\r\n<p>In this remarkable treatise, one of God&rsquo;s foremost apostles and prophets of our generation, Reverend (Dr.) Chris Oyakhilome, shares with the Church, timeless truths gleaned from decades of applying his own mind to reach greater heights of accomplishment through God&rsquo;s Word. This isn&rsquo;t farfetched at all, because his yearning and passion to see people enter into their inheritance in Christ Jesus and reign in life has continually remained his driving force.</p>\r\n<p>&nbsp;</p>\r\n<p>Indeed, this amazing book couldn&rsquo;t have been released to the Body of Christ and to the whole world at a better time. Expounding on critical points such as</p>\r\n<p>&nbsp;</p>\r\n<ul>\r\n<li>The Concept of Mind-Management</li>\r\n<li>The Power of Thoughts</li>\r\n<li>Attitude&mdash;Your Mental Disposition</li>\r\n<li>Meditation&mdash;Your Moments of Creation, etc., Pastor Chris elevates your understanding of the power of your mind and helps you see it as a God-given instrument for your transformation.</li>\r\n</ul>\r\n<p style=\"padding-left: 80px;\">&nbsp;</p>\r\n<p>This book is just as apt for the young as it is for the old, because not only will it reshape the structure of its reader&rsquo;s thinking, it&rsquo;ll also open him up to realms of endless possibilities and help him become the excellent personality God planned for him to be.</p>', 1, NULL, NULL, 1, 1, NULL, '2024-10-03 15:34:44', '2024-10-10 18:56:30'),
(10, 1, 2, 1, 'Join This Chariot', 'A classic on soulwinning', 'join-this-chariot', '/storage/upload/products/thumbnail/1728384712.jpg', NULL, NULL, 'ea7265b5-f717-4440-a2c8-66179b35b0d3', '8.9', '8.1', '2200', NULL, '8.9', '8.1', 'faith, Prayer, Prophecy', 'In this book, Pastor Chris teaches divine truths about ‘chariots’ as God’s tolls for soul winning.', '<p>In this book, Pastor Chris teaches divine truths about &lsquo;chariots&rsquo; as God&rsquo;s tolls for soul winning. He reveals that God&rsquo;s call to Phillip to &ldquo;&hellip;<em>join</em>&hellip;<em>this chariot</em>&nbsp;&ldquo; (Acts 8:29) is to every believer in every generation, challenges you to answer that call and shows you how to maximize your chariot for world evangelization. You will also discover:</p>\r\n<ul>\r\n<li>Why God trusts you with the gospel</li>\r\n<li>Who a watchman is</li>\r\n<li>The Believer&rsquo;s Statements of Commitment</li>\r\n<li>&hellip;and so much more.</li>\r\n</ul>', 1, NULL, NULL, 1, 1, NULL, '2024-10-01 15:10:23', '2024-10-08 09:51:52'),
(12, 1, 2, 1, 'Recreating Your World', NULL, 'recreating-your-world', '/storage/upload/products/thumbnail/1728384851.jpg', NULL, NULL, '47127371-221d-4cb0-83d4-2812aa8a58a1', '9.2', '8.3', '1650', NULL, '9.2', '8.3', 'faith, Prayer, Prophecy', '“Can I achieve my goals? How can I achieve the life of my dreams? Can I do something about my situation or is everything I am going through God’s will for me?”', '<p>&ldquo;Can I achieve my goals? How can I achieve the life of my dreams? Can I do something about my situation or is everything I am going through God&rsquo;s will for me?&rdquo;</p>\r\n<p>In this book, Pastor Chris Oyakhilome D. Sc., D. D. teaches simple, but profound, time-tested principles for effecting positive changes in your life, now.&nbsp;Every believer has the right and the ability to cause changes; You too can recreate the circumstances of your life and live your best life now.&nbsp;Get answers to these questions and much more in the bestseller Recreating Your World.</p>', 1, NULL, NULL, 1, 1, NULL, '2024-10-01 15:06:23', '2024-10-08 09:54:12'),
(13, 1, 2, 1, 'The Gates Of Zion', NULL, 'the-gates-of-zion', '/storage/upload/products/thumbnail/1728384601.jpg', NULL, NULL, '4e9c52f8-278d-41ee-8b79-7eb95e36a1f7', '8.9', '8.1', '2750', NULL, '8.9', '8.1', 'Christian Life and Living', 'In this prophetic book, Pastor Chris takes you through the rebuilding of the walls of Jerusalem as symbolic of God’s pattern for building His Church. Not only will you experience the glory of God as you read, more importantly, you will reflect His glory in your life.', '<p>In this prophetic book, Pastor Chris takes you through the rebuilding of the walls of Jerusalem as symbolic of God&rsquo;s pattern for building His Church. Not only will you experience the glory of God as you read, more importantly, you will reflect His glory in your life.</p>', 1, NULL, NULL, 1, 1, NULL, '2024-10-01 15:15:26', '2024-10-08 09:50:01'),
(14, 1, 2, 1, 'The Oil and the Mantle', 'Unvieling the mysteries of material medium', 'the-oil-and-the-mantle', '/storage/upload/products/thumbnail/1728384952.jpg', NULL, NULL, '6248cb3a-04a6-4914-9ee2-82aa6a1be61e', '9.2', '8.3', '2200', NULL, '9.2', '8.3', 'christian living', 'In the new edition of this important book are revealed mysteries of material mediums.\r\n\r\nIn his usual dynamic and easy-to-be-understood manner, Chris Oyakhilome exposes the myths about the use of material mediums to perform miracles, and reveals clearly the mind of God on the subject.', '<p>In the new edition of this important book are revealed mysteries of material mediums.</p>\r\n<p>In his usual dynamic and easy-to-be-understood manner, Chris Oyakhilome exposes the myths about the use of material mediums to perform miracles, and reveals clearly the mind of God on the subject.</p>\r\n<p>&ldquo;The Oil and The Mantle,&rdquo; an explicit treatise on these controversial issues, will cause you to be established in the truth.</p>', 1, NULL, NULL, 1, 1, NULL, '2024-10-01 15:05:25', '2024-10-08 09:55:52'),
(15, 1, 2, 1, 'The Promised Land', NULL, 'the-promised-land', '/storage/upload/products/thumbnail/1728385607.jpg', NULL, NULL, NULL, '12.9', '11.7', '3300', NULL, '12.9', '11.7', 'faith, Prayer, Prophecy', 'This book is a classic exposition of the Christian life. It provides Bible-based answers to a lot of questions, and provides explanations needed to live a constantly victorious life.', '<p>The Promised Land is a classic exposition of the Christian life. It provides Bible-based answers to a lot of questions, and provides explanations needed to live a constantly victorious life.</p>\r\n<p>Every page is filled with divine truths. You will need to read &ldquo;The Promised Land&rdquo; again and again. It is a must for every Christian, every minister and every serious student of the Bible.</p>', 1, NULL, NULL, 1, 1, NULL, '2024-09-17 21:21:03', '2024-10-08 10:06:47'),
(16, 1, 2, 1, 'Your Rights in Christ', NULL, 'your-rights-in-christ', '/storage/upload/products/thumbnail/1728385159.jpg', NULL, NULL, '4e80a802-1f72-418f-8ba8-051dac449397', '9.2', '8.3', '2200', NULL, '9.2', '8.3', 'righteousness,Glorious life', 'By virtue of the redemptive work of Christ, you have been declared free and at liberty to choose the way to live. This freedom in Christ comes with legal rights that empower you to dictate the course of your life.', '<p>By virtue of the redemptive work of Christ, you have been declared free and at liberty to choose the way to live. This freedom in Christ comes with legal rights that empower you to dictate the course of your life.&nbsp; Join Pastor Chris in &ldquo;Your Rights In Christ&rdquo; as he shows you what these rights are, their significance, their benefits, and how to appropriate them to yourself.</p>\r\n<p>This revised edition has been designed to make its vital truths more practical in your daily Christian walk.</p>', 1, NULL, NULL, 1, 1, NULL, '2024-10-01 14:59:09', '2024-10-08 09:59:19'),
(17, 1, 2, 1, 'When God visits you', NULL, 'when-god-visits-you', '/storage/upload/products/thumbnail/1728385124.jpg', NULL, NULL, '33ef3d5b-d9ea-4800-a37c-b2a2a196ac13', '9.2', '8.3', '1980', NULL, '9.2', '8.3', 'strong desire for a change,visitation,transformation,preparation', 'Does God visit?\r\nWhen does He visit?\r\nHow do I prepare for His visitation?\r\nWhat are the benefits of such visits?', '<p>Does God visit?<br />When does He visit?<br />How do I prepare for His visitation?<br />What are the benefits of such visits?</p>\r\n<p>In this dynamic volume, Pastor Chris shares from the lives of Bible characters on how you can position yourself for a visitation from God and experience that change you&rsquo;ve so long desired.</p>', 1, NULL, NULL, 1, 1, NULL, '2024-10-01 15:01:02', '2024-10-08 09:58:44'),
(18, 1, 2, 1, 'Rhapsody Of Realities Devotional Study Bible – Smart Size', NULL, 'rhapsody-of-realities-devotional-study-bible-–-smart-size', '/storage/upload/products/thumbnail/1728386422.png', NULL, NULL, NULL, '20', '18', '6500', NULL, '20', '18', 'faith, Prayer, Prophecy', 'Ignite your spiritual journey with the remarkable smart-size Rhapsody Of Realities Devotional Study Bible. Seamlessly blending profound insights, comprehensive study tools, and inspirational messages, this bible is your ultimate companion for deepening your connection with God.', '<p>Ignite your spiritual journey with the remarkable smart-size Rhapsody Of Realities Devotional Study Bible. Seamlessly blending profound insights, comprehensive study tools, and inspirational messages, this bible is your ultimate companion for deepening your connection with God.</p>\r\n<p><strong>Features:</strong></p>\r\n<p><strong>Inspirational Messages:</strong>&nbsp;Read inspiration and revelation, guiding you towards a closer walk with God.</p>\r\n<p><strong>Bible Study Plan:</strong>&nbsp;Embark on a transformative journey with either a one-year or two-year Bible study plan, allowing you to delve deeper into the scriptures.</p>\r\n<p><strong>Center Column Reference:</strong>&nbsp;Easily cross-reference verses, enhancing your understanding of God&rsquo;s word and its connections.</p>\r\n<p><strong>Words of Christ in Red:</strong>&nbsp;Discern the words of Christ as they are highlighted in red, emphasizing the teachings of the Savior.</p>\r\n<p><strong>96-Page Concordances:</strong>&nbsp;Access a comprehensive collection of concordances to swiftly locate specific verses and topics.</p>\r\n<p><strong>Compact Size:</strong>&nbsp;Designed as a smart-size Bible, it offers portability. Carry it wherever you go, and be equipped for spiritual growth and revelation at any moment.</p>\r\n<p><strong>Elevate Your Spiritual Growth:</strong>&nbsp;Whether you&rsquo;re a seasoned believer or a newcomer to the faith, the Rhapsody Of Realities Devotional Study Bible is a potent tool for cultivating a deep and meaningful relationship with God&rsquo;s word. It&rsquo;s more than a Bible &ndash; it&rsquo;s an invaluable resource for daily inspiration, personal reflection, and spiritual enlightenment.</p>\r\n<p>Discover the transformative power of the Rhapsody Of Realities Devotional&nbsp;<a href=\"https://loveworldbooks.org/product/rhapsody-of-realities-devotional-study-bible/\">Study Bible</a>. Elevate your understanding, enrich your faith, and embrace a life illuminated by the word of God.</p>', 1, NULL, NULL, 1, NULL, NULL, '2024-09-17 21:36:26', '2024-10-08 10:20:22'),
(19, 1, 2, 1, 'Rhapsody of Realities- A Topical Compendium volume 5', NULL, 'rhapsody-of-realities--a-topical-compendium-volume-5', '/storage/upload/products/thumbnail/1728386266.png', NULL, NULL, NULL, '14.99', '13.5', '4400', NULL, '14.99', '13.5', 'faith, Prayer, Prophecy', 'The Rhapsody of Realities Topical Compendium series are comprehensive reference materials that have enhanced Word based training among Christians. These series are renowned with inspiring articles that articulate the gospel of our Lord Jesus, and it’s, therefore, an important tool for the spiritual development of God’s children.', '<p>The Rhapsody of Realities Topical Compendium series are comprehensive reference materials that have enhanced Word based training among Christians. These series are renowned with inspiring articles that articulate the gospel of our Lord Jesus, and it&rsquo;s, therefore, an important tool for the spiritual development of God&rsquo;s children.</p>\r\n<p>The Rhapsody of Realities Topical Compendium Volume 5 is the newest installment in the series of compilation of choice articles by Rev. Chris Oyakhilome. What&rsquo;s more, the articles in this volume have been organized under exciting chapters such as: The Acts of God, The Efficacy of God&rsquo;s Word, The Lordship of Jesus Christ, The Holy Spirit and You, The Mindset of the Just, The Ministry of Reconciliation, The Glory &ndash; Life, The Authority of Believers, Divine Benefits.</p>\r\n<p>This is a sure complete resource book, that guarantees your profound walk with the Lord through fellowship with His Word.</p>', 1, NULL, NULL, 1, NULL, NULL, '2024-09-17 21:39:51', '2024-10-08 10:17:46'),
(20, 1, 2, 1, 'RORK Illustrated Bible', NULL, 'rork-illustrated-bible', '/storage/upload/products/thumbnail/1728386195.png', NULL, NULL, NULL, '20', '18', '10500', NULL, '20', '18', 'faith, Prayer, Prophecy', 'More than just a collection of Bible stories, RORK Illustrated Bible tells the story within the story, and it brings to light the message of love, hope and faith, to help children experience the wonders and beauties of the Christian life.', '<p>More than just a collection of Bible stories, RORK Illustrated Bible tells the story within the story, and it brings to light the message of love, hope and faith, to help children experience the wonders and beauties of the Christian life.</p>\r\n<p>RORK Illustrated Bible will be a great material for the family to bond, as it comes in handy during household Bible study times and at bedtime with the children. Teachers will also find it resourceful to prepare to teach notes and outline for their students.</p>\r\n<p>This is an extraordinary work put together to make the Bible come alive for every child!</p>', 1, NULL, NULL, 1, NULL, NULL, '2024-09-17 21:42:42', '2024-10-08 10:16:35'),
(21, 1, 2, 1, 'TeeVo Bible', NULL, 'teevo-bible', '/storage/upload/products/thumbnail/1728386157.png', NULL, NULL, NULL, '20', '18', '6500', NULL, '20', '18', 'faith, Prayer, Prophecy', 'The Teevo Bible has been designed to inspire and encourage teenagers and young adults generally to study God’s word. You will find presentation styles endearing and its features helpful. engaging and designed to appeal to young minds.', '<p>The Teevo Bible has been designed to inspire and encourage teenagers and young adults generally to study God&rsquo;s word. You will find presentation styles endearing and its features helpful. engaging and designed to appeal to young minds.</p>', 1, NULL, NULL, 1, NULL, NULL, '2024-09-17 21:45:27', '2024-10-08 10:15:58'),
(22, 1, 2, 1, 'Seven Things The Holy Spirit Will Do For You', NULL, 'seven-things-the-holy-spirit-will-do-for-you', '/storage/upload/products/thumbnail/1728384566.jpg', NULL, NULL, 'c2f31a58-6fbd-4154-9aba-c134b2afc6b7', '9.2', '8.3', '2200', NULL, '9.2', '8.3', 'Holy Spirit', 'Learn how to take advantage of His awesome presence, ministry and fellowship and live the supernatural life every day!', '<p>Enter a whole new world of discovery of the person of the Holy Spirit and the fullness of the blessings He brings into your life in this revised edition of the classic &ldquo;Seven Things the Holy Spirit Will Do For You.&rdquo;</p>\r\n<p>Learn how to take advantage of His awesome presence, ministry and fellowship and live the supernatural life every day!</p>', 1, NULL, NULL, 1, 1, NULL, '2024-10-01 15:24:07', '2024-10-08 09:49:26'),
(23, 1, 2, 1, 'Seven Things The Holy Spirit Will Do In You', NULL, 'seven-things-the-holy-spirit-will-do-in-you', '/storage/upload/products/thumbnail/1728384680.jpg', NULL, NULL, '06eaa0c5-5dc8-461b-a361-743f71c3f713', '9.2', '8.3', '2200', NULL, '9.2', '8.3', 'Holy Spirit', 'Get ready for a fresh revelation of Who the Holy Spirit is and what He can do in your life. And begin to enjoy the fullness of the blessings of His presence as you walk with Him daily.', '<p>Get ready for a fresh revelation of Who the Holy Spirit is and what He can do in your life. And begin to enjoy the fullness of the blessings of His presence as you walk with Him daily.</p>\r\n<p>In&nbsp;<em>Seven Things The Holy Spirit Will Do In You,&nbsp;</em>Pastor Chris introduces the Holy Spirit and shows you seven things He will do in you; seven crucial blessings you will have in your life&nbsp;<em>only</em>&nbsp;when you receive Him and give Him full, unlimited access.</p>', 1, NULL, NULL, 1, 1, NULL, '2024-10-01 15:22:02', '2024-10-08 09:51:20'),
(24, 1, 2, 1, 'The Seven Spirits Of God', NULL, 'the-seven-spirits-of-god', '/storage/upload/products/thumbnail/1728385073.jpg', NULL, NULL, '40796957-1308-4584-8dce-cb3747783bbe', '12.9', '11.7', '2970', NULL, '12.9', '11.7', 'The Supenatural,The Miraculous,Holy Spirit,The fullness of the Spirit,The Spirit of wisdom', 'You will receive the revelation knowledge you require to experience the fullness of the Holy Spirit in your life and discover deeper dimensions of the Spirit that will enable you walk in the miraculous and supernatural consistently.', '<p>In the riveting classic on the Holy Spirit, Chris Oyakhilome unveils to you new depths of His power and operation in the life of the believer. This book teaches you;</p>\r\n<ul>\r\n<li><em>What</em></li>\r\n<li><em>Who</em></li>\r\n<li><em>Why</em></li>\r\n<li><em>How</em></li>\r\n</ul>\r\n<p>You will receive the revelation knowledge you require to experience the fullness of the Holy Spirit in your life and discover deeper dimensions of the Spirit that will enable you walk in the miraculous and supernatural consistently.<strong><em>&nbsp;</em></strong></p>', 1, NULL, NULL, 1, 1, NULL, '2024-10-01 15:03:26', '2024-10-08 09:57:53'),
(25, 3, 2, 1, '30-60 Hundredfold: Your Financial Harvest Released by Dr John Avanzini', NULL, '30-60-hundredfold:-your-financial-harvest-released-by-dr-john-avanzini', '/storage/upload/products/thumbnail/1728386096.png', NULL, NULL, NULL, '0', NULL, '0', NULL, '0', NULL, 'faith, Prayer, Prophecy', '30, 60, Hundredfold: Your Financial Harvest Released – is an enlightening read for anyone seeking biblical wisdom on financial prosperity.', '<p>30, 60, Hundredfold: Your Financial Harvest Released &ndash; is an enlightening read for anyone seeking biblical wisdom on financial prosperity. This book delves into the profound, yet often overlooked, principles of sowing and reaping as it applies to your finances. Avanzini draws compelling parallels between agricultural laws of the harvest and financial success, offering readers twelve actionable laws to unlock their potential for abundance. With a blend of personal testimony and scriptural truths, Avanzini doesn&rsquo;t just theorize; he shares a practical blueprint that transforms giving into a spiritual act capable of yielding miraculous returns. This is not just a book about getting rich&mdash;it&rsquo;s about understanding the divine economics that can lead to a life of generosity, stability, and God-centered financial breakthrough.</p>', 1, NULL, NULL, 1, NULL, NULL, '2024-09-17 22:01:34', '2024-10-08 10:14:56'),
(26, 3, 2, 1, 'Rich God Poor God by Dr John Avanzini', NULL, 'rich-god-poor-god-by-dr-john-avanzini', '/storage/upload/products/thumbnail/1728385690.png', NULL, NULL, NULL, '0', NULL, '0', NULL, '0', NULL, 'faith, Prayer, Prophecy', 'Rich God, Poor God: Reclaiming True Wealth – by Dr John Avanzini is a transformative guide that will challenge your perception of prosperity and its divine purpose.', '<p>Rich God, Poor God: Reclaiming True Wealth &ndash; by Dr John Avanzini is a transformative guide that will challenge your perception of prosperity and its divine purpose. In this compelling narrative, Dr Avanzini dismantles the misconceptions that equate godliness with poverty, inviting you to embrace a God who delights in your prosperity. With profound insights into Scripture, this book reveals how God&rsquo;s abundant nature is at the core of His plan for you, offering practical wisdom on aligning with divine prosperity. Beyond mere wealth, it&rsquo;s a call to stewardship, to manage God&rsquo;s riches in a way that extends His generosity to others. Prepare to expand your horizons beyond the limitations of need-based giving and step into a life of abundant giving. This book isn&rsquo;t just about wealth&mdash;it&rsquo;s about transforming your financial perspective to reflect the true richness of a God who gives lavishly to His children.</p>', 1, NULL, NULL, NULL, 1, NULL, '2024-09-18 09:19:45', '2024-10-08 10:08:10'),
(27, 1, 2, 1, 'I’m beautiful', NULL, 'i’m-beautiful', '/storage/upload/products/thumbnail/1728385898.png', NULL, NULL, NULL, '4', NULL, '1980', NULL, '4', NULL, 'faith, Prayer, Prophecy', 'I Know Who I Am Volume 5 is about a young girl Timi. She is excited about being invited to Tana’s birthday party but at the party something happens to her that makes her sad. Timi is a little girl that is confronted with a situation many kids of her age often deal with: peer pressure, identify crisis and self-confidence.\r\n\r\nFollow her journey to self-discovery and that transcendent joy in knowing who she is in Christ. Find out what happened to her and learn how she overpowered it.', '<p><strong><em>I Know Who I Am</em></strong>&nbsp;Volume 5 is about a young girl Timi. She is excited about being invited to Tana&rsquo;s birthday party but at the party something happens to her that makes her sad. Timi is a little girl that is confronted with a situation many kids of her age often deal with: peer pressure, identify crisis and self-confidence.</p>\r\n<p>Follow her journey to self-discovery and that transcendent joy in knowing who she is in Christ. Find out what happened to her and learn how she overpowered it.</p>', 1, NULL, NULL, 1, 1, NULL, '2024-09-17 22:08:05', '2024-10-08 10:11:38'),
(28, 1, 2, 1, 'I’m Smart', NULL, 'i’m-smart', '/storage/upload/products/thumbnail/1728385842.png', NULL, NULL, NULL, '0', NULL, '1980', NULL, '0', NULL, 'faith, Prayer, Prophecy', 'In this 2nd Volume in the series, I Know Who I Am, Kevin always believes he’s not smart. He shies away from any game or activity that would make him think intelligently.\r\n\r\nHis classmates eventually find out and tease him about it. Kevin accepts what they say as true and doesn’t think he can ever become smart.\r\n\r\nThen… he learns something new, something he’s never heard before and from that moment everything about him changes.\r\n\r\nFind out what Kevin discovers that changes everything about him.', '<p>In this 2<sup>nd</sup>&nbsp;Volume in the series,&nbsp;<strong><em>I Know Who I Am</em></strong>, Kevin always believes he&rsquo;s not smart. He shies away from any game or activity that would make him think intelligently.</p>\r\n<p>His classmates eventually find out and tease him about it. Kevin accepts what they say as true and doesn&rsquo;t think he can ever become smart.</p>\r\n<p>Then&hellip; he learns something new, something he&rsquo;s never heard before and from that moment everything about him changes.</p>\r\n<p>Find out what Kevin discovers that changes everything about him.</p>', 1, NULL, NULL, 1, 1, NULL, '2024-09-17 22:11:14', '2024-10-08 10:10:42'),
(29, 1, 2, 1, 'Great Miracles of The Bible (Vol 1)', NULL, 'great-miracles-of-the-bible-(vol-1)', '/storage/upload/products/thumbnail/1728385781.png', NULL, NULL, NULL, '9.2', '8.3', '2200', NULL, '9.2', '8.3', 'faith, Prayer, Prophecy', 'Great Miracles of the Bible is a collection of inspiring illustrated stories of God’s divine intervention in the affairs of men that would stir children to have faith in God and the miraculous.\r\n\r\nThis edition has three exciting stories and themes with vivid illustrations. As an added feature, we have included Discussion/ Question & Answer pages to help strengthen what they will learn in each story, building in them life-principles.', '<p>Great Miracles of the Bible is a collection of inspiring illustrated stories of God&rsquo;s divine intervention in the affairs of men that would stir children to have faith in God and the miraculous.</p>\r\n<p>This edition has three exciting stories and themes with vivid illustrations. As an added feature, we have included Discussion/ Question &amp; Answer pages to help strengthen what they will learn in each story, building in them life-principles.</p>', 1, NULL, NULL, 1, 1, NULL, '2024-09-17 22:14:24', '2024-10-08 10:09:41'),
(30, 1, 2, 1, 'Prophecy', 'Understanding the Power That Controls Your Future', 'prophecy', '/storage/upload/products/thumbnail/1728386974.png', NULL, NULL, '277de15c-461b-4c19-9787-8bf626071861', '5', NULL, '2397', NULL, '5', NULL, 'Prophecy,confessions,faith,supernatural', '“And it shall come to pass in the last days, says God, That I will pour out of My Spirit on all flesh; Your sons and your daughters shall prophesy…”Acts 2:17 NKJV', '<p>&ldquo;And it shall come to pass in the last days, says God, That I will pour out of My Spirit on all flesh; Your sons and your daughters shall prophesy&hellip;&rdquo;Acts 2:17 NKJV</p>\r\n<p>God&rsquo;s people are a people of prophecy. We are products of the prophetic Word and we can only be established and make advancements in our lives through the same. In this timely classic, Pastor Chris Oyakhilome reveals how to take advantage of the powerful gift of prophecy to order the course of your life, and create the future you ought to have.</p>\r\n<p>Get ready to discover:</p>\r\n<p>* What Prophecy really is<br />* The two-fold application of prophecy<br />* The difference between the prophetic ministry and the gift of prophecy<br />* The link between prophecy and tongues<br />* How to change circumstances through prophecy and so much more!</p>\r\n<p>Learn to speak forth Rhema &ndash; God&rsquo;s specific Word to you, at a specific time, for a specific purpose &ndash; and control your destiny by the power of God made available to you through prophecy!</p>', 1, NULL, NULL, 1, 1, NULL, '2024-10-01 15:08:08', '2024-10-08 10:29:34'),
(31, 1, 2, 1, 'The Holy Spirit and You', NULL, 'the-holy-spirit-and-you', '/storage/upload/products/thumbnail/1728385221.jpg', NULL, NULL, 'fb4f53e0-66b1-454c-be52-db2e709c5749', '9.2', '8.3', '1650', NULL, '9.2', '8.3', 'Holy Spirit,success,my helper,the supernatural', 'Discover in “The Holy Spirit and You” the key to the successful life you’ve always desired.', '<p>Discover in &ldquo;<strong>The Holy Spirit and You&rdquo;&nbsp;</strong>the key to the successful life you&rsquo;ve always desired. Get to know the One who answers to the Name of Jesus. Learn to walk with Him, and let Him lead you into your inheritance and your destiny in God.</p>\r\n<p>&ldquo;<strong>The Holy Spirit and You&rdquo;&nbsp;</strong>will arouse in you a deep desire for an intimate relationship with the Holy Spirit and help you develop such a relationship. THEN YOU AND THE HOLY SPIRIT CAN MAKE AN UNBEATABLE TEAM THAT WILL IMPACT YOUR WORLD!</p>', 1, NULL, NULL, 1, 1, NULL, '2024-10-01 14:50:11', '2024-10-08 10:00:21'),
(34, 1, 2, 1, 'Don’t Stop Here', NULL, 'don’t-stop-here', '/storage/upload/products/thumbnail/1728384511.jpg', NULL, NULL, '9931788c-1007-4e24-a29c-e3b392093210', '7.2', '6.5', '1320', NULL, '7.2', '6.5', 'Christian Life and living', 'In “Don’t Stop Here” Pastor Chris shows you just how to make spiritual progress as he takes you through Elijah and Elisha’s journey from Gilgal to Jordan. This inspirational and prophetic book will open your eyes to see where you are in your spiritual journey.', '<p>In &ldquo;Don&rsquo;t Stop Here&rdquo; Pastor Chris shows you just how to make spiritual progress as he takes you through Elijah and Elisha&rsquo;s journey from Gilgal to Jordan. This inspirational and prophetic book will open your eyes to see where you are in your spiritual journey.</p>', 1, NULL, NULL, 1, 1, NULL, '2024-10-01 16:10:40', '2024-10-08 09:48:31'),
(36, 1, 2, 1, 'Now That You Are Born Again', NULL, 'now-that-you-are-born-again', '/storage/upload/products/thumbnail/1728386569.png', NULL, NULL, '1026be81-7e0a-4e16-936d-829b25ef536e', '5.2', '4.7', '500', NULL, '5.2', '4.7', 'salvation, New Creation', '“Now that you’re born again, WHAT NEXT?” That’s the big question, and this book gives clear and simple answers. In it, best-selling author and teacher, Chris Oyakhilome, reveals vital truths fundamental to the Christian faith, truths upon which you can build a strong and vibrant life in Christ.', '<p>&ldquo;Now that you&rsquo;re born again, WHAT NEXT?&rdquo; That&rsquo;s the big question, and this book gives clear and simple answers. In it, best-selling author and teacher, Chris Oyakhilome, reveals vital truths fundamental to the Christian faith, truths upon which you can build a strong and vibrant life in Christ.</p>\r\n<p>&ldquo;Now That You Are Born Again&rdquo; unveils insightful revelations that will point the new Christian in the right direction and nurture him in his new life in Christ.</p>', 1, NULL, NULL, 1, 1, NULL, '2024-10-04 16:00:14', '2024-10-08 10:22:49');

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

--
-- Table structure for table `sessions`
--

CREATE TABLE `sessions` (
  `id` varchar(255) NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `ip_address` varchar(45) DEFAULT NULL,
  `user_agent` text DEFAULT NULL,
  `payload` longtext NOT NULL,
  `last_activity` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sessions`
--

INSERT INTO `sessions` (`id`, `user_id`, `ip_address`, `user_agent`, `payload`, `last_activity`) VALUES
('7MgRKGyZUPvIq41qKOKq6ucKryhqreFHSiFpl89w', 1, '127.0.0.1', 'Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36', 'YTo0OntzOjY6Il90b2tlbiI7czo0MDoiTm4xbDRxYWNHNWo3WGRnMHdaSk9yYW1EMU1BYkx4cGlKemxObDdlayI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6MzI6Imh0dHA6Ly9lbGlicmFyeS50ZXN0L2FsbC9wcm9kdWN0Ijt9czo2OiJfZmxhc2giO2E6Mjp7czozOiJvbGQiO2E6MDp7fXM6MzoibmV3IjthOjA6e319czo1MDoibG9naW5fd2ViXzU5YmEzNmFkZGMyYjJmOTQwMTU4MGYwMTRjN2Y1OGVhNGUzMDk4OWQiO2k6MTt9', 1728590863);

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

--
-- Table structure for table `sliders`
--

CREATE TABLE `sliders` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `slider_name` varchar(255) DEFAULT NULL,
  `slider_image` varchar(255) DEFAULT NULL,
  `slider_heading` varchar(255) DEFAULT NULL,
  `slider_text` text DEFAULT NULL,
  `slider_url` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `sliders`
--

INSERT INTO `sliders` (`id`, `slider_name`, `slider_image`, `slider_heading`, `slider_text`, `slider_url`, `created_at`, `updated_at`) VALUES
(1, 'GCS', '/storage/upload/slider/1728499307.jpg', NULL, NULL, 'http://test.loveworldbooks.org/', '2024-10-09 17:41:47', '2024-10-09 20:55:38'),
(2, 'YLW', '/storage/upload/slider/1728499348.jpg', NULL, NULL, NULL, '2024-10-09 17:42:28', '2024-10-09 17:42:28');

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

--
-- Table structure for table `subscriptions`
--

CREATE TABLE `subscriptions` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `user_id` bigint(20) UNSIGNED DEFAULT NULL,
  `payment_id` bigint(20) UNSIGNED DEFAULT NULL,
  `subscription_name` varchar(255) DEFAULT NULL,
  `level_id` bigint(20) UNSIGNED DEFAULT NULL,
  `subscription_duration` enum('monthly','quarterly','yearly') DEFAULT NULL,
  `start_date` varchar(255) DEFAULT NULL,
  `end_date` varchar(255) DEFAULT NULL,
  `status` enum('active','inactive') DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `subscriptions`
--

INSERT INTO `subscriptions` (`id`, `user_id`, `payment_id`, `subscription_name`, `level_id`, `subscription_duration`, `start_date`, `end_date`, `status`, `created_at`, `updated_at`) VALUES
(13, 3, 19, 'Gold  Subscription', 9, 'monthly', '2024-10-02 12:05:07', '2024-11-02 12:05:07', 'active', '2024-10-02 11:05:07', NULL),
(14, 6, 20, 'Platinum Subscription', 10, 'yearly', '2024-10-02 13:29:24', '2025-10-02 13:29:24', 'active', '2024-10-02 12:29:24', NULL),
(15, 15, 21, 'Gold  Subscription', 9, 'monthly', '2024-10-02 17:04:26', '2024-11-02 17:04:26', 'active', '2024-10-02 16:04:26', NULL),
(16, 16, 22, 'Gold  Subscription', 9, 'monthly', '2024-10-03 10:40:59', '2024-11-03 10:40:59', 'active', '2024-10-03 09:40:59', NULL),
(17, 18, 23, 'Gold  Subscription', 9, 'monthly', '2024-10-03 18:10:03', '2024-11-03 18:10:03', 'active', '2024-10-03 17:10:03', NULL);

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

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

CREATE TABLE `testimonials` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `testimonial_name` varchar(255) DEFAULT NULL,
  `testimonial_image` varchar(255) DEFAULT NULL,
  `testimonial_country` varchar(255) DEFAULT NULL,
  `testimonial_text` text DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `testimonials` (`id`, `testimonial_name`, `testimonial_image`, `testimonial_country`, `testimonial_text`, `created_at`, `updated_at`) VALUES
(1, 'Martins Rich', '/storage/upload/testimonial/1728410727.jpg', 'Lagos, Nigeria', '<p>The Teaching Word of God From The Man Of God - Rev Chris Has Greatly Blessed and Impacted My Life.&nbsp; My Life Has Indeed Been Given A Meaning.&nbsp; I now know who I am In Christ Jesus.</p>', '2024-10-08 17:03:48', '2024-10-08 17:19:25'),
(2, 'Stephanie Grace', NULL, 'Accra, Ghana', '<p>The Teaching Word of God From The Man Of God - Rev Chris Has Greatly Blessed and Impacted My Life.&nbsp; My Life Has Indeed Been Given A Meaning.&nbsp; I now know who I am In Christ Jesus.</p>', '2024-10-08 17:06:19', '2024-10-08 17:19:10'),
(3, 'Steve Clarkson', '/storage/upload/testimonial/1728590812.jpg', 'United States', '<p>The Teaching Word of God From The Man Of God - Rev Chris Has Greatly Blessed and Impacted My Life.&nbsp; My Life Has Indeed Been Given A Meaning.&nbsp; I now know who I am In Christ Jesus.</p>', '2024-10-08 17:07:03', '2024-10-10 19:06:52'),
(4, 'Fullman Harry', NULL, 'United Kingdom', '<p>The Teaching Word of God From The Man Of God - Rev Chris Has Greatly Blessed and Impacted My Life.&nbsp; My Life Has Indeed Been Given A Meaning.&nbsp; I now know who I am In Christ Jesus.</p>', '2024-10-08 17:07:42', '2024-10-08 17:07:42'),
(6, 'Philip Nelson', NULL, 'South Africa', '<p>The Teaching Word of God From The Man Of God - Rev Chris Has Greatly Blessed and Impacted My Life.&nbsp; My Life Has Indeed Been Given A Meaning.&nbsp; I now know who I am In Christ Jesus.</p>', '2024-10-08 17:21:04', '2024-10-08 17:21:04');

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

--
-- Table structure for table `users`
--

CREATE TABLE `users` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `title` varchar(255) DEFAULT NULL,
  `firstname` varchar(255) NOT NULL,
  `surname` varchar(255) NOT NULL,
  `username` varchar(255) DEFAULT NULL,
  `email` varchar(255) NOT NULL,
  `email_verified_at` timestamp NULL DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `photo` varchar(255) DEFAULT NULL,
  `phone_number` varchar(255) DEFAULT NULL,
  `country` varchar(255) DEFAULT NULL,
  `role` enum('admin','vendor','user') NOT NULL DEFAULT 'user',
  `status` enum('1','0') NOT NULL DEFAULT '1',
  `remember_token` varchar(100) DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `users`
--

INSERT INTO `users` (`id`, `title`, `firstname`, `surname`, `username`, `email`, `email_verified_at`, `password`, `photo`, `phone_number`, `country`, `role`, `status`, `remember_token`, `created_at`, `updated_at`) VALUES
(1, 'Mr', 'Admin', 'Greatness', 'admin', 'admin@email.com', '2024-08-22 10:09:50', '$2y$12$PA0wX3QOGDEo9H3/pgwxcOnEF4kaD1La4pOxLXCSa8ZMMv4OVlugK', NULL, '08076739334', 'Ogba', 'admin', '1', 'gppEVBMtNVnsw7Ifk9Lkt95piqmfv1MTbdSGptzXabiyt1jl8lfn7DBkB1Nc', NULL, '2024-08-31 10:21:11'),
(2, 'Mr', 'Vendor', 'Plus', 'vendor', 'vendor@email.com', '2024-08-22 10:13:47', '$2y$12$G1ihT3OiJMKltBNA1RkVM.fv5SIaRdmahNsV0h/cCymVxe6fcz/t6', NULL, '08076739334', 'Lagos', 'vendor', '1', NULL, NULL, '2024-08-31 09:16:16'),
(3, 'Mr', 'User', 'Greatness', 'user', 'user@email.com', '2024-08-21 16:27:54', '$2y$12$XuCVzmhxwhVT/0vNmgG9t.NXCHKII91eqzUjCspaPgGcL/h0pUKjK', NULL, '08076739334', 'Lagos', 'user', '1', NULL, NULL, '2024-08-31 08:15:32'),
(4, 'Mr', 'Admin2', 'Profile', 'admin2', 'admin2@email.com', '2024-08-26 07:32:37', '$2y$12$7h0rcXvjSP4FZLQtmvi5xuXQYPKgJWMisqX5c6eod3KMyvkhljAWe', NULL, NULL, NULL, 'admin', '1', NULL, NULL, '2024-08-26 07:32:37'),
(5, 'Mr', 'Vendor2', 'Profile', 'vendor2', 'vendor2@email.com', NULL, '$2y$12$5dbsSSp.vsD1q99cKy/mNeCFyb/6AjpLh8kC6MnFwemmLyuNj9AZi', NULL, NULL, NULL, 'vendor', '1', NULL, NULL, NULL),
(6, 'Mr', 'User2', 'Profile', 'user2', 'user2@email.com', '2024-10-01 17:07:46', '$2y$12$wX9PfjDO0hWHzPj1TEEXHOm/XyBEtJm2hegyTad/xCOkDtSFEY.i.', NULL, NULL, NULL, 'user', '1', NULL, NULL, '2024-10-01 17:07:46'),
(7, 'Mr', 'Admin3', 'Profile', 'admin3', 'admin3@email.com', NULL, '$2y$12$pRLax8XJeHUDzwQbwMmthO/okH0nB50YgJfaKZ2ni78rlPks2eNOO', NULL, NULL, NULL, 'admin', '1', NULL, NULL, NULL),
(8, 'Mr', 'Vendor3', 'Profile', 'vendor3', 'vendor3@email.com', NULL, '$2y$12$9Du3UtZ1J/jBcwOZSwPb4ejaQB1X7.WH8JjvMZ9H7FPKd1tP86eIa', NULL, NULL, NULL, 'vendor', '1', NULL, NULL, NULL),
(9, 'Mr', 'User3', 'Profile', 'user3', 'user3@email.com', '2024-10-01 18:46:07', '$2y$12$KIA8PctZNNx1YfWIATeAKudaIMmi1M2MFELwMwQhwTAiVOpAXFJU6', NULL, NULL, NULL, 'user', '1', NULL, NULL, '2024-10-01 18:46:07'),
(10, 'Mr', 'Phenom', 'Pm', NULL, 'phenompm@gmail.com', '2024-08-22 07:57:40', '$2y$12$bZhniFTB3.V5/IJYHxj60uvs1FhRfhwh5epmCFlt6L8JBwgjAguEm', NULL, NULL, NULL, 'user', '1', NULL, '2024-08-22 07:57:00', '2024-08-22 07:57:40'),
(12, 'Esteemed Bro', 'Busayo', 'Olujobi', 'Bossman', 'olujobimayowa@yahoo.com', '2024-09-28 07:51:41', '$2y$12$Mys4wwcUwanlNzbMbceTl.zRPkjSO7Ozd/ybC.PRnzd0jd8QXiB1m', NULL, '08076739334', 'nigeria', 'user', '1', NULL, '2024-09-28 07:43:52', '2024-09-28 08:10:43'),
(13, NULL, 'Grace', 'Nath', NULL, 'graceynath@gmail.com', '2024-10-01 19:08:10', '$2y$12$7Tz4pE4I9TZt67MXvyZEFeKIRhv2HCwhsZ/WhdrWCb6xHz.vSiIta', NULL, '8025687214', 'nigeria', 'user', '1', NULL, '2024-10-01 19:07:17', '2024-10-01 19:08:10'),
(14, NULL, 'Phenom', 'Pm', NULL, 'phenomplus@gmail.com', '2024-10-02 13:32:32', '$2y$12$psC2EE9oFLdfIk5XTtWi2.idTXedkNsPtnqsmawGH5eQ1wMh0N5wK', NULL, '08076739334', 'nigeria', 'user', '1', NULL, '2024-10-02 13:31:39', '2024-10-02 13:32:32'),
(15, NULL, 'Phenom', 'Plus', NULL, 'phenomplus1@gmail.com', '2024-10-02 15:59:10', '$2y$12$QL/s0UfzcTU2LyL1rpZKGuoKC1Ou2p/sWhNAWcLrBwCNd6yQptndC', NULL, '08076739334', 'nigeria', 'user', '1', NULL, '2024-10-02 15:57:58', '2024-10-02 15:59:10'),
(16, NULL, 'User4', 'Person', NULL, 'user4@email.com', '2024-10-03 09:11:46', '$2y$12$Hsmid3KpS/AkpIkQozOfluG4m.EioQuhUYPGaVTmKHMGM/OpRA5kK', NULL, '07088693671', 'nigeria', 'user', '1', NULL, '2024-10-03 09:09:51', '2024-10-03 09:11:46'),
(17, NULL, 'user5', 'Person', NULL, 'user5@email.com', '2024-10-03 09:42:51', '$2y$12$fJ.QWg7GhCKRkTeiNi4UJe.Qjkleo6umj4I0tTsRqXdAdLYDap.yK', NULL, '08076739334', 'nigeria', 'user', '1', NULL, '2024-10-03 09:42:24', '2024-10-03 09:42:51'),
(18, NULL, 'Mayowa', 'Olujobi', NULL, 'mayowaolujobi@gmail.com', '2024-10-03 12:37:10', '$2y$12$La5OWn9vMFnkOlKVcGQzKepdCT.CrlqryoA/Z7pViSe7Bxg3syBEi', NULL, '08076739334', 'nigeria', 'user', '1', NULL, '2024-10-03 12:36:44', '2024-10-03 12:37:10');

--
-- Indexes for dumped tables
--

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

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

--
-- Indexes for table `cache`
--
ALTER TABLE `cache`
  ADD PRIMARY KEY (`key`);

--
-- Indexes for table `cache_locks`
--
ALTER TABLE `cache_locks`
  ADD PRIMARY KEY (`key`);

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

--
-- Indexes for table `category_product`
--
ALTER TABLE `category_product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `category_product_category_id_foreign` (`category_id`),
  ADD KEY `category_product_product_id_foreign` (`product_id`);

--
-- Indexes for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `failed_jobs_uuid_unique` (`uuid`);

--
-- Indexes for table `jobs`
--
ALTER TABLE `jobs`
  ADD PRIMARY KEY (`id`),
  ADD KEY `jobs_queue_index` (`queue`);

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

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

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

--
-- Indexes for table `level_product`
--
ALTER TABLE `level_product`
  ADD PRIMARY KEY (`id`),
  ADD KEY `level_product_level_id_foreign` (`level_id`),
  ADD KEY `level_product_product_id_foreign` (`product_id`);

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

--
-- Indexes for table `packages`
--
ALTER TABLE `packages`
  ADD PRIMARY KEY (`id`),
  ADD KEY `packages_level_id_foreign` (`level_id`);

--
-- Indexes for table `password_reset_tokens`
--
ALTER TABLE `password_reset_tokens`
  ADD PRIMARY KEY (`email`);

--
-- Indexes for table `payments`
--
ALTER TABLE `payments`
  ADD PRIMARY KEY (`id`),
  ADD KEY `payments_user_id_foreign` (`user_id`);

--
-- Indexes for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  ADD KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`);

--
-- Indexes for table `products`
--
ALTER TABLE `products`
  ADD PRIMARY KEY (`id`),
  ADD KEY `products_author_id_foreign` (`author_id`),
  ADD KEY `products_vendor_id_foreign` (`vendor_id`),
  ADD KEY `products_language_id_foreign` (`language_id`);

--
-- Indexes for table `sessions`
--
ALTER TABLE `sessions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `sessions_user_id_index` (`user_id`),
  ADD KEY `sessions_last_activity_index` (`last_activity`);

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

--
-- Indexes for table `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD PRIMARY KEY (`id`),
  ADD KEY `subscriptions_user_id_foreign` (`user_id`),
  ADD KEY `subscriptions_payment_id_foreign` (`payment_id`),
  ADD KEY `subscriptions_level_id_foreign` (`level_id`);

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

--
-- Indexes for table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `users_email_unique` (`email`);

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `authors`
--
ALTER TABLE `authors`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

--
-- AUTO_INCREMENT for table `blogs`
--
ALTER TABLE `blogs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

--
-- AUTO_INCREMENT for table `categories`
--
ALTER TABLE `categories`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=16;

--
-- AUTO_INCREMENT for table `category_product`
--
ALTER TABLE `category_product`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=48;

--
-- AUTO_INCREMENT for table `failed_jobs`
--
ALTER TABLE `failed_jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `jobs`
--
ALTER TABLE `jobs`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `languages`
--
ALTER TABLE `languages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT for table `levels`
--
ALTER TABLE `levels`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `level_product`
--
ALTER TABLE `level_product`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=116;

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

--
-- AUTO_INCREMENT for table `packages`
--
ALTER TABLE `packages`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=11;

--
-- AUTO_INCREMENT for table `payments`
--
ALTER TABLE `payments`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT for table `personal_access_tokens`
--
ALTER TABLE `personal_access_tokens`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT for table `products`
--
ALTER TABLE `products`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=37;

--
-- AUTO_INCREMENT for table `sliders`
--
ALTER TABLE `sliders`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=6;

--
-- AUTO_INCREMENT for table `subscriptions`
--
ALTER TABLE `subscriptions`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=18;

--
-- AUTO_INCREMENT for table `testimonials`
--
ALTER TABLE `testimonials`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=7;

--
-- AUTO_INCREMENT for table `users`
--
ALTER TABLE `users`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=19;

--
-- Constraints for dumped tables
--

--
-- Constraints for table `category_product`
--
ALTER TABLE `category_product`
  ADD CONSTRAINT `category_product_category_id_foreign` FOREIGN KEY (`category_id`) REFERENCES `categories` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `category_product_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `level_product`
--
ALTER TABLE `level_product`
  ADD CONSTRAINT `level_product_level_id_foreign` FOREIGN KEY (`level_id`) REFERENCES `levels` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `level_product_product_id_foreign` FOREIGN KEY (`product_id`) REFERENCES `products` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `packages`
--
ALTER TABLE `packages`
  ADD CONSTRAINT `packages_level_id_foreign` FOREIGN KEY (`level_id`) REFERENCES `levels` (`id`);

--
-- Constraints for table `payments`
--
ALTER TABLE `payments`
  ADD CONSTRAINT `payments_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE;

--
-- Constraints for table `products`
--
ALTER TABLE `products`
  ADD CONSTRAINT `products_author_id_foreign` FOREIGN KEY (`author_id`) REFERENCES `authors` (`id`),
  ADD CONSTRAINT `products_language_id_foreign` FOREIGN KEY (`language_id`) REFERENCES `languages` (`id`),
  ADD CONSTRAINT `products_vendor_id_foreign` FOREIGN KEY (`vendor_id`) REFERENCES `users` (`id`);

--
-- Constraints for table `subscriptions`
--
ALTER TABLE `subscriptions`
  ADD CONSTRAINT `subscriptions_level_id_foreign` FOREIGN KEY (`level_id`) REFERENCES `levels` (`id`),
  ADD CONSTRAINT `subscriptions_payment_id_foreign` FOREIGN KEY (`payment_id`) REFERENCES `payments` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `subscriptions_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE SET NULL;
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 */;
