-- https://www.phpmyadmin.net/
--
-- Client :  localhost
-- Généré le :  Mar 28 Mars 2017 à 19:17
-- Version du serveur :  5.6.35
-- Version de PHP :  7.1.1


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

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

--
-- Structure de la table `application`
--

CREATE TABLE `application` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `course_id` int(11) NOT NULL,
  `status` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `application`
--

INSERT INTO `application` (`id`, `user_id`, `course_id`, `status`, `created_at`, `updated_at`) VALUES
(5, 39, 12, NULL, NULL, NULL),
(6, 14, 12, NULL, NULL, NULL),
(7, 14, 6, NULL, NULL, NULL),
(8, 40, 7, NULL, NULL, NULL),
(9, 14, 11, NULL, NULL, NULL),
(10, 41, 3, NULL, NULL, NULL),
(11, 41, 5, NULL, NULL, NULL),
(12, 42, 12, NULL, NULL, NULL),
(14, 14, 9, NULL, NULL, NULL),
(15, 14, 14, NULL, NULL, NULL),
(16, 14, 5, NULL, NULL, NULL),
(17, 43, 7, NULL, NULL, NULL),
(18, 14, 8, NULL, '2017-03-19 23:07:36', NULL),
(20, 44, 7, NULL, '2017-03-19 23:12:16', NULL),
(21, 45, 3, NULL, '2017-03-20 11:11:19', NULL),
(23, 48, 8, NULL, '2017-03-23 20:09:22', NULL),
(24, 14, 3, NULL, '2017-03-24 12:41:08', NULL),
(25, 14, 4, NULL, '2017-03-24 12:45:41', NULL),
(26, 14, 7, NULL, '2017-03-24 12:53:05', NULL),
(27, 14, 1, NULL, '2017-03-24 15:32:20', NULL),
(28, 14, 15, NULL, '2017-03-24 15:36:50', NULL),
(29, 48, 7, NULL, '2017-03-24 17:52:26', NULL),
(30, 52, 9, NULL, '2017-03-27 11:37:34', NULL);

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

--
-- Structure de la table `autorisations`
--

