-- phpMyAdmin SQL Dump
-- version 4.1.8
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 11, 2014 at 02:15 AM
-- Server version: 5.5.32-cll-lve
-- PHP Version: 5.4.23

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: `axisdmc3`
--

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

--
-- Table structure for table `datalist`
--

CREATE TABLE IF NOT EXISTS `datalist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL,
  `source` text,
  `status` varchar(255) DEFAULT NULL,
  `send_auto_mail` varchar(255) DEFAULT NULL,
  `plot_intrest_no` int(10) DEFAULT NULL,
  `offer_price` varchar(500) DEFAULT NULL,
  `site_visit_date` varchar(255) DEFAULT NULL,
  `site_visit_time` varchar(500) DEFAULT NULL,
  `sent_doc` text,
  `remark` text,
  `follow_up` varchar(500) DEFAULT NULL,
  `follow_time` varchar(500) DEFAULT NULL,
  `call_1` varchar(500) DEFAULT NULL,
  `time_1` varchar(500) DEFAULT NULL,
  `call_2` varchar(500) DEFAULT NULL,
  `time_2` varchar(500) DEFAULT NULL,
  `call_3` varchar(500) DEFAULT NULL,
  `time_3` varchar(500) DEFAULT NULL,
  `call_4` varchar(500) DEFAULT NULL,
  `time_4` varchar(500) DEFAULT NULL,
  `call_5` varchar(500) DEFAULT NULL,
  `time_5` varchar(500) DEFAULT NULL,
  `call_6` varchar(500) DEFAULT NULL,
  `time_6` varchar(500) DEFAULT NULL,
  `call_7` varchar(500) DEFAULT NULL,
  `time_7` varchar(500) NOT NULL,
  `call_8` varchar(500) DEFAULT NULL,
  `time_8` varchar(500) DEFAULT NULL,
  `call_9` varchar(500) DEFAULT NULL,
  `time_9` varchar(500) DEFAULT NULL,
  `date` varchar(500) DEFAULT NULL,
  `mobile` bigint(20) DEFAULT NULL,
  `is_admin` smallint(6) DEFAULT NULL,
  `password` varchar(500) DEFAULT NULL,
  `manager` varchar(500) DEFAULT NULL,
  `manager_type` varchar(500) DEFAULT NULL,
  `c1_status` varchar(500) NOT NULL,
  `c1_manager` varchar(500) NOT NULL,
  `c2_status` varchar(500) NOT NULL,
  `c2_manager` varchar(500) NOT NULL,
  `c3_status` varchar(500) NOT NULL,
  `c3_manager` varchar(500) NOT NULL,
  `c4_status` varchar(500) NOT NULL,
  `c4_manager` varchar(500) NOT NULL,
  `c5_status` varchar(500) NOT NULL,
  `c5_manager` varchar(500) NOT NULL,
  `c6_status` varchar(500) NOT NULL,
  `c6_manager` varchar(500) NOT NULL,
  `c7_status` varchar(500) NOT NULL,
  `c7_manager` varchar(500) NOT NULL,
  `c8_status` varchar(500) NOT NULL,
  `c8_manager` varchar(500) NOT NULL,
  `c9_status` varchar(500) NOT NULL,
  `c9_manager` varchar(500) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1278 ;

--
-- Dumping data for table `datalist`
--

INSERT INTO `datalist` (`id`, `name`, `email`, `source`, `status`, `send_auto_mail`, `plot_intrest_no`, `offer_price`, `site_visit_date`, `site_visit_time`, `sent_doc`, `remark`, `follow_up`, `follow_time`, `call_1`, `time_1`, `call_2`, `time_2`, `call_3`, `time_3`, `call_4`, `time_4`, `call_5`, `time_5`, `call_6`, `time_6`, `call_7`, `time_7`, `call_8`, `time_8`, `call_9`, `time_9`, `date`, `mobile`, `is_admin`, `password`, `manager`, `manager_type`, `c1_status`, `c1_manager`, `c2_status`, `c2_manager`, `c3_status`, `c3_manager`, `c4_status`, `c4_manager`, `c5_status`, `c5_manager`, `c6_status`, `c6_manager`, `c7_status`, `c7_manager`, `c8_status`, `c8_manager`, `c9_status`, `c9_manager`) VALUES
(10, 'admin', 'admin@gmail.com', 'Auto Mail', 'Proposal', 'Yes', 12121, '1212121211', '1990-07-07', NULL, 'asd', 'asd', '1', '1', '2', '2', '2', '3', '4', '4', '5', '5', '6', '6', '7', '7', '8', '8', '9', '9', '10', '10', '', 1234567890, 1, 'admin123', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''),
(36, 'user', 'user@gmail.com', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '', NULL, 2, 'user123', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '');

/*!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 */;