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
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
|
create database if not exists gamestats_tf;
use gamestats_tf;
create table if not exists tf_mapdata
(
MapName VARCHAR(64)
);
alter table tf_mapdata add INDEX(MapName);
alter table tf_mapdata add column ServerID VARCHAR(16);
alter table tf_mapdata add column TimeSubmitted DATETIME;
alter table tf_mapdata add INDEX(TimeSubmitted);
alter table tf_mapdata add column RoundsPlayed BIGINT;
alter table tf_mapdata add column TotalTime BIGINT;
alter table tf_mapdata add column BlueWins BIGINT;
alter table tf_mapdata add column RedWins BIGINT;
alter table tf_mapdata add column Stalemates BIGINT;
create table if not exists tf_mapdata_rollup
(
MapName VARCHAR(64)
);
alter table tf_mapdata_rollup add INDEX(MapName);
alter table tf_mapdata_rollup add column TimeSubmitted DATETIME;
alter table tf_mapdata_rollup add INDEX(TimeSubmitted);
alter table tf_mapdata_rollup add column RoundsPlayed BIGINT;
alter table tf_mapdata_rollup add column TotalTime BIGINT;
alter table tf_mapdata_rollup add column BlueWins BIGINT;
alter table tf_mapdata_rollup add column RedWins BIGINT;
alter table tf_mapdata_rollup add column Stalemates BIGINT;
create table if not exists tf_classdata
(
MapName VARCHAR(64)
);
alter table tf_classdata add INDEX(MapName);
alter table tf_classdata add column ServerID VARCHAR(16);
alter table tf_classdata add column TimeSubmitted DATETIME;
alter table tf_classdata add INDEX(TimeSubmitted);
alter table tf_classdata add column Class TINYINT;
alter table tf_classdata add column Spawns BIGINT;
alter table tf_classdata add column TotalTime BIGINT;
alter table tf_classdata add column Score BIGINT;
alter table tf_classdata add column Kills BIGINT;
alter table tf_classdata add column Deaths BIGINT;
alter table tf_classdata add column Assists BIGINT;
alter table tf_classdata add column Captures BIGINT;
create table if not exists tf_classdata_rollup
(
MapName VARCHAR(64)
);
alter table tf_classdata_rollup add INDEX(MapName);
alter table tf_classdata_rollup add column TimeSubmitted DATETIME;
alter table tf_classdata_rollup add INDEX(TimeSubmitted);
alter table tf_classdata_rollup add column Class TINYINT;
alter table tf_classdata_rollup add column Spawns BIGINT;
alter table tf_classdata_rollup add column TotalTime BIGINT;
alter table tf_classdata_rollup add column Score BIGINT;
alter table tf_classdata_rollup add column Kills BIGINT;
alter table tf_classdata_rollup add column Deaths BIGINT;
alter table tf_classdata_rollup add column Assists BIGINT;
alter table tf_classdata_rollup add column Captures BIGINT;
create table if not exists tf_weapondata
(
WeaponID TINYINT
);
alter table tf_weapondata add INDEX(WeaponID);
alter table tf_weapondata add column ServerID VARCHAR(16);
alter table tf_weapondata add column MapName VARCHAR(64);
alter table tf_weapondata add INDEX(MapName);
alter table tf_weapondata add column TimeSubmitted DATETIME;
alter table tf_weapondata add INDEX(TimeSubmitted);
alter table tf_weapondata add column ShotsFired BIGINT;
alter table tf_weapondata add column ShotsFiredCrit BIGINT;
alter table tf_weapondata add column ShotsHit BIGINT;
alter table tf_weapondata add column DamageTotal BIGINT;
alter table tf_weapondata add column HitsWithKnownDistance BIGINT;
alter table tf_weapondata add column DistanceTotal BIGINT;
create table if not exists tf_weapondata_rollup
(
WeaponID TINYINT
);
alter table tf_weapondata_rollup add INDEX(WeaponID);
alter table tf_weapondata_rollup add column MapName VARCHAR(64);
alter table tf_weapondata_rollup add INDEX(MapName);
alter table tf_weapondata_rollup add column TimeSubmitted DATETIME;
alter table tf_weapondata_rollup add INDEX(TimeSubmitted);
alter table tf_weapondata_rollup add column ShotsFired BIGINT;
alter table tf_weapondata_rollup add column ShotsFiredCrit BIGINT;
alter table tf_weapondata_rollup add column ShotsHit BIGINT;
alter table tf_weapondata_rollup add column DamageTotal BIGINT;
alter table tf_weapondata_rollup add column HitsWithKnownDistance BIGINT;
alter table tf_weapondata_rollup add column DistanceTotal BIGINT;
create table if not exists tf_deaths
(
UserID CHAR(16),
Tag CHAR(8),
KEY( Tag ),
MapName CHAR(20),
MapVersion INT,
KEY( MapVersion ),
LastUpdate DATETIME,
KEY( LastUpdate ),
DeathIndex INT,
X SMALLINT,
Y SMALLINT,
Z SMALLINT,
PRIMARY KEY ( UserID, Tag, MapName, X, Y, Z )
) TYPE=MyISAM;
create table if not exists tf_perfdata
(
CreationTimeStamp DATETIME,
AvgFps FLOAT,
MinFps FLOAT,
MaxFps FLOAT,
CPUID VARCHAR(64),
CPUGhz FLOAT,
NumCores INT,
GPUDrv VARCHAR(64),
GPUVendor INT,
GPUDeviceID INT,
GPUDriverVersion VARCHAR(25),
DxLvl INT,
Width INT,
Height INT,
MapName VARCHAR(64),
TotalLevelTime INT,
NumLevels SMALLINT,
INDEX(CreationTimeStamp),
INDEX(AvgFps),
INDEX(GPUDrv),
INDEX(Width),
INDEX(MapName)
);
create table if not exists tf_perfdata_rollup_fps
(
CreationTimeStamp DATETIME,
NumEntries BIGINT,
AvgFps FLOAT,
INDEX(CreationTimeStamp),
);
create table if not exists tf_perfdata_rollup_fpsdist
(
CreationTimeStamp DATETIME,
NumEntries BIGINT,
BaseFps FLOAT,
GPUDrv VARCHAR(64),
INDEX(CreationTimeStamp),
INDEX(GPUDrv)
);
create table if not exists tf_perfdata_rollup_fpsmap
(
CreationTimeStamp DATETIME,
NumEntries BIGINT,
AvgFps FLOAT,
MapName VARCHAR(64),
INDEX(CreationTimeStamp),
INDEX(MapName),
);
create table if not exists tf_perfdata_rollup_fpscard
(
CreationTimeStamp DATETIME,
NumEntries BIGINT,
AvgFps FLOAT,
GPUDrv VARCHAR(64),
INDEX(CreationTimeStamp),
INDEX(GPUDrv),
);
create table if not exists tf_perfdata_rollup_fpswidth
(
CreationTimeStamp DATETIME,
NumEntries BIGINT,
AvgFps FLOAT,
Width INT,
INDEX(CreationTimeStamp),
);
create table if not exists tf_perfdata_rollup_fpscardwidth
(
CreationTimeStamp DATETIME,
NumEntries BIGINT,
AvgFps FLOAT,
Width INT,
GPUDrv VARCHAR(64),
INDEX(CreationTimeStamp),
INDEX(GPUDrv),
);
create table if not exists tf_perfdata_rollup_cpudist
(
CreationTimeStamp DATETIME,
NumEntries BIGINT,
AvgFps FLOAT,
CPUID VARCHAR(64),
NumCores INT,
BaseCPUGhz FLOAT,
GPUVendor INT,
INDEX(CreationTimeStamp),
);
create table if not exists tf_perfdata_rollup_playtime
(
CreationTimeStamp DATETIME,
AvgSession FLOAT,
AvgLevels FLOAT,
INDEX(CreationTimeStamp),
);
create table if not exists tf_perfdata_rollup_playtimedist
(
CreationTimeStamp DATETIME,
BaseSession FLOAT,
NumEntries INT,
INDEX(CreationTimeStamp),
);
|