Context Navigation

← Previous Change
Next Change →

pokedex.sql

Timestamp:

08/19/07 16:08:28 (16 months ago)

Author:

eevee

Message:

Added slot numbers to the Pokemon ability map table, and changed the has_many definition to always sort by this column. Now seeing what ability your Pokemon will have after it evolves is guaranteed to be consistent. Some abilities have also been doubled, e.g. Jolteon which evolves from Eevee, which has two abilities. (#24)

Files:

: 1 modified

veekun/trunk/script/pokedex.sql (modified) (2 diffs)

Legend:

: Unmodified
: Added
: Removed

veekun/trunk/script/pokedex.sql

r276	r306
13020	13020	pokeid int(10) unsigned NOT NULL,
13021	13021	abilityid int(10) unsigned NOT NULL,
13022		PRIMARY KEY (pokeid,abilityid),
	13022	slot tinyint(1) unsigned NOT NULL,
	13023	PRIMARY KEY (pokeid,abilityid,slot),
13023	13024	KEY pokeid (pokeid),
13024	13025	KEY abilityid (abilityid)
…	…
13031	13032	LOCK TABLES pokemon_abilities WRITE;
13032	13033	/!40000 ALTER TABLE pokemon_abilities DISABLE KEYS /;
13033		INSERT INTO pokemon_abilities VALUES (1,65),
13034		(2,65),
13035		(3,65),
13036		(4,66),
13037		(5,66),
13038		(6,66),
13039		(7,67),
13040		(8,67),
13041		(9,67),
13042		(10,19),
13043		(11,61),
13044		(12,14),
13045		(13,19),
13046		(14,61),
13047		(15,68),
13048		(16,51),
13049		(16,77),
13050		(17,51),
13051		(17,77),
13052		(18,51),
13053		(18,77),
13054		(19,50),
13055		(19,62),
13056		(20,50),
13057		(20,62),
13058		(21,51),
13059		(22,51),
13060		(23,22),
13061		(23,61),
13062		(24,22),
13063		(24,61),
13064		(25,9),
13065		(26,9),
13066		(27,8),
13067		(28,8),
13068		(29,38),
13069		(29,79),
13070		(30,38),
13071		(30,79),
13072		(31,38),
13073		(31,79),
13074		(32,38),
13075		(32,79),
13076		(33,38),
13077		(33,79),
13078		(34,38),
13079		(34,79),
13080		(35,56),
13081		(35,98),
13082		(36,56),
13083		(36,98),
13084		(37,18),
13085		(38,18),
13086		(39,56),
13087		(40,56),
13088		(41,39),
13089		(42,39),
13090		(43,34),
13091		(44,34),
13092		(45,34),
13093		(46,27),
13094		(46,87),
13095		(47,27),
13096		(47,87),
13097		(48,14),
13098		(48,110),
13099		(49,19),
13100		(49,110),
13101		(50,8),
13102		(50,71),
13103		(51,8),
13104		(51,71),
13105		(52,53),
13106		(52,101),
13107		(53,7),
13108		(53,101),
13109		(54,6),
13110		(54,13),
13111		(55,6),
13112		(55,13),
13113		(56,72),
13114		(56,83),
13115		(57,72),
13116		(57,83),
13117		(58,18),
13118		(58,22),
13119		(59,18),
13120		(59,22),
13121		(60,6),
13122		(60,11),
13123		(61,6),
13124		(61,11),
13125		(62,6),
13126		(62,11),
13127		(63,28),
13128		(63,39),
13129		(64,28),
13130		(64,39),
13131		(65,28),
13132		(65,39),
13133		(66,62),
13134		(66,99),
13135		(67,62),
13136		(67,99),
13137		(68,62),
13138		(68,99),
13139		(69,34),
13140		(70,34),
13141		(71,34),
13142		(72,29),
13143		(72,64),
13144		(73,29),
13145		(73,64),
13146		(74,5),
13147		(74,69),
13148		(75,5),
13149		(75,69),
13150		(76,5),
13151		(76,69),
13152		(77,18),
13153		(77,50),
13154		(78,18),
13155		(78,50),
13156		(79,12),
13157		(79,20),
13158		(80,12),
13159		(80,20),
13160		(81,5),
13161		(81,42),
13162		(82,5),
13163		(82,42),
13164		(83,39),
13165		(83,51),
13166		(84,48),
13167		(84,50),
13168		(85,48),
13169		(85,50),
13170		(86,47),
13171		(86,93),
13172		(87,47),
13173		(87,93),
13174		(88,1),
13175		(88,60),
13176		(89,1),
13177		(89,60),
13178		(90,75),
13179		(90,92),
13180		(91,75),
13181		(91,92),
13182		(92,26),
13183		(93,26),
13184		(94,26),
13185		(95,5),
13186		(95,69),
13187		(96,15),
13188		(96,108),
13189		(97,15),
13190		(97,108),
13191		(98,52),
13192		(98,75),
13193		(99,52),
13194		(99,75),
13195		(100,9),
13196		(100,43),
13197		(101,9),
13198		(101,43),
13199		(102,34),
13200		(103,34),
13201		(104,31),
13202		(104,69),
13203		(105,31),
13204		(105,69),
13205		(106,7),
13206		(106,120),
13207		(107,51),
13208		(107,89),
13209		(108,12),
13210		(108,20),
13211		(109,26),
13212		(110,26),
13213		(111,31),
13214		(111,69),
13215		(112,31),
13216		(112,69),
13217		(113,30),
13218		(113,32),
13219		(114,34),
13220		(114,102),
13221		(115,48),
13222		(115,113),
13223		(116,33),
13224		(116,97),
13225		(117,38),
13226		(117,97),
13227		(118,33),
13228		(118,41),
13229		(119,33),
13230		(119,41),
13231		(120,30),
13232		(120,35),
13233		(121,30),
13234		(121,35),
13235		(122,43),
13236		(122,111),
13237		(123,68),
13238		(123,101),
13239		(124,12),
13240		(124,108),
13241		(125,9),
13242		(126,49),
13243		(127,52),
13244		(127,104),
13245		(128,22),
13246		(128,83),
13247		(129,33),
13248		(130,22),
13249		(131,11),
13250		(131,75),
13251		(132,7),
13252		(133,50),
13253		(133,91),
13254		(134,11),
13255		(135,10),
13256		(136,18),
13257		(137,36),
13258		(137,88),
13259		(138,33),
13260		(138,75),
13261		(139,33),
13262		(139,75),
13263		(140,4),
13264		(140,33),
13265		(141,4),
13266		(141,33),
13267		(142,46),
13268		(142,69),
13269		(143,17),
13270		(143,47),
13271		(144,46),
13272		(145,46),
13273		(146,46),
13274		(147,61),
13275		(148,61),
13276		(149,39),
13277		(150,46),
13278		(151,28),
13279		(152,65),
13280		(153,65),
13281		(154,65),
13282		(155,66),
13283		(156,66),
13284		(157,66),
13285		(158,67),
13286		(159,67),
13287		(160,67),
13288		(161,50),
13289		(161,51),
13290		(162,50),
13291		(162,51),
13292		(163,15),
13293		(163,51),
13294		(164,15),
13295		(164,51),
13296		(165,48),
13297		(165,68),
13298		(166,48),
13299		(166,68),
13300		(167,15),
13301		(167,68),
13302		(168,15),
13303		(168,68),
13304		(169,39),
13305		(170,10),
13306		(170,35),
13307		(171,10),
13308		(171,35),
13309		(172,9),
13310		(173,56),
13311		(173,98),
13312		(174,56),
13313		(175,32),
13314		(175,55),
13315		(176,32),
13316		(176,55),
13317		(177,28),
13318		(177,48),
13319		(178,28),
13320		(178,48),
13321		(179,9),
13322		(180,9),
13323		(181,9),
13324		(182,34),
13325		(183,37),
13326		(183,47),
13327		(184,37),
13328		(184,47),
13329		(185,5),
13330		(185,69),
13331		(186,6),
13332		(186,11),
13333		(187,34),
13334		(187,102),
13335		(188,34),
13336		(188,102),
13337		(189,34),
13338		(189,102),
13339		(190,50),
13340		(190,53),
13341		(191,34),
13342		(191,94),
13343		(192,34),
13344		(192,94),
13345		(193,3),
13346		(193,14),
13347		(194,6),
13348		(194,11),
13349		(195,6),
13350		(195,11),
13351		(196,28),
13352		(197,28),
13353		(198,15),
13354		(198,105),
13355		(199,12),
13356		(199,20),
13357		(200,26),
13358		(201,26),
13359		(202,23),
13360		(203,39),
13361		(203,48),
13362		(204,5),
13363		(205,5),
13364		(206,32),
13365		(206,50),
13366		(207,8),
13367		(207,52),
13368		(208,5),
13369		(208,69),
13370		(209,22),
13371		(209,50),
13372		(210,22),
13373		(210,95),
13374		(211,33),
13375		(211,38),
13376		(212,68),
13377		(212,101),
13378		(213,5),
13379		(213,82),
13380		(214,62),
13381		(214,68),
13382		(215,39),
13383		(215,51),
13384		(216,53),
13385		(216,95),
13386		(217,62),
13387		(217,95),
13388		(218,40),
13389		(218,49),
13390		(219,40),
13391		(219,49),
13392		(220,12),
13393		(220,81),
13394		(221,12),
13395		(221,81),
13396		(222,30),
13397		(222,55),
13398		(223,55),
13399		(223,97),
13400		(224,21),
13401		(224,97),
13402		(225,55),
13403		(225,72),
13404		(226,11),
13405		(226,33),
13406		(227,5),
13407		(227,51),
13408		(228,18),
13409		(228,48),
13410		(229,18),
13411		(229,48),
13412		(230,33),
13413		(230,97),
13414		(231,53),
13415		(232,5),
13416		(233,36),
13417		(233,88),
13418		(234,22),
13419		(234,119),
13420		(235,20),
13421		(235,101),
13422		(236,62),
13423		(236,80),
13424		(237,22),
13425		(237,101),
13426		(238,12),
13427		(238,108),
13428		(239,9),
13429		(240,49),
13430		(241,47),
13431		(241,113),
13432		(242,30),
13433		(242,32),
13434		(243,46),
13435		(244,46),
13436		(245,46),
13437		(246,62),
13438		(247,61),
13439		(248,45),
13440		(249,46),
13441		(250,46),
13442		(251,30),
13443		(252,65),
13444		(253,65),
13445		(254,65),
13446		(255,66),
13447		(256,66),
13448		(257,66),
13449		(258,67),
13450		(259,67),
13451		(260,67),
13452		(261,50),
13453		(261,95),
13454		(262,22),
13455		(262,95),
13456		(263,53),
13457		(263,82),
13458		(264,53),
13459		(264,82),
13460		(265,19),
13461		(266,61),
13462		(267,68),
13463		(268,61),
13464		(269,19),
13465		(270,33),
13466		(270,44),
13467		(271,33),
13468		(271,44),
13469		(272,33),
13470		(272,44),
13471		(273,34),
13472		(273,48),
13473		(274,34),
13474		(274,48),
13475		(275,34),
13476		(275,48),
13477		(276,62),
13478		(277,62),
13479		(278,51),
13480		(279,51),
13481		(280,28),
13482		(280,36),
13483		(281,28),
13484		(281,36),
13485		(282,28),
13486		(282,36),
13487		(283,33),
13488		(284,22),
13489		(285,27),
13490		(285,90),
13491		(286,27),
13492		(286,90),
13493		(287,54),
13494		(288,72),
13495		(289,54),
13496		(290,14),
13497		(291,3),
13498		(292,25),
13499		(293,43),
13500		(294,43),
13501		(295,43),
13502		(296,47),
13503		(296,62),
13504		(297,47),
13505		(297,62),
13506		(298,37),
13507		(298,47),
13508		(299,5),
13509		(299,42),
13510		(300,56),
13511		(300,96),
13512		(301,56),
13513		(301,96),
13514		(302,51),
13515		(302,100),
13516		(303,22),
13517		(303,52),
13518		(304,5),
13519		(304,69),
13520		(305,5),
13521		(305,69),
13522		(306,5),
13523		(306,69),
13524		(307,74),
13525		(308,74),
13526		(309,9),
13527		(309,31),
13528		(310,9),
13529		(310,31),
13530		(311,57),
13531		(312,58),
13532		(313,35),
13533		(313,68),
13534		(314,12),
13535		(314,110),
13536		(315,30),
13537		(315,38),
13538		(316,60),
13539		(316,64),
13540		(317,60),
13541		(317,64),
13542		(318,24),
13543		(319,24),
13544		(320,12),
13545		(320,41),
13546		(321,12),
13547		(321,41),
13548		(322,12),
13549		(322,86),
13550		(323,40),
13551		(323,116),
13552		(324,73),
13553		(325,20),
13554		(325,47),
13555		(326,20),
13556		(326,47),
13557		(327,20),
13558		(327,77),
13559		(328,52),
13560		(328,71),
13561		(329,26),
13562		(330,26),
13563		(331,8),
13564		(332,8),
13565		(333,30),
13566		(334,30),
13567		(335,17),
13568		(336,61),
13569		(337,26),
13570		(338,26),
13571		(339,12),
13572		(339,107),
13573		(340,12),
13574		(340,107),
13575		(341,52),
13576		(341,75),
13577		(342,52),
13578		(342,75),
13579		(343,26),
13580		(344,26),
13581		(345,21),
13582		(346,21),
13583		(347,4),
13584		(348,4),
13585		(349,33),
13586		(350,63),
13587		(351,59),
13588		(352,16),
13589		(353,15),
13590		(353,119),
13591		(354,15),
13592		(354,119),
13593		(355,26),
13594		(356,46),
13595		(357,34),
13596		(357,94),
13597		(358,26),
13598		(359,46),
13599		(359,105),
13600		(360,23),
13601		(361,39),
13602		(361,115),
13603		(362,39),
13604		(362,115),
13605		(363,47),
13606		(363,115),
13607		(364,47),
13608		(364,115),
13609		(365,47),
13610		(365,115),
13611		(366,75),
13612		(367,33),
13613		(368,33),
13614		(369,33),
13615		(369,69),
13616		(370,33),
13617		(371,69),
13618		(372,69),
13619		(373,22),
13620		(374,29),
13621		(375,29),
13622		(376,29),
13623		(377,29),
13624		(378,29),
13625		(379,29),
13626		(380,26),
13627		(381,26),
13628		(382,2),
13629		(383,70),
13630		(384,76),
13631		(385,32),
13632		(386,46),
13633		(387,65),
13634		(388,65),
13635		(389,65),
13636		(390,66),
13637		(391,66),
13638		(392,66),
13639		(393,67),
13640		(394,67),
13641		(395,67),
13642		(396,51),
13643		(397,22),
13644		(398,22),
13645		(399,86),
13646		(399,109),
13647		(400,86),
13648		(400,109),
13649		(401,61),
13650		(402,68),
13651		(403,22),
13652		(403,79),
13653		(404,22),
13654		(404,79),
13655		(405,22),
13656		(405,79),
13657		(406,30),
13658		(406,38),
13659		(407,30),
13660		(407,38),
13661		(408,104),
13662		(409,104),
13663		(410,5),
13664		(411,5),
13665		(412,61),
13666		(413,107),
13667		(414,68),
13668		(415,118),
13669		(416,46),
13670		(417,50),
13671		(417,53),
13672		(418,33),
13673		(419,33),
13674		(420,34),
13675		(421,122),
13676		(422,60),
13677		(422,114),
13678		(423,60),
13679		(423,114),
13680		(424,53),
13681		(424,101),
13682		(425,84),
13683		(425,106),
13684		(426,84),
13685		(426,106),
13686		(427,50),
13687		(427,103),
13688		(428,56),
13689		(428,103),
13690		(429,26),
13691		(430,15),
13692		(430,105),
13693		(431,7),
13694		(431,20),
13695		(432,20),
13696		(432,47),
13697		(433,26),
13698		(434,1),
13699		(434,106),
13700		(435,1),
13701		(435,106),
13702		(436,26),
13703		(436,85),
13704		(437,26),
13705		(437,85),
13706		(438,5),
13707		(438,69),
13708		(439,43),
13709		(439,111),
13710		(440,30),
13711		(440,32),
13712		(441,51),
13713		(441,77),
13714		(442,46),
13715		(443,8),
13716		(444,8),
13717		(445,8),
13718		(446,47),
13719		(446,53),
13720		(447,39),
13721		(447,80),
13722		(448,39),
13723		(448,80),
13724		(449,45),
13725		(450,45),
13726		(451,4),
13727		(451,97),
13728		(452,4),
13729		(452,97),
13730		(453,87),
13731		(453,107),
13732		(454,87),
13733		(454,107),
13734		(455,26),
13735		(456,33),
13736		(456,114),
13737		(457,33),
13738		(457,114),
13739		(458,11),
13740		(458,33),
13741		(459,117),
13742		(460,117),
13743		(461,46),
13744		(462,5),
13745		(462,42),
13746		(463,12),
13747		(463,20),
13748		(464,31),
13749		(464,116),
13750		(465,34),
13751		(465,102),
13752		(466,78),
13753		(467,49),
13754		(468,32),
13755		(468,55),
13756		(469,3),
13757		(469,110),
13758		(470,102),
13759		(471,81),
13760		(472,8),
13761		(472,52),
13762		(473,12),
13763		(473,81),
13764		(474,88),
13765		(474,91),
13766		(475,80),
13767		(476,5),
13768		(476,42),
13769		(477,46),
13770		(478,81),
13771		(479,26),
13772		(480,26),
13773		(481,26),
13774		(482,26),
13775		(483,46),
13776		(484,46),
13777		(485,18),
13778		(486,112),
13779		(487,46),
13780		(488,26),
13781		(489,93),
13782		(490,93),
13783		(491,123),
13784		(492,30),
13785		(493,121),
13786		(496,46),
13787		(497,46),
13788		(498,46),
13789		(499,107),
13790		(500,107);
	13034	INSERT INTO pokemon_abilities VALUES (1,65,1),
	13035	(2,65,1),
	13036	(3,65,1),
	13037	(4,66,1),
	13038	(5,66,1),
	13039	(6,66,1),
	13040	(7,67,1),
	13041	(8,67,1),
	13042	(9,67,1),
	13043	(10,19,1),
	13044	(11,61,1),
	13045	(12,14,1),
	13046	(13,19,1),
	13047	(14,61,1),
	13048	(15,68,1),
	13049	(16,51,1),
	13050	(16,77,2),
	13051	(17,51,1),
	13052	(17,77,2),
	13053	(18,51,1),
	13054	(18,77,2),
	13055	(19,50,1),
	13056	(19,62,2),
	13057	(20,50,1),
	13058	(20,62,2),
	13059	(21,51,1),
	13060	(22,51,1),
	13061	(23,22,1),
	13062	(23,61,2),
	13063	(24,22,1),
	13064	(24,61,2),
	13065	(25,9,1),
	13066	(26,9,1),
	13067	(27,8,1),
	13068	(28,8,1),
	13069	(29,38,1),
	13070	(29,79,2),
	13071	(30,38,1),
	13072	(30,79,2),
	13073	(31,38,1),
	13074	(31,79,2),
	13075	(32,38,1),
	13076	(32,79,2),
	13077	(33,38,1),
	13078	(33,79,2),
	13079	(34,38,1),
	13080	(34,79,2),
	13081	(35,56,1),
	13082	(35,98,2),
	13083	(36,56,1),
	13084	(36,98,2),
	13085	(37,18,1),
	13086	(38,18,1),
	13087	(39,56,1),
	13088	(40,56,1),
	13089	(41,39,1),
	13090	(42,39,1),
	13091	(43,34,1),
	13092	(44,34,1),
	13093	(45,34,1),
	13094	(46,27,1),
	13095	(46,87,2),
	13096	(47,27,1),
	13097	(47,87,2),
	13098	(48,14,1),
	13099	(48,110,2),
	13100	(49,19,1),
	13101	(49,110,2),
	13102	(50,8,1),
	13103	(50,71,2),
	13104	(51,8,1),
	13105	(51,71,2),
	13106	(52,53,1),
	13107	(52,101,2),
	13108	(53,7,1),
	13109	(53,101,2),
	13110	(54,6,1),
	13111	(54,13,2),
	13112	(55,6,1),
	13113	(55,13,2),
	13114	(56,72,1),
	13115	(56,83,2),
	13116	(57,72,1),
	13117	(57,83,2),
	13118	(58,18,1),
	13119	(58,22,2),
	13120	(59,18,1),
	13121	(59,22,2),
	13122	(60,6,1),
	13123	(60,11,2),
	13124	(61,6,1),
	13125	(61,11,2),
	13126	(62,6,1),
	13127	(62,11,2),
	13128	(63,28,1),
	13129	(63,39,2),
	13130	(64,28,1),
	13131	(64,39,2),
	13132	(65,28,1),
	13133	(65,39,2),
	13134	(66,62,1),
	13135	(66,99,2),
	13136	(67,62,1),
	13137	(67,99,2),
	13138	(68,62,1),
	13139	(68,99,2),
	13140	(69,34,1),
	13141	(70,34,1),
	13142	(71,34,1),
	13143	(72,29,1),
	13144	(72,64,2),
	13145	(73,29,1),
	13146	(73,64,2),
	13147	(74,5,1),
	13148	(74,69,2),
	13149	(75,5,1),
	13150	(75,69,2),
	13151	(76,5,1),
	13152	(76,69,2),
	13153	(77,18,1),
	13154	(77,50,2),
	13155	(78,18,1),
	13156	(78,50,2),
	13157	(79,12,1),
	13158	(79,20,2),
	13159	(80,12,1),
	13160	(80,20,2),
	13161	(81,5,1),
	13162	(81,42,2),
	13163	(82,5,1),
	13164	(82,42,2),
	13165	(83,39,1),
	13166	(83,51,2),
	13167	(84,48,1),
	13168	(84,50,2),
	13169	(85,48,1),
	13170	(85,50,2),
	13171	(86,47,1),
	13172	(86,93,2),
	13173	(87,47,1),
	13174	(87,93,2),
	13175	(88,1,1),
	13176	(88,60,2),
	13177	(89,1,1),
	13178	(89,60,2),
	13179	(90,75,1),
	13180	(90,92,2),
	13181	(91,75,1),
	13182	(91,92,2),
	13183	(92,26,1),
	13184	(93,26,1),
	13185	(94,26,1),
	13186	(95,5,1),
	13187	(95,69,2),
	13188	(96,15,1),
	13189	(96,108,2),
	13190	(97,15,1),
	13191	(97,108,2),
	13192	(98,52,1),
	13193	(98,75,2),
	13194	(99,52,1),
	13195	(99,75,2),
	13196	(100,9,1),
	13197	(100,43,2),
	13198	(101,9,1),
	13199	(101,43,2),
	13200	(102,34,1),
	13201	(103,34,1),
	13202	(104,31,1),
	13203	(104,69,2),
	13204	(105,31,1),
	13205	(105,69,2),
	13206	(106,7,1),
	13207	(106,120,2),
	13208	(107,51,1),
	13209	(107,89,2),
	13210	(108,12,1),
	13211	(108,20,2),
	13212	(109,26,1),
	13213	(110,26,1),
	13214	(111,31,1),
	13215	(111,69,2),
	13216	(112,31,1),
	13217	(112,69,2),
	13218	(113,30,1),
	13219	(113,32,2),
	13220	(114,34,1),
	13221	(114,102,2),
	13222	(115,48,1),
	13223	(115,113,2),
	13224	(116,33,1),
	13225	(116,97,2),
	13226	(117,38,1),
	13227	(117,97,2),
	13228	(118,33,1),
	13229	(118,41,2),
	13230	(119,33,1),
	13231	(119,41,2),
	13232	(120,30,1),
	13233	(120,35,2),
	13234	(121,30,1),
	13235