diff options
| -rw-r--r-- | resources/catalog/dbscripts/mysql/vfc-nfvo-catalog-createobj.sql | 5 |
1 files changed, 5 insertions, 0 deletions
diff --git a/resources/catalog/dbscripts/mysql/vfc-nfvo-catalog-createobj.sql b/resources/catalog/dbscripts/mysql/vfc-nfvo-catalog-createobj.sql index 8fa8126..8943a1f 100644 --- a/resources/catalog/dbscripts/mysql/vfc-nfvo-catalog-createobj.sql +++ b/resources/catalog/dbscripts/mysql/vfc-nfvo-catalog-createobj.sql @@ -22,6 +22,7 @@ DROP TABLE IF EXISTS CATALOG_NSPACKAGE; DROP TABLE IF EXISTS CATALOG_SOFTWAREIMAGEMODEL; DROP TABLE IF EXISTS CATALOG_VNFPACKAGE; DROP TABLE IF EXISTS CATALOG_PNFPACKAGE; +DROP TABLE IF EXISTS CATALOG_NSDM_SUBSCRIPTION; -- -- Create model JobModel @@ -47,3 +48,7 @@ CREATE TABLE `CATALOG_VNFPACKAGE` (`VNFPACKAGEID` varchar(50) NOT NULL PRIMARY K -- Create model PnfPackageModel -- CREATE TABLE `CATALOG_PNFPACKAGE` (`PNFPACKAGEID` varchar(50) NOT NULL PRIMARY KEY, `PNFPACKAGEURI` varchar(300) NULL, `SDCCSARURI` varchar(300) NULL, `CHECKSUM` varchar(50) NULL, `ONBOARDINGSTATE` varchar(20) NULL, `USAGESTATE` varchar(20) NULL, `DELETIONPENDING` varchar(20) NULL, `PNFDID` varchar(50) NULL, `VENDOR` varchar(50) NULL, `PNFDPRODUCTNAME` varchar(50) NULL, `PNFDVERSION` varchar(20) NULL, `PNFSOFTWAREVERSION` varchar(20) NULL, `USERDEFINEDDATA` longtext NULL, `LOCALFILEPATH` varchar(300) NULL, `PNFDMODEL` longtext NULL, `PNFDNAME` varchar(100) NULL); +-- +-- Create model NsdmSubscription +-- +CREATE TABLE `CATALOG_NSDM_SUBSCRIPTION` (`SUBSCRIPTIONID` varchar(255) NOT NULL PRIMARY KEY, `NOTIFICATIONTYPES` longtext NULL, `AUTHINFO` longtext NULL, `CALLBACKURI` varchar(255) NOT NULL, `NSDINFOID` longtext NULL, `NSDID` longtext NULL, `NSDNAME` longtext NULL, `NSDVERSION` longtext NULL, `NSDDESIGNER` longtext NULL, `NSDINVARIANTID` longtext NULL, `VNFPKGIDS` longtext NULL, `PNFDINFOIDS` longtext NULL, `NESTEDNSDINFOIDS` longtext NULL, `NSDONBOARDINGSTATE` longtext NULL, `NSDOPERATIONALSTATE` longtext NULL, `NSDUSAGESTATE` longtext NULL, `PNFDID` longtext NULL, `PNFDNAME` longtext NULL, `PNFDVERSION` longtext NULL, `PNFDPROVIDER` longtext NULL, `PNFDINVARIANTID` longtext NULL, `PNFDONBOARDINGSTATE` longtext NULL, `PNFDUSAGESTATE` longtext NULL, `LINKS` longtext NOT NULL); |