-- phpMyAdmin SQL Dump
-- version 3.5.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Oct 01, 2014 at 09:41 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 `repair`
--

CREATE TABLE IF NOT EXISTS `repair` (
  `repair_id` int(11) NOT NULL,
  `repair_date` date NOT NULL,
  `bus_id` int(11) NOT NULL,
  `repair_type` varchar(20) NOT NULL,
  `repair_place` varchar(30) NOT NULL,
  `repair_cause` varchar(100) NOT NULL,
  `parts` int(11) NOT NULL,
  `battery` int(11) NOT NULL,
  `tyre` int(11) NOT NULL,
  `repair_cost` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

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

INSERT INTO `repair` (`repair_id`, `repair_date`, `bus_id`, `repair_type`, `repair_place`, `repair_cause`, `parts`, `battery`, `tyre`, `repair_cost`) VALUES
(0, '2014-09-22', 14, '1', 'ডিপো', '', 123, 0, 0, 0),
(0, '2014-09-22', 16, '2', '‌বকত্ব', '', 123, 0, 0, 0),
(1, '2014-09-22', 11, '1', 'ওয়ার্কশপ', '', 123, 0, 0, 0),
(2, '2014-09-22', 14, '1', 'sdfgf', '', 110, 0, 0, 0),
(3, '2014-09-22', 0, '-1', '', '', 0, 0, 0, 0),
(4, '2014-09-16', 14, '1', 'কতদতক', '', 0, 0, 0, 0),
(5, '2014-09-26', 11, '1', 'পটডপট', '', 0, 0, 0, 0),
(6, '2014-09-24', 7, '1', 'ত্বকত্বক', '', 3666, 0, 0, 0),
(7, '2014-09-23', 16, '1', 'টচকজটচ', '', 4747, 0, 0, 0),
(8, '2014-09-28', 0, '-1', '', '', 0, 0, 0, 0);

/*!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 */;
