-- phpMyAdmin SQL Dump
-- version 4.0.10.7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: May 14, 2015 at 12:27 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: `axisdmc1`
--

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

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

CREATE TABLE IF NOT EXISTS `datalist` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `description` varchar(255) DEFAULT NULL,
  `cheque_no` varchar(255) DEFAULT NULL,
  `amount` varchar(250) DEFAULT NULL,
  `status` varchar(255) DEFAULT NULL,
  `balance` varchar(255) DEFAULT NULL,
  `plot_no` int(10) DEFAULT NULL,
  `salary_month` varchar(500) DEFAULT NULL,
  `plot_notwo` varchar(255) DEFAULT NULL,
  `name` varchar(500) DEFAULT NULL,
  `down_payment` varchar(250) DEFAULT NULL,
  `remark` text,
  `installment` varchar(500) DEFAULT NULL,
  `follow_time` varchar(500) DEFAULT NULL,
  `call_1` varchar(500) DEFAULT NULL,
  `time_1` varchar(500) DEFAULT NULL,
  `service_taxno` varchar(500) DEFAULT NULL,
  `check` varchar(500) DEFAULT NULL,
  `service_tax` varchar(500) DEFAULT NULL,
  `time_3` varchar(500) DEFAULT NULL,
  `stamp_duty` varchar(500) DEFAULT NULL,
  `time_4` varchar(500) DEFAULT NULL,
  `regi_duty` varchar(500) DEFAULT NULL,
  `time_5` varchar(500) DEFAULT NULL,
  `lawyer_fee` varchar(500) DEFAULT NULL,
  `time_6` varchar(500) DEFAULT NULL,
  `maintance_charge` varchar(500) DEFAULT NULL,
  `time_7` varchar(500) NOT NULL,
  `call_2` 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,
  `cr_dr` varchar(250) 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,
  `email` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1292 ;

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

INSERT INTO `datalist` (`id`, `description`, `cheque_no`, `amount`, `status`, `balance`, `plot_no`, `salary_month`, `plot_notwo`, `name`, `down_payment`, `remark`, `installment`, `follow_time`, `call_1`, `time_1`, `service_taxno`, `check`, `service_tax`, `time_3`, `stamp_duty`, `time_4`, `regi_duty`, `time_5`, `lawyer_fee`, `time_6`, `maintance_charge`, `time_7`, `call_2`, `time_8`, `call_9`, `time_9`, `date`, `cr_dr`, `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`, `email`) VALUES
(10, 'admin', 'admin@gmail.com', 'Auto Mail', 'Proposal', 'Yes', 12121, '1212121211', '1990-07-07', 'admin', '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, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'admin@gmail.com'),
(36, 'user', 'user@gmail.com', NULL, NULL, NULL, NULL, NULL, NULL, 'user', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, NULL, NULL, '', NULL, 2, 'bankdmc01012014', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'bank@gmail.com'),
(1291, 'test', 'test', 'test', '', 'test', 0, '', '', '', '', '', '', '', '', NULL, ' ', NULL, ' ', NULL, ' ', NULL, ' ', NULL, ' ', NULL, ' ', '', '19/09/2014', NULL, '', NULL, '19/09/2014', 'test', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 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 */;