From 584308136c56f7834546f2b39079a74cb2a733f4 Mon Sep 17 00:00:00 2001 From: fujinhua Date: Sat, 19 Aug 2017 10:12:32 +0800 Subject: [PATCH] Add two fields to workflow model Change-Id: If21328bbd72f615e93aa1de8845711b61ebfa6f3 Issue-Id: VFC-111 Signed-off-by: fujinhua --- lcm/pub/database/models.py | 2 ++ resources/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql | 2 ++ 2 files changed, 4 insertions(+) diff --git a/lcm/pub/database/models.py b/lcm/pub/database/models.py index 9071c8e7..0f26c238 100644 --- a/lcm/pub/database/models.py +++ b/lcm/pub/database/models.py @@ -308,5 +308,7 @@ class WFPlanModel(models.Model): deployed_id = models.CharField(db_column='DEPLOYEDID', max_length=255, primary_key=True) process_id = models.CharField(db_column='PROCESSID', max_length=255) + status = models.CharField(db_column='STATUS', max_length=255) + message = models.CharField(db_column='MESSAGE', max_length=1024) plan_name = models.CharField(db_column='PLANNAME', max_length=255) diff --git a/resources/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql b/resources/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql index 36c9ffb6..b2588f05 100644 --- a/resources/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql +++ b/resources/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql @@ -273,5 +273,7 @@ DROP TABLE IF EXISTS NFVO_WF_PLAN; CREATE TABLE NFVO_WF_PLAN ( `DEPLOYEDID` varchar(255) NOT NULL PRIMARY KEY, `PROCESSID` varchar(255) NOT NULL, + `STATUS` varchar(255) NOT NULL, + `MESSAGE` varchar(1024) NULL, `PLANNAME` varchar(255) NOT NULL ); -- 2.16.6