-- phpMyAdmin SQL Dump
-- version 5.2.0
-- https://www.phpmyadmin.net/
--
-- Hôte : db
-- Généré le : mar. 07 fév. 2023 à 16:29
-- Version du serveur : 8.0.31
-- Version de PHP : 8.0.26

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
START TRANSACTION;
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 : `polaris`
--

--
-- Déchargement des données de la table `category_aircraft`
--

INSERT INTO `category_aircraft` (`id`, `name`) VALUES
(1, 'PLANE'),
(2, 'SEA PLANE'),
(3, 'HELICOPTER'),
(4, 'ULTRA-LIGHT'),
(5, 'MOTOGLIDER'),
(6, 'GLIDER');

--
-- Déchargement des données de la table `class_aircraft`
--

INSERT INTO `class_aircraft` (`id`, `name`) VALUES
(1, 'SEP LAND'),
(2, 'AMPHIBIAN'),
(3, 'SET LAND'),
(4, 'SET'),
(5, 'CLASS 1'),
(6, 'CLASS 2'),
(7, 'CLASS 3'),
(8, 'CLASS 4'),
(9, 'CLASS 5'),
(10, 'CLASS 6'),
(11, 'TMG'),
(12, 'CLUB'),
(13, '15 M'),
(14, 'LIBRE'),
(15, 'STANDARD'),
(16, 'MONDIAL'),
(17, 'DUAL'),
(18, '18 M');

--
-- Déchargement des données de la table `engine_type_aircraft`
--

INSERT INTO `engine_type_aircraft` (`id`, `name`) VALUES
(1, 'Piston'),
(2, 'Turboprop'),
(3, 'None'),
(4, 'Turbofan');

--
-- Déchargement des données de la table `manufacturer_aircraft`
--

INSERT INTO `manufacturer_aircraft` (`id`, `name`) VALUES
(1, 'ROBIN'),
(2, 'CESSNA'),
(3, 'AIR-TRACTOR'),
(4, 'BELL'),
(5, 'CORSAIR'),
(6, 'PARAMANIA'),
(7, 'TAKEOGG'),
(8, 'COSMOS'),
(9, 'AEROPO'),
(10, 'DYNAERO'),
(11, 'ELA'),
(12, 'MAGNI'),
(13, 'CELIER'),
(14, 'TRIXY AVIATION'),
(15, 'BALLONS CHAIZE'),
(16, 'HELISPORT'),
(17, 'LAMBADA'),
(18, 'SCHEIBE'),
(19, 'STEMME'),
(20, 'LANGE ANTARES'),
(21, 'JANTAR'),
(22, 'ASW22'),
(23, 'NIMBUS'),
(24, 'ALEXANDER SCHLEICHER'),
(25, 'PIPER AIRCRAFT'),
(26, 'CIRRUS DESIGN'),
(27, 'DIAMOND'),
(28, 'MORANE-SAULNIER'),
(29, 'SOCATA'),
(30, 'FOURNIER'),
(31, 'ALPI AVIATION'),
(32, 'APEX'),
(33, 'MUDRY'),
(34, 'DYN\'AERO'),
(35, 'EXTRA AIRCRAFT'),
(36, 'CURTIS PITTS'),
(37, 'GRUMMAN AMERICA');

--
-- Déchargement des données de la table `model_aircraft`
--

