From 09094bb9434096914b1c5f16df6a426983a67d1f Mon Sep 17 00:00:00 2001
From: Ruoyu Ying <ruoyu.ying@intel.com>
Date: Fri, 7 Sep 2018 18:35:27 +0800
Subject: Refine DB table for OOF directives

Refine DB table to store only one record for one vnf

Change-Id: I54deca8d0ede933b688a821362ce696fa34b6cc4
Issue-ID: VFC-1085
Signed-off-by: Ruoyu Ying <ruoyu.ying@intel.com>
---
 resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql | 6 ++----
 1 file changed, 2 insertions(+), 4 deletions(-)

(limited to 'resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql')

diff --git a/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql b/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql
index f6af383..e3c2cb6 100644
--- a/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql
+++ b/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql
@@ -282,7 +282,6 @@ CREATE TABLE NFVO_WF_PLAN (
 
 DROP TABLE IF EXISTS NFVO_OOF_DATA;
 CREATE TABLE NFVO_OOF_DATA (
-  `ID` varchar(255) NOT NULL PRIMARY KEY,
   `REQUESTID` varchar(255) NOT NULL,
   `TRANSACTIONID` varchar(255) NOT NULL,
   `REQUESTSTATUS` varchar(50) NOT NULL,
@@ -291,7 +290,6 @@ CREATE TABLE NFVO_OOF_DATA (
   `VIMID` varchar(255) NULL,
   `CLOUDOWNER` varchar(100) NULL,
   `CLOUDREGIONID` varchar(255) NULL,
-  `VDUNAME` varchar(100) NULL,
-  `FLAVORNAME` varchar(100) NULL,
-  `DIRECTIVE` longtext NULL
+  `VDUINFO` longtext NULL,
+  CONSTRAINT ID PRIMARY KEY(REQUESTID,TRANSACTIONID)
 );
-- 
cgit 1.2.3-korg

