From d5f5d0d06b7838d14b8776d8273a62ca3eb99355 Mon Sep 17 00:00:00 2001
From: subhash kumar singh <subhash.kumar.singh@huawei.com>
Date: Tue, 22 Jan 2019 12:56:29 +0530
Subject: Fix CSAR distribution on CCVPN service

Fix db schema to allow CCVPN service witout heat artifacts.

Change-Id: I4f79881a6a04f01f8984835eea88907a61c640db
Issue-ID: SO-1407
Signed-off-by: subhash kumar singh <subhash.kumar.singh@huawei.com>
---
 mso-catalog-db/src/test/resources/schema.sql | 11 +++++------
 1 file changed, 5 insertions(+), 6 deletions(-)

(limited to 'mso-catalog-db/src/test/resources/schema.sql')

diff --git a/mso-catalog-db/src/test/resources/schema.sql b/mso-catalog-db/src/test/resources/schema.sql
index bd19c77e44..221f0d8df6 100644
--- a/mso-catalog-db/src/test/resources/schema.sql
+++ b/mso-catalog-db/src/test/resources/schema.sql
@@ -165,8 +165,8 @@ create table `network_recipe` (
 
 create table `temp_network_heat_template_lookup` (
   `network_resource_model_name` varchar(200) not null,
-  `heat_template_artifact_uuid` varchar(200) not null,
-  `aic_version_min` varchar(20) not null,
+  `heat_template_artifact_uuid` varchar(200) null,
+  `aic_version_min` varchar(20) null,
   `aic_version_max` varchar(20) default null,
   primary key (`network_resource_model_name`),
   key `fk_temp_network_heat_template_lookup__heat_template1_idx` (`heat_template_artifact_uuid`),
@@ -180,11 +180,11 @@ create table `network_resource` (
   `model_name` varchar(200) not null,
   `model_invariant_uuid` varchar(200) default null,
   `description` varchar(1200) default null,
-  `heat_template_artifact_uuid` varchar(200) not null,
+  `heat_template_artifact_uuid` varchar(200) null,
   `neutron_network_type` varchar(20) default null,
   `model_version` varchar(20) default null,
   `tosca_node_type` varchar(200) default null,
-  `aic_version_min` varchar(20) not null,
+  `aic_version_min` varchar(20) null,
   `aic_version_max` varchar(20) default null,
   `orchestration_mode` varchar(20) default 'heat',
   `resource_category` varchar(20) default null,
@@ -193,8 +193,7 @@ create table `network_resource` (
   primary key (`model_uuid`),
   key `fk_network_resource__temp_network_heat_template_lookup1_idx` (`model_name`),
   key `fk_network_resource__heat_template1_idx` (`heat_template_artifact_uuid`),
-  constraint `fk_network_resource__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete no action on update cascade,
-  constraint `fk_network_resource__temp_network_heat_template_lookup__mod_nm1` foreign key (`model_name`) references `temp_network_heat_template_lookup` (`network_resource_model_name`) on delete no action on update no action
+  constraint `fk_network_resource__heat_template1` foreign key (`heat_template_artifact_uuid`) references `heat_template` (`artifact_uuid`) on delete no action on update cascade
 ) engine=innodb default charset=latin1;
 
 
-- 
cgit 1.2.3-korg

