INSERT INTO `sustainup_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 `sustainup_badge` (`id`, `name`) VALUES
(1, 'Expert'),
(2, 'Ambassadeur');

INSERT INTO `sustainup_day` (`id`, `name`, `one_stars`, `two_stars`, `three_stars`, `min_score_1`, `min_score_2`) VALUES
(1, 'Day 1', 50, 99, 149, 68, 15),
(2, 'Day 2', 126, 252, 378, 145, 65),
(3, 'Day 3', 54, 108, 162, 90, 0),
(4, 'Day 4', 129, 258, 387, 95, 120),
(5, 'Day 5', 77, 153, 230, 100, 28),
(6, 'Day 6', 111, 222, 333, 108, 78);

INSERT INTO `sustainup_story_steps` (`id`, `day_id`, `category`) VALUES
(1, 1, 'QCM DIAGNOSTIC DE DURABILITE'),
(2, 1, 'Classement DIAGNOSTIC DE DURABILITE'),
(3, 1, 'Drag and drop'),
(4, 1, 'Total Day 1'),

(5, 2, 'Classement ELABORATION DE LA STRATEGIE DE DURABILITE'),
(6, 2, 'QCM ELABORATION DE LA STRATEGIE DE DURABILITE'),
(7, 2, 'Drag and drop'),
(8, 2, 'Total Day 2'),

(9, 3, 'Multiselection Des raisons expliquant l\'importance d\'adopter des pratiques durables'),
(10, 3, 'Multiselection Quelques actions pour intégrer la durabilité dans les opérations de l\'entreprise'),
(11, 3, 'Drag and drop'),
(12, 3, 'Total Day 3'),

(13, 4, 'QCM IMPLICATION DES PARTIES PRENANTES'),
(14, 4, 'Drag and drop'),
(15, 4, 'Dossier Attentes des Employés'),
(16, 4, 'Dossier Attentes des Clients'),
(17, 4, 'Dossier Attentes des Fournisseurs'),
(18, 4, 'Dossier Attenteas des Investisseurs'),
(19, 4, 'Dossier Attentes de la Communauté locale'),
(20, 4, 'Dossier Attentes de l\'Etat et des autorités réglementaires'),
(21, 4, 'Drag and drop'),
(22, 4, 'Total Day 4'),

(23, 5, 'Multiselection Notions sur la mesure de performance et le reporting de durabilité au sein de l\'entreprise'),
(24, 5, 'Drag and drop'),
(25, 5, 'Dossier Normes internationales de reporting'),
(26, 5, 'Dossier Attentes des Clients'),
(27, 5, 'Dossier Attentes des Fournisseurs'),
(28, 5, 'Total Day 5'),

(29, 6, 'QCM'),
(30, 6, 'Multiselection Notions liés aux risques, tendances amplificatrices et aux opportunités de durabilité'),
(31, 6, 'Drag and drop'),
(32, 6, 'Total Day 6');

INSERT INTO `sustainup_decision` (`id`, `score1`, `score2`, `day_id`) VALUES
(1,0,0,1),
(2,0,0,1),
(3,10,0,1),
(4,0,0,1),
(5,0,0,1),
(6,10,0,1),
(7,0,0,1),
(8,0,0,1),
(9,10,0,1),
(10,0,0,1),
(11,0,0,1),
(12,0,0,1),
(13,0,0,1),
(14,0,0,1),
(15,0,0,1),
(16,10,0,1),
(17,0,5,1),
(18,0,5,1),
(19,0,5,1),
(20,0,5,1),
(21,0,5,1),
(22,0,5,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,5,0,1),
(37,5,0,1),
(38,5,0,1),
(39,5,0,1),
(40,5,0,1),
(41,5,0,1),
(42,0,5,2),
(43,0,5,2),
(44,0,5,2),
(45,0,5,2),
(46,0,5,2),
(47,0,5,2),
(48,10,0,2),
(49,10,0,2),
(50,0,0,2),
(51,10,0,2),
(52,0,0,2),
(53,10,0,2),
(54,10,0,2),
(55,0,0,2),
(56,10,0,2),
(57,0,0,2),
(58,10,0,2),
(59,10,0,2),
(60,10,0,2),
(61,0,0,2),
(62,10,0,2),
(63,0,0,2),
(64,10,0,2),
(65,0,0,2),
(66,10,0,2),
(67,10,0,2),
(68,0,0,2),
(69,10,0,2),
(70,0,0,2),
(71,10,0,2),
(72,10,0,2),
(73,0,0,2),
(74,10,0,2),
(75,10,0,2),
(76,0,0,2),
(77,10,0,2),
(78,0,0,2),
(79,5,5,2),
(80,5,5,2),
(81,5,5,2),
(82,5,5,2),
(83,5,5,2),
(84,5,5,2),
(85,5,5,2),
(86,5,5,2),
(87,5,5,2),
(88,5,5,2),
(89,5,5,2),
(90,5,5,2),
(91,5,5,2),
(92,5,5,2),
(93,5,5,2),
(94,5,5,2),
(95,5,5,2),
(96,5,5,2),
(97,5,5,2),
(98,5,5,2),
(99,5,0,3),
(100,0,0,3),
(101,0,0,3),
(102,0,0,3),
(103,0,0,3),
(104,5,0,3),
(105,0,0,3),
(106,0,0,3),
(107,0,0,3),
(108,0,0,3),
(109,5,0,3),
(110,0,0,3),
(111,0,0,3),
(112,0,0,3),
(113,5,0,3),
(114,0,0,3),
(115,5,0,3),
(116,0,0,3),
(117,0,0,3),
(118,0,0,3),
(119,0,0,3),
(120,5,0,3),
(121,0,0,3),
(122,0,0,3),
(123,0,0,3),
(124,0,0,3),
(125,5,0,3),
(126,0,0,3),
(127,0,0,3),
(128,0,0,3),
(129,5,0,3),
(130,0,0,3),
(131,5,0,3),
(132,5,0,3),
(133,5,0,3),
(134,5,0,3),
(135,5,0,3),
(136,5,0,3),
(137,5,0,3),
(138,5,0,3),
(139,5,0,3),
(140,5,0,3),
(141,5,0,3),
(142,5,0,3),
(143,5,0,3),
(144,5,0,3),
(145,5,0,3),
(146,5,0,3),
(147,5,0,3),
(148,5,0,3),
(149,5,0,3),
(150,5,0,3),
(151,5,0,3),
(152,5,0,3),
(153,5,0,3),
(154,5,0,3),
(155,5,0,3),
(156,5,0,3),
(157,5,0,3),
(158,5,0,3),
(159,0,0,4),
(160,0,0,4),
(161,0,0,4),
(162,0,0,4),
(163,10,0,4),
(164,0,0,4),
(165,0,0,4),
(166,0,0,4),
(167,10,0,4),
(168,5,0,4),
(169,5,0,4),
(170,5,0,4),
(171,5,0,4),
(172,5,0,4),
(173,5,0,4),
(174,5,0,4),
(175,5,0,4),
(176,5,0,4),
(177,5,0,4),
(178,0,5,4),
(179,0,5,4),
(180,0,5,4),
(181,0,5,4),
(182,0,0,4),
(183,0,0,4),
(184,0,0,4),
(185,0,0,4),
(186,0,5,4),
(187,0,5,4),
(188,0,5,4),
(189,0,5,4),
(190,0,0,4),
(191,0,0,4),
(192,0,0,4),
(193,0,0,4),
(194,0,5,4),
(195,0,5,4),
(196,0,5,4),
(197,0,5,4),
(198,0,0,4),
(199,0,0,4),
(200,0,0,4),
(201,0,5,4),
(202,0,5,4),
(203,0,5,4),
(204,0,5,4),
(205,0,0,4),
(206,0,0,4),
(207,0,0,4),
(208,0,5,4),
(209,0,5,4),
(210,0,5,4),
(211,0,5,4),
(212,0,0,4),
(213,0,0,4),
(214,0,0,4),
(215,0,5,4),
(216,0,5,4),
(217,0,5,4),
(218,0,5,4),
(219,0,0,4),
(220,0,0,4),
(221,0,0,4),
(222,5,5,4),
(223,5,5,4),
(224,5,5,4),
(225,5,5,4),
(226,5,5,4),
(227,5,5,4),
(228,5,5,4),
(229,5,5,4),
(230,5,5,4),
(231,5,5,4),
(232,5,5,4),
(233,5,5,4),
(234,5,5,4),
(235,5,5,4),
(236,5,5,4),
(237,5,5,4),
(238,5,5,4),
(239,5,5,4),
(240,5,5,4),
(241,5,5,4),
(242,5,5,4),
(243,5,5,4),
(244,5,5,4),
(245,5,5,4),
(246,0,0,5),
(247,0,0,5),
(248,0,0,5),
(249,5,0,5),
(250,0,0,5),
(251,5,0,5),
(252,0,0,5),
(253,0,0,5),
(254,0,0,5),
(255,0,0,5),
(256,5,0,5),
(257,0,0,5),
(258,0,0,5),
(259,0,0,5),
(260,0,0,5),
(261,5,0,5),
(262,0,0,5),
(263,5,0,5),
(264,0,0,5),
(265,0,0,5),
(266,0,0,5),
(267,0,0,5),
(268,0,0,5),
(269,5,0,5),
(270,5,0,5),
(271,5,0,5),
(272,5,0,5),
(273,5,0,5),
(274,5,0,5),
(275,5,0,5),
(276,5,0,5),
(277,5,0,5),
(278,5,0,5),
(279,5,0,5),
(280,5,0,5),
(281,5,0,5),
(282,5,0,5),
(283,5,0,5),
(284,5,0,5),
(285,5,0,5),
(286,5,0,5),
(287,5,0,5),
(288,5,0,5),
(289,5,0,5),
(290,5,0,5),
(291,5,0,5),
(292,5,0,5),
(293,5,0,5),
(294,5,0,5),
(295,5,0,5),
(296,5,0,5),
(297,5,0,5),
(298,5,0,5),
(299,5,0,5),
(300,5,0,5),
(301,5,0,5),
(302,5,0,5),
(303,5,0,5),
(304,0,5,5),
(305,0,5,5),
(306,0,5,5),
(307,0,0,5),
(308,0,0,5),
(309,0,0,5),
(310,0,0,5),
(311,0,0,5),
(312,0,5,5),
(313,0,5,5),
(314,0,5,5),
(315,0,5,5),
(316,0,0,5),
(317,0,0,5),
(318,0,0,5),
(319,0,0,5),
(320,0,5,5),
(321,0,5,5),
(322,0,5,5),
(323,0,5,5),
(324,0,0,5),
(325,0,0,5),
(326,0,0,5),
(327,10,0,6),
(328,0,0,6),
(329,0,0,6),
(330,0,0,6),
(331,0,0,6),
(332,5,0,6),
(333,0,0,6),
(334,5,0,6),
(335,0,0,6),
(336,0,0,6),
(337,0,0,6),
(338,10,0,6),
(339,0,0,6),
(340,0,0,6),
(341,5,0,6),
(342,0,0,6),
(343,0,0,6),
(344,5,0,6),
(345,0,0,6),
(346,0,0,6),
(347,0,0,6),
(348,0,0,6),
(349,0,0,6),
(350,5,0,6),
(351,5,0,6),
(352,0,0,6),
(353,0,0,6),
(354,0,0,6),
(355,5,0,6),
(356,0,0,6),
(357,0,0,6),
(358,0,0,6),
(359,0,0,6),
(360,0,0,6),
(361,5,0,6),
(362,0,0,6),
(363,5,5,6),
(364,5,5,6),
(365,5,5,6),
(366,5,5,6),
(367,5,5,6),
(368,5,5,6),
(369,5,5,6),
(370,5,5,6),
(371,5,5,6),
(372,5,5,6),
(373,5,5,6),
(374,5,5,6),
(375,5,5,6),
(376,5,5,6),
(377,5,5,6),
(378,5,5,6),
(379,5,5,6),
(380,5,5,6),
(381,5,5,6),
(382,5,5,6),
(383,5,5,6),
(384,5,5,6),
(385,5,5,6),
(386,5,5,6),
(387,5,5,6),
(388,5,5,6),
(389,5,5,6),
(390,5,5,6),
(391,5,5,6),
(392,5,5,6),
(393,5,5,6);