 /*!40101 SET character_set_client = utf8 */;
 CREATE TABLE `podnetworks` (
   `idpod` int(11) NOT NULL,
-  `podstartip` varchar(45) DEFAULT NULL,
-  `podendip` varchar(45) DEFAULT NULL,
-  `podmask` varchar(45) DEFAULT NULL,
-  `podgw` varchar(45) DEFAULT NULL,
-  `numips` int(11) DEFAULT NULL,
-  `vlans` varchar(45) DEFAULT NULL,
-  `numvlans` varchar(45) DEFAULT NULL,
+  `podstartip` varchar(45) NOT NULL,
+  `podendip` varchar(45) NOT NULL,
+  `podmask` varchar(45) NOT NULL,
+  `podgw` varchar(45) NOT NULL,
+  `numips` int(11) NOT NULL,
+  `vlans` varchar(45) NOT NULL,
+  `numvlans` varchar(45) NOT NULL,
   `inuse` varchar(45) NOT NULL,
   `envid` int(11) DEFAULT NULL,
   `updated` datetime DEFAULT NULL,
   `removed` datetime DEFAULT NULL,
   `comment` varchar(400) DEFAULT NULL,
-  `environmentname` varchar(100) NOT NULL,
+  `environmentname` varchar(100) DEFAULT NULL,
+  `pod_index` int(11) DEFAULT NULL,
+  `zone_index` int(11) DEFAULT NULL,
   PRIMARY KEY (`idpod`),
   UNIQUE KEY `idpod_UNIQUE` (`idpod`)
 ) ENGINE=InnoDB DEFAULT CHARSET=latin1;


LOCK TABLES `pubnetworks` WRITE;
/*!40000 ALTER TABLE `pubnetworks` DISABLE KEYS */;
INSERT INTO `pubnetworks` VALUES (1,'10.1.34.1','10.1.34.20','255.255.224.0','10.1.63.254',20,'1000','FALSE',NULL,NULL,NULL,'',''),(2,'10.1.34.21','10.1.34.40','255.255.224.0','10.1.63.254',20,'1000','FALSE',NULL,NULL,NULL,'',''),(3,'10.1.34.41','10.1.34.60','255.255.224.0','10.1.63.254',20,'1000','FALSE',NULL,NULL,NULL,'',''),(4,'10.1.34.61','10.1.34.80','255.255.224.0','10.1.63.254',20,'1000','FALSE',NULL,NULL,NULL,'',''),(5,'10.1.34.81','10.1.34.100','255.255.224.0','10.1.63.254',20,'1000','FALSE',NULL,NULL,NULL,'',''),(6,'10.1.34.101','10.1.34.120','255.255.224.0','10.1.63.254',20,'1000','FALSE',NULL,NULL,NULL,'',''),(7,'10.1.34.121','10.1.34.140','255.255.224.0','10.1.63.254',20,'1000','FALSE',NULL,NULL,NULL,'',''),(8,'10.1.34.141','10.1.34.160','255.255.224.0','10.1.63.254',20,'1000','FALSE',NULL,NULL,NULL,'',''),(9,'10.1.34.161','10.1.34.180','255.255.224.0','10.1.63.254',20,'1000','FALSE',NULL,NULL,NULL,'',''),(10,'10.1.34.181','10.1.34.200','255.255.224.0','10.1.63.254',20,'1000','FALSE',NULL,NULL,NULL,'',''),(11,'10.1.34.201','10.1.34.220','255.255.224.0','10.1.63.254',20,'1000','FALSE',NULL,NULL,NULL,'',''),(12,'10.1.34.221','10.1.34.240','255.255.224.0','10.1.63.254',20,'1000','FALSE',NULL,NULL,NULL,'',''),(13,'10.1.35.1','10.1.35.20','255.255.224.0','10.1.63.254',20,'1000','FALSE',NULL,NULL,NULL,'',''),(14,'10.1.35.21','10.1.35.40','255.255.224.0','10.1.63.254',20,'1000','FALSE',NULL,NULL,NULL,'',''),(15,'10.1.35.41','10.1.35.60','255.255.224.0','10.1.63.254',20,'1000','FALSE',NULL,NULL,NULL,'',''),(16,'10.1.35.61','10.1.35.80','255.255.224.0','10.1.63.254',20,'1000','FALSE',NULL,NULL,NULL,'',''),(17,'10.1.35.81','10.1.35.100','255.255.224.0','10.1.63.254',20,'1000','FALSE',NULL,NULL,NULL,'',''),(18,'10.1.35.101','10.1.35.120','255.255.224.0','10.1.63.254',20,'1000','FALSE',NULL,NULL,NULL,'',''),(19,'10.1.35.121','10.1.35.140','255.255.224.0','10.1.63.254',20,'1000','FALSE',NULL,NULL,NULL,'',''),(20,'10.1.35.141','10.1.35.160','255.255.224.0','10.1.63.254',20,'1000','FALSE',NULL,NULL,NULL,'','');
/*!40000 ALTER TABLE `pubnetworks` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

UNLOCK TABLES;

--
-- Table structure for table `lastbuild`
--

DROP TABLE IF EXISTS `lastbuild`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `lastbuild` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `last_env_build` datetime NOT NULL,
  `max_envs` varchar(45) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `lastbuild`
--

LOCK TABLES `lastbuild` WRITE;
/*!40000 ALTER TABLE `lastbuild` DISABLE KEYS */;
INSERT INTO `lastbuild` VALUES (1,'0000-00-00 00:00:00','22');
/*!40000 ALTER TABLE `lastbuild` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `podnetworks`
--

