-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathpokemon.sql
More file actions
46 lines (39 loc) · 35 KB
/
Copy pathpokemon.sql
File metadata and controls
46 lines (39 loc) · 35 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
CREATE DATABASE pokemon;
USE pokemon;
/*This table lists all the pokemon
id = The unique id for each pokemon (generally follows pokedox number with the exception of subspecies)
pokemon_name = pokemon name
species = this number is the exact pokedex number (Subspecies have different ids)
height = Pokemon Height
weight = pokemon weight
is_default = states whether the pokemon is the base species (1) or a subspecies (2)*/
CREATE TABLE pokemon(
id INTEGER(11) NOT NULL,
pokemon_name VARCHAR(500) NOT NULL,
height INTEGER(5) NOT NULL,
weight INTEGER(5) NOT NULL,
base_experience INTEGER(5) NOT NULL,
is_default INTEGER(5) NOT NULL,
PRIMARY KEY (id)
);
INSERT INTO `pokemon` VALUES (1,'bulbasaur',1,7,69,64,1),(2,'ivysaur',2,10,130,142,1),(3,'venusaur',3,20,1000,236,1),(4,'charmander',4,6,85,62,1),(5,'charmeleon',5,11,190,142,1),(6,'charizard',6,17,905,240,1),(7,'squirtle',7,5,90,63,1),(8,'wartortle',8,10,225,142,1),(9,'blastoise',9,16,855,239,1),(10,'caterpie',10,3,29,39,1),(11,'metapod',11,7,99,72,1),(12,'butterfree',12,11,320,178,1),(13,'weedle',13,3,32,39,1),(14,'kakuna',14,6,100,72,1),(15,'beedrill',15,10,295,178,1),(16,'pidgey',16,3,18,50,1),(17,'pidgeotto',17,11,300,122,1),(18,'pidgeot',18,15,395,216,1),(19,'rattata',19,3,35,51,1),(20,'raticate',20,7,185,145,1),(21,'spearow',21,3,20,52,1),(22,'fearow',22,12,380,155,1),(23,'ekans',23,20,69,58,1),(24,'arbok',24,35,650,153,1),(25,'pikachu',25,4,60,112,1),(26,'raichu',26,8,300,218,1),(27,'sandshrew',27,6,120,60,1),(28,'sandslash',28,10,295,158,1),(29,'nidoran-f',29,4,70,55,1),(30,'nidorina',30,8,200,128,1),(31,'nidoqueen',31,13,600,227,1),(32,'nidoran-m',32,5,90,55,1),(33,'nidorino',33,9,195,128,1),(34,'nidoking',34,14,620,227,1),(35,'clefairy',35,6,75,113,1),(36,'clefable',36,13,400,217,1),(37,'vulpix',37,6,99,60,1),(38,'ninetales',38,11,199,177,1),(39,'jigglypuff',39,5,55,95,1),(40,'wigglytuff',40,10,120,196,1),(41,'zubat',41,8,75,49,1),(42,'golbat',42,16,550,159,1),(43,'oddish',43,5,54,64,1),(44,'gloom',44,8,86,138,1),(45,'vileplume',45,12,186,221,1),(46,'paras',46,3,54,57,1),(47,'parasect',47,10,295,142,1),(48,'venonat',48,10,300,61,1),(49,'venomoth',49,15,125,158,1),(50,'diglett',50,2,8,53,1),(51,'dugtrio',51,7,333,142,1),(52,'meowth',52,4,42,58,1),(53,'persian',53,10,320,154,1),(54,'psyduck',54,8,196,64,1),(55,'golduck',55,17,766,175,1),(56,'mankey',56,5,280,61,1),(57,'primeape',57,10,320,159,1),(58,'growlithe',58,7,190,70,1),(59,'arcanine',59,19,1550,194,1),(60,'poliwag',60,6,124,60,1),(61,'poliwhirl',61,10,200,135,1),(62,'poliwrath',62,13,540,230,1),(63,'abra',63,9,195,62,1),(64,'kadabra',64,13,565,140,1),(65,'alakazam',65,15,480,225,1),(66,'machop',66,8,195,61,1),(67,'machoke',67,15,705,142,1),(68,'machamp',68,16,1300,227,1),(69,'bellsprout',69,7,40,60,1),(70,'weepinbell',70,10,64,137,1),(71,'victreebel',71,17,155,221,1),(72,'tentacool',72,9,455,67,1),(73,'tentacruel',73,16,550,180,1),(74,'geodude',74,4,200,60,1),(75,'graveler',75,10,1050,137,1),(76,'golem',76,14,3000,223,1),(77,'ponyta',77,10,300,82,1),(78,'rapidash',78,17,950,175,1),(79,'slowpoke',79,12,360,63,1),(80,'slowbro',80,16,785,172,1),(81,'magnemite',81,3,60,65,1),(82,'magneton',82,10,600,163,1),(83,'farfetchd',83,8,150,123,1),(84,'doduo',84,14,392,62,1),(85,'dodrio',85,18,852,161,1),(86,'seel',86,11,900,65,1),(87,'dewgong',87,17,1200,166,1),(88,'grimer',88,9,300,65,1),(89,'muk',89,12,300,175,1),(90,'shellder',90,3,40,61,1),(91,'cloyster',91,15,1325,184,1),(92,'gastly',92,13,1,62,1),(93,'haunter',93,16,1,142,1),(94,'gengar',94,15,405,225,1),(95,'onix',95,88,2100,77,1),(96,'drowzee',96,10,324,66,1),(97,'hypno',97,16,756,169,1),(98,'krabby',98,4,65,65,1),(99,'kingler',99,13,600,166,1),(100,'voltorb',100,5,104,66,1),(101,'electrode',101,12,666,168,1),(102,'exeggcute',102,4,25,65,1),(103,'exeggutor',103,20,1200,182,1),(104,'cubone',104,4,65,64,1),(105,'marowak',105,10,450,149,1),(106,'hitmonlee',106,15,498,159,1),(107,'hitmonchan',107,14,502,159,1),(108,'lickitung',108,12,655,77,1),(109,'koffing',109,6,10,68,1),(110,'weezing',110,12,95,172,1),(111,'rhyhorn',111,10,1150,69,1),(112,'rhydon',112,19,1200,170,1),(113,'chansey',113,11,346,395,1),(114,'tangela',114,10,350,87,1),(115,'kangaskhan',115,22,800,172,1),(116,'horsea',116,4,80,59,1),(117,'seadra',117,12,250,154,1),(118,'goldeen',118,6,150,64,1),(119,'seaking',119,13,390,158,1),(120,'staryu',120,8,345,68,1),(121,'starmie',121,11,800,182,1),(122,'mr-mime',122,13,545,161,1),(123,'scyther',123,15,560,100,1),(124,'jynx',124,14,406,159,1),(125,'electabuzz',125,11,300,172,1),(126,'magmar',126,13,445,173,1),(127,'pinsir',127,15,550,175,1),(128,'tauros',128,14,884,172,1),(129,'magikarp',129,9,100,40,1),(130,'gyarados',130,65,2350,189,1),(131,'lapras',131,25,2200,187,1),(132,'ditto',132,3,40,101,1),(133,'eevee',133,3,65,65,1),(134,'vaporeon',134,10,290,184,1),(135,'jolteon',135,8,245,184,1),(136,'flareon',136,9,250,184,1),(137,'porygon',137,8,365,79,1),(138,'omanyte',138,4,75,71,1),(139,'omastar',139,10,350,173,1),(140,'kabuto',140,5,115,71,1),(141,'kabutops',141,13,405,173,1),(142,'aerodactyl',142,18,590,180,1),(143,'snorlax',143,21,4600,189,1),(144,'articuno',144,17,554,261,1),(145,'zapdos',145,16,526,261,1),(146,'moltres',146,20,600,261,1),(147,'dratini',147,18,33,60,1),(148,'dragonair',148,40,165,147,1),(149,'dragonite',149,22,2100,270,1),(150,'mewtwo',150,20,1220,306,1),(151,'mew',151,4,40,270,1),(152,'chikorita',152,9,64,64,1),(153,'bayleef',153,12,158,142,1),(154,'meganium',154,18,1005,236,1),(155,'cyndaquil',155,5,79,62,1),(156,'quilava',156,9,190,142,1),(157,'typhlosion',157,17,795,240,1),(158,'totodile',158,6,95,63,1),(159,'croconaw',159,11,250,142,1),(160,'feraligatr',160,23,888,239,1),(161,'sentret',161,8,60,43,1),(162,'furret',162,18,325,145,1),(163,'hoothoot',163,7,212,52,1),(164,'noctowl',164,16,408,155,1),(165,'ledyba',165,10,108,53,1),(166,'ledian',166,14,356,137,1),(167,'spinarak',167,5,85,50,1),(168,'ariados',168,11,335,137,1),(169,'crobat',169,18,750,241,1),(170,'chinchou',170,5,120,66,1),(171,'lanturn',171,12,225,161,1),(172,'pichu',172,3,20,41,1),(173,'cleffa',173,3,30,44,1),(174,'igglybuff',174,3,10,42,1),(175,'togepi',175,3,15,49,1),(176,'togetic',176,6,32,142,1),(177,'natu',177,2,20,64,1),(178,'xatu',178,15,150,165,1),(179,'mareep',179,6,78,56,1),(180,'flaaffy',180,8,133,128,1),(181,'ampharos',181,14,615,230,1),(182,'bellossom',182,4,58,221,1),(183,'marill',183,4,85,88,1),(184,'azumarill',184,8,285,189,1),(185,'sudowoodo',185,12,380,144,1),(186,'politoed',186,11,339,225,1),(187,'hoppip',187,4,5,50,1),(188,'skiploom',188,6,10,119,1),(189,'jumpluff',189,8,30,207,1),(190,'aipom',190,8,115,72,1),(191,'sunkern',191,3,18,36,1),(192,'sunflora',192,8,85,149,1),(193,'yanma',193,12,380,78,1),(194,'wooper',194,4,85,42,1),(195,'quagsire',195,14,750,151,1),(196,'espeon',196,9,265,184,1),(197,'umbreon',197,10,270,184,1),(198,'murkrow',198,5,21,81,1),(199,'slowking',199,20,795,172,1),(200,'misdreavus',200,7,10,87,1),(201,'unown',201,5,50,118,1),(202,'wobbuffet',202,13,285,142,1),(203,'girafarig',203,15,415,159,1),(204,'pineco',204,6,72,58,1),(205,'forretress',205,12,1258,163,1),(206,'dunsparce',206,15,140,145,1),(207,'gligar',207,11,648,86,1),(208,'steelix',208,92,4000,179,1),(209,'snubbull',209,6,78,60,1),(210,'granbull',210,14,487,158,1),(211,'qwilfish',211,5,39,86,1),(212,'scizor',212,18,1180,175,1),(213,'shuckle',213,6,205,177,1),(214,'heracross',214,15,540,175,1),(215,'sneasel',215,9,280,86,1),(216,'teddiursa',216,6,88,66,1),(217,'ursaring',217,18,1258,175,1),(218,'slugma',218,7,350,50,1),(219,'magcargo',219,8,550,144,1),(220,'swinub',220,4,65,50,1),(221,'piloswine',221,11,558,158,1),(222,'corsola',222,6,50,133,1),(223,'remoraid',223,6,120,60,1),(224,'octillery',224,9,285,168,1),(225,'delibird',225,9,160,116,1),(226,'mantine',226,21,2200,163,1),(227,'skarmory',227,17,505,163,1),(228,'houndour',228,6,108,66,1),(229,'houndoom',229,14,350,175,1),(230,'kingdra',230,18,1520,243,1),(231,'phanpy',231,5,335,66,1),(232,'donphan',232,11,1200,175,1),(233,'porygon2',233,6,325,180,1),(234,'stantler',234,14,712,163,1),(235,'smeargle',235,12,580,88,1),(236,'tyrogue',236,7,210,42,1),(237,'hitmontop',237,14,480,159,1),(238,'smoochum',238,4,60,61,1),(239,'elekid',239,6,235,72,1),(240,'magby',240,7,214,73,1),(241,'miltank',241,12,755,172,1),(242,'blissey',242,15,468,608,1),(243,'raikou',243,19,1780,261,1),(244,'entei',244,21,1980,261,1),(245,'suicune',245,20,1870,261,1),(246,'larvitar',246,6,720,60,1),(247,'pupitar',247,12,1520,144,1),(248,'tyranitar',248,20,2020,270,1),(249,'lugia',249,52,2160,306,1),(250,'ho-oh',250,38,1990,306,1),(251,'celebi',251,6,50,270,1),(252,'treecko',252,5,50,62,1),(253,'grovyle',253,9,216,142,1),(254,'sceptile',254,17,522,239,1),(255,'torchic',255,4,25,62,1),(256,'combusken',256,9,195,142,1),(257,'blaziken',257,19,520,239,1),(258,'mudkip',258,4,76,62,1),(259,'marshtomp',259,7,280,142,1),(260,'swampert',260,15,819,241,1),(261,'poochyena',261,5,136,44,1),(262,'mightyena',262,10,370,147,1),(263,'zigzagoon',263,4,175,48,1),(264,'linoone',264,5,325,147,1),(265,'wurmple',265,3,36,39,1),(266,'silcoon',266,6,100,72,1),(267,'beautifly',267,10,284,178,1),(268,'cascoon',268,7,115,41,1),(269,'dustox',269,12,316,135,1),(270,'lotad',270,5,26,44,1),(271,'lombre',271,12,325,119,1),(272,'ludicolo',272,15,550,216,1),(273,'seedot',273,5,40,44,1),(274,'nuzleaf',274,10,280,119,1),(275,'shiftry',275,13,596,216,1),(276,'taillow',276,3,23,54,1),(277,'swellow',277,7,198,151,1),(278,'wingull',278,6,95,54,1),(279,'pelipper',279,12,280,151,1),(280,'ralts',280,4,66,40,1),(281,'kirlia',281,8,202,97,1),(282,'gardevoir',282,16,484,233,1),(283,'surskit',283,5,17,54,1),(284,'masquerain',284,8,36,145,1),(285,'shroomish',285,4,45,59,1),(286,'breloom',286,12,392,161,1),(287,'slakoth',287,8,240,56,1),(288,'vigoroth',288,14,465,154,1),(289,'slaking',289,20,1305,252,1),(290,'nincada',290,5,55,53,1),(291,'ninjask',291,8,120,160,1),(292,'shedinja',292,8,12,83,1),(293,'whismur',293,6,163,48,1),(294,'loudred',294,10,405,126,1),(295,'exploud',295,15,840,221,1),(296,'makuhita',296,10,864,47,1),(297,'hariyama',297,23,2538,166,1),(298,'azurill',298,2,20,38,1),(299,'nosepass',299,10,970,75,1),(300,'skitty',300,6,110,52,1),(301,'delcatty',301,11,326,133,1),(302,'sableye',302,5,110,133,1),(303,'mawile',303,6,115,133,1),(304,'aron',304,4,600,66,1),(305,'lairon',305,9,1200,151,1),(306,'aggron',306,21,3600,239,1),(307,'meditite',307,6,112,56,1),(308,'medicham',308,13,315,144,1),(309,'electrike',309,6,152,59,1),(310,'manectric',310,15,402,166,1),(311,'plusle',311,4,42,142,1),(312,'minun',312,4,42,142,1),(313,'volbeat',313,7,177,140,1),(314,'illumise',314,6,177,140,1),(315,'roselia',315,3,20,140,1),(316,'gulpin',316,4,103,60,1),(317,'swalot',317,17,800,163,1),(318,'carvanha',318,8,208,61,1),(319,'sharpedo',319,18,888,161,1),(320,'wailmer',320,20,1300,80,1),(321,'wailord',321,145,3980,175,1),(322,'numel',322,7,240,61,1),(323,'camerupt',323,19,2200,161,1),(324,'torkoal',324,5,804,165,1),(325,'spoink',325,7,306,66,1),(326,'grumpig',326,9,715,165,1),(327,'spinda',327,11,50,126,1),(328,'trapinch',328,7,150,58,1),(329,'vibrava',329,11,153,119,1),(330,'flygon',330,20,820,234,1),(331,'cacnea',331,4,513,67,1),(332,'cacturne',332,13,774,166,1),(333,'swablu',333,4,12,62,1),(334,'altaria',334,11,206,172,1),(335,'zangoose',335,13,403,160,1),(336,'seviper',336,27,525,160,1),(337,'lunatone',337,10,1680,154,1),(338,'solrock',338,12,1540,154,1),(339,'barboach',339,4,19,58,1),(340,'whiscash',340,9,236,164,1),(341,'corphish',341,6,115,62,1),(342,'crawdaunt',342,11,328,164,1),(343,'baltoy',343,5,215,60,1),(344,'claydol',344,15,1080,175,1),(345,'lileep',345,10,238,71,1),(346,'cradily',346,15,604,173,1),(347,'anorith',347,7,125,71,1),(348,'armaldo',348,15,682,173,1),(349,'feebas',349,6,74,40,1),(350,'milotic',350,62,1620,189,1),(351,'castform',351,3,8,147,1),(352,'kecleon',352,10,220,154,1),(353,'shuppet',353,6,23,59,1),(354,'banette',354,11,125,159,1),(355,'duskull',355,8,150,59,1),(356,'dusclops',356,16,306,159,1),(357,'tropius',357,20,1000,161,1),(358,'chimecho',358,6,10,149,1),(359,'absol',359,12,470,163,1),(360,'wynaut',360,6,140,52,1),(361,'snorunt',361,7,168,60,1),(362,'glalie',362,15,2565,168,1),(363,'spheal',363,8,395,58,1),(364,'sealeo',364,11,876,144,1),(365,'walrein',365,14,1506,239,1),(366,'clamperl',366,4,525,69,1),(367,'huntail',367,17,270,170,1),(368,'gorebyss',368,18,226,170,1),(369,'relicanth',369,10,234,170,1),(370,'luvdisc',370,6,87,116,1),(371,'bagon',371,6,421,60,1),(372,'shelgon',372,11,1105,147,1),(373,'salamence',373,15,1026,270,1),(374,'beldum',374,6,952,60,1),(375,'metang',375,12,2025,147,1),(376,'metagross',376,16,5500,270,1),(377,'regirock',377,17,2300,261,1),(378,'regice',378,18,1750,261,1),(379,'registeel',379,19,2050,261,1),(380,'latias',380,14,400,270,1),(381,'latios',381,20,600,270,1),(382,'kyogre',382,45,3520,302,1),(383,'groudon',383,35,9500,302,1),(384,'rayquaza',384,70,2065,306,1),(385,'jirachi',385,3,11,270,1),(386,'deoxys-normal',386,17,608,270,1),(387,'turtwig',387,4,102,64,1),(388,'grotle',388,11,970,142,1),(389,'torterra',389,22,3100,236,1),(390,'chimchar',390,5,62,62,1),(391,'monferno',391,9,220,142,1),(392,'infernape',392,12,550,240,1),(393,'piplup',393,4,52,63,1),(394,'prinplup',394,8,230,142,1),(395,'empoleon',395,17,845,239,1),(396,'starly',396,3,20,49,1),(397,'staravia',397,6,155,119,1),(398,'staraptor',398,12,249,218,1),(399,'bidoof',399,5,200,50,1),(400,'bibarel',400,10,315,144,1),(401,'kricketot',401,3,22,39,1),(402,'kricketune',402,10,255,134,1),(403,'shinx',403,5,95,53,1),(404,'luxio',404,9,305,127,1),(405,'luxray',405,14,420,235,1),(406,'budew',406,2,12,56,1),(407,'roserade',407,9,145,232,1),(408,'cranidos',408,9,315,70,1),(409,'rampardos',409,16,1025,173,1),(410,'shieldon',410,5,570,70,1),(411,'bastiodon',411,13,1495,173,1),(412,'burmy',412,2,34,45,1),(413,'wormadam-plant',413,5,65,148,1),(414,'mothim',414,9,233,148,1),(415,'combee',415,3,55,49,1),(416,'vespiquen',416,12,385,166,1),(417,'pachirisu',417,4,39,142,1),(418,'buizel',418,7,295,66,1),(419,'floatzel',419,11,335,173,1),(420,'cherubi',420,4,33,55,1),(421,'cherrim',421,5,93,158,1),(422,'shellos',422,3,63,65,1),(423,'gastrodon',423,9,299,166,1),(424,'ambipom',424,12,203,169,1),(425,'drifloon',425,4,12,70,1),(426,'drifblim',426,12,150,174,1),(427,'buneary',427,4,55,70,1),(428,'lopunny',428,12,333,168,1),(429,'mismagius',429,9,44,173,1),(430,'honchkrow',430,9,273,177,1),(431,'glameow',431,5,39,62,1),(432,'purugly',432,10,438,158,1),(433,'chingling',433,2,6,57,1),(434,'stunky',434,4,192,66,1),(435,'skuntank',435,10,380,168,1),(436,'bronzor',436,5,605,60,1),(437,'bronzong',437,13,1870,175,1),(438,'bonsly',438,5,150,58,1),(439,'mime-jr',439,6,130,62,1),(440,'happiny',440,6,244,110,1),(441,'chatot',441,5,19,144,1),(442,'spiritomb',442,10,1080,170,1),(443,'gible',443,7,205,60,1),(444,'gabite',444,14,560,144,1),(445,'garchomp',445,19,950,270,1),(446,'munchlax',446,6,1050,78,1),(447,'riolu',447,7,202,57,1),(448,'lucario',448,12,540,184,1),(449,'hippopotas',449,8,495,66,1),(450,'hippowdon',450,20,3000,184,1),(451,'skorupi',451,8,120,66,1),(452,'drapion',452,13,615,175,1),(453,'croagunk',453,7,230,60,1),(454,'toxicroak',454,13,444,172,1),(455,'carnivine',455,14,270,159,1),(456,'finneon',456,4,70,66,1),(457,'lumineon',457,12,240,161,1),(458,'mantyke',458,10,650,69,1),(459,'snover',459,10,505,67,1),(460,'abomasnow',460,22,1355,173,1),(461,'weavile',461,11,340,179,1),(462,'magnezone',462,12,1800,241,1),(463,'lickilicky',463,17,1400,180,1),(464,'rhyperior',464,24,2828,241,1),(465,'tangrowth',465,20,1286,187,1),(466,'electivire',466,18,1386,243,1),(467,'magmortar',467,16,680,243,1),(468,'togekiss',468,15,380,245,1),(469,'yanmega',469,19,515,180,1),(470,'leafeon',470,10,255,184,1),(471,'glaceon',471,8,259,184,1),(472,'gliscor',472,20,425,179,1),(473,'mamoswine',473,25,2910,239,1),(474,'porygon-z',474,9,340,241,1),(475,'gallade',475,16,520,233,1),(476,'probopass',476,14,3400,184,1),(477,'dusknoir',477,22,1066,236,1),(478,'froslass',478,13,266,168,1),(479,'rotom',479,3,3,154,1),(480,'uxie',480,3,3,261,1),(481,'mesprit',481,3,3,261,1),(482,'azelf',482,3,3,261,1),(483,'dialga',483,54,6830,306,1),(484,'palkia',484,42,3360,306,1),(485,'heatran',485,17,4300,270,1),(486,'regigigas',486,37,4200,302,1),(487,'giratina-altered',487,45,7500,306,1),(488,'cresselia',488,15,856,270,1),(489,'phione',489,4,31,216,1),(490,'manaphy',490,3,14,270,1),(491,'darkrai',491,15,505,270,1),(492,'shaymin-land',492,2,21,270,1),(493,'arceus',493,32,3200,324,1),(494,'victini',494,4,40,270,1),(495,'snivy',495,6,81,62,1),(496,'servine',496,8,160,145,1),(497,'serperior',497,33,630,238,1),(498,'tepig',498,5,99,62,1),(499,'pignite',499,10,555,146,1),(500,'emboar',500,16,1500,238,1),(501,'oshawott',501,5,59,62,1),(502,'dewott',502,8,245,145,1),(503,'samurott',503,15,946,238,1),(504,'patrat',504,5,116,51,1),(505,'watchog',505,11,270,147,1),(506,'lillipup',506,4,41,55,1),(507,'herdier',507,9,147,130,1),(508,'stoutland',508,12,610,225,1),(509,'purrloin',509,4,101,56,1),(510,'liepard',510,11,375,156,1),(511,'pansage',511,6,105,63,1),(512,'simisage',512,11,305,174,1),(513,'pansear',513,6,110,63,1),(514,'simisear',514,10,280,174,1),(515,'panpour',515,6,135,63,1),(516,'simipour',516,10,290,174,1),(517,'munna',517,6,233,58,1),(518,'musharna',518,11,605,170,1),(519,'pidove',519,3,21,53,1),(520,'tranquill',520,6,150,125,1),(521,'unfezant',521,12,290,220,1),(522,'blitzle',522,8,298,59,1),(523,'zebstrika',523,16,795,174,1),(524,'roggenrola',524,4,180,56,1),(525,'boldore',525,9,1020,137,1),(526,'gigalith',526,17,2600,232,1),(527,'woobat',527,4,21,63,1),(528,'swoobat',528,9,105,149,1),(529,'drilbur',529,3,85,66,1),(530,'excadrill',530,7,404,178,1),(531,'audino',531,11,310,390,1),(532,'timburr',532,6,125,61,1),(533,'gurdurr',533,12,400,142,1),(534,'conkeldurr',534,14,870,227,1),(535,'tympole',535,5,45,59,1),(536,'palpitoad',536,8,170,134,1),(537,'seismitoad',537,15,620,229,1),(538,'throh',538,13,555,163,1),(539,'sawk',539,14,510,163,1),(540,'sewaddle',540,3,25,62,1),(541,'swadloon',541,5,73,133,1),(542,'leavanny',542,12,205,225,1),(543,'venipede',543,4,53,52,1),(544,'whirlipede',544,12,585,126,1),(545,'scolipede',545,25,2005,218,1),(546,'cottonee',546,3,6,56,1),(547,'whimsicott',547,7,66,168,1),(548,'petilil',548,5,66,56,1),(549,'lilligant',549,11,163,168,1),(550,'basculin-red-striped',550,10,180,161,1),(551,'sandile',551,7,152,58,1),(552,'krokorok',552,10,334,123,1),(553,'krookodile',553,15,963,234,1),(554,'darumaka',554,6,375,63,1),(555,'darmanitan-standard',555,13,929,168,1),(556,'maractus',556,10,280,161,1),(557,'dwebble',557,3,145,65,1),(558,'crustle',558,14,2000,166,1),(559,'scraggy',559,6,118,70,1),(560,'scrafty',560,11,300,171,1),(561,'sigilyph',561,14,140,172,1),(562,'yamask',562,5,15,61,1),(563,'cofagrigus',563,17,765,169,1),(564,'tirtouga',564,7,165,71,1),(565,'carracosta',565,12,810,173,1),(566,'archen',566,5,95,71,1),(567,'archeops',567,14,320,177,1),(568,'trubbish',568,6,310,66,1),(569,'garbodor',569,19,1073,166,1),(570,'zorua',570,7,125,66,1),(571,'zoroark',571,16,811,179,1),(572,'minccino',572,4,58,60,1),(573,'cinccino',573,5,75,165,1),(574,'gothita',574,4,58,58,1),(575,'gothorita',575,7,180,137,1),(576,'gothitelle',576,15,440,221,1),(577,'solosis',577,3,10,58,1),(578,'duosion',578,6,80,130,1),(579,'reuniclus',579,10,201,221,1),(580,'ducklett',580,5,55,61,1),(581,'swanna',581,13,242,166,1),(582,'vanillite',582,4,57,61,1),(583,'vanillish',583,11,410,138,1),(584,'vanilluxe',584,13,575,241,1),(585,'deerling',585,6,195,67,1),(586,'sawsbuck',586,19,925,166,1),(587,'emolga',587,4,50,150,1),(588,'karrablast',588,5,59,63,1),(589,'escavalier',589,10,330,173,1),(590,'foongus',590,2,10,59,1),(591,'amoonguss',591,6,105,162,1),(592,'frillish',592,12,330,67,1),(593,'jellicent',593,22,1350,168,1),(594,'alomomola',594,12,316,165,1),(595,'joltik',595,1,6,64,1),(596,'galvantula',596,8,143,165,1),(597,'ferroseed',597,6,188,61,1),(598,'ferrothorn',598,10,1100,171,1),(599,'klink',599,3,210,60,1),(600,'klang',600,6,510,154,1),(601,'klinklang',601,6,810,234,1),(602,'tynamo',602,2,3,55,1),(603,'eelektrik',603,12,220,142,1),(604,'eelektross',604,21,805,232,1),(605,'elgyem',605,5,90,67,1),(606,'beheeyem',606,10,345,170,1),(607,'litwick',607,3,31,55,1),(608,'lampent',608,6,130,130,1),(609,'chandelure',609,10,343,234,1),(610,'axew',610,6,180,64,1),(611,'fraxure',611,10,360,144,1),(612,'haxorus',612,18,1055,243,1),(613,'cubchoo',613,5,85,61,1),(614,'beartic',614,26,2600,170,1),(615,'cryogonal',615,11,1480,170,1),(616,'shelmet',616,4,77,61,1),(617,'accelgor',617,8,253,173,1),(618,'stunfisk',618,7,110,165,1),(619,'mienfoo',619,9,200,70,1),(620,'mienshao',620,14,355,179,1),(621,'druddigon',621,16,1390,170,1),(622,'golett',622,10,920,61,1),(623,'golurk',623,28,3300,169,1),(624,'pawniard',624,5,102,68,1),(625,'bisharp',625,16,700,172,1),(626,'bouffalant',626,16,946,172,1),(627,'rufflet',627,5,105,70,1),(628,'braviary',628,15,410,179,1),(629,'vullaby',629,5,90,74,1),(630,'mandibuzz',630,12,395,179,1),(631,'heatmor',631,14,580,169,1),(632,'durant',632,3,330,169,1),(633,'deino',633,8,173,60,1),(634,'zweilous',634,14,500,147,1),(635,'hydreigon',635,18,1600,270,1),(636,'larvesta',636,11,288,72,1),(637,'volcarona',637,16,460,248,1),(638,'cobalion',638,21,2500,261,1),(639,'terrakion',639,19,2600,261,1),(640,'virizion',640,20,2000,261,1),(641,'tornadus-incarnate',641,15,630,261,1),(642,'thundurus-incarnate',642,15,610,261,1),(643,'reshiram',643,32,3300,306,1),(644,'zekrom',644,29,3450,306,1),(645,'landorus-incarnate',645,15,680,270,1),(646,'kyurem',646,30,3250,297,1),(647,'keldeo-ordinary',647,14,485,261,1),(648,'meloetta-aria',648,6,65,270,1),(649,'genesect',649,15,825,270,1),(650,'chespin',650,4,90,63,1),(651,'quilladin',651,7,290,142,1),(652,'chesnaught',652,16,900,239,1),(653,'fennekin',653,4,94,61,1),(654,'braixen',654,10,145,143,1),(655,'delphox',655,15,390,240,1),(656,'froakie',656,3,70,63,1),(657,'frogadier',657,6,109,142,1),(658,'greninja',658,15,400,239,1),(659,'bunnelby',659,4,50,47,1),(660,'diggersby',660,10,424,148,1),(661,'fletchling',661,3,17,56,1),(662,'fletchinder',662,7,160,134,1),(663,'talonflame',663,12,245,175,1),(664,'scatterbug',664,3,25,40,1),(665,'spewpa',665,3,84,75,1),(666,'vivillon',666,12,170,185,1),(667,'litleo',667,6,135,74,1),(668,'pyroar',668,15,815,177,1),(669,'flabebe',669,1,1,61,1),(670,'floette',670,2,9,130,1),(671,'florges',671,11,100,248,1),(672,'skiddo',672,9,310,70,1),(673,'gogoat',673,17,910,186,1),(674,'pancham',674,6,80,70,1),(675,'pangoro',675,21,1360,173,1),(676,'furfrou',676,12,280,165,1),(677,'espurr',677,3,35,71,1),(678,'meowstic-male',678,6,85,163,1),(679,'honedge',679,8,20,65,1),(680,'doublade',680,8,45,157,1),(681,'aegislash-shield',681,17,530,234,1),(682,'spritzee',682,2,5,68,1),(683,'aromatisse',683,8,155,162,1),(684,'swirlix',684,4,35,68,1),(685,'slurpuff',685,8,50,168,1),(686,'inkay',686,4,35,58,1),(687,'malamar',687,15,470,169,1),(688,'binacle',688,5,310,61,1),(689,'barbaracle',689,13,960,175,1),(690,'skrelp',690,5,73,64,1),(691,'dragalge',691,18,815,173,1),(692,'clauncher',692,5,83,66,1),(693,'clawitzer',693,13,353,100,1),(694,'helioptile',694,5,60,58,1),(695,'heliolisk',695,10,210,168,1),(696,'tyrunt',696,8,260,72,1),(697,'tyrantrum',697,25,2700,182,1),(698,'amaura',698,13,252,72,1),(699,'aurorus',699,27,2250,104,1),(700,'sylveon',700,10,235,184,1),(701,'hawlucha',701,8,215,175,1),(702,'dedenne',702,2,22,151,1),(703,'carbink',703,3,57,100,1),(704,'goomy',704,3,28,60,1),(705,'sliggoo',705,8,175,158,1),(706,'goodra',706,20,1505,270,1),(707,'klefki',707,2,30,165,1),(708,'phantump',708,4,70,62,1),(709,'trevenant',709,15,710,166,1),(710,'pumpkaboo-average',710,4,50,67,1),(711,'gourgeist-average',711,9,125,173,1),(712,'bergmite',712,10,995,61,1),(713,'avalugg',713,20,5050,180,1),(714,'noibat',714,5,80,49,1),(715,'noivern',715,15,850,187,1),(716,'xerneas',716,30,2150,306,1),(717,'yveltal',717,58,2030,306,1),(718,'zygarde',718,50,3050,270,1),(719,'diancie',719,7,88,270,1),(720,'hoopa',720,5,90,270,1),(721,'volcanion',721,17,1950,270,1),(10001,'deoxys-attack',386,17,608,270,0),(10002,'deoxys-defense',386,17,608,270,0),(10003,'deoxys-speed',386,17,608,270,0),(10004,'wormadam-sandy',413,5,65,148,0),(10005,'wormadam-trash',413,5,65,148,0),(10006,'shaymin-sky',492,4,52,270,0),(10007,'giratina-origin',487,69,6500,306,0),(10008,'rotom-heat',479,3,3,182,0),(10009,'rotom-wash',479,3,3,182,0),(10010,'rotom-frost',479,3,3,182,0),(10011,'rotom-fan',479,3,3,182,0),(10012,'rotom-mow',479,3,3,182,0),(10013,'castform-sunny',351,3,8,147,0),(10014,'castform-rainy',351,3,8,147,0),(10015,'castform-snowy',351,3,8,147,0),(10016,'basculin-blue-striped',550,10,180,161,0),(10017,'darmanitan-zen',555,13,929,189,0),(10018,'meloetta-pirouette',648,6,65,270,0),(10019,'tornadus-therian',641,14,630,261,0),(10020,'thundurus-therian',642,30,610,261,0),(10021,'landorus-therian',645,13,680,270,0),(10022,'kyurem-black',646,33,3250,315,0),(10023,'kyurem-white',646,36,3250,315,0),(10024,'keldeo-resolute',647,14,485,261,0),(10025,'meowstic-female',678,6,85,163,0),(10026,'aegislash-blade',681,17,530,234,0),(10027,'pumpkaboo-small',710,3,35,67,0),(10028,'pumpkaboo-large',710,5,75,67,0),(10029,'pumpkaboo-super',710,8,150,67,0),(10030,'gourgeist-small',711,7,95,173,0),(10031,'gourgeist-large',711,11,140,173,0),(10032,'gourgeist-super',711,17,390,173,0),(10033,'venusaur-mega',3,24,1555,281,0),(10034,'charizard-mega-x',6,17,1105,285,0),(10035,'charizard-mega-y',6,17,1005,285,0),(10036,'blastoise-mega',9,16,1011,284,0),(10037,'alakazam-mega',65,12,480,266,0),(10038,'gengar-mega',94,14,405,270,0),(10039,'kangaskhan-mega',115,22,1000,207,0),(10040,'pinsir-mega',127,17,590,210,0),(10041,'gyarados-mega',130,65,3050,224,0),(10042,'aerodactyl-mega',142,21,790,215,0),(10043,'mewtwo-mega-x',150,23,1270,351,0),(10044,'mewtwo-mega-y',150,15,330,351,0),(10045,'ampharos-mega',181,14,615,275,0),(10046,'scizor-mega',212,20,1250,210,0),(10047,'heracross-mega',214,17,625,210,0),(10048,'houndoom-mega',229,19,495,210,0),(10049,'tyranitar-mega',248,25,2550,315,0),(10050,'blaziken-mega',257,19,520,284,0),(10051,'gardevoir-mega',282,16,484,278,0),(10052,'mawile-mega',303,10,235,168,0),(10053,'aggron-mega',306,22,3950,284,0),(10054,'medicham-mega',308,13,315,179,0),(10055,'manectric-mega',310,18,440,201,0),(10056,'banette-mega',354,12,130,194,0),(10057,'absol-mega',359,12,490,198,0),(10058,'garchomp-mega',445,19,950,315,0),(10059,'lucario-mega',448,13,575,219,0),(10060,'abomasnow-mega',460,27,1850,208,0),(10061,'floette-eternal',670,2,9,243,0),(10062,'latias-mega',380,18,520,315,0),(10063,'latios-mega',381,23,700,315,0),(10064,'swampert-mega',260,19,1020,286,0),(10065,'sceptile-mega',254,19,552,284,0),(10066,'sableye-mega',302,5,1610,168,0),(10067,'altaria-mega',334,15,206,207,0),(10068,'gallade-mega',475,16,564,278,0),(10069,'audino-mega',531,15,320,425,0),(10070,'sharpedo-mega',319,25,1303,196,0),(10071,'slowbro-mega',80,20,1200,207,0),(10072,'steelix-mega',208,105,7400,214,0),(10073,'pidgeot-mega',18,22,505,261,0),(10074,'glalie-mega',362,21,3502,203,0),(10075,'diancie-mega',719,11,278,315,0),(10076,'metagross-mega',376,25,9429,315,0),(10077,'kyogre-primal',382,98,4300,347,0),(10078,'groudon-primal',383,50,9997,347,0),(10079,'rayquaza-mega',384,108,3920,351,0),(10080,'pikachu-rock-star',25,4,60,112,0),(10081,'pikachu-belle',25,4,60,112,0),(10082,'pikachu-pop-star',25,4,60,112,0),(10083,'pikachu-phd',25,4,60,112,0),(10084,'pikachu-libre',25,4,60,112,0),(10085,'pikachu-cosplay',25,4,60,112,0),(10086,'hoopa-unbound',720,65,4900,306,0),(10087,'camerupt-mega',323,25,3205,196,0),(10088,'lopunny-mega',428,13,283,203,0),(10089,'salamence-mega',373,18,1126,315,0),(10090,'beedrill-mega',15,14,405,223,0);
/*This table list all the different type possibilities for pokemon
id = The unique id for each type
identifier = the actual word name for the type
generation_id = the pokemon generation which the type was introduced*/
CREATE TABLE types(
id INTEGER(11) NOT NULL,
identifier VARCHAR(500) NOT NULL,
generation_id INTEGER(5) NOT NULL,
PRIMARY KEY (id)
);
INSERT INTO `types` VALUES (1,'normal',1),(2,'fighting',1),(3,'flying',1),(4,'poison',1),(5,'ground',1),(6,'rock',1),(7,'bug',1),(8,'ghost',1),(9,'steel',2),(10,'fire',1),(11,'water',1),(12,'grass',1),(13,'electric',1),(14,'psychic',1),(15,'ice',1),(16,'dragon',1),(17,'dark',2),(18,'fairy',6),(10001,'unknown',2),(10002,'shadow',3);
/*This is an intermediate table that ties all the pokemon to their types
pokemon_id = The unique id for each pokemon just like the pokemon table(generally follows pokedox number with the exception of subspecies)
type_id = the unique id for each type just like the types table*/
CREATE TABLE pokemon_types(
pokemon_id INTEGER(11) NOT NULL,
type_id INTEGER(5) NOT NULL,
PRIMARY KEY (pokemon_id)
);
INSERT INTO `pokemon_types` VALUES (1,12),(2,12),(3,12),(4,10),(5,10),(6,10),(7,11),(8,11),(9,11),(10,7),(11,7),(12,7),(13,7),(14,7),(15,7),(16,1),(17,1),(18,1),(19,1),(20,1),(21,1),(22,1),(23,4),(24,4),(25,13),(26,13),(27,5),(28,5),(29,4),(30,4),(31,4),(32,4),(33,4),(34,4),(35,18),(36,18),(37,10),(38,10),(39,1),(40,1),(41,4),(42,4),(43,12),(44,12),(45,12),(46,7),(47,7),(48,7),(49,7),(50,5),(51,5),(52,1),(53,1),(54,11),(55,11),(56,2),(57,2),(58,10),(59,10),(60,11),(61,11),(62,11),(63,14),(64,14),(65,14),(66,2),(67,2),(68,2),(69,12),(70,12),(71,12),(72,11),(73,11),(74,6),(75,6),(76,6),(77,10),(78,10),(79,11),(80,11),(81,13),(82,13),(83,1),(84,1),(85,1),(86,11),(87,11),(88,4),(89,4),(90,11),(91,11),(92,8),(93,8),(94,8),(95,6),(96,14),(97,14),(98,11),(99,11),(100,13),(101,13),(102,12),(103,12),(104,5),(105,5),(106,2),(107,2),(108,1),(109,4),(110,4),(111,5),(112,5),(113,1),(114,12),(115,1),(116,11),(117,11),(118,11),(119,11),(120,11),(121,11),(122,14),(123,7),(124,15),(125,13),(126,10),(127,7),(128,1),(129,11),(130,11),(131,11),(132,1),(133,1),(134,11),(135,13),(136,10),(137,1),(138,6),(139,6),(140,6),(141,6),(142,6),(143,1),(144,15),(145,13),(146,10),(147,16),(148,16),(149,16),(150,14),(151,14),(152,12),(153,12),(154,12),(155,10),(156,10),(157,10),(158,11),(159,11),(160,11),(161,1),(162,1),(163,1),(164,1),(165,7),(166,7),(167,7),(168,7),(169,4),(170,11),(171,11),(172,13),(173,18),(174,1),(175,18),(176,18),(177,14),(178,14),(179,13),(180,13),(181,13),(182,12),(183,11),(184,11),(185,6),(186,11),(187,12),(188,12),(189,12),(190,1),(191,12),(192,12),(193,7),(194,11),(195,11),(196,14),(197,17),(198,17),(199,11),(200,8),(201,14),(202,14),(203,1),(204,7),(205,7),(206,1),(207,5),(208,9),(209,18),(210,18),(211,11),(212,7),(213,7),(214,7),(215,17),(216,1),(217,1),(218,10),(219,10),(220,15),(221,15),(222,11),(223,11),(224,11),(225,15),(226,11),(227,9),(228,17),(229,17),(230,11),(231,5),(232,5),(233,1),(234,1),(235,1),(236,2),(237,2),(238,15),(239,13),(240,10),(241,1),(242,1),(243,13),(244,10),(245,11),(246,6),(247,6),(248,6),(249,14),(250,10),(251,14),(252,12),(253,12),(254,12),(255,10),(256,10),(257,10),(258,11),(259,11),(260,11),(261,17),(262,17),(263,1),(264,1),(265,7),(266,7),(267,7),(268,7),(269,7),(270,11),(271,11),(272,11),(273,12),(274,12),(275,12),(276,1),(277,1),(278,11),(279,11),(280,14),(281,14),(282,14),(283,7),(284,7),(285,12),(286,12),(287,1),(288,1),(289,1),(290,7),(291,7),(292,7),(293,1),(294,1),(295,1),(296,2),(297,2),(298,1),(299,6),(300,1),(301,1),(302,17),(303,9),(304,9),(305,9),(306,9),(307,2),(308,2),(309,13),(310,13),(311,13),(312,13),(313,7),(314,7),(315,12),(316,4),(317,4),(318,11),(319,11),(320,11),(321,11),(322,10),(323,10),(324,10),(325,14),(326,14),(327,1),(328,5),(329,5),(330,5),(331,12),(332,12),(333,1),(334,16),(335,1),(336,4),(337,6),(338,6),(339,11),(340,11),(341,11),(342,11),(343,5),(344,5),(345,6),(346,6),(347,6),(348,6),(349,11),(350,11),(351,1),(352,1),(353,8),(354,8),(355,8),(356,8),(357,12),(358,14),(359,17),(360,14),(361,15),(362,15),(363,15),(364,15),(365,15),(366,11),(367,11),(368,11),(369,11),(370,11),(371,16),(372,16),(373,16),(374,9),(375,9),(376,9),(377,6),(378,15),(379,9),(380,16),(381,16),(382,11),(383,5),(384,16),(385,9),(386,14),(387,12),(388,12),(389,12),(390,10),(391,10),(392,10),(393,11),(394,11),(395,11),(396,1),(397,1),(398,1),(399,1),(400,1),(401,7),(402,7),(403,13),(404,13),(405,13),(406,12),(407,12),(408,6),(409,6),(410,6),(411,6),(412,7),(413,7),(414,7),(415,7),(416,7),(417,13),(418,11),(419,11),(420,12),(421,12),(422,11),(423,11),(424,1),(425,8),(426,8),(427,1),(428,1),(429,8),(430,17),(431,1),(432,1),(433,14),(434,4),(435,4),(436,9),(437,9),(438,6),(439,14),(440,1),(441,1),(442,8),(443,16),(444,16),(445,16),(446,1),(447,2),(448,2),(449,5),(450,5),(451,4),(452,4),(453,4),(454,4),(455,12),(456,11),(457,11),(458,11),(459,12),(460,12),(461,17),(462,13),(463,1),(464,5),(465,12),(466,13),(467,10),(468,18),(469,7),(470,12),(471,15),(472,5),(473,15),(474,1),(475,14),(476,6),(477,8),(478,15),(479,13),(480,14),(481,14),(482,14),(483,9),(484,11),(485,10),(486,1),(487,8),(488,14),(489,11),(490,11),(491,17),(492,12),(493,1),(494,14),(495,12),(496,12),(497,12),(498,10),(499,10),(500,10),(501,11),(502,11),(503,11),(504,1),(505,1),(506,1),(507,1),(508,1),(509,17),(510,17),(511,12),(512,12),(513,10),(514,10),(515,11),(516,11),(517,14),(518,14),(519,1),(520,1),(521,1),(522,13),(523,13),(524,6),(525,6),(526,6),(527,14),(528,14),(529,5),(530,5),(531,1),(532,2),(533,2),(534,2),(535,11),(536,11),(537,11),(538,2),(539,2),(540,7),(541,7),(542,7),(543,7),(544,7),(545,7),(546,12),(547,12),(548,12),(549,12),(550,11),(551,5),(552,5),(553,5),(554,10),(555,10),(556,12),(557,7),(558,7),(559,17),(560,17),(561,14),(562,8),(563,8),(564,11),(565,11),(566,6),(567,6),(568,4),(569,4),(570,17),(571,17),(572,1),(573,1),(574,14),(575,14),(576,14),(577,14),(578,14),(579,14),(580,11),(581,11),(582,15),(583,15),(584,15),(585,1),(586,1),(587,13),(588,7),(589,7),(590,12),(591,12),(592,11),(593,11),(594,11),(595,7),(596,7),(597,12),(598,12),(599,9),(600,9),(601,9),(602,13),(603,13),(604,13),(605,14),(606,14),(607,8),(608,8),(609,8),(610,16),(611,16),(612,16),(613,15),(614,15),(615,15),(616,7),(617,7),(618,5),(619,2),(620,2),(621,16),(622,5),(623,5),(624,17),(625,17),(626,1),(627,1),(628,1),(629,17),(630,17),(631,10),(632,7),(633,17),(634,17),(635,17),(636,7),(637,7),(638,9),(639,6),(640,12),(641,3),(642,13),(643,16),(644,16),(645,5),(646,16),(647,11),(648,1),(649,7),(650,12),(651,12),(652,12),(653,10),(654,10),(655,10),(656,11),(657,11),(658,11),(659,1),(660,1),(661,1),(662,10),(663,10),(664,7),(665,7),(666,7),(667,10),(668,10),(669,18),(670,18),(671,18),(672,12),(673,12),(674,2),(675,2),(676,1),(677,14),(678,14),(679,9),(680,9),(681,9),(682,18),(683,18),(684,18),(685,18),(686,17),(687,17),(688,6),(689,6),(690,4),(691,4),(692,11),(693,11),(694,13),(695,13),(696,6),(697,6),(698,6),(699,6),(700,18),(701,2),(702,13),(703,6),(704,16),(705,16),(706,16),(707,9),(708,8),(709,8),(710,8),(711,8),(712,15),(713,15),(714,3),(715,3),(716,18),(717,17),(718,16),(719,6),(720,14),(721,10),(10001,14),(10002,14),(10003,14),(10004,7),(10005,7),(10006,12),(10007,8),(10008,13),(10009,13),(10010,13),(10011,13),(10012,13),(10013,10),(10014,11),(10015,15),(10016,11),(10017,10),(10018,1),(10019,3),(10020,13),(10021,5),(10022,16),(10023,16),(10024,11),(10025,14),(10026,9),(10027,8),(10028,8),(10029,8),(10030,8),(10031,8),(10032,8),(10033,12),(10034,10),(10035,10),(10036,11),(10037,14),(10038,8),(10039,1),(10040,7),(10041,11),(10042,6),(10043,14),(10044,14),(10045,13),(10046,7),(10047,7),(10048,17),(10049,6),(10050,10),(10051,14),(10052,9),(10053,9),(10054,2),(10055,13),(10056,8),(10057,17),(10058,16),(10059,2),(10060,12),(10061,18),(10062,16),(10063,16),(10064,11),(10065,12),(10066,17),(10067,16),(10068,14),(10069,1),(10070,11),(10071,11),(10072,9),(10073,1),(10074,15),(10075,6),(10076,9),(10077,11),(10078,5),(10079,16),(10080,13),(10081,13),(10082,13),(10083,13),(10084,13),(10085,13),(10086,14),(10087,10),(10088,1),(10089,16),(10090,7);