Add port to servers table

[xonotic/xonstatdb.git] / tables / player_game_stats.tab

diff --git a/tables/player_game_stats.tab b/tables/player_game_stats.tab
index e09f351da60d3a511eae2ee69a66247d0d439017..e72e4d6b190c9c9192e8922eb27f6b8444e5d458 100755 (executable)
--- a/tables/player_game_stats.tab
+++ b/tables/player_game_stats.tab
@@ -13,17 +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 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)
@@ -42,7 +47,6 @@ CREATE INDEX player_game_stats_ix02 on player_game_stats(game_id);
 CREATE INDEX player_game_stats_ix03 on player_game_stats(player_id);
 ALTER TABLE xonstat.player_game_stats OWNER TO xonstat;
 
-
 CREATE TABLE xonstat.player_game_stats_2011Q2 (
     CHECK ( create_dt >= DATE '2011-04-01' AND create_dt < DATE '2011-07-01' ) 
 ) INHERITS (player_game_stats);
@@ -131,4 +135,3 @@ CREATE INDEX player_game_stats_2013Q2_ix01 on player_game_stats_2013Q2(create_dt
 CREATE INDEX player_game_stats_2013Q2_ix02 on player_game_stats_2013Q2(game_id);
 CREATE INDEX player_game_stats_2013Q2_ix03 on player_game_stats_2013Q2(player_id);
 ALTER TABLE xonstat.player_game_stats_2013Q2 OWNER TO xonstat;
-