From 7effe59bc36f2c6ad41711e37ab6d2ce36d86eea Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Thu, 7 Jul 2011 15:44:36 -0400 Subject: [PATCH] Remove stat type column, as we only care about scoreboard stats. --- tables/player_game_stats.tab | 3 +-- 1 file changed, 1 insertion(+), 2 deletions(-) diff --git a/tables/player_game_stats.tab b/tables/player_game_stats.tab index 7071388..0ac34ba 100644 --- a/tables/player_game_stats.tab +++ b/tables/player_game_stats.tab @@ -3,7 +3,6 @@ CREATE TABLE xonstat.player_game_stats player_game_stat_id bigserial NOT NULL, player_id integer NOT NULL, game_id bigint NOT NULL, - stat_type character varying(1), nick character varying(64), team integer, "rank" integer, @@ -32,7 +31,7 @@ CREATE TABLE xonstat.player_game_stats CONSTRAINT player_game_stats_fk002 FOREIGN KEY (game_id) REFERENCES xonstat.games (game_id) MATCH SIMPLE ON UPDATE NO ACTION ON DELETE NO ACTION, - CONSTRAINT player_game_stats_uk001 UNIQUE (player_id, game_id, stat_type) + CONSTRAINT player_game_stats_uk001 UNIQUE (player_id, game_id) ) WITH ( OIDS=FALSE -- 2.39.2