From 7effe59bc36f2c6ad41711e37ab6d2ce36d86eea Mon Sep 17 00:00:00 2001
From: Ant Zucaro <azucaro@gmail.com>
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.5