 --
 
 CREATE TABLE IF NOT EXISTS `customers` (
+  `prospect_id` int(11) NOT NULL,
   `id` int(11) NOT NULL AUTO_INCREMENT,
   `customer_name` varchar(1000) NOT NULL,
   `email` varchar(1000) NOT NULL,

  `followup` varchar(1000) NOT NULL,
  `vehicle_reg` varchar(255) NOT NULL,
  `branch` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=17 ;

--
-- Dumping data for table `customers`
--

INSERT INTO `customers` (`id`, `customer_name`, `email`, `mobile_no`, `phone_no`, `address`, `engine_chesis_no`, `payment_complete`, `payment_fail_reason`, `payment_type`, `cheque_no`, `document_complete`, `document_ids`, `tax_complete`, `tax_fail_reason`, `registration_no_type`, `document_given_customer`, `no_for_choice`, `no_given_customer`, `document_for_no_choice`, `call_agent_rc`, `rc_dispached_not_reason`, `customer_state`, `active`, `delivery_date`, `consultant_name`, `remaining_amt`, `amount`, `finance`, `bank_name`, `insurance`, `followup`, `vehicle_reg`, `branch`) VALUES
(1, 'Rajat', 'rajat@eail.co', '2147483647', '2147483647', '9806203545', '9806203545', 1, '', 'cheque', 0, 1, '1,2,3', 1, '', 'vip_no', 1, '1', 1, 1, 0, '', 1, 0, '0000-00-00 00:00:00', '', 0, 0, 0, '0', '', '', '', ''),
(4, 'adasasd', '', '0', '0', '', '', 1, '', 'cash', 0, 1, '', 1, '', 'choice_no', 1, '1', 1, 1, 0, '', 3, 0, '0000-00-00 00:00:00', '', 0, 0, 0, '0', '', '', '', ''),
(5, '', '', '0', '0', '', '', 0, '', 'cash', 0, 0, '', 0, '', 'regular_no', 0, '', 0, 0, 0, '', 3, 0, '0000-00-00 00:00:00', '', 0, 0, 0, '0', '', '', '', ''),
(6, '', '', '0', '0', '', '', 0, '', 'cash', 0, 0, '', 0, '', 'regular_no', 0, '', 0, 0, 0, '', 1, 0, '0000-00-00 00:00:00', '', 0, 0, 0, '0', '', '', '', ''),
(7, 'dsadsa', 'dasdsa', '0', '0', 'dsad', '4332', 1, '', 'cash', 0, 1, '1', 1, '', 'choice_no', 0, 'on', 0, 0, 0, '', 3, 0, '0000-00-00 00:00:00', '', 0, 0, 0, '0', '', '', '', ''),
(8, 'dsdsd', 'rajat@gmail.com', '2147483647', '2147483647', '9806203545', '9806203545', 1, '', 'cheque', 433434, 1, '2,3', 1, '', 'regular_no', 1, '', 0, 0, 0, '', 3, 0, '0000-00-00 00:00:00', '', 0, 0, 0, '0', '', '', '', ''),
(9, '', '', '0', '0', '', '', 0, '', '', 0, 0, '', 1, '', 'regular_no', 1, '', 1, 0, 0, '', 4, 0, '0000-00-00 00:00:00', '', 0, 0, 0, '0', '', '', '', ''),
(10, 'Rajat Gupta', 'rajat@gmail.com', '9806203545', '2147483647', '9806203545', '9806203545', 1, '', 'cash', 0, 1, '2,3', 1, 'Test', 'choice_no', 0, 'on', 1, 0, 0, '', 2, 1, '0000-00-00 00:00:00', '', 0, 0, 0, '0', '', '', '', ''),
(11, 'Dharmendra Deora', 'deoradharmendra@gmail.com', '9630258741', '9658741458', 'Biyabani Indore', '9856214558', 1, '', 'cheque', 9635, 1, '1,3', 1, '', 'regular_no', 1, '0', 1, 0, 0, '', 4, 1, '0000-00-00 00:00:00', '', 0, 0, 0, '0', '', '', '', ''),
(12, 'Praveen Chouhan', 'praveen@gmail.com', '9412547485', '9320147857', 'Rajmohalla Indore', '9632547487', 1, '', 'cash', 0, 1, '1,2', 1, '', 'choice_no', 0, '0', 0, 0, 0, '', 3, 1, '0000-00-00 00:00:00', '', 0, 0, 0, '0', '', '', '', ''),
(13, 'Ramesh Lal', 'ramesh@gmail.com', '9631478547', '7854741458', 'Gangwal indore', '9874521475', 1, '', 'cheque', 96547, 1, '1,2,3', 0, 'Check Clearance', 'choice_no', 0, 'on', 1, 1, 0, '', 4, 1, '0000-00-00 00:00:00', '', 0, 0, 0, '0', '', '', '', ''),
(14, 'Raghvendra Singh', 'ragven@gmail.com', '9541745874', '9321475874', 'Bombay Hospital Indore', '9654148822', 1, '', 'cheque', 4343, 1, '1,2,3', 1, '', 'choice_no', 0, 'on', 1, 0, 1, '', 5, 1, '0000-00-00 00:00:00', '', 0, 0, 0, '0', '', '', '', ''),
(15, 'dsadsa', 'dss@ffdf.fd', '4324344444', '4324344444', 'dsadsadsdssa', '43232', 1, '', 'cash', 0, 1, '1', 0, '', '', 0, '', 0, 0, 0, '', 1, 1, '0000-00-00 00:00:00', '', 0, 0, 0, '0', '', '', '', ''),
(16, 'Rajat Gupta', 'rajat@gmail.com', '9806203545', '9806203545', '98062035459', '123456', 1, '', 'cheque', 87654, 1, '1,3', 0, '', '', 0, '', 0, 0, 0, '', 1, 1, '2017-02-27 23:03:00', 'Dharmendra Deora', 1, 100, 0, '', 'self', '9806203545', 'c/o', 'fordfigo');

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


  `date` datetime NOT NULL,
  `taken` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

--
-- Dumping data for table `enquiry`
--

INSERT INTO `enquiry` (`id`, `employee_id`, `name`, `email`, `phone`, `address`, `reason`, `date`, `taken`) VALUES
(1, 1, 'Rajat Gupta', 'rajatgupta.gupta1@gmail.com', '(980) 620-3545', 'Test', 'Test', '2017-03-03 00:00:00', 1);

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

