-- Pokemon Database
-- Base de données des pokemon de la première version
-- Utilisée à des fins pédagogiques

-- Bastien Thouverez
DROP DATABASE IF EXISTS pokemon;
CREATE DATABASE pokemon DEFAULT CHARSET utf8; 
USE pokemon;

DROP TABLE IF EXISTS detient_pokemons, est_type, evolue_en;
DROP TABLE IF EXISTS attaques, types, pokemons, dresseurs;


-- Structure de la table pokemons
-- Table de base
CREATE TABLE pokemons (
	id SERIAL NOT NULL,
	nom varchar(10) NOT NULL,
	PRIMARY KEY(id)
);

-- Table evolue_en
-- Un pokémon peut évoluer en un autre pokémon à un certain niveau
-- lvl = -1 -> nécessite une pierre pour évoluer
-- lvl = -2 -> nécessite un échange pour évoluer
CREATE TABLE evolue_en (
	pokemon_base_id bigint(20) unsigned NOT NULL,
	pokemon_evol_id bigint(20) unsigned NOT NULL,
	niveau int NOT NULL,
	FOREIGN KEY(pokemon_base_id) REFERENCES pokemons(id),
	FOREIGN KEY(pokemon_evol_id) REFERENCES pokemons(id)
);

-- Structure de la table type
-- Table des types, pour les pokemons et les attaques
CREATE TABLE types (
	id SERIAL NOT NULL,
	libelle varchar(10) NOT NULL,
	PRIMARY KEY(id)
);

-- Structure de la table est_type
-- Fait le lien entre un pokemon et un type
CREATE TABLE est_type (
	pokemon_id bigint(20) unsigned NOT NULL,
	type_id bigint(20) unsigned NOT NULL,
	FOREIGN KEY(pokemon_id) REFERENCES pokemons(id),
	FOREIGN KEY(type_id) REFERENCES types(id)
);
	
-- Structure de la table dresseurs
CREATE TABLE dresseurs (
	id SERIAL NOT NULL,
	nom varchar(25) NOT NULL,
	PRIMARY KEY(id)
);


-- Table détientPokémon
-- Un dresseur détient au maximum 6 pokémons
CREATE TABLE detient_pokemons (
	dresseur_id bigint(20) unsigned NOT NULL, 
	pokemon_id bigint(20) unsigned NOT NULL,  
	niveau int NOT NULL,
	FOREIGN KEY(dresseur_id) REFERENCES dresseurs(id),
	FOREIGN KEY(pokemon_id) REFERENCES pokemons(id)
);

-- Structure de la table attaque
-- Attaques des pokémons
CREATE TABLE attaques (
	id SERIAL NOT NULL,
	libelle varchar(50) NOT NULL,
	type_id bigint(20) unsigned NOT NULL,
	pp int NOT NULL,
	puissance int NULL,
	precisions int NOT NULL,
	PRIMARY KEY(id),
	FOREIGN KEY(type_id) REFERENCES types(id)
);

-- Attaques
-- https://www.pokemontrash.com/rouge-bleu-jaune/liste-attaques.php



-- Gestion de la carte du monde
-- Tous les élements de la carte sont regroupés dans une table afin qu'ils aient un id unique
-- Les élements de la map sont: des villes, des sites et des routes
-- Les routes ont l'id de leur numéro
-- CREATE TABLE mapElement (
-- 	'id_elem' SERIAL NOT NULL PRIMARY KEY
-- );
-- 
-- CREATE TABLE ville (
-- 	'id_ville' int NOT NULL, -- FK mapElement(id_elem)
-- 	'nom_ville' varchar(25) 
-- );
-- 
-- CREATE TABLE site (
-- 	'id_site' int NOT NULL, -- FK mapElement(id_elem)
-- 	'nom_site' varchar(25)
-- );
-- 
-- CREATE TABLE route (
-- 	'id_route' int NOT NULL, -- FK mapElement(id_elem)
-- 	'type_route' varchar(20) NOT NULL -- maritime ou terrestre
-- );
-- 
-- -- id_elem peut représenter une route ou un site:
-- --   Une route relie deux elements de la carte
-- --   Un site a une entrée et une sortie qui sont des éléments de map
-- CREATE TABLE liensMap (
-- 	'id_elem' int NOT NULL, -- FK route(id_route)
-- 	'id_elem_in' int NOT NULL, -- FK mapElement(id_elem)
-- 	'id_elem_out' int NOT NULL -- FK mapElement(id_elem)
-- );


