INF4211 - TP

querry.sql

-- Creating the basic table structure

CREATE TABLE `Bateaux` (
    `noBateau` int  NOT NULL AUTO_INCREMENT,
    `nom` varchar(50)  NOT NULL ,
    `type` varchar(50)  NOT NULL ,
    PRIMARY KEY (
        `noBateau`
    )
);

CREATE TABLE `Clients` (
    `noClient` int  NOT NULL AUTO_INCREMENT,
    `noAdresse` int  NOT NULL ,
    `nom` varchar(100)  NOT NULL ,
    `email` varchar(100)  NOT NULL ,
    `responsable` varchar(100)  NOT NULL ,
    PRIMARY KEY (
        `noClient`
    )
);

CREATE TABLE `Ports` (
    `noPort` int  NOT NULL AUTO_INCREMENT,
    `noPays` int  NOT NULL ,
    `nom` varchar(100) NOT NULL ,
    PRIMARY KEY (
        `noPort`
    )
);

CREATE TABLE `Pays` (
    `noPays` int  NOT NULL AUTO_INCREMENT,
    `nom` varchar(100)  NOT NULL ,
    `tarif` decimal(10, 2)  NOT NULL ,
    PRIMARY KEY (
        `noPays`
    )
);

CREATE TABLE `Commandes` (
    `noCommandes` int  NOT NULL AUTO_INCREMENT,
    `noVoyage` int  NOT NULL ,
    `noDestination` int  NOT NULL ,
    `noClient` int  NOT NULL ,
    `nombreContainer` int  NOT NULL ,
    `poids` float  NOT NULL ,
    `valeur` float  NOT NULL ,
    PRIMARY KEY (
        `noCommandes`
    )
);

CREATE TABLE `Employes` (
    `noEmploye` int  NOT NULL AUTO_INCREMENT,
    `noAdresse` int  NOT NULL ,
    `noMetier` int  NOT NULL ,
    `nom` varchar(100)  NOT NULL ,
    `citoyennete` varchar(100)  NOT NULL ,
    `age` int  NOT NULL ,
    PRIMARY KEY (
        `noEmploye`
    )
);

CREATE TABLE `Adresses` (
    `noAdresse` int  NOT NULL AUTO_INCREMENT,
    `adresse` varchar(100)  NOT NULL ,
    `ville` varchar(100)  NOT NULL ,
    `pays` varchar(100)  NOT NULL ,
    `telephone` varchar(100)  NOT NULL ,
    `courriel` varchar(100)  NOT NULL ,
    PRIMARY KEY (
        `noAdresse`
    )
);

CREATE TABLE `Metiers` (
    `noMetier` int  NOT NULL AUTO_INCREMENT,
    `nom` varchar(100) NOT NULL ,
    `tauxHoraire` float  NOT NULL ,
    PRIMARY KEY (
        `noMetier`
    )
);

CREATE TABLE `Etapes` (
    `noEtape` int  NOT NULL AUTO_INCREMENT,
    `noVoyage` int  NOT NULL ,
    `noOrigine` int  NOT NULL ,
    `noDestination` int  NOT NULL ,
    `etapePrecedente` int DEFAULT NULL,
    `status` varchar(50)  NOT NULL ,
    `depart` datetime  NOT NULL ,
    `ordre` int  NOT NULL ,
    `dateArrivee` datetime  NULL ,
    PRIMARY KEY (
        `noEtape`
    )
);

CREATE TABLE `Voyages` (
    `noVoyage` int  NOT NULL AUTO_INCREMENT,
    `noOrigine` int  NOT NULL ,
    `noDestination` int  NOT NULL ,
    `noCapitaine` int  NOT NULL ,
    `noBateau` int  NOT NULL ,
    `type` varchar(50)  NOT NULL ,
    `status` varchar(50)  NOT NULL ,
    `depart` datetime  NOT NULL ,
    PRIMARY KEY (
        `noVoyage`
    )
);



ALTER TABLE `Voyages` ADD CONSTRAINT `fk_Voyage_noOrigine` FOREIGN KEY(`noOrigine`)
REFERENCES `Ports` (`noPort`);

ALTER TABLE `Voyages` ADD CONSTRAINT `fk_Voyage_noDestination` FOREIGN KEY(`noDestination`)
REFERENCES `Ports` (`noPort`);

ALTER TABLE `Voyages` ADD CONSTRAINT `fk_Voyage_noCapitaine` FOREIGN KEY(`noCapitaine`)
REFERENCES `Employes` (`noEmploye`);

ALTER TABLE `Voyages` ADD CONSTRAINT `fk_Voyage_noBateau` FOREIGN KEY(`noBateau`)
REFERENCES `Bateaux` (`noBateau`);

ALTER TABLE `Etapes` ADD CONSTRAINT `fk_Etape_noVoyage` FOREIGN KEY(`noVoyage`)
REFERENCES `Voyages` (`noVoyage`);

ALTER TABLE `Etapes` ADD CONSTRAINT `fk_Etape_noOrigine` FOREIGN KEY(`noOrigine`)
REFERENCES `Ports` (`noPort`);

ALTER TABLE `Etapes` ADD CONSTRAINT `fk_Etape_noDestination` FOREIGN KEY(`noDestination`)
REFERENCES `Ports` (`noPort`);

ALTER TABLE `Etapes` ADD CONSTRAINT `fk_Etape_prochaineEtape` FOREIGN KEY(`etapePrecedente`)
REFERENCES `Etapes` (`noEtape`);

ALTER TABLE `Clients` ADD CONSTRAINT `fk_Client_noAdresse` FOREIGN KEY(`noAdresse`)
REFERENCES `Adresses` (`noAdresse`);

ALTER TABLE `Ports` ADD CONSTRAINT `fk_Port_noPays` FOREIGN KEY(`noPays`)
REFERENCES `Pays` (`noPays`);

ALTER TABLE `Commandes` ADD CONSTRAINT `fk_Charge_noVoyage` FOREIGN KEY(`noVoyage`)
REFERENCES `Voyages` (`noVoyage`);

ALTER TABLE `Commandes` ADD CONSTRAINT `fk_Charge_noDestination` FOREIGN KEY(`noDestination`)
REFERENCES `Ports` (`noPort`);

ALTER TABLE `Commandes` ADD CONSTRAINT `fk_Charge_noClient` FOREIGN KEY(`noClient`)
REFERENCES `Clients` (`noClient`);

ALTER TABLE `Employes` ADD CONSTRAINT `fk_Employes_noAdresse` FOREIGN KEY(`noAdresse`)
REFERENCES `Adresses` (`noAdresse`);

ALTER TABLE `Employes` ADD CONSTRAINT `fk_Employes_noMetier` FOREIGN KEY(`noMetier`)
REFERENCES `Metiers` (`noMetier`);

CREATE INDEX `idx_Bateau_nom`
ON `Bateaux` (`nom`);

CREATE INDEX `idx_Voyage_noOrigine`
ON `Voyages` (`noOrigine`);

CREATE INDEX `idx_Voyage_noDestination`
ON `Voyages` (`noDestination`);

CREATE INDEX `idx_Etape_noOrigine`
ON `Etapes` (`noOrigine`);

CREATE INDEX `idx_Etape_noDestination`
ON `Etapes` (`noDestination`);

CREATE INDEX `idx_Client_nom`
ON `Clients` (`nom`);

-- Creating the roles and users.

CREATE ROLE `directeur`, `superviseur`, `vendeur`;

GRANT SELECT, INSERT, UPDATE, DELETE ON Bateaux to directeur;

GRANT SELECT, INSERT, UPDATE, DELETE ON Employes to superviseur;
GRANT SELECT, INSERT, UPDATE, DELETE ON Adresses to superviseur;
GRANT SELECT, INSERT, UPDATE, DELETE ON Metiers to superviseur;
GRANT SELECT, INSERT, UPDATE, DELETE ON Voyages to superviseur;
GRANT SELECT, INSERT, UPDATE, DELETE ON Etapes to superviseur;
GRANT SELECT, INSERT, UPDATE, DELETE ON Pays to superviseur;
GRANT SELECT, INSERT, UPDATE, DELETE ON Ports to superviseur;
GRANT SELECT ON Commandes to superviseur;

GRANT SELECT, INSERT, UPDATE, DELETE ON Clients to vendeur;
GRANT SELECT, INSERT, UPDATE, DELETE ON Adresses to vendeur;
GRANT SELECT, INSERT, UPDATE, DELETE ON Commandes to vendeur;
GRANT SELECT ON Voyages to vendeur;
GRANT SELECT ON Ports to vendeur;

CREATE USER 'directeur'@'localhost' IDENTIFIED BY 'passworddirecteur';
GRANT 'directeur' TO 'directeur'@'localhost';

CREATE USER 'superviseur'@'localhost' IDENTIFIED BY 'passwordsuperviseur';
GRANT 'superviseur' TO 'superviseur'@'localhost';

CREATE USER 'vendeur'@'localhost' IDENTIFIED BY 'passwordvendeur';
GRANT 'vendeur' TO 'vendeur'@'localhost';

-- Inserer les donnés d'exemple dans la basse de données

INSERT INTO `Adresses` (`noAdresse`, `adresse`, `ville`, `pays`, `telephone`, `courriel`) VALUES
('1', '93, place de Bertrand', 'Leroux', 'Érythrée', '+33 (0)4 95 24 04 15', '[email protected]'),
('2', 'chemin de Thibault', 'Klein-la-Forêt', 'Yemen', '01 12 55 97 49', '[email protected]'),
('3', '89, boulevard de Philippe', 'Guilbert', 'Cocos (Îles)', '+33 (0)1 67 39 99 14', '[email protected]'),
('4', '59, impasse Devaux', 'Reynaudboeuf', 'Nauru', '+33 (0)7 33 78 32 67', '[email protected]'),
('5', '714, place Fouquet', 'Lecomte-les-Bains', 'Belize', '+33 (0)9 49 35 21 58', '[email protected]'),
('6', '62, boulevard Laroche', 'Gallet-sur-Baron', 'Honduras', '+33 (0)6 38 32 14 49', '[email protected]'),
('7', '3, chemin Devaux', 'Marion-sur-Pages', 'Gambie', '+33 (0)8 97 80 59 00', '[email protected]'),
('8', 'avenue Denis', 'BoulangerBourg', 'Bolivie', '+33 6 37 22 85 15', '[email protected]'),
('9', '8, chemin Michelle Boucher', 'Herve-les-Bains', 'Uruguay', '+33 (0)2 70 73 61 51', '[email protected]'),
('10', '71, chemin de Boyer', 'Moreau', 'Tunisie', '+33 1 46 99 71 27', '[email protected]'),
('11', '21, place Deschamps', 'Chauvet', 'Tuvalu', '+33 5 77 22 02 70', '[email protected]'),
('12', '86, boulevard Lelievre', 'Thierry', 'Polynésie française', '07 55 31 69 00', '[email protected]'),
('13', '89, boulevard Ferrand', 'Leblanc', 'Ouganda', '08 93 22 49 46', '[email protected]'),
('14', '64, avenue de Marty', 'Cordier', 'Guyane', '0146259142', '[email protected]'),
('15', 'rue Fernandez', 'Hamon', 'Bouvet (Îles)', '+33 9 16 47 26 94', '[email protected]'),
('16', '46, impasse Hebert', 'Dupuynec', 'Laos', '+33 (0)3 65 63 52 38', '[email protected]'),
('17', '65, avenue Techer', 'Barbe', 'Irlande', '+33 4 10 20 50 38', '[email protected]'),
('18', '181, place Maurice Rey', 'Bouvier', 'Afrique du sud', '0800840773', '[email protected]'),
('19', '4, chemin de Godard', 'Guillou', 'Ouganda', '0740784923', '[email protected]'),
('20', '1, chemin Lucas Seguin', 'Loiseau-sur-Hoareau', 'Chine (Rép. pop.)', '+33 (0)9 59 04 53 17', '[email protected]'),
('21', 'rue Rémy Letellier', 'Poirier-sur-Navarro', 'Belize', '03 44 11 95 32', '[email protected]'),
('22', '69, avenue Louis Cordier', 'Guyotnec', 'Danemark', '05 25 43 70 12', '[email protected]'),
('23', 'chemin Alexandre Letellier', 'Delaunay-sur-Blanc', 'Saint-Marin (Rép. de)', '+33 2 16 41 23 22', '[email protected]'),
('24', '7, impasse Margot Marchal', 'Laporte', 'Myanmar', '06 61 51 49 97', '[email protected]'),
('25', '27, boulevard Carre', 'Berger', 'Tchad', '+33 2 37 05 64 60', '[email protected]'),
('26', '64, boulevard Torres', 'Michel', 'Slovénie', '03 32 97 79 86', '[email protected]'),
('27', '74, boulevard de Payet', 'Goncalves', 'Soudan', '02 47 39 48 96', '[email protected]'),
('28', '788, boulevard Maillard', 'Faivre', 'Lesotho', '+33 1 72 62 94 78', '[email protected]'),
('29', 'impasse de Thierry', 'GarciaBourg', 'Antarctique', '07 66 04 71 11', '[email protected]'),
('30', 'boulevard Hugues Potier', 'Michel', 'Vietnam', '0506545511', '[email protected]'),
('31', '302, chemin de Georges', 'Diallo', 'Syrie', '+33 (0)1 11 58 39 77', '[email protected]'),
('32', 'rue Antoine Chretien', 'Noel', 'Arménie', '+33 (0)3 85 89 52 41', '[email protected]'),
('33', 'chemin de Leleu', 'Poulain', 'Royaume-Uni', '+33 (0)7 37 62 75 74', '[email protected]'),
('34', '4, impasse Perrot', 'Camusboeuf', 'Singapour', '+33 (0)1 07 77 78 24', '[email protected]'),
('35', '32, impasse Georges Gimenez', 'Barre-sur-Moreno', 'Chili', '0116162300', '[email protected]'),
('36', '238, avenue de Laine', 'Maillard', 'Tchad', '+33 4 46 00 40 38', '[email protected]'),
('37', '2, impasse Legendre', 'Dos Santos', 'Angola', '0771428540', '[email protected]'),
('38', '40, chemin Hardy', 'BerthelotVille', 'Seychelles', '05 15 72 01 31', '[email protected]'),
('39', '53, chemin Ribeiro', 'Fleurydan', 'Sierra Leone', '07 63 81 21 95', '[email protected]'),
('40', '50, rue Célina Noel', 'Vasseur-sur-Garcia', 'Turks et Caïques (Îles)', '04 68 14 15 65', '[email protected]'),
('41', '214, boulevard Alexandre', 'Legerdan', 'Pakistan', '+33 1 20 17 03 40', '[email protected]'),
('42', '75, chemin de Leconte', 'Lopesboeuf', 'Israël', '+33 (0)1 11 02 99 10', '[email protected]'),
('43', '20, impasse Théophile Roux', 'Gay', 'Danemark', '0694833102', '[email protected]'),
('44', '3, avenue Carpentier', 'Poirier-sur-Guillet', 'Pologne', '+33 1 98 73 08 77', '[email protected]'),
('45', '99, boulevard de Gilles', 'Blot', 'Estonie', '+33 5 35 10 58 97', '[email protected]'),
('46', '31, boulevard Bernadette Hardy', 'Bruneau', 'Seychelles', '05 17 34 82 32', '[email protected]'),
('47', '20, rue Gros', 'Royer', 'Timor', '+33 2 79 62 66 11', '[email protected]'),
('48', '564, rue de Dos Santos', 'Lebon', 'Ouganda', '02 15 47 98 59', '[email protected]'),
('49', '57, avenue Vincent', 'Charrier', 'Égypte', '+33 6 78 93 77 13', '[email protected]'),
('50', '6, impasse Dufour', 'Pichon', 'Zaïre', '+33 9 02 62 69 42', '[email protected]');

