diff options
3 files changed, 50 insertions, 5 deletions
diff --git a/resources/catalog/dbscripts/mysql/vfc-nfvo-catalog-createobj.sql b/resources/catalog/dbscripts/mysql/vfc-nfvo-catalog-createobj.sql index 98bcc9b..3e2761b 100644 --- a/resources/catalog/dbscripts/mysql/vfc-nfvo-catalog-createobj.sql +++ b/resources/catalog/dbscripts/mysql/vfc-nfvo-catalog-createobj.sql @@ -33,7 +33,7 @@ CREATE TABLE `CATALOG_JOB_STATUS` (`id` integer AUTO_INCREMENT NOT NULL PRIMARY -- -- Create model NSPackageModel -- -CREATE TABLE `CATALOG_NSPACKAGE` (`NSPACKAGEID` varchar(50) NOT NULL PRIMARY KEY, `NSPACKAGEURI` varchar(300) NULL, `CHECKSUM` varchar(50) NULL, `SDCCSARID` varchar(50) NULL, `ONBOARDINGSTATE` varchar(20) NULL, `OPERATIONALSTATE` varchar(20) NULL, `USAGESTATE` varchar(20) NULL, `DELETIONPENDING` varchar(20) NULL, `NSDID` varchar(50) NULL, `NSDNAME` varchar(50) NULL, `NSDDESIGNER` varchar(50) NULL, `NSDDESCRIPTION` varchar(100) NULL, `NSDVERSION` varchar(20) NULL, `USERDEFINEDDATA` longtext NULL, `LOCALFILEPATH` varchar(300) NULL, `NSDMODEL` longtext NULL); +CREATE TABLE `CATALOG_NSPACKAGE` (`NSPACKAGEID` varchar(50) NOT NULL PRIMARY KEY, `NSPACKAGEURI` varchar(300) NULL, `CHECKSUM` varchar(50) NULL, `SDCCSARID` varchar(50) NULL, `ONBOARDINGSTATE` varchar(20) NULL, `OPERATIONALSTATE` varchar(20) NULL, `USAGESTATE` varchar(20) NULL, `DELETIONPENDING` varchar(20) NULL, `NSDID` varchar(50) NULL, `NSDNAME` varchar(50) NULL, `NSDDESIGNER` varchar(50) NULL, `NSDDESCRIPTION` varchar(100) NULL, `NSDVERSION` varchar(20) NULL, `USERDEFINEDDATA` longtext NULL, `LOCALFILEPATH` varchar(300) NULL, `NSDMODEL` longtext NULL, `INVARIANTID` varchar(50) NULL); -- -- Create model SoftwareImageModel -- diff --git a/resources/gvnfm/dbscripts/mysql/onap-gvnfm-vnfres-createobj.sql b/resources/gvnfm/dbscripts/mysql/onap-gvnfm-vnfres-createobj.sql index 2dbd668..4c91949 100644 --- a/resources/gvnfm/dbscripts/mysql/onap-gvnfm-vnfres-createobj.sql +++ b/resources/gvnfm/dbscripts/mysql/onap-gvnfm-vnfres-createobj.sql @@ -33,7 +33,9 @@ CREATE TABLE `NFINST` ( `VNFDID` varchar(200), `VNFSOFTWAREVER` varchar(200), `VNFCONFIGURABLEPROPERTIES` longtext, - `LOCALIZATIONLANGUAGE` varchar(255) + `LOCALIZATIONLANGUAGE` varchar(255), + `RESINFO` longtext, + `VIMINFO` longtext ) ; CREATE TABLE `JOB` ( @@ -245,6 +247,34 @@ CREATE TABLE `VNF_REG` ( `PASSWORD` varchar(255) NOT NULL ) ; - +CREATE TABLE `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 +) +; +CREATE TABLE `VNFLCMOPOCCS` ( + `ID` varchar(255) NOT NULL PRIMARY KEY, + `OPERATIONSTATE` varchar(30) NOT NULL, + `STATEENTEREDTIME` varchar(30) NOT NULL, + `STARTTIME` varchar(30) NOT NULL, + `VNFINSTANCEID` varchar(255) NOT NULL, + `GRANTID` varchar(255), + `OPERATION` varchar(30) NOT NULL, + `ISAUTOMATICINVOCATION` varchar(5) NOT NULL, + `OPERATIONPARAMS` longtext NOT NULL, + `ISCANCELPENDING` varchar(5) NOT NULL, + `CANCELMODE` varchar(255), + `ERROR` longtext, + `RESOURCECHANGES` longtext, + `CHANGEDINFO` longtext, + `CHANGEDEXTCONNECTIVITY` longtext, + `LINKS` longtext NOT NULL +) +; COMMIT; - diff --git a/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql b/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql index f884e73..dfc4dac 100644 --- a/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql +++ b/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql @@ -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,17 @@ 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) +); |