2 * Copyright 2015 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.5.43, for debian-linux-gnu (x86_64)
24 -- Host: localhost Database: mano_db
25 -- ------------------------------------------------------
26 -- Server version 5.5.43-0ubuntu0.14.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(64) DEFAULT NULL,
85 `vim_tenant_id`
varchar(36) 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 `created_at`
double NOT NULL,
90 `modified_at`
double DEFAULT NULL,
92 KEY `FK_vim_tenants_datacenters`
(`datacenter_id`
),
93 CONSTRAINT `FK_vim_tenants_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
94 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Scenarios defined by the user';
95 /*!40101 SET character_set_client = @saved_cs_client */;
98 -- Table structure for table `datacenters`
101 DROP TABLE IF EXISTS `datacenters`
;
102 /*!40101 SET @saved_cs_client = @@character_set_client */;
103 /*!40101 SET character_set_client = utf8 */;
104 CREATE TABLE `datacenters`
(
105 `uuid`
varchar(36) NOT NULL,
106 `
name`
varchar(255) NOT NULL,
107 `description`
varchar(255) DEFAULT NULL,
108 `
type`
varchar(36) NOT NULL DEFAULT 'openvim',
109 `vim_url`
varchar(150) NOT NULL COMMENT 'URL of the VIM for the REST API',
110 `vim_url_admin`
varchar(150) DEFAULT NULL,
111 `config`
varchar(4000) DEFAULT NULL COMMENT 'extra config information in json',
112 `created_at`
double NOT NULL,
113 `modified_at`
double DEFAULT NULL,
114 PRIMARY KEY (`uuid`
),
115 UNIQUE KEY `
name`
(`
name`
)
116 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Datacenters managed by the NFVO.';
117 /*!40101 SET character_set_client = @saved_cs_client */;
120 -- Table structure for table `datacenters_flavors`
123 DROP TABLE IF EXISTS `datacenters_flavors`
;
124 /*!40101 SET @saved_cs_client = @@character_set_client */;
125 /*!40101 SET character_set_client = utf8 */;
126 CREATE TABLE `datacenters_flavors`
(
127 `
id`
int(11) NOT NULL AUTO_INCREMENT
,
128 `flavor_id`
varchar(36) NOT NULL,
129 `datacenter_id`
varchar(36) NOT NULL,
130 `vim_id`
varchar(36) NOT NULL,
131 `created`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if it has been created by openmano, or already existed',
133 KEY `FK__flavors`
(`flavor_id`
),
134 KEY `FK__datacenters_f`
(`datacenter_id`
),
135 CONSTRAINT `FK__datacenters_f`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
136 CONSTRAINT `FK__flavors`
FOREIGN KEY (`flavor_id`
) REFERENCES `flavors`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
137 ) ENGINE
=InnoDB AUTO_INCREMENT
=7 DEFAULT CHARSET
=utf8
;
138 /*!40101 SET character_set_client = @saved_cs_client */;
141 -- Table structure for table `datacenters_images`
144 DROP TABLE IF EXISTS `datacenters_images`
;
145 /*!40101 SET @saved_cs_client = @@character_set_client */;
146 /*!40101 SET character_set_client = utf8 */;
147 CREATE TABLE `datacenters_images`
(
148 `
id`
int(11) NOT NULL AUTO_INCREMENT
,
149 `image_id`
varchar(36) NOT NULL,
150 `datacenter_id`
varchar(36) NOT NULL,
151 `vim_id`
varchar(36) NOT NULL,
152 `created`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if it has been created by openmano, or already existed',
154 KEY `FK__images`
(`image_id`
),
155 KEY `FK__datacenters_i`
(`datacenter_id`
),
156 CONSTRAINT `FK__datacenters_i`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
157 CONSTRAINT `FK__images`
FOREIGN KEY (`image_id`
) REFERENCES `images`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
158 ) ENGINE
=InnoDB AUTO_INCREMENT
=6 DEFAULT CHARSET
=utf8
;
159 /*!40101 SET character_set_client = @saved_cs_client */;
162 -- Table structure for table `flavors`
165 DROP TABLE IF EXISTS `flavors`
;
166 /*!40101 SET @saved_cs_client = @@character_set_client */;
167 /*!40101 SET character_set_client = utf8 */;
168 CREATE TABLE `flavors`
(
169 `uuid`
varchar(36) NOT NULL,
170 `
name`
varchar(255) NOT NULL,
171 `description`
varchar(255) DEFAULT NULL,
172 `disk`
smallint(5) unsigned
DEFAULT NULL,
173 `ram`
smallint(5) unsigned
DEFAULT NULL,
174 `vcpus`
smallint(5) unsigned
DEFAULT NULL,
175 `extended`
varchar(2000) DEFAULT NULL COMMENT 'Extra description json format of needed resources and pining, orginized in sets per numa',
177 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
;
178 /*!40101 SET character_set_client = @saved_cs_client */;
181 -- Table structure for table `images`
184 DROP TABLE IF EXISTS `images`
;
185 /*!40101 SET @saved_cs_client = @@character_set_client */;
186 /*!40101 SET character_set_client = utf8 */;
187 CREATE TABLE `images`
(
188 `uuid`
varchar(36) NOT NULL,
189 `
name`
varchar(255) NOT NULL,
190 `
location`
varchar(200) NOT NULL,
191 `description`
varchar(255) DEFAULT NULL,
192 `metadata`
varchar(2000) DEFAULT NULL,
193 PRIMARY KEY (`uuid`
),
194 UNIQUE KEY `
location`
(`
location`
)
195 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
;
196 /*!40101 SET character_set_client = @saved_cs_client */;
199 -- Table structure for table `instance_interfaces`
202 DROP TABLE IF EXISTS `instance_interfaces`
;
203 /*!40101 SET @saved_cs_client = @@character_set_client */;
204 /*!40101 SET character_set_client = utf8 */;
205 CREATE TABLE `instance_interfaces`
(
206 `uuid`
varchar(36) NOT NULL,
207 `instance_vm_id`
varchar(36) NOT NULL,
208 `instance_net_id`
varchar(36) NOT NULL,
209 `interface_id`
varchar(36) NOT NULL,
210 `vim_interface_id`
varchar(36) DEFAULT NULL COMMENT 'vim identity for that interface',
211 `mac_address`
varchar(32) DEFAULT NULL,
212 `ip_address`
varchar(64) DEFAULT NULL,
214 `
type`
enum('internal','external') NOT NULL COMMENT 'Indicates if this interface is external to a vnf, or internal',
215 PRIMARY KEY (`uuid`
),
216 KEY `FK_instance_vms`
(`instance_vm_id`
),
217 KEY `FK_instance_nets`
(`instance_net_id`
),
218 KEY `FK_instance_ids`
(`interface_id`
),
219 CONSTRAINT `FK_instance_ids`
FOREIGN KEY (`interface_id`
) REFERENCES `interfaces`
(`uuid`
),
220 CONSTRAINT `FK_instance_nets`
FOREIGN KEY (`instance_net_id`
) REFERENCES `instance_nets`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
221 CONSTRAINT `FK_instance_vms`
FOREIGN KEY (`instance_vm_id`
) REFERENCES `instance_vms`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
222 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Table with all running associattion among VM instances and net instances';
223 /*!40101 SET character_set_client = @saved_cs_client */;
226 -- Table structure for table `instance_nets`
229 DROP TABLE IF EXISTS `instance_nets`
;
230 /*!40101 SET @saved_cs_client = @@character_set_client */;
231 /*!40101 SET character_set_client = utf8 */;
232 CREATE TABLE `instance_nets`
(
233 `uuid`
varchar(36) NOT NULL,
234 `vim_net_id`
varchar(36) NOT NULL COMMENT 'Network ID in the VIM DB',
235 `instance_scenario_id`
varchar(36) NOT NULL,
236 `sce_net_id`
varchar(36) DEFAULT NULL,
237 `net_id`
varchar(36) DEFAULT NULL,
238 `datacenter_id`
varchar(36) DEFAULT NULL,
239 `datacenter_tenant_id`
varchar(36) NOT NULL,
240 `status`
enum('ACTIVE','DOWN','BUILD','ERROR','VIM_ERROR','INACTIVE','DELETED') NOT NULL DEFAULT 'BUILD',
241 `error_msg`
varchar(1024) DEFAULT NULL,
243 `multipoint`
enum('true','false') NOT NULL DEFAULT 'true',
244 `
external`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'If external, means that it already exists at VIM',
245 `created_at`
double NOT NULL,
246 `modified_at`
double DEFAULT NULL,
247 PRIMARY KEY (`uuid`
),
248 UNIQUE KEY `vim_net_id_instance_scenario_id`
(`vim_net_id`
,`instance_scenario_id`
),
249 KEY `FK_instance_nets_instance_scenarios`
(`instance_scenario_id`
),
250 KEY `FK_instance_nets_sce_nets`
(`sce_net_id`
),
251 KEY `FK_instance_nets_nets`
(`net_id`
),
252 KEY `FK_instance_nets_datacenters`
(`datacenter_id`
),
253 KEY `FK_instance_nets_datacenter_tenants`
(`datacenter_tenant_id`
),
254 CONSTRAINT `FK_instance_nets_datacenter_tenants`
FOREIGN KEY (`datacenter_tenant_id`
) REFERENCES `datacenter_tenants`
(`uuid`
),
255 CONSTRAINT `FK_instance_nets_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
),
256 CONSTRAINT `FK_instance_nets_instance_scenarios`
FOREIGN KEY (`instance_scenario_id`
) REFERENCES `instance_scenarios`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
257 CONSTRAINT `FK_instance_nets_nets`
FOREIGN KEY (`net_id`
) REFERENCES `nets`
(`uuid`
) ON DELETE SET NULL ON UPDATE CASCADE,
258 CONSTRAINT `FK_instance_nets_sce_nets`
FOREIGN KEY (`sce_net_id`
) REFERENCES `sce_nets`
(`uuid`
) ON DELETE SET NULL ON UPDATE CASCADE
259 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Instances of networks';
260 /*!40101 SET character_set_client = @saved_cs_client */;
263 -- Table structure for table `instance_scenarios`
266 DROP TABLE IF EXISTS `instance_scenarios`
;
267 /*!40101 SET @saved_cs_client = @@character_set_client */;
268 /*!40101 SET character_set_client = utf8 */;
269 CREATE TABLE `instance_scenarios`
(
270 `uuid`
varchar(36) NOT NULL,
271 `
name`
varchar(255) NOT NULL,
272 `tenant_id`
varchar(36) DEFAULT NULL,
273 `scenario_id`
varchar(36) NOT NULL,
274 `datacenter_id`
varchar(36) NOT NULL,
275 `datacenter_tenant_id`
varchar(36) NOT NULL,
276 `description`
varchar(255) DEFAULT NULL,
277 `created_at`
double NOT NULL,
278 `modified_at`
double DEFAULT NULL,
279 PRIMARY KEY (`uuid`
),
280 UNIQUE KEY `
name`
(`
name`
),
281 KEY `FK_scenarios_nfvo_tenants`
(`tenant_id`
),
282 KEY `FK_instance_scenarios_vim_tenants`
(`datacenter_tenant_id`
),
283 KEY `FK_instance_scenarios_datacenters`
(`datacenter_id`
),
284 KEY `FK_instance_scenarios_scenarios`
(`scenario_id`
),
285 CONSTRAINT `FK_instance_scenarios_datacenter_tenants`
FOREIGN KEY (`datacenter_tenant_id`
) REFERENCES `datacenter_tenants`
(`uuid`
),
286 CONSTRAINT `FK_instance_scenarios_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
),
287 CONSTRAINT `FK_instance_scenarios_nfvo_tenants`
FOREIGN KEY (`tenant_id`
) REFERENCES `nfvo_tenants`
(`uuid`
),
288 CONSTRAINT `FK_instance_scenarios_scenarios`
FOREIGN KEY (`scenario_id`
) REFERENCES `scenarios`
(`uuid`
)
289 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Instances of scenarios defined by the user';
290 /*!40101 SET character_set_client = @saved_cs_client */;
293 -- Table structure for table `instance_vms`
296 DROP TABLE IF EXISTS `instance_vms`
;
297 /*!40101 SET @saved_cs_client = @@character_set_client */;
298 /*!40101 SET character_set_client = utf8 */;
299 CREATE TABLE `instance_vms`
(
300 `uuid`
varchar(36) NOT NULL,
301 `instance_vnf_id`
varchar(36) NOT NULL,
302 `vm_id`
varchar(36) NOT NULL,
303 `vim_vm_id`
varchar(36) NOT NULL COMMENT 'VM ID in the VIM DB',
304 `status`
enum('ACTIVE:NoMgmtIP','ACTIVE','INACTIVE','BUILD','ERROR','VIM_ERROR','PAUSED','SUSPENDED','DELETED') NOT NULL DEFAULT 'BUILD',
305 `error_msg`
varchar(1024) DEFAULT NULL,
307 `created_at`
double NOT NULL,
308 `modified_at`
double DEFAULT NULL,
309 PRIMARY KEY (`uuid`
),
310 UNIQUE KEY `vim_vm_id`
(`vim_vm_id`
),
311 KEY `FK_instance_vms_vms`
(`vm_id`
),
312 KEY `FK_instance_vms_instance_vnfs`
(`instance_vnf_id`
),
313 CONSTRAINT `FK_instance_vms_instance_vnfs`
FOREIGN KEY (`instance_vnf_id`
) REFERENCES `instance_vnfs`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
314 CONSTRAINT `FK_instance_vms_vms`
FOREIGN KEY (`vm_id`
) REFERENCES `vms`
(`uuid`
)
315 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Instances of VMs as part of VNF instances';
316 /*!40101 SET character_set_client = @saved_cs_client */;
319 -- Table structure for table `instance_vnfs`
322 DROP TABLE IF EXISTS `instance_vnfs`
;
323 /*!40101 SET @saved_cs_client = @@character_set_client */;
324 /*!40101 SET character_set_client = utf8 */;
325 CREATE TABLE `instance_vnfs`
(
326 `uuid`
varchar(36) NOT NULL,
327 `instance_scenario_id`
varchar(36) NOT NULL,
328 `vnf_id`
varchar(36) NOT NULL,
329 `sce_vnf_id`
varchar(36) DEFAULT NULL,
330 `datacenter_id`
varchar(36) DEFAULT NULL,
331 `datacenter_tenant_id`
varchar(36) DEFAULT NULL,
332 `created_at`
double NOT NULL,
333 `modified_at`
double DEFAULT NULL,
334 PRIMARY KEY (`uuid`
),
335 KEY `FK_instance_vnfs_vnfs`
(`vnf_id`
),
336 KEY `FK_instance_vnfs_instance_scenarios`
(`instance_scenario_id`
),
337 KEY `FK_instance_vnfs_sce_vnfs`
(`sce_vnf_id`
),
338 KEY `FK_instance_vnfs_datacenters`
(`datacenter_id`
),
339 KEY `FK_instance_vnfs_datacenter_tenants`
(`datacenter_tenant_id`
),
340 CONSTRAINT `FK_instance_vnfs_datacenter_tenants`
FOREIGN KEY (`datacenter_tenant_id`
) REFERENCES `datacenter_tenants`
(`uuid`
),
341 CONSTRAINT `FK_instance_vnfs_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
),
342 CONSTRAINT `FK_instance_vnfs_instance_scenarios`
FOREIGN KEY (`instance_scenario_id`
) REFERENCES `instance_scenarios`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
343 CONSTRAINT `FK_instance_vnfs_sce_vnfs`
FOREIGN KEY (`sce_vnf_id`
) REFERENCES `sce_vnfs`
(`uuid`
) ON DELETE SET NULL ON UPDATE CASCADE,
344 CONSTRAINT `FK_instance_vnfs_vnfs`
FOREIGN KEY (`vnf_id`
) REFERENCES `vnfs`
(`uuid`
)
345 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Instances of VNFs as part of a scenario';
346 /*!40101 SET character_set_client = @saved_cs_client */;
349 -- Table structure for table `interfaces`
352 DROP TABLE IF EXISTS `interfaces`
;
353 /*!40101 SET @saved_cs_client = @@character_set_client */;
354 /*!40101 SET character_set_client = utf8 */;
355 CREATE TABLE `interfaces`
(
356 `uuid`
varchar(36) NOT NULL,
357 `internal_name`
varchar(255) NOT NULL,
358 `external_name`
varchar(255) DEFAULT NULL,
359 `vm_id`
varchar(36) NOT NULL,
360 `net_id`
varchar(36) DEFAULT NULL,
361 `
type`
enum('mgmt','bridge','data') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
362 `vpci`
char(12) DEFAULT NULL,
363 `bw`
mediumint(8) unsigned
DEFAULT NULL COMMENT 'BW expressed in Mbits/s. Maybe this field is not necessary.',
364 `created_at`
double NOT NULL,
365 `modified_at`
double DEFAULT NULL,
366 `model`
varchar(12) DEFAULT NULL,
367 `mac`
char(18) DEFAULT NULL,
368 PRIMARY KEY (`uuid`
),
369 UNIQUE KEY `internal_name_vm_id`
(`internal_name`
,`vm_id`
),
370 KEY `FK_interfaces_vms`
(`vm_id`
),
371 KEY `FK_interfaces_nets`
(`net_id`
),
372 CONSTRAINT `FK_interfaces_nets`
FOREIGN KEY (`net_id`
) REFERENCES `nets`
(`uuid`
) ON DELETE CASCADE,
373 CONSTRAINT `FK_interfaces_vms`
FOREIGN KEY (`vm_id`
) REFERENCES `vms`
(`uuid`
) ON DELETE CASCADE
374 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='VM interfaces';
375 /*!40101 SET character_set_client = @saved_cs_client */;
378 -- Table structure for table `logs`
381 DROP TABLE IF EXISTS `logs`
;
382 /*!40101 SET @saved_cs_client = @@character_set_client */;
383 /*!40101 SET character_set_client = utf8 */;
384 CREATE TABLE `logs`
(
385 `
id`
int(10) unsigned
NOT NULL AUTO_INCREMENT
,
386 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
387 `nfvo_tenant_id`
varchar(36) DEFAULT NULL,
388 `related`
varchar(36) NOT NULL COMMENT 'Relevant element for the log',
389 `uuid`
varchar(36) DEFAULT NULL COMMENT 'Uuid of vnf, scenario, etc. that log relates to',
390 `
level`
enum('panic','error','info','debug','verbose') NOT NULL,
391 `description`
varchar(200) NOT NULL,
393 ) ENGINE
=InnoDB AUTO_INCREMENT
=3423 DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
;
394 /*!40101 SET character_set_client = @saved_cs_client */;
397 -- Table structure for table `nets`
400 DROP TABLE IF EXISTS `nets`
;
401 /*!40101 SET @saved_cs_client = @@character_set_client */;
402 /*!40101 SET character_set_client = utf8 */;
403 CREATE TABLE `nets`
(
404 `uuid`
varchar(36) NOT NULL,
405 `vnf_id`
varchar(36) NOT NULL,
406 `
name`
varchar(255) NOT NULL,
407 `
type`
enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
408 `multipoint`
enum('true','false') NOT NULL DEFAULT 'false',
409 `description`
varchar(255) DEFAULT NULL,
410 `created_at`
double NOT NULL,
411 `modified_at`
double DEFAULT NULL,
412 PRIMARY KEY (`uuid`
),
413 UNIQUE KEY `vnf_id_name`
(`vnf_id`
,`
name`
),
414 CONSTRAINT `FK_nets_vnfs`
FOREIGN KEY (`vnf_id`
) REFERENCES `vnfs`
(`uuid`
) ON DELETE CASCADE
415 ) 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.';
416 /*!40101 SET character_set_client = @saved_cs_client */;
419 -- Table structure for table `nfvo_tenants`
422 DROP TABLE IF EXISTS `nfvo_tenants`
;
423 /*!40101 SET @saved_cs_client = @@character_set_client */;
424 /*!40101 SET character_set_client = utf8 */;
425 CREATE TABLE `nfvo_tenants`
(
426 `uuid`
varchar(36) NOT NULL,
427 `
name`
varchar(255) NOT NULL,
428 `description`
varchar(255) DEFAULT NULL,
429 `created_at`
double NOT NULL,
430 `modified_at`
double DEFAULT NULL,
431 PRIMARY KEY (`uuid`
),
432 UNIQUE KEY `
name`
(`
name`
)
433 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Scenarios defined by the user';
434 /*!40101 SET character_set_client = @saved_cs_client */;
437 -- Table structure for table `sce_interfaces`
440 DROP TABLE IF EXISTS `sce_interfaces`
;
441 /*!40101 SET @saved_cs_client = @@character_set_client */;
442 /*!40101 SET character_set_client = utf8 */;
443 CREATE TABLE `sce_interfaces`
(
444 `uuid`
varchar(36) NOT NULL,
445 `sce_vnf_id`
varchar(36) NOT NULL,
446 `sce_net_id`
varchar(36) DEFAULT NULL,
447 `interface_id`
varchar(36) DEFAULT NULL,
448 `created_at`
double NOT NULL,
449 `modified_at`
double DEFAULT NULL,
450 PRIMARY KEY (`uuid`
),
451 KEY `FK_sce_interfaces_sce_vnfs`
(`sce_vnf_id`
),
452 KEY `FK_sce_interfaces_sce_nets`
(`sce_net_id`
),
453 KEY `FK_sce_interfaces_interfaces`
(`interface_id`
),
454 CONSTRAINT `FK_sce_interfaces_interfaces`
FOREIGN KEY (`interface_id`
) REFERENCES `interfaces`
(`uuid`
),
455 CONSTRAINT `FK_sce_interfaces_sce_nets`
FOREIGN KEY (`sce_net_id`
) REFERENCES `sce_nets`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
456 CONSTRAINT `FK_sce_interfaces_sce_vnfs`
FOREIGN KEY (`sce_vnf_id`
) REFERENCES `sce_vnfs`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
457 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='VNF interfaces in a scenario definition.';
458 /*!40101 SET character_set_client = @saved_cs_client */;
461 -- Table structure for table `sce_nets`
464 DROP TABLE IF EXISTS `sce_nets`
;
465 /*!40101 SET @saved_cs_client = @@character_set_client */;
466 /*!40101 SET character_set_client = utf8 */;
467 CREATE TABLE `sce_nets`
(
468 `uuid`
varchar(36) NOT NULL,
469 `
name`
varchar(255) NOT NULL,
470 `scenario_id`
varchar(36) DEFAULT NULL COMMENT 'NULL if net is matched to several scenarios',
471 `
type`
enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
472 `multipoint`
enum('true','false') NOT NULL DEFAULT 'true',
473 `
external`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'If external, net is already present at VIM',
474 `description`
varchar(255) DEFAULT NULL,
475 `created_at`
double NOT NULL,
476 `modified_at`
double DEFAULT NULL,
477 `graph`
varchar(2000) DEFAULT NULL,
478 PRIMARY KEY (`uuid`
),
479 KEY `FK_sce_nets_scenarios`
(`scenario_id`
),
480 CONSTRAINT `FK_sce_nets_scenarios`
FOREIGN KEY (`scenario_id`
) REFERENCES `scenarios`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
481 ) 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''.';
482 /*!40101 SET character_set_client = @saved_cs_client */;
485 -- Table structure for table `sce_vnfs`
488 DROP TABLE IF EXISTS `sce_vnfs`
;
489 /*!40101 SET @saved_cs_client = @@character_set_client */;
490 /*!40101 SET character_set_client = utf8 */;
491 CREATE TABLE `sce_vnfs`
(
492 `uuid`
varchar(36) NOT NULL,
493 `
name`
varchar(255) NOT NULL,
494 `scenario_id`
varchar(36) NOT NULL,
495 `vnf_id`
varchar(36) NOT NULL,
496 `description`
varchar(255) DEFAULT NULL,
497 `created_at`
double NOT NULL,
498 `modified_at`
double DEFAULT NULL,
499 `graph`
varchar(2000) DEFAULT NULL,
500 PRIMARY KEY (`uuid`
),
501 UNIQUE KEY `name_scenario_id`
(`
name`
,`scenario_id`
),
502 KEY `FK_sce_vnfs_scenarios`
(`scenario_id`
),
503 KEY `FK_sce_vnfs_vnfs`
(`vnf_id`
),
504 CONSTRAINT `FK_sce_vnfs_scenarios`
FOREIGN KEY (`scenario_id`
) REFERENCES `scenarios`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
505 CONSTRAINT `FK_sce_vnfs_vnfs`
FOREIGN KEY (`vnf_id`
) REFERENCES `vnfs`
(`uuid`
)
506 ) 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';
507 /*!40101 SET character_set_client = @saved_cs_client */;
510 -- Table structure for table `scenarios`
513 DROP TABLE IF EXISTS `scenarios`
;
514 /*!40101 SET @saved_cs_client = @@character_set_client */;
515 /*!40101 SET character_set_client = utf8 */;
516 CREATE TABLE `scenarios`
(
517 `uuid`
varchar(36) NOT NULL,
518 `
name`
varchar(255) NOT NULL,
519 `tenant_id`
varchar(36) DEFAULT NULL,
520 `description`
varchar(255) DEFAULT NULL,
521 `
public`
enum('true','false') NOT NULL DEFAULT 'false',
522 `created_at`
double NOT NULL,
523 `modified_at`
double DEFAULT NULL,
524 `
descriptor`
text COMMENT 'Original text descriptor used for create the scenario',
525 PRIMARY KEY (`uuid`
),
526 UNIQUE KEY `
name`
(`
name`
),
527 KEY `FK_scenarios_nfvo_tenants`
(`tenant_id`
),
528 CONSTRAINT `FK_scenarios_nfvo_tenants`
FOREIGN KEY (`tenant_id`
) REFERENCES `nfvo_tenants`
(`uuid`
)
529 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Scenarios defined by the user';
530 /*!40101 SET character_set_client = @saved_cs_client */;
533 -- Table structure for table `schema_version`
536 DROP TABLE IF EXISTS `schema_version`
;
537 /*!40101 SET @saved_cs_client = @@character_set_client */;
538 /*!40101 SET character_set_client = utf8 */;
539 CREATE TABLE `schema_version`
(
540 `version_int`
int(11) NOT NULL COMMENT 'version as a number. Must not contain gaps',
541 `
version`
varchar(20) NOT NULL COMMENT 'version as a text',
542 `openmano_ver`
varchar(20) NOT NULL COMMENT 'openmano version',
543 `
comments`
varchar(2000) DEFAULT NULL COMMENT 'changes to database',
544 `
date`
date DEFAULT NULL,
545 PRIMARY KEY (`version_int`
)
546 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
COMMENT='database schema control version';
547 /*!40101 SET character_set_client = @saved_cs_client */;
550 -- Table structure for table `tenants_datacenters`
553 DROP TABLE IF EXISTS `tenants_datacenters`
;
554 /*!40101 SET @saved_cs_client = @@character_set_client */;
555 /*!40101 SET character_set_client = utf8 */;
556 CREATE TABLE `tenants_datacenters`
(
557 `
id`
int(11) NOT NULL AUTO_INCREMENT
,
558 `nfvo_tenant_id`
varchar(36) NOT NULL,
559 `datacenter_id`
varchar(36) NOT NULL,
560 `datacenter_tenant_id`
varchar(36) NOT NULL,
561 `created_at`
double NOT NULL,
562 `modified_at`
double DEFAULT NULL,
564 UNIQUE KEY `datacenter_nfvo_tenant`
(`datacenter_id`
,`nfvo_tenant_id`
),
565 KEY `FK_nfvo_tenants_datacenters`
(`datacenter_id`
),
566 KEY `FK_nfvo_tenants_vim_tenants`
(`datacenter_tenant_id`
),
567 KEY `FK_tenants_datacenters_nfvo_tenants`
(`nfvo_tenant_id`
),
568 CONSTRAINT `FK_tenants_datacenters_datacenter_tenants`
FOREIGN KEY (`datacenter_tenant_id`
) REFERENCES `datacenter_tenants`
(`uuid`
),
569 CONSTRAINT `FK_tenants_datacenters_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
),
570 CONSTRAINT `FK_tenants_datacenters_nfvo_tenants`
FOREIGN KEY (`nfvo_tenant_id`
) REFERENCES `nfvo_tenants`
(`uuid`
)
571 ) ENGINE
=InnoDB AUTO_INCREMENT
=86 DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Scenarios defined by the user';
572 /*!40101 SET character_set_client = @saved_cs_client */;
575 -- Table structure for table `uuids`
578 DROP TABLE IF EXISTS `uuids`
;
579 /*!40101 SET @saved_cs_client = @@character_set_client */;
580 /*!40101 SET character_set_client = utf8 */;
581 CREATE TABLE `uuids`
(
582 `uuid`
varchar(36) NOT NULL,
583 `root_uuid`
varchar(36) DEFAULT NULL COMMENT 'Some related UUIDs can be grouped by this field, so that they can be deleted at once',
584 `created_at`
double NOT NULL,
585 `used_at`
varchar(36) DEFAULT NULL COMMENT 'Table that uses this UUID',
587 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
COMMENT='Table with all unique IDs used to avoid UUID repetitions among different elements';
588 /*!40101 SET character_set_client = @saved_cs_client */;
591 -- Table structure for table `vms`
594 DROP TABLE IF EXISTS `vms`
;
595 /*!40101 SET @saved_cs_client = @@character_set_client */;
596 /*!40101 SET character_set_client = utf8 */;
598 `uuid`
varchar(36) NOT NULL,
599 `
name`
varchar(255) NOT NULL,
600 `vnf_id`
varchar(36) NOT NULL,
601 `flavor_id`
varchar(36) NOT NULL COMMENT 'Link to flavor table',
602 `image_id`
varchar(36) NOT NULL COMMENT 'Link to image table',
603 `image_path`
varchar(100) NOT NULL COMMENT 'Path where the image of the VM is located',
604 `description`
varchar(255) DEFAULT NULL,
605 `created_at`
double NOT NULL,
606 `modified_at`
double DEFAULT NULL,
607 PRIMARY KEY (`uuid`
),
608 UNIQUE KEY `name_vnf_id`
(`
name`
,`vnf_id`
),
609 KEY `FK_vms_vnfs`
(`vnf_id`
),
610 KEY `FK_vms_images`
(`image_id`
),
611 KEY `FK_vms_flavors`
(`flavor_id`
),
612 CONSTRAINT `FK_vms_flavors`
FOREIGN KEY (`flavor_id`
) REFERENCES `flavors`
(`uuid`
),
613 CONSTRAINT `FK_vms_images`
FOREIGN KEY (`image_id`
) REFERENCES `images`
(`uuid`
),
614 CONSTRAINT `FK_vms_vnfs`
FOREIGN KEY (`vnf_id`
) REFERENCES `vnfs`
(`uuid`
) ON DELETE CASCADE
615 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='VM definitions. It contains the set of VMs used by the VNF definitions.';
616 /*!40101 SET character_set_client = @saved_cs_client */;
619 -- Table structure for table `vnfs`
622 DROP TABLE IF EXISTS `vnfs`
;
623 /*!40101 SET @saved_cs_client = @@character_set_client */;
624 /*!40101 SET character_set_client = utf8 */;
625 CREATE TABLE `vnfs`
(
626 `uuid`
varchar(36) NOT NULL,
627 `
name`
varchar(255) NOT NULL,
628 `tenant_id`
varchar(36) DEFAULT NULL,
629 `physical`
enum('true','false') NOT NULL DEFAULT 'false',
630 `
public`
enum('true','false') NOT NULL DEFAULT 'false',
631 `description`
varchar(255) DEFAULT NULL,
632 `created_at`
double NOT NULL,
633 `modified_at`
double DEFAULT NULL,
634 `
class`
varchar(36) DEFAULT 'MISC',
635 `
descriptor`
text COMMENT 'Original text descriptor used for create the VNF',
636 PRIMARY KEY (`uuid`
),
637 KEY `FK_vnfs_nfvo_tenants`
(`tenant_id`
),
638 CONSTRAINT `FK_vnfs_nfvo_tenants`
FOREIGN KEY (`tenant_id`
) REFERENCES `nfvo_tenants`
(`uuid`
) ON DELETE SET NULL ON UPDATE CASCADE
639 ) 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';
640 /*!40101 SET character_set_client = @saved_cs_client */;
643 -- Dumping routines for database 'mano_db'
645 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
647 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
648 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
649 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
650 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
651 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
652 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
653 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
655 -- Dump completed on 2016-05-13 12:23:52
661 -- MySQL dump 10.13 Distrib 5.5.43, for debian-linux-gnu (x86_64)
663 -- Host: localhost Database: mano_db
664 -- ------------------------------------------------------
665 -- Server version 5.5.43-0ubuntu0.14.04.1
667 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
668 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
669 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
670 /*!40101 SET NAMES utf8 */;
671 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
672 /*!40103 SET TIME_ZONE='+00:00' */;
673 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
674 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
675 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
676 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
679 -- Dumping data for table `schema_version`
682 LOCK TABLES `schema_version`
WRITE;
683 /*!40000 ALTER TABLE `schema_version` DISABLE KEYS */;
684 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');
685 /*!40000 ALTER TABLE `schema_version` ENABLE KEYS */;
687 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
689 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
690 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
691 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
692 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
693 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
694 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
695 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
697 -- Dump completed on 2016-05-13 12:23:52