Commit | Line | Data |
---|---|---|
46d7c660 JB |
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 */; |