-- phpMyAdmin SQL Dump
-- version 3.5.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Sep 21, 2014 at 07:48 AM
-- Server version: 5.5.25a
-- PHP Version: 5.4.4

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;

--
-- Database: `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(30) NOT NULL,
  `chesis_no` varchar(30) NOT NULL,
  `reg_no` varchar(30) 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',
  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`) VALUES
(1, 1, 1, 'op[o', '421412', '24242', '242', '2013-10-16', 0, 0, 'Yes', 6, 1, 0, '', '', '868', 'Active'),
(5, 3, 1, 'iop;', '45856', '45646', '4564', '2013-10-24', 0, 0, 'No', 1, 3, 0, '', '', '', 'Active'),
(6, 3, 1, 'iop;', '45856', '45646', '4564', '2013-10-24', 0, 0, 'Yes', 5, 1, 0, '', '', '', 'Active'),
(7, 3, 1, 'hjkhjk', '65435436', '54365434', '453453', '2013-10-24', 0, 0, 'Yes', 2, 2, 3, '', '', '', 'Active'),
(8, 1, 1, 'hjkhjk', '65435436', '54365434', '453453', '2013-10-24', 0, 0, 'Yes', 8, 1, 0, '', '', 'fdgdfgdf', 'Active'),
(11, 2, 1, 'hjkhjk gfgsd sdfsd sdfsd', '65435436', '54365434', '453453', '2013-10-24', 0, 0, 'Yes', 2, 2, 4, 'হেদায়েত', '', 'sdf sdf sdfsd f', 'Active'),
(12, 1, 1, 'fyjhfgjfg', '453245', '453', '453', '2013-10-31', 0, 0, 'Yes', 4, 3, 0, '', '', '', 'Active'),
(13, 1, 1, '', '7', '45645', '456', '2013-10-18', 0, 0, 'Yes', 4, 2, 0, '', '', 'j gf gufg yhdgh f rstewsr w wer ewrew rwer wear wer we rwer', 'Active'),
(14, 2, 1, '', '3', '4', '5', '2013-10-23', 0, 0, 'Yes', 2, 4, 2, '', '', 'ccc', 'Active'),
(15, 1, 1, '', '454646', '', '', '1970-01-01', 0, 0, 'Yes', 3, 4, 0, '', '', '', 'Active'),
(16, 1, 1, '', '123456', '567898', '1234', '1970-01-01', 0, 0, 'Yes', 2, 6, 1, 'রহিম', '', '', 'Active'),
(17, 2, 1, '', '435', '4564', '67', '2014-01-14', 0, 0, 'No', 1, 2, 0, '', '', '', 'Active'),
(18, 4, 1, '', '456454', '34', '3453', '0000-00-00', 0, 0, 'Yes', 7, 1, 0, '', '', '', 'Active'),
(19, 1, 1, 'dfgfd', '45645', '456456', '65756', '2014-09-03', 0, 0, 'No', 1, 1, 0, '', '', '', 'Active'),
(20, 3, 1, '', '325345', '34534', '3466', '2014-09-05', 0, 0, 'No', 1, 1, 0, '', '', '', 'Active'),
(21, 2, 1, '', '234', '2445', '234', '2014-09-03', 0, 0, 'No', 1, 1, 0, '', '', '', 'Active'),
(22, 2, 1, '', '456', '546', '456', '2014-09-10', 0, 0, 'No', 1, 4, 0, '', '', '', 'Active'),
(23, 2, 1, '', '456', '456', '456', '2014-09-18', 0, 0, 'No', 1, 2, 0, '', '', '', 'Active'),
(24, 1, 1, '', '345', '345', '345', '2014-10-16', 0, 0, 'No', 1, 2, 0, '', '', '', 'Active'),
(25, 3, 1, '', '1324', '345', '4567', '2014-09-18', 0, 0, 'Yes', 1, 1, 0, '', 'photo/bus_95e0fcfff0ae94d369659618dac41cd2.pdf', '', 'Active'),
(26, 1, 1, '', '345', '657', '567', '2014-09-18', 20, 30, 'No', 1, 2, 0, '', 'photo/bus_bf4dc7761cb5745f304b03dda097b0bf.jpg', '', 'Active'),
(27, 1, 1, 'dgsdf', '234', '234', '234', '2014-09-03', 60, 70, 'No', 1, 1, 0, '', '', '', 'Active');

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