INSERT INTO `model_aircraft` (`id`, `name`, `engine_type_id`, `category_id`, `manufacturer_id`) VALUES
(1, 'ATL', 1, 1, 1),
(2, ' Ambassadeur', 1, 1, 1),
(3, 'Ambassadeur', 1, 1, 1),
(4, 'Sicile', 1, 1, 1),
(5, 'Sicile-Record', 1, 1, 1),
(6, 'Excellence', 1, 1, 1),
(7, 'DR-200', 1, 1, 1),
(8, 'Capitaine', 1, 1, 1),
(9, 'B', 1, 1, 32),
(10, '2+2', 1, 1, 1),
(11, 'A 2+2', 1, 1, 1),
(12, 'AB 2+2', 1, 1, 1),
(13, 'Dauphin', 1, 1, 1),
(14, 'Régent', 1, 1, 1),
(15, 'Major', 1, 1, 1),
(16, 'Petit-Prince', 1, 1, 1),
(17, 'Chevalier', 1, 1, 1),
(18, 'Prince', 1, 1, 1),
(19, 'L\'Acrobat', 1, 1, 1),
(20, '108 2+2', 1, 1, 1),
(21, '180R Major', 1, 1, 1),
(22, '125', 1, 1, 1),
(23, '140', 1, 1, 1),
(24, 'Dauphin 2+2', 1, 1, 1),
(25, 'REMO 180', 1, 1, 1),
(26, 'REMO 200', 1, 1, 1),
(27, 'HR 100', 1, 1, 1),
(28, 'HR 200', 1, 1, 1),
(29, 'R 1180', 1, 1, 1),
(30, 'R 2112', 1, 1, 1),
(31, 'R 2160', 1, 1, 1),
(32, 'R 3000', 1, 1, 1),
(33, '200', 1, 1, 35),
(34, '200A', 1, 1, 1),
(35, '200B', 1, 1, 1),
(36, '210F Safari', 1, 1, 1),
(37, '320 Tiara', 1, 1, 1),
(38, '285 Tiara', 1, 1, 1),
(39, '235TR', 1, 1, 1),
(40, '250TR Président', 1, 1, 1),
(41, '320 4+2', 1, 1, 1),
(42, 'HR-200', 1, 1, 1),
(43, 'Aiglon', 1, 1, 1),
(44, 'T-Aiglon', 1, 1, 1),
(45, 'TD-Aiglon', 1, 1, 1),
(46, 'Club', 1, 1, 1),
(47, 'Alpha', 1, 1, 1),
(48, 'Sport', 1, 1, 1),
(49, 'Alpha Sport', 1, 1, 1),
(50, '120', 1, 1, 34),
(51, '120D', 1, 1, 1),
(52, '160', 1, 1, 1),
(53, '160S', 1, 1, 1),
(54, 'C150', 1, 1, 2),
(55, 'C150-Aerobat', 1, 1, 2),
(56, 'C152', 1, 1, 2),
(57, 'C152-Aerobat', 1, 1, 2),
(58, 'R-Skyhawk', 1, 1, 2),
(59, 'S-Skyhawk', 1, 1, 2),
(60, 'RG-Cutlass', 1, 1, 2),
(61, 'A-Cardinal', 1, 1, 2),
(62, 'B-Cardinal', 1, 1, 2),
(63, 'RG-Cardinal', 1, 1, 2),
(64, 'Skywagon', 1, 1, 2),
(65, 'C182', 1, 1, 2),
(66, 'C182A-Skylane', 1, 1, 2),
(67, 'C182C', 1, 1, 2),
(68, 'C182E-Skylane', 1, 1, 2),
(69, 'C182N-Skylane', 1, 1, 2),
(70, 'C182Q-Skylane', 1, 1, 2),
(71, 'R182-Skylane RG', 1, 1, 2),
(72, 'TR182-Turbo Skylane RG', 1, 1, 2),
(73, 'C182R', 1, 1, 2),
(74, 'T182', 1, 1, 2),
(75, '182S Skylane', 1, 1, 2),
(76, 'T182T Skylane', 1, 1, 2),
(77, 'Stationair', 1, 1, 2),
(78, 'Soloy Mk1', 2, 1, 2),
(79, 'Sloloy Mk2', 2, 1, 2),
(80, 'Centurion', 1, 1, 2),
(81, 'Corvalis TTX', 1, 1, 2),
(82, 'Caravan I', 2, 1, 2),
(83, 'Caravan 675', 2, 1, 2),
(84, 'Cargomaster', 2, 1, 2),
(85, 'Grand Caravan', 2, 1, 2),
(86, 'Super Cargomaster', 2, 1, 2),
(87, 'Caravan Amphibian', 2, 2, 2),
(88, 'Soloy PathFinder 21', 2, 1, 2),
(89, 'AT-400', 2, 1, 3),
(90, 'AT-401', 2, 1, 3),
(91, 'AT-402', 2, 1, 3),
(92, 'AT-502', 2, 1, 3),
(93, 'AT-602', 2, 1, 3),
(94, 'AT-802F', 2, 2, 3),
(95, '206L', 2, 3, 4),
(96, '206L1', 2, 3, 4),
(97, '206L3', 2, 3, 4),
(98, '206L4', 2, 3, 4),
(99, '206LT', 2, 3, 4),
(100, '407', 2, 3, 4),
(101, 'M25Y', 1, 4, 5),
(102, 'GT26', 1, 4, 6),
(103, '1200', 1, 4, 7),
(104, '582', 1, 4, 8),
(105, '503', 1, 4, 8),
(106, '447', 1, 4, 8),
(107, 'Jaribu', 1, 4, 10),
(108, '912', 1, 4, 9),
(109, '4S 912ULS', 1, 4, 10),
(110, '912S', 1, 4, 10),
(111, '07 914', 1, 4, 11),
(112, 'M16', 1, 4, 12),
(113, 'RST', 1, 4, 13),
(114, 'Rotax 914 Turbo', 1, 4, 14),
(115, 'JZ 18', 1, 4, 15),
(116, 'JZ 20', 1, 4, 15),
(117, 'JZ 22', 1, 4, 15),
(118, 'JZ 25', 1, 4, 15),
(119, 'JZ 30', 1, 4, 15),
(120, 'JZ 35', 1, 4, 15),
(121, 'JZ 40', 1, 4, 15),
(122, 'CS 1600', 1, 4, 15),
(123, 'CS 1800', 1, 4, 15),
(124, 'CS 2000', 1, 4, 15),
(125, 'CS 3000', 1, 4, 15),
(126, 'CS 4000', 1, 4, 15),
(127, 'CS 5000', 1, 4, 15),
(128, 'DC 67', 1, 4, 15),
(129, 'DC 70', 1, 4, 15),
(130, 'DC 77', 1, 4, 15),
(131, 'Kompress', 1, 4, 16),
(132, 'Lambada', 1, 5, 17),
(133, 'SF28', 1, 5, 18),
(134, 'S10', 1, 5, 19),
(135, 'S10-V', 1, 5, 19),
(136, 'S10-VT', 1, 5, 19),
(137, 'S10-15', 1, 5, 19),
(138, '20E', 1, 5, 20),
(139, 'STD 3', 3, 6, 21),
(140, 'D-6856', 3, 6, 22),
(141, '3', 3, 6, 23),
(142, 'ASK 21', 3, 6, 24),
(143, 'ASK 21 Mi', 3, 6, 24),
(144, 'ASW 12', 3, 6, 24),
(145, 'ASW 15', 3, 6, 24),
(146, 'ASW 17', 3, 6, 24),
(147, 'ASW 19', 3, 6, 24),
(148, 'Cub', 1, 1, 25),
(149, 'Cub Coupe', 1, 1, 25),
(150, 'Cub Cruiser', 1, 1, 25),
(151, 'Cub Special', 1, 1, 25),
(152, 'Cuper Cruiser', 1, 1, 25),
(153, 'Family Cruiser', 1, 1, 25),
(154, 'Super Cub', 1, 1, 25),
(155, 'Pacer', 1, 1, 25),
(156, 'PA21', 1, 1, 25),
(157, 'Apache', 1, 1, 25),
(158, 'Aztec', 1, 1, 25),
(159, 'Comanche', 1, 1, 25),
(160, 'Pawnee', 1, 1, 25),
(161, 'Cherokee', 1, 1, 25),
(162, 'Warrior', 1, 1, 25),
(163, 'Archer', 1, 1, 25),
(164, 'Dakota', 1, 1, 25),
(165, 'Arrow', 1, 1, 25),
(166, 'Twin Comanche', 1, 1, 25),
(167, 'Chieftain', 1, 1, 25),
(168, 'Mojave', 1, 1, 25),
(169, 'Navajo', 1, 1, 25),
(170, 'Cheyenne', 1, 1, 25),
(171, 'Cherokee Six', 1, 1, 25),
(172, 'Lance', 1, 1, 25),
(173, 'Saratoga', 1, 1, 25),
(174, 'Seneca', 1, 1, 25),
(175, 'Pawnee Brave', 1, 1, 25),
(176, 'Tomahawk', 1, 1, 25),
(177, 'Seminole', 1, 1, 25),
(178, 'Malibu', 1, 1, 25),
(179, 'Mirage', 1, 1, 25),
(180, 'Meridian', 1, 1, 25),
(181, 'Matrix', 1, 1, 25),
(182, 'Piper Jet', 1, 1, 25),
(183, 'VK-30', 1, 1, 26),
(184, 'SRV', 1, 1, 26),
(185, 'SR22', 1, 1, 26),
(186, 'SR22 T', 1, 1, 26),
(187, 'SF50', 1, 1, 26),
(188, 'Katana', 1, 1, 27),
(189, 'Star 180', 1, 1, 27),
(190, 'Star TDI', 1, 1, 27),
(191, 'DA 40-F', 1, 1, 27),
(192, 'TDI Twin Star', 1, 1, 27),
(193, '360 Twin Star', 1, 1, 27),
(194, 'VI', 1, 1, 27),
(195, 'MPP', 1, 1, 27),
(196, 'Opale', 1, 1, 27),
(197, 'Super Star', 1, 1, 27),
(198, 'Magnum', 1, 1, 27),
(199, 'D-JET', 1, 1, 27),
(200, 'MS 880', 1, 1, 28),
(201, 'MS 881', 1, 1, 28),
(202, 'MS 883', 1, 1, 28),
(203, 'MS 885', 1, 1, 28),
(204, 'MS 886', 1, 1, 28),
(205, 'MS 890', 1, 1, 28),
(206, 'MS 892', 1, 1, 28),
(207, 'MS 893', 1, 1, 28),
(208, 'MS 894 Minerva', 1, 1, 28),
(209, 'MS 110 Galopin', 1, 1, 28),
(210, 'GY-80', 1, 1, 29),
(211, 'Diplomate', 1, 1, 29),
(212, 'Tampico', 1, 1, 29),
(213, 'Tobago', 1, 1, 29),
(214, 'Tobago XL', 1, 1, 29),
(215, 'Trinidad', 1, 1, 29),
(216, 'TC Trinidad', 1, 1, 29),
(217, 'Epsilon', 1, 1, 29),
(218, 'TBM 700', 1, 1, 29),
(219, 'TBM 850', 1, 1, 29),
(220, 'TBM 900', 1, 1, 29),
(221, 'RF-2', 1, 5, 30),
(222, 'RF-3', 1, 5, 30),
(223, 'RF4', 1, 5, 30),
(224, 'RF-5', 1, 5, 30),
(225, 'RF-6', 1, 1, 30),
(226, 'RF-7', 1, 1, 30),
(227, 'RF-8', 1, 5, 30),
(228, 'RF-10', 1, 5, 30),
(229, 'RF-47', 1, 1, 30),
(230, '200S Sparrow', 1, 4, 31),
(231, '200 SDT', 1, 4, 31),
(232, '230', 1, 4, 31),
(233, 'Kite ULM', 1, 4, 31),
(234, 'Kite LSA', 1, 1, 31),
(235, 'Hawk', 1, 4, 31),
(236, '400', 1, 1, 31),
(237, 'AH 130', 1, 4, 31),
(238, 'C', 1, 1, 32),
(239, 'CAP 20', 1, 1, 33),
(240, 'CAP 20 L', 1, 1, 33),
(241, 'CAP 21', 1, 1, 33),
(242, 'CAP 230', 1, 1, 33),
(243, 'CAP 231', 1, 1, 33),
(244, 'EX', 1, 1, 33),
(245, 'CAP 232', 1, 1, 33),
(246, 'SC', 1, 1, 33),
(247, 'MXS', 1, 1, 33),
(248, '100', 1, 1, 34),
(249, '100 T', 1, 1, 34),
(250, '110', 1, 1, 34),
(251, '300', 1, 1, 35),
(252, '300S', 1, 1, 35),
(253, '300L', 1, 1, 35),
(254, '300LP', 1, 1, 35),
(255, '330', 1, 1, 35),
(256, '330LC', 1, 1, 35),
(257, '330SC', 1, 1, 35),
(258, 'S1', 1, 1, 36),
(259, 'S-1C', 1, 1, 36),
(260, 'S-1D', 1, 1, 36),
(261, 'S-1E', 1, 1, 36),
(262, 'S-1F', 1, 1, 36),
(263, 'S-1S', 1, 1, 36),
(264, 'S-1T', 1, 1, 36),
(265, 'S-1-11B', 1, 1, 36),
(266, 'S-2A', 1, 1, 36),
(267, 'S-2B', 1, 1, 36),
(268, 'S-2C', 1, 1, 36),
(269, 'S-2E', 1, 1, 36),
(270, 'S-2S', 1, 1, 36),
(271, 'AA-5', 1, 1, 37),
(272, 'AA-5A', 1, 1, 37),
(273, 'AA-5B', 1, 1, 37),
(274, 'AG-5B', 1, 1, 37);

