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