ad3f48f9de
Fixes a couple issues with the column checking. Adds verification to table columns to make sure table format is correct. Cleans up the node processing. Adds a loading progress status. Adjusts the SQL import files to not destroy previously imported data. Updated README.md to reflect the changes for SQL importing. Fixes #5485 Fixes #5477 Thanks to @Lemongrass3110! Co-authored-by: Lemongrass3110 <lemongrass@kstp.at>
33 lines
1.9 KiB
Batchfile
33 lines
1.9 KiB
Batchfile
@echo off
|
|
|
|
rem MySQL database setup
|
|
|
|
rem Use the `MYSQL_PWD` environment variable to avoid insecure warning.
|
|
set MYSQL_PWD=%DB_ROOTPW%
|
|
|
|
%MYSQL% -u %DB_ROOT% -e "CREATE DATABASE %DB_NAME%;"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\main.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\logs.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\item_cash_db.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\item_cash_db2.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\item_db.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\item_db_usable.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\item_db_equip.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\item_db_etc.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\item_db2.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\item_db_re.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\item_db_re_usable.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\item_db_re_equip.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\item_db_re_etc.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\item_db2_re.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\mob_db.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\mob_db2.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\mob_db_re.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\mob_db2_re.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\mob_skill_db.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\mob_skill_db2.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\mob_skill_db_re.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\mob_skill_db2_re.sql"
|
|
%MYSQL% -u %DB_ROOT% %DB_NAME% -e "source sql-files\roulette_default_data.sql"
|
|
%MYSQL% -u %DB_ROOT% -e "GRANT SELECT,INSERT,UPDATE,DELETE ON %DB_NAME%.* TO '%DB_USER%'@'%DB_HOST%' IDENTIFIED BY '%DB_USERPW%';"
|