X-Git-Url: https://osm.etsi.org/gitweb/?a=blobdiff_plain;f=database_utils%2Fmano_db_structure.sql;h=c70fbc1cca1f0fbb76de1bd17de07eb234ddebf0;hb=2c31ee74f12d0f584c9191414ddab5ede6ea540d;hp=cea38f4d195b6e56a8877bb97ee5624d9e0ac21d;hpb=7edb675ac76f3e0473042cf5cf7de3c0f19eda7d;p=osm%2FRO.git diff --git a/database_utils/mano_db_structure.sql b/database_utils/mano_db_structure.sql index cea38f4d..c70fbc1c 100644 --- a/database_utils/mano_db_structure.sql +++ b/database_utils/mano_db_structure.sql @@ -18,11 +18,12 @@ * For those usages not covered by the Apache License, Version 2.0 please * contact with: nfvlabs@tid.es **/ --- MySQL dump 10.13 Distrib 5.5.35, for debian-linux-gnu (x86_64) + +-- MySQL dump 10.13 Distrib 5.5.43, for debian-linux-gnu (x86_64) -- -- Host: localhost Database: mano_db -- ------------------------------------------------------ --- Server version 5.5.35-1ubuntu1 +-- Server version 5.5.43-0ubuntu0.14.04.1 /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; @@ -35,16 +36,6 @@ /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; --- --- Current Database: `mano_db` --- - -/*!40000 DROP DATABASE IF EXISTS `mano_db`*/; - -CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mano_db` /*!40100 DEFAULT CHARACTER SET latin1 */; - -USE `mano_db`; - -- -- Table structure for table `datacenter_nets` -- @@ -54,15 +45,15 @@ DROP TABLE IF EXISTS `datacenter_nets`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `datacenter_nets` ( `uuid` varchar(36) NOT NULL, - `name` varchar(36) NOT NULL COMMENT 'To match with sce_nets', + `name` varchar(255) NOT NULL, `vim_net_id` varchar(36) NOT NULL, `datacenter_id` varchar(36) NOT NULL, `type` enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network', `multipoint` enum('true','false') NOT NULL DEFAULT 'true', `shared` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'If can be shared with serveral scenarios', - `description` varchar(100) DEFAULT NULL, - `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, - `modified_at` timestamp NULL DEFAULT NULL, + `description` varchar(255) DEFAULT NULL, + `created_at` double NOT NULL, + `modified_at` double DEFAULT NULL, PRIMARY KEY (`uuid`), UNIQUE KEY `name_datacenter_id` (`name`,`datacenter_id`), KEY `FK_datacenter_nets_datacenters` (`datacenter_id`), @@ -70,6 +61,29 @@ CREATE TABLE `datacenter_nets` ( ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Contain the external nets of a datacenter'; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `datacenter_tenants` +-- + +DROP TABLE IF EXISTS `datacenter_tenants`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `datacenter_tenants` ( + `uuid` varchar(36) NOT NULL, + `datacenter_id` varchar(36) NOT NULL COMMENT 'Datacenter of this tenant', + `vim_tenant_name` varchar(64) DEFAULT NULL, + `vim_tenant_id` varchar(36) DEFAULT NULL COMMENT 'Tenant ID at VIM', + `created` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if this tenant has been created by openmano, or it existed on VIM', + `user` varchar(64) DEFAULT NULL, + `passwd` varchar(64) DEFAULT NULL, + `created_at` double NOT NULL, + `modified_at` double DEFAULT NULL, + PRIMARY KEY (`uuid`), + KEY `FK_vim_tenants_datacenters` (`datacenter_id`), + CONSTRAINT `FK_vim_tenants_datacenters` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Scenarios defined by the user'; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `datacenters` -- @@ -79,18 +93,98 @@ DROP TABLE IF EXISTS `datacenters`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `datacenters` ( `uuid` varchar(36) NOT NULL, - `name` varchar(36) NOT NULL, - `description` varchar(100) DEFAULT NULL, - `type` enum('openvim','openstack') NOT NULL DEFAULT 'openvim', + `name` varchar(255) NOT NULL, + `description` varchar(255) DEFAULT NULL, + `type` varchar(36) NOT NULL DEFAULT 'openvim', `vim_url` varchar(150) NOT NULL COMMENT 'URL of the VIM for the REST API', `vim_url_admin` varchar(150) DEFAULT NULL, - `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `modified_at` timestamp NULL DEFAULT NULL, + `config` varchar(4000) DEFAULT NULL COMMENT 'extra config information in json', + `created_at` double NOT NULL, + `modified_at` double DEFAULT NULL, PRIMARY KEY (`uuid`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Datacenters managed by the NFVO.'; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `datacenters_flavors` +-- + +DROP TABLE IF EXISTS `datacenters_flavors`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `datacenters_flavors` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `flavor_id` varchar(36) NOT NULL, + `datacenter_id` varchar(36) NOT NULL, + `vim_id` varchar(36) NOT NULL, + `created` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if it has been created by openmano, or already existed', + PRIMARY KEY (`id`), + KEY `FK__flavors` (`flavor_id`), + KEY `FK__datacenters_f` (`datacenter_id`), + CONSTRAINT `FK__datacenters_f` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT `FK__flavors` FOREIGN KEY (`flavor_id`) REFERENCES `flavors` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE +) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `datacenters_images` +-- + +DROP TABLE IF EXISTS `datacenters_images`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `datacenters_images` ( + `id` int(11) NOT NULL AUTO_INCREMENT, + `image_id` varchar(36) NOT NULL, + `datacenter_id` varchar(36) NOT NULL, + `vim_id` varchar(36) NOT NULL, + `created` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if it has been created by openmano, or already existed', + PRIMARY KEY (`id`), + KEY `FK__images` (`image_id`), + KEY `FK__datacenters_i` (`datacenter_id`), + CONSTRAINT `FK__datacenters_i` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT `FK__images` FOREIGN KEY (`image_id`) REFERENCES `images` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE +) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `flavors` +-- + +DROP TABLE IF EXISTS `flavors`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `flavors` ( + `uuid` varchar(36) NOT NULL, + `name` varchar(255) NOT NULL, + `description` varchar(255) DEFAULT NULL, + `disk` smallint(5) unsigned DEFAULT NULL, + `ram` smallint(5) unsigned DEFAULT NULL, + `vcpus` smallint(5) unsigned DEFAULT NULL, + `extended` varchar(2000) DEFAULT NULL COMMENT 'Extra description json format of needed resources and pining, orginized in sets per numa', + PRIMARY KEY (`uuid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Table structure for table `images` +-- + +DROP TABLE IF EXISTS `images`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `images` ( + `uuid` varchar(36) NOT NULL, + `name` varchar(255) NOT NULL, + `location` varchar(200) NOT NULL, + `description` varchar(255) DEFAULT NULL, + `metadata` varchar(2000) DEFAULT NULL, + PRIMARY KEY (`uuid`), + UNIQUE KEY `location` (`location`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `instance_interfaces` -- @@ -103,7 +197,10 @@ CREATE TABLE `instance_interfaces` ( `instance_vm_id` varchar(36) NOT NULL, `instance_net_id` varchar(36) NOT NULL, `interface_id` varchar(36) NOT NULL, - `vim_interface_id` varchar(36) NOT NULL COMMENT 'vim identity for that interface', + `vim_interface_id` varchar(36) DEFAULT NULL COMMENT 'vim identity for that interface', + `mac_address` varchar(32) DEFAULT NULL, + `ip_address` varchar(64) DEFAULT NULL, + `vim_info` text, `type` enum('internal','external') NOT NULL COMMENT 'Indicates if this interface is external to a vnf, or internal', PRIMARY KEY (`uuid`), KEY `FK_instance_vms` (`instance_vm_id`), @@ -126,15 +223,29 @@ CREATE TABLE `instance_nets` ( `uuid` varchar(36) NOT NULL, `vim_net_id` varchar(36) NOT NULL COMMENT 'Network ID in the VIM DB', `instance_scenario_id` varchar(36) NOT NULL, - `status` enum('ACTIVE','DOWN','BUILD','ERROR') NOT NULL DEFAULT 'BUILD', + `sce_net_id` varchar(36) DEFAULT NULL, + `net_id` varchar(36) DEFAULT NULL, + `datacenter_id` varchar(36) DEFAULT NULL, + `datacenter_tenant_id` varchar(36) NOT NULL, + `status` enum('ACTIVE','DOWN','BUILD','ERROR','VIM_ERROR','INACTIVE','DELETED') NOT NULL DEFAULT 'BUILD', + `error_msg` varchar(1024) DEFAULT NULL, + `vim_info` text, `multipoint` enum('true','false') NOT NULL DEFAULT 'true', `external` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'If external, means that it already exists at VIM', - `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `modified_at` timestamp NULL DEFAULT NULL, + `created_at` double NOT NULL, + `modified_at` double DEFAULT NULL, PRIMARY KEY (`uuid`), UNIQUE KEY `vim_net_id_instance_scenario_id` (`vim_net_id`,`instance_scenario_id`), KEY `FK_instance_nets_instance_scenarios` (`instance_scenario_id`), - CONSTRAINT `FK_instance_nets_instance_scenarios` FOREIGN KEY (`instance_scenario_id`) REFERENCES `instance_scenarios` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE + KEY `FK_instance_nets_sce_nets` (`sce_net_id`), + KEY `FK_instance_nets_nets` (`net_id`), + KEY `FK_instance_nets_datacenters` (`datacenter_id`), + KEY `FK_instance_nets_datacenter_tenants` (`datacenter_tenant_id`), + CONSTRAINT `FK_instance_nets_datacenter_tenants` FOREIGN KEY (`datacenter_tenant_id`) REFERENCES `datacenter_tenants` (`uuid`), + CONSTRAINT `FK_instance_nets_datacenters` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`), + CONSTRAINT `FK_instance_nets_instance_scenarios` FOREIGN KEY (`instance_scenario_id`) REFERENCES `instance_scenarios` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT `FK_instance_nets_nets` FOREIGN KEY (`net_id`) REFERENCES `nets` (`uuid`) ON DELETE SET NULL ON UPDATE CASCADE, + CONSTRAINT `FK_instance_nets_sce_nets` FOREIGN KEY (`sce_net_id`) REFERENCES `sce_nets` (`uuid`) ON DELETE SET NULL ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Instances of networks'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -147,24 +258,24 @@ DROP TABLE IF EXISTS `instance_scenarios`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `instance_scenarios` ( `uuid` varchar(36) NOT NULL, - `name` varchar(36) NOT NULL, + `name` varchar(255) NOT NULL, + `tenant_id` varchar(36) DEFAULT NULL, `scenario_id` varchar(36) NOT NULL, - `nfvo_tenant_id` varchar(36) NOT NULL, - `vim_tenant_id` varchar(36) NOT NULL, `datacenter_id` varchar(36) NOT NULL, - `description` varchar(100) DEFAULT NULL, - `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `modified_at` timestamp NULL DEFAULT NULL, + `datacenter_tenant_id` varchar(36) NOT NULL, + `description` varchar(255) DEFAULT NULL, + `created_at` double NOT NULL, + `modified_at` double DEFAULT NULL, PRIMARY KEY (`uuid`), UNIQUE KEY `name` (`name`), - KEY `FK_scenarios_nfvo_tenants` (`nfvo_tenant_id`), - KEY `FK_instance_scenarios_vim_tenants` (`vim_tenant_id`), + KEY `FK_scenarios_nfvo_tenants` (`tenant_id`), + KEY `FK_instance_scenarios_vim_tenants` (`datacenter_tenant_id`), KEY `FK_instance_scenarios_datacenters` (`datacenter_id`), KEY `FK_instance_scenarios_scenarios` (`scenario_id`), + CONSTRAINT `FK_instance_scenarios_datacenter_tenants` FOREIGN KEY (`datacenter_tenant_id`) REFERENCES `datacenter_tenants` (`uuid`), CONSTRAINT `FK_instance_scenarios_datacenters` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`), - CONSTRAINT `FK_instance_scenarios_nfvo_tenants` FOREIGN KEY (`nfvo_tenant_id`) REFERENCES `nfvo_tenants` (`uuid`), - CONSTRAINT `FK_instance_scenarios_scenarios` FOREIGN KEY (`scenario_id`) REFERENCES `scenarios` (`uuid`), - CONSTRAINT `FK_instance_scenarios_vim_tenants` FOREIGN KEY (`vim_tenant_id`) REFERENCES `vim_tenants` (`uuid`) + CONSTRAINT `FK_instance_scenarios_nfvo_tenants` FOREIGN KEY (`tenant_id`) REFERENCES `nfvo_tenants` (`uuid`), + CONSTRAINT `FK_instance_scenarios_scenarios` FOREIGN KEY (`scenario_id`) REFERENCES `scenarios` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Instances of scenarios defined by the user'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -180,9 +291,11 @@ CREATE TABLE `instance_vms` ( `instance_vnf_id` varchar(36) NOT NULL, `vm_id` varchar(36) NOT NULL, `vim_vm_id` varchar(36) NOT NULL COMMENT 'VM ID in the VIM DB', - `status` enum('ACTIVE','PAUSED','INACTIVE','CREATING','ERROR','DELETING') NOT NULL DEFAULT 'CREATING', - `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `modified_at` timestamp NULL DEFAULT NULL, + `status` enum('ACTIVE:NoMgmtIP','ACTIVE','INACTIVE','BUILD','ERROR','VIM_ERROR','PAUSED','SUSPENDED','DELETED') NOT NULL DEFAULT 'BUILD', + `error_msg` varchar(1024) DEFAULT NULL, + `vim_info` text, + `created_at` double NOT NULL, + `modified_at` double DEFAULT NULL, PRIMARY KEY (`uuid`), UNIQUE KEY `vim_vm_id` (`vim_vm_id`), KEY `FK_instance_vms_vms` (`vm_id`), @@ -203,12 +316,21 @@ CREATE TABLE `instance_vnfs` ( `uuid` varchar(36) NOT NULL, `instance_scenario_id` varchar(36) NOT NULL, `vnf_id` varchar(36) NOT NULL, - `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `modified_at` timestamp NULL DEFAULT NULL, + `sce_vnf_id` varchar(36) DEFAULT NULL, + `datacenter_id` varchar(36) DEFAULT NULL, + `datacenter_tenant_id` varchar(36) DEFAULT NULL, + `created_at` double NOT NULL, + `modified_at` double DEFAULT NULL, PRIMARY KEY (`uuid`), KEY `FK_instance_vnfs_vnfs` (`vnf_id`), KEY `FK_instance_vnfs_instance_scenarios` (`instance_scenario_id`), + KEY `FK_instance_vnfs_sce_vnfs` (`sce_vnf_id`), + KEY `FK_instance_vnfs_datacenters` (`datacenter_id`), + KEY `FK_instance_vnfs_datacenter_tenants` (`datacenter_tenant_id`), + CONSTRAINT `FK_instance_vnfs_datacenter_tenants` FOREIGN KEY (`datacenter_tenant_id`) REFERENCES `datacenter_tenants` (`uuid`), + CONSTRAINT `FK_instance_vnfs_datacenters` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`), CONSTRAINT `FK_instance_vnfs_instance_scenarios` FOREIGN KEY (`instance_scenario_id`) REFERENCES `instance_scenarios` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT `FK_instance_vnfs_sce_vnfs` FOREIGN KEY (`sce_vnf_id`) REFERENCES `sce_vnfs` (`uuid`) ON DELETE SET NULL ON UPDATE CASCADE, CONSTRAINT `FK_instance_vnfs_vnfs` FOREIGN KEY (`vnf_id`) REFERENCES `vnfs` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Instances of VNFs as part of a scenario'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -222,16 +344,17 @@ DROP TABLE IF EXISTS `interfaces`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `interfaces` ( `uuid` varchar(36) NOT NULL, - `internal_name` varchar(25) NOT NULL, - `external_name` varchar(25) DEFAULT NULL COMMENT 'NULL if the interface is not an external interface', + `internal_name` varchar(255) NOT NULL, + `external_name` varchar(255) DEFAULT NULL, `vm_id` varchar(36) NOT NULL, `net_id` varchar(36) DEFAULT NULL, `type` enum('mgmt','bridge','data') NOT NULL DEFAULT 'data' COMMENT 'Type of network', `vpci` char(12) DEFAULT NULL, `bw` mediumint(8) unsigned DEFAULT NULL COMMENT 'BW expressed in Mbits/s. Maybe this field is not necessary.', - `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `modified_at` timestamp NULL DEFAULT NULL, + `created_at` double NOT NULL, + `modified_at` double DEFAULT NULL, `model` varchar(12) DEFAULT NULL, + `mac` char(18) DEFAULT NULL, PRIMARY KEY (`uuid`), UNIQUE KEY `internal_name_vm_id` (`internal_name`,`vm_id`), KEY `FK_interfaces_vms` (`vm_id`), @@ -252,12 +375,12 @@ CREATE TABLE `logs` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `nfvo_tenant_id` varchar(36) DEFAULT NULL, - `related` enum('nfvo_tenants','datacenters','vim_tenants','tenants_datacenters','vnfs','vms','interfaces','nets','scenarios','sce_vnfs','sce_interfaces','sce_nets','instance_scenarios','instance_vnfs','instance_vms','instance_nets','instance_interfaces') NOT NULL COMMENT 'Relevant element for the log', + `related` varchar(36) NOT NULL COMMENT 'Relevant element for the log', `uuid` varchar(36) DEFAULT NULL COMMENT 'Uuid of vnf, scenario, etc. that log relates to', `level` enum('panic','error','info','debug','verbose') NOT NULL, `description` varchar(200) NOT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB AUTO_INCREMENT=3286 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; +) ENGINE=InnoDB AUTO_INCREMENT=3423 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -270,12 +393,12 @@ DROP TABLE IF EXISTS `nets`; CREATE TABLE `nets` ( `uuid` varchar(36) NOT NULL, `vnf_id` varchar(36) NOT NULL, - `name` varchar(36) NOT NULL, + `name` varchar(255) NOT NULL, `type` enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network', `multipoint` enum('true','false') NOT NULL DEFAULT 'false', - `description` varchar(100) DEFAULT NULL, - `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `modified_at` timestamp NULL DEFAULT NULL, + `description` varchar(255) DEFAULT NULL, + `created_at` double NOT NULL, + `modified_at` double DEFAULT NULL, PRIMARY KEY (`uuid`), UNIQUE KEY `vnf_id_name` (`vnf_id`,`name`), CONSTRAINT `FK_nets_vnfs` FOREIGN KEY (`vnf_id`) REFERENCES `vnfs` (`uuid`) ON DELETE CASCADE @@ -291,10 +414,10 @@ DROP TABLE IF EXISTS `nfvo_tenants`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `nfvo_tenants` ( `uuid` varchar(36) NOT NULL, - `name` varchar(36) NOT NULL, - `description` varchar(100) DEFAULT NULL, - `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `modified_at` timestamp NULL DEFAULT NULL, + `name` varchar(255) NOT NULL, + `description` varchar(255) DEFAULT NULL, + `created_at` double NOT NULL, + `modified_at` double DEFAULT NULL, PRIMARY KEY (`uuid`), UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Scenarios defined by the user'; @@ -312,8 +435,8 @@ CREATE TABLE `sce_interfaces` ( `sce_vnf_id` varchar(36) NOT NULL, `sce_net_id` varchar(36) DEFAULT NULL, `interface_id` varchar(36) DEFAULT NULL, - `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `modified_at` timestamp NULL DEFAULT NULL, + `created_at` double NOT NULL, + `modified_at` double DEFAULT NULL, PRIMARY KEY (`uuid`), KEY `FK_sce_interfaces_sce_vnfs` (`sce_vnf_id`), KEY `FK_sce_interfaces_sce_nets` (`sce_net_id`), @@ -333,15 +456,15 @@ DROP TABLE IF EXISTS `sce_nets`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sce_nets` ( `uuid` varchar(36) NOT NULL, - `name` varchar(36) DEFAULT NULL, + `name` varchar(255) NOT NULL, `scenario_id` varchar(36) DEFAULT NULL COMMENT 'NULL if net is matched to several scenarios', `type` enum('bridge','data','ptp') NOT NULL DEFAULT 'data' COMMENT 'Type of network', `multipoint` enum('true','false') NOT NULL DEFAULT 'true', `external` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'If external, net is already present at VIM', - `description` varchar(100) DEFAULT NULL, - `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `modified_at` timestamp NULL DEFAULT NULL, - `graph` varchar(200) DEFAULT NULL, + `description` varchar(255) DEFAULT NULL, + `created_at` double NOT NULL, + `modified_at` double DEFAULT NULL, + `graph` varchar(2000) DEFAULT NULL, PRIMARY KEY (`uuid`), KEY `FK_sce_nets_scenarios` (`scenario_id`), CONSTRAINT `FK_sce_nets_scenarios` FOREIGN KEY (`scenario_id`) REFERENCES `scenarios` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE @@ -357,13 +480,13 @@ DROP TABLE IF EXISTS `sce_vnfs`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `sce_vnfs` ( `uuid` varchar(36) NOT NULL, - `name` varchar(36) NOT NULL, + `name` varchar(255) NOT NULL, `scenario_id` varchar(36) NOT NULL, `vnf_id` varchar(36) NOT NULL, - `description` varchar(100) DEFAULT NULL, - `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `modified_at` timestamp NULL DEFAULT NULL, - `graph` varchar(200) DEFAULT NULL, + `description` varchar(255) DEFAULT NULL, + `created_at` double NOT NULL, + `modified_at` double DEFAULT NULL, + `graph` varchar(2000) DEFAULT NULL, PRIMARY KEY (`uuid`), UNIQUE KEY `name_scenario_id` (`name`,`scenario_id`), KEY `FK_sce_vnfs_scenarios` (`scenario_id`), @@ -382,19 +505,37 @@ DROP TABLE IF EXISTS `scenarios`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `scenarios` ( `uuid` varchar(36) NOT NULL, - `name` varchar(36) NOT NULL, - `nfvo_tenant_id` varchar(36) DEFAULT NULL, - `description` varchar(100) DEFAULT NULL, + `name` varchar(255) NOT NULL, + `tenant_id` varchar(36) DEFAULT NULL, + `description` varchar(255) DEFAULT NULL, `public` enum('true','false') NOT NULL DEFAULT 'false', - `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `modified_at` timestamp NULL DEFAULT NULL, + `created_at` double NOT NULL, + `modified_at` double DEFAULT NULL, + `descriptor` text COMMENT 'Original text descriptor used for create the scenario', PRIMARY KEY (`uuid`), UNIQUE KEY `name` (`name`), - KEY `FK_scenarios_nfvo_tenants` (`nfvo_tenant_id`), - CONSTRAINT `FK_scenarios_nfvo_tenants` FOREIGN KEY (`nfvo_tenant_id`) REFERENCES `nfvo_tenants` (`uuid`) + KEY `FK_scenarios_nfvo_tenants` (`tenant_id`), + CONSTRAINT `FK_scenarios_nfvo_tenants` FOREIGN KEY (`tenant_id`) REFERENCES `nfvo_tenants` (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Scenarios defined by the user'; /*!40101 SET character_set_client = @saved_cs_client */; +-- +-- Table structure for table `schema_version` +-- + +DROP TABLE IF EXISTS `schema_version`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `schema_version` ( + `version_int` int(11) NOT NULL COMMENT 'version as a number. Must not contain gaps', + `version` varchar(20) NOT NULL COMMENT 'version as a text', + `openmano_ver` varchar(20) NOT NULL COMMENT 'openmano version', + `comments` varchar(2000) DEFAULT NULL COMMENT 'changes to database', + `date` date DEFAULT NULL, + PRIMARY KEY (`version_int`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='database schema control version'; +/*!40101 SET character_set_client = @saved_cs_client */; + -- -- Table structure for table `tenants_datacenters` -- @@ -406,18 +547,18 @@ CREATE TABLE `tenants_datacenters` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nfvo_tenant_id` varchar(36) NOT NULL, `datacenter_id` varchar(36) NOT NULL, - `vim_tenant_id` varchar(36) NOT NULL, - `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `modified_at` timestamp NULL DEFAULT NULL, + `datacenter_tenant_id` varchar(36) NOT NULL, + `created_at` double NOT NULL, + `modified_at` double DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `datacenter_nfvo_tenant` (`datacenter_id`,`nfvo_tenant_id`), KEY `FK_nfvo_tenants_datacenters` (`datacenter_id`), - KEY `FK_nfvo_tenants_vim_tenants` (`vim_tenant_id`), + KEY `FK_nfvo_tenants_vim_tenants` (`datacenter_tenant_id`), KEY `FK_tenants_datacenters_nfvo_tenants` (`nfvo_tenant_id`), + CONSTRAINT `FK_tenants_datacenters_datacenter_tenants` FOREIGN KEY (`datacenter_tenant_id`) REFERENCES `datacenter_tenants` (`uuid`), CONSTRAINT `FK_tenants_datacenters_datacenters` FOREIGN KEY (`datacenter_id`) REFERENCES `datacenters` (`uuid`), - CONSTRAINT `FK_tenants_datacenters_nfvo_tenants` FOREIGN KEY (`nfvo_tenant_id`) REFERENCES `nfvo_tenants` (`uuid`), - CONSTRAINT `FK_tenants_datacenters_vim_tenants` FOREIGN KEY (`vim_tenant_id`) REFERENCES `vim_tenants` (`uuid`) -) ENGINE=InnoDB AUTO_INCREMENT=85 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Scenarios defined by the user'; + CONSTRAINT `FK_tenants_datacenters_nfvo_tenants` FOREIGN KEY (`nfvo_tenant_id`) REFERENCES `nfvo_tenants` (`uuid`) +) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Scenarios defined by the user'; /*!40101 SET character_set_client = @saved_cs_client */; -- @@ -430,32 +571,12 @@ DROP TABLE IF EXISTS `uuids`; CREATE TABLE `uuids` ( `uuid` varchar(36) NOT NULL, `root_uuid` varchar(36) DEFAULT NULL COMMENT 'Some related UUIDs can be grouped by this field, so that they can be deleted at once', - `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `used_at` enum('nfvo_tenants','datacenters','vim_tenants','vnfs','vms','interfaces','nets','scenarios','sce_vnfs','sce_interfaces','sce_nets','instance_scenarios','instance_vnfs','instance_vms','instance_nets','instance_interfaces') DEFAULT NULL COMMENT 'Table that uses this UUID', + `created_at` double NOT NULL, + `used_at` varchar(36) DEFAULT NULL COMMENT 'Table that uses this UUID', PRIMARY KEY (`uuid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='Table with all unique IDs used to avoid UUID repetitions among different elements'; /*!40101 SET character_set_client = @saved_cs_client */; --- --- Table structure for table `vim_tenants` --- - -DROP TABLE IF EXISTS `vim_tenants`; -/*!40101 SET @saved_cs_client = @@character_set_client */; -/*!40101 SET character_set_client = utf8 */; -CREATE TABLE `vim_tenants` ( - `uuid` varchar(36) NOT NULL, - `name` varchar(36) NOT NULL, - `vim_tenant_id` varchar(36) NOT NULL COMMENT 'Tenant ID in the VIM DB', - `created` enum('true','false') NOT NULL DEFAULT 'false' COMMENT 'Indicates if this tenant has been created by openmano, or it existed on VIM', - `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `modified_at` timestamp NULL DEFAULT NULL, - PRIMARY KEY (`uuid`), - UNIQUE KEY `name` (`name`), - UNIQUE KEY `vim_tenant_id` (`vim_tenant_id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='Scenarios defined by the user'; -/*!40101 SET character_set_client = @saved_cs_client */; - -- -- Table structure for table `vms` -- @@ -465,17 +586,21 @@ DROP TABLE IF EXISTS `vms`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vms` ( `uuid` varchar(36) NOT NULL, - `name` varchar(36) NOT NULL, + `name` varchar(255) NOT NULL, `vnf_id` varchar(36) NOT NULL, - `vim_flavor_id` varchar(36) NOT NULL COMMENT 'Flavor ID in the VIM DB', - `vim_image_id` varchar(36) NOT NULL COMMENT 'Image ID in the VIM DB', + `flavor_id` varchar(36) NOT NULL COMMENT 'Link to flavor table', + `image_id` varchar(36) NOT NULL COMMENT 'Link to image table', `image_path` varchar(100) NOT NULL COMMENT 'Path where the image of the VM is located', - `description` varchar(100) DEFAULT NULL, - `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `modified_at` timestamp NULL DEFAULT NULL, + `description` varchar(255) DEFAULT NULL, + `created_at` double NOT NULL, + `modified_at` double DEFAULT NULL, PRIMARY KEY (`uuid`), UNIQUE KEY `name_vnf_id` (`name`,`vnf_id`), KEY `FK_vms_vnfs` (`vnf_id`), + KEY `FK_vms_images` (`image_id`), + KEY `FK_vms_flavors` (`flavor_id`), + CONSTRAINT `FK_vms_flavors` FOREIGN KEY (`flavor_id`) REFERENCES `flavors` (`uuid`), + CONSTRAINT `FK_vms_images` FOREIGN KEY (`image_id`) REFERENCES `images` (`uuid`), CONSTRAINT `FK_vms_vnfs` FOREIGN KEY (`vnf_id`) REFERENCES `vnfs` (`uuid`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='VM definitions. It contains the set of VMs used by the VNF definitions.'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -489,17 +614,18 @@ DROP TABLE IF EXISTS `vnfs`; /*!40101 SET character_set_client = utf8 */; CREATE TABLE `vnfs` ( `uuid` varchar(36) NOT NULL, - `name` varchar(36) NOT NULL, - `path` varchar(100) DEFAULT NULL COMMENT 'Path where the YAML descriptor of the VNF can be found. NULL if it is a physical network function.', + `name` varchar(255) NOT NULL, + `tenant_id` varchar(36) DEFAULT NULL, `physical` enum('true','false') NOT NULL DEFAULT 'false', - `public` enum('true','false') NOT NULL DEFAULT 'true', - `description` varchar(100) DEFAULT NULL, - `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, - `modified_at` timestamp NULL DEFAULT NULL, + `public` enum('true','false') NOT NULL DEFAULT 'false', + `description` varchar(255) DEFAULT NULL, + `created_at` double NOT NULL, + `modified_at` double DEFAULT NULL, `class` varchar(36) DEFAULT 'MISC', + `descriptor` text COMMENT 'Original text descriptor used for create the VNF', PRIMARY KEY (`uuid`), - UNIQUE KEY `name` (`name`), - UNIQUE KEY `path` (`path`) + KEY `FK_vnfs_nfvo_tenants` (`tenant_id`), + CONSTRAINT `FK_vnfs_nfvo_tenants` FOREIGN KEY (`tenant_id`) REFERENCES `nfvo_tenants` (`uuid`) ON DELETE SET NULL ON UPDATE CASCADE ) 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'; /*!40101 SET character_set_client = @saved_cs_client */; @@ -516,4 +642,46 @@ CREATE TABLE `vnfs` ( /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; --- Dump completed on 2015-03-11 17:34:28 +-- Dump completed on 2016-05-13 12:23:52 + + + + + +-- MySQL dump 10.13 Distrib 5.5.43, for debian-linux-gnu (x86_64) +-- +-- Host: localhost Database: mano_db +-- ------------------------------------------------------ +-- Server version 5.5.43-0ubuntu0.14.04.1 + +/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; +/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */; +/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */; +/*!40101 SET NAMES utf8 */; +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; +/*!40103 SET TIME_ZONE='+00:00' */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +-- +-- Dumping data for table `schema_version` +-- + +LOCK TABLES `schema_version` WRITE; +/*!40000 ALTER TABLE `schema_version` DISABLE KEYS */; +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'); +/*!40000 ALTER TABLE `schema_version` ENABLE KEYS */; +UNLOCK TABLES; +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; + +-- Dump completed on 2016-05-13 12:23:52