From b4eb3a04bc5a583dde9de19d063a69536ff1f568 Mon Sep 17 00:00:00 2001 From: Bharath Thiruveedula Date: Thu, 30 Aug 2018 14:07:28 +0530 Subject: Add SUBSCRIPTION table to GVNFM DB Issue-ID: VFC-999 Change-Id: Ic3cfcfaf09701b363720ccacdf9eaaef3aafd9d8 Signed-off-by: Bharath Thiruveedula --- .../gvnfm/dbscripts/mysql/onap-gvnfm-vnfres-createobj.sql | 14 ++++++++++++-- 1 file changed, 12 insertions(+), 2 deletions(-) diff --git a/resources/gvnfm/dbscripts/mysql/onap-gvnfm-vnfres-createobj.sql b/resources/gvnfm/dbscripts/mysql/onap-gvnfm-vnfres-createobj.sql index 2dbd668..9ee6c1e 100644 --- a/resources/gvnfm/dbscripts/mysql/onap-gvnfm-vnfres-createobj.sql +++ b/resources/gvnfm/dbscripts/mysql/onap-gvnfm-vnfres-createobj.sql @@ -245,6 +245,16 @@ 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 +) +; COMMIT; - + -- cgit 1.2.3-korg