aboutsummaryrefslogtreecommitdiffstats
path: root/resources
diff options
context:
space:
mode:
authorFu Jinhua <fu.jinhua@zte.com.cn>2018-11-10 03:30:47 +0000
committerGerrit Code Review <gerrit@onap.org>2018-11-10 03:30:47 +0000
commit7d469e77df1fb79b879e2e2c12fdaa228089c17f (patch)
tree219416c338d35f0e42b9994ec40dc5214d68d9bf /resources
parentb39ed3b6833783c3b2efe8bf0b03f90712cf4d6f (diff)
parentdbc96e353cec70db224622253bc43b0e99f271fe (diff)
Merge "fix db error"3.0.1-ONAP3.0.0-ONAP1.2.1
Diffstat (limited to 'resources')
-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
+);