X-Git-Url: http://de.git.xonotic.org/?a=blobdiff_plain;f=tables%2Fplayer_game_stats.tab;h=e72e4d6b190c9c9192e8922eb27f6b8444e5d458;hb=0f02546e71dc762deada44f7475c0b05e5fcbec8;hp=90fd7bae9a434b36760255cb023237b9eb1ee0fb;hpb=faeb4ae30efba69dd79dfab45b3a8c139ec9ccaa;p=xonotic%2Fxonstatdb.git 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)