INSERT INTO `Bateaux` (`noBateau`, `nom`, `type`) VALUES
('1', 'Titanic', 'Regulier'),
('2', 'ARM Cuauhtemoc', 'Regulier'),
('3', 'ARM Tizon', 'Regulier'),
('4', 'MS Antenor', 'Regulier'),
('5', 'USS Oregon', 'Regulier'),
('6', 'MS Costa Allegra', 'Regulier'),
('7', 'MS Costa Solar', 'Regulier'),
('8', 'MS Courusant', 'Regulier'),
('9', 'MS Playa', 'Regulier'),
('10', 'MS Las Piedras', 'Regulier'),
('11', 'Nauvoo Galactic Republic', 'Express'),
('12', 'Milenial Flacoln', 'Express'),
('13', 'Lord Vader', 'Express'),
('14', 'The Emperor', 'Express'),
('15', 'USS Texas', 'Regulier'),
('16', 'USS Washington', 'Regulier'),
('17', 'HSMS Monréal', 'Express'),
('18', 'HSMS Calgary', 'Express'),
('19', 'HSMS Toronto', 'Express'),
('20', 'Mayapan', 'Express'),
('21', 'Uxmal', 'Express'),
('22', 'HSMS Vancouver', 'Express');

INSERT INTO `Clients` (`noClient`, `noAdresse`, `nom`, `email`, `responsable`) VALUES
('1', '10', 'Da Costa', '[email protected]', 'Édith Gillet'),
('2', '20', 'Wagner SAS', '[email protected]', 'Brigitte-Frédérique Marin'),
('3', '30', 'Delaunay S.A.R.L.', '[email protected]', 'Aurélie David'),
('4', '29', 'Robert Giraud S.A.', '[email protected]', 'Gabrielle Jacob'),
('5', '27', 'Vidal Valette S.A.S.', '[email protected]', 'Antoinette Legrand'),
('6', '5', 'Blot', '[email protected]', 'Hélène Leblanc'),
('7', '2', 'Guillon Mathieu SAS', '[email protected]', 'Honoré de la Bouvier'),
('8', '9', 'Devaux SA', '[email protected]', 'Martin Brunet'),
('9', '19', 'Teixeira', '[email protected]', 'Thierry-Benjamin Baron'),
('10', '2', 'Martins', '[email protected]', 'Daniel Petit-Moulin'),
('11', '37', 'Guillou', '[email protected]', 'Laurence Techer-Le Roux'),
('12', '11', 'Francois Hubert S.A.S.', '[email protected]', 'Henri-Daniel Mercier'),
('13', '19', 'Hamel', '[email protected]', 'Grégoire Delmas-Morel'),
('14', '14', 'Bouchet', '[email protected]', 'Joseph Peltier'),
('15', '15', 'Gomez', '[email protected]', 'Thierry Gomez'),
('16', '34', 'Bourgeois S.A.R.L.', '[email protected]', 'Laure Joubert-Barbe'),
('17', '40', 'Berthelot S.A.R.L.', '[email protected]', 'Pauline Guillaume-Lebon'),
('18', '13', 'Aubert', '[email protected]', 'Rémy Hoareau'),
('19', '40', 'Rousseau Richard SARL', '[email protected]', 'Claude Peron'),
('20', '2', 'Menard', '[email protected]', 'Thibaut Barthelemy'),
('21', '41', 'Bouvier SA', '[email protected]', 'Paul Jourdan'),
('22', '21', 'Menard', '[email protected]', 'Théophile Le Garcia'),
('23', '46', 'Julien SARL', '[email protected]', 'Alexandre Francois'),
('24', '28', 'Alexandre', '[email protected]', 'Christophe Garcia'),
('25', '1', 'Bonnin', '[email protected]', 'Margaud-Marie Petit'),
('26', '47', 'Boulanger SAS', '[email protected]', 'Victor Collet'),
('27', '14', 'Gregoire S.A.', '[email protected]', 'Amélie Texier'),
('28', '34', 'Peltier et Fils', '[email protected]', 'Thibaut Hernandez'),
('29', '42', 'Barbier Perrier SARL', '[email protected]', 'Luc Marechal'),
('30', '27', 'Chauveau SARL', '[email protected]', 'Michel Laurent'),
('31', '43', 'Lebon Loiseau et Fils', '[email protected]', 'Suzanne Lamy'),
('32', '46', 'Poulain', '[email protected]', 'Gilbert Guillaume'),
('33', '9', 'Carre', '[email protected]', 'Margot Aubry'),
('34', '23', 'Bernier Thibault S.A.R.L.', '[email protected]', 'Michèle Pires-Delattre'),
('35', '37', 'Gautier', '[email protected]', 'Geneviève Bigot'),
('36', '29', 'Clerc', '[email protected]', 'Susanne Gonzalez-Marechal'),
('37', '12', 'Gallet et Fils', '[email protected]', 'Frédéric Albert'),
('38', '23', 'Delannoy Didier S.A.S.', '[email protected]', 'Guillaume Ferrand'),
('39', '12', 'Rousset S.A.S.', '[email protected]', 'Claude-Guillaume Lejeune'),
('40', '45', 'Didier', '[email protected]', 'Catherine Devaux'),
('41', '12', 'Lesage Andre S.A.R.L.', '[email protected]', 'Geneviève Humbert'),
('42', '1', 'Pelletier Marques SA', '[email protected]', 'Thomas Lefevre'),
('43', '46', 'Guillot S.A.', '[email protected]', 'Marthe Breton'),
('44', '38', 'Faure', '[email protected]', 'Pierre Godard-De Sousa'),
('45', '9', 'Toussaint Dumas S.A.', '[email protected]', 'Michelle-Aimée Guyot'),
('46', '6', 'Lebreton', '[email protected]', 'Gabrielle Couturier-Perez'),
('47', '16', 'Georges Laporte SA', '[email protected]', 'Jérôme Charpentier'),
('48', '5', 'Hoarau Benoit S.A.S.', '[email protected]', 'Xavier Hoareau-Pelletier'),
('49', '48', 'Fischer Barbier S.A.', '[email protected]', 'Vincent de la Caron'),
('50', '34', 'Charpentier Perrier SAS', '[email protected]', 'Thierry-Théodore Richard');

