From 71e6138dde16af73702835e066e7fe4ae6a8283c Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Mon, 17 Oct 2011 11:25:04 -0400 Subject: [PATCH] Allow up to 128 characters in the player nick --- tables/player_game_stats.tab | 2 +- tables/player_nicks.tab | 4 ++-- tables/players.tab | 2 +- 3 files changed, 4 insertions(+), 4 deletions(-) diff --git a/tables/player_game_stats.tab b/tables/player_game_stats.tab index 840520f..947e072 100644 --- a/tables/player_game_stats.tab +++ b/tables/player_game_stats.tab @@ -3,7 +3,7 @@ CREATE TABLE xonstat.player_game_stats player_game_stat_id bigserial NOT NULL, player_id integer NOT NULL, game_id bigint NOT NULL, - nick character varying(64), + nick character varying(128), team integer, "rank" integer, alivetime interval, diff --git a/tables/player_nicks.tab b/tables/player_nicks.tab index 7e7ed6f..d80c8dd 100644 --- a/tables/player_nicks.tab +++ b/tables/player_nicks.tab @@ -1,8 +1,8 @@ CREATE TABLE xonstat.player_nicks ( player_id integer NOT NULL, - stripped_nick character varying(64) NOT NULL, - nick character varying(64) NOT NULL, + stripped_nick character varying(128) NOT NULL, + nick character varying(128) NOT NULL, create_dt timestamp without time zone NOT NULL DEFAULT now(), CONSTRAINT player_nicks_pk PRIMARY KEY (player_id, stripped_nick), CONSTRAINT player_nicks_fk01 FOREIGN KEY (player_id) diff --git a/tables/players.tab b/tables/players.tab index ec98486..4e4e2d4 100644 --- a/tables/players.tab +++ b/tables/players.tab @@ -1,7 +1,7 @@ CREATE TABLE xonstat.players ( player_id serial NOT NULL, - nick character varying(64), + nick character varying(128), "location" character varying(100), create_dt timestamp without time zone NOT NULL DEFAULT now(), CONSTRAINT players_pk PRIMARY KEY (player_id) -- 2.39.2