SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- 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=307 DEFAULT CHARSET=latin1;