Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Small problem with pokemonium

F

Facewithcock

Newbie Spellweaver
Joined
Sep 6, 2014
Messages
7
Reaction score
0
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 :D:

(btw if you can help me out of skype u'd be a real boss)
 
Last edited:
The Best DDoS Protected Servers
P

piertho

Newbie Spellweaver
Joined
Jul 22, 2011
Messages
33
Reaction score
1
I don't need your money, just take others files like pokemonium.
 
L

Lucila

Banned
Banned
Joined
Aug 28, 2013
Messages
539
Reaction score
103
Use this Database

Code: 
/*
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);
 
F

Facewithcock

Newbie Spellweaver
Joined
Sep 6, 2014
Messages
7
Reaction score
0
Lucila said:
Use this Database

Code: 
/*
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);
Click to expand...

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

Lucila

Banned
Banned
Joined
Aug 28, 2013
Messages
539
Reaction score
103
Is for your navicat..
use this package.. inside are a navicat that work 100%
You must be registered to see links
 
You must log in or register to reply here.

About Us

RaGEZONE® is a website dedicated to the development of massively multiplayer online role-playing games (MMORPGs).

Online statistics

Members online
225
Guests online
9,721
Total visitors
9,946
Totals may include hidden visitors.

Forum statistics

Threads
429,119
Messages
4,590,418
Members
280,775
Latest member
prowelll
Most visitors online was 10519 , on 26 Apr 2024

RaGEZONE Sponsor

    HyperFilter
Back
Top