 
 LOCK TABLES `flow_state` WRITE;
 /*!40000 ALTER TABLE `flow_state` DISABLE KEYS */;
-INSERT INTO `flow_state` VALUES (2,0,0,'off',2),(3,40,7,'on 100%',2),(8,0,0,NULL,5),(9,10,20,NULL,5),(10,20,40,NULL,5),(11,0,0,NULL,6),(12,10,10,NULL,6),(13,20,20,NULL,6),(14,0,0,NULL,7),(15,1,100,NULL,7),(16,2,200,NULL,7);
+INSERT INTO `flow_state` VALUES (2,0.000000000,0.000000000,'off',2),(3,0.004670000,6.600000000,'on 100%',2),(8,0.000000000,0.000000000,NULL,5),(9,10.000000000,20.000000000,NULL,5),(10,20.000000000,40.000000000,NULL,5),(11,0.000000000,0.000000000,NULL,6),(12,10.000000000,10.000000000,NULL,6),(13,20.000000000,20.000000000,NULL,6),(14,0.000000000,0.000000000,NULL,7),(15,1.000000000,100.000000000,NULL,7),(16,2.000000000,200.000000000,NULL,7);
 /*!40000 ALTER TABLE `flow_state` ENABLE KEYS */;
 UNLOCK TABLES;
 


LOCK TABLES `coolingdevice` WRITE;
/*!40000 ALTER TABLE `coolingdevice` DISABLE KEYS */;
INSERT INTO `coolingdevice` VALUES (20,'Refrigeration',1013000,NULL,NULL,NULL,NULL,900000),(23,'Refrigeration',5000,NULL,NULL,NULL,NULL,5000);
/*!40000 ALTER TABLE `coolingdevice` ENABLE KEYS */;
UNLOCK TABLES;


CREATE TABLE `cstate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `processor_id` int(11) DEFAULT NULL,
  `power_usage` decimal(18,9) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_5A13F9B137BAC19A` (`processor_id`),
  CONSTRAINT `FK_5A13F9B137BAC19A` FOREIGN KEY (`processor_id`) REFERENCES `processor` (`id`)
