/*
Navicat MySQL Data Transfer

Source Server         : test
Source Server Version : 50625
Source Host           : localhost:3306
Source Database       : invoice_system

Target Server Type    : MYSQL
Target Server Version : 50625
File Encoding         : 65001

Date: 2016-05-05 22:12:35
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for `billingdetails`
-- ----------------------------
DROP TABLE IF EXISTS `billingdetails`;
CREATE TABLE `billingdetails` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `Empno` varchar(50) DEFAULT NULL,
  `TotalHrs` varchar(50) DEFAULT NULL,
  `TotalCalc` int(10) DEFAULT NULL,
  `OTAmount` varchar(50) DEFAULT NULL,
  `TotalAmount` varchar(50) DEFAULT NULL,
  `date` date DEFAULT NULL,
  `Calcdone` int(1) NOT NULL DEFAULT '0',
  `del_flg` int(10) DEFAULT NULL,
  `Ins_DT` date DEFAULT NULL,
  `Ins_TM` time DEFAULT NULL,
  `CreatedBy` varchar(100) DEFAULT NULL,
  `Up_DT` date DEFAULT NULL,
  `UP_TM` date DEFAULT NULL,
  `UpdatedBy` varchar(50) DEFAULT NULL,
  `Clientid` varchar(10) DEFAULT NULL,
  `branch_id` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of billingdetails
-- ----------------------------
INSERT INTO billingdetails VALUES ('9', 'MB0032', '80', '1', '120,000', '320,000', '2015-11-02', '2', '0', '2015-12-12', '07:21:22', 'Kumar&nbsp;Sathish', null, null, null, 'CST00700', '');
INSERT INTO billingdetails VALUES ('8', 'MB0032', '75', '1', '149,985', '549,985', '2015-11-16', '2', '0', '2015-12-12', '07:20:55', 'Kumar&nbsp;Sathish', null, null, null, 'CST00300', 'CST00301');

-- ----------------------------
-- Table structure for `clientempteam`
-- ----------------------------
DROP TABLE IF EXISTS `clientempteam`;
CREATE TABLE `clientempteam` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `cust_id` varchar(15) DEFAULT NULL,
  `emp_id` varchar(15) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `start_date` date DEFAULT NULL,
  `end_date` date DEFAULT NULL,
  `Ins_DT` date DEFAULT NULL,
  `Ins_TM` time DEFAULT NULL,
  `Up_DT` date DEFAULT NULL,
  `UP_TM` time DEFAULT NULL,
  `CreatedBy` varchar(50) DEFAULT NULL,
  `UpdatedBy` varchar(50) DEFAULT NULL,
  `delFLg` int(1) DEFAULT NULL,
  `branch_id` varchar(10) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=129 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of clientempteam
-- ----------------------------
INSERT INTO clientempteam VALUES ('113', 'CST00200', 'MB0106', '3', '2015-01-01', '2015-03-01', '2015-12-15', '12:57:13', '2016-03-09', '04:27:13', 'Kumar&nbsp;Sathish', 'MBINV001', '0', null);
INSERT INTO clientempteam VALUES ('112', 'CST00200', 'MB0178', '3', '2013-01-05', '2016-03-09', '2015-12-15', '12:57:13', '2016-03-09', '04:27:31', 'Kumar&nbsp;Sathish', 'MBINV001', '0', null);
INSERT INTO clientempteam VALUES ('111', 'CST00200', 'MB0181', '3', '2014-12-01', '2015-12-01', '2015-12-15', '12:57:13', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('109', 'CST00100', 'MB0042', '1', '2015-07-27', '0000-00-00', '2015-12-14', '02:09:53', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('74', 'CST00300', 'MB0106', '3', '2014-10-14', '2015-01-06', '2015-12-14', '01:44:43', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('86', 'CST00400', 'MB0021', '1', '2014-04-02', '0000-00-00', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('110', 'CST00100', 'MB0032', '1', '2015-11-02', '0000-00-00', '2015-12-14', '02:09:53', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('73', 'CST00300', 'MB0117', '2', '2014-10-15', '2014-10-24', '2015-12-14', '01:44:43', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('87', 'CST00400', 'MB0042', '2', '2014-03-03', '2015-02-28', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('72', 'CST00300', 'MB0137', '2', '2014-10-09', '2015-02-19', '2015-12-14', '01:44:43', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('71', 'CST00300', 'MBC008', '1', '2011-12-12', '0000-00-00', '2015-12-14', '01:44:43', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('76', 'CST00300', 'MB0133', '4', '2014-05-22', '2015-05-11', '2015-12-14', '01:44:43', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('75', 'CST00300', 'MB0108', '3', '2014-10-01', '2014-10-22', '2015-12-14', '01:44:43', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('70', 'CST00600', 'MBC013', '1', '2015-04-20', '0000-00-00', '2015-12-14', '01:39:58', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('69', 'CST00600', 'MB0162', '3', '2015-06-17', '2015-12-03', '2015-12-14', '01:39:58', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('67', 'CST00600', 'MB0169', '1', '2015-04-22', '0000-00-00', '2015-12-14', '01:39:58', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('68', 'CST00600', 'MB0144', '3', '2015-07-02', '2016-07-20', '2015-12-14', '01:39:58', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('66', 'CST00600', 'MB0166', '1', '2015-04-23', '0000-00-00', '2015-12-14', '01:39:58', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('65', 'CST00600', 'MBC014', '1', '2015-03-05', '0000-00-00', '2015-12-14', '01:39:58', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('64', 'CST00600', 'MB0167', '4', '2015-02-03', '2015-02-17', '2015-12-14', '01:39:58', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('63', 'CST00600', 'MB0161', '1', '2015-01-08', '0000-00-00', '2015-12-14', '01:39:58', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('62', 'CST00600', 'MB0119', '1', '2015-01-12', '0000-00-00', '2015-12-14', '01:39:58', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('61', 'CST00600', 'MB0133', '2', '2015-06-22', '2015-07-16', '2015-12-14', '01:39:58', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('60', 'CST00600', 'MB0148', '1', '2014-10-14', '0000-00-00', '2015-12-14', '01:39:58', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('59', 'CST00600', 'MB0109', '3', '2014-10-14', '2015-12-03', '2015-12-14', '01:39:58', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('58', 'CST00600', 'MB0114', '1', '2014-03-03', '0000-00-00', '2015-12-14', '01:39:58', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('57', 'CST00600', 'MB0161', '2', '2014-11-04', '2014-11-27', '2015-12-14', '01:39:58', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('56', 'CST00600', 'MBC006', '1', '2014-12-01', '0000-00-00', '2015-12-14', '01:39:58', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('55', 'CST00600', 'MB0154', '1', '2014-12-18', '0000-00-00', '2015-12-14', '01:39:58', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('77', 'CST00300', 'MBC001', '3', '2014-12-16', '2015-04-29', '2015-12-14', '01:44:43', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('78', 'CST00300', 'MB0126', '1', '2014-12-08', '0000-00-00', '2015-12-14', '01:44:43', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('79', 'CST00300', 'MB0128', '1', '2014-12-08', '0000-00-00', '2015-12-14', '01:44:43', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('80', 'CST00300', 'MB0134', '1', '2014-01-01', '0000-00-00', '2015-12-14', '01:44:43', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('81', 'CST00300', 'MB0163', '2', '2014-12-02', '2015-06-24', '2015-12-14', '01:44:43', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('82', 'CST00300', 'MB0137', '1', '2015-02-19', '0000-00-00', '2015-12-14', '01:44:43', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('83', 'CST00300', 'MB0137', '2', '2015-02-19', '2015-02-20', '2015-12-14', '01:44:43', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('84', 'CST00300', 'MB0144', '1', '2016-07-20', '0000-00-00', '2015-12-14', '01:44:43', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('85', 'CST00300', 'MB0162', '1', '2015-12-03', '0000-00-00', '2015-12-14', '01:44:43', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('88', 'CST00400', 'MB0035', '2', '2014-03-03', '2014-08-15', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('89', 'CST00400', 'MB0048', '1', '2014-10-01', '2016-04-05', '2015-12-14', '02:02:48', '2016-04-11', '11:22:47', 'Kumar&nbsp;Sathish', '', '0', null);
INSERT INTO clientempteam VALUES ('90', 'CST00400', 'MB0039', '1', '2014-10-01', '0000-00-00', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('91', 'CST00400', 'MB0047', '1', '2014-10-01', '0000-00-00', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('92', 'CST00400', 'MB0033', '5', '2014-02-03', '2015-10-16', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('93', 'CST00400', 'MB0040', '2', '2014-11-04', '2014-11-30', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('94', 'CST00400', 'MB0045', '2', '2014-11-04', '2014-12-26', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('95', 'CST00400', 'MB0031', '4', '2015-01-05', '2015-09-02', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('96', 'CST00400', 'MB0054', '2', '2015-01-05', '2015-09-30', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('97', 'CST00400', 'MB0051', '1', '2015-01-05', '0000-00-00', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('98', 'CST00400', 'MB0052', '1', '2015-01-05', '0000-00-00', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('99', 'CST00400', 'MB0035', '2', '2015-01-16', '2015-09-02', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('100', 'CST00400', 'MB0049', '1', '2014-10-01', '0000-00-00', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('101', 'CST00400', 'MB0053', '2', '2015-04-01', '2015-09-04', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('102', 'CST00400', 'MB0058', '1', '2015-04-01', '0000-00-00', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('103', 'CST00400', 'MB0057', '1', '2015-04-01', '0000-00-00', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('104', 'CST00400', 'MB0059', '1', '2015-08-03', '0000-00-00', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('105', 'CST00400', 'MB0062', '1', '2015-10-13', '0000-00-00', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('106', 'CST00400', 'MB0063', '1', '2015-10-13', '0000-00-00', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('107', 'CST00400', 'MB0061', '1', '2015-10-13', '0000-00-00', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('108', 'CST00400', 'MB0060', '1', '2015-10-13', '0000-00-00', '2015-12-14', '02:02:48', null, null, 'Kumar&nbsp;Sathish', null, '0', null);
INSERT INTO clientempteam VALUES ('114', 'CST00400', 'MB0106', '1', '2016-03-09', '0000-00-00', '2016-03-09', '04:27:13', null, null, 'MBINV001', null, '0', 'CST00401');
INSERT INTO clientempteam VALUES ('115', 'CST00400', 'MB0178', '3', '2016-03-18', '2016-04-29', '2016-03-09', '04:27:31', '2016-04-13', '07:03:37', 'MBINV001', 'MBINV001', '0', 'CST00401');
INSERT INTO clientempteam VALUES ('116', 'CST00500', 'MB0198', '3', '2016-03-09', '2016-03-23', '2016-03-09', '04:28:26', '2016-03-09', '04:28:50', 'MBINV001', 'MBINV001', '0', 'CST00501');
INSERT INTO clientempteam VALUES ('117', 'CST00400', 'MB0198', '1', '2016-03-29', '2016-04-27', '2016-03-09', '04:28:50', '2016-04-13', '07:34:30', 'MBINV001', 'MBINV001', '0', 'CST00401');
INSERT INTO clientempteam VALUES ('118', 'CST00400', 'MB0222', '3', '2016-03-31', '2016-03-31', '2016-03-17', '03:33:08', '2016-03-17', '03:34:11', 'MBINV001', 'MBINV001', '0', 'CST00401');
INSERT INTO clientempteam VALUES ('119', 'CST00300', 'MB0222', '1', '2016-04-01', '0000-00-00', '2016-03-17', '03:34:11', null, null, 'MBINV001', null, '0', 'CST00301');
INSERT INTO clientempteam VALUES ('120', 'CST00900', 'MB0174', '1', '2016-04-12', '0000-00-00', '2016-04-08', '07:32:40', null, null, 'MBINV001', null, '0', 'CST00901');
INSERT INTO clientempteam VALUES ('121', 'CST00100', 'MB0178', '1', '2016-04-13', '0000-00-00', '2016-04-13', '07:03:37', null, null, 'MBINV001', null, '0', 'CST00101');
INSERT INTO clientempteam VALUES ('122', 'CST00400', 'MB0206', '3', '2016-04-13', '2016-04-15', '2016-04-13', '07:26:11', '2016-04-13', '07:32:54', 'MBINV001', 'MBINV001', '0', 'CST00401');
INSERT INTO clientempteam VALUES ('123', 'CST00100', 'MB0206', '1', '2016-04-13', '0000-00-00', '2016-04-13', '07:32:54', null, null, 'MBINV001', null, '0', 'CST00102');
INSERT INTO clientempteam VALUES ('124', 'CST00400', 'MB0055', '1', '2016-04-21', '0000-00-00', '2016-04-13', '07:39:35', null, null, 'MBINV001', null, '0', 'CST00401');
INSERT INTO clientempteam VALUES ('125', 'CST00400', 'MB0221', '1', '2016-04-14', '0000-00-00', '2016-04-15', '08:22:37', null, null, 'MBINV001', null, '0', 'CST00401');
INSERT INTO clientempteam VALUES ('126', 'CST01200', 'MB0167', '1', '2016-04-12', '0000-00-00', '2016-04-15', '09:12:03', null, null, '', null, '0', 'CST01202');
INSERT INTO clientempteam VALUES ('127', 'CST00500', 'MB0038', '1', '2016-04-04', '0000-00-00', '2016-04-21', '07:59:41', null, null, 'MBINV001', null, '0', 'CST00501');
INSERT INTO clientempteam VALUES ('128', 'CST00500', 'MB0031', '1', '2016-04-04', '0000-00-00', '2016-04-21', '07:59:52', null, null, 'MBINV001', null, '0', '');
