-
Notifications
You must be signed in to change notification settings - Fork 0
/
get5_import_stats.sql
109 lines (97 loc) · 3.7 KB
/
get5_import_stats.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
--
-- Table structure for table `get5_stats_maps`
--
DROP TABLE IF EXISTS `get5_stats_maps`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `get5_stats_maps` (
`matchid` int(10) unsigned NOT NULL,
`mapnumber` smallint(5) unsigned NOT NULL,
`start_time` datetime NOT NULL,
`end_time` datetime,
`winner` varchar(16) NOT NULL DEFAULT '',
`mapname` varchar(64) NOT NULL DEFAULT '',
`team1_score` smallint(5) unsigned NOT NULL DEFAULT '0',
`team2_score` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`matchid`,`mapnumber`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `get5_stats_maps`
--
LOCK TABLES `get5_stats_maps` WRITE;
/*!40000 ALTER TABLE `get5_stats_maps` DISABLE KEYS */;
/*!40000 ALTER TABLE `get5_stats_maps` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `get5_stats_matches`
--
DROP TABLE IF EXISTS `get5_stats_matches`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `get5_stats_matches` (
`matchid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`start_time` datetime NOT NULL,
`end_time` datetime,
`winner` varchar(16) NOT NULL DEFAULT '',
`series_type` varchar(64) NOT NULL DEFAULT '',
`team1_name` varchar(64) NOT NULL DEFAULT '',
`team1_score` smallint(5) unsigned NOT NULL DEFAULT '0',
`team2_name` varchar(64) NOT NULL DEFAULT '',
`team2_score` smallint(5) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`matchid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `get5_stats_matches`
--
LOCK TABLES `get5_stats_matches` WRITE;
/*!40000 ALTER TABLE `get5_stats_matches` DISABLE KEYS */;
/*!40000 ALTER TABLE `get5_stats_matches` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `get5_stats_players`
--
DROP TABLE IF EXISTS `get5_stats_players`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `get5_stats_players` (
`matchid` int(10) unsigned NOT NULL,
`mapnumber` smallint(5) unsigned NOT NULL,
`steamid64` varchar(32) NOT NULL,
`team` varchar(16) NOT NULL DEFAULT '',
`rounds_played` smallint(5) unsigned NOT NULL,
`name` varchar(64) NOT NULL,
`kills` smallint(5) unsigned NOT NULL,
`deaths` smallint(5) unsigned NOT NULL,
`assists` smallint(5) unsigned NOT NULL,
`flashbang_assists` smallint(5) unsigned NOT NULL,
`teamkills` smallint(5) unsigned NOT NULL,
`headshot_kills` smallint(5) unsigned NOT NULL,
`damage` int(10) unsigned NOT NULL,
`bomb_plants` smallint(5) unsigned NOT NULL,
`bomb_defuses` smallint(5) unsigned NOT NULL,
`v1` smallint(5) unsigned NOT NULL,
`v2` smallint(5) unsigned NOT NULL,
`v3` smallint(5) unsigned NOT NULL,
`v4` smallint(5) unsigned NOT NULL,
`v5` smallint(5) unsigned NOT NULL,
`2k` smallint(5) unsigned NOT NULL,
`3k` smallint(5) unsigned NOT NULL,
`4k` smallint(5) unsigned NOT NULL,
`5k` smallint(5) unsigned NOT NULL,
`firstkill_t` smallint(5) unsigned NOT NULL,
`firstkill_ct` smallint(5) unsigned NOT NULL,
`firstdeath_t` smallint(5) unsigned NOT NULL,
`firstdeath_ct` smallint(5) unsigned NOT NULL,
PRIMARY KEY (`matchid`,`mapnumber`,`steamid64`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `get5_stats_players`
--
LOCK TABLES `get5_stats_players` WRITE;
/*!40000 ALTER TABLE `get5_stats_players` DISABLE KEYS */;
/*!40000 ALTER TABLE `get5_stats_players` ENABLE KEYS */;
UNLOCK TABLES;
-- Dump completed on 2016-07-03 1:10:28