-- MySQL dump 10.13  Distrib 5.7.12, for Win32 (AMD64)
--
-- Host: localhost    Database: toreador_db_2
-- ------------------------------------------------------
-- Server version	5.6.33

/*!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 utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `datadensity`
--

DROP TABLE IF EXISTS `datadensity`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `datadensity` (
  `iddatadensity` int(11) NOT NULL,
  `value` varchar(45) DEFAULT NULL,
  `score` float DEFAULT NULL,
  `graph` int(11) DEFAULT NULL,
  PRIMARY KEY (`iddatadensity`),
  KEY `idgraph_dd_idx` (`graph`),
  CONSTRAINT `idgraph_dd` FOREIGN KEY (`graph`) REFERENCES `graphs` (`idgraphs`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `datadensity`
--

LOCK TABLES `datadensity` WRITE;
/*!40000 ALTER TABLE `datadensity` DISABLE KEYS */;
INSERT INTO `datadensity` VALUES (1,'High',-0.5,1),(2,'Low',1,1),(3,'High',-0.5,2),(4,'Low',1,2),(5,'High',1,3),(6,'Low',0,3),(7,'High',1,4),(8,'Low',0,4),(9,'High',1,5),(10,'Low',0,5),(11,'High',-0.5,6),(12,'Low',1,6),(13,'High',0.5,7),(14,'Low',0.5,7),(15,'High',-0.5,8),(16,'Low',0.5,8),(17,'High',-0.5,9),(18,'Low',0.5,9),(19,'High',0.5,10),(20,'Low',-1,10),(21,'High',0.5,11),(22,'Low',-0.5,11),(23,'High',-0.5,12),(24,'Low',0.5,12),(25,'High',1,13),(26,'Low',-0.5,13),(27,'High',0,14),(28,'Low',0,14),(29,'High',-0.5,15),(30,'Low',1,15),(31,'High',-0.5,16),(32,'Low',1,16),(33,'High',1,17),(34,'Low',-1,17),(35,'High',-0.5,18),(36,'Low',0.5,18),(37,'High',-0.5,19),(38,'Low',0.5,19),(39,'High',0.5,20),(40,'Low',-0.5,20),(41,'High',-0.5,21),(42,'Low',0.5,21),(43,'High',-0.5,22),(44,'Low',0.5,22),(45,'High',0.5,23),(46,'Low',-0.5,23),(47,'High',0.5,24),(48,'Low',-1,24),(49,'High',1,25),(50,'Low',-0.5,25),(51,'High',-0.5,26),(52,'Low',1,26),(53,'High',-0.5,27),(54,'Low',1,27),(55,'High',-0.5,28),(56,'Low',1,28),(57,'High',-0.5,29),(58,'Low',1,29),(59,'High',0,30),(60,'Low',0,30),(61,'High',0,31),(62,'Low',0,31),(63,'High',1,32),(64,'Low',-0.5,32),(65,'High',-0.5,33),(66,'Low',1,33),(67,'High',-0.5,34),(68,'Low',1,34),(69,'High',-0.5,35),(70,'Low',1,35),(71,'High',-0.5,36),(72,'Low',1,36),(73,'High',0,37),(74,'Low',0,37),(75,'High',0,38),(76,'Low',0,38),(77,'High',1,39),(78,'Low',0,39),(79,'High',1,40),(80,'Low',0,40),(81,'High',1,41),(82,'Low',0,41),(83,'High',1,42),(84,'Low',0,42),(85,'High',1,43),(86,'Low',-0.5,43),(87,'High',-0.5,44),(88,'Low',1,44),(89,'High',1,45),(90,'Low',-0.5,45),(91,'High',-0.5,46),(92,'Low',1,46),(93,'High',-0.5,47),(94,'Low',1,47),(95,'High',1,48),(96,'Low',-0.5,48),(97,'High',1,49),(98,'Low',-0.5,49),(99,'High',1,50),(100,'Low',-0.5,50),(101,'High',1,51),(102,'Low',-0.5,51),(103,'High',1,52),(104,'Low',-0.5,52),(105,'High',-1,53),(106,'Low',1,53),(107,'High',0.5,54),(108,'Low',0.5,54),(109,'High',-0.5,55),(110,'Low',0.5,55),(111,'High',-0.5,56),(112,'Low',0.5,56);
/*!40000 ALTER TABLE `datadensity` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `datatype`
--

DROP TABLE IF EXISTS `datatype`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `datatype` (
  `iddatatype` int(11) NOT NULL,
  `value` varchar(45) DEFAULT NULL,
  `score` float DEFAULT NULL,
  `graph` int(11) DEFAULT NULL,
  PRIMARY KEY (`iddatatype`),
  KEY `idgraph_dt_idx` (`graph`),
  CONSTRAINT `idgraph_dt` FOREIGN KEY (`graph`) REFERENCES `graphs` (`idgraphs`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `datatype`
--

LOCK TABLES `datatype` WRITE;
/*!40000 ALTER TABLE `datatype` DISABLE KEYS */;
INSERT INTO `datatype` VALUES (1,'Nominal',-1,1),(2,'Ordinal',-1,1),(3,'Interval',-1,1),(4,'Ratio',1,1),(5,'Nominal',-1,2),(6,'Ordinal',-1,2),(7,'Interval',-1,2),(8,'Ratio',1,2),(9,'Nominal',-1,3),(10,'Ordinal',-1,3),(11,'Interval',1,3),(12,'Ratio',1,3),(13,'Nominal',-1,4),(14,'Ordinal',-1,4),(15,'Interval',1,4),(16,'Ratio',1,4),(17,'Nominal',0,5),(18,'Ordinal',0,5),(19,'Interval',0,5),(20,'Ratio',0,5),(21,'Nominal',-1,6),(22,'Ordinal',-0.5,6),(23,'Interval',0.5,6),(24,'Ratio',1,6),(25,'Nominal',-1,7),(26,'Ordinal',1,7),(27,'Interval',1,7),(28,'Ratio',1,7),(29,'Nominal',-1,8),(30,'Ordinal',0.5,8),(31,'Interval',0.5,8),(32,'Ratio',0.5,8),(33,'Nominal',1,9),(34,'Ordinal',0.5,9),(35,'Interval',0.5,9),(36,'Ratio',0.5,9),(37,'Nominal',-1,10),(38,'Ordinal',-1,10),(39,'Interval',-1,10),(40,'Ratio',1,10),(41,'Nominal',0,11),(42,'Ordinal',-1,11),(43,'Interval',-0.5,11),(44,'Ratio',1,11),(45,'Nominal',0,12),(46,'Ordinal',-1,12),(47,'Interval',-0.5,12),(48,'Ratio',1,12),(49,'Nominal',1,13),(50,'Ordinal',1,13),(51,'Interval',1,13),(52,'Ratio',1,13),(53,'Nominal',0,14),(54,'Ordinal',0,14),(55,'Interval',0,14),(56,'Ratio',0,14),(57,'Nominal',1,15),(58,'Ordinal',-1,15),(59,'Interval',1,15),(60,'Ratio',-1,15),(61,'Nominal',-1,16),(62,'Ordinal',-1,16),(63,'Interval',1,16),(64,'Ratio',-1,16),(65,'Nominal',-1,17),(66,'Ordinal',-0.5,17),(67,'Interval',0.5,17),(68,'Ratio',1,17),(69,'Nominal',-1,18),(70,'Ordinal',0.5,18),(71,'Interval',0.5,18),(72,'Ratio',0.5,18),(73,'Nominal',0.5,19),(74,'Ordinal',0.5,19),(75,'Interval',1,19),(76,'Ratio',1,19),(77,'Nominal',1,20),(78,'Ordinal',1,20),(79,'Interval',0.5,20),(80,'Ratio',0.5,20),(81,'Nominal',-1,21),(82,'Ordinal',-1,21),(83,'Interval',0.5,21),(84,'Ratio',1,21),(85,'Nominal',-1,22),(86,'Ordinal',-1,22),(87,'Interval',0.5,22),(88,'Ratio',1,22),(89,'Nominal',-1,23),(90,'Ordinal',0.5,23),(91,'Interval',1,23),(92,'Ratio',1,23),(93,'Nominal',-1,24),(94,'Ordinal',-1,24),(95,'Interval',-1,24),(96,'Ratio',1,24),(97,'Nominal',-1,25),(98,'Ordinal',0,25),(99,'Interval',1,25),(100,'Ratio',1,25),(101,'Nominal',-1,26),(102,'Ordinal',0,26),(103,'Interval',1,26),(104,'Ratio',1,26),(105,'Nominal',-1,27),(106,'Ordinal',0,27),(107,'Interval',1,27),(108,'Ratio',1,27),(109,'Nominal',-1,28),(110,'Ordinal',0,28),(111,'Interval',1,28),(112,'Ratio',1,28),(113,'Nominal',-1,29),(114,'Ordinal',0,29),(115,'Interval',1,29),(116,'Ratio',1,29),(117,'Nominal',0,30),(118,'Ordinal',0,30),(119,'Interval',0,30),(120,'Ratio',0,30),(121,'Nominal',0,31),(122,'Ordinal',0,31),(123,'Interval',0,31),(124,'Ratio',0,31),(125,'Nominal',1,32),(126,'Ordinal',0.5,32),(127,'Interval',-1,32),(128,'Ratio',-1,32),(129,'Nominal',1,33),(130,'Ordinal',0.5,33),(131,'Interval',-1,33),(132,'Ratio',-1,33),(133,'Nominal',1,34),(134,'Ordinal',0.5,34),(135,'Interval',-1,34),(136,'Ratio',-1,34),(137,'Nominal',1,35),(138,'Ordinal',0.5,35),(139,'Interval',-1,35),(140,'Ratio',-1,35),(141,'Nominal',1,36),(142,'Ordinal',0.5,36),(143,'Interval',-1,36),(144,'Ratio',-1,36),(145,'Nominal',0,37),(146,'Ordinal',0,37),(147,'Interval',0,37),(148,'Ratio',0,37),(149,'Nominal',0,38),(150,'Ordinal',0,38),(151,'Interval',0,38),(152,'Ratio',0,38),(153,'Nominal',-1,39),(154,'Ordinal',-1,39),(155,'Interval',1,39),(156,'Ratio',1,39),(157,'Nominal',-1,40),(158,'Ordinal',-1,40),(159,'Interval',1,40),(160,'Ratio',1,40),(161,'Nominal',-1,41),(162,'Ordinal',-1,41),(163,'Interval',1,41),(164,'Ratio',1,41),(165,'Nominal',-1,42),(166,'Ordinal',-1,42),(167,'Interval',1,42),(168,'Ratio',1,42),(169,'Nominal',1,43),(170,'Ordinal',-1,43),(171,'Interval',-1,43),(172,'Ratio',-1,43),(173,'Nominal',1,44),(174,'Ordinal',1,44),(175,'Interval',1,44),(176,'Ratio',1,44),(177,'Nominal',1,45),(178,'Ordinal',1,45),(179,'Interval',1,45),(180,'Ratio',1,45),(181,'Nominal',-1,46),(182,'Ordinal',-1,46),(183,'Interval',-0.5,46),(184,'Ratio',1,46),(185,'Nominal',1,47),(186,'Ordinal',1,47),(187,'Interval',1,47),(188,'Ratio',-0.5,47),(189,'Nominal',1,48),(190,'Ordinal',1,48),(191,'Interval',1,48),(192,'Ratio',0,48),(193,'Nominal',1,49),(194,'Ordinal',1,49),(195,'Interval',1,49),(196,'Ratio',-0.5,49),(197,'Nominal',1,50),(198,'Ordinal',1,50),(199,'Interval',-1,50),(200,'Ratio',-1,50),(201,'Nominal',1,51),(202,'Ordinal',1,51),(203,'Interval',-1,51),(204,'Ratio',-1,51),(205,'Nominal',1,52),(206,'Ordinal',1,52),(207,'Interval',-1,52),(208,'Ratio',-1,52),(209,'Nominal',0,53),(210,'Ordinal',0,53),(211,'Interval',0,53),(212,'Ratio',0,53),(213,'Nominal',-1,54),(214,'Ordinal',1,54),(215,'Interval',1,54),(216,'Ratio',1,54),(217,'Nominal',-1,55),(218,'Ordinal',-0.5,55),(219,'Interval',0.5,55),(220,'Ratio',1,55),(221,'Nominal',-1,56),(222,'Ordinal',-0.5,56),(223,'Interval',0.5,56),(224,'Ratio',1,56);
/*!40000 ALTER TABLE `datatype` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `dimensionality`
--

DROP TABLE IF EXISTS `dimensionality`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `dimensionality` (
  `iddimensionality` int(11) NOT NULL,
  `value` varchar(45) DEFAULT NULL,
  `score` float DEFAULT NULL,
  `graph` int(11) DEFAULT NULL,
  PRIMARY KEY (`iddimensionality`),
  KEY `idgraph_dim_idx` (`graph`),
  CONSTRAINT `idgraph_dim` FOREIGN KEY (`graph`) REFERENCES `graphs` (`idgraphs`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `dimensionality`
--

LOCK TABLES `dimensionality` WRITE;
/*!40000 ALTER TABLE `dimensionality` DISABLE KEYS */;
INSERT INTO `dimensionality` VALUES (1,'2D',1,1),(2,'Tree',-1,1),(3,'nD',-1,1),(4,'Graph',-1,1),(5,'1D',-1,1),(6,'2D',-1,2),(7,'Tree',-1,2),(8,'nD',1,2),(9,'Graph',-1,2),(10,'1D',-1,2),(11,'2D',1,3),(12,'Tree',-1,3),(13,'nD',-1,3),(14,'Graph',-1,3),(15,'1D',-1,3),(16,'2D',-1,4),(17,'Tree',-1,4),(18,'nD',1,4),(19,'Graph',-1,4),(20,'1D',-1,4),(21,'2D',0,5),(22,'Tree',0,5),(23,'nD',0,5),(24,'Graph',0,5),(25,'1D',0,5),(26,'2D',1,6),(27,'Tree',-1,6),(28,'nD',-1,6),(29,'Graph',-1,6),(30,'1D',-1,6),(31,'2D',-1,7),(32,'Tree',-1,7),(33,'nD',-1,7),(34,'Graph',-1,7),(35,'1D',1,7),(36,'2D',-1,8),(37,'Tree',1,8),(38,'nD',-1,8),(39,'Graph',-1,8),(40,'1D',-1,8),(41,'2D',-1,9),(42,'Tree',-1,9),(43,'nD',-1,9),(44,'Graph',1,9),(45,'1D',-1,9),(46,'2D',-1,10),(47,'Tree',-1,10),(48,'nD',1,10),(49,'Graph',-1,10),(50,'1D',-1,10),(51,'2D',1,11),(52,'Tree',-1,11),(53,'nD',-1,11),(54,'Graph',-1,11),(55,'1D',-1,11),(56,'2D',-1,12),(57,'Tree',-1,12),(58,'nD',1,12),(59,'Graph',-1,12),(60,'1D',-1,12),(61,'2D',1,13),(62,'Tree',-1,13),(63,'nD',1,13),(64,'Graph',-1,13),(65,'1D',-1,13),(66,'2D',0,14),(67,'Tree',0,14),(68,'nD',0,14),(69,'Graph',0,14),(70,'1D',0,14),(71,'2D',1,15),(72,'Tree',-1,15),(73,'nD',-1,15),(74,'Graph',-1,15),(75,'1D',-1,15),(76,'2D',1,16),(77,'Tree',-1,16),(78,'nD',-1,16),(79,'Graph',-1,16),(80,'1D',-1,16),(81,'2D',1,17),(82,'Tree',-1,17),(83,'nD',-1,17),(84,'Graph',-1,17),(85,'1D',-1,17),(86,'2D',-1,18),(87,'Tree',1,18),(88,'nD',-1,18),(89,'Graph',-1,18),(90,'1D',-1,18),(91,'2D',-1,19),(92,'Tree',-1,19),(93,'nD',1,19),(94,'Graph',-1,19),(95,'1D',-1,19),(96,'2D',-1,20),(97,'Tree',-1,20),(98,'nD',1,20),(99,'Graph',-1,20),(100,'1D',-1,20),(101,'2D',-1,21),(102,'Tree',-1,21),(103,'nD',1,21),(104,'Graph',-1,21),(105,'1D',-1,21),(106,'2D',1,22),(107,'Tree',-1,22),(108,'nD',-1,22),(109,'Graph',-1,22),(110,'1D',-1,22),(112,'2D',-1,23),(113,'Tree',-1,23),(114,'nD',1,23),(115,'Graph',-1,23),(116,'1D',-1,23),(117,'2D',-1,24),(118,'Tree',-1,24),(119,'nD',1,24),(120,'Graph',-1,24),(121,'1D',-1,24),(122,'2D',-1,25),(123,'Tree',-1,25),(124,'nD',1,25),(125,'Graph',-1,25),(126,'1D',-1,25),(127,'2D',-1,26),(128,'Tree',-1,26),(129,'nD',1,26),(130,'Graph',-1,26),(131,'1D',-1,26),(132,'2D',-1,27),(133,'Tree',-1,27),(134,'nD',1,27),(135,'Graph',-1,27),(136,'1D',-1,27),(137,'2D',-1,28),(138,'Tree',-1,28),(139,'nD',1,28),(140,'Graph',-1,28),(141,'1D',-1,28),(142,'2D',-1,29),(143,'Tree',-1,29),(144,'nD',1,29),(145,'Graph',-1,29),(146,'1D',-1,29),(147,'2D',0,30),(148,'Tree',0,30),(149,'nD',0,30),(150,'Graph',0,30),(151,'1D',0,30),(152,'2D',0,31),(153,'Tree',0,31),(154,'nD',0,31),(155,'Graph',0,31),(156,'1D',0,31),(157,'2D',-1,32),(158,'Tree',-1,32),(159,'nD',1,32),(160,'Graph',-1,32),(161,'1D',-1,32),(162,'2D',-1,33),(163,'Tree',-1,33),(164,'nD',1,33),(165,'Graph',-1,33),(166,'1D',-1,33),(167,'2D',-1,34),(168,'Tree',-1,34),(169,'nD',1,34),(170,'Graph',-1,34),(171,'1D',-1,34),(172,'2D',-1,35),(173,'Tree',-1,35),(174,'nD',1,35),(175,'Graph',-1,35),(176,'1D',-1,35),(177,'2D',-1,36),(178,'Tree',-1,36),(179,'nD',1,36),(180,'Graph',-1,36),(181,'1D',-1,36),(182,'2D',0,37),(183,'Tree',0,37),(184,'nD',0,37),(185,'Graph',0,37),(186,'1D',0,37),(187,'2D',0,38),(188,'Tree',0,38),(189,'nD',0,38),(190,'Graph',0,38),(191,'1D',0,38),(192,'2D',1,39),(193,'Tree',-1,39),(194,'nD',-1,39),(195,'Graph',-1,39),(196,'1D',-1,39),(197,'2D',-1,40),(198,'Tree',-1,40),(199,'nD',1,40),(200,'Graph',-1,40),(201,'1D',-1,40),(202,'2D',-1,41),(203,'Tree',-1,41),(204,'nD',1,41),(205,'Graph',-1,41),(206,'1D',-1,41),(207,'2D',-1,42),(208,'Tree',-1,42),(209,'nD',1,42),(210,'Graph',-1,42),(211,'1D',-1,42),(212,'2D',-1,43),(213,'Tree',-1,43),(214,'nD',1,43),(215,'Graph',-1,43),(216,'1D',-1,43),(217,'2D',-1,44),(218,'Tree',-1,44),(219,'nD',1,44),(220,'Graph',-1,44),(221,'1D',-1,44),(222,'2D',1,45),(223,'Tree',-1,45),(224,'nD',1,45),(225,'Graph',-1,45),(226,'1D',-1,45),(227,'2D',-1,46),(228,'Tree',-1,46),(229,'nD',1,46),(230,'Graph',-1,46),(231,'1D',-1,46),(232,'2D',0.5,47),(233,'Tree',-1,47),(234,'nD',1,47),(235,'Graph',-1,47),(236,'1D',-1,47),(237,'2D',-1,48),(238,'Tree',-1,48),(239,'nD',1,48),(240,'Graph',-1,48),(241,'1D',-1,48),(242,'2D',-1,49),(243,'Tree',-1,49),(244,'nD',1,49),(245,'Graph',-1,49),(246,'1D',-1,49),(247,'2D',-1,50),(248,'Tree',-1,50),(249,'nD',1,50),(250,'Graph',-1,50),(251,'1D',-1,50),(252,'2D',-1,51),(253,'Tree',-1,51),(254,'nD',1,51),(255,'Graph',-1,51),(256,'1D',-1,51),(257,'2D',-1,52),(258,'Tree',-1,52),(259,'nD',1,52),(260,'Graph',-1,52),(261,'1D',-1,52),(262,'2D',-1,53),(263,'Tree',-1,53),(264,'nD',-1,53),(265,'Graph',-1,53),(266,'1D',1,53),(267,'2D',-1,54),(268,'Tree',-1,54),(269,'nD',-1,54),(270,'Graph',-1,54),(271,'1D',1,54),(272,'2D',1,55),(273,'Tree',-1,55),(274,'nD',-1,55),(275,'Graph',-1,55),(276,'1D',-1,55),(277,'2D',1,56),(278,'Tree',-1,56),(279,'nD',-1,56),(280,'Graph',-1,56),(281,'1D',-1,56);
/*!40000 ALTER TABLE `dimensionality` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `goal`
--

DROP TABLE IF EXISTS `goal`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `goal` (
  `idgoal` int(11) NOT NULL AUTO_INCREMENT,
  `value` varchar(45) DEFAULT NULL,
  `score` int(11) DEFAULT NULL,
  `graph` int(11) DEFAULT NULL,
  PRIMARY KEY (`idgoal`),
  KEY `idgraph_goal_idx` (`graph`),
  CONSTRAINT `idgraph_goal` FOREIGN KEY (`graph`) REFERENCES `graphs` (`idgraphs`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=449 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `goal`
--

LOCK TABLES `goal` WRITE;
/*!40000 ALTER TABLE `goal` DISABLE KEYS */;
INSERT INTO `goal` VALUES (1,'Trends',-1,1),(2,'Distribution',-1,1),(3,'Relationship',-1,1),(4,'Comparison',0,1),(5,'Cluster/Categorize',-1,1),(6,'Composition',1,1),(7,'Geospatial',-1,1),(8,'Order/rank/sort',0,1),(9,'Trends',-1,2),(10,'Distribution',-1,2),(11,'Relationship',-1,2),(12,'Comparison',0,2),(13,'Cluster/Categorize',-1,2),(14,'Composition',1,2),(15,'Geospatial',-1,2),(16,'Order/rank/sort',0,2),(17,'Trends',1,3),(18,'Distribution',-1,3),(19,'Relationship',-1,3),(20,'Comparison',1,3),(21,'Cluster/Categorize',-1,3),(22,'Composition',-1,3),(23,'Geospatial',-1,3),(24,'Order/rank/sort',-1,3),(25,'Trends',1,4),(26,'Distribution',-1,4),(27,'Relationship',1,4),(28,'Comparison',1,4),(29,'Cluster/Categorize',-1,4),(30,'Composition',1,4),(31,'Geospatial',-1,4),(32,'Order/rank/sort',-1,4),(33,'Trends',1,5),(34,'Distribution',0,5),(35,'Relationship',0,5),(36,'Comparison',0,5),(37,'Cluster/Categorize',0,5),(38,'Composition',0,5),(39,'Geospatial',0,5),(40,'Order/rank/sort',0,5),(41,'Trends',1,6),(42,'Distribution',1,6),(43,'Relationship',-1,6),(44,'Comparison',-1,6),(45,'Cluster/Categorize',-1,6),(46,'Composition',-1,6),(47,'Geospatial',-1,6),(48,'Order/rank/sort',-1,6),(49,'Trends',-1,7),(50,'Distribution',-1,7),(51,'Relationship',-1,7),(52,'Comparison',-1,7),(53,'Cluster/Categorize',-1,7),(54,'Composition',-1,7),(55,'Geospatial',-1,7),(56,'Order/rank/sort',-1,7),(57,'Trends',-1,8),(58,'Distribution',1,8),(59,'Relationship',1,8),(60,'Comparison',-1,8),(61,'Cluster/Categorize',1,8),(62,'Composition',-1,8),(63,'Geospatial',-1,8),(64,'Order/rank/sort',-1,8),(65,'Trends',-1,9),(66,'Distribution',1,9),(67,'Relationship',1,9),(68,'Comparison',-1,9),(69,'Cluster/Categorize',1,9),(70,'Composition',-1,9),(71,'Geospatial',-1,9),(72,'Order/rank/sort',-1,9),(73,'Trends',1,10),(74,'Distribution',-1,10),(75,'Relationship',-1,10),(76,'Comparison',1,10),(77,'Cluster/Categorize',-1,10),(78,'Composition',-1,10),(79,'Geospatial',-1,10),(80,'Order/rank/sort',-1,10),(81,'Trends',1,11),(82,'Distribution',1,11),(83,'Relationship',1,11),(84,'Comparison',-1,11),(85,'Cluster/Categorize',1,11),(86,'Composition',-1,11),(87,'Geospatial',-1,11),(88,'Order/rank/sort',-1,11),(89,'Trends',1,12),(90,'Distribution',1,12),(91,'Relationship',1,12),(92,'Comparison',1,12),(93,'Cluster/Categorize',1,12),(94,'Composition',-1,12),(95,'Geospatial',-1,12),(96,'Order/rank/sort',-1,12),(97,'Trends',1,13),(98,'Distribution',1,13),(99,'Relationship',1,13),(100,'Comparison',-1,13),(101,'Cluster/Categorize',-1,13),(102,'Composition',-1,13),(103,'Geospatial',-1,13),(104,'Order/rank/sort',1,13),(105,'Trends',0,14),(106,'Distribution',0,14),(107,'Relationship',0,14),(108,'Comparison',0,14),(109,'Cluster/Categorize',0,14),(110,'Composition',0,14),(111,'Geospatial',0,14),(112,'Order/rank/sort',0,14),(113,'Trends',-1,15),(114,'Distribution',1,15),(115,'Relationship',-1,15),(116,'Comparison',1,15),(117,'Cluster/Categorize',-1,15),(118,'Composition',1,15),(119,'Geospatial',-1,15),(120,'Order/rank/sort',-1,15),(121,'Trends',1,16),(122,'Distribution',1,16),(123,'Relationship',-1,16),(124,'Comparison',1,16),(125,'Cluster/Categorize',-1,16),(126,'Composition',1,16),(127,'Geospatial',-1,16),(128,'Order/rank/sort',-1,16),(129,'Trends',1,17),(130,'Distribution',1,17),(131,'Relationship',-1,17),(132,'Comparison',-1,17),(133,'Cluster/Categorize',-1,17),(134,'Composition',-1,17),(135,'Geospatial',-1,17),(136,'Order/rank/sort',1,17),(137,'Trends',-1,18),(138,'Distribution',1,18),(139,'Relationship',1,18),(140,'Comparison',-1,18),(141,'Cluster/Categorize',1,18),(142,'Composition',-1,18),(143,'Geospatial',-1,18),(144,'Order/rank/sort',-1,18),(145,'Trends',-1,19),(146,'Distribution',1,19),(147,'Relationship',-1,19),(148,'Comparison',1,19),(149,'Cluster/Categorize',1,19),(150,'Composition',-1,19),(151,'Geospatial',1,19),(152,'Order/rank/sort',-1,19),(153,'Trends',-1,20),(154,'Distribution',1,20),(155,'Relationship',-1,20),(156,'Comparison',1,20),(157,'Cluster/Categorize',1,20),(158,'Composition',-1,20),(159,'Geospatial',1,20),(160,'Order/rank/sort',-1,20),(161,'Trends',-1,21),(162,'Distribution',1,21),(163,'Relationship',1,21),(164,'Comparison',-1,21),(165,'Cluster/Categorize',1,21),(166,'Composition',-1,21),(167,'Geospatial',-1,21),(168,'Order/rank/sort',-1,21),(169,'Trends',-1,22),(170,'Distribution',1,22),(171,'Relationship',1,22),(172,'Comparison',-1,22),(173,'Cluster/Categorize',1,22),(174,'Composition',-1,22),(175,'Geospatial',-1,22),(176,'Order/rank/sort',-1,22),(177,'Trends',-1,23),(178,'Distribution',-1,23),(179,'Relationship',1,23),(180,'Comparison',1,23),(181,'Cluster/Categorize',-1,23),(182,'Composition',1,23),(183,'Geospatial',-1,23),(184,'Order/rank/sort',-1,23),(185,'Trends',1,24),(186,'Distribution',-1,24),(187,'Relationship',-1,24),(188,'Comparison',1,24),(189,'Cluster/Categorize',-1,24),(190,'Composition',-1,24),(191,'Geospatial',-1,24),(192,'Order/rank/sort',-1,24),(193,'Trends',-1,25),(194,'Distribution',1,25),(195,'Relationship',0,25),(196,'Comparison',1,25),(197,'Cluster/Categorize',-1,25),(198,'Composition',1,25),(199,'Geospatial',-1,25),(200,'Order/rank/sort',-1,25),(201,'Trends',-1,26),(202,'Distribution',1,26),(203,'Relationship',1,26),(204,'Comparison',1,26),(205,'Cluster/Categorize',-1,26),(206,'Composition',1,26),(207,'Geospatial',-1,26),(208,'Order/rank/sort',-1,26),(209,'Trends',-1,27),(210,'Distribution',1,27),(211,'Relationship',-1,27),(212,'Comparison',1,27),(213,'Cluster/Categorize',-1,27),(214,'Composition',1,27),(215,'Geospatial',-1,27),(216,'Order/rank/sort',-1,27),(217,'Trends',-1,28),(218,'Distribution',1,28),(219,'Relationship',-1,28),(220,'Comparison',1,28),(221,'Cluster/Categorize',-1,28),(222,'Composition',1,28),(223,'Geospatial',-1,28),(224,'Order/rank/sort',-1,28),(225,'Trends',-1,29),(226,'Distribution',1,29),(227,'Relationship',0,29),(228,'Comparison',1,29),(229,'Cluster/Categorize',-1,29),(230,'Composition',1,29),(231,'Geospatial',-1,29),(232,'Order/rank/sort',-1,29),(233,'Trends',0,30),(234,'Distribution',1,30),(235,'Relationship',-1,30),(236,'Comparison',0,30),(237,'Cluster/Categorize',0,30),(238,'Composition',0,30),(239,'Geospatial',0,30),(240,'Order/rank/sort',0,30),(241,'Trends',0,31),(242,'Distribution',1,31),(243,'Relationship',-1,31),(244,'Comparison',0,31),(245,'Cluster/Categorize',0,31),(246,'Composition',0,31),(247,'Geospatial',0,31),(248,'Order/rank/sort',0,31),(249,'Trends',1,32),(250,'Distribution',1,32),(251,'Relationship',0,32),(252,'Comparison',0,32),(253,'Cluster/Categorize',-1,32),(254,'Composition',1,32),(255,'Geospatial',-1,32),(256,'Order/rank/sort',-1,32),(257,'Trends',1,33),(258,'Distribution',1,33),(259,'Relationship',1,33),(260,'Comparison',1,33),(261,'Cluster/Categorize',-1,33),(262,'Composition',1,33),(263,'Geospatial',-1,33),(264,'Order/rank/sort',-1,33),(265,'Trends',1,34),(266,'Distribution',1,34),(267,'Relationship',-1,34),(268,'Comparison',0,34),(269,'Cluster/Categorize',-1,34),(270,'Composition',1,34),(271,'Geospatial',-1,34),(272,'Order/rank/sort',-1,34),(273,'Trends',1,35),(274,'Distribution',1,35),(275,'Relationship',-1,35),(276,'Comparison',1,35),(277,'Cluster/Categorize',-1,35),(278,'Composition',1,35),(279,'Geospatial',-1,35),(280,'Order/rank/sort',-1,35),(281,'Trends',1,36),(282,'Distribution',1,36),(283,'Relationship',0,36),(284,'Comparison',0,36),(285,'Cluster/Categorize',-1,36),(286,'Composition',1,36),(287,'Geospatial',-1,36),(288,'Order/rank/sort',-1,36),(289,'Trends',1,37),(290,'Distribution',1,37),(291,'Relationship',-1,37),(292,'Comparison',0,37),(293,'Cluster/Categorize',0,37),(294,'Composition',1,37),(295,'Geospatial',0,37),(296,'Order/rank/sort',0,37),(297,'Trends',0,38),(298,'Distribution',1,38),(299,'Relationship',-1,38),(300,'Comparison',0,38),(301,'Cluster/Categorize',0,38),(302,'Composition',0,38),(303,'Geospatial',0,38),(304,'Order/rank/sort',0,38),(305,'Trends',1,39),(306,'Distribution',-1,39),(307,'Relationship',-1,39),(308,'Comparison',1,39),(309,'Cluster/Categorize',-1,39),(310,'Composition',-1,39),(311,'Geospatial',-1,39),(312,'Order/rank/sort',-1,39),(313,'Trends',1,40),(314,'Distribution',1,40),(315,'Relationship',-1,40),(316,'Comparison',0,40),(317,'Cluster/Categorize',-1,40),(318,'Composition',-1,40),(319,'Geospatial',-1,40),(320,'Order/rank/sort',-1,40),(321,'Trends',1,41),(322,'Distribution',-1,41),(323,'Relationship',1,41),(324,'Comparison',1,41),(325,'Cluster/Categorize',-1,41),(326,'Composition',1,41),(327,'Geospatial',-1,41),(328,'Order/rank/sort',-1,41),(329,'Trends',1,42),(330,'Distribution',-1,42),(331,'Relationship',1,42),(332,'Comparison',1,42),(333,'Cluster/Categorize',-1,42),(334,'Composition',1,42),(335,'Geospatial',-1,42),(336,'Order/rank/sort',-1,42),(337,'Trends',1,43),(338,'Distribution',-1,43),(339,'Relationship',1,43),(340,'Comparison',1,43),(341,'Cluster/Categorize',-1,43),(342,'Composition',-1,43),(343,'Geospatial',-1,43),(344,'Order/rank/sort',-1,43),(345,'Trends',0,44),(346,'Distribution',0,44),(347,'Relationship',1,44),(348,'Comparison',-1,44),(349,'Cluster/Categorize',-1,44),(350,'Composition',1,44),(351,'Geospatial',-1,44),(352,'Order/rank/sort',-1,44),(353,'Trends',1,45),(354,'Distribution',1,45),(355,'Relationship',1,45),(356,'Comparison',1,45),(357,'Cluster/Categorize',1,45),(358,'Composition',1,45),(359,'Geospatial',-1,45),(360,'Order/rank/sort',-1,45),(361,'Trends',1,46),(362,'Distribution',0,46),(363,'Relationship',-1,46),(364,'Comparison',1,46),(365,'Cluster/Categorize',-1,46),(366,'Composition',1,46),(367,'Geospatial',-1,46),(368,'Order/rank/sort',-1,46),(369,'Trends',-1,47),(370,'Distribution',-1,47),(371,'Relationship',-1,47),(372,'Comparison',1,47),(373,'Cluster/Categorize',-1,47),(374,'Composition',-1,47),(375,'Geospatial',-1,47),(376,'Order/rank/sort',1,47),(377,'Trends',0,48),(378,'Distribution',-1,48),(379,'Relationship',-1,48),(380,'Comparison',1,48),(381,'Cluster/Categorize',-1,48),(382,'Composition',1,48),(383,'Geospatial',-1,48),(384,'Order/rank/sort',-1,48),(385,'Trends',1,49),(386,'Distribution',-1,49),(387,'Relationship',1,49),(388,'Comparison',1,49),(389,'Cluster/Categorize',-1,49),(390,'Composition',-1,49),(391,'Geospatial',-1,49),(392,'Order/rank/sort',1,49),(393,'Trends',-1,50),(394,'Distribution',-1,50),(395,'Relationship',1,50),(396,'Comparison',1,50),(397,'Cluster/Categorize',-1,50),(398,'Composition',1,50),(399,'Geospatial',-1,50),(400,'Order/rank/sort',1,50),(401,'Trends',-1,51),(402,'Distribution',1,51),(403,'Relationship',1,51),(404,'Comparison',-1,51),(405,'Cluster/Categorize',-1,51),(406,'Composition',1,51),(407,'Geospatial',-1,51),(408,'Order/rank/sort',1,51),(409,'Trends',-1,52),(410,'Distribution',-1,52),(411,'Relationship',1,52),(412,'Comparison',-1,52),(413,'Cluster/Categorize',-1,52),(414,'Composition',1,52),(415,'Geospatial',-1,52),(416,'Order/rank/sort',1,52),(417,'Trends',-1,53),(418,'Distribution',-1,53),(419,'Relationship',-1,53),(420,'Comparison',-1,53),(421,'Cluster/Categorize',1,53),(422,'Composition',-1,53),(423,'Geospatial',-1,53),(424,'Order/rank/sort',-1,53),(425,'Trends',-1,54),(426,'Distribution',-1,54),(427,'Relationship',-1,54),(428,'Comparison',-1,54),(429,'Cluster/Categorize',1,54),(430,'Composition',-1,54),(431,'Geospatial',-1,54),(432,'Order/rank/sort',-1,54),(433,'Trends',-1,55),(434,'Distribution',0,55),(435,'Relationship',-1,55),(436,'Comparison',-1,55),(437,'Cluster/Categorize',-1,55),(438,'Composition',-1,55),(439,'Geospatial',-1,55),(440,'Order/rank/sort',-1,55),(441,'Trends',-1,56),(442,'Distribution',1,56),(443,'Relationship',-1,56),(444,'Comparison',-1,56),(445,'Cluster/Categorize',-1,56),(446,'Composition',-1,56),(447,'Geospatial',-1,56),(448,'Order/rank/sort',-1,56);
/*!40000 ALTER TABLE `goal` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `graphs`
--

DROP TABLE IF EXISTS `graphs`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `graphs` (
  `idgraphs` int(11) NOT NULL AUTO_INCREMENT,
  `category` varchar(45) DEFAULT NULL,
  `subcategory` varchar(45) NOT NULL,
  PRIMARY KEY (`idgraphs`)
) ENGINE=InnoDB AUTO_INCREMENT=57 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `graphs`
--

LOCK TABLES `graphs` WRITE;
/*!40000 ALTER TABLE `graphs` DISABLE KEYS */;
INSERT INTO `graphs` VALUES (1,'pie chart','pie chart'),(2,'pie chart','stacked pie chart'),(3,'line chart','single line chart'),(4,'line chart','stacked line chart'),(5,'line chart','marked line chart'),(6,'histogram','histogram'),(7,'gauge','gauge'),(8,'dendogram','dendogram'),(9,'network map','network map'),(10,'plot chart','box plot chart'),(11,'plot chart','scatter plot chart'),(12,'bubble chart','bubble chart'),(13,'parallel graph','parallel graph'),(14,'network map','map'),(15,'bar chart','horizontal bar chart'),(16,'bar chart','vertical bar chart'),(17,'histogram','line histogram'),(18,'map','tree map'),(19,'map','heat map'),(20,'map','cloropleth map'),(21,'map','zoomable map tiles'),(22,'map','map'),(23,'bar chart','bullet chart'),(24,'plot chart','box plot chart'),(25,'bar chart','stacked bar chart'),(26,'bar chart','grouped bar chart'),(27,'bar chart','stacked 100% bar chart'),(28,'bar chart','variable width bar chart'),(29,'bar chart','stacked 100% bar chart with subcomponents'),(30,'bar chart','scatter bar volume chart'),(31,'bar chart','scatter bar volume with total chart'),(32,'column chart','stacked column chart'),(33,'column chart','multiple column chart'),(34,'column chart','stacked 100% column chart'),(35,'column chart','variable width column chart'),(36,'column chart','stacked 100% column chart with subcomponents'),(37,'column chart','scatter column volume chart'),(38,'column chart','scatter column volume with total chart'),(39,'area chart','area chart'),(40,'area chart','3D area chart'),(41,'area chart','stacked area chart'),(42,'area chart','stacked 100% area chart'),(43,'area chart','circular area chart'),(44,'radar chart','radar chart'),(45,'parallel coordinate graph','parallel coordinate graph'),(46,'waterfall chart','waterfall chart'),(47,'table','table'),(48,'table','pivot table'),(49,'table','table with embedded chart'),(50,'table','alternative row table'),(51,'table','quartile table'),(52,'table','grouping table'),(53,'alert','alert'),(54,'gauge','gauge'),(55,'tag cloud','tag cloud 1'),(56,'tag cloud','tag cloud 2');
/*!40000 ALTER TABLE `graphs` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `interaction`
--

DROP TABLE IF EXISTS `interaction`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `interaction` (
  `idinteraction` int(11) NOT NULL AUTO_INCREMENT,
  `value` varchar(45) DEFAULT NULL,
  `score` float DEFAULT NULL,
  `graph` int(11) DEFAULT NULL,
  PRIMARY KEY (`idinteraction`),
  KEY `idgraph_int_idx` (`graph`),
  CONSTRAINT `idgraph_int` FOREIGN KEY (`graph`) REFERENCES `graphs` (`idgraphs`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=1862 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `interaction`
--

LOCK TABLES `interaction` WRITE;
/*!40000 ALTER TABLE `interaction` DISABLE KEYS */;
INSERT INTO `interaction` VALUES (1,'Overview',1,1),(2,'Link &amp; Brush',0,1),(3,'Projection',-1,1),(4,'Details-on-demand',0.5,1),(5,'Distortion',-1,1),(6,'Zoom',0,1),(7,'Filter',0.5,1),(8,'History',0,1),(9,'Extract',0,1),(10,'Overview',1,2),(11,'Link &amp; Brush',0,2),(12,'Projection',0.5,2),(13,'Details-on-demand',0.5,2),(14,'Distortion',-1,2),(15,'Zoom',0,2),(16,'Filter',0.5,2),(17,'History',0,2),(18,'Extract',0,2),(19,'Overview',0.5,3),(20,'Link &amp; Brush',0,3),(21,'Projection',-1,3),(22,'Details-on-demand',-0.5,3),(23,'Distortion',-1,3),(24,'Zoom',-0.5,3),(25,'Filter',0.5,3),(26,'History',0,3),(27,'Extract',0,3),(28,'Overview',0.5,4),(29,'Link &amp; Brush',0,4),(30,'Projection',-1,4),(31,'Details-on-demand',0.5,4),(32,'Distortion',-1,4),(33,'Zoom',-0.5,4),(34,'Filter',0.5,4),(35,'History',0,4),(36,'Extract',0,4),(37,'Overview',0,5),(38,'Link &amp; Brush',0,5),(39,'Projection',0,5),(40,'Details-on-demand',0,5),(41,'Distortion',0,5),(42,'Zoom',0,5),(43,'Filter',0,5),(44,'History',0,5),(45,'Extract',0,5),(46,'Overview',0.5,6),(47,'Link &amp; Brush',0,6),(48,'Projection',-1,6),(49,'Details-on-demand',0.5,6),(50,'Distortion',-1,6),(51,'Zoom',0.5,6),(52,'Filter',0.5,6),(53,'History',0,6),(54,'Extract',0,6),(55,'Overview',-1,7),(56,'Link &amp; Brush',0,7),(57,'Projection',-1,7),(58,'Details-on-demand',0.5,7),(59,'Distortion',-1,7),(60,'Zoom',-0.5,7),(61,'Filter',0.5,7),(62,'History',0,7),(63,'Extract',0,7),(64,'Overview',1,8),(65,'Link &amp; Brush',0,8),(66,'Projection',-1,8),(67,'Details-on-demand',0.5,8),(68,'Distortion',0.5,8),(69,'Zoom',1,8),(70,'FilterFilter',0.5,8),(71,'History',0,8),(72,'Extract',0,8),(73,'Overview',0.5,9),(74,'Link &amp; Brush',0,9),(75,'Projection',0.5,9),(76,'Details-on-demand',0.5,9),(77,'Distortion',0.5,9),(78,'Zoom',0.5,9),(79,'Filter',0.5,9),(80,'History',0,9),(81,'Extract',0,9),(82,'Overview',1,10),(83,'Link &amp; Brush',0,10),(84,'Projection',-1,10),(85,'Details-on-demand',0.5,10),(86,'Distortion',-1,10),(87,'Zoom',0.5,10),(88,'Filter',0.5,10),(89,'History',0,10),(90,'Extract',0,10),(91,'Overview',0.5,11),(92,'Link &amp; Brush',0,11),(93,'Projection',-1,11),(94,'Details-on-demand',0.5,11),(95,'Distortion',-1,11),(96,'Zoom',0.5,11),(97,'Filter',0.5,11),(98,'History',0,11),(99,'Extract',0,11),(100,'Overview',0.5,12),(101,'Link &amp; Brush',0,12),(102,'Projection',0.5,12),(103,'Details-on-demand',0.5,12),(104,'Distortion',-1,12),(105,'Zoom',0.5,12),(106,'Filter',0.5,12),(107,'History',0,12),(108,'Extract',0,12),(109,'Overview',0.5,13),(110,'Link &amp; Brush',1,13),(111,'Projection',-1,13),(112,'Details-on-demand',0.5,13),(113,'Distortion',-1,13),(114,'Zoom',0.5,13),(115,'Filter',0.5,13),(116,'History',0,13),(117,'Extract',0,13),(118,'Overview',0,14),(119,'Link &amp; Brush',1,14),(120,'Projection',0,14),(121,'Details-on-demand',0,14),(122,'Distortion',-1,14),(123,'Zoom',0,14),(124,'Filter',0,14),(125,'History',0,14),(126,'Extract',0,14),(127,'Overview',0.5,15),(128,'Link &amp; Brush',1,15),(129,'Projection',-1,15),(130,'Details-on-demand',0.5,15),(131,'Distortion',-1,15),(132,'Zoom',0.5,15),(133,'Filter',0.5,15),(134,'History',0,15),(135,'Extract',0,15),(136,'Overview',0.5,16),(137,'Link &amp; Brush',1,16),(138,'Projection',-1,16),(139,'Details-on-demand',0.5,16),(140,'Distortion',-1,16),(141,'Zoom',0.5,16),(142,'Filter',0.5,16),(143,'History',0,16),(144,'Extract',0,16),(145,'Overview',0.5,17),(146,'Link &amp; Brush',0,17),(147,'Projection',-1,17),(148,'Details-on-demand',0,17),(149,'Distortion',-1,17),(150,'Zoom',0.5,17),(151,'Filter',0,17),(152,'History',0,17),(153,'Extract',0,17),(154,'Overview',0.5,18),(155,'Link &amp; Brush',0,18),(156,'Projection',-1,18),(157,'Details-on-demand',0,18),(158,'Distortion',0.5,18),(159,'Zoom',0.5,18),(160,'Filter',0,18),(161,'History',0,18),(162,'Extract',0,18),(163,'Overview',1,19),(164,'Link &amp; Brush',1,19),(165,'Projection',-1,19),(167,'Details-on-demand',0.5,19),(168,'Distortion',0.5,19),(169,'Zoom',0,19),(170,'Filter',0,19),(171,'History',0,19),(172,'Overview',1,20),(173,'Link &amp; Brush',1,20),(174,'Projection',-1,20),(175,'Details-on-demand',0,20),(176,'Distortion',0.5,20),(177,'Zoom',0.5,20),(178,'Filter',0,20),(179,'History',0,20),(180,'Extract',0,20),(181,'Overview',0.5,21),(182,'Link &amp; Brush',1,21),(183,'Projection',-1,21),(184,'Details-on-demand',0,21),(185,'Distortion',-1,21),(186,'Zoom',1,21),(187,'Filter',0,21),(188,'History',0,21),(189,'Extract',0,21),(190,'Overview',0.5,22),(191,'Link &amp; Brush',1,22),(192,'Projection',-1,22),(193,'Details-on-demand',0,22),(194,'Distortion',-1,22),(195,'Zoom',0.5,22),(196,'Filter',0,22),(197,'History',0,22),(198,'Extract',0,22),(199,'Overview',0.5,23),(200,'Link &amp; Brush',0,23),(201,'Projection',0.5,23),(202,'Details-on-demand',0,23),(203,'Distortion',0.5,23),(204,'Zoom',0.5,23),(205,'Filter',0,23),(206,'History',0,23),(207,'Extract',0,23),(208,'Overview',1,24),(209,'Link &amp; Brush',0,24),(210,'Projection',-1,24),(211,'Details-on-demand',0,24),(212,'Distortion',-1,24),(213,'Zoom',0.5,24),(214,'Filter',0,24),(215,'History',0,24),(216,'Extract',0,24),(217,'Overview',0.5,25),(218,'Link &amp; Brush',0.5,25),(219,'Projection',0,25),(220,'Details-on-demand',0,25),(221,'Distortion',0.5,25),(222,'Zoom',0.5,25),(223,'Filter',0,25),(224,'History',0,25),(225,'Extract',0,25),(226,'Overview',0.5,26),(227,'Link &amp; Brush',0.5,26),(228,'Projection',-1,26),(229,'Details-on-demand',0,26),(230,'Distortion',0.5,26),(231,'Zoom',0.5,26),(232,'Filter',0,26),(233,'History',0,26),(234,'Extract',0,26),(235,'Overview',0.5,27),(236,'Link &amp; Brush',0.5,27),(237,'Projection',0,27),(238,'Details-on-demand',0,27),(239,'Distortion',0.5,27),(240,'Zoom',0.5,27),(241,'Filter',0,27),(242,'History',0,27),(243,'Extract',0,27),(244,'Overview',0.5,28),(245,'Link &amp; Brush',0.5,28),(246,'Projection',0.5,28),(247,'Details-on-demand',0,28),(248,'Distortion',0.5,28),(249,'Zoom',0.5,28),(250,'Filter',0,28),(251,'History',0,28),(252,'Extract',0,28),(253,'Overview',0.5,29),(254,'Link &amp; Brush',0.5,29),(255,'Projection',0.5,29),(256,'Details-on-demand',0,29),(257,'Distortion',0.5,29),(258,'Zoom',1,29),(259,'Filter',0,29),(260,'History',0,29),(261,'Extract',0,29),(262,'Overview',0,30),(263,'Link &amp; Brush',0,30),(264,'Projection',0,30),(265,'Details-on-demand',0,30),(266,'Distortion',0,30),(267,'Zoom',0,30),(268,'Filter',0,30),(269,'History',0,30),(270,'Extract',0,30),(271,'Overview',0,31),(272,'Link &amp; Brush',0,31),(273,'Projection',0,31),(274,'Details-on-demand',0,31),(275,'Distortion',0,31),(276,'Zoom',0,31),(277,'Filter',0,31),(278,'History',0,31),(279,'Extract',0,31),(280,'Overview',0.5,32),(281,'Link &amp; Brush',0.5,32),(282,'Projection',0,32),(283,'Details-on-demand',0,32),(284,'Distortion',0.5,32),(285,'Zoom',0.5,32),(286,'Filter',0,32),(287,'History',0,32),(288,'Extract',0,32),(289,'Overview',0.5,33),(290,'Link &amp; Brush',0.5,33),(291,'Projection',-1,33),(292,'Details-on-demand',0,33),(293,'Distortion',0.5,33),(294,'Zoom',0.5,33),(295,'Filter',0,33),(296,'History',0,33),(297,'Extract',0,33),(298,'Overview',0.5,34),(299,'Link &amp; Brush',0.5,34),(300,'Projection',0,34),(301,'Details-on-demand',0,34),(302,'Distortion',0.5,34),(303,'Zoom',0.5,34),(304,'Filter',0,34),(305,'History',0,34),(306,'Extract',0,34),(307,'Overview',0.5,35),(308,'Link &amp; Brush',0.5,35),(309,'Projection',0.5,35),(1666,'Extract',0,19),(1667,'Details-on-demand',0,35),(1668,'Distortion',0.5,35),(1669,'Zoom',0.5,35),(1670,'Filter',0,35),(1671,'History',0,35),(1672,'Extract',0,35),(1673,'Overview',0.5,36),(1674,'Link &amp; Brush',0.5,36),(1675,'Projection',0.5,36),(1676,'Details-on-demand',0,36),(1677,'Distortion',0.5,36),(1678,'Zoom',1,36),(1679,'Filter',0,36),(1680,'History',0,36),(1681,'Extract',0,36),(1682,'Overview',0,37),(1683,'Link &amp; Brush',0,37),(1684,'Projection',0,37),(1685,'Details-on-demand',0,37),(1686,'Distortion',0,37),(1687,'Zoom',0,37),(1688,'Filter',0,37),(1689,'History',0,37),(1690,'Extract',0,37),(1691,'Overview',0,38),(1692,'Link &amp; Brush',0,38),(1693,'Projection',0,38),(1694,'Details-on-demand',0,38),(1695,'Distortion',0,38),(1696,'Zoom',0,38),(1697,'Filter',0,38),(1698,'History',0,38),(1699,'Extract',0,38),(1700,'Overview',1,39),(1701,'Link &amp; Brush',0,39),(1702,'Projection',-1,39),(1703,'Details-on-demand',0,39),(1704,'Distortion',0.5,39),(1705,'Zoom',0.5,39),(1706,'Filter',0,39),(1707,'History',0,39),(1708,'Extract',0,39),(1709,'Overview',1,40),(1710,'Link &amp; Brush',0,40),(1711,'Projection',0.5,40),(1712,'Details-on-demand',0,40),(1713,'Distortion',0.5,40),(1714,'Zoom',0.5,40),(1715,'Filter',0,40),(1716,'History',0,40),(1717,'Extract',0,40),(1718,'Overview',1,41),(1719,'Link &amp; Brush',0,41),(1720,'Projection',0,41),(1721,'Details-on-demand',0,41),(1722,'Distortion',0.5,41),(1723,'Zoom',0.5,41),(1724,'Filter',0,41),(1725,'History',0,41),(1726,'Extract',0,41),(1727,'Overview',1,42),(1728,'Link &amp; Brush',0,42),(1729,'Projection',0,42),(1730,'Details-on-demand',0,42),(1731,'Distortion',0.5,42),(1732,'Zoom',1,42),(1733,'Filter',0,42),(1734,'History',0,42),(1735,'Extract',0,42),(1736,'Overview',0.5,43),(1737,'Link &amp; Brush',0,43),(1738,'Projection',0.5,43),(1739,'Details-on-demand',0,43),(1740,'Distortion',-1,43),(1741,'Zoom',0.5,43),(1742,'Filter',0,43),(1743,'History',0,43),(1744,'Extract',0,43),(1745,'Overview',0.5,44),(1746,'Link &amp; Brush',0,44),(1747,'Projection',1,44),(1748,'Details-on-demand',0,44),(1749,'Distortion',0.5,44),(1750,'Zoom',0,44),(1751,'Filter',0,44),(1752,'History',0,44),(1753,'Extract',0,44),(1754,'Overview',0.5,45),(1755,'Link &amp; Brush',1,45),(1756,'Projection',0.5,45),(1757,'Details-on-demand',0,45),(1758,'Distortion',0.5,45),(1759,'Zoom',0.5,45),(1760,'Filter',0,45),(1761,'History',0,45),(1762,'Extract',0,45),(1763,'Overview',0.5,46),(1764,'Link &amp; Brush',0,46),(1765,'Projection',-1,46),(1766,'Details-on-demand',0,46),(1767,'Distortion',0.5,46),(1768,'Zoom',0,46),(1769,'Filter',0,46),(1770,'History',0,46),(1771,'Extract',0,46),(1772,'Overview',-0.5,47),(1773,'Link &amp; Brush',0,47),(1774,'Projection',1,47),(1775,'Details-on-demand',0,47),(1776,'Distortion',-1,47),(1777,'Zoom',-1,47),(1778,'Filter',0,47),(1779,'History',0,47),(1780,'Extract',0,47),(1781,'Overview',0.5,48),(1782,'Link &amp; Brush',0,48),(1783,'Projection',1,48),(1784,'Details-on-demand',0,48),(1785,'Distortion',0.5,48),(1786,'Zoom',-1,48),(1787,'Filter',0,48),(1788,'History',0,48),(1789,'Extract',0,48),(1790,'Overview',0.5,49),(1791,'Link &amp; Brush',0,49),(1792,'Projection',1,49),(1793,'Details-on-demand',0,49),(1794,'Distortion',0.5,49),(1795,'Zoom',-1,49),(1796,'Filter',0,49),(1797,'History',0,49),(1798,'Extract',0,49),(1799,'Overview',-0.5,50),(1800,'Link &amp; Brush',0,50),(1801,'Projection',1,50),(1802,'Details-on-demand',0,50),(1803,'Distortion',-1,50),(1804,'Zoom',-1,50),(1805,'Filter',0,50),(1806,'History',0,50),(1807,'Extract',0,50),(1808,'Overview',-0.5,51),(1809,'Link &amp; Brush',0,51),(1810,'Projection',0.5,51),(1811,'Details-on-demand',0,51),(1812,'Distortion',-1,51),(1813,'Zoom',-1,51),(1814,'Filter',0,51),(1815,'History',0,51),(1816,'Extract',0,51),(1817,'Overview',-0.5,52),(1818,'Link &amp; Brush',0,52),(1819,'Projection',1,52),(1820,'Details-on-demand',0,52),(1821,'Distortion',-1,52),(1822,'Zoom',-1,52),(1823,'Filter',0,52),(1824,'History',0,52),(1825,'Extract',0,52),(1826,'Overview',0.5,53),(1827,'Link &amp; Brush',0,53),(1828,'Projection',-1,53),(1829,'Details-on-demand',0,53),(1830,'Distortion',-1,53),(1831,'Zoom',-0.5,53),(1832,'Filter',0,53),(1833,'History',0,53),(1834,'Extract',0,53),(1835,'Overview',-1,54),(1836,'Link &amp; Brush',0,54),(1837,'Projection',-1,54),(1838,'Details-on-demand',0,54),(1839,'Distortion',-1,54),(1840,'Zoom',-0.5,54),(1841,'Filter',0,54),(1842,'History',0,54),(1843,'Extract',0,54),(1844,'Overview',1,55),(1845,'Link &amp; Brush',0,55),(1846,'Projection',-1,55),(1847,'Details-on-demand',0,55),(1848,'Distortion',0.5,55),(1849,'Zoom',-0.5,55),(1850,'Filter',0,55),(1851,'History',0,55),(1852,'Extract',0,55),(1853,'Overview',1,56),(1854,'Link &amp; Brush',0,56),(1855,'Projection',0.5,56),(1856,'Details-on-demand',0,56),(1857,'Distortion',0.5,56),(1858,'Zoom',-0.5,56),(1859,'Filter',0,56),(1860,'History',0,56),(1861,'Extract',0,56);
/*!40000 ALTER TABLE `interaction` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user`
--

DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user` (
  `iduser` int(11) NOT NULL,
  `value` varchar(45) DEFAULT NULL,
  `score` int(11) DEFAULT NULL,
  `graph` int(11) DEFAULT NULL,
  PRIMARY KEY (`iduser`),
  KEY `idgraph_user_idx` (`graph`),
  CONSTRAINT `idgraph_user` FOREIGN KEY (`graph`) REFERENCES `graphs` (`idgraphs`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user`
--

LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (1,'Lay-user',1,1),(2,'Techie',1,1),(3,'Lay-user',-1,2),(4,'Techie',1,2),(5,'Lay-user',1,3),(6,'Techie',1,3),(7,'Lay-user',1,4),(8,'Techie',1,4),(9,'Lay-user',0,5),(10,'Techie',0,5),(11,'Lay-user',1,6),(12,'Techie',1,6),(13,'Lay-user',1,7),(14,'Techie',0,7),(15,'Lay-user',1,8),(16,'Techie',1,8),(17,'Lay-user',1,9),(18,'Techie',1,9),(19,'Lay-user',-1,10),(20,'Techie',1,10),(21,'Lay-user',0,11),(22,'Techie',1,11),(23,'Lay-user',1,12),(24,'Techie',1,12),(25,'Lay-user',-1,13),(26,'Techie',1,13),(27,'Lay-user',1,14),(28,'Techie',0,14),(29,'Lay-user',1,15),(30,'Techie',0,15),(31,'Lay-user',1,16),(32,'Techie',0,16),(33,'Lay-user',1,17),(34,'Techie',1,17),(35,'Lay-user',-1,18),(36,'Techie',1,18),(37,'Lay-user',1,19),(38,'Techie',1,19),(39,'Lay-user',1,20),(40,'Techie',1,20),(41,'Lay-user',1,21),(42,'Techie',0,21),(43,'Lay-user',1,22),(44,'Techie',0,22),(45,'Lay-user',-1,23),(46,'Techie',1,23),(47,'Lay-user',-1,24),(48,'Techie',1,24),(49,'Lay-user',1,25),(50,'Techie',1,25),(51,'Lay-user',1,26),(52,'Techie',1,26),(53,'Lay-user',1,27),(54,'Techie',1,27),(55,'Lay-user',1,28),(56,'Techie',0,28),(57,'Lay-user',1,29),(58,'Techie',1,29),(59,'Lay-user',0,30),(60,'Techie',0,30),(61,'Lay-user',0,31),(62,'Techie',0,31),(63,'Lay-user',1,32),(64,'Techie',1,32),(65,'Lay-user',1,33),(66,'Techie',1,33),(67,'Lay-user',1,34),(68,'Techie',1,34),(69,'Lay-user',1,35),(70,'Techie',0,35),(71,'Lay-user',1,36),(72,'Techie',1,36),(73,'Lay-user',0,37),(74,'Techie',0,37),(75,'Lay-user',0,38),(76,'Techie',0,38),(77,'Lay-user',1,39),(78,'Techie',1,39),(79,'Lay-user',0,40),(80,'Techie',1,40),(81,'Lay-user',1,41),(82,'Techie',1,41),(83,'Lay-user',1,42),(84,'Techie',1,42),(85,'Lay-user',-1,43),(86,'Techie',1,43),(87,'Lay-user',0,44),(88,'Techie',1,44),(89,'Lay-user',-1,45),(90,'Techie',1,45),(91,'Lay-user',-1,46),(92,'Techie',1,46),(93,'Lay-user',1,47),(94,'Techie',0,47),(95,'Lay-user',1,48),(96,'Techie',1,48),(97,'Lay-user',1,49),(98,'Techie',1,49),(99,'Lay-user',1,50),(100,'Techie',0,50),(101,'Lay-user',-1,51),(102,'Techie',1,51),(103,'Lay-user',-1,52),(104,'Techie',1,52),(105,'Lay-user',1,53),(106,'Techie',0,53),(107,'Lay-user',1,54),(108,'Techie',0,54),(109,'Lay-user',1,55),(110,'Techie',0,55),(111,'Lay-user',1,56),(112,'Techie',0,56);
/*!40000 ALTER TABLE `user` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!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 */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2016-12-20 17:15:48