--
-- DATA
--

-- TRUNCATE TABLE attaques CASCADE;
-- TRUNCATE TABLE types CASCADE;
-- TRUNCATE TABLE pokemons CASCADE;
-- TRUNCATE TABLE dresseurs CASCADE;

-- http://www.g33kmania.com/liste-pokemon-generation-1/
INSERT INTO pokemons (id, nom) VALUES
	(  1, 'Bulbizarre'),
	(  2, 'Herbizarre'),
	(  3, 'Florizarre'),
	(  4, 'Salameche'),
	(  5, 'Reptincel'),
	(  6, 'Dracaufeu'),
	(  7, 'Carapuce'),
	(  8, 'Carabaffe'),
	(  9, 'Tortank'),
	( 10, 'Chenipan'),
	( 11, 'Chrysacier'),
	( 12, 'Papilusion'),
	( 13, 'Aspicot'),
	( 14, 'Coconfort'),
	( 15, 'Dardargnan'),
	( 16, 'Roucool'),
	( 17, 'Roucoups'),
	( 18, 'Roucarnage'),
	( 19, 'Rattata'),
	( 20, 'Rattatac'),
	( 21, 'Piafabec'),
	( 22, 'Rapasdepic'),
	( 23, 'Abo'),
	( 24, 'Arbok'),
	( 25, 'Pikachu'),
	( 26, 'Raichu'),
	( 27, 'Sabelette'),
	( 28, 'Sablaireau'),
	-- ( 29, 'Nidoran♀'),
	( 29, 'NidoranF'),
	( 30, 'Nidorina'),
	( 31, 'Nidoqueen'),
	-- ( 32, 'Nidoran♂'),
	( 32, 'NidoranM'),
	( 33, 'Nidorino'),
	( 34, 'Nidoking'),
	( 35, 'Melofee'),
	( 36, 'Melodelfe'),
	( 37, 'Goupix'),
	( 38, 'Feunard'),
	( 39, 'Rondoudou'),
	( 40, 'Grodoudou'),
	( 41, 'Nosferapti'),
	( 42, 'Nosferalto'),
	( 43, 'Mystherbe'),
	( 44, 'Ortide'),
	( 45, 'Rafflesia'),
	( 46, 'Paras'),
	( 47, 'Parasect'),
	( 48, 'Mimitoss'),
	( 49, 'Aeromite'),
	( 50, 'Taupiqueur'),
	( 51, 'Triopikeur'),
	( 52, 'Miaouss'),
	( 53, 'Persian'),
	( 54, 'Psykokwak'),
	( 55, 'Akwakwak'),
	( 56, 'Ferosinge'),
	( 57, 'Colossinge'),
	( 58, 'Caninos'),
	( 59, 'Arcanin'),
	( 60, 'Ptitard'),
	( 61, 'Tetarte'),
	( 62, 'Tartard'),
	( 63, 'Abra'),
	( 64, 'Kadabra'),
	( 65, 'Alakazam'),
	( 66, 'Machoc'),
	( 67, 'Machopeur'),
	( 68, 'Mackogneur'),
	( 69, 'Chetiflor'),
	( 70, 'Boustiflor'),
	( 71, 'Empiflor'),
	( 72, 'Tentacool'),
	( 73, 'Tentacruel'),
	( 74, 'Racaillou'),
	( 75, 'Gravalanch'),
	( 76, 'Grolem'),
	( 77, 'Ponyta'),
	( 78, 'Galopa'),
	( 79, 'Ramoloss'),
	( 80, 'Flagadoss'),
	( 81, 'Magneti'),
	( 82, 'Magneton'),
	( 83, 'Canarticho'),
	( 84, 'Doduo'),
	( 85, 'Dodrio'),
	( 86, 'Otaria'),
	( 87, 'Lamantine'),
	( 88, 'Tadmorv'),
	( 89, 'Grotadmorv'),
	( 90, 'Kokiyas'),
	( 91, 'Crustabri'),
	( 92, 'Fantominus'),
	( 93, 'Spectrum'),
	( 94, 'Ectoplasma'),
	( 95, 'Onix'),
	( 96, 'Soporifik'),
	( 97, 'Hypnomade'),
	( 98, 'Krabby'),
	( 99, 'Krabboss'),
	(100, 'Voltorbe'),
	(101, 'Electrode'),
	(102, 'Noeunoeuf'),
	(103, 'Noadkoko'),
	(104, 'Osselait'),
	(105, 'Ossatueur'),
	(106, 'Kicklee'),
	(107, 'Tygnon'),
	(108, 'Excelangue'),
	(109, 'Smogo'),
	(110, 'Smogogo'),
	(111, 'Rhinocorne'),
	(112, 'Rhinoferos'),
	(113, 'Leveinard'),
	(114, 'Saquedeneu'),
	(115, 'Kangourex'),
	(116, 'Hypotrempe'),
	(117, 'Hypocean'),
	(118, 'Poissirene'),
	(119, 'Poissoroy'),
	(120, 'Stari'),
	(121, 'Staross'),
	(122, 'M. Mime'),
	(123, 'Insecateur'),
	(124, 'Lippoutou'),
	(125, 'Elektek'),
	(126, 'Magmar'),
	(127, 'Scarabrute'),
	(128, 'Tauros'),
	(129, 'Magicarpe'),
	(130, 'Leviator'),
	(131, 'Lokhlass'),
	(132, 'Metamorph'),
	(133, 'Evoli'),
	(134, 'Aquali'),
	(135, 'Voltali'),
	(136, 'Pyroli'),
	(137, 'Porygon'),
	(138, 'Amonita'),
	(139, 'Amonistar'),
	(140, 'Kabuto'),
	(141, 'Kabutops'),
	(142, 'Ptera'),
	(143, 'Ronflex'),
	(144, 'Artikodin'),
	(145, 'Electhor'),
	(146, 'Sulfura'),
	(147, 'Minidraco'),
	(148, 'Draco'),
	(149, 'Dracolosse'),
	(150, 'Mewtwo'),
	(151, 'Mew');