CREATE TABLE `autorisations` (
  `role_id` int(11) NOT NULL,
  `fonctionnalite_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `autorisations`
--

INSERT INTO `autorisations` (`role_id`, `fonctionnalite_id`) VALUES
(3, 2),
(3, 3);

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

--
-- Structure de la table `course`
--

CREATE TABLE `course` (
  `id` int(11) NOT NULL,
  `diploma_id` int(11) NOT NULL,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `conditions` longtext COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `course`
--

INSERT INTO `course` (`id`, `diploma_id`, `name`, `conditions`) VALUES
(1, 3, 'Première année', '- Toutes séries de bac'),
(2, 3, 'Deuxième année', '- Toutes séries de bac\r\n-Filières Droit, Sociologie, Sc Ecomiques, Philosophie Histoire.'),
(3, 1, 'Première année', '- Baccalauréat série sciences expérimentales (SPC-SVT), mathématiques, Bac techniques et Bac économie.'),
(4, 1, 'Deuxième année', '- Baccalauréat série sciences expérimentales (SPC-SVT), mathématiques, Bac techniques et Bac économie.'),
(5, 6, 'Quatrième année', '-Licence ou d’un diplôme équivalant en histoire de l’art, archéologie, géographie,  tourisme, sciences économiques et gestion, \r\narchitecture, muséologie et patrimoine ou médiation culturelle.\"'),
(6, 6, 'Cinquième année', '- Licence ou d’un diplôme équivalant en histoire de l’art, archéologie, géographie, tourisme, sciences économiques et gestion, architecture, muséologie et patrimoine ou médiation culturelle.</br>\r\n- Master 1 ou Master 2 ou équivalent en histoire de l’art, archéologie, géographie, tourisme, sciences économiques et gestion, architecture, muséologie et patrimoine ou médiation culturelle.'),
(7, 5, 'Quatrième année', '- Licence ou diplôme équivalent en Lettres ou en Siences Humaines et Sociales'),
(8, 11, 'Troisième année', '- DEUG ou équivalent en: Sc Humaines ,Sc Environnement Sc Gestion.'),
(9, 4, 'Première année', '- Toutes séries de bac Sauf Bac Lettres'),
(11, 8, 'Première année', '- Bac Lettres\r\n- Bac Sc Economiques\r\n- Bac scientifique'),
(12, 2, 'Première année', '- Toutes séries de bac'),
(13, 7, 'Troisième année', 'DEUG ou équivalent en: Sc Humaines ,Sc Environnement  Sc Gestion'),
(14, 10, 'Quatrième année', '- Licence ou diplôme équivalant en histoire de l’art, archéologie, géographie, tourisme, sciences économiques et gestion, architecture, muséologie et patrimoine ou médiation culturelle.'),
(15, 9, 'Quatrième année', '- Licence ou diplôme équivalent en Lettres ou en Siences Humaines et Sociales'),
(19, 12, 'Première année', 'Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Curabitur aliquet quam id dui posuere blandit. Mauris blandit aliquet elit, eget tincidunt nibh pulvinar a. Vivamus suscipit tortor eget felis porttitor volutpat. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Sed porttitor lectus nibh. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Curabitur aliquet quam id dui posuere blandit.'),
(20, 13, 'Troisième année', 'Vivamus suscipit tortor eget felis porttitor volutpat. Mauris blandit aliquet elit, eget tincidunt nibh pulvinar a. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Proin eget tortor risus. Sed porttitor lectus nibh. Cras ultricies ligula sed magna dictum porta. Donec sollicitudin molestie malesuada. Pellentesque in ipsum id orci porta dapibus. Quisque velit nisi, pretium ut lacinia in, elementum id enim. Vivamus suscipit tortor eget felis porttitor volutpat.'),
(21, 14, 'Quatrième année', 'Donec sollicitudin molestie malesuada. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula. Sed porttitor lectus nibh. Nulla quis lorem ut libero malesuada feugiat. Nulla quis lorem ut libero malesuada feugiat. Vivamus suscipit tortor eget felis porttitor volutpat. Proin eget tortor risus. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula.'),
(22, 15, 'Quatrième année', 'Donec sollicitudin molestie malesuada. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula. Sed porttitor lectus nibh. Nulla quis lorem ut libero malesuada feugiat. Nulla quis lorem ut libero malesuada feugiat. Vivamus suscipit tortor eget felis porttitor volutpat. Proin eget tortor risus. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula.'),
(23, 16, 'Quatrième année', 'Cras ultricies ligula sed magna dictum porta. Sed porttitor lectus nibh. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Pellentesque in ipsum id orci porta dapibus. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Quisque velit nisi, pretium ut lacinia in, elementum id enim.'),
(24, 17, 'Quatrième année', 'Cras ultricies ligula sed magna dictum porta. Sed porttitor lectus nibh. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Pellentesque in ipsum id orci porta dapibus. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Quisque velit nisi, pretium ut lacinia in, elementum id enim.'),
(25, 18, 'Quatrième année', 'Cras ultricies ligula sed magna dictum porta. Sed porttitor lectus nibh. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Pellentesque in ipsum id orci porta dapibus. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Quisque velit nisi, pretium ut lacinia in, elementum id enim.'),
(26, 19, 'Troisième année', 'Nulla porttitor accumsan tincidunt. Sed porttitor lectus nibh. Cras ultricies ligula sed magna dictum porta. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque in ipsum id orci porta dapibus. Proin eget tortor risus. Vivamus suscipit tortor eget felis porttitor volutpat. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Curabitur aliquet quam id dui posuere blandit.'),
(27, 20, 'Troisième année', 'Nulla porttitor accumsan tincidunt. Sed porttitor lectus nibh. Cras ultricies ligula sed magna dictum porta. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque in ipsum id orci porta dapibus. Proin eget tortor risus. Vivamus suscipit tortor eget felis porttitor volutpat. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Curabitur aliquet quam id dui posuere blandit.'),
(28, 21, 'Troisième année', 'Nulla porttitor accumsan tincidunt. Sed porttitor lectus nibh. Cras ultricies ligula sed magna dictum porta. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque in ipsum id orci porta dapibus. Proin eget tortor risus. Vivamus suscipit tortor eget felis porttitor volutpat. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Curabitur aliquet quam id dui posuere blandit.'),
(29, 22, 'Troisième année', 'Nulla porttitor accumsan tincidunt. Sed porttitor lectus nibh. Cras ultricies ligula sed magna dictum porta. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque in ipsum id orci porta dapibus. Proin eget tortor risus. Vivamus suscipit tortor eget felis porttitor volutpat. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Curabitur aliquet quam id dui posuere blandit.');

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

--
-- Structure de la table `course_document_type`
--

CREATE TABLE `course_document_type` (
  `course_id` int(11) NOT NULL,
  `document_type_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `course_document_type`
--

INSERT INTO `course_document_type` (`course_id`, `document_type_id`) VALUES
(1, 1),
(1, 6),
(1, 9),
(2, 1),
(2, 6),
(2, 7),
(2, 9),
(3, 1),
(3, 6),
(3, 9),
(4, 1),
(4, 2),
(4, 3),
(4, 4),
(4, 5),
(4, 6),
(4, 7),
(4, 9),
(5, 1),
(5, 7),
(5, 9),
(6, 1),
(6, 7),
(6, 9),
(6, 10),
(7, 1),
(7, 7),
(7, 9),
(8, 1),
(8, 7),
(8, 9),
(9, 1),
(9, 6),
(9, 9),
(11, 1),
(11, 6),
(11, 9),
(12, 1),
(12, 6),
(12, 9),
(13, 1),
(13, 7),
(13, 9),
(14, 1),
(14, 7),
(14, 9),
(15, 1),
(15, 7),
(15, 9),
(19, 1),
(19, 6),
(19, 9),
(20, 1),
(20, 7),
(20, 9),
(20, 11),
(21, 1),
(21, 7),
(21, 9),
(21, 10),
(22, 1),
(22, 7),
(22, 9),
(22, 10),
(23, 1),
(23, 7),
(23, 9),
(23, 10),
(24, 1),
(24, 7),
(24, 9),
(24, 10),
(25, 1),
(25, 7),
(25, 9),
(25, 10),
(26, 1),
(26, 7),
(26, 9),
(27, 1),
(27, 7),
(27, 9),
(28, 1),
(28, 7),
(28, 9),
(29, 1),
(29, 7),
(29, 9);

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

--
-- Structure de la table `diploma`
--

CREATE TABLE `diploma` (
  `id` int(11) NOT NULL,
  `school_id` int(11) NOT NULL,
  `school_field_id` int(11) NOT NULL,
  `diploma_type_id` int(11) NOT NULL,
  `training_type_id` int(11) NOT NULL,
  `school_year` int(11) NOT NULL,
  `application_deadline` datetime DEFAULT NULL,
  `files_deadline` datetime DEFAULT NULL,
  `payment_receipt_deadline` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `diploma`
--

INSERT INTO `diploma` (`id`, `school_id`, `school_field_id`, `diploma_type_id`, `training_type_id`, `school_year`, `application_deadline`, `files_deadline`, `payment_receipt_deadline`) VALUES
(1, 1, 1, 4, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(2, 2, 2, 4, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(3, 2, 3, 1, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(4, 3, 4, 1, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(5, 4, 9, 2, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(6, 4, 8, 2, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(7, 4, 6, 1, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(8, 4, 5, 1, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(9, 4, 10, 2, 5, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(10, 4, 11, 2, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(11, 4, 7, 1, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(12, 5, 12, 4, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(13, 5, 13, 4, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(14, 6, 14, 2, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(15, 6, 15, 2, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(16, 6, 16, 2, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(17, 6, 17, 2, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(18, 6, 18, 2, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(19, 6, 19, 1, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(20, 6, 20, 1, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(21, 6, 21, 1, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00'),
(22, 6, 22, 1, 6, 2017, '2017-05-27 00:00:00', '2017-05-27 00:00:00', '2017-05-27 00:00:00');

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

--
-- Structure de la table `diploma_type`
--

CREATE TABLE `diploma_type` (
  `id` int(11) NOT NULL,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `diploma_type`
--

INSERT INTO `diploma_type` (`id`, `name`, `description`) VALUES
(1, 'Licence', '<b>Curabitur</b> non nulla sit amet nisl tempus convallis quis ac lectus. Quisque velit nisi, pretium ut lacinia in, elementum id enim. Nulla quis lorem ut libero malesuada feugiat. Donec sollicitudin molestie malesuada. Quisque velit nisi, pretium ut lacinia in, elementum id enim. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque in ipsum id orci porta dapibus. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi.'),
(2, 'Master', 'Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Quisque velit nisi, pretium ut lacinia in, elementum id enim. Nulla quis lorem ut libero malesuada feugiat. Donec sollicitudin molestie malesuada. Quisque velit nisi, pretium ut lacinia in, elementum id enim. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque in ipsum id orci porta dapibus. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi.'),
(4, 'Formation d\'architecte', 'Mauris blandit aliquet elit, eget tincidunt nibh pulvinar a. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Nulla porttitor accumsan tincidunt. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Nulla porttitor accumsan tincidunt. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Pellentesque in ipsum id orci porta dapibus. Mauris blandit aliquet elit, eget tincidunt nibh pulvinar a. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula.'),
(6, 'Année préparatoire aux cycles d\'ingénieurs', 'jjjk'),
(7, 'Cycle d\'ingénieur', 'gfgfhg');

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

--
-- Structure de la table `document`
--

CREATE TABLE `document` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `document_type_id` int(11) NOT NULL,
  `application_id` int(11) NOT NULL,
  `filename` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `extension` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `document`
--

INSERT INTO `document` (`id`, `user_id`, `document_type_id`, `application_id`, `filename`, `extension`) VALUES
(62, 39, 1, 5, 'avatar_17-03-2017_1489771820_58cc1d2cc3d7c_4831.png', 'png'),
(63, 39, 2, 5, 'cv_17-03-2017_1489771945_58cc1da9631bd_4664.pdf', 'pdf'),
(64, 39, 8, 5, 'payment_receipt_17-03-2017_1489771982_58cc1dce23c46_4118.jpeg', 'jpeg'),
(68, 40, 5, 8, 'attestation2_17-03-2017_1489778442_58cc370a93450_9552.png', 'png'),
(69, 40, 6, 8, 'attestation3_17-03-2017_1489778442_58cc370aa3c72_2821.png', 'png'),
(70, 40, 7, 8, 'attestation4_17-03-2017_1489778442_58cc370aa9448_6036.png', 'png'),
(71, 40, 8, 8, 'payment_receipt_17-03-2017_1489778492_58cc373cd6c26_100.png', 'png'),
(74, 14, 1, 9, 'avatar_17-03-2017_1489781301_58cc4235ba653_5285.pdf', 'pdf'),
(75, 14, 3, 9, 'lettre_invitation_17-03-2017_1489781301_58cc4235c957e_7039.png', 'png'),
(76, 14, 7, 9, 'attestation4_17-03-2017_1489781301_58cc4235d1640_7656.pdf', 'pdf'),
(77, 14, 8, 9, 'payment_receipt_17-03-2017_1489781329_58cc425123832_8815.pdf', 'pdf'),
(78, 41, 8, 11, 'payment_receipt_17-03-2017_1489781568_58cc43402efdd_3794.pdf', 'pdf'),
(79, 41, 8, 10, 'payment_receipt_17-03-2017_1489781583_58cc434f61c5c_7289.pdf', 'pdf'),
(80, 41, 1, 10, 'avatar_17-03-2017_1489781605_58cc43654f3c5_1567.png', 'png'),
(81, 41, 2, 10, 'cv_17-03-2017_1489781605_58cc436561a47_3046.png', 'png'),
(84, 14, 8, 6, 'payment_receipt_18-03-2017_1489839278_58cd24aeb66df_4558.pdf', 'pdf'),
(89, 14, 1, 6, 'cin_18-03-2017_1489848083_58cd471384147_6874.png', 'png'),
(90, 14, 3, 6, 'attestation_reussite_18-03-2017_1489848198_58cd4786dfbae_2464.pdf', 'pdf'),
(94, 14, 8, 7, 'payment_receipt_18-03-2017_1489848923_58cd4a5bc9fa6_6224.png', 'png'),
(95, 14, 5, 6, 'lettre_motivation_19-03-2017_1489961175_58cf00d702a03_5487.pdf', 'pdf'),
(96, 14, 1, 6, 'cin_19-03-2017_1489961175_58cf00d714dce_2156.png', 'png'),
(97, 14, 2, 6, 'attestation_Inscription_19-03-2017_1489961190_58cf00e69df63_9179.pdf', 'pdf'),
(99, 14, 8, 15, 'payment_receipt_19-03-2017_1489961223_58cf0107bdcd9_8153.pdf', 'pdf'),
(101, 44, 8, 20, 'payment_receipt_19-03-2017_1489961547_58cf024ba548f_229.pdf', 'pdf'),
(102, 44, 2, 20, 'attestation_Inscription_19-03-2017_1489961563_58cf025bcbcef_8849.pdf', 'pdf'),
(104, 45, 8, 21, 'payment_receipt_20-03-2017_1490004899_58cfaba3d8c69_8891.pdf', 'pdf'),
(106, 14, 4, 6, 'plaquette_pedagogique_formation_23-03-2017_1490286770_58d3f8b23daba_4112.png', 'png'),
(111, 14, 1, 6, 'cin_23-03-2017_1490294735_58d417cfc84cc_5102.docx', 'docx'),
(112, 14, 6, 6, 'releve_notes_bac_regional_23-03-2017_1490295353_58d41a39996d3_1130.png', 'png'),
(117, 48, 8, 23, 'payment_receipt_23-03-2017_1490296451_58d41e83bc14d_3258.png', 'png'),
(118, 48, 2, 23, 'attestation_Inscription_23-03-2017_1490296529_58d41ed109aa1_5027.png', 'png'),
(119, 48, 3, 23, 'attestation_reussite_23-03-2017_1490296542_58d41ede3e20c_4462.png', 'png'),
(120, 14, 8, 28, 'payment_receipt_24-03-2017_1490366535_58d5304761629_9118.docx', 'docx'),
(121, 14, 6, 9, 'releve_notes_bac_regional_24-03-2017_1490367207_58d532e734d99_572.docx', 'docx'),
(122, 14, 9, 9, 'releves_notes_bac_24-03-2017_1490367226_58d532fa20177_4239.docx', 'docx'),
(123, 14, 7, 28, 'releves_notes_post_bac_24-03-2017_1490367270_58d533269dc2a_8472.docx', 'docx'),
(126, 14, 6, 27, 'releve_notes_bac_regional_24-03-2017_1490367403_58d533abd1a2e_7449.png', 'png'),
(127, 14, 6, 27, 'releve_notes_bac_regional_24-03-2017_1490367403_58d533abde381_415.docx', 'docx'),
(128, 14, 9, 27, 'releves_notes_bac_24-03-2017_1490367403_58d533abe454f_6516.docx', 'docx'),
(129, 14, 1, 27, 'cin_24-03-2017_1490367404_58d533ac02922_2298.docx', 'docx'),
(130, 14, 8, 27, 'payment_receipt_24-03-2017_1490367410_58d533b23b09a_1515.docx', 'docx'),
(140, 14, 9, 28, 'releves_notes_bac_24-03-2017_1490369141_58d53a7538451_6994.docx', 'docx'),
(141, 14, 1, 28, 'cin_24-03-2017_1490369145_58d53a79eeb52_5644.docx', 'docx');

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

--
-- Structure de la table `document_type`
--

CREATE TABLE `document_type` (
  `id` int(11) NOT NULL,
  `name` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `code` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `multiple` tinyint(1) DEFAULT NULL,
  `order_row` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `document_type`
--

INSERT INTO `document_type` (`id`, `name`, `code`, `multiple`, `order_row`) VALUES
(1, 'CIN (Carte d\'identité nationale)', 'cin', 1, 13),
(2, 'Attestation d\'Inscription', 'attestation_Inscription', 1, 12),
(3, 'Attestation de Réussite', 'attestation_reussite', 0, NULL),
(4, 'Plaquette pédagogique de la formation', 'plaquette_pedagogique_formation', 0, NULL),
(5, 'Lettre Motivation', 'lettre_motivation', 0, NULL),
(6, 'Relevé de notes du Bac Régional', 'releve_notes_bac_regional', 1, NULL),
(7, 'Relevés de notes Post Bac', 'releves_notes_post_bac', 1, NULL),
(8, 'Reçu de paiement', 'payment_receipt', 0, NULL),
(9, 'Relevés de notes du Bac', 'releves_notes_bac', 1, NULL),
(10, 'Relevés de notes Post Licence', 'releves_notes_post_licence', 1, NULL),
(11, 'Relevés Notes du cursus', 'releves_notes_cursus', 1, NULL);

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

--
-- Structure de la table `fonctionnalites`
--

CREATE TABLE `fonctionnalites` (
  `id` int(11) NOT NULL,
  `code` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `fonctionnalites`
--

INSERT INTO `fonctionnalites` (`id`, `code`, `description`) VALUES
(2, 'create user', 'Ajouter utilisateur'),
(3, 'update user', 'update user');

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

--
-- Structure de la table `nationality`
--

CREATE TABLE `nationality` (
  `id` int(11) NOT NULL,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `nationality`
--

INSERT INTO `nationality` (`id`, `name`) VALUES
(62, 'Afghane'),
(63, 'Albanaise'),
(64, 'Algerienne'),
(65, 'Allemande'),
(66, 'Americaine'),
(67, 'Andorrane'),
(68, 'Angolaise'),
(69, 'Antiguaise et barbudienne'),
(70, 'Argentine'),
(71, 'Armenienne'),
(72, 'Australienne'),
(73, 'Autrichienne'),
(74, 'Azerbaïdjanaise'),
(75, 'Bahamienne'),
(76, 'Bahreinienne'),
(77, 'Bangladaise'),
(78, 'Barbadienne'),
(79, 'Belge'),
(80, 'Belizienne'),
(2, 'Béninoise'),
(81, 'Bhoutanaise'),
(82, 'Bielorusse'),
(83, 'Birmane'),
(84, 'Bissau-Guinéenne'),
(85, 'Bolivienne'),
(86, 'Bosnienne'),
(87, 'Botswanaise'),
(88, 'Bresilienne'),
(89, 'Britannique'),
(90, 'Bruneienne'),
(91, 'Bulgare'),
(3, 'Burkinabaise'),
(92, 'Burkinabe'),
(93, 'Burundaise'),
(94, 'Cambodgienne'),
(95, 'Camerounaise'),
(96, 'Canadienne'),
(97, 'Cap-verdienne'),
(98, 'Centrafricaine'),
(99, 'Chilienne'),
(100, 'Chinoise'),
(101, 'Chypriote'),
(102, 'Colombienne'),
(103, 'Comorienne'),
(104, 'Congolaise'),
(105, 'Costaricaine'),
(106, 'Croate'),
(107, 'Cubaine'),
(108, 'Danoise'),
(109, 'Djiboutienne'),
(110, 'Dominicaine'),
(111, 'Dominiquaise'),
(112, 'Egyptienne'),
(113, 'Emirienne'),
(114, 'Equato-guineenne'),
(115, 'Equatorienne'),
(116, 'Erythreenne'),
(117, 'Espagnole'),
(118, 'Est-timoraise'),
(119, 'Estonienne'),
(120, 'Ethiopienne'),
(121, 'Fidjienne'),
(122, 'Finlandaise'),
(123, 'Française'),
(5, 'Gabonaise'),
(124, 'Gambienne'),
(125, 'Georgienne'),
(126, 'Ghaneenne'),
(127, 'Grenadienne'),
(128, 'Guatemalteque'),
(129, 'Guineenne'),
(130, 'Guyanienne'),
(131, 'Haïtienne'),
(132, 'Hellenique'),
(133, 'Hondurienne'),
(134, 'Hongroise'),
(135, 'Indienne'),
(136, 'Indonesienne'),
(137, 'Irakienne'),
(138, 'Irlandaise'),
(139, 'Islandaise'),
(140, 'Israélienne'),
(141, 'Italienne'),
(142, 'Ivoirienne'),
(143, 'Jamaïcaine'),
(144, 'Japonaise'),
(145, 'Jordanienne'),
(146, 'Kazakhstanaise'),
(147, 'Kenyane'),
(148, 'Kirghize'),
(149, 'Kiribatienne'),
(150, 'Kittitienne-et-nevicienne'),
(151, 'Kossovienne'),
(152, 'Koweitienne'),
(153, 'Laotienne'),
(154, 'Lesothane'),
(155, 'Lettone'),
(156, 'Libanaise'),
(157, 'Liberienne'),
(158, 'Libyenne'),
(159, 'Liechtensteinoise'),
(160, 'Lituanienne'),
(161, 'Luxembourgeoise'),
(162, 'Macedonienne'),
(163, 'Malaisienne'),
(164, 'Malawienne'),
(165, 'Maldivienne'),
(166, 'Malgache'),
(7, 'Malienne'),
(167, 'Maltaise'),
(1, 'Marocaine'),
(168, 'Marshallaise'),
(169, 'Mauricienne'),
(170, 'Mauritanienne'),
(171, 'Mexicaine'),
(172, 'Micronesienne'),
(173, 'Moldave'),
(174, 'Monegasque'),
(175, 'Mongole'),
(176, 'Montenegrine'),
(177, 'Mozambicaine'),
(178, 'Namibienne'),
(179, 'Nauruane'),
(180, 'Neerlandaise'),
(181, 'Neo-zelandaise'),
(182, 'Nepalaise'),
(183, 'Nicaraguayenne'),
(184, 'Nigeriane'),
(185, 'Nigerienne'),
(186, 'Nord-coréenne'),
(187, 'Norvegienne'),
(188, 'Omanaise'),
(189, 'Ougandaise'),
(190, 'Ouzbeke'),
(191, 'Pakistanaise'),
(192, 'Palau'),
(193, 'Palestinienne'),
(194, 'Panameenne'),
(195, 'Papouane-neoguineenne'),
(196, 'Paraguayenne'),
(197, 'Peruvienne'),
(198, 'Philippine'),
(199, 'Polonaise'),
(200, 'Portoricaine'),
(201, 'Portugaise'),
(202, 'Qatarienne'),
(203, 'Roumaine'),
(204, 'Russe'),
(205, 'Rwandaise'),
(206, 'Saint-lucienne'),
(207, 'Saint-marinaise'),
(208, 'Saint-vincentaise-et-grenadine'),
(209, 'Salomonaise'),
(210, 'Salvadorienne'),
(211, 'Samoane'),
(212, 'Santomeenne'),
(213, 'Saoudienne'),
(214, 'Senegalaise'),
(215, 'Serbe'),
(216, 'Seychelloise'),
(217, 'Sierra-leonaise'),
(218, 'Singapourienne'),
(219, 'Slovaque'),
(220, 'Slovene'),
(221, 'Somalienne'),
(222, 'Soudanaise'),
(223, 'Sri-lankaise'),
(224, 'Sud-africaine'),
(225, 'Sud-coréenne'),
(226, 'Suedoise'),
(227, 'Suisse'),
(228, 'Surinamaise'),
(229, 'Swazie'),
(230, 'Syrienne'),
(231, 'Tadjike'),
(232, 'Taiwanaise'),
(233, 'Tanzanienne'),
(234, 'Tchadienne'),
(235, 'Tcheque'),
(236, 'Thaïlandaise'),
(237, 'Togolaise'),
(238, 'Tonguienne'),
(239, 'Trinidadienne'),
(240, 'Tunisienne'),
(241, 'Turkmene'),
(242, 'Turque'),
(243, 'Tuvaluane'),
(244, 'Ukrainienne'),
(245, 'Uruguayenne'),
(246, 'Vanuatuane'),
(247, 'Venezuelienne'),
(248, 'Vietnamienne'),
(249, 'Yemenite'),
(250, 'Zambienne'),
(251, 'Zimbabweenne');

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

--
-- Structure de la table `roles`
--

CREATE TABLE `roles` (
  `id` int(11) NOT NULL,
  `libelle` varchar(70) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `roles`
--

INSERT INTO `roles` (`id`, `libelle`) VALUES
(3, 'reerre');

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

--
-- Structure de la table `school`
--

CREATE TABLE `school` (
  `id` int(11) NOT NULL,
  `name` varchar(250) COLLATE utf8_unicode_ci NOT NULL,
  `address` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `phoneNumber` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `updated_at` datetime DEFAULT NULL,
  `code` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `school`
--

INSERT INTO `school` (`id`, `name`, `address`, `phoneNumber`, `created_at`, `updated_at`, `code`) VALUES
(1, 'Ecole EuroMed d\'Architecture, de Design et d\'Urbanisme', 'EMADU', 'EMADU', '2017-03-28 11:22:01', '2017-03-28 16:59:04', 'EMADU'),
(2, 'Institut EuroMed de Sciences Politiques', 'IEMSP', 'IEMSP', '2017-03-13 13:57:00', '2017-03-28 16:59:44', 'IEMSP'),
(3, 'EuroMed Business School', 'EBS', 'EBS', '2017-03-15 13:40:00', '2017-03-28 17:00:13', 'EBS'),
(4, 'Faculté EuroMed des Sciences Humaines et Sociales', 'FEMSHS', 'FEMSHS', '2017-03-17 23:21:00', '2017-03-28 17:00:42', 'FEMSHS'),
(5, 'Ecole EuroMed de Génie Civil', 'EEMGC', 'EEMGC', '2017-03-24 16:55:00', '2017-03-28 17:01:18', 'EEMGC'),
(6, 'Faculté EuroMed de Génie', 'FEMG', 'FEMG', '2017-03-24 16:56:00', '2017-03-28 17:01:48', 'FEMG');

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

--
-- Structure de la table `school_field`
--

CREATE TABLE `school_field` (
  `id` int(11) NOT NULL,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `date_accreditation` datetime NOT NULL,
  `description` longtext COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `school_field`
--

INSERT INTO `school_field` (`id`, `name`, `date_accreditation`, `description`) VALUES
(1, 'Architecture', '2067-04-07 00:00:00', '<b>Praesent</b> sapien massa, convallis a pellentesque nec, egestas non nisi. Vivamus suscipit tortor eget felis porttitor volutpat. Quisque velit nisi, pretium ut lacinia in, elementum id enim. Pellentesque in ipsum id orci porta dapibus. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Nulla porttitor accumsan tincidunt. Curabitur aliquet quam id dui posuere blandit. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Proin eget tortor risus. Quisque velit nisi, <b><u>pretium</u></b> ut lacinia in, elementum id enim.'),
(2, 'Design', '2012-01-01 00:00:00', 'Sed porttitor lectus nibh. Cras ultricies ligula sed magna dictum porta. Vivamus suscipit tortor eget felis porttitor volutpat. Pellentesque in ipsum id orci porta dapibus. Proin eget tortor risus. Proin eget tortor risus. Nulla porttitor accumsan tincidunt. Nulla porttitor accumsan tincidunt. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Quisque velit nisi, pretium ut lacinia in, elementum id enim.'),
(3, 'Licence Sc Pol', '2012-01-01 00:00:00', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec sollicitudin molestie malesuada. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Donec rutrum congue leo eget malesuada. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur aliquet quam id dui posuere blandit. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Sed porttitor lectus nibh. Vivamus suscipit tortor eget felis porttitor volutpat. Proin eget tortor risus.'),
(4, 'Licence Sc Gestion', '2012-01-01 00:00:00', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Curabitur aliquet quam id dui posuere blandit. Nulla porttitor accumsan tincidunt. Nulla quis lorem ut libero malesuada feugiat. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Proin eget tortor risus. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui.'),
(5, 'Licence L1 Traduction', '2012-01-01 00:00:00', 'Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Quisque velit nisi, pretium ut lacinia in, elementum id enim. Donec rutrum congue leo eget malesuada. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Nulla quis lorem ut libero malesuada feugiat. Nulla porttitor accumsan tincidunt. Curabitur aliquet quam id dui posuere blandit. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Vivamus suscipit tortor eget felis porttitor volutpat.'),
(6, 'Licence L1 Gestion Projets Environnementaux', '2012-01-01 00:00:00', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Pellentesque in ipsum id orci porta dapibus. Sed porttitor lectus nibh. Nulla porttitor accumsan tincidunt. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula. Pellentesque in ipsum id orci porta dapibus. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Quisque velit nisi, pretium ut lacinia in, elementum id enim. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus.'),
(7, 'Licence L3 Gestion Projets Environnementaux', '2012-01-01 00:00:00', 'Donec sollicitudin molestie malesuada. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Donec rutrum congue leo eget malesuada. Pellentesque in ipsum id orci porta dapibus. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Pellentesque in ipsum id orci porta dapibus. Donec sollicitudin molestie malesuada. Curabitur aliquet quam id dui posuere blandit. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula.'),
(8, 'Master Gestion et Valorisation Touristique', '2012-01-01 00:00:00', 'Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula. Mauris blandit aliquet elit, eget tincidunt nibh pulvinar a. Nulla porttitor accumsan tincidunt. Sed porttitor lectus nibh. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Nulla porttitor accumsan tincidunt. Nulla quis lorem ut libero malesuada feugiat. Mauris blandit aliquet elit, eget tincidunt nibh pulvinar a.'),
(9, 'Master Traduction', '2012-01-01 00:00:00', 'Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Cras ultricies ligula sed magna dictum porta. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Cras ultricies ligula sed magna dictum porta. Donec sollicitudin molestie malesuada. Donec sollicitudin molestie malesuada. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Donec rutrum congue leo eget malesuada. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Sed porttitor lectus nibh.'),
(10, 'Master Interprétariat', '2012-01-01 00:00:00', 'Nulla quis lorem ut libero malesuada feugiat. Mauris blandit aliquet elit, eget tincidunt nibh pulvinar a. Curabitur aliquet quam id dui posuere blandit. Nulla quis lorem ut libero malesuada feugiat. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Sed porttitor lectus nibh. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Pellentesque in ipsum id orci porta dapibus. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus.'),
(11, 'Master Communication des Eses et des Inst', '2012-01-01 00:00:00', 'Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula. Cras ultricies ligula sed magna dictum porta. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Cras ultricies ligula sed magna dictum porta. Pellentesque in ipsum id orci porta dapibus. Donec rutrum congue leo eget malesuada. Donec rutrum congue leo eget malesuada. Donec sollicitudin molestie malesuada. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula.'),
(12, 'GC 1A', '2012-01-01 00:00:00', 'Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Mauris blandit aliquet elit, eget tincidunt nibh pulvinar a. Donec sollicitudin molestie malesuada. Pellentesque in ipsum id orci porta dapibus. Proin eget tortor risus. Sed porttitor lectus nibh. Mauris blandit aliquet elit, eget tincidunt nibh pulvinar a.'),
(13, 'GC 3A', '2012-01-01 00:00:00', 'Donec rutrum congue leo eget malesuada. Donec sollicitudin molestie malesuada. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Proin eget tortor risus. Quisque velit nisi, pretium ut lacinia in, elementum id enim. Nulla porttitor accumsan tincidunt. Quisque velit nisi, pretium ut lacinia in, elementum id enim. Cras ultricies ligula sed magna dictum porta. Nulla porttitor accumsan tincidunt. Pellentesque in ipsum id orci porta dapibus.'),
(14, 'M1 EREE', '2012-01-01 00:00:00', 'Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Vivamus suscipit tortor eget felis porttitor volutpat. Nulla quis lorem ut libero malesuada feugiat. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Sed porttitor lectus nibh. Cras ultricies ligula sed magna dictum porta. Proin eget tortor risus. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus.'),
(15, 'M1 GEGE', '2012-01-01 00:00:00', 'Donec rutrum congue leo eget malesuada. Nulla quis lorem ut libero malesuada feugiat. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Donec sollicitudin molestie malesuada. Pellentesque in ipsum id orci porta dapibus. Nulla quis lorem ut libero malesuada feugiat. Nulla porttitor accumsan tincidunt. Donec sollicitudin molestie malesuada. Curabitur aliquet quam id dui posuere blandit. Nulla quis lorem ut libero malesuada feugiat.'),
(16, 'M1 Matériaux', '2012-01-01 00:00:00', 'Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Donec sollicitudin molestie malesuada. Proin eget tortor risus. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Curabitur aliquet quam id dui posuere blandit. Vivamus suscipit tortor eget felis porttitor volutpat. Sed porttitor lectus nibh. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Pellentesque in ipsum id orci porta dapibus.'),
(17, 'M1 BIG DATA', '2012-01-01 00:00:00', 'Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Pellentesque in ipsum id orci porta dapibus. Quisque velit nisi, pretium ut lacinia in, elementum id enim. Quisque velit nisi, pretium ut lacinia in, elementum id enim. Donec sollicitudin molestie malesuada. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Pellentesque in ipsum id orci porta dapibus. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi.'),
(18, 'M1 Transport', '2012-01-01 00:00:00', 'Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Pellentesque in ipsum id orci porta dapibus. Pellentesque in ipsum id orci porta dapibus. Proin eget tortor risus. Lorem ipsum dolor sit amet, consectetur adipiscing elit. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Donec rutrum congue leo eget malesuada. Donec rutrum congue leo eget malesuada. Cras ultricies ligula sed magna dictum porta. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula.'),
(19, 'LP 3 Expert Ener', '2012-01-01 00:00:00', 'Donec rutrum congue leo eget malesuada. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Nulla porttitor accumsan tincidunt. Proin eget tortor risus. Vestibulum ante ipsum primis in faucibus orci luctus et ultrices posuere cubilia Curae; Donec velit neque, auctor sit amet aliquam vel, ullamcorper sit amet ligula. Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Cras ultricies ligula sed magna dictum porta. Cras ultricies ligula sed magna dictum porta. Nulla porttitor accumsan tincidunt.'),
(20, 'LP 3 Matériaux', '2012-01-01 00:00:00', 'Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Donec sollicitudin molestie malesuada. Donec rutrum congue leo eget malesuada. Proin eget tortor risus. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Donec rutrum congue leo eget malesuada. Cras ultricies ligula sed magna dictum porta. Sed porttitor lectus nibh. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Quisque velit nisi, pretium ut lacinia in, elementum id enim.'),
(21, 'LP 3 Logistique', '2012-01-01 00:00:00', 'Vivamus magna justo, lacinia eget consectetur sed, convallis at tellus. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Quisque velit nisi, pretium ut lacinia in, elementum id enim. Nulla quis lorem ut libero malesuada feugiat. Praesent sapien massa, convallis a pellentesque nec, egestas non nisi. Donec sollicitudin molestie malesuada. Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Curabitur aliquet quam id dui posuere blandit. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Quisque velit nisi, pretium ut lacinia in, elementum id enim.'),
(22, 'LP 3 Analyste', '2012-01-01 00:00:00', 'Curabitur arcu erat, accumsan id imperdiet et, porttitor at sem. Vivamus suscipit tortor eget felis porttitor volutpat. Donec sollicitudin molestie malesuada. Cras ultricies ligula sed magna dictum porta. Donec sollicitudin molestie malesuada. Curabitur non nulla sit amet nisl tempus convallis quis ac lectus. Pellentesque in ipsum id orci porta dapibus. Vestibulum ac diam sit amet quam vehicula elementum sed sit amet dui. Sed porttitor lectus nibh. Pellentesque in ipsum id orci porta dapibus.');

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

--
-- Structure de la table `training`
--

CREATE TABLE `training` (
  `id` int(11) NOT NULL,
  `user_id` int(11) NOT NULL,
  `year_graduation` int(11) NOT NULL,
  `specialty` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
  `establishment` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `level` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `moyenne` varchar(255) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `training`
--

INSERT INTO `training` (`id`, `user_id`, `year_graduation`, `specialty`, `establishment`, `level`, `moyenne`) VALUES
(13, 39, 2013, 'fvq', 'fbfqv', 'Bac+3', '14'),
(14, 40, 2015, 'systems informatiques', 'fsts', 'Bac+5', '12,23'),
(16, 41, 2011, 'kldklflk', 'fdflkl', 'Bac+1', 'dffdfd'),
(17, 42, 2012, 'SC MATH', 'LYCEE MOHAMMED 6', 'Bac+2', '14.78'),
(18, 43, 2013, 'Chimie', 'Sorbone', 'Bac+5', '12'),
(27, 48, 2010, 'gfdg', 'fdgfd', 'Bac+1', '12'),
(28, 14, 2012, 'kldklflk', 'fdflkl', 'Bac', '15'),
(29, 14, 2010, 'kldklflk', 'dffd', 'Bac', '15'),
(30, 14, 2010, 'ddffd', 'fdfdf', 'Bac', '13.5'),
(31, 52, 2016, 'SC PHYSIQUE', 'lycée mao', 'Bac', '10'),
(32, 14, 2012, 'kldklflk', 'fdflkl', 'Bac', '15'),
(33, 14, 1981, 'kldklflk', 'fdflkl', 'Semestre 2 deuxième année bac', '15');

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

--
-- Structure de la table `training_type`
--

CREATE TABLE `training_type` (
  `id` int(11) NOT NULL,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `training_type`
--

INSERT INTO `training_type` (`id`, `name`) VALUES
(5, 'Formation continue'),
(6, 'Formation initiale');

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

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

CREATE TABLE `users` (
  `id` int(11) NOT NULL,
  `nationality_id` int(11) NOT NULL,
  `email` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `email_canonical` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `enabled` tinyint(1) NOT NULL,
  `salt` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
  `password` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `locked` tinyint(1) NOT NULL,
  `expired` tinyint(1) NOT NULL,
  `expires_at` datetime DEFAULT NULL,
  `confirmation_token` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `password_requested_at` datetime DEFAULT NULL,
  `roles` longtext COLLATE utf8_unicode_ci NOT NULL COMMENT '(DC2Type:array)',
  `credentials_expired` tinyint(1) NOT NULL,
  `credentials_expire_at` datetime DEFAULT NULL,
  `first_name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `last_name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `cin` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `cne` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `address` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
  `phoneNumber` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `place_birth` varchar(45) COLLATE utf8_unicode_ci DEFAULT NULL,
  `birth_date` datetime NOT NULL,
  `role` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `username` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `username_canonical` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `created_at` datetime DEFAULT NULL,
  `updated_at` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `users`
--

INSERT INTO `users` (`id`, `nationality_id`, `email`, `email_canonical`, `enabled`, `salt`, `password`, `last_login`, `locked`, `expired`, `expires_at`, `confirmation_token`, `password_requested_at`, `roles`, `credentials_expired`, `credentials_expire_at`, `first_name`, `last_name`, `cin`, `cne`, `address`, `phoneNumber`, `place_birth`, `birth_date`, `role`, `username`, `username_canonical`, `created_at`, `updated_at`) VALUES
(14, 1, 'ouchayan.h@gmail.com', 'ouchayan.h@gmail.com', 1, '1srjamcxm0cgwkcwww0k4oow4cso480', '$2y$13$1srjamcxm0cgwkcwww0k4e/./l/x5xqQfh2WVgMcIAl86VPSBXx7.', '2017-03-28 18:38:11', 0, 0, NULL, '5jlVFPPNIaXalo0p3JsIpcDeRkJsoLoNTCzUbYD0a4w', '2017-03-21 11:06:31', 'a:0:{}', 0, NULL, 'ouchayankkj', 'hamid', '123', NULL, 'kfdklfdkl', 'fdlkkldfdd', 'casablanca', '2017-01-31 00:00:00', 'student', NULL, '', NULL, NULL),
(37, 2, 'abdellahbenidder@gmail.com', 'abdellahbenidder@gmail.com', 1, '4ohe2gbkgd2cw84csks0kggs0c0owgs', '$2y$13$4ohe2gbkgd2cw84csks0ke/NzMa/sK8UYRulub4PP.5zvhReTQ286', '2017-03-17 18:19:44', 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, 'abdo', 'abdo', 'aaaa', 'aaaa', 'fdfd', 'fdf', 'casablanca', '2017-03-15 00:00:00', 'student', NULL, '', NULL, NULL),
(39, 1, 'rachid.ouelciad@gmail.com', 'rachid.ouelciad@gmail.com', 1, 'fdr9fz2903cw40cog804ws4c0sscwg4', '$2y$13$fdr9fz2903cw40cog804wer5xwU68seTvg0G1Gbaj.OtGjZ2BVZWW', '2017-03-17 18:27:58', 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, 'oulcaid', 'rachid', '123ddd', '123456', 'AllÃ©e des parcs', '0642443512', 'lkfd  kldfk dfkl', '2017-03-15 00:00:00', 'student', NULL, '', NULL, NULL),
(40, 1, 'yassir3d@gmail.com', 'yassir3d@gmail.com', 1, 'pssi592cmj48w40kg0scco4o8owco0w', '$2y$13$pssi592cmj48w40kg0sccephoAkwPYITwyTX4lXQFWVyrTIJV.8IC', '2017-03-17 20:17:49', 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, 'filali', 'yassir', 'sh133252', '101032546', 'casablanca', '0621363253', 'ouarzazate', '1990-08-16 00:00:00', 'student', NULL, '', NULL, NULL),
(41, 2, 'h.ouchayan@labs-it.com', 'h.ouchayan@labs-it.com', 1, '3rartw5nm8aosgwgsc0g4sw0gkk0gsc', '$2y$13$3rartw5nm8aosgwgsc0g4eeedJgEZyvEGsW5O.OkR8CzS9zwbezkC', '2017-03-17 21:10:25', 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, 'ouchayan', 'hamid', '12345', '12345', 'Allée des parcs', '0642443512', 'lkfd  kldfk dfkl', '2017-03-07 00:00:00', 'student', NULL, '', NULL, NULL),
(42, 2, 'alo.mohamed@gmail.com', 'alo.mohamed@gmail.com', 1, '23y3itatsmrog08k00kskws8s888kcg', '$2y$13$23y3itatsmrog08k00ksku1W3MbGo04t7QQTivzoOAwRrmn0z1jZW', '2017-03-18 01:08:46', 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, 'ALAOUI', 'MOHAMED', 'P230220', '12345678', 'casablanca', '0661570569', 'CASA', '2016-05-05 00:00:00', 'student', NULL, '', NULL, NULL),
(43, 2, 'ncsedition@gmail.com', 'ncsedition@gmail.com', 1, '36vwinpviqw488s48wgkcswskssgokw', '$2y$13$36vwinpviqw488s48wgkceOrEbadczmxTmivUWr.n/gzBFCZNpVsa', '2017-03-19 12:44:57', 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, 'Bernard', 'Jack', 'BE000000', '222222', 'Kalvovegen 11', '+46735624280', 'Fes', '2017-03-10 00:00:00', 'student', NULL, '', NULL, NULL),
(44, 2, 'ouchayan.h@gmail.comdsdsddsdsds', 'ouchayan.h@gmail.comdsdsddsdsds', 1, 'jhi3ql78vcowcc88sgw0wswks4gwkgg', '$2y$13$jhi3ql78vcowcc88sgw0weX2HTdLMRQuZB3A9qQQseEbUabOGW9Wy', '2017-03-21 11:27:06', 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, 'fjkfdjkjkdffdf', 'jkdfkjdfkj', 'sdklsklsd', 'dfklfdlfkdkfldfkld', 'flkdklfdlkdffddfdfd', '0642443512', 'casablanca', '2017-03-03 00:00:00', 'student', NULL, '', '2017-03-19 23:10:20', NULL),
(45, 1, 'b.seddouki@ueuromed.org', 'b.seddouki@ueuromed.org', 1, 'f8lcwlr8fvkk408c00scssg44404s8o', '$2y$13$f8lcwlr8fvkk408c00scseL1Gj/.0W/C2HJC/r/OaHt2h8HvpxfYi', '2017-03-20 13:00:35', 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, 'SEDDOUKI', 'Brahim', 'c456587', '125487879', 'Rue zohour', '0658987883', 'Fès', '1990-01-01 00:00:00', 'student', NULL, '', '2017-03-20 10:14:00', NULL),
(46, 3, 'ouchayan.h@gmail.comdfdf', 'ouchayan.h@gmail.comdfdf', 1, 'nnszdys0cqo04g444g0osg884wkw04w', '$2y$13$nnszdys0cqo04g444g0osevZl7K1pWyjPEy9GHktDBTf8AcBTxIAy', NULL, 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, 'lmlmfdlm', 'vclmvcml', '123fdfdf', '12345ffdfd', 'Allée des parcs', '0642445323', 'lkfd  kldfk dfkl', '2017-03-14 00:00:00', 'student', NULL, '', '2017-03-21 11:09:58', NULL),
(47, 3, 'y.chaoui@ueuromed.org', 'y.chaoui@ueuromed.org', 1, 'adv29p7bumg4840g0g0osggcowwgw80', '$2y$13$adv29p7bumg4840g0g0oseM53z79PZUzPyILCNR3MMEx4SzpICl0K', '2017-03-21 19:47:25', 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, 'dhdhd', 'cccc', 'dhhddh', 'ddddf', 'fff', 'eeddd', 'dds', '1991-02-01 00:00:00', 'student', NULL, '', '2017-03-21 19:38:28', NULL),
(48, 1, 'alo.mohamed1986@gmail.com', 'alo.mohamed1986@gmail.com', 1, 'n0zugaby4eoc4s0wc4w8o884s84g0sk', '$2y$13$n0zugaby4eoc4s0wc4w8ou.HufhM5TLnxzGwHPL2G4quusvSSJxee', '2017-03-24 17:48:25', 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, 'ala', 'moha', 'p232323', '12345687', 'casa', '+212661545434', 'oua', '1980-01-01 00:00:00', 'student', NULL, '', '2017-03-23 20:00:32', NULL),
(49, 2, 'ouchayan.h@gmail.dt', 'ouchayan.h@gmail.dt', 0, 'r6rzhdpzfdc8kcwk4kc00o84kc4ok44', NULL, NULL, 0, 0, NULL, 'YylQnP9QTcIBAwp6igYPdmj6zSo28i4BTkLt-cX2DTw', NULL, 'a:0:{}', 0, NULL, 'dfklfdkl', 'lflfklfdlk', '123123231', '123456432', 'klfklfkl', 'klvklkl', 'lkfd  kldfk dfkl', '2017-03-02 00:00:00', 'student', NULL, '', '2017-03-24 10:47:38', NULL),
(50, 1, 'h.ouchayan@1labs-it.com', 'h.ouchayan@1labs-it.com', 0, 'bz2hskkm48gs480o8o880s8008gsgo0', NULL, NULL, 0, 0, NULL, '73WkRkd04Uu4nVaM-C7raYmRaw0CCL9ThFXhlx7W-KA', NULL, 'a:0:{}', 0, NULL, 'ouchayan', 'hamid', '123456789', '123456789', 'Allée des parcs', '0642443512', 'casablanca', '2015-05-07 00:00:00', 'student', NULL, '', '2017-03-24 16:39:01', NULL),
(51, 7, 'a.safouane@ueuromed.org', 'a.safouane@ueuromed.org', 1, 'i3aek0vptwggwcs4kosgc8gccsoskko', '$2y$13$i3aek0vptwggwcs4kosgcud1iBDgcbUEbWQ6SgeQ1nb4xpcWlfthi', NULL, 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, 'SAFOUANE', 'ABDELLATIF', 'CD34345', '1111111111111', 'UEMF', '0661354015', 'FES', '1966-03-11 00:00:00', 'student', NULL, '', '2017-03-26 11:30:36', NULL),
(52, 1, 'a.safouane@gmail.com', 'a.safouane@gmail.com', 1, 'lyhwcstii4gwsg8o8ckcs40wsscw0o0', '$2y$13$lyhwcstii4gwsg8o8ckcsuUGjnBYrUtsMk3ADmLrR2zSuhbLPMhcO', '2017-03-27 11:29:52', 0, 0, NULL, NULL, NULL, 'a:0:{}', 0, NULL, 'AAAA', 'BBBB', 'cv124578', '4564564565', 'CCCC', '0661354015', 'fès', '2000-01-01 00:00:00', 'student', NULL, '', '2017-03-27 11:25:32', NULL);

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

--
-- Structure de la table `user_diploma_type`
--

CREATE TABLE `user_diploma_type` (
  `user_id` int(11) NOT NULL,
  `diploma_type_id` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Contenu de la table `user_diploma_type`
--

INSERT INTO `user_diploma_type` (`user_id`, `diploma_type_id`) VALUES
(14, 1),
(14, 2),
(14, 4),
(37, 1),
(37, 2),
(39, 1),
(39, 2),
(40, 1),
(40, 2),
(41, 2),
(42, 1),
(42, 2),
(43, 2),
(44, 2),
(44, 4),
(45, 1),
(45, 2),
(46, 2),
(48, 2),
(48, 4),
(49, 1),
(49, 2),
(50, 1),
(50, 2),
(50, 4),
(51, 4),
(52, 1);

--
-- Index pour les tables exportées
--

--
-- Index pour la table `application`
--
ALTER TABLE `application`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_A45BDDC1A76ED395` (`user_id`),
  ADD KEY `IDX_A45BDDC1591CC992` (`course_id`);

--
-- Index pour la table `autorisations`
--
ALTER TABLE `autorisations`
  ADD PRIMARY KEY (`role_id`,`fonctionnalite_id`),
  ADD KEY `IDX_3AB39F8FD60322AC` (`role_id`),
  ADD KEY `IDX_3AB39F8F4477C5D8` (`fonctionnalite_id`);

--
-- Index pour la table `course`
--
ALTER TABLE `course`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_169E6FB9A99ACEB5` (`diploma_id`);

--
-- Index pour la table `course_document_type`
--
ALTER TABLE `course_document_type`
  ADD PRIMARY KEY (`course_id`,`document_type_id`),
  ADD KEY `IDX_E8E79F63591CC992` (`course_id`),
  ADD KEY `IDX_E8E79F6361232A4F` (`document_type_id`);

--
-- Index pour la table `diploma`
--
ALTER TABLE `diploma`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_EC218957C32A47EE` (`school_id`),
  ADD KEY `IDX_EC218957BA7133F4` (`school_field_id`),
  ADD KEY `IDX_EC218957D2BDC45D` (`diploma_type_id`),
  ADD KEY `IDX_EC21895718721C9D` (`training_type_id`);

--
-- Index pour la table `diploma_type`
--
ALTER TABLE `diploma_type`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_DD5D6F5E237E06` (`name`);

--
-- Index pour la table `document`
--
ALTER TABLE `document`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_D8698A76A76ED395` (`user_id`),
  ADD KEY `IDX_D8698A7661232A4F` (`document_type_id`),
  ADD KEY `IDX_D8698A763E030ACD` (`application_id`);

--
-- Index pour la table `document_type`
--
ALTER TABLE `document_type`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_2B6ADBBA5E237E06` (`name`);

--
-- Index pour la table `fonctionnalites`
--
ALTER TABLE `fonctionnalites`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_6386856277153098` (`code`);

--
-- Index pour la table `nationality`
--
ALTER TABLE `nationality`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_8AC58B705E237E06` (`name`);

--
-- Index pour la table `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_B63E2EC7A4D60759` (`libelle`);

--
-- Index pour la table `school`
--
ALTER TABLE `school`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_F99EDABB5E237E06` (`name`);

--
-- Index pour la table `school_field`
--
ALTER TABLE `school_field`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_850FF3425E237E06` (`name`);

--
-- Index pour la table `training`
--
ALTER TABLE `training`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_D5128A8FA76ED395` (`user_id`);

--
-- Index pour la table `training_type`
--
ALTER TABLE `training_type`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_8344106A5E237E06` (`name`);

--
-- Index pour la table `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_1483A5E9A0D96FBF` (`email_canonical`),
  ADD UNIQUE KEY `UNIQ_1483A5E9ABE530DA` (`cin`),
  ADD UNIQUE KEY `UNIQ_1483A5E973767F95` (`cne`),
  ADD KEY `IDX_1483A5E91C9DA55` (`nationality_id`);

--
-- Index pour la table `user_diploma_type`
--
ALTER TABLE `user_diploma_type`
  ADD PRIMARY KEY (`user_id`,`diploma_type_id`),
  ADD KEY `IDX_8011216DA76ED395` (`user_id`),
  ADD KEY `IDX_8011216DD2BDC45D` (`diploma_type_id`);

--
-- AUTO_INCREMENT pour les tables exportées
--

--
-- AUTO_INCREMENT pour la table `application`
--
ALTER TABLE `application`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;
--
-- AUTO_INCREMENT pour la table `course`
--
ALTER TABLE `course`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;
--
-- AUTO_INCREMENT pour la table `diploma`
--
ALTER TABLE `diploma`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=23;
--
-- AUTO_INCREMENT pour la table `diploma_type`
--
ALTER TABLE `diploma_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT pour la table `document`
--
ALTER TABLE `document`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=142;
--
-- AUTO_INCREMENT pour la table `document_type`
--
ALTER TABLE `document_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;
--
-- AUTO_INCREMENT pour la table `fonctionnalites`
--
ALTER TABLE `fonctionnalites`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;
--
-- AUTO_INCREMENT pour la table `nationality`
--
ALTER TABLE `nationality`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=252;
--
-- AUTO_INCREMENT pour la table `roles`
--
ALTER TABLE `roles`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;
--
-- AUTO_INCREMENT pour la table `school`
--
ALTER TABLE `school`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;
--
-- AUTO_INCREMENT pour la table `school_field`
--
ALTER TABLE `school_field`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=26;
--
-- AUTO_INCREMENT pour la table `training`
--
ALTER TABLE `training`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=34;
--
-- AUTO_INCREMENT pour la table `training_type`
--
ALTER TABLE `training_type`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;
--
-- AUTO_INCREMENT pour la table `users`
--
ALTER TABLE `users`
  MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=53;
--
-- Contraintes pour les tables exportées
--

--
-- Contraintes pour la table `application`
--
ALTER TABLE `application`
  ADD CONSTRAINT `FK_A45BDDC1591CC992` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`),
  ADD CONSTRAINT `FK_A45BDDC1A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Contraintes pour la table `autorisations`
--
ALTER TABLE `autorisations`
  ADD CONSTRAINT `FK_3AB39F8F4477C5D8` FOREIGN KEY (`fonctionnalite_id`) REFERENCES `fonctionnalites` (`id`),
  ADD CONSTRAINT `FK_3AB39F8FD60322AC` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`);

--
-- Contraintes pour la table `course`
--
ALTER TABLE `course`
  ADD CONSTRAINT `FK_169E6FB9A99ACEB5` FOREIGN KEY (`diploma_id`) REFERENCES `diploma` (`id`);

--
-- Contraintes pour la table `course_document_type`
--
ALTER TABLE `course_document_type`
  ADD CONSTRAINT `FK_E8E79F63591CC992` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`),
  ADD CONSTRAINT `FK_E8E79F6361232A4F` FOREIGN KEY (`document_type_id`) REFERENCES `document_type` (`id`);

--
-- Contraintes pour la table `diploma`
--
ALTER TABLE `diploma`
  ADD CONSTRAINT `FK_EC21895718721C9D` FOREIGN KEY (`training_type_id`) REFERENCES `training_type` (`id`),
  ADD CONSTRAINT `FK_EC218957BA7133F4` FOREIGN KEY (`school_field_id`) REFERENCES `school_field` (`id`),
  ADD CONSTRAINT `FK_EC218957C32A47EE` FOREIGN KEY (`school_id`) REFERENCES `school` (`id`),
  ADD CONSTRAINT `FK_EC218957D2BDC45D` FOREIGN KEY (`diploma_type_id`) REFERENCES `diploma_type` (`id`);

--
-- Contraintes pour la table `document`
--
ALTER TABLE `document`
  ADD CONSTRAINT `FK_D8698A763E030ACD` FOREIGN KEY (`application_id`) REFERENCES `application` (`id`),
  ADD CONSTRAINT `FK_D8698A7661232A4F` FOREIGN KEY (`document_type_id`) REFERENCES `document_type` (`id`),
  ADD CONSTRAINT `FK_D8698A76A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Contraintes pour la table `training`
--
ALTER TABLE `training`
  ADD CONSTRAINT `FK_D5128A8FA76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`);

--
-- Contraintes pour la table `users`
--
ALTER TABLE `users`
  ADD CONSTRAINT `FK_1483A5E91C9DA55` FOREIGN KEY (`nationality_id`) REFERENCES `nationality` (`id`);

--
-- Contraintes pour la table `user_diploma_type`
--
ALTER TABLE `user_diploma_type`
  ADD CONSTRAINT `FK_8011216DA76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  ADD CONSTRAINT `FK_8011216DD2BDC45D` FOREIGN KEY (`diploma_type_id`) REFERENCES `diploma_type` (`id`);
