1 CREATE TABLE xonstat.player_game_anticheats
\r
3 player_game_anticheat_id bigserial NOT NULL,
\r
4 player_id integer NOT NULL,
\r
5 game_id bigint NOT NULL,
\r
6 key character varying(128),
\r
8 create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
\r
9 CONSTRAINT player_game_anticheats_pk PRIMARY KEY (player_game_anticheat_id),
\r
10 CONSTRAINT player_game_anticheats_fk01 FOREIGN KEY (player_id)
\r
11 REFERENCES players (player_id) MATCH SIMPLE
\r
12 ON UPDATE NO ACTION ON DELETE NO ACTION
\r
18 CREATE INDEX player_game_anticheats_ix01 on player_game_anticheats(game_id);
\r
19 CREATE INDEX player_game_anticheats_ix02 on player_game_anticheats(player_id);
\r
20 ALTER TABLE xonstat.player_game_anticheats OWNER TO xonstat;
\r