INSERT INTO types (id, libelle) VALUES 
	(  1, 'Combat'),
	(  2, 'Dragon'),
	(  3, 'Eau'),
	(  4, 'Electrique'),
	(  5, 'Feu'),
	(  6, 'Glace'),
	(  7, 'Insecte'),
	(  8, 'Normal'),
	(  9, 'Plante'),
	( 10, 'Poison'),
	( 11, 'Psy'),
	( 12, 'Roche'),
	( 13, 'Sol'),
	( 14, 'Spectre'),
	( 15, 'Vol');

INSERT INTO attaques (id, libelle, type_id, pp, puissance, precisions) VALUES
	(  1, 'Abîme', 			13, 5, 	null, 	30),
	(  2, 'Acid''armure', 	10, 40, null, 	100),
	(  3, 'Acide', 			10, 30, 40, 	100),
	(  4, 'Adaptation', 	8, 	40, null, 	100),
	(  5, 'Affûtage', 		8, 	30, null, 	100),
	(  6, 'Amnésie', 		11, 20, null, 	100),
	(  7, 'Armure', 		8, 	30, null, 	100),
	(  8, 'Balayage', 		1, 	20, 50, 	90),
	(  9, 'Bec Vrille', 	15, 20, 80, 	100),
	( 10, 'Bélier', 		8, 	20, 90, 	85),
	( 11, 'Berceuse', 		8, 	15, null, 	55),
	( 12, 'Blizzard', 		6, 	5, 	120, 	90),
	( 13, 'Bomb''oeuf', 	8, 	10, 100, 	75),
	( 14, 'Bouclier', 		11, 30, null, 	100),
	( 15, 'Boul''armure', 	8, 	20, null, 	100),
	( 16, 'Brouillard', 	8, 	20, null, 	100),
	( 17, 'Brume', 			6, 	30, null, 	100),
	( 18, 'Buée noire', 	6, 	30, null, 	100),
	( 19, 'Bulles d''O', 	3, 	20, 65, 	100),
	( 20, 'Cage éclair', 	4, 	20, null, 	100),
	( 21, 'Cascade', 		3, 	15, 80, 	100),
	( 22, 'Charge', 		8, 	35, 35, 	85),
	( 23, 'Choc mental', 	11, 25, 50, 	100),
	( 24, 'Claquoir', 		3, 	10, 35, 	75),
	( 25, 'Clonage', 		8, 	10, null, 	100),
	( 26, 'Combo-griffes', 	8, 	15, 20, 	80),
	( 27, 'Constriction', 	8, 	35, 10, 	100),
	( 28, 'Copie', 			8, 	10, null, 	100),
	( 29, 'Coud''boule', 	8, 	15, 70, 	100),
	( 30, 'Coud''krâne', 	8, 	15, 100, 	100),
	( 31, 'Coupe', 			8, 	30, 50, 	95),
	( 32, 'Coupe-vent', 	8, 	10, 80, 	75),
	( 33, 'Croc de mort', 	8, 	15, 80, 	70),
	( 34, 'Croc fatal', 	8, 	10, null, 	90),
	( 35, 'Croissance', 	8, 	40, null, 	100),
	( 36, 'Cru-aile', 		15, 35, 35, 	100),
	( 37, 'Cyclone', 		8, 	20, null, 	85),
	( 38, 'Damoclès', 		8, 	15, 15, 	100),
	( 39, 'Danse-Flamme', 	5, 	15, 15, 	70),
	( 40, 'Danse-Fleur', 	9, 	20, 70, 	100),
	( 41, 'Danse-Lames', 	8, 	30, null, 	100),
	( 42, 'Dard-Nuée', 		7, 	20, 14, 	85),
	( 43, 'Dard-Venin', 	10, 35, 15, 	100),
	( 44, 'Déflagration', 	5, 	5, 	120, 	85),
	( 45, 'Destruction', 	8, 	5, 	260, 	100),
	( 46, 'Détitrus', 		10, 20, 65, 	100),
	( 47, 'Dévorêve', 		11, 15, 100, 	100),
	( 48, 'Double-Dard', 	7, 	20, 25, 	100),
	( 49, 'Double-Pied', 	1, 	30, 30, 	100),
	( 50, 'Draco-Rage', 	2, 	10, 40, 	100),
	( 51, 'Eboulement', 	12, 10, 80, 	90),
	( 52, 'Eclair', 		4, 	30, 40, 	100),
	( 53, 'E-Coque', 		8, 	10, null, 	100),
	( 54, 'Ecrasement', 	8, 	20, 65, 	100),
	( 55, 'Ecras''face', 	8, 	35, 40, 	100),
	( 56, 'Ecume', 			3, 	30, 20, 	100),
	( 57, 'Empal''korne', 	8, 	5, 	null, 	30),
	( 58, 'Entrave', 		8, 	20, null, 	55),
	( 59, 'Etreinte', 		8, 	20, 15, 	75),
	( 60, 'Explosion', 		8, 	5, 	340, 	100),
	( 61, 'Fatale-Foudre', 	4, 	10, 120, 	70),
	( 62, 'Flammèches', 	5, 	25, 40, 	100),
	( 63, 'Flash', 			8, 	20, null, 	70),
	( 64, 'Force', 			8, 	15, 80, 	100),
	( 65, 'Force-Poigne', 	8, 	30, 55, 	100),
	( 66, 'Fouet Lianes', 	9, 	10, 35, 	100),
	( 67, 'Frappe-Atlas', 	1, 	20, 0, 		100),
	( 68, 'Frénésie', 		8, 	20, 20, 	100),
	( 69, 'Furie', 			8, 	20, 15, 	85),
	( 70, 'Gaz Toxik', 		10, 40, null, 	55),
	( 71, 'Griffe', 		8, 	35, 40, 	100),
	( 72, 'Grincement', 	8, 	40, null, 	85),
	( 73, 'Grobisou', 		8, 	10, null, 	75),
	( 74, 'Gros''yeux', 	8, 	30, null, 	100),
	( 75, 'Guillotine', 	8, 	5, 	null, 	30),
	( 76, 'Hâte', 			11, 30, null, 	100),
	( 77, 'Hurlement', 		8, 	20, null, 	100),
	( 78, 'Hydrocanon', 	3, 	5, 	120, 	80),
	( 79, 'Hypnose', 		11, 20, null, 	60),
	( 80, 'Intimidation', 	8, 	30, null, 	75),
	( 81, 'Jackpot', 		8, 	20, 40, 	100),
	( 82, 'Jet de sable', 	8, 	15, null, 	100),
	( 83, 'Jet de pierres', 12, 15, 50, 	75),
	( 84, 'Koud''korne', 	8, 	25, 65, 	100),
	( 85, 'Lance-Flamme', 	5, 	15, 95, 	100),
	( 86, 'Lance-Soleil', 	9, 	10, 120, 	100),
	( 87, 'Laser-Glace', 	6, 	10, 95, 	100),
	( 88, 'Léchouille', 	14, 30, 20, 	100),
	( 89, 'Ligotage', 		8, 	20, 15, 	85),
	( 90, 'Liliput', 		8, 	20, null, 	100),
	( 91, 'Lutte', 			8, 	1, 	100, 	100),
	( 92, 'Mania', 			8, 	20, 90, 	100),
	( 93, 'Massd''os', 		13, 20, 65, 	85),
	( 94, 'Mawashi Geri', 	1, 	15, 60, 	80),
	( 95, 'Mega-Sangsue', 	9, 	10, 40, 	100),
	( 96, 'Météores', 		8, 	20, 60, 	100),
	( 97, 'Métronome', 		8, 	10, null, 	100),
	( 98, 'Mimique', 		15, 20, null, 	100),
	( 99, 'Mimi-Queue', 	8, 	30, null, 	100),
	(100, 'Morphing', 		8, 	10, null, 	100),
	(101, 'Morsure', 		8, 	25, 60, 	100),
	(102, 'Mur Lumière', 	11, 30, null, 	100),
	(103, 'Onde Boréale', 	6, 	20, 65, 	100),
	(104, 'Onde Folie', 	14, 10, null, 	100),
	(105, 'Osmerang', 		13, 10, 50, 	90),
	(106, 'Paraspore', 		9, 	30, null, 	75),
	(107, 'Patience', 		8, 	10, null, 	100),
	(108, 'Picanon', 		8, 	15, 20, 	100),
	(109, 'Picpic', 		15, 35, 35, 	100),
	(110, 'Pied Sauté', 	1, 	25, 70, 	95),
	(111, 'Pied Voltige', 	1, 	20, 85, 	90),
	(112, 'Pilonnage', 		8, 	20, 15, 	85),
	(113, 'Pince-Masse', 	3, 	10, 90, 	85),
	(114, 'Piqué', 			15, 5, 	140, 	90),
	(115, 'Pistolet à O', 	3, 	20, 40, 	100),
	(116, 'Plaquage', 		8, 	15, 85, 	100),
	(117, 'Poing Comète', 	8, 	15, 18, 	85),
	(118, 'Poing de Feu', 	5, 	15, 75, 	100),
	(119, 'Poing Karaté', 	1, 	25, 50, 	100),
	(120, 'Poing Eclair', 	4, 	15, 75, 	100),
	(121, 'Poing Glace', 	6, 	15, 75, 	100),
	(122, 'Poudre Dodo', 	9, 	15, null, 	75),
	(123, 'Poudre Toxik', 	10, 35, null, 	75),
	(124, 'Protection', 	11, 20, null, 	100),
	(125, 'Psyko', 			11, 10, 90, 	100),
	(126, 'Puissance', 		8, 	30, null, 	100),
	(127, 'Purédpois', 		10, 20, 20, 	70),
	(128, 'Rafale Psy', 	11, 20, 65, 	100),
	(129, 'Reflet', 		8, 	15, null, 	100),
	(130, 'Repli', 			3, 	40, null, 	100),
	(131, 'Repos', 			11, 10, null, 	100),
	(132, 'Riposte', 		1, 	20, null, 	100),
	(133, 'Rugissement', 	8, 	10, null, 	100),
	(134, 'Sacrifice', 		1, 	25, 80, 	80),
	(135, 'Sécrétion', 		7, 	40, null, 	95),
	(136, 'Séisme', 		13, 10, 100, 	100),
	(137, 'Soin', 			8, 	10, null, 	100),
	(138, 'Sonicboom', 		8, 	20, 20, 	100),
	(139, 'Souplesse', 		8, 	20, 80, 	75),
	(140, 'Spore', 			9, 	15, null, 	100),
	(141, 'Surf', 			3, 	15, 95, 	100),
	(142, 'Télékinésie', 	11, 15, null, 	75),
	(143, 'Téléport', 		11, 20, null, 	100),
	(144, 'Ténèbres', 		14, 15, 0, 		100),
	(145, 'Tonnerre', 		4, 	15, 95, 	100),
	(146, 'Torgnoles', 		8, 	10, 15, 	85),
	(147, 'Tornade', 		15, 35, 40, 	100),
	(148, 'Toxik', 			10, 10, null, 	85),
	(149, 'Tranche', 		8, 	20, 70, 	100),
	(150, 'Tranch''herbe', 	9, 	25, 55, 	95),
	(151, 'Trempette', 		3, 	40, null, 	100),
	(152, 'Triplattaque', 	8, 	10, 80, 	100),
	(153, 'Tunnel', 		13, 10, 100, 	100),
	(154, 'Ultimapoing', 	8, 	20, 80, 	85),
	(155, 'Ultimawashi', 	8, 	5, 	120, 	75),
	(156, 'Ultralaser', 	8, 	5, 	120, 	90),
	(157, 'Ultrason', 		8, 	20, null, 	55),
	(158, 'Uppercut', 		8, 	10, 70, 	100),
	(159, 'Vague Psy', 		11, 15, null, 	80),
	(160, 'Vampigraine', 	9, 	10, null, 	90),
	(161, 'Vampirisme', 	7, 	15, 20, 	100),
	(162, 'Vive Attaque', 	8, 	30, 40, 	100),
	(163, 'Vol', 			15, 15, 70, 	95),
	(164, 'Vol-vie', 		9, 	20, 20, 	100),
	(165, 'Yoga', 			11, 40, null, 	100);


