-- phpMyAdmin SQL Dump
-- version 5.2.1
-- https://www.phpmyadmin.net/
--
-- Host: localhost:3306
-- Creato il: Apr 29, 2024 alle 11:15
-- Versione del server: 10.6.17-MariaDB
-- Versione PHP: 8.1.27

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


/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;

--
-- Database: `w84431_rh_vito`
--

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

--
-- 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) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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) NOT NULL,
  `Name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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) NOT NULL,
  `Name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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) NOT NULL,
  `Name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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) NOT NULL,
  `Name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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) NOT NULL,
  `Name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- 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_cogni_area`
--

DROP TABLE IF EXISTS `ima_cogni_area`;
CREATE TABLE `ima_cogni_area` (
  `CogniArea_ID` int(9) NOT NULL,
  `Name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `ima_cogni_area` (`CogniArea_ID`, `Name`) VALUES
(1, 'Attention'),
(2, 'Memory'),
(3, 'Perception'),
(4, 'Metacognitive processes'),
(5, 'No Area');

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

--
-- Struttura della tabella `ima_cogni_area_function`
--

DROP TABLE IF EXISTS `ima_cogni_area_function`;
CREATE TABLE `ima_cogni_area_function` (
  `CogniFunction_ID` int(9) NOT NULL,
  `CogniArea_ID` int(9) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

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

INSERT INTO `ima_cogni_area_function` (`CogniFunction_ID`, `CogniArea_ID`) VALUES
(1, 1),
(2, 1),
(3, 1),
(4, 1),
(5, 1),
(6, 2),
(7, 2),
(8, 2),
(9, 2),
(10, 3),
(11, 3),
(12, 4),
(13, 4),
(14, 4),
(15, 4),
(16, 5),
(17, 5),
(18, 5);

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

--
-- Struttura della tabella `ima_cogni_area_language`
--

DROP TABLE IF EXISTS `ima_cogni_area_language`;
CREATE TABLE `ima_cogni_area_language` (
  `CogniArea_ID` int(9) NOT NULL,
  `Language_ID` varchar(10) NOT NULL,
  `Name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

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

INSERT INTO `ima_cogni_area_language` (`CogniArea_ID`, `Language_ID`, `Name`) VALUES
(1, 'es', 'Atención'),
(1, 'fr', 'Attention'),
(1, 'it', 'Attenzione'),
(2, 'es', 'Memoria'),
(2, 'fr', 'Mémoire'),
(2, 'it', 'Memoria'),
(3, 'es', 'Percepción'),
(3, 'fr', 'Perception'),
(3, 'it', 'Percezione'),
(4, 'es', 'Procesos metacognitivos'),
(4, 'fr', 'Processus métacognitifs'),
(4, 'it', 'Processi Metacognitivi'),
(5, 'es', 'No Area'),
(5, 'fr', 'No Area'),
(5, 'it', 'No Area');

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

--
-- Struttura della tabella `ima_cogni_function`
--

DROP TABLE IF EXISTS `ima_cogni_function`;
CREATE TABLE `ima_cogni_function` (
  `CogniFunction_ID` int(9) NOT NULL,
  `Name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

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

INSERT INTO `ima_cogni_function` (`CogniFunction_ID`, `Name`) VALUES
(1, 'Selective attention'),
(2, 'Sustained attention'),
(3, 'Divided attention'),
(4, 'Alternating attention'),
(5, 'Inhibition'),
(6, 'Working memory'),
(7, 'Sensory memory'),
(8, 'Long term memory'),
(9, 'Short term memory'),
(10, 'Propioception'),
(11, 'Sensory integration'),
(12, 'Planning'),
(13, 'Monitoring'),
(14, 'Evaluation'),
(15, 'Problem Solving'),
(16, 'Language'),
(17, 'Visuospatial coordination'),
(18, 'Calculation');

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

--
-- Struttura della tabella `ima_cogni_function_language`
--

DROP TABLE IF EXISTS `ima_cogni_function_language`;
CREATE TABLE `ima_cogni_function_language` (
  `CogniFunction_ID` int(9) NOT NULL,
  `Language_ID` varchar(10) NOT NULL,
  `Name` varchar(255) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 ROW_FORMAT=DYNAMIC;

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

INSERT INTO `ima_cogni_function_language` (`CogniFunction_ID`, `Language_ID`, `Name`) VALUES
(1, 'es', 'Atención selectiva'),
(1, 'fr', 'Attention sélective'),
(1, 'it', 'Attenzione selettiva'),
(2, 'es', 'Atención sostenida'),
(2, 'fr', 'Attention soutenue'),
(2, 'it', 'Attenzione sostenuta'),
(3, 'es', 'Atención dividida'),
(3, 'fr', 'Attention divisée'),
(3, 'it', 'Attenzione divisa'),
(4, 'es', 'Atención alterna'),
(4, 'fr', 'Attention alternée'),
(4, 'it', 'Attenzione alternata'),
(5, 'es', 'Inhibición'),
(5, 'fr', 'Inhibition'),
(5, 'it', 'Inibizione'),
(6, 'es', 'Memoria de trabajo'),
(6, 'fr', 'Mémoire de travail'),
(6, 'it', 'Memoria di lavoro'),
(7, 'es', 'Memoria sensorial'),
(7, 'fr', 'Mémoire sensorielle'),
(7, 'it', 'Memoria sensoriale'),
(8, 'es', 'Memoria a largo plazo'),
(8, 'fr', 'Mémoire à long terme'),
(8, 'it', 'Memoria a lungo termine'),
(9, 'es', 'Memoria a corto plazo'),
(9, 'fr', 'Mémoire à court terme'),
(9, 'it', 'Memoria a breve termine'),
(10, 'es', 'Propiocepción'),
(10, 'fr', 'Proprioception'),
(10, 'it', 'Propriocezione'),
(11, 'es', 'Integración sensorial'),
(11, 'fr', 'Intégration multisensorielle'),
(11, 'it', 'Integrazione sensoriale'),
(12, 'es', 'Planificación'),
(12, 'fr', 'Planification'),
(12, 'it', 'Pianificazione'),
(13, 'es', 'Seguimiento'),
(13, 'fr', 'Suivi'),
(13, 'it', 'Monitoraggio'),
(14, 'es', 'Evaluación'),
(14, 'fr', 'Évaluation'),
(14, 'it', 'Valutazione'),
(15, 'es', 'Problem Solving'),
(15, 'fr', 'Résolution de problèmes'),
(15, 'it', 'Problem Solving'),
(16, 'es', 'Lenguaje'),
(16, 'fr', 'Langue'),
(16, 'it', 'Linguaggio'),
(17, 'es', 'Coordinación visual y espacial'),
(17, 'fr', 'Coordination visuo-spatiale'),
(17, 'it', 'Coordinazione visuo-spaziale'),
(18, 'es', 'Calculo'),
(18, 'fr', 'Calcul'),
(18, 'it', 'Calcolo');

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

--
-- 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=latin1;

--
-- 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=latin1;

--
-- 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_cogni_mapping`
--

DROP TABLE IF EXISTS `ima_game_cogni_mapping`;
CREATE TABLE `ima_game_cogni_mapping` (
  `Game_ID` int(9) NOT NULL,
  `CogniArea_ID` int(9) NOT NULL,
  `CogniFunction_ID` int(9) NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

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

INSERT INTO `ima_game_cogni_mapping` (`Game_ID`, `CogniArea_ID`, `CogniFunction_ID`) VALUES
(3, 1, 1),
(3, 1, 2),
(3, 1, 3),
(3, 1, 5),
(3, 2, 6),
(3, 5, 17),
(4, 1, 1),
(4, 1, 2),
(4, 1, 3),
(4, 1, 5),
(4, 2, 6),
(4, 5, 17),
(5, 1, 1),
(5, 2, 6),
(5, 5, 17),
(7, 1, 2),
(7, 2, 6),
(7, 3, 10),
(7, 4, 13),
(7, 4, 14),
(7, 5, 17),
(8, 1, 1),
(8, 1, 2),
(8, 1, 3),
(8, 1, 4),
(8, 1, 5),
(8, 2, 6),
(8, 2, 7),
(8, 3, 10),
(8, 3, 11),
(8, 4, 12),
(8, 4, 13),
(8, 4, 14),
(10, 1, 1),
(10, 2, 6),
(10, 2, 7),
(10, 2, 9),
(10, 3, 11),
(10, 4, 13),
(10, 4, 14),
(10, 5, 17),
(14, 1, 1),
(14, 1, 2),
(14, 1, 3),
(14, 1, 4),
(14, 1, 5),
(14, 2, 6),
(14, 2, 8),
(14, 2, 9),
(14, 4, 15),
(14, 5, 16),
(15, 1, 2),
(15, 1, 3),
(15, 2, 6),
(15, 2, 7),
(15, 2, 8),
(15, 2, 9),
(15, 4, 12),
(15, 4, 13),
(15, 4, 14),
(15, 4, 15),
(16, 2, 6),
(16, 4, 12),
(16, 4, 14),
(16, 4, 15),
(16, 5, 18),
(17, 1, 1),
(17, 1, 2),
(17, 1, 4),
(17, 2, 6),
(17, 2, 7),
(17, 4, 12),
(17, 4, 13),
(17, 4, 14),
(17, 4, 15),
(18, 1, 1),
(18, 1, 2),
(18, 1, 3),
(18, 1, 4),
(18, 1, 5),
(18, 2, 6),
(18, 2, 7),
(18, 2, 8),
(18, 2, 9),
(18, 4, 13),
(18, 4, 14),
(18, 5, 17),
(19, 1, 2),
(19, 2, 6),
(19, 3, 10),
(19, 4, 12),
(19, 4, 13),
(19, 4, 14),
(19, 4, 15),
(19, 5, 17),
(20, 1, 1),
(20, 1, 2),
(20, 1, 3),
(20, 1, 4),
(20, 1, 5),
(20, 2, 7),
(20, 3, 10),
(20, 3, 11),
(20, 4, 13),
(20, 5, 17),
(22, 1, 1),
(22, 1, 2),
(22, 1, 3),
(22, 1, 5),
(22, 2, 6),
(22, 5, 17),
(23, 1, 1),
(23, 1, 2),
(23, 1, 3),
(23, 1, 5),
(23, 2, 6),
(23, 5, 17),
(24, 1, 1),
(24, 1, 2),
(24, 1, 3),
(24, 1, 5),
(24, 2, 6),
(24, 5, 17),
(25, 1, 1),
(25, 1, 2),
(25, 1, 3),
(25, 1, 5),
(25, 2, 6),
(25, 5, 17),
(26, 1, 1),
(26, 1, 2),
(26, 2, 6),
(26, 2, 7),
(26, 2, 8),
(26, 3, 10),
(26, 4, 13),
(26, 4, 14),
(26, 5, 17),
(28, 1, 1),
(28, 1, 2),
(28, 2, 6),
(28, 2, 8),
(28, 3, 10),
(28, 4, 13),
(28, 4, 14),
(28, 5, 17),
(30, 1, 1),
(30, 2, 6),
(30, 2, 7),
(30, 4, 13),
(30, 4, 14),
(31, 1, 1),
(31, 2, 6),
(31, 2, 8),
(31, 3, 10),
(31, 3, 11),
(32, 1, 1),
(32, 1, 2),
(32, 1, 4),
(32, 4, 13),
(32, 4, 14),
(36, 1, 2),
(36, 2, 6),
(36, 3, 10),
(36, 4, 12),
(36, 4, 13),
(36, 4, 14),
(36, 4, 15),
(36, 5, 17),
(37, 1, 1),
(37, 1, 2),
(37, 1, 3),
(37, 1, 4),
(37, 2, 6),
(37, 2, 7),
(37, 3, 10),
(37, 3, 11),
(37, 4, 12),
(37, 4, 13),
(37, 4, 14),
(37, 4, 15),
(39, 1, 1),
(39, 1, 2),
(39, 2, 6),
(39, 2, 7),
(39, 3, 10),
(39, 3, 11),
(39, 4, 13),
(39, 4, 14),
(40, 3, 10),
(40, 3, 11),
(40, 5, 17),
(41, 1, 1),
(41, 1, 2),
(41, 1, 3),
(41, 1, 4),
(41, 1, 5),
(41, 2, 6),
(41, 2, 8),
(41, 2, 9),
(41, 3, 10),
(41, 3, 11),
(41, 4, 12),
(41, 4, 13),
(41, 4, 14),
(42, 1, 1),
(42, 1, 4),
(42, 2, 6),
(42, 3, 10),
(42, 4, 12),
(42, 4, 13),
(42, 4, 14),
(42, 5, 17),
(44, 1, 1),
(44, 1, 4),
(44, 3, 10),
(44, 4, 13),
(44, 4, 14),
(44, 5, 17),
(54, 1, 1),
(54, 1, 4),
(54, 3, 10),
(54, 4, 13),
(54, 4, 14),
(54, 5, 17),
(59, 1, 1),
(59, 1, 2),
(59, 1, 3),
(59, 1, 4),
(59, 2, 6),
(59, 2, 8),
(59, 2, 9),
(59, 3, 11),
(59, 4, 14),
(59, 4, 15),
(59, 5, 17),
(60, 1, 1),
(60, 1, 2),
(60, 1, 3),
(60, 1, 4),
(60, 1, 5),
(60, 2, 6),
(60, 2, 8),
(60, 2, 9),
(60, 3, 10),
(60, 4, 12),
(60, 4, 13),
(60, 4, 14),
(60, 4, 15),
(60, 5, 17),
(63, 1, 1),
(63, 1, 2),
(63, 3, 10),
(63, 3, 11),
(63, 4, 12),
(63, 4, 13),
(63, 4, 14),
(63, 5, 17),
(64, 1, 1),
(64, 1, 4),
(64, 2, 6),
(64, 4, 12),
(64, 4, 13),
(64, 4, 14),
(65, 1, 1),
(65, 1, 2),
(65, 1, 3),
(65, 1, 4),
(65, 1, 5),
(65, 2, 6),
(65, 2, 8),
(65, 2, 9),
(65, 3, 10),
(65, 3, 11),
(65, 4, 12),
(65, 4, 13),
(65, 4, 14),
(65, 4, 15);

--
-- 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_cogni_area`
--
ALTER TABLE `ima_cogni_area`
  ADD PRIMARY KEY (`CogniArea_ID`);

--
-- Indici per le tabelle `ima_cogni_area_function`
--
ALTER TABLE `ima_cogni_area_function`
  ADD PRIMARY KEY (`CogniFunction_ID`,`CogniArea_ID`) USING BTREE;

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

--
-- Indici per le tabelle `ima_cogni_function`
--
ALTER TABLE `ima_cogni_function`
  ADD PRIMARY KEY (`CogniFunction_ID`) USING BTREE;

--
-- Indici per le tabelle `ima_cogni_function_language`
--
ALTER TABLE `ima_cogni_function_language`
  ADD PRIMARY KEY (`CogniFunction_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_cogni_mapping`
--
ALTER TABLE `ima_game_cogni_mapping`
  ADD PRIMARY KEY (`Game_ID`,`CogniArea_ID`,`CogniFunction_ID`);
COMMIT;

/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;