summaryrefslogtreecommitdiff
path: root/localserver/initdb.sh
diff options
context:
space:
mode:
Diffstat (limited to 'localserver/initdb.sh')
-rwxr-xr-xlocalserver/initdb.sh18
1 files changed, 18 insertions, 0 deletions
diff --git a/localserver/initdb.sh b/localserver/initdb.sh
new file mode 100755
index 0000000..82f9257
--- /dev/null
+++ b/localserver/initdb.sh
@@ -0,0 +1,18 @@
+#!/bin/bash
+
+cd ../../server-data/sql-files
+
+echo Creating db and user...
+echo Enter mysql root password:
+mysql --force -u root -p <./init.sql
+
+export CMD="mysql -u evol -pevol evol"
+
+echo Creating tables...
+$CMD <main.sql
+$CMD <mob_skill_db.sql
+$CMD <mob_skill_db2.sql
+$CMD <logs.sql
+$CMD <item_db_re.sql
+$CMD <mob_db_re.sql
+$CMD <mob_skill_db_re.sql