INSERT INTO est_type (pokemon_id, type_id) VALUES
	(  1, 9),
	(  1, 10),
	(  2, 9),
	(  2, 10),
	(  3, 9),
	(  3, 10),
	(  4, 5),
	(  5, 5),
	(  6, 5),
	(  6, 15),
	(  7, 3),
	(  8, 3),
	(  9, 3),
	( 10, 7),
	( 11, 7),
	( 12, 7),
	( 12, 15),
	( 13, 7),
	( 13, 10),
	( 14, 7),
	( 14, 10),
	( 15, 7),
	( 15, 10),
	( 16, 8),
	( 16, 15),
	( 17, 8),
	( 17, 15),
	( 18, 8),
	( 18, 15),
	( 19, 8),
	( 20, 8),
	( 21, 8),
	( 21, 15),
	( 22, 8),
	( 22, 15),
	( 23, 10),
	( 24, 10),
	( 25, 4),
	( 26, 4),
	( 27, 13),
	( 28, 13),
	( 29, 10),
	( 30, 10),
	( 31, 10),
	( 31, 13),
	( 32, 10),
	( 33, 10),
	( 34, 10),
	( 34, 13),
	( 35, 8),
	( 36, 8),
	( 37, 5),
	( 38, 5),
	( 39, 8),
	( 40, 8),
	( 41, 10),
	( 41, 15),
	( 42, 10),
	( 42, 15),
	( 43, 9),
	( 43, 10),
	( 44, 9),
	( 44, 10),
	( 45, 9),
	( 45, 10),
	( 46, 7),
	( 46, 9),
	( 47, 7),
	( 47, 9),
	( 48, 7),
	( 48, 10),
	( 49, 7),
	( 49, 10),
	( 50, 13),
	( 51, 13),
	( 52, 8),
	( 53, 8),
	( 54, 3),
	( 55, 3),
	( 56, 1),
	( 57, 1),
	( 58, 5),
	( 59, 5),
	( 60, 3),
	( 61, 3),
	( 62, 3),
	( 62, 1),
	( 63, 11),
	( 64, 11),
	( 65, 11),
	( 66, 1),
	( 67, 1),
	( 68, 1),
	( 69, 9),
	( 69, 10),
	( 70, 9),
	( 70, 10),
	( 71, 9),
	( 71, 10),
	( 72, 3),
	( 72, 10),
	( 73, 3),
	( 73, 10),
	( 74, 12),
	( 74, 13),
	( 75, 12),
	( 75, 13),
	( 76, 12),
	( 76, 13),
	( 77, 5),
	( 78, 5),
	( 79, 3),
	( 79, 11),
	( 80, 3),
	( 80, 11),
	( 81, 4),
	( 82, 4),
	( 83, 8),
	( 83, 15),
	( 84, 8),
	( 84, 15),
	( 85, 8),
	( 85, 15),
	( 86, 3),
	( 87, 3),
	( 87, 6),
	( 88, 10),
	( 89, 10),
	( 90, 3),
	( 91, 3),
	( 91, 6),
	( 92, 14),
	( 92, 10),
	( 93, 14),
	( 93, 10),
	( 94, 14),
	( 94, 10),
	( 95, 12),
	( 95, 13),
	( 96, 11),
	( 97, 11),
	( 98, 3),
	( 99, 3),
	(100, 4),
	(101, 4),
	(102, 9),
	(102, 11),
	(103, 9),
	(103, 11),
	(104, 13),
	(105, 13),
	(106, 1),
	(107, 1),
	(108, 8),
	(109, 10),
	(110, 10),
	(111, 13),
	(111, 12),
	(112, 13),
	(112, 12),
	(113, 8),
	(114, 9),
	(115, 8),
	(116, 3),
	(117, 3),
	(118, 3),
	(119, 3),
	(120, 3),
	(121, 3),
	(121, 11),
	(122, 11),
	(123, 7),
	(123, 15),
	(124, 6),
	(124, 11),
	(125, 4),
	(126, 5),
	(127, 7),
	(128, 8),
	(129, 3),
	(130, 3),
	(130, 15),
	(131, 3),
	(131, 6),
	(132, 8),
	(133, 8),
	(134, 3),
	(135, 4),
	(136, 5),
	(137, 8),
	(138, 12),
	(138, 3),
	(139, 12),
	(139, 3),
	(140, 12),
	(140, 3),
	(141, 12),
	(141, 3),
	(142, 12),
	(142, 15),
	(143, 8),
	(144, 6),
	(144, 15),
	(145, 4),
	(145, 15),
	(146, 5),
	(146, 15),
	(147, 2),
	(148, 2),
	(149, 2),
	(149, 15),
	(150, 11),
	(151, 11);


