-- Extraction du 10/12/23
insert into users (licence,name,first_name,birthday,category,email,password) values('1010658E','PETIT DUGARD','Alphonse','2017-01-13','U11','aurelie.dugard2912@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('1007305F','FERRAIRA RODRIGUES','Oriana','2015-12-16','U11','pscar_2005@hotmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0047969R','BONNET REFREGIER','JEAN','2015-01-08','U11','jeanluc8bonnet@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0047966M','BENEZECH','Emilie','2014-12-26','U11','julie.mailhe@orange.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0023078K','LE COZ','Candice','2014-12-15','U11','mandou-elan@hotmail.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0026454E','KARABALIAN','Gaspar','2014-07-29','U11','exbrayat.fannie@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0063469N','GARCIA','Hugo','2014-01-27','U11','alain.g11@laposte.net','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('1010661H','PETIT DUGARD','Leon','2014-01-06','U11','aurelie.dugard2912@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('1007310K','POSTIGO','Charlotte','2013-10-21','U13','cecilemunesa@hotmail.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0051185L','BRUT','Adrien','2013-07-09','U13','asadbrut1212@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0063468M','LAFON','ALEXANDRE','2014-11-25','U11','eldorass@netcourrier.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0023048C','LALLIER-GOLLET','Lilou','2013-06-15','U13','laflambee@hotmail.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('1021132A','FIZES','Heloïse','2013-05-31','U13','audrey-suissa@hotmail.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0043969T','MARTIN','LENNY','2013-02-09','U13','patrice.martin59@orange.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0023043X','ROUSTAN','DYLAN','2013-01-14','U13','aurelieroustan@yahoo.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0047957C','AZAIS FILLET','MAËL','2012-10-06','U13','dominique.azais@sfr.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('1005145D','SENESI','Eloïse','2012-07-31','U13','delphine.costa5@orange.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('1008199P','TREMBLAY','Alicia','2012-02-21','U13','anne.miquel2@free.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0031543L','SAVOYANT','BENJI','2011-12-20','U15','jennybm.jg.jg@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0008546P','MUTEY','Celian','2011-06-18','U15','jf.mutey@orange.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('1004369H','JAUFFRET','Raphael','2011-01-30','U15','virginie.jauffret@me.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('1008184A','CONNES','Clémence','2011-01-07','U15','connes.muriel@orange.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0043962K','PAGE','Lily','2010-11-30','U15','paginations@yahoo.co.uk','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0060951B','CROS','ANTONY','2010-09-17','U15','alaincros991@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0063470P','GARCIA','Clement','2010-07-08','U15','alain.g11@laposte.net','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0998522A','PETRAUD','ANAIS','2010-06-04','U15','celinesauvaitre@hotmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('1019174S','PUEL','Marie','2010-02-07','U15','katia.puel@outlook.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0054950D','PRIVAT','Duncan','2009-07-15','U18','nathalie.gazel@sfr.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0047799F','THIERS','Léona','2009-07-10','U18','severine.fabre3@wanadoo.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0045550L','GALZIN','Emilien','2009-03-15','U18','emibessierelie@orange.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('1014986Q','GUISLAIN','Gabin','2008-10-04','U18','gabin.guislain@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0052253X','GABEN','Mathias','2008-09-29','U18','juliengaben@orange.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('1012101R','CRASSOUS','Lucie','2008-07-18','U18','lucie.crassous12@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0048684T','BELIN','Mickael','2008-05-15','U18','ag.belin@orange.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0048687W','MICHEL','Noé','2008-04-24','U18','p.michel800@laposte.net','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('1013025F','ARLES','Lucie','2008-04-09','U18','arleslucie12@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0043956D','MALLEVIALE-GAYRAUD','Maëlys','2007-12-20','U18','maelysg325@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0023033L','MAZET','ROMAIN','2007-12-11','U18','romain.mazet12@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0998468S','VERNHES','SIMON','2007-11-03','U18','juliecros12@yahoo.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0040828D','FLAVIER','Margot','2007-08-30','U18','magali.nespoulous@wanadoo.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('1008197N','REMY','Eliott','2007-08-28','U18','remy.eliott12490@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0978380G','BOCHER','Elisa','2007-08-14','U18','elisa.bocher14@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('1004367F','JAUFFRET','Logan','2007-04-30','U18','logan.jauffret@icloud.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0052594T','ZANARDE','LÉO','2006-11-09','U21','zanardeleo@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('1004365D','GAILLARD','Gabriel','2006-08-15','U21','gabrielgaillard582@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('1001072M','JULIEN','Elena','2006-07-29','U21','elenajulien1@outlook.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0978378E','HADOURI GANET','Meli','2006-03-09','U21','ganet_peggy@yahoo.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0033972B','CAMBON','ARTHUR','2005-01-16','U21','sneaxarthur@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0977021E','DRESSAYRE','LUCIEN','2003-03-15','Sénior 1','lucien.savignac@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0000295W','TOFFOLON','BERTRAND','1996-05-14','Sénior 1','b.toffolon@outlook.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0061624H','PERONNET','Elie','1996-04-16','Sénior 1','nathalie.peronnet@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('1004352Q','MERCIER','Kevin','1994-03-25','Sénior 1','kmercier49@yahoo.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0037870N','HOUDART','Vincent','1988-06-30','Sénior 1','vincentbdbhoudart@live.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0054014L','DUFRENNE','Julien','1987-08-22','Sénior 1','julduff@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0026144T','BERNARD','Alphonse','1987-04-02','Sénior 1','alphonsebernard@ymail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0042295Y','RAPP','FLORENT','1986-07-28','Sénior 1','florent.rapp@hotmail.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0890354B','BEAUD','Benedicte','1984-03-13','Sénior 2','benedicte.beaud@hotmail.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0054021U','ROUSTAN','NICOLAS','1981-04-24','Sénior 2','nicolasdu34@yahoo.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0061552E','ECHEGUT','NICOLAS','1981-04-03','Sénior 2','nico.echegut@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0974956K','BOCHER','SAMUEL','1979-02-16','Sénior 2','sambocher@yahoo.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('1019536Q','CAUMES','Mickael','1978-07-03','Sénior 2','caumes.mickael@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('1003001R','TERRAL','Nathalie','1976-04-22','Sénior 2','nathalie.terral@sfr.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0998518W','CORNUEJOULS','STEPHANE','1975-02-24','Sénior 2','scornuejouls@ac-toulouse.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('1003004U','MOHANDIS','Aniss','1973-10-13','Sénior 2','a.mohandis@free.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0997274U','AZAM','THIERRY','1972-01-29','Sénior 2','thierryazam12@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0063026G','ALFONSO','JOSÉ','1970-08-27','Sénior 2','jose.alfonso@sfr.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0936344R','PIEL','Michel','1967-03-17','Sénior 2','pielmichel70@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0998524C','MAUREL','JEROME','1966-12-21','Sénior 2','jjsac@free.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0997242J','BERNARD','SANDRINE','1966-03-31','Sénior 2','sbsandrine.p@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0026468V','LE BEL','CHRISTIAN','1965-07-21','Sénior 2','christ.le.bel@hotmail.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0001267C','GARCIA','Philippe','1964-01-08','Sénior 3','philduweb@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0051180F','GINER','CHRISTINE','1961-12-30','Sénior 3','gerard.christine12@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0398315B','HOMMET','Bruno','1957-11-02','Sénior 3','bruno.hommet@gmail.com','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');
insert into users (licence,name,first_name,birthday,category,email,password) values('0998520Y','PIERRE','CHRISTIAN','1950-06-17','Sénior 3','c.pierre22a@orange.fr','$2y$10$UYUSAUuBG7FD69eyurtOI.mjpPdRMxidacrwpuS0mj78Xm1bc4zti');


-- Départs Compétitions
insert into departures_comp (club, date_dep, am_pm, infos) values('Neptune', '2024-10-03', 'Matin', 'Inscription 12€');
insert into departures_comp (club, date_dep, am_pm, infos) values('Neptune', '2024-10-03', 'Après-midi', 'Inscription 15€');
insert into departures_comp (club, date_dep, am_pm, infos) values('Saturne', '2024-11-03', 'Après-midi', 'Inscription 10€ buvette');
insert into departures_comp (club, date_dep, am_pm, infos) values('Lune', '2024-09-03', 'Matin', 'Inscription 15€ pas de restauration');

-- Armes
insert into weapons(name) values('Classique');
insert into weapons(name) values('Arc nu');
insert into weapons(name) values('Poulie');

--  registration_competitions
insert into registrations_competitions (id_user, id_dep, id_weapon) values(71, 2, 1);
insert into registrations_competitions (id_user, id_dep, id_weapon) values(12, 2, 3);
insert into registrations_competitions (id_user, id_dep, id_weapon) values(37, 2, 2);
insert into registrations_competitions (id_user, id_dep, id_weapon) values(64, 3, 2);
