--
-- Host: localhost    Database: uemf
-- ------------------------------------------------------


--
-- Table structure for table `application`
--

CREATE TABLE `application` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  KEY `IDX_A45BDDC1A76ED395` (`user_id`),
  KEY `IDX_A45BDDC1591CC992` (`course_id`),
  CONSTRAINT `FK_A45BDDC1591CC992` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`),
  CONSTRAINT `FK_A45BDDC1A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `application`
--

INSERT INTO `application` 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);
/*!40000 ALTER TABLE `application` IAVBLE KEYS */;

--
-- Table structure for table `course`
--

CREATE TABLE `course` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `diploma_id` int(11) NOT NULL,
  `name` varchar(45) COLLATE utf8_unicode_ci NOT NULL,
  `conditions` longtext COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_169E6FB9A99ACEB5` (`diploma_id`),
  CONSTRAINT `FK_169E6FB9A99ACEB5` FOREIGN KEY (`diploma_id`) REFERENCES `diploma` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `course`
--

INSERT INTO `course` 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.');
/*!40000 ALTER TABLE `course` IAVBLE KEYS */;

--
-- Table structure for table `course_document_type`
--

CREATE TABLE `course_document_type` (
  `course_id` int(11) NOT NULL,
  `document_type_id` int(11) NOT NULL,
  PRIMARY KEY (`course_id`,`document_type_id`),
  KEY `IDX_E8E79F63591CC992` (`course_id`),
  KEY `IDX_E8E79F6361232A4F` (`document_type_id`),
  CONSTRAINT `FK_E8E79F63591CC992` FOREIGN KEY (`course_id`) REFERENCES `course` (`id`),
  CONSTRAINT `FK_E8E79F6361232A4F` FOREIGN KEY (`document_type_id`) REFERENCES `document_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `course_document_type`
--

INSERT INTO `course_document_type` 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);
/*!40000 ALTER TABLE `course_document_type` IAVBLE KEYS */;

--
-- Table structure for table `diploma`
--

CREATE TABLE `diploma` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  KEY `IDX_EC218957C32A47EE` (`school_id`),
  KEY `IDX_EC218957BA7133F4` (`school_field_id`),
  KEY `IDX_EC218957D2BDC45D` (`diploma_type_id`),
  KEY `IDX_EC21895718721C9D` (`training_type_id`),
  CONSTRAINT `FK_EC21895718721C9D` FOREIGN KEY (`training_type_id`) REFERENCES `training_type` (`id`),
  CONSTRAINT `FK_EC218957BA7133F4` FOREIGN KEY (`school_field_id`) REFERENCES `school_field` (`id`),
  CONSTRAINT `FK_EC218957C32A47EE` FOREIGN KEY (`school_id`) REFERENCES `school` (`id`),
  CONSTRAINT `FK_EC218957D2BDC45D` FOREIGN KEY (`diploma_type_id`) REFERENCES `diploma_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `diploma`
--

INSERT INTO `diploma` VALUES (1,1,1,4,6,2017),(2,2,2,4,6,2017),(3,2,3,1,6,2017),(4,3,4,1,6,2017),(5,4,9,2,6,2017),(6,4,8,2,6,2017),(7,4,6,1,6,2017),(8,4,5,1,6,2017),(9,4,10,2,5,2017),(10,4,11,2,6,2017),(11,4,7,1,6,2017),(12,5,12,4,6,2017),(13,5,13,4,6,2017),(14,6,14,2,6,2017),(15,6,15,2,6,2017),(16,6,16,2,6,2017),(17,6,17,2,6,2017),(18,6,18,2,6,2017),(19,6,19,1,6,2017),(20,6,20,1,6,2017),(21,6,21,1,6,2017),(22,6,22,1,6,2017);
/*!40000 ALTER TABLE `diploma` IAVBLE KEYS */;

--
-- Table structure for table `diploma_type`
--

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

--
-- Dumping data for table `diploma_type`
--

INSERT INTO `diploma_type` VALUES (1,'Licence','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.'),(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.');
/*!40000 ALTER TABLE `diploma_type` IAVBLE KEYS */;

--
-- Table structure for table `document`
--

CREATE TABLE `document` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  KEY `IDX_D8698A76A76ED395` (`user_id`),
  KEY `IDX_D8698A7661232A4F` (`document_type_id`),
  KEY `IDX_D8698A763E030ACD` (`application_id`),
  CONSTRAINT `FK_D8698A763E030ACD` FOREIGN KEY (`application_id`) REFERENCES `application` (`id`),
  CONSTRAINT `FK_D8698A7661232A4F` FOREIGN KEY (`document_type_id`) REFERENCES `document_type` (`id`),
  CONSTRAINT `FK_D8698A76A76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=142 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `document`
