Allow up to 128 characters in the player nick

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

diff --git a/tables/player_game_stats.tab b/tables/player_game_stats.tab
index d7ec40ef17512576ff6b0cc501cd7cc146eb8413..947e0723333b9ba50bc4057eb6f2ca890e287497 100644 (file)
--- a/tables/player_game_stats.tab
+++ b/tables/player_game_stats.tab
@@ -3,9 +3,10 @@ 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),
+  nick character varying(128),
   team integer,
+  "rank" integer,
+  alivetime interval,
   kills integer,
   deaths integer,
   suicides integer,
@@ -29,8 +30,7 @@ CREATE TABLE xonstat.player_game_stats
       ON UPDATE NO ACTION ON DELETE NO ACTION,
   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)
+      ON UPDATE NO ACTION ON DELETE NO ACTION
 )
 WITH (
   OIDS=FALSE