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