6SsVWW11

1-- --------------------------------------------------------
2-- Verkkotietokone:              127.0.0.1
3-- Palvelinversio:               10.1.18-MariaDB - mariadb.org binary distribution
4-- Server OS:                    Win64
5-- HeidiSQL Versio:              9.3.0.4984
6-- --------------------------------------------------------
7
8/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
9/*!40101 SET NAMES utf8mb4 */;
10/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
11/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
12
13-- Dumping database structure for summonerio
14CREATE DATABASE IF NOT EXISTS `summonerio` /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci */;
15USE `summonerio`;
16
17
18-- Dumping structure for taulu summonerio.match
19CREATE TABLE IF NOT EXISTS `match` (
20  `gameId` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
21  `seasonId` int(30) NOT NULL,
22  `queueId` int(30) NOT NULL,
23  `gameDuration` int(50) NOT NULL,
24  `gameCreation` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
25  PRIMARY KEY (`gameId`)
26) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
27
28-- Tietojen vientiä ei oltu valittu.
29
30
31-- Dumping structure for taulu summonerio.match_participant
32CREATE TABLE IF NOT EXISTS `match_participant` (
33  `id` int(11) NOT NULL AUTO_INCREMENT,
34  `gameId` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '0',
35  `summonerId` int(11) NOT NULL DEFAULT '0',
36  `participantId` int(11) NOT NULL DEFAULT '0',
37  `championId` int(11) NOT NULL DEFAULT '0',
38  `lane` varchar(10) COLLATE utf8_unicode_ci DEFAULT '0',
39  `kills` int(11) DEFAULT '0',
40  `assists` int(11) DEFAULT '0',
41  `deaths` int(11) DEFAULT '0',
42  `item1` int(11) DEFAULT '0',
43  `item2` int(11) DEFAULT '0',
44  `item3` int(11) DEFAULT '0',
45  `item4` int(11) DEFAULT '0',
46  `item5` int(11) DEFAULT '0',
47  `item6` int(11) DEFAULT '0',
48  `spell1` int(11) NOT NULL DEFAULT '0',
49  `spell2` int(11) NOT NULL DEFAULT '0',
50  PRIMARY KEY (`id`),
51  KEY `FK_match_participant_summoner` (`summonerId`),
52  KEY `FK_match_participant_match` (`gameId`),
53  CONSTRAINT `FK_match_participant_match` FOREIGN KEY (`gameId`) REFERENCES `match` (`gameId`),
54  CONSTRAINT `FK_match_participant_summoner` FOREIGN KEY (`summonerId`) REFERENCES `summoner` (`id`)
55) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
56
57-- Tietojen vientiä ei oltu valittu.
58
59
60-- Dumping structure for taulu summonerio.summoner
61CREATE TABLE IF NOT EXISTS `summoner` (
62  `id` int(30) NOT NULL,
63  `name` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
64  `accountId` int(30) NOT NULL,
65  `profileIconId` int(30) NOT NULL,
66  `region` varchar(10) COLLATE utf8_unicode_ci NOT NULL,
67  `summonerLevel` int(11) DEFAULT NULL,
68  PRIMARY KEY (`id`)
69) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
70
71-- Tietojen vientiä ei oltu valittu.
72/*!40101 SET SQL_MODE=IFNULL(@OLD_SQL_MODE, '') */;
73/*!40014 SET FOREIGN_KEY_CHECKS=IF(@OLD_FOREIGN_KEY_CHECKS IS NULL, 1, @OLD_FOREIGN_KEY_CHECKS) */;
74/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;