--- /dev/null
+id,name,description
+1,Level up,Learned when a Pokémon reaches a certain level.
+2,Egg,"Appears on a newly-hatched Pokémon, if the mother had the same move."
+3,Tutor,Can be taught at any time by an NPC.
+4,Machine,Can be taught at any time by using a TM or HM.
+5,Stadium: Surfing Pikachu,"Learned when a non-rental Pikachu helps beat Prime Cup Master Ball R-2. It must participate in every battle, and you must win with no continues."
+6,Volt Tackle Pichu,Appears on a Pichu whose mother was holding a Light Ball. The father cannot be Ditto.
+7,Colosseum: Purification,Appears on a Shadow Pokémon as it becomes increasingly purified.
+8,XD: Shadow,Appears on a Snatched Shadow Pokémon.
+9,XD: Purification,Appears on a Shadow Pokémon as it becomes increasingly purified.
item_id = Column(Integer, ForeignKey('items.id'), primary_key=True, nullable=False, autoincrement=False)
rarity = Column(Integer, nullable=False)
+class PokemonMove(TableBase):
+ __tablename__ = 'pokemon_moves'
+ pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
+ 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)
+ order = Column(Integer, nullable=True)
+
+class PokemonMoveMethod(TableBase):
+ __tablename__ = 'pokemon_move_methods'
+ id = Column(Integer, primary_key=True, nullable=False, autoincrement=False)
+ name = Column(Unicode(64), nullable=False)
+ description = Column(Unicode(255), nullable=False)
+
class PokemonName(TableBase):
__tablename__ = 'pokemon_names'
pokemon_id = Column(Integer, ForeignKey('pokemon.id'), primary_key=True, nullable=False, autoincrement=False)
uselist=False))
PokemonFormSprite.pokemon = relation(Pokemon, backref='form_sprites')
+PokemonMove.pokemon = relation(Pokemon, backref='pokemon_moves')
+PokemonMove.version_group = relation(VersionGroup)
+PokemonMove.move = relation(Move, backref='pokemon_moves')
+PokemonMove.method = relation(PokemonMoveMethod)
+
PokemonName.language = relation(Language)
PokemonStat.stat = relation(Stat)
Version.generation = relation(Generation, secondary=VersionGroup.__table__,
backref='versions')
+Version.version_group = relation(VersionGroup, backref='versions')