From 171f98dea0ed68b01d9ee59cc1a6962296725375 Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Wed, 27 Apr 2011 21:58:31 -0400 Subject: [PATCH] Fix weapon_cd in child table. --- tables/player_weapon_stats.tab | 12 ++++++------ 1 file changed, 6 insertions(+), 6 deletions(-) diff --git a/tables/player_weapon_stats.tab b/tables/player_weapon_stats.tab index 23d6a64..05474f7 100644 --- a/tables/player_weapon_stats.tab +++ b/tables/player_weapon_stats.tab @@ -3,12 +3,12 @@ CREATE TABLE xonstat.player_weapon_stats player_weapon_stats_id bigserial NOT NULL, player_id integer NOT NULL, game_id bigint NOT NULL, - weapon_cd character varying(3) NOT NULL, - actual integer NOT NULL, - max integer NOT NULL, - hit integer NOT NULL, - fired integer NOT NULL, - frags integer 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(), CONSTRAINT player_weapon_stats_pk PRIMARY KEY (player_weapon_stats_id), CONSTRAINT player_weapon_stats_fk001 FOREIGN KEY (player_id) -- 2.39.2