From 09094bb9434096914b1c5f16df6a426983a67d1f Mon Sep 17 00:00:00 2001 From: Ruoyu Ying 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 --- resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql | 6 ++---- 1 file changed, 2 insertions(+), 4 deletions(-) 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