-- phpMyAdmin SQL Dump
-- version 4.0.4
-- http://www.phpmyadmin.net
--
-- Client: localhost
-- Généré le: Sam 12 Avril 2014 à 18:02
-- Version du serveur: 5.6.12-log
-- Version de PHP: 5.4.12

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

--
-- Base de données: `controletechnique`
--
CREATE DATABASE IF NOT EXISTS `controletechnique` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `controletechnique`;

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

--
-- Structure de la table `conducteur`
--

CREATE TABLE IF NOT EXISTS `conducteur` (
  `conduc_id` int(11) NOT NULL AUTO_INCREMENT,
  `conduc_nom` varchar(255) NOT NULL,
  `conduc_prenom` varchar(255) NOT NULL,
  `conduc_nagrement` varchar(50) NOT NULL,
  `conduc_pseudo` varchar(255) NOT NULL,
  PRIMARY KEY (`conduc_id`),
  UNIQUE KEY `conduc_id` (`conduc_id`),
  KEY `conduc_id_2` (`conduc_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Contenu de la table `conducteur`
--

INSERT INTO `conducteur` (`conduc_id`, `conduc_nom`, `conduc_prenom`, `conduc_nagrement`, `conduc_pseudo`) VALUES
(4, 'Debienne', 'Aymeric', 'fr15478985', 'aydebienne');

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

--
-- Structure de la table `controleur`
--

CREATE TABLE IF NOT EXISTS `controleur` (
  `control_id` int(11) NOT NULL AUTO_INCREMENT,
  `control_nom` varchar(255) NOT NULL,
  `control_prenom` varchar(255) NOT NULL,
  `control_nagrement` varchar(50) NOT NULL,
  `login` varchar(255) NOT NULL,
  `mdp` varchar(255) NOT NULL,
  PRIMARY KEY (`control_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;

--
-- Contenu de la table `controleur`
--

INSERT INTO `controleur` (`control_id`, `control_nom`, `control_prenom`, `control_nagrement`, `login`, `mdp`) VALUES
(1, 'Menez', 'Pascal', 'GF154785', 'mpascal', '123456');

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

--
-- Structure de la table `rdv`
--

CREATE TABLE IF NOT EXISTS `rdv` (
  `rdv_id` int(11) NOT NULL AUTO_INCREMENT,
  `rdv_naturecontrole` varchar(255) NOT NULL,
  `rdv_date` varchar(255) NOT NULL,
  `vehi_id` int(11) NOT NULL,
  PRIMARY KEY (`rdv_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=7 ;

--
-- Contenu de la table `rdv`
--

INSERT INTO `rdv` (`rdv_id`, `rdv_naturecontrole`, `rdv_date`, `vehi_id`) VALUES
(1, 'Revision', '09/01/2014', 2),
(2, 'Revision', '10/01/2014', 2),
(3, 'Test', '09/01/2014', 4),
(4, 'Revision', '15/01/2014', 1),
(5, 'Nouvel an', '01/01/2014', 4),
(6, 'Revision', '26/02/2014', 2);

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

--
-- Structure de la table `vehicules`
--

CREATE TABLE IF NOT EXISTS `vehicules` (
  `vehi_id` int(11) NOT NULL AUTO_INCREMENT,
  `vehi_immat` varchar(25) NOT NULL,
  `vehi_dateci` varchar(255) NOT NULL,
  `vehi_datepremierecirc` varchar(255) NOT NULL,
  `vehi_genre` varchar(50) NOT NULL,
  `vehi_marque` varchar(50) NOT NULL,
  `vehi_type` varchar(50) NOT NULL,
  `vehi_nserie` varchar(50) NOT NULL,
  `vehi_energie` varchar(50) NOT NULL,
  `vehi_kmcompt` int(11) NOT NULL,
  `vehi_desicom` varchar(50) NOT NULL,
  `vehi_conducid` int(11) NOT NULL,
  PRIMARY KEY (`vehi_id`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;

--
-- Contenu de la table `vehicules`
--

INSERT INTO `vehicules` (`vehi_id`, `vehi_immat`, `vehi_dateci`, `vehi_datepremierecirc`, `vehi_genre`, `vehi_marque`, `vehi_type`, `vehi_nserie`, `vehi_energie`, `vehi_kmcompt`, `vehi_desicom`, `vehi_conducid`) VALUES
(1, 'AS-699-FS', '2013-11-13', '2013-11-01', 'VL', 'Renault', 'Twingo', 'qss2458212d0542d', 'Essence', 120000, 'Twingo', 4),
(2, 'FD-584-JH', '10/05/2005', '11/05/2005', 'VL', 'Mercedes', 'VL', 'efefefe5f15412', 'Diesel', 95000, 'SLR 200', 4),
(4, 'HG-587-ML', '01/01/2000', '01/01/2000', 'VL', 'Renault', 'VL', 'efef1f1e54f5e4', 'Diesel', 105000, 'Scenic', 4);

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