From 5e27e549f7351d6b993067ca48cbed4a5f6e043a Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Thu, 1 Dec 2011 12:00:34 -0500 Subject: [PATCH] Add a match_id to each games row. --- tables/games.tab | 1 + 1 file changed, 1 insertion(+) diff --git a/tables/games.tab b/tables/games.tab index fe76771..e26ba1d 100644 --- a/tables/games.tab +++ b/tables/games.tab @@ -7,6 +7,7 @@ CREATE TABLE xonstat.games map_id integer NOT NULL, duration interval, winner integer, + match_id numeric, create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'), CONSTRAINT games_pk PRIMARY KEY (game_id), CONSTRAINT games_fk001 FOREIGN KEY (game_type_cd) -- 2.39.2