aboutsummaryrefslogtreecommitdiffstats
path: root/resources/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql
diff options
context:
space:
mode:
authorFu Jinhua <fu.jinhua@zte.com.cn>2017-08-18 09:26:16 +0000
committerGerrit Code Review <gerrit@onap.org>2017-08-18 09:26:16 +0000
commitd1b52d475a5f17b3ee2e069de17ccb6c5e34cd49 (patch)
treed2dd422b07ed379d32015e726ddabc2d144db33b /resources/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql
parente8e3fec8c31069218ddf95a288d1ff0dbfe5088d (diff)
parent7e18504725e6f38b88981cd9d7aa7653038558e1 (diff)
Merge "Add workflow model and db script"
Diffstat (limited to 'resources/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql')
-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
+);