Show
Ignore:
Timestamp:
02/08/08 02:44:39 (10 months ago)
Author:
eevee
Message:

Database refactoring. Renamed columns and tables to be more consistent and more readable. (#58)

Files:
1 modified

Legend:

Unmodified
Added
Removed

  • veekun/trunk/script/pokedex.sql

    r399 r406  
    1818  id tinyint(3) unsigned NOT NULL default '0', 
    1919  `name` varchar(24) NOT NULL default '', 
    20   gameblurb tinytext NOT NULL, 
    21   effect tinytext NOT NULL, 
     20  blurb_dp tinytext NOT NULL, 
     21  description tinytext NOT NULL, 
    2222  PRIMARY KEY  (id) 
    2323) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    … …  
    251251 
    252252-- 
    253 -- Table structure for table `contestmoves` 
     253-- Table structure for table `contest_effects` 
    254254-- 
    255255 
    256 DROP TABLE IF EXISTS contestmoves; 
    257 CREATE TABLE contestmoves ( 
     256DROP TABLE IF EXISTS contest_effects; 
     257CREATE TABLE contest_effects ( 
    258258  id tinyint(4) NOT NULL default '0', 
    259259  appeal tinyint(4) NOT NULL default '0', 
    260260  jam tinyint(4) NOT NULL default '0', 
     261  blurb_rusa tinytext NOT NULL, 
    261262  description tinytext NOT NULL, 
    262   effect tinytext NOT NULL, 
    263263  PRIMARY KEY  (id) 
    264264) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    265265 
    266266-- 
    267 -- Dumping data for table `contestmoves` 
     267-- Dumping data for table `contest_effects` 
    268268-- 
    269269 
    270 LOCK TABLES contestmoves WRITE; 
    271 /*!40000 ALTER TABLE contestmoves DISABLE KEYS */; 
    272 INSERT INTO contestmoves VALUES (1,4,0,'A highly appealing move.','Gives a high number of appeal points wth no other effects.'), 
     270LOCK TABLES contest_effects WRITE; 
     271/*!40000 ALTER TABLE contest_effects DISABLE KEYS */; 
     272INSERT INTO contest_effects VALUES (1,4,0,'A highly appealing move.','Gives a high number of appeal points wth no other effects.'), 
    273273(2,3,0,'Affected by how well the appeal in front goes.','If the Pokemon that appealed before the user earned less than three appeal points, user earns six; if three, user earns three; if more than three, user earns none.'), 
    274274(3,6,0,'After this move, the user is more easily startled.','If the user is jammed this turn after using this move, it will receive twice as many jam points.'), 
    … …  
    303303(32,1,0,'Ups the user\'s condition.  Helps prevent nervousness.','User gains one star.'), 
    304304(33,3,0,'Worsens the condition of those that made appeals.','Removes all stars from all Pokemon that have appealed this turn.'); 
    305 /*!40000 ALTER TABLE contestmoves ENABLE KEYS */; 
     305/*!40000 ALTER TABLE contest_effects ENABLE KEYS */; 
    306306UNLOCK TABLES; 
    307307 
    308308-- 
    309 -- Table structure for table `evchains` 
     309-- Table structure for table `evo_chains` 
    310310-- 
    311311 
    312 DROP TABLE IF EXISTS evchains; 
    313 CREATE TABLE evchains ( 
     312DROP TABLE IF EXISTS evo_chains; 
     313CREATE TABLE evo_chains ( 
    314314  id tinyint(3) unsigned NOT NULL default '0', 
    315   base smallint(5) unsigned NOT NULL default '0', 
    316   growth enum('slow','medium','fast','poly','superfast','superslow') default NULL, 
    317   `chain` tinytext NOT NULL, 
     315  growth_rate enum('slow','medium','fast','poly','superfast','superslow') default NULL, 
    318316  steps mediumint(8) unsigned default '0', 
    319   babygs tinytext, 
    320   babyc tinytext, 
    321   babyrusa tinytext, 
    322317  baby_item varchar(12) NOT NULL, 
    323318  PRIMARY KEY  (id) 
    … …  
    325320 
    326321-- 
    327 -- Dumping data for table `evchains` 
     322-- Dumping data for table `evo_chains` 
    328323-- 
    329324 
    330 LOCK TABLES evchains WRITE; 
    331 /*!40000 ALTER TABLE evchains DISABLE KEYS */; 
    332 INSERT INTO evchains VALUES (1,1,'poly','[0,\"\",[1,\"L16\",[2,\"L32\"]]]',5120,'112 129 218 012 079','112 129 218 012 079','079 112 129 173 203 218 319 344',''), 
    333 (2,4,'poly','[3,\"\",[4,\"L16\",[5,\"L36\"]]]',5120,'186 245 156 043 199 250','186 245 156 043 199 250','186 245 156 043 199 250 013 348',''), 
    334 (3,7,'poly','[6,\"\",[7,\"L16\",[8,\"L36\"]]]',5120,'242 113 053 092 192 174','242 113 053 092 192 174','242 113 053 192 174 286 299 280',''), 
    335 (4,10,'medium','[9,\"\",[10,\"L7\",[11,\"L10\"]]]',3840,NULL,NULL,NULL,''), 
    336 (5,13,'medium','[12,\"\",[13,\"L7\",[14,\"L10\"]]]',3840,NULL,NULL,NULL,''), 
    337 (6,16,'poly','[15,\"\",[16,\"L18\",[17,\"L36\"]]]',3840,'227 184 192','227 184 192','227 184 192 210 313',''), 
    338 (7,19,'medium','[18,\"\",[19,\"L20\"]]',3840,'102 171 153 043 067 178','102 171 153 043 067 178','102 171 153 043 067 178 252 206',''), 
    339 (8,21,'medium','[20,\"\",[21,\"L20\"]]',3840,'184 205 183 097 160','184 205 183 097 160','184 205 183 097 160 309 142',''), 
    340 (9,23,'medium','[22,\"\",[23,\"L22\"]]',5120,'227 028 179 250','227 028 179 250 241','227 028 179 250 304',''), 
    341 (10,25,'medium','[171,\"\",[24,\"H\",[25,\"T\"]]]',2560,'178 116 216 226 002','178 116 216 226 002','178 116 216 226 002 272 267',''), 
    342 (11,27,'medium','[26,\"\",[27,\"L22\"]]',5120,'174 218 067 228','174 218 067 228 231','174 218 067 228 156 231 013 305',''), 
    343 (12,29,'poly','[28,\"\",[29,\"L16\",[30,\"M\"]]]',5120,'047 049 035 115 203 067 250','047 049 035 115 203 067 250','047 049 035 115 203 067 250',''), 
    344 (13,32,'poly','[31,\"\",[32,\"L16\",[33,\"M\"]]]',5120,'047 049 035 092 132 067 250','047 049 035 092 132 067 250','067 049 047 035 132 092 250',''), 
    345 (14,35,'fast','[172,\"\",[34,\"H\",[35,\"M\"]]]',2560,'216 117 132 186 149 101','216 117 132 186 149 101','216 117 132 186 149 101 272 163',''), 
    346 (15,37,'medium','[36,\"\",[37,\"F\"]]',5120,'184 094 174 179 049','184 094 174 179 049','184 094 174 179 049 335 243 256',''), 
    347 (16,39,'fast','[173,\"\",[38,\"H\",[39,\"M\"]]]',2560,'194 216 184','194 216 184','194 216 184 272 312',''), 
    348 (17,41,'medium','[40,\"\",[41,\"L22\",[168,\"H\"]]]',3840,'097 227 184 015 017','097 227 184 015 017','097 227 184 015 017 173',''), 
    349 (18,43,'poly','[42,\"\",[43,\"L21\",[44,\"P\"],[181,\"S\"]]]',5120,'013 074 174 234','013 074 174 234','013 074 174 234 203 274',''), 
    350 (19,46,'medium','[45,\"\",[46,\"L24\"]]',5120,'205 102 067 059 174 112 227','205 102 067 059 174 112 227','205 102 067 059 174 229 112 227',''), 
    351 (20,48,'medium','[47,\"\",[48,\"L31\"]]',5120,'225 102 201','225 102 201','225 102 201 323',''), 
    352 (21,50,'medium','[49,\"\",[50,\"L26\"]]',5120,'184 102 245 227 250','184 102 245 227 250','184 102 245 227 250 252 156',''), 
    353 (22,52,'medium','[51,\"\",[52,\"L28\"]]',5120,'179 203 094 132','179 203 094 132','179 203 094 132 243 273',''), 
    354 (23,54,'medium','[53,\"\",[54,\"L33\"]]',5120,'057 094 059 192 112 247 093','057 094 059 192 112 247 093 237','094 059 192 112 247 093 237 286',''), 
    355 (24,56,'medium','[55,\"\",[56,\"L28\"]]',5120,'156 192 095 067 178 250','156 192 095 067 178 250','156 192 095 067 178 250 278 264',''), 
    356 (25,58,'slow','[57,\"\",[58,\"F\"]]',5120,'033 218 241 036 082','033 218 241 036 082','033 218 241 036 082 335 256',''), 
    357 (26,60,'poly','[59,\"\",[60,\"L25\",[61,\"W\"],[185,\"IKing\'s Rock\"]]]',5120,'053 149 060 113 169','053 149 060 113 169','053 149 060 113 169 345 300',''), 
    358 (27,63,'poly','[62,\"\",[63,\"L16\",[64,\"R\"]]]',5120,'112 226 111','112 226 111','226 111 281 006 008 007',''), 
    359 (28,66,'poly','[65,\"\",[66,\"L28\",[67,\"R\"]]]',5120,'112 095 026 226','112 095 026 226','112 095 026 226 264 067 156',''), 
    360 (29,69,'poly','[68,\"\",[69,\"L21\",[70,\"P\"]]]',5120,'013 226 114 234 140','013 226 114 234 140','013 226 114 234 140 274 344',''), 
    361 (30,72,'slow','[71,\"\",[72,\"L30\"]]',5120,'061 242 228 113 218','061 242 228 113 218','061 242 228 113 218 108',''), 
    362 (31,74,'poly','[73,\"\",[74,\"L25\",[75,\"R\"]]]',3840,'004 156','004 156','004 156 334',''), 
    363 (32,77,'medium','[76,\"\",[77,\"L40\"]]',5120,'171 036 023 094 203 097','171 036 023 094 203 097','171 036 023 094 203 037',''), 
    364 (33,79,'medium','[78,\"\",[79,\"L37\"],[198,\"IKing\'s Rock\"]]',5120,'218 186 247 022','218 186 247 022','218 186 247 022 299 213 172',''), 
    365 (34,81,'medium','[80,\"\",[81,\"L30\"]]',5120,NULL,NULL,NULL,''), 
    366 (35,83,'medium','[82,\"\"]',5120,'192 118 015 097 174','192 118 015 097 174','210 192 118 015 097 174 296 173',''), 
    367 (36,84,'medium','[83,\"\",[84,\"L31\"]]',5120,'097 047 113 184 174','097 047 113 184 174','097 047 113 184 174 282',''), 
    368 (37,86,'medium','[85,\"\",[86,\"L34\"]]',5120,'121 194 049 063 028 226','121 194 049 063 028 226','121 194 049 031 028 226 251 332',''), 
    369 (38,88,'medium','[87,\"\",[88,\"L38\"]]',5120,'113 211 121','113 211 121','113 211 121 285 173 324 152',''), 
    370 (39,90,'slow','[89,\"\",[90,\"W\"]]',5120,'060 035 111 228 102','060 035 111 228 102','060 035 111 228 102 332',''), 
    371 (40,92,'poly','[91,\"\",[92,\"L25\",[93,\"R\"]]]',5120,'148 194 113','148 194 113','148 194 113 309 260 287 152',''), 
    372 (41,95,'medium','[94,\"\",[207,\"IMetal Coat\"]]',6400,'156 174','156 174','156 174 152 334',''), 
    373 (42,96,'medium','[95,\"\",[96,\"L26\"]]',5120,'112 111','112 111','111 273 271 006 008 007',''), 
    374 (43,98,'medium','[97,\"\",[98,\"L28\"]]',5120,'090 113 132 174 028','090 113 132 174 028','090 113 132 174 028 281 013',''), 
    375 (44,100,'medium','[99,\"\",[100,\"L30\"]]',5120,NULL,NULL,NULL,''), 
    376 (45,102,'slow','[101,\"\",[102,\"P\"]]',5120,'234 235 114 071 245','234 235 114 071 245','234 235 114 245 243 274 173',''), 
    377 (46,104,'medium','[103,\"\",[104,\"L28\"]]',5120,'156 245 186 102 129 194','156 245 186 102 129 194 013','156 245 186 102 129 194 013',''), 
    378 (47,106,'medium','[235,\"\",[105,\"a20\"],[106,\"d20\"],[236,\"e20\"]]',6400,'228 135 182 169','228 135 182 169','228 135 182 169 269',''), 
    379 (48,108,'medium','[107,\"\"]',5120,'186 221 033','186 221 033','186 221 033 173 264 213 172 163',''), 
    380 (49,109,'medium','[108,\"\",[109,\"L35\"]]',5120,'102 148 059 193 219','102 148 059 193 219','102 148 059 193 219 260',''), 
    381 (50,111,'slow','[110,\"\",[111,\"L42\"]]',5120,'241 178 156 036 227 067 221','241 178 156 036 227 067 221','241 178 156 067 221 013 173 305',''), 
    382 (51,113,'fast','[112,\"\",[241,\"H\"]]',10240,'216 117 214','216 117 214','216 117 214 311 163','Luck Incense'), 
    383 (52,114,'medium','[113,\"\"]',5120,'174 092 071 114 132','174 092 071 114 132','174 092 071 114 132 072 266',''), 
    384 (53,115,'medium','[114,\"\"]',5120,'022 192 115 218 049','022 192 115 218 049','022 192 115 218 049 067 305 163',''), 
    385 (54,116,'medium','[115,\"\",[116,\"L32\",[229,\"IDragon Scale\"]]]',5120,'174 061 189 049 149 081','174 061 189 049 149 081','174 061 189 049 149 081 224',''), 
    386 (55,118,'medium','[117,\"\",[118,\"L33\"]]',5120,'059 113 055','059 113 055','059 113 055 213 299',''), 
    387 (56,120,'slow','[119,\"\",[120,\"W\"]]',5120,'061 111 047',NULL,NULL,''), 
    388 (57,122,'medium','[121,\"\"]',6400,'247 094 101','247 094 101','247 094 101 243 251 270','Odd Incense'), 
    389 (58,123,'medium','[122,\"\",[211,\"IMetal Coat\"]]',6400,'067 218 225 012 178 112','067 218 225 012 178 112','067 218 225 012 178 112 202 317',''), 
    390 (59,124,'medium','[237,\"\",[123,\"L30\"]]',6400,'095','095','095 243 251 272 007',''), 
    391 (60,125,'medium','[238,\"\",[124,\"L30\"]]',6400,'001 111 026 095','001 111 026 095 237','001 111 026 095 237 006 007',''), 
    392 (61,126,'medium','[239,\"\",[125,\"L30\"]]',6400,'001 004 111 102','001 004 111 102 237','001 004 111 102 237 008',''), 
    393 (62,127,'slow','[126,\"\"]',6400,'030 174','030 174','030 174 205 184',''), 
    394 (63,128,'slow','[127,\"\"]',5120,NULL,NULL,NULL,''), 
    395 (64,129,'slow','[128,\"\",[129,\"L20\"]]',1280,NULL,NULL,NULL,''), 
    396 (65,131,'slow','[130,\"\"]',10240,'061 192','061 192','192 163 320 286 348 173 213 031',''), 
    397 (66,132,'medium','[131,\"\"]',5120,NULL,NULL,NULL,''), 
    398 (67,133,'medium','[132,\"\",[133,\"W\"],[134,\"T\"],[135,\"F\"],[195,\"DH\"],[196,\"NH\"]]',8960,'174 203','174 203','203 174 202 173 320 272',''), 
    399 (68,137,'medium','[136,\"\",[232,\"IUp-Grade\"]]',5120,NULL,NULL,NULL,''), 
    400 (69,138,'medium','[137,\"\",[138,\"L40\"]]',7680,'060 061 028 047 113','060 061 028 047 113','060 061 028 047 113 156 190',''), 
    401 (70,140,'medium','[139,\"\",[140,\"L40\"]]',7680,'060 061 228 090 174','060 061 228 090 174','060 061 228 090 174 281 108',''), 
    402 (71,142,'slow','[141,\"\"]',8960,'017 227 192','017 227 192','017 227 192 210 224 173',''), 
    403 (72,143,'slow','[142,\"\"]',10240,'121','121','121 203 037 173 089 163','Full Incense'), 
    404 (73,144,'slow','[143,\"\"]',20480,NULL,NULL,NULL,''), 
    405 (74,145,'slow','[144,\"\"]',20480,NULL,NULL,NULL,''), 
    406 (75,146,'slow','[145,\"\"]',20480,NULL,NULL,NULL,''), 
    407 (76,147,'slow','[146,\"\",[147,\"L30\",[148,\"L55\"]]]',10240,'112 053 113 047','112 053 113 047','112 053 113 047 224 348',''), 
    408 (77,150,'slow','[149,\"\"]',30720,NULL,NULL,NULL,''), 
    409 (78,151,'poly','[150,\"\"]',30720,NULL,NULL,NULL,''), 
    410 (79,152,'poly','[151,\"\",[152,\"L16\",[153,\"L32\"]]]',5120,'021 072 067 245 174','021 072 067 245 174 013','021 072 067 245 174 266 274 319',''), 
    411 (80,155,'poly','[154,\"\",[155,\"L14\",[156,\"L36\"]]]',5120,'153 097 178 036 192','153 097 178 036 192 065','153 097 178 036 192 342 335 305',''), 
    412 (81,158,'poly','[157,\"\",[158,\"L18\",[159,\"L30\"]]]',5120,'241 036 055 245 012 156','241 036 055 245 012 156','241 036 055 245 156 299 345 336',''), 
    413 (82,161,'medium','[160,\"\",[161,\"L15\"]]',3840,'037 227 162 115 178','037 227 162 115 178','037 227 162 115 178 163 270 273',''), 
    414 (83,163,'medium','[162,\"\",[163,\"L20\"]]',3840,'118 047 184 016 017','118 047 184 016 017 142','118 047 184 016 017 142 296',''), 
    415 (84,165,'fast','[164,\"\",[165,\"L18\"]]',3840,'059 116 112','059 116 112','059 116 317',''), 
    416 (85,167,'fast','[166,\"\",[167,\"L22\"]]',3840,'059 049 048 225 227','059 049 048 225 227','059 049 048 225 227 323',''), 
    417 (86,170,'slow','[169,\"\",[170,\"L27\"]]',5120,'174 047 102','174 047 102','174 102 132',''), 
    418 (87,175,'fast','[174,\"\",[175,\"H\"]]',2560,'216 118 063 192 247','216 118 063 192 247','216 118 063 192 247 163 243',''), 
    419 (88,177,'medium','[176,\"\",[177,\"L25\"]]',5120,'113 064 097 184 210','113 064 097 184 210','113 064 097 184 210 243 296 286',''), 
    420 (89,179,'poly','[178,\"\",[179,\"L15\",[180,\"L30\"]]]',5120,'084 035 033 218 102 114','084 035 033 218 102 114','035 033 218 102 114 315 267',''), 
    421 (90,183,'fast','[297,\"\",[182,\"H\",[183,\"L18\"]]]',2560,'112 216 132 247 186 194 047 192','112 216 132 247 186 194 047 192','226 046 286 020 320','Sea Incense'), 
    422 (91,185,'medium','[184,\"\"]',5120,'119','119','119','Rock Incense'), 
    423 (92,187,'poly','[186,\"\",[187,\"L18\",[188,\"L27\"]]]',5120,'092 044 226 037 114 132 005','092 044 226 037 114 132 005','092 226 037 114 132 269 243',''), 
    424 (93,190,'fast','[189,\"\"]',5120,'067 102 227 096 179 028 002 250','067 102 227 096 179 028 002 250','067 102 227 096 179 028 002 250',''), 
    425 (94,191,'poly','[190,\"\",[191,\"S\"]]',5120,NULL,NULL,'319 226 072 266 173 269',''), 
    426 (95,193,'medium','[192,\"\"]',5120,'017 178 140','017 178 140','017 178 140 323 317',''), 
    427 (96,194,'medium','[193,\"\",[194,\"L20\"]]',5120,'033 245 218','033 245 218','033 245 218 173 299 253 255 254',''), 
    428 (97,198,'poly','[197,\"\"]',5120,'017 064 097 118 016','017 064 097 118 016 142','017 064 118 016 142 108 296 194',''), 
    429 (98,200,'fast','[199,\"\"]',6400,'102 193','102 193','102 193 243 285',''), 
    430 (99,201,'medium','[200,\"\"]',10240,NULL,NULL,NULL,''), 
    431 (100,202,'medium','[359,\"\",[201,\"L15\"]]',5120,NULL,NULL,NULL,'Lax Incense'), 
    432 (101,203,'medium','[202,\"\"]',5120,'035 132 192 247 250','035 132 192 247 250','035 132 192 247 250 243 272 276',''), 
    433 (102,204,'medium','[203,\"\",[204,\"L31\"]]',5120,'114 041 174 128','114 041 174 128','114 041 174 128 067 327',''), 
    434 (103,206,'medium','[205,\"\"]',5120,'116 245 156 043 098','116 245 156 043 098','116 245 156 043 020 309 173',''), 
    435 (104,207,'poly','[206,\"\"]',5120,'231 016 012 067','231 016 012 067','231 016 012 067 327',''), 
    436 (105,209,'fast','[208,\"\",[209,\"L23\"]]',5120,'117 184 114 216 241 214 121 042','117 184 114 216 241 214 121 042','117 184 114 216 241 214 172 264',''), 
    437 (106,211,'medium','[210,\"\"]',5120,'174 113 060 047','174 113 060 047','174 113 060 047 309',''), 
    438 (107,213,'poly','[212,\"\"]',5120,'229','229','229',''), 
    439 (108,214,'slow','[213,\"\"]',6400,'105 116 174','105 116 174','105 116 174 205',''), 
    440 (109,215,'poly','[214,\"\"]',5120,'067 179 192 114 043','067 179 192 114 043','067 179 192 114 043 305 251',''), 
    441 (110,216,'medium','[215,\"\",[216,\"L30\"]]',5120,'241 035 068 115 067','241 035 068 115 067 231','241 035 068 067 231 312 280 213',''), 
    442 (111,218,'medium','[217,\"\",[218,\"L38\"]]',5120,'150','150','150 256',''), 
    443 (112,220,'slow','[219,\"\",[220,\"L33\"]]',5120,'035 043 033 156 245','035 043 033 156 245','035 043 033 156 245 340 332 037',''), 
    444 (113,222,'fast','[221,\"\"]',5120,'156 218 102 053 132','156 218 102 053 132','156 102 053 132 111 274 108 332',''), 
    445 (114,223,'medium','[222,\"\",[223,\"L25\"]]',5120,'061 189 047 113 102','061 189 047 113 102','061 189 047 113 102 085 349',''), 
    446 (115,225,'fast','[224,\"\"]',5120,'061 097 247 149 228','061 097 247 149 228','061 097 247 149 228 300',''), 
    447 (116,226,'slow','[225,\"\"]',6400,'238 055 113 028','238 055 113 028','238 055 113 028 299 156','Wave Incense'), 
    448 (117,227,'slow','[226,\"\"]',6400,'064 227 017','064 227 017 142','064 227 017 142 173',''), 
    449 (118,228,'slow','[227,\"\",[228,\"L24\"]]',5120,'082 098 227 067 179 178 250','082 098 227 067 179 178 250','082 098 227 067 179 178 250 260',''), 
    450 (119,231,'medium','[230,\"\",[231,\"L25\"]]',5120,'115 033 245','115 033 245 054','115 033 245 172 067 089',''), 
    451 (120,234,'slow','[233,\"\"]',5120,'114 179 049 112 043','114 179 049 112 043','179 049 043 206 243 325',''), 
    452 (121,235,'fast','[234,\"\"]',5120,NULL,NULL,NULL,''), 
    453 (122,241,'slow','[240,\"\"]',5120,'216 178 068','216 178 068','216 178 068 202 243 173 269 213',''), 
    454 (123,243,'slow','[242,\"\"]',20480,NULL,NULL,NULL,''), 
    455 (124,244,'slow','[243,\"\"]',20480,NULL,NULL,NULL,''), 
    456 (125,245,'slow','[244,\"\"]',20480,NULL,NULL,NULL,''), 
    457 (126,246,'slow','[245,\"\",[246,\"L30\",[247,\"L55\"]]]',10240,'227 022 199 115 245','227 022 199 115 245','227 022 199 115 245 348 173',''), 
    458 (127,249,'slow','[248,\"\"]',30720,NULL,NULL,NULL,''), 
    459 (128,250,'slow','[249,\"\"]',30720,NULL,NULL,NULL,''), 
    460 (129,251,'poly','[250,\"\"]',30720,NULL,NULL,NULL,''), 
    461 (130,252,'poly','[251,\"\",[252,\"L16\",[253,\"L36\"]]]',5120,NULL,NULL,'241 299 282 072 224 305',''), 
    462 (131,255,'poly','[254,\"\",[255,\"L16\",[256,\"L36\"]]]',5120,NULL,NULL,'067 178 202 206 156 264',''), 
    463 (132,258,'poly','[257,\"\",[258,\"L16\",[259,\"L36\"]]]',5120,NULL,NULL,'286 252 173 022 300 242',''), 
    464 (133,261,'medium','[260,\"\",[261,\"L20\"]]',3840,NULL,NULL,'309 304 342 042 280',''), 
    465 (134,263,'medium','[262,\"\",[263,\"L20\"]]',3840,NULL,NULL,'203 227 163 320 270',''), 
    466 (135,265,'medium','[264,\"\",[265,\"L7\",[266,\"L10\"]],[267,\"L7\",[268,\"L10\"]]]',3840,NULL,NULL,NULL,''), 
    467 (136,270,'poly','[269,\"\",[270,\"L14\",[271,\"W\"]]]',3840,NULL,NULL,'234 074 229 072 174 054',''), 
    468 (137,273,'poly','[272,\"\",[273,\"L16\",[274,\"P\"]]]',3840,NULL,NULL,'072 132 097 012 035 205',''), 
    469 (138,276,'poly','[275,\"\",[276,\"L22\"]]',3840,NULL,NULL,'227 047 286 118 098 142',''), 
    470 (139,278,'medium','[277,\"\",[278,\"L25\"]]',5120,NULL,NULL,'053 238 096 015 345',''), 
    471 (140,280,'slow','[279,\"\",[280,\"L20\",[281,\"L30\"]]]',5120,NULL,NULL,'049 260 211 261 193',''), 
    472 (141,283,'medium','[282,\"\",[283,\"L22\"]]',3840,NULL,NULL,'192 340 059 055 169',''), 
    473 (142,285,'superslow','[284,\"\",[285,\"L23\"]]',3840,NULL,NULL,'312 206 203 205 269',''), 
    474 (143,287,'slow','[286,\"\",[287,\"L18\",[288,\"L36\"]]]',3840,NULL,NULL,'227 162 033 172 305 173 213',''), 
    475 (144,290,'superfast','[289,\"\",[290,\"L20\"],[291,\"E290\"]]',3840,NULL,NULL,'202 184 015 317',''), 
    476 (145,293,'poly','[292,\"\",[293,\"L20\",[294,\"L40\"]]]',5120,NULL,NULL,'035 172 206 325 264',''), 
    477 (146,296,'superslow','[295,\"\",[296,\"L24\"]]',5120,NULL,NULL,'184 196 192 269 237 278 222 067',''), 
    478 (147,299,'medium','[298,\"\"]',5120,NULL,NULL,'221 204 152',''), 
    479 (148,300,'fast','[299,\"\",[300,\"M\"]]',3840,NULL,NULL,'269 243 252 312 272 225 163 320',''), 
    480 (149,302,'poly','[301,\"\"]',6400,NULL,NULL,'243 104 235',''), 
    481 (150,303,'fast','[302,\"\"]',5120,NULL,NULL,'013 205 304 243 245 320',''), 
    482 (151,304,'slow','[303,\"\",[304,\"L32\",[305,\"L42\"]]]',8960,NULL,NULL,'282 033 022 264',''), 
    483 (152,307,'medium','[306,\"\",[307,\"L37\"]]',5120,NULL,NULL,'006 008 007 192 251 225 222',''), 
    484 (153,309,'slow','[308,\"\",[309,\"L26\"]]',5120,NULL,NULL,'241 028 252 173 128',''), 
    485 (154,311,'medium','[310,\"\"]',5120,NULL,NULL,'163 272',''), 
    486 (155,312,'medium','[311,\"\"]',5120,NULL,NULL,'163 272',''), 
    487 (156,313,'superfast','[312,\"\"]',3840,NULL,NULL,'225 317 270',''), 
    488 (157,314,'superslow','[313,\"\"]',3840,NULL,NULL,'225 317 073',''), 
    489 (158,315,'poly','[314,\"\"]',5120,NULL,NULL,'190 234 041 177','Rose Incense'), 
    490 (159,316,'superslow','[315,\"\",[316,\"L26\"]]',5120,NULL,NULL,'137 150 122 219',''), 
    491 (160,318,'slow','[317,\"\",[318,\"L30\"]]',5120,NULL,NULL,'055 037 036',''), 
    492 (161,320,'superslow','[319,\"\",[320,\"L40\"]]',10240,NULL,NULL,'037 036 206 172 213 173 089 320',''), 
    493 (162,322,'medium','[321,\"\",[322,\"L33\"]]',5120,NULL,NULL,'335 183 033 204 110 022',''), 
    494 (163,324,'medium','[323,\"\"]',5120,NULL,NULL,'283 202 213 280',''), 
    495 (164,325,'fast','[324,\"\",[325,\"L32\"]]',5120,NULL,NULL,'247 325 163 270',''), 
    496 (165,327,'fast','[326,\"\"]',3840,NULL,NULL,'226 156 273 049 225 272 270 264',''), 
    497 (166,328,'poly','[327,\"\",[328,\"L35\",[329,\"L45\"]]]',5120,NULL,NULL,'115 097 015',''), 
    498 (167,331,'poly','[330,\"\",[331,\"L32\"]]',5120,NULL,NULL,'319 050 297 222 067',''), 
    499 (168,333,'superfast','[332,\"\",[333,\"L35\"]]',5120,NULL,NULL,'096 113 227 098',''), 
    500 (169,335,'superfast','[334,\"\"]',5120,NULL,NULL,'174 023 012 067 045 173',''), 
    501 (170,336,'superslow','[335,\"\"]',5120,NULL,NULL,'253 255 254 033',''), 
    502 (171,337,'fast','[336,\"\"]',6400,NULL,NULL,NULL,''), 
    503 (172,338,'fast','[337,\"\"]',6400,NULL,NULL,NULL,''), 
    504 (173,339,'medium','[338,\"\",[339,\"L30\"]]',5120,NULL,NULL,'036 249 208',''), 
    505 (174,341,'superslow','[340,\"\",[341,\"L30\"]]',3840,NULL,NULL,'299 282 033 245',''), 
    506 (175,343,'medium','[342,\"\",[343,\"L36\"]]',5120,NULL,NULL,NULL,''), 
    507 (176,345,'superfast','[344,\"\",[345,\"L40\"]]',7680,NULL,NULL,'111 104 242 156',''), 
    508 (177,347,'superfast','[346,\"\",[347,\"L40\"]]',7680,NULL,NULL,'228 281 013 156',''), 
    509 (178,349,'superfast','[348,\"\",[349,\"B\"]]',5120,NULL,NULL,'242 224 299 094 112 108',''), 
    510 (179,351,'medium','[350,\"\"]',6400,NULL,NULL,'247 243',''), 
    511 (180,352,'poly','[351,\"\"]',5120,NULL,NULL,'049 276 270',''), 
    512 (181,353,'fast','[352,\"\",[353,\"L37\"]]',6400,NULL,NULL,'049 193 192 309 285',''), 
    513 (182,355,'fast','[354,\"\",[355,\"L37\"]]',6400,NULL,NULL,'285 193 219 287 261 184',''), 
    514 (183,357,'slow','[356,\"\"]',6400,NULL,NULL,'028 020 012 072 266',''), 
    515 (184,358,'fast','[357,\"\"]',6400,NULL,NULL,'049 173 094 137','Pure Incense'), 
    516 (185,359,'poly','[358,\"\"]',6400,NULL,NULL,'225 184 037 276 173 163',''), 
    517 (186,361,'medium','[360,\"\",[361,\"L42\"]]',5120,NULL,NULL,'334 190',''), 
    518 (187,363,'poly','[362,\"\",[363,\"L32\",[364,\"L44\"]]]',5120,NULL,NULL,'345 253 255 254 280 156 173 089',''), 
    519 (188,366,'superfast','[365,\"\",[366,\"IDeepseatooth\"],[367,\"IDeepseascale\"]]',5120,NULL,NULL,'286 299 033 047 111 108',''), 
    520 (189,369,'slow','[368,\"\"]',10240,NULL,NULL,'221 129 345 132 213 156',''), 
    521 (190,370,'fast','[369,\"\"]',5120,NULL,NULL,'149 047 345 299',''), 
    522 (191,371,'slow','[370,\"\",[371,\"L30\",[372,\"L50\"]]]',10240,NULL,NULL,'055 036 081 238 348 186',''), 
    523 (192,374,'slow','[373,\"\",[374,\"L20\",[375,\"L45\"]]]',10240,NULL,NULL,NULL,''), 
    524 (193,377,'slow','[376,\"\"]',20480,NULL,NULL,NULL,''), 
    525 (194,378,'slow','[377,\"\"]',20480,NULL,NULL,NULL,''), 
    526 (195,379,'slow','[378,\"\"]',20480,NULL,NULL,NULL,''), 
    527 (196,380,'slow','[379,\"\"]',30720,NULL,NULL,NULL,''), 
    528 (197,381,'slow','[380,\"\"]',30720,NULL,NULL,NULL,''), 
    529 (198,382,'slow','[381,\"\"]',30720,NULL,NULL,NULL,''), 
    530 (199,383,'slow','[382,\"\"]',30720,NULL,NULL,NULL,''), 
    531 (200,384,'slow','[383,\"\"]',30720,NULL,NULL,NULL,''), 
    532 (201,385,'slow','[384,\"\"]',30720,NULL,NULL,NULL,''), 
    533 (202,386,'slow','[385,\"\"]',30720,NULL,NULL,NULL,''), 
    534 (0,0,NULL,'',0,NULL,NULL,NULL,''), 
    535 (203,387,'poly','',5120,'','','',''), 
    536 (204,390,'poly','',5120,'','','',''), 
    537 (205,393,'poly','',5120,'','','',''), 
    538 (206,396,'poly','',3840,'','','',''), 
    539 (207,399,'medium','',3840,'','','',''), 
    540 (208,401,'poly','',3840,'','','',''), 
    541 (209,403,'poly','',5120,'','','',''), 
    542 (211,408,'superfast','',7680,'','','',''), 
    543 (212,410,'superfast','',7680,'','','',''), 
    544 (213,412,'medium','',3840,'','','',''), 
    545 (214,415,'poly','',3840,'','','',''), 
    546 (215,417,'medium','',2560,'','','',''), 
    547 (216,418,'medium','',5120,'','','',''), 
    548 (217,420,'medium','',5120,'','','',''), 
    549 (218,422,'medium','',5120,'','','',''), 
    550 (219,425,'superslow','',7680,'','','',''), 
    551 (220,427,'medium','',5120,'','','',''), 
    552 (221,431,'fast','',5120,'','','',''), 
    553 (223,434,'medium','',5120,'','','',''), 
    554 (224,436,'medium','',5120,'','','',''), 
    555 (228,441,'poly','',5120,'','','',''), 
    556 (229,442,'medium','',7680,'','','',''), 
    557 (230,443,'slow','',10240,'','','',''), 
    558 (232,447,'poly','',6400,'','','',''), 
    559 (233,449,'slow','',7680,'','','',''), 
    560 (234,451,'slow','',5120,'','','',''), 
    561 (235,453,'medium','',2560,'','','',''), 
    562 (236,455,'slow','',6400,'','','',''), 
    563 (237,456,'superfast','',5120,'','','',''), 
    564 (239,459,'slow','',5120,'','','',''), 
    565 (240,479,'medium','',5120,'','','',''), 
    566 (241,480,'slow','',20480,'','','',''), 
    567 (242,481,'slow','',20480,'','','',''), 
    568 (243,482,'slow','',20480,'','','',''), 
    569 (244,483,'slow','',30720,'','','',''), 
    570 (245,484,'slow','',30720,'','','',''), 
    571 (246,485,'slow','',2560,'','','',''), 
    572 (247,486,'slow','',30720,'','','',''), 
    573 (248,487,'slow','',30720,'','','',''), 
    574 (249,488,'slow','',30720,'','','',''), 
    575 (250,490,'slow','',10240,'','','',''), 
    576 (251,490,'slow','',2560,'','','',''), 
    577 (252,491,'slow','',30720,'','','',''), 
    578 (253,492,'poly','',30720,'','','',''), 
    579 (254,493,'slow','',30720,'','','',''); 
    580 /*!40000 ALTER TABLE evchains ENABLE KEYS */; 
     325LOCK TABLES evo_chains WRITE; 
     326/*!40000 ALTER TABLE evo_chains DISABLE KEYS */; 
     327INSERT INTO evo_chains VALUES (1,'poly',5120,''), 
     328(2,'poly',5120,''), 
     329(3,'poly',5120,''), 
     330(4,'medium',3840,''), 
     331(5,'medium',3840,''), 
     332(6,'poly',3840,''), 
     333(7,'medium',3840,''), 
     334(8,'medium',3840,''), 
     335(9,'medium',5120,''), 
     336(10,'medium',2560,''), 
     337(11,'medium',5120,''), 
     338(12,'poly',5120,''), 
     339(13,'poly',5120,''), 
     340(14,'fast',2560,''), 
     341(15,'medium',5120,''), 
     342(16,'fast',2560,''), 
     343(17,'medium',3840,''), 
     344(18,'poly',5120,''), 
     345(19,'medium',5120,''), 
     346(20,'medium',5120,''), 
     347(21,'medium',5120,''), 
     348(22,'medium',5120,''), 
     349(23,'medium',5120,''), 
     350(24,'medium',5120,''), 
     351(25,'slow',5120,''), 
     352(26,'poly',5120,''), 
     353(27,'poly',5120,''), 
     354(28,'poly',5120,''), 
     355(29,'poly',5120,''), 
     356(30,'slow',5120,''), 
     357(31,'poly',3840,''), 
     358(32,'medium',5120,''), 
     359(33,'medium',5120,''), 
     360(34,'medium',5120,''), 
     361(35,'medium',5120,''), 
     362(36,'medium',5120,''), 
     363(37,'medium',5120,''), 
     364(38,'medium',5120,''), 
     365(39,'slow',5120,''), 
     366(40,'poly',5120,''), 
     367(41,'medium',6400,''), 
     368(42,'medium',5120,''), 
     369(43,'medium',5120,''), 
     370(44,'medium',5120,''), 
     371(45,'slow',5120,''), 
     372(46,'medium',5120,''), 
     373(47,'medium',6400,''), 
     374(48,'medium',5120,''), 
     375(49,'medium',5120,''), 
     376(50,'slow',5120,''), 
     377(51,'fast',10240,'Luck Incense'), 
     378(52,'medium',5120,''), 
     379(53,'medium',5120,''), 
     380(54,'medium',5120,''), 
     381(55,'medium',5120,''), 
     382(56,'slow',5120,''), 
     383(57,'medium',6400,'Odd Incense'), 
     384(58,'medium',6400,''), 
     385(59,'medium',6400,''), 
     386(60,'medium',6400,''), 
     387(61,'medium',6400,''), 
     388(62,'slow',6400,''), 
     389(63,'slow',5120,''), 
     390(64,'slow',1280,''), 
     391(65,'slow',10240,''), 
     392(66,'medium',5120,''), 
     393(67,'medium',8960,''), 
     394(68,'medium',5120,''), 
     395(69,'medium',7680,''), 
     396(70,'medium',7680,''), 
     397(71,'slow',8960,''), 
     398(72,'slow',10240,'Full Incense'), 
     399(73,'slow',20480,''), 
     400(74,'slow',20480,''), 
     401(75,'slow',20480,''), 
     402(76,'slow',10240,''), 
     403(77,'slow',30720,''), 
     404(78,'poly',30720,''), 
     405(79,'poly',5120,''), 
     406(80,'poly',5120,''), 
     407(81,'poly',5120,''), 
     408(82,'medium',3840,''), 
     409(83,'medium',3840,''), 
     410(84,'fast',3840,''), 
     411(85,'fast',3840,''), 
     412(86,'slow',5120,''), 
     413(87,'fast',2560,''), 
     414(88,'medium',5120,''), 
     415(89,'poly',5120,''), 
     416(90,'fast',2560,'Sea Incense'), 
     417(91,'medium',5120,'Rock Incense'), 
     418(92,'poly',5120,''), 
     419(93,'fast',5120,''), 
     420(94,'poly',5120,''), 
     421(95,'medium',5120,''), 
     422(96,'medium',5120,''), 
     423(97,'poly',5120,''), 
     424(98,'fast',6400,''), 
     425(99,'medium',10240,''), 
     426(100,'medium',5120,'Lax Incense'), 
     427(101,'medium',5120,''), 
     428(102,'medium',5120,''), 
     429(103,'medium',5120,''), 
     430(104,'poly',5120,''), 
     431(105,'fast',5120,''), 
     432(106,'medium',5120,''), 
     433(107,'poly',5120,''), 
     434(108,'slow',6400,''), 
     435(109,'poly',5120,''), 
     436(110,'medium',5120,''), 
     437(111,'medium',5120,''), 
     438(112,'slow',5120,''), 
     439(113,'fast',5120,''), 
     440(114,'medium',5120,''), 
     441(115,'fast',5120,''), 
     442(116,'slow',6400,'Wave Incense'), 
     443(117,'slow',6400,''), 
     444(118,'slow',5120,''), 
     445(119,'medium',5120,''), 
     446(120,'slow',5120,''), 
     447(121,'fast',5120,''), 
     448(122,'slow',5120,''), 
     449(123,'slow',20480,''), 
     450(124,'slow',20480,''), 
     451(125,'slow',20480,''), 
     452(126,'slow',10240,''), 
     453(127,'slow',30720,''), 
     454(128,'slow',30720,''), 
     455(129,'poly',30720,''), 
     456(130,'poly',5120,''), 
     457(131,'poly',5120,''), 
     458(132,'poly',5120,''), 
     459(133,'medium',3840,''), 
     460(134,'medium',3840,''), 
     461(135,'medium',3840,''), 
     462(136,'poly',3840,''), 
     463(137,'poly',3840,''), 
     464(138,'poly',3840,''), 
     465(139,'medium',5120,''), 
     466(140,'slow',5120,''), 
     467(141,'medium',3840,''), 
     468(142,'superslow',3840,''), 
     469(143,'slow',3840,''), 
     470(144,'superfast',3840,''), 
     471(145,'poly',5120,''), 
     472(146,'superslow',5120,''), 
     473(147,'medium',5120,''), 
     474(148,'fast',3840,''), 
     475(149,'poly',6400,''), 
     476(150,'fast',5120,''), 
     477(151,'slow',8960,''), 
     478(152,'medium',5120,''), 
     479(153,'slow',5120,''), 
     480(154,'medium',5120,''), 
     481(155,'medium',5120,''), 
     482(156,'superfast',3840,''), 
     483(157,'superslow',3840,''), 
     484(158,'poly',5120,'Rose Incense'), 
     485(159,'superslow',5120,''), 
     486(160,'slow',5120,''), 
     487(161,'superslow',10240,''), 
     488(162,'medium',5120,''), 
     489(163,'medium',5120,''), 
     490(164,'fast',5120,''), 
     491(165,'fast',3840,''), 
     492(166,'poly',5120,''), 
     493(167,'poly',5120,''), 
     494(168,'superfast',5120,''), 
     495(169,'superfast',5120,''), 
     496(170,'superslow',5120,''), 
     497(171,'fast',6400,''), 
     498(172,'fast',6400,''), 
     499(173,'medium',5120,''), 
     500(174,'superslow',3840,''), 
     501(175,'medium',5120,''), 
     502(176,'superfast',7680,''), 
     503(177,'superfast',7680,''), 
     504(178,'superfast',5120,''), 
     505(179,'medium',6400,''), 
     506(180,'poly',5120,''), 
     507(181,'fast',6400,''), 
     508(182,'fast',6400,''), 
     509(183,'slow',6400,''), 
     510(184,'fast',6400,'Pure Incense'), 
     511(185,'poly',6400,''), 
     512(186,'medium',5120,''), 
     513(187,'poly',5120,''), 
     514(188,'superfast',5120,''), 
     515(189,'slow',10240,''), 
     516(190,'fast',5120,''), 
     517(191,'slow',10240,''), 
     518(192,'slow',10240,''), 
     519(193,'slow',20480,''), 
     520(194,'slow',20480,''), 
     521(195,'slow',20480,''), 
     522(196,'slow',30720,''), 
     523(197,'slow',30720,''), 
     524(198,'slow',30720,''), 
     525(199,'slow',30720,''), 
     526(200,'slow',30720,''), 
     527(201,'slow',30720,''), 
     528(202,'slow',30720,''), 
     529(0,NULL,0,''), 
     530(203,'poly',5120,''), 
     531(204,'poly',5120,''), 
     532(205,'poly',5120,''), 
     533(206,'poly',3840,''), 
     534(207,'medium',3840,''), 
     535(208,'poly',3840,''), 
     536(209,'poly',5120,''), 
     537(211,'superfast',7680,''), 
     538(212,'superfast',7680,''), 
     539(213,'medium',3840,''), 
     540(214,'poly',3840,''), 
     541(215,'medium',2560,''), 
     542(216,'medium',5120,''), 
     543(217,'medium',5120,''), 
     544(218,'medium',5120,''), 
     545(219,'superslow',7680,''), 
     546(220,'medium',5120,''), 
     547(221,'fast',5120,''), 
     548(223,'medium',5120,''), 
     549(224,'medium',5120,''), 
     550(228,'poly',5120,''), 
     551(229,'medium',7680,''), 
     552(230,'slow',10240,''), 
     553(232,'poly',6400,''), 
     554(233,'slow',7680,''), 
     555(234,'slow',5120,''), 
     556(235,'medium',2560,''), 
     557(236,'slow',6400,''), 
     558(237,'superfast',5120,''), 
     559(239,'slow',5120,''), 
     560(240,'medium',5120,''), 
     561(241,'slow',20480,''), 
     562(242,'slow',20480,''), 
     563(243,'slow',20480,''), 
     564(244,'slow',30720,''), 
     565(245,'slow',30720,''), 
     566(246,'slow',2560,''), 
     567(247,'slow',30720,''), 
     568(248,'slow',30720,''), 
     569(249,'slow',30720,''), 
     570(250,'slow',10240,''), 
     571(251,'slow',2560,''), 
     572(252,'slow',30720,''), 
     573(253,'poly',30720,''), 
     574(254,'slow',30720,''); 
     575/*!40000 ALTER TABLE evo_chains ENABLE KEYS */; 
    581576UNLOCK TABLES; 
    582577 
    583578-- 
    584 -- Table structure for table `flavortext` 
     579-- Table structure for table `flavor_text` 
    585580-- 
    586581 
    587 DROP TABLE IF EXISTS flavortext; 
    588 CREATE TABLE flavortext ( 
    589   pokeid smallint(5) unsigned NOT NULL default '0', 
     582DROP TABLE IF EXISTS flavor_text; 
     583CREATE TABLE flavor_text ( 
     584  pokemon_id smallint(5) unsigned NOT NULL default '0', 
    590585  generation enum('rb','y','g','s','c','ru','sa','e','fr','lg','d','p') NOT NULL default 'rb', 
    591586  `text` tinytext NOT NULL, 
    592   PRIMARY KEY  (pokeid,generation) 
     587  PRIMARY KEY  USING BTREE (pokemon_id,generation) 
    593588) ENGINE=MyISAM DEFAULT CHARSET=utf8; 
    594589 
    595590-- 
    596 -- Dumping data for table `flavortext` 
     591-- Dumping data for table `flavor_text` 
    597592-- 
    598593 
    599 LOCK TABLES flavortext WRITE; 
    600 /*!40000 ALTER TABLE flavortext DISABLE KEYS */; 
    601 INSERT INTO flavortext VALUES (1,'rb','A strange seed was planted in its back at birth.  The plant sprouts and grows with this Pokemon.'), 
     594LOCK TABLES flavor_text WRITE; 
     595/*!40000 ALTER TABLE flavor_text DISABLE KEYS */; 
     596INSERT INTO flavor_text VALUES (1,'rb','A strange seed was planted in its back at birth.  The plant sprouts and grows with this Pokemon.'), 
    602597(1,'y','It can go for days without eating a single morsel.  In the bulb on its back, it stores energy.'), 
    603598(1,'g','The seed on its back is filled with nutrients. The seed grows steadily larger as its body grows.'), 
    … …  
    40854080(492,'p','It can dissolve toxins in the air to instantly transform ruined land into a lush field of flowers.'), 
    40864081(493,'p','It is told in mythology that this Pokémon was born before the universe even existed.'); 
    4087 /*!40000 ALTER TABLE flavortext ENABLE KEYS */; 
     4082/*!40000 ALTER TABLE flavor_text ENABLE KEYS */; 
    40884083UNLOCK TABLES; 
    40894084 
    … …  
    41304125  happiness3 tinyint(4) NOT NULL, 
    41314126  is_underground tinyint(1) NOT NULL, 
    4132   dpblurb varchar(128) NOT NULL, 
     4127  blurb_dp varchar(128) NOT NULL, 
    41334128  description text NOT NULL, 
    41344129  PRIMARY KEY  (id) 
    4135 ) ENGINE=InnoDB DEFAULT CHARSET=utf8; 
     4130) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC; 
    41364131 
    41374132-- 
    … …  
    1153211527  generation tinyint(3) unsigned NOT NULL default '0', 
    1153311528  cost smallint(3) unsigned NOT NULL default '0', 
    11534   moveid smallint(5) unsigned NOT NULL default '0', 
     11529  move_id smallint(5) unsigned NOT NULL default '0', 
    1153511530  location tinytext NOT NULL, 
    1153611531  PRIMARY KEY  (id,generation) 
    … …  
    1182911824  power tinyint(3) unsigned default NULL, 
    1183011825  pp tinyint(2) NOT NULL default '0', 
    11831   acc tinyint(3) unsigned NOT NULL default '0', 
     11826  accuracy tinyint(3) unsigned NOT NULL default '0', 
    1183211827  target enum('all','allies','ally','enemies','enemy','enemyfield','lastenemy','others','randenemy','unknown1','unknown2','user') NOT NULL, 
    1183311828  class enum('physical','special','none') NOT NULL, 
    … …  
    1183911834  `status` varchar(25) default NULL, 
    1184011835  move_effect_id int(10) unsigned NOT NULL, 
    11841   gameblurb tinytext NOT NULL, 
    11842   dpblurb tinytext character set utf8 NOT NULL, 
    11843   contype enum('cute','tough','smart','cool','beauty') NOT NULL default 'cute', 
    11844   coneffect tinyint(4) NOT NULL default '0', 
     11836  blurb_rusa tinytext NOT NULL, 
     11837  blurb_dp tinytext character set utf8 NOT NULL, 
     11838  contest_type enum('cute','tough','smart','cool','beauty') NOT NULL default 'cute', 
     11839  contest_effect_id tinyint(4) NOT NULL default '0', 
    1184511840  notes text, 
    11846   newflags char(13) default NULL, 
     11841  XXX_new_flags char(13) default NULL, 
    1184711842  PRIMARY KEY  (id) 
    1184811843) ENGINE=MyISAM DEFAULT CHARSET=latin1; 
    … …  
    1234312338  id int(10) unsigned NOT NULL, 
    1234412339  priority tinyint(4) NOT NULL,