YkxzvtiH

1DROP TABLE IF EXISTS `slaves`;
2/*!40101 SET @saved_cs_client     = @@character_set_client */;
3/*!40101 SET character_set_client = utf8 */;
4CREATE TABLE `slaves` (
5  `slaveid` int(11) NOT NULL auto_increment,
6  `name` varchar(128) NOT NULL,
7  `distroid` int(11) NOT NULL,
8  `bitsid` int(11) NOT NULL,
9  `speedid` int(11) NOT NULL,
10  `purposeid` int(11) NOT NULL,
11  `dcid` int(11) NOT NULL,
12  `trustid` int(11) NOT NULL,
13  `envid` int(11) NOT NULL,
14  `poolid` int(11) NOT NULL,
15  `basedir` text NOT NULL,
16  `locked_masterid` int(11) default NULL,
17  `custom_tplid` int(11) default NULL,
18  `enabled` tinyint(1) NOT NULL,
19  `notes` text,
20  `current_masterid` int(11) default NULL,
21  PRIMARY KEY  (`slaveid`),
22  UNIQUE KEY `name` (`name`),
23  KEY `current_masterid` (`current_masterid`),
24  KEY `bitsid` (`bitsid`),
25  KEY `speedid` (`speedid`),
26  KEY `purposeid` (`purposeid`),
27  KEY `dcid` (`dcid`),
28  KEY `envid` (`envid`),
29  KEY `locked_masterid` (`locked_masterid`),
30  KEY `trustid` (`trustid`),
31  KEY `slave_silo` (`distroid`,`bitsid`,`speedid`,`purposeid`,`dcid`,`trustid`,`envid`),
32  KEY `slave_poolid` (`poolid`),
33  CONSTRAINT `slaves_ibfk_1` FOREIGN KEY (`current_masterid`) REFERENCES `masters` (`masterid`),
34  CONSTRAINT `slaves_ibfk_10` FOREIGN KEY (`trustid`) REFERENCES `trustlevels` (`trustid`),
35  CONSTRAINT `slaves_ibfk_2` FOREIGN KEY (`distroid`) REFERENCES `distros` (`distroid`),
36  CONSTRAINT `slaves_ibfk_3` FOREIGN KEY (`bitsid`) REFERENCES `bitlengths` (`bitsid`),
37  CONSTRAINT `slaves_ibfk_4` FOREIGN KEY (`speedid`) REFERENCES `speeds` (`speedid`),
38  CONSTRAINT `slaves_ibfk_5` FOREIGN KEY (`purposeid`) REFERENCES `purposes` (`purposeid`),
39  CONSTRAINT `slaves_ibfk_6` FOREIGN KEY (`dcid`) REFERENCES `datacenters` (`dcid`),
40  CONSTRAINT `slaves_ibfk_7` FOREIGN KEY (`envid`) REFERENCES `environments` (`envid`),
41  CONSTRAINT `slaves_ibfk_8` FOREIGN KEY (`poolid`) REFERENCES `pools` (`poolid`),
42  CONSTRAINT `slaves_ibfk_9` FOREIGN KEY (`locked_masterid`) REFERENCES `masters` (`masterid`)
43) ENGINE=InnoDB AUTO_INCREMENT=1070 DEFAULT CHARSET=utf8;
44/*!40101 SET character_set_client = @saved_cs_client */;
45/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;