Add stripped nick to the players table to support future search implementation.
authorantzucaro <azucaro@gmail.com>
Wed, 16 Nov 2011 01:00:05 +0000 (20:00 -0500)
committerantzucaro <azucaro@gmail.com>
Wed, 16 Nov 2011 01:00:05 +0000 (20:00 -0500)
tables/players.tab

index 4e4e2d4..b51fb33 100644 (file)
@@ -2,6 +2,7 @@ CREATE TABLE xonstat.players
 (
   player_id serial NOT NULL,
   nick character varying(128),
+  stripped_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)