Update db process part

[vfc/nfvo/driver/vnfm/svnfm.git] / nokia / vnfmdriver / vfcadaptorservice / deployment / src / main / release / db / mysql / db-schema.sql

diff --git a/nokia/vnfmdriver/vfcadaptorservice/deployment/src/main/release/db/mysql/db-schema.sql b/nokia/vnfmdriver/vfcadaptorservice/deployment/src/main/release/db/mysql/db-schema.sql
index 2625222..8a3b2a2 100644 (file)
--- a/nokia/vnfmdriver/vfcadaptorservice/deployment/src/main/release/db/mysql/db-schema.sql
+++ b/nokia/vnfmdriver/vfcadaptorservice/deployment/src/main/release/db/mysql/db-schema.sql
@@ -17,18 +17,18 @@
 
 /******************drop old database and user***************************/
 use mysql;
-drop database IF  EXISTS vnfm_db;
+drop database IF EXISTS vnfm_db;
 delete from user where User='vnfm';
 FLUSH PRIVILEGES;
 
 /******************create new database and user***************************/
 create database vnfm_db CHARACTER SET utf8;
 
-GRANT ALL PRIVILEGES ON vnfm_db.* TO 'vnfm'@'%' IDENTIFIED BY 'vnfm' WITH GRANT OPTION;
-GRANT ALL PRIVILEGES ON mysql.* TO 'vnfm'@'%' IDENTIFIED BY 'vnfm' WITH GRANT OPTION;
+GRANT ALL PRIVILEGES ON vnfm_db.* TO 'vnfm'@'%' IDENTIFIED BY 'vnfmpass' WITH GRANT OPTION;
+GRANT ALL PRIVILEGES ON mysql.* TO 'vnfm'@'%' IDENTIFIED BY 'vnfmpass' WITH GRANT OPTION;
 
-GRANT ALL PRIVILEGES ON vnfm_db.* TO 'vnfm'@'localhost' IDENTIFIED BY 'vnfm' WITH GRANT OPTION;
-GRANT ALL PRIVILEGES ON mysql.* TO 'vnfm'@'localhost' IDENTIFIED BY 'vnfm' WITH GRANT OPTION;
+GRANT ALL PRIVILEGES ON vnfm_db.* TO 'vnfm'@'localhost' IDENTIFIED BY 'vnfmpass' WITH GRANT OPTION;
+GRANT ALL PRIVILEGES ON mysql.* TO 'vnfm'@'localhost' IDENTIFIED BY 'vnfmpass' WITH GRANT OPTION;
 FLUSH PRIVILEGES;
 
 use vnfm_db;
@@ -36,21 +36,21 @@ set Names 'utf8';
 
 /******************drop old table and create new***************************/
 
-DROP TABLE IF EXISTS  vnfm_job_execution_record;
-CREATE TABLE `vnfm_job_execution_record` (
-  `jobId` int(11) auto_increment primary key,
-  `vnfInstanceId` varchar(60) DEFAULT NULL,
-  `vnfmExecutionId` varchar(60) DEFAULT NULL,
-  `vnfmInterfceName` varchar(60) DEFAULT NULL,
+DROP TABLE IF EXISTS  vnfm_job_execution_info;
+CREATE TABLE `vnfm_job_execution_info` (
+  `job_id` int(11) auto_increment primary key,
+  `vnf_instance_id` varchar(60) DEFAULT NULL,
+  `vnfm_execution_id` varchar(60) DEFAULT NULL,
+  `vnfm_interface_name` varchar(60) DEFAULT NULL,
   `status` varchar(24) DEFAULT NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
 
 
-DROP TABLE IF EXISTS vnfm_resource_record;
-CREATE TABLE `vnfm_resource` (
+DROP TABLE IF EXISTS vnfm_resource_info;
+CREATE TABLE `vnfm_resource_info` (
   `id` int(11) auto_increment primary key,
   `type` enum ('VDU','VL','CP','Storage') DEFAULT NULL,
-  `resourceDefinitionId` varchar(60) DEFAULT NULL,
+  `resource_definition_id` varchar(60) DEFAULT NULL,
   `vdu` varchar(60) DEFAULT NULL,
   `status` varchar(24) DEFAULT NULL
 ) ENGINE=MyISAM DEFAULT CHARSET=utf8;
\ No newline at end of file