 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`
 --
 

/*!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,
  `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,
  PRIMARY KEY (`idpod`),
  UNIQUE KEY `idpod_UNIQUE` (`idpod`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

USE `trillian_envs`;

--
-- Table structure for table `basicguestnetworks`
--

DROP TABLE IF EXISTS `basicguestnetworks`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `basicguestnetworks` (
  `idguest` int(11) NOT NULL,
  `gueststartip` varchar(45) DEFAULT NULL,
  `guestendip` varchar(45) DEFAULT NULL,
  `guestmask` varchar(45) DEFAULT NULL,
  `guestgw` varchar(45) DEFAULT NULL,
  `numips` int(11) DEFAULT NULL,
  `vlan` varchar(45) DEFAULT 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,
  PRIMARY KEY (`idguest`),
  UNIQUE KEY `idub_UNIQUE` (`idguest`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `basicguestnetworks`
--

LOCK TABLES `basicguestnetworks` WRITE;
/*!40000 ALTER TABLE `basicguestnetworks` DISABLE KEYS */;
INSERT INTO `basicguestnetworks` VALUES (0,NULL,NULL,NULL,NULL,NULL,NULL,'',NULL,NULL,'2016-01-01 12:00:00',NULL,'TBC'),(1,'10.3.0.1','10.3.0.250','255.255.224.0','10.3.31.254',250,'3000','FALSE',NULL,NULL,NULL,NULL,'TBC'),(2,'10.3.1.1','10.3.1.250','255.255.224.0','10.3.31.254',250,'3000','FALSE',NULL,NULL,NULL,NULL,'TBC'),(3,'10.3.2.1','10.3.2.250','255.255.224.0','10.3.31.254',250,'3000','FALSE',NULL,NULL,NULL,NULL,'TBC'),(4,'10.3.3.1','10.3.3.250','255.255.224.0','10.3.31.254',250,'3000','FALSE',NULL,NULL,NULL,NULL,'TBC'),(5,'10.3.4.1','10.3.4.250','255.255.224.0','10.3.31.254',250,'3000','FALSE',NULL,NULL,NULL,NULL,'TBC'),(6,'10.3.5.1','10.3.5.250','255.255.224.0','10.3.31.254',250,'3000','FALSE',NULL,NULL,NULL,NULL,'TBC'),(7,'10.3.6.1','10.3.6.250','255.255.224.0','10.3.31.254',250,'3000','FALSE',NULL,NULL,NULL,NULL,'TBC'),(8,'10.3.7.1','10.3.7.250','255.255.224.0','10.3.31.254',250,'3000','FALSE',NULL,NULL,NULL,NULL,'TBC'),(9,'10.3.8.1','10.3.8.250','255.255.224.0','10.3.31.254',250,'3000','FALSE',NULL,NULL,NULL,NULL,'TBC'),(10,'10.3.9.1','10.3.9.250','255.255.224.0','10.3.31.254',250,'3000','FALSE',NULL,NULL,NULL,NULL,'TBC'),(11,'10.3.10.1','10.3.10.250','255.255.224.0','10.3.31.254',250,'3000','FALSE',NULL,NULL,NULL,NULL,'TBC'),(12,'10.3.11.1','10.3.11.250','255.255.224.0','10.3.31.254',250,'3000','FALSE',NULL,NULL,NULL,NULL,'TBC'),(13,'10.3.12.1','10.3.12.250','255.255.224.0','10.3.31.254',250,'3000','FALSE',NULL,NULL,NULL,NULL,'TBC'),(14,'10.3.13.1','10.3.13.250','255.255.224.0','10.3.31.254',250,'3000','FALSE',NULL,NULL,NULL,NULL,'TBC'),(15,'10.3.14.1','10.3.14.250','255.255.224.0','10.3.31.254',250,'3000','FALSE',NULL,NULL,NULL,NULL,'TBC'),(16,'10.3.15.1','10.3.15.250','255.255.224.0','10.3.31.254',250,'3000','FALSE',NULL,NULL,NULL,NULL,'TBC'),(17,'10.3.16.1','10.3.16.250','255.255.224.0','10.3.31.254',250,'3000','FALSE',NULL,NULL,NULL,NULL,'TBC'),(18,'10.3.17.1','10.3.17.250','255.255.224.0','10.3.31.254',250,'3000','FALSE',NULL,NULL,NULL,NULL,'TBC'),(19,'10.3.18.1','10.3.18.250','255.255.224.0','10.3.31.254',250,'3000','FALSE',NULL,NULL,NULL,NULL,'TBC'),(20,'10.3.19.1','10.3.19.250','255.255.224.0','10.3.31.254',250,'3000','FALSE',NULL,NULL,NULL,NULL,'TBC');
/*!40000 ALTER TABLE `basicguestnetworks` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `environments`
--

