Merge "Add INSTANTIATE in affectedNs"

[vfc/nfvo/lcm.git] / resources / dbscripts / mysql / vfc-nfvo-lcm-createobj.sql

diff --git a/resources/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql b/resources/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql
index f42915f..c244776 100644 (file)
--- a/resources/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql
+++ b/resources/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql
@@ -1,5 +1,5 @@
 --
--- Copyright  2017 ZTE Corporation.
+-- Copyright 2018 ZTE Corporation.
 --
 -- Licensed under the Apache License, Version 2.0 (the "License");
 -- you may not use this file except in compliance with the License.
@@ -133,7 +133,8 @@ CREATE TABLE NFVO_NSINST (
   `ID` varchar(200) NOT NULL PRIMARY KEY, 
   `NAME` varchar(200) NOT NULL, 
   `NSPACKAGEID` varchar(200) NULL, 
-  `NSDID` varchar(200) NOT NULL, 
+  `NSDID` varchar(200) NOT NULL,
+  `NSDINVARIANTID` varchar(200) NOT NULL,
   `DESCRIPTION` varchar(255) NULL, 
   `SDNCONTROLLERID` varchar(200) NULL, 
   `FLAVOURID` varchar(200) NULL, 
@@ -279,3 +280,41 @@ CREATE TABLE NFVO_WF_PLAN (
   `MESSAGE` varchar(1024) NULL,
   `PLANNAME` varchar(255) NOT NULL
 );
+
+DROP TABLE IF EXISTS NFVO_OOF_DATA;
+CREATE TABLE NFVO_OOF_DATA (
+  `REQUESTID` varchar(255) NOT NULL,
+  `TRANSACTIONID` varchar(255) NOT NULL,
+  `REQUESTSTATUS` varchar(50) NOT NULL,
+  `RESOURCEMODULENAME` varchar(100) NOT NULL,
+  `SERVICERESOURCEID` varchar(255) NOT NULL,
+  `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;
+CREATE TABLE NFVO_PNFINST (
+  `PNFID` varchar(255) NOT NULL PRIMARY KEY,
+  `PNFNAME` varchar(255) NOT NULL,
+  `PNFDID` varchar(50) NOT NULL,
+  `PNFDINFOID` varchar(100) NOT NULL,
+  `PNFPROFILEID` varchar(255) NOT NULL,
+  `CPINFO` longtext NOT NULL, 
+  `EMSID` varchar(255) NOT NULL,
+  `NSINSTANCES` varchar(1000) NOT NULL
+); 
+
+DROP TABLE IF EXISTS NFVO_SUBSCRIPTION;
+CREATE TABLE `NFVO_SUBSCRIPTION` (
+    `SUBSCRIPTIONID` varchar(200) NOT NULL PRIMARY KEY,
+    `CALLBACKURI` longtext NOT NULL,
+    `AUTHINFO` longtext,
+    `NOTIFICATIONTYPES` varchar(255),
+    `OPERATIONTYPES` longtext,
+    `OPERATIONSTATES` longtext,
+    `VNFINSTANCEFILTER` longtext,
+    `LINKS` longtext NOT NULL
+);