-- phpMyAdmin SQL Dump
-- version 3.5.4
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Feb 21, 2013 at 07:16 PM

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: `busticket`
--

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

--
-- Table structure for table `admin`
--

CREATE TABLE IF NOT EXISTS `admin` (
  `un` varchar(20) NOT NULL,
  `pass` varchar(20) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `admin`
--

INSERT INTO `admin` (`un`, `pass`) VALUES
('admin', 'pass'),
('aravinda', 'technology');

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

--
-- Table structure for table `brno`
--

CREATE TABLE IF NOT EXISTS `brno` (
  `routeno` int(10) NOT NULL,
  `busid` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `brno`
--

INSERT INTO `brno` (`routeno`, `busid`) VALUES
(1, 1001);

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

--
-- Table structure for table `bus`
--

CREATE TABLE IF NOT EXISTS `bus` (
  `bustype` varchar(30) NOT NULL,
  `capacity` int(10) NOT NULL,
  `busid` int(10) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `bus`
--

INSERT INTO `bus` (`bustype`, `capacity`, `busid`) VALUES
('2+1 Seater', 34, 1001);

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

--
-- Table structure for table `busroute`
--

CREATE TABLE IF NOT EXISTS `busroute` (
  `busid` varchar(10) NOT NULL,
  `day` date NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `busroute`
--

INSERT INTO `busroute` (`busid`, `day`) VALUES
('1001', '2009-03-25');

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

--
-- Table structure for table `cancel`
--

CREATE TABLE IF NOT EXISTS `cancel` (
  `ticketno` varchar(10) NOT NULL,
  `time` datetime NOT NULL,
  `noofseats` int(5) NOT NULL,
  `refamt` double(10,2) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

--
-- Table structure for table `customer`
--

CREATE TABLE IF NOT EXISTS `customer` (
  `custid` int(10) NOT NULL auto_increment,
  `name` varchar(20) NOT NULL,
  `phno` bigint(10) NOT NULL,
  PRIMARY KEY  (`custid`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `customer`
--

INSERT INTO `customer` (`custid`, `name`, `phno`) VALUES
(1, 'Raj', 12345),
(2, 'Kiran', 56789);

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

--
-- Table structure for table `refund`
--

CREATE TABLE IF NOT EXISTS `refund` (
  `refid` varchar(10) NOT NULL,
  `lrange` bigint(10) NOT NULL,
  `urange` bigint(10) NOT NULL,
  `percenteage` bigint(10) NOT NULL,
  PRIMARY KEY  (`refid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

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

CREATE TABLE IF NOT EXISTS `route` (
  `routeno` int(10) NOT NULL auto_increment,
  `source` varchar(20) NOT NULL,
  `dest` varchar(20) NOT NULL,
  `tim` varchar(20) NOT NULL,
  `fare` double(10,2) NOT NULL,
  `type` varchar(25) NOT NULL,
  `date` date NOT NULL,
  ` busid` int(10) NOT NULL,
  PRIMARY KEY  (`routeno`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=4 ;

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

INSERT INTO `route` (`routeno`, `source`, `dest`, `tim`, `fare`, `type`, `date`, ` busid`) VALUES
(1, 'Mangalore', 'Hubli', '9:00 PM', 380.00, '2+1 Seater', '2009-03-25', 1001),
(2, 'Mangalore', 'Belgaum', '9:00 PM', 340.00, '2+1 Seater', '2009-03-25', 1001);

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

--
-- Table structure for table `seat`
--

CREATE TABLE IF NOT EXISTS `seat` (
  `ticketno` varchar(10) NOT NULL,
  `gender` varchar(5) NOT NULL,
  `seatno` varchar(5) NOT NULL,
  `busid` int(10) NOT NULL,
  `status` varchar(15) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `seat`
--

INSERT INTO `seat` (`ticketno`, `gender`, `seatno`, `busid`, `status`) VALUES
('1', 'Male', '1', 1001, 'Reserved'),
('2', 'Femal', '2', 1001, 'Booked');

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

--
-- Table structure for table `ticket`
--

CREATE TABLE IF NOT EXISTS `ticket` (
  `ticketno` int(10) NOT NULL auto_increment,
  `busid` varchar(10) NOT NULL,
  `custid` varchar(10) NOT NULL,
  `date` date NOT NULL,
  `amt` double(6,2) NOT NULL,
  `status` varchar(10) NOT NULL,
  `actdate` datetime NOT NULL,
  PRIMARY KEY  (`ticketno`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=3 ;

--
-- Dumping data for table `ticket`
--

INSERT INTO `ticket` (`ticketno`, `busid`, `custid`, `date`, `amt`, `status`, `actdate`) VALUES
(1, '1001', '1', '2009-03-25', 380.00, 'Reserved', '2009-03-21 12:13:03'),
(2, '1001', '2', '2009-03-25', 340.00, 'Booked', '2009-03-21 12:13:03');

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