INSERT INTO `category` (`id`, `title`, `color`) VALUES
(1, 'Pharmacovigilance', '#145374'),
(2, 'Strategy', '#FF584A'),
(3, 'Finance', '#FC7D49'),
(4, 'Digital', '#663DFC'),
(5, 'Analytics', '#E34FE8'),
(6, 'Cybersecurity', '#E34FC4'),
(7, 'Sustainability', '#EC4FC3'),
(8, 'SustainUp', '#EC6FC5'),
(9, 'HackerMind', '#E54CC3'),
(10, 'Onboarding', '#EB7FB3'),
(11, 'Pharmacovigilance Plus','#EB7FB3'),
(12, 'Purchase To Pay','#E34FC4'),
(13, 'Business Analytics', '#E34FC4');
(14, 'Lemo', '#EB7FB3'),


INSERT INTO `game` (`id`, `description`, `logo_path`, `name`) VALUES
(1, 'Price War Game representing a Price war between four competitors', 'https://www.nowedge.io/bg/logos/stratedge.png', 'StratEdge'),
(2, 'Management of trading portfolio', 'https://www.nowedge.ma/bg/logos/finedge.jpeg', 'FinEdge'),
(3, 'Ce business game permet d\évaluer les aptitudes et capacités des candidats à manager un centre de Pharmacovigilance', 'https://www.nowedge.io/bg/logos/pvgame_logo.svg', 'PVGame'),
(4, 'Management of Automotive corporation', 'https://www.nowedge.io/bg/logos/leadedge.png', 'LeadEdge'),
(5, 'Pharma 5 Pharmacovigilance Game', 'https://www.nowedge.io/bg/logos/pv5_game.svg', 'PV5Game'),
(6, 'The Pharmacovigilance Game', 'https://www.nowedge.io/bg/logos/pv_challenge_logo.svg', 'PVChallenge'),
(7, 'Discovering Analytics', 'https://www.nowedge.io/bg/logos/insights_logo.png', 'Insights'),
(8, 'Discovering Digital Transformation', 'https://www.nowedge.io/bg/logos/digital_ambassadors_logo.png', 'DigitalAmbassadors'),
(9, 'Sustainability and the reduction of consumption', 'https://www.nowedge.io/bg/logos/sustainup_logo.png', 'SustainUp'),
(10, 'Cybersecurity awareness', 'https://www.nowedge.io/bg/logos/hacker_mind_logo.png', 'HackerMind'),
(11, 'Digital transformation', 'https://www.nowedge.io/bg/logos/eccbc_onboarding_logo.png', 'ECCBCOnboarding'),
(12, 'The Pharmacovigilance Game Plus', 'https://www.nowedge.io/bg/logos/pv_challenge_plus_logo.svg', 'PVChallengePlus'),
(14, 'Purchase To Pay', 'https://www.nowedge.io/bg/logos/p2p_game_logo.svg', 'P2pGame');
(15, 'Lemo', 'https://www.nowedge.io/bg/logos/lemo_logo.svg', 'LemoGame');
INSERT INTO `role` (`id`, `name`, `description`) VALUES
(1, 'Admin', 'Administrator'),
(2, 'Moderator', 'Moderator'),
(3, 'Participant', 'Participant'),
(4, 'Professor', 'Professor');