From d7ec2c310d4bbab78ba098f3b3160d5816121c9c Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Tue, 27 May 2014 20:32:16 -0400 Subject: [PATCH] Add an anticheat log table. --- build/build_full.sql | 2 ++ tables/player_game_anticheats.tab | 20 ++++++++++++++++++++ 2 files changed, 22 insertions(+) create mode 100755 tables/player_game_anticheats.tab diff --git a/build/build_full.sql b/build/build_full.sql index 708e2cf..6e2bba5 100755 --- a/build/build_full.sql +++ b/build/build_full.sql @@ -1,4 +1,5 @@ -- drop tables first in reverse order +drop table if exists player_game_anticheats; drop table if exists team_game_stats; drop table if exists summary_stats cascade; drop table if exists player_map_captimes; @@ -49,6 +50,7 @@ drop table if exists players cascade; \i tables/player_map_captimes.tab \i tables/summary_stats.tab \i tables/team_game_stats.tab +\i tables/player_game_anticheats.tab begin; diff --git a/tables/player_game_anticheats.tab b/tables/player_game_anticheats.tab new file mode 100755 index 0000000..54967e3 --- /dev/null +++ b/tables/player_game_anticheats.tab @@ -0,0 +1,20 @@ +CREATE TABLE xonstat.player_game_anticheats +( + player_game_anticheat_id bigserial NOT NULL, + player_id integer NOT NULL, + game_id bigint NOT NULL, + key character varying(128), + value numeric, + create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'), + CONSTRAINT player_game_anticheats_pk PRIMARY KEY (player_game_anticheat_id), + CONSTRAINT player_game_anticheats_fk01 FOREIGN KEY (player_id) + REFERENCES players (player_id) MATCH SIMPLE + ON UPDATE NO ACTION ON DELETE NO ACTION +) +WITH ( + OIDS=FALSE +); + +CREATE INDEX player_game_anticheats_ix01 on player_game_anticheats(game_id); +CREATE INDEX player_game_anticheats_ix02 on player_game_anticheats(player_id); +ALTER TABLE xonstat.player_game_anticheats OWNER TO xonstat; -- 2.39.2