Make schema creation clear. Create pgplsql language.

diff --git a/README b/README
index 1a591bb431f90d82e390da90c6e36684795af8dd..e5ea23ef6a3ecce47668e706289e9eabab8bf8be 100644 (file)
--- a/README
+++ b/README
@@ -17,21 +17,24 @@ Next, create the database itself:
         OWNER=xonstat
         CONNECTION LIMIT=-1;
 
         OWNER=xonstat
         CONNECTION LIMIT=-1;
 

+Next, log into the newly created database using the user account
+you just created:
+
+    psql -U xonstat xonstatdb
+

 Create the schema in which all of the xonstat tables will reside:
 
     CREATE SCHEMA xonstat
        AUTHORIZATION xonstat;
 
 Create the schema in which all of the xonstat tables will reside:
 
     CREATE SCHEMA xonstat
        AUTHORIZATION xonstat;
 

-Navigate to the 'build' directory. Log into the database as the 
-admin user created above and issue the following to build the
-initial tables:
+Create the pgplsql language:

 
 

-    \i build/build_full.sql
+    CREATE LANGUAGE pgplsql;

 
 

-    *Note: You will see a lot of NOTICE messages. This is normal.
+Back in the command shell, navigate to the 'build' directory. 
+Log into the database as the admin user created above and issue 
+the following to build the initial tables:

 
 

-TODO:
+    \i build/build_full.sql

 
 

-- Define indexes
-- Audit report SQL to verify index usage 
-- ? Partition games, player_game_stats, player_weapon_stats via inheritance
+    *Note: You will see a lot of NOTICE messages. This is normal.