aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authorBharath Thiruveedula <bharath.thiruveedula@verizon.com>2018-08-30 14:07:28 +0530
committerBharath Thiruveedula <bharath.thiruveedula@verizon.com>2018-08-31 15:43:04 +0530
commitb4eb3a04bc5a583dde9de19d063a69536ff1f568 (patch)
treeadf112e0dac755defbc92245c2129cfbeca76859
parent4fed77acee4732f0921a7e528c703ef762239a9d (diff)
Add SUBSCRIPTION table to GVNFM DB
Issue-ID: VFC-999 Change-Id: Ic3cfcfaf09701b363720ccacdf9eaaef3aafd9d8 Signed-off-by: Bharath Thiruveedula<bharath.thiruveedula@verizon.com>
-rw-r--r--resources/gvnfm/dbscripts/mysql/onap-gvnfm-vnfres-createobj.sql14
1 files 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;
-
+