From: Ant Zucaro <azucaro@gmail.com>
Date: Tue, 26 Jan 2016 14:42:25 +0000 (-0500)
Subject: Consolidate indexes for the games table.
X-Git-Url: http://git.xonotic.org/?p=xonotic%2Fxonstatdb.git;a=commitdiff_plain;h=53141a09143ceb6625324f2d9873783f1ffee0be

Consolidate indexes for the games table.
---

diff --git a/scripts/gen_partitions.shl b/scripts/gen_partitions.shl
index 4a76742..1b68000 100755
--- a/scripts/gen_partitions.shl
+++ b/scripts/gen_partitions.shl
@@ -48,11 +48,6 @@ do
             printf "CREATE INDEX %s_%s%s_ix002 on %s_%s%s(game_id);\n" $table $year $qtr $table $year $qtr
         fi
 
-        if [[ $table = "games" ]]
-        then
-            printf "CREATE INDEX %s_%s%s_ix002 on %s_%s%s using gin(players);\n" $table $year $qtr $table $year $qtr
-        fi
-
         printf "\n"
     done
 done