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




--
-- Database: `covenantnet`
--

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

--
-- Table structure for table `comment`
--

CREATE TABLE `comment` (
  `id` int(11) NOT NULL,
  `pageId` int(11) NOT NULL DEFAULT '3',
  `user_id` int(11) NOT NULL,
  `comment` text NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `comment`
--

INSERT INTO `comment` (`id`, `pageId`, `user_id`, `comment`, `created`, `updated`, `deleted`) VALUES
(19, 3, 1, 'Greetings to you in the name of our lord Jesus Christ.', '2021-09-26 07:20:16', '2022-08-28 11:51:01', NULL),
(21, 3, 2, 'Thank you too so much!\nIt’s always an honour to be with you and your wonderful teachings, I pray for good health and protection upon you as you continue to touch many lives.\nGod bless you and your family and ministry.', '2021-11-22 19:06:54', '2022-08-28 11:51:19', NULL),
(22, 3, 3, 'Hi Servant of God,\nPraise the Lord receive greetings from Homa-Bay, Kenya in Jesus name. Grace and peace be multiplied unto you from God our Father and our Lord. I am delighted that I was able to come across your web-page. I count it God’s blessings to be able to see what you are doing for the Kingdom of God It’s blessing. I believe as a pastor God has entrusted to your care the most precious thing in the entire universe his own body, the church. He does not intend you to stop where you are. He has called you, chosen you and singled you out to do a job for him that no one else can do. There has never been another like you since time began. You are unique and different from every other minister God has commissioned.\nMay Heaven smiles upon you. Shalom .\nApostle. Mathews O. Ongere.\nHope Of Salvation Fellowship Ministries,\nP.O.Box 4928-30100, Eldoret , Kenya.', '2022-02-24 05:50:03', '2022-08-28 11:51:43', NULL),
(23, 3, 4, 'Dear brethren in Christ, our hearts is spiritually touched with your encouragement reading from your website kindly please share more with us and help us with your teaching materials for they will help us in our fellowship here and win more souls to Christ Jesus we pray and request you kindly if you have Bibles to send to us that Lord will lead you to come and share the word of God with us we hope that God bless us to share more in his kingdom and pray for the orphans who I TAKE CARE OF AND worship with THEM happy to read from you in Jesus name. . PASTOR ONTIRI KENYA', '2022-03-18 09:46:02', '2022-08-28 11:52:01', NULL),
(28, 3, 11, 'hey test', '2022-08-28 16:08:41', '2022-08-28 16:08:41', NULL);

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

--
-- Table structure for table `commentors`
--

CREATE TABLE `commentors` (
  `id` int(11) NOT NULL,
  `name` varchar(200) NOT NULL,
  `email` varchar(400) NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `commentors`
--

INSERT INTO `commentors` (`id`, `name`, `email`, `created`, `updated`, `deleted`) VALUES
(1, 'Kinnera.Mariyamma', 'test@gmail.com', '2021-09-05 08:27:02', '2022-08-28 11:49:03', NULL),
(2, 'Mike', 'test1@gmail.com', '2021-09-05 15:38:52', '2022-08-28 11:49:06', NULL),
(3, 'Mathew Ongere ', 'test2@gmail.com', '2021-09-05 15:40:29', '2022-08-28 11:49:54', NULL),
(4, 'ontiri', 'test3@gmail.com', '2021-09-08 04:37:55', '2022-08-28 11:50:09', NULL),
(11, 'Test', 'test5@gmail.com', '2022-08-28 15:56:29', '2022-08-28 15:56:29', NULL);

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

--
-- Table structure for table `courses`
--

CREATE TABLE `courses` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `name` varchar(400) NOT NULL,
  `created` datetime NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `deleted` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `courses`
--

INSERT INTO `courses` (`id`, `name`, `created`, `updated`, `deleted`) VALUES
(1, 'Leadership Principles', '2022-03-17 21:13:28', '2022-03-17 20:13:28', NULL),
(2, 'Creative Awareness', '2022-03-17 21:15:01', '2022-03-17 20:15:01', NULL),
(3, 'Bible Studies', '2022-03-18 11:16:57', '2022-03-18 10:16:57', '2022-03-19 08:22:50'),
(4, 'Business Management', '2022-03-18 11:20:13', '2022-03-18 10:20:13', NULL),
(5, 'Course Study', '2022-03-19 10:42:04', '2022-03-19 09:42:04', '2022-03-19 10:42:12'),
(6, 'Advanced Bible Course', '2022-03-19 18:41:01', '2022-03-19 17:41:01', NULL),
(7, 'Foundation Bible Course', '2022-03-19 18:41:18', '2022-03-19 17:41:18', NULL);

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

--
-- Table structure for table `page`
--

CREATE TABLE `page` (
  `id` int(11) NOT NULL,
  `name` varchar(500) NOT NULL,
  `bgImage` varchar(200) NOT NULL,
  `fontSize` float DEFAULT NULL,
  `fontColor` varchar(200) DEFAULT NULL,
  `postPerPage` int(11) NOT NULL DEFAULT '10',
  `comment` varchar(200) NOT NULL DEFAULT 'disabled',
  `tagline` text,
  `heading` varchar(200) DEFAULT NULL,
  `content` longtext,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `page`
--

INSERT INTO `page` (`id`, `name`, `bgImage`, `fontSize`, `fontColor`, `postPerPage`, `comment`, `tagline`, `heading`, `content`, `created`, `updated`, `deleted`) VALUES
(1, 'HOME PAGE', 'life1.jpg', 15, '#137fdd', 10, 'ENABLED', 'Touching Lives - Building People - Impacting Communities', 'LIFE', '<p style=\"box-sizing: border-box; margin: 0px 0px 1.625em; border: 0px; font-family: \'Helvetica Neue\', Helvetica, Arial, sans-serif; font-size: 15px; outline: 0px; padding: 0px; vertical-align: baseline; color: #373737; background-color: #ffffff;\"><strong style=\"box-sizing: border-box; border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">- is all you have, and is the result of the decisions you made before -</strong></p>\n<p style=\"box-sizing: border-box; margin: 0px 0px 1.625em; border: 0px; font-family: \'Helvetica Neue\', Helvetica, Arial, sans-serif; font-size: 15px; outline: 0px; padding: 0px; vertical-align: baseline; color: #373737; background-color: #ffffff;\">Yes, you may have or own&nbsp;lots of things in life, but those things don&rsquo;t make you,<br style=\"box-sizing: border-box;\" />&hellip; in fact most times those things have you and therefore have your life,<br style=\"box-sizing: border-box;\" />&hellip; instead of you having them!</p>\n<p style=\"box-sizing: border-box; margin: 0px 0px 1.625em; border: 0px; font-family: \'Helvetica Neue\', Helvetica, Arial, sans-serif; font-size: 15px; outline: 0px; padding: 0px; vertical-align: baseline; color: #373737; background-color: #ffffff;\">Money, property or things that you have or have worked for,<br style=\"box-sizing: border-box;\" />&hellip; are simply additions to life, and only serve to enrich or detract from life.<br style=\"box-sizing: border-box;\" /><em style=\"box-sizing: border-box;\"><strong style=\"box-sizing: border-box; border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">They can add to life, but they don&rsquo;t bring life.</strong></em></p>\n<p style=\"box-sizing: border-box; margin: 0px 0px 1.625em; border: 0px; font-family: \'Helvetica Neue\', Helvetica, Arial, sans-serif; font-size: 15px; outline: 0px; padding: 0px; vertical-align: baseline; color: #373737; background-color: #ffffff;\">Life is what comes from the inside,<br style=\"box-sizing: border-box;\" />&hellip; is&nbsp;<em style=\"box-sizing: border-box;\">what makes you the YOU that you are.</em></p>\n<p style=\"box-sizing: border-box; margin: 0px 0px 1.625em; border: 0px; font-family: \'Helvetica Neue\', Helvetica, Arial, sans-serif; font-size: 15px; outline: 0px; padding: 0px; vertical-align: baseline; color: #373737; background-color: #ffffff;\"><span style=\"font-family: \'Helvetica Neue\', Helvetica, Arial, sans-serif;\">Life is about living,</span><br style=\"box-sizing: border-box;\" /><span style=\"font-family: \'Helvetica Neue\', Helvetica, Arial, sans-serif;\">&hellip; about interaction,</span>&nbsp; <br style=\"box-sizing: border-box;\" /><span style=\"font-family: \'Helvetica Neue\', Helvetica, Arial, sans-serif;\">&hellip; about relationships.</span><br style=\"box-sizing: border-box;\" /><em style=\"box-sizing: border-box;\"><strong style=\"box-sizing: border-box; border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">LIFE is about people!</strong></em></p>\n<p style=\"box-sizing: border-box; margin: 0px 0px 1.625em; border: 0px; font-family: \'Helvetica Neue\', Helvetica, Arial, sans-serif; font-size: 15px; outline: 0px; padding: 0px; vertical-align: baseline; color: #373737; background-color: #ffffff;\"><em style=\"box-sizing: border-box;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; * * * * * * * * * * * * * * * * * * * * * *</em></p>\n<p style=\"box-sizing: border-box; margin: 0px 0px 1.625em; border: 0px; font-family: \'Helvetica Neue\', Helvetica, Arial, sans-serif; font-size: 15px; outline: 0px; padding: 0px; vertical-align: baseline; color: #373737; background-color: #ffffff;\"><strong>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp;&nbsp; May His presence fill your life,</strong><br style=\"box-sizing: border-box;\" /><strong>&nbsp; &nbsp;&nbsp; &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &hellip; His peace envelop your life,</strong><br style=\"box-sizing: border-box;\" /><strong>&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &hellip; His grace complete your life,</strong><br style=\"box-sizing: border-box;\" /><strong><em style=\"box-sizing: border-box;\"><span style=\"box-sizing: border-box; border: 0px none; font-family: inherit; font-style: inherit; margin: 0px; outline: currentcolor none 0px; padding: 0px; vertical-align: baseline;\">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;</span></em><span style=\"box-sizing: border-box;\"><span style=\"box-sizing: border-box; border: 0px none; font-family: inherit; font-style: inherit; margin: 0px; outline: currentcolor none 0px; padding: 0px; vertical-align: baseline;\"> and His love be your life.</span></span></strong></p>\n<p style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline;\"><a style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; color: #0d4593; text-decoration-line: none;\" href=\"https://beta.halo-technology.co.ke/coaching/jan.jpg\"><img class=\"alignleft wp-image-400 size-medium\" style=\"height: 122px; max-width: 97.5%; border: 1px solid #dddddd; margin-top: 0.4em; display: inline; float: left; margin-right: 1.625em; margin-bottom: 1.625em; padding: 6px;\" src=\"https://api.coaching4life.me/files/others/jan.jpeg\" alt=\"\" width=\"105\" height=\"220\" /></a><span style=\"font-family: \'Helvetica Neue\', Helvetica, Arial, sans-serif;\"><strong style=\"box-sizing: border-box; border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">papajan</strong></span></p>\n<p style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline;\"><br style=\"box-sizing: border-box;\" />Jan D vanderMerwe<br style=\"box-sizing: border-box;\" />Life Coach &amp; Teacher&nbsp; </p>', '2021-08-21 00:00:00', '2022-07-27 11:56:16', NULL),
(2, 'BLOG PAGE', 'bg-blog.jpg', 15, '#137fdd', 7, 'DISABLED', NULL, NULL, NULL, '2021-08-21 14:45:56', '2022-08-28 10:51:58', NULL),
(3, 'ABOUT PAGE', 'coaching.jpg', NULL, NULL, 10, 'ENABLED', NULL, NULL, NULL, '2021-08-21 14:51:07', '2022-08-28 16:19:59', NULL),
(4, 'Magazine', 'study.png', NULL, NULL, 10, 'DISABLED', NULL, NULL, NULL, '2022-03-02 08:19:23', '2022-08-28 16:20:54', NULL),
(5, 'People', 'bible study.jpg', NULL, NULL, 10, 'DISABLED', NULL, NULL, NULL, '2022-03-02 08:20:08', '2022-08-28 16:20:57', NULL),
(6, 'Projects', 'leader.jpg', NULL, NULL, 10, 'DISABLED', NULL, NULL, NULL, '2022-03-02 08:20:28', '2022-08-28 16:20:43', NULL),
(7, 'Testimonies', 'business.jpg', NULL, NULL, 10, 'DISABLED', NULL, NULL, NULL, '2022-03-02 08:20:48', '2022-08-28 16:20:46', NULL),
(8, 'Training Centres', 'create.png', NULL, NULL, 10, 'DISABLED', NULL, NULL, NULL, '2022-03-02 08:21:06', '2022-08-28 16:20:35', NULL),
(9, 'Ministries & Projects', 'register.jpg', NULL, NULL, 10, 'DISABLED', NULL, NULL, NULL, '2022-03-02 08:21:22', '2022-08-28 16:17:13', NULL),
(10, 'Resources', 'resources.jpg', NULL, NULL, 10, 'DISABLED', 'Touching Lives – Building People – Impacting Communities', 'Resources / Downloads', '<article id=\"post-1642\" class=\"post-1642 page type-page status-publish hentry\" style=\"border-bottom: none; margin: 0px 0px 1.625em; padding: 3.5em 0px 0px; position: relative; color: #373737; font-family: \'Helvetica Neue\', Helvetica, Arial, sans-serif; font-size: 15px; background-color: #ffffff;\">\n<div class=\"entry-content\" style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px auto; outline: 0px; padding: 1.625em 0px 0px; vertical-align: baseline; width: 584.266px;\">\n<p style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline; overflow-wrap: break-word;\"><a style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; color: #0d4593; text-decoration-line: none;\" href=\"../unique\" target=\"_blank\" rel=\"noopener\"><img class=\"alignleft alt=\" style=\"height: auto; max-width: 97.5%; border: 1px solid #dddddd; margin-top: 0.4em; display: inline; float: left; margin-right: 1.625em; margin-bottom: 1.625em; padding: 6px;\" src=\"https://api.beta.halo-technology.co.ke/files/others/unique-s.jpeg\" width=\"180\" /></a></p>\n<p style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline; overflow-wrap: break-word;\"><big style=\"border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">Study of a UNIQUE BEING</strong></big><strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><br />&ndash; The origin of life &ndash;</strong><br /><small style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">Look around &ndash; where did all of this come from?</strong><br />Not so long ago there were no built structures<br /><em>&ndash; no organized environment or developed infra-structure.</em><br />&nbsp; &nbsp; Yes, there were natural climatic cycles and seasons,<br />&nbsp; &nbsp; Yes, there were living creatures that reproduced,<br />&nbsp; &nbsp;&nbsp;<strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">But, there was NO development and NO progress<br />&ndash; UNTIL &ndash;</strong><br />Something started to changed &amp; mightily impact this earth,<br /><strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><strong>Whobody was that?</strong></strong></small></p>\n<h5 style=\"border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; clear: both; overflow-wrap: break-word;\"><a style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; color: #0d4593; text-decoration-line: none;\" href=\"https://api.coaching4life.me/files/others/unikebook.pdf\"><strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">Study of a UNIQUE BEING &nbsp; &nbsp; &ndash;&nbsp;<em><small style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">free download</small></em></strong></a></h5>\n<p style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline; overflow-wrap: break-word;\">&nbsp;</p>\n<p style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline; overflow-wrap: break-word;\"><a style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; color: #0d4593; text-decoration-line: none;\" href=\"../creation/\" target=\"_blank\" rel=\"noopener\"><img class=\"alignleft alt=\" style=\"height: auto; max-width: 97.5%; border: 1px solid #dddddd; margin-top: 0.4em; display: inline; float: left; margin-right: 1.625em; margin-bottom: 1.625em; padding: 6px;\" src=\"https://api.beta.halo-technology.co.ke/files/others/creation-tp-s.jpeg\" width=\"180\" /></a></p>\n<p style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline; overflow-wrap: break-word;\"><big style=\"border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">God, His man, CREATION and the REST!</strong></big><br /><small style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">Know God&rsquo;s&nbsp;<strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><strong>FULL PLAN</strong></strong><strong>&nbsp;&amp;&nbsp;<strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">PURPOSE</strong>&nbsp;in&nbsp;<strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">CREATION!</strong></strong></small></p>\n<small style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><strong>Why did God create you?</strong></small>\n<p style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline; overflow-wrap: break-word;\"><small style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><strong>A Perfect World!</strong></strong></small></p>\n<h5 style=\"border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; clear: both; overflow-wrap: break-word;\"><a style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; color: #0d4593; text-decoration-line: none;\" href=\"https://api.coaching4life.me/files/others/kreatebook.pdf\"><strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">God, His man, CREATION and the REST! &nbsp; &nbsp; &ndash;&nbsp;<em><small style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">free download</small></em></strong></a></h5>\n<p style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline; overflow-wrap: break-word;\">&nbsp;</p>\n<p style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline; overflow-wrap: break-word;\"><a style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; color: #0d4593; text-decoration-line: none;\" href=\"../end-times/\" target=\"_blank\" rel=\"noopener\"><img class=\"alignleft alt=\" style=\"height: auto; max-width: 97.5%; border: 1px solid #dddddd; margin-top: 0.4em; display: inline; float: left; margin-right: 1.625em; margin-bottom: 1.625em; padding: 6px;\" src=\"https://api.beta.halo-technology.co.ke/files/others/end-times-s.jpeg\" width=\"180\" /></a></p>\n<p style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline; overflow-wrap: break-word;\"><big style=\"border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><strong>The Times of the End Times</strong></strong></big><br /><small style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">Why you absolutely need to read this book!</strong></small></p>\n<p style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline; overflow-wrap: break-word;\">An insight into&hellip;<br />&hellip;&nbsp;<strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><strong>the Book of Revelation!</strong></strong></p>\n<p style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline; overflow-wrap: break-word;\">&nbsp; &nbsp;&nbsp;<em>What is the Tribulation?<br />&nbsp; &nbsp; Who is the Antichrist?<br />&nbsp; &nbsp; How will it affect the Church?<br />&nbsp; &nbsp; Is there hope for the future?</em></p>\n<p style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline; overflow-wrap: break-word;\"><small style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><strong>How will it all End?</strong></strong></small></p>\n<h5 style=\"border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; clear: both; overflow-wrap: break-word;\"><a style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; color: #0d4593; text-decoration-line: none;\" href=\"https://api.coaching4life.me/files/others/etimebook.pdf\"><strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">The Times of the End Times &nbsp; &nbsp; &ndash;&nbsp;<em><small style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">free download</small></em></strong></a></h5>\n<p style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline; overflow-wrap: break-word;\">&nbsp;</p>\n<p style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline; overflow-wrap: break-word;\"><a style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; color: #0d4593; text-decoration-line: none;\" href=\"../daily-nuggets/\" target=\"_blank\" rel=\"noopener\"><img class=\"alignleft alt=\" style=\"height: auto; max-width: 97.5%; border: 1px solid #dddddd; margin-top: 0.4em; display: inline; float: left; margin-right: 1.625em; margin-bottom: 1.625em; padding: 6px;\" src=\"https://api.beta.halo-technology.co.ke/files/others/nuggets-s.jpeg\" width=\"180\" /></a></p>\n<p style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline; overflow-wrap: break-word;\"><big style=\"border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><strong>Daily Nuggets&nbsp;</strong></strong></big><strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><em>&ndash; from God&rsquo;s Word</em></strong><br /><small style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><strong>Why this book will completely<br />&hellip; change your life!</strong></strong></small></p>\n<p style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline; overflow-wrap: break-word;\">&nbsp; &nbsp;&nbsp;<em><strong>Overcome lifes challenges</strong><br />&nbsp; &nbsp; in a real, personal relationship<br />&nbsp; &nbsp; in Covenant with &hellip;<br />&nbsp; &nbsp; God, Jesus and the Holy Spirit!</em></p>\n<p style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px 0px 1.625em; outline: 0px; padding: 0px; vertical-align: baseline; overflow-wrap: break-word;\"><small style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\"><strong>Daily Nuggets &ndash; to a victorious day!</strong></strong></small></p>\n<h5 style=\"border: 0px; font-family: inherit; font-size: 15px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; clear: both; overflow-wrap: break-word;\"><a style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; color: #0d4593; text-decoration-line: none;\" href=\"https://api.coaching4life.me/files/others/nugebook.pdf\"><strong style=\"border: 0px; font-family: inherit; font-style: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">Daily Nuggets &nbsp; &nbsp; &ndash;&nbsp;<em><small style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline;\">free download</small></em></strong></a></h5>\n<center>\n<div class=\"addtoany_share_save_container addtoany_content addtoany_content_bottom\" style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 16px auto; outline: 0px; padding: 0px; vertical-align: baseline; clear: both;\">\n<div class=\"a2a_kit a2a_kit_size_32 addtoany_list\" style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; display: inline; line-height: 32px; touch-action: manipulation;\" data-a2a-url=\"https://coaching4life.me/?page_id=1642\" data-a2a-title=\"Resources / Downloads\"><a class=\"a2a_button_facebook\" style=\"border: 0px; font-family: inherit; font-size: 32px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px 4px; vertical-align: middle; color: #0d4593; text-decoration-line: none; box-shadow: none; display: inline-block; cursor: pointer;\" title=\"Facebook\" href=\"https://coaching4life.me/#facebook\" target=\"_blank\" rel=\"nofollow noopener\"><span class=\"a2a_label\" style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; clip-path: polygon(0px 0px, 0px 0px, 0px 0px); overflow: hidden; height: 32px; width: 32px; display: inline-block; float: none; border-radius: 4px; opacity: 1; line-height: 32px; position: absolute !important;\">Facebook</span></a><a class=\"a2a_button_twitter\" style=\"border: 0px; font-family: inherit; font-size: 32px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px 4px; vertical-align: middle; color: #0d4593; text-decoration-line: none; box-shadow: none; display: inline-block; cursor: pointer;\" title=\"Twitter\" href=\"https://coaching4life.me/#twitter\" target=\"_blank\" rel=\"nofollow noopener\"><span class=\"a2a_label\" style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; clip-path: polygon(0px 0px, 0px 0px, 0px 0px); overflow: hidden; height: 32px; width: 32px; display: inline-block; float: none; border-radius: 4px; opacity: 1; line-height: 32px; position: absolute !important;\">Twitter</span></a><a class=\"a2a_button_linkedin\" style=\"border: 0px; font-family: inherit; font-size: 32px; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px 4px; vertical-align: middle; color: #0d4593; text-decoration-line: none; box-shadow: none; display: inline-block; cursor: pointer;\" title=\"LinkedIn\" href=\"https://coaching4life.me/#linkedin\" target=\"_blank\" rel=\"nofollow noopener\"><span class=\"a2a_label\" style=\"border: 0px; font-family: inherit; font-style: inherit; font-weight: inherit; margin: 0px; outline: 0px; padding: 0px; vertical-align: baseline; clip-path: polygon(0px 0px, 0px 0px, 0px 0px); overflow: hidden; height: 32px; width: 32px; display: inline-block; float: none; border-radius: 4px; opacity: 1; line-height: 32px; position: absolute !important;\">Linke</span></a></div>\n</div>\n</center></div>\n</article>', '2022-03-02 08:21:47', '2022-05-21 15:21:38', NULL),
(11, 'Mailing List', 'mailing.jpg', NULL, NULL, 10, 'disabled', NULL, NULL, NULL, '2022-03-23 14:48:55', '2022-03-25 12:29:39', NULL),
(12, 'Donation', 'helping.png', NULL, NULL, 10, 'disabled', NULL, NULL, NULL, '2022-03-23 14:49:09', '2022-03-26 11:51:16', NULL);

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

--
-- Table structure for table `post`
--

CREATE TABLE `post` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `pageId` int(11) NOT NULL,
  `heading` text NOT NULL,
  `image` varchar(500) DEFAULT NULL,
  `text` text,
  `fontSize` float DEFAULT NULL,
  `fontColor` varchar(200) DEFAULT NULL,
  `createdBy` int(11) NOT NULL,
  `status` int(11) NOT NULL DEFAULT '1',
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `post`
--

INSERT INTO `post` (`id`, `pageId`, `heading`, `image`, `text`, `fontSize`, `fontColor`, `createdBy`, `status`, `created`, `updated`, `deleted`) VALUES
(19, 3, 'character of an awesome GOD', '1-awesomegod.jpg', '', 50, NULL, 8, 1, '2021-03-22 20:33:00', '2021-09-26 18:33:37', NULL),
(20, 3, 'hopeful not hopeless', '2-hopeful.jpg', '', 50, NULL, 8, 1, '2021-03-26 20:34:00', '2021-09-26 18:34:12', NULL),
(21, 3, 'don\'t panic', '01a-dontpanic.jpg', '', 50, NULL, 8, 1, '2021-03-29 20:34:00', '2021-09-26 18:34:47', NULL),
(22, 3, 'Son of God', '3-songod.jpg', '', 50, NULL, 8, 1, '2021-04-01 20:34:00', '2021-09-26 18:35:07', NULL),
(23, 3, 'in the center of LOVE', '4-centerlove.jpg', '', 50, NULL, 8, 1, '2021-04-05 20:35:00', '2021-09-26 18:35:33', NULL),
(24, 3, 'denial of reality', '5-denialreality.jpg', '', 50, NULL, 8, 1, '2021-04-08 20:36:00', '2021-09-26 18:36:21', NULL),
(45, 1, 'started small', '1 started small.jpg', '', 50, NULL, 8, 1, '2021-08-30 17:15:00', '2022-03-25 17:05:15', '2022-03-25 17:05:15'),
(60, 2, 'make it personal', 'p5-personalfaith.jpg', '', 50, 'null', 8, 1, '2021-09-23 11:19:00', '2022-03-26 08:49:28', '2022-03-26 08:49:28'),
(61, 2, 'knowing him personally', 'p6-personalname.jpg', '', 50, '', 8, 1, '2021-09-22 11:19:00', '2022-03-26 08:49:33', '2022-03-26 08:49:33'),
(62, 2, 'draw close', 'p7-drawclose.jpg', '', 50, '', 8, 1, '2021-09-21 11:20:00', '2022-03-26 08:49:48', '2022-03-26 08:49:48'),
(63, 2, 'get personal', 'p8-fastprayer.jpg', '', 50, '', 8, 1, '2021-09-20 09:19:00', '2022-03-26 08:50:17', '2022-03-26 08:50:17'),
(64, 3, 'in favor & grace', '6-livingfavor.jpg', '', 50, '', 8, 1, '2021-04-12 20:36:00', '2021-09-26 18:36:40', NULL),
(65, 3, 'hack attack', '7-hackattack.jpg', '', 50, '', 8, 1, '2021-04-19 20:37:00', '2021-09-26 18:37:33', NULL),
(66, 3, 'God\'s kingdom is', '8-kingdomis.jpg', '', 50, '', 8, 1, '2021-04-26 20:37:00', '2021-09-26 18:38:10', NULL),
(67, 3, 'the victory is ours', '9-battlelords.jpg', '', 50, '', 8, 1, '2021-04-30 20:39:00', '2021-09-26 18:40:06', NULL),
(68, 3, 'to love God', '10-gettolove.jpg', '', 50, '', 8, 1, '2021-05-03 20:40:00', '2021-09-26 18:41:03', NULL),
(69, 3, 'self value', '11-selfvalue.jpg', '', 50, '', 8, 1, '2021-05-07 20:41:00', '2021-09-26 18:41:48', NULL),
(70, 3, 'fake news', '12-fakenews.jpg', '', 50, '', 8, 1, '2021-05-08 20:42:00', '2021-09-26 18:43:22', NULL),
(71, 3, 'without conditions', '13-noconditions.jpg', '', 50, '', 8, 1, '2021-05-10 20:44:00', '2021-09-26 18:44:58', NULL),
(74, 2, 'if it\'s not personal', 'p1-ifnotpersonal.jpg', '', 50, '', 8, 1, '2021-08-20 20:13:00', '2022-03-26 08:50:38', '2022-03-26 08:50:38'),
(75, 2, 'it began very personal', 'p2-personalbegining.jpg', '', 50, '', 8, 1, '2021-09-26 11:13:00', '2022-03-26 08:46:35', '2022-03-26 08:46:35'),
(76, 2, 'not personal anymore', 'p3-moses.jpg', '', 50, '', 8, 1, '2021-09-25 11:15:00', '2022-03-26 08:48:24', '2022-03-26 08:48:24'),
(77, 2, 'personally with him', 'p4-fishermen.jpg', '', 50, '', 8, 1, '2021-09-24 11:16:00', '2022-03-26 08:49:19', '2022-03-26 08:49:19'),
(78, 3, 'what you see', '14-whatsee.jpg', '', 50, '', 8, 1, '2021-05-12 11:42:00', '2021-09-27 09:43:06', NULL),
(81, 3, 'leave no place', '15-noplaceforsin.jpg', '', 47, '', 8, 1, '2021-05-17 10:10:28', '2021-10-01 10:15:10', NULL),
(82, 3, 'in Him - i am', '16-inhiminlove.jpg', '', 50, '', 8, 1, '2021-05-21 12:16:00', '2021-10-01 10:16:51', NULL),
(83, 3, 'is God - God?', '17-isgodyourgod.jpg', '', 50, '', 8, 1, '2021-05-24 12:17:00', '2021-10-01 10:18:34', NULL),
(84, 3, 'stop looking for...', '18-startlook.jpg', '', 50, '', 8, 1, '2021-05-31 12:19:00', '2021-10-01 10:19:25', NULL),
(85, 3, '- to judge or not -', '19-judge.jpg', '', 50, '', 8, 1, '2021-06-07 12:20:00', '2021-10-01 10:22:15', NULL),
(86, 3, 'i was not there', '20-iwasnotthere.jpg', '', 50, '', 8, 1, '2021-06-14 13:01:00', '2021-10-01 11:01:53', NULL),
(87, 3, 'and the greatest is', '21-thegreatestis.jpg', '', 50, '', 8, 1, '2021-06-18 13:04:00', '2021-10-01 11:04:48', NULL),
(88, 3, 'disappointed', '22-disappointed.jpg', '', 50, '', 8, 1, '2021-06-22 13:06:00', '2021-10-01 11:07:14', NULL),
(89, 3, 'God gives you a choice', '23-yourchoice.jpg', '', 50, '', 8, 1, '2021-06-28 13:08:00', '2021-10-01 11:08:28', NULL),
(90, 3, 'the love of art', '24-artoflove.jpg', '', 50, '', 8, 1, '2021-07-02 13:08:00', '2021-10-01 11:09:23', NULL),
(91, 3, 'what about', '25-seeyourselfable.jpg', '', 50, '', 8, 1, '2021-07-05 13:09:00', '2021-10-01 11:10:17', NULL),
(92, 3, 'what happened', '26-whathappened.jpg', '', 50, '', 8, 1, '2021-07-12 13:10:00', '2021-10-01 11:11:07', NULL),
(93, 3, 'the unseen world', '27-unseenworld.jpg', '', 50, '', 8, 1, '2021-07-15 13:14:00', '2021-10-01 11:15:08', NULL),
(94, 3, 'time to reboot', '28-upgrade.jpg', '', 50, '', 8, 1, '2021-07-16 13:15:00', '2021-10-01 11:16:23', NULL),
(95, 3, 'a new world', '29-wholenew.jpg', '', 50, '', 8, 1, '2021-07-16 13:20:00', '2021-10-01 11:21:05', NULL),
(96, 3, 'perfected in love', '30-perfectedlove.jpg', '', 50, '', 8, 1, '2021-07-17 13:21:00', '2021-10-01 11:21:45', NULL),
(97, 3, 'I am the way', '31-iamtheway.jpg', '', 50, '', 8, 1, '2021-07-18 13:22:00', '2021-10-01 11:23:27', NULL),
(98, 3, 'religion', '32-religionvoice.jpg', '', 50, '', 8, 1, '2021-07-21 13:24:00', '2021-10-01 11:25:43', NULL),
(99, 3, 'love covers', '33-loveheals.jpg', '', 50, '', 8, 1, '2021-07-23 16:49:00', '2021-10-02 14:50:29', NULL),
(100, 3, 'the truth', '34-truthfree.jpg', '', 50, '', 8, 1, '2021-07-30 16:50:00', '2021-10-02 14:52:56', NULL),
(101, 3, 'the secret', '35-secrettolearning.jpg', '', 50, '', 8, 1, '2021-07-31 16:53:00', '2021-10-02 14:53:45', NULL),
(102, 3, 'prosperity', '36-prosperity.jpg', '', 50, '', 8, 1, '2021-08-10 17:02:00', '2021-10-02 15:02:56', NULL),
(103, 3, 'He is still', '37-godis.jpg', '', 50, '', 8, 1, '2021-08-16 17:03:00', '2021-10-02 15:04:03', NULL),
(104, 3, 'believing - is seeing', '38-believing.jpg', '', 50, '', 8, 1, '2021-08-18 10:00:00', '2021-11-27 09:00:50', NULL),
(105, 2, 'it became personal', 'p9-jesusloved.jpg', '', 50, '', 8, 1, '2021-09-19 12:59:00', '2022-03-26 08:48:44', '2022-03-26 08:48:44'),
(106, 2, 'make it happen', 'p10-makehappen.jpg', '', 50, 'null', 8, 1, '2021-09-18 09:58:00', '2022-03-26 08:50:22', '2022-03-26 08:50:22'),
(107, 3, 'agreeing with', '39-negative.jpg', '', 50, '', 8, 1, '2021-08-30 10:01:00', '2021-11-27 09:02:06', NULL),
(108, 3, 'what you think', '40-whatthink.jpg', '', 50, '', 8, 1, '2021-09-03 10:02:00', '2021-11-27 09:03:39', NULL),
(109, 3, 'does God have', '41-favorites.jpg', '', 50, '', 8, 1, '2021-09-09 10:56:00', '2021-11-27 09:56:22', NULL),
(110, 3, 'living in faith', '42-faithlove.jpg', '', 50, '', 8, 1, '2021-09-13 10:56:00', '2021-11-27 09:57:10', NULL),
(119, 3, 'no explanation', '43-justify.jpg', '', 50, '', 8, 1, '2021-09-20 19:26:00', '2021-11-27 18:28:37', NULL),
(120, 3, 'make it happen', '44-makeithappen.jpg', '', 50, '', 8, 1, '2021-09-25 20:51:00', '2021-11-27 19:52:11', NULL),
(121, 3, 'do you believe', '45-doyoubelieve.jpg', '', 50, '', 8, 1, '2021-10-15 20:55:00', '2021-11-27 19:55:56', NULL),
(122, 3, 'is your system under attack', '46-underattack.jpg', '', 50, '', 8, 1, '2021-10-28 20:56:00', '2021-11-27 19:57:16', NULL),
(123, 3, 'that fearful tree', '47-fear.jpg', '', 50, '', 8, 1, '2021-11-01 20:57:00', '2021-11-27 20:04:55', NULL),
(124, 2, 'if the anointing is not personal', 'p11-anointed.jpg', '', 50, '', 8, 1, '2021-09-17 11:37:00', '2022-03-26 08:50:27', '2022-03-26 08:50:27'),
(125, 3, 'dominate', '48-dominate.jpg', '', 50, '', 8, 1, '2021-12-04 21:32:00', '2021-12-13 20:33:39', NULL),
(126, 3, 'life is', '49-lifechoices.jpg', '', 50, '', 8, 1, '2021-12-12 21:34:00', '2021-12-13 20:34:54', NULL),
(127, 3, '- time -', '50-timeternity.jpg', '', 50, '', 8, 1, '2021-12-17 20:24:00', '2021-12-20 19:25:06', NULL),
(128, 2, 'draw near to Him', 'p25-drawnear.jpg', '', 50, '', 8, 1, '2021-09-01 21:27:00', '2022-03-26 08:50:33', '2022-03-26 08:50:33'),
(129, 3, 'God\'s will ...', '51-whodecides.jpg', '', 50, '', 8, 1, '2022-01-07 10:00:00', '2022-01-10 09:00:15', NULL),
(132, 3, 'believing', '52-believingfaith.jpg', '', 50, '', 8, 1, '2022-01-14 17:47:00', '2022-01-17 16:47:22', NULL),
(134, 3, 'we make pictures', '53-makingpictures.jpg', '', 50, '', 8, 1, '2022-01-27 22:17:00', '2022-01-31 21:16:54', NULL),
(135, 3, 'beware of', '54-trojan.jpg', '', 50, '', 8, 1, '2022-01-31 22:19:00', '2022-01-31 21:18:19', NULL),
(136, 3, 'get ready', '55-heavenlyfeast.jpg', '', 50, '', 8, 1, '2022-02-07 10:41:00', '2022-02-07 09:41:36', NULL),
(137, 1, 'no losers', '56-nolosers.jpg', '', 50, '', 8, 1, '2022-02-12 10:10:00', '2022-02-12 09:09:44', NULL),
(138, 3, 'no losers', '56-nolosers.jpg', '', 50, '', 8, 1, '2022-02-12 10:13:00', '2022-02-12 09:12:12', NULL),
(139, 1, 'does God have favourites', '2206-41-favorites.jpg', '', 50, '', 7, 1, '2022-03-22 00:00:00', '2022-03-22 10:09:06', NULL),
(140, 1, 'test', '274154549_323536089819609_7389396433772817044_n.jpeg', '', 19, '', 7, 1, '2022-03-22 17:46:00', '2022-03-23 08:52:12', '2022-03-23 08:52:12'),
(141, 1, 'test', '274154549_323536089819609_7389396433772817044_n.jpeg', '', 19, '', 7, 1, '2022-03-23 11:00:00', '2022-03-23 09:03:25', '2022-03-23 09:03:25'),
(142, 1, 'test', '274154549_323536089819609_7389396433772817044_n.jpeg', '', 19, '', 7, 1, '2022-03-23 11:00:00', '2022-03-23 09:06:43', '2022-03-23 09:06:43'),
(143, 2, 'does God have favourites', '2206-41-favorites.jpg', '', 50, '', 7, 1, '2022-03-23 00:00:00', '2022-03-26 08:53:10', NULL),
(144, 2, 'are you following', '2204-85-control.jpg', '', 50, '', 7, 1, '2022-02-16 00:00:00', '2022-03-26 16:19:14', NULL),
(145, 2, 'recognizing your value', '2207-64-selfvalue.jpg', '', 50, '', 7, 1, '2022-03-29 00:00:00', '2022-03-29 09:22:42', NULL),
(146, 2, '- are you -', '2205-00-tempted.jpg', '', 50, '', 7, 1, '2022-03-04 00:00:00', '2022-03-29 09:25:19', NULL),
(147, 2, 'is seeing believing?', '2201-38-seeing.jpg', '', 50, '', 8, 1, '2022-01-04 00:00:00', '2022-04-15 20:22:24', NULL),
(148, 2, 'secret to learning', '2202-35-secret.jpg', '', 50, '', 8, 1, '2022-01-19 00:00:00', '2022-04-15 20:24:18', NULL),
(149, 2, 'Disappointed in yourself?', '2203-22-disappointed.jpg', '', 50, '', 8, 1, '2022-02-01 00:00:00', '2022-04-15 20:25:53', NULL),
(150, 2, 'no explanation', '2208-03-justification.jpg', '', 50, '', 8, 1, '2022-04-15 00:00:00', '2022-04-15 21:05:57', NULL),
(151, 2, 'that is love', '2209-88-thatslove.jpg', '', 50, '', 8, 1, '2022-05-04 21:13:37', '2022-04-30 09:41:49', NULL),
(152, 2, 'He does not change', '2210-97-change.jpg', '', 50, '', 8, 1, '2022-05-18 09:52:37', '2022-04-30 09:56:14', NULL),
(153, 2, 'That fearful tree...', '2211-47-thattree.jpg', '', 50, '', 8, 1, '2022-06-01 00:00:00', '2022-05-10 15:08:41', NULL),
(154, 2, 'make your words count', '2212-73-mean.jpg', '', 50, '', 8, 1, '2022-06-15 00:00:00', '2022-05-10 15:11:12', NULL),
(155, 2, 'opportunities or obstacles', '2213-95-opportunities.jpg', '', 50, '', 8, 1, '2022-06-29 00:00:00', '2022-06-26 17:19:32', NULL),
(156, 2, 'tongue tied', '2214-99-tonguetied.jpg', '', 50, '', 8, 1, '2022-07-13 17:25:55', '2022-07-01 20:17:13', NULL),
(157, 2, 'Test post', 'astonvillavsliverpool.jpg', '', 12, '', 7, 0, '2022-07-03 16:38:10', '2022-07-03 16:38:50', '2022-07-03 16:38:50'),
(158, 2, 'it is valuable', '2215-91-valuable.jpg', '', 50, '', 8, 1, '2022-07-25 00:00:00', '2022-07-25 20:20:10', NULL),
(159, 2, '- be who you are -', '2216-p29-responsible.jpg', '', 50, '', 8, 1, '2022-08-07 00:00:00', '2022-08-07 09:19:07', NULL),
(160, 2, 'a heavenly feast', '2217-55-feast.jpg', '', 50, '', 8, 1, '2022-08-08 00:00:00', '2022-08-07 09:26:05', NULL);

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

--
-- Table structure for table `registration`
--

CREATE TABLE `registration` (
  `id` bigint(20) UNSIGNED NOT NULL,
  `firstName` varchar(200) NOT NULL,
  `lastName` varchar(200) NOT NULL,
  `email` varchar(400) NOT NULL,
  `msisdn` bigint(20) NOT NULL,
  `courseId` bigint(20) UNSIGNED NOT NULL,
  `created` datetime NOT NULL,
  `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Dumping data for table `registration`
--

INSERT INTO `registration` (`id`, `firstName`, `lastName`, `email`, `msisdn`, `courseId`, `created`, `updated`, `deleted`) VALUES
(1, 'John', 'Doe', 'mudenhojunior2@gmail.com', 254715583438, 1, '2022-03-18 09:27:15', '2022-03-18 08:27:15', NULL);

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

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

CREATE TABLE `slider` (
  `id` int(11) NOT NULL,
  `title` varchar(400) NOT NULL,
  `tagline` varchar(400) NOT NULL,
  `image` varchar(400) NOT NULL,
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `deleted` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

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

INSERT INTO `slider` (`id`, `title`, `tagline`, `image`, `created`, `updated`, `deleted`) VALUES
(1, 'Welcome to Covenant Ministries', 'Touching Lives - Building People - Impacting Communities', 'title1.png', '2022-08-28 00:00:00', '2022-08-28 10:06:17', NULL),
(2, 'Ready to begin your journey?', 'Feel free to look around', 'Zurich-1c.png', '2022-08-28 00:00:00', '2022-08-28 10:06:17', NULL);

--
-- Indexes for dumped tables
--

--
-- Indexes for table `comment`
--
ALTER TABLE `comment`
  ADD PRIMARY KEY (`id`),
  ADD KEY `pageId` (`pageId`,`user_id`,`created`,`deleted`);

--
-- Indexes for table `commentors`
--
ALTER TABLE `commentors`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `email` (`email`),
  ADD KEY `pageId` (`name`,`email`,`created`,`deleted`);

--
-- Indexes for table `courses`
--
ALTER TABLE `courses`
  ADD PRIMARY KEY (`id`),
  ADD KEY `name` (`name`);

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

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

--
-- Indexes for table `registration`
--
ALTER TABLE `registration`
  ADD PRIMARY KEY (`id`),
  ADD KEY `courseId` (`courseId`),
  ADD KEY `firstName` (`firstName`),
  ADD KEY `lastName` (`lastName`),
  ADD KEY `email` (`email`),
  ADD KEY `msisdn` (`msisdn`),
  ADD KEY `created` (`created`);

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

--
-- AUTO_INCREMENT for dumped tables
--

--
-- AUTO_INCREMENT for table `comment`
--
ALTER TABLE `comment`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;
--
-- AUTO_INCREMENT for table `commentors`
--
ALTER TABLE `commentors`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=12;
--
-- AUTO_INCREMENT for table `courses`
--
ALTER TABLE `courses`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT for table `page`
--
ALTER TABLE `page`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=17;
--
-- AUTO_INCREMENT for table `post`
--
ALTER TABLE `post`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=161;
--
-- AUTO_INCREMENT for table `registration`
--
ALTER TABLE `registration`
  MODIFY `id` bigint(20) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
--
-- AUTO_INCREMENT for table `slider`
--
ALTER TABLE `slider`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
--
-- Constraints for dumped tables
--

--
-- Constraints for table `registration`
--
ALTER TABLE `registration`
  ADD CONSTRAINT `registration_ibfk_1` FOREIGN KEY (`courseId`) REFERENCES `courses` (`id`);

