X-Git-Url: https://osm.etsi.org/gitweb/?a=blobdiff_plain;f=database_utils%2Fmano_db_structure.sql;h=9e2d911e1c5b1d7fea40ee868d36546c1214f212;hb=88b676c8c572277e2487c309be6daace6bed0ee9;hp=747ffe27a6bec51cd4490616cc433db6e2d2a32d;hpb=fc7df372047d3e16f8e3779544d175175e33bef3;p=osm%2FRO.git

diff --git a/database_utils/mano_db_structure.sql b/database_utils/mano_db_structure.sql
index 747ffe27..9e2d911e 100644
--- a/database_utils/mano_db_structure.sql
+++ b/database_utils/mano_db_structure.sql
@@ -780,16 +780,19 @@ DROP TABLE IF EXISTS `sce_rsp_hops`;
 CREATE TABLE `sce_rsp_hops` (
   `uuid` varchar(36) NOT NULL,
   `if_order` int(11) NOT NULL DEFAULT '0',
-  `interface_id` varchar(36) NOT NULL,
+  `ingress_interface_id` varchar(36) NOT NULL,
+  `egress_interface_id` varchar(36) NOT NULL,
   `sce_vnf_id` varchar(36) NOT NULL,
   `sce_rsp_id` varchar(36) NOT NULL,
   `created_at` double NOT NULL,
   `modified_at` double DEFAULT NULL,
   PRIMARY KEY (`uuid`),
-  KEY `FK_interfaces_rsp_hop` (`interface_id`),
+  KEY `FK_interfaces_rsp_hop` (`ingress_interface_id`),
   KEY `FK_sce_vnfs_rsp_hop` (`sce_vnf_id`),
   KEY `FK_sce_rsps_rsp_hop` (`sce_rsp_id`),
-  CONSTRAINT `FK_interfaces_rsp_hop` FOREIGN KEY (`interface_id`) REFERENCES `interfaces` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE,
+  KEY `FK_interfaces_rsp_hop_egress` (`egress_interface_id`),
+  CONSTRAINT `FK_interfaces_rsp_hop_egress` FOREIGN KEY (`egress_interface_id`) REFERENCES `interfaces` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE,
+  CONSTRAINT `FK_interfaces_rsp_hop_ingress` FOREIGN KEY (`ingress_interface_id`) REFERENCES `interfaces` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE,
   CONSTRAINT `FK_sce_rsps_rsp_hop` FOREIGN KEY (`sce_rsp_id`) REFERENCES `sce_rsps` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE,
   CONSTRAINT `FK_sce_vnfs_rsp_hop` FOREIGN KEY (`sce_vnf_id`) REFERENCES `sce_vnfs` (`uuid`) ON DELETE CASCADE ON UPDATE CASCADE
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
@@ -997,7 +1000,7 @@ CREATE TABLE `vms` (
   `vnf_id` varchar(36) NOT NULL,
   `count` smallint(6) NOT NULL DEFAULT '1',
   `flavor_id` varchar(36) NOT NULL COMMENT 'Link to flavor table',
-  `image_id` varchar(36) NOT NULL COMMENT 'Link to image table',
+  `image_id` varchar(36) DEFAULT NULL COMMENT 'Link to image table',
   `image_list` text COMMENT 'Alternative images',
   `image_path` varchar(100) DEFAULT NULL COMMENT 'Path where the image of the VM is located',
   `boot_data` text,
@@ -1059,7 +1062,7 @@ CREATE TABLE `wim_accounts` (
   `created` enum('true','false') NOT NULL DEFAULT 'false',
   `user` varchar(64) DEFAULT NULL,
   `password` varchar(64) DEFAULT NULL,
-  `config` varchar(4000) DEFAULT NULL,
+  `config` text,
   `created_at` double NOT NULL,
   `modified_at` double DEFAULT NULL,
   PRIMARY KEY (`uuid`),
@@ -1134,7 +1137,7 @@ CREATE TABLE `wims` (
   `description` varchar(255) DEFAULT NULL,
   `type` varchar(36) NOT NULL DEFAULT 'odl',
   `wim_url` varchar(150) NOT NULL,
-  `config` varchar(4000) DEFAULT NULL,
+  `config` text,
   `created_at` double NOT NULL,
   `modified_at` double DEFAULT NULL,
   PRIMARY KEY (`uuid`),