}
-cd /service
-if [ ! -f dbexist.txt ]; then
- echo 1 > dbexist.txt
+GET_NSLCM_DB="show databases like 'vfcnfvolcm';"
+NSLCM_DB=`mysql -u$MYSQL_ROOT_USER -p$MYSQL_ROOT_PASSWORD -P$MYSQL_PORT -h$MYSQL_IP -e "GET_NSLCM_DB"`
+if [[ "$NSLCM_DB" == "" ]]; then
create_database
migrate_database
fi
mysql -u$MYSQL_USER -p$MYSQL_PASSWORD -P$MYSQL_PORT -h$MYSQL_IP <$sql_path/dbscripts/mysql/vfc-nfvo-lcm-createdb.sql
sql_result=$?
if [ $sql_result -ne 0 ] ; then
- echo "failed to create vfcnfvolcm database"
+ echo "Failed to create vfcnfvolcm database"
exit 1
-elif [ $sql_result -eq 0 ]; then
- echo "create vfcnfvolcm database successfully"
+else
+ echo "Create vfcnfvolcm database successfully"
exit 0
fi
-- limitations under the License.
--
-/******************drop old database and user***************************/
+/******************create database and user***************************/
use mysql;
-drop database IF EXISTS vfcnfvolcm;
-delete from user where User='vfcnfvolcm';
-FLUSH PRIVILEGES;
+create database if not exists vfcnfvolcm CHARACTER SET utf8;
-/******************create new database and user***************************/
-create database vfcnfvolcm CHARACTER SET utf8;
GRANT ALL PRIVILEGES ON vfcnfvolcm.* TO 'vfcnfvolcm'@'%' IDENTIFIED BY 'vfcnfvolcm' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON mysql.* TO 'vfcnfvolcm'@'%' IDENTIFIED BY 'vfcnfvolcm' WITH GRANT OPTION;