bdVols.sql

   1 -- phpMyAdmin SQL Dump
   2 -- version 4.5.4.1deb2ubuntu2
   3 -- http://www.phpmyadmin.net
   4 --
   5 -- Client :  localhost
   6 -- Généré le :  Dim 21 Janvier 2018 à 23:17
   7 -- Version du serveur :  5.7.20-0ubuntu0.16.04.1
   8 -- Version de PHP :  7.0.22-0ubuntu0.16.04.1
   9
  10 SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  11 SET time_zone = "+00:00";
  12
  13
  14 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  15 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  16 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  17 /*!40101 SET NAMES utf8mb4 */;
  18
  19 --
  20 -- Base de données :  `bdVols`
  21 --
  22
  23 -- --------------------------------------------------------
  24
  25 --
  26 -- Structure de la table `AVIONS`
  27 --
  28
  29 DROP TABLE IF EXISTS `AVIONS`;
  30 CREATE TABLE `AVIONS` (
  31   `NumAv` int(11) NOT NULL,
  32   `NomAv` varchar(20) DEFAULT NULL,
  33   `CapAv` int(11) DEFAULT NULL,
  34   `VilleAv` varchar(15) DEFAULT NULL
  35 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  36
  37 --
  38 -- Contenu de la table `AVIONS`
  39 --
  40
  41 INSERT INTO `AVIONS` (`NumAv`, `NomAv`, `CapAv`, `VilleAv`) VALUES
  42 (101, 'Boeing 707', 350, 'Beyrouth'),
  43 (122, 'Falcon 900', 40, 'Avignon'),
  44 (140, 'Boeing 727', 150, 'Strasbourg'),
  45 (202, 'Falcon 900', 30, 'Nice'),
  46 (205, 'Boeing 747', 350, 'Metz'),
  47 (207, 'Boeing 737', 350, 'Nimes'),
  48 (210, 'Dc10', 200, 'Nantes'),
  49 (220, 'Concorde', 100, 'New York'),
  50 (225, 'Tupolev', 150, 'Pekin'),
  51 (240, 'Boeing 737', 300, 'Paris'),
  52 (250, 'Boeing 747', 500, 'Paris'),
  53 (256, 'Boeing 747', 220, 'Paris'),
  54 (269, 'Boeing 737', NULL, 'Paris'),
  55 (311, 'Dc10', 265, 'Ankara'),
  56 (315, 'Airbus A340', 350, 'Marseille'),
  57 (320, 'Falcon 900', NULL, 'Avignon'),
  58 (325, 'Antonov', 500, 'Marseille'),
  59 (401, 'Boeing 727', 150, 'Dijon'),
  60 (411, 'Tupolev', 130, 'Istanbul'),
  61 (415, 'Airbus A330', 350, 'Nice'),
  62 (440, 'Concorde', 100, 'Marseille'),
  63 (511, 'Airbus A320', 280, 'Toulouse'),
  64 (525, 'Airbus A320', 270, 'Paris'),
  65 (535, 'Airbus A330', 370, 'Marseille'),
  66 (560, 'Airbus A320', 250, 'Nice'),
  67 (614, 'Dc20', 255, 'Beyrouth'),
  68 (615, 'Caravelle', 80, 'Alger'),
  69 (620, 'Antonov', 580, 'Moscou'),
  70 (640, 'Boeing 727', 150, 'Nantes'),
  71 (660, 'Dc20', 295, 'Alger'),
  72 (715, 'Airbus A310', 150, 'Ajaccio'),
  73 (720, 'Boeing 727', 150, 'Marseille'),
  74 (722, 'Boeing 737', 350, 'Toulon'),
  75 (801, 'Concorde', NULL, 'Rome'),
  76 (811, 'Caravelle', 380, 'Naples'),
  77 (820, 'Boeing 737', 350, 'Ajaccio'),
  78 (840, 'Boeing 727', 150, 'Montpellier'),
  79 (915, 'Airbus A340', 350, 'Nice');
  80
  81 -- --------------------------------------------------------
  82
  83 --
  84 -- Structure de la table `CLIENTS`
  85 --
  86
  87 DROP TABLE IF EXISTS `CLIENTS`;
  88 CREATE TABLE `CLIENTS` (
  89   `NumCl` int(11) NOT NULL,
  90   `NomCl` varchar(25) DEFAULT NULL,
  91   `PrenomCl` varchar(25) DEFAULT NULL,
  92   `EmailCl` varchar(50) DEFAULT NULL,
  93   `PasswordCl` varchar(255) DEFAULT NULL,
  94   `NumRueCl` smallint(6) DEFAULT NULL,
  95   `NomRueCl` varchar(50) DEFAULT NULL,
  96   `CodePosteCl` int(11) DEFAULT NULL,
  97   `VilleCl` varchar(15) DEFAULT NULL
  98 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  99
 100 --
 101 -- Contenu de la table `CLIENTS`
 102 --
 103
 104 INSERT INTO `CLIENTS` (`NumCl`, `NomCl`, `PrenomCl`, `EmailCl`, `PasswordCl`, `NumRueCl`, `NomRueCl`, `CodePosteCl`, `VilleCl`) VALUES
 105 (1001, 'Becquerel', 'StÃ©phanie', 'becky@gmail.com', '$2y$10$QY47TLe3nGBtuDqjLQfjD.8JNzha8oYPDhu3a31SRrbhRlULcdDdm', 24, 'Rue De Fabre', 13015, 'Marseille'),
 106 (1002, 'Curie', NULL, 'curie@gmail.com', '$2y$10$QY47TLe3nGBtuDqjLQfjD.8JNzha8oYPDhu3a31SRrbhRlULcdDdm', 1, 'Rue De Rome', 87031, 'Limoges'),
 107 (1036, 'Benoit', 'JÃ©rÃ´me', 'jerome.benoit@piment-noir.org', '$2y$10$zcWP.9OOCK7NaHt/NztWeugvTv7csLh80yj5sN7v84NPWJddpX4Vq', 50, 'Rue de la paix', 13012, 'Marseille'),
 108 (1037, 'Benoit', 'JÃ©rÃ´me', 'jerome.benoit@grenouille.com', '$2y$10$pYc3FsoXE2sKdgGObsn1IujRoamGX7l7pL5h.pSAmXYTOqRkWXJGO', 35, 'Rue de la paix Marcel Paul', 13001, 'Marseille');
 109
 110 -- --------------------------------------------------------
 111
 112 --
 113 -- Structure de la table `DEFCLASSES`
 114 --
 115
 116 DROP TABLE IF EXISTS `DEFCLASSES`;
 117 CREATE TABLE `DEFCLASSES` (
 118   `NumVol` varchar(5) NOT NULL,
 119   `Classe` varchar(12) NOT NULL,
 120   `CoeffPlace` float NOT NULL,
 121   `CoeffPrix` float DEFAULT NULL
 122 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 123
 124 --
 125 -- Contenu de la table `DEFCLASSES`
 126 --
 127
 128 INSERT INTO `DEFCLASSES` (`NumVol`, `Classe`, `CoeffPlace`, `CoeffPrix`) VALUES
 129 ('V1000', 'Economique', 0.5, 1),
 130 ('V1000', 'Touriste', 0.3, 1.4),
 131 ('V1001', 'Economique', 0.5, 1),
 132 ('V1001', 'Touriste', 0.3, 1.4),
 133 ('V1002', 'Economique', 0.5, 1),
 134 ('V1002', 'Touriste', 0.3, 1.4),
 135 ('V101', 'Business', 0.2, 1.8),
 136 ('V101', 'Economique', 0.5, 1),
 137 ('V101', 'Touriste', 0.3, 1.4),
 138 ('V102', 'Business', 0.2, 1.8),
 139 ('V102', 'Economique', 0.5, 1),
 140 ('V102', 'Touriste', 0.3, 1.4),
 141 ('V103', 'Business', 0.2, 1.8),
 142 ('V103', 'Economique', 0.5, 1),
 143 ('V103', 'Touriste', 0.3, 1.4),
 144 ('V104', 'Business', 0.2, 1.8),
 145 ('V104', 'Economique', 0.5, 1),
 146 ('V104', 'Touriste', 0.3, 1.4),
 147 ('V105', 'Business', 0.2, 1.8),
 148 ('V105', 'Economique', 0.5, 1),
 149 ('V105', 'Touriste', 0.3, 1.4),
 150 ('V106', 'Business', 0.2, 1.8),
 151 ('V106', 'Economique', 0.5, 1),
 152 ('V106', 'Touriste', 0.3, 1.4),
 153 ('V107', 'Business', 0.2, 1.8),
 154 ('V107', 'Economique', 0.5, 1),
 155 ('V107', 'Touriste', 0.3, 1.4),
 156 ('V108', 'Business', 0.2, 1.8),
 157 ('V108', 'Economique', 0.5, 1),
 158 ('V108', 'Touriste', 0.3, 1.4),
 159 ('V109', 'Business', 0.2, 1.8),
 160 ('V109', 'Economique', 0.5, 1),
 161 ('V109', 'Touriste', 0.3, 1.4),
 162 ('V110', 'Business', 0.2, 1.8),
 163 ('V110', 'Economique', 0.5, 1),
 164 ('V110', 'Touriste', 0.3, 1.4),
 165 ('V111', 'Business', 0.2, 1.8),
 166 ('V111', 'Economique', 0.5, 1),
 167 ('V111', 'Touriste', 0.3, 1.4),
 168 ('V112', 'Business', 0.2, 1.8),
 169 ('V112', 'Economique', 0.5, 1),
 170 ('V112', 'Touriste', 0.3, 1.4),
 171 ('V113', 'Business', 0.2, 1.8),
 172 ('V113', 'Economique', 0.5, 1),
 173 ('V113', 'Touriste', 0.3, 1.4),
 174 ('V114', 'Business', 0.2, 1.8),
 175 ('V114', 'Economique', 0.5, 1),
 176 ('V114', 'Touriste', 0.3, 1.4),
 177 ('V115', 'Business', 0.2, 1.8),
 178 ('V115', 'Economique', 0.5, 1),
 179 ('V115', 'Touriste', 0.3, 1.4),
 180 ('V116', 'Business', 0.2, 1.8),
 181 ('V116', 'Economique', 0.5, 1),
 182 ('V116', 'Touriste', 0.3, 1.4),
 183 ('V117', 'Business', 0.2, 1.8),
 184 ('V117', 'Economique', 0.5, 1),
 185 ('V117', 'Touriste', 0.3, 1.4),
 186 ('V118', 'Business', 0.2, 1.8),
 187 ('V118', 'Economique', 0.5, 1),
 188 ('V118', 'Touriste', 0.3, 1.4),
 189 ('V119', 'Business', 0.2, 1.8),
 190 ('V119', 'Economique', 0.5, 1),
 191 ('V119', 'Touriste', 0.3, 1.4),
 192 ('V120', 'Business', 0.2, 1.8),
 193 ('V120', 'Economique', 0.5, 1),
 194 ('V120', 'Touriste', 0.3, 1.4),
 195 ('V131', 'Business', 0.2, 1.8),
 196 ('V131', 'Economique', 0.5, 1),
 197 ('V131', 'Touriste', 0.3, 1.4),
 198 ('V141', 'Business', 0.3, 1.8),
 199 ('V141', 'Economique', 0.4, 1),
 200 ('V141', 'Touriste', 0.3, 1.4),
 201 ('V142', 'Business', 0.3, 1.8),
 202 ('V142', 'Economique', 0.4, 1),
 203 ('V142', 'Touriste', 0.3, 1.4),
 204 ('V143', 'Business', 0.3, 1.8),
 205 ('V143', 'Economique', 0.4, 1),
 206 ('V143', 'Touriste', 0.3, 1.4),
 207 ('V144', 'Business', 0.3, 1.8),
 208 ('V144', 'Economique', 0.4, 1),
 209 ('V144', 'Touriste', 0.3, 1.4),
 210 ('V145', 'Business', 0.3, 1.8),
 211 ('V145', 'Economique', 0.4, 1),
 212 ('V145', 'Touriste', 0.3, 1.4),
 213 ('V146', 'Business', 0.3, 1.8),
 214 ('V146', 'Economique', 0.4, 1),
 215 ('V146', 'Touriste', 0.3, 1.4),
 216 ('V147', 'Business', 0.3, 1.8),
 217 ('V147', 'Economique', 0.4, 1),
 218 ('V147', 'Touriste', 0.3, 1.4),
 219 ('V148', 'Business', 0.3, 1.8),
 220 ('V148', 'Economique', 0.4, 1),
 221 ('V148', 'Touriste', 0.3, 1.4),
 222 ('V149', 'Business', 0.3, 1.8),
 223 ('V149', 'Economique', 0.4, 1),
 224 ('V149', 'Touriste', 0.3, 1.4),
 225 ('V150', 'Business', 0.3, 1.8),
 226 ('V150', 'Economique', 0.4, 1),
 227 ('V150', 'Touriste', 0.3, 1.4),
 228 ('V151', 'Business', 0.3, 1.8),
 229 ('V151', 'Economique', 0.4, 1),
 230 ('V151', 'Touriste', 0.3, 1.4),
 231 ('V152', 'Business', 0.3, 1.8),
 232 ('V152', 'Economique', 0.4, 1),
 233 ('V152', 'Touriste', 0.3, 1.4),
 234 ('V153', 'Business', 0.3, 1.8),
 235 ('V153', 'Economique', 0.4, 1),
 236 ('V153', 'Touriste', 0.3, 1.4),
 237 ('V154', 'Business', 0.3, 1.8),
 238 ('V154', 'Economique', 0.4, 1),
 239 ('V154', 'Touriste', 0.3, 1.4),
 240 ('V155', 'Business', 0.3, 1.8),
 241 ('V155', 'Economique', 0.4, 1),
 242 ('V155', 'Touriste', 0.3, 1.4),
 243 ('V156', 'Business', 0.3, 1.8),
 244 ('V156', 'Economique', 0.4, 1),
 245 ('V156', 'Touriste', 0.3, 1.4),
 246 ('V157', 'Business', 0.3, 1.8),
 247 ('V157', 'Economique', 0.4, 1),
 248 ('V157', 'Touriste', 0.3, 1.4),
 249 ('V180', 'Economique', 0.5, 1),
 250 ('V180', 'Touriste', 0.5, 1.4),
 251 ('V181', 'Economique', 0.5, 1),
 252 ('V181', 'Touriste', 0.5, 1.4),
 253 ('V182', 'Economique', 0.5, 1),
 254 ('V182', 'Touriste', 0.5, 1.4),
 255 ('V183', 'Economique', 0.5, 1),
 256 ('V183', 'Touriste', 0.5, 1.4),
 257 ('V184', 'Economique', 0.5, 1),
 258 ('V184', 'Touriste', 0.5, 1.4),
 259 ('V185', 'Economique', 0.5, 1),
 260 ('V185', 'Touriste', 0.5, 1.4),
 261 ('V186', 'Economique', 0.5, 1),
 262 ('V186', 'Touriste', 0.5, 1.4),
 263 ('V187', 'Economique', 0.5, 1),
 264 ('V187', 'Touriste', 0.5, 1.4),
 265 ('V188', 'Economique', 0.5, 1),
 266 ('V188', 'Touriste', 0.5, 1.4),
 267 ('V189', 'Economique', 0.5, 1),
 268 ('V189', 'Touriste', 0.5, 1.4),
 269 ('V190', 'Economique', 0.5, 1),
 270 ('V190', 'Touriste', 0.5, 1.4),
 271 ('V191', 'Economique', 0.5, 1),
 272 ('V191', 'Touriste', 0.5, 1.4),
 273 ('V192', 'Economique', 0.5, 1),
 274 ('V192', 'Touriste', 0.5, 1.4),
 275 ('V193', 'Economique', 0.5, 1),
 276 ('V193', 'Touriste', 0.5, 1.4),
 277 ('V194', 'Economique', 0.5, 1),
 278 ('V194', 'Touriste', 0.5, 1.4),
 279 ('V195', 'Economique', 0.5, 1),
 280 ('V195', 'Touriste', 0.5, 1.4),
 281 ('V196', 'Economique', 0.5, 1),
 282 ('V196', 'Touriste', 0.5, 1.4),
 283 ('V197', 'Economique', 0.5, 1),
 284 ('V197', 'Touriste', 0.5, 1.4),
 285 ('V198', 'Economique', 0.5, 1),
 286 ('V198', 'Touriste', 0.5, 1.4),
 287 ('V199', 'Economique', 0.5, 1),
 288 ('V199', 'Touriste', 0.5, 1.4),
 289 ('V200', 'Economique', 0.5, 1),
 290 ('V200', 'Touriste', 0.5, 1.4),
 291 ('V210', 'Business', 0.2, 1.8),
 292 ('V210', 'Economique', 0.5, 1),
 293 ('V210', 'Touriste', 0.3, 1.4),
 294 ('V211', 'Business', 0.2, 1.8),
 295 ('V211', 'Economique', 0.5, 1),
 296 ('V211', 'Touriste', 0.3, 1.4),
 297 ('V212', 'Business', 0.2, 1.8),
 298 ('V212', 'Economique', 0.5, 1),
 299 ('V212', 'Touriste', 0.3, 1.4),
 300 ('V213', 'Business', 0.2, 1.8),
 301 ('V213', 'Economique', 0.5, 1),
 302 ('V213', 'Touriste', 0.3, 1.4),
 303 ('V214', 'Business', 0.2, 1.8),
 304 ('V214', 'Economique', 0.5, 1),
 305 ('V214', 'Touriste', 0.3, 1.4),
 306 ('V215', 'Business', 0.2, 1.8),
 307 ('V215', 'Economique', 0.5, 1),
 308 ('V215', 'Touriste', 0.3, 1.4),
 309 ('V216', 'Business', 0.2, 1.8),
 310 ('V216', 'Economique', 0.5, 1),
 311 ('V216', 'Touriste', 0.3, 1.4),
 312 ('V217', 'Business', 0.2, 1.8),
 313 ('V217', 'Economique', 0.5, 1),
 314 ('V217', 'Touriste', 0.3, 1.4),
 315 ('V218', 'Business', 0.2, 1.8),
 316 ('V218', 'Economique', 0.5, 1),
 317 ('V218', 'Touriste', 0.3, 1.4),
 318 ('V219', 'Business', 0.2, 1.8),
 319 ('V219', 'Economique', 0.5, 1),
 320 ('V219', 'Touriste', 0.3, 1.4),
 321 ('V220', 'Business', 0.2, 1.8),
 322 ('V220', 'Economique', 0.5, 1),
 323 ('V220', 'Touriste', 0.3, 1.4),
 324 ('V221', 'Business', 0.2, 1.8),
 325 ('V221', 'Economique', 0.5, 1),
 326 ('V221', 'Touriste', 0.3, 1.4),
 327 ('V222', 'Business', 0.2, 1.8),
 328 ('V222', 'Economique', 0.5, 1),
 329 ('V222', 'Touriste', 0.3, 1.4),
 330 ('V223', 'Business', 0.2, 1.8),
 331 ('V223', 'Economique', 0.5, 1),
 332 ('V223', 'Touriste', 0.3, 1.4),
 333 ('V224', 'Business', 0.2, 1.8),
 334 ('V224', 'Economique', 0.5, 1),
 335 ('V224', 'Touriste', 0.3, 1.4),
 336 ('V240', 'Business', 0.2, 1.8),
 337 ('V240', 'Economique', 0.5, 1),
 338 ('V240', 'Touriste', 0.3, 1.4),
 339 ('V265', 'Business', 0.2, 1.8),
 340 ('V265', 'Economique', 0.5, 1),
 341 ('V265', 'Touriste', 0.3, 1.4),
 342 ('V341', 'Business', 0.2, 1.8),
 343 ('V341', 'Economique', 0.5, 1),
 344 ('V341', 'Touriste', 0.3, 1.4),
 345 ('V342', 'Business', 0.2, 1.8),
 346 ('V342', 'Economique', 0.5, 1),
 347 ('V342', 'Touriste', 0.3, 1.4),
 348 ('V343', 'Business', 0.2, 1.8),
 349 ('V343', 'Economique', 0.5, 1),
 350 ('V343', 'Touriste', 0.3, 1.4),
 351 ('V344', 'Business', 0.2, 1.8),
 352 ('V344', 'Economique', 0.5, 1),
 353 ('V344', 'Touriste', 0.3, 1.4),
 354 ('V345', 'Business', 0.2, 1.8),
 355 ('V345', 'Economique', 0.5, 1),
 356 ('V345', 'Touriste', 0.3, 1.4),
 357 ('V346', 'Business', 0.2, 1.8),
 358 ('V346', 'Economique', 0.5, 1),
 359 ('V346', 'Touriste', 0.3, 1.4),
 360 ('V347', 'Business', 0.2, 1.8),
 361 ('V347', 'Economique', 0.5, 1),
 362 ('V347', 'Touriste', 0.3, 1.4),
 363 ('V348', 'Business', 0.2, 1.8),
 364 ('V348', 'Economique', 0.5, 1),
 365 ('V348', 'Touriste', 0.3, 1.4),
 366 ('V349', 'Business', 0.2, 1.8),
 367 ('V349', 'Economique', 0.5, 1),
 368 ('V349', 'Touriste', 0.3, 1.4),
 369 ('V350', 'Business', 0.2, 1.8),
 370 ('V350', 'Economique', 0.5, 1),
 371 ('V350', 'Touriste', 0.3, 1.4),
 372 ('V351', 'Business', 0.2, 1.8),
 373 ('V351', 'Economique', 0.5, 1),
 374 ('V351', 'Touriste', 0.3, 1.4),
 375 ('V352', 'Business', 0.2, 1.8),
 376 ('V352', 'Economique', 0.5, 1),
 377 ('V352', 'Touriste', 0.3, 1.4),
 378 ('V353', 'Business', 0.2, 1.8),
 379 ('V353', 'Economique', 0.5, 1),
 380 ('V353', 'Touriste', 0.3, 1.4),
 381 ('V354', 'Business', 0.2, 1.8),
 382 ('V354', 'Economique', 0.5, 1),
 383 ('V354', 'Touriste', 0.3, 1.4),
 384 ('V355', 'Business', 0.2, 1.8),
 385 ('V355', 'Economique', 0.5, 1),
 386 ('V355', 'Touriste', 0.3, 1.4),
 387 ('V356', 'Business', 0.2, 1.8),
 388 ('V356', 'Economique', 0.5, 1),
 389 ('V356', 'Touriste', 0.3, 1.4),
 390 ('V357', 'Business', 0.2, 1.8),
 391 ('V357', 'Economique', 0.5, 1),
 392 ('V357', 'Touriste', 0.3, 1.4),
 393 ('V358', 'Business', 0.2, 1.8),
 394 ('V358', 'Economique', 0.5, 1),
 395 ('V358', 'Touriste', 0.3, 1.4),
 396 ('V359', 'Business', 0.2, 1.8),
 397 ('V359', 'Economique', 0.5, 1),
 398 ('V359', 'Touriste', 0.3, 1.4),
 399 ('V360', 'Business', 0.2, 1.8),
 400 ('V360', 'Economique', 0.5, 1),
 401 ('V360', 'Touriste', 0.3, 1.4),
 402 ('V361', 'Business', 0.2, 1.8),
 403 ('V361', 'Economique', 0.5, 1),
 404 ('V361', 'Touriste', 0.3, 1.4),
 405 ('V362', 'Business', 0.2, 1.8),
 406 ('V362', 'Economique', 0.5, 1),
 407 ('V362', 'Touriste', 0.3, 1.4),
 408 ('V363', 'Business', 0.2, 1.8),
 409 ('V363', 'Economique', 0.5, 1),
 410 ('V363', 'Touriste', 0.3, 1.4),
 411 ('V364', 'Business', 0.2, 1.8),
 412 ('V364', 'Economique', 0.5, 1),
 413 ('V364', 'Touriste', 0.3, 1.4),
 414 ('V365', 'Business', 0.2, 1.8),
 415 ('V365', 'Economique', 0.5, 1),
 416 ('V365', 'Touriste', 0.3, 1.4),
 417 ('V366', 'Business', 0.2, 1.8),
 418 ('V366', 'Economique', 0.5, 1),
 419 ('V366', 'Touriste', 0.3, 1.4),
 420 ('V367', 'Business', 0.2, 1.8),
 421 ('V367', 'Economique', 0.5, 1),
 422 ('V367', 'Touriste', 0.3, 1.4),
 423 ('V368', 'Business', 0.2, 1.8),
 424 ('V368', 'Economique', 0.5, 1),
 425 ('V368', 'Touriste', 0.3, 1.4),
 426 ('V369', 'Business', 0.2, 1.8),
 427 ('V369', 'Economique', 0.5, 1),
 428 ('V369', 'Touriste', 0.3, 1.4),
 429 ('V370', 'Business', 0.2, 1.8),
 430 ('V370', 'Economique', 0.5, 1),
 431 ('V370', 'Touriste', 0.3, 1.4),
 432 ('V420', 'Business', 0.2, 1.8),
 433 ('V420', 'Economique', 0.5, 1),
 434 ('V420', 'Touriste', 0.3, 1.4),
 435 ('V431', 'Business', 0.2, 1.8),
 436 ('V431', 'Economique', 0.5, 1),
 437 ('V431', 'Touriste', 0.3, 1.4),
 438 ('V490', 'Business', 0.2, 1.8),
 439 ('V490', 'Economique', 0.5, 1),
 440 ('V490', 'Touriste', 0.3, 1.4),
 441 ('V501', 'Business', 0.2, 1.8),
 442 ('V501', 'Economique', 0.5, 1),
 443 ('V501', 'Touriste', 0.3, 1.4),
 444 ('V502', 'Business', 0.2, 1.8),
 445 ('V502', 'Economique', 0.5, 1),
 446 ('V502', 'Touriste', 0.3, 1.4),
 447 ('V503', 'Business', 0.2, 1.8),
 448 ('V503', 'Economique', 0.5, 1),
 449 ('V503', 'Touriste', 0.3, 1.4),
 450 ('V504', 'Business', 0.2, 1.8),
 451 ('V504', 'Economique', 0.5, 1),
 452 ('V504', 'Touriste', 0.3, 1.4),
 453 ('V505', 'Business', 0.2, 1.8),
 454 ('V505', 'Economique', 0.5, 1),
 455 ('V505', 'Touriste', 0.3, 1.4),
 456 ('V506', 'Business', 0.2, 1.8),
 457 ('V506', 'Economique', 0.5, 1),
 458 ('V506', 'Touriste', 0.3, 1.4),
 459 ('V507', 'Business', 0.2, 1.8),
 460 ('V507', 'Economique', 0.5, 1),
 461 ('V507', 'Touriste', 0.3, 1.4),
 462 ('V508', 'Business', 0.2, 1.8),
 463 ('V508', 'Economique', 0.5, 1),
 464 ('V508', 'Touriste', 0.3, 1.4),
 465 ('V509', 'Business', 0.2, 1.8),
 466 ('V509', 'Economique', 0.5, 1),
 467 ('V509', 'Touriste', 0.3, 1.4),
 468 ('V510', 'Business', 0.2, 1.8),
 469 ('V510', 'Economique', 0.5, 1),
 470 ('V510', 'Touriste', 0.3, 1.4),
 471 ('V511', 'Business', 0.2, 1.8),
 472 ('V511', 'Economique', 0.5, 1),
 473 ('V511', 'Touriste', 0.3, 1.4),
 474 ('V512', 'Business', 0.2, 1.8),
 475 ('V512', 'Economique', 0.5, 1),
 476 ('V512', 'Touriste', 0.3, 1.4),
 477 ('V513', 'Business', 0.2, 1.8),
 478 ('V513', 'Economique', 0.5, 1),
 479 ('V513', 'Touriste', 0.3, 1.4),
 480 ('V514', 'Business', 0.2, 1.8),
 481 ('V514', 'Economique', 0.5, 1),
 482 ('V514', 'Touriste', 0.3, 1.4),
 483 ('V515', 'Business', 0.2, 1.8),
 484 ('V515', 'Economique', 0.5, 1),
 485 ('V515', 'Touriste', 0.3, 1.4),
 486 ('V516', 'Business', 0.2, 1.8),
 487 ('V516', 'Economique', 0.5, 1),
 488 ('V516', 'Touriste', 0.3, 1.4),
 489 ('V517', 'Business', 0.2, 1.8),
 490 ('V517', 'Economique', 0.5, 1),
 491 ('V517', 'Touriste', 0.3, 1.4),
 492 ('V518', 'Business', 0.2, 1.8),
 493 ('V518', 'Economique', 0.5, 1),
 494 ('V518', 'Touriste', 0.3, 1.4),
 495 ('V519', 'Business', 0.2, 1.8),
 496 ('V519', 'Economique', 0.5, 1),
 497 ('V519', 'Touriste', 0.3, 1.4),
 498 ('V520', 'Business', 0.2, 1.8),
 499 ('V520', 'Economique', 0.5, 1),
 500 ('V520', 'Touriste', 0.3, 1.4),
 501 ('V521', 'Business', 0.2, 1.8),
 502 ('V521', 'Economique', 0.5, 1),
 503 ('V521', 'Touriste', 0.3, 1.4),
 504 ('V522', 'Business', 0.2, 1.8),
 505 ('V522', 'Economique', 0.5, 1),
 506 ('V522', 'Touriste', 0.3, 1.4),
 507 ('V523', 'Business', 0.2, 1.8),
 508 ('V523', 'Economique', 0.5, 1),
 509 ('V523', 'Touriste', 0.3, 1.4),
 510 ('V524', 'Business', 0.2, 1.8),
 511 ('V524', 'Economique', 0.5, 1),
 512 ('V524', 'Touriste', 0.3, 1.4),
 513 ('V525', 'Business', 0.2, 1.8),
 514 ('V525', 'Economique', 0.5, 1),
 515 ('V525', 'Touriste', 0.3, 1.4),
 516 ('V526', 'Business', 0.2, 1.8),
 517 ('V526', 'Economique', 0.5, 1),
 518 ('V526', 'Touriste', 0.3, 1.4),
 519 ('V527', 'Business', 0.2, 1.8),
 520 ('V527', 'Economique', 0.5, 1),
 521 ('V527', 'Touriste', 0.3, 1.4),
 522 ('V528', 'Business', 0.2, 1.8),
 523 ('V528', 'Economique', 0.5, 1),
 524 ('V528', 'Touriste', 0.3, 1.4),
 525 ('V529', 'Business', 0.2, 1.8),
 526 ('V529', 'Economique', 0.5, 1),
 527 ('V529', 'Touriste', 0.3, 1.4),
 528 ('V530', 'Business', 0.2, 1.8),
 529 ('V530', 'Economique', 0.5, 1),
 530 ('V530', 'Touriste', 0.3, 1.4),
 531 ('V590', 'Business', 0.2, 1.8),
 532 ('V590', 'Economique', 0.5, 1),
 533 ('V590', 'Touriste', 0.3, 1.4),
 534 ('V601', 'Business', 0.2, 1.8),
 535 ('V601', 'Economique', 0.5, 1),
 536 ('V601', 'Touriste', 0.3, 1.4),
 537 ('V602', 'Business', 0.2, 1.8),
 538 ('V602', 'Economique', 0.5, 1),
 539 ('V602', 'Touriste', 0.3, 1.4),
 540 ('V603', 'Business', 0.2, 1.8),
 541 ('V603', 'Economique', 0.5, 1),
 542 ('V603', 'Touriste', 0.3, 1.4),
 543 ('V604', 'Business', 0.2, 1.8),
 544 ('V604', 'Economique', 0.5, 1),
 545 ('V604', 'Touriste', 0.3, 1.4),
 546 ('V605', 'Business', 0.2, 1.8),
 547 ('V605', 'Economique', 0.5, 1),
 548 ('V605', 'Touriste', 0.3, 1.4),
 549 ('V606', 'Business', 0.2, 1.8),
 550 ('V606', 'Economique', 0.5, 1),
 551 ('V606', 'Touriste', 0.3, 1.4),
 552 ('V607', 'Business', 0.2, 1.8),
 553 ('V607', 'Economique', 0.5, 1),
 554 ('V607', 'Touriste', 0.3, 1.4),
 555 ('V608', 'Business', 0.2, 1.8),
 556 ('V608', 'Economique', 0.5, 1),
 557 ('V608', 'Touriste', 0.3, 1.4),
 558 ('V609', 'Business', 0.2, 1.8),
 559 ('V609', 'Economique', 0.5, 1),
 560 ('V609', 'Touriste', 0.3, 1.4),
 561 ('V610', 'Business', 0.2, 1.8),
 562 ('V610', 'Economique', 0.5, 1),
 563 ('V610', 'Touriste', 0.3, 1.4),
 564 ('V611', 'Business', 0.2, 1.8),
 565 ('V611', 'Economique', 0.5, 1),
 566 ('V611', 'Touriste', 0.3, 1.4),
 567 ('V612', 'Business', 0.2, 1.8),
 568 ('V612', 'Economique', 0.5, 1),
 569 ('V612', 'Touriste', 0.3, 1.4),
 570 ('V613', 'Business', 0.2, 1.8),
 571 ('V613', 'Economique', 0.5, 1),
 572 ('V613', 'Touriste', 0.3, 1.4),
 573 ('V614', 'Business', 0.2, 1.8),
 574 ('V614', 'Economique', 0.5, 1),
 575 ('V614', 'Touriste', 0.3, 1.4),
 576 ('V615', 'Business', 0.2, 1.8),
 577 ('V615', 'Economique', 0.5, 1),
 578 ('V615', 'Touriste', 0.3, 1.4),
 579 ('V616', 'Business', 0.2, 1.8),
 580 ('V616', 'Economique', 0.5, 1),
 581 ('V616', 'Touriste', 0.3, 1.4),
 582 ('V617', 'Business', 0.2, 1.8),
 583 ('V617', 'Economique', 0.5, 1),
 584 ('V617', 'Touriste', 0.3, 1.4),
 585 ('V618', 'Business', 0.2, 1.8),
 586 ('V618', 'Economique', 0.5, 1),
 587 ('V618', 'Touriste', 0.3, 1.4),
 588 ('V619', 'Business', 0.2, 1.8),
 589 ('V619', 'Economique', 0.5, 1),
 590 ('V619', 'Touriste', 0.3, 1.4),
 591 ('V620', 'Business', 0.2, 1.8),
 592 ('V620', 'Economique', 0.5, 1),
 593 ('V620', 'Touriste', 0.3, 1.4),
 594 ('V621', 'Business', 0.2, 1.8),
 595 ('V621', 'Economique', 0.5, 1),
 596 ('V621', 'Touriste', 0.3, 1.4),
 597 ('V622', 'Business', 0.2, 1.8),
 598 ('V622', 'Economique', 0.5, 1),
 599 ('V622', 'Touriste', 0.3, 1.4),
 600 ('V623', 'Business', 0.2, 1.8),
 601 ('V623', 'Economique', 0.5, 1),
 602 ('V623', 'Touriste', 0.3, 1.4),
 603 ('V624', 'Business', 0.2, 1.8),
 604 ('V624', 'Economique', 0.5, 1),
 605 ('V624', 'Touriste', 0.3, 1.4),
 606 ('V625', 'Business', 0.2, 1.8),
 607 ('V625', 'Economique', 0.5, 1),
 608 ('V625', 'Touriste', 0.3, 1.4),
 609 ('V626', 'Business', 0.2, 1.8),
 610 ('V626', 'Economique', 0.5, 1),
 611 ('V626', 'Touriste', 0.3, 1.4),
 612 ('V627', 'Business', 0.2, 1.8),
 613 ('V627', 'Economique', 0.5, 1),
 614 ('V627', 'Touriste', 0.3, 1.4),
 615 ('V628', 'Business', 0.2, 1.8),
 616 ('V628', 'Economique', 0.5, 1),
 617 ('V628', 'Touriste', 0.3, 1.4),
 618 ('V629', 'Business', 0.2, 1.8),
 619 ('V629', 'Economique', 0.5, 1),
 620 ('V629', 'Touriste', 0.3, 1.4),
 621 ('V630', 'Business', 0.2, 1.8),
 622 ('V630', 'Economique', 0.5, 1),
 623 ('V630', 'Touriste', 0.3, 1.4),
 624 ('V641', 'Business', 0.2, 1.8),
 625 ('V641', 'Economique', 0.5, 1),
 626 ('V641', 'Touriste', 0.3, 1.4),
 627 ('V642', 'Business', 0.2, 1.8),
 628 ('V642', 'Economique', 0.5, 1),
 629 ('V642', 'Touriste', 0.3, 1.4),
 630 ('V643', 'Business', 0.2, 1.8),
 631 ('V643', 'Economique', 0.5, 1),
 632 ('V643', 'Touriste', 0.3, 1.4),
 633 ('V644', 'Business', 0.2, 1.8),
 634 ('V644', 'Economique', 0.5, 1),
 635 ('V644', 'Touriste', 0.3, 1.4),
 636 ('V645', 'Business', 0.2, 1.8),
 637 ('V645', 'Economique', 0.5, 1),
 638 ('V645', 'Touriste', 0.3, 1.4),
 639 ('V646', 'Business', 0.2, 1.8),
 640 ('V646', 'Economique', 0.5, 1),
 641 ('V646', 'Touriste', 0.3, 1.4),
 642 ('V647', 'Business', 0.2, 1.8),
 643 ('V647', 'Economique', 0.5, 1),
 644 ('V647', 'Touriste', 0.3, 1.4),
 645 ('V648', 'Business', 0.2, 1.8),
 646 ('V648', 'Economique', 0.5, 1),
 647 ('V648', 'Touriste', 0.3, 1.4),
 648 ('V649', 'Business', 0.2, 1.8),
 649 ('V649', 'Economique', 0.5, 1),
 650 ('V649', 'Touriste', 0.3, 1.4),
 651 ('V650', 'Business', 0.2, 1.8),
 652 ('V650', 'Economique', 0.5, 1),
 653 ('V650', 'Touriste', 0.3, 1.4),
 654 ('V651', 'Business', 0.2, 1.8),
 655 ('V651', 'Economique', 0.5, 1),
 656 ('V651', 'Touriste', 0.3, 1.4),
 657 ('V652', 'Business', 0.2, 1.8),
 658 ('V652', 'Economique', 0.5, 1),
 659 ('V652', 'Touriste', 0.3, 1.4),
 660 ('V653', 'Business', 0.2, 1.8),
 661 ('V653', 'Economique', 0.5, 1),
 662 ('V653', 'Touriste', 0.3, 1.4),
 663 ('V654', 'Business', 0.2, 1.8),
 664 ('V654', 'Economique', 0.5, 1),
 665 ('V654', 'Touriste', 0.3, 1.4),
 666 ('V655', 'Business', 0.2, 1.8),
 667 ('V655', 'Economique', 0.5, 1),
 668 ('V655', 'Touriste', 0.3, 1.4),
 669 ('V656', 'Business', 0.2, 1.8),
 670 ('V656', 'Economique', 0.5, 1),
 671 ('V656', 'Touriste', 0.3, 1.4),
 672 ('V657', 'Business', 0.2, 1.8),
 673 ('V657', 'Economique', 0.5, 1),
 674 ('V657', 'Touriste', 0.3, 1.4),
 675 ('V658', 'Business', 0.2, 1.8),
 676 ('V658', 'Economique', 0.5, 1),
 677 ('V658', 'Touriste', 0.3, 1.4),
 678 ('V659', 'Business', 0.2, 1.8),
 679 ('V659', 'Economique', 0.5, 1),
 680 ('V659', 'Touriste', 0.3, 1.4),
 681 ('V660', 'Business', 0.2, 1.8),
 682 ('V660', 'Economique', 0.5, 1),
 683 ('V660', 'Touriste', 0.3, 1.4),
 684 ('V661', 'Business', 0.2, 1.8),
 685 ('V661', 'Economique', 0.5, 1),
 686 ('V661', 'Touriste', 0.3, 1.4),
 687 ('V662', 'Business', 0.2, 1.8),
 688 ('V662', 'Economique', 0.5, 1),
 689 ('V662', 'Touriste', 0.3, 1.4),
 690 ('V663', 'Business', 0.2, 1.8),
 691 ('V663', 'Economique', 0.5, 1),
 692 ('V663', 'Touriste', 0.3, 1.4),
 693 ('V664', 'Business', 0.2, 1.8),
 694 ('V664', 'Economique', 0.5, 1),
 695 ('V664', 'Touriste', 0.3, 1.4),
 696 ('V665', 'Business', 0.2, 1.8),
 697 ('V665', 'Economique', 0.5, 1),
 698 ('V665', 'Touriste', 0.3, 1.4),
 699 ('V666', 'Business', 0.2, 1.8),
 700 ('V666', 'Economique', 0.5, 1),
 701 ('V666', 'Touriste', 0.3, 1.4),
 702 ('V667', 'Business', 0.2, 1.8),
 703 ('V667', 'Economique', 0.5, 1),
 704 ('V667', 'Touriste', 0.3, 1.4),
 705 ('V668', 'Business', 0.2, 1.8),
 706 ('V668', 'Economique', 0.5, 1),
 707 ('V668', 'Touriste', 0.3, 1.4),
 708 ('V669', 'Business', 0.2, 1.8),
 709 ('V669', 'Economique', 0.5, 1),
 710 ('V669', 'Touriste', 0.3, 1.4),
 711 ('V670', 'Business', 0.2, 1.8),
 712 ('V670', 'Economique', 0.5, 1),
 713 ('V670', 'Touriste', 0.3, 1.4),
 714 ('V681', 'Business', 0.2, 1.8),
 715 ('V681', 'Economique', 0.5, 1),
 716 ('V681', 'Touriste', 0.3, 1.4),
 717 ('V682', 'Business', 0.2, 1.8),
 718 ('V682', 'Economique', 0.5, 1),
 719 ('V682', 'Touriste', 0.3, 1.4),
 720 ('V683', 'Business', 0.2, 1.8),
 721 ('V683', 'Economique', 0.5, 1),
 722 ('V683', 'Touriste', 0.3, 1.4),
 723 ('V684', 'Business', 0.2, 1.8),
 724 ('V684', 'Economique', 0.5, 1),
 725 ('V684', 'Touriste', 0.3, 1.4),
 726 ('V685', 'Business', 0.2, 1.8),
 727 ('V685', 'Economique', 0.5, 1),
 728 ('V685', 'Touriste', 0.3, 1.4),
 729 ('V686', 'Business', 0.2, 1.8),
 730 ('V686', 'Economique', 0.5, 1),
 731 ('V686', 'Touriste', 0.3, 1.4),
 732 ('V687', 'Business', 0.2, 1.8),
 733 ('V687', 'Economique', 0.5, 1),
 734 ('V687', 'Touriste', 0.3, 1.4),
 735 ('V688', 'Business', 0.2, 1.8),
 736 ('V688', 'Economique', 0.5, 1),
 737 ('V688', 'Touriste', 0.3, 1.4),
 738 ('V689', 'Business', 0.2, 1.8),
 739 ('V689', 'Economique', 0.5, 1),
 740 ('V689', 'Touriste', 0.3, 1.4),
 741 ('V690', 'Business', 0.2, 1.8),
 742 ('V690', 'Economique', 0.5, 1),
 743 ('V690', 'Touriste', 0.3, 1.4),
 744 ('V691', 'Business', 0.2, 1.8),
 745 ('V691', 'Economique', 0.5, 1),
 746 ('V691', 'Touriste', 0.3, 1.4),
 747 ('V692', 'Business', 0.2, 1.8),
 748 ('V692', 'Economique', 0.5, 1),
 749 ('V692', 'Touriste', 0.3, 1.4),
 750 ('V693', 'Business', 0.2, 1.8),
 751 ('V693', 'Economique', 0.5, 1),
 752 ('V693', 'Touriste', 0.3, 1.4),
 753 ('V694', 'Business', 0.2, 1.8),
 754 ('V694', 'Economique', 0.5, 1),
 755 ('V694', 'Touriste', 0.3, 1.4),
 756 ('V720', 'Business', 0.2, 1.8),
 757 ('V720', 'Economique', 0.5, 1),
 758 ('V720', 'Touriste', 0.3, 1.4),
 759 ('V787', 'Business', 0.2, 1.8),
 760 ('V787', 'Economique', 0.5, 1),
 761 ('V787', 'Touriste', 0.3, 1.4),
 762 ('V788', 'Business', 0.2, 1.8),
 763 ('V788', 'Economique', 0.5, 1),
 764 ('V788', 'Touriste', 0.3, 1.4),
 765 ('V789', 'Business', 0.2, 1.8),
 766 ('V789', 'Economique', 0.5, 1),
 767 ('V789', 'Touriste', 0.3, 1.4),
 768 ('V790', 'Business', 0.2, 1.8),
 769 ('V790', 'Economique', 0.5, 1),
 770 ('V790', 'Touriste', 0.3, 1.4),
 771 ('V791', 'Business', 0.2, 1.8),
 772 ('V791', 'Economique', 0.5, 1),
 773 ('V791', 'Touriste', 0.3, 1.4),
 774 ('V804', 'Business', 0.2, 1.8),
 775 ('V804', 'Economique', 0.5, 1),
 776 ('V804', 'Touriste', 0.3, 1.4),
 777 ('V805', 'Business', 0.2, 1.8),
 778 ('V805', 'Economique', 0.5, 1),
 779 ('V805', 'Touriste', 0.3, 1.4),
 780 ('V806', 'Business', 0.2, 1.8),
 781 ('V806', 'Economique', 0.5, 1),
 782 ('V806', 'Touriste', 0.3, 1.4),
 783 ('V807', 'Business', 0.2, 1.8),
 784 ('V807', 'Economique', 0.5, 1),
 785 ('V807', 'Touriste', 0.3, 1.4),
 786 ('V808', 'Business', 0.2, 1.8),
 787 ('V808', 'Economique', 0.5, 1),
 788 ('V808', 'Touriste', 0.3, 1.4),
 789 ('V809', 'Business', 0.2, 1.8),
 790 ('V809', 'Economique', 0.5, 1),
 791 ('V809', 'Touriste', 0.3, 1.4),
 792 ('V882', 'Business', 0.2, 1.8),
 793 ('V882', 'Economique', 0.5, 1),
 794 ('V882', 'Touriste', 0.3, 1.4),
 795 ('V883', 'Business', 0.2, 1.8),
 796 ('V883', 'Economique', 0.5, 1),
 797 ('V883', 'Touriste', 0.3, 1.4),
 798 ('V884', 'Business', 0.2, 1.8),
 799 ('V884', 'Economique', 0.5, 1),
 800 ('V884', 'Touriste', 0.3, 1.4),
 801 ('V885', 'Business', 0.2, 1.8),
 802 ('V885', 'Economique', 0.5, 1),
 803 ('V885', 'Touriste', 0.3, 1.4),
 804 ('V886', 'Business', 0.2, 1.8),
 805 ('V886', 'Economique', 0.5, 1),
 806 ('V886', 'Touriste', 0.3, 1.4),
 807 ('V887', 'Business', 0.2, 1.8),
 808 ('V887', 'Economique', 0.5, 1),
 809 ('V887', 'Touriste', 0.3, 1.4),
 810 ('V888', 'Business', 0.2, 1.8),
 811 ('V888', 'Economique', 0.5, 1),
 812 ('V888', 'Touriste', 0.3, 1.4),
 813 ('V889', 'Business', 0.2, 1.8),
 814 ('V889', 'Economique', 0.5, 1),
 815 ('V889', 'Touriste', 0.3, 1.4),
 816 ('V890', 'Business', 0.2, 1.8),
 817 ('V890', 'Economique', 0.5, 1),
 818 ('V890', 'Touriste', 0.3, 1.4),
 819 ('V901', 'Business', 0.2, 1.8),
 820 ('V901', 'Economique', 0.5, 1),
 821 ('V901', 'Touriste', 0.3, 1.4),
 822 ('V902', 'Business', 0.2, 1.8),
 823 ('V902', 'Economique', 0.5, 1),
 824 ('V902', 'Touriste', 0.3, 1.4),
 825 ('V903', 'Business', 0.2, 1.8),
 826 ('V903', 'Economique', 0.5, 1),
 827 ('V903', 'Touriste', 0.3, 1.4),
 828 ('V904', 'Business', 0.2, 1.8),
 829 ('V904', 'Economique', 0.5, 1),
 830 ('V904', 'Touriste', 0.3, 1.4),
 831 ('V905', 'Business', 0.2, 1.8),
 832 ('V905', 'Economique', 0.5, 1),
 833 ('V905', 'Touriste', 0.3, 1.4),
 834 ('V906', 'Business', 0.2, 1.8),
 835 ('V906', 'Economique', 0.5, 1),
 836 ('V906', 'Touriste', 0.3, 1.4),
 837 ('V907', 'Business', 0.2, 1.8),
 838 ('V907', 'Economique', 0.5, 1),
 839 ('V907', 'Touriste', 0.3, 1.4),
 840 ('V908', 'Business', 0.2, 1.8),
 841 ('V908', 'Economique', 0.5, 1),
 842 ('V908', 'Touriste', 0.3, 1.4),
 843 ('V909', 'Business', 0.2, 1.8),
 844 ('V909', 'Economique', 0.5, 1),
 845 ('V909', 'Touriste', 0.3, 1.4),
 846 ('V910', 'Business', 0.2, 1.8),
 847 ('V910', 'Economique', 0.5, 1),
 848 ('V910', 'Touriste', 0.3, 1.4),
 849 ('V911', 'Business', 0.2, 1.8),
 850 ('V911', 'Economique', 0.5, 1),
 851 ('V911', 'Touriste', 0.3, 1.4),
 852 ('V912', 'Business', 0.2, 1.8),
 853 ('V912', 'Economique', 0.5, 1),
 854 ('V912', 'Touriste', 0.3, 1.4),
 855 ('V913', 'Business', 0.2, 1.8),
 856 ('V913', 'Economique', 0.5, 1),
 857 ('V913', 'Touriste', 0.3, 1.4),
 858 ('V914', 'Business', 0.2, 1.8),
 859 ('V914', 'Economique', 0.5, 1),
 860 ('V914', 'Touriste', 0.3, 1.4),
 861 ('V915', 'Business', 0.2, 1.8),
 862 ('V915', 'Economique', 0.5, 1),
 863 ('V915', 'Touriste', 0.3, 1.4),
 864 ('V916', 'Business', 0.2, 1.8),
 865 ('V916', 'Economique', 0.5, 1),
 866 ('V916', 'Touriste', 0.3, 1.4),
 867 ('V917', 'Business', 0.2, 1.8),
 868 ('V917', 'Economique', 0.5, 1),
 869 ('V917', 'Touriste', 0.3, 1.4),
 870 ('V918', 'Business', 0.2, 1.8),
 871 ('V918', 'Economique', 0.5, 1),
 872 ('V918', 'Touriste', 0.3, 1.4),
 873 ('V919', 'Business', 0.2, 1.8),
 874 ('V919', 'Economique', 0.5, 1),
 875 ('V919', 'Touriste', 0.3, 1.4),
 876 ('V920', 'Business', 0.2, 1.8),
 877 ('V920', 'Economique', 0.5, 1),
 878 ('V920', 'Touriste', 0.3, 1.4),
 879 ('V921', 'Business', 0.2, 1.8),
 880 ('V921', 'Economique', 0.5, 1),
 881 ('V921', 'Touriste', 0.3, 1.4),
 882 ('V922', 'Business', 0.2, 1.8),
 883 ('V922', 'Economique', 0.5, 1),
 884 ('V922', 'Touriste', 0.3, 1.4),
 885 ('V923', 'Business', 0.2, 1.8),
 886 ('V923', 'Economique', 0.5, 1),
 887 ('V923', 'Touriste', 0.3, 1.4),
 888 ('V924', 'Business', 0.2, 1.8),
 889 ('V924', 'Economique', 0.5, 1),
 890 ('V924', 'Touriste', 0.3, 1.4),
 891 ('V925', 'Business', 0.2, 1.8),
 892 ('V925', 'Economique', 0.5, 1),
 893 ('V925', 'Touriste', 0.3, 1.4),
 894 ('V926', 'Business', 0.2, 1.8),
 895 ('V926', 'Economique', 0.5, 1),
 896 ('V926', 'Touriste', 0.3, 1.4),
 897 ('V927', 'Business', 0.2, 1.8),
 898 ('V927', 'Economique', 0.5, 1),
 899 ('V927', 'Touriste', 0.3, 1.4),
 900 ('V928', 'Business', 0.2, 1.8),
 901 ('V928', 'Economique', 0.5, 1),
 902 ('V928', 'Touriste', 0.3, 1.4),
 903 ('V929', 'Business', 0.2, 1.8),
 904 ('V929', 'Economique', 0.5, 1),
 905 ('V929', 'Touriste', 0.3, 1.4),
 906 ('V930', 'Business', 0.2, 1.8),
 907 ('V930', 'Economique', 0.5, 1),
 908 ('V930', 'Touriste', 0.3, 1.4),
 909 ('V998', 'Business', 0.2, 1.8),
 910 ('V998', 'Economique', 0.5, 1),
 911 ('V998', 'Touriste', 0.3, 1.4),
 912 ('V999', 'Business', 0.2, 1.8),
 913 ('V999', 'Economique', 0.5, 1),
 914 ('V999', 'Touriste', 0.3, 1.4);
 915
 916 -- --------------------------------------------------------
 917
 918 --
 919 -- Structure de la table `PILOTES`
 920 --
 921
 922 DROP TABLE IF EXISTS `PILOTES`;
 923 CREATE TABLE `PILOTES` (
 924   `NumPil` int(11) NOT NULL,
 925   `NomPil` varchar(20) NOT NULL,
 926   `NaisPil` int(11) DEFAULT NULL,
 927   `VillePil` varchar(15) DEFAULT NULL
 928 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 929
 930 --
 931 -- Contenu de la table `PILOTES`
 932 --
 933
 934 INSERT INTO `PILOTES` (`NumPil`, `NomPil`, `NaisPil`, `VillePil`) VALUES
 935 (2000, 'Laplace', NULL, 'Toulon'),
 936 (2020, 'Lapalice', NULL, 'Marseille'),
 937 (2777, 'Larousse', 1963, 'Toulouse'),
 938 (2890, 'Latour', 1958, 'Montpellier'),
 939 (3000, 'Delaroche', 1960, 'Nice'),
 940 (3044, 'Delavigne', 1970, 'Nice'),
 941 (3321, 'Delacroix', 1957, 'Paris'),
 942 (3687, 'Delalande', 1966, 'Nice'),
 943 (4000, 'Duparc', 1955, 'Nice'),
 944 (4010, 'Dupre', NULL, 'Paris'),
 945 (4020, 'Duval', 1944, 'Marseille'),
 946 (4030, 'Dupont', 1943, NULL),
 947 (4040, 'Dupuis', 1960, 'Nantes'),
 948 (4050, 'Dumas', 1949, 'Marseille'),
 949 (4060, 'Dubois', NULL, NULL),
 950 (4070, 'Duchemin', 1965, 'Marseille'),
 951 (4080, 'Durand', 1950, 'Beyrouth'),
 952 (4090, 'Duclos', 1940, 'Toulouse'),
 953 (4111, 'Dujardin', 1940, 'Colmar'),
 954 (5050, 'Leblanc', 1960, 'Marseille'),
 955 (5060, 'Ledru', NULL, 'Nice'),
 956 (5070, 'Legrand', 1945, 'Toulon'),
 957 (5080, 'Leroy', 1970, NULL),
 958 (5090, 'Lebon', 1938, 'Lyon'),
 959 (5456, 'Lejoli', 1949, 'Marseille');
 960
 961 -- --------------------------------------------------------
 962
 963 --
 964 -- Structure de la table `RESERVATIONS`
 965 --
 966
 967 DROP TABLE IF EXISTS `RESERVATIONS`;
 968 CREATE TABLE `RESERVATIONS` (
 969   `NumCl` int(11) NOT NULL,
 970   `NumVol` varchar(5) NOT NULL,
 971   `Classe` varchar(12) NOT NULL,
 972   `NbPlaces` smallint(6) NOT NULL
 973 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
 974
 975 --
 976 -- Contenu de la table `RESERVATIONS`
 977 --
 978
 979 INSERT INTO `RESERVATIONS` (`NumCl`, `NumVol`, `Classe`, `NbPlaces`) VALUES
 980 (1001, 'V1000', 'Economique', 1),
 981 (1001, 'V1000', 'Touriste', 2),
 982 (1001, 'V118', 'Business', 8),
 983 (1001, 'V188', 'Economique', 1),
 984 (1036, 'V1000', 'Economique', 2),
 985 (1036, 'V188', 'Economique', 2),
 986 (1036, 'V190', 'Economique', 3),
 987 (1036, 'V618', 'Touriste', 8),
 988 (1037, 'V1000', 'Economique', 4),
 989 (1037, 'V1002', 'Economique', 8),
 990 (1037, 'V618', 'Economique', 2);
 991
 992 -- --------------------------------------------------------
 993
 994 --
 995 -- Structure de la table `VOLS`
 996 --
 997
 998 DROP TABLE IF EXISTS `VOLS`;
 999 CREATE TABLE `VOLS` (
1000   `NumVol` varchar(5) NOT NULL,
1001   `VilleD` varchar(15) NOT NULL,
1002   `VilleA` varchar(15) NOT NULL,
1003   `DateD` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
1004   `DateA` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
1005   `NumPil` int(11) DEFAULT NULL,
1006   `NumAv` int(11) DEFAULT NULL,
1007   `CoutVol` int(11) DEFAULT NULL
1008 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1009
1010 --
1011 -- Contenu de la table `VOLS`
1012 --
1013
1014 INSERT INTO `VOLS` (`NumVol`, `VilleD`, `VilleA`, `DateD`, `DateA`, `NumPil`, `NumAv`, `CoutVol`) VALUES
1015 ('V1000', 'Amsterdam', 'Marseille', '2018-04-07 13:30:00', '2018-04-07 18:00:00', 5050, 250, 1100),
1016 ('V1001', 'Amsterdam', 'Marseille', '2018-04-07 04:30:00', '2018-04-07 10:10:00', 4040, 320, 1200),
1017 ('V1002', 'Marseille', 'Ajaccio', '2018-04-07 16:00:00', '2018-04-07 17:40:00', 3321, 269, 3950),
1018 ('V101', 'Marseille', 'Amsterdam', '2001-04-07 06:10:00', '2001-04-07 07:10:00', 5050, 560, 950),
1019 ('V102', 'Marseille', 'Amsterdam', '2002-04-07 06:10:00', '2002-04-07 07:10:00', 5050, 560, 950),
1020 ('V103', 'Marseille', 'Amsterdam', '2003-04-07 06:10:00', '2003-04-07 07:10:00', 5050, 560, 950),
1021 ('V104', 'Marseille', 'Amsterdam', '2004-04-07 06:10:00', '2004-04-07 07:10:00', 5050, 560, 950),
1022 ('V105', 'Marseille', 'Amsterdam', '2005-04-07 06:10:00', '2005-04-07 07:10:00', 5050, 560, 950),
1023 ('V106', 'Marseille', 'Amsterdam', '2006-04-07 06:10:00', '2006-04-07 07:10:00', 5050, 560, 950),
1024 ('V107', 'Marseille', 'Amsterdam', '2007-04-07 06:10:00', '2007-04-07 07:10:00', 5050, 560, 950),
1025 ('V108', 'Marseille', 'Amsterdam', '2008-04-07 06:10:00', '2008-04-07 07:10:00', 5050, 560, 950),
1026 ('V109', 'Marseille', 'Amsterdam', '2009-04-07 06:10:00', '2009-04-07 07:10:00', 5050, 560, 950),
1027 ('V110', 'Marseille', 'Amsterdam', '2010-04-07 06:10:00', '2010-04-07 07:10:00', 5050, 560, 950),
1028 ('V111', 'Marseille', 'Amsterdam', '2011-04-07 06:10:00', '2011-04-07 07:10:00', 5050, 560, 950),
1029 ('V112', 'Marseille', 'Amsterdam', '2012-04-07 06:10:00', '2012-04-07 07:10:00', 5050, 560, 950),
1030 ('V113', 'Marseille', 'Amsterdam', '2013-04-07 06:10:00', '2013-04-07 07:10:00', 5050, 560, 950),
1031 ('V114', 'Marseille', 'Amsterdam', '2014-04-07 06:10:00', '2014-04-07 07:10:00', 5050, 560, 950),
1032 ('V115', 'Marseille', 'Amsterdam', '2015-04-07 06:10:00', '2015-04-07 07:10:00', 5050, 560, 950),
1033 ('V116', 'Marseille', 'Amsterdam', '2016-04-07 06:10:00', '2016-04-07 07:10:00', 5050, 560, 950),
1034 ('V117', 'Marseille', 'Amsterdam', '2017-04-07 06:10:00', '2017-04-07 07:10:00', 5050, 560, 950),
1035 ('V118', 'Marseille', 'Amsterdam', '2018-04-07 06:10:00', '2018-04-07 07:10:00', 5050, 560, 950),
1036 ('V119', 'Marseille', 'Amsterdam', '2019-04-07 06:10:00', '2019-04-07 07:10:00', 5050, 560, 950),
1037 ('V120', 'Marseille', 'Amsterdam', '2020-04-07 06:10:00', '2020-04-07 07:10:00', 5050, 560, 950),
1038 ('V131', 'Paris', 'Beyrouth', '2018-01-09 14:21:59', '2018-01-09 14:21:59', 4010, 122, 5200),
1039 ('V141', 'Amsterdam', 'Marseille', '2001-04-07 21:20:00', '2002-04-06 23:10:00', 5050, 101, 950),
1040 ('V142', 'Amsterdam', 'Marseille', '2002-04-07 21:20:00', '2003-04-06 23:10:00', 5050, 101, 950),
1041 ('V143', 'Amsterdam', 'Marseille', '2003-04-07 21:20:00', '2004-04-06 23:10:00', 5050, 101, 950),
1042 ('V144', 'Amsterdam', 'Marseille', '2004-04-07 21:20:00', '2005-04-06 23:10:00', 5050, 101, 950),
1043 ('V145', 'Amsterdam', 'Marseille', '2005-04-07 21:20:00', '2006-04-06 23:10:00', 5050, 101, 950),
1044 ('V146', 'Amsterdam', 'Marseille', '2006-04-07 21:20:00', '2007-04-06 23:10:00', 5050, 101, 950),
1045 ('V147', 'Amsterdam', 'Marseille', '2007-04-07 21:20:00', '2008-04-06 23:10:00', 5050, 101, 950),
1046 ('V148', 'Amsterdam', 'Marseille', '2008-04-07 21:20:00', '2009-04-06 23:10:00', 5050, 101, 950),
1047 ('V149', 'Amsterdam', 'Marseille', '2009-04-07 21:20:00', '2010-04-06 23:10:00', 5050, 101, 950),
1048 ('V150', 'Amsterdam', 'Marseille', '2010-04-07 21:20:00', '2011-04-06 23:10:00', 5050, 101, 950),
1049 ('V151', 'Amsterdam', 'Marseille', '2011-04-07 21:20:00', '2012-04-06 23:10:00', 5050, 101, 950),
1050 ('V152', 'Amsterdam', 'Marseille', '2012-04-07 21:20:00', '2013-04-06 23:10:00', 5050, 101, 950),
1051 ('V153', 'Amsterdam', 'Marseille', '2013-04-07 21:20:00', '2014-04-06 23:10:00', 5050, 101, 950),
1052 ('V154', 'Amsterdam', 'Marseille', '2014-04-07 21:20:00', '2015-04-06 23:10:00', 5050, 101, 950),
1053 ('V155', 'Amsterdam', 'Marseille', '2015-04-07 21:20:00', '2016-04-06 23:10:00', 5050, 101, 950),
1054 ('V156', 'Amsterdam', 'Marseille', '2016-04-07 21:20:00', '2017-04-06 23:10:00', 5050, 101, 950),
1055 ('V157', 'Amsterdam', 'Marseille', '2017-04-07 21:20:00', '2018-04-06 23:10:00', 5050, 101, 950),
1056 ('V180', 'Marseille', 'Amsterdam', '2010-04-07 08:10:00', '2010-04-07 09:10:00', 5050, 915, 950),
1057 ('V181', 'Marseille', 'Amsterdam', '2011-04-07 08:10:00', '2011-04-07 09:10:00', 5050, 915, 950),
1058 ('V182', 'Marseille', 'Amsterdam', '2012-04-07 08:10:00', '2012-04-07 09:10:00', 5050, 915, 950),
1059 ('V183', 'Marseille', 'Amsterdam', '2013-04-07 08:10:00', '2013-04-07 09:10:00', 5050, 915, 950),
1060 ('V184', 'Marseille', 'Amsterdam', '2014-04-07 08:10:00', '2014-04-07 09:10:00', 5050, 915, 950),
1061 ('V185', 'Marseille', 'Amsterdam', '2015-04-07 08:10:00', '2015-04-07 09:10:00', 5050, 915, 950),
1062 ('V186', 'Marseille', 'Amsterdam', '2016-04-07 08:10:00', '2016-04-07 09:10:00', 5050, 915, 950),
1063 ('V187', 'Marseille', 'Amsterdam', '2017-04-07 08:10:00', '2017-04-07 09:10:00', 5050, 915, 950),
1064 ('V188', 'Marseille', 'Amsterdam', '2018-04-07 08:10:00', '2018-04-07 09:10:00', 5050, 915, 950),
1065 ('V189', 'Marseille', 'Amsterdam', '2019-04-07 08:10:00', '2019-04-07 09:10:00', 5050, 915, 950),
1066 ('V190', 'Marseille', 'Amsterdam', '2020-04-07 08:10:00', '2020-04-07 09:10:00', 5050, 915, 950),
1067 ('V191', 'Marseille', 'Amsterdam', '2021-04-07 08:10:00', '2021-04-07 09:10:00', 5050, 915, 950),
1068 ('V192', 'Marseille', 'Amsterdam', '2022-04-07 08:10:00', '2022-04-07 09:10:00', 5050, 915, 950),
1069 ('V193', 'Marseille', 'Amsterdam', '2023-04-07 08:10:00', '2023-04-07 09:10:00', 5050, 915, 950),
1070 ('V194', 'Marseille', 'Amsterdam', '2024-04-07 08:10:00', '2024-04-07 09:10:00', 5050, 915, 950),
1071 ('V195', 'Marseille', 'Amsterdam', '2025-04-07 08:10:00', '2025-04-07 09:10:00', 5050, 915, 950),
1072 ('V196', 'Marseille', 'Amsterdam', '2026-04-07 08:10:00', '2026-04-07 09:10:00', 5050, 915, 950),
1073 ('V197', 'Marseille', 'Amsterdam', '2027-04-07 08:10:00', '2027-04-07 09:10:00', 5050, 915, 950),
1074 ('V198', 'Marseille', 'Amsterdam', '2028-04-07 08:10:00', '2028-04-07 09:10:00', 5050, 915, 950),
1075 ('V199', 'Marseille', 'Amsterdam', '2029-04-07 08:10:00', '2029-04-07 09:10:00', 5050, 915, 950),
1076 ('V200', 'Marseille', 'Amsterdam', '2030-04-07 08:10:00', '2030-04-07 09:10:00', 5050, 915, 950),
1077 ('V210', 'Paris', 'Moscou', '2018-01-09 14:21:59', '2018-01-09 14:21:59', 2020, 511, 4900),
1078 ('V211', 'Paris', 'Pekin', '2001-04-07 15:00:00', '2002-04-07 03:07:00', 5070, 525, 3900),
1079 ('V212', 'Paris', 'Pekin', '2003-04-07 15:00:00', '2004-04-07 03:07:00', 5070, 525, 3900),
1080 ('V213', 'Paris', 'Pekin', '2005-04-07 15:00:00', '2006-04-07 03:07:00', 5070, 525, 3900),
1081 ('V214', 'Paris', 'Pekin', '2007-04-07 15:00:00', '2008-04-07 03:07:00', 5070, 525, 3900),
1082 ('V215', 'Paris', 'Pekin', '2009-04-07 15:00:00', '2010-04-07 03:07:00', 5070, 525, 3900),
1083 ('V216', 'Paris', 'Pekin', '2011-04-07 15:00:00', '2012-04-07 03:07:00', 5070, 525, 3900),
1084 ('V217', 'Paris', 'Pekin', '2013-04-07 15:00:00', '2014-04-07 03:07:00', 5070, 525, 3900),
1085 ('V218', 'Paris', 'Pekin', '2015-04-07 15:00:00', '2016-04-07 03:07:00', 5070, 525, 3900),
1086 ('V219', 'Paris', 'Pekin', '2017-04-07 15:00:00', '2018-04-07 03:07:00', 5070, 525, 3900),
1087 ('V220', 'Paris', 'Pekin', '2019-04-07 15:00:00', '2020-04-07 03:07:00', 5070, 525, 3900),
1088 ('V221', 'Paris', 'Pekin', '2021-04-07 15:00:00', '2022-04-07 03:07:00', 5070, 525, 3900),
1089 ('V222', 'Paris', 'Pekin', '2023-04-07 15:00:00', '2024-04-07 03:07:00', 5070, 525, 3900),
1090 ('V223', 'Paris', 'Pekin', '2025-04-07 15:00:00', '2026-04-07 03:07:00', 5070, 525, 3900),
1091 ('V224', 'Paris', 'Pekin', '2027-04-07 15:00:00', '2028-04-07 03:07:00', 5070, 525, 3900),
1092 ('V240', 'Marseille', 'Paris', '2018-01-09 14:21:59', '2018-01-09 14:21:59', 5050, 315, 850),
1093 ('V265', 'Paris', 'Marseille', '2015-04-07 06:10:00', '2015-04-07 07:10:00', 4000, 715, 850),
1094 ('V341', 'Marseille', 'Paris', '2001-04-07 06:10:00', '2001-04-07 07:10:00', NULL, 415, 850),
1095 ('V342', 'Marseille', 'Paris', '2002-04-07 06:10:00', '2002-04-07 07:10:00', NULL, 415, 850),
1096 ('V343', 'Marseille', 'Paris', '2003-04-07 06:10:00', '2003-04-07 07:10:00', NULL, 415, 850),
1097 ('V344', 'Marseille', 'Paris', '2004-04-07 06:10:00', '2004-04-07 07:10:00', NULL, 415, 850),
1098 ('V345', 'Marseille', 'Paris', '2005-04-07 06:10:00', '2005-04-07 07:10:00', NULL, 415, 850),
1099 ('V346', 'Marseille', 'Paris', '2006-04-07 06:10:00', '2006-04-07 07:10:00', NULL, 415, 850),
1100 ('V347', 'Marseille', 'Paris', '2007-04-07 06:10:00', '2007-04-07 07:10:00', NULL, 415, 850),
1101 ('V348', 'Marseille', 'Paris', '2008-04-07 06:10:00', '2008-04-07 07:10:00', NULL, 415, 850),
1102 ('V349', 'Marseille', 'Paris', '2009-04-07 06:10:00', '2009-04-07 07:10:00', NULL, 415, 850),
1103 ('V350', 'Marseille', 'Paris', '2010-04-07 06:10:00', '2010-04-07 07:10:00', NULL, 415, 850),
1104 ('V351', 'Marseille', 'Paris', '2011-04-07 06:10:00', '2011-04-07 07:10:00', NULL, 415, 850),
1105 ('V352', 'Marseille', 'Paris', '2012-04-07 06:10:00', '2012-04-07 07:10:00', NULL, 415, 850),
1106 ('V353', 'Marseille', 'Paris', '2013-04-07 06:10:00', '2013-04-07 07:10:00', NULL, 415, 850),
1107 ('V354', 'Marseille', 'Paris', '2014-04-07 06:10:00', '2014-04-07 07:10:00', NULL, 415, 850),
1108 ('V355', 'Marseille', 'Paris', '2015-04-07 06:10:00', '2015-04-07 07:10:00', NULL, 415, 850),
1109 ('V356', 'Marseille', 'Paris', '2016-04-07 06:10:00', '2016-04-07 07:10:00', NULL, 415, 850),
1110 ('V357', 'Marseille', 'Paris', '2017-04-07 06:10:00', '2017-04-07 07:10:00', NULL, 415, 850),
1111 ('V358', 'Marseille', 'Paris', '2018-01-20 12:06:20', '2018-04-07 07:10:00', 3321, 415, 850),
1112 ('V359', 'Marseille', 'Paris', '2019-04-07 06:10:00', '2019-04-07 07:10:00', NULL, 415, 850),
1113 ('V360', 'Marseille', 'Paris', '2020-04-07 06:10:00', '2020-04-07 07:10:00', NULL, 415, 850),
1114 ('V361', 'Marseille', 'Paris', '2021-04-07 06:10:00', '2021-04-07 07:10:00', NULL, 415, 850),
1115 ('V362', 'Marseille', 'Paris', '2022-04-07 06:10:00', '2022-04-07 07:10:00', NULL, 415, 850),
1116 ('V363', 'Marseille', 'Paris', '2023-04-07 06:10:00', '2023-04-07 07:10:00', NULL, 415, 850),
1117 ('V364', 'Marseille', 'Paris', '2024-04-07 06:10:00', '2024-04-07 07:10:00', NULL, 415, 850),
1118 ('V365', 'Marseille', 'Paris', '2025-04-07 06:10:00', '2025-04-07 07:10:00', NULL, 415, 850),
1119 ('V366', 'Marseille', 'Paris', '2026-04-07 06:10:00', '2026-04-07 07:10:00', NULL, 415, 850),
1120 ('V367', 'Marseille', 'Paris', '2027-04-07 06:10:00', '2027-04-07 07:10:00', NULL, 415, 850),
1121 ('V368', 'Marseille', 'Paris', '2028-04-07 06:10:00', '2028-04-07 07:10:00', NULL, 415, 850),
1122 ('V369', 'Marseille', 'Paris', '2029-04-07 06:10:00', '2029-04-07 07:10:00', NULL, 415, 850),
1123 ('V370', 'Marseille', 'Paris', '2030-04-07 06:10:00', '2030-04-07 07:10:00', NULL, 415, 850),
1124 ('V420', 'Nantes', 'Paris', '2020-04-07 06:00:00', '2020-04-07 07:10:00', 3321, 140, 250),
1125 ('V431', 'Marseille', 'Istanbul', '2018-01-09 14:22:00', '2018-01-09 14:22:00', 5050, 535, 1000),
1126 ('V490', 'Paris', 'New York', '2018-01-09 14:22:00', '2018-01-09 14:22:00', 4030, 269, 2560),
1127 ('V501', 'Marseille', 'New York', '2001-04-07 06:30:00', '2001-04-07 08:40:00', 5060, 240, 2500),
1128 ('V502', 'Marseille', 'New York', '2002-04-07 06:30:00', '2002-04-07 08:40:00', 5060, 240, 2500),
1129 ('V503', 'Marseille', 'New York', '2003-04-07 06:30:00', '2003-04-07 08:40:00', 5060, 240, 2500),
1130 ('V504', 'Marseille', 'New York', '2004-04-07 06:30:00', '2004-04-07 08:40:00', 5060, 240, 2500),
1131 ('V505', 'Marseille', 'New York', '2005-04-07 06:30:00', '2005-04-07 08:40:00', 5060, 240, 2500),
1132 ('V506', 'Marseille', 'New York', '2006-04-07 06:30:00', '2006-04-07 08:40:00', 5060, 240, 2500),
1133 ('V507', 'Marseille', 'New York', '2007-04-07 06:30:00', '2007-04-07 08:40:00', 5060, 240, 2500),
1134 ('V508', 'Marseille', 'New York', '2008-04-07 06:30:00', '2008-04-07 08:40:00', 5060, 240, 2500),
1135 ('V509', 'Marseille', 'New York', '2009-04-07 06:30:00', '2009-04-07 08:40:00', 5060, 240, 2500),
1136 ('V510', 'Marseille', 'New York', '2010-04-07 06:30:00', '2010-04-07 08:40:00', 5060, 240, 2500),
1137 ('V511', 'Marseille', 'New York', '2011-04-07 06:30:00', '2011-04-07 08:40:00', 5060, 240, 2500),
1138 ('V512', 'Marseille', 'New York', '2012-04-07 06:30:00', '2012-04-07 08:40:00', 5060, 240, 2500),
1139 ('V513', 'Marseille', 'New York', '2013-04-07 06:30:00', '2013-04-07 08:40:00', 5060, 240, 2500),
1140 ('V514', 'Marseille', 'New York', '2014-04-07 06:30:00', '2014-04-07 08:40:00', 5060, 240, 2500),
1141 ('V515', 'Marseille', 'New York', '2015-04-07 06:30:00', '2015-04-07 08:40:00', 5060, 240, 2500),
1142 ('V516', 'Marseille', 'New York', '2016-04-07 06:30:00', '2016-04-07 08:40:00', 5060, 240, 2500),
1143 ('V517', 'Marseille', 'New York', '2017-04-07 06:30:00', '2017-04-07 08:40:00', 5060, 240, 2500),
1144 ('V518', 'Marseille', 'New York', '2018-04-07 06:30:00', '2018-04-07 08:40:00', 5060, 240, 2500),
1145 ('V519', 'Marseille', 'New York', '2019-04-07 06:30:00', '2019-04-07 08:40:00', 5060, 240, 2500),
1146 ('V520', 'Marseille', 'New York', '2020-04-07 06:30:00', '2020-04-07 08:40:00', 5060, 240, 2500),
1147 ('V521', 'Marseille', 'New York', '2021-04-07 06:30:00', '2021-04-07 08:40:00', 5060, 240, 2500),
1148 ('V522', 'Marseille', 'New York', '2022-04-07 06:30:00', '2022-04-07 08:40:00', 5060, 240, 2500),
1149 ('V523', 'Marseille', 'New York', '2023-04-07 06:30:00', '2023-04-07 08:40:00', 5060, 240, 2500),
1150 ('V524', 'Marseille', 'New York', '2024-04-07 06:30:00', '2024-04-07 08:40:00', 5060, 240, 2500),
1151 ('V525', 'Marseille', 'New York', '2025-04-07 06:30:00', '2025-04-07 08:40:00', 5060, 240, 2500),
1152 ('V526', 'Marseille', 'New York', '2026-04-07 06:30:00', '2026-04-07 08:40:00', 5060, 240, 2500),
1153 ('V527', 'Marseille', 'New York', '2027-04-07 06:30:00', '2027-04-07 08:40:00', 5060, 240, 2500),
1154 ('V528', 'Marseille', 'New York', '2028-04-07 06:30:00', '2028-04-07 08:40:00', 5060, 240, 2500),
1155 ('V529', 'Marseille', 'New York', '2029-04-07 06:30:00', '2029-04-07 08:40:00', 5060, 240, 2500),
1156 ('V530', 'Marseille', 'New York', '2030-04-07 06:30:00', '2030-04-07 08:40:00', 5060, 240, 2500),
1157 ('V590', 'Nice', 'Alger', '2018-01-09 14:22:00', '2018-01-09 14:22:00', 4040, 320, 2250),
1158 ('V601', 'Ajaccio', 'Marseille', '2001-04-07 16:00:00', '2001-04-07 17:40:00', 3687, 840, 3950),
1159 ('V602', 'Ajaccio', 'Marseille', '2002-04-07 16:00:00', '2002-04-07 17:40:00', 3687, 840, 3950),
1160 ('V603', 'Ajaccio', 'Marseille', '2003-04-07 16:00:00', '2003-04-07 17:40:00', 3687, 840, 3950),
1161 ('V604', 'Ajaccio', 'Marseille', '2004-04-07 16:00:00', '2004-04-07 17:40:00', 3687, 840, 3950),
1162 ('V605', 'Ajaccio', 'Marseille', '2005-04-07 16:00:00', '2005-04-07 17:40:00', 3687, 840, 3950),
1163 ('V606', 'Ajaccio', 'Marseille', '2006-04-07 16:00:00', '2006-04-07 17:40:00', 3687, 840, 3950),
1164 ('V607', 'Ajaccio', 'Marseille', '2007-04-07 16:00:00', '2007-04-07 17:40:00', 3687, 840, 3950),
1165 ('V608', 'Ajaccio', 'Marseille', '2008-04-07 16:00:00', '2008-04-07 17:40:00', 3687, 840, 3950),
1166 ('V609', 'Ajaccio', 'Marseille', '2009-04-07 16:00:00', '2009-04-07 17:40:00', 3687, 840, 3950),
1167 ('V610', 'Ajaccio', 'Marseille', '2010-04-07 16:00:00', '2010-04-07 17:40:00', 3687, 840, 3950),
1168 ('V611', 'Ajaccio', 'Marseille', '2011-04-07 16:00:00', '2011-04-07 17:40:00', 3687, 840, 3950),
1169 ('V612', 'Ajaccio', 'Marseille', '2012-04-07 16:00:00', '2012-04-07 17:40:00', 3687, 840, 3950),
1170 ('V613', 'Ajaccio', 'Marseille', '2013-04-07 16:00:00', '2013-04-07 17:40:00', 3687, 840, 3950),
1171 ('V614', 'Ajaccio', 'Marseille', '2014-04-07 16:00:00', '2014-04-07 17:40:00', 3687, 840, 3950),
1172 ('V615', 'Ajaccio', 'Marseille', '2015-04-07 16:00:00', '2015-04-07 17:40:00', 3687, 840, 3950),
1173 ('V616', 'Ajaccio', 'Marseille', '2016-04-07 16:00:00', '2016-04-07 17:40:00', 3687, 840, 3950),
1174 ('V617', 'Ajaccio', 'Marseille', '2017-04-07 16:00:00', '2017-04-07 17:40:00', 3687, 840, 3950),
1175 ('V618', 'Ajaccio', 'Marseille', '2018-04-07 16:00:00', '2018-04-07 17:40:00', 3687, 840, 3950),
1176 ('V619', 'Ajaccio', 'Marseille', '2019-04-07 16:00:00', '2019-04-07 17:40:00', 3687, 840, 3950),
1177 ('V620', 'Ajaccio', 'Marseille', '2020-04-07 16:00:00', '2020-04-07 17:40:00', 3687, 840, 3950),
1178 ('V621', 'Ajaccio', 'Marseille', '2021-04-07 16:00:00', '2021-04-07 17:40:00', 3687, 840, 3950),
1179 ('V622', 'Ajaccio', 'Marseille', '2022-04-07 16:00:00', '2022-04-07 17:40:00', 3687, 840, 3950),
1180 ('V623', 'Ajaccio', 'Marseille', '2023-04-07 16:00:00', '2023-04-07 17:40:00', 3687, 840, 3950),
1181 ('V624', 'Ajaccio', 'Marseille', '2024-04-07 16:00:00', '2024-04-07 17:40:00', 3687, 840, 3950),
1182 ('V625', 'Ajaccio', 'Marseille', '2025-04-07 16:00:00', '2025-04-07 17:40:00', 3687, 840, 3950),
1183 ('V626', 'Ajaccio', 'Marseille', '2026-04-07 16:00:00', '2026-04-07 17:40:00', 3687, 840, 3950),
1184 ('V627', 'Ajaccio', 'Marseille', '2027-04-07 16:00:00', '2027-04-07 17:40:00', 3687, 840, 3950),
1185 ('V628', 'Ajaccio', 'Marseille', '2028-04-07 16:00:00', '2028-04-07 17:40:00', 3687, 840, 3950),
1186 ('V629', 'Ajaccio', 'Marseille', '2029-04-07 16:00:00', '2029-04-07 17:40:00', 3687, 840, 3950),
1187 ('V630', 'Ajaccio', 'Marseille', '2030-04-07 16:00:00', '2030-04-07 17:40:00', 3687, 840, 3950),
1188 ('V641', 'Ajaccio', 'Marseille', '2001-04-07 16:00:00', '2001-04-07 17:40:00', 3321, NULL, 3950),
1189 ('V642', 'Ajaccio', 'Marseille', '2002-04-07 16:00:00', '2002-04-07 17:40:00', 3321, NULL, 3950),
1190 ('V643', 'Ajaccio', 'Marseille', '2003-04-07 16:00:00', '2003-04-07 17:40:00', 3321, NULL, 3950),
1191 ('V644', 'Ajaccio', 'Marseille', '2004-04-07 16:00:00', '2004-04-07 17:40:00', 3321, NULL, 3950),
1192 ('V645', 'Ajaccio', 'Marseille', '2005-04-07 16:00:00', '2005-04-07 17:40:00', 3321, NULL, 3950),
1193 ('V646', 'Ajaccio', 'Marseille', '2006-04-07 16:00:00', '2006-04-07 17:40:00', 3321, NULL, 3950),
1194 ('V647', 'Ajaccio', 'Marseille', '2007-04-07 16:00:00', '2007-04-07 17:40:00', 3321, NULL, 3950),
1195 ('V648', 'Ajaccio', 'Marseille', '2008-04-07 16:00:00', '2008-04-07 17:40:00', 3321, NULL, 3950),
1196 ('V649', 'Ajaccio', 'Marseille', '2009-04-07 16:00:00', '2009-04-07 17:40:00', 3321, NULL, 3950),
1197 ('V650', 'Ajaccio', 'Marseille', '2010-04-07 16:00:00', '2010-04-07 17:40:00', 3321, NULL, 3950),
1198 ('V651', 'Ajaccio', 'Marseille', '2011-04-07 16:00:00', '2011-04-07 17:40:00', 3321, NULL, 3950),
1199 ('V652', 'Ajaccio', 'Marseille', '2012-04-07 16:00:00', '2012-04-07 17:40:00', 3321, NULL, 3950),
1200 ('V653', 'Ajaccio', 'Marseille', '2013-04-07 16:00:00', '2013-04-07 17:40:00', 3321, NULL, 3950),
1201 ('V654', 'Ajaccio', 'Marseille', '2014-04-07 16:00:00', '2014-04-07 17:40:00', 3321, NULL, 3950),
1202 ('V655', 'Ajaccio', 'Marseille', '2015-04-07 16:00:00', '2015-04-07 17:40:00', 3321, NULL, 3950),
1203 ('V656', 'Ajaccio', 'Marseille', '2016-04-07 16:00:00', '2016-04-07 17:40:00', 3321, NULL, 3950),
1204 ('V657', 'Ajaccio', 'Marseille', '2017-04-07 16:00:00', '2017-04-07 17:40:00', 3321, NULL, 3950),
1205 ('V658', 'Ajaccio', 'Marseille', '2018-04-07 16:00:00', '2018-04-07 17:40:00', 3321, NULL, 3950),
1206 ('V659', 'Ajaccio', 'Marseille', '2018-01-20 11:28:38', '2019-04-07 17:40:00', 3321, 820, 3950),
1207 ('V660', 'Ajaccio', 'Marseille', '2020-04-07 16:00:00', '2020-04-07 17:40:00', 3321, NULL, 3950),
1208 ('V661', 'Ajaccio', 'Marseille', '2021-04-07 16:00:00', '2021-04-07 17:40:00', 3321, NULL, 3950),
1209 ('V662', 'Ajaccio', 'Marseille', '2022-04-07 16:00:00', '2022-04-07 17:40:00', 3321, NULL, 3950),
1210 ('V663', 'Ajaccio', 'Marseille', '2023-04-07 16:00:00', '2023-04-07 17:40:00', 3321, NULL, 3950),
1211 ('V664', 'Ajaccio', 'Marseille', '2024-04-07 16:00:00', '2024-04-07 17:40:00', 3321, NULL, 3950),
1212 ('V665', 'Ajaccio', 'Marseille', '2025-04-07 16:00:00', '2025-04-07 17:40:00', 3321, NULL, 3950),
1213 ('V666', 'Ajaccio', 'Marseille', '2026-04-07 16:00:00', '2026-04-07 17:40:00', 3321, NULL, 3950),
1214 ('V667', 'Ajaccio', 'Marseille', '2027-04-07 16:00:00', '2027-04-07 17:40:00', 3321, NULL, 3950),
1215 ('V668', 'Ajaccio', 'Marseille', '2028-04-07 16:00:00', '2028-04-07 17:40:00', 3321, NULL, 3950),
1216 ('V669', 'Ajaccio', 'Marseille', '2029-04-07 16:00:00', '2029-04-07 17:40:00', 3321, NULL, 3950),
1217 ('V670', 'Ajaccio', 'Marseille', '2030-04-07 16:00:00', '2030-04-07 17:40:00', 3321, NULL, 3950),
1218 ('V681', 'Marseille', 'Pekin', '2001-04-07 16:00:00', '2002-04-07 04:15:00', 4050, 440, 5400),
1219 ('V682', 'Marseille', 'Pekin', '2003-04-07 16:00:00', '2004-04-07 04:15:00', 4050, 440, 5400),
1220 ('V683', 'Marseille', 'Pekin', '2005-04-07 16:00:00', '2006-04-07 04:15:00', 4050, 440, 5400),
1221 ('V684', 'Marseille', 'Pekin', '2007-04-07 16:00:00', '2008-04-07 04:15:00', 4050, 440, 5400),
1222 ('V685', 'Marseille', 'Pekin', '2009-04-07 16:00:00', '2010-04-07 04:15:00', 4050, 440, 5400),
1223 ('V686', 'Marseille', 'Pekin', '2011-04-07 16:00:00', '2012-04-07 04:15:00', 4050, 440, 5400),
1224 ('V687', 'Marseille', 'Pekin', '2013-04-07 16:00:00', '2014-04-07 04:15:00', 4050, 440, 5400),
1225 ('V688', 'Marseille', 'Pekin', '2015-04-07 16:00:00', '2016-04-07 04:15:00', 4050, 440, 5400),
1226 ('V689', 'Marseille', 'Pekin', '2017-04-07 16:00:00', '2018-04-07 04:15:00', 4050, 440, 5400),
1227 ('V690', 'Marseille', 'Pekin', '2019-04-07 16:00:00', '2020-04-07 04:15:00', 4050, 440, 5400),
1228 ('V691', 'Marseille', 'Pekin', '2021-04-07 16:00:00', '2022-04-07 04:15:00', 4050, 440, 5400),
1229 ('V692', 'Marseille', 'Pekin', '2023-04-07 16:00:00', '2024-04-07 04:15:00', 4050, 440, 5400),
1230 ('V693', 'Marseille', 'Pekin', '2025-04-07 16:00:00', '2026-04-07 04:15:00', 4050, 440, 5400),
1231 ('V694', 'Marseille', 'Pekin', '2027-04-07 16:00:00', '2028-04-07 04:15:00', 4050, 440, 5400),
1232 ('V720', 'Beyrouth', 'Paris', '2018-01-09 14:22:01', '2018-01-09 14:22:01', 4080, 811, 1950),
1233 ('V787', 'Metz', 'Marseille', '2017-04-07 03:00:00', '2017-04-07 04:15:00', 4060, 720, 1400),
1234 ('V788', 'Metz', 'Marseille', '2018-04-07 03:00:00', '2018-04-07 04:15:00', 4060, 720, 1400),
1235 ('V789', 'Metz', 'Marseille', '2019-04-07 03:00:00', '2019-04-07 04:15:00', 4060, 720, 1400),
1236 ('V790', 'Metz', 'Marseille', '2020-04-07 03:00:00', '2020-04-07 04:15:00', 4060, 720, 1400),
1237 ('V791', 'Metz', 'Marseille', '2021-04-07 03:00:00', '2021-04-07 04:15:00', 4060, 720, 1400),
1238 ('V804', 'Nice', 'Paris', '2004-04-07 03:00:00', '2004-04-07 04:15:00', 4020, 240, 1200),
1239 ('V805', 'Nice', 'Paris', '2005-04-07 03:00:00', '2005-04-07 04:15:00', 4020, 240, 1200),
1240 ('V806', 'Nice', 'Paris', '2006-04-07 03:00:00', '2006-04-07 04:15:00', 4020, 240, 1200),
1241 ('V807', 'Nice', 'Paris', '2007-04-07 03:00:00', '2007-04-07 04:15:00', 4020, 240, 1200),
1242 ('V808', 'Nice', 'Paris', '2008-04-07 03:00:00', '2008-04-07 04:15:00', 4020, 240, 1200),
1243 ('V809', 'Nice', 'Paris', '2009-04-07 03:00:00', '2009-04-07 04:15:00', 4020, 240, 1200),
1244 ('V882', 'Strasbourg', 'Marseille', '2012-04-07 05:00:00', '2012-04-07 06:15:00', 4060, 240, 1650),
1245 ('V883', 'Strasbourg', 'Marseille', '2013-04-07 05:00:00', '2013-04-07 06:15:00', 4060, 240, 1650),
1246 ('V884', 'Strasbourg', 'Marseille', '2014-04-07 05:00:00', '2014-04-07 06:15:00', 4060, 240, 1650),
1247 ('V885', 'Strasbourg', 'Marseille', '2015-04-07 05:00:00', '2015-04-07 06:15:00', 4060, 240, 1650),
1248 ('V886', 'Strasbourg', 'Marseille', '2016-04-07 05:00:00', '2016-04-07 06:15:00', 4060, 240, 1650),
1249 ('V887', 'Strasbourg', 'Marseille', '2017-04-07 05:00:00', '2017-04-07 06:15:00', 4060, 240, 1650),
1250 ('V888', 'Strasbourg', 'Marseille', '2018-04-07 05:00:00', '2018-04-07 06:15:00', 4060, 240, 1650),
1251 ('V889', 'Strasbourg', 'Marseille', '2019-04-07 05:00:00', '2019-04-07 06:15:00', 4060, 240, 1650),
1252 ('V890', 'Strasbourg', 'Marseille', '2020-04-07 05:00:00', '2020-04-07 06:15:00', 4060, 240, 1650),
1253 ('V901', 'Paris', 'Nice', '2001-04-07 20:00:00', '2001-04-07 21:15:00', 4020, 240, 1200),
1254 ('V902', 'Paris', 'Nice', '2002-04-07 20:00:00', '2002-04-07 21:15:00', 4020, 240, 1200),
1255 ('V903', 'Paris', 'Nice', '2003-04-07 20:00:00', '2003-04-07 21:15:00', 4020, 240, 1200),
1256 ('V904', 'Paris', 'Nice', '2004-04-07 20:00:00', '2004-04-07 21:15:00', 4020, 240, 1200),
1257 ('V905', 'Paris', 'Nice', '2005-04-07 20:00:00', '2005-04-07 21:15:00', 4020, 240, 1200),
1258 ('V906', 'Paris', 'Nice', '2006-04-07 20:00:00', '2006-04-07 21:15:00', 4020, 240, 1200),
1259 ('V907', 'Paris', 'Nice', '2007-04-07 20:00:00', '2007-04-07 21:15:00', 4020, 240, 1200),
1260 ('V908', 'Paris', 'Nice', '2008-04-07 20:00:00', '2008-04-07 21:15:00', 4020, 240, 1200),
1261 ('V909', 'Paris', 'Nice', '2009-04-07 20:00:00', '2009-04-07 21:15:00', 4020, 240, 1200),
1262 ('V910', 'Paris', 'Nice', '2010-04-07 20:00:00', '2010-04-07 21:15:00', 4020, 240, 1200),
1263 ('V911', 'Paris', 'Nice', '2011-04-07 20:00:00', '2011-04-07 21:15:00', 4020, 240, 1200),
1264 ('V912', 'Paris', 'Nice', '2012-04-07 20:00:00', '2012-04-07 21:15:00', 4020, 240, 1200),
1265 ('V913', 'Paris', 'Nice', '2013-04-07 20:00:00', '2013-04-07 21:15:00', 4020, 240, 1200),
1266 ('V914', 'Paris', 'Nice', '2014-04-07 20:00:00', '2014-04-07 21:15:00', 4020, 240, 1200),
1267 ('V915', 'Paris', 'Nice', '2015-04-07 20:00:00', '2015-04-07 21:15:00', 4020, 240, 1200),
1268 ('V916', 'Paris', 'Nice', '2016-04-07 20:00:00', '2016-04-07 21:15:00', 4020, 240, 1200),
1269 ('V917', 'Paris', 'Nice', '2017-04-07 20:00:00', '2017-04-07 21:15:00', 4020, 240, 1200),
1270 ('V918', 'Paris', 'Nice', '2018-04-07 20:00:00', '2018-04-07 21:15:00', 4020, 240, 1200),
1271 ('V919', 'Paris', 'Nice', '2019-04-07 20:00:00', '2019-04-07 21:15:00', 4020, 240, 1200),
1272 ('V920', 'Paris', 'Nice', '2020-04-07 20:00:00', '2020-04-07 21:15:00', 4020, 240, 1200),
1273 ('V921', 'Paris', 'Nice', '2021-04-07 20:00:00', '2021-04-07 21:15:00', 4020, 240, 1200),
1274 ('V922', 'Paris', 'Nice', '2022-04-07 20:00:00', '2022-04-07 21:15:00', 4020, 240, 1200),
1275 ('V923', 'Paris', 'Nice', '2023-04-07 20:00:00', '2023-04-07 21:15:00', 4020, 240, 1200),
1276 ('V924', 'Paris', 'Nice', '2024-04-07 20:00:00', '2024-04-07 21:15:00', 4020, 240, 1200),
1277 ('V925', 'Paris', 'Nice', '2025-04-07 20:00:00', '2025-04-07 21:15:00', 4020, 240, 1200),
1278 ('V926', 'Paris', 'Nice', '2026-04-07 20:00:00', '2026-04-07 21:15:00', 4020, 240, 1200),
1279 ('V927', 'Paris', 'Nice', '2027-04-07 20:00:00', '2027-04-07 21:15:00', 4020, 240, 1200),
1280 ('V928', 'Paris', 'Nice', '2028-04-07 20:00:00', '2028-04-07 21:15:00', 4020, 240, 1200),
1281 ('V929', 'Paris', 'Nice', '2029-04-07 20:00:00', '2029-04-07 21:15:00', 4020, 240, 1200),
1282 ('V930', 'Paris', 'Nice', '2030-04-07 20:00:00', '2030-04-07 21:15:00', 4020, 240, 1200),
1283 ('V998', 'Moscou', 'Paris', '2030-04-07 21:40:00', '2001-05-07 00:00:00', 5070, 411, 3000),
1284 ('V999', 'Alger', 'Marseille', '2018-01-09 14:22:01', '2018-01-09 14:22:01', 4090, 660, 1850);
1285
1286 --
1287 -- Index pour les tables exportées
1288 --
1289
1290 --
1291 -- Index pour la table `AVIONS`
1292 --
1293 ALTER TABLE `AVIONS`
1294   ADD PRIMARY KEY (`NumAv`);
1295
1296 --
1297 -- Index pour la table `CLIENTS`
1298 --
1299 ALTER TABLE `CLIENTS`
1300   ADD PRIMARY KEY (`NumCl`),
1301   ADD UNIQUE KEY `EmailCI` (`EmailCl`);
1302
1303 --
1304 -- Index pour la table `DEFCLASSES`
1305 --
1306 ALTER TABLE `DEFCLASSES`
1307   ADD PRIMARY KEY (`NumVol`,`Classe`);
1308
1309 --
1310 -- Index pour la table `PILOTES`
1311 --
1312 ALTER TABLE `PILOTES`
1313   ADD PRIMARY KEY (`NumPil`);
1314
1315 --
1316 -- Index pour la table `RESERVATIONS`
1317 --
1318 ALTER TABLE `RESERVATIONS`
1319   ADD PRIMARY KEY (`NumCl`,`NumVol`,`Classe`),
1320   ADD KEY `classe_ref_reserv` (`NumVol`,`Classe`);
1321
1322 --
1323 -- Index pour la table `VOLS`
1324 --
1325 ALTER TABLE `VOLS`
1326   ADD PRIMARY KEY (`NumVol`),
1327   ADD KEY `pil_ref_vol` (`NumPil`),
1328   ADD KEY `avion_ref_vol` (`NumAv`);
1329
1330 --
1331 -- AUTO_INCREMENT pour les tables exportées
1332 --
1333
1334 --
1335 -- AUTO_INCREMENT pour la table `CLIENTS`
1336 --
1337 ALTER TABLE `CLIENTS`
1338   MODIFY `NumCl` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1038;
1339 --
1340 -- AUTO_INCREMENT pour la table `PILOTES`
1341 --
1342 ALTER TABLE `PILOTES`
1343   MODIFY `NumPil` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5457;
1344 --
1345 -- Contraintes pour les tables exportées
1346 --
1347
1348 --
1349 -- Contraintes pour la table `DEFCLASSES`
1350 --
1351 ALTER TABLE `DEFCLASSES`
1352   ADD CONSTRAINT `vol_ref_defclasse` FOREIGN KEY (`NumVol`) REFERENCES `VOLS` (`NumVol`);
1353
1354 --
1355 -- Contraintes pour la table `RESERVATIONS`
1356 --
1357 ALTER TABLE `RESERVATIONS`
1358   ADD CONSTRAINT `classe_ref_reserv` FOREIGN KEY (`NumVol`,`Classe`) REFERENCES `DEFCLASSES` (`NumVol`, `Classe`),
1359   ADD CONSTRAINT `client_ref_reserv` FOREIGN KEY (`NumCl`) REFERENCES `CLIENTS` (`NumCl`);
1360
1361 --
1362 -- Contraintes pour la table `VOLS`
1363 --
1364 ALTER TABLE `VOLS`
1365   ADD CONSTRAINT `avion_ref_vol` FOREIGN KEY (`NumAv`) REFERENCES `AVIONS` (`NumAv`),
1366   ADD CONSTRAINT `pil_ref_vol` FOREIGN KEY (`NumPil`) REFERENCES `PILOTES` (`NumPil`);
1367
1368 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1369 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1370 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;