--

INSERT INTO `document` 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');
/*!40000 ALTER TABLE `document` IAVBLE KEYS */;

--
-- Table structure for table `document_type`
--

CREATE TABLE `document_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_2B6ADBBA5E237E06` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `document_type`
--

INSERT INTO `document_type` VALUES (1,'CIN (Carte d\'identité nationale)','cin',0,12),(2,'Attestation d\'Inscription','attestation_Inscription',0,NULL),(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);
/*!40000 ALTER TABLE `document_type` IAVBLE KEYS */;

--
-- Table structure for table `nationality`
--

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

--
-- Dumping data for table `nationality`
--

INSERT INTO `nationality` VALUES (8,'Autre'),(2,'Béninoise'),(3,'Burkinabaise'),(4,'Cameroun'),(5,'Gabonaise'),(6,'Ivoirienne'),(7,'Malienne'),(1,'Marocaine');
/*!40000 ALTER TABLE `nationality` IAVBLE KEYS */;

--
-- Table structure for table `school`
--

CREATE TABLE `school` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) 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,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_F99EDABB5E237E06` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `school`
--

INSERT INTO `school` VALUES (1,'EMADU','EMADU','EMADU','2017-03-13 11:46:00',NULL),(2,'IEMSP','IEMSP','IEMSP','2017-03-13 13:57:00',NULL),(3,'EBS','EBS','EBS','2017-03-15 13:40:00',NULL),(4,'FEMSHS','FEMSHS','FEMSHS','2017-03-17 23:21:00',NULL),(5,'EEMGC','EEMGC','EEMGC','2017-03-24 16:55:00',NULL),(6,'FEMG','FEMG','FEMG','2017-03-24 16:56:00',NULL);
/*!40000 ALTER TABLE `school` IAVBLE KEYS */;

--
-- Table structure for table `school_field`
--

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

--
-- Dumping data for table `school_field`
--

INSERT INTO `school_field` VALUES (1,'Architecture','2012-01-01 00:00:00','Praesent 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, pretium 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.');
/*!40000 ALTER TABLE `school_field` IAVBLE KEYS */;

--
-- Table structure for table `training`
--

CREATE TABLE `training` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `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,
  PRIMARY KEY (`id`),
  KEY `IDX_D5128A8FA76ED395` (`user_id`),
  CONSTRAINT `FK_D5128A8FA76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `training`
--

INSERT INTO `training` 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');
/*!40000 ALTER TABLE `training` IAVBLE KEYS */;

--
-- Table structure for table `training_type`
--

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

--
-- Dumping data for table `training_type`
--

INSERT INTO `training_type` VALUES (5,'Formation continue'),(6,'Formation initiale');
/*!40000 ALTER TABLE `training_type` IAVBLE KEYS */;

--
-- Table structure for table `user_diploma_type`
--

CREATE TABLE `user_diploma_type` (
  `user_id` int(11) NOT NULL,
  `diploma_type_id` int(11) NOT NULL,
  PRIMARY KEY (`user_id`,`diploma_type_id`),
  KEY `IDX_8011216DA76ED395` (`user_id`),
  KEY `IDX_8011216DD2BDC45D` (`diploma_type_id`),
  CONSTRAINT `FK_8011216DA76ED395` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`),
  CONSTRAINT `FK_8011216DD2BDC45D` FOREIGN KEY (`diploma_type_id`) REFERENCES `diploma_type` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

--
-- Dumping data for table `user_diploma_type`
--

INSERT INTO `user_diploma_type` 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);
/*!40000 ALTER TABLE `user_diploma_type` IAVBLE KEYS */;


