Newer
Older
/**
* Copyright 2015 Telefónica Investigación y Desarrollo, S.A.U.
* This file is part of openmano
* All Rights Reserved.
*
* Licensed under the Apache License, Version 2.0 (the "License"); you may
* not use this file except in compliance with the License. You may obtain
* a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
* WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
* License for the specific language governing permissions and limitations
* under the License.
*
* For those usages not covered by the Apache License, Version 2.0 please
* contact with: nfvlabs@tid.es
**/

Alfonso Tierno
committed
-- MySQL dump 10.13 Distrib 5.5.43, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: mano_db
-- ------------------------------------------------------

Alfonso Tierno
committed
-- Server version 5.5.43-0ubuntu0.14.04.1
/*!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 */;
/*!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 `datacenter_nets`
--
DROP TABLE IF EXISTS `datacenter_nets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `datacenter_nets` (
`uuid` varchar(36) NOT NULL,

Alfonso Tierno
committed
`name` varchar(255) NOT NULL,
`vim_net_id` varchar(36) NOT NULL,
`datacenter_id` varchar(36) NOT NULL,
`type` enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
`multipoint` enum('true','false') NOT NULL DEFAULT 'true',
`shared` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'If can be shared with serveral scenarios',

Alfonso Tierno
committed
`description` varchar(255) DEFAULT NULL,
`created_at` double NOT NULL,
`modified_at` double DEFAULT NULL,
PRIMARY KEY (`uuid`),
UNIQUE KEY `name_datacenter_id` (`name`,`datacenter_id`),
KEY `FK_datacenter_nets_datacenters` (`datacenter_id`),
CONSTRAINT `FK_datacenter_nets_datacenters` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Contain the external nets of a datacenter';
/*!40101 SET character_set_client = @saved_cs_client */;

