Modify VFC catalog

Modify VFC catalog URL and add sql file

Change-Id: Ie49a0c6aefc4d41cd347d0ad4a955f39ef0970c9
Issue-ID: VFC-152
Signed-off-by: maopengzhang <zhang.maopeng1@zte.com.cn>

1 files changed, 66 insertions, 4 deletions

diff --git a/resources/dbscripts/mysql/vfc-nfvo-catalog-createobj.sql b/resources/dbscripts/mysql/vfc-nfvo-catalog-createobj.sql
index 53b5b4f0..6aba3eee 100644
--- a/resources/dbscripts/mysql/vfc-nfvo-catalog-createobj.sql
+++ b/resources/dbscripts/mysql/vfc-nfvo-catalog-createobj.sql
@@ -16,8 +16,70 @@
 
 use nfvocatalog;
 
-DROP TABLE IF EXISTS NFVO_SAMPLE;
-CREATE TABLE NFVO_SAMPLE ( 
-  `SAMPLEID` varchar(255) NOT NULL PRIMARY KEY, 
-  `SAMPLENAME` varchar(255) NOT NULL
+DROP TABLE IF EXISTS NFVO_JOB;
+CREATE TABLE NFVO_JOB (
+  `JOBID` varchar(255) NOT NULL PRIMARY KEY,
+  `JOBTYPE` varchar (255) NOT NULL,
+  `JOBACTION` varchar(255) NOT NULL,
+  `RESID` varchar(255) NOT NULL,
+  `STATUS` integer NULL,
+  `STARTTIME` varchar(255) NULL,
+  `ENDTIME` varchar(255) NULL,
+  `PROGRESS` integer NULL,
+  `USER` varchar(255) NULL,
+  `PARENTJOBID` varchar(255) NULL,
+  `RESNAME` varchar(255) NULL
 );
+
+DROP TABLE IF EXISTS NFVO_JOB_STATUS;
+CREATE TABLE NFVO_JOB_STATUS (
+  `id` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
+  `INDEXID` integer NOT NULL,
+  `JOBID` varchar(255) NOT NULL,
+  `STATUS` varchar(255) NOT NULL,
+  `PROGRESS` integer NULL,
+  `DESCP` longtext NOT NULL,
+  `ERRCODE` varchar(255) NULL,
+  `ADDTIME` varchar(255) NULL
+);
+
+
+DROP TABLE IF EXISTS NFVO_NFPACKAGE;
+CREATE TABLE NFVO_NFPACKAGE (
+  `UUID` varchar(255) NOT NULL PRIMARY KEY,
+  `NFPACKAGEID` varchar(200) NOT NULL,
+  `VNFDID` varchar(255) NOT NULL,
+  `VENDOR` varchar(255) NOT NULL,
+  `VNFDVERSION` varchar(255) NOT NULL,
+  `VNFVERSION` varchar(255) NOT NULL,
+  `VNFDMODEL` longtext NULL,
+  `VNFDPATH` varchar(300) NULL
+);
+
+DROP TABLE IF EXISTS NFVO_NSPACKAGE;
+CREATE TABLE NFVO_NSPACKAGE (
+  `ID` varchar(200) NOT NULL PRIMARY KEY,
+  `NSDID` varchar(200) NOT NULL,
+  `NAME` varchar(200) NOT NULL,
+  `VENDOR` varchar(200) NULL,
+  `DESCRIPTION` varchar(200) NULL,
+  `VERSION` varchar(200) NULL,
+  `NSDMODEL` longtext NULL,
+  `NSDPATH` varchar(300) NULL
+);
+
+
+DROP TABLE IF EXISTS NFVO_NFPACKAGEFILE;
+CREATE TABLE NFVO_NFPACKAGEFILE (
+  `ID` integer AUTO_INCREMENT NOT NULL PRIMARY KEY,
+  `NFPACKAGEID` varchar(50) NOT NULL,
+  `FILENAME` varchar(100) NOT NULL,
+  `FILETYPE` varchar(2) NOT NULL,
+  `IMAGEID` varchar(50) NOT NULL,
+  `VIMID` varchar(50) NOT NULL,
+  `VIMUSER` varchar(50) NOT NULL,
+  `TENANT` varchar(50) NOT NULL,
+  `PURPOSE` varchar(1000) NOT NULL,
+  `STATUS` varchar(10) NOT NULL
+);
+