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




--
-- Database: `brtc_inventory`
--

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

--
-- Table structure for table `bus_info`
--

CREATE TABLE IF NOT EXISTS `bus_info` (
  `bus_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `product_type_id` int(11) NOT NULL DEFAULT '1',
  `bus_description` varchar(500) NOT NULL,
  `engine_no` varchar(100) NOT NULL,
  `chesis_no` varchar(100) NOT NULL,
  `reg_no` varchar(100) NOT NULL,
  `reg_date` date DEFAULT NULL,
  `spec_kpl` int(11) NOT NULL,
  `real_kpl` int(11) NOT NULL,
  `delivery_status` varchar(10) NOT NULL,
  `delivery_to_id` int(11) NOT NULL DEFAULT '1',
  `condition_id` int(11) NOT NULL DEFAULT '1',
  `route_id` int(11) NOT NULL,
  `driver_name` varchar(300) NOT NULL,
  `photo_path` text CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `bus_remarks` varchar(10000) NOT NULL,
  `bus_status` varchar(10) NOT NULL DEFAULT 'Active',
  `input_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`bus_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `bus_info`
--

INSERT INTO `bus_info` (`bus_id`, `class_id`, `product_type_id`, `bus_description`, `engine_no`, `chesis_no`, `reg_no`, `reg_date`, `spec_kpl`, `real_kpl`, `delivery_status`, `delivery_to_id`, `condition_id`, `route_id`, `driver_name`, `photo_path`, `bus_remarks`, `bus_status`, `input_date`) VALUES
(0, 0, 1, '', '', '', '', NULL, 0, 0, '', 1, 1, 4, '', '', '', 'Active', '0000-00-00 00:00:00'),
(1, 2, 1, '', 'বিএমএইচজেড-১০৩৮১০', 'এমবি১পিজেইওয়াইসি২বিজিসিএ-৩৫৫৯', 'ঢাকা-মেট্রো-ব-১১-৫৭২৯', '2012-02-15', 3, 3, 'No', 1, 2, 0, '', '', '', 'Inactive', '0000-00-00 00:00:00'),
(2, 2, 1, '', 'বিসিএইচজেড-১০৪৯৩২', 'এমবি১পিজেইওয়াইসি৬বিজিসিএ-৩৫৬৪', 'ঢাকা-মেট্রো-ব-১১-৫৭১৬', '2012-02-15', 0, 0, 'No', 1, 2, 0, '', '', '', 'Inactive', '0000-00-00 00:00:00'),
(3, 2, 1, '', 'আরবিএইচ-৭০৪৪৫৫', 'এমবি১পিজেইওয়াইসি৪বিজিসিএ-৩৫৬৩', 'ঢাকা-মেট্রো-ব-১১-৫৭২৫', '2012-02-15', 0, 0, 'No', 1, 2, 0, '', '', '', 'Inactive', '0000-00-00 00:00:00'),
(4, 2, 1, '', 'আরবিএইচ-৭০৪৪৫৬', 'এমবি১পিজেইওয়াইসি০বিজিসিএ-৩৫৬১', 'ঢাকা-মেট্রো-ব-৫৭১৮', '2012-02-15', 0, 0, 'No', 1, 2, 0, '', '', '', 'Inactive', '0000-00-00 00:00:00'),
(5, 2, 1, '', 'বিএমএইচজেড-১০৩৭৪৭', 'এমবি১পিজেইওয়াইসি২বিজিসিএ-৩৫৬২', 'ঢাকা-মেট্রো-ব-১১-৫৭৪০', '2012-02-15', 0, 0, 'No', 1, 2, 0, '', '', '', 'Inactive', '0000-00-00 00:00:00'),
(6, 2, 1, '', 'RBH-702540', 'MB1PJEYC1BGMA-3555', 'ঢাকা-মেট্রো-ব-১১-৫৭২২', '2012-02-24', 0, 0, 'No', 1, 2, 0, '', '', '', 'Inactive', '0000-00-00 00:00:00'),
(7, 2, 1, '', 'RBH-703047', 'MB1PJEYCOBGCA-3558', 'DM-BA-11-5719', '2012-02-15', 3, 3, 'Yes', 2, 2, 4, '', '', '', 'Active', '0000-00-00 00:00:00'),
(8, 2, 1, '', 'BMHZ-103810', 'MB1PJEYC2BGCA-3559', 'DM-BA-11-5729', '2012-02-15', 3, 3, 'Yes', 2, 2, 2, '', '', '', 'Active', '0000-00-00 00:00:00'),
(9, 2, 1, '', 'BCHZ-104932', 'MB1PJEYC6BGCA-3564', 'DM-BA-11-5716', '2012-02-15', 0, 0, 'Yes', 2, 2, 3, '', '', '', 'Active', '0000-00-00 00:00:00'),
(10, 2, 1, '', 'RBH-704455', 'MB1PJEYC4BGCA-3563', 'DM-BA-11-5725', '2012-02-15', 3, 3, 'Yes', 2, 2, 2, '', '', '', 'Active', '0000-00-00 00:00:00'),
(11, 2, 1, '', 'RBH-704456', 'MB1PJEYCOBGCA-3561', 'DM-BA-11-5718', '2012-02-15', 3, 3, 'Yes', 2, 2, 1, '', '', '', 'Active', '0000-00-00 00:00:00'),
(12, 2, 1, '', 'BMHZ-103747', 'MB1PJEYC2BGCA-3562', 'DM-BA-11-5740', '2012-02-15', 3, 3, 'Yes', 2, 2, 3, '', '', '', 'Active', '0000-00-00 00:00:00'),
(13, 2, 1, '', 'RBH-702540', 'MB1PJEYC1BGMA-3555', 'DM-BA-11-5734', '2012-02-15', 3, 3, 'Yes', 2, 2, 1, '', '', '', 'Active', '0000-00-00 00:00:00'),
(14, 2, 1, '', 'RBH-702538', 'MB1PJEYC5BGMA-3557', 'DM-BA-11-5724', '2012-02-24', 3, 3, 'Yes', 2, 2, 3, '', '', '', 'Active', '0000-00-00 00:00:00'),
(15, 2, 1, '', 'RBH-704458', 'MB1PJEYC2BGNA-3552', 'DM-BA-11-5742', '2012-02-24', 3, 3, 'Yes', 2, 2, 1, '', '', '', 'Active', '0000-00-00 00:00:00'),
(16, 2, 1, '', 'RBH-704459', 'MB1PJEYC4BGNA-3553', 'DM-BA-11-5735', '2012-02-24', 3, 3, 'Yes', 2, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(17, 2, 1, '', 'RBH-702541', 'MB1PJEYCXBGMA-3554', 'DM-BA-11-5734', '2012-02-24', 3, 3, 'Yes', 2, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(18, 2, 1, '', 'RBH-702539', 'MB1PJEYC3BGMA-3556', 'DM-BA-11-5737', '2012-02-24', 3, 3, 'Yes', 2, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(19, 2, 1, '', 'BMGZ-103748', 'MB1PJEYCOBGCA-3575', 'DM-BA-11-5723', '2012-03-08', 3, 3, 'Yes', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(20, 2, 1, '', 'BMGZ-103808', 'MB1PJEYC2BGCA-3576', 'DM-BA-11-5717', '2012-03-08', 3, 3, 'Yes', 2, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(21, 2, 1, '', 'RBH-702543', 'MB1PJEYC1BGCA-3567', 'DM-BA-11-5728', '2012-03-08', 3, 3, 'Yes', 2, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(22, 2, 1, '', 'RBH-703048', 'MB1PJEYC3BGCA-3568', 'DM-BA-11-5739', '2012-03-08', 3, 3, 'Yes', 2, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(23, 2, 1, '', 'BCHZ-104935', 'MB1PJEYC8BGCA-3565', 'DM-BA-11-5733', '2012-03-08', 3, 3, 'Yes', 2, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(24, 2, 1, '', 'BMHZ-103750', 'MB1PJEYCXBGCH-3566', 'DM-BA-11-5736', '2012-03-08', 3, 3, 'Yes', 2, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(25, 2, 1, '', 'BMHZ-103751', 'MB1PJEYC6BGCA-3578', 'DM-BA-11-5741', '2012-03-20', 3, 3, 'Yes', 2, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(26, 2, 1, '', 'BMHZ-103749', 'MB1PJEYC9BGCA-3574', 'DM-BA-11-5731', '2012-03-20', 3, 3, 'Yes', 2, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(27, 2, 1, '', 'BMHZ-103807', 'MB1PJEYC3BGCA-3571', 'DM-BA-11-5730', '2012-03-20', 3, 3, 'Yes', 2, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(28, 2, 1, '', 'RBH-704454', 'MB1PJEYC9BGCA-3560', 'DM-BA-11-5720', '2012-03-30', 3, 3, 'Yes', 4, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(29, 2, 1, '', 'BMHZ-104527', 'MB1PJEYC4BGCA-3580', 'DM-BA-11-5721', '2012-03-30', 3, 3, 'Yes', 2, 2, 2, 'হেলাল', '', '', 'Active', '0000-00-00 00:00:00'),
(30, 2, 1, '', 'BCHZ-104528', 'MB1PJEYC4BGCA-3577', 'DM-BA-11-5727', '2012-03-30', 0, 0, 'Yes', 4, -1, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(31, 2, 1, '', 'BCHZ-104931', 'MB1PJEYC1BGCA-3570', 'DM-BA-11-5738', '2012-03-30', 3, 3, 'Yes', 2, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(32, 2, 1, '', 'RBH-703050', 'MB1PJEYC5BGCA-3572', 'DM-BA-11-5732', '2012-03-30', 3, 3, 'Yes', 2, 2, 3, 'সেলিম', '', '', 'Active', '0000-00-00 00:00:00'),
(33, 2, 1, '', 'BMHZ-103809', 'MB1PJEYC7BGCA-3573', 'DM-BA-11-5726', '2012-03-30', 3, 3, 'Yes', 2, 2, 1, 'রশিদ', '', '', 'Active', '0000-00-00 00:00:00'),
(34, 2, 1, '', 'BCHZ-106751', 'MB1PJEYC9CGBA-3606', 'DM-BA-11-5797', '2012-03-13', 3, 3, 'Yes', 6, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(35, 2, 1, '', 'RBH-703051', 'MB1PJEYC5BGCA-3569', 'DM-BA-11-5793', '2012-04-13', 3, 3, 'Yes', 6, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(36, 2, 1, '', 'BCHZ-406914', 'MB1PJEYC3CGBA-3603', 'DM-BA-11-5796', '2012-04-13', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(37, 2, 1, '', 'BCHZ-106752', 'MB1PJEYC7CGBA-3605', 'DM-BA-11-5798', '2012-04-13', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(38, 2, 1, '', 'BCHZ-106747', 'MB1PJEYC1CGBA-3602', 'DM-BA-11-5799', '2012-04-13', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(39, 2, 1, '', 'RBH-702542', 'MB1PJEYC8BGCA-3579', 'DM-BA-11-5795', '2012-04-14', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(40, 2, 1, '', 'CBHZ-400396', 'MB1PJEYCXCGBA-3615', 'DM-BA-11-5811', '2012-05-02', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(41, 2, 1, '', 'BCHZ-406908', 'MB1PJEYC8CGBA-3614', 'DM-BA-11-5810', '2012-05-02', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(42, 2, 1, '', 'BCHZ-406913', 'MB1PJEYC6CGBA3613', 'DM-BA-11-5809', '2012-05-02', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(43, 2, 1, '', 'BCHZ-106750', 'MB1PJEYC4CGBA3612', 'DM-BA-11-5794', '2012-05-02', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(44, 2, 1, '', 'CBHZ-400397', 'MB1PJEYC5CGBA3604', 'DM-BA-11-5803', '2012-05-02', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(45, 2, 1, '', 'BCHZ-406916', 'MB1PJEYC2CGBA3611', 'DM-BA-11-5804', '2012-05-02', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(46, 2, 1, '', 'BCHZ-106749', 'MB1PJEYCOCGBA3610', 'DM-BA-11-5805', '2012-05-02', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(47, 2, 1, '', 'BCHZ-406920', 'MB1PJEYCOCGBA3607', 'DM-BA-11-5792', '2012-05-02', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(48, 2, 1, '', 'BCHZ-106755', 'MB1PJEYCXCGBA-3601', 'DM-BA-11-5806', '2012-05-02', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(49, 2, 1, '', 'BCHZ-106748', 'MB1PJEYC2CGBA-3608', 'DM-BA-11-5807', '2012-05-02', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(50, 2, 1, '', 'BCHZ-406376', 'MB1PJEYC3CGBA-3617', 'DM-BA-11-5823', '2012-05-02', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(51, 2, 1, '', 'BCHZ-106754', 'MB1PJEPYC4CGBA-3609', 'DM-BA-11-5808', '2012-05-02', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(52, 2, 1, '', 'BCHZ-406379', 'MB1PJEYC6CGBA-3627', 'DM-BA-11-5815', '2012-05-15', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(53, 2, 1, '', 'CBHZ-401105', 'MB1PJEYC1CGBA-3633', 'DM-BA-11-5813', '2012-05-15', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(54, 2, 1, '', 'BCHZ-406378', 'MB1PJEYC8CGBA-3628', 'DM-BA-11-5816', '2012-05-15', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(55, 2, 1, '', 'BCHZ-406377', 'MB1PJEYC1CGBA-3616', 'On Processing', '2012-05-15', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(56, 2, 1, '', 'CBHZ-401001', 'MB1PJEYC3CGBA-3634', 'DM-BA-11-5814', '2012-05-15', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(57, 2, 1, '', 'CBHZ-401382', 'MB1PJEYCOCGAA-3653', 'DM-BA-11-5802', '2012-05-23', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(58, 2, 1, '', 'CBHZ-401372', 'MB1PJEYCOCGAA-3670', 'DM-BA-11-5801', '2012-05-23', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(59, 2, 1, '', 'CBHZ-401370', 'MB1PJEYCOCGAA-3654', 'DM-BA-11-5790', '2012-05-23', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(60, 2, 1, '', 'CBHZ-401002', 'MB1PJEYC8CGBA-3631', 'DM-BA-11-5800', '2012-05-23', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(61, 2, 1, '', 'CBHZ-401113', 'MB1PJEYC4CGAA-3655', 'DM-BA-11-5817', '2012-05-23', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(62, 2, 1, '', 'CBHZ-401369', 'MB1PJEYC4CGAA-3669', 'DM-BA-11-5818', '2012-05-23', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(63, 2, 1, '', 'CBHZ-401373', 'MB1PJEYC4CGAA-3672', 'DM-BA-11-5819', '2012-05-23', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(64, 2, 1, '', 'CBHZ-401558', 'MB1PJEYC8CGAA-3657', 'DM-BA-11-5820', '2012-05-23', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(65, 2, 1, '', 'CBHZ-400400', 'MB1PJEYC9CGAA-3652', 'DM-BA-11-5822', '2012-05-23', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(66, 2, 1, '', 'CBHZ-401376', 'MB1PJEYCXCGAA-3658', 'DM-BA-11-5821', '2012-05-23', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(67, 2, 1, '', 'CBHZ-401000', 'MB1PJEYC5CGBA-3635', '0000', '2012-06-13', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(68, 2, 1, '', 'CBHZ-401112', 'MB1PJEYC5CGAA-3681', 'DM-BA-11-5896', '2012-06-13', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(69, 2, 1, '', 'CBHZ-401109', 'MB1PJEYC7CGAA-3682', 'DM-BA-11-5907', '2012-06-13', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(70, 2, 1, '', 'CBHZ-401004', 'MB1PJEYC5CGAA-3678', 'DM-BA-11-5898', '2011-06-13', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(71, 2, 1, '', 'CBHZ-401114', 'MB1PJEYC8CGAA-3691', 'DM-BA-11-5903', '2012-06-13', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(72, 2, 1, '', 'CBHZ-401103', 'MB1PJEYC7CGAA-3679', 'DM-BA-11-5897', '2012-06-13', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(73, 2, 1, '', 'CBHZ-401547', 'MB1PJEYC7CGAA-3696', 'DM-BA-11-5904', '2012-06-13', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(74, 2, 1, '', 'CBHZ-401101', 'MB1PJEYCXCGAA-3689', 'DM-BA-11-5901', '2012-06-13', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(75, 2, 1, '', 'CBHZ-401553', 'MB1PJEYCOCGAA-3698', 'DM-BA-11-5915', '2012-06-13', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(76, 2, 1, '', 'CBHZ-401374', 'MB1PJEYC3CGAA-3677', 'DM-BA-11-5916', '2012-06-13', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(77, 2, 1, '', 'RBH-704457', 'MB1PJEYCOCGYA-3799', 'DM-BA-11-5909', '2012-06-13', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(78, 2, 1, '', 'BCHZ-106746', 'MB1PJEYC2CGYA-3822', 'DM-BA-11-5910', '2012-06-13', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(79, 2, 1, '', 'CYHZ-404943', 'MB1PJEYC4CGAY-3806', 'DM-BA-11-5911', '2012-06-13', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(80, 2, 1, '', 'CBHZ-401554', 'MB1PJEYC5CGAA-3700', 'DM-BA-11-5912', '2012-06-13', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(81, 2, 1, '', 'CBHZ-401003', 'MB1PJEYC6CGAA-3690', 'DM-BA-11-5913', '2012-06-13', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(82, 2, 1, '', 'CBHZ-401549', 'MB1PJEYCXCGAA-3692', 'DM-BA-11-5914', '2012-06-13', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(83, 2, 1, '', 'CBHZ-401559', 'MB1PJEYC3CGYA-3814', 'DM-BA-11-5917', '2012-06-13', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(84, 2, 1, '', 'CAHZ-403587', 'MB1PJEYC5CGYA-3796', '', '2012-06-25', 5, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(85, 2, 1, '', 'CYHZ-404945', 'MB1PJEYC5CGAY-3815', 'DM-BA-11-5919', '2012-06-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(86, 2, 1, '', 'CYHZ-405347', 'MB1PJEYC5CGYA-3829', 'DM-BA-11-5920', '2012-06-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(87, 2, 1, '', 'CYHZ-405199', 'MB1PJEYC6CGYA-3807', 'DM-BA-11-5908', '2012-06-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(88, 2, 1, '', 'BCHZ-406695', 'MB1PJEYC9CGBA-3587', '....', '2012-07-03', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(89, 2, 1, '', 'BCHZ-406694', 'MB1PJEYC5CGBA-3618', '....', '2012-07-03', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(90, 2, 1, '', 'CBHZ-401108', 'MB1PJEYCXCGBA-3632', '...', '2012-07-03', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(91, 2, 1, '', 'CBHZ-401550', 'MB1PJEYCOCGAA-3779', '....', '2012-07-06', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(92, 2, 1, '', 'CAHZ-403578', 'MB1PJEYC6CGAA-3768', '.....', '2012-07-06', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(93, 2, 1, '', 'RBH-703049', 'MB1PJEYC7CGYA-3797', '....', '2012-07-06', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(94, 2, 1, '', 'CYHZ-405198', 'MB1PJEYC7CGYA-3816', '....', '2012-07-06', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(95, 2, 1, '', 'CBHZ-401555', 'MB1PJEYC8CGAA-3710', '....', '2012-07-06', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(96, 2, 1, '', 'BMHZ-104526', 'MB1PJEYCXBGCA-3583', '....', '2012-07-06', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(97, 2, 1, '', 'CBHZ-401557', 'MB1PJEYC1CGAA-3743', 'DM-BA-11-5980', '2012-07-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(98, 2, 1, '', 'CAHZ-403580', 'MB1PJEYC4CGAA-3770', '......', '2012-07-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(99, 2, 1, '', 'CBHZ-400398', 'MB1PJEYC5CGAA-3745', 'DM-BA-11-5979', '2012-07-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(100, 2, 1, '', 'CAHZ-403583', 'MB1PJEYC6CGAA-3754', 'DM-BA-11-5977', '2012-07-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(101, 2, 1, '', 'CBHZ-401552', 'MB1PJEYC7CGAA-3701', 'DM-BA-11-5975', '2012-07-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(102, 2, 1, '', 'CBHZ-401560', 'MB1PJEYC7CGAA-3732', 'DM-BA-11-5971', '2012-07-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(103, 2, 1, '', 'CBHZ-401102', 'MB1PJEYC8CGAA-3741', 'DM-BA-11-5974', '2012-07-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(104, 2, 1, '', 'BCHZ-406910', 'MB1PJEYC1CGBA-3597', 'DM-BA-11-5993', '2012-07-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(105, 2, 1, '', 'BCHZ-106753', 'MB1PJEYC3CGBA--3598', 'DM-BA-11-5992', '2012-07-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(106, 2, 1, '', 'BCHZ-104933', 'MB1PJEY-C1BGCA-3584', '....', '2012-07-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(107, 2, 1, '', 'CYHZ-405547', 'MB1PJEYC2CGYA-3867', 'DM-BA-11-5996', '2012-07-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(108, 2, 1, '', 'CAHZ-403585', 'MB1PJEYC7CGAA-3780', 'DM-BA-11-5973', '2012-07-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(109, 2, 1, '', 'CAHZ-403584', 'MB1PJEYC9CGAA-3778', 'DM-BA-11-5972', '2012-07-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(110, 2, 1, '', 'CYHZ--404944', 'MB1PJEYCXCGYA-3809', 'DM-BA-11-5994', '2012-07-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(111, 2, 1, '', 'CYHZ-405548', 'MB1PJEYC6CGYA-3869', 'DM-BA-11-5995', '2012-07-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(112, 2, 1, '', 'CYHZ-405200', 'MB1PJEYC1CGYA-3813', 'DM-BA-11-5900', '2012-07-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(113, 2, 1, '', 'CBHZ-401379', 'MB1PJEYC3CGAA-3713', 'DM-BA-11-5905', '2012-07-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(114, 2, 1, '', 'CBHZ-401377', 'MB1PJEYC9CGAA-3716', 'DM-BA-11-5902', '2012-07-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(115, 2, 1, '', 'CBHZ-401104', 'MB1PJEYC9CGAA-3747', 'DM-BA-11-5899', '2012-07-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(116, 2, 1, '', 'CBHZ-401548', 'MB1PJEYCXCGAA-3742', 'DM-BA-11-5906', '2012-07-25', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(117, 2, 1, '', 'CYHZ-405550', 'MB1PJEYC0CGYA-3866', 'DM-BA-11-5989', '2012-08-09', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(118, 2, 1, '', 'CYHZ-404942', 'MB1PJEYC0CGYA-3897', 'DM-BA-11-5988', '2012-08-09', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(119, 2, 1, '', 'CYHZ-405808', 'MB1PJEYC2CGYA-3870', 'DM-BA-11-5990', '2012-08-09', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(120, 2, 1, '', 'CYHZ-405346', 'MB1PJEYC4CGYA-3854', 'DM-BA-11-5986', '2012-08-09', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(121, 2, 1, '', 'CYHZ-405202', 'MB1PJEYC4CGYA-3868', 'DM-BA-11-5991', '2012-08-09', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(122, 2, 1, '', 'CYHZ-406019', 'MB1PJEYC0CGYA-3902', '....', '2012-08-15', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(123, 2, 1, '', 'CYHZ-405813', 'MB1PJEYC8CGYA-3873', '...', '2012-08-15', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(124, 2, 1, '', 'CYHZ-406021', 'MB1PJEYC8CGYA-3906', '....', '2012-08-15', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(125, 2, 1, '', 'CYHZ-405549', 'MB1PJEYC8CGYA-3937', '.....', '2012-08-15', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(126, 2, 1, '', 'CBHZ-401561', 'MB1PJEYCXCGAA-3708', '....', '2012-08-15', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(127, 2, 1, '', 'CBHZ-400399', 'MB1PJEYCXCGAA-3711', '......', '2012-08-15', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(128, 2, 1, '', 'CYHZ-405546', 'MB1PJEYCXCGYA-3857', '......', '2012-08-15', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(129, 2, 1, '', 'CYHZ-405525', 'MB1PJEYC4CGYA-3871', 'DM-BA-11-5984', '2012-09-14', 3, 3, 'No', 1, -1, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(130, 2, 1, '', 'CYHZ-405522', 'MB1PJEYC6CGYA-3855', 'DM-BA-11-5983', '2012-09-14', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(131, 2, 1, '', 'CYHZ-405524', 'MB1PJEYC6CGYA-3872', 'DM-BA-11-5970', '2012-09-14', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(132, 2, 1, '', 'CYHZ-405201', 'MB1PJEYC8CGYA-3808', 'DM-BA-11-5981', '2012-09-14', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(133, 2, 1, '', 'CYHZ-405345', 'MB1PJEYC9CGYA-3865', 'DM-BA-11-5982', '2012-09-14', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(134, 2, 1, '', 'CYHZ-405811', 'MB1PJEYC4CGYA-3899', 'DM-BA-11-5985', '2012-09-14', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(135, 2, 1, '', 'CYHZ-406017', 'MB1PJEYC6CGYA-3905', 'DM-BA-11-5987', '2012-09-14', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(136, 2, 1, '', 'CYHZ-406846', 'MB1PJEYCXCGXA-3953', 'DM-BA-11-6004', '2012-09-14', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(137, 2, 1, '', 'CBHZ-401110', 'MB1PJEYC0CGBA--3638', '......', '2012-09-14', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(138, 2, 1, '', 'CBHZ-401100', 'MB1PJEYC9CGBA-3637', '.........', '2012-09-14', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(139, 2, 1, '', 'CBHZ-401107', 'MB1PJEYC9CGBA-3640', '.......', '2012-09-14', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(140, 2, 1, '', 'CBHZ-401368', 'MB1PJEYC1CGAA-3676', '.........', '2012-09-14', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(141, 2, 1, '', 'CYHZ-405814', 'MB1PJEYC7CGYA-3900', 'DM-BA-11-6003', '2012-09-14', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(142, 2, 1, '', 'CBHZ--401551', 'MB1PJEYC1CGAA-3709', 'DM-BA-11-5978', '2012-09-14', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(143, 2, 1, '', 'CYHZ-406022', 'MB1PJEYC3CGYA-3926', 'DM-BA-11-5998', '2012-09-14', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(144, 2, 1, '', 'CYHZ-406020', 'MB1PJEYC4CGYA-3904', 'DM-BA-11-5999', '2012-09-14', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(145, 2, 1, '', 'CYHZ-405523', 'MB1PJEYC8CGYA-3856', 'DM-BA-11-6002', '2012-09-14', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(146, 2, 1, '', 'CYHZ-405521', 'MB1PJEYC8CGYA-3923', 'DM-BA-11-6001', '2012-09-14', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(147, 2, 1, '', 'CYHZ-405810', 'MB1PJEYCXCGYA-3924', 'DM-BA-11-6000', '2012-09-14', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(148, 2, 1, '', 'BCHZ-406907', 'MB1PJEYCXCGYA-3941', 'DM-BA-11-5997', '2012-09-14', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(149, 2, 1, '', 'CBHZ-401380', 'MB1PJEYC3CGAA-3744', '...', '2012-09-17', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(150, 2, 1, '', 'CYHZ-405349', 'MB1PJEYC5CGYA-3930', '......', '2012-09-17', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(151, 2, 1, '', 'CYHZ-406961', 'MB1PJEYC6CGXA-3948', '....', '2012-09-17', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(152, 2, 1, '', 'CBHZ-401371', 'MB1PJEYCXCGAA-3675', '......', '2012-09-17', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(153, 2, 1, '', 'CYHZ-405348', 'MB1PJEYC5CGYA-3927', '...', '2012-09-17', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(154, 2, 1, '', 'BCHZ-104934', 'MB1PJEYC3BGCA-3585', '....', '2012-09-17', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(155, 2, 1, '', 'BCHZ-406919', 'MB1PJEYC0CGBA-3591', '....', '2012-09-17', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(156, 2, 1, '', 'CBHZ-401381', 'MB1PJEYC8CGAA-3674', '....', '2012-09-17', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(157, 2, 1, '', 'CYHZ-405815', 'MB1PJEYC7CGYA--3928', '...', '2012-09-17', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(158, 2, 1, '', 'MBHZ-104529', 'MB1PJEYC6BGCA-3981', '....', '2012-09-17', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(159, 2, 1, '', 'CYHZ-406844', 'MB1PJEYC6CGXA-3951', '....', '2012-09-17', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(160, 2, 1, '', 'CYHZ-404946', 'MB1PJEYC9CGYA-3798', '....', '2012-09-17', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(161, 2, 1, '', 'CBHZ-401357', 'MB1PJEYC3CGAA-3680', '.....', '2012-09-17', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(162, 2, 1, '', 'CAHZ--403581', 'MB1PJEYC2CGAA-3749', '....', '2012-09-17', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(163, 2, 1, '', 'BMHZ-104525', 'MB1PJEYC8BGCA-3582', '.....', '2012-09-17', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(164, 2, 1, '', 'CAHZ-403582', 'MB1PJEYC4CGAA-3753', '....', '2012-09-17', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(165, 2, 1, '', 'CBHZ-401556', 'MB1PJEYC0CGAA-3751', '....', '2012-09-17', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(166, 2, 1, '', 'CBHZ-401378', 'MB1PJEYC7CGAA-3746', '....', '2012-09-17', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(167, 2, 1, '', 'CYHZ-406960', 'MB1PJEYC1CGXA-3954', '.....', '2012-09-17', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(168, 2, 1, '', 'BCHZ-406692', 'MB1PJEYCXCGBA-3596', '....', '2012-09-17', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(169, 2, 1, '', 'CXHZ-407422', 'MB1PJEYC7CGXA-3988', '....', '2012-09-19', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(170, 2, 1, '', 'CXHZ-407577', 'MB1PJEYC5CGXA-4010', '.....', '2012-09-19', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(171, 2, 1, '', 'CVHZ-411658', 'MB1PJEYC2CGVA-4217', '.....', '2012-09-19', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(172, 2, 1, '', 'CYHZ-405806', 'MB1PJEYC9CGYA-3932', '....', '2012-09-19', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(173, 2, 1, '', 'BCHZ-406917', 'MB1PJEYC4CGBA-3593', '....', '2012-09-19', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(174, 2, 1, '', 'CXHZ-408001', 'MB1PJEYC7CGWA-4118', '....', '2012-09-19', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(175, 2, 1, '', 'CXHZ-407691', 'MB1PJEYC1CGWA-4082', '....', '2012-09-19', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(176, 2, 1, '', 'BCHZ-406880', 'MB1PJEYC7CGXA-3943', '.....', '2012-09-19', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(177, 2, 1, '', 'CXHZ-408004', 'MB1PJEYCXCGWA-4078', '......', '2012-09-19', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(178, 2, 1, '', 'CXHZ-407753', 'MB1PJEYC7CGXA-4008', '.....', '2012-09-19', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(179, 2, 1, '', 'CXHZ-406844', 'MB1PJEYC3CGWA-4083', '.......', '2012-09-19', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(180, 2, 1, '', 'CYHZ-406845', 'MB1PJEYC5CGXA-3956', '........', '2012-09-19', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(181, 2, 1, '', 'CXHZ-407417', 'MB1PJEYC5CGXA-4007', '.......', '2012-09-19', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(182, 2, 1, '', 'CXHZ--407414', 'MB1PJEYC4CGXA-3950', '........', '2012-09-19', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(183, 2, 1, '', 'CWHZ-409555', 'MB1PJEYC2CGWA-4141', '........', '2012-09-19', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(184, 2, 1, '', 'CXHZ-407690', 'MB1PJEYC7CGXA-4011', '..........', '2012-09-19', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(185, 2, 1, '', 'CYHZ-405809', 'MB1PJEYC9CGYA-3901', '........', '2012-09-19', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(186, 2, 1, '', 'CYHZ-406963', 'MB1PJEYC0CGXA-3959', '........', '2012-09-19', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(187, 2, 1, '', 'CYHZ-406962', 'MB1PJEYC3CGXA-3955', '.......', '2012-09-19', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(188, 2, 1, '', 'CYHZ-406488', 'MB1PJEYC8CGXA-3949', '.....', '2012-09-19', 3, 3, 'No', 1, -1, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(189, 2, 1, '', 'CXHZ-407416', 'MB1PJEYC0CGXA-3993', '.....', '2012-09-21', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(190, 2, 1, '', 'CXHZ-407420', 'MB1PJEYC7CGXA-3991', '.....', '2012-09-21', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(191, 2, 1, '', 'CXHZ-407413', 'MB1PJEYC3CGXA-3986', '.........', '2012-09-21', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(192, 2, 1, '', 'CYHZ-406016', 'MB1PJEYC6CGYA-3936', '....', '2012-09-21', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(193, 2, 1, '', 'CYHZ-405807', 'MB1PJEYC1CGYA-3925', '.........', '2012-09-21', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(194, 2, 1, '', 'CXHZ-408000', 'MB1PJEYC6CGWA-4076', '.......', '2012-09-21', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(195, 2, 1, '', 'CYHZ-406964', 'MB1PJEYC5CGXA-3987', '.........', '2012-09-21', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(196, 2, 1, '', 'CXHZ-407689', 'MB1PJEYC0CGXA-4013', '...', '2012-09-21', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(197, 2, 1, '', 'CXHZ-407687', 'MB1PJEYC5CGXA-3990', '........', '2012-09-21', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(198, 2, 1, '', 'CXHZ--407688', 'MB1PJEYC9CGXA-4009', '......', '2012-09-21', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(199, 2, 1, '', 'CXHZ-408798', 'MB1PJEYC9CGWA-4072', '......', '2012-09-21', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(200, 2, 1, '', 'CXHZ-407421', 'MB1PJEYC2CGWA-4074', '........', '2012-09-21', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(201, 2, 1, '', 'CYHZ-405812', 'MB1PJEYC2CGYA-3903', '......', '2012-09-21', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(202, 2, 1, '', 'CXHZ-407999', 'MB1PJEYC9CGXA-4012', '........', '2012-09-21', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(203, 2, 1, '', 'CXHZ-407415', 'MB1PJEYC1CGXA-3985', '.......', '2012-09-21', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(204, 2, 1, '', 'CXHZ-407418', 'MB1PJEYC9CGXA-3989', '.....', '2012-09-21', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(205, 2, 1, '', 'CXHZ-407419', 'MB1PJEYC9CGXA-3992', '......', '2012-09-21', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(206, 2, 1, '', 'CVHZ--412004', 'MB1PJEYC6CGVA-4222', '........', '2012-09-28', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(207, 2, 1, '', 'CTHZ-413550', 'MB1PJEYC9CGTA-4243', '.....', '2012-09-28', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(208, 2, 1, '', 'CTHZ-413381', 'MB1PJEYC8CGTA-4278', '......', '2012-09-28', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(209, 2, 1, '', 'CTHZ-413463', 'MB1PJEYC5CGTA-4271', '.......', '2012-09-28', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(210, 2, 1, '', 'CWHZ-409556', 'MB1PJEYC3CGVA-4212', '......', '2012-09-28', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(211, 2, 1, '', 'CXHZ-407754', 'MB1PJEYCXCGWA-4081', '.......', '2012-09-28', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(212, 2, 1, '', 'CVHZ-411656', 'MB1PJEYC5CGVA-4213', '...........', '2012-09-28', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(213, 2, 1, '', 'CVHZ-411659', 'MB1PJEYC4CGVA-4221', '.......', '2012-09-28', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(214, 2, 1, '', 'CTHZ-413382', 'CTHZ-413382', '.........', '2012-09-28', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(215, 2, 1, '', 'CWHZ-411360', 'MB1PJEYC1CGVA-4242', '........', '2012-09-28', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(216, 2, 1, '', 'CVHZ-412363', 'MB1PJEYC0CGTA-4274', '.....', '2012-09-28', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(217, 2, 1, '', 'CXHZ-407579', 'MB1PJEYC4CGXA-4015', '...........', '2012-09-28', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(218, 2, 1, '', 'CTHZ-413383', 'MB1PJEYC7CGTA-4272', '.........', '2012-09-28', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(219, 2, 1, '', 'CXHZ-408002', 'MB1PJEYC8CGWA-4080', '.....', '2012-09-28', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(220, 2, 1, '', 'CWHZ-409554', 'MB1PJEYC9CGWA-4122', '.........', '2012-09-28', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(221, 2, 1, '', 'CVHZ-412007', 'MB1PJEYC2CGTA-4258', '.......', '2012-09-28', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(222, 2, 1, '', 'CWHZ-409553', 'MB1PJEYC5CGWA-4120', '.......', '2012-09-28', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(223, 2, 1, '', 'CVHZ-412361', 'MB1PJEYC3CGTA-4270', '...', '2012-09-28', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(224, 2, 1, '', 'CVHZ-411653', 'MB1PJEYC0CGVA-4216', '........', '2012-09-28', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(225, 2, 1, '', 'CWHZ-409552', 'MB1PJEYC7CGEA-4121', '.......', '2012-09-28', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(226, 2, 1, '', 'CXHZ-407581', 'MB1PJEYC7CGVA-4214', '.........', '2012-10-02', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(227, 2, 1, '', 'CVHZ-412006', 'MB1PJEYC9CGVA-4215', '.........', '2012-10-02', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(228, 2, 1, '', 'CWHZ-409551', 'MB1PJEYC9CGWA-4119', '.......', '2012-10-02', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(229, 2, 1, '', 'CVHZ-411948', 'MB1PJEYC9CGTA-4256', '......', '2012-10-02', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(230, 2, 1, '', 'BCHZ-406909', 'MB1PJEYC5CGBA-3599', '....', '2012-10-08', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(231, 2, 1, '', 'BCHZ-406911', 'MB1PJEYC8CGBA-3595', '....', '2012-10-08', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(232, 2, 1, '', 'CBHZ-411951', 'MB1PJEYC0CGTA-4257', '....', '2012-10-08', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(233, 2, 1, '', 'CWHZ-411357', 'MB1PJEYC3CGVA-4243', '....', '2012-10-08', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(234, 2, 1, '', 'CXHZ-408799', 'MB1PJEYC6CGVA-4219', '...', '2012-10-08', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(235, 2, 1, '', 'CVHZ-411950', 'MB1PJEYCXCGVA-4224', '....', '2012-10-08', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(236, 2, 1, '', 'CVHZ-412005', 'MB1PJEYCXCGVA-4241', '....', '2012-10-08', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(237, 2, 1, '', 'CXHZ-407752', 'MB1PJEYC0CGWA-4123', '....', '2012-10-08', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(238, 2, 1, '', 'BCHZ-406915', 'MB1PJEYC2CGBA-3592', '...', '2012-10-08', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(239, 2, 1, '', 'BCHZ-406912', 'MB1PJEYC6CGBA-3594', '.....', '2012-10-08', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(240, 2, 1, '', 'CTHZ-413501', 'MB1PJEYC1CGTA-4283', '....', '2012-10-08', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(241, 2, 1, '', 'SBH-699590', 'MB1PJEYC3BGPA-3551', '.....', '2012-10-08', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(242, 2, 1, '', 'CTHZ-413387', 'MB1PJEYC4CGTA-4276', '....', '2012-10-15', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(243, 2, 1, '', 'CWHZ-411367', 'MB1PJEYC6CGTA-4277', '....', '2012-10-08', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(244, 2, 1, '', 'CTHZ-413386', 'MB1PJEYCXCGTA-4279', '....', '2012-10-08', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(245, 2, 1, '', 'CTHZ-413379', 'MB1PJEYCXCGTA-4282', '....', '2012-10-08', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(246, 2, 1, '', 'CVHZ-412360', 'MB1PJEYC3CGTA-4262', '....', '2012-10-16', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(247, 2, 1, '', 'CVHZ-411952', 'MB1PJEYC2CGVA-4220', '......', '2012-10-16', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(248, 2, 1, '', 'CXHZ-407580', 'MB1PJEYC4CGVA-4218', '....', '2012-10-16', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(249, 2, 1, '', 'CWHZ-411359', 'MB1PJEYC0CGVA-4247', '.....', '2012-10-16', 3, 3, 'No', 1, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(250, 2, 1, '', 'CTHZ-413462', 'MB1PJEYC5CGSA-4297', '....', '2012-10-16', 3, 3, 'Yes', 10, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00'),
(251, 2, 1, '', 'CTHZ-413385', 'MB1PJEYC8CGTA-4281', '....', '2012-10-16', 3, 3, 'Yes', 10, 2, 0, '', '', '', 'Active', '0000-00-00 00:00:00');

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

--
-- Table structure for table `company_info`
--

CREATE TABLE IF NOT EXISTS `company_info` (
  `company_id` int(5) NOT NULL,
  `company_name` varchar(500) NOT NULL,
  `company_address` varchar(300) NOT NULL,
  `contact_person` varchar(50) NOT NULL,
  `designation` varchar(30) NOT NULL,
  `phone` varchar(30) NOT NULL,
  `email` varchar(20) NOT NULL,
  `company_remarks` varchar(10000) NOT NULL,
  PRIMARY KEY (`company_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `company_info`
--

INSERT INTO `company_info` (`company_id`, `company_name`, `company_address`, `contact_person`, `designation`, `phone`, `email`, `company_remarks`) VALUES
(1, 'Ashok Leyland Limited', '1 Sardar Patel Road, Guindy, Chennai, India', 'Mr. Kaushik Sarkar', 'Country Head, Ashok Leyland Li', '+88-017-133-64825', 'Kaushik.Sarkar@ashok', ''),
(2, 'Daewoo International Corporation', 'CPO Box-2810, Seoul, Korea', 'Md. Golam Mostafa', 'Assistant General Manager, Dae', '+88-017-130-82283', 'mostafa@daewoo.bd.co', '-'),
(3, 'Dongfeng Yangtse Motor (Wuhan) Co., Ltd.', '30 Gutian, 4 Road, Qiaokou District, Wuhan City, Hubei Province, PR China', 'Hu Yousan', 'Local Representative, Dongfeng', '-', '-', '-');

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

--
-- Table structure for table `delivery`
--

CREATE TABLE IF NOT EXISTS `delivery` (
  `delivery_id` int(11) NOT NULL,
  `delivery_date` date NOT NULL,
  `input_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `product_type_id` int(20) NOT NULL,
  `product_id` int(11) NOT NULL,
  `regt_no` varchar(30) NOT NULL,
  `delivery_from_id` int(11) NOT NULL,
  `delivery_to_id` int(11) NOT NULL,
  `delivery_purpose` varchar(50) NOT NULL,
  `delivery_remarks` varchar(10000) NOT NULL,
  `status` varchar(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `delivery`
--

INSERT INTO `delivery` (`delivery_id`, `delivery_date`, `input_date`, `product_type_id`, `product_id`, `regt_no`, `delivery_from_id`, `delivery_to_id`, `delivery_purpose`, `delivery_remarks`, `status`) VALUES
(19, '2014-10-16', '0000-00-00 00:00:00', 1, 8, 'DM-BA-11-5719', 1, 2, 'চালানোর জন্য', '', 'Active'),
(20, '2014-10-16', '0000-00-00 00:00:00', 1, 9, 'DM-BA-11-5729', 1, 2, 'চালানোর জন্য', '', 'Active'),
(21, '2014-10-16', '0000-00-00 00:00:00', 1, 10, 'DM-BA-11-5716', 1, 2, 'চালানোর জন্য', '', 'Active'),
(22, '2014-10-16', '0000-00-00 00:00:00', 1, 11, 'DM-BA-11-5725', 1, 2, 'চালানোর জন্য', '', 'Active'),
(23, '2014-10-16', '0000-00-00 00:00:00', 1, 12, 'DM-BA-11-5718', 1, 2, 'চালানোর জন্য', '', 'Active'),
(24, '2014-10-16', '0000-00-00 00:00:00', 1, 13, 'DM-BA-11-5740', 1, 2, 'চালানোর জন্য', '', 'Active'),
(25, '2014-10-16', '0000-00-00 00:00:00', 1, 14, 'DM-BA-11-5734', 1, 2, 'চালানোর জন্য', '', 'Active'),
(26, '2014-10-16', '0000-00-00 00:00:00', 1, 21, '', 1, 12, 'মেরামতের জন্য', '', 'Inactive'),
(26, '2014-10-16', '0000-00-00 00:00:00', 1, 20, '', 1, 12, 'মেরামতের জন্য', '', 'Inactive'),
(27, '2014-10-17', '0000-00-00 00:00:00', 1, 21, '', 12, 1, 'চালানোর জন্য', '', 'Inactive'),
(27, '2014-10-17', '0000-00-00 00:00:00', 1, 20, '', 12, 1, 'চালানোর জন্য', '', 'Inactive'),
(28, '2014-10-07', '0000-00-00 00:00:00', 1, 16, '', 1, 2, 'চালানোর জন্য', '', 'Inactive'),
(28, '2014-10-07', '0000-00-00 00:00:00', 1, 15, '', 1, 2, 'চালানোর জন্য', '', 'Inactive'),
(29, '2014-10-26', '0000-00-00 00:00:00', 1, 16, '', 2, 1, 'বিক্রয়ের জন্য', '', 'Inactive'),
(29, '2014-10-26', '0000-00-00 00:00:00', 1, 15, '', 2, 1, 'বিক্রয়ের জন্য', '', 'Inactive'),
(30, '2014-10-26', '0000-00-00 00:00:00', 1, 16, '', 1, 2, 'চালানোর জন্য', '', 'Active'),
(30, '2014-10-26', '0000-00-00 00:00:00', 1, 15, '', 1, 2, 'চালানোর জন্য', '', 'Active'),
(32, '2014-11-19', '0000-00-00 00:00:00', 1, 20, 'DM-BA-11-5717', 1, 2, 'চালানোর জন্য', '', 'Active'),
(33, '2014-11-19', '0000-00-00 00:00:00', 1, 21, 'DM-BA-11-5728', 1, 2, 'চালানোর জন্য', '', 'Active'),
(34, '2014-11-19', '0000-00-00 00:00:00', 1, 29, 'DM-BA-11-5721', 1, 2, 'চালানোর জন্য', '', 'Active'),
(35, '2014-11-19', '0000-00-00 00:00:00', 1, 31, 'DM-BA-11-5738', 1, 2, 'চালানোর জন্য', '', 'Active'),
(36, '2014-11-19', '0000-00-00 00:00:00', 1, 32, 'DM-BA-11-5732', 1, 2, 'চালানোর জন্য', '', 'Active'),
(37, '2014-11-19', '0000-00-00 00:00:00', 1, 33, 'DM-BA-11-5726', 1, 2, 'চালানোর জন্য', '', 'Active'),
(38, '2015-01-14', '2015-01-25 04:18:17', 1, 34, 'DM-BA-11-5797', 1, 6, 'চালানোর জন্য', '', 'Active'),
(39, '2015-01-14', '2015-01-25 04:18:17', 1, 35, 'DM-BA-11-5793', 1, 6, 'চালানোর জন্য', '', 'Active');

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

--
-- Table structure for table `delivery_to`
--

CREATE TABLE IF NOT EXISTS `delivery_to` (
  `delivery_to_id` int(11) NOT NULL,
  `delivery_to_type_id` int(30) NOT NULL,
  `delivery_to_name` varchar(50) NOT NULL,
  `location` varchar(100) NOT NULL,
  `del_contact_person` varchar(50) NOT NULL,
  `del_designation` varchar(30) NOT NULL,
  `del_phone` int(30) DEFAULT NULL,
  `del_email` varchar(20) DEFAULT NULL,
  `delivery_to_remarks` varchar(10000) DEFAULT NULL,
  PRIMARY KEY (`delivery_to_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `delivery_to`
--

INSERT INTO `delivery_to` (`delivery_to_id`, `delivery_to_type_id`, `delivery_to_name`, `location`, `del_contact_person`, `del_designation`, `del_phone`, `del_email`, `delivery_to_remarks`) VALUES
(1, 1, 'প্রধান কার্যালয়', 'মতিঝিল', 'চেয়্যারম্যান', 'চেয়ারম্যান', NULL, NULL, ''),
(2, 2, 'কল্যাণপুর বাস ডিপো', 'কল্যাণপুর', 'ডিপো ম্যানেজার', '', NULL, NULL, ''),
(3, 2, 'জোয়ারসাহারা বাস ডিপো', 'জোয়ারসাহারা', 'ডিপো ম্যানেজার', '', NULL, NULL, ''),
(4, 2, 'মতিঝিল বাস ডিপো', 'মতিঝিল', 'ডিপো ম্যানেজার', '', NULL, NULL, ''),
(5, 2, 'মিরপুর দ্বিতল বাস ডিপো', 'মিরপুর', 'ডিপো ম্যানেজার', 'ডিপো ম্যানেজার', NULL, NULL, ''),
(6, 2, 'মোহাম্মদপুর বাস ডিপো', 'মোহাম্মদপুর', 'ডিপো ম্যানেজার', 'ডিপো ম্যানেজার', NULL, NULL, ''),
(7, 2, 'নরসিংদী বাস ডিপো', 'নরসিংদী', 'ডিপো ম্যানেজার', 'ডিপো ম্যানেজার', 1723654987, '', ''),
(8, 2, 'কুমিল্লা বাস ডিপো', 'কুমিল্লা', 'ডিপো ম্যানেজার', '', NULL, NULL, ''),
(9, 2, 'চট্টগ্রাম বাস ডিপো', 'চট্টগ্রাম', 'ম্যানেজার', 'ম্যানেজার', NULL, NULL, ''),
(10, 2, 'বগুড়া বাস ডিপো', 'বগুড়া', 'ম্যানেজার', 'ম্যানেজার', 0, 'del_email', ''),
(11, 2, 'বরিশাল বাস ডিপো', 'বরিশাল', 'ম্যানেজার', 'ম্যানেজার', 0, 'del_email', ''),
(12, 2, 'পাবনা বাস ডিপো', 'পাবনা', 'ম্যানেজার', 'ম্যানেজার', 0, 'del_email', ''),
(13, 2, 'রংপুর বাস ডিপো', 'রংপুর', 'ম্যানেজার', 'ম্যানেজার', 0, 'del_email', ''),
(14, 2, 'খুলনা বাস ডিপো', 'খুলনা', 'ম্যানেজার', 'ম্যানেজার', 0, 'del_email', ''),
(15, 2, 'সিলেট বাস ডিপো', 'সিলেট', 'ম্যানেজার', 'ম্যানেজার', 0, 'del_email', ''),
(16, 2, 'নারায়ণগঞ্জ বাস ডিপো', 'নারায়ণগঞ্জ', 'ম্যানেজার', 'ম্যানেজার', 0, 'del_email', ''),
(17, 2, 'উথলী বাস ডিপো', 'উথলী', 'ম্যানেজার', 'ম্যানেজার', 0, 'del_email', ''),
(18, 2, 'সোনাপুর বাস ডিপো', 'সোনাপুর', 'ম্যানেজার', 'ম্যানেজার', 0, 'del_email', ''),
(19, 2, 'গাজীপুর বাস ডিপো', 'গাজীপুর', 'ম্যানেজার', 'ম্যানেজার', 0, 'del_email', ''),
(20, 4, 'কেন্দ্রীয় মেরামত কারখানা, জয়দেবপুর', 'জয়দেবপুর', 'ম্যানেজার', 'ম্যানেজার', 0, 'del_email', ''),
(21, 4, 'কেন্দ্রীয় মেরামত কারখানা, তেজগাঁও', 'তেজগাঁও', 'ম্যানেজার', 'ম্যানেজার', 0, 'del_email', ''),
(22, 3, 'কেন্দ্রীয় প্রশিক্ষণ কেন্দ্র, গাজীপুর', 'গাজীপুর', '', '', NULL, NULL, NULL);

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

--
-- Table structure for table `delivery_to_type`
--

CREATE TABLE IF NOT EXISTS `delivery_to_type` (
  `delivery_to_type_id` int(11) NOT NULL,
  `delivery_to_type_name` varchar(50) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `delivery_to_type`
--

INSERT INTO `delivery_to_type` (`delivery_to_type_id`, `delivery_to_type_name`) VALUES
(2, 'ডিপো'),
(3, 'প্রশিক্ষণ কেন্দ্র'),
(4, 'ওয়ার্কশপ'),
(1, 'কার্যালয়'),
(5, 'ইজারা গ্রহীতা');

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

--
-- Table structure for table `depot_exp`
--

CREATE TABLE IF NOT EXISTS `depot_exp` (
  `exp_id` int(11) NOT NULL DEFAULT '0',
  `exp_date` date NOT NULL,
  `input_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `product_id` int(11) NOT NULL,
  `fuel` decimal(10,2) NOT NULL,
  `mobil` decimal(10,2) NOT NULL,
  `gear_oil` decimal(10,2) NOT NULL,
  `differ_oil` decimal(10,2) NOT NULL,
  `break_oil` decimal(10,2) NOT NULL,
  `steering_oil` decimal(10,2) NOT NULL,
  `power_oil` decimal(10,2) NOT NULL,
  `grease` decimal(10,2) NOT NULL,
  `fuel_filter` decimal(10,2) NOT NULL,
  `oil_filter` decimal(10,2) NOT NULL,
  `air_filter` decimal(10,2) NOT NULL,
  `air_separator` decimal(10,2) NOT NULL,
  `toll` decimal(10,2) NOT NULL,
  `operating_cost` decimal(10,2) NOT NULL,
  `exp_remarks` varchar(500) NOT NULL,
  PRIMARY KEY (`exp_id`),
  UNIQUE KEY `exp_id` (`exp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `depot_exp`
--

INSERT INTO `depot_exp` (`exp_id`, `exp_date`, `input_date`, `product_id`, `fuel`, `mobil`, `gear_oil`, `differ_oil`, `break_oil`, `steering_oil`, `power_oil`, `grease`, `fuel_filter`, `oil_filter`, `air_filter`, `air_separator`, `toll`, `operating_cost`, `exp_remarks`) VALUES
(1, '2014-09-10', '2014-09-10 07:21:34', 7, 4.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 4000.00, 0.00, ''),
(2, '2014-09-10', '2014-09-10 07:21:34', 11, 3.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 3000.00, 0.00, ''),
(3, '2014-09-10', '2014-09-10 07:21:34', 14, 5.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 4500.00, 0.00, ''),
(4, '2014-09-10', '2014-09-11 10:50:58', 16, 2.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 2000.00, 0.00, ''),
(5, '2014-09-12', '2014-09-12 17:23:34', 16, 435.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 345.00, 0.00, ''),
(6, '2014-09-12', '2014-09-12 17:23:34', 11, 536.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 435.00, 0.00, ''),
(7, '2014-09-12', '2014-09-12 17:23:34', 7, 23.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 545.00, 0.00, ''),
(8, '2014-09-15', '2014-09-14 06:49:55', 16, 234.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 423.00, 0.00, ''),
(9, '2014-09-15', '2014-09-14 06:49:55', 11, 234.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 326.00, 0.00, ''),
(10, '2014-09-16', '2014-09-14 07:36:03', 16, 123.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 123.00, 0.00, ''),
(11, '2014-09-16', '2014-09-14 07:36:03', 11, 123.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 123.00, 0.00, ''),
(12, '2014-09-16', '2014-09-14 07:36:03', 7, 123.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 122.00, 0.00, ''),
(13, '2014-09-14', '2014-09-14 07:39:11', 16, 67.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 566.00, 0.00, ''),
(14, '2014-09-14', '2014-09-14 07:39:11', 11, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(15, '2014-09-14', '2014-09-14 07:39:11', 7, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(16, '2014-09-17', '2014-09-14 07:40:06', 16, 54.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 350.00, 0.00, ''),
(17, '2014-09-17', '2014-09-14 07:40:06', 11, 345.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 445.00, 0.00, ''),
(18, '2014-09-17', '2014-09-14 07:40:06', 7, 546.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 750.00, 0.00, ''),
(19, '2014-09-18', '0000-00-00 00:00:00', 16, 345.00, 345.00, 345.00, 345.00, 345.00, 34.00, 534.00, 534.00, 0.00, 0.00, 0.00, 0.00, 534.00, 5.00, ''),
(20, '2014-09-18', '0000-00-00 00:00:00', 11, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(21, '2014-09-18', '0000-00-00 00:00:00', 7, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(22, '2014-09-21', '0000-00-00 00:00:00', 11, 576.00, 76.00, 876.00, 876.00, 876.00, 86.00, 876.00, 876.00, 0.00, 0.00, 0.00, 0.00, 876.00, 786.00, ''),
(23, '2014-09-21', '0000-00-00 00:00:00', 7, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(24, '2014-10-15', '0000-00-00 00:00:00', 16, 100.00, 200.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(25, '2014-10-15', '0000-00-00 00:00:00', 14, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(26, '2014-10-15', '0000-00-00 00:00:00', 11, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(27, '2014-10-15', '0000-00-00 00:00:00', 7, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(28, '2014-10-26', '0000-00-00 00:00:00', 16, 100.00, 5.00, 45.00, 45.00, 64.00, 6.00, 46.00, 6.00, 0.00, 0.00, 0.00, 0.00, 6.00, 323.00, ''),
(29, '2014-10-26', '0000-00-00 00:00:00', 15, 34.00, 5.00, 5.00, 34.00, 3.00, 43.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 124.00, ''),
(30, '2014-10-26', '0000-00-00 00:00:00', 14, 70.00, 30.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 100.00, ''),
(31, '2014-10-26', '0000-00-00 00:00:00', 13, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(32, '2014-10-26', '0000-00-00 00:00:00', 12, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(33, '2014-10-26', '0000-00-00 00:00:00', 11, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(34, '2014-10-26', '0000-00-00 00:00:00', 10, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(35, '2014-10-26', '0000-00-00 00:00:00', 9, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(36, '2014-10-26', '0000-00-00 00:00:00', 8, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(37, '2014-11-25', '2014-11-25 04:03:43', 16, 58.00, 45.00, 4.00, 50.00, 2.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 159.00, ''),
(38, '2014-11-25', '2014-11-25 04:03:43', 15, 72.00, 3.00, 3.00, 9.00, 7.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 94.00, ''),
(39, '2014-11-25', '2014-11-25 04:03:43', 14, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(40, '2014-11-25', '2014-11-25 04:03:43', 13, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(41, '2014-11-25', '2014-11-25 04:03:43', 12, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(42, '2014-11-25', '2014-11-25 04:03:43', 11, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(43, '2014-11-25', '2014-11-25 04:03:43', 10, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(44, '2014-11-25', '2014-11-25 04:03:43', 9, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, ''),
(45, '2014-11-25', '2014-11-25 04:03:43', 8, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, '');

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

--
-- Table structure for table `depot_income`
--

CREATE TABLE IF NOT EXISTS `depot_income` (
  `income_id` int(11) NOT NULL DEFAULT '0',
  `income_date` date NOT NULL,
  `input_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `product_id` int(11) NOT NULL,
  `trip_no` int(11) NOT NULL,
  `mileage` int(11) NOT NULL,
  `income` decimal(10,2) NOT NULL,
  `income_remarks` varchar(500) NOT NULL,
  PRIMARY KEY (`income_id`),
  UNIQUE KEY `income_id` (`income_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `depot_income`
--

INSERT INTO `depot_income` (`income_id`, `income_date`, `input_date`, `product_id`, `trip_no`, `mileage`, `income`, `income_remarks`) VALUES
(1, '2014-09-10', '2014-09-10 07:21:34', 7, 4, 40, 4000.00, ''),
(2, '2014-09-10', '2014-09-10 07:21:34', 11, 3, 30, 3000.00, ''),
(3, '2014-09-10', '2014-09-10 07:21:34', 14, 5, 25, 4500.00, ''),
(4, '2014-09-10', '2014-09-11 10:50:58', 16, 2, 20, 2000.00, ''),
(5, '2014-09-12', '2014-09-12 17:23:34', 16, 435, 345, 345.00, ''),
(6, '2014-09-12', '2014-09-12 17:23:34', 11, 536, 64, 435.00, ''),
(7, '2014-09-12', '2014-09-12 17:23:34', 7, 23, 345, 545.00, ''),
(8, '2014-09-15', '2014-09-14 06:49:55', 16, 234, 234, 423.00, ''),
(9, '2014-09-15', '2014-09-14 06:49:55', 11, 234, 234, 326.00, ''),
(13, '2014-09-14', '2014-09-14 07:39:11', 16, 67, 567, 566.00, ''),
(14, '2014-09-14', '2014-09-14 07:39:11', 11, 0, 0, 0.00, ''),
(15, '2014-09-14', '2014-09-14 07:39:11', 7, 0, 0, 0.00, ''),
(16, '2014-09-17', '2014-09-14 07:40:06', 16, 54, 35, 350.00, ''),
(17, '2014-09-17', '2014-09-14 07:40:06', 11, 345, 45, 445.00, ''),
(18, '2014-09-17', '2014-09-14 07:40:06', 7, 546, 4564, 750.00, ''),
(19, '2014-10-15', '2014-10-15 10:08:31', 11, 0, 0, 10.00, ''),
(20, '2014-10-15', '2014-10-15 10:08:31', 7, 0, 0, 0.00, ''),
(21, '2014-10-19', '2014-10-19 10:15:34', 16, 45, 5, 7777.00, ''),
(22, '2014-10-19', '2014-10-19 10:15:34', 15, 0, 0, 6000.00, ''),
(23, '2014-10-19', '2014-10-19 10:15:34', 14, 0, 0, 0.00, ''),
(24, '2014-10-19', '2014-10-19 10:15:34', 13, 0, 0, 0.00, ''),
(25, '2014-10-19', '2014-10-19 10:15:34', 12, 0, 0, 0.00, ''),
(26, '2014-10-19', '2014-10-19 10:15:34', 11, 0, 0, 0.00, ''),
(27, '2014-10-19', '2014-10-19 10:15:34', 10, 0, 0, 0.00, ''),
(28, '2014-10-19', '2014-10-19 10:15:34', 9, 0, 0, 0.00, ''),
(29, '2014-10-19', '2014-10-19 10:15:34', 8, 0, 0, 0.00, ''),
(30, '2014-10-26', '2014-10-26 15:42:31', 16, 10, 120, 3434.00, ''),
(31, '2014-10-26', '2014-10-26 15:42:31', 15, 9, 100, 3000.00, ''),
(32, '2014-10-26', '2014-10-26 15:42:31', 14, 700, 100, 100.00, ''),
(33, '2014-10-26', '2014-10-26 15:42:31', 13, 0, 0, 0.00, ''),
(34, '2014-10-26', '2014-10-26 15:42:31', 12, 0, 0, 0.00, ''),
(35, '2014-10-26', '2014-10-26 15:42:31', 11, 0, 0, 0.00, ''),
(36, '2014-10-26', '2014-10-26 15:42:31', 10, 0, 0, 0.00, ''),
(37, '2014-10-26', '2014-10-26 15:42:31', 9, 0, 0, 0.00, ''),
(38, '2014-10-26', '2014-10-26 15:42:31', 8, 0, 0, 0.00, ''),
(39, '2014-10-25', '2014-10-26 15:49:27', 16, 0, 0, 435.00, ''),
(40, '2014-10-25', '2014-10-26 15:49:27', 15, 0, 0, 0.00, ''),
(41, '2014-10-25', '2014-10-26 15:49:27', 14, 0, 0, 0.00, ''),
(42, '2014-10-25', '2014-10-26 15:49:27', 13, 0, 0, 0.00, ''),
(43, '2014-10-25', '2014-10-26 15:49:27', 12, 0, 0, 0.00, ''),
(44, '2014-10-25', '2014-10-26 15:49:27', 11, 0, 0, 0.00, ''),
(45, '2014-10-25', '2014-10-26 15:49:27', 10, 0, 0, 0.00, ''),
(46, '2014-10-25', '2014-10-26 15:49:27', 9, 0, 0, 0.00, ''),
(47, '2014-10-25', '2014-10-26 15:49:27', 8, 0, 0, 0.00, ''),
(48, '2014-11-03', '2014-11-03 04:10:19', 16, 0, 0, 654.00, 'ভাড়ায়'),
(49, '2014-11-03', '2014-11-03 04:10:19', 15, 0, 0, 0.00, ''),
(50, '2014-11-03', '2014-11-03 04:10:19', 14, 0, 0, 0.00, ''),
(51, '2014-11-03', '2014-11-03 04:10:19', 13, 0, 0, 0.00, ''),
(52, '2014-11-03', '2014-11-03 04:10:19', 12, 0, 0, 0.00, ''),
(53, '2014-11-03', '2014-11-03 04:10:19', 11, 0, 0, 0.00, ''),
(54, '2014-11-03', '2014-11-03 04:10:19', 10, 0, 0, 0.00, ''),
(55, '2014-11-03', '2014-11-03 04:10:19', 9, 0, 0, 0.00, ''),
(56, '2014-11-03', '2014-11-03 04:10:19', 8, 0, 0, 0.00, '');

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

--
-- Table structure for table `depot_name`
--

CREATE TABLE IF NOT EXISTS `depot_name` (
  `depot_id` int(11) NOT NULL,
  `depot_name` text NOT NULL,
  PRIMARY KEY (`depot_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `depot_name`
--

INSERT INTO `depot_name` (`depot_id`, `depot_name`) VALUES
(1, 'কল্যাণপুর বাস ডিপো'),
(2, 'মিরপুর দ্বিতল বাস ডিপো'),
(3, 'জোয়ারসাহারা বাস ডিপো'),
(4, 'মতিঝিল বাস ডিপো'),
(5, 'নারায়ণগঞ্জ বাস ডিপো'),
(6, 'নরসিংদী বাস ডিপো'),
(7, 'কুমিল্লা বাস ডিপো'),
(8, 'চট্টগ্রাম বাস ডিপো'),
(9, 'বগুড়া বাস ডিপো'),
(10, 'বরিশাল বাস ডিপো'),
(11, 'পাবনা বাস ডিপো'),
(12, 'রংপুর বাস ডিপো'),
(13, 'খুলনা বাস ডিপো'),
(14, 'সিলেট বাস ডিপো'),
(15, 'উথলী বাস ডিপো'),
(16, 'সোনাপুর বাস ডিপো'),
(17, 'গাজীপুর বাস ডিপো'),
(18, 'কেন্দ্রীয় মেরামত কারখানা, জয়দেবপুর'),
(19, 'কেন্দ্রীয় মেরামত কারখানা, তেজগাঁও');

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

--
-- Table structure for table `fund_source`
--

CREATE TABLE IF NOT EXISTS `fund_source` (
  `fund_id` int(5) NOT NULL,
  `fund_name` varchar(500) NOT NULL,
  `fund_amount` decimal(10,2) NOT NULL,
  `gob` decimal(10,2) NOT NULL,
  `interest_rate` decimal(10,2) NOT NULL,
  `instal_amount` decimal(10,2) NOT NULL,
  `instal_start_date` date DEFAULT NULL,
  `fund_remarks` varchar(10000) NOT NULL,
  PRIMARY KEY (`fund_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `fund_source`
--

INSERT INTO `fund_source` (`fund_id`, `fund_name`, `fund_amount`, `gob`, `interest_rate`, `instal_amount`, `instal_start_date`, `fund_remarks`) VALUES
(1, 'Indian Dollar Credit Line (IDCL)', 29395.00, 0.00, 1.00, 0.00, '2018-07-10', '-'),
(2, 'Economic Development Cooperation Fund (EDCF)', 20655.00, 0.00, 0.00, 0.00, '2021-07-15', '-'),
(3, 'Nordic Development Fund (NDF)', 9500.00, 0.00, 0.00, 0.00, '2020-07-10', '-');

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

--
-- Table structure for table `parts_cost`
--

CREATE TABLE IF NOT EXISTS `parts_cost` (
  `parts_cost_id` int(11) NOT NULL,
  `repair_id` int(11) NOT NULL,
  `repair_date` date NOT NULL,
  `product_id` int(11) NOT NULL,
  `part_id` int(11) NOT NULL,
  `parts_quantity` varchar(30) NOT NULL,
  `parts_cost` decimal(10,2) NOT NULL,
  UNIQUE KEY `parts_cost_id` (`parts_cost_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `parts_cost`
--

INSERT INTO `parts_cost` (`parts_cost_id`, `repair_id`, `repair_date`, `product_id`, `part_id`, `parts_quantity`, `parts_cost`) VALUES
(1, 23, '2014-10-16', 7, 1, '1', 435.00),
(2, 23, '2014-10-16', 7, 2, '1', 345.00),
(3, 24, '2014-10-19', 16, 1, '1', 78.00),
(4, 24, '2014-10-19', 16, 2, '1', 78.00),
(5, 25, '2014-10-26', 15, 1, '', 85.00),
(6, 25, '2014-10-26', 15, 6, '', 85.00),
(7, 26, '2014-10-26', 16, 3, '1', 23.00),
(8, 26, '2014-10-26', 16, 4, '2', 45.00),
(9, 27, '2014-10-29', 16, 3, '1', 45.00),
(10, 27, '2014-10-29', 16, 4, '2', 46.00),
(11, 28, '2014-11-25', 16, 4, '1', 45.00),
(12, 28, '2014-11-25', 16, 5, '2', 200.00),
(13, 29, '2014-11-24', 15, 1, '', 89.56),
(14, 30, '2014-11-25', 15, 3, '', 8525.00),
(15, 31, '2014-11-27', 33, 1, '', 700.00),
(16, 32, '2014-11-30', 21, 1, '', 200.00),
(17, 32, '2014-11-30', 21, 3, '', 400.00),
(20, 33, '2014-11-30', 29, 1, '', 100.00),
(21, 33, '2014-11-30', 29, 2, '', 200.00),
(23, 31, '2014-11-27', 33, 7, '', 100.00),
(25, 31, '2014-11-27', 33, 5, '', 500.00),
(27, 35, '2014-12-04', 31, 3, '', 300.00),
(29, 35, '2014-12-04', 31, 2, '', 600.00),
(30, 35, '2014-12-04', 31, 4, '', 400.00);

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

--
-- Table structure for table `parts_list`
--

CREATE TABLE IF NOT EXISTS `parts_list` (
  `parts_id` int(11) NOT NULL,
  `parts_name` varchar(100) NOT NULL,
  `parts_remarks` varchar(200) NOT NULL,
  PRIMARY KEY (`parts_id`),
  UNIQUE KEY `parts_id` (`parts_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `parts_list`
--

INSERT INTO `parts_list` (`parts_id`, `parts_name`, `parts_remarks`) VALUES
(1, 'ব্যাটারী', ''),
(2, 'টায়ার', ''),
(3, 'ইলেকট্রিক হর্ণ', ''),
(4, 'বল জয়েন্ট', ''),
(5, 'হ্যাঙ্গার বুশ', ''),
(6, 'ওয়াইপার ব্লেড', ''),
(7, 'স্পার্ক প্লাগ', '');

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

--
-- Table structure for table `present_condition`
--

CREATE TABLE IF NOT EXISTS `present_condition` (
  `condition_id` int(11) NOT NULL,
  `condition` varchar(50) NOT NULL,
  PRIMARY KEY (`condition_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `present_condition`
--

INSERT INTO `present_condition` (`condition_id`, `condition`) VALUES
(1, 'হেল্ড'),
(2, 'সচল (নিজস্ব পরিচালনায়)'),
(3, 'সচল (লীজের মাধ্যমে)'),
(4, 'হালকা মেরামতাধীন'),
(5, 'ভারী মেরামতাধীন'),
(6, 'দুর্ঘটনা কবলিত'),
(7, 'মেরামতের অযোগ্য'),
(8, 'বাতিল'),
(9, 'বিক্রীত');

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

--
-- Table structure for table `product_class`
--

CREATE TABLE IF NOT EXISTS `product_class` (
  `class_id` int(11) NOT NULL,
  `class_name` varchar(200) NOT NULL,
  `product_type_id` int(11) NOT NULL,
  `length` int(11) NOT NULL,
  `width` int(11) NOT NULL,
  `height` int(11) NOT NULL,
  `cc` int(11) NOT NULL,
  `power` int(11) NOT NULL,
  `eng_position` varchar(10) NOT NULL,
  `speed` int(11) NOT NULL,
  `seat_no` int(11) NOT NULL,
  `life` int(11) NOT NULL,
  `tyre_no` int(11) NOT NULL,
  `tyre_size` int(11) NOT NULL,
  `origin` varchar(20) NOT NULL,
  `date_manufacture` date NOT NULL,
  `life_start` date NOT NULL,
  `class_remarks` varchar(10000) NOT NULL,
  PRIMARY KEY (`class_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `product_class`
--

INSERT INTO `product_class` (`class_id`, `class_name`, `product_type_id`, `length`, `width`, `height`, `cc`, `power`, `eng_position`, `speed`, `seat_no`, `life`, `tyre_no`, `tyre_size`, `origin`, `date_manufacture`, `life_start`, `class_remarks`) VALUES
(2, 'Double Decker (Ashok Leyland,', 1, 9125, 2475, 4725, 0, 160, 'Front', 75, 76, 12, 7, 10, 'India', '2014-09-22', '2014-09-22', '-'),
(3, 'Single Decker AC (Ashok Leylan', 1, 11700, 2600, 4000, 0, 180, 'Front', 95, 41, 12, 7, 10, 'India', '2014-09-22', '2014-09-22', '-'),
(4, 'Articulated (Ashok Leyland, In', 1, 16000, 2600, 3400, 5759, 160, 'Front', 67, 59, 12, 9, 10, 'India', '2014-09-22', '2014-09-22', '-'),
(6, 'Chinese CNG Single Decker (Don', 1, 11000, 2480, 3270, 0, 160, 'Front', 105, 53, 10, 7, 10, 'China', '1970-01-01', '1970-01-01', '-'),
(7, 'Daewoo Express Bus-Single Deck', 1, 11000, 2490, 3225, 8071, 240, 'Front', 120, 46, 15, 7, 11, 'South Korea', '2011-01-01', '2011-10-31', '-'),
(8, 'Daewoo City Bus-Single Decker ', 1, 11000, 2490, 3225, 8071, 240, 'Front', 120, 53, 15, 7, 11, 'South Korea', '2011-01-01', '2011-10-31', '-');

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

--
-- Table structure for table `product_type`
--

CREATE TABLE IF NOT EXISTS `product_type` (
  `product_type_id` int(11) NOT NULL,
  `product_type` varchar(20) NOT NULL,
  PRIMARY KEY (`product_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `product_type`
--

INSERT INTO `product_type` (`product_type_id`, `product_type`) VALUES
(1, 'বাস'),
(2, 'ট্রাক'),
(3, 'প্রশিক্ষণ কার');

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

--
-- Table structure for table `purchase`
--

CREATE TABLE IF NOT EXISTS `purchase` (
  `purchase_id` int(11) NOT NULL,
  `contract_date` date NOT NULL,
  `purchase_date` date NOT NULL,
  `class_id` int(11) NOT NULL,
  `company_id` int(11) NOT NULL,
  `fund_id` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  `purchase_remarks` varchar(10000) NOT NULL,
  PRIMARY KEY (`purchase_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `purchase`
--

INSERT INTO `purchase` (`purchase_id`, `contract_date`, `purchase_date`, `class_id`, `company_id`, `fund_id`, `quantity`, `purchase_remarks`) VALUES
(1, '2011-05-19', '2012-10-31', 2, 1, 3, 290, '-'),
(2, '2012-06-12', '2013-07-19', 3, 1, 3, 88, '-'),
(3, '2012-05-31', '2013-04-17', 4, 1, 3, 50, '-'),
(4, '2011-01-04', '2011-08-25', 5, 2, 6, 255, '-'),
(5, '1970-01-01', '1970-01-01', 6, 3, 7, 275, '-');

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

--
-- Table structure for table `repair`
--

CREATE TABLE IF NOT EXISTS `repair` (
  `repair_id` int(11) NOT NULL,
  `repair_date` date NOT NULL,
  `input_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `product_id` int(11) NOT NULL,
  `repair_type` varchar(20) NOT NULL,
  `repair_place` varchar(100) NOT NULL,
  `repair_cause` varchar(100) NOT NULL,
  `parts_total` decimal(10,2) NOT NULL,
  `work_total` decimal(10,2) NOT NULL,
  `wages` decimal(10,2) NOT NULL,
  `overhead_charge` decimal(10,2) NOT NULL,
  `handling_charge` decimal(10,2) NOT NULL,
  `vat` decimal(10,2) NOT NULL,
  `repair_cost` decimal(10,2) NOT NULL,
  UNIQUE KEY `repair_id` (`repair_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `repair`
--

INSERT INTO `repair` (`repair_id`, `repair_date`, `input_date`, `product_id`, `repair_type`, `repair_place`, `repair_cause`, `parts_total`, `work_total`, `wages`, `overhead_charge`, `handling_charge`, `vat`, `repair_cost`) VALUES
(1, '2014-09-22', '0000-00-00 00:00:00', 11, '1', 'ওয়ার্কশপ', '', 123.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(2, '2014-09-22', '0000-00-00 00:00:00', 14, '1', 'sdfgf', '', 110.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(3, '2014-09-22', '0000-00-00 00:00:00', 0, '-1', '', '', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(4, '2014-09-16', '0000-00-00 00:00:00', 14, '1', 'কতদতক', '', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(5, '2014-09-26', '0000-00-00 00:00:00', 11, '1', 'পটডপট', '', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(6, '2014-09-24', '0000-00-00 00:00:00', 7, '1', 'ত্বকত্বক', '', 3666.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(8, '2014-09-28', '0000-00-00 00:00:00', 0, '-1', '', '', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(17, '2014-10-14', '0000-00-00 00:00:00', 7, '1', '', '', 5654.00, 0.00, 0.00, 0.00, 0.00, 0.00, 5654.00),
(22, '2014-10-14', '0000-00-00 00:00:00', 11, '-1', '', '', 0.00, 0.00, 0.00, 0.00, 0.00, 0.00, 0.00),
(23, '2014-10-16', '0000-00-00 00:00:00', 7, '1', 'fsgsdf', 'sdfsdf', 780.00, 52.00, 56.00, 565.00, 67.00, 57.00, 1577.00),
(24, '2014-10-19', '0000-00-00 00:00:00', 16, '1', '', '', 156.00, 0.00, 785.00, 0.00, 0.00, 0.00, 941.00),
(25, '2014-10-26', '0000-00-00 00:00:00', 15, '1', '', '', 170.00, 0.00, 86.00, 0.00, 0.00, 0.00, 256.00),
(26, '2014-10-26', '0000-00-00 00:00:00', 16, '1', '', '', 68.00, 45.00, 45.00, 54.00, 354.00, 0.00, 566.00),
(27, '2014-10-29', '0000-00-00 00:00:00', 16, '-1', '', '', 82.00, 0.00, 0.00, 0.00, 0.00, 0.00, 82.00),
(28, '2014-11-25', '0000-00-00 00:00:00', 16, 'হালকা', '', '', 245.00, 85.00, 520.00, 0.00, 0.00, 0.00, 850.00),
(29, '2014-11-24', '0000-00-00 00:00:00', 15, '1', '', '', 89.56, 0.00, 0.00, 0.00, 0.00, 0.00, 89.56),
(30, '2014-11-25', '0000-00-00 00:00:00', 15, 'ভারী', '', '', 8525.00, 0.00, 0.00, 0.00, 0.00, 0.00, 8525.00),
(31, '2014-11-27', '0000-00-00 00:00:00', 33, 'হালকা', 'ডিপো', 'দুর্ঘটনা', 1300.00, 0.00, 800.00, 600.00, 0.00, 0.00, 2700.00),
(32, '2014-11-30', '0000-00-00 00:00:00', 21, 'হালকা', '', '', 600.00, 0.00, 800.00, 0.00, 0.00, 0.00, 1400.00),
(33, '2014-11-30', '0000-00-00 00:00:00', 29, 'হালকা', '', '', 300.00, 0.00, 0.00, 0.00, 0.00, 0.00, 300.00),
(34, '2014-12-01', '0000-00-00 00:00:00', 20, 'হালকা', '', '', 0.00, 700.00, 0.00, 0.00, 0.00, 0.00, 700.00),
(35, '2014-12-04', '0000-00-00 00:00:00', 31, 'হালকা', '', '', 1300.00, 800.00, 700.00, 800.00, 600.00, 0.00, 4200.00);

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

--
-- Table structure for table `route`
--

CREATE TABLE IF NOT EXISTS `route` (
  `route_id` int(11) NOT NULL,
  `route_name` varchar(500) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `route`
--

INSERT INTO `route` (`route_id`, `route_name`) VALUES
(1, 'মিরপুর-মতিঝিল'),
(2, 'আব্দুল্লাহপুর-মতিঝিল'),
(3, 'গাবতলী-মতিঝিল'),
(4, 'গাবতলী-টঙ্গী');

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

--
-- Table structure for table `route_details`
--

CREATE TABLE IF NOT EXISTS `route_details` (
  `route_details_id` int(11) NOT NULL,
  `route_id` tinyint(10) NOT NULL,
  `product_type_id` tinyint(2) NOT NULL,
  `product_id` int(11) NOT NULL,
  `start_point_id` tinyint(10) NOT NULL,
  `end_point_id` tinyint(10) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `start_end`
--

CREATE TABLE IF NOT EXISTS `start_end` (
  `start_end_id` int(11) NOT NULL,
  `start_end_point` varchar(20) NOT NULL,
  UNIQUE KEY `id` (`start_end_id`),
  UNIQUE KEY `id_2` (`start_end_id`),
  UNIQUE KEY `id_3` (`start_end_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `start_end`
--

INSERT INTO `start_end` (`start_end_id`, `start_end_point`) VALUES
(1, 'মিরপুর'),
(2, 'মতিঝিল');

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

--
-- Table structure for table `status_history`
--

CREATE TABLE IF NOT EXISTS `status_history` (
  `change_id` tinyint(10) NOT NULL AUTO_INCREMENT,
  `product_type_id` tinyint(10) NOT NULL,
  `product_id` tinyint(10) NOT NULL,
  `delivery_to_id` tinyint(10) NOT NULL,
  `condition_id` tinyint(10) NOT NULL,
  `route_id` int(11) DEFAULT NULL,
  `driver_name` varchar(50) NOT NULL,
  `change_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `change_remarks` varchar(100) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT 'active',
  PRIMARY KEY (`change_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `status_history`
--

INSERT INTO `status_history` (`change_id`, `product_type_id`, `product_id`, `delivery_to_id`, `condition_id`, `route_id`, `driver_name`, `change_date`, `change_remarks`, `status`) VALUES
(1, 1, 28, 1, 1, NULL, '', '2014-09-23 06:43:43', '', 'Active'),
(2, 1, 14, 2, 0, 1, '', '2014-10-16 09:01:49', '', 'Active'),
(3, 1, 13, 2, 0, 1, '', '2014-10-16 09:01:56', '', 'Active'),
(4, 1, 13, 2, 0, 3, '', '2014-10-16 09:02:01', '', 'Active'),
(5, 1, 12, 2, 0, 1, '', '2014-10-16 09:02:07', '', 'Active'),
(6, 1, 11, 2, 0, 2, '', '2014-10-16 09:02:12', '', 'Active'),
(7, 1, 10, 2, 0, 3, '', '2014-10-16 09:02:17', '', 'Active'),
(8, 1, 9, 2, 0, 2, '', '2014-10-16 09:02:24', '', 'Active'),
(9, 1, 8, 2, 0, 4, '', '2014-10-16 09:02:29', '', 'Active'),
(10, 1, 15, 2, 0, 3, '', '2014-10-19 10:29:48', '', 'Active'),
(11, 1, 16, 2, 0, 1, '', '2014-10-19 10:29:54', '', 'Active'),
(12, 1, 32, 2, 0, 0, 'সেলিম', '2014-12-17 09:55:05', '', 'Active');

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

--
-- Table structure for table `tcar_info`
--

CREATE TABLE IF NOT EXISTS `tcar_info` (
  `tcar_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `product_type_id` int(11) NOT NULL DEFAULT '1',
  `no_of_seat` int(11) NOT NULL,
  `tcar_life` tinyint(5) NOT NULL,
  `tcar_description` varchar(500) NOT NULL,
  `engine_no` varchar(30) NOT NULL,
  `chesis_no` varchar(30) NOT NULL,
  `reg_no` varchar(30) NOT NULL,
  `reg_date` date NOT NULL,
  `delivery_status` varchar(10) NOT NULL,
  `delivery_to_id` int(11) NOT NULL DEFAULT '1',
  `condition_id` int(11) NOT NULL DEFAULT '1',
  `tcar_remarks` varchar(10000) NOT NULL,
  `tcar_status` varchar(10) NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`tcar_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `trip`
--

CREATE TABLE IF NOT EXISTS `trip` (
  `trip_id` int(11) NOT NULL,
  `product_type_id` int(11) NOT NULL,
  `product_id` int(11) NOT NULL,
  `trip_date` date NOT NULL,
  `start_time` time NOT NULL,
  `reach_time` time NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `truck_info`
--

CREATE TABLE IF NOT EXISTS `truck_info` (
  `truck_id` int(11) NOT NULL,
  `class_id` int(11) NOT NULL,
  `product_type_id` int(11) NOT NULL,
  `capacity` int(11) NOT NULL,
  `truck_life` tinyint(5) NOT NULL,
  `truck_description` varchar(500) NOT NULL,
  `engine_no` varchar(30) NOT NULL,
  `chesis_no` varchar(30) NOT NULL,
  `reg_no` varchar(30) NOT NULL,
  `reg_date` date NOT NULL,
  `delivery_status` varchar(10) NOT NULL,
  `delivery_to_id` int(11) NOT NULL DEFAULT '1',
  `condition_id` int(11) NOT NULL DEFAULT '1',
  `truck_remarks` varchar(10000) NOT NULL,
  `truck_status` varchar(10) NOT NULL DEFAULT 'Active',
  PRIMARY KEY (`truck_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

--
-- Table structure for table `user_type`
--

CREATE TABLE IF NOT EXISTS `user_type` (
  `user_type_id` int(10) NOT NULL,
  `user_type` varchar(30) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `user_type`
--

INSERT INTO `user_type` (`user_type_id`, `user_type`) VALUES
(1, 'সুপার এডমিন'),
(2, 'এডমিন'),
(3, 'প্রধান কার্যালয় এডমিন'),
(4, 'ডিপো এডমিন'),
(5, 'প্রশিক্ষণ ইনস্টিটিউট এডমিন'),
(6, 'ওয়ার্কশপ এডমিন');

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

--
-- Table structure for table `work_cost`
--

CREATE TABLE IF NOT EXISTS `work_cost` (
  `work_cost_id` int(11) NOT NULL,
  `repair_id` int(11) NOT NULL,
  `repair_date` date NOT NULL,
  `product_id` int(11) NOT NULL,
  `works_id` int(11) NOT NULL,
  `work_cost` decimal(10,2) NOT NULL,
  UNIQUE KEY `work_cost_id` (`work_cost_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `work_cost`
--

INSERT INTO `work_cost` (`work_cost_id`, `repair_id`, `repair_date`, `product_id`, `works_id`, `work_cost`) VALUES
(1, 0, '2014-10-14', 7, 2, 30.00),
(2, 0, '2014-10-14', 7, 1, 40.00),
(3, 0, '2014-10-14', 11, 1, 2.00),
(4, 0, '2014-10-14', 14, 1, 30.00),
(5, 0, '2014-10-14', 14, 2, 40.00),
(6, 0, '2014-10-14', 16, 2, 10.00),
(7, 0, '2014-10-14', 0, 1, 4575.00),
(8, 23, '2014-10-16', 7, 1, 52.00),
(9, 26, '2014-10-26', 16, 1, 45.00),
(10, 28, '2014-11-25', 16, 1, 85.00),
(11, 34, '2014-12-01', 20, 1, 400.00),
(12, 34, '2014-12-01', 20, 2, 300.00),
(14, 35, '2014-12-04', 31, 2, 300.00),
(15, 35, '2014-12-04', 31, 1, 500.00);

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

--
-- Table structure for table `work_list`
--

CREATE TABLE IF NOT EXISTS `work_list` (
  `work_id` int(11) NOT NULL,
  `work_name` varchar(100) NOT NULL,
  `work_desc` varchar(500) NOT NULL,
  `work_remarks` varchar(200) NOT NULL,
  PRIMARY KEY (`work_id`),
  UNIQUE KEY `parts_id` (`work_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

--
-- Dumping data for table `work_list`
--

INSERT INTO `work_list` (`work_id`, `work_name`, `work_desc`, `work_remarks`) VALUES
(1, 'ইলেকট্রিক লাইন চেকিং ও মেরামত', '', ''),
(2, 'সাইড ও বাম্পার ডেন্টিং ও পেইন্টিং', '', ''),
(3, 'দরজা মেরামত', 'ুািকতুকি;দবতদআব দ;তা্;ব আব তবত দবতদআব;দআবত ;দাবত;দ আআব ;দআবত;দ আতব ;দআবত দ;বত;দআ বত;দআবত তবআবদবআবদ আব আব', '');

