create_db.bat

CRM源码This file describes some issues that should be implemented in future and how it should be imple

@echo off
cd $MYSQL_PATH\bin

rem set login and password
set LOGIN=--user=$MYSQL_LOGIN
set PASS=$MYSQL_PASSWORD
set DBNAME=$DB_NAME
set PORT=--port=$MYSQL_PORT

@if not "%PASS%" == "" set PASS=--password=%PASS%

set /a i=0

:connect
echo Trying to Connect to MySQL...
set /a i=i+1
mysql %LOGIN% %PASS% %PORT% < .\sql\connect.sql > null

if "%i%" == "40" goto invalid
 
if errorlevel 1 goto connect

echo Connected Successfully

echo Creating QueWeb database ...
mysql %LOGIN% %PASS% %PORT% < .\sql\0.database-qwoss_v001.sql > null
echo Script 1 of 11 done
mysql %LOGIN% %PASS% %PORT% %DBNAME% < .\sql\0.database-qwoss-login_v001.sql > null
echo Script 2 of 11 done

set LOGIN=--user=$DB_USER
set PASS=--password=$DB_PASSWORD

mysql %LOGIN% %PASS% %PORT% %DBNAME% < .\sql\1.framework-objects_v068.sql > null
echo Script 3 of 11 done
mysql %LOGIN% %PASS% %PORT% %DBNAME% < .\sql\2.framework-sp_v001.sql > null
echo Script 4 of 11 done
mysql %LOGIN% %PASS% %PORT% %DBNAME% < .\sql\3.framework-data_v068.sql > null
echo Script 5 of 11 done
mysql %LOGIN% %PASS% %PORT% %DBNAME% < .\sql\4.primarykeys-update_proc_v001.sql > null
echo Script 6 of 11 done
mysql %LOGIN% %PASS% %PORT% %DBNAME% < .\sql\5.framework-data_v055.sql > null
echo Script 7 of 11 done
mysql %LOGIN% %PASS% %PORT% %DBNAME% < .\sql\6.dataschema_v055.sql > null
echo Script 8 of 11 done
mysql %LOGIN% %PASS% %PORT% %DBNAME% < .\sql\7.data-dictionaries_v055.sql > null
echo Script 9 of 11 done
mysql %LOGIN% %PASS% %PORT% %DBNAME% < .\sql\8.application-data_v055.sql > null
echo Script 10 of 11 done
mysql %LOGIN% %PASS% %PORT% %DBNAME% < .\sql\dashboard_data.sql > null
echo Script 11 of 11 done
echo QueWeb DB has been successfully created!

echo Removing script files...
rem remove sql files
del .\sql /Q /F
rmdir .\sql
echo All script files have been removed!

goto exit

:invalid
echo Connect was not established, please check that MySQL is installed and started!

:exit