-- MySQL dump 10.9 -- -- Host: localhost Database: wwwscal_ec2farm -- ------------------------------------------------------ -- Server version 4.1.22-standard /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; /*!40101 SET NAMES utf8 */; /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; -- -- Table structure for table `ami_roles` -- DROP TABLE IF EXISTS `ami_roles`; CREATE TABLE `ami_roles` ( `id` int(11) NOT NULL auto_increment, `ami_id` varchar(255) default NULL, `name` varchar(255) default NULL, `roletype` enum('SHARED','CUSTOM') default NULL, `clientid` int(11) default NULL, `prototype_iid` varchar(255) default NULL, `iscompleted` tinyint(1) default '1', `comments` text, `dtbuilt` datetime default NULL, `description` varchar(255) default NULL, `replace` varchar(255) default NULL, `default_minLA` int(5) default NULL, `default_maxLA` int(5) default NULL, `alias` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=16 DEFAULT CHARSET=latin1; -- -- Dumping data for table `ami_roles` -- LOCK TABLES `ami_roles` WRITE; /*!40000 ALTER TABLE `ami_roles` DISABLE KEYS */; INSERT INTO `ami_roles` VALUES (1,'ami-5dd53034','base','SHARED',0,NULL,1,NULL,NULL,NULL,NULL,5,10,'base'),(2,'ami-53d5303a','mysql','SHARED',0,NULL,1,NULL,NULL,NULL,NULL,5,10,'mysql'),(3,'ami-5ed53037','www','SHARED',0,NULL,1,NULL,NULL,NULL,NULL,5,10,'www'),(7,'ami-50d53039','app','SHARED',0,NULL,1,NULL,NULL,NULL,NULL,5,10,'app'); /*!40000 ALTER TABLE `ami_roles` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `clients` -- DROP TABLE IF EXISTS `clients`; CREATE TABLE `clients` ( `id` int(11) NOT NULL auto_increment, `email` varchar(255) default NULL, `password` varchar(64) default NULL, `aws_accesskeyid` varchar(255) default NULL, `aws_accountid` varchar(50) default NULL, `aws_accesskey` varchar(255) default NULL, `farms_limit` int(2) default '2', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; -- -- Dumping data for table `clients` -- LOCK TABLES `clients` WRITE; /*!40000 ALTER TABLE `clients` DISABLE KEYS */; /*!40000 ALTER TABLE `clients` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `config` -- DROP TABLE IF EXISTS `config`; CREATE TABLE `config` ( `id` int(10) unsigned NOT NULL auto_increment, `key` varchar(255) default NULL, `value` text, PRIMARY KEY (`id`), UNIQUE KEY `key` (`key`) ) ENGINE=MyISAM AUTO_INCREMENT=118 DEFAULT CHARSET=latin1; -- -- Dumping data for table `config` -- LOCK TABLES `config` WRITE; /*!40000 ALTER TABLE `config` DISABLE KEYS */; INSERT INTO `config` VALUES (96,'admin_login','admin'),(77,'admin_password','8c6976e5b5410415bde908bd4dee15dfb167a9c873fc4bb8a81f6f2ab448a918'),(3,'cryptokey','QhSqDYX7K5N85W8E'),(4,'crypto_algo','SHA256'),(18,'paging_items','20'),(97,'email_address','admin@scalr.net'),(98,'email_name','Support'),(105,'aws_accountid','123456789012'),(106,'aws_keyname','UIXXXXXXXXXXXMN3'),(102,'def_soa_owner','admin.scalr.net'),(110,'eventhandler_url','67.19.29.18'),(107,'secgroup_prefix','scalr.'),(99,'email_dsn',''),(113,'Submit','Save'),(111,'reboot_timeout','160'),(103,'def_soa_parent','ns1.scalr.net'),(104,'namedconftpl','zone \"{zone}\" {\r\n type master;\r\n file \"{db_filename}\";\r\n};'),(101,'dynamic_a_rec_ttl','90'),(108,'s3cfg_template','[default]\r\naccess_key = [access_key]\r\nacl_public = False\r\nforce = False\r\nhost = s3.amazonaws.com\r\nhuman_readable_sizes = False\r\nrecv_chunk = 4096\r\nsecret_key = [secret_key]\r\nsend_chunk = 4096\r\nverbosity = WARNING'),(109,'snmptrap_path','/usr/bin/snmptrap'),(100,'log_days','10'),(112,'launch_timeout','160'),(114,'id',''),(115,'page',''),(116,'f',''),(117,'client_max_instances','20'); /*!40000 ALTER TABLE `config` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `farm_amis` -- DROP TABLE IF EXISTS `farm_amis`; CREATE TABLE `farm_amis` ( `id` int(11) NOT NULL auto_increment, `farmid` int(11) default NULL, `ami_id` varchar(255) default NULL, `min_count` int(3) default '1', `max_count` int(3) default '2', `min_LA` float(5,2) default NULL, `max_LA` float(5,2) default NULL, `replace_to_ami` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=89 DEFAULT CHARSET=latin1; -- -- Dumping data for table `farm_amis` -- LOCK TABLES `farm_amis` WRITE; /*!40000 ALTER TABLE `farm_amis` DISABLE KEYS */; /*!40000 ALTER TABLE `farm_amis` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `farm_instances` -- DROP TABLE IF EXISTS `farm_instances`; CREATE TABLE `farm_instances` ( `id` int(11) NOT NULL auto_increment, `farmid` int(11) default NULL, `instance_id` varchar(255) default NULL, `state` enum('Pending','Running') default 'Pending', `ami_id` varchar(50) default NULL, `internal_ip` varchar(15) default NULL, `external_ip` varchar(15) default NULL, `isdbmaster` tinyint(1) default '0', `replace_iid` varchar(255) default NULL, `dtadded` datetime default NULL, `dtrebootstart` datetime default NULL, `isrebootlaunched` tinyint(1) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=247 DEFAULT CHARSET=latin1; -- -- Dumping data for table `farm_instances` -- LOCK TABLES `farm_instances` WRITE; /*!40000 ALTER TABLE `farm_instances` DISABLE KEYS */; /*!40000 ALTER TABLE `farm_instances` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `farms` -- DROP TABLE IF EXISTS `farms`; CREATE TABLE `farms` ( `id` int(11) NOT NULL auto_increment, `clientid` int(11) default NULL, `name` varchar(255) default NULL, `iscompleted` tinyint(1) default '0', `hash` varchar(25) default NULL, `dtadded` datetime default NULL, `private_key` text, `private_key_name` varchar(255) default NULL, `public_key` text, `status` tinyint(1) default '1', `mysql_bcp` tinyint(1) default '0', `mysql_bcp_every` int(5) default NULL, `mysql_rebundle_every` int(5) default NULL, `dtlastbcp` int(11) default NULL, `dtlastrebundle` int(11) default NULL, `isbcprunning` tinyint(1) default '0', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=30 DEFAULT CHARSET=latin1; -- -- Dumping data for table `farms` -- LOCK TABLES `farms` WRITE; /*!40000 ALTER TABLE `farms` DISABLE KEYS */; /*!40000 ALTER TABLE `farms` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `logentries` -- DROP TABLE IF EXISTS `logentries`; CREATE TABLE `logentries` ( `id` int(11) NOT NULL auto_increment, `serverid` varchar(25) NOT NULL default '', `message` text NOT NULL, `severity` tinyint(1) default '0', `time` int(11) NOT NULL default '0', `source` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `logentries` -- LOCK TABLES `logentries` WRITE; /*!40000 ALTER TABLE `logentries` DISABLE KEYS */; /*!40000 ALTER TABLE `logentries` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `nameservers` -- DROP TABLE IF EXISTS `nameservers`; CREATE TABLE `nameservers` ( `id` int(10) unsigned NOT NULL auto_increment, `host` varchar(100) default NULL, `port` int(10) unsigned default NULL, `username` varchar(100) default NULL, `password` text, `rndc_path` varchar(255) default NULL, `named_path` varchar(255) default NULL, `namedconf_path` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `nameservers` -- LOCK TABLES `nameservers` WRITE; /*!40000 ALTER TABLE `nameservers` DISABLE KEYS */; INSERT INTO `nameservers` VALUES (1,'ns1.scalr.net',22,'named','sVTN4//0JAU=','/usr/sbin/rndc','/var/named','/etc/named.conf'),(2,'ns2.scalr.net',22,'named','sVTN4//0JAU=','/usr/sbin/rndc','/var/named','/etc/named.conf'); /*!40000 ALTER TABLE `nameservers` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `records` -- DROP TABLE IF EXISTS `records`; CREATE TABLE `records` ( `id` int(10) unsigned NOT NULL auto_increment, `zoneid` int(10) unsigned NOT NULL default '0', `rtype` enum('A','MX','CNAME','NS') default NULL, `ttl` int(10) unsigned default NULL, `rpriority` int(10) unsigned default NULL, `rvalue` varchar(255) default NULL, `rkey` varchar(255) default NULL, `issystem` tinyint(1) default NULL, PRIMARY KEY (`id`), UNIQUE KEY `zoneid` (`zoneid`,`rtype`,`rvalue`,`rkey`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `records` -- LOCK TABLES `records` WRITE; /*!40000 ALTER TABLE `records` DISABLE KEYS */; INSERT INTO `records` VALUES (159,3,'A',90,NULL,'67.202.23.236','@',1),(160,3,'A',90,NULL,'67.202.24.142','@',1),(162,3,'A',90,NULL,'72.44.34.226','@',1); /*!40000 ALTER TABLE `records` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `security_rules` -- DROP TABLE IF EXISTS `security_rules`; CREATE TABLE `security_rules` ( `id` int(11) NOT NULL auto_increment, `roleid` int(11) default NULL, `rule` varchar(255) default NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=39 DEFAULT CHARSET=latin1; -- -- Dumping data for table `security_rules` -- LOCK TABLES `security_rules` WRITE; /*!40000 ALTER TABLE `security_rules` DISABLE KEYS */; INSERT INTO `security_rules` VALUES (1,1,'tcp:22:22:0.0.0.0/0'),(2,1,'udp:161:162:0.0.0.0/0'),(3,2,'tcp:22:22:0.0.0.0/0'),(4,2,'tcp:3306:3306:0.0.0.0/0'),(5,2,'udp:161:162:0.0.0.0/0'),(35,3,'tcp:80:80:0.0.0.0/0'),(34,3,'tcp:22:22:0.0.0.0/0'),(33,3,'udp:161:162:0.0.0.0/0'),(32,7,'udp:161:162:0.0.0.0/0'),(31,7,'tcp:22:22:0.0.0.0/0'),(30,7,'tcp:80:80:0.0.0.0/0'),(15,9,'tcp:80:80:0.0.0.0/0'),(16,9,'tcp:22:22:0.0.0.0/0'),(17,9,'udp:161:162:0.0.0.0/0'),(27,10,'tcp:80:80:0.0.0.0/0'),(28,10,'tcp:22:22:0.0.0.0/0'),(29,10,'udp:161:162:0.0.0.0/0'),(36,15,'udp:161:162:0.0.0.0/0'),(37,15,'tcp:22:22:0.0.0.0/0'),(38,15,'tcp:80:80:0.0.0.0/0'); /*!40000 ALTER TABLE `security_rules` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `syslog` -- DROP TABLE IF EXISTS `syslog`; CREATE TABLE `syslog` ( `id` int(10) unsigned NOT NULL auto_increment, `dtadded` datetime default NULL, `message` text, `severity` int(11) default NULL, `dtadded_time` bigint(20) default NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `syslog` -- LOCK TABLES `syslog` WRITE; /*!40000 ALTER TABLE `syslog` DISABLE KEYS */; /*!40000 ALTER TABLE `syslog` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `zones` -- DROP TABLE IF EXISTS `zones`; CREATE TABLE `zones` ( `id` int(10) unsigned NOT NULL auto_increment, `zone` varchar(255) default NULL, `soa_owner` varchar(100) default NULL, `soa_ttl` int(10) unsigned default NULL, `soa_parent` varchar(100) default NULL, `soa_serial` int(10) unsigned default NULL, `soa_refresh` int(10) unsigned default NULL, `soa_retry` int(10) unsigned default NULL, `soa_expire` int(10) unsigned default NULL, `min_ttl` int(10) unsigned default NULL, `dtupdated` datetime default NULL, `farmid` int(11) default NULL, `ami_id` varchar(255) default NULL, `clientid` int(11) default NULL, `isdeleted` tinyint(1) default '0', PRIMARY KEY (`id`), UNIQUE KEY `zones_index3945` (`zone`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- -- Dumping data for table `zones` -- LOCK TABLES `zones` WRITE; /*!40000 ALTER TABLE `zones` DISABLE KEYS */; /*!40000 ALTER TABLE `zones` ENABLE KEYS */; UNLOCK TABLES; /*!40101 SET SQL_MODE=@OLD_SQL_MODE */; /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;