diff options
| author |   Sirisha Gopigiri <sirisha.gopigiri@verizon.com> | 2019-04-10 15:20:31 +0530 |
|---|---|---|
| committer | Sirisha Gopigiri <sirisha.gopigiri@verizon.com> | 2019-04-10 15:23:47 +0530 |
| commit | 1f139f5c32cbc6f782caa85db1da57066d482649 (patch) | |
| tree | 4c59777e6371cdd3a48cebb49da8ace6e46972c3 | |
| parent | bbc7362e73f3699ab306f74295a32588c5e4ab5c (diff) | |
Add NsdManagementSubscription Table
Add SOL 005 NsdManagementSubscription Table in CatalogDB
Change-Id: I4db9549d70e15eb7e20ff010f3e91f99fc5abcac
Issue-ID: VFC-1217
Signed-off-by: Sirisha Gopigiri <sirisha.gopigiri@verizon.com>
| -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); |