Add B/W move metadata. #389
authorEevee <git@veekun.com>
Sun, 6 Mar 2011 08:00:40 +0000 (00:00 -0800)
committerEevee <git@veekun.com>
Wed, 9 Mar 2011 06:28:33 +0000 (22:28 -0800)
pokedex/data/csv/move_meta.csv [new file with mode: 0644]
pokedex/data/csv/move_meta_ailments.csv [new file with mode: 0644]
pokedex/data/csv/move_meta_categories.csv [new file with mode: 0644]
pokedex/data/csv/move_meta_stat_changes.csv [new file with mode: 0644]
pokedex/data/csv/stats.csv
pokedex/db/tables.py

diff --git a/pokedex/data/csv/move_meta.csv b/pokedex/data/csv/move_meta.csv
new file mode 100644 (file)
index 0000000..cef5e5d
--- /dev/null
@@ -0,0 +1,560 @@
+move_id,meta_category_id,meta_ailment_id,min_hits,max_hits,min_turns,max_turns,recoil,healing,crit_rate,ailment_chance,flinch_chance,stat_chance
+1,0,0,,,,,0,0,0,0,0,0
+2,0,0,,,,,0,0,1,0,0,0
+3,0,0,2,5,,,0,0,0,0,0,0
+4,0,0,2,5,,,0,0,0,0,0,0
+5,0,0,,,,,0,0,0,0,0,0
+6,0,0,,,,,0,0,0,0,0,0
+7,4,4,,,,,0,0,0,10,0,0
+8,4,3,,,,,0,0,0,10,0,0
+9,4,1,,,,,0,0,0,10,0,0
+10,0,0,,,,,0,0,0,0,0,0
+11,0,0,,,,,0,0,0,0,0,0
+12,9,0,,,,,0,0,0,0,0,0
+13,0,0,,,,,0,0,1,0,0,0
+14,2,0,,,,,0,0,0,0,0,0
+15,0,0,,,,,0,0,0,0,0,0
+16,0,0,,,,,0,0,0,0,0,0
+17,0,0,,,,,0,0,0,0,0,0
+18,12,0,,,,,0,0,0,0,0,0
+19,0,0,,,,,0,0,0,0,0,0
+20,4,8,,,5,6,0,0,0,100,0,0
+21,0,0,,,,,0,0,0,0,0,0
+22,0,0,,,,,0,0,0,0,0,0
+23,0,0,,,,,0,0,0,0,30,0
+24,0,0,2,2,,,0,0,0,0,0,0
+25,0,0,,,,,0,0,0,0,0,0
+26,0,0,,,,,0,0,0,0,0,0
+27,0,0,,,,,0,0,0,0,30,0
+28,2,0,,,,,0,0,0,0,0,0
+29,0,0,,,,,0,0,0,0,30,0
+30,0,0,,,,,0,0,0,0,0,0
+31,0,0,2,5,,,0,0,0,0,0,0
+32,9,0,,,,,0,0,0,0,0,0
+33,0,0,,,,,0,0,0,0,0,0
+34,4,1,,,,,0,0,0,30,0,0
+35,4,8,,,5,6,0,0,0,100,0,0
+36,0,0,,,,,-25,0,0,0,0,0
+37,0,0,,,,,0,0,0,0,0,0
+38,0,0,,,,,-33,0,0,0,0,0
+39,2,0,,,,,0,0,0,0,0,0
+40,4,5,,,,,0,0,0,30,0,0
+41,4,5,2,2,,,0,0,0,20,0,0
+42,0,0,2,5,,,0,0,0,0,0,0
+43,2,0,,,,,0,0,0,0,0,0
+44,0,0,,,,,0,0,0,0,30,0
+45,2,0,,,,,0,0,0,0,0,0
+46,12,0,,,,,0,0,0,0,0,0
+47,1,2,,,2,4,0,0,0,0,0,0
+48,1,6,,,2,5,0,0,0,0,0,0
+49,0,0,,,,,0,0,0,0,0,0
+50,13,13,,,4,4,0,0,0,0,0,0
+51,6,0,,,,,0,0,0,0,0,10
+52,4,4,,,,,0,0,0,10,0,0
+53,4,4,,,,,0,0,0,10,0,0
+54,11,0,,,,,0,0,0,0,0,0
+55,0,0,,,,,0,0,0,0,0,0
+56,0,0,,,,,0,0,0,0,0,0
+57,0,0,,,,,0,0,0,0,0,0
+58,4,3,,,,,0,0,0,10,0,0
+59,4,3,,,,,0,0,0,10,0,0
+60,4,6,,,2,5,0,0,0,10,0,0
+61,6,0,,,,,0,0,0,0,0,10
+62,6,0,,,,,0,0,0,0,0,10
+63,0,0,,,,,0,0,0,0,0,0
+64,0,0,,,,,0,0,0,0,0,0
+65,0,0,,,,,0,0,0,0,0,0
+66,0,0,,,,,-25,0,0,0,0,0
+67,0,0,,,,,0,0,0,0,0,0
+68,0,0,,,,,0,0,0,0,0,0
+69,0,0,,,,,0,0,0,0,0,0
+70,0,0,,,,,0,0,0,0,0,0
+71,8,0,,,,,50,0,0,0,0,0
+72,8,0,,,,,50,0,0,0,0,0
+73,1,18,,,,,0,0,0,0,0,0
+74,2,0,,,,,0,0,0,0,0,0
+75,0,0,,,,,0,0,1,0,0,0
+76,0,0,,,,,0,0,0,0,0,0
+77,1,5,,,,,0,0,0,0,0,0
+78,1,1,,,,,0,0,0,0,0,0
+79,1,2,,,2,4,0,0,0,0,0,0
+80,0,0,,,,,0,0,0,0,0,0
+81,2,0,,,,,0,0,0,0,0,0
+82,0,0,,,,,0,0,0,0,0,0
+83,4,8,,,5,6,0,0,0,100,0,0
+84,4,1,,,,,0,0,0,10,0,0
+85,4,1,,,,,0,0,0,10,0,0
+86,1,1,,,,,0,0,0,0,0,0
+87,4,1,,,,,0,0,0,30,0,0
+88,0,0,,,,,0,0,0,0,0,0
+89,0,0,,,,,0,0,0,0,0,0
+90,9,0,,,,,0,0,0,0,0,0
+91,0,0,,,,,0,0,0,0,0,0
+92,1,5,,,15,15,0,0,0,0,0,0
+93,4,6,,,2,5,0,0,0,10,0,0
+94,6,0,,,,,0,0,0,0,0,10
+95,1,2,,,2,4,0,0,0,0,0,0
+96,2,0,,,,,0,0,0,0,0,0
+97,2,0,,,,,0,0,0,0,0,0
+98,0,0,,,,,0,0,0,0,0,0
+99,0,0,,,,,0,0,0,0,0,0
+100,13,0,,,,,0,0,0,0,0,0
+101,0,0,,,,,0,0,0,0,0,0
+102,13,0,,,,,0,0,0,0,0,0
+103,2,0,,,,,0,0,0,0,0,0
+104,2,0,,,,,0,0,0,0,0,0
+105,3,0,,,,,0,50,0,0,0,0
+106,2,0,,,,,0,0,0,0,0,0
+107,2,0,,,,,0,0,0,0,0,0
+108,2,0,,,,,0,0,0,0,0,0
+109,1,6,,,2,5,0,0,0,0,0,0
+110,2,0,,,,,0,0,0,0,0,0
+111,2,0,,,,,0,0,0,0,0,0
+112,2,0,,,,,0,0,0,0,0,0
+113,11,0,,,,,0,0,0,0,0,0
+114,10,0,,,,,0,0,0,0,0,0
+115,11,0,,,,,0,0,0,0,0,0
+116,13,0,,,,,0,0,0,0,0,0
+117,0,0,,,,,0,0,0,0,0,0
+118,13,0,,,,,0,0,0,0,0,0
+119,13,0,,,,,0,0,0,0,0,0
+120,0,0,,,,,0,0,0,0,0,0
+121,0,0,,,,,0,0,0,0,0,0
+122,4,1,,,,,0,0,0,30,0,0
+123,4,5,,,,,0,0,0,40,0,0
+124,4,5,,,,,0,0,0,30,0,0
+125,0,0,,,,,0,0,0,0,10,0
+126,4,4,,,,,0,0,0,10,0,0
+127,0,0,,,,,0,0,0,0,20,0
+128,4,8,,,5,6,0,0,0,100,0,0
+129,0,0,,,,,0,0,0,0,0,0
+130,0,0,,,,,0,0,0,100,0,0
+131,0,0,2,5,,,0,0,0,0,0,0
+132,6,0,,,,,0,0,0,0,0,10
+133,2,0,,,,,0,0,0,0,0,0
+134,2,0,,,,,0,0,0,0,0,0
+135,3,0,,,,,0,50,0,0,0,0
+136,0,0,,,,,0,0,0,0,0,0
+137,1,1,,,,,0,0,0,0,0,0
+138,8,0,,,,,50,0,0,0,0,0
+139,1,5,,,,,0,0,0,0,0,0
+140,0,0,2,5,,,0,0,0,0,0,0
+141,8,0,,,,,50,0,0,0,0,0
+142,1,2,,,2,4,0,0,0,0,0,0
+143,0,0,,,,,0,0,1,0,30,0
+144,13,0,,,,,0,0,0,0,0,0
+145,6,0,,,,,0,0,0,0,0,10
+146,4,6,,,2,5,0,0,0,20,0,0
+147,1,2,,,2,4,0,0,0,0,0,0
+148,2,0,,,,,0,0,0,0,0,0
+149,0,0,,,,,0,0,0,0,0,0
+150,13,0,,,,,0,0,0,0,0,0
+151,2,0,,,,,0,0,0,0,0,0
+152,0,0,,,,,0,0,1,0,0,0
+153,0,0,,,,,0,0,0,0,0,0
+154,0,0,2,5,,,0,0,0,0,0,0
+155,0,0,2,2,,,0,0,0,0,0,0
+156,13,0,,,,,0,0,0,0,0,0
+157,0,0,,,,,0,0,0,0,30,0
+158,0,0,,,,,0,0,0,0,10,0
+159,2,0,,,,,0,0,0,0,0,0
+160,13,0,,,,,0,0,0,0,0,0
+161,4,-1,,,,,0,0,0,20,0,0
+162,0,0,,,,,0,0,0,0,0,0
+163,0,0,,,,,0,0,1,0,0,0
+164,13,0,,,,,0,0,0,0,0,0
+165,0,0,,,,,0,-25,0,0,0,0
+166,13,0,,,,,0,0,0,0,0,0
+167,0,0,3,3,,,0,0,0,0,0,0
+168,0,0,,,,,0,0,0,0,0,0
+169,13,0,,,,,0,0,0,0,0,0
+170,13,0,,,,,0,0,0,0,0,0
+171,1,9,,,,,0,0,0,0,0,0
+172,4,4,,,,,0,0,0,10,0,0
+173,0,0,,,,,0,0,0,0,30,0
+174,13,0,,,,,0,0,0,0,0,0
+175,0,0,,,,,0,0,0,0,0,0
+176,13,0,,,,,0,0,0,0,0,0
+177,0,0,,,,,0,0,1,0,0,0
+178,2,0,,,,,0,0,0,0,0,0
+179,0,0,,,,,0,0,0,0,0,0
+180,13,0,,,,,0,0,0,0,0,0
+181,4,3,,,,,0,0,0,10,0,0
+182,13,0,,,,,0,0,0,0,0,0
+183,0,0,,,,,0,0,0,0,0,0
+184,2,0,,,,,0,0,0,0,0,0
+185,0,0,,,,,0,0,0,0,0,0
+186,1,6,,,2,5,0,0,0,0,0,0
+187,13,0,,,,,0,0,0,0,0,0
+188,4,5,,,,,0,0,0,30,0,0
+189,6,0,,,,,0,0,0,0,0,100
+190,6,0,,,,,0,0,0,0,0,50
+191,11,0,,,,,0,0,0,0,0,0
+192,4,1,,,,,0,0,0,100,0,0
+193,1,17,,,,,0,0,0,0,0,0
+194,13,0,,,,,0,0,0,0,0,0
+195,1,20,,,4,4,0,0,0,0,0,0
+196,6,0,,,,,0,0,0,0,0,100
+197,13,0,,,,,0,0,0,0,0,0
+198,0,0,2,5,,,0,0,0,0,0,0
+199,13,0,,,,,0,0,0,0,0,0
+200,0,0,,,,,0,0,0,0,0,0
+201,10,0,,,,,0,0,0,0,0,0
+202,8,0,,,,,50,0,0,0,0,0
+203,13,0,,,,,0,0,0,0,0,0
+204,2,0,,,,,0,0,0,0,0,0
+205,0,0,,,,,0,0,0,0,0,0
+206,0,0,,,,,0,0,0,0,0,0
+207,5,6,,,2,5,0,0,0,0,0,0
+208,3,0,,,,,0,50,0,0,0,0
+209,4,1,,,,,0,0,0,30,0,0
+210,0,0,,,,,0,0,0,0,0,0
+211,7,0,,,,,0,0,0,0,0,10
+212,13,0,,,,,0,0,0,0,0,0
+213,1,7,,,,,0,0,0,0,0,0
+214,13,0,,,,,0,0,0,0,0,0
+215,13,0,,,,,0,0,0,0,0,0
+216,0,0,,,,,0,0,0,0,0,0
+217,0,0,,,,,0,0,0,0,0,0
+218,0,0,,,,,0,0,0,0,0,0
+219,11,0,,,,,0,0,0,0,0,0
+220,13,0,,,,,0,0,0,0,0,0
+221,4,4,,,,,0,0,0,50,0,0
+222,0,0,,,,,0,0,0,0,0,0
+223,4,6,,,2,5,0,0,0,100,0,0
+224,0,0,,,,,0,0,0,0,0,0
+225,4,1,,,,,0,0,0,30,0,0
+226,13,0,,,,,0,0,0,0,0,0
+227,13,0,,,,,0,0,0,0,0,0
+228,0,0,,,,,0,0,0,0,0,0
+229,0,0,,,,,0,0,0,0,0,0
+230,2,0,,,,,0,0,0,0,0,0
+231,6,0,,,,,0,0,0,0,0,30
+232,7,0,,,,,0,0,0,0,0,10
+233,0,0,,,,,0,0,0,0,0,0
+234,3,0,,,,,0,50,0,0,0,0
+235,3,0,,,,,0,50,0,0,0,0
+236,3,0,,,,,0,50,0,0,0,0
+237,0,0,,,,,0,0,0,0,0,0
+238,0,0,,,,,0,0,1,0,0,0
+239,0,0,,,,,0,0,0,0,20,0
+240,10,0,,,,,0,0,0,0,0,0
+241,10,0,,,,,0,0,0,0,0,0
+242,6,0,,,,,0,0,0,0,0,20
+243,0,0,,,,,0,0,0,0,0,0
+244,13,0,,,,,0,0,0,0,0,0
+245,0,0,,,,,0,0,0,0,0,0
+246,7,0,,,,,0,0,0,0,0,10
+247,6,0,,,,,0,0,0,0,0,20
+248,13,0,,,,,0,0,0,0,0,0
+249,6,0,,,,,0,0,0,0,0,50
+250,4,8,,,5,6,0,0,0,100,0,0
+251,0,0,6,6,,,0,0,0,0,0,0
+252,0,0,,,,,0,0,0,0,100,0
+253,0,0,,,,,0,0,0,0,0,0
+254,13,0,,,,,0,0,0,0,0,0
+255,0,0,,,,,0,0,0,0,0,0
+256,3,0,,,,,0,25,0,0,0,0
+257,4,4,,,,,0,0,0,10,0,0
+258,10,0,,,,,0,0,0,0,0,0
+259,1,12,,,,,0,0,0,0,0,0
+260,5,6,,,2,5,0,0,0,0,0,0
+261,1,4,,,,,0,0,0,0,0,0
+262,13,0,,,,,0,0,0,0,0,0
+263,0,0,,,,,0,0,0,0,0,0
+264,0,0,,,,,0,0,0,0,0,0
+265,0,0,,,,,0,0,0,0,0,0
+266,13,0,,,,,0,0,0,0,0,0
+267,13,0,,,,,0,0,0,0,0,0
+268,2,0,,,,,0,0,0,0,0,0
+269,13,0,,,,,0,0,0,0,0,0
+270,13,0,,,,,0,0,0,0,0,0
+271,13,0,,,,,0,0,0,0,0,0
+272,13,0,,,,,0,0,0,0,0,0
+273,13,0,,,,,0,0,0,0,0,0
+274,13,0,,,,,0,0,0,0,0,0
+275,1,21,,,,,0,0,0,0,0,0
+276,7,0,,,,,0,0,0,0,0,100
+277,13,0,,,,,0,0,0,0,0,0
+278,13,0,,,,,0,0,0,0,0,0
+279,0,0,,,,,0,0,0,0,0,0
+280,0,0,,,,,0,0,0,0,0,0
+281,1,14,,,2,2,0,0,0,0,0,0
+282,0,0,,,,,0,0,0,0,0,0
+283,0,0,,,,,0,0,0,0,0,0
+284,0,0,,,,,0,0,0,0,0,0
+285,13,0,,,,,0,0,0,0,0,0
+286,13,0,,,,,0,0,0,0,0,0
+287,13,0,,,,,0,0,0,0,0,0
+288,13,0,,,,,0,0,0,0,0,0
+289,13,0,,,,,0,0,0,0,0,0
+290,0,0,,,,,0,0,0,30,0,0
+291,0,0,,,,,0,0,0,0,0,0
+292,0,0,2,5,,,0,0,0,0,0,0
+293,13,0,,,,,0,0,0,0,0,0
+294,2,0,,,,,0,0,0,0,0,0
+295,6,0,,,,,0,0,0,0,0,50
+296,6,0,,,,,0,0,0,0,0,50
+297,2,0,,,,,0,0,0,0,0,0
+298,1,6,,,2,5,0,0,0,0,0,0
+299,4,4,,,,,0,0,1,10,0,0
+300,10,0,,,,,0,0,0,0,0,0
+301,0,0,,,,,0,0,0,0,0,0
+302,0,0,,,,,0,0,0,0,30,0
+303,3,0,,,,,0,50,0,0,0,0
+304,0,0,,,,,0,0,0,0,0,0
+305,4,5,,,15,15,0,0,0,30,0,0
+306,6,0,,,,,0,0,0,0,0,50
+307,0,0,,,,,0,0,0,0,0,0
+308,0,0,,,,,0,0,0,0,0,0
+309,7,0,,,,,0,0,0,0,0,20
+310,0,0,,,,,0,0,0,0,30,0
+311,0,0,,,,,0,0,0,0,0,0
+312,13,0,,,,,0,0,0,0,0,0
+313,2,0,,,,,0,0,0,0,0,0
+314,0,0,,,,,0,0,1,0,0,0
+315,7,0,,,,,0,0,0,0,0,100
+316,1,17,,,,,0,0,0,0,0,0
+317,6,0,,,,,0,0,0,0,0,100
+318,7,0,,,,,0,0,0,0,0,10
+319,2,0,,,,,0,0,0,0,0,0
+320,1,2,,,2,4,0,0,0,0,0,0
+321,2,0,,,,,0,0,0,0,0,0
+322,2,0,,,,,0,0,0,0,0,0
+323,0,0,,,,,0,0,0,0,0,0
+324,4,6,,,2,5,0,0,0,10,0,0
+325,0,0,,,,,0,0,0,0,0,0
+326,0,0,,,,,0,0,0,0,10,0
+327,0,0,,,,,0,0,0,0,0,0
+328,4,8,,,5,6,0,0,0,100,0,0
+329,9,0,,,,,0,0,0,0,0,0
+330,6,0,,,,,0,0,0,0,0,30
+331,0,0,2,5,,,0,0,0,0,0,0
+332,0,0,,,,,0,0,0,0,0,0
+333,0,0,2,5,,,0,0,0,0,0,0
+334,2,0,,,,,0,0,0,0,0,0
+335,13,0,,,,,0,0,0,0,0,0
+336,2,0,,,,,0,0,0,0,0,0
+337,0,0,,,,,0,0,0,0,0,0
+338,0,0,,,,,0,0,0,0,0,0
+339,2,0,,,,,0,0,0,0,0,0
+340,4,1,,,,,0,0,0,30,0,0
+341,6,0,,,,,0,0,0,0,0,100
+342,4,5,,,,,0,0,1,10,0,0
+343,0,0,,,,,0,0,0,0,0,0
+344,4,1,,,,,-33,0,0,10,0,0
+345,0,0,,,,,0,0,0,0,0,0
+346,10,0,,,,,0,0,0,0,0,0
+347,2,0,,,,,0,0,0,0,0,0
+348,0,0,,,,,0,0,1,0,0,0
+349,2,0,,,,,0,0,0,0,0,0
+350,0,0,2,5,,,0,0,0,0,0,0
+351,0,0,,,,,0,0,0,0,0,0
+352,4,6,,,2,5,0,0,0,20,0,0
+353,13,0,,,,,0,0,0,0,0,0
+354,7,0,,,,,0,0,0,0,0,100
+355,3,0,,,,,0,50,0,0,0,0
+356,10,0,,,,,0,0,0,0,0,0
+357,1,17,,,,,0,0,0,0,0,0
+358,0,0,,,,,0,0,0,0,0,0
+359,7,0,,,,,0,0,0,0,0,100
+360,0,0,,,,,0,0,0,0,0,0
+361,13,0,,,,,0,0,0,0,0,0
+362,0,0,,,,,0,0,0,0,0,0
+363,0,0,,,,,0,0,0,0,0,0
+364,0,0,,,,,0,0,0,0,0,0
+365,0,0,,,,,0,0,0,0,0,0
+366,11,0,,,,,0,0,0,0,0,0
+367,13,0,,,,,0,0,0,0,0,0
+368,0,0,,,,,0,0,0,0,0,0
+369,0,0,,,,,0,0,0,0,0,0
+370,7,0,,,,,0,0,0,0,0,100
+371,0,0,,,,,0,0,0,0,0,0
+372,0,0,,,,,0,0,0,0,0,0
+373,1,19,,,5,5,0,0,0,0,0,0
+374,0,0,,,,,0,0,0,0,0,0
+375,13,0,,,,,0,0,0,0,0,0
+376,0,0,,,,,0,0,0,0,0,0
+377,1,15,,,5,5,0,0,0,0,0,0
+378,0,0,,,,,0,0,0,0,0,0
+379,13,0,,,,,0,0,0,0,0,0
+380,13,0,,,,,0,0,0,0,0,0
+381,11,0,,,,,0,0,0,0,0,0
+382,0,0,,,,,0,0,0,0,0,0
+383,13,0,,,,,0,0,0,0,0,0
+384,13,0,,,,,0,0,0,0,0,0
+385,13,0,,,,,0,0,0,0,0,0
+386,0,0,,,,,0,0,0,0,0,0
+387,0,0,,,,,0,0,0,0,0,0
+388,13,0,,,,,0,0,0,0,0,0
+389,0,0,,,,,0,0,0,0,0,0
+390,11,0,,,,,0,0,0,0,0,0
+391,13,0,,,,,0,0,0,0,0,0
+392,13,0,,,,,0,0,0,0,0,0
+393,13,0,,,5,5,0,0,0,0,0,0
+394,4,4,,,,,-33,0,0,10,0,0
+395,4,1,,,,,0,0,0,30,0,0
+396,0,0,,,,,0,0,0,0,0,0
+397,2,0,,,,,0,0,0,0,0,0
+398,4,5,,,,,0,0,0,30,0,0
+399,0,0,,,,,0,0,0,0,20,0
+400,0,0,,,,,0,0,1,0,0,0
+401,0,0,,,,,0,0,0,0,0,0
+402,0,0,,,,,0,0,0,0,0,0
+403,0,0,,,,,0,0,0,0,30,0
+404,0,0,,,,,0,0,0,0,0,0
+405,6,0,,,,,0,0,0,0,0,10
+406,0,0,,,,,0,0,0,0,0,0
+407,0,0,,,,,0,0,0,0,20,0
+408,0,0,,,,,0,0,0,0,0,0
+409,8,0,,,,,50,0,0,0,0,0
+410,0,0,,,,,0,0,0,0,0,0
+411,6,0,,,,,0,0,0,0,0,10
+412,6,0,,,,,0,0,0,0,0,10
+413,0,0,,,,,-33,0,0,0,0,0
+414,6,0,,,,,0,0,0,0,0,10
+415,13,0,,,,,0,0,0,0,0,0
+416,0,0,,,,,0,0,0,0,0,0
+417,2,0,,,,,0,0,0,0,0,0
+418,0,0,,,,,0,0,0,0,0,0
+419,0,0,,,,,0,0,0,0,0,0
+420,0,0,,,,,0,0,0,0,0,0
+421,0,0,,,,,0,0,1,0,0,0
+422,4,1,,,,,0,0,0,10,10,0
+423,4,3,,,,,0,0,0,10,10,0
+424,4,4,,,,,0,0,0,10,10,0
+425,0,0,,,,,0,0,0,0,0,0
+426,6,0,,,,,0,0,0,0,0,30
+427,0,0,,,,,0,0,1,0,0,0
+428,0,0,,,,,0,0,0,0,20,0
+429,6,0,,,,,0,0,0,0,0,30
+430,6,0,,,,,0,0,0,0,0,10
+431,4,6,,,2,5,0,0,0,20,0,0
+432,13,0,,,,,0,0,0,0,0,0
+433,10,0,,,,,0,0,0,0,0,0
+434,7,0,,,,,0,0,0,0,0,100
+435,4,1,,,,,0,0,0,30,0,0
+436,4,4,,,,,0,0,0,30,0,0
+437,7,0,,,,,0,0,0,0,0,100
+438,0,0,,,,,0,0,0,0,0,0
+439,0,0,,,,,0,0,0,0,0,0
+440,4,5,,,,,0,0,1,10,0,0
+441,4,5,,,,,0,0,0,30,0,0
+442,0,0,,,,,0,0,0,0,30,0
+443,0,0,,,,,0,0,0,0,0,0
+444,0,0,,,,,0,0,1,0,0,0
+445,2,0,,,,,0,0,0,0,0,0
+446,11,0,,,,,0,0,0,0,0,0
+447,0,0,,,,,0,0,0,0,0,0
+448,4,6,,,2,5,0,0,0,0,0,0
+449,0,0,,,,,0,0,0,0,0,0
+450,0,0,,,,,0,0,0,0,0,0
+451,7,0,,,,,0,0,0,0,0,70
+452,0,0,,,,,-33,0,0,0,0,0
+453,0,0,,,,,0,0,0,0,0,0
+454,0,0,,,,,0,0,1,0,0,0
+455,2,0,,,,,0,0,0,0,0,0
+456,3,0,,,,,0,50,0,0,0,0
+457,0,0,,,,,-50,0,0,0,0,0
+458,0,0,2,2,,,0,0,0,0,0,0
+459,0,0,,,,,0,0,0,0,0,0
+460,0,0,,,,,0,0,1,0,0,0
+461,13,0,,,,,0,0,0,0,0,0
+462,0,0,,,,,0,0,0,0,0,0
+463,4,8,,,5,6,0,0,0,100,0,0
+464,1,2,,,2,4,0,0,0,0,0,0
+465,6,0,,,,,0,0,0,0,0,40
+466,7,0,,,,,0,0,0,10,0,10
+467,0,0,,,,,0,0,0,0,0,0
+468,2,0,,,,,0,0,0,0,0,0
+469,11,0,,,,,0,0,0,0,0,0
+470,13,0,,,,,0,0,0,0,0,0
+471,13,0,,,,,0,0,0,0,0,0
+472,10,0,,,,,0,0,0,0,0,0
+473,0,0,,,,,0,0,0,0,0,0
+474,0,0,,,,,0,0,0,0,0,0
+475,2,0,,,,,0,0,0,0,0,0
+476,13,0,,,,,0,0,0,0,0,0
+477,1,-1,,,3,3,0,0,0,0,0,0
+478,10,0,,,,,0,0,0,0,0,0
+479,0,-1,,,,,0,0,0,100,0,0
+480,0,0,,,,,0,0,6,0,0,0
+481,0,0,,,,,0,0,0,0,0,0
+482,4,5,,,,,0,0,0,10,0,0
+483,2,0,,,,,0,0,0,0,0,0
+484,0,0,,,,,0,0,0,0,0,0
+485,0,0,,,,,0,0,0,0,0,0
+486,0,0,,,,,0,0,0,0,0,0
+487,13,0,,,,,0,0,0,0,0,0
+488,7,0,,,,,0,0,0,0,0,100
+489,2,0,,,,,0,0,0,0,0,0
+490,6,0,,,,,0,0,0,0,0,100
+491,6,0,,,,,0,0,0,0,0,100
+492,0,0,,,,,0,0,0,0,0,0
+493,13,0,,,,,0,0,0,0,0,0
+494,13,0,,,,,0,0,0,0,0,0
+495,13,0,,,,,0,0,0,0,0,0
+496,0,0,,,,,0,0,0,0,0,0
+497,0,0,,,,,0,0,0,0,0,0
+498,0,0,,,,,0,0,0,0,0,0
+499,0,0,,,,,0,0,0,0,0,0
+500,0,0,,,,,0,0,0,0,0,0
+501,11,0,,,,,0,0,0,0,0,0
+502,13,0,,,,,0,0,0,0,0,0
+503,4,4,,,,,0,0,0,30,0,0
+504,13,0,,,,,0,0,0,0,0,0
+505,3,0,,,,,0,50,0,0,0,0
+506,0,0,,,,,0,0,0,0,0,0
+507,0,0,,,,,0,0,0,0,0,0
+508,2,0,,,,,0,0,0,0,0,0
+509,0,0,,,,,0,0,0,0,0,0
+510,0,0,,,,,0,0,0,0,0,0
+511,13,0,,,,,0,0,0,0,0,0
+512,0,0,,,,,0,0,0,0,0,0
+513,13,0,,,,,0,0,0,0,0,0
+514,0,0,,,,,0,0,0,0,0,0
+515,0,0,,,,,0,0,0,0,0,0
+516,13,0,,,,,0,0,0,0,0,0
+517,4,4,,,,,0,0,0,100,0,0
+518,0,0,,,,,0,0,0,0,0,0
+519,0,0,,,,,0,0,0,0,0,0
+520,0,0,,,,,0,0,0,0,0,0
+521,0,0,,,,,0,0,0,0,0,0
+522,6,0,,,,,0,0,0,0,0,100
+523,6,0,,,,,0,0,0,0,0,100
+524,0,0,,,,,0,0,6,100,0,0
+525,0,0,,,,,0,0,0,0,0,0
+526,2,0,,,,,0,0,0,0,0,0
+527,6,0,,,,,0,0,0,0,0,100
+528,0,0,,,,,-25,0,0,0,0,0
+529,0,0,,,,,0,0,1,0,0,0
+530,0,0,2,2,,,0,0,0,0,0,0
+531,0,0,,,,,0,0,0,0,30,0
+532,8,0,,,,,50,0,0,0,0,0
+533,0,0,,,,,0,0,0,0,0,0
+534,6,0,,,,,0,0,0,0,0,50
+535,0,0,,,,,0,0,0,0,0,0
+536,6,0,,,,,0,0,0,0,0,50
+537,0,0,,,,,0,0,0,0,30,0
+538,2,0,,,,,0,0,0,0,0,0
+539,6,0,,,,,0,0,0,0,0,40
+540,0,0,,,,,0,0,0,0,0,0
+541,0,0,2,5,,,0,0,0,0,0,0
+542,4,6,,,2,5,0,0,0,30,0,0
+543,0,0,,,,,-25,0,0,0,0,0
+544,0,0,2,2,,,0,0,0,0,0,0
+545,4,4,,,,,0,0,0,30,0,0
+546,0,0,,,,,0,0,0,0,0,0
+547,4,2,,,2,4,0,0,0,10,0,0
+548,0,0,,,,,0,0,0,0,0,0
+549,6,0,,,,,0,0,0,0,0,100
+550,4,1,,,,,0,0,0,20,0,0
+551,4,4,,,,,0,0,0,20,0,0
+552,7,0,,,,,0,0,0,0,0,50
+553,4,1,,,,,0,0,0,30,0,0
+554,4,4,,,,,0,0,0,30,0,0
+555,6,0,,,,,0,0,0,0,0,100
+556,0,0,,,,,0,0,0,0,30,0
+557,7,0,,,,,0,0,0,0,0,100
+558,0,0,,,,,0,0,0,0,0,0
+559,0,0,,,,,0,0,0,0,0,0
diff --git a/pokedex/data/csv/move_meta_ailments.csv b/pokedex/data/csv/move_meta_ailments.csv
new file mode 100644 (file)
index 0000000..34eb5c7
--- /dev/null
@@ -0,0 +1,21 @@
+id,name
+-1,????
+0,none
+1,Paralysis
+2,Sleep
+3,Freeze
+4,Burn
+5,Poison
+6,Confusion
+7,Infatuation
+8,Trap
+9,Nightmare
+12,Torment
+13,Disable
+14,Yawn
+15,Heal Block
+17,No type immunity
+18,Leech Seed
+19,Embargo
+20,Perish Song
+21,Ingrain
diff --git a/pokedex/data/csv/move_meta_categories.csv b/pokedex/data/csv/move_meta_categories.csv
new file mode 100644 (file)
index 0000000..b853a22
--- /dev/null
@@ -0,0 +1,15 @@
+id,description
+0,Inflicts damage
+1,No damage; inflicts status ailment
+2,No damage; lowers target's stats or raises user's stats
+3,No damage; heals the user
+4,Inflicts damage; inflicts status ailment
+5,No damage; inflicts status ailment; raises target's stats
+6,Inflicts damage; lowers target's stats
+7,Inflicts damage; raises user's stats
+8,Inflicts damage; absorbs damage done to heal the user
+9,One-hit KO
+10,Effect on the whole field
+11,Effect on one side of the field
+12,Forces target to switch out
+13,Unique effect
diff --git a/pokedex/data/csv/move_meta_stat_changes.csv b/pokedex/data/csv/move_meta_stat_changes.csv
new file mode 100644 (file)
index 0000000..a57a5e3
--- /dev/null
@@ -0,0 +1,136 @@
+move_id,stat_id,change
+14,2,2
+28,7,-1
+39,3,-1
+43,3,-1
+45,2,-1
+51,5,-1
+61,6,-1
+62,2,-1
+74,2,1
+74,4,1
+81,6,-1
+94,5,-1
+96,2,1
+97,6,2
+103,3,-2
+104,8,1
+106,3,1
+107,8,2
+108,7,-1
+110,3,1
+111,3,1
+112,3,2
+132,6,-1
+133,5,2
+134,7,-1
+145,6,-1
+148,7,-1
+151,3,2
+159,2,1
+178,6,-2
+184,6,-2
+189,7,-1
+190,7,-1
+196,6,-1
+204,2,-2
+207,2,2
+211,3,1
+230,8,-1
+231,3,-1
+232,2,1
+242,3,-1
+246,2,1
+246,3,1
+246,4,1
+246,5,1
+246,6,1
+247,5,-1
+249,3,-1
+260,4,1
+268,5,1
+276,2,-1
+276,3,-1
+294,4,3
+295,5,-1
+296,4,-1
+297,2,-2
+306,3,-1
+309,2,1
+313,5,-2
+315,4,-2
+317,6,-1
+318,2,1
+318,3,1
+318,4,1
+318,5,1
+318,6,1
+319,5,-2
+321,2,-1
+321,3,-1
+322,3,1
+322,5,1
+330,7,-1
+334,3,2
+336,2,1
+339,2,1
+339,3,1
+341,6,-1
+347,4,1
+347,5,1
+349,2,1
+349,6,1
+354,4,-2
+359,6,-1
+370,3,-1
+370,5,-1
+397,6,2
+405,5,-1
+411,5,-1
+412,5,-1
+414,5,-1
+417,4,2
+426,7,-1
+429,7,-1
+430,5,-1
+434,4,-2
+437,4,-2
+445,4,-2
+451,4,1
+455,3,1
+455,5,1
+465,5,-2
+466,2,1
+466,3,1
+466,4,1
+466,5,1
+466,6,1
+468,2,1
+468,7,1
+475,6,2
+483,4,1
+483,5,1
+483,6,1
+488,6,1
+489,2,1
+489,3,1
+489,7,1
+490,6,-1
+491,5,-2
+508,2,1
+508,6,2
+522,4,-1
+523,6,-1
+526,2,1
+526,4,1
+527,6,-1
+534,3,-1
+536,7,-1
+538,3,3
+539,7,-1
+549,6,-1
+552,4,1
+555,4,-1
+557,3,-1
+557,5,-1
+557,6,-1
index 49be037..6eb3865 100644 (file)
@@ -5,3 +5,5 @@ id,damage_class_id,name
 4,3,Special Attack
 5,3,Special Defense
 6,,Speed
