
INSERT INTO `pv_avatar` (`id`, `name`) VALUES
(1, 'Avatar 1'),
(2, 'Avatar 2'),
(3, 'Avatar 3'),
(4, 'Avatar 4');


INSERT INTO `pv_badge` (`id`, `name`) VALUES
(1, 'Badge Notification'),
(2, 'Badge Imputabilité'),
(3, 'Badge OMS');



INSERT INTO `pv_country` (`id`, `name`) VALUES
(1, 'Sénégal'),
(2, 'Burkina Faso'),
(3, 'Algérie'),
(4, 'Liban'),
(5, 'Cameroun'),
(6, 'Burundi'),
(7, 'Haiti'),
(8, 'Côte d Ivoire'),
(9, 'Niger'),
(10, 'Mali'),
(11, 'Rep. Dém. Du Congo'),
(12, 'Tunisie'),
(13, 'Suisse'),
(14, 'Maroc');


INSERT INTO `pv_day` (`id`, `name`, `one_stars`, `two_stars`, `three_stars`) VALUES
(1, 'Day 1', 73, 146, 220),
(2, 'Day 2', 28, 56, 85),
(3, 'Day 3', 48, 96, 145),
(4, 'Day 4', 46, 92, 140),
(5, 'Day 5', 40, 80, 120),
(6, 'Day 6', 40, 80, 120),
(7, 'Day 7', 80, 160, 240),
(8, 'Day 8', 53, 106, 160),
(9, 'Day 9', 43, 86, 130),
(10, 'Day 10', 46, 92, 140);


INSERT INTO `pv_story_steps` (`id`, `day_id`, `category`) VALUES
(1, 1, 'Financement'),
(2, 1, 'Réglementation et procédures'),
(3, 1, 'Equipement'),
(4, 1, 'Ressources humaines'),
(5, 1, 'DAY 1'),
(6, 2, 'DAY 2'),
(7, 3, 'Pharmacovigilance team (WHO) Geneva'),
(8, 3, 'Upssala Monitoring Centre'),
(9, 3, 'Rabat collaborating center RCC'),
(10, 3, 'Les bailleurs de fonds'),
(11, 3, 'Les sociétés savantes '),
(12, 3, 'Les bureaux régionaux et nationaux de de l OMS '),
(13, 3, 'DAY 3'),
(14, 4, 'DAY 4'),
(15, 4, 'DAY 4'),
(16, 5, 'DAY 5'),
(17, 6, 'DAY 6'),
(18, 6, 'DAY 6'),
(19, 6, 'DAY 6'),
(20, 6, 'DAY 6'),
(21, 7, 'DAY 7'),
(22, 7, 'DAY 7'),
(23, 8, 'DAY 8'),
(24, 8, 'DAY 8'),
(25, 8, 'DAY 8'),
(26, 9, 'DAY 9'),
(27, 9, 'DAY 9'),
(28, 9, 'DAY 9'),
(29, 9, 'DAY 9'),
(30, 9, 'DAY 9'),
(31, 9, 'DAY 9'),
(32, 9, 'DAY 9'),
(33, 9, 'DAY 9'),
(34, 9, 'DAY 9'),
(35, 10, 'DAY 10'),
(36, 10, 'DAY 10'),
(37, 10, 'DAY 10'),
(38, 10, 'DAY 10'),
(39, 10, 'DAY 10'),
(40, 10, 'DAY 10'),
(41, 10, 'DAY 10');

