zM7q9A8n

1ALTER TABLE airatlantiquecsharp.vols DROP FOREIGN KEY vols_ibfk_1;`
2DROP TABLE IF EXISTS `avions`;
3CREATE TABLE IF NOT EXISTS `avions` (
4  `idAvion` int(11) NOT NULL AUTO_INCREMENT,
5  `modele` varchar(50) NOT NULL,
6  `motorisation` varchar(50) NOT NULL,
7  `capacite` smallint(6) NOT NULL,
8  `nb_place_premium` int(11) NOT NULL,
9  `nb_place_business` int(11) NOT NULL,
10  `nb_place_eco` int(11) NOT NULL,
11  `etat` int(11) NOT NULL,
12  `type` int(11) NOT NULL,
13  PRIMARY KEY (`idAvion`)
14) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8_general_ci;
15
16INSERT INTO `avions` (`idAvion`, `modele`, `motorisation` , `capacite`, `etat`, `nb_place_premium`, `nb_place_business`, `nb_place_eco`, `type`) VALUES
17(1, 'AirBus A300','RAF 2', 380, 0, 60, 40, 280, 0),
18(2, 'AirBus A300','Koerting 8 SL', 325, 0, 50, 35, 280, 1),
19(3, 'AirBus A300','Ivchenko AI-14', 380, 0, 60, 40, 250, 0),
20(4, 'AirBus A300','RAF 2', 380, 0, 60, 35, 280, 1),
21(5, 'AirBus A350','Ivchenko AI-14', 380, 0, 60, 40, 280, 0),
22(6, 'AirBus A318','Koerting 8 SL', 325, 0, 60, 40, 280, 0),
23(7, 'AirBus A318','RAF 2', 380, 0, 60, 40, 250, 0),
24(8, 'AirBus A300','Ivchenko AI-14', 380, 0, 50, 35, 280, 1),
25(9, 'AirBus A300','Hirth HM 8', 380, 0, 60, 40, 280, 0),
26(10, 'AirBus AA318','Ivchenko AI-14', 325, 0, 60, 40, 280, 0),
27(11, 'AirBus A300','RAF 2', 380, 0, 60, 40, 250, 1),
28(12, 'AirBus A300','Koerting 8 SL', 325, 0, 60, 35, 280, 0),
29(13, 'AirBus AA318','RAF 2', 380, 0, 50, 40, 280, 1),
30(14, 'AirBus A300','Ivchenko AI-14', 380, 0, 60, 40, 280, 0),
31(15, 'AirBus A300','Hirth HM 8', 325, 0, 50, 40, 250, 1),
32(16, 'AirBus A300','RAF 2', 380, 0, 60, 40, 280, 0),
33(17, 'AirBus A300','Ivchenko AI-14', 380, 0, 60, 35, 280, 1),
34(18, 'AirBus AA318','Koerting 8 SL', 380, 0, 60, 40, 280, 0),
35(19, 'AirBus A300','Hirth HM 8', 325, 0, 60, 40, 250, 1),
36(20, 'AirBus A300','RAF 2', 380, 0, 50, 35, 280, 0),
37(21, 'AirBus AA318','Ivchenko AI-14', 380, 0, 60, 40, 280, 0),
38(22, 'AirBus A300','RAF 2', 325, 0, 60, 40, 280, 1),
39(23, 'AirBus A350','Koerting 8 SL', 380, 0, 50, 35, 250, 0),
40(24, 'AirBus A300','RAF 2', 250, 0, 60, 40, 280, 1),
41(25, 'AirBus A350','Ivchenko AI-14', 380, 0, 50, 40, 250, 0);
42
43ALTER TABLE `vols` ADD FOREIGN KEY (`id_avion`) REFERENCES `avions`(`idAvion`) ON DELETE RESTRICT ON UPDATE RESTRICT;