1 CREATE TABLE xonstat.player_agg_stats_mv
3 player_id integer NOT NULL,
4 game_type_cd character varying(10),
5 nick character varying(128),
6 stripped_nick character varying(128),
7 last_seen timestamp without time zone,
17 carrier_frags integer,
19 create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
20 CONSTRAINT player_agg_stats_mv_pk PRIMARY KEY (player_id, game_type_cd)
26 ALTER TABLE xonstat.player_agg_stats_mv OWNER TO xonstat;