INSERT INTO `Commandes` (`noCommandes`, `noVoyage`, `noDestination`, `noClient`, `nombreContainer`, `poids`, `valeur`) VALUES
('1', '101', '69', '38', '59', '20', '28149'),
('2', '39', '6', '20', '51', '98', '36103'),
('3', '46', '51', '17', '10', '92', '15935'),
('4', '44', '109', '20', '16', '57', '12556'),
('5', '165', '10', '31', '18', '82', '70851'),
('6', '99', '122', '33', '77', '2', '30308'),
('7', '70', '94', '29', '88', '27', '81816'),
('8', '26', '60', '21', '36', '28', '45446'),
('9', '55', '18', '15', '79', '75', '20249'),
('10', '60', '16', '20', '21', '39', '8340'),
('11', '149', '70', '39', '74', '26', '6090'),
('12', '171', '68', '25', '60', '31', '35514'),
('13', '5', '40', '48', '65', '77', '22342'),
('14', '168', '1', '29', '60', '15', '4892'),
('15', '82', '66', '36', '93', '89', '37701'),
('16', '129', '45', '7', '12', '40', '39469'),
('17', '82', '70', '17', '67', '5', '81099'),
('18', '19', '94', '16', '90', '5', '29837'),
('19', '190', '117', '12', '58', '29', '83107'),
('20', '158', '113', '36', '67', '83', '66594'),
('21', '7', '123', '27', '24', '39', '91017'),
('22', '39', '61', '13', '39', '95', '45946'),
('23', '54', '73', '4', '13', '9', '12171'),
('24', '102', '100', '26', '26', '70', '94614'),
('25', '178', '114', '44', '54', '58', '9183'),
('26', '176', '41', '46', '73', '24', '21066'),
('27', '150', '86', '25', '50', '58', '26418'),
('28', '4', '55', '31', '36', '58', '14098'),
('29', '184', '71', '24', '23', '28', '88326'),
('30', '177', '1', '22', '92', '76', '81430'),
('31', '162', '30', '26', '50', '7', '97538'),
('32', '87', '97', '3', '7', '99', '35055'),
('33', '160', '16', '14', '54', '82', '44870'),
('34', '62', '49', '36', '70', '20', '18492'),
('35', '103', '107', '32', '56', '9', '98935'),
('36', '93', '84', '48', '79', '59', '43363'),
('37', '34', '69', '4', '79', '51', '42555'),
('38', '15', '81', '4', '99', '2', '65791'),
('39', '1', '83', '50', '1', '50', '30939'),
('40', '168', '12', '4', '50', '95', '29707'),
('41', '142', '99', '30', '32', '70', '15470'),
('42', '177', '119', '37', '18', '71', '85622'),
('43', '49', '4', '45', '22', '88', '95071'),
('44', '3', '6', '24', '73', '71', '96841'),
('45', '120', '98', '33', '75', '39', '45814'),
('46', '103', '68', '24', '9', '100', '78019'),
('47', '172', '71', '5', '10', '37', '92744'),
('48', '160', '19', '19', '73', '84', '2960'),
('49', '33', '67', '50', '67', '4', '89255'),
('50', '159', '89', '9', '28', '59', '80478'),
('51', '140', '58', '12', '44', '52', '88734'),
('52', '53', '105', '13', '17', '91', '75338'),
('53', '152', '79', '38', '25', '61', '95272'),
('54', '148', '62', '17', '78', '18', '61745'),
('55', '153', '29', '21', '6', '28', '76524'),
('56', '152', '10', '4', '37', '12', '1641'),
('57', '119', '130', '42', '73', '50', '59253'),
('58', '186', '56', '24', '14', '60', '82608'),
('59', '109', '57', '17', '29', '86', '22245'),
('60', '137', '11', '49', '52', '45', '12397'),
('61', '57', '77', '40', '40', '41', '35830'),
('62', '23', '70', '12', '58', '100', '12251'),
('63', '151', '90', '20', '4', '75', '13141'),
('64', '47', '70', '41', '30', '7', '42018'),
('65', '160', '42', '11', '98', '9', '3911'),
('66', '136', '97', '4', '89', '50', '49585'),
('67', '188', '60', '10', '38', '1', '32037'),
('68', '142', '47', '26', '27', '2', '17643'),
('69', '16', '85', '11', '46', '96', '14495'),
('70', '34', '39', '24', '72', '68', '70658'),
('71', '171', '53', '8', '14', '19', '19214'),
('72', '129', '47', '10', '15', '10', '68022'),
('73', '157', '57', '23', '33', '87', '73388'),
('74', '162', '42', '2', '21', '8', '41635'),
('75', '139', '78', '39', '36', '7', '98010'),
('76', '41', '102', '14', '20', '11', '72978'),
('77', '1', '36', '16', '58', '79', '12279'),
('78', '45', '46', '31', '31', '13', '84674'),
('79', '62', '45', '27', '22', '41', '22087'),
('80', '162', '63', '36', '87', '38', '6085'),
('81', '49', '36', '42', '19', '58', '90148'),
('82', '183', '98', '5', '64', '78', '64452'),
('83', '8', '81', '2', '8', '33', '55668'),
('84', '173', '50', '41', '4', '53', '55599'),
('85', '55', '20', '35', '2', '66', '71392'),
('86', '107', '97', '9', '88', '32', '98932'),
('87', '190', '96', '44', '26', '33', '77977'),
('88', '135', '102', '16', '11', '4', '37846'),
('89', '66', '12', '47', '96', '9', '354'),
('90', '167', '129', '38', '11', '34', '74621'),
('91', '164', '28', '21', '76', '91', '59490'),
('92', '30', '39', '19', '47', '1', '70828'),
('93', '199', '85', '36', '22', '34', '16467'),
('94', '37', '103', '50', '90', '74', '36489'),
('95', '128', '126', '13', '84', '11', '15275'),
('96', '3', '38', '47', '29', '46', '36267'),
('97', '116', '117', '41', '96', '47', '80582'),
('98', '35', '90', '19', '38', '86', '68910'),
('99', '71', '106', '44', '83', '25', '29902'),
('100', '46', '111', '45', '70', '90', '95665'),
('101', '196', '106', '47', '80', '57', '60163'),
('102', '68', '38', '17', '14', '1', '62917'),
('103', '141', '41', '27', '66', '91', '88134'),
('104', '80', '122', '12', '93', '52', '64207'),
('105', '188', '27', '28', '69', '90', '10468'),
('106', '181', '68', '2', '10', '14', '97957'),
('107', '70', '5', '17', '96', '28', '22529'),
('108', '47', '89', '39', '77', '71', '80057'),
('109', '33', '104', '46', '4', '94', '2638'),
('110', '16', '47', '35', '24', '53', '23683'),
('111', '50', '10', '2', '12', '26', '20355'),
('112', '16', '59', '49', '43', '72', '95824'),
('113', '76', '64', '34', '5', '53', '76478'),
('114', '100', '82', '44', '19', '41', '17563'),
('115', '82', '10', '19', '24', '92', '63818'),
('116', '171', '126', '30', '82', '43', '39951'),
('117', '169', '51', '49', '50', '18', '1733'),
('118', '145', '81', '3', '19', '81', '54328'),
('119', '11', '81', '22', '10', '35', '59558'),
('120', '140', '93', '16', '96', '10', '29222'),
('121', '178', '92', '45', '63', '16', '16618'),
('122', '154', '19', '21', '4', '75', '53100'),
('123', '149', '4', '12', '52', '93', '51789'),
('124', '152', '15', '34', '72', '57', '51894'),
('125', '75', '37', '49', '76', '38', '39818'),
('126', '54', '58', '41', '95', '45', '42461'),
('127', '123', '31', '45', '86', '39', '69939'),
('128', '74', '81', '5', '96', '51', '27064'),
('129', '18', '88', '5', '33', '32', '49695'),
('130', '64', '39', '24', '48', '42', '74311'),
('131', '178', '120', '47', '39', '99', '24142'),
('132', '113', '49', '5', '39', '40', '84762'),
('133', '90', '130', '28', '29', '74', '70111'),
('134', '130', '28', '33', '57', '64', '3390'),
('135', '12', '13', '42', '24', '15', '31168'),
('136', '105', '41', '7', '42', '37', '41666'),
('137', '128', '95', '49', '93', '40', '42566'),
('138', '199', '14', '48', '94', '33', '54627'),
('139', '34', '125', '28', '90', '91', '94435'),
('140', '29', '90', '48', '58', '18', '24710'),
('141', '190', '46', '27', '20', '64', '920'),
('142', '115', '75', '26', '12', '94', '55274'),
('143', '195', '96', '9', '9', '25', '42455'),
('144', '154', '84', '1', '81', '49', '45619'),
('145', '51', '67', '45', '65', '26', '48531'),
('146', '49', '10', '29', '89', '96', '91811'),
('147', '8', '129', '17', '58', '100', '95518'),
('148', '117', '95', '10', '54', '17', '99366'),
('149', '199', '12', '12', '59', '11', '80569'),
('150', '41', '33', '37', '25', '73', '85539'),
('151', '100', '118', '49', '70', '94', '17483'),
('152', '97', '4', '1', '4', '57', '38940'),
('153', '180', '52', '29', '45', '70', '96905'),
('154', '160', '31', '36', '98', '58', '50850'),
('155', '183', '121', '41', '42', '3', '68139'),
('156', '108', '80', '31', '62', '39', '45520'),
('157', '147', '55', '17', '38', '11', '42813'),
('158', '54', '81', '1', '31', '25', '57811'),
('159', '103', '12', '36', '44', '61', '84982'),
('160', '149', '46', '14', '88', '46', '24938'),
('161', '45', '69', '23', '94', '15', '45509'),
('162', '14', '92', '18', '5', '90', '58728'),
('163', '151', '28', '35', '77', '7', '54877'),
('164', '186', '67', '9', '65', '23', '39001'),
('165', '60', '85', '26', '51', '42', '94887'),
('166', '77', '66', '18', '21', '73', '49167'),
('167', '18', '1', '39', '30', '40', '36471'),
('168', '66', '5', '35', '96', '50', '79012'),
('169', '153', '126', '18', '38', '50', '89584'),
('170', '64', '117', '44', '26', '2', '53748'),
('171', '53', '73', '25', '12', '21', '17466'),
('172', '30', '27', '26', '32', '29', '36792'),
('173', '152', '28', '46', '1', '59', '16609'),
('174', '112', '84', '27', '65', '55', '97860'),
('175', '101', '44', '19', '30', '26', '10682'),
('176', '61', '129', '5', '12', '51', '38072'),
('177', '165', '29', '7', '42', '1', '29459'),
('178', '49', '124', '6', '6', '30', '87802'),
('179', '16', '78', '11', '34', '56', '41688'),
('180', '148', '37', '16', '54', '48', '34043'),
('181', '193', '63', '50', '9', '15', '61302'),
('182', '16', '108', '2', '64', '28', '30686'),
('183', '163', '26', '26', '19', '27', '43255'),
('184', '86', '98', '21', '46', '62', '44990'),
('185', '85', '6', '12', '4', '25', '74287'),
('186', '93', '65', '20', '52', '44', '2764'),
('187', '88', '30', '2', '50', '41', '72649'),
('188', '114', '44', '41', '68', '29', '65759'),
('189', '59', '88', '45', '70', '17', '84239'),
('190', '192', '51', '46', '82', '70', '12164'),
('191', '24', '24', '12', '16', '22', '67289'),
('192', '167', '118', '4', '88', '6', '26101'),
('193', '132', '38', '49', '85', '40', '59463'),
('194', '81', '62', '34', '42', '31', '13559'),
('195', '64', '77', '2', '87', '92', '25315'),
('196', '14', '19', '11', '27', '3', '25427'),
('197', '13', '101', '1', '45', '17', '85768'),
('198', '69', '75', '22', '9', '100', '31508'),
('199', '185', '112', '50', '22', '93', '78296'),
('200', '46', '128', '38', '74', '65', '68526'),
('201', '173', '73', '49', '100', '78', '27501'),
('202', '124', '12', '23', '60', '15', '17371'),
('203', '45', '81', '22', '87', '55', '14596'),
('204', '79', '20', '32', '45', '22', '7567'),
('205', '95', '17', '19', '12', '36', '97424'),
('206', '140', '73', '23', '45', '78', '69712'),
('207', '173', '130', '28', '15', '63', '27913'),
('208', '197', '85', '30', '69', '66', '86156'),
('209', '14', '129', '35', '81', '67', '18771'),
('210', '143', '48', '8', '8', '15', '20581'),
('211', '26', '98', '39', '89', '7', '22313'),
('212', '2', '24', '32', '78', '21', '68991'),
('213', '175', '77', '49', '30', '86', '14950'),
('214', '128', '80', '1', '56', '75', '13713'),
('215', '145', '63', '25', '56', '56', '22591'),
('216', '150', '80', '30', '15', '68', '4264'),
('217', '59', '22', '30', '56', '64', '8750'),
('218', '27', '110', '6', '1', '54', '25879'),
('219', '52', '128', '11', '83', '37', '57343'),
('220', '184', '56', '11', '7', '71', '61503'),
('221', '145', '75', '25', '44', '39', '42018'),
('222', '200', '51', '21', '97', '46', '80089'),
('223', '17', '95', '36', '44', '61', '69156'),
('224', '83', '11', '39', '73', '54', '81417'),
('225', '165', '108', '2', '28', '45', '51145'),
('226', '66', '72', '37', '87', '44', '79519'),
('227', '66', '30', '36', '98', '90', '55024'),
('228', '110', '67', '30', '71', '17', '78114'),
('229', '106', '35', '34', '26', '31', '48682'),
('230', '62', '7', '8', '96', '64', '53801'),
('231', '149', '79', '10', '89', '27', '4974'),
('232', '187', '101', '32', '94', '52', '61208'),
('233', '16', '23', '15', '18', '55', '75610'),
('234', '156', '55', '35', '92', '98', '98367'),
('235', '94', '71', '19', '16', '55', '79294'),
('236', '131', '76', '26', '55', '14', '89999'),
('237', '30', '5', '7', '65', '45', '41625'),
('238', '140', '13', '25', '50', '98', '77228'),
('239', '166', '98', '42', '83', '77', '26756'),
('240', '176', '15', '19', '65', '80', '1602'),
('241', '175', '127', '12', '86', '59', '45311'),
('242', '107', '11', '15', '69', '24', '34021'),
('243', '181', '2', '10', '65', '37', '67075'),
('244', '24', '122', '12', '78', '58', '81072'),
('245', '10', '117', '11', '68', '20', '74348'),
('246', '141', '85', '20', '11', '40', '2143'),
('247', '103', '105', '40', '95', '43', '40486'),
('248', '152', '124', '49', '91', '50', '96706'),
('249', '74', '24', '26', '16', '13', '79548'),
('250', '74', '99', '20', '23', '81', '7726'),
('251', '42', '35', '27', '20', '98', '36198'),
('252', '46', '120', '12', '26', '37', '50107'),
('253', '72', '65', '8', '11', '52', '19633'),
('254', '104', '8', '45', '99', '24', '17997'),
('255', '129', '109', '19', '67', '2', '77794'),
('256', '125', '92', '50', '48', '38', '49348'),
('257', '109', '24', '37', '69', '56', '75296'),
('258', '163', '35', '15', '86', '60', '84079'),
('259', '107', '83', '45', '17', '57', '99513'),
('260', '136', '21', '8', '89', '80', '13402'),
('261', '194', '82', '44', '2', '67', '8885'),
('262', '31', '92', '46', '98', '18', '22136'),
('263', '1', '42', '27', '74', '31', '90238'),
('264', '53', '40', '32', '88', '14', '1867'),
('265', '7', '27', '1', '60', '41', '94587'),
('266', '155', '3', '48', '26', '95', '12348'),
('267', '86', '62', '17', '60', '58', '3824'),
('268', '177', '125', '3', '39', '44', '52651'),
('269', '79', '66', '21', '95', '2', '53831'),
('270', '20', '90', '8', '4', '88', '7798'),
('271', '135', '110', '13', '63', '51', '19790'),
('272', '187', '25', '33', '56', '31', '46662'),
('273', '25', '130', '9', '9', '75', '83718'),
('274', '5', '62', '48', '75', '15', '801'),
('275', '132', '43', '33', '68', '57', '97146'),
('276', '75', '52', '3', '16', '72', '91666'),
('277', '169', '103', '49', '89', '13', '33546'),
('278', '54', '17', '24', '33', '67', '73481'),
('279', '104', '28', '44', '6', '54', '12177'),
('280', '194', '103', '2', '69', '38', '49466'),
('281', '36', '16', '29', '67', '35', '20610'),
('282', '114', '129', '36', '34', '52', '92709'),
('283', '187', '93', '13', '89', '30', '85483'),
('284', '159', '37', '11', '11', '53', '94125'),
('285', '195', '123', '27', '64', '5', '31498'),
('286', '125', '81', '34', '76', '21', '54689'),
('287', '4', '24', '38', '8', '32', '37782'),
('288', '107', '120', '13', '62', '15', '95747'),
('289', '161', '70', '27', '28', '37', '23527'),
('290', '185', '121', '37', '23', '32', '42492'),
('291', '85', '62', '15', '20', '21', '51200'),
('292', '136', '53', '46', '17', '26', '31576'),
('293', '23', '13', '23', '60', '36', '11244'),
('294', '103', '11', '4', '64', '35', '23253'),
('295', '142', '13', '13', '48', '80', '46774'),
('296', '180', '30', '1', '13', '10', '563'),
('297', '67', '1', '10', '20', '42', '68463'),
('298', '152', '129', '32', '57', '74', '5468'),
('299', '9', '94', '27', '27', '93', '7761'),
('300', '127', '72', '40', '17', '84', '56159');

INSERT INTO `Employes` (`noEmploye`, `noAdresse`, `noMetier`, `nom`, `citoyennete`, `age`) VALUES
('1', '47', '21', 'Roger Diallo', 'Lettonie', '48'),
('2', '15', '4', 'Tristan Sanchez', 'Cameroun', '52'),
('3', '21', '20', 'Marie-Henriette Moreau', 'Niue', '45'),
('4', '4', '2', 'Roland Aubert-Gaillard', 'Côte d\'Ivoire', '20'),
('5', '2', '25', 'Françoise Remy', 'Estonie', '29'),
('6', '4', '11', 'Frédéric Merle', 'Pologne', '49'),
('7', '28', '12', 'Isaac Da Costa', 'Philippines', '62'),
('8', '35', '13', 'Laurent-Roland Perrier', 'Suède', '47'),
('9', '37', '13', 'Thomas Bonneau', 'Afrique du sud', '21'),
('10', '40', '19', 'Antoine Brunel', 'Kirghizistan', '50'),
('11', '37', '23', 'Célina Marie', 'Finlande', '26'),
('12', '20', '7', 'Jean Gillet', 'Mariannes du Nord (Îles)', '57'),
('13', '34', '20', 'Suzanne Allain-Dupuis', 'Autriche', '51'),
('14', '7', '23', 'Noémi Fischer', 'France', '64'),
('15', '37', '24', 'Frédérique Boulanger-Bouvier', 'Égypte', '37'),
('16', '12', '14', 'Aurore Paul-Gaillard', 'Vatican (Etat du)', '52'),
('17', '47', '8', 'Margot Hardy-Lacroix', 'Mali', '62'),
('18', '5', '22', 'Xavier Louis', 'Kazakhstan', '48'),
('19', '37', '23', 'Susan Le Roux-Jacques', 'Venezuela', '25'),
('20', '4', '2', 'William Legendre', 'Cuba', '52'),
('21', '29', '24', 'Pierre Laurent', 'Espagne', '61'),
('22', '39', '5', 'Christophe-Joseph Cousin', 'Cayman (Îles)', '24'),
('23', '29', '21', 'Adélaïde Rodriguez-Dupuy', 'Wallis et Futuna (Îles)', '53'),
('24', '38', '3', 'Madeleine Reynaud', 'Antilles néerlandaises', '40'),
('25', '44', '2', 'Arthur Andre', 'Algérie', '63'),
('26', '8', '11', 'Adrien Perrin-Bodin', 'Andorre', '24'),
('27', '14', '9', 'Thomas Pereira', 'Christmas (Île)', '44'),
('28', '36', '11', 'Raymond Renault', 'Samoa', '18'),
('29', '29', '14', 'Eugène Boulanger', 'Grèce', '58'),
('30', '30', '12', 'Gabrielle Chevalier', 'République centrafricaine', '34'),
('31', '17', '25', 'Véronique Colin', 'Israël', '27'),
('32', '1', '8', 'Paulette Aubry', 'Érythrée', '41'),
('33', '41', '19', 'Théodore Guyon-Bailly', 'Émirats arabes unis', '43'),
('34', '39', '16', 'Lorraine-Thérèse Girard', 'Zambie', '54'),
('35', '46', '3', 'Théophile Perrier', 'Haïti', '31'),
('36', '11', '2', 'Nath Poirier', 'Afghanistan', '35'),
('37', '18', '5', 'Roland-Alexandre Francois', 'Timor', '43'),
('38', '22', '22', 'Timothée Fontaine-Barthelemy', 'Finlande', '60'),
('39', '30', '21', 'Sophie de la Evrard', 'Guinée', '31'),
('40', '18', '7', 'Caroline-Lucie Allard', 'Brésil', '63'),
('41', '33', '25', 'Thierry Legrand', 'Corée du Nord', '18'),
('42', '22', '5', 'Hugues Pasquier-Garcia', 'Ethiopie', '23'),
('43', '3', '14', 'Adrien Sanchez', 'Angola', '51'),
('44', '37', '4', 'Sophie Mallet-Regnier', 'Niue', '41'),
('45', '35', '10', 'Gérard Rey', 'Corée du Nord', '25'),
('46', '33', '13', 'Pierre Imbert', 'Sri Lanka', '40'),
('47', '45', '5', 'Marc de la Chartier', 'Martinique', '35'),
('48', '18', '13', 'Dominique Bodin', 'Iran', '27'),
('49', '37', '13', 'Olivie-Éléonore Dupont', 'Brésil', '24'),
('50', '15', '7', 'Capucine Barbe', 'Djibouti', '18'),
('51', '48', '17', 'Monique Hernandez-Humbert', 'Royaume-Uni', '44'),
('52', '6', '24', 'Cécile Gaillard-Paul', 'Malawi', '37'),
('53', '11', '17', 'William du Traore', 'République Dominicaine', '25'),
('54', '13', '13', 'Hortense Rodriguez', 'Kenya', '60'),
('55', '26', '16', 'Dorothée Rocher-Chartier', 'Ukraine', '41'),
('56', '7', '9', 'Alexandrie Samson', 'Zaïre', '32'),
('57', '10', '15', 'Julien Techer', 'Guyane française', '33'),
('58', '30', '16', 'Charles Blin', 'Afghanistan', '22'),
('59', '2', '1', 'Claudine Bouchet-Dias', 'Guam', '63'),
('60', '44', '13', 'Bernadette de la Devaux', 'Oman', '20'),
('61', '47', '2', 'Juliette Hoarau-Guyon', 'Chine (Rép. pop.)', '51'),
('62', '43', '20', 'Eugène de la Ledoux', 'Libye', '52'),
('63', '10', '1', 'Richard Boyer', 'Indonésie', '19'),
('64', '26', '17', 'Rémy Morin', 'Kirghizistan', '24'),
('65', '45', '12', 'Dominique Paris', 'Sri Lanka', '30'),
('66', '38', '16', 'Christiane Royer', 'Vierges (Îles)', '52'),
('67', '43', '23', 'Thibault-Édouard Lebreton', 'Micronésie (États fédérés de)', '22'),
('68', '21', '24', 'Adrienne Gay', 'Swaziland', '65'),
('69', '44', '7', 'Timothée du Lemaitre', 'Croatie', '37'),
('70', '1', '14', 'Stéphane de la Paris', 'Afrique du sud', '51'),
('71', '41', '18', 'Constance Gay', 'Liechtenstein', '33'),
('72', '6', '7', 'Franck Faure', 'Israël', '54'),
('73', '19', '6', 'Édith Schneider', 'Papouasie-Nouvelle-Guinée', '23'),
('74', '25', '13', 'Joséphine Hamon', 'Hongrie', '37'),
('75', '45', '6', 'Dominique de la Pineau', 'Afghanistan', '52'),
('76', '41', '7', 'Lucy Marion-Regnier', 'Tonga', '35'),
('77', '10', '6', 'Matthieu Millet', 'Malaisie', '19'),
('78', '28', '14', 'André Legendre', 'Liechtenstein', '61'),
('79', '26', '3', 'Daniel Lebrun', 'Corée du Nord', '48'),
('80', '50', '4', 'Édith-Aurélie Coste', 'Singapour', '45'),
('81', '1', '13', 'Alain Boyer', 'Moldavie', '60'),
('82', '29', '10', 'Julie Bonneau', 'Burkina Faso', '30'),
('83', '42', '24', 'André Gerard', 'Sierra Leone', '43'),
('84', '13', '3', 'Arthur Guichard-Marchand', 'Inde', '46'),
('85', '24', '16', 'Yves Delattre', 'Aruba', '18'),
('86', '13', '5', 'Astrid Julien', 'Aruba', '62'),
('87', '45', '16', 'Claudine Le Carpentier', 'Égypte', '33'),
('88', '3', '7', 'Éléonore de la Blanc', 'Kenya', '60'),
('89', '36', '2', 'Xavier Le Legrand', 'Malaisie', '41'),
('90', '21', '22', 'Eugène Blin', 'Cambodge', '63'),
('91', '35', '17', 'Susan Pascal', 'Jamaïque', '27'),
('92', '25', '24', 'Brigitte Gerard', 'Côte d\'Ivoire', '36'),
('93', '33', '24', 'Zacharie Fleury', 'Maurice', '55'),
('94', '15', '17', 'Lorraine Le Chauveau', 'Antilles néerlandaises', '23'),
('95', '39', '14', 'Henri-Alphonse Aubry', 'Colombie', '38'),
('96', '15', '5', 'Marianne Techer', 'Chypre', '21'),
('97', '21', '9', 'Jeannine Lecoq', 'Ukraine', '27'),
('98', '39', '15', 'Brigitte Pinto-Lefevre', 'Équateur', '61'),
('99', '15', '11', 'André de la Becker', 'Niger', '25'),
('100', '12', '15', 'Claude de Lombard', 'Saint-Kitts et Nevis', '36');

