aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authormaopengzhang <zhang.maopeng1@zte.com.cn>2018-11-09 20:30:22 +0800
committermaopengzhang <zhang.maopeng1@zte.com.cn>2018-11-09 20:30:22 +0800
commitdbc96e353cec70db224622253bc43b0e99f271fe (patch)
tree27f7271846fbd63c34597aab37265e05422d0497
parent7bd9c7bca5461002a30c0678c9b8b48bf0281e73 (diff)
fix db error
add table nfvo_sub, etc Change-Id: Ie22ca97e58c78715abf6c134864cd16b8ab4f14a Issue-ID: VFC-1158 Signed-off-by: maopengzhang <zhang.maopeng1@zte.com.cn>
-rw-r--r--resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql12
1 files changed, 12 insertions, 0 deletions
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
+);