PokeAPI
Tracking Pokemon ability changes / additions throughout each generation
There's two way's to handle this, so bringing this up for discussion.
- Adding column
changed_in_version_group_idinpokemon_abilities - Adding a whole new file
pokemon_abilities_changelog
Option one has the easiest maintainability, with the most complex for parsing and displaying the current gen's abilities if that's all you care about. Option two separates changes in each pokemon's abilities in each version, but will need to be updated at unpredictable intervals whenever changes are made to a pokemon's ability.
Overall option two is probably the cleanest, but it should allow for you to pull each "ability set" a pokemon has in each version.
Once a format for this has been agreed upon, I will push a PR with with this.
pokemon_abilities_changelog
Structure and example below.
id,pokemon_id,ability_id,is_hidden,slot_changed_in_version_group_id
# Volt Absorb Raikou
XX,243,10,1,3,11
XX,243,10,1,3,14
XX,243,10,1,3,15
XX,243,10,1,3,16
# Levitate Gengar
XX,94,26,0,1,3
XX,94,26,0,1,4
XX,94,26,0,1,5
XX,94,26,0,1,6
XX,94,26,0,1,7
XX,94,26,0,1,88
XX,94,26,0,1,9
XX,94,26,0,1,10
XX,94,26,0,1,11
XX,94,26,0,1,12
XX,94,26,0,1,13
XX,94,26,0,1,14
XX,94,26,0,1,15
XX,94,26,0,1,16
# Flash Fire Entei
XX,244,18,1,3,11
XX,244,18,1,3,14
XX,244,18,1,3,15
XX,244,18,1,3,16
# Water Absorb Suicune
XX,245,11,1,3,11
XX,245,11,1,3,14
XX,245,11,1,3,15
XX,245,11,1,3,16
# Lightning Rod Zapdos
XX,145,31,1,3,11
XX,145,31,1,3,14
# Quick Feet Venipede
XX,543,95,1,3,11
XX,543,95,1,3,14
# Quick Feet Whirlipede
XX,544,95,1,3,11
XX,544,95,1,3,14
# Quick Feet Scolipede
XX,545,95,1,3,11
XX,545,95,1,3,14
# Shadow Tag Litwick
XX,607,23,1,3,11
XX,607,23,1,3,14
# Shadow Tag Lampent
XX,608,23,1,3,11
XX,608,23,1,3,14
# Shadow Tag Chandelure
XX,609,23,1,3,11
XX,609,23,1,3,14
We already have some changelog tables. Currently anyway there's not many contributors
This would be partially addressed by this PR, but with a more simple dataset #848
