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.18, for Linux (x86_64)
24 -- Host: localhost Database: {{mano_db}}
25 -- ------------------------------------------------------
26 -- Server version 5.7.18-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 `datacenter_id`
varchar(36) NOT NULL COMMENT 'Datacenter of this tenant',
84 `vim_tenant_name`
varchar(256) DEFAULT NULL,
85 `vim_tenant_id`
varchar(256) DEFAULT NULL COMMENT 'Tenant ID at VIM',
86 `created`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if this tenant has been created by openmano, or it existed on VIM',
87 `
user`
varchar(64) DEFAULT NULL,
88 `passwd`
varchar(64) DEFAULT NULL,
89 `config`
varchar(4000) DEFAULT NULL,
90 `created_at`
double NOT NULL,
91 `modified_at`
double DEFAULT NULL,
93 KEY `FK_vim_tenants_datacenters`
(`datacenter_id`
),
94 CONSTRAINT `FK_vim_tenants_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
95 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Scenarios defined by the user';
96 /*!40101 SET character_set_client = @saved_cs_client */;
99 -- Table structure for table `datacenters`
102 DROP TABLE IF EXISTS `datacenters`
;
103 /*!40101 SET @saved_cs_client = @@character_set_client */;
104 /*!40101 SET character_set_client = utf8 */;
105 CREATE TABLE `datacenters`
(
106 `uuid`
varchar(36) NOT NULL,
107 `
name`
varchar(255) NOT NULL,
108 `description`
varchar(255) DEFAULT NULL,
109 `
type`
varchar(36) NOT NULL DEFAULT 'openvim',
110 `vim_url`
varchar(150) NOT NULL COMMENT 'URL of the VIM for the REST API',
111 `vim_url_admin`
varchar(150) DEFAULT NULL,
112 `config`
varchar(4000) DEFAULT NULL COMMENT 'extra config information in json',
113 `created_at`
double NOT NULL,
114 `modified_at`
double DEFAULT NULL,
115 PRIMARY KEY (`uuid`
),
116 UNIQUE KEY `
name`
(`
name`
)
117 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Datacenters managed by the NFVO.';
118 /*!40101 SET character_set_client = @saved_cs_client */;
121 -- Table structure for table `datacenters_flavors`
124 DROP TABLE IF EXISTS `datacenters_flavors`
;
125 /*!40101 SET @saved_cs_client = @@character_set_client */;
126 /*!40101 SET character_set_client = utf8 */;
127 CREATE TABLE `datacenters_flavors`
(
128 `
id`
int(11) NOT NULL AUTO_INCREMENT
,
129 `flavor_id`
varchar(36) NOT NULL,
130 `datacenter_id`
varchar(36) NOT NULL,
131 `vim_id`
varchar(36) NOT NULL,
132 `created`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if it has been created by openmano, or already existed',
133 `extended`
varchar(2000) DEFAULT NULL COMMENT 'Extra description json format of additional devices',
135 KEY `FK__flavors`
(`flavor_id`
),
136 KEY `FK__datacenters_f`
(`datacenter_id`
),
137 CONSTRAINT `FK__datacenters_f`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
138 CONSTRAINT `FK__flavors`
FOREIGN KEY (`flavor_id`
) REFERENCES `flavors`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
139 ) ENGINE
=InnoDB AUTO_INCREMENT
=7 DEFAULT CHARSET
=utf8
;
140 /*!40101 SET character_set_client = @saved_cs_client */;
143 -- Table structure for table `datacenters_images`
146 DROP TABLE IF EXISTS `datacenters_images`
;
147 /*!40101 SET @saved_cs_client = @@character_set_client */;
148 /*!40101 SET character_set_client = utf8 */;
149 CREATE TABLE `datacenters_images`
(
150 `
id`
int(11) NOT NULL AUTO_INCREMENT
,
151 `image_id`
varchar(36) NOT NULL,
152 `datacenter_id`
varchar(36) NOT NULL,
153 `vim_id`
varchar(36) NOT NULL,
154 `created`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if it has been created by openmano, or already existed',
156 KEY `FK__images`
(`image_id`
),
157 KEY `FK__datacenters_i`
(`datacenter_id`
),
158 CONSTRAINT `FK__datacenters_i`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
159 CONSTRAINT `FK__images`
FOREIGN KEY (`image_id`
) REFERENCES `images`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
160 ) ENGINE
=InnoDB AUTO_INCREMENT
=6 DEFAULT CHARSET
=utf8
;
161 /*!40101 SET character_set_client = @saved_cs_client */;
164 -- Table structure for table `flavors`
167 DROP TABLE IF EXISTS `flavors`
;
168 /*!40101 SET @saved_cs_client = @@character_set_client */;
169 /*!40101 SET character_set_client = utf8 */;
170 CREATE TABLE `flavors`
(
171 `uuid`
varchar(36) NOT NULL,
172 `
name`
varchar(255) NOT NULL,
173 `description`
varchar(255) DEFAULT NULL,
174 `disk`
smallint(5) unsigned
DEFAULT NULL,
175 `ram`
smallint(5) unsigned
DEFAULT NULL,
176 `vcpus`
smallint(5) unsigned
DEFAULT NULL,
177 `extended`
varchar(2000) DEFAULT NULL COMMENT 'Extra description json format of needed resources and pining, orginized in sets per numa',
179 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
;
180 /*!40101 SET character_set_client = @saved_cs_client */;
183 -- Table structure for table `images`
186 DROP TABLE IF EXISTS `images`
;
187 /*!40101 SET @saved_cs_client = @@character_set_client */;
188 /*!40101 SET character_set_client = utf8 */;
189 CREATE TABLE `images`
(
190 `uuid`
varchar(36) NOT NULL,
191 `
name`
varchar(255) NOT NULL,
192 `universal_name`
varchar(255) DEFAULT NULL,
193 `checksum`
varchar(32) DEFAULT NULL,
194 `
location`
varchar(200) DEFAULT NULL,
195 `description`
varchar(255) DEFAULT NULL,
196 `metadata`
varchar(2000) DEFAULT NULL,
197 PRIMARY KEY (`uuid`
),
198 UNIQUE KEY `
location`
(`
location`
),
199 UNIQUE KEY `universal_name_checksum`
(`universal_name`
,`checksum`
)
200 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
;
201 /*!40101 SET character_set_client = @saved_cs_client */;
204 -- Table structure for table `instance_interfaces`
207 DROP TABLE IF EXISTS `instance_interfaces`
;
208 /*!40101 SET @saved_cs_client = @@character_set_client */;
209 /*!40101 SET character_set_client = utf8 */;
210 CREATE TABLE `instance_interfaces`
(
211 `uuid`
varchar(36) NOT NULL,
212 `instance_vm_id`
varchar(36) NOT NULL,
213 `instance_net_id`
varchar(36) NOT NULL,
214 `interface_id`
varchar(36) NOT NULL,
215 `vim_interface_id`
varchar(36) DEFAULT NULL COMMENT 'vim identity for that interface',
216 `mac_address`
varchar(32) DEFAULT NULL,
217 `ip_address`
varchar(64) DEFAULT NULL,
219 `
type`
enum('internal','external') NOT NULL COMMENT 'Indicates if this interface is external to a vnf, or internal',
220 `floating_ip`
tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates if a floating_ip must be associated to this interface',
221 `port_security`
tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Indicates if port security must be enabled or disabled. By default it is enabled',
222 `sdn_port_id`
varchar(36) DEFAULT NULL COMMENT 'Port id in ovim',
223 `compute_node`
varchar(100) DEFAULT NULL COMMENT 'Compute node id used to specify the SDN port mapping',
224 `pci`
varchar(12) DEFAULT NULL COMMENT 'PCI of the physical port in the host',
225 `vlan`
smallint(5) unsigned
DEFAULT NULL COMMENT 'VLAN tag used by the port',
226 PRIMARY KEY (`uuid`
),
227 KEY `FK_instance_vms`
(`instance_vm_id`
),
228 KEY `FK_instance_nets`
(`instance_net_id`
),
229 KEY `FK_instance_ids`
(`interface_id`
),
230 CONSTRAINT `FK_instance_ids`
FOREIGN KEY (`interface_id`
) REFERENCES `interfaces`
(`uuid`
),
231 CONSTRAINT `FK_instance_nets`
FOREIGN KEY (`instance_net_id`
) REFERENCES `instance_nets`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
232 CONSTRAINT `FK_instance_vms`
FOREIGN KEY (`instance_vm_id`
) REFERENCES `instance_vms`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
233 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Table with all running associattion among VM instances and net instances';
234 /*!40101 SET character_set_client = @saved_cs_client */;
237 -- Table structure for table `instance_nets`
240 DROP TABLE IF EXISTS `instance_nets`
;
241 /*!40101 SET @saved_cs_client = @@character_set_client */;
242 /*!40101 SET character_set_client = utf8 */;
243 CREATE TABLE `instance_nets`
(
244 `uuid`
varchar(36) NOT NULL,
245 `vim_net_id`
varchar(36) NOT NULL COMMENT 'Network ID in the VIM DB',
246 `instance_scenario_id`
varchar(36) NOT NULL,
247 `sce_net_id`
varchar(36) DEFAULT NULL,
248 `net_id`
varchar(36) DEFAULT NULL,
249 `datacenter_id`
varchar(36) DEFAULT NULL,
250 `datacenter_tenant_id`
varchar(36) NOT NULL,
251 `status`
enum('ACTIVE','DOWN','BUILD','ERROR','VIM_ERROR','INACTIVE','DELETED') NOT NULL DEFAULT 'BUILD',
252 `error_msg`
varchar(1024) DEFAULT NULL,
254 `multipoint`
enum('true','false') NOT NULL DEFAULT 'true',
255 `created`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Created or already exists at VIM',
256 `created_at`
double NOT NULL,
257 `modified_at`
double DEFAULT NULL,
258 `sdn_net_id`
varchar(36) DEFAULT NULL COMMENT 'Network id in ovim',
259 PRIMARY KEY (`uuid`
),
260 KEY `FK_instance_nets_instance_scenarios`
(`instance_scenario_id`
),
261 KEY `FK_instance_nets_sce_nets`
(`sce_net_id`
),
262 KEY `FK_instance_nets_nets`
(`net_id`
),
263 KEY `FK_instance_nets_datacenters`
(`datacenter_id`
),
264 KEY `FK_instance_nets_datacenter_tenants`
(`datacenter_tenant_id`
),
265 CONSTRAINT `FK_instance_nets_datacenter_tenants`
FOREIGN KEY (`datacenter_tenant_id`
) REFERENCES `datacenter_tenants`
(`uuid`
),
266 CONSTRAINT `FK_instance_nets_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
),
267 CONSTRAINT `FK_instance_nets_instance_scenarios`
FOREIGN KEY (`instance_scenario_id`
) REFERENCES `instance_scenarios`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
268 CONSTRAINT `FK_instance_nets_nets`
FOREIGN KEY (`net_id`
) REFERENCES `nets`
(`uuid`
) ON DELETE SET NULL ON UPDATE CASCADE,
269 CONSTRAINT `FK_instance_nets_sce_nets`
FOREIGN KEY (`sce_net_id`
) REFERENCES `sce_nets`
(`uuid`
) ON DELETE SET NULL ON UPDATE CASCADE
270 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Instances of networks';
271 /*!40101 SET character_set_client = @saved_cs_client */;
274 -- Table structure for table `instance_scenarios`
277 DROP TABLE IF EXISTS `instance_scenarios`
;
278 /*!40101 SET @saved_cs_client = @@character_set_client */;
279 /*!40101 SET character_set_client = utf8 */;
280 CREATE TABLE `instance_scenarios`
(
281 `uuid`
varchar(36) NOT NULL,
282 `
name`
varchar(255) NOT NULL,
283 `tenant_id`
varchar(36) DEFAULT NULL,
284 `scenario_id`
varchar(36) NOT NULL,
285 `datacenter_id`
varchar(36) NOT NULL,
286 `datacenter_tenant_id`
varchar(36) NOT NULL,
287 `description`
varchar(255) DEFAULT NULL,
288 `created_at`
double NOT NULL,
289 `modified_at`
double DEFAULT NULL,
290 `cloud_config` mediumtext
,
291 PRIMARY KEY (`uuid`
),
292 KEY `FK_scenarios_nfvo_tenants`
(`tenant_id`
),
293 KEY `FK_instance_scenarios_vim_tenants`
(`datacenter_tenant_id`
),
294 KEY `FK_instance_scenarios_datacenters`
(`datacenter_id`
),
295 KEY `FK_instance_scenarios_scenarios`
(`scenario_id`
),
296 CONSTRAINT `FK_instance_scenarios_datacenter_tenants`
FOREIGN KEY (`datacenter_tenant_id`
) REFERENCES `datacenter_tenants`
(`uuid`
),
297 CONSTRAINT `FK_instance_scenarios_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
),
298 CONSTRAINT `FK_instance_scenarios_nfvo_tenants`
FOREIGN KEY (`tenant_id`
) REFERENCES `nfvo_tenants`
(`uuid`
),
299 CONSTRAINT `FK_instance_scenarios_scenarios`
FOREIGN KEY (`scenario_id`
) REFERENCES `scenarios`
(`uuid`
)
300 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Instances of scenarios defined by the user';
301 /*!40101 SET character_set_client = @saved_cs_client */;
304 -- Table structure for table `instance_vms`
307 DROP TABLE IF EXISTS `instance_vms`
;
308 /*!40101 SET @saved_cs_client = @@character_set_client */;
309 /*!40101 SET character_set_client = utf8 */;
310 CREATE TABLE `instance_vms`
(
311 `uuid`
varchar(36) NOT NULL,
312 `instance_vnf_id`
varchar(36) NOT NULL,
313 `vm_id`
varchar(36) NOT NULL,
314 `vim_vm_id`
varchar(36) NOT NULL COMMENT 'VM ID in the VIM DB',
315 `status`
enum('ACTIVE:NoMgmtIP','ACTIVE','INACTIVE','BUILD','ERROR','VIM_ERROR','PAUSED','SUSPENDED','DELETED') NOT NULL DEFAULT 'BUILD',
316 `error_msg`
varchar(1024) DEFAULT NULL,
318 `created_at`
double NOT NULL,
319 `modified_at`
double DEFAULT NULL,
320 PRIMARY KEY (`uuid`
),
321 UNIQUE KEY `vim_vm_id`
(`vim_vm_id`
),
322 KEY `FK_instance_vms_vms`
(`vm_id`
),
323 KEY `FK_instance_vms_instance_vnfs`
(`instance_vnf_id`
),
324 CONSTRAINT `FK_instance_vms_instance_vnfs`
FOREIGN KEY (`instance_vnf_id`
) REFERENCES `instance_vnfs`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
325 CONSTRAINT `FK_instance_vms_vms`
FOREIGN KEY (`vm_id`
) REFERENCES `vms`
(`uuid`
)
326 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Instances of VMs as part of VNF instances';
327 /*!40101 SET character_set_client = @saved_cs_client */;
330 -- Table structure for table `instance_vnfs`
333 DROP TABLE IF EXISTS `instance_vnfs`
;
334 /*!40101 SET @saved_cs_client = @@character_set_client */;
335 /*!40101 SET character_set_client = utf8 */;
336 CREATE TABLE `instance_vnfs`
(
337 `uuid`
varchar(36) NOT NULL,
338 `instance_scenario_id`
varchar(36) NOT NULL,
339 `vnf_id`
varchar(36) NOT NULL,
340 `sce_vnf_id`
varchar(36) DEFAULT NULL,
341 `datacenter_id`
varchar(36) DEFAULT NULL,
342 `datacenter_tenant_id`
varchar(36) DEFAULT NULL,
343 `created_at`
double NOT NULL,
344 `modified_at`
double DEFAULT NULL,
345 PRIMARY KEY (`uuid`
),
346 KEY `FK_instance_vnfs_vnfs`
(`vnf_id`
),
347 KEY `FK_instance_vnfs_instance_scenarios`
(`instance_scenario_id`
),
348 KEY `FK_instance_vnfs_sce_vnfs`
(`sce_vnf_id`
),
349 KEY `FK_instance_vnfs_datacenters`
(`datacenter_id`
),
350 KEY `FK_instance_vnfs_datacenter_tenants`
(`datacenter_tenant_id`
),
351 CONSTRAINT `FK_instance_vnfs_datacenter_tenants`
FOREIGN KEY (`datacenter_tenant_id`
) REFERENCES `datacenter_tenants`
(`uuid`
),
352 CONSTRAINT `FK_instance_vnfs_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
),
353 CONSTRAINT `FK_instance_vnfs_instance_scenarios`
FOREIGN KEY (`instance_scenario_id`
) REFERENCES `instance_scenarios`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
354 CONSTRAINT `FK_instance_vnfs_sce_vnfs`
FOREIGN KEY (`sce_vnf_id`
) REFERENCES `sce_vnfs`
(`uuid`
) ON DELETE SET NULL ON UPDATE CASCADE,
355 CONSTRAINT `FK_instance_vnfs_vnfs`
FOREIGN KEY (`vnf_id`
) REFERENCES `vnfs`
(`uuid`
)
356 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Instances of VNFs as part of a scenario';
357 /*!40101 SET character_set_client = @saved_cs_client */;
360 -- Table structure for table `interfaces`
363 DROP TABLE IF EXISTS `interfaces`
;
364 /*!40101 SET @saved_cs_client = @@character_set_client */;
365 /*!40101 SET character_set_client = utf8 */;
366 CREATE TABLE `interfaces`
(
367 `uuid`
varchar(36) NOT NULL,
368 `internal_name`
varchar(255) NOT NULL,
369 `external_name`
varchar(255) DEFAULT NULL,
370 `vm_id`
varchar(36) NOT NULL,
371 `net_id`
varchar(36) DEFAULT NULL,
372 `
type`
enum('mgmt','bridge','data') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
373 `vpci`
char(12) DEFAULT NULL,
374 `bw`
mediumint(8) unsigned
DEFAULT NULL COMMENT 'BW expressed in Mbits/s. Maybe this field is not necessary.',
375 `created_at`
double NOT NULL,
376 `modified_at`
double DEFAULT NULL,
377 `model`
varchar(12) DEFAULT NULL,
378 `mac`
char(18) DEFAULT NULL,
379 `ip_address`
varchar(64) DEFAULT NULL,
380 `floating_ip`
tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates if a floating_ip must be associated to this interface',
381 `port_security`
tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Indicates if port security must be enabled or disabled. By default it is enabled',
382 PRIMARY KEY (`uuid`
),
383 UNIQUE KEY `internal_name_vm_id`
(`internal_name`
,`vm_id`
),
384 KEY `FK_interfaces_vms`
(`vm_id`
),
385 KEY `FK_interfaces_nets`
(`net_id`
),
386 CONSTRAINT `FK_interfaces_nets`
FOREIGN KEY (`net_id`
) REFERENCES `nets`
(`uuid`
) ON DELETE CASCADE,
387 CONSTRAINT `FK_interfaces_vms`
FOREIGN KEY (`vm_id`
) REFERENCES `vms`
(`uuid`
) ON DELETE CASCADE
388 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='VM interfaces';
389 /*!40101 SET character_set_client = @saved_cs_client */;
392 -- Table structure for table `ip_profiles`
395 DROP TABLE IF EXISTS `ip_profiles`
;
396 /*!40101 SET @saved_cs_client = @@character_set_client */;
397 /*!40101 SET character_set_client = utf8 */;
398 CREATE TABLE `ip_profiles`
(
399 `
id`
int(11) NOT NULL AUTO_INCREMENT
,
400 `net_id`
varchar(36) DEFAULT NULL,
401 `sce_net_id`
varchar(36) DEFAULT NULL,
402 `instance_net_id`
varchar(36) DEFAULT NULL,
403 `ip_version`
enum('IPv4','IPv6') NOT NULL DEFAULT 'IPv4',
404 `subnet_address`
varchar(64) DEFAULT NULL,
405 `gateway_address`
varchar(64) DEFAULT NULL,
406 `dns_address`
varchar(64) DEFAULT NULL,
407 `dhcp_enabled`
enum('true','false') NOT NULL DEFAULT 'true',
408 `dhcp_start_address`
varchar(64) DEFAULT NULL,
409 `dhcp_count`
int(11) DEFAULT NULL,
411 KEY `FK_ipprofiles_nets`
(`net_id`
),
412 KEY `FK_ipprofiles_scenets`
(`sce_net_id`
),
413 KEY `FK_ipprofiles_instancenets`
(`instance_net_id`
),
414 CONSTRAINT `FK_ipprofiles_instancenets`
FOREIGN KEY (`instance_net_id`
) REFERENCES `instance_nets`
(`uuid`
) ON DELETE CASCADE,
415 CONSTRAINT `FK_ipprofiles_nets`
FOREIGN KEY (`net_id`
) REFERENCES `nets`
(`uuid`
) ON DELETE CASCADE,
416 CONSTRAINT `FK_ipprofiles_scenets`
FOREIGN KEY (`sce_net_id`
) REFERENCES `sce_nets`
(`uuid`
) ON DELETE CASCADE
417 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
COMMENT='Table containing the IP parameters of a network, either a net, a sce_net or and instance_net.';
418 /*!40101 SET character_set_client = @saved_cs_client */;
421 -- Table structure for table `logs`
424 DROP TABLE IF EXISTS `logs`
;
425 /*!40101 SET @saved_cs_client = @@character_set_client */;
426 /*!40101 SET character_set_client = utf8 */;
427 CREATE TABLE `logs`
(
428 `
id`
int(10) unsigned
NOT NULL AUTO_INCREMENT
,
429 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
430 `nfvo_tenant_id`
varchar(36) DEFAULT NULL,
431 `related`
varchar(36) NOT NULL COMMENT 'Relevant element for the log',
432 `uuid`
varchar(36) DEFAULT NULL COMMENT 'Uuid of vnf, scenario, etc. that log relates to',
433 `
level`
enum('panic','error','info','debug','verbose') NOT NULL,
434 `description`
varchar(200) NOT NULL,
436 ) ENGINE
=InnoDB AUTO_INCREMENT
=3423 DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
;
437 /*!40101 SET character_set_client = @saved_cs_client */;
440 -- Table structure for table `nets`
443 DROP TABLE IF EXISTS `nets`
;
444 /*!40101 SET @saved_cs_client = @@character_set_client */;
445 /*!40101 SET character_set_client = utf8 */;
446 CREATE TABLE `nets`
(
447 `uuid`
varchar(36) NOT NULL,
448 `vnf_id`
varchar(36) NOT NULL,
449 `
name`
varchar(255) NOT NULL,
450 `
type`
enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
451 `multipoint`
enum('true','false') NOT NULL DEFAULT 'false',
452 `description`
varchar(255) DEFAULT NULL,
453 `created_at`
double NOT NULL,
454 `modified_at`
double DEFAULT NULL,
455 PRIMARY KEY (`uuid`
),
456 UNIQUE KEY `vnf_id_name`
(`vnf_id`
,`
name`
),
457 CONSTRAINT `FK_nets_vnfs`
FOREIGN KEY (`vnf_id`
) REFERENCES `vnfs`
(`uuid`
) ON DELETE CASCADE
458 ) 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.';
459 /*!40101 SET character_set_client = @saved_cs_client */;
462 -- Table structure for table `nfvo_tenants`
465 DROP TABLE IF EXISTS `nfvo_tenants`
;
466 /*!40101 SET @saved_cs_client = @@character_set_client */;
467 /*!40101 SET character_set_client = utf8 */;
468 CREATE TABLE `nfvo_tenants`
(
469 `uuid`
varchar(36) NOT NULL,
470 `
name`
varchar(255) NOT NULL,
471 `description`
varchar(255) DEFAULT NULL,
472 `created_at`
double NOT NULL,
473 `modified_at`
double DEFAULT NULL,
474 PRIMARY KEY (`uuid`
),
475 UNIQUE KEY `
name`
(`
name`
)
476 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Scenarios defined by the user';
477 /*!40101 SET character_set_client = @saved_cs_client */;
480 -- Table structure for table `sce_interfaces`
483 DROP TABLE IF EXISTS `sce_interfaces`
;
484 /*!40101 SET @saved_cs_client = @@character_set_client */;
485 /*!40101 SET character_set_client = utf8 */;
486 CREATE TABLE `sce_interfaces`
(
487 `uuid`
varchar(36) NOT NULL,
488 `sce_vnf_id`
varchar(36) NOT NULL,
489 `sce_net_id`
varchar(36) DEFAULT NULL,
490 `interface_id`
varchar(36) DEFAULT NULL,
491 `ip_address`
varchar(64) DEFAULT NULL,
492 `created_at`
double NOT NULL,
493 `modified_at`
double DEFAULT NULL,
494 PRIMARY KEY (`uuid`
),
495 KEY `FK_sce_interfaces_sce_vnfs`
(`sce_vnf_id`
),
496 KEY `FK_sce_interfaces_sce_nets`
(`sce_net_id`
),
497 KEY `FK_sce_interfaces_interfaces`
(`interface_id`
),
498 CONSTRAINT `FK_sce_interfaces_interfaces`
FOREIGN KEY (`interface_id`
) REFERENCES `interfaces`
(`uuid`
),
499 CONSTRAINT `FK_sce_interfaces_sce_nets`
FOREIGN KEY (`sce_net_id`
) REFERENCES `sce_nets`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
500 CONSTRAINT `FK_sce_interfaces_sce_vnfs`
FOREIGN KEY (`sce_vnf_id`
) REFERENCES `sce_vnfs`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
501 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='VNF interfaces in a scenario definition.';
502 /*!40101 SET character_set_client = @saved_cs_client */;
505 -- Table structure for table `sce_nets`
508 DROP TABLE IF EXISTS `sce_nets`
;
509 /*!40101 SET @saved_cs_client = @@character_set_client */;
510 /*!40101 SET character_set_client = utf8 */;
511 CREATE TABLE `sce_nets`
(
512 `uuid`
varchar(36) NOT NULL,
513 `
name`
varchar(255) NOT NULL,
514 `scenario_id`
varchar(36) DEFAULT NULL COMMENT 'NULL if net is matched to several scenarios',
515 `
type`
enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
516 `multipoint`
enum('true','false') NOT NULL DEFAULT 'true',
517 `
external`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'If external, net is already present at VIM',
518 `description`
varchar(255) DEFAULT NULL,
519 `created_at`
double NOT NULL,
520 `modified_at`
double DEFAULT NULL,
521 `graph`
varchar(2000) DEFAULT NULL,
522 PRIMARY KEY (`uuid`
),
523 KEY `FK_sce_nets_scenarios`
(`scenario_id`
),
524 CONSTRAINT `FK_sce_nets_scenarios`
FOREIGN KEY (`scenario_id`
) REFERENCES `scenarios`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
525 ) 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''.';
526 /*!40101 SET character_set_client = @saved_cs_client */;
529 -- Table structure for table `sce_vnfs`
532 DROP TABLE IF EXISTS `sce_vnfs`
;
533 /*!40101 SET @saved_cs_client = @@character_set_client */;
534 /*!40101 SET character_set_client = utf8 */;
535 CREATE TABLE `sce_vnfs`
(
536 `uuid`
varchar(36) NOT NULL,
537 `
name`
varchar(255) NOT NULL,
538 `scenario_id`
varchar(36) NOT NULL,
539 `vnf_id`
varchar(36) NOT NULL,
540 `description`
varchar(255) DEFAULT NULL,
541 `created_at`
double NOT NULL,
542 `modified_at`
double DEFAULT NULL,
543 `graph`
varchar(2000) DEFAULT NULL,
544 PRIMARY KEY (`uuid`
),
545 UNIQUE KEY `name_scenario_id`
(`
name`
,`scenario_id`
),
546 KEY `FK_sce_vnfs_scenarios`
(`scenario_id`
),
547 KEY `FK_sce_vnfs_vnfs`
(`vnf_id`
),
548 CONSTRAINT `FK_sce_vnfs_scenarios`
FOREIGN KEY (`scenario_id`
) REFERENCES `scenarios`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
549 CONSTRAINT `FK_sce_vnfs_vnfs`
FOREIGN KEY (`vnf_id`
) REFERENCES `vnfs`
(`uuid`
)
550 ) 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';
551 /*!40101 SET character_set_client = @saved_cs_client */;
554 -- Table structure for table `scenarios`
557 DROP TABLE IF EXISTS `scenarios`
;
558 /*!40101 SET @saved_cs_client = @@character_set_client */;
559 /*!40101 SET character_set_client = utf8 */;
560 CREATE TABLE `scenarios`
(
561 `uuid`
varchar(36) NOT NULL,
562 `
name`
varchar(255) NOT NULL,
563 `tenant_id`
varchar(36) DEFAULT NULL,
564 `description`
varchar(255) DEFAULT NULL,
565 `
public`
enum('true','false') NOT NULL DEFAULT 'false',
566 `created_at`
double NOT NULL,
567 `modified_at`
double DEFAULT NULL,
568 `
descriptor`
text COMMENT 'Original text descriptor used for create the scenario',
569 `cloud_config` mediumtext
,
570 PRIMARY KEY (`uuid`
),
571 KEY `FK_scenarios_nfvo_tenants`
(`tenant_id`
),
572 CONSTRAINT `FK_scenarios_nfvo_tenants`
FOREIGN KEY (`tenant_id`
) REFERENCES `nfvo_tenants`
(`uuid`
)
573 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Scenarios defined by the user';
574 /*!40101 SET character_set_client = @saved_cs_client */;
577 -- Table structure for table `schema_version`
580 DROP TABLE IF EXISTS `schema_version`
;
581 /*!40101 SET @saved_cs_client = @@character_set_client */;
582 /*!40101 SET character_set_client = utf8 */;
583 CREATE TABLE `schema_version`
(
584 `version_int`
int(11) NOT NULL COMMENT 'version as a number. Must not contain gaps',
585 `
version`
varchar(20) NOT NULL COMMENT 'version as a text',
586 `openmano_ver`
varchar(20) NOT NULL COMMENT 'openmano version',
587 `
comments`
varchar(2000) DEFAULT NULL COMMENT 'changes to database',
588 `
date`
date DEFAULT NULL,
589 PRIMARY KEY (`version_int`
)
590 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
COMMENT='database schema control version';
591 /*!40101 SET character_set_client = @saved_cs_client */;
594 -- Table structure for table `tenants_datacenters`
597 DROP TABLE IF EXISTS `tenants_datacenters`
;
598 /*!40101 SET @saved_cs_client = @@character_set_client */;
599 /*!40101 SET character_set_client = utf8 */;
600 CREATE TABLE `tenants_datacenters`
(
601 `
id`
int(11) NOT NULL AUTO_INCREMENT
,
602 `nfvo_tenant_id`
varchar(36) NOT NULL,
603 `datacenter_id`
varchar(36) NOT NULL,
604 `datacenter_tenant_id`
varchar(36) NOT NULL,
605 `created_at`
double NOT NULL,
606 `modified_at`
double DEFAULT NULL,
608 UNIQUE KEY `datacenter_nfvo_tenant`
(`datacenter_id`
,`nfvo_tenant_id`
),
609 KEY `FK_nfvo_tenants_datacenters`
(`datacenter_id`
),
610 KEY `FK_nfvo_tenants_vim_tenants`
(`datacenter_tenant_id`
),
611 KEY `FK_tenants_datacenters_nfvo_tenants`
(`nfvo_tenant_id`
),
612 CONSTRAINT `FK_tenants_datacenters_datacenter_tenants`
FOREIGN KEY (`datacenter_tenant_id`
) REFERENCES `datacenter_tenants`
(`uuid`
),
613 CONSTRAINT `FK_tenants_datacenters_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
),
614 CONSTRAINT `FK_tenants_datacenters_nfvo_tenants`
FOREIGN KEY (`nfvo_tenant_id`
) REFERENCES `nfvo_tenants`
(`uuid`
)
615 ) ENGINE
=InnoDB AUTO_INCREMENT
=86 DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Scenarios defined by the user';
616 /*!40101 SET character_set_client = @saved_cs_client */;
619 -- Table structure for table `uuids`
622 DROP TABLE IF EXISTS `uuids`
;
623 /*!40101 SET @saved_cs_client = @@character_set_client */;
624 /*!40101 SET character_set_client = utf8 */;
625 CREATE TABLE `uuids`
(
626 `uuid`
varchar(36) NOT NULL,
627 `root_uuid`
varchar(36) DEFAULT NULL COMMENT 'Some related UUIDs can be grouped by this field, so that they can be deleted at once',
628 `created_at`
double NOT NULL,
629 `used_at`
varchar(36) DEFAULT NULL COMMENT 'Table that uses this UUID',
631 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
COMMENT='Table with all unique IDs used to avoid UUID repetitions among different elements';
632 /*!40101 SET character_set_client = @saved_cs_client */;
635 -- Table structure for table `vms`
638 DROP TABLE IF EXISTS `vms`
;
639 /*!40101 SET @saved_cs_client = @@character_set_client */;
640 /*!40101 SET character_set_client = utf8 */;
642 `uuid`
varchar(36) NOT NULL,
643 `
name`
varchar(255) NOT NULL,
644 `vnf_id`
varchar(36) NOT NULL,
645 `flavor_id`
varchar(36) NOT NULL COMMENT 'Link to flavor table',
646 `image_id`
varchar(36) NOT NULL COMMENT 'Link to image table',
647 `image_path`
varchar(100) DEFAULT NULL COMMENT 'Path where the image of the VM is located',
649 `description`
varchar(255) DEFAULT NULL,
650 `created_at`
double NOT NULL,
651 `modified_at`
double DEFAULT NULL,
652 PRIMARY KEY (`uuid`
),
653 UNIQUE KEY `name_vnf_id`
(`
name`
,`vnf_id`
),
654 KEY `FK_vms_vnfs`
(`vnf_id`
),
655 KEY `FK_vms_images`
(`image_id`
),
656 KEY `FK_vms_flavors`
(`flavor_id`
),
657 CONSTRAINT `FK_vms_flavors`
FOREIGN KEY (`flavor_id`
) REFERENCES `flavors`
(`uuid`
),
658 CONSTRAINT `FK_vms_images`
FOREIGN KEY (`image_id`
) REFERENCES `images`
(`uuid`
),
659 CONSTRAINT `FK_vms_vnfs`
FOREIGN KEY (`vnf_id`
) REFERENCES `vnfs`
(`uuid`
) ON DELETE CASCADE
660 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='VM definitions. It contains the set of VMs used by the VNF definitions.';
661 /*!40101 SET character_set_client = @saved_cs_client */;
664 -- Table structure for table `vnfs`
667 DROP TABLE IF EXISTS `vnfs`
;
668 /*!40101 SET @saved_cs_client = @@character_set_client */;
669 /*!40101 SET character_set_client = utf8 */;
670 CREATE TABLE `vnfs`
(
671 `uuid`
varchar(36) NOT NULL,
672 `
name`
varchar(255) NOT NULL,
673 `tenant_id`
varchar(36) DEFAULT NULL,
674 `physical`
enum('true','false') NOT NULL DEFAULT 'false',
675 `
public`
enum('true','false') NOT NULL DEFAULT 'false',
676 `description`
varchar(255) DEFAULT NULL,
677 `created_at`
double NOT NULL,
678 `modified_at`
double DEFAULT NULL,
679 `
class`
varchar(36) DEFAULT 'MISC',
680 `
descriptor`
text COMMENT 'Original text descriptor used for create the VNF',
681 PRIMARY KEY (`uuid`
),
682 KEY `FK_vnfs_nfvo_tenants`
(`tenant_id`
),
683 CONSTRAINT `FK_vnfs_nfvo_tenants`
FOREIGN KEY (`tenant_id`
) REFERENCES `nfvo_tenants`
(`uuid`
) ON DELETE SET NULL ON UPDATE CASCADE
684 ) 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';
685 /*!40101 SET character_set_client = @saved_cs_client */;
688 -- Dumping routines for database '{{mano_db}}'
690 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
692 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
693 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
694 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
695 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
696 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
697 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
698 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
700 -- Dump completed on 2017-05-03 11:39:20
706 -- MySQL dump 10.13 Distrib 5.7.18, for Linux (x86_64)
708 -- Host: localhost Database: {{mano_db}}
709 -- ------------------------------------------------------
710 -- Server version 5.7.18-0ubuntu0.16.04.1
712 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
713 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
714 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
715 /*!40101 SET NAMES utf8 */;
716 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
717 /*!40103 SET TIME_ZONE='+00:00' */;
718 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
719 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
720 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
721 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
724 -- Dumping data for table `schema_version`
727 LOCK TABLES `schema_version`
WRITE;
728 /*!40000 ALTER TABLE `schema_version` DISABLE KEYS */;
729 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');
730 /*!40000 ALTER TABLE `schema_version` ENABLE KEYS */;
732 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
734 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
735 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
736 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
737 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
738 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
739 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
740 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
742 -- Dump completed on 2017-05-03 11:39:20