INSERT INTO `Etapes` (`noEtape`, `noVoyage`, `noOrigine`, `noDestination`, `etapePrecedente`, `status`, `depart`, `ordre`, `dateArrivee`) VALUES
('1', '144', '120', '80', NULL, 'Annulé', '2020-07-06 16:52:23', '9', NULL),
('2', '66', '101', '122', '1', 'Interrompu', '2019-10-05 02:24:16', '8', NULL),
('3', '19', '129', '19', '1', 'Annulé', '2019-03-04 20:30:28', '7', NULL),
('4', '97', '10', '73', '1', 'Port (en route)', '2020-09-11 10:20:06', '1', NULL),
('5', '87', '18', '40', '2', 'Arrivé', '2019-06-30 19:49:59', '2', NULL),
('6', '130', '24', '63', '5', 'Interrompu', '2020-01-01 23:13:08', '8', NULL),
('7', '145', '39', '67', '2', 'Arrivé', '2019-07-08 05:03:35', '6', NULL),
('8', '117', '15', '80', '3', 'En route', '2020-11-01 09:08:55', '1', NULL),
('9', '133', '54', '108', '8', 'En préparation', '2019-07-31 02:15:08', '10', NULL),
('10', '143', '72', '34', '9', 'Arrivé', '2019-04-21 01:02:30', '7', NULL),
('11', '80', '119', '52', '8', 'Arrivé', '2020-02-05 16:41:59', '1', NULL),
('12', '53', '31', '63', '6', 'En préparation', '2019-06-17 15:10:02', '6', NULL),
('13', '66', '125', '113', '4', 'Interrompu', '2020-10-12 05:00:12', '6', NULL),
('14', '170', '6', '94', '6', 'Interrompu', '2019-03-28 20:32:49', '7', NULL),
('15', '180', '116', '32', '4', 'Prêt à partir', '2020-02-04 01:07:24', '9', NULL),
('16', '129', '31', '95', '4', 'En route', '2020-12-07 14:40:33', '7', NULL),
('17', '109', '55', '104', '7', 'Interrompu', '2019-09-18 10:32:24', '2', NULL),
('18', '187', '5', '127', '16', 'Port (en route)', '2019-02-03 03:23:41', '3', NULL),
('19', '19', '70', '61', '15', 'En préparation', '2020-05-26 06:22:55', '3', NULL),
('20', '96', '107', '69', '7', 'Prêt à partir', '2019-06-19 15:06:40', '4', NULL),
('21', '162', '118', '118', '18', 'Annulé', '2020-03-23 01:02:16', '2', NULL),
('22', '121', '57', '24', '4', 'Prêt à partir', '2020-12-01 12:15:31', '3', NULL),
('23', '54', '113', '117', '22', 'Arrivé', '2020-09-10 22:50:47', '4', NULL),
('24', '93', '83', '124', '20', 'Annulé', '2019-04-28 19:09:00', '6', NULL),
('25', '115', '102', '52', '10', 'En préparation', '2019-11-12 06:56:31', '1', NULL),
('26', '75', '108', '41', '24', 'Annulé', '2019-04-22 06:14:51', '9', NULL),
('27', '28', '12', '91', '10', 'Port (en route)', '2020-05-04 05:17:55', '4', NULL),
('28', '89', '4', '8', '15', 'Prêt à partir', '2020-09-14 16:39:56', '8', NULL),
('29', '192', '129', '105', '9', 'Interrompu', '2020-08-06 14:59:22', '3', NULL),
('30', '168', '113', '4', '25', 'Port (en route)', '2019-02-01 23:32:22', '4', NULL),
('31', '69', '58', '93', '10', 'En préparation', '2020-04-17 02:17:37', '3', NULL),
('32', '65', '25', '43', '2', 'Interrompu', '2020-09-30 19:22:45', '4', NULL),
('33', '91', '47', '58', '25', 'Annulé', '2020-03-16 21:36:44', '9', NULL),
('34', '131', '12', '69', '13', 'En préparation', '2019-04-22 23:48:09', '8', NULL),
('35', '161', '95', '31', '21', 'En préparation', '2019-09-10 12:44:45', '1', NULL),
('36', '147', '56', '53', '19', 'En préparation', '2020-10-11 18:29:56', '6', NULL),
('37', '104', '72', '123', '19', 'Arrivé', '2019-01-09 09:19:14', '6', NULL),
('38', '131', '59', '50', '1', 'Interrompu', '2019-02-15 10:26:10', '5', NULL),
('39', '99', '119', '97', '8', 'Port (en route)', '2019-12-17 03:21:30', '10', NULL),
('40', '134', '11', '18', '15', 'Interrompu', '2020-08-24 18:16:28', '3', NULL),
('41', '60', '81', '123', '32', 'Interrompu', '2019-12-14 04:28:41', '6', NULL),
('42', '137', '16', '21', '41', 'Arrivé', '2020-09-07 13:45:16', '7', NULL),
('43', '6', '58', '79', '30', 'En route', '2019-05-15 15:38:37', '10', NULL),
('44', '94', '123', '56', '10', 'Interrompu', '2019-06-03 10:50:10', '2', NULL),
('45', '117', '121', '11', '25', 'Port (en route)', '2019-09-11 13:31:19', '3', NULL),
('46', '198', '79', '117', '28', 'Prêt à partir', '2020-01-08 10:16:36', '3', NULL),
('47', '33', '88', '8', '23', 'Port (en route)', '2020-04-15 10:29:30', '8', NULL),
('48', '68', '17', '23', '18', 'En route', '2020-02-11 09:12:14', '4', NULL),
('49', '66', '77', '112', '31', 'Arrivé', '2019-12-21 11:31:58', '10', NULL),
('50', '48', '27', '113', '31', 'Interrompu', '2019-06-07 08:35:14', '3', NULL),
('51', '8', '71', '97', '20', 'En route', '2020-09-26 01:59:04', '5', NULL),
('52', '29', '105', '115', '26', 'Arrivé', '2019-03-31 13:39:04', '10', NULL),
('53', '168', '25', '98', '24', 'Port (en route)', '2019-10-23 13:08:37', '4', NULL),
('54', '69', '11', '58', '47', 'Annulé', '2020-07-10 12:11:31', '1', NULL),
('55', '189', '114', '95', '53', 'En préparation', '2020-02-24 09:15:05', '4', NULL),
('56', '13', '115', '12', '6', 'Interrompu', '2019-05-12 10:27:07', '10', NULL),
('57', '162', '99', '129', '19', 'Interrompu', '2020-12-10 19:52:46', '8', NULL),
('58', '79', '5', '99', '13', 'Prêt à partir', '2020-12-03 01:15:03', '10', NULL),
('59', '88', '11', '112', '48', 'Interrompu', '2019-02-14 14:56:22', '7', NULL),
('60', '194', '4', '41', '39', 'En route', '2020-04-24 00:18:26', '5', NULL),
('61', '60', '81', '25', '9', 'Prêt à partir', '2019-04-01 22:17:26', '7', NULL),
('62', '96', '93', '47', '7', 'En préparation', '2019-03-22 09:24:14', '2', NULL),
('63', '70', '50', '22', '52', 'Port (en route)', '2019-05-21 00:51:31', '10', NULL),
('64', '142', '33', '99', '49', 'Port (en route)', '2020-03-29 13:21:21', '5', NULL),
('65', '23', '69', '15', '36', 'Interrompu', '2020-05-09 14:18:23', '7', NULL),
('66', '57', '73', '5', '25', 'Port (en route)', '2019-01-09 19:35:45', '7', NULL),
('67', '9', '72', '23', '47', 'En préparation', '2019-12-12 07:04:15', '2', NULL),
('68', '144', '71', '13', '6', 'Annulé', '2019-08-10 19:39:10', '8', NULL),
('69', '157', '52', '57', '57', 'Prêt à partir', '2020-03-21 23:28:10', '8', NULL),
('70', '42', '94', '87', '19', 'Arrivé', '2019-10-08 22:23:00', '9', NULL),
('71', '104', '10', '69', '36', 'Port (en route)', '2019-05-31 00:19:01', '5', NULL),
('72', '156', '15', '121', '66', 'Port (en route)', '2019-06-23 05:08:12', '6', NULL),
('73', '179', '5', '57', '23', 'Prêt à partir', '2020-10-14 19:22:59', '8', NULL),
('74', '167', '49', '104', '5', 'En route', '2020-03-02 07:33:43', '1', NULL),
('75', '194', '44', '117', '8', 'Annulé', '2020-10-17 21:38:12', '2', NULL),
('76', '59', '62', '66', '57', 'Annulé', '2019-06-14 12:21:09', '9', NULL),
('77', '89', '93', '96', '75', 'Annulé', '2020-02-26 06:05:03', '4', NULL),
('78', '164', '28', '29', '26', 'Arrivé', '2019-12-01 17:04:15', '1', NULL),
('79', '151', '108', '55', '25', 'Port (en route)', '2020-12-21 21:51:27', '8', NULL),
('80', '107', '19', '19', '68', 'En route', '2019-08-02 01:10:32', '9', NULL),
('81', '156', '36', '38', '75', 'Interrompu', '2020-11-24 04:11:23', '2', NULL),
('82', '106', '65', '30', '71', 'Arrivé', '2019-02-11 18:26:07', '10', NULL),
('83', '27', '105', '53', '3', 'Annulé', '2019-09-16 06:24:24', '8', NULL),
('84', '198', '122', '95', '48', 'Prêt à partir', '2020-10-05 07:46:02', '7', NULL),
('85', '144', '61', '112', '84', 'En route', '2020-04-03 16:37:09', '8', NULL),
('86', '165', '42', '38', '27', 'En préparation', '2019-12-28 07:30:16', '6', NULL),
('87', '28', '16', '80', '68', 'Arrivé', '2020-01-28 07:03:51', '8', NULL),
('88', '143', '89', '46', '62', 'En préparation', '2020-12-27 16:25:20', '8', NULL),
('89', '107', '47', '12', '42', 'Arrivé', '2020-03-24 21:34:43', '9', NULL),
('90', '94', '103', '87', '55', 'Arrivé', '2019-01-30 08:21:54', '3', NULL),
('91', '182', '18', '90', '83', 'Arrivé', '2019-05-29 05:36:27', '10', NULL),
('92', '28', '47', '29', '88', 'Arrivé', '2019-06-12 02:49:03', '2', NULL),
('93', '38', '6', '16', '16', 'En route', '2019-09-02 19:43:02', '7', NULL),
('94', '151', '115', '96', '11', 'En préparation', '2019-03-07 15:02:02', '2', NULL),
('95', '148', '7', '57', '72', 'En préparation', '2020-08-06 18:58:08', '10', NULL),
('96', '51', '90', '10', '64', 'Prêt à partir', '2019-01-06 23:19:52', '4', NULL),
('97', '38', '34', '10', '13', 'Interrompu', '2020-08-13 01:34:46', '9', NULL),
('98', '152', '33', '85', '52', 'En préparation', '2020-08-31 09:33:28', '7', NULL),
('99', '61', '61', '41', '77', 'Arrivé', '2020-03-13 02:06:28', '10', NULL),
('100', '87', '45', '3', '40', 'Interrompu', '2019-11-25 00:27:08', '5', NULL),
('101', '157', '58', '51', '53', 'Arrivé', '2020-05-17 04:55:13', '3', NULL),
('102', '94', '63', '78', '42', 'En préparation', '2020-11-28 06:21:15', '4', NULL),
('103', '91', '81', '15', '52', 'En route', '2020-03-28 17:55:22', '10', NULL),
('104', '131', '82', '34', '30', 'En route', '2020-02-25 15:37:59', '4', NULL),
('105', '113', '7', '73', '10', 'En préparation', '2019-04-02 20:06:53', '2', NULL),
('106', '146', '107', '63', '77', 'Prêt à partir', '2019-12-11 08:20:48', '5', NULL),
('107', '179', '31', '124', '54', 'Prêt à partir', '2020-05-20 05:06:14', '4', NULL),
('108', '47', '35', '57', '90', 'En préparation', '2020-05-23 17:17:46', '8', NULL),
('109', '133', '74', '107', '99', 'Arrivé', '2020-05-07 07:30:59', '3', NULL),
('110', '88', '12', '100', '54', 'En préparation', '2019-05-13 05:30:31', '2', NULL),
('111', '33', '35', '113', '10', 'En route', '2019-11-12 12:11:34', '2', NULL),
('112', '190', '8', '118', '106', 'Prêt à partir', '2020-10-09 19:10:01', '4', NULL),
('113', '192', '3', '91', '20', 'Annulé', '2020-01-04 10:44:40', '5', NULL),
('114', '145', '15', '78', '50', 'Prêt à partir', '2020-06-02 02:50:19', '1', NULL),
('115', '187', '39', '54', '51', 'Arrivé', '2020-12-12 22:44:53', '6', NULL),
('116', '68', '4', '124', '55', 'Annulé', '2020-03-29 08:56:39', '7', NULL),
('117', '48', '34', '68', '89', 'En préparation', '2019-10-15 23:48:27', '6', NULL),
('118', '76', '58', '48', '80', 'Interrompu', '2019-05-26 03:09:11', '4', NULL),
('119', '162', '12', '130', '49', 'Annulé', '2020-11-02 23:20:08', '1', NULL),
('120', '105', '45', '92', '115', 'En route', '2020-02-12 00:09:06', '6', NULL),
('121', '38', '63', '7', '79', 'Annulé', '2019-09-06 02:32:21', '9', NULL),
('122', '49', '1', '58', '87', 'Annulé', '2020-01-04 09:52:30', '8', NULL),
('123', '172', '24', '103', '101', 'Arrivé', '2020-03-10 02:52:13', '3', NULL),
('124', '155', '105', '56', '81', 'Annulé', '2020-03-14 23:54:20', '4', NULL),
('125', '26', '56', '100', '94', 'En préparation', '2019-07-02 16:09:29', '9', NULL),
('126', '73', '129', '59', '66', 'Interrompu', '2019-03-23 16:12:14', '4', NULL),
('127', '114', '72', '49', '48', 'Annulé', '2020-11-13 07:39:57', '2', NULL),
('128', '139', '93', '78', '118', 'Annulé', '2019-01-30 21:43:23', '8', NULL),
('129', '74', '104', '107', '116', 'Annulé', '2020-09-13 02:29:24', '5', NULL),
('130', '45', '62', '110', '104', 'En route', '2019-10-06 16:12:55', '9', NULL),
('131', '15', '85', '43', '74', 'Arrivé', '2020-08-17 23:30:23', '8', NULL),
('132', '144', '29', '88', '3', 'En préparation', '2020-11-23 07:57:06', '6', NULL),
('133', '95', '96', '125', '22', 'Annulé', '2019-05-06 14:10:12', '8', NULL),
('134', '70', '92', '92', '35', 'Arrivé', '2020-10-13 12:08:19', '9', NULL),
('135', '200', '91', '41', '107', 'Arrivé', '2020-09-16 10:05:46', '5', NULL),
('136', '117', '130', '114', '71', 'Annulé', '2019-03-29 14:24:37', '4', NULL),
('137', '78', '121', '130', '39', 'Annulé', '2019-04-08 21:09:26', '6', NULL),
('138', '184', '10', '65', '96', 'En préparation', '2020-11-11 04:38:02', '1', NULL),
('139', '74', '51', '33', '4', 'Port (en route)', '2019-05-30 01:55:24', '7', NULL),
('140', '33', '91', '63', '11', 'En route', '2020-08-20 04:19:56', '4', NULL),
('141', '136', '47', '29', '22', 'En préparation', '2020-10-31 14:15:47', '7', NULL),
('142', '130', '115', '1', '34', 'Port (en route)', '2019-02-20 23:17:31', '8', NULL),
('143', '127', '62', '35', '19', 'En route', '2019-01-11 01:09:51', '7', NULL),
('144', '93', '2', '5', '18', 'Prêt à partir', '2020-11-22 01:14:28', '7', NULL),
('145', '177', '44', '98', '128', 'Port (en route)', '2019-02-09 08:49:29', '10', NULL),
('146', '162', '39', '37', '126', 'Prêt à partir', '2019-02-21 13:43:15', '4', NULL),
('147', '12', '40', '43', '120', 'Port (en route)', '2020-04-09 15:48:03', '8', NULL),
('148', '64', '56', '95', '102', 'Interrompu', '2020-09-24 03:15:23', '9', NULL),
('149', '63', '104', '82', '94', 'Port (en route)', '2020-10-18 04:35:03', '10', NULL),
('150', '179', '2', '60', '133', 'Interrompu', '2019-06-02 00:54:44', '2', NULL),
('151', '81', '24', '59', '141', 'Annulé', '2020-12-15 19:09:09', '10', NULL),
('152', '155', '18', '85', '76', 'En préparation', '2020-09-24 09:45:20', '10', NULL),
('153', '109', '51', '99', '48', 'Interrompu', '2020-05-05 17:26:57', '5', NULL),
('154', '120', '75', '88', '132', 'Port (en route)', '2020-02-28 08:17:25', '9', NULL),
('155', '190', '23', '125', '62', 'Arrivé', '2020-03-29 05:12:20', '9', NULL),
('156', '67', '38', '95', '90', 'Arrivé', '2019-10-01 11:54:08', '5', NULL),
('157', '74', '22', '25', '92', 'En route', '2020-12-24 14:35:57', '5', NULL),
('158', '173', '68', '109', '14', 'Port (en route)', '2020-05-08 01:35:18', '6', NULL),
('159', '109', '107', '3', '142', 'Arrivé', '2019-01-25 07:17:06', '6', NULL),
('160', '147', '80', '113', '114', 'Arrivé', '2020-01-13 17:18:39', '6', NULL),
('161', '163', '114', '22', '4', 'Annulé', '2020-07-18 00:57:19', '9', NULL),
('162', '71', '80', '29', '161', 'Port (en route)', '2019-02-09 08:17:26', '9', NULL),
('163', '158', '67', '97', '87', 'En préparation', '2020-05-05 04:09:43', '5', NULL),
('164', '18', '38', '8', '50', 'Arrivé', '2020-09-13 07:36:15', '8', NULL),
('165', '108', '126', '58', '85', 'Port (en route)', '2020-10-23 11:41:55', '2', NULL),
('166', '157', '38', '4', '49', 'Port (en route)', '2020-01-08 20:42:28', '5', NULL),
('167', '155', '126', '45', '98', 'Annulé', '2020-06-15 03:26:57', '9', NULL),
('168', '102', '75', '58', '94', 'Interrompu', '2020-01-16 05:53:23', '5', NULL),
('169', '76', '121', '62', '50', 'Arrivé', '2019-02-26 01:00:01', '7', NULL),
('170', '123', '84', '20', '27', 'En route', '2019-03-17 16:00:00', '1', NULL),
('171', '77', '58', '68', '122', 'En préparation', '2020-10-07 11:35:52', '7', NULL),
('172', '181', '109', '14', '64', 'Prêt à partir', '2019-05-07 21:11:43', '8', NULL),
('173', '34', '55', '47', '25', 'En route', '2020-02-03 04:37:17', '1', NULL),
('174', '135', '63', '89', '25', 'Interrompu', '2019-07-04 01:47:05', '5', NULL),
('175', '81', '80', '99', '157', 'En préparation', '2020-01-02 00:29:47', '8', NULL),
('176', '135', '111', '94', '170', 'Prêt à partir', '2019-11-17 10:57:59', '9', NULL),
('177', '32', '11', '101', '155', 'En préparation', '2020-05-30 08:11:19', '8', NULL),
('178', '52', '46', '14', '117', 'En préparation', '2019-01-01 02:43:48', '9', NULL),
('179', '87', '107', '78', '151', 'En route', '2019-02-02 07:50:16', '7', NULL),
('180', '64', '3', '125', '12', 'Prêt à partir', '2019-05-17 09:25:24', '8', NULL),
('181', '190', '68', '81', '31', 'En préparation', '2019-10-13 05:25:49', '4', NULL),
('182', '171', '103', '14', '138', 'En route', '2019-11-21 07:46:06', '4', NULL),
('183', '44', '113', '44', '58', 'Port (en route)', '2019-12-05 19:47:29', '7', NULL),
('184', '187', '8', '130', '59', 'En route', '2019-07-18 02:04:47', '10', NULL),
('185', '112', '2', '3', '37', 'Arrivé', '2019-03-27 16:15:40', '2', NULL),
('186', '178', '65', '109', '177', 'Prêt à partir', '2019-03-12 14:09:45', '6', NULL),
('187', '57', '47', '124', '153', 'Interrompu', '2019-07-24 14:14:13', '1', NULL),
('188', '26', '128', '65', '139', 'Arrivé', '2020-06-13 01:42:00', '1', NULL),
('189', '169', '109', '88', '46', 'Interrompu', '2020-08-08 12:55:21', '8', NULL),
('190', '116', '113', '123', '103', 'Arrivé', '2019-06-16 14:50:14', '3', NULL),
('191', '118', '22', '121', '21', 'Arrivé', '2019-01-21 05:28:12', '3', NULL),
('192', '3', '49', '116', '152', 'En préparation', '2020-02-11 06:46:55', '6', NULL),
('193', '171', '34', '18', '9', 'Arrivé', '2019-12-03 03:45:32', '3', NULL),
('194', '88', '31', '67', '87', 'Port (en route)', '2019-08-03 23:07:28', '5', NULL),
('195', '63', '87', '42', '66', 'En route', '2020-04-27 09:40:41', '10', NULL),
('196', '193', '92', '45', '177', 'Port (en route)', '2020-08-09 08:02:04', '1', NULL),
('197', '185', '103', '125', '20', 'En préparation', '2020-10-20 10:04:11', '4', NULL),
('198', '90', '86', '60', '57', 'En route', '2020-08-02 00:44:29', '7', NULL),
('199', '91', '79', '122', '121', 'Interrompu', '2019-11-11 10:53:04', '5', NULL),
('200', '187', '102', '21', '172', 'En route', '2020-10-02 07:32:51', '2', NULL),
('201', '118', '10', '69', '52', 'Annulé', '2019-07-20 23:55:34', '6', NULL),
('202', '151', '120', '79', '107', 'En préparation', '2019-01-05 12:54:19', '9', NULL),
('203', '31', '91', '35', '136', 'Arrivé', '2019-03-01 03:28:45', '4', NULL),
('204', '136', '2', '53', '48', 'Interrompu', '2019-07-13 02:09:48', '4', NULL),
('205', '151', '78', '78', '186', 'Annulé', '2019-07-05 09:50:53', '10', NULL),
('206', '55', '35', '5', '158', 'Port (en route)', '2019-07-01 05:06:25', '6', NULL),
('207', '12', '10', '40', '43', 'Interrompu', '2020-09-02 00:08:50', '2', NULL),
('208', '134', '18', '57', '66', 'En préparation', '2020-10-04 15:44:00', '5', NULL),
('209', '91', '115', '69', '14', 'Interrompu', '2019-10-28 01:56:29', '9', NULL),
('210', '175', '97', '57', '104', 'Arrivé', '2020-10-14 09:53:53', '2', NULL),
('211', '28', '30', '107', '13', 'Arrivé', '2019-12-27 19:44:39', '4', NULL),
('212', '55', '78', '38', '2', 'Arrivé', '2020-02-05 00:11:38', '5', NULL),
('213', '129', '90', '64', '202', 'Annulé', '2020-05-02 09:31:31', '3', NULL),
('214', '100', '79', '108', '110', 'Prêt à partir', '2019-09-14 13:14:37', '4', NULL),
('215', '34', '62', '13', '60', 'Arrivé', '2019-06-11 14:31:26', '9', NULL),
('216', '118', '79', '126', '120', 'Prêt à partir', '2020-09-19 02:33:10', '6', NULL),
('217', '151', '100', '89', '67', 'Prêt à partir', '2019-12-17 00:06:36', '4', NULL),
('218', '131', '77', '80', '13', 'Arrivé', '2020-09-19 12:36:13', '4', NULL),
('219', '180', '44', '36', '114', 'En route', '2020-03-31 03:55:52', '10', NULL),
('220', '31', '43', '84', '49', 'Port (en route)', '2020-03-08 17:22:33', '3', NULL),
('221', '112', '97', '50', '57', 'En route', '2020-07-29 11:30:27', '10', NULL),
('222', '191', '121', '101', '26', 'Port (en route)', '2020-05-09 20:27:17', '7', NULL),
('223', '102', '115', '17', '21', 'Arrivé', '2019-01-31 14:05:54', '6', NULL),
('224', '33', '63', '121', '81', 'Arrivé', '2020-05-27 03:33:50', '1', NULL),
('225', '149', '107', '104', '199', 'Annulé', '2020-08-14 17:27:49', '1', NULL),
('226', '16', '129', '122', '142', 'Prêt à partir', '2019-07-06 21:03:03', '10', NULL),
('227', '172', '123', '45', '127', 'Port (en route)', '2019-10-31 09:18:45', '4', NULL),
('228', '146', '83', '116', '110', 'Arrivé', '2019-08-04 07:10:52', '6', NULL),
('229', '149', '58', '8', '37', 'En route', '2020-10-12 01:29:37', '2', NULL),
('230', '96', '12', '89', '204', 'En route', '2019-05-11 23:38:29', '7', NULL),
('231', '177', '81', '63', '68', 'Interrompu', '2019-08-09 18:20:22', '8', NULL),
('232', '167', '12', '129', '2', 'Arrivé', '2019-09-12 05:20:44', '2', NULL),
('233', '20', '58', '23', '93', 'Prêt à partir', '2020-09-26 04:09:08', '5', NULL),
('234', '173', '35', '99', '134', 'Interrompu', '2019-03-31 13:47:30', '8', NULL),
('235', '59', '52', '46', '206', 'En route', '2020-09-12 05:34:14', '2', NULL),
('236', '152', '119', '26', '24', 'Interrompu', '2020-06-08 17:32:28', '8', NULL),
('237', '188', '75', '118', '113', 'En préparation', '2019-06-08 14:08:19', '9', NULL),
('238', '36', '67', '93', '167', 'Interrompu', '2019-10-01 16:09:03', '4', NULL),
('239', '173', '60', '21', '43', 'Annulé', '2020-02-12 13:04:18', '10', NULL),
('240', '98', '47', '44', '177', 'En préparation', '2020-05-15 18:31:32', '10', NULL),
('241', '102', '15', '8', '20', 'En préparation', '2020-04-06 10:30:56', '5', NULL),
('242', '134', '62', '55', '120', 'Arrivé', '2019-06-21 09:26:40', '4', NULL),
('243', '180', '107', '105', '129', 'En route', '2019-01-20 17:35:16', '8', NULL),
('244', '102', '57', '115', '98', 'Arrivé', '2020-01-30 19:33:24', '2', NULL),
('245', '142', '3', '104', '192', 'En préparation', '2019-11-16 12:24:16', '9', NULL),
('246', '7', '102', '15', '150', 'En préparation', '2019-03-30 05:54:28', '1', NULL),
('247', '35', '27', '76', '200', 'Prêt à partir', '2019-11-13 03:54:44', '1', NULL),
('248', '135', '73', '30', '16', 'Port (en route)', '2020-09-08 13:56:12', '4', NULL),
('249', '23', '66', '19', '95', 'Port (en route)', '2020-08-04 13:36:46', '10', NULL),
('250', '59', '18', '75', '164', 'En préparation', '2019-03-27 09:50:17', '1', NULL),
('251', '146', '68', '103', '1', 'Prêt à partir', '2019-04-20 23:04:39', '6', NULL),
('252', '83', '52', '96', '249', 'En route', '2019-07-07 06:31:52', '3', NULL),
('253', '20', '3', '4', '100', 'Arrivé', '2020-01-02 01:20:52', '10', NULL),
('254', '57', '33', '115', '130', 'Annulé', '2020-02-09 21:06:16', '7', NULL),
('255', '193', '69', '38', '181', 'En route', '2020-12-16 11:47:15', '9', NULL),
('256', '17', '56', '23', '43', 'Arrivé', '2019-05-11 01:06:48', '10', NULL),
('257', '176', '118', '126', '27', 'Annulé', '2019-09-22 05:43:18', '5', NULL),
('258', '100', '106', '72', '224', 'Arrivé', '2019-01-01 17:42:40', '10', NULL),
('259', '61', '110', '28', '27', 'Prêt à partir', '2019-01-30 09:00:02', '4', NULL),
('260', '155', '108', '22', '77', 'En préparation', '2019-01-05 06:48:29', '1', NULL),
('261', '59', '37', '108', '57', 'En préparation', '2020-06-02 22:23:29', '3', NULL),
('262', '35', '23', '63', '221', 'En route', '2020-11-30 18:15:58', '9', NULL),
('263', '152', '28', '86', '249', 'Prêt à partir', '2020-07-18 09:23:48', '6', NULL),
('264', '21', '123', '77', '157', 'Arrivé', '2019-04-13 04:31:04', '9', NULL),
('265', '124', '37', '79', '13', 'Prêt à partir', '2020-06-09 10:24:16', '1', NULL),
('266', '34', '45', '66', '249', 'Interrompu', '2020-06-13 23:03:27', '3', NULL),
('267', '190', '76', '89', '98', 'Interrompu', '2020-03-04 07:35:04', '3', NULL),
('268', '199', '54', '73', '47', 'Arrivé', '2020-04-06 20:22:38', '2', NULL),
('269', '61', '56', '113', '192', 'En préparation', '2020-10-04 09:40:54', '9', NULL),
('270', '74', '85', '64', '244', 'Annulé', '2020-04-05 23:04:56', '9', NULL),
('271', '157', '64', '65', '168', 'Annulé', '2019-12-06 20:49:52', '1', NULL),
('272', '186', '12', '72', '18', 'Arrivé', '2020-12-20 00:19:17', '4', NULL),
('273', '89', '110', '93', '107', 'Interrompu', '2019-02-16 23:00:39', '3', NULL),
('274', '132', '48', '68', '130', 'Interrompu', '2019-10-27 08:29:33', '7', NULL),
('275', '12', '85', '69', '18', 'En route', '2020-11-28 20:36:18', '4', NULL),
('276', '54', '22', '89', '151', 'Prêt à partir', '2019-03-21 09:43:55', '8', NULL),
('277', '99', '31', '92', '260', 'Port (en route)', '2020-11-18 16:38:13', '5', NULL),
('278', '20', '108', '39', '222', 'Prêt à partir', '2020-12-20 06:13:44', '9', NULL),
('279', '117', '78', '121', '241', 'Interrompu', '2019-04-12 21:33:13', '8', NULL),
('280', '100', '125', '111', '135', 'En route', '2020-10-28 18:18:40', '1', NULL),
('281', '86', '49', '15', '84', 'En route', '2019-04-10 01:02:20', '7', NULL),
('282', '110', '57', '71', '262', 'Interrompu', '2019-06-02 10:51:19', '6', NULL),
('283', '52', '102', '66', '77', 'Interrompu', '2019-04-05 20:31:04', '10', NULL),
('284', '120', '53', '93', '84', 'Annulé', '2020-01-28 09:22:16', '8', NULL),
('285', '94', '101', '64', '130', 'Prêt à partir', '2020-03-27 11:57:30', '1', NULL),
('286', '120', '3', '20', '123', 'Port (en route)', '2019-08-09 17:10:18', '7', NULL),
('287', '192', '83', '117', '202', 'Prêt à partir', '2020-03-12 16:06:22', '6', NULL),
('288', '21', '25', '97', '144', 'En route', '2020-07-23 15:52:45', '2', NULL),
('289', '110', '26', '56', '133', 'En préparation', '2019-11-24 04:58:34', '9', NULL),
('290', '151', '10', '110', '175', 'Interrompu', '2020-05-12 17:42:36', '2', NULL),
('291', '158', '12', '60', '208', 'Prêt à partir', '2020-02-17 15:34:48', '4', NULL),
('292', '16', '122', '54', '217', 'En préparation', '2019-07-05 19:20:24', '3', NULL),
('293', '171', '130', '77', '48', 'Arrivé', '2019-05-09 15:18:40', '6', NULL),
('294', '161', '15', '116', '125', 'Interrompu', '2019-02-08 03:52:34', '5', NULL),
('295', '187', '33', '17', '114', 'Arrivé', '2020-08-04 06:20:50', '2', NULL),
('296', '142', '68', '56', '211', 'Prêt à partir', '2020-01-15 23:42:27', '4', NULL),
('297', '86', '127', '116', '214', 'En préparation', '2019-04-10 14:21:43', '9', NULL),
('298', '154', '34', '19', '208', 'Interrompu', '2020-04-21 05:54:06', '4', NULL),
('299', '167', '69', '65', '206', 'Annulé', '2019-07-02 15:21:26', '5', NULL),
('300', '118', '113', '9', '163', 'En route', '2019-02-13 04:10:15', '4', NULL),
('301', '131', '75', '121', '297', 'En route', '2019-04-28 02:35:35', '5', NULL),
('302', '122', '3', '45', '170', 'Annulé', '2020-04-07 06:07:09', '2', NULL),
('303', '108', '109', '119', '171', 'Annulé', '2020-05-19 00:49:32', '10', NULL),
('304', '94', '19', '74', '153', 'En préparation', '2020-11-28 19:20:06', '7', NULL),
('305', '21', '29', '49', '304', 'Interrompu', '2019-08-16 20:45:43', '10', NULL),
('306', '6', '54', '1', '86', 'Interrompu', '2020-01-22 20:04:55', '2', NULL),
('307', '53', '14', '117', '38', 'En préparation', '2020-10-01 13:21:15', '1', NULL),
('308', '131', '85', '72', '101', 'Arrivé', '2020-07-08 18:01:45', '7', NULL),
('309', '72', '17', '63', '104', 'Port (en route)', '2019-05-30 14:15:46', '6', NULL),
('310', '96', '2', '93', '236', 'Annulé', '2019-01-06 04:51:43', '1', NULL),
('311', '84', '85', '16', '275', 'Arrivé', '2020-06-11 06:54:01', '8', NULL),
('312', '158', '127', '119', '269', 'Port (en route)', '2019-06-12 18:32:36', '5', NULL),
('313', '40', '54', '34', '262', 'Arrivé', '2020-03-15 10:04:44', '1', NULL),
('314', '186', '23', '37', '16', 'Annulé', '2019-06-17 11:33:49', '2', NULL),
('315', '69', '5', '36', '41', 'En route', '2019-12-18 14:06:22', '5', NULL),
('316', '160', '36', '48', '234', 'Annulé', '2020-09-02 00:00:12', '2', NULL),
('317', '25', '33', '90', '181', 'Interrompu', '2019-07-01 17:05:35', '9', NULL),
('318', '29', '113', '61', '162', 'Arrivé', '2019-12-28 21:07:06', '3', NULL),
('319', '94', '118', '49', '187', 'Annulé', '2020-06-26 10:15:50', '3', NULL),
('320', '86', '85', '123', '68', 'Annulé', '2020-10-12 12:58:26', '8', NULL),
('321', '110', '114', '47', '282', 'En route', '2019-02-02 15:05:30', '9', NULL),
('322', '22', '17', '103', '1', 'Interrompu', '2020-04-22 17:32:06', '4', NULL),
('323', '144', '107', '109', '285', 'Arrivé', '2019-01-04 14:01:37', '3', NULL),
('324', '133', '14', '36', '194', 'Arrivé', '2019-01-19 20:31:45', '7', NULL),
('325', '13', '84', '4', '107', 'Arrivé', '2020-01-21 13:40:27', '7', NULL),
('326', '117', '43', '126', '315', 'Annulé', '2020-01-04 07:02:28', '5', NULL),
('327', '180', '99', '74', '112', 'Arrivé', '2020-01-11 20:24:48', '7', NULL),
('328', '2', '7', '19', '256', 'En route', '2020-04-11 03:41:17', '7', NULL),
('329', '4', '97', '129', '180', 'En route', '2019-07-03 19:07:35', '8', NULL),
('330', '129', '129', '27', '139', 'En préparation', '2019-04-13 21:50:54', '4', NULL),
('331', '142', '39', '35', '143', 'Interrompu', '2019-05-06 23:02:19', '1', NULL),
('332', '192', '48', '92', '36', 'En route', '2019-08-21 10:03:55', '9', NULL),
('333', '175', '18', '13', '306', 'Port (en route)', '2019-04-21 08:01:40', '9', NULL),
('334', '175', '38', '106', '127', 'Annulé', '2019-01-22 22:54:18', '8', NULL),
('335', '6', '69', '19', '288', 'Arrivé', '2020-07-26 15:21:42', '7', NULL),
('336', '126', '37', '98', '318', 'Annulé', '2020-04-01 23:14:38', '9', NULL),
('337', '48', '122', '94', '128', 'Arrivé', '2019-04-10 18:01:54', '7', NULL),
('338', '30', '56', '101', '23', 'Interrompu', '2020-10-12 03:40:49', '9', NULL),
('339', '79', '74', '44', '222', 'Annulé', '2020-05-05 18:36:58', '9', NULL),
('340', '172', '85', '31', '132', 'En préparation', '2020-06-04 04:26:29', '1', NULL),
('341', '166', '60', '33', '76', 'En route', '2019-05-19 12:47:44', '8', NULL),
('342', '45', '66', '97', '164', 'Prêt à partir', '2019-04-24 11:31:18', '10', NULL),
('343', '110', '15', '77', '317', 'En route', '2019-06-10 17:48:49', '7', NULL),
('344', '122', '61', '120', '239', 'Annulé', '2019-02-16 06:47:53', '4', NULL),
('345', '185', '13', '109', '125', 'Arrivé', '2019-11-06 15:12:15', '5', NULL),
('346', '38', '73', '111', '187', 'Arrivé', '2019-10-19 04:21:19', '7', NULL),
('347', '77', '15', '11', '320', 'Annulé', '2020-12-27 01:23:29', '1', NULL),
('348', '128', '21', '97', '59', 'En route', '2020-08-09 01:45:08', '10', NULL),
('349', '102', '25', '129', '97', 'Interrompu', '2019-02-26 22:38:58', '8', NULL),
('350', '73', '111', '5', '203', 'Port (en route)', '2019-07-10 11:54:11', '1', NULL),
('351', '179', '60', '4', '174', 'Port (en route)', '2020-11-28 05:42:38', '3', NULL),
('352', '72', '51', '51', '338', 'En route', '2020-04-23 22:02:01', '5', NULL),
('353', '65', '89', '123', '146', 'En route', '2020-11-28 10:38:48', '2', NULL),
('354', '93', '73', '105', '41', 'En route', '2019-01-20 22:41:40', '1', NULL),
('355', '24', '18', '124', '23', 'En préparation', '2020-08-14 19:20:18', '4', NULL),
('356', '34', '76', '32', '197', 'En route', '2019-08-13 16:34:20', '8', NULL),
('357', '111', '70', '113', '143', 'Arrivé', '2019-05-11 02:36:55', '5', NULL),
('358', '174', '41', '29', '331', 'En route', '2020-03-28 17:05:38', '6', NULL),
('359', '28', '38', '47', '199', 'Port (en route)', '2019-03-29 02:11:41', '5', NULL),
('360', '29', '88', '111', '344', 'Arrivé', '2019-02-16 14:23:27', '10', NULL),
('361', '68', '25', '37', '356', 'Annulé', '2020-08-07 03:33:06', '2', NULL),
('362', '114', '21', '18', '56', 'En route', '2019-02-21 01:04:57', '8', NULL),
('363', '66', '71', '93', '207', 'Interrompu', '2020-08-05 03:13:33', '3', NULL),
('364', '90', '84', '99', '325', 'Port (en route)', '2019-09-28 02:36:49', '8', NULL),
('365', '181', '6', '64', '218', 'En préparation', '2019-01-18 17:11:47', '6', NULL),
('366', '157', '31', '61', '151', 'Interrompu', '2019-04-14 05:55:03', '5', NULL),
('367', '73', '101', '120', '21', 'Annulé', '2020-09-13 10:09:43', '8', NULL),
('368', '49', '73', '112', '28', 'Prêt à partir', '2019-10-27 03:51:04', '3', NULL),
('369', '149', '49', '27', '22', 'Annulé', '2020-11-12 19:27:10', '2', NULL),
('370', '132', '80', '38', '16', 'En préparation', '2019-07-09 15:53:19', '9', NULL),
('371', '73', '85', '72', '168', 'Prêt à partir', '2020-06-29 03:37:09', '8', NULL),
('372', '146', '99', '93', '68', 'Arrivé', '2020-09-07 23:23:20', '3', NULL),
('373', '25', '39', '37', '117', 'Port (en route)', '2019-10-05 22:05:23', '2', NULL),
('374', '66', '78', '21', '152', 'Port (en route)', '2020-06-14 05:16:57', '7', NULL),
('375', '94', '26', '45', '290', 'Interrompu', '2019-07-25 21:05:11', '5', NULL),
('376', '56', '87', '63', '9', 'Prêt à partir', '2019-06-19 08:00:24', '3', NULL),
('377', '151', '6', '101', '310', 'Interrompu', '2020-08-16 01:46:08', '3', NULL),
('378', '52', '104', '68', '351', 'En préparation', '2020-11-22 13:48:05', '5', NULL),
('379', '6', '94', '100', '36', 'En préparation', '2020-09-08 22:27:35', '1', NULL),
('380', '72', '70', '24', '153', 'Port (en route)', '2019-02-25 20:12:43', '1', NULL),
('381', '38', '121', '101', '21', 'En route', '2020-01-10 06:00:10', '5', NULL),
('382', '167', '19', '73', '196', 'Arrivé', '2019-02-11 12:03:30', '5', NULL),
('383', '10', '77', '100', '179', 'Port (en route)', '2020-12-30 10:50:50', '3', NULL),
('384', '45', '122', '39', '72', 'Prêt à partir', '2020-12-06 08:09:31', '1', NULL),
('385', '162', '29', '107', '37', 'Prêt à partir', '2020-02-15 22:41:34', '2', NULL),
('386', '50', '34', '129', '224', 'Port (en route)', '2019-10-06 01:04:50', '4', NULL),
('387', '158', '128', '4', '2', 'Prêt à partir', '2020-09-10 05:53:59', '5', NULL),
('388', '100', '92', '13', '365', 'Arrivé', '2020-10-12 07:18:24', '9', NULL),
('389', '163', '2', '64', '40', 'Prêt à partir', '2019-12-05 10:29:30', '6', NULL),
('390', '36', '72', '6', '210', 'Interrompu', '2020-05-09 19:28:12', '5', NULL),
('391', '42', '60', '62', '276', 'En route', '2020-12-01 01:39:05', '4', NULL),
('392', '82', '22', '53', '68', 'Port (en route)', '2019-08-27 08:12:28', '4', NULL),
('393', '35', '13', '33', '347', 'Annulé', '2019-08-21 08:31:57', '5', NULL),
('394', '92', '27', '37', '350', 'Prêt à partir', '2019-02-16 00:05:32', '5', NULL),
('395', '196', '19', '52', '384', 'En préparation', '2019-03-13 00:18:19', '9', NULL),
('396', '84', '125', '31', '364', 'Arrivé', '2019-10-17 23:50:17', '5', NULL),
('397', '75', '81', '66', '111', 'En route', '2020-03-22 08:07:09', '9', NULL),
('398', '64', '34', '84', '204', 'En route', '2020-07-29 09:19:23', '1', NULL),
('399', '114', '30', '35', '262', 'Annulé', '2020-08-12 09:33:31', '9', NULL),
('400', '186', '37', '14', '228', 'En route', '2019-06-22 05:11:32', '6', NULL);

