From 639e74cc10e6800002e7c071e9bef6f296708c65 Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Thu, 24 Jan 2013 22:28:22 -0500 Subject: [PATCH] Modify column structure for better reuse. --- tables/player_game_stats.tab | 8 ++++---- 1 file changed, 4 insertions(+), 4 deletions(-) diff --git a/tables/player_game_stats.tab b/tables/player_game_stats.tab index 90fd7ba..e72e4d6 100755 --- a/tables/player_game_stats.tab +++ b/tables/player_game_stats.tab @@ -13,22 +13,22 @@ CREATE TABLE xonstat.player_game_stats suicides integer, score integer, "time" interval, - held interval, captures integer, pickups integer, drops integer, "returns" integer, collects integer, destroys integer, - destroys_holding_key integer, pushes integer, - pushed integer, carrier_frags integer, elo_delta numeric, - fastest_cap interval, + fastest interval, avg_latency numeric, teamrank integer, scoreboardpos integer, + laps integer, + revivals integer, + lives integer, create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'), CONSTRAINT player_game_stats_pk PRIMARY KEY (player_game_stat_id), CONSTRAINT player_game_stats_fk001 FOREIGN KEY (player_id) -- 2.39.2