Changes in MANO DB init scripts to allow db_name as input parameter
Signed-off-by: tierno <alfonso.tiernosepulveda@telefonica.com>
diff --git a/database_utils/init_mano_db.sh b/database_utils/init_mano_db.sh
index c876ea4..cbb76ef 100755
--- a/database_utils/init_mano_db.sh
+++ b/database_utils/init_mano_db.sh
@@ -41,11 +41,11 @@
echo -e " -p PASS database password. 'No password' by default. Prompts if DB access fails"
echo -e " -P PORT database port. '$DBPORT' by default"
echo -e " -h HOST database host. '$DBHOST' by default"
-# echo -e " -d NAME database name. '$DBNAME' by default. Prompts if DB access fails"
+ echo -e " -d NAME database name. '$DBNAME' by default. Prompts if DB access fails"
echo -e " --help shows this help"
}
-while getopts ":u:p:P:h:-:" o; do
+while getopts ":u:p:P:d:h:-:" o; do
case "${o}" in
u)
DBUSER="$OPTARG"
@@ -56,9 +56,9 @@
P)
DBPORT="$OPTARG"
;;
-# d)
-# DBNAME="$OPTARG"
-# ;;
+ d)
+ DBNAME="$OPTARG"
+ ;;
h)
DBHOST="$OPTARG"
;;
@@ -106,7 +106,7 @@
#${DIRNAME}/quick_delete_db.sh $MUSER $MPASS $MDB $HOST $PORT
echo " loading ${DIRNAME}/${DBNAME}_structure.sql"
-mysql $DBHOST_ $DBPORT_ $DBUSER_ $DBPASS_ < ${DIRNAME}/${DBNAME}_structure.sql
+mysql $DBHOST_ $DBPORT_ $DBUSER_ $DBPASS_ $DBNAME < ${DIRNAME}/mano_db_structure.sql
echo " migrage database version"
${DIRNAME}/migrate_mano_db.sh $DBHOST_ $DBPORT_ $DBUSER_ $DBPASS_ -d$DBNAME
diff --git a/database_utils/mano_db_structure.sql b/database_utils/mano_db_structure.sql
index aca07aa..c70fbc1 100644
--- a/database_utils/mano_db_structure.sql
+++ b/database_utils/mano_db_structure.sql
@@ -37,16 +37,6 @@
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
--
--- Current Database: `mano_db`
---
-
-/*!40000 DROP DATABASE IF EXISTS `mano_db`*/;
-
-CREATE DATABASE /*!32312 IF NOT EXISTS*/ `mano_db` /*!40100 DEFAULT CHARACTER SET latin1 */;
-
-USE `mano_db`;
-
---
-- Table structure for table `datacenter_nets`
--