database_utils/mano_db_structure.sql

   1 /**
   2 * Copyright 2017 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.7.18, for Linux (x86_64)
  23 --
  24 -- Host: localhost    Database: {{mano_db}}
  25 -- ------------------------------------------------------
  26 -- Server version       5.7.18-0ubuntu0.16.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(256) DEFAULT NULL,
  85   `vim_tenant_id` varchar(256) 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   `config` varchar(4000) DEFAULT NULL,
  90   `created_at` double NOT NULL,
  91   `modified_at` double DEFAULT NULL,
  92   PRIMARY KEY (`uuid`),
  93   KEY `FK_vim_tenants_datacenters` (`datacenter_id`),
  94   CONSTRAINT `FK_vim_tenants_datacenters` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE
  95 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Scenarios defined by the user';
  96 /*!40101 SET character_set_client = @saved_cs_client */;
  97
  98 --
  99 -- Table structure for table `datacenters`
 100 --
 101
 102 DROP TABLE IF EXISTS `datacenters`;
 103 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 104 /*!40101 SET character_set_client = utf8 */;
 105 CREATE TABLE `datacenters` (
 106   `uuid` varchar(36) NOT NULL,
 107   `name` varchar(255) NOT NULL,
 108   `description` varchar(255) DEFAULT NULL,
 109   `type` varchar(36) NOT NULL DEFAULT 'openvim',
 110   `vim_url` varchar(150) NOT NULL COMMENT 'URL of the VIM for the REST API',
 111   `vim_url_admin` varchar(150) DEFAULT NULL,
 112   `config` varchar(4000) DEFAULT NULL COMMENT 'extra config information in json',
 113   `created_at` double NOT NULL,
 114   `modified_at` double DEFAULT NULL,
 115   PRIMARY KEY (`uuid`),
 116   UNIQUE KEY `name` (`name`)
 117 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Datacenters managed by the NFVO.';
 118 /*!40101 SET character_set_client = @saved_cs_client */;
 119
 120 --
 121 -- Table structure for table `datacenters_flavors`
 122 --
 123
 124 DROP TABLE IF EXISTS `datacenters_flavors`;
 125 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 126 /*!40101 SET character_set_client = utf8 */;
 127 CREATE TABLE `datacenters_flavors` (
 128   `id` int(11) NOT NULL AUTO_INCREMENT,
 129   `flavor_id` varchar(36) NOT NULL,
 130   `datacenter_id` varchar(36) NOT NULL,
 131   `vim_id` varchar(36) NOT NULL,
 132   `created` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if it has been created by openmano, or already existed',
 133   `extended` varchar(2000) DEFAULT NULL COMMENT 'Extra description json format of additional devices',
 134   PRIMARY KEY (`id`),
 135   KEY `FK__flavors` (`flavor_id`),
 136   KEY `FK__datacenters_f` (`datacenter_id`),
 137   CONSTRAINT `FK__datacenters_f` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE,
 138   CONSTRAINT `FK__flavors` FOREIGN KEY (`flavor_id`) REFERENCES `flavors` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE
 139 ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;
 140 /*!40101 SET character_set_client = @saved_cs_client */;
 141
 142 --
 143 -- Table structure for table `datacenters_images`
 144 --
 145
 146 DROP TABLE IF EXISTS `datacenters_images`;
 147 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 148 /*!40101 SET character_set_client = utf8 */;
 149 CREATE TABLE `datacenters_images` (
 150   `id` int(11) NOT NULL AUTO_INCREMENT,
 151   `image_id` varchar(36) NOT NULL,
 152   `datacenter_id` varchar(36) NOT NULL,
 153   `vim_id` varchar(36) NOT NULL,
 154   `created` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if it has been created by openmano, or already existed',
 155   PRIMARY KEY (`id`),
 156   KEY `FK__images` (`image_id`),
 157   KEY `FK__datacenters_i` (`datacenter_id`),
 158   CONSTRAINT `FK__datacenters_i` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE,
 159   CONSTRAINT `FK__images` FOREIGN KEY (`image_id`) REFERENCES `images` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE
 160 ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;
 161 /*!40101 SET character_set_client = @saved_cs_client */;
 162
 163 --
 164 -- Table structure for table `flavors`
 165 --
 166
 167 DROP TABLE IF EXISTS `flavors`;
 168 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 169 /*!40101 SET character_set_client = utf8 */;
 170 CREATE TABLE `flavors` (
 171   `uuid` varchar(36) NOT NULL,
 172   `name` varchar(255) NOT NULL,
 173   `description` varchar(255) DEFAULT NULL,
 174   `disk` smallint(5) unsigned DEFAULT NULL,
 175   `ram` smallint(5) unsigned DEFAULT NULL,
 176   `vcpus` smallint(5) unsigned DEFAULT NULL,
 177   `extended` varchar(2000) DEFAULT NULL COMMENT 'Extra description json format of needed resources and pining, orginized in sets per numa',
 178   PRIMARY KEY (`uuid`)
 179 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 180 /*!40101 SET character_set_client = @saved_cs_client */;
 181
 182 --
 183 -- Table structure for table `images`
 184 --
 185
 186 DROP TABLE IF EXISTS `images`;
 187 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 188 /*!40101 SET character_set_client = utf8 */;
 189 CREATE TABLE `images` (
 190   `uuid` varchar(36) NOT NULL,
 191   `name` varchar(255) NOT NULL,
 192   `universal_name` varchar(255) DEFAULT NULL,
 193   `checksum` varchar(32) DEFAULT NULL,
 194   `location` varchar(200) DEFAULT NULL,
 195   `description` varchar(255) DEFAULT NULL,
 196   `metadata` varchar(2000) DEFAULT NULL,
 197   PRIMARY KEY (`uuid`),
 198   UNIQUE KEY `location` (`location`),
 199   UNIQUE KEY `universal_name_checksum` (`universal_name`,`checksum`)
 200 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 201 /*!40101 SET character_set_client = @saved_cs_client */;
 202
 203 --
 204 -- Table structure for table `instance_interfaces`
 205 --
 206
 207 DROP TABLE IF EXISTS `instance_interfaces`;
 208 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 209 /*!40101 SET character_set_client = utf8 */;
 210 CREATE TABLE `instance_interfaces` (
 211   `uuid` varchar(36) NOT NULL,
 212   `instance_vm_id` varchar(36) NOT NULL,
 213   `instance_net_id` varchar(36) NOT NULL,
 214   `interface_id` varchar(36) NOT NULL,
 215   `vim_interface_id` varchar(36) DEFAULT NULL COMMENT 'vim identity for that interface',
 216   `mac_address` varchar(32) DEFAULT NULL,
 217   `ip_address` varchar(64) DEFAULT NULL,
 218   `vim_info` text,
 219   `type` enum('internal','external') NOT NULL COMMENT 'Indicates if this interface is external to a vnf, or internal',
 220   `floating_ip` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates if a floating_ip must be associated to this interface',
 221   `port_security` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Indicates if port security must be enabled or disabled. By default it is enabled',
 222   `sdn_port_id` varchar(36) DEFAULT NULL COMMENT 'Port id in ovim',
 223   `compute_node` varchar(100) DEFAULT NULL COMMENT 'Compute node id used to specify the SDN port mapping',
 224   `pci` varchar(12) DEFAULT NULL COMMENT 'PCI of the physical port in the host',
 225   `vlan` smallint(5) unsigned DEFAULT NULL COMMENT 'VLAN tag used by the port',
 226   PRIMARY KEY (`uuid`),
 227   KEY `FK_instance_vms` (`instance_vm_id`),
 228   KEY `FK_instance_nets` (`instance_net_id`),
 229   KEY `FK_instance_ids` (`interface_id`),
 230   CONSTRAINT `FK_instance_ids` FOREIGN KEY (`interface_id`) REFERENCES `interfaces` (`uuid`),
 231   CONSTRAINT `FK_instance_nets` FOREIGN KEY (`instance_net_id`) REFERENCES `instance_nets` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE,
 232   CONSTRAINT `FK_instance_vms` FOREIGN KEY (`instance_vm_id`) REFERENCES `instance_vms` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE
 233 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Table with all running associattion among VM instances and net instances';
 234 /*!40101 SET character_set_client = @saved_cs_client */;
 235
 236 --
 237 -- Table structure for table `instance_nets`
 238 --
 239
 240 DROP TABLE IF EXISTS `instance_nets`;
 241 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 242 /*!40101 SET character_set_client = utf8 */;
 243 CREATE TABLE `instance_nets` (
 244   `uuid` varchar(36) NOT NULL,
 245   `vim_net_id` varchar(36) NOT NULL COMMENT 'Network ID in the VIM DB',
 246   `instance_scenario_id` varchar(36) NOT NULL,
 247   `sce_net_id` varchar(36) DEFAULT NULL,
 248   `net_id` varchar(36) DEFAULT NULL,
 249   `datacenter_id` varchar(36) DEFAULT NULL,
 250   `datacenter_tenant_id` varchar(36) NOT NULL,
 251   `status` enum('ACTIVE','DOWN','BUILD','ERROR','VIM_ERROR','INACTIVE','DELETED') NOT NULL DEFAULT 'BUILD',
 252   `error_msg` varchar(1024) DEFAULT NULL,
 253   `vim_info` text,
 254   `multipoint` enum('true','false') NOT NULL DEFAULT 'true',
 255   `created` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Created or already exists at VIM',
 256   `created_at` double NOT NULL,
 257   `modified_at` double DEFAULT NULL,
 258   `sdn_net_id` varchar(36) DEFAULT NULL COMMENT 'Network id in ovim',
 259   PRIMARY KEY (`uuid`),
 260   KEY `FK_instance_nets_instance_scenarios` (`instance_scenario_id`),
 261   KEY `FK_instance_nets_sce_nets` (`sce_net_id`),
 262   KEY `FK_instance_nets_nets` (`net_id`),
 263   KEY `FK_instance_nets_datacenters` (`datacenter_id`),
 264   KEY `FK_instance_nets_datacenter_tenants` (`datacenter_tenant_id`),
 265   CONSTRAINT `FK_instance_nets_datacenter_tenants` FOREIGN KEY (`datacenter_tenant_id`) REFERENCES `datacenter_tenants` (`uuid`),
 266   CONSTRAINT `FK_instance_nets_datacenters` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`),
 267   CONSTRAINT `FK_instance_nets_instance_scenarios` FOREIGN KEY (`instance_scenario_id`) REFERENCES `instance_scenarios` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE,
 268   CONSTRAINT `FK_instance_nets_nets` FOREIGN KEY (`net_id`) REFERENCES `nets` (`uuid`) ON DELETE SET NULL ON UPDATE CASCADE,
 269   CONSTRAINT `FK_instance_nets_sce_nets` FOREIGN KEY (`sce_net_id`) REFERENCES `sce_nets` (`uuid`) ON DELETE SET NULL ON UPDATE CASCADE
 270 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Instances of networks';
 271 /*!40101 SET character_set_client = @saved_cs_client */;
 272
 273 --
 274 -- Table structure for table `instance_scenarios`
 275 --
 276
 277 DROP TABLE IF EXISTS `instance_scenarios`;
 278 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 279 /*!40101 SET character_set_client = utf8 */;
 280 CREATE TABLE `instance_scenarios` (
 281   `uuid` varchar(36) NOT NULL,
 282   `name` varchar(255) NOT NULL,
 283   `tenant_id` varchar(36) DEFAULT NULL,
 284   `scenario_id` varchar(36) NOT NULL,
 285   `datacenter_id` varchar(36) NOT NULL,
 286   `datacenter_tenant_id` varchar(36) NOT NULL,
 287   `description` varchar(255) DEFAULT NULL,
 288   `created_at` double NOT NULL,
 289   `modified_at` double DEFAULT NULL,
 290   `cloud_config` mediumtext,
 291   PRIMARY KEY (`uuid`),
 292   KEY `FK_scenarios_nfvo_tenants` (`tenant_id`),
 293   KEY `FK_instance_scenarios_vim_tenants` (`datacenter_tenant_id`),
 294   KEY `FK_instance_scenarios_datacenters` (`datacenter_id`),
 295   KEY `FK_instance_scenarios_scenarios` (`scenario_id`),
 296   CONSTRAINT `FK_instance_scenarios_datacenter_tenants` FOREIGN KEY (`datacenter_tenant_id`) REFERENCES `datacenter_tenants` (`uuid`),
 297   CONSTRAINT `FK_instance_scenarios_datacenters` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`),
 298   CONSTRAINT `FK_instance_scenarios_nfvo_tenants` FOREIGN KEY (`tenant_id`) REFERENCES `nfvo_tenants` (`uuid`),
 299   CONSTRAINT `FK_instance_scenarios_scenarios` FOREIGN KEY (`scenario_id`) REFERENCES `scenarios` (`uuid`)
 300 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Instances of scenarios defined by the user';
 301 /*!40101 SET character_set_client = @saved_cs_client */;
 302
 303 --
 304 -- Table structure for table `instance_vms`
 305 --
 306
 307 DROP TABLE IF EXISTS `instance_vms`;
 308 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 309 /*!40101 SET character_set_client = utf8 */;
 310 CREATE TABLE `instance_vms` (
 311   `uuid` varchar(36) NOT NULL,
 312   `instance_vnf_id` varchar(36) NOT NULL,
 313   `vm_id` varchar(36) NOT NULL,
 314   `vim_vm_id` varchar(36) NOT NULL COMMENT 'VM ID in the VIM DB',
 315   `status` enum('ACTIVE:NoMgmtIP','ACTIVE','INACTIVE','BUILD','ERROR','VIM_ERROR','PAUSED','SUSPENDED','DELETED') NOT NULL DEFAULT 'BUILD',
 316   `error_msg` varchar(1024) DEFAULT NULL,
 317   `vim_info` text,
 318   `created_at` double NOT NULL,
 319   `modified_at` double DEFAULT NULL,
 320   PRIMARY KEY (`uuid`),
 321   UNIQUE KEY `vim_vm_id` (`vim_vm_id`),
 322   KEY `FK_instance_vms_vms` (`vm_id`),
 323   KEY `FK_instance_vms_instance_vnfs` (`instance_vnf_id`),
 324   CONSTRAINT `FK_instance_vms_instance_vnfs` FOREIGN KEY (`instance_vnf_id`) REFERENCES `instance_vnfs` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE,
 325   CONSTRAINT `FK_instance_vms_vms` FOREIGN KEY (`vm_id`) REFERENCES `vms` (`uuid`)
 326 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Instances of VMs as part of VNF instances';
 327 /*!40101 SET character_set_client = @saved_cs_client */;
 328
 329 --
 330 -- Table structure for table `instance_vnfs`
 331 --
 332
 333 DROP TABLE IF EXISTS `instance_vnfs`;
 334 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 335 /*!40101 SET character_set_client = utf8 */;
 336 CREATE TABLE `instance_vnfs` (
 337   `uuid` varchar(36) NOT NULL,
 338   `instance_scenario_id` varchar(36) NOT NULL,
 339   `vnf_id` varchar(36) NOT NULL,
 340   `sce_vnf_id` varchar(36) DEFAULT NULL,
 341   `datacenter_id` varchar(36) DEFAULT NULL,
 342   `datacenter_tenant_id` varchar(36) DEFAULT NULL,
 343   `created_at` double NOT NULL,
 344   `modified_at` double DEFAULT NULL,
 345   PRIMARY KEY (`uuid`),
 346   KEY `FK_instance_vnfs_vnfs` (`vnf_id`),
 347   KEY `FK_instance_vnfs_instance_scenarios` (`instance_scenario_id`),
 348   KEY `FK_instance_vnfs_sce_vnfs` (`sce_vnf_id`),
 349   KEY `FK_instance_vnfs_datacenters` (`datacenter_id`),
 350   KEY `FK_instance_vnfs_datacenter_tenants` (`datacenter_tenant_id`),
 351   CONSTRAINT `FK_instance_vnfs_datacenter_tenants` FOREIGN KEY (`datacenter_tenant_id`) REFERENCES `datacenter_tenants` (`uuid`),
 352   CONSTRAINT `FK_instance_vnfs_datacenters` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`),
 353   CONSTRAINT `FK_instance_vnfs_instance_scenarios` FOREIGN KEY (`instance_scenario_id`) REFERENCES `instance_scenarios` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE,
 354   CONSTRAINT `FK_instance_vnfs_sce_vnfs` FOREIGN KEY (`sce_vnf_id`) REFERENCES `sce_vnfs` (`uuid`) ON DELETE SET NULL ON UPDATE CASCADE,
 355   CONSTRAINT `FK_instance_vnfs_vnfs` FOREIGN KEY (`vnf_id`) REFERENCES `vnfs` (`uuid`)
 356 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Instances of VNFs as part of a scenario';
 357 /*!40101 SET character_set_client = @saved_cs_client */;
 358
 359 --
 360 -- Table structure for table `interfaces`
 361 --
 362
 363 DROP TABLE IF EXISTS `interfaces`;
 364 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 365 /*!40101 SET character_set_client = utf8 */;
 366 CREATE TABLE `interfaces` (
 367   `uuid` varchar(36) NOT NULL,
 368   `internal_name` varchar(255) NOT NULL,
 369   `external_name` varchar(255) DEFAULT NULL,
 370   `vm_id` varchar(36) NOT NULL,
 371   `net_id` varchar(36) DEFAULT NULL,
 372   `type` enum('mgmt','bridge','data') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
 373   `vpci` char(12) DEFAULT NULL,
 374   `bw` mediumint(8) unsigned DEFAULT NULL COMMENT 'BW expressed in Mbits/s. Maybe this field is not necessary.',
 375   `created_at` double NOT NULL,
 376   `modified_at` double DEFAULT NULL,
 377   `model` varchar(12) DEFAULT NULL,
 378   `mac` char(18) DEFAULT NULL,
 379   `ip_address` varchar(64) DEFAULT NULL,
 380   `floating_ip` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'Indicates if a floating_ip must be associated to this interface',
 381   `port_security` tinyint(1) NOT NULL DEFAULT '1' COMMENT 'Indicates if port security must be enabled or disabled. By default it is enabled',
 382   PRIMARY KEY (`uuid`),
 383   UNIQUE KEY `internal_name_vm_id` (`internal_name`,`vm_id`),
 384   KEY `FK_interfaces_vms` (`vm_id`),
 385   KEY `FK_interfaces_nets` (`net_id`),
 386   CONSTRAINT `FK_interfaces_nets` FOREIGN KEY (`net_id`) REFERENCES `nets` (`uuid`) ON DELETE CASCADE,
 387   CONSTRAINT `FK_interfaces_vms` FOREIGN KEY (`vm_id`) REFERENCES `vms` (`uuid`) ON DELETE CASCADE
 388 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='VM interfaces';
 389 /*!40101 SET character_set_client = @saved_cs_client */;
 390
 391 --
 392 -- Table structure for table `ip_profiles`
 393 --
 394
 395 DROP TABLE IF EXISTS `ip_profiles`;
 396 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 397 /*!40101 SET character_set_client = utf8 */;
 398 CREATE TABLE `ip_profiles` (
 399   `id` int(11) NOT NULL AUTO_INCREMENT,
 400   `net_id` varchar(36) DEFAULT NULL,
 401   `sce_net_id` varchar(36) DEFAULT NULL,
 402   `instance_net_id` varchar(36) DEFAULT NULL,
 403   `ip_version` enum('IPv4','IPv6') NOT NULL DEFAULT 'IPv4',
 404   `subnet_address` varchar(64) DEFAULT NULL,
 405   `gateway_address` varchar(64) DEFAULT NULL,
 406   `dns_address` varchar(64) DEFAULT NULL,
 407   `dhcp_enabled` enum('true','false') NOT NULL DEFAULT 'true',
 408   `dhcp_start_address` varchar(64) DEFAULT NULL,
 409   `dhcp_count` int(11) DEFAULT NULL,
 410   PRIMARY KEY (`id`),
 411   KEY `FK_ipprofiles_nets` (`net_id`),
 412   KEY `FK_ipprofiles_scenets` (`sce_net_id`),
 413   KEY `FK_ipprofiles_instancenets` (`instance_net_id`),
 414   CONSTRAINT `FK_ipprofiles_instancenets` FOREIGN KEY (`instance_net_id`) REFERENCES `instance_nets` (`uuid`) ON DELETE CASCADE,
 415   CONSTRAINT `FK_ipprofiles_nets` FOREIGN KEY (`net_id`) REFERENCES `nets` (`uuid`) ON DELETE CASCADE,
 416   CONSTRAINT `FK_ipprofiles_scenets` FOREIGN KEY (`sce_net_id`) REFERENCES `sce_nets` (`uuid`) ON DELETE CASCADE
 417 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table containing the IP parameters of a network, either a net, a sce_net or and instance_net.';
 418 /*!40101 SET character_set_client = @saved_cs_client */;
 419
 420 --
 421 -- Table structure for table `logs`
 422 --
 423
 424 DROP TABLE IF EXISTS `logs`;
 425 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 426 /*!40101 SET character_set_client = utf8 */;
 427 CREATE TABLE `logs` (
 428   `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
 429   `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
 430   `nfvo_tenant_id` varchar(36) DEFAULT NULL,
 431   `related` varchar(36) NOT NULL COMMENT 'Relevant element for the log',
 432   `uuid` varchar(36) DEFAULT NULL COMMENT 'Uuid of vnf, scenario, etc. that log relates to',
 433   `level` enum('panic','error','info','debug','verbose') NOT NULL,
 434   `description` varchar(200) NOT NULL,
 435   PRIMARY KEY (`id`)
 436 ) ENGINE=InnoDB AUTO_INCREMENT=3423 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
 437 /*!40101 SET character_set_client = @saved_cs_client */;
 438
 439 --
 440 -- Table structure for table `nets`
 441 --
 442
 443 DROP TABLE IF EXISTS `nets`;
 444 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 445 /*!40101 SET character_set_client = utf8 */;
 446 CREATE TABLE `nets` (
 447   `uuid` varchar(36) NOT NULL,
 448   `vnf_id` varchar(36) NOT NULL,
 449   `name` varchar(255) NOT NULL,
 450   `type` enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
 451   `multipoint` enum('true','false') NOT NULL DEFAULT 'false',
 452   `description` varchar(255) DEFAULT NULL,
 453   `created_at` double NOT NULL,
 454   `modified_at` double DEFAULT NULL,
 455   PRIMARY KEY (`uuid`),
 456   UNIQUE KEY `vnf_id_name` (`vnf_id`,`name`),
 457   CONSTRAINT `FK_nets_vnfs` FOREIGN KEY (`vnf_id`) REFERENCES `vnfs` (`uuid`) ON DELETE CASCADE
 458 ) 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.';
 459 /*!40101 SET character_set_client = @saved_cs_client */;
 460
 461 --
 462 -- Table structure for table `nfvo_tenants`
 463 --
 464
 465 DROP TABLE IF EXISTS `nfvo_tenants`;
 466 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 467 /*!40101 SET character_set_client = utf8 */;
 468 CREATE TABLE `nfvo_tenants` (
 469   `uuid` varchar(36) NOT NULL,
 470   `name` varchar(255) NOT NULL,
 471   `description` varchar(255) DEFAULT NULL,
 472   `created_at` double NOT NULL,
 473   `modified_at` double DEFAULT NULL,
 474   PRIMARY KEY (`uuid`),
 475   UNIQUE KEY `name` (`name`)
 476 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Scenarios defined by the user';
 477 /*!40101 SET character_set_client = @saved_cs_client */;
 478
 479 --
 480 -- Table structure for table `sce_interfaces`
 481 --
 482
 483 DROP TABLE IF EXISTS `sce_interfaces`;
 484 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 485 /*!40101 SET character_set_client = utf8 */;
 486 CREATE TABLE `sce_interfaces` (
 487   `uuid` varchar(36) NOT NULL,
 488   `sce_vnf_id` varchar(36) NOT NULL,
 489   `sce_net_id` varchar(36) DEFAULT NULL,
 490   `interface_id` varchar(36) DEFAULT NULL,
 491   `ip_address` varchar(64) DEFAULT NULL,
 492   `created_at` double NOT NULL,
 493   `modified_at` double DEFAULT NULL,
 494   PRIMARY KEY (`uuid`),
 495   KEY `FK_sce_interfaces_sce_vnfs` (`sce_vnf_id`),
 496   KEY `FK_sce_interfaces_sce_nets` (`sce_net_id`),
 497   KEY `FK_sce_interfaces_interfaces` (`interface_id`),
 498   CONSTRAINT `FK_sce_interfaces_interfaces` FOREIGN KEY (`interface_id`) REFERENCES `interfaces` (`uuid`),
 499   CONSTRAINT `FK_sce_interfaces_sce_nets` FOREIGN KEY (`sce_net_id`) REFERENCES `sce_nets` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE,
 500   CONSTRAINT `FK_sce_interfaces_sce_vnfs` FOREIGN KEY (`sce_vnf_id`) REFERENCES `sce_vnfs` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE
 501 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='VNF interfaces in a scenario definition.';
 502 /*!40101 SET character_set_client = @saved_cs_client */;
 503
 504 --
 505 -- Table structure for table `sce_nets`
 506 --
 507
 508 DROP TABLE IF EXISTS `sce_nets`;
 509 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 510 /*!40101 SET character_set_client = utf8 */;
 511 CREATE TABLE `sce_nets` (
 512   `uuid` varchar(36) NOT NULL,
 513   `name` varchar(255) NOT NULL,
 514   `scenario_id` varchar(36) DEFAULT NULL COMMENT 'NULL if net is matched to several scenarios',
 515   `type` enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network',
 516   `multipoint` enum('true','false') NOT NULL DEFAULT 'true',
 517   `external` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'If external, net is already present at VIM',
 518   `description` varchar(255) DEFAULT NULL,
 519   `created_at` double NOT NULL,
 520   `modified_at` double DEFAULT NULL,
 521   `graph` varchar(2000) DEFAULT NULL,
 522   PRIMARY KEY (`uuid`),
 523   KEY `FK_sce_nets_scenarios` (`scenario_id`),
 524   CONSTRAINT `FK_sce_nets_scenarios` FOREIGN KEY (`scenario_id`) REFERENCES `scenarios` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE
 525 ) 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''.';
 526 /*!40101 SET character_set_client = @saved_cs_client */;
 527
 528 --
 529 -- Table structure for table `sce_vnfs`
 530 --
 531
 532 DROP TABLE IF EXISTS `sce_vnfs`;
 533 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 534 /*!40101 SET character_set_client = utf8 */;
 535 CREATE TABLE `sce_vnfs` (
 536   `uuid` varchar(36) NOT NULL,
 537   `name` varchar(255) NOT NULL,
 538   `scenario_id` varchar(36) NOT NULL,
 539   `vnf_id` varchar(36) NOT NULL,
 540   `description` varchar(255) DEFAULT NULL,
 541   `created_at` double NOT NULL,
 542   `modified_at` double DEFAULT NULL,
 543   `graph` varchar(2000) DEFAULT NULL,
 544   PRIMARY KEY (`uuid`),
 545   UNIQUE KEY `name_scenario_id` (`name`,`scenario_id`),
 546   KEY `FK_sce_vnfs_scenarios` (`scenario_id`),
 547   KEY `FK_sce_vnfs_vnfs` (`vnf_id`),
 548   CONSTRAINT `FK_sce_vnfs_scenarios` FOREIGN KEY (`scenario_id`) REFERENCES `scenarios` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE,
 549   CONSTRAINT `FK_sce_vnfs_vnfs` FOREIGN KEY (`vnf_id`) REFERENCES `vnfs` (`uuid`)
 550 ) 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';
 551 /*!40101 SET character_set_client = @saved_cs_client */;
 552
 553 --
 554 -- Table structure for table `scenarios`
 555 --
 556
 557 DROP TABLE IF EXISTS `scenarios`;
 558 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 559 /*!40101 SET character_set_client = utf8 */;
 560 CREATE TABLE `scenarios` (
 561   `uuid` varchar(36) NOT NULL,
 562   `name` varchar(255) NOT NULL,
 563   `tenant_id` varchar(36) DEFAULT NULL,
 564   `description` varchar(255) DEFAULT NULL,
 565   `public` enum('true','false') NOT NULL DEFAULT 'false',
 566   `created_at` double NOT NULL,
 567   `modified_at` double DEFAULT NULL,
 568   `descriptor` text COMMENT 'Original text descriptor used for create the scenario',
 569   `cloud_config` mediumtext,
 570   PRIMARY KEY (`uuid`),
 571   KEY `FK_scenarios_nfvo_tenants` (`tenant_id`),
 572   CONSTRAINT `FK_scenarios_nfvo_tenants` FOREIGN KEY (`tenant_id`) REFERENCES `nfvo_tenants` (`uuid`)
 573 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Scenarios defined by the user';
 574 /*!40101 SET character_set_client = @saved_cs_client */;
 575
 576 --
 577 -- Table structure for table `schema_version`
 578 --
 579
 580 DROP TABLE IF EXISTS `schema_version`;
 581 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 582 /*!40101 SET character_set_client = utf8 */;
 583 CREATE TABLE `schema_version` (
 584   `version_int` int(11) NOT NULL COMMENT 'version as a number. Must not contain gaps',
 585   `version` varchar(20) NOT NULL COMMENT 'version as a text',
 586   `openmano_ver` varchar(20) NOT NULL COMMENT 'openmano version',
 587   `comments` varchar(2000) DEFAULT NULL COMMENT 'changes to database',
 588   `date` date DEFAULT NULL,
 589   PRIMARY KEY (`version_int`)
 590 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='database schema control version';
 591 /*!40101 SET character_set_client = @saved_cs_client */;
 592
 593 --
 594 -- Table structure for table `tenants_datacenters`
 595 --
 596
 597 DROP TABLE IF EXISTS `tenants_datacenters`;
 598 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 599 /*!40101 SET character_set_client = utf8 */;
 600 CREATE TABLE `tenants_datacenters` (
 601   `id` int(11) NOT NULL AUTO_INCREMENT,
 602   `nfvo_tenant_id` varchar(36) NOT NULL,
 603   `datacenter_id` varchar(36) NOT NULL,
 604   `datacenter_tenant_id` varchar(36) NOT NULL,
 605   `created_at` double NOT NULL,
 606   `modified_at` double DEFAULT NULL,
 607   PRIMARY KEY (`id`),
 608   UNIQUE KEY `datacenter_nfvo_tenant` (`datacenter_id`,`nfvo_tenant_id`),
 609   KEY `FK_nfvo_tenants_datacenters` (`datacenter_id`),
 610   KEY `FK_nfvo_tenants_vim_tenants` (`datacenter_tenant_id`),
 611   KEY `FK_tenants_datacenters_nfvo_tenants` (`nfvo_tenant_id`),
 612   CONSTRAINT `FK_tenants_datacenters_datacenter_tenants` FOREIGN KEY (`datacenter_tenant_id`) REFERENCES `datacenter_tenants` (`uuid`),
 613   CONSTRAINT `FK_tenants_datacenters_datacenters` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`),
 614   CONSTRAINT `FK_tenants_datacenters_nfvo_tenants` FOREIGN KEY (`nfvo_tenant_id`) REFERENCES `nfvo_tenants` (`uuid`)
 615 ) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Scenarios defined by the user';
 616 /*!40101 SET character_set_client = @saved_cs_client */;
 617
 618 --
 619 -- Table structure for table `uuids`
 620 --
 621
 622 DROP TABLE IF EXISTS `uuids`;
 623 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 624 /*!40101 SET character_set_client = utf8 */;
 625 CREATE TABLE `uuids` (
 626   `uuid` varchar(36) NOT NULL,
 627   `root_uuid` varchar(36) DEFAULT NULL COMMENT 'Some related UUIDs can be grouped by this field, so that they can be deleted at once',
 628   `created_at` double NOT NULL,
 629   `used_at` varchar(36) DEFAULT NULL COMMENT 'Table that uses this UUID',
 630   PRIMARY KEY (`uuid`)
 631 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table with all unique IDs used to avoid UUID repetitions among different elements';
 632 /*!40101 SET character_set_client = @saved_cs_client */;
 633
 634 --
 635 -- Table structure for table `vms`
 636 --
 637
 638 DROP TABLE IF EXISTS `vms`;
 639 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 640 /*!40101 SET character_set_client = utf8 */;
 641 CREATE TABLE `vms` (
 642   `uuid` varchar(36) NOT NULL,
 643   `name` varchar(255) NOT NULL,
 644   `vnf_id` varchar(36) NOT NULL,
 645   `flavor_id` varchar(36) NOT NULL COMMENT 'Link to flavor table',
 646   `image_id` varchar(36) NOT NULL COMMENT 'Link to image table',
 647   `image_path` varchar(100) DEFAULT NULL COMMENT 'Path where the image of the VM is located',
 648   `boot_data` text,
 649   `description` varchar(255) DEFAULT NULL,
 650   `created_at` double NOT NULL,
 651   `modified_at` double DEFAULT NULL,
 652   PRIMARY KEY (`uuid`),
 653   UNIQUE KEY `name_vnf_id` (`name`,`vnf_id`),
 654   KEY `FK_vms_vnfs` (`vnf_id`),
 655   KEY `FK_vms_images` (`image_id`),
 656   KEY `FK_vms_flavors` (`flavor_id`),
 657   CONSTRAINT `FK_vms_flavors` FOREIGN KEY (`flavor_id`) REFERENCES `flavors` (`uuid`),
 658   CONSTRAINT `FK_vms_images` FOREIGN KEY (`image_id`) REFERENCES `images` (`uuid`),
 659   CONSTRAINT `FK_vms_vnfs` FOREIGN KEY (`vnf_id`) REFERENCES `vnfs` (`uuid`) ON DELETE CASCADE
 660 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='VM definitions. It contains the set of VMs used by the VNF definitions.';
 661 /*!40101 SET character_set_client = @saved_cs_client */;
 662
 663 --
 664 -- Table structure for table `vnfs`
 665 --
 666
 667 DROP TABLE IF EXISTS `vnfs`;
 668 /*!40101 SET @saved_cs_client     = @@character_set_client */;
 669 /*!40101 SET character_set_client = utf8 */;
 670 CREATE TABLE `vnfs` (
 671   `uuid` varchar(36) NOT NULL,
 672   `name` varchar(255) NOT NULL,
 673   `tenant_id` varchar(36) DEFAULT NULL,
 674   `physical` enum('true','false') NOT NULL DEFAULT 'false',
 675   `public` enum('true','false') NOT NULL DEFAULT 'false',
 676   `description` varchar(255) DEFAULT NULL,
 677   `created_at` double NOT NULL,
 678   `modified_at` double DEFAULT NULL,
 679   `class` varchar(36) DEFAULT 'MISC',
 680   `descriptor` text COMMENT 'Original text descriptor used for create the VNF',
 681   PRIMARY KEY (`uuid`),
 682   KEY `FK_vnfs_nfvo_tenants` (`tenant_id`),
 683   CONSTRAINT `FK_vnfs_nfvo_tenants` FOREIGN KEY (`tenant_id`) REFERENCES `nfvo_tenants` (`uuid`) ON DELETE SET NULL ON UPDATE CASCADE
 684 ) 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';
 685 /*!40101 SET character_set_client = @saved_cs_client */;
 686
 687 --
 688 -- Dumping routines for database '{{mano_db}}'
 689 --
 690 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 691
 692 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
 693 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
 694 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
 695 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 696 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
 697 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 698 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 699
 700 -- Dump completed on 2017-05-03 11:39:20
 701
 702
 703
 704
 705
 706 -- MySQL dump 10.13  Distrib 5.7.18, for Linux (x86_64)
 707 --
 708 -- Host: localhost    Database: {{mano_db}}
 709 -- ------------------------------------------------------
 710 -- Server version       5.7.18-0ubuntu0.16.04.1
 711
 712 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
 713 /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
 714 /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
 715 /*!40101 SET NAMES utf8 */;
 716 /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
 717 /*!40103 SET TIME_ZONE='+00:00' */;
 718 /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
 719 /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
 720 /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
 721 /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
 722
 723 --
 724 -- Dumping data for table `schema_version`
 725 --
 726
 727 LOCK TABLES `schema_version` WRITE;
 728 /*!40000 ALTER TABLE `schema_version` DISABLE KEYS */;
 729 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'),(11,'0.11','0.4.43','remove unique name at scenarios,instance_scenarios','2016-07-18'),(12,'0.12','0.4.46','create ip_profiles table, with foreign keys to all nets tables, and add ip_address column to interfaces and sce_interfaces','2016-08-29'),(13,'0.13','0.4.47','insert cloud-config at scenarios,instance_scenarios','2016-08-30'),(14,'0.14','0.4.57','remove unique index vim_net_id, instance_scenario_id','2016-09-26'),(15,'0.15','0.4.59','add columns universal_name and checksum at table images, add unique index universal_name_checksum, and change location to allow NULL; change column image_path in table vms to allow NULL','2016-09-27'),(16,'0.16','0.5.2','enlarge vim_tenant_name and id. New config at datacenter_tenants','2016-10-11'),(17,'0.17','0.5.3','Extra description json format of additional devices in datacenter_flavors','2016-12-20'),(18,'0.18','0.5.4','Add columns \'floating_ip\' and \'port_security\' at tables \'interfaces\' and \'instance_interfaces\'','2017-01-09'),(19,'0.19','0.5.5','Extra Boot-data content at VNFC (vms)','2017-01-11'),(20,'0.20','0.5.9','Added columns to store dataplane connectivity info','2017-03-13');
 730 /*!40000 ALTER TABLE `schema_version` ENABLE KEYS */;
 731 UNLOCK TABLES;
 732 /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
 733
 734 /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
 735 /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
 736 /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
 737 /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
 738 /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
 739 /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
 740 /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
 741
 742 -- Dump completed on 2017-05-03 11:39:20