INSERT INTO `digital_ambassadors_avatar` (`id`, `name`) VALUES
(1, 'Avatar 1'),
(2, 'Avatar 2'),
(3, 'Avatar 3'),
(4, 'Avatar 4'),
(5, 'Avatar 5'),
(6, 'Avatar 6'),
(7, 'Avatar 7'),
(8, 'Avatar 8');

INSERT INTO `digital_ambassadors_badge` (`id`, `name`) VALUES
(1, 'Expert'),
(2, 'Ambassadeur');

INSERT INTO `digital_ambassadors_day` (`id`, `name`, `one_stars`, `two_stars`, `three_stars`, `min_score_1`, `min_score_2`) VALUES
(1, 'Day 1', 20, 39, 59, 33, 0),
(2, 'Day 2', 60, 120, 180, 45, 55),
(3, 'Day 3', 32, 63, 95, 53, 0),
(4, 'Day 4', 47, 93, 140, 78, 0),
(5, 'Day 5', 42, 84, 126, 30, 40);

INSERT INTO `digital_ambassadors_story_steps` (`id`, `day_id`, `category`) VALUES
(1, 1, 'Définition de la transformation digitale'),
(2, 1, 'Drag and drop'),
(3, 1, 'Total Day 1'),

(4, 2, 'Les défis de la transformation digitale '),
(5, 2, 'Drag and Drop des défis de la transformation digitale'),
(6, 2, 'Quel défi majeur une entreprise ?'),
(7, 2, 'Pourquoi la sécurité des données est-elle un enjeu critique ?'),
(8, 2, 'Qu est-ce qui peut aider à surmonter la résistance au changement lors de la transformation digitale ?'),
(9, 2, 'Total Day 2'),

(10, 3, 'Avantage de la transformation digitale'),
(11, 3, 'Les opportunités de transformation digitale '),
(12, 3, 'Total Day 3'),

(13, 4, 'Les technologies émergentes '),
(14, 4, 'Qu est-ce que la réalité augmentée (RA) ?'),
(15, 4, 'Quelle est l utilisation principale de la blockchain ?'),
(16, 4, 'Qu est-ce que l intelligence artificielle (IA) ?'),
(17, 4, 'Total Day 4'),

(18, 5, 'Reskilling et upskilling'),
(19, 5, 'Quelle stratégie de formation serait la plus appropriée ?'),
(20, 5, 'Dossier Gestion des données : Approche de reskilling '),
(21, 5, 'Dossier Processus de production: Stratégie d upskilling '),
(22, 5, 'Dossier Marketing : Reskilling efficace '),
(23, 5, 'Dossier Analytics : Reskilling efficace'),
(24, 5, 'Total Day 5');

INSERT INTO `digital_ambassadors_decision` (`id`, `score1`, `score2`, `day_id`) VALUES
(1,0,0,1),
(2,10,0,1),
(3,0,0,1),
(4,5,0,1),
(5,5,0,1),
(6,5,0,1),
(7,5,0,1),
(8,5,0,1),
(9,5,0,1),
(10,5,0,1),
(11,5,0,1),
(12,5,0,1),
(13,5,0,1),
(14,5,0,1),
(15,0,5,2),
(16,0,5,2),
(17,0,5,2),
(18,0,5,2),
(19,0,5,2),
(20,0,5,2),
(21,0,5,2),
(22,0,5,2),
(23,0,5,2),
(24,0,5,2),
(25,5,5,2),
(26,5,5,2),
(27,5,5,2),
(28,5,5,2),
(29,5,5,2),
(30,5,5,2),
(31,5,5,2),
(32,5,5,2),
(33,5,5,2),
(34,5,5,2),
(35,5,5,2),
(36,5,5,2),
(37,10,0,2),
(38,0,0,2),
(39,0,0,2),
(40,0,0,2),
(41,10,0,2),
(42,0,0,2),
(43,0,0,2),
(44,0,0,2),
(45,0,0,2),
(46,0,0,2),
(47,10,0,2),
(48,0,0,2),
(49,5,0,3),
(50,0,0,3),
(51,0,0,3),
(52,0,0,3),
(53,5,0,3),
(54,0,0,3),
(55,0,0,3),
(56,0,0,3),
(57,5,0,3),
(58,0,0,3),
(59,0,0,3),
(60,5,0,3),
(61,0,0,3),
(62,5,0,3),
(63,0,0,3),
(64,5,0,3),
(65,5,0,3),
(66,5,0,3),
(67,5,0,3),
(68,5,0,3),
(69,5,0,3),
(70,5,0,3),
(71,5,0,3),
(72,5,0,3),
(73,5,0,3),
(74,5,0,3),
(75,5,0,3),
(76,5,0,3),
(77,5,0,3),
(78,5,0,3),
(79,5,0,3),
(80,5,0,4),
(81,5,0,4),
(82,5,0,4),
(83,5,0,4),
(84,5,0,4),
(85,5,0,4),
(86,5,0,4),
(87,5,0,4),
(88,5,0,4),
(89,5,0,4),
(90,5,0,4),
(91,5,0,4),
(92,5,0,4),
(93,5,0,4),
(94,5,0,4),
(95,5,0,4),
(96,5,0,4),
(97,5,0,4),
(98,5,0,4),
(99,5,0,4),
(100,5,0,4),
(101,5,0,4),
(102,5,0,4),
(103,5,0,4),
(104,5,0,4),
(105,0,0,4),
(106,10,0,4),
(107,0,0,4),
(108,0,0,4),
(109,10,0,4),
(110,0,0,4),
(111,0,0,4),
(112,0,0,4),
(113,10,0,4),
(114,5,0,5),
(115,5,0,5),
(116,5,0,5),
(117,5,0,5),
(118,5,0,5),
(119,5,0,5),
(120,5,0,5),
(121,5,0,5),
(122,5,0,5),
(123,5,0,5),
(124,0,0,5),
(125,10,0,5),
(126,0,0,5),
(127,0,5,5),
(128,0,5,5),
(129,0,5,5),
(130,0,5,5),
(131,0,0,5),
(132,0,0,5),
(133,0,0,5),
(134,0,0,5),
(135,0,5,5),
(136,0,5,5),
(137,0,5,5),
(138,0,5,5),
(139,0,0,5),
(140,0,0,5),
(141,0,0,5),
(142,0,0,5),
(143,0,5,5),
(144,0,5,5),
(145,0,5,5),
(146,0,5,5),
(147,0,0,5),
(148,0,0,5),
(149,0,0,5),
(150,0,0,5),
(151,0,5,5),
(152,0,5,5),
(153,0,5,5),
(154,0,5,5),
(155,0,0,5),
(156,0,0,5),
(157,0,0,5),
(158,0,0,5);