From d42559754d4ede6c3b435c9b83b27a22e244b38a Mon Sep 17 00:00:00 2001 From: Ant Zucaro Date: Mon, 16 Oct 2017 20:02:45 -0400 Subject: [PATCH] Use the plain JSON type, not JSONB due to PG9.3. --- tables/player_game_frag_matrix.tab | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/tables/player_game_frag_matrix.tab b/tables/player_game_frag_matrix.tab index fd302dc..cf309cd 100755 --- a/tables/player_game_frag_matrix.tab +++ b/tables/player_game_frag_matrix.tab @@ -4,7 +4,7 @@ CREATE TABLE xonstat.player_game_frag_matrix player_game_stat_id bigint NOT NULL, player_id integer NOT NULL, player_index smallint NOT NULL, - matrix jsonb NOT NULL, + matrix json NOT NULL, create_dt timestamp without time zone NOT NULL DEFAULT (current_timestamp at time zone 'UTC'), CONSTRAINT player_game_frag_matrix_pk PRIMARY KEY (game_id, player_game_stat_id), CONSTRAINT player_game_frag_matrix_fk001 FOREIGN KEY (game_id) -- 2.39.2