   `riskvalue` double NOT NULL,
   `description` longtext NOT NULL,
   PRIMARY KEY (`risk_policy_id`)
-) ENGINE=InnoDB AUTO_INCREMENT=144 DEFAULT CHARSET=latin1;
-/*!40101 SET character_set_client = @saved_cs_client */;
+) ENGINE=InnoDB AUTO_INCREMENT=113 DEFAULT CHARSET=latin1;
+/*!40101 SET character_set_client = @saved_cs_client */;
+
+--
+-- Dumping data for table `risk_policy`
+--
+
+LOCK TABLES `risk_policy` WRITE;
+/*!40000 ALTER TABLE `risk_policy` DISABLE KEYS */;
+INSERT INTO `risk_policy` VALUES (1,0,'myrsikpolicy'),(2,0,'myrsikpolicy'),(3,0,'myrsikpolicy'),(4,0,'myrsikpolicy'),(5,0,'myrsikpolicy'),(6,0,'myrsikpolicy'),(7,0,'myrsikpolicy'),(8,0,'myrsikpolicy'),(9,0,'myrsikpolicy'),(10,0,'myrsikpolicy'),(11,0,'myrsikpolicy'),(12,0,'myrsikpolicy'),(13,0,'myrsikpolicy'),(14,0,'myrsikpolicy'),(15,0,'myrsikpolicy'),(16,0,'myrsikpolicy'),(17,0,'myrsikpolicy'),(18,0,'myrsikpolicy'),(19,0,'myrsikpolicy'),(20,0,'myrsikpolicy'),(21,0,'myrsikpolicy'),(22,0,'myrsikpolicy'),(23,0,'myrsikpolicy'),(24,0,'myrsikpolicy'),(25,0,'myrsikpolicy'),(26,0,'myrsikpolicy'),(27,0,'myrsikpolicy'),(28,0,'myrsikpolicy'),(29,0,'myrsikpolicy'),(30,0,'myrsikpolicy'),(31,0,'myrsikpolicy'),(32,0,'myrsikpolicy'),(33,0,'myrsikpolicy'),(34,0,'myrsikpolicy'),(35,0,'myrsikpolicy'),(36,0,'myrsikpolicy'),(37,0,'myrsikpolicy'),(38,0,'myrsikpolicy'),(39,0,'myrsikpolicy'),(40,0,'myrsikpolicy'),(41,0,'myrsikpolicy'),(42,0,'myrsikpolicy'),(43,0,'myrsikpolicy'),(44,0,'myrsikpolicy'),(45,0,'myrsikpolicy'),(46,0,'myrsikpolicy'),(47,0,'myrsikpolicy'),(48,0,'myrsikpolicy'),(49,0,'myrsikpolicy'),(50,0,'myrsikpolicy'),(51,0,'myrsikpolicy'),(52,0,'myrsikpolicy'),(53,0,'myrsikpolicy'),(54,0,'myrsikpolicy'),(55,0,'myrsikpolicy'),(56,0,'myrsikpolicy'),(57,0,'myrsikpolicy'),(58,0,'myrsikpolicy'),(59,0,'myrsikpolicy'),(60,0,'myrsikpolicy'),(61,0,'myrsikpolicy'),(62,0,'myrsikpolicy'),(63,0,'myrsikpolicy'),(64,0,'myrsikpolicy'),(65,0,'myrsikpolicy'),(66,0,'myrsikpolicy'),(67,0,'myrsikpolicy'),(68,0,'myrsikpolicy'),(69,0,'myrsikpolicy'),(70,0,'myrsikpolicy'),(71,0,'myrsikpolicy'),(72,0,'myrsikpolicy'),(73,0,'myrsikpolicy'),(74,0,'myrsikpolicy'),(75,0,'myrsikpolicy'),(76,0,'myrsikpolicy'),(77,0,'myrsikpolicy'),(78,0,'myrsikpolicy'),(79,0,'myrsikpolicy'),(80,0,'myrsikpolicy'),(81,0,'myrsikpolicy'),(82,0,'myrsikpolicy'),(83,0,'myrsikpolicy'),(84,0,'myrsikpolicy'),(85,0,'myrsikpolicy'),(86,0,'myrsikpolicy'),(87,0,'myrsikpolicy'),(88,0,'myrsikpolicy'),(89,0,'myrsikpolicy'),(90,0,'myrsikpolicy'),(91,0,'myrsikpolicy'),(92,0,'myrsikpolicy'),(93,0,'myrsikpolicy'),(94,0,'myrsikpolicy'),(95,0,'myrsikpolicy'),(96,0,'myrsikpolicy'),(97,0,'myrsikpolicy'),(98,0,'myrsikpolicy'),(99,0,'myrsikpolicy'),(100,0,'myrsikpolicy'),(101,0,'myrsikpolicy'),(102,0,'myrsikpolicy'),(103,0,'myrsikpolicy'),(104,0,'myrsikpolicy'),(105,0,'myrsikpolicy'),(106,0,'myrsikpolicy'),(107,0,'myrsikpolicy'),(108,0,'myrsikpolicy'),(109,0,'myrsikpolicy'),(110,0,'myrsikpolicy'),(111,0,'myrsikpolicy'),(112,0,'myrsikpolicy');
+/*!40000 ALTER TABLE `risk_policy` ENABLE KEYS */;
+UNLOCK TABLES;
 
 --
 -- Table structure for table `risk_treatment`

