Add a new table for player skills.

[xonotic/xonstatdb.git] / scripts / gen_partitions.shl

diff --git a/scripts/gen_partitions.shl b/scripts/gen_partitions.shl
index 4a767424c825e1d46eb7b7145c9b8f68280ace9f..a189064003c7b571937433273cb600a672dbf76d 100755 (executable)
--- a/scripts/gen_partitions.shl
+++ b/scripts/gen_partitions.shl
@@ -37,7 +37,7 @@ do
             printf "ALTER TABLE %s_%s%s ADD PRIMARY KEY USING INDEX %s_%s%s_pk;\n" $table $year $qtr $table $year $qtr
         fi
         
-        if [[ $table = "player_game_stats" || $table = "player_weapon_stats" ]]
+        if [[ $table = "player_game_stats" || $table = "player_weapon_stats" || $table = "player_game_nonparticipants" ]]
         then
             printf "CREATE INDEX %s_%s%s_ix002 on %s_%s%s(game_id);\n" $table $year $qtr $table $year $qtr
             printf "CREATE INDEX %s_%s%s_ix003 on %s_%s%s(player_id);\n" $table $year $qtr $table $year $qtr
@@ -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