INSERT INTO `pv_challenge_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');

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

INSERT INTO `pv_challenge_day` (`id`, `name`, `one_stars`, `two_stars`, `three_stars`, `min_score_1`, `min_score_2`) VALUES
(1, 'Day 1', 40, 80, 120, 68, 0),
(2, 'Day 2', 75, 150, 225, 125, 0),
(3, 'Day 3', 75, 150, 225, 40, 85),
(4, 'Day 4', 35, 71, 106, 0, 59),
(5, 'Day 5', 27, 54, 81, 0, 45);

INSERT INTO `pv_challenge_story_steps` (`id`, `day_id`, `category`) VALUES
(1, 1, 'Quiz'),
(2, 1, 'Choix parmi liste'),
(3, 1, 'Drag and drop'),
(4, 1, 'Total Day 1'),

(5, 2, 'Quiz'),
(6, 2, 'Drag and drop'),
(7, 2, 'Classer les différentes activités'),
(8, 2, 'Quiz'),
(9, 2, 'Total Day 2'),

(10, 3, 'Choix parmi liste'),
(11, 3, 'Fiche de notification'),
(12, 3, 'Quiz'),
(13, 3, 'Choix parmi liste'),
(14, 3, 'Quiz'),
(15, 3, 'Total Day 3'),

(16, 4, 'Traitement des notifications téléphone'),
(17, 4, 'Traitement des notifications email'),
(18, 4, 'Traitement des notifications papier'),
(19, 4, 'Quiz'),
(20, 4, 'Total Day 4'),

(21, 5, 'Résumé médecin'),
(22, 5, 'Résumé délégué médical'),
(23, 5, 'Résumé unité PHV Interne'),
(24, 5, 'Résumé CNPV'),
(25, 5, 'Total Day 5');

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