From 1e0ceb4b7c714430ff42a1c98d416246f035d75f Mon Sep 17 00:00:00 2001 From: Kjetil Orbekk Date: Thu, 13 Oct 2022 08:13:12 -0400 Subject: Add player positions to db --- server/migrations/20221008120534_init.up.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'server/migrations/20221008120534_init.up.sql') diff --git a/server/migrations/20221008120534_init.up.sql b/server/migrations/20221008120534_init.up.sql index 6a46f84..729446c 100644 --- a/server/migrations/20221008120534_init.up.sql +++ b/server/migrations/20221008120534_init.up.sql @@ -19,6 +19,7 @@ create table active_tables ( create table table_players ( active_tables_id uuid not null references active_tables (id), player_id varchar(64) not null references players (id), - primary key(active_tables_id, player_id) + position jsonb, + primary key(active_tables_id, player_id, position) ); create unique index player_table on table_players (player_id); -- cgit v1.2.3