From d023b242fad961d3fb4b420f7cbe47c59ac4fe6f Mon Sep 17 00:00:00 2001
From: Ruoyu <ruoyu.ying@intel.com>
Date: Wed, 28 Nov 2018 04:46:56 +0000
Subject: Change primary key for OOF table

Change the primary key to serviceResourceId

Change-Id: I7161135536be44ab71a890065b002cbe08048d5a
Issue-ID: VFC-941
Signed-off-by: Ruoyu <ruoyu.ying@intel.com>
---
 resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql | 3 +--
 1 file changed, 1 insertion(+), 2 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 c244776..798e1c2 100644
--- a/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql
+++ b/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql
@@ -287,12 +287,11 @@ CREATE TABLE NFVO_OOF_DATA (
   `TRANSACTIONID` varchar(255) NOT NULL,
   `REQUESTSTATUS` varchar(50) NOT NULL,
   `RESOURCEMODULENAME` varchar(100) NOT NULL,
-  `SERVICERESOURCEID` varchar(255) NOT NULL,
+  `SERVICERESOURCEID` varchar(255) NOT NULL PRIMARY KEY,
   `VIMID` varchar(255) NULL,
   `CLOUDOWNER` varchar(100) NULL,
   `CLOUDREGIONID` varchar(255) NULL,
   `VDUINFO` longtext NULL,
-  CONSTRAINT ID PRIMARY KEY(REQUESTID,TRANSACTIONID)
 );
 
 DROP TABLE IF EXISTS NFVO_PNFINST;
-- 
cgit 

