schema.sql

-- pokemon table for d1
DROP TABLE IF EXISTS pokemon;
CREATE TABLE IF NOT EXISTS pokemon (
    id INT PRIMARY KEY,
    name VARCHAR(50) NOT NULL,
    type VARCHAR(50) NOT NULL
);

INSERT INTO pokemon (id, name, type) VALUES 
(1, 'Bulbasaur', 'Grass'),
(2, 'Ivysaur', 'Grass'),
(3, 'Venusaur', 'Grass'),
(4, 'Charmander', 'Fire'),
(5, 'Charmeleon', 'Fire'),
(6, 'Charizard', 'Fire'),
(7, 'Squirtle', 'Water'),
(8, 'Wartortle', 'Water'),
(9, 'Blastoise', 'Water'),
(10, 'Caterpie', 'Bug'),
(11, 'Metapod', 'Bug'),
(12, 'Butterfree', 'Bug'),
(13, 'Weedle', 'Bug'),
(14, 'Kakuna', 'Bug'),
(15, 'Beedrill', 'Bug'),
(16, 'Pidgey', 'Normal'),
(17, 'Pidgeotto', 'Normal'),
(18, 'Pidgeot', 'Normal'),
(19, 'Rattata', 'Normal'),
(20, 'Raticate', 'Normal'),
(21, 'Spearow', 'Normal'),
(22, 'Fearow', 'Normal'),
(23, 'Ekans', 'Poison'),
(24, 'Arbok', 'Poison'),
(25, 'Pikachu', 'Electric'),
(26, 'Raichu', 'Electric'),
(27, 'Sandshrew', 'Ground'),
(28, 'Sandslash', 'Ground'),
(29, 'Nidoran♀', 'Poison'),
(30, 'Nidorina', 'Poison'),
(31, 'Nidoqueen', 'Poison'),
(32, 'Nidoran♂', 'Poison'),
(33, 'Nidorino', 'Poison'),
(34, 'Nidoking', 'Poison'),
(35, 'Clefairy', 'Fairy'),
(36, 'Clefable', 'Fairy'),
(37, 'Vulpix', 'Fire'),
(38, 'Ninetales', 'Fire'),
(39, 'Jigglypuff', 'Normal'),
(40, 'Wigglytuff', 'Normal'),
(41, 'Zubat', 'Poison'),
(42, 'Golbat', 'Poison'),
(43, 'Oddish', 'GrassPoison'),
(44, 'Gloom', 'GrassPoison'),
(45, 'Vileplume', 'GrassPoison'),
(46, 'Paras', 'BugGrass'),
(47, 'Parasect', 'BugGrass'),
(48, 'Venonat', 'BugPoison'),
(49, 'Venomoth', 'BugPoison'),
(50, 'Diglett', 'Ground'),
(51, 'Dugtrio', 'Ground'),
(52, 'Meowth', 'Normal'),
(53, 'Persian', 'Normal'),
(54, 'Psyduck', 'Water'),
(55, 'Golduck', 'Water'),
(56, 'Mankey', 'Fighting'),
(57, 'Primeape', 'Fighting'),
(58, 'Growlithe', 'Fire'),
(59, 'Arcanine', 'Fire'),
(60, 'Poliwag', 'Water'),
(61, 'Poliwhirl', 'Water'),
(62, 'Poliwrath', 'WaterFighting'),
(63, 'Abra', 'Psychic'),
(64, 'Kadabra', 'Psychic'),
(65, 'Alakazam', 'Psychic'),
(66, 'Machop', 'Fighting'),
(67, 'Machoke', 'Fighting'),
(68, 'Machamp', 'Fighting'),
(69, 'Bellsprout', 'GrassPoison'),
(70, 'Weepinbell', 'GrassPoison'),
(71, 'Victreebel', 'GrassPoison'),
(72, 'Tentacool', 'WaterPoison'),
(73, 'Tentacruel', 'WaterPoison'),
(74, 'Geodude', 'RockGround'),
(75, 'Graveler', 'RockGround'),
(76, 'Golem', 'RockGround'),
(77, 'Ponyta', 'Fire'),
(78, 'Rapidash', 'Fire'),
(79, 'Slowpoke', 'WaterPsychic'),
(80, 'Slowbro', 'WaterPsychic'),
(81, 'Magnemite', 'ElectricSteel'),
(82, 'Magneton', 'ElectricSteel'),
(83, 'Farfetch''d', 'NormalFlying'),
(84, 'Doduo', 'NormalFlying'),
(85, 'Dodrio', 'NormalFlying'),
(86, 'Seel', 'Water'),
(87, 'Dewgong', 'WaterIce'),
(88, 'Grimer', 'Poison'),
(89, 'Muk', 'Poison'),
(90, 'Shellder', 'Water'),
(91, 'Cloyster', 'WaterIce'),
(92, 'Gastly', 'GhostPoison'),
(93, 'Haunter', 'GhostPoison'),
(94, 'Gengar', 'GhostPoison'),
(95, 'Onix', 'RockGround'),
(96, 'Drowzee', 'Psychic'),
(97, 'Hypno', 'Psychic'),
(98, 'Krabby', 'Water'),
(99, 'Kingler', 'Water'),
(100, 'Voltorb', 'Electric'),
(101, 'Electrode', 'Electric'),
(102, 'Exeggcute', 'GrassPsychic'),
(103, 'Exeggutor', 'GrassPsychic'),
(104, 'Cubone', 'Ground'),
(105, 'Marowak', 'Ground'),
(106, 'Hitmonlee', 'Fighting'),
(107, 'Hitmonchan', 'Fighting'),
(108, 'Lickitung', 'Normal'),
(109, 'Koffing', 'Poison'),
(110, 'Weezing', 'Poison'),
(111, 'Rhyhorn', 'GroundRock'),
(112, 'Rhydon', 'GroundRock'),
(113, 'Chansey', 'Normal'),
(114, 'Tangela', 'Grass'),
(115, 'Kangaskhan', 'Normal'),
(116, 'Horsea', 'Water'),
(117, 'Seadra', 'Water'),
(118, 'Goldeen', 'Water'),
(119, 'Seaking', 'Water'),
(120, 'Staryu', 'Water'),
(121, 'Starmie', 'WaterPsychic'),
(122, 'Mr. Mime', 'PsychicFairy'),
(123, 'Scyther', 'BugFlying'),
(124, 'Jynx', 'IcePsychic'),
(125, 'Electabuzz', 'Electric'),
(126, 'Magmar', 'Fire'),
(127, 'Pinsir', 'Bug'),
(128, 'Tauros', 'Normal'),
(129, 'Magikarp', 'Water'),
(130, 'Gyarados', 'WaterFlying'),
(131, 'Lapras', 'WaterIce'),
(132, 'Ditto', 'Normal'),
(133, 'Eevee', 'Normal'),
(134, 'Vaporeon', 'Water'),
(135, 'Jolteon', 'Electric'),
(136, 'Flareon', 'Fire'),
(137, 'Porygon', 'Normal'),
(138, 'Omanyte', 'RockWater'),
(139, 'Omastar', 'RockWater'),
(140, 'Kabuto', 'RockWater'),
(141, 'Kabutops', 'RockWater'),
(142, 'Aerodactyl', 'RockFlying'),
(143, 'Snorlax', 'Normal'),
(144, 'Articuno', 'IceFlying'),
(145, 'Zapdos', 'ElectricFlying'),
(146, 'Moltres', 'FireFlying'),
(147, 'Dratini', 'Dragon'),
(148, 'Dragonair', 'Dragon'),
(149, 'Dragonite', 'DragonFlying'),
(150, 'Mewtwo', 'Psychic'),
(151, 'Mew', 'Psychic');