+-- phpMyAdmin SQL Dump
+-- version 4.5.4.1deb2ubuntu2
+-- http://www.phpmyadmin.net
+--
+-- Client : localhost
+-- Généré le : Dim 21 Janvier 2018 à 23:17
+-- Version du serveur : 5.7.20-0ubuntu0.16.04.1
+-- Version de PHP : 7.0.22-0ubuntu0.16.04.1
+
+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 utf8mb4 */;
+
+--
+-- Base de données : `bdVols`
+--
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `AVIONS`
+--
+
+DROP TABLE IF EXISTS `AVIONS`;
+CREATE TABLE `AVIONS` (
+ `NumAv` int(11) NOT NULL,
+ `NomAv` varchar(20) DEFAULT NULL,
+ `CapAv` int(11) DEFAULT NULL,
+ `VilleAv` varchar(15) DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Contenu de la table `AVIONS`
+--
+
+INSERT INTO `AVIONS` (`NumAv`, `NomAv`, `CapAv`, `VilleAv`) VALUES
+(101, 'Boeing 707', 350, 'Beyrouth'),
+(122, 'Falcon 900', 40, 'Avignon'),
+(140, 'Boeing 727', 150, 'Strasbourg'),
+(202, 'Falcon 900', 30, 'Nice'),
+(205, 'Boeing 747', 350, 'Metz'),
+(207, 'Boeing 737', 350, 'Nimes'),
+(210, 'Dc10', 200, 'Nantes'),
+(220, 'Concorde', 100, 'New York'),
+(225, 'Tupolev', 150, 'Pekin'),
+(240, 'Boeing 737', 300, 'Paris'),
+(250, 'Boeing 747', 500, 'Paris'),
+(256, 'Boeing 747', 220, 'Paris'),
+(269, 'Boeing 737', NULL, 'Paris'),
+(311, 'Dc10', 265, 'Ankara'),
+(315, 'Airbus A340', 350, 'Marseille'),
+(320, 'Falcon 900', NULL, 'Avignon'),
+(325, 'Antonov', 500, 'Marseille'),
+(401, 'Boeing 727', 150, 'Dijon'),
+(411, 'Tupolev', 130, 'Istanbul'),
+(415, 'Airbus A330', 350, 'Nice'),
+(440, 'Concorde', 100, 'Marseille'),
+(511, 'Airbus A320', 280, 'Toulouse'),
+(525, 'Airbus A320', 270, 'Paris'),
+(535, 'Airbus A330', 370, 'Marseille'),
+(560, 'Airbus A320', 250, 'Nice'),
+(614, 'Dc20', 255, 'Beyrouth'),
+(615, 'Caravelle', 80, 'Alger'),
+(620, 'Antonov', 580, 'Moscou'),
+(640, 'Boeing 727', 150, 'Nantes'),
+(660, 'Dc20', 295, 'Alger'),
+(715, 'Airbus A310', 150, 'Ajaccio'),
+(720, 'Boeing 727', 150, 'Marseille'),
+(722, 'Boeing 737', 350, 'Toulon'),
+(801, 'Concorde', NULL, 'Rome'),
+(811, 'Caravelle', 380, 'Naples'),
+(820, 'Boeing 737', 350, 'Ajaccio'),
+(840, 'Boeing 727', 150, 'Montpellier'),
+(915, 'Airbus A340', 350, 'Nice');
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `CLIENTS`
+--
+
+DROP TABLE IF EXISTS `CLIENTS`;
+CREATE TABLE `CLIENTS` (
+ `NumCl` int(11) NOT NULL,
+ `NomCl` varchar(25) DEFAULT NULL,
+ `PrenomCl` varchar(25) DEFAULT NULL,
+ `EmailCl` varchar(50) DEFAULT NULL,
+ `PasswordCl` varchar(255) DEFAULT NULL,
+ `NumRueCl` smallint(6) DEFAULT NULL,
+ `NomRueCl` varchar(50) DEFAULT NULL,
+ `CodePosteCl` int(11) DEFAULT NULL,
+ `VilleCl` varchar(15) DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Contenu de la table `CLIENTS`
+--
+
+INSERT INTO `CLIENTS` (`NumCl`, `NomCl`, `PrenomCl`, `EmailCl`, `PasswordCl`, `NumRueCl`, `NomRueCl`, `CodePosteCl`, `VilleCl`) VALUES
+(1001, 'Becquerel', 'Stéphanie', 'becky@gmail.com', '$2y$10$QY47TLe3nGBtuDqjLQfjD.8JNzha8oYPDhu3a31SRrbhRlULcdDdm', 24, 'Rue De Fabre', 13015, 'Marseille'),
+(1002, 'Curie', NULL, 'curie@gmail.com', '$2y$10$QY47TLe3nGBtuDqjLQfjD.8JNzha8oYPDhu3a31SRrbhRlULcdDdm', 1, 'Rue De Rome', 87031, 'Limoges'),
+(1036, 'Benoit', 'Jérôme', 'jerome.benoit@piment-noir.org', '$2y$10$zcWP.9OOCK7NaHt/NztWeugvTv7csLh80yj5sN7v84NPWJddpX4Vq', 50, 'Rue de la paix', 13012, 'Marseille'),
+(1037, 'Benoit', 'Jérôme', 'jerome.benoit@grenouille.com', '$2y$10$pYc3FsoXE2sKdgGObsn1IujRoamGX7l7pL5h.pSAmXYTOqRkWXJGO', 35, 'Rue de la paix Marcel Paul', 13001, 'Marseille');
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `DEFCLASSES`
+--
+
+DROP TABLE IF EXISTS `DEFCLASSES`;
+CREATE TABLE `DEFCLASSES` (
+ `NumVol` varchar(5) NOT NULL,
+ `Classe` varchar(12) NOT NULL,
+ `CoeffPlace` float NOT NULL,
+ `CoeffPrix` float DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Contenu de la table `DEFCLASSES`
+--
+
+INSERT INTO `DEFCLASSES` (`NumVol`, `Classe`, `CoeffPlace`, `CoeffPrix`) VALUES
+('V1000', 'Economique', 0.5, 1),
+('V1000', 'Touriste', 0.3, 1.4),
+('V1001', 'Economique', 0.5, 1),
+('V1001', 'Touriste', 0.3, 1.4),
+('V1002', 'Economique', 0.5, 1),
+('V1002', 'Touriste', 0.3, 1.4),
+('V101', 'Business', 0.2, 1.8),
+('V101', 'Economique', 0.5, 1),
+('V101', 'Touriste', 0.3, 1.4),
+('V102', 'Business', 0.2, 1.8),
+('V102', 'Economique', 0.5, 1),
+('V102', 'Touriste', 0.3, 1.4),
+('V103', 'Business', 0.2, 1.8),
+('V103', 'Economique', 0.5, 1),
+('V103', 'Touriste', 0.3, 1.4),
+('V104', 'Business', 0.2, 1.8),
+('V104', 'Economique', 0.5, 1),
+('V104', 'Touriste', 0.3, 1.4),
+('V105', 'Business', 0.2, 1.8),
+('V105', 'Economique', 0.5, 1),
+('V105', 'Touriste', 0.3, 1.4),
+('V106', 'Business', 0.2, 1.8),
+('V106', 'Economique', 0.5, 1),
+('V106', 'Touriste', 0.3, 1.4),
+('V107', 'Business', 0.2, 1.8),
+('V107', 'Economique', 0.5, 1),
+('V107', 'Touriste', 0.3, 1.4),
+('V108', 'Business', 0.2, 1.8),
+('V108', 'Economique', 0.5, 1),
+('V108', 'Touriste', 0.3, 1.4),
+('V109', 'Business', 0.2, 1.8),
+('V109', 'Economique', 0.5, 1),
+('V109', 'Touriste', 0.3, 1.4),
+('V110', 'Business', 0.2, 1.8),
+('V110', 'Economique', 0.5, 1),
+('V110', 'Touriste', 0.3, 1.4),
+('V111', 'Business', 0.2, 1.8),
+('V111', 'Economique', 0.5, 1),
+('V111', 'Touriste', 0.3, 1.4),
+('V112', 'Business', 0.2, 1.8),
+('V112', 'Economique', 0.5, 1),
+('V112', 'Touriste', 0.3, 1.4),
+('V113', 'Business', 0.2, 1.8),
+('V113', 'Economique', 0.5, 1),
+('V113', 'Touriste', 0.3, 1.4),
+('V114', 'Business', 0.2, 1.8),
+('V114', 'Economique', 0.5, 1),
+('V114', 'Touriste', 0.3, 1.4),
+('V115', 'Business', 0.2, 1.8),
+('V115', 'Economique', 0.5, 1),
+('V115', 'Touriste', 0.3, 1.4),
+('V116', 'Business', 0.2, 1.8),
+('V116', 'Economique', 0.5, 1),
+('V116', 'Touriste', 0.3, 1.4),
+('V117', 'Business', 0.2, 1.8),
+('V117', 'Economique', 0.5, 1),
+('V117', 'Touriste', 0.3, 1.4),
+('V118', 'Business', 0.2, 1.8),
+('V118', 'Economique', 0.5, 1),
+('V118', 'Touriste', 0.3, 1.4),
+('V119', 'Business', 0.2, 1.8),
+('V119', 'Economique', 0.5, 1),
+('V119', 'Touriste', 0.3, 1.4),
+('V120', 'Business', 0.2, 1.8),
+('V120', 'Economique', 0.5, 1),
+('V120', 'Touriste', 0.3, 1.4),
+('V131', 'Business', 0.2, 1.8),
+('V131', 'Economique', 0.5, 1),
+('V131', 'Touriste', 0.3, 1.4),
+('V141', 'Business', 0.3, 1.8),
+('V141', 'Economique', 0.4, 1),
+('V141', 'Touriste', 0.3, 1.4),
+('V142', 'Business', 0.3, 1.8),
+('V142', 'Economique', 0.4, 1),
+('V142', 'Touriste', 0.3, 1.4),
+('V143', 'Business', 0.3, 1.8),
+('V143', 'Economique', 0.4, 1),
+('V143', 'Touriste', 0.3, 1.4),
+('V144', 'Business', 0.3, 1.8),
+('V144', 'Economique', 0.4, 1),
+('V144', 'Touriste', 0.3, 1.4),
+('V145', 'Business', 0.3, 1.8),
+('V145', 'Economique', 0.4, 1),
+('V145', 'Touriste', 0.3, 1.4),
+('V146', 'Business', 0.3, 1.8),
+('V146', 'Economique', 0.4, 1),
+('V146', 'Touriste', 0.3, 1.4),
+('V147', 'Business', 0.3, 1.8),
+('V147', 'Economique', 0.4, 1),
+('V147', 'Touriste', 0.3, 1.4),
+('V148', 'Business', 0.3, 1.8),
+('V148', 'Economique', 0.4, 1),
+('V148', 'Touriste', 0.3, 1.4),
+('V149', 'Business', 0.3, 1.8),
+('V149', 'Economique', 0.4, 1),
+('V149', 'Touriste', 0.3, 1.4),
+('V150', 'Business', 0.3, 1.8),
+('V150', 'Economique', 0.4, 1),
+('V150', 'Touriste', 0.3, 1.4),
+('V151', 'Business', 0.3, 1.8),
+('V151', 'Economique', 0.4, 1),
+('V151', 'Touriste', 0.3, 1.4),
+('V152', 'Business', 0.3, 1.8),
+('V152', 'Economique', 0.4, 1),
+('V152', 'Touriste', 0.3, 1.4),
+('V153', 'Business', 0.3, 1.8),
+('V153', 'Economique', 0.4, 1),
+('V153', 'Touriste', 0.3, 1.4),
+('V154', 'Business', 0.3, 1.8),
+('V154', 'Economique', 0.4, 1),
+('V154', 'Touriste', 0.3, 1.4),
+('V155', 'Business', 0.3, 1.8),
+('V155', 'Economique', 0.4, 1),
+('V155', 'Touriste', 0.3, 1.4),
+('V156', 'Business', 0.3, 1.8),
+('V156', 'Economique', 0.4, 1),
+('V156', 'Touriste', 0.3, 1.4),
+('V157', 'Business', 0.3, 1.8),
+('V157', 'Economique', 0.4, 1),
+('V157', 'Touriste', 0.3, 1.4),
+('V180', 'Economique', 0.5, 1),
+('V180', 'Touriste', 0.5, 1.4),
+('V181', 'Economique', 0.5, 1),
+('V181', 'Touriste', 0.5, 1.4),
+('V182', 'Economique', 0.5, 1),
+('V182', 'Touriste', 0.5, 1.4),
+('V183', 'Economique', 0.5, 1),
+('V183', 'Touriste', 0.5, 1.4),
+('V184', 'Economique', 0.5, 1),
+('V184', 'Touriste', 0.5, 1.4),
+('V185', 'Economique', 0.5, 1),
+('V185', 'Touriste', 0.5, 1.4),
+('V186', 'Economique', 0.5, 1),
+('V186', 'Touriste', 0.5, 1.4),
+('V187', 'Economique', 0.5, 1),
+('V187', 'Touriste', 0.5, 1.4),
+('V188', 'Economique', 0.5, 1),
+('V188', 'Touriste', 0.5, 1.4),
+('V189', 'Economique', 0.5, 1),
+('V189', 'Touriste', 0.5, 1.4),
+('V190', 'Economique', 0.5, 1),
+('V190', 'Touriste', 0.5, 1.4),
+('V191', 'Economique', 0.5, 1),
+('V191', 'Touriste', 0.5, 1.4),
+('V192', 'Economique', 0.5, 1),
+('V192', 'Touriste', 0.5, 1.4),
+('V193', 'Economique', 0.5, 1),
+('V193', 'Touriste', 0.5, 1.4),
+('V194', 'Economique', 0.5, 1),
+('V194', 'Touriste', 0.5, 1.4),
+('V195', 'Economique', 0.5, 1),
+('V195', 'Touriste', 0.5, 1.4),
+('V196', 'Economique', 0.5, 1),
+('V196', 'Touriste', 0.5, 1.4),
+('V197', 'Economique', 0.5, 1),
+('V197', 'Touriste', 0.5, 1.4),
+('V198', 'Economique', 0.5, 1),
+('V198', 'Touriste', 0.5, 1.4),
+('V199', 'Economique', 0.5, 1),
+('V199', 'Touriste', 0.5, 1.4),
+('V200', 'Economique', 0.5, 1),
+('V200', 'Touriste', 0.5, 1.4),
+('V210', 'Business', 0.2, 1.8),
+('V210', 'Economique', 0.5, 1),
+('V210', 'Touriste', 0.3, 1.4),
+('V211', 'Business', 0.2, 1.8),
+('V211', 'Economique', 0.5, 1),
+('V211', 'Touriste', 0.3, 1.4),
+('V212', 'Business', 0.2, 1.8),
+('V212', 'Economique', 0.5, 1),
+('V212', 'Touriste', 0.3, 1.4),
+('V213', 'Business', 0.2, 1.8),
+('V213', 'Economique', 0.5, 1),
+('V213', 'Touriste', 0.3, 1.4),
+('V214', 'Business', 0.2, 1.8),
+('V214', 'Economique', 0.5, 1),
+('V214', 'Touriste', 0.3, 1.4),
+('V215', 'Business', 0.2, 1.8),
+('V215', 'Economique', 0.5, 1),
+('V215', 'Touriste', 0.3, 1.4),
+('V216', 'Business', 0.2, 1.8),
+('V216', 'Economique', 0.5, 1),
+('V216', 'Touriste', 0.3, 1.4),
+('V217', 'Business', 0.2, 1.8),
+('V217', 'Economique', 0.5, 1),
+('V217', 'Touriste', 0.3, 1.4),
+('V218', 'Business', 0.2, 1.8),
+('V218', 'Economique', 0.5, 1),
+('V218', 'Touriste', 0.3, 1.4),
+('V219', 'Business', 0.2, 1.8),
+('V219', 'Economique', 0.5, 1),
+('V219', 'Touriste', 0.3, 1.4),
+('V220', 'Business', 0.2, 1.8),
+('V220', 'Economique', 0.5, 1),
+('V220', 'Touriste', 0.3, 1.4),
+('V221', 'Business', 0.2, 1.8),
+('V221', 'Economique', 0.5, 1),
+('V221', 'Touriste', 0.3, 1.4),
+('V222', 'Business', 0.2, 1.8),
+('V222', 'Economique', 0.5, 1),
+('V222', 'Touriste', 0.3, 1.4),
+('V223', 'Business', 0.2, 1.8),
+('V223', 'Economique', 0.5, 1),
+('V223', 'Touriste', 0.3, 1.4),
+('V224', 'Business', 0.2, 1.8),
+('V224', 'Economique', 0.5, 1),
+('V224', 'Touriste', 0.3, 1.4),
+('V240', 'Business', 0.2, 1.8),
+('V240', 'Economique', 0.5, 1),
+('V240', 'Touriste', 0.3, 1.4),
+('V265', 'Business', 0.2, 1.8),
+('V265', 'Economique', 0.5, 1),
+('V265', 'Touriste', 0.3, 1.4),
+('V341', 'Business', 0.2, 1.8),
+('V341', 'Economique', 0.5, 1),
+('V341', 'Touriste', 0.3, 1.4),
+('V342', 'Business', 0.2, 1.8),
+('V342', 'Economique', 0.5, 1),
+('V342', 'Touriste', 0.3, 1.4),
+('V343', 'Business', 0.2, 1.8),
+('V343', 'Economique', 0.5, 1),
+('V343', 'Touriste', 0.3, 1.4),
+('V344', 'Business', 0.2, 1.8),
+('V344', 'Economique', 0.5, 1),
+('V344', 'Touriste', 0.3, 1.4),
+('V345', 'Business', 0.2, 1.8),
+('V345', 'Economique', 0.5, 1),
+('V345', 'Touriste', 0.3, 1.4),
+('V346', 'Business', 0.2, 1.8),
+('V346', 'Economique', 0.5, 1),
+('V346', 'Touriste', 0.3, 1.4),
+('V347', 'Business', 0.2, 1.8),
+('V347', 'Economique', 0.5, 1),
+('V347', 'Touriste', 0.3, 1.4),
+('V348', 'Business', 0.2, 1.8),
+('V348', 'Economique', 0.5, 1),
+('V348', 'Touriste', 0.3, 1.4),
+('V349', 'Business', 0.2, 1.8),
+('V349', 'Economique', 0.5, 1),
+('V349', 'Touriste', 0.3, 1.4),
+('V350', 'Business', 0.2, 1.8),
+('V350', 'Economique', 0.5, 1),
+('V350', 'Touriste', 0.3, 1.4),
+('V351', 'Business', 0.2, 1.8),
+('V351', 'Economique', 0.5, 1),
+('V351', 'Touriste', 0.3, 1.4),
+('V352', 'Business', 0.2, 1.8),
+('V352', 'Economique', 0.5, 1),
+('V352', 'Touriste', 0.3, 1.4),
+('V353', 'Business', 0.2, 1.8),
+('V353', 'Economique', 0.5, 1),
+('V353', 'Touriste', 0.3, 1.4),
+('V354', 'Business', 0.2, 1.8),
+('V354', 'Economique', 0.5, 1),
+('V354', 'Touriste', 0.3, 1.4),
+('V355', 'Business', 0.2, 1.8),
+('V355', 'Economique', 0.5, 1),
+('V355', 'Touriste', 0.3, 1.4),
+('V356', 'Business', 0.2, 1.8),
+('V356', 'Economique', 0.5, 1),
+('V356', 'Touriste', 0.3, 1.4),
+('V357', 'Business', 0.2, 1.8),
+('V357', 'Economique', 0.5, 1),
+('V357', 'Touriste', 0.3, 1.4),
+('V358', 'Business', 0.2, 1.8),
+('V358', 'Economique', 0.5, 1),
+('V358', 'Touriste', 0.3, 1.4),
+('V359', 'Business', 0.2, 1.8),
+('V359', 'Economique', 0.5, 1),
+('V359', 'Touriste', 0.3, 1.4),
+('V360', 'Business', 0.2, 1.8),
+('V360', 'Economique', 0.5, 1),
+('V360', 'Touriste', 0.3, 1.4),
+('V361', 'Business', 0.2, 1.8),
+('V361', 'Economique', 0.5, 1),
+('V361', 'Touriste', 0.3, 1.4),
+('V362', 'Business', 0.2, 1.8),
+('V362', 'Economique', 0.5, 1),
+('V362', 'Touriste', 0.3, 1.4),
+('V363', 'Business', 0.2, 1.8),
+('V363', 'Economique', 0.5, 1),
+('V363', 'Touriste', 0.3, 1.4),
+('V364', 'Business', 0.2, 1.8),
+('V364', 'Economique', 0.5, 1),
+('V364', 'Touriste', 0.3, 1.4),
+('V365', 'Business', 0.2, 1.8),
+('V365', 'Economique', 0.5, 1),
+('V365', 'Touriste', 0.3, 1.4),
+('V366', 'Business', 0.2, 1.8),
+('V366', 'Economique', 0.5, 1),
+('V366', 'Touriste', 0.3, 1.4),
+('V367', 'Business', 0.2, 1.8),
+('V367', 'Economique', 0.5, 1),
+('V367', 'Touriste', 0.3, 1.4),
+('V368', 'Business', 0.2, 1.8),
+('V368', 'Economique', 0.5, 1),
+('V368', 'Touriste', 0.3, 1.4),
+('V369', 'Business', 0.2, 1.8),
+('V369', 'Economique', 0.5, 1),
+('V369', 'Touriste', 0.3, 1.4),
+('V370', 'Business', 0.2, 1.8),
+('V370', 'Economique', 0.5, 1),
+('V370', 'Touriste', 0.3, 1.4),
+('V420', 'Business', 0.2, 1.8),
+('V420', 'Economique', 0.5, 1),
+('V420', 'Touriste', 0.3, 1.4),
+('V431', 'Business', 0.2, 1.8),
+('V431', 'Economique', 0.5, 1),
+('V431', 'Touriste', 0.3, 1.4),
+('V490', 'Business', 0.2, 1.8),
+('V490', 'Economique', 0.5, 1),
+('V490', 'Touriste', 0.3, 1.4),
+('V501', 'Business', 0.2, 1.8),
+('V501', 'Economique', 0.5, 1),
+('V501', 'Touriste', 0.3, 1.4),
+('V502', 'Business', 0.2, 1.8),
+('V502', 'Economique', 0.5, 1),
+('V502', 'Touriste', 0.3, 1.4),
+('V503', 'Business', 0.2, 1.8),
+('V503', 'Economique', 0.5, 1),
+('V503', 'Touriste', 0.3, 1.4),
+('V504', 'Business', 0.2, 1.8),
+('V504', 'Economique', 0.5, 1),
+('V504', 'Touriste', 0.3, 1.4),
+('V505', 'Business', 0.2, 1.8),
+('V505', 'Economique', 0.5, 1),
+('V505', 'Touriste', 0.3, 1.4),
+('V506', 'Business', 0.2, 1.8),
+('V506', 'Economique', 0.5, 1),
+('V506', 'Touriste', 0.3, 1.4),
+('V507', 'Business', 0.2, 1.8),
+('V507', 'Economique', 0.5, 1),
+('V507', 'Touriste', 0.3, 1.4),
+('V508', 'Business', 0.2, 1.8),
+('V508', 'Economique', 0.5, 1),
+('V508', 'Touriste', 0.3, 1.4),
+('V509', 'Business', 0.2, 1.8),
+('V509', 'Economique', 0.5, 1),
+('V509', 'Touriste', 0.3, 1.4),
+('V510', 'Business', 0.2, 1.8),
+('V510', 'Economique', 0.5, 1),
+('V510', 'Touriste', 0.3, 1.4),
+('V511', 'Business', 0.2, 1.8),
+('V511', 'Economique', 0.5, 1),
+('V511', 'Touriste', 0.3, 1.4),
+('V512', 'Business', 0.2, 1.8),
+('V512', 'Economique', 0.5, 1),
+('V512', 'Touriste', 0.3, 1.4),
+('V513', 'Business', 0.2, 1.8),
+('V513', 'Economique', 0.5, 1),
+('V513', 'Touriste', 0.3, 1.4),
+('V514', 'Business', 0.2, 1.8),
+('V514', 'Economique', 0.5, 1),
+('V514', 'Touriste', 0.3, 1.4),
+('V515', 'Business', 0.2, 1.8),
+('V515', 'Economique', 0.5, 1),
+('V515', 'Touriste', 0.3, 1.4),
+('V516', 'Business', 0.2, 1.8),
+('V516', 'Economique', 0.5, 1),
+('V516', 'Touriste', 0.3, 1.4),
+('V517', 'Business', 0.2, 1.8),
+('V517', 'Economique', 0.5, 1),
+('V517', 'Touriste', 0.3, 1.4),
+('V518', 'Business', 0.2, 1.8),
+('V518', 'Economique', 0.5, 1),
+('V518', 'Touriste', 0.3, 1.4),
+('V519', 'Business', 0.2, 1.8),
+('V519', 'Economique', 0.5, 1),
+('V519', 'Touriste', 0.3, 1.4),
+('V520', 'Business', 0.2, 1.8),
+('V520', 'Economique', 0.5, 1),
+('V520', 'Touriste', 0.3, 1.4),
+('V521', 'Business', 0.2, 1.8),
+('V521', 'Economique', 0.5, 1),
+('V521', 'Touriste', 0.3, 1.4),
+('V522', 'Business', 0.2, 1.8),
+('V522', 'Economique', 0.5, 1),
+('V522', 'Touriste', 0.3, 1.4),
+('V523', 'Business', 0.2, 1.8),
+('V523', 'Economique', 0.5, 1),
+('V523', 'Touriste', 0.3, 1.4),
+('V524', 'Business', 0.2, 1.8),
+('V524', 'Economique', 0.5, 1),
+('V524', 'Touriste', 0.3, 1.4),
+('V525', 'Business', 0.2, 1.8),
+('V525', 'Economique', 0.5, 1),
+('V525', 'Touriste', 0.3, 1.4),
+('V526', 'Business', 0.2, 1.8),
+('V526', 'Economique', 0.5, 1),
+('V526', 'Touriste', 0.3, 1.4),
+('V527', 'Business', 0.2, 1.8),
+('V527', 'Economique', 0.5, 1),
+('V527', 'Touriste', 0.3, 1.4),
+('V528', 'Business', 0.2, 1.8),
+('V528', 'Economique', 0.5, 1),
+('V528', 'Touriste', 0.3, 1.4),
+('V529', 'Business', 0.2, 1.8),
+('V529', 'Economique', 0.5, 1),
+('V529', 'Touriste', 0.3, 1.4),
+('V530', 'Business', 0.2, 1.8),
+('V530', 'Economique', 0.5, 1),
+('V530', 'Touriste', 0.3, 1.4),
+('V590', 'Business', 0.2, 1.8),
+('V590', 'Economique', 0.5, 1),
+('V590', 'Touriste', 0.3, 1.4),
+('V601', 'Business', 0.2, 1.8),
+('V601', 'Economique', 0.5, 1),
+('V601', 'Touriste', 0.3, 1.4),
+('V602', 'Business', 0.2, 1.8),
+('V602', 'Economique', 0.5, 1),
+('V602', 'Touriste', 0.3, 1.4),
+('V603', 'Business', 0.2, 1.8),
+('V603', 'Economique', 0.5, 1),
+('V603', 'Touriste', 0.3, 1.4),
+('V604', 'Business', 0.2, 1.8),
+('V604', 'Economique', 0.5, 1),
+('V604', 'Touriste', 0.3, 1.4),
+('V605', 'Business', 0.2, 1.8),
+('V605', 'Economique', 0.5, 1),
+('V605', 'Touriste', 0.3, 1.4),
+('V606', 'Business', 0.2, 1.8),
+('V606', 'Economique', 0.5, 1),
+('V606', 'Touriste', 0.3, 1.4),
+('V607', 'Business', 0.2, 1.8),
+('V607', 'Economique', 0.5, 1),
+('V607', 'Touriste', 0.3, 1.4),
+('V608', 'Business', 0.2, 1.8),
+('V608', 'Economique', 0.5, 1),
+('V608', 'Touriste', 0.3, 1.4),
+('V609', 'Business', 0.2, 1.8),
+('V609', 'Economique', 0.5, 1),
+('V609', 'Touriste', 0.3, 1.4),
+('V610', 'Business', 0.2, 1.8),
+('V610', 'Economique', 0.5, 1),
+('V610', 'Touriste', 0.3, 1.4),
+('V611', 'Business', 0.2, 1.8),
+('V611', 'Economique', 0.5, 1),
+('V611', 'Touriste', 0.3, 1.4),
+('V612', 'Business', 0.2, 1.8),
+('V612', 'Economique', 0.5, 1),
+('V612', 'Touriste', 0.3, 1.4),
+('V613', 'Business', 0.2, 1.8),
+('V613', 'Economique', 0.5, 1),
+('V613', 'Touriste', 0.3, 1.4),
+('V614', 'Business', 0.2, 1.8),
+('V614', 'Economique', 0.5, 1),
+('V614', 'Touriste', 0.3, 1.4),
+('V615', 'Business', 0.2, 1.8),
+('V615', 'Economique', 0.5, 1),
+('V615', 'Touriste', 0.3, 1.4),
+('V616', 'Business', 0.2, 1.8),
+('V616', 'Economique', 0.5, 1),
+('V616', 'Touriste', 0.3, 1.4),
+('V617', 'Business', 0.2, 1.8),
+('V617', 'Economique', 0.5, 1),
+('V617', 'Touriste', 0.3, 1.4),
+('V618', 'Business', 0.2, 1.8),
+('V618', 'Economique', 0.5, 1),
+('V618', 'Touriste', 0.3, 1.4),
+('V619', 'Business', 0.2, 1.8),
+('V619', 'Economique', 0.5, 1),
+('V619', 'Touriste', 0.3, 1.4),
+('V620', 'Business', 0.2, 1.8),
+('V620', 'Economique', 0.5, 1),
+('V620', 'Touriste', 0.3, 1.4),
+('V621', 'Business', 0.2, 1.8),
+('V621', 'Economique', 0.5, 1),
+('V621', 'Touriste', 0.3, 1.4),
+('V622', 'Business', 0.2, 1.8),
+('V622', 'Economique', 0.5, 1),
+('V622', 'Touriste', 0.3, 1.4),
+('V623', 'Business', 0.2, 1.8),
+('V623', 'Economique', 0.5, 1),
+('V623', 'Touriste', 0.3, 1.4),
+('V624', 'Business', 0.2, 1.8),
+('V624', 'Economique', 0.5, 1),
+('V624', 'Touriste', 0.3, 1.4),
+('V625', 'Business', 0.2, 1.8),
+('V625', 'Economique', 0.5, 1),
+('V625', 'Touriste', 0.3, 1.4),
+('V626', 'Business', 0.2, 1.8),
+('V626', 'Economique', 0.5, 1),
+('V626', 'Touriste', 0.3, 1.4),
+('V627', 'Business', 0.2, 1.8),
+('V627', 'Economique', 0.5, 1),
+('V627', 'Touriste', 0.3, 1.4),
+('V628', 'Business', 0.2, 1.8),
+('V628', 'Economique', 0.5, 1),
+('V628', 'Touriste', 0.3, 1.4),
+('V629', 'Business', 0.2, 1.8),
+('V629', 'Economique', 0.5, 1),
+('V629', 'Touriste', 0.3, 1.4),
+('V630', 'Business', 0.2, 1.8),
+('V630', 'Economique', 0.5, 1),
+('V630', 'Touriste', 0.3, 1.4),
+('V641', 'Business', 0.2, 1.8),
+('V641', 'Economique', 0.5, 1),
+('V641', 'Touriste', 0.3, 1.4),
+('V642', 'Business', 0.2, 1.8),
+('V642', 'Economique', 0.5, 1),
+('V642', 'Touriste', 0.3, 1.4),
+('V643', 'Business', 0.2, 1.8),
+('V643', 'Economique', 0.5, 1),
+('V643', 'Touriste', 0.3, 1.4),
+('V644', 'Business', 0.2, 1.8),
+('V644', 'Economique', 0.5, 1),
+('V644', 'Touriste', 0.3, 1.4),
+('V645', 'Business', 0.2, 1.8),
+('V645', 'Economique', 0.5, 1),
+('V645', 'Touriste', 0.3, 1.4),
+('V646', 'Business', 0.2, 1.8),
+('V646', 'Economique', 0.5, 1),
+('V646', 'Touriste', 0.3, 1.4),
+('V647', 'Business', 0.2, 1.8),
+('V647', 'Economique', 0.5, 1),
+('V647', 'Touriste', 0.3, 1.4),
+('V648', 'Business', 0.2, 1.8),
+('V648', 'Economique', 0.5, 1),
+('V648', 'Touriste', 0.3, 1.4),
+('V649', 'Business', 0.2, 1.8),
+('V649', 'Economique', 0.5, 1),
+('V649', 'Touriste', 0.3, 1.4),
+('V650', 'Business', 0.2, 1.8),
+('V650', 'Economique', 0.5, 1),
+('V650', 'Touriste', 0.3, 1.4),
+('V651', 'Business', 0.2, 1.8),
+('V651', 'Economique', 0.5, 1),
+('V651', 'Touriste', 0.3, 1.4),
+('V652', 'Business', 0.2, 1.8),
+('V652', 'Economique', 0.5, 1),
+('V652', 'Touriste', 0.3, 1.4),
+('V653', 'Business', 0.2, 1.8),
+('V653', 'Economique', 0.5, 1),
+('V653', 'Touriste', 0.3, 1.4),
+('V654', 'Business', 0.2, 1.8),
+('V654', 'Economique', 0.5, 1),
+('V654', 'Touriste', 0.3, 1.4),
+('V655', 'Business', 0.2, 1.8),
+('V655', 'Economique', 0.5, 1),
+('V655', 'Touriste', 0.3, 1.4),
+('V656', 'Business', 0.2, 1.8),
+('V656', 'Economique', 0.5, 1),
+('V656', 'Touriste', 0.3, 1.4),
+('V657', 'Business', 0.2, 1.8),
+('V657', 'Economique', 0.5, 1),
+('V657', 'Touriste', 0.3, 1.4),
+('V658', 'Business', 0.2, 1.8),
+('V658', 'Economique', 0.5, 1),
+('V658', 'Touriste', 0.3, 1.4),
+('V659', 'Business', 0.2, 1.8),
+('V659', 'Economique', 0.5, 1),
+('V659', 'Touriste', 0.3, 1.4),
+('V660', 'Business', 0.2, 1.8),
+('V660', 'Economique', 0.5, 1),
+('V660', 'Touriste', 0.3, 1.4),
+('V661', 'Business', 0.2, 1.8),
+('V661', 'Economique', 0.5, 1),
+('V661', 'Touriste', 0.3, 1.4),
+('V662', 'Business', 0.2, 1.8),
+('V662', 'Economique', 0.5, 1),
+('V662', 'Touriste', 0.3, 1.4),
+('V663', 'Business', 0.2, 1.8),
+('V663', 'Economique', 0.5, 1),
+('V663', 'Touriste', 0.3, 1.4),
+('V664', 'Business', 0.2, 1.8),
+('V664', 'Economique', 0.5, 1),
+('V664', 'Touriste', 0.3, 1.4),
+('V665', 'Business', 0.2, 1.8),
+('V665', 'Economique', 0.5, 1),
+('V665', 'Touriste', 0.3, 1.4),
+('V666', 'Business', 0.2, 1.8),
+('V666', 'Economique', 0.5, 1),
+('V666', 'Touriste', 0.3, 1.4),
+('V667', 'Business', 0.2, 1.8),
+('V667', 'Economique', 0.5, 1),
+('V667', 'Touriste', 0.3, 1.4),
+('V668', 'Business', 0.2, 1.8),
+('V668', 'Economique', 0.5, 1),
+('V668', 'Touriste', 0.3, 1.4),
+('V669', 'Business', 0.2, 1.8),
+('V669', 'Economique', 0.5, 1),
+('V669', 'Touriste', 0.3, 1.4),
+('V670', 'Business', 0.2, 1.8),
+('V670', 'Economique', 0.5, 1),
+('V670', 'Touriste', 0.3, 1.4),
+('V681', 'Business', 0.2, 1.8),
+('V681', 'Economique', 0.5, 1),
+('V681', 'Touriste', 0.3, 1.4),
+('V682', 'Business', 0.2, 1.8),
+('V682', 'Economique', 0.5, 1),
+('V682', 'Touriste', 0.3, 1.4),
+('V683', 'Business', 0.2, 1.8),
+('V683', 'Economique', 0.5, 1),
+('V683', 'Touriste', 0.3, 1.4),
+('V684', 'Business', 0.2, 1.8),
+('V684', 'Economique', 0.5, 1),
+('V684', 'Touriste', 0.3, 1.4),
+('V685', 'Business', 0.2, 1.8),
+('V685', 'Economique', 0.5, 1),
+('V685', 'Touriste', 0.3, 1.4),
+('V686', 'Business', 0.2, 1.8),
+('V686', 'Economique', 0.5, 1),
+('V686', 'Touriste', 0.3, 1.4),
+('V687', 'Business', 0.2, 1.8),
+('V687', 'Economique', 0.5, 1),
+('V687', 'Touriste', 0.3, 1.4),
+('V688', 'Business', 0.2, 1.8),
+('V688', 'Economique', 0.5, 1),
+('V688', 'Touriste', 0.3, 1.4),
+('V689', 'Business', 0.2, 1.8),
+('V689', 'Economique', 0.5, 1),
+('V689', 'Touriste', 0.3, 1.4),
+('V690', 'Business', 0.2, 1.8),
+('V690', 'Economique', 0.5, 1),
+('V690', 'Touriste', 0.3, 1.4),
+('V691', 'Business', 0.2, 1.8),
+('V691', 'Economique', 0.5, 1),
+('V691', 'Touriste', 0.3, 1.4),
+('V692', 'Business', 0.2, 1.8),
+('V692', 'Economique', 0.5, 1),
+('V692', 'Touriste', 0.3, 1.4),
+('V693', 'Business', 0.2, 1.8),
+('V693', 'Economique', 0.5, 1),
+('V693', 'Touriste', 0.3, 1.4),
+('V694', 'Business', 0.2, 1.8),
+('V694', 'Economique', 0.5, 1),
+('V694', 'Touriste', 0.3, 1.4),
+('V720', 'Business', 0.2, 1.8),
+('V720', 'Economique', 0.5, 1),
+('V720', 'Touriste', 0.3, 1.4),
+('V787', 'Business', 0.2, 1.8),
+('V787', 'Economique', 0.5, 1),
+('V787', 'Touriste', 0.3, 1.4),
+('V788', 'Business', 0.2, 1.8),
+('V788', 'Economique', 0.5, 1),
+('V788', 'Touriste', 0.3, 1.4),
+('V789', 'Business', 0.2, 1.8),
+('V789', 'Economique', 0.5, 1),
+('V789', 'Touriste', 0.3, 1.4),
+('V790', 'Business', 0.2, 1.8),
+('V790', 'Economique', 0.5, 1),
+('V790', 'Touriste', 0.3, 1.4),
+('V791', 'Business', 0.2, 1.8),
+('V791', 'Economique', 0.5, 1),
+('V791', 'Touriste', 0.3, 1.4),
+('V804', 'Business', 0.2, 1.8),
+('V804', 'Economique', 0.5, 1),
+('V804', 'Touriste', 0.3, 1.4),
+('V805', 'Business', 0.2, 1.8),
+('V805', 'Economique', 0.5, 1),
+('V805', 'Touriste', 0.3, 1.4),
+('V806', 'Business', 0.2, 1.8),
+('V806', 'Economique', 0.5, 1),
+('V806', 'Touriste', 0.3, 1.4),
+('V807', 'Business', 0.2, 1.8),
+('V807', 'Economique', 0.5, 1),
+('V807', 'Touriste', 0.3, 1.4),
+('V808', 'Business', 0.2, 1.8),
+('V808', 'Economique', 0.5, 1),
+('V808', 'Touriste', 0.3, 1.4),
+('V809', 'Business', 0.2, 1.8),
+('V809', 'Economique', 0.5, 1),
+('V809', 'Touriste', 0.3, 1.4),
+('V882', 'Business', 0.2, 1.8),
+('V882', 'Economique', 0.5, 1),
+('V882', 'Touriste', 0.3, 1.4),
+('V883', 'Business', 0.2, 1.8),
+('V883', 'Economique', 0.5, 1),
+('V883', 'Touriste', 0.3, 1.4),
+('V884', 'Business', 0.2, 1.8),
+('V884', 'Economique', 0.5, 1),
+('V884', 'Touriste', 0.3, 1.4),
+('V885', 'Business', 0.2, 1.8),
+('V885', 'Economique', 0.5, 1),
+('V885', 'Touriste', 0.3, 1.4),
+('V886', 'Business', 0.2, 1.8),
+('V886', 'Economique', 0.5, 1),
+('V886', 'Touriste', 0.3, 1.4),
+('V887', 'Business', 0.2, 1.8),
+('V887', 'Economique', 0.5, 1),
+('V887', 'Touriste', 0.3, 1.4),
+('V888', 'Business', 0.2, 1.8),
+('V888', 'Economique', 0.5, 1),
+('V888', 'Touriste', 0.3, 1.4),
+('V889', 'Business', 0.2, 1.8),
+('V889', 'Economique', 0.5, 1),
+('V889', 'Touriste', 0.3, 1.4),
+('V890', 'Business', 0.2, 1.8),
+('V890', 'Economique', 0.5, 1),
+('V890', 'Touriste', 0.3, 1.4),
+('V901', 'Business', 0.2, 1.8),
+('V901', 'Economique', 0.5, 1),
+('V901', 'Touriste', 0.3, 1.4),
+('V902', 'Business', 0.2, 1.8),
+('V902', 'Economique', 0.5, 1),
+('V902', 'Touriste', 0.3, 1.4),
+('V903', 'Business', 0.2, 1.8),
+('V903', 'Economique', 0.5, 1),
+('V903', 'Touriste', 0.3, 1.4),
+('V904', 'Business', 0.2, 1.8),
+('V904', 'Economique', 0.5, 1),
+('V904', 'Touriste', 0.3, 1.4),
+('V905', 'Business', 0.2, 1.8),
+('V905', 'Economique', 0.5, 1),
+('V905', 'Touriste', 0.3, 1.4),
+('V906', 'Business', 0.2, 1.8),
+('V906', 'Economique', 0.5, 1),
+('V906', 'Touriste', 0.3, 1.4),
+('V907', 'Business', 0.2, 1.8),
+('V907', 'Economique', 0.5, 1),
+('V907', 'Touriste', 0.3, 1.4),
+('V908', 'Business', 0.2, 1.8),
+('V908', 'Economique', 0.5, 1),
+('V908', 'Touriste', 0.3, 1.4),
+('V909', 'Business', 0.2, 1.8),
+('V909', 'Economique', 0.5, 1),
+('V909', 'Touriste', 0.3, 1.4),
+('V910', 'Business', 0.2, 1.8),
+('V910', 'Economique', 0.5, 1),
+('V910', 'Touriste', 0.3, 1.4),
+('V911', 'Business', 0.2, 1.8),
+('V911', 'Economique', 0.5, 1),
+('V911', 'Touriste', 0.3, 1.4),
+('V912', 'Business', 0.2, 1.8),
+('V912', 'Economique', 0.5, 1),
+('V912', 'Touriste', 0.3, 1.4),
+('V913', 'Business', 0.2, 1.8),
+('V913', 'Economique', 0.5, 1),
+('V913', 'Touriste', 0.3, 1.4),
+('V914', 'Business', 0.2, 1.8),
+('V914', 'Economique', 0.5, 1),
+('V914', 'Touriste', 0.3, 1.4),
+('V915', 'Business', 0.2, 1.8),
+('V915', 'Economique', 0.5, 1),
+('V915', 'Touriste', 0.3, 1.4),
+('V916', 'Business', 0.2, 1.8),
+('V916', 'Economique', 0.5, 1),
+('V916', 'Touriste', 0.3, 1.4),
+('V917', 'Business', 0.2, 1.8),
+('V917', 'Economique', 0.5, 1),
+('V917', 'Touriste', 0.3, 1.4),
+('V918', 'Business', 0.2, 1.8),
+('V918', 'Economique', 0.5, 1),
+('V918', 'Touriste', 0.3, 1.4),
+('V919', 'Business', 0.2, 1.8),
+('V919', 'Economique', 0.5, 1),
+('V919', 'Touriste', 0.3, 1.4),
+('V920', 'Business', 0.2, 1.8),
+('V920', 'Economique', 0.5, 1),
+('V920', 'Touriste', 0.3, 1.4),
+('V921', 'Business', 0.2, 1.8),
+('V921', 'Economique', 0.5, 1),
+('V921', 'Touriste', 0.3, 1.4),
+('V922', 'Business', 0.2, 1.8),
+('V922', 'Economique', 0.5, 1),
+('V922', 'Touriste', 0.3, 1.4),
+('V923', 'Business', 0.2, 1.8),
+('V923', 'Economique', 0.5, 1),
+('V923', 'Touriste', 0.3, 1.4),
+('V924', 'Business', 0.2, 1.8),
+('V924', 'Economique', 0.5, 1),
+('V924', 'Touriste', 0.3, 1.4),
+('V925', 'Business', 0.2, 1.8),
+('V925', 'Economique', 0.5, 1),
+('V925', 'Touriste', 0.3, 1.4),
+('V926', 'Business', 0.2, 1.8),
+('V926', 'Economique', 0.5, 1),
+('V926', 'Touriste', 0.3, 1.4),
+('V927', 'Business', 0.2, 1.8),
+('V927', 'Economique', 0.5, 1),
+('V927', 'Touriste', 0.3, 1.4),
+('V928', 'Business', 0.2, 1.8),
+('V928', 'Economique', 0.5, 1),
+('V928', 'Touriste', 0.3, 1.4),
+('V929', 'Business', 0.2, 1.8),
+('V929', 'Economique', 0.5, 1),
+('V929', 'Touriste', 0.3, 1.4),
+('V930', 'Business', 0.2, 1.8),
+('V930', 'Economique', 0.5, 1),
+('V930', 'Touriste', 0.3, 1.4),
+('V998', 'Business', 0.2, 1.8),
+('V998', 'Economique', 0.5, 1),
+('V998', 'Touriste', 0.3, 1.4),
+('V999', 'Business', 0.2, 1.8),
+('V999', 'Economique', 0.5, 1),
+('V999', 'Touriste', 0.3, 1.4);
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `PILOTES`
+--
+
+DROP TABLE IF EXISTS `PILOTES`;
+CREATE TABLE `PILOTES` (
+ `NumPil` int(11) NOT NULL,
+ `NomPil` varchar(20) NOT NULL,
+ `NaisPil` int(11) DEFAULT NULL,
+ `VillePil` varchar(15) DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Contenu de la table `PILOTES`
+--
+
+INSERT INTO `PILOTES` (`NumPil`, `NomPil`, `NaisPil`, `VillePil`) VALUES
+(2000, 'Laplace', NULL, 'Toulon'),
+(2020, 'Lapalice', NULL, 'Marseille'),
+(2777, 'Larousse', 1963, 'Toulouse'),
+(2890, 'Latour', 1958, 'Montpellier'),
+(3000, 'Delaroche', 1960, 'Nice'),
+(3044, 'Delavigne', 1970, 'Nice'),
+(3321, 'Delacroix', 1957, 'Paris'),
+(3687, 'Delalande', 1966, 'Nice'),
+(4000, 'Duparc', 1955, 'Nice'),
+(4010, 'Dupre', NULL, 'Paris'),
+(4020, 'Duval', 1944, 'Marseille'),
+(4030, 'Dupont', 1943, NULL),
+(4040, 'Dupuis', 1960, 'Nantes'),
+(4050, 'Dumas', 1949, 'Marseille'),
+(4060, 'Dubois', NULL, NULL),
+(4070, 'Duchemin', 1965, 'Marseille'),
+(4080, 'Durand', 1950, 'Beyrouth'),
+(4090, 'Duclos', 1940, 'Toulouse'),
+(4111, 'Dujardin', 1940, 'Colmar'),
+(5050, 'Leblanc', 1960, 'Marseille'),
+(5060, 'Ledru', NULL, 'Nice'),
+(5070, 'Legrand', 1945, 'Toulon'),
+(5080, 'Leroy', 1970, NULL),
+(5090, 'Lebon', 1938, 'Lyon'),
+(5456, 'Lejoli', 1949, 'Marseille');
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `RESERVATIONS`
+--
+
+DROP TABLE IF EXISTS `RESERVATIONS`;
+CREATE TABLE `RESERVATIONS` (
+ `NumCl` int(11) NOT NULL,
+ `NumVol` varchar(5) NOT NULL,
+ `Classe` varchar(12) NOT NULL,
+ `NbPlaces` smallint(6) NOT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Contenu de la table `RESERVATIONS`
+--
+
+INSERT INTO `RESERVATIONS` (`NumCl`, `NumVol`, `Classe`, `NbPlaces`) VALUES
+(1001, 'V1000', 'Economique', 1),
+(1001, 'V1000', 'Touriste', 2),
+(1001, 'V118', 'Business', 8),
+(1001, 'V188', 'Economique', 1),
+(1036, 'V1000', 'Economique', 2),
+(1036, 'V188', 'Economique', 2),
+(1036, 'V190', 'Economique', 3),
+(1036, 'V618', 'Touriste', 8),
+(1037, 'V1000', 'Economique', 4),
+(1037, 'V1002', 'Economique', 8),
+(1037, 'V618', 'Economique', 2);
+
+-- --------------------------------------------------------
+
+--
+-- Structure de la table `VOLS`
+--
+
+DROP TABLE IF EXISTS `VOLS`;
+CREATE TABLE `VOLS` (
+ `NumVol` varchar(5) NOT NULL,
+ `VilleD` varchar(15) NOT NULL,
+ `VilleA` varchar(15) NOT NULL,
+ `DateD` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
+ `DateA` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
+ `NumPil` int(11) DEFAULT NULL,
+ `NumAv` int(11) DEFAULT NULL,
+ `CoutVol` int(11) DEFAULT NULL
+) ENGINE=InnoDB DEFAULT CHARSET=latin1;
+
+--
+-- Contenu de la table `VOLS`
+--
+
+INSERT INTO `VOLS` (`NumVol`, `VilleD`, `VilleA`, `DateD`, `DateA`, `NumPil`, `NumAv`, `CoutVol`) VALUES
+('V1000', 'Amsterdam', 'Marseille', '2018-04-07 13:30:00', '2018-04-07 18:00:00', 5050, 250, 1100),
+('V1001', 'Amsterdam', 'Marseille', '2018-04-07 04:30:00', '2018-04-07 10:10:00', 4040, 320, 1200),
+('V1002', 'Marseille', 'Ajaccio', '2018-04-07 16:00:00', '2018-04-07 17:40:00', 3321, 269, 3950),
+('V101', 'Marseille', 'Amsterdam', '2001-04-07 06:10:00', '2001-04-07 07:10:00', 5050, 560, 950),
+('V102', 'Marseille', 'Amsterdam', '2002-04-07 06:10:00', '2002-04-07 07:10:00', 5050, 560, 950),
+('V103', 'Marseille', 'Amsterdam', '2003-04-07 06:10:00', '2003-04-07 07:10:00', 5050, 560, 950),
+('V104', 'Marseille', 'Amsterdam', '2004-04-07 06:10:00', '2004-04-07 07:10:00', 5050, 560, 950),
+('V105', 'Marseille', 'Amsterdam', '2005-04-07 06:10:00', '2005-04-07 07:10:00', 5050, 560, 950),
+('V106', 'Marseille', 'Amsterdam', '2006-04-07 06:10:00', '2006-04-07 07:10:00', 5050, 560, 950),
+('V107', 'Marseille', 'Amsterdam', '2007-04-07 06:10:00', '2007-04-07 07:10:00', 5050, 560, 950),
+('V108', 'Marseille', 'Amsterdam', '2008-04-07 06:10:00', '2008-04-07 07:10:00', 5050, 560, 950),
+('V109', 'Marseille', 'Amsterdam', '2009-04-07 06:10:00', '2009-04-07 07:10:00', 5050, 560, 950),
+('V110', 'Marseille', 'Amsterdam', '2010-04-07 06:10:00', '2010-04-07 07:10:00', 5050, 560, 950),
+('V111', 'Marseille', 'Amsterdam', '2011-04-07 06:10:00', '2011-04-07 07:10:00', 5050, 560, 950),
+('V112', 'Marseille', 'Amsterdam', '2012-04-07 06:10:00', '2012-04-07 07:10:00', 5050, 560, 950),
+('V113', 'Marseille', 'Amsterdam', '2013-04-07 06:10:00', '2013-04-07 07:10:00', 5050, 560, 950),
+('V114', 'Marseille', 'Amsterdam', '2014-04-07 06:10:00', '2014-04-07 07:10:00', 5050, 560, 950),
+('V115', 'Marseille', 'Amsterdam', '2015-04-07 06:10:00', '2015-04-07 07:10:00', 5050, 560, 950),
+('V116', 'Marseille', 'Amsterdam', '2016-04-07 06:10:00', '2016-04-07 07:10:00', 5050, 560, 950),
+('V117', 'Marseille', 'Amsterdam', '2017-04-07 06:10:00', '2017-04-07 07:10:00', 5050, 560, 950),
+('V118', 'Marseille', 'Amsterdam', '2018-04-07 06:10:00', '2018-04-07 07:10:00', 5050, 560, 950),
+('V119', 'Marseille', 'Amsterdam', '2019-04-07 06:10:00', '2019-04-07 07:10:00', 5050, 560, 950),
+('V120', 'Marseille', 'Amsterdam', '2020-04-07 06:10:00', '2020-04-07 07:10:00', 5050, 560, 950),
+('V131', 'Paris', 'Beyrouth', '2018-01-09 14:21:59', '2018-01-09 14:21:59', 4010, 122, 5200),
+('V141', 'Amsterdam', 'Marseille', '2001-04-07 21:20:00', '2002-04-06 23:10:00', 5050, 101, 950),
+('V142', 'Amsterdam', 'Marseille', '2002-04-07 21:20:00', '2003-04-06 23:10:00', 5050, 101, 950),
+('V143', 'Amsterdam', 'Marseille', '2003-04-07 21:20:00', '2004-04-06 23:10:00', 5050, 101, 950),
+('V144', 'Amsterdam', 'Marseille', '2004-04-07 21:20:00', '2005-04-06 23:10:00', 5050, 101, 950),
+('V145', 'Amsterdam', 'Marseille', '2005-04-07 21:20:00', '2006-04-06 23:10:00', 5050, 101, 950),
+('V146', 'Amsterdam', 'Marseille', '2006-04-07 21:20:00', '2007-04-06 23:10:00', 5050, 101, 950),
+('V147', 'Amsterdam', 'Marseille', '2007-04-07 21:20:00', '2008-04-06 23:10:00', 5050, 101, 950),
+('V148', 'Amsterdam', 'Marseille', '2008-04-07 21:20:00', '2009-04-06 23:10:00', 5050, 101, 950),
+('V149', 'Amsterdam', 'Marseille', '2009-04-07 21:20:00', '2010-04-06 23:10:00', 5050, 101, 950),
+('V150', 'Amsterdam', 'Marseille', '2010-04-07 21:20:00', '2011-04-06 23:10:00', 5050, 101, 950),
+('V151', 'Amsterdam', 'Marseille', '2011-04-07 21:20:00', '2012-04-06 23:10:00', 5050, 101, 950),
+('V152', 'Amsterdam', 'Marseille', '2012-04-07 21:20:00', '2013-04-06 23:10:00', 5050, 101, 950),
+('V153', 'Amsterdam', 'Marseille', '2013-04-07 21:20:00', '2014-04-06 23:10:00', 5050, 101, 950),
+('V154', 'Amsterdam', 'Marseille', '2014-04-07 21:20:00', '2015-04-06 23:10:00', 5050, 101, 950),
+('V155', 'Amsterdam', 'Marseille', '2015-04-07 21:20:00', '2016-04-06 23:10:00', 5050, 101, 950),
+('V156', 'Amsterdam', 'Marseille', '2016-04-07 21:20:00', '2017-04-06 23:10:00', 5050, 101, 950),
+('V157', 'Amsterdam', 'Marseille', '2017-04-07 21:20:00', '2018-04-06 23:10:00', 5050, 101, 950),
+('V180', 'Marseille', 'Amsterdam', '2010-04-07 08:10:00', '2010-04-07 09:10:00', 5050, 915, 950),
+('V181', 'Marseille', 'Amsterdam', '2011-04-07 08:10:00', '2011-04-07 09:10:00', 5050, 915, 950),
+('V182', 'Marseille', 'Amsterdam', '2012-04-07 08:10:00', '2012-04-07 09:10:00', 5050, 915, 950),
+('V183', 'Marseille', 'Amsterdam', '2013-04-07 08:10:00', '2013-04-07 09:10:00', 5050, 915, 950),
+('V184', 'Marseille', 'Amsterdam', '2014-04-07 08:10:00', '2014-04-07 09:10:00', 5050, 915, 950),
+('V185', 'Marseille', 'Amsterdam', '2015-04-07 08:10:00', '2015-04-07 09:10:00', 5050, 915, 950),
+('V186', 'Marseille', 'Amsterdam', '2016-04-07 08:10:00', '2016-04-07 09:10:00', 5050, 915, 950),
+('V187', 'Marseille', 'Amsterdam', '2017-04-07 08:10:00', '2017-04-07 09:10:00', 5050, 915, 950),
+('V188', 'Marseille', 'Amsterdam', '2018-04-07 08:10:00', '2018-04-07 09:10:00', 5050, 915, 950),
+('V189', 'Marseille', 'Amsterdam', '2019-04-07 08:10:00', '2019-04-07 09:10:00', 5050, 915, 950),
+('V190', 'Marseille', 'Amsterdam', '2020-04-07 08:10:00', '2020-04-07 09:10:00', 5050, 915, 950),
+('V191', 'Marseille', 'Amsterdam', '2021-04-07 08:10:00', '2021-04-07 09:10:00', 5050, 915, 950),
+('V192', 'Marseille', 'Amsterdam', '2022-04-07 08:10:00', '2022-04-07 09:10:00', 5050, 915, 950),
+('V193', 'Marseille', 'Amsterdam', '2023-04-07 08:10:00', '2023-04-07 09:10:00', 5050, 915, 950),
+('V194', 'Marseille', 'Amsterdam', '2024-04-07 08:10:00', '2024-04-07 09:10:00', 5050, 915, 950),
+('V195', 'Marseille', 'Amsterdam', '2025-04-07 08:10:00', '2025-04-07 09:10:00', 5050, 915, 950),
+('V196', 'Marseille', 'Amsterdam', '2026-04-07 08:10:00', '2026-04-07 09:10:00', 5050, 915, 950),
+('V197', 'Marseille', 'Amsterdam', '2027-04-07 08:10:00', '2027-04-07 09:10:00', 5050, 915, 950),
+('V198', 'Marseille', 'Amsterdam', '2028-04-07 08:10:00', '2028-04-07 09:10:00', 5050, 915, 950),
+('V199', 'Marseille', 'Amsterdam', '2029-04-07 08:10:00', '2029-04-07 09:10:00', 5050, 915, 950),
+('V200', 'Marseille', 'Amsterdam', '2030-04-07 08:10:00', '2030-04-07 09:10:00', 5050, 915, 950),
+('V210', 'Paris', 'Moscou', '2018-01-09 14:21:59', '2018-01-09 14:21:59', 2020, 511, 4900),
+('V211', 'Paris', 'Pekin', '2001-04-07 15:00:00', '2002-04-07 03:07:00', 5070, 525, 3900),
+('V212', 'Paris', 'Pekin', '2003-04-07 15:00:00', '2004-04-07 03:07:00', 5070, 525, 3900),
+('V213', 'Paris', 'Pekin', '2005-04-07 15:00:00', '2006-04-07 03:07:00', 5070, 525, 3900),
+('V214', 'Paris', 'Pekin', '2007-04-07 15:00:00', '2008-04-07 03:07:00', 5070, 525, 3900),
+('V215', 'Paris', 'Pekin', '2009-04-07 15:00:00', '2010-04-07 03:07:00', 5070, 525, 3900),
+('V216', 'Paris', 'Pekin', '2011-04-07 15:00:00', '2012-04-07 03:07:00', 5070, 525, 3900),
+('V217', 'Paris', 'Pekin', '2013-04-07 15:00:00', '2014-04-07 03:07:00', 5070, 525, 3900),
+('V218', 'Paris', 'Pekin', '2015-04-07 15:00:00', '2016-04-07 03:07:00', 5070, 525, 3900),
+('V219', 'Paris', 'Pekin', '2017-04-07 15:00:00', '2018-04-07 03:07:00', 5070, 525, 3900),
+('V220', 'Paris', 'Pekin', '2019-04-07 15:00:00', '2020-04-07 03:07:00', 5070, 525, 3900),
+('V221', 'Paris', 'Pekin', '2021-04-07 15:00:00', '2022-04-07 03:07:00', 5070, 525, 3900),
+('V222', 'Paris', 'Pekin', '2023-04-07 15:00:00', '2024-04-07 03:07:00', 5070, 525, 3900),
+('V223', 'Paris', 'Pekin', '2025-04-07 15:00:00', '2026-04-07 03:07:00', 5070, 525, 3900),
+('V224', 'Paris', 'Pekin', '2027-04-07 15:00:00', '2028-04-07 03:07:00', 5070, 525, 3900),
+('V240', 'Marseille', 'Paris', '2018-01-09 14:21:59', '2018-01-09 14:21:59', 5050, 315, 850),
+('V265', 'Paris', 'Marseille', '2015-04-07 06:10:00', '2015-04-07 07:10:00', 4000, 715, 850),
+('V341', 'Marseille', 'Paris', '2001-04-07 06:10:00', '2001-04-07 07:10:00', NULL, 415, 850),
+('V342', 'Marseille', 'Paris', '2002-04-07 06:10:00', '2002-04-07 07:10:00', NULL, 415, 850),
+('V343', 'Marseille', 'Paris', '2003-04-07 06:10:00', '2003-04-07 07:10:00', NULL, 415, 850),
+('V344', 'Marseille', 'Paris', '2004-04-07 06:10:00', '2004-04-07 07:10:00', NULL, 415, 850),
+('V345', 'Marseille', 'Paris', '2005-04-07 06:10:00', '2005-04-07 07:10:00', NULL, 415, 850),
+('V346', 'Marseille', 'Paris', '2006-04-07 06:10:00', '2006-04-07 07:10:00', NULL, 415, 850),
+('V347', 'Marseille', 'Paris', '2007-04-07 06:10:00', '2007-04-07 07:10:00', NULL, 415, 850),
+('V348', 'Marseille', 'Paris', '2008-04-07 06:10:00', '2008-04-07 07:10:00', NULL, 415, 850),
+('V349', 'Marseille', 'Paris', '2009-04-07 06:10:00', '2009-04-07 07:10:00', NULL, 415, 850),
+('V350', 'Marseille', 'Paris', '2010-04-07 06:10:00', '2010-04-07 07:10:00', NULL, 415, 850),
+('V351', 'Marseille', 'Paris', '2011-04-07 06:10:00', '2011-04-07 07:10:00', NULL, 415, 850),
+('V352', 'Marseille', 'Paris', '2012-04-07 06:10:00', '2012-04-07 07:10:00', NULL, 415, 850),
+('V353', 'Marseille', 'Paris', '2013-04-07 06:10:00', '2013-04-07 07:10:00', NULL, 415, 850),
+('V354', 'Marseille', 'Paris', '2014-04-07 06:10:00', '2014-04-07 07:10:00', NULL, 415, 850),
+('V355', 'Marseille', 'Paris', '2015-04-07 06:10:00', '2015-04-07 07:10:00', NULL, 415, 850),
+('V356', 'Marseille', 'Paris', '2016-04-07 06:10:00', '2016-04-07 07:10:00', NULL, 415, 850),
+('V357', 'Marseille', 'Paris', '2017-04-07 06:10:00', '2017-04-07 07:10:00', NULL, 415, 850),
+('V358', 'Marseille', 'Paris', '2018-01-20 12:06:20', '2018-04-07 07:10:00', 3321, 415, 850),
+('V359', 'Marseille', 'Paris', '2019-04-07 06:10:00', '2019-04-07 07:10:00', NULL, 415, 850),
+('V360', 'Marseille', 'Paris', '2020-04-07 06:10:00', '2020-04-07 07:10:00', NULL, 415, 850),
+('V361', 'Marseille', 'Paris', '2021-04-07 06:10:00', '2021-04-07 07:10:00', NULL, 415, 850),
+('V362', 'Marseille', 'Paris', '2022-04-07 06:10:00', '2022-04-07 07:10:00', NULL, 415, 850),
+('V363', 'Marseille', 'Paris', '2023-04-07 06:10:00', '2023-04-07 07:10:00', NULL, 415, 850),
+('V364', 'Marseille', 'Paris', '2024-04-07 06:10:00', '2024-04-07 07:10:00', NULL, 415, 850),
+('V365', 'Marseille', 'Paris', '2025-04-07 06:10:00', '2025-04-07 07:10:00', NULL, 415, 850),
+('V366', 'Marseille', 'Paris', '2026-04-07 06:10:00', '2026-04-07 07:10:00', NULL, 415, 850),
+('V367', 'Marseille', 'Paris', '2027-04-07 06:10:00', '2027-04-07 07:10:00', NULL, 415, 850),
+('V368', 'Marseille', 'Paris', '2028-04-07 06:10:00', '2028-04-07 07:10:00', NULL, 415, 850),
+('V369', 'Marseille', 'Paris', '2029-04-07 06:10:00', '2029-04-07 07:10:00', NULL, 415, 850),
+('V370', 'Marseille', 'Paris', '2030-04-07 06:10:00', '2030-04-07 07:10:00', NULL, 415, 850),
+('V420', 'Nantes', 'Paris', '2020-04-07 06:00:00', '2020-04-07 07:10:00', 3321, 140, 250),
+('V431', 'Marseille', 'Istanbul', '2018-01-09 14:22:00', '2018-01-09 14:22:00', 5050, 535, 1000),
+('V490', 'Paris', 'New York', '2018-01-09 14:22:00', '2018-01-09 14:22:00', 4030, 269, 2560),
+('V501', 'Marseille', 'New York', '2001-04-07 06:30:00', '2001-04-07 08:40:00', 5060, 240, 2500),
+('V502', 'Marseille', 'New York', '2002-04-07 06:30:00', '2002-04-07 08:40:00', 5060, 240, 2500),
+('V503', 'Marseille', 'New York', '2003-04-07 06:30:00', '2003-04-07 08:40:00', 5060, 240, 2500),
+('V504', 'Marseille', 'New York', '2004-04-07 06:30:00', '2004-04-07 08:40:00', 5060, 240, 2500),
+('V505', 'Marseille', 'New York', '2005-04-07 06:30:00', '2005-04-07 08:40:00', 5060, 240, 2500),
+('V506', 'Marseille', 'New York', '2006-04-07 06:30:00', '2006-04-07 08:40:00', 5060, 240, 2500),
+('V507', 'Marseille', 'New York', '2007-04-07 06:30:00', '2007-04-07 08:40:00', 5060, 240, 2500),
+('V508', 'Marseille', 'New York', '2008-04-07 06:30:00', '2008-04-07 08:40:00', 5060, 240, 2500),
+('V509', 'Marseille', 'New York', '2009-04-07 06:30:00', '2009-04-07 08:40:00', 5060, 240, 2500),
+('V510', 'Marseille', 'New York', '2010-04-07 06:30:00', '2010-04-07 08:40:00', 5060, 240, 2500),
+('V511', 'Marseille', 'New York', '2011-04-07 06:30:00', '2011-04-07 08:40:00', 5060, 240, 2500),
+('V512', 'Marseille', 'New York', '2012-04-07 06:30:00', '2012-04-07 08:40:00', 5060, 240, 2500),
+('V513', 'Marseille', 'New York', '2013-04-07 06:30:00', '2013-04-07 08:40:00', 5060, 240, 2500),
+('V514', 'Marseille', 'New York', '2014-04-07 06:30:00', '2014-04-07 08:40:00', 5060, 240, 2500),
+('V515', 'Marseille', 'New York', '2015-04-07 06:30:00', '2015-04-07 08:40:00', 5060, 240, 2500),
+('V516', 'Marseille', 'New York', '2016-04-07 06:30:00', '2016-04-07 08:40:00', 5060, 240, 2500),
+('V517', 'Marseille', 'New York', '2017-04-07 06:30:00', '2017-04-07 08:40:00', 5060, 240, 2500),
+('V518', 'Marseille', 'New York', '2018-04-07 06:30:00', '2018-04-07 08:40:00', 5060, 240, 2500),
+('V519', 'Marseille', 'New York', '2019-04-07 06:30:00', '2019-04-07 08:40:00', 5060, 240, 2500),
+('V520', 'Marseille', 'New York', '2020-04-07 06:30:00', '2020-04-07 08:40:00', 5060, 240, 2500),
+('V521', 'Marseille', 'New York', '2021-04-07 06:30:00', '2021-04-07 08:40:00', 5060, 240, 2500),
+('V522', 'Marseille', 'New York', '2022-04-07 06:30:00', '2022-04-07 08:40:00', 5060, 240, 2500),
+('V523', 'Marseille', 'New York', '2023-04-07 06:30:00', '2023-04-07 08:40:00', 5060, 240, 2500),
+('V524', 'Marseille', 'New York', '2024-04-07 06:30:00', '2024-04-07 08:40:00', 5060, 240, 2500),
+('V525', 'Marseille', 'New York', '2025-04-07 06:30:00', '2025-04-07 08:40:00', 5060, 240, 2500),
+('V526', 'Marseille', 'New York', '2026-04-07 06:30:00', '2026-04-07 08:40:00', 5060, 240, 2500),
+('V527', 'Marseille', 'New York', '2027-04-07 06:30:00', '2027-04-07 08:40:00', 5060, 240, 2500),
+('V528', 'Marseille', 'New York', '2028-04-07 06:30:00', '2028-04-07 08:40:00', 5060, 240, 2500),
+('V529', 'Marseille', 'New York', '2029-04-07 06:30:00', '2029-04-07 08:40:00', 5060, 240, 2500),
+('V530', 'Marseille', 'New York', '2030-04-07 06:30:00', '2030-04-07 08:40:00', 5060, 240, 2500),
+('V590', 'Nice', 'Alger', '2018-01-09 14:22:00', '2018-01-09 14:22:00', 4040, 320, 2250),
+('V601', 'Ajaccio', 'Marseille', '2001-04-07 16:00:00', '2001-04-07 17:40:00', 3687, 840, 3950),
+('V602', 'Ajaccio', 'Marseille', '2002-04-07 16:00:00', '2002-04-07 17:40:00', 3687, 840, 3950),
+('V603', 'Ajaccio', 'Marseille', '2003-04-07 16:00:00', '2003-04-07 17:40:00', 3687, 840, 3950),
+('V604', 'Ajaccio', 'Marseille', '2004-04-07 16:00:00', '2004-04-07 17:40:00', 3687, 840, 3950),
+('V605', 'Ajaccio', 'Marseille', '2005-04-07 16:00:00', '2005-04-07 17:40:00', 3687, 840, 3950),
+('V606', 'Ajaccio', 'Marseille', '2006-04-07 16:00:00', '2006-04-07 17:40:00', 3687, 840, 3950),
+('V607', 'Ajaccio', 'Marseille', '2007-04-07 16:00:00', '2007-04-07 17:40:00', 3687, 840, 3950),
+('V608', 'Ajaccio', 'Marseille', '2008-04-07 16:00:00', '2008-04-07 17:40:00', 3687, 840, 3950),
+('V609', 'Ajaccio', 'Marseille', '2009-04-07 16:00:00', '2009-04-07 17:40:00', 3687, 840, 3950),
+('V610', 'Ajaccio', 'Marseille', '2010-04-07 16:00:00', '2010-04-07 17:40:00', 3687, 840, 3950),
+('V611', 'Ajaccio', 'Marseille', '2011-04-07 16:00:00', '2011-04-07 17:40:00', 3687, 840, 3950),
+('V612', 'Ajaccio', 'Marseille', '2012-04-07 16:00:00', '2012-04-07 17:40:00', 3687, 840, 3950),
+('V613', 'Ajaccio', 'Marseille', '2013-04-07 16:00:00', '2013-04-07 17:40:00', 3687, 840, 3950),
+('V614', 'Ajaccio', 'Marseille', '2014-04-07 16:00:00', '2014-04-07 17:40:00', 3687, 840, 3950),
+('V615', 'Ajaccio', 'Marseille', '2015-04-07 16:00:00', '2015-04-07 17:40:00', 3687, 840, 3950),
+('V616', 'Ajaccio', 'Marseille', '2016-04-07 16:00:00', '2016-04-07 17:40:00', 3687, 840, 3950),
+('V617', 'Ajaccio', 'Marseille', '2017-04-07 16:00:00', '2017-04-07 17:40:00', 3687, 840, 3950),
+('V618', 'Ajaccio', 'Marseille', '2018-04-07 16:00:00', '2018-04-07 17:40:00', 3687, 840, 3950),
+('V619', 'Ajaccio', 'Marseille', '2019-04-07 16:00:00', '2019-04-07 17:40:00', 3687, 840, 3950),
+('V620', 'Ajaccio', 'Marseille', '2020-04-07 16:00:00', '2020-04-07 17:40:00', 3687, 840, 3950),
+('V621', 'Ajaccio', 'Marseille', '2021-04-07 16:00:00', '2021-04-07 17:40:00', 3687, 840, 3950),
+('V622', 'Ajaccio', 'Marseille', '2022-04-07 16:00:00', '2022-04-07 17:40:00', 3687, 840, 3950),
+('V623', 'Ajaccio', 'Marseille', '2023-04-07 16:00:00', '2023-04-07 17:40:00', 3687, 840, 3950),
+('V624', 'Ajaccio', 'Marseille', '2024-04-07 16:00:00', '2024-04-07 17:40:00', 3687, 840, 3950),
+('V625', 'Ajaccio', 'Marseille', '2025-04-07 16:00:00', '2025-04-07 17:40:00', 3687, 840, 3950),
+('V626', 'Ajaccio', 'Marseille', '2026-04-07 16:00:00', '2026-04-07 17:40:00', 3687, 840, 3950),
+('V627', 'Ajaccio', 'Marseille', '2027-04-07 16:00:00', '2027-04-07 17:40:00', 3687, 840, 3950),
+('V628', 'Ajaccio', 'Marseille', '2028-04-07 16:00:00', '2028-04-07 17:40:00', 3687, 840, 3950),
+('V629', 'Ajaccio', 'Marseille', '2029-04-07 16:00:00', '2029-04-07 17:40:00', 3687, 840, 3950),
+('V630', 'Ajaccio', 'Marseille', '2030-04-07 16:00:00', '2030-04-07 17:40:00', 3687, 840, 3950),
+('V641', 'Ajaccio', 'Marseille', '2001-04-07 16:00:00', '2001-04-07 17:40:00', 3321, NULL, 3950),
+('V642', 'Ajaccio', 'Marseille', '2002-04-07 16:00:00', '2002-04-07 17:40:00', 3321, NULL, 3950),
+('V643', 'Ajaccio', 'Marseille', '2003-04-07 16:00:00', '2003-04-07 17:40:00', 3321, NULL, 3950),
+('V644', 'Ajaccio', 'Marseille', '2004-04-07 16:00:00', '2004-04-07 17:40:00', 3321, NULL, 3950),
+('V645', 'Ajaccio', 'Marseille', '2005-04-07 16:00:00', '2005-04-07 17:40:00', 3321, NULL, 3950),
+('V646', 'Ajaccio', 'Marseille', '2006-04-07 16:00:00', '2006-04-07 17:40:00', 3321, NULL, 3950),
+('V647', 'Ajaccio', 'Marseille', '2007-04-07 16:00:00', '2007-04-07 17:40:00', 3321, NULL, 3950),
+('V648', 'Ajaccio', 'Marseille', '2008-04-07 16:00:00', '2008-04-07 17:40:00', 3321, NULL, 3950),
+('V649', 'Ajaccio', 'Marseille', '2009-04-07 16:00:00', '2009-04-07 17:40:00', 3321, NULL, 3950),
+('V650', 'Ajaccio', 'Marseille', '2010-04-07 16:00:00', '2010-04-07 17:40:00', 3321, NULL, 3950),
+('V651', 'Ajaccio', 'Marseille', '2011-04-07 16:00:00', '2011-04-07 17:40:00', 3321, NULL, 3950),
+('V652', 'Ajaccio', 'Marseille', '2012-04-07 16:00:00', '2012-04-07 17:40:00', 3321, NULL, 3950),
+('V653', 'Ajaccio', 'Marseille', '2013-04-07 16:00:00', '2013-04-07 17:40:00', 3321, NULL, 3950),
+('V654', 'Ajaccio', 'Marseille', '2014-04-07 16:00:00', '2014-04-07 17:40:00', 3321, NULL, 3950),
+('V655', 'Ajaccio', 'Marseille', '2015-04-07 16:00:00', '2015-04-07 17:40:00', 3321, NULL, 3950),
+('V656', 'Ajaccio', 'Marseille', '2016-04-07 16:00:00', '2016-04-07 17:40:00', 3321, NULL, 3950),
+('V657', 'Ajaccio', 'Marseille', '2017-04-07 16:00:00', '2017-04-07 17:40:00', 3321, NULL, 3950),
+('V658', 'Ajaccio', 'Marseille', '2018-04-07 16:00:00', '2018-04-07 17:40:00', 3321, NULL, 3950),
+('V659', 'Ajaccio', 'Marseille', '2018-01-20 11:28:38', '2019-04-07 17:40:00', 3321, 820, 3950),
+('V660', 'Ajaccio', 'Marseille', '2020-04-07 16:00:00', '2020-04-07 17:40:00', 3321, NULL, 3950),
+('V661', 'Ajaccio', 'Marseille', '2021-04-07 16:00:00', '2021-04-07 17:40:00', 3321, NULL, 3950),
+('V662', 'Ajaccio', 'Marseille', '2022-04-07 16:00:00', '2022-04-07 17:40:00', 3321, NULL, 3950),
+('V663', 'Ajaccio', 'Marseille', '2023-04-07 16:00:00', '2023-04-07 17:40:00', 3321, NULL, 3950),
+('V664', 'Ajaccio', 'Marseille', '2024-04-07 16:00:00', '2024-04-07 17:40:00', 3321, NULL, 3950),
+('V665', 'Ajaccio', 'Marseille', '2025-04-07 16:00:00', '2025-04-07 17:40:00', 3321, NULL, 3950),
+('V666', 'Ajaccio', 'Marseille', '2026-04-07 16:00:00', '2026-04-07 17:40:00', 3321, NULL, 3950),
+('V667', 'Ajaccio', 'Marseille', '2027-04-07 16:00:00', '2027-04-07 17:40:00', 3321, NULL, 3950),
+('V668', 'Ajaccio', 'Marseille', '2028-04-07 16:00:00', '2028-04-07 17:40:00', 3321, NULL, 3950),
+('V669', 'Ajaccio', 'Marseille', '2029-04-07 16:00:00', '2029-04-07 17:40:00', 3321, NULL, 3950),
+('V670', 'Ajaccio', 'Marseille', '2030-04-07 16:00:00', '2030-04-07 17:40:00', 3321, NULL, 3950),
+('V681', 'Marseille', 'Pekin', '2001-04-07 16:00:00', '2002-04-07 04:15:00', 4050, 440, 5400),
+('V682', 'Marseille', 'Pekin', '2003-04-07 16:00:00', '2004-04-07 04:15:00', 4050, 440, 5400),
+('V683', 'Marseille', 'Pekin', '2005-04-07 16:00:00', '2006-04-07 04:15:00', 4050, 440, 5400),
+('V684', 'Marseille', 'Pekin', '2007-04-07 16:00:00', '2008-04-07 04:15:00', 4050, 440, 5400),
+('V685', 'Marseille', 'Pekin', '2009-04-07 16:00:00', '2010-04-07 04:15:00', 4050, 440, 5400),
+('V686', 'Marseille', 'Pekin', '2011-04-07 16:00:00', '2012-04-07 04:15:00', 4050, 440, 5400),
+('V687', 'Marseille', 'Pekin', '2013-04-07 16:00:00', '2014-04-07 04:15:00', 4050, 440, 5400),
+('V688', 'Marseille', 'Pekin', '2015-04-07 16:00:00', '2016-04-07 04:15:00', 4050, 440, 5400),
+('V689', 'Marseille', 'Pekin', '2017-04-07 16:00:00', '2018-04-07 04:15:00', 4050, 440, 5400),
+('V690', 'Marseille', 'Pekin', '2019-04-07 16:00:00', '2020-04-07 04:15:00', 4050, 440, 5400),
+('V691', 'Marseille', 'Pekin', '2021-04-07 16:00:00', '2022-04-07 04:15:00', 4050, 440, 5400),
+('V692', 'Marseille', 'Pekin', '2023-04-07 16:00:00', '2024-04-07 04:15:00', 4050, 440, 5400),
+('V693', 'Marseille', 'Pekin', '2025-04-07 16:00:00', '2026-04-07 04:15:00', 4050, 440, 5400),
+('V694', 'Marseille', 'Pekin', '2027-04-07 16:00:00', '2028-04-07 04:15:00', 4050, 440, 5400),
+('V720', 'Beyrouth', 'Paris', '2018-01-09 14:22:01', '2018-01-09 14:22:01', 4080, 811, 1950),
+('V787', 'Metz', 'Marseille', '2017-04-07 03:00:00', '2017-04-07 04:15:00', 4060, 720, 1400),
+('V788', 'Metz', 'Marseille', '2018-04-07 03:00:00', '2018-04-07 04:15:00', 4060, 720, 1400),
+('V789', 'Metz', 'Marseille', '2019-04-07 03:00:00', '2019-04-07 04:15:00', 4060, 720, 1400),
+('V790', 'Metz', 'Marseille', '2020-04-07 03:00:00', '2020-04-07 04:15:00', 4060, 720, 1400),
+('V791', 'Metz', 'Marseille', '2021-04-07 03:00:00', '2021-04-07 04:15:00', 4060, 720, 1400),
+('V804', 'Nice', 'Paris', '2004-04-07 03:00:00', '2004-04-07 04:15:00', 4020, 240, 1200),
+('V805', 'Nice', 'Paris', '2005-04-07 03:00:00', '2005-04-07 04:15:00', 4020, 240, 1200),
+('V806', 'Nice', 'Paris', '2006-04-07 03:00:00', '2006-04-07 04:15:00', 4020, 240, 1200),
+('V807', 'Nice', 'Paris', '2007-04-07 03:00:00', '2007-04-07 04:15:00', 4020, 240, 1200),
+('V808', 'Nice', 'Paris', '2008-04-07 03:00:00', '2008-04-07 04:15:00', 4020, 240, 1200),
+('V809', 'Nice', 'Paris', '2009-04-07 03:00:00', '2009-04-07 04:15:00', 4020, 240, 1200),
+('V882', 'Strasbourg', 'Marseille', '2012-04-07 05:00:00', '2012-04-07 06:15:00', 4060, 240, 1650),
+('V883', 'Strasbourg', 'Marseille', '2013-04-07 05:00:00', '2013-04-07 06:15:00', 4060, 240, 1650),
+('V884', 'Strasbourg', 'Marseille', '2014-04-07 05:00:00', '2014-04-07 06:15:00', 4060, 240, 1650),
+('V885', 'Strasbourg', 'Marseille', '2015-04-07 05:00:00', '2015-04-07 06:15:00', 4060, 240, 1650),
+('V886', 'Strasbourg', 'Marseille', '2016-04-07 05:00:00', '2016-04-07 06:15:00', 4060, 240, 1650),
+('V887', 'Strasbourg', 'Marseille', '2017-04-07 05:00:00', '2017-04-07 06:15:00', 4060, 240, 1650),
+('V888', 'Strasbourg', 'Marseille', '2018-04-07 05:00:00', '2018-04-07 06:15:00', 4060, 240, 1650),
+('V889', 'Strasbourg', 'Marseille', '2019-04-07 05:00:00', '2019-04-07 06:15:00', 4060, 240, 1650),
+('V890', 'Strasbourg', 'Marseille', '2020-04-07 05:00:00', '2020-04-07 06:15:00', 4060, 240, 1650),
+('V901', 'Paris', 'Nice', '2001-04-07 20:00:00', '2001-04-07 21:15:00', 4020, 240, 1200),
+('V902', 'Paris', 'Nice', '2002-04-07 20:00:00', '2002-04-07 21:15:00', 4020, 240, 1200),
+('V903', 'Paris', 'Nice', '2003-04-07 20:00:00', '2003-04-07 21:15:00', 4020, 240, 1200),
+('V904', 'Paris', 'Nice', '2004-04-07 20:00:00', '2004-04-07 21:15:00', 4020, 240, 1200),
+('V905', 'Paris', 'Nice', '2005-04-07 20:00:00', '2005-04-07 21:15:00', 4020, 240, 1200),
+('V906', 'Paris', 'Nice', '2006-04-07 20:00:00', '2006-04-07 21:15:00', 4020, 240, 1200),
+('V907', 'Paris', 'Nice', '2007-04-07 20:00:00', '2007-04-07 21:15:00', 4020, 240, 1200),
+('V908', 'Paris', 'Nice', '2008-04-07 20:00:00', '2008-04-07 21:15:00', 4020, 240, 1200),
+('V909', 'Paris', 'Nice', '2009-04-07 20:00:00', '2009-04-07 21:15:00', 4020, 240, 1200),
+('V910', 'Paris', 'Nice', '2010-04-07 20:00:00', '2010-04-07 21:15:00', 4020, 240, 1200),
+('V911', 'Paris', 'Nice', '2011-04-07 20:00:00', '2011-04-07 21:15:00', 4020, 240, 1200),
+('V912', 'Paris', 'Nice', '2012-04-07 20:00:00', '2012-04-07 21:15:00', 4020, 240, 1200),
+('V913', 'Paris', 'Nice', '2013-04-07 20:00:00', '2013-04-07 21:15:00', 4020, 240, 1200),
+('V914', 'Paris', 'Nice', '2014-04-07 20:00:00', '2014-04-07 21:15:00', 4020, 240, 1200),
+('V915', 'Paris', 'Nice', '2015-04-07 20:00:00', '2015-04-07 21:15:00', 4020, 240, 1200),
+('V916', 'Paris', 'Nice', '2016-04-07 20:00:00', '2016-04-07 21:15:00', 4020, 240, 1200),
+('V917', 'Paris', 'Nice', '2017-04-07 20:00:00', '2017-04-07 21:15:00', 4020, 240, 1200),
+('V918', 'Paris', 'Nice', '2018-04-07 20:00:00', '2018-04-07 21:15:00', 4020, 240, 1200),
+('V919', 'Paris', 'Nice', '2019-04-07 20:00:00', '2019-04-07 21:15:00', 4020, 240, 1200),
+('V920', 'Paris', 'Nice', '2020-04-07 20:00:00', '2020-04-07 21:15:00', 4020, 240, 1200),
+('V921', 'Paris', 'Nice', '2021-04-07 20:00:00', '2021-04-07 21:15:00', 4020, 240, 1200),
+('V922', 'Paris', 'Nice', '2022-04-07 20:00:00', '2022-04-07 21:15:00', 4020, 240, 1200),
+('V923', 'Paris', 'Nice', '2023-04-07 20:00:00', '2023-04-07 21:15:00', 4020, 240, 1200),
+('V924', 'Paris', 'Nice', '2024-04-07 20:00:00', '2024-04-07 21:15:00', 4020, 240, 1200),
+('V925', 'Paris', 'Nice', '2025-04-07 20:00:00', '2025-04-07 21:15:00', 4020, 240, 1200),
+('V926', 'Paris', 'Nice', '2026-04-07 20:00:00', '2026-04-07 21:15:00', 4020, 240, 1200),
+('V927', 'Paris', 'Nice', '2027-04-07 20:00:00', '2027-04-07 21:15:00', 4020, 240, 1200),
+('V928', 'Paris', 'Nice', '2028-04-07 20:00:00', '2028-04-07 21:15:00', 4020, 240, 1200),
+('V929', 'Paris', 'Nice', '2029-04-07 20:00:00', '2029-04-07 21:15:00', 4020, 240, 1200),
+('V930', 'Paris', 'Nice', '2030-04-07 20:00:00', '2030-04-07 21:15:00', 4020, 240, 1200),
+('V998', 'Moscou', 'Paris', '2030-04-07 21:40:00', '2001-05-07 00:00:00', 5070, 411, 3000),
+('V999', 'Alger', 'Marseille', '2018-01-09 14:22:01', '2018-01-09 14:22:01', 4090, 660, 1850);
+
+--
+-- Index pour les tables exportées
+--
+
+--
+-- Index pour la table `AVIONS`
+--
+ALTER TABLE `AVIONS`
+ ADD PRIMARY KEY (`NumAv`);
+
+--
+-- Index pour la table `CLIENTS`
+--
+ALTER TABLE `CLIENTS`
+ ADD PRIMARY KEY (`NumCl`),
+ ADD UNIQUE KEY `EmailCI` (`EmailCl`);
+
+--
+-- Index pour la table `DEFCLASSES`
+--
+ALTER TABLE `DEFCLASSES`
+ ADD PRIMARY KEY (`NumVol`,`Classe`);
+
+--
+-- Index pour la table `PILOTES`
+--
+ALTER TABLE `PILOTES`
+ ADD PRIMARY KEY (`NumPil`);
+
+--
+-- Index pour la table `RESERVATIONS`
+--
+ALTER TABLE `RESERVATIONS`
+ ADD PRIMARY KEY (`NumCl`,`NumVol`,`Classe`),
+ ADD KEY `classe_ref_reserv` (`NumVol`,`Classe`);
+
+--
+-- Index pour la table `VOLS`
+--
+ALTER TABLE `VOLS`
+ ADD PRIMARY KEY (`NumVol`),
+ ADD KEY `pil_ref_vol` (`NumPil`),
+ ADD KEY `avion_ref_vol` (`NumAv`);
+
+--
+-- AUTO_INCREMENT pour les tables exportées
+--
+
+--
+-- AUTO_INCREMENT pour la table `CLIENTS`
+--
+ALTER TABLE `CLIENTS`
+ MODIFY `NumCl` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1038;
+--
+-- AUTO_INCREMENT pour la table `PILOTES`
+--
+ALTER TABLE `PILOTES`
+ MODIFY `NumPil` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5457;
+--
+-- Contraintes pour les tables exportées
+--
+
+--
+-- Contraintes pour la table `DEFCLASSES`
+--
+ALTER TABLE `DEFCLASSES`
+ ADD CONSTRAINT `vol_ref_defclasse` FOREIGN KEY (`NumVol`) REFERENCES `VOLS` (`NumVol`);
+
+--
+-- Contraintes pour la table `RESERVATIONS`
+--
+ALTER TABLE `RESERVATIONS`
+ ADD CONSTRAINT `classe_ref_reserv` FOREIGN KEY (`NumVol`,`Classe`) REFERENCES `DEFCLASSES` (`NumVol`, `Classe`),
+ ADD CONSTRAINT `client_ref_reserv` FOREIGN KEY (`NumCl`) REFERENCES `CLIENTS` (`NumCl`);
+
+--
+-- Contraintes pour la table `VOLS`
+--
+ALTER TABLE `VOLS`
+ ADD CONSTRAINT `avion_ref_vol` FOREIGN KEY (`NumAv`) REFERENCES `AVIONS` (`NumAv`),
+ ADD CONSTRAINT `pil_ref_vol` FOREIGN KEY (`NumPil`) REFERENCES `PILOTES` (`NumPil`);
+
+/*!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 */;
repositories / Project_webapp.git / commitdiff
