From 24ed61a3c1384196d46201fd119497393fadeaff Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Thu, 6 Oct 2011 13:06:14 -0400 Subject: [PATCH] Make schema creation clear. Create pgplsql language. --- README | 21 ++++++++++++--------- 1 file changed, 12 insertions(+), 9 deletions(-) diff --git a/README b/README index 1a591bb..e5ea23e 100644 --- a/README +++ b/README @@ -17,21 +17,24 @@ Next, create the database itself: 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; -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. -- 2.39.2