From 4fed77acee4732f0921a7e528c703ef762239a9d Mon Sep 17 00:00:00 2001
From: Ruoyu Ying <ruoyu.ying@intel.com>
Date: Thu, 30 Aug 2018 00:01:53 +0800
Subject: 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>
---
 .../nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql     | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

(limited to 'resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql')

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
+);
-- 
cgit 1.2.3-korg