-- arenes https://www.pokebip.com/page__jeuxvideo__rbvj__champions_arene.html
-- ligue https://www.pokebip.com/page__jeuxvideo__rbvj__conseil4.html
INSERT INTO dresseurs (id, nom) VALUES 
	(2, 'Pierre'),
	(3, 'Ondine'),
	(4, 'Major Bob'),
	(5, 'Erika'),
	(6, 'Koga'),
	(7, 'Morgane'),
	(8, 'Auguste'),
	(9, 'Giovanni'),
	(10, 'Olga'),
	(11, 'Aldo'),
	(12, 'Agatha'),
	(13, 'Peter');

INSERT INTO detient_pokemons (dresseur_id, pokemon_id, niveau) VALUES
	-- Pierre: Raccaillou 12, Onix 14 
	(2, 74, 12),
	(2, 95, 14),
	-- Ondine: Stari 18, Staross 21
	(3, 120, 18),
	(3, 121, 21),
	-- Major Bob: Voltorbe 21, Pikachu 18, Raichu 24
	(4, 100, 21),
	(4, 25, 18),
	(4, 26, 24),
	-- Erika: Empiflor 29, Saquedeneu 24, Rafflesia 29
	(5, 71, 29),
	(5, 114, 24),
	(5, 45, 29),
	-- Koga: Smogo 37, Grotadmorv 39, Smogo 37, Smogogo 43
	(6, 109, 37),
	(6, 89, 39),
	(6, 109, 37),
	(6, 110, 43),
	-- Morgane: Kadabra 38, M.  Mime 37, Aeromite 38, Alakazam 43
	(7, 64, 38),
	(7, 122, 37),
	(7, 49, 38),
	(7, 65, 43),
	-- Auguste: Caninos 42, Ponyta 40, Galopa 42, Arcanin 47
	(8, 58, 42),
	(8, 77, 40),
	(8, 78, 42),
	(8, 59, 47),
	-- Giovanni: Rhinocorne 45, Triopikeur 42, Nidoqueen 44, Nodiking 45, Rhinoferos 50
	(9, 111, 42),
	(9, 51, 42),
	(9, 31, 44),
	(9, 34, 45),
	(9, 112, 50),
	-- Olga: Lamantine 54, Crustabri 53, Flagadoss 54, Lippoutou 56, Lokhlass 56
	(10, 87, 54),
	(10, 91, 53),
	(10, 80, 54),
	(10, 124, 56),
	(10, 131, 56),
	-- Aldo: Onix 53, Tygnon 55, Kicklee 55, Onix 56, Mackogneur 58
	(11, 95, 53),
	(11, 107, 55),
	(11, 106, 55),
	(11, 95, 56),
	(11, 68, 58),
	-- Agatha: Ectoplasma 56, Nosferalto 56, Spectrum 55, Arbok 58, Ectoplasma 60
	(12, 94, 56),
	(12, 42, 56),
	(12, 93, 55),
	(12, 24, 58),
	(12, 94, 60),
	-- Peter: Leviator 58, Draco 56,  Draco 56, Ptera 60, Dracolosse 62
	(13, 130, 58),
	(13, 148, 56),
	(13, 148, 56),
	(13, 142, 60),
	(13, 149, 62);


