-- phpMyAdmin SQL Dump
-- version 4.5.4.1
-- http://www.phpmyadmin.net
--
-- Client :  localhost
-- Généré le :  Mer 15 Novembre 2023 à 22:31
-- Version du serveur :  5.7.11
-- Version de PHP :  5.6.18

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Base de données :  `aviation`
--

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

--
-- Structure de la table `avions_ligne`
--

CREATE TABLE `avions_ligne` (
  `ID_AL` varchar(5) COLLATE latin1_general_cs NOT NULL,
  `ID_ALFull` varchar(15) COLLATE latin1_general_cs NOT NULL COMMENT 'ID de l''avion',
  `Constructeur` varchar(10) COLLATE latin1_general_cs NOT NULL COMMENT 'Nom du constructeur',
  `Famille` varchar(5) COLLATE latin1_general_cs NOT NULL,
  `Série` varchar(5) COLLATE latin1_general_cs NOT NULL,
  `Modèle` varchar(10) COLLATE latin1_general_cs NOT NULL,
  `NbreMoteurs` tinyint(4) NOT NULL,
  `ID_Moteur` varchar(20) COLLATE latin1_general_cs NOT NULL,
  `Envergure` decimal(5,2) NOT NULL COMMENT '(m)',
  `Longueur` decimal(5,2) NOT NULL COMMENT '(m)',
  `Hauteur` decimal(5,2) NOT NULL COMMENT '(m)',
  `LargeurFuselage` decimal(5,2) NOT NULL COMMENT '(m)',
  `LargeurCabine` decimal(5,2) NOT NULL COMMENT '(m)',
  `NbrePassMin` smallint(6) NOT NULL DEFAULT '0',
  `NbrePassMax` smallint(6) NOT NULL DEFAULT '0',
  `VolumeCargo` smallint(6) NOT NULL COMMENT '(mètres cube)',
  `LD3` tinyint(4) NOT NULL,
  `MiseEnService` date DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs COMMENT='Avions de ligne';

--
-- Contenu de la table `avions_ligne`
--

INSERT INTO `avions_ligne` (`ID_AL`, `ID_ALFull`, `Constructeur`, `Famille`, `Série`, `Modèle`, `NbreMoteurs`, `ID_Moteur`, `Envergure`, `Longueur`, `Hauteur`, `LargeurFuselage`, `LargeurCabine`, `NbrePassMin`, `NbrePassMax`, `VolumeCargo`, `LD3`, `MiseEnService`) VALUES
('AL1', 'A350-800', 'Airbus', '350', '', '800', 2, 'M7', '64.75', '60.64', '17.05', '5.96', '5.61', 276, 312, 0, 28, '0000-00-00'),
('AL10', 'A320-214', 'Airbus', '320', '200', '214', 2, 'M15', '35.80', '37.57', '11.76', '3.95', '3.70', 150, 180, 0, 7, '1987-04-18'),
('AL11', 'A321-211', 'Airbus', '320', '200', '211', 2, 'M16', '35.80', '44.51', '11.76', '3.95', '3.70', 185, 236, 0, 10, '1993-03-11'),
('AL12', 'A321-212', 'Airbus', '320', '200', '212', 2, 'M17', '35.80', '44.51', '11.76', '3.95', '3.70', 185, 236, 10, 10, '1993-03-11'),
('AL13', 'A321-131', 'Airbus', '320', '100', '131', 2, 'M18', '35.80', '44.51', '11.76', '3.95', '3.70', 185, 236, 0, 10, '1993-03-11'),
('AL14', 'A321-231', 'Airbus', '320', '200', '231', 2, 'M19', '35.80', '44.51', '11.76', '3.95', '3.70', 185, 236, 0, 10, '1993-03-11'),
('AL15', 'A350-941', 'Airbus', '350', '900', '941', 2, 'M8', '64.75', '66.89', '17.05', '5.96', '5.61', 315, 366, 0, 36, '2015-01-15'),
('AL2', 'B777-300ER', 'Boeing', '777', '', '300ER', 2, 'M1', '64.80', '73.90', '18.50', '6.20', '5.87', 365, 550, 216, 0, '0000-00-00'),
('AL3', 'B777F', 'Boeing', '777', '', 'F', 2, 'M2', '64.80', '63.70', '18.50', '6.20', '5.87', 0, 0, 653, 0, '0000-00-00'),
('AL4', 'B777-200ER', 'Boeing', '777', '', '200ER', 2, 'M2', '60.90', '63.70', '18.50', '6.20', '5.87', 301, 440, 162, 0, NULL),
('AL5', 'A380-841', 'Airbus', '380', '800', '841', 4, 'M11', '79.75', '72.72', '24.09', '7.14', '6.54', 525, 853, 0, 38, '2007-10-25'),
('AL6', 'A380-861', 'Airbus', '380', '800', '861', 4, 'M10', '79.75', '72.72', '24.09', '7.14', '6.54', 525, 853, 0, 38, '2007-10-25'),
('AL7', 'A380-800', 'Airbus', '380', '800', '842', 4, 'M12', '79.75', '72.72', '24.09', '7.14', '6.54', 525, 853, 0, 38, '2007-10-25'),
('AL8', 'B747-8', 'Boeing', '747', '', '8I', 4, 'M13', '68.45', '76.25', '19.35', '0.00', '6.10', 467, 605, 162, 0, '2012-06-01'),
('AL9', 'ERJ190-100', 'Embraer', 'E-Jet', '', 'E-190', 2, 'M14', '28.72', '36.24', '10.28', '3.01', '2.74', 94, 114, 0, 0, '2004-03-17');

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

--
-- Structure de la table `compagnies_aériennes`
--

CREATE TABLE `compagnies_aériennes` (
  `ID_Compagnie` varchar(2) COLLATE latin1_general_cs NOT NULL,
  `Nom` varchar(20) COLLATE latin1_general_cs NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs COMMENT='Compagnies aériennes';

--
-- Contenu de la table `compagnies_aériennes`
--

INSERT INTO `compagnies_aériennes` (`ID_Compagnie`, `Nom`) VALUES
('AF', 'Air France'),
('AI', 'Air India'),
('BA', 'British Airways'),
('EK', 'Emirates'),
('LH', 'Lufthansa'),
('QF', 'Quantas'),
('QR', 'Qatar Airways');

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

--
-- Structure de la table `flotte`
--

CREATE TABLE `flotte` (
  `Immatriculation` varchar(8) COLLATE latin1_general_cs NOT NULL,
  `ID_Compagnie` varchar(2) COLLATE latin1_general_cs NOT NULL,
  `ID_AL` varchar(5) COLLATE latin1_general_cs NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs COMMENT='Flotte transport passagers';

--
-- Contenu de la table `flotte`
--

INSERT INTO `flotte` (`Immatriculation`, `ID_Compagnie`, `ID_AL`) VALUES
('A6-00', 'EK', 'AL6'),
('A6-01', 'EK', 'AL6'),
('A6-010', 'EK', 'AL6'),
('A6-0100', 'EK', 'AL2'),
('A6-0101', 'EK', 'AL2'),
('A6-0102', 'EK', 'AL2'),
('A6-0103', 'EK', 'AL2'),
('A6-0104', 'EK', 'AL2'),
('A6-0105', 'EK', 'AL2'),
('A6-0106', 'EK', 'AL2'),
('A6-0107', 'EK', 'AL2'),
('A6-0108', 'EK', 'AL2'),
('A6-0109', 'EK', 'AL2'),
('A6-011', 'EK', 'AL6'),
('A6-0110', 'EK', 'AL2'),
('A6-0111', 'EK', 'AL2'),
('A6-0112', 'EK', 'AL2'),
('A6-0113', 'EK', 'AL2'),
('A6-0114', 'EK', 'AL2'),
('A6-0115', 'EK', 'AL2'),
('A6-0116', 'EK', 'AL2'),
('A6-0117', 'EK', 'AL2'),
('A6-0118', 'EK', 'AL2'),
('A6-0119', 'EK', 'AL2'),
('A6-012', 'EK', 'AL6'),
('A6-0120', 'EK', 'AL2'),
('A6-0121', 'EK', 'AL2'),
('A6-0122', 'EK', 'AL2'),
('A6-0123', 'EK', 'AL2'),
('A6-0124', 'EK', 'AL2'),
('A6-0125', 'EK', 'AL2'),
('A6-0126', 'EK', 'AL2'),
('A6-0127', 'EK', 'AL2'),
('A6-0128', 'EK', 'AL2'),
('A6-0129', 'EK', 'AL2'),
('A6-013', 'EK', 'AL6'),
('A6-0130', 'EK', 'AL2'),
('A6-0131', 'EK', 'AL2'),
('A6-0132', 'EK', 'AL2'),
('A6-0133', 'EK', 'AL2'),
('A6-0134', 'EK', 'AL2'),
('A6-0135', 'EK', 'AL2'),
('A6-0136', 'EK', 'AL2'),
('A6-0137', 'EK', 'AL2'),
('A6-0138', 'EK', 'AL2'),
('A6-0139', 'EK', 'AL2'),
('A6-014', 'EK', 'AL6'),
('A6-0140', 'EK', 'AL2'),
('A6-0141', 'EK', 'AL2'),
('A6-0142', 'EK', 'AL2'),
('A6-0143', 'EK', 'AL2'),
('A6-0144', 'EK', 'AL2'),
('A6-0145', 'EK', 'AL2'),
('A6-0146', 'EK', 'AL2'),
('A6-0147', 'EK', 'AL2'),
('A6-0148', 'EK', 'AL2'),
('A6-0149', 'EK', 'AL2'),
('A6-015', 'EK', 'AL6'),
('A6-0150', 'EK', 'AL2'),
('A6-0151', 'EK', 'AL2'),
('A6-0152', 'EK', 'AL2'),
('A6-0153', 'EK', 'AL2'),
('A6-0154', 'EK', 'AL2'),
('A6-0155', 'EK', 'AL2'),
('A6-0156', 'EK', 'AL2'),
('A6-0157', 'EK', 'AL2'),
('A6-0158', 'EK', 'AL2'),
('A6-0159', 'EK', 'AL2'),
('A6-016', 'EK', 'AL6'),
('A6-017', 'EK', 'AL6'),
('A6-018', 'EK', 'AL6'),
('A6-019', 'EK', 'AL6'),
('A6-02', 'EK', 'AL6'),
('A6-020', 'EK', 'AL6'),
('A6-021', 'EK', 'AL6'),
('A6-022', 'EK', 'AL6'),
('A6-023', 'EK', 'AL6'),
('A6-024', 'EK', 'AL6'),
('A6-025', 'EK', 'AL6'),
('A6-026', 'EK', 'AL6'),
('A6-027', 'EK', 'AL6'),
('A6-028', 'EK', 'AL6'),
('A6-029', 'EK', 'AL6'),
('A6-03', 'EK', 'AL6'),
('A6-030', 'EK', 'AL6'),
('A6-031', 'EK', 'AL6'),
('A6-032', 'EK', 'AL6'),
('A6-033', 'EK', 'AL6'),
('A6-034', 'EK', 'AL6'),
('A6-035', 'EK', 'AL6'),
('A6-036', 'EK', 'AL6'),
('A6-037', 'EK', 'AL6'),
('A6-038', 'EK', 'AL6'),
('A6-039', 'EK', 'AL6'),
('A6-04', 'EK', 'AL6'),
('A6-040', 'EK', 'AL6'),
('A6-041', 'EK', 'AL6'),
('A6-042', 'EK', 'AL6'),
('A6-043', 'EK', 'AL6'),
('A6-044', 'EK', 'AL6'),
('A6-045', 'EK', 'AL6'),
('A6-046', 'EK', 'AL6'),
('A6-047', 'EK', 'AL6'),
('A6-048', 'EK', 'AL6'),
('A6-049', 'EK', 'AL6'),
('A6-05', 'EK', 'AL6'),
('A6-050', 'EK', 'AL6'),
('A6-051', 'EK', 'AL6'),
('A6-052', 'EK', 'AL6'),
('A6-053', 'EK', 'AL6'),
('A6-054', 'EK', 'AL6'),
('A6-055', 'EK', 'AL6'),
('A6-056', 'EK', 'AL6'),
('A6-057', 'EK', 'AL6'),
('A6-058', 'EK', 'AL6'),
('A6-059', 'EK', 'AL2'),
('A6-06', 'EK', 'AL6'),
('A6-060', 'EK', 'AL2'),
('A6-061', 'EK', 'AL2'),
('A6-062', 'EK', 'AL2'),
('A6-063', 'EK', 'AL2'),
('A6-064', 'EK', 'AL2'),
('A6-065', 'EK', 'AL2'),
('A6-066', 'EK', 'AL2'),
('A6-067', 'EK', 'AL2'),
('A6-068', 'EK', 'AL2'),
('A6-069', 'EK', 'AL2'),
('A6-07', 'EK', 'AL6'),
('A6-070', 'EK', 'AL2'),
('A6-071', 'EK', 'AL2'),
('A6-072', 'EK', 'AL2'),
('A6-073', 'EK', 'AL2'),
('A6-074', 'EK', 'AL2'),
('A6-075', 'EK', 'AL2'),
('A6-076', 'EK', 'AL2'),
('A6-077', 'EK', 'AL2'),
('A6-078', 'EK', 'AL2'),
('A6-079', 'EK', 'AL2'),
('A6-08', 'EK', 'AL6'),
('A6-080', 'EK', 'AL2'),
('A6-081', 'EK', 'AL2'),
('A6-082', 'EK', 'AL2'),
('A6-083', 'EK', 'AL2'),
('A6-084', 'EK', 'AL2'),
('A6-085', 'EK', 'AL2'),
('A6-086', 'EK', 'AL2'),
('A6-087', 'EK', 'AL2'),
('A6-088', 'EK', 'AL2'),
('A6-089', 'EK', 'AL2'),
('A6-09', 'EK', 'AL6'),
('A6-090', 'EK', 'AL2'),
('A6-091', 'EK', 'AL2'),
('A6-092', 'EK', 'AL2'),
('A6-093', 'EK', 'AL2'),
('A6-094', 'EK', 'AL2'),
('A6-095', 'EK', 'AL2'),
('A6-096', 'EK', 'AL2'),
('A6-097', 'EK', 'AL2'),
('A6-098', 'EK', 'AL2'),
('A6-099', 'EK', 'AL2'),
('A7-00', 'QR', 'AL15'),
('A7-01', 'QR', 'AL15'),
('A7-010', 'QR', 'AL14'),
('A7-011', 'QR', 'AL14'),
('A7-012', 'QR', 'AL14'),
('A7-02', 'QR', 'AL6'),
('A7-03', 'QR', 'AL6'),
('A7-04', 'QR', 'AL6'),
('A7-05', 'QR', 'AL6'),
('A7-06', 'QR', 'AL14'),
('A7-07', 'QR', 'AL14'),
('A7-08', 'QR', 'AL14'),
('A7-09', 'QR', 'AL14'),
('D-000', 'LH', 'AL8'),
('D-001', 'LH', 'AL8'),
('D-0010', 'LH', 'AL8'),
('D-0011', 'LH', 'AL8'),
('D-0012', 'LH', 'AL8'),
('D-0013', 'LH', 'AL8'),
('D-0014', 'LH', 'AL8'),
('D-0016', 'LH', 'AL13'),
('D-0017', 'LH', 'AL13'),
('D-0018', 'LH', 'AL13'),
('D-0019', 'LH', 'AL13'),
('D-002', 'LH', 'AL8'),
('D-0020', 'LH', 'AL13'),
('D-0021', 'LH', 'AL13'),
('D-0022', 'LH', 'AL13'),
('D-0023', 'LH', 'AL13'),
('D-0024', 'LH', 'AL13'),
('D-0025', 'LH', 'AL13'),
('D-0026', 'LH', 'AL13'),
('D-0027', 'LH', 'AL13'),
('D-0028', 'LH', 'AL13'),
('D-0029', 'LH', 'AL13'),
('D-003', 'LH', 'AL8'),
('D-0030', 'LH', 'AL13'),
('D-0031', 'LH', 'AL13'),
('D-0032', 'LH', 'AL13'),
('D-0033', 'LH', 'AL13'),
('D-0034', 'LH', 'AL13'),
('D-0035', 'LH', 'AL13'),
('D-0036', 'LH', 'AL5'),
('D-0037', 'LH', 'AL5'),
('D-0038', 'LH', 'AL5'),
('D-0039', 'LH', 'AL5'),
('D-004', 'LH', 'AL8'),
('D-0040', 'LH', 'AL5'),
('D-0041', 'LH', 'AL5'),
('D-0042', 'LH', 'AL5'),
('D-0043', 'LH', 'AL5'),
('D-0044', 'LH', 'AL5'),
('D-0045', 'LH', 'AL5'),
('D-0046', 'LH', 'AL5'),
('D-0047', 'LH', 'AL5'),
('D-005', 'LH', 'AL8'),
('D-006', 'LH', 'AL8'),
('D-007', 'LH', 'AL8'),
('D-008', 'LH', 'AL8'),
('D-009', 'LH', 'AL8'),
('F-G001', 'AF', 'AL10'),
('F-G002', 'AF', 'AL10'),
('F-G003', 'AF', 'AL10'),
('F-G004', 'AF', 'AL10'),
('F-G005', 'AF', 'AL10'),
('F-G006', 'AF', 'AL10'),
('F-G007', 'AF', 'AL10'),
('F-G008', 'AF', 'AL10'),
('F-G009', 'AF', 'AL10'),
('F-G010', 'AF', 'AL10'),
('F-G011', 'AF', 'AL10'),
('F-G012', 'AF', 'AL10'),
('F-G013', 'AF', 'AL10'),
('F-G014', 'AF', 'AL10'),
('F-G015', 'AF', 'AL10'),
('F-G016', 'AF', 'AL10'),
('F-G017', 'AF', 'AL10'),
('F-G018', 'AF', 'AL10'),
('F-G019', 'AF', 'AL10'),
('F-G020', 'AF', 'AL10'),
('F-G021', 'AF', 'AL10'),
('F-G022', 'AF', 'AL10'),
('F-G023', 'AF', 'AL10'),
('F-G024', 'AF', 'AL10'),
('F-G025', 'AF', 'AL10'),
('F-G026', 'AF', 'AL10'),
('F-G027', 'AF', 'AL10'),
('F-G028', 'AF', 'AL10'),
('F-G029', 'AF', 'AL10'),
('F-G030', 'AF', 'AL10'),
('F-G031', 'AF', 'AL10'),
('F-G032', 'AF', 'AL10'),
('F-G033', 'AF', 'AL10'),
('F-G034', 'AF', 'AL10'),
('F-G035', 'AF', 'AL10'),
('F-G036', 'AF', 'AL10'),
('F-G037', 'AF', 'AL10'),
('F-G038', 'AF', 'AL10'),
('F-G039', 'AF', 'AL10'),
('F-G040', 'AF', 'AL10'),
('F-G041', 'AF', 'AL11'),
('F-G042', 'AF', 'AL11'),
('F-G043', 'AF', 'AL11'),
('F-G044', 'AF', 'AL11'),
('F-G045', 'AF', 'AL11'),
('F-G046', 'AF', 'AL11'),
('F-G047', 'AF', 'AL11'),
('F-G048', 'AF', 'AL11'),
('F-G049', 'AF', 'AL11'),
('F-G050', 'AF', 'AL11'),
('F-G051', 'AF', 'AL12'),
('F-G052', 'AF', 'AL12'),
('F-G053', 'AF', 'AL12'),
('F-G054', 'AF', 'AL12'),
('F-G055', 'AF', 'AL12'),
('F-G056', 'AF', 'AL12'),
('F-G057', 'AF', 'AL12'),
('F-G058', 'AF', 'AL12'),
('F-G059', 'AF', 'AL12'),
('F-G060', 'AF', 'AL12'),
('F-G061', 'AF', 'AL2'),
('F-G062', 'AF', 'AL2'),
('F-G063', 'AF', 'AL2'),
('F-G064', 'AF', 'AL2'),
('F-G065', 'AF', 'AL2'),
('F-G066', 'AF', 'AL2'),
('F-G067', 'AF', 'AL2'),
('F-G068', 'AF', 'AL2'),
('F-G069', 'AF', 'AL2'),
('F-G070', 'AF', 'AL2'),
('F-G071', 'AF', 'AL2'),
('F-G072', 'AF', 'AL2'),
('F-G073', 'AF', 'AL2'),
('F-G074', 'AF', 'AL2'),
('F-G075', 'AF', 'AL2'),
('F-G076', 'AF', 'AL2'),
('F-G077', 'AF', 'AL2'),
('F-G078', 'AF', 'AL2'),
('F-G079', 'AF', 'AL2'),
('F-G080', 'AF', 'AL2'),
('F-G081', 'AF', 'AL2'),
('F-G082', 'AF', 'AL2'),
('F-G083', 'AF', 'AL2'),
('F-G084', 'AF', 'AL2'),
('F-G085', 'AF', 'AL2'),
('F-G086', 'AF', 'AL2'),
('F-G087', 'AF', 'AL2'),
('F-G088', 'AF', 'AL2'),
('F-G089', 'AF', 'AL2'),
('F-G090', 'AF', 'AL2'),
('F-G091', 'AF', 'AL2'),
('F-G092', 'AF', 'AL2'),
('F-G093', 'AF', 'AL2'),
('F-G094', 'AF', 'AL2'),
('F-G095', 'AF', 'AL2'),
('F-G096', 'AF', 'AL2'),
('F-G097', 'AF', 'AL2'),
('F-G098', 'AF', 'AL2'),
('F-G099', 'AF', 'AL2'),
('F-G100', 'AF', 'AL4'),
('F-G101', 'AF', 'AL4'),
('F-G102', 'AF', 'AL4'),
('F-G103', 'AF', 'AL4'),
('F-G104', 'AF', 'AL4'),
('F-G105', 'AF', 'AL4'),
('F-G106', 'AF', 'AL4'),
('F-G107', 'AF', 'AL4'),
('F-G108', 'AF', 'AL4'),
('F-G109', 'AF', 'AL4'),
('F-G110', 'AF', 'AL4'),
('F-G111', 'AF', 'AL4'),
('F-G112', 'AF', 'AL4'),
('F-G113', 'AF', 'AL4'),
('F-G114', 'AF', 'AL4'),
('F-G115', 'AF', 'AL4'),
('F-G116', 'AF', 'AL4'),
('F-G117', 'AF', 'AL4'),
('F-G118', 'AF', 'AL4'),
('F-G119', 'AF', 'AL4'),
('F-G120', 'AF', 'AL4'),
('F-G121', 'AF', 'AL4'),
('F-G122', 'AF', 'AL4'),
('F-G123', 'AF', 'AL4'),
('F-G124', 'AF', 'AL4'),
('F-G125', 'AF', 'AL6'),
('F-G126', 'AF', 'AL6'),
('F-G127', 'AF', 'AL6'),
('F-G128', 'AF', 'AL6'),
('F-G129', 'AF', 'AL6'),
('F-G130', 'AF', 'AL6'),
('F-G131', 'AF', 'AL6'),
('F-G132', 'AF', 'AL6'),
('F-G133', 'AF', 'AL6'),
('F-G134', 'AF', 'AL6'),
('FP1', 'BA', 'AL2'),
('FP11', 'BA', 'AL9'),
('FP18', 'QR', 'AL15'),
('FP19', 'QR', 'AL6'),
('FP2', 'BA', 'AL5'),
('FP20', 'QR', 'AL14'),
('G-B001', 'BA', 'AL2'),
('G-B002', 'BA', 'AL2'),
('G-B003', 'BA', 'AL2'),
('G-B004', 'BA', 'AL2'),
('G-B005', 'BA', 'AL2'),
('G-B006', 'BA', 'AL2'),
('G-B007', 'BA', 'AL2'),
('G-B008', 'BA', 'AL2'),
('G-B009', 'BA', 'AL2'),
('G-B010', 'BA', 'AL2'),
('G-B011', 'BA', 'AL2'),
('G-B012', 'BA', 'AL2'),
('G-B013', 'BA', 'AL9'),
('G-B014', 'BA', 'AL9'),
('G-B015', 'BA', 'AL9'),
('G-B016', 'BA', 'AL9'),
('G-B017', 'BA', 'AL9'),
('G-B018', 'BA', 'AL9'),
('G-B019', 'BA', 'AL9'),
('G-B020', 'BA', 'AL9'),
('G-B021', 'BA', 'AL9'),
('G-B022', 'BA', 'AL9'),
('G-B023', 'BA', 'AL9'),
('VH-00', 'QF', 'AL7'),
('VH-01', 'QF', 'AL7'),
('VH-010', 'QF', 'AL7'),
('VH-011', 'QF', 'AL7'),
('VH-02', 'QF', 'AL7'),
('VH-03', 'QF', 'AL7'),
('VH-04', 'QF', 'AL7'),
('VH-05', 'QF', 'AL7'),
('VH-06', 'QF', 'AL7'),
('VH-07', 'QF', 'AL7'),
('VH-08', 'QF', 'AL7'),
('VH-09', 'QF', 'AL7'),
('VT-00', 'AI', 'AL11'),
('VT-01', 'AI', 'AL11'),
('VT-010', 'AI', 'AL11'),
('VT-011', 'AI', 'AL11'),
('VT-012', 'AI', 'AL11'),
('VT-013', 'AI', 'AL11'),
('VT-014', 'AI', 'AL11'),
('VT-015', 'AI', 'AL11'),
('VT-016', 'AI', 'AL11'),
('VT-017', 'AI', 'AL11'),
('VT-018', 'AI', 'AL2'),
('VT-019', 'AI', 'AL2'),
('VT-02', 'AI', 'AL11'),
('VT-020', 'AI', 'AL2'),
('VT-021', 'AI', 'AL2'),
('VT-022', 'AI', 'AL2'),
('VT-023', 'AI', 'AL2'),
('VT-024', 'AI', 'AL2'),
('VT-025', 'AI', 'AL2'),
('VT-026', 'AI', 'AL2'),
('VT-027', 'AI', 'AL2'),
('VT-028', 'AI', 'AL2'),
('VT-029', 'AI', 'AL2'),
('VT-03', 'AI', 'AL11'),
('VT-04', 'AI', 'AL11'),
('VT-05', 'AI', 'AL11'),
('VT-06', 'AI', 'AL11'),
('VT-07', 'AI', 'AL11'),
('VT-08', 'AI', 'AL11'),
('VT-09', 'AI', 'AL11');

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

--
-- Structure de la table `moteurs`
--

CREATE TABLE `moteurs` (
  `ID_Moteur` varchar(4) COLLATE latin1_general_cs NOT NULL,
  `ID_MoteurFull` varchar(25) COLLATE latin1_general_cs NOT NULL,
  `Type` varchar(15) COLLATE latin1_general_cs NOT NULL,
  `Fabricant` varchar(30) COLLATE latin1_general_cs NOT NULL,
  `Famille` varchar(10) COLLATE latin1_general_cs NOT NULL,
  `Série` varchar(10) COLLATE latin1_general_cs NOT NULL,
  `Modèle` varchar(10) COLLATE latin1_general_cs NOT NULL,
  `Poussée` decimal(5,2) NOT NULL COMMENT 'Poussée maximale au décollage (kN)',
  `Longueur` smallint(6) NOT NULL COMMENT '(mm)'
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_general_cs COMMENT='Moteurs pour avion de ligne';

--
-- Contenu de la table `moteurs`
--

INSERT INTO `moteurs` (`ID_Moteur`, `ID_MoteurFull`, `Type`, `Fabricant`, `Famille`, `Série`, `Modèle`, `Poussée`, `Longueur`) VALUES
('M1', 'GE90-115B', 'Turboréacteur', 'General Electrics', 'GE90', '', '115B', '512.00', 7289),
('M10', 'GP7270', 'Turboréacteur', 'Engine Alliance', 'GP', '7200', '70', '332.00', 4740),
('M11', 'RR RB211 Trent 970-84', 'Turboréacteur', 'Rolls-Royce', 'Trent', '900', '970', '334.00', 5477),
('M12', 'RR RB211 Trent 972-84', 'Turboréacteur', 'Rolls-Royce', 'Trent', '900', '972-84', '341.00', 5477),
('M13', 'GEnx-2B-67', 'Turboréacteur', 'General Electrics', 'GEnx', '2B', '67', '296.00', 4310),
('M14', 'GE CF34-10E', 'Turboréacteur', 'General Electrics', 'CF34', '10', '10E', '89.00', 3700),
('M15', 'CFM56-5B4', 'Turboréacteur', 'CFM International', 'CFM56', '5B', '5B4', '120.00', 2500),
('M16', 'CFM56-5B3', 'Turboréacteur', 'CFM International', 'CFM56', '5B', '5B3', '150.00', 2500),
('M17', 'CFM56-5B1', 'Turboréacteur', 'CFM International', 'CFM56', '5B', '5B1', '130.00', 2500),
('M18', 'IAE V2530-A5', 'Turboréacteur', 'International Aero Engines', 'V2500', '', 'V2530-A5', '140.00', 3200),
('M19', 'IAE V2533-A5', 'Turboréacteur', 'International Aero Engines', 'V2500', '', 'V2533-A5', '147.00', 3200),
('M2', 'GE90-94B', 'Turboréacteur', 'General Electrics', 'GE90', '', '94B', '425.00', 7289),
('M3', 'PW4090', 'Turboréacteur', 'Pratt&Whitney', 'PW4000', '112', 'PW4090', '400.00', 4851),
('M5', 'RR RB211 Trent 977-84', 'Turboréacteur', 'Rolls-Royce', 'Trent', '900', '977-84', '359.00', 5477),
('M6', 'RR RB211 Trent 977B-84', 'Turboréacteur', 'Rolls-Royce', 'Trent', '900', '977B-84', '373.00', 5477),
('M7', 'RR Trent XWB-75', 'Turboréacteur', 'Rolls-Royce', 'Trent', '1700', '75', '337.00', 5218),
('M8', 'RR Trent XWB-84', 'Turboréacteur', 'Rolls-Royce', 'Trent', '1700', '84', '374.00', 5218),
('M9', 'RR Trent XWB-97', 'Turboréacteur', 'Rolls-Royce', 'Trent', '1700', '97', '432.00', 5218);

--
-- Index pour les tables exportées
--

--
-- Index pour la table `avions_ligne`
--
ALTER TABLE `avions_ligne`
  ADD PRIMARY KEY (`ID_AL`),
  ADD UNIQUE KEY `ID` (`ID_AL`);

--
-- Index pour la table `compagnies_aériennes`
--
ALTER TABLE `compagnies_aériennes`
  ADD PRIMARY KEY (`ID_Compagnie`),
  ADD UNIQUE KEY `ID_Compagnie` (`ID_Compagnie`);

--
-- Index pour la table `flotte`
--
ALTER TABLE `flotte`
  ADD PRIMARY KEY (`Immatriculation`),
  ADD UNIQUE KEY `Id_FPass` (`Immatriculation`);

--
-- Index pour la table `moteurs`
--
ALTER TABLE `moteurs`
  ADD PRIMARY KEY (`ID_Moteur`),
  ADD UNIQUE KEY `ID_Moteur` (`ID_MoteurFull`),
  ADD UNIQUE KEY `ID_Moteur_2` (`ID_Moteur`),
  ADD KEY `ID_MoteurFull` (`ID_MoteurFull`),
  ADD KEY `ID_MoteurFull_2` (`ID_MoteurFull`);

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;