From: Eevee <git@veekun.com>
Date: Wed, 26 May 2010 05:40:30 +0000 (-0700)
Subject: Blindly throw some more indexes on pokemon_moves.
X-Git-Tag: veekun-promotions/2010060201~5
X-Git-Url: http://git.veekun.com/zzz-pokedex.git/commitdiff_plain/2335f5758bca22ecac9d4e2bd179145949494e79?ds=sidebyside

Blindly throw some more indexes on pokemon_moves.
---

diff --git a/pokedex/db/tables.py b/pokedex/db/tables.py
index 8bd9c90..cc68c5f 100644
--- a/pokedex/db/tables.py
+++ b/pokedex/db/tables.py
@@ -571,8 +571,8 @@ class PokemonMove(TableBase):
     version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False, autoincrement=False)
     move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False, index=True)
     pokemon_move_method_id = Column(Integer, ForeignKey('pokemon_move_methods.id'), primary_key=True, nullable=False, autoincrement=False)
-    level = Column(Integer, primary_key=True, nullable=True, autoincrement=False)
-    order = Column(Integer, nullable=True)
+    level = Column(Integer, primary_key=True, nullable=True, autoincrement=False, index=True)
+    order = Column(Integer, nullable=True, index=True)
 
 class PokemonMoveMethod(TableBase):
     __tablename__ = 'pokemon_move_methods'