From dbc96e353cec70db224622253bc43b0e99f271fe Mon Sep 17 00:00:00 2001 From: maopengzhang Date: Fri, 9 Nov 2018 20:30:22 +0800 Subject: fix db error add table nfvo_sub, etc Change-Id: Ie22ca97e58c78715abf6c134864cd16b8ab4f14a Issue-ID: VFC-1158 Signed-off-by: maopengzhang --- resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) diff --git a/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql b/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql index d0e4d7e..c244776 100644 --- a/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql +++ b/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql @@ -306,3 +306,15 @@ CREATE TABLE NFVO_PNFINST ( `EMSID` varchar(255) NOT NULL, `NSINSTANCES` varchar(1000) NOT NULL ); + +DROP TABLE IF EXISTS NFVO_SUBSCRIPTION; +CREATE TABLE `NFVO_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 +); -- cgit 1.2.3-korg