INSERT INTO `t_adherent_adh` (`adh_nom`, `adh_prenom`, `adh_email`, `adh_statut`, `adh_numero`, `adh_rue`, `adh_codepostal`, `adh_ville`, `adh_telephone`, `adh_validite`, `cpt_pseudo`) VALUES
('Martin', 'Arthur', 'arthur_martin@gmail.com', 'M', 15, 'Rue de la Gare', 29000, 'Quimper', '0645781236', 'O', 'arthurmartin'),
('Boulanger', 'Baptiste', 'boulangerbapt@gmail.com', 'M', 14, 'Rue Charles de Gaulle', 29200, 'Brest', '0707088915', 'O', 'baptiseboulanger'),
('Husson', 'Benjamin', 'benjamin_husson@gmail.com', 'G', 42, 'Rue Kiel', 29200, 'Brest', '0626484286', 'O', 'benjaminhusson'),
('Pasquier', 'Benjamin', 'ben-pasquier@free.fr', 'M', 25, 'Rue Robespierre', 29200, 'Brest', '0712234556', 'O', 'benjaminpasquier'),
('Lamy', 'Elina', 'lamy_elina@gmail.Com', 'M', 16, 'Rue de Glasgow', 29200, 'Brest', '0632621569', 'O', 'elinalamy'),
('Roux', 'Elina', 'roux_elina@hotmail.fr', 'M', 54, 'Rue George Clémenceau', 29200, 'Brest', '0698457432', 'O', 'elinaroux'),
('Robert', 'Emilie', 'emi_robert@gmail.com', 'M', 96, 'Rue Jean Jacques Rousseau', 29000, 'Quimper', '0687964132', 'O', 'emilierobert'),
('Mallet', 'Julien', 'juju_mallet@laposte.fr', 'M', 7, 'Rue du Paradis', 29480, 'Le Relecq Kerhuon', '0612369637', 'M', 'julienmallet'),
('Jourdan', 'Lola', 'jourdan_lola@hotmail.Fr', 'M', 1, 'Rue Louis Jouvet', 29400, 'Guimiliau', '0796451937', 'O', 'lolajourdan'),
('Bernard', 'Marine', 'bernard.marine@gmail.com', 'M', 20, 'Rue Gambetta', 29200, 'Brest', '0698653214', 'O', 'marinebernard'),
('Benoist', 'Paul', 'paul_benoist@gmail.com', 'M', 65, 'Rue Jean Jaurès', 29200, 'Brest', '0775351595', 'O', 'paulbenoist'),
('Morel', 'Paul', 'pmorel@hotmail.fr', 'M', 23, 'Rue Anatole France', 29200, 'Brest', '0632123645', 'O', 'paulmorel'),
('Morel', 'Pierre', 'pierre_morel@yahoo.Fr', 'M', 42, 'Rue de la République', 29200, 'Brest', '0785416302', 'O', 'pierremorel'),
('Richard', 'Michel', 'richard.michel@yahoo.fr', 'G', 12, 'Rue de Normandie', 29200, 'Brest', '0687964512', 'O', 'richardmichel'),
('Le Brun', 'Samuel', 'lebrun_sam@yahoo.fr', 'M', 15, 'Rue de la Glacière', 29400, 'Landivisiau', '0712968574', 'O', 'samuellebrun'),
('Thomas', 'Jean', 'jean.thomas@gmail.com', 'G', 96, 'Rue de Bretagne', 29480, 'Le Relecq Kerhuon', '0674859636', 'O', 'thomasjean'),
('Pensec', 'William', 'william.pensec@hotmail.fr', 'G', 45, 'Rue Lavoisier', 29200, 'Brest', '0651360696', 'O', 'williampensec');







INSERT INTO `t_compte_cpt` (`cpt_pseudo`, `cpt_mdp`) VALUES
('arthurmartin', 'd3234416f1effffaf4eed314f6e01188'),
('baptiseboulanger', '4198779bda6c07e555fd57e37fdd6504'),
('benjaminhusson', 'f6696445d79f6e007d8df636179938b7'),
('benjaminpasquier', '0fd871659734e2a0c6362cd84e4a50fc'),
('elinalamy', '442db197e5243105e393bde06dde61cb'),
('elinaroux', '2047f779f8beb71bdad3295b84dcb6e2'),
('emilierobert', 'bdca52ef2d29b2d3123ec99b3bf1ae5f'),
('gestionnaireP', '9112db420f4b390b1b21237a529bb033'),
('julienmallet', '55a2f7a54befe9390bba6714671f39d2'),
('lolajourdan', '2b52967883e98976aaa42b9184f8ea63'),
('marinebernard', 'fcbfe7901ec6be8e5e923331b973d4c5'),
('paulbenoist', '55d143ca838b750ce0585f0e9464e414'),
('paulmorel', '17029b8b39b252d5f32f3582797e098c'),
('pierremorel', '79ef43fd283fd5aac1f032b017f6ac3e'),
('richardmichel', '395c2c454bf05f684c6b464a603c28eb'),
('samuellebrun', 'b9a6cc48bc36ff232df41f48078507bf'),
('thomasjean', 'd8988ceb9ddb2ec2a6acda939cf1c4fb'),
('williampensec', '4eb0856080b4e21ea4c09689dcd278a6');