-- evolutions
INSERT INTO evolue_en (pokemon_base_id, pokemon_evol_id, niveau) VALUES
-- http://www.pokepedia.fr/Liste_des_Pok%C3%A9mon_par_famille_d%27%C3%A9volution
	(  1,   2, 16),
	(  2,   3, 32),
	(  4,   5, 16),
	(  5,   6, 36),
	(  7,   8, 16),
	(  8,   9, 36),
	( 10,  11, 7 ),
	( 11,  12, 10),
	( 13,  14, 7 ),
	( 14,  15, 10),
	( 16,  17, 18),
	( 17,  18, 36),
	( 19,  20, 20),
	( 21,  22, 20),
	( 23,  24, 22),
	( 25,  26, -1),
	( 27,  28, 22),
	( 29,  30, 16),
	( 30,  31, -1),
	( 32,  33, 16),
	( 33,  34, -1),
	( 35,  36, -1),
	( 37,  38, -1),
	( 39,  40, -1),
	( 41,  42, 22),
	( 43,  44, 21),
	( 44,  45, -1),
	( 46,  47, 24),
	( 48,  49, 31),
	( 50,  51, 26),
	( 52,  53, 28),
	( 54,  55, 33),
	( 56,  57, 28),
	( 58,  59, -1),
	( 60,  61, 25),
	( 61,  62, -1),
	( 63,  64, 16),
	( 64,  65, -2),
	( 66,  67, 28),
	( 67,  68, -2),
	( 69,  70, 21),
	( 70,  71, -1),
	( 72,  73, 30),
	( 74,  75, 25),
	( 75,  76, -2),
	( 77,  78, 40),
	( 79,  80, 37),
	( 81,  82, 30),
	( 84,  85, 31),
	( 86,  87, 34),
	( 88,  89, 38),
	( 90,  91, -1),
	( 92,  93, 25),
	( 93,  94, -2),
	( 96,  97, 26),
	( 98,  99, 28),
	(100, 101, 30),
	(102, 103, -1),
	(104, 105, 28),
	(109, 110, 35),
	(111, 112, 42),
	(116, 117, 32),
	(118, 119, 33),
	(120, 121, -1),
	(129, 130, 20),
	(133, 134, -1),
	(133, 135, -1),
	(133, 136, -1),
	(138, 139, 40),
	(140, 141, 40),
	(147, 148, 30),
	(148, 149, 55);

