-- 
-- aggiunge il supporto per il filtraggio dei giochi attraverso le patologie, 
-- parti del corpo e funzioni del corpo al database
--
-- creazione: 05/09/2023




-- phpMyAdmin SQL Dump
-- version 4.9.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost
-- Creato il: Set 04, 2023 alle 23:48
-- Versione del server: 5.5.57-MariaDB
-- Versione PHP: 5.6.40

SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET AUTOCOMMIT = 0;
START TRANSACTION;
SET time_zone = "+00:00";

--
-- Database: `test`
--

-- --------------------------------------------------------

--
-- Struttura della tabella `ima_body_area`
--

DROP TABLE IF EXISTS `ima_body_area`;
CREATE TABLE `ima_body_area` (
  `BodyArea_ID` int(9) NOT NULL,
  `Name` varchar(255) CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dump dei dati per la tabella `ima_body_area`
--

INSERT INTO `ima_body_area` (`BodyArea_ID`, `Name`) VALUES
(1, 'Upper limbs'),
(2, 'Lower limbs'),
(3, 'Torso');

-- --------------------------------------------------------

--
-- Struttura della tabella `ima_body_area_language`
--

DROP TABLE IF EXISTS `ima_body_area_language`;
CREATE TABLE `ima_body_area_language` (
  `BodyArea_ID` int(9) NOT NULL,
  `Language_ID` varchar(10) CHARACTER SET utf8 NOT NULL,
  `Name` varchar(255) CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dump dei dati per la tabella `ima_body_area_language`
--

INSERT INTO `ima_body_area_language` (`BodyArea_ID`, `Language_ID`, `Name`) VALUES
(1, 'it', 'Arti superiori'),
(2, 'it', 'Arti inferiori'),
(3, 'it', 'Torso');

-- --------------------------------------------------------

--
-- Struttura della tabella `ima_body_function`
--

DROP TABLE IF EXISTS `ima_body_function`;
CREATE TABLE `ima_body_function` (
  `BodyFunction_ID` int(9) NOT NULL,
  `Name` varchar(255) CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dump dei dati per la tabella `ima_body_function`
--

INSERT INTO `ima_body_function` (`BodyFunction_ID`, `Name`) VALUES
(1, 'Adduction/Abduction'),
(2, 'Flexion/Extension'),
(3, 'Flexion'),
(4, 'Lateral flexion');

-- --------------------------------------------------------

--
-- Struttura della tabella `ima_body_function_language`
--

DROP TABLE IF EXISTS `ima_body_function_language`;
CREATE TABLE `ima_body_function_language` (
  `BodyFunction_ID` int(9) NOT NULL,
  `Language_ID` varchar(10) CHARACTER SET utf8 NOT NULL,
  `Name` varchar(255) CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dump dei dati per la tabella `ima_body_function_language`
--

INSERT INTO `ima_body_function_language` (`BodyFunction_ID`, `Language_ID`, `Name`) VALUES
(1, 'it', 'Adduzione/Abduzione'),
(2, 'it', 'Flessione/Estensione'),
(3, 'it', 'Flessione'),
(4, 'it', 'Flessione laterale');

-- --------------------------------------------------------

--
-- Struttura della tabella `ima_body_part`
--

DROP TABLE IF EXISTS `ima_body_part`;
CREATE TABLE `ima_body_part` (
  `BodyPart_ID` int(9) NOT NULL,
  `Name` varchar(255) CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dump dei dati per la tabella `ima_body_part`
--

INSERT INTO `ima_body_part` (`BodyPart_ID`, `Name`) VALUES
(1, 'Shoulder'),
(2, 'Elbow'),
(3, 'Wrist'),
(4, 'Hip'),
(5, 'Knee'),
(6, 'Ankle'),
(7, 'Torso');

-- --------------------------------------------------------

--
-- Struttura della tabella `ima_body_part_language`
--

DROP TABLE IF EXISTS `ima_body_part_language`;
CREATE TABLE `ima_body_part_language` (
  `BodyPart_ID` int(9) NOT NULL,
  `Language_ID` varchar(10) CHARACTER SET utf8 NOT NULL,
  `Name` varchar(255) CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dump dei dati per la tabella `ima_body_part_language`
--

INSERT INTO `ima_body_part_language` (`BodyPart_ID`, `Language_ID`, `Name`) VALUES
(1, 'it', 'Spalla'),
(2, 'it', 'Gomito'),
(3, 'it', 'Polso'),
(4, 'it', 'Anca'),
(5, 'it', 'Ginocchio'),
(6, 'it', 'Caviglia'),
(7, 'it', 'Torso');

-- --------------------------------------------------------

--
-- Struttura della tabella `ima_brain_area`
--

DROP TABLE IF EXISTS `ima_brain_area`;
CREATE TABLE `ima_brain_area` (
  `BrainArea_ID` int(9) NOT NULL,
  `Name` varchar(255) CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dump dei dati per la tabella `ima_brain_area`
--

INSERT INTO `ima_brain_area` (`BrainArea_ID`, `Name`) VALUES
(1, 'Lateral intraparietal area LP'),
(2, 'Superior parietal lobule'),
(3, 'Primary motor cortex'),
(4, 'Inferior temporal cortex'),
(5, 'Prefrontal cortex'),
(6, 'Dorsalteral prefrontal cortex'),
(7, 'Parietal cortex'),
(8, 'Hippocampus'),
(9, 'Posterior parietal cortex'),
(10, 'Dorsolateral prefrontal cortex'),
(11, 'Anterior cingulate cortex'),
(12, 'Premotor cortex'),
(13, 'Cerebellum'),
(14, 'Infero temporal cortex'),
(15, 'Intraparietal sulcus'),
(16, 'Visual association cortex');

-- --------------------------------------------------------

--
-- Struttura della tabella `ima_brain_area_language`
--

DROP TABLE IF EXISTS `ima_brain_area_language`;
CREATE TABLE `ima_brain_area_language` (
  `BrainArea_ID` int(9) NOT NULL,
  `Language_ID` varchar(10) CHARACTER SET utf8 NOT NULL,
  `Name` varchar(255) CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dump dei dati per la tabella `ima_brain_area_language`
--

INSERT INTO `ima_brain_area_language` (`BrainArea_ID`, `Language_ID`, `Name`) VALUES
(1, 'it', 'Area Intraparietale laterale LP'),
(2, 'it', 'Lobulo parietale superiore'),
(3, 'it', 'Corteccia motoria primaria'),
(4, 'it', 'Corteccia temporale inferiore'),
(5, 'it', 'Corteccia Prefrontale'),
(6, 'it', 'Corteccia prefrontale dorsale'),
(7, 'it', 'Corteccia parietale'),
(8, 'it', 'Ippocampo'),
(9, 'it', 'Corteccia parietale posteriore'),
(10, 'it', 'Corteccia prefrontale dorsolaterale'),
(11, 'it', 'Corteccia cingolata anteriore'),
(12, 'it', 'Corteccia premotoria'),
(13, 'it', 'Cervelletto'),
(14, 'it', 'Corteccia inferotemporale'),
(15, 'it', 'Solco intraparietale'),
(16, 'it', 'Corteccia associativa visiva');

-- --------------------------------------------------------

--
-- Struttura della tabella `ima_brain_function`
--

DROP TABLE IF EXISTS `ima_brain_function`;
CREATE TABLE `ima_brain_function` (
  `BrainFunction_ID` int(9) NOT NULL,
  `Name` varchar(255) CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dump dei dati per la tabella `ima_brain_function`
--

INSERT INTO `ima_brain_function` (`BrainFunction_ID`, `Name`) VALUES
(1, 'Matching visual stimuli'),
(2, 'Controlled motor movements'),
(3, 'Sorting information'),
(4, 'Creating a link between visual stimuli'),
(5, 'Memory'),
(6, 'Spatial memory and navigation'),
(7, 'Spatial awareness'),
(8, 'Multitasking'),
(9, 'Fine motor movements'),
(10, 'Object recognition and identification'),
(11, 'Numerical processing and mathematical calculations'),
(12, 'Reconstruction and completing imcomplete images');

-- --------------------------------------------------------

--
-- Struttura della tabella `ima_brain_function_language`
--

DROP TABLE IF EXISTS `ima_brain_function_language`;
CREATE TABLE `ima_brain_function_language` (
  `BrainFunction_ID` int(9) NOT NULL,
  `Language_ID` varchar(10) CHARACTER SET utf8 NOT NULL,
  `Name` varchar(255) CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dump dei dati per la tabella `ima_brain_function_language`
--

INSERT INTO `ima_brain_function_language` (`BrainFunction_ID`, `Language_ID`, `Name`) VALUES
(1, 'it', 'Stimoli visivi corrispondenti'),
(2, 'it', 'Movimenti motori controllati'),
(3, 'it', 'Ordinamento delle informazioni'),
(4, 'it', 'Creazione di un collegamento tra stimoli visivi'),
(5, 'it', 'Memoria'),
(6, 'it', 'Memoria spaziale e navigazione'),
(7, 'it', 'Consapevolezza spaziale'),
(8, 'it', 'Multitasking'),
(9, 'it', 'Movimenti motori fini'),
(10, 'it', 'Riconoscimento e identificazione degli oggetti'),
(11, 'it', 'Elaborazione numerica e calcoli matematici'),
(12, 'it', 'Ricostruzione e completamento di immagini incomplete');

-- --------------------------------------------------------

--
-- Struttura della tabella `ima_game_body_mapping`
--

DROP TABLE IF EXISTS `ima_game_body_mapping`;
CREATE TABLE `ima_game_body_mapping` (
  `Game_ID` int(9) NOT NULL,
  `BodyArea_ID` int(9) NOT NULL,
  `BodyPart_ID` int(9) NOT NULL,
  `BodyFunction_ID` int(9) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dump dei dati per la tabella `ima_game_body_mapping`
--

INSERT INTO `ima_game_body_mapping` (`Game_ID`, `BodyArea_ID`, `BodyPart_ID`, `BodyFunction_ID`) VALUES
(3, 1, 1, 1),
(3, 1, 1, 2),
(3, 1, 2, 2),
(4, 1, 1, 1),
(4, 1, 1, 2),
(4, 1, 2, 2),
(5, 1, 1, 1),
(5, 1, 1, 2),
(5, 1, 2, 2),
(7, 1, 1, 1),
(7, 1, 1, 2),
(7, 1, 2, 2),
(8, 1, 1, 1),
(8, 1, 1, 2),
(8, 1, 2, 2),
(10, 1, 1, 1),
(10, 1, 1, 2),
(10, 1, 2, 2),
(14, 1, 1, 1),
(14, 1, 1, 2),
(14, 1, 2, 2),
(15, 1, 1, 1),
(15, 1, 1, 2),
(15, 1, 2, 2),
(16, 1, 1, 1),
(16, 1, 1, 2),
(16, 1, 2, 2),
(17, 1, 1, 1),
(17, 1, 1, 2),
(17, 1, 2, 2),
(18, 1, 1, 1),
(18, 1, 1, 2),
(18, 1, 2, 2),
(19, 1, 1, 1),
(19, 1, 1, 2),
(19, 1, 2, 2),
(20, 1, 1, 1),
(20, 1, 1, 2),
(20, 1, 2, 2),
(21, 1, 1, 1),
(21, 1, 1, 2),
(21, 1, 2, 2),
(22, 1, 1, 1),
(22, 1, 1, 2),
(22, 1, 2, 2),
(23, 1, 1, 1),
(23, 1, 1, 2),
(23, 1, 2, 2),
(24, 1, 1, 1),
(24, 1, 1, 2),
(24, 1, 2, 2),
(25, 1, 1, 1),
(25, 1, 1, 2),
(25, 1, 2, 2),
(26, 1, 1, 1),
(26, 1, 1, 2),
(26, 1, 2, 2),
(28, 1, 1, 1),
(28, 1, 1, 2),
(28, 1, 2, 2),
(30, 1, 1, 1),
(30, 1, 1, 2),
(30, 1, 2, 2),
(31, 1, 1, 1),
(31, 1, 1, 2),
(31, 1, 2, 2),
(32, 1, 1, 1),
(32, 1, 1, 2),
(32, 1, 2, 2),
(33, 1, 1, 1),
(33, 1, 1, 2),
(33, 1, 2, 2),
(34, 1, 1, 1),
(34, 1, 1, 2),
(34, 1, 2, 2),
(35, 1, 1, 1),
(35, 1, 1, 2),
(35, 1, 2, 2),
(36, 3, 7, 3),
(36, 3, 7, 4),
(37, 3, 7, 3),
(37, 3, 7, 4),
(38, 1, 1, 1),
(38, 1, 1, 2),
(38, 1, 2, 2),
(39, 2, 4, 1),
(39, 2, 4, 2),
(39, 2, 5, 2),
(40, 2, 4, 1),
(40, 2, 4, 2),
(40, 2, 5, 2),
(41, 2, 4, 1),
(41, 2, 4, 2),
(41, 2, 5, 2),
(42, 2, 5, 2),
(43, 2, 4, 1),
(43, 2, 4, 2),
(43, 2, 5, 2),
(44, 3, 7, 3),
(44, 3, 7, 4),
(52, 2, 5, 2),
(53, 2, 4, 2),
(53, 2, 5, 2),
(54, 3, 7, 3),
(54, 3, 7, 4),
(56, 1, 1, 1),
(56, 2, 4, 1),
(57, 1, 1, 1),
(57, 2, 4, 1),
(58, 2, 4, 2),
(58, 2, 5, 2),
(59, 1, 1, 1),
(59, 1, 1, 2),
(59, 1, 2, 2),
(60, 1, 1, 1),
(60, 1, 1, 2),
(60, 1, 2, 2),
(61, 1, 1, 1),
(61, 1, 1, 2),
(61, 1, 2, 2),
(62, 1, 1, 1),
(62, 1, 1, 2),
(62, 1, 2, 2),
(63, 1, 1, 1),
(63, 1, 1, 2),
(63, 1, 2, 2),
(63, 2, 4, 1),
(63, 2, 4, 2),
(63, 2, 5, 2),
(64, 1, 1, 1),
(64, 1, 1, 2),
(64, 1, 2, 2),
(65, 2, 4, 1),
(65, 2, 4, 2),
(65, 2, 5, 2);

-- --------------------------------------------------------

--
-- Struttura della tabella `ima_game_brain_mapping`
--

DROP TABLE IF EXISTS `ima_game_brain_mapping`;
CREATE TABLE `ima_game_brain_mapping` (
  `Game_ID` int(9) NOT NULL,
  `BrainArea_ID` int(9) NOT NULL,
  `BrainFunction_ID` int(9) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dump dei dati per la tabella `ima_game_brain_mapping`
--

INSERT INTO `ima_game_brain_mapping` (`Game_ID`, `BrainArea_ID`, `BrainFunction_ID`) VALUES
(3, 3, 2),
(3, 4, 2),
(4, 3, 2),
(4, 4, 2),
(5, 3, 2),
(5, 4, 2),
(5, 6, 3),
(5, 7, 3),
(7, 3, 2),
(7, 4, 2),
(7, 6, 3),
(7, 7, 3),
(7, 12, 9),
(7, 13, 9),
(8, 3, 2),
(8, 4, 2),
(10, 3, 2),
(10, 4, 2),
(10, 6, 3),
(10, 7, 3),
(10, 12, 9),
(10, 13, 9),
(14, 3, 2),
(14, 4, 2),
(14, 8, 4),
(14, 8, 5),
(14, 8, 6),
(15, 3, 2),
(15, 4, 2),
(15, 8, 4),
(15, 8, 5),
(15, 8, 6),
(16, 3, 2),
(16, 4, 2),
(16, 15, 11),
(17, 3, 2),
(17, 4, 2),
(17, 16, 12),
(18, 8, 4),
(18, 8, 5),
(18, 8, 6),
(19, 3, 2),
(19, 4, 2),
(19, 8, 4),
(19, 8, 5),
(19, 8, 6),
(20, 3, 2),
(20, 4, 2),
(21, 3, 2),
(21, 4, 2),
(21, 6, 3),
(21, 7, 3),
(22, 3, 2),
(22, 4, 2),
(23, 3, 2),
(23, 4, 2),
(24, 3, 2),
(24, 4, 2),
(25, 3, 2),
(25, 4, 2),
(26, 3, 2),
(26, 4, 2),
(26, 6, 3),
(26, 7, 3),
(26, 12, 9),
(26, 13, 9),
(28, 3, 2),
(28, 4, 2),
(28, 6, 3),
(28, 7, 3),
(28, 12, 9),
(28, 13, 9),
(30, 3, 2),
(30, 4, 2),
(30, 6, 3),
(30, 7, 3),
(31, 3, 2),
(31, 4, 2),
(31, 6, 3),
(31, 7, 3),
(32, 3, 2),
(32, 4, 2),
(33, 3, 2),
(33, 4, 2),
(33, 8, 4),
(33, 8, 5),
(33, 8, 6),
(34, 3, 2),
(34, 4, 2),
(35, 1, 1),
(35, 2, 1),
(35, 3, 2),
(35, 4, 2),
(35, 12, 9),
(35, 13, 9),
(36, 3, 2),
(36, 4, 2),
(36, 9, 7),
(36, 13, 9),
(37, 1, 1),
(37, 2, 1),
(37, 3, 2),
(37, 4, 2),
(37, 8, 9),
(38, 3, 2),
(38, 4, 2),
(38, 8, 4),
(38, 8, 5),
(38, 8, 6),
(39, 3, 2),
(39, 4, 2),
(39, 6, 3),
(39, 7, 3),
(40, 3, 2),
(40, 4, 2),
(40, 6, 3),
(40, 7, 3),
(41, 3, 2),
(41, 4, 2),
(42, 3, 2),
(42, 4, 2),
(42, 9, 7),
(43, 3, 2),
(43, 4, 2),
(44, 3, 2),
(44, 4, 2),
(44, 9, 7),
(44, 13, 9),
(52, 3, 2),
(52, 4, 2),
(53, 3, 2),
(53, 4, 2),
(54, 3, 2),
(54, 4, 2),
(54, 9, 7),
(54, 13, 9),
(56, 3, 2),
(56, 4, 2),
(57, 3, 2),
(57, 4, 2),
(58, 3, 2),
(58, 4, 2),
(59, 3, 2),
(59, 4, 2),
(59, 8, 4),
(59, 8, 5),
(59, 8, 6),
(60, 3, 2),
(60, 4, 2),
(60, 10, 8),
(60, 11, 8),
(61, 3, 2),
(61, 4, 2),
(61, 8, 4),
(61, 8, 5),
(61, 8, 6),
(62, 3, 2),
(62, 4, 2),
(62, 8, 4),
(62, 8, 5),
(62, 8, 6),
(63, 3, 2),
(63, 4, 2),
(63, 9, 7),
(64, 3, 2),
(64, 4, 2),
(64, 6, 3),
(64, 7, 3),
(65, 3, 2),
(65, 4, 2),
(65, 8, 4),
(65, 8, 5),
(65, 8, 6);

-- --------------------------------------------------------

--
-- Struttura della tabella `ima_game_pathology`
--

DROP TABLE IF EXISTS `ima_game_pathology`;
CREATE TABLE `ima_game_pathology` (
  `Game_ID` int(9) NOT NULL,
  `Pathology_ID` int(9) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dump dei dati per la tabella `ima_game_pathology`
--

INSERT INTO `ima_game_pathology` (`Game_ID`, `Pathology_ID`) VALUES
(3, 2),
(3, 3),
(3, 4),
(3, 5),
(3, 6),
(3, 7),
(3, 8),
(3, 9),
(3, 10),
(3, 11),
(3, 12),
(3, 13),
(3, 14),
(3, 15),
(3, 30),
(3, 31),
(3, 32),
(3, 33),
(3, 34),
(4, 2),
(4, 3),
(4, 4),
(4, 5),
(4, 6),
(4, 7),
(4, 8),
(4, 9),
(4, 10),
(4, 11),
(4, 12),
(4, 13),
(4, 14),
(4, 15),
(4, 30),
(4, 31),
(4, 32),
(4, 33),
(4, 34),
(5, 1),
(5, 2),
(5, 3),
(5, 4),
(5, 5),
(5, 6),
(5, 7),
(5, 8),
(5, 9),
(5, 10),
(5, 11),
(5, 12),
(5, 13),
(5, 14),
(5, 15),
(5, 30),
(5, 31),
(5, 32),
(5, 33),
(5, 34),
(5, 52),
(5, 53),
(7, 1),
(7, 2),
(7, 3),
(7, 4),
(7, 5),
(7, 6),
(7, 7),
(7, 8),
(7, 9),
(7, 10),
(7, 11),
(7, 12),
(7, 13),
(7, 14),
(7, 15),
(7, 30),
(7, 31),
(7, 32),
(7, 33),
(7, 34),
(8, 2),
(8, 3),
(8, 4),
(8, 5),
(8, 6),
(8, 7),
(8, 8),
(8, 9),
(8, 10),
(8, 11),
(8, 12),
(8, 13),
(8, 14),
(8, 15),
(8, 30),
(8, 31),
(8, 32),
(8, 33),
(8, 34),
(10, 1),
(10, 2),
(10, 3),
(10, 4),
(10, 5),
(10, 6),
(10, 7),
(10, 8),
(10, 9),
(10, 10),
(10, 11),
(10, 12),
(10, 13),
(10, 14),
(10, 15),
(10, 30),
(10, 31),
(10, 32),
(10, 33),
(10, 34),
(14, 1),
(14, 2),
(14, 3),
(14, 4),
(14, 5),
(14, 6),
(14, 7),
(14, 8),
(14, 9),
(14, 10),
(14, 11),
(14, 12),
(14, 13),
(14, 14),
(14, 15),
(14, 30),
(14, 31),
(14, 32),
(14, 33),
(14, 34),
(14, 52),
(14, 53),
(15, 1),
(15, 2),
(15, 3),
(15, 4),
(15, 5),
(15, 6),
(15, 7),
(15, 8),
(15, 9),
(15, 10),
(15, 11),
(15, 12),
(15, 13),
(15, 14),
(15, 15),
(15, 30),
(15, 31),
(15, 32),
(15, 33),
(15, 34),
(15, 52),
(15, 53),
(16, 1),
(16, 2),
(16, 3),
(16, 4),
(16, 5),
(16, 6),
(16, 7),
(16, 8),
(16, 9),
(16, 10),
(16, 11),
(16, 12),
(16, 13),
(16, 14),
(16, 15),
(16, 30),
(16, 31),
(16, 32),
(16, 33),
(16, 34),
(17, 1),
(17, 2),
(17, 3),
(17, 4),
(17, 5),
(17, 6),
(17, 7),
(17, 8),
(17, 9),
(17, 10),
(17, 11),
(17, 12),
(17, 13),
(17, 14),
(17, 15),
(17, 30),
(17, 31),
(17, 32),
(17, 33),
(17, 34),
(17, 52),
(17, 53),
(18, 1),
(18, 2),
(18, 3),
(18, 4),
(18, 5),
(18, 6),
(18, 7),
(18, 8),
(18, 9),
(18, 10),
(18, 11),
(18, 12),
(18, 13),
(18, 14),
(18, 15),
(18, 30),
(18, 31),
(18, 32),
(18, 33),
(18, 34),
(19, 1),
(19, 2),
(19, 3),
(19, 4),
(19, 5),
(19, 6),
(19, 7),
(19, 8),
(19, 9),
(19, 10),
(19, 11),
(19, 12),
(19, 13),
(19, 14),
(19, 15),
(19, 30),
(19, 31),
(19, 32),
(19, 33),
(19, 34),
(20, 2),
(20, 3),
(20, 4),
(20, 5),
(20, 6),
(20, 7),
(20, 8),
(20, 9),
(20, 10),
(20, 11),
(20, 12),
(20, 13),
(20, 14),
(20, 15),
(20, 30),
(20, 31),
(20, 32),
(20, 33),
(20, 34),
(21, 1),
(21, 2),
(21, 3),
(21, 4),
(21, 5),
(21, 6),
(21, 7),
(21, 8),
(21, 9),
(21, 10),
(21, 11),
(21, 12),
(21, 13),
(21, 14),
(21, 15),
(21, 30),
(21, 31),
(21, 32),
(21, 33),
(21, 34),
(21, 52),
(21, 53),
(22, 2),
(22, 3),
(22, 4),
(22, 5),
(22, 6),
(22, 7),
(22, 8),
(22, 9),
(22, 10),
(22, 11),
(22, 12),
(22, 13),
(22, 14),
(22, 15),
(22, 30),
(22, 31),
(22, 32),
(22, 33),
(22, 34),
(23, 2),
(23, 3),
(23, 4),
(23, 5),
(23, 6),
(23, 7),
(23, 8),
(23, 9),
(23, 10),
(23, 11),
(23, 12),
(23, 13),
(23, 14),
(23, 15),
(23, 30),
(23, 31),
(23, 32),
(23, 33),
(23, 34),
(24, 2),
(24, 3),
(24, 4),
(24, 5),
(24, 6),
(24, 7),
(24, 8),
(24, 9),
(24, 10),
(24, 11),
(24, 12),
(24, 13),
(24, 14),
(24, 15),
(24, 30),
(24, 31),
(24, 32),
(24, 33),
(24, 34),
(25, 2),
(25, 3),
(25, 4),
(25, 5),
(25, 6),
(25, 7),
(25, 8),
(25, 9),
(25, 10),
(25, 11),
(25, 12),
(25, 13),
(25, 14),
(25, 15),
(25, 30),
(25, 31),
(25, 32),
(25, 33),
(25, 34),
(26, 1),
(26, 2),
(26, 3),
(26, 4),
(26, 5),
(26, 6),
(26, 7),
(26, 8),
(26, 9),
(26, 10),
(26, 11),
(26, 12),
(26, 13),
(26, 14),
(26, 15),
(26, 30),
(26, 31),
(26, 32),
(26, 33),
(26, 34),
(28, 1),
(28, 2),
(28, 3),
(28, 4),
(28, 5),
(28, 6),
(28, 7),
(28, 8),
(28, 9),
(28, 10),
(28, 11),
(28, 12),
(28, 13),
(28, 14),
(28, 15),
(28, 30),
(28, 31),
(28, 32),
(28, 33),
(28, 34),
(30, 1),
(30, 2),
(30, 3),
(30, 4),
(30, 5),
(30, 6),
(30, 7),
(30, 8),
(30, 9),
(30, 10),
(30, 11),
(30, 12),
(30, 13),
(30, 14),
(30, 15),
(30, 30),
(30, 31),
(30, 32),
(30, 33),
(30, 34),
(30, 52),
(30, 53),
(31, 1),
(31, 2),
(31, 3),
(31, 4),
(31, 5),
(31, 6),
(31, 7),
(31, 8),
(31, 9),
(31, 10),
(31, 11),
(31, 12),
(31, 13),
(31, 14),
(31, 15),
(31, 30),
(31, 31),
(31, 32),
(31, 33),
(31, 34),
(31, 52),
(31, 53),
(32, 1),
(32, 2),
(32, 3),
(32, 4),
(32, 5),
(32, 6),
(32, 7),
(32, 8),
(32, 9),
(32, 10),
(32, 11),
(32, 12),
(32, 13),
(32, 14),
(32, 15),
(32, 30),
(32, 31),
(32, 32),
(32, 33),
(32, 34),
(33, 1),
(33, 2),
(33, 3),
(33, 4),
(33, 5),
(33, 6),
(33, 7),
(33, 8),
(33, 9),
(33, 10),
(33, 11),
(33, 12),
(33, 13),
(33, 14),
(33, 15),
(33, 30),
(33, 31),
(33, 32),
(33, 33),
(33, 34),
(34, 2),
(34, 3),
(34, 4),
(34, 5),
(34, 6),
(34, 7),
(34, 8),
(34, 9),
(34, 10),
(34, 11),
(34, 12),
(34, 13),
(34, 14),
(34, 15),
(34, 30),
(34, 31),
(34, 32),
(34, 33),
(34, 34),
(35, 1),
(35, 2),
(35, 3),
(35, 4),
(35, 5),
(35, 6),
(35, 7),
(35, 8),
(35, 9),
(35, 10),
(35, 11),
(35, 12),
(35, 13),
(35, 14),
(35, 15),
(35, 30),
(35, 31),
(35, 32),
(35, 33),
(35, 34),
(36, 1),
(36, 3),
(36, 16),
(36, 17),
(36, 18),
(36, 19),
(36, 20),
(36, 21),
(36, 22),
(36, 23),
(36, 24),
(36, 25),
(36, 26),
(36, 27),
(36, 28),
(36, 29),
(36, 30),
(36, 31),
(36, 32),
(36, 33),
(36, 34),
(37, 1),
(37, 3),
(37, 16),
(37, 17),
(37, 18),
(37, 19),
(37, 20),
(37, 21),
(37, 22),
(37, 23),
(37, 24),
(37, 25),
(37, 26),
(37, 27),
(37, 28),
(37, 29),
(37, 30),
(37, 31),
(37, 32),
(37, 33),
(37, 34),
(37, 52),
(37, 53),
(38, 1),
(38, 2),
(38, 3),
(38, 4),
(38, 5),
(38, 6),
(38, 7),
(38, 8),
(38, 9),
(38, 10),
(38, 11),
(38, 12),
(38, 13),
(38, 14),
(38, 15),
(38, 30),
(38, 31),
(38, 32),
(38, 33),
(38, 34),
(39, 1),
(39, 2),
(39, 3),
(39, 16),
(39, 17),
(39, 18),
(39, 19),
(39, 20),
(39, 21),
(39, 22),
(39, 23),
(39, 24),
(39, 25),
(39, 26),
(39, 27),
(39, 28),
(39, 29),
(39, 30),
(39, 31),
(39, 32),
(39, 33),
(39, 34),
(39, 52),
(39, 53),
(40, 2),
(40, 3),
(40, 16),
(40, 17),
(40, 18),
(40, 19),
(40, 20),
(40, 21),
(40, 22),
(40, 23),
(40, 24),
(40, 25),
(40, 26),
(40, 27),
(40, 28),
(40, 29),
(40, 30),
(40, 31),
(40, 32),
(40, 33),
(40, 34),
(40, 52),
(40, 53),
(41, 2),
(41, 16),
(41, 17),
(41, 18),
(41, 19),
(41, 20),
(41, 21),
(41, 22),
(41, 23),
(41, 24),
(41, 25),
(41, 26),
(41, 27),
(41, 28),
(41, 29),
(41, 30),
(41, 31),
(41, 32),
(41, 33),
(41, 34),
(41, 35),
(41, 36),
(41, 37),
(41, 38),
(41, 39),
(41, 40),
(41, 41),
(41, 42),
(41, 43),
(41, 44),
(41, 45),
(41, 46),
(41, 47),
(41, 48),
(41, 49),
(41, 50),
(41, 51),
(42, 2),
(42, 16),
(42, 17),
(42, 18),
(42, 19),
(42, 20),
(42, 21),
(42, 22),
(42, 29),
(42, 30),
(42, 31),
(42, 32),
(42, 33),
(42, 34),
(42, 35),
(42, 36),
(42, 37),
(42, 38),
(42, 39),
(42, 40),
(42, 41),
(42, 42),
(42, 43),
(42, 44),
(42, 45),
(42, 46),
(42, 47),
(42, 48),
(42, 49),
(42, 50),
(42, 51),
(43, 1),
(43, 2),
(43, 16),
(43, 17),
(43, 18),
(43, 19),
(43, 20),
(43, 21),
(43, 22),
(43, 23),
(43, 24),
(43, 25),
(43, 26),
(43, 27),
(43, 28),
(43, 29),
(43, 30),
(43, 31),
(43, 32),
(43, 33),
(43, 34),
(44, 1),
(44, 2),
(44, 3),
(44, 16),
(44, 17),
(44, 18),
(44, 19),
(44, 20),
(44, 21),
(44, 22),
(44, 23),
(44, 24),
(44, 25),
(44, 26),
(44, 27),
(44, 28),
(44, 29),
(44, 30),
(44, 31),
(44, 32),
(44, 33),
(44, 34),
(52, 1),
(52, 2),
(52, 3),
(52, 4),
(52, 21),
(52, 22),
(52, 31),
(52, 32),
(52, 33),
(52, 34),
(53, 1),
(53, 2),
(53, 3),
(53, 4),
(53, 16),
(53, 17),
(53, 18),
(53, 19),
(53, 20),
(53, 21),
(53, 22),
(53, 23),
(53, 24),
(53, 25),
(53, 26),
(53, 27),
(53, 28),
(53, 29),
(53, 31),
(53, 32),
(53, 33),
(53, 34),
(54, 1),
(54, 2),
(54, 3),
(54, 16),
(54, 17),
(54, 18),
(54, 19),
(54, 20),
(54, 21),
(54, 22),
(54, 23),
(54, 24),
(54, 25),
(54, 26),
(54, 27),
(54, 28),
(54, 29),
(54, 30),
(54, 31),
(54, 32),
(54, 33),
(54, 34),
(56, 2),
(56, 5),
(56, 6),
(56, 7),
(56, 8),
(56, 9),
(56, 16),
(56, 17),
(56, 18),
(56, 19),
(56, 20),
(56, 21),
(56, 22),
(56, 29),
(56, 35),
(56, 36),
(56, 37),
(56, 38),
(56, 39),
(56, 40),
(56, 41),
(56, 42),
(56, 43),
(56, 44),
(56, 45),
(56, 46),
(56, 47),
(56, 48),
(56, 49),
(56, 50),
(56, 51),
(57, 2),
(57, 5),
(57, 6),
(57, 7),
(57, 8),
(57, 9),
(57, 35),
(57, 36),
(57, 37),
(57, 38),
(57, 39),
(57, 40),
(57, 41),
(57, 42),
(57, 43),
(57, 44),
(57, 45),
(57, 46),
(57, 47),
(57, 48),
(57, 49),
(57, 50),
(57, 51),
(58, 2),
(58, 35),
(58, 36),
(58, 37),
(58, 38),
(58, 39),
(58, 40),
(58, 41),
(58, 42),
(58, 43),
(58, 44),
(58, 45),
(58, 46),
(58, 47),
(58, 48),
(58, 49),
(58, 50),
(58, 51),
(59, 2),
(59, 3),
(59, 4),
(59, 5),
(59, 6),
(59, 7),
(59, 8),
(59, 9),
(59, 10),
(59, 11),
(59, 12),
(59, 13),
(59, 14),
(59, 15),
(59, 30),
(59, 31),
(59, 32),
(59, 33),
(59, 34),
(60, 2),
(60, 3),
(60, 4),
(60, 5),
(60, 6),
(60, 7),
(60, 8),
(60, 9),
(60, 10),
(60, 11),
(60, 12),
(60, 13),
(60, 14),
(60, 15),
(60, 30),
(60, 31),
(60, 32),
(60, 33),
(60, 34),
(61, 2),
(61, 3),
(61, 4),
(61, 5),
(61, 6),
(61, 7),
(61, 8),
(61, 9),
(61, 10),
(61, 11),
(61, 12),
(61, 13),
(61, 14),
(61, 15),
(61, 30),
(61, 31),
(61, 32),
(61, 33),
(61, 34),
(62, 2),
(62, 3),
(62, 4),
(62, 5),
(62, 6),
(62, 7),
(62, 8),
(62, 9),
(62, 10),
(62, 11),
(62, 12),
(62, 13),
(62, 14),
(62, 15),
(62, 30),
(62, 31),
(62, 32),
(62, 33),
(62, 34),
(63, 5),
(63, 6),
(63, 7),
(63, 8),
(63, 9),
(63, 16),
(63, 17),
(63, 18),
(63, 19),
(63, 20),
(63, 21),
(63, 22),
(63, 23),
(63, 24),
(63, 25),
(63, 26),
(63, 27),
(63, 28),
(63, 29),
(63, 35),
(63, 36),
(63, 37),
(63, 38),
(63, 39),
(63, 40),
(63, 41),
(63, 42),
(63, 43),
(63, 44),
(63, 45),
(63, 46),
(63, 47),
(63, 48),
(63, 49),
(63, 50),
(63, 51),
(64, 1),
(64, 2),
(64, 3),
(64, 4),
(64, 5),
(64, 6),
(64, 7),
(64, 8),
(64, 9),
(64, 10),
(64, 11),
(64, 12),
(64, 13),
(64, 14),
(64, 15),
(64, 30),
(64, 31),
(64, 32),
(64, 33),
(64, 34),
(64, 52),
(64, 53),
(65, 2),
(65, 16),
(65, 17),
(65, 18),
(65, 19),
(65, 20),
(65, 21),
(65, 22),
(65, 23),
(65, 24),
(65, 25),
(65, 26),
(65, 27),
(65, 28),
(65, 29),
(65, 30),
(65, 31),
(65, 32),
(65, 33),
(65, 34),
(65, 35),
(65, 36),
(65, 37),
(65, 38),
(65, 39),
(65, 40),
(65, 41),
(65, 42),
(65, 43),
(65, 44),
(65, 45),
(65, 46),
(65, 47),
(65, 48),
(65, 49),
(65, 50),
(65, 51);

-- --------------------------------------------------------

--
-- Struttura della tabella `ima_pathology`
--

DROP TABLE IF EXISTS `ima_pathology`;
CREATE TABLE `ima_pathology` (
  `Pathology_ID` int(9) NOT NULL,
  `Name` varchar(255) CHARACTER SET utf8 NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dump dei dati per la tabella `ima_pathology`
--

INSERT INTO `ima_pathology` (`Pathology_ID`, `Name`) VALUES
(1, 'Parkinson'),
(2, 'MS'),
(3, 'Stroke'),
(4, 'Spinal cord injuries'),
(5, 'Frozen Shoulder'),
(6, 'Shoulder Replacement'),
(7, 'Shoulder Impingement Syndrome'),
(8, 'Rotator Cuff Tear'),
(9, 'Brachial Plexus Injury'),
(10, 'Elbow Fractures'),
(11, 'Lateral Epicondylitis'),
(12, 'Medial Epicondylitis'),
(13, 'Elbow Arthroscopy'),
(14, 'Elbow Arthroplasty'),
(15, 'Cubital Tunnel Syndrome'),
(16, 'Hip Replacement'),
(17, 'Hip Fractures'),
(18, 'Hip impingement Femoroacetabular Impingement'),
(19, 'Hip Osteotomy'),
(20, 'Hip Arthrodesis'),
(21, 'Knee ligament Injury'),
(22, 'Knee osteoarthritis'),
(23, 'Achilles Tendonitis'),
(24, 'Ankle Arthroscopy'),
(25, 'Ankle Arthroplasty'),
(26, 'Ankle Ligament Reconstruction'),
(27, 'Ankle Fracture'),
(28, 'Clubfoot (Talipes Equinovarus)'),
(29, 'Developmental Dysplasia of the Hip'),
(30, 'Scoliosis'),
(31, 'Achondroplasia'),
(32, 'Marfan Syndrome'),
(33, 'Fibrodysplasia Ossificans Progressiva (FOP)'),
(34, 'Diastrophic Dysplasia'),
(35, 'Coronary Artery Disease'),
(36, 'Heart Failure'),
(37, 'Myocardial Infarction'),
(38, 'Peripheral arterial disease'),
(39, 'Cardiac arrythmias'),
(40, 'Valvular Heart Disease'),
(41, 'COPD'),
(42, 'Asthma'),
(43, 'Cystic Fibrosis'),
(44, 'Pulmonary Fibrosis'),
(45, 'Respiratory muscle weakness'),
(46, 'Obstructive sleep apnoea'),
(47, 'Diabetes'),
(48, 'Thyroid Disorders'),
(49, 'Adrenal Insufficiency'),
(50, 'PCOS'),
(51, 'Cushing syndrome'),
(52, 'ADHD'),
(53, 'Autism');

-- --------------------------------------------------------

--
-- Struttura della tabella `ima_pathology_language`
--

DROP TABLE IF EXISTS `ima_pathology_language`;
CREATE TABLE `ima_pathology_language` (
  `Pathology_ID` int(9) NOT NULL,
  `Language_ID` varchar(10) CHARACTER SET utf8 NOT NULL,
  `Name` varchar(255) CHARACTER SET utf8 DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

--
-- Dump dei dati per la tabella `ima_pathology_language`
--

INSERT INTO `ima_pathology_language` (`Pathology_ID`, `Language_ID`, `Name`) VALUES
(1, 'it', 'Parkinson'),
(2, 'it', 'Sclerosi Multipla'),
(3, 'it', 'Ictus'),
(4, 'it', 'Lesioni del midollo spinale'),
(5, 'it', 'Spalla congelata'),
(6, 'it', 'Sostituzione della spalla'),
(7, 'it', 'Sindrome da conflitto alla spalla'),
(8, 'it', 'Strappo della cuffia dei rotatori'),
(9, 'it', 'Lesione del plesso brachiale'),
(10, 'it', 'Fratture del gomito'),
(11, 'it', 'Epicondilite laterale'),
(12, 'it', 'Epicondilite mediale'),
(13, 'it', 'Artroscopia del gomito'),
(14, 'it', 'Protesi di gomito'),
(15, 'it', 'Sindrome del tunnel cubitale'),
(16, 'it', 'Sostituzione dell\'anca'),
(17, 'it', 'Fratture dell\'anca'),
(18, 'it', 'Conflitto femoro-acetabolare'),
(19, 'it', 'Osteotomia dell\'anca'),
(20, 'it', 'Artrodesi dell\'anca'),
(21, 'it', 'Lesione al legamento del ginocchio'),
(22, 'it', 'Artrosi al ginocchio'),
(23, 'it', 'Tendinite d\'Achille'),
(24, 'it', 'Artroscopia di caviglia'),
(25, 'it', 'Protesi di caviglia');

--
-- Indici per le tabelle scaricate
--

--
-- Indici per le tabelle `ima_body_area`
--
ALTER TABLE `ima_body_area`
  ADD PRIMARY KEY (`BodyArea_ID`);

--
-- Indici per le tabelle `ima_body_area_language`
--
ALTER TABLE `ima_body_area_language`
  ADD PRIMARY KEY (`BodyArea_ID`,`Language_ID`) USING BTREE;

--
-- Indici per le tabelle `ima_body_function`
--
ALTER TABLE `ima_body_function`
  ADD PRIMARY KEY (`BodyFunction_ID`);

--
-- Indici per le tabelle `ima_body_function_language`
--
ALTER TABLE `ima_body_function_language`
  ADD PRIMARY KEY (`BodyFunction_ID`,`Language_ID`) USING BTREE;

--
-- Indici per le tabelle `ima_body_part`
--
ALTER TABLE `ima_body_part`
  ADD PRIMARY KEY (`BodyPart_ID`);

--
-- Indici per le tabelle `ima_body_part_language`
--
ALTER TABLE `ima_body_part_language`
  ADD PRIMARY KEY (`BodyPart_ID`,`Language_ID`) USING BTREE;

--
-- Indici per le tabelle `ima_brain_area`
--
ALTER TABLE `ima_brain_area`
  ADD PRIMARY KEY (`BrainArea_ID`);

--
-- Indici per le tabelle `ima_brain_area_language`
--
ALTER TABLE `ima_brain_area_language`
  ADD PRIMARY KEY (`BrainArea_ID`,`Language_ID`) USING BTREE;

--
-- Indici per le tabelle `ima_brain_function`
--
ALTER TABLE `ima_brain_function`
  ADD PRIMARY KEY (`BrainFunction_ID`);

--
-- Indici per le tabelle `ima_brain_function_language`
--
ALTER TABLE `ima_brain_function_language`
  ADD PRIMARY KEY (`BrainFunction_ID`,`Language_ID`) USING BTREE;

--
-- Indici per le tabelle `ima_game_body_mapping`
--
ALTER TABLE `ima_game_body_mapping`
  ADD PRIMARY KEY (`Game_ID`,`BodyArea_ID`,`BodyPart_ID`,`BodyFunction_ID`);

--
-- Indici per le tabelle `ima_game_brain_mapping`
--
ALTER TABLE `ima_game_brain_mapping`
  ADD PRIMARY KEY (`Game_ID`,`BrainArea_ID`,`BrainFunction_ID`);

--
-- Indici per le tabelle `ima_game_pathology`
--
ALTER TABLE `ima_game_pathology`
  ADD PRIMARY KEY (`Game_ID`,`Pathology_ID`);

--
-- Indici per le tabelle `ima_pathology`
--
ALTER TABLE `ima_pathology`
  ADD PRIMARY KEY (`Pathology_ID`);

--
-- Indici per le tabelle `ima_pathology_language`
--
ALTER TABLE `ima_pathology_language`
  ADD PRIMARY KEY (`Pathology_ID`,`Language_ID`);
COMMIT;
