player_weapon_stats_id bigserial NOT NULL,
player_id integer NOT NULL,
game_id bigint NOT NULL,
- nick character varying(64),
+ player_game_stat_id bigint NOT NULL,
weapon_cd character varying(15) NOT NULL,
actual integer NOT NULL default 0,
max integer NOT NULL default 0,
hit integer NOT NULL default 0,
fired integer NOT NULL default 0,
frags integer NOT NULL default 0,
- create_dt timestamp without time zone NOT NULL DEFAULT now(),
+ create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'),
CONSTRAINT player_weapon_stats_pk PRIMARY KEY (player_weapon_stats_id),
CONSTRAINT player_weapon_stats_fk001 FOREIGN KEY (player_id)
REFERENCES xonstat.players (player_id) MATCH SIMPLE
CONSTRAINT player_weapon_stats_fk003 FOREIGN KEY (weapon_cd)
REFERENCES xonstat.cd_weapon (weapon_cd) MATCH SIMPLE
ON UPDATE NO ACTION ON DELETE NO ACTION,
- CONSTRAINT player_weapon_stats_uk001 UNIQUE (player_id, game_id, weapon_cd, nick)
+ CONSTRAINT player_weapon_stats_fk004 FOREIGN KEY (player_game_stat_id)
+ REFERENCES xonstat.player_game_stats (player_game_stat_id) MATCH SIMPLE
+ ON UPDATE NO ACTION ON DELETE NO ACTION
)
WITH (
OIDS=FALSE