--
-- Déchargement des données de la table `type_aircraft`
--

INSERT INTO `type_aircraft` (`id`, `name`, `manufacturer_id`) VALUES
(1, 'ATL', 1),
(2, 'DR-105A', 1),
(3, 'DR-1050', 1),
(4, 'DR-1051', 1),
(5, 'DR-1050 MM1', 1),
(6, 'DR-1051 MM1', 1),
(7, 'DR-1050 M', 1),
(8, 'DR-1051 M', 1),
(9, 'DR-200', 1),
(10, 'DR-250', 1),
(11, 'DR-220', 1),
(12, 'DR-221', 1),
(13, 'DR-253', 1),
(14, 'DR-340', 1),
(15, 'DR-315', 1),
(16, 'DR-360', 1),
(17, 'DR-380', 1),
(18, 'DR-330', 1),
(19, 'DR-300', 1),
(20, 'DR 400', 1),
(21, 'HR 100', 1),
(22, 'HR 200', 1),
(23, 'R 1180', 1),
(24, 'R 2112', 1),
(25, 'R 2160', 1),
(26, 'R 3000', 1),
(27, 'HR-100', 1),
(28, 'HR-200', 1),
(29, 'R-1180', 1),
(30, 'R-2100', 1),
(31, 'R-2112', 1),
(32, 'R-2160', 1),
(33, 'R-2120', 1),
(34, 'R-3000', 1),
(35, 'C150', 2),
(36, 'C152', 2),
(37, 'C172', 2),
(38, 'C177', 2),
(39, 'C180', 2),
(40, 'C182', 2),
(41, 'C206', 2),
(42, 'C210', 2),
(43, 'C350', 2),
(44, 'C400', 2),
(45, 'C208 CARAVAN', 2),
(46, 'AT', 3),
(47, '206', 4),
(48, '407', 4),
(49, 'M25Y', 5),
(50, 'Action', 6),
(51, 'Merlin', 7),
(52, 'Phase 2', 8),
(53, 'Bidulm', 8),
(54, 'Eurofox', 9),
(55, 'MCR', 10),
(56, 'COUGAR', 11),
(57, 'M16', 12),
(58, 'XENON', 13),
(59, 'Liberty', 14),
(60, 'Cross-over', 15),
(61, 'Cloud Surfer', 15),
(62, 'Dawn Chaser', 15),
(63, 'CH-7', 16),
(64, 'Lambada', 17),
(65, 'SF28', 18),
(66, 'S10', 19),
(67, '20E', 20),
(68, 'STD 3', 21),
(69, 'D-6856', 22),
(70, '3', 23),
(71, 'ASK21', 24),
(72, 'ASW', 24),
(73, 'J3', 25),
(74, 'J4', 25),
(75, 'J5', 25),
(76, 'PA-11', 25),
(77, 'PA-12', 25),
(78, 'PA-14', 25),
(79, 'PA-18', 25),
(80, 'PA-20', 25),
(81, 'PA-21', 25),
(82, 'PA-23', 25),
(83, 'PA-24', 25),
(84, 'PA-25', 25),
(85, 'PA-28', 25),
(86, 'PA-30', 25),
(87, 'PA-31', 25),
(88, 'PA-32', 25),
(89, 'PA-34', 25),
(90, 'PA-36', 25),
(91, 'PA-38', 25),
(92, 'PA-42', 25),
(93, 'PA-44', 25),
(94, 'PA-46', 25),
(95, 'PA-47', 25),
(96, 'VK-30', 26),
(97, 'SR20', 26),
(98, 'SR22', 26),
(99, 'Vision', 26),
(100, 'DA 20', 27),
(101, 'DA 40', 27),
(102, 'DA 42', 27),
(103, 'DA 50', 27),
(104, 'D-JET', 27),
(105, 'Rallye', 28),
(106, 'Gardan', 29),
(107, 'ST 10', 29),
(108, 'TB 9', 29),
(109, 'TB 10', 29),
(110, 'TB 200', 29),
(111, 'TB 20', 29),
(112, 'TB 21', 29),
(113, 'TB 30', 29),
(114, 'TBM 700', 29),
(115, 'TBM 850', 29),
(116, 'TBM 900', 29),
(117, 'RF-2', 30),
(118, 'RF-3', 30),
(119, 'RF-4', 30),
(120, 'RF-5', 30),
(121, 'RF-6', 30),
(122, 'RF-7', 30),
(123, 'RF-8', 30),
(124, 'RF-10', 30),
(125, 'RF-47', 30),
(126, 'PIONEER', 31),
(127, 'SYTON', 31),
(128, 'CAP 10', 32),
(129, 'CAP 20', 33),
(130, 'CAP 21', 33),
(131, 'CAP 230', 33),
(132, 'CAP 231', 33),
(133, 'CAP 232', 33),
(134, 'CAP 332', 33),
(135, 'CAP 432', 33),
(136, 'CR', 34),
(137, 'EXTRA', 35),
(138, 'PITTS', 36),
(139, 'GRUMMAN', 37);

