diff options
author | Bharath Thiruveedula <bharath.thiruveedula@verizon.com> | 2018-09-05 16:32:03 +0530 |
---|---|---|
committer | Bharath Thiruveedula <bharath.thiruveedula@verizon.com> | 2018-09-05 21:29:07 +0530 |
commit | 22656dd896543fe65bb718161bdb23323fda18a6 (patch) | |
tree | b898655045fcec9b0aad07b68fcd591721622584 | |
parent | b4eb3a04bc5a583dde9de19d063a69536ff1f568 (diff) |
Add VNFLCMOPOCCS Table to GVNFM DB
Signed-off-by: Bharath Thiruveedula<bharath.thiruveedula@verizon.com>
Change-Id: I19b8fe344913c36306f053b6c945b12b487873a7
Issue-ID: VFC-997
-rw-r--r-- | resources/gvnfm/dbscripts/mysql/onap-gvnfm-vnfres-createobj.sql | 20 |
1 files changed, 19 insertions, 1 deletions
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; - |