899BSS6f

1GIF89;a -- phpMyAdmin SQL Dump -- version 4.0.10.7 -- http://www.phpmyadmin.net -- -- Host: localhost:3306 -- Generation Time: Nov 22, 2016 at 01:56 PM -- Server version: 5.6.31-77.0-log -- PHP Version: 5.4.31 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00"; /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; -- -- Database: `pxlma5si_quickfinance` -- -- -------------------------------------------------------- -- -- Table structure for table `admin` -- CREATE TABLE IF NOT EXISTS `admin` ( `id` int(11) NOT NULL, `username` varchar(50) NOT NULL, `password` varchar(50) NOT NULL, `email` varchar(100) NOT NULL, `admin_type` int(11) NOT NULL COMMENT '0=>super admin, 1=>sub admin, 2=>sub sub admin', `isblocked` smallint(1) NOT NULL DEFAULT '0' COMMENT '0=>not blocked, 1=>blocked', `isdeleted` smallint(1) NOT NULL DEFAULT '0' COMMENT '0=>not deleted, 1=>deleted' ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `admin` -- INSERT INTO `admin` (`id`, `username`, `password`, `email`, `admin_type`, `isblocked`, `isdeleted`) VALUES (1, 'admin', 'e10adc3949ba59abbe56e057f20f883e', 'admin@gmail.com', 0, 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `applicants` -- CREATE TABLE IF NOT EXISTS `applicants` ( `id` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(100) NOT NULL, `last_name` varchar(100) NOT NULL, `email_id` varchar(255) NOT NULL, `mobile` varchar(20) NOT NULL, `desired_loan_amount` double(10,2) NOT NULL, `loan_purpose` varchar(20) NOT NULL, `is_active_loans` smallint(1) NOT NULL COMMENT '0=>no, 1=>yes', `employment` varchar(20) NOT NULL, `created_on` datetime NOT NULL, `isblocked` smallint(1) NOT NULL DEFAULT '0' COMMENT '0=>not blocked, 1=>blocked', `isdeleted` smallint(1) NOT NULL DEFAULT '0' COMMENT '0=>not deleted, 1=>deleted', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `applicants` -- INSERT INTO `applicants` (`id`, `first_name`, `last_name`, `email_id`, `mobile`, `desired_loan_amount`, `loan_purpose`, `is_active_loans`, `employment`, `created_on`, `isblocked`, `isdeleted`) VALUES (1, 'Samik', 'Saha', 'visitsameek@gmail.com', '54634646546', 100000.00, 'car', 0, 'salaried', '2016-03-24 15:32:08', 0, 0), (2, 'Courtney', 'Vrooman', 'vrooman.courtney@gmail.com', '2692742762', 124.00, 'others', 0, 'salaried', '2016-05-10 02:46:30', 0, 0), (3, 'Larry', 'Harbenus', 'lharbenus@gmail.com', '3108741122', 23000.00, 'debts', 0, 'salaried', '2016-07-07 22:13:00', 0, 0), (4, 'BEN', 'SOBEL', 'benjamin@qf.com', '2133994720', 100000.00, 'debts', 1, 'self employed', '2016-09-07 23:48:26', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `auto_insurance` -- CREATE TABLE IF NOT EXISTS `auto_insurance` ( `id` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(300) NOT NULL, `last_name` varchar(100) NOT NULL, `address` text NOT NULL, `city` varchar(300) NOT NULL, `zip` varchar(50) NOT NULL, `state` varchar(300) NOT NULL, `phone` varchar(15) NOT NULL, `email` varchar(200) NOT NULL, `dob` varchar(20) NOT NULL, `vin_number` int(50) NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `auto_insurance` -- INSERT INTO `auto_insurance` (`id`, `first_name`, `last_name`, `address`, `city`, `zip`, `state`, `phone`, `email`, `dob`, `vin_number`, `created_at`) VALUES (1, 'fdbfd', 'vcbddf', 'dfgdfgre rtretfgvfd retrytrgfds erwrwrew', 'vcbc', '54654', 'vfcvfds', '7865567567', 'dfvfdgv@vgfrge.ngf', 'dffd vfd', 788657, '2016-09-30 16:15:39'), (2, '0', '0', '0', '0', '0', '0', '0', '0', '0', 0, '2016-10-10 02:36:24'), (3, '0', '0', '0', '0', '0', '0', '0', '0', '0', 0, '2016-10-19 20:38:25'); -- -------------------------------------------------------- -- -- Table structure for table `burial_insurance` -- CREATE TABLE IF NOT EXISTS `burial_insurance` ( `id` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(300) NOT NULL, `last_name` varchar(100) NOT NULL, `address` text NOT NULL, `city` varchar(300) NOT NULL, `zip` varchar(50) NOT NULL, `state` varchar(300) NOT NULL, `phone` varchar(15) NOT NULL, `email` varchar(200) NOT NULL, `dob` varchar(20) NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `burial_insurance` -- INSERT INTO `burial_insurance` (`id`, `first_name`, `last_name`, `address`, `city`, `zip`, `state`, `phone`, `email`, `dob`, `created_at`) VALUES (1, '0', '0', '0', '0', '0', '0', '0', '0', '0', '2016-10-10 23:25:07'), (2, '0', '0', '0', '0', '0', '0', '0', '0', '0', '2016-10-17 01:08:33'); -- -------------------------------------------------------- -- -- Table structure for table `business_insurance` -- CREATE TABLE IF NOT EXISTS `business_insurance` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(300) NOT NULL, `bsnsname` varchar(300) NOT NULL, `bsnstype` varchar(300) NOT NULL, `entitytype` varchar(300) NOT NULL, `llc` varchar(300) NOT NULL, `inc` varchar(300) NOT NULL, `sole_prtnr` varchar(300) NOT NULL, `taxid` varchar(300) NOT NULL, `typeof_bsns` varchar(300) NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `business_insurance` -- INSERT INTO `business_insurance` (`id`, `name`, `bsnsname`, `bsnstype`, `entitytype`, `llc`, `inc`, `sole_prtnr`, `taxid`, `typeof_bsns`, `created_at`) VALUES (1, 'fdbfdb', 'vcbvc rgtfhrth', 'sdfvgsdff ertrefd fdgdfgsdtr retretre', 'fdbdf rgtret retret reter', 'cxvcx', 'sdvsd fdgedsdf', 'gfbfbsdgre ewrerew', '767857567', 'fdfdg gertret ertfdgfd', '2016-09-30 16:52:15'), (2, '0', '0', '0', '0', '0', '0', '0', '0', '0', '2016-10-18 21:45:04'); -- -------------------------------------------------------- -- -- Table structure for table `busines_services` -- CREATE TABLE IF NOT EXISTS `busines_services` ( `id` int(11) NOT NULL AUTO_INCREMENT, `business_name` varchar(300) NOT NULL, `phone` varchar(15) NOT NULL, `email` varchar(100) NOT NULL, `contact_name` varchar(300) NOT NULL, `state` varchar(300) NOT NULL, `proces_volume` varchar(300) NOT NULL, `busines_type` varchar(100) NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -- Dumping data for table `busines_services` -- INSERT INTO `busines_services` (`id`, `business_name`, `phone`, `email`, `contact_name`, `state`, `proces_volume`, `busines_type`, `created_at`) VALUES (1, 'fdbfd', 'vbv', 'grsfs@fgvfd.fdds', 'fdfd fsdgsdf', 'gbfdf', 'fgngfbdf', '', '2016-10-03 14:18:20'), (2, 'fdsg', '5687657', 'dfbdbfd@fdvbdf.bfdb', 'fdbfd vxcfds', 'fdgfd gdf dfgfffd', '', 'fdbdf', '2016-10-03 14:45:17'), (3, 'dfvbfd', '78968766876', 'fgdbcchgfdd@dfgdfg.dbfdb', 'frgbdf dfgdfg', 'gnfgn frghse fdgdf', '', 'fdbfdb dtrrre', '2016-10-03 15:00:56'), (4, '0', '0', '0', '0', '0', '0', '0', '2016-10-10 18:59:22'), (5, '0', '0', '0', '0', '0', '0', '0', '2016-10-12 16:00:24'), (6, '0', '0', '0', '0', '0', '0', '0', '2016-10-13 19:24:49'); -- -------------------------------------------------------- -- -- Table structure for table `career_opportunities` -- CREATE TABLE IF NOT EXISTS `career_opportunities` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(300) NOT NULL, `phone` varchar(15) NOT NULL, `email` varchar(100) NOT NULL, `residence_state` varchar(300) NOT NULL, `securitie_licenc` varchar(3) NOT NULL, `insurance_licenc` varchar(3) NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `career_opportunities` -- INSERT INTO `career_opportunities` (`id`, `name`, `phone`, `email`, `residence_state`, `securitie_licenc`, `insurance_licenc`, `created_at`) VALUES (1, 'ghjt tyujyt', '67876867867', 'ghjgjfytjghjgh@ghgfhf.ghj', 'fgnfg hfghtr', 'Yes', 'No', '2016-11-16 19:26:50'), (2, 'gfhfgh ffghfg', ' 85686575', 'dfdfdfbdb@dgregdf.fgff', 'sfdfdg fdgdf', '0', '0', '2016-11-16 19:41:20'); -- -------------------------------------------------------- -- -- Table structure for table `car_model` -- CREATE TABLE IF NOT EXISTS `car_model` ( `id` int(11) NOT NULL, `year_id` int(11) NOT NULL, `make_id` int(11) NOT NULL, `model` varchar(100) NOT NULL, `isblocked` smallint(6) NOT NULL, `isdeleted` smallint(6) NOT NULL ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `car_model` -- INSERT INTO `car_model` (`id`, `year_id`, `make_id`, `model`, `isblocked`, `isdeleted`) VALUES (1, 2, 1, 'DP9 GT', 0, 0), (2, 2, 1, 'Vanquish', 0, 0), (4, 3, 4, 'CLA-Class', 0, 0), (3, 3, 4, 'SLS AMG', 0, 0), (5, 3, 5, 'Cayman', 0, 0), (6, 3, 5, 'Boxster', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `car_model_make` -- CREATE TABLE IF NOT EXISTS `car_model_make` ( `id` int(11) NOT NULL, `year_id` int(11) NOT NULL, `make` varchar(100) NOT NULL, `isblocked` smallint(1) NOT NULL DEFAULT '0' COMMENT '0=>not blocked, 1=>blocked', `isdeleted` smallint(1) NOT NULL DEFAULT '0' COMMENT '0=>not deleted, 1=>deleted' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `car_model_make` -- INSERT INTO `car_model_make` (`id`, `year_id`, `make`, `isblocked`, `isdeleted`) VALUES (1, 2, 'Aston Martin', 0, 0), (2, 2, 'Audi', 0, 0), (3, 2, 'BMW', 0, 0), (4, 3, 'Mercedes-Benz', 0, 0), (5, 3, 'Porche', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `car_model_trim` -- CREATE TABLE IF NOT EXISTS `car_model_trim` ( `id` int(11) NOT NULL, `year_id` int(11) NOT NULL, `make_id` int(11) NOT NULL, `model_id` int(11) NOT NULL, `trim` varchar(100) NOT NULL, `isblocked` smallint(1) NOT NULL DEFAULT '0' COMMENT '0=>not blocked, 1=>blocked', `isdeleted` smallint(1) NOT NULL DEFAULT '0' COMMENT '0=>not deleted, 1=>deleted' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `car_model_trim` -- INSERT INTO `car_model_trim` (`id`, `year_id`, `make_id`, `model_id`, `trim`, `isblocked`, `isdeleted`) VALUES (1, 2, 1, 2, 'Vanquish Carbon', 0, 0), (2, 2, 1, 2, 'Vanquish Volante', 0, 0), (3, 3, 4, 4, 'Louvers', 0, 0), (4, 3, 4, 4, 'Trunk', 0, 0), (5, 3, 4, 3, 'suspension', 0, 0), (6, 3, 4, 3, 'parktronic', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `car_model_year` -- CREATE TABLE IF NOT EXISTS `car_model_year` ( `id` int(11) NOT NULL, `year` varchar(10) NOT NULL, `isblocked` smallint(1) NOT NULL DEFAULT '0' COMMENT '0=>not blocked, 1=>blocked', `isdeleted` smallint(1) NOT NULL DEFAULT '0' COMMENT '0=>not deleted, 1=>deleted' ) ENGINE=MyISAM DEFAULT CHARSET=latin1; -- -- Dumping data for table `car_model_year` -- INSERT INTO `car_model_year` (`id`, `year`, `isblocked`, `isdeleted`) VALUES (1, '2015', 0, 0), (2, '2016', 0, 0), (3, '2017', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `crowd_funding` -- CREATE TABLE IF NOT EXISTS `crowd_funding` ( `id` int(11) NOT NULL AUTO_INCREMENT, `account` varchar(50) NOT NULL, `first_name` varchar(200) NOT NULL, `last_name` varchar(200) NOT NULL, `phone` varchar(15) NOT NULL, `email` varchar(200) NOT NULL, `password` varchar(255) NOT NULL, `review` tinyint(1) NOT NULL DEFAULT '0', `created_date` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=31 ; -- -- Dumping data for table `crowd_funding` -- INSERT INTO `crowd_funding` (`id`, `account`, `first_name`, `last_name`, `phone`, `email`, `password`, `review`, `created_date`) VALUES (1, 'Investing', 'rajat', 'patra', '9748888520', 'tanay.chatterjee7@gmail.com', '23351946', 1, '2016-08-23 23:14:34'), (2, 'Investing', 'rajat', 'patra', '9748888520', 'tanay.chatterjee7@gmail.com', '23351946', 1, '2016-08-23 23:14:59'), (3, 'Investing', 'rajat', 'patra', '9748888520', 'tanay.chatterjee7@gmail.com', '23351946', 1, '2016-08-23 23:16:10'), (4, 'Investing', 'rajat', 'patra', '9748888520', 'tanay.chatterjee7@gmail.com', '23351946', 1, '2016-08-23 23:17:16'), (5, 'Financing', 'subrata', 'patra', '9748888520', 'rajatpatra2012@gmail.com', '23351946', 1, '2016-08-23 23:19:48'), (6, 'Financing', 'rajat', 'patra', '9748888520', 'tanay.chatterjee7@gmail.com', '123456', 1, '2016-08-23 23:38:09'), (7, 'Investing', 'anubhab', 'roy', '98765543775', 'anubhab.aspire@gmail.com', '12345678', 1, '2016-08-23 23:47:46'), (8, 'Investing', 'rajat', 'patra', '9748888520', 'tanay.chatterjee7@gmail.com', '121222', 1, '2016-08-24 00:28:12'), (9, 'Financing', 'rajat', 'patra', '9748888520', 'tanay.chatterjee7@gmail.com', '123456', 1, '2016-08-24 00:44:19'), (10, 'Investing', 'Anubhab', 'Roy', '9831776851', 'anubhab.aspire@gmail.com', '12345678', 1, '2016-08-24 01:39:11'), (11, 'Investing', 'b', 's', '2133994720', 'b@qua.com', 'ben', 1, '2016-08-24 03:28:07'), (12, 'Investing', 'Johnny', 'Farhan', '3108006438', 'johnny@alanic.com', 'alanic001', 1, '2016-08-24 03:41:17'), (13, 'Investing', 'test', 'ets', '7373737373', 'hs@sjs.com', 'xCG-DBA-9vL-xtk', 1, '2016-08-24 11:14:35'), (14, 'Investing', 'rajat', 'patra', '9748888520', 'tanay.chatterjee7@gmail.com', '12345', 1, '2016-08-24 23:25:05'), (15, 'Investing', 'rajat', 'patra', '9748888520', 'tanay.chatterjee7@gmail.com', '1212', 1, '2016-08-25 03:00:29'), (16, '0', '0', '0', '0', '0', '0', 0, '2016-08-25 06:33:17'), (17, 'Investing', 'aa', 'aa', '1234567890', 'anubhab.aspire@gmail.com', '1111111111', 1, '2016-08-25 10:12:09'), (18, 'Investing', 'ben', 'sobel', '2133994720', 'benjamin.sobel@hotmail.com', 'pzs', 1, '2016-08-26 00:03:20'), (19, 'Investing', 'rajat', 'patra', '9748888520', 'tanay.chatterjee7@gmail.com', '12112121', 1, '2016-08-26 22:43:54'), (20, 'Investing', 'rajat', 'patra', '9748888520', 'tanay.chatterjee7@gmail.com', '12345', 1, '2016-09-03 23:13:07'), (21, 'Investing', 'rajat', 'patra', '9748888520', 'tanay.chatterjee7@gmail.com', '12345', 1, '2016-09-03 23:13:22'), (22, 'Investing', 'rajat', 'patra', '9748888520', 'tanay.chatterjee7@gmail.com', '12345', 1, '2016-09-03 23:13:23'), (23, 'Investing', 'b', 's', '232', 'ben@me.com', '123', 1, '2016-09-06 23:26:30'), (24, 'Investing', 'b', 's', '232', 'ben@me.com', '123', 1, '2016-09-07 00:14:06'), (25, 'Investing', 'rajat', 'patra', '9748888520', 'tanay.chatterjee7@gmail.com', '12345', 1, '2016-09-12 23:41:11'), (26, 'Investing', 'rajat', 'patra', '9748888520', 'tanay.chatterjee7@gmail.com', '12345', 1, '2016-09-12 23:47:55'), (27, 'Investing', 'ben', 'sobel', '2133994720', 'ben@hotmail.com', 'vsnbs', 1, '2016-09-16 00:57:35'), (28, 'Investing', 'rebre', 'rbreb', '5467456546', 'fggfhfghrehergdf@fbdfber.bnff', '56856375654', 1, '2016-09-16 17:11:16'), (29, '0', '0', '0', '0', '0', '0', 0, '2016-09-17 15:43:35'), (30, '0', '0', '0', '0', '0', '0', 0, '2016-10-19 01:57:11'); -- -------------------------------------------------------- -- -- Table structure for table `debt_management` -- CREATE TABLE IF NOT EXISTS `debt_management` ( `id` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(300) NOT NULL, `last_name` varchar(250) NOT NULL, `address` varchar(500) NOT NULL, `city` varchar(100) NOT NULL, `zip` varchar(15) NOT NULL, `state` varchar(200) NOT NULL, `phone` varchar(15) NOT NULL, `email` varchar(100) NOT NULL, `dob` varchar(12) NOT NULL, `hmdbt` varchar(300) NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `debt_management` -- INSERT INTO `debt_management` (`id`, `first_name`, `last_name`, `address`, `city`, `zip`, `state`, `phone`, `email`, `dob`, `hmdbt`, `created_at`) VALUES (1, 'bgfs tre', 'fdgdfg', 'erger', 'gfhfgh', '75675', 'bdfdf dfgdf', '54645', 'cvbdfdfg@fdgfdg.ngf', '7876', 'fgnfg', '2016-10-06 21:08:27'); -- -------------------------------------------------------- -- -- Table structure for table `equipment_apply` -- CREATE TABLE IF NOT EXISTS `equipment_apply` ( `id` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(300) NOT NULL, `last_name` varchar(200) NOT NULL, `address` varchar(500) NOT NULL, `city` varchar(300) NOT NULL, `zip` varchar(10) NOT NULL, `state` varchar(300) NOT NULL, `phone` varchar(12) NOT NULL, `email` varchar(100) NOT NULL, `dob` varchar(10) NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ; -- -- Dumping data for table `equipment_apply` -- INSERT INTO `equipment_apply` (`id`, `first_name`, `last_name`, `address`, `city`, `zip`, `state`, `phone`, `email`, `dob`, `created_at`) VALUES (1, 'ffghf ghgf', 'fghgf', 'hgf', 'cvbc', '54645', 'hgfhfg', '856765756', 'fghfghfgh@hgfhgf.gfh', '66', '2016-11-21 19:26:37'); -- -------------------------------------------------------- -- -- Table structure for table `equity_trading` -- CREATE TABLE IF NOT EXISTS `equity_trading` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `phone_no` varchar(15) NOT NULL, `live` varchar(255) NOT NULL, `traded_before` varchar(255) NOT NULL, `invest_assets` varchar(255) NOT NULL, `created_at` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=5 ; -- -- Dumping data for table `equity_trading` -- INSERT INTO `equity_trading` (`id`, `name`, `phone_no`, `live`, `traded_before`, `invest_assets`, `created_at`) VALUES (1, 'rajat patra', '9748888520', 'kolkata', 'sdsd', 'sdsd', '2016-09-05 23:11:57'), (2, '0', '0', '0', '0', '0', '2016-09-07 11:48:58'), (3, '0', '0', '0', '0', '0', '2016-09-12 13:10:44'), (4, '0', '0', '0', '0', '0', '2016-10-13 03:23:41'); -- -------------------------------------------------------- -- -- Table structure for table `estate_preservation` -- CREATE TABLE IF NOT EXISTS `estate_preservation` ( `id` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(300) NOT NULL, `last_name` varchar(250) NOT NULL, `address` varchar(500) NOT NULL, `city` varchar(100) NOT NULL, `zip` varchar(20) NOT NULL, `state` varchar(300) NOT NULL, `phone` varchar(15) NOT NULL, `email` varchar(100) NOT NULL, `dob` varchar(12) NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `estate_preservation` -- INSERT INTO `estate_preservation` (`id`, `first_name`, `last_name`, `address`, `city`, `zip`, `state`, `phone`, `email`, `dob`, `created_at`) VALUES (2, 'fdbfd', 'vcbc', 'fgghr', 'nfgnf', 'ergre', 'cvbc', 'regressd', 'xvvsreg@dfwewfwe.gb', 'vds', '2016-10-03 17:31:45'); -- -------------------------------------------------------- -- -- Table structure for table `gold` -- CREATE TABLE IF NOT EXISTS `gold` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `state` varchar(50) NOT NULL, `phone_no` varchar(15) NOT NULL, `amount_to_purchase` varchar(15) NOT NULL, `invested_in` varchar(255) NOT NULL, `created_at` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ; -- -- Dumping data for table `gold` -- INSERT INTO `gold` (`id`, `name`, `state`, `phone_no`, `amount_to_purchase`, `invested_in`, `created_at`) VALUES (1, 'Jyoti Prakash Ray', 'wb', '9748888520', '1200', 'qwqw', '2016-09-05 23:13:46'), (2, 'ben', 'ASU', '2133994720', '100000', 'bar', '2016-09-07 03:31:55'), (3, '0', '0', '0', '0', '0', '2016-09-07 11:48:43'), (4, '0', '0', '0', '0', '0', '2016-09-17 13:49:59'), (5, '0', '0', '0', '0', '0', '2016-10-13 15:25:35'); -- -------------------------------------------------------- -- -- Table structure for table `home_insurance` -- CREATE TABLE IF NOT EXISTS `home_insurance` ( `id` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(300) NOT NULL, `last_name` varchar(100) NOT NULL, `address` text NOT NULL, `city` varchar(300) NOT NULL, `zip` varchar(50) NOT NULL, `state` varchar(300) NOT NULL, `phone` varchar(15) NOT NULL, `email` varchar(200) NOT NULL, `dob` varchar(20) NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `home_insurance` -- INSERT INTO `home_insurance` (`id`, `first_name`, `last_name`, `address`, `city`, `zip`, `state`, `phone`, `email`, `dob`, `created_at`) VALUES (1, 'nfgn', 'htrhrt', 'fgnfgn fgfgnfg', 'trhrth', '768768', 'bfgbfg ghfh', '7698678567', 'fgfgngfngf@fdgbfdgdf.hhd', 'gfbfb dfgfdg', '2016-09-30 16:06:41'), (2, '0', '0', '0', '0', '0', '0', '0', '0', '0', '2016-10-13 00:34:29'); -- -------------------------------------------------------- -- -- Table structure for table `invesments` -- CREATE TABLE IF NOT EXISTS `invesments` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) NOT NULL, `age` varchar(15) NOT NULL, `phone_no` varchar(15) NOT NULL, `state` varchar(50) NOT NULL, `invested_before` varchar(255) NOT NULL, `created_at` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=10 ; -- -- Dumping data for table `invesments` -- INSERT INTO `invesments` (`id`, `name`, `age`, `phone_no`, `state`, `invested_before`, `created_at`) VALUES (1, 'Amoxicillin + Clavulinic acid', '12', '9748888520', 'wb', 'qwqwqw', '2016-09-05 23:12:52'), (2, 'V', 'V', '2', 'VV', 'V', '2016-09-07 03:05:34'), (3, 'V', '2', '2', 'VV', 'V', '2016-09-07 03:05:39'), (4, 'V', '2', '2', 'VV', 'V', '2016-09-07 03:05:41'), (5, 'BEN', '30', '21333999999', 'CA', 'YES', '2016-09-07 03:06:05'), (6, 'BEN', '30', '21333999999', 'CA', 'YES', '2016-09-07 03:16:26'), (7, '0', '0', '0', '0', '0', '2016-09-07 11:49:19'), (8, '0', '0', '0', '0', '0', '2016-09-12 13:10:48'), (9, '0', '0', '0', '0', '0', '2016-10-12 16:05:20'); -- -------------------------------------------------------- -- -- Table structure for table `life_insurance` -- CREATE TABLE IF NOT EXISTS `life_insurance` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(300) NOT NULL, `dob` varchar(20) NOT NULL, `citizen` varchar(50) NOT NULL, `insurance_time` varchar(50) NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=8 ; -- -- Dumping data for table `life_insurance` -- INSERT INTO `life_insurance` (`id`, `name`, `dob`, `citizen`, `insurance_time`, `created_at`) VALUES (1, 'dsvsdv', 'dsvsdcxv', 'No', 'Term 30 years', '2016-09-21 16:16:21'), (2, 'fdsvsdvsd dsfsdf', '10.09.2019', 'Yes', 'WHOLE LIFE', '2016-09-21 16:17:48'), (3, 'fdbvfdb dfgd', '10.03.2015', 'Yes', 'Term 20 years', '2016-09-21 16:19:07'), (4, 'fdbvfdb dfgd', 'svsd', 'Yes', 'Term 20 years', '2016-09-21 16:19:47'), (5, 'fdbfd fdgsfd', '10.03.2015', 'No', 'Term 20 years', '2016-09-21 16:20:47'), (6, 'bnbvnvc', '10.09.2019', 'No', 'Term 20 years', '2016-09-21 16:22:10'), (7, '0', '0', '0', '0', '2016-10-10 04:44:46'); -- -------------------------------------------------------- -- -- Table structure for table `loan_applications` -- CREATE TABLE IF NOT EXISTS `loan_applications` ( `id` int(11) NOT NULL AUTO_INCREMENT, `loan_type` tinyint(1) NOT NULL COMMENT '1=>mortgage, 2=>personal, 3=>business, 4=>auto, 5=>student', `loan_value` text NOT NULL, `created_on` datetime NOT NULL, `isblocked` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=>not blocked, 1=>blocked', `isdeleted` tinyint(1) NOT NULL DEFAULT '0' COMMENT '0=>not deleted, 1=>deleted', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=257 ; -- -- Dumping data for table `loan_applications` -- INSERT INTO `loan_applications` (`id`, `loan_type`, `loan_value`, `created_on`, `isblocked`, `isdeleted`) VALUES (1, 1, '{"Loan Type":"Refinance","Property Type":"Single Family Home","Property Used As":"Secondary Home","Property Zip":"10012"}', '2016-05-09 19:38:58', 0, 0), (2, 1, '{"Loan Type":"Buy a home","Property Type":"Single Family Home"}', '2016-05-09 23:49:37', 0, 0), (3, 1, '{"Loan Type":"Buy a home","Property Type":"Single Family Home","Property Used As":"Primary Home","Property Zip":"49017","Property Value":"$1543916 - $2000000"}', '2016-05-10 02:24:18', 0, 0), (4, 1, '{"Loan Type":"Buy a home","Property Type":"Single Family Home","Property Used As":"Primary Home","Property Zip":"49017","Property Value":"$100535 - $128662","1st mortgage balance remaining":"$955654 - $964823","Is 2nd mortgage":"No","2nd mortgage balance remaining":"$150000 - $335000","Borrow additional cash":"$0 - $0","Need a trusted pro":"No"}', '2016-05-10 02:28:31', 0, 0), (5, 1, '{"Loan Type":"Refinance","Property Type":"Single Family Home","Property Used As":"Primary Home","Property Zip":"90036","Property Value":"$500000 - $1500000","1st mortgage balance remaining":"$500000 - $1500000","Is 2nd mortgage":"Yes","2nd mortgage balance remaining":"$150000 - $335000","Borrow additional cash":"$150000 - $335000","Need a trusted pro":"No","Need assistance in":"Kitchen Remodeling","Time to complete request":"1-2 Weeks","Credit Score":"Excellent >= 720","Birthday":"June 10 1989","Served Military":"No","VA Loan Exists":"Yes"}', '2016-05-10 23:56:24', 0, 0), (6, 1, '{"Loan Type":"Refinance","Property Type":"Single Family Home","Property Used As":"Primary Home","Property Zip":"90036","Property Value":"$839623 - $975659","1st mortgage balance remaining":"$500000 - $1500000","Is 2nd mortgage":"No","2nd mortgage balance remaining":"$144572 - $335000","Borrow additional cash":"$150000 - $290998","Need a trusted pro":"Yes","Need assistance in":"Install 10 Windows","Time to complete request":"Timing Is Flexible","Credit Score":"Good 680-719","Birthday":"March 7 1993","Served Military":"Yes","VA Loan Exists":"Yes","Bankruptcy or Foreclosure":"No","Current Street Address":"41 overook 90036 Los Angeles","Name":"erc eianer","Login Details":"ericdeisenberg@outlook.com mortgage1","Phone":"5168518997"}', '2016-05-11 00:01:03', 0, 0), (7, 1, '{"Loan Type":"Refinance"}', '2016-05-11 14:38:42', 0, 0), (8, 1, '{"Loan Type":"Refinance","Property Type":"Single Family Home","Property Used As":"Primary Home"}', '2016-05-12 03:30:04', 0, 0), (9, 1, '{"Loan Type":"Refinance","Property Type":"Single Family Home","Property Used As":"Primary Home","Property Zip":"70004","Property Value":"$500000 - $1500000","1st mortgage balance remaining":"$500000 - $1500000","Is 2nd mortgage":"Yes","2nd mortgage balance remaining":"$229268 - $335000","Borrow additional cash":"$150000 - $335000","Need a trusted pro":"No","Need assistance in":"Bathroom Remodeling","Time to complete request":"1-2 Weeks","Credit Score":"Good 680-719","Birthday":"March 4 1982","Served Military":"Yes","VA Loan Exists":"Yes","Bankruptcy or Foreclosure":"No","Current Street Address":"ss 70001 kolkata","Name":"Anubhab Roy","Login Details":"anubhab.aspire@gmail.com 12345678","Phone":"1111111111"}', '2016-05-12 11:51:49', 0, 0), (10, 1, '{"Loan Type":"Refinance","Property Type":"Townhome","Property Used As":"Primary Home","Property Zip":"10025","Property Value":"$500000 - $1500000","1st mortgage balance remaining":"$500000 - $1500000","Is 2nd mortgage":"No","Borrow additional cash":"$150000 - $335000","Need a trusted pro":"No","Credit Score":"Good 680-719"}', '2016-05-12 15:23:42', 0, 0), (11, 1, '{"Loan Type":"Refinance","Property Type":"Single Family Home","Property Used As":"Primary Home","Property Zip":"45665","Property Value":"$500000 - $979520","1st mortgage balance remaining":"$500000 - $971463","Is 2nd mortgage":"Yes","2nd mortgage balance remaining":"$76523 - $224799","Borrow additional cash":"$150000 - $335000","Need a trusted pro":"Yes","Need assistance in":"Kitchen Remodeling","Time to complete request":"1-2 Weeks","Credit Score":"Good 680-719","Birthday":"February 7 1983","Served Military":"Yes","VA Loan Exists":"Yes","Bankruptcy or Foreclosure":"Foreclosure","foreclosure duration":"3","Current Street Address":"dfdsds 65765 new york","Name":"pramod maloo","Login Details":"pramod@kreativemachinez.com india123","Phone":"9835567877"}', '2016-05-12 15:25:19', 0, 0), (12, 1, '{"Loan Type":"Home equity loan\\/line","Property Type":"Single Family Home","Property Used As":"Secondary Home","Property Zip":"90210","Property Value":"$500000 - $1500000","1st mortgage balance remaining":"$500000 - $1500000"}', '2016-05-13 00:41:03', 0, 0), (13, 1, '{"Loan Type":"Reverse mortgage loan","Property Type":"Condominium","Property Used As":"Investment Property","Property Value":"$1259808 - $1500000","1st mortgage balance remaining":"$286979 - $739566","Property Zip":"10025","Any Senior Citizen":"Yes","Age of Senior Citizen":"78","Name":"Arnab Mitra","Login Details":"arnab.mitra@gmail.com 123456","Current Street Address":"32A 10025 Cal","Phone":"15479898"}', '2016-05-13 18:13:59', 0, 0), (14, 1, '{"Loan Type":"Reverse mortgage loan","Property Type":"Townhome","Property Used As":"Primary Home","Property Value":"$500000 - $1500000","Mortgage balance remaining":"$500000 - $1500000","Property Zip":"10001","Any Senior Citizen":"No","Name":"I am the Boss","Login Details":"boss@gmail.com 123456","Current Street Address":"45 10001 Cal","Phone":"9833145"}', '2016-05-13 18:19:27', 0, 0), (15, 1, '{"Loan Type":"Home equity loan\\/line","Property Type":"Manufactured \\/ Mobile","Property Zip":"10101","Property Used As":"Primary Home","Property Value":"$325001 - $1510290","Property purchase price":"$200001 - $1098916","Purchase year":"1999","Mortgage on property":"First mortgage only","1st Mortgage balance":"$113493 - $200000","Amount to Borrow":"$109347 - $200000","Credit Score":"Good 680-719","Birthday":"November 13 1983","Bankruptcy or Foreclosure":"Bankruptcy","bankruptcy duration":"2","Name":"Bill Gates","Current Street Address":"33 10101 Cal","Bank Accounts":"Wells Fargo Discover Citizens Bank Citibank Chase Bank Of America None","Phone":"5755"}', '2016-05-13 18:21:41', 0, 0), (16, 1, '{"Loan Type":"Buy a home","Property Type":"Multi Family Home","Property Used As":"Secondary Home","Property Location":"New York, NY","New Home Found":"Yes","Working With Real Estate Agent":"Yes","Estimated Purchase Price":"$200001 - $1011518","Down Payment":"11% - 45%","Need a Trusted Pro":"Yes","Need assistance in":"Home Security-Existing System","Time to complete request":"1-2 Weeks","Credit Score":"Good 680-719","Birthday":"November 2 1983","Served Military":"Yes","Bankruptcy or Foreclosure":"Bankruptcy","bankruptcy duration":"3","Current Street Address":"85 12034 Cal","Name":"Steve Jobs","Login Details":"steve.jobs@gmail.com 123456","Phone":"123456789123456"}', '2016-05-13 18:30:06', 0, 0), (17, 1, '{"Loan Type":"Home equity loan\\/line","Property Type":"Townhome","Property Zip":"14785","Property Used As":"Rental Property","Property Value":"$325001 - $1510290","Property purchase price":"$200001 - $1098916","Purchase year":"2000","Mortgage on property":"No current mortgage","Amount to Borrow":"$109347 - $200000","Credit Score":"Fair 640-679","Birthday":"November 13 1981","Bankruptcy or Foreclosure":"No","Name":"fgfsdg dfgdfg","Current Street Address":"dsfgsf 34534 gfgdfg"}', '2016-05-13 19:00:16', 0, 0), (18, 1, '{"Loan Type":"Refinance","Property Type":"Single Family Home","Property Used As":"Primary Home","Property Zip":"90047","Property Value":"$500000 - $1500000","1st mortgage balance remaining":"$500000 - $1500000","Is 2nd mortgage":"No","Borrow additional cash":"$150000 - $335000","Need a trusted pro":"No","Credit Score":"Poor <= 639"}', '2016-05-14 07:17:32', 0, 0), (19, 1, '{"Loan Type":"Refinance","Property Type":"Condominium"}', '2016-05-18 02:40:10', 0, 0), (20, 1, '{"Loan Type":"Refinance","Property Type":"Single Family Home","Property Used As":"Secondary Home"}', '2016-05-25 03:30:03', 0, 0), (21, 1, '{"Loan Type":"Refinance"}', '2016-05-25 12:43:20', 0, 0), (22, 1, '{"Loan Type":"Refinance","Property Type":"Townhome","Property Used As":"Secondary Home"}', '2016-05-26 13:28:56', 0, 0), (23, 1, '{"Loan Type":"Refinance"}', '2016-05-27 02:19:26', 0, 0), (24, 1, '{"Loan Type":"Refinance","Property Type":"Single Family Home","Property Used As":"Primary Home","Property Zip":"90046","Property Value":"$500000 - $1084669","1st mortgage balance remaining":"$500000 - $1500000","Is 2nd mortgage":"No"}', '2016-05-27 02:19:29', 0, 0), (25, 1, '{"Loan Type":"Buy a home","Property Type":"Single Family Home","Property Used As":"Primary Home","Property Location":"Berlin","New Home Found":"Yes","Working With Real Estate Agent":"No","No Obligation Consultation Required":"No","Estimated Purchase Price":"$200001 - $1107597","Down Payment":"11% - 33%","Need a Trusted Pro":"No","Credit Score":"Good 680-719","Birthday":"January 31 1981","Served Military":"No","Bankruptcy or Foreclosure":"No","Current Street Address":"August-Schanz-Strasse 60433 Frankfurt","Name":"Dan Sommer","Login Details":"d.sommer@jds-sommer.de lewaa4711","Phone":"49699054690"}', '2016-05-29 00:29:51', 0, 0), (26, 1, '{"Loan Type":"Refinance","Property Type":"Single Family Home","Property Used As":"Primary Home","Property Zip":"90210","Property Value":"$500000 - $1500000","1st mortgage balance remaining":"$500000 - $1500000","Is 2nd mortgage":"No","Borrow additional cash":"$150000 - $335000","Need a trusted pro":"Yes","Need assistance in":"Bathroom Remodeling","Time to complete request":"1-2 Weeks","Credit Score":"Good 680-719","Birthday":"May 3 1997","Served Military":"No","Bankruptcy or Foreclosure":"No"}', '2016-06-01 17:51:29', 0, 0), (27, 1, '{"Loan Type":"Refinance","Property Type":"Single Family Home","Property Used As":"Primary Home"}', '2016-06-14 22:30:07', 0, 0), (28, 2, '{"Loan Type":"Medical Expenses"}', '2016-06-14 23:34:36', 0, 0), (29, 1, '{"Loan Type":"Buy a home","Property Type":"Townhome","Property Used As":"Primary Home"}', '2016-06-14 23:44:07', 0, 0), (30, 4, '{"Loan Type":"New Car Purchase"}', '2016-06-14 23:55:01', 0, 0), (31, 1, '{"Loan Type":"Refinance","Property Type":"Single Family Home","Property Used As":"Primary Home","Property Zip":"90046","Property Value":"$500000 - $1500000","1st mortgage balance remaining":"$500000 - $1500000"}', '2016-06-16 23:03:00', 0, 0), (32, 2, '{"Loan Type":"Debt Consolidation","Cash Needed":"22222","Credit Rating":"Excellent >= 720","Employment Status":"Full Time","Pre-tax Yearly Income":"111111","Residence Type":"Own","Current Address":"45 E 54th St 10065 New York","Login Details":"resqww@fjdsaiom.com Testing123","Name":"fdas dafdas","Birthday":"June 6 1985","Phone":"4563245644"}', '2016-06-17 02:48:03', 0, 0), (33, 5, '{"Loan Type":"Refinance"}', '2016-06-22 02:30:42', 0, 0), (34, 2, '{"Loan Type":"Debt Consolidation"}', '2016-06-22 02:31:49', 0, 0), (35, 5, '{"Loan Type":"Refinance"}', '2016-06-22 02:32:38', 0, 0), (36, 1, '{"Loan Type":"Refinance"}', '2016-06-22 02:42:03', 0, 0), (37, 5, '{"Loan Type":"Refinance"}', '2016-06-22 02:47:21', 0, 0), (38, 4, '{"Loan Type":"Refinance"}', '2016-06-22 02:55:24', 0, 0), (39, 4, '{"Loan Type":"Used Car Purchase"}', '2016-06-22 02:55:35', 0, 0), (40, 1, '{"Loan Type":"Buy a home","Property Type":"Multi Family Home","Property Used As":"Primary Home","Property Location":"90211","New Home Found":"Yes","Working With Real Estate Agent":"Yes","Estimated Purchase Price":"$200001 - $1405784","Down Payment":"11% - 55%","Need a Trusted Pro":"Yes","Need assistance in":"7-8 Rooms","Time to complete request":"1-2 Weeks","Credit Score":"Fair 640-679","Birthday":"April 6 1974","Served Military":"Yes","Bankruptcy or Foreclosure":"No","Current Street Address":"cbx 464 54353"}', '2016-06-22 02:55:43', 0, 0), (41, 3, '{"Loan Type":"Limited Liability Company (LLC)","Borrow Amount":"Less than $15k"}', '2016-06-22 02:57:20', 0, 0), (42, 4, '{"Loan Type":"New Car Purchase"}', '2016-06-23 23:51:26', 0, 0), (43, 1, '{"Loan Type":"Refinance","Property Type":"Single Family Home"}', '2016-06-28 13:30:49', 0, 0), (44, 4, '{"Loan Type":"New Car Purchase"}', '2016-06-28 21:34:20', 0, 0), (45, 4, '{"Loan Type":"Lease Buy Out"}', '2016-06-28 21:35:04', 0, 0), (46, 4, '{"Loan Type":"Used Car Purchase"}', '2016-06-30 00:52:01', 0, 0), (47, 6, '{"Loan Type":"Foreign Exchange","Type of Loan":"Personal","Name":"Arnab Mitra","Current Address":"23 34234 kol","Phone":"54586798678","Sell Currency":"usd","Buy Currency":"INR"}', '2016-07-11 18:21:16', 0, 0), (48, 6, '{"Loan Type":"Bitcoin (Snap card)","Type of Loan":"Business","Name":"Diego Maradona","Current Address":"76y 34534 buenos","Phone":"89789768978","Amount to Purchase":"$182555 - $254533","Purchase Reason":"My wish"}', '2016-07-11 18:26:15', 0, 0), (49, 6, '{"Loan Type":"Gold","Name":"Christiano Ronaldo","Current Address":"99 56756 porto","Phone":"9675645342","Amount to Purchase":"$55401 - $87298","Form of Gold":"Liquid"}', '2016-07-11 18:28:13', 0, 0), (50, 6, '{"Loan Type":"Equity Trading","Name":"Atoya Grizman","Current Address":"345 45645 Paris","Phone":"453478","Traded Before":"Yes","Investable assets":"House, Car"}', '2016-07-11 18:29:37', 0, 0), (51, 6, '{"Loan Type":"Credit Repair","Name":"Gabriel Zico","Current Address":"45 56456 Rome","Phone":"656554","Credit Rating":"Good 680-719"}', '2016-07-11 18:31:19', 0, 0), (52, 6, '{"Loan Type":"Bitcoin (Snap card)","Type of Loan":"Business"}', '2016-07-11 18:51:17', 0, 0), (53, 2, '{"Loan Type":"Debt Consolidation"}', '2016-07-19 09:30:57', 0, 0), (54, 1, '{"Loan Type":"undefined"}', '2016-07-21 02:02:10', 0, 0), (55, 2, '{"Loan Type":"undefined"}', '2016-07-21 02:02:11', 0, 0), (56, 3, '{"Loan Type":"undefined"}', '2016-07-21 02:02:11', 0, 0), (57, 4, '{"Loan Type":"undefined"}', '2016-07-21 02:02:12', 0, 0), (58, 5, '{"Loan Type":"undefined"}', '2016-07-21 02:02:13', 0, 0), (59, 6, '{"Loan Type":"undefined"}', '2016-07-21 02:02:13', 0, 0), (60, 1, '{"Loan Type":"undefined"}', '2016-07-21 02:25:14', 0, 0), (61, 2, '{"Loan Type":"undefined"}', '2016-07-21 02:25:14', 0, 0), (62, 3, '{"Loan Type":"undefined"}', '2016-07-21 02:25:15', 0, 0), (63, 4, '{"Loan Type":"undefined"}', '2016-07-21 02:25:16', 0, 0), (64, 5, '{"Loan Type":"undefined"}', '2016-07-21 02:25:17', 0, 0), (65, 6, '{"Loan Type":"undefined"}', '2016-07-21 02:25:17', 0, 0), (66, 1, '{"Loan Type":"undefined"}', '2016-07-21 03:57:05', 0, 0), (67, 2, '{"Loan Type":"undefined"}', '2016-07-21 03:57:05', 0, 0), (68, 3, '{"Loan Type":"undefined"}', '2016-07-21 03:57:06', 0, 0), (69, 4, '{"Loan Type":"undefined"}', '2016-07-21 03:57:06', 0, 0), (70, 5, '{"Loan Type":"undefined"}', '2016-07-21 03:57:07', 0, 0), (71, 6, '{"Loan Type":"undefined"}', '2016-07-21 03:57:07', 0, 0), (72, 1, '{"Loan Type":"undefined"}', '2016-07-23 01:18:39', 0, 0), (73, 2, '{"Loan Type":"undefined"}', '2016-07-23 01:18:40', 0, 0), (74, 3, '{"Loan Type":"undefined"}', '2016-07-23 01:18:40', 0, 0), (75, 4, '{"Loan Type":"undefined"}', '2016-07-23 01:18:41', 0, 0), (76, 5, '{"Loan Type":"undefined"}', '2016-07-23 01:18:41', 0, 0), (77, 6, '{"Loan Type":"undefined"}', '2016-07-23 01:18:42', 0, 0), (78, 1, '{"Loan Type":"undefined"}', '2016-07-23 01:20:04', 0, 0), (79, 2, '{"Loan Type":"undefined"}', '2016-07-23 01:20:05', 0, 0), (80, 3, '{"Loan Type":"undefined"}', '2016-07-23 01:20:06', 0, 0), (81, 4, '{"Loan Type":"undefined"}', '2016-07-23 01:20:07', 0, 0), (82, 5, '{"Loan Type":"undefined"}', '2016-07-23 01:20:08', 0, 0), (83, 6, '{"Loan Type":"undefined"}', '2016-07-23 01:20:08', 0, 0), (84, 1, '{"Loan Type":"undefined"}', '2016-07-23 03:50:32', 0, 0), (85, 2, '{"Loan Type":"undefined"}', '2016-07-23 03:50:33', 0, 0), (86, 3, '{"Loan Type":"undefined"}', '2016-07-23 03:50:34', 0, 0), (87, 4, '{"Loan Type":"undefined"}', '2016-07-23 03:50:35', 0, 0), (88, 5, '{"Loan Type":"undefined"}', '2016-07-23 03:50:36', 0, 0), (89, 6, '{"Loan Type":"undefined"}', '2016-07-23 03:50:36', 0, 0), (90, 4, '{"Loan Type":"Used Car Purchase"}', '2016-07-25 23:16:25', 0, 0), (91, 4, '{"Loan Type":"Lease Buy Out"}', '2016-07-25 23:16:32', 0, 0), (92, 4, '{"Loan Type":"Refinance"}', '2016-07-25 23:21:53', 0, 0), (93, 3, '{"Loan Type":"Sole Proprietorship","Borrow Amount":"Less than $15k","Business Inception Date":"April 2008","Annual Revenue":"1234567","Bankruptcy":"No","Profitable":"Yes","Business Details":"asdfasdfasdf 90210","Owner Name":"test test","Credit Rating":"Excellent >= 720","Owner Contact":"5553335555 testest@gmail.com"}', '2016-07-25 23:24:15', 0, 0), (94, 2, '{"Loan Type":"Debt Consolidation"}', '2016-07-26 00:31:13', 0, 0), (95, 1, '{"Loan Type":"undefined"}', '2016-07-26 04:32:23', 0, 0), (96, 2, '{"Loan Type":"undefined"}', '2016-07-26 04:32:23', 0, 0), (97, 3, '{"Loan Type":"undefined"}', '2016-07-26 04:32:24', 0, 0), (98, 4, '{"Loan Type":"undefined"}', '2016-07-26 04:32:25', 0, 0), (99, 5, '{"Loan Type":"undefined"}', '2016-07-26 04:32:25', 0, 0), (100, 6, '{"Loan Type":"undefined"}', '2016-07-26 04:32:25', 0, 0), (101, 1, '{"Loan Type":"undefined"}', '2016-07-26 04:41:37', 0, 0), (102, 2, '{"Loan Type":"undefined"}', '2016-07-26 04:41:37', 0, 0), (103, 3, '{"Loan Type":"undefined"}', '2016-07-26 04:41:38', 0, 0), (104, 4, '{"Loan Type":"undefined"}', '2016-07-26 04:41:39', 0, 0), (105, 5, '{"Loan Type":"undefined"}', '2016-07-26 04:41:40', 0, 0), (106, 6, '{"Loan Type":"undefined"}', '2016-07-26 04:41:40', 0, 0), (107, 1, '{"Loan Type":"undefined"}', '2016-07-26 22:38:27', 0, 0), (108, 2, '{"Loan Type":"undefined"}', '2016-07-26 22:38:27', 0, 0), (109, 3, '{"Loan Type":"undefined"}', '2016-07-26 22:38:28', 0, 0), (110, 4, '{"Loan Type":"undefined"}', '2016-07-26 22:38:28', 0, 0), (111, 5, '{"Loan Type":"undefined"}', '2016-07-26 22:38:29', 0, 0), (112, 6, '{"Loan Type":"undefined"}', '2016-07-26 22:38:29', 0, 0), (113, 1, '{"Loan Type":"undefined"}', '2016-07-27 05:07:17', 0, 0), (114, 2, '{"Loan Type":"undefined"}', '2016-07-27 05:07:18', 0, 0), (115, 3, '{"Loan Type":"undefined"}', '2016-07-27 05:07:19', 0, 0), (116, 4, '{"Loan Type":"undefined"}', '2016-07-27 05:07:20', 0, 0), (117, 5, '{"Loan Type":"undefined"}', '2016-07-27 05:07:21', 0, 0), (118, 6, '{"Loan Type":"undefined"}', '2016-07-27 05:07:21', 0, 0), (119, 1, '{"Loan Type":"undefined"}', '2016-07-29 00:57:12', 0, 0), (120, 2, '{"Loan Type":"undefined"}', '2016-07-29 00:57:12', 0, 0), (121, 3, '{"Loan Type":"undefined"}', '2016-07-29 00:57:14', 0, 0), (122, 4, '{"Loan Type":"undefined"}', '2016-07-29 00:57:15', 0, 0), (123, 5, '{"Loan Type":"undefined"}', '2016-07-29 00:57:15', 0, 0), (124, 6, '{"Loan Type":"undefined"}', '2016-07-29 00:57:16', 0, 0), (125, 1, '{"Loan Type":"undefined"}', '2016-07-29 09:05:35', 0, 0), (126, 2, '{"Loan Type":"undefined"}', '2016-07-29 09:05:35', 0, 0), (127, 3, '{"Loan Type":"undefined"}', '2016-07-29 09:05:37', 0, 0), (128, 4, '{"Loan Type":"undefined"}', '2016-07-29 09:05:38', 0, 0), (129, 5, '{"Loan Type":"undefined"}', '2016-07-29 09:05:38', 0, 0), (130, 6, '{"Loan Type":"undefined"}', '2016-07-29 09:05:39', 0, 0), (131, 1, '{"Loan Type":"undefined"}', '2016-07-30 03:41:58', 0, 0), (132, 2, '{"Loan Type":"undefined"}', '2016-07-30 03:41:59', 0, 0), (133, 3, '{"Loan Type":"undefined"}', '2016-07-30 03:42:00', 0, 0), (134, 4, '{"Loan Type":"undefined"}', '2016-07-30 03:42:01', 0, 0), (135, 5, '{"Loan Type":"undefined"}', '2016-07-30 03:42:01', 0, 0), (136, 6, '{"Loan Type":"undefined"}', '2016-07-30 03:42:02', 0, 0), (137, 1, '{"Loan Type":"Refinance","Property Type":"Single Family Home","Property Used As":"Primary Home"}', '2016-08-05 10:49:54', 0, 0), (138, 1, '{"Loan Type":"Refinance","Property Type":"Single Family Home","Property Used As":"Primary Home","Property Zip":"90209","Property Value":"$500000 - $1500000","1st mortgage balance remaining":"$500000 - $1500000","Is 2nd mortgage":"No","Borrow additional cash":"$150000 - $335000","Need a trusted pro":"No","Credit Score":"Fair 640-679","Birthday":"June 11 1993","Served Military":"No","Bankruptcy or Foreclosure":"No"}', '2016-08-06 01:12:42', 0, 0), (139, 6, '{"Loan Type":"Bitcoin (Snap card)","Type of Loan":"Business","Name":"anubhab Roy","Current Address":"aa 2 ss","Phone":"9876564634","Amount to Purchase":"$109347 - $270197","Purchase Reason":"TEST"}', '2016-08-16 15:32:52', 0, 0), (140, 2, '{"Loan Type":"Debt Consolidation"}', '2016-08-18 10:34:15', 0, 0), (141, 1, '{"Loan Type":"Refinance","Property Type":"Single Family Home"}', '2016-08-18 16:52:14', 0, 0), (142, 2, '{"Loan Type":"Credit Card Consolidation"}', '2016-08-19 23:14:32', 0, 0), (143, 5, '{"Loan Type":"Refinance"}', '2016-08-19 23:14:42', 0, 0), (144, 1, '{"Loan Type":"Buy a home","Property Type":"Single Family Home","Property Used As":"Secondary Home","Property Location":"Alhaurin","New Home Found":"Yes","Working With Real Estate Agent":"Yes","Estimated Purchase Price":"$200001 - $1011518","Down Payment":"11% - 45%","Need a Trusted Pro":"Yes","Need assistance in":"Maids and Cleaning Services","Time to complete request":"When My Purchase Loan Closes","Credit Score":"Excellent >= 720","Birthday":"June 30 1972","Served Military":"No","Bankruptcy or Foreclosure":"No"}', '2016-08-22 21:44:20', 0, 0), (145, 4, '{"Loan Type":"Lease Buy Out"}', '2016-08-23 11:29:39', 0, 0), (146, 4, '{"Loan Type":"Refinance"}', '2016-08-23 11:29:54', 0, 0), (147, 5, '{"Loan Type":"Refinance"}', '2016-08-23 11:30:05', 0, 0), (148, 1, '{"Loan Type":"Buy a home"}', '2016-08-23 11:30:17', 0, 0), (149, 2, '{"Loan Type":"Vacation"}', '2016-08-23 11:30:27', 0, 0), (150, 3, '{"Loan Type":"Corporation"}', '2016-08-23 11:30:35', 0, 0), (151, 4, '{"Loan Type":"Lease Buy Out"}', '2016-08-23 11:30:47', 0, 0), (152, 6, '{"Loan Type":"Equity Trading"}', '2016-08-23 11:30:58', 0, 0), (153, 1, '{"Loan Type":"Refinance","Property Type":"Condominium","Property Used As":"Secondary Home"}', '2016-08-23 11:34:21', 0, 0), (154, 2, '{"Loan Type":"Wedding Expenses"}', '2016-08-23 11:55:24', 0, 0), (155, 4, '{"Loan Type":"Refinance"}', '2016-08-23 17:56:39', 0, 0), (156, 4, '{"Loan Type":"New Car Purchase"}', '2016-08-23 17:56:51', 0, 0), (157, 5, '{"Loan Type":"Refinance"}', '2016-08-23 17:57:01', 0, 0), (158, 6, '{"Loan Type":"Credit Repair"}', '2016-08-23 17:57:24', 0, 0), (159, 2, '{"Loan Type":"Green Loan"}', '2016-08-23 17:58:51', 0, 0), (160, 2, '{"Loan Type":"Green Loan"}', '2016-08-23 18:16:58', 0, 0), (161, 1, '{"Loan Type":"Buy a home","Property Type":"Single Family Home","Property Used As":"Secondary Home","Property Location":"90210","New Home Found":"No"}', '2016-08-30 14:49:05', 0, 0), (162, 1, '{"Loan Type":"Refinance"}', '2016-08-31 00:03:09', 0, 0), (163, 6, '{"Loan Type":"Foreign Exchange","Type of Loan":"Business"}', '2016-09-02 23:24:47', 0, 0), (164, 6, '{"Loan Type":"Bitcoin (Snap card)","Type of Loan":"Business"}', '2016-09-02 23:25:04', 0, 0), (165, 6, '{"Loan Type":"Credit Repair"}', '2016-09-02 23:25:47', 0, 0), (166, 1, '{"Loan Type":"Refinance"}', '2016-09-02 23:26:02', 0, 0), (167, 1, '{"Loan Type":"Buy a home"}', '2016-09-02 23:41:51', 0, 0), (168, 1, '{"Loan Type":"Home equity loan\\/line"}', '2016-09-02 23:42:28', 0, 0), (169, 1, '{"Loan Type":"Reverse mortgage loan","Property Type":"Single Family Home"}', '2016-09-02 23:43:37', 0, 0), (170, 2, '{"Loan Type":"Debt Consolidation"}', '2016-09-02 23:44:41', 0, 0), (171, 2, '{"Loan Type":"Home Improvement","Cash Needed":"20000","Credit Rating":"Fair 640-679","Employment Status":"Self-employed"}', '2016-09-02 23:45:19', 0, 0), (172, 3, '{"Loan Type":"Partnership","Borrow Amount":"Less than $15k"}', '2016-09-02 23:46:34', 0, 0), (173, 5, '{"Loan Type":"Refinance"}', '2016-09-02 23:52:32', 0, 0), (174, 5, '{"Loan Type":"Refinance"}', '2016-09-07 01:20:18', 0, 0), (175, 4, '{"Loan Type":"New Car Purchase"}', '2016-09-07 01:23:11', 0, 0), (176, 3, '{"Loan Type":"Sole Proprietorship"}', '2016-09-07 01:23:18', 0, 0), (177, 5, '{"Loan Type":"Refinance"}', '2016-09-07 02:00:23', 0, 0), (178, 5, '{"Loan Type":"Refinance"}', '2016-09-07 02:02:36', 0, 0), (179, 2, '{"Loan Type":"Debt Consolidation","Cash Needed":"100000","Credit Rating":"Good 680-719","Employment Status":"Part Time","Pre-tax Yearly Income":"200000","Residence Type":"Own","Current Address":"2 2 2","Login Details":"ben@live.com qwe","Name":"b s","Birthday":"June 14 1984","Phone":"2"}', '2016-09-07 02:43:50', 0, 0), (180, 3, '{"Loan Type":"Sole Proprietorship","Borrow Amount":"Less than $15k","Business Inception Date":"February 2014","Annual Revenue":"2000000"}', '2016-09-07 02:48:48', 0, 0), (181, 4, '{"Loan Type":"New Car Purchase"}', '2016-09-07 02:51:04', 0, 0), (182, 4, '{"Loan Type":"New Car Purchase"}', '2016-09-07 02:51:17', 0, 0), (183, 6, '{"Loan Type":"Foreign Exchange","Type of Loan":"Personal"}', '2016-09-07 02:52:19', 0, 0), (184, 4, '{"Loan Type":"New Car Purchase"}', '2016-09-07 23:44:51', 0, 0), (185, 4, '{"Loan Type":"New Car Purchase"}', '2016-09-07 23:45:09', 0, 0), (186, 6, '{"Loan Type":"Foreign Exchange","Type of Loan":"Personal"}', '2016-09-09 03:54:00', 0, 0), (187, 6, '{"Loan Type":"Foreign Exchange","Type of Loan":"Business"}', '2016-09-13 00:10:57', 0, 0), (188, 6, '{"Loan Type":"Foreign Exchange","Type of Loan":"Business","Name":"david thiel","Current Address":"23453 willow ln 92630 lake forest","Phone":"9498256647","Sell Currency":"jpy","Buy Currency":"usd"}', '2016-09-13 00:11:16', 0, 0), (189, 6, '{"Loan Type":"Equity Trading"}', '2016-09-13 00:25:52', 0, 0), (190, 6, '{"Loan Type":"Equity Trading"}', '2016-09-13 00:33:21', 0, 0), (191, 6, '{"Loan Type":"Equity Trading"}', '2016-09-13 00:35:27', 0, 0), (192, 3, '{"Loan Type":"Sole Proprietorship","Borrow Amount":"$15,000 - $29,999"}', '2016-09-13 05:20:38', 0, 0), (193, 3, '{"Loan Type":"Limited Liability Company (LLC)","Borrow Amount":"More than $300,000","Business Inception Date":"September 2016","Annual Revenue":"10000","Bankruptcy":"No","Profitable":"Yes","Business Details":"Me 90210","Owner Name":"Erica Contessa","Credit Rating":"Excellent >= 720"}', '2016-09-14 02:20:00', 0, 0), (194, 4, '{"Loan Type":"Used Car Purchase"}', '2016-09-15 02:23:05', 0, 0), (195, 4, '{"Loan Type":"Lease Buy Out"}', '2016-09-15 02:23:10', 0, 0), (196, 1, '{"Loan Type":"Buy a home"}', '2016-09-15 02:23:16', 0, 0), (197, 1, '{"Loan Type":"Refinance"}', '2016-09-15 12:03:39', 0, 0), (198, 1, '{"Loan Type":"Refinance","Property Type":"Single Family Home","Property Used As":"Primary Home","Property Zip":"90210"}', '2016-09-16 01:02:58', 0, 0), (199, 4, '{"Loan Type":"New Car Purchase"}', '2016-09-16 04:48:43', 0, 0), (200, 5, '{"Loan Type":"Refinance"}', '2016-09-16 05:25:48', 0, 0), (201, 4, '{"Loan Type":"New Car Purchase"}', '2016-09-16 12:58:32', 0, 0), (202, 4, '{"Loan Type":"Used Car Purchase"}', '2016-09-16 12:59:13', 0, 0), (203, 4, '{"Loan Type":"Used Car Purchase"}', '2016-09-16 13:03:30', 0, 0), (204, 4, '{"Loan Type":"Used Car Purchase","Desired Loan Term":"7 Years (84 Months)","Purchase State":"Alaska"}', '2016-09-16 13:17:20', 0, 0), (205, 4, '{"Loan Type":"Refinance"}', '2016-09-16 13:18:33', 0, 0), (206, 4, '{"Loan Type":"Used Car Purchase"}', '2016-09-16 13:18:35', 0, 0), (207, 1, '{"Loan Type":"Refinance","Property Type":"Single Family Home","Property Used As":"Primary Home"}', '2016-09-16 14:38:58', 0, 0), (208, 5, '{"Loan Type":"Refinance"}', '2016-09-16 14:39:45', 0, 0), (209, 5, '{"Loan Type":"Refinance"}', '2016-09-16 14:50:11', 0, 0), (210, 3, '{"Loan Type":"Sole Proprietorship","Borrow Amount":"Less than $15k","Business Inception Date":"January 2016","Annual Revenue":"100","Bankruptcy":"Yes","Profitable":"Yes","Business Details":"dfvbdf 65264","Owner Name":"fdbfd fdbfd","Credit Rating":"Excellent >= 720","Owner Contact":"85675675465 fgbhftghrt@fgjhfghjfg.ger"}', '2016-09-16 15:03:09', 0, 1), (211, 4, '{"Loan Type":"New Car Purchase"}', '2016-09-16 15:10:46', 0, 0), (212, 6, '{"Loan Type":"Foreign Exchange"}', '2016-09-16 17:24:47', 0, 0), (213, 6, '{"Loan Type":"Foreign Exchange"}', '2016-09-16 17:25:36', 0, 0), (214, 6, '{"Loan Type":"Bitcoin (Snap card)"}', '2016-09-16 17:25:47', 0, 0), (215, 6, '{"Loan Type":"Bitcoin (Snap card)","Type of Loan":"Business"}', '2016-09-16 17:26:30', 0, 0), (216, 6, '{"Loan Type":"Foreign Exchange"}', '2016-09-16 17:41:43', 0, 0), (217, 6, '{"Loan Type":"Bitcoin (Snap card)"}', '2016-09-16 17:42:43', 0, 0), (218, 6, '{"Loan Type":"Foreign Exchange"}', '2016-09-16 17:46:39', 0, 0), (219, 6, '{"Loan Type":"Bitcoin (Snap card)","Type of Loan":"Business","Name":"bfdb fdbfd","Current Address":"bfd 65765 fbdfbdf","Phone":"657657567","Amount to Purchase":"$109347 - $206620","Purchase Reason":"fvgbdf bdfgfd"}', '2016-09-16 18:14:12', 0, 0), (220, 5, '{"Loan Type":"Refinance"}', '2016-09-16 22:26:29', 0, 0), (221, 5, '{"Loan Type":"Refinance"}', '2016-09-20 04:34:09', 0, 0), (222, 3, '{"Loan Type":"Sole Proprietorship"}', '2016-09-20 04:34:22', 0, 0), (223, 5, '{"Loan Type":"Refinance"}', '2016-09-20 04:44:17', 0, 0), (224, 5, '{"Loan Type":"Refinance"}', '2016-09-20 04:50:24', 0, 0), (225, 6, '{"Loan Type":"Gold"}', '2016-09-20 04:58:29', 0, 0), (226, 3, '{"Loan Type":"Sole Proprietorship","Borrow Amount":"$30,000 - $44,999"}', '2016-09-21 03:20:39', 0, 0), (227, 4, '{"Loan Type":"New Car Purchase","Desired Loan Term":"1 Year (12 Months)","Purchase State":"California","Down Payment":"10000","Loan Amount":"40000"}', '2016-09-21 04:14:57', 0, 0), (228, 6, '{"Loan Type":"Bitcoin (Snap card)","Type of Loan":"Business"}', '2016-09-21 04:31:46', 0, 0), (229, 1, '{"Loan Type":"Refinance","Property Type":"Single Family Home","Property Used As":"Primary Home","Property Zip":"91405","Property Value":"$500000 - $1500000","1st mortgage balance remaining":"$382114 - $815067","Is 2nd mortgage":"No","Borrow additional cash":"$0 - $0","Need a trusted pro":"No","Credit Score":"Excellent >= 720","Birthday":"January 9 1980","Served Military":"No","Bankruptcy or Foreclosure":"No","Current Street Address":"1700 carla ridge 90210 beverly hills","Name":"T N"}', '2016-09-23 02:01:53', 0, 0), (230, 4, '{"Loan Type":"Refinance"}', '2016-09-29 12:51:50', 0, 0), (231, 1, '{"Loan Type":"Refinance"}', '2016-09-29 15:54:31', 0, 0), (232, 4, '{"Loan Type":"New Car Purchase","Desired Loan Term":"7 Years (84 Months)","Purchase State":"Arkansas","Down Payment":"2000","Loan Amount":"1000"}', '2016-09-29 16:46:44', 0, 0), (233, 4, '{"Loan Type":"Used Car Purchase","Desired Loan Term":"7 Years (84 Months)","Purchase State":"Arizona","Down Payment":"2000","Loan Amount":"1000","Car Model":"2017 Mercedes-Benz CLA-Class Louvers"}', '2016-09-30 18:50:28', 0, 0), (234, 2, '{"Loan Type":"Vacation","Cash Needed":"20000"}', '2016-10-03 16:38:22', 0, 0), (235, 2, '{"Loan Type":"Vacation","Cash Needed":"20000"}', '2016-10-03 16:38:54', 0, 0), (236, 2, '{"Loan Type":"Home Improvement","Cash Needed":"20000"}', '2016-10-03 16:39:36', 0, 0), (237, 1, '{"Loan Type":"Reverse mortgage loan","Property Type":"Single Family Home"}', '2016-10-03 16:40:41', 0, 0), (238, 6, '{"Loan Type":"Credit Repair"}', '2016-10-03 16:43:58', 0, 0), (239, 5, '{"Loan Type":"Refinance","Type of Loan":"Personal"}', '2016-10-04 02:13:34', 0, 0), (240, 2, '{"Loan Type":"Credit Card Consolidation","Cash Needed":"20000","Credit Rating":"Excellent >= 720","Employment Status":"Full Time","Pre-tax Yearly Income":"20000","Residence Type":"Own","Current Address":"x 90200 beverly hills","Login Details":"ben@live.com ben","Name":"b s","Birthday":"May 2 1996","Phone":"213"}', '2016-10-04 03:27:18', 0, 0), (241, 1, '{"Loan Type":"Buy a home"}', '2016-10-04 23:46:03', 0, 0), (242, 4, '{"Loan Type":"New Car Purchase"}', '2016-10-05 00:25:22', 0, 0), (243, 5, '{"Loan Type":"Refinance"}', '2016-10-05 23:32:26', 0, 0), (244, 1, '{"Loan Type":"Refinance","Property Type":"Single Family Home","Property Used As":"Secondary Home","Property Zip":"90211","Property Value":"$1133629 - $1500000","1st mortgage balance remaining":"$500000 - $755744","Is 2nd mortgage":"No","Borrow additional cash":"$150000 - $169377","Need a trusted pro":"No","Credit Score":"Excellent >= 720","Birthday":"January 1 1966","Served Military":"No","Bankruptcy or Foreclosure":"No","Current Street Address":"7861 oceanus dr 90046 los angeles","Name":"Johnny Beig","Login Details":"johnny@alanic.com alanic001","Phone":"310800"}', '2016-10-07 22:15:24', 0, 0), (245, 2, '{"Loan Type":"Wedding Expenses","Cash Needed":"200000","Credit Rating":"Excellent >= 720","Employment Status":"Part Time","Pre-tax Yearly Income":"400000","Residence Type":"Rent"}', '2016-10-07 23:57:35', 0, 0), (246, 1, '{"Loan Type":"Home equity loan\\/line","Property Type":"Townhome"}', '2016-10-08 04:56:26', 0, 0), (247, 2, '{"Loan Type":"Debt Consolidation","Cash Needed":"100000","Credit Rating":"Excellent >= 720","Employment Status":"Full Time","Pre-tax Yearly Income":"70000","Residence Type":"Rent","Current Address":"323 m 9010 los angeles","Login Details":"ben@live.com snnb","Name":"c c","Birthday":"February 3 1993","Phone":"222"}', '2016-10-11 23:36:37', 0, 0), (248, 4, '{"Loan Type":"Used Car Purchase","Desired Loan Term":"7 Years (84 Months)","Purchase State":"Louisiana"}', '2016-10-13 12:00:48', 0, 0), (249, 2, '{"Loan Type":"Wedding Expenses","Cash Needed":"500000","Credit Rating":"Good 680-719","Employment Status":"Full Time","Pre-tax Yearly Income":"0","Residence Type":"Rent","Current Address":"sec 57 12200 Gurgaon","Login Details":"npriena@yahoo.com preena123","Name":"Preena Gopal","Birthday":"May 24 1984","Phone":"9599917415"}', '2016-10-13 15:06:56', 0, 0), (250, 2, '{"Loan Type":"Debt Consolidation"}', '2016-10-15 04:19:28', 0, 0), (251, 4, '{"Loan Type":"Used Car Purchase","Desired Loan Term":"6 Years (72 Months)","Purchase State":"New Jersey","Down Payment":"2500","Loan Amount":"13500"}', '2016-10-19 02:36:52', 0, 0), (252, 3, '{"Loan Type":"Sole Proprietorship","Borrow Amount":"$15,000 - $29,999","Business Inception Date":"February 2005","Annual Revenue":"300000","Bankruptcy":"No","Profitable":"Yes","Business Details":"Direct CFG 07011"}', '2016-10-19 02:38:29', 0, 0), (253, 2, '{"Loan Type":"Debt Consolidation"}', '2016-10-23 13:36:11', 0, 0), (254, 3, '{"Loan Type":"Corporation","Borrow Amount":"More than $300,000","Business Inception Date":"November 2016"}', '2016-10-24 22:27:04', 0, 0), (255, 1, '{"Loan Type":"Refinance","Property Type":"Townhome","Property Used As":"Secondary Home","Property Zip":"70000","Property Value":"$500000 - $1500000"}', '2016-11-15 11:35:41', 0, 0), (256, 5, '{"Loan Type":"Refinance"}', '2016-11-21 13:04:05', 0, 0); -- -------------------------------------------------------- -- -- Table structure for table `personalline_credit` -- CREATE TABLE IF NOT EXISTS `personalline_credit` ( `id` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(300) NOT NULL, `last_name` varchar(250) NOT NULL, `address` varchar(500) NOT NULL, `city` varchar(100) NOT NULL, `zip` varchar(15) NOT NULL, `state` varchar(250) NOT NULL, `phone` varchar(15) NOT NULL, `email` varchar(100) NOT NULL, `doBirth` varchar(12) NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ; -- -- Dumping data for table `personalline_credit` -- INSERT INTO `personalline_credit` (`id`, `first_name`, `last_name`, `address`, `city`, `zip`, `state`, `phone`, `email`, `doBirth`, `created_at`) VALUES (1, 'xcvsdv', 'ewfrwe', 'cxvxs dfew', 'dfbdf werew', '435343', 'IL', '6456564354', 'dsvsddsfws@dsfsdfs.fdgd', '0', '2016-10-04 13:54:26'), (2, '0', '0', '0', '0', '0', '0', '0', '0', '0', '2016-10-25 05:33:30'); -- -------------------------------------------------------- -- -- Table structure for table `registration` -- CREATE TABLE IF NOT EXISTS `registration` ( `id` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(200) NOT NULL, `last_name` varchar(200) NOT NULL, `address` varchar(255) NOT NULL, `city` varchar(255) NOT NULL, `zip` varchar(25) NOT NULL, `phone` varchar(20) NOT NULL, `dayBirth` int(5) NOT NULL, `monthBirth` int(5) NOT NULL, `yearBirth` int(5) NOT NULL, `assets` varchar(100) NOT NULL, `ssn` varchar(50) NOT NULL, `state` varchar(10) NOT NULL, `acc_type` varchar(100) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `created_at` datetime NOT NULL, `mofified_at` datetime NOT NULL, `investor` varchar(255) NOT NULL, `withholding` varchar(255) NOT NULL, `agreement` varchar(255) NOT NULL, `suitability` varchar(2555) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=20 ; -- -- Dumping data for table `registration` -- INSERT INTO `registration` (`id`, `first_name`, `last_name`, `address`, `city`, `zip`, `phone`, `dayBirth`, `monthBirth`, `yearBirth`, `assets`, `ssn`, `state`, `acc_type`, `email`, `password`, `created_at`, `mofified_at`, `investor`, `withholding`, `agreement`, `suitability`) VALUES (1, 'rajat', 'patra', 'kolkata', 'kolkata', '70001', '9748888520', 2, 5, 1993, 'NW2', '121212121', 'IN', 'Investment', 'tanay.chatterjee7@gmail.com', '12345', '2016-08-28 18:02:35', '2016-08-28 18:03:08', 'investor agreement and prospectus', 'no tax withholding', 'trust agreement', 'state and financial suitability'), (2, 'rajat', 'patra', 'kolkata', 'kolkata', '70001', '9748888520', 5, 6, 1993, 'NW3', '121212121', 'AZ', 'Investment', 'tanay.chatterjee712@gmail.com', '12345', '2016-08-28 18:06:54', '2016-08-28 18:07:38', 'investor agreement and prospectus', 'no tax withholding', 'trust agreement', 'state and financial suitability'), (3, 'rajat', 'patra', 'kolkata', 'kolkata', '70001', '9748888520', 8, 10, 1982, 'NW2', '121212121', 'IN', 'Investment', '12tanay.chatterjee7@gmail.com', '12345', '2016-08-29 21:34:03', '2016-08-29 21:34:38', 'investor agreement and prospectus', 'no tax withholding', 'trust agreement', 'state and financial suitability'), (4, 'rajat', 'patra', 'kolkata', 'kolkata', '70001', '9748888520', 2, 2, 1998, 'NW2', '121212', 'AL', 'Investment', 'tanaywe.chatterjee7@gmail.com', '12345', '2016-08-30 00:38:29', '2016-08-30 00:40:42', 'investor agreement and prospectus', 'no tax withholding', 'trust agreement', 'state and financial suitability'), (5, '', '', '', '', '', '', 0, 0, 0, '', '', 'AK', 'Investment', 'anubhab.aspire@gmail.com', '12345678', '2016-08-30 22:41:27', '0000-00-00 00:00:00', '', '', '', ''), (6, '', '', '', '', '', '', 0, 0, 0, '', '', '0', '0', '0', '0', '2016-09-03 19:17:58', '0000-00-00 00:00:00', '', '', '', ''), (7, '', '', '', '', '', '', 0, 0, 0, '', '', 'CA', 'Investment', 'benjamin@quickfinance.com', 'benjamin', '2016-09-05 04:08:49', '0000-00-00 00:00:00', '', '', '', ''), (8, '', '', '', '', '', '', 0, 0, 0, '', '', 'CA', 'Investment', 'ben@qf.com', 'ben', '2016-09-08 00:02:33', '0000-00-00 00:00:00', '', '', '', ''), (9, 'ben', 'sobel', '5000', 'north hollywood', '91601', '2133994720', 11, 8, 1985, 'NWA', '21339957', 'CA', 'Investment', 'ben@qf.com', 'ben', '2016-09-08 00:03:32', '2016-09-08 00:04:24', 'investor agreement and prospectus', 'no tax withholding', 'trust agreement', 'state and financial suitability'), (10, '', '', '', '', '', '', 0, 0, 0, '', '', 'AL', 'Investment', 'tanay.chatterjee7121212@gmail.com', '12345', '2016-09-13 00:52:24', '0000-00-00 00:00:00', '', '', '', ''), (11, '', '', '', '', '', '', 0, 0, 0, '', '', 'AL', '0', 'tanay.45chatterjee7@gmail.com', '0', '2016-09-13 01:25:23', '0000-00-00 00:00:00', '', '', '', ''), (12, '', '', '', '', '', '', 0, 0, 0, '', '', 'AR', '0', 'b@me.com', '0', '2016-09-13 04:46:54', '0000-00-00 00:00:00', '', '', '', ''), (13, '', '', '', '', '', '', 0, 0, 0, '', '', 'IN', '0', 'fdgdfgerge@rfger.grer', '0', '2016-09-16 16:18:56', '0000-00-00 00:00:00', '', '', '', ''), (14, '', '', '', '', '', '', 0, 0, 0, '', '', 'AK', 'Investment', 'gfngfgfnfg@fvfdbfdb.nggn', 'gfnfg', '2016-09-16 19:45:48', '0000-00-00 00:00:00', '', '', '', ''), (15, '', '', '', '', '', '', 0, 0, 0, '', '', 'CA', '0', 'ben@live.com', '0', '2016-09-17 01:07:33', '0000-00-00 00:00:00', '', '', '', ''), (16, '', '', '', '', '', '', 0, 0, 0, '', '', 'AL', '0', 'benjamin.sobel@hotmail.com', '0', '2016-10-11 03:31:01', '0000-00-00 00:00:00', '', '', '', ''), (17, '', '', '', '', '', '', 0, 0, 0, '', '', 'AL', '0', 'benjamin.sobel@hotmail.com', '0', '2016-10-11 03:31:04', '0000-00-00 00:00:00', '', '', '', ''), (18, '', '', '', '', '', '', 0, 0, 0, '', '', '0', '0', '0', '0', '2016-10-12 08:57:31', '0000-00-00 00:00:00', '', '', '', ''), (19, '', '', '', '', '', '', 0, 0, 0, '', '', '0', '0', '0', '0', '2016-10-16 09:04:24', '0000-00-00 00:00:00', '', '', '', ''); -- -------------------------------------------------------- -- -- Table structure for table `settings` -- CREATE TABLE IF NOT EXISTS `settings` ( `id` int(11) NOT NULL, `home_loan_rate` float(10,2) NOT NULL, `personal_loan_rate` float(10,2) NOT NULL, `car_loan_rate` float(10,2) NOT NULL, `retirement_loan_rate` float(10,2) NOT NULL, `educational_loan_rate` float(10,2) NOT NULL, `sme_loan_rate` float(10,2) NOT NULL, `start_up_loan_rate` float(10,2) NOT NULL, `mortgage_rate` float(10,2) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `settings` -- INSERT INTO `settings` (`id`, `home_loan_rate`, `personal_loan_rate`, `car_loan_rate`, `retirement_loan_rate`, `educational_loan_rate`, `sme_loan_rate`, `start_up_loan_rate`, `mortgage_rate`) VALUES (1, 4.25, 13.50, 10.00, 2.25, 15.00, 9.75, 11.25, 20.00); -- -------------------------------------------------------- -- -- Table structure for table `tax_free_retirement` -- CREATE TABLE IF NOT EXISTS `tax_free_retirement` ( `id` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(300) NOT NULL, `last_name` varchar(250) NOT NULL, `address` text NOT NULL, `city` varchar(300) NOT NULL, `zip` varchar(50) NOT NULL, `state` varchar(300) NOT NULL, `phone` varchar(15) NOT NULL, `email` varchar(100) NOT NULL, `dob` varchar(12) NOT NULL, `retired_status` enum('2','1') NOT NULL, `interested` varchar(100) NOT NULL, `citizen` varchar(100) NOT NULL, `benefits` varchar(2) NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7 ; -- -- Dumping data for table `tax_free_retirement` -- INSERT INTO `tax_free_retirement` (`id`, `first_name`, `last_name`, `address`, `city`, `zip`, `state`, `phone`, `email`, `dob`, `retired_status`, `interested`, `citizen`, `benefits`, `created_at`) VALUES (1, 'fgbnfgn', 'fdfdg', 'fdcvbcv', 'ghmgh', '56756', 'dfbfd', '879676576', 'vvbdfv@sdfsd.bfd', '657', '1', '', 'US Citizen', '', '2016-10-03 12:37:18'), (2, 'gfngf', 'bvnvb', 'fgnbgf', 'vbnv', '65756', 'fggfbnfg fghfg', '9867867', 'vcbcgfd@sdfsd.gbdf', '56756', '1', 'Term 20 years', '', '', '2016-10-03 12:36:09'), (3, 'test', 'bvfn', 'gfn', 'jmnghj', '787686', 'vbnfn gfht', '787974645', 'vcbbdgd@eewffvbdf.ngf', '7856756', '2', '', 'Green Card', 'Ye', '2016-10-03 12:38:56'), (4, 'dfbfd', 'reer', 'dfbfdbd dfgret', 'dfgdf ertre', '567546', 'fgfg tryer', '67856756', 'fdbdfdfd@dfbfdfgh.gffd', '654645', '2', '', 'Green Card', 'No', '2016-10-04 22:56:10'), (5, '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '2016-10-11 02:58:11'), (6, '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0', '0', '0', '2016-10-17 02:48:49'); -- -------------------------------------------------------- -- -- Table structure for table `term_insurance` -- CREATE TABLE IF NOT EXISTS `term_insurance` ( `id` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(300) NOT NULL, `last_name` varchar(100) NOT NULL, `address` text NOT NULL, `city` varchar(300) NOT NULL, `zip` varchar(50) NOT NULL, `state` varchar(300) NOT NULL, `phone` varchar(15) NOT NULL, `email` varchar(200) NOT NULL, `dob` varchar(20) NOT NULL, `citizen` varchar(100) NOT NULL, `insurance_time` varchar(50) NOT NULL, `live_bnft` enum('1','2') NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ; -- -- Dumping data for table `term_insurance` -- INSERT INTO `term_insurance` (`id`, `first_name`, `last_name`, `address`, `city`, `zip`, `state`, `phone`, `email`, `dob`, `citizen`, `insurance_time`, `live_bnft`, `created_at`) VALUES (3, 'sdfgfg', 'erger', 'dfhdf', 'fdh', 're', 'df', 'cvh', 'ghddhdf@errth.ng', '546', 'US Citizen', 'Term 10 years', '', '2016-10-27 12:44:58'); -- -------------------------------------------------------- -- -- Table structure for table `user` -- CREATE TABLE IF NOT EXISTS `user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `first_name` varchar(200) NOT NULL, `last_name` varchar(200) NOT NULL, `email` varchar(255) NOT NULL, `password` varchar(255) NOT NULL, `created_at` datetime NOT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=9 ; -- -- Dumping data for table `user` -- INSERT INTO `user` (`id`, `first_name`, `last_name`, `email`, `password`, `created_at`) VALUES (1, 'rajat', 'patra', 'tanay.chatterjee7@gmail.com', '12345', '2016-09-08 23:30:20'), (2, 'rajat', 'patra', 'rajatpatra79@gmail.com', '12345', '2016-09-09 00:00:52'), (3, 'ben', 'sobel', 'benjamin@quickfinance.com', 'pz1406', '2016-09-09 00:02:50'), (4, 'Louise', 'Sobel', 'louise.sobel@gmail.com', 'kobi0304', '2016-09-09 02:54:29'), (5, '0', '0', '0', '0', '2016-09-09 05:30:34'), (6, '0', '0', '0', '0', '2016-09-11 17:41:30'), (7, 'rajat', 'patra', 'tanay.chatterjee71223@gmail.com', '12345', '2016-09-13 00:41:56'), (8, '0', '0', '0', '0', '2016-10-19 02:42:49'); -- -------------------------------------------------------- -- -- Table structure for table `workers_compensation` -- CREATE TABLE IF NOT EXISTS `workers_compensation` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(200) NOT NULL, `business_name` varchar(500) NOT NULL, `business_type` varchar(100) NOT NULL, `entity_type` varchar(50) NOT NULL, `taxid` varchar(200) NOT NULL, `payroll_amount` float NOT NULL, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ; /*!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 */;