INSERT INTO `Metiers` (`noMetier`, `nom`, `tauxHoraire`) VALUES
('1', 'Responsable Comptable', '23'),
('2', 'Responsable Bateau', '34'),
('3', 'Préposé Vendeur', '16'),
('4', 'Chargée Ressources Humaines', '28'),
('5', 'Responsable Bateau', '12'),
('6', 'Directeur Comptable', '25'),
('7', 'Responsable Capitaine', '30'),
('8', 'Préposé Comptable', '47'),
('9', 'Chargée Marketing', '53'),
('10', 'Responsable Ressources Humaines', '16'),
('11', 'Préposé Vendeur', '24'),
('12', 'Directeur Ressources Humaines', '55'),
('13', 'Responsable Comptable', '10'),
('14', 'Chargée Capitaine', '21'),
('15', 'Chargée Ressources Humaines', '48'),
('16', 'Directeur Bateau', '34'),
('17', 'Chargée Comptable', '19'),
('18', 'Responsable Bateau', '11'),
('19', 'Responsable Ressources Humaines', '45'),
('20', 'Responsable Capitaine', '52'),
('21', 'Directeur Vendeur', '17'),
('22', 'Responsable Capitaine', '45'),
('23', 'Préposé Comptable', '18'),
('24', 'Préposé Capitaine', '47'),
('25', 'Directeur Capitaine', '35');

