-- phpMyAdmin SQL Dump
-- version 3.4.11.1deb2+deb7u2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 03, 2016 at 12:56 PM
-- Server version: 5.5.47
-- PHP Version: 5.4.45-0+deb7u2

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

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

--
-- Table structure for table `trajet`
--

CREATE TABLE IF NOT EXISTS `trajet` (
  `id_trajet` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(100) CHARACTER SET latin1 NOT NULL,
  `ville_depart` varchar(100) CHARACTER SET latin1 NOT NULL,
  `ville_arrive` varchar(100) CHARACTER SET latin1 NOT NULL,
  `date_depart` datetime NOT NULL,
  `lieu_rdv` varchar(100) NOT NULL,
  `depot_arrive` varchar(100) NOT NULL,
  `montant` int(11) NOT NULL,
  `nbre_places` int(11) NOT NULL,
  `type_voiture` varchar(50) CHARACTER SET latin1 NOT NULL,
  `modele_voiture` varchar(255) CHARACTER SET latin1 NOT NULL,
  `voyage` varchar(30) CHARACTER SET latin1 NOT NULL,
  `colis` varchar(30) CHARACTER SET latin1 NOT NULL,
  `animaux` varchar(30) CHARACTER SET latin1 NOT NULL,
  `commentaires` varchar(255) CHARACTER SET latin1 NOT NULL,
  PRIMARY KEY (`id_trajet`,`email`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;

--
-- Dumping data for table `trajet`
--

INSERT INTO `trajet` (`id_trajet`, `email`, `ville_depart`, `ville_arrive`, `date_depart`, `lieu_rdv`, `depot_arrive`, `montant`, `nbre_places`, `type_voiture`, `modele_voiture`, `voyage`, `colis`, `animaux`, `commentaires`) VALUES
(1, 'evenkhaled@edenamour.com', 'paris', 'marseille', '2016-04-23 08:00:00', 'la place', 'place école', 40, 3, 'Autres marque', '', '', '', '', ''),
(2, 'evenkhaled@edenamour.com', 'lyon', 'bordeaux', '2016-03-08 08:00:00', 'place', 'garre', 52, 3, 'Peugeot', '', '', '', '', ''),
(3, 'evenkhaled@edenamour.com', 'paris', 'Montpellier', '2016-04-19 08:00:00', 'la gard', 'l''école', 60, 3, 'Autres marque', '', '', '', '', ''),
(4, 'evenkhaled@edenamour.com', 'lille', 'perpignan', '2016-04-17 08:00:00', 'place', 'garre', 115, 3, 'Autres marque', '', '', '', '', ''),
(5, 'gigot@gmail.com', 'caen', 'nancy', '2016-04-14 08:00:00', 'lycée', 'école', 70, 1, 'Autres marque', '', '', '', '', ''),
(6, 'gigot@gmail.com', 'brest', 'nice', '2016-04-28 08:00:00', 'port', 'café', 33, 3, 'Autres marque', '', '', '', '', ''),
(7, 'gigot@gmail.com', 'lille', 'peau', '2016-03-08 08:00:00', 'lycée', 'le stade', 20, 3, 'Autres marque', '', '', '', '', ''),
(8, 'gigot@gmail.com', 'paris', 'bordeaux', '2016-04-11 10:00:00', 'musée', 'place', 22, 3, 'Autres marque', '', '', '', '', ''),
(9, 'gigot@gmail.com', 'pau', 'paris', '2016-04-23 15:00:00', 'place', 'pizza', 75, 3, 'Autres marque', '', '', '', '', ''),
(10, 'evenkhaled@edenamour.com', 'lyon', 'marseille', '2016-04-27 08:00:00', 'place', 'port', 55, 3, 'Autres marque', '', '', '', '', ''),
(11, 'faty@yahoo.com', 'montpellier', 'nice', '2016-04-01 08:00:00', 'gare', 'gare', 20, 3, 'Autres marque', '', 'Voyage', '', '', 'r"r&"r"r'),
(12, 'faty@yahoo.com', 'paris', 'bordeaux', '2016-04-20 10:00:00', 'gare', 'café', 30, 3, 'Ford', '', 'on', '', '', ',eqpg,ek^zkg,^zr');

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