use Transport;

DROP TABLE IF EXISTS `TransportRecursif`;

CREATE TABLE `TransportRecursif`(
        `idTransport`         Int AUTO_INCREMENT NOT NULL,
        `typeTransport`       Varchar (25) NOT NULL,
        `commentTransport`  Text,
        `id_type_pere`      Int,
        PRIMARY KEY  (`idTransport`),
        CONSTRAINT FK_id_transport_type_pere FOREIGN KEY (`id_type_pere`) REFERENCES TransportRecursif(`idTransport`)
);

SET FOREIGN_KEY_CHECKS=0;
TRUNCATE TABLE `TransportRecursif`;
DELETE from `TransportRecursif`;
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
INSERT INTO `TransportRecursif` (`idTransport`, `typeTransport`, `id_type_pere`) VALUES (0, 'Transport', NULL);
SET FOREIGN_KEY_CHECKS=1;

INSERT INTO `TransportRecursif` (`typeTransport`, `id_type_pere`) VALUES
('Terrestre', 0),
('Marin', 0),
('Aérien', 0),
('Voiture', 0),
('Camion', 1),
('Moto', 1),
('Vélo', 1),
('Hélico', 3),
('Avion', 3),
('ULM', 3),
('Fusée', 3),
('Parachute', 3),
('Planeur', 3),
('Voilier', 2),
('Paquebot', 2),
('Planche à voile', 2),
('Moto_Roadster', 6),
('Moto_Side-car', 6),
('Chasse', 9),
('Boeing_747', 9);