1 CREATE TABLE xonstat.player_weapon_stats
3 player_weapon_stats_id bigserial NOT NULL,
4 player_id integer NOT NULL,
5 game_id bigint NOT NULL,
6 player_game_stat_id bigint NOT NULL,
7 weapon_cd character varying(15) NOT NULL,
8 actual integer NOT NULL default 0,
9 max integer NOT NULL default 0,
10 hit integer NOT NULL default 0,
11 fired integer NOT NULL default 0,
12 frags integer NOT NULL default 0,
13 create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
14 CONSTRAINT player_weapon_stats_pk PRIMARY KEY (player_weapon_stats_id),
15 CONSTRAINT player_weapon_stats_fk001 FOREIGN KEY (player_id)
16 REFERENCES xonstat.players (player_id) MATCH SIMPLE
17 ON UPDATE NO ACTION ON DELETE NO ACTION,
18 CONSTRAINT player_weapon_stats_fk002 FOREIGN KEY (game_id)
19 REFERENCES xonstat.games (game_id) MATCH SIMPLE
20 ON UPDATE NO ACTION ON DELETE NO ACTION,
21 CONSTRAINT player_weapon_stats_fk003 FOREIGN KEY (weapon_cd)
22 REFERENCES xonstat.cd_weapon (weapon_cd) MATCH SIMPLE
23 ON UPDATE NO ACTION ON DELETE NO ACTION,
24 CONSTRAINT player_weapon_stats_fk004 FOREIGN KEY (player_game_stat_id)
25 REFERENCES xonstat.player_game_stats (player_game_stat_id) MATCH SIMPLE
26 ON UPDATE NO ACTION ON DELETE NO ACTION
32 CREATE INDEX player_weap_stats_ix01 on player_weapon_stats(create_dt);
33 CREATE INDEX player_weap_stats_ix02 on player_weapon_stats(game_id);
34 CREATE INDEX player_weap_stats_ix03 on player_weapon_stats(player_id);
36 ALTER TABLE xonstat.player_weapon_stats OWNER TO xonstat;
38 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2014q1 (
39 CHECK ( create_dt >= DATE '2014-01-01' AND create_dt < DATE '2014-04-01' )
40 ) INHERITS (player_weapon_stats);
42 CREATE INDEX player_weapon_stats_2014q1_ix001 on player_weapon_stats_2014q1(create_dt);
43 CREATE INDEX player_weapon_stats_2014q1_ix002 on player_weapon_stats_2014q1(game_id);
44 CREATE INDEX player_weapon_stats_2014q1_ix003 on player_weapon_stats_2014q1(player_id);
46 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2014q2 (
47 CHECK ( create_dt >= DATE '2014-04-01' AND create_dt < DATE '2014-07-01' )
48 ) INHERITS (player_weapon_stats);
50 CREATE INDEX player_weapon_stats_2014q2_ix001 on player_weapon_stats_2014q2(create_dt);
51 CREATE INDEX player_weapon_stats_2014q2_ix002 on player_weapon_stats_2014q2(game_id);
52 CREATE INDEX player_weapon_stats_2014q2_ix003 on player_weapon_stats_2014q2(player_id);
54 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2014q3 (
55 CHECK ( create_dt >= DATE '2014-07-01' AND create_dt < DATE '2014-10-01' )
56 ) INHERITS (player_weapon_stats);
58 CREATE INDEX player_weapon_stats_2014q3_ix001 on player_weapon_stats_2014q3(create_dt);
59 CREATE INDEX player_weapon_stats_2014q3_ix002 on player_weapon_stats_2014q3(game_id);
60 CREATE INDEX player_weapon_stats_2014q3_ix003 on player_weapon_stats_2014q3(player_id);
62 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2014q4 (
63 CHECK ( create_dt >= DATE '2014-10-01' AND create_dt < DATE '2015-01-01' )
64 ) INHERITS (player_weapon_stats);
66 CREATE INDEX player_weapon_stats_2014q4_ix001 on player_weapon_stats_2014q4(create_dt);
67 CREATE INDEX player_weapon_stats_2014q4_ix002 on player_weapon_stats_2014q4(game_id);
68 CREATE INDEX player_weapon_stats_2014q4_ix003 on player_weapon_stats_2014q4(player_id);
70 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2015q1 (
71 CHECK ( create_dt >= DATE '2015-01-01' AND create_dt < DATE '2015-04-01' )
72 ) INHERITS (player_weapon_stats);
74 CREATE INDEX player_weapon_stats_2015q1_ix001 on player_weapon_stats_2015q1(create_dt);
75 CREATE INDEX player_weapon_stats_2015q1_ix002 on player_weapon_stats_2015q1(game_id);
76 CREATE INDEX player_weapon_stats_2015q1_ix003 on player_weapon_stats_2015q1(player_id);
78 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2015q2 (
79 CHECK ( create_dt >= DATE '2015-04-01' AND create_dt < DATE '2015-07-01' )
80 ) INHERITS (player_weapon_stats);
82 CREATE INDEX player_weapon_stats_2015q2_ix001 on player_weapon_stats_2015q2(create_dt);
83 CREATE INDEX player_weapon_stats_2015q2_ix002 on player_weapon_stats_2015q2(game_id);
84 CREATE INDEX player_weapon_stats_2015q2_ix003 on player_weapon_stats_2015q2(player_id);
86 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2015q3 (
87 CHECK ( create_dt >= DATE '2015-07-01' AND create_dt < DATE '2015-10-01' )
88 ) INHERITS (player_weapon_stats);
90 CREATE INDEX player_weapon_stats_2015q3_ix001 on player_weapon_stats_2015q3(create_dt);
91 CREATE INDEX player_weapon_stats_2015q3_ix002 on player_weapon_stats_2015q3(game_id);
92 CREATE INDEX player_weapon_stats_2015q3_ix003 on player_weapon_stats_2015q3(player_id);
94 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2015q4 (
95 CHECK ( create_dt >= DATE '2015-10-01' AND create_dt < DATE '2016-01-01' )
96 ) INHERITS (player_weapon_stats);
98 CREATE INDEX player_weapon_stats_2015q4_ix001 on player_weapon_stats_2015q4(create_dt);
99 CREATE INDEX player_weapon_stats_2015q4_ix002 on player_weapon_stats_2015q4(game_id);
100 CREATE INDEX player_weapon_stats_2015q4_ix003 on player_weapon_stats_2015q4(player_id);
102 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2016q1 (
103 CHECK ( create_dt >= DATE '2016-01-01' AND create_dt < DATE '2016-04-01' )
104 ) INHERITS (player_weapon_stats);
106 CREATE INDEX player_weapon_stats_2016q1_ix001 on player_weapon_stats_2016q1(create_dt);
107 CREATE INDEX player_weapon_stats_2016q1_ix002 on player_weapon_stats_2016q1(game_id);
108 CREATE INDEX player_weapon_stats_2016q1_ix003 on player_weapon_stats_2016q1(player_id);
110 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2016q2 (
111 CHECK ( create_dt >= DATE '2016-04-01' AND create_dt < DATE '2016-07-01' )
112 ) INHERITS (player_weapon_stats);
114 CREATE INDEX player_weapon_stats_2016q2_ix001 on player_weapon_stats_2016q2(create_dt);
115 CREATE INDEX player_weapon_stats_2016q2_ix002 on player_weapon_stats_2016q2(game_id);
116 CREATE INDEX player_weapon_stats_2016q2_ix003 on player_weapon_stats_2016q2(player_id);
118 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2016q3 (
119 CHECK ( create_dt >= DATE '2016-07-01' AND create_dt < DATE '2016-10-01' )
120 ) INHERITS (player_weapon_stats);
122 CREATE INDEX player_weapon_stats_2016q3_ix001 on player_weapon_stats_2016q3(create_dt);
123 CREATE INDEX player_weapon_stats_2016q3_ix002 on player_weapon_stats_2016q3(game_id);
124 CREATE INDEX player_weapon_stats_2016q3_ix003 on player_weapon_stats_2016q3(player_id);
126 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2016q4 (
127 CHECK ( create_dt >= DATE '2016-10-01' AND create_dt < DATE '2017-01-01' )
128 ) INHERITS (player_weapon_stats);
130 CREATE INDEX player_weapon_stats_2016q4_ix001 on player_weapon_stats_2016q4(create_dt);
131 CREATE INDEX player_weapon_stats_2016q4_ix002 on player_weapon_stats_2016q4(game_id);
132 CREATE INDEX player_weapon_stats_2016q4_ix003 on player_weapon_stats_2016q4(player_id);
134 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2017q1 (
135 CHECK ( create_dt >= DATE '2017-01-01' AND create_dt < DATE '2017-04-01' )
136 ) INHERITS (player_weapon_stats);
138 CREATE INDEX player_weapon_stats_2017q1_ix001 on player_weapon_stats_2017q1(create_dt);
139 CREATE INDEX player_weapon_stats_2017q1_ix002 on player_weapon_stats_2017q1(game_id);
140 CREATE INDEX player_weapon_stats_2017q1_ix003 on player_weapon_stats_2017q1(player_id);
142 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2017q2 (
143 CHECK ( create_dt >= DATE '2017-04-01' AND create_dt < DATE '2017-07-01' )
144 ) INHERITS (player_weapon_stats);
146 CREATE INDEX player_weapon_stats_2017q2_ix001 on player_weapon_stats_2017q2(create_dt);
147 CREATE INDEX player_weapon_stats_2017q2_ix002 on player_weapon_stats_2017q2(game_id);
148 CREATE INDEX player_weapon_stats_2017q2_ix003 on player_weapon_stats_2017q2(player_id);
150 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2017q3 (
151 CHECK ( create_dt >= DATE '2017-07-01' AND create_dt < DATE '2017-10-01' )
152 ) INHERITS (player_weapon_stats);
154 CREATE INDEX player_weapon_stats_2017q3_ix001 on player_weapon_stats_2017q3(create_dt);
155 CREATE INDEX player_weapon_stats_2017q3_ix002 on player_weapon_stats_2017q3(game_id);
156 CREATE INDEX player_weapon_stats_2017q3_ix003 on player_weapon_stats_2017q3(player_id);
158 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2017q4 (
159 CHECK ( create_dt >= DATE '2017-10-01' AND create_dt < DATE '2018-01-01' )
160 ) INHERITS (player_weapon_stats);
162 CREATE INDEX player_weapon_stats_2017q4_ix001 on player_weapon_stats_2017q4(create_dt);
163 CREATE INDEX player_weapon_stats_2017q4_ix002 on player_weapon_stats_2017q4(game_id);
164 CREATE INDEX player_weapon_stats_2017q4_ix003 on player_weapon_stats_2017q4(player_id);
166 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2018q1 (
167 CHECK ( create_dt >= DATE '2018-01-01' AND create_dt < DATE '2018-04-01' )
168 ) INHERITS (player_weapon_stats);
170 CREATE INDEX player_weapon_stats_2018q1_ix001 on player_weapon_stats_2018q1(create_dt);
171 CREATE INDEX player_weapon_stats_2018q1_ix002 on player_weapon_stats_2018q1(game_id);
172 CREATE INDEX player_weapon_stats_2018q1_ix003 on player_weapon_stats_2018q1(player_id);
174 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2018q2 (
175 CHECK ( create_dt >= DATE '2018-04-01' AND create_dt < DATE '2018-07-01' )
176 ) INHERITS (player_weapon_stats);
178 CREATE INDEX player_weapon_stats_2018q2_ix001 on player_weapon_stats_2018q2(create_dt);
179 CREATE INDEX player_weapon_stats_2018q2_ix002 on player_weapon_stats_2018q2(game_id);
180 CREATE INDEX player_weapon_stats_2018q2_ix003 on player_weapon_stats_2018q2(player_id);
182 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2018q3 (
183 CHECK ( create_dt >= DATE '2018-07-01' AND create_dt < DATE '2018-10-01' )
184 ) INHERITS (player_weapon_stats);
186 CREATE INDEX player_weapon_stats_2018q3_ix001 on player_weapon_stats_2018q3(create_dt);
187 CREATE INDEX player_weapon_stats_2018q3_ix002 on player_weapon_stats_2018q3(game_id);
188 CREATE INDEX player_weapon_stats_2018q3_ix003 on player_weapon_stats_2018q3(player_id);
190 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2018q4 (
191 CHECK ( create_dt >= DATE '2018-10-01' AND create_dt < DATE '2019-01-01' )
192 ) INHERITS (player_weapon_stats);
194 CREATE INDEX player_weapon_stats_2018q4_ix001 on player_weapon_stats_2018q4(create_dt);
195 CREATE INDEX player_weapon_stats_2018q4_ix002 on player_weapon_stats_2018q4(game_id);
196 CREATE INDEX player_weapon_stats_2018q4_ix003 on player_weapon_stats_2018q4(player_id);
198 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2019q1 (
199 CHECK ( create_dt >= DATE '2019-01-01' AND create_dt < DATE '2019-04-01' )
200 ) INHERITS (player_weapon_stats);
202 CREATE INDEX player_weapon_stats_2019q1_ix001 on player_weapon_stats_2019q1(create_dt);
203 CREATE INDEX player_weapon_stats_2019q1_ix002 on player_weapon_stats_2019q1(game_id);
204 CREATE INDEX player_weapon_stats_2019q1_ix003 on player_weapon_stats_2019q1(player_id);
206 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2019q2 (
207 CHECK ( create_dt >= DATE '2019-04-01' AND create_dt < DATE '2019-07-01' )
208 ) INHERITS (player_weapon_stats);
210 CREATE INDEX player_weapon_stats_2019q2_ix001 on player_weapon_stats_2019q2(create_dt);
211 CREATE INDEX player_weapon_stats_2019q2_ix002 on player_weapon_stats_2019q2(game_id);
212 CREATE INDEX player_weapon_stats_2019q2_ix003 on player_weapon_stats_2019q2(player_id);
214 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2019q3 (
215 CHECK ( create_dt >= DATE '2019-07-01' AND create_dt < DATE '2019-10-01' )
216 ) INHERITS (player_weapon_stats);
218 CREATE INDEX player_weapon_stats_2019q3_ix001 on player_weapon_stats_2019q3(create_dt);
219 CREATE INDEX player_weapon_stats_2019q3_ix002 on player_weapon_stats_2019q3(game_id);
220 CREATE INDEX player_weapon_stats_2019q3_ix003 on player_weapon_stats_2019q3(player_id);
222 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2019q4 (
223 CHECK ( create_dt >= DATE '2019-10-01' AND create_dt < DATE '2020-01-01' )
224 ) INHERITS (player_weapon_stats);
226 CREATE INDEX player_weapon_stats_2019q4_ix001 on player_weapon_stats_2019q4(create_dt);
227 CREATE INDEX player_weapon_stats_2019q4_ix002 on player_weapon_stats_2019q4(game_id);
228 CREATE INDEX player_weapon_stats_2019q4_ix003 on player_weapon_stats_2019q4(player_id);
230 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2020q1 (
231 CHECK ( create_dt >= DATE '2020-01-01' AND create_dt < DATE '2020-04-01' )
232 ) INHERITS (player_weapon_stats);
234 CREATE INDEX player_weapon_stats_2020q1_ix001 on player_weapon_stats_2020q1(create_dt);
235 CREATE INDEX player_weapon_stats_2020q1_ix002 on player_weapon_stats_2020q1(game_id);
236 CREATE INDEX player_weapon_stats_2020q1_ix003 on player_weapon_stats_2020q1(player_id);
238 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2020q2 (
239 CHECK ( create_dt >= DATE '2020-04-01' AND create_dt < DATE '2020-07-01' )
240 ) INHERITS (player_weapon_stats);
242 CREATE INDEX player_weapon_stats_2020q2_ix001 on player_weapon_stats_2020q2(create_dt);
243 CREATE INDEX player_weapon_stats_2020q2_ix002 on player_weapon_stats_2020q2(game_id);
244 CREATE INDEX player_weapon_stats_2020q2_ix003 on player_weapon_stats_2020q2(player_id);
246 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2020q3 (
247 CHECK ( create_dt >= DATE '2020-07-01' AND create_dt < DATE '2020-10-01' )
248 ) INHERITS (player_weapon_stats);
250 CREATE INDEX player_weapon_stats_2020q3_ix001 on player_weapon_stats_2020q3(create_dt);
251 CREATE INDEX player_weapon_stats_2020q3_ix002 on player_weapon_stats_2020q3(game_id);
252 CREATE INDEX player_weapon_stats_2020q3_ix003 on player_weapon_stats_2020q3(player_id);
254 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2020q4 (
255 CHECK ( create_dt >= DATE '2020-10-01' AND create_dt < DATE '2021-01-01' )
256 ) INHERITS (player_weapon_stats);
258 CREATE INDEX player_weapon_stats_2020q4_ix001 on player_weapon_stats_2020q4(create_dt);
259 CREATE INDEX player_weapon_stats_2020q4_ix002 on player_weapon_stats_2020q4(game_id);
260 CREATE INDEX player_weapon_stats_2020q4_ix003 on player_weapon_stats_2020q4(player_id);
262 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2021q1 (
263 CHECK ( create_dt >= DATE '2021-01-01' AND create_dt < DATE '2021-04-01' )
264 ) INHERITS (player_weapon_stats);
266 CREATE INDEX player_weapon_stats_2021q1_ix001 on player_weapon_stats_2021q1(create_dt);
267 CREATE INDEX player_weapon_stats_2021q1_ix002 on player_weapon_stats_2021q1(game_id);
268 CREATE INDEX player_weapon_stats_2021q1_ix003 on player_weapon_stats_2021q1(player_id);
270 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2021q2 (
271 CHECK ( create_dt >= DATE '2021-04-01' AND create_dt < DATE '2021-07-01' )
272 ) INHERITS (player_weapon_stats);
274 CREATE INDEX player_weapon_stats_2021q2_ix001 on player_weapon_stats_2021q2(create_dt);
275 CREATE INDEX player_weapon_stats_2021q2_ix002 on player_weapon_stats_2021q2(game_id);
276 CREATE INDEX player_weapon_stats_2021q2_ix003 on player_weapon_stats_2021q2(player_id);
278 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2021q3 (
279 CHECK ( create_dt >= DATE '2021-07-01' AND create_dt < DATE '2021-10-01' )
280 ) INHERITS (player_weapon_stats);
282 CREATE INDEX player_weapon_stats_2021q3_ix001 on player_weapon_stats_2021q3(create_dt);
283 CREATE INDEX player_weapon_stats_2021q3_ix002 on player_weapon_stats_2021q3(game_id);
284 CREATE INDEX player_weapon_stats_2021q3_ix003 on player_weapon_stats_2021q3(player_id);
286 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2021q4 (
287 CHECK ( create_dt >= DATE '2021-10-01' AND create_dt < DATE '2022-01-01' )
288 ) INHERITS (player_weapon_stats);
290 CREATE INDEX player_weapon_stats_2021q4_ix001 on player_weapon_stats_2021q4(create_dt);
291 CREATE INDEX player_weapon_stats_2021q4_ix002 on player_weapon_stats_2021q4(game_id);
292 CREATE INDEX player_weapon_stats_2021q4_ix003 on player_weapon_stats_2021q4(player_id);
294 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2022q1 (
295 CHECK ( create_dt >= DATE '2022-01-01' AND create_dt < DATE '2022-04-01' )
296 ) INHERITS (player_weapon_stats);
298 CREATE INDEX player_weapon_stats_2022q1_ix001 on player_weapon_stats_2022q1(create_dt);
299 CREATE INDEX player_weapon_stats_2022q1_ix002 on player_weapon_stats_2022q1(game_id);
300 CREATE INDEX player_weapon_stats_2022q1_ix003 on player_weapon_stats_2022q1(player_id);
302 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2022q2 (
303 CHECK ( create_dt >= DATE '2022-04-01' AND create_dt < DATE '2022-07-01' )
304 ) INHERITS (player_weapon_stats);
306 CREATE INDEX player_weapon_stats_2022q2_ix001 on player_weapon_stats_2022q2(create_dt);
307 CREATE INDEX player_weapon_stats_2022q2_ix002 on player_weapon_stats_2022q2(game_id);
308 CREATE INDEX player_weapon_stats_2022q2_ix003 on player_weapon_stats_2022q2(player_id);
310 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2022q3 (
311 CHECK ( create_dt >= DATE '2022-07-01' AND create_dt < DATE '2022-10-01' )
312 ) INHERITS (player_weapon_stats);
314 CREATE INDEX player_weapon_stats_2022q3_ix001 on player_weapon_stats_2022q3(create_dt);
315 CREATE INDEX player_weapon_stats_2022q3_ix002 on player_weapon_stats_2022q3(game_id);
316 CREATE INDEX player_weapon_stats_2022q3_ix003 on player_weapon_stats_2022q3(player_id);
318 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2022q4 (
319 CHECK ( create_dt >= DATE '2022-10-01' AND create_dt < DATE '2023-01-01' )
320 ) INHERITS (player_weapon_stats);
322 CREATE INDEX player_weapon_stats_2022q4_ix001 on player_weapon_stats_2022q4(create_dt);
323 CREATE INDEX player_weapon_stats_2022q4_ix002 on player_weapon_stats_2022q4(game_id);
324 CREATE INDEX player_weapon_stats_2022q4_ix003 on player_weapon_stats_2022q4(player_id);
326 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2023q1 (
327 CHECK ( create_dt >= DATE '2023-01-01' AND create_dt < DATE '2023-04-01' )
328 ) INHERITS (player_weapon_stats);
330 CREATE INDEX player_weapon_stats_2023q1_ix001 on player_weapon_stats_2023q1(create_dt);
331 CREATE INDEX player_weapon_stats_2023q1_ix002 on player_weapon_stats_2023q1(game_id);
332 CREATE INDEX player_weapon_stats_2023q1_ix003 on player_weapon_stats_2023q1(player_id);
334 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2023q2 (
335 CHECK ( create_dt >= DATE '2023-04-01' AND create_dt < DATE '2023-07-01' )
336 ) INHERITS (player_weapon_stats);
338 CREATE INDEX player_weapon_stats_2023q2_ix001 on player_weapon_stats_2023q2(create_dt);
339 CREATE INDEX player_weapon_stats_2023q2_ix002 on player_weapon_stats_2023q2(game_id);
340 CREATE INDEX player_weapon_stats_2023q2_ix003 on player_weapon_stats_2023q2(player_id);
342 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2023q3 (
343 CHECK ( create_dt >= DATE '2023-07-01' AND create_dt < DATE '2023-10-01' )
344 ) INHERITS (player_weapon_stats);
346 CREATE INDEX player_weapon_stats_2023q3_ix001 on player_weapon_stats_2023q3(create_dt);
347 CREATE INDEX player_weapon_stats_2023q3_ix002 on player_weapon_stats_2023q3(game_id);
348 CREATE INDEX player_weapon_stats_2023q3_ix003 on player_weapon_stats_2023q3(player_id);
350 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2023q4 (
351 CHECK ( create_dt >= DATE '2023-10-01' AND create_dt < DATE '2024-01-01' )
352 ) INHERITS (player_weapon_stats);
354 CREATE INDEX player_weapon_stats_2023q4_ix001 on player_weapon_stats_2023q4(create_dt);
355 CREATE INDEX player_weapon_stats_2023q4_ix002 on player_weapon_stats_2023q4(game_id);
356 CREATE INDEX player_weapon_stats_2023q4_ix003 on player_weapon_stats_2023q4(player_id);
358 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2024q1 (
359 CHECK ( create_dt >= DATE '2024-01-01' AND create_dt < DATE '2024-04-01' )
360 ) INHERITS (player_weapon_stats);
362 CREATE INDEX player_weapon_stats_2024q1_ix001 on player_weapon_stats_2024q1(create_dt);
363 CREATE INDEX player_weapon_stats_2024q1_ix002 on player_weapon_stats_2024q1(game_id);
364 CREATE INDEX player_weapon_stats_2024q1_ix003 on player_weapon_stats_2024q1(player_id);
366 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2024q2 (
367 CHECK ( create_dt >= DATE '2024-04-01' AND create_dt < DATE '2024-07-01' )
368 ) INHERITS (player_weapon_stats);
370 CREATE INDEX player_weapon_stats_2024q2_ix001 on player_weapon_stats_2024q2(create_dt);
371 CREATE INDEX player_weapon_stats_2024q2_ix002 on player_weapon_stats_2024q2(game_id);
372 CREATE INDEX player_weapon_stats_2024q2_ix003 on player_weapon_stats_2024q2(player_id);
374 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2024q3 (
375 CHECK ( create_dt >= DATE '2024-07-01' AND create_dt < DATE '2024-10-01' )
376 ) INHERITS (player_weapon_stats);
378 CREATE INDEX player_weapon_stats_2024q3_ix001 on player_weapon_stats_2024q3(create_dt);
379 CREATE INDEX player_weapon_stats_2024q3_ix002 on player_weapon_stats_2024q3(game_id);
380 CREATE INDEX player_weapon_stats_2024q3_ix003 on player_weapon_stats_2024q3(player_id);
382 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2024q4 (
383 CHECK ( create_dt >= DATE '2024-10-01' AND create_dt < DATE '2025-01-01' )
384 ) INHERITS (player_weapon_stats);
386 CREATE INDEX player_weapon_stats_2024q4_ix001 on player_weapon_stats_2024q4(create_dt);
387 CREATE INDEX player_weapon_stats_2024q4_ix002 on player_weapon_stats_2024q4(game_id);
388 CREATE INDEX player_weapon_stats_2024q4_ix003 on player_weapon_stats_2024q4(player_id);
390 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2025q1 (
391 CHECK ( create_dt >= DATE '2025-01-01' AND create_dt < DATE '2025-04-01' )
392 ) INHERITS (player_weapon_stats);
394 CREATE INDEX player_weapon_stats_2025q1_ix001 on player_weapon_stats_2025q1(create_dt);
395 CREATE INDEX player_weapon_stats_2025q1_ix002 on player_weapon_stats_2025q1(game_id);
396 CREATE INDEX player_weapon_stats_2025q1_ix003 on player_weapon_stats_2025q1(player_id);
398 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2025q2 (
399 CHECK ( create_dt >= DATE '2025-04-01' AND create_dt < DATE '2025-07-01' )
400 ) INHERITS (player_weapon_stats);
402 CREATE INDEX player_weapon_stats_2025q2_ix001 on player_weapon_stats_2025q2(create_dt);
403 CREATE INDEX player_weapon_stats_2025q2_ix002 on player_weapon_stats_2025q2(game_id);
404 CREATE INDEX player_weapon_stats_2025q2_ix003 on player_weapon_stats_2025q2(player_id);
406 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2025q3 (
407 CHECK ( create_dt >= DATE '2025-07-01' AND create_dt < DATE '2025-10-01' )
408 ) INHERITS (player_weapon_stats);
410 CREATE INDEX player_weapon_stats_2025q3_ix001 on player_weapon_stats_2025q3(create_dt);
411 CREATE INDEX player_weapon_stats_2025q3_ix002 on player_weapon_stats_2025q3(game_id);
412 CREATE INDEX player_weapon_stats_2025q3_ix003 on player_weapon_stats_2025q3(player_id);
414 CREATE TABLE IF NOT EXISTS xonstat.player_weapon_stats_2025q4 (
415 CHECK ( create_dt >= DATE '2025-10-01' AND create_dt < DATE '2026-01-01' )
416 ) INHERITS (player_weapon_stats);
418 CREATE INDEX player_weapon_stats_2025q4_ix001 on player_weapon_stats_2025q4(create_dt);
419 CREATE INDEX player_weapon_stats_2025q4_ix002 on player_weapon_stats_2025q4(game_id);
420 CREATE INDEX player_weapon_stats_2025q4_ix003 on player_weapon_stats_2025q4(player_id);