INSERT INTO `Pays` (`noPays`, `nom`, `tarif`) VALUES
('1', 'Tonga', '3100.00'),
('2', 'Fidji (République des)', '2618.00'),
('3', 'Vanuatu', '1418.00'),
('4', 'Nigeria', '3456.00'),
('5', 'Saint-Marin (Rép. de)', '4894.00'),
('6', 'Islande', '3414.00'),
('7', 'Botswana', '4535.00'),
('8', 'Christmas (Île)', '4449.00'),
('9', 'Turquie', '2147.00'),
('10', 'Croatie', '1898.00'),
('11', 'Tanzanie', '4379.00'),
('12', 'Réunion (La)', '3195.00'),
('13', 'République centrafricaine', '3280.00'),
('14', 'Togo', '4447.00'),
('15', 'Angola', '4263.00'),
('16', 'Papouasie-Nouvelle-Guinée', '2377.00'),
('17', 'Turks et Caïques (Îles)', '1668.00'),
('18', 'Indonésie', '1505.00'),
('19', 'Aruba', '3519.00'),
('20', 'Guadeloupe', '4887.00'),
('21', 'Saint-Marin (Rép. de)', '4395.00'),
('22', 'Somalie', '3098.00'),
('23', 'Égypte', '1177.00'),
('24', 'Cayman (Îles)', '4467.00'),
('25', 'Brésil', '4368.00'),
('26', 'Turks et Caïques (Îles)', '3635.00'),
('27', 'Libye', '2432.00'),
('28', 'Allemagne', '1346.00'),
('29', 'Venezuela', '4764.00'),
('30', 'Chili', '2182.00');

