summaryrefslogtreecommitdiffstats
path: root/resources/dbscripts
diff options
context:
space:
mode:
authorfujinhua <fu.jinhua@zte.com.cn>2017-08-18 17:26:11 +0800
committerfujinhua <fu.jinhua@zte.com.cn>2017-08-18 17:26:11 +0800
commit7e18504725e6f38b88981cd9d7aa7653038558e1 (patch)
tree6c4bb282774c6f1b665d3ce911e47cc727807a3b /resources/dbscripts
parent9ee493d90e4ec5a0eb382e33c1681b8d6760dc6c (diff)
Add workflow model and db script
Change-Id: Ia0a086b3360318c75a609132c76ad6f91cba24d3 Issue-Id: VFC-111 Signed-off-by: fujinhua <fu.jinhua@zte.com.cn>
Diffstat (limited to 'resources/dbscripts')
-rw-r--r--resources/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql7
1 files changed, 7 insertions, 0 deletions
diff --git a/resources/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql b/resources/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql
index a325bcfd..36c9ffb6 100644
--- a/resources/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql
+++ b/resources/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql
@@ -268,3 +268,10 @@ CREATE TABLE t_lcm_inputParam_mapping (
CONSTRAINT t_lcm_inputParam_mapping PRIMARY KEY(serviceId,inputKey),
CONSTRAINT t_lcm_inputParam_mapping FOREIGN KEY (serviceId) REFERENCES t_lcm_servicebaseinfo (serviceId)
);
+
+DROP TABLE IF EXISTS NFVO_WF_PLAN;
+CREATE TABLE NFVO_WF_PLAN (
+ `DEPLOYEDID` varchar(255) NOT NULL PRIMARY KEY,
+ `PROCESSID` varchar(255) NOT NULL,
+ `PLANNAME` varchar(255) NOT NULL
+);