summaryrefslogtreecommitdiff
path: root/server/migrations/20221008120534_init.up.sql
diff options
context:
space:
mode:
Diffstat (limited to 'server/migrations/20221008120534_init.up.sql')
-rw-r--r--server/migrations/20221008120534_init.up.sql3
1 files changed, 2 insertions, 1 deletions
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);