aboutsummaryrefslogtreecommitdiffstats
diff options
context:
space:
mode:
authormaopengzhang <zhang.maopeng1@zte.com.cn>2018-10-08 18:28:35 +0800
committermaopengzhang <zhang.maopeng1@zte.com.cn>2018-10-08 18:28:35 +0800
commit534eacb5d02868363c72484bf93f92f2d0a9d938 (patch)
tree4480b12b002dbbf7b1a7cf1fb97effde484ce067
parent5378f016654d283902d5720c3db5f94d5f3ea1b2 (diff)
add PNF Script
add PNF Script in DB Change-Id: Ia243e3ed0eb654cad6a1351754f250c74b315196 Issue-ID: VFC-1102 Signed-off-by: maopengzhang <zhang.maopeng1@zte.com.cn>
-rw-r--r--resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql b/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql
index dfc4dac..d0e4d7e 100644
--- a/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql
+++ b/resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql
@@ -294,3 +294,15 @@ CREATE TABLE NFVO_OOF_DATA (
`VDUINFO` longtext NULL,
CONSTRAINT ID PRIMARY KEY(REQUESTID,TRANSACTIONID)
);
+
+DROP TABLE IF EXISTS NFVO_PNFINST;
+CREATE TABLE NFVO_PNFINST (
+ `PNFID` varchar(255) NOT NULL PRIMARY KEY,
+ `PNFNAME` varchar(255) NOT NULL,
+ `PNFDID` varchar(50) NOT NULL,
+ `PNFDINFOID` varchar(100) NOT NULL,
+ `PNFPROFILEID` varchar(255) NOT NULL,
+ `CPINFO` longtext NOT NULL,
+ `EMSID` varchar(255) NOT NULL,
+ `NSINSTANCES` varchar(1000) NOT NULL
+);