-- Script de Poblado (Seeding) de la Pokedex
-- Incluye una selección representativa de las 9 generaciones

SET FOREIGN_KEY_CHECKS = 0;
TRUNCATE TABLE ltic_pokedex;

INSERT INTO ltic_pokedex (id, nombre, tipo1, tipo2, region_origen_id) VALUES
-- GEN 1: KANTO (Region 1)
(1, 'Bulbasaur', 'Planta', 'Veneno', 1),
(4, 'Charmander', 'Fuego', NULL, 1),
(7, 'Squirtle', 'Agua', NULL, 1),
(25, 'Pikachu', 'Eléctrico', NULL, 1),
(35, 'Clefairy', 'Hada', NULL, 1),
(37, 'Vulpix', 'Fuego', NULL, 1),
(52, 'Meowth', 'Normal', NULL, 1),
(54, 'Psyduck', 'Agua', NULL, 1),
(58, 'Growlithe', 'Fuego', NULL, 1),
(63, 'Abra', 'Psíquico', NULL, 1),
(66, 'Machop', 'Lucha', NULL, 1),
(74, 'Geodude', 'Roca', 'Tierra', 1),
(92, 'Gastly', 'Fantasma', 'Veneno', 1),
(95, 'Onix', 'Roca', 'Tierra', 1),
(133, 'Eevee', 'Normal', NULL, 1),
(143, 'Snorlax', 'Normal', NULL, 1),
(149, 'Dragonite', 'Dragón', 'Volador', 1),
(150, 'Mewtwo', 'Psíquico', NULL, 1),

-- GEN 2: JOHTO (Region 2)
(152, 'Chikorita', 'Planta', NULL, 2),
(155, 'Cyndaquil', 'Fuego', NULL, 2),
(158, 'Totodile', 'Agua', NULL, 2),
(175, 'Togepi', 'Hada', NULL, 2),
(179, 'Mareep', 'Eléctrico', NULL, 2),
(183, 'Marill', 'Agua', 'Hada', 2),
(185, 'Sudowoodo', 'Roca', NULL, 2),
(196, 'Espeon', 'Psíquico', NULL, 2),
(197, 'Umbreon', 'Siniestro', NULL, 2),
(208, 'Steelix', 'Acero', 'Tierra', 2),
(212, 'Scizor', 'Bicho', 'Acero', 2),
(214, 'Heracross', 'Bicho', 'Lucha', 2),
(228, 'Houndour', 'Siniestro', 'Fuego', 2),
(248, 'Tyranitar', 'Roca', 'Siniestro', 2),
(249, 'Lugia', 'Psíquico', 'Volador', 2),

-- GEN 3: HOENN (Region 3)
(252, 'Treecko', 'Planta', NULL, 3),
(255, 'Torchic', 'Fuego', NULL, 3),
(258, 'Mudkip', 'Agua', NULL, 3),
(280, 'Ralts', 'Psíquico', 'Hada', 3),
(302, 'Sableye', 'Siniestro', 'Fantasma', 3),
(304, 'Aron', 'Acero', 'Roca', 3),
(359, 'Absol', 'Siniestro', NULL, 3),
(371, 'Bagon', 'Dragón', NULL, 3),
(374, 'Beldum', 'Acero', 'Psíquico', 3),
(384, 'Rayquaza', 'Dragón', 'Volador', 3),

-- GEN 4: SINNOH (Region 4)
(387, 'Turtwig', 'Planta', NULL, 4),
(390, 'Chimchar', 'Fuego', NULL, 4),
(393, 'Piplup', 'Agua', NULL, 4),
(403, 'Shinx', 'Eléctrico', NULL, 4),
(443, 'Gible', 'Dragón', 'Tierra', 4),
(447, 'Riolu', 'Lucha', NULL, 4),
(448, 'Lucario', 'Lucha', 'Acero', 4),
(479, 'Rotom', 'Eléctrico', 'Fantasma', 4),

-- GEN 5: TESELIA (Region 5)
(495, 'Snivy', 'Planta', NULL, 5),
(498, 'Tepig', 'Fuego', NULL, 5),
(501, 'Oshawott', 'Agua', NULL, 5),
(570, 'Zorua', 'Siniestro', NULL, 5),
(609, 'Chandelure', 'Fantasma', 'Fuego', 5),
(612, 'Haxorus', 'Dragón', NULL, 5),
(635, 'Hydreigon', 'Siniestro', 'Dragón', 5),

-- GEN 6: KALOS (Region 6)
(650, 'Chespin', 'Planta', NULL, 6),
(653, 'Fennekin', 'Fuego', NULL, 6),
(656, 'Froakie', 'Agua', NULL, 6),
(663, 'Talonflame', 'Fuego', 'Volador', 6),
(700, 'Sylveon', 'Hada', NULL, 6),
(704, 'Goomy', 'Dragón', NULL, 6),
(718, 'Zygarde', 'Dragón', 'Tierra', 6),

-- GEN 7: ALOLA (Region 7)
(722, 'Rowlet', 'Planta', 'Volador', 7),
(725, 'Litten', 'Fuego', NULL, 7),
(728, 'Popplio', 'Agua', NULL, 7),
(744, 'Rockruff', 'Roca', NULL, 7),
(760, 'Bewear', 'Normal', 'Lucha', 7),
(778, 'Mimikyu', 'Fantasma', 'Hada', 7),
(785, 'Tapu Koko', 'Eléctrico', 'Hada', 7),

-- GEN 8: GALAR (Region 8)
(810, 'Grookey', 'Planta', NULL, 8),
(813, 'Scorbunny', 'Fuego', NULL, 8),
(816, 'Sobble', 'Agua', NULL, 8),
(823, 'Corviknight', 'Volador', 'Acero', 8),
(877, 'Morpeko', 'Eléctrico', 'Siniestro', 8),
(887, 'Dragapult', 'Dragón', 'Fantasma', 8),

-- GEN 9: PALDEA (Region 9)
(906, 'Sprigatito', 'Planta', NULL, 9),
(909, 'Fuecoco', 'Fuego', NULL, 9),
(912, 'Quaxly', 'Agua', NULL, 9),
(924, 'Tandemaus', 'Normal', NULL, 9),
(957, 'Tinkatink', 'Hada', 'Acero', 9),
(979, 'Annihilape', 'Lucha', 'Fantasma', 9);

SET FOREIGN_KEY_CHECKS = 1;

SELECT CONCAT('Se han insertado ', COUNT(*), ' Pokemon en la Pokedex.') AS Status FROM ltic_pokedex;