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 -- Table structure for table `datacenter_nets`
43 DROP TABLE IF EXISTS `datacenter_nets`
;
44 /*!40101 SET @saved_cs_client = @@character_set_client */;
45 /*!40101 SET character_set_client = utf8 */;
46 CREATE TABLE `datacenter_nets`
(
47 `uuid`
varchar(36) NOT NULL,
48 `
name`
varchar(255) NOT NULL,
49 `vim_net_id`
varchar(36) NOT NULL,
50 `datacenter_id`
varchar(36) NOT NULL,
51 `
type`
enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
52 `multipoint`
enum('true','false') NOT NULL DEFAULT 'true',
53 `shared`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'If can be shared with serveral scenarios',
54 `description`
varchar(255) DEFAULT NULL,
55 `created_at`
double NOT NULL,
56 `modified_at`
double DEFAULT NULL,
58 UNIQUE KEY `name_datacenter_id`
(`
name`
,`datacenter_id`
),
59 KEY `FK_datacenter_nets_datacenters`
(`datacenter_id`
),
60 CONSTRAINT `FK_datacenter_nets_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
61 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
COMMENT='Contain the external nets of a datacenter';
62 /*!40101 SET character_set_client = @saved_cs_client */;
65 -- Table structure for table `datacenter_tenants`
68 DROP TABLE IF EXISTS `datacenter_tenants`
;
69 /*!40101 SET @saved_cs_client = @@character_set_client */;
70 /*!40101 SET character_set_client = utf8 */;
71 CREATE TABLE `datacenter_tenants`
(
72 `uuid`
varchar(36) NOT NULL,
73 `datacenter_id`
varchar(36) NOT NULL COMMENT 'Datacenter of this tenant',
74 `vim_tenant_name`
varchar(64) DEFAULT NULL,
75 `vim_tenant_id`
varchar(36) DEFAULT NULL COMMENT 'Tenant ID at VIM',
76 `created`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if this tenant has been created by openmano, or it existed on VIM',
77 `
user`
varchar(64) DEFAULT NULL,
78 `passwd`
varchar(64) DEFAULT NULL,
79 `created_at`
double NOT NULL,
80 `modified_at`
double DEFAULT NULL,
82 KEY `FK_vim_tenants_datacenters`
(`datacenter_id`
),
83 CONSTRAINT `FK_vim_tenants_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
84 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Scenarios defined by the user';
85 /*!40101 SET character_set_client = @saved_cs_client */;
88 -- Table structure for table `datacenters`
91 DROP TABLE IF EXISTS `datacenters`
;
92 /*!40101 SET @saved_cs_client = @@character_set_client */;
93 /*!40101 SET character_set_client = utf8 */;
94 CREATE TABLE `datacenters`
(
95 `uuid`
varchar(36) NOT NULL,
96 `
name`
varchar(255) NOT NULL,
97 `description`
varchar(255) DEFAULT NULL,
98 `
type`
varchar(36) NOT NULL DEFAULT 'openvim',
99 `vim_url`
varchar(150) NOT NULL COMMENT 'URL of the VIM for the REST API',
100 `vim_url_admin`
varchar(150) DEFAULT NULL,
101 `config`
varchar(4000) DEFAULT NULL COMMENT 'extra config information in json',
102 `created_at`
double NOT NULL,
103 `modified_at`
double DEFAULT NULL,
104 PRIMARY KEY (`uuid`
),
105 UNIQUE KEY `
name`
(`
name`
)
106 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Datacenters managed by the NFVO.';
107 /*!40101 SET character_set_client = @saved_cs_client */;
110 -- Table structure for table `datacenters_flavors`
113 DROP TABLE IF EXISTS `datacenters_flavors`
;
114 /*!40101 SET @saved_cs_client = @@character_set_client */;
115 /*!40101 SET character_set_client = utf8 */;
116 CREATE TABLE `datacenters_flavors`
(
117 `
id`
int(11) NOT NULL AUTO_INCREMENT
,
118 `flavor_id`
varchar(36) NOT NULL,
119 `datacenter_id`
varchar(36) NOT NULL,
120 `vim_id`
varchar(36) NOT NULL,
121 `created`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if it has been created by openmano, or already existed',
123 KEY `FK__flavors`
(`flavor_id`
),
124 KEY `FK__datacenters_f`
(`datacenter_id`
),
125 CONSTRAINT `FK__datacenters_f`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
126 CONSTRAINT `FK__flavors`
FOREIGN KEY (`flavor_id`
) REFERENCES `flavors`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
127 ) ENGINE
=InnoDB AUTO_INCREMENT
=7 DEFAULT CHARSET
=utf8
;
128 /*!40101 SET character_set_client = @saved_cs_client */;
131 -- Table structure for table `datacenters_images`
134 DROP TABLE IF EXISTS `datacenters_images`
;
135 /*!40101 SET @saved_cs_client = @@character_set_client */;
136 /*!40101 SET character_set_client = utf8 */;
137 CREATE TABLE `datacenters_images`
(
138 `
id`
int(11) NOT NULL AUTO_INCREMENT
,
139 `image_id`
varchar(36) NOT NULL,
140 `datacenter_id`
varchar(36) NOT NULL,
141 `vim_id`
varchar(36) NOT NULL,
142 `created`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if it has been created by openmano, or already existed',
144 KEY `FK__images`
(`image_id`
),
145 KEY `FK__datacenters_i`
(`datacenter_id`
),
146 CONSTRAINT `FK__datacenters_i`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
147 CONSTRAINT `FK__images`
FOREIGN KEY (`image_id`
) REFERENCES `images`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
148 ) ENGINE
=InnoDB AUTO_INCREMENT
=6 DEFAULT CHARSET
=utf8
;
149 /*!40101 SET character_set_client = @saved_cs_client */;
152 -- Table structure for table `flavors`
155 DROP TABLE IF EXISTS `flavors`
;
156 /*!40101 SET @saved_cs_client = @@character_set_client */;
157 /*!40101 SET character_set_client = utf8 */;
158 CREATE TABLE `flavors`
(
159 `uuid`
varchar(36) NOT NULL,
160 `
name`
varchar(255) NOT NULL,
161 `description`
varchar(255) DEFAULT NULL,
162 `disk`
smallint(5) unsigned
DEFAULT NULL,
163 `ram`
smallint(5) unsigned
DEFAULT NULL,
164 `vcpus`
smallint(5) unsigned
DEFAULT NULL,
165 `extended`
varchar(2000) DEFAULT NULL COMMENT 'Extra description json format of needed resources and pining, orginized in sets per numa',
167 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
;
168 /*!40101 SET character_set_client = @saved_cs_client */;
171 -- Table structure for table `images`
174 DROP TABLE IF EXISTS `images`
;
175 /*!40101 SET @saved_cs_client = @@character_set_client */;
176 /*!40101 SET character_set_client = utf8 */;
177 CREATE TABLE `images`
(
178 `uuid`
varchar(36) NOT NULL,
179 `
name`
varchar(255) NOT NULL,
180 `
location`
varchar(200) NOT NULL,
181 `description`
varchar(255) DEFAULT NULL,
182 `metadata`
varchar(2000) DEFAULT NULL,
183 PRIMARY KEY (`uuid`
),
184 UNIQUE KEY `
location`
(`
location`
)
185 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
;
186 /*!40101 SET character_set_client = @saved_cs_client */;
189 -- Table structure for table `instance_interfaces`
192 DROP TABLE IF EXISTS `instance_interfaces`
;
193 /*!40101 SET @saved_cs_client = @@character_set_client */;
194 /*!40101 SET character_set_client = utf8 */;
195 CREATE TABLE `instance_interfaces`
(
196 `uuid`
varchar(36) NOT NULL,
197 `instance_vm_id`
varchar(36) NOT NULL,
198 `instance_net_id`
varchar(36) NOT NULL,
199 `interface_id`
varchar(36) NOT NULL,
200 `vim_interface_id`
varchar(36) DEFAULT NULL COMMENT 'vim identity for that interface',
201 `mac_address`
varchar(32) DEFAULT NULL,
202 `ip_address`
varchar(64) DEFAULT NULL,
204 `
type`
enum('internal','external') NOT NULL COMMENT 'Indicates if this interface is external to a vnf, or internal',
205 PRIMARY KEY (`uuid`
),
206 KEY `FK_instance_vms`
(`instance_vm_id`
),
207 KEY `FK_instance_nets`
(`instance_net_id`
),
208 KEY `FK_instance_ids`
(`interface_id`
),
209 CONSTRAINT `FK_instance_ids`
FOREIGN KEY (`interface_id`
) REFERENCES `interfaces`
(`uuid`
),
210 CONSTRAINT `FK_instance_nets`
FOREIGN KEY (`instance_net_id`
) REFERENCES `instance_nets`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
211 CONSTRAINT `FK_instance_vms`
FOREIGN KEY (`instance_vm_id`
) REFERENCES `instance_vms`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
212 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Table with all running associattion among VM instances and net instances';
213 /*!40101 SET character_set_client = @saved_cs_client */;
216 -- Table structure for table `instance_nets`
219 DROP TABLE IF EXISTS `instance_nets`
;
220 /*!40101 SET @saved_cs_client = @@character_set_client */;
221 /*!40101 SET character_set_client = utf8 */;
222 CREATE TABLE `instance_nets`
(
223 `uuid`
varchar(36) NOT NULL,
224 `vim_net_id`
varchar(36) NOT NULL COMMENT 'Network ID in the VIM DB',
225 `instance_scenario_id`
varchar(36) NOT NULL,
226 `sce_net_id`
varchar(36) DEFAULT NULL,
227 `net_id`
varchar(36) DEFAULT NULL,
228 `datacenter_id`
varchar(36) DEFAULT NULL,
229 `datacenter_tenant_id`
varchar(36) NOT NULL,
230 `status`
enum('ACTIVE','DOWN','BUILD','ERROR','VIM_ERROR','INACTIVE','DELETED') NOT NULL DEFAULT 'BUILD',
231 `error_msg`
varchar(1024) DEFAULT NULL,
233 `multipoint`
enum('true','false') NOT NULL DEFAULT 'true',
234 `
external`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'If external, means that it already exists at VIM',
235 `created_at`
double NOT NULL,
236 `modified_at`
double DEFAULT NULL,
237 PRIMARY KEY (`uuid`
),
238 UNIQUE KEY `vim_net_id_instance_scenario_id`
(`vim_net_id`
,`instance_scenario_id`
),
239 KEY `FK_instance_nets_instance_scenarios`
(`instance_scenario_id`
),
240 KEY `FK_instance_nets_sce_nets`
(`sce_net_id`
),
241 KEY `FK_instance_nets_nets`
(`net_id`
),
242 KEY `FK_instance_nets_datacenters`
(`datacenter_id`
),
243 KEY `FK_instance_nets_datacenter_tenants`
(`datacenter_tenant_id`
),
244 CONSTRAINT `FK_instance_nets_datacenter_tenants`
FOREIGN KEY (`datacenter_tenant_id`
) REFERENCES `datacenter_tenants`
(`uuid`
),
245 CONSTRAINT `FK_instance_nets_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
),
246 CONSTRAINT `FK_instance_nets_instance_scenarios`
FOREIGN KEY (`instance_scenario_id`
) REFERENCES `instance_scenarios`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
247 CONSTRAINT `FK_instance_nets_nets`
FOREIGN KEY (`net_id`
) REFERENCES `nets`
(`uuid`
) ON DELETE SET NULL ON UPDATE CASCADE,
248 CONSTRAINT `FK_instance_nets_sce_nets`
FOREIGN KEY (`sce_net_id`
) REFERENCES `sce_nets`
(`uuid`
) ON DELETE SET NULL ON UPDATE CASCADE
249 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Instances of networks';
250 /*!40101 SET character_set_client = @saved_cs_client */;
253 -- Table structure for table `instance_scenarios`
256 DROP TABLE IF EXISTS `instance_scenarios`
;
257 /*!40101 SET @saved_cs_client = @@character_set_client */;
258 /*!40101 SET character_set_client = utf8 */;
259 CREATE TABLE `instance_scenarios`
(
260 `uuid`
varchar(36) NOT NULL,
261 `
name`
varchar(255) NOT NULL,
262 `tenant_id`
varchar(36) DEFAULT NULL,
263 `scenario_id`
varchar(36) NOT NULL,
264 `datacenter_id`
varchar(36) NOT NULL,
265 `datacenter_tenant_id`
varchar(36) NOT NULL,
266 `description`
varchar(255) DEFAULT NULL,
267 `created_at`
double NOT NULL,
268 `modified_at`
double DEFAULT NULL,
269 PRIMARY KEY (`uuid`
),
270 UNIQUE KEY `
name`
(`
name`
),
271 KEY `FK_scenarios_nfvo_tenants`
(`tenant_id`
),
272 KEY `FK_instance_scenarios_vim_tenants`
(`datacenter_tenant_id`
),
273 KEY `FK_instance_scenarios_datacenters`
(`datacenter_id`
),
274 KEY `FK_instance_scenarios_scenarios`
(`scenario_id`
),
275 CONSTRAINT `FK_instance_scenarios_datacenter_tenants`
FOREIGN KEY (`datacenter_tenant_id`
) REFERENCES `datacenter_tenants`
(`uuid`
),
276 CONSTRAINT `FK_instance_scenarios_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
),
277 CONSTRAINT `FK_instance_scenarios_nfvo_tenants`
FOREIGN KEY (`tenant_id`
) REFERENCES `nfvo_tenants`
(`uuid`
),
278 CONSTRAINT `FK_instance_scenarios_scenarios`
FOREIGN KEY (`scenario_id`
) REFERENCES `scenarios`
(`uuid`
)
279 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Instances of scenarios defined by the user';
280 /*!40101 SET character_set_client = @saved_cs_client */;
283 -- Table structure for table `instance_vms`
286 DROP TABLE IF EXISTS `instance_vms`
;
287 /*!40101 SET @saved_cs_client = @@character_set_client */;
288 /*!40101 SET character_set_client = utf8 */;
289 CREATE TABLE `instance_vms`
(
290 `uuid`
varchar(36) NOT NULL,
291 `instance_vnf_id`
varchar(36) NOT NULL,
292 `vm_id`
varchar(36) NOT NULL,
293 `vim_vm_id`
varchar(36) NOT NULL COMMENT 'VM ID in the VIM DB',
294 `status`
enum('ACTIVE:NoMgmtIP','ACTIVE','INACTIVE','BUILD','ERROR','VIM_ERROR','PAUSED','SUSPENDED','DELETED') NOT NULL DEFAULT 'BUILD',
295 `error_msg`
varchar(1024) DEFAULT NULL,
297 `created_at`
double NOT NULL,
298 `modified_at`
double DEFAULT NULL,
299 PRIMARY KEY (`uuid`
),
300 UNIQUE KEY `vim_vm_id`
(`vim_vm_id`
),
301 KEY `FK_instance_vms_vms`
(`vm_id`
),
302 KEY `FK_instance_vms_instance_vnfs`
(`instance_vnf_id`
),
303 CONSTRAINT `FK_instance_vms_instance_vnfs`
FOREIGN KEY (`instance_vnf_id`
) REFERENCES `instance_vnfs`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
304 CONSTRAINT `FK_instance_vms_vms`
FOREIGN KEY (`vm_id`
) REFERENCES `vms`
(`uuid`
)
305 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Instances of VMs as part of VNF instances';
306 /*!40101 SET character_set_client = @saved_cs_client */;
309 -- Table structure for table `instance_vnfs`
312 DROP TABLE IF EXISTS `instance_vnfs`
;
313 /*!40101 SET @saved_cs_client = @@character_set_client */;
314 /*!40101 SET character_set_client = utf8 */;
315 CREATE TABLE `instance_vnfs`
(
316 `uuid`
varchar(36) NOT NULL,
317 `instance_scenario_id`
varchar(36) NOT NULL,
318 `vnf_id`
varchar(36) NOT NULL,
319 `sce_vnf_id`
varchar(36) DEFAULT NULL,
320 `datacenter_id`
varchar(36) DEFAULT NULL,
321 `datacenter_tenant_id`
varchar(36) DEFAULT NULL,
322 `created_at`
double NOT NULL,
323 `modified_at`
double DEFAULT NULL,
324 PRIMARY KEY (`uuid`
),
325 KEY `FK_instance_vnfs_vnfs`
(`vnf_id`
),
326 KEY `FK_instance_vnfs_instance_scenarios`
(`instance_scenario_id`
),
327 KEY `FK_instance_vnfs_sce_vnfs`
(`sce_vnf_id`
),
328 KEY `FK_instance_vnfs_datacenters`
(`datacenter_id`
),
329 KEY `FK_instance_vnfs_datacenter_tenants`
(`datacenter_tenant_id`
),
330 CONSTRAINT `FK_instance_vnfs_datacenter_tenants`
FOREIGN KEY (`datacenter_tenant_id`
) REFERENCES `datacenter_tenants`
(`uuid`
),
331 CONSTRAINT `FK_instance_vnfs_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
),
332 CONSTRAINT `FK_instance_vnfs_instance_scenarios`
FOREIGN KEY (`instance_scenario_id`
) REFERENCES `instance_scenarios`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
333 CONSTRAINT `FK_instance_vnfs_sce_vnfs`
FOREIGN KEY (`sce_vnf_id`
) REFERENCES `sce_vnfs`
(`uuid`
) ON DELETE SET NULL ON UPDATE CASCADE,
334 CONSTRAINT `FK_instance_vnfs_vnfs`
FOREIGN KEY (`vnf_id`
) REFERENCES `vnfs`
(`uuid`
)
335 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Instances of VNFs as part of a scenario';
336 /*!40101 SET character_set_client = @saved_cs_client */;
339 -- Table structure for table `interfaces`
342 DROP TABLE IF EXISTS `interfaces`
;
343 /*!40101 SET @saved_cs_client = @@character_set_client */;
344 /*!40101 SET character_set_client = utf8 */;
345 CREATE TABLE `interfaces`
(
346 `uuid`
varchar(36) NOT NULL,
347 `internal_name`
varchar(255) NOT NULL,
348 `external_name`
varchar(255) DEFAULT NULL,
349 `vm_id`
varchar(36) NOT NULL,
350 `net_id`
varchar(36) DEFAULT NULL,
351 `
type`
enum('mgmt','bridge','data') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
352 `vpci`
char(12) DEFAULT NULL,
353 `bw`
mediumint(8) unsigned
DEFAULT NULL COMMENT 'BW expressed in Mbits/s. Maybe this field is not necessary.',
354 `created_at`
double NOT NULL,
355 `modified_at`
double DEFAULT NULL,
356 `model`
varchar(12) DEFAULT NULL,
357 `mac`
char(18) DEFAULT NULL,
358 PRIMARY KEY (`uuid`
),
359 UNIQUE KEY `internal_name_vm_id`
(`internal_name`
,`vm_id`
),
360 KEY `FK_interfaces_vms`
(`vm_id`
),
361 KEY `FK_interfaces_nets`
(`net_id`
),
362 CONSTRAINT `FK_interfaces_nets`
FOREIGN KEY (`net_id`
) REFERENCES `nets`
(`uuid`
) ON DELETE CASCADE,
363 CONSTRAINT `FK_interfaces_vms`
FOREIGN KEY (`vm_id`
) REFERENCES `vms`
(`uuid`
) ON DELETE CASCADE
364 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='VM interfaces';
365 /*!40101 SET character_set_client = @saved_cs_client */;
368 -- Table structure for table `logs`
371 DROP TABLE IF EXISTS `logs`
;
372 /*!40101 SET @saved_cs_client = @@character_set_client */;
373 /*!40101 SET character_set_client = utf8 */;
374 CREATE TABLE `logs`
(
375 `
id`
int(10) unsigned
NOT NULL AUTO_INCREMENT
,
376 `created_at`
timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
377 `nfvo_tenant_id`
varchar(36) DEFAULT NULL,
378 `related`
varchar(36) NOT NULL COMMENT 'Relevant element for the log',
379 `uuid`
varchar(36) DEFAULT NULL COMMENT 'Uuid of vnf, scenario, etc. that log relates to',
380 `
level`
enum('panic','error','info','debug','verbose') NOT NULL,
381 `description`
varchar(200) NOT NULL,
383 ) ENGINE
=InnoDB AUTO_INCREMENT
=3423 DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
;
384 /*!40101 SET character_set_client = @saved_cs_client */;
387 -- Table structure for table `nets`
390 DROP TABLE IF EXISTS `nets`
;
391 /*!40101 SET @saved_cs_client = @@character_set_client */;
392 /*!40101 SET character_set_client = utf8 */;
393 CREATE TABLE `nets`
(
394 `uuid`
varchar(36) NOT NULL,
395 `vnf_id`
varchar(36) NOT NULL,
396 `
name`
varchar(255) NOT NULL,
397 `
type`
enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
398 `multipoint`
enum('true','false') NOT NULL DEFAULT 'false',
399 `description`
varchar(255) DEFAULT NULL,
400 `created_at`
double NOT NULL,
401 `modified_at`
double DEFAULT NULL,
402 PRIMARY KEY (`uuid`
),
403 UNIQUE KEY `vnf_id_name`
(`vnf_id`
,`
name`
),
404 CONSTRAINT `FK_nets_vnfs`
FOREIGN KEY (`vnf_id`
) REFERENCES `vnfs`
(`uuid`
) ON DELETE CASCADE
405 ) 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.';
406 /*!40101 SET character_set_client = @saved_cs_client */;
409 -- Table structure for table `nfvo_tenants`
412 DROP TABLE IF EXISTS `nfvo_tenants`
;
413 /*!40101 SET @saved_cs_client = @@character_set_client */;
414 /*!40101 SET character_set_client = utf8 */;
415 CREATE TABLE `nfvo_tenants`
(
416 `uuid`
varchar(36) NOT NULL,
417 `
name`
varchar(255) NOT NULL,
418 `description`
varchar(255) DEFAULT NULL,
419 `created_at`
double NOT NULL,
420 `modified_at`
double DEFAULT NULL,
421 PRIMARY KEY (`uuid`
),
422 UNIQUE KEY `
name`
(`
name`
)
423 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Scenarios defined by the user';
424 /*!40101 SET character_set_client = @saved_cs_client */;
427 -- Table structure for table `sce_interfaces`
430 DROP TABLE IF EXISTS `sce_interfaces`
;
431 /*!40101 SET @saved_cs_client = @@character_set_client */;
432 /*!40101 SET character_set_client = utf8 */;
433 CREATE TABLE `sce_interfaces`
(
434 `uuid`
varchar(36) NOT NULL,
435 `sce_vnf_id`
varchar(36) NOT NULL,
436 `sce_net_id`
varchar(36) DEFAULT NULL,
437 `interface_id`
varchar(36) DEFAULT NULL,
438 `created_at`
double NOT NULL,
439 `modified_at`
double DEFAULT NULL,
440 PRIMARY KEY (`uuid`
),
441 KEY `FK_sce_interfaces_sce_vnfs`
(`sce_vnf_id`
),
442 KEY `FK_sce_interfaces_sce_nets`
(`sce_net_id`
),
443 KEY `FK_sce_interfaces_interfaces`
(`interface_id`
),
444 CONSTRAINT `FK_sce_interfaces_interfaces`
FOREIGN KEY (`interface_id`
) REFERENCES `interfaces`
(`uuid`
),
445 CONSTRAINT `FK_sce_interfaces_sce_nets`
FOREIGN KEY (`sce_net_id`
) REFERENCES `sce_nets`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
446 CONSTRAINT `FK_sce_interfaces_sce_vnfs`
FOREIGN KEY (`sce_vnf_id`
) REFERENCES `sce_vnfs`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
447 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='VNF interfaces in a scenario definition.';
448 /*!40101 SET character_set_client = @saved_cs_client */;
451 -- Table structure for table `sce_nets`
454 DROP TABLE IF EXISTS `sce_nets`
;
455 /*!40101 SET @saved_cs_client = @@character_set_client */;
456 /*!40101 SET character_set_client = utf8 */;
457 CREATE TABLE `sce_nets`
(
458 `uuid`
varchar(36) NOT NULL,
459 `
name`
varchar(255) NOT NULL,
460 `scenario_id`
varchar(36) DEFAULT NULL COMMENT 'NULL if net is matched to several scenarios',
461 `
type`
enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
462 `multipoint`
enum('true','false') NOT NULL DEFAULT 'true',
463 `
external`
enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'If external, net is already present at VIM',
464 `description`
varchar(255) DEFAULT NULL,
465 `created_at`
double NOT NULL,
466 `modified_at`
double DEFAULT NULL,
467 `graph`
varchar(2000) DEFAULT NULL,
468 PRIMARY KEY (`uuid`
),
469 KEY `FK_sce_nets_scenarios`
(`scenario_id`
),
470 CONSTRAINT `FK_sce_nets_scenarios`
FOREIGN KEY (`scenario_id`
) REFERENCES `scenarios`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE
471 ) 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''.';
472 /*!40101 SET character_set_client = @saved_cs_client */;
475 -- Table structure for table `sce_vnfs`
478 DROP TABLE IF EXISTS `sce_vnfs`
;
479 /*!40101 SET @saved_cs_client = @@character_set_client */;
480 /*!40101 SET character_set_client = utf8 */;
481 CREATE TABLE `sce_vnfs`
(
482 `uuid`
varchar(36) NOT NULL,
483 `
name`
varchar(255) NOT NULL,
484 `scenario_id`
varchar(36) NOT NULL,
485 `vnf_id`
varchar(36) NOT NULL,
486 `description`
varchar(255) DEFAULT NULL,
487 `created_at`
double NOT NULL,
488 `modified_at`
double DEFAULT NULL,
489 `graph`
varchar(2000) DEFAULT NULL,
490 PRIMARY KEY (`uuid`
),
491 UNIQUE KEY `name_scenario_id`
(`
name`
,`scenario_id`
),
492 KEY `FK_sce_vnfs_scenarios`
(`scenario_id`
),
493 KEY `FK_sce_vnfs_vnfs`
(`vnf_id`
),
494 CONSTRAINT `FK_sce_vnfs_scenarios`
FOREIGN KEY (`scenario_id`
) REFERENCES `scenarios`
(`uuid`
) ON DELETE CASCADE ON UPDATE CASCADE,
495 CONSTRAINT `FK_sce_vnfs_vnfs`
FOREIGN KEY (`vnf_id`
) REFERENCES `vnfs`
(`uuid`
)
496 ) 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';
497 /*!40101 SET character_set_client = @saved_cs_client */;
500 -- Table structure for table `scenarios`
503 DROP TABLE IF EXISTS `scenarios`
;
504 /*!40101 SET @saved_cs_client = @@character_set_client */;
505 /*!40101 SET character_set_client = utf8 */;
506 CREATE TABLE `scenarios`
(
507 `uuid`
varchar(36) NOT NULL,
508 `
name`
varchar(255) NOT NULL,
509 `tenant_id`
varchar(36) DEFAULT NULL,
510 `description`
varchar(255) DEFAULT NULL,
511 `
public`
enum('true','false') NOT NULL DEFAULT 'false',
512 `created_at`
double NOT NULL,
513 `modified_at`
double DEFAULT NULL,
514 `
descriptor`
text COMMENT 'Original text descriptor used for create the scenario',
515 PRIMARY KEY (`uuid`
),
516 UNIQUE KEY `
name`
(`
name`
),
517 KEY `FK_scenarios_nfvo_tenants`
(`tenant_id`
),
518 CONSTRAINT `FK_scenarios_nfvo_tenants`
FOREIGN KEY (`tenant_id`
) REFERENCES `nfvo_tenants`
(`uuid`
)
519 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Scenarios defined by the user';
520 /*!40101 SET character_set_client = @saved_cs_client */;
523 -- Table structure for table `schema_version`
526 DROP TABLE IF EXISTS `schema_version`
;
527 /*!40101 SET @saved_cs_client = @@character_set_client */;
528 /*!40101 SET character_set_client = utf8 */;
529 CREATE TABLE `schema_version`
(
530 `version_int`
int(11) NOT NULL COMMENT 'version as a number. Must not contain gaps',
531 `
version`
varchar(20) NOT NULL COMMENT 'version as a text',
532 `openmano_ver`
varchar(20) NOT NULL COMMENT 'openmano version',
533 `
comments`
varchar(2000) DEFAULT NULL COMMENT 'changes to database',
534 `
date`
date DEFAULT NULL,
535 PRIMARY KEY (`version_int`
)
536 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
COMMENT='database schema control version';
537 /*!40101 SET character_set_client = @saved_cs_client */;
540 -- Table structure for table `tenants_datacenters`
543 DROP TABLE IF EXISTS `tenants_datacenters`
;
544 /*!40101 SET @saved_cs_client = @@character_set_client */;
545 /*!40101 SET character_set_client = utf8 */;
546 CREATE TABLE `tenants_datacenters`
(
547 `
id`
int(11) NOT NULL AUTO_INCREMENT
,
548 `nfvo_tenant_id`
varchar(36) NOT NULL,
549 `datacenter_id`
varchar(36) NOT NULL,
550 `datacenter_tenant_id`
varchar(36) NOT NULL,
551 `created_at`
double NOT NULL,
552 `modified_at`
double DEFAULT NULL,
554 UNIQUE KEY `datacenter_nfvo_tenant`
(`datacenter_id`
,`nfvo_tenant_id`
),
555 KEY `FK_nfvo_tenants_datacenters`
(`datacenter_id`
),
556 KEY `FK_nfvo_tenants_vim_tenants`
(`datacenter_tenant_id`
),
557 KEY `FK_tenants_datacenters_nfvo_tenants`
(`nfvo_tenant_id`
),
558 CONSTRAINT `FK_tenants_datacenters_datacenter_tenants`
FOREIGN KEY (`datacenter_tenant_id`
) REFERENCES `datacenter_tenants`
(`uuid`
),
559 CONSTRAINT `FK_tenants_datacenters_datacenters`
FOREIGN KEY (`datacenter_id`
) REFERENCES `datacenters`
(`uuid`
),
560 CONSTRAINT `FK_tenants_datacenters_nfvo_tenants`
FOREIGN KEY (`nfvo_tenant_id`
) REFERENCES `nfvo_tenants`
(`uuid`
)
561 ) ENGINE
=InnoDB AUTO_INCREMENT
=86 DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='Scenarios defined by the user';
562 /*!40101 SET character_set_client = @saved_cs_client */;
565 -- Table structure for table `uuids`
568 DROP TABLE IF EXISTS `uuids`
;
569 /*!40101 SET @saved_cs_client = @@character_set_client */;
570 /*!40101 SET character_set_client = utf8 */;
571 CREATE TABLE `uuids`
(
572 `uuid`
varchar(36) NOT NULL,
573 `root_uuid`
varchar(36) DEFAULT NULL COMMENT 'Some related UUIDs can be grouped by this field, so that they can be deleted at once',
574 `created_at`
double NOT NULL,
575 `used_at`
varchar(36) DEFAULT NULL COMMENT 'Table that uses this UUID',
577 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8
COMMENT='Table with all unique IDs used to avoid UUID repetitions among different elements';
578 /*!40101 SET character_set_client = @saved_cs_client */;
581 -- Table structure for table `vms`
584 DROP TABLE IF EXISTS `vms`
;
585 /*!40101 SET @saved_cs_client = @@character_set_client */;
586 /*!40101 SET character_set_client = utf8 */;
588 `uuid`
varchar(36) NOT NULL,
589 `
name`
varchar(255) NOT NULL,
590 `vnf_id`
varchar(36) NOT NULL,
591 `flavor_id`
varchar(36) NOT NULL COMMENT 'Link to flavor table',
592 `image_id`
varchar(36) NOT NULL COMMENT 'Link to image table',
593 `image_path`
varchar(100) NOT NULL COMMENT 'Path where the image of the VM is located',
594 `description`
varchar(255) DEFAULT NULL,
595 `created_at`
double NOT NULL,
596 `modified_at`
double DEFAULT NULL,
597 PRIMARY KEY (`uuid`
),
598 UNIQUE KEY `name_vnf_id`
(`
name`
,`vnf_id`
),
599 KEY `FK_vms_vnfs`
(`vnf_id`
),
600 KEY `FK_vms_images`
(`image_id`
),
601 KEY `FK_vms_flavors`
(`flavor_id`
),
602 CONSTRAINT `FK_vms_flavors`
FOREIGN KEY (`flavor_id`
) REFERENCES `flavors`
(`uuid`
),
603 CONSTRAINT `FK_vms_images`
FOREIGN KEY (`image_id`
) REFERENCES `images`
(`uuid`
),
604 CONSTRAINT `FK_vms_vnfs`
FOREIGN KEY (`vnf_id`
) REFERENCES `vnfs`
(`uuid`
) ON DELETE CASCADE
605 ) ENGINE
=InnoDB
DEFAULT CHARSET
=utf8 ROW_FORMAT
=COMPACT
COMMENT='VM definitions. It contains the set of VMs used by the VNF definitions.';
606 /*!40101 SET character_set_client = @saved_cs_client */;
609 -- Table structure for table `vnfs`
612 DROP TABLE IF EXISTS `vnfs`
;
613 /*!40101 SET @saved_cs_client = @@character_set_client */;
614 /*!40101 SET character_set_client = utf8 */;
615 CREATE TABLE `vnfs`
(
616 `uuid`
varchar(36) NOT NULL,
617 `
name`
varchar(255) NOT NULL,
618 `tenant_id`
varchar(36) DEFAULT NULL,
619 `physical`
enum('true','false') NOT NULL DEFAULT 'false',
620 `
public`
enum('true','false') NOT NULL DEFAULT 'false',
621 `description`
varchar(255) DEFAULT NULL,
622 `created_at`
double NOT NULL,
623 `modified_at`
double DEFAULT NULL,
624 `
class`
varchar(36) DEFAULT 'MISC',
625 `
descriptor`
text COMMENT 'Original text descriptor used for create the VNF',
626 PRIMARY KEY (`uuid`
),
627 KEY `FK_vnfs_nfvo_tenants`
(`tenant_id`
),
628 CONSTRAINT `FK_vnfs_nfvo_tenants`
FOREIGN KEY (`tenant_id`
) REFERENCES `nfvo_tenants`
(`uuid`
) ON DELETE SET NULL ON UPDATE CASCADE
629 ) 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';
630 /*!40101 SET character_set_client = @saved_cs_client */;
633 -- Dumping routines for database 'mano_db'
635 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
637 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
638 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
639 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
640 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
641 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
642 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
643 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
645 -- Dump completed on 2016-05-13 12:23:52
651 -- MySQL dump 10.13 Distrib 5.5.43, for debian-linux-gnu (x86_64)
653 -- Host: localhost Database: mano_db
654 -- ------------------------------------------------------
655 -- Server version 5.5.43-0ubuntu0.14.04.1
657 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
658 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
659 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
660 /*!40101 SET NAMES utf8 */;
661 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
662 /*!40103 SET TIME_ZONE='+00:00' */;
663 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
664 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
665 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
666 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
669 -- Dumping data for table `schema_version`
672 LOCK TABLES `schema_version`
WRITE;
673 /*!40000 ALTER TABLE `schema_version` DISABLE KEYS */;
674 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');
675 /*!40000 ALTER TABLE `schema_version` ENABLE KEYS */;
677 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
679 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
680 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
681 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
682 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
683 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
684 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
685 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
687 -- Dump completed on 2016-05-13 12:23:52