INSERT INTO `Ports` (`noPort`, `noPays`, `nom`) VALUES
('1', '24', 'Renaud'),
('2', '27', 'LaunayVille'),
('3', '21', 'Blin-les-Bains'),
('4', '27', 'Schmitt-la-Forêt'),
('5', '8', 'Begue'),
('6', '15', 'Guillet'),
('7', '7', 'Julien'),
('8', '7', 'Couturier'),
('9', '8', 'Reynaud'),
('10', '13', 'Courtois'),
('11', '17', 'Marin'),
('12', '27', 'Gosselin-sur-Da Silva'),
('13', '2', 'Fernandes-la-Forêt'),
('14', '24', 'Breton'),
('15', '2', 'Launay'),
('16', '21', 'Gay'),
('17', '13', 'Bigot-la-Forêt'),
('18', '25', 'Guillon-les-Bains'),
('19', '2', 'Pascal-sur-Mer'),
('20', '15', 'BertrandVille'),
('21', '22', 'Poulain-sur-Evrard'),
('22', '11', 'Marie'),
('23', '12', 'Parent'),
('24', '4', 'Daniel'),
('25', '3', 'MathieuBourg'),
('26', '12', 'Neveu'),
('27', '27', 'Noel'),
('28', '16', 'Hoarau-les-Bains'),
('29', '5', 'Lemaitreboeuf'),
('30', '4', 'Collin'),
('31', '8', 'Voisin'),
('32', '29', 'LeclercqVille'),
('33', '28', 'Bouvet'),
('34', '18', 'Diaz-sur-Mer'),
('35', '29', 'Blanchet'),
('36', '13', 'Devaux'),
('37', '10', 'Delattreboeuf'),
('38', '5', 'Fernandez'),
('39', '27', 'Lemaire'),
('40', '10', 'LarocheVille'),
('41', '1', 'Legendredan'),
('42', '9', 'Mahe'),
('43', '23', 'Potier'),
('44', '4', 'Diallo-sur-Parent'),
('45', '25', 'Marchand'),
('46', '23', 'Jacquot-les-Bains'),
('47', '27', 'Adam'),
('48', '17', 'Gregoire'),
('49', '18', 'Julien-la-Forêt'),
('50', '11', 'TessierVille'),
('51', '12', 'Morel'),
('52', '28', 'Mercier'),
('53', '3', 'Berger-sur-Levy'),
('54', '2', 'Aubry'),
('55', '17', 'Georges'),
('56', '19', 'Bourdon-les-Bains'),
('57', '26', 'Meunier-les-Bains'),
('58', '9', 'Baudry-sur-Morin'),
('59', '16', 'Albert'),
('60', '5', 'Bourdon'),
('61', '9', 'Ramosdan'),
('62', '29', 'Pruvost'),
('63', '28', 'Lefevre-les-Bains'),
('64', '13', 'Gregoire-sur-Mer'),
('65', '23', 'Rocher'),
('66', '10', 'Barreboeuf'),
('67', '21', 'Giraud-les-Bains'),
('68', '19', 'Sauvage'),
('69', '23', 'Diaz-la-Forêt'),
('70', '13', 'Renault'),
('71', '18', 'Moulin-sur-Pons'),
('72', '6', 'Maurice'),
('73', '13', 'Durand'),
('74', '13', 'Guillon'),
('75', '25', 'Francois-sur-Mer'),
('76', '7', 'Tanguy-les-Bains'),
('77', '4', 'Barbier'),
('78', '25', 'Perret-sur-Monnier'),
('79', '22', 'Guibert-sur-Auger'),
('80', '30', 'Gilles-la-Forêt'),
('81', '12', 'Gillesboeuf'),
('82', '13', 'Masson'),
('83', '10', 'Moreaunec'),
('84', '17', 'Paris'),
('85', '4', 'Durandnec'),
('86', '24', 'Maurice'),
('87', '30', 'Seguin'),
('88', '4', 'Raymond-sur-Moreno'),
('89', '20', 'Roger'),
('90', '3', 'Dubois'),
('91', '26', 'Picardboeuf'),
('92', '30', 'Francois-sur-Mer'),
('93', '25', 'Chretien'),
('94', '18', 'Dupre-les-Bains'),
('95', '4', 'Rolland-la-Forêt'),
('96', '14', 'Clerc'),
('97', '22', 'Evrard-la-Forêt'),
('98', '2', 'Buissondan'),
('99', '28', 'Mailletdan'),
('100', '26', 'David'),
('101', '29', 'Bonnin'),
('102', '15', 'GayBourg'),
('103', '26', 'Courtois'),
('104', '1', 'Leveque'),
('105', '2', 'Gerardboeuf'),
('106', '25', 'Fischer'),
('107', '14', 'Henry'),
('108', '9', 'Le Roux-sur-David'),
('109', '9', 'Launay-sur-Lucas'),
('110', '6', 'EtienneVille'),
('111', '16', 'Regnier'),
('112', '16', 'Bertin'),
('113', '23', 'Carre'),
('114', '27', 'Verdier'),
('115', '22', 'Foucher'),
('116', '26', 'Normand-la-Forêt'),
('117', '4', 'Roger'),
('118', '29', 'Leroyboeuf'),
('119', '2', 'Bourgeoisdan'),
('120', '23', 'Charpentier'),
('121', '22', 'Toussaint'),
('122', '10', 'MoulinBourg'),
('123', '28', 'Ribeiro-sur-Bonnin'),
('124', '19', 'Rousset'),
('125', '11', 'Dumas-les-Bains'),
('126', '19', 'JacquetBourg'),
('127', '5', 'Legros'),
('128', '25', 'Gosselin'),
('129', '10', 'Collet'),
('130', '30', 'Collet');