Alfonso Tierno
committed
--
-- Table structure for table `datacenter_tenants`
--
DROP TABLE IF EXISTS `datacenter_tenants`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `datacenter_tenants` (
`uuid` varchar(36) NOT NULL,
`datacenter_id` varchar(36) NOT NULL COMMENT 'Datacenter of this tenant',
`vim_tenant_name` varchar(64) DEFAULT NULL,
`vim_tenant_id` varchar(36) DEFAULT NULL COMMENT 'Tenant ID at VIM',
`created` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if this tenant has been created by openmano, or it existed on VIM',
`user` varchar(64) DEFAULT NULL,
`passwd` varchar(64) DEFAULT NULL,
`created_at` double NOT NULL,
`modified_at` double DEFAULT NULL,
PRIMARY KEY (`uuid`),
KEY `FK_vim_tenants_datacenters` (`datacenter_id`),
CONSTRAINT `FK_vim_tenants_datacenters` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Scenarios defined by the user';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `datacenters`
--
DROP TABLE IF EXISTS `datacenters`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `datacenters` (
`uuid` varchar(36) NOT NULL,

Alfonso Tierno
committed
`name` varchar(255) NOT NULL,
`description` varchar(255) DEFAULT NULL,
`type` varchar(36) NOT NULL DEFAULT 'openvim',
`vim_url` varchar(150) NOT NULL COMMENT 'URL of the VIM for the REST API',
`vim_url_admin` varchar(150) DEFAULT NULL,

Alfonso Tierno
committed
`config` varchar(4000) DEFAULT NULL COMMENT 'extra config information in json',
`created_at` double NOT NULL,
`modified_at` double DEFAULT NULL,
PRIMARY KEY (`uuid`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Datacenters managed by the NFVO.';
/*!40101 SET character_set_client = @saved_cs_client */;

Alfonso Tierno
committed
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
--
-- Table structure for table `datacenters_flavors`
--
DROP TABLE IF EXISTS `datacenters_flavors`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `datacenters_flavors` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`flavor_id` varchar(36) NOT NULL,
`datacenter_id` varchar(36) NOT NULL,
`vim_id` varchar(36) NOT NULL,
`created` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if it has been created by openmano, or already existed',
PRIMARY KEY (`id`),
KEY `FK__flavors` (`flavor_id`),
KEY `FK__datacenters_f` (`datacenter_id`),
CONSTRAINT `FK__datacenters_f` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK__flavors` FOREIGN KEY (`flavor_id`) REFERENCES `flavors` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `datacenters_images`
--
DROP TABLE IF EXISTS `datacenters_images`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `datacenters_images` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`image_id` varchar(36) NOT NULL,
`datacenter_id` varchar(36) NOT NULL,
`vim_id` varchar(36) NOT NULL,
`created` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if it has been created by openmano, or already existed',
PRIMARY KEY (`id`),
KEY `FK__images` (`image_id`),
KEY `FK__datacenters_i` (`datacenter_id`),
CONSTRAINT `FK__datacenters_i` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK__images` FOREIGN KEY (`image_id`) REFERENCES `images` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `flavors`
--
DROP TABLE IF EXISTS `flavors`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `flavors` (
`uuid` varchar(36) NOT NULL,
`name` varchar(255) NOT NULL,
`description` varchar(255) DEFAULT NULL,
`disk` smallint(5) unsigned DEFAULT NULL,
`ram` smallint(5) unsigned DEFAULT NULL,
`vcpus` smallint(5) unsigned DEFAULT NULL,
`extended` varchar(2000) DEFAULT NULL COMMENT 'Extra description json format of needed resources and pining, orginized in sets per numa',
PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `images`
--
DROP TABLE IF EXISTS `images`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `images` (
`uuid` varchar(36) NOT NULL,
`name` varchar(255) NOT NULL,
`location` varchar(200) NOT NULL,
`description` varchar(255) DEFAULT NULL,
`metadata` varchar(2000) DEFAULT NULL,
PRIMARY KEY (`uuid`),
UNIQUE KEY `location` (`location`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `instance_interfaces`
--
DROP TABLE IF EXISTS `instance_interfaces`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `instance_interfaces` (
`uuid` varchar(36) NOT NULL,
`instance_vm_id` varchar(36) NOT NULL,
`instance_net_id` varchar(36) NOT NULL,
`interface_id` varchar(36) NOT NULL,

Alfonso Tierno
committed
`vim_interface_id` varchar(36) DEFAULT NULL COMMENT 'vim identity for that interface',
`mac_address` varchar(32) DEFAULT NULL,
`ip_address` varchar(64) DEFAULT NULL,
`vim_info` text,
`type` enum('internal','external') NOT NULL COMMENT 'Indicates if this interface is external to a vnf, or internal',
PRIMARY KEY (`uuid`),
KEY `FK_instance_vms` (`instance_vm_id`),
KEY `FK_instance_nets` (`instance_net_id`),
KEY `FK_instance_ids` (`interface_id`),
CONSTRAINT `FK_instance_ids` FOREIGN KEY (`interface_id`) REFERENCES `interfaces` (`uuid`),
CONSTRAINT `FK_instance_nets` FOREIGN KEY (`instance_net_id`) REFERENCES `instance_nets` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_instance_vms` FOREIGN KEY (`instance_vm_id`) REFERENCES `instance_vms` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Table with all running associattion among VM instances and net instances';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `instance_nets`
--
DROP TABLE IF EXISTS `instance_nets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `instance_nets` (
`uuid` varchar(36) NOT NULL,
`vim_net_id` varchar(36) NOT NULL COMMENT 'Network ID in the VIM DB',
`instance_scenario_id` varchar(36) NOT NULL,

Alfonso Tierno
committed
`sce_net_id` varchar(36) DEFAULT NULL,
`net_id` varchar(36) DEFAULT NULL,
`datacenter_id` varchar(36) DEFAULT NULL,
`datacenter_tenant_id` varchar(36) NOT NULL,
`status` enum('ACTIVE','DOWN','BUILD','ERROR','VIM_ERROR','INACTIVE','DELETED') NOT NULL DEFAULT 'BUILD',
`error_msg` varchar(1024) DEFAULT NULL,
`vim_info` text,
`multipoint` enum('true','false') NOT NULL DEFAULT 'true',
`external` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'If external, means that it already exists at VIM',

Alfonso Tierno
committed
`created_at` double NOT NULL,
`modified_at` double DEFAULT NULL,
PRIMARY KEY (`uuid`),
UNIQUE KEY `vim_net_id_instance_scenario_id` (`vim_net_id`,`instance_scenario_id`),
KEY `FK_instance_nets_instance_scenarios` (`instance_scenario_id`),

Alfonso Tierno
committed
KEY `FK_instance_nets_sce_nets` (`sce_net_id`),
KEY `FK_instance_nets_nets` (`net_id`),
KEY `FK_instance_nets_datacenters` (`datacenter_id`),
KEY `FK_instance_nets_datacenter_tenants` (`datacenter_tenant_id`),
CONSTRAINT `FK_instance_nets_datacenter_tenants` FOREIGN KEY (`datacenter_tenant_id`) REFERENCES `datacenter_tenants` (`uuid`),
CONSTRAINT `FK_instance_nets_datacenters` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`),
CONSTRAINT `FK_instance_nets_instance_scenarios` FOREIGN KEY (`instance_scenario_id`) REFERENCES `instance_scenarios` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_instance_nets_nets` FOREIGN KEY (`net_id`) REFERENCES `nets` (`uuid`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `FK_instance_nets_sce_nets` FOREIGN KEY (`sce_net_id`) REFERENCES `sce_nets` (`uuid`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Instances of networks';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `instance_scenarios`
--
DROP TABLE IF EXISTS `instance_scenarios`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `instance_scenarios` (
`uuid` varchar(36) NOT NULL,

Alfonso Tierno
committed
`name` varchar(255) NOT NULL,
`tenant_id` varchar(36) DEFAULT NULL,
`scenario_id` varchar(36) NOT NULL,
`datacenter_id` varchar(36) NOT NULL,

Alfonso Tierno
committed
`datacenter_tenant_id` varchar(36) NOT NULL,
`description` varchar(255) DEFAULT NULL,
`created_at` double NOT NULL,
`modified_at` double DEFAULT NULL,
PRIMARY KEY (`uuid`),
UNIQUE KEY `name` (`name`),

Alfonso Tierno
committed
KEY `FK_scenarios_nfvo_tenants` (`tenant_id`),
KEY `FK_instance_scenarios_vim_tenants` (`datacenter_tenant_id`),
KEY `FK_instance_scenarios_datacenters` (`datacenter_id`),
KEY `FK_instance_scenarios_scenarios` (`scenario_id`),

Alfonso Tierno
committed
CONSTRAINT `FK_instance_scenarios_datacenter_tenants` FOREIGN KEY (`datacenter_tenant_id`) REFERENCES `datacenter_tenants` (`uuid`),
CONSTRAINT `FK_instance_scenarios_datacenters` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`),

Alfonso Tierno
committed
CONSTRAINT `FK_instance_scenarios_nfvo_tenants` FOREIGN KEY (`tenant_id`) REFERENCES `nfvo_tenants` (`uuid`),
CONSTRAINT `FK_instance_scenarios_scenarios` FOREIGN KEY (`scenario_id`) REFERENCES `scenarios` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Instances of scenarios defined by the user';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `instance_vms`
--
DROP TABLE IF EXISTS `instance_vms`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `instance_vms` (
`uuid` varchar(36) NOT NULL,
`instance_vnf_id` varchar(36) NOT NULL,
`vm_id` varchar(36) NOT NULL,
`vim_vm_id` varchar(36) NOT NULL COMMENT 'VM ID in the VIM DB',

Alfonso Tierno
committed
`status` enum('ACTIVE:NoMgmtIP','ACTIVE','INACTIVE','BUILD','ERROR','VIM_ERROR','PAUSED','SUSPENDED','DELETED') NOT NULL DEFAULT 'BUILD',
`error_msg` varchar(1024) DEFAULT NULL,
`vim_info` text,
`created_at` double NOT NULL,
`modified_at` double DEFAULT NULL,
PRIMARY KEY (`uuid`),
UNIQUE KEY `vim_vm_id` (`vim_vm_id`),
KEY `FK_instance_vms_vms` (`vm_id`),
KEY `FK_instance_vms_instance_vnfs` (`instance_vnf_id`),
CONSTRAINT `FK_instance_vms_instance_vnfs` FOREIGN KEY (`instance_vnf_id`) REFERENCES `instance_vnfs` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_instance_vms_vms` FOREIGN KEY (`vm_id`) REFERENCES `vms` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Instances of VMs as part of VNF instances';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `instance_vnfs`
--
DROP TABLE IF EXISTS `instance_vnfs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `instance_vnfs` (
`uuid` varchar(36) NOT NULL,
`instance_scenario_id` varchar(36) NOT NULL,
`vnf_id` varchar(36) NOT NULL,

Alfonso Tierno
committed
`sce_vnf_id` varchar(36) DEFAULT NULL,
`datacenter_id` varchar(36) DEFAULT NULL,
`datacenter_tenant_id` varchar(36) DEFAULT NULL,
`created_at` double NOT NULL,
`modified_at` double DEFAULT NULL,
PRIMARY KEY (`uuid`),
KEY `FK_instance_vnfs_vnfs` (`vnf_id`),
KEY `FK_instance_vnfs_instance_scenarios` (`instance_scenario_id`),

Alfonso Tierno
committed
KEY `FK_instance_vnfs_sce_vnfs` (`sce_vnf_id`),
KEY `FK_instance_vnfs_datacenters` (`datacenter_id`),
KEY `FK_instance_vnfs_datacenter_tenants` (`datacenter_tenant_id`),
CONSTRAINT `FK_instance_vnfs_datacenter_tenants` FOREIGN KEY (`datacenter_tenant_id`) REFERENCES `datacenter_tenants` (`uuid`),
CONSTRAINT `FK_instance_vnfs_datacenters` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`),
CONSTRAINT `FK_instance_vnfs_instance_scenarios` FOREIGN KEY (`instance_scenario_id`) REFERENCES `instance_scenarios` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE,

Alfonso Tierno
committed
CONSTRAINT `FK_instance_vnfs_sce_vnfs` FOREIGN KEY (`sce_vnf_id`) REFERENCES `sce_vnfs` (`uuid`) ON DELETE SET NULL ON UPDATE CASCADE,
CONSTRAINT `FK_instance_vnfs_vnfs` FOREIGN KEY (`vnf_id`) REFERENCES `vnfs` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Instances of VNFs as part of a scenario';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `interfaces`
--
DROP TABLE IF EXISTS `interfaces`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `interfaces` (
`uuid` varchar(36) NOT NULL,

Alfonso Tierno
committed
`internal_name` varchar(255) NOT NULL,
`external_name` varchar(255) DEFAULT NULL,
`vm_id` varchar(36) NOT NULL,
`net_id` varchar(36) DEFAULT NULL,
`type` enum('mgmt','bridge','data') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
`vpci` char(12) DEFAULT NULL,
`bw` mediumint(8) unsigned DEFAULT NULL COMMENT 'BW expressed in Mbits/s. Maybe this field is not necessary.',

Alfonso Tierno
committed
`created_at` double NOT NULL,
`modified_at` double DEFAULT NULL,

Alfonso Tierno
committed
`mac` char(18) DEFAULT NULL,
PRIMARY KEY (`uuid`),
UNIQUE KEY `internal_name_vm_id` (`internal_name`,`vm_id`),
KEY `FK_interfaces_vms` (`vm_id`),
KEY `FK_interfaces_nets` (`net_id`),
CONSTRAINT `FK_interfaces_nets` FOREIGN KEY (`net_id`) REFERENCES `nets` (`uuid`) ON DELETE CASCADE,
CONSTRAINT `FK_interfaces_vms` FOREIGN KEY (`vm_id`) REFERENCES `vms` (`uuid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='VM interfaces';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `logs`
--
DROP TABLE IF EXISTS `logs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `logs` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
`nfvo_tenant_id` varchar(36) DEFAULT NULL,

Alfonso Tierno
committed
`related` varchar(36) NOT NULL COMMENT 'Relevant element for the log',
`uuid` varchar(36) DEFAULT NULL COMMENT 'Uuid of vnf, scenario, etc. that log relates to',
`level` enum('panic','error','info','debug','verbose') NOT NULL,
`description` varchar(200) NOT NULL,
PRIMARY KEY (`id`)

Alfonso Tierno
committed
) ENGINE=InnoDB AUTO_INCREMENT=3423 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `nets`
--
DROP TABLE IF EXISTS `nets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nets` (
`uuid` varchar(36) NOT NULL,
`vnf_id` varchar(36) NOT NULL,

Alfonso Tierno
committed
`name` varchar(255) NOT NULL,
`type` enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
`multipoint` enum('true','false') NOT NULL DEFAULT 'false',

Alfonso Tierno
committed
`description` varchar(255) DEFAULT NULL,
`created_at` double NOT NULL,
`modified_at` double DEFAULT NULL,
PRIMARY KEY (`uuid`),
UNIQUE KEY `vnf_id_name` (`vnf_id`,`name`),
CONSTRAINT `FK_nets_vnfs` FOREIGN KEY (`vnf_id`) REFERENCES `vnfs` (`uuid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Networks in a VNF definition. These are only the internal networks among VMs of the same VNF.';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `nfvo_tenants`
--
DROP TABLE IF EXISTS `nfvo_tenants`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nfvo_tenants` (
`uuid` varchar(36) NOT NULL,

Alfonso Tierno
committed
`name` varchar(255) NOT NULL,
`description` varchar(255) DEFAULT NULL,
`created_at` double NOT NULL,
`modified_at` double DEFAULT NULL,
PRIMARY KEY (`uuid`),
UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Scenarios defined by the user';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sce_interfaces`
--
DROP TABLE IF EXISTS `sce_interfaces`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sce_interfaces` (
`uuid` varchar(36) NOT NULL,
`sce_vnf_id` varchar(36) NOT NULL,
`sce_net_id` varchar(36) DEFAULT NULL,
`interface_id` varchar(36) DEFAULT NULL,

Alfonso Tierno
committed
`created_at` double NOT NULL,
`modified_at` double DEFAULT NULL,
PRIMARY KEY (`uuid`),
KEY `FK_sce_interfaces_sce_vnfs` (`sce_vnf_id`),
KEY `FK_sce_interfaces_sce_nets` (`sce_net_id`),
KEY `FK_sce_interfaces_interfaces` (`interface_id`),
CONSTRAINT `FK_sce_interfaces_interfaces` FOREIGN KEY (`interface_id`) REFERENCES `interfaces` (`uuid`),
CONSTRAINT `FK_sce_interfaces_sce_nets` FOREIGN KEY (`sce_net_id`) REFERENCES `sce_nets` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_sce_interfaces_sce_vnfs` FOREIGN KEY (`sce_vnf_id`) REFERENCES `sce_vnfs` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='VNF interfaces in a scenario definition.';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sce_nets`
--
DROP TABLE IF EXISTS `sce_nets`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sce_nets` (
`uuid` varchar(36) NOT NULL,

Alfonso Tierno
committed
`name` varchar(255) NOT NULL,
`scenario_id` varchar(36) DEFAULT NULL COMMENT 'NULL if net is matched to several scenarios',
`type` enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
`multipoint` enum('true','false') NOT NULL DEFAULT 'true',
`external` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'If external, net is already present at VIM',

Alfonso Tierno
committed
`description` varchar(255) DEFAULT NULL,
`created_at` double NOT NULL,
`modified_at` double DEFAULT NULL,
`graph` varchar(2000) DEFAULT NULL,
PRIMARY KEY (`uuid`),
KEY `FK_sce_nets_scenarios` (`scenario_id`),
CONSTRAINT `FK_sce_nets_scenarios` FOREIGN KEY (`scenario_id`) REFERENCES `scenarios` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Networks in a scenario definition. It only considers networks among VNFs. Networks among internal VMs are only considered in tble ''nets''.';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `sce_vnfs`
--
DROP TABLE IF EXISTS `sce_vnfs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sce_vnfs` (
`uuid` varchar(36) NOT NULL,

Alfonso Tierno
committed
`name` varchar(255) NOT NULL,
`scenario_id` varchar(36) NOT NULL,
`vnf_id` varchar(36) NOT NULL,

Alfonso Tierno
committed
`description` varchar(255) DEFAULT NULL,
`created_at` double NOT NULL,
`modified_at` double DEFAULT NULL,
`graph` varchar(2000) DEFAULT NULL,
PRIMARY KEY (`uuid`),
UNIQUE KEY `name_scenario_id` (`name`,`scenario_id`),
KEY `FK_sce_vnfs_scenarios` (`scenario_id`),
KEY `FK_sce_vnfs_vnfs` (`vnf_id`),
CONSTRAINT `FK_sce_vnfs_scenarios` FOREIGN KEY (`scenario_id`) REFERENCES `scenarios` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE,
CONSTRAINT `FK_sce_vnfs_vnfs` FOREIGN KEY (`vnf_id`) REFERENCES `vnfs` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='VNFs in scenario definitions. This table also contains the Physical Network Functions and the external elements such as MAN, Core, etc.\r\n';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `scenarios`
--
DROP TABLE IF EXISTS `scenarios`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scenarios` (
`uuid` varchar(36) NOT NULL,

Alfonso Tierno
committed
`name` varchar(255) NOT NULL,
`tenant_id` varchar(36) DEFAULT NULL,
`description` varchar(255) DEFAULT NULL,
`public` enum('true','false') NOT NULL DEFAULT 'false',

Alfonso Tierno
committed
`created_at` double NOT NULL,
`modified_at` double DEFAULT NULL,
`descriptor` text COMMENT 'Original text descriptor used for create the scenario',
PRIMARY KEY (`uuid`),
UNIQUE KEY `name` (`name`),

Alfonso Tierno
committed
KEY `FK_scenarios_nfvo_tenants` (`tenant_id`),
CONSTRAINT `FK_scenarios_nfvo_tenants` FOREIGN KEY (`tenant_id`) REFERENCES `nfvo_tenants` (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Scenarios defined by the user';
/*!40101 SET character_set_client = @saved_cs_client */;

Alfonso Tierno
committed
--
-- Table structure for table `schema_version`
--
DROP TABLE IF EXISTS `schema_version`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `schema_version` (
`version_int` int(11) NOT NULL COMMENT 'version as a number. Must not contain gaps',
`version` varchar(20) NOT NULL COMMENT 'version as a text',
`openmano_ver` varchar(20) NOT NULL COMMENT 'openmano version',
`comments` varchar(2000) DEFAULT NULL COMMENT 'changes to database',
`date` date DEFAULT NULL,
PRIMARY KEY (`version_int`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='database schema control version';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `tenants_datacenters`
--
DROP TABLE IF EXISTS `tenants_datacenters`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `tenants_datacenters` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`nfvo_tenant_id` varchar(36) NOT NULL,
`datacenter_id` varchar(36) NOT NULL,

Alfonso Tierno
committed
`datacenter_tenant_id` varchar(36) NOT NULL,
`created_at` double NOT NULL,
`modified_at` double DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `datacenter_nfvo_tenant` (`datacenter_id`,`nfvo_tenant_id`),
KEY `FK_nfvo_tenants_datacenters` (`datacenter_id`),

Alfonso Tierno
committed
KEY `FK_nfvo_tenants_vim_tenants` (`datacenter_tenant_id`),
KEY `FK_tenants_datacenters_nfvo_tenants` (`nfvo_tenant_id`),

Alfonso Tierno
committed
CONSTRAINT `FK_tenants_datacenters_datacenter_tenants` FOREIGN KEY (`datacenter_tenant_id`) REFERENCES `datacenter_tenants` (`uuid`),
CONSTRAINT `FK_tenants_datacenters_datacenters` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`),

Alfonso Tierno
committed
CONSTRAINT `FK_tenants_datacenters_nfvo_tenants` FOREIGN KEY (`nfvo_tenant_id`) REFERENCES `nfvo_tenants` (`uuid`)
) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Scenarios defined by the user';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `uuids`
--
DROP TABLE IF EXISTS `uuids`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `uuids` (
`uuid` varchar(36) NOT NULL,
`root_uuid` varchar(36) DEFAULT NULL COMMENT 'Some related UUIDs can be grouped by this field, so that they can be deleted at once',

Alfonso Tierno
committed
`created_at` double NOT NULL,
`used_at` varchar(36) DEFAULT NULL COMMENT 'Table that uses this UUID',
PRIMARY KEY (`uuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table with all unique IDs used to avoid UUID repetitions among different elements';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `vms`
--
DROP TABLE IF EXISTS `vms`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vms` (
`uuid` varchar(36) NOT NULL,

Alfonso Tierno
committed
`name` varchar(255) NOT NULL,

Alfonso Tierno
committed
`flavor_id` varchar(36) NOT NULL COMMENT 'Link to flavor table',
`image_id` varchar(36) NOT NULL COMMENT 'Link to image table',
`image_path` varchar(100) NOT NULL COMMENT 'Path where the image of the VM is located',

Alfonso Tierno
committed
`description` varchar(255) DEFAULT NULL,
`created_at` double NOT NULL,
`modified_at` double DEFAULT NULL,
PRIMARY KEY (`uuid`),
UNIQUE KEY `name_vnf_id` (`name`,`vnf_id`),
KEY `FK_vms_vnfs` (`vnf_id`),

Alfonso Tierno
committed
KEY `FK_vms_images` (`image_id`),
KEY `FK_vms_flavors` (`flavor_id`),
CONSTRAINT `FK_vms_flavors` FOREIGN KEY (`flavor_id`) REFERENCES `flavors` (`uuid`),
CONSTRAINT `FK_vms_images` FOREIGN KEY (`image_id`) REFERENCES `images` (`uuid`),
CONSTRAINT `FK_vms_vnfs` FOREIGN KEY (`vnf_id`) REFERENCES `vnfs` (`uuid`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='VM definitions. It contains the set of VMs used by the VNF definitions.';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Table structure for table `vnfs`
--
DROP TABLE IF EXISTS `vnfs`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `vnfs` (
`uuid` varchar(36) NOT NULL,

Alfonso Tierno
committed
`name` varchar(255) NOT NULL,
`tenant_id` varchar(36) DEFAULT NULL,
`physical` enum('true','false') NOT NULL DEFAULT 'false',

Alfonso Tierno
committed
`public` enum('true','false') NOT NULL DEFAULT 'false',
`description` varchar(255) DEFAULT NULL,
`created_at` double NOT NULL,
`modified_at` double DEFAULT NULL,

Alfonso Tierno
committed
`descriptor` text COMMENT 'Original text descriptor used for create the VNF',

Alfonso Tierno
committed
KEY `FK_vnfs_nfvo_tenants` (`tenant_id`),
CONSTRAINT `FK_vnfs_nfvo_tenants` FOREIGN KEY (`tenant_id`) REFERENCES `nfvo_tenants` (`uuid`) ON DELETE SET NULL ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='VNF definitions. This is the catalogue of VNFs. It also includes Physical Network Functions or Physical Elements.\r\n';
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping routines for database 'mano_db'
--
/*!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 */;

Alfonso Tierno
committed
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
-- Dump completed on 2016-05-13 12:23:52
-- MySQL dump 10.13 Distrib 5.5.43, for debian-linux-gnu (x86_64)
--
-- Host: localhost Database: mano_db
-- ------------------------------------------------------
-- Server version 5.5.43-0ubuntu0.14.04.1
/*!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 */;
/*!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 */;
--
-- Dumping data for table `schema_version`
--
LOCK TABLES `schema_version` WRITE;
/*!40000 ALTER TABLE `schema_version` DISABLE KEYS */;
INSERT INTO `schema_version` VALUES (1,'0.1','0.2.2','insert schema_version','2015-05-08'),(2,'0.2','0.2.5','new tables images,flavors','2015-07-13'),(3,'0.3','0.3.3','alter vim_tenant tables','2015-07-28'),(4,'0.4','0.3.5','enlarge graph field at sce_vnfs/nets','2015-10-20'),(5,'0.5','0.4.1','Add mac address for bridge interfaces','2015-12-14'),(6,'0.6','0.4.2','Adding VIM status info','2015-12-22'),(7,'0.7','0.4.3','Changing created_at time at database','2016-01-25'),(8,'0.8','0.4.32','Enlarging name at database','2016-02-01'),(9,'0.9','0.4.33','Add ACTIVE:NoMgmtIP to instance_vms table','2016-02-05'),(10,'0.10','0.4.36','tenant management of vnfs,scenarios','2016-03-08');
/*!40000 ALTER TABLE `schema_version` 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 2016-05-13 12:23:52