From 534eacb5d02868363c72484bf93f92f2d0a9d938 Mon Sep 17 00:00:00 2001 From: maopengzhang Date: Mon, 8 Oct 2018 18:28:35 +0800 Subject: [PATCH] add PNF Script add PNF Script in DB Change-Id: Ia243e3ed0eb654cad6a1351754f250c74b315196 Issue-ID: VFC-1102 Signed-off-by: maopengzhang --- resources/nslcm/dbscripts/mysql/vfc-nfvo-lcm-createobj.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) 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 +); -- 2.16.6