-- version OVH
-- https://www.phpmyadmin.net/
--
-- Hôte : ma231255-001.privatesql:35372
-- Généré le :  lun. 15 fév. 2021 à 15:02
-- Version du serveur :  5.7.32-log
-- Version de PHP :  7.3.20

START TRANSACTION;



--
-- Base de données :  `app_sofrecom_db`
--

-- --------------------------------------------------------

--
-- Structure de la table `general_config`
--

CREATE TABLE `general_config` (
  `id` int(10) NOT NULL,
  `link_or` text,
  `link_fr` text,
  `link_ar` text,
  `link_quiz` text,
  `register` int(11) NOT NULL DEFAULT '0',
  `login_check` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `general_config`
--

INSERT INTO `general_config` (`id`, `link_or`, `link_fr`, `link_ar`, `link_quiz`, `register`, `login_check`) VALUES
(1, '493349234', '', '', NULL, 1, 1);

-- --------------------------------------------------------

--
-- Structure de la table `questions`
--

CREATE TABLE `questions` (
  `id` int(11) NOT NULL,
  `title` longtext,
  `status` tinyint(1) DEFAULT '0',
  `user_id` int(11) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `checked_at` timestamp NULL DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `questions`
--

INSERT INTO `questions` (`id`, `title`, `status`, `user_id`, `created_at`, `checked_at`) VALUES
(11, 'Bonjour Mr Noomane \r\nPourquoi on sent qu\'il y a toujours une résistance au changement en Tunisie, citant l\'exemple de la digitalisation de l\'administration et   pourquoi ça a pris autant de temps?', 1, 192, '2020-12-17 13:42:12', '2020-12-17 13:53:45'),
(12, 'une question d\'un participant ; \r\n\r\nWaht about the blockchain technologie? I think it\'s more versatile than IOT', 0, 28, '2020-12-17 13:50:39', NULL),
(13, 'Et le 1.7 ?\r\n', 0, 85, '2020-12-17 13:51:07', NULL),
(14, 'Question de Ahmed BEN ALI\r\nLe transfert de la confiance est dans les valeurs, pourquoi ne pas mettre la BlockChain dans les 5 T :)\r\n', 0, 28, '2020-12-17 13:57:33', NULL),
(15, 'de Mme Henen Blelagha : \r\n\r\nVous parler des idées assez avanceées, actuellement, on ne peut nier qu\'une grande partie de notre société a encore des doutes,  un sentiment d\'insécurité face à l\'utilisation des différentes technologies et aux différents services offerts via internet meme des services les plus basiques. à quel point vous envisager mettre l\'accent sur le point sécurité des services, des réseaux ....sur le plan technique et surtout sur le plan  social afin de mieux faire avancer la situation numérique dans notre pays.\r\n\r\n', 0, 28, '2020-12-17 14:09:18', NULL),
(16, 'de Mahmoud\r\n\r\nHow to learn from failure ? c\'est un état d\'esprit ; en fait, pas toutes les entreprises aiment parler des échecs !\r\n\r\n', 1, 28, '2020-12-17 14:09:44', '2020-12-17 14:38:50'),
(17, 'D\'une personnes anonyme : \r\n\r\nUne autre chanson de Mira entre les interventions sera un plus :)\r\n\r\n', 1, 28, '2020-12-17 14:11:49', '2020-12-17 14:37:17'),
(18, '\r\nToutes cette technologie est pour quand en tunisie . On risque d’être toujours en retard par rapport au développement technologique ?\r\n', 0, 28, '2020-12-17 14:12:00', NULL),
(19, 'Merci , It\'s a mind-blowing ', 1, 125, '2020-12-17 14:15:55', '2020-12-17 14:37:12'),
(20, 'On dit toujours que l’innovation et la recherche n\'est pas toujours rentable ?\r\n\r\n', 1, 28, '2020-12-17 14:19:52', '2020-12-17 14:38:46'),
(21, 'à Mr le ministre, est ce possible de faire un parlement virtuel (application basée sur l\'IA, machine learning,...) pour faire de projets de lois qui aident notre pays à sortir de cette crise. Avec un algorithme aussi puissant (bourse, stratégies économiques, prévision de désastres,...)\r\net surtout pour remplacer nos élus :)', 0, 85, '2020-12-17 14:26:19', NULL),
(22, 'à Mr le ministre, est ce possible de faire un parlement virtuel (application basée sur l\'IA, machine learning,...) pour faire de projets de lois qui aident notre pays à sortir de cette crise. Avec un algorithme aussi puissant (bourse, stratégies économiques, prévision de désastres,...)\r\net surtout pour remplacer nos élus :)', 0, 85, '2020-12-17 14:26:49', NULL),
(23, 'Ahdi CHERIF\r\nDream , Believe , Achieve\r\n\r\n', 1, 28, '2020-12-17 14:27:20', '2020-12-17 14:38:41'),
(24, 'Merci , It\'s a mind-blowing ', 1, 125, '2020-12-17 14:27:21', '2020-12-17 14:38:36'),
(25, 'Quelle est la stratégie de l\'état et les entreprises privés   pour lutter contre la fuite  des cerveaux spécialement dans le domaine de l\'informatique ?', 0, 140, '2020-12-17 14:33:39', NULL),
(26, '\r\nWe need Mira with us , hire her Please\r\n', 0, 28, '2020-12-17 14:46:31', NULL),
(27, 'Derren Brown !', 0, 159, '2020-12-17 15:04:47', NULL),
(28, 'Si possible de relancer la vidéo plsutard, on n\'a pas fini avec l\'équipe archi.', 0, 189, '2020-12-17 15:29:42', NULL);

-- --------------------------------------------------------

--
-- Structure de la table `users`
--

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `firstname` varchar(50) NOT NULL,
  `lastname` varchar(50) NOT NULL,
  `cuid` int(100) DEFAULT NULL,
  `Specialite` varchar(255) DEFAULT NULL,
  `fonction` varchar(255) DEFAULT NULL,
  `status` int(1) NOT NULL DEFAULT '0',
  `logged` int(11) NOT NULL DEFAULT '0',
  `role` varchar(255) NOT NULL DEFAULT 'ROLE_PARTICIPANT',
  `user_email` varchar(60) NOT NULL,
  `user_password` varchar(255) DEFAULT NULL,
  `password_plaintext` varchar(255) DEFAULT NULL,
  `joining_date` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `logged_time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

--
-- Déchargement des données de la table `users`
--

INSERT INTO `users` (`id`, `firstname`, `lastname`, `cuid`, `Specialite`, `fonction`, `status`, `logged`, `role`, `user_email`, `user_password`, `password_plaintext`, `joining_date`, `logged_time`) VALUES
(1, 'ADMINISTRATEUR', 'ADMINISTRATEUR', 0, NULL, NULL, 1, 0, 'ROLE_ADMINISTRATEUR', 'admin@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', '123456', '2020-06-12 12:23:31', '2021-02-12 19:41:28'),
(2, 'MODERATEUR', 'MODERATEUR', 0, NULL, NULL, 1, 0, 'ROLE_MODERATEUR', 'moderateur@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', '123456', '2020-06-12 12:23:31', '2021-02-12 19:40:25'),
(3, 'ORATEUR', 'ORATEUR', 0, NULL, NULL, 1, 0, 'ROLE_ORATEUR', 'orateur@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', '123456', '2020-06-12 12:23:31', '2020-12-16 11:43:03'),
(28, 'PARTICIPANT', 'PARTICIPANT', 0, NULL, NULL, 1, 0, 'ROLE_PARTICIPANT', 'participant@gmail.com', 'e10adc3949ba59abbe56e057f20f883e', '123456', '2020-11-24 14:31:55', '2021-02-12 19:39:58'),
(81, 'Fatma', 'fadhla', 1235, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'benfadhla.fatma@gmail.com', NULL, NULL, '2020-12-16 13:24:15', '2020-12-17 14:24:33'),
(82, 'BELHAJ', 'Afef', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'afef.belhaj@sofrecom.com', NULL, NULL, '2020-12-16 15:45:33', '2020-12-19 14:52:42'),
(83, 'chaabi', 'sabrine', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'sabrine.chaabi@sofrecom.com', NULL, NULL, '2020-12-16 16:00:49', '2020-12-17 14:01:48'),
(84, 'MAROUANI', 'Hassen', NULL, NULL, NULL, 1, 0, 'ROLE_PARTICIPANT', 'hassen.marouani@sofrecom.com', NULL, NULL, '2020-12-16 16:00:57', '2020-12-17 15:01:07'),
(85, 'NASRI', 'Hamza', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'hamza.nasri@sofrecom.com', NULL, NULL, '2020-12-16 16:01:09', '2020-12-17 15:25:13'),
(86, 'Aouani', 'Ftima Yosra', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'ftimayosra.aouani@sofrecom.com', NULL, NULL, '2020-12-16 16:01:17', '2020-12-17 14:05:53'),
(87, 'NAGMAR', 'Mehdi', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'mehdi.nagmar@sofrecom.com', NULL, NULL, '2020-12-16 16:01:26', '2020-12-17 14:33:05'),
(88, 'REJEB', 'Saba', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'saba.rejeb@sofrecom.com', NULL, NULL, '2020-12-16 16:01:29', '2020-12-17 14:27:47'),
(89, 'Chbiki', 'Chbiki', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'firas.chbiki@sofrecom.com', NULL, NULL, '2020-12-16 16:01:41', '2020-12-17 14:29:56'),
(90, 'suibgui', 'omran', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'omran.suibgui@sofrecom.com', NULL, NULL, '2020-12-16 16:01:44', '2020-12-17 14:07:56'),
(91, 'KHEMIRI', 'Ons', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'ons.khemiri@sofrecom.com', NULL, NULL, '2020-12-16 16:02:02', '2020-12-17 15:46:26'),
(92, 'Hajer', 'Doghri', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'hajer.doghri@sofrecom.com', NULL, NULL, '2020-12-16 16:02:16', '2020-12-17 14:25:26'),
(95, 'MEJRI', 'Wael', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'wael.mejri@sofrecom.com', NULL, NULL, '2020-12-16 16:02:28', '2020-12-17 14:13:31'),
(96, 'AYARI', 'Ahlem', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'ahlem.ayari@sofrecom.com', NULL, NULL, '2020-12-16 16:02:30', '2020-12-17 14:24:47'),
(97, 'Chaabnia', 'Saoussen', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'saoussen.chaabnia@sofrecom.com', NULL, NULL, '2020-12-16 16:02:41', '2020-12-17 14:11:40'),
(98, 'Turki', 'Aslem', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'aslem.turki@sofrecom.com', NULL, NULL, '2020-12-16 16:02:44', '2020-12-17 14:23:59'),
(100, 'CHERIF', 'Ahdi', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'ahdi.cherif@sofrecom.com', NULL, NULL, '2020-12-16 16:02:55', '2020-12-17 14:04:08'),
(101, 'Amani', 'Chkir', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'amani.chkir@sofrecom.com', NULL, NULL, '2020-12-16 16:03:28', '2020-12-17 14:06:11'),
(102, 'Omar', 'Ben Romdhane', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'omar.benromdhane@sofrecom.com', NULL, NULL, '2020-12-16 16:03:31', '2020-12-17 14:51:18'),
(104, 'Ben Tamansourt', 'Majdi', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'majdi.bentamansourt@sofrecom.com', NULL, NULL, '2020-12-16 16:03:34', '2020-12-17 13:59:40'),
(105, 'Bouaziz', 'Nesrine', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'nesrine.bouaziz@sofrecom.com', NULL, NULL, '2020-12-16 16:04:25', '2020-12-17 14:18:03'),
(107, 'Kohila', 'Saba Sahar', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'sabasahar.kohila@sofrecom.com', NULL, NULL, '2020-12-16 16:04:37', '2020-12-17 15:37:36'),
(108, 'TEYEB', 'Hana', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'hana.teyeb@sofrecom.com', NULL, NULL, '2020-12-16 16:05:05', '2020-12-17 14:15:16'),
(109, 'jouini', 'nadia', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'nadia.jouini@sofrecom.com', NULL, NULL, '2020-12-16 16:05:16', '2020-12-17 14:55:25'),
(110, 'Belhadj ', 'Mohamed ', NULL, NULL, NULL, 1, 0, 'ROLE_PARTICIPANT', 'mohamed.belhadj@sofrecom.com', NULL, NULL, '2020-12-16 16:05:51', '2020-12-17 16:32:24'),
(111, 'Ghardadou', 'Aymen', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'aymen.ghardadou@sofrecom.com', NULL, NULL, '2020-12-16 16:06:22', '2020-12-17 14:20:38'),
(112, 'Bel Hadj Khélifa', 'Mariem', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'mariem.belhadjkhelifa@sofrecom.com', NULL, NULL, '2020-12-16 16:06:23', '2020-12-17 15:17:21'),
(113, 'mohamed jihed', 'jaouadi', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'mohamedjihed.jaouadi@sofrecom.com', NULL, NULL, '2020-12-16 16:06:23', '2020-12-17 15:47:17'),
(115, 'Bouhafa', 'Mouna', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'mouna.bouhafa@sofrecom.com', NULL, NULL, '2020-12-16 16:06:36', '2020-12-17 15:33:47'),
(116, 'ATITALLAH', 'Rafika', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'rafika.atitallah@sofrecom.com', NULL, NULL, '2020-12-16 16:07:23', '2020-12-17 14:05:16'),
(117, 'Guesmi', 'Amel', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'amel.guesmi@sofrecom.com', NULL, NULL, '2020-12-16 16:07:27', '2020-12-17 15:03:15'),
(119, 'Arfa', 'Amal', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'amal.arfa@sofrecom.com', NULL, NULL, '2020-12-16 16:07:53', '2020-12-17 14:09:47'),
(120, 'Jean', 'CHENEVAT', NULL, NULL, NULL, 1, 0, 'ROLE_PARTICIPANT', 'jeanmichel.chenevat@orange.com', NULL, NULL, '2020-12-16 16:07:59', '2020-12-17 14:02:31'),
(121, 'BEN RHIMA', 'Mouna', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'mouna.benrhima@sofrecom.com', NULL, NULL, '2020-12-16 16:08:03', '2020-12-17 14:13:45'),
(122, 'Saidani', 'kaouther', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'kaouther.saidani@sofrecom.com', NULL, NULL, '2020-12-16 16:08:22', '2020-12-17 14:00:30'),
(123, 'Ben Sassi', 'Hichem', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'hichem.bensassi@sofrecom.com', NULL, NULL, '2020-12-16 16:10:40', '2020-12-17 14:13:20'),
(125, 'gmati', 'amani', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'amani.gmati@sofrecom.com', NULL, NULL, '2020-12-16 16:13:52', '2020-12-17 14:01:27'),
(128, 'Afef', 'ZENNED', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'afef.zenned@sofrecom.com', NULL, NULL, '2020-12-16 16:17:13', '2020-12-17 14:13:55'),
(131, 'Mohamed Hadi', 'WESLATI', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'mohamedhadi.weslati@sofrecom.com', NULL, NULL, '2020-12-16 16:22:18', '2020-12-17 14:19:53'),
(132, 'kawther', 'Mastouri', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'kawther.mastouri@sofrecom.com', NULL, NULL, '2020-12-16 16:22:46', '2020-12-17 14:02:40'),
(133, 'HIZAOUI', 'Hela', NULL, NULL, NULL, 1, 0, 'ROLE_PARTICIPANT', 'hela.hizaoui@sofrecom.com', NULL, NULL, '2020-12-16 16:23:22', NULL),
(134, 'amal', 'rahal', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'amal.rahal@sofrecom.com', NULL, NULL, '2020-12-16 16:24:17', '2020-12-17 14:20:21'),
(135, 'languer', 'khaled', NULL, NULL, NULL, 1, 0, 'ROLE_PARTICIPANT', 'khaled.languer@sofrecom.com', NULL, NULL, '2020-12-16 16:25:20', '2020-12-17 15:00:09'),
(136, 'Mehdi', 'Tkhayat', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'mehdi.bentkhayat@sofrecom.com', NULL, NULL, '2020-12-16 16:25:48', '2020-12-17 14:08:00'),
(137, 'Houiji', 'Houcem', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'houcem.houiji@sofrecom.com', NULL, NULL, '2020-12-16 16:25:51', '2020-12-17 14:50:40'),
(138, 'Ben Chaâbane', 'Meriam', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'meriam.benchaabane@sofrecom.com', NULL, NULL, '2020-12-16 16:26:04', '2020-12-17 16:18:56'),
(139, 'Mahfoudhi', 'Rami', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'rami.mahfoudhi@sofrecom.com', NULL, NULL, '2020-12-16 16:26:37', '2020-12-17 14:02:51'),
(140, 'Amira ', 'Ben Rejeb ', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'amira.benrejeb@sofrecom.com', NULL, NULL, '2020-12-16 16:31:27', '2020-12-17 14:24:53'),
(141, 'Bel Arbi', 'Aymen', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'aymen.belarbi@gmail.com', NULL, NULL, '2020-12-16 16:33:30', '2021-02-12 19:41:48'),
(142, 'Ben Lagha', 'Hanene', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'hanene.benlagha@sofrecom.com', NULL, NULL, '2020-12-16 16:34:38', '2020-12-17 14:11:21'),
(144, 'Ben Hassine', 'Rim', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'rim.benhassine@sofrecom.com', NULL, NULL, '2020-12-16 16:35:31', '2020-12-17 14:02:23'),
(145, 'oussama', 'Zaghdoud', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'oussama.zaghdoud@sofrecom.com', NULL, NULL, '2020-12-16 16:38:03', '2020-12-17 14:12:53'),
(146, 'ABID', 'Ines', NULL, NULL, NULL, 1, 0, 'ROLE_PARTICIPANT', 'ines.abid@sofrecom.com', NULL, NULL, '2020-12-16 16:41:41', '2021-02-12 19:41:13'),
(149, 'zbidi', 'amir', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'mohamedamir.zbidi@sofrecom.com', NULL, NULL, '2020-12-16 16:42:22', '2020-12-17 14:26:18'),
(150, 'Ksontini', 'Khaled', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'khaled.ksontini@sofrecom.com', NULL, NULL, '2020-12-16 16:42:46', '2020-12-17 13:58:59'),
(151, 'manel', 'jaber', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'manel.jaber@sofrecom.com', NULL, NULL, '2020-12-16 16:48:20', '2020-12-17 14:05:51'),
(152, 'BEL HADJ SALAH', 'Khouloud', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'Khouloud.belhadjsalah@sofrecom.com', NULL, NULL, '2020-12-16 16:50:42', '2020-12-17 14:13:46'),
(153, 'ben amar', 'dorra', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'dorra.benamara@sofrecom.com', NULL, NULL, '2020-12-16 16:51:37', '2020-12-17 13:47:11'),
(154, 'Ben Hammouda', 'Manel', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'manel.benhammouda@sofrecom.com', NULL, NULL, '2020-12-16 16:52:27', '2020-12-17 15:38:20'),
(155, 'EL OUAFI', 'Amen Allah', NULL, NULL, NULL, 1, 0, 'ROLE_PARTICIPANT', 'amenallah.elouafi@sofrecom.com', NULL, NULL, '2020-12-16 16:57:04', NULL),
(156, 'saad', 'marouane', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'marouane.saad@sofrecom.com', NULL, NULL, '2020-12-16 16:58:22', '2020-12-17 13:59:03'),
(157, 'ELECHI', 'Besma', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'besma.eleuchi@sofrecom.com', NULL, NULL, '2020-12-16 16:58:43', '2020-12-17 14:27:45'),
(158, 'Mohamed amine', 'Romdhani', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'mohamedamine.romdhani@sofrecom.com', NULL, NULL, '2020-12-16 17:00:54', '2020-12-17 16:31:53'),
(159, 'HAFSI', 'ILYES', NULL, NULL, NULL, 1, 0, 'ROLE_PARTICIPANT', 'ilyes.hafsi@sofrecom.com', NULL, NULL, '2020-12-16 17:01:36', '2020-12-17 14:05:52'),
(160, 'Hanen', 'Kammoun', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'hanen.kammoun@sofrecom.com', NULL, NULL, '2020-12-16 17:18:27', '2020-12-17 14:24:31'),
(161, 'Sdiri', 'Syrine', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'syrine.sdiri@sofrecom.com', NULL, NULL, '2020-12-16 17:21:49', '2020-12-17 14:00:08'),
(162, 'Ben rebah', 'Ameni', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'ameni.benrebah@sofrecom.com', NULL, NULL, '2020-12-16 17:22:15', '2020-12-17 14:00:37'),
(163, 'HAMMAMI', 'Khouloud', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'khouloud.hammami@sofrecom.com', NULL, NULL, '2020-12-16 17:34:07', '2020-12-17 14:06:01'),
(164, 'Hamza', 'Omrani', NULL, NULL, NULL, 1, 0, 'ROLE_PARTICIPANT', 'hamza.omrani@sofrecom.com', NULL, NULL, '2020-12-16 17:34:29', NULL),
(165, 'Braham', 'Yassine', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'yassine.braham@sofrecom.com', NULL, NULL, '2020-12-16 17:35:56', '2020-12-17 15:51:23'),
(166, 'ARFAOUI', 'Marouene', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'marouene.arfaoui@sofrecom.com', NULL, NULL, '2020-12-16 17:39:37', '2020-12-17 16:41:01'),
(168, 'Maha', 'SASSI', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'maha.sassi@sofrecom.com', NULL, NULL, '2020-12-16 17:39:54', '2020-12-17 14:10:20'),
(170, 'RAHALI', 'Tarek', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'tarek.rahali@sofrecom.com', NULL, NULL, '2020-12-16 17:46:22', '2020-12-17 14:01:01'),
(172, 'Emna', 'Hajkacem', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'emna.hajkacem@sofrecom.com', NULL, NULL, '2020-12-16 17:50:43', '2020-12-17 14:02:54'),
(173, 'BEN ALI', 'Ahmed', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'ahmed.benali@sofrecom.com', NULL, NULL, '2020-12-16 17:54:46', '2020-12-17 14:02:23'),
(175, 'Khaled', 'Nasser', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'khaled.nasser@sofrecom.com', NULL, NULL, '2020-12-16 17:56:15', '2020-12-17 15:55:10'),
(177, 'ben abdelmoumen', 'yosra', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'yosra.benabdelmoumen@sofrecom.com', NULL, NULL, '2020-12-16 18:00:03', '2020-12-17 14:04:25'),
(178, 'Bassem', 'METTICHI', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'bassem.mettichi@sofrecom.com', NULL, NULL, '2020-12-16 18:00:25', '2020-12-17 14:05:34'),
(180, 'ben ali', 'ahmed', NULL, NULL, NULL, 1, 0, 'ROLE_PARTICIPANT', 'ahmed.benali@orange.com', NULL, NULL, '2020-12-16 18:04:41', NULL),
(182, 'Hamdi', 'Fatma', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'fatma.hamdi@sofrecom.com', NULL, NULL, '2020-12-16 18:29:10', '2020-12-17 14:37:25'),
(183, 'Taamallah', 'Zeineb', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'zeineb.taamallah@sofrecom.com', NULL, NULL, '2020-12-16 18:33:07', '2020-12-17 13:59:52'),
(184, 'AMMOUS', 'Zied', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'zied.ammous@sofrecom.com', NULL, NULL, '2020-12-16 18:40:50', '2020-12-17 14:17:06'),
(185, 'Kechiche', 'Skander', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'skander.kechiche@sofrecom.com', NULL, NULL, '2020-12-16 18:59:19', '2020-12-17 16:35:48'),
(186, 'NACEF', 'Mahmoud', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'mahmoud.nacef@sofrecom.com', NULL, NULL, '2020-12-16 19:52:37', '2020-12-17 14:20:13'),
(187, 'JAMAI', 'Zied', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'zied.jamai@sofrecom.com', NULL, NULL, '2020-12-16 19:55:53', '2020-12-17 14:36:57'),
(188, 'Saidi', 'Manel', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'manel.saidi@sofrecom.com', NULL, NULL, '2020-12-16 20:43:08', '2020-12-17 13:59:43'),
(189, 'Ben Aissa', 'Imene', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'imene.benaissa@sofrecom.com', NULL, NULL, '2020-12-16 21:43:34', '2020-12-17 16:39:48'),
(190, 'Hajjaji', 'Ayoub', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'ayoub.hajjaji@sofrecom.com', NULL, NULL, '2020-12-16 21:51:32', '2020-12-17 14:09:09'),
(191, 'Tebessi', 'Nadia', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'nadia.tebessi@sofrecom.com', NULL, NULL, '2020-12-16 22:17:07', '2020-12-17 14:03:46'),
(192, 'adnani', 'seifeddine', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'seifeddine.adnani@sofrecom.com', NULL, NULL, '2020-12-17 00:28:02', '2020-12-18 15:09:11'),
(193, 'TRABELSI', 'Walid', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'walid1.trabelsi@sofrecom.com', NULL, NULL, '2020-12-17 07:49:39', '2020-12-17 14:06:50'),
(194, 'zeineb', 'BL', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'zeineb.benlazreg@sofrecom.com', NULL, NULL, '2020-12-17 08:49:14', '2020-12-17 14:26:07'),
(195, 'TURKI', 'Rihab', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'rihab.turki@sofrecom.com', NULL, NULL, '2020-12-17 08:58:52', '2020-12-17 14:12:39'),
(196, 'Jaafar', 'Asma', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'asma.jaafar@sofrecom.com', NULL, NULL, '2020-12-17 09:08:52', '2020-12-17 14:13:14'),
(198, 'Ayari', 'Maher', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'maher.ayari@sofrecom.com', NULL, NULL, '2020-12-17 09:22:20', '2020-12-17 15:59:27'),
(199, 'Ghazouani', 'Wifek', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'wifek.ghazouani@sofrecom.com', NULL, NULL, '2020-12-17 09:23:45', '2020-12-17 14:04:28'),
(202, 'RHOUMA', 'Mohamed Sallami', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'mohamed.sallamirhouma@sofrecom.com', NULL, NULL, '2020-12-17 09:30:54', '2020-12-17 14:15:34'),
(203, 'Salma', 'Bradai', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'salma.bradai@sofrecom.com', NULL, NULL, '2020-12-17 09:33:26', '2020-12-17 14:01:20'),
(204, 'HERMI', 'Aymen', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'aymen.hermi@sofrecom.com', NULL, NULL, '2020-12-17 09:35:10', '2020-12-17 14:02:49'),
(205, 'mlika', 'imen', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'imen.mlika@sofrecom.com', NULL, NULL, '2020-12-17 09:44:38', '2020-12-17 13:57:07'),
(206, 'hachani', 'refka', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'refka.hachani@sofrecom.com', NULL, NULL, '2020-12-17 09:50:41', '2020-12-17 14:41:05'),
(207, 'belloumi', 'Mohamed', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'mohamed.belloumi@sofrecom.com', NULL, NULL, '2020-12-17 09:56:40', '2020-12-17 14:13:14'),
(208, 'Naim', 'SAMMOUDI', NULL, NULL, NULL, 1, 0, 'ROLE_PARTICIPANT', 'naim.sammoudi@sofrecom.com', NULL, NULL, '2020-12-17 10:02:11', '2020-12-17 14:06:06'),
(209, 'Boukhriss', 'Aymen', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'aymen.boukhriss@sofrecom.com', NULL, NULL, '2020-12-17 10:08:06', '2020-12-20 18:43:37'),
(210, 'Bouchnak', 'Hanene', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'hanene.bouchnak@sofrecom.com', NULL, NULL, '2020-12-17 10:12:06', '2020-12-17 14:14:25'),
(211, 'sanaa', 'anis', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'anis.sanaa@sofrecom.com', NULL, NULL, '2020-12-17 10:16:36', '2020-12-17 14:02:33'),
(212, 'Nejib', 'Abbassi', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'nejib.abbassi@sofrecom.com', NULL, NULL, '2020-12-17 10:38:13', '2020-12-17 14:00:57'),
(213, 'khelifi', 'Aycha', NULL, NULL, NULL, 1, 0, 'ROLE_PARTICIPANT', 'aycha.khelifi@sofrecom.com', NULL, NULL, '2020-12-17 10:44:22', NULL),
(214, 'Mouaddeb', 'Sirine', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'sirine.elmouaddeb@sofrecom.com', NULL, NULL, '2020-12-17 11:08:32', '2020-12-17 14:16:33'),
(215, 'laalaa', 'adel', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'adel.laalaa@sofrecom.com', NULL, NULL, '2020-12-17 11:09:21', '2020-12-17 14:03:05'),
(216, 'Bel Arbi', 'Aymen', NULL, NULL, NULL, 1, 0, 'ROLE_PARTICIPANT', 'aymen.belarbi@sofrecom.com', NULL, NULL, '2020-12-17 11:10:30', NULL),
(217, 'GUENIDI', 'Souha', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'guenidisouha@gmail.com', NULL, NULL, '2020-12-17 11:15:51', '2020-12-17 15:51:23'),
(218, 'Nakbi', 'Rihab', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'rihab.nakbi@sofrecom.com', NULL, NULL, '2020-12-17 11:17:47', '2020-12-17 16:55:03'),
(223, 'Belguith', 'Rihem', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'rihem.belguith@sofrecom.com', NULL, NULL, '2020-12-17 11:19:32', '2020-12-17 14:05:32'),
(224, 'nadim', 'harb', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'nadim.harb@sofrecom.com', NULL, NULL, '2020-12-17 11:21:34', '2020-12-17 15:38:27'),
(225, 'BELMANAA', 'Hamed', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'hamed.belmanaa@sofrecom.com', NULL, NULL, '2020-12-17 11:27:53', '2020-12-17 14:32:34'),
(227, 'BENZAHRA', 'Samir', NULL, NULL, NULL, 1, 0, 'ROLE_PARTICIPANT', 'samir.benzahra@sofrecom.com', NULL, NULL, '2020-12-17 11:27:58', NULL),
(229, 'NAGMAR', 'Mohamed Hedi', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'medhedi.nagmar@aiesec.net', NULL, NULL, '2020-12-17 11:30:58', '2020-12-17 14:02:11'),
(232, 'kanzari', 'chaima', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'chaima.kanzari@sofrecom.com', NULL, NULL, '2020-12-17 11:31:40', '2020-12-17 14:24:49'),
(235, 'DRIDI', 'Cyrine', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'syrine.dridi@sofrecom.com', NULL, NULL, '2020-12-17 12:16:00', '2020-12-17 15:37:58'),
(236, 'Makhlouf', 'Ines', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'ines.makhlouf@sofrecom.com', NULL, NULL, '2020-12-17 12:16:58', '2020-12-17 16:02:22'),
(237, 'Tabana', 'Jebrane', NULL, NULL, NULL, 1, 0, 'ROLE_PARTICIPANT', 'jebrane.tabana@sofrecom.com', NULL, NULL, '2020-12-17 12:25:27', NULL),
(238, 'Bouhamed', 'Imen', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'imen.bouhamed@sofrecom.com', NULL, NULL, '2020-12-17 12:29:34', '2020-12-17 14:00:41'),
(239, 'BEN FRAJ', 'Ayman', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'ayman.benfraj@sofrecom.com', NULL, NULL, '2020-12-17 12:40:56', '2020-12-17 14:01:17'),
(240, 'Zaidi', 'Nada', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'nadazaidi162@gmail.com', NULL, NULL, '2020-12-17 13:12:51', '2020-12-17 14:14:01'),
(241, 'Bayoudh', 'Zouhour', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'zouhour.bayoudh@sofrecom.com', NULL, NULL, '2020-12-17 13:33:08', '2020-12-17 18:38:40'),
(242, 'jemal', 'khaled', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'khaled.jemal@sofrecom.com', NULL, NULL, '2020-12-17 13:39:22', '2020-12-17 14:11:34'),
(245, 'Wiem', 'BATITA ', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'wiem.batita@sofrecom.com', NULL, NULL, '2020-12-17 13:47:10', '2020-12-17 13:57:29'),
(247, 'Dhyeb', 'Louay', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'louay.dhyeb@sofrecom.com', NULL, NULL, '2020-12-17 13:48:08', '2020-12-17 14:28:02'),
(248, 'MALEK', 'KAZDAGHLI', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'malek.kazdaghli@sofrecom.com', NULL, NULL, '2020-12-17 13:49:39', '2020-12-17 14:48:57'),
(249, 'Maryem', 'Hamdi', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'maryem.hamdi@sofrecom.com', NULL, NULL, '2020-12-17 13:52:31', '2020-12-17 14:10:47'),
(251, 'Louati', 'Badii', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'badii.louati@sofrecom.com', NULL, NULL, '2020-12-17 13:54:34', '2020-12-17 15:48:30'),
(254, 'Wassim', 'Ayari', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'wassim.ayari@sofrecom.com', NULL, NULL, '2020-12-17 13:58:19', '2020-12-17 14:00:24'),
(255, 'Garrawi', 'Aahed', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'aahed.garrawi@sofrecom.com', NULL, NULL, '2020-12-17 14:00:04', '2020-12-17 14:01:07'),
(256, 'Mariem', 'chtaytia ', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'mariem.chtaytia@sofrecom.com', NULL, NULL, '2020-12-17 14:00:34', '2020-12-17 14:11:43'),
(257, 'Hamdi', 'Ilhem', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'ilhem.hamdi@sofrecom.com', NULL, NULL, '2020-12-17 14:02:04', '2020-12-17 14:03:52'),
(259, 'Haifa', 'Riahi', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'haifa.riahi@sofrecom.com', NULL, NULL, '2020-12-17 14:03:21', '2020-12-17 14:15:15'),
(261, 'Rezgui', 'Mohamed', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'mohamed1.rezgui@sofrecom.com', NULL, NULL, '2020-12-17 14:04:11', '2020-12-17 14:04:43'),
(262, 'dridi rezgui', 'Hamza', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'hamza.dridirezgui@sofrecom.com', NULL, NULL, '2020-12-17 14:04:34', '2020-12-17 14:05:24'),
(263, 'Debbabi', 'Hamza', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'hamza.debbabi@sofrecom.com', NULL, NULL, '2020-12-17 14:04:46', '2020-12-17 14:05:39'),
(264, 'kamoun', 'samiha', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'samiha.kamoun@sofrecom.com', NULL, NULL, '2020-12-17 14:05:33', '2020-12-17 16:30:24'),
(265, 'Dkhil', 'Amani', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'Amani.dkhil@sofrecom.com', NULL, NULL, '2020-12-17 14:06:25', '2020-12-17 14:11:22'),
(266, 'RAHAL', 'Ali', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'ali.rahal@sofrecom.com', NULL, NULL, '2020-12-17 14:07:57', '2020-12-17 14:15:15'),
(267, 'Idir', 'Amina', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'amina.idir@sofrecom.com', NULL, NULL, '2020-12-17 14:08:01', '2020-12-17 14:10:25'),
(268, 'BOUSNINA', 'Achraf', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'achraf.bousnina@sofrecom.com', NULL, NULL, '2020-12-17 14:08:39', '2020-12-17 14:14:01'),
(269, 'BOUZOUITA', 'Chaima', NULL, NULL, NULL, 1, 0, 'ROLE_PARTICIPANT', 'chaima.bouzouita@sofrecom.com', NULL, NULL, '2020-12-17 14:10:43', '2020-12-17 15:14:13'),
(270, 'Mariem', 'Ben Omrane', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'mariem.benomrane@sofrecom.com', NULL, NULL, '2020-12-17 14:11:22', '2020-12-17 14:11:40'),
(271, 'Trabelsi', 'Racha', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'racha.trabelsi@sofrecom.com', NULL, NULL, '2020-12-17 14:14:17', '2020-12-17 14:15:24'),
(272, 'Zaghmouri', 'Roua', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'roua.zaghmouri@sofrecom.com', NULL, NULL, '2020-12-17 14:16:50', '2020-12-17 14:17:35'),
(273, 'Ben Salem', 'Marouen', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'marouen.bensalem@sofrecom.com', NULL, NULL, '2020-12-17 14:17:03', '2020-12-17 14:17:15'),
(274, 'Bradai', 'Abir', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'abir.bradai@sofrecom.com', NULL, NULL, '2020-12-17 14:17:15', '2020-12-17 16:16:00'),
(275, 'kanoun', 'mouna', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'mouna.kanoun@sofrecom.com', NULL, NULL, '2020-12-17 14:18:01', '2020-12-17 14:18:29'),
(276, 'Ben majed', 'sonia', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'sonia.benmajed@sofrecom.com', NULL, NULL, '2020-12-17 14:18:48', '2020-12-17 14:18:56'),
(277, 'Ben Saad', 'Firas', NULL, NULL, NULL, 1, 0, 'ROLE_PARTICIPANT', 'firas.bensaad@sofrecom.com', NULL, NULL, '2020-12-17 14:23:32', NULL),
(278, 'jelliti', 'mouna', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'mouna.jelliti@sofrecom.com', NULL, NULL, '2020-12-17 14:24:34', '2020-12-17 14:24:58'),
(279, 'abidi', 'wael', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'wael.abidi@sofrecom.com', NULL, NULL, '2020-12-17 14:25:04', '2020-12-17 14:25:25'),
(280, 'aymen', 'mhadheb', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'aymen.mhadheb@sofrecom.com', NULL, NULL, '2020-12-17 14:25:21', '2020-12-17 15:49:37'),
(281, 'ben fatma', 'oussama', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'oussama.benfatma@sofrecom.com', NULL, NULL, '2020-12-17 14:40:29', '2020-12-17 14:40:49'),
(283, 'OUESLATI', 'Mohamed Mokhtar', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'mohamedmokhtar.oueslati@sofrecom.com', NULL, NULL, '2020-12-17 14:46:47', '2020-12-17 14:47:01'),
(284, 'almi', 'hager', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'hager.almi@sofrecom.com', NULL, NULL, '2020-12-17 14:50:01', '2020-12-17 14:51:53'),
(285, 'ben youssef', 'haifa', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'haifa.benyoussef@sofrecom.com', NULL, NULL, '2020-12-17 14:59:46', '2020-12-17 15:00:40'),
(286, 'Ons', 'KHEMIRI', NULL, NULL, NULL, 1, 0, 'ROLE_PARTICIPANT', 'onskhemiri@gmail.com', NULL, NULL, '2020-12-17 15:30:44', NULL),
(287, 'Kharroubi', 'Mohamed', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'mohamed.kharroubi@sofrecom.com', NULL, NULL, '2020-12-17 15:32:28', '2020-12-17 15:33:14'),
(289, 'Ben Massoud', 'Saifeddine', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'saifeddinebenmassoud@sofrecom.com', NULL, NULL, '2020-12-17 15:34:37', '2020-12-17 15:34:56'),
(290, 'Mdimagh', 'Anja', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'anja.mdimagh@sofrecom.com', NULL, NULL, '2020-12-17 15:47:31', '2020-12-17 16:45:23'),
(291, 'Moumen', 'Hanen', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'hanen1.moumen@sofrecom.com', NULL, NULL, '2020-12-17 15:51:43', '2020-12-19 10:50:37'),
(292, 'Nabil', 'KHADRAOUI', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'nabil.khadraoui@sofrecom.com', NULL, NULL, '2020-12-17 16:33:13', '2020-12-17 16:34:02'),
(293, 'Afef', 'Karoui', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'afef.karoui@sofrecom.com', NULL, NULL, '2020-12-17 16:55:03', '2020-12-17 16:55:07'),
(294, 'Mourad ', 'Bejaoui', NULL, NULL, NULL, 1, 1, 'ROLE_PARTICIPANT', 'mourad.bejaoui@jourj-events.com', NULL, NULL, '2021-02-12 19:45:14', '2021-02-13 13:40:49');

--
-- Index pour les tables déchargées
--

--
-- Index pour la table `general_config`
--
ALTER TABLE `general_config`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `questions`
--
ALTER TABLE `questions`
  ADD PRIMARY KEY (`id`);

--
-- Index pour la table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `user_email` (`user_email`);

--
-- AUTO_INCREMENT pour les tables déchargées
--

--
-- AUTO_INCREMENT pour la table `general_config`
--
ALTER TABLE `general_config`
  MODIFY `id` int(10) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

--
-- AUTO_INCREMENT pour la table `questions`
--
ALTER TABLE `questions`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=29;

--
-- AUTO_INCREMENT pour la table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=295;
COMMIT;

