--
-- Host: localhost    Database: iampapajan
-- ------------------------------------------------------


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

CREATE TABLE `comment` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int 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,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;

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

INSERT INTO `comment` VALUES (19,3,'hi','2021-09-26 07:20:16','2021-09-26 07:20:16',NULL),(21,7,'So wonderful receiving such good news from you','2021-11-22 19:06:54','2021-11-22 19:06:54',NULL),(22,8,'I want to do the business course','2022-02-24 05:50:03','2022-02-24 05:50:03',NULL);

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

CREATE TABLE `commentors` (
  `id` int NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;

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

INSERT INTO `commentors` VALUES (1,'hello','test@gmail.com','2021-09-05 08:27:02','2021-09-05 08:27:02',NULL),(2,'jan','papajan@covenantnet.com','2021-09-05 15:38:52','2021-09-05 15:38:52',NULL),(3,'jan','mail@covenantnet.com','2021-09-05 15:40:29','2021-09-05 15:40:29',NULL),(4,'Haggai Asega','mudenhojunior2@gmail.com','2021-09-08 04:37:55','2021-09-08 04:37:55',NULL),(5,'haggai asega','mudenho@gmail.com','2021-09-08 05:23:22','2021-09-08 05:23:22',NULL),(6,'jack','coach@coaching4life.me','2021-09-08 07:22:29','2021-09-08 07:22:29',NULL),(7,'Zadock Wekesa Juma','jumazadock123@gmail.com','2021-11-22 19:06:52','2021-11-22 19:06:52',NULL),(8,'Jan','covjan@gmail.com','2022-02-24 05:50:03','2022-02-24 05:50:03',NULL);

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

CREATE TABLE `page` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(500) NOT NULL,
  `bgImage` varchar(200) NOT NULL,
  `fontSize` float DEFAULT NULL,
  `fontColor` varchar(200) DEFAULT NULL,
  `postPerPage` int NOT NULL DEFAULT '10',
  `comment` varchar(200) NOT NULL DEFAULT 'disabled',
  `created` datetime NOT NULL,
  `updated` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;

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

INSERT INTO `page` VALUES (1,'HOME PAGE','bg-iam-iampapajan.jpg',15,'#137fdd',10,'ENABLED','2021-08-21 00:00:00','2021-09-18 11:24:43'),(2,'IT IS PERSONAL','bg-iam-personal.jpg',15,'#137fdd',10,'DISABLED','2021-08-21 14:45:56','2021-09-18 11:51:42'),(3,'FROM MY HEART','bg-iam-heart.jpg',15,'#137fdd',10,'DISABLED','2021-08-21 14:51:07','2021-09-26 18:28:12');

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

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

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

INSERT INTO `post` 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'),(20,3,'hopeful not hopeless','2-hopeful.jpg','',50,NULL,8,1,'2021-03-26 20:34:00','2021-09-26 18:34:12'),(21,3,'don\'t panic','01a-dontpanic.jpg','',50,NULL,8,1,'2021-03-29 20:34:00','2021-09-26 18:34:47'),(22,3,'Son of God','3-songod.jpg','',50,NULL,8,1,'2021-04-01 20:34:00','2021-09-26 18:35:07'),(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'),(24,3,'denial of reality','5-denialreality.jpg','',50,NULL,8,1,'2021-04-08 20:36:00','2021-09-26 18:36:21'),(45,1,'started small','1 started small.jpg','',50,NULL,8,1,'2021-08-30 17:15:00','2021-09-26 07:29:56'),(48,1,'GOD had a plan','2 God had a plan.jpg','',50,NULL,8,1,'2021-08-28 17:17:00','2021-09-26 07:30:14'),(49,1,'where do you start','3 where do you start.jpg','',50,NULL,8,1,'2021-08-25 17:17:00','2021-09-26 07:30:23'),(50,1,'passing the test','4 test.jpg','',50,NULL,8,1,'2021-08-01 17:32:00','2021-09-29 15:33:11'),(60,2,'make it personal','p5-personalfaith.jpg','',50,'null',8,1,'2021-09-23 11:19:00','2021-09-27 09:19:27'),(61,2,'knowing him personally','p6-personalname.jpg','',50,'',8,1,'2021-09-22 11:19:00','2021-09-27 09:19:44'),(62,2,'draw close','p7-drawclose.jpg','',50,'',8,1,'2021-09-21 11:20:00','2021-09-27 09:20:03'),(63,2,'get personal','p8-fastprayer.jpg','',50,'',8,1,'2021-09-20 09:19:00','2021-11-27 08:19:46'),(64,3,'in favor & grace','6-livingfavor.jpg','',50,'',8,1,'2021-04-12 20:36:00','2021-09-26 18:36:40'),(65,3,'hack attack','7-hackattack.jpg','',50,'',8,1,'2021-04-19 20:37:00','2021-09-26 18:37:33'),(66,3,'God\'s kingdom is','8-kingdomis.jpg','',50,'',8,1,'2021-04-26 20:37:00','2021-09-26 18:38:10'),(67,3,'the victory is ours','9-battlelords.jpg','',50,'',8,1,'2021-04-30 20:39:00','2021-09-26 18:40:06'),(68,3,'to love God','10-gettolove.jpg','',50,'',8,1,'2021-05-03 20:40:00','2021-09-26 18:41:03'),(69,3,'self value','11-selfvalue.jpg','',50,'',8,1,'2021-05-07 20:41:00','2021-09-26 18:41:48'),(70,3,'fake news','12-fakenews.jpg','',50,'',8,1,'2021-05-08 20:42:00','2021-09-26 18:43:22'),(71,3,'without conditions','13-noconditions.jpg','',50,'',8,1,'2021-05-10 20:44:00','2021-09-26 18:44:58'),(74,2,'if it\'s not personal','p1-ifnotpersonal.jpg','',50,'',8,1,'2021-09-27 11:10:00','2021-09-27 09:12:43'),(75,2,'it began very personal','p2-personalbegining.jpg','',50,'',8,1,'2021-09-26 11:13:00','2021-09-27 09:14:02'),(76,2,'not personal anymore','p3-moses.jpg','',50,'',8,1,'2021-09-25 11:15:00','2021-09-27 09:15:11'),(77,2,'personally with him','p4-fishermen.jpg','',50,'',8,1,'2021-09-24 11:16:00','2021-09-27 09:16:19'),(78,3,'what you see','14-whatsee.jpg','',50,'',8,1,'2021-05-12 11:42:00','2021-09-27 09:43:06'),(80,1,'finding His way','5 finding His way.jpg','',50,'',8,1,'2021-08-23 18:06:00','2021-09-29 16:07:13'),(81,3,'leave no place','15-noplaceforsin.jpg','',47,'',8,1,'2021-05-17 10:10:28','2021-10-01 10:15:10'),(82,3,'in Him - i am','16-inhiminlove.jpg','',50,'',8,1,'2021-05-21 12:16:00','2021-10-01 10:16:51'),(83,3,'is God - God?','17-isgodyourgod.jpg','',50,'',8,1,'2021-05-24 12:17:00','2021-10-01 10:18:34'),(84,3,'stop looking for...','18-startlook.jpg','',50,'',8,1,'2021-05-31 12:19:00','2021-10-01 10:19:25'),(85,3,'- to judge or not -','19-judge.jpg','',50,'',8,1,'2021-06-07 12:20:00','2021-10-01 10:22:15'),(86,3,'i was not there','20-iwasnotthere.jpg','',50,'',8,1,'2021-06-14 13:01:00','2021-10-01 11:01:53'),(87,3,'and the greatest is','21-thegreatestis.jpg','',50,'',8,1,'2021-06-18 13:04:00','2021-10-01 11:04:48'),(88,3,'disappointed','22-disappointed.jpg','',50,'',8,1,'2021-06-22 13:06:00','2021-10-01 11:07:14'),(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'),(90,3,'the love of art','24-artoflove.jpg','',50,'',8,1,'2021-07-02 13:08:00','2021-10-01 11:09:23'),(91,3,'what about','25-seeyourselfable.jpg','',50,'',8,1,'2021-07-05 13:09:00','2021-10-01 11:10:17'),(92,3,'what happened','26-whathappened.jpg','',50,'',8,1,'2021-07-12 13:10:00','2021-10-01 11:11:07'),(93,3,'the unseen world','27-unseenworld.jpg','',50,'',8,1,'2021-07-15 13:14:00','2021-10-01 11:15:08'),(94,3,'time to reboot','28-upgrade.jpg','',50,'',8,1,'2021-07-16 13:15:00','2021-10-01 11:16:23'),(95,3,'a new world','29-wholenew.jpg','',50,'',8,1,'2021-07-16 13:20:00','2021-10-01 11:21:05'),(96,3,'perfected in love','30-perfectedlove.jpg','',50,'',8,1,'2021-07-17 13:21:00','2021-10-01 11:21:45'),(97,3,'I am the way','31-iamtheway.jpg','',50,'',8,1,'2021-07-18 13:22:00','2021-10-01 11:23:27'),(98,3,'religion','32-religionvoice.jpg','',50,'',8,1,'2021-07-21 13:24:00','2021-10-01 11:25:43'),(99,3,'love covers','33-loveheals.jpg','',50,'',8,1,'2021-07-23 16:49:00','2021-10-02 14:50:29'),(100,3,'the truth','34-truthfree.jpg','',50,'',8,1,'2021-07-30 16:50:00','2021-10-02 14:52:56'),(101,3,'the secret','35-secrettolearning.jpg','',50,'',8,1,'2021-07-31 16:53:00','2021-10-02 14:53:45'),(102,3,'prosperity','36-prosperity.jpg','',50,'',8,1,'2021-08-10 17:02:00','2021-10-02 15:02:56'),(103,3,'He is still','37-godis.jpg','',50,'',8,1,'2021-08-16 17:03:00','2021-10-02 15:04:03'),(104,3,'believing - is seeing','38-believing.jpg','',50,'',8,1,'2021-08-18 10:00:00','2021-11-27 09:00:50'),(105,2,'it became personal','p9-jesusloved.jpg','',50,'',8,1,'2021-09-19 12:59:00','2021-10-26 10:59:59'),(106,2,'make it happen','p10-makehappen.jpg','',50,'null',8,1,'2021-09-18 09:58:00','2021-11-27 08:59:10'),(107,3,'agreeing with','39-negative.jpg','',50,'',8,1,'2021-08-30 10:01:00','2021-11-27 09:02:06'),(108,3,'what you think','40-whatthink.jpg','',50,'',8,1,'2021-09-03 10:02:00','2021-11-27 09:03:39'),(109,3,'does God have','41-favorites.jpg','',50,'',8,1,'2021-09-09 10:56:00','2021-11-27 09:56:22'),(110,3,'living in faith','42-faithlove.jpg','',50,'',8,1,'2021-09-13 10:56:00','2021-11-27 09:57:10'),(119,3,'no explanation','43-justify.jpg','',50,'',8,1,'2021-09-20 19:26:00','2021-11-27 18:28:37'),(120,3,'make it happen','44-makeithappen.jpg','',50,'',8,1,'2021-09-25 20:51:00','2021-11-27 19:52:11'),(121,3,'do you believe','45-doyoubelieve.jpg','',50,'',8,1,'2021-10-15 20:55:00','2021-11-27 19:55:56'),(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'),(123,3,'that fearful tree','47-fear.jpg','',50,'',8,1,'2021-11-01 20:57:00','2021-11-27 20:04:55'),(124,2,'if the anointing is not personal','p11-anointed.jpg','',50,'',8,1,'2021-09-17 11:37:00','2021-12-10 10:37:38'),(125,3,'dominate','48-dominate.jpg','',50,'',8,1,'2021-12-04 21:32:00','2021-12-13 20:33:39'),(126,3,'life is','49-lifechoices.jpg','',50,'',8,1,'2021-12-12 21:34:00','2021-12-13 20:34:54'),(127,3,'- time -','50-timeternity.jpg','',50,'',8,1,'2021-12-17 20:24:00','2021-12-20 19:25:06'),(128,2,'draw near to Him','p25-drawnear.jpg','',50,'',8,1,'2021-09-01 21:27:00','2021-12-23 20:30:28'),(129,3,'God\'s will ...','51-whodecides.jpg','',50,'',8,1,'2022-01-07 10:00:00','2022-01-10 09:00:15'),(132,3,'believing','52-believingfaith.jpg','',50,'',8,1,'2022-01-14 17:47:00','2022-01-17 16:47:22'),(134,3,'we make pictures','53-makingpictures.jpg','',50,'',8,1,'2022-01-27 22:17:00','2022-01-31 21:16:54'),(135,3,'beware of','54-trojan.jpg','',50,'',8,1,'2022-01-31 22:19:00','2022-01-31 21:18:19'),(136,3,'get ready','55-heavenlyfeast.jpg','',50,'',8,1,'2022-02-07 10:41:00','2022-02-07 09:41:36'),(140,3,'no losers','56-nolosers.jpg','',50,'',8,1,'2022-02-11 17:46:00','2022-03-13 16:48:42'),(142,3,'- is faith -','57-faithis.jpg','',50,'',8,1,'2022-02-18 10:00:00','2022-03-15 09:00:19'),(143,3,'religion','58-religionreality.jpg','',50,'#ffffff',8,1,'2022-02-24 10:31:00','2022-03-15 09:34:05'),(144,3,'unlimited','59-unlimited.jpg','',50,'',8,1,'2022-03-07 10:37:00','2022-03-15 09:37:38'),(145,3,'you need to succeed','60-needseed.jpg','',50,'',8,1,'2022-03-15 10:41:00','2022-03-15 09:41:58'),(146,2,'- if you don\'t -','p12-drawnear.jpg','',50,'',8,1,'2021-09-16 11:34:00','2022-03-15 10:34:33'),(147,2,'just like God did','p13-personalgod.jpg','',50,'',8,1,'2021-09-15 11:05:00','2022-03-15 10:05:27'),(148,2,'his grace is sufficient','p14-spirit.jpg','',50,'',8,1,'2021-09-14 11:06:00','2022-03-15 10:07:04'),(150,2,'so should you','p15-lifehimself.jpg','',50,'',8,1,'2021-09-13 11:37:00','2022-03-15 10:37:42');