+7,,accuracy
+8,,evasion
index 812fdc2..c8d48fe 100644 (file)
@@ -628,6 +628,44 @@ class MoveFlavorText(TableBase):
     flavor_text = Column(Unicode(255), nullable=False,
         info=dict(description="The English flavor text", official=True, format='gametext'))
 
+class MoveMeta(TableBase):
+    u"""Metadata for move effects, sorta-kinda ripped straight from the game"""
+    __tablename__ = 'move_meta'
+    move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
+    meta_category_id = Column(Integer, ForeignKey('move_meta_categories.id'), nullable=False)
+    meta_ailment_id = Column(Integer, ForeignKey('move_meta_ailments.id'), nullable=False)
+    min_hits = Column(Integer, nullable=True, index=True)
+    max_hits = Column(Integer, nullable=True, index=True)
+    min_turns = Column(Integer, nullable=True, index=True)
+    max_turns = Column(Integer, nullable=True, index=True)
+    recoil = Column(Integer, nullable=False, index=True)
+    healing = Column(Integer, nullable=False, index=True)
+    crit_rate = Column(Integer, nullable=False, index=True)
+    ailment_chance = Column(Integer, nullable=False, index=True)
+    flinch_chance = Column(Integer, nullable=False, index=True)
+    stat_chance = Column(Integer, nullable=False, index=True)
+
+class MoveMetaAilment(TableBase):
+    u"""Common status ailments moves can inflict on a single Pokémon, including
+    major ailments like paralysis and minor ailments like trapping.
+    """
+    __tablename__ = 'move_meta_ailments'
+    id = Column(Integer, primary_key=True, nullable=False)
+    name = Column(Unicode(24), nullable=False)
+
+class MoveMetaCategory(TableBase):
+    u"""Very general categories that loosely group move effects."""
+    __tablename__ = 'move_meta_categories'
+    id = Column(Integer, primary_key=True, nullable=False)
+    description = Column(Unicode(64), nullable=False)
+
+class MoveMetaStatChange(TableBase):
+    u"""Stat changes moves (may) make."""
+    __tablename__ = 'move_meta_stat_changes'
+    move_id = Column(Integer, ForeignKey('moves.id'), primary_key=True, nullable=False, autoincrement=False)
+    stat_id = Column(Integer, ForeignKey('stats.id'), primary_key=True, nullable=False, autoincrement=False)
+    change = Column(Integer, nullable=False, index=True)
+
 class MoveName(TableBase):
     u"""Non-English name of a move
     """
@@ -1431,6 +1469,8 @@ Move.flavor_text = relation(MoveFlavorText, order_by=MoveFlavorText.version_grou
 Move.foreign_names = relation(MoveName, backref='move')
 Move.generation = relation(Generation, backref='moves')
 Move.machines = relation(Machine, backref='move')
+Move.meta = relation(MoveMeta, uselist=False, backref='move')
+Move.meta_stat_changes = relation(MoveMetaStatChange)
 Move.move_effect = relation(MoveEffect, backref='moves')
 Move.move_flags = relation(MoveFlag, backref='move')
 Move.super_contest_effect = relation(SuperContestEffect, backref='moves')
@@ -1463,6 +1503,11 @@ MoveFlag.flag = relation(MoveFlagType)
 
 MoveFlavorText.version_group = relation(VersionGroup)
 
+MoveMeta.category = relation(MoveMetaCategory, backref='move_meta')
+MoveMeta.ailment = relation(MoveMetaAilment, backref='move_meta')
+
+MoveMetaStatChange.stat = relation(Stat, backref='move_meta_stat_changes')
+
 MoveName.language = relation(Language)
 
 Nature.foreign_names = relation(NatureName, backref='nature')