
--
-- Table structure for table `formation_formatting`
--

CREATE TABLE `formation_formatting` (
  `id` int NOT NULL AUTO_INCREMENT,
  `formation_id` int NOT NULL,
  `bg_color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `font_style` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `font_size` int DEFAULT NULL,
  `color` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `font_mode` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `type` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_41CD5835200282E` (`formation_id`),
  CONSTRAINT `FK_41CD5835200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `formation_formatting`
--

INSERT INTO `formation_formatting` VALUES (1,13,'#000000','Time new roman',22,'#ff0000','bold, italic','moduleGroup'),(2,13,'#fbcb89',NULL,NULL,'#007bff',NULL,'module'),(3,13,'#fc0303',NULL,40,'#78e010',NULL,'lesson'),(4,13,'#ffffff',NULL,NULL,'#000000',NULL,'phase'),(5,13,'#ffffff',NULL,NULL,'#000000',NULL,'exercisesGroup'),(6,13,'#ffffff',NULL,NULL,'#000000',NULL,'exercise'),(7,13,'#ffffff',NULL,NULL,'#000000',NULL,'exerciseItem'),(8,13,NULL,NULL,NULL,NULL,NULL,'skills'),(9,16,'#000599','Time new roman',24,'#00ff88','italic, bold, underline','moduleGroup'),(10,16,'#ad5858','Time new roman',18,'#ff8a8a','bold, underline','module'),(11,16,'#ff7070','polaris',16,'#005e75','italic','lesson'),(12,16,'#8f0000','Time new roman',15,'#ffea00','bold','phase'),(13,16,'#ffffff',NULL,NULL,'#000000',NULL,'exercisesGroup'),(14,16,'#000000','polaris',14,'#f100f5','underline','exercise'),(15,16,'#000000','Time new roman',13,'#ffffff','bold, italic','exerciseItem'),(16,16,NULL,NULL,NULL,NULL,NULL,'skills'),(17,51,'#000000',NULL,NULL,'#ff0000',NULL,'moduleGroup'),(18,51,'#fbcb89',NULL,NULL,'#007bff',NULL,'module'),(19,51,'#ffe0e0',NULL,NULL,'#78e010',NULL,'lesson'),(20,51,'#80ffce','Time new roman',20,'#ff0000','italic','phase'),(21,51,'#ffffff',NULL,NULL,'#000000',NULL,'exercisesGroup'),(22,51,'#ffea00','polaris',17,'#0084ff','underline','exercise'),(23,51,'#ffffff',NULL,NULL,'#000000',NULL,'exerciseItem'),(24,51,NULL,NULL,NULL,NULL,NULL,'skills');

--
-- Table structure for table `formation_item`
--

CREATE TABLE `formation_item` (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int DEFAULT NULL,
  `formation_id` int DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `standard_duration` int DEFAULT NULL,
  `max_duration` int DEFAULT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `goals` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `position` int NOT NULL,
  `extra_lesson_id` int DEFAULT NULL,
  `config_isexpended` tinyint(1) DEFAULT NULL,
  `formation_item_from_list_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `notation_id` int DEFAULT NULL,
  `min_rating_id` int DEFAULT NULL,
  `classroom_id` int DEFAULT NULL,
  `subname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `is_theoretical` tinyint(1) DEFAULT NULL,
  `min_visibility` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `min_weather` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `ceiling` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `technical_ref` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `groupe` tinyint(1) DEFAULT NULL,
  `is_important` tinyint(1) DEFAULT NULL,
  `expected_value_id` int DEFAULT NULL,
  `expected_duration` int DEFAULT NULL,
  `time` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_48C4C05E727ACA70` (`parent_id`),
  KEY `IDX_48C4C05E5200282E` (`formation_id`),
  KEY `IDX_48C4C05E3FD4DD80` (`extra_lesson_id`),
  KEY `IDX_48C4C05E9680B7F7` (`notation_id`),
  KEY `IDX_48C4C05E55D631A8` (`min_rating_id`),
  KEY `IDX_48C4C05E6278D5A8` (`classroom_id`),
  KEY `IDX_48C4C05EB0E02586` (`expected_value_id`),
  CONSTRAINT `FK_48C4C05E3FD4DD80` FOREIGN KEY (`extra_lesson_id`) REFERENCES `extra_lesson` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_48C4C05E5200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_48C4C05E55D631A8` FOREIGN KEY (`min_rating_id`) REFERENCES `rating_value` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_48C4C05E6278D5A8` FOREIGN KEY (`classroom_id`) REFERENCES `classroom` (`id`),
  CONSTRAINT `FK_48C4C05E727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `formation_item` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_48C4C05E9680B7F7` FOREIGN KEY (`notation_id`) REFERENCES `rating` (`id`),
  CONSTRAINT `FK_48C4C05EB0E02586` FOREIGN KEY (`expected_value_id`) REFERENCES `rating_value` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=551 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `formation_item`
--

INSERT INTO `formation_item` VALUES (41,NULL,2,'Module',0,0,'item_module','','',0,NULL,1,'clg6zi4kq000i356iny4npmqv',27,NULL,NULL,'',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,900,NULL),(46,41,NULL,'Leçon',0,0,'item_lesson','','',0,NULL,1,'clg2s31m40005356ieraloz8c',27,NULL,NULL,NULL,1,'','','','',0,NULL,NULL,900,NULL),(47,41,NULL,'Leçon 2',0,0,'item_lesson','','',1,NULL,1,'clg2s34mi000b356iuaf9qjzt',27,NULL,NULL,NULL,1,'','','','',0,NULL,NULL,NULL,NULL),(48,46,NULL,'Abbréviation',0,0,'item_phase','','',0,NULL,1,'clg9s49sl0008356eww3ft4xv',27,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,47,NULL,'Abbréviation',0,0,'item_phase','','',0,NULL,1,'clg9s49sl0008356eww3ft4xv',27,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,48,NULL,'Exercice',0,0,'item_exercise','','',0,NULL,NULL,'clg2s3d1m002o356itnkv5nt5',27,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,49,NULL,'Exercice',0,0,'item_exercise','','',0,NULL,NULL,'clg2s3d1m002o356itnkv5nt5',27,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(56,NULL,13,'Groupe module',0,0,'item_modules_group','','',0,NULL,1,'clgcs98si0001356i8a2gjx7t',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1080,NULL),(57,58,NULL,'Exercice',0,0,'item_exercise','test','test',0,NULL,NULL,'clgb31ywu001x356i88tnm1ow',36,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(58,59,NULL,'Abbréviation',0,0,'item_phase','','',0,NULL,1,'clgb31j4w0000356iqkxb4wmb',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,912),(59,61,NULL,'Leçon',0,0,'item_lesson','test','test',0,NULL,1,'clgb31s9x000i356iijvueanh',31,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(60,62,NULL,'Leçon 2',0,0,'item_lesson','','',0,NULL,1,'clgcsa4al008a356i63y9xltq',31,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,180,NULL),(61,56,NULL,'Module',0,0,'item_module','','',0,NULL,1,'clgb31oe40003356in789uhg8',31,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,900,NULL),(62,56,NULL,'Module 2',0,0,'item_module','','',1,NULL,1,'clgcs9ww7005m356ifv8l4dcu',31,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,300,NULL),(63,NULL,14,'Leçon',0,0,'item_lesson','Description Leçon','ObjectifsLeçon',0,NULL,NULL,'clgqbzfjg0001356ixn93vw8h',28,NULL,NULL,NULL,0,'','','','',0,NULL,32,600,900),(64,NULL,15,'Leçon ',0,0,'item_lesson','Description leçon','Objectif leçon',0,NULL,NULL,'clgqcl3200001356g5kp1qtej',29,NULL,NULL,NULL,0,'','','','',0,NULL,33,900,1200),(65,58,NULL,'Exercice 2',0,0,'item_exercise','test 2','test 2',1,NULL,NULL,'clgqkezv5000n356ggjl2owgd',28,32,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(66,68,NULL,'Exercice 2',0,0,'item_exercise','','',0,NULL,0,'clgqkezv5000n356ggjl2owgd',31,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,68,NULL,'Exercice',0,0,'item_exercise','','',1,NULL,NULL,'clgqkhbdh0071356g25dsv3mp',31,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(68,60,NULL,'Abbréviation',0,0,'item_phase','','',0,NULL,1,'clgqkeoog000k356gm0ydz3tw',31,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,73,NULL,'Exercice',0,0,'item_exercise','Test','TEst',0,NULL,NULL,'clgqkjiyb00dj356gjla8cnb9',27,29,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,73,NULL,'Exercice 2',0,0,'item_exercise','Test 2','Test 2',1,NULL,NULL,'clgqkjmx700dn356gz3ynrlrt',27,29,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(71,74,NULL,'Exercice 2',0,0,'item_exercise','Test 2','',0,NULL,NULL,'clgqkjmx700dn356gz3ynrlrt',27,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(72,74,NULL,'Exercice 3',0,0,'item_exercise','','',1,NULL,NULL,'clgqkjsll00dt356gwlzvtmcg',27,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(73,NULL,16,'test',0,0,'item_lesson','test','test',0,NULL,1,'clgqkj75f00cd356g02k9gn2j',27,29,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(74,NULL,16,'Leçon 2',0,0,'item_lesson','test 2','test 2',1,NULL,1,'clgqkjbgc00cf356gihwwg3bo',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(75,78,NULL,'l\'exerciceee',0,0,'item_exercise','','',0,3,NULL,'clgxkt43i000d356iv7s49ksc',32,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,78,NULL,'l\'exerciceee 2',0,0,'item_exercise','','',1,3,NULL,'clgxkt680000j356iycsz1vxf',36,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(77,79,NULL,'l\'exerciceee',0,0,'item_exercise','','',0,3,NULL,'clgxkt43i000d356iv7s49ksc',34,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(78,NULL,17,'leçonnn',0,0,'item_lesson','','',0,NULL,1,'clgxksxq20001356i9e5ccjkq',7,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(79,NULL,17,'leçonnn 2',0,0,'item_lesson','','',1,NULL,1,'clgxkt0bz0007356izgmdn69r',32,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(80,83,NULL,'Exercice 1',0,0,'item_exercise','','',0,5,NULL,'clgxq8b6k000z356g07zseoj1',43,64,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,63,NULL,NULL),(81,83,NULL,'Exercice 2',0,0,'item_exercise','','',1,5,NULL,'clgxq8jmq001y356gjh4iy3hk',43,63,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,64,NULL,NULL),(82,84,NULL,'Exercice 2',0,0,'item_exercise','','',0,5,NULL,'clgxq8jmq001y356gjh4iy3hk',43,63,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,63,NULL,NULL),(83,NULL,18,'Leçon 1',0,0,'item_lesson','','',0,NULL,1,'clgxq7jue0001356g742y2ram',41,58,NULL,NULL,0,'','','','',0,NULL,57,NULL,NULL),(84,NULL,18,'Leçon 2',0,0,'item_lesson','','',1,NULL,1,'clgxq7xg30007356g1sp9bxf2',41,57,NULL,NULL,0,'','','','',0,NULL,57,NULL,NULL),(85,88,NULL,'Exercice',0,0,'item_exercise','','',0,NULL,NULL,'clgxsrbn8000g356itwx4p9aq',43,64,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,64,NULL,NULL),(86,89,NULL,'l\'exerciceee 2',0,0,'item_exercise','','',0,NULL,NULL,'clgxsrrug001j356i8u3cspkw',43,64,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,64,NULL,NULL),(87,89,NULL,'Exercice',0,0,'item_exercise','','',1,NULL,NULL,'clgxsrbn8000g356itwx4p9aq',43,64,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,64,NULL,NULL),(88,NULL,19,'efzfzfz',0,0,'item_lesson','','',0,NULL,1,'clgxsr3e00001356iapi0npsl',41,58,NULL,NULL,0,'','','','',0,NULL,58,NULL,NULL),(89,NULL,19,'zefzfzef',0,0,'item_lesson','','',1,NULL,1,'clgxsrjef0012356i1p8ykkvi',41,57,NULL,NULL,0,'','','','',0,NULL,58,NULL,NULL),(90,NULL,19,'test',0,0,'item_lesson','','',2,NULL,0,'clgxtuzxm000e356i0ihhycjj',41,NULL,NULL,NULL,0,'','','','',0,NULL,58,NULL,NULL),(91,NULL,19,'test2',0,0,'item_lesson','','',3,NULL,NULL,'clgxtx0e3000m356gg9nlvqsa',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(99,NULL,21,'MODULEEE',0,0,'item_module','','',0,NULL,1,'clh4rzsuh0005356ij517tzln',41,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,300,NULL),(100,NULL,21,'MODULEEE 2',0,0,'item_module','','',1,NULL,1,'clh4s036t004g356ify5svo6x',41,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,540,NULL),(101,103,NULL,'l\'exerciceee',0,0,'item_exercise','','',0,NULL,NULL,'clgza9xfq000h356iffqwsd7h',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(102,104,NULL,'EXERCICEEE 2',0,0,'item_exercise','','',0,NULL,NULL,'clh4s0h59007d356ict5xx595',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(103,105,NULL,'zfef',0,0,'item_phase','','',0,NULL,1,'clh4rzqb40002356i1ruo61oq',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(104,106,NULL,'CUSTOM PHASEEE',0,0,'item_phase','','',0,NULL,1,'clh4s0d8s006m356i78e60a2c',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(105,99,NULL,'leçonnn',0,0,'item_lesson','','',0,NULL,1,'clgza9s550003356i2tb4k4gv',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(106,100,NULL,'LEÇONNN 2',0,0,'item_lesson','','',0,NULL,1,'clh4s07v7005l356icjfptjl6',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(125,NULL,22,'CUSTOM GROUPE',0,0,'item_modules_group','','',0,NULL,1,'clhajr44r0005356gndo7miqp',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(126,128,NULL,'l\'exerciceee',0,0,'item_exercise','','',0,NULL,NULL,'clhaibi7k0007356igc8bhsk3',42,61,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,60,NULL,NULL),(127,129,NULL,'l\'exerciceee 2',0,0,'item_exercise','','',0,NULL,NULL,'clhaibmcm000u356i9jzgwav9',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,57,NULL,NULL),(128,130,NULL,'d\'exercicesss',0,0,'item_exercises_group','','',0,NULL,1,'clhajdrh8002s356iouraybkw',42,61,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(129,131,NULL,'d\'exercicesss 2',0,0,'item_exercises_group','','',0,NULL,1,'clhajdykk007f356ivw3wpsco',42,60,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(130,132,NULL,'Abbréviation',0,0,'item_phase','','',0,NULL,1,'clhajcp82000i356i8i8mkx4p',42,61,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(131,133,NULL,'Abbréviation',0,0,'item_phase','','',0,NULL,1,'clhajcp82000i356i8i8mkx4p',42,60,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(132,134,NULL,'leçonnn',0,0,'item_lesson','','',0,NULL,1,'clgzazz930001356epi5lr1r3',42,61,NULL,NULL,0,'','','','',0,NULL,60,NULL,NULL),(133,134,NULL,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,1,'clh9bt0wp0003356ilvm2cnwt',42,NULL,NULL,NULL,0,'','','','',0,NULL,60,NULL,NULL),(134,125,NULL,'MODULEEE',0,0,'item_module','','',0,NULL,1,'clhajr7u3000k356g9upwdakh',7,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(135,NULL,20,'CUSTOM GROUPE',0,0,'item_modules_group','','',0,NULL,1,'clhc0xixn0003356g9bbnjmj9',41,58,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(136,137,NULL,'zefzeff',0,0,'item_exercise','','',0,NULL,NULL,'clgz7i3l70001356g0nwjjmoc',42,61,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,60,NULL,NULL),(137,138,NULL,'fzefff',0,0,'item_phase','','',0,NULL,1,'clhc0x5750000356gpg0d84ud',42,61,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(138,139,NULL,'zefefezf',0,0,'item_lesson','','',0,NULL,1,'clgz7i5950007356gorrkrfog',42,61,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(139,135,NULL,'MODULEEE ',0,0,'item_module','','',0,NULL,1,'clhc0xzn8000g356gykxp5z6k',42,61,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(140,137,NULL,'l\'exerciceee',0,0,'item_exercise','','',1,NULL,NULL,'clheq7d7k000f356ixy8v0aor',43,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,63,NULL,NULL),(141,144,NULL,'l\'exerciceee',0,0,'item_exercise','','',0,11,NULL,'clhglycoh000e356ishdt89em',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(142,144,NULL,'l\'exerciceee 2',0,0,'item_exercise','','',1,NULL,NULL,'clhglytah0017356ilwr0m19d',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(143,145,NULL,'l\'exerciceee 2',0,0,'item_exercise','','',0,NULL,NULL,'clhglytah0017356ilwr0m19d',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(144,NULL,23,'leçonnn',0,0,'item_lesson','','',0,NULL,1,'clhgly7mj0001356ix2f4s6qw',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(145,NULL,23,'leçonnn 2',0,0,'item_lesson','','',1,NULL,1,'clhglyydo0027356i5748ajol',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(146,152,NULL,'étapes',0,0,'item_exercise_item','','',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(147,152,NULL,'étapes 2',0,0,'item_exercise_item','','',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(148,152,NULL,'étapes 3',0,0,'item_exercise_item','','',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL),(149,153,NULL,'étapes 3 - 1',0,0,'item_exercise_item','','',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(150,153,NULL,'étapes 3 - 2',0,0,'item_exercise_item','','',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL),(151,153,NULL,'étapes 3 - 3',0,0,'item_exercise_item','','',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL),(152,155,NULL,'EXERCICEEE',0,0,'item_exercise','','',0,NULL,NULL,'clhl1qr9c000z356enzoubj80',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,58,NULL,NULL),(153,155,NULL,'EXERCICEEE 3',0,0,'item_exercise','','',1,NULL,NULL,'clhl1r08h0033356e7f57ney3',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,57,NULL,NULL),(154,156,NULL,'EXERCICEEE 2',0,0,'item_exercise','','',0,NULL,NULL,'clhl1qvlf0028356euuyjrzq2',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,57,NULL,NULL),(155,NULL,24,'LEÇONNN',0,0,'item_lesson','','',0,NULL,1,'clhl1p8rd0001356e0gagffdf',42,NULL,NULL,NULL,0,'','','','',0,NULL,61,NULL,NULL),(156,NULL,24,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,1,'clhl1qm7z000h356ee3g4r4r7',43,NULL,NULL,NULL,0,'','','','',0,NULL,63,NULL,NULL),(157,161,NULL,'LEÇONNN',0,0,'item_exercise','','',0,NULL,NULL,'clhm0pm20000u356elh0jto1p',43,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(158,161,NULL,'LEÇONNN 2',0,0,'item_exercise','','',1,NULL,NULL,'clhm0pped001g356eefwzcqxf',43,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(159,161,NULL,'LEÇONNN 3',0,0,'item_exercise','','',2,NULL,NULL,'clhm0q1cc002i356edmohke1d',43,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(160,162,NULL,'LEÇONNN 2',0,0,'item_exercise','','',0,NULL,NULL,'clhm0pped001g356eefwzcqxf',43,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(161,NULL,25,'LEÇONNN ',0,0,'item_lesson','','',0,NULL,1,'clhm0pevy0001356eygs43jot',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(162,NULL,25,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,1,'clhm0pgwh0007356el0yg71q6',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(163,164,NULL,'EXERCICEEE',0,0,'item_exercise','','',0,16,NULL,'clhn6va900034356e6f5w1aoc',44,67,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,67,NULL,NULL),(164,165,NULL,'LEÇONNN',0,0,'item_lesson','','',0,NULL,1,'clhn6v312002b356eepq4s5x9',41,58,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(165,166,NULL,'MODULEEE',0,0,'item_module','','',0,NULL,1,'clhn6uolw000r356em3ual5z7',42,61,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(166,NULL,26,'CUSTOM GROUPE',0,0,'item_modules_group','','',0,NULL,1,'clhn6u9bm0001356e0hsxuw1m',43,64,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(167,126,NULL,'étapes',0,0,'item_exercise_item','','',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL,NULL,NULL),(168,126,NULL,'étapes 2',0,0,'item_exercise_item','','',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,0,NULL,NULL,NULL),(169,NULL,27,'CUSTOM GROUPE',0,0,'item_modules_group','','',0,NULL,1,'clhqn3nhz0001356e0ajstbye',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(170,NULL,27,'CUSTOM GROUPE 2',0,0,'item_modules_group','','',1,NULL,1,'clhqn3pim0007356edp0umcdy',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(171,169,NULL,'MODULEEE',0,0,'item_module','','',0,NULL,1,'clhqn41qn0016356e42tukvjf',41,NULL,NULL,'',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(172,169,NULL,'MODULEEE 2',0,0,'item_module','','',1,NULL,1,'clhqn45lc001w356e8eb2dwpw',42,NULL,NULL,'',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(173,170,NULL,'MODULEEE',0,0,'item_module','','',0,NULL,1,'clhqn41qn0016356e42tukvjf',43,NULL,NULL,'',1,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(174,171,NULL,'LEÇONNN',0,0,'item_lesson','','',0,NULL,1,'clhqmy6di0001356eu93zts6f',42,NULL,NULL,NULL,1,'','','','',0,NULL,NULL,NULL,NULL),(175,172,NULL,'LEÇONNN 2',0,0,'item_lesson','','',0,NULL,1,'clhqqea8r002j356e6u0yon3g',42,NULL,NULL,NULL,1,'','','','',0,NULL,NULL,NULL,NULL),(176,173,NULL,'LEÇONNN',0,0,'item_lesson','','',0,NULL,1,'clhqmy6di0001356eu93zts6f',43,NULL,NULL,NULL,1,'','','','',0,NULL,NULL,NULL,NULL),(177,173,NULL,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,1,'clhqqea8r002j356e6u0yon3g',43,NULL,NULL,NULL,1,'','','','',0,NULL,NULL,NULL,NULL),(178,174,NULL,'EXERCICEEE',0,0,'item_exercise','','',0,NULL,NULL,'clhqqe1ea000f356emzxoy6ai',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(179,175,NULL,'EXERCICEEE 2',0,0,'item_exercise','','',0,NULL,NULL,'clhqqeqjh0064356esz1swju3',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(180,176,NULL,'EXERCICEEE',0,0,'item_exercise','','',0,NULL,NULL,'clhqqe1ea000f356emzxoy6ai',43,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(181,176,NULL,'EXERCICEEE 3',0,0,'item_exercise','','',1,NULL,NULL,'clhqqexhr007e356e9fgwp1e3',43,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(182,177,NULL,'EXERCICEEE 3',0,0,'item_exercise','','',0,NULL,NULL,'clhqqexhr007e356e9fgwp1e3',43,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(183,186,NULL,'EXERCICEEE',0,0,'item_exercise','','',0,NULL,NULL,'clhruv14g000h356er3t8yq0c',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(184,187,NULL,'EXERCICEEE',0,0,'item_exercise','','',0,NULL,NULL,'clhruv14g000h356er3t8yq0c',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(185,187,NULL,'EXERCICEEE 2',0,0,'item_exercise','','',1,NULL,NULL,'clhruva5f001z356ewam6gdpm',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(186,NULL,28,'LEÇONNN',0,0,'item_lesson','','',0,NULL,1,'clhruuwnd0001356ep4atmwbb',42,NULL,NULL,NULL,1,'','','','',0,NULL,NULL,NULL,NULL),(187,NULL,28,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,1,'clhruv69k001e356eladedkj0',42,NULL,NULL,NULL,1,'','','','',0,NULL,NULL,NULL,NULL),(191,NULL,29,'CUSTOM GROUPE',0,0,'item_modules_group','','',0,NULL,1,'clhthesgs0001356e19r14sqz',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(192,193,NULL,'fzefff',0,0,'item_phase','','',0,NULL,NULL,'clhthslod0000356eul1xfqij',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(193,194,NULL,'LEÇONNN',0,0,'item_lesson','','',0,NULL,1,'clhthf0jp0018356eol9eh9bo',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(194,191,NULL,'MODULEEE',0,0,'item_module','','',0,NULL,1,'clhthewls000g356e4r4lpcdn',NULL,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(195,198,NULL,'EXERCICEEE',0,0,'item_exercise','','',0,NULL,NULL,'clhruv14g000h356er3t8yq0c',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(196,199,NULL,'EXERCICEEE',0,0,'item_exercise','','',0,NULL,NULL,'clhruv14g000h356er3t8yq0c',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(197,199,NULL,'EXERCICEEE 2',0,0,'item_exercise','','',1,NULL,NULL,'clhruva5f001z356ewam6gdpm',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(198,NULL,34,'LEÇONNN',0,0,'item_lesson','','',0,NULL,1,'clhruuwnd0001356ep4atmwbb',42,NULL,NULL,NULL,1,'','','','',0,NULL,NULL,NULL,NULL),(199,NULL,34,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,1,'clhruv69k001e356eladedkj0',42,NULL,NULL,NULL,1,'','','','',0,NULL,NULL,NULL,NULL),(237,241,NULL,'EXERCICEEE',0,0,'item_exercise','','',0,NULL,NULL,'clhzbp7vv00a4356e55njra49',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(238,241,NULL,'EXERCICEEE 3',0,0,'item_exercise','','',1,NULL,NULL,'clhzbpfus00ae356eq3v7mzzg',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(239,242,NULL,'EXERCICEEE 2',0,0,'item_exercise','','',0,NULL,NULL,'clhzbp9zv00a8356egcdck8lw',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(240,243,NULL,'EXERCICEEE 3',0,0,'item_exercise','','',0,NULL,NULL,'clhzbpfus00ae356eq3v7mzzg',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(241,NULL,41,'LEÇONNN',0,0,'item_lesson','','',0,NULL,1,'clhzbox2q008j356el5d7n5za',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(242,NULL,41,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,1,'clhzboz6q008n356ew6obb7qj',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(243,NULL,41,'LEÇONNN 3',0,0,'item_lesson','','',2,NULL,1,'clhzbp1yb008t356e5iz7be9b',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(244,NULL,42,'LEÇONNN',0,0,'item_lesson','','',0,NULL,NULL,'cli1idhih0001356eta9lfuxa',41,NULL,NULL,NULL,1,'','','','',0,NULL,NULL,75,NULL),(245,NULL,42,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,NULL,'cli1idlcy000f356ekpn06xuz',41,NULL,NULL,NULL,1,'','','','',0,NULL,NULL,120,NULL),(246,NULL,42,'LEÇONNN 3',0,0,'item_lesson','','',2,NULL,NULL,'cli1idnqq000j356el58yl425',41,NULL,NULL,NULL,1,'','','','',0,NULL,NULL,105,NULL),(247,NULL,43,'LEÇONNN',0,0,'item_lesson','','',0,NULL,1,'cli1wh8510001356e59loyhu5',41,NULL,NULL,NULL,1,'','','','',0,NULL,NULL,NULL,NULL),(248,NULL,43,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,1,'cli1whbph000f356ea2mtbjbt',41,NULL,NULL,NULL,1,'','','','',0,NULL,NULL,NULL,NULL),(249,247,NULL,'EXERCICEEE',0,0,'item_exercise','','',0,NULL,NULL,'cli1x93tl0007356e039k5p5k',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(250,247,NULL,'EXERCICEEE 2',0,0,'item_exercise','','',1,NULL,NULL,'cli1x98u2000y356eco0pqfsc',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(251,248,NULL,'EXERCICEEE',0,0,'item_exercise','','',0,NULL,NULL,'cli1x93tl0007356e039k5p5k',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(252,NULL,44,'LEÇONNN',0,0,'item_lesson','','',0,NULL,NULL,'cli2vu7aq0001356eb9dyy6so',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,600,NULL),(253,259,NULL,'EXERCICEEE 2',0,0,'item_exercise','','',0,NULL,NULL,'cli2wq2hn001a356ed1uhqicm',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,60,NULL,NULL),(254,259,NULL,'EXERCICEEE',0,0,'item_exercise','','',1,NULL,NULL,'cli2wq03f0016356e50crf79d',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,61,NULL,NULL),(255,260,NULL,'EXERCICEEE 3',0,0,'item_exercise','','',0,NULL,NULL,'cli2wq4yk001g356e71cr1og2',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,60,NULL,NULL),(256,260,NULL,'EXERCICEEE 2',0,0,'item_exercise','','',1,NULL,NULL,'cli2wq2hn001a356ed1uhqicm',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,61,NULL,NULL),(257,261,NULL,'EXERCICEEE 3',0,0,'item_exercise','','',0,NULL,NULL,'cli2wq4yk001g356e71cr1og2',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,61,NULL,NULL),(258,261,NULL,'EXERCICEEE',0,0,'item_exercise','','',1,NULL,NULL,'cli2wq03f0016356e50crf79d',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,61,NULL,NULL),(259,NULL,45,'LEÇONNN',0,0,'item_lesson','','',0,NULL,1,'cli2wpprv0001356e1kj48tkm',41,NULL,NULL,NULL,0,'','','','',0,NULL,57,NULL,NULL),(260,NULL,45,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,1,'cli2wpst7000f356eq4kuca5e',41,NULL,NULL,NULL,0,'','','','',0,NULL,58,NULL,NULL),(261,NULL,45,'LEÇONNN 3',0,0,'item_lesson','','',2,NULL,1,'cli2wpvre000r356eyczghszm',41,NULL,NULL,NULL,0,'','','','',0,NULL,57,NULL,NULL),(262,269,NULL,'EXERCICEEE 2',0,0,'item_exercise','','',0,NULL,NULL,'cli33erkc003a356ef7ym1u8j',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(263,269,NULL,'EXERCICEEE',0,0,'item_exercise','','',1,NULL,NULL,'cli33en2k001w356ev4credjb',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(264,270,NULL,'EXERCICEEE 2',0,0,'item_exercise','','',0,NULL,NULL,'cli33erkc003a356ef7ym1u8j',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(265,270,NULL,'EXERCICEEE 3',0,0,'item_exercise','','',1,NULL,NULL,'cli33euvb0044356eg1rm9798',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(266,271,NULL,'EXERCICEEE 2',0,0,'item_exercise','','',0,NULL,NULL,'cli33erkc003a356ef7ym1u8j',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(267,271,NULL,'EXERCICEEE 3',0,0,'item_exercise','','',1,NULL,NULL,'cli33euvb0044356eg1rm9798',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(268,271,NULL,'EXERCICEEE',0,0,'item_exercise','','',2,NULL,NULL,'cli33en2k001w356ev4credjb',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(269,NULL,46,'LEÇONNN',0,0,'item_lesson','','',0,NULL,1,'cli33ea3e0001356ebg981cwn',43,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(270,NULL,46,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,1,'cli33ec0a0003356e05zblr6k',43,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(271,NULL,46,'LEÇONNN 3',0,0,'item_lesson','','',2,NULL,1,'cli33edxj0005356em0wzajp9',43,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(274,NULL,48,'LEÇONNN',0,0,'item_lesson','','',0,NULL,NULL,'cli377isu0002356etze9tpzh',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(275,NULL,48,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,NULL,'cli377kvc0004356euf4ku8g0',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(286,NULL,49,'L1',0,0,'item_lesson','','',0,NULL,NULL,'cli4nqnx50003356ei8xmkaxn',29,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(287,NULL,49,'L2',0,0,'item_lesson','','',1,NULL,NULL,'cli4nqr120009356efgpyvx6p',29,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(288,NULL,50,'LEÇONNN',0,0,'item_lesson','','',0,NULL,NULL,'clicwlr3k0001356e06abkozp',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,5,5),(289,NULL,50,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,NULL,'clicwm39l000h356e7tmt9a32',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,5,NULL),(290,NULL,50,'LEÇONNN 3',0,0,'item_lesson','','',2,NULL,NULL,'clicwm6b7000l356e15gvjzhg',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,10,NULL),(291,NULL,50,'LEÇONNN 4',0,0,'item_lesson','','',3,NULL,NULL,'clicwm8sp000r356ewmc3jq30',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,10,NULL),(301,NULL,47,'CUSTOM GROUPE',300,0,'item_modules_group','','',0,NULL,1,'clieohtk40001356gw79h4tu7',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(302,NULL,47,'CUSTOM GROUPE 2',300,0,'item_modules_group','','',1,NULL,1,'clieohxt1000f356gyum9d8s3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(303,312,NULL,'LEÇONNN',120,0,'item_lesson','','',0,NULL,1,'cli3548i90001356e4htoxi6m',42,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(304,312,NULL,'LEÇONNN 2',60,0,'item_lesson','','',1,NULL,1,'cli354ahl0003356eb5ajkysj',42,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(305,313,NULL,'LEÇONNN 2',60,0,'item_lesson','','',0,NULL,1,'cli354ahl0003356eb5ajkysj',42,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(306,313,NULL,'LEÇONNN 3',60,0,'item_lesson','','',1,NULL,1,'cliel6qxp000v356gwnjlbbuc',42,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(307,314,NULL,'LEÇONNN',0,0,'item_lesson','','',0,NULL,1,'cli3548i90001356e4htoxi6m',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(308,314,NULL,'LEÇONNN 3',0,0,'item_lesson','','',1,NULL,1,'cliel6qxp000v356gwnjlbbuc',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(309,315,NULL,'LEÇONNN 3',0,0,'item_lesson','','',0,NULL,1,'cliel6qxp000v356gwnjlbbuc',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(310,315,NULL,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,1,'cli354ahl0003356eb5ajkysj',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(311,315,NULL,'LEÇONNN',0,0,'item_lesson','','',2,NULL,1,'cli3548i90001356e4htoxi6m',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(312,301,NULL,'MODULEEE',180,0,'item_module','','',0,NULL,1,'clieoi2n2000t356gp1b8bezq',42,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(313,301,NULL,'MODULEEE 2',120,0,'item_module','','',1,NULL,1,'clieoi5ry001w356gajl740kt',42,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(314,302,NULL,'MODULEEE 3',0,0,'item_module','','',0,NULL,1,'clieoidnq004w356gvd9oo61u',NULL,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(315,302,NULL,'MODULEEE 4',0,0,'item_module','','',1,NULL,1,'clieoihav005k356gl75604t3',NULL,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(316,303,NULL,'fzefff',0,0,'item_phase','','',0,NULL,1,'cliel6lpo0000356g8qeo9kj6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(317,304,NULL,'fzefff',0,0,'item_phase','','',0,NULL,1,'cliel6lpo0000356g8qeo9kj6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(318,305,NULL,'fzefff',0,0,'item_phase','','',0,NULL,1,'cliel6lpo0000356g8qeo9kj6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(319,306,NULL,'fzefff',0,0,'item_phase','','',0,NULL,1,'cliel6lpo0000356g8qeo9kj6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(320,307,NULL,'fzefff',0,0,'item_phase','','',0,NULL,1,'cliel6lpo0000356g8qeo9kj6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(321,308,NULL,'fzefff',0,0,'item_phase','','',0,NULL,1,'cliel6lpo0000356g8qeo9kj6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(322,309,NULL,'fzefff',0,0,'item_phase','','',0,NULL,1,'cliel6lpo0000356g8qeo9kj6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(323,310,NULL,'fzefff',0,0,'item_phase','','',0,NULL,1,'cliel6lpo0000356g8qeo9kj6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(324,311,NULL,'fzefff',0,0,'item_phase','','',0,NULL,NULL,'cliel6lpo0000356g8qeo9kj6',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(325,316,NULL,'EXERCICEEE',0,0,'item_exercise','','',0,NULL,NULL,'cliel7059002q356gm7aucunx',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(326,317,NULL,'EXERCICEEE 2',0,0,'item_exercise','','',0,NULL,NULL,'cliel72kl002u356g2xmazp6j',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(327,318,NULL,'EXERCICEEE 2',0,0,'item_exercise','','',0,NULL,NULL,'cliel72kl002u356g2xmazp6j',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(328,319,NULL,'EXERCICEEE',0,0,'item_exercise','','',0,NULL,NULL,'cliel7059002q356gm7aucunx',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(329,320,NULL,'EXERCICEEE',0,0,'item_exercise','','',0,NULL,NULL,'cliel7059002q356gm7aucunx',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(330,321,NULL,'EXERCICEEE 2',0,0,'item_exercise','','',0,NULL,NULL,'cliel72kl002u356g2xmazp6j',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(331,322,NULL,'EXERCICEEE',0,0,'item_exercise','','',0,NULL,NULL,'cliel7059002q356gm7aucunx',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(332,323,NULL,'EXERCICEEE 2',0,0,'item_exercise','','',0,NULL,NULL,'cliel72kl002u356g2xmazp6j',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(346,NULL,51,'CUSTOM GROUPE',0,0,'item_modules_group','','',0,NULL,1,'clievuukp0051356gd7rr93x5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(347,NULL,51,'CUSTOM GROUPE 2',0,0,'item_modules_group','','',1,NULL,1,'clievuzw6005b356gs4tx9k7g',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(350,352,NULL,'ihikhlbg',0,0,'item_lesson','','',0,NULL,1,'clievshlq000f356gnyeeage6',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(351,353,NULL,'L',0,0,'item_lesson','','',0,NULL,1,'cliephlx00003356gqwliuik3',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(352,346,NULL,'MODULEEE 2',0,0,'item_module','','',0,NULL,1,'clievvh3u0069356gqq0zlyw8',NULL,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(353,347,NULL,'MODULEEE',0,0,'item_module','','',0,NULL,1,'clievvbv3005p356g9yyz462f',NULL,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(354,350,NULL,'Abbréviation',0,0,'item_phase','','',0,NULL,1,'clilqyd770010356g2tommol3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(355,351,NULL,'Abbréviation',0,0,'item_phase','','',0,NULL,1,'clilqyd770010356g2tommol3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(356,354,NULL,'E',0,0,'item_exercise','','',0,NULL,NULL,'cliephr34001f356gzuvz66qk',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(357,355,NULL,'E',0,0,'item_exercise','','',0,NULL,NULL,'cliephr34001f356gzuvz66qk',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(358,363,NULL,'E',0,0,'item_exercise','','',0,NULL,NULL,'clin9tx9g002f356gcq053v8x',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(359,364,NULL,'E 2',0,0,'item_exercise','','',0,NULL,NULL,'clin9tz6c002j356gb5j3mpwn',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(360,365,NULL,'E 3',0,0,'item_exercise','','',0,NULL,NULL,'clin9u1ed002p356gbf39cg5t',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(361,366,NULL,'E 4',0,0,'item_exercise','','',0,NULL,NULL,'clin9u3st002x356gtm20dguu',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(362,367,NULL,'E 5',0,0,'item_exercise','','',0,NULL,NULL,'clin9u5la0037356gr61wye6w',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(363,NULL,52,'LEÇONNN',0,0,'item_lesson','','',0,NULL,1,'clin9tiuj0001356gqk4rhp7l',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(364,NULL,52,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,1,'clin9tkwa0007356gzy7r5wit',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(365,NULL,52,'LEÇONNN 3',0,0,'item_lesson','','',2,NULL,1,'clin9tmob000d356g1b1cu6s5',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(366,NULL,52,'LEÇONNN 4',0,0,'item_lesson','','',3,NULL,1,'clin9tqdl001n356gq4xo0rid',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(367,NULL,52,'LEÇONNN 5',0,0,'item_lesson','','',4,NULL,1,'clin9tt5e001p356g22orzp9w',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(368,373,NULL,'E',0,0,'item_exercise','','',0,NULL,NULL,'cliog64g2003q356gbduwbnlr',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,61,NULL,NULL),(369,374,NULL,'E 2',0,0,'item_exercise','','',0,NULL,NULL,'cliog66g3003u356g1lkno9dz',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,60,NULL,NULL),(370,375,NULL,'E 3',0,0,'item_exercise','','',0,NULL,NULL,'cliog69jf003w356g6szbuios',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,60,NULL,NULL),(371,376,NULL,'E 4',0,0,'item_exercise','','',0,NULL,NULL,'cliog6cv80044356g5ruawnbj',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,61,NULL,NULL),(372,377,NULL,'E 5',0,0,'item_exercise','','',0,NULL,NULL,'cliog6eyc004e356gcldt6jab',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,60,NULL,NULL),(373,NULL,53,'LEÇONNN',0,0,'item_lesson','','',0,NULL,1,'cliog5mig0001356gf69jiiua',41,NULL,NULL,NULL,0,'','','','',0,NULL,57,NULL,NULL),(374,NULL,53,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,1,'cliog5p280007356g6dlg7r4p',41,NULL,NULL,NULL,0,'','','','',0,NULL,57,NULL,NULL),(375,NULL,53,'LEÇONNN 3',0,0,'item_lesson','','',2,NULL,1,'cliog5r4h000d356gqri0vaci',41,NULL,NULL,NULL,0,'','','','',0,NULL,58,NULL,NULL),(376,NULL,53,'LEÇONNN 4',0,0,'item_lesson','','',3,NULL,1,'cliog5u49000r356gqa41t294',41,NULL,NULL,NULL,0,'','','','',0,NULL,57,NULL,NULL),(377,NULL,53,'LEÇONNN 5',0,0,'item_lesson','','',4,NULL,1,'cliog5x0y0011356gy1d7hacp',41,NULL,NULL,NULL,0,'','','','',0,NULL,57,NULL,NULL),(394,NULL,54,'MODULEEE',0,0,'item_module','','',0,NULL,1,'cliq0a5v70001356gky5axkl9',42,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,60,NULL,NULL),(395,NULL,54,'MODULEEE 2',0,0,'item_module','','',1,NULL,1,'cliq0aokj003n356gky5ihftr',42,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,61,NULL,NULL),(396,394,NULL,'LEÇONNN',0,0,'item_lesson','','',0,NULL,NULL,'cliq0a9jd000d356glmpfc8o2',42,NULL,NULL,NULL,0,'','','','',0,NULL,61,NULL,NULL),(397,394,NULL,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,NULL,'cliq0abll000h356gzdj4p0qv',42,NULL,NULL,NULL,0,'','','','',0,NULL,60,NULL,NULL),(398,395,NULL,'LEÇONNN 3',0,0,'item_lesson','','',0,NULL,NULL,'cliq0adpd000n356g9s4x6qxk',42,NULL,NULL,NULL,0,'','','','',0,NULL,60,NULL,NULL),(399,395,NULL,'LEÇONNN 4',0,0,'item_lesson','','',1,NULL,NULL,'cliq0afxu000v356glp2om7c0',42,NULL,NULL,NULL,0,'','','','',0,NULL,61,NULL,NULL),(400,395,NULL,'LEÇONNN',0,0,'item_lesson','','',2,NULL,NULL,'cliq0a9jd000d356glmpfc8o2',42,NULL,NULL,NULL,0,'','','','',0,NULL,60,NULL,NULL),(428,NULL,62,'CUSTOM GROUPE',0,0,'item_modules_group','','',0,NULL,1,'clirqr28h0047356gkl5tomjs',41,57,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,57,NULL,NULL),(429,NULL,62,'CUSTOM GROUPE 2',0,0,'item_modules_group','','',1,NULL,1,'clirqrb8i004m356gkmyzj9b4',41,58,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,58,NULL,NULL),(430,435,NULL,'LEÇONNN',0,0,'item_lesson','','',0,NULL,NULL,'clirqsbcw00c9356gwa54mfjd',41,57,NULL,NULL,0,'','','','',0,NULL,57,NULL,NULL),(431,435,NULL,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,NULL,'clirqsgux00d6356g881gfsov',42,61,NULL,NULL,0,'','','','',0,NULL,61,NULL,NULL),(432,436,NULL,'LEÇONNN 3',0,0,'item_lesson','','',0,NULL,NULL,'clirqsmv200ey356g769if9hf',42,60,NULL,NULL,0,'','','','',0,NULL,60,NULL,NULL),(433,437,NULL,'LEÇONNN 4',0,0,'item_lesson','','',0,NULL,NULL,'clirqssbe00fp356gj3cv28he',41,58,NULL,NULL,0,'','','','',0,NULL,58,NULL,NULL),(434,438,NULL,'LEÇONNN 5',0,0,'item_lesson','','',0,NULL,NULL,'clirqsx5t00ge356glbfcgjh6',43,64,NULL,NULL,0,'','','','',0,NULL,64,NULL,NULL),(435,428,NULL,'MODULEEE',0,0,'item_module','','',0,NULL,1,'clirqri4b004z356gaggf05om',42,60,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,60,NULL,NULL),(436,428,NULL,'MODULEEE 2',0,0,'item_module','','',1,NULL,1,'clirqrlsk0063356gv9xrhe4x',42,61,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,61,NULL,NULL),(437,429,NULL,'MODULEEE 3',0,0,'item_module','','',0,NULL,1,'clirqru5f008n356gi1wlr7vd',42,61,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,61,NULL,NULL),(438,429,NULL,'MODULEEE 4',0,0,'item_module','','',1,NULL,1,'clirqrzry009b356glr9e93zg',42,62,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,62,NULL,NULL),(439,NULL,63,'CUSTOM GROUPE',240,360,'item_modules_group','','',0,NULL,1,'clisnxaji0001356gb312efp4',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,300,NULL),(440,439,NULL,'MODULEEE',240,360,'item_module','','',0,NULL,1,'clisnxdyu000h356gircv5eie',NULL,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,300,NULL),(441,440,NULL,'LEÇONNN',240,360,'item_lesson','grezegef','thdhtae',0,NULL,NULL,'cliu61ymh0006356g9ucsj1ej',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,300,NULL),(449,NULL,65,'LEÇONNN',0,0,'item_lesson','','',0,NULL,1,'cliug9y0g0001356gkr73jrju',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(450,NULL,65,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,1,'cliuga1cw000j356gwgohzdsv',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(451,NULL,65,'LEÇONNN 3',0,0,'item_lesson','','',2,NULL,1,'cliuga51w000t356g9hkalz1h',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(452,456,NULL,'EXERCICEEE',0,0,'item_exercise','','',0,NULL,NULL,'cliugabmb001g356g93p9drxq',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(453,457,NULL,'EXERCICEEE 2',0,0,'item_exercise','','',0,NULL,NULL,'cliugaen0002r356g86gj6z0g',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(454,457,NULL,'EXERCICEEE 4',0,0,'item_exercise','','',1,NULL,NULL,'cliugamgm003x356gsy8zwp6a',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(455,458,NULL,'EXERCICEEE 3',0,0,'item_exercise','','',0,NULL,NULL,'cliugai8z003b356g33kkkdtf',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(456,459,NULL,'GROUPE D\'EXERCICESSS',0,0,'item_exercises_group','','',0,NULL,1,'cliujnrzq0039356g9z3uuhs3',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(457,460,NULL,'GROUPE D\'EXERCICESSS 2',0,0,'item_exercises_group','','',0,NULL,1,'cliujnuwp003d356gky8k3q2u',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(458,461,NULL,'GROUPE D\'EXERCICESSS 3',0,0,'item_exercises_group','','',0,NULL,1,'cliujnx9w003j356ghbjc55qg',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(459,449,NULL,'zfef',0,0,'item_phase','','',0,NULL,1,'cliujnf3k000q356gvk73zzrl',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(460,450,NULL,'zfef',0,0,'item_phase','','',0,NULL,1,'cliujnf3k000q356gvk73zzrl',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(461,451,NULL,'zfef',0,0,'item_phase','','',0,NULL,1,'cliujnf3k000q356gvk73zzrl',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(462,464,NULL,'E',0,0,'item_exercise','','',0,NULL,NULL,'clivgvl54002i356ghkqpffou',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(463,465,NULL,'E 2',0,0,'item_exercise','','',0,NULL,NULL,'clivgvpo20059356gd6gg0ov1',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(464,466,NULL,'zfef',0,0,'item_phase','','',0,NULL,1,'clivgv8o50000356g4etkgj62',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(465,467,NULL,'zfef',0,0,'item_phase','','',0,NULL,1,'clivgv8o50000356g4etkgj62',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(466,NULL,66,'LEÇONNN',0,0,'item_lesson','','',0,NULL,1,'clivgvbnd0003356g2yurwo3o',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(467,NULL,66,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,1,'clivgveq1000i356gy5hjtbzh',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(468,469,NULL,'E',0,0,'item_exercise','','',0,NULL,NULL,'clix586h7000i356gylhfczvp',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(469,NULL,67,'e',0,0,'item_lesson','','',0,NULL,1,'clix5834h0001356gbta64clq',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(470,476,NULL,'LEÇONNN',1,2,'item_lesson','','',0,NULL,NULL,'cliylq7mn000f356gsam8nqqo',42,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,2,NULL),(471,476,NULL,'LEÇONNN 2',1,2,'item_lesson','','',1,NULL,NULL,'cliylqjg8001e356gdj81ja15',42,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,1,NULL),(472,476,NULL,'LEÇONNN 3',1,2,'item_lesson','','',2,NULL,NULL,'cliylqvmq0039356gqa9mcel8',42,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,2,NULL),(473,477,NULL,'LEÇONNN 4',3,7,'item_lesson','','',0,NULL,NULL,'cliylqxvm003d356gukyzow0y',42,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,5,NULL),(474,478,NULL,'LEÇONNN 5',2,3,'item_lesson','','',0,NULL,NULL,'cliylqzrv003j356g62exaqc7',42,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,2,NULL),(475,478,NULL,'LEÇONNN 6',2,4,'item_lesson','','',1,NULL,NULL,'cliylr7ws009q356gdt7eps8b',42,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,3,NULL),(476,NULL,69,'MODULEEE',3,6,'item_module','','',0,NULL,1,'cliylq4a20001356gv6596adj',42,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL),(477,NULL,69,'MODULEEE 2',3,7,'item_module','','',1,NULL,1,'cliylqomh002f356gh0eh8xg7',42,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL),(478,NULL,69,'MODULEEE 3',4,7,'item_module','','',2,NULL,1,'cliylqs8i002t356gpanzu5ow',42,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL),(485,NULL,70,'CUSTOM GROUPE',0,0,'item_modules_group','','',0,NULL,1,'cliyqtioi0001356gv9c1r29p',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(486,488,NULL,'EXERCICEEE',0,0,'item_exercise','','',0,NULL,NULL,'cliyqycv1003u356gekvmkv6k',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(487,489,NULL,'EXERCICEEE',0,0,'item_exercise','','',0,NULL,NULL,'cliyqycv1003u356gekvmkv6k',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(488,490,NULL,'Abbréviation',0,0,'item_phase','','',0,NULL,1,'cliyqxw4e0000356gapcm8sbc',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(489,490,NULL,'CUSTOM PHASEEE',0,0,'item_phase','','',1,NULL,1,'cliyqy3jv001x356gb6moxi9d',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(490,491,NULL,'LEÇONNN',0,0,'item_lesson','','',0,NULL,1,'cliyqtqez001a356g1n4bjsm2',42,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(491,485,NULL,'MODULEEE',0,0,'item_module','','',0,NULL,1,'cliyqtlua000f356g5ovp25zp',42,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(492,NULL,68,'MODULEEE',0,0,'item_module','','',0,NULL,1,'cliynf68a0001356g4cxamr9o',41,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,5,NULL),(493,497,NULL,'E',0,0,'item_exercise','','',0,NULL,NULL,'clj2mhnlk003c356gljiayxlv',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,60,NULL,NULL),(494,497,NULL,'E 2',0,0,'item_exercise','','',1,NULL,NULL,'clj2mhpgx003e356gy9bspp4d',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,57,NULL,NULL),(495,497,NULL,'E 3',0,0,'item_exercise','','',2,NULL,NULL,'clj2mhti1003g356g1xw9ob59',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,58,NULL,NULL),(496,498,NULL,'E 4',0,0,'item_exercise','','',0,NULL,NULL,'clj2mi3tm009c356gurfrbrpg',43,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(497,492,NULL,'LEÇONNN',0,0,'item_lesson','','',0,NULL,1,'cliynf9c2000f356gckg3ax5y',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,4,NULL),(498,492,NULL,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,1,'cliynfemz001c356gwd081hdo',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,1,NULL),(499,506,NULL,'EXERCICEEE',0,0,'item_exercise','','',0,NULL,NULL,'clj41p0w000u1356gzlqre723',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(500,506,NULL,'EXERCICEEE 2',0,0,'item_exercise','','',1,NULL,NULL,'clj41p2qh00u5356ga4y2z05g',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(501,507,NULL,'EXERCICEEE 3',0,0,'item_exercise','','',0,NULL,NULL,'clj41p4pk00ub356gywbuqyct',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(502,508,NULL,'EXERCICEEE 4',0,0,'item_exercise','','',0,NULL,NULL,'clj41p7g800uj356gkeyazdwv',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(503,509,NULL,'EXERCICEEE 5',0,0,'item_exercise','','',0,NULL,NULL,'clj41p9ka00ut356gjsyzmb5d',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(504,510,NULL,'EXERCICEEE 6',0,0,'item_exercise','','',0,NULL,NULL,'clj41pbix00v5356g6otykl8p',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(505,511,NULL,'EXERCICEEE 7',0,0,'item_exercise','','',0,NULL,NULL,'clj41pr0j01m7356g79qp2bw7',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(506,512,NULL,'fzefff',0,0,'item_phase','','',0,NULL,1,'clj41mmqw0000356g4oujgskj',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(507,513,NULL,'fzefff',0,0,'item_phase','','',0,NULL,1,'clj41mmqw0000356g4oujgskj',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(508,514,NULL,'fzefff',0,0,'item_phase','','',0,NULL,1,'clj41mmqw0000356g4oujgskj',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(509,515,NULL,'fzefff',0,0,'item_phase','','',0,NULL,1,'clj41mmqw0000356g4oujgskj',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(510,516,NULL,'fzefff',0,0,'item_phase','','',0,NULL,1,'clj41mmqw0000356g4oujgskj',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(511,517,NULL,'fzefff',0,0,'item_phase','','',0,NULL,1,'clj41mmqw0000356g4oujgskj',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(512,518,NULL,'LEÇONNN',1,2,'item_lesson','','',0,NULL,1,'clj41nltd008g356gwjkhfny6',42,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,1,NULL),(513,518,NULL,'LEÇONNN 2',1,1,'item_lesson','','',1,NULL,1,'clj41nov6008i356gucupz9i9',42,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,1,NULL),(514,519,NULL,'LEÇONNN 3',1,2,'item_lesson','','',0,NULL,1,'clj41nr8a008k356gy0118w59',42,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,1,NULL),(515,519,NULL,'LEÇONNN 4',0,1,'item_lesson','','',1,NULL,1,'clj41nww2008s356gfanqcx2u',42,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,1,NULL),(516,520,NULL,'LEÇONNN 5',1,2,'item_lesson','','',0,NULL,1,'clj41nz8q0092356g8xrzznks',42,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,1,NULL),(517,521,NULL,'LEÇONNN 6',1,2,'item_lesson','','',0,NULL,1,'clj41o73x009r356g0qkf606h',42,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,1,NULL),(518,522,NULL,'MODULEEE',2,3,'item_module','','',0,NULL,1,'clj41n43i0013356gi81q1jnj',42,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL),(519,522,NULL,'MODULEEE 2',1,3,'item_module','','',1,NULL,1,'clj41n68e0017356glgz2l7d5',42,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL),(520,523,NULL,'MODULEEE 3',1,2,'item_module','','',0,NULL,1,'clj41n7xa001d356gy35jve61',42,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL),(521,523,NULL,'MODULEEE 4',1,2,'item_module','','',1,NULL,1,'clj41n9rb001l356gtdyeev7w',42,NULL,NULL,'',0,NULL,NULL,NULL,NULL,NULL,NULL,NULL,1,NULL),(522,NULL,71,'CUSTOM GROUPE',3,6,'item_modules_group','','',0,NULL,1,'clj41mqak0003356g5hmts7nc',43,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,4,NULL),(523,NULL,71,'CUSTOM GROUPE 2',2,4,'item_modules_group','','',1,NULL,1,'clj41mt9g0009356gpzcd6pcc',43,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,2,NULL),(525,529,NULL,'Item1 ',0,0,'item_exercise','','',0,NULL,NULL,'clj4lw7490013356gyglmb24w',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(526,529,NULL,'Item 2',0,0,'item_exercise','','',1,NULL,NULL,'clj4lwaao0015356gp7o672ax',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(527,530,NULL,'Item 3',0,0,'item_exercise','','',0,NULL,NULL,'clj4lwgvb0017356gf7z7c4q5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(528,530,NULL,'Item 4',0,0,'item_exercise','','',1,NULL,NULL,'clj4lwjhw0019356g73nxqsqy',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(529,NULL,74,'L1',7,14,'item_lesson','','',0,NULL,1,'clj4lw0di0001356gcagd9ibl',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,9,NULL),(530,NULL,74,'L2',13,16,'item_lesson','','',1,NULL,1,'clj4lw2cg0007356g2qi9mjby',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,16,NULL),(532,535,NULL,'EXERCICEEE',0,0,'item_exercise','','',0,NULL,NULL,'clj5zgyn2000v356g5fyboz4c',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(533,535,NULL,'EXERCICEEE 2',0,0,'item_exercise','','',1,NULL,NULL,'clj5zh0kf000z356g4a52apz2',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(534,536,NULL,'EXERCICEEE 3',0,0,'item_exercise','','',0,NULL,NULL,'clj5zh7tc005b356gcbz3apsd',42,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(535,NULL,75,'LEÇONNN',0,0,'item_lesson','','',0,NULL,1,'clj5z7rrn0001356gdh6p2syw',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(536,NULL,75,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,1,'clj5zgnr9000f356gs177644z',NULL,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(537,NULL,73,'LEÇONNN',1,3,'item_lesson','','',0,NULL,1,'clj5pyr2e0001356gzyo3nhkg',43,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,2,NULL),(538,NULL,73,'LEÇONNN 2',1,2,'item_lesson','','',1,NULL,1,'clj6z2o7l000g356gyuxmpdar',43,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,1,NULL),(539,NULL,73,'LEÇONNN 3',1,2,'item_lesson','','',2,NULL,1,'clj6z2ptd000k356grgv9rqqh',43,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,1,NULL),(540,NULL,73,'LEÇONNN 4',1,3,'item_lesson','','',3,NULL,1,'clj6z2rql000q356g82jixypc',43,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,2,NULL),(541,537,NULL,'E',0,0,'item_exercise','','',0,NULL,NULL,'clj6z2xld0027356gtma7mzej',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(542,537,NULL,'E 1',0,0,'item_exercise','','',1,NULL,NULL,'clj6z30b5002b356g88jbim83',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(543,538,NULL,'E 2',0,0,'item_exercise','','',0,NULL,NULL,'clj6z34ai002h356ghxfsdmku',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(544,539,NULL,'E 3',0,0,'item_exercise','','',0,NULL,NULL,'clj6z3702002p356g5jto1x5d',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(545,540,NULL,'E 4',0,0,'item_exercise','','',0,NULL,NULL,'clj6z38xv002z356gbm0epp43',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(546,540,NULL,'E 5',0,0,'item_exercise','','',1,NULL,1,'clj6z3fr000a3356g89wtcwge',41,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(547,NULL,76,'LEÇONNN',0,0,'item_lesson','','',0,NULL,NULL,'clj8flyr30001356gwhqlfuk2',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(548,NULL,76,'LEÇONNN 2',0,0,'item_lesson','','',1,NULL,NULL,'clj8fm1ld0007356gui76k6ii',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(549,NULL,76,'LEÇONNN 3',0,0,'item_lesson','','',2,NULL,NULL,'clj8fm3e8000d356gb0jxqk8g',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL),(550,NULL,76,'LEÇONNN 4',0,0,'item_lesson','','',3,NULL,NULL,'clj8fm67i000l356gvnrkzz9n',41,NULL,NULL,NULL,0,'','','','',0,NULL,NULL,NULL,NULL);

--
-- Table structure for table `formation_item_action`
--

CREATE TABLE `formation_item_action` (
  `formation_item_id` int NOT NULL,
  `action_id` int NOT NULL,
  PRIMARY KEY (`formation_item_id`,`action_id`),
  KEY `IDX_9EC8D98657901725` (`formation_item_id`),
  KEY `IDX_9EC8D9869D32F035` (`action_id`),
  CONSTRAINT `FK_9EC8D98657901725` FOREIGN KEY (`formation_item_id`) REFERENCES `formation_item` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_9EC8D9869D32F035` FOREIGN KEY (`action_id`) REFERENCES `action` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `formation_item_action`
--

INSERT INTO `formation_item_action` VALUES (125,5),(125,6);

--
-- Table structure for table `formation_item_formation_item`
--

CREATE TABLE `formation_item_formation_item` (
  `formation_item_source` int NOT NULL,
  `formation_item_target` int NOT NULL,
  PRIMARY KEY (`formation_item_source`,`formation_item_target`),
  KEY `IDX_DEAC66A1868E2A67` (`formation_item_source`),
  KEY `IDX_DEAC66A19F6B7AE8` (`formation_item_target`),
  CONSTRAINT `FK_DEAC66A1868E2A67` FOREIGN KEY (`formation_item_source`) REFERENCES `formation_item` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_DEAC66A19F6B7AE8` FOREIGN KEY (`formation_item_target`) REFERENCES `formation_item` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `formation_item_formation_item`
--


--
-- Table structure for table `formation_item_skills`
--

CREATE TABLE `formation_item_skills` (
  `formation_item_id` int NOT NULL,
  `skills_id` int NOT NULL,
  PRIMARY KEY (`formation_item_id`,`skills_id`),
  KEY `IDX_C35436457901725` (`formation_item_id`),
  KEY `IDX_C3543647FF61858` (`skills_id`),
  CONSTRAINT `FK_C35436457901725` FOREIGN KEY (`formation_item_id`) REFERENCES `formation_item` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_C3543647FF61858` FOREIGN KEY (`skills_id`) REFERENCES `skills` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `formation_item_skills`
--


--
-- Table structure for table `formation_items_technical_skills`
--

CREATE TABLE `formation_items_technical_skills` (
  `formation_item_id` int NOT NULL,
  `skills_id` int NOT NULL,
  PRIMARY KEY (`formation_item_id`,`skills_id`),
  KEY `IDX_72D338D457901725` (`formation_item_id`),
  KEY `IDX_72D338D47FF61858` (`skills_id`),
  CONSTRAINT `FK_72D338D457901725` FOREIGN KEY (`formation_item_id`) REFERENCES `formation_item` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_72D338D47FF61858` FOREIGN KEY (`skills_id`) REFERENCES `skills` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `formation_items_technical_skills`
--


--
-- Table structure for table `formation_practical_counter_type`
--

CREATE TABLE `formation_practical_counter_type` (
  `formation_id` int NOT NULL,
  `counter_type_value_id` int NOT NULL,
  PRIMARY KEY (`formation_id`,`counter_type_value_id`),
  KEY `IDX_8EA8CCD95200282E` (`formation_id`),
  KEY `IDX_8EA8CCD92402E8F` (`counter_type_value_id`),
  CONSTRAINT `FK_8EA8CCD92402E8F` FOREIGN KEY (`counter_type_value_id`) REFERENCES `counter_type_value` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_8EA8CCD95200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `formation_practical_counter_type`
--

INSERT INTO `formation_practical_counter_type` VALUES (13,17),(13,19),(13,21),(13,22),(13,26),(13,27),(13,28),(13,29),(21,18),(21,22),(22,21),(22,22),(22,26),(46,15),(46,17),(47,32),(48,22),(49,17),(52,27),(76,22),(76,26),(76,27),(76,29);

--
-- Table structure for table `formation_skills`
--

CREATE TABLE `formation_skills` (
  `formation_id` int NOT NULL,
  `skills_id` int NOT NULL,
  PRIMARY KEY (`formation_id`,`skills_id`),
  KEY `IDX_F528185D5200282E` (`formation_id`),
  KEY `IDX_F528185D7FF61858` (`skills_id`),
  CONSTRAINT `FK_F528185D5200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_F528185D7FF61858` FOREIGN KEY (`skills_id`) REFERENCES `skills` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `formation_skills`
--

INSERT INTO `formation_skills` VALUES (41,35),(41,36),(43,23),(43,24),(43,25),(43,36),(45,24),(45,36),(46,23),(46,24),(48,23),(65,35),(67,23),(67,25),(68,35),(68,36),(73,35),(73,36),(75,35),(75,36);

--
-- Table structure for table `formation_theoretical_counter_type`
--

CREATE TABLE `formation_theoretical_counter_type` (
  `formation_id` int NOT NULL,
  `counter_type_value_id` int NOT NULL,
  PRIMARY KEY (`formation_id`,`counter_type_value_id`),
  KEY `IDX_4B85E0E35200282E` (`formation_id`),
  KEY `IDX_4B85E0E32402E8F` (`counter_type_value_id`),
  CONSTRAINT `FK_4B85E0E32402E8F` FOREIGN KEY (`counter_type_value_id`) REFERENCES `counter_type_value` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_4B85E0E35200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `formation_theoretical_counter_type`
--

INSERT INTO `formation_theoretical_counter_type` VALUES (2,12),(28,30),(28,31),(34,30),(34,31),(35,30),(35,31),(42,30);

--
-- Table structure for table `instructor_skill`
--

CREATE TABLE `instructor_skill` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `instructor_skill`
--

INSERT INTO `instructor_skill` VALUES (1,'test');

--
-- Table structure for table `instructor_skill_ato_user`
--

CREATE TABLE `instructor_skill_ato_user` (
  `instructor_skill_id` int NOT NULL,
  `ato_user_id` int NOT NULL,
  PRIMARY KEY (`instructor_skill_id`,`ato_user_id`),
  KEY `IDX_1EC3796555E763E7` (`instructor_skill_id`),
  KEY `IDX_1EC3796530A17E02` (`ato_user_id`),
  CONSTRAINT `FK_1EC3796530A17E02` FOREIGN KEY (`ato_user_id`) REFERENCES `ato_user` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_1EC3796555E763E7` FOREIGN KEY (`instructor_skill_id`) REFERENCES `instructor_skill` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `instructor_skill_ato_user`
--

INSERT INTO `instructor_skill_ato_user` VALUES (1,32);

--
-- Table structure for table `lesson_annotation`
--

CREATE TABLE `lesson_annotation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ato_id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_234D7723847DC024` (`ato_id`),
  CONSTRAINT `FK_234D7723847DC024` FOREIGN KEY (`ato_id`) REFERENCES `ato` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lesson_annotation`
--


--
-- Table structure for table `lesson_annotation_value`
--

CREATE TABLE `lesson_annotation_value` (
  `id` int NOT NULL AUTO_INCREMENT,
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lesson_annotation_value`
--


--
-- Table structure for table `lesson_skills_indicator_notation`
--

CREATE TABLE `lesson_skills_indicator_notation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `skill_detail_id` int DEFAULT NULL,
  `notation_id` int DEFAULT NULL,
  `notation_reason_id` int DEFAULT NULL,
  `session_id` int DEFAULT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_4BC4B8B78B2138E6` (`skill_detail_id`),
  KEY `IDX_4BC4B8B79680B7F7` (`notation_id`),
  KEY `IDX_4BC4B8B79646E8C` (`notation_reason_id`),
  KEY `IDX_4BC4B8B7613FECDF` (`session_id`),
  CONSTRAINT `FK_4BC4B8B7613FECDF` FOREIGN KEY (`session_id`) REFERENCES `session` (`id`),
  CONSTRAINT `FK_4BC4B8B78B2138E6` FOREIGN KEY (`skill_detail_id`) REFERENCES `skills_detail` (`id`),
  CONSTRAINT `FK_4BC4B8B79646E8C` FOREIGN KEY (`notation_reason_id`) REFERENCES `rating_value_reasons_details` (`id`),
  CONSTRAINT `FK_4BC4B8B79680B7F7` FOREIGN KEY (`notation_id`) REFERENCES `rating_value` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lesson_skills_indicator_notation`
--

INSERT INTO `lesson_skills_indicator_notation` VALUES (1,31,60,50,74,'2023-05-14 15:36:14'),(2,32,61,53,74,'2023-05-14 15:36:14'),(3,33,62,54,74,'2023-05-14 15:36:14'),(4,47,61,NULL,100,'2023-05-22 23:05:29'),(5,48,62,NULL,100,'2023-05-22 23:05:29'),(10,47,62,54,227,'2023-06-22 14:20:59'),(11,48,60,51,227,'2023-06-22 14:20:59');

--
-- Table structure for table `lesson_skills_notation`
--

CREATE TABLE `lesson_skills_notation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `skill_id` int DEFAULT NULL,
  `notation_id` int DEFAULT NULL,
  `notation_reason_id` int DEFAULT NULL,
  `session_id` int NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_C2CE256A5585C142` (`skill_id`),
  KEY `IDX_C2CE256A9680B7F7` (`notation_id`),
  KEY `IDX_C2CE256A9646E8C` (`notation_reason_id`),
  KEY `IDX_C2CE256A613FECDF` (`session_id`),
  CONSTRAINT `FK_C2CE256A5585C142` FOREIGN KEY (`skill_id`) REFERENCES `skills` (`id`),
  CONSTRAINT `FK_C2CE256A613FECDF` FOREIGN KEY (`session_id`) REFERENCES `session` (`id`),
  CONSTRAINT `FK_C2CE256A9646E8C` FOREIGN KEY (`notation_reason_id`) REFERENCES `rating_value_reasons_details` (`id`),
  CONSTRAINT `FK_C2CE256A9680B7F7` FOREIGN KEY (`notation_id`) REFERENCES `rating_value` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lesson_skills_notation`
--

INSERT INTO `lesson_skills_notation` VALUES (1,23,57,44,64,'2023-05-11 16:44:58'),(2,24,61,52,64,'2023-05-11 16:44:58'),(3,25,63,NULL,64,'2023-05-11 16:44:58'),(4,25,65,60,70,'2023-05-13 18:15:36'),(5,26,57,45,70,'2023-05-13 18:15:36'),(6,23,58,46,74,'2023-05-14 15:36:14'),(7,26,59,49,74,'2023-05-14 15:36:14'),(8,35,57,NULL,100,'2023-05-22 23:05:29'),(9,36,60,NULL,100,'2023-05-22 23:05:29'),(10,24,60,50,107,'2023-05-25 11:06:19'),(11,36,60,50,107,'2023-05-25 11:06:19'),(12,24,61,52,108,'2023-05-25 11:07:40'),(13,36,61,52,108,'2023-05-25 11:07:40'),(14,23,58,47,109,'2023-05-25 14:23:33'),(15,24,62,54,109,'2023-05-25 14:23:33'),(16,23,58,47,110,'2023-05-25 14:43:24'),(17,24,62,54,110,'2023-05-25 14:43:24'),(18,23,58,46,112,'2023-05-25 15:59:35'),(19,23,57,44,113,'2023-05-25 16:01:00'),(20,23,57,44,118,'2023-05-30 23:49:14'),(25,35,58,47,227,'2023-06-22 14:20:59'),(26,36,58,46,227,'2023-06-22 14:20:59');

--
-- Table structure for table `manufacturer_aircraft`
--

CREATE TABLE `manufacturer_aircraft` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `manufacturer_aircraft`
--

INSERT INTO `manufacturer_aircraft` VALUES (1,'ROBIN'),(2,'CESSNA'),(3,'AIR-TRACTOR'),(4,'BELL'),(5,'CORSAIR'),(6,'PARAMANIA'),(7,'TAKEOGG'),(8,'COSMOS'),(9,'AEROPO'),(10,'DYNAERO'),(11,'ELA'),(12,'MAGNI'),(13,'CELIER'),(14,'TRIXY AVIATION'),(15,'BALLONS CHAIZE'),(16,'HELISPORT'),(17,'LAMBADA'),(18,'SCHEIBE'),(19,'STEMME'),(20,'LANGE ANTARES'),(21,'JANTAR'),(22,'ASW22'),(23,'NIMBUS'),(24,'ALEXANDER SCHLEICHER'),(25,'PIPER AIRCRAFT'),(26,'CIRRUS DESIGN'),(27,'DIAMOND'),(28,'MORANE-SAULNIER'),(29,'SOCATA'),(30,'FOURNIER'),(31,'ALPI AVIATION'),(32,'APEX'),(33,'MUDRY'),(34,'DYN\'AERO'),(35,'EXTRA AIRCRAFT'),(36,'CURTIS PITTS'),(37,'GRUMMAN AMERICA'),(38,'Test');

--
-- Table structure for table `media_object`
--

CREATE TABLE `media_object` (
  `id` int NOT NULL AUTO_INCREMENT,
  `file_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `content_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `formation_id` int DEFAULT NULL,
  `lesson_id` int DEFAULT NULL,
  `original_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `action_id` int DEFAULT NULL,
  `extra_lesson_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_14D431325200282E` (`formation_id`),
  KEY `IDX_14D43132CDF80196` (`lesson_id`),
  KEY `IDX_14D431329D32F035` (`action_id`),
  KEY `IDX_14D431323FD4DD80` (`extra_lesson_id`),
  CONSTRAINT `FK_14D431323FD4DD80` FOREIGN KEY (`extra_lesson_id`) REFERENCES `extra_lesson` (`id`),
  CONSTRAINT `FK_14D431325200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_14D431329D32F035` FOREIGN KEY (`action_id`) REFERENCES `action` (`id`),
  CONSTRAINT `FK_14D43132CDF80196` FOREIGN KEY (`lesson_id`) REFERENCES `formation_item` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `media_object`
--

INSERT INTO `media_object` VALUES (1,'63cd553dcea52_126831522_688122635403879_4351436385684016301_n.jpg','/media/63cd553dcea52_126831522_688122635403879_4351436385684016301_n.jpg',NULL,NULL,'126831522_688122635403879_4351436385684016301_n.jpg',NULL,NULL),(5,'63e672ffcff05_126831522_688122635403879_4351436385684016301_n.jpg','/media/63e672ffcff05_126831522_688122635403879_4351436385684016301_n.jpg',NULL,NULL,'126831522_688122635403879_4351436385684016301_n.jpg',NULL,NULL),(6,'63ed1a1fc6395_126831522_688122635403879_4351436385684016301_n.jpg','/media/63ed1a1fc6395_126831522_688122635403879_4351436385684016301_n.jpg',NULL,NULL,'126831522_688122635403879_4351436385684016301_n.jpg',NULL,NULL),(8,'63f3989ca89d2_126831522_688122635403879_4351436385684016301_n.jpg','/media/63f3989ca89d2_126831522_688122635403879_4351436385684016301_n.jpg',NULL,NULL,'126831522_688122635403879_4351436385684016301_n.jpg',NULL,NULL),(9,'63f3989e61f8b_126222546_287869209235716_5096667585606811254_n.jpg','/media/63f3989e61f8b_126222546_287869209235716_5096667585606811254_n.jpg',NULL,NULL,'126222546_287869209235716_5096667585606811254_n.jpg',NULL,NULL),(10,'63f398bf9eefd_126831522_688122635403879_4351436385684016301_n.jpg','/media/63f398bf9eefd_126831522_688122635403879_4351436385684016301_n.jpg',NULL,NULL,'126831522_688122635403879_4351436385684016301_n.jpg',NULL,NULL),(12,'640cc12f7aa60_126831522_688122635403879_4351436385684016301_n.jpg','/media/640cc12f7aa60_126831522_688122635403879_4351436385684016301_n.jpg',NULL,NULL,'126831522_688122635403879_4351436385684016301_n.jpg',NULL,NULL),(13,'640cc1fb0cee0_126831522_688122635403879_4351436385684016301_n.jpg','/media/640cc1fb0cee0_126831522_688122635403879_4351436385684016301_n.jpg',NULL,NULL,'126831522_688122635403879_4351436385684016301_n.jpg',NULL,NULL),(14,'640cc231baa0b_126831522_688122635403879_4351436385684016301_n.jpg','/media/640cc231baa0b_126831522_688122635403879_4351436385684016301_n.jpg',NULL,NULL,'126831522_688122635403879_4351436385684016301_n.jpg',NULL,NULL),(15,'640cc81478632_golden-retriever.jpg','/media/640cc81478632_golden-retriever.jpg',NULL,NULL,'golden-retriever.jpg',NULL,NULL),(17,'6427f647e0fbb_example.xlsx','/media/6427f647e0fbb_example.xlsx',NULL,NULL,'example.xlsx',NULL,NULL),(18,'6442543a755d8_299684898_2197753793736740_3257285090226740465_n.jpg','/media/6442543a755d8_299684898_2197753793736740_3257285090226740465_n.jpg',NULL,NULL,'299684898_2197753793736740_3257285090226740465_n.jpg',NULL,NULL),(19,'6442558734990_299684898_2197753793736740_3257285090226740465_n.jpg','/media/6442558734990_299684898_2197753793736740_3257285090226740465_n.jpg',NULL,NULL,'299684898_2197753793736740_3257285090226740465_n.jpg',NULL,NULL),(20,'644255c5194fa_299684898_2197753793736740_3257285090226740465_n.jpg','/media/644255c5194fa_299684898_2197753793736740_3257285090226740465_n.jpg',NULL,NULL,'299684898_2197753793736740_3257285090226740465_n.jpg',NULL,NULL),(21,'644255e8dcee7_299684898_2197753793736740_3257285090226740465_n.jpg','/media/644255e8dcee7_299684898_2197753793736740_3257285090226740465_n.jpg',NULL,NULL,'299684898_2197753793736740_3257285090226740465_n.jpg',NULL,NULL),(22,'64425605c7606_299684898_2197753793736740_3257285090226740465_n.jpg','/media/64425605c7606_299684898_2197753793736740_3257285090226740465_n.jpg',NULL,NULL,'299684898_2197753793736740_3257285090226740465_n.jpg',NULL,NULL),(23,'6442fcbd6abfe_example (1).xlsx','/media/6442fcbd6abfe_example (1).xlsx',16,NULL,'example (1).xlsx',NULL,NULL),(24,'6442fd62a5d2f_example (9).xlsx','/media/6442fd62a5d2f_example (9).xlsx',NULL,73,'example (9).xlsx',NULL,NULL),(25,'644a71d10d42c_example (9).xlsx','/media/644a71d10d42c_example (9).xlsx',NULL,NULL,'example (9).xlsx',NULL,NULL),(26,'644a799739f3a_example (9).xlsx','/media/644a799739f3a_example (9).xlsx',NULL,NULL,'example (9).xlsx',NULL,5);

--
-- Table structure for table `migration_versions`
--

CREATE TABLE `migration_versions` (
  `version` varchar(14) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `executed_at` datetime NOT NULL COMMENT '(DC2Type:datetime_immutable)',
  PRIMARY KEY (`version`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migration_versions`
--


--
-- Table structure for table `model_aircraft`
--

CREATE TABLE `model_aircraft` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `engine_type_id` int NOT NULL,
  `category_id` int NOT NULL,
  `manufacturer_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_D90336CA577F21F8` (`engine_type_id`),
  KEY `IDX_D90336CA12469DE2` (`category_id`),
  KEY `IDX_D90336CAA23B42D` (`manufacturer_id`),
  CONSTRAINT `FK_D90336CA12469DE2` FOREIGN KEY (`category_id`) REFERENCES `category_aircraft` (`id`),
  CONSTRAINT `FK_D90336CA577F21F8` FOREIGN KEY (`engine_type_id`) REFERENCES `engine_type_aircraft` (`id`),
  CONSTRAINT `FK_D90336CAA23B42D` FOREIGN KEY (`manufacturer_id`) REFERENCES `manufacturer_aircraft` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=276 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `model_aircraft`
--

INSERT INTO `model_aircraft` VALUES (1,'ATL',1,1,1),(2,' Ambassadeur',1,1,1),(3,'Ambassadeur',1,1,1),(4,'Sicile',1,1,1),(5,'Sicile-Record',1,1,1),(6,'Excellence',1,1,1),(7,'DR-200',1,1,1),(8,'Capitaine',1,1,1),(9,'B',1,1,32),(10,'2+2',1,1,1),(11,'A 2+2',1,1,1),(12,'AB 2+2',1,1,1),(13,'Dauphin',1,1,1),(14,'Régent',1,1,1),(15,'Major',1,1,1),(16,'Petit-Prince',1,1,1),(17,'Chevalier',1,1,1),(18,'Prince',1,1,1),(19,'L\'Acrobat',1,1,1),(20,'108 2+2',1,1,1),(21,'180R Major',1,1,1),(22,'125',1,1,1),(23,'140',1,1,1),(24,'Dauphin 2+2',1,1,1),(25,'REMO 180',1,1,1),(26,'REMO 200',1,1,1),(27,'HR 100',1,1,1),(28,'HR 200',1,1,1),(29,'R 1180',1,1,1),(30,'R 2112',1,1,1),(31,'R 2160',1,1,1),(32,'R 3000',1,1,1),(33,'200',1,1,35),(34,'200A',1,1,1),(35,'200B',1,1,1),(36,'210F Safari',1,1,1),(37,'320 Tiara',1,1,1),(38,'285 Tiara',1,1,1),(39,'235TR',1,1,1),(40,'250TR Président',1,1,1),(41,'320 4+2',1,1,1),(42,'HR-200',1,1,1),(43,'Aiglon',1,1,1),(44,'T-Aiglon',1,1,1),(45,'TD-Aiglon',1,1,1),(46,'Club',1,1,1),(47,'Alpha',1,1,1),(48,'Sport',1,1,1),(49,'Alpha Sport',1,1,1),(50,'120',1,1,34),(51,'120D',1,1,1),(52,'160',1,1,1),(53,'160S',1,1,1),(54,'C150',1,1,2),(55,'C150-Aerobat',1,1,2),(56,'C152',1,1,2),(57,'C152-Aerobat',1,1,2),(58,'R-Skyhawk',1,1,2),(59,'S-Skyhawk',1,1,2),(60,'RG-Cutlass',1,1,2),(61,'A-Cardinal',1,1,2),(62,'B-Cardinal',1,1,2),(63,'RG-Cardinal',1,1,2),(64,'Skywagon',1,1,2),(65,'C182',1,1,2),(66,'C182A-Skylane',1,1,2),(67,'C182C',1,1,2),(68,'C182E-Skylane',1,1,2),(69,'C182N-Skylane',1,1,2),(70,'C182Q-Skylane',1,1,2),(71,'R182-Skylane RG',1,1,2),(72,'TR182-Turbo Skylane RG',1,1,2),(73,'C182R',1,1,2),(74,'T182',1,1,2),(75,'182S Skylane',1,1,2),(76,'T182T Skylane',1,1,2),(77,'Stationair',1,1,2),(78,'Soloy Mk1',2,1,2),(79,'Sloloy Mk2',2,1,2),(80,'Centurion',1,1,2),(81,'Corvalis TTX',1,1,2),(82,'Caravan I',2,1,2),(83,'Caravan 675',2,1,2),(84,'Cargomaster',2,1,2),(85,'Grand Caravan',2,1,2),(86,'Super Cargomaster',2,1,2),(87,'Caravan Amphibian',2,2,2),(88,'Soloy PathFinder 21',2,1,2),(89,'AT-400',2,1,3),(90,'AT-401',2,1,3),(91,'AT-402',2,1,3),(92,'AT-502',2,1,3),(93,'AT-602',2,1,3),(94,'AT-802F',2,2,3),(95,'206L',2,3,4),(96,'206L1',2,3,4),(97,'206L3',2,3,4),(98,'206L4',2,3,4),(99,'206LT',2,3,4),(100,'407',2,3,4),(101,'M25Y',1,4,5),(102,'GT26',1,4,6),(103,'1200',1,4,7),(104,'582',1,4,8),(105,'503',1,4,8),(106,'447',1,4,8),(107,'Jaribu',1,4,10),(108,'912',1,4,9),(109,'4S 912ULS',1,4,10),(110,'912S',1,4,10),(111,'07 914',1,4,11),(112,'M16',1,4,12),(113,'RST',1,4,13),(114,'Rotax 914 Turbo',1,4,14),(115,'JZ 18',1,4,15),(116,'JZ 20',1,4,15),(117,'JZ 22',1,4,15),(118,'JZ 25',1,4,15),(119,'JZ 30',1,4,15),(120,'JZ 35',1,4,15),(121,'JZ 40',1,4,15),(122,'CS 1600',1,4,15),(123,'CS 1800',1,4,15),(124,'CS 2000',1,4,15),(125,'CS 3000',1,4,15),(126,'CS 4000',1,4,15),(127,'CS 5000',1,4,15),(128,'DC 67',1,4,15),(129,'DC 70',1,4,15),(130,'DC 77',1,4,15),(131,'Kompress',1,4,16),(132,'Lambada',1,5,17),(133,'SF28',1,5,18),(134,'S10',1,5,19),(135,'S10-V',1,5,19),(136,'S10-VT',1,5,19),(137,'S10-15',1,5,19),(138,'20E',1,5,20),(139,'STD 3',3,6,21),(140,'D-6856',3,6,22),(141,'3',3,6,23),(142,'ASK 21',3,6,24),(143,'ASK 21 Mi',3,6,24),(144,'ASW 12',3,6,24),(145,'ASW 15',3,6,24),(146,'ASW 17',3,6,24),(147,'ASW 19',3,6,24),(148,'Cub',1,1,25),(149,'Cub Coupe',1,1,25),(150,'Cub Cruiser',1,1,25),(151,'Cub Special',1,1,25),(152,'Cuper Cruiser',1,1,25),(153,'Family Cruiser',1,1,25),(154,'Super Cub',1,1,25),(155,'Pacer',1,1,25),(156,'PA21',1,1,25),(157,'Apache',1,1,25),(158,'Aztec',1,1,25),(159,'Comanche',1,1,25),(160,'Pawnee',1,1,25),(161,'Cherokee',1,1,25),(162,'Warrior',1,1,25),(163,'Archer',1,1,25),(164,'Dakota',1,1,25),(165,'Arrow',1,1,25),(166,'Twin Comanche',1,1,25),(167,'Chieftain',1,1,25),(168,'Mojave',1,1,25),(169,'Navajo',1,1,25),(170,'Cheyenne',1,1,25),(171,'Cherokee Six',1,1,25),(172,'Lance',1,1,25),(173,'Saratoga',1,1,25),(174,'Seneca',1,1,25),(175,'Pawnee Brave',1,1,25),(176,'Tomahawk',1,1,25),(177,'Seminole',1,1,25),(178,'Malibu',1,1,25),(179,'Mirage',1,1,25),(180,'Meridian',1,1,25),(181,'Matrix',1,1,25),(182,'Piper Jet',1,1,25),(183,'VK-30',1,1,26),(184,'SRV',1,1,26),(185,'SR22',1,1,26),(186,'SR22 T',1,1,26),(187,'SF50',1,1,26),(188,'Katana',1,1,27),(189,'Star 180',1,1,27),(190,'Star TDI',1,1,27),(191,'DA 40-F',1,1,27),(192,'TDI Twin Star',1,1,27),(193,'360 Twin Star',1,1,27),(194,'VI',1,1,27),(195,'MPP',1,1,27),(196,'Opale',1,1,27),(197,'Super Star',1,1,27),(198,'Magnum',1,1,27),(199,'D-JET',1,1,27),(200,'MS 880',1,1,28),(201,'MS 881',1,1,28),(202,'MS 883',1,1,28),(203,'MS 885',1,1,28),(204,'MS 886',1,1,28),(205,'MS 890',1,1,28),(206,'MS 892',1,1,28),(207,'MS 893',1,1,28),(208,'MS 894 Minerva',1,1,28),(209,'MS 110 Galopin',1,1,28),(210,'GY-80',1,1,29),(211,'Diplomate',1,1,29),(212,'Tampico',1,1,29),(213,'Tobago',1,1,29),(214,'Tobago XL',1,1,29),(215,'Trinidad',1,1,29),(216,'TC Trinidad',1,1,29),(217,'Epsilon',1,1,29),(218,'TBM 700',1,1,29),(219,'TBM 850',1,1,29),(220,'TBM 900',1,1,29),(221,'RF-2',1,5,30),(222,'RF-3',1,5,30),(223,'RF4',1,5,30),(224,'RF-5',1,5,30),(225,'RF-6',1,1,30),(226,'RF-7',1,1,30),(227,'RF-8',1,5,30),(228,'RF-10',1,5,30),(229,'RF-47',1,1,30),(230,'200S Sparrow',1,4,31),(231,'200 SDT',1,4,31),(232,'230',1,4,31),(233,'Kite ULM',1,4,31),(234,'Kite LSA',1,1,31),(235,'Hawk',1,4,31),(236,'400',1,1,31),(237,'AH 130',1,4,31),(238,'C',1,1,32),(239,'CAP 20',1,1,33),(240,'CAP 20 L',1,1,33),(241,'CAP 21',1,1,33),(242,'CAP 230',1,1,33),(243,'CAP 231',1,1,33),(244,'EX',1,1,33),(245,'CAP 232',1,1,33),(246,'SC',1,1,33),(247,'MXS',1,1,33),(248,'100',1,1,34),(249,'100 T',1,1,34),(250,'110',1,1,34),(251,'300',1,1,35),(252,'300S',1,1,35),(253,'300L',1,1,35),(254,'300LP',1,1,35),(255,'330',1,1,35),(256,'330LC',1,1,35),(257,'330SC',1,1,35),(258,'S1',1,1,36),(259,'S-1C',1,1,36),(260,'S-1D',1,1,36),(261,'S-1E',1,1,36),(262,'S-1F',1,1,36),(263,'S-1S',1,1,36),(264,'S-1T',1,1,36),(265,'S-1-11B',1,1,36),(266,'S-2A',1,1,36),(267,'S-2B',1,1,36),(268,'S-2C',1,1,36),(269,'S-2E',1,1,36),(270,'S-2S',1,1,36),(271,'AA-5',1,1,37),(272,'AA-5A',1,1,37),(273,'AA-5B',1,1,37),(274,'AG-5B',1,1,37),(275,'Test',5,7,38);

--
-- Table structure for table `notification`
--

CREATE TABLE `notification` (
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:guid)',
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `is_read` tinyint(1) NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_BF5476CAA76ED395` (`user_id`),
  CONSTRAINT `FK_BF5476CAA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `notification`
--

INSERT INTO `notification` VALUES (1,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn Leçon à signer',0,'2023-04-21 12:52:13'),(2,'03877864-9f30-11ed-a278-0242ac120004','test2 Edit-test2 Edit: Leçonnn Leçon à signer',0,'2023-04-24 21:53:48'),(3,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn eththed à signer',0,'2023-04-26 15:15:01'),(4,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn Leçon 1 à signer',0,'2023-04-26 15:26:27'),(5,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn Leçon 2 à signer',0,'2023-04-26 15:28:56'),(6,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn rtyhryth à signer',0,'2023-04-26 15:41:05'),(7,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn Leçon extra à signer',0,'2023-05-05 15:52:42'),(8,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn leçonnn à signer',0,'2023-05-10 15:24:01'),(9,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn leçonnn à signer',0,'2023-05-10 15:43:32'),(10,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn leçonnn à signer',0,'2023-05-10 15:47:35'),(11,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn leçonnn à signer',0,'2023-05-10 15:49:30'),(12,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn leçonnn à signer',0,'2023-05-10 16:07:25'),(13,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn leçonnn à signer',0,'2023-05-10 16:08:13'),(14,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn leçonnn à signer',0,'2023-05-10 16:35:55'),(15,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn leçonnn à signer',0,'2023-05-10 16:36:25'),(16,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn leçonnn à signer',0,'2023-05-10 16:36:51'),(17,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn leçonnn à signer',0,'2023-05-10 16:37:13'),(18,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn leçonnn à signer',0,'2023-05-10 19:43:07'),(19,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn grzgr à signer',0,'2023-05-10 23:23:55'),(20,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-05-17 13:25:13'),(21,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-05-17 13:49:16'),(22,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-05-17 13:50:23'),(23,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-05-17 13:50:41'),(24,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-05-18 16:10:36'),(25,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-05-18 16:12:07'),(26,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN 2 à signer',0,'2023-05-18 20:30:13'),(27,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN 2 à signer',0,'2023-05-18 20:30:42'),(28,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN 2 à signer',0,'2023-05-18 20:35:20'),(29,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-05-24 16:10:37'),(30,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-05-24 17:25:14'),(31,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-05-24 17:25:35'),(32,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn fsdxgvxfvc gd à signer',0,'2023-05-30 23:49:14'),(33,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-06-02 19:37:02'),(34,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN 2 à signer',0,'2023-06-02 20:05:41'),(35,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-06-06 14:19:04'),(36,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-06-06 14:27:40'),(37,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-06-06 14:29:43'),(38,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-06-06 14:36:18'),(39,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-06-06 14:36:54'),(40,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-06-06 14:38:50'),(41,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-06-06 14:39:01'),(42,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-06-06 14:51:12'),(43,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-06-06 14:51:58'),(44,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-06-06 14:58:16'),(45,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-06-06 15:01:25'),(46,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-06-06 15:03:12'),(47,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-06-06 15:05:38'),(48,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-06-06 15:37:45'),(49,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-06-06 15:39:02'),(50,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-06-06 15:40:27'),(51,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-06-06 15:46:38'),(52,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-06-06 15:47:32'),(53,'03877864-9f30-11ed-a278-0242ac120004','test2 Edit-test2 Edit: Leçonnn dfhtgxbtdh à signer',0,'2023-06-12 18:11:30'),(54,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN à signer',0,'2023-06-15 11:38:31'),(55,'61b08719-e025-11ed-b103-0242ac120002','test2 Edit-test2 Edit: Leçonnn LEÇONNN 2 à signer',0,'2023-06-15 13:56:59');

--
-- Table structure for table `phases_detail`
--

CREATE TABLE `phases_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `phases_group_id` int NOT NULL,
  `abbreviation` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `flight_phase` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_69884265E4DA94E3` (`phases_group_id`),
  CONSTRAINT `FK_69884265E4DA94E3` FOREIGN KEY (`phases_group_id`) REFERENCES `phases_group` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phases_detail`
--

INSERT INTO `phases_detail` VALUES (4,2,'Abbréviation 2','zefzfz','fzeffz'),(5,3,'Abbréviation','fzefezfzf','zefzefez'),(6,4,'zfef','zfzef','zfzef'),(9,5,'fzefff','zfzfzefezf','fz'),(10,6,'A','B','C'),(11,6,'D','E','F'),(12,6,'G','H','I'),(13,6,'J','K','L'),(14,6,'M','N','O'),(15,6,'P','Q','R'),(16,6,'S','T','U'),(17,6,'V','W','X'),(18,6,'Y','Z','AA');

--
-- Table structure for table `phases_group`
--

CREATE TABLE `phases_group` (
  `id` int NOT NULL AUTO_INCREMENT,
  `phases_sub_group_id` int NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_5132CD2BA6D2EB60` (`phases_sub_group_id`),
  CONSTRAINT `FK_5132CD2BA6D2EB60` FOREIGN KEY (`phases_sub_group_id`) REFERENCES `phases_sub_group` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phases_group`
--

INSERT INTO `phases_group` VALUES (2,1,'2023-04-09 18:40:57'),(3,2,'2023-04-09 19:01:30'),(4,3,'2023-04-11 19:59:39'),(5,4,'2023-04-23 13:48:20'),(6,5,'2023-06-23 11:43:57');

--
-- Table structure for table `phases_group_formation_item`
--

CREATE TABLE `phases_group_formation_item` (
  `phases_group_id` int NOT NULL,
  `formation_item_id` int NOT NULL,
  PRIMARY KEY (`phases_group_id`,`formation_item_id`),
  KEY `IDX_774723FEE4DA94E3` (`phases_group_id`),
  KEY `IDX_774723FE57901725` (`formation_item_id`),
  CONSTRAINT `FK_774723FE57901725` FOREIGN KEY (`formation_item_id`) REFERENCES `formation_item` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_774723FEE4DA94E3` FOREIGN KEY (`phases_group_id`) REFERENCES `phases_group` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phases_group_formation_item`
--


--
-- Table structure for table `phases_sub_group`
--

CREATE TABLE `phases_sub_group` (
  `id` int NOT NULL AUTO_INCREMENT,
  `group_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phases_sub_group`
--

INSERT INTO `phases_sub_group` VALUES (1,'bfgdfgbs zef 2 Edit','2023-04-09 17:55:42'),(2,'bfgdfgbs zef 2','2023-04-09 19:00:57'),(3,'zgzzerf','2023-04-11 19:59:29'),(4,'test ','2023-04-23 13:47:11'),(5,'TEMs','2023-06-23 11:42:53');

--
-- Table structure for table `phases_sub_group_ato`
--

CREATE TABLE `phases_sub_group_ato` (
  `phases_sub_group_id` int NOT NULL,
  `ato_id` int NOT NULL,
  PRIMARY KEY (`phases_sub_group_id`,`ato_id`),
  KEY `IDX_6CA631EA6D2EB60` (`phases_sub_group_id`),
  KEY `IDX_6CA631E847DC024` (`ato_id`),
  CONSTRAINT `FK_6CA631E847DC024` FOREIGN KEY (`ato_id`) REFERENCES `ato` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_6CA631EA6D2EB60` FOREIGN KEY (`phases_sub_group_id`) REFERENCES `phases_sub_group` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `phases_sub_group_ato`
--

INSERT INTO `phases_sub_group_ato` VALUES (1,4),(2,3),(3,3),(4,3),(5,3);

--
-- Table structure for table `postal_address`
--

CREATE TABLE `postal_address` (
  `id` int NOT NULL AUTO_INCREMENT,
  `number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `street` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `city` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `zipcode` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `country` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=96 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `postal_address`
--

INSERT INTO `postal_address` VALUES (1,'11','zfzf','zefze','78505','FRANCE'),(2,'70','Rue de l\'Agriculture','Saint-Amand','7000','France'),(3,'','','fezfa','45151','FRANCE'),(4,'','','ZRFZ','zeFE','Fance'),(5,'','','zerffez','zrffrzfze','Espagne'),(6,'','','fze','zffe','faze'),(7,'','','test5','test5','test5'),(8,'','','test6','test6','test6'),(9,'','','test7','test7','test7'),(10,'','','test8','test8','test8'),(11,'','','test9','test9','test9'),(12,'11','zfeffze','zfze','zfzef','zefzfe'),(13,'12','zfezefez','zeefzef','zefzef','zefez'),(14,'11','zfezefez','zeefzef','zefzef','zefez'),(15,NULL,NULL,'','','zefez'),(16,'11','zfeffze','zfze','zfzef','zefzfe'),(17,'11','zfeffze','zfze','zfzef','zefzfe'),(18,'11','zfeffze','zfze','zfzef','zefzfe'),(19,'11','zfeffze','zfze','zfzef','zefzfe'),(20,'11','zfeffze','zfze','zfzef','zefzfe'),(21,'','','ZRFZ','zeFE','Fance'),(22,'11','zfeffze','zfze','zfzef','zefzfe'),(24,'11','zfeffze','zfze','zfzef','zefzfe'),(25,'11','zfeffze','zfze','zfzef','zefzfe'),(26,NULL,NULL,'','',''),(27,'','','','',''),(28,'','','','',''),(29,'','','','',''),(30,'','','','',''),(31,'','','','',''),(32,'','','','',''),(33,'','','','',''),(34,'','','','',''),(35,'','','','',''),(36,'','','','',''),(37,'','','','',''),(38,'','','','',''),(39,'','','','',''),(40,'','','','',''),(41,'','','','',''),(42,'','','','',''),(43,'','','','',''),(44,'11','fezfzfezfezf','zefezf','zezf','zefezf'),(46,'11','zfeffze','zfze','zfzef','zefzfe'),(47,'efe','zfezfz','test10','test10','france'),(48,'','','test10','test10','allemagne'),(49,'','','test10','test10','allemagne'),(50,'','','test10','test10','allemagne'),(51,'','','test10','test10','allemagne'),(52,'','','test10','test10','allemagne'),(53,'','','test10','test10','allemagne'),(54,'','','test10','test10','allemagne'),(55,'','','test10','test10','allemagne'),(56,'','','test10','test10','allemagne'),(58,'','','test10','test10','allemagne'),(59,'','','test11','test11','france'),(60,'','','test12','test12','france'),(61,'','','fezfa','45151','FRANCE'),(62,'','','test12','test12','france'),(63,'','','test12','test12','france'),(64,'','','test12','test12','france'),(65,'11','zefezf','zefezf','zefezf','ezfez'),(66,'11','zefezf','zefezf','zefezf','ezfez'),(67,'','','ZRFZ','zeFE','Fance'),(68,'','','zerffez','zrffrzfze','Espagne'),(69,'11','zfzefzefez','fezze','zfezfezf','armenie'),(70,'','','fezfa','45151','FRANCE'),(71,'','','fezfa','45151','FRANCE'),(72,'11','zfeffze','zfze','zfzef','zefzfe'),(73,'11','zfeffze','zfze','zfzef','zefzfe'),(74,'','','ZRFZ','zeFE','Fance'),(75,'','','zerffez','zrffrzfze','Espagne'),(76,'','','zerffez','zrffrzfze','Espagne'),(77,'','','zerffez','zrffrzfze','Espagne'),(78,'','','ZRFZ','zeFE','Fance'),(79,'','','zefzefez','45000','france'),(80,'354','ergergeggr','Paris','45555','France'),(81,'','','zerffez','zrffrzfze','Espagne'),(82,'','','zerffez','zrffrzfze','Espagne'),(83,'zfzef','zefzef','Orléans','45555','france'),(84,'23','rzfzfzef','Orléans','45555','france'),(85,'11','zfzefzefezfzf','Paris','45464','france'),(86,'11','zfzeff','zfzefzefe','454545','france'),(87,'23','rzfzfzef','Orléans','45555','france'),(88,'zfzef','zefzef','Orléans','45555','france'),(89,'11','zfeffze','zfze','zfzef','zefzfe'),(90,'','','fezfa','45151','FRANCE'),(91,'11','zfeffze','zfze','zfzef','zefzfe'),(92,'11','zfeffze','zfze','zfzef','zefzfe'),(93,'11','zfeffze','zfze','zfzef','zefzfe'),(94,'11','zfeffze','zfze','zfzef','zefzfe'),(95,'23','rzfzfzef','Orléans','45555','france');

--
-- Table structure for table `promotion`
--

CREATE TABLE `promotion` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ato_id` int NOT NULL,
  `created_at` datetime NOT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_C11D7DD1847DC024` (`ato_id`),
  CONSTRAINT `FK_C11D7DD1847DC024` FOREIGN KEY (`ato_id`) REFERENCES `ato` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `promotion`
--


--
-- Table structure for table `promotion_ato_user`
--

CREATE TABLE `promotion_ato_user` (
  `promotion_id` int NOT NULL,
  `ato_user_id` int NOT NULL,
  PRIMARY KEY (`promotion_id`,`ato_user_id`),
  KEY `IDX_4826C3F0139DF194` (`promotion_id`),
  KEY `IDX_4826C3F030A17E02` (`ato_user_id`),
  CONSTRAINT `FK_4826C3F0139DF194` FOREIGN KEY (`promotion_id`) REFERENCES `promotion` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_4826C3F030A17E02` FOREIGN KEY (`ato_user_id`) REFERENCES `ato_user` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `promotion_ato_user`
--


--
-- Table structure for table `promotion_formation`
--

CREATE TABLE `promotion_formation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `formation_id` int NOT NULL,
  `promotion_id` int NOT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_3137F092139DF194` (`promotion_id`),
  KEY `IDX_3137F0925200282E` (`formation_id`),
  CONSTRAINT `FK_3137F092139DF194` FOREIGN KEY (`promotion_id`) REFERENCES `promotion` (`id`),
  CONSTRAINT `FK_3137F0925200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `promotion_formation`
--


--
-- Table structure for table `rating`
--

CREATE TABLE `rating` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `next_when_unvalidate` tinyint(1) NOT NULL,
  `next_when_unrealized` tinyint(1) NOT NULL,
  `created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rating`
--

INSERT INTO `rating` VALUES (1,'test',0,0,'2023-04-05 19:53:58'),(6,'fgjhgjd',0,0,'2023-04-06 00:00:00'),(7,'test',0,0,'1900-01-07 00:00:00'),(26,'test2',0,0,'1900-01-08 00:00:00'),(27,'test2',0,0,'2023-01-09 00:00:00'),(28,'fezfzef',0,0,'2023-01-18 00:00:00'),(29,'gregre',0,0,'1900-01-10 19:54:35'),(30,'fgsbgr',1,1,'2023-04-10 19:54:38'),(31,'nv ,jbcx',1,0,'2023-04-11 00:00:00'),(32,'grsgsr',1,1,'1900-01-24 00:00:00'),(33,'hdgsfv',1,0,NULL),(34,'hfdgsgrfs',1,0,NULL),(35,'ththrrth',1,0,NULL),(36,'greefszr',1,1,NULL),(37,'zefez',1,1,NULL),(38,'fzeezf',1,1,NULL),(39,'zrefezf',1,1,NULL),(40,'fzeefz',0,0,NULL),(41,'TEST',1,1,'2023-04-26 15:21:14'),(42,'TEST 2 ',1,1,'2023-04-26 15:21:37'),(43,'TEST 3 ',1,1,'2023-04-26 15:22:07'),(44,'Test formation',1,1,'2023-05-05 18:26:00'),(45,'ehtrgehgrt',1,1,'2023-06-02 21:16:16'),(46,'test 3',0,1,'2023-06-02 21:22:05');

--
-- Table structure for table `rating_ato`
--

CREATE TABLE `rating_ato` (
  `rating_id` int NOT NULL,
  `ato_id` int NOT NULL,
  PRIMARY KEY (`rating_id`,`ato_id`),
  KEY `IDX_39D385C7A32EFC6` (`rating_id`),
  KEY `IDX_39D385C7847DC024` (`ato_id`),
  CONSTRAINT `FK_39D385C7847DC024` FOREIGN KEY (`ato_id`) REFERENCES `ato` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_39D385C7A32EFC6` FOREIGN KEY (`rating_id`) REFERENCES `rating` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rating_ato`
--

INSERT INTO `rating_ato` VALUES (1,2),(6,2),(7,3),(26,2),(26,4),(27,3),(28,3),(29,3),(30,3),(31,3),(32,2),(32,3),(33,2),(34,2),(34,3),(35,2),(35,4),(36,2),(36,3),(37,2),(37,4),(38,4),(39,2),(39,5),(40,3),(41,3),(42,3),(43,3),(44,3),(45,3),(46,3);

--
-- Table structure for table `rating_value`
--

CREATE TABLE `rating_value` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rating_type_id` int NOT NULL,
  `value` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `validate_exercise` tinyint(1) DEFAULT NULL,
  `position` int NOT NULL,
  `media_value_id` int DEFAULT NULL,
  `color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `exercise_notperformed` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_80615708F6419510` (`media_value_id`),
  KEY `IDX_80615708260075EB` (`rating_type_id`),
  CONSTRAINT `FK_80615708260075EB` FOREIGN KEY (`rating_type_id`) REFERENCES `rating` (`id`),
  CONSTRAINT `FK_80615708F6419510` FOREIGN KEY (`media_value_id`) REFERENCES `media_object` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=75 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rating_value`
--

INSERT INTO `rating_value` VALUES (1,1,'test',1,0,NULL,'#000000','test',0),(2,1,'test',1,1,NULL,'#000000','test',0),(11,6,'',1,0,10,'#000000','',0),(12,6,'---',0,1,NULL,'#000000','',1),(13,7,'test',1,0,NULL,'#000000','',0),(14,7,'test2',0,1,NULL,'#000000','',1),(29,27,'test2 v2',1,0,NULL,'#000000','',0),(30,27,'test2 v2',0,1,NULL,'#000000','',1),(31,28,'zfzef',1,0,14,'#000000','',0),(32,28,'zefze',0,1,15,'#000000','',1),(33,29,'egrgr',1,0,NULL,'#000000','',0),(34,29,'gre',0,1,NULL,'#000000','',0),(35,30,'rgrg',1,0,NULL,'#000000','',0),(36,30,'sgsg',0,1,NULL,'#000000','',1),(37,31,'ngffgs',1,0,NULL,'#000000','',0),(38,31,'fsgbng',0,1,NULL,'#000000','',1),(40,32,'dhteh',0,1,NULL,'#000000','',1),(41,33,'fsgfgb',0,0,NULL,'#000000','',0),(42,33,'fdhgs',0,1,NULL,'#000000','',0),(43,34,'egdtrgrsf',0,0,NULL,'#000000','',0),(44,34,'sgf',0,1,NULL,'#000000','',0),(45,35,'trdhrdh',1,0,NULL,'#000000','',0),(46,35,'rthrth',0,1,NULL,'#000000','',1),(47,36,'hte',1,0,NULL,'#000000','',0),(48,36,'ryjhtzrg',0,1,NULL,'#000000','',0),(49,37,'zef',1,0,NULL,'#000000','',0),(50,37,'zef',0,1,NULL,'#000000','',0),(51,38,'f',1,0,NULL,'#000000','',0),(52,38,'z',0,1,NULL,'#000000','',0),(53,39,'zef',1,0,NULL,'#000000','',0),(54,39,'fe',0,1,NULL,'#000000','',0),(55,40,'zeffez',1,0,NULL,'#000000','',0),(56,40,'ezffze',0,1,NULL,'#000000','',1),(57,41,'Oui',1,0,NULL,'#000000','Oui',0),(58,41,'Non',0,1,NULL,'#000000','Non',0),(59,41,'-',0,2,NULL,'#000000','-',1),(60,42,'OK',1,0,NULL,'#73e148','OK',0),(61,42,'KO',0,1,NULL,'#da3326','KO',0),(62,42,'-',0,2,NULL,'#000000','-',1),(63,43,'Valide',1,0,NULL,'#000000','Valide',0),(64,43,'Non valide',0,1,NULL,'#000000','Non valide',0),(65,43,'-',0,2,NULL,'#000000','-',1),(66,44,'OK',1,0,NULL,'#000000','',0),(67,44,'KO',0,1,NULL,'#000000','',0),(68,44,'=',0,2,NULL,'#000000','',0),(69,45,'egr',1,0,NULL,'#000000','erg',0),(70,45,'rzg',0,1,NULL,'#000000','erzg',0),(71,45,'fezfez',0,2,NULL,'#000000','ezf',1),(72,46,'test',1,0,NULL,'#000000','test',0),(73,46,'test 2',0,1,NULL,'#000000','',0),(74,46,'test 3',0,2,NULL,'#000000','',1);

--
-- Table structure for table `rating_value_reasons`
--

CREATE TABLE `rating_value_reasons` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rating_id` int NOT NULL,
  `group_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_21127A34A32EFC6` (`rating_id`),
  CONSTRAINT `FK_21127A34A32EFC6` FOREIGN KEY (`rating_id`) REFERENCES `rating` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rating_value_reasons`
--

INSERT INTO `rating_value_reasons` VALUES (1,1,'efzfezf','2023-03-21 22:01:20'),(6,31,'test33TEST','2023-04-04 20:21:46'),(7,31,'grzgzr','2023-04-04 20:57:32'),(8,36,'gzrgrgeg','2023-04-04 20:57:39'),(9,7,'eghrgerg','2023-04-04 20:57:43'),(13,41,'TEST motif de note','2023-05-06 13:42:18'),(14,42,'TEST 2 motif de la note','2023-05-06 15:28:00'),(15,43,'TEST 3 Motif de la note','2023-05-06 15:29:42');

--
-- Table structure for table `rating_value_reasons_details`
--

CREATE TABLE `rating_value_reasons_details` (
  `id` int NOT NULL AUTO_INCREMENT,
  `rating_value_id` int NOT NULL,
  `rating_value_reasons_id` int NOT NULL,
  `code` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_FD4E9D31634A6869` (`rating_value_reasons_id`),
  KEY `IDX_FD4E9D31A71D0E55` (`rating_value_id`),
  CONSTRAINT `FK_FD4E9D31634A6869` FOREIGN KEY (`rating_value_reasons_id`) REFERENCES `rating_value_reasons` (`id`),
  CONSTRAINT `FK_FD4E9D31A71D0E55` FOREIGN KEY (`rating_value_id`) REFERENCES `rating_value` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=62 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `rating_value_reasons_details`
--

INSERT INTO `rating_value_reasons_details` VALUES (6,37,7,'zgrrgrzg','egregrg'),(9,47,8,'egerg','ergrg'),(40,37,6,'Code','zefzefzef'),(41,37,6,'Code 2','faef EDIT'),(44,57,13,'tezeze','fzefezfzefzefze'),(45,57,13,'zfzefzef 2','zfzfzefzef 2'),(46,58,13,'jytgrzs','jryhrgz'),(47,58,13,'jytfgerz 2','htyrjrgz 2'),(48,59,13,'hyjrrzg','ryhjregz'),(49,59,13,'hjyrtrgz 2','bxcvryjt 2'),(50,60,14,'grezzrgf','rzgfgrzf'),(51,60,14,'grezzrgf 2','rzgfgrzf 2'),(52,61,14,'ergfvrgg','egrrgergr'),(53,61,14,'ergfvrgg 2','egrrgergr 2'),(54,62,14,'zrfzefez','zefezfz'),(55,62,14,'zfzefezf 2',' grgrzz 2'),(56,63,15,'fzefezfez','zfefzefez'),(57,63,15,'zrzef 2 ','zrvrf 2'),(58,64,15,'gzfzefz ','zefzefez'),(59,64,15,'aerg 2','fezazed 2'),(60,65,15,'fzefzfezf ','zefzefez'),(61,65,15,'fezfzf 2',' efzfe 2');

--
-- Table structure for table `refresh_tokens`
--

CREATE TABLE `refresh_tokens` (
  `id` int NOT NULL AUTO_INCREMENT,
  `refresh_token` varchar(128) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `valid` datetime NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_9BACE7E1C74F2195` (`refresh_token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `refresh_tokens`
--


--
-- Table structure for table `resources`
--

CREATE TABLE `resources` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `ato_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_EF66EBAE847DC024` (`ato_id`),
  CONSTRAINT `FK_EF66EBAE847DC024` FOREIGN KEY (`ato_id`) REFERENCES `ato` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=36 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `resources`
--

INSERT INTO `resources` VALUES (1,'dzad','resource_classroom',2),(4,'dazd','resource_aircraft',2),(5,'gzrzgg','resource_aircraft',5),(8,'tetehet','resource_aircraft',4),(9,'','resource_aircraft',4),(10,'','resource_aircraft',2),(12,'testSA','resource_classroom',3),(13,'testSA2','resource_classroom',5),(17,'gregeg','resource_aircraft',2),(20,'gjdhhtdeg','resource_aircraft',NULL),(22,'azerytrt','resource_aircraft',NULL),(23,'rethtr','resource_aircraft',2),(24,'liujgd','resource_aircraft',2),(25,'sfghjgd Edit','resource_aircraft',3),(27,'test edit','resource_aircraft',2),(28,'rethtr 2','resource_aircraft',NULL),(29,'rethtr 2','resource_aircraft',2),(30,'nimp','resource_aircraft',3),(31,'nimp 2','resource_aircraft',NULL),(32,'nimp 3','resource_aircraft',NULL),(33,'nimp 5','resource_aircraft',NULL),(35,'test SA 2','resource_classroom',3);

--
-- Table structure for table `resources_session`
--

CREATE TABLE `resources_session` (
  `resources_id` int NOT NULL,
  `session_id` int NOT NULL,
  PRIMARY KEY (`resources_id`,`session_id`),
  KEY `IDX_6E458FB3ACFC5BFF` (`resources_id`),
  KEY `IDX_6E458FB3613FECDF` (`session_id`),
  CONSTRAINT `FK_6E458FB3613FECDF` FOREIGN KEY (`session_id`) REFERENCES `session` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_6E458FB3ACFC5BFF` FOREIGN KEY (`resources_id`) REFERENCES `resources` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `resources_session`
--

INSERT INTO `resources_session` VALUES (12,2),(12,81),(12,82),(12,83),(12,84),(12,85),(12,86),(12,88),(12,89),(12,90),(12,118),(12,123),(12,124),(12,125),(12,126),(12,127),(12,130),(12,131),(12,133),(12,134),(12,136),(12,137),(12,138),(12,139),(12,140);

--
-- Table structure for table `session`
--

CREATE TABLE `session` (
  `id` int NOT NULL AUTO_INCREMENT,
  `instructor_id` int NOT NULL,
  `start_at` datetime NOT NULL,
  `end_at` datetime DEFAULT NULL,
  `comments` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `is_theoretical` tinyint(1) NOT NULL,
  `formation_id` int NOT NULL,
  `lesson_id` int DEFAULT NULL,
  `lesson_notation_id` int DEFAULT NULL,
  `bloc_time` int DEFAULT NULL,
  `flight_time` int DEFAULT NULL,
  `lesson_extra_id` int DEFAULT NULL,
  `instructor_signature_id` int DEFAULT NULL,
  `success` tinyint(1) NOT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `pdf_file_id` int DEFAULT NULL,
  `validate_at` datetime DEFAULT NULL,
  `correction_id` int DEFAULT NULL,
  `departure_airport_id` int DEFAULT NULL,
  `arrival_airport_id` int DEFAULT NULL,
  `aircraft_id` int DEFAULT NULL,
  `resources_id` int DEFAULT NULL,
  `module_notation_id` int DEFAULT NULL,
  `module_group_notation_id` int DEFAULT NULL,
  `module_reason_id` int DEFAULT NULL,
  `module_group_reason_id` int DEFAULT NULL,
  `module_comments` longtext COLLATE utf8mb4_unicode_ci,
  `module_group_comments` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_D044D5D463D2D5DF` (`lesson_extra_id`),
  UNIQUE KEY `UNIQ_D044D5D41AE37126` (`instructor_signature_id`),
  UNIQUE KEY `UNIQ_D044D5D4E071F843` (`pdf_file_id`),
  UNIQUE KEY `UNIQ_D044D5D494AE086B` (`correction_id`),
  KEY `IDX_D044D5D48C4FC193` (`instructor_id`),
  KEY `IDX_D044D5D45200282E` (`formation_id`),
  KEY `IDX_D044D5D4CDF80196` (`lesson_id`),
  KEY `IDX_D044D5D467595CFC` (`lesson_notation_id`),
  KEY `IDX_D044D5D4F631AB5C` (`departure_airport_id`),
  KEY `IDX_D044D5D47F43E343` (`arrival_airport_id`),
  KEY `IDX_D044D5D4846E2F5C` (`aircraft_id`),
  KEY `IDX_D044D5D4ACFC5BFF` (`resources_id`),
  KEY `IDX_D044D5D418ABBD25` (`module_notation_id`),
  KEY `IDX_D044D5D43AE61306` (`module_group_notation_id`),
  KEY `IDX_D044D5D43DA0A5A` (`module_reason_id`),
  KEY `IDX_D044D5D464B2EEF9` (`module_group_reason_id`),
  CONSTRAINT `FK_D044D5D418ABBD25` FOREIGN KEY (`module_notation_id`) REFERENCES `rating_value` (`id`),
  CONSTRAINT `FK_D044D5D41AE37126` FOREIGN KEY (`instructor_signature_id`) REFERENCES `signature` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_D044D5D43AE61306` FOREIGN KEY (`module_group_notation_id`) REFERENCES `rating_value` (`id`),
  CONSTRAINT `FK_D044D5D43DA0A5A` FOREIGN KEY (`module_reason_id`) REFERENCES `rating_value_reasons_details` (`id`),
  CONSTRAINT `FK_D044D5D45200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`),
  CONSTRAINT `FK_D044D5D463D2D5DF` FOREIGN KEY (`lesson_extra_id`) REFERENCES `extra_lesson` (`id`),
  CONSTRAINT `FK_D044D5D464B2EEF9` FOREIGN KEY (`module_group_reason_id`) REFERENCES `rating_value_reasons_details` (`id`),
  CONSTRAINT `FK_D044D5D467595CFC` FOREIGN KEY (`lesson_notation_id`) REFERENCES `rating_value` (`id`),
  CONSTRAINT `FK_D044D5D47F43E343` FOREIGN KEY (`arrival_airport_id`) REFERENCES `airport` (`id`),
  CONSTRAINT `FK_D044D5D4846E2F5C` FOREIGN KEY (`aircraft_id`) REFERENCES `aircraft` (`id`),
  CONSTRAINT `FK_D044D5D48C4FC193` FOREIGN KEY (`instructor_id`) REFERENCES `ato_user` (`id`),
  CONSTRAINT `FK_D044D5D494AE086B` FOREIGN KEY (`correction_id`) REFERENCES `session` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_D044D5D4ACFC5BFF` FOREIGN KEY (`resources_id`) REFERENCES `resources` (`id`),
  CONSTRAINT `FK_D044D5D4CDF80196` FOREIGN KEY (`lesson_id`) REFERENCES `formation_item` (`id`),
  CONSTRAINT `FK_D044D5D4E071F843` FOREIGN KEY (`pdf_file_id`) REFERENCES `media_object` (`id`),
  CONSTRAINT `FK_D044D5D4F631AB5C` FOREIGN KEY (`departure_airport_id`) REFERENCES `airport` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=248 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `session`
--

INSERT INTO `session` VALUES (1,33,'2023-04-21 12:47:00','2023-04-24 21:32:00','',0,14,63,32,4845,0,NULL,2,0,'toSign',NULL,NULL,NULL,172,172,30,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,33,'2023-04-20 21:50:51','2023-04-21 12:50:51','Commentaire Appréciation Leçonnn',1,2,46,29,0,0,NULL,1,1,'toSign',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,33,'2023-04-26 11:00:00','2023-04-26 11:00:00','',0,17,78,13,0,0,NULL,3,0,'validated',NULL,'2023-04-26 11:01:17',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,33,'2023-04-26 11:43:00','2023-04-26 11:45:00','',0,17,78,13,2,0,NULL,5,0,'validated',NULL,'2023-04-26 11:48:15',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,33,'2023-04-26 11:48:00','2023-04-26 11:59:00','',0,17,79,40,11,0,NULL,7,0,'validated',NULL,'2023-04-26 12:02:02',NULL,58,58,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,33,'2023-04-26 20:00:00','2023-04-26 12:28:00','',0,17,78,14,452,0,NULL,9,0,'validated',NULL,'2023-04-26 12:30:06',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,33,'2023-04-25 18:00:00','2023-04-26 13:02:00','',0,17,79,40,1142,0,NULL,11,0,'validated',NULL,'2023-04-26 15:03:42',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,33,'2023-04-26 15:13:00','2023-04-26 13:13:00','',0,17,NULL,NULL,0,0,3,13,0,'validated',NULL,'2023-04-26 15:15:59',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(14,33,'2023-04-26 15:25:00','2023-04-26 13:26:00','',0,18,83,57,1,0,NULL,15,1,'validated',NULL,'2023-04-26 15:26:42',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(15,33,'2023-04-26 15:27:00','2023-04-26 13:28:00','',0,18,84,57,1,0,NULL,17,1,'validated',NULL,'2023-04-26 15:29:10',NULL,10,17,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,33,'2023-04-26 15:38:00','2023-04-26 13:40:00','',0,18,NULL,57,2,0,4,19,1,'validated',NULL,'2023-04-26 15:41:44',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(18,33,'2023-04-25 15:45:00','2023-04-26 13:46:00','',0,18,83,57,1441,0,NULL,21,0,'validated',NULL,'2023-04-26 15:48:03',NULL,37,37,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(19,33,'2023-04-27 15:32:00','2023-04-27 17:27:00','',0,18,NULL,57,115,0,5,23,1,'validated',NULL,'2023-04-27 17:27:37',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,33,'2023-05-02 03:00:00','2023-05-02 21:00:00','',0,21,105,57,960,0,NULL,25,1,'validated',NULL,'2023-05-02 21:01:46',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,33,'2023-05-03 20:38:00','2023-05-03 20:44:00','',0,19,88,57,6,0,NULL,27,1,'validated',NULL,'2023-05-03 20:45:14',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,33,'2023-05-04 10:56:00','2023-05-04 11:56:00','',0,21,106,57,60,0,NULL,29,1,'validated',NULL,'2023-05-04 12:09:33',NULL,10,17,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,33,'2023-05-05 14:37:00','2023-05-05 15:47:00','',0,22,132,60,70,0,NULL,31,1,'validated',NULL,'2023-05-05 15:49:43',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(37,33,'2023-05-05 15:50:00','2023-05-05 15:52:00','getrzefergtzrg zrg rzg  rgz  ',0,22,NULL,13,2,0,6,33,1,'validated',NULL,'2023-05-05 16:03:36',NULL,17,17,30,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,33,'2023-05-05 16:04:00','2023-05-05 16:36:00','',0,22,133,61,32,0,NULL,35,1,'validated',NULL,'2023-05-05 16:36:59',NULL,37,11,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,33,'2023-05-05 16:42:00','2023-05-05 16:43:00','',0,22,NULL,14,1,0,7,37,0,'validated',NULL,'2023-05-05 16:43:28',NULL,1714,9,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(41,33,'2023-05-08 12:55:00','2023-05-08 12:56:00','',0,20,138,60,1,0,NULL,39,1,'validated',NULL,'2023-05-08 12:57:28',NULL,37,37,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(42,33,'2023-05-08 13:24:00','2023-05-08 13:34:00','',0,20,138,60,10,0,NULL,41,1,'validated',NULL,'2023-05-08 13:35:09',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,33,'2023-05-10 22:56:00','2023-05-10 23:14:00','',0,23,144,57,18,0,NULL,52,1,'validated',NULL,'2023-05-10 23:18:48',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(60,33,'2023-05-10 23:22:00','2023-05-10 23:23:00','',0,23,NULL,57,1,0,9,54,1,'validated',NULL,'2023-05-10 23:26:46',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(62,33,'2023-05-10 23:26:00','2023-05-10 23:46:00','',0,23,145,57,20,0,NULL,56,1,'validated',NULL,'2023-05-10 23:47:11',NULL,10,26,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(64,33,'2023-05-11 16:20:00','2023-05-11 16:44:00','',0,23,NULL,57,24,0,11,58,1,'validated',NULL,'2023-05-11 16:44:59',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(67,33,'2023-05-12 23:38:00','2023-05-12 23:39:00','',0,24,155,60,1,0,NULL,60,0,'validated',NULL,'2023-05-12 23:42:18',NULL,10,43,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(70,33,'2023-05-13 15:24:00','2023-05-13 18:13:00','',0,25,161,NULL,169,0,NULL,62,0,'validated',NULL,'2023-05-13 18:15:37',NULL,10,50,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,33,'2023-05-14 15:17:00','2023-05-14 15:35:00','grezzg',0,26,164,58,18,0,NULL,64,1,'validated',NULL,'2023-05-14 15:36:15',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(76,33,'2023-05-15 23:08:00','2023-05-15 23:27:00','',0,22,132,60,19,0,NULL,66,1,'validated',NULL,'2023-05-15 23:28:03',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(81,33,'2023-05-17 11:14:00','2023-05-17 13:29:00','',1,27,174,60,0,0,NULL,68,1,'Edited',NULL,NULL,85,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(82,33,'2023-05-17 13:48:52','2023-05-17 16:48:52','poluikujhfgbdv',1,27,174,60,0,0,NULL,69,1,'validated',NULL,'2023-05-17 13:50:12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,33,'2023-05-17 13:48:52','2023-05-17 16:48:52','poluikujhfgbdv',1,27,174,60,0,0,NULL,72,1,'Edited',NULL,NULL,84,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(84,33,'2023-05-17 13:48:52','2023-05-17 16:48:52','poluikujhfgbdv',1,27,174,60,0,0,NULL,NULL,1,'toSign',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(85,33,'2023-05-17 11:14:00','2023-05-17 13:29:00','',1,27,174,60,0,0,NULL,NULL,1,'toSign',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(86,33,'2023-05-18 16:10:04','2023-05-18 18:40:04','',1,28,186,60,0,0,NULL,73,1,'validated',NULL,'2023-05-18 20:36:06',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(88,33,'2023-05-18 20:29:43','2023-05-18 22:34:43','',1,28,187,60,0,0,NULL,74,0,'validated',NULL,'2023-05-18 20:36:13',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(89,33,'2023-05-18 20:29:43','2023-05-18 22:34:43','',1,28,187,60,0,0,NULL,75,0,'validated',NULL,'2023-05-18 20:36:19',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(90,33,'2023-05-18 20:29:43','2023-05-18 22:34:43','',1,28,187,60,0,0,NULL,76,0,'validated',NULL,'2023-05-18 20:36:30',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(92,33,'2023-05-19 15:12:00','2023-05-19 15:20:00','yjhtgfvsdc',0,24,NULL,NULL,8,0,15,81,0,'validated',NULL,'2023-05-19 15:20:20',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(93,33,'2023-05-19 15:21:00','2023-05-19 15:21:00','',0,26,NULL,57,0,0,16,83,0,'validated',NULL,'2023-05-19 15:21:43',NULL,58,20,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(100,33,'2023-05-22 22:52:00','2023-05-22 23:02:00','',0,41,241,57,10,0,NULL,85,0,'validated',NULL,'2023-05-22 23:05:30',NULL,10,43,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(107,33,'2023-05-25 11:05:00','2023-05-25 11:05:00','',0,45,259,58,0,0,NULL,88,0,'validated',NULL,'2023-05-25 11:06:19',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(108,33,'2023-05-25 11:06:00','2023-05-25 11:07:00','',0,45,NULL,57,1,0,18,90,1,'validated',NULL,'2023-05-25 11:07:41',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(109,33,'2023-05-25 14:14:00','2023-05-25 14:22:00','erezfzef',0,46,269,63,8,0,NULL,92,1,'validated',NULL,'2023-05-25 14:23:34',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(110,33,'2023-05-25 14:24:00','2023-05-25 14:42:00','',0,46,NULL,63,18,0,19,94,1,'validated',NULL,'2023-05-25 14:43:25',NULL,10,10,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(112,33,'2023-05-25 15:58:00','2023-05-25 15:58:00','',0,48,274,57,0,0,NULL,96,1,'validated',NULL,'2023-05-25 15:59:36',NULL,10,17,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(113,33,'2023-05-25 16:00:00','2023-05-25 16:00:00','',0,48,NULL,57,0,0,21,98,1,'validated',NULL,'2023-05-25 16:01:01',NULL,58,58,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(118,33,'2023-05-29 17:31:00','2023-05-30 23:48:00','',1,48,NULL,57,1817,0,25,100,1,'validated',NULL,'2023-06-06 14:06:47',NULL,NULL,NULL,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(121,33,'2023-06-01 11:00:00','2023-06-01 12:12:00','',0,50,288,57,72,6,NULL,101,1,'validated',NULL,'2023-06-01 12:22:04',NULL,30,26,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(122,33,'2023-06-01 12:27:00','2023-06-01 12:30:00','',0,50,289,57,3,3,NULL,103,1,'validated',NULL,'2023-06-01 12:30:56',NULL,19,51,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(123,33,'2023-06-02 19:22:04','2023-06-02 19:36:00','',1,43,247,57,14,0,NULL,105,0,'validated',NULL,'2023-06-02 19:52:01',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(124,33,'2023-06-02 19:46:29','2023-06-02 20:05:00','',1,43,248,57,19,0,NULL,107,1,'validated',NULL,'2023-06-06 14:02:52',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(125,33,'2023-06-06 12:53:14','2023-06-06 14:18:00','',1,42,244,57,85,0,NULL,110,1,'validated',NULL,'2023-06-06 14:19:51',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(126,33,'2023-06-06 13:04:58','2023-06-06 14:26:00','',1,42,244,59,81,0,NULL,112,0,'Edited',NULL,NULL,127,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(127,33,'2023-06-06 13:04:58','2023-06-06 14:26:00','',1,42,244,59,81,0,NULL,113,0,'validated',NULL,'2023-06-06 14:33:12',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(130,33,'2023-06-06 13:18:22','2023-06-06 14:33:00','',1,42,244,57,75,0,NULL,115,1,'Edited',NULL,NULL,131,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(131,33,'2023-06-06 13:18:22','2023-06-06 14:33:00','',1,42,244,57,75,0,NULL,116,1,'validated',NULL,'2023-06-06 14:37:47',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(133,33,'2023-06-06 13:23:06','2023-06-06 14:38:00','',1,42,244,57,75,0,NULL,118,1,'Edited',NULL,NULL,134,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(134,33,'2023-06-06 13:23:06','2023-06-06 14:38:00','',1,42,244,57,75,0,NULL,119,1,'validated',NULL,'2023-06-06 14:50:31',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(136,33,'2023-06-06 13:35:38','2023-06-06 14:50:00','test',1,42,244,57,74,0,NULL,121,1,'Edited',NULL,NULL,137,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(137,33,'2023-06-06 13:35:38','2023-06-06 14:50:00','test',1,42,244,57,74,0,NULL,122,1,'Edited',NULL,NULL,138,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(138,33,'2023-06-06 13:35:38','2023-06-06 14:50:00','test',1,42,244,57,74,0,NULL,123,1,'Edited',NULL,NULL,139,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(139,33,'2023-06-06 13:35:38','2023-06-06 14:50:00','test',1,42,244,57,74,0,NULL,124,1,'Edited',NULL,NULL,140,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(140,33,'2023-06-06 13:35:38','2023-06-06 14:50:00','test',1,42,244,57,74,0,NULL,125,1,'Edited',NULL,NULL,141,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(141,33,'2023-06-06 13:35:38','2023-06-06 14:50:00','test',1,42,244,57,74,0,NULL,126,1,'validated',NULL,'2023-06-06 15:17:40',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(146,33,'2023-06-06 14:19:23','2023-06-06 15:37:00','',1,42,244,57,78,0,NULL,128,1,'Edited',NULL,NULL,147,NULL,NULL,NULL,35,NULL,NULL,NULL,NULL,NULL,NULL),(147,33,'2023-06-06 14:19:23','2023-06-06 15:37:00','',1,42,244,57,78,0,NULL,129,1,'Edited',NULL,NULL,148,NULL,NULL,NULL,12,NULL,NULL,NULL,NULL,NULL,NULL),(148,33,'2023-06-06 14:19:23','2023-06-06 15:37:00','',1,42,244,57,78,0,NULL,130,1,'Edited',NULL,NULL,149,NULL,NULL,NULL,35,NULL,NULL,NULL,NULL,NULL,NULL),(149,33,'2023-06-06 14:19:23','2023-06-06 15:37:00','',1,42,244,57,78,0,NULL,131,1,'Edited',NULL,NULL,150,NULL,NULL,NULL,12,NULL,NULL,NULL,NULL,NULL,NULL),(150,33,'2023-06-06 14:19:23','2023-06-06 15:37:00','',1,42,244,57,78,0,NULL,132,1,'validated',NULL,'2023-06-06 15:48:31',NULL,NULL,NULL,NULL,35,NULL,NULL,NULL,NULL,NULL,NULL),(152,33,'2023-06-07 14:00:00','2023-06-07 14:34:00','',0,50,290,57,34,34,NULL,134,1,'validated',NULL,'2023-06-07 14:34:28',NULL,10,50,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(154,33,'2023-06-08 17:16:00','2023-06-08 17:56:00','',0,52,363,58,40,6,NULL,136,1,'validated',NULL,'2023-06-08 18:00:29',NULL,10,37,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(155,33,'2023-06-08 18:23:00','2023-06-08 18:26:00','',0,52,364,58,3,0,NULL,138,1,'validated',NULL,'2023-06-08 18:26:43',NULL,14,14,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(156,33,'2023-06-09 12:08:00','2023-06-09 12:13:00','',0,52,363,58,5,0,NULL,140,1,'validated',NULL,'2023-06-09 12:14:22',NULL,10,10,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(157,33,'2023-06-09 12:15:00','2023-06-09 12:18:00','',0,52,364,57,3,0,NULL,142,1,'validated',NULL,'2023-06-09 12:19:18',NULL,10,50,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(158,33,'2023-06-09 12:56:00','2023-06-09 12:57:00','',0,53,373,57,1,0,NULL,144,0,'validated',NULL,'2023-06-09 12:59:25',NULL,10,21,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(159,33,'2023-06-09 12:59:00','2023-06-09 13:00:00','',0,53,374,58,1,0,NULL,146,1,'validated',NULL,'2023-06-09 13:01:01',NULL,21,31,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(160,33,'2023-06-09 13:02:00','2023-06-09 13:02:00','',0,53,375,57,0,0,NULL,148,1,'validated',NULL,'2023-06-09 13:02:58',NULL,31,1570,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(161,33,'2023-06-09 13:02:00','2023-06-09 13:03:00','',0,53,376,57,1,0,NULL,150,1,'validated',NULL,'2023-06-09 13:03:28',NULL,1570,593,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(165,33,'2023-06-09 19:46:00','2023-06-09 19:52:00','',0,54,396,60,6,0,NULL,152,1,'validated',NULL,'2023-06-09 19:53:06',NULL,10,58,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(168,33,'2023-06-11 11:10:00','2023-06-11 17:43:00','Leçon non OK',0,54,397,61,393,0,NULL,158,0,'validated',NULL,'2023-06-11 17:51:43',NULL,10,21,25,25,60,NULL,50,NULL,'Module OK - grezzrgf',NULL),(170,33,'2023-06-11 20:15:00','2023-06-11 21:02:00','Note Leçonnn',0,62,430,57,47,5,NULL,160,1,'validated',NULL,'2023-06-11 21:03:06',NULL,10,21,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(171,33,'2023-06-11 21:03:00','2023-06-11 21:03:00','Note Leçonnn 2',0,62,431,60,0,0,NULL,162,1,'validated',NULL,'2023-06-11 21:11:01',NULL,10,21,25,25,60,NULL,50,NULL,'Finalisation module 1 - grezzrgf',NULL),(172,33,'2023-06-11 21:11:00','2023-06-11 21:34:00','Note leçonnn 3',0,62,432,60,23,0,NULL,164,1,'validated',NULL,'2023-06-11 21:43:51',NULL,10,21,25,25,60,57,50,45,'Note moduleee 3 - grezzrgf','Note groupe module 1 - zfzefzef 2'),(173,33,'2023-06-11 22:01:00','2023-06-11 22:02:00','Note leçonnn 4',0,62,433,57,1,0,NULL,166,1,'validated',NULL,'2023-06-11 22:02:40',NULL,10,21,25,25,60,NULL,51,NULL,'Note moduleee 3',NULL),(174,33,'2023-06-12 18:06:00','2023-06-12 18:11:00','Note leçonnn extra théorique multiple',1,43,NULL,57,5,10,27,168,1,'toSign',NULL,NULL,NULL,NULL,NULL,25,12,NULL,NULL,NULL,NULL,NULL,NULL),(177,33,'2023-06-13 14:34:00','2023-06-13 14:56:00','',0,63,441,NULL,22,10,NULL,169,1,'validated',NULL,'2023-06-13 15:00:35',NULL,27,14,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(184,33,'2023-06-14 10:45:00','2023-06-14 10:46:00','',0,66,466,57,1,0,NULL,171,0,'validated',NULL,'2023-06-14 10:47:23',NULL,21,21,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(185,33,'2023-06-14 20:16:00','2023-06-14 21:21:00','egrzefr',0,66,467,58,65,0,NULL,173,0,'validated',NULL,'2023-06-14 21:33:29',NULL,21,37,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(186,33,'2023-06-15 11:17:00','2023-06-15 11:17:00','',0,66,466,57,0,0,NULL,175,1,'validated',NULL,'2023-06-15 11:17:48',NULL,10,21,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(187,33,'2023-06-15 11:17:00','2023-06-15 11:18:00','',0,66,467,57,1,0,NULL,177,1,'validated',NULL,'2023-06-15 11:18:53',NULL,21,37,25,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(188,33,'2023-06-15 11:28:24','2023-06-15 11:38:00','Appréciation Leçonnn\n ',1,43,247,59,10,5,NULL,180,0,'validated',NULL,'2023-06-15 11:39:33',NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,NULL,NULL,NULL),(189,33,'2023-06-15 13:55:31','2023-06-15 13:56:00','',1,43,248,57,0,10,NULL,182,1,'validated',NULL,'2023-06-15 14:01:37',NULL,NULL,NULL,NULL,12,NULL,NULL,NULL,NULL,NULL,NULL),(197,33,'2023-06-16 15:38:00','2023-06-16 15:41:00','zegrgrfzed',0,69,470,60,3,0,NULL,184,1,'validated',NULL,'2023-06-16 15:42:09',NULL,10,21,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(198,33,'2023-06-16 16:04:00','2023-06-16 16:05:00','',0,69,471,60,1,0,NULL,186,1,'validated',NULL,'2023-06-16 16:05:36',NULL,10,21,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(213,33,'2023-06-20 11:42:00','2023-06-20 11:43:00','Appréciation Leçonnn',0,71,512,60,1,0,NULL,188,0,'validated',NULL,'2023-06-20 11:43:31',NULL,21,37,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(216,33,'2023-06-21 00:32:00','2023-06-21 00:33:00','fzrezfr',0,52,365,57,1,0,NULL,190,1,'validated',NULL,'2023-06-21 00:36:01',NULL,21,20,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(217,33,'2023-06-21 11:15:00','2023-06-21 12:47:00','',0,74,529,58,92,9,NULL,192,1,'validated',NULL,'2023-06-21 12:47:31',NULL,21,1570,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(227,33,'2023-06-22 14:19:00','2023-06-22 14:20:00','Commentaire - Appréciation Leçonnn',0,73,537,63,1,0,NULL,198,0,'validated',NULL,'2023-06-22 14:20:59',NULL,21,1570,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(228,33,'2023-06-23 11:29:00','2023-06-23 11:30:00','',0,26,164,57,1,0,NULL,200,0,'validated',NULL,'2023-06-23 11:30:36',NULL,21,1570,25,25,NULL,NULL,NULL,NULL,NULL,NULL),(247,33,'2023-06-23 20:15:00',NULL,'',0,76,547,NULL,0,0,NULL,NULL,0,'toClose',NULL,NULL,NULL,NULL,NULL,25,25,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `session_airport`
--

CREATE TABLE `session_airport` (
  `session_id` int NOT NULL,
  `airport_id` int NOT NULL,
  PRIMARY KEY (`session_id`,`airport_id`),
  KEY `IDX_6C497598613FECDF` (`session_id`),
  KEY `IDX_6C497598289F53C8` (`airport_id`),
  CONSTRAINT `FK_6C497598289F53C8` FOREIGN KEY (`airport_id`) REFERENCES `airport` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_6C497598613FECDF` FOREIGN KEY (`session_id`) REFERENCES `session` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `session_airport`
--

INSERT INTO `session_airport` VALUES (30,10),(30,17);

--
-- Table structure for table `session_ato_user`
--

CREATE TABLE `session_ato_user` (
  `session_id` int NOT NULL,
  `ato_user_id` int NOT NULL,
  PRIMARY KEY (`session_id`,`ato_user_id`),
  KEY `IDX_5DE07DC613FECDF` (`session_id`),
  KEY `IDX_5DE07DC30A17E02` (`ato_user_id`),
  CONSTRAINT `FK_5DE07DC30A17E02` FOREIGN KEY (`ato_user_id`) REFERENCES `ato_user` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_5DE07DC613FECDF` FOREIGN KEY (`session_id`) REFERENCES `session` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `session_ato_user`
--

INSERT INTO `session_ato_user` VALUES (82,35),(82,36),(83,35),(83,36),(84,35),(84,36);

--
-- Table structure for table `session_exercise`
--

CREATE TABLE `session_exercise` (
  `id` int NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `session_exercise`
--


--
-- Table structure for table `session_item`
--

CREATE TABLE `session_item` (
  `id` int NOT NULL AUTO_INCREMENT,
  `formation_item_id` int NOT NULL,
  `rate_id` int DEFAULT NULL,
  `comment` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `session_id` int DEFAULT NULL,
  `student_rate_id` int DEFAULT NULL,
  `additional_for_session_id` int DEFAULT NULL,
  `is_fail` tinyint(1) DEFAULT NULL,
  `notation_reason_id` int DEFAULT NULL,
  `formation_id` int DEFAULT NULL,
  `lesson_id` int DEFAULT NULL,
  `lesson_exercises_validated_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_D96A2534613FECDF` (`session_id`),
  KEY `IDX_D96A2534BC999F9F` (`rate_id`),
  KEY `IDX_D96A253451AF2A67` (`student_rate_id`),
  KEY `IDX_D96A253457901725` (`formation_item_id`),
  KEY `IDX_D96A25346AD4BF0E` (`additional_for_session_id`),
  KEY `IDX_D96A25349646E8C` (`notation_reason_id`),
  KEY `IDX_D96A25345200282E` (`formation_id`),
  KEY `IDX_D96A2534CDF80196` (`lesson_id`),
  KEY `IDX_D96A2534177243FF` (`lesson_exercises_validated_id`),
  CONSTRAINT `FK_D96A2534177243FF` FOREIGN KEY (`lesson_exercises_validated_id`) REFERENCES `formation_item` (`id`),
  CONSTRAINT `FK_D96A253451AF2A67` FOREIGN KEY (`student_rate_id`) REFERENCES `rating_value` (`id`),
  CONSTRAINT `FK_D96A25345200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`),
  CONSTRAINT `FK_D96A253457901725` FOREIGN KEY (`formation_item_id`) REFERENCES `formation_item` (`id`),
  CONSTRAINT `FK_D96A2534613FECDF` FOREIGN KEY (`session_id`) REFERENCES `session` (`id`),
  CONSTRAINT `FK_D96A25346AD4BF0E` FOREIGN KEY (`additional_for_session_id`) REFERENCES `session` (`id`),
  CONSTRAINT `FK_D96A25349646E8C` FOREIGN KEY (`notation_reason_id`) REFERENCES `rating_value_reasons_details` (`id`),
  CONSTRAINT `FK_D96A2534BC999F9F` FOREIGN KEY (`rate_id`) REFERENCES `rating_value` (`id`),
  CONSTRAINT `FK_D96A2534CDF80196` FOREIGN KEY (`lesson_id`) REFERENCES `formation_item` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=395 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `session_item`
--

INSERT INTO `session_item` VALUES (1,48,NULL,'',2,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,75,40,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,76,48,NULL,3,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,75,40,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,76,47,NULL,5,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(13,77,43,NULL,6,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(16,75,40,NULL,9,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(17,76,48,NULL,9,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(20,77,44,NULL,11,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(27,75,40,NULL,13,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(28,76,47,NULL,13,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(29,77,43,NULL,13,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(30,76,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(33,80,63,NULL,14,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(34,81,63,NULL,14,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(36,82,63,NULL,15,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(38,80,63,NULL,16,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(39,80,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(44,80,64,NULL,18,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(45,81,64,NULL,18,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(49,80,63,NULL,19,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(50,81,63,NULL,19,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(51,82,63,NULL,19,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(52,80,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(53,81,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(54,82,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(57,101,63,NULL,28,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(59,85,63,NULL,29,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(61,102,63,NULL,30,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(69,126,60,NULL,36,60,NULL,NULL,NULL,NULL,NULL,NULL),(71,126,60,NULL,37,60,NULL,NULL,NULL,NULL,NULL,NULL),(72,126,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(74,127,57,NULL,38,57,NULL,NULL,NULL,NULL,NULL,NULL),(77,126,61,NULL,39,61,NULL,NULL,NULL,NULL,NULL,NULL),(78,127,58,NULL,39,58,NULL,NULL,NULL,NULL,NULL,NULL),(82,136,60,NULL,41,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(83,140,63,NULL,41,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(86,136,60,NULL,42,NULL,NULL,NULL,51,NULL,NULL,NULL),(87,140,63,NULL,42,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(131,141,60,NULL,59,NULL,NULL,NULL,50,NULL,NULL,NULL),(132,142,60,NULL,59,NULL,NULL,NULL,51,NULL,NULL,NULL),(134,141,60,NULL,60,NULL,NULL,NULL,50,NULL,NULL,NULL),(135,141,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(138,143,60,NULL,62,NULL,NULL,NULL,50,NULL,NULL,NULL),(139,141,61,NULL,NULL,NULL,62,NULL,52,NULL,NULL,NULL),(143,141,60,NULL,64,NULL,NULL,NULL,50,NULL,NULL,NULL),(144,141,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(157,152,57,NULL,67,NULL,NULL,NULL,44,NULL,NULL,NULL),(158,146,NULL,NULL,67,NULL,NULL,1,NULL,NULL,NULL,NULL),(159,147,NULL,NULL,67,NULL,NULL,0,NULL,NULL,NULL,NULL),(160,148,NULL,NULL,67,NULL,NULL,0,NULL,NULL,NULL,NULL),(161,153,58,NULL,67,NULL,NULL,NULL,46,NULL,NULL,NULL),(162,149,NULL,NULL,67,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(163,150,NULL,NULL,67,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(164,151,NULL,NULL,67,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(181,157,63,NULL,70,NULL,NULL,NULL,56,NULL,NULL,NULL),(182,158,63,NULL,70,NULL,NULL,NULL,57,NULL,NULL,NULL),(183,159,65,NULL,70,NULL,NULL,NULL,60,NULL,NULL,NULL),(188,163,66,NULL,74,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(193,126,60,NULL,76,60,NULL,NULL,50,NULL,NULL,NULL),(194,167,NULL,NULL,76,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(195,168,NULL,NULL,76,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(205,178,60,'',81,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(206,178,60,'',82,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(207,178,60,'',83,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(208,178,60,'',84,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(209,178,60,'',85,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(210,183,57,'',86,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(212,184,57,'',88,NULL,NULL,NULL,44,NULL,NULL,NULL),(213,185,59,'',88,NULL,NULL,NULL,48,NULL,NULL,NULL),(214,184,57,'',89,NULL,NULL,NULL,44,NULL,NULL,NULL),(215,185,59,'',89,NULL,NULL,NULL,48,NULL,NULL,NULL),(216,184,57,'',90,NULL,NULL,NULL,44,NULL,NULL,NULL),(217,185,59,'',90,NULL,NULL,NULL,48,NULL,NULL,NULL),(223,153,58,NULL,92,NULL,NULL,NULL,46,NULL,NULL,NULL),(224,149,NULL,NULL,92,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(225,150,NULL,NULL,92,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(226,151,NULL,NULL,92,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(228,163,68,NULL,93,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(240,237,60,NULL,100,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(241,238,62,NULL,100,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(250,253,61,NULL,107,NULL,NULL,NULL,52,NULL,NULL,NULL),(251,254,60,NULL,107,NULL,NULL,NULL,51,NULL,NULL,NULL),(253,253,60,NULL,108,NULL,NULL,NULL,50,NULL,NULL,NULL),(254,253,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(257,262,57,NULL,109,NULL,NULL,NULL,44,NULL,NULL,NULL),(258,263,57,NULL,109,NULL,NULL,NULL,45,NULL,NULL,NULL),(260,262,57,NULL,110,NULL,NULL,NULL,44,NULL,NULL,NULL),(261,262,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(274,249,57,NULL,123,NULL,NULL,NULL,44,NULL,NULL,NULL),(275,250,59,NULL,123,NULL,NULL,NULL,49,NULL,NULL,NULL),(277,251,57,NULL,124,NULL,NULL,NULL,44,NULL,NULL,NULL),(281,358,60,NULL,154,NULL,NULL,NULL,50,NULL,NULL,NULL),(283,359,60,NULL,155,NULL,NULL,NULL,50,NULL,NULL,NULL),(285,358,60,NULL,156,NULL,NULL,NULL,50,NULL,NULL,NULL),(288,359,60,NULL,157,NULL,NULL,NULL,50,NULL,NULL,NULL),(289,358,61,NULL,NULL,NULL,157,NULL,53,NULL,NULL,NULL),(291,368,62,NULL,158,NULL,NULL,NULL,54,NULL,NULL,NULL),(293,369,60,NULL,159,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(295,370,60,NULL,160,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(297,371,60,NULL,161,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(305,462,64,NULL,184,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(307,463,64,NULL,185,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(309,462,63,NULL,186,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(312,463,63,NULL,187,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(313,462,64,NULL,NULL,NULL,187,NULL,NULL,NULL,NULL,NULL),(316,249,57,'',188,NULL,NULL,NULL,44,NULL,NULL,NULL),(317,250,59,'',188,NULL,NULL,NULL,49,NULL,NULL,NULL),(322,251,57,'',189,NULL,NULL,NULL,44,NULL,NULL,NULL),(323,249,57,NULL,NULL,NULL,189,NULL,NULL,NULL,NULL,NULL),(324,251,59,NULL,NULL,NULL,189,NULL,NULL,NULL,NULL,NULL),(325,250,59,NULL,NULL,NULL,189,NULL,NULL,NULL,NULL,NULL),(326,249,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(356,499,60,NULL,213,NULL,NULL,NULL,50,NULL,NULL,NULL),(357,500,61,NULL,213,NULL,NULL,NULL,53,NULL,NULL,NULL),(363,360,60,NULL,216,NULL,NULL,NULL,50,NULL,NULL,NULL),(366,525,60,NULL,217,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(367,526,60,NULL,217,NULL,NULL,NULL,50,NULL,NULL,NULL),(386,541,57,NULL,227,NULL,NULL,NULL,44,NULL,NULL,NULL),(387,542,58,NULL,227,NULL,NULL,NULL,46,NULL,NULL,NULL),(389,163,68,NULL,228,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `session_skill`
--

CREATE TABLE `session_skill` (
  `id` int NOT NULL AUTO_INCREMENT,
  `note_id` int DEFAULT NULL,
  `skill_id` int NOT NULL,
  `session_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_85405CA126ED0855` (`note_id`),
  KEY `IDX_85405CA15585C142` (`skill_id`),
  KEY `IDX_85405CA1613FECDF` (`session_id`),
  CONSTRAINT `FK_85405CA126ED0855` FOREIGN KEY (`note_id`) REFERENCES `rating_value` (`id`),
  CONSTRAINT `FK_85405CA15585C142` FOREIGN KEY (`skill_id`) REFERENCES `skills` (`id`),
  CONSTRAINT `FK_85405CA1613FECDF` FOREIGN KEY (`session_id`) REFERENCES `session` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `session_skill`
--


--
-- Table structure for table `signature`
--

CREATE TABLE `signature` (
  `id` int NOT NULL AUTO_INCREMENT,
  `ato_user_id` int NOT NULL,
  `date` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_AE88014130A17E02` (`ato_user_id`),
  CONSTRAINT `FK_AE88014130A17E02` FOREIGN KEY (`ato_user_id`) REFERENCES `ato_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=202 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `signature`
--

INSERT INTO `signature` VALUES (1,33,'2023-04-21 12:52:13'),(2,33,'2023-04-24 21:53:48'),(3,33,'2023-04-26 11:01:16'),(5,33,'2023-04-26 11:48:14'),(6,37,'2023-04-26 11:48:15'),(7,33,'2023-04-26 12:02:02'),(8,37,'2023-04-26 12:02:02'),(9,33,'2023-04-26 12:30:06'),(10,35,'2023-04-26 12:30:06'),(11,33,'2023-04-26 15:03:41'),(12,35,'2023-04-26 15:03:42'),(13,33,'2023-04-26 15:15:01'),(14,37,'2023-04-26 15:15:59'),(15,33,'2023-04-26 15:26:27'),(16,37,'2023-04-26 15:26:42'),(17,33,'2023-04-26 15:28:56'),(18,37,'2023-04-26 15:29:10'),(19,33,'2023-04-26 15:41:05'),(20,37,'2023-04-26 15:41:44'),(21,33,'2023-04-26 15:48:02'),(22,35,'2023-04-26 15:48:03'),(23,33,'2023-04-27 17:27:37'),(24,37,'2023-04-27 17:27:37'),(25,33,'2023-05-02 21:01:45'),(26,37,'2023-05-02 21:01:46'),(27,33,'2023-05-03 20:45:14'),(28,37,'2023-05-03 20:45:14'),(29,33,'2023-05-04 12:09:33'),(30,37,'2023-05-04 12:09:33'),(31,33,'2023-05-05 15:49:42'),(32,37,'2023-05-05 15:49:43'),(33,33,'2023-05-05 15:52:42'),(34,37,'2023-05-05 16:03:36'),(35,33,'2023-05-05 16:36:58'),(36,37,'2023-05-05 16:36:59'),(37,33,'2023-05-05 16:43:28'),(38,37,'2023-05-05 16:43:28'),(39,33,'2023-05-08 12:57:28'),(40,37,'2023-05-08 12:57:28'),(41,33,'2023-05-08 13:35:08'),(42,36,'2023-05-08 13:35:09'),(43,33,'2023-05-10 14:12:53'),(44,37,'2023-05-10 14:12:54'),(45,33,'2023-05-10 15:24:01'),(46,33,'2023-05-10 15:43:31'),(47,33,'2023-05-10 15:47:35'),(48,33,'2023-05-10 15:49:30'),(49,33,'2023-05-10 16:07:25'),(51,37,'2023-05-10 20:56:59'),(52,33,'2023-05-10 23:18:48'),(53,37,'2023-05-10 23:18:48'),(54,33,'2023-05-10 23:23:55'),(55,37,'2023-05-10 23:26:46'),(56,33,'2023-05-10 23:47:11'),(57,37,'2023-05-10 23:47:11'),(58,33,'2023-05-11 16:44:59'),(59,37,'2023-05-11 16:44:59'),(60,33,'2023-05-12 23:42:18'),(61,37,'2023-05-12 23:42:18'),(62,33,'2023-05-13 18:15:37'),(63,37,'2023-05-13 18:15:37'),(64,33,'2023-05-14 15:36:15'),(65,37,'2023-05-14 15:36:15'),(66,33,'2023-05-15 23:28:02'),(67,36,'2023-05-15 23:28:03'),(68,33,'2023-05-17 13:25:13'),(69,33,'2023-05-17 13:49:16'),(70,37,'2023-05-17 13:50:05'),(71,37,'2023-05-17 13:50:12'),(72,33,'2023-05-17 13:50:23'),(73,33,'2023-05-18 16:10:36'),(74,33,'2023-05-18 20:30:13'),(75,33,'2023-05-18 20:30:42'),(76,33,'2023-05-18 20:35:20'),(81,33,'2023-05-19 15:20:20'),(82,37,'2023-05-19 15:20:20'),(83,33,'2023-05-19 15:21:42'),(84,37,'2023-05-19 15:21:43'),(85,33,'2023-05-22 23:05:30'),(86,37,'2023-05-22 23:05:30'),(87,33,'2023-05-24 16:10:37'),(88,33,'2023-05-25 11:06:19'),(89,37,'2023-05-25 11:06:19'),(90,33,'2023-05-25 11:07:41'),(91,37,'2023-05-25 11:07:41'),(92,33,'2023-05-25 14:23:34'),(93,37,'2023-05-25 14:23:34'),(94,33,'2023-05-25 14:43:24'),(95,37,'2023-05-25 14:43:25'),(96,33,'2023-05-25 15:59:36'),(97,37,'2023-05-25 15:59:36'),(98,33,'2023-05-25 16:01:00'),(99,37,'2023-05-25 16:01:01'),(100,33,'2023-05-30 23:49:14'),(101,33,'2023-06-01 12:22:03'),(102,37,'2023-06-01 12:22:04'),(103,33,'2023-06-01 12:30:56'),(104,37,'2023-06-01 12:30:56'),(105,33,'2023-06-02 19:37:02'),(106,37,'2023-06-02 19:52:01'),(107,33,'2023-06-02 20:05:41'),(108,37,'2023-06-06 14:02:52'),(109,37,'2023-06-06 14:06:47'),(110,33,'2023-06-06 14:19:04'),(111,37,'2023-06-06 14:19:51'),(112,33,'2023-06-06 14:27:40'),(113,33,'2023-06-06 14:29:54'),(114,37,'2023-06-06 14:33:12'),(115,33,'2023-06-06 14:36:18'),(116,33,'2023-06-06 14:37:05'),(117,37,'2023-06-06 14:37:47'),(118,33,'2023-06-06 14:38:50'),(119,33,'2023-06-06 14:39:11'),(120,37,'2023-06-06 14:50:31'),(121,33,'2023-06-06 14:51:12'),(122,33,'2023-06-06 14:52:06'),(123,33,'2023-06-06 14:58:30'),(124,33,'2023-06-06 15:01:34'),(125,33,'2023-06-06 15:03:20'),(126,33,'2023-06-06 15:05:52'),(127,37,'2023-06-06 15:17:40'),(128,33,'2023-06-06 15:37:45'),(129,33,'2023-06-06 15:39:09'),(130,33,'2023-06-06 15:40:48'),(131,33,'2023-06-06 15:47:20'),(132,33,'2023-06-06 15:47:40'),(133,37,'2023-06-06 15:48:31'),(134,33,'2023-06-07 14:34:28'),(135,37,'2023-06-07 14:34:28'),(136,33,'2023-06-08 18:00:29'),(137,37,'2023-06-08 18:00:29'),(138,33,'2023-06-08 18:26:42'),(139,37,'2023-06-08 18:26:43'),(140,33,'2023-06-09 12:14:21'),(141,36,'2023-06-09 12:14:22'),(142,33,'2023-06-09 12:19:18'),(143,36,'2023-06-09 12:19:18'),(144,33,'2023-06-09 12:59:24'),(145,37,'2023-06-09 12:59:25'),(146,33,'2023-06-09 13:01:00'),(147,37,'2023-06-09 13:01:01'),(148,33,'2023-06-09 13:02:57'),(149,37,'2023-06-09 13:02:58'),(150,33,'2023-06-09 13:03:27'),(151,37,'2023-06-09 13:03:28'),(152,33,'2023-06-10 19:54:06'),(153,37,'2023-06-10 19:54:06'),(154,33,'2023-06-11 10:58:26'),(155,37,'2023-06-11 10:58:26'),(156,33,'2023-06-11 11:08:37'),(157,37,'2023-06-11 11:08:37'),(158,33,'2023-06-11 17:51:42'),(159,37,'2023-06-11 17:51:43'),(160,33,'2023-06-11 21:03:05'),(161,37,'2023-06-11 21:03:06'),(162,33,'2023-06-11 21:11:01'),(163,37,'2023-06-11 21:11:01'),(164,33,'2023-06-11 21:43:50'),(165,37,'2023-06-11 21:43:51'),(166,33,'2023-06-11 22:02:40'),(167,37,'2023-06-11 22:02:40'),(168,33,'2023-06-12 18:11:30'),(169,33,'2023-06-13 15:00:34'),(170,37,'2023-06-13 15:00:35'),(171,33,'2023-06-14 10:47:22'),(172,37,'2023-06-14 10:47:23'),(173,33,'2023-06-14 21:33:29'),(174,37,'2023-06-14 21:33:29'),(175,33,'2023-06-15 11:17:48'),(176,36,'2023-06-15 11:17:48'),(177,33,'2023-06-15 11:18:52'),(178,36,'2023-06-15 11:18:53'),(179,37,'2023-06-15 11:28:15'),(180,33,'2023-06-15 11:38:31'),(181,37,'2023-06-15 11:39:33'),(182,33,'2023-06-15 13:56:59'),(183,37,'2023-06-15 14:01:37'),(184,33,'2023-06-16 15:42:09'),(185,37,'2023-06-16 15:42:09'),(186,33,'2023-06-16 16:05:35'),(187,37,'2023-06-16 16:05:36'),(188,33,'2023-06-20 11:43:30'),(189,37,'2023-06-20 11:43:31'),(190,33,'2023-06-21 00:36:00'),(191,37,'2023-06-21 00:36:00'),(192,33,'2023-06-21 12:47:31'),(193,37,'2023-06-21 12:47:31'),(194,33,'2023-06-22 14:03:00'),(195,37,'2023-06-22 14:03:00'),(198,33,'2023-06-22 14:20:59'),(199,37,'2023-06-22 14:20:59'),(200,33,'2023-06-23 11:30:36'),(201,36,'2023-06-23 11:30:36');

--
-- Table structure for table `skill_indicator_item_notation`
--

CREATE TABLE `skill_indicator_item_notation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `skill_detail_id` int DEFAULT NULL,
  `notation_id` int DEFAULT NULL,
  `notation_reason_id` int DEFAULT NULL,
  `session_item_id` int DEFAULT NULL,
  `created_at` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_517B935A8B2138E6` (`skill_detail_id`),
  KEY `IDX_517B935A9680B7F7` (`notation_id`),
  KEY `IDX_517B935A9646E8C` (`notation_reason_id`),
  KEY `IDX_517B935AB7D004` (`session_item_id`),
  CONSTRAINT `FK_517B935A8B2138E6` FOREIGN KEY (`skill_detail_id`) REFERENCES `skills_detail` (`id`),
  CONSTRAINT `FK_517B935A9646E8C` FOREIGN KEY (`notation_reason_id`) REFERENCES `rating_value_reasons_details` (`id`),
  CONSTRAINT `FK_517B935A9680B7F7` FOREIGN KEY (`notation_id`) REFERENCES `rating_value` (`id`),
  CONSTRAINT `FK_517B935AB7D004` FOREIGN KEY (`session_item_id`) REFERENCES `session_item` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `skill_indicator_item_notation`
--

INSERT INTO `skill_indicator_item_notation` VALUES (1,31,60,51,181,'2023-05-13 18:15:36'),(2,32,61,53,181,'2023-05-13 18:15:36'),(3,33,62,54,181,'2023-05-13 18:15:36'),(4,31,62,55,182,'2023-05-13 18:15:36'),(5,32,60,50,182,'2023-05-13 18:15:36'),(6,33,61,53,182,'2023-05-13 18:15:36'),(7,31,62,55,183,'2023-05-13 18:15:36'),(8,32,60,50,183,'2023-05-13 18:15:36'),(9,33,61,53,183,'2023-05-13 18:15:36'),(10,31,61,52,213,'2023-05-18 20:30:12'),(11,32,62,55,213,'2023-05-18 20:30:12'),(12,33,60,50,213,'2023-05-18 20:30:12'),(13,31,61,52,215,'2023-05-18 20:30:41'),(14,32,62,55,215,'2023-05-18 20:30:41'),(15,33,60,50,215,'2023-05-18 20:30:41'),(16,31,61,52,217,'2023-05-18 20:35:20'),(17,32,62,55,217,'2023-05-18 20:35:20'),(18,33,60,50,217,'2023-05-18 20:35:20'),(19,47,62,NULL,240,'2023-05-22 23:05:29'),(20,48,60,NULL,240,'2023-05-22 23:05:29'),(21,47,61,NULL,241,'2023-05-22 23:05:29'),(22,48,62,NULL,241,'2023-05-22 23:05:29'),(31,47,65,60,386,'2023-06-22 14:20:58'),(32,48,63,57,386,'2023-06-22 14:20:58'),(33,47,63,56,387,'2023-06-22 14:20:58'),(34,48,64,59,387,'2023-06-22 14:20:58');

--
-- Table structure for table `skill_item_notation`
--

CREATE TABLE `skill_item_notation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `skill_id` int DEFAULT NULL,
  `notation_id` int DEFAULT NULL,
  `exercise_id` int DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `notation_reason_id` int DEFAULT NULL,
  `session_item_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_80F979E25585C142` (`skill_id`),
  KEY `IDX_80F979E29680B7F7` (`notation_id`),
  KEY `IDX_80F979E2E934951A` (`exercise_id`),
  KEY `IDX_80F979E29646E8C` (`notation_reason_id`),
  KEY `IDX_80F979E2B7D004` (`session_item_id`),
  CONSTRAINT `FK_80F979E25585C142` FOREIGN KEY (`skill_id`) REFERENCES `skills` (`id`),
  CONSTRAINT `FK_80F979E29646E8C` FOREIGN KEY (`notation_reason_id`) REFERENCES `rating_value_reasons_details` (`id`),
  CONSTRAINT `FK_80F979E29680B7F7` FOREIGN KEY (`notation_id`) REFERENCES `rating_value` (`id`),
  CONSTRAINT `FK_80F979E2B7D004` FOREIGN KEY (`session_item_id`) REFERENCES `session_item` (`id`),
  CONSTRAINT `FK_80F979E2E934951A` FOREIGN KEY (`exercise_id`) REFERENCES `formation_item` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=78 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `skill_item_notation`
--

INSERT INTO `skill_item_notation` VALUES (1,23,57,141,'2023-05-10 16:07:25',44,NULL),(2,24,61,141,'2023-05-10 16:07:25',52,NULL),(3,25,63,142,'2023-05-10 16:07:25',56,NULL),(4,23,58,141,'2023-05-10 19:42:39',47,NULL),(5,24,61,NULL,'2023-05-10 19:42:39',52,NULL),(6,25,63,NULL,'2023-05-10 19:42:39',56,NULL),(7,23,58,141,'2023-05-10 23:18:48',46,NULL),(8,24,62,141,'2023-05-10 23:18:48',54,NULL),(9,25,63,142,'2023-05-10 23:18:48',NULL,NULL),(10,23,58,141,'2023-05-10 23:18:47',46,131),(11,24,62,141,'2023-05-10 23:18:47',54,131),(12,25,63,142,'2023-05-10 23:18:47',NULL,132),(13,23,58,141,'2023-05-10 23:23:55',46,NULL),(14,24,62,141,'2023-05-10 23:23:55',54,NULL),(15,23,58,141,'2023-05-10 23:23:54',46,134),(16,24,62,141,'2023-05-10 23:23:54',54,134),(17,23,57,141,'2023-05-10 23:47:11',44,139),(18,24,62,141,'2023-05-10 23:47:11',NULL,139),(19,23,58,141,'2023-05-11 16:44:58',46,143),(20,24,60,141,'2023-05-11 16:44:58',51,143),(21,25,64,157,'2023-05-13 18:15:36',59,181),(22,26,59,157,'2023-05-13 18:15:36',48,181),(23,26,58,158,'2023-05-13 18:15:36',46,182),(24,25,63,159,'2023-05-13 18:15:36',57,183),(25,26,58,159,'2023-05-13 18:15:36',46,183),(26,23,58,184,'2023-05-18 20:30:12',47,212),(27,26,57,185,'2023-05-18 20:30:12',45,213),(28,23,58,184,'2023-05-18 20:30:41',47,214),(29,26,57,185,'2023-05-18 20:30:41',45,215),(30,23,58,184,'2023-05-18 20:35:20',47,216),(31,26,57,185,'2023-05-18 20:35:20',45,217),(32,35,58,237,'2023-05-22 23:05:29',NULL,240),(33,36,61,237,'2023-05-22 23:05:29',NULL,240),(34,35,57,238,'2023-05-22 23:05:29',NULL,241),(35,24,61,253,'2023-05-25 11:06:19',53,250),(36,36,62,253,'2023-05-25 11:06:19',54,250),(37,24,61,254,'2023-05-25 11:06:19',52,251),(38,24,61,253,'2023-05-25 11:07:40',52,253),(39,36,61,253,'2023-05-25 11:07:40',52,253),(40,23,58,262,'2023-05-25 14:23:33',47,257),(41,24,62,262,'2023-05-25 14:23:33',54,257),(42,23,58,263,'2023-05-25 14:23:33',46,258),(43,23,58,262,'2023-05-25 14:43:24',47,260),(44,24,62,262,'2023-05-25 14:43:24',54,260),(45,23,58,249,'2023-06-02 19:37:02',47,274),(46,24,62,249,'2023-06-02 19:37:02',54,274),(47,25,63,249,'2023-06-02 19:37:02',57,274),(48,36,61,249,'2023-06-02 19:37:02',52,274),(49,23,57,250,'2023-06-02 19:37:02',44,275),(50,24,61,250,'2023-06-02 19:37:02',53,275),(51,23,58,251,'2023-06-02 20:05:41',47,277),(52,25,65,251,'2023-06-02 20:05:41',60,277),(53,23,58,249,'2023-06-15 11:38:30',47,316),(54,24,62,249,'2023-06-15 11:38:30',54,316),(55,25,63,249,'2023-06-15 11:38:30',57,316),(56,36,61,249,'2023-06-15 11:38:30',52,316),(57,23,57,250,'2023-06-15 11:38:30',44,317),(58,24,61,250,'2023-06-15 11:38:30',53,317),(59,23,58,251,'2023-06-15 13:56:58',47,322),(60,25,65,251,'2023-06-15 13:56:58',60,322),(61,23,58,249,'2023-06-15 13:56:58',NULL,323),(62,24,62,249,'2023-06-15 13:56:58',NULL,323),(63,25,63,249,'2023-06-15 13:56:58',NULL,323),(64,36,61,249,'2023-06-15 13:56:58',NULL,323),(65,23,57,251,'2023-06-15 13:56:58',NULL,324),(66,25,64,251,'2023-06-15 13:56:58',NULL,324),(67,23,57,250,'2023-06-15 13:56:58',NULL,325),(68,24,61,250,'2023-06-15 13:56:58',NULL,325),(75,35,61,541,'2023-06-22 14:20:58',53,386),(76,35,62,542,'2023-06-22 14:20:58',55,387),(77,36,62,542,'2023-06-22 14:20:58',54,387);

--
-- Table structure for table `skills`
--

CREATE TABLE `skills` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rating_system_id` int DEFAULT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  `created_at` datetime DEFAULT NULL,
  `type` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL,
  `rating_system_indicator_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_D5311670F31275AF` (`rating_system_id`),
  KEY `IDX_D5311670C459A4` (`rating_system_indicator_id`),
  CONSTRAINT `FK_D5311670C459A4` FOREIGN KEY (`rating_system_indicator_id`) REFERENCES `rating` (`id`),
  CONSTRAINT `FK_D5311670F31275AF` FOREIGN KEY (`rating_system_id`) REFERENCES `rating` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=37 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `skills`
--

INSERT INTO `skills` VALUES (18,'test2 v2',1,'test2 v2 edit','2023-04-27 10:23:03','none',NULL),(20,'gerezf',6,'zefefz','2023-03-13 20:14:12','none',NULL),(21,'gdhhteght',NULL,'tehhtethe','2023-03-22 11:02:08','technical',NULL),(22,'j;ghf,',27,'fgnfkuj edit','2023-04-27 10:24:53','non technical',NULL),(23,'Compétence 1',41,'Desc compétence 1','2023-05-09 20:28:37','technical',NULL),(24,'Compétence 2',42,'Desc compétence 2','2023-05-09 20:29:03','technical',NULL),(25,'Compétence 3',43,'Desc compétence 3','2023-05-09 20:29:24','technical',NULL),(26,'Compétence 4 ',41,'Notation indicateur','2023-05-13 14:13:47','technical',42),(27,'Compétence 5',NULL,'zfzfzfz','2023-05-13 15:17:18','technical',NULL),(34,'Pilotage Manuel',41,'Gestion du pilotage manuel de l\'appareil','2023-05-22 21:05:08','technical',42),(35,'Compétences indicateurs',41,'àpîhzERFGPNZREG','2023-05-22 22:43:33','technical',42),(36,'Compétences sans indicateurs',42,'effhefezthg','2023-05-22 22:43:50','non technical',NULL);

--
-- Table structure for table `skills_ato`
--

CREATE TABLE `skills_ato` (
  `skills_id` int NOT NULL,
  `ato_id` int NOT NULL,
  PRIMARY KEY (`skills_id`,`ato_id`),
  KEY `IDX_2E11FF737FF61858` (`skills_id`),
  KEY `IDX_2E11FF73847DC024` (`ato_id`),
  CONSTRAINT `FK_2E11FF737FF61858` FOREIGN KEY (`skills_id`) REFERENCES `skills` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_2E11FF73847DC024` FOREIGN KEY (`ato_id`) REFERENCES `ato` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `skills_ato`
--

INSERT INTO `skills_ato` VALUES (18,2),(18,4),(20,2),(20,4),(21,3),(22,3),(23,3),(24,3),(25,3),(26,3),(27,3),(34,3),(35,3),(36,3);

--
-- Table structure for table `skills_detail`
--

CREATE TABLE `skills_detail` (
  `id` int NOT NULL AUTO_INCREMENT,
  `skills_id` int NOT NULL,
  `description` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`),
  KEY `IDX_631971207FF61858` (`skills_id`),
  CONSTRAINT `FK_631971207FF61858` FOREIGN KEY (`skills_id`) REFERENCES `skills` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=49 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `skills_detail`
--

INSERT INTO `skills_detail` VALUES (13,21,'ethte'),(21,22,'nfnynnyt'),(22,23,'Indicateurs comportementaux - Compétence 1 - 1'),(23,23,'Indicateurs comportementaux - Compétence 1 - 2'),(24,24,'Indicateurs comportementaux - Compétence 2 - 1'),(25,24,'Indicateurs comportementaux - Compétence 2 - 2'),(26,24,'Indicateurs comportementaux - Compétence 2 - 3'),(27,25,'Indicateurs comportementaux - Compétence 3 - 1'),(31,26,'INDICATEUR 1'),(32,26,'INDICATEUR 2'),(33,26,'INDICATEUR 3'),(46,34,'tegdff'),(47,35,'Indicateur 1'),(48,35,'Indicateur 2');

--
-- Table structure for table `student_formation`
--

CREATE TABLE `student_formation` (
  `id` int NOT NULL AUTO_INCREMENT,
  `formation_id` int NOT NULL,
  `student_id` int NOT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `registered_on` datetime NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_272EE03F5200282E` (`formation_id`),
  KEY `IDX_272EE03FCB944F1A` (`student_id`),
  CONSTRAINT `FK_272EE03F5200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`),
  CONSTRAINT `FK_272EE03FCB944F1A` FOREIGN KEY (`student_id`) REFERENCES `ato_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=152 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `student_formation`
--

INSERT INTO `student_formation` VALUES (7,14,33,'inProgress','2023-04-21 09:12:13'),(8,14,35,'inProgress','2023-04-21 09:24:08'),(9,14,36,'inProgress','2023-04-21 09:24:08'),(10,14,37,'inProgress','2023-04-21 09:24:08'),(11,15,33,'inProgress','2023-04-21 09:29:04'),(12,15,37,'inProgress','2023-04-21 09:29:04'),(13,2,33,'inProgress','2023-04-21 12:50:26'),(14,2,37,'inProgress','2023-04-21 12:50:26'),(20,17,37,'inProgress','2023-04-26 11:42:13'),(21,17,35,'inProgress','2023-04-26 12:04:21'),(22,17,36,'inProgress','2023-04-26 15:19:10'),(23,18,37,'closed','2023-04-26 15:25:30'),(24,18,35,'inProgress','2023-04-26 15:25:31'),(27,21,33,'inProgress','2023-05-02 20:33:03'),(28,21,37,'inProgress','2023-05-02 20:33:03'),(29,19,37,'inProgress','2023-05-03 20:38:31'),(30,19,36,'inProgress','2023-05-03 20:38:31'),(37,22,37,'inProgress','2023-05-05 15:37:34'),(39,20,37,'inProgress','2023-05-08 12:55:34'),(40,20,36,'inProgress','2023-05-08 13:24:28'),(41,20,35,'inProgress','2023-05-08 13:24:28'),(42,23,37,'inProgress','2023-05-09 22:02:44'),(43,23,36,'inProgress','2023-05-09 22:02:44'),(45,13,37,'inProgress','2023-05-12 16:20:14'),(46,24,37,'inProgress','2023-05-12 23:38:13'),(47,24,36,'inProgress','2023-05-12 23:38:13'),(48,25,37,'inProgress','2023-05-13 15:24:50'),(49,25,36,'inProgress','2023-05-13 15:24:50'),(56,26,37,'inProgress','2023-05-14 15:17:38'),(57,22,36,'inProgress','2023-05-15 23:08:27'),(58,22,35,'inProgress','2023-05-15 23:08:27'),(59,22,33,'inProgress','2023-05-15 23:08:27'),(60,27,37,'inProgress','2023-05-17 12:04:25'),(61,27,36,'inProgress','2023-05-17 12:04:25'),(62,27,35,'inProgress','2023-05-17 12:04:25'),(67,28,37,'inProgress','2023-05-19 16:18:53'),(68,28,36,'inProgress','2023-05-19 16:18:53'),(73,41,37,'inProgress','2023-05-22 22:52:38'),(74,41,36,'inProgress','2023-05-22 22:52:38'),(75,41,35,'inProgress','2023-05-22 22:52:38'),(76,42,37,'inProgress','2023-05-24 11:37:55'),(77,43,37,'inProgress','2023-05-24 18:15:07'),(78,43,36,'inProgress','2023-05-24 18:15:07'),(79,43,35,'inProgress','2023-05-24 18:15:07'),(80,44,37,'inProgress','2023-05-25 10:39:38'),(81,45,37,'inProgress','2023-05-25 11:05:14'),(82,46,37,'inProgress','2023-05-25 14:14:49'),(83,48,37,'inProgress','2023-05-25 15:58:13'),(84,47,37,'inProgress','2023-05-29 21:43:22'),(85,25,33,'inProgress','2023-05-31 23:30:25'),(86,25,35,'inProgress','2023-05-31 23:30:25'),(87,50,37,'inProgress','2023-06-01 11:00:29'),(88,50,36,'inProgress','2023-06-01 11:00:29'),(89,50,35,'inProgress','2023-06-01 11:00:29'),(90,50,33,'inProgress','2023-06-01 11:00:29'),(92,52,37,'inProgress','2023-06-08 17:13:11'),(93,52,36,'inProgress','2023-06-08 17:13:11'),(94,52,35,'inProgress','2023-06-08 17:13:11'),(95,52,33,'inProgress','2023-06-08 17:13:11'),(96,53,37,'inProgress','2023-06-09 12:56:04'),(97,53,36,'inProgress','2023-06-09 12:56:04'),(98,53,35,'inProgress','2023-06-09 12:56:04'),(99,53,33,'inProgress','2023-06-09 12:56:04'),(100,51,37,'inProgress','2023-06-09 16:10:27'),(101,51,36,'inProgress','2023-06-09 16:10:27'),(102,51,35,'inProgress','2023-06-09 16:10:27'),(103,51,33,'inProgress','2023-06-09 16:10:27'),(104,54,37,'inProgress','2023-06-10 17:38:52'),(105,62,37,'inProgress','2023-06-11 20:12:53'),(106,62,36,'inProgress','2023-06-11 20:12:53'),(107,62,35,'inProgress','2023-06-11 20:12:53'),(108,62,33,'inProgress','2023-06-11 20:12:53'),(109,63,37,'inProgress','2023-06-13 13:09:16'),(110,63,36,'inProgress','2023-06-13 13:09:16'),(111,63,35,'inProgress','2023-06-13 13:09:16'),(112,63,33,'inProgress','2023-06-13 13:09:16'),(113,65,37,'inProgress','2023-06-13 17:41:57'),(114,65,36,'inProgress','2023-06-13 17:41:57'),(115,65,35,'inProgress','2023-06-13 17:41:57'),(116,65,33,'inProgress','2023-06-13 17:41:57'),(117,66,37,'inProgress','2023-06-14 10:45:46'),(118,66,36,'inProgress','2023-06-14 10:45:46'),(119,66,35,'inProgress','2023-06-14 10:45:46'),(120,66,33,'inProgress','2023-06-14 10:45:46'),(121,69,37,'inProgress','2023-06-16 15:27:09'),(122,69,36,'inProgress','2023-06-16 15:27:09'),(123,69,35,'inProgress','2023-06-16 15:27:09'),(124,69,33,'inProgress','2023-06-16 15:27:09'),(125,68,37,'inProgress','2023-06-18 00:20:51'),(126,68,36,'inProgress','2023-06-18 00:20:51'),(127,68,35,'inProgress','2023-06-18 00:20:51'),(128,68,33,'inProgress','2023-06-18 00:20:51'),(129,71,37,'inProgress','2023-06-20 10:53:46'),(130,71,36,'inProgress','2023-06-20 10:53:46'),(131,71,35,'inProgress','2023-06-20 10:53:46'),(132,71,33,'inProgress','2023-06-20 10:53:46'),(133,74,37,'inProgress','2023-06-20 20:17:47'),(134,74,36,'inProgress','2023-06-20 20:17:47'),(135,74,35,'inProgress','2023-06-20 20:17:47'),(136,74,33,'inProgress','2023-06-20 20:17:47'),(137,73,37,'inProgress','2023-06-21 14:57:45'),(138,73,36,'inProgress','2023-06-21 14:57:45'),(139,73,35,'inProgress','2023-06-21 14:57:45'),(140,73,33,'inProgress','2023-06-21 14:57:45'),(141,75,37,'inProgress','2023-06-21 19:28:10'),(142,75,33,'inProgress','2023-06-21 19:28:10'),(143,75,35,'inProgress','2023-06-21 19:28:10'),(144,75,36,'inProgress','2023-06-21 19:28:10'),(145,26,36,'inProgress','2023-06-23 11:29:41'),(146,26,35,'inProgress','2023-06-23 11:29:41'),(147,26,33,'inProgress','2023-06-23 11:29:41'),(148,76,33,'inProgress','2023-06-23 12:32:52'),(149,76,35,'inProgress','2023-06-23 12:32:52'),(150,76,36,'inProgress','2023-06-23 12:32:52'),(151,76,37,'inProgress','2023-06-23 12:32:52');

--
-- Table structure for table `student_session`
--

CREATE TABLE `student_session` (
  `id` int NOT NULL AUTO_INCREMENT,
  `session_id` int NOT NULL,
  `signature_id` int DEFAULT NULL,
  `student_id` int NOT NULL,
  `student_formation_id` int NOT NULL,
  `success_at` datetime DEFAULT NULL,
  `is_success` tinyint(1) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_3D72602CED61183A` (`signature_id`),
  KEY `IDX_3D72602C613FECDF` (`session_id`),
  KEY `IDX_3D72602CCB944F1A` (`student_id`),
  KEY `IDX_3D72602CCBDE9999` (`student_formation_id`),
  CONSTRAINT `FK_3D72602C613FECDF` FOREIGN KEY (`session_id`) REFERENCES `session` (`id`),
  CONSTRAINT `FK_3D72602CCB944F1A` FOREIGN KEY (`student_id`) REFERENCES `ato_user` (`id`),
  CONSTRAINT `FK_3D72602CCBDE9999` FOREIGN KEY (`student_formation_id`) REFERENCES `student_formation` (`id`),
  CONSTRAINT `FK_3D72602CED61183A` FOREIGN KEY (`signature_id`) REFERENCES `signature` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=246 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `student_session`
--

INSERT INTO `student_session` VALUES (2,2,NULL,37,14,'2023-04-21 12:52:13',1),(5,5,6,37,20,'2023-04-26 11:48:14',1),(6,6,8,37,20,'2023-04-26 12:02:02',0),(13,13,14,37,20,'2023-04-26 15:15:01',0),(14,14,16,37,23,'2023-04-26 15:26:27',1),(15,15,18,37,23,'2023-04-26 15:28:56',1),(16,16,20,37,23,'2023-04-26 15:41:05',1),(18,18,22,35,24,'2023-04-26 15:48:02',0),(19,19,24,37,23,'2023-04-27 17:27:37',1),(28,28,26,37,28,'2023-05-02 21:01:45',1),(29,29,28,37,29,'2023-05-03 20:45:14',1),(30,30,30,37,28,'2023-05-04 12:09:33',1),(36,36,32,37,37,'2023-05-05 15:49:42',1),(37,37,34,37,37,'2023-05-05 15:52:42',1),(38,38,36,37,37,'2023-05-05 16:36:58',1),(39,39,38,37,37,'2023-05-05 16:43:28',0),(41,41,40,37,39,'2023-05-08 12:57:28',1),(42,42,42,36,40,'2023-05-08 13:35:08',1),(57,59,53,37,42,'2023-05-10 23:18:48',1),(58,60,55,37,42,'2023-05-10 23:23:55',1),(59,62,57,37,42,'2023-05-10 23:47:11',1),(61,64,59,37,42,'2023-05-11 16:44:59',1),(64,67,61,37,46,'2023-05-12 23:42:18',0),(67,70,63,37,48,'2023-05-13 18:15:37',0),(71,74,65,37,56,'2023-05-14 15:36:15',1),(73,76,67,36,57,'2023-05-15 23:28:02',1),(78,81,70,37,60,'2023-05-17 13:25:13',1),(79,81,NULL,36,61,'2023-05-17 13:25:13',1),(80,81,NULL,35,62,'2023-05-17 13:25:13',1),(81,82,71,37,60,'2023-05-17 13:49:16',1),(82,83,NULL,37,60,'2023-05-17 13:50:23',1),(83,84,NULL,37,60,'2023-05-17 13:50:23',1),(84,85,NULL,37,60,'2023-05-17 13:25:13',1),(85,85,NULL,36,61,'2023-05-17 13:25:13',1),(86,85,NULL,35,62,'2023-05-17 13:25:13',1),(93,92,82,37,46,'2023-05-19 15:20:20',0),(94,93,84,37,56,'2023-05-19 15:21:42',0),(108,107,89,37,81,'2023-05-25 11:06:19',1),(109,108,91,37,81,'2023-05-25 11:07:41',1),(110,109,93,37,82,'2023-05-25 14:23:34',1),(111,110,95,37,82,'2023-05-25 14:43:24',1),(113,112,97,37,83,'2023-05-25 15:59:36',1),(114,113,99,37,83,'2023-05-25 16:01:00',1),(119,118,109,37,83,'2023-05-30 23:49:14',1),(122,121,102,37,87,'2023-06-01 12:22:03',1),(123,122,104,37,87,'2023-06-01 12:30:56',1),(124,123,106,37,77,'2023-06-02 19:37:02',1),(125,124,108,37,77,'2023-06-02 20:05:41',1),(126,125,111,37,76,'2023-06-06 14:19:04',1),(127,126,NULL,37,76,'2023-06-06 14:27:40',0),(128,127,114,37,76,'2023-06-06 14:29:54',0),(129,130,NULL,37,76,'2023-06-06 14:36:18',1),(130,131,117,37,76,'2023-06-06 14:37:05',1),(131,133,NULL,37,76,'2023-06-06 14:38:50',1),(132,134,120,37,76,'2023-06-06 14:39:11',1),(133,136,NULL,37,76,'2023-06-06 14:51:12',1),(134,137,NULL,37,76,'2023-06-06 14:52:06',1),(135,138,NULL,37,76,'2023-06-06 14:58:30',1),(136,139,NULL,37,76,'2023-06-06 15:01:34',1),(137,140,NULL,37,76,'2023-06-06 15:03:20',1),(138,141,127,37,76,'2023-06-06 15:05:52',1),(143,146,NULL,37,76,'2023-06-06 15:37:45',1),(144,147,NULL,37,76,'2023-06-06 15:39:09',1),(145,148,NULL,37,76,'2023-06-06 15:40:48',1),(146,149,NULL,37,76,'2023-06-06 15:47:20',1),(147,150,133,37,76,'2023-06-06 15:47:40',1),(149,152,135,37,87,'2023-06-07 14:34:28',1),(151,154,137,37,92,'2023-06-08 18:00:29',1),(152,155,139,37,92,'2023-06-08 18:26:42',1),(153,156,141,36,93,'2023-06-09 12:14:21',1),(154,157,143,36,93,'2023-06-09 12:19:18',1),(155,158,145,37,96,'2023-06-09 12:59:24',0),(156,159,147,37,96,'2023-06-09 13:01:00',1),(157,160,149,37,96,'2023-06-09 13:02:57',1),(158,161,151,37,96,'2023-06-09 13:03:27',1),(162,165,153,37,104,'2023-06-10 19:54:06',1),(165,168,159,37,104,'2023-06-11 17:51:42',0),(167,170,161,37,105,'2023-06-11 21:03:05',1),(168,171,163,37,105,'2023-06-11 21:11:01',1),(169,172,165,37,105,'2023-06-11 21:43:50',1),(170,173,167,37,105,'2023-06-11 22:02:40',1),(171,174,NULL,35,79,'2023-06-12 18:11:30',1),(172,174,NULL,36,78,'2023-06-12 18:11:30',1),(173,174,179,37,77,'2023-06-12 18:11:30',1),(176,177,170,37,109,'2023-06-13 15:00:34',1),(183,184,172,37,117,'2023-06-14 10:47:22',0),(184,185,174,37,117,'2023-06-14 21:33:29',0),(185,186,176,36,118,'2023-06-15 11:17:48',1),(186,187,178,36,118,'2023-06-15 11:18:52',1),(187,188,181,37,77,'2023-06-15 11:38:31',1),(188,189,183,37,77,'2023-06-15 13:56:59',1),(196,197,185,37,121,'2023-06-16 15:42:09',1),(197,198,187,37,121,'2023-06-16 16:05:35',1),(212,213,189,37,129,'2023-06-20 11:43:30',0),(215,216,191,37,92,'2023-06-21 00:36:00',1),(216,217,193,37,133,'2023-06-21 12:47:31',1),(225,227,199,37,137,'2023-06-22 14:20:59',0),(226,228,201,36,145,'2023-06-23 11:30:36',0),(245,247,NULL,37,151,NULL,0);

--
-- Table structure for table `tem`
--

CREATE TABLE `tem` (
  `id` int NOT NULL AUTO_INCREMENT,
  `threat_group` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `created_at` datetime NOT NULL,
  `phase_sub_group_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_87309B99A2241D27` (`phase_sub_group_id`),
  CONSTRAINT `FK_87309B99A2241D27` FOREIGN KEY (`phase_sub_group_id`) REFERENCES `phases_sub_group` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tem`
--

INSERT INTO `tem` VALUES (1,'grefezfezfez','2023-04-02 11:17:24',2),(2,'tezfef','2023-04-07 19:01:48',NULL),(3,'zfeezfzef','2023-04-11 20:18:29',2),(4,'zefzefz','2023-04-12 17:02:30',3),(5,'fzefff','2023-04-12 17:17:07',3),(10,'zfzefezfez','2023-04-22 17:13:32',2),(11,'rgjyfhryjht','2023-04-22 17:14:54',2),(12,'TEM Phase TEMs','2023-06-23 11:45:34',5);

--
-- Table structure for table `tem_ato`
--

CREATE TABLE `tem_ato` (
  `tem_id` int NOT NULL,
  `ato_id` int NOT NULL,
  PRIMARY KEY (`tem_id`,`ato_id`),
  KEY `IDX_F0F5788B20EF25B5` (`tem_id`),
  KEY `IDX_F0F5788B847DC024` (`ato_id`),
  CONSTRAINT `FK_F0F5788B20EF25B5` FOREIGN KEY (`tem_id`) REFERENCES `tem` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_F0F5788B847DC024` FOREIGN KEY (`ato_id`) REFERENCES `ato` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tem_ato`
--

INSERT INTO `tem_ato` VALUES (3,3),(4,3),(5,3),(5,4),(10,3),(11,3),(12,3);

--
-- Table structure for table `tem_formation_item`
--

CREATE TABLE `tem_formation_item` (
  `tem_id` int NOT NULL,
  `formation_item_id` int NOT NULL,
  PRIMARY KEY (`tem_id`,`formation_item_id`),
  KEY `IDX_51F5666920EF25B5` (`tem_id`),
  KEY `IDX_51F5666957901725` (`formation_item_id`),
  CONSTRAINT `FK_51F5666920EF25B5` FOREIGN KEY (`tem_id`) REFERENCES `tem` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_51F5666957901725` FOREIGN KEY (`formation_item_id`) REFERENCES `formation_item` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `tem_formation_item`
--


--
-- Table structure for table `temdetails`
--

CREATE TABLE `temdetails` (
  `id` int NOT NULL AUTO_INCREMENT,
  `tem_id` int NOT NULL,
  `threat` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL,
  `phase_detail_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_AE78E8E120EF25B5` (`tem_id`),
  KEY `IDX_AE78E8E1B9FFE821` (`phase_detail_id`),
  CONSTRAINT `FK_AE78E8E120EF25B5` FOREIGN KEY (`tem_id`) REFERENCES `tem` (`id`),
  CONSTRAINT `FK_AE78E8E1B9FFE821` FOREIGN KEY (`phase_detail_id`) REFERENCES `phases_detail` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `temdetails`
--

INSERT INTO `temdetails` VALUES (2,2,'fezffezf',NULL),(3,2,'zefzefzefz',NULL),(4,1,'grefrez',5),(8,4,'zefzf',6),(9,5,'zfezfz',NULL),(18,10,'zfzef',5),(19,10,'fezfezfez',NULL),(21,3,'efef EDIT',5),(22,12,'Menaces et erreurs - A',10),(23,12,'Menaces et erreurs - AA',10),(24,12,'Menaces et erreurs - AAA',10),(25,12,'Menaces et erreurs - AAAA',10),(26,12,'Menaces et erreurs - D',11),(27,12,'Menaces et erreurs - DD',11),(28,12,'Menaces et erreurs - G',12),(29,12,'Menaces et erreurs - J',13),(30,12,'Menaces et erreurs - JJ',13);

--
-- Table structure for table `type_aircraft`
--

CREATE TABLE `type_aircraft` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `manufacturer_id` int NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_DE2640D5A23B42D` (`manufacturer_id`),
  CONSTRAINT `FK_DE2640D5A23B42D` FOREIGN KEY (`manufacturer_id`) REFERENCES `manufacturer_aircraft` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=141 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `type_aircraft`
--

INSERT INTO `type_aircraft` VALUES (1,'ATL',1),(2,'DR-105A',1),(3,'DR-1050',1),(4,'DR-1051',1),(5,'DR-1050 MM1',1),(6,'DR-1051 MM1',1),(7,'DR-1050 M',1),(8,'DR-1051 M',1),(9,'DR-200',1),(10,'DR-250',1),(11,'DR-220',1),(12,'DR-221',1),(13,'DR-253',1),(14,'DR-340',1),(15,'DR-315',1),(16,'DR-360',1),(17,'DR-380',1),(18,'DR-330',1),(19,'DR-300',1),(20,'DR 400',1),(21,'HR 100',1),(22,'HR 200',1),(23,'R 1180',1),(24,'R 2112',1),(25,'R 2160',1),(26,'R 3000',1),(27,'HR-100',1),(28,'HR-200',1),(29,'R-1180',1),(30,'R-2100',1),(31,'R-2112',1),(32,'R-2160',1),(33,'R-2120',1),(34,'R-3000',1),(35,'C150',2),(36,'C152',2),(37,'C172',2),(38,'C177',2),(39,'C180',2),(40,'C182',2),(41,'C206',2),(42,'C210',2),(43,'C350',2),(44,'C400',2),(45,'C208 CARAVAN',2),(46,'AT',3),(47,'206',4),(48,'407',4),(49,'M25Y',5),(50,'Action',6),(51,'Merlin',7),(52,'Phase 2',8),(53,'Bidulm',8),(54,'Eurofox',9),(55,'MCR',10),(56,'COUGAR',11),(57,'M16',12),(58,'XENON',13),(59,'Liberty',14),(60,'Cross-over',15),(61,'Cloud Surfer',15),(62,'Dawn Chaser',15),(63,'CH-7',16),(64,'Lambada',17),(65,'SF28',18),(66,'S10',19),(67,'20E',20),(68,'STD 3',21),(69,'D-6856',22),(70,'3',23),(71,'ASK21',24),(72,'ASW',24),(73,'J3',25),(74,'J4',25),(75,'J5',25),(76,'PA-11',25),(77,'PA-12',25),(78,'PA-14',25),(79,'PA-18',25),(80,'PA-20',25),(81,'PA-21',25),(82,'PA-23',25),(83,'PA-24',25),(84,'PA-25',25),(85,'PA-28',25),(86,'PA-30',25),(87,'PA-31',25),(88,'PA-32',25),(89,'PA-34',25),(90,'PA-36',25),(91,'PA-38',25),(92,'PA-42',25),(93,'PA-44',25),(94,'PA-46',25),(95,'PA-47',25),(96,'VK-30',26),(97,'SR20',26),(98,'SR22',26),(99,'Vision',26),(100,'DA 20',27),(101,'DA 40',27),(102,'DA 42',27),(103,'DA 50',27),(104,'D-JET',27),(105,'Rallye',28),(106,'Gardan',29),(107,'ST 10',29),(108,'TB 9',29),(109,'TB 10',29),(110,'TB 200',29),(111,'TB 20',29),(112,'TB 21',29),(113,'TB 30',29),(114,'TBM 700',29),(115,'TBM 850',29),(116,'TBM 900',29),(117,'RF-2',30),(118,'RF-3',30),(119,'RF-4',30),(120,'RF-5',30),(121,'RF-6',30),(122,'RF-7',30),(123,'RF-8',30),(124,'RF-10',30),(125,'RF-47',30),(126,'PIONEER',31),(127,'SYTON',31),(128,'CAP 10',32),(129,'CAP 20',33),(130,'CAP 21',33),(131,'CAP 230',33),(132,'CAP 231',33),(133,'CAP 232',33),(134,'CAP 332',33),(135,'CAP 432',33),(136,'CR',34),(137,'EXTRA',35),(138,'PITTS',36),(139,'GRUMMAN',37),(140,'Test',38);

--
-- Table structure for table `type_aircraft_model_aircraft`
--

CREATE TABLE `type_aircraft_model_aircraft` (
  `type_aircraft_id` int NOT NULL,
  `model_aircraft_id` int NOT NULL,
  PRIMARY KEY (`type_aircraft_id`,`model_aircraft_id`),
  KEY `IDX_114C446CCF77F8CD` (`type_aircraft_id`),
  KEY `IDX_114C446CEA6C16B0` (`model_aircraft_id`),
  CONSTRAINT `FK_114C446CCF77F8CD` FOREIGN KEY (`type_aircraft_id`) REFERENCES `type_aircraft` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_114C446CEA6C16B0` FOREIGN KEY (`model_aircraft_id`) REFERENCES `model_aircraft` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `type_aircraft_model_aircraft`
--

INSERT INTO `type_aircraft_model_aircraft` VALUES (1,1),(2,2),(3,3),(3,4),(4,3),(4,4),(5,5),(6,5),(7,6),(8,6),(9,7),(10,8),(10,9),(11,10),(11,11),(11,12),(12,9),(12,13),(13,9),(13,14),(14,15),(15,16),(16,17),(17,18),(18,19),(19,20),(19,21),(19,22),(19,23),(20,14),(20,15),(20,24),(20,25),(20,26),(21,27),(22,28),(23,29),(24,30),(25,31),(26,32),(27,33),(27,34),(27,35),(27,36),(27,37),(27,38),(27,39),(27,40),(27,41),(28,42),(29,43),(29,44),(29,45),(30,46),(31,47),(32,48),(32,49),(33,47),(34,23),(34,50),(34,51),(34,52),(34,53),(35,54),(35,55),(36,56),(36,57),(37,58),(37,59),(37,60),(38,61),(38,62),(38,63),(39,64),(40,65),(40,66),(40,67),(40,68),(40,69),(40,70),(40,71),(40,72),(40,73),(40,74),(40,75),(40,76),(41,77),(41,78),(41,79),(42,80),(43,81),(44,81),(45,82),(45,83),(45,84),(45,85),(45,86),(45,87),(45,88),(46,89),(46,90),(46,91),(46,92),(46,93),(46,94),(47,95),(47,96),(47,97),(47,98),(47,99),(48,100),(49,101),(50,102),(51,103),(52,104),(52,105),(53,106),(54,107),(54,108),(55,107),(55,109),(55,110),(56,111),(57,112),(58,113),(59,114),(60,115),(60,116),(60,117),(60,118),(60,119),(60,120),(60,121),(61,122),(61,123),(61,124),(61,125),(61,126),(61,127),(62,128),(62,129),(62,130),(63,131),(64,132),(65,133),(66,134),(66,135),(66,136),(66,137),(67,138),(68,139),(69,140),(70,141),(71,142),(71,143),(72,144),(72,145),(72,146),(72,147),(73,148),(74,149),(75,150),(76,151),(77,152),(78,153),(79,154),(80,155),(81,156),(82,157),(82,158),(83,159),(84,160),(85,161),(85,162),(85,163),(85,164),(85,165),(86,166),(87,167),(87,168),(87,169),(87,170),(88,171),(88,172),(88,173),(89,174),(90,175),(91,176),(92,170),(93,177),(94,178),(94,179),(94,180),(94,181),(95,182),(96,183),(97,184),(98,185),(98,186),(99,187),(100,188),(101,189),(101,190),(101,191),(102,192),(102,193),(102,194),(102,195),(102,196),(103,197),(103,198),(104,199),(105,200),(105,201),(105,202),(105,203),(105,204),(105,205),(105,206),(105,207),(105,208),(105,209),(106,210),(107,211),(108,212),(109,213),(110,214),(111,215),(112,216),(113,217),(114,218),(115,219),(116,220),(117,221),(118,222),(119,223),(120,224),(121,225),(122,226),(123,227),(124,228),(125,229),(126,230),(126,231),(126,232),(126,233),(126,234),(126,235),(126,236),(127,237),(128,9),(128,238),(129,239),(129,240),(130,241),(131,242),(132,243),(132,244),(133,245),(134,246),(135,247),(136,50),(136,248),(136,249),(136,250),(137,33),(137,251),(137,252),(137,253),(137,254),(137,255),(137,256),(137,257),(138,258),(138,259),(138,260),(138,261),(138,262),(138,263),(138,264),(138,265),(138,266),(138,267),(138,268),(138,269),(138,270),(139,271),(139,272),(139,273),(139,274),(140,275);

--
-- Table structure for table `user`
--

CREATE TABLE `user` (
  `id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:guid)',
  `email` varchar(180) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `roles` json NOT NULL,
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `firstname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `lastname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `phone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `licence_number` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `last_login` datetime DEFAULT NULL,
  `token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created_at` datetime NOT NULL,
  `validate_at` datetime DEFAULT NULL,
  `last_login_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `civility` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `avatar_file_id` int DEFAULT NULL,
  `new_last_login_ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `new_last_login` datetime DEFAULT NULL,
  `preference` json DEFAULT NULL,
  `postal_address_id` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UNIQ_8D93D649E7927C74` (`email`),
  UNIQUE KEY `UNIQ_8D93D64945A576B2` (`avatar_file_id`),
  UNIQUE KEY `UNIQ_8D93D649FD54954B` (`postal_address_id`),
  CONSTRAINT `FK_8D93D64945A576B2` FOREIGN KEY (`avatar_file_id`) REFERENCES `media_object` (`id`) ON DELETE SET NULL,
  CONSTRAINT `FK_8D93D649FD54954B` FOREIGN KEY (`postal_address_id`) REFERENCES `postal_address` (`id`),
  CONSTRAINT `user_chk_1` CHECK (json_valid(`roles`)),
  CONSTRAINT `user_chk_2` CHECK (json_valid(`preference`))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user`
--

INSERT INTO `user` VALUES ('03877864-9f30-11ed-a278-0242ac120004','mja.arredondo+test2@gmail.com','[]','$2y$13$NqKm5qJqoR4qvnKdvrSd1O7axgDewtyOMiadquXWQhYTlFg5vSV..','Mathias','Arredondo','0606060606','',NULL,NULL,'2023-01-28 17:20:08',NULL,NULL,NULL,'men','',18,'172.18.0.1','2023-04-21 09:14:45','[]',80),('0b4ff315-a8ab-11ed-b14e-0242ac120002','mja.arredondo+creation3@gmail.com','[]','$2y$13$qqDES0M/Wons7JCh2DEQEeF52Fz9JeJth8CHBwQ8Xt279QizG4uJC','Mathias','Arredondo','0621600320',NULL,'2023-02-10 16:38:46',NULL,'2023-02-09 18:53:29',NULL,'172.18.0.1','1997-10-31','men','',5,'172.18.0.1','2023-02-10 16:39:22','[]',66),('26eb189f-a65a-11ed-9a87-0242ac120005','mja.arredondo+testRole@gmail.com','[]','$argon2id$v=19$m=65536,t=4,p=1$hkN1/aRkxCmmzt/KRxVEqA$9uUDAOGfxyDrV4tFX0AOnWtO2VHBuD35hjAL4jSjbOQ','Mathias','Arredondo','0621600320',NULL,NULL,NULL,'2023-02-06 20:09:24',NULL,NULL,'1997-10-31','men','',6,NULL,NULL,'[]',69),('2be64b2c-1cdc-45cf-a43e-b095857364nb','mja.arredondo@gmail.com','[\"ROLE_ADMIN\"]','$2y$13$3KN1D2/3r2cHXwTcnaFdNOejY9HVOXmWDoXG93H/q/.7eGXAfVpty','Mathias','Arredondo','123445555566','1234567890','2023-06-02 15:07:43',NULL,'2020-06-05 15:18:37','2020-06-05 15:18:36','172.18.0.1','1966-06-04','men',NULL,NULL,'172.18.0.1','2023-06-02 17:22:38',NULL,1),('2be64b2c-1cdc-45cf-a43e-b095857384de','itatlantis@gmail.com','[]','$2y$13$aEh0.IXMsHgQgGR7lRZ35e3YXCTdQoibQhl4kW7X83cB364nb.SFy','Sergio','Di Donato','123445555566','1234567890','2023-01-20 16:08:00',NULL,'2020-06-05 15:18:37','2020-06-05 15:18:36','85.27.2.19','1966-06-04','men',NULL,NULL,'85.27.2.19','2023-01-20 16:08:22',NULL,2),('3870b579-9b32-11ed-97f8-0242ac120004','mja.arredondo+creation@gmail.com','[]','$argon2id$v=19$m=65536,t=4,p=1$rGGqx4oYv53DfNSUSV+OiA$vACuRcdHEkm/IIXHJBFlzS51r4Y48XHbYoHe9YQ4Snk','Mathias','Arredondo','','',NULL,NULL,'2023-01-23 15:25:51',NULL,NULL,NULL,'','',NULL,NULL,NULL,'[]',NULL),('4f0e2470-e025-11ed-b103-0242ac120002','mja.arredondo+test2_1@gmail.com','[]','$argon2id$v=19$m=65536,t=4,p=1$NqHx+MWp18Xd7WKAT9H6ig$+57joY1KRXCd00USkN6AEh7jafO9LfW34IuVu9u//mU','Mathias','Arredondo','0505050505',NULL,NULL,NULL,'2023-04-21 09:17:15',NULL,NULL,'1997-10-31','men','',19,'te',NULL,'[]',88),('5fc3353c-a0ee-11ed-b188-0242ac120005','mja.arredondo+testSupp@gmail.com','[]','$2y$13$4ZjjhyuVGhvfuvE58CvJdOugBWEIPs74cm4GJYVdzger1A84H.Nh.','Mathias','Arredondo','','','2023-02-05 22:43:18',NULL,'2023-01-30 22:35:18',NULL,'172.18.0.1',NULL,'','',NULL,'172.18.0.1','2023-02-05 22:46:48','[]',NULL),('61b08719-e025-11ed-b103-0242ac120002','mja.arredondo+test2_2@gmail.com','[]','$2y$13$slSjiFf9NeDPivhvj5lEMei1tZAFHJUMXEWkP5fQZAAUKaY/NE4fK','Mathias 2_2','Arredondo','625165156',NULL,'2023-06-15 11:27:55',NULL,'2023-04-21 09:17:47',NULL,'172.18.0.1','1997-10-31','men','',NULL,'172.18.0.1','2023-06-15 11:37:42','[]',95),('6b6dc8dc-a654-11ed-9a87-0242ac120005','mja.arredondo+test3@gmail.com','[]','$argon2id$v=19$m=65536,t=4,p=1$ESt27w7akoqpKb6KXvPZuA$jdH2WkdAcZys8p9b8nYbpQjGgSiWDIioEL3vqvaeihA','','','','',NULL,'63e154d6c322e','2023-02-06 19:28:22',NULL,NULL,NULL,'','',NULL,NULL,NULL,'[]',NULL),('6b9c79aa-9b32-11ed-97f8-0242ac120004','mja.arredondo+creation2@gmail.com','[]','$2y$13$mjRq4XsNRH2i/i/IG/zojeLoaejMMPQxBq/broF.q3.op8c8wHbzm','Mathias','Arredondo','','','2023-02-08 21:05:41',NULL,'2023-01-23 15:27:17',NULL,'172.18.0.1',NULL,'','',NULL,'172.18.0.1','2023-02-10 16:35:15','[]',NULL),('74366de7-e025-11ed-b103-0242ac120002','mja.arredondo+test2_3@gmail.com','[]','$argon2id$v=19$m=65536,t=4,p=1$p6n+uN87tpoLhr5aVlS25g$E05pdyO8kJvCSA4j9AGs/bmNrbJZOfC/wKuITRCQsao','Mathias 2_3','Arredondo','65156165',NULL,NULL,NULL,'2023-04-21 09:18:18',NULL,NULL,'1997-10-31','men','',21,NULL,NULL,'[]',85),('9bc89c16-e025-11ed-b103-0242ac120002','mja.arredondo+test2_4@gmail.com','[]','$argon2id$v=19$m=65536,t=4,p=1$4zJztWCI1cVRMCLb1H/7MQ$D0ioLiX/fSXXg7OYk2DQcYM3Gc+6u9YwXcKJaROY/6g','Mathias 2_4','Arredondo','5414451654',NULL,NULL,NULL,'2023-04-21 09:19:24',NULL,NULL,'1997-10-31','men','',22,NULL,NULL,'[]',86),('e82e1ec2-9a66-11ed-9a3d-0242ac120005','mja.arredondo+test@gmail.com','[]','$2y$13$uejcIZPPrulb/4G.O5zuYe6bMF6T.Okem7MgIfFkNJyEUj/XYB44m','Mathias','Arredondo','0606060606','1234567654','2023-06-20 10:46:03','63d020e2ca3ee','2023-01-22 15:10:28',NULL,'172.18.0.1','1997-10-31','men','',1,'172.18.0.1','2023-06-20 14:57:41','[]',94),('f9267fff-c04a-11ed-afd6-0242ac120003','mja.arredondo+user@gmail.com','[]','$argon2id$v=19$m=65536,t=4,p=1$sVb7LM4X/Y6DQ0NG6eKRPA$hnocZ9JnVDotmdV8xiWjkLshFMf2XcW9TyWbvV+8hSo','','','','',NULL,'640ce3e7cb7a4','2023-03-11 20:26:15',NULL,NULL,NULL,'','',NULL,NULL,NULL,'[]',NULL);

--
-- Table structure for table `user_app_role`
--

CREATE TABLE `user_app_role` (
  `user_id` char(36) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '(DC2Type:guid)',
  `app_role_id` int NOT NULL,
  PRIMARY KEY (`user_id`,`app_role_id`),
  KEY `IDX_B2CA4BCAA76ED395` (`user_id`),
  KEY `IDX_B2CA4BCA3B5EA2E1` (`app_role_id`),
  CONSTRAINT `FK_B2CA4BCA3B5EA2E1` FOREIGN KEY (`app_role_id`) REFERENCES `app_role` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_B2CA4BCAA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `user_app_role`
--

INSERT INTO `user_app_role` VALUES ('2be64b2c-1cdc-45cf-a43e-b095857364nb',1),('2be64b2c-1cdc-45cf-a43e-b095857384de',1);


