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