INSERT INTO `formation_item` (`id`, `parent_id`, `formation_id`, `name`, `standard_duration`, `max_duration`, `type`, `description`, `goals`, `position`, `extra_lesson_id`, `config_isexpended`, `formation_item_from_list_id`, `notation_id`, `min_rating_id`, `classroom_id`, `subname`, `is_theoretical`, `min_visibility`, `min_weather`, `ceiling`, `technical_ref`, `groupe`, `is_important`, `expected_value_id`) VALUES
(63797, 63802, NULL, 'E6', 0, 0, 'item_exercise', '', '', 0, NULL, NULL, 'cl1axk2j8001j2669i3p1h9zo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63798, 63803, NULL, 'E7', 0, 0, 'item_exercise', '', '', 0, NULL, NULL, 'cl1axk8jp001n26695s39qn1c', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63799, 63803, NULL, 'E8', 0, 0, 'item_exercise', '', '', 1, NULL, NULL, 'cl1axkjbs001r2669vw513mw1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63800, NULL, 349, 'S1', 0, 0, 'item_lesson', '', '', 0, NULL, 1, 'cl1axiogx000j26693ni36tmo', NULL, NULL, NULL, NULL, 0, '', '', '', '', 0, NULL, NULL),
(63801, NULL, 349, 'S2', 0, 0, 'item_lesson', '', '', 1, NULL, 1, 'cl1axitw5000n2669rhhgtjs9', NULL, NULL, NULL, NULL, 0, '', '', '', '', 0, NULL, NULL),
(63802, NULL, 349, 'S3', 0, 0, 'item_lesson', '', '', 2, NULL, 1, 'cl1axixf8000r2669sa8dvzrj', NULL, NULL, NULL, NULL, 0, '', '', '', '', 0, NULL, NULL),
(63803, NULL, 349, 'S4', 0, 0, 'item_lesson', '', '', 3, NULL, 1, 'cl1axj3ux000v2669q25lyq85', NULL, NULL, NULL, NULL, 0, '', '', '', '', 0, NULL, NULL),
(63804, 63812, NULL, 'E1', 0, 0, 'item_exercise', '', '', 0, 28, NULL, 'cl1axj6xg000z2669cl8dmn04', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63805, 63812, NULL, 'E2', 0, 0, 'item_exercise', '', '', 1, 28, NULL, 'cl1axjbdo001126699hxlqap5', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63806, 63813, NULL, 'E3', 0, 0, 'item_exercise', '', '', 0, 28, NULL, 'cl1axjg3w001726693633gkux', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63807, 63813, NULL, 'E4', 0, 0, 'item_exercise', '', '', 1, 28, NULL, 'cl1axjk7g001b2669qzzq7ydi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63808, 63813, NULL, 'E5', 0, 0, 'item_exercise', '', '', 2, 28, NULL, 'cl1axjudh001f266990hf0lxh', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63809, 63814, NULL, 'E6', 0, 0, 'item_exercise', '', '', 0, 28, NULL, 'cl1axk2j8001j2669i3p1h9zo', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63810, 63815, NULL, 'E7', 0, 0, 'item_exercise', '', '', 0, 28, NULL, 'cl1axk8jp001n26695s39qn1c', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63811, 63815, NULL, 'E8', 0, 0, 'item_exercise', '', '', 1, 28, NULL, 'cl1axkjbs001r2669vw513mw1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63812, NULL, 350, 'S1', 0, 0, 'item_lesson', '', '', 0, NULL, 1, 'cl1axiogx000j26693ni36tmo', NULL, NULL, NULL, NULL, 0, '', '', '', '', 0, NULL, NULL),
(63813, NULL, 350, 'S2', 0, 0, 'item_lesson', '', '', 1, NULL, 1, 'cl1axitw5000n2669rhhgtjs9', NULL, NULL, NULL, NULL, 0, '', '', '', '', 0, NULL, NULL),
(63814, NULL, 350, 'S3', 0, 0, 'item_lesson', '', '', 2, NULL, 1, 'cl1axixf8000r2669sa8dvzrj', NULL, NULL, NULL, NULL, 0, '', '', '', '', 0, NULL, NULL),
(63815, NULL, 350, 'S4', 0, 0, 'item_lesson', '', '', 3, NULL, 1, 'cl1axj3ux000v2669q25lyq85', NULL, NULL, NULL, NULL, 0, '', '', '', '', 0, NULL, NULL),
(63816, NULL, 350, 'S5', 0, 0, 'item_lesson', '', '', 4, NULL, 1, 'cl1axmyb000ae26695ar8lyyg', NULL, NULL, NULL, NULL, 0, '', '', '', '', 0, NULL, NULL),
(63817, 63815, NULL, 'E9', 0, 0, 'item_exercise', '', '', 2, 28, NULL, 'cl1axnusl00c82669q8smxed1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63818, 63816, NULL, 'E9', 0, 0, 'item_exercise', '', '', 0, 28, NULL, 'cl1axnusl00c82669q8smxed1', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63819, 63816, NULL, 'E10', 0, 0, 'item_exercise', '', '', 1, 28, NULL, 'cl1axnzzi00cc2669z1hg5det', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63820, NULL, 351, 'SA', 0, 0, 'item_lesson', '', '', 0, NULL, 1, 'cl1bsxbsz00013e6aset6fx9j', 85, NULL, NULL, NULL, 0, '', '', '', '', 0, NULL, NULL),
(63821, NULL, 351, 'SB', 0, 0, 'item_lesson', '', '', 1, NULL, 1, 'cl1bsxgzs00073e6a5d9vpkl1', 85, NULL, NULL, NULL, 0, '', '', '', '', 0, NULL, NULL),
(63822, 63820, NULL, 'X1', 0, 0, 'item_exercise', '', '', 0, NULL, NULL, 'cl1bsxkwt000b3e6a0tsg87bx', 85, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63823, 63820, NULL, 'X2', 0, 0, 'item_exercise', '', '', 1, NULL, NULL, 'cl1bsxo42000f3e6axgv3wavb', 85, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63824, 63821, NULL, 'X3', 0, 0, 'item_exercise', '', '', 0, NULL, NULL, 'cl1bsxreh000j3e6awu16wj5i', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63825, 63821, NULL, 'X1', 0, 0, 'item_exercise', '', '', 1, NULL, NULL, 'cl1bsxkwt000b3e6a0tsg87bx', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63826, 63830, NULL, 'X1', 0, 0, 'item_exercise', '', '', 0, NULL, NULL, 'cl1bsxkwt000b3e6a0tsg87bx', 85, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63827, 63830, NULL, 'X2', 0, 0, 'item_exercise', '', '', 1, NULL, NULL, 'cl1bsxo42000f3e6axgv3wavb', 85, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63828, 63831, NULL, 'X3', 0, 0, 'item_exercise', '', '', 0, NULL, NULL, 'cl1bsxreh000j3e6awu16wj5i', 85, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63829, 63831, NULL, 'X1', 0, 0, 'item_exercise', '', '', 1, NULL, NULL, 'cl1bsxkwt000b3e6a0tsg87bx', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63830, NULL, 352, 'SA', 0, 0, 'item_lesson', '', '', 0, NULL, 1, 'cl1bsxbsz00013e6aset6fx9j', 85, NULL, NULL, NULL, 0, '', '', '', '', 0, NULL, NULL),
(63831, NULL, 352, 'SB', 0, 0, 'item_lesson', '', '', 1, NULL, 1, 'cl1bsxgzs00073e6a5d9vpkl1', 85, NULL, NULL, NULL, 0, '', '', '', '', 0, NULL, NULL),
(63832, 63836, NULL, 'X1', 0, 0, 'item_exercise', '', '', 0, NULL, NULL, 'cl1bsxkwt000b3e6a0tsg87bx', 85, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63833, 63836, NULL, 'X2', 0, 0, 'item_exercise', '', '', 1, NULL, NULL, 'cl1bsxo42000f3e6axgv3wavb', 85, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63834, 63837, NULL, 'X3', 0, 0, 'item_exercise', '', '', 0, NULL, NULL, 'cl1bsxreh000j3e6awu16wj5i', 85, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63835, 63837, NULL, 'X1', 0, 0, 'item_exercise', '', '', 1, NULL, NULL, 'cl1bsxkwt000b3e6a0tsg87bx', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL),
(63836, NULL, 353, 'SA', 0, 0, 'item_lesson', '', '', 0, NULL, 1, 'cl1bsxbsz00013e6aset6fx9j', 85, NULL, NULL, NULL, 0, '', '', '', '', 0, NULL, NULL),
(63837, NULL, 353, 'SB', 0, 0, 'item_lesson', '', '', 1, NULL, 1, 'cl1bsxgzs00073e6a5d9vpkl1', 85, NULL, NULL, NULL, 0, '', '', '', '', 0, NULL, NULL);

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

--
-- Structure de la table `formation_items_technical_skills`
--

CREATE TABLE `formation_items_technical_skills` (
  `formation_item_id` int NOT NULL,
  `skills_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `formation_items_technical_skills` (`formation_item_id`, `skills_id`) VALUES
(484, 32),
(10687, 37),
(10708, 37),
(10730, 37),
(10747, 37),
(10748, 37),
(10749, 37),
(10750, 37),
(10751, 37),
(10752, 37),
(10753, 37),
(10893, 37),
(10894, 37),
(10895, 37),
(10896, 37),
(10897, 37),
(10898, 37),
(10899, 37),
(11046, 37),
(11047, 37),
(11048, 37),
(11049, 37),
(11050, 37),
(11051, 37),
(11052, 37),
(11053, 37),
(11054, 37),
(11055, 37),
(11056, 37),
(11256, 37),
(11257, 37),
(11258, 37),
(11259, 37),
(11260, 37),
(11261, 37),
(11262, 37),
(11263, 37),
(11264, 37),
(11265, 37),
(11436, 37),
(11437, 37),
(11438, 37),
(11439, 37),
(11440, 37),
(11442, 37),
(11443, 37),
(11444, 37),
(11445, 37),
(11593, 37),
(11594, 37),
(11620, 37),
(11621, 37),
(11622, 37),
(11623, 37),
(11624, 37),
(11727, 37),
(11728, 37),
(11729, 37),
(11731, 37),
(11732, 37),
(20103, 37),
(20104, 37),
(20105, 37),
(20106, 37),
(20107, 37),
(20108, 37),
(20109, 37),
(20110, 37),
(20111, 37),
(20112, 37),
(20114, 37),
(20115, 37),
(20116, 37),
(20117, 37),
(20118, 37),
(20119, 37),
(20120, 37),
(20122, 37),
(20123, 37),
(20124, 37),
(20125, 37),
(20126, 37),
(20127, 37),
(20128, 37),
(20129, 37),
(20130, 37),
(20131, 37),
(20132, 37),
(20134, 37),
(20135, 37),
(20136, 37),
(20137, 37),
(20138, 37),
(20139, 37),
(20140, 37),
(20141, 37),
(20142, 37),
(20143, 37),
(20145, 37),
(20146, 37),
(20147, 37),
(20148, 37),
(20149, 37),
(20151, 37),
(20152, 37),
(20153, 37),
(20154, 37),
(20268, 37),
(20269, 37),
(20270, 37),
(20272, 37),
(20273, 37),
(20418, 37),
(20419, 37),
(20421, 37),
(20422, 37),
(20423, 37),
(20424, 37),
(20425, 37),
(21507, 37),
(21508, 37),
(21509, 37),
(21511, 37),
(21512, 37),
(21622, 37),
(21623, 37),
(21624, 37),
(21626, 37),
(21627, 37),
(22994, 37),
(23050, 37),
(23084, 37),
(23113, 37),
(23142, 37),
(23175, 37),
(60219, 40),
(60220, 40),
(60221, 40),
(60222, 40),
(62178, 42),
(62179, 35),
(62180, 40);

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

--
-- Structure de la table `formation_item_action`
--

CREATE TABLE `formation_item_action` (
  `formation_item_id` int NOT NULL,
  `action_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `formation_item_action` (`formation_item_id`, `action_id`) VALUES
(62278, 72);

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

--
-- Structure de la table `formation_item_formation_item`
--

CREATE TABLE `formation_item_formation_item` (
  `formation_item_source` int NOT NULL,
  `formation_item_target` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `formation_item_skills`
--

CREATE TABLE `formation_item_skills` (
  `formation_item_id` int NOT NULL,
  `skills_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `formation_item_skills` (`formation_item_id`, `skills_id`) VALUES
(484, 34),
(10687, 36),
(10708, 36),
(10730, 36),
(10747, 36),
(10748, 36),
(10749, 36),
(10750, 36),
(10751, 36),
(10752, 36),
(10753, 36),
(10893, 36),
(10894, 36),
(10895, 36),
(10896, 36),
(10897, 36),
(10898, 36),
(10899, 36),
(11046, 36),
(11047, 36),
(11048, 36),
(11049, 36),
(11050, 36),
(11051, 36),
(11052, 36),
(11053, 36),
(11054, 36),
(11055, 36),
(11056, 36),
(11256, 36),
(11257, 36),
(11258, 36),
(11259, 36),
(11260, 36),
(11261, 36),
(11262, 36),
(11263, 36),
(11264, 36),
(11265, 36),
(11436, 36),
(11437, 36),
(11438, 36),
(11439, 36),
(11440, 36),
(11442, 36),
(11443, 36),
(11444, 36),
(11445, 36),
(11593, 36),
(11594, 36),
(11620, 36),
(11621, 36),
(11622, 36),
(11623, 36),
(11624, 36),
(11727, 36),
(11728, 36),
(11729, 36),
(11731, 36),
(11732, 36),
(11881, 38),
(11882, 38),
(11883, 38),
(11884, 38),
(11885, 38),
(11886, 38),
(11887, 38),
(11888, 38),
(11889, 38),
(11890, 38),
(11891, 38),
(11892, 38),
(11893, 38),
(11894, 38),
(11895, 38),
(11896, 38),
(11897, 38),
(11898, 38),
(11899, 38),
(11900, 38),
(11901, 38),
(11902, 38),
(11903, 38),
(11904, 38),
(11920, 38),
(11921, 38),
(11922, 38),
(11923, 38),
(11924, 38),
(11925, 38),
(11926, 38),
(11927, 38),
(11928, 38),
(11929, 38),
(11930, 38),
(11931, 38),
(11932, 38),
(11933, 38),
(11934, 38),
(11935, 38),
(12300, 38),
(12301, 38),
(12305, 38),
(12306, 38),
(12307, 38),
(12308, 38),
(12309, 38),
(12310, 38),
(12311, 38),
(12312, 38),
(12313, 38),
(12314, 38),
(12315, 38),
(12316, 38),
(12317, 38),
(12318, 38),
(12319, 38),
(12320, 38),
(12321, 38),
(12322, 38),
(12323, 38),
(12324, 38),
(12325, 38),
(12326, 38),
(12327, 38),
(12328, 38),
(12330, 38),
(12331, 38),
(12332, 38),
(12334, 38),
(12335, 38),
(12336, 38),
(12338, 38),
(12339, 38),
(12341, 38),
(12342, 38),
(12343, 38),
(12344, 38),
(12734, 38),
(12735, 38),
(12736, 38),
(12737, 38),
(12738, 38),
(12739, 38),
(12740, 38),
(12741, 38),
(12742, 38),
(20103, 36),
(20104, 36),
(20105, 36),
(20106, 36),
(20107, 36),
(20108, 36),
(20109, 36),
(20110, 36),
(20111, 36),
(20112, 36),
(20114, 36),
(20115, 36),
(20116, 36),
(20117, 36),
(20118, 36),
(20119, 36),
(20120, 36),
(20122, 36),
(20123, 36),
(20124, 36),
(20125, 36),
(20126, 36),
(20127, 36),
(20128, 36),
(20129, 36),
(20130, 36),
(20131, 36),
(20132, 36),
(20134, 36),
(20135, 36),
(20136, 36),
(20137, 36),
(20138, 36),
(20139, 36),
(20140, 36),
(20141, 36),
(20142, 36),
(20143, 36),
(20145, 36),
(20146, 36),
(20147, 36),
(20148, 36),
(20149, 36),
(20151, 36),
(20152, 36),
(20153, 36),
(20154, 36),
(20268, 36),
(20269, 36),
(20270, 36),
(20272, 36),
(20273, 36),
(20418, 36),
(20419, 36),
(20421, 36),
(20422, 36),
(20423, 36),
(20424, 36),
(20425, 36),
(20848, 38),
(20849, 38),
(20850, 38),
(20851, 38),
(20852, 38),
(20853, 38),
(20854, 38),
(20855, 38),
(20856, 38),
(20857, 38),
(20858, 38),
(20859, 38),
(20860, 38),
(20861, 38),
(20862, 38),
(20863, 38),
(20864, 38),
(20865, 38),
(20866, 38),
(20867, 38),
(20868, 38),
(20869, 38),
(20870, 38),
(20871, 38),
(20872, 38),
(20873, 38),
(20874, 38),
(20875, 38),
(20876, 38),
(20877, 38),
(20878, 38),
(20879, 38),
(20880, 38),
(20881, 38),
(20882, 38),
(20883, 38),
(20884, 38),
(20885, 38),
(20886, 38),
(20887, 38),
(20888, 38),
(20889, 38),
(21310, 38),
(21311, 38),
(21312, 38),
(21313, 38),
(21314, 38),
(21315, 38),
(21316, 38),
(21317, 38),
(21318, 38),
(21319, 38),
(21320, 38),
(21321, 38),
(21322, 38),
(21323, 38),
(21324, 38),
(21325, 38),
(21326, 38),
(21327, 38),
(21328, 38),
(21329, 38),
(21330, 38),
(21331, 38),
(21332, 38),
(21333, 38),
(21334, 38),
(21335, 38),
(21336, 38),
(21337, 38),
(21338, 38),
(21339, 38),
(21340, 38),
(21341, 38),
(21342, 38),
(21343, 38),
(21344, 38),
(21345, 38),
(21346, 38),
(21347, 38),
(21348, 38),
(21349, 38),
(21350, 38),
(21351, 38),
(21507, 36),
(21508, 36),
(21509, 36),
(21511, 36),
(21512, 36),
(21622, 36),
(21623, 36),
(21624, 36),
(21626, 36),
(21627, 36),
(22048, 38),
(22049, 38),
(22050, 38),
(22051, 38),
(22052, 38),
(22053, 38),
(22054, 38),
(22055, 38),
(22056, 38),
(22057, 38),
(22058, 38),
(22059, 38),
(22060, 38),
(22061, 38),
(22062, 38),
(22063, 38),
(22064, 38),
(22065, 38),
(22066, 38),
(22067, 38),
(22068, 38),
(22069, 38),
(22070, 38),
(22071, 38),
(22072, 38),
(22073, 38),
(22074, 38),
(22075, 38),
(22076, 38),
(22077, 38),
(22078, 38),
(22079, 38),
(22080, 38),
(22081, 38),
(22082, 38),
(22083, 38),
(22084, 38),
(22085, 38),
(22086, 38),
(22087, 38),
(22088, 38),
(22089, 38),
(22994, 38),
(23050, 38),
(23084, 38),
(23113, 38),
(23142, 38),
(23175, 38),
(60219, 41),
(60220, 41),
(60221, 41),
(60222, 41),
(62178, 43),
(62179, 34),
(62180, 36),
(63634, 49),
(63635, 49),
(63636, 49),
(63637, 49),
(63638, 49),
(63639, 49),
(63662, 49),
(63663, 49),
(63664, 49),
(63665, 49),
(63666, 49),
(63667, 49),
(63702, 49),
(63703, 49),
(63704, 49),
(63705, 49),
(63706, 49),
(63707, 49);

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

--
-- Structure de la table `formation_practical_counter_type`
--

CREATE TABLE `formation_practical_counter_type` (
  `formation_id` int NOT NULL,
  `counter_type_value_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `formation_practical_counter_type` (`formation_id`, `counter_type_value_id`) VALUES
(219, 20),
(238, 30),
(239, 20),
(270, 45);

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

--
-- Structure de la table `formation_theoretical_counter_type`
--

CREATE TABLE `formation_theoretical_counter_type` (
  `formation_id` int NOT NULL,
  `counter_type_value_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `formation_theoretical_counter_type` (`formation_id`, `counter_type_value_id`) VALUES
(219, 6),
(231, 28),
(233, 28),
(234, 28),
(237, 6),
(238, 29),
(239, 6),
(240, 28),
(241, 28),
(242, 28),
(245, 28),
(246, 28),
(248, 28),
(308, 79),
(309, 79),
(310, 79),
(316, 79),
(318, 79),
(320, 79),
(321, 79),
(331, 6),
(332, 6),
(333, 6),
(334, 6),
(335, 6),
(336, 6),
(344, 6),
(345, 6);

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

--
-- Structure de la table `instructor_skill`
--

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

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

INSERT INTO `instructor_skill` (`id`, `name`) VALUES
(6, 'Comp. instructeur 1'),
(7, 'Comp. instructeur 2'),
(8, 'test 2'),
(10, 'Comp. instructeur 1'),
(11, 'Comp. instructeur 2'),
(14, 'Qualif instructeur n°1'),
(15, 'SEP'),
(17, 'VDN'),
(18, 'MEP'),
(19, 'TEST'),
(20, 'VDN');

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

--
-- Structure de la table `instructor_skill_ato_user`
--

CREATE TABLE `instructor_skill_ato_user` (
  `instructor_skill_id` int NOT NULL,
  `ato_user_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `instructor_skill_ato_user` (`instructor_skill_id`, `ato_user_id`) VALUES
(15, 50),
(15, 59),
(15, 76),
(15, 77),
(15, 98),
(15, 99),
(17, 59),
(17, 76),
(19, 77);

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

--
-- Structure de la table `lesson_annotation`
--

CREATE TABLE `lesson_annotation` (
  `id` int NOT NULL,
  `ato_id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `lesson_annotation_value`
--

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

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

--
-- Structure de la table `manufacturer_aircraft`
--

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

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

INSERT INTO `manufacturer_aircraft` (`id`, `name`) VALUES
(20, 'ROBIN'),
(21, 'CESSNA'),
(22, 'AIR-TRACTOR'),
(23, 'BELL'),
(24, 'CORSAIR'),
(25, 'PARAMANIA'),
(26, 'TAKEOGG'),
(27, 'COSMOS'),
(28, 'AEROPO'),
(29, 'DYNAERO'),
(30, 'ELA'),
(31, 'MAGNI'),
(32, 'CELIER'),
(33, 'TRIXY AVIATION'),
(34, 'BALLONS CHAIZE'),
(35, 'HELISPORT'),
(36, 'LAMBADA'),
(37, 'SCHEIBE'),
(38, 'STEMME'),
(39, 'LANGE ANTARES'),
(40, 'JANTAR'),
(41, 'ASW22'),
(42, 'NIMBUS'),
(43, 'ALEXANDER SCHLEICHER'),
(44, 'PIPER AIRCRAFT'),
(45, 'CIRRUS DESIGN'),
(46, 'DIAMOND'),
(47, 'MORANE-SAULNIER'),
(48, 'SOCATA'),
(49, 'FOURNIER'),
(50, 'ALPI AVIATION'),
(51, 'APEX'),
(52, 'MUDRY'),
(53, 'DYN\'AERO'),
(54, 'EXTRA AIRCRAFT'),
(55, 'CURTIS PITTS'),
(56, 'GRUMMAN AMERICA'),
(58, 'test constructeur');

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

--
-- Structure de la table `media_object`
--

CREATE TABLE `media_object` (
  `id` int NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `media_object` (`id`, `file_path`, `content_url`, `formation_id`, `lesson_id`, `original_name`, `action_id`, `extra_lesson_id`) VALUES
(260, '603bb119f079c_example (11).xlsx', '/media/603bb119f079c_example (11).xlsx', NULL, NULL, 'example (11).xlsx', NULL, NULL),
(263, '603bf19bdfe4a_Aspects financiers.docx', '/media/603bf19bdfe4a_Aspects financiers.docx', NULL, NULL, 'Aspects financiers.docx', NULL, NULL),
(264, '603bf1b3c4ed6_formation test.xlsx', '/media/603bf1b3c4ed6_formation test.xlsx', NULL, NULL, 'formation test.xlsx', NULL, NULL),
(265, '6048d145944a1_example (1).xlsx', '/media/6048d145944a1_example (1).xlsx', NULL, NULL, 'example (1).xlsx', NULL, NULL),
(266, '6048d146c270c_example.xlsx', '/media/6048d146c270c_example.xlsx', NULL, NULL, 'example.xlsx', NULL, NULL),
(268, '60511afcb1159_31-12-2020-justificatif-de-deplacement-professionnel-couvre-feu-pdf.pdf', '/media/60511afcb1159_31-12-2020-justificatif-de-deplacement-professionnel-couvre-feu-pdf.pdf', NULL, NULL, '31-12-2020-justificatif-de-deplacement-professionnel-couvre-feu-pdf.pdf', NULL, NULL),
(269, '60511b89a4ede_31-12-2020-justificatif-de-deplacement-professionnel-couvre-feu-pdf.pdf', '/media/60511b89a4ede_31-12-2020-justificatif-de-deplacement-professionnel-couvre-feu-pdf.pdf', NULL, NULL, '31-12-2020-justificatif-de-deplacement-professionnel-couvre-feu-pdf.pdf', NULL, NULL),
(270, '60511c41dade3_31-12-2020-justificatif-de-deplacement-professionnel-couvre-feu-pdf.pdf', '/media/60511c41dade3_31-12-2020-justificatif-de-deplacement-professionnel-couvre-feu-pdf.pdf', NULL, NULL, '31-12-2020-justificatif-de-deplacement-professionnel-couvre-feu-pdf.pdf', NULL, NULL),
(271, '60511cfeb0f78_31-12-2020-justificatif-de-deplacement-professionnel-couvre-feu-pdf.pdf', '/media/60511cfeb0f78_31-12-2020-justificatif-de-deplacement-professionnel-couvre-feu-pdf.pdf', NULL, NULL, '31-12-2020-justificatif-de-deplacement-professionnel-couvre-feu-pdf.pdf', NULL, NULL),
(272, '60511f5b27b72_31-12-2020-justificatif-de-deplacement-professionnel-couvre-feu-pdf.pdf', '/media/60511f5b27b72_31-12-2020-justificatif-de-deplacement-professionnel-couvre-feu-pdf.pdf', NULL, NULL, '31-12-2020-justificatif-de-deplacement-professionnel-couvre-feu-pdf.pdf', NULL, NULL),
(273, '60511f5bd4924_logo V1 noir sur fond blanc.jpg', '/media/60511f5bd4924_logo V1 noir sur fond blanc.jpg', NULL, NULL, 'logo V1 noir sur fond blanc.jpg', NULL, NULL),
(287, '609524898d801_example (4).xlsx', '/media/609524898d801_example (4).xlsx', NULL, NULL, 'example (4).xlsx', NULL, NULL),
(288, '609524b902311_example (3).xlsx', '/media/609524b902311_example (3).xlsx', NULL, NULL, 'example (3).xlsx', NULL, NULL),
(290, '609a89985c72b_activation errors.txt', '/media/609a89985c72b_activation errors.txt', NULL, NULL, 'activation errors.txt', NULL, NULL),
(292, '60c241f5472b2_Cas possibles.xlsx', '/media/60c241f5472b2_Cas possibles.xlsx', NULL, NULL, 'Cas possibles.xlsx', NULL, NULL),
(293, '60fc282c90780_Capture d’écran 2021-07-24 à 16.46.57.png', '/media/60fc282c90780_Capture d’écran 2021-07-24 à 16.46.57.png', NULL, NULL, 'Capture d’écran 2021-07-24 à 16.46.57.png', NULL, NULL),
(294, '60fc2833d2307_Capture d’écran 2021-07-24 à 16.47.07.png', '/media/60fc2833d2307_Capture d’écran 2021-07-24 à 16.47.07.png', NULL, NULL, 'Capture d’écran 2021-07-24 à 16.47.07.png', NULL, NULL),
(295, '60fc2836dbc28_Capture d’écran 2021-07-24 à 16.47.28.png', '/media/60fc2836dbc28_Capture d’écran 2021-07-24 à 16.47.28.png', NULL, NULL, 'Capture d’écran 2021-07-24 à 16.47.28.png', NULL, NULL),
(296, '60fc283a5461a_Capture d’écran 2021-07-24 à 16.47.43.png', '/media/60fc283a5461a_Capture d’écran 2021-07-24 à 16.47.43.png', NULL, NULL, 'Capture d’écran 2021-07-24 à 16.47.43.png', NULL, NULL),
(299, '613b61c57ab5b_Capture d’écran 2021-09-10 à 15.46.11.png', '/media/613b61c57ab5b_Capture d’écran 2021-09-10 à 15.46.11.png', NULL, NULL, 'Capture d’écran 2021-09-10 à 15.46.11.png', NULL, NULL),
(300, '613b61ed701bf_Capture d’écran 2021-09-10 à 15.46.47.png', '/media/613b61ed701bf_Capture d’écran 2021-09-10 à 15.46.47.png', NULL, NULL, 'Capture d’écran 2021-09-10 à 15.46.47.png', NULL, NULL),
(301, '613b620985a94_Capture d’écran 2021-09-10 à 15.47.20.png', '/media/613b620985a94_Capture d’écran 2021-09-10 à 15.47.20.png', NULL, NULL, 'Capture d’écran 2021-09-10 à 15.47.20.png', NULL, NULL),
(302, '613b6223012e9_Capture d’écran 2021-09-10 à 15.47.45.png', '/media/613b6223012e9_Capture d’écran 2021-09-10 à 15.47.45.png', NULL, NULL, 'Capture d’écran 2021-09-10 à 15.47.45.png', NULL, NULL),
(306, '613b62bedefa7_Capture d’écran 2021-09-10 à 15.47.20.png', '/media/613b62bedefa7_Capture d’écran 2021-09-10 à 15.47.20.png', NULL, NULL, 'Capture d’écran 2021-09-10 à 15.47.20.png', NULL, NULL),
(308, '613b62cdae16d_Capture d’écran 2021-09-10 à 15.47.45.png', '/media/613b62cdae16d_Capture d’écran 2021-09-10 à 15.47.45.png', NULL, NULL, 'Capture d’écran 2021-09-10 à 15.47.45.png', NULL, NULL),
(309, '613b6dda7d71b_Rapport audit.pdf', '/media/613b6dda7d71b_Rapport audit.pdf', 248, NULL, 'Rapport audit.pdf', NULL, NULL),
(311, '61432a42bbe1d_Sergio.png', '/media/61432a42bbe1d_Sergio.png', NULL, NULL, 'Sergio.png', NULL, NULL),
(312, '615c4ad38aa70_Doc1.pdf', '/media/615c4ad38aa70_Doc1.pdf', NULL, NULL, 'Doc1.pdf', NULL, NULL),
(313, '615ee27d33922_Doc1.pdf', '/media/615ee27d33922_Doc1.pdf', NULL, NULL, 'Doc1.pdf', NULL, NULL),
(314, '6161787ab7b34_Doc1.pdf', '/media/6161787ab7b34_Doc1.pdf', NULL, NULL, 'Doc1.pdf', NULL, NULL),
(315, '6161794d6dfa9_Doc1.pdf', '/media/6161794d6dfa9_Doc1.pdf', NULL, NULL, 'Doc1.pdf', NULL, NULL),
(316, '61617aa05007c_Doc1.pdf', '/media/61617aa05007c_Doc1.pdf', NULL, NULL, 'Doc1.pdf', NULL, NULL),
(317, '61617c3bb14cf_Doc1.pdf', '/media/61617c3bb14cf_Doc1.pdf', NULL, NULL, 'Doc1.pdf', NULL, NULL),
(318, '61617ca7e462c_Doc1.pdf', '/media/61617ca7e462c_Doc1.pdf', NULL, NULL, 'Doc1.pdf', NULL, NULL),
(319, '61617d2de3988_Doc1.pdf', '/media/61617d2de3988_Doc1.pdf', NULL, NULL, 'Doc1.pdf', NULL, NULL),
(320, '61617d660533b_Doc1.pdf', '/media/61617d660533b_Doc1.pdf', 251, NULL, 'Doc1.pdf', NULL, NULL),
(325, '61729fcf606c7_Capture d’écran 2021-10-22 à 13.25.56.png', '/media/61729fcf606c7_Capture d’écran 2021-10-22 à 13.25.56.png', NULL, NULL, 'Capture d’écran 2021-10-22 à 13.25.56.png', NULL, NULL),
(326, '61729fd392bb5_Capture d’écran 2021-10-22 à 13.23.50.png', '/media/61729fd392bb5_Capture d’écran 2021-10-22 à 13.23.50.png', NULL, NULL, 'Capture d’écran 2021-10-22 à 13.23.50.png', NULL, NULL),
(327, '61729fd6cf5b4_Capture d’écran 2021-10-22 à 13.24.00.png', '/media/61729fd6cf5b4_Capture d’écran 2021-10-22 à 13.24.00.png', NULL, NULL, 'Capture d’écran 2021-10-22 à 13.24.00.png', NULL, NULL),
(329, '61729fe2185cd_Capture d’écran 2021-10-22 à 13.24.13.png', '/media/61729fe2185cd_Capture d’écran 2021-10-22 à 13.24.13.png', NULL, NULL, 'Capture d’écran 2021-10-22 à 13.24.13.png', NULL, NULL),
(330, '61729fe9dcee5_Capture d’écran 2021-10-22 à 13.24.30.png', '/media/61729fe9dcee5_Capture d’écran 2021-10-22 à 13.24.30.png', NULL, NULL, 'Capture d’écran 2021-10-22 à 13.24.30.png', NULL, NULL),
(333, '6173d73ad215f_IMG_7025.pdf', '/media/6173d73ad215f_IMG_7025.pdf', 255, NULL, 'IMG_7025.pdf', NULL, NULL),
(341, '61c988174683f_Test document.pdf', '/media/61c988174683f_Test document.pdf', 268, NULL, 'Test document.pdf', NULL, NULL),
(342, '61c98817d1154_Présentation1.pptx', '/media/61c98817d1154_Présentation1.pptx', 268, NULL, 'Présentation1.pptx', NULL, NULL),
(343, '61c98818429a2_Test document.docx', '/media/61c98818429a2_Test document.docx', 268, NULL, 'Test document.docx', NULL, NULL),
(344, '61c98dcf522bf_Test document.pdf', '/media/61c98dcf522bf_Test document.pdf', 270, NULL, 'Test document.pdf', NULL, NULL),
(345, '61c98dcfdf086_Présentation1.pptx', '/media/61c98dcfdf086_Présentation1.pptx', 270, NULL, 'Présentation1.pptx', NULL, NULL),
(346, '61c98dd047a84_Test document.docx', '/media/61c98dd047a84_Test document.docx', 270, NULL, 'Test document.docx', NULL, NULL),
(355, '61e54038205f5_s-1.jpeg', '/media/61e54038205f5_s-1.jpeg', NULL, NULL, 's-1.jpeg', NULL, NULL),
(359, '61e543134ea62_1.jpg', '/media/61e543134ea62_1.jpg', NULL, NULL, '1.jpg', NULL, NULL),
(360, '61e545fa020c9_8.jpg', '/media/61e545fa020c9_8.jpg', NULL, NULL, '8.jpg', NULL, NULL),
(361, '61e54612335e9_9.jpg', '/media/61e54612335e9_9.jpg', NULL, NULL, '9.jpg', NULL, NULL),
(363, '61e5688b8a93c_7.jpg', '/media/61e5688b8a93c_7.jpg', NULL, NULL, '7.jpg', NULL, NULL),
(364, '61e5716c4afcb_téléchargement.png', '/media/61e5716c4afcb_téléchargement.png', NULL, NULL, 'téléchargement.png', NULL, NULL),
(365, '61e571920511e_téléchargement.png', '/media/61e571920511e_téléchargement.png', NULL, NULL, 'téléchargement.png', NULL, NULL),
(367, '61e5754087366_Sergio.png', '/media/61e5754087366_Sergio.png', NULL, NULL, 'Sergio.png', NULL, NULL),
(369, '61eaf4865f562_61e5684700b0b_2.jpg', '/media/61eaf4865f562_61e5684700b0b_2.jpg', NULL, NULL, '61e5684700b0b_2.jpg', NULL, NULL),
(371, '61ec194ec980f_Sergio.png', '/media/61ec194ec980f_Sergio.png', NULL, NULL, 'Sergio.png', NULL, NULL),
(372, '623ac53bd94b8_Good Pilot.pdf', '/media/623ac53bd94b8_Good Pilot.pdf', 308, NULL, 'Good Pilot.pdf', NULL, NULL),
(373, '623ace7d59dd1_Good Pilot.pdf', '/media/623ace7d59dd1_Good Pilot.pdf', 309, NULL, 'Good Pilot.pdf', NULL, NULL),
(374, '623ae69d9362b_Good Pilot VDN.pdf', '/media/623ae69d9362b_Good Pilot VDN.pdf', 310, NULL, 'Good Pilot VDN.pdf', NULL, NULL),
(375, '623af26a523bd_Good Pilot LAPL-PPL.pdf', '/media/623af26a523bd_Good Pilot LAPL-PPL.pdf', 316, NULL, 'Good Pilot LAPL-PPL.pdf', NULL, NULL),
(376, '623c2fdc8268d_PPL vers LAPL.pdf', '/media/623c2fdc8268d_PPL vers LAPL.pdf', NULL, NULL, 'PPL vers LAPL.pdf', NULL, NULL),
(377, '623c32b2334d9_PPL vers LAPL.pdf', '/media/623c32b2334d9_PPL vers LAPL.pdf', 321, NULL, 'PPL vers LAPL.pdf', NULL, NULL),
(378, '623c389e76416_CCI01092021_4.jpg', '/media/623c389e76416_CCI01092021_4.jpg', NULL, NULL, 'CCI01092021_4.jpg', NULL, NULL),
(379, '623ec3de69179_a.png', '/media/623ec3de69179_a.png', NULL, NULL, 'a.png', NULL, NULL),
(380, '623ec3ec33a4d_b.png', '/media/623ec3ec33a4d_b.png', NULL, NULL, 'b.png', NULL, NULL),
(381, '623ec3f7e95b3_c.png', '/media/623ec3f7e95b3_c.png', NULL, NULL, 'c.png', NULL, NULL),
(382, '623ec404995dc_d.png', '/media/623ec404995dc_d.png', NULL, NULL, 'd.png', NULL, NULL);

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

--
-- Structure de la 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)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `migration_versions` (`version`, `executed_at`) VALUES
('20210311165355', '2021-03-11 16:54:34'),
('20210311165759', '2021-03-11 16:58:04'),
('20210311165924', '2021-03-11 16:59:28'),
('20210311191108', '2021-03-11 19:11:13'),
('20210316201711', '2021-03-16 20:17:24'),
('20210316201928', '2021-03-16 20:19:33'),
('20210316202339', '2021-03-16 20:23:44'),
('20210316202448', '2021-03-16 20:24:51'),
('20210316203338', '2021-03-16 20:33:42'),
('20210316221850', '2021-03-16 22:18:55'),
('20210316222444', '2021-03-16 22:24:48'),
('20210317004605', '2021-03-17 00:46:10'),
('20210317010753', '2021-03-17 01:07:57'),
('20210323053241', '2021-03-23 05:32:46'),
('20210323054949', '2021-03-23 05:49:53'),
('20210323055458', '2021-03-23 05:55:01'),
('20210323060429', '2021-03-23 06:04:43'),
('20210323061353', '2021-03-23 06:13:58'),
('20210323063124', '2021-03-23 06:31:28'),
('20210323063250', '2021-03-23 06:32:53'),
('20210323064715', '2021-03-23 06:47:28'),
('20210323083257', '2021-03-23 08:33:03'),
('20210323090635', '2021-03-23 09:06:40'),
('20210323090838', '2021-03-23 09:08:59'),
('20210323091218', '2021-03-23 09:12:30'),
('20210325112716', '2021-03-25 11:27:25'),
('20210325153010', '2021-03-25 15:30:15'),
('20210406034335', '2021-04-06 03:44:15'),
('20210406093344', '2021-04-06 09:33:51'),
('20210406111208', '2021-04-06 11:12:13'),
('20210406112256', '2021-04-06 11:27:38'),
('20210406113009', '2021-04-06 11:30:27'),
('20210429225251', '2021-04-29 22:53:45'),
('20210429233706', '2021-04-29 23:37:26'),
('20210506224020', '2021-05-06 22:40:28'),
('20210511114523', '2021-05-11 11:45:41'),
('20210513031939', '2021-05-13 03:19:49'),
('20210521050535', '2021-05-21 05:05:44'),
('20210603052338', '2021-06-03 05:40:38'),
('20210603114329', '2021-06-03 11:43:40'),
('20210701234348', '2021-07-01 23:44:00'),
('20210717185723', '2021-07-17 18:58:00'),
('20210821142720', '2021-08-21 14:27:32'),
('20210829024724', '2021-08-29 02:47:33'),
('20210909005825', '2021-09-09 01:12:56'),
('20210909005826', '2021-09-09 01:28:48'),
('20210920205501', '2021-09-20 20:55:09'),
('20211008175357', '2021-10-08 17:54:10'),
('20211020225346', '2021-10-20 22:53:57'),
('20211122221545', '2021-11-22 22:15:53'),
('20211213010400', '2021-12-13 01:10:12'),
('20211226011505', '2021-12-26 01:15:12'),
('20211228153303', '2021-12-28 15:33:10'),
('20220110234031', '2022-01-10 23:40:36'),
('20220117003252', '2022-01-17 00:32:59'),
('20220130145607', '2022-01-30 14:56:15'),
('20220222124050', '2022-02-22 12:42:28'),
('20220227102628', '2022-02-27 10:26:35'),
('20220314072530', '2022-03-15 12:27:16'),
('20220322003516', '2022-03-22 00:35:23');

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

--
-- Structure de la table `model_aircraft`
--

CREATE TABLE `model_aircraft` (
  `id` int NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `model_aircraft` (`id`, `name`, `engine_type_id`, `category_id`, `manufacturer_id`) VALUES
(147, 'ATL', 4, 7, 20),
(148, ' Ambassadeur', 4, 7, 20),
(149, 'Ambassadeur', 4, 7, 20),
(150, 'Sicile', 4, 7, 20),
(151, 'Sicile-Record', 4, 7, 20),
(152, 'Excellence', 4, 7, 20),
(153, 'DR-200', 4, 7, 20),
(154, 'Capitaine', 4, 7, 20),
(155, 'B', 4, 7, 51),
(156, '2+2', 4, 7, 20),
(157, 'A 2+2', 4, 7, 20),
(158, 'AB 2+2', 4, 7, 20),
(159, 'Dauphin', 4, 7, 20),
(160, 'Régent', 4, 7, 20),
(161, 'Major', 4, 7, 20),
(162, 'Petit-Prince', 4, 7, 20),
(163, 'Chevalier', 4, 7, 20),
(164, 'Prince', 4, 7, 20),
(165, 'L\'Acrobat', 4, 7, 20),
(166, '108 2+2', 4, 7, 20),
(167, '180R Major', 4, 7, 20),
(168, '125', 4, 7, 20),
(169, '140', 4, 7, 20),
(170, 'Dauphin 2+2', 4, 7, 20),
(171, 'REMO 180', 4, 7, 20),
(172, 'REMO 200', 4, 7, 20),
(173, 'HR 100', 4, 7, 20),
(174, 'HR 200', 4, 7, 20),
(175, 'R 1180', 4, 7, 20),
(176, 'R 2112', 4, 7, 20),
(177, 'R 2160', 4, 7, 20),
(178, 'R 3000', 4, 7, 20),
(179, '200', 4, 7, 54),
(180, '200A', 4, 7, 20),
(181, '200B', 4, 7, 20),
(182, '210F Safari', 4, 7, 20),
(183, '320 Tiara', 4, 7, 20),
(184, '285 Tiara', 4, 7, 20),
(185, '235TR', 4, 7, 20),
(186, '250TR Président', 4, 7, 20),
(187, '320 4+2', 4, 7, 20),
(188, 'HR-200', 4, 7, 20),
(189, 'Aiglon', 4, 7, 20),
(190, 'T-Aiglon', 4, 7, 20),
(191, 'TD-Aiglon', 4, 7, 20),
(192, 'Club', 4, 7, 20),
(193, 'Alpha', 4, 7, 20),
(194, 'Sport', 4, 7, 20),
(195, 'Alpha Sport', 4, 7, 20),
(196, '120', 4, 7, 53),
(197, '120D', 4, 7, 20),
(198, '160', 4, 7, 20),
(199, '160S', 4, 7, 20),
(200, 'C150', 4, 7, 21),
(201, 'C150-Aerobat', 4, 7, 21),
(202, 'C152', 4, 7, 21),
(203, 'C152-Aerobat', 4, 7, 21),
(204, 'R-Skyhawk', 4, 7, 21),
(205, 'S-Skyhawk', 4, 7, 21),
(206, 'RG-Cutlass', 4, 7, 21),
(207, 'A-Cardinal', 4, 7, 21),
(208, 'B-Cardinal', 4, 7, 21),
(209, 'RG-Cardinal', 4, 7, 21),
(210, 'Skywagon', 4, 7, 21),
(211, 'C182', 4, 7, 21),
(212, 'C182A-Skylane', 4, 7, 21),
(213, 'C182C', 4, 7, 21),
(214, 'C182E-Skylane', 4, 7, 21),
(215, 'C182N-Skylane', 4, 7, 21),
(216, 'C182Q-Skylane', 4, 7, 21),
(217, 'R182-Skylane RG', 4, 7, 21),
(218, 'TR182-Turbo Skylane RG', 4, 7, 21),
(219, 'C182R', 4, 7, 21),
(220, 'T182', 4, 7, 21),
(221, '182S Skylane', 4, 7, 21),
(222, 'T182T Skylane', 4, 7, 21),
(223, 'Stationair', 4, 7, 21),
(224, 'Soloy Mk1', 5, 7, 21),
(225, 'Sloloy Mk2', 5, 7, 21),
(226, 'Centurion', 4, 7, 21),
(227, 'Corvalis TTX', 4, 7, 21),
(228, 'Caravan I', 5, 7, 21),
(229, 'Caravan 675', 5, 7, 21),
(230, 'Cargomaster', 5, 7, 21),
(231, 'Grand Caravan', 5, 7, 21),
(232, 'Super Cargomaster', 5, 7, 21),
(233, 'Caravan Amphibian', 5, 8, 21),
(234, 'Soloy PathFinder 21', 5, 7, 21),
(235, 'AT-400', 5, 7, 22),
(236, 'AT-401', 5, 7, 22),
(237, 'AT-402', 5, 7, 22),
(238, 'AT-502', 5, 7, 22),
(239, 'AT-602', 5, 7, 22),
(240, 'AT-802F', 5, 8, 22),
(241, '206L', 5, 9, 23),
(242, '206L1', 5, 9, 23),
(243, '206L3', 5, 9, 23),
(244, '206L4', 5, 9, 23),
(245, '206LT', 5, 9, 23),
(246, '407', 5, 9, 23),
(247, 'M25Y', 4, 10, 24),
(248, 'GT26', 4, 10, 25),
(249, '1200', 4, 10, 26),
(250, '582', 4, 10, 27),
(251, '503', 4, 10, 27),
(252, '447', 4, 10, 27),
(253, 'Jaribu', 4, 10, 29),
(254, '912', 4, 10, 28),
(255, '4S 912ULS', 4, 10, 29),
(256, '912S', 4, 10, 29),
(257, '07 914', 4, 10, 30),
(258, 'M16', 4, 10, 31),
(259, 'RST', 4, 10, 32),
(260, 'Rotax 914 Turbo', 4, 10, 33),
(261, 'JZ 18', 4, 10, 34),
(262, 'JZ 20', 4, 10, 34),
(263, 'JZ 22', 4, 10, 34),
(264, 'JZ 25', 4, 10, 34),
(265, 'JZ 30', 4, 10, 34),
(266, 'JZ 35', 4, 10, 34),
(267, 'JZ 40', 4, 10, 34),
(268, 'CS 1600', 4, 10, 34),
(269, 'CS 1800', 4, 10, 34),
(270, 'CS 2000', 4, 10, 34),
(271, 'CS 3000', 4, 10, 34),
(272, 'CS 4000', 4, 10, 34),
(273, 'CS 5000', 4, 10, 34),
(274, 'DC 67', 4, 10, 34),
(275, 'DC 70', 4, 10, 34),
(276, 'DC 77', 4, 10, 34),
(277, 'Kompress', 4, 10, 35),
(278, 'Lambada', 4, 11, 36),
(279, 'SF28', 4, 11, 37),
(280, 'S10', 4, 11, 38),
(281, 'S10-V', 4, 11, 38),
(282, 'S10-VT', 4, 11, 38),
(283, 'S10-15', 4, 11, 38),
(284, '20E', 4, 11, 39),
(285, 'STD 3', 6, 12, 40),
(286, 'D-6856', 6, 12, 41),
(287, '3', 6, 12, 42),
(288, 'ASK 21', 6, 12, 43),
(289, 'ASK 21 Mi', 6, 12, 43),
(290, 'ASW 12', 6, 12, 43),
(291, 'ASW 15', 6, 12, 43),
(292, 'ASW 17', 6, 12, 43),
(293, 'ASW 19', 6, 12, 43),
(294, 'Cub', 4, 7, 44),
(295, 'Cub Coupe', 4, 7, 44),
(296, 'Cub Cruiser', 4, 7, 44),
(297, 'Cub Special', 4, 7, 44),
(298, 'Cuper Cruiser', 4, 7, 44),
(299, 'Family Cruiser', 4, 7, 44),
(300, 'Super Cub', 4, 7, 44),
(301, 'Pacer', 4, 7, 44),
(302, 'PA21', 4, 7, 44),
(303, 'Apache', 4, 7, 44),
(304, 'Aztec', 4, 7, 44),
(305, 'Comanche', 4, 7, 44),
(306, 'Pawnee', 4, 7, 44),
(307, 'Cherokee', 4, 7, 44),
(308, 'Warrior', 4, 7, 44),
(309, 'Archer', 4, 7, 44),
(310, 'Dakota', 4, 7, 44),
(311, 'Arrow', 4, 7, 44),
(312, 'Twin Comanche', 4, 7, 44),
(313, 'Chieftain', 4, 7, 44),
(314, 'Mojave', 4, 7, 44),
(315, 'Navajo', 4, 7, 44),
(316, 'Cheyenne', 4, 7, 44),
(317, 'Cherokee Six', 4, 7, 44),
(318, 'Lance', 4, 7, 44),
(319, 'Saratoga', 4, 7, 44),
(320, 'Seneca', 4, 7, 44),
(321, 'Pawnee Brave', 4, 7, 44),
(322, 'Tomahawk', 4, 7, 44),
(323, 'Seminole', 4, 7, 44),
(324, 'Malibu', 4, 7, 44),
(325, 'Mirage', 4, 7, 44),
(326, 'Meridian', 4, 7, 44),
(327, 'Matrix', 4, 7, 44),
(328, 'Piper Jet', 4, 7, 44),
(329, 'VK-30', 4, 7, 45),
(330, 'SRV', 4, 7, 45),
(331, 'SR22', 4, 7, 45),
(332, 'SR22 T', 4, 7, 45),
(333, 'SF50', 4, 7, 45),
(334, 'Katana', 4, 7, 46),
(335, 'Star 180', 4, 7, 46),
(336, 'Star TDI', 4, 7, 46),
(337, 'DA 40-F', 4, 7, 46),
(338, 'TDI Twin Star', 4, 7, 46),
(339, '360 Twin Star', 4, 7, 46),
(340, 'VI', 4, 7, 46),
(341, 'MPP', 4, 7, 46),
(342, 'Opale', 4, 7, 46),
(343, 'Super Star', 4, 7, 46),
(344, 'Magnum', 4, 7, 46),
(345, 'D-JET', 4, 7, 46),
(346, 'MS 880', 4, 7, 47),
(347, 'MS 881', 4, 7, 47),
(348, 'MS 883', 4, 7, 47),
(349, 'MS 885', 4, 7, 47),
(350, 'MS 886', 4, 7, 47),
(351, 'MS 890', 4, 7, 47),
(352, 'MS 892', 4, 7, 47),
(353, 'MS 893', 4, 7, 47),
(354, 'MS 894 Minerva', 4, 7, 47),
(355, 'MS 110 Galopin', 4, 7, 47),
(356, 'GY-80', 4, 7, 48),
(357, 'Diplomate', 4, 7, 48),
(358, 'Tampico', 4, 7, 48),
(359, 'Tobago', 4, 7, 48),
(360, 'Tobago XL', 4, 7, 48),
(361, 'Trinidad', 4, 7, 48),
(362, 'TC Trinidad', 4, 7, 48),
(363, 'Epsilon', 4, 7, 48),
(364, 'TBM 700', 4, 7, 48),
(365, 'TBM 850', 4, 7, 48),
(366, 'TBM 900', 4, 7, 48),
(367, 'RF-2', 4, 11, 49),
(368, 'RF-3', 4, 11, 49),
(369, 'RF4', 4, 11, 49),
(370, 'RF-5', 4, 11, 49),
(371, 'RF-6', 4, 7, 49),
(372, 'RF-7', 4, 7, 49),
(373, 'RF-8', 4, 11, 49),
(374, 'RF-10', 4, 11, 49),
(375, 'RF-47', 4, 7, 49),
(376, '200S Sparrow', 4, 10, 50),
(377, '200 SDT', 4, 10, 50),
(378, '230', 4, 10, 50),
(379, 'Kite ULM', 4, 10, 50),
(380, 'Kite LSA', 4, 7, 50),
(381, 'Hawk', 4, 10, 50),
(382, '400', 4, 7, 50),
(383, 'AH 130', 4, 10, 50),
(384, 'C', 4, 7, 51),
(385, 'CAP 20', 4, 7, 52),
(386, 'CAP 20 L', 4, 7, 52),
(387, 'CAP 21', 4, 7, 52),
(388, 'CAP 230', 4, 7, 52),
(389, 'CAP 231', 4, 7, 52),
(390, 'EX', 4, 7, 52),
(391, 'CAP 232', 4, 7, 52),
(392, 'SC', 4, 7, 52),
(393, 'MXS', 4, 7, 52),
(394, '100', 4, 7, 53),
(395, '100 T', 4, 7, 53),
(396, '110', 4, 7, 53),
(397, '300', 4, 7, 54),
(398, '300S', 4, 7, 54),
(399, '300L', 4, 7, 54),
(400, '300LP', 4, 7, 54),
(401, '330', 4, 7, 54),
(402, '330LC', 4, 7, 54),
(403, '330SC', 4, 7, 54),
(404, 'S1', 4, 7, 55),
(405, 'S-1C', 4, 7, 55),
(406, 'S-1D', 4, 7, 55),
(407, 'S-1E', 4, 7, 55),
(408, 'S-1F', 4, 7, 55),
(409, 'S-1S', 4, 7, 55),
(410, 'S-1T', 4, 7, 55),
(411, 'S-1-11B', 4, 7, 55),
(412, 'S-2A', 4, 7, 55),
(413, 'S-2B', 4, 7, 55),
(414, 'S-2C', 4, 7, 55),
(415, 'S-2E', 4, 7, 55),
(416, 'S-2S', 4, 7, 55),
(417, 'AA-5', 4, 7, 56),
(418, 'AA-5A', 4, 7, 56),
(419, 'AA-5B', 4, 7, 56),
(420, 'AG-5B', 4, 7, 56),
(421, 'Test avion crée', 8, 13, 58);

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

--
-- Structure de la table `notification`
--

CREATE TABLE `notification` (
  `id` int NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `notification` (`id`, `user_id`, `content`, `is_read`, `created_at`) VALUES
(2, '2be64b2c-1cdc-45cf-a43e-b095857384de', '__test-test: Séances L2 à signer', 0, '2022-01-13 09:45:43'),
(3, 'bb7b6793-9688-11eb-a36d-089798b0d1ad', '__test-test: Séances Leçon 1 à signer', 0, '2022-01-16 10:53:04'),
(4, 'bb7b6793-9688-11eb-a36d-089798b0d1ad', '__test-test: Séances L1 à signer', 0, '2022-01-17 00:38:16'),
(5, '2be64b2c-1cdc-45cf-a43e-b095857384de', '__test-test: Séances L1 à signer', 0, '2022-01-17 08:52:37'),
(8, '2be64b2c-1cdc-45cf-a43e-b095857384de', '__test-test: Séances L2 à signer', 0, '2022-01-18 14:12:32'),
(9, '2be64b2c-1cdc-45cf-a43e-b095857384de', '__test-test: Séances L3 à signer', 0, '2022-01-18 14:42:56'),
(10, '2be64b2c-1cdc-45cf-a43e-b095857384de', '__test-test: Séances C1 à signer', 0, '2022-01-18 15:03:49'),
(11, '2be64b2c-1cdc-45cf-a43e-b095857384de', '__test-test: Séances C2 à signer', 0, '2022-01-18 15:27:54'),
(12, '2be64b2c-1cdc-45cf-a43e-b095857384de', '__test-test: Séances Approche du décrochage en virage et à une hauteur de sécurité déterminée à signer', 0, '2022-01-18 16:23:59'),
(13, '2be64b2c-1cdc-45cf-a43e-b095857384de', '__test-test: Séances Intégration sur aérodrome non controlé  🤦‍♂️ à signer', 0, '2022-01-18 16:39:01'),
(14, '2be64b2c-1cdc-45cf-a43e-b095857384de', '__test-test: Séances L4 à signer', 0, '2022-01-21 19:06:27'),
(15, '2be64b2c-1cdc-45cf-a43e-b095857384de', '__test-test: Séances L4 à signer', 0, '2022-01-21 19:06:46'),
(16, '2be64b2c-1cdc-45cf-a43e-b095857384de', '__test-test: Séances L1 à signer', 0, '2022-01-21 19:15:48'),
(19, '2be64b2c-1cdc-45cf-a43e-b095857384de', '__test-test: Séances L4 à signer', 0, '2022-01-22 08:50:22'),
(21, '2be64b2c-1cdc-45cf-a43e-b095857384de', '__test-test: Séances Approche du décrochage en virage et à une hauteur de sécurité déterminée à signer', 0, '2022-01-22 13:56:14'),
(22, '2be64b2c-1cdc-45cf-a43e-b095857384de', '__test-test: Séance L2 à signer', 0, '2022-01-31 15:17:05'),
(23, 'bb7b6793-9688-11eb-a36d-089798b0d1ad', '__test-test: Séance L1 à signer', 0, '2022-02-02 05:23:29'),
(24, '2be64b2c-1cdc-45cf-a43e-b095857384de', '__test-test: Séance L1 à signer', 0, '2022-02-02 09:41:21'),
(25, '2be64b2c-1cdc-45cf-a43e-b095857384de', '__test-test: Séance Fev1 à signer', 0, '2022-02-02 10:03:44'),
(40, '2be64b2c-1cdc-45cf-a43e-b095857384de', '__test-test: Séance Prat1 à signer', 0, '2022-02-08 11:31:06'),
(41, '2be64b2c-1cdc-45cf-a43e-b095857384de', '__test-test: Séance Fev1 à signer', 0, '2022-02-08 11:32:27'),
(44, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'test-test: Séance S1 à signer', 0, '2022-02-24 10:31:47'),
(45, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'test-test: Séance L1 à signer', 0, '2022-02-24 10:31:59'),
(46, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'test-test: Séance L4 à signer', 0, '2022-02-24 10:32:09'),
(76, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'test-test: Séance L1 à signer', 0, '2022-03-04 11:06:04'),
(77, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'test-test: Séance L3 à signer', 0, '2022-03-04 14:09:33'),
(78, '58061cac-119e-11ec-acae-d60414d71c23', 'test-test: Séance Leçon 1 à signer', 0, '2022-03-11 09:55:01'),
(79, '58061cac-119e-11ec-acae-d60414d71c23', 'test-test: Séance Leçon 2 à signer', 0, '2022-03-11 10:14:50'),
(80, '58061cac-119e-11ec-acae-d60414d71c23', 'test-test: Séance Leçon 1 à signer', 0, '2022-03-11 10:20:36'),
(81, '58061cac-119e-11ec-acae-d60414d71c23', 'test-test: Séance Leçon 2 à signer', 0, '2022-03-11 10:21:49'),
(82, '58061cac-119e-11ec-acae-d60414d71c23', 'test-test: Séance Leçon 3 à signer', 0, '2022-03-11 10:24:31'),
(83, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance Leçon 1 à signer', 0, '2022-03-21 13:14:55'),
(84, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance 1 à signer', 0, '2022-03-21 13:56:39'),
(89, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance S1 à signer', 0, '2022-03-23 09:24:42'),
(90, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance S2 à signer', 0, '2022-03-23 09:30:29'),
(91, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance S1 à signer', 0, '2022-03-23 09:43:59'),
(92, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance S2 à signer', 0, '2022-03-23 09:46:05'),
(93, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance S1 à signer', 0, '2022-03-23 09:55:01'),
(94, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance S2 à signer', 0, '2022-03-23 09:58:29'),
(95, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance S1 à signer', 0, '2022-03-23 10:11:02'),
(96, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance 1 à signer', 0, '2022-03-23 10:14:37'),
(97, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance  à signer', 0, '2022-03-23 10:37:18'),
(98, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance S1 à signer', 0, '2022-03-23 10:43:56'),
(99, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance S2 à signer', 0, '2022-03-23 10:45:15'),
(100, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance S1 à signer', 0, '2022-03-24 09:38:01'),
(103, '4e2e40d5-119e-11ec-acae-d60414d71c23', 'ZZZZ-Base test mars 2022: Séance S1 à signer', 0, '2022-03-24 10:06:00'),
(104, '4e2e40d5-119e-11ec-acae-d60414d71c23', 'ZZZZ-Base test mars 2022: Séance S2 à signer', 0, '2022-03-24 10:12:39'),
(105, '4e2e40d5-119e-11ec-acae-d60414d71c23', 'ZZZZ-Base test mars 2022: Séance  à signer', 0, '2022-03-24 16:14:04'),
(106, '4e2e40d5-119e-11ec-acae-d60414d71c23', 'ZZZZ-Base test mars 2022: Séance  à signer', 0, '2022-03-24 16:20:31'),
(107, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance S1 à signer', 0, '2022-03-25 09:18:39'),
(108, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance  à signer', 0, '2022-03-25 09:20:38'),
(109, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance  à signer', 0, '2022-03-25 09:28:16'),
(110, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance L1 à signer', 0, '2022-03-25 10:06:36'),
(111, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance L2 à signer', 0, '2022-03-25 10:31:57'),
(112, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance L1 à signer', 0, '2022-03-25 10:42:05'),
(113, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance T2 à signer', 0, '2022-03-25 10:50:52'),
(114, '4e2e40d5-119e-11ec-acae-d60414d71c23', 'ZZZZ-Base test mars 2022: Séance T1 à signer', 0, '2022-03-25 11:01:15'),
(115, '4e2e40d5-119e-11ec-acae-d60414d71c23', 'ZZZZ-Base test mars 2022: Séance T1 à signer', 0, '2022-03-25 12:33:16'),
(116, '4e2e40d5-119e-11ec-acae-d60414d71c23', 'ZZZZ-Base test mars 2022: Séance S4 à signer', 0, '2022-03-28 09:02:00'),
(117, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance S1 à signer', 0, '2022-03-28 12:53:34'),
(118, '4e2e40d5-119e-11ec-acae-d60414d71c23', 'ZZZZ-Base test mars 2022: Séance T1 à signer', 0, '2022-03-28 12:54:12'),
(119, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance T1 à signer', 0, '2022-03-28 12:56:17'),
(120, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance T1 à signer', 0, '2022-03-28 12:59:11'),
(121, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance T2 à signer', 0, '2022-03-28 13:00:26'),
(122, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance T2 à signer', 0, '2022-03-28 13:00:37'),
(123, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance T2 à signer', 0, '2022-03-28 13:01:04'),
(124, '4e2e40d5-119e-11ec-acae-d60414d71c23', 'ZZZZ-Base test mars 2022: Séance S1 à signer', 0, '2022-03-28 13:24:27'),
(125, '4e2e40d5-119e-11ec-acae-d60414d71c23', 'ZZZZ-Base test mars 2022: Séance S2 extraaaaaaaaaaa à signer', 0, '2022-03-28 13:28:11'),
(126, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance VERIF1 à signer', 0, '2022-03-28 13:37:06'),
(127, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance VERIF2 à signer', 0, '2022-03-28 13:38:31'),
(128, '4e2e40d5-119e-11ec-acae-d60414d71c23', 'ZZZZ-Base test mars 2022: Séance S1 à signer', 0, '2022-03-28 13:57:08'),
(129, '4e2e40d5-119e-11ec-acae-d60414d71c23', 'ZZZZ-Base test mars 2022: Séance S2 à signer', 0, '2022-03-28 14:13:01'),
(130, '4e2e40d5-119e-11ec-acae-d60414d71c23', 'ZZZZ-Base test mars 2022: Séance S1 à signer', 0, '2022-03-28 16:43:51'),
(131, '4e2e40d5-119e-11ec-acae-d60414d71c23', 'ZZZZ-Base test mars 2022: Séance S2 à signer', 0, '2022-03-28 16:50:04'),
(132, '4e2e40d5-119e-11ec-acae-d60414d71c23', 'ZZZZ-Base test mars 2022: Séance S3 à signer', 0, '2022-03-28 17:09:20'),
(133, '4e2e40d5-119e-11ec-acae-d60414d71c23', 'ZZZZ-Base test mars 2022: Séance S4 à signer', 0, '2022-03-28 17:19:53'),
(134, '4e2e40d5-119e-11ec-acae-d60414d71c23', 'ZZZZ-Base test mars 2022: Séance S5 à signer', 0, '2022-03-28 17:33:20'),
(135, '4e2e40d5-119e-11ec-acae-d60414d71c23', 'ZZZZ-Base test mars 2022: Séance Extra au-delà de la dernière à signer', 0, '2022-03-28 17:38:27'),
(136, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance SA à signer', 0, '2022-03-29 07:15:09'),
(137, '2be64b2c-1cdc-45cf-a43e-b095857384de', 'ZZZZ-Base test mars 2022: Séance SB à signer', 0, '2022-03-29 07:30:02');

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

--
-- Structure de la table `postal_address`
--

CREATE TABLE `postal_address` (
  `id` int NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `postal_address` (`id`, `number`, `street`, `city`, `zipcode`, `country`) VALUES
(28, '79', '79', 'Pourcieux', '83470', 'France'),
(29, '56', 'chemin des Amandiers', 'Pourcieux', '83470', 'France'),
(30, '79', '79', 'Pourcieux', '83470', 'France'),
(49, '79', 'chemin des Amandiers', 'Pourcieux', '83470', 'France'),
(71, '79', 'Chemin des Amandiers', 'Pourcieux', '83470', 'France'),
(73, '', '', 'AEROPORT', '00000', 'FRANCE'),
(74, '7', 'rue du Poncelet', 'FESMY LE SART', '02450', 'FRANCE'),
(75, '7', 'rue du Poncelet', 'FESMY LE SART', '02450', 'FRANCE'),
(76, '7', 'rue du Poncelet', 'FESMY LE SART', '02450', 'FRANCE'),
(77, '', '', 'Paris', '9999', 'France');

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

--
-- Structure de la table `promotion`
--

CREATE TABLE `promotion` (
  `id` int NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `promotion` (`id`, `name`, `ato_id`, `created_at`, `status`) VALUES
(13, 'A1.TEO.27', 603, '2021-12-22 12:01:12', 'active'),
(14, '01JAN2022', 603, '2022-01-06 15:38:09', 'active');

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

--
-- Structure de la table `promotion_ato_user`
--

CREATE TABLE `promotion_ato_user` (
  `promotion_id` int NOT NULL,
  `ato_user_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `promotion_ato_user` (`promotion_id`, `ato_user_id`) VALUES
(13, 100),
(13, 101),
(14, 100),
(14, 101);

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

--
-- Structure de la table `promotion_formation`
--

CREATE TABLE `promotion_formation` (
  `id` int NOT NULL,
  `formation_id` int NOT NULL,
  `promotion_id` int NOT NULL,
  `status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Structure de la table `rating`
--

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

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

INSERT INTO `rating` (`id`, `name`) VALUES
(49, 'test 2'),
(51, 'test 3'),
(54, 'test'),
(56, 'test 55'),
(57, 'TP'),
(58, '123'),
(59, 'TP - Briefing'),
(60, 'TP - Vol'),
(61, 'TP (oui/non)'),
(62, 'Progression bilan'),
(63, 'Non effectué / Effectué (TP/JPO)'),
(64, 'ANPI leçons'),
(65, 'ANPI contrôle'),
(66, 'CNT (NA-I-S-P)'),
(71, 'Smiley'),
(72, 'A1.TEO.27'),
(74, '+/-/NR'),
(75, '++ -- NR'),
(76, '- / + / ++'),
(77, 'NR / - / + / ++'),
(78, 'Sans note'),
(79, 'TB/B/P/NR'),
(81, 'Notation Briefing NE/Vu'),
(82, 'Notation exercices en vol'),
(83, 'Bilan fin de phase oui/non'),
(84, 'Bilan fin de phase séance'),
(85, 'Smileys');

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

--
-- Structure de la table `rating_ato`
--

CREATE TABLE `rating_ato` (
  `rating_id` int NOT NULL,
  `ato_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `rating_ato` (`rating_id`, `ato_id`) VALUES
(57, 603),
(58, 603),
(59, 603),
(60, 603),
(61, 603),
(62, 603),
(63, 603),
(64, 603),
(65, 603),
(66, 603),
(71, 603),
(72, 603),
(74, 603),
(75, 603),
(76, 626),
(77, 626),
(78, 626),
(79, 626),
(81, 627),
(82, 627),
(83, 627),
(84, 627),
(85, 626);

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

--
-- Structure de la table `rating_value`
--

CREATE TABLE `rating_value` (
  `id` int NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `rating_value` (`id`, `rating_type_id`, `value`, `validate_exercise`, `position`, `media_value_id`, `color`, `description`, `exercise_notperformed`) VALUES
(157, 49, 'a', 1, 0, NULL, '#000000', NULL, 0),
(158, 49, 'b', 0, 1, NULL, '#000000', NULL, 0),
(162, 51, 'a', 1, 0, NULL, '#000000', NULL, 0),
(163, 51, 'b', 1, 1, NULL, '#000000', NULL, 0),
(164, 51, 'c', 1, 2, NULL, '#000000', NULL, 0),
(176, 54, 'a', 1, 0, NULL, '#000000', '', 0),
(177, 54, 'c', 0, 1, NULL, '#000000', '', 0),
(183, 56, 'a', 1, 0, NULL, '#000000', '', 0),
(184, 56, 'a', 0, 1, NULL, '#000000', '', 1),
(205, 59, 'NE', 0, 0, NULL, '#000000', '', 1),
(206, 59, 'Vu', 1, 1, NULL, '#000000', '', 0),
(211, 60, 'NE', 0, 0, NULL, '#000000', 'Non effectué', 1),
(212, 60, 'Vu', 1, 1, NULL, '#000000', '', 0),
(213, 60, 'Guidé', 1, 2, NULL, '#000000', '', 0),
(214, 60, 'Autonome', 1, 3, NULL, '#000000', '', 0),
(215, 57, 'NE', 0, 0, NULL, '#000000', '', 1),
(216, 57, 'Vu', 1, 1, NULL, '#000000', '', 0),
(217, 57, 'Guidé', 1, 2, NULL, '#000000', '', 0),
(218, 57, 'Autonome', 1, 3, NULL, '#000000', '', 0),
(227, 61, 'Oui', 1, 0, NULL, '#000000', '', 0),
(228, 61, 'Non', 0, 1, NULL, '#000000', '', 0),
(229, 62, 'Sous le standard', 1, 0, 293, '#f3afaf', '', 0),
(230, 62, 'Besoin d\'amélioration', 1, 1, 294, '#aaf7fd', '', 0),
(231, 62, 'Standard', 1, 2, 295, '#c2fdba', '', 0),
(232, 62, 'Au-dessus du standard', 1, 3, 296, '#37ba08', '', 0),
(233, 63, 'Non effectué', 0, 0, NULL, '#000000', '', 1),
(234, 63, 'Effectué', 1, 1, NULL, '#000000', '', 0),
(238, 65, 'I', 0, 0, NULL, '#000000', '', 1),
(239, 65, 'S', 1, 1, NULL, '#000000', '', 0),
(240, 65, 'P', 1, 2, NULL, '#000000', '', 0),
(241, 65, 'NA', 0, 3, NULL, '#000000', '', 1),
(248, 66, 'NA', 0, 0, NULL, '#000000', '', 0),
(249, 66, 'I', 1, 1, NULL, '#000000', '', 0),
(250, 66, 'S', 1, 2, NULL, '#000000', '', 0),
(251, 66, 'P', 1, 3, NULL, '#000000', '', 0),
(252, 64, 'E', 1, 0, NULL, '#000000', '', 0),
(253, 64, 'S', 1, 1, NULL, '#000000', '', 0),
(260, 58, '0', 0, 0, NULL, '#f64646', 'NR', 1),
(261, 58, '1', 0, 1, NULL, '#fd7c7c', 'Pas bien', 0),
(262, 58, '2', 0, 2, NULL, '#f7b0b0', 'Moins bien', 0),
(263, 58, '3', 1, 3, NULL, '#c8fbac', 'Dans la moyenne', 0),
(264, 58, '4', 1, 4, NULL, '#9bf769', 'Bien', 0),
(265, 58, '5', 1, 5, NULL, '#22fb13', 'Très bien', 0),
(319, 71, '', 0, 0, 325, '#000000', '', 1),
(320, 71, '', 0, 1, 326, '#000000', '', 0),
(321, 71, '', 0, 2, 327, '#000000', '', 0),
(322, 71, '', 1, 3, 329, '#000000', '', 0),
(323, 71, '', 1, 4, 330, '#000000', '', 0),
(328, 72, 'Oui', 1, 0, NULL, '#000000', 'Très bien', 0),
(329, 72, 'Oui', 0, 1, NULL, '#000000', 'Très bien', 1),
(332, 74, '+', 1, 0, NULL, '#000000', '', 0),
(333, 74, '-', 0, 1, NULL, '#000000', '', 1),
(334, 74, 'NR', 0, 2, NULL, '#000000', '', 1),
(341, 75, '++', 1, 0, NULL, '#19bf0d', 'Exercice validé', 0),
(342, 75, '- -', 0, 1, NULL, '#ff9500', 'Exercice sera reporté ', 0),
(343, 75, 'NR', 0, 2, NULL, '#0676bc', 'Exercice non réalisé', 1),
(344, 76, '-', 0, 0, NULL, '#ff7300', 'A parfaire', 0),
(345, 76, '+', 1, 1, NULL, '#0954ec', 'Bonne restitution', 0),
(346, 76, '++', 1, 2, NULL, '#7ad123', 'Très bonne restitution', 0),
(385, 78, '', 1, 0, NULL, '#000000', '', 0),
(386, 78, '', 1, 1, NULL, '#000000', '', 0),
(391, 77, 'NR', 0, 0, NULL, '#000000', 'Non réalisé', 1),
(392, 77, '-', 0, 1, NULL, '#fa9e00', 'A parfaire', 0),
(393, 77, '+', 1, 2, NULL, '#0fdb00', 'Restitution dans la moyenne', 0),
(394, 77, '++', 1, 3, NULL, '#0537ff', 'Très bonne restitution', 0),
(395, 79, 'Très bien', 1, 0, NULL, '#000000', '', 0),
(396, 79, 'Bien', 1, 1, NULL, '#000000', '', 0),
(397, 79, 'A parfaire', 0, 2, NULL, '#000000', '', 0),
(398, 79, 'NR', 0, 3, NULL, '#000000', '', 1),
(401, 81, 'NE', 0, 0, NULL, '#fca103', 'Non effectué', 1),
(402, 81, 'Vu', 1, 1, NULL, '#04cd1c', 'Vu', 0),
(403, 82, 'NE', 1, 0, NULL, '#fca103', 'L’exercice n’a pas été effectué.', 0),
(404, 82, 'Vu', 1, 1, NULL, '#04cd1c', 'L’exercice a été expliqué et démontré.', 0),
(405, 82, 'Guidé', 1, 2, NULL, '#515ad6', 'L’exercice est restitué mais il nécessite un guidage de la part de l\'instructeur. Le stagiaire n\'a pas atteint une performance acceptable.', 0),
(406, 82, 'Autonome', 1, 3, NULL, '#0189b7', 'L’exercice est exécuté en sécurité avec des erreurs mineures mais pas d\'écart majeur par rapport à l\'idéal. Le pilote démontre une aptitude technique.', 0),
(407, 83, 'Oui', 1, 0, NULL, '#04cd1c', '', 0),
(408, 83, 'Non', 0, 1, NULL, '#f53d3d', '', 1),
(413, 84, 'Sous le standard', 0, 0, NULL, '#f53d3d', '', 0),
(414, 84, 'Besoin d\'amélioration', 0, 1, NULL, '#fca103', '', 0),
(415, 84, 'Standard', 1, 2, NULL, '#04cd1c', '', 0),
(416, 84, 'Au dessus du standard', 1, 3, NULL, '#515ad6', '', 0),
(417, 85, '', 1, 0, 379, '#000000', 'Très bien', 0),
(418, 85, '', 1, 1, 380, '#000000', 'Bien', 0),
(419, 85, '', 1, 2, 381, '#000000', 'Dans la moyenne', 0),
(420, 85, '', 0, 3, 382, '#000000', 'A parfaire', 1);

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

--
-- Structure de la table `resources`
--

CREATE TABLE `resources` (
  `id` int NOT NULL,
  `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 NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `resources` (`id`, `name`, `type`, `ato_id`) VALUES
(915, 'F-HFEN', 'resource_aircraft', 603),
(920, 'Salle 1b', 'resource_classroom', 626),
(923, 'F-TUCH', 'resource_aircraft', 626),
(924, 'F-PALF', 'resource_aircraft', 627);

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

--
-- Structure de la table `session`
--

CREATE TABLE `session` (
  `id` int NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `session` (`id`, `instructor_id`, `start_at`, `end_at`, `comments`, `is_theoretical`, `formation_id`, `lesson_id`, `lesson_notation_id`, `bloc_time`, `flight_time`, `lesson_extra_id`, `instructor_signature_id`, `success`, `status`, `pdf_file_id`, `validate_at`, `correction_id`, `departure_airport_id`, `arrival_airport_id`, `aircraft_id`) VALUES
(118, 121, '2022-03-21 14:10:00', '2022-03-21 14:14:00', '', 0, 292, 62276, NULL, 4, 0, NULL, 90, 0, 'validated', NULL, '2022-03-21 13:21:43', NULL, NULL, NULL, NULL),
(119, 121, '2022-03-21 14:35:00', '2022-03-21 14:56:00', '', 0, 300, 62311, NULL, 21, 0, NULL, 92, 0, 'validated', NULL, '2022-03-21 13:56:56', NULL, 2, 2, 923),
(120, 125, '2022-03-21 14:49:00', '2022-03-21 14:56:00', '', 0, 292, 62277, NULL, 7, 0, NULL, 94, 1, 'validated', NULL, '2022-03-21 14:12:55', NULL, NULL, NULL, 923),
(121, 50, '2022-03-21 14:49:00', '2022-03-21 14:59:00', '', 0, 251, 22994, NULL, 10, 0, NULL, 95, 1, 'validated', NULL, '2022-03-21 14:00:19', NULL, NULL, NULL, 915),
(122, 121, '2022-03-21 15:11:00', '2022-03-21 15:13:00', '', 0, 302, 62323, NULL, 2, 0, NULL, 98, 0, 'validated', NULL, '2022-03-21 14:16:38', NULL, 1, 1, 923),
(123, 121, '2022-03-21 15:15:00', '2022-03-21 15:16:00', '', 0, 302, 62324, NULL, 1, 0, NULL, 100, 0, 'validated', NULL, '2022-03-21 14:17:24', NULL, NULL, NULL, 923),
(124, 121, '2022-03-22 10:49:00', '2022-03-22 10:53:00', '', 0, 307, 62350, NULL, 4, 0, NULL, 102, 0, 'validated', NULL, '2022-03-22 09:54:50', NULL, 2, 2, 923),
(125, 121, '2022-03-22 10:49:00', '2022-03-22 10:55:00', '', 0, 307, 62351, NULL, 6, 0, NULL, 104, 1, 'validated', NULL, '2022-03-22 09:56:58', NULL, 2, 1, 923),
(127, 121, '2022-03-23 08:10:00', '2022-03-23 10:24:00', '', 0, 311, 62392, NULL, 134, 0, NULL, 106, 1, 'validated', NULL, '2022-03-23 09:25:20', NULL, 1, 1, 923),
(128, 121, '2022-03-23 08:10:00', '2022-03-23 10:30:00', '', 0, 311, 62393, NULL, 140, 0, NULL, 108, 1, 'validated', NULL, '2022-03-23 09:30:46', NULL, 1, 1, 923),
(129, 121, '2022-03-23 10:32:00', '2022-03-23 10:43:00', '', 0, 312, 62398, NULL, 11, 0, NULL, 110, 1, 'validated', NULL, '2022-03-23 09:44:10', NULL, 1, 3, 923),
(130, 121, '2022-03-23 10:32:00', '2022-03-23 10:45:00', '', 0, 312, 62399, NULL, 13, 0, NULL, 112, 1, 'validated', NULL, '2022-03-23 09:46:22', NULL, 2, 2, 923),
(131, 121, '2022-03-23 10:32:00', '2022-03-23 10:54:00', '', 0, 315, 62416, NULL, 22, 0, NULL, 114, 1, 'validated', NULL, '2022-03-23 09:55:14', NULL, 2, 2, 923),
(132, 121, '2022-03-23 10:32:00', '2022-03-23 10:58:00', '', 0, 315, 62417, NULL, 26, 0, NULL, 116, 0, 'validated', NULL, '2022-03-23 10:08:29', NULL, 4, 3, 923),
(133, 121, '2022-03-23 10:32:00', '2022-03-23 11:10:00', '', 0, 315, NULL, NULL, 38, 0, 2, 118, 0, 'validated', NULL, '2022-03-23 10:33:16', NULL, 1, 1, 923),
(134, 121, '2022-03-23 10:32:00', '2022-03-23 11:14:00', '', 0, 300, NULL, NULL, 42, 0, 3, 119, 0, 'validated', NULL, '2022-03-23 10:15:35', NULL, 1, 2, 923),
(135, 121, '2022-03-23 10:32:00', '2022-03-23 11:35:00', '', 0, 315, NULL, NULL, 63, 0, 4, 122, 1, 'validated', NULL, '2022-03-23 10:38:52', NULL, 2, 1, 923),
(137, 121, '2022-03-23 11:35:00', '2022-03-23 11:43:00', '', 0, 317, 62422, NULL, 8, 0, NULL, 124, 0, 'validated', NULL, '2022-03-23 10:44:07', NULL, 1, 2, 923),
(138, 121, '2022-02-01 12:35:00', '2022-02-01 13:44:00', '', 0, 317, 62423, NULL, 69, 0, NULL, 126, 1, 'toSign', NULL, NULL, NULL, 1, 1, 923),
(139, 121, '2022-03-24 10:04:00', '2022-03-24 10:37:00', '', 0, 326, 63443, NULL, 33, 0, NULL, 127, 1, 'validated', NULL, '2022-03-24 09:40:50', NULL, 2, 8, 923),
(140, 123, '2022-03-24 10:37:00', '2022-03-24 10:51:00', '', 0, 326, 63443, NULL, 14, 0, NULL, 129, 1, 'validated', NULL, '2022-03-24 09:53:40', NULL, 1, 1, 923),
(141, 123, '2022-03-24 10:37:00', '2022-03-24 10:54:00', '', 0, 326, 63444, NULL, 17, 0, NULL, 131, 0, 'validated', NULL, '2022-03-24 09:54:46', NULL, 1, 1, 923),
(142, 123, '2022-03-24 10:37:00', '2022-03-24 11:05:00', '', 0, 327, 63449, NULL, 28, 0, NULL, 133, 0, 'validated', NULL, '2022-03-24 10:06:53', NULL, 8, 8, 923),
(143, 123, '2022-03-24 10:37:00', '2022-03-24 11:12:00', '', 0, 327, 63450, NULL, 35, 0, NULL, 135, 0, 'validated', NULL, '2022-03-24 10:13:36', NULL, 4, 5, 923),
(144, 123, '2022-03-24 16:58:00', '2022-03-24 17:11:00', '', 0, 327, NULL, NULL, 13, 0, 11, 137, 0, 'validated', NULL, '2022-03-24 16:14:31', NULL, 6, 6, 923),
(145, 123, '2022-03-24 16:58:00', '2022-03-24 17:20:00', '', 0, 327, NULL, NULL, 22, 0, 12, 139, 1, 'validated', NULL, '2022-03-24 16:20:44', NULL, 6, 6, 923),
(146, 121, '2022-03-25 09:48:00', '2022-03-25 10:18:00', '', 0, 329, 63532, NULL, 30, 0, NULL, 141, 0, 'validated', NULL, '2022-03-25 09:19:07', NULL, 2, 2, 923),
(147, 121, '2022-03-25 09:48:00', '2022-03-25 10:20:00', '', 0, 329, NULL, NULL, 32, 0, 17, 143, 0, 'validated', NULL, '2022-03-25 09:26:36', NULL, 2, 2, 923),
(148, 121, '2022-03-25 10:26:00', '2022-03-25 10:28:00', '', 0, 329, NULL, NULL, 2, 0, 18, 145, 0, 'validated', NULL, '2022-03-25 09:28:34', NULL, 2, 2, 923),
(149, 121, '2022-03-25 10:51:00', '2022-03-25 11:05:00', '', 0, 330, 63546, 397, 14, 0, NULL, 147, 0, 'validated', NULL, '2022-03-25 10:28:37', NULL, 1, 1, 923),
(150, 121, '2022-03-25 11:27:00', '2022-03-25 11:31:00', '', 0, 330, 63547, NULL, 4, 0, NULL, 149, 0, 'validated', NULL, '2022-03-25 10:32:29', NULL, 1, 1, 923),
(151, 121, '2022-03-25 11:31:00', '2022-03-25 11:41:00', '', 0, 332, 63558, NULL, 10, 0, NULL, 151, 1, 'validated', NULL, '2022-03-25 10:42:23', NULL, 2, 2, 923),
(154, 121, '2022-03-25 10:31:40', '2022-03-25 11:31:40', '', 1, 331, 63552, NULL, 0, 0, NULL, 155, 1, 'validated', NULL, '2022-03-25 11:05:07', NULL, NULL, NULL, NULL),
(158, 121, '2022-03-28 10:35:00', '2022-03-28 11:01:00', '', 0, 338, 63637, 418, 26, 0, NULL, 158, 1, 'validated', NULL, '2022-03-28 09:02:16', NULL, 2, 1, 923),
(163, 121, '2022-03-28 14:28:00', '2022-03-28 14:53:00', '', 0, 343, 63716, 393, 25, 0, NULL, 160, 1, 'validated', NULL, '2022-03-28 12:53:47', NULL, 2, 2, 923),
(164, 121, '2022-03-28 14:28:00', '2022-03-28 15:28:00', '', 1, 331, 63552, NULL, 0, 0, NULL, 162, 1, 'validated', NULL, '2022-03-28 12:54:40', NULL, NULL, NULL, NULL),
(165, 121, '2022-03-28 14:28:00', '2022-03-28 16:28:00', '', 1, 331, 63552, NULL, 0, 0, NULL, 164, 1, 'validated', NULL, '2022-03-28 12:56:39', NULL, NULL, NULL, NULL),
(166, 121, '2022-03-28 14:56:00', '2022-03-28 16:56:00', '', 1, 334, 63572, NULL, 0, 0, NULL, 166, 1, 'validated', NULL, '2022-03-28 12:59:35', NULL, NULL, NULL, NULL),
(167, 121, '2022-03-28 14:56:00', '2022-03-28 17:56:00', '', 1, 334, 63573, NULL, 0, 0, NULL, 168, 1, 'Edited', NULL, NULL, 168, NULL, NULL, NULL),
(168, 121, '2022-03-28 14:56:00', '2022-03-28 17:56:00', '', 1, 334, 63573, NULL, 0, 0, NULL, NULL, 1, 'Edited', NULL, NULL, 169, NULL, NULL, NULL),
(169, 121, '2022-03-28 14:56:00', '2022-03-28 17:56:00', '', 1, 334, 63573, NULL, 0, 0, NULL, NULL, 1, 'validated', NULL, '2022-03-28 13:13:40', NULL, NULL, NULL, NULL),
(170, 121, '2022-03-28 14:04:00', '2022-03-28 15:24:00', '', 0, 327, NULL, NULL, 80, 0, 24, 170, 1, 'validated', NULL, '2022-03-28 13:26:31', NULL, 2, 2, 923),
(172, 121, '2022-03-28 14:04:00', '2022-03-28 15:27:00', '', 0, 327, NULL, NULL, 83, 0, 26, 172, 1, 'validated', NULL, '2022-03-28 13:28:39', NULL, 1, 1, 923),
(173, 121, '2022-03-28 15:35:00', '2022-03-28 15:36:00', '', 0, 345, 63774, 397, 1, 0, NULL, 174, 0, 'validated', NULL, '2022-03-28 13:37:19', NULL, 2, 2, 923),
(174, 121, '2022-03-28 15:35:00', '2022-03-28 15:38:00', '', 0, 345, 63775, 397, 3, 0, NULL, 176, 0, 'validated', NULL, '2022-03-28 13:38:49', NULL, 1, 2, 923),
(175, 123, '2022-03-28 15:53:00', '2022-03-28 15:56:00', '', 0, 346, 63783, 392, 3, 0, NULL, 178, 1, 'validated', NULL, '2022-03-28 13:58:07', NULL, 1, 1, 923),
(177, 123, '2022-03-28 15:53:00', '2022-03-28 16:12:00', '', 0, 346, 63784, 392, 19, 0, NULL, 180, 0, 'validated', NULL, '2022-03-28 14:13:14', NULL, 2, 2, 923),
(178, 123, '2022-03-28 18:26:00', '2022-03-28 18:43:00', '', 0, 350, 63812, NULL, 17, 0, NULL, 182, 0, 'validated', NULL, '2022-03-28 16:46:03', NULL, 2, 2, 923),
(179, 123, '2022-03-28 18:26:00', '2022-03-28 18:49:00', 'SSSSSSSSCCVVG', 0, 350, 63813, NULL, 23, 0, NULL, 184, 0, 'validated', NULL, '2022-03-28 16:56:44', NULL, 2, 2, 923),
(181, 123, '2022-03-28 18:26:00', '2022-03-28 19:07:00', 'AAAAAAAZZEEEERRRTTYYYY', 0, 350, 63814, NULL, 41, 0, NULL, 186, 0, 'validated', NULL, '2022-03-28 17:09:50', NULL, 3, 3, 923),
(182, 123, '2022-03-28 18:26:00', '2022-03-28 19:19:00', 'TTTTTTTT', 0, 350, 63815, NULL, 53, 0, NULL, 188, 0, 'validated', NULL, '2022-03-28 17:20:27', NULL, 5, 6, 923),
(183, 123, '2022-03-28 18:26:00', '2022-03-28 19:32:00', '', 0, 350, 63816, NULL, 66, 0, NULL, 190, 0, 'validated', NULL, '2022-03-28 17:33:41', NULL, 1, 1, 923),
(184, 123, '2022-03-28 18:26:00', '2022-03-28 19:37:00', '', 0, 350, NULL, NULL, 71, 0, 28, 192, 0, 'validated', NULL, '2022-03-28 17:38:45', NULL, 1, 1, 923),
(185, 121, '2022-03-29 09:13:00', '2022-03-29 09:14:00', '', 0, 351, 63820, 420, 1, 0, NULL, 194, 0, 'validated', NULL, '2022-03-29 07:15:23', NULL, 1, 2, 923),
(186, 121, '2022-03-29 09:13:00', '2022-03-29 09:28:00', '', 0, 351, 63821, 419, 15, 0, NULL, 196, 1, 'validated', NULL, '2022-03-29 07:30:17', NULL, 1, 1, 923),
(188, 125, '2022-03-29 13:33:00', NULL, '', 0, 351, 63820, NULL, 0, 0, NULL, NULL, 0, 'toClose', NULL, NULL, NULL, NULL, NULL, 923);

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

--
-- Structure de la table `session_exercise`
--

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

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

--
-- Structure de la table `signature`
--

CREATE TABLE `signature` (
  `id` int NOT NULL,
  `ato_user_id` int NOT NULL,
  `date` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

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

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

--
-- Structure de la table `skills`
--

CREATE TABLE `skills` (
  `id` int NOT NULL,
  `ato_id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `rating_system_id` int DEFAULT NULL,
  `is_technical` tinyint(1) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `skills` (`id`, `ato_id`, `name`, `rating_system_id`, `is_technical`) VALUES
(32, 603, 'PIL', 57, 1),
(33, 603, 'COM', NULL, 1),
(34, 603, 'CFIT', NULL, 0),
(35, 603, 'Conscience de la situation', NULL, 1),
(36, 603, 'CNT (TP/JPO)', 58, 0),
(37, 603, 'CT (TP/JPO)', 58, 1),
(38, 603, 'CNT ANPI', 66, 0),
(39, 603, 'eghjklm', 57, 1),
(40, 603, 'Simaero', 58, 1),
(41, 603, 'SimaeroCNT', 58, 0),
(42, 603, 'Compétence CT sans notation', NULL, 1),
(43, 603, 'Compétence CNT sans notation', NULL, 0),
(44, 626, 'CNT', 77, 0),
(46, 626, 'dd', NULL, 1),
(47, 626, 'Nom de la compétence', NULL, 1),
(48, 626, 'CT smileys', 85, 1),
(49, 626, 'CNT smileys', 85, 0);

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

--
-- Structure de la table `skills_detail`
--

CREATE TABLE `skills_detail` (
  `id` int NOT NULL,
  `skills_id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `skills_detail` (`id`, `skills_id`, `name`) VALUES
(21, 37, 'PIL'),
(22, 37, 'TRA'),
(23, 37, 'CON'),
(24, 37, 'COM'),
(25, 37, 'PRO'),
(31, 36, 'TM'),
(32, 36, 'AM'),
(33, 36, 'RM ADM'),
(34, 36, 'SA'),
(35, 36, 'CFIT'),
(41, 38, 'TM'),
(42, 38, 'AM'),
(43, 38, 'RM ADM'),
(44, 38, 'SA'),
(45, 38, 'CFIT'),
(52, 39, 'sdfghj,;:'),
(53, 39, 'dfgb'),
(54, 39, 'jhgfds'),
(55, 40, 'Automatic Flight'),
(56, 40, 'Manual Flight'),
(57, 40, 'Lateral and Vertical path'),
(58, 40, 'Procedure SOP'),
(59, 40, 'Knowledge'),
(60, 40, 'Radio Phraseology'),
(61, 40, 'Task Sharing'),
(70, 41, 'Communication'),
(71, 41, 'Crew Resource Management'),
(72, 41, 'Decision making'),
(73, 41, 'Environment management'),
(74, 41, 'Leadership'),
(75, 41, 'Priority management'),
(76, 41, 'Situation Awareness'),
(77, 41, 'Session Final Grading'),
(81, 44, 'Conscience de soi'),
(82, 44, 'CFIT'),
(83, 44, 'Prise de décision'),
(96, 46, 'd'),
(97, 46, 's'),
(98, 46, 'q'),
(99, 46, 'a'),
(103, 48, 'PIL'),
(104, 48, 'PRO'),
(105, 48, 'COM'),
(106, 48, 'TRA'),
(107, 49, 'AM'),
(108, 49, 'TM'),
(109, 49, 'RM'),
(110, 49, 'CS');

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

--
-- Structure de la table `student_formation`
--

CREATE TABLE `student_formation` (
  `id` int NOT NULL,
  `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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `student_formation` (`id`, `formation_id`, `student_id`, `status`, `registered_on`) VALUES
(1, 207, 56, 'inProgress', '2022-03-15 12:27:16'),
(5, 251, 56, 'inProgress', '2022-03-15 12:27:16'),
(6, 207, 57, 'inProgress', '2022-03-15 12:27:16'),
(7, 207, 58, 'inProgress', '2022-03-15 12:27:16'),
(8, 207, 59, 'inProgress', '2022-03-15 12:27:16'),
(9, 207, 60, 'inProgress', '2022-03-15 12:27:16'),
(10, 207, 56, 'inProgress', '2022-03-15 12:27:16'),
(11, 207, 58, 'inProgress', '2022-03-15 12:27:16'),
(12, 251, 58, 'inProgress', '2022-03-15 12:27:16'),
(22, 255, 56, 'inProgress', '2022-03-15 12:27:16'),
(23, 255, 58, 'inProgress', '2022-03-15 12:27:16'),
(24, 255, 61, 'inProgress', '2022-03-15 12:27:16'),
(25, 255, 60, 'inProgress', '2022-03-15 12:27:16'),
(26, 255, 64, 'inProgress', '2022-03-15 12:27:16'),
(27, 255, 65, 'inProgress', '2022-03-15 12:27:16'),
(28, 255, 62, 'inProgress', '2022-03-15 12:27:16'),
(39, 256, 56, 'inProgress', '2022-03-15 12:27:16'),
(41, 256, 58, 'inProgress', '2022-03-15 12:27:16'),
(42, 256, 59, 'inProgress', '2022-03-15 12:27:16'),
(46, 256, 56, 'inProgress', '2022-03-15 12:27:16'),
(47, 256, 57, 'inProgress', '2022-03-15 12:27:16'),
(48, 256, 58, 'inProgress', '2022-03-15 12:27:16'),
(49, 256, 59, 'inProgress', '2022-03-15 12:27:16'),
(50, 256, 60, 'inProgress', '2022-03-15 12:27:16'),
(51, 256, 61, 'inProgress', '2022-03-15 12:27:16'),
(52, 256, 76, 'inProgress', '2022-03-15 12:27:16'),
(53, 257, 76, 'inProgress', '2022-03-15 12:27:16'),
(54, 257, 56, 'inProgress', '2022-03-15 12:27:16'),
(55, 258, 57, 'inProgress', '2022-03-15 12:27:16'),
(56, 258, 76, 'inProgress', '2022-03-15 12:27:16'),
(57, 258, 56, 'inProgress', '2022-03-15 12:27:16'),
(58, 258, 58, 'inProgress', '2022-03-15 12:27:16'),
(59, 258, 59, 'inProgress', '2022-03-15 12:27:16'),
(60, 258, 60, 'inProgress', '2022-03-15 12:27:16'),
(61, 258, 61, 'inProgress', '2022-03-15 12:27:16'),
(63, 261, 50, 'inProgress', '2022-03-15 12:27:16'),
(64, 268, 56, 'inProgress', '2022-03-15 12:27:16'),
(66, 261, 76, 'inProgress', '2022-03-15 12:27:16'),
(67, 268, 50, 'inProgress', '2022-03-15 12:27:16'),
(68, 268, 76, 'inProgress', '2022-03-15 12:27:16'),
(71, 270, 50, 'inProgress', '2022-03-15 12:27:16'),
(72, 270, 61, 'inProgress', '2022-03-15 12:27:16'),
(73, 273, 76, 'inProgress', '2022-03-15 12:27:16'),
(74, 274, 100, 'inProgress', '2022-03-15 12:27:16'),
(75, 275, 56, 'inProgress', '2022-03-15 12:27:16'),
(76, 274, 103, 'inProgress', '2022-03-15 12:27:16'),
(79, 276, 76, 'inProgress', '2022-03-15 12:27:16'),
(80, 277, 76, 'inProgress', '2022-03-15 12:27:16'),
(81, 258, 100, 'inProgress', '2022-03-15 12:27:16'),
(82, 273, 100, 'inProgress', '2022-03-15 12:27:16'),
(83, 277, 77, 'inProgress', '2022-03-15 12:27:16'),
(84, 278, 76, 'inProgress', '2022-03-15 12:27:16'),
(85, 278, 56, 'inProgress', '2022-03-15 12:27:16'),
(86, 279, 76, 'inProgress', '2022-03-15 12:27:16'),
(88, 280, 76, 'inProgress', '2022-03-15 12:27:16'),
(89, 282, 76, 'inProgress', '2022-03-15 12:27:16'),
(90, 283, 76, 'inProgress', '2022-03-15 12:27:16'),
(91, 278, 101, 'inProgress', '2022-03-15 12:27:16'),
(92, 286, 100, 'inProgress', '2022-03-15 12:27:16'),
(93, 287, 100, 'inProgress', '2022-03-15 12:27:16'),
(94, 288, 101, 'inProgress', '2022-03-15 12:27:16'),
(95, 289, 101, 'inProgress', '2022-03-15 12:27:16'),
(99, 292, 122, 'inProgress', '2022-03-21 13:12:47'),
(100, 292, 123, 'inProgress', '2022-03-21 13:13:55'),
(101, 300, 123, 'inProgress', '2022-03-21 13:55:54'),
(102, 302, 122, 'inProgress', '2022-03-21 14:11:53'),
(103, 307, 122, 'inProgress', '2022-03-22 09:52:58'),
(104, 311, 123, 'closed', '2022-03-23 09:23:37'),
(105, 312, 123, 'closed', '2022-03-23 09:42:11'),
(106, 315, 123, 'closed', '2022-03-23 09:54:10'),
(107, 317, 123, 'closed', '2022-03-23 10:43:23'),
(108, 326, 123, 'inProgress', '2022-03-24 09:37:12'),
(109, 326, 122, 'closed', '2022-03-24 09:48:07'),
(110, 327, 122, 'inProgress', '2022-03-24 10:03:50'),
(111, 329, 123, 'inProgress', '2022-03-25 09:18:04'),
(112, 330, 123, 'inProgress', '2022-03-25 10:05:42'),
(113, 331, 123, 'inProgress', '2022-03-25 10:38:28'),
(114, 331, 122, 'inProgress', '2022-03-25 10:38:28'),
(115, 332, 123, 'inProgress', '2022-03-25 10:41:38'),
(116, 333, 122, 'inProgress', '2022-03-25 10:49:26'),
(117, 333, 123, 'inProgress', '2022-03-25 10:49:26'),
(118, 335, 122, 'inProgress', '2022-03-25 10:53:47'),
(119, 335, 125, 'inProgress', '2022-03-25 12:34:21'),
(120, 336, 122, 'inProgress', '2022-03-26 07:48:40'),
(121, 338, 122, 'inProgress', '2022-03-28 08:38:18'),
(122, 339, 122, 'inProgress', '2022-03-28 09:01:02'),
(123, 341, 122, 'inProgress', '2022-03-28 12:05:34'),
(125, 341, 123, 'inProgress', '2022-03-28 12:29:16'),
(126, 342, 122, 'inProgress', '2022-03-28 12:36:18'),
(127, 343, 123, 'inProgress', '2022-03-28 12:52:01'),
(128, 334, 122, 'inProgress', '2022-03-28 12:58:27'),
(129, 334, 123, 'inProgress', '2022-03-28 12:58:27'),
(130, 344, 123, 'inProgress', '2022-03-28 13:05:32'),
(131, 344, 122, 'inProgress', '2022-03-28 13:05:32'),
(132, 345, 122, 'inProgress', '2022-03-28 13:36:29'),
(133, 345, 123, 'inProgress', '2022-03-28 13:36:29'),
(134, 346, 122, 'inProgress', '2022-03-28 13:55:04'),
(135, 350, 122, 'inProgress', '2022-03-28 16:42:25'),
(136, 351, 122, 'inProgress', '2022-03-29 07:14:05'),
(137, 351, 123, 'inProgress', '2022-03-29 07:14:06');

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

--
-- Structure de la table `type_aircraft`
--

CREATE TABLE `type_aircraft` (
  `id` int NOT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL,
  `manufacturer_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `type_aircraft` (`id`, `name`, `manufacturer_id`) VALUES
(83, 'ATL', 20),
(84, 'DR-105A', 20),
(85, 'DR-1050', 20),
(86, 'DR-1051', 20),
(87, 'DR-1050 MM1', 20),
(88, 'DR-1051 MM1', 20),
(89, 'DR-1050 M', 20),
(90, 'DR-1051 M', 20),
(91, 'DR-200', 20),
(92, 'DR-250', 20),
(93, 'DR-220', 20),
(94, 'DR-221', 20),
(95, 'DR-253', 20),
(96, 'DR-340', 20),
(97, 'DR-315', 20),
(98, 'DR-360', 20),
(99, 'DR-380', 20),
(100, 'DR-330', 20),
(101, 'DR-300', 20),
(102, 'DR 400', 20),
(103, 'HR 100', 20),
(104, 'HR 200', 20),
(105, 'R 1180', 20),
(106, 'R 2112', 20),
(107, 'R 2160', 20),
(108, 'R 3000', 20),
(109, 'HR-100', 20),
(110, 'HR-200', 20),
(111, 'R-1180', 20),
(112, 'R-2100', 20),
(113, 'R-2112', 20),
(114, 'R-2160', 20),
(115, 'R-2120', 20),
(116, 'R-3000', 20),
(117, 'C150', 21),
(118, 'C152', 21),
(119, 'C172', 21),
(120, 'C177', 21),
(121, 'C180', 21),
(122, 'C182', 21),
(123, 'C206', 21),
(124, 'C210', 21),
(125, 'C350', 21),
(126, 'C400', 21),
(127, 'C208 CARAVAN', 21),
(128, 'AT', 22),
(129, '206', 23),
(130, '407', 23),
(131, 'M25Y', 24),
(132, 'Action', 25),
(133, 'Merlin', 26),
(134, 'Phase 2', 27),
(135, 'Bidulm', 27),
(136, 'Eurofox', 28),
(137, 'MCR', 29),
(138, 'COUGAR', 30),
(139, 'M16', 31),
(140, 'XENON', 32),
(141, 'Liberty', 33),
(142, 'Cross-over', 34),
(143, 'Cloud Surfer', 34),
(144, 'Dawn Chaser', 34),
(145, 'CH-7', 35),
(146, 'Lambada', 36),
(147, 'SF28', 37),
(148, 'S10', 38),
(149, '20E', 39),
(150, 'STD 3', 40),
(151, 'D-6856', 41),
(152, '3', 42),
(153, 'ASK21', 43),
(154, 'ASW', 43),
(155, 'J3', 44),
(156, 'J4', 44),
(157, 'J5', 44),
(158, 'PA-11', 44),
(159, 'PA-12', 44),
(160, 'PA-14', 44),
(161, 'PA-18', 44),
(162, 'PA-20', 44),
(163, 'PA-21', 44),
(164, 'PA-23', 44),
(165, 'PA-24', 44),
(166, 'PA-25', 44),
(167, 'PA-28', 44),
(168, 'PA-30', 44),
(169, 'PA-31', 44),
(170, 'PA-32', 44),
(171, 'PA-34', 44),
(172, 'PA-36', 44),
(173, 'PA-38', 44),
(174, 'PA-42', 44),
(175, 'PA-44', 44),
(176, 'PA-46', 44),
(177, 'PA-47', 44),
(178, 'VK-30', 45),
(179, 'SR20', 45),
(180, 'SR22', 45),
(181, 'Vision', 45),
(182, 'DA 20', 46),
(183, 'DA 40', 46),
(184, 'DA 42', 46),
(185, 'DA 50', 46),
(186, 'D-JET', 46),
(187, 'Rallye', 47),
(188, 'Gardan', 48),
(189, 'ST 10', 48),
(190, 'TB 9', 48),
(191, 'TB 10', 48),
(192, 'TB 200', 48),
(193, 'TB 20', 48),
(194, 'TB 21', 48),
(195, 'TB 30', 48),
(196, 'TBM 700', 48),
(197, 'TBM 850', 48),
(198, 'TBM 900', 48),
(199, 'RF-2', 49),
(200, 'RF-3', 49),
(201, 'RF-4', 49),
(202, 'RF-5', 49),
(203, 'RF-6', 49),
(204, 'RF-7', 49),
(205, 'RF-8', 49),
(206, 'RF-10', 49),
(207, 'RF-47', 49),
(208, 'PIONEER', 50),
(209, 'SYTON', 50),
(210, 'CAP 10', 51),
(211, 'CAP 20', 52),
(212, 'CAP 21', 52),
(213, 'CAP 230', 52),
(214, 'CAP 231', 52),
(215, 'CAP 232', 52),
(216, 'CAP 332', 52),
(217, 'CAP 432', 52),
(218, 'CR', 53),
(219, 'EXTRA', 54),
(220, 'PITTS', 55),
(221, 'GRUMMAN', 56),
(222, 'Test type', 58);

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

--
-- Structure de la table `type_aircraft_model_aircraft`
--

CREATE TABLE `type_aircraft_model_aircraft` (
  `type_aircraft_id` int NOT NULL,
  `model_aircraft_id` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `type_aircraft_model_aircraft` (`type_aircraft_id`, `model_aircraft_id`) VALUES
(83, 147),
(84, 148),
(85, 149),
(85, 150),
(86, 149),
(86, 150),
(87, 151),
(88, 151),
(89, 152),
(90, 152),
(91, 153),
(92, 154),
(92, 155),
(93, 156),
(93, 157),
(93, 158),
(94, 155),
(94, 159),
(95, 155),
(95, 160),
(96, 161),
(97, 162),
(98, 163),
(99, 164),
(100, 165),
(101, 166),
(101, 167),
(101, 168),
(101, 169),
(102, 160),
(102, 161),
(102, 170),
(102, 171),
(102, 172),
(103, 173),
(104, 174),
(105, 175),
(106, 176),
(107, 177),
(108, 178),
(109, 179),
(109, 180),
(109, 181),
(109, 182),
(109, 183),
(109, 184),
(109, 185),
(109, 186),
(109, 187),
(110, 188),
(111, 189),
(111, 190),
(111, 191),
(112, 192),
(113, 193),
(114, 194),
(114, 195),
(115, 193),
(116, 169),
(116, 196),
(116, 197),
(116, 198),
(116, 199),
(117, 200),
(117, 201),
(118, 202),
(118, 203),
(119, 204),
(119, 205),
(119, 206),
(120, 207),
(120, 208),
(120, 209),
(121, 210),
(122, 211),
(122, 212),
(122, 213),
(122, 214),
(122, 215),
(122, 216),
(122, 217),
(122, 218),
(122, 219),
(122, 220),
(122, 221),
(122, 222),
(123, 223),
(123, 224),
(123, 225),
(124, 226),
(125, 227),
(126, 227),
(127, 228),
(127, 229),
(127, 230),
(127, 231),
(127, 232),
(127, 233),
(127, 234),
(128, 235),
(128, 236),
(128, 237),
(128, 238),
(128, 239),
(128, 240),
(129, 241),
(129, 242),
(129, 243),
(129, 244),
(129, 245),
(130, 246),
(131, 247),
(132, 248),
(133, 249),
(134, 250),
(134, 251),
(135, 252),
(136, 253),
(136, 254),
(137, 253),
(137, 255),
(137, 256),
(138, 257),
(139, 258),
(140, 259),
(141, 260),
(142, 261),
(142, 262),
(142, 263),
(142, 264),
(142, 265),
(142, 266),
(142, 267),
(143, 268),
(143, 269),
(143, 270),
(143, 271),
(143, 272),
(143, 273),
(144, 274),
(144, 275),
(144, 276),
(145, 277),
(146, 278),
(147, 279),
(148, 280),
(148, 281),
(148, 282),
(148, 283),
(149, 284),
(150, 285),
(151, 286),
(152, 287),
(153, 288),
(153, 289),
(154, 290),
(154, 291),
(154, 292),
(154, 293),
(155, 294),
(156, 295),
(157, 296),
(158, 297),
(159, 298),
(160, 299),
(161, 300),
(162, 301),
(163, 302),
(164, 303),
(164, 304),
(165, 305),
(166, 306),
(167, 307),
(167, 308),
(167, 309),
(167, 310),
(167, 311),
(168, 312),
(169, 313),
(169, 314),
(169, 315),
(169, 316),
(170, 317),
(170, 318),
(170, 319),
(171, 320),
(172, 321),
(173, 322),
(174, 316),
(175, 323),
(176, 324),
(176, 325),
(176, 326),
(176, 327),
(177, 328),
(178, 329),
(179, 330),
(180, 331),
(180, 332),
(181, 333),
(182, 334),
(183, 335),
(183, 336),
(183, 337),
(184, 338),
(184, 339),
(184, 340),
(184, 341),
(184, 342),
(185, 343),
(185, 344),
(186, 345),
(187, 346),
(187, 347),
(187, 348),
(187, 349),
(187, 350),
(187, 351),
(187, 352),
(187, 353),
(187, 354),
(187, 355),
(188, 356),
(189, 357),
(190, 358),
(191, 359),
(192, 360),
(193, 361),
(194, 362),
(195, 363),
(196, 364),
(197, 365),
(198, 366),
(199, 367),
(200, 368),
(201, 369),
(202, 370),
(203, 371),
(204, 372),
(205, 373),
(206, 374),
(207, 375),
(208, 376),
(208, 377),
(208, 378),
(208, 379),
(208, 380),
(208, 381),
(208, 382),
(209, 383),
(210, 155),
(210, 384),
(211, 385),
(211, 386),
(212, 387),
(213, 388),
(214, 389),
(214, 390),
(215, 391),
(216, 392),
(217, 393),
(218, 196),
(218, 394),
(218, 395),
(218, 396),
(219, 179),
(219, 397),
(219, 398),
(219, 399),
(219, 400),
(219, 401),
(219, 402),
(219, 403),
(220, 404),
(220, 405),
(220, 406),
(220, 407),
(220, 408),
(220, 409),
(220, 410),
(220, 411),
(220, 412),
(220, 413),
(220, 414),
(220, 415),
(220, 416),
(221, 417),
(221, 418),
(221, 419),
(221, 420),
(222, 421);

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

--
-- Structure de la 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
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

INSERT INTO `user_app_role` (`user_id`, `app_role_id`) VALUES
('2be64b2c-1cdc-45cf-a43e-b095857384de', 17),
('3f6be5e0-119e-11ec-acae-d60414d71c23', 17),
('f3ea90dd-ca78-400b-a099-07f18157e954', 17),
('f96aea32-fdd3-4190-9a61-04ecc4104f5e', 17),
('2be64b2c-1cdc-45cf-a43e-b095857384de', 22),
('2be64b2c-1cdc-45cf-a43e-b095857384de', 23);

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

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

--
-- Index pour la table `aircraft`
--
ALTER TABLE `aircraft`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_13D9672912469DE2` (`category_id`),
  ADD KEY `IDX_13D96729EA000B10` (`class_id`),
  ADD KEY `IDX_13D96729A23B42D` (`manufacturer_id`),
  ADD KEY `IDX_13D96729C54C8C93` (`type_id`),
  ADD KEY `IDX_13D967297975B7E7` (`model_id`),
  ADD KEY `IDX_13D96729577F21F8` (`engine_type_id`);

--
-- Index pour la table `aircraft_counter_type_value`
--
ALTER TABLE `aircraft_counter_type_value`
  ADD PRIMARY KEY (`aircraft_id`,`counter_type_value_id`),
  ADD KEY `IDX_E6BC0EF1846E2F5C` (`aircraft_id`),
  ADD KEY `IDX_E6BC0EF12402E8F` (`counter_type_value_id`);

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

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

--
-- Index pour la table `ato`
--
ALTER TABLE `ato`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_200AB83EFD54954B` (`postal_address_id`),
  ADD UNIQUE KEY `UNIQ_200AB83EF5A825DA` (`leader_responsible_id`),
  ADD UNIQUE KEY `UNIQ_200AB83EB8ECE616` (`security_manager_id`),
  ADD UNIQUE KEY `UNIQ_200AB83E521911ED` (`compliance_manager_id`),
  ADD UNIQUE KEY `UNIQ_200AB83EE36700E2` (`head_teacher_id`),
  ADD UNIQUE KEY `UNIQ_200AB83ED1F50D7E` (`assistant_head_teacher_id`),
  ADD UNIQUE KEY `UNIQ_200AB83E851FE69C` (`chief_ground_instructor_id`),
  ADD UNIQUE KEY `UNIQ_200AB83EBDA5B3D2` (`chief_flight_instructor_id`),
  ADD KEY `IDX_200AB83E727ACA70` (`parent_id`);

--
-- Index pour la table `ato_counter_type_value`
--
ALTER TABLE `ato_counter_type_value`
  ADD PRIMARY KEY (`ato_id`,`counter_type_value_id`),
  ADD KEY `IDX_82B4DD5847DC024` (`ato_id`),
  ADD KEY `IDX_82B4DD52402E8F` (`counter_type_value_id`);

--
-- Index pour la table `ato_instructor_skill`
--
ALTER TABLE `ato_instructor_skill`
  ADD PRIMARY KEY (`ato_id`,`instructor_skill_id`),
  ADD KEY `IDX_29651708847DC024` (`ato_id`),
  ADD KEY `IDX_2965170855E763E7` (`instructor_skill_id`);

--
-- Index pour la table `ato_role`
--
ALTER TABLE `ato_role`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_54883B97847DC024` (`ato_id`);

--
-- Index pour la table `ato_user`
--
ALTER TABLE `ato_user`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_8E7267B4847DC024` (`ato_id`),
  ADD KEY `IDX_8E7267B4A76ED395` (`user_id`);

--
-- Index pour la table `ato_user_action`
--
ALTER TABLE `ato_user_action`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_F1A04DE79D32F035` (`action_id`),
  ADD KEY `IDX_F1A04DE730A17E02` (`ato_user_id`);

--
-- Index pour la table `ato_user_ato_role`
--
ALTER TABLE `ato_user_ato_role`
  ADD PRIMARY KEY (`ato_user_id`,`ato_role_id`),
  ADD KEY `IDX_EAA3F26E30A17E02` (`ato_user_id`),
  ADD KEY `IDX_EAA3F26E41CC8F3B` (`ato_role_id`);

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

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

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

--
-- Index pour la table `class_aircraft_manufacturer_aircraft`
--
ALTER TABLE `class_aircraft_manufacturer_aircraft`
  ADD PRIMARY KEY (`class_aircraft_id`,`manufacturer_aircraft_id`),
  ADD KEY `IDX_E01BD698BC00E06A` (`class_aircraft_id`),
  ADD KEY `IDX_E01BD69884B93B67` (`manufacturer_aircraft_id`);

--
-- Index pour la table `class_aircraft_model_aircraft`
--
ALTER TABLE `class_aircraft_model_aircraft`
  ADD PRIMARY KEY (`class_aircraft_id`,`model_aircraft_id`),
  ADD KEY `IDX_D4AC5D84BC00E06A` (`class_aircraft_id`),
  ADD KEY `IDX_D4AC5D84EA6C16B0` (`model_aircraft_id`);

--
-- Index pour la table `class_aircraft_type_aircraft`
--
ALTER TABLE `class_aircraft_type_aircraft`
  ADD PRIMARY KEY (`class_aircraft_id`,`type_aircraft_id`),
  ADD KEY `IDX_1C27305FBC00E06A` (`class_aircraft_id`),
  ADD KEY `IDX_1C27305FCF77F8CD` (`type_aircraft_id`);

--
-- Index pour la table `constraint`
--
ALTER TABLE `constraint`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_394A8EF255E763E7` (`instructor_skill_id`),
  ADD KEY `IDX_394A8EF29D32F035` (`action_id`),
  ADD KEY `IDX_394A8EF257901725` (`formation_item_id`),
  ADD KEY `IDX_394A8EF2727ACA70` (`parent_id`);

--
-- Index pour la table `counter_counter_type_value`
--
ALTER TABLE `counter_counter_type_value`
  ADD PRIMARY KEY (`counter_id`,`counter_type_value_id`),
  ADD KEY `IDX_9A27E752FCEEF2E3` (`counter_id`),
  ADD KEY `IDX_9A27E7522402E8F` (`counter_type_value_id`);

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

--
-- Index pour la table `counter_predefined_value`
--
ALTER TABLE `counter_predefined_value`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_11873EEE4B27D0B2` (`counter_type_id`);

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

--
-- Index pour la table `counter_type_counter_group`
--
ALTER TABLE `counter_type_counter_group`
  ADD PRIMARY KEY (`counter_type_id`,`counter_group_id`),
  ADD KEY `IDX_B20934924B27D0B2` (`counter_type_id`),
  ADD KEY `IDX_B2093492B2B3A245` (`counter_group_id`);

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

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

--
-- Index pour la table `extra_lesson`
--
ALTER TABLE `extra_lesson`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_2E584C5BCDF80196` (`lesson_id`),
  ADD KEY `IDX_2E584C5B5200282E` (`formation_id`);

--
-- Index pour la table `extra_lesson_skills`
--
ALTER TABLE `extra_lesson_skills`
  ADD PRIMARY KEY (`extra_lesson_id`,`skills_id`),
  ADD KEY `IDX_3DC4DAAE3FD4DD80` (`extra_lesson_id`),
  ADD KEY `IDX_3DC4DAAE7FF61858` (`skills_id`);

--
-- Index pour la table `formation`
--
ALTER TABLE `formation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_404021BF67595CFC` (`lesson_notation_id`),
  ADD KEY `IDX_404021BFB61422E` (`exercises_notation_id`),
  ADD KEY `IDX_404021BFE250A17B` (`exercise_decomposition_notation_id`),
  ADD KEY `IDX_404021BF847DC024` (`ato_id`);

--
-- Index pour la table `formation_item`
--
ALTER TABLE `formation_item`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_48C4C05E727ACA70` (`parent_id`),
  ADD KEY `IDX_48C4C05E5200282E` (`formation_id`),
  ADD KEY `IDX_48C4C05E3FD4DD80` (`extra_lesson_id`),
  ADD KEY `IDX_48C4C05E9680B7F7` (`notation_id`),
  ADD KEY `IDX_48C4C05E55D631A8` (`min_rating_id`),
  ADD KEY `IDX_48C4C05E6278D5A8` (`classroom_id`),
  ADD KEY `IDX_48C4C05EB0E02586` (`expected_value_id`);

--
-- Index pour la table `formation_items_technical_skills`
--
ALTER TABLE `formation_items_technical_skills`
  ADD PRIMARY KEY (`formation_item_id`,`skills_id`),
  ADD KEY `IDX_72D338D457901725` (`formation_item_id`),
  ADD KEY `IDX_72D338D47FF61858` (`skills_id`);

--
-- Index pour la table `formation_item_action`
--
ALTER TABLE `formation_item_action`
  ADD PRIMARY KEY (`formation_item_id`,`action_id`),
  ADD KEY `IDX_9EC8D98657901725` (`formation_item_id`),
  ADD KEY `IDX_9EC8D9869D32F035` (`action_id`);

--
-- Index pour la table `formation_item_formation_item`
--
ALTER TABLE `formation_item_formation_item`
  ADD PRIMARY KEY (`formation_item_source`,`formation_item_target`),
  ADD KEY `IDX_DEAC66A1868E2A67` (`formation_item_source`),
  ADD KEY `IDX_DEAC66A19F6B7AE8` (`formation_item_target`);

--
-- Index pour la table `formation_item_skills`
--
ALTER TABLE `formation_item_skills`
  ADD PRIMARY KEY (`formation_item_id`,`skills_id`),
  ADD KEY `IDX_C35436457901725` (`formation_item_id`),
  ADD KEY `IDX_C3543647FF61858` (`skills_id`);

--
-- Index pour la table `formation_practical_counter_type`
--
ALTER TABLE `formation_practical_counter_type`
  ADD PRIMARY KEY (`formation_id`,`counter_type_value_id`),
  ADD KEY `IDX_8EA8CCD95200282E` (`formation_id`),
  ADD KEY `IDX_8EA8CCD92402E8F` (`counter_type_value_id`);

--
-- Index pour la table `formation_theoretical_counter_type`
--
ALTER TABLE `formation_theoretical_counter_type`
  ADD PRIMARY KEY (`formation_id`,`counter_type_value_id`),
  ADD KEY `IDX_4B85E0E35200282E` (`formation_id`),
  ADD KEY `IDX_4B85E0E32402E8F` (`counter_type_value_id`);

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

--
-- Index pour la table `instructor_skill_ato_user`
--
ALTER TABLE `instructor_skill_ato_user`
  ADD PRIMARY KEY (`instructor_skill_id`,`ato_user_id`),
  ADD KEY `IDX_1EC3796555E763E7` (`instructor_skill_id`),
  ADD KEY `IDX_1EC3796530A17E02` (`ato_user_id`);

--
-- Index pour la table `lesson_annotation`
--
ALTER TABLE `lesson_annotation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_234D7723847DC024` (`ato_id`);

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

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

--
-- Index pour la table `media_object`
--
ALTER TABLE `media_object`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_14D431325200282E` (`formation_id`),
  ADD KEY `IDX_14D43132CDF80196` (`lesson_id`),
  ADD KEY `IDX_14D431329D32F035` (`action_id`),
  ADD KEY `IDX_14D431323FD4DD80` (`extra_lesson_id`);

--
-- Index pour la table `migration_versions`
--
ALTER TABLE `migration_versions`
  ADD PRIMARY KEY (`version`);

--
-- Index pour la table `model_aircraft`
--
ALTER TABLE `model_aircraft`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_D90336CA577F21F8` (`engine_type_id`),
  ADD KEY `IDX_D90336CA12469DE2` (`category_id`),
  ADD KEY `IDX_D90336CAA23B42D` (`manufacturer_id`);

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

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

--
-- Index pour la table `promotion`
--
ALTER TABLE `promotion`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_C11D7DD1847DC024` (`ato_id`);

--
-- Index pour la table `promotion_ato_user`
--
ALTER TABLE `promotion_ato_user`
  ADD PRIMARY KEY (`promotion_id`,`ato_user_id`),
  ADD KEY `IDX_4826C3F0139DF194` (`promotion_id`),
  ADD KEY `IDX_4826C3F030A17E02` (`ato_user_id`);

--
-- Index pour la table `promotion_formation`
--
ALTER TABLE `promotion_formation`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_3137F092139DF194` (`promotion_id`),
  ADD KEY `IDX_3137F0925200282E` (`formation_id`);

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

--
-- Index pour la table `rating_ato`
--
ALTER TABLE `rating_ato`
  ADD PRIMARY KEY (`rating_id`,`ato_id`),
  ADD KEY `IDX_39D385C7A32EFC6` (`rating_id`),
  ADD KEY `IDX_39D385C7847DC024` (`ato_id`);

--
-- Index pour la table `rating_value`
--
ALTER TABLE `rating_value`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_80615708F6419510` (`media_value_id`),
  ADD KEY `IDX_80615708260075EB` (`rating_type_id`);

--
-- Index pour la table `resources`
--
ALTER TABLE `resources`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_EF66EBAE847DC024` (`ato_id`);

--
-- Index pour la table `session`
--
ALTER TABLE `session`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `UNIQ_D044D5D463D2D5DF` (`lesson_extra_id`),
  ADD UNIQUE KEY `UNIQ_D044D5D41AE37126` (`instructor_signature_id`),
  ADD UNIQUE KEY `UNIQ_D044D5D4E071F843` (`pdf_file_id`),
  ADD UNIQUE KEY `UNIQ_D044D5D494AE086B` (`correction_id`),
  ADD KEY `IDX_D044D5D48C4FC193` (`instructor_id`),
  ADD KEY `IDX_D044D5D45200282E` (`formation_id`),
  ADD KEY `IDX_D044D5D4CDF80196` (`lesson_id`),
  ADD KEY `IDX_D044D5D467595CFC` (`lesson_notation_id`),
  ADD KEY `IDX_D044D5D4F631AB5C` (`departure_airport_id`),
  ADD KEY `IDX_D044D5D47F43E343` (`arrival_airport_id`),
  ADD KEY `IDX_D044D5D4846E2F5C` (`aircraft_id`);

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

--
-- Index pour la table `signature`
--
ALTER TABLE `signature`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_AE88014130A17E02` (`ato_user_id`);

--
-- Index pour la table `skills`
--
ALTER TABLE `skills`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_D5311670847DC024` (`ato_id`),
  ADD KEY `IDX_D5311670F31275AF` (`rating_system_id`);

--
-- Index pour la table `skills_detail`
--
ALTER TABLE `skills_detail`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_631971207FF61858` (`skills_id`);

--
-- Index pour la table `student_formation`
--
ALTER TABLE `student_formation`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_272EE03F5200282E` (`formation_id`),
  ADD KEY `IDX_272EE03FCB944F1A` (`student_id`);

--
-- Index pour la table `type_aircraft`
--
ALTER TABLE `type_aircraft`
  ADD PRIMARY KEY (`id`),
  ADD KEY `IDX_DE2640D5A23B42D` (`manufacturer_id`);

--
-- Index pour la table `type_aircraft_model_aircraft`
--
ALTER TABLE `type_aircraft_model_aircraft`
  ADD PRIMARY KEY (`type_aircraft_id`,`model_aircraft_id`),
  ADD KEY `IDX_114C446CCF77F8CD` (`type_aircraft_id`),
  ADD KEY `IDX_114C446CEA6C16B0` (`model_aircraft_id`);

--
-- Index pour la table `user_app_role`
--
ALTER TABLE `user_app_role`
  ADD PRIMARY KEY (`user_id`,`app_role_id`),
  ADD KEY `IDX_B2CA4BCAA76ED395` (`user_id`),
  ADD KEY `IDX_B2CA4BCA3B5EA2E1` (`app_role_id`);

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

--
-- AUTO_INCREMENT pour la table `action`
--
ALTER TABLE `action`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=73;

--
-- AUTO_INCREMENT pour la table `airport`
--
ALTER TABLE `airport`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=467;

--
-- AUTO_INCREMENT pour la table `app_role`
--
ALTER TABLE `app_role`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=24;

--
-- AUTO_INCREMENT pour la table `ato`
--
ALTER TABLE `ato`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=628;

--
-- AUTO_INCREMENT pour la table `ato_role`
--
ALTER TABLE `ato_role`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=181;

--
-- AUTO_INCREMENT pour la table `ato_user`
--
ALTER TABLE `ato_user`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=128;

--
-- AUTO_INCREMENT pour la table `ato_user_action`
--
ALTER TABLE `ato_user_action`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `category_aircraft`
--
ALTER TABLE `category_aircraft`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=14;

--
-- AUTO_INCREMENT pour la table `class_aircraft`
--
ALTER TABLE `class_aircraft`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=42;

--
-- AUTO_INCREMENT pour la table `constraint`
--
ALTER TABLE `constraint`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=160;

--
-- AUTO_INCREMENT pour la table `counter_predefined_value`
--
ALTER TABLE `counter_predefined_value`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=22;

--
-- AUTO_INCREMENT pour la table `counter_type_value`
--
ALTER TABLE `counter_type_value`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=80;

--
-- AUTO_INCREMENT pour la table `engine_type_aircraft`
--
ALTER TABLE `engine_type_aircraft`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=9;

--
-- AUTO_INCREMENT pour la table `extra_lesson`
--
ALTER TABLE `extra_lesson`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=30;

--
-- AUTO_INCREMENT pour la table `formation`
--
ALTER TABLE `formation`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=355;

--
-- AUTO_INCREMENT pour la table `formation_item`
--
ALTER TABLE `formation_item`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=63838;

--
-- AUTO_INCREMENT pour la table `instructor_skill`
--
ALTER TABLE `instructor_skill`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=21;

--
-- AUTO_INCREMENT pour la table `lesson_annotation`
--
ALTER TABLE `lesson_annotation`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `lesson_annotation_value`
--
ALTER TABLE `lesson_annotation_value`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `manufacturer_aircraft`
--
ALTER TABLE `manufacturer_aircraft`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=59;

--
-- AUTO_INCREMENT pour la table `media_object`
--
ALTER TABLE `media_object`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=383;

--
-- AUTO_INCREMENT pour la table `model_aircraft`
--
ALTER TABLE `model_aircraft`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=422;

--
-- AUTO_INCREMENT pour la table `notification`
--
ALTER TABLE `notification`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=138;

--
-- AUTO_INCREMENT pour la table `postal_address`
--
ALTER TABLE `postal_address`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=78;

--
-- AUTO_INCREMENT pour la table `promotion`
--
ALTER TABLE `promotion`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=15;

--
-- AUTO_INCREMENT pour la table `promotion_formation`
--
ALTER TABLE `promotion_formation`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

--
-- AUTO_INCREMENT pour la table `rating`
--
ALTER TABLE `rating`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=86;

--
-- AUTO_INCREMENT pour la table `rating_value`
--
ALTER TABLE `rating_value`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=421;

--
-- AUTO_INCREMENT pour la table `resources`
--
ALTER TABLE `resources`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=925;

--
-- AUTO_INCREMENT pour la table `session`
--
ALTER TABLE `session`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=189;

--
-- AUTO_INCREMENT pour la table `session_exercise`
--
ALTER TABLE `session_exercise`
  MODIFY `id` int NOT NULL AUTO_INCREMENT;

--
-- AUTO_INCREMENT pour la table `signature`
--
ALTER TABLE `signature`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=198;

--
-- AUTO_INCREMENT pour la table `skills`
--
ALTER TABLE `skills`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=50;

--
-- AUTO_INCREMENT pour la table `skills_detail`
--
ALTER TABLE `skills_detail`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=111;

--
-- AUTO_INCREMENT pour la table `student_formation`
--
ALTER TABLE `student_formation`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=138;

--
-- AUTO_INCREMENT pour la table `type_aircraft`
--
ALTER TABLE `type_aircraft`
  MODIFY `id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=223;

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

--
-- Contraintes pour la table `aircraft`
--
ALTER TABLE `aircraft`
  ADD CONSTRAINT `FK_13D9672912469DE2` FOREIGN KEY (`category_id`) REFERENCES `category_aircraft` (`id`),
  ADD CONSTRAINT `FK_13D96729577F21F8` FOREIGN KEY (`engine_type_id`) REFERENCES `engine_type_aircraft` (`id`),
  ADD CONSTRAINT `FK_13D967297975B7E7` FOREIGN KEY (`model_id`) REFERENCES `model_aircraft` (`id`),
  ADD CONSTRAINT `FK_13D96729A23B42D` FOREIGN KEY (`manufacturer_id`) REFERENCES `manufacturer_aircraft` (`id`),
  ADD CONSTRAINT `FK_13D96729BF396750` FOREIGN KEY (`id`) REFERENCES `resources` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_13D96729C54C8C93` FOREIGN KEY (`type_id`) REFERENCES `type_aircraft` (`id`),
  ADD CONSTRAINT `FK_13D96729EA000B10` FOREIGN KEY (`class_id`) REFERENCES `class_aircraft` (`id`);

--
-- Contraintes pour la table `aircraft_counter_type_value`
--
ALTER TABLE `aircraft_counter_type_value`
  ADD CONSTRAINT `FK_E6BC0EF12402E8F` FOREIGN KEY (`counter_type_value_id`) REFERENCES `counter_type_value` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_E6BC0EF1846E2F5C` FOREIGN KEY (`aircraft_id`) REFERENCES `aircraft` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `ato`
--
ALTER TABLE `ato`
  ADD CONSTRAINT `FK_200AB83E521911ED` FOREIGN KEY (`compliance_manager_id`) REFERENCES `ato_user` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_200AB83E727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `ato` (`id`),
  ADD CONSTRAINT `FK_200AB83E851FE69C` FOREIGN KEY (`chief_ground_instructor_id`) REFERENCES `ato_user` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_200AB83EB8ECE616` FOREIGN KEY (`security_manager_id`) REFERENCES `ato_user` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_200AB83EBDA5B3D2` FOREIGN KEY (`chief_flight_instructor_id`) REFERENCES `ato_user` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_200AB83ED1F50D7E` FOREIGN KEY (`assistant_head_teacher_id`) REFERENCES `ato_user` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_200AB83EE36700E2` FOREIGN KEY (`head_teacher_id`) REFERENCES `ato_user` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_200AB83EF5A825DA` FOREIGN KEY (`leader_responsible_id`) REFERENCES `ato_user` (`id`),
  ADD CONSTRAINT `FK_200AB83EFD54954B` FOREIGN KEY (`postal_address_id`) REFERENCES `postal_address` (`id`);

--
-- Contraintes pour la table `ato_counter_type_value`
--
ALTER TABLE `ato_counter_type_value`
  ADD CONSTRAINT `FK_82B4DD52402E8F` FOREIGN KEY (`counter_type_value_id`) REFERENCES `counter_type_value` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_82B4DD5847DC024` FOREIGN KEY (`ato_id`) REFERENCES `ato` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `ato_instructor_skill`
--
ALTER TABLE `ato_instructor_skill`
  ADD CONSTRAINT `FK_2965170855E763E7` FOREIGN KEY (`instructor_skill_id`) REFERENCES `instructor_skill` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_29651708847DC024` FOREIGN KEY (`ato_id`) REFERENCES `ato` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `ato_role`
--
ALTER TABLE `ato_role`
  ADD CONSTRAINT `FK_54883B97847DC024` FOREIGN KEY (`ato_id`) REFERENCES `ato` (`id`);

--
-- Contraintes pour la table `ato_user`
--
ALTER TABLE `ato_user`
  ADD CONSTRAINT `FK_8E7267B4847DC024` FOREIGN KEY (`ato_id`) REFERENCES `ato` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_8E7267B4A76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);

--
-- Contraintes pour la table `ato_user_action`
--
ALTER TABLE `ato_user_action`
  ADD CONSTRAINT `FK_F1A04DE730A17E02` FOREIGN KEY (`ato_user_id`) REFERENCES `ato_user` (`id`),
  ADD CONSTRAINT `FK_F1A04DE79D32F035` FOREIGN KEY (`action_id`) REFERENCES `action` (`id`);

--
-- Contraintes pour la table `ato_user_ato_role`
--
ALTER TABLE `ato_user_ato_role`
  ADD CONSTRAINT `FK_EAA3F26E30A17E02` FOREIGN KEY (`ato_user_id`) REFERENCES `ato_user` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_EAA3F26E41CC8F3B` FOREIGN KEY (`ato_role_id`) REFERENCES `ato_role` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `classroom`
--
ALTER TABLE `classroom`
  ADD CONSTRAINT `FK_497D309DBF396750` FOREIGN KEY (`id`) REFERENCES `resources` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `class_aircraft_manufacturer_aircraft`
--
ALTER TABLE `class_aircraft_manufacturer_aircraft`
  ADD CONSTRAINT `FK_E01BD69884B93B67` FOREIGN KEY (`manufacturer_aircraft_id`) REFERENCES `manufacturer_aircraft` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_E01BD698BC00E06A` FOREIGN KEY (`class_aircraft_id`) REFERENCES `class_aircraft` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `class_aircraft_model_aircraft`
--
ALTER TABLE `class_aircraft_model_aircraft`
  ADD CONSTRAINT `FK_D4AC5D84BC00E06A` FOREIGN KEY (`class_aircraft_id`) REFERENCES `class_aircraft` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_D4AC5D84EA6C16B0` FOREIGN KEY (`model_aircraft_id`) REFERENCES `model_aircraft` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `class_aircraft_type_aircraft`
--
ALTER TABLE `class_aircraft_type_aircraft`
  ADD CONSTRAINT `FK_1C27305FBC00E06A` FOREIGN KEY (`class_aircraft_id`) REFERENCES `class_aircraft` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_1C27305FCF77F8CD` FOREIGN KEY (`type_aircraft_id`) REFERENCES `type_aircraft` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `constraint`
--
ALTER TABLE `constraint`
  ADD CONSTRAINT `FK_394A8EF255E763E7` FOREIGN KEY (`instructor_skill_id`) REFERENCES `instructor_skill` (`id`),
  ADD CONSTRAINT `FK_394A8EF257901725` FOREIGN KEY (`formation_item_id`) REFERENCES `formation_item` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_394A8EF2727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `formation_item` (`id`),
  ADD CONSTRAINT `FK_394A8EF29D32F035` FOREIGN KEY (`action_id`) REFERENCES `action` (`id`);

--
-- Contraintes pour la table `counter_counter_type_value`
--
ALTER TABLE `counter_counter_type_value`
  ADD CONSTRAINT `FK_9A27E7522402E8F` FOREIGN KEY (`counter_type_value_id`) REFERENCES `counter_type_value` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_9A27E752FCEEF2E3` FOREIGN KEY (`counter_id`) REFERENCES `counter` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `counter_group`
--
ALTER TABLE `counter_group`
  ADD CONSTRAINT `FK_BE593DE7BF396750` FOREIGN KEY (`id`) REFERENCES `counter_type_value` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `counter_predefined_value`
--
ALTER TABLE `counter_predefined_value`
  ADD CONSTRAINT `FK_11873EEE4B27D0B2` FOREIGN KEY (`counter_type_id`) REFERENCES `counter_type` (`id`);

--
-- Contraintes pour la table `counter_type`
--
ALTER TABLE `counter_type`
  ADD CONSTRAINT `FK_C3538E4EBF396750` FOREIGN KEY (`id`) REFERENCES `counter_type_value` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `counter_type_counter_group`
--
ALTER TABLE `counter_type_counter_group`
  ADD CONSTRAINT `FK_B20934924B27D0B2` FOREIGN KEY (`counter_type_id`) REFERENCES `counter_type` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_B2093492B2B3A245` FOREIGN KEY (`counter_group_id`) REFERENCES `counter_group` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `extra_lesson`
--
ALTER TABLE `extra_lesson`
  ADD CONSTRAINT `FK_2E584C5B5200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`),
  ADD CONSTRAINT `FK_2E584C5BCDF80196` FOREIGN KEY (`lesson_id`) REFERENCES `formation_item` (`id`);

--
-- Contraintes pour la table `extra_lesson_skills`
--
ALTER TABLE `extra_lesson_skills`
  ADD CONSTRAINT `FK_3DC4DAAE3FD4DD80` FOREIGN KEY (`extra_lesson_id`) REFERENCES `extra_lesson` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_3DC4DAAE7FF61858` FOREIGN KEY (`skills_id`) REFERENCES `skills` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `formation`
--
ALTER TABLE `formation`
  ADD CONSTRAINT `FK_404021BF67595CFC` FOREIGN KEY (`lesson_notation_id`) REFERENCES `rating` (`id`),
  ADD CONSTRAINT `FK_404021BF847DC024` FOREIGN KEY (`ato_id`) REFERENCES `ato` (`id`),
  ADD CONSTRAINT `FK_404021BFB61422E` FOREIGN KEY (`exercises_notation_id`) REFERENCES `rating` (`id`),
  ADD CONSTRAINT `FK_404021BFE250A17B` FOREIGN KEY (`exercise_decomposition_notation_id`) REFERENCES `rating` (`id`);

--
-- Contraintes pour la table `formation_item`
--
ALTER TABLE `formation_item`
  ADD CONSTRAINT `FK_48C4C05E3FD4DD80` FOREIGN KEY (`extra_lesson_id`) REFERENCES `extra_lesson` (`id`) ON DELETE SET NULL,
  ADD CONSTRAINT `FK_48C4C05E5200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_48C4C05E55D631A8` FOREIGN KEY (`min_rating_id`) REFERENCES `rating_value` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_48C4C05E6278D5A8` FOREIGN KEY (`classroom_id`) REFERENCES `classroom` (`id`),
  ADD CONSTRAINT `FK_48C4C05E727ACA70` FOREIGN KEY (`parent_id`) REFERENCES `formation_item` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_48C4C05E9680B7F7` FOREIGN KEY (`notation_id`) REFERENCES `rating` (`id`),
  ADD CONSTRAINT `FK_48C4C05EB0E02586` FOREIGN KEY (`expected_value_id`) REFERENCES `rating_value` (`id`);

--
-- Contraintes pour la table `formation_items_technical_skills`
--
ALTER TABLE `formation_items_technical_skills`
  ADD CONSTRAINT `FK_72D338D457901725` FOREIGN KEY (`formation_item_id`) REFERENCES `formation_item` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_72D338D47FF61858` FOREIGN KEY (`skills_id`) REFERENCES `skills` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `formation_item_action`
--
ALTER TABLE `formation_item_action`
  ADD CONSTRAINT `FK_9EC8D98657901725` FOREIGN KEY (`formation_item_id`) REFERENCES `formation_item` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_9EC8D9869D32F035` FOREIGN KEY (`action_id`) REFERENCES `action` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `formation_item_formation_item`
--
ALTER TABLE `formation_item_formation_item`
  ADD CONSTRAINT `FK_DEAC66A1868E2A67` FOREIGN KEY (`formation_item_source`) REFERENCES `formation_item` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_DEAC66A19F6B7AE8` FOREIGN KEY (`formation_item_target`) REFERENCES `formation_item` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `formation_item_skills`
--
ALTER TABLE `formation_item_skills`
  ADD CONSTRAINT `FK_C35436457901725` FOREIGN KEY (`formation_item_id`) REFERENCES `formation_item` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_C3543647FF61858` FOREIGN KEY (`skills_id`) REFERENCES `skills` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `formation_practical_counter_type`
--
ALTER TABLE `formation_practical_counter_type`
  ADD CONSTRAINT `FK_8EA8CCD92402E8F` FOREIGN KEY (`counter_type_value_id`) REFERENCES `counter_type_value` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_8EA8CCD95200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `formation_theoretical_counter_type`
--
ALTER TABLE `formation_theoretical_counter_type`
  ADD CONSTRAINT `FK_4B85E0E32402E8F` FOREIGN KEY (`counter_type_value_id`) REFERENCES `counter_type_value` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_4B85E0E35200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `instructor_skill_ato_user`
--
ALTER TABLE `instructor_skill_ato_user`
  ADD CONSTRAINT `FK_1EC3796530A17E02` FOREIGN KEY (`ato_user_id`) REFERENCES `ato_user` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_1EC3796555E763E7` FOREIGN KEY (`instructor_skill_id`) REFERENCES `instructor_skill` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `lesson_annotation`
--
ALTER TABLE `lesson_annotation`
  ADD CONSTRAINT `FK_234D7723847DC024` FOREIGN KEY (`ato_id`) REFERENCES `ato` (`id`);

--
-- Contraintes pour la table `media_object`
--
ALTER TABLE `media_object`
  ADD CONSTRAINT `FK_14D431323FD4DD80` FOREIGN KEY (`extra_lesson_id`) REFERENCES `extra_lesson` (`id`),
  ADD CONSTRAINT `FK_14D431325200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_14D431329D32F035` FOREIGN KEY (`action_id`) REFERENCES `action` (`id`),
  ADD CONSTRAINT `FK_14D43132CDF80196` FOREIGN KEY (`lesson_id`) REFERENCES `formation_item` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `model_aircraft`
--
ALTER TABLE `model_aircraft`
  ADD CONSTRAINT `FK_D90336CA12469DE2` FOREIGN KEY (`category_id`) REFERENCES `category_aircraft` (`id`),
  ADD CONSTRAINT `FK_D90336CA577F21F8` FOREIGN KEY (`engine_type_id`) REFERENCES `engine_type_aircraft` (`id`),
  ADD CONSTRAINT `FK_D90336CAA23B42D` FOREIGN KEY (`manufacturer_id`) REFERENCES `manufacturer_aircraft` (`id`);

--
-- Contraintes pour la table `notification`
--
ALTER TABLE `notification`
  ADD CONSTRAINT `FK_BF5476CAA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`);

--
-- Contraintes pour la table `promotion`
--
ALTER TABLE `promotion`
  ADD CONSTRAINT `FK_C11D7DD1847DC024` FOREIGN KEY (`ato_id`) REFERENCES `ato` (`id`);

--
-- Contraintes pour la table `promotion_ato_user`
--
ALTER TABLE `promotion_ato_user`
  ADD CONSTRAINT `FK_4826C3F0139DF194` FOREIGN KEY (`promotion_id`) REFERENCES `promotion` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_4826C3F030A17E02` FOREIGN KEY (`ato_user_id`) REFERENCES `ato_user` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `promotion_formation`
--
ALTER TABLE `promotion_formation`
  ADD CONSTRAINT `FK_3137F092139DF194` FOREIGN KEY (`promotion_id`) REFERENCES `promotion` (`id`),
  ADD CONSTRAINT `FK_3137F0925200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`);

--
-- Contraintes pour la table `rating_ato`
--
ALTER TABLE `rating_ato`
  ADD CONSTRAINT `FK_39D385C7847DC024` FOREIGN KEY (`ato_id`) REFERENCES `ato` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_39D385C7A32EFC6` FOREIGN KEY (`rating_id`) REFERENCES `rating` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `rating_value`
--
ALTER TABLE `rating_value`
  ADD CONSTRAINT `FK_80615708260075EB` FOREIGN KEY (`rating_type_id`) REFERENCES `rating` (`id`),
  ADD CONSTRAINT `FK_80615708F6419510` FOREIGN KEY (`media_value_id`) REFERENCES `media_object` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `resources`
--
ALTER TABLE `resources`
  ADD CONSTRAINT `FK_EF66EBAE847DC024` FOREIGN KEY (`ato_id`) REFERENCES `ato` (`id`);

--
-- Contraintes pour la table `session`
--
ALTER TABLE `session`
  ADD CONSTRAINT `FK_D044D5D41AE37126` FOREIGN KEY (`instructor_signature_id`) REFERENCES `signature` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_D044D5D45200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`),
  ADD CONSTRAINT `FK_D044D5D463D2D5DF` FOREIGN KEY (`lesson_extra_id`) REFERENCES `extra_lesson` (`id`),
  ADD CONSTRAINT `FK_D044D5D467595CFC` FOREIGN KEY (`lesson_notation_id`) REFERENCES `rating_value` (`id`),
  ADD CONSTRAINT `FK_D044D5D47F43E343` FOREIGN KEY (`arrival_airport_id`) REFERENCES `airport` (`id`),
  ADD CONSTRAINT `FK_D044D5D4846E2F5C` FOREIGN KEY (`aircraft_id`) REFERENCES `aircraft` (`id`),
  ADD CONSTRAINT `FK_D044D5D48C4FC193` FOREIGN KEY (`instructor_id`) REFERENCES `ato_user` (`id`),
  ADD CONSTRAINT `FK_D044D5D494AE086B` FOREIGN KEY (`correction_id`) REFERENCES `session` (`id`),
  ADD CONSTRAINT `FK_D044D5D4CDF80196` FOREIGN KEY (`lesson_id`) REFERENCES `formation_item` (`id`),
  ADD CONSTRAINT `FK_D044D5D4E071F843` FOREIGN KEY (`pdf_file_id`) REFERENCES `media_object` (`id`),
  ADD CONSTRAINT `FK_D044D5D4F631AB5C` FOREIGN KEY (`departure_airport_id`) REFERENCES `airport` (`id`);

--
-- Contraintes pour la table `signature`
--
ALTER TABLE `signature`
  ADD CONSTRAINT `FK_AE88014130A17E02` FOREIGN KEY (`ato_user_id`) REFERENCES `ato_user` (`id`);

--
-- Contraintes pour la table `skills`
--
ALTER TABLE `skills`
  ADD CONSTRAINT `FK_D5311670847DC024` FOREIGN KEY (`ato_id`) REFERENCES `ato` (`id`),
  ADD CONSTRAINT `FK_D5311670F31275AF` FOREIGN KEY (`rating_system_id`) REFERENCES `rating` (`id`);

--
-- Contraintes pour la table `skills_detail`
--
ALTER TABLE `skills_detail`
  ADD CONSTRAINT `FK_631971207FF61858` FOREIGN KEY (`skills_id`) REFERENCES `skills` (`id`);

--
-- Contraintes pour la table `student_formation`
--
ALTER TABLE `student_formation`
  ADD CONSTRAINT `FK_272EE03F5200282E` FOREIGN KEY (`formation_id`) REFERENCES `formation` (`id`),
  ADD CONSTRAINT `FK_272EE03FCB944F1A` FOREIGN KEY (`student_id`) REFERENCES `ato_user` (`id`);

--
-- Contraintes pour la table `type_aircraft`
--
ALTER TABLE `type_aircraft`
  ADD CONSTRAINT `FK_DE2640D5A23B42D` FOREIGN KEY (`manufacturer_id`) REFERENCES `manufacturer_aircraft` (`id`);

--
-- Contraintes pour la table `type_aircraft_model_aircraft`
--
ALTER TABLE `type_aircraft_model_aircraft`
  ADD CONSTRAINT `FK_114C446CCF77F8CD` FOREIGN KEY (`type_aircraft_id`) REFERENCES `type_aircraft` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_114C446CEA6C16B0` FOREIGN KEY (`model_aircraft_id`) REFERENCES `model_aircraft` (`id`) ON DELETE CASCADE;

--
-- Contraintes pour la table `user_app_role`
--
ALTER TABLE `user_app_role`
  ADD CONSTRAINT `FK_B2CA4BCA3B5EA2E1` FOREIGN KEY (`app_role_id`) REFERENCES `app_role` (`id`) ON DELETE CASCADE,
  ADD CONSTRAINT `FK_B2CA4BCAA76ED395` FOREIGN KEY (`user_id`) REFERENCES `user` (`id`) ON DELETE CASCADE;
COMMIT;

