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', 'franck39@wanadoo.fr'),
('2', 'chemin de Thibault', 'Klein-la-Forêt', 'Yemen', '01 12 55 97 49', 'edouard.durand@gmail.com'),
('3', '89, boulevard de Philippe', 'Guilbert', 'Cocos (Îles)', '+33 (0)1 67 39 99 14', 'hugues.neveu@guyon.fr'),
('4', '59, impasse Devaux', 'Reynaudboeuf', 'Nauru', '+33 (0)7 33 78 32 67', 'petitjean.patrick@julien.org'),
('5', '714, place Fouquet', 'Lecomte-les-Bains', 'Belize', '+33 (0)9 49 35 21 58', 'nlaporte@tiscali.fr'),
('6', '62, boulevard Laroche', 'Gallet-sur-Baron', 'Honduras', '+33 (0)6 38 32 14 49', 'qbourdon@hotmail.fr'),
('7', '3, chemin Devaux', 'Marion-sur-Pages', 'Gambie', '+33 (0)8 97 80 59 00', 'roger58@gmail.com'),
('8', 'avenue Denis', 'BoulangerBourg', 'Bolivie', '+33 6 37 22 85 15', 'ythomas@noos.fr'),
('9', '8, chemin Michelle Boucher', 'Herve-les-Bains', 'Uruguay', '+33 (0)2 70 73 61 51', 'juliette51@voila.fr'),
('10', '71, chemin de Boyer', 'Moreau', 'Tunisie', '+33 1 46 99 71 27', 'margaud36@giraud.net'),
('11', '21, place Deschamps', 'Chauvet', 'Tuvalu', '+33 5 77 22 02 70', 'munoz.patrick@gmail.com'),
('12', '86, boulevard Lelievre', 'Thierry', 'Polynésie française', '07 55 31 69 00', 'toussaint.laurent@tessier.org'),
('13', '89, boulevard Ferrand', 'Leblanc', 'Ouganda', '08 93 22 49 46', 'pires.emmanuelle@orange.fr'),
('14', '64, avenue de Marty', 'Cordier', 'Guyane', '0146259142', 'wguichard@ifrance.com'),
('15', 'rue Fernandez', 'Hamon', 'Bouvet (Îles)', '+33 9 16 47 26 94', 'frederique.perez@club-internet.fr'),
('16', '46, impasse Hebert', 'Dupuynec', 'Laos', '+33 (0)3 65 63 52 38', 'perrot.amelie@orange.fr'),
('17', '65, avenue Techer', 'Barbe', 'Irlande', '+33 4 10 20 50 38', 'nicolas.schneider@noos.fr'),
('18', '181, place Maurice Rey', 'Bouvier', 'Afrique du sud', '0800840773', 'andre42@tele2.fr'),
('19', '4, chemin de Godard', 'Guillou', 'Ouganda', '0740784923', 'hmarques@ifrance.com'),
('20', '1, chemin Lucas Seguin', 'Loiseau-sur-Hoareau', 'Chine (Rép. pop.)', '+33 (0)9 59 04 53 17', 'bourgeois.vincent@live.com'),
('21', 'rue Rémy Letellier', 'Poirier-sur-Navarro', 'Belize', '03 44 11 95 32', 'colette88@bertin.fr'),
('22', '69, avenue Louis Cordier', 'Guyotnec', 'Danemark', '05 25 43 70 12', 'margot.barbier@teixeira.com'),
('23', 'chemin Alexandre Letellier', 'Delaunay-sur-Blanc', 'Saint-Marin (Rép. de)', '+33 2 16 41 23 22', 'gabriel.rolland@becker.com'),
('24', '7, impasse Margot Marchal', 'Laporte', 'Myanmar', '06 61 51 49 97', 'qpichon@vallee.org'),
('25', '27, boulevard Carre', 'Berger', 'Tchad', '+33 2 37 05 64 60', 'pberger@carlier.org'),
('26', '64, boulevard Torres', 'Michel', 'Slovénie', '03 32 97 79 86', 'tmoreno@orange.fr'),
('27', '74, boulevard de Payet', 'Goncalves', 'Soudan', '02 47 39 48 96', 'adrien90@paris.org'),
('28', '788, boulevard Maillard', 'Faivre', 'Lesotho', '+33 1 72 62 94 78', 'lpires@blanchet.fr'),
('29', 'impasse de Thierry', 'GarciaBourg', 'Antarctique', '07 66 04 71 11', 'paulette68@collin.org'),
('30', 'boulevard Hugues Potier', 'Michel', 'Vietnam', '0506545511', 'bleroux@ledoux.com'),
('31', '302, chemin de Georges', 'Diallo', 'Syrie', '+33 (0)1 11 58 39 77', 'danielle.foucher@meyer.com'),
('32', 'rue Antoine Chretien', 'Noel', 'Arménie', '+33 (0)3 85 89 52 41', 'marechal.benjamin@joseph.com'),
('33', 'chemin de Leleu', 'Poulain', 'Royaume-Uni', '+33 (0)7 37 62 75 74', 'jpotier@laposte.net'),
('34', '4, impasse Perrot', 'Camusboeuf', 'Singapour', '+33 (0)1 07 77 78 24', 'vbuisson@yahoo.fr'),
('35', '32, impasse Georges Gimenez', 'Barre-sur-Moreno', 'Chili', '0116162300', 'victoire.payet@lacombe.fr'),
('36', '238, avenue de Laine', 'Maillard', 'Tchad', '+33 4 46 00 40 38', 'xlelievre@leroux.org'),
('37', '2, impasse Legendre', 'Dos Santos', 'Angola', '0771428540', 'louis.baron@voila.fr'),
('38', '40, chemin Hardy', 'BerthelotVille', 'Seychelles', '05 15 72 01 31', 'xthibault@laine.fr'),
('39', '53, chemin Ribeiro', 'Fleurydan', 'Sierra Leone', '07 63 81 21 95', 'christophe.fischer@guyon.fr'),
('40', '50, rue Célina Noel', 'Vasseur-sur-Garcia', 'Turks et Caïques (Îles)', '04 68 14 15 65', 'manon.faivre@rousseau.fr'),
('41', '214, boulevard Alexandre', 'Legerdan', 'Pakistan', '+33 1 20 17 03 40', 'sylvie.legall@sfr.fr'),
('42', '75, chemin de Leconte', 'Lopesboeuf', 'Israël', '+33 (0)1 11 02 99 10', 'weber.audrey@sfr.fr'),
('43', '20, impasse Théophile Roux', 'Gay', 'Danemark', '0694833102', 'tristan25@live.com'),
('44', '3, avenue Carpentier', 'Poirier-sur-Guillet', 'Pologne', '+33 1 98 73 08 77', 'mmarion@orange.fr'),
('45', '99, boulevard de Gilles', 'Blot', 'Estonie', '+33 5 35 10 58 97', 'robert96@voila.fr'),
('46', '31, boulevard Bernadette Hardy', 'Bruneau', 'Seychelles', '05 17 34 82 32', 'ebarthelemy@ledoux.com'),
('47', '20, rue Gros', 'Royer', 'Timor', '+33 2 79 62 66 11', 'vincent.arnaud@yahoo.fr'),
('48', '564, rue de Dos Santos', 'Lebon', 'Ouganda', '02 15 47 98 59', 'lenoir.josette@gmail.com'),
('49', '57, avenue Vincent', 'Charrier', 'Égypte', '+33 6 78 93 77 13', 'zribeiro@bouygtel.fr'),
('50', '6, impasse Dufour', 'Pichon', 'Zaïre', '+33 9 02 62 69 42', 'michele.bodin@voila.fr');

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', 'joly.frederic@baudry.com', 'Édith Gillet'),
('2', '20', 'Wagner SAS', 'diaz.henri@bouvier.com', 'Brigitte-Frédérique Marin'),
('3', '30', 'Delaunay S.A.R.L.', 'kleroy@gallet.com', 'Aurélie David'),
('4', '29', 'Robert Giraud S.A.', 'evallee@giraud.fr', 'Gabrielle Jacob'),
('5', '27', 'Vidal Valette S.A.S.', 'ferrand.francois@joubert.com', 'Antoinette Legrand'),
('6', '5', 'Blot', 'gblanchard@collin.org', 'Hélène Leblanc'),
('7', '2', 'Guillon Mathieu SAS', 'pgoncalves@camus.net', 'Honoré de la Bouvier'),
('8', '9', 'Devaux SA', 'courtois.patrick@chartier.com', 'Martin Brunet'),
('9', '19', 'Teixeira', 'leon53@guichard.com', 'Thierry-Benjamin Baron'),
('10', '2', 'Martins', 'steixeira@pelletier.com', 'Daniel Petit-Moulin'),
('11', '37', 'Guillou', 'pherve@legoff.com', 'Laurence Techer-Le Roux'),
('12', '11', 'Francois Hubert S.A.S.', 'bousquet.marguerite@carre.fr', 'Henri-Daniel Mercier'),
('13', '19', 'Hamel', 'moreau.nicole@reynaud.fr', 'Grégoire Delmas-Morel'),
('14', '14', 'Bouchet', 'sophie22@masse.org', 'Joseph Peltier'),
('15', '15', 'Gomez', 'obourdon@lacroix.com', 'Thierry Gomez'),
('16', '34', 'Bourgeois S.A.R.L.', 'margot00@mercier.com', 'Laure Joubert-Barbe'),
('17', '40', 'Berthelot S.A.R.L.', 'llanglois@samson.net', 'Pauline Guillaume-Lebon'),
('18', '13', 'Aubert', 'michelle11@pottier.fr', 'Rémy Hoareau'),
('19', '40', 'Rousseau Richard SARL', 'antoinette.marie@arnaud.com', 'Claude Peron'),
('20', '2', 'Menard', 'breton.nicole@bernard.com', 'Thibaut Barthelemy'),
('21', '41', 'Bouvier SA', 'bernadette.foucher@legoff.net', 'Paul Jourdan'),
('22', '21', 'Menard', 'martin51@giraud.fr', 'Théophile Le Garcia'),
('23', '46', 'Julien SARL', 'sebastien.francois@labbe.fr', 'Alexandre Francois'),
('24', '28', 'Alexandre', 'dias.capucine@simon.com', 'Christophe Garcia'),
('25', '1', 'Bonnin', 'dguillot@becker.fr', 'Margaud-Marie Petit'),
('26', '47', 'Boulanger SAS', 'eric.marion@mendes.com', 'Victor Collet'),
('27', '14', 'Gregoire S.A.', 'kbertin@gilles.com', 'Amélie Texier'),
('28', '34', 'Peltier et Fils', 'alix92@morvan.org', 'Thibaut Hernandez'),
('29', '42', 'Barbier Perrier SARL', 'isaac.pineau@besnard.net', 'Luc Marechal'),
('30', '27', 'Chauveau SARL', 'denise79@laroche.fr', 'Michel Laurent'),
('31', '43', 'Lebon Loiseau et Fils', 'simone52@roussel.org', 'Suzanne Lamy'),
('32', '46', 'Poulain', 'olivie.legros@bailly.org', 'Gilbert Guillaume'),
('33', '9', 'Carre', 'emilie14@guerin.com', 'Margot Aubry'),
('34', '23', 'Bernier Thibault S.A.R.L.', 'philippine.hebert@perrot.org', 'Michèle Pires-Delattre'),
('35', '37', 'Gautier', 'mfouquet@girard.fr', 'Geneviève Bigot'),
('36', '29', 'Clerc', 'klopez@brunet.org', 'Susanne Gonzalez-Marechal'),
('37', '12', 'Gallet et Fils', 'marques.marc@regnier.fr', 'Frédéric Albert'),
('38', '23', 'Delannoy Didier S.A.S.', 'edith11@colin.com', 'Guillaume Ferrand'),
('39', '12', 'Rousset S.A.S.', 'pfernandez@gosselin.org', 'Claude-Guillaume Lejeune'),
('40', '45', 'Didier', 'jean.normand@besson.net', 'Catherine Devaux'),
('41', '12', 'Lesage Andre S.A.R.L.', 'barre.lucie@poulain.net', 'Geneviève Humbert'),
('42', '1', 'Pelletier Marques SA', 'eugene.robin@hamel.org', 'Thomas Lefevre'),
('43', '46', 'Guillot S.A.', 'alex38@gay.org', 'Marthe Breton'),
('44', '38', 'Faure', 'rlouis@jacob.com', 'Pierre Godard-De Sousa'),
('45', '9', 'Toussaint Dumas S.A.', 'wbuisson@chretien.org', 'Michelle-Aimée Guyot'),
('46', '6', 'Lebreton', 'vgilles@neveu.com', 'Gabrielle Couturier-Perez'),
('47', '16', 'Georges Laporte SA', 'lucie.roux@blanchet.fr', 'Jérôme Charpentier'),
('48', '5', 'Hoarau Benoit S.A.S.', 'suzanne92@brun.net', 'Xavier Hoareau-Pelletier'),
('49', '48', 'Fischer Barbier S.A.', 'wphilippe@dupuis.org', 'Vincent de la Caron'),
('50', '34', 'Charpentier Perrier SAS', 'courtois.lucy@chauvet.com', '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?