--
-- Host: qzhwvys2aph.mysql.db    Database: qzhwvys2aph
-- ------------------------------------------------------
--
-- Dumping data for table `structures`
--
-- ORDER BY:  `id`
INSERT INTO `structures` (`id`, `name`, `logo`, `bgcolor`, `fgcolor`) VALUES (1,'2APH','2APH.png','',''),(2,'CFAS Centre','2APH.png','408080',''),(3,'CFAS Occitanie Ouest','','266085','ffffff'),(4,'CFAS Auvergne','2APH.png','5286c5','000000'),(5,'CFA Inclusif','','',''),(6,'ADAPT Bretagne','','',''),(7,'CFA Relai Avenir Pro','','',''),(8,'CFAS Occitanie Est','','',''),(9,'CFAS Hauts de France Agap','','',''),(10,'CFAR Formation Adaptée','','','');
--
-- Dumping data for table `users`
--
-- ORDER BY:  `id`
INSERT INTO `users` (`id`, `profile`, `structure`, `user`, `pass`, `full`, `mail`, `tel`) VALUES (1,1,1,'admin','sUp3r-uS3r','Administrateur','',''),(2,1,1,'presidente','Gardou-2021','Nathalie Leprat','',''),(3,2,4,'Benoît Ayme','1234','Benoît Ayme','b.ayme@cfas-auvergne.com','634272975'),(4,2,6,'v.grandemange','1234','Véronique Grandemange','',''),(5,3,2,'j.gaudin','CFAS45','Joel Gaudin','joel.gaudin@cfas-centre.fr',''),(6,3,2,'z.ozsolak','CFAS28','Zahide Ozsolak','zahide.ozsolak@cfas-centre.fr',''),(7,3,2,'i.millet','CFAS37','Isabelle Millet','isabelle.millet@cfas-centre.fr',''),(8,3,2,'n.kos','CFAS41','Nathalie Kos','nathalie.kos@cfas-centre.fr','647941878'),(9,4,2,'g.picotin','1234','gaelle picotin','gaelle.picotin@cfas-centre.fr',''),(10,2,2,'cfas.centre','1234','cfas centre','cfas-centre@cfas-centre.fr',''),(11,1,1,'admin2','2aph.admin2','Cécile Chartreau','c.chartreau@arseaa.org','676090067'),(12,2,3,'arseaa','1234','cfas arseaa','',''),(13,2,5,'s.hochard','Aquitaine19','Sonia Hochard','s.hochard@lespep19.org',''),(14,4,5,'m.combes','CFAinclusif19','Magali Combes','magali.combes3@gmail.com','684497073'),(15,4,5,'s.pouget','CFApep19','Sabrina Pouget','s.pouget@lespep19.org','675052381'),(16,3,5,'Sonia HOCHARD','CharlieCFA19!','Sonia HOCHARD','s.hochard@lespep19.org','785877950'),(17,2,9,'Jean-Christophe Parez','1234','Jean-Christophe Parez','',''),(18,2,7,'Laurent Bossu','1234','Laurent Bossu','direction@avenirpro.fr','0672872787'),(19,2,8,'Karine Chmiel','1234','Karine Chmiel','',''),(20,2,3,'Eric Massuyeau','1234','Eric Massuyeau','',''),(21,3,3,'gestionaire gdc','1234','Marcel Durand','marcel.durand@gdc.fr',''),(22,2,10,'Christine Maillis','2407','Christine Maillis','cmaillis@formationmetier.fr','0618573736'),(23,3,6,'n.hemmerlin','1234','Nadège Hemmerlin','hemmerlin.nadege@ladapt.net','06 40 06 83 83'),(24,3,6,'l.piton','1234','Laetitia Piton','piton.laetitia@ladapt.net','0623411434'),(25,3,6,'m.lefaucheux','1234','Mélissa Lefaucheux','',''),(26,3,6,'s.dubillot','1234','Stéphanie Dubillot','',''),(27,3,6,'a.bouchoux','1234','Annabelle Bouchoux','',''),(28,3,10,'Hélène INGOUF','3112','Hélène INGOUF','hingouf@formationmetier.fr','0672599951');
--
-- Dumping data for table `apprentices`
--
-- ORDER BY:  `id`
INSERT INTO `apprentices` (`id`, `structure`, `name`, `firstname`, `use_fem`, `birthday`, `start`) VALUES (1,6,'Apprentie 1 Bretagne','Bécassine',1,'2000-06-20',NULL),(2,2,'PROUST','MARIE',1,'2000-06-20',NULL),(3,2,'MARETHEU','Louis',0,'2005-05-25',NULL),(4,5,'FORNASIER','Marion',1,'2000-09-21','2021-07-01'),(5,6,'KERDRANVAT','Alice',1,'1999-04-23','2018-09-03'),(6,7,'BELBACHIR','THOMAS',1,'1998-05-12','2021-02-26');
--
-- Dumping data for table `answers`
--
-- ORDER BY:  `apprentice`,`question`,`entry_date`
INSERT INTO `answers` (`apprentice`, `question`, `choice`, `text`, `entry_date`, `entry_user`) VALUES (3,1,1,'','2021-06-28',7),(3,2,1,'','2021-06-28',7),(3,3,1,'','2021-06-28',7),(3,4,1,'','2021-06-28',7),(3,5,1,'','2021-06-28',7),(3,6,1,'','2021-06-28',7),(3,7,1,'','2021-06-28',7),(3,8,1,'','2021-06-28',7),(3,9,1,'','2021-06-28',7),(3,10,1,'','2021-06-28',7),(3,11,2,'','2021-06-28',7),(3,12,1,'','2021-06-28',7),(3,13,1,'','2021-06-28',7),(3,14,1,'','2021-06-28',7),(3,15,1,'','2021-06-28',7),(3,16,1,'','2021-06-28',7),(3,17,1,'','2021-06-28',7),(3,18,1,'','2021-06-28',7),(3,19,1,'','2021-06-28',7),(3,20,1,'','2021-06-28',7),(3,21,2,'','2021-06-28',7),(3,22,2,'','2021-06-28',7),(3,23,2,'','2021-06-28',7),(3,24,2,'','2021-06-28',7),(3,25,4,'','2021-06-28',7),(3,26,1,'','2021-06-28',7),(3,27,1,'','2021-06-28',7),(3,28,3,'','2021-06-28',7),(3,29,2,'','2021-06-28',7),(3,30,2,'','2021-06-28',7),(3,31,1,'','2021-06-28',7),(3,32,2,'','2021-06-28',7),(3,33,2,'','2021-06-28',7),(3,34,1,'','2021-06-28',7),(3,35,2,'','2021-06-28',7),(3,36,2,'','2021-06-28',7),(3,37,1,'','2021-06-28',7),(3,38,1,'','2021-06-28',7),(3,39,2,'','2021-06-28',7),(3,40,2,'','2021-06-28',7),(3,41,1,'','2021-06-28',7),(3,42,2,'','2021-06-28',7),(3,43,2,'','2021-06-28',7),(3,44,1,'','2021-06-28',7),(3,45,1,'','2021-06-28',7),(3,46,2,'','2021-06-28',7),(3,47,1,'','2021-06-28',7),(3,48,1,'','2021-06-28',7),(3,49,1,'','2021-06-28',7),(3,50,2,'','2021-06-28',7),(3,52,2,'','2021-06-28',7),(3,53,1,'','2021-06-28',7),(3,55,1,'','2021-06-28',7),(3,57,1,'','2021-06-28',7),(3,59,1,'','2021-06-28',7),(3,60,1,'','2021-06-28',7),(3,61,1,'','2021-06-28',7),(3,62,1,'','2021-06-28',7),(3,63,1,'','2021-06-28',7),(3,64,1,'','2021-06-28',7),(3,65,1,'','2021-06-28',7),(3,66,2,'','2021-06-28',7),(3,68,2,'','2021-06-28',7),(3,70,4,'','2021-06-28',7),(3,72,1,'','2021-06-28',7),(3,74,2,'','2021-06-28',7),(3,75,1,'','2021-06-28',7),(3,78,1,'','2021-06-28',7),(3,79,3,'','2021-06-28',7),(4,1,3,'','2021-06-28',13),(4,2,4,'','2021-06-28',13),(4,3,3,'','2021-06-28',13),(4,4,3,'','2021-06-28',13),(4,5,3,'','2021-06-28',13),(4,6,4,'','2021-06-28',13),(4,7,4,'','2021-06-28',13),(4,8,4,'','2021-06-28',13),(4,9,4,'','2021-06-28',13),(4,10,3,'','2021-06-28',13),(4,11,3,'','2021-06-28',13),(4,12,3,'','2021-06-28',13),(4,13,4,'','2021-06-28',13),(4,14,2,'','2021-06-28',13),(4,15,2,'','2021-06-28',13),(4,16,3,'','2021-06-28',13),(4,17,3,'','2021-06-28',13),(4,18,3,'','2021-06-28',13),(4,19,2,'','2021-06-28',13),(4,21,4,'','2021-06-28',13),(4,22,3,'','2021-06-28',13),(4,23,1,'','2021-06-28',13),(4,24,3,'','2021-06-28',13),(4,25,3,'','2021-06-28',13),(4,26,3,'','2021-06-28',13),(4,27,3,'','2021-06-28',13),(4,28,3,'','2021-06-28',13),(4,29,3,'','2021-06-28',13);
--
-- Dumping data for table `needs`
--
-- ORDER BY:  `apprentice`,`adapt`,`entry_date`
INSERT INTO `needs` (`apprentice`, `adapt`, `need`, `details`, `entry_date`, `entry_user`) VALUES (3,4,0,'Troubles du langage écrit: dyslexie/dysorthographie','2021-06-28',7),(3,7,1,'','2021-06-28',7),(3,8,1,'','2021-06-28',7),(3,10,1,'','2021-06-28',7),(3,11,1,'','2021-06-28',7),(3,13,1,'','2021-06-28',7),(3,14,1,'','2021-06-28',7),(3,18,0,'limiter la copie et la prise de notes','2021-06-28',7),(3,20,1,'','2021-06-28',7),(3,21,1,'','2021-06-28',7),(3,22,1,'','2021-06-28',7),(3,23,1,'','2021-06-28',7),(3,24,1,'','2021-06-28',7),(3,25,0,'valorisation, mise en confiance','2021-06-28',7),(3,26,1,'','2021-06-28',7),(3,28,1,'','2021-06-28',7),(3,30,1,'','2021-06-28',7),(3,31,1,'','2021-06-28',7),(3,32,0,'ne pas tenir compte de l\'orthographe','2021-06-28',7),(3,33,1,'','2021-06-28',7),(3,34,1,'','2021-06-28',7),(3,35,1,'','2021-06-28',7),(3,38,1,'','2021-06-28',7),(3,39,1,'','2021-06-28',7),(3,40,1,'','2021-06-28',7),(3,41,1,'','2021-06-28',7),(3,42,1,'','2021-06-28',7),(3,45,1,'','2021-06-28',7),(3,46,1,'','2021-06-28',7),(3,47,1,'','2021-06-28',7),(3,49,1,'','2021-06-28',7),(3,51,1,'','2021-06-28',7),(3,52,1,'','2021-06-28',7),(3,53,1,'','2021-06-28',7),(3,56,1,'','2021-06-28',7),(3,75,1,'','2021-06-28',7),(3,79,1,'','2021-06-28',7),(3,84,1,'','2021-06-28',7),(3,85,0,'à préciser en fin de 1ère année en concertation','2021-06-28',7),(3,88,1,'','2021-06-28',7),(6,5,1,'','2021-06-30',18),(6,6,1,'','2021-06-30',18),(6,7,1,'','2021-06-30',18);
--
-- Dumping data for table `logins`
--
-- ORDER BY:  `id`,`ip`,`ua`
INSERT INTO `logins` (`id`, `ip`, `ua`, `last_time`, `auth`) VALUES (1,'62.147.206.116','Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0',1624960270,'8fa7a578b64b33d450f0bdb93dc5434c'),(2,'109.17.81.9','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36',1624961333,'4ac65cb73829cc67ebb3965e1201f108'),(4,'2a04:cec0:109e:a','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36',1625047835,'270781c41f84c54e542bf6307e454c04'),(4,'31.33.192.151','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36',1625029214,'e5fd2f04add3559d9db05f7d033c7956'),(4,'77.74.212.27','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36',1624979118,'764dd9ed70bd644b7ef291533fdad782'),(5,'2a01:cb00:83c8:4','Mozilla/5.0 (Windows NT 6.3; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36',1624958395,'92b690dcdc385805c3b3c8fbe8c77c8c'),(6,'79.83.199.136','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36',1624952979,'63caccc53c94af19f56e5a2c4f1a201d'),(8,'2a04:cec0:118b:1','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36',1624976842,'a03b1f832fffa7973d11c2a0e2d759fa'),(8,'62.147.206.116','Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0',1624913200,'d53dac160e7ed6f9ff790e9426d1621a'),(8,'92.184.97.68','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36',1624952189,'913a71a65f8aed3fb36645966148f8d8'),(10,'109.17.81.9','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36',1624961346,'4c5a28161ff8a9f4be6f2a15d4b3e964'),(10,'62.147.206.116','Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0',1624964298,'38d0c225459ce2a9f494f6fec4b4826d'),(11,'217.109.39.253','Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0',1624980467,'1538404d4e3987d82d4f5a6302b3d93e'),(12,'217.109.39.253','Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0',1624973590,'55623f7feb794955eb9618158a3d3e4c'),(15,'62.147.206.116','Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0',1624961552,'3b1f7a37a4322410844682c96d1c4f91'),(16,'62.147.206.116','Mozilla/5.0 (Windows NT 6.1; Win64; x64; rv:78.0) Gecko/20100101 Firefox/78.0',1625054866,'c1f551983310bdf13e741e9c5ed6c8a5'),(18,'185.228.228.98','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36',1625044806,'6f324e4a3cb817a9899bf74f03a21c70'),(18,'185.228.231.244','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36',1625044926,'8e56b60011eadea026b4042517aebe03'),(22,'194.250.240.32','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36',1625054093,'9b8838b50e0aefd6407a898863f2f3e1'),(23,'2a04:cec0:109e:a','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36',1625047334,'c5da5c86f8ce5675d9057839ea7c7642'),(23,'77.74.212.27','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36',1624979091,'90185cd29fc4863c3702643e2e016d4d'),(23,'77.74.212.27','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36',1625042206,'75147d403e657bd89ee9e07f8d27d867'),(24,'90.32.114.69','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36',1625046313,'912b5e8106b615d2068bc42d6b8706f0'),(25,'77.74.212.27','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.124 Safari/537.36',1625048826,'589be633a0e8c0bba1816a74ae00d4bd'),(26,'86.229.198.176','Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/91.0.4472.114 Safari/537.36',1625042920,'903ad023d84dd098bc98e65181430f96');
