buildPokemonDatabase

DROP SCHEMA IF EXISTS pokemon;
CREATE SCHEMA pokemon;
USE pokemon;

DROP TABLE IF EXISTS `Generation`;
CREATE TABLE `Generation` (
  `ID` INT,
  `FirstReleased` DATE,
  `Region` VARCHAR(60),
  PRIMARY KEY (`ID`),
  KEY `Key` (`FirstReleased`, `Region`)
);

DROP TABLE IF EXISTS `Games`;
CREATE TABLE `Games` (
  `ID` INT,
  `Name` VARCHAR(100),
  `ReleaseDate` DATE,
  `Generation` INT,
  PRIMARY KEY (`ID`),
  FOREIGN KEY (`Generation`) REFERENCES `Generation`(`ID`),
  KEY `Key` (`Name`, `ReleaseDate`)
);

DROP TABLE IF EXISTS `Abilities`;
CREATE TABLE `Abilities` (
  `ID` INT,
  `Name` VARCHAR(60),
  `Description` VARCHAR(300),
  PRIMARY KEY (`ID`),
  KEY `Key` (`Name`, `Description`)
);

DROP TABLE IF EXISTS `Classification`;
CREATE TABLE `Classification` (
  `ID` INT,
  `Name` VARCHAR(60),
  PRIMARY KEY (`ID`),
  KEY `Key` (`Name`)
);

DROP TABLE IF EXISTS `Pokemon`;
CREATE TABLE `Pokemon` (
  `ID` INT,
  `Name` VARCHAR(60),
  `Romanji` VARCHAR(60),
  `Type1` VARCHAR(60),
  `Type2` VARCHAR(60),
  `Classification` INT,
  `Attack` INT,
  `Defense` INT,
  `Hp` INT,
  `Sp_attack` INT,
  `Sp_defense` INT,
  `Speed` INT,
  `Weight_kg` FLOAT,
  `Generation` INT,
  `Is_legendary` BOOL,
  PRIMARY KEY (`PokedexID`),
  FOREIGN KEY (`Classification`) REFERENCES `Classification`(`ID`),
  FOREIGN KEY (`Generation`) REFERENCES `Generation`(`ID`),
  KEY `Key` (`Name`, `Romanji`, `Type1`, `Type2`, `Attack`, `Defense`, `Hp`, `Sp_attack`, `Sp_defense`, `Speed`, `Weight_kg`, `Is_legendary`)
);

DROP TABLE IF EXISTS `PokemonAbilities`;
CREATE TABLE `PokemonAbilities` (
  `ID` INT,
  `PokemonID` INT,
  `AbilityID` INT,
  PRIMARY KEY (`ID`),
  FOREIGN KEY (`AbilityID`) REFERENCES `Abilities`(`ID`),
  FOREIGN KEY (`PokemonID`) REFERENCES `Pokemon`(`ID`)
);