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
21 -- MySQL dump 10.13 Distrib 5.5.35, for debian-linux-gnu (x86_64)
23 -- Host: localhost Database: mano_db
24 -- ------------------------------------------------------
25 -- Server version 5.5.35-1ubuntu1
27 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
28 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
29 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
30 /*!40101 SET NAMES utf8 */;
31 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
32 /*!40103 SET TIME_ZONE='+00:00' */;
33 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
34 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
35 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
36 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
39 -- Current Database: `mano_db`
42 /*!40000 DROP DATABASE IF EXISTS `mano_db`*/;
44 CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mano_db`
/*!40100 DEFAULT CHARACTER SET latin1 */;
49 -- Table structure for table `datacenter_nets`
52 DROP TABLE IF EXISTS `datacenter_nets`
;
53 /*!40101 SET @saved_cs_client = @@character_set_client */;
54 /*!40101 SET character_set_client = utf8 */;
55 CREATE TABLE `datacenter_nets`
(
56 `uuid`
varchar(36) NOT NULL,
57 `
name`
varchar(36) NOT NULL COMMENT 'To match with sce_nets',
58 `vim_net_id`
varchar(36) NOT NULL,
59 `datacenter_id`
varchar(36) NOT NULL,
60 `
type`
enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
61 `multipoint`
enum('true','false') NOT NULL DEFAULT 'true',
62 `shared`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'If can be shared with serveral scenarios',
63 `description`
varchar(100) DEFAULT NULL,
64 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
65 `modified_at`
timestamp NULL DEFAULT NULL,
67 UNIQUE KEY `name_datacenter_id`
(`
name`
,`datacenter_id`
),
68 KEY `FK_datacenter_nets_datacenters`
(`datacenter_id`
),
69 CONSTRAINT `FK_datacenter_nets_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
70 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
COMMENT='Contain the external nets of a datacenter';
71 /*!40101 SET character_set_client = @saved_cs_client */;
74 -- Table structure for table `datacenters`
77 DROP TABLE IF EXISTS `datacenters`
;
78 /*!40101 SET @saved_cs_client = @@character_set_client */;
79 /*!40101 SET character_set_client = utf8 */;
80 CREATE TABLE `datacenters`
(
81 `uuid`
varchar(36) NOT NULL,
82 `
name`
varchar(36) NOT NULL,
83 `description`
varchar(100) DEFAULT NULL,
84 `
type`
enum('openvim','openstack') NOT NULL DEFAULT 'openvim',
85 `vim_url`
varchar(150) NOT NULL COMMENT 'URL of the VIM for the REST API',
86 `vim_url_admin`
varchar(150) DEFAULT NULL,
87 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
88 `modified_at`
timestamp NULL DEFAULT NULL,
90 UNIQUE KEY `
name`
(`
name`
)
91 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Datacenters managed by the NFVO.';
92 /*!40101 SET character_set_client = @saved_cs_client */;
95 -- Table structure for table `instance_interfaces`
98 DROP TABLE IF EXISTS `instance_interfaces`
;
99 /*!40101 SET @saved_cs_client = @@character_set_client */;
100 /*!40101 SET character_set_client = utf8 */;
101 CREATE TABLE `instance_interfaces`
(
102 `uuid`
varchar(36) NOT NULL,
103 `instance_vm_id`
varchar(36) NOT NULL,
104 `instance_net_id`
varchar(36) NOT NULL,
105 `interface_id`
varchar(36) NOT NULL,
106 `vim_interface_id`
varchar(36) NOT NULL COMMENT 'vim identity for that interface',
107 `
type`
enum('internal','external') NOT NULL COMMENT 'Indicates if this interface is external to a vnf, or internal',
108 PRIMARY KEY (`uuid`
),
109 KEY `FK_instance_vms`
(`instance_vm_id`
),
110 KEY `FK_instance_nets`
(`instance_net_id`
),
111 KEY `FK_instance_ids`
(`interface_id`
),
112 CONSTRAINT `FK_instance_ids`
FOREIGN KEY (`interface_id`
) REFERENCES `interfaces`
(`uuid`
),
113 CONSTRAINT `FK_instance_nets`
FOREIGN KEY (`instance_net_id`
) REFERENCES `instance_nets`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
114 CONSTRAINT `FK_instance_vms`
FOREIGN KEY (`instance_vm_id`
) REFERENCES `instance_vms`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
115 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Table with all running associattion among VM instances and net instances';
116 /*!40101 SET character_set_client = @saved_cs_client */;
119 -- Table structure for table `instance_nets`
122 DROP TABLE IF EXISTS `instance_nets`
;
123 /*!40101 SET @saved_cs_client = @@character_set_client */;
124 /*!40101 SET character_set_client = utf8 */;
125 CREATE TABLE `instance_nets`
(
126 `uuid`
varchar(36) NOT NULL,
127 `vim_net_id`
varchar(36) NOT NULL COMMENT 'Network ID in the VIM DB',
128 `instance_scenario_id`
varchar(36) NOT NULL,
129 `status`
enum('ACTIVE','DOWN','BUILD','ERROR') NOT NULL DEFAULT 'BUILD',
130 `multipoint`
enum('true','false') NOT NULL DEFAULT 'true',
131 `
external`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'If external, means that it already exists at VIM',
132 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
133 `modified_at`
timestamp NULL DEFAULT NULL,
134 PRIMARY KEY (`uuid`
),
135 UNIQUE KEY `vim_net_id_instance_scenario_id`
(`vim_net_id`
,`instance_scenario_id`
),
136 KEY `FK_instance_nets_instance_scenarios`
(`instance_scenario_id`
),
137 CONSTRAINT `FK_instance_nets_instance_scenarios`
FOREIGN KEY (`instance_scenario_id`
) REFERENCES `instance_scenarios`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
138 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Instances of networks';
139 /*!40101 SET character_set_client = @saved_cs_client */;
142 -- Table structure for table `instance_scenarios`
145 DROP TABLE IF EXISTS `instance_scenarios`
;
146 /*!40101 SET @saved_cs_client = @@character_set_client */;
147 /*!40101 SET character_set_client = utf8 */;
148 CREATE TABLE `instance_scenarios`
(
149 `uuid`
varchar(36) NOT NULL,
150 `
name`
varchar(36) NOT NULL,
151 `scenario_id`
varchar(36) NOT NULL,
152 `nfvo_tenant_id`
varchar(36) NOT NULL,
153 `vim_tenant_id`
varchar(36) NOT NULL,
154 `datacenter_id`
varchar(36) NOT NULL,
155 `description`
varchar(100) DEFAULT NULL,
156 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
157 `modified_at`
timestamp NULL DEFAULT NULL,
158 PRIMARY KEY (`uuid`
),
159 UNIQUE KEY `
name`
(`
name`
),
160 KEY `FK_scenarios_nfvo_tenants`
(`nfvo_tenant_id`
),
161 KEY `FK_instance_scenarios_vim_tenants`
(`vim_tenant_id`
),
162 KEY `FK_instance_scenarios_datacenters`
(`datacenter_id`
),
163 KEY `FK_instance_scenarios_scenarios`
(`scenario_id`
),
164 CONSTRAINT `FK_instance_scenarios_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
),
165 CONSTRAINT `FK_instance_scenarios_nfvo_tenants`
FOREIGN KEY (`nfvo_tenant_id`
) REFERENCES `nfvo_tenants`
(`uuid`
),
166 CONSTRAINT `FK_instance_scenarios_scenarios`
FOREIGN KEY (`scenario_id`
) REFERENCES `scenarios`
(`uuid`
),
167 CONSTRAINT `FK_instance_scenarios_vim_tenants`
FOREIGN KEY (`vim_tenant_id`
) REFERENCES `vim_tenants`
(`uuid`
)
168 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Instances of scenarios defined by the user';
169 /*!40101 SET character_set_client = @saved_cs_client */;
172 -- Table structure for table `instance_vms`
175 DROP TABLE IF EXISTS `instance_vms`
;
176 /*!40101 SET @saved_cs_client = @@character_set_client */;
177 /*!40101 SET character_set_client = utf8 */;
178 CREATE TABLE `instance_vms`
(
179 `uuid`
varchar(36) NOT NULL,
180 `instance_vnf_id`
varchar(36) NOT NULL,
181 `vm_id`
varchar(36) NOT NULL,
182 `vim_vm_id`
varchar(36) NOT NULL COMMENT 'VM ID in the VIM DB',
183 `status`
enum('ACTIVE','PAUSED','INACTIVE','CREATING','ERROR','DELETING') NOT NULL DEFAULT 'CREATING',
184 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
185 `modified_at`
timestamp NULL DEFAULT NULL,
186 PRIMARY KEY (`uuid`
),
187 UNIQUE KEY `vim_vm_id`
(`vim_vm_id`
),
188 KEY `FK_instance_vms_vms`
(`vm_id`
),
189 KEY `FK_instance_vms_instance_vnfs`
(`instance_vnf_id`
),
190 CONSTRAINT `FK_instance_vms_instance_vnfs`
FOREIGN KEY (`instance_vnf_id`
) REFERENCES `instance_vnfs`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
191 CONSTRAINT `FK_instance_vms_vms`
FOREIGN KEY (`vm_id`
) REFERENCES `vms`
(`uuid`
)
192 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Instances of VMs as part of VNF instances';
193 /*!40101 SET character_set_client = @saved_cs_client */;
196 -- Table structure for table `instance_vnfs`
199 DROP TABLE IF EXISTS `instance_vnfs`
;
200 /*!40101 SET @saved_cs_client = @@character_set_client */;
201 /*!40101 SET character_set_client = utf8 */;
202 CREATE TABLE `instance_vnfs`
(
203 `uuid`
varchar(36) NOT NULL,
204 `instance_scenario_id`
varchar(36) NOT NULL,
205 `vnf_id`
varchar(36) NOT NULL,
206 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
207 `modified_at`
timestamp NULL DEFAULT NULL,
208 PRIMARY KEY (`uuid`
),
209 KEY `FK_instance_vnfs_vnfs`
(`vnf_id`
),
210 KEY `FK_instance_vnfs_instance_scenarios`
(`instance_scenario_id`
),
211 CONSTRAINT `FK_instance_vnfs_instance_scenarios`
FOREIGN KEY (`instance_scenario_id`
) REFERENCES `instance_scenarios`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
212 CONSTRAINT `FK_instance_vnfs_vnfs`
FOREIGN KEY (`vnf_id`
) REFERENCES `vnfs`
(`uuid`
)
213 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Instances of VNFs as part of a scenario';
214 /*!40101 SET character_set_client = @saved_cs_client */;
217 -- Table structure for table `interfaces`
220 DROP TABLE IF EXISTS `interfaces`
;
221 /*!40101 SET @saved_cs_client = @@character_set_client */;
222 /*!40101 SET character_set_client = utf8 */;
223 CREATE TABLE `interfaces`
(
224 `uuid`
varchar(36) NOT NULL,
225 `internal_name`
varchar(25) NOT NULL,
226 `external_name`
varchar(25) DEFAULT NULL COMMENT 'NULL if the interface is not an external interface',
227 `vm_id`
varchar(36) NOT NULL,
228 `net_id`
varchar(36) DEFAULT NULL,
229 `
type`
enum('mgmt','bridge','data') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
230 `vpci`
char(12) DEFAULT NULL,
231 `bw`
mediumint(8) unsigned
DEFAULT NULL COMMENT 'BW expressed in Mbits/s. Maybe this field is not necessary.',
232 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
233 `modified_at`
timestamp NULL DEFAULT NULL,
234 `model`
varchar(12) DEFAULT NULL,
235 PRIMARY KEY (`uuid`
),
236 UNIQUE KEY `internal_name_vm_id`
(`internal_name`
,`vm_id`
),
237 KEY `FK_interfaces_vms`
(`vm_id`
),
238 KEY `FK_interfaces_nets`
(`net_id`
),
239 CONSTRAINT `FK_interfaces_nets`
FOREIGN KEY (`net_id`
) REFERENCES `nets`
(`uuid`
) ON DELETE CASCADE,
240 CONSTRAINT `FK_interfaces_vms`
FOREIGN KEY (`vm_id`
) REFERENCES `vms`
(`uuid`
) ON DELETE CASCADE
241 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='VM interfaces';
242 /*!40101 SET character_set_client = @saved_cs_client */;
245 -- Table structure for table `logs`
248 DROP TABLE IF EXISTS `logs`
;
249 /*!40101 SET @saved_cs_client = @@character_set_client */;
250 /*!40101 SET character_set_client = utf8 */;
251 CREATE TABLE `logs`
(
252 `
id`
int(10) unsigned
NOT NULL AUTO_INCREMENT
,
253 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
254 `nfvo_tenant_id`
varchar(36) DEFAULT NULL,
255 `related`
enum('nfvo_tenants','datacenters','vim_tenants','tenants_datacenters','vnfs','vms','interfaces','nets','scenarios','sce_vnfs','sce_interfaces','sce_nets','instance_scenarios','instance_vnfs','instance_vms','instance_nets','instance_interfaces') NOT NULL COMMENT 'Relevant element for the log',
256 `uuid`
varchar(36) DEFAULT NULL COMMENT 'Uuid of vnf, scenario, etc. that log relates to',
257 `
level`
enum('panic','error','info','debug','verbose') NOT NULL,
258 `description`
varchar(200) NOT NULL,
260 ) ENGINE
=InnoDB AUTO_INCREMENT
=3286 DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
;
261 /*!40101 SET character_set_client = @saved_cs_client */;
264 -- Table structure for table `nets`
267 DROP TABLE IF EXISTS `nets`
;
268 /*!40101 SET @saved_cs_client = @@character_set_client */;
269 /*!40101 SET character_set_client = utf8 */;
270 CREATE TABLE `nets`
(
271 `uuid`
varchar(36) NOT NULL,
272 `vnf_id`
varchar(36) NOT NULL,
273 `
name`
varchar(36) NOT NULL,
274 `
type`
enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
275 `multipoint`
enum('true','false') NOT NULL DEFAULT 'false',
276 `description`
varchar(100) DEFAULT NULL,
277 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
278 `modified_at`
timestamp NULL DEFAULT NULL,
279 PRIMARY KEY (`uuid`
),
280 UNIQUE KEY `vnf_id_name`
(`vnf_id`
,`
name`
),
281 CONSTRAINT `FK_nets_vnfs`
FOREIGN KEY (`vnf_id`
) REFERENCES `vnfs`
(`uuid`
) ON DELETE CASCADE
282 ) 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.';
283 /*!40101 SET character_set_client = @saved_cs_client */;
286 -- Table structure for table `nfvo_tenants`
289 DROP TABLE IF EXISTS `nfvo_tenants`
;
290 /*!40101 SET @saved_cs_client = @@character_set_client */;
291 /*!40101 SET character_set_client = utf8 */;
292 CREATE TABLE `nfvo_tenants`
(
293 `uuid`
varchar(36) NOT NULL,
294 `
name`
varchar(36) NOT NULL,
295 `description`
varchar(100) DEFAULT NULL,
296 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
297 `modified_at`
timestamp NULL DEFAULT NULL,
298 PRIMARY KEY (`uuid`
),
299 UNIQUE KEY `
name`
(`
name`
)
300 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Scenarios defined by the user';
301 /*!40101 SET character_set_client = @saved_cs_client */;
304 -- Table structure for table `sce_interfaces`
307 DROP TABLE IF EXISTS `sce_interfaces`
;
308 /*!40101 SET @saved_cs_client = @@character_set_client */;
309 /*!40101 SET character_set_client = utf8 */;
310 CREATE TABLE `sce_interfaces`
(
311 `uuid`
varchar(36) NOT NULL,
312 `sce_vnf_id`
varchar(36) NOT NULL,
313 `sce_net_id`
varchar(36) DEFAULT NULL,
314 `interface_id`
varchar(36) DEFAULT NULL,
315 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
316 `modified_at`
timestamp NULL DEFAULT NULL,
317 PRIMARY KEY (`uuid`
),
318 KEY `FK_sce_interfaces_sce_vnfs`
(`sce_vnf_id`
),
319 KEY `FK_sce_interfaces_sce_nets`
(`sce_net_id`
),
320 KEY `FK_sce_interfaces_interfaces`
(`interface_id`
),
321 CONSTRAINT `FK_sce_interfaces_interfaces`
FOREIGN KEY (`interface_id`
) REFERENCES `interfaces`
(`uuid`
),
322 CONSTRAINT `FK_sce_interfaces_sce_nets`
FOREIGN KEY (`sce_net_id`
) REFERENCES `sce_nets`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
323 CONSTRAINT `FK_sce_interfaces_sce_vnfs`
FOREIGN KEY (`sce_vnf_id`
) REFERENCES `sce_vnfs`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
324 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='VNF interfaces in a scenario definition.';
325 /*!40101 SET character_set_client = @saved_cs_client */;
328 -- Table structure for table `sce_nets`
331 DROP TABLE IF EXISTS `sce_nets`
;
332 /*!40101 SET @saved_cs_client = @@character_set_client */;
333 /*!40101 SET character_set_client = utf8 */;
334 CREATE TABLE `sce_nets`
(
335 `uuid`
varchar(36) NOT NULL,
336 `
name`
varchar(36) DEFAULT NULL,
337 `scenario_id`
varchar(36) DEFAULT NULL COMMENT 'NULL if net is matched to several scenarios',
338 `
type`
enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
339 `multipoint`
enum('true','false') NOT NULL DEFAULT 'true',
340 `
external`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'If external, net is already present at VIM',
341 `description`
varchar(100) DEFAULT NULL,
342 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
343 `modified_at`
timestamp NULL DEFAULT NULL,
344 `graph`
varchar(200) DEFAULT NULL,
345 PRIMARY KEY (`uuid`
),
346 KEY `FK_sce_nets_scenarios`
(`scenario_id`
),
347 CONSTRAINT `FK_sce_nets_scenarios`
FOREIGN KEY (`scenario_id`
) REFERENCES `scenarios`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
348 ) 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''.';
349 /*!40101 SET character_set_client = @saved_cs_client */;
352 -- Table structure for table `sce_vnfs`
355 DROP TABLE IF EXISTS `sce_vnfs`
;
356 /*!40101 SET @saved_cs_client = @@character_set_client */;
357 /*!40101 SET character_set_client = utf8 */;
358 CREATE TABLE `sce_vnfs`
(
359 `uuid`
varchar(36) NOT NULL,
360 `
name`
varchar(36) NOT NULL,
361 `scenario_id`
varchar(36) NOT NULL,
362 `vnf_id`
varchar(36) NOT NULL,
363 `description`
varchar(100) DEFAULT NULL,
364 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
365 `modified_at`
timestamp NULL DEFAULT NULL,
366 `graph`
varchar(200) DEFAULT NULL,
367 PRIMARY KEY (`uuid`
),
368 UNIQUE KEY `name_scenario_id`
(`
name`
,`scenario_id`
),
369 KEY `FK_sce_vnfs_scenarios`
(`scenario_id`
),
370 KEY `FK_sce_vnfs_vnfs`
(`vnf_id`
),
371 CONSTRAINT `FK_sce_vnfs_scenarios`
FOREIGN KEY (`scenario_id`
) REFERENCES `scenarios`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
372 CONSTRAINT `FK_sce_vnfs_vnfs`
FOREIGN KEY (`vnf_id`
) REFERENCES `vnfs`
(`uuid`
)
373 ) 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';
374 /*!40101 SET character_set_client = @saved_cs_client */;
377 -- Table structure for table `scenarios`
380 DROP TABLE IF EXISTS `scenarios`
;
381 /*!40101 SET @saved_cs_client = @@character_set_client */;
382 /*!40101 SET character_set_client = utf8 */;
383 CREATE TABLE `scenarios`
(
384 `uuid`
varchar(36) NOT NULL,
385 `
name`
varchar(36) NOT NULL,
386 `nfvo_tenant_id`
varchar(36) DEFAULT NULL,
387 `description`
varchar(100) DEFAULT NULL,
388 `
public`
enum('true','false') NOT NULL DEFAULT 'false',
389 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
390 `modified_at`
timestamp NULL DEFAULT NULL,
391 PRIMARY KEY (`uuid`
),
392 UNIQUE KEY `
name`
(`
name`
),
393 KEY `FK_scenarios_nfvo_tenants`
(`nfvo_tenant_id`
),
394 CONSTRAINT `FK_scenarios_nfvo_tenants`
FOREIGN KEY (`nfvo_tenant_id`
) REFERENCES `nfvo_tenants`
(`uuid`
)
395 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Scenarios defined by the user';
396 /*!40101 SET character_set_client = @saved_cs_client */;
399 -- Table structure for table `tenants_datacenters`
402 DROP TABLE IF EXISTS `tenants_datacenters`
;
403 /*!40101 SET @saved_cs_client = @@character_set_client */;
404 /*!40101 SET character_set_client = utf8 */;
405 CREATE TABLE `tenants_datacenters`
(
406 `
id`
int(11) NOT NULL AUTO_INCREMENT
,
407 `nfvo_tenant_id`
varchar(36) NOT NULL,
408 `datacenter_id`
varchar(36) NOT NULL,
409 `vim_tenant_id`
varchar(36) NOT NULL,
410 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
411 `modified_at`
timestamp NULL DEFAULT NULL,
413 UNIQUE KEY `datacenter_nfvo_tenant`
(`datacenter_id`
,`nfvo_tenant_id`
),
414 KEY `FK_nfvo_tenants_datacenters`
(`datacenter_id`
),
415 KEY `FK_nfvo_tenants_vim_tenants`
(`vim_tenant_id`
),
416 KEY `FK_tenants_datacenters_nfvo_tenants`
(`nfvo_tenant_id`
),
417 CONSTRAINT `FK_tenants_datacenters_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
),
418 CONSTRAINT `FK_tenants_datacenters_nfvo_tenants`
FOREIGN KEY (`nfvo_tenant_id`
) REFERENCES `nfvo_tenants`
(`uuid`
),
419 CONSTRAINT `FK_tenants_datacenters_vim_tenants`
FOREIGN KEY (`vim_tenant_id`
) REFERENCES `vim_tenants`
(`uuid`
)
420 ) ENGINE
=InnoDB AUTO_INCREMENT
=85 DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Scenarios defined by the user';
421 /*!40101 SET character_set_client = @saved_cs_client */;
424 -- Table structure for table `uuids`
427 DROP TABLE IF EXISTS `uuids`
;
428 /*!40101 SET @saved_cs_client = @@character_set_client */;
429 /*!40101 SET character_set_client = utf8 */;
430 CREATE TABLE `uuids`
(
431 `uuid`
varchar(36) NOT NULL,
432 `root_uuid`
varchar(36) DEFAULT NULL COMMENT 'Some related UUIDs can be grouped by this field, so that they can be deleted at once',
433 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
434 `used_at`
enum('nfvo_tenants','datacenters','vim_tenants','vnfs','vms','interfaces','nets','scenarios','sce_vnfs','sce_interfaces','sce_nets','instance_scenarios','instance_vnfs','instance_vms','instance_nets','instance_interfaces') DEFAULT NULL COMMENT 'Table that uses this UUID',
436 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
COMMENT='Table with all unique IDs used to avoid UUID repetitions among different elements';
437 /*!40101 SET character_set_client = @saved_cs_client */;
440 -- Table structure for table `vim_tenants`
443 DROP TABLE IF EXISTS `vim_tenants`
;
444 /*!40101 SET @saved_cs_client = @@character_set_client */;
445 /*!40101 SET character_set_client = utf8 */;
446 CREATE TABLE `vim_tenants`
(
447 `uuid`
varchar(36) NOT NULL,
448 `
name`
varchar(36) NOT NULL,
449 `vim_tenant_id`
varchar(36) NOT NULL COMMENT 'Tenant ID in the VIM DB',
450 `created`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if this tenant has been created by openmano, or it existed on VIM',
451 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
452 `modified_at`
timestamp NULL DEFAULT NULL,
453 PRIMARY KEY (`uuid`
),
454 UNIQUE KEY `
name`
(`
name`
),
455 UNIQUE KEY `vim_tenant_id`
(`vim_tenant_id`
)
456 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Scenarios defined by the user';
457 /*!40101 SET character_set_client = @saved_cs_client */;
460 -- Table structure for table `vms`
463 DROP TABLE IF EXISTS `vms`
;
464 /*!40101 SET @saved_cs_client = @@character_set_client */;
465 /*!40101 SET character_set_client = utf8 */;
467 `uuid`
varchar(36) NOT NULL,
468 `
name`
varchar(36) NOT NULL,
469 `vnf_id`
varchar(36) NOT NULL,
470 `vim_flavor_id`
varchar(36) NOT NULL COMMENT 'Flavor ID in the VIM DB',
471 `vim_image_id`
varchar(36) NOT NULL COMMENT 'Image ID in the VIM DB',
472 `image_path`
varchar(100) NOT NULL COMMENT 'Path where the image of the VM is located',
473 `description`
varchar(100) DEFAULT NULL,
474 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
475 `modified_at`
timestamp NULL DEFAULT NULL,
476 PRIMARY KEY (`uuid`
),
477 UNIQUE KEY `name_vnf_id`
(`
name`
,`vnf_id`
),
478 KEY `FK_vms_vnfs`
(`vnf_id`
),
479 CONSTRAINT `FK_vms_vnfs`
FOREIGN KEY (`vnf_id`
) REFERENCES `vnfs`
(`uuid`
) ON DELETE CASCADE
480 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='VM definitions. It contains the set of VMs used by the VNF definitions.';
481 /*!40101 SET character_set_client = @saved_cs_client */;
484 -- Table structure for table `vnfs`
487 DROP TABLE IF EXISTS `vnfs`
;
488 /*!40101 SET @saved_cs_client = @@character_set_client */;
489 /*!40101 SET character_set_client = utf8 */;
490 CREATE TABLE `vnfs`
(
491 `uuid`
varchar(36) NOT NULL,
492 `
name`
varchar(36) NOT NULL,
493 `
path`
varchar(100) DEFAULT NULL COMMENT 'Path where the YAML descriptor of the VNF can be found. NULL if it is a physical network function.',
494 `physical`
enum('true','false') NOT NULL DEFAULT 'false',
495 `
public`
enum('true','false') NOT NULL DEFAULT 'true',
496 `description`
varchar(100) DEFAULT NULL,
497 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
498 `modified_at`
timestamp NULL DEFAULT NULL,
499 `
class`
varchar(36) DEFAULT 'MISC',
500 PRIMARY KEY (`uuid`
),
501 UNIQUE KEY `
name`
(`
name`
),
502 UNIQUE KEY `
path`
(`
path`
)
503 ) 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';
504 /*!40101 SET character_set_client = @saved_cs_client */;
507 -- Dumping routines for database 'mano_db'
509 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
511 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
512 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
513 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
514 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
515 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
516 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
517 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
519 -- Dump completed on 2015-03-11 17:34:28