From: Ant Zucaro Date: Thu, 23 May 2013 00:58:09 +0000 (-0400) Subject: Add rounds, caps fields. X-Git-Url: https://git.xonotic.org/?p=xonotic%2Fxonstatdb.git;a=commitdiff_plain;h=87bc9655e83f2dace3c41058db2ab09119356e43 Add rounds, caps fields. --- diff --git a/tables/team_game_stats.tab b/tables/team_game_stats.tab index 77c2c17..a8e0275 100755 --- a/tables/team_game_stats.tab +++ b/tables/team_game_stats.tab @@ -4,6 +4,8 @@ CREATE TABLE xonstat.team_game_stats game_id bigint NOT NULL, team integer NOT NULL, score integer, + rounds integer, + caps integer, create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'), CONSTRAINT team_game_stats_pk PRIMARY KEY (team_game_stat_id), CONSTRAINT team_game_stats_uk001 UNIQUE (game_id, team),