--
-- Déchargement des données de la table `class_aircraft_model_aircraft`
--

INSERT INTO `class_aircraft_model_aircraft` (`class_aircraft_id`, `model_aircraft_id`) VALUES
(1, 1),
(1, 2),
(1, 3),
(1, 4),
(1, 5),
(1, 6),
(1, 7),
(1, 8),
(1, 9),
(1, 10),
(1, 11),
(1, 12),
(1, 13),
(1, 14),
(1, 15),
(1, 16),
(1, 17),
(1, 18),
(1, 19),
(1, 20),
(1, 21),
(1, 22),
(1, 23),
(1, 24),
(1, 25),
(1, 26),
(1, 27),
(1, 28),
(1, 29),
(1, 30),
(1, 31),
(1, 32),
(1, 33),
(1, 34),
(1, 35),
(1, 36),
(1, 37),
(1, 38),
(1, 39),
(1, 40),
(1, 41),
(1, 42),
(1, 43),
(1, 44),
(1, 45),
(1, 46),
(1, 47),
(1, 48),
(1, 49),
(1, 50),
(1, 51),
(1, 52),
(1, 53),
(1, 54),
(1, 55),
(1, 56),
(1, 57),
(1, 58),
(1, 59),
(1, 60),
(1, 61),
(1, 62),
(1, 63),
(1, 64),
(1, 65),
(1, 66),
(1, 67),
(1, 68),
(1, 69),
(1, 70),
(1, 71),
(1, 72),
(1, 73),
(1, 74),
(1, 75),
(1, 76),
(1, 77),
(1, 80),
(1, 81),
(1, 148),
(1, 149),
(1, 150),
(1, 151),
(1, 152),
(1, 153),
(1, 154),
(1, 155),
(1, 156),
(1, 157),
(1, 158),
(1, 159),
(1, 160),
(1, 161),
(1, 162),
(1, 163),
(1, 164),
(1, 165),
(1, 166),
(1, 167),
(1, 168),
(1, 169),
(1, 170),
(1, 171),
(1, 172),
(1, 173),
(1, 174),
(1, 175),
(1, 176),
(1, 177),
(1, 183),
(1, 184),
(1, 185),
(1, 186),
(1, 188),
(1, 189),
(1, 190),
(1, 191),
(1, 192),
(1, 193),
(1, 194),
(1, 195),
(1, 196),
(1, 197),
(1, 198),
(1, 200),
(1, 201),
(1, 202),
(1, 203),
(1, 204),
(1, 205),
(1, 206),
(1, 207),
(1, 208),
(1, 209),
(1, 210),
(1, 211),
(1, 212),
(1, 213),
(1, 214),
(1, 215),
(1, 216),
(1, 217),
(1, 221),
(1, 222),
(1, 223),
(1, 224),
(1, 225),
(1, 226),
(1, 227),
(1, 228),
(1, 229),
(1, 234),
(1, 236),
(1, 238),
(1, 239),
(1, 240),
(1, 241),
(1, 242),
(1, 243),
(1, 244),
(1, 245),
(1, 246),
(1, 247),
(1, 248),
(1, 249),
(1, 250),
(1, 251),
(1, 252),
(1, 253),
(1, 254),
(1, 255),
(1, 256),
(1, 257),
(1, 258),
(1, 259),
(1, 260),
(1, 261),
(1, 262),
(1, 263),
(1, 264),
(1, 265),
(1, 266),
(1, 267),
(1, 268),
(1, 269),
(1, 270),
(1, 271),
(1, 272),
(1, 273),
(1, 274),
(2, 87),
(2, 94),
(3, 78),
(3, 79),
(3, 82),
(3, 83),
(3, 84),
(3, 85),
(3, 86),
(3, 88),
(3, 89),
(3, 90),
(3, 91),
(3, 92),
(3, 93),
(3, 94),
(3, 178),
(3, 179),
(3, 180),
(3, 181),
(3, 182),
(3, 187),
(3, 199),
(3, 218),
(3, 219),
(3, 220),
(4, 95),
(4, 96),
(4, 97),
(4, 98),
(4, 99),
(4, 100),
(5, 101),
(5, 102),
(6, 103),
(6, 104),
(6, 105),
(6, 106),
(7, 107),
(7, 108),
(7, 109),
(7, 110),
(7, 230),
(7, 231),
(7, 232),
(7, 233),
(7, 235),
(8, 111),
(8, 112),
(8, 113),
(8, 114),
(9, 115),
(9, 116),
(9, 117),
(9, 118),
(9, 119),
(9, 120),
(9, 121),
(9, 122),
(9, 123),
(9, 124),
(9, 125),
(9, 126),
(9, 127),
(9, 128),
(9, 129),
(9, 130),
(10, 131),
(10, 237),
(11, 132),
(11, 133),
(11, 134),
(11, 135),
(11, 136),
(11, 137),
(11, 138),
(12, 139),
(12, 147),
(13, 140),
(14, 141),
(15, 142),
(16, 143),
(17, 144),
(17, 145),
(18, 146);

