-- phpMyAdmin SQL Dump -- version 4.0.10.7 -- http://www.phpmyadmin.net -- -- Host: localhost -- Generation Time: May 28, 2015 at 02:32 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: `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); /*!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 */;