From 22656dd896543fe65bb718161bdb23323fda18a6 Mon Sep 17 00:00:00 2001 From: Bharath Thiruveedula Date: Wed, 5 Sep 2018 16:32:03 +0530 Subject: [PATCH] Add VNFLCMOPOCCS Table to GVNFM DB Signed-off-by: Bharath Thiruveedula Change-Id: I19b8fe344913c36306f053b6c945b12b487873a7 Issue-ID: VFC-997 --- .../dbscripts/mysql/onap-gvnfm-vnfres-createobj.sql | 20 +++++++++++++++++++- 1 file changed, 19 insertions(+), 1 deletion(-) diff --git a/resources/gvnfm/dbscripts/mysql/onap-gvnfm-vnfres-createobj.sql b/resources/gvnfm/dbscripts/mysql/onap-gvnfm-vnfres-createobj.sql index 9ee6c1e..73ad74c 100644 --- a/resources/gvnfm/dbscripts/mysql/onap-gvnfm-vnfres-createobj.sql +++ b/resources/gvnfm/dbscripts/mysql/onap-gvnfm-vnfres-createobj.sql @@ -256,5 +256,23 @@ CREATE TABLE `SUBSCRIPTION` ( `LINKS` longtext NOT NULL ) ; +CREATE TABLE `VNFLCMOPOCCS` ( + `ID` varchar(255) NOT NULL PRIMARY KEY, + `OPERATIONSTATE` varchar(30) NOT NULL, + `STATEENTEREDTIME` varchar(30) NOT NULL, + `STARTTIME` varchar(30) NOT NULL, + `VNFINSTANCEID` varchar(255) NOT NULL, + `GRANTID` varchar(255), + `OPERATION` varchar(30) NOT NULL, + `ISAUTOMATICINVOCATION` varchar(5) NOT NULL, + `OPERATIONPARAMS` longtext NOT NULL, + `ISCANCELPENDING` varchar(5) NOT NULL, + `CANCELMODE` varchar(255), + `ERROR` longtext, + `RESOURCECHANGES` longtext, + `CHANGEDINFO` longtext, + `CHANGEDEXTCONNECTIVITY` longtext, + `LINKS` longtext NOT NULL +) +; COMMIT; - -- 2.16.6