--
-- Déchargement des données de la table `type_aircraft_model_aircraft`
--

INSERT INTO `type_aircraft_model_aircraft` (`type_aircraft_id`, `model_aircraft_id`) VALUES
(1, 1),
(2, 2),
(3, 3),
(3, 4),
(4, 3),
(4, 4),
(5, 5),
(6, 5),
(7, 6),
(8, 6),
(9, 7),
(10, 8),
(10, 9),
(11, 10),
(11, 11),
(11, 12),
(12, 9),
(12, 13),
(13, 9),
(13, 14),
(14, 15),
(15, 16),
(16, 17),
(17, 18),
(18, 19),
(19, 20),
(19, 21),
(19, 22),
(19, 23),
(20, 14),
(20, 15),
(20, 24),
(20, 25),
(20, 26),
(21, 27),
(22, 28),
(23, 29),
(24, 30),
(25, 31),
(26, 32),
(27, 33),
(27, 34),
(27, 35),
(27, 36),
(27, 37),
(27, 38),
(27, 39),
(27, 40),
(27, 41),
(28, 42),
(29, 43),
(29, 44),
(29, 45),
(30, 46),
(31, 47),
(32, 48),
(32, 49),
(33, 47),
(34, 23),
(34, 50),
(34, 51),
(34, 52),
(34, 53),
(35, 54),
(35, 55),
(36, 56),
(36, 57),
(37, 58),
(37, 59),
(37, 60),
(38, 61),
(38, 62),
(38, 63),
(39, 64),
(40, 65),
(40, 66),
(40, 67),
(40, 68),
(40, 69),
(40, 70),
(40, 71),
(40, 72),
(40, 73),
(40, 74),
(40, 75),
(40, 76),
(41, 77),
(41, 78),
(41, 79),
(42, 80),
(43, 81),
(44, 81),
(45, 82),
(45, 83),
(45, 84),
(45, 85),
(45, 86),
(45, 87),
(45, 88),
(46, 89),
(46, 90),
(46, 91),
(46, 92),
(46, 93),
(46, 94),
(47, 95),
(47, 96),
(47, 97),
(47, 98),
(47, 99),
(48, 100),
(49, 101),
(50, 102),
(51, 103),
(52, 104),
(52, 105),
(53, 106),
(54, 107),
(54, 108),
(55, 107),
(55, 109),
(55, 110),
(56, 111),
(57, 112),
(58, 113),
(59, 114),
(60, 115),
(60, 116),
(60, 117),
(60, 118),
(60, 119),
(60, 120),
(60, 121),
(61, 122),
(61, 123),
(61, 124),
(61, 125),
(61, 126),
(61, 127),
(62, 128),
(62, 129),
(62, 130),
(63, 131),
(64, 132),
(65, 133),
(66, 134),
(66, 135),
(66, 136),
(66, 137),
(67, 138),
(68, 139),
(69, 140),
(70, 141),
(71, 142),
(71, 143),
(72, 144),
(72, 145),
(72, 146),
(72, 147),
(73, 148),
(74, 149),
(75, 150),
(76, 151),
(77, 152),
(78, 153),
(79, 154),
(80, 155),
(81, 156),
(82, 157),
(82, 158),
(83, 159),
(84, 160),
(85, 161),
(85, 162),
(85, 163),
(85, 164),
(85, 165),
(86, 166),
(87, 167),
(87, 168),
(87, 169),
(87, 170),
(88, 171),
(88, 172),
(88, 173),
(89, 174),
(90, 175),
(91, 176),
(92, 170),
(93, 177),
(94, 178),
(94, 179),
(94, 180),
(94, 181),
(95, 182),
(96, 183),
(97, 184),
(98, 185),
(98, 186),
(99, 187),
(100, 188),
(101, 189),
(101, 190),
(101, 191),
(102, 192),
(102, 193),
(102, 194),
(102, 195),
(102, 196),
(103, 197),
(103, 198),
(104, 199),
(105, 200),
(105, 201),
(105, 202),
(105, 203),
(105, 204),
(105, 205),
(105, 206),
(105, 207),
(105, 208),
(105, 209),
(106, 210),
(107, 211),
(108, 212),
(109, 213),
(110, 214),
(111, 215),
(112, 216),
(113, 217),
(114, 218),
(115, 219),
(116, 220),
(117, 221),
(118, 222),
(119, 223),
(120, 224),
(121, 225),
(122, 226),
(123, 227),
(124, 228),
(125, 229),
(126, 230),
(126, 231),
(126, 232),
(126, 233),
(126, 234),
(126, 235),
(126, 236),
(127, 237),
(128, 9),
(128, 238),
(129, 239),
(129, 240),
(130, 241),
(131, 242),
(132, 243),
(132, 244),
(133, 245),
(134, 246),
(135, 247),
(136, 50),
(136, 248),
(136, 249),
(136, 250),
(137, 33),
(137, 251),
(137, 252),
(137, 253),
(137, 254),
(137, 255),
(137, 256),
(137, 257),
(138, 258),
(138, 259),
(138, 260),
(138, 261),
(138, 262),
(138, 263),
(138, 264),
(138, 265),
(138, 266),
(138, 267),
(138, 268),
(138, 269),
(138, 270),
(139, 271),
(139, 272),
(139, 273),
(139, 274);
COMMIT;

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