Small problem with pokemonium

[Facewithcock]

If someone can help me get this up i will reward him with a 5$ paypal donation! (help over skype, or post)

i've set everything up for localhost.


I got the server running
And i got the client running fine.

When i open the game im able to register an account.
But when i try to login in get this pop up "login failed, please try again"

Idk what to do.
I used "database.sql" and not "new database.sq"
As that one gave 33 errors in navicat

And perhaps i need to set the client to localhost?
But i cant find where i can edit the IP in the client.

Or perhaps its something else that i need to do (i'm very new to this kind of things)
If anyone could help me out, it would be awsome

(btw if you can help me out of skype u'd be a real boss)

[MentaL]

[piertho]

I don't need your money, just take others files like pokemonium.

[Facewithcock]

I used the orginal pokemonium files.

[piertho]

Can we have a screen ?

[Lucila]

Use this Database

/*
Navicat MySQL Data Transfer

Source Server         : servers
Source Server Version : 50130
Source Host           : localhost:3306
Source Database       : pokemon

Target Server Type    : MYSQL
Target Server Version : 50130
File Encoding         : 65001

Date: 2014-09-09 21:13:35
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `pn_bag`
-- ----------------------------
DROP TABLE IF EXISTS `pn_bag`;
CREATE TABLE `pn_bag` (
  `member` int(11) NOT NULL,
  `item` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  PRIMARY KEY (`member`,`item`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

-- ----------------------------
-- Records of pn_bag
-- ----------------------------
INSERT INTO `pn_bag` VALUES ('1', '1', '5');
INSERT INTO `pn_bag` VALUES ('1', '35', '1');
INSERT INTO `pn_bag` VALUES ('1', '206', '2');
INSERT INTO `pn_bag` VALUES ('2', '35', '5');
INSERT INTO `pn_bag` VALUES ('3', '1', '1');
INSERT INTO `pn_bag` VALUES ('3', '92', '4');
INSERT INTO `pn_bag` VALUES ('3', '93', '1');
INSERT INTO `pn_bag` VALUES ('3', '97', '1');
INSERT INTO `pn_bag` VALUES ('3', '99', '1');
INSERT INTO `pn_bag` VALUES ('3', '206', '7');
INSERT INTO `pn_bag` VALUES ('3', '207', '1');
INSERT INTO `pn_bag` VALUES ('3', '365', '3');
INSERT INTO `pn_bag` VALUES ('4', '1', '3');
INSERT INTO `pn_bag` VALUES ('4', '35', '5');
INSERT INTO `pn_bag` VALUES ('4', '206', '4');
INSERT INTO `pn_bag` VALUES ('5', '35', '4');
INSERT INTO `pn_bag` VALUES ('5', '206', '1');
INSERT INTO `pn_bag` VALUES ('6', '35', '5');
INSERT INTO `pn_bag` VALUES ('6', '206', '2');

-- ----------------------------
-- Table structure for `pn_bans`
-- ----------------------------
DROP TABLE IF EXISTS `pn_bans`;
CREATE TABLE `pn_bans` (
  `playername` varchar(12) NOT NULL,
  `ip` varchar(16) NOT NULL,
  PRIMARY KEY (`playername`,`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pn_bans
-- ----------------------------

-- ----------------------------
-- Table structure for `pn_box`
-- ----------------------------
DROP TABLE IF EXISTS `pn_box`;
CREATE TABLE `pn_box` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member` int(11) DEFAULT NULL,
  `pokemon0` int(11) DEFAULT NULL,
  `pokemon1` int(11) DEFAULT NULL,
  `pokemon2` int(11) DEFAULT NULL,
  `pokemon3` int(11) DEFAULT NULL,
  `pokemon4` int(11) DEFAULT NULL,
  `pokemon5` int(11) DEFAULT NULL,
  `pokemon6` int(11) DEFAULT NULL,
  `pokemon7` int(11) DEFAULT NULL,
  `pokemon8` int(11) DEFAULT NULL,
  `pokemon9` int(11) DEFAULT NULL,
  `pokemon10` int(11) DEFAULT NULL,
  `pokemon11` int(11) DEFAULT NULL,
  `pokemon12` int(11) DEFAULT NULL,
  `pokemon13` int(11) DEFAULT NULL,
  `pokemon14` int(11) DEFAULT NULL,
  `pokemon15` int(11) DEFAULT NULL,
  `pokemon16` int(11) DEFAULT NULL,
  `pokemon17` int(11) DEFAULT NULL,
  `pokemon18` int(11) DEFAULT NULL,
  `pokemon19` int(11) DEFAULT NULL,
  `pokemon20` int(11) DEFAULT NULL,
  `pokemon21` int(11) DEFAULT NULL,
  `pokemon22` int(11) DEFAULT NULL,
  `pokemon23` int(11) DEFAULT NULL,
  `pokemon24` int(11) DEFAULT NULL,
  `pokemon25` int(11) DEFAULT NULL,
  `pokemon26` int(11) DEFAULT NULL,
  `pokemon27` int(11) DEFAULT NULL,
  `pokemon28` int(11) DEFAULT NULL,
  `pokemon29` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `player_box_idx` (`member`),
  KEY `first_poke_idx` (`pokemon0`),
  CONSTRAINT `player_box_fk` FOREIGN KEY (`member`) REFERENCES `pn_members` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pn_box
-- ----------------------------

-- ----------------------------
-- Table structure for `pn_cheatlog`
-- ----------------------------
DROP TABLE IF EXISTS `pn_cheatlog`;
CREATE TABLE `pn_cheatlog` (
  `playerid` int(11) NOT NULL,
  `date` varchar(25) NOT NULL,
  `message` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`playerid`,`date`),
  KEY `player_cheat_idx` (`playerid`),
  CONSTRAINT `player_cheat_fk` FOREIGN KEY (`playerid`) REFERENCES `pn_members` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pn_cheatlog
-- ----------------------------

-- ----------------------------
-- Table structure for `pn_friends`
-- ----------------------------
DROP TABLE IF EXISTS `pn_friends`;
CREATE TABLE `pn_friends` (
  `id` int(11) NOT NULL,
  `friendId` int(11) NOT NULL,
  PRIMARY KEY (`id`,`friendId`),
  KEY `player_friend_idx` (`id`),
  KEY `friend_idx` (`friendId`),
  CONSTRAINT `firend_fk` FOREIGN KEY (`friendId`) REFERENCES `pn_members` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `player_friend_fk` FOREIGN KEY (`id`) REFERENCES `pn_members` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pn_friends
-- ----------------------------

-- ----------------------------
-- Table structure for `pn_members`
-- ----------------------------
DROP TABLE IF EXISTS `pn_members`;
CREATE TABLE `pn_members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(12) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `dob` varchar(12) DEFAULT NULL,
  `email` varchar(32) DEFAULT NULL,
  `lastLoginTime` varchar(42) DEFAULT NULL,
  `lastLoginServer` varchar(24) CHARACTER SET utf8 DEFAULT NULL,
  `lastLoginIP` varchar(24) DEFAULT NULL,
  `lastLanguageUsed` tinyint(4) DEFAULT NULL,
  `sprite` smallint(6) DEFAULT NULL,
  `party` int(11) DEFAULT NULL,
  `money` int(11) DEFAULT NULL,
  `npcMul` varchar(6) DEFAULT NULL,
  `skHerb` int(11) DEFAULT NULL,
  `skCraft` int(11) DEFAULT NULL,
  `skFish` int(11) DEFAULT NULL,
  `skTrain` int(11) DEFAULT NULL,
  `skCoord` int(11) DEFAULT NULL,
  `skBreed` int(11) DEFAULT NULL,
  `x` smallint(6) DEFAULT NULL,
  `y` smallint(6) DEFAULT NULL,
  `mapX` tinyint(4) DEFAULT NULL,
  `mapY` tinyint(4) DEFAULT NULL,
  `bag` int(11) DEFAULT NULL,
  `badges` varchar(50) DEFAULT NULL,
  `healX` int(11) DEFAULT NULL,
  `healY` int(11) DEFAULT NULL,
  `healMapX` int(11) DEFAULT NULL,
  `healMapY` int(11) DEFAULT NULL,
  `isSurfing` varchar(5) DEFAULT NULL,
  `adminLevel` tinyint(3) unsigned DEFAULT NULL,
  `muted` varchar(5) DEFAULT '',
  `pokedexId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `username_idx` (`username`),
  KEY `dex_id_idx` (`pokedexId`),
  CONSTRAINT `dex_id` FOREIGN KEY (`pokedexId`) REFERENCES `pn_pokedex` (`pokedexId`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pn_members
-- ----------------------------
INSERT INTO `pn_members` VALUES ('1', '123123', 'C78893ECE569DB7D21FE3A55E82F1AC570A5E1A872F85E33124478610BC875FD82A6221F773B981648C74803A50969D28987BB2E4206B6B19DE58E267B554AAF', '11/11/1991', '123123@hotmail.com', '1410123515396', 'null', '192.168.0.6', '5', '27', '1', '4396', null, '0', '0', '0', '356', '0', '0', '608', '1016', '3', '-3', null, '100000000000000000000000000000000000000000', '480', '376', '-49', '-29', 'false', '0', 'false', '1');
INSERT INTO `pn_members` VALUES ('2', 'prueba', '3A606E7BA4BBFE1D0C7E817905C49EF4A1D2E5F343132004ADBEBC740E9A0A53B26390BDB6B589CA5681F00F399A7B5E823CDC49F1F1BDF76023399C11049CAF', '19/11/1991', 'prueba@hotmail.com', '1410123419084', 'null', '192.168.0.6', '5', '11', '2', '1150', null, '0', '0', '0', '30', '0', '0', '512', '440', '3', '1', null, '000000000000000000000000000000000000000000', '512', '440', '3', '1', 'false', '0', 'false', '2');
INSERT INTO `pn_members` VALUES ('3', 'conejo', 'FC047343D8292CBF03773B7F9AB34DBC0608382D10AEBD53F29694125B1ED64FFA31A52E73588C9B12D2126A1A8EBE32CBB0F3F09EAD4078EE2483EEA3ACCA54', '19/11/1991', 'conejo@hotmail.com', '1410123850753', 'null', '192.168.0.6', '5', '19', '3', '7406', null, '0', '0', '99', '2552', '0', '0', '384', '216', '-2', '-5', null, '111111111111111111111111111111110000000000', '480', '376', '-49', '-29', 'false', '0', 'false', '3');
INSERT INTO `pn_members` VALUES ('4', 'wolf', 'F38E3B25F51EE6104E65E89B524EA40A7BB6AD43E931924D0C8CACA2E2D137F411C1B28FE78534C210E8DE6E9A8F3D3FC4F5DDDF01D7752A5F45B2AC3D17B2B0', '19/11/1991', 'wolf.-91@hotmail.com', '1409593964153', 'null', '192.168.0.2', '5', '11', '4', '1500', null, '0', '0', '0', '315', '0', '0', '192', '280', '3', '-2', null, '000000000000000000000000000000000000000000', '480', '376', '-50', '-29', 'false', '0', 'false', '4');
INSERT INTO `pn_members` VALUES ('5', 'AAAA', '89AFEDEE150429F075CD1952741BF0712E670E6CBDF0A42358E6F274A17DEA33F4F7D1D7A0662BBECAAA1C211ACDF8F85865CBD3A6AF8F18C6A16F2AE9669D0D', '12/12/2050', 'qwer@tyui.com', '1409667809522', 'null', '192.168.0.2', '5', '1', '5', '0', null, '0', '0', '0', '84', '0', '0', '480', '376', '-49', '-29', null, '000000000000000000000000000000000000000000', '480', '376', '-49', '-29', 'false', '0', 'false', '5');
INSERT INTO `pn_members` VALUES ('6', 'fernamaton', '8E5C81CCDF163B1C440FD11577DE90FB408388F53B7248B4325966B45218FED27BB416DD27A33B71B2A02287A0101355C197EE8FEBE04570886CE34A3B428198', '09/11/1991', 'fernamaton@gmail.com', '1409772120090', 'null', '200.121.159.150', '5', '19', '6', '550', null, '0', '0', '0', '105', '0', '0', '128', '1816', '3', '-2', null, '000000000000000000000000000000000000000000', '512', '440', '3', '1', 'false', '0', 'false', '6');

-- ----------------------------
-- Table structure for `pn_mypokes`
-- ----------------------------
DROP TABLE IF EXISTS `pn_mypokes`;
CREATE TABLE `pn_mypokes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member` int(11) DEFAULT NULL,
  `party` int(11) DEFAULT NULL,
  `box0` int(11) DEFAULT NULL,
  `box1` int(11) DEFAULT NULL,
  `box2` int(11) DEFAULT NULL,
  `box3` int(11) DEFAULT NULL,
  `box4` int(11) DEFAULT NULL,
  `box5` int(11) DEFAULT NULL,
  `box6` int(11) DEFAULT NULL,
  `box7` int(11) DEFAULT NULL,
  `box8` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `player_pokes_idx` (`member`),
  KEY `party_idx` (`party`),
  CONSTRAINT `party_pokes_fk` FOREIGN KEY (`party`) REFERENCES `pn_party` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `player_pokes_fk` FOREIGN KEY (`member`) REFERENCES `pn_members` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pn_mypokes
-- ----------------------------

-- ----------------------------
-- Table structure for `pn_party`
-- ----------------------------
DROP TABLE IF EXISTS `pn_party`;
CREATE TABLE `pn_party` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member` int(11) DEFAULT NULL,
  `pokemon0` int(11) DEFAULT NULL,
  `pokemon1` int(11) DEFAULT NULL,
  `pokemon2` int(11) DEFAULT NULL,
  `pokemon3` int(11) DEFAULT NULL,
  `pokemon4` int(11) DEFAULT NULL,
  `pokemon5` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `player_party_idx` (`member`),
  CONSTRAINT `player_party_fk` FOREIGN KEY (`member`) REFERENCES `pn_members` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pn_party
-- ----------------------------
INSERT INTO `pn_party` VALUES ('1', '1', '1', '3', '2', '-1', '-1', '-1');
INSERT INTO `pn_party` VALUES ('2', '2', '4', '-1', '-1', '-1', '-1', '-1');
INSERT INTO `pn_party` VALUES ('3', '3', '5', '6', '-1', '-1', '-1', '-1');
INSERT INTO `pn_party` VALUES ('4', '4', '7', '-1', '-1', '-1', '-1', '-1');
INSERT INTO `pn_party` VALUES ('5', '5', '8', '11', '9', '10', '12', '-1');
INSERT INTO `pn_party` VALUES ('6', '6', '13', '-1', '-1', '-1', '-1', '-1');

-- ----------------------------
-- Table structure for `pn_pokedex`
-- ----------------------------
DROP TABLE IF EXISTS `pn_pokedex`;
CREATE TABLE `pn_pokedex` (
  `pokedexId` int(11) NOT NULL AUTO_INCREMENT,
  `memberId` int(11) NOT NULL,
  `1` tinyint(4) NOT NULL,
  `2` tinyint(4) NOT NULL,
  `3` tinyint(4) NOT NULL,
  `4` tinyint(4) NOT NULL,
  `5` tinyint(4) NOT NULL,
  `6` tinyint(4) NOT NULL,
  `7` tinyint(4) NOT NULL,
  `8` tinyint(4) NOT NULL,
  `9` tinyint(4) NOT NULL,
  `10` tinyint(4) NOT NULL,
  `11` tinyint(4) NOT NULL,
  `12` tinyint(4) NOT NULL,
  `13` tinyint(4) NOT NULL,
  `14` tinyint(4) NOT NULL,
  `15` tinyint(4) NOT NULL,
  `16` tinyint(4) NOT NULL,
  `17` tinyint(4) NOT NULL,
  `18` tinyint(4) NOT NULL,
  `19` tinyint(4) NOT NULL,
  `20` tinyint(4) NOT NULL,
  `21` tinyint(4) NOT NULL,
  `22` tinyint(4) NOT NULL,
  `23` tinyint(4) NOT NULL,
  `24` tinyint(4) NOT NULL,
  `25` tinyint(4) NOT NULL,
  `26` tinyint(4) NOT NULL,
  `27` tinyint(4) NOT NULL,
  `28` tinyint(4) NOT NULL,
  `29` tinyint(4) NOT NULL,
  `30` tinyint(4) NOT NULL,
  `31` tinyint(4) NOT NULL,
  `32` tinyint(4) NOT NULL,
  `33` tinyint(4) NOT NULL,
  `34` tinyint(4) NOT NULL,
  `35` tinyint(4) NOT NULL,
  `36` tinyint(4) NOT NULL,
  `37` tinyint(4) NOT NULL,
  `38` tinyint(4) NOT NULL,
  `39` tinyint(4) NOT NULL,
  `40` tinyint(4) NOT NULL,
  `41` tinyint(4) NOT NULL,
  `42` tinyint(4) NOT NULL,
  `43` tinyint(4) NOT NULL,
  `44` tinyint(4) NOT NULL,
  `45` tinyint(4) NOT NULL,
  `46` tinyint(4) NOT NULL,
  `47` tinyint(4) NOT NULL,
  `48` tinyint(4) NOT NULL,
  `49` tinyint(4) NOT NULL,
  `50` tinyint(4) NOT NULL,
  `51` tinyint(4) NOT NULL,
  `52` tinyint(4) NOT NULL,
  `53` tinyint(4) NOT NULL,
  `54` tinyint(4) NOT NULL,
  `55` tinyint(4) NOT NULL,
  `56` tinyint(4) NOT NULL,
  `57` tinyint(4) NOT NULL,
  `58` tinyint(4) NOT NULL,
  `59` tinyint(4) NOT NULL,
  `60` tinyint(4) NOT NULL,
  `61` tinyint(4) NOT NULL,
  `62` tinyint(4) NOT NULL,
  `63` tinyint(4) NOT NULL,
  `64` tinyint(4) NOT NULL,
  `65` tinyint(4) NOT NULL,
  `66` tinyint(4) NOT NULL,
  `67` tinyint(4) NOT NULL,
  `68` tinyint(4) NOT NULL,
  `69` tinyint(4) NOT NULL,
  `70` tinyint(4) NOT NULL,
  `71` tinyint(4) NOT NULL,
  `72` tinyint(4) NOT NULL,
  `73` tinyint(4) NOT NULL,
  `74` tinyint(4) NOT NULL,
  `75` tinyint(4) NOT NULL,
  `76` tinyint(4) NOT NULL,
  `77` tinyint(4) NOT NULL,
  `78` tinyint(4) NOT NULL,
  `79` tinyint(4) NOT NULL,
  `80` tinyint(4) NOT NULL,
  `81` tinyint(4) NOT NULL,
  `82` tinyint(4) NOT NULL,
  `83` tinyint(4) NOT NULL,
  `84` tinyint(4) NOT NULL,
  `85` tinyint(4) NOT NULL,
  `86` tinyint(4) NOT NULL,
  `87` tinyint(4) NOT NULL,
  `88` tinyint(4) NOT NULL,
  `89` tinyint(4) NOT NULL,
  `90` tinyint(4) NOT NULL,
  `91` tinyint(4) NOT NULL,
  `92` tinyint(4) NOT NULL,
  `93` tinyint(4) NOT NULL,
  `94` tinyint(4) NOT NULL,
  `95` tinyint(4) NOT NULL,
  `96` tinyint(4) NOT NULL,
  `97` tinyint(4) NOT NULL,
  `98` tinyint(4) NOT NULL,
  `99` tinyint(4) NOT NULL,
  `100` tinyint(4) NOT NULL,
  `101` tinyint(4) NOT NULL,
  `102` tinyint(4) NOT NULL,
  `103` tinyint(4) NOT NULL,
  `104` tinyint(4) NOT NULL,
  `105` tinyint(4) NOT NULL,
  `106` tinyint(4) NOT NULL,
  `107` tinyint(4) NOT NULL,
  `108` tinyint(4) NOT NULL,
  `109` tinyint(4) NOT NULL,
  `110` tinyint(4) NOT NULL,
  `111` tinyint(4) NOT NULL,
  `112` tinyint(4) NOT NULL,
  `113` tinyint(4) NOT NULL,
  `114` tinyint(4) NOT NULL,
  `115` tinyint(4) NOT NULL,
  `116` tinyint(4) NOT NULL,
  `117` tinyint(4) NOT NULL,
  `118` tinyint(4) NOT NULL,
  `119` tinyint(4) NOT NULL,
  `120` tinyint(4) NOT NULL,
  `121` tinyint(4) NOT NULL,
  `122` tinyint(4) NOT NULL,
  `123` tinyint(4) NOT NULL,
  `124` tinyint(4) NOT NULL,
  `125` tinyint(4) NOT NULL,
  `126` tinyint(4) NOT NULL,
  `127` tinyint(4) NOT NULL,
  `128` tinyint(4) NOT NULL,
  `129` tinyint(4) NOT NULL,
  `130` tinyint(4) NOT NULL,
  `131` tinyint(4) NOT NULL,
  `132` tinyint(4) NOT NULL,
  `133` tinyint(4) NOT NULL,
  `134` tinyint(4) NOT NULL,
  `135` tinyint(4) NOT NULL,
  `136` tinyint(4) NOT NULL,
  `137` tinyint(4) NOT NULL,
  `138` tinyint(4) NOT NULL,
  `139` tinyint(4) NOT NULL,
  `140` tinyint(4) NOT NULL,
  `141` tinyint(4) NOT NULL,
  `142` tinyint(4) NOT NULL,
  `143` tinyint(4) NOT NULL,
  `144` tinyint(4) NOT NULL,
  `145` tinyint(4) NOT NULL,
  `146` tinyint(4) NOT NULL,
  `147` tinyint(4) NOT NULL,
  `148` tinyint(4) NOT NULL,
  `149` tinyint(4) NOT NULL,
  `150` tinyint(4) NOT NULL,
  `151` tinyint(4) NOT NULL,
  `152` tinyint(4) NOT NULL,
  `153` tinyint(4) NOT NULL,
  `154` tinyint(4) NOT NULL,
  `155` tinyint(4) NOT NULL,
  `156` tinyint(4) NOT NULL,
  `157` tinyint(4) NOT NULL,
  `158` tinyint(4) NOT NULL,
  `159` tinyint(4) NOT NULL,
  `160` tinyint(4) NOT NULL,
  `161` tinyint(4) NOT NULL,
  `162` tinyint(4) NOT NULL,
  `163` tinyint(4) NOT NULL,
  `164` tinyint(4) NOT NULL,
  `165` tinyint(4) NOT NULL,
  `166` tinyint(4) NOT NULL,
  `167` tinyint(4) NOT NULL,
  `168` tinyint(4) NOT NULL,
  `169` tinyint(4) NOT NULL,
  `170` tinyint(4) NOT NULL,
  `171` tinyint(4) NOT NULL,
  `172` tinyint(4) NOT NULL,
  `173` tinyint(4) NOT NULL,
  `174` tinyint(4) NOT NULL,
  `175` tinyint(4) NOT NULL,
  `176` tinyint(4) NOT NULL,
  `177` tinyint(4) NOT NULL,
  `178` tinyint(4) NOT NULL,
  `179` tinyint(4) NOT NULL,
  `180` tinyint(4) NOT NULL,
  `181` tinyint(4) NOT NULL,
  `182` tinyint(4) NOT NULL,
  `183` tinyint(4) NOT NULL,
  `184` tinyint(4) NOT NULL,
  `185` tinyint(4) NOT NULL,
  `186` tinyint(4) NOT NULL,
  `187` tinyint(4) NOT NULL,
  `188` tinyint(4) NOT NULL,
  `189` tinyint(4) NOT NULL,
  `190` tinyint(4) NOT NULL,
  `191` tinyint(4) NOT NULL,
  `192` tinyint(4) NOT NULL,
  `193` tinyint(4) NOT NULL,
  `194` tinyint(4) NOT NULL,
  `195` tinyint(4) NOT NULL,
  `196` tinyint(4) NOT NULL,
  `197` tinyint(4) NOT NULL,
  `198` tinyint(4) NOT NULL,
  `199` tinyint(4) NOT NULL,
  `200` tinyint(4) NOT NULL,
  `201` tinyint(4) NOT NULL,
  `202` tinyint(4) NOT NULL,
  `203` tinyint(4) NOT NULL,
  `204` tinyint(4) NOT NULL,
  `205` tinyint(4) NOT NULL,
  `206` tinyint(4) NOT NULL,
  `207` tinyint(4) NOT NULL,
  `208` tinyint(4) NOT NULL,
  `209` tinyint(4) NOT NULL,
  `210` tinyint(4) NOT NULL,
  `211` tinyint(4) NOT NULL,
  `212` tinyint(4) NOT NULL,
  `213` tinyint(4) NOT NULL,
  `214` tinyint(4) NOT NULL,
  `215` tinyint(4) NOT NULL,
  `216` tinyint(4) NOT NULL,
  `217` tinyint(4) NOT NULL,
  `218` tinyint(4) NOT NULL,
  `219` tinyint(4) NOT NULL,
  `220` tinyint(4) NOT NULL,
  `221` tinyint(4) NOT NULL,
  `222` tinyint(4) NOT NULL,
  `223` tinyint(4) NOT NULL,
  `224` tinyint(4) NOT NULL,
  `225` tinyint(4) NOT NULL,
  `226` tinyint(4) NOT NULL,
  `227` tinyint(4) NOT NULL,
  `228` tinyint(4) NOT NULL,
  `229` tinyint(4) NOT NULL,
  `230` tinyint(4) NOT NULL,
  `231` tinyint(4) NOT NULL,
  `232` tinyint(4) NOT NULL,
  `233` tinyint(4) NOT NULL,
  `234` tinyint(4) NOT NULL,
  `235` tinyint(4) NOT NULL,
  `236` tinyint(4) NOT NULL,
  `237` tinyint(4) NOT NULL,
  `238` tinyint(4) NOT NULL,
  `239` tinyint(4) NOT NULL,
  `240` tinyint(4) NOT NULL,
  `241` tinyint(4) NOT NULL,
  `242` tinyint(4) NOT NULL,
  `243` tinyint(4) NOT NULL,
  `244` tinyint(4) NOT NULL,
  `245` tinyint(4) NOT NULL,
  `246` tinyint(4) NOT NULL,
  `247` tinyint(4) NOT NULL,
  `248` tinyint(4) NOT NULL,
  `249` tinyint(4) NOT NULL,
  `250` tinyint(4) NOT NULL,
  `251` tinyint(4) NOT NULL,
  `252` tinyint(4) NOT NULL,
  `253` tinyint(4) NOT NULL,
  `254` tinyint(4) NOT NULL,
  `255` tinyint(4) NOT NULL,
  `256` tinyint(4) NOT NULL,
  `257` tinyint(4) NOT NULL,
  `258` tinyint(4) NOT NULL,
  `259` tinyint(4) NOT NULL,
  `260` tinyint(4) NOT NULL,
  `261` tinyint(4) NOT NULL,
  `262` tinyint(4) NOT NULL,
  `263` tinyint(4) NOT NULL,
  `264` tinyint(4) NOT NULL,
  `265` tinyint(4) NOT NULL,
  `266` tinyint(4) NOT NULL,
  `267` tinyint(4) NOT NULL,
  `268` tinyint(4) NOT NULL,
  `269` tinyint(4) NOT NULL,
  `270` tinyint(4) NOT NULL,
  `271` tinyint(4) NOT NULL,
  `272` tinyint(4) NOT NULL,
  `273` tinyint(4) NOT NULL,
  `274` tinyint(4) NOT NULL,
  `275` tinyint(4) NOT NULL,
  `276` tinyint(4) NOT NULL,
  `277` tinyint(4) NOT NULL,
  `278` tinyint(4) NOT NULL,
  `279` tinyint(4) NOT NULL,
  `280` tinyint(4) NOT NULL,
  `281` tinyint(4) NOT NULL,
  `282` tinyint(4) NOT NULL,
  `283` tinyint(4) NOT NULL,
  `284` tinyint(4) NOT NULL,
  `285` tinyint(4) NOT NULL,
  `286` tinyint(4) NOT NULL,
  `287` tinyint(4) NOT NULL,
  `288` tinyint(4) NOT NULL,
  `289` tinyint(4) NOT NULL,
  `290` tinyint(4) NOT NULL,
  `291` tinyint(4) NOT NULL,
  `292` tinyint(4) NOT NULL,
  `293` tinyint(4) NOT NULL,
  `294` tinyint(4) NOT NULL,
  `295` tinyint(4) NOT NULL,
  `296` tinyint(4) NOT NULL,
  `297` tinyint(4) NOT NULL,
  `298` tinyint(4) NOT NULL,
  `299` tinyint(4) NOT NULL,
  `300` tinyint(4) NOT NULL,
  `301` tinyint(4) NOT NULL,
  `302` tinyint(4) NOT NULL,
  `303` tinyint(4) NOT NULL,
  `304` tinyint(4) NOT NULL,
  `305` tinyint(4) NOT NULL,
  `306` tinyint(4) NOT NULL,
  `307` tinyint(4) NOT NULL,
  `308` tinyint(4) NOT NULL,
  `309` tinyint(4) NOT NULL,
  `310` tinyint(4) NOT NULL,
  `311` tinyint(4) NOT NULL,
  `312` tinyint(4) NOT NULL,
  `313` tinyint(4) NOT NULL,
  `314` tinyint(4) NOT NULL,
  `315` tinyint(4) NOT NULL,
  `316` tinyint(4) NOT NULL,
  `317` tinyint(4) NOT NULL,
  `318` tinyint(4) NOT NULL,
  `319` tinyint(4) NOT NULL,
  `320` tinyint(4) NOT NULL,
  `321` tinyint(4) NOT NULL,
  `322` tinyint(4) NOT NULL,
  `323` tinyint(4) NOT NULL,
  `324` tinyint(4) NOT NULL,
  `325` tinyint(4) NOT NULL,
  `326` tinyint(4) NOT NULL,
  `327` tinyint(4) NOT NULL,
  `328` tinyint(4) NOT NULL,
  `329` tinyint(4) NOT NULL,
  `330` tinyint(4) NOT NULL,
  `331` tinyint(4) NOT NULL,
  `332` tinyint(4) NOT NULL,
  `333` tinyint(4) NOT NULL,
  `334` tinyint(4) NOT NULL,
  `335` tinyint(4) NOT NULL,
  `336` tinyint(4) NOT NULL,
  `337` tinyint(4) NOT NULL,
  `338` tinyint(4) NOT NULL,
  `339` tinyint(4) NOT NULL,
  `340` tinyint(4) NOT NULL,
  `341` tinyint(4) NOT NULL,
  `342` tinyint(4) NOT NULL,
  `343` tinyint(4) NOT NULL,
  `344` tinyint(4) NOT NULL,
  `345` tinyint(4) NOT NULL,
  `346` tinyint(4) NOT NULL,
  `347` tinyint(4) NOT NULL,
  `348` tinyint(4) NOT NULL,
  `349` tinyint(4) NOT NULL,
  `350` tinyint(4) NOT NULL,
  `351` tinyint(4) NOT NULL,
  `352` tinyint(4) NOT NULL,
  `353` tinyint(4) NOT NULL,
  `354` tinyint(4) NOT NULL,
  `355` tinyint(4) NOT NULL,
  `356` tinyint(4) NOT NULL,
  `357` tinyint(4) NOT NULL,
  `358` tinyint(4) NOT NULL,
  `359` tinyint(4) NOT NULL,
  `360` tinyint(4) NOT NULL,
  `361` tinyint(4) NOT NULL,
  `362` tinyint(4) NOT NULL,
  `363` tinyint(4) NOT NULL,
  `364` tinyint(4) NOT NULL,
  `365` tinyint(4) NOT NULL,
  `366` tinyint(4) NOT NULL,
  `367` tinyint(4) NOT NULL,
  `368` tinyint(4) NOT NULL,
  `369` tinyint(4) NOT NULL,
  `370` tinyint(4) NOT NULL,
  `371` tinyint(4) NOT NULL,
  `372` tinyint(4) NOT NULL,
  `373` tinyint(4) NOT NULL,
  `374` tinyint(4) NOT NULL,
  `375` tinyint(4) NOT NULL,
  `376` tinyint(4) NOT NULL,
  `377` tinyint(4) NOT NULL,
  `378` tinyint(4) NOT NULL,
  `379` tinyint(4) NOT NULL,
  `380` tinyint(4) NOT NULL,
  `381` tinyint(4) NOT NULL,
  `382` tinyint(4) NOT NULL,
  `383` tinyint(4) NOT NULL,
  `384` tinyint(4) NOT NULL,
  `385` tinyint(4) NOT NULL,
  `386` tinyint(4) NOT NULL,
  `387` tinyint(4) NOT NULL,
  `388` tinyint(4) NOT NULL,
  `389` tinyint(4) NOT NULL,
  `390` tinyint(4) NOT NULL,
  `391` tinyint(4) NOT NULL,
  `392` tinyint(4) NOT NULL,
  `393` tinyint(4) NOT NULL,
  `394` tinyint(4) NOT NULL,
  `395` tinyint(4) NOT NULL,
  `396` tinyint(4) NOT NULL,
  `397` tinyint(4) NOT NULL,
  `398` tinyint(4) NOT NULL,
  `399` tinyint(4) NOT NULL,
  `400` tinyint(4) NOT NULL,
  `401` tinyint(4) NOT NULL,
  `402` tinyint(4) NOT NULL,
  `403` tinyint(4) NOT NULL,
  `404` tinyint(4) NOT NULL,
  `405` tinyint(4) NOT NULL,
  `406` tinyint(4) NOT NULL,
  `407` tinyint(4) NOT NULL,
  `408` tinyint(4) NOT NULL,
  `409` tinyint(4) NOT NULL,
  `410` tinyint(4) NOT NULL,
  `411` tinyint(4) NOT NULL,
  `412` tinyint(4) NOT NULL,
  `413` tinyint(4) NOT NULL,
  `414` tinyint(4) NOT NULL,
  `415` tinyint(4) NOT NULL,
  `416` tinyint(4) NOT NULL,
  `417` tinyint(4) NOT NULL,
  `418` tinyint(4) NOT NULL,
  `419` tinyint(4) NOT NULL,
  `420` tinyint(4) NOT NULL,
  `421` tinyint(4) NOT NULL,
  `422` tinyint(4) NOT NULL,
  `423` tinyint(4) NOT NULL,
  `424` tinyint(4) NOT NULL,
  `425` tinyint(4) NOT NULL,
  `426` tinyint(4) NOT NULL,
  `427` tinyint(4) NOT NULL,
  `428` tinyint(4) NOT NULL,
  `429` tinyint(4) NOT NULL,
  `430` tinyint(4) NOT NULL,
  `431` tinyint(4) NOT NULL,
  `432` tinyint(4) NOT NULL,
  `433` tinyint(4) NOT NULL,
  `434` tinyint(4) NOT NULL,
  `435` tinyint(4) NOT NULL,
  `436` tinyint(4) NOT NULL,
  `437` tinyint(4) NOT NULL,
  `438` tinyint(4) NOT NULL,
  `439` tinyint(4) NOT NULL,
  `440` tinyint(4) NOT NULL,
  `441` tinyint(4) NOT NULL,
  `442` tinyint(4) NOT NULL,
  `443` tinyint(4) NOT NULL,
  `444` tinyint(4) NOT NULL,
  `445` tinyint(4) NOT NULL,
  `446` tinyint(4) NOT NULL,
  `447` tinyint(4) NOT NULL,
  `448` tinyint(4) NOT NULL,
  `449` tinyint(4) NOT NULL,
  `450` tinyint(4) NOT NULL,
  `451` tinyint(4) NOT NULL,
  `452` tinyint(4) NOT NULL,
  `453` tinyint(4) NOT NULL,
  `454` tinyint(4) NOT NULL,
  `455` tinyint(4) NOT NULL,
  `456` tinyint(4) NOT NULL,
  `457` tinyint(4) NOT NULL,
  `458` tinyint(4) NOT NULL,
  `459` tinyint(4) NOT NULL,
  `460` tinyint(4) NOT NULL,
  `461` tinyint(4) NOT NULL,
  `462` tinyint(4) NOT NULL,
  `463` tinyint(4) NOT NULL,
  `464` tinyint(4) NOT NULL,
  `465` tinyint(4) NOT NULL,
  `466` tinyint(4) NOT NULL,
  `467` tinyint(4) NOT NULL,
  `468` tinyint(4) NOT NULL,
  `469` tinyint(4) NOT NULL,
  `470` tinyint(4) NOT NULL,
  `471` tinyint(4) NOT NULL,
  `472` tinyint(4) NOT NULL,
  `473` tinyint(4) NOT NULL,
  `474` tinyint(4) NOT NULL,
  `475` tinyint(4) NOT NULL,
  `476` tinyint(4) NOT NULL,
  `477` tinyint(4) NOT NULL,
  `478` tinyint(4) NOT NULL,
  `479` tinyint(4) NOT NULL,
  `480` tinyint(4) NOT NULL,
  `481` tinyint(4) NOT NULL,
  `482` tinyint(4) NOT NULL,
  `483` tinyint(4) NOT NULL,
  `484` tinyint(4) NOT NULL,
  `485` tinyint(4) NOT NULL,
  `486` tinyint(4) NOT NULL,
  `487` tinyint(4) NOT NULL,
  `488` tinyint(4) NOT NULL,
  `489` tinyint(4) NOT NULL,
  `490` tinyint(4) NOT NULL,
  `491` tinyint(4) NOT NULL,
  `492` tinyint(4) NOT NULL,
  `493` tinyint(4) NOT NULL,
  PRIMARY KEY (`pokedexId`),
  KEY `player_dex_idx` (`memberId`),
  CONSTRAINT `Player_dex_fk` FOREIGN KEY (`memberId`) REFERENCES `pn_members` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pn_pokedex
-- ----------------------------
INSERT INTO `pn_pokedex` VALUES ('1', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '1', '1', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '2', '0', '1', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `pn_pokedex` VALUES ('2', '2', '0', '0', '0', '2', '0', '0', '0', '0', '0', '1', '1', '0', '1', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `pn_pokedex` VALUES ('3', '3', '2', '2', '2', '0', '0', '0', '0', '0', '0', '1', '1', '0', '1', '1', '0', '1', '0', '0', '2', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `pn_pokedex` VALUES ('4', '4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '1', '1', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `pn_pokedex` VALUES ('5', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '1', '1', '0', '0', '0', '0', '1', '0', '2', '0', '0', '0', '2', '0', '1', '0', '2', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `pn_pokedex` VALUES ('6', '6', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

-- ----------------------------
-- Table structure for `pn_pokemon`
-- ----------------------------
DROP TABLE IF EXISTS `pn_pokemon`;
CREATE TABLE `pn_pokemon` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(24) DEFAULT NULL,
  `speciesName` varchar(32) DEFAULT NULL,
  `exp` float(9,2) DEFAULT NULL,
  `baseExp` tinyint(3) unsigned DEFAULT NULL,
  `expType` varchar(16) DEFAULT NULL,
  `isFainted` varchar(5) DEFAULT NULL,
  `level` tinyint(3) unsigned DEFAULT NULL,
  `happiness` tinyint(3) unsigned DEFAULT NULL,
  `gender` tinyint(4) DEFAULT NULL,
  `nature` varchar(24) DEFAULT NULL,
  `abilityName` varchar(24) DEFAULT NULL,
  `itemName` varchar(28) DEFAULT NULL,
  `isShiny` varchar(5) DEFAULT NULL,
  `originalTrainerName` varchar(12) DEFAULT NULL,
  `currentTrainerName` varchar(12) DEFAULT NULL,
  `contestStats` varchar(25) DEFAULT NULL,
  `move0` varchar(32) DEFAULT NULL,
  `move1` varchar(32) DEFAULT NULL,
  `move2` varchar(32) DEFAULT NULL,
  `move3` varchar(32) DEFAULT NULL,
  `hp` smallint(6) DEFAULT NULL,
  `atk` smallint(6) DEFAULT NULL,
  `def` smallint(6) DEFAULT NULL,
  `speed` smallint(6) DEFAULT NULL,
  `spATK` smallint(6) DEFAULT NULL,
  `spDEF` smallint(6) DEFAULT NULL,
  `evHP` tinyint(3) unsigned DEFAULT NULL,
  `evATK` tinyint(3) unsigned DEFAULT NULL,
  `evDEF` tinyint(3) unsigned DEFAULT NULL,
  `evSPD` tinyint(3) unsigned DEFAULT NULL,
  `evSPATK` tinyint(3) unsigned DEFAULT NULL,
  `evSPDEF` tinyint(3) unsigned DEFAULT NULL,
  `ivHP` tinyint(4) DEFAULT NULL,
  `ivATK` tinyint(4) DEFAULT NULL,
  `ivDEF` tinyint(4) DEFAULT NULL,
  `ivSPD` tinyint(4) DEFAULT NULL,
  `ivSPATK` tinyint(4) DEFAULT NULL,
  `ivSPDEF` tinyint(4) DEFAULT NULL,
  `pp0` tinyint(4) DEFAULT NULL,
  `pp1` tinyint(4) DEFAULT NULL,
  `pp2` tinyint(4) DEFAULT NULL,
  `pp3` tinyint(4) DEFAULT NULL,
  `maxpp0` tinyint(4) DEFAULT NULL,
  `maxpp1` tinyint(4) DEFAULT NULL,
  `maxpp2` tinyint(4) DEFAULT NULL,
  `maxpp3` tinyint(4) DEFAULT NULL,
  `ppUp0` tinyint(3) unsigned DEFAULT NULL,
  `ppUp1` tinyint(3) unsigned DEFAULT NULL,
  `ppUp2` tinyint(3) unsigned DEFAULT NULL,
  `ppUp3` tinyint(3) unsigned DEFAULT NULL,
  `date` varchar(25) DEFAULT NULL,
  `caughtWith` tinyint(3) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pn_pokemon
-- ----------------------------
INSERT INTO `pn_pokemon` VALUES ('1', 'Bulbasaur', 'Bulbasaur', '1163.00', '64', 'PARABOLIC', 'false', '12', '255', '1', 'Quirky', 'Overgrow', '', 'false', '123123', '123123', '0,0,0,0,0', 'Tackle', 'Leech Seed', 'Growl', 'Vine Whip', '30', '20', '20', '16', '23', '22', '5', '2', '6', '9', '0', '0', '30', '27', '28', '4', '24', '17', '25', '10', '40', '10', '35', '10', '40', '10', '0', '0', '0', '0', '2014-08-06:02-18-22', null);
INSERT INTO `pn_pokemon` VALUES ('2', 'Hoothoot', 'Hoothoot', '8.00', '58', 'MEDIUM', 'false', '2', '255', '2', 'Rash', 'Insomnia', '', 'false', '123123', '123123', '0,0,0,0,0', 'Tackle', 'Growl', 'null', 'null', '14', '6', '6', '7', '7', '7', '0', '0', '0', '0', '0', '0', '26', '8', '1', '2', '23', '30', '35', '40', '-1', '-1', '35', '40', '-1', '-1', '0', '0', '0', '0', '2014-08-06:02-20-35', '35');
INSERT INTO `pn_pokemon` VALUES ('3', 'Pikachu', 'Pikachu', '27.00', '82', 'MEDIUM', 'false', '3', '255', '1', 'Hasty', 'Static', '', 'false', '123123', '123123', '0,0,0,0,0', 'Thundershock', 'Growl', 'null', 'null', '15', '8', '6', '11', '8', '7', '0', '0', '0', '0', '0', '0', '15', '13', '26', '3', '19', '10', '30', '40', '-1', '-1', '30', '40', '-1', '-1', '0', '0', '0', '0', '2014-08-06:03-05-13', '35');
INSERT INTO `pn_pokemon` VALUES ('4', 'Charmander', 'Charmander', '185.00', '65', 'PARABOLIC', 'false', '6', '255', '2', 'Quirky', 'Blaze', '', 'false', 'prueba', 'prueba', '0,0,0,0,0', 'Scratch', 'Growl', 'null', 'null', '20', '12', '11', '14', '13', '11', '0', '0', '0', '1', '0', '0', '5', '20', '26', '24', '28', '8', '35', '40', '-1', '-1', '35', '40', '-1', '-1', '0', '0', '0', '0', '2014-08-06:03-08-35', null);
INSERT INTO `pn_pokemon` VALUES ('5', 'Venusaur', 'Venusaur', '42411.00', '64', 'PARABOLIC', 'false', '36', '255', '1', 'Quirky', 'Overgrow', 'Old Rod', 'true', 'conejo', 'conejo', '0,0,0,0,0', 'Tackle', 'Razor Leaf', 'Petal Dance', 'Sweet Scent', '100', '71', '70', '67', '79', '79', '13', '0', '6', '21', '0', '0', '9', '25', '20', '12', '13', '14', '19', '17', '20', '20', '35', '25', '20', '20', '0', '0', '0', '0', '2014-08-16:02-03-48', null);
INSERT INTO `pn_pokemon` VALUES ('6', 'Alakazam', 'Alakazam', '153671.00', '73', 'PARABOLIC', 'false', '54', '255', '2', 'Rash', 'Synchronize', 'Grip Claw', 'false', 'conejo', 'conejo', '0,0,0,0,0', 'Recover', 'Psychic', 'Confusion', 'Psybeam', '141', '68', '98', '146', '199', '104', '11', '60', '255', '62', '105', '17', '31', '3', '19', '6', '30', '31', '10', '10', '25', '20', '10', '10', '25', '20', '0', '0', '0', '0', '2013-02-12:09-59-55', '35');
INSERT INTO `pn_pokemon` VALUES ('7', 'Totodile', 'Totodile', '1165.00', '66', 'PARABOLIC', 'false', '12', '255', '2', 'Quirky', 'Torrent', 'Oran Berry', 'false', 'wolf', 'wolf', '0,0,0,0,0', 'Scratch', 'Leer', 'Water Gun', 'Rage', '22', '20', '21', '17', '14', '17', '5', '0', '2', '12', '0', '0', '29', '7', '24', '27', '1', '15', '0', '30', '22', '20', '35', '30', '25', '20', '0', '0', '0', '0', '2014-09-01:14-35-01', null);
INSERT INTO `pn_pokemon` VALUES ('8', 'Piplup', 'Piplup', '186.00', '66', 'PARABOLIC', 'false', '6', '153', '1', 'Quirky', 'Torrent', '', 'false', 'AAAA', 'AAAA', '0,0,0,0,0', 'Pound', 'null', 'Growl', 'null', '22', '12', '12', '11', '12', '12', '0', '0', '0', '1', '0', '0', '6', '16', '16', '23', '7', '17', '35', '-1', '40', '-1', '35', '-1', '40', '-1', '0', '0', '0', '0', '2014-09-02:11-12-48', null);
INSERT INTO `pn_pokemon` VALUES ('9', 'Spearow', 'Spearow', '343.00', '58', 'MEDIUM', 'false', '7', '153', '1', 'Quiet', 'Keen Eye', '', 'false', 'AAAA', 'AAAA', '0,0,0,0,0', 'Peck', 'Growl', 'null', 'Leer', '23', '13', '11', '13', '11', '9', '1', '0', '0', '0', '0', '0', '12', '5', '27', '3', '21', '3', '35', '40', '-1', '30', '35', '40', '-1', '30', '0', '0', '0', '0', '2014-09-02:11-22-13', '35');
INSERT INTO `pn_pokemon` VALUES ('10', 'Nidoran-m', 'Nidoran-m', '97.00', '60', 'PARABOLIC', 'false', '4', '84', '1', 'Relaxed', 'Poison Point', '', 'false', 'AAAA', 'AAAA', '0,0,0,0,0', 'Leer', 'Peck', 'null', 'null', '18', '10', '9', '8', '8', '8', '0', '0', '0', '0', '0', '0', '8', '31', '5', '11', '7', '18', '30', '35', '-1', '-1', '30', '35', '-1', '-1', '0', '0', '0', '0', '2014-09-02:11-25-15', '35');
INSERT INTO `pn_pokemon` VALUES ('11', 'Pikachu', 'Pikachu', '27.00', '82', 'MEDIUM', 'false', '3', '84', '2', 'Bold', 'Static', '', 'false', 'AAAA', 'AAAA', '0,0,0,0,0', 'Thundershock', 'Growl', 'null', 'null', '15', '7', '7', '10', '8', '8', '0', '0', '0', '0', '0', '0', '7', '4', '9', '0', '11', '25', '30', '40', '-1', '-1', '30', '40', '-1', '-1', '0', '0', '0', '0', '2014-09-02:11-30-09', '35');
INSERT INTO `pn_pokemon` VALUES ('12', 'Nidoran-f', 'Nidoran-f', '10.00', '59', 'PARABOLIC', 'false', '2', '84', '2', 'Naughty', 'Poison Point', '', 'false', 'AAAA', 'AAAA', '0,0,0,0,0', 'Growl', 'Scratch', 'null', 'null', '14', '7', '7', '6', '6', '6', '0', '0', '0', '0', '0', '0', '16', '5', '0', '4', '4', '11', '40', '35', '-1', '-1', '40', '35', '-1', '-1', '0', '0', '0', '0', '2014-09-02:11-25-34', '35');
INSERT INTO `pn_pokemon` VALUES ('13', 'Charmander', 'Charmander', '337.00', '65', 'PARABOLIC', 'false', '8', '183', '1', 'Quirky', 'Blaze', '', 'false', 'fernamaton', 'fernamaton', '0,0,0,0,0', 'Scratch', 'Growl', 'Ember', 'null', '15', '14', '13', '16', '14', '13', '0', '0', '0', '3', '0', '0', '10', '30', '29', '29', '10', '25', '29', '40', '24', '-1', '35', '40', '25', '-1', '0', '0', '0', '0', '2014-09-03:16-21-52', null);

[Facewithcock]

Use this Database

/*
Navicat MySQL Data Transfer

Source Server         : servers
Source Server Version : 50130
Source Host           : localhost:3306
Source Database       : pokemon

Target Server Type    : MYSQL
Target Server Version : 50130
File Encoding         : 65001

Date: 2014-09-09 21:13:35
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `pn_bag`
-- ----------------------------
DROP TABLE IF EXISTS `pn_bag`;
CREATE TABLE `pn_bag` (
  `member` int(11) NOT NULL,
  `item` int(11) NOT NULL,
  `quantity` int(11) NOT NULL,
  PRIMARY KEY (`member`,`item`)
) ENGINE=InnoDB DEFAULT CHARSET=ascii;

-- ----------------------------
-- Records of pn_bag
-- ----------------------------
INSERT INTO `pn_bag` VALUES ('1', '1', '5');
INSERT INTO `pn_bag` VALUES ('1', '35', '1');
INSERT INTO `pn_bag` VALUES ('1', '206', '2');
INSERT INTO `pn_bag` VALUES ('2', '35', '5');
INSERT INTO `pn_bag` VALUES ('3', '1', '1');
INSERT INTO `pn_bag` VALUES ('3', '92', '4');
INSERT INTO `pn_bag` VALUES ('3', '93', '1');
INSERT INTO `pn_bag` VALUES ('3', '97', '1');
INSERT INTO `pn_bag` VALUES ('3', '99', '1');
INSERT INTO `pn_bag` VALUES ('3', '206', '7');
INSERT INTO `pn_bag` VALUES ('3', '207', '1');
INSERT INTO `pn_bag` VALUES ('3', '365', '3');
INSERT INTO `pn_bag` VALUES ('4', '1', '3');
INSERT INTO `pn_bag` VALUES ('4', '35', '5');
INSERT INTO `pn_bag` VALUES ('4', '206', '4');
INSERT INTO `pn_bag` VALUES ('5', '35', '4');
INSERT INTO `pn_bag` VALUES ('5', '206', '1');
INSERT INTO `pn_bag` VALUES ('6', '35', '5');
INSERT INTO `pn_bag` VALUES ('6', '206', '2');

-- ----------------------------
-- Table structure for `pn_bans`
-- ----------------------------
DROP TABLE IF EXISTS `pn_bans`;
CREATE TABLE `pn_bans` (
  `playername` varchar(12) NOT NULL,
  `ip` varchar(16) NOT NULL,
  PRIMARY KEY (`playername`,`ip`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pn_bans
-- ----------------------------

-- ----------------------------
-- Table structure for `pn_box`
-- ----------------------------
DROP TABLE IF EXISTS `pn_box`;
CREATE TABLE `pn_box` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member` int(11) DEFAULT NULL,
  `pokemon0` int(11) DEFAULT NULL,
  `pokemon1` int(11) DEFAULT NULL,
  `pokemon2` int(11) DEFAULT NULL,
  `pokemon3` int(11) DEFAULT NULL,
  `pokemon4` int(11) DEFAULT NULL,
  `pokemon5` int(11) DEFAULT NULL,
  `pokemon6` int(11) DEFAULT NULL,
  `pokemon7` int(11) DEFAULT NULL,
  `pokemon8` int(11) DEFAULT NULL,
  `pokemon9` int(11) DEFAULT NULL,
  `pokemon10` int(11) DEFAULT NULL,
  `pokemon11` int(11) DEFAULT NULL,
  `pokemon12` int(11) DEFAULT NULL,
  `pokemon13` int(11) DEFAULT NULL,
  `pokemon14` int(11) DEFAULT NULL,
  `pokemon15` int(11) DEFAULT NULL,
  `pokemon16` int(11) DEFAULT NULL,
  `pokemon17` int(11) DEFAULT NULL,
  `pokemon18` int(11) DEFAULT NULL,
  `pokemon19` int(11) DEFAULT NULL,
  `pokemon20` int(11) DEFAULT NULL,
  `pokemon21` int(11) DEFAULT NULL,
  `pokemon22` int(11) DEFAULT NULL,
  `pokemon23` int(11) DEFAULT NULL,
  `pokemon24` int(11) DEFAULT NULL,
  `pokemon25` int(11) DEFAULT NULL,
  `pokemon26` int(11) DEFAULT NULL,
  `pokemon27` int(11) DEFAULT NULL,
  `pokemon28` int(11) DEFAULT NULL,
  `pokemon29` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `player_box_idx` (`member`),
  KEY `first_poke_idx` (`pokemon0`),
  CONSTRAINT `player_box_fk` FOREIGN KEY (`member`) REFERENCES `pn_members` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pn_box
-- ----------------------------

-- ----------------------------
-- Table structure for `pn_cheatlog`
-- ----------------------------
DROP TABLE IF EXISTS `pn_cheatlog`;
CREATE TABLE `pn_cheatlog` (
  `playerid` int(11) NOT NULL,
  `date` varchar(25) NOT NULL,
  `message` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`playerid`,`date`),
  KEY `player_cheat_idx` (`playerid`),
  CONSTRAINT `player_cheat_fk` FOREIGN KEY (`playerid`) REFERENCES `pn_members` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pn_cheatlog
-- ----------------------------

-- ----------------------------
-- Table structure for `pn_friends`
-- ----------------------------
DROP TABLE IF EXISTS `pn_friends`;
CREATE TABLE `pn_friends` (
  `id` int(11) NOT NULL,
  `friendId` int(11) NOT NULL,
  PRIMARY KEY (`id`,`friendId`),
  KEY `player_friend_idx` (`id`),
  KEY `friend_idx` (`friendId`),
  CONSTRAINT `firend_fk` FOREIGN KEY (`friendId`) REFERENCES `pn_members` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `player_friend_fk` FOREIGN KEY (`id`) REFERENCES `pn_members` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pn_friends
-- ----------------------------

-- ----------------------------
-- Table structure for `pn_members`
-- ----------------------------
DROP TABLE IF EXISTS `pn_members`;
CREATE TABLE `pn_members` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `username` varchar(12) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL,
  `dob` varchar(12) DEFAULT NULL,
  `email` varchar(32) DEFAULT NULL,
  `lastLoginTime` varchar(42) DEFAULT NULL,
  `lastLoginServer` varchar(24) CHARACTER SET utf8 DEFAULT NULL,
  `lastLoginIP` varchar(24) DEFAULT NULL,
  `lastLanguageUsed` tinyint(4) DEFAULT NULL,
  `sprite` smallint(6) DEFAULT NULL,
  `party` int(11) DEFAULT NULL,
  `money` int(11) DEFAULT NULL,
  `npcMul` varchar(6) DEFAULT NULL,
  `skHerb` int(11) DEFAULT NULL,
  `skCraft` int(11) DEFAULT NULL,
  `skFish` int(11) DEFAULT NULL,
  `skTrain` int(11) DEFAULT NULL,
  `skCoord` int(11) DEFAULT NULL,
  `skBreed` int(11) DEFAULT NULL,
  `x` smallint(6) DEFAULT NULL,
  `y` smallint(6) DEFAULT NULL,
  `mapX` tinyint(4) DEFAULT NULL,
  `mapY` tinyint(4) DEFAULT NULL,
  `bag` int(11) DEFAULT NULL,
  `badges` varchar(50) DEFAULT NULL,
  `healX` int(11) DEFAULT NULL,
  `healY` int(11) DEFAULT NULL,
  `healMapX` int(11) DEFAULT NULL,
  `healMapY` int(11) DEFAULT NULL,
  `isSurfing` varchar(5) DEFAULT NULL,
  `adminLevel` tinyint(3) unsigned DEFAULT NULL,
  `muted` varchar(5) DEFAULT '',
  `pokedexId` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `username_idx` (`username`),
  KEY `dex_id_idx` (`pokedexId`),
  CONSTRAINT `dex_id` FOREIGN KEY (`pokedexId`) REFERENCES `pn_pokedex` (`pokedexId`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pn_members
-- ----------------------------
INSERT INTO `pn_members` VALUES ('1', '123123', 'C78893ECE569DB7D21FE3A55E82F1AC570A5E1A872F85E33124478610BC875FD82A6221F773B981648C74803A50969D28987BB2E4206B6B19DE58E267B554AAF', '11/11/1991', '123123@hotmail.com', '1410123515396', 'null', '192.168.0.6', '5', '27', '1', '4396', null, '0', '0', '0', '356', '0', '0', '608', '1016', '3', '-3', null, '100000000000000000000000000000000000000000', '480', '376', '-49', '-29', 'false', '0', 'false', '1');
INSERT INTO `pn_members` VALUES ('2', 'prueba', '3A606E7BA4BBFE1D0C7E817905C49EF4A1D2E5F343132004ADBEBC740E9A0A53B26390BDB6B589CA5681F00F399A7B5E823CDC49F1F1BDF76023399C11049CAF', '19/11/1991', 'prueba@hotmail.com', '1410123419084', 'null', '192.168.0.6', '5', '11', '2', '1150', null, '0', '0', '0', '30', '0', '0', '512', '440', '3', '1', null, '000000000000000000000000000000000000000000', '512', '440', '3', '1', 'false', '0', 'false', '2');
INSERT INTO `pn_members` VALUES ('3', 'conejo', 'FC047343D8292CBF03773B7F9AB34DBC0608382D10AEBD53F29694125B1ED64FFA31A52E73588C9B12D2126A1A8EBE32CBB0F3F09EAD4078EE2483EEA3ACCA54', '19/11/1991', 'conejo@hotmail.com', '1410123850753', 'null', '192.168.0.6', '5', '19', '3', '7406', null, '0', '0', '99', '2552', '0', '0', '384', '216', '-2', '-5', null, '111111111111111111111111111111110000000000', '480', '376', '-49', '-29', 'false', '0', 'false', '3');
INSERT INTO `pn_members` VALUES ('4', 'wolf', 'F38E3B25F51EE6104E65E89B524EA40A7BB6AD43E931924D0C8CACA2E2D137F411C1B28FE78534C210E8DE6E9A8F3D3FC4F5DDDF01D7752A5F45B2AC3D17B2B0', '19/11/1991', 'wolf.-91@hotmail.com', '1409593964153', 'null', '192.168.0.2', '5', '11', '4', '1500', null, '0', '0', '0', '315', '0', '0', '192', '280', '3', '-2', null, '000000000000000000000000000000000000000000', '480', '376', '-50', '-29', 'false', '0', 'false', '4');
INSERT INTO `pn_members` VALUES ('5', 'AAAA', '89AFEDEE150429F075CD1952741BF0712E670E6CBDF0A42358E6F274A17DEA33F4F7D1D7A0662BBECAAA1C211ACDF8F85865CBD3A6AF8F18C6A16F2AE9669D0D', '12/12/2050', 'qwer@tyui.com', '1409667809522', 'null', '192.168.0.2', '5', '1', '5', '0', null, '0', '0', '0', '84', '0', '0', '480', '376', '-49', '-29', null, '000000000000000000000000000000000000000000', '480', '376', '-49', '-29', 'false', '0', 'false', '5');
INSERT INTO `pn_members` VALUES ('6', 'fernamaton', '8E5C81CCDF163B1C440FD11577DE90FB408388F53B7248B4325966B45218FED27BB416DD27A33B71B2A02287A0101355C197EE8FEBE04570886CE34A3B428198', '09/11/1991', 'fernamaton@gmail.com', '1409772120090', 'null', '200.121.159.150', '5', '19', '6', '550', null, '0', '0', '0', '105', '0', '0', '128', '1816', '3', '-2', null, '000000000000000000000000000000000000000000', '512', '440', '3', '1', 'false', '0', 'false', '6');

-- ----------------------------
-- Table structure for `pn_mypokes`
-- ----------------------------
DROP TABLE IF EXISTS `pn_mypokes`;
CREATE TABLE `pn_mypokes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member` int(11) DEFAULT NULL,
  `party` int(11) DEFAULT NULL,
  `box0` int(11) DEFAULT NULL,
  `box1` int(11) DEFAULT NULL,
  `box2` int(11) DEFAULT NULL,
  `box3` int(11) DEFAULT NULL,
  `box4` int(11) DEFAULT NULL,
  `box5` int(11) DEFAULT NULL,
  `box6` int(11) DEFAULT NULL,
  `box7` int(11) DEFAULT NULL,
  `box8` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `player_pokes_idx` (`member`),
  KEY `party_idx` (`party`),
  CONSTRAINT `party_pokes_fk` FOREIGN KEY (`party`) REFERENCES `pn_party` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
  CONSTRAINT `player_pokes_fk` FOREIGN KEY (`member`) REFERENCES `pn_members` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pn_mypokes
-- ----------------------------

-- ----------------------------
-- Table structure for `pn_party`
-- ----------------------------
DROP TABLE IF EXISTS `pn_party`;
CREATE TABLE `pn_party` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `member` int(11) DEFAULT NULL,
  `pokemon0` int(11) DEFAULT NULL,
  `pokemon1` int(11) DEFAULT NULL,
  `pokemon2` int(11) DEFAULT NULL,
  `pokemon3` int(11) DEFAULT NULL,
  `pokemon4` int(11) DEFAULT NULL,
  `pokemon5` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `player_party_idx` (`member`),
  CONSTRAINT `player_party_fk` FOREIGN KEY (`member`) REFERENCES `pn_members` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pn_party
-- ----------------------------
INSERT INTO `pn_party` VALUES ('1', '1', '1', '3', '2', '-1', '-1', '-1');
INSERT INTO `pn_party` VALUES ('2', '2', '4', '-1', '-1', '-1', '-1', '-1');
INSERT INTO `pn_party` VALUES ('3', '3', '5', '6', '-1', '-1', '-1', '-1');
INSERT INTO `pn_party` VALUES ('4', '4', '7', '-1', '-1', '-1', '-1', '-1');
INSERT INTO `pn_party` VALUES ('5', '5', '8', '11', '9', '10', '12', '-1');
INSERT INTO `pn_party` VALUES ('6', '6', '13', '-1', '-1', '-1', '-1', '-1');

-- ----------------------------
-- Table structure for `pn_pokedex`
-- ----------------------------
DROP TABLE IF EXISTS `pn_pokedex`;
CREATE TABLE `pn_pokedex` (
  `pokedexId` int(11) NOT NULL AUTO_INCREMENT,
  `memberId` int(11) NOT NULL,
  `1` tinyint(4) NOT NULL,
  `2` tinyint(4) NOT NULL,
  `3` tinyint(4) NOT NULL,
  `4` tinyint(4) NOT NULL,
  `5` tinyint(4) NOT NULL,
  `6` tinyint(4) NOT NULL,
  `7` tinyint(4) NOT NULL,
  `8` tinyint(4) NOT NULL,
  `9` tinyint(4) NOT NULL,
  `10` tinyint(4) NOT NULL,
  `11` tinyint(4) NOT NULL,
  `12` tinyint(4) NOT NULL,
  `13` tinyint(4) NOT NULL,
  `14` tinyint(4) NOT NULL,
  `15` tinyint(4) NOT NULL,
  `16` tinyint(4) NOT NULL,
  `17` tinyint(4) NOT NULL,
  `18` tinyint(4) NOT NULL,
  `19` tinyint(4) NOT NULL,
  `20` tinyint(4) NOT NULL,
  `21` tinyint(4) NOT NULL,
  `22` tinyint(4) NOT NULL,
  `23` tinyint(4) NOT NULL,
  `24` tinyint(4) NOT NULL,
  `25` tinyint(4) NOT NULL,
  `26` tinyint(4) NOT NULL,
  `27` tinyint(4) NOT NULL,
  `28` tinyint(4) NOT NULL,
  `29` tinyint(4) NOT NULL,
  `30` tinyint(4) NOT NULL,
  `31` tinyint(4) NOT NULL,
  `32` tinyint(4) NOT NULL,
  `33` tinyint(4) NOT NULL,
  `34` tinyint(4) NOT NULL,
  `35` tinyint(4) NOT NULL,
  `36` tinyint(4) NOT NULL,
  `37` tinyint(4) NOT NULL,
  `38` tinyint(4) NOT NULL,
  `39` tinyint(4) NOT NULL,
  `40` tinyint(4) NOT NULL,
  `41` tinyint(4) NOT NULL,
  `42` tinyint(4) NOT NULL,
  `43` tinyint(4) NOT NULL,
  `44` tinyint(4) NOT NULL,
  `45` tinyint(4) NOT NULL,
  `46` tinyint(4) NOT NULL,
  `47` tinyint(4) NOT NULL,
  `48` tinyint(4) NOT NULL,
  `49` tinyint(4) NOT NULL,
  `50` tinyint(4) NOT NULL,
  `51` tinyint(4) NOT NULL,
  `52` tinyint(4) NOT NULL,
  `53` tinyint(4) NOT NULL,
  `54` tinyint(4) NOT NULL,
  `55` tinyint(4) NOT NULL,
  `56` tinyint(4) NOT NULL,
  `57` tinyint(4) NOT NULL,
  `58` tinyint(4) NOT NULL,
  `59` tinyint(4) NOT NULL,
  `60` tinyint(4) NOT NULL,
  `61` tinyint(4) NOT NULL,
  `62` tinyint(4) NOT NULL,
  `63` tinyint(4) NOT NULL,
  `64` tinyint(4) NOT NULL,
  `65` tinyint(4) NOT NULL,
  `66` tinyint(4) NOT NULL,
  `67` tinyint(4) NOT NULL,
  `68` tinyint(4) NOT NULL,
  `69` tinyint(4) NOT NULL,
  `70` tinyint(4) NOT NULL,
  `71` tinyint(4) NOT NULL,
  `72` tinyint(4) NOT NULL,
  `73` tinyint(4) NOT NULL,
  `74` tinyint(4) NOT NULL,
  `75` tinyint(4) NOT NULL,
  `76` tinyint(4) NOT NULL,
  `77` tinyint(4) NOT NULL,
  `78` tinyint(4) NOT NULL,
  `79` tinyint(4) NOT NULL,
  `80` tinyint(4) NOT NULL,
  `81` tinyint(4) NOT NULL,
  `82` tinyint(4) NOT NULL,
  `83` tinyint(4) NOT NULL,
  `84` tinyint(4) NOT NULL,
  `85` tinyint(4) NOT NULL,
  `86` tinyint(4) NOT NULL,
  `87` tinyint(4) NOT NULL,
  `88` tinyint(4) NOT NULL,
  `89` tinyint(4) NOT NULL,
  `90` tinyint(4) NOT NULL,
  `91` tinyint(4) NOT NULL,
  `92` tinyint(4) NOT NULL,
  `93` tinyint(4) NOT NULL,
  `94` tinyint(4) NOT NULL,
  `95` tinyint(4) NOT NULL,
  `96` tinyint(4) NOT NULL,
  `97` tinyint(4) NOT NULL,
  `98` tinyint(4) NOT NULL,
  `99` tinyint(4) NOT NULL,
  `100` tinyint(4) NOT NULL,
  `101` tinyint(4) NOT NULL,
  `102` tinyint(4) NOT NULL,
  `103` tinyint(4) NOT NULL,
  `104` tinyint(4) NOT NULL,
  `105` tinyint(4) NOT NULL,
  `106` tinyint(4) NOT NULL,
  `107` tinyint(4) NOT NULL,
  `108` tinyint(4) NOT NULL,
  `109` tinyint(4) NOT NULL,
  `110` tinyint(4) NOT NULL,
  `111` tinyint(4) NOT NULL,
  `112` tinyint(4) NOT NULL,
  `113` tinyint(4) NOT NULL,
  `114` tinyint(4) NOT NULL,
  `115` tinyint(4) NOT NULL,
  `116` tinyint(4) NOT NULL,
  `117` tinyint(4) NOT NULL,
  `118` tinyint(4) NOT NULL,
  `119` tinyint(4) NOT NULL,
  `120` tinyint(4) NOT NULL,
  `121` tinyint(4) NOT NULL,
  `122` tinyint(4) NOT NULL,
  `123` tinyint(4) NOT NULL,
  `124` tinyint(4) NOT NULL,
  `125` tinyint(4) NOT NULL,
  `126` tinyint(4) NOT NULL,
  `127` tinyint(4) NOT NULL,
  `128` tinyint(4) NOT NULL,
  `129` tinyint(4) NOT NULL,
  `130` tinyint(4) NOT NULL,
  `131` tinyint(4) NOT NULL,
  `132` tinyint(4) NOT NULL,
  `133` tinyint(4) NOT NULL,
  `134` tinyint(4) NOT NULL,
  `135` tinyint(4) NOT NULL,
  `136` tinyint(4) NOT NULL,
  `137` tinyint(4) NOT NULL,
  `138` tinyint(4) NOT NULL,
  `139` tinyint(4) NOT NULL,
  `140` tinyint(4) NOT NULL,
  `141` tinyint(4) NOT NULL,
  `142` tinyint(4) NOT NULL,
  `143` tinyint(4) NOT NULL,
  `144` tinyint(4) NOT NULL,
  `145` tinyint(4) NOT NULL,
  `146` tinyint(4) NOT NULL,
  `147` tinyint(4) NOT NULL,
  `148` tinyint(4) NOT NULL,
  `149` tinyint(4) NOT NULL,
  `150` tinyint(4) NOT NULL,
  `151` tinyint(4) NOT NULL,
  `152` tinyint(4) NOT NULL,
  `153` tinyint(4) NOT NULL,
  `154` tinyint(4) NOT NULL,
  `155` tinyint(4) NOT NULL,
  `156` tinyint(4) NOT NULL,
  `157` tinyint(4) NOT NULL,
  `158` tinyint(4) NOT NULL,
  `159` tinyint(4) NOT NULL,
  `160` tinyint(4) NOT NULL,
  `161` tinyint(4) NOT NULL,
  `162` tinyint(4) NOT NULL,
  `163` tinyint(4) NOT NULL,
  `164` tinyint(4) NOT NULL,
  `165` tinyint(4) NOT NULL,
  `166` tinyint(4) NOT NULL,
  `167` tinyint(4) NOT NULL,
  `168` tinyint(4) NOT NULL,
  `169` tinyint(4) NOT NULL,
  `170` tinyint(4) NOT NULL,
  `171` tinyint(4) NOT NULL,
  `172` tinyint(4) NOT NULL,
  `173` tinyint(4) NOT NULL,
  `174` tinyint(4) NOT NULL,
  `175` tinyint(4) NOT NULL,
  `176` tinyint(4) NOT NULL,
  `177` tinyint(4) NOT NULL,
  `178` tinyint(4) NOT NULL,
  `179` tinyint(4) NOT NULL,
  `180` tinyint(4) NOT NULL,
  `181` tinyint(4) NOT NULL,
  `182` tinyint(4) NOT NULL,
  `183` tinyint(4) NOT NULL,
  `184` tinyint(4) NOT NULL,
  `185` tinyint(4) NOT NULL,
  `186` tinyint(4) NOT NULL,
  `187` tinyint(4) NOT NULL,
  `188` tinyint(4) NOT NULL,
  `189` tinyint(4) NOT NULL,
  `190` tinyint(4) NOT NULL,
  `191` tinyint(4) NOT NULL,
  `192` tinyint(4) NOT NULL,
  `193` tinyint(4) NOT NULL,
  `194` tinyint(4) NOT NULL,
  `195` tinyint(4) NOT NULL,
  `196` tinyint(4) NOT NULL,
  `197` tinyint(4) NOT NULL,
  `198` tinyint(4) NOT NULL,
  `199` tinyint(4) NOT NULL,
  `200` tinyint(4) NOT NULL,
  `201` tinyint(4) NOT NULL,
  `202` tinyint(4) NOT NULL,
  `203` tinyint(4) NOT NULL,
  `204` tinyint(4) NOT NULL,
  `205` tinyint(4) NOT NULL,
  `206` tinyint(4) NOT NULL,
  `207` tinyint(4) NOT NULL,
  `208` tinyint(4) NOT NULL,
  `209` tinyint(4) NOT NULL,
  `210` tinyint(4) NOT NULL,
  `211` tinyint(4) NOT NULL,
  `212` tinyint(4) NOT NULL,
  `213` tinyint(4) NOT NULL,
  `214` tinyint(4) NOT NULL,
  `215` tinyint(4) NOT NULL,
  `216` tinyint(4) NOT NULL,
  `217` tinyint(4) NOT NULL,
  `218` tinyint(4) NOT NULL,
  `219` tinyint(4) NOT NULL,
  `220` tinyint(4) NOT NULL,
  `221` tinyint(4) NOT NULL,
  `222` tinyint(4) NOT NULL,
  `223` tinyint(4) NOT NULL,
  `224` tinyint(4) NOT NULL,
  `225` tinyint(4) NOT NULL,
  `226` tinyint(4) NOT NULL,
  `227` tinyint(4) NOT NULL,
  `228` tinyint(4) NOT NULL,
  `229` tinyint(4) NOT NULL,
  `230` tinyint(4) NOT NULL,
  `231` tinyint(4) NOT NULL,
  `232` tinyint(4) NOT NULL,
  `233` tinyint(4) NOT NULL,
  `234` tinyint(4) NOT NULL,
  `235` tinyint(4) NOT NULL,
  `236` tinyint(4) NOT NULL,
  `237` tinyint(4) NOT NULL,
  `238` tinyint(4) NOT NULL,
  `239` tinyint(4) NOT NULL,
  `240` tinyint(4) NOT NULL,
  `241` tinyint(4) NOT NULL,
  `242` tinyint(4) NOT NULL,
  `243` tinyint(4) NOT NULL,
  `244` tinyint(4) NOT NULL,
  `245` tinyint(4) NOT NULL,
  `246` tinyint(4) NOT NULL,
  `247` tinyint(4) NOT NULL,
  `248` tinyint(4) NOT NULL,
  `249` tinyint(4) NOT NULL,
  `250` tinyint(4) NOT NULL,
  `251` tinyint(4) NOT NULL,
  `252` tinyint(4) NOT NULL,
  `253` tinyint(4) NOT NULL,
  `254` tinyint(4) NOT NULL,
  `255` tinyint(4) NOT NULL,
  `256` tinyint(4) NOT NULL,
  `257` tinyint(4) NOT NULL,
  `258` tinyint(4) NOT NULL,
  `259` tinyint(4) NOT NULL,
  `260` tinyint(4) NOT NULL,
  `261` tinyint(4) NOT NULL,
  `262` tinyint(4) NOT NULL,
  `263` tinyint(4) NOT NULL,
  `264` tinyint(4) NOT NULL,
  `265` tinyint(4) NOT NULL,
  `266` tinyint(4) NOT NULL,
  `267` tinyint(4) NOT NULL,
  `268` tinyint(4) NOT NULL,
  `269` tinyint(4) NOT NULL,
  `270` tinyint(4) NOT NULL,
  `271` tinyint(4) NOT NULL,
  `272` tinyint(4) NOT NULL,
  `273` tinyint(4) NOT NULL,
  `274` tinyint(4) NOT NULL,
  `275` tinyint(4) NOT NULL,
  `276` tinyint(4) NOT NULL,
  `277` tinyint(4) NOT NULL,
  `278` tinyint(4) NOT NULL,
  `279` tinyint(4) NOT NULL,
  `280` tinyint(4) NOT NULL,
  `281` tinyint(4) NOT NULL,
  `282` tinyint(4) NOT NULL,
  `283` tinyint(4) NOT NULL,
  `284` tinyint(4) NOT NULL,
  `285` tinyint(4) NOT NULL,
  `286` tinyint(4) NOT NULL,
  `287` tinyint(4) NOT NULL,
  `288` tinyint(4) NOT NULL,
  `289` tinyint(4) NOT NULL,
  `290` tinyint(4) NOT NULL,
  `291` tinyint(4) NOT NULL,
  `292` tinyint(4) NOT NULL,
  `293` tinyint(4) NOT NULL,
  `294` tinyint(4) NOT NULL,
  `295` tinyint(4) NOT NULL,
  `296` tinyint(4) NOT NULL,
  `297` tinyint(4) NOT NULL,
  `298` tinyint(4) NOT NULL,
  `299` tinyint(4) NOT NULL,
  `300` tinyint(4) NOT NULL,
  `301` tinyint(4) NOT NULL,
  `302` tinyint(4) NOT NULL,
  `303` tinyint(4) NOT NULL,
  `304` tinyint(4) NOT NULL,
  `305` tinyint(4) NOT NULL,
  `306` tinyint(4) NOT NULL,
  `307` tinyint(4) NOT NULL,
  `308` tinyint(4) NOT NULL,
  `309` tinyint(4) NOT NULL,
  `310` tinyint(4) NOT NULL,
  `311` tinyint(4) NOT NULL,
  `312` tinyint(4) NOT NULL,
  `313` tinyint(4) NOT NULL,
  `314` tinyint(4) NOT NULL,
  `315` tinyint(4) NOT NULL,
  `316` tinyint(4) NOT NULL,
  `317` tinyint(4) NOT NULL,
  `318` tinyint(4) NOT NULL,
  `319` tinyint(4) NOT NULL,
  `320` tinyint(4) NOT NULL,
  `321` tinyint(4) NOT NULL,
  `322` tinyint(4) NOT NULL,
  `323` tinyint(4) NOT NULL,
  `324` tinyint(4) NOT NULL,
  `325` tinyint(4) NOT NULL,
  `326` tinyint(4) NOT NULL,
  `327` tinyint(4) NOT NULL,
  `328` tinyint(4) NOT NULL,
  `329` tinyint(4) NOT NULL,
  `330` tinyint(4) NOT NULL,
  `331` tinyint(4) NOT NULL,
  `332` tinyint(4) NOT NULL,
  `333` tinyint(4) NOT NULL,
  `334` tinyint(4) NOT NULL,
  `335` tinyint(4) NOT NULL,
  `336` tinyint(4) NOT NULL,
  `337` tinyint(4) NOT NULL,
  `338` tinyint(4) NOT NULL,
  `339` tinyint(4) NOT NULL,
  `340` tinyint(4) NOT NULL,
  `341` tinyint(4) NOT NULL,
  `342` tinyint(4) NOT NULL,
  `343` tinyint(4) NOT NULL,
  `344` tinyint(4) NOT NULL,
  `345` tinyint(4) NOT NULL,
  `346` tinyint(4) NOT NULL,
  `347` tinyint(4) NOT NULL,
  `348` tinyint(4) NOT NULL,
  `349` tinyint(4) NOT NULL,
  `350` tinyint(4) NOT NULL,
  `351` tinyint(4) NOT NULL,
  `352` tinyint(4) NOT NULL,
  `353` tinyint(4) NOT NULL,
  `354` tinyint(4) NOT NULL,
  `355` tinyint(4) NOT NULL,
  `356` tinyint(4) NOT NULL,
  `357` tinyint(4) NOT NULL,
  `358` tinyint(4) NOT NULL,
  `359` tinyint(4) NOT NULL,
  `360` tinyint(4) NOT NULL,
  `361` tinyint(4) NOT NULL,
  `362` tinyint(4) NOT NULL,
  `363` tinyint(4) NOT NULL,
  `364` tinyint(4) NOT NULL,
  `365` tinyint(4) NOT NULL,
  `366` tinyint(4) NOT NULL,
  `367` tinyint(4) NOT NULL,
  `368` tinyint(4) NOT NULL,
  `369` tinyint(4) NOT NULL,
  `370` tinyint(4) NOT NULL,
  `371` tinyint(4) NOT NULL,
  `372` tinyint(4) NOT NULL,
  `373` tinyint(4) NOT NULL,
  `374` tinyint(4) NOT NULL,
  `375` tinyint(4) NOT NULL,
  `376` tinyint(4) NOT NULL,
  `377` tinyint(4) NOT NULL,
  `378` tinyint(4) NOT NULL,
  `379` tinyint(4) NOT NULL,
  `380` tinyint(4) NOT NULL,
  `381` tinyint(4) NOT NULL,
  `382` tinyint(4) NOT NULL,
  `383` tinyint(4) NOT NULL,
  `384` tinyint(4) NOT NULL,
  `385` tinyint(4) NOT NULL,
  `386` tinyint(4) NOT NULL,
  `387` tinyint(4) NOT NULL,
  `388` tinyint(4) NOT NULL,
  `389` tinyint(4) NOT NULL,
  `390` tinyint(4) NOT NULL,
  `391` tinyint(4) NOT NULL,
  `392` tinyint(4) NOT NULL,
  `393` tinyint(4) NOT NULL,
  `394` tinyint(4) NOT NULL,
  `395` tinyint(4) NOT NULL,
  `396` tinyint(4) NOT NULL,
  `397` tinyint(4) NOT NULL,
  `398` tinyint(4) NOT NULL,
  `399` tinyint(4) NOT NULL,
  `400` tinyint(4) NOT NULL,
  `401` tinyint(4) NOT NULL,
  `402` tinyint(4) NOT NULL,
  `403` tinyint(4) NOT NULL,
  `404` tinyint(4) NOT NULL,
  `405` tinyint(4) NOT NULL,
  `406` tinyint(4) NOT NULL,
  `407` tinyint(4) NOT NULL,
  `408` tinyint(4) NOT NULL,
  `409` tinyint(4) NOT NULL,
  `410` tinyint(4) NOT NULL,
  `411` tinyint(4) NOT NULL,
  `412` tinyint(4) NOT NULL,
  `413` tinyint(4) NOT NULL,
  `414` tinyint(4) NOT NULL,
  `415` tinyint(4) NOT NULL,
  `416` tinyint(4) NOT NULL,
  `417` tinyint(4) NOT NULL,
  `418` tinyint(4) NOT NULL,
  `419` tinyint(4) NOT NULL,
  `420` tinyint(4) NOT NULL,
  `421` tinyint(4) NOT NULL,
  `422` tinyint(4) NOT NULL,
  `423` tinyint(4) NOT NULL,
  `424` tinyint(4) NOT NULL,
  `425` tinyint(4) NOT NULL,
  `426` tinyint(4) NOT NULL,
  `427` tinyint(4) NOT NULL,
  `428` tinyint(4) NOT NULL,
  `429` tinyint(4) NOT NULL,
  `430` tinyint(4) NOT NULL,
  `431` tinyint(4) NOT NULL,
  `432` tinyint(4) NOT NULL,
  `433` tinyint(4) NOT NULL,
  `434` tinyint(4) NOT NULL,
  `435` tinyint(4) NOT NULL,
  `436` tinyint(4) NOT NULL,
  `437` tinyint(4) NOT NULL,
  `438` tinyint(4) NOT NULL,
  `439` tinyint(4) NOT NULL,
  `440` tinyint(4) NOT NULL,
  `441` tinyint(4) NOT NULL,
  `442` tinyint(4) NOT NULL,
  `443` tinyint(4) NOT NULL,
  `444` tinyint(4) NOT NULL,
  `445` tinyint(4) NOT NULL,
  `446` tinyint(4) NOT NULL,
  `447` tinyint(4) NOT NULL,
  `448` tinyint(4) NOT NULL,
  `449` tinyint(4) NOT NULL,
  `450` tinyint(4) NOT NULL,
  `451` tinyint(4) NOT NULL,
  `452` tinyint(4) NOT NULL,
  `453` tinyint(4) NOT NULL,
  `454` tinyint(4) NOT NULL,
  `455` tinyint(4) NOT NULL,
  `456` tinyint(4) NOT NULL,
  `457` tinyint(4) NOT NULL,
  `458` tinyint(4) NOT NULL,
  `459` tinyint(4) NOT NULL,
  `460` tinyint(4) NOT NULL,
  `461` tinyint(4) NOT NULL,
  `462` tinyint(4) NOT NULL,
  `463` tinyint(4) NOT NULL,
  `464` tinyint(4) NOT NULL,
  `465` tinyint(4) NOT NULL,
  `466` tinyint(4) NOT NULL,
  `467` tinyint(4) NOT NULL,
  `468` tinyint(4) NOT NULL,
  `469` tinyint(4) NOT NULL,
  `470` tinyint(4) NOT NULL,
  `471` tinyint(4) NOT NULL,
  `472` tinyint(4) NOT NULL,
  `473` tinyint(4) NOT NULL,
  `474` tinyint(4) NOT NULL,
  `475` tinyint(4) NOT NULL,
  `476` tinyint(4) NOT NULL,
  `477` tinyint(4) NOT NULL,
  `478` tinyint(4) NOT NULL,
  `479` tinyint(4) NOT NULL,
  `480` tinyint(4) NOT NULL,
  `481` tinyint(4) NOT NULL,
  `482` tinyint(4) NOT NULL,
  `483` tinyint(4) NOT NULL,
  `484` tinyint(4) NOT NULL,
  `485` tinyint(4) NOT NULL,
  `486` tinyint(4) NOT NULL,
  `487` tinyint(4) NOT NULL,
  `488` tinyint(4) NOT NULL,
  `489` tinyint(4) NOT NULL,
  `490` tinyint(4) NOT NULL,
  `491` tinyint(4) NOT NULL,
  `492` tinyint(4) NOT NULL,
  `493` tinyint(4) NOT NULL,
  PRIMARY KEY (`pokedexId`),
  KEY `player_dex_idx` (`memberId`),
  CONSTRAINT `Player_dex_fk` FOREIGN KEY (`memberId`) REFERENCES `pn_members` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pn_pokedex
-- ----------------------------
INSERT INTO `pn_pokedex` VALUES ('1', '1', '2', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '1', '1', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '2', '0', '1', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `pn_pokedex` VALUES ('2', '2', '0', '0', '0', '2', '0', '0', '0', '0', '0', '1', '1', '0', '1', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `pn_pokedex` VALUES ('3', '3', '2', '2', '2', '0', '0', '0', '0', '0', '0', '1', '1', '0', '1', '1', '0', '1', '0', '0', '2', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `pn_pokedex` VALUES ('4', '4', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '1', '1', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `pn_pokedex` VALUES ('5', '5', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '1', '0', '1', '1', '0', '0', '0', '0', '1', '0', '2', '0', '0', '0', '2', '0', '1', '0', '2', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');
INSERT INTO `pn_pokedex` VALUES ('6', '6', '0', '0', '0', '2', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '1', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');

-- ----------------------------
-- Table structure for `pn_pokemon`
-- ----------------------------
DROP TABLE IF EXISTS `pn_pokemon`;
CREATE TABLE `pn_pokemon` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(24) DEFAULT NULL,
  `speciesName` varchar(32) DEFAULT NULL,
  `exp` float(9,2) DEFAULT NULL,
  `baseExp` tinyint(3) unsigned DEFAULT NULL,
  `expType` varchar(16) DEFAULT NULL,
  `isFainted` varchar(5) DEFAULT NULL,
  `level` tinyint(3) unsigned DEFAULT NULL,
  `happiness` tinyint(3) unsigned DEFAULT NULL,
  `gender` tinyint(4) DEFAULT NULL,
  `nature` varchar(24) DEFAULT NULL,
  `abilityName` varchar(24) DEFAULT NULL,
  `itemName` varchar(28) DEFAULT NULL,
  `isShiny` varchar(5) DEFAULT NULL,
  `originalTrainerName` varchar(12) DEFAULT NULL,
  `currentTrainerName` varchar(12) DEFAULT NULL,
  `contestStats` varchar(25) DEFAULT NULL,
  `move0` varchar(32) DEFAULT NULL,
  `move1` varchar(32) DEFAULT NULL,
  `move2` varchar(32) DEFAULT NULL,
  `move3` varchar(32) DEFAULT NULL,
  `hp` smallint(6) DEFAULT NULL,
  `atk` smallint(6) DEFAULT NULL,
  `def` smallint(6) DEFAULT NULL,
  `speed` smallint(6) DEFAULT NULL,
  `spATK` smallint(6) DEFAULT NULL,
  `spDEF` smallint(6) DEFAULT NULL,
  `evHP` tinyint(3) unsigned DEFAULT NULL,
  `evATK` tinyint(3) unsigned DEFAULT NULL,
  `evDEF` tinyint(3) unsigned DEFAULT NULL,
  `evSPD` tinyint(3) unsigned DEFAULT NULL,
  `evSPATK` tinyint(3) unsigned DEFAULT NULL,
  `evSPDEF` tinyint(3) unsigned DEFAULT NULL,
  `ivHP` tinyint(4) DEFAULT NULL,
  `ivATK` tinyint(4) DEFAULT NULL,
  `ivDEF` tinyint(4) DEFAULT NULL,
  `ivSPD` tinyint(4) DEFAULT NULL,
  `ivSPATK` tinyint(4) DEFAULT NULL,
  `ivSPDEF` tinyint(4) DEFAULT NULL,
  `pp0` tinyint(4) DEFAULT NULL,
  `pp1` tinyint(4) DEFAULT NULL,
  `pp2` tinyint(4) DEFAULT NULL,
  `pp3` tinyint(4) DEFAULT NULL,
  `maxpp0` tinyint(4) DEFAULT NULL,
  `maxpp1` tinyint(4) DEFAULT NULL,
  `maxpp2` tinyint(4) DEFAULT NULL,
  `maxpp3` tinyint(4) DEFAULT NULL,
  `ppUp0` tinyint(3) unsigned DEFAULT NULL,
  `ppUp1` tinyint(3) unsigned DEFAULT NULL,
  `ppUp2` tinyint(3) unsigned DEFAULT NULL,
  `ppUp3` tinyint(3) unsigned DEFAULT NULL,
  `date` varchar(25) DEFAULT NULL,
  `caughtWith` tinyint(3) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records of pn_pokemon
-- ----------------------------
INSERT INTO `pn_pokemon` VALUES ('1', 'Bulbasaur', 'Bulbasaur', '1163.00', '64', 'PARABOLIC', 'false', '12', '255', '1', 'Quirky', 'Overgrow', '', 'false', '123123', '123123', '0,0,0,0,0', 'Tackle', 'Leech Seed', 'Growl', 'Vine Whip', '30', '20', '20', '16', '23', '22', '5', '2', '6', '9', '0', '0', '30', '27', '28', '4', '24', '17', '25', '10', '40', '10', '35', '10', '40', '10', '0', '0', '0', '0', '2014-08-06:02-18-22', null);
INSERT INTO `pn_pokemon` VALUES ('2', 'Hoothoot', 'Hoothoot', '8.00', '58', 'MEDIUM', 'false', '2', '255', '2', 'Rash', 'Insomnia', '', 'false', '123123', '123123', '0,0,0,0,0', 'Tackle', 'Growl', 'null', 'null', '14', '6', '6', '7', '7', '7', '0', '0', '0', '0', '0', '0', '26', '8', '1', '2', '23', '30', '35', '40', '-1', '-1', '35', '40', '-1', '-1', '0', '0', '0', '0', '2014-08-06:02-20-35', '35');
INSERT INTO `pn_pokemon` VALUES ('3', 'Pikachu', 'Pikachu', '27.00', '82', 'MEDIUM', 'false', '3', '255', '1', 'Hasty', 'Static', '', 'false', '123123', '123123', '0,0,0,0,0', 'Thundershock', 'Growl', 'null', 'null', '15', '8', '6', '11', '8', '7', '0', '0', '0', '0', '0', '0', '15', '13', '26', '3', '19', '10', '30', '40', '-1', '-1', '30', '40', '-1', '-1', '0', '0', '0', '0', '2014-08-06:03-05-13', '35');
INSERT INTO `pn_pokemon` VALUES ('4', 'Charmander', 'Charmander', '185.00', '65', 'PARABOLIC', 'false', '6', '255', '2', 'Quirky', 'Blaze', '', 'false', 'prueba', 'prueba', '0,0,0,0,0', 'Scratch', 'Growl', 'null', 'null', '20', '12', '11', '14', '13', '11', '0', '0', '0', '1', '0', '0', '5', '20', '26', '24', '28', '8', '35', '40', '-1', '-1', '35', '40', '-1', '-1', '0', '0', '0', '0', '2014-08-06:03-08-35', null);
INSERT INTO `pn_pokemon` VALUES ('5', 'Venusaur', 'Venusaur', '42411.00', '64', 'PARABOLIC', 'false', '36', '255', '1', 'Quirky', 'Overgrow', 'Old Rod', 'true', 'conejo', 'conejo', '0,0,0,0,0', 'Tackle', 'Razor Leaf', 'Petal Dance', 'Sweet Scent', '100', '71', '70', '67', '79', '79', '13', '0', '6', '21', '0', '0', '9', '25', '20', '12', '13', '14', '19', '17', '20', '20', '35', '25', '20', '20', '0', '0', '0', '0', '2014-08-16:02-03-48', null);
INSERT INTO `pn_pokemon` VALUES ('6', 'Alakazam', 'Alakazam', '153671.00', '73', 'PARABOLIC', 'false', '54', '255', '2', 'Rash', 'Synchronize', 'Grip Claw', 'false', 'conejo', 'conejo', '0,0,0,0,0', 'Recover', 'Psychic', 'Confusion', 'Psybeam', '141', '68', '98', '146', '199', '104', '11', '60', '255', '62', '105', '17', '31', '3', '19', '6', '30', '31', '10', '10', '25', '20', '10', '10', '25', '20', '0', '0', '0', '0', '2013-02-12:09-59-55', '35');
INSERT INTO `pn_pokemon` VALUES ('7', 'Totodile', 'Totodile', '1165.00', '66', 'PARABOLIC', 'false', '12', '255', '2', 'Quirky', 'Torrent', 'Oran Berry', 'false', 'wolf', 'wolf', '0,0,0,0,0', 'Scratch', 'Leer', 'Water Gun', 'Rage', '22', '20', '21', '17', '14', '17', '5', '0', '2', '12', '0', '0', '29', '7', '24', '27', '1', '15', '0', '30', '22', '20', '35', '30', '25', '20', '0', '0', '0', '0', '2014-09-01:14-35-01', null);
INSERT INTO `pn_pokemon` VALUES ('8', 'Piplup', 'Piplup', '186.00', '66', 'PARABOLIC', 'false', '6', '153', '1', 'Quirky', 'Torrent', '', 'false', 'AAAA', 'AAAA', '0,0,0,0,0', 'Pound', 'null', 'Growl', 'null', '22', '12', '12', '11', '12', '12', '0', '0', '0', '1', '0', '0', '6', '16', '16', '23', '7', '17', '35', '-1', '40', '-1', '35', '-1', '40', '-1', '0', '0', '0', '0', '2014-09-02:11-12-48', null);
INSERT INTO `pn_pokemon` VALUES ('9', 'Spearow', 'Spearow', '343.00', '58', 'MEDIUM', 'false', '7', '153', '1', 'Quiet', 'Keen Eye', '', 'false', 'AAAA', 'AAAA', '0,0,0,0,0', 'Peck', 'Growl', 'null', 'Leer', '23', '13', '11', '13', '11', '9', '1', '0', '0', '0', '0', '0', '12', '5', '27', '3', '21', '3', '35', '40', '-1', '30', '35', '40', '-1', '30', '0', '0', '0', '0', '2014-09-02:11-22-13', '35');
INSERT INTO `pn_pokemon` VALUES ('10', 'Nidoran-m', 'Nidoran-m', '97.00', '60', 'PARABOLIC', 'false', '4', '84', '1', 'Relaxed', 'Poison Point', '', 'false', 'AAAA', 'AAAA', '0,0,0,0,0', 'Leer', 'Peck', 'null', 'null', '18', '10', '9', '8', '8', '8', '0', '0', '0', '0', '0', '0', '8', '31', '5', '11', '7', '18', '30', '35', '-1', '-1', '30', '35', '-1', '-1', '0', '0', '0', '0', '2014-09-02:11-25-15', '35');
INSERT INTO `pn_pokemon` VALUES ('11', 'Pikachu', 'Pikachu', '27.00', '82', 'MEDIUM', 'false', '3', '84', '2', 'Bold', 'Static', '', 'false', 'AAAA', 'AAAA', '0,0,0,0,0', 'Thundershock', 'Growl', 'null', 'null', '15', '7', '7', '10', '8', '8', '0', '0', '0', '0', '0', '0', '7', '4', '9', '0', '11', '25', '30', '40', '-1', '-1', '30', '40', '-1', '-1', '0', '0', '0', '0', '2014-09-02:11-30-09', '35');
INSERT INTO `pn_pokemon` VALUES ('12', 'Nidoran-f', 'Nidoran-f', '10.00', '59', 'PARABOLIC', 'false', '2', '84', '2', 'Naughty', 'Poison Point', '', 'false', 'AAAA', 'AAAA', '0,0,0,0,0', 'Growl', 'Scratch', 'null', 'null', '14', '7', '7', '6', '6', '6', '0', '0', '0', '0', '0', '0', '16', '5', '0', '4', '4', '11', '40', '35', '-1', '-1', '40', '35', '-1', '-1', '0', '0', '0', '0', '2014-09-02:11-25-34', '35');
INSERT INTO `pn_pokemon` VALUES ('13', 'Charmander', 'Charmander', '337.00', '65', 'PARABOLIC', 'false', '8', '183', '1', 'Quirky', 'Blaze', '', 'false', 'fernamaton', 'fernamaton', '0,0,0,0,0', 'Scratch', 'Growl', 'Ember', 'null', '15', '14', '13', '16', '14', '13', '0', '0', '0', '3', '0', '0', '10', '30', '29', '29', '10', '25', '29', '40', '24', '-1', '35', '40', '25', '-1', '0', '0', '0', '0', '2014-09-03:16-21-52', null);

When i Copy paste this in a file and name it Database.sql and import it into navicat i get 73 errors.

[-DefaulT]

@Facewithcock add me on skype and ill see if i can give you some help
d.faultx on skype

[Lucila]

Is for your navicat..
use this package.. inside are a navicat that work 100%
https://mega.co.nz/#!GUxhzCDI!OYInAT...CuwPlqLtyG8Cpk