-- https://www.phpmyadmin.net/
--
-- Hôte : 127.0.0.1:3306
-- Généré le :  ven. 16 nov. 2018 à 15:42
-- Version du serveur :  5.7.21
-- Version de PHP :  7.0.29

START TRANSACTION;

--
-- Base de données :  `linguanomad`
--
CREATE DATABASE IF NOT EXISTS `linguanomad` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
USE `linguanomad`;

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

--
-- Structure de la table `activite`
--

CREATE TABLE IF NOT EXISTS `activite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `origine_id` int(11) DEFAULT NULL,
  `proprietaire_id` int(11) DEFAULT NULL,
  `langue_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_B875551587998E` (`origine_id`),
  KEY `IDX_B875551576C50E4A` (`proprietaire_id`),
  KEY `IDX_B87555152AADBACD` (`langue_id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `activite`
--

TRUNCATE TABLE `activite`;
--
-- Déchargement des données de la table `activite`
--

INSERT INTO `activite` (`id`, `libelle`, `origine_id`, `proprietaire_id`, `langue_id`) VALUES
(1, 'Activité 1', NULL, 25, 16),
(2, 'Activité 2', NULL, 25, 16),
(3, '', NULL, 31, 16),
(4, '', NULL, 31, 16),
(5, '', NULL, 31, 16),
(6, '', NULL, 31, 16),
(7, '', NULL, 31, 16),
(8, '', NULL, 31, 16),
(9, '', NULL, 31, 16),
(10, 'Activité 1', 1, 31, 16),
(11, 'Activité 1', 1, 31, 16),
(12, 'Activité 2', 2, 24, 16),
(13, 'Activité 1', 10, 24, 16),
(14, 'Activité 3', NULL, 24, 16),
(15, 'Activité A', NULL, 25, 16),
(16, 'Activité B', NULL, 25, 16),
(17, 'Activité C', NULL, 25, 16),
(18, 'Activité 1', 13, 12, 16),
(19, 'Activité 1', 18, 25, 16),
(20, '', NULL, 31, 16),
(21, '', NULL, 31, 16),
(22, 'Activité Semaine 1', NULL, 12, 16),
(23, '', NULL, 12, 16),
(24, 'Activité Semaine 2', 1, 12, 16),
(25, 'TEst ng', NULL, 12, 16),
(26, 'Activite essai accroche', 3, 12, 16),
(27, '', 9, 12, 16);

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

--
-- Structure de la table `activite_exercice`
--

CREATE TABLE IF NOT EXISTS `activite_exercice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `activite_id` int(11) NOT NULL,
  `exercice_id` int(11) NOT NULL,
  `ordre` int(11) NOT NULL,
  `accroche` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `IDX_798016259B0F88B1` (`activite_id`),
  KEY `IDX_7980162589D40298` (`exercice_id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `activite_exercice`
--

TRUNCATE TABLE `activite_exercice`;
--
-- Déchargement des données de la table `activite_exercice`
--

INSERT INTO `activite_exercice` (`id`, `activite_id`, `exercice_id`, `ordre`, `accroche`) VALUES
(2, 1, 130, 1, 0),
(4, 2, 132, 2, 0),
(5, 2, 133, 3, 0),
(6, 2, 134, 3, 0),
(7, 1, 131, 2, 0),
(8, 2, 129, 1, 0),
(13, 3, 129, 2, 0),
(14, 3, 130, 1, 0),
(16, 9, 131, 2, 0),
(17, 9, 132, 1, 1),
(18, 8, 133, 1, 0),
(19, 5, 131, 1, 0),
(20, 5, 132, 2, 0),
(21, 5, 134, 3, 0),
(22, 4, 134, 1, 0),
(24, 11, 130, 1, 0),
(25, 11, 131, 2, 0),
(26, 11, 134, 2, 0),
(27, 10, 138, 1, 0),
(28, 10, 130, 2, 0),
(29, 12, 129, 1, 0),
(30, 12, 132, 2, 0),
(31, 12, 134, 4, 0),
(32, 13, 138, 1, 0),
(33, 13, 130, 2, 0),
(34, 13, 133, 3, 0),
(35, 14, 130, 1, 0),
(36, 14, 133, 2, 0),
(37, 14, 138, 3, 0),
(38, 15, 141, 1, 0),
(39, 15, 142, 2, 0),
(40, 16, 144, 1, 0),
(41, 16, 145, 2, 0),
(42, 16, 143, 3, 0),
(43, 17, 130, 2, 0),
(44, 17, 131, 3, 0),
(45, 17, 132, 4, 0),
(46, 17, 133, 5, 0),
(47, 17, 146, 1, 0),
(48, 18, 138, 2, 0),
(49, 18, 130, 3, 0),
(50, 18, 133, 4, 0),
(51, 18, 148, 1, 0),
(52, 19, 138, 1, 0),
(53, 19, 148, 2, 0),
(54, 19, 130, 3, 0),
(55, 19, 133, 4, 0),
(56, 20, 131, 1, 0),
(57, 21, 138, 1, 0),
(58, 22, 153, 2, 0),
(59, 22, 141, 1, 0),
(60, 22, 143, 3, 0),
(62, 22, 129, 4, 0),
(63, 24, 130, 1, 0),
(64, 24, 131, 2, 0),
(65, 25, 141, 1, 0),
(66, 25, 156, 2, 0),
(67, 26, 129, 1, 0),
(68, 26, 130, 3, 0),
(69, 27, 131, 2, 0),
(70, 27, 132, 1, 0),
(71, 26, 163, 2, 1);

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

--
-- Structure de la table `bilan`
--

