From adf231067d2e0d040fd00289c991ecdec2b49693 Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Sun, 6 Mar 2011 16:21:01 -0500 Subject: [PATCH] Update README --- README | 11 +++++------ 1 file changed, 5 insertions(+), 6 deletions(-) diff --git a/README b/README index e2d44b7..1a591bb 100644 --- a/README +++ b/README @@ -19,20 +19,19 @@ Next, create the database itself: Create the schema in which all of the xonstat tables will reside: -CREATE SCHEMA xonstat + 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: - TODO + \i build/build_full.sql + + *Note: You will see a lot of NOTICE messages. This is normal. TODO: - Define indexes - Audit report SQL to verify index usage -- Review datatypes to ensure no truncation occurs. -- Review plurality in table names -- Review for usage of serial datatypes in foreign keys -- Review regular serials vs bigserials +- ? Partition games, player_game_stats, player_weapon_stats via inheritance -- 2.39.2