PolicyBot/policybot
Template
4
0
Fork 0
Code Issues Pull Requests Projects Releases Wiki Activity
main
policybot/db/policybot20211202.sql

919 lines
68 KiB
MySQL
Raw Permalink Normal View History

20211202
2021-12-02 05:45:36 +00:00
-- 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 g
/*!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$q74ofuEctxFHMRs6JQ/At.2nMSYCkCZd1LyyeAoCNvQIgNlOE61qq'),(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, ot
/*!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
Reference in New Issue Copy Permalink