-- MySQL dump 10.16 Distrib 10.1.26-MariaDB, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: opennebula -- ------------------------------------------------------ -- Server version 10.1.26-MariaDB-0+deb9u1 /*!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 utf8mb4 */; /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; /*!40103 SET TIME_ZONE='+00:00' */; /*!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 `acl` -- DROP TABLE IF EXISTS `acl`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `acl` ( `oid` int(11) NOT NULL, `user` bigint(20) DEFAULT NULL, `resource` bigint(20) DEFAULT NULL, `rights` bigint(20) DEFAULT NULL, `zone` bigint(20) DEFAULT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `user` (`user`,`resource`,`rights`,`zone`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `acl` -- LOCK TABLES `acl` WRITE; /*!40000 ALTER TABLE `acl` DISABLE KEYS */; INSERT INTO `acl` VALUES (3,8589934593,154618822656,2,4294967296),(4,8589934593,17884243820544,1,4294967296),(0,8589934593,9361877654044672,8,17179869184),(1,17179869184,140754668224512,1,17179869184),(2,17179869184,6755416620924928,1,17179869184); /*!40000 ALTER TABLE `acl` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cluster_datastore_relation` -- DROP TABLE IF EXISTS `cluster_datastore_relation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cluster_datastore_relation` ( `cid` int(11) NOT NULL, `oid` int(11) NOT NULL, PRIMARY KEY (`cid`,`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cluster_datastore_relation` -- LOCK TABLES `cluster_datastore_relation` WRITE; /*!40000 ALTER TABLE `cluster_datastore_relation` DISABLE KEYS */; INSERT INTO `cluster_datastore_relation` VALUES (0,0),(0,1),(0,2); /*!40000 ALTER TABLE `cluster_datastore_relation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cluster_network_relation` -- DROP TABLE IF EXISTS `cluster_network_relation`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cluster_network_relation` ( `cid` int(11) NOT NULL, `oid` int(11) NOT NULL, PRIMARY KEY (`cid`,`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cluster_network_relation` -- LOCK TABLES `cluster_network_relation` WRITE; /*!40000 ALTER TABLE `cluster_network_relation` DISABLE KEYS */; /*!40000 ALTER TABLE `cluster_network_relation` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cluster_pool` -- DROP TABLE IF EXISTS `cluster_pool`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cluster_pool` ( `oid` int(11) NOT NULL, `name` varchar(128) DEFAULT NULL, `body` mediumtext, `uid` int(11) DEFAULT NULL, `gid` int(11) DEFAULT NULL, `owner_u` int(11) DEFAULT NULL, `group_u` int(11) DEFAULT NULL, `other_u` int(11) DEFAULT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cluster_pool` -- LOCK TABLES `cluster_pool` WRITE; /*!40000 ALTER TABLE `cluster_pool` DISABLE KEYS */; INSERT INTO `cluster_pool` VALUES (0,'default','0default012',0,0,1,0,0); /*!40000 ALTER TABLE `cluster_pool` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `cluster_vnc_bitmap` -- DROP TABLE IF EXISTS `cluster_vnc_bitmap`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `cluster_vnc_bitmap` ( `id` int(11) NOT NULL, `map` longtext, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `cluster_vnc_bitmap` -- LOCK TABLES `cluster_vnc_bitmap` WRITE; /*!40000 ALTER TABLE `cluster_vnc_bitmap` DISABLE KEYS */; INSERT INTO `cluster_vnc_bitmap` VALUES (0,'eJztwYEAAAAAgCCl/ekWqQoAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAAABqFo8C0Q=='); /*!40000 ALTER TABLE `cluster_vnc_bitmap` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `datastore_pool` -- DROP TABLE IF EXISTS `datastore_pool`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `datastore_pool` ( `oid` int(11) NOT NULL, `name` varchar(128) DEFAULT NULL, `body` mediumtext, `uid` int(11) DEFAULT NULL, `gid` int(11) DEFAULT NULL, `owner_u` int(11) DEFAULT NULL, `group_u` int(11) DEFAULT NULL, `other_u` int(11) DEFAULT NULL, PRIMARY KEY (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `datastore_pool` -- LOCK TABLES `datastore_pool` WRITE; /*!40000 ALTER TABLE `datastore_pool` DISABLE KEYS */; INSERT INTO `datastore_pool` VALUES (0,'system','000oneadminoneadminsystem1101000001000000',0,0,1,1,0),(1,'default','100oneadminoneadmindefault110100000000029909248643504',0,0,1,1,0),(2,'files','200oneadminoneadminfiles110100000200029909248643504',0,0,1,1,0); /*!40000 ALTER TABLE `datastore_pool` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `db_versioning` -- DROP TABLE IF EXISTS `db_versioning`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `db_versioning` ( `oid` int(11) NOT NULL, `version` varchar(256) DEFAULT NULL, `timestamp` int(11) DEFAULT NULL, `comment` varchar(256) DEFAULT NULL, PRIMARY KEY (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `db_versioning` -- LOCK TABLES `db_versioning` WRITE; /*!40000 ALTER TABLE `db_versioning` DISABLE KEYS */; INSERT INTO `db_versioning` VALUES (0,'5.4.1',1516659880,'OpenNebula 5.4.1 daemon bootstrap'); /*!40000 ALTER TABLE `db_versioning` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `document_pool` -- DROP TABLE IF EXISTS `document_pool`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `document_pool` ( `oid` int(11) NOT NULL, `name` varchar(128) DEFAULT NULL, `body` mediumtext, `type` int(11) DEFAULT NULL, `uid` int(11) DEFAULT NULL, `gid` int(11) DEFAULT NULL, `owner_u` int(11) DEFAULT NULL, `group_u` int(11) DEFAULT NULL, `other_u` int(11) DEFAULT NULL, PRIMARY KEY (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `document_pool` -- LOCK TABLES `document_pool` WRITE; /*!40000 ALTER TABLE `document_pool` DISABLE KEYS */; /*!40000 ALTER TABLE `document_pool` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `group_pool` -- DROP TABLE IF EXISTS `group_pool`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `group_pool` ( `oid` int(11) NOT NULL, `name` varchar(128) DEFAULT NULL, `body` mediumtext, `uid` int(11) DEFAULT NULL, `gid` int(11) DEFAULT NULL, `owner_u` int(11) DEFAULT NULL, `group_u` int(11) DEFAULT NULL, `other_u` int(11) DEFAULT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `group_pool` -- LOCK TABLES `group_pool` WRITE; /*!40000 ALTER TABLE `group_pool` DISABLE KEYS */; INSERT INTO `group_pool` VALUES (0,'oneadmin','0oneadmin01',0,0,1,1,0),(1,'users','1users',0,1,1,1,0); /*!40000 ALTER TABLE `group_pool` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `group_quotas` -- DROP TABLE IF EXISTS `group_quotas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `group_quotas` ( `group_oid` int(11) NOT NULL, `body` mediumtext, PRIMARY KEY (`group_oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `group_quotas` -- LOCK TABLES `group_quotas` WRITE; /*!40000 ALTER TABLE `group_quotas` DISABLE KEYS */; INSERT INTO `group_quotas` VALUES (0,'0'),(1,'1'); /*!40000 ALTER TABLE `group_quotas` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `history` -- DROP TABLE IF EXISTS `history`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `history` ( `vid` int(11) NOT NULL, `seq` int(11) NOT NULL, `body` mediumtext, `stime` int(11) DEFAULT NULL, `etime` int(11) DEFAULT NULL, PRIMARY KEY (`vid`,`seq`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `history` -- LOCK TABLES `history` WRITE; /*!40000 ALTER TABLE `history` DISABLE KEYS */; /*!40000 ALTER TABLE `history` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `host_monitoring` -- DROP TABLE IF EXISTS `host_monitoring`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `host_monitoring` ( `hid` int(11) NOT NULL, `last_mon_time` int(11) NOT NULL, `body` mediumtext, PRIMARY KEY (`hid`,`last_mon_time`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `host_monitoring` -- LOCK TABLES `host_monitoring` WRITE; /*!40000 ALTER TABLE `host_monitoring` DISABLE KEYS */; /*!40000 ALTER TABLE `host_monitoring` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `host_pool` -- DROP TABLE IF EXISTS `host_pool`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `host_pool` ( `oid` int(11) NOT NULL, `name` varchar(128) DEFAULT NULL, `body` mediumtext, `state` int(11) DEFAULT NULL, `last_mon_time` int(11) DEFAULT NULL, `uid` int(11) DEFAULT NULL, `gid` int(11) DEFAULT NULL, `owner_u` int(11) DEFAULT NULL, `group_u` int(11) DEFAULT NULL, `other_u` int(11) DEFAULT NULL, `cid` int(11) DEFAULT NULL, PRIMARY KEY (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `host_pool` -- LOCK TABLES `host_pool` WRITE; /*!40000 ALTER TABLE `host_pool` DISABLE KEYS */; /*!40000 ALTER TABLE `host_pool` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `image_pool` -- DROP TABLE IF EXISTS `image_pool`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `image_pool` ( `oid` int(11) NOT NULL, `name` varchar(128) DEFAULT NULL, `body` mediumtext, `uid` int(11) DEFAULT NULL, `gid` int(11) DEFAULT NULL, `owner_u` int(11) DEFAULT NULL, `group_u` int(11) DEFAULT NULL, `other_u` int(11) DEFAULT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `name` (`name`,`uid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `image_pool` -- LOCK TABLES `image_pool` WRITE; /*!40000 ALTER TABLE `image_pool` DISABLE KEYS */; /*!40000 ALTER TABLE `image_pool` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `local_db_versioning` -- DROP TABLE IF EXISTS `local_db_versioning`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `local_db_versioning` ( `oid` int(11) NOT NULL, `version` varchar(256) DEFAULT NULL, `timestamp` int(11) DEFAULT NULL, `comment` varchar(256) DEFAULT NULL, `is_slave` tinyint(1) DEFAULT NULL, PRIMARY KEY (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `local_db_versioning` -- LOCK TABLES `local_db_versioning` WRITE; /*!40000 ALTER TABLE `local_db_versioning` DISABLE KEYS */; INSERT INTO `local_db_versioning` VALUES (0,'5.4.1',1516659876,'OpenNebula 5.4.1 daemon bootstrap',0); /*!40000 ALTER TABLE `local_db_versioning` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `logdb` -- DROP TABLE IF EXISTS `logdb`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `logdb` ( `log_index` int(11) NOT NULL, `term` int(11) DEFAULT NULL, `sqlcmd` mediumtext, `timestamp` int(11) DEFAULT NULL, `fed_index` int(11) DEFAULT NULL, PRIMARY KEY (`log_index`), KEY `fed_index_idx` (`fed_index`), KEY `timestamp_idx` (`timestamp`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `logdb` -- LOCK TABLES `logdb` WRITE; /*!40000 ALTER TABLE `logdb` DISABLE KEYS */; INSERT INTO `logdb` VALUES (-1,-1,'',0,-1),(0,0,'eJwzNDU0MzO1tDAzBwALTwIX',1516659867,-1); /*!40000 ALTER TABLE `logdb` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `marketplace_pool` -- DROP TABLE IF EXISTS `marketplace_pool`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `marketplace_pool` ( `oid` int(11) NOT NULL, `name` varchar(128) DEFAULT NULL, `body` mediumtext, `uid` int(11) DEFAULT NULL, `gid` int(11) DEFAULT NULL, `owner_u` int(11) DEFAULT NULL, `group_u` int(11) DEFAULT NULL, `other_u` int(11) DEFAULT NULL, PRIMARY KEY (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `marketplace_pool` -- LOCK TABLES `marketplace_pool` WRITE; /*!40000 ALTER TABLE `marketplace_pool` DISABLE KEYS */; INSERT INTO `marketplace_pool` VALUES (0,'OpenNebula Public','000oneadminoneadminOpenNebula Public0000123456789101112131415161718192021222324111100100',0,0,1,1,1); /*!40000 ALTER TABLE `marketplace_pool` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `marketplaceapp_pool` -- DROP TABLE IF EXISTS `marketplaceapp_pool`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `marketplaceapp_pool` ( `oid` int(11) NOT NULL, `name` varchar(128) DEFAULT NULL, `body` mediumtext, `uid` int(11) DEFAULT NULL, `gid` int(11) DEFAULT NULL, `owner_u` int(11) DEFAULT NULL, `group_u` int(11) DEFAULT NULL, `other_u` int(11) DEFAULT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `name` (`name`,`uid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `marketplaceapp_pool` -- LOCK TABLES `marketplaceapp_pool` WRITE; /*!40000 ALTER TABLE `marketplaceapp_pool` DISABLE KEYS */; INSERT INTO `marketplaceapp_pool` VALUES (0,'Vrouter Load Balancer Alpine - KVM','000oneadminoneadmin1485773382Vrouter Load Balancer Alpine - KVM81920OpenNebula Public11110100100',0,0,1,1,1),(1,'Fedora 27 - KVM','100oneadminoneadmin1515059845Fedora 27 - KVM40960OpenNebula Public11110100100',0,0,1,1,1),(2,'Alpine Linux 3.6 - KVM','200oneadminoneadmin1515056284Alpine Linux 3.6 - KVM102400OpenNebula Public11110100100',0,0,1,1,1),(3,'Ubuntu 16.04 - EC2','300oneadminoneadmin1515065188Ubuntu 16.04 - EC200OpenNebula Public11110100100',0,0,1,1,1),(4,'Debian 9 - KVM','400oneadminoneadmin1500454066Debian 9 - KVM20480OpenNebula Public11110100100',0,0,1,1,1),(5,'Ubuntu 16.04 - KVM','500oneadminoneadmin1465895586Ubuntu 16.04 - KVM22520OpenNebula Public11110100100',0,0,1,1,1),(6,'alpine-vrouter (KVM)','600oneadminoneadmin1457608289alpine-vrouter (KVM)2560OpenNebula Public11110100100',0,0,1,1,1),(7,'openSUSE 42 - KVM','700oneadminoneadmin1500454066openSUSE 42 - KVM102400OpenNebula Public11110100100',0,0,1,1,1),(8,'Ubuntu 17.04 - KVM','800oneadminoneadmin1465895586Ubuntu 17.04 - KVM22520OpenNebula Public11110100100',0,0,1,1,1),(9,'boot2docker','900oneadminoneadmin1456501637boot2docker390OpenNebula Public11110100100',0,0,1,1,1),(10,'Debian 9 - EC2','1000oneadminoneadmin1515065188Debian 9 - EC200OpenNebula Public11110100100',0,0,1,1,1),(11,'CentOS 6 - KVM','1100oneadminoneadmin1407674298CentOS 6 - KVM81920OpenNebula Public11110100100',0,0,1,1,1),(12,'Debian 8 - KVM','1200oneadminoneadmin1443105849Debian 8 - KVM20480OpenNebula Public11110100100',0,0,1,1,1),(13,'alpine-vrouter (vcenter)','1300oneadminoneadmin1457608461alpine-vrouter (vcenter)2560OpenNebula Public11110100100',0,0,1,1,1),(14,'Ubuntu for Docker Machine','1400oneadminoneadmin1456159688Ubuntu for Docker Machine102400OpenNebula Public11110100100',0,0,1,1,1),(15,'Ubuntu 14.04 - KVM','1500oneadminoneadmin1407697330Ubuntu 14.04 - KVM22520OpenNebula Public11110100100',0,0,1,1,1),(16,'CentOS 7 - EC2','1600oneadminoneadmin1515065188CentOS 7 - EC200OpenNebula Public11110100100',0,0,1,1,1),(17,'Devuan 1 - KVM','1700oneadminoneadmin1500454066Devuan 1 - KVM204790OpenNebula Public11110100100',0,0,1,1,1),(18,'ttylinux - kvm','1800oneadminoneadmin0ttylinux - kvm2000OpenNebula Public11110100100',0,0,1,1,1),(19,'CentOS 7 - KVM','1900oneadminoneadmin1407696786CentOS 7 - KVM81920OpenNebula Public11110100100',0,0,1,1,1),(20,'Arch Linux','2000oneadminoneadmin1426762698Arch Linux100000OpenNebula Public11110100100',0,0,1,1,1),(21,'Ubuntu 16.04 - LXD','2100oneadminoneadmin1500931500Ubuntu 16.04 - LXD10240OpenNebula Public11110100100',0,0,1,1,1),(22,'CoreOS alpha','2200oneadminoneadmin1459704192CoreOS alpha102400OpenNebula Public11110100100',0,0,1,1,1),(23,'FreeBSD 10.3','2300oneadminoneadmin1486408847FreeBSD 10.3204800OpenNebula Public11110100100',0,0,1,1,1),(24,'VyOS 1.1.5 Helium 64 bits','2400oneadminoneadmin1430328100VyOS 1.1.5 Helium 64 bits20000OpenNebula Public11110100100',0,0,1,1,1); /*!40000 ALTER TABLE `marketplaceapp_pool` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `network_pool` -- DROP TABLE IF EXISTS `network_pool`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `network_pool` ( `oid` int(11) NOT NULL, `name` varchar(128) DEFAULT NULL, `body` mediumtext, `uid` int(11) DEFAULT NULL, `gid` int(11) DEFAULT NULL, `owner_u` int(11) DEFAULT NULL, `group_u` int(11) DEFAULT NULL, `other_u` int(11) DEFAULT NULL, `pid` int(11) DEFAULT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `name` (`name`,`uid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `network_pool` -- LOCK TABLES `network_pool` WRITE; /*!40000 ALTER TABLE `network_pool` DISABLE KEYS */; /*!40000 ALTER TABLE `network_pool` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `network_vlan_bitmap` -- DROP TABLE IF EXISTS `network_vlan_bitmap`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `network_vlan_bitmap` ( `id` int(11) NOT NULL, `map` longtext, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `network_vlan_bitmap` -- LOCK TABLES `network_vlan_bitmap` WRITE; /*!40000 ALTER TABLE `network_vlan_bitmap` DISABLE KEYS */; INSERT INTO `network_vlan_bitmap` VALUES (0,'eJztwQENAAAAwqBK75/OHg4oAAAA4N0A+B4ALg=='); /*!40000 ALTER TABLE `network_vlan_bitmap` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `pool_control` -- DROP TABLE IF EXISTS `pool_control`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `pool_control` ( `tablename` varchar(32) NOT NULL, `last_oid` bigint(20) unsigned DEFAULT NULL, PRIMARY KEY (`tablename`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `pool_control` -- LOCK TABLES `pool_control` WRITE; /*!40000 ALTER TABLE `pool_control` DISABLE KEYS */; INSERT INTO `pool_control` VALUES ('acl',4),('cluster_pool',99),('datastore_pool',99),('group_pool',99),('marketplaceapp_pool',24),('marketplace_pool',99),('secgroup_pool',99),('user_pool',1),('vdc_pool',99),('zone_pool',99); /*!40000 ALTER TABLE `pool_control` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `secgroup_pool` -- DROP TABLE IF EXISTS `secgroup_pool`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `secgroup_pool` ( `oid` int(11) NOT NULL, `name` varchar(128) DEFAULT NULL, `body` mediumtext, `uid` int(11) DEFAULT NULL, `gid` int(11) DEFAULT NULL, `owner_u` int(11) DEFAULT NULL, `group_u` int(11) DEFAULT NULL, `other_u` int(11) DEFAULT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `name` (`name`,`uid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `secgroup_pool` -- LOCK TABLES `secgroup_pool` WRITE; /*!40000 ALTER TABLE `secgroup_pool` DISABLE KEYS */; INSERT INTO `secgroup_pool` VALUES (0,'default','000oneadminoneadmindefault111100100',0,0,1,1,1); /*!40000 ALTER TABLE `secgroup_pool` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `system_attributes` -- DROP TABLE IF EXISTS `system_attributes`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `system_attributes` ( `name` varchar(128) NOT NULL, `body` mediumtext, PRIMARY KEY (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `system_attributes` -- LOCK TABLES `system_attributes` WRITE; /*!40000 ALTER TABLE `system_attributes` DISABLE KEYS */; INSERT INTO `system_attributes` VALUES ('DEFAULT_GROUP_QUOTAS',''),('DEFAULT_USER_QUOTAS',''); /*!40000 ALTER TABLE `system_attributes` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `template_pool` -- DROP TABLE IF EXISTS `template_pool`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `template_pool` ( `oid` int(11) NOT NULL, `name` varchar(128) DEFAULT NULL, `body` mediumtext, `uid` int(11) DEFAULT NULL, `gid` int(11) DEFAULT NULL, `owner_u` int(11) DEFAULT NULL, `group_u` int(11) DEFAULT NULL, `other_u` int(11) DEFAULT NULL, PRIMARY KEY (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `template_pool` -- LOCK TABLES `template_pool` WRITE; /*!40000 ALTER TABLE `template_pool` DISABLE KEYS */; /*!40000 ALTER TABLE `template_pool` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_pool` -- DROP TABLE IF EXISTS `user_pool`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user_pool` ( `oid` int(11) NOT NULL, `name` varchar(128) DEFAULT NULL, `body` mediumtext, `uid` int(11) DEFAULT NULL, `gid` int(11) DEFAULT NULL, `owner_u` int(11) DEFAULT NULL, `group_u` int(11) DEFAULT NULL, `other_u` int(11) DEFAULT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_pool` -- LOCK TABLES `user_pool` WRITE; /*!40000 ALTER TABLE `user_pool` DISABLE KEYS */; INSERT INTO `user_pool` VALUES (0,'oneadmin','000oneadminoneadmin1',0,0,1,0,0),(1,'serveradmin','100oneadminserveradmin1',1,0,1,0,0); /*!40000 ALTER TABLE `user_pool` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `user_quotas` -- DROP TABLE IF EXISTS `user_quotas`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `user_quotas` ( `user_oid` int(11) NOT NULL, `body` mediumtext, PRIMARY KEY (`user_oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `user_quotas` -- LOCK TABLES `user_quotas` WRITE; /*!40000 ALTER TABLE `user_quotas` DISABLE KEYS */; INSERT INTO `user_quotas` VALUES (0,'0'),(1,'1'); /*!40000 ALTER TABLE `user_quotas` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `vdc_pool` -- DROP TABLE IF EXISTS `vdc_pool`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vdc_pool` ( `oid` int(11) NOT NULL, `name` varchar(128) DEFAULT NULL, `body` mediumtext, `uid` int(11) DEFAULT NULL, `gid` int(11) DEFAULT NULL, `owner_u` int(11) DEFAULT NULL, `group_u` int(11) DEFAULT NULL, `other_u` int(11) DEFAULT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `vdc_pool` -- LOCK TABLES `vdc_pool` WRITE; /*!40000 ALTER TABLE `vdc_pool` DISABLE KEYS */; INSERT INTO `vdc_pool` VALUES (0,'default','0default10-10',0,0,1,0,0); /*!40000 ALTER TABLE `vdc_pool` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `vm_import` -- DROP TABLE IF EXISTS `vm_import`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vm_import` ( `deploy_id` varchar(128) NOT NULL, `vmid` int(11) DEFAULT NULL, PRIMARY KEY (`deploy_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `vm_import` -- LOCK TABLES `vm_import` WRITE; /*!40000 ALTER TABLE `vm_import` DISABLE KEYS */; /*!40000 ALTER TABLE `vm_import` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `vm_monitoring` -- DROP TABLE IF EXISTS `vm_monitoring`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vm_monitoring` ( `vmid` int(11) NOT NULL, `last_poll` int(11) NOT NULL, `body` mediumtext, PRIMARY KEY (`vmid`,`last_poll`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `vm_monitoring` -- LOCK TABLES `vm_monitoring` WRITE; /*!40000 ALTER TABLE `vm_monitoring` DISABLE KEYS */; /*!40000 ALTER TABLE `vm_monitoring` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `vm_pool` -- DROP TABLE IF EXISTS `vm_pool`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vm_pool` ( `oid` int(11) NOT NULL, `name` varchar(128) DEFAULT NULL, `body` mediumtext, `uid` int(11) DEFAULT NULL, `gid` int(11) DEFAULT NULL, `last_poll` int(11) DEFAULT NULL, `state` int(11) DEFAULT NULL, `lcm_state` int(11) DEFAULT NULL, `owner_u` int(11) DEFAULT NULL, `group_u` int(11) DEFAULT NULL, `other_u` int(11) DEFAULT NULL, PRIMARY KEY (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `vm_pool` -- LOCK TABLES `vm_pool` WRITE; /*!40000 ALTER TABLE `vm_pool` DISABLE KEYS */; /*!40000 ALTER TABLE `vm_pool` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `vm_showback` -- DROP TABLE IF EXISTS `vm_showback`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vm_showback` ( `vmid` int(11) NOT NULL, `year` int(11) NOT NULL, `month` int(11) NOT NULL, `body` mediumtext, PRIMARY KEY (`vmid`,`year`,`month`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `vm_showback` -- LOCK TABLES `vm_showback` WRITE; /*!40000 ALTER TABLE `vm_showback` DISABLE KEYS */; /*!40000 ALTER TABLE `vm_showback` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `vmgroup_pool` -- DROP TABLE IF EXISTS `vmgroup_pool`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vmgroup_pool` ( `oid` int(11) NOT NULL, `name` varchar(128) DEFAULT NULL, `body` mediumtext, `uid` int(11) DEFAULT NULL, `gid` int(11) DEFAULT NULL, `owner_u` int(11) DEFAULT NULL, `group_u` int(11) DEFAULT NULL, `other_u` int(11) DEFAULT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `name` (`name`,`uid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `vmgroup_pool` -- LOCK TABLES `vmgroup_pool` WRITE; /*!40000 ALTER TABLE `vmgroup_pool` DISABLE KEYS */; /*!40000 ALTER TABLE `vmgroup_pool` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `vrouter_pool` -- DROP TABLE IF EXISTS `vrouter_pool`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vrouter_pool` ( `oid` int(11) NOT NULL, `name` varchar(128) DEFAULT NULL, `body` mediumtext, `uid` int(11) DEFAULT NULL, `gid` int(11) DEFAULT NULL, `owner_u` int(11) DEFAULT NULL, `group_u` int(11) DEFAULT NULL, `other_u` int(11) DEFAULT NULL, PRIMARY KEY (`oid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `vrouter_pool` -- LOCK TABLES `vrouter_pool` WRITE; /*!40000 ALTER TABLE `vrouter_pool` DISABLE KEYS */; /*!40000 ALTER TABLE `vrouter_pool` ENABLE KEYS */; UNLOCK TABLES; -- -- Table structure for table `zone_pool` -- DROP TABLE IF EXISTS `zone_pool`; /*!40101 SET @saved_cs_client = @@character_set_client */; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `zone_pool` ( `oid` int(11) NOT NULL, `name` varchar(128) DEFAULT NULL, `body` mediumtext, `uid` int(11) DEFAULT NULL, `gid` int(11) DEFAULT NULL, `owner_u` int(11) DEFAULT NULL, `group_u` int(11) DEFAULT NULL, `other_u` int(11) DEFAULT NULL, PRIMARY KEY (`oid`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; /*!40101 SET character_set_client = @saved_cs_client */; -- -- Dumping data for table `zone_pool` -- LOCK TABLES `zone_pool` WRITE; /*!40000 ALTER TABLE `zone_pool` DISABLE KEYS */; INSERT INTO `zone_pool` VALUES (0,'OpenNebula','0OpenNebula',0,0,1,0,0); /*!40000 ALTER TABLE `zone_pool` ENABLE KEYS */; UNLOCK TABLES; /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; /*!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 */; -- Dump completed on 2018-01-22 16:18:50