From 4fed77acee4732f0921a7e528c703ef762239a9d Mon Sep 17 00:00:00 2001 From: Ruoyu Ying 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 --- .../nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql | 16 ++++++++++++++++ 1 file changed, 16 insertions(+) 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