database_utils/mano_db_structure.sql

   1 /**
   2 * Copyright 2015 Telefónica Investigación y Desarrollo, S.A.U.
   3 * This file is part of openmano
   4 * All Rights Reserved.
   5 *
   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
   9 *
  10 *         http://www.apache.org/licenses/LICENSE-2.0
  11 *
  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
  16 * under the License.
  17 *
  18 * For those usages not covered by the Apache License, Version 2.0 please
  19 * contact with: nfvlabs@tid.es
  20 **/
  21
  22 -- MySQL dump 10.13  Distrib 5.5.43, for debian-linux-gnu (x86_64)
  23 --
  24 -- Host: localhost    Database: mano_db
  25 -- ------------------------------------------------------
  26 -- Server version       5.5.43-0ubuntu0.14.04.1
  27
  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 */;
  38
  39 --
  40 -- Table structure for table `datacenter_nets`
  41 --
  42
  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,
  57   PRIMARY KEY (`uuid`),
  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 */;
  63
  64 --
  65 -- Table structure for table `datacenter_tenants`
  66 --
  67
  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,
  81   PRIMARY KEY (`uuid`),
  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 */;
  86
  87 --
  88 -- Table structure for table `datacenters`
  89 --
  90
  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 */;
 108
 109 --
 110 -- Table structure for table `datacenters_flavors`
 111 --
 112
 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',
 122   PRIMARY KEY (`id`),
 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 */;
 129
 130 --
 131 -- Table structure for table `datacenters_images`
 132 --
 133
 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',
 143   PRIMARY KEY (`id`),
 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 */;
 150
 151 --
 152 -- Table structure for table `flavors`
 153 --
 154
 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',
 166   PRIMARY KEY (`uuid`)
 167 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 168 /*!40101 SET character_set_client = @saved_cs_client */;
 169
 170 --
 171 -- Table structure for table `images`
 172 --
 173
 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 */;
 187
 188 --
 189 -- Table structure for table `instance_interfaces`
 190 --
 191
 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,
 203   `vim_info` text,
 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 */;
 214
 215 --
 216 -- Table structure for table `instance_nets`
 217 --
 218
 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,
 232   `vim_info` text,
 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 */;
 251
 252 --
 253 -- Table structure for table `instance_scenarios`
 254 --
 255
 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 */;
 281
 282 --
 283 -- Table structure for table `instance_vms`
 284 --
 285
 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,
 296   `vim_info` text,
 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 */;
 307
 308 --
 309 -- Table structure for table `instance_vnfs`
 310 --
 311
 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 */;
 337
 338 --
 339 -- Table structure for table `interfaces`
 340 --
 341
 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 */;
 366
 367 --
 368 -- Table structure for table `logs`
 369 --
 370
 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,
 382   PRIMARY KEY (`id`)
 383 ) ENGINE=InnoDB AUTO_INCREMENT=3423 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
 384 /*!40101 SET character_set_client = @saved_cs_client */;
 385
 386 --
 387 -- Table structure for table `nets`
 388 --
 389
 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 */;
 407
 408 --
 409 -- Table structure for table `nfvo_tenants`
 410 --
 411
 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 */;
 425
 426 --
 427 -- Table structure for table `sce_interfaces`
 428 --
 429
 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 */;
 449
 450 --
 451 -- Table structure for table `sce_nets`
 452 --
 453
 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 */;
 473
 474 --
 475 -- Table structure for table `sce_vnfs`
 476 --
 477
 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 */;
 498
 499 --
 500 -- Table structure for table `scenarios`
 501 --
 502
 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 */;
 521
 522 --
 523 -- Table structure for table `schema_version`
 524 --
 525
 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 */;
 538
 539 --
 540 -- Table structure for table `tenants_datacenters`
 541 --
 542
 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,
 553   PRIMARY KEY (`id`),
 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 */;
 563
 564 --
 565 -- Table structure for table `uuids`
 566 --
 567
 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',
 576   PRIMARY KEY (`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 */;
 579
 580 --
 581 -- Table structure for table `vms`
 582 --
 583
 584 DROP TABLE IF EXISTS `vms`;
 585 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 586 /*!40101 SET character_set_client = utf8 */;
 587 CREATE TABLE `vms` (
 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 */;
 607
 608 --
 609 -- Table structure for table `vnfs`
 610 --
 611
 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 */;
 631
 632 --
 633 -- Dumping routines for database 'mano_db'
 634 --
 635 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 636
 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 */;
 644
 645 -- Dump completed on 2016-05-13 12:23:52
 646
 647
 648
 649
 650
 651 -- MySQL dump 10.13  Distrib 5.5.43, for debian-linux-gnu (x86_64)
 652 --
 653 -- Host: localhost    Database: mano_db
 654 -- ------------------------------------------------------
 655 -- Server version       5.5.43-0ubuntu0.14.04.1
 656
 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 */;
 667
 668 --
 669 -- Dumping data for table `schema_version`
 670 --
 671
 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 */;
 676 UNLOCK TABLES;
 677 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 678
 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 */;
 686
 687 -- Dump completed on 2016-05-13 12:23:52