2 * Copyright 2017 Telefónica Investigación y Desarrollo, S.A.U.
3 * This file is part of openmano
6 * Licensed under the Apache License, Version 2.0 (the "License"); you may
7 * not use this file except in compliance with the License. You may obtain
8 * a copy of the License at
10 * http://www.apache.org/licenses/LICENSE-2.0
12 * Unless required by applicable law or agreed to in writing, software
13 * distributed under the License is distributed on an "AS IS" BASIS, WITHOUT
14 * WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the
15 * License for the specific language governing permissions and limitations
18 * For those usages not covered by the Apache License, Version 2.0 please
19 * contact with: nfvlabs@tid.es
22 -- MySQL dump 10.13 Distrib 5.7.20, for Linux (x86_64)
24 -- Host: localhost Database: {{mano_db}}
25 -- ------------------------------------------------------
26 -- Server version 5.7.20-0ubuntu0.16.04.1
28 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
29 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
30 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
31 /*!40101 SET NAMES utf8 */;
32 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
33 /*!40103 SET TIME_ZONE='+00:00' */;
34 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
35 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
36 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
37 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
40 -- Current Database: `{{mano_db}}`
43 /*!40000 DROP DATABASE IF EXISTS `{{mano_db}}`*/;
45 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `
{{mano_db
}}`
/*!40100 DEFAULT CHARACTER SET latin1 */;
50 -- Table structure for table `datacenter_nets`
53 DROP TABLE IF EXISTS `datacenter_nets`
;
54 /*!40101 SET @saved_cs_client = @@character_set_client */;
55 /*!40101 SET character_set_client = utf8 */;
56 CREATE TABLE `datacenter_nets`
(
57 `uuid`
varchar(36) NOT NULL,
58 `
name`
varchar(255) NOT NULL,
59 `vim_net_id`
varchar(36) NOT NULL,
60 `datacenter_id`
varchar(36) NOT NULL,
61 `
type`
enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
62 `multipoint`
enum('true','false') NOT NULL DEFAULT 'true',
63 `shared`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'If can be shared with serveral scenarios',
64 `description`
varchar(255) DEFAULT NULL,
65 `created_at`
double NOT NULL,
66 `modified_at`
double DEFAULT NULL,
68 UNIQUE KEY `name_datacenter_id`
(`
name`
,`datacenter_id`
),
69 KEY `FK_datacenter_nets_datacenters`
(`datacenter_id`
),
70 CONSTRAINT `FK_datacenter_nets_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
71 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
COMMENT='Contain the external nets of a datacenter';
72 /*!40101 SET character_set_client = @saved_cs_client */;
75 -- Table structure for table `datacenter_tenants`
78 DROP TABLE IF EXISTS `datacenter_tenants`
;
79 /*!40101 SET @saved_cs_client = @@character_set_client */;
80 /*!40101 SET character_set_client = utf8 */;
81 CREATE TABLE `datacenter_tenants`
(
82 `uuid`
varchar(36) NOT NULL,
83 `
name`
varchar(255) DEFAULT NULL,
84 `datacenter_id`
varchar(36) NOT NULL COMMENT 'Datacenter of this tenant',
85 `vim_tenant_name`
varchar(256) DEFAULT NULL,
86 `vim_tenant_id`
varchar(256) DEFAULT NULL COMMENT 'Tenant ID at VIM',
87 `created`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if this tenant has been created by openmano, or it existed on VIM',
88 `
user`
varchar(64) DEFAULT NULL,
89 `passwd`
varchar(64) DEFAULT NULL,
90 `config`
varchar(4000) DEFAULT NULL,
91 `created_at`
double NOT NULL,
92 `modified_at`
double DEFAULT NULL,
94 KEY `FK_vim_tenants_datacenters`
(`datacenter_id`
),
95 CONSTRAINT `FK_vim_tenants_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
96 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Scenarios defined by the user';
97 /*!40101 SET character_set_client = @saved_cs_client */;
100 -- Table structure for table `datacenters`
103 DROP TABLE IF EXISTS `datacenters`
;
104 /*!40101 SET @saved_cs_client = @@character_set_client */;
105 /*!40101 SET character_set_client = utf8 */;
106 CREATE TABLE `datacenters`
(
107 `uuid`
varchar(36) NOT NULL,
108 `
name`
varchar(255) NOT NULL,
109 `description`
varchar(255) DEFAULT NULL,
110 `
type`
varchar(36) NOT NULL DEFAULT 'openvim',
111 `vim_url`
varchar(150) NOT NULL COMMENT 'URL of the VIM for the REST API',
112 `vim_url_admin`
varchar(150) DEFAULT NULL,
113 `config`
varchar(4000) DEFAULT NULL COMMENT 'extra config information in json',
114 `created_at`
double NOT NULL,
115 `modified_at`
double DEFAULT NULL,
116 PRIMARY KEY (`uuid`
),
117 UNIQUE KEY `
name`
(`
name`
)
118 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Datacenters managed by the NFVO.';
119 /*!40101 SET character_set_client = @saved_cs_client */;
122 -- Table structure for table `datacenters_flavors`
125 DROP TABLE IF EXISTS `datacenters_flavors`
;
126 /*!40101 SET @saved_cs_client = @@character_set_client */;
127 /*!40101 SET character_set_client = utf8 */;
128 CREATE TABLE `datacenters_flavors`
(
129 `
id`
int(11) NOT NULL AUTO_INCREMENT
,
130 `flavor_id`
varchar(36) NOT NULL,
131 `datacenter_vim_id`
varchar(36) NOT NULL,
132 `vim_id`
varchar(36) NOT NULL,
133 `status`
enum('ACTIVE','INACTIVE','BUILD','ERROR','VIM_ERROR','DELETED','SCHEDULED_CREATION','SCHEDULED_DELETION') NOT NULL DEFAULT 'BUILD',
135 `created`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if it has been created by openmano, or already existed',
136 `extended`
varchar(2000) DEFAULT NULL COMMENT 'Extra description json format of additional devices',
138 KEY `FK__flavors`
(`flavor_id`
),
139 KEY `FK_datacenters_flavors_datacenter_tenants`
(`datacenter_vim_id`
),
140 CONSTRAINT `FK__flavors`
FOREIGN KEY (`flavor_id`
) REFERENCES `flavors`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
141 CONSTRAINT `FK_datacenters_flavors_datacenter_tenants`
FOREIGN KEY (`datacenter_vim_id`
) REFERENCES `datacenter_tenants`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
142 ) ENGINE
=InnoDB AUTO_INCREMENT
=7 DEFAULT CHARSET
=utf8
;
143 /*!40101 SET character_set_client = @saved_cs_client */;
146 -- Table structure for table `datacenters_images`
149 DROP TABLE IF EXISTS `datacenters_images`
;
150 /*!40101 SET @saved_cs_client = @@character_set_client */;
151 /*!40101 SET character_set_client = utf8 */;
152 CREATE TABLE `datacenters_images`
(
153 `
id`
int(11) NOT NULL AUTO_INCREMENT
,
154 `image_id`
varchar(36) NOT NULL,
155 `datacenter_vim_id`
varchar(36) NOT NULL,
156 `vim_id`
varchar(36) NOT NULL,
157 `status`
enum('ACTIVE','INACTIVE','BUILD','ERROR','VIM_ERROR','DELETED','SCHEDULED_CREATION','SCHEDULED_DELETION') NOT NULL DEFAULT 'BUILD',
159 `created`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if it has been created by openmano, or already existed',
161 KEY `FK__images`
(`image_id`
),
162 KEY `FK_datacenters_images_datacenter_tenants`
(`datacenter_vim_id`
),
163 CONSTRAINT `FK__images`
FOREIGN KEY (`image_id`
) REFERENCES `images`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
164 CONSTRAINT `FK_datacenters_images_datacenter_tenants`
FOREIGN KEY (`datacenter_vim_id`
) REFERENCES `datacenter_tenants`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
165 ) ENGINE
=InnoDB AUTO_INCREMENT
=6 DEFAULT CHARSET
=utf8
;
166 /*!40101 SET character_set_client = @saved_cs_client */;
169 -- Table structure for table `flavors`
172 DROP TABLE IF EXISTS `flavors`
;
173 /*!40101 SET @saved_cs_client = @@character_set_client */;
174 /*!40101 SET character_set_client = utf8 */;
175 CREATE TABLE `flavors`
(
176 `uuid`
varchar(36) NOT NULL,
177 `
name`
varchar(255) NOT NULL,
178 `description`
varchar(255) DEFAULT NULL,
179 `disk`
smallint(5) unsigned
DEFAULT NULL,
180 `ram`
mediumint(7) unsigned
DEFAULT NULL,
181 `vcpus`
smallint(5) unsigned
DEFAULT NULL,
182 `extended`
varchar(2000) DEFAULT NULL COMMENT 'Extra description json format of needed resources and pining, orginized in sets per numa',
184 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
;
185 /*!40101 SET character_set_client = @saved_cs_client */;
188 -- Table structure for table `images`
191 DROP TABLE IF EXISTS `images`
;
192 /*!40101 SET @saved_cs_client = @@character_set_client */;
193 /*!40101 SET character_set_client = utf8 */;
194 CREATE TABLE `images`
(
195 `uuid`
varchar(36) NOT NULL,
196 `
name`
varchar(255) NOT NULL,
197 `universal_name`
varchar(255) DEFAULT NULL,
198 `checksum`
varchar(32) DEFAULT NULL,
199 `
location`
varchar(200) DEFAULT NULL,
200 `description`
varchar(255) DEFAULT NULL,
201 `metadata`
varchar(2000) DEFAULT NULL,
202 PRIMARY KEY (`uuid`
),
203 UNIQUE KEY `
location`
(`
location`
),
204 UNIQUE KEY `universal_name_checksum`
(`universal_name`
,`checksum`
)
205 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
;
206 /*!40101 SET character_set_client = @saved_cs_client */;
209 -- Table structure for table `instance_actions`
212 DROP TABLE IF EXISTS `instance_actions`
;
213 /*!40101 SET @saved_cs_client = @@character_set_client */;
214 /*!40101 SET character_set_client = utf8 */;
215 CREATE TABLE `instance_actions`
(
216 `uuid`
varchar(36) NOT NULL,
217 `tenant_id`
varchar(36) DEFAULT NULL,
218 `instance_id`
varchar(36) DEFAULT NULL,
219 `description`
varchar(64) DEFAULT NULL COMMENT 'CREATE, DELETE, SCALE OUT/IN, ...',
220 `number_tasks`
smallint(6) NOT NULL DEFAULT '1',
221 `number_done`
smallint(6) NOT NULL DEFAULT '0',
222 `number_failed`
smallint(6) NOT NULL DEFAULT '0',
223 `created_at`
double NOT NULL,
224 `modified_at`
double DEFAULT NULL,
225 PRIMARY KEY (`uuid`
),
226 KEY `FK_actions_tenants`
(`tenant_id`
),
227 CONSTRAINT `FK_actions_tenant`
FOREIGN KEY (`tenant_id`
) REFERENCES `nfvo_tenants`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
228 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
COMMENT='Contains client actions over instances';
229 /*!40101 SET character_set_client = @saved_cs_client */;
232 -- Table structure for table `instance_interfaces`
235 DROP TABLE IF EXISTS `instance_interfaces`
;
236 /*!40101 SET @saved_cs_client = @@character_set_client */;
237 /*!40101 SET character_set_client = utf8 */;
238 CREATE TABLE `instance_interfaces`
(
239 `uuid`
varchar(36) NOT NULL,
240 `instance_vm_id`
varchar(36) NOT NULL,
241 `instance_net_id`
varchar(36) NOT NULL,
242 `interface_id`
varchar(36) DEFAULT NULL,
243 `vim_interface_id`
varchar(128) DEFAULT NULL,
244 `mac_address`
varchar(32) DEFAULT NULL,
245 `ip_address`
varchar(64) DEFAULT NULL,
247 `
type`
enum('internal','external') NOT NULL COMMENT 'Indicates if this interface is external to a vnf, or internal',
248 `floating_ip`
tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates if a floating_ip must be associated to this interface',
249 `port_security`
tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Indicates if port security must be enabled or disabled. By default it is enabled',
250 `sdn_port_id`
varchar(36) DEFAULT NULL COMMENT 'Port id in ovim',
251 `compute_node`
varchar(100) DEFAULT NULL COMMENT 'Compute node id used to specify the SDN port mapping',
252 `pci`
varchar(50) DEFAULT NULL COMMENT 'PCI of the physical port in the host',
253 `vlan`
smallint(5) unsigned
DEFAULT NULL COMMENT 'VLAN tag used by the port',
254 PRIMARY KEY (`uuid`
),
255 KEY `FK_instance_vms`
(`instance_vm_id`
),
256 KEY `FK_instance_nets`
(`instance_net_id`
),
257 KEY `FK_instance_ids`
(`interface_id`
),
258 CONSTRAINT `FK_instance_ids`
FOREIGN KEY (`interface_id`
) REFERENCES `interfaces`
(`uuid`
) ON DELETE SET NULL ON UPDATE CASCADE,
259 CONSTRAINT `FK_instance_nets`
FOREIGN KEY (`instance_net_id`
) REFERENCES `instance_nets`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
260 CONSTRAINT `FK_instance_vms`
FOREIGN KEY (`instance_vm_id`
) REFERENCES `instance_vms`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
261 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Table with all running associattion among VM instances and net instances';
262 /*!40101 SET character_set_client = @saved_cs_client */;
265 -- Table structure for table `instance_nets`
268 DROP TABLE IF EXISTS `instance_nets`
;
269 /*!40101 SET @saved_cs_client = @@character_set_client */;
270 /*!40101 SET character_set_client = utf8 */;
271 CREATE TABLE `instance_nets`
(
272 `uuid`
varchar(36) NOT NULL,
273 `vim_net_id`
varchar(128) DEFAULT NULL,
274 `instance_scenario_id`
varchar(36) DEFAULT NULL,
275 `sce_net_id`
varchar(36) DEFAULT NULL,
276 `net_id`
varchar(36) DEFAULT NULL,
277 `datacenter_id`
varchar(36) DEFAULT NULL,
278 `datacenter_tenant_id`
varchar(36) NOT NULL,
279 `status`
enum('ACTIVE','INACTIVE','DOWN','BUILD','ERROR','VIM_ERROR','DELETED','SCHEDULED_CREATION','SCHEDULED_DELETION') NOT NULL DEFAULT 'BUILD',
280 `error_msg`
varchar(1024) DEFAULT NULL,
282 `multipoint`
enum('true','false') NOT NULL DEFAULT 'true',
283 `created`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Created or already exists at VIM',
284 `created_at`
double NOT NULL,
285 `modified_at`
double DEFAULT NULL,
286 `sdn_net_id`
varchar(36) DEFAULT NULL COMMENT 'Network id in ovim',
287 PRIMARY KEY (`uuid`
),
288 KEY `FK_instance_nets_instance_scenarios`
(`instance_scenario_id`
),
289 KEY `FK_instance_nets_sce_nets`
(`sce_net_id`
),
290 KEY `FK_instance_nets_nets`
(`net_id`
),
291 KEY `FK_instance_nets_datacenters`
(`datacenter_id`
),
292 KEY `FK_instance_nets_datacenter_tenants`
(`datacenter_tenant_id`
),
293 CONSTRAINT `FK_instance_nets_datacenter_tenants`
FOREIGN KEY (`datacenter_tenant_id`
) REFERENCES `datacenter_tenants`
(`uuid`
),
294 CONSTRAINT `FK_instance_nets_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
),
295 CONSTRAINT `FK_instance_nets_instance_scenarios`
FOREIGN KEY (`instance_scenario_id`
) REFERENCES `instance_scenarios`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
296 CONSTRAINT `FK_instance_nets_nets`
FOREIGN KEY (`net_id`
) REFERENCES `nets`
(`uuid`
) ON DELETE SET NULL ON UPDATE CASCADE,
297 CONSTRAINT `FK_instance_nets_sce_nets`
FOREIGN KEY (`sce_net_id`
) REFERENCES `sce_nets`
(`uuid`
) ON DELETE SET NULL ON UPDATE CASCADE
298 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Instances of networks';
299 /*!40101 SET character_set_client = @saved_cs_client */;
302 -- Table structure for table `instance_scenarios`
305 DROP TABLE IF EXISTS `instance_scenarios`
;
306 /*!40101 SET @saved_cs_client = @@character_set_client */;
307 /*!40101 SET character_set_client = utf8 */;
308 CREATE TABLE `instance_scenarios`
(
309 `uuid`
varchar(36) NOT NULL,
310 `
name`
varchar(255) NOT NULL,
311 `tenant_id`
varchar(36) DEFAULT NULL,
312 `scenario_id`
varchar(36) DEFAULT NULL,
313 `datacenter_id`
varchar(36) NOT NULL,
314 `datacenter_tenant_id`
varchar(36) NOT NULL,
315 `description`
varchar(255) DEFAULT NULL,
316 `created_at`
double NOT NULL,
317 `modified_at`
double DEFAULT NULL,
318 `cloud_config` mediumtext
,
319 PRIMARY KEY (`uuid`
),
320 KEY `FK_scenarios_nfvo_tenants`
(`tenant_id`
),
321 KEY `FK_instance_scenarios_vim_tenants`
(`datacenter_tenant_id`
),
322 KEY `FK_instance_scenarios_datacenters`
(`datacenter_id`
),
323 KEY `FK_instance_scenarios_scenarios`
(`scenario_id`
),
324 CONSTRAINT `FK_instance_scenarios_datacenter_tenants`
FOREIGN KEY (`datacenter_tenant_id`
) REFERENCES `datacenter_tenants`
(`uuid`
),
325 CONSTRAINT `FK_instance_scenarios_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
),
326 CONSTRAINT `FK_instance_scenarios_nfvo_tenants`
FOREIGN KEY (`tenant_id`
) REFERENCES `nfvo_tenants`
(`uuid`
),
327 CONSTRAINT `FK_instance_scenarios_scenarios`
FOREIGN KEY (`scenario_id`
) REFERENCES `scenarios`
(`uuid`
) ON DELETE SET NULL ON UPDATE CASCADE
328 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Instances of scenarios defined by the user';
329 /*!40101 SET character_set_client = @saved_cs_client */;
332 -- Table structure for table `instance_vms`
335 DROP TABLE IF EXISTS `instance_vms`
;
336 /*!40101 SET @saved_cs_client = @@character_set_client */;
337 /*!40101 SET character_set_client = utf8 */;
338 CREATE TABLE `instance_vms`
(
339 `uuid`
varchar(36) NOT NULL,
340 `instance_vnf_id`
varchar(36) NOT NULL,
341 `vm_id`
varchar(36) DEFAULT NULL,
342 `vim_vm_id`
varchar(128) DEFAULT NULL,
343 `status`
enum('ACTIVE:NoMgmtIP','ACTIVE','INACTIVE','BUILD','ERROR','VIM_ERROR','PAUSED','SUSPENDED','DELETED','SCHEDULED_CREATION','SCHEDULED_DELETION') NOT NULL DEFAULT 'BUILD',
344 `error_msg`
varchar(1024) DEFAULT NULL,
346 `created_at`
double NOT NULL,
347 `modified_at`
double DEFAULT NULL,
348 PRIMARY KEY (`uuid`
),
349 UNIQUE KEY `vim_vm_id`
(`vim_vm_id`
),
350 KEY `FK_instance_vms_vms`
(`vm_id`
),
351 KEY `FK_instance_vms_instance_vnfs`
(`instance_vnf_id`
),
352 CONSTRAINT `FK_instance_vms_instance_vnfs`
FOREIGN KEY (`instance_vnf_id`
) REFERENCES `instance_vnfs`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
353 CONSTRAINT `FK_instance_vms_vms`
FOREIGN KEY (`vm_id`
) REFERENCES `vms`
(`uuid`
) ON DELETE SET NULL ON UPDATE CASCADE
354 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Instances of VMs as part of VNF instances';
355 /*!40101 SET character_set_client = @saved_cs_client */;
358 -- Table structure for table `instance_vnfs`
361 DROP TABLE IF EXISTS `instance_vnfs`
;
362 /*!40101 SET @saved_cs_client = @@character_set_client */;
363 /*!40101 SET character_set_client = utf8 */;
364 CREATE TABLE `instance_vnfs`
(
365 `uuid`
varchar(36) NOT NULL,
366 `instance_scenario_id`
varchar(36) NOT NULL,
367 `vnf_id`
varchar(36) NOT NULL,
368 `sce_vnf_id`
varchar(36) DEFAULT NULL,
369 `datacenter_id`
varchar(36) DEFAULT NULL,
370 `datacenter_tenant_id`
varchar(36) DEFAULT NULL,
371 `created_at`
double NOT NULL,
372 `modified_at`
double DEFAULT NULL,
373 PRIMARY KEY (`uuid`
),
374 KEY `FK_instance_vnfs_vnfs`
(`vnf_id`
),
375 KEY `FK_instance_vnfs_instance_scenarios`
(`instance_scenario_id`
),
376 KEY `FK_instance_vnfs_sce_vnfs`
(`sce_vnf_id`
),
377 KEY `FK_instance_vnfs_datacenters`
(`datacenter_id`
),
378 KEY `FK_instance_vnfs_datacenter_tenants`
(`datacenter_tenant_id`
),
379 CONSTRAINT `FK_instance_vnfs_datacenter_tenants`
FOREIGN KEY (`datacenter_tenant_id`
) REFERENCES `datacenter_tenants`
(`uuid`
),
380 CONSTRAINT `FK_instance_vnfs_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
),
381 CONSTRAINT `FK_instance_vnfs_instance_scenarios`
FOREIGN KEY (`instance_scenario_id`
) REFERENCES `instance_scenarios`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
382 CONSTRAINT `FK_instance_vnfs_sce_vnfs`
FOREIGN KEY (`sce_vnf_id`
) REFERENCES `sce_vnfs`
(`uuid`
) ON DELETE SET NULL ON UPDATE CASCADE,
383 CONSTRAINT `FK_instance_vnfs_vnfs`
FOREIGN KEY (`vnf_id`
) REFERENCES `vnfs`
(`uuid`
)
384 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Instances of VNFs as part of a scenario';
385 /*!40101 SET character_set_client = @saved_cs_client */;
388 -- Table structure for table `interfaces`
391 DROP TABLE IF EXISTS `interfaces`
;
392 /*!40101 SET @saved_cs_client = @@character_set_client */;
393 /*!40101 SET character_set_client = utf8 */;
394 CREATE TABLE `interfaces`
(
395 `uuid`
varchar(36) NOT NULL,
396 `internal_name`
varchar(255) NOT NULL,
397 `external_name`
varchar(255) DEFAULT NULL,
398 `vm_id`
varchar(36) NOT NULL,
399 `net_id`
varchar(36) DEFAULT NULL,
400 `
type`
enum('mgmt','bridge','data') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
401 `vpci`
char(12) DEFAULT NULL,
402 `bw`
mediumint(8) unsigned
DEFAULT NULL COMMENT 'BW expressed in Mbits/s. Maybe this field is not necessary.',
403 `created_at`
double NOT NULL,
404 `modified_at`
double DEFAULT NULL,
405 `model`
varchar(12) DEFAULT NULL,
406 `mac`
char(18) DEFAULT NULL,
407 `ip_address`
varchar(64) DEFAULT NULL,
408 `floating_ip`
tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates if a floating_ip must be associated to this interface',
409 `port_security`
tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Indicates if port security must be enabled or disabled. By default it is enabled',
410 PRIMARY KEY (`uuid`
),
411 UNIQUE KEY `internal_name_vm_id`
(`internal_name`
,`vm_id`
),
412 KEY `FK_interfaces_vms`
(`vm_id`
),
413 KEY `FK_interfaces_nets`
(`net_id`
),
414 CONSTRAINT `FK_interfaces_nets`
FOREIGN KEY (`net_id`
) REFERENCES `nets`
(`uuid`
) ON DELETE CASCADE,
415 CONSTRAINT `FK_interfaces_vms`
FOREIGN KEY (`vm_id`
) REFERENCES `vms`
(`uuid`
) ON DELETE CASCADE
416 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='VM interfaces';
417 /*!40101 SET character_set_client = @saved_cs_client */;
420 -- Table structure for table `ip_profiles`
423 DROP TABLE IF EXISTS `ip_profiles`
;
424 /*!40101 SET @saved_cs_client = @@character_set_client */;
425 /*!40101 SET character_set_client = utf8 */;
426 CREATE TABLE `ip_profiles`
(
427 `
id`
int(11) NOT NULL AUTO_INCREMENT
,
428 `net_id`
varchar(36) DEFAULT NULL,
429 `sce_net_id`
varchar(36) DEFAULT NULL,
430 `instance_net_id`
varchar(36) DEFAULT NULL,
431 `ip_version`
enum('IPv4','IPv6') NOT NULL DEFAULT 'IPv4',
432 `subnet_address`
varchar(64) DEFAULT NULL,
433 `gateway_address`
varchar(64) DEFAULT NULL,
434 `dns_address`
varchar(255) DEFAULT NULL COMMENT 'dns ip list separated by semicolon',
435 `dhcp_enabled`
enum('true','false') NOT NULL DEFAULT 'true',
436 `dhcp_start_address`
varchar(64) DEFAULT NULL,
437 `dhcp_count`
int(11) DEFAULT NULL,
438 `security_group`
varchar(255) DEFAULT NULL,
440 KEY `FK_ipprofiles_nets`
(`net_id`
),
441 KEY `FK_ipprofiles_scenets`
(`sce_net_id`
),
442 KEY `FK_ipprofiles_instancenets`
(`instance_net_id`
),
443 CONSTRAINT `FK_ipprofiles_instancenets`
FOREIGN KEY (`instance_net_id`
) REFERENCES `instance_nets`
(`uuid`
) ON DELETE CASCADE,
444 CONSTRAINT `FK_ipprofiles_nets`
FOREIGN KEY (`net_id`
) REFERENCES `nets`
(`uuid`
) ON DELETE CASCADE,
445 CONSTRAINT `FK_ipprofiles_scenets`
FOREIGN KEY (`sce_net_id`
) REFERENCES `sce_nets`
(`uuid`
) ON DELETE CASCADE
446 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
COMMENT='Table containing the IP parameters of a network, either a net, a sce_net or and instance_net.';
447 /*!40101 SET character_set_client = @saved_cs_client */;
450 -- Table structure for table `logs`
453 DROP TABLE IF EXISTS `logs`
;
454 /*!40101 SET @saved_cs_client = @@character_set_client */;
455 /*!40101 SET character_set_client = utf8 */;
456 CREATE TABLE `logs`
(
457 `
id`
int(10) unsigned
NOT NULL AUTO_INCREMENT
,
458 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
459 `nfvo_tenant_id`
varchar(36) DEFAULT NULL,
460 `related`
varchar(36) NOT NULL COMMENT 'Relevant element for the log',
461 `uuid`
varchar(36) DEFAULT NULL COMMENT 'Uuid of vnf, scenario, etc. that log relates to',
462 `
level`
enum('panic','error','info','debug','verbose') NOT NULL,
463 `description`
varchar(200) NOT NULL,
465 ) ENGINE
=InnoDB AUTO_INCREMENT
=3423 DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
;
466 /*!40101 SET character_set_client = @saved_cs_client */;
469 -- Table structure for table `nets`
472 DROP TABLE IF EXISTS `nets`
;
473 /*!40101 SET @saved_cs_client = @@character_set_client */;
474 /*!40101 SET character_set_client = utf8 */;
475 CREATE TABLE `nets`
(
476 `uuid`
varchar(36) NOT NULL,
477 `vnf_id`
varchar(36) NOT NULL,
478 `
name`
varchar(255) NOT NULL,
479 `
type`
enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
480 `multipoint`
enum('true','false') NOT NULL DEFAULT 'false',
481 `description`
varchar(255) DEFAULT NULL,
482 `created_at`
double NOT NULL,
483 `modified_at`
double DEFAULT NULL,
484 PRIMARY KEY (`uuid`
),
485 UNIQUE KEY `vnf_id_name`
(`vnf_id`
,`
name`
),
486 CONSTRAINT `FK_nets_vnfs`
FOREIGN KEY (`vnf_id`
) REFERENCES `vnfs`
(`uuid`
) ON DELETE CASCADE
487 ) 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.';
488 /*!40101 SET character_set_client = @saved_cs_client */;
491 -- Table structure for table `nfvo_tenants`
494 DROP TABLE IF EXISTS `nfvo_tenants`
;
495 /*!40101 SET @saved_cs_client = @@character_set_client */;
496 /*!40101 SET character_set_client = utf8 */;
497 CREATE TABLE `nfvo_tenants`
(
498 `uuid`
varchar(36) NOT NULL,
499 `
name`
varchar(255) NOT NULL,
500 `description`
varchar(255) DEFAULT NULL,
501 `encrypted_RO_priv_key`
varchar(2000) DEFAULT NULL,
502 `RO_pub_key`
varchar(510) DEFAULT NULL,
503 `created_at`
double NOT NULL,
504 `modified_at`
double DEFAULT NULL,
505 PRIMARY KEY (`uuid`
),
506 UNIQUE KEY `
name`
(`
name`
)
507 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Scenarios defined by the user';
508 /*!40101 SET character_set_client = @saved_cs_client */;
511 -- Table structure for table `sce_interfaces`
514 DROP TABLE IF EXISTS `sce_interfaces`
;
515 /*!40101 SET @saved_cs_client = @@character_set_client */;
516 /*!40101 SET character_set_client = utf8 */;
517 CREATE TABLE `sce_interfaces`
(
518 `uuid`
varchar(36) NOT NULL,
519 `sce_vnf_id`
varchar(36) NOT NULL,
520 `sce_net_id`
varchar(36) DEFAULT NULL,
521 `interface_id`
varchar(36) DEFAULT NULL,
522 `ip_address`
varchar(64) DEFAULT NULL,
523 `created_at`
double NOT NULL,
524 `modified_at`
double DEFAULT NULL,
525 PRIMARY KEY (`uuid`
),
526 KEY `FK_sce_interfaces_sce_vnfs`
(`sce_vnf_id`
),
527 KEY `FK_sce_interfaces_sce_nets`
(`sce_net_id`
),
528 KEY `FK_sce_interfaces_interfaces`
(`interface_id`
),
529 CONSTRAINT `FK_sce_interfaces_interfaces`
FOREIGN KEY (`interface_id`
) REFERENCES `interfaces`
(`uuid`
),
530 CONSTRAINT `FK_sce_interfaces_sce_nets`
FOREIGN KEY (`sce_net_id`
) REFERENCES `sce_nets`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
531 CONSTRAINT `FK_sce_interfaces_sce_vnfs`
FOREIGN KEY (`sce_vnf_id`
) REFERENCES `sce_vnfs`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
532 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='VNF interfaces in a scenario definition.';
533 /*!40101 SET character_set_client = @saved_cs_client */;
536 -- Table structure for table `sce_nets`
539 DROP TABLE IF EXISTS `sce_nets`
;
540 /*!40101 SET @saved_cs_client = @@character_set_client */;
541 /*!40101 SET character_set_client = utf8 */;
542 CREATE TABLE `sce_nets`
(
543 `uuid`
varchar(36) NOT NULL,
544 `
name`
varchar(255) NOT NULL,
545 `scenario_id`
varchar(36) DEFAULT NULL COMMENT 'NULL if net is matched to several scenarios',
546 `
type`
enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
547 `multipoint`
enum('true','false') NOT NULL DEFAULT 'true',
548 `
external`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'If external, net is already present at VIM',
549 `description`
varchar(255) DEFAULT NULL,
550 `created_at`
double NOT NULL,
551 `modified_at`
double DEFAULT NULL,
552 `graph`
varchar(2000) DEFAULT NULL,
553 PRIMARY KEY (`uuid`
),
554 KEY `FK_sce_nets_scenarios`
(`scenario_id`
),
555 CONSTRAINT `FK_sce_nets_scenarios`
FOREIGN KEY (`scenario_id`
) REFERENCES `scenarios`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
556 ) 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''.';
557 /*!40101 SET character_set_client = @saved_cs_client */;
560 -- Table structure for table `sce_vnfs`
563 DROP TABLE IF EXISTS `sce_vnfs`
;
564 /*!40101 SET @saved_cs_client = @@character_set_client */;
565 /*!40101 SET character_set_client = utf8 */;
566 CREATE TABLE `sce_vnfs`
(
567 `uuid`
varchar(36) NOT NULL,
568 `member_vnf_index`
smallint(6) DEFAULT NULL,
569 `
name`
varchar(255) NOT NULL,
570 `scenario_id`
varchar(36) NOT NULL,
571 `vnf_id`
varchar(36) NOT NULL,
572 `description`
varchar(255) DEFAULT NULL,
573 `created_at`
double NOT NULL,
574 `modified_at`
double DEFAULT NULL,
575 `graph`
varchar(2000) DEFAULT NULL,
576 PRIMARY KEY (`uuid`
),
577 UNIQUE KEY `name_scenario_id`
(`
name`
,`scenario_id`
),
578 KEY `FK_sce_vnfs_scenarios`
(`scenario_id`
),
579 KEY `FK_sce_vnfs_vnfs`
(`vnf_id`
),
580 CONSTRAINT `FK_sce_vnfs_scenarios`
FOREIGN KEY (`scenario_id`
) REFERENCES `scenarios`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
581 CONSTRAINT `FK_sce_vnfs_vnfs`
FOREIGN KEY (`vnf_id`
) REFERENCES `vnfs`
(`uuid`
)
582 ) 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';
583 /*!40101 SET character_set_client = @saved_cs_client */;
586 -- Table structure for table `scenarios`
589 DROP TABLE IF EXISTS `scenarios`
;
590 /*!40101 SET @saved_cs_client = @@character_set_client */;
591 /*!40101 SET character_set_client = utf8 */;
592 CREATE TABLE `scenarios`
(
593 `uuid`
varchar(36) NOT NULL,
594 `osm_id`
varchar(255) DEFAULT NULL,
595 `
name`
varchar(255) NOT NULL,
596 `short_name`
varchar(255) DEFAULT NULL,
597 `tenant_id`
varchar(36) DEFAULT NULL,
598 `description`
varchar(255) DEFAULT NULL,
599 `vendor`
varchar(255) DEFAULT NULL,
600 `
public`
enum('true','false') NOT NULL DEFAULT 'false',
601 `created_at`
double NOT NULL,
602 `modified_at`
double DEFAULT NULL,
603 `
descriptor`
text COMMENT 'Original text descriptor used for create the scenario',
604 `cloud_config` mediumtext
,
605 PRIMARY KEY (`uuid`
),
606 UNIQUE KEY `osm_id_tenant_id`
(`osm_id`
,`tenant_id`
),
607 KEY `FK_scenarios_nfvo_tenants`
(`tenant_id`
),
608 CONSTRAINT `FK_scenarios_nfvo_tenants`
FOREIGN KEY (`tenant_id`
) REFERENCES `nfvo_tenants`
(`uuid`
)
609 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Scenarios defined by the user';
610 /*!40101 SET character_set_client = @saved_cs_client */;
613 -- Table structure for table `schema_version`
616 DROP TABLE IF EXISTS `schema_version`
;
617 /*!40101 SET @saved_cs_client = @@character_set_client */;
618 /*!40101 SET character_set_client = utf8 */;
619 CREATE TABLE `schema_version`
(
620 `version_int`
int(11) NOT NULL COMMENT 'version as a number. Must not contain gaps',
621 `
version`
varchar(20) NOT NULL COMMENT 'version as a text',
622 `openmano_ver`
varchar(20) NOT NULL COMMENT 'openmano version',
623 `
comments`
varchar(2000) DEFAULT NULL COMMENT 'changes to database',
624 `
date`
date DEFAULT NULL,
625 PRIMARY KEY (`version_int`
)
626 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
COMMENT='database schema control version';
627 /*!40101 SET character_set_client = @saved_cs_client */;
630 -- Table structure for table `tenants_datacenters`
633 DROP TABLE IF EXISTS `tenants_datacenters`
;
634 /*!40101 SET @saved_cs_client = @@character_set_client */;
635 /*!40101 SET character_set_client = utf8 */;
636 CREATE TABLE `tenants_datacenters`
(
637 `
id`
int(11) NOT NULL AUTO_INCREMENT
,
638 `nfvo_tenant_id`
varchar(36) NOT NULL,
639 `datacenter_id`
varchar(36) NOT NULL,
640 `datacenter_tenant_id`
varchar(36) NOT NULL,
641 `created_at`
double NOT NULL,
642 `modified_at`
double DEFAULT NULL,
644 UNIQUE KEY `datacenter_nfvo_tenant`
(`datacenter_id`
,`nfvo_tenant_id`
),
645 KEY `FK_nfvo_tenants_datacenters`
(`datacenter_id`
),
646 KEY `FK_nfvo_tenants_vim_tenants`
(`datacenter_tenant_id`
),
647 KEY `FK_tenants_datacenters_nfvo_tenants`
(`nfvo_tenant_id`
),
648 CONSTRAINT `FK_tenants_datacenters_datacenter_tenants`
FOREIGN KEY (`datacenter_tenant_id`
) REFERENCES `datacenter_tenants`
(`uuid`
),
649 CONSTRAINT `FK_tenants_datacenters_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
),
650 CONSTRAINT `FK_tenants_datacenters_nfvo_tenants`
FOREIGN KEY (`nfvo_tenant_id`
) REFERENCES `nfvo_tenants`
(`uuid`
)
651 ) ENGINE
=InnoDB AUTO_INCREMENT
=86 DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Scenarios defined by the user';
652 /*!40101 SET character_set_client = @saved_cs_client */;
655 -- Table structure for table `uuids`
658 DROP TABLE IF EXISTS `uuids`
;
659 /*!40101 SET @saved_cs_client = @@character_set_client */;
660 /*!40101 SET character_set_client = utf8 */;
661 CREATE TABLE `uuids`
(
662 `uuid`
varchar(36) NOT NULL,
663 `root_uuid`
varchar(36) DEFAULT NULL COMMENT 'Some related UUIDs can be grouped by this field, so that they can be deleted at once',
664 `created_at`
double NOT NULL,
665 `used_at`
varchar(36) DEFAULT NULL COMMENT 'Table that uses this UUID',
667 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
COMMENT='Table with all unique IDs used to avoid UUID repetitions among different elements';
668 /*!40101 SET character_set_client = @saved_cs_client */;
671 -- Table structure for table `vim_actions`
674 DROP TABLE IF EXISTS `vim_actions`
;
675 /*!40101 SET @saved_cs_client = @@character_set_client */;
676 /*!40101 SET character_set_client = utf8 */;
677 CREATE TABLE `vim_actions`
(
678 `instance_action_id`
varchar(36) NOT NULL,
679 `task_index`
int(6) NOT NULL,
680 `datacenter_vim_id`
varchar(36) NOT NULL,
681 `vim_id`
varchar(64) DEFAULT NULL,
682 `
action`
varchar(36) NOT NULL COMMENT 'CREATE,DELETE,START,STOP...',
683 `item`
enum('datacenters_flavors','datacenter_images','instance_nets','instance_vms','instance_interfaces') NOT NULL COMMENT 'table where the item is stored',
684 `item_id`
varchar(36) DEFAULT NULL COMMENT 'uuid of the entry in the table',
685 `status`
enum('SCHEDULED','BUILD','DONE','FAILED','SUPERSEDED') NOT NULL DEFAULT 'SCHEDULED',
686 `extra`
text COMMENT 'json with params:, depends_on: for the task',
687 `error_msg`
varchar(1024) DEFAULT NULL,
688 `created_at`
double NOT NULL,
689 `modified_at`
double DEFAULT NULL,
690 PRIMARY KEY (`task_index`
,`instance_action_id`
),
691 KEY `FK_actions_instance_actions`
(`instance_action_id`
),
692 KEY `FK_actions_vims`
(`datacenter_vim_id`
),
693 CONSTRAINT `FK_actions_instance_actions`
FOREIGN KEY (`instance_action_id`
) REFERENCES `instance_actions`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
694 CONSTRAINT `FK_actions_vims`
FOREIGN KEY (`datacenter_vim_id`
) REFERENCES `datacenter_tenants`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
695 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
COMMENT='Table with the individual VIM actions.';
696 /*!40101 SET character_set_client = @saved_cs_client */;
699 -- Table structure for table `vms`
702 DROP TABLE IF EXISTS `vms`
;
703 /*!40101 SET @saved_cs_client = @@character_set_client */;
704 /*!40101 SET character_set_client = utf8 */;
706 `uuid`
varchar(36) NOT NULL,
707 `osm_id`
varchar(255) DEFAULT NULL,
708 `
name`
varchar(255) NOT NULL,
709 `vnf_id`
varchar(36) NOT NULL,
710 `
count`
smallint(6) NOT NULL DEFAULT '1',
711 `flavor_id`
varchar(36) NOT NULL COMMENT 'Link to flavor table',
712 `image_id`
varchar(36) NOT NULL COMMENT 'Link to image table',
713 `image_path`
varchar(100) DEFAULT NULL COMMENT 'Path where the image of the VM is located',
715 `description`
varchar(255) DEFAULT NULL,
716 `created_at`
double NOT NULL,
717 `modified_at`
double DEFAULT NULL,
718 `availability_zone`
varchar(255) DEFAULT NULL,
719 PRIMARY KEY (`uuid`
),
720 UNIQUE KEY `name_vnf_id`
(`
name`
,`vnf_id`
),
721 KEY `FK_vms_vnfs`
(`vnf_id`
),
722 KEY `FK_vms_images`
(`image_id`
),
723 KEY `FK_vms_flavors`
(`flavor_id`
),
724 CONSTRAINT `FK_vms_flavors`
FOREIGN KEY (`flavor_id`
) REFERENCES `flavors`
(`uuid`
),
725 CONSTRAINT `FK_vms_images`
FOREIGN KEY (`image_id`
) REFERENCES `images`
(`uuid`
),
726 CONSTRAINT `FK_vms_vnfs`
FOREIGN KEY (`vnf_id`
) REFERENCES `vnfs`
(`uuid`
) ON DELETE CASCADE
727 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='VM definitions. It contains the set of VMs used by the VNF definitions.';
728 /*!40101 SET character_set_client = @saved_cs_client */;
731 -- Table structure for table `vnfs`
734 DROP TABLE IF EXISTS `vnfs`
;
735 /*!40101 SET @saved_cs_client = @@character_set_client */;
736 /*!40101 SET character_set_client = utf8 */;
737 CREATE TABLE `vnfs`
(
738 `uuid`
varchar(36) NOT NULL,
739 `osm_id`
varchar(255) DEFAULT NULL,
740 `
name`
varchar(255) NOT NULL,
741 `short_name`
varchar(255) DEFAULT NULL,
742 `tenant_id`
varchar(36) DEFAULT NULL,
743 `physical`
enum('true','false') NOT NULL DEFAULT 'false',
744 `
public`
enum('true','false') NOT NULL DEFAULT 'false',
745 `description`
varchar(255) DEFAULT NULL,
746 `vendor`
varchar(255) DEFAULT NULL,
747 `mgmt_access`
varchar(2000) DEFAULT NULL,
748 `created_at`
double NOT NULL,
749 `modified_at`
double DEFAULT NULL,
750 `
class`
varchar(36) DEFAULT 'MISC',
751 `
descriptor`
text COMMENT 'Original text descriptor used for create the VNF',
752 PRIMARY KEY (`uuid`
),
753 UNIQUE KEY `osm_id_tenant_id`
(`osm_id`
,`tenant_id`
),
754 KEY `FK_vnfs_nfvo_tenants`
(`tenant_id`
),
755 CONSTRAINT `FK_vnfs_nfvo_tenants`
FOREIGN KEY (`tenant_id`
) REFERENCES `nfvo_tenants`
(`uuid`
) ON DELETE SET NULL ON UPDATE CASCADE
756 ) 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';
757 /*!40101 SET character_set_client = @saved_cs_client */;
760 -- Dumping routines for database '{{mano_db}}'
762 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
764 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
765 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
766 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
767 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
768 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
769 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
770 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
772 -- Dump completed on 2017-11-23 10:24:39
778 -- MySQL dump 10.13 Distrib 5.7.20, for Linux (x86_64)
780 -- Host: localhost Database: {{mano_db}}
781 -- ------------------------------------------------------
782 -- Server version 5.7.20-0ubuntu0.16.04.1
784 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
785 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
786 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
787 /*!40101 SET NAMES utf8 */;
788 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
789 /*!40103 SET TIME_ZONE='+00:00' */;
790 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
791 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
792 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
793 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
796 -- Dumping data for table `schema_version`
799 LOCK TABLES `schema_version`
WRITE;
800 /*!40000 ALTER TABLE `schema_version` DISABLE KEYS */;
801 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'),(11,'0.11','0.4.43','remove unique name at scenarios,instance_scenarios','2016-07-18'),(12,'0.12','0.4.46','create ip_profiles table, with foreign keys to all nets tables, and add ip_address column to interfaces and sce_interfaces','2016-08-29'),(13,'0.13','0.4.47','insert cloud-config at scenarios,instance_scenarios','2016-08-30'),(14,'0.14','0.4.57','remove unique index vim_net_id, instance_scenario_id','2016-09-26'),(15,'0.15','0.4.59','add columns universal_name and checksum at table images, add unique index universal_name_checksum, and change location to allow NULL; change column image_path in table vms to allow NULL','2016-09-27'),(16,'0.16','0.5.2','enlarge vim_tenant_name and id. New config at datacenter_tenants','2016-10-11'),(17,'0.17','0.5.3','Extra description json format of additional devices in datacenter_flavors','2016-12-20'),(18,'0.18','0.5.4','Add columns \'floating_ip\' and \'port_security\' at tables \'interfaces\' and \'instance_interfaces\'','2017-01-09'),(19,'0.19','0.5.5','Extra Boot-data content at VNFC (vms)','2017-01-11'),(20,'0.20','0.5.9','Added columns to store dataplane connectivity info','2017-03-13'),(21,'0.21','0.5.15','Edit instance_nets to allow instance_scenario_id=None and enlarge column dns_address at table ip_profiles','2017-06-02'),(22,'0.22','0.5.16','Changed type of ram in flavors from SMALLINT to MEDIUMINT','2017-06-02'),(23,'0.23','0.5.20','Changed type of ram in flavors from SMALLINT to MEDIUMINT','2017-08-29'),(24,'0.24','0.5.21','Added vnfd fields','2017-08-29'),(25,'0.25','0.5.22','Added osm_id to vnfs,scenarios','2017-09-01'),(26,'0.26','0.5.23','Several changes','2017-09-09'),(27,'0.27','0.5.25','Added encrypted_RO_priv_key,RO_pub_key to table nfvo_tenants','2017-09-29');
802 /*!40000 ALTER TABLE `schema_version` ENABLE KEYS */;
804 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
806 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
807 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
808 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
809 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
810 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
811 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
812 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
814 -- Dump completed on 2017-11-23 10:24:39