mirror of
https://github.com/NexusForever/NexusForever
synced 2026-08-14 00:26:05 -04:00
6ebe337877
Moved from database first to code first. Upgraded to EFCore 3.1. Upgraded to .NET Core 3.1.
38 lines
1.5 KiB
Bash
38 lines
1.5 KiB
Bash
#!/bin/bash
|
|
|
|
# Find dir script is running in
|
|
DIR="$( cd "$( dirname "${BASH_SOURCE[0]}" )" >/dev/null && pwd )"
|
|
|
|
echo "Cleaning existing DB"
|
|
mysql -v -u root -e "DROP DATABASE nexus_forever_auth;"
|
|
mysql -v -u root -e "DROP DATABASE nexus_forever_character;"
|
|
mysql -v -u root -e "DROP DATABASE nexus_forever_world;"
|
|
mysql -v -u root -e "DROP USER nexusforever;"
|
|
|
|
echo "Creating databases"
|
|
mysql -v -u root -e "CREATE DATABASE nexus_forever_auth;"
|
|
mysql -v -u root -e "CREATE DATABASE nexus_forever_character;"
|
|
mysql -v -u root -e "CREATE DATABASE nexus_forever_world;"
|
|
|
|
echo "Creating user for tests to use"
|
|
mysql -v -u root -e "CREATE USER nexusforever IDENTIFIED BY 'nexusforever';"
|
|
mysql -v -u root -e "GRANT ALL ON *.* to nexusforever;"
|
|
|
|
echo "Running base scripts"
|
|
mysql -v -u root -D nexus_forever_auth < $DIR/../Base/Auth.sql
|
|
mysql -v -u root -D nexus_forever_character < $DIR/../Base/Character.sql
|
|
mysql -v -u root -D nexus_forever_world < $DIR/../Base/World.sql
|
|
|
|
echo "Running update scripts"
|
|
for file in $(find $DIR/../Updates/Auth/ -name '*.sql' | sort); do
|
|
mysql -u root -D nexus_forever_auth < $file;
|
|
done;
|
|
for file in $(find $DIR/../Updates/Character/ -name '*.sql' | sort); do
|
|
mysql -u root -D nexus_forever_character < $file;
|
|
done;
|
|
for file in $(find $DIR/../Updates/World/ -name '*.sql' | sort); do
|
|
mysql -u root -D nexus_forever_world < $file;
|
|
done;
|
|
|
|
echo "Inserting server information"
|
|
mysql -v -u root -D nexus_forever_auth -e "INSERT INTO server (name, host, port, type) VALUES ('NexusForever', '127.0.0.1', 24000, 0);"
|