Add team_game_stats to the mix.
authorAnt Zucaro <azucaro@gmail.com>
Sun, 30 Nov 2014 13:22:47 +0000 (08:22 -0500)
committerAnt Zucaro <azucaro@gmail.com>
Sun, 30 Nov 2014 13:22:47 +0000 (08:22 -0500)
scripts/gen_partitions.shl

index 963f829..5c47605 100755 (executable)
@@ -35,6 +35,11 @@ do
             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
         fi
+
+        if [[ $table = "team_game_stats" ]]
+        then
+            printf "CREATE INDEX %s_%s%s_ix002 on %s_%s%s(game_id);\n" $table $year $qtr $table $year $qtr
+        fi
         printf "\n"
     done
 done