From: Zhorken Date: Tue, 4 May 2010 06:03:01 +0000 (-0400) Subject: Added ability flavour text. #62 X-Git-Tag: veekun-promotions/2010050901~8 X-Git-Url: http://git.veekun.com/zzz-pokedex.git/commitdiff_plain/056c835e4b25e784d75ea37e0c7484508f0f0470 Added ability flavour text. #62 We had D/P flavour text in the abilities table already, but I didn't entirely trust it, so I reripped it along with the rest when I moved flavour text into its own table. And we didn't actually use the D/P text anywhere, so I'm just going to pretend that it is entirely new. --- diff --git a/pokedex/data/csv/ability_flavor_text.csv b/pokedex/data/csv/ability_flavor_text.csv new file mode 100644 index 0000000..46c2936 --- /dev/null +++ b/pokedex/data/csv/ability_flavor_text.csv @@ -0,0 +1,967 @@ +ability_id,version_group_id,flavor_text +1,5,Helps repel wild POKéMON. +1,6,Helps repel wild POKéMON. +1,7,Helps repel wild POKéMON. +1,8,"The stench helps keep +wild Pokémon away." +1,9,"The stench helps keep +wild Pokémon away." +1,10,"The stench helps keep +wild Pokémon away." +2,5,Summons rain in battle. +2,6,Summons rain in battle. +2,7,Summons rain in battle. +2,8,"The Pokémon makes it rain +if it appears in battle." +2,9,"The Pokémon makes it rain +if it appears in battle." +2,10,"The Pokémon makes it rain +if it appears in battle." +3,5,Gradually boosts SPEED. +3,6,Gradually boosts SPEED. +3,7,Gradually boosts SPEED. +3,8,"The Pokémon’s Speed stat +is gradually boosted." +3,9,"The Pokémon’s Speed stat +is gradually boosted." +3,10,"Its Speed stat is +gradually boosted." +4,5,Blocks critical hits. +4,6,Blocks critical hits. +4,7,Blocks critical hits. +4,8,"The Pokémon is protected +against critical hits." +4,9,"The Pokémon is protected +against critical hits." +4,10,"The Pokémon is protected +against critical hits." +5,5,Negates 1-hit KO attacks. +5,6,Negates 1-hit KO attacks. +5,7,Negates 1-hit KO attacks. +5,8,"The Pokémon is protected +against 1-hit KO attacks." +5,9,"The Pokémon is protected +against 1-hit KO attacks." +5,10,"It is protected against +1-hit KO attacks." +6,5,Prevents self-destruction. +6,6,Prevents self-destruction. +6,7,Prevents self-destruction. +6,8,"Prevents combatants from +self destructing." +6,9,"Prevents combatants from +self destructing." +6,10,"Prevents combatants +from self-destructing." +7,5,Prevents paralysis. +7,6,Prevents paralysis. +7,7,Prevents paralysis. +7,8,"The Pokémon is protected +from paralysis." +7,9,"The Pokémon is protected +from paralysis." +7,10,"The Pokémon is protected +from paralysis." +8,5,Ups evasion in a sandstorm. +8,6,Ups evasion in a sandstorm. +8,7,Ups evasion in a sandstorm. +8,8,"Boosts the Pokémon’s +evasion in a sandstorm." +8,9,"Boosts the Pokémon’s +evasion in a sandstorm." +8,10,"Boosts the Pokémon’s +evasion in a sandstorm." +9,5,Paralyzes on contact. +9,6,Paralyzes on contact. +9,7,Paralyzes on contact. +9,8,"Contact with the Pokémon +may cause paralysis." +9,9,"Contact with the Pokémon +may cause paralysis." +9,10,"Contact with the Pokémon +may cause paralysis." +10,5,Turns electricity into HP. +10,6,Turns electricity into HP. +10,7,Turns electricity into HP. +10,8,"Restores HP if hit by an +Electric-type move." +10,9,"Restores HP if hit by an +Electric-type move." +10,10,"Restores HP if hit by an +Electric-type move." +11,5,Changes water into HP. +11,6,Changes water into HP. +11,7,Changes water into HP. +11,8,"Restores HP if hit by a +Water-type move." +11,9,"Restores HP if hit by a +Water-type move." +11,10,"Restores HP if hit by a +Water-type move." +12,5,Prevents attraction. +12,6,Prevents attraction. +12,7,Prevents attraction. +12,8,"Prevents the Pokémon +from becoming infatuated." +12,9,"Prevents the Pokémon +from becoming infatuated." +12,10,"Prevents it from +becoming infatuated." +13,5,Negates weather effects. +13,6,Negates weather effects. +13,7,Negates weather effects. +13,8,"Eliminates the effects of +weather." +13,9,"Eliminates the effects of +weather." +13,10,"Eliminates the effects of +weather." +14,5,Raises accuracy. +14,6,Raises accuracy. +14,7,Raises accuracy. +14,8,"The Pokémon’s accuracy is +boosted." +14,9,"The Pokémon’s accuracy is +boosted." +14,10,"The Pokémon’s accuracy +is boosted." +15,5,Prevents sleep. +15,6,Prevents sleep. +15,7,Prevents sleep. +15,8,"Prevents the Pokémon +from falling asleep." +15,9,"Prevents the Pokémon +from falling asleep." +15,10,"Prevents the Pokémon +from falling asleep." +16,5,Changes type to foe’s move. +16,6,Changes type to foe’s move. +16,7,Changes type to foe’s move. +16,8,"Changes the Pokémon’s +type to the foe’s move." +16,9,"Changes the Pokémon’s +type to the foe’s move." +16,10,"Changes the Pokémon’s +type to the foe’s move." +17,5,Prevents poisoning. +17,6,Prevents poisoning. +17,7,Prevents poisoning. +17,8,"Prevents the Pokémon +from getting poisoned." +17,9,"Prevents the Pokémon +from getting poisoned." +17,10,"Prevents the Pokémon +from getting poisoned." +18,5,Powers up if hit by fire. +18,6,Powers up if hit by fire. +18,7,Powers up if hit by fire. +18,8,"Powers up Fire-type moves +if hit by a fire move." +18,9,"Powers up Fire-type moves +if hit by a fire move." +18,10,"It powers up Fire-type +moves if it’s hit by one." +19,5,Prevents added effects. +19,6,Prevents added effects. +19,7,Prevents added effects. +19,8,"Blocks the added effects +of attacks taken." +19,9,"Blocks the added effects +of attacks taken." +19,10,"Blocks the added effects +of attacks taken." +20,5,Prevents confusion. +20,6,Prevents confusion. +20,7,Prevents confusion. +20,8,"Prevents the Pokémon +from becoming confused." +20,9,"Prevents the Pokémon +from becoming confused." +20,10,"Prevents the Pokémon +from becoming confused." +21,5,Firmly anchors the body. +21,6,Firmly anchors the body. +21,7,Firmly anchors the body. +21,8,"Negates moves that +force switching out." +21,9,"Negates moves that +force switching out." +21,10,"Negates foes’ moves that +force switching out." +22,5,Lowers the foe’s ATTACK. +22,6,Lowers the foe’s ATTACK. +22,7,Lowers the foe’s ATTACK. +22,8,"Lowers the foe’s Attack +stat." +22,9,"Lowers the foe’s Attack +stat." +22,10,"Lowers the foe’s +Attack stat." +23,5,Prevents the foe’s escape. +23,6,Prevents the foe’s escape. +23,7,Prevents the foe’s escape. +23,8,"Prevents the foe from +escaping." +23,9,"Prevents the foe from +escaping." +23,10,"Prevents the foe from +escaping." +24,5,Hurts to touch. +24,6,Hurts to touch. +24,7,Hurts to touch. +24,8,"Inflicts damage to the +foe on contact." +24,9,"Inflicts damage to the +foe on contact." +24,10,"Inflicts damage to the +foe on contact." +25,5,“Super effective” hits. +25,6,“Super effective” hits. +25,7,“Super effective” hits. +25,8,"Only supereffective +moves will hit." +25,9,"Only supereffective +moves will hit." +25,10,"Only supereffective +moves will hit." +26,5,Not hit by GROUND attacks. +26,6,Not hit by GROUND attacks. +26,7,Not hit by GROUND attacks. +26,8,"Gives full immunity to all +Ground-type moves." +26,9,"Gives full immunity to all +Ground-type moves." +26,10,"Gives full immunity to all +Ground-type moves." +27,5,Leaves spores on contact. +27,6,Leaves spores on contact. +27,7,Leaves spores on contact. +27,8,"Contact may paralyze, +poison, or cause sleep." +27,9,"Contact may paralyze, +poison, or cause sleep." +27,10,"Contact may paralyze, +poison, or cause sleep." +28,5,Passes on status problems. +28,6,Passes on status problems. +28,7,Passes on status problems. +28,8,"Passes on a burn, poison, +or paralysis to the foe." +28,9,"Passes on a burn, poison, +or paralysis to the foe." +28,10,"Passes a burn, poison, +or paralysis to the foe." +29,5,Prevents ability reduction. +29,6,Prevents ability reduction. +29,7,Prevents ability reduction. +29,8,"Prevents the Pokémon’s +stats from being lowered." +29,9,"Prevents the Pokémon’s +stats from being lowered." +29,10,"Prevents its stats from +being lowered." +30,5,Heals upon switching out. +30,6,Heals upon switching out. +30,7,Heals upon switching out. +30,8,"All status problems are +healed upon switching out." +30,9,"All status problems are +healed upon switching out." +30,10,"All status problems heal +when it switches out." +31,5,Draws electrical moves. +31,6,Draws electrical moves. +31,7,Draws electrical moves. +31,8,"The Pokémon draws in all +Electric-type moves." +31,9,"The Pokémon draws in all +Electric-type moves." +31,10,"The Pokémon draws in all +Electric-type moves." +32,5,Promotes added effects. +32,6,Promotes added effects. +32,7,Promotes added effects. +32,8,"Boosts the likelihood of +added effects appearing." +32,9,"Boosts the likelihood of +added effects appearing." +32,10,"Boosts the likelihood of +added effects appearing." +33,5,Raises SPEED in rain. +33,6,Raises SPEED in rain. +33,7,Raises SPEED in rain. +33,8,"Boosts the Pokémon’s +Speed in rain." +33,9,"Boosts the Pokémon’s +Speed in rain." +33,10,"Boosts the Pokémon’s +Speed in rain." +34,5,Raises SPEED in sunshine. +34,6,Raises SPEED in sunshine. +34,7,Raises SPEED in sunshine. +34,8,"Boosts the Pokémon’s +Speed in sunshine." +34,9,"Boosts the Pokémon’s +Speed in sunshine." +34,10,"Boosts the Pokémon’s +Speed in sunshine." +35,5,Encounter rate increases. +35,6,Encounter rate increases. +35,7,Encounter rate increases. +35,8,"Raises the likelihood of +meeting wild Pokémon." +35,9,"Raises the likelihood of +meeting wild Pokémon." +35,10,"Raises the likelihood of +meeting wild Pokémon." +36,5,Copies special ability. +36,6,Copies special ability. +36,7,Copies special ability. +36,8,"The Pokémon copies the +foe’s ability." +36,9,"The Pokémon copies the +foe’s ability." +36,10,"The Pokémon copies the +foe’s ability." +37,5,Raises ATTACK. +37,6,Raises ATTACK. +37,7,Raises ATTACK. +37,8,"Raises the Pokémon’s +Attack stat." +37,9,"Raises the Pokémon’s +Attack stat." +37,10,"Raises the Pokémon’s +Attack stat." +38,5,Poisons foe on contact. +38,6,Poisons foe on contact. +38,7,Poisons foe on contact. +38,8,"Contact with the Pokémon +may poison the foe." +38,9,"Contact with the Pokémon +may poison the foe." +38,10,"Contact with the Pokémon +may poison the foe." +39,5,Prevents flinching. +39,6,Prevents flinching. +39,7,Prevents flinching. +39,8,"The Pokémon is protected +from flinching." +39,9,"The Pokémon is protected +from flinching." +39,10,"The Pokémon is protected +from flinching." +40,5,Prevents freezing. +40,6,Prevents freezing. +40,7,Prevents freezing. +40,8,"Prevents the Pokémon +from becoming frozen." +40,9,"Prevents the Pokémon +from becoming frozen." +40,10,"Prevents the Pokémon +from becoming frozen." +41,5,Prevents burns. +41,6,Prevents burns. +41,7,Prevents burns. +41,8,"Prevents the Pokémon +from getting a burn." +41,9,"Prevents the Pokémon +from getting a burn." +41,10,"Prevents the Pokémon +from getting a burn." +42,5,Traps STEEL-type POKéMON. +42,6,Traps STEEL-type POKéMON. +42,7,Traps STEEL-type POKéMON. +42,8,"Prevents Steel-type +Pokémon from escaping." +42,9,"Prevents Steel-type +Pokémon from escaping." +42,10,"Prevents Steel-type +Pokémon from escaping." +43,5,Avoids sound-based moves. +43,6,Avoids sound-based moves. +43,7,Avoids sound-based moves. +43,8,"Gives full immunity to all +sound-based moves." +43,9,"Gives full immunity to all +sound-based moves." +43,10,"Gives full immunity to all +sound-based moves." +44,5,Slight HP recovery in rain. +44,6,Slight HP recovery in rain. +44,7,Slight HP recovery in rain. +44,8,"The Pokémon gradually +recovers HP in rain." +44,9,"The Pokémon gradually +recovers HP in rain." +44,10,"The Pokémon gradually +recovers HP in rain." +45,5,Summons a sandstorm. +45,6,Summons a sandstorm. +45,7,Summons a sandstorm. +45,8,"The Pokémon summons a +sandstorm in battle." +45,9,"The Pokémon summons a +sandstorm in battle." +45,10,"The Pokémon summons a +sandstorm in battle." +46,5,Raises foe’s PP usage. +46,6,Raises foe’s PP usage. +46,7,Raises foe’s PP usage. +46,8,"The Pokémon raises the +foe’s PP usage." +46,9,"The Pokémon raises the +foe’s PP usage." +46,10,"The Pokémon raises the +foe’s PP usage." +47,5,Heat-and-cold protection. +47,6,Heat-and-cold protection. +47,7,Heat-and-cold protection. +47,8,"Raises resistance to Fire- +and Ice-type moves." +47,9,"Raises resistance to Fire- +and Ice-type moves." +47,10,"Ups resistance to Fire- +and Ice-type moves." +48,5,Awakens quickly from sleep. +48,6,Awakens quickly from sleep. +48,7,Awakens quickly from sleep. +48,8,"The Pokémon awakens +quickly from sleep." +48,9,"The Pokémon awakens +quickly from sleep." +48,10,"The Pokémon awakens +quickly from sleep." +49,5,Burns the foe on contact. +49,6,Burns the foe on contact. +49,7,Burns the foe on contact. +49,8,"Contact with the Pokémon +may burn the foe." +49,9,"Contact with the Pokémon +may burn the foe." +49,10,"Contact with the Pokémon +may burn the foe." +50,5,Makes escaping easier. +50,6,Makes escaping easier. +50,7,Makes escaping easier. +50,8,"Enables sure getaway from +wild Pokémon." +50,9,"Enables sure getaway from +wild Pokémon." +50,10,"Enables sure getaway +from wild Pokémon." +51,5,Prevents loss of accuracy. +51,6,Prevents loss of accuracy. +51,7,Prevents loss of accuracy. +51,8,"Prevents the Pokémon +from losing accuracy." +51,9,"Prevents the Pokémon +from losing accuracy." +51,10,"Prevents the Pokémon +from losing accuracy." +52,5,Prevents ATTACK reduction. +52,6,Prevents ATTACK reduction. +52,7,Prevents ATTACK reduction. +52,8,"Prevents the Attack stat +from being lowered." +52,9,"Prevents the Attack stat +from being lowered." +52,10,"Prevents the Attack +stat from being lowered." +53,5,May pick up items. +53,6,May pick up items. +53,7,May pick up items. +53,8,"The Pokémon may pick up +items." +53,9,"The Pokémon may pick up +items." +53,10,"The Pokémon may +pick up items." +54,5,Moves only every two turns. +54,6,Moves only every two turns. +54,7,Moves only every two turns. +54,8,"The Pokémon can’t attack +on consecutive turns." +54,9,"The Pokémon can’t attack +on consecutive turns." +54,10,"Pokémon can’t attack +on consecutive turns." +55,5,Trades accuracy for power. +55,6,Trades accuracy for power. +55,7,Trades accuracy for power. +55,8,"Boosts the Attack stat, +but lowers accuracy." +55,9,"Boosts the Attack stat, +but lowers accuracy." +55,10,"Boosts the Attack stat, +but lowers accuracy." +56,5,Infatuates on contact. +56,6,Infatuates on contact. +56,7,Infatuates on contact. +56,8,"Contact with the Pokémon +may cause infatuation." +56,9,"Contact with the Pokémon +may cause infatuation." +56,10,"Contact with the Pokémon +may cause infatuation." +57,5,Powers up with MINUS. +57,6,Powers up with MINUS. +57,7,Powers up with MINUS. +57,8,"Boosts Sp. Atk if another +Pokémon has Minus." +57,9,"Boosts Sp. Atk if another +Pokémon has Minus." +57,10,"Ups Sp. Atk if another +Pokémon has Minus." +58,5,Powers up with PLUS. +58,6,Powers up with PLUS. +58,7,Powers up with PLUS. +58,8,"Boosts Sp. Atk if another +Pokémon has Plus." +58,9,"Boosts Sp. Atk if another +Pokémon has Plus." +58,10,"Ups Sp. Atk if another +Pokémon has Plus." +59,5,Changes with the weather. +59,6,Changes with the weather. +59,7,Changes with the weather. +59,8,"CASTFORM transforms with +the weather." +59,9,"CASTFORM transforms with +the weather." +59,10,"CASTFORM transforms with +the weather." +60,5,Prevents item theft. +60,6,Prevents item theft. +60,7,Prevents item theft. +60,8,"Protects the Pokémon +from item theft." +60,9,"Protects the Pokémon +from item theft." +60,10,"Protects the Pokémon +from item theft." +61,5,Heals the body by shedding. +61,6,Heals the body by shedding. +61,7,Heals the body by shedding. +61,8,"The Pokémon may heal its +own status problems." +61,9,"The Pokémon may heal its +own status problems." +61,10,"The Pokémon may heal its +own status problems." +62,5,Ups ATTACK if suffering. +62,6,Ups ATTACK if suffering. +62,7,Ups ATTACK if suffering. +62,8,"Boosts Attack if there is +a status problem." +62,9,"Boosts Attack if there is +a status problem." +62,10,"Boosts Attack if there is +a status problem." +63,5,Ups DEFENSE if suffering. +63,6,Ups DEFENSE if suffering. +63,7,Ups DEFENSE if suffering. +63,8,"Boosts Defense if there is +a status problem." +63,9,"Boosts Defense if there is +a status problem." +63,10,"Ups Defense if there is +a status problem." +64,5,Draining causes injury. +64,6,Draining causes injury. +64,7,Draining causes injury. +64,8,"Inflicts damage on foes +using any draining move." +64,9,"Inflicts damage on foes +using any draining move." +64,10,"Inflicts damage on foes +using any draining move." +65,5,Ups GRASS moves in a pinch. +65,6,Ups GRASS moves in a pinch. +65,7,Ups GRASS moves in a pinch. +65,8,"Powers up Grass-type +moves in a pinch." +65,9,"Powers up Grass-type +moves in a pinch." +65,10,"Powers up Grass-type +moves in a pinch." +66,5,Ups FIRE moves in a pinch. +66,6,Ups FIRE moves in a pinch. +66,7,Ups FIRE moves in a pinch. +66,8,"Powers up Fire-type +moves in a pinch." +66,9,"Powers up Fire-type +moves in a pinch." +66,10,"Powers up Fire-type +moves in a pinch." +67,5,Ups WATER moves in a pinch. +67,6,Ups WATER moves in a pinch. +67,7,Ups WATER moves in a pinch. +67,8,"Powers up Water-type +moves in a pinch." +67,9,"Powers up Water-type +moves in a pinch." +67,10,"Powers up Water-type +moves in a pinch." +68,5,Ups BUG moves in a pinch. +68,6,Ups BUG moves in a pinch. +68,7,Ups BUG moves in a pinch. +68,8,"Powers up Bug-type +moves in a pinch." +68,9,"Powers up Bug-type +moves in a pinch." +68,10,"Powers up Bug-type +moves in a pinch." +69,5,Prevents recoil damage. +69,6,Prevents recoil damage. +69,7,Prevents recoil damage. +69,8,"Protects the Pokémon +from recoil damage." +69,9,"Protects the Pokémon +from recoil damage." +69,10,"Protects the Pokémon +from recoil damage." +70,5,Summons sunlight in battle. +70,6,Summons sunlight in battle. +70,7,Summons sunlight in battle. +70,8,"The Pokémon makes it +sunny if it is in battle." +70,9,"The Pokémon makes it +sunny if it is in battle." +70,10,"The Pokémon makes it +sunny if it is in battle." +71,5,Prevents fleeing. +71,6,Prevents fleeing. +71,7,Prevents fleeing. +71,8,"Prevents the foe from +fleeing." +71,9,"Prevents the foe from +fleeing." +71,10,"Prevents the foe from +fleeing." +72,5,Prevents sleep. +72,6,Prevents sleep. +72,7,Prevents sleep. +72,8,"Prevents the Pokémon +from falling asleep." +72,9,"Prevents the Pokémon +from falling asleep." +72,10,"Prevents the Pokémon +from falling asleep." +73,5,Prevents ability reduction. +73,6,Prevents ability reduction. +73,7,Prevents ability reduction. +73,8,"Prevents the Pokémon’s +stats from being lowered." +73,9,"Prevents the Pokémon’s +stats from being lowered." +73,10,"Prevents its stats from +being lowered." +74,5,Raises ATTACK. +74,6,Raises ATTACK. +74,7,Raises ATTACK. +74,8,"Boosts the power of +physical attacks." +74,9,"Boosts the power of +physical attacks." +74,10,"Boosts the power of +physical attacks." +75,5,Blocks critical hits. +75,6,Blocks critical hits. +75,7,Blocks critical hits. +75,8,"The Pokémon is protected +against critical hits." +75,9,"The Pokémon is protected +against critical hits." +75,10,"The Pokémon is protected +against critical hits." +76,5,Negates weather effects. +76,6,Negates weather effects. +76,7,Negates weather effects. +76,8,"Eliminates the effects of +weather." +76,9,"Eliminates the effects of +weather." +76,10,"Eliminates the effects of +weather." +77,8,"Raises evasion if the +Pokémon is confused." +77,9,"Raises evasion if the +Pokémon is confused." +77,10,"Raises evasion if the +Pokémon is confused." +78,8,"Raises Speed if hit by an +Electric-type move." +78,9,"Raises Speed if hit by an +Electric-type move." +78,10,"Raises Speed if hit by an +Electric-type move." +79,8,"Raises Attack if the foe +is of the same gender." +79,9,"Raises Attack if the foe +is of the same gender." +79,10,"Raises Attack if the foe +is of the same gender." +80,8,"Raises Speed each time +the Pokémon flinches." +80,9,"Raises Speed each time +the Pokémon flinches." +80,10,"Raises Speed each time +the Pokémon flinches." +81,8,"Raises evasion in a +hailstorm." +81,9,"Raises evasion in a +hailstorm." +81,10,"Raises evasion in a +hailstorm." +82,8,"Encourages the early use +of a held Berry." +82,9,"Encourages the early use +of a held Berry." +82,10,"Encourages the early use +of a held Berry." +83,8,"Raises Attack upon taking +a critical hit." +83,9,"Raises Attack upon taking +a critical hit." +83,10,"Raises Attack upon +taking a critical hit." +84,8,"Raises Speed if a held +item is used." +84,9,"Raises Speed if a held +item is used." +84,10,"Raises Speed if a held +item is used." +85,8,"Weakens the power of +Fire-type moves." +85,9,"Weakens the power of +Fire-type moves." +85,10,"Weakens the power of +Fire-type moves." +86,8,"The Pokémon is prone to +wild stat changes." +86,9,"The Pokémon is prone to +wild stat changes." +86,10,"The Pokémon is prone to +wild stat changes." +87,8,"Reduces HP if it is hot. +Water restores HP." +87,9,"Reduces HP if it is hot. +Water restores HP." +87,10,"Reduces HP if it is hot. +Water restores HP." +88,8,"Adjusts power according +to the foe’s ability." +88,9,"Adjusts power according +to the foe’s ability." +88,10,"Adjusts power according +to the foe’s ability." +89,8,"Boosts the power of +punching moves." +89,9,"Boosts the power of +punching moves." +89,10,"Boosts the power of +punching moves." +90,8,"Restores HP if the +Pokémon is poisoned." +90,9,"Restores HP if the +Pokémon is poisoned." +90,10,"Restores HP if the +Pokémon is poisoned." +91,8,"Powers up moves of the +same type." +91,9,"Powers up moves of the +same type." +91,10,"Powers up moves of the +same type." +92,8,"Increases the frequency +of multi-strike moves." +92,9,"Increases the frequency +of multi-strike moves." +92,10,"Increases the frequency +of multi-strike moves." +93,8,"Heals status problems if +it is raining." +93,9,"Heals status problems if +it is raining." +93,10,"Heals status problems if +it is raining." +94,8,"Boosts Sp. Atk, but +lowers HP in sunshine." +94,9,"Boosts Sp. Atk, but +lowers HP in sunshine." +94,10,"Boosts Sp. Atk, but +lowers HP in sunshine." +95,8,"Boosts Speed if there is a +status problem." +95,9,"Boosts Speed if there is a +status problem." +95,10,"Boosts Speed if there is +a status problem." +96,8,"All the Pokémon’s moves +become the Normal type." +96,9,"All the Pokémon’s moves +become the Normal type." +96,10,"All the Pokémon’s moves +become the Normal type." +97,8,"Powers up moves if they +become critical hits." +97,9,"Powers up moves if they +become critical hits." +97,10,"Powers up moves if they +become critical hits." +98,8,"The Pokémon only takes +damage from attacks." +98,9,"The Pokémon only takes +damage from attacks." +98,10,"The Pokémon only takes +damage from attacks." +99,8,"Ensures the Pokémon and +its foe’s attacks land." +99,9,"Ensures the Pokémon and +its foe’s attacks land." +99,10,"Ensures both Pokémon’s +and foe’s attacks land." +100,8,"The Pokémon moves after +even slower foes." +100,9,"The Pokémon moves after +even slower foes." +100,10,"The Pokémon moves after +even slower foes." +101,8,"Powers up the Pokémon’s +weaker moves." +101,9,"Powers up the Pokémon’s +weaker moves." +101,10,"Powers up the Pokémon’s +weaker moves." +102,8,"Prevents status problems +in sunny weather." +102,9,"Prevents status problems +in sunny weather." +102,10,"Prevents problems with +status in sunny weather." +103,8,"The Pokémon can’t use +any held items." +103,9,"The Pokémon can’t use +any held items." +103,10,"The Pokémon can’t use +any held items." +104,8,"Moves can be used +regardless of abilities." +104,9,"Moves can be used +regardless of abilities." +104,10,"Moves can be used +regardless of abilities." +105,8,"Heightens the critical-hit +ratios of moves." +105,9,"Heightens the critical-hit +ratios of moves." +105,10,"Heightens the critical- +hit ratios of moves." +106,8,"Damages the foe landing +the finishing hit." +106,9,"Damages the foe landing +the finishing hit." +106,10,"Damages the foe landing +the finishing hit." +107,8,"Senses the foe’s +dangerous moves." +107,9,"Senses the foe’s +dangerous moves." +107,10,"Senses the foe’s +dangerous moves." +108,8,"Determines what moves +the foe has." +108,9,"Determines what moves +the foe has." +108,10,"Determines what moves +the foe has." +109,8,"Ignores any change in +ability by the foe." +109,9,"Ignores any change in +ability by the foe." +109,10,"Ignores any change in +ability by the foe." +110,8,"Powers up “not very +effective” moves." +110,9,"Powers up “not very +effective” moves." +110,10,"Powers up “not very +effective” moves." +111,8,"Powers down super- +effective moves." +111,9,"Powers down super- +effective moves." +111,10,"Reduces damage from +supereffective attacks." +112,8,"Temporarily halves Attack +and Speed." +112,9,"Temporarily halves Attack +and Speed." +112,10,"Temporarily halves +Attack and Speed." +113,8,"Enables moves to hit +Ghost-type foes." +113,9,"Enables moves to hit +Ghost-type foes." +113,10,"Enables moves to hit +Ghost-type foes." +114,8,"The Pokémon draws in all +Water-type moves." +114,9,"The Pokémon draws in all +Water-type moves." +114,10,"The Pokémon draws in all +Water-type moves." +115,8,"The Pokémon regains HP in +a hailstorm." +115,9,"The Pokémon regains HP in +a hailstorm." +115,10,"The Pokémon regains HP in +a hailstorm." +116,8,"Powers down super- +effective moves." +116,9,"Powers down super- +effective moves." +116,10,"Reduces damage from +supereffective attacks" +117,8,"The Pokémon summons a +hailstorm in battle." +117,9,"The Pokémon summons a +hailstorm in battle." +117,10,"The Pokémon summons a +hailstorm in battle." +118,8,"The Pokémon may gather +Honey from somewhere." +118,9,"The Pokémon may gather +Honey from somewhere." +118,10,"The Pokémon may gather +Honey from somewhere." +119,8,"The Pokémon can check +the foe’s held item." +119,9,"The Pokémon can check +the foe’s held item." +119,10,"The Pokémon can check +the foe’s held item." +120,8,"Powers up moves that +have recoil damage." +120,9,"Powers up moves that +have recoil damage." +120,10,"Powers up moves that +have recoil damage." +121,8,"Changes type to match +the held Plate." +121,9,"Changes type to match +the held Plate." +121,10,"Changes type to match +the held Plate." +122,8,"Powers up party Pokémon +when it is sunny." +122,9,"Powers up party Pokémon +when it is sunny." +122,10,"Powers up party Pokémon +when it is sunny." +123,8,"Reduces a sleeping foe’s +HP." +123,9,"Reduces a sleeping foe’s +HP." +123,10,"Reduces a sleeping +foe’s HP." diff --git a/pokedex/db/tables.py b/pokedex/db/tables.py index f366192..8ae80d8 100644 --- a/pokedex/db/tables.py +++ b/pokedex/db/tables.py @@ -20,6 +20,11 @@ class Ability(TableBase): generation_id = Column(Integer, ForeignKey('generations.id'), nullable=False) effect = Column(rst.RstTextColumn(5120), nullable=False) short_effect = Column(rst.RstTextColumn(255), nullable=False) + +class AbilityFlavorText(TableBase): + __tablename__ = 'ability_flavor_text' + ability_id = Column(Integer, ForeignKey('abilities.id'), primary_key=True, nullable=False, autoincrement=False) + version_group_id = Column(Integer, ForeignKey('version_groups.id'), primary_key=True, nullable=False, autoincrement=False) flavor_text = Column(Unicode(64), nullable=False) class Berry(TableBase): @@ -630,8 +635,11 @@ class Version(TableBase): ### Relations down here, to avoid ordering problems +Ability.flavor_text = relation(AbilityFlavorText, order_by=AbilityFlavorText.version_group_id, backref='abilities') Ability.generation = relation(Generation, backref='abilities') +AbilityFlavorText.version_group = relation(VersionGroup) + Berry.berry_firmness = relation(BerryFirmness, backref='berries') Berry.firmness = association_proxy('berry_firmness', 'name') Berry.flavors = relation(BerryFlavor, order_by=BerryFlavor.contest_type_id, backref='berry')