-- MySQL dump 10.13  Distrib 8.0.27, for Win64 (x86_64)
--
-- Host: 139.59.246.148    Database: demo_policybot
-- ------------------------------------------------------
-- Server version	5.7.35

/*!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 */;
/*!50503 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `agent_racetype`
--

DROP TABLE IF EXISTS `agent_racetype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `agent_racetype` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `agent_racetype`
--

LOCK TABLES `agent_racetype` WRITE;
/*!40000 ALTER TABLE `agent_racetype` DISABLE KEYS */;
INSERT INTO `agent_racetype` VALUES (1,'Malay',1),(2,'Chinese',1),(3,'English',1),(4,'Tamil',1);
/*!40000 ALTER TABLE `agent_racetype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `agent_subscribes`
--

DROP TABLE IF EXISTS `agent_subscribes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `agent_subscribes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `agency_id` int(11) NOT NULL,
  `policy_id` int(11) NOT NULL,
  `cdate` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `agent_subscribes`
--

LOCK TABLES `agent_subscribes` WRITE;
/*!40000 ALTER TABLE `agent_subscribes` DISABLE KEYS */;
/*!40000 ALTER TABLE `agent_subscribes` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `agents`
--

DROP TABLE IF EXISTS `agents`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `agents` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL DEFAULT '0',
  `agent_code` text NOT NULL,
  `permalink` varchar(255) DEFAULT NULL,
  `category` varchar(100) DEFAULT NULL,
  `intro` longtext,
  `experience` varchar(100) DEFAULT NULL,
  `location` varchar(100) DEFAULT NULL,
  `term` varchar(100) DEFAULT NULL,
  `image1` varchar(200) DEFAULT NULL,
  `image2` varchar(200) DEFAULT NULL,
  `image3` varchar(200) DEFAULT NULL,
  `image4` varchar(200) DEFAULT NULL,
  `benefits` varchar(200) DEFAULT NULL,
  `specializations` varchar(200) DEFAULT NULL,
  `racetype` text NOT NULL,
  `pincode` int(11) NOT NULL,
  `company` text NOT NULL,
  `status` int(11) NOT NULL,
  `category_notify` int(11) NOT NULL,
  `racetype_notify` int(11) NOT NULL,
  `company_notify` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `agents`
--

LOCK TABLES `agents` WRITE;
/*!40000 ALTER TABLE `agents` DISABLE KEYS */;
INSERT INTO `agents` VALUES (1,2,'0',NULL,'1','Agent','10 Months',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2, 3',742002,'2',1,1,1,1),(2,1,'0',NULL,'','','10 Months',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'',642001,'2',1,1,1,0),(3,15,'agent22',NULL,'13,22','hello dearss','10 Days',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'2,3',642002,'1',1,1,1,1),(4,18,'',NULL,'1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'4',642001,'1',1,0,0,0);
/*!40000 ALTER TABLE `agents` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `blog`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `blog` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `image` text NOT NULL,
  `intro` text NOT NULL,
  `tags` text NOT NULL,
  `cdate` timestamp NULL DEFAULT NULL,
  `cby` int(11) NOT NULL,
  `udate` timestamp NULL DEFAULT NULL,
  `uby` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `blog` WRITE;
/*!40000 ALTER TABLE `blog` DISABLE KEYS */;
INSERT INTO `blog` VALUES (1,'Lic anouncement','uploads/slider/image480081lic-policy-1575445432.jpg','The Republican leader is wrong, as the U.S. government continues to borrow heavily to pay for Trump\'s tax cuts.','lic','2021-09-23 05:33:10',1,'2021-09-23 06:17:47',1,0);
/*!40000 ALTER TABLE `blog` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `categories`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `categories` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) NOT NULL,
  `name` varchar(255) DEFAULT NULL,
  `icon` varchar(100) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  `short_description` text NOT NULL,
  `cdate` timestamp NULL DEFAULT NULL,
  `udate` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `categories` WRITE;
/*!40000 ALTER TABLE `categories` DISABLE KEYS */;
INSERT INTO `categories` VALUES (1,0,'Life Insurance','uploads/category/image335644image4879331.png',1,'Life Insurance is defined as an agreement or contract between an insurance company and a policyholder. The insurance company promises to pay a lump sum amount of money in exchange for a premium, upon the policyholder’s unfortunate death or after a set period.','2021-10-20 10:44:50','2021-11-17 11:18:31'),(2,0,'Health Insurance','uploads/category/image4778541.png',1,'Health Insurance or medical insurance is a contract between the insurer and policyholder  where the insurance company helps the insured to meet medical expenses. ','2021-10-28 05:56:17',NULL),(6,0,'Family Insurance','uploads/category/image839803illustration-family-healthcare_53876-40783.jpg',1,'Health insurance takes care of your medical expenses and ensures that out-of-pocket expenses are curtailed up to the Sum insured','2021-11-15 11:43:47',NULL);
/*!40000 ALTER TABLE `categories` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `category_compare_detail`
--

DROP TABLE IF EXISTS `category_compare_detail`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `category_compare_detail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` int(11) NOT NULL,
  `compare` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `category_compare_detail`
--

LOCK TABLES `category_compare_detail` WRITE;
/*!40000 ALTER TABLE `category_compare_detail` DISABLE KEYS */;
INSERT INTO `category_compare_detail` VALUES (1,1,1,1),(2,1,2,1),(3,1,3,0),(4,1,4,1),(5,1,5,0),(9,3,9,1),(10,3,10,1),(11,3,11,1),(12,4,12,1),(13,4,13,1),(14,4,14,1),(15,6,2,1),(16,6,4,1),(17,6,12,1),(18,1,3,1),(19,1,15,0),(20,1,16,0),(21,1,5,1);
/*!40000 ALTER TABLE `category_compare_detail` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `category_compare_master`
--

DROP TABLE IF EXISTS `category_compare_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `category_compare_master` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `compare_name` text NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `category_compare_master`
--

LOCK TABLES `category_compare_master` WRITE;
/*!40000 ALTER TABLE `category_compare_master` DISABLE KEYS */;
INSERT INTO `category_compare_master` VALUES (1,'Policy Term',1),(2,'Maturity Benefits',1),(3,'Ideal For',1),(4,'Claim Assistance',1),(5,'Payout Options',1),(9,'Entry Age',1),(10,'Coverage Type',1),(11,'Discount On Premium',1),(12,'Restoration Of Cover',1),(13,'Cashless Hospitals',1),(14,'Free Health Checkup',1),(15,'Catisnew',1),(16,'Claiming Method',1);
/*!40000 ALTER TABLE `category_compare_master` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `category_document_details`
--

DROP TABLE IF EXISTS `category_document_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `category_document_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` int(11) NOT NULL,
  `document` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `category_document_details`
--

LOCK TABLES `category_document_details` WRITE;
/*!40000 ALTER TABLE `category_document_details` DISABLE KEYS */;
INSERT INTO `category_document_details` VALUES (1,1,1,1),(2,1,2,0),(3,1,3,1),(4,1,4,1);
/*!40000 ALTER TABLE `category_document_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `category_questions_before_quote`
--

DROP TABLE IF EXISTS `category_questions_before_quote`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `category_questions_before_quote` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `category` int(11) NOT NULL,
  `question` text NOT NULL,
  `option_input_type` int(11) NOT NULL COMMENT '1-choose one,2-input,3-multiple select',
  `options` text NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `category_questions_before_quote`
--

LOCK TABLES `category_questions_before_quote` WRITE;
/*!40000 ALTER TABLE `category_questions_before_quote` DISABLE KEYS */;
INSERT INTO `category_questions_before_quote` VALUES (1,1,'Are  you smoker ?',2,'Yes|No',0),(2,1,'Select your annual income',1,'15 Lac +|10 Lac to 14.9 Lac|7 Lac to 9.9 Lac|5 Lac to 6.9 Lac|3 Lac to 4.9 Lac|2 Lac to 2.9 Lac|Less than 2 Lac',0),(3,1,'Please select your occupation type',3,'Salaried',1),(4,1,'Please select your educational qualification',1,'College graduate & Above|12th Pass',1),(5,3,'Do you have an existing illness or medical history ?',1,'Existing illness|Covid 19|Surgical procedure|None of these',1),(6,3,'Who are all covering this insurance ?',3,'Mother|Father|Wife|Daughter|Son',1),(7,2,'Who are all cover this policy',1,'Self|Me + Wife|Me + Wife + Son',1),(8,2,'Enter Your age',2,'-',1),(9,2,'Do you have an existing illness or medical history',1,'Existing illness|Covid 19|Surgical procedure|None of these',1),(10,6,'Are you smooker ?',1,'Yes|No',1),(11,1,'Are you smooker ?',1,'Yes',1);
/*!40000 ALTER TABLE `category_questions_before_quote` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `collected_documents_from_customer`
--

DROP TABLE IF EXISTS `collected_documents_from_customer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `collected_documents_from_customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `document_id` int(11) NOT NULL,
  `doc_copy` text NOT NULL,
  `quote` int(11) NOT NULL,
  `category` int(11) NOT NULL,
  `policy` int(11) NOT NULL,
  `user` int(11) NOT NULL,
  `agent` int(11) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `collected_documents_from_customer`
--

LOCK TABLES `collected_documents_from_customer` WRITE;
/*!40000 ALTER TABLE `collected_documents_from_customer` DISABLE KEYS */;
INSERT INTO `collected_documents_from_customer` VALUES (1,1,'uploads/document_collect/211115025312.f1.jpg',1,1,30,11,2,1),(2,2,'uploads/document_collect/211115025312.f2.jpg',1,1,30,11,2,1),(3,3,'uploads/document_collect/211115025312.f5.jpg',1,1,30,11,2,1),(4,1,'uploads/document_collect/211115025444.f1.jpg',1,1,30,11,2,1),(5,1,'uploads/document_collect/211116124323.21104.png',1,1,30,11,2,1),(6,2,'uploads/document_collect/211116012130.21104.png',1,1,30,11,2,1),(7,1,'uploads/document_collect/211201123119.21104.png',6,1,33,7,15,1);
/*!40000 ALTER TABLE `collected_documents_from_customer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `companies`
--

DROP TABLE IF EXISTS `companies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `companies` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL,
  `logo` text NOT NULL,
  `cdate` datetime NOT NULL,
  `udate` datetime NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `companies`
--

LOCK TABLES `companies` WRITE;
/*!40000 ALTER TABLE `companies` DISABLE KEYS */;
INSERT INTO `companies` VALUES (1,'LICs','uploads/company/image994311download.png','2021-10-20 17:30:12','2021-10-20 17:38:15',1),(2,'Hdfc ','uploads/company/image978968download (1).png','2021-10-21 15:04:57','0000-00-00 00:00:00',1);
/*!40000 ALTER TABLE `companies` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `contact`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `contact` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `mobile` varchar(30) DEFAULT NULL,
  `subject` varchar(255) DEFAULT NULL,
  `message` text,
  `ip` varchar(100) DEFAULT NULL,
  `browser` varchar(255) DEFAULT NULL,
  `cdate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `udate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `contact` WRITE;
/*!40000 ALTER TABLE `contact` DISABLE KEYS */;
INSERT INTO `contact` VALUES (6,'JamesPhymn','no-replyCrealgeflirl@gmail.com','85565819723','A new method of email distribution.','Hi!  policybot.com.my \r\n \r\nDo you know the easiest way to state your merchandise or services? Sending messages using contact forms will allow you to easily enter the markets of any country (full geographical coverage for all countries of the world).  The advantage of such a mailing  is that the emails that will be sent through it\'ll find yourself in the mailbox that\'s intended for such messages. Causing messages using Feedback forms is not blocked by mail systems, which implies it\'s sure to reach the recipient. You will be ready to send your offer to potential customers who were previously unobtainable thanks to email filters. \r\nWe offer you to check our service for free of charge. We are going to send up to fifty thousand message for you. \r\nThe cost of sending one million messages is us $ 49. \r\n \r\nThis message is created automatically. Please use the contact details below to contact us. \r\n \r\nContact us. \r\nTelegram - @FeedbackMessages \r\nSkype  live:contactform_18 \r\nWhatsApp - +375259112693 \r\nWe only use chat.','92.204.174.83','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.75 Safari/537.36','2021-05-05 19:25:02','0000-00-00 00:00:00',1),(7,'Mike Wilson\r\n','no-replySah@gmail.com','88173932279','Local SEO for more business','Good Day \r\n \r\nI have just analyzed  policybot.com.my for its Local SEO Trend and seen that your website could use a boost. \r\n \r\nWe will increase your Local Ranks organically and safely, using only whitehat methods, while providing Google maps and website offsite work at the same time. \r\n \r\nPlease check our services below, we offer SEO at cheap rates. \r\nhttps://speed-seo.net/product/local-seo-package/ \r\n \r\nStart increasing your local visibility with us, today! \r\n \r\nregards \r\nMike Wilson\r\n \r\nSpeed SEO Digital Agency \r\nsupport@speed-seo.net','37.120.143.59','Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36 Kinza/4.7.2','2021-05-11 21:40:51','0000-00-00 00:00:00',0),(8,'Yahoo','press@yahoo.com','81554965773','Most profitable cryptocurrency miners released','Most profitable cryptocurrency miners has been released : \r\nDBT Miner: $7,500 (Bitcoin), $13,000 (Litecoin), $13,000 (Ethereum), and $15,000 (Monero) \r\n \r\nGBT Miner: $22,500 (Bitcoin), $39,000 (Litecoin), $37,000 (Ethereum), and $45,000 (Monero) \r\nRead more here : \r\nhttps://www.yahoo.com/now/bitwats-release-most-profitable-asic-195600764.html','191.101.217.75','Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36 Kinza/4.7.2','2021-05-13 07:12:45','0000-00-00 00:00:00',0),(9,'Mike Holmes\r\n','no-reply@google.com','87826348467','whitehat monthly SEO plans','Howdy \r\n \r\nI have just took a look on your SEO for  policybot.com.my for the ranking keywords and saw that your website could use an upgrade. \r\n \r\nWe will improve your SEO metrics and ranks organically and safely, using only whitehat methods, while providing monthly reports and outstanding support. \r\n \r\nPlease check our plans here, we offer SEO at cheap rates. \r\nhttps://www.hilkom-digital.de/cheap-seo-packages/ \r\n \r\nStart enhancing your sales and leads with us, today! \r\n \r\nregards \r\nMike Holmes\r\n \r\nHilkom Digital Team \r\nsupport@hilkom-digital.de','84.247.48.51','Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.87 Safari/537.36 OPR/54.0.2952.71','2021-05-13 14:48:23','0000-00-00 00:00:00',0),(10,'Mike Flatcher\r\n','see-email-in-message@monkeydigital.co','82953222428','Increase Domain Strength for policybot.com.my','Hi there \r\n \r\nDo you want a quick boost in ranks and sales for your policybot.com.my website? \r\nHaving a high DA score, always helps \r\n \r\nGet your policybot.com.my to have a DA between 50 to 60 points in Moz with us today and rip the benefits of such a great feat. \r\n \r\nSee our offers here: \r\nhttps://www.monkeydigital.co/product/moz-da50-seo-plan/ \r\n \r\nNEW: \r\nhttps://www.monkeydigital.co/product/ahrefs-DR50-UR70/ \r\n \r\n \r\nthank you \r\nMike Flatcher\r\n \r\nsupport@monkeydigital.co','176.125.230.132','Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.146 Safari/537.36','2021-05-13 18:35:25','0000-00-00 00:00:00',0),(11,'Mazlan Selvi','no-replyMl@gmail.com','84248317561','Please I need your urgent response','Dear Friend, \r\n \r\nMy names are Mr. Mezlan Selvi, a lawyer base in Kuala Lumpur - Malaysia. I have previously sent you an email regarding a transaction of US$13.5 Million left behind by my late client before his tragic death but no response from you. \r\n \r\nHowever, I am contacting you once again with strong believe that you will work /partner with me to execute this business transaction in good faith. Please if you are interested in proceeding with me, kindly respond to me via my private email mselvi@ponnusamylawassociates-my.com for more detailed information. \r\n \r\nAs a matter of fact, this transaction is 100% risk free and I look forward to your acknowledgement. \r\n \r\nRegards, \r\nMr. Mazlan Selvi \r\nEmail: mselvi@ponnusamylawassociates-my.com','176.125.229.133','Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36','2021-05-13 19:43:43','0000-00-00 00:00:00',0),(12,'Sambo Dasuki','mmzxxz288@gmail.com','85386889189','Business Partner','Dear Partner; \r\n \r\nI came across your email contact on Database; Where i was searching for a competent Partner who can handle a lucrative business for me as trustee and manager. I anticipate to read from you soon so I can provide you with more details. \r\n \r\nYours Sincerely, \r\nAlh. Sambo Dasuki \r\nmmzxxz288@gmail.com','185.253.97.250','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/66.0.3359.181 Safari/537.36','2021-05-18 20:26:18','0000-00-00 00:00:00',0),(13,'Treasury Dept','qqa564594@email-checker.us','88237762777','This Very Urgent','Hello, \r\n \r\nHow are you today? I hope you are in good health. I am a banker with a financial institution here in China and I am writing to you for an opportunity that will benefit us both immensely. I have discovered an \r\nunclaimed inheritance fund and I wish to lay down your name as the next of kin to the amount in question due to the death of the \r\ndepositor who died years ago along with her family. \r\n \r\nHowever, i assure you that it will be executed under a legitimate arrangement that will protect you from any breach of the law both in your country and here in china once the fund is transferred to your bank account. The funds i am referring to is right here in this bank floating in a suspense account, therefore i solicit for your \r\ncooperation to be in collaboration with me to have this done. If you are interested in this transaction, I will need you to provide the your information urgently to enable the attorney to start the processing of all the relevant legal documents for the remittance of the said fund. \r\n \r\nI urgently hope to get your response as soon as possible - Please Reply to:  qqa564594@gmail.com \r\n \r\nYours Sincerely, \r\nFrom: Treasury Dept. \r\nEcitic Bank of China. \r\nqqa564594@gmail.com','191.101.209.115','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.181 Safari/537.36','2021-05-22 06:29:46','0000-00-00 00:00:00',0),(14,'Mike Kendal\r\n','no-reply@google.com','89129816568','quality monthly SEO plans','Good Day \r\n \r\nI have just took a look on your SEO for  policybot.com.my for the ranking keywords and saw that your website could use an upgrade. \r\n \r\nWe will increase your SEO metrics and ranks organically and safely, using only whitehat methods, while providing monthly reports and outstanding support. \r\n \r\nPlease check our plans here, we offer SEO at cheap rates. \r\nhttps://www.hilkom-digital.de/cheap-seo-packages/ \r\n \r\nStart improving your sales and leads with us, today! \r\n \r\nregards \r\nMike Kendal\r\n \r\nHilkom Digital Team \r\nsupport@hilkom-digital.de','77.81.139.42','Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.79 Safari/537.36','2021-05-22 07:06:49','0000-00-00 00:00:00',0),(15,'Rajiv Michael','rajiindian3@gmail.com','85372465797','Do you need funding?','Hello Dear, \r\n \r\nI am working directly with a private family portfolio that can provide funding for credible clients with feasible projects. Currently, we have investment funds for viable projects. \r\n \r\nThey are interested in the following: Institution, Library, Hospitals, Green energy, \r\nPower projects, Agriculture and Real Estate. They can also partner with your company on other projects of value. The interest rate and tenure are fantastic. \r\n \r\nYour response is most anticipated if this is of interest to you. Reach me on email: financial@eurocleargroups.email or rajiindian3@gmail.com \r\n \r\n \r\nKind regards, \r\n \r\nRajiv Michael \r\nFinancial Consultant \r\nWhatsApp: +15183802182 \r\nTelegram@ +12092482370 \r\nEuroclear Groups \r\nfinancial@eurocleargroups.email \r\nUrl: http://euroclear.com','84.17.48.13','Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/68.0.3440.106 Safari/537.36 Kinza/4.9.1','2021-05-25 19:44:33','0000-00-00 00:00:00',0),(16,'Nick Brown','nick@saaytext.com','85931971898','Can you direct me to the right person','Hello, we have a fully Unlimited Texting tool for businesses to communicate with customers. \r\n \r\nIt\'s 49/mo flat, all you can send no other costs. \r\n \r\nYou can text your whole list at once using the bulk send feature or send two-way texts and get replies with Peer to Peer texting. \r\n \r\nYou can check it out at http://saaytext.com \r\n \r\nThanks \r\nNick','104.200.151.92','Mozilla/5.0 (Windows NT 6.1; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/67.0.3396.99 Safari/537.36','2021-05-27 06:04:12','0000-00-00 00:00:00',0);
/*!40000 ALTER TABLE `contact` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `documents_master`
--

DROP TABLE IF EXISTS `documents_master`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `documents_master` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` text NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `documents_master`
--

LOCK TABLES `documents_master` WRITE;
/*!40000 ALTER TABLE `documents_master` DISABLE KEYS */;
INSERT INTO `documents_master` VALUES (1,'Adhaar Card',1),(2,'PAN Card',1),(3,'Age Proof',1),(4,'Id Card',1);
/*!40000 ALTER TABLE `documents_master` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `faq`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `faq` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `question` varchar(255) DEFAULT NULL,
  `answer` text,
  `cdate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `udate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `faq` WRITE;
/*!40000 ALTER TABLE `faq` DISABLE KEYS */;
INSERT INTO `faq` VALUES (6,'how to apply ?','use our website','2021-09-23 11:44:14','2021-09-23 11:57:25',1);
/*!40000 ALTER TABLE `faq` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `menu`
--

DROP TABLE IF EXISTS `menu`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `menu` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `parent_id` bigint(20) NOT NULL DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `icon` varchar(100) DEFAULT NULL,
  `filename` varchar(100) DEFAULT NULL,
  `cdate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `udate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `menu`
--

LOCK TABLES `menu` WRITE;
/*!40000 ALTER TABLE `menu` DISABLE KEYS */;
INSERT INTO `menu` VALUES (1,0,'Dashboard','dashboard','dashboard','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(2,0,'Role','perm_identity','role','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(3,0,'Staff','group','staff','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(4,5,'Category','pages','admin/category','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(5,0,'Policy Info','local_florist','javascript:;','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(6,0,'Slider ','photo_library','slider','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(7,0,'Blog ','chrome_reader_mode','blog','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(8,0,'Testimonial ','forum','testimonial','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(9,0,'FAQ ','send','faq','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(10,0,'Enquires ','email','enquiries','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(11,0,'Quotes','library_books','#','0000-00-00 00:00:00','0000-00-00 00:00:00',0),(12,0,'Requests','forward','#','0000-00-00 00:00:00','0000-00-00 00:00:00',0),(13,0,'Orders','content_paste','orders','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(14,0,'Review','textsms','reviews','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(15,5,'Companies',NULL,'admin/company','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(16,5,'Policies',' ','admin/policies','0000-00-00 00:00:00','0000-00-00 00:00:00',1),(17,5,'Documents Need',' ','admin/documents','0000-00-00 00:00:00','0000-00-00 00:00:00',1);
/*!40000 ALTER TABLE `menu` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `options`
--

DROP TABLE IF EXISTS `options`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `options` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `option_name` varchar(255) DEFAULT NULL,
  `option_value` text,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `options`
--

LOCK TABLES `options` WRITE;
/*!40000 ALTER TABLE `options` DISABLE KEYS */;
INSERT INTO `options` VALUES (1,'site_name','PolicyBot'),(2,'site_description','Insurance Policy '),(3,'site_keywords','Auto Insurance, Health Insurance, Life Insurance, Agri Insurance, Travel Insurance '),(4,'admin_address','Kuala Lumpur '),(5,'admin_email','CustomerCare@PolicyBot.com'),(6,'paypal_email','inetmsakthi@gmail.com'),(7,'site_currency','MYR'),(8,'facebook','https://facebook.com'),(9,'twitter','https://twitter.com'),(10,'linkedin','https://linkedin.com'),(11,'gplus','https://plus.google.com'),(12,'site_logo','logo_6016e0f68b0c3.png'),(13,'admin_username','admin'),(14,'admin_password','$2y$11$[REDACTED]'),(15,'about_us','<p>We\'re here to Simplify, and make Insurance available for all !</p>'),(16,'terms_conditions','<p>Terms of Use</p>'),(17,'privacy_policy','<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Policy on Privacy</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">We are like you - we know our privacy standards.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">A matter of value and sensitivity is insurance. This Privacy Policy, therefore, discloses the</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Www.PolicyBot.com privacy policies which refers exclusively to information obtained by our</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">The webpage. Our agenda encompasses:</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">1. What personally identifiable data is gathered from you through the</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Website, how it is used and who can share it with</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">2. What options are open to you concerning the use of your information?</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">3. The protection protocols that are in place to prevent the abuse of your data</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">4. How to correct any inaccuracies in the data</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">We want to honour our pledge, after all, to preserve all that matters to you!</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">We gather information to best represent you and not pass it on to others.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Tom, Harry and Dick</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">We are the sole owners of the details on www.PolicyBot.com that we receive. We just have the</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Links to the database of information that you voluntarily send to us via this website, email or other direct information</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Contact yourself. We will not sell your details or rent it to anyone.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">In order to reply to you regarding the reason you contacted us, we will use your details. We\'re going to</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Do not share your data with any outside third party of our company, registered insurance</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Partners of the firm, other than as required to satisfy your order, e.g. to provide a quotation or to provide a quotation</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">For our newsletters, sign up.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Unless you ask us not to do so, we will in the future contact you by email to tell you about specials,</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Or changes to this Privacy Policy for new goods or services.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">At any time, you can opt out of any potential communication with us. At any moment, you can do the following:</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">By unsubscribing to the email connection itself, or by contacting us at admin@PolicyBot.com:</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">1. See what data we have, if any, about you,</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">2. Change/correct any data about you that we have</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">3. Have us delete any data about you that we have</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">4. Present any questions you have about our use of your details</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Tell us what you want and don\'t like, so that we can give you suggestions that you do not like.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Uh, love.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">This is how your data will be used by us.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">You communicate with us mainly through 2 different means:</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Buy Now\" or \"Purchase\" to be obtained on the web immediately, or;\"</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">\"Send Message\"Send message</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">You are needed to offer certain details in order for us to facilitate these activities, for</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Examples include name, email address, contact number, identification number, sex, age, income, etc.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">The degree, smoking status and number of the car.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">\"Your information with your consent will be provided with respect to \"Purchase\" or \"Buy Now</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">We and our insurance partners will use it to create an online instant quote for you.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">As far as \'Send Message\' is concerned, your data can also be used by you with your permission.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">In order to determine the requirements for the particular insurance policy, the insurance partners.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">If you decide not to take the appropriate measures to carry out these acts or leave the platform,</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">All in all, we will not maintain any data that you have provided. For you, it is not mandatory to give</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">The personal information that is needed, but we will not be able to supply you if you do not,</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">With the requested services and/or goods.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">We can collect data from your browser and you</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">On this blog, we use \"cookies\" where a cookie is a piece of data that is hard to store on a visitor\'s site.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Drive to help us enhance your access to our website and recognise our website\'s frequent visitors. For, For</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">For example, if we use a cookie to recognise you, you wouldn\'t have to log in any more passwords</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">More than once, thereby saving time when on our website. Cookies can also help us to control and goal</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">The wishes of our users to boost the experience on our website. The use of a cookie is in no way feasible.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Related to any details on our web that is personally identifiable.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">We handle your data as though it were a national security problem.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">In order to protect your privacy, we take precautions. When you send sensitive data through the</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Your information is covered both online and offline by the website.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">This data is encrypted anywhere confidential information (such as personal data) is obtained.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">And transmitted in a safe manner to us. By searching for a closed lock icon on the lock icon, you can confirm this.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Or search for \"https\" at the beginning of the web address at the bottom of your web browser.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Uh, tab.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Although we use encryption to secure the online transmission of sensitive information, we also protect your</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Offline details. Just workers who need the data in order to perform a particular job (for</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Customer relationship management) are given access to personally identifiable information, for example.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">About details. The machines/servers in which we store personally identifiable data are stored</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">In a safe environment.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">This Privacy Policy is not laid down in stone.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">As PolicyBot and the insurance industry develop and expand, we will change our privacy policy.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">For a period of time. You can still find the most up-to-date edition at www.PolicyBot.com. Your Own</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">After an update to the Privacy Policy, continuing use of our website means you adhere to the current Privacy Policy.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Our Privacy Policy Terminology. Please stop using the privacy policy if you do not agree with the privacy policy.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Services at PolicyBot.</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">If you have any more questions about the protection of your data at PolicyBot, please do not</p>\r\n<p class=\"MsoNormal\" style=\"margin: 0cm 0cm 0.0001pt; font-size: 12pt; font-family: Calibri;\">Please email us at admin@PolicyBot.com and do not hesitate.</p>'),(18,'admin_mobile','+6012xxxxxx'),(19,'instagram','https://instagram.com'),(20,'about_us_footer','<p>We\'re here to Simplify, and make Insurance available for all !</p>'),(21,'mapEmbed','<iframe src=\"https://www.google.com/maps/embed?pb=!1m18!1m12!1m3!1d3983.787480459913!2d101.7052679149283!3d3.1506828540214187!2m3!1f0!2f0!3f0!3m2!1i1024!2i768!4f13.1!3m3!1m2!1s0x31cc362a8141df93%3A0xc76ff194a8ddd60f!2sJln%20Raja%20Chulan%2C%20Kuala%20Lumpur%2C%20Wilayah%20Persekutuan%20Kuala%20Lumpur!5e0!3m2!1sen!2smy!4v1612202043583!5m2!1sen!2smy\" width=\"600\" height=\"450\" frameborder=\"0\" style=\"border:0;\" allowfullscreen=\"\" aria-hidden=\"false\" tabindex=\"0\"></iframe>'),(27,'footer_logo','ftlogo_6016e0f68b39f.png'),(22,'admin_name','Admin'),(23,'fb_app_id','1822680511099177'),(24,'fb_app_secret','[REDACTED]'),(25,'gp_client_id','127721327848-8k59j05du0biandu1htvrf33cs1e0vrn.apps.googleusercontent.com'),(26,'gp_client_secret','[REDACTED]-GEY88');
/*!40000 ALTER TABLE `options` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `policies`
--

DROP TABLE IF EXISTS `policies`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `policies` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `agency_id` bigint(20) NOT NULL DEFAULT '0',
  `name` varchar(255) DEFAULT NULL,
  `permalink` varchar(255) DEFAULT NULL,
  `category` bigint(20) DEFAULT NULL,
  `company` int(11) NOT NULL,
  `amount` float NOT NULL DEFAULT '0',
  `amount_period` varchar(100) DEFAULT NULL,
  `image` varchar(200) DEFAULT NULL,
  `intro` longtext,
  `benefits` varchar(200) DEFAULT NULL,
  `specializations` varchar(200) DEFAULT NULL,
  `guarantee` varchar(100) DEFAULT NULL,
  `max_cover_age` text NOT NULL,
  `policy_period` varchar(100) DEFAULT NULL,
  `life_cover` text NOT NULL,
  `claimed_settlement` text NOT NULL,
  `company logo` text NOT NULL,
  `is_this_top_plan` int(11) NOT NULL DEFAULT '0' COMMENT '0-no top,1-top plan',
  `cdate` timestamp NULL DEFAULT NULL,
  `udate` timestamp NULL DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `permalink` (`permalink`)
) ENGINE=MyISAM AUTO_INCREMENT=36 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `policies`
--

LOCK TABLES `policies` WRITE;
/*!40000 ALTER TABLE `policies` DISABLE KEYS */;
INSERT INTO `policies` VALUES (32,0,'Critical Illness Insurance',NULL,18,3,1000,'Years','uploads/policy/image436379health-insurance.png','Your family’s health and safety means the world to you. We understand that and want to help you protect your loved ones from situations beyond your control. Star Comprehensive Family Insurance Plan is perfect for you and your family for a life free from worries.','Affordable Health Insurance cover on a floater basis, Upto 100% Increase in Sum Insured upon a claim free renewal, ','Domiciliary Hospitalisation, Hospital cash benefit., ','10 Years','','25 Months','','','',0,'2021-10-18 12:17:58',NULL,1),(31,0,'TATA AIG Car Insurance',NULL,22,3,1000,'Years','uploads/policy/image775960car-insurance-1.jpg','Give your Car an All-Round Protection with TATA AIG. Prices Starting @ Rs 2072* *T&C Apply. Get Covered For Tyre Repair & Replacement With Engine & Gearbox Protection. NCB Upto 50%. No Paperwork. 24*7 Claim Assistance. Breakdown Assistance. Zero Depreciation.','Unlimited Liability for Personal Damages, Up to 7.5 Lakhs for Property/Vehicle Damages, Up to 50% Discount, ','Cashless Repairs, Claim Settlement Ratio, ','1 Years','','2 Years','','','',0,'2021-09-28 05:55:48',NULL,1),(30,0,'Buy/Renew Car Insurance policy detail',NULL,1,2,1200,'Years','uploads/policy/image391393car.jpg','Car Insurance, also known as auto or motor insurance, is a type of vehicle insurance policy that protects you and your car from any risks and damages caused from accidents, thefts or natural disasters. So, you will be financially secure in case of any losses that may be incurred because of any such unforeseen circumstances. In addition to that, you will also be protected from third-party liabilities.','Cashless Repairs, 24*7 Support, ','Zero Depreciation Cover, Engine and Gear-box Protection Cover, ','1 Years','75','5 Years','','','',1,'2021-09-27 12:14:07',NULL,0),(33,0,'Saral Jeevan Bima Plan',NULL,1,1,0,'Years','uploads/policy/image451939download.png','In recent years, it has been noticed that there has been an increasing requirement for a  pocket-friendly and basic life insurance plan, specifically for the normal working Indian. Keeping  in mind the growing demand, innovative protection products have been introduced by life insurers with different features, benefits, riders, options, and so forth. The IRDAI has introduced a new standardized insurance plan and all the life insurance companies  have to abide by the standardized policy product guidelines. ','Easy Claim, ','Cashless settlement, ','5 Years','70','5 Years','12 LAC','97.9','',0,'2021-10-21 05:09:25','2021-11-17 13:04:00',1),(34,0,'Coronavirus Term Insurance',NULL,1,2,0,'Years','uploads/policy/image240371life.jpg','The pandemic indeed has forced financial security to the minds of almost every individual in an unprecedented way. Throughout the nation, individuals are surely moving towards proactive buying amidst the concern growing in regards to the COVID-19. In these times of uncertainties, coronavirus ','Easy Claim, ','100% secure, ','5 Years','45','5 Years','20 LAC','95.5','',1,'2021-10-21 09:37:38',NULL,1),(35,0,'Pension Plans',NULL,2,1,0,'Years','uploads/policy/image933786download.png','Pension plans are otherwise called retirement plans. In this, you may put some segment of your pay into the assigned plan. ','Pension plans are otherwise called retirement plans. In this, you may put some segment of your pay into the assigned plan. , ','Pension plans are otherwise called retirement plans. In this, you may put some segment of your pay into the assigned plan. , ','2 Years','50','12 Years','20 LAC','90','',0,'2021-10-28 06:10:46',NULL,1);
/*!40000 ALTER TABLE `policies` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `policy_compare_details`
--

DROP TABLE IF EXISTS `policy_compare_details`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `policy_compare_details` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `policy` int(11) NOT NULL,
  `category` int(11) NOT NULL,
  `compare` int(11) NOT NULL,
  `comparedetail` text NOT NULL,
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `policy_compare_details`
--

LOCK TABLES `policy_compare_details` WRITE;
/*!40000 ALTER TABLE `policy_compare_details` DISABLE KEYS */;
INSERT INTO `policy_compare_details` VALUES (1,33,1,2,' have to abide by the standardized policy product guidelines. ','2021-11-17 13:04:00',1),(2,33,1,5,'Easy ','2021-11-17 13:04:00',0),(3,33,1,4,'100%','2021-11-17 13:04:00',1),(4,34,1,2,'Easy to claim','2021-10-21 09:37:38',1),(5,34,1,4,'available','2021-10-21 09:37:38',1),(6,34,1,1,'','2021-10-21 09:37:38',1),(7,35,4,12,' 5 lakh once in a year','2021-10-28 06:10:46',1),(8,35,4,13,'9900+','2021-10-28 06:10:46',1),(9,35,4,14,'one year','2021-10-28 06:10:46',1),(10,35,4,12,'','2021-10-28 06:10:46',1),(11,33,1,3,'all','2021-11-17 13:04:00',1),(12,33,1,5,'all','2021-11-17 12:59:54',0),(13,33,1,1,'Easy ','2021-11-17 12:59:31',0),(14,33,1,12,'Easy ','2021-11-17 12:59:31',0),(15,33,1,13,'Easy ','2021-11-17 12:59:31',0),(16,33,1,14,'Easy ','2021-11-17 12:59:31',0),(17,30,1,14,' 5 lakh once in a year','2021-11-09 07:33:05',1),(18,33,1,1,'secure','2021-11-17 13:00:26',0),(19,33,1,1,'security','2021-11-17 13:02:24',0),(20,33,1,1,'sssss','2021-11-17 13:04:00',0);
/*!40000 ALTER TABLE `policy_compare_details` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `policy_detail_enquiry`
--

DROP TABLE IF EXISTS `policy_detail_enquiry`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `policy_detail_enquiry` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `userid` int(11) NOT NULL,
  `policyid` int(11) NOT NULL,
  `name` text NOT NULL,
  `email` text NOT NULL,
  `pincode` int(11) NOT NULL,
  `mobile` text NOT NULL,
  `message` text NOT NULL,
  `status` int(11) NOT NULL,
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `policy_detail_enquiry`
--

LOCK TABLES `policy_detail_enquiry` WRITE;
/*!40000 ALTER TABLE `policy_detail_enquiry` DISABLE KEYS */;
INSERT INTO `policy_detail_enquiry` VALUES (1,16,31,'kaleesma','kaleeswari26122@gmail.com',642001,'9865326589','hello',1,'2021-10-05 03:22:40'),(2,11,31,'kalees','kaleeswari2612@gmail.com',642001,'5665656565','enqutiry',1,'2021-10-05 03:25:20');
/*!40000 ALTER TABLE `policy_detail_enquiry` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `quote_questions`
--

DROP TABLE IF EXISTS `quote_questions`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `quote_questions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `quote_id` int(11) NOT NULL,
  `question` text NOT NULL,
  `answer` text NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `quote_questions`
--

LOCK TABLES `quote_questions` WRITE;
/*!40000 ALTER TABLE `quote_questions` DISABLE KEYS */;
INSERT INTO `quote_questions` VALUES (1,1,'Are  you smoker ?','s',1),(2,1,'Select your annual income','15 Lac +',1),(3,1,'Please select your occupation type','Salaried',1),(4,1,'Please select your educational qualification','College graduate & Above',1),(5,2,'Please select your occupation type','Salaried',1),(6,2,'Please select your educational qualification','College graduate & Above',1),(7,2,'Are you smooker ?','Yes',1),(8,3,'Please select your occupation type','Salaried',1),(9,3,'Please select your educational qualification','College graduate & Above',1),(10,3,'Are you smooker ?','Yes',1),(11,4,'Please select your occupation type','Salaried',1),(12,4,'Please select your educational qualification','12th Pass',1),(13,4,'Are you smooker ?','Yes',1),(14,5,'Please select your occupation type','Salaried',1),(15,5,'Please select your educational qualification','12th Pass',1),(16,5,'Are you smooker ?','Yes',1),(17,6,'Please select your occupation type','Salaried',1),(18,6,'Please select your educational qualification','College graduate & Above',1),(19,6,'Are you smooker ?','Yes',1);
/*!40000 ALTER TABLE `quote_questions` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `quote_response`
--

DROP TABLE IF EXISTS `quote_response`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `quote_response` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `agency_id` bigint(20) NOT NULL DEFAULT '0',
  `user_id` bigint(20) NOT NULL DEFAULT '0',
  `quote_id` bigint(20) NOT NULL DEFAULT '0',
  `mobile` varchar(20) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `message` text,
  `cdate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `udate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` int(1) NOT NULL DEFAULT '0' COMMENT '0=InProgress, 1=Accepted, 2=Canceled',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `quote_response`
--

LOCK TABLES `quote_response` WRITE;
/*!40000 ALTER TABLE `quote_response` DISABLE KEYS */;
INSERT INTO `quote_response` VALUES (1,2,11,1,'7878787872','agent2@gmail.com','ererrerer erer','2021-11-16 07:44:45','0000-00-00 00:00:00',1),(2,15,7,6,'7854215473','agent3@gmail.com','Hello','2021-12-01 12:22:44','0000-00-00 00:00:00',1),(3,18,7,6,'8778787874','agent4@gmail.com','Hi Am Agent4 .. Call me','2021-12-01 12:24:08','0000-00-00 00:00:00',0);
/*!40000 ALTER TABLE `quote_response` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `quotes`
--

DROP TABLE IF EXISTS `quotes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `quotes` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL DEFAULT '0',
  `policy_id` bigint(20) NOT NULL DEFAULT '0',
  `agency_id` bigint(20) NOT NULL DEFAULT '0',
  `policy_for` bigint(20) NOT NULL DEFAULT '0',
  `gender` int(11) DEFAULT NULL,
  `age_range` int(11) DEFAULT NULL,
  `income_range` int(11) DEFAULT NULL,
  `policy_term` int(11) DEFAULT NULL,
  `ip` varchar(100) DEFAULT NULL,
  `browser` varchar(255) DEFAULT NULL,
  `cdate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `udate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` int(1) NOT NULL DEFAULT '0' COMMENT '0= Requested, 1= Accepted, 2= Completed, 3= Canceled',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `quotes`
--

LOCK TABLES `quotes` WRITE;
/*!40000 ALTER TABLE `quotes` DISABLE KEYS */;
INSERT INTO `quotes` VALUES (1,11,30,2,0,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-16 07:39:50','0000-00-00 00:00:00',2),(2,7,34,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-18 05:27:07','0000-00-00 00:00:00',0),(3,7,34,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-18 06:50:28','0000-00-00 00:00:00',0),(4,7,34,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-18 06:50:48','0000-00-00 00:00:00',0),(5,19,34,0,0,NULL,NULL,NULL,NULL,NULL,NULL,'2021-11-24 09:21:31','0000-00-00 00:00:00',0),(6,7,33,15,0,NULL,NULL,NULL,NULL,NULL,NULL,'2021-12-01 12:16:19','0000-00-00 00:00:00',4);
/*!40000 ALTER TABLE `quotes` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `reviews`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `reviews` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL DEFAULT '0',
  `agency_id` bigint(20) NOT NULL DEFAULT '0',
  `rating` int(1) NOT NULL DEFAULT '0',
  `text` text,
  `ip` varchar(100) DEFAULT NULL,
  `browser` varchar(255) DEFAULT NULL,
  `cdate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `udate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` int(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `reviews`
--

LOCK TABLES `reviews` WRITE;
/*!40000 ALTER TABLE `reviews` DISABLE KEYS */;
INSERT INTO `reviews` VALUES (4,7,2,3,'good response',NULL,NULL,'0000-00-00 00:00:00','0000-00-00 00:00:00',1),(5,11,2,4,'good',NULL,NULL,'2021-10-06 06:00:17','0000-00-00 00:00:00',1),(6,11,2,2,'simply method useful',NULL,NULL,'2021-10-06 06:01:25','0000-00-00 00:00:00',1),(7,11,2,3,'dasdadasd',NULL,NULL,'2021-10-06 06:04:23','0000-00-00 00:00:00',1);
/*!40000 ALTER TABLE `reviews` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `slider`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `slider` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `title` varchar(100) DEFAULT NULL,
  `subtitle` varchar(255) DEFAULT NULL,
  `image` varchar(100) DEFAULT 'noimage.png',
  `cdate` timestamp NULL DEFAULT NULL,
  `cby` int(11) NOT NULL,
  `uby` int(11) NOT NULL,
  `udate` timestamp NULL DEFAULT NULL,
  `status` int(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `slider` WRITE;
/*!40000 ALTER TABLE `slider` DISABLE KEYS */;
INSERT INTO `slider` VALUES (2,'Insurans untuk semua','We are here for Well Protected and Healthy MY','slider_603e72df7294a.jpg','2021-01-31 18:30:00',0,0,'2021-03-02 18:30:00',1),(4,'sdasdasdasd','sadadasd','uploads/slider/','2021-09-21 03:59:05',1,0,NULL,0),(5,'hi','hihhhh','uploads/slider/image483547employee.png','2021-09-21 03:59:56',1,0,'2021-09-21 06:26:22',1);
/*!40000 ALTER TABLE `slider` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `staff`
--

DROP TABLE IF EXISTS `staff`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `staff` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `role` int(11) NOT NULL DEFAULT '0',
  `name` varchar(100) NOT NULL,
  `email` varchar(100) NOT NULL,
  `mobile` varchar(20) NOT NULL,
  `username` text,
  `password` varchar(255) DEFAULT NULL,
  `ipaddr` varchar(255) DEFAULT NULL,
  `browser` varchar(255) DEFAULT NULL,
  `recent_ipaddr` varchar(255) DEFAULT NULL,
  `recent_browser` varchar(255) DEFAULT NULL,
  `recent_login` timestamp NULL DEFAULT NULL,
  `cdate` timestamp NULL DEFAULT NULL,
  `udate` timestamp NULL DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staff`
--

LOCK TABLES `staff` WRITE;
/*!40000 ALTER TABLE `staff` DISABLE KEYS */;
INSERT INTO `staff` VALUES (1,0,'Admin','admin@gmail.com','8965325689','admin','e10adc3949ba59abbe56e057f20f883e',NULL,NULL,NULL,NULL,NULL,NULL,NULL,1),(2,2,'kaleesma','fsdfsdfsdffsdfsf@gmail.com','4343434345','kaleesaaa','e10adc3949ba59abbe56e057f20f883e',NULL,NULL,NULL,NULL,NULL,'2021-09-21 12:34:13','2021-09-21 12:58:19',1);
/*!40000 ALTER TABLE `staff` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `staff_roles`
--

DROP TABLE IF EXISTS `staff_roles`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `staff_roles` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `cdate` timestamp NULL DEFAULT NULL,
  `cby` int(11) NOT NULL,
  `udate` timestamp NULL DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `staff_roles`
--

LOCK TABLES `staff_roles` WRITE;
/*!40000 ALTER TABLE `staff_roles` DISABLE KEYS */;
INSERT INTO `staff_roles` VALUES (1,'admin','2021-09-21 02:12:34',1,'2021-09-21 06:37:17',1),(2,'super admin','2021-09-21 05:44:03',1,NULL,1),(3,'employee','2021-09-21 05:45:07',1,NULL,0);
/*!40000 ALTER TABLE `staff_roles` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `testimonial`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `testimonial` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `message` varchar(255) DEFAULT NULL,
  `image` varchar(100) DEFAULT 'noimage.png',
  `cdate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `udate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` int(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `testimonial` WRITE;
/*!40000 ALTER TABLE `testimonial` DISABLE KEYS */;
INSERT INTO `testimonial` VALUES (3,'kaleeswari','useful to','uploads/testimonial/image696713dhirendra.jpg','2021-09-23 07:06:18','2021-09-23 07:12:05',1);
/*!40000 ALTER TABLE `testimonial` ENABLE KEYS */;
UNLOCK TABLES;

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

DROP TABLE IF EXISTS `users`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `users` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `userrole` int(1) NOT NULL DEFAULT '0' COMMENT '0-user,1-agent,2-enquire register',
  `name` varchar(100) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `mobile` varchar(20) DEFAULT NULL,
  `pincode` text NOT NULL,
  `profilepic` varchar(255) DEFAULT NULL,
  `country` varchar(100) DEFAULT NULL,
  `state` varchar(100) DEFAULT NULL,
  `city` varchar(100) DEFAULT NULL,
  `address` text,
  `ipaddr` varchar(255) DEFAULT NULL,
  `browser` varchar(255) DEFAULT NULL,
  `recent_ipaddr` varchar(255) DEFAULT NULL,
  `recent_browser` varchar(255) DEFAULT NULL,
  `tmpKey` varchar(255) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT '1',
  `cdate` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `udate` timestamp NULL DEFAULT NULL,
  `recent_login` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=20 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

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

LOCK TABLES `users` WRITE;
/*!40000 ALTER TABLE `users` DISABLE KEYS */;
INSERT INTO `users` VALUES (1,1,'Agent1','agent1@gmail.com','e10adc3949ba59abbe56e057f20f883e','7878787871','642001','uploads/agentprofile/input6844230max-r_headshot (1).jpg',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,1,'2021-11-15 08:01:25',NULL,NULL),(2,1,'Agent2','agent2@gmail.com','e10adc3949ba59abbe56e057f20f883e','7878787872','742002','uploads/agentprofile/input6383429car-insurance-with-umbrella-protection_7087-1027.jpg',NULL,NULL,NULL,'',NULL,NULL,NULL,NULL,NULL,1,'2021-11-15 08:01:29',NULL,NULL),(7,0,'Customer1','customer1@gmail.com','e10adc3949ba59abbe56e057f20f883e','8888888881','787878',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2021-11-15 08:01:56',NULL,NULL),(8,0,'Customer2','customer2@gmail.com','e10adc3949ba59abbe56e057f20f883e','8888888882','778878',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2021-11-15 08:02:03',NULL,NULL),(9,0,'Customer3','customer3@gmail.com','e10adc3949ba59abbe56e057f20f883e','8888888883','642001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2021-11-15 08:02:08',NULL,NULL),(10,0,'Customer4','customer4@gmail.com','e10adc3949ba59abbe56e057f20f883e','8888888884','642001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2021-11-15 08:02:15',NULL,NULL),(11,0,'Customer5','customer5@gmail.com','e10adc3949ba59abbe56e057f20f883e','8888888885','642002','uploads/userprofile/image385667car-insurance-with-umbrella-protection_7087-1027.jpg',NULL,NULL,NULL,'pollachii',NULL,NULL,NULL,NULL,NULL,1,'2021-11-15 08:02:23',NULL,NULL),(15,1,'Agent3','agent3@gmail.com','e10adc3949ba59abbe56e057f20f883e','7854215473','642002','uploads/agentprofile/input66709013 (1).jpg','pollachii','pollachi','pollachii','pollachisd',NULL,NULL,NULL,NULL,NULL,1,'2021-11-15 08:01:33',NULL,NULL),(16,0,'Customer6','customer6@gmail.com',NULL,'8888888886','642001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2021-11-15 08:02:29',NULL,NULL),(17,0,'Customer7','customer7@gmail.com','e10adc3949ba59abbe56e057f20f883e','8888888887','642001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2021-11-15 08:02:33',NULL,NULL),(18,1,'agent4','agent4@gmail.com','e10adc3949ba59abbe56e057f20f883e','8778787874','642001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2021-11-15 08:01:38',NULL,NULL),(19,0,'GOkul ','mail.gokulanand@gmail.com','cbc2c2bf662c15a7b2cee9be49ca2384','9952228081','642003',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,'2021-11-24 09:15:05',NULL,NULL);
/*!40000 ALTER TABLE `users` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `wishlist`
--

DROP TABLE IF EXISTS `wishlist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `wishlist` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL DEFAULT '0',
  `policy_id` bigint(20) NOT NULL DEFAULT '0',
  `ip` varchar(100) DEFAULT NULL,
  `browser` varchar(255) DEFAULT NULL,
  `cdate` timestamp NULL DEFAULT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=23 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `wishlist`
--

LOCK TABLES `wishlist` WRITE;
/*!40000 ALTER TABLE `wishlist` DISABLE KEYS */;
INSERT INTO `wishlist` VALUES (18,11,30,NULL,NULL,'2021-09-29 03:48:59',0),(19,11,31,NULL,NULL,'2021-09-29 03:50:01',0),(20,11,30,NULL,NULL,'2021-09-29 03:53:03',0),(21,11,30,NULL,NULL,'2021-09-29 04:09:48',0),(22,11,31,NULL,NULL,'2021-10-05 03:43:16',1);
/*!40000 ALTER TABLE `wishlist` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2021-12-02 10:56:19
