 
 LOCK TABLES `room` WRITE;
 /*!40000 ALTER TABLE `room` DISABLE KEYS */;
-INSERT INTO `room` VALUES (1,NULL,NULL,NULL,NULL,'PSNC - Little Server Room',NULL,NULL,NULL,200,2.5,300,0,0,0,0,0,0,'PSNC','Little Server Room',NULL,'100 50 10','0.003 0.003 0.003','room',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,NULL,NULL,NULL,NULL,'for D3.5 - ComputeBox2 Blueprint',NULL,NULL,NULL,240,2.385,570,0,0,0,0,0,0,'for D3.5','ComputeBox2 Blueprint',NULL,'100 50 10','0.003 0.003 0.003',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,NULL,NULL,NULL,NULL,'TEST',NULL,NULL,NULL,319.76666,2.2,299.76666,0,0,0,0,0,0,NULL,'TEST',NULL,'100 50 10','0.003 0.003 0.003',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,NULL,NULL,NULL,NULL,'ComputeBox2 - Christmann',NULL,NULL,NULL,240,2.385,1210,0,0,0,0,0,0,'ComputeBox2','Christmann',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,NULL,NULL,NULL,NULL,'test',NULL,NULL,NULL,0,0,0,0,0,0,0,0,0,NULL,'test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,NULL,NULL,NULL,NULL,'test_D2.5',NULL,NULL,NULL,300,0,300,0,0,0,0,0,0,NULL,'test_D2.5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,NULL,NULL,NULL,NULL,'Room - PCSS',NULL,NULL,NULL,800,0,1200,0,0,0,0,0,0,'Room','PCSS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,NULL,NULL,NULL,NULL,'WojteksServerRoom',NULL,NULL,NULL,0,0,0,0,0,0,0,0,0,NULL,'WojteksServerRoom',NULL,NULL,NULL,'room',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,NULL,NULL,NULL,NULL,'for D3.5 - ComputeBox1 Blueprint',NULL,NULL,NULL,200,200,200,0,0,0,0,0,0,'for D3.5','ComputeBox1 Blueprint',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,NULL,NULL,NULL,NULL,'PSNC - Wojtek 10 Racks Room',NULL,NULL,NULL,0,0,0,0,0,0,0,0,0,'PSNC','Wojtek 10 Racks Room',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
+INSERT INTO `room` VALUES (1,NULL,NULL,NULL,NULL,'PSNC - Little Server Room',NULL,NULL,NULL,200,2.5,300,0,0,0,0,0,0,'PSNC','Little Server Room',NULL,'100 50 10','0.003 0.003 0.003','room',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,NULL,NULL,NULL,NULL,'for D3.5 - ComputeBox2 Blueprint',NULL,NULL,NULL,240,2.385,570,0,0,0,0,0,0,'for D3.5','ComputeBox2 Blueprint',NULL,'100 50 10','0.003 0.003 0.003',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,NULL,NULL,NULL,NULL,'TEST',NULL,NULL,NULL,319.76666,2.2,299.76666,0,0,0,0,0,0,NULL,'TEST',NULL,'100 50 10','0.003 0.003 0.003',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,NULL,NULL,NULL,NULL,'ComputeBox2 - Christmann',NULL,NULL,NULL,240,2.385,1210,0,0,0,0,0,0,'ComputeBox2','Christmann',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(5,NULL,NULL,NULL,NULL,'test',NULL,NULL,NULL,0,0,0,0,0,0,0,0,0,NULL,'test',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(6,NULL,NULL,NULL,NULL,'test_D2.5',NULL,NULL,NULL,300,0,300,0,0,0,0,0,0,NULL,'test_D2.5',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(7,NULL,NULL,NULL,NULL,'Room - PCSS',NULL,NULL,NULL,800,0,1200,0,0,0,0,0,0,'Room','PCSS',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(8,NULL,NULL,NULL,NULL,'WojteksServerRoom',NULL,NULL,NULL,0,0,0,0,0,0,0,0,0,NULL,'WojteksServerRoom',NULL,NULL,NULL,'room',NULL,NULL,NULL,NULL,NULL,NULL,NULL),(9,NULL,NULL,NULL,NULL,'for D3.5 - ComputeBox1 Blueprint',NULL,NULL,NULL,200,200,200,0,0,0,0,0,0,'for D3.5','ComputeBox1 Blueprint',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(10,NULL,NULL,NULL,NULL,'PSNC - Wojtek 10 Racks Room',NULL,NULL,NULL,0,0,0,0,0,0,0,0,0,'PSNC','Wojtek 10 Racks Room',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(11,NULL,NULL,NULL,NULL,'Infrastructure Container',NULL,NULL,NULL,240,2.385,1210,0,0,0,0,0,0,NULL,'Infrastructure Container',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);
 /*!40000 ALTER TABLE `room` ENABLE KEYS */;
 UNLOCK TABLES;
 


LOCK TABLES `racktoroom` WRITE;
/*!40000 ALTER TABLE `racktoroom` DISABLE KEYS */;
INSERT INTO `racktoroom` VALUES (4,1,1,NULL,70,130,0,0,NULL,NULL,NULL),(10,2,2,NULL,0,30,0,270,NULL,NULL,NULL),(11,2,2,NULL,0,130,0,270,NULL,NULL,NULL),(12,2,2,NULL,0,330,0,270,NULL,NULL,NULL),(13,2,2,NULL,0,230,0,270,NULL,NULL,NULL),(19,3,2,NULL,0,110,0,270,NULL,NULL,NULL),(21,3,2,NULL,0,210,0,270,NULL,NULL,NULL),(23,3,2,NULL,0,310,0,270,NULL,NULL,NULL),(24,3,2,NULL,0,410,0,270,NULL,NULL,NULL),(25,2,2,NULL,0,430,0,270,NULL,NULL,NULL),(26,3,2,NULL,0,510,0,270,NULL,NULL,NULL),(27,3,3,NULL,80,130,0,0,NULL,NULL,NULL),(28,2,3,NULL,100,130,0,0,NULL,NULL,NULL),(30,9,4,NULL,0,1110,0,90,0.006000000,12.142000000,NULL),(31,11,4,NULL,70,1140,0,90,0.608000000,11.987000000,NULL),(32,10,4,NULL,190,1060,0,90,1.846000000,12.142000000,NULL),(33,8,4,NULL,0,50,0,270,1.200000000,0.450000000,0.013000000),(34,12,4,NULL,0,130,0,270,1.200000000,1.250000000,0.013000000),(35,8,4,NULL,0,150,0,270,1.200000000,1.450000000,0.013000000),(36,12,4,NULL,0,230,0,270,1.200000000,2.250000000,0.013000000),(37,8,4,NULL,0,250,0,270,1.200000000,2.450000000,0.013000000),(38,12,4,NULL,0,330,0,270,1.200000000,3.250000000,0.013000000),(39,8,4,NULL,0,350,0,270,1.200000000,3.450000000,0.013000000),(41,8,4,NULL,0,450,0,270,1.200000000,4.450000000,0.013000000),(42,12,4,NULL,0,430,0,270,1.200000000,4.250000000,0.013000000),(43,8,4,NULL,0,550,0,270,1.200000000,5.450000000,0.013000000),(44,12,4,NULL,0,530,0,270,1.200000000,5.250000000,0.013000000),(46,12,4,NULL,0,630,0,270,1.200000000,6.250000000,0.013000000),(47,8,4,NULL,0,750,0,270,1.200000000,7.450000000,0.013000000),(49,8,4,NULL,0,850,0,270,1.200000000,8.450000000,0.013000000),(51,8,4,NULL,0,950,0,270,1.200000000,9.450000000,0.013000000),(52,12,4,NULL,0,830,0,270,1.200000000,8.250000000,0.013000000),(53,12,4,NULL,0,930,0,270,1.200000000,9.250000000,0.013000000),(55,12,4,NULL,0,1030,0,270,1.200000000,10.250000000,0.013000000),(56,8,5,NULL,170,310,0,0,NULL,NULL,NULL),(57,12,5,NULL,150,310,0,0,NULL,NULL,NULL),(58,8,5,NULL,150,430,0,90,NULL,NULL,NULL),(59,12,5,NULL,150,510,0,90,NULL,NULL,NULL),(60,8,5,NULL,270,450,0,270,NULL,NULL,NULL),(61,12,5,NULL,270,430,0,270,NULL,NULL,NULL),(62,8,5,NULL,250,310,0,180,NULL,NULL,NULL),(63,12,5,NULL,330,310,0,180,NULL,NULL,NULL),(67,14,6,NULL,150,150,0,NULL,NULL,NULL,NULL),(70,13,7,NULL,220,1010,0,NULL,NULL,NULL,NULL),(71,13,7,NULL,420,1010,0,NULL,NULL,NULL,NULL),(72,13,7,NULL,320,1010,0,NULL,NULL,NULL,NULL),(73,13,7,NULL,520,1010,0,NULL,NULL,NULL,NULL),(74,13,7,NULL,520,910,0,NULL,NULL,NULL,NULL),(75,13,7,NULL,420,910,0,NULL,NULL,NULL,NULL),(76,13,7,NULL,320,910,0,NULL,NULL,NULL,NULL),(77,13,7,NULL,220,910,0,NULL,NULL,NULL,NULL),(78,13,7,NULL,320,810,0,NULL,NULL,NULL,NULL),(79,13,7,NULL,420,810,0,NULL,NULL,NULL,NULL),(80,13,7,NULL,520,810,0,NULL,NULL,NULL,NULL),(81,13,7,NULL,220,810,0,NULL,NULL,NULL,NULL),(82,13,7,NULL,320,710,0,NULL,NULL,NULL,NULL),(83,13,7,NULL,420,710,0,NULL,NULL,NULL,NULL),(84,13,7,NULL,520,710,0,NULL,NULL,NULL,NULL),(85,13,7,NULL,220,710,0,NULL,NULL,NULL,NULL),(86,13,7,NULL,320,610,0,NULL,NULL,NULL,NULL),(87,13,7,NULL,420,610,0,NULL,NULL,NULL,NULL),(88,13,7,NULL,520,610,0,NULL,NULL,NULL,NULL),(89,13,7,NULL,220,610,0,NULL,NULL,NULL,NULL),(90,13,7,NULL,520,110,0,NULL,NULL,NULL,NULL),(91,13,7,NULL,320,510,0,NULL,NULL,NULL,NULL),(92,13,7,NULL,420,510,0,NULL,NULL,NULL,NULL),(93,13,7,NULL,520,510,0,NULL,NULL,NULL,NULL),(94,13,7,NULL,220,410,0,NULL,NULL,NULL,NULL),(95,13,7,NULL,320,410,0,NULL,NULL,NULL,NULL),(96,13,7,NULL,420,410,0,NULL,NULL,NULL,NULL),(97,13,7,NULL,520,410,0,NULL,NULL,NULL,NULL),(98,13,7,NULL,220,310,0,NULL,NULL,NULL,NULL),(99,13,7,NULL,320,310,0,NULL,NULL,NULL,NULL),(100,13,7,NULL,420,310,0,NULL,NULL,NULL,NULL),(101,13,7,NULL,520,310,0,NULL,NULL,NULL,NULL),(102,13,7,NULL,220,210,0,NULL,NULL,NULL,NULL),(103,13,7,NULL,320,210,0,NULL,NULL,NULL,NULL),(104,13,7,NULL,420,210,0,NULL,NULL,NULL,NULL),(105,13,7,NULL,520,210,0,NULL,NULL,NULL,NULL),(106,13,7,NULL,220,110,0,NULL,NULL,NULL,NULL),(107,13,7,NULL,320,110,0,NULL,NULL,NULL,NULL),(108,13,7,NULL,420,110,0,NULL,NULL,NULL,NULL),(109,13,7,NULL,220,510,0,NULL,NULL,NULL,NULL),(130,15,8,NULL,300,560,0,NULL,NULL,NULL,NULL),(131,15,8,NULL,400,560,0,NULL,NULL,NULL,NULL),(134,16,10,NULL,450,410,0,NULL,NULL,NULL,NULL),(135,16,10,NULL,350,410,0,NULL,NULL,NULL,NULL),(136,16,10,NULL,250,410,0,NULL,NULL,NULL,NULL),(137,16,10,NULL,650,410,0,NULL,NULL,NULL,NULL),(138,16,10,NULL,550,410,0,NULL,NULL,NULL,NULL),(139,17,10,NULL,650,260,0,NULL,NULL,NULL,NULL),(140,17,10,NULL,550,260,0,NULL,NULL,NULL,NULL),(141,17,10,NULL,450,260,0,NULL,NULL,NULL,NULL),(142,17,10,NULL,350,260,0,NULL,NULL,NULL,NULL),(143,17,10,NULL,250,260,0,NULL,NULL,NULL,NULL),(144,18,9,NULL,50,40,0,0,NULL,NULL,NULL),(145,19,9,NULL,130,40,0,NULL,NULL,NULL,NULL),(146,18,4,NULL,0,650,0,270,1.200000000,6.450000000,0.013000000),(147,19,4,NULL,0,730,0,270,1.200000000,7.250000000,0.013000000);
/*!40000 ALTER TABLE `racktoroom` ENABLE KEYS */;
UNLOCK TABLES;


  KEY `IDX_4B7FFF358E86A33E` (`rack_id`),
  CONSTRAINT `FK_4B7FFF352C147D48` FOREIGN KEY (`nodegroup_id`) REFERENCES `nodegroup` (`id`) ON DELETE CASCADE,
  CONSTRAINT `FK_4B7FFF358E86A33E` FOREIGN KEY (`rack_id`) REFERENCES `rack` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=512 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
