From: Ant Zucaro <azucaro@gmail.com>
Date: Sun, 20 Nov 2011 21:59:06 +0000 (-0500)
Subject: Revert the functional index on players table. It won't be used with LIKE query anyway.
X-Git-Url: http://de.git.xonotic.org/?p=xonotic%2Fxonstatdb.git;a=commitdiff_plain;h=d07f8c25994aeee3531b4c08573ffd27f60258f8;hp=a7cb6092f505c520ef4e83de0824a818df79d124

Revert the functional index on players table. It won't be used with LIKE query anyway.
---

diff --git a/tables/players.tab b/tables/players.tab
index db38ce4..b75a53a 100644
--- a/tables/players.tab
+++ b/tables/players.tab
@@ -11,5 +11,3 @@ WITH (
   OIDS=FALSE
 );
 ALTER TABLE xonstat.players OWNER TO xonstat;
-
-CREATE INDEX players_ix01 ON players ((upper(stripped_nick));