/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Table structure for table `threat`
--


  KEY `decision-risk_communication:risk_communication_id_idx` (`risk_communication_id`),
  CONSTRAINT `decision-access_request:access_request_id` FOREIGN KEY (`access_request_id`) REFERENCES `access_request` (`access_request_id`) ON DELETE NO ACTION ON UPDATE CASCADE,
  CONSTRAINT `decision-risk_communication:risk_communication_id` FOREIGN KEY (`risk_communication_id`) REFERENCES `risk_communication` (`risk_communication_id`) ON DELETE NO ACTION ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=569 DEFAULT CHARSET=utf8 COMMENT='Table which stores all decision computed by the RT2AE. All fields are defined in the table.';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `decision`
--

LOCK TABLES `decision` WRITE;
/*!40000 ALTER TABLE `decision` DISABLE KEYS */;
INSERT INTO `decision` VALUES (545,80,900,'GRANTED','',0,'2014-08-10 00:00:00'),(546,80,900,'GRANTED','',0,'2014-08-11 00:00:00'),(548,80,900,'GRANTED','',0,'2014-08-12 00:00:00'),(549,80,900,'GRANTED','',0,'2014-08-12 00:00:00'),(550,80,900,'GRANTED','',0,'2014-08-12 00:00:00'),(551,80,900,'GRANTED','',0,'2014-08-12 00:00:00'),(552,80,900,'GRANTED','',0,'2014-08-12 00:00:00'),(553,80,900,'GRANTED','',0,'2014-08-12 00:00:00'),(554,80,900,'GRANTED','',0,'2014-08-12 00:00:00'),(555,80,900,'GRANTED','',0,'2014-08-12 00:00:00'),(556,80,900,'GRANTED','',0,'2014-08-12 00:00:00'),(557,80,900,'GRANTED','',0,'2014-08-12 00:00:00'),(558,80,900,'STRONGDENY','',0,'2015-01-23 16:03:24'),(559,80,900,'GRANTED','test',2,'2015-01-23 17:12:28'),(560,80,900,'GRANTED','test',2,'2015-01-23 17:13:03'),(561,80,900,'GRANTED',NULL,0,'2015-01-23 17:18:55'),(562,80,904,'GRANTED',NULL,0,'2015-01-23 17:23:23'),(563,80,905,'GRANTED',NULL,0,'2015-01-23 17:25:13'),(564,80,906,'GRANTED',NULL,0,'2015-01-23 17:27:11'),(565,80,907,'GRANTED',NULL,0,'2015-01-23 17:29:57'),(566,80,908,'GRANTED',NULL,0,'2015-01-23 17:31:53'),(567,80,909,'GRANTED',NULL,0,'2015-01-23 17:34:21'),(568,80,910,'GRANTED',NULL,0,'2015-01-23 18:15:37');
/*!40000 ALTER TABLE `decision` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `device_config`