CREATE TABLE IF NOT EXISTS `bilan` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `formationprof_id` int(11) NOT NULL,
  `formationeleve_id` int(11) NOT NULL,
  `commentaire` longtext COLLATE utf8_unicode_ci NOT NULL,
  `activitesrealisees` longtext COLLATE utf8_unicode_ci NOT NULL,
  `grammaire` longtext COLLATE utf8_unicode_ci NOT NULL,
  `vocabulaire` longtext COLLATE utf8_unicode_ci NOT NULL,
  `phonetique` longtext COLLATE utf8_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `IDX_F4DF4F4472EB1E50` (`formationprof_id`),
  KEY `IDX_F4DF4F443BDB63B4` (`formationeleve_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `bilan`
--

TRUNCATE TABLE `bilan`;
-- --------------------------------------------------------

--
-- Structure de la table `compterendu`
--

CREATE TABLE IF NOT EXISTS `compterendu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `formationeleve_id` int(11) NOT NULL,
  `numero` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `duree` time NOT NULL,
  `objectifspedagogiques` longtext COLLATE utf8_unicode_ci NOT NULL,
  `activitesrealiseesbilan` longtext COLLATE utf8_unicode_ci,
  `activitesrealisees` longtext COLLATE utf8_unicode_ci NOT NULL,
  `grammairebilan` longtext COLLATE utf8_unicode_ci,
  `grammaire` longtext COLLATE utf8_unicode_ci NOT NULL,
  `vocabulairebilan` longtext COLLATE utf8_unicode_ci,
  `vocabulaire` longtext COLLATE utf8_unicode_ci NOT NULL,
  `phonetiquebilan` longtext COLLATE utf8_unicode_ci,
  `phonetique` longtext COLLATE utf8_unicode_ci NOT NULL,
  `supportutilise` longtext COLLATE utf8_unicode_ci NOT NULL,
  `travailafaire` longtext COLLATE utf8_unicode_ci NOT NULL,
  `dateprochaincours` datetime NOT NULL,
  `commentaire` longtext COLLATE utf8_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `IDX_2F62FA3E3BDB63B4` (`formationeleve_id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `compterendu`
--

TRUNCATE TABLE `compterendu`;
--
-- Déchargement des données de la table `compterendu`
--

INSERT INTO `compterendu` (`id`, `formationeleve_id`, `numero`, `date`, `duree`, `objectifspedagogiques`, `activitesrealiseesbilan`, `activitesrealisees`, `grammairebilan`, `grammaire`, `vocabulairebilan`, `vocabulaire`, `phonetiquebilan`, `phonetique`, `supportutilise`, `travailafaire`, `dateprochaincours`, `commentaire`, `active`) VALUES
(1, 40, 123, '2018-10-05 00:00:00', '01:00:00', '<p>aaaaa</p>', '<p>aaaaa</p>', '<p>aaaaa</p>', '<p>aaaaa</p>', '<p>aaaaa</p>', '<p>aaaaa</p>', '<p>aaaaa</p>', '<p>aaaaa</p>', '<p>aaaaa</p>', '<p>aaaaa</p>', '<p>aaaaa</p>', '2018-10-12 00:00:00', '<p>aaaaa</p>', 1),
(2, 40, 1112154, '2018-10-05 00:00:00', '02:00:00', '<p>aaa</p>', '<p>aaa</p>', '<p>aaa</p>', '<p>aaa</p>', '<p>aaa</p>', '<p>aaa</p>', '<p>aaa</p>', '<p>aaa</p>', '<p>aaa</p>', '<p>aaa</p>', '<p>aaa</p>', '2018-10-19 00:00:00', '<p>aaa</p>', 1);

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

--
-- Structure de la table `compterenduformation`
--

CREATE TABLE IF NOT EXISTS `compterenduformation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `formation_id` int(11) NOT NULL,
  `numero` int(11) NOT NULL,
  `date` datetime NOT NULL,
  `duree` time NOT NULL,
  `objectifspedagogiques` longtext COLLATE utf8_unicode_ci NOT NULL,
  `activitesrealiseesbilan` longtext COLLATE utf8_unicode_ci,
  `activitesrealisees` longtext COLLATE utf8_unicode_ci NOT NULL,
  `grammairebilan` longtext COLLATE utf8_unicode_ci,
  `grammaire` longtext COLLATE utf8_unicode_ci NOT NULL,
  `vocabulairebilan` longtext COLLATE utf8_unicode_ci,
  `vocabulaire` longtext COLLATE utf8_unicode_ci NOT NULL,
  `phonetiquebilan` longtext COLLATE utf8_unicode_ci,
  `phonetique` longtext COLLATE utf8_unicode_ci NOT NULL,
  `supportutilise` longtext COLLATE utf8_unicode_ci NOT NULL,
  `travailafaire` longtext COLLATE utf8_unicode_ci NOT NULL,
  `dateprochaincours` datetime NOT NULL,
  `commentaire` longtext COLLATE utf8_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `effectue` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `IDX_22CBD8525200282E` (`formation_id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `compterenduformation`
--

TRUNCATE TABLE `compterenduformation`;
--
-- Déchargement des données de la table `compterenduformation`
--

INSERT INTO `compterenduformation` (`id`, `formation_id`, `numero`, `date`, `duree`, `objectifspedagogiques`, `activitesrealiseesbilan`, `activitesrealisees`, `grammairebilan`, `grammaire`, `vocabulairebilan`, `vocabulaire`, `phonetiquebilan`, `phonetique`, `supportutilise`, `travailafaire`, `dateprochaincours`, `commentaire`, `active`, `effectue`) VALUES
(1, 13, 123456, '2018-11-09 00:00:00', '01:05:00', '<p>xcv</p>', NULL, '<p>xcv</p>', NULL, '<p>xcv</p>', NULL, '<p>xcv</p>', NULL, '<p>xcv</p>', '<p>xcv</p>', '<p>xcv</p>', '2018-11-21 00:00:00', '<p>xcv</p>', 1, 1);

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

--
-- Structure de la table `eleve_activite`
--

CREATE TABLE IF NOT EXISTS `eleve_activite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `activite_id` int(11) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `eleve_lecon_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_AC98B3619B0F88B1` (`activite_id`),
  KEY `IDX_AC98B361F8FEEED1` (`eleve_lecon_id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `eleve_activite`
--

TRUNCATE TABLE `eleve_activite`;
--
-- Déchargement des données de la table `eleve_activite`
--

INSERT INTO `eleve_activite` (`id`, `activite_id`, `active`, `eleve_lecon_id`) VALUES
(1, 22, 1, 1),
(2, 24, 1, 1),
(3, 15, 1, 3),
(4, 16, 1, 3),
(5, 17, 1, 2),
(6, 17, 1, 3),
(7, 15, 1, 2),
(8, 16, 1, 2),
(9, 19, 1, 5),
(10, 12, 1, 5),
(11, 14, 1, 6),
(12, 14, 1, 5),
(13, 4, 1, 9),
(14, 26, 1, 9),
(15, 8, 1, 9),
(16, 27, 1, 9),
(17, 16, 1, 9),
(18, 5, 1, 10),
(19, 5, 1, 9),
(20, 6, 1, 10),
(21, 6, 1, 9),
(22, 7, 1, 10),
(23, 7, 1, 9),
(24, 20, 1, 20),
(25, 20, 1, 19),
(26, 21, 1, 20),
(27, 21, 1, 19);

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

--
-- Structure de la table `eleve_lecon`
--

CREATE TABLE IF NOT EXISTS `eleve_lecon` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lecon_id` int(11) NOT NULL,
  `module_id` int(11) NOT NULL,
  `note` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `duree` int(11) NOT NULL,
  `completude` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `formation_eleve_id` int(11) NOT NULL,
  `datevalidation` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_8B8639C7EC1308A5` (`lecon_id`),
  KEY `IDX_8B8639C7AFC2B591` (`module_id`),
  KEY `IDX_8B8639C7CDFE9043` (`formation_eleve_id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `eleve_lecon`
--

TRUNCATE TABLE `eleve_lecon`;
--
-- Déchargement des données de la table `eleve_lecon`
--

INSERT INTO `eleve_lecon` (`id`, `lecon_id`, `module_id`, `note`, `duree`, `completude`, `active`, `formation_eleve_id`, `datevalidation`) VALUES
(1, 12, 6, '', 66, '50', 1, 40, NULL),
(2, 9, 4, '', 0, '0', 1, 40, NULL),
(3, 8, 4, '', 562, '0', 1, 40, NULL),
(4, 10, 4, '', 0, '0', 1, 40, NULL),
(5, 1, 1, '', 255, '100', 1, 40, NULL),
(6, 7, 1, '', 0, '0', 1, 40, NULL),
(7, 13, 7, '', 0, '0', 1, 40, NULL),
(8, 12, 6, '', 0, '0', 1, 59, NULL),
(9, 2, 2, '', 0, '0', 1, 59, NULL),
(10, 3, 2, '', 0, '0', 1, 59, NULL),
(11, 5, 2, '', 0, '0', 1, 59, NULL),
(12, 6, 2, '', 0, '0', 1, 59, NULL),
(13, 8, 3, '', 0, '0', 1, 59, NULL),
(14, 2, 3, '', 0, '', 1, 59, NULL),
(15, 12, 6, '', 0, '0', 1, 62, NULL),
(16, 9, 4, '', 0, '0', 1, 62, NULL),
(17, 8, 4, '', 0, '', 1, 62, NULL),
(18, 10, 4, '', 0, '0', 1, 62, NULL),
(19, 4, 5, '', 0, '0', 1, 40, NULL),
(20, 11, 5, '', 0, '0', 1, 40, NULL);

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

--
-- Structure de la table `eleve_tentative`
--

CREATE TABLE IF NOT EXISTS `eleve_tentative` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `eleve_activite_id` int(11) NOT NULL,
  `datecreation` datetime NOT NULL,
  `note` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `tentative` int(11) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `etat` int(11) NOT NULL,
  `completude` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_8CBFDA3A1E688286` (`eleve_activite_id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `eleve_tentative`
--

TRUNCATE TABLE `eleve_tentative`;
--
-- Déchargement des données de la table `eleve_tentative`
--

INSERT INTO `eleve_tentative` (`id`, `eleve_activite_id`, `datecreation`, `note`, `tentative`, `active`, `etat`, `completude`) VALUES
(1, 1, '2018-11-13 11:49:56', '67', 0, 1, 1, '100'),
(2, 2, '2018-11-13 11:49:56', '', 0, 1, 0, '0'),
(3, 1, '2018-11-13 11:57:51', '100', 1, 1, 1, '100'),
(4, 3, '2018-11-13 12:00:20', '', 0, 1, 0, '0'),
(5, 4, '2018-11-13 12:00:21', '40', 0, 1, 1, '100'),
(6, 5, '2018-11-13 12:00:22', '', 0, 1, 0, '0'),
(7, 6, '2018-11-13 12:00:22', '', 0, 1, 0, '0'),
(8, 4, '2018-11-13 12:01:45', '', 1, 1, 0, '0'),
(9, 4, '2018-11-13 12:06:12', '60', 2, 1, 1, '100'),
(10, 4, '2018-11-13 12:08:31', '0', 3, 1, 1, '100'),
(11, 4, '2018-11-13 12:11:55', '80', 4, 1, 1, '100'),
(12, 4, '2018-11-13 12:13:44', '', 5, 1, 0, '0'),
(13, 4, '2018-11-13 12:14:09', '80', 6, 1, 1, '100'),
(14, 4, '2018-11-13 12:14:37', '', 7, 1, 0, '0'),
(15, 7, '2018-11-13 12:20:47', '', 0, 1, 0, '0'),
(16, 8, '2018-11-13 12:20:47', '', 0, 1, 0, '0'),
(17, 9, '2018-11-13 12:21:13', '75', 0, 1, 1, '100'),
(18, 10, '2018-11-13 12:21:13', '100', 0, 1, 1, '100'),
(19, 11, '2018-11-13 12:21:13', '', 0, 1, 0, '0'),
(20, 12, '2018-11-13 12:21:13', '', 0, 1, 0, '0'),
(21, 13, '2018-11-16 14:40:33', '', 0, 1, 0, '0'),
(22, 14, '2018-11-16 14:40:34', '', 0, 1, 0, '0'),
(23, 15, '2018-11-16 14:40:34', '', 0, 1, 0, '0'),
(24, 16, '2018-11-16 14:40:34', '', 0, 1, 0, '0'),
(25, 17, '2018-11-16 14:40:34', '', 0, 1, 0, '0'),
(26, 18, '2018-11-16 14:40:34', '', 0, 1, 0, '0'),
(27, 19, '2018-11-16 14:40:34', '', 0, 1, 0, '0'),
(28, 20, '2018-11-16 14:40:34', '', 0, 1, 0, '0'),
(29, 21, '2018-11-16 14:40:34', '', 0, 1, 0, '0'),
(30, 22, '2018-11-16 14:40:34', '', 0, 1, 0, '0'),
(31, 23, '2018-11-16 14:40:34', '', 0, 1, 0, '0'),
(32, 24, '2018-11-16 15:38:38', '', 0, 1, 0, '0'),
(33, 25, '2018-11-16 15:38:38', '', 0, 1, 0, '0'),
(34, 26, '2018-11-16 15:38:38', '', 0, 1, 0, '0'),
(35, 27, '2018-11-16 15:38:38', '', 0, 1, 0, '0');

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

--
-- Structure de la table `exercice`
--

CREATE TABLE IF NOT EXISTS `exercice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jsonContent` longtext COLLATE utf8_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `type_exercice_id` int(11) DEFAULT NULL,
  `titre` varchar(50) COLLATE utf8_unicode_ci DEFAULT NULL,
  `langue_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_E418C74DC2CDD509` (`type_exercice_id`),
  KEY `IDX_E418C74D2AADBACD` (`langue_id`)
) ENGINE=InnoDB AUTO_INCREMENT=164 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `exercice`
--

TRUNCATE TABLE `exercice`;
--
-- Déchargement des données de la table `exercice`
--

INSERT INTO `exercice` (`id`, `jsonContent`, `active`, `type_exercice_id`, `titre`, `langue_id`) VALUES
(43, '{\"type\":\"3\",\"texte\":[\"Mario \",\" est un des meilleurs \",\" de l\'om !\"],\"reponses\":{\"1\":\"Ballotelli\",\"2\":\"attaquants\"}}', 1, 3, 'ggg', 15),
(57, '{\"type\":\"2\",\"texte\":[\"Bonjour \",\" va bien ??\"],\"reponses\":{\"1\":\"&ccedil;a\"}}', 0, 2, '', 15),
(79, '{\"type\":\"2\",\"texte\":[\"La \",\" est encore championne du \",\" 2018 !\"],\"reponses\":{\"1\":\"France\",\"2\":\"monde\"}}', 1, 2, 'France championne du monde', 15),
(92, '{\"type\":\"4\",\"texte\":{\"1\":[\"<p>Salut<\\/p>\",\"<p>tu vas bien ?<\\/p>\"],\"2\":[\"<p>Hola<\\/p>\",\"<p>Que tal ?<\\/p>\"],\"3\":[\"<p>Hello<\\/p>\",\"<p>how are you today ?<\\/p>\"],\"4\":[\"<p>Bom dia<\\/p>\",\"<p>Todo Bem ?<\\/p>\"],\"5\":[\"<p>Nouvelle Association<\\/p>\",\"<p>Nouvelle r&eacute;ponse<\\/p>\"]}}', 1, 4, 'Un exercice d\'association très dur', 15),
(110, '{\"type\":\"4\",\"texte\":{\"1\":[\"<p>Question 1<\\/p>\",\"<p>R&eacute;ponse 1<\\/p>\"],\"2\":[\"<p>question D<\\/p>\",\"<p>r&eacute;ponse D<\\/p>\"]}}', 1, 4, 'Test 1709', 15),
(112, '{\"type\":\"5\",\"question\":\"<p>Ca va bien ?<\\/p>\"}', 0, 5, 'test ', 15),
(119, '{\"type\":\"5\",\"question\":\"<p>Il y a-t-il une vie apr&egrave;s la mort ?<\\/p>\"}', 1, 5, 'Question libre', 15),
(121, '{\"type\":\"8\",\"question\":\"<div id=\\\"lipsum\\\">\\r\\n<div id=\\\"lipsum\\\">\\r\\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Maecenas laoreet eleifend purus, ut dictum odio fringilla a. Donec vulputate magna eu massa suscipit vulputate. Nam maximus vestibulum euismod. Phasellus et metus ut erat feugiat pellentesque ornare sit amet dolor. Duis in est pulvinar, condimentum tortor ut, finibus mauris. Morbi a gravida ipsum. Vestibulum egestas, neque auctor volutpat tincidunt, lacus justo porttitor odio, id hendrerit ipsum est id libero. Donec dui lectus, feugiat quis sodales id, fringilla in velit. Phasellus risus purus, blandit et lacinia nec, molestie convallis turpis.<\\/p>\\r\\n<p>Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Proin vitae arcu tellus. Duis porttitor justo eu tincidunt tristique. Maecenas porta magna ligula, vitae sollicitudin augue convallis vel. Nam imperdiet porta faucibus. Aliquam erat volutpat. Quisque non malesuada lorem. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Class aptent taciti sociosqu ad litora torquent per conubia nostra, per inceptos himenaeos. Pellentesque tristique nibh nulla, nec euismod orci ultricies eget. Donec sodales elit ut odio posuere venenatis. Nam non nisl lectus.<\\/p>\\r\\n<p>Duis ac mauris vulputate, eleifend nunc in, tincidunt quam. Maecenas ullamcorper, neque non consectetur tincidunt, metus eros molestie dolor, in rutrum quam dolor non leo. Integer ornare consectetur nulla vel congue. Etiam dapibus risus dui, eget vehicula velit malesuada ut. Nulla sodales elit felis, non imperdiet neque porttitor vitae. Quisque nec odio eget ante malesuada interdum quis ut ex. Pellentesque rhoncus vestibulum diam, eu imperdiet sapien pellentesque dictum. Quisque vehicula, risus vel interdum aliquet, leo leo aliquet risus, a volutpat mauris ligula at massa. Etiam ac sollicitudin sapien, at iaculis felis. Donec aliquam eros sit amet iaculis facilisis.<\\/p>\\r\\n<p>Fusce mauris tellus, dapibus a urna non, vulputate porta ligula. Sed facilisis quam nec tortor tincidunt, hendrerit interdum mi vehicula. Ut interdum aliquam ultricies. Nam convallis ac libero vel posuere. Etiam at tempus nulla, vitae feugiat elit. Morbi gravida orci vitae lobortis lobortis. Nunc vehicula luctus ipsum. Maecenas vulputate eget nisl sed efficitur. In at elementum metus, nec tristique justo.<\\/p>\\r\\n<p>Mauris hendrerit mi sem, ut sagittis metus luctus at. Vestibulum quis interdum urna. Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. In est ipsum, ultrices id metus et, maximus rhoncus felis. Duis volutpat felis massa, sit amet bibendum velit laoreet nec. Maecenas quis ornare nisi. Sed massa ligula, hendrerit nec vestibulum tristique, euismod ac turpis. Sed congue, ipsum a lobortis efficitur, libero turpis commodo mauris, sed auctor sapien ligula a tellus. Donec lobortis, enim nec vestibulum fringilla, dolor enim vestibulum massa, sit amet laoreet turpis tortor in metus. Suspendisse faucibus neque felis, ac dignissim lorem gravida eu.<\\/p>\\r\\n<\\/div>\\r\\n<\\/div>\"}', 1, 8, 'Texte d\'exemple', 15),
(122, '{\"type\":\"6\",\"question\":\"<p class=\\\"SousTitre\\\" style=\\\"margin-top: 30px; margin-bottom: 12px; font-weight: bold; text-decoration-line: underline; font-family: \'Century Gothic\'; font-size: 13px;\\\"><span style=\\\"text-decoration: underline;\\\">1. R&egrave;gle d\'accord g&eacute;n&eacute;rale TEST MODIF<br \\/><\\/span><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Le&nbsp;<strong class=\\\"DecorationText1\\\" style=\\\"color: #ff0000;\\\">verbe<\\/strong>&nbsp;s\'accorde&nbsp;<strong>en genre et en nombre,&nbsp;<\\/strong>selon<strong>&nbsp;un mode et un temps<\\/strong>, avec le&nbsp;<strong class=\\\"DecorationText1\\\" style=\\\"color: #ff0000;\\\">sujet<\\/strong>&nbsp;auquel il se rapporte.<\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : Cet homme beau, riche et instruit me laiss<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">e<\\/span><span class=\\\"ExpTexte\\\">&nbsp;de marbre<\\/span>.&nbsp;<em>(sujet =&nbsp;<\\/em>cet homme beau, riche et instruit<em>&nbsp;-&gt; il)<\\/em><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : St&eacute;phanie et Laure sont bien arriv<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">&eacute;es<\\/span>&nbsp;&agrave; Madagascar.&nbsp;<em>(sujet =<\\/em>&nbsp;St&eacute;phanie et Laure<em>&nbsp;-&gt; elles)<\\/em><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : Ils mont<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">&egrave;rent<\\/span>&nbsp;dans l\'avion et eur<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">ent<\\/span>&nbsp;tout de suite peur.&nbsp;<em>(sujet =&nbsp;<\\/em>Ils<em>)<\\/em><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : Votre tarte aux pommes m\'attir<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">e<\\/span>&nbsp;irr&eacute;sistiblement.&nbsp;<em>(sujet =&nbsp;<\\/em>Votre tarte aux pommes<em>&nbsp;-&gt; elle)<\\/em><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : [...] ce lieu in&eacute;dit o&ugrave; se m&eacute;lang<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">ent<\\/span>&nbsp;diff&eacute;rentes classes sociales.&nbsp;<em>(sujet =&nbsp;<\\/em>diff&eacute;rentes classes sociales&nbsp;<em>-&gt; elles)<\\/em><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : Aur<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">ais<\\/span>-tu oubli&eacute; de me remercier chaleureusement ?&nbsp;<em>(sujet =<\\/em>&nbsp;tu<em>)<\\/em><\\/p>\\r\\n<p class=\\\"SousTitre\\\" style=\\\"margin-top: 30px; margin-bottom: 12px; font-weight: bold; text-decoration-line: underline; font-family: \'Century Gothic\'; font-size: 13px;\\\"><a name=\\\"2\\\"><\\/a>2.&nbsp;<span style=\\\"text-decoration: underline;\\\">R&egrave;gle d\'accord avec plusieurs sujets s&eacute;par&eacute;s par<em>&nbsp;et<\\/em>,&nbsp;<em>ou<\\/em>,&nbsp;<em>ni<\\/em><\\/span><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">- Lorsque les&nbsp;<strong class=\\\"DecorationText1\\\" style=\\\"color: #ff0000;\\\">sujets<\\/strong>&nbsp;sont associ&eacute;s par&nbsp;<strong><em>et<\\/em><\\/strong>, le&nbsp;<strong class=\\\"DecorationText1\\\" style=\\\"color: #ff0000;\\\">verbe<\\/strong>&nbsp;s\'accorde au&nbsp;<strong>pluriel<\\/strong>.<\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Le&nbsp;<strong class=\\\"DecorationText1\\\" style=\\\"color: #ff0000;\\\">participe pass&eacute;<\\/strong>&nbsp;s\'accorde au&nbsp;<strong>f&eacute;minin<\\/strong>&nbsp;uniquement si tous les&nbsp;<strong class=\\\"DecorationText1\\\" style=\\\"color: #ff0000;\\\">sujets<\\/strong>&nbsp;sont au<strong>&nbsp;f&eacute;minin<\\/strong>. Si au moins un des&nbsp;<strong class=\\\"DecorationText1\\\" style=\\\"color: #ff0000;\\\">sujets<\\/strong>&nbsp;est au&nbsp;<strong>masculin<\\/strong>, le&nbsp;<strong class=\\\"DecorationText1\\\" style=\\\"color: #ff0000;\\\">participe pass&eacute;<\\/strong>&nbsp;reste au&nbsp;<strong>masculin<\\/strong>.<\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : La chambre&nbsp;<strong>et<\\/strong>&nbsp;la salle de bains sont bien agenc<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">&eacute;es<\\/span>.&nbsp;<em>(sujet au f&eacute;minin pluriel)<\\/em><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : Sa m&egrave;re, son p&egrave;re&nbsp;<strong>et<\\/strong>&nbsp;sa s<em>&oelig;<\\/em>ur sont baptis<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">&eacute;s<\\/span>.&nbsp;<em>(sujet au masculin pluriel)<\\/em><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">- Lorsque les&nbsp;<span class=\\\"DecorationText1\\\" style=\\\"font-weight: bold; color: #ff0000;\\\">sujets<\\/span>&nbsp;sont associ&eacute;s par&nbsp;<strong><em>ou<\\/em>&nbsp;<\\/strong>ou&nbsp;<strong><em>ni<\\/em><\\/strong>, le&nbsp;<strong class=\\\"DecorationText1\\\" style=\\\"color: #ff0000;\\\">verbe<\\/strong>&nbsp;s\'accorde soit avec les deux&nbsp;<span class=\\\"DecorationText1\\\" style=\\\"font-weight: bold; color: #ff0000;\\\">sujets<\\/span>&nbsp;r&eacute;unis (&agrave; la mani&egrave;re de&nbsp;<em><strong>et<\\/strong><\\/em>), soit avec l\'un des&nbsp;<span class=\\\"DecorationText1\\\" style=\\\"font-weight: bold; color: #ff0000;\\\">sujets<\\/span>.<\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : Diane ou Lucie&nbsp;<span class=\\\"ExpTexte\\\">devr<\\/span><span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">a<\\/span>&nbsp;assurer le service.&nbsp;<em>(sujet au f&eacute;minin singulier)<\\/em><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : L\'&eacute;v&ecirc;que, le cur&eacute; ou le pr&ecirc;tre&nbsp;<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">seront<\\/span>&nbsp;tr&egrave;s bien accueill<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">is<\\/span>.&nbsp;<em>(sujet au masculin pluriel)<\\/em><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : Ni G&eacute;rard ni Bernadette n\'<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">ont<\\/span>&nbsp;choisi leur pr&eacute;nom.&nbsp;<em>(sujet au masculin pluriel)<\\/em><\\/p>\\r\\n<p class=\\\"SousTitre\\\" style=\\\"margin-top: 30px; margin-bottom: 12px; font-weight: bold; text-decoration-line: underline; font-family: \'Century Gothic\'; font-size: 13px;\\\"><span style=\\\"text-decoration: underline;\\\"><a name=\\\"3\\\"><\\/a>3. R&egrave;gle d\'accord avec&nbsp;<\\/span>les noms collectifs<\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Lorsqu\'un&nbsp;<strong>nom collectif<\\/strong>&nbsp;est employ&eacute; seul, le&nbsp;<span class=\\\"DecorationText1\\\" style=\\\"font-weight: bold; color: #ff0000;\\\">verbe<\\/span>&nbsp;s\'accorde au singulier.<\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : Un groupe s\'avanc<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">e<\\/span>.<\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Quand un&nbsp;<strong>nom collectif<\\/strong>&nbsp;est accompagn&eacute; d\'un&nbsp;<strong>compl&eacute;ment de nom<\\/strong>, le&nbsp;<span class=\\\"DecorationText1\\\" style=\\\"font-weight: bold; color: #ff0000;\\\">verbe<\\/span>&nbsp;s\'accorde selon le sens le plus fort de la situation. Il peut alors &ecirc;tre conjugu&eacute; soit au&nbsp;<strong>singulier<\\/strong>, soit au&nbsp;<strong>pluriel<\\/strong>.<\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : Une foule de paysans encercl<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">ait<\\/span>&nbsp;la ville.&nbsp;<em>(on appuie sur l\'id&eacute;e de&nbsp;<\\/em>foule<em>)<\\/em><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : Un troupeau de brebis avan&ccedil;<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">aient<\\/span>&nbsp;sur la butte.&nbsp;<em>(on s\'int&eacute;resse plus aux<\\/em>&nbsp;brebis<em>&nbsp;qu\'&agrave; l\'id&eacute;e de&nbsp;<\\/em>troupeau<em>)<\\/em><\\/p>\\r\\n<p class=\\\"SousTitre\\\" style=\\\"margin-top: 30px; margin-bottom: 12px; font-weight: bold; text-decoration-line: underline; font-family: \'Century Gothic\'; font-size: 13px;\\\"><span style=\\\"text-decoration: underline;\\\"><a name=\\\"4\\\"><\\/a>4. R&egrave;gle d\'accord avec&nbsp;<em>la plupart de<\\/em><\\/span>&nbsp;et&nbsp;<em>une infinit&eacute; de<\\/em><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Si le&nbsp;<span class=\\\"DecorationText1\\\" style=\\\"font-weight: bold; color: #ff0000;\\\">sujet<\\/span>&nbsp;est&nbsp;<strong><em>la plupart de<\\/em><\\/strong>&nbsp;ou&nbsp;<strong><em>une infinit&eacute; de<\\/em><\\/strong>, le&nbsp;<span class=\\\"DecorationText1\\\" style=\\\"font-weight: bold; color: #ff0000;\\\">verbe<\\/span>&nbsp;s\'accorde toujours avec le&nbsp;<strong>compl&eacute;ment<\\/strong>.<\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : La plupart des requins ne&nbsp;<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">sont<\\/span>&nbsp;pas dangereux pour l\'homme.<\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : Une infinit&eacute; d\'actes malveillants&nbsp;<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">ont<\\/span>&nbsp;&eacute;t&eacute; commi<span class=\\\"ExpTexte\\\">s<\\/span>.<\\/p>\\r\\n<p class=\\\"SousTitre\\\" style=\\\"margin-top: 30px; margin-bottom: 12px; font-weight: bold; text-decoration-line: underline; font-family: \'Century Gothic\'; font-size: 13px;\\\"><span style=\\\"text-decoration: underline;\\\"><a name=\\\"5\\\"><\\/a>5. R&egrave;gle d\'accord avec&nbsp;<em>la moiti&eacute;<\\/em>,&nbsp;<em>la majorit&eacute;<\\/em>&nbsp;et&nbsp;<\\/span><em>la totalit&eacute;<\\/em><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">S<span class=\\\"ExpTexte\\\">i&nbsp;<strong><em>la moiti&eacute;<\\/em><\\/strong>,&nbsp;<strong><em>la majorit&eacute;<\\/em><\\/strong>&nbsp;et&nbsp;<strong><em>la totalit&eacute;<\\/em><\\/strong><\\/span>&nbsp;ne sont pas accompagn&eacute;es de&nbsp;<strong>compl&eacute;ments de nom<\\/strong>, alors le&nbsp;<strong>verbe<\\/strong>&nbsp;se conjugue au&nbsp;<strong>singulier<\\/strong>.<\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : La moiti&eacute;&nbsp;<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">a<\\/span>&nbsp;&eacute;t&eacute; mang<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">&eacute;e<\\/span>.<\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : La totalit&eacute; te reviend<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">ra<\\/span>.<\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Mais si s\'ils sont suivis d\'un&nbsp;<strong>compl&eacute;ment de nom&nbsp;<\\/strong>au&nbsp;<strong>pluriel<\\/strong>, alors le&nbsp;<strong>verbe<\\/strong>&nbsp;peut soit se conjuguer au&nbsp;<strong>singulier<\\/strong>, soit au&nbsp;<strong>pluriel<\\/strong>.<\\/p>\\r\\n<p class=\\\"SousTitre\\\" style=\\\"margin-top: 30px; margin-bottom: 12px; font-weight: bold; text-decoration-line: underline; font-family: \'Century Gothic\'; font-size: 13px;\\\"><span style=\\\"text-decoration: underline;\\\"><a name=\\\"6\\\"><\\/a>6. R&egrave;gle d\'accord avec les adjectifs num&eacute;raux, les fractions et les pourcentages<\\/span><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Si le&nbsp;<span class=\\\"DecorationText1\\\" style=\\\"font-weight: bold; color: #ff0000;\\\">sujet<\\/span>&nbsp;est un&nbsp;<strong>adjectif num&eacute;ral<\\/strong>&nbsp;(une&nbsp;<strong>quinzaine<\\/strong>, une&nbsp;<strong>centaine<\\/strong>, un&nbsp;<strong>millier<\\/strong>, etc.), une&nbsp;<strong>fraction<\\/strong>&nbsp;(<strong>un tiers<\\/strong>,&nbsp;<strong>deux quarts,&nbsp;<\\/strong>etc.) ou un&nbsp;<strong>pourcentage<\\/strong>&nbsp;(<strong>50%<\\/strong>,&nbsp;<strong>60%<\\/strong>, etc.), alors le&nbsp;<span class=\\\"DecorationText1\\\" style=\\\"font-weight: bold; color: #ff0000;\\\">verbe<\\/span>&nbsp;s\'accorde avec celui qui du&nbsp;<strong>nom<\\/strong>&nbsp;ou du&nbsp;<strong>compl&eacute;ment de nom<\\/strong>&nbsp;exprime le mieux la situation.<\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : Une centaine de magasins&nbsp;<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">sont<\\/span>&nbsp;implant<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">&eacute;s<\\/span>&nbsp;ici.&nbsp;<em>(on met l\'accent sur les&nbsp;<\\/em>magasins<em>)<\\/em><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : Un tiers des matelots arriv<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">e<\\/span>&nbsp;&agrave; franchir ce cap.&nbsp;<em>(on insiste sur la proportion)<\\/em><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : 60% de la population&nbsp;<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">est<\\/span>&nbsp;sceptique face &agrave; cette r&eacute;forme.&nbsp;<em>(l\'accent est mis sur&nbsp;<\\/em>la population<em>)<\\/em><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">En revanche, si l\'<strong>adjectif ordinal<\\/strong>, la&nbsp;<strong>fraction<\\/strong>&nbsp;ou le&nbsp;<strong>pourcentage<\\/strong>&nbsp;est pr&eacute;c&eacute;d&eacute; d\'un&nbsp;<strong>d&eacute;terminant au<\\/strong>&nbsp;<strong>pluriel<\\/strong>, alors le&nbsp;<span class=\\\"DecorationText1\\\" style=\\\"font-weight: bold; color: #ff0000;\\\">verbe<\\/span>s\'accorde avec ce dernier.<\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : Les trois quarts de la population&nbsp;<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">sont<\\/span>&nbsp;favorables &agrave; cette loi.&nbsp;<em>(d&eacute;terminant =&nbsp;<\\/em>Les<em>)<\\/em><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : Des centaines de personnes cri<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">ent<\\/span>&nbsp;de joie.&nbsp;<em>(d&eacute;terminant =&nbsp;<\\/em>Des<em>)<\\/em><\\/p>\\r\\n<p class=\\\"SousTitre\\\" style=\\\"margin-top: 30px; margin-bottom: 12px; font-weight: bold; text-decoration-line: underline; font-family: \'Century Gothic\'; font-size: 13px;\\\"><span style=\\\"text-decoration: underline;\\\"><a name=\\\"7\\\"><\\/a>7. R&egrave;gle d\'accord avec un adverbe de quantit&eacute;<\\/span><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Si un&nbsp;<strong>adverbe de quantit&eacute;<\\/strong>&nbsp;(<strong>peu<\\/strong>,&nbsp;<strong>beaucoup<\\/strong>,&nbsp;<strong>assez<\\/strong>, etc.) est suivi d\'un&nbsp;<strong>compl&eacute;ment de nom<\\/strong>, alors le&nbsp;<span class=\\\"DecorationText1\\\" style=\\\"font-weight: bold; color: #ff0000;\\\">verbe<\\/span>&nbsp;s\'accorde avec le&nbsp;<strong>compl&eacute;ment<\\/strong>.<br \\/><br \\/>Ex : Peu d\'animaux&nbsp;<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">ont<\\/span>&nbsp;cinq pattes.&nbsp;<em>(le verbe s\'accorde avec<\\/em>&nbsp;animaux<em>)<\\/em><\\/p>\\r\\n<p style=\\\"margin-top: 12px; margin-bottom: 12px; font-family: \'Century Gothic\'; font-size: 13px;\\\">Ex : Beaucoup d\'huile&nbsp;<span class=\\\"DecorationText2\\\" style=\\\"font-weight: bold; color: #0000ff;\\\">sera&nbsp;<\\/span>n&eacute;cessaire pour cuire nos bananes plantain.&nbsp;<em>(le verbe s\'accorde avec&nbsp;<\\/em>huile<em>)<\\/em><\\/p>\"}', 1, 6, 'Accord verbe sujet', 15),
(123, '{\"type\":\"7\",\"question\":\"<dl style=\\\"margin-top: 0.2em; margin-bottom: 0.5em; color: #222222; font-family: sans-serif; font-size: 14px;\\\">\\r\\n<dt style=\\\"font-weight: bold; margin-bottom: 0.1em;\\\">&Ccedil;a marche mais pas<\\/dt>\\r\\n<dd style=\\\"margin-left: 1.6em; margin-bottom: 0.1em; margin-right: 0px;\\\">Exprime le fait qu\'un logiciel ou un code fonctionne sans pour autant produire le r&eacute;sultat souhait&eacute;, sans forc&eacute;ment que l\'on ne comprenne pourquoi.<\\/dd>\\r\\n<\\/dl>\\r\\n<dl style=\\\"margin-top: 0.2em; margin-bottom: 0.5em; color: #222222; font-family: sans-serif; font-size: 14px;\\\">\\r\\n<dt style=\\\"font-weight: bold; margin-bottom: 0.1em;\\\"><a style=\\\"text-decoration-line: none; color: #0b0080; background: none;\\\" title=\\\"M&eacute;moire cache\\\" href=\\\"https:\\/\\/fr.wikipedia.org\\/wiki\\/M%C3%A9moire_cache\\\"><em>Cache<\\/em>&nbsp;ou ant&eacute;m&eacute;moire<\\/a><\\/dt>\\r\\n<dd style=\\\"margin-left: 1.6em; margin-bottom: 0.1em; margin-right: 0px;\\\">M&eacute;moire qui enregistre temporairement des copies de donn&eacute;es provenant d\'une autre source de donn&eacute;es.<\\/dd>\\r\\n<\\/dl>\\r\\n<dl style=\\\"margin-top: 0.2em; margin-bottom: 0.5em; color: #222222; font-family: sans-serif; font-size: 14px;\\\">\\r\\n<dt style=\\\"font-weight: bold; margin-bottom: 0.1em;\\\"><em><span class=\\\"lang-en\\\" lang=\\\"en\\\"><a style=\\\"text-decoration-line: none; color: #0b0080; background: none;\\\" title=\\\"Thrashing\\\" href=\\\"https:\\/\\/fr.wikipedia.org\\/wiki\\/Thrashing\\\">Cache Thrashing<\\/a><\\/span><\\/em>&nbsp;(emballement du cache, de l&rsquo;ant&eacute;m&eacute;moire)<\\/dt>\\r\\n<dd style=\\\"margin-left: 1.6em; margin-bottom: 0.1em; margin-right: 0px;\\\">Ce qui se passe quand le taux d&rsquo;interception du cache devient tr&egrave;s bas&nbsp;: les instructions sautent d&rsquo;un endroit &agrave; l&rsquo;autre de la m&eacute;moire, rendant inutiles les efforts de chargement anticip&eacute; de la m&eacute;moire dans le cache<\\/dd>\\r\\n<\\/dl>\\r\\n<dl style=\\\"margin-top: 0.2em; margin-bottom: 0.5em; color: #222222; font-family: sans-serif; font-size: 14px;\\\">\\r\\n<dt style=\\\"font-weight: bold; margin-bottom: 0.1em;\\\"><a class=\\\"mw-redirect\\\" style=\\\"text-decoration-line: none; color: #0b0080; background: none;\\\" title=\\\"Client-serveur\\\" href=\\\"https:\\/\\/fr.wikipedia.org\\/wiki\\/Client-serveur\\\">Client-serveur<\\/a>&nbsp;ou architecture 2-tiers<\\/dt>\\r\\n<dd style=\\\"margin-left: 1.6em; margin-bottom: 0.1em; margin-right: 0px;\\\">Type d\'architecture technique d\'une application informatique dans laquelle les traitements et la gestion des donn&eacute;es sont r&eacute;parties entre le serveur et le client (g&eacute;n&eacute;ralement le poste de l\'utilisateur) selon des proportions variables (on parle de client serveur l&eacute;ger lorsque l\'essentiel des traitements et des donn&eacute;es sont sur le serveur, de client lourd dans le cas inverse.<\\/dd>\\r\\n<\\/dl>\\r\\n<dl style=\\\"margin-top: 0.2em; margin-bottom: 0.5em; color: #222222; font-family: sans-serif; font-size: 14px;\\\">\\r\\n<dt style=\\\"font-weight: bold; margin-bottom: 0.1em;\\\">Code 18<\\/dt>\\r\\n<dd style=\\\"margin-left: 1.6em; margin-bottom: 0.1em; margin-right: 0px;\\\">18&nbsp;pouces est la distance moyenne s&eacute;parant un utilisateur de son &eacute;cran. Utilis&eacute; pour d&eacute;signer la responsabilit&eacute; d\'une erreur informatique (codeur ou utilisateur). Parfois connu aussi sous le vocable Code 45 (pour 45&nbsp;<abbr class=\\\"abbr\\\" style=\\\"border-bottom: 0px; cursor: help; text-decoration-line: none; text-decoration-style: initial;\\\" title=\\\"centim&egrave;tre\\\">cm<\\/abbr>).<\\/dd>\\r\\n<dd style=\\\"margin-left: 1.6em; margin-bottom: 0.1em; margin-right: 0px;\\\">On peut aussi employer &laquo;&nbsp;interface chaise-clavier&nbsp;&raquo;.<\\/dd>\\r\\n<\\/dl>\\r\\n<dl style=\\\"margin-top: 0.2em; margin-bottom: 0.5em; color: #222222; font-family: sans-serif; font-size: 14px;\\\">\\r\\n<dt style=\\\"font-weight: bold; margin-bottom: 0.1em;\\\">Coder<\\/dt>\\r\\n<dd style=\\\"margin-left: 1.6em; margin-bottom: 0.1em; margin-right: 0px;\\\">R&eacute;diger le code, programmer, &eacute;crire un programme.<\\/dd>\\r\\n<\\/dl>\\r\\n<dl style=\\\"margin-top: 0.2em; margin-bottom: 0.5em; color: #222222; font-family: sans-serif; font-size: 14px;\\\">\\r\\n<dt style=\\\"font-weight: bold; margin-bottom: 0.1em;\\\"><em><span class=\\\"lang-en\\\" lang=\\\"en\\\">Commit<\\/span><\\/em>&nbsp;(Soumission)<\\/dt>\\r\\n<dd style=\\\"margin-left: 1.6em; margin-bottom: 0.1em; margin-right: 0px;\\\">Action d&rsquo;envoyer une partie du code que l\'on a modifi&eacute; sur un serveur gr&acirc;ce &agrave; des logiciels de partage de version (<a style=\\\"text-decoration-line: none; color: #0b0080; background: none;\\\" title=\\\"Concurrent versions system\\\" href=\\\"https:\\/\\/fr.wikipedia.org\\/wiki\\/Concurrent_versions_system\\\">CVS<\\/a>,&nbsp;<a style=\\\"text-decoration-line: none; color: #0b0080; background: none;\\\" title=\\\"Apache Subversion\\\" href=\\\"https:\\/\\/fr.wikipedia.org\\/wiki\\/Apache_Subversion\\\">SVN<\\/a>,&nbsp;<a style=\\\"text-decoration-line: none; color: #0b0080; background: none;\\\" title=\\\"Git\\\" href=\\\"https:\\/\\/fr.wikipedia.org\\/wiki\\/Git\\\">GIT<\\/a>).<\\/dd>\\r\\n<\\/dl>\\r\\n<dl style=\\\"margin-top: 0.2em; margin-bottom: 0.5em; color: #222222; font-family: sans-serif; font-size: 14px;\\\">\\r\\n<dt style=\\\"font-weight: bold; margin-bottom: 0.1em;\\\"><a style=\\\"text-decoration-line: none; color: #0b0080; background: none;\\\" title=\\\"Compilateur\\\" href=\\\"https:\\/\\/fr.wikipedia.org\\/wiki\\/Compilateur\\\">Compile<\\/a><\\/dt>\\r\\n<dd style=\\\"margin-left: 1.6em; margin-bottom: 0.1em; margin-right: 0px;\\\">R&eacute;sultat de la transformation d\'un programme &eacute;crit en langage compilable.<\\/dd>\\r\\n<\\/dl>\\r\\n<dl style=\\\"margin-top: 0.2em; margin-bottom: 0.5em; color: #222222; font-family: sans-serif; font-size: 14px;\\\">\\r\\n<dt style=\\\"font-weight: bold; margin-bottom: 0.1em;\\\"><a style=\\\"text-decoration-line: none; color: #0b0080; background: none;\\\" title=\\\"Consultant\\\" href=\\\"https:\\/\\/fr.wikipedia.org\\/wiki\\/Consultant\\\">Consultant<\\/a><\\/dt>\\r\\n<dd style=\\\"margin-left: 1.6em; margin-bottom: 0.1em; margin-right: 0px;\\\"><span class=\\\"need_ref\\\" style=\\\"border-bottom: 1px solid #aaaaaa; cursor: help;\\\" title=\\\"Ce passage semble contrevenir &agrave; la neutralit&eacute; de point de vue.\\\">Le Monsieur-je-sais-tout de l\'informatique<\\/span><sup class=\\\"need_ref_tag\\\" style=\\\"line-height: 1; padding-left: 2px;\\\"><a style=\\\"text-decoration-line: none; color: #0b0080; background: none;\\\" title=\\\"Wikip&eacute;dia:Neutralit&eacute; de point de vue\\\" href=\\\"https:\\/\\/fr.wikipedia.org\\/wiki\\/Wikip%C3%A9dia:Neutralit%C3%A9_de_point_de_vue\\\">[non neutre]<\\/a><\\/sup>. Il existe diverses variantes: consultant&nbsp;<a style=\\\"text-decoration-line: none; color: #0b0080; background: none;\\\" title=\\\"Progiciel\\\" href=\\\"https:\\/\\/fr.wikipedia.org\\/wiki\\/Progiciel\\\">progiciel<\\/a>, consultant technique, consultant fonctionnel, consultant r&eacute;seau&hellip; Personne qui loue ses comp&eacute;tences &agrave; des entreprises ou des particuliers dans le but de r&eacute;soudre des probl&egrave;mes que l\'entreprise ou les particuliers ne savent pas r&eacute;soudre.<\\/dd>\\r\\n<\\/dl>\\r\\n<dl style=\\\"margin-top: 0.2em; margin-bottom: 0.5em; color: #222222; font-family: sans-serif; font-size: 14px;\\\">\\r\\n<dt style=\\\"font-weight: bold; margin-bottom: 0.1em;\\\">Couche 8<\\/dt>\\r\\n<dd style=\\\"margin-left: 1.6em; margin-bottom: 0.1em; margin-right: 0px;\\\">Mani&egrave;re de d&eacute;signer les utilisateurs par r&eacute;f&eacute;rence au&nbsp;<a style=\\\"text-decoration-line: none; color: #0b0080; background: none;\\\" title=\\\"Mod&egrave;le OSI\\\" href=\\\"https:\\/\\/fr.wikipedia.org\\/wiki\\/Mod%C3%A8le_OSI\\\">Mod&egrave;le OSI<\\/a>. Voir aussi ICC (interface chaise-clavier) ou Code 18 \\/ Code 45.<\\/dd>\\r\\n<\\/dl>\\r\\n<dl style=\\\"margin-top: 0.2em; margin-bottom: 0.5em; color: #222222; font-family: sans-serif; font-size: 14px;\\\">\\r\\n<dt style=\\\"font-weight: bold; margin-bottom: 0.1em;\\\"><a style=\\\"text-decoration-line: none; color: #0b0080; background: none;\\\" title=\\\"Chef de projet\\\" href=\\\"https:\\/\\/fr.wikipedia.org\\/wiki\\/Chef_de_projet\\\">CP<\\/a><\\/dt>\\r\\n<dd style=\\\"margin-left: 1.6em; margin-bottom: 0.1em; margin-right: 0px;\\\">Abr&eacute;viation de &laquo;&nbsp;chef de projet&nbsp;&raquo;.<\\/dd>\\r\\n<dd style=\\\"margin-left: 1.6em; margin-bottom: 0.1em; margin-right: 0px;\\\">Il existe des chefs de projet ma&icirc;trise d\'&oelig;uvre (CP MOE) ou ma&icirc;trise d\'ouvrage (CP MOA).<\\/dd>\\r\\n<\\/dl>\\r\\n<dl style=\\\"margin-top: 0.2em; margin-bottom: 0.5em; color: #222222; font-family: sans-serif; font-size: 14px;\\\">\\r\\n<dt style=\\\"font-weight: bold; margin-bottom: 0.1em;\\\">Crasher<\\/dt>\\r\\n<dd style=\\\"margin-left: 1.6em; margin-bottom: 0.1em; margin-right: 0px;\\\">Une application qui crashe est un programme qui plante sans que l\'utilisateur ait une id&eacute;e de la cause du probl&egrave;me survenu.<\\/dd>\\r\\n<\\/dl>\\r\\n<dl style=\\\"margin-top: 0.2em; margin-bottom: 0.5em; color: #222222; font-family: sans-serif; font-size: 14px;\\\">\\r\\n<dt style=\\\"font-weight: bold; margin-bottom: 0.1em;\\\"><a style=\\\"text-decoration-line: none; color: #0b0080; background: none;\\\" title=\\\"Unit&eacute; de calcul en virgule flottante\\\" href=\\\"https:\\/\\/fr.wikipedia.org\\/wiki\\/Unit%C3%A9_de_calcul_en_virgule_flottante\\\">Coprocesseur<\\/a>&nbsp;arithm&eacute;tique<\\/dt>\\r\\n<dd style=\\\"margin-left: 1.6em; margin-bottom: 0.1em; margin-right: 0px;\\\">Microprocesseur additionnel (et optionnel) destin&eacute; &agrave; soulager le microprocesseur principal des calculs en virgule flottante. La firme&nbsp;<a style=\\\"text-decoration-line: none; color: #0b0080; background: none;\\\" title=\\\"Intel\\\" href=\\\"https:\\/\\/fr.wikipedia.org\\/wiki\\/Intel\\\">Intel<\\/a>&nbsp;a int&eacute;gr&eacute; cette unit&eacute; de calcul au microprocesseur principal &agrave; partir de son mod&egrave;le&nbsp;<a style=\\\"text-decoration-line: none; color: #0b0080; background: none;\\\" title=\\\"Intel 80486DX\\\" href=\\\"https:\\/\\/fr.wikipedia.org\\/wiki\\/Intel_80486DX\\\">486DX<\\/a>.<\\/dd>\\r\\n<\\/dl>\\r\\n<dl style=\\\"margin-top: 0.2em; margin-bottom: 0.5em; color: #222222; font-family: sans-serif; font-size: 14px;\\\">\\r\\n<dt style=\\\"font-weight: bold; margin-bottom: 0.1em;\\\"><a style=\\\"text-decoration-line: none; color: #0b0080; background: none;\\\" title=\\\"Gestion de la relation client\\\" href=\\\"https:\\/\\/fr.wikipedia.org\\/wiki\\/Gestion_de_la_relation_client\\\">CRM<\\/a><\\/dt>\\r\\n<dd style=\\\"margin-left: 1.6em; margin-bottom: 0.1em; margin-right: 0px;\\\">Abr&eacute;viation de l&rsquo;anglais &laquo;&nbsp;<em><span class=\\\"lang-en\\\" lang=\\\"en\\\">Customer Relationship Management<\\/span><\\/em>&nbsp;&raquo; (gestion de la relation client).<\\/dd>\\r\\n<dd style=\\\"margin-left: 1.6em; margin-bottom: 0.1em; margin-right: 0px;\\\">Outils permettant de g&eacute;rer la relation avec les clients dans le but d\'am&eacute;liorer la qualit&eacute; de service et surtout d\'augmenter le chiffre d\'affaires r&eacute;alis&eacute; avec chaque client.<\\/dd>\\r\\n<dd style=\\\"margin-left: 1.6em; margin-bottom: 0.1em; margin-right: 0px;\\\">Un r&eacute;tro-sigle fran&ccedil;ais est&nbsp;<em>Comment Ramener la Monnaie<\\/em>.<\\/dd>\\r\\n<\\/dl>\\r\\n<p>&nbsp;<\\/p>\\r\\n<p>...<\\/p>\"}', 1, 7, 'jargon info: la lettre C', 15),
(124, '{\"type\":\"12\",\"motclef\":\"photo\",\"media\":{\"id\":8,\"fichier\":\"07d018256475cd66fa1f4349d4c5925f.bmp\"}}', 0, 12, 'essai vide', 15),
(125, '{\"type\":\"12\",\"motclef\":\"photo\",\"media\":{\"id\":8,\"fichier\":\"07d018256475cd66fa1f4349d4c5925f.bmp\"}}', 0, 12, 'essai vide', 16),
(126, '{\"type\":\"9\",\"question\":\"\"}', 0, 9, '', 15),
(127, '{\"type\":\"9\",\"question\":\"\"}', 1, 9, 'Opinion', 27),
(128, '{\"type\":\"5\",\"question\":\"<p>Comment vous appelez-vous ?<\\/p>\"}', 0, 5, 'se présenter', 16),
(129, '{\"type\":\"5\",\"question\":\"<p>what\'s your name ?<\\/p>\"}', 1, 5, 'Se présenter', 16),
(130, '{\"type\":\"4\",\"texte\":{\"1\":[\"<p>Nuire<\\/p>\",\"<p>Damage<\\/p>\"],\"2\":[\"<p>Dette<\\/p>\",\"<p>Debt<\\/p>\"],\"3\":[\"<p>Boite de nuit<\\/p>\",\"<p>Nightclub<\\/p>\"]}}', 1, 4, 'Tulips', 16),
(131, '{\"type\":\"9\",\"question\":\"<p>Read the text and do[the] work<\\/p>\"}', 1, 9, 'Tulips 2', 16),
(132, '{\"type\":\"2\",\"texte\":[\"Organise a conference:\\u00a0Elicit tasks to be doneLook at modalsWrite a timetable and then list of \",\"\\u00a0then each person must \",\"\\u00a0an email pertinent to the theme\\u00a0\"],\"reponses\":{\"1\":\"responsibilities\",\"2\":\"write\"}}', 1, 2, 'Tulips 3', 16),
(133, '{\"type\":\"3\",\"texte\":[\"How much is\\u00a0\",\" doggy in the window\"],\"reponses\":{\"1\":\"\"}}', 1, 3, 'Tulips 4', 16),
(134, '{\"type\":\"4\",\"texte\":{\"1\":[\"<p>flower<\\/p>\",\"<p>tulip<\\/p>\"]}}', 1, 4, 'TEST PF V2 LN Team', 16),
(135, '{\"type\":\"9\",\"question\":\"<p>hello everybody . Tell us if ...<\\/p>\"}', 1, 9, 'Consigne du 25 SEPT. 18', 15),
(136, '{\"type\":\"7\",\"question\":\"<p>Point&nbsp;<\\/p>\"}', 0, 7, 'team building', 17),
(137, '{\"type\":\"4\",\"texte\":{\"1\":[\"media_id_1\",\"media_id_2\"]}}', 1, 4, 'ASSOCIATION POUR RIRE', 15),
(138, '{\"type\":\"2\",\"texte\":[\"\",\"&nbsp;tend to be&nbsp;\",\" than \",\". Example:\",\" vs.\",\"&nbsp;\"],\"reponses\":{\"1\":\"Cooked cheeses\",\"2\":\"firmer and softer\",\"3\":\"raw cheeses\",\"4\":\"gouda\",\"5\":\"roquefort\"}}', 1, 2, 'fromage', 16),
(139, '{\n    \"type\":\"1\",\n    \"questions\":{\n        \"1\":\"<p>Quel est la couleur du cheval blanc d\'Henry IV ?</p>\"\n    },\n    \"reponses\":{\n        \"1\":{\n            \"type\":\"1\",\n            \"0\":{\"texte\":\"Blanc\",\"etat\":\"1\"},\n            \"1\":{\"texte\":\"Bleu\",\"etat\":\"0\"},\n            \"2\":{\"texte\":\"Rose\",\"etat\":\"0\"}\n        }\n    }\n}', 1, 1, 'QCM pour un champion', 15),
(140, '{\"type\":\"4\",\"texte\":{\"1\":[\"<p>Et je cours<\\/p>\",\"<p>je me raccroche &agrave; la vie<\\/p>\"],\"2\":[\"<p>Deux &eacute;trangers au bout du monde<\\/p>\",\"<p>si diff&eacute;rents<\\/p>\"],\"3\":[\"<p>Un jour je serais<\\/p>\",\"<p>le meilleur dresseur<\\/p>\"]}}', 1, 4, 'Un exercice d\'association très dur', 15),
(141, '{\"type\":\"8\",\"question\":\"<div id=\\\"lipsum\\\">\\r\\n<p>Lorem ipsum dolor sit amet, consectetur adipiscing elit. Phasellus gravida purus vitae tempor luctus. Phasellus a eros vel neque ornare hendrerit. Donec vitae velit diam. Nam rhoncus, neque id faucibus porta, arcu sem scelerisque ex, et maximus mauris sapien in lorem. Etiam aliquet mauris vel venenatis ornare. Cras nec urna erat. Etiam mauris odio, maximus et justo ut, tristique fermentum sem. Integer euismod quam purus, eget molestie risus consectetur vel. Orci varius natoque penatibus et magnis dis parturient montes, nascetur <strong>ridiculus<\\/strong> mus. Mauris ipsum mauris, feugiat vitae vehicula ac, varius vitae sem. Integer non odio tempor, suscipit sapien et, laoreet odio. Integer nec aliquam nunc.<\\/p>\\r\\n<ol>\\r\\n<li>Liste 1<\\/li>\\r\\n<li>Liste 2<\\/li>\\r\\n<li>Liste 3<\\/li>\\r\\n<\\/ol>\\r\\n<p>Curabitur ornare nisi nunc, id ultricies magna faucibus in. Aenean ac tristique mi, eu tempor massa. Proin luctus velit ac ipsum sagittis, eu euismod tellus efficitur. Nullam sed ipsum suscipit, venenatis lacus at, tristique nibh. Vivamus consectetur mattis suscipit. Nam hendrerit sed nisl et porttitor. Vestibulum imperdiet arcu id mi laoreet varius. Etiam dapibus lacinia felis ac porttitor. Donec magna diam, laoreet nec libero id, blandit aliquam turpis.<\\/p>\\r\\n<p>Maecenas hendrerit tristique neque <strong>posuere pharetra<\\/strong>. In egestas sapien metus, id porta turpis faucibus egestas. Maecenas elementum vehicula dapibus. Donec tristique iaculis molestie. Ut euismod sodales porta. Donec ac nisl nunc. In lectus arcu, pellentesque nec ligula ac, euismod malesuada magna. Suspendisse euismod consectetur blandit. Etiam quis vulputate augue. Sed non orci aliquet, egestas dui ut, porta felis. Donec pulvinar <em>urna<\\/em> ipsum, tempor interdum quam ultrices vitae.<\\/p>\\r\\n<p>Pellentesque habitant morbi tristique senectus et netus et malesuada fames ac turpis egestas. Sed vel libero nisi. Duis convallis facilisis facilisis. Mauris mattis odio id arcu feugiat consequat. Etiam rhoncus odio vitae mauris tincidunt semper. Etiam nec vulputate augue. Sed facilisis dui eu quam auctor, eget pellentesque nulla finibus. Aenean eget condimentum velit. Etiam eget tortor nisl. <strong>Donec<\\/strong> at lectus et leo aliquam imperdiet. Nunc cursus enim nec velit efficitur sagittis. Suspendisse sed porta ante, eget egestas odio. Sed rhoncus dapibus dapibus. Integer molestie dolor justo, at mollis metus egestas in. Donec ut vehicula massa. Donec augue nunc, dapibus in sem eget, dictum ullamcorper sapien.<\\/p>\\r\\n<p>Nulla facilisi. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec commodo velit at eleifend auctor. Nunc iaculis orci ut nisi volutpat, ut bland<span style=\\\"text-decoration: underline;\\\">it lorem accumsan. Sed molestie dui a pharetra tincidunt. Duis sapien metus, congue malesuada viverra vitae, molestie sit amet quam. Praesent at posuere nibh. Donec non mauris sit amet risus tincidunt auctor eget ut erat. Suspe<\\/span>ndisse in mi et sem blandit pulvinar. Maecenas congue, arcu ut facilisis pharetra, mi lorem vestibulum mi, sed tristique velit lorem ut ligula. Proin hendrerit ipsum eu sapien pretium auctor. Curabitur porta vel metus non feugiat. Nulla facilisi.<\\/p>\\r\\n<\\/div>\"}', 1, 8, 'Exercice NG1', 16),
(142, '{\"type\":\"9\",\"question\":\"<p>Test de consigne<\\/p>\"}', 1, 9, 'Exercice NG2', 16),
(143, '{\"type\":\"1\",\"questions\":{\"1\":\"<p>Traduisez le chiffre 1<\\/p>\"},\"reponses\":{\"1\":{\"type\":\"1\",\"0\":{\"texte\":\"One\",\"etat\":\"1\"},\"1\":{\"texte\":\"Two\",\"etat\":\"0\"},\"2\":{\"texte\":\"Three\",\"etat\":\"0\"}}}}', 1, 1, 'Exercice NG3', 16),
(144, '{\"type\":\"4\",\"texte\":{\"1\":[\"media_id_2\",\"<p>Voiture<\\/p>\"],\"2\":[\"media_id_8\",\"<p>Moto<\\/p>\"]}}', 1, 4, 'Exercice NG4', 16),
(145, '{\"type\":\"2\",\"texte\":[\"Je suis un \",\" de \",\" et c\'est super bien !\"],\"reponses\":{\"1\":\"texte\",\"2\":\"test\"}}', 1, 2, 'Exercice NG5', 16),
(146, '{\"type\":\"6\",\"question\":\"<p>Point Grammaire :<br \\/><br \\/>R&egrave;gles communes:<\\/p>\\r\\n<ol>\\r\\n<li>Les modaux sont suivis de la base verbale, c\'est-&agrave;-dire l\'infinitif sans TO. Il n\'y a donc pas d\'accord, &agrave; toutes les personnes.<\\/li>\\r\\n<li>I can swim, you can swim, he\\/she\\/it can swim, you can swim, they can swim<\\/li>\\r\\n<li>Forme n&eacute;gative : on utilise la contraction N\'T: She can\'t drive, she mustn\'t come...<\\/li>\\r\\n<li>Forme interrogative : on fait l\'inversion. Can she drive? Must she come?<\\/li>\\r\\n<\\/ol>\"}', 1, 6, 'Exercice NG6', 16),
(147, '{\"type\":\"10\",\"motclef\":\"musique libre de droit\",\"media\":{\"id\":6,\"fichier\":\"abbb50d798330a2902e28c987f2e2235.mpga\"}}', 1, 10, 'Casse-noisettes', 16),
(148, '{\"type\":\"4\",\"texte\":{\"1\":[\"media_id_5\",\"<p>Life<\\/p>\"],\"2\":[\"media_id_6\",\"<p>Bolero<\\/p>\"],\"3\":[\"media_id_7\",\"<p>Every\'s gotta live<\\/p>\"]}}', 1, 4, 'Blind test', 16),
(149, '{\"type\":\"9\",\"question\":\"<p>Test<\\/p>\"}', 1, 9, 'Mon premier composant', 16),
(150, '{\"type\":\"9\",\"question\":\"<p>qsdqsd<\\/p>\"}', 0, 9, 'sssss', 27),
(151, '{\"type\":\"4\",\"texte\":{\"1\":[\"media_id_8\",\"<p>Moto<\\/p>\"],\"2\":[\"media_id_2\",\"<p><span style=\\\"color: #ff9900;\\\">Voi<\\/span>t<span style=\\\"background-color: #993300;\\\">ure<\\/span><\\/p>\"]}}', 1, 4, 'Mon assoc de locomotion', 15),
(152, '{\"type\":\"13\",\"question\":\"<p>Test transcript<\\/p>\"}', 1, 13, 'test', 19),
(153, '{\"type\":\"4\",\"texte\":{\"1\":[\"media_id_12\",\"<p>beach<\\/p>\"],\"2\":[\"media_id_11\",\"<p>moutain<\\/p>\"]}}', 1, 4, 'Les paysages', 16),
(154, '{\"type\":\"2\",\"texte\":[\"\",\" a \",\" b \",\" c \",\" d \",\"\"],\"reponses\":{\"1\":\"1\",\"2\":\"2\",\"3\":\"3\",\"4\":\"4\",\"5\":\"5\"}}', 1, 2, 'Test Texte à trou 1', 16),
(155, '{\"type\":\"2\",\"texte\":[\"\",\" \",\" \",\" \",\" \",\"\"],\"reponses\":{\"1\":\"1\",\"2\":\"2\",\"3\":\"3\",\"4\":\"4\",\"5\":\"5\"}}', 1, 2, 'Test Texte à trou 2', 16),
(156, '{\"type\":\"13\",\"question\":\"<p>Bla bla bla<\\/p>\\r\\n<p>Ligne2<\\/p>\\r\\n<p>Fin de bla bla<\\/p>\"}', 1, 13, 'transcript de test', 16),
(157, '{\"type\":\"10\",\"motclef\":\" \"}', 1, 10, 'Sample Audio', 16),
(158, '{\"type\":\"11\",\"motclef\":\"Sample vid\\u00e9o\",\"media\":{\"id\":10,\"fichier\":\"11bfeac972a2614d95e2779aa1fb631d.mp4\"}}', 1, 11, 'Sample Vidéo', 16),
(159, '{\"type\":\"10\",\"motclef\":\"sdfsdf\"}', 1, 10, 'Sample 2', 16),
(160, '{\"type\":\"10\",\"motclef\":\"sdfsdf\"}', 1, 10, 'dfsfsdf ', 16),
(161, '{\"type\":\"10\",\"motclef\":\"qsdqs\"}', 1, 10, 'test1030', 16),
(162, '{\"type\":\"1\",\"questions\":{\"1\":\"<p><span id=\\\"mce_4\\\" class=\\\"ns_correction_prof\\\">La nuit les chat sont gris ?<br \\/><\\/span><\\/p>\",\"2\":\"<p><span id=\\\"mce_5\\\" class=\\\"ns_correction_prof\\\">Un animal &agrave; 4 pattes ?<br \\/><\\/span><\\/p>\",\"3\":\"<p><span id=\\\"mce_6\\\" class=\\\"ns_correction_prof\\\">Traduisez 1<br \\/><\\/span><\\/p>\"},\"reponses\":{\"1\":{\"type\":\"1\",\"0\":{\"texte\":\"Oui\",\"etat\":\"1\"},\"1\":{\"texte\":\"Non\",\"etat\":\"0\"}},\"2\":{\"type\":\"0\",\"0\":{\"texte\":\"Chat\",\"etat\":\"1\"},\"1\":{\"texte\":\"Chien\",\"etat\":\"1\"},\"2\":{\"texte\":\"Corbeau\",\"etat\":\"0\"}},\"3\":{\"type\":\"1\",\"0\":{\"texte\":\"one\",\"etat\":\"1\"},\"1\":{\"texte\":\"Two\",\"etat\":\"0\"},\"2\":{\"texte\":\"Three\",\"etat\":\"0\"}}}}', 1, 1, 'Test NG1116', 16),
(163, '{\"type\":\"10\",\"motclef\":\"Sample 1133\",\"media\":{\"id\":17,\"fichier\":\"82786902193929ebf7397fd9be9dd4c4.mp3\"}}', 1, 10, 'Sample 1133', 16);

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

--
-- Structure de la table `formation`
--

CREATE TABLE IF NOT EXISTS `formation` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `duree_visio` int(11) DEFAULT NULL,
  `duree_conversation` int(11) DEFAULT NULL,
  `duree_plateforme` int(11) DEFAULT NULL,
  `duree_face` int(11) DEFAULT NULL,
  `niveau_id` int(11) DEFAULT NULL,
  `langue_id` int(11) DEFAULT NULL,
  `formation_type_id` int(11) DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `designation` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `objectif` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `commentaire` longtext COLLATE utf8_unicode_ci,
  `activitesrealisees` longtext COLLATE utf8_unicode_ci,
  `grammaire` longtext COLLATE utf8_unicode_ci,
  `vocabulaire` longtext COLLATE utf8_unicode_ci,
  `phonetique` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IDX_404021BFB3E9C81` (`niveau_id`),
  KEY `IDX_404021BF2AADBACD` (`langue_id`),
  KEY `IDX_404021BF80B3C9E8` (`formation_type_id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `formation`
--

TRUNCATE TABLE `formation`;
--
-- Déchargement des données de la table `formation`
--

INSERT INTO `formation` (`id`, `duree_visio`, `duree_conversation`, `duree_plateforme`, `duree_face`, `niveau_id`, `langue_id`, `formation_type_id`, `active`, `designation`, `objectif`, `commentaire`, `activitesrealisees`, `grammaire`, `vocabulaire`, `phonetique`) VALUES
(10, 0, 0, 0, 0, 54, 19, 3, 1, 'Test de formation', 'qsdqsdqs', NULL, NULL, NULL, NULL, NULL),
(11, 2, 2, 2, 2, 51, 16, 1, 1, '', '', NULL, NULL, NULL, NULL, NULL),
(12, 10, 11, 12, 13, 55, 23, 3, 1, '', '', NULL, NULL, NULL, NULL, NULL),
(13, 10, 10, 10, 10, 50, 16, 3, 1, 'Formation Nalta', 'Tester', NULL, '', '', '', ''),
(14, 1, 1, 1, 1, 50, 16, 3, 1, 'Formation Anglais avancée', 'Etre très fort en anglais', NULL, NULL, NULL, NULL, NULL),
(15, 0, 0, 0, 0, 57, 16, 3, 1, 'IRFASE 2018', 'Social work communication', NULL, NULL, NULL, NULL, NULL),
(16, 0, 1, 1, -1, 52, 16, 3, 1, 'TEST 2 Ann', 'blabla', NULL, NULL, NULL, NULL, NULL),
(17, -1, 1, 1, -1, 50, 27, 6, 1, 'cvcv', 'vbvb', NULL, NULL, NULL, NULL, NULL),
(18, 0, 0, 0, 0, 57, 17, 3, 1, 'Entrainement', 'Tester', NULL, NULL, NULL, NULL, NULL),
(19, 0, 0, 0, 0, 57, 16, 3, 1, 'Amsterdamnnn', 'Communication', NULL, NULL, NULL, NULL, NULL),
(20, 0, 0, 0, 0, 52, 16, 3, 1, 'Savoir parler de soi', 'savoir parler de ses goûts', NULL, NULL, NULL, NULL, NULL),
(21, 1, 0, 1, 0, 50, 16, 3, 1, 'ELO', 'Sing along', NULL, NULL, NULL, NULL, NULL),
(22, 1, 0, 0, 0, 57, 16, 3, 1, 'qsd', 'ixc', NULL, NULL, NULL, NULL, NULL),
(23, 0, 0, 0, 0, 51, 16, 12, 1, 'Bed time', 'Sleep', NULL, NULL, NULL, NULL, NULL);

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

--
-- Structure de la table `formation_eleve`
--

CREATE TABLE IF NOT EXISTS `formation_eleve` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `formation_id` int(11) DEFAULT NULL,
  `eleve_id` int(11) DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `commentaire` longtext COLLATE utf8_unicode_ci,
  `activitesrealisees` longtext COLLATE utf8_unicode_ci,
  `grammaire` longtext COLLATE utf8_unicode_ci,
  `vocabulaire` longtext COLLATE utf8_unicode_ci,
  `phonetique` longtext COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IDX_9A2A9B825200282E` (`formation_id`),
  KEY `IDX_9A2A9B82A6CC7B2` (`eleve_id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `formation_eleve`
--

TRUNCATE TABLE `formation_eleve`;
--
-- Déchargement des données de la table `formation_eleve`
--

INSERT INTO `formation_eleve` (`id`, `formation_id`, `eleve_id`, `active`, `commentaire`, `activitesrealisees`, `grammaire`, `vocabulaire`, `phonetique`) VALUES
(11, 12, 10, 1, NULL, NULL, NULL, NULL, NULL),
(39, 10, 27, 1, NULL, NULL, NULL, NULL, NULL),
(40, 13, 11, 1, NULL, '<hr class=\"ns_separator\" /><p>aaaaa</p><hr class=\"ns_separator\" /><p>aaa</p>', '<hr class=\"ns_separator\" /><p>aaaaa</p><hr class=\"ns_separator\" /><p>aaa</p>', '<hr class=\"ns_separator\" /><p>aaaaa</p><hr class=\"ns_separator\" /><p>aaa</p>', '<hr class=\"ns_separator\" /><p>aaaaa</p><hr class=\"ns_separator\" /><p>aaa</p>'),
(41, 10, 9, 1, NULL, NULL, NULL, NULL, NULL),
(42, 10, 10, 1, NULL, NULL, NULL, NULL, NULL),
(43, 10, 11, 1, NULL, NULL, NULL, NULL, NULL),
(44, 10, 26, 1, NULL, NULL, NULL, NULL, NULL),
(45, 10, 28, 1, NULL, NULL, NULL, NULL, NULL),
(49, 15, 9, 1, NULL, NULL, NULL, NULL, NULL),
(50, 15, 26, 1, NULL, NULL, NULL, NULL, NULL),
(52, 15, 28, 1, NULL, NULL, NULL, NULL, NULL),
(53, 16, 28, 1, NULL, NULL, NULL, NULL, NULL),
(54, 16, 30, 1, NULL, NULL, NULL, NULL, NULL),
(55, 10, 30, 1, NULL, NULL, NULL, NULL, NULL),
(56, 10, 32, 1, NULL, NULL, NULL, NULL, NULL),
(59, 19, 11, 1, NULL, NULL, NULL, NULL, NULL),
(60, 13, 32, 1, NULL, NULL, NULL, NULL, NULL),
(61, 17, 32, 1, NULL, NULL, NULL, NULL, NULL),
(62, 17, 11, 1, NULL, NULL, NULL, NULL, NULL);

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

--
-- Structure de la table `formation_module`
--

CREATE TABLE IF NOT EXISTS `formation_module` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `ordre` int(11) NOT NULL,
  `formation_id` int(11) NOT NULL,
  `module_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_2C3D28055200282E` (`formation_id`),
  KEY `IDX_2C3D2805AFC2B591` (`module_id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `formation_module`
--

TRUNCATE TABLE `formation_module`;
--
-- Déchargement des données de la table `formation_module`
--

INSERT INTO `formation_module` (`id`, `ordre`, `formation_id`, `module_id`) VALUES
(2, 1, 19, 3),
(3, 1, 19, 2),
(4, 1, 13, 4),
(5, 1, 13, 1),
(6, 1, 13, 6),
(7, 1, 19, 6),
(8, 1, 17, 6),
(9, 1, 17, 4),
(10, 1, 13, 7);

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

--
-- Structure de la table `formation_prof`
--

CREATE TABLE IF NOT EXISTS `formation_prof` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `formation_id` int(11) DEFAULT NULL,
  `prof_id` int(11) DEFAULT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `IDX_C6595FB5200282E` (`formation_id`),
  KEY `IDX_C6595FBABC1F7FE` (`prof_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `formation_prof`
--

TRUNCATE TABLE `formation_prof`;
--
-- Déchargement des données de la table `formation_prof`
--

INSERT INTO `formation_prof` (`id`, `formation_id`, `prof_id`, `active`) VALUES
(3, 12, 12, 1),
(6, 11, 14, 1),
(7, 11, 8, 1),
(8, 11, 13, 1),
(10, 10, 8, 1),
(11, 13, 12, 1),
(12, 15, 29, 1),
(13, 16, 8, 1),
(14, 16, 10, 1),
(15, 16, 12, 1),
(16, 16, 14, 1),
(17, 16, 29, 1),
(18, 19, 12, 1),
(19, 17, 12, 1);

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

--
-- Structure de la table `formation_type`
--

CREATE TABLE IF NOT EXISTS `formation_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_DB01B269A4D60759` (`libelle`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `formation_type`
--

TRUNCATE TABLE `formation_type`;
--
-- Déchargement des données de la table `formation_type`
--

INSERT INTO `formation_type` (`id`, `libelle`, `active`) VALUES
(1, 'Cours Visio', 1),
(3, 'Face à Face collectif', 1),
(4, 'IFRASE 2019-20 EJE A', 0),
(5, 'Test Initial IRFASE 2018', 0),
(6, 'test again', 0),
(7, 'School libre', 0),
(8, 'Conversation', 1),
(9, 'Test Initial', 1),
(10, 'Test Final', 1),
(11, 'Démonstration Client', 1),
(12, 'Face à Face individuel', 1);

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

--
-- Structure de la table `groupe`
--

CREATE TABLE IF NOT EXISTS `groupe` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(180) COLLATE utf8_unicode_ci NOT NULL,
  `roles` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_4B98C215E237E06` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `groupe`
--

TRUNCATE TABLE `groupe`;
-- --------------------------------------------------------

--
-- Structure de la table `langue`
--

CREATE TABLE IF NOT EXISTS `langue` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_9357758EA4D60759` (`libelle`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `langue`
--

TRUNCATE TABLE `langue`;
--
-- Déchargement des données de la table `langue`
--

INSERT INTO `langue` (`id`, `libelle`, `active`) VALUES
(15, 'Français', 1),
(16, 'Anglais', 1),
(17, 'Espagnol', 1),
(18, 'Mandarin', 1),
(19, 'Arabe', 1),
(20, 'Hindi', 0),
(21, 'Russe', 1),
(22, 'Bengali', 0),
(23, 'Portugais', 1),
(24, 'Malais', 0),
(25, 'Indonésien', 0),
(26, 'Ourdou', 0),
(27, 'Allemand', 1),
(28, 'Japonais', 1),
(29, 'Italien', 1);

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

--
-- Structure de la table `langue_utilisateur`
--

CREATE TABLE IF NOT EXISTS `langue_utilisateur` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `utilisateur_id` int(11) NOT NULL,
  `langue_id` int(11) NOT NULL,
  `type` varchar(20) COLLATE utf8_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `IDX_EDF270C8FB88E14F` (`utilisateur_id`),
  KEY `IDX_EDF270C82AADBACD` (`langue_id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `langue_utilisateur`
--

TRUNCATE TABLE `langue_utilisateur`;
--
-- Déchargement des données de la table `langue_utilisateur`
--

INSERT INTO `langue_utilisateur` (`id`, `utilisateur_id`, `langue_id`, `type`, `active`) VALUES
(31, 13, 16, 'parlé', 1),
(32, 13, 20, 'parlé', 1),
(33, 13, 16, 'cible', 1),
(34, 13, 19, 'cible', 1),
(54, 8, 16, 'parlé', 1),
(55, 8, 17, 'parlé', 1),
(56, 8, 15, 'parlé', 1),
(57, 8, 27, 'cible', 1),
(58, 9, 15, 'parlé', 1),
(59, 9, 16, 'cible', 1),
(60, 9, 17, 'cible', 1),
(61, 11, 17, 'parlé', 1),
(62, 11, 15, 'parlé', 1),
(63, 11, 16, 'cible', 1),
(64, 32, 16, 'parlé', 1),
(65, 32, 15, 'cible', 1),
(66, 32, 15, 'enseigné', 1),
(67, 24, 19, 'enseigné', 1),
(68, 12, 16, 'parlé', 1),
(69, 12, 15, 'parlé', 1),
(70, 12, 16, 'enseigné', 1),
(71, 25, 16, 'enseigné', 1);

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

--
-- Structure de la table `lecon`
--

CREATE TABLE IF NOT EXISTS `lecon` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `origine_id` int(11) DEFAULT NULL,
  `proprietaire_id` int(11) DEFAULT NULL,
  `langue_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_94E6242E87998E` (`origine_id`),
  KEY `IDX_94E6242E76C50E4A` (`proprietaire_id`),
  KEY `IDX_94E6242E2AADBACD` (`langue_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `lecon`
--

TRUNCATE TABLE `lecon`;
--
-- Déchargement des données de la table `lecon`
--

INSERT INTO `lecon` (`id`, `libelle`, `origine_id`, `proprietaire_id`, `langue_id`) VALUES
(1, 'Leçon 1', NULL, NULL, 16),
(2, 'All over the Word', NULL, NULL, 16),
(3, '', NULL, NULL, 16),
(4, 'TEST', NULL, NULL, 16),
(5, '', NULL, NULL, 16),
(6, 'Lecon de démonstration', NULL, NULL, 16),
(7, 'Lecon 2', NULL, NULL, 16),
(8, 'Lecon Octobre', NULL, NULL, 16),
(9, 'Lecon Novembre', NULL, NULL, 16),
(10, 'Lecon Decembre', NULL, NULL, 16),
(11, '', NULL, NULL, 16),
(12, 'Leçon de débutant', NULL, NULL, 16),
(13, 'Lecon de test', NULL, NULL, 16);

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

--
-- Structure de la table `lecon_activite`
--

CREATE TABLE IF NOT EXISTS `lecon_activite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lecon_id` int(11) NOT NULL,
  `activite_id` int(11) NOT NULL,
  `ordre` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_473DE290EC1308A5` (`lecon_id`),
  KEY `IDX_473DE2909B0F88B1` (`activite_id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `lecon_activite`
--

TRUNCATE TABLE `lecon_activite`;
--
-- Déchargement des données de la table `lecon_activite`
--

INSERT INTO `lecon_activite` (`id`, `lecon_id`, `activite_id`, `ordre`) VALUES
(1, 1, 19, 0),
(3, 2, 26, 2),
(4, 2, 4, 1),
(5, 3, 5, 0),
(6, 3, 6, 1),
(7, 3, 7, 2),
(8, 4, 11, 1),
(9, 2, 8, 2),
(10, 2, 27, 3),
(11, 1, 12, 2),
(12, 7, 14, 0),
(13, 8, 15, 0),
(14, 8, 16, 1),
(15, 9, 17, 0),
(16, 2, 16, 5),
(17, 11, 20, 0),
(18, 11, 21, 1),
(19, 12, 22, 0),
(21, 12, 24, 3),
(22, 13, 25, 0);

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

--
-- Structure de la table `lecon_exercice`
--

CREATE TABLE IF NOT EXISTS `lecon_exercice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lecon_id` int(11) NOT NULL,
  `exercice_id` int(11) NOT NULL,
  `ordre` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_1B5070C8EC1308A5` (`lecon_id`),
  KEY `IDX_1B5070C889D40298` (`exercice_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `lecon_exercice`
--

TRUNCATE TABLE `lecon_exercice`;
-- --------------------------------------------------------

--
-- Structure de la table `media`
--

CREATE TABLE IF NOT EXISTS `media` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `categorie_id` int(11) DEFAULT NULL,
  `ordre` int(11) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `libelle` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `texte` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
  `fichier` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `motclef` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
  `type` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
  `codeintegration` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
  `auteur_id` int(11) DEFAULT NULL,
  `datecreation` datetime NOT NULL,
  `datemodification` datetime NOT NULL,
  `source` varchar(512) COLLATE utf8_unicode_ci DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_6A2CA10CBCF5E72D` (`categorie_id`),
  KEY `IDX_6A2CA10C60BB6FE6` (`auteur_id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `media`
--

TRUNCATE TABLE `media`;
--
-- Déchargement des données de la table `media`
--

INSERT INTO `media` (`id`, `categorie_id`, `ordre`, `active`, `libelle`, `texte`, `fichier`, `motclef`, `type`, `codeintegration`, `auteur_id`, `datecreation`, `datemodification`, `source`) VALUES
(1, 3, 0, 1, 'Comment conduire une moto ?', 'Comment conduire une moto ?', NULL, 'Tuto, moto, apprendre, sport', 'vidéo', '<iframe width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/xFOJN8kaEE0\" frameborder=\"0\" allow=\"autoplay; encrypted-media\" allowfullscreen></iframe>', 25, '2018-09-27 12:23:40', '2018-09-27 12:31:36', NULL),
(2, 4, 0, 1, 'Voiture bleue', 'Voiture bleue', '676bed268a8687938c74847d739801f9.jpeg', 'voiture, bleue, sport, bmw', 'image', NULL, 25, '2018-09-27 12:30:58', '2018-09-27 12:30:58', NULL),
(3, 10, 0, 1, 'Wu-Tang-Forever.jpg', NULL, '0c9b9638d629b59bbcf6caa6eb81ed17.jpeg', NULL, 'image', NULL, 31, '2018-10-07 17:48:00', '2018-10-07 17:48:00', NULL),
(4, 2, 0, 1, 'objets de toilette', 'creative commons', '2d3b4f903b3c192f8a3e870a328d96a9.jpeg', 'brosse à dents', 'image', NULL, 31, '2018-10-08 10:55:58', '2018-10-08 10:55:58', NULL),
(5, 17, 0, 1, 'Desree  Life.mp3', NULL, '70eb4a4799e157378cd49d848f32339f.mpga', 'musique', 'son', NULL, 12, '2018-10-12 15:29:43', '2018-10-12 15:29:43', NULL),
(6, 17, 0, 1, 'BOLERO - Ravel.mp3', NULL, 'abbb50d798330a2902e28c987f2e2235.mpga', 'musique', 'son', NULL, 12, '2018-10-12 15:31:12', '2018-10-12 16:13:11', NULL),
(7, 10, 0, 1, 'Love & Arthur Lee - Everybody\'s Gotta Live.mp3', 'nouvel essai avec un mp3 dont le mimetype n\'était pas reconnu', 'eac710ace34ddf31b195edaccc8303ac.mp3', NULL, 'son', NULL, 25, '2018-10-12 17:17:02', '2018-10-12 17:17:02', NULL),
(8, 3, 0, 1, 'Moto', 'Superbe moto bleue', 'aaf7e36c1451f4ef1ba0d9cd6c9c06ab.jpeg', 'moto, bleu, course', 'image', NULL, 25, '2018-10-23 11:16:16', '2018-10-23 11:16:16', NULL),
(9, 19, 0, 0, 'ROME3.mp3', NULL, '4730fad5b36754aea77b1cca85229558.mp3', NULL, 'son', NULL, 12, '2018-11-02 14:40:25', '2018-11-02 14:40:25', NULL),
(10, 19, 0, 1, 'SampleVideo_1280x720_1mb.mp4', NULL, '11bfeac972a2614d95e2779aa1fb631d.mp4', NULL, 'vidéo', NULL, 12, '2018-11-02 14:50:07', '2018-11-02 14:50:07', NULL),
(11, 29, 0, 1, 'Superbe Montagne', 'Superbe Montagne des Alpes', 'c094c3e1aed7e31c82df243f894270f4.jpg', 'montagne, neige, A0, A1, A2', 'image', NULL, 25, '2018-11-06 11:36:55', '2018-11-06 11:38:37', NULL),
(12, 30, 0, 1, 'Plage', 'Plage', '5daf66fbf5c468c3941c61fa5e67f23c.jpg', 'plage, sable', 'image', NULL, 25, '2018-11-06 11:37:46', '2018-11-06 11:37:46', NULL),
(13, 30, 0, 1, 'Plage landaises', NULL, '5c104164d1cfdefa5f8a36d52475b85a.jpg', 'Landes, 40, Sable, Plage', 'image', NULL, 12, '2018-11-06 11:40:08', '2018-11-06 11:40:42', NULL),
(14, 30, 0, 1, 'BigBuckBunny_320x180.mp4', 'essai mp4', '6715a72c20cc9f6a6ed21019b218fdbf.mp4', NULL, 'vidéo', NULL, 25, '2018-11-12 17:12:06', '2018-11-12 17:12:06', NULL),
(15, 19, 0, 1, 'Sample Son', 'Sample Son', '13449aa52d206eb0828c1b6b1b358aeb.mp3', 'Sample Son', 'son', NULL, 25, '2018-11-16 10:08:35', '2018-11-16 10:08:35', 'https://www.sample-videos.com/download-sample-audio.php'),
(16, 19, 0, 1, 'ROME1.mp3', NULL, 'ee7b17562572d716ee994e3b0537a38a.mp3', NULL, 'son', NULL, 12, '2018-11-16 10:27:27', '2018-11-16 10:27:27', NULL),
(17, 31, 0, 1, 'Test trailer', 'Test trailer', '82786902193929ebf7397fd9be9dd4c4.mp3', 'Test trailer', 'son', NULL, 25, '2018-11-16 11:34:33', '2018-11-16 11:34:33', 'NG');

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

--
-- Structure de la table `media_categorie`
--

CREATE TABLE IF NOT EXISTS `media_categorie` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `ordre` int(11) NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `libelle` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_6C1D65BA727ACA70` (`parent_id`)
) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `media_categorie`
--

TRUNCATE TABLE `media_categorie`;
--
-- Déchargement des données de la table `media_categorie`
--

INSERT INTO `media_categorie` (`id`, `parent_id`, `ordre`, `active`, `libelle`) VALUES
(1, NULL, 0, 1, 'Véhicules'),
(2, NULL, 0, 1, 'Pièces - Rooms'),
(3, 1, 0, 1, '2 Roues'),
(4, 1, 0, 1, '4 Roues'),
(5, 3, 0, 1, '12 roues'),
(6, 1, 0, 1, '13 roues'),
(7, 1, 0, 1, '3 roues'),
(8, 1, 0, 1, '5 roues'),
(9, 1, 0, 1, 'a roues'),
(10, 1, 0, 1, '0 roue'),
(11, 1, 0, 1, '0.1 roue'),
(12, 1, 0, 1, '0.2 roues'),
(13, 1, 0, 1, '0.3 roues'),
(14, 2, 0, 1, 'Cuisine'),
(15, 2, 0, 1, 'Chambre'),
(16, 2, 0, 1, 'Salle de bain'),
(17, 2, 0, 1, 'Extérieur'),
(18, NULL, 0, 1, 'Chanson'),
(19, 18, 0, 1, 'ELO'),
(20, 18, 0, 1, 'ELO'),
(21, 2, 0, 1, 'Cuisine'),
(22, 1, 0, 1, 'car'),
(23, 2, 0, 1, 'odile'),
(24, 15, 0, 1, 'Lit'),
(25, 14, 0, 1, 'GAZINIERE'),
(26, 15, 0, 1, 'TableDeChevet'),
(27, NULL, 0, 1, 'Bande-Annonce'),
(28, NULL, 0, 1, 'Paysage'),
(29, 28, 0, 1, 'Montagne'),
(30, 28, 0, 1, 'Plage'),
(31, 27, 0, 1, 'Trailer'),
(32, 28, 0, 1, 'Ville');

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

--
-- Structure de la table `module`
--

CREATE TABLE IF NOT EXISTS `module` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `langue_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_C2426282AADBACD` (`langue_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `module`
--

TRUNCATE TABLE `module`;
--
-- Déchargement des données de la table `module`
--

INSERT INTO `module` (`id`, `libelle`, `active`, `langue_id`) VALUES
(1, 'Module de test', 1, 16),
(2, 'ELO', 1, 16),
(3, 'SAUCISSE SECHE', 1, 16),
(4, 'Module 20181023', 1, 16),
(5, 'social work', 1, 16),
(6, '20181106', 1, 16),
(7, 'testscript', 1, 16);

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

--
-- Structure de la table `module_lecon`
--

CREATE TABLE IF NOT EXISTS `module_lecon` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lecon_id` int(11) NOT NULL,
  `module_id` int(11) NOT NULL,
  `ordre` int(11) NOT NULL,
  `retry` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  KEY `IDX_9DEA5440EC1308A5` (`lecon_id`),
  KEY `IDX_9DEA5440AFC2B591` (`module_id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `module_lecon`
--

TRUNCATE TABLE `module_lecon`;
--
-- Déchargement des données de la table `module_lecon`
--

INSERT INTO `module_lecon` (`id`, `lecon_id`, `module_id`, `ordre`, `retry`) VALUES
(1, 1, 1, 0, 1),
(2, 2, 2, 0, 1),
(3, 3, 2, 1, 1),
(5, 5, 2, 2, 1),
(6, 6, 2, 3, 1),
(7, 7, 1, 1, 1),
(8, 2, 3, 1, 1),
(9, 8, 4, 0, 1),
(10, 9, 4, 1, 1),
(11, 11, 5, 0, 1),
(12, 12, 6, 0, 1),
(13, 13, 7, 0, 1);

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

--
-- Structure de la table `nationalite`
--

CREATE TABLE IF NOT EXISTS `nationalite` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_9EC4D73FA4D60759` (`libelle`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `nationalite`
--

TRUNCATE TABLE `nationalite`;
--
-- Déchargement des données de la table `nationalite`
--

INSERT INTO `nationalite` (`id`, `libelle`, `active`) VALUES
(16, 'Francais(e)', 1),
(17, 'Anglais(e)', 1),
(18, 'Espagnol(e)', 1),
(19, 'Allemand(e)', 1),
(20, 'Serbo Croate', 0),
(21, 'Écossais/e', 1);

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

--
-- Structure de la table `niveau`
--

CREATE TABLE IF NOT EXISTS `niveau` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_4BDFF36BA4D60759` (`libelle`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `niveau`
--

TRUNCATE TABLE `niveau`;
--
-- Déchargement des données de la table `niveau`
--

INSERT INTO `niveau` (`id`, `libelle`, `active`) VALUES
(50, 'A0', 1),
(51, 'A1', 1),
(52, 'A2', 1),
(53, 'B1', 1),
(54, 'B2', 1),
(55, 'C1', 1),
(56, 'C2', 1),
(57, 'A1+', 1),
(58, 'C1-', 0),
(59, 'Débutant', 0),
(60, 'A2+', 1),
(61, 'B1+', 1);

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

--
-- Structure de la table `pays`
--

CREATE TABLE IF NOT EXISTS `pays` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_349F3CAEA4D60759` (`libelle`)
) ENGINE=InnoDB AUTO_INCREMENT=1013 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `pays`
--

TRUNCATE TABLE `pays`;
--
-- Déchargement des données de la table `pays`
--

INSERT INTO `pays` (`id`, `libelle`, `active`) VALUES
(760, 'Afghanistan', 1),
(761, 'Afrique du Sud', 1),
(762, 'Albanie', 1),
(763, 'Algérie', 1),
(764, 'Allemagne', 1),
(765, 'Andorre', 1),
(766, 'Angola', 1),
(767, 'Anguilla', 0),
(768, 'Antarctique', 0),
(769, 'Antigua-et-Barbuda', 0),
(770, 'Arabie saoudite', 1),
(771, 'Argentine', 1),
(772, 'Arménie', 1),
(773, 'Aruba', 0),
(774, 'Australie', 1),
(775, 'Autriche', 1),
(776, 'Azerbaïdjan', 1),
(777, 'Bahamas', 1),
(778, 'Bahreïn', 1),
(779, 'Bangladesh', 1),
(780, 'Barbade', 0),
(781, 'Belgique', 1),
(782, 'Belize', 0),
(783, 'Bénin', 1),
(784, 'Bermudes', 0),
(785, 'Bhoutan', 0),
(786, 'Biélorussie', 1),
(787, 'Bolivie', 1),
(788, 'Bosnie-Herzégovine', 1),
(789, 'Botswana', 1),
(790, 'Brésil', 1),
(791, 'Brunéi Darussalam', 1),
(792, 'Bulgarie', 1),
(793, 'Burkina Faso', 1),
(794, 'Burundi', 1),
(795, 'Cambodge', 1),
(796, 'Cameroun', 1),
(797, 'Canada', 1),
(798, 'Cap-Vert', 1),
(799, 'Ceuta et Melilla', 0),
(800, 'Chili', 1),
(801, 'Chine', 1),
(802, 'Chypre', 1),
(803, 'Colombie', 1),
(804, 'Comores', 1),
(805, 'Congo-Brazzaville', 1),
(806, 'Congo-Kinshasa', 1),
(807, 'Corée du Nord', 1),
(808, 'Corée du Sud', 1),
(809, 'Costa Rica', 1),
(810, 'Côte d’Ivoire', 1),
(811, 'Croatie', 1),
(812, 'Cuba', 1),
(813, 'Curaçao', 1),
(814, 'Danemark', 1),
(815, 'Diego Garcia', 0),
(816, 'Djibouti', 1),
(817, 'Dominique', 1),
(818, 'Égypte', 1),
(819, 'El Salvador', 1),
(820, 'Émirats arabes unis', 1),
(821, 'Équateur', 1),
(822, 'Érythrée', 0),
(823, 'Espagne', 1),
(824, 'Estonie', 1),
(825, 'État de la Cité du Vatican', 0),
(826, 'États fédérés de Micronésie', 0),
(827, 'États-Unis', 1),
(828, 'Éthiopie', 1),
(829, 'Fidji', 0),
(830, 'Finlande', 1),
(831, 'France', 1),
(832, 'Gabon', 1),
(833, 'Gambie', 1),
(834, 'Géorgie', 1),
(835, 'Ghana', 1),
(836, 'Gibraltar', 1),
(837, 'Grèce', 1),
(838, 'Grenade', 0),
(839, 'Groenland', 1),
(840, 'Guadeloupe', 1),
(841, 'Guam', 0),
(842, 'Guatemala', 1),
(843, 'Guernesey', 1),
(844, 'Guinée', 1),
(845, 'Guinée équatoriale', 1),
(846, 'Guinée-Bissau', 1),
(847, 'Guyana', 1),
(848, 'Guyane française', 1),
(849, 'Haïti', 1),
(850, 'Honduras', 1),
(851, 'Hongrie', 1),
(852, 'Île Christmas', 0),
(853, 'Île de l’Ascension', 0),
(854, 'Île de Man', 0),
(855, 'Île Norfolk', 0),
(856, 'Îles Åland', 0),
(857, 'Îles Caïmans', 0),
(858, 'Îles Canaries', 1),
(859, 'Îles Cocos', 0),
(860, 'Îles Cook', 0),
(861, 'Îles Féroé', 0),
(862, 'Îles Géorgie du Sud et Sandwich du Sud', 0),
(863, 'Îles Malouines', 1),
(864, 'Îles Mariannes du Nord', 0),
(865, 'Îles Marshall', 0),
(866, 'Îles mineures éloignées des États-Unis', 0),
(867, 'Îles Salomon', 1),
(868, 'Îles Turques-et-Caïques', 0),
(869, 'Îles Vierges britanniques', 0),
(870, 'Îles Vierges des États-Unis', 0),
(871, 'Inde', 1),
(872, 'Indonésie', 1),
(873, 'Irak', 1),
(874, 'Iran', 1),
(875, 'Irlande', 1),
(876, 'Islande', 1),
(877, 'Israël', 1),
(878, 'Italie', 1),
(879, 'Jamaïque', 1),
(880, 'Japon', 1),
(881, 'Jersey', 1),
(882, 'Jordanie', 1),
(883, 'Kazakhstan', 1),
(884, 'Kenya', 1),
(885, 'Kirghizistan', 1),
(886, 'Kiribati', 1),
(887, 'Kosovo', 1),
(888, 'Koweït', 1),
(889, 'La Réunion', 1),
(890, 'Laos', 1),
(891, 'Lesotho', 1),
(892, 'Lettonie', 1),
(893, 'Liban', 1),
(894, 'Libéria', 1),
(895, 'Libye', 1),
(896, 'Liechtenstein', 1),
(897, 'Lituanie', 1),
(898, 'Luxembourg', 1),
(899, 'Macédoine', 1),
(900, 'Madagascar', 1),
(901, 'Malaisie', 1),
(902, 'Malawi', 1),
(903, 'Maldives', 1),
(904, 'Mali', 1),
(905, 'Malte', 1),
(906, 'Maroc', 1),
(907, 'Martinique', 1),
(908, 'Maurice', 1),
(909, 'Mauritanie', 1),
(910, 'Mayotte', 1),
(911, 'Mexique', 1),
(912, 'Moldavie', 1),
(913, 'Monaco', 1),
(914, 'Mongolie', 1),
(915, 'Monténégro', 1),
(916, 'Montserrat', 1),
(917, 'Mozambique', 1),
(918, 'Myanmar', 1),
(919, 'Namibie', 1),
(920, 'Nauru', 1),
(921, 'Népal', 1),
(922, 'Nicaragua', 1),
(923, 'Niger', 1),
(924, 'Nigéria', 1),
(925, 'Niue', 1),
(926, 'Norvège', 1),
(927, 'Nouvelle-Calédonie', 1),
(928, 'Nouvelle-Zélande', 1),
(929, 'Oman', 1),
(930, 'Ouganda', 1),
(931, 'Ouzbékistan', 1),
(932, 'Pakistan', 1),
(933, 'Palaos', 1),
(934, 'Panama', 1),
(935, 'Papouasie-Nouvelle-Guinée', 1),
(936, 'Paraguay', 1),
(937, 'Pays-Bas', 1),
(938, 'Pays-Bas caribéens', 0),
(939, 'Pérou', 1),
(940, 'Philippines', 1),
(941, 'Pitcairn', 1),
(942, 'Pologne', 1),
(943, 'Polynésie française', 1),
(944, 'Porto Rico', 1),
(945, 'Portugal', 1),
(946, 'Qatar', 1),
(947, 'R.A.S. chinoise de Hong Kong', 1),
(948, 'R.A.S. chinoise de Macao', 1),
(949, 'République centrafricaine', 1),
(950, 'République dominicaine', 1),
(951, 'République tchèque', 1),
(952, 'Roumanie', 1),
(953, 'Royaume-Uni', 1),
(954, 'Russie', 1),
(955, 'Rwanda', 1),
(956, 'Sahara occidental', 0),
(957, 'Saint-Barthélemy', 1),
(958, 'Saint-Christophe-et-Niévès', 1),
(959, 'Saint-Marin', 1),
(960, 'Saint-Martin (partie française)', 1),
(961, 'Saint-Martin (partie néerlandaise)', 0),
(962, 'Saint-Pierre-et-Miquelon', 1),
(963, 'Saint-Vincent-et-les-Grenadines', 1),
(964, 'Sainte-Hélène', 1),
(965, 'Sainte-Lucie', 1),
(966, 'Samoa', 1),
(967, 'Samoa américaines', 0),
(968, 'Sao Tomé-et-Principe', 1),
(969, 'Sénégal', 1),
(970, 'Serbie', 1),
(971, 'Seychelles', 1),
(972, 'Sierra Leone', 1),
(973, 'Singapour', 1),
(974, 'Slovaquie', 1),
(975, 'Slovénie', 1),
(976, 'Somalie', 1),
(977, 'Soudan', 1),
(978, 'Soudan du Sud', 1),
(979, 'Sri Lanka', 1),
(980, 'Suède', 1),
(981, 'Suisse', 1),
(982, 'Suriname', 1),
(983, 'Svalbard et Jan Mayen', 0),
(984, 'Swaziland', 1),
(985, 'Syrie', 1),
(986, 'Tadjikistan', 1),
(987, 'Taïwan', 1),
(988, 'Tanzanie', 1),
(989, 'Tchad', 1),
(990, 'Terres australes françaises', 0),
(991, 'Territoire britannique de l’océan Indien', 0),
(992, 'Territoires palestiniens', 1),
(993, 'Thaïlande', 1),
(994, 'Timor oriental', 1),
(995, 'Togo', 1),
(996, 'Tokelau', 0),
(997, 'Tonga', 0),
(998, 'Trinité-et-Tobago', 1),
(999, 'Tristan da Cunha', 0),
(1000, 'Tunisie', 1),
(1001, 'Turkménistan', 1),
(1002, 'Turquie', 1),
(1003, 'Tuvalu', 0),
(1004, 'Ukraine', 1),
(1005, 'Uruguay', 1),
(1006, 'Vanuatu', 1),
(1007, 'Venezuela', 1),
(1008, 'Vietnam', 1),
(1009, 'Wallis-et-Futuna', 1),
(1010, 'Yémen', 1),
(1011, 'Zambie', 1),
(1012, 'Zimbabwe', 1);

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

--
-- Structure de la table `reponse`
--

CREATE TABLE IF NOT EXISTS `reponse` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `jsonContent` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `exercice_id` int(11) NOT NULL,
  `note` varchar(15) COLLATE utf8_unicode_ci NOT NULL,
  `eleve_tentative_id` int(11) NOT NULL,
  `succes` tinyint(1) NOT NULL,
  `commentaire` varchar(280) COLLATE utf8_unicode_ci DEFAULT NULL,
  `jsonContentCorrection` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  `jsonContentCorrect` varchar(500) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_5FB6DEC789D40298` (`exercice_id`),
  KEY `IDX_5FB6DEC76FB42672` (`eleve_tentative_id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `reponse`
--

TRUNCATE TABLE `reponse`;
--
-- Déchargement des données de la table `reponse`
--

INSERT INTO `reponse` (`id`, `jsonContent`, `exercice_id`, `note`, `eleve_tentative_id`, `succes`, `commentaire`, `jsonContentCorrection`, `jsonContentCorrect`) VALUES
(1, '[[\"media_id_12\",\"<p>beach<\\/p>\"],[\"media_id_11\",\"<p>moutain<\\/p>\"]]', 153, '2/2', 1, 1, NULL, '[[\"media_id_12\",\"<p>beach<\\/p>\"],[\"media_id_11\",\"<p>moutain<\\/p>\"]]', ''),
(2, '{\"reponse\":\"\"}', 129, '', 1, 0, NULL, '{\"reponse\":\"\"}', ''),
(3, '{\"1\":[\"2\"]}', 143, '0/1', 1, 0, NULL, '{\"1\":[\"2\"]}', ''),
(4, '{\"1\":[\"1\"]}', 143, '1/1', 3, 1, NULL, '{\"1\":[\"1\"]}', ''),
(5, '[[\"media_id_12\",\"<p>beach<\\/p>\"],[\"media_id_11\",\"<p>moutain<\\/p>\"]]', 153, '2/2', 3, 1, NULL, '[[\"media_id_12\",\"<p>beach<\\/p>\"],[\"media_id_11\",\"<p>moutain<\\/p>\"]]', ''),
(6, '{\"reponse\":\"Moi\"}', 129, 'effectué', 3, 1, NULL, '{\"reponse\":\"<p>M<span id=\\\"mce_3\\\" class=\\\"ns_correction_prof\\\">iy<\\/span>oi<span id=\\\"mce_4\\\" class=\\\"ns_correction_prof\\\">iuy<\\/span><\\/p>\"}', ''),
(7, '[[\"media_id_2\",\"<p>Moto<\\/p>\"]]', 144, '0/2', 5, 0, NULL, '[[\"media_id_2\",\"<p>Moto<\\/p>\"]]', ''),
(8, '{\"1\":\"texte\",\"2\":\"test\"}', 145, '2/2', 5, 1, NULL, '{\"1\":\"texte\",\"2\":\"test\"}', ''),
(9, '{\"1\":[\"3\"]}', 143, '0/1', 5, 0, NULL, '{\"1\":[\"3\"]}', ''),
(10, '[[\"media_id_2\",\"<p>Voiture<\\/p>\"],[\"media_id_8\",\"<p>Moto<\\/p>\"]]', 144, '2/2', 9, 1, NULL, '[[\"media_id_2\",\"<p>Voiture<\\/p>\"],[\"media_id_8\",\"<p>Moto<\\/p>\"]]', ''),
(11, '{\"1\":\"texte\",\"2\":\"\"}', 145, '1/2', 9, 0, NULL, '{\"1\":\"texte\",\"2\":\"\"}', ''),
(12, '[]', 143, '0/1', 9, 0, NULL, '[]', ''),
(13, '[]', 144, '0/2', 10, 0, NULL, '[]', ''),
(14, '{\"1\":\"\",\"2\":\"\"}', 145, '0/2', 10, 0, NULL, '{\"1\":\"\",\"2\":\"\"}', ''),
(15, '[]', 143, '0/1', 10, 0, NULL, '[]', ''),
(16, '{\"1\":\"texte\",\"2\":\"test\"}', 145, '2/2', 11, 1, NULL, '{\"1\":\"texte\",\"2\":\"test\"}', ''),
(17, '[[\"media_id_2\",\"<p>Voiture<\\/p>\"]]', 144, '1/2', 11, 0, NULL, '[[\"media_id_2\",\"<p>Voiture<\\/p>\"]]', ''),
(18, '{\"1\":[\"1\"]}', 143, '1/1', 11, 1, NULL, '{\"1\":[\"1\"]}', ''),
(19, '[[\"media_id_2\",\"<p>Voiture<\\/p>\"],[\"media_id_8\",\"<p>Moto<\\/p>\"]]', 144, '2/2', 13, 1, NULL, '[[\"media_id_2\",\"<p>Voiture<\\/p>\"],[\"media_id_8\",\"<p>Moto<\\/p>\"]]', ''),
(20, '{\"1\":\"texte\",\"2\":\"\"}', 145, '1/2', 13, 0, NULL, '{\"1\":\"texte\",\"2\":\"\"}', ''),
(21, '{\"1\":[\"1\"]}', 143, '1/1', 13, 1, NULL, '{\"1\":[\"1\"]}', ''),
(22, '{\"reponse\":\"Nicolas, I say!\"}', 129, 'effectué', 18, 1, NULL, '{\"reponse\":\"<p>Nicolas<em>, I say!&nbsp;<span id=\\\"mce_3\\\" class=\\\"ns_correction_prof\\\">&lt;-no<\\/span><\\/em><\\/p>\"}', '{\"reponse\":\"Nicolas, I say!\"}'),
(23, '{\"1\":\"Cooked cheeses\",\"2\":\"firmer and softer\",\"3\":\"raw cheeses\",\"4\":\"\",\"5\":\"\"}', 138, '3/5', 17, 0, NULL, '{\"1\":\"Cooked cheeses\",\"2\":\"firmer and softer\",\"3\":\"raw cheeses\",\"4\":\"\",\"5\":\"\"}', '{\"1\":\"Cooked cheeses\",\"2\":\"firmer and softer\",\"3\":\"raw cheeses\"}'),
(24, '[[\"media_id_5\",\"<p>Life<\\/p>\"],[\"media_id_6\",\"<p>Bolero<\\/p>\"]]', 148, '2/3', 17, 0, NULL, '[[\"media_id_5\",\"<p>Life<\\/p>\"],[\"media_id_6\",\"<p>Bolero<\\/p>\"]]', '[[\"media_id_5\",\"<p>Life<\\/p>\"],[\"media_id_6\",\"<p>Bolero<\\/p>\"]]'),
(25, '[[\"<p>Nuire<\\/p>\",\"<p>Damage<\\/p>\"],[\"<p>Dette<\\/p>\",\"<p>Debt<\\/p>\"],[\"<p>Boite de nuit<\\/p>\",\"<p>Nightclub<\\/p>\"]]', 130, '3/3', 17, 1, NULL, '[[\"<p>Nuire<\\/p>\",\"<p>Damage<\\/p>\"],[\"<p>Dette<\\/p>\",\"<p>Debt<\\/p>\"],[\"<p>Boite de nuit<\\/p>\",\"<p>Nightclub<\\/p>\"]]', '[[\"<p>Nuire<\\/p>\",\"<p>Damage<\\/p>\"],[\"<p>Dette<\\/p>\",\"<p>Debt<\\/p>\"],[\"<p>Boite de nuit<\\/p>\",\"<p>Nightclub<\\/p>\"]]'),
(26, '{\"1\":\"\"}', 133, '1/1', 17, 1, NULL, '{\"1\":\"\"}', '{\"1\":\"\"}'),
(27, '{\"1\":\"responsibilities\",\"2\":\"write\"}', 132, '2/2', 18, 1, NULL, '{\"1\":\"responsibilities\",\"2\":\"write\"}', '{\"1\":\"responsibilities\",\"2\":\"write\"}'),
(28, '[[\"<p>flower<\\/p>\",\"<p>tulip<\\/p>\"]]', 134, '1/1', 18, 1, NULL, '[[\"<p>flower<\\/p>\",\"<p>tulip<\\/p>\"]]', '[[\"<p>flower<\\/p>\",\"<p>tulip<\\/p>\"]]');

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

--
-- Structure de la table `type_exercice`
--

CREATE TABLE IF NOT EXISTS `type_exercice` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `libelle` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `active` tinyint(1) NOT NULL DEFAULT '1',
  `logohtml` varchar(128) COLLATE utf8_unicode_ci DEFAULT NULL,
  `accrochable` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_29E7E0B1A4D60759` (`libelle`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `type_exercice`
--

TRUNCATE TABLE `type_exercice`;
INSERT INTO `type_exercice` (`id`, `libelle`, `active`, `logohtml`, `accrochable`) VALUES
(1, 'QCM', 1, '<i class="fa fa-question fa-lg fa-fw mx-2 logoComposant" aria-hidden="true" style="color:#9e9e9e;" title="Multiple Choice"></i>', 1),
(2, 'Texte à trous - Click & click', 1, '<i class="fa fa-wrench fa-lg fa-fw mx-2 logoComposant" aria-hidden="true" style="color:#9e9e9e;" title="Gap Fill - Select & Drop"></i>', 1),
(3, 'Texte à trous - Compléter', 1, '<i class="fa fa-wrench fa-lg fa-fw mx-2 logoComposant" aria-hidden="true" style="color:#9e9e9e;" title="Gap Fill - Write"></i>', 1),
(4, 'Association', 1, '<i class="fa fa-link fa-lg fa-fw mx-2 logoComposant" aria-hidden="true" style="color:#9e9e9e;" title="Association"></i>', 0),
(5, 'Question Ouverte', 1, '<i class="fa fa-pencil fa-lg fa-fw mx-2 logoComposant" aria-hidden="true" style="color:#9e9e9e;" title="Open Question"></i>', 1),
(6, 'Point Grammaire', 1, '<i class="fa fa-info-circle fa-lg fa-fw mx-2 logoComposant" aria-hidden="true" style="color:#9e9e9e;" title="Point Grammaire"></i>', 0),
(7, 'Point Vocabulaire', 1, '<i class="fa fa-info-circle fa-lg fa-fw mx-2 logoComposant" aria-hidden="true" style="color:#9e9e9e;" title="Point Vocabulaire"></i>', 0),
(8, 'Texte', 1, '<i class="fa fa-info-circle fa-lg fa-fw mx-2 logoComposant" aria-hidden="true" style="color:#9e9e9e;" title="Texte"></i>', 1),
(9, 'Consigne', 0, '<i class="fa fa-exclamation-circle fa-lg fa-fw mx-2 logoComposant" aria-hidden="true" title="Consigne"></i>', 1),
(10, 'Son', 1, '<i class="fa fa-headphones fa-lg fa-fw mx-2 logoComposant" aria-hidden="true" style="color:#9e9e9e;" title="Son"></i>', 1),
(11, 'Vidéo', 1, '<i class="fa fa-video-camera fa-lg fa-fw mx-2 logoComposant" aria-hidden="true" style="color:#9e9e9e;" title="Vidéo"></i>', 0),
(12, 'Image', 1, '<i class="fa fa-camera fa-lg fa-fw mx-2 logoComposant" aria-hidden="true" style="color:#9e9e9e;" title="Image"></i>', 0),
(13, 'Transcript', 1, '<i class="fa fa-question-circle fa-lg fa-fw mx-2 logoComposant" aria-hidden="true"></i>', 1);

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

--
-- Structure de la table `utilisateur_groupe`
--

CREATE TABLE IF NOT EXISTS `utilisateur_groupe` (
  `utilisateur_id` int(11) NOT NULL,
  `groupe_id` int(11) NOT NULL,
  PRIMARY KEY (`utilisateur_id`,`groupe_id`),
  KEY `IDX_6514B6AAFB88E14F` (`utilisateur_id`),
  KEY `IDX_6514B6AA7A45358C` (`groupe_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `utilisateur_groupe`
--

TRUNCATE TABLE `utilisateur_groupe`;
-- --------------------------------------------------------

--
-- Structure de la table `utilisateur_nationalite`
--

CREATE TABLE IF NOT EXISTS `utilisateur_nationalite` (
  `utilisateur_id` int(11) NOT NULL,
  `nationalite_id` int(11) NOT NULL,
  PRIMARY KEY (`utilisateur_id`,`nationalite_id`),
  KEY `IDX_6A22DAACFB88E14F` (`utilisateur_id`),
  KEY `IDX_6A22DAAC1B063272` (`nationalite_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Tronquer la table avant d'insérer `utilisateur_nationalite`
--

TRUNCATE TABLE `utilisateur_nationalite`;
--
-- Déchargement des données de la table `utilisateur_nationalite`
--

INSERT INTO `utilisateur_nationalite` (`utilisateur_id`, `nationalite_id`) VALUES
(8, 16),
(9, 16),
(10, 16),
(10, 19),
(11, 16),
(12, 16),
(13, 18),
(14, 16),
(24, 16),
(25, 16),
(26, 16),
(26, 17),
(27, 19),
(28, 16),
(29, 16),
(30, 20),
(31, 16),
(32, 17),
(33, 16);

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

--
-- Contraintes pour la table `activite`
--
ALTER TABLE `activite`
  ADD CONSTRAINT `FK_B87555152AADBACD` FOREIGN KEY (`langue_id`) REFERENCES `langue` (`id`),
  ADD CONSTRAINT `FK_B875551576C50E4A` FOREIGN KEY (`proprietaire_id`) REFERENCES `utilisateur` (`id`),
  ADD CONSTRAINT `FK_B875551587998E` FOREIGN KEY (`origine_id`) REFERENCES `activite` (`id`);

--
-- Contraintes pour la table `activite_exercice`
--
ALTER TABLE `activite_exercice`
  ADD CONSTRAINT `FK_7980162589D40298` FOREIGN KEY (`exercice_id`) REFERENCES `exercice` (`id`),
  ADD CONSTRAINT `FK_798016259B0F88B1` FOREIGN KEY (`activite_id`) REFERENCES `activite` (`id`);

--
-- Contraintes pour la table `bilan`
--
ALTER TABLE `bilan`
  ADD CONSTRAINT `FK_F4DF4F443BDB63B4` FOREIGN KEY (`formationeleve_id`) REFERENCES `formation_eleve` (`id`),
  ADD CONSTRAINT `FK_F4DF4F4472EB1E50` FOREIGN KEY (`formationprof_id`) REFERENCES `formation_prof` (`id`);

--
-- Contraintes pour la table `compterendu`
--
ALTER TABLE `compterendu`
  ADD CONSTRAINT `FK_2F62FA3E3BDB63B4` FOREIGN KEY (`formationeleve_id`) REFERENCES `formation_eleve` (`id`);

--
-- Contraintes pour la table `compterenduformation`
--
ALTER TABLE `compterenduformation`
  ADD CONSTRAINT `FK_22CBD8525200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`);

--
-- Contraintes pour la table `eleve_activite`
--
ALTER TABLE `eleve_activite`
  ADD CONSTRAINT `FK_AC98B3619B0F88B1` FOREIGN KEY (`activite_id`) REFERENCES `activite` (`id`),
  ADD CONSTRAINT `FK_AC98B361F8FEEED1` FOREIGN KEY (`eleve_lecon_id`) REFERENCES `eleve_lecon` (`id`);

--
-- Contraintes pour la table `eleve_lecon`
--
ALTER TABLE `eleve_lecon`
  ADD CONSTRAINT `FK_8B8639C7AFC2B591` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`),
  ADD CONSTRAINT `FK_8B8639C7CDFE9043` FOREIGN KEY (`formation_eleve_id`) REFERENCES `formation_eleve` (`id`),
  ADD CONSTRAINT `FK_8B8639C7EC1308A5` FOREIGN KEY (`lecon_id`) REFERENCES `lecon` (`id`);

--
-- Contraintes pour la table `eleve_tentative`
--
ALTER TABLE `eleve_tentative`
  ADD CONSTRAINT `FK_8CBFDA3A1E688286` FOREIGN KEY (`eleve_activite_id`) REFERENCES `eleve_activite` (`id`);

--
-- Contraintes pour la table `exercice`
--
ALTER TABLE `exercice`
  ADD CONSTRAINT `FK_E418C74D2AADBACD` FOREIGN KEY (`langue_id`) REFERENCES `langue` (`id`),
  ADD CONSTRAINT `FK_E418C74DC2CDD509` FOREIGN KEY (`type_exercice_id`) REFERENCES `type_exercice` (`id`);

--
-- Contraintes pour la table `formation`
--
ALTER TABLE `formation`
  ADD CONSTRAINT `FK_404021BF2AADBACD` FOREIGN KEY (`langue_id`) REFERENCES `langue` (`id`),
  ADD CONSTRAINT `FK_404021BFB3E9C81` FOREIGN KEY (`niveau_id`) REFERENCES `niveau` (`id`),
  ADD CONSTRAINT `FK_C2B1A31C80B3C9E8` FOREIGN KEY (`formation_type_id`) REFERENCES `formation_type` (`id`);

--
-- Contraintes pour la table `formation_eleve`
--
ALTER TABLE `formation_eleve`
  ADD CONSTRAINT `FK_9A2A9B825200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`),
  ADD CONSTRAINT `FK_9A2A9B82A6CC7B2` FOREIGN KEY (`eleve_id`) REFERENCES `utilisateur` (`id`);

--
-- Contraintes pour la table `formation_module`
--
ALTER TABLE `formation_module`
  ADD CONSTRAINT `FK_2C3D28055200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`),
  ADD CONSTRAINT `FK_2C3D2805AFC2B591` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`);

--
-- Contraintes pour la table `formation_prof`
--
ALTER TABLE `formation_prof`
  ADD CONSTRAINT `FK_C6595FB5200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`),
  ADD CONSTRAINT `FK_C6595FBABC1F7FE` FOREIGN KEY (`prof_id`) REFERENCES `utilisateur` (`id`);

--
-- Contraintes pour la table `langue_utilisateur`
--
ALTER TABLE `langue_utilisateur`
  ADD CONSTRAINT `FK_EDF270C82AADBACD` FOREIGN KEY (`langue_id`) REFERENCES `langue` (`id`),
  ADD CONSTRAINT `FK_EDF270C8FB88E14F` FOREIGN KEY (`utilisateur_id`) REFERENCES `utilisateur` (`id`);

--
-- Contraintes pour la table `lecon`
--
ALTER TABLE `lecon`
  ADD CONSTRAINT `FK_94E6242E2AADBACD` FOREIGN KEY (`langue_id`) REFERENCES `langue` (`id`),
  ADD CONSTRAINT `FK_94E6242E76C50E4A` FOREIGN KEY (`proprietaire_id`) REFERENCES `utilisateur` (`id`),
  ADD CONSTRAINT `FK_94E6242E87998E` FOREIGN KEY (`origine_id`) REFERENCES `lecon` (`id`);

--
-- Contraintes pour la table `lecon_activite`
--
ALTER TABLE `lecon_activite`
  ADD CONSTRAINT `FK_473DE2909B0F88B1` FOREIGN KEY (`activite_id`) REFERENCES `activite` (`id`),
  ADD CONSTRAINT `FK_473DE290EC1308A5` FOREIGN KEY (`lecon_id`) REFERENCES `lecon` (`id`);

--
-- Contraintes pour la table `lecon_exercice`
--
ALTER TABLE `lecon_exercice`
  ADD CONSTRAINT `FK_1B5070C889D40298` FOREIGN KEY (`exercice_id`) REFERENCES `exercice` (`id`),
  ADD CONSTRAINT `FK_1B5070C8EC1308A5` FOREIGN KEY (`lecon_id`) REFERENCES `lecon` (`id`);

--
-- Contraintes pour la table `media`
--
ALTER TABLE `media`
  ADD CONSTRAINT `FK_6A2CA10C60BB6FE6` FOREIGN KEY (`auteur_id`) REFERENCES `utilisateur` (`id`),
  ADD CONSTRAINT `FK_6A2CA10CBCF5E72D` FOREIGN KEY (`categorie_id`) REFERENCES `media_categorie` (`id`);

--
-- Contraintes pour la table `media_categorie`
--
ALTER TABLE `media_categorie`
  ADD CONSTRAINT `FK_6C1D65BA727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `media_categorie` (`id`);

--
-- Contraintes pour la table `module`
--
ALTER TABLE `module`
  ADD CONSTRAINT `FK_C2426282AADBACD` FOREIGN KEY (`langue_id`) REFERENCES `langue` (`id`);

--
-- Contraintes pour la table `module_lecon`
--
ALTER TABLE `module_lecon`
  ADD CONSTRAINT `FK_9DEA5440AFC2B591` FOREIGN KEY (`module_id`) REFERENCES `module` (`id`),
  ADD CONSTRAINT `FK_9DEA5440EC1308A5` FOREIGN KEY (`lecon_id`) REFERENCES `lecon` (`id`);

--
-- Contraintes pour la table `reponse`
--
ALTER TABLE `reponse`
  ADD CONSTRAINT `FK_5FB6DEC76FB42672` FOREIGN KEY (`eleve_tentative_id`) REFERENCES `eleve_tentative` (`id`),
  ADD CONSTRAINT `FK_5FB6DEC789D40298` FOREIGN KEY (`exercice_id`) REFERENCES `exercice` (`id`);

--
-- Contraintes pour la table `utilisateur_groupe`
--
ALTER TABLE `utilisateur_groupe`
  ADD CONSTRAINT `FK_6514B6AA7A45358C` FOREIGN KEY (`groupe_id`) REFERENCES `groupe` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_6514B6AAFB88E14F` FOREIGN KEY (`utilisateur_id`) REFERENCES `utilisateur` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `utilisateur_nationalite`
--
ALTER TABLE `utilisateur_nationalite`
  ADD CONSTRAINT `FK_6A22DAAC1B063272` FOREIGN KEY (`nationalite_id`) REFERENCES `nationalite` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_6A22DAACFB88E14F` FOREIGN KEY (`utilisateur_id`) REFERENCES `utilisateur` (`id`) ON DELETE CASCADE;
COMMIT;