INSERT INTO `pv_decision` (`id`, `score1`, `score2`, `score3`, `budget`, `day_id`) VALUES
(1, 5, 0, 0, 5000, 1),
(2, 5, 0, 0, 4000, 1),
(3, 5, 0, 0, 1000, 1),
(4, 5, 0, 0, 2000, 1),
(5, 5, 0, 0, 3000, 1),
(6, 3, 0, 0, 5000, 1),
(7, 3, 0, 0, 4000, 1),
(8, 3, 0, 0, 2000, 1),
(9, 3, 0, 0, 3000, 1),
(10, 3, 0, 0, 1000, 1),
(11, 0, 0, 0, 3000, 1),
(12, 0, 0, 0, 1000, 1),
(13, 0, 0, 0, 5000, 1),
(14, 0, 0, 0, 2000, 1),
(15, 0, 0, 0, 4000, 1),
(16, 15, 0, 0, 35, 1),
(17, 15, 0, 0, 40, 1),
(18, 10, 0, 0, 35, 1),
(19, 10, 0, 0, 20, 1),
(20, 10, 0, 0, 20, 1),
(21, 5, 0, 0, 40, 1),
(22, 5, 0, 0, 20, 1),
(23, 5, 0, 0, 20, 1),
(24, 5, 0, 0, 35, 1),
(25, 5, 0, 0, 35, 1),
(26, 1, 0, 0, 20, 1),
(27, 1, 0, 0, 35, 1),
(28, 1, 0, 0, 40, 1),
(29, 1, 0, 0, 20, 1),
(30, 1, 0, 0, 35, 1),
(31, 10, 0, 0, -4000, 1),
(32, 15, 0, 0, -17000, 1),
(33, 10, 0, 0, -500, 1),
(34, 10, 0, 0, -500, 1),
(35, 10, 0, 0, -2000, 1),
(36, 10, 0, 0, -1000, 1),
(37, 15, 0, 0, -10000, 1),
(38, 5, 0, 0, -4000, 1),
(39, 5, 0, 0, -2000, 1),
(40, 5, 0, 0, -8000, 1),
(41, 5, 0, 0, -3500, 1),
(42, 5, 0, 0, -1500, 1),
(43, 5, 0, 0, -16000, 1),
(44, 1, 0, 0, -700, 1),
(45, 0, 0, 0, -1500, 1),
(46, 0, 0, 0, -10000, 1),
(47, 1, 0, 0, -1600, 1),
(48, 0, 0, 0, -20000, 1),
(49, 1, 0, 0, -1200, 1),
(50, 15, 0, 0, -15000, 1),
(51, 10, 0, 0, -7000, 1),
(52, 10, 0, 0, -2000, 1),
(53, 10, 0, 0, -7000, 1),
(54, 10, 0, 0, -9000, 1),
(55, 5, 0, 0, -13000, 1),
(56, 5, 0, 0, -3000, 1),
(57, 5, 0, 0, -8000, 1),
(58, 5, 0, 0, -10000, 1),
(59, 5, 0, 0, -3000, 1),
(60, 5, 0, 0, -3000, 1),
(61, 1, 0, 0, -2000, 1),
(62, 1, 0, 0, -9000, 1),
(63, 1, 0, 0, -2000, 1),
(64, 1, 0, 0, -20000, 1),
(65, 1, 0, 0, -7000, 1),
(66, 13, 0, 0, 0, 2),
(67, 7, 0, 0, 0, 2),
(68, 3, 0, 0, 0, 2),
(69, 12, 0, 0, 0, 2),
(70, 7, 0, 0, 0, 2),
(71, 1, 0, 0, 0, 2),
(72, 12, 0, 0, 0, 2),
(73, 7, 0, 0, 0, 2),
(74, 3, 0, 0, 0, 2),
(75, 12, 0, 0, 0, 2),
(76, 8, 0, 0, 0, 2),
(77, 3, 0, 0, 0, 2),
(78, 12, 0, 0, 0, 2),
(79, 7, 0, 0, 0, 2),
(80, 3, 0, 0, 0, 2),
(81, 12, 0, 0, 0, 2),
(82, 7, 0, 0, 0, 2),
(83, 3, 0, 0, 0, 2),
(84, 12, 0, 0, 0, 2),
(85, 7, 0, 0, 0, 2),
(86, 3, 0, 0, 0, 2),
(87, 6, 0, 0, 0, 3),
(88, 6, 0, 0, 0, 3),
(89, 6, 0, 0, 0, 3),
(90, 0, 0, 0, 0, 3),
(91, 6, 0, 0, 0, 3),
(92, 0, 0, 0, 0, 3),
(93, 0, 0, 0, 0, 3),
(94, 6, 0, 0, 0, 3),
(95, 0, 0, 0, 0, 3),
(96, 6, 0, 0, 0, 3),
(97, 6, 0, 0, 0, 3),
(98, 6, 0, 0, 0, 3),
(99, 7, 0, 0, 0, 3),
(100, 0, 0, 0, 0, 3),
(101, 6, 0, 0, 0, 3),
(102, 6, 0, 0, 0, 3),
(103, 0, 0, 0, 0, 3),
(104, 0, 0, 0, 0, 3),
(105, 6, 0, 0, 0, 3),
(106, 6, 0, 0, 0, 3),
(107, 0, 0, 0, 0, 3),
(108, 0, 0, 0, 0, 3),
(109, 6, 0, 0, 0, 3),
(110, 6, 0, 0, 0, 3),
(111, 6, 0, 0, 0, 3),
(112, 0, 0, 0, 0, 3),
(113, 6, 0, 0, 0, 3),
(114, 6, 0, 0, 0, 3),
(115, 6, 0, 0, 0, 3),
(116, 0, 0, 0, 0, 3),
(117, 6, 0, 0, 0, 3),
(118, 6, 0, 0, 0, 3),
(119, 6, 0, 0, 0, 3),
(120, 6, 0, 0, 0, 3),
(121, 0, 0, 0, 0, 3),
(122, 6, 0, 0, 0, 3),
(123, 0, 10, 0, 0, 4),
(124, 0, 10, 0, 0, 4),
(125, 0, 10, 0, 0, 4),
(126, 0, 10, 0, 0, 4),
(127, 0, 10, 0, 0, 4),
(128, 0, 10, 0, 0, 4),
(129, 0, 10, 0, 0, 4),
(130, 0, 10, 0, 0, 4),
(131, 0, 10, 0, 0, 4),
(132, 0, 10, 0, 0, 4),
(133, 0, 10, 0, 0, 4),
(134, 0, 10, 0, 0, 4),
(135, 0, 0, 0, 0, 4),
(136, 0, 0, 0, 0, 4),
(137, 0, 0, 0, 0, 4),
(138, 0, 0, 0, 0, 4),
(139, 0, 0, 0, 0, 4),
(140, 0, 0, 0, 0, 4),
(141, 0, 0, 0, 0, 4),
(142, 0, 0, 0, 0, 4),
(143, 0, 0, 0, 0, 4),
(144, 0, 0, 0, 0, 4),
(145, 0, 0, 0, 0, 4),
(146, 0, 0, 0, 0, 4),
(147, 0, 0, 0, 0, 4),
(148, 0, 10, 0, 0, 4),
(149, 0, 0, 0, 0, 4),
(150, 0, 10, 0, 0, 4),
(151, 0, 0, 0, 0, 4),
(152, 0, 0, 0, 0, 4),
(153, 0, 10, 0, 0, 5),
(154, 0, 10, 0, 0, 5),
(155, 0, 10, 0, 0, 5),
(156, 0, 10, 0, 0, 5),
(157, 0, 10, 0, 0, 5),
(158, 0, 10, 0, 0, 5),
(159, 0, 10, 0, 0, 5),
(160, 0, 10, 0, 0, 5),
(161, 0, 10, 0, 0, 5),
(162, 0, 10, 0, 0, 5),
(163, 0, 10, 0, 0, 5),
(164, 0, 10, 0, 0, 5),
(165, 0, 5, 0, 0, 5),
(166, 0, 5, 0, 0, 5),
(167, 0, 5, 0, 0, 5),
(168, 0, 5, 0, 0, 5),
(169, 0, 5, 0, 0, 5),
(170, 0, 5, 0, 0, 5),
(171, 0, 5, 0, 0, 5),
(172, 0, 5, 0, 0, 5),
(173, 0, 5, 0, 0, 5),
(174, 0, 5, 0, 0, 5),
(175, 0, 5, 0, 0, 5),
(176, 0, 5, 0, 0, 5),
(177, 0, 0, 0, 0, 5),
(178, 0, 0, 0, 0, 5),
(179, 0, 0, 0, 0, 5),
(180, 0, 0, 0, 0, 5),
(181, 0, 0, 0, 0, 5),
(182, 0, 0, 0, 0, 5),
(183, 0, 0, 0, 0, 5),
(184, 0, 0, 0, 0, 5),
(185, 0, 0, 0, 0, 5),
(186, 0, 0, 0, 0, 5),
(187, 0, 0, 0, 0, 5),
(188, 0, 0, 0, 0, 5),
(189, 0, 0, 0, 0, 5),
(190, 0, 0, 0, 0, 5),
(191, 0, 0, 0, 0, 5),
(192, 0, 0, 0, 0, 5),
(193, 0, 6, 0, 0, 6),
(194, 0, 0, 0, 0, 6),
(195, 0, 6, 0, 0, 6),
(196, 0, 0, 0, 0, 6),
(197, 0, 6, 0, 0, 6),
(198, 0, 0, 0, 0, 6),
(199, 0, 6, 0, 0, 6),
(200, 0, 0, 0, 0, 6),
(201, 0, 6, 0, 0, 6),
(202, 0, 0, 0, 0, 6),
(203, 0, 6, 0, 0, 6),
(204, 0, 0, 0, 0, 6),
(205, 0, 6, 0, 0, 6),
(206, 0, 0, 0, 0, 6),
(207, 0, 6, 0, 0, 6),
(208, 0, 0, 0, 0, 6),
(209, 0, 0, 0, 0, 6),
(210, 0, 6, 0, 0, 6),
(211, 0, 6, 0, 0, 6),
(212, 0, 0, 0, 0, 6),
(213, 0, 6, 0, 0, 6),
(214, 0, 0, 0, 0, 6),
(215, 0, 6, 0, 0, 6),
(216, 0, 0, 0, 0, 6),
(217, 0, 6, 0, 0, 6),
(218, 0, 0, 0, 0, 6),
(219, 0, 6, 0, 0, 6),
(220, 0, 0, 0, 0, 6),
(221, 0, 6, 0, 0, 6),
(222, 0, 0, 0, 0, 6),
(223, 0, 6, 0, 0, 6),
(224, 0, 0, 0, 0, 6),
(225, 0, 0, 0, 0, 6),
(226, 0, 6, 0, 0, 6),
(227, 0, 6, 0, 0, 6),
(228, 0, 0, 0, 0, 6),
(229, 0, 6, 0, 0, 6),
(230, 0, 0, 0, 0, 6),
(231, 0, 0, 0, 0, 6),
(232, 0, 6, 0, 0, 6),
(233, 0, 0, 1, 0, 7),
(234, 0, 0, 1, 0, 7),
(235, 0, 0, 1, 0, 7),
(236, 0, 0, 1, 0, 7),
(237, 0, 0, 1, 0, 7),
(238, 0, 0, 1, 0, 7),
(239, 0, 0, 1, 0, 7),
(240, 0, 0, 1, 0, 7),
(241, 0, 0, 1, 0, 7),
(242, 0, 0, 1, 0, 7),
(243, 0, 0, 1, 0, 7),
(244, 0, 0, 1, 0, 7),
(245, 0, 0, 1, 0, 7),
(246, 0, 0, 1, 0, 7),
(247, 0, 0, 1, 0, 7),
(248, 0, 0, 1, 0, 7),
(249, 0, 0, 1, 0, 7),
(250, 0, 0, 1, 0, 7),
(251, 0, 0, 1, 0, 7),
(252, 0, 0, 1, 0, 7),
(253, 0, 0, 1, 0, 7),
(254, 0, 0, 1, 0, 7),
(255, 0, 0, 0, 0, 7),
(256, 0, 0, 0, 0, 7),
(257, 0, 0, 0, 0, 7),
(258, 0, 0, 0, 0, 7),
(259, 0, 0, 0, 0, 7),
(260, 0, 0, 0, 0, 7),
(261, 0, 0, 0, 0, 7),
(262, 0, 0, 0, 0, 7),
(263, 0, 0, 2, 0, 7),
(264, 0, 0, 2, 0, 7),
(265, 0, 0, 0, 0, 7),
(266, 0, 0, 0, 0, 7),
(267, 0, 0, 0, 0, 7),
(268, 0, 0, 0, 0, 7),
(269, 0, 0, 0, 0, 7),
(270, 0, 0, 0, 0, 7),
(271, 0, 0, 0, 0, 7),
(272, 0, 0, 0, 0, 7),
(273, 0, 0, 1, 0, 7),
(274, 0, 0, 1, 0, 7),
(275, 0, 0, 1, 0, 7),
(276, 0, 0, 1, 0, 7),
(277, 0, 0, 1, 0, 7),
(278, 0, 0, 1, 0, 7),
(279, 0, 0, 1, 0, 7),
(280, 0, 0, 1, 0, 7),
(281, 0, 0, 1, 0, 7),
(282, 0, 0, 1, 0, 7),
(283, 0, 0, 1, 0, 7),
(284, 0, 0, 1, 0, 7),
(285, 0, 0, 1, 0, 7),
(286, 0, 0, 1, 0, 7),
(287, 0, 0, 1, 0, 7),
(288, 0, 0, 1, 0, 7),
(289, 0, 0, 1, 0, 7),
(290, 0, 0, 1, 0, 7),
(291, 0, 0, 1, 0, 7),
(292, 0, 0, 1, 0, 7),
(293, 0, 0, 1, 0, 7),
(294, 0, 0, 1, 0, 7),
(295, 0, 0, 1, 0, 7),
(296, 0, 0, 1, 0, 7),
(297, 0, 0, 1, 0, 7),
(298, 0, 0, 1, 0, 7),
(299, 0, 0, 1, 0, 7),
(300, 0, 0, 1, 0, 7),
(301, 0, 0, 1, 0, 7),
(302, 0, 0, 1, 0, 7),
(303, 0, 0, 2, 0, 7),
(304, 0, 0, 2, 0, 7),
(305, 0, 0, 2, 0, 7),
(306, 0, 0, 2, 0, 7),
(307, 0, 0, 2, 0, 7),
(308, 0, 0, 2, 0, 7),
(309, 0, 0, 2, 0, 7),
(310, 0, 0, 2, 0, 7),
(311, 0, 0, 2, 0, 7),
(312, 0, 0, 2, 0, 7),
(313, 0, 0, 2, 0, 7),
(314, 0, 0, 2, 0, 7),
(315, 0, 0, 0, 0, 7),
(316, 0, 0, 0, 0, 7),
(317, 0, 0, 0, 0, 7),
(318, 0, 0, 0, 0, 7),
(319, 0, 0, 0, 0, 7),
(320, 0, 0, 0, 0, 7),
(321, 0, 0, 0, 0, 7),
(322, 0, 0, 0, 0, 7),
(323, 0, 0, 2, 0, 7),
(324, 0, 0, 2, 0, 7),
(325, 0, 0, 2, 0, 7),
(326, 0, 0, 2, 0, 7),
(327, 0, 0, 2, 0, 7),
(328, 0, 0, 2, 0, 7),
(329, 0, 0, 2, 0, 7),
(330, 0, 0, 2, 0, 7),
(331, 0, 0, 2, 0, 7),
(332, 0, 0, 2, 0, 7),
(333, 0, 0, 2, 0, 7),
(334, 0, 0, 2, 0, 7),
(335, 0, 0, 2, 0, 7),
(336, 0, 0, 2, 0, 7),
(337, 0, 0, 2, 0, 7),
(338, 0, 0, 2, 0, 7),
(339, 0, 0, 2, 0, 7),
(340, 0, 0, 2, 0, 7),
(341, 0, 0, 2, 0, 7),
(342, 0, 0, 2, 0, 7),
(343, 0, 0, 2, 0, 7),
(344, 0, 0, 2, 0, 7),
(345, 0, 0, 2, 0, 7),
(346, 0, 0, 2, 0, 7),
(347, 0, 0, 2, 0, 7),
(348, 0, 0, 2, 0, 7),
(349, 0, 0, 2, 0, 7),
(350, 0, 0, 2, 0, 7),
(351, 0, 0, 2, 0, 7),
(352, 0, 0, 2, 0, 7),
(353, 0, 0, 2, 0, 7),
(354, 0, 0, 2, 0, 7),
(355, 0, 0, 2, 0, 7),
(356, 0, 0, 2, 0, 7),
(357, 0, 0, 2, 0, 7),
(358, 0, 0, 2, 0, 7),
(359, 0, 0, 2, 0, 7),
(360, 0, 0, 2, 0, 7),
(361, 0, 0, 2, 0, 7),
(362, 0, 0, 2, 0, 7),
(363, 0, 0, 2, 0, 7),
(364, 0, 0, 2, 0, 7),
(365, 0, 0, 2, 0, 7),
(366, 0, 0, 2, 0, 7),
(367, 0, 0, 2, 0, 7),
(368, 0, 0, 2, 0, 7),
(369, 0, 0, 2, 0, 7),
(370, 0, 0, 2, 0, 7),
(371, 0, 0, 2, 0, 7),
(372, 0, 0, 2, 0, 7),
(373, 0, 0, 2, 0, 7),
(374, 0, 0, 2, 0, 7),
(375, 0, 0, 2, 0, 7),
(376, 0, 0, 2, 0, 7),
(377, 0, 0, 2, 0, 7),
(378, 0, 0, 2, 0, 7),
(379, 0, 0, 2, 0, 7),
(380, 0, 0, 2, 0, 7),
(381, 0, 0, 2, 0, 7),
(382, 0, 0, 2, 0, 7),
(383, 0, 0, 2, 0, 7),
(384, 0, 0, 2, 0, 7),
(385, 0, 0, 2, 0, 7),
(386, 0, 0, 2, 0, 7),
(387, 0, 0, 2, 0, 7),
(388, 0, 0, 2, 0, 7),
(389, 0, 0, 2, 0, 7),
(390, 0, 0, 2, 0, 7),
(391, 0, 0, 2, 0, 7),
(392, 0, 0, 2, 0, 7),
(393, 0, 0, 2, 0, 7),
(394, 0, 0, 2, 0, 7),
(395, 0, 0, 2, 0, 7),
(396, 0, 0, 2, 0, 7),
(397, 0, 0, 2, 0, 7),
(398, 0, 0, 2, 0, 7),
(399, 0, 0, 2, 0, 7),
(400, 0, 0, 2, 0, 7),
(401, 0, 0, 2, 0, 7),
(402, 0, 0, 2, 0, 7),
(403, 0, 0, 10, 0, 8),
(404, 0, 0, 10, 0, 8),
(405, 0, 0, 10, 0, 8),
(406, 0, 0, 10, 0, 8),
(407, 0, 0, 10, 0, 8),
(408, 0, 0, 10, 0, 8),
(409, 0, 0, 10, 0, 8),
(410, 0, 0, 9, 0, 8),
(411, 0, 0, 9, 0, 8),
(412, 0, 0, 4, 0, 8),
(413, 0, 0, 4, 0, 8),
(414, 0, 0, 4, 0, 8),
(415, 0, 0, 4, 0, 8),
(416, 0, 0, 4, 0, 8),
(417, 0, 0, 4, 0, 8),
(418, 0, 0, 4, 0, 8),
(419, 0, 0, 4, 0, 8),
(420, 0, 0, 4, 0, 8),
(421, 0, 0, 4, 0, 8),
(422, 0, 0, 4, 0, 8),
(423, 0, 0, 4, 0, 8),
(424, 0, 0, 4, 0, 8),
(425, 0, 0, 4, 0, 8),
(426, 0, 0, 4, 0, 8),
(427, 0, 0, 4, 0, 8),
(428, 0, 0, 4, 0, 8),
(429, 0, 0, 4, 0, 8),
(430, 0, 0, 1, 0, 9),
(431, 0, 0, 1, 0, 9),
(432, 0, 0, 1, 0, 9),
(433, 0, 0, 1, 0, 9),
(434, 0, 0, 1, 0, 9),
(435, 0, 0, 1, 0, 9),
(436, 0, 0, 1, 0, 9),
(437, 0, 0, 1, 0, 9),
(438, 0, 0, 1, 0, 9),
(439, 0, 0, 1, 0, 9),
(440, 0, 0, 1, 0, 9),
(441, 0, 0, 1, 0, 9),
(442, 0, 0, 1, 0, 9),
(443, 0, 0, 1, 0, 9),
(444, 0, 0, 1, 0, 9),
(445, 0, 0, 1, 0, 9),
(446, 0, 0, 1, 0, 9),
(447, 0, 0, 1, 0, 9),
(448, 0, 0, 1, 0, 9),
(449, 0, 0, 1, 0, 9),
(450, 0, 0, 0, 0, 9),
(451, 0, 0, 0, 0, 9),
(452, 0, 0, 0, 0, 9),
(453, 0, 0, 0, 0, 9),
(454, 0, 0, 0, 0, 9),
(455, 0, 0, 0, 0, 9),
(456, 0, 0, 0, 0, 9),
(457, 0, 0, 0, 0, 9),
(458, 0, 0, 0, 0, 9),
(459, 0, 0, 0, 0, 9),
(460, 0, 0, 0, 0, 9),
(461, 0, 0, 0, 0, 9),
(462, 0, 0, 0, 0, 9),
(463, 0, 0, 0, 0, 9),
(464, 0, 0, 0, 0, 9),
(465, 0, 0, 0, 0, 9),
(466, 0, 0, 0, 0, 9),
(467, 0, 0, 0, 0, 9),
(468, 0, 0, 0, 0, 9),
(469, 0, 0, 0, 0, 9),
(470, 0, 0, 0, 0, 9),
(471, 0, 0, 10, 0, 9),
(472, 0, 0, 0, 0, 9),
(473, 0, 0, 1, 0, 9),
(474, 0, 0, 1, 0, 9),
(475, 0, 0, 1, 0, 9),
(476, 0, 0, 1, 0, 9),
(477, 0, 0, 1, 0, 9),
(478, 0, 0, 1, 0, 9),
(479, 0, 0, 1, 0, 9),
(480, 0, 0, 1, 0, 9),
(481, 0, 0, 1, 0, 9),
(482, 0, 0, 1, 0, 9),
(483, 0, 0, 1, 0, 9),
(484, 0, 0, 1, 0, 9),
(485, 0, 0, 1, 0, 9),
(486, 0, 0, 1, 0, 9),
(487, 0, 0, 1, 0, 9),
(488, 0, 0, 1, 0, 9),
(489, 0, 0, 1, 0, 9),
(490, 0, 0, 1, 0, 9),
(491, 0, 0, 1, 0, 9),
(492, 0, 0, 1, 0, 9),
(493, 0, 0, 0, 0, 9),
(494, 0, 0, 0, 0, 9),
(495, 0, 0, 0, 0, 9),
(496, 0, 0, 0, 0, 9),
(497, 0, 0, 0, 0, 9),
(498, 0, 0, 0, 0, 9),
(499, 0, 0, 0, 0, 9),
(500, 0, 0, 0, 0, 9),
(501, 0, 0, 0, 0, 9),
(502, 0, 0, 0, 0, 9),
(503, 0, 0, 0, 0, 9),
(504, 0, 0, 0, 0, 9),
(505, 0, 0, 0, 0, 9),
(506, 0, 0, 0, 0, 9),
(507, 0, 0, 0, 0, 9),
(508, 0, 0, 0, 0, 9),
(509, 0, 0, 0, 0, 9),
(510, 0, 0, 0, 0, 9),
(511, 0, 0, 0, 0, 9),
(512, 0, 0, 0, 0, 9),
(513, 0, 0, 1, 0, 9),
(514, 0, 0, 1, 0, 9),
(515, 0, 0, 1, 0, 9),
(516, 0, 0, 1, 0, 9),
(517, 0, 0, 1, 0, 9),
(518, 0, 0, 1, 0, 9),
(519, 0, 0, 1, 0, 9),
(520, 0, 0, 1, 0, 9),
(521, 0, 0, 1, 0, 9),
(522, 0, 0, 1, 0, 9),
(523, 0, 0, 1, 0, 9),
(524, 0, 0, 1, 0, 9),
(525, 0, 0, 1, 0, 9),
(526, 0, 0, 1, 0, 9),
(527, 0, 0, 1, 0, 9),
(528, 0, 0, 1, 0, 9),
(529, 0, 0, 1, 0, 9),
(530, 0, 0, 1, 0, 9),
(531, 0, 0, 1, 0, 9),
(532, 0, 0, 1, 0, 9),
(533, 0, 0, 0, 0, 9),
(534, 0, 0, 0, 0, 9),
(535, 0, 0, 0, 0, 9),
(536, 0, 0, 0, 0, 9),
(537, 0, 0, 0, 0, 9),
(538, 0, 0, 0, 0, 9),
(539, 0, 0, 0, 0, 9),
(540, 0, 0, 0, 0, 9),
(541, 0, 0, 0, 0, 9),
(542, 0, 0, 0, 0, 9),
(543, 0, 0, 0, 0, 9),
(544, 0, 0, 0, 0, 9),
(545, 0, 0, 0, 0, 9),
(546, 0, 0, 0, 0, 9),
(547, 0, 0, 0, 0, 9),
(548, 0, 0, 0, 0, 9),
(549, 0, 0, 0, 0, 9),
(550, 0, 0, 0, 0, 9),
(551, 0, 0, 0, 0, 9),
(552, 0, 0, 0, 0, 9),
(553, 0, 0, 10, 0, 9),
(554, 0, 0, 0, 0, 9),
(555, 0, 0, 0, 0, 9),
(556, 0, 0, 1, 0, 9),
(557, 0, 0, 1, 0, 9),
(558, 0, 0, 1, 0, 9),
(559, 0, 0, 1, 0, 9),
(560, 0, 0, 1, 0, 9),
(561, 0, 0, 1, 0, 9),
(562, 0, 0, 1, 0, 9),
(563, 0, 0, 1, 0, 9),
(564, 0, 0, 1, 0, 9),
(565, 0, 0, 1, 0, 9),
(566, 0, 0, 1, 0, 9),
(567, 0, 0, 1, 0, 9),
(568, 0, 0, 1, 0, 9),
(569, 0, 0, 1, 0, 9),
(570, 0, 0, 1, 0, 9),
(571, 0, 0, 1, 0, 9),
(572, 0, 0, 1, 0, 9),
(573, 0, 0, 1, 0, 9),
(574, 0, 0, 1, 0, 9),
(575, 0, 0, 1, 0, 9),
(576, 0, 0, 0, 0, 9),
(577, 0, 0, 0, 0, 9),
(578, 0, 0, 0, 0, 9),
(579, 0, 0, 0, 0, 9),
(580, 0, 0, 0, 0, 9),
(581, 0, 0, 0, 0, 9),
(582, 0, 0, 0, 0, 9),
(583, 0, 0, 0, 0, 9),
(584, 0, 0, 0, 0, 9),
(585, 0, 0, 0, 0, 9),
(586, 0, 0, 0, 0, 9),
(587, 0, 0, 0, 0, 9),
(588, 0, 0, 0, 0, 9),
(589, 0, 0, 0, 0, 9),
(590, 0, 0, 0, 0, 9),
(591, 0, 0, 0, 0, 9),
(592, 0, 0, 0, 0, 9),
(593, 0, 0, 0, 0, 9),
(594, 0, 0, 0, 0, 9),
(595, 0, 0, 0, 0, 9),
(596, 0, 0, 1, 0, 9),
(597, 0, 0, 1, 0, 9),
(598, 0, 0, 1, 0, 9),
(599, 0, 0, 1, 0, 9),
(600, 0, 0, 1, 0, 9),
(601, 0, 0, 1, 0, 9),
(602, 0, 0, 1, 0, 9),
(603, 0, 0, 1, 0, 9),
(604, 0, 0, 1, 0, 9),
(605, 0, 0, 1, 0, 9),
(606, 0, 0, 1, 0, 9),
(607, 0, 0, 1, 0, 9),
(608, 0, 0, 1, 0, 9),
(609, 0, 0, 1, 0, 9),
(610, 0, 0, 1, 0, 9),
(611, 0, 0, 1, 0, 9),
(612, 0, 0, 1, 0, 9),
(613, 0, 0, 1, 0, 9),
(614, 0, 0, 1, 0, 9),
(615, 0, 0, 1, 0, 9),
(616, 0, 0, 0, 0, 9),
(617, 0, 0, 0, 0, 9),
(618, 0, 0, 0, 0, 9),
(619, 0, 0, 0, 0, 9),
(620, 0, 0, 0, 0, 9),
(621, 0, 0, 0, 0, 9),
(622, 0, 0, 0, 0, 9),
(623, 0, 0, 0, 0, 9),
(624, 0, 0, 0, 0, 9),
(625, 0, 0, 0, 0, 9),
(626, 0, 0, 0, 0, 9),
(627, 0, 0, 0, 0, 9),
(628, 0, 0, 0, 0, 9),
(629, 0, 0, 0, 0, 9),
(630, 0, 0, 0, 0, 9),
(631, 0, 0, 0, 0, 9),
(632, 0, 0, 0, 0, 9),
(633, 0, 0, 0, 0, 9),
(634, 0, 0, 0, 0, 9),
(635, 0, 0, 0, 0, 9),
(636, 0, 0, 10, 0, 9),
(637, 0, 0, 0, 0, 9),
(638, 0, 0, 0, 0, 9),
(639, 0, 0, 4, 0, 10),
(640, 0, 0, 4, 0, 10),
(641, 0, 0, 4, 0, 10),
(642, 0, 0, 4, 0, 10),
(643, 0, 0, 4, 0, 10),
(644, 0, 0, 4, 0, 10),
(645, 0, 0, 0, 0, 10),
(646, 0, 0, 0, 0, 10),
(647, 0, 0, 0, 0, 10),
(648, 0, 0, 4, 0, 10),
(649, 0, 0, 0, 0, 10),
(650, 0, 0, 0, 0, 10),
(651, 0, 0, 4, 0, 10),
(652, 0, 0, 4, 0, 10),
(653, 0, 0, 4, 0, 10),
(654, 0, 0, 4, 0, 10),
(655, 0, 0, 4, 0, 10),
(656, 0, 0, 4, 0, 10),
(657, 0, 0, 4, 0, 10),
(658, 0, 0, 0, 0, 10),
(659, 0, 0, 0, 0, 10),
(660, 0, 0, 0, 0, 10),
(661, 0, 0, 4, 0, 10),
(662, 0, 0, 0, 0, 10),
(663, 0, 0, 0, 0, 10),
(664, 0, 0, 3, 0, 10),
(665, 0, 0, 3, 0, 10),
(666, 0, 0, 3, 0, 10),
(667, 0, 0, 3, 0, 10),
(668, 0, 0, 3, 0, 10),
(669, 0, 0, 4, 0, 10),
(670, 0, 0, 4, 0, 10),
(671, 0, 0, 3, 0, 10),
(672, 0, 0, 3, 0, 10),
(673, 0, 0, 0, 0, 10),
(674, 0, 0, 0, 0, 10),
(675, 0, 0, 0, 0, 10),
(676, 0, 0, 0, 0, 10),
(677, 0, 0, 3, 0, 10),
(678, 0, 0, 0, 0, 10),
(679, 0, 0, 0, 0, 10),
(680, 0, 0, 2, 0, 10),
(681, 0, 0, 0, 0, 10),
(682, 0, 0, 2, 0, 10),
(683, 0, 0, 2, 0, 10),
(684, 0, 0, 2, 0, 10),
(685, 0, 0, 2, 0, 10),
(686, 0, 0, 2, 0, 10),
(687, 0, 0, 2, 0, 10),
(688, 0, 0, 2, 0, 10),
(689, 0, 0, 3, 0, 10),
(690, 0, 0, 3, 0, 10),
(691, 0, 0, 3, 0, 10),
(692, 0, 0, 3, 0, 10),
(693, 0, 0, 3, 0, 10),
(694, 0, 0, 3, 0, 10),
(695, 0, 0, 2, 0, 10),
(696, 0, 0, 0, 0, 10),
(697, 0, 0, 2, 0, 10),
(698, 0, 0, 2, 0, 10),
(699, 0, 0, 2, 0, 10),
(700, 0, 0, 2, 0, 10),
(701, 0, 0, 2, 0, 10),
(702, 0, 0, 2, 0, 10);





INSERT INTO `pv_responsibility` (`id`, `name`) VALUES
(1, 'Médecin'),
(2, 'Pharmacien'),
(3, 'Analyste'),
(4, 'Professeur'),
(5, 'Epidemiologiste');
