From 4543c318e20d8fda5729951aadf091310ccfa77c Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Mon, 15 Dec 2014 21:31:00 -0500 Subject: [PATCH] Store a list of player_ids in the games table. --- tables/games.tab | 1 + 1 file changed, 1 insertion(+) diff --git a/tables/games.tab b/tables/games.tab index 06d8079..cf63852 100755 --- a/tables/games.tab +++ b/tables/games.tab @@ -10,6 +10,7 @@ CREATE TABLE xonstat.games match_id character varying(64), mod character varying(64), create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'), + players integer[], CONSTRAINT games_pk PRIMARY KEY (game_id), CONSTRAINT games_fk001 FOREIGN KEY (game_type_cd) REFERENCES xonstat.cd_game_type (game_type_cd) MATCH SIMPLE -- 2.39.2