Add stripped nick to the players table to support future search implementation.

diff --git a/tables/players.tab b/tables/players.tab
index 4e4e2d452f4c41dbc10b836275a7eb20d69cae42..b51fb3380e60bc59789d1548d05abdde8d5d6fda 100644 (file)
--- a/tables/players.tab
+++ b/tables/players.tab
@@ -2,6 +2,7 @@ CREATE TABLE xonstat.players
 (
   player_id serial NOT NULL,
   nick character varying(128),
 (
   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)
   "location" character varying(100),
   create_dt timestamp without time zone NOT NULL DEFAULT now(),
   CONSTRAINT players_pk PRIMARY KEY (player_id)