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 stat_type character varying(1),
7 nick character varying(64),
21 destroys_holding_key integer,
24 carrier_frags integer,
25 create_dt timestamp without time zone NOT NULL,
26 CONSTRAINT player_game_stats_pk PRIMARY KEY (player_game_stat_id),
27 CONSTRAINT player_game_stats_fk001 FOREIGN KEY (player_id)
28 REFERENCES xonstat.players (player_id) MATCH SIMPLE
29 ON UPDATE NO ACTION ON DELETE NO ACTION,
30 CONSTRAINT player_game_stats_fk002 FOREIGN KEY (game_id)
31 REFERENCES xonstat.games (game_id) MATCH SIMPLE
32 ON UPDATE NO ACTION ON DELETE NO ACTION,
33 CONSTRAINT player_game_stats_uk001 UNIQUE (player_id, game_id, stat_type)
38 ALTER TABLE xonstat.player_game_stats OWNER TO xonstat;