Add teamrank and scoreboardpos fields.

diff --git a/tables/player_game_stats.tab b/tables/player_game_stats.tab
index 9a9f681a5d91f3bb7239a7db0c37dc9a87ebce8c..90fd7bae9a434b36760255cb023237b9eb1ee0fb 100755 (executable)
--- a/tables/player_game_stats.tab
+++ b/tables/player_game_stats.tab
@@ -27,6 +27,8 @@ CREATE TABLE xonstat.player_game_stats
   elo_delta numeric,
   fastest_cap interval,
   avg_latency numeric,
   elo_delta numeric,
   fastest_cap interval,
   avg_latency numeric,

+  teamrank integer,
+  scoreboardpos 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)
   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)