From 9aa0f3da49308d58971ca65b5592d574b1b56d18 Mon Sep 17 00:00:00 2001 From: Bharath Thiruveedula Date: Wed, 10 Apr 2019 13:07:05 -0400 Subject: Add VNF_PKG_SUBSCRIPTION table to Catalog Change-Id: I6225c9f16b2c8be091e43232b7a4fb926298cd7a Issue-ID: VFC-1221 Signed-off-by: Bharath Thiruveedula --- resources/catalog/dbscripts/mysql/vfc-nfvo-catalog-createobj.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'resources') diff --git a/resources/catalog/dbscripts/mysql/vfc-nfvo-catalog-createobj.sql b/resources/catalog/dbscripts/mysql/vfc-nfvo-catalog-createobj.sql index 8943a1f..8be01b4 100644 --- a/resources/catalog/dbscripts/mysql/vfc-nfvo-catalog-createobj.sql +++ b/resources/catalog/dbscripts/mysql/vfc-nfvo-catalog-createobj.sql @@ -52,3 +52,5 @@ CREATE TABLE `CATALOG_PNFPACKAGE` (`PNFPACKAGEID` varchar(50) NOT NULL PRIMARY K -- 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); + +CREATE TABLE `VNF_PKG_SUBSCRIPTION` (`SUBSCRIPTION_ID` varchar(50) NOT NULL PRIMARY KEY, `CALLBACK_URI` varchar(255) NOT NULL, `AUTH_INFO` longtext NULL, `USAGE_STATES` longtext NULL, `NOTIFICATION_TYPES` longtext NULL, `VNFD_ID` longtext NULL, `VNF_PKG_ID` longtext NULL, `OPERATION_STATES` longtext NULL, `VNF_PRODUCTS_FROM_PROVIDER` longtext NULL, `LINKS` longtext NULL); -- cgit 1.2.3-korg