-- http://www.phpmyadmin.net
--




--
-- Database: `Laison_Expence`
--

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

--
-- 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=22 ;

--
-- 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
(2, 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, NULL, NULL, NULL, 2, 'expense321', NULL, NULL, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 'expence@gmail.com'),
(4, '40000', 'test', '196/2', 'DMC-3', '', 0, '', '', 'NA advance ', 'Cash', 'valinda', '-', '', '', NULL, '-', NULL, '-', NULL, '', NULL, '', NULL, '', NULL, '', '', '15/10/2015', NULL, '', NULL, '16/05/2015', 'Bharatbhai', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL),
(5, '293500', '-', '196/2', 'DMC-3', '', 0, '', '', 'NA Jilla panchayat', 'Cash', 'valinda', '', '', '', NULL, ' ', NULL, 'NA mate anilbhai ne ane jilla panchayat ma aapya', NULL, '', NULL, '', NULL, '', NULL, '', '', ' 22/10/2015', NULL, '', NULL, '16/05/2015', 'Bharatbhai', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL),
(6, '178500', '', '611/1/2', 'DMC-5001', '', 0, '', '', 'Plan pass', 'Cash', 'Fedra', '', '', '', NULL, ' ', NULL, ' Advance fee bharva', NULL, '', NULL, '', NULL, '', NULL, '', '', ' 20/10/2014', NULL, '', NULL, '16/05/2015', 'Manoj kanani', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL),
(7, '50000', '-', '196/2', 'DMC-3', '', 0, '', '', 'NA ', 'Cash', 'valinda', '', '', '', NULL, ' ', NULL, ' Gandhinagar aapya', NULL, '', NULL, '', NULL, '', NULL, '', '', ' 18/10/2014', NULL, '', NULL, '16/05/2015', 'Jethva saheb', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL),
(8, '10000', '-', 'GPCB ', 'Other', '', 0, '', '', 'Param mate', 'Cash', 'Gandhinagar', '', '', '', NULL, ' ', NULL, 'Hajira andho project mate', NULL, '', NULL, '', NULL, '', NULL, '', '', ' 21/10/2014', NULL, '', NULL, '16/05/2015', 'Bhut saheb ', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL),
(9, '70000', '-', '196/2', 'DMC-3', '', 0, '', '', 'NA', 'Cash', 'valinda', '', '', '', NULL, '  ', NULL, ' Talti sikshan upkar,rupantar kar,vishesh dharo,local fund', NULL, '', NULL, '', NULL, '', NULL, '', '', '  29/10/2015', NULL, '', NULL, '16/05/2015', 'Talati', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL),
(10, '100000', '-', '-', 'DMC-2', '', 0, '', '', 'Site kharch', 'Cash', 'valinda', '', '', '', NULL, ' ', NULL, ' site pati case', NULL, '', NULL, '', NULL, '', NULL, '', '', ' 31/122015', NULL, '', NULL, '16/05/2015', 'Ramnikkaka', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL),
(11, '100000', '', '196/2', 'DMC-2', '', 0, '', '', 'Site kharch', 'Cash', 'valinda', '', '', '', NULL, ' ', NULL, ' U.p 150000 NA mate aapya temathi kaka ne aapya', NULL, '', NULL, '', NULL, '', NULL, '', '', '21/01/2015', NULL, '', NULL, '16/05/2015', 'Ramnikkaka', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL),
(12, '100000', '-', '196/2', 'DMC-3', '', 0, '', '', 'Site kharch', 'Cash', 'valinda', '', '', '', NULL, ' ', NULL, 'site pati case', NULL, '', NULL, '', NULL, '', NULL, '', '', '03/02/2015', NULL, '', NULL, '16/05/2015', 'Ramnikkaka', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL),
(13, '150000', '-', '611/1/2', 'DMC-5001', '', 0, '', '', 'NA ', 'Cash', 'Fedra', '', '', '', NULL, ' ', NULL, ' 611 NA na abhipray mate ', NULL, '', NULL, '', NULL, '', NULL, '', '', ' 20/01/2015', NULL, '', NULL, '16/05/2015', 'NA', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL),
(14, '150000', '-', '611/1/2', 'DMC-5001', '', 0, '', '', 'NA karch', 'Cash', 'Fedra', '', '', '', NULL, ' ', NULL, '611 NA na abhipray mate', NULL, '', NULL, '', NULL, '', NULL, '', '', '06/01/2015', NULL, '', NULL, '16/05/2015', 'NA', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL),
(15, '10000', '4000', '611/1/2', 'DMC-5001', '', 0, '', '', '611 NA mate 133/1/2 6no ', 'Cash', 'Fedra', '', '', '', NULL, ' ', NULL, ' 5000 shah ne ane 1000 mahendra sinh ne aapya', NULL, '', NULL, '', NULL, '', NULL, '', '', ' 23/02/2015', NULL, '', NULL, '16/05/2015', 'Shah,mahendra sinh ', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL),
(16, '40000', '835', '198,196/1,196/2', 'Other', '', 0, '', '', 'Talati vero', 'Cash', 'valinda', '', '', '', NULL, ' ', NULL, ' Talati all vera bharya (39165)', NULL, '', NULL, '', NULL, '', NULL, '', '', ' 24/02/2015', NULL, '', NULL, '16/05/2015', 'Akshay', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL),
(17, '40000', '3416', '196/1', 'DMC-2', '', 0, '', '', 'Primium', 'Cash', 'valinda', '', '', '', NULL, ' ', NULL, ' 196/1 second time primium paid (36584)', NULL, '', NULL, '', NULL, '', NULL, '', '', ' 02/03/2015', NULL, '', NULL, '16/05/2015', 'Akshay', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL),
(18, '', '', '611/1 paiki 1 611/1 paiky 2', 'DMC-5001', '', 0, '', '', 'Entry', 'Cash', 'fedra', '', '', '', NULL, '  4689', NULL, '  13-05-2015 Mudat puri thase', NULL, '', NULL, '', NULL, '', NULL, '', '', ' 13/05/2015', NULL, '', NULL, '16/05/2015', 'Dhambha or Circle Officer', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL),
(19, '', '', '124p', 'Other', '', 0, '', '', 'Entry', 'Cash', 'Mundi', '', '', '', NULL, '  1210', NULL, '  Pramanit thai gayi chhe 7*12 ma asar apavanu baki chhe', NULL, '', NULL, '', NULL, '', NULL, '', '', ' 22/05/2015', NULL, '', NULL, '22/05/2015', 'Dhambha or Circle Officer', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL),
(20, '', '', '197', 'DMC-4', '', 0, '', '', 'Title Clerance', 'Cheque', 'Valinda', '', '', '', NULL, '  ', NULL, '  ', NULL, '', NULL, '', NULL, '', NULL, '', '', '', NULL, '', NULL, '22/05/2015', 'Mukundray Jani', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL),
(21, '', '', '196/2', 'DMC-3', '', 0, '', '', 'NA DILR Survey', 'Cash', 'Valinda', '', '', '', NULL, '  ', NULL, '  Original Mapani nu Chalan lai Javu', NULL, '', NULL, '', NULL, '', NULL, '', '', '25/05/2015', NULL, '', NULL, '25/05/2015', 'P R Raval DILR 9998099090', 0, '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', NULL);