INSERT INTO `Voyages` (`noVoyage`, `noOrigine`, `noDestination`, `noCapitaine`, `noBateau`, `type`, `status`, `depart`) VALUES
('1', '4', '77', '65', '17', 'Express', 'Arrivé', '2019-05-29 17:18:37'),
('2', '76', '90', '76', '4', 'Regulier', 'Port (en route)', '2020-01-12 15:23:13'),
('3', '123', '20', '77', '7', 'Regulier', 'Arrivé', '2019-10-08 03:52:01'),
('4', '84', '67', '32', '1', 'Regulier', 'Prêt à partir', '2020-11-29 00:17:25'),
('5', '119', '40', '96', '4', 'Express', 'Port (en route)', '2019-10-17 21:04:15'),
('6', '112', '71', '84', '6', 'Regulier', 'En route', '2019-08-08 09:28:28'),
('7', '72', '60', '9', '13', 'Regulier', 'Interrompu', '2020-06-23 09:45:12'),
('8', '52', '37', '92', '17', 'Regulier', 'Port (en route)', '2019-03-10 03:58:42'),
('9', '59', '112', '84', '22', 'Regulier', 'En préparation', '2020-08-31 17:03:03'),
('10', '13', '65', '72', '2', 'Express', 'Arrivé', '2019-01-22 02:30:00'),
('11', '56', '43', '93', '2', 'Regulier', 'En route', '2019-09-21 04:00:21'),
('12', '51', '21', '94', '22', 'Regulier', 'Interrompu', '2019-02-24 16:17:11'),
('13', '101', '24', '81', '14', 'Regulier', 'Port (en route)', '2020-10-23 21:49:02'),
('14', '111', '64', '34', '19', 'Express', 'Arrivé', '2020-12-17 15:43:39'),
('15', '72', '69', '44', '2', 'Regulier', 'Prêt à partir', '2019-10-24 04:18:59'),
('16', '28', '15', '40', '1', 'Regulier', 'Interrompu', '2020-04-24 05:57:27'),
('17', '1', '74', '18', '21', 'Express', 'Port (en route)', '2019-10-11 00:36:52'),
('18', '57', '51', '5', '14', 'Express', 'En préparation', '2019-04-24 15:34:04'),
('19', '88', '53', '91', '4', 'Regulier', 'Interrompu', '2019-10-11 04:55:27'),
('20', '5', '43', '19', '16', 'Express', 'Prêt à partir', '2019-08-11 07:13:56'),
('21', '102', '81', '9', '12', 'Express', 'Prêt à partir', '2019-01-18 05:57:48'),
('22', '88', '45', '28', '5', 'Express', 'Arrivé', '2020-08-21 10:34:38'),
('23', '85', '105', '70', '16', 'Express', 'Interrompu', '2019-03-09 21:22:56'),
('24', '23', '93', '37', '14', 'Regulier', 'Annulé', '2019-10-14 04:10:01'),
('25', '102', '2', '22', '1', 'Express', 'Port (en route)', '2020-03-20 06:26:04'),
('26', '63', '5', '81', '11', 'Express', 'Port (en route)', '2019-01-21 10:07:24'),
('27', '77', '46', '46', '2', 'Regulier', 'Interrompu', '2019-09-08 08:42:19'),
('28', '28', '122', '8', '5', 'Express', 'Arrivé', '2020-04-26 04:55:06'),
('29', '25', '51', '59', '10', 'Regulier', 'Arrivé', '2019-06-14 10:46:00'),
('30', '72', '10', '2', '11', 'Regulier', 'En préparation', '2019-01-10 14:58:13'),
('31', '35', '45', '16', '21', 'Regulier', 'En route', '2019-07-16 05:27:16'),
('32', '27', '33', '43', '4', 'Regulier', 'Prêt à partir', '2020-09-14 21:02:56'),
('33', '77', '104', '72', '11', 'Regulier', 'Interrompu', '2019-06-29 22:42:18'),
('34', '44', '48', '45', '7', 'Express', 'En route', '2020-06-03 21:57:49'),
('35', '44', '115', '23', '7', 'Express', 'Arrivé', '2020-07-31 06:38:30'),
('36', '72', '30', '70', '20', 'Express', 'En route', '2020-08-07 09:09:11'),
('37', '56', '40', '7', '21', 'Regulier', 'Annulé', '2020-10-16 19:50:28'),
('38', '60', '17', '27', '1', 'Regulier', 'Interrompu', '2020-12-20 21:57:00'),
('39', '119', '53', '78', '12', 'Express', 'Interrompu', '2020-05-20 02:49:26'),
('40', '79', '76', '26', '6', 'Express', 'Annulé', '2019-06-12 17:03:09'),
('41', '29', '39', '76', '19', 'Regulier', 'En préparation', '2020-04-13 22:13:19'),
('42', '48', '89', '63', '22', 'Regulier', 'Interrompu', '2019-07-29 19:33:01'),
('43', '47', '97', '57', '7', 'Regulier', 'En préparation', '2019-02-26 05:31:27'),
('44', '89', '6', '55', '12', 'Regulier', 'En route', '2019-10-28 03:08:59'),
('45', '95', '53', '61', '16', 'Express', 'En route', '2020-12-23 14:55:27'),
('46', '31', '7', '54', '17', 'Regulier', 'Prêt à partir', '2020-08-05 00:51:47'),
('47', '17', '50', '64', '10', 'Regulier', 'Annulé', '2020-05-15 05:01:07'),
('48', '90', '56', '91', '1', 'Express', 'En route', '2019-04-03 19:08:10'),
('49', '111', '121', '100', '22', 'Regulier', 'En préparation', '2019-01-19 13:30:29'),
('50', '97', '82', '17', '22', 'Express', 'Port (en route)', '2019-05-23 19:59:09'),
('51', '64', '8', '40', '9', 'Regulier', 'Arrivé', '2019-10-08 10:25:15'),
('52', '45', '111', '36', '2', 'Express', 'Port (en route)', '2019-02-13 10:20:22'),
('53', '97', '13', '95', '5', 'Regulier', 'En route', '2020-07-24 11:05:18'),
('54', '24', '92', '38', '2', 'Regulier', 'Arrivé', '2020-01-09 08:54:11'),
('55', '112', '76', '25', '14', 'Express', 'Annulé', '2019-05-30 17:55:37'),
('56', '85', '89', '82', '22', 'Regulier', 'Prêt à partir', '2020-07-23 20:24:02'),
('57', '33', '17', '25', '3', 'Regulier', 'Annulé', '2019-07-12 12:33:02'),
('58', '66', '117', '75', '13', 'Regulier', 'Arrivé', '2019-07-08 00:58:10'),
('59', '4', '42', '87', '6', 'Regulier', 'En préparation', '2019-06-21 16:10:48'),
('60', '87', '48', '51', '15', 'Express', 'Prêt à partir', '2020-01-15 00:49:34'),
('61', '69', '37', '63', '7', 'Express', 'En route', '2020-05-13 09:05:18'),
('62', '116', '105', '44', '20', 'Regulier', 'Annulé', '2019-04-04 09:08:47'),
('63', '86', '29', '89', '4', 'Express', 'Interrompu', '2019-12-25 13:05:24'),
('64', '47', '55', '87', '20', 'Express', 'Interrompu', '2020-03-17 17:54:45'),
('65', '99', '15', '97', '13', 'Express', 'Port (en route)', '2020-02-17 06:03:18'),
('66', '108', '38', '62', '2', 'Regulier', 'En route', '2019-05-24 16:40:46'),
('67', '60', '47', '94', '6', 'Regulier', 'En préparation', '2019-02-06 00:22:09'),
('68', '22', '122', '5', '11', 'Express', 'Interrompu', '2020-08-01 01:32:14'),
('69', '5', '92', '6', '22', 'Express', 'Interrompu', '2020-04-02 01:55:56'),
('70', '39', '94', '18', '19', 'Express', 'Arrivé', '2020-10-20 07:48:40'),
('71', '121', '35', '52', '5', 'Express', 'Port (en route)', '2019-09-25 11:21:43'),
('72', '34', '122', '36', '9', 'Express', 'Port (en route)', '2020-08-23 21:57:31'),
('73', '109', '112', '84', '16', 'Regulier', 'Prêt à partir', '2020-01-21 11:51:00'),
('74', '38', '27', '95', '16', 'Regulier', 'En préparation', '2020-11-27 13:57:48'),
('75', '72', '16', '53', '16', 'Express', 'En route', '2019-07-20 15:01:35'),
('76', '70', '16', '76', '18', 'Regulier', 'Port (en route)', '2020-11-09 03:17:35'),
('77', '92', '1', '30', '12', 'Regulier', 'Interrompu', '2020-02-11 21:36:28'),
('78', '118', '26', '9', '10', 'Regulier', 'Interrompu', '2020-07-25 07:16:39'),
('79', '39', '14', '97', '15', 'Express', 'Annulé', '2019-01-27 04:17:03'),
('80', '24', '103', '49', '6', 'Express', 'Prêt à partir', '2020-07-08 22:23:51'),
('81', '40', '99', '30', '15', 'Express', 'Prêt à partir', '2020-02-04 18:04:19'),
('82', '109', '111', '90', '6', 'Express', 'Annulé', '2019-09-04 06:14:39'),
('83', '96', '49', '27', '13', 'Express', 'Port (en route)', '2019-12-24 20:44:09'),
('84', '109', '78', '36', '4', 'Regulier', 'En route', '2020-06-20 05:25:02'),
('85', '66', '98', '13', '14', 'Regulier', 'Arrivé', '2019-08-02 16:24:42'),
('86', '70', '3', '68', '4', 'Regulier', 'Prêt à partir', '2019-04-13 15:19:42'),
('87', '123', '42', '72', '9', 'Regulier', 'Annulé', '2019-04-22 07:22:30'),
('88', '40', '28', '86', '22', 'Express', 'Prêt à partir', '2020-12-29 15:23:11'),
('89', '89', '50', '19', '7', 'Regulier', 'En route', '2019-02-28 00:27:05'),
('90', '101', '12', '54', '15', 'Regulier', 'En préparation', '2019-10-15 20:12:43'),
('91', '41', '6', '83', '3', 'Regulier', 'Prêt à partir', '2019-03-30 20:02:48'),
('92', '92', '46', '82', '17', 'Express', 'Prêt à partir', '2020-07-27 11:28:25'),
('93', '8', '97', '65', '4', 'Regulier', 'Port (en route)', '2020-11-11 12:59:09'),
('94', '115', '81', '29', '18', 'Regulier', 'Arrivé', '2019-07-16 04:36:23'),
('95', '71', '65', '85', '15', 'Regulier', 'Arrivé', '2020-09-27 08:58:29'),
('96', '9', '27', '20', '15', 'Regulier', 'Interrompu', '2019-06-14 21:54:45'),
('97', '44', '16', '50', '21', 'Regulier', 'Arrivé', '2020-08-20 09:51:18'),
('98', '27', '78', '32', '17', 'Express', 'En préparation', '2019-05-11 18:37:02'),
('99', '22', '81', '45', '9', 'Regulier', 'Port (en route)', '2020-11-13 05:28:02'),
('100', '57', '1', '82', '10', 'Regulier', 'Annulé', '2019-12-15 03:50:36'),
('101', '43', '88', '42', '20', 'Express', 'En préparation', '2020-11-04 23:26:19'),
('102', '91', '16', '76', '8', 'Express', 'Annulé', '2019-05-28 06:32:00'),
('103', '46', '25', '61', '14', 'Regulier', 'Interrompu', '2020-10-23 01:38:41'),
('104', '45', '47', '65', '1', 'Express', 'Port (en route)', '2020-12-13 10:54:57'),
('105', '50', '30', '37', '11', 'Express', 'Prêt à partir', '2020-10-12 09:03:18'),
('106', '11', '12', '54', '4', 'Regulier', 'Prêt à partir', '2019-11-25 12:03:00'),
('107', '104', '50', '32', '22', 'Regulier', 'Annulé', '2019-10-03 16:04:31'),
('108', '62', '127', '4', '22', 'Express', 'En préparation', '2019-10-24 12:56:31'),
('109', '110', '17', '76', '20', 'Express', 'Arrivé', '2020-03-23 15:13:35'),
('110', '35', '90', '17', '7', 'Express', 'En route', '2019-01-03 20:47:31'),
('111', '81', '116', '93', '15', 'Express', 'En préparation', '2020-10-16 10:03:54'),
('112', '104', '28', '25', '5', 'Express', 'Prêt à partir', '2020-08-05 15:19:28'),
('113', '33', '49', '87', '21', 'Regulier', 'En route', '2020-08-24 07:58:57'),
('114', '53', '129', '13', '10', 'Regulier', 'Annulé', '2019-07-08 12:42:42'),
('115', '65', '114', '24', '9', 'Express', 'Port (en route)', '2019-07-05 04:03:55'),
('116', '32', '111', '71', '15', 'Regulier', 'Port (en route)', '2020-02-25 13:49:38'),
('117', '20', '117', '23', '22', 'Express', 'Annulé', '2020-09-25 14:56:06'),
('118', '3', '102', '6', '9', 'Regulier', 'Port (en route)', '2019-11-11 05:38:38'),
('119', '85', '10', '6', '10', 'Express', 'En préparation', '2020-04-15 22:31:48'),
('120', '99', '128', '62', '19', 'Express', 'Interrompu', '2020-05-08 00:19:37'),
('121', '93', '64', '97', '19', 'Express', 'Interrompu', '2020-01-01 04:15:48'),
('122', '81', '85', '87', '8', 'Regulier', 'Interrompu', '2020-12-29 21:33:47'),
('123', '115', '29', '63', '8', 'Regulier', 'Arrivé', '2020-10-14 06:00:53'),
('124', '3', '66', '84', '1', 'Express', 'Arrivé', '2019-03-10 19:38:27'),
('125', '109', '11', '76', '10', 'Regulier', 'Arrivé', '2020-09-13 10:08:53'),
('126', '130', '104', '6', '13', 'Express', 'En route', '2020-04-29 11:50:38'),
('127', '74', '64', '3', '18', 'Express', 'En préparation', '2020-06-28 05:58:22'),
('128', '55', '41', '25', '1', 'Regulier', 'En route', '2019-07-18 09:10:32'),
('129', '30', '127', '33', '18', 'Express', 'Prêt à partir', '2019-04-11 21:44:04'),
('130', '20', '72', '24', '17', 'Regulier', 'En route', '2019-12-26 21:07:36'),
('131', '72', '121', '82', '20', 'Express', 'Prêt à partir', '2020-10-31 08:48:06'),
('132', '59', '88', '91', '12', 'Regulier', 'En préparation', '2019-02-17 08:41:24'),
('133', '106', '65', '53', '13', 'Regulier', 'Port (en route)', '2020-05-23 15:35:17'),
('134', '86', '61', '81', '1', 'Regulier', 'Interrompu', '2020-11-04 13:20:51'),
('135', '84', '10', '17', '22', 'Regulier', 'En préparation', '2019-02-04 13:03:50'),
('136', '52', '63', '8', '11', 'Express', 'Arrivé', '2019-05-22 12:08:06'),
('137', '112', '44', '36', '18', 'Express', 'Arrivé', '2020-08-02 05:52:33'),
('138', '72', '94', '93', '15', 'Regulier', 'Port (en route)', '2020-12-06 21:28:42'),
('139', '45', '127', '3', '9', 'Regulier', 'Interrompu', '2019-11-04 16:05:49'),
('140', '9', '24', '65', '16', 'Regulier', 'En préparation', '2020-11-07 08:34:55'),
('141', '29', '77', '88', '22', 'Express', 'Arrivé', '2020-02-04 13:18:05'),
('142', '52', '32', '58', '16', 'Regulier', 'En préparation', '2020-05-23 08:55:41'),
('143', '34', '41', '8', '5', 'Express', 'En route', '2019-04-17 21:36:08'),
('144', '27', '71', '54', '4', 'Regulier', 'Prêt à partir', '2019-09-20 06:07:45'),
('145', '14', '27', '77', '6', 'Express', 'Port (en route)', '2020-01-17 14:00:37'),
('146', '31', '80', '1', '17', 'Express', 'Prêt à partir', '2020-06-11 05:07:41'),
('147', '77', '69', '82', '18', 'Express', 'Port (en route)', '2019-10-06 14:19:00'),
('148', '105', '40', '85', '10', 'Regulier', 'Annulé', '2019-04-12 18:13:04'),
('149', '7', '102', '100', '22', 'Regulier', 'En route', '2019-07-11 05:12:17'),
('150', '130', '93', '67', '6', 'Express', 'Annulé', '2019-07-10 05:18:45'),
('151', '46', '55', '54', '7', 'Regulier', 'Port (en route)', '2020-02-09 07:24:04'),
('152', '24', '7', '71', '6', 'Regulier', 'Annulé', '2019-08-09 17:37:22'),
('153', '64', '85', '37', '10', 'Express', 'En route', '2020-06-22 11:10:48'),
('154', '21', '99', '63', '11', 'Express', 'Port (en route)', '2019-02-28 22:55:57'),
('155', '97', '103', '21', '13', 'Express', 'Annulé', '2019-01-06 09:13:40'),
('156', '77', '42', '46', '14', 'Express', 'En route', '2020-09-17 23:46:26'),
('157', '97', '101', '25', '15', 'Express', 'Arrivé', '2019-05-27 00:28:52'),
('158', '76', '15', '84', '10', 'Regulier', 'Port (en route)', '2020-06-27 22:45:43'),
('159', '20', '76', '55', '2', 'Regulier', 'En route', '2019-03-13 15:09:26'),
('160', '97', '17', '67', '16', 'Express', 'En route', '2020-05-17 03:24:58'),
('161', '94', '109', '63', '10', 'Regulier', 'En route', '2019-11-12 01:58:43'),
('162', '23', '16', '87', '13', 'Express', 'En route', '2020-09-27 01:43:58'),
('163', '89', '80', '80', '7', 'Regulier', 'En préparation', '2019-10-03 18:21:57'),
('164', '34', '127', '7', '15', 'Regulier', 'Annulé', '2020-07-08 22:57:07'),
('165', '14', '53', '16', '1', 'Regulier', 'En route', '2019-05-10 11:49:27'),
('166', '63', '44', '57', '4', 'Express', 'Prêt à partir', '2020-09-20 15:21:29'),
('167', '102', '89', '63', '4', 'Regulier', 'Port (en route)', '2019-12-25 12:44:43'),
('168', '31', '7', '15', '2', 'Express', 'En préparation', '2019-05-23 12:21:16'),
('169', '110', '95', '78', '11', 'Regulier', 'Annulé', '2019-10-17 17:27:16'),
('170', '97', '125', '71', '11', 'Express', 'En route', '2020-03-05 08:22:22'),
('171', '127', '75', '36', '20', 'Regulier', 'En route', '2019-04-19 06:36:14'),
('172', '94', '45', '9', '6', 'Regulier', 'Interrompu', '2019-10-13 22:39:58'),
('173', '5', '130', '59', '2', 'Express', 'Annulé', '2020-08-21 05:01:37'),
('174', '21', '3', '85', '11', 'Express', 'En route', '2019-06-25 00:17:03'),
('175', '81', '72', '14', '7', 'Regulier', 'Interrompu', '2020-06-17 10:19:11'),
('176', '25', '97', '54', '6', 'Express', 'Annulé', '2020-08-08 17:45:28'),
('177', '106', '16', '74', '21', 'Express', 'Arrivé', '2020-02-06 09:40:40'),
('178', '89', '95', '48', '12', 'Regulier', 'Arrivé', '2020-11-21 04:50:50'),
('179', '25', '21', '87', '1', 'Regulier', 'Arrivé', '2020-02-05 10:23:07'),
('180', '78', '72', '61', '20', 'Regulier', 'Port (en route)', '2020-08-27 05:42:09'),
('181', '102', '111', '99', '5', 'Express', 'Arrivé', '2019-10-26 11:45:38'),
('182', '44', '87', '44', '4', 'Regulier', 'Arrivé', '2020-09-16 01:46:34'),
('183', '85', '34', '96', '9', 'Regulier', 'Prêt à partir', '2019-04-21 02:15:10'),
('184', '104', '74', '12', '4', 'Regulier', 'Interrompu', '2019-07-02 19:21:48'),
('185', '118', '15', '95', '6', 'Express', 'En préparation', '2019-05-06 15:10:59'),
('186', '15', '42', '73', '22', 'Regulier', 'Annulé', '2019-05-22 05:40:34'),
('187', '41', '47', '79', '8', 'Express', 'En route', '2019-02-21 13:14:38'),
('188', '82', '62', '93', '2', 'Express', 'Annulé', '2020-02-23 05:41:04'),
('189', '2', '30', '61', '3', 'Express', 'En préparation', '2019-03-11 08:26:03'),
('190', '102', '1', '41', '5', 'Regulier', 'Annulé', '2020-12-24 11:37:15'),
('191', '48', '110', '4', '10', 'Regulier', 'Arrivé', '2020-04-04 09:01:10'),
('192', '113', '66', '87', '12', 'Express', 'En route', '2019-01-02 02:32:18'),
('193', '107', '20', '100', '22', 'Regulier', 'En préparation', '2020-07-30 10:29:59'),
('194', '29', '55', '81', '21', 'Regulier', 'En préparation', '2019-01-09 17:05:38'),
('195', '104', '85', '30', '12', 'Regulier', 'En route', '2020-09-01 10:46:58'),
('196', '91', '32', '71', '19', 'Regulier', 'En préparation', '2020-09-03 11:46:14'),
('197', '106', '41', '4', '8', 'Regulier', 'En préparation', '2019-09-22 10:17:30'),
('198', '92', '124', '15', '6', 'Express', 'En route', '2020-08-26 16:35:15'),
('199', '25', '121', '82', '18', 'Regulier', 'Arrivé', '2019-11-07 13:38:45'),
('200', '2', '19', '85', '22', 'Express', 'Interrompu', '2020-11-05 12:07:26');

Mon dieu!!! c'est toi qui a créer toute ces données wow!!!

çca due être long

je peux t'appeler? c'est un bon moment pour toi?