create table pokedex (id smallint not null auto_increment, kid smallint, name varchar(20), type1 varchar(10), type2 varchar(10), PRIMARY KEY (id));
INSERT INTO pokedex (kid,name,type1,type2) VALUES
("001","Bulbasaur","Grass","Poison"),
("002","Ivysaur","Grass","Poison"),
("003","Venusaur","Grass","Poison"),
("004","Charmander","Fire","none"),
("005","Charmeleon","Fire","none"),
("006","Charizard","Fire","Flying"),
("007","Squirtle","Water","none"),
("008","Wartortle","Water","none"),
("009","Blastoise","Water","none"),
("010","Caterpie","Bug","none"),
("011","Metapod","Bug","none"),
("012","Butterfree","Bug","Flying"),
("013","Weedle","Bug","Poison"),
("014","Kakuna","Bug","Poison"),
("015","Beedrill","Bug","Poison"),
("016","Pidgey","Normal","Flying"),
("017","Pidgeotto","Normal","Flying"),
("018","Pidgeot","Normal","Flying"),
("019","Rattata","Normal","none"),
("020","Raticate","Normal","none"),
("021","Spearow","Normal","Flying"),
("022","Fearow","Normal","Flying"),
("023","Ekans","Poison","none"),
("024","Arbok","Poison","none"),
("025","Pikachu","Electric","none"),
("026","Raichu","Electric","none"),
("027","Sandshrew","Ground","none"),
("028","Sandslash","Ground","none"),
("029","Nidoran(f)","Poison","none"),
("030","Nidorina","Poison","none"),
("031","Nidoqueen","Poison","Ground"),
("032","Nidoran(m)","Poison","none"),
("033","Nidorino","Poison","none"),
("034","Nidoking","Poison","Ground"),
("035","Clefairy","Normal","none"),
("036","Clefable","Normal","none"),
("037","Vulpix","Fire","none"),
("038","Ninetales","Fire","none"),
("039","Jigglypuff","Normal","none"),
("040","Wigglytuff","Normal","none"),
("041","Zubat","Poison","Flying"),
("042","Golbat","Poison","Flying"),
("043","Oddish","Grass","Poison"),
("044","Gloom","Grass","Poison"),
("045","Vileplume","Grass","Poison"),
("046","Paras","Bug","Grass"),
("047","Parasect","Bug","Grass"),
("048","Venonat","Bug","Poison"),
("049","Venomoth","Bug","Poison"),
("050","Diglett","Ground","none"),
("051","Dugtrio","Ground","none"),
("052","Meowth","Normal","none"),
("053","Persian","Normal","none"),
("054","Psyduck","Water","none"),
("055","Golduck","Water","none"),
("056","Mankey","Fighting","none"),
("057","Primeape","Fighting","none"),
("058","Growlithe","Fire","none"),
("059","Arcanine","Fire","none"),
("060","Poliwag","Water","none"),
("061","Poliwhirl","Water","none"),
("062","Poliwrath","Water","Fighting"),
("063","Abra","Psychic","none"),
("064","Kadabra","Psychic","none"),
("065","Alakazam","Psychic","none"),
("066","Machop","Fighting","none"),
("067","Machoke","Fighting","none"),
("068","Machamp","Fighting","none"),
("069","Bellsprout","Grass","Poison"),
("070","Weepinbell","Grass","Poison"),
("071","Victreebel","Grass","Poison"),
("072","Tentacool","Water","Poison"),
("073","Tentacruel","Water","Poison"),
("074","Geodude","Rock","Ground"),
("075","Graveler","Rock","Ground"),
("076","Golem","Rock","Ground"),
("077","Ponyta","Fire","none"),
("078","Rapidash","Fire","none"),
("079","Slowpoke","Water","Psychic"),
("080","Slowbro","Water","Psychic"),
("081","Magnemite","Electric","none"),
("082","Magneton","Electric","none"),
("083","Farfetch'd","Normal","Flying"),
("084","Doduo","Normal","Flying"),
("085","Dodrio","Normal","Flying"),
("086","Seel","Water","none"),
("087","Dewgong","Water","Ice"),
("088","Grimer","Poison","none"),
("089","Muk","Poison","none"),
("090","Shellder","Water","none"),
("091","Cloyster","Water","Ice"),
("092","Gastly","Ghost","Poison"),
("093","Haunter","Ghost","Poison"),
("094","Gengar","Ghost","Poison"),
("095","Onix","Rock","Ground"),
("096","Drowzee","Psychic","none"),
("097","Hypno","Psychic","none"),
("098","Krabby","Water","none"),
("099","Kingler","Water","none"),
("100","Voltorb","Electric","none"),
("101","Electrode","Electric","none"),
("102","Exeggcute","Grass","Psychic"),
("103","Exeggutor","Grass","Psychic"),
("104","Cubone","Ground","none"),
("105","Marowak","Ground","none"),
("106","Hitmonlee","Fighting","none"),
("107","Hitmonchan","Fighting","none"),
("108","Lickitung","Normal","none"),
("109","Koffing","Poison","none"),
("110","Weezing","Poison","none"),
("111","Rhyhorn","Ground","Rock"),
("112","Rhydon","Ground","Rock"),
("113","Chansey","Normal","none"),
("114","Tangela","Grass","none"),
("115","Kangaskhan","Normal","none"),
("116","Horsea","Water","none"),
("117","Seadra","Water","none"),
("118","Goldeen","Water","none"),
("119","Seaking","Water","none"),
("120","Staryu","Water","none"),
("121","Starmie","Water","Psychic"),
("122","Mr. Mime","Psychic","none"),
("123","Scyther","Bug","Flying"),
("124","Jynx","Ice","Psychic"),
("125","Electabuzz","Electric","none"),
("126","Magmar","Fire","none"),
("127","Pinsir","Bug","none"),
("128","Tauros","Normal","none"),
("129","Magikarp","Water","none"),
("130","Gyarados","Water","Flying"),
("131","Lapras","Water","Ice"),
("132","Ditto","Normal","none"),
("133","Eevee","Normal","none"),
("134","Vaporeon","Water","none"),
("135","Jolteon","Electric","none"),
("136","Flareon","Fire","none"),
("137","Porygon","Normal","none"),
("138","Omanyte","Rock","Water"),
("139","Omastar","Rock","Water"),
("140","Kabuto","Rock","Water"),
("141","Kabutops","Rock","Water"),
("142","Aerodactyl","Rock","Flying"),
("143","Snorlax","Normal","none"),
("144","Articuno","Ice","Flying"),
("145","Zapdos","Electric","Flying"),
("146","Moltres","Fire","Flying"),
("147","Dratini","Dragon","none"),
("148","Dragonair","Dragon","none"),
("149","Dragonite","Dragon","Flying"),
("150","Mewtwo","Psychic","none"),
("151","Mew","Psychic","none")

;