1 CREATE TABLE xonstat.player_game_stats
3 player_game_stat_id bigserial NOT NULL,
4 player_id integer NOT NULL,
5 game_id bigint NOT NULL,
6 nick character varying(128),
7 stripped_nick character varying(128),
23 carrier_frags integer,
28 scoreboardpos integer,
32 create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
33 CONSTRAINT player_game_stats_pk PRIMARY KEY (player_game_stat_id),
34 CONSTRAINT player_game_stats_fk001 FOREIGN KEY (player_id)
35 REFERENCES xonstat.players (player_id) MATCH SIMPLE
36 ON UPDATE NO ACTION ON DELETE NO ACTION,
37 CONSTRAINT player_game_stats_fk002 FOREIGN KEY (game_id)
38 REFERENCES xonstat.games (game_id) MATCH SIMPLE
39 ON UPDATE NO ACTION ON DELETE NO ACTION
45 CREATE INDEX player_game_stats_ix01 on player_game_stats(create_dt);
46 CREATE INDEX player_game_stats_ix02 on player_game_stats(game_id);
47 CREATE INDEX player_game_stats_ix03 on player_game_stats(player_id);
48 ALTER TABLE xonstat.player_game_stats OWNER TO xonstat;
50 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2014q1 (
51 CHECK ( create_dt >= DATE '2014-01-01' AND create_dt < DATE '2014-04-01' )
52 ) INHERITS (player_game_stats);
54 CREATE INDEX player_game_stats_2014q1_ix001 on player_game_stats_2014q1(create_dt);
55 CREATE INDEX player_game_stats_2014q1_ix002 on player_game_stats_2014q1(game_id);
56 CREATE INDEX player_game_stats_2014q1_ix003 on player_game_stats_2014q1(player_id);
58 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2014q2 (
59 CHECK ( create_dt >= DATE '2014-04-01' AND create_dt < DATE '2014-07-01' )
60 ) INHERITS (player_game_stats);
62 CREATE INDEX player_game_stats_2014q2_ix001 on player_game_stats_2014q2(create_dt);
63 CREATE INDEX player_game_stats_2014q2_ix002 on player_game_stats_2014q2(game_id);
64 CREATE INDEX player_game_stats_2014q2_ix003 on player_game_stats_2014q2(player_id);
66 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2014q3 (
67 CHECK ( create_dt >= DATE '2014-07-01' AND create_dt < DATE '2014-10-01' )
68 ) INHERITS (player_game_stats);
70 CREATE INDEX player_game_stats_2014q3_ix001 on player_game_stats_2014q3(create_dt);
71 CREATE INDEX player_game_stats_2014q3_ix002 on player_game_stats_2014q3(game_id);
72 CREATE INDEX player_game_stats_2014q3_ix003 on player_game_stats_2014q3(player_id);
74 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2014q4 (
75 CHECK ( create_dt >= DATE '2014-10-01' AND create_dt < DATE '2015-01-01' )
76 ) INHERITS (player_game_stats);
78 CREATE INDEX player_game_stats_2014q4_ix001 on player_game_stats_2014q4(create_dt);
79 CREATE INDEX player_game_stats_2014q4_ix002 on player_game_stats_2014q4(game_id);
80 CREATE INDEX player_game_stats_2014q4_ix003 on player_game_stats_2014q4(player_id);
82 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2015q1 (
83 CHECK ( create_dt >= DATE '2015-01-01' AND create_dt < DATE '2015-04-01' )
84 ) INHERITS (player_game_stats);
86 CREATE INDEX player_game_stats_2015q1_ix001 on player_game_stats_2015q1(create_dt);
87 CREATE INDEX player_game_stats_2015q1_ix002 on player_game_stats_2015q1(game_id);
88 CREATE INDEX player_game_stats_2015q1_ix003 on player_game_stats_2015q1(player_id);
90 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2015q2 (
91 CHECK ( create_dt >= DATE '2015-04-01' AND create_dt < DATE '2015-07-01' )
92 ) INHERITS (player_game_stats);
94 CREATE INDEX player_game_stats_2015q2_ix001 on player_game_stats_2015q2(create_dt);
95 CREATE INDEX player_game_stats_2015q2_ix002 on player_game_stats_2015q2(game_id);
96 CREATE INDEX player_game_stats_2015q2_ix003 on player_game_stats_2015q2(player_id);
98 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2015q3 (
99 CHECK ( create_dt >= DATE '2015-07-01' AND create_dt < DATE '2015-10-01' )
100 ) INHERITS (player_game_stats);
102 CREATE INDEX player_game_stats_2015q3_ix001 on player_game_stats_2015q3(create_dt);
103 CREATE INDEX player_game_stats_2015q3_ix002 on player_game_stats_2015q3(game_id);
104 CREATE INDEX player_game_stats_2015q3_ix003 on player_game_stats_2015q3(player_id);
106 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2015q4 (
107 CHECK ( create_dt >= DATE '2015-10-01' AND create_dt < DATE '2016-01-01' )
108 ) INHERITS (player_game_stats);
110 CREATE INDEX player_game_stats_2015q4_ix001 on player_game_stats_2015q4(create_dt);
111 CREATE INDEX player_game_stats_2015q4_ix002 on player_game_stats_2015q4(game_id);
112 CREATE INDEX player_game_stats_2015q4_ix003 on player_game_stats_2015q4(player_id);
114 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2016q1 (
115 CHECK ( create_dt >= DATE '2016-01-01' AND create_dt < DATE '2016-04-01' )
116 ) INHERITS (player_game_stats);
118 CREATE INDEX player_game_stats_2016q1_ix001 on player_game_stats_2016q1(create_dt);
119 CREATE INDEX player_game_stats_2016q1_ix002 on player_game_stats_2016q1(game_id);
120 CREATE INDEX player_game_stats_2016q1_ix003 on player_game_stats_2016q1(player_id);
122 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2016q2 (
123 CHECK ( create_dt >= DATE '2016-04-01' AND create_dt < DATE '2016-07-01' )
124 ) INHERITS (player_game_stats);
126 CREATE INDEX player_game_stats_2016q2_ix001 on player_game_stats_2016q2(create_dt);
127 CREATE INDEX player_game_stats_2016q2_ix002 on player_game_stats_2016q2(game_id);
128 CREATE INDEX player_game_stats_2016q2_ix003 on player_game_stats_2016q2(player_id);
130 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2016q3 (
131 CHECK ( create_dt >= DATE '2016-07-01' AND create_dt < DATE '2016-10-01' )
132 ) INHERITS (player_game_stats);
134 CREATE INDEX player_game_stats_2016q3_ix001 on player_game_stats_2016q3(create_dt);
135 CREATE INDEX player_game_stats_2016q3_ix002 on player_game_stats_2016q3(game_id);
136 CREATE INDEX player_game_stats_2016q3_ix003 on player_game_stats_2016q3(player_id);
138 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2016q4 (
139 CHECK ( create_dt >= DATE '2016-10-01' AND create_dt < DATE '2017-01-01' )
140 ) INHERITS (player_game_stats);
142 CREATE INDEX player_game_stats_2016q4_ix001 on player_game_stats_2016q4(create_dt);
143 CREATE INDEX player_game_stats_2016q4_ix002 on player_game_stats_2016q4(game_id);
144 CREATE INDEX player_game_stats_2016q4_ix003 on player_game_stats_2016q4(player_id);
146 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2017q1 (
147 CHECK ( create_dt >= DATE '2017-01-01' AND create_dt < DATE '2017-04-01' )
148 ) INHERITS (player_game_stats);
150 CREATE INDEX player_game_stats_2017q1_ix001 on player_game_stats_2017q1(create_dt);
151 CREATE INDEX player_game_stats_2017q1_ix002 on player_game_stats_2017q1(game_id);
152 CREATE INDEX player_game_stats_2017q1_ix003 on player_game_stats_2017q1(player_id);
154 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2017q2 (
155 CHECK ( create_dt >= DATE '2017-04-01' AND create_dt < DATE '2017-07-01' )
156 ) INHERITS (player_game_stats);
158 CREATE INDEX player_game_stats_2017q2_ix001 on player_game_stats_2017q2(create_dt);
159 CREATE INDEX player_game_stats_2017q2_ix002 on player_game_stats_2017q2(game_id);
160 CREATE INDEX player_game_stats_2017q2_ix003 on player_game_stats_2017q2(player_id);
162 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2017q3 (
163 CHECK ( create_dt >= DATE '2017-07-01' AND create_dt < DATE '2017-10-01' )
164 ) INHERITS (player_game_stats);
166 CREATE INDEX player_game_stats_2017q3_ix001 on player_game_stats_2017q3(create_dt);
167 CREATE INDEX player_game_stats_2017q3_ix002 on player_game_stats_2017q3(game_id);
168 CREATE INDEX player_game_stats_2017q3_ix003 on player_game_stats_2017q3(player_id);
170 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2017q4 (
171 CHECK ( create_dt >= DATE '2017-10-01' AND create_dt < DATE '2018-01-01' )
172 ) INHERITS (player_game_stats);
174 CREATE INDEX player_game_stats_2017q4_ix001 on player_game_stats_2017q4(create_dt);
175 CREATE INDEX player_game_stats_2017q4_ix002 on player_game_stats_2017q4(game_id);
176 CREATE INDEX player_game_stats_2017q4_ix003 on player_game_stats_2017q4(player_id);
178 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2018q1 (
179 CHECK ( create_dt >= DATE '2018-01-01' AND create_dt < DATE '2018-04-01' )
180 ) INHERITS (player_game_stats);
182 CREATE INDEX player_game_stats_2018q1_ix001 on player_game_stats_2018q1(create_dt);
183 CREATE INDEX player_game_stats_2018q1_ix002 on player_game_stats_2018q1(game_id);
184 CREATE INDEX player_game_stats_2018q1_ix003 on player_game_stats_2018q1(player_id);
186 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2018q2 (
187 CHECK ( create_dt >= DATE '2018-04-01' AND create_dt < DATE '2018-07-01' )
188 ) INHERITS (player_game_stats);
190 CREATE INDEX player_game_stats_2018q2_ix001 on player_game_stats_2018q2(create_dt);
191 CREATE INDEX player_game_stats_2018q2_ix002 on player_game_stats_2018q2(game_id);
192 CREATE INDEX player_game_stats_2018q2_ix003 on player_game_stats_2018q2(player_id);
194 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2018q3 (
195 CHECK ( create_dt >= DATE '2018-07-01' AND create_dt < DATE '2018-10-01' )
196 ) INHERITS (player_game_stats);
198 CREATE INDEX player_game_stats_2018q3_ix001 on player_game_stats_2018q3(create_dt);
199 CREATE INDEX player_game_stats_2018q3_ix002 on player_game_stats_2018q3(game_id);
200 CREATE INDEX player_game_stats_2018q3_ix003 on player_game_stats_2018q3(player_id);
202 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2018q4 (
203 CHECK ( create_dt >= DATE '2018-10-01' AND create_dt < DATE '2019-01-01' )
204 ) INHERITS (player_game_stats);
206 CREATE INDEX player_game_stats_2018q4_ix001 on player_game_stats_2018q4(create_dt);
207 CREATE INDEX player_game_stats_2018q4_ix002 on player_game_stats_2018q4(game_id);
208 CREATE INDEX player_game_stats_2018q4_ix003 on player_game_stats_2018q4(player_id);
210 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2019q1 (
211 CHECK ( create_dt >= DATE '2019-01-01' AND create_dt < DATE '2019-04-01' )
212 ) INHERITS (player_game_stats);
214 CREATE INDEX player_game_stats_2019q1_ix001 on player_game_stats_2019q1(create_dt);
215 CREATE INDEX player_game_stats_2019q1_ix002 on player_game_stats_2019q1(game_id);
216 CREATE INDEX player_game_stats_2019q1_ix003 on player_game_stats_2019q1(player_id);
218 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2019q2 (
219 CHECK ( create_dt >= DATE '2019-04-01' AND create_dt < DATE '2019-07-01' )
220 ) INHERITS (player_game_stats);
222 CREATE INDEX player_game_stats_2019q2_ix001 on player_game_stats_2019q2(create_dt);
223 CREATE INDEX player_game_stats_2019q2_ix002 on player_game_stats_2019q2(game_id);
224 CREATE INDEX player_game_stats_2019q2_ix003 on player_game_stats_2019q2(player_id);
226 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2019q3 (
227 CHECK ( create_dt >= DATE '2019-07-01' AND create_dt < DATE '2019-10-01' )
228 ) INHERITS (player_game_stats);
230 CREATE INDEX player_game_stats_2019q3_ix001 on player_game_stats_2019q3(create_dt);
231 CREATE INDEX player_game_stats_2019q3_ix002 on player_game_stats_2019q3(game_id);
232 CREATE INDEX player_game_stats_2019q3_ix003 on player_game_stats_2019q3(player_id);
234 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2019q4 (
235 CHECK ( create_dt >= DATE '2019-10-01' AND create_dt < DATE '2020-01-01' )
236 ) INHERITS (player_game_stats);
238 CREATE INDEX player_game_stats_2019q4_ix001 on player_game_stats_2019q4(create_dt);
239 CREATE INDEX player_game_stats_2019q4_ix002 on player_game_stats_2019q4(game_id);
240 CREATE INDEX player_game_stats_2019q4_ix003 on player_game_stats_2019q4(player_id);
242 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2020q1 (
243 CHECK ( create_dt >= DATE '2020-01-01' AND create_dt < DATE '2020-04-01' )
244 ) INHERITS (player_game_stats);
246 CREATE INDEX player_game_stats_2020q1_ix001 on player_game_stats_2020q1(create_dt);
247 CREATE INDEX player_game_stats_2020q1_ix002 on player_game_stats_2020q1(game_id);
248 CREATE INDEX player_game_stats_2020q1_ix003 on player_game_stats_2020q1(player_id);
250 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2020q2 (
251 CHECK ( create_dt >= DATE '2020-04-01' AND create_dt < DATE '2020-07-01' )
252 ) INHERITS (player_game_stats);
254 CREATE INDEX player_game_stats_2020q2_ix001 on player_game_stats_2020q2(create_dt);
255 CREATE INDEX player_game_stats_2020q2_ix002 on player_game_stats_2020q2(game_id);
256 CREATE INDEX player_game_stats_2020q2_ix003 on player_game_stats_2020q2(player_id);
258 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2020q3 (
259 CHECK ( create_dt >= DATE '2020-07-01' AND create_dt < DATE '2020-10-01' )
260 ) INHERITS (player_game_stats);
262 CREATE INDEX player_game_stats_2020q3_ix001 on player_game_stats_2020q3(create_dt);
263 CREATE INDEX player_game_stats_2020q3_ix002 on player_game_stats_2020q3(game_id);
264 CREATE INDEX player_game_stats_2020q3_ix003 on player_game_stats_2020q3(player_id);
266 CREATE TABLE IF NOT EXISTS xonstat.player_game_stats_2020q4 (
267 CHECK ( create_dt >= DATE '2020-10-01' AND create_dt < DATE '2021-01-01' )
268 ) INHERITS (player_game_stats);
270 CREATE INDEX player_game_stats_2020q4_ix001 on player_game_stats_2020q4(create_dt);
271 CREATE INDEX player_game_stats_2020q4_ix002 on player_game_stats_2020q4(game_id);
272 CREATE INDEX player_game_stats_2020q4_ix003 on player_game_stats_2020q4(player_id);