aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
-rw-r--r--resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql6
1 files 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)
);