The match_id is now a varchar.

diff --git a/tables/games.tab b/tables/games.tab
index a9a5e5a6bf9de478aca83c09f32922ff07c46da3..15c32869136a14734baad21c7ac1c513b49cceb6 100755 (executable)
--- a/tables/games.tab
+++ b/tables/games.tab
@@ -7,7 +7,7 @@ CREATE TABLE xonstat.games
   map_id integer NOT NULL,
   duration interval,
   winner integer,
   map_id integer NOT NULL,
   duration interval,
   winner integer,

-  match_id numeric,
+  match_id character varying(64),

   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)
   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)