From e10c05a77923093aa2be00b9ca6e5976ca9951e6 Mon Sep 17 00:00:00 2001
From: Stefan Beller <stefanbeller@googlemail.com>
Date: Sat, 30 Apr 2011 14:26:50 +0200
Subject: README: add section for inital db setup

---
 README | 14 ++++++++++++--
 1 file changed, 12 insertions(+), 2 deletions(-)

(limited to 'README')

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';"
+
-- 
cgit