 
 LOCK TABLES `pstate` WRITE;
 /*!40000 ALTER TABLE `pstate` DISABLE KEYS */;
-INSERT INTO `pstate` VALUES (5,1,800,1),(24,1,1000,1),(73,4,600,1),(74,4,800,1),(75,4,1000,1),(76,4,1200,1),(77,4,1400,1),(78,4,1600,1),(143,3,208,1),(144,3,416,1),(145,3,625,1),(146,3,833,1),(147,3,1041,1),(148,3,1250,1),(149,3,1458,1),(150,3,1666,1),(160,2,1000,1),(161,2,800,1),(387,8,800,1),(388,8,900,1),(389,8,1000,1),(390,8,1100,1),(391,8,1200,1),(392,8,1300,1),(393,8,1400,1),(394,8,1500,1),(395,8,1600,1),(396,8,1700,1),(397,8,1800,1),(398,8,1900,1),(399,8,2000,1),(400,8,2100,1),(401,8,2101,1),(584,9,1200,1),(585,9,1300,1),(586,9,1400,1),(587,9,1500,1),(588,9,1600,1),(589,9,1700,1),(590,9,1800,1),(591,9,1900,1),(592,9,2000,1),(593,9,2100,1),(594,9,2200,1),(595,9,2300,1),(596,9,2301,1);
+INSERT INTO `pstate` VALUES (5,1,800.000000000,1.000000000),(24,1,1000.000000000,1.000000000),(73,4,600.000000000,1.000000000),(74,4,800.000000000,1.000000000),(75,4,1000.000000000,1.000000000),(76,4,1200.000000000,1.000000000),(77,4,1400.000000000,1.000000000),(78,4,1600.000000000,1.000000000),(143,3,208.000000000,1.000000000),(144,3,416.000000000,1.000000000),(145,3,625.000000000,1.000000000),(146,3,833.000000000,1.000000000),(147,3,1041.000000000,1.000000000),(148,3,1250.000000000,1.000000000),(149,3,1458.000000000,1.000000000),(150,3,1666.000000000,1.000000000),(160,2,1000.000000000,1.000000000),(161,2,800.000000000,1.000000000),(387,8,800.000000000,1.000000000),(388,8,900.000000000,1.000000000),(389,8,1000.000000000,1.000000000),(390,8,1100.000000000,1.000000000),(391,8,1200.000000000,1.000000000),(392,8,1300.000000000,1.000000000),(393,8,1400.000000000,1.000000000),(394,8,1500.000000000,1.000000000),(395,8,1600.000000000,1.000000000),(396,8,1700.000000000,1.000000000),(397,8,1800.000000000,1.000000000),(398,8,1900.000000000,1.000000000),(399,8,2000.000000000,1.000000000),(400,8,2100.000000000,1.000000000),(401,8,2101.000000000,1.000000000),(584,9,1200.000000000,1.000000000),(585,9,1300.000000000,1.000000000),(586,9,1400.000000000,1.000000000),(587,9,1500.000000000,1.000000000),(588,9,1600.000000000,1.000000000),(589,9,1700.000000000,1.000000000),(590,9,1800.000000000,1.000000000),(591,9,1900.000000000,1.000000000),(592,9,2000.000000000,1.000000000),(593,9,2100.000000000,1.000000000),(594,9,2200.000000000,1.000000000),(595,9,2300.000000000,1.000000000),(596,9,2301.000000000,1.000000000);
 /*!40000 ALTER TABLE `pstate` ENABLE KEYS */;
 UNLOCK TABLES;
 

/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `flow_state` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `flow` decimal(10,0) DEFAULT NULL,
  `power_usage` decimal(10,0) DEFAULT NULL,
  `description` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `flowProfile_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),

CREATE TABLE `pstate` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `processor_id` int(11) DEFAULT NULL,
  `frequency` decimal(18,9) NOT NULL,
  `voltage` decimal(18,9) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `IDX_DF51898437BAC19A` (`processor_id`),
  CONSTRAINT `FK_DF51898437BAC19A` FOREIGN KEY (`processor_id`) REFERENCES `processor` (`id`)
