summaryrefslogtreecommitdiffstats
path: root/README
diff options
context:
space:
mode:
authorStefan Beller <stefanbeller@googlemail.com>2011-04-30 14:26:50 +0200
committerStefan Beller <stefanbeller@googlemail.com>2011-08-10 21:37:12 +0200
commite10c05a77923093aa2be00b9ca6e5976ca9951e6 (patch)
treeb9d41fac5d8057cded60b6a595089a99d6666a57 /README
parent38eb4fa16f9ac0775bb4cab968c13ef594d355e1 (diff)
downloadmanaserv-e10c05a77923093aa2be00b9ca6e5976ca9951e6.tar.gz
manaserv-e10c05a77923093aa2be00b9ca6e5976ca9951e6.tar.xz
manaserv-e10c05a77923093aa2be00b9ca6e5976ca9951e6.zip
README: add section for inital db setup
Diffstat (limited to 'README')
-rw-r--r--README14
1 files changed, 12 insertions, 2 deletions
diff --git a/README b/README
index c2ce655..5b316b7 100644
--- a/README
+++ b/README
@@ -75,5 +75,15 @@ Access to port "accountServerPort + 1" of the account server can be restricted
to connections from game servers only. Users do not need to access it.
-TODO: Explain about automatic first time creation of database
-TODO: Explain about setting a character to be administrator
+INITIAL DATABASE SETUP
+
+To initally setup the database run the following command:
+
+ cat src/sql/sqlite/createTables.sql | sqlite3 mana.db
+
+This will generate a database called mana.db according to the needs of the server.
+
+For making a player admin do:
+
+ sqlite3 mana.db "UPDATE mana_accounts SET level=255 WHERE username='MyAccount';"
+