Blindly throw some more indexes on pokemon_moves.
authorEevee <git@veekun.com>
Wed, 26 May 2010 05:40:30 +0000 (22:40 -0700)
committerEevee <git@veekun.com>
Wed, 2 Jun 2010 07:17:26 +0000 (00:17 -0700)
pokedex/db/tables.py

index 8bd9c90..cc68c5f 100644 (file)
@@ -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'