diff options
| author |   Ruoyu Ying <ruoyu.ying@intel.com> | 2018-08-30 00:01:53 +0800 |
|---|---|---|
| committer | Ruoyu Ying <ruoyu.ying@intel.com> | 2018-08-30 01:03:00 +0800 |
| commit | 4fed77acee4732f0921a7e528c703ef762239a9d (patch) | |
| tree | 777ac73673ed16772215602b6572806ac9ce4218 | |
| parent | eb6e99be10684ffc3a1ee2aa56a48519fe4fae01 (diff) | |
Add DB table for OOF directives
Add one extra table to store information returned by OOF.
Change-Id: I4b29e7029f0fe0d5cceda2cb411ebb858e99be34
Issue-ID: VFC-1085
Signed-off-by: Ruoyu Ying <ruoyu.ying@intel.com>
| -rw-r--r-- | resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql | 16 |
1 files changed, 16 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 f884e73..f6af383 100644 --- a/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql +++ b/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql @@ -279,3 +279,19 @@ CREATE TABLE NFVO_WF_PLAN ( `MESSAGE` varchar(1024) NULL, `PLANNAME` varchar(255) NOT NULL ); + +DROP TABLE IF EXISTS NFVO_OOF_DATA; +CREATE TABLE NFVO_OOF_DATA ( + `ID` varchar(255) NOT NULL PRIMARY KEY, + `REQUESTID` varchar(255) NOT NULL, + `TRANSACTIONID` varchar(255) NOT NULL, + `REQUESTSTATUS` varchar(50) NOT NULL, + `RESOURCEMODULENAME` varchar(100) NOT NULL, + `SERVICERESOURCEID` varchar(255) NOT NULL, + `VIMID` varchar(255) NULL, + `CLOUDOWNER` varchar(100) NULL, + `CLOUDREGIONID` varchar(255) NULL, + `VDUNAME` varchar(100) NULL, + `FLAVORNAME` varchar(100) NULL, + `DIRECTIVE` longtext NULL +); |