-- --------------------------------------------------------
-- Verkkotietokone:              127.0.0.1
-- Palvelinversio:               10.1.18-MariaDB - mariadb.org binary distribution
-- Server OS:                    Win64
-- HeidiSQL Versio:              9.3.0.4984
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8mb4 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;

-- Dumping database structure for summonerio
CREATE DATABASE IF NOT EXISTS `summonerio` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
USE `summonerio`;


-- Dumping structure for taulu summonerio.match
CREATE TABLE IF NOT EXISTS `match` (
  `gameId` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `seasonId` int(30) NOT NULL,
  `queueId` int(30) NOT NULL,
  `gameDuration` int(50) NOT NULL,
  `gameCreation` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  PRIMARY KEY (`gameId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Tietojen vientiä ei oltu valittu.


-- Dumping structure for taulu summonerio.match_participant
CREATE TABLE IF NOT EXISTS `match_participant` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `gameId` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
  `summonerId` int(11) NOT NULL DEFAULT '0',
  `participantId` int(11) NOT NULL DEFAULT '0',
  `championId` int(11) NOT NULL DEFAULT '0',
  `lane` varchar(10) COLLATE utf8_unicode_ci DEFAULT '0',
  `kills` int(11) DEFAULT '0',
  `assists` int(11) DEFAULT '0',
  `deaths` int(11) DEFAULT '0',
  `item1` int(11) DEFAULT '0',
  `item2` int(11) DEFAULT '0',
  `item3` int(11) DEFAULT '0',
  `item4` int(11) DEFAULT '0',
  `item5` int(11) DEFAULT '0',
  `item6` int(11) DEFAULT '0',
  `spell1` int(11) NOT NULL DEFAULT '0',
  `spell2` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `FK_match_participant_summoner` (`summonerId`),
  KEY `FK_match_participant_match` (`gameId`),
  CONSTRAINT `FK_match_participant_match` FOREIGN KEY (`gameId`) REFERENCES `match` (`gameId`),
  CONSTRAINT `FK_match_participant_summoner` FOREIGN KEY (`summonerId`) REFERENCES `summoner` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Tietojen vientiä ei oltu valittu.


-- Dumping structure for taulu summonerio.summoner
CREATE TABLE IF NOT EXISTS `summoner` (
  `id` int(30) NOT NULL,
  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
  `accountId` int(30) NOT NULL,
  `profileIconId` int(30) NOT NULL,
  `region` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
  `summonerLevel` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;

-- Tietojen vientiä ei oltu valittu.
/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;