--
-- 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','','',''),(4,'CFAS Auvergne','2APH.png','5286c5','000000'),(5,'CFA Inclusif','','',''),(6,'ADAPT Bretagne','','','');
--
-- 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,'ayme','1234','Benoît Ayme','b.ayme@cfas-auvergne.com','0634272975'),(4,2,6,'v.grandemange','portblanc22','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','1234','Cécile Chartreau','c.chartreau@arseaa.org','');
--
-- 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);
--
-- Dumping data for table `answers`
--
-- ORDER BY:  `apprentice`,`question`,`entry_date`
--
-- Dumping data for table `needs`
--
-- ORDER BY:  `apprentice`,`adapt`,`entry_date`
--
-- 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',1624960086,'b6073c70f72049d2964af817ce6a9fcd'),(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,'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',1624960044,'e9f06580175d